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 |
|---|---|---|---|---|---|---|---|---|
| 15130001150705 | L15/debats | 15 | 15130001150653 | 15130001150704 | 1 | Amendement no 2252 | Amendement n<sup>o</sup><lienAdt id_syceron="1977724"> 2252</lienAdt> | |
| 15130001150707 | L15/debats | 15 | 15130001150653 | 15130001150706 | 1 | Amendements nos 141, 2257, 2460 | Amendements n<sup>os</sup><lienAdt id_syceron="1977728"> 141</lienAdt>, <lienAdt id_syceron="1977730"> 2257</lienAdt>, <lienAdt id_syceron="1977732"> 2460</lien… | |
| 15130001150709 | L15/debats | 15 | 15130001150653 | 15130001150708 | 1 | Amendements nos 943, 790, 1619 | Amendements n<sup>os</sup><lienAdt id_syceron="1977736"> 943</lienAdt>, <lienAdt id_syceron="1977738"> 790</lienAdt>, <lienAdt id_syceron="1977742"> 1619</lienA… | |
| 15130001150711 | L15/debats | 15 | 15130001150653 | 15130001150710 | 1 | Amendements nos 251, 1691 | Amendements n<sup>os</sup><lienAdt id_syceron="1977750"> 251, 1691</lienAdt> | |
| 15130001150713 | L15/debats | 15 | 15130001150653 | 15130001150712 | 1 | Amendements nos 2487, 2251 | Amendements n<sup>os</sup><lienAdt id_syceron="1977753"> 2487</lienAdt>, <lienAdt id_syceron="1977755"> 2251</lienAdt> | |
| 15130001150715 | L15/debats | 15 | 15130001150653 | 15130001150714 | 1 | Amendements nos 211, 203, 2620, 2621, 2622, 2623, 2490 | Amendements n<sup>os</sup><lienAdt id_syceron="1977760"> 211</lienAdt>, <lienAdt id_syceron="1977762"> 203</lienAdt>, <lienAdt id_syceron="1977764"> 2620, 2621,… | |
| 15130001150717 | L15/debats | 15 | 15130001150653 | 15130001150716 | 1 | Amendements nos 1673, 908 | Amendements n<sup>os</sup><lienAdt id_syceron="1977770"> 1673, 908</lienAdt> | |
| 15130001150720 | L15/debats | 15 | 15130001150653 | 15130001150719 | 1 | Amendement no 413 | Amendement n<sup>o</sup><lienAdt id_syceron="1977834"> 413</lienAdt> | |
| 15130001150722 | L15/debats | 15 | 15130001150653 | 15130001150721 | 1 | Amendements nos 2275 rectifié, 2595 (sous-amendement) | Amendements n<sup>os</sup><lienAdt id_syceron="1977838"> 2275 rectifié</lienAdt>, <lienAdt id_syceron="1977840"> 2595 (sous-amendement)</lienAdt> | |
| 15130001150724 | L15/debats | 15 | 15130001150653 | 15130001150723 | 1 | Amendement no 139 | Amendement n<sup>o</sup><lienAdt id_syceron="1977849"> 139</lienAdt> | |
| 15130001150726 | L15/debats | 15 | 15130001150653 | 15130001150725 | 1 | Amendement no 2286 | Amendement n<sup>o</sup><lienAdt id_syceron="1977857"> 2286</lienAdt> | |
| 15130001150728 | L15/debats | 15 | 15130001150653 | 15130001150727 | 1 | Amendement no 2295 | Amendement n<sup>o</sup><lienAdt id_syceron="1977870"> 2295</lienAdt> | |
| 15130001150730 | L15/debats | 15 | 15130001150653 | 15130001150729 | 1 | Amendements nos 212, 2021 | Amendements n<sup>os</sup><lienAdt id_syceron="1977874"> 212</lienAdt>, <lienAdt id_syceron="1977878"> 2021</lienAdt> | |
| 15130001150732 | L15/debats | 15 | 15130001150653 | 15130001150731 | 1 | Amendements nos 1062, 2190, 2191 | Amendements n<sup>os</sup><lienAdt id_syceron="1977882"> 1062</lienAdt>, <lienAdt id_syceron="1977889"> 2190, 2191</lienAdt> | |
| 15130001150734 | L15/debats | 15 | 15130001150653 | 15130001150733 | 1 | Amendements nos 412, 496 | Amendements n<sup>os</sup><lienAdt id_syceron="1977900"> 412</lienAdt>, <lienAdt id_syceron="1977904"> 496</lienAdt> | |
| 15130001150737 | L15/debats | 15 | 15130001150653 | 15130001150736 | 1 | Amendements nos 1063, 1187 | Amendements n<sup>os</sup><lienAdt id_syceron="1977912"> 1063</lienAdt>, <lienAdt id_syceron="1977914"> 1187</lienAdt> | |
| 15130001150740 | L15/debats | 15 | 15130001150653 | 15130001150739 | 1 | Amendement no 422 | Amendement n<sup>o</sup><lienAdt id_syceron="1977934"> 422</lienAdt> | |
| 15130001153544 | L15/debats | 15 | 15130001153539 | 15130001153543 | 1 | Amendements nos 1540, 2298, 2575 (sous-amendement) | Amendements n<sup>os</sup><lienAdt id_syceron="1976064"> 1540</lienAdt>, <lienAdt id_syceron="1976066"> 2298</lienAdt>, <lienAdt id_syceron="1976067"> 2575 (sou… | |
| 15130001153546 | L15/debats | 15 | 15130001153539 | 15130001153545 | 1 | Amendements nos 2294, 2580, 1328 | Amendements n<sup>os</sup><lienAdt id_syceron="1976072"> 2294</lienAdt>, <lienAdt id_syceron="1976074"> 2580</lienAdt>, <lienAdt id_syceron="1976076"> 1328</lie… | |
| 15130001153548 | L15/debats | 15 | 15130001153539 | 15130001153547 | 1 | Amendements nos 2588, 2589 | Amendements n<sup>os</sup><lienAdt id_syceron="1976083"> 2588, 2589</lienAdt> | |
| 15130001153550 | L15/debats | 15 | 15130001153539 | 15130001153549 | 1 | Amendement no 2667 | Amendement n<sup>o</sup><lienAdt id_syceron="1976087"> 2667</lienAdt> | |
| 15130001153551 | L15/debats | 15 | 15130001153539 | 15130001153549 | 2 | Mme Graziella Melchior, rapporteure pour avis de la commission des affaires économiques | 1976088 | |
| 15130001153554 | L15/debats | 15 | 15130001153539 | 15130001153553 | 1 | Amendements nos 145, 144, 403, 1261, 93 | Amendements n<sup>os</sup><lienAdt id_syceron="1976100"> 145</lienAdt>, <lienAdt id_syceron="1976103"> 144</lienAdt>, <lienAdt id_syceron="1976110"> 403</lienAd… | |
| 15130001153555 | L15/debats | 15 | 15130001153539 | 15130001153553 | 2 | Mme Barbara Pompili, présidente de la commission du développement durable et de l’aménagement du territoire | 1976120 | |
| 15130001153556 | L15/debats | 15 | 15130001153539 | 15130001153553 | 3 | Mme Stéphanie Kerbarh, rapporteure de la commission du développement durable et de l’aménagement du territoire | 1976326 | |
| 15130001153557 | L15/debats | 15 | 15130001153539 | 15130001153553 | 4 | Mme Brune Poirson, secrétaire d’État auprès de la ministre de la transition écologique et solidaire | 1976124 | |
| 15130001153558 | L15/debats | 15 | 15130001153539 | 15130001153553 | 5 | Amendements nos 1410, 445, 1070, 217, 67, 111, 297, 1656, 68, 110, 220, 296, 1653, 1274, 218, 2066, 2095, 2241, 563, 558, 546, 560, 557, 564, 567 | Amendements n<sup>os</sup><lienAdt id_syceron="1976128"> 1410</lienAdt>, <lienAdt id_syceron="1976132"> 445</lienAdt>, <lienAdt id_syceron="1976143"> 1070</lien… | |
| 15130001153560 | L15/debats | 15 | 15130001153539 | 15130001153559 | 1 | Amendements nos 182, 1539 | Amendements n<sup>os</sup><lienAdt id_syceron="1976160"> 182, 1539</lienAdt> | |
| 15130001153562 | L15/debats | 15 | 15130001153539 | 15130001153561 | 1 | Amendement no 162 | Amendement n<sup>o</sup><lienAdt id_syceron="1976163"> 162</lienAdt> | |
| 15130001153564 | L15/debats | 15 | 15130001153539 | 15130001153563 | 1 | Amendements nos 1520, 2112, 1521, 2120 | Amendements n<sup>os</sup><lienAdt id_syceron="1976168"> 1520</lienAdt>, <lienAdt id_syceron="1976171"> 2112</lienAdt>, <lienAdt id_syceron="1976173"> 1521</lie… | |
| 15130001153567 | L15/debats | 15 | 15130001153539 | 15130001153566 | 1 | Amendements nos 54, 763, 512, 907 | Amendements n<sup>os</sup><lienAdt id_syceron="1976185"> 54</lienAdt>, <lienAdt id_syceron="1976187"> 763</lienAdt>, <lienAdt id_syceron="1976188"> 512</lienAdt… | |
| 15130001153569 | L15/debats | 15 | 15130001153539 | 15130001153568 | 1 | Amendements nos 1872, 2660, 2661 (sous-amendements) | Amendements n<sup>os</sup><lienAdt id_syceron="1976194"> 1872</lienAdt>, <lienAdt id_syceron="1976197"> 2660, 2661 (sous-amendements)</lienAdt> | |
| 15130001153571 | L15/debats | 15 | 15130001153539 | 15130001153570 | 1 | Amendement no 1204 | Amendement n<sup>o</sup><lienAdt id_syceron="1975871"> 1204</lienAdt> | |
| 15130001153573 | L15/debats | 15 | 15130001153539 | 15130001153572 | 1 | Amendement no 411 | Amendement n<sup>o</sup><lienAdt id_syceron="1975880"> 411</lienAdt> | |
| 15130001153575 | L15/debats | 15 | 15130001153539 | 15130001153574 | 1 | Amendements nos 1072, 607, 2302, 429 | Amendements n<sup>os</sup><lienAdt id_syceron="1975884"> 1072</lienAdt>, <lienAdt id_syceron="1975886"> 607</lienAdt>, <lienAdt id_syceron="1975889"> 2302</lien… | |
| 15130001153577 | L15/debats | 15 | 15130001153539 | 15130001153576 | 1 | Amendements nos 315, 514, 912, 941, 970, 2336, 1629, 1943 | Amendements n<sup>os</sup><lienAdt id_syceron="1975920"> 315</lienAdt>, <lienAdt id_syceron="1975922"> 514</lienAdt>, <lienAdt id_syceron="1975924"> 912, 941</l… | |
| 15130001153579 | L15/debats | 15 | 15130001153539 | 15130001153578 | 1 | Amendement no 2616 | Amendement n<sup>o</sup><lienAdt id_syceron="1975945"> 2616</lienAdt> | |
| 15130001153581 | L15/debats | 15 | 15130001153539 | 15130001153580 | 1 | Amendements nos 2328, 2398 | Amendements n<sup>os</sup><lienAdt id_syceron="1975979"> 2328</lienAdt>, <lienAdt id_syceron="1975984"> 2398</lienAdt> | |
| 15130001153584 | L15/debats | 15 | 15130001153539 | 15130001153583 | 1 | Amendement no 1038 | Amendement n<sup>o</sup><lienAdt id_syceron="1975990"> 1038</lienAdt> | |
| 15130001153586 | L15/debats | 15 | 15130001153539 | 15130001153585 | 1 | Amendements nos 186, 213, 2493 | Amendements n<sup>os</sup><lienAdt id_syceron="1976000"> 186</lienAdt>, <lienAdt id_syceron="1976001"> 213</lienAdt>, <lienAdt id_syceron="1976006"> 2493</lienA… | |
| 15130001153588 | L15/debats | 15 | 15130001153539 | 15130001153587 | 1 | Amendement no 1001 | Amendement n<sup>o</sup><lienAdt id_syceron="1976010"> 1001</lienAdt> | |
| 15130001153590 | L15/debats | 15 | 15130001153539 | 15130001153589 | 1 | Amendements nos 1643, 2399, 2401 | Amendements n<sup>os</sup><lienAdt id_syceron="1976013"> 1643</lienAdt>, <lienAdt id_syceron="1976015"> 2399, 2401</lienAdt> | |
| 15130001153592 | L15/debats | 15 | 15130001153539 | 15130001153591 | 1 | Amendement no 2562 | Amendement n<sup>o</sup><lienAdt id_syceron="1976019"> 2562</lienAdt> | |
| 15130001153594 | L15/debats | 15 | 15130001153539 | 15130001153593 | 1 | Amendement no 2271 | Amendement n<sup>o</sup><lienAdt id_syceron="1976022"> 2271</lienAdt> | |
| 15130001153596 | L15/debats | 15 | 15130001153539 | 15130001153595 | 1 | Amendements nos 2284, 2285 | Amendements n<sup>os</sup><lienAdt id_syceron="1976033"> 2284</lienAdt>, <lienAdt id_syceron="1976207"> 2285</lienAdt> | |
| 15130001153598 | L15/debats | 15 | 15130001153539 | 15130001153597 | 1 | Amendements nos 968, 1798, 2186, 2671 (sous-amendement), 1818, 1802, 610, 1739, 1757 | Amendements n<sup>os</sup><lienAdt id_syceron="1976256"> 968</lienAdt>, <lienAdt id_syceron="1976259"> 1798</lienAdt>, <lienAdt id_syceron="1976277"> 2186</lien… | |
| 15130001153600 | L15/debats | 15 | 15130001153539 | 15130001153599 | 1 | Amendements nos 938, 2507 | Amendements n<sup>os</sup><lienAdt id_syceron="1976318"> 938</lienAdt>, <lienAdt id_syceron="1976332"> 2507</lienAdt> | |
| 15130001153602 | L15/debats | 15 | 15130001153539 | 15130001153601 | 1 | Amendements nos 1513, 1230 | Amendements n<sup>os</sup><lienAdt id_syceron="1976336"> 1513</lienAdt>, <lienAdt id_syceron="1976345"> 1230</lienAdt> | |
| 15130001153605 | L15/debats | 15 | 15130001153539 | 15130001153604 | 1 | Amendements nos 559, 1145, 87, 972, 971 | Amendements n<sup>os</sup><lienAdt id_syceron="1976357"> 559</lienAdt>, <lienAdt id_syceron="1976360"> 1145</lienAdt>, <lienAdt id_syceron="1976362"> 87</lienAd… | |
| 15130001153608 | L15/debats | 15 | 15130001153539 | 15130001153607 | 1 | Amendements nos 1320, 1321 | Amendements n<sup>os</sup><lienAdt id_syceron="1976382"> 1320</lienAdt>, <lienAdt id_syceron="1976394"> 1321</lienAdt> |