debats.compte_rendu_sommaire1_sommaire2_sommaire3_para
Chemin compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para · présence : L17 74 %, L16 74 %, L15 76 %
46 400 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | valeur | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para · présence : L17 74 %, L16 74 %, L15 76 % |
| 8 | id_syceron | BIGINT | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para.@id_syceron · présence : L17 72 %, L16 72 %, L15 74 % |
| 9 | xml | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para.#xml · présence : L17 72 %, L16 71 %, L15 72 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | valeur | id_syceron | xml |
|---|---|---|---|---|---|---|---|---|
| 16130000563506 | L16/debats | 16 | 16130000563480 | 16130000563503 | 3 | Mme Caroline Colombier | 3297591 | |
| 16130000563507 | L16/debats | 16 | 16130000563480 | 16130000563503 | 4 | Amendement no 1216 | Amendement n<sup>o</sup> <lienAdt id_syceron="3297592"> 1216</lienAdt> | |
| 16130000563509 | L16/debats | 16 | 16130000563480 | 16130000563508 | 1 | Mme Martine Etienne | 3297597 | |
| 16130000563510 | L16/debats | 16 | 16130000563480 | 16130000563508 | 2 | M. Jérôme Guedj | 3297609 | |
| 16130000563511 | L16/debats | 16 | 16130000563480 | 16130000563508 | 3 | M. Pierre Dharréville | 3297794 | |
| 16130000563512 | L16/debats | 16 | 16130000563480 | 16130000563508 | 4 | Mme Aurore Bergé, ministre | 3297797 | |
| 16130000563513 | L16/debats | 16 | 16130000563480 | 16130000563508 | 5 | Amendements nos 1217, 1184 rectifié | Amendements n<sup>os</sup> <lienAdt id_syceron="3297802"> 1217</lienAdt>, <lienAdt id_syceron="3297804"> 1184 rectifié</lienAdt> | |
| 16130000563515 | L16/debats | 16 | 16130000563480 | 16130000563514 | 1 | Amendements nos 40, 284 | Amendements n<sup>os</sup> <lienAdt id_syceron="3297818"> 40</lienAdt>, <lienAdt id_syceron="3297821"> 284</lienAdt> | |
| 16130000563517 | L16/debats | 16 | 16130000563480 | 16130000563516 | 1 | M. Jérôme Guedj | 3297834 | |
| 16130000563518 | L16/debats | 16 | 16130000563480 | 16130000563516 | 2 | Amendement no 1172 | Amendement n<sup>o</sup> <lienAdt id_syceron="3297837"> 1172</lienAdt> | |
| 16130000563519 | L16/debats | 16 | 16130000563480 | 16130000563516 | 3 | Mme Annie Vidal, rapporteure de la commission des affaires sociales | 3298036 | |
| 16130000563520 | L16/debats | 16 | 16130000563480 | 16130000563516 | 4 | Amendements nos 1031, 681, 1175, 253, 1200, 391, 204, 205, 661, 1133, 1202, 544, 126, 873 | Amendements n<sup>os</sup> <lienAdt id_syceron="3297844"> 1031</lienAdt>, <lienAdt id_syceron="3298038"> 681</lienAdt>, <lienAdt id_syceron="3298041"> 1175</lie… | |
| 16130000563523 | L16/debats | 16 | 16130000563480 | 16130000563522 | 1 | Amendements nos 1035, 1290, 1037, 1295, 1072, 1291, 1036, 1156, 1292 | Amendements n<sup>os</sup> <lienAdt id_syceron="3298296"> 1035</lienAdt>, <lienAdt id_syceron="3298298"> 1290</lienAdt>, <lienAdt id_syceron="3298307"> 1037</li… | |
| 16130000563524 | L16/debats | 16 | 16130000563480 | 16130000563522 | 2 | Sous-amendement nos 1403, 1399 | Sous-amendement n<sup>os</sup> <lienAdt id_syceron="3298438"> 1403, 1399</lienAdt> | |
| 16130000564654 | L16/debats | 16 | 16130000564553 | 16130000564653 | 1 | Amendements nos 26, 1, 15, 17, 30 | Amendements n<sup>os</sup> <lienAdt id_syceron="3300482"> 26</lienAdt>, <lienAdt id_syceron="3300562"> 1</lienAdt>, <lienAdt id_syceron="3300569"> 15</lienAdt>,… | |
| 16130000566336 | L16/debats | 16 | 16130000566331 | 16130000566335 | 1 | Amendement no 70 | Amendement n<sup>o</sup> <lienAdt id_syceron="3299924"> 70</lienAdt> | |
| 16130000566337 | L16/debats | 16 | 16130000566331 | 16130000566335 | 2 | M. Bruno Millienne, rapporteur de la commission du développement durable et de l’aménagement du territoire | 3299927 | |
| 16130000566338 | L16/debats | 16 | 16130000566331 | 16130000566335 | 3 | M. Clément Beaune, ministre délégué chargé des transports | 3299932 | |
| 16130000566339 | L16/debats | 16 | 16130000566331 | 16130000566335 | 4 | Amendements nos 56, 71, 8, 63, 25, 58, 59, 57, 72 | Amendements n<sup>os</sup> <lienAdt id_syceron="3299868"> 56</lienAdt>, <lienAdt id_syceron="3299891"> 71</lienAdt>, <lienAdt id_syceron="3299893"> 8</lienAdt>,… | |
| 16130000566341 | L16/debats | 16 | 16130000566331 | 16130000566340 | 1 | Amendement no 31 | Amendement n<sup>o</sup> <lienAdt id_syceron="3299745"> 31</lienAdt> | |
| 16130000566343 | L16/debats | 16 | 16130000566331 | 16130000566342 | 1 | Amendements nos 32, 55, 73 | Amendements n<sup>os</sup> <lienAdt id_syceron="3300851"> 32</lienAdt>, <lienAdt id_syceron="3300855"> 55</lienAdt>, <lienAdt id_syceron="3300894"> 73</lienAdt> | |
| 16130000566345 | L16/debats | 16 | 16130000566331 | 16130000566344 | 1 | Amendement no 74 | Amendement n<sup>o</sup> <lienAdt id_syceron="3301225"> 74</lienAdt> | |
| 16130000566347 | L16/debats | 16 | 16130000566331 | 16130000566346 | 1 | Amendements nos 4, 18 | Amendements n<sup>os</sup> <lienAdt id_syceron="3301246"> 4</lienAdt>, <lienAdt id_syceron="3301248"> 18</lienAdt> | |
| 16130000566349 | L16/debats | 16 | 16130000566331 | 16130000566348 | 1 | M. Paul Vannier | 3301276 | |
| 16130000566350 | L16/debats | 16 | 16130000566331 | 16130000566348 | 2 | Amendements nos 20, 7, 62, 6 | Amendements n<sup>os</sup> <lienAdt id_syceron="3301515"> 20</lienAdt>, <lienAdt id_syceron="3301517"> 7</lienAdt>, <lienAdt id_syceron="3301555"> 62</lienAdt>,… | |
| 16130000566352 | L16/debats | 16 | 16130000566331 | 16130000566351 | 1 | Amendements nos 39, 11, 10, 64, 65 | Amendements n<sup>os</sup> <lienAdt id_syceron="3301578"> 39</lienAdt>, <lienAdt id_syceron="3299464"> 11</lienAdt>, <lienAdt id_syceron="3299474"> 10</lienAdt>… | |
| 16130000566354 | L16/debats | 16 | 16130000566331 | 16130000566353 | 1 | Amendements nos 21, 42, 67 | Amendements n<sup>os</sup> <lienAdt id_syceron="3299575"> 21</lienAdt>, <lienAdt id_syceron="3299530"> 42</lienAdt>, <lienAdt id_syceron="3300141"> 67</lienAdt> | |
| 16130000566356 | L16/debats | 16 | 16130000566331 | 16130000566355 | 1 | Amendement no 75 | Amendement n<sup>o</sup> <lienAdt id_syceron="3300180"> 75</lienAdt> | |
| 16130000566358 | L16/debats | 16 | 16130000566331 | 16130000566357 | 1 | Amendements nos 43, 22, 44, 23, 24, 46, 45 | Amendements n<sup>os</sup> <lienAdt id_syceron="3300187"> 43</lienAdt>, <lienAdt id_syceron="3300278"> 22</lienAdt>, <lienAdt id_syceron="3300309"> 44</lienAdt>… | |
| 16130000566360 | L16/debats | 16 | 16130000566331 | 16130000566359 | 1 | Amendements nos 66, 5, 19, 34, 33, 40, 41, 47 | Amendements n<sup>os</sup> <lienAdt id_syceron="3300978"> 66</lienAdt>, <lienAdt id_syceron="3300984"> 5</lienAdt>, <lienAdt id_syceron="3300986"> 19, 34</lienA… | |
| 16130000567849 | L16/debats | 16 | 16130000567824 | 16130000567848 | 1 | M. Pierre Vatin | 3300766 | |
| 16130000567850 | L16/debats | 16 | 16130000567824 | 16130000567848 | 2 | Amendements nos 18, 1, 2, 3, 5, 19, 17 | Amendements n<sup>os</sup> <lienAdt id_syceron="3300770"> 18</lienAdt>, <lienAdt id_syceron="3301280"> 1, 2</lienAdt>, <lienAdt id_syceron="3300807"> 3</lienAdt… | |
| 16130000567852 | L16/debats | 16 | 16130000567824 | 16130000567851 | 1 | Amendements nos 6, 4 | Amendements n<sup>os</sup> <lienAdt id_syceron="3301685"> 6</lienAdt>, <lienAdt id_syceron="3301689"> 4</lienAdt> | |
| 16130000568584 | L16/debats | 16 | 16130000568551 | 16130000568583 | 1 | Amendements nos 1, 93, 160, 180, 205, 256, 52, 173, 51, 177, 50, 175, 49, 176, 48, 178, 47, 174, 186, 185, 183, 187, 188, 181, 54, 179, 53, 184 | Amendements n<sup>os</sup> <lienAdt id_syceron="3302194"> 1</lienAdt>, <lienAdt id_syceron="3302201"> 93</lienAdt>, <lienAdt id_syceron="3302306">160, 180, 205<… | |
| 16130000568588 | L16/debats | 16 | 16130000568551 | 16130000568587 | 1 | Amendements nos 2, 94, 182, 204, 258, 257, 585 | Amendements n<sup>os</sup> <lienAdt id_syceron="3302569"> 2</lienAdt>, <lienAdt id_syceron="3302574"> 94</lienAdt>, <lienAdt id_syceron="3302576"> 182</lienAdt>… | |
| 16130000568590 | L16/debats | 16 | 16130000568551 | 16130000568589 | 1 | Amendements nos 3, 97, 261, 191, 95, 259, 193, 260, 473, 301, 96, 248 | Amendements n<sup>os</sup> <lienAdt id_syceron="3302683"> 3</lienAdt>, <lienAdt id_syceron="3302686"> 97</lienAdt>, <lienAdt id_syceron="3302689"> 261</lienAdt>… | |
| 16130000568592 | L16/debats | 16 | 16130000568551 | 16130000568591 | 1 | Amendements nos 99, 190, 268, 98, 198, 383, 206, 207 | Amendements n<sup>os</sup> <lienAdt id_syceron="3302814"> 99, 190</lienAdt>, <lienAdt id_syceron="3302815"> 268</lienAdt>, <lienAdt id_syceron="3302833"> 98</li… | |
| 16130000568594 | L16/debats | 16 | 16130000568551 | 16130000568593 | 1 | Amendement no 384 | Amendement n<sup>o</sup> <lienAdt id_syceron="3302068"> 384</lienAdt> | |
| 16130000568607 | L16/debats | 16 | 16130000568551 | 16130000568606 | 1 | M. Jérôme Guedj | 3302249 | |
| 16130000568608 | L16/debats | 16 | 16130000568551 | 16130000568606 | 2 | Amendement no 708 | Amendement n<sup>o</sup> <lienAdt id_syceron="3302251">708</lienAdt> | |
| 16130000568609 | L16/debats | 16 | 16130000568551 | 16130000568606 | 3 | Mme Laurence Cristol, rapporteure de la commission des affaires sociales | 3302343 | |
| 16130000568610 | L16/debats | 16 | 16130000568551 | 16130000568606 | 4 | Mme Aurore Bergé, ministre des solidarités et des familles | 3302265 | |
| 16130000568612 | L16/debats | 16 | 16130000568551 | 16130000568611 | 1 | Amendements nos 489, 913, 1329, 1146, 1336, 1337, 714, 1153, 1282, 1324, 1333, 1236, 555, 705, 547 | Amendements n<sup>os</sup> <lienAdt id_syceron="3302273">489</lienAdt>, <lienAdt id_syceron="3302277">913</lienAdt>, <lienAdt id_syceron="3302281">1329</lienAdt… | |
| 16130000568615 | L16/debats | 16 | 16130000568551 | 16130000568614 | 1 | Amendement no 1218 | Amendement n<sup>o</sup> <lienAdt id_syceron="3302709"> 1218</lienAdt> | |
| 16130000568617 | L16/debats | 16 | 16130000568551 | 16130000568616 | 1 | M. Jérôme Guedj | 3302523 | |
| 16130000568618 | L16/debats | 16 | 16130000568551 | 16130000568616 | 2 | Amendement no 1219 | Amendement n<sup>o</sup> <lienAdt id_syceron="3302712"> 1219</lienAdt> | |
| 16130000568620 | L16/debats | 16 | 16130000568551 | 16130000568619 | 1 | Amendements nos 1266, 1150, 655, 656, 657, 658, 659, 660, 1222, 313, 882, 884, 944, 943, 746, 822, 949, 950, 951, 952, 1116, 1223, 1343 | Amendements n<sup>os</sup> <lienAdt id_syceron="3302531"> 1266</lienAdt>, <lienAdt id_syceron="3302539"> 1150</lienAdt>, <lienAdt id_syceron="3302542"> 655</lie… | |
| 16130000568622 | L16/debats | 16 | 16130000568551 | 16130000568621 | 1 | M. Jérôme Guedj | 3302844 | |
| 16130000568623 | L16/debats | 16 | 16130000568551 | 16130000568621 | 2 | Amendement no 989 | Amendement n<sup>o</sup> <lienAdt id_syceron="3302845"> 989</lienAdt> | |
| 16130000568625 | L16/debats | 16 | 16130000568551 | 16130000568624 | 1 | Amendements nos 4, 1041, 942, 953, 955, 960, 893, 874 | Amendements n<sup>os</sup> <lienAdt id_syceron="3302866"> 4</lienAdt>, <lienAdt id_syceron="3302875"> 1041</lienAdt>, <lienAdt id_syceron="3302879"> 942</lienAd… |