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 |
|---|---|---|---|---|---|---|---|---|
| 16130000215548 | L16/debats | 16 | 16130000215530 | 16130000215547 | 1 | M. José Gonzalez | 2938464 | |
| 16130000215568 | L16/debats | 16 | 16130000215530 | 16130000215567 | 1 | Amendements nos 3, 4, 8, 9 | Amendements n<sup>os</sup> <lienAdt id_syceron="2939102"> 3</lienAdt>, <lienAdt id_syceron="2939109"> 4</lienAdt>, <lienAdt id_syceron="2939119"> 8</lienAdt>, <… | |
| 16130000218466 | L16/debats | 16 | 16130000218461 | 16130000218465 | 1 | Amendements nos 12, 16, 17, 18 | Amendements n<sup>os</sup> <lienAdt id_syceron="2940301"> 12</lienAdt>, <lienAdt id_syceron="2940304"> 16, 17, 18</lienAdt> | |
| 16130000218467 | L16/debats | 16 | 16130000218461 | 16130000218465 | 2 | M. Guillaume Kasbarian, rapporteur de la commission des affaires économiques | 2940307 | |
| 16130000218468 | L16/debats | 16 | 16130000218461 | 16130000218465 | 3 | M. Éric Dupond-Moretti, garde des sceaux, ministre de la justice | 2940311 | |
| 16130000218470 | L16/debats | 16 | 16130000218461 | 16130000218469 | 1 | M. William Martinet | 2940325 | |
| 16130000218471 | L16/debats | 16 | 16130000218461 | 16130000218469 | 2 | M. Gérard Leseul | 2940329 | |
| 16130000218472 | L16/debats | 16 | 16130000218461 | 16130000218469 | 3 | Amendement no 85 | Amendement n<sup>o</sup> <lienAdt id_syceron="2940332"> 85</lienAdt> | |
| 16130000218474 | L16/debats | 16 | 16130000218461 | 16130000218473 | 1 | Amendements nos 71, 128 | Amendements n<sup>os</sup> <lienAdt id_syceron="2940645"> 71</lienAdt>, <lienAdt id_syceron="2940782"> 128</lienAdt> | |
| 16130000218476 | L16/debats | 16 | 16130000218461 | 16130000218475 | 1 | Mme Danielle Simonnet | 2940845 | |
| 16130000218478 | L16/debats | 16 | 16130000218461 | 16130000218477 | 1 | Amendement no 175 | Amendement n<sup>o</sup> <lienAdt id_syceron="2940907"> 175</lienAdt> | |
| 16130000218480 | L16/debats | 16 | 16130000218461 | 16130000218479 | 1 | M. William Martinet | 2940933 | |
| 16130000218482 | L16/debats | 16 | 16130000218461 | 16130000218481 | 1 | Amendement no 32 | Amendement n<sup>o</sup> <lienAdt id_syceron="2940938"> 32</lienAdt> | |
| 16130000218484 | L16/debats | 16 | 16130000218461 | 16130000218483 | 1 | M. William Martinet | 2940942 | |
| 16130000218485 | L16/debats | 16 | 16130000218461 | 16130000218483 | 2 | M. Guillaume Kasbarian, rapporteur | 2940948 | |
| 16130000218486 | L16/debats | 16 | 16130000218461 | 16130000218483 | 3 | M. Stéphane Peu | 2940952 | |
| 16130000218487 | L16/debats | 16 | 16130000218461 | 16130000218483 | 4 | Mme Patricia Lemoine | 2940958 | |
| 16130000218489 | L16/debats | 16 | 16130000218461 | 16130000218488 | 1 | M. Gérard Leseul | 2940967 | |
| 16130000218490 | L16/debats | 16 | 16130000218461 | 16130000218488 | 2 | M. François Piquemal | 2941040 | |
| 16130000218491 | L16/debats | 16 | 16130000218461 | 16130000218488 | 3 | M. Charles Sitzenstuhl | 2941046 | |
| 16130000218492 | L16/debats | 16 | 16130000218461 | 16130000218488 | 4 | Amendements nos 78, 87, 182, 127 | Amendements n<sup>os</sup> <lienAdt id_syceron="2941059"> 78</lienAdt>, <lienAdt id_syceron="2941070"> 87</lienAdt>, <lienAdt id_syceron="2941079"> 182</lienAdt… | |
| 16130000218493 | L16/debats | 16 | 16130000218461 | 16130000218488 | 5 | Sous-amendements nos 343, 340, 339, 346, 335 | Sous-amendements n<sup>os</sup> <lienAdt id_syceron="2941317"> 343</lienAdt>, <lienAdt id_syceron="2941323"> 340</lienAdt>, <lienAdt id_syceron="2941337"> 339</… | |
| 16130000218495 | L16/debats | 16 | 16130000218461 | 16130000218494 | 2 | Sous-amendements nos 334, 336, 345, 341, 347, 338, 337, 342, 344 | Sous-amendements n<sup>os</sup> <lienAdt id_syceron="2941428"> 334</lienAdt>, <lienAdt id_syceron="2941433"> 336</lienAdt>, <lienAdt id_syceron="2941438"> 345</… | |
| 16130000218497 | L16/debats | 16 | 16130000218461 | 16130000218496 | 1 | M. William Martinet | 2940999 | |
| 16130000218498 | L16/debats | 16 | 16130000218461 | 16130000218496 | 2 | Mme la présidente | 2941001 | |
| 16130000218501 | L16/debats | 16 | 16130000218461 | 16130000218500 | 1 | Mme Caroline Yadan | 2941027 | |
| 16130000218504 | L16/debats | 16 | 16130000218461 | 16130000218503 | 1 | M. Thomas Portes | 2940850 | |
| 16130000218506 | L16/debats | 16 | 16130000218461 | 16130000218505 | 1 | Amendement no 119 | Amendement n<sup>o</sup> <lienAdt id_syceron="2940858"> 119</lienAdt> | |
| 16130000218507 | L16/debats | 16 | 16130000218461 | 16130000218505 | 2 | Sous-amendements nos 372, 384, 374, 386, 364, 376, 366, 378, 368, 370, 360, 362, 375, 359, 371, 367, 379, 363, 373, 385, 369, 365, 377, 361 | Sous-amendements n<sup>os</sup> <lienAdt id_syceron="2940862"> 372</lienAdt>, <lienAdt id_syceron="2940870"> 384</lienAdt>, <lienAdt id_syceron="2940873"> 374</… | |
| 16130000218508 | L16/debats | 16 | 16130000218461 | 16130000218505 | 3 | Amendements nos 136, 9, 174, 172, 20, 130, 115, 135 | Amendements n<sup>os</sup> <lienAdt id_syceron="2940734"> 136</lienAdt>, <lienAdt id_syceron="2940746"> 9</lienAdt>, <lienAdt id_syceron="2940754"> 174</lienAdt… | |
| 16130000218510 | L16/debats | 16 | 16130000218461 | 16130000218509 | 1 | Amendements nos 126, 86, 116, 117, 123, 152 | Amendements n<sup>os</sup> <lienAdt id_syceron="2941528"> 126</lienAdt>, <lienAdt id_syceron="2941543"> 86</lienAdt>, <lienAdt id_syceron="2941545"> 116</lienAd… | |
| 16130000218512 | L16/debats | 16 | 16130000218461 | 16130000218511 | 1 | M. Charles Sitzenstuhl | 2941610 | |
| 16130000218514 | L16/debats | 16 | 16130000218461 | 16130000218513 | 1 | Amendement no 168 | Amendement n<sup>o</sup> <lienAdt id_syceron="2941616"> 168</lienAdt> | |
| 16130000218516 | L16/debats | 16 | 16130000218461 | 16130000218515 | 1 | M. William Martinet | 2941627 | |
| 16130000218518 | L16/debats | 16 | 16130000218461 | 16130000218517 | 1 | Amendements nos 170, 151 | Amendements n<sup>os</sup> <lienAdt id_syceron="2941632"> 170</lienAdt>, <lienAdt id_syceron="2941735"> 151</lienAdt> | |
| 16130000218520 | L16/debats | 16 | 16130000218461 | 16130000218519 | 1 | M. Charles Sitzenstuhl | 2941754 | |
| 16130000218521 | L16/debats | 16 | 16130000218461 | 16130000218519 | 2 | M. Pierrick Berteloot | 2941760 | |
| 16130000218522 | L16/debats | 16 | 16130000218461 | 16130000218519 | 3 | M. Thomas Portes | 2941765 | |
| 16130000218523 | L16/debats | 16 | 16130000218461 | 16130000218519 | 4 | Amendements nos 90, 109, 186, 67, 177 | Amendements n<sup>os</sup> <lienAdt id_syceron="2941767"> 90</lienAdt>, <lienAdt id_syceron="2941772"> 109</lienAdt>, <lienAdt id_syceron="2941777"> 186</lienAd… | |
| 16130000221110 | L16/debats | 16 | 16130000221075 | 16130000221109 | 1 | Amendement no 1270 | Amendement n<sup>o</sup> <lienAdt id_syceron="2944229"> 1270</lienAdt> | |
| 16130000221112 | L16/debats | 16 | 16130000221075 | 16130000221111 | 1 | Amendement no 1310 | Amendement n<sup>o</sup> <lienAdt id_syceron="2944242"> 1310</lienAdt> | |
| 16130000221114 | L16/debats | 16 | 16130000221075 | 16130000221113 | 1 | Amendements nos 799, 1113, 1140, 1830, 2199, 2783 | Amendements n<sup>os</sup> <lienAdt id_syceron="2944252"> 799</lienAdt>, <lienAdt id_syceron="2944255"> 1113</lienAdt>, <lienAdt id_syceron="2944256"> 1140</lie… | |
| 16130000222058 | L16/debats | 16 | 16130000222053 | 16130000222057 | 1 | Amendement no 2132 rectifié | Amendement n<sup>o</sup> <lienAdt id_syceron="2943710"> 2132 rectifié</lienAdt> | |
| 16130000222059 | L16/debats | 16 | 16130000222053 | 16130000222057 | 2 | M. Pierre Cazeneuve, rapporteur pour avis de la commission du développement durable et de l’aménagement du territoire | 2943711 | |
| 16130000222060 | L16/debats | 16 | 16130000222053 | 16130000222057 | 3 | Mme Agnès Pannier-Runacher, ministre de la transition énergétique | 2943715 | |
| 16130000222062 | L16/debats | 16 | 16130000222053 | 16130000222061 | 1 | Amendements nos 1700, 849, 2397, 2857, 914, 2401, 276, 360, 671, 972, 1314, 2320, 2812, 2910, 2937, 1833, 2967, 1477, 2578, 793, 7, 1327, 2267, 2056, 86, 2398, … | Amendements n<sup>os</sup> <lienAdt id_syceron="2943677"> 1700</lienAdt>, <lienAdt id_syceron="2943697"> 849</lienAdt>, <lienAdt id_syceron="2943699"> 2397</lie… | |
| 16130000222064 | L16/debats | 16 | 16130000222053 | 16130000222063 | 1 | M. Jean-Philippe Tanguy | 2944771 | |
| 16130000222066 | L16/debats | 16 | 16130000222053 | 16130000222065 | 1 | Amendement no 3039 | Amendement n<sup>o</sup> <lienAdt id_syceron="2944810"> 3039</lienAdt> | |
| 16130000222067 | L16/debats | 16 | 16130000222053 | 16130000222065 | 2 | Sous-amendement no 3062 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="2944865"> 3062</lienAdt> | |
| 16130000225592 | L16/debats | 16 | 16130000225587 | 16130000225591 | 1 | Amendements nos 2863, 855, 856, 117, 151, 159, 299, 857, 1414, 2941, 1084, 1271, 1603, 2948, 1090, 180, 561, 1186, 1373, 1517, 2013, 2764 | Amendements n<sup>os</sup> <lienAdt id_syceron="2946827"> 2863</lienAdt>, <lienAdt id_syceron="2946829"> 855</lienAdt>, <lienAdt id_syceron="2946841"> 856</lien… |