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 |
|---|---|---|---|---|---|---|---|---|
| 15130000410468 | L15/debats | 15 | 15130000410415 | 15130000410467 | 1 | M. Marc Le Fur | 1269940 | |
| 15130000410470 | L15/debats | 15 | 15130000410415 | 15130000410469 | 1 | Amendement no414 | Amendement n<sup>o</sup><lienAdt id_syceron="1270451">414</lienAdt> | |
| 15130000410471 | L15/debats | 15 | 15130000410415 | 15130000410469 | 2 | M. Jean-Baptiste Moreau, rapporteur de la commission des affaires économiques | 1270455 | |
| 15130000410472 | L15/debats | 15 | 15130000410415 | 15130000410469 | 3 | M. Stéphane Travert, ministre de l’agriculture et de l’alimentation | 1270461 | |
| 15130000410473 | L15/debats | 15 | 15130000410415 | 15130000410469 | 4 | Amendements nos152, 411, 537, 592, 668, 746, 2386, 2406, 700 | Amendements n<sup>os</sup><lienAdt id_syceron="1270471">152</lienAdt>, <lienAdt id_syceron="1270473">411</lienAdt>, <lienAdt id_syceron="1270475">537</lienAdt>,… | |
| 15130000410475 | L15/debats | 15 | 15130000410415 | 15130000410474 | 1 | M. André Chassaigne | 1270501 | |
| 15130000410477 | L15/debats | 15 | 15130000410415 | 15130000410476 | 1 | Amendements nos710, 751, 852, 889, 909, 972, 1144, 1188, 1590, 1809, 2213, 2559, 1655, 2127, 669, 1026, 1994, 594, 1162, 2712 (sous-amendement), 1, 1279, 349, 3… | Amendements n<sup>os</sup><lienAdt id_syceron="1270506">710</lienAdt>, <lienAdt id_syceron="1270508">751</lienAdt>, <lienAdt id_syceron="1270700">852</lienAdt>,… | |
| 15130000410478 | L15/debats | 15 | 15130000410415 | 15130000410476 | 2 | Amendement no1998 | Amendement n<sup>o</sup><lienAdt id_syceron="1270981">1998</lienAdt> | |
| 15130000410479 | L15/debats | 15 | 15130000410415 | 15130000410476 | 3 | Amendements nos21, 287, 538, 596, 665, 753, 1402, 1281, 155, 268, 1029, 232, 148, 233, 267, 1282, 1061, 582, 210, 435, 301, 1667, 2001, 302, 706, 2697 (sous-ame… | Amendements n<sup>os</sup><lienAdt id_syceron="1270995">21</lienAdt>, <lienAdt id_syceron="1270997">287</lienAdt>, <lienAdt id_syceron="1270999">538</lienAdt>, … | |
| 15130000412486 | L15/debats | 15 | 15130000412481 | 15130000412485 | 1 | Amendement no1658 | Amendement n<sup>o</sup><lienAdt id_syceron="1270295">1658</lienAdt> | |
| 15130000412489 | L15/debats | 15 | 15130000412481 | 15130000412488 | 1 | M. Fabien Di Filippo | 1270402 | |
| 15130000412490 | L15/debats | 15 | 15130000412481 | 15130000412488 | 2 | Mme Valérie Rabault | 1270408 | |
| 15130000412491 | L15/debats | 15 | 15130000412481 | 15130000412488 | 3 | M. Sébastien Jumel | 1270414 | |
| 15130000412493 | L15/debats | 15 | 15130000412481 | 15130000412492 | 1 | M. Jean-Baptiste Moreau, rapporteur de la commission des affaires économiques | 1270418 | |
| 15130000412494 | L15/debats | 15 | 15130000412481 | 15130000412492 | 2 | M. Stéphane Travert, ministre de l’agriculture et de l’alimentation | 1270420 | |
| 15130000412496 | L15/debats | 15 | 15130000412481 | 15130000412495 | 1 | M. Aurélien Pradié | 1270425 | |
| 15130000412497 | L15/debats | 15 | 15130000412481 | 15130000412495 | 2 | Mme la présidente | 1270427 | |
| 15130000412498 | L15/debats | 15 | 15130000412481 | 15130000412495 | 3 | Mme Valérie Rabault | 1270443 | |
| 15130000412500 | L15/debats | 15 | 15130000412481 | 15130000412499 | 1 | Mme la présidente | 1270514 | |
| 15130000412501 | L15/debats | 15 | 15130000412481 | 15130000412499 | 2 | M. Aurélien Pradié | 1270519 | |
| 15130000412502 | L15/debats | 15 | 15130000412481 | 15130000412499 | 3 | Mme la présidente | 1270521 | |
| 15130000412503 | L15/debats | 15 | 15130000412481 | 15130000412499 | 4 | M. Arnaud Viala | 1270526 | |
| 15130000412505 | L15/debats | 15 | 15130000412481 | 15130000412504 | 1 | M. Jérôme Nury | 1271318 | |
| 15130000412506 | L15/debats | 15 | 15130000412481 | 15130000412504 | 2 | Mme la présidente | 1271321 | |
| 15130000412508 | L15/debats | 15 | 15130000412481 | 15130000412507 | 1 | Amendements nos2279, 2415, 304, 1999, 707, 2184, 137, 234, 2237, 385, 1892, 1189, 1879, 1420, 2187 | Amendements n<sup>os</sup><lienAdt id_syceron="1271324">2279</lienAdt>, <lienAdt id_syceron="1271327">2415</lienAdt>, <lienAdt id_syceron="1271336">304</lienAdt… | |
| 15130000412509 | L15/debats | 15 | 15130000412481 | 15130000412507 | 2 | M. Roland Lescure, président de la commission des affaires économiques | 1271843 | |
| 15130000412510 | L15/debats | 15 | 15130000412481 | 15130000412507 | 3 | Amendements nos2188, 1778, 1656, 2239, 408, 409, 1553, 1165, 1719, 716, 762, 898, 916, 926, 978, 1016, 1059, 1065, 1203, 1593, 1825, 2565, 2542, 2656, 1166, 181… | Amendements n<sup>os</sup><lienAdt id_syceron="1271859">2188</lienAdt>, <lienAdt id_syceron="1271227">1778</lienAdt>, <lienAdt id_syceron="1271236">1656</lienAd… | |
| 15130000412512 | L15/debats | 15 | 15130000412481 | 15130000412511 | 1 | Amendements nos1544, 2409, 159, 236, 601, 768, 1032, 2647, 97, 1631, 457, 602, 769, 923, 1779, 526, 675, 1219, 1246, 1641, 1873, 1932, 417, 2367, 22, 603, 771, … | Amendements n<sup>os</sup><lienAdt id_syceron="1271599">1544</lienAdt>, <lienAdt id_syceron="1271751">2409</lienAdt>, <lienAdt id_syceron="1271754">159</lienAdt… | |
| 15130000414120 | L15/debats | 15 | 15130000414094 | 15130000414119 | 1 | M. Laurent Furst | 1272879 | |
| 15130000414121 | L15/debats | 15 | 15130000414094 | 15130000414119 | 2 | M. Philippe Gosselin | 1272692 | |
| 15130000414122 | L15/debats | 15 | 15130000414094 | 15130000414119 | 3 | M. Raphaël Schellenberger | 1272698 | |
| 15130000414123 | L15/debats | 15 | 15130000414094 | 15130000414119 | 4 | Amendement no24 | Amendement n<sup>o</sup><lienAdt id_syceron="1272704">24</lienAdt> | |
| 15130000414125 | L15/debats | 15 | 15130000414094 | 15130000414124 | 1 | Amendements nos27, 1, 31, 32, 21, 25 | Amendements n<sup>os</sup><lienAdt id_syceron="1272727">27</lienAdt>, <lienAdt id_syceron="1272733">1</lienAdt>, <lienAdt id_syceron="1272735">31</lienAdt>, <li… | |
| 15130000414127 | L15/debats | 15 | 15130000414094 | 15130000414126 | 1 | M. Laurent Furst | 1272767 | |
| 15130000414128 | L15/debats | 15 | 15130000414094 | 15130000414126 | 2 | Amendements nos2, 20, 23 | Amendements n<sup>os</sup><lienAdt id_syceron="1272771">2</lienAdt>, <lienAdt id_syceron="1272774">20</lienAdt>, <lienAdt id_syceron="1272789">23</lienAdt> | |
| 15130000414130 | L15/debats | 15 | 15130000414094 | 15130000414129 | 1 | Amendement no3 | Amendement n<sup>o</sup><lienAdt id_syceron="1272797">3</lienAdt> | |
| 15130000414132 | L15/debats | 15 | 15130000414094 | 15130000414131 | 1 | Amendement no22 | Amendement n<sup>o</sup><lienAdt id_syceron="1272802">22</lienAdt> | |
| 15130000414135 | L15/debats | 15 | 15130000414094 | 15130000414134 | 1 | M. Raphaël Schellenberger | 1272902 | |
| 15130000414138 | L15/debats | 15 | 15130000414094 | 15130000414137 | 1 | Amendement no4 | Amendement n<sup>o</sup><lienAdt id_syceron="1272907">4</lienAdt> | |
| 15130000414141 | L15/debats | 15 | 15130000414094 | 15130000414140 | 1 | Amendement no5 | Amendement n<sup>o</sup><lienAdt id_syceron="1272914">5</lienAdt> | |
| 15130000414144 | L15/debats | 15 | 15130000414094 | 15130000414143 | 1 | Amendement no6 | Amendement n<sup>o</sup><lienAdt id_syceron="1272921">6</lienAdt> | |
| 15130000414147 | L15/debats | 15 | 15130000414094 | 15130000414146 | 1 | Amendement no28 | Amendement n<sup>o</sup><lienAdt id_syceron="1272928">28</lienAdt> | |
| 15130000414150 | L15/debats | 15 | 15130000414094 | 15130000414149 | 1 | Amendement no7 | Amendement n<sup>o</sup><lienAdt id_syceron="1272947">7</lienAdt> | |
| 15130000414160 | L15/debats | 15 | 15130000414094 | 15130000414159 | 1 | Amendement no8 | Amendement n<sup>o</sup><lienAdt id_syceron="1272118">8</lienAdt> | |
| 15130000414163 | L15/debats | 15 | 15130000414094 | 15130000414162 | 1 | Amendement no29 | Amendement n<sup>o</sup><lienAdt id_syceron="1272134">29</lienAdt> | |
| 15130000414166 | L15/debats | 15 | 15130000414094 | 15130000414165 | 1 | Amendement no19 | Amendement n<sup>o</sup><lienAdt id_syceron="1272163">19</lienAdt> | |
| 15130000414169 | L15/debats | 15 | 15130000414094 | 15130000414168 | 1 | Amendement no10 | Amendement n<sup>o</sup><lienAdt id_syceron="1272188">10</lienAdt> | |
| 15130000414172 | L15/debats | 15 | 15130000414094 | 15130000414171 | 1 | Amendements nos18, 11, 30, 33 (sous-amendement) | Amendements n<sup>os</sup><lienAdt id_syceron="1272217">18, 11</lienAdt>, <lienAdt id_syceron="1272220">30</lienAdt>, <lienAdt id_syceron="1272222">33 (sous-ame… | |
| 15130000414174 | L15/debats | 15 | 15130000414094 | 15130000414173 | 1 | Amendement no14 | Amendement n<sup>o</sup><lienAdt id_syceron="1272230">14</lienAdt> | |
| 15130000414176 | L15/debats | 15 | 15130000414094 | 15130000414175 | 1 | Amendement no15 | Amendement n<sup>o</sup><lienAdt id_syceron="1272420">15</lienAdt> |