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 |
|---|---|---|---|---|---|---|---|---|
| 16130000233801 | L16/debats | 16 | 16130000233770 | 16130000233800 | 1 | Amendements nos 2438, 2439, 2436 | Amendements n<sup>os</sup> <lienAdt id_syceron="2954552"> 2438, 2439</lienAdt>, <lienAdt id_syceron="2954561"> 2436</lienAdt> | |
| 16130000233803 | L16/debats | 16 | 16130000233770 | 16130000233802 | 1 | Amendements nos 1799 | Amendements n<sup>os</sup> <lienAdt id_syceron="2954566"> 1799</lienAdt> | |
| 16130000233804 | L16/debats | 16 | 16130000233770 | 16130000233802 | 2 | Sous-amendement nos 3067, 3068 | Sous-amendement n<sup>os</sup> <lienAdt id_syceron="2954574"> 3067, 3068</lienAdt> | |
| 16130000233806 | L16/debats | 16 | 16130000233770 | 16130000233805 | 1 | Amendements nos 2373, 2207, 2597, 1488, 2410, 205, 696, 2216, 2208 | Amendements n<sup>os</sup> <lienAdt id_syceron="2954666"> 2373</lienAdt>, <lienAdt id_syceron="2954668"> 2207</lienAdt>, <lienAdt id_syceron="2954670"> 2597</li… | |
| 16130000233808 | L16/debats | 16 | 16130000233770 | 16130000233807 | 1 | Amendements nos 1929, 1275, 1276, 1277, 1278, 1280, 1279 | Amendements n<sup>os</sup> <lienAdt id_syceron="2954703"> 1929</lienAdt>, <lienAdt id_syceron="2954705"> 1275</lienAdt>, <lienAdt id_syceron="2954707"> 1276</li… | |
| 16130000233810 | L16/debats | 16 | 16130000233770 | 16130000233809 | 1 | Amendements nos 1070, 2043, 199, 515, 1306, 1550, 2036, 2368, 164, 1692 rectifié, 571 | Amendements n<sup>os</sup> <lienAdt id_syceron="2954904"> 1070</lienAdt>, <lienAdt id_syceron="2954905"> 2043</lienAdt>, <lienAdt id_syceron="2954912"> 199</lie… | |
| 16130000233812 | L16/debats | 16 | 16130000233770 | 16130000233811 | 1 | Amendements nos 1132, 237, 1739, 750, 1400 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955362"> 1132</lienAdt>, <lienAdt id_syceron="2955364"> 237, 1739</lienAdt>, <lienAdt id_syceron="2955533"> 750… | |
| 16130000233814 | L16/debats | 16 | 16130000233770 | 16130000233813 | 1 | Amendements nos 2044, 1669, 2014 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955370"> 2044</lienAdt>, <lienAdt id_syceron="2955384"> 1669</lienAdt>, <lienAdt id_syceron="2955387"> 2014</li… | |
| 16130000233816 | L16/debats | 16 | 16130000233770 | 16130000233815 | 1 | Amendements nos 1489, 2009, 2235, 2413 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955551"> 1489</lienAdt>, <lienAdt id_syceron="2955553"> 2009</lienAdt>, <lienAdt id_syceron="2955554"> 2235</li… | |
| 16130000233819 | L16/debats | 16 | 16130000233770 | 16130000233818 | 1 | Amendements nos 1026, 382, 2703 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955835"> 1026</lienAdt>, <lienAdt id_syceron="2955837"> 382</lienAdt>, <lienAdt id_syceron="2955839"> 2703</lie… | |
| 16130000235483 | L16/debats | 16 | 16130000235477 | 16130000235482 | 1 | Amendement no 1404 | Amendement n<sup>o</sup> <lienAdt id_syceron="2954728"> 1404</lienAdt> | |
| 16130000235484 | L16/debats | 16 | 16130000235477 | 16130000235482 | 2 | M. Pierre Cazeneuve, rapporteur pour avis de la commission du développement durable et de l’aménagement du territoire | 2954730 | |
| 16130000235485 | L16/debats | 16 | 16130000235477 | 16130000235482 | 3 | Mme Agnès Pannier-Runacher, ministre de la transition énergétique | 2954732 | |
| 16130000235486 | L16/debats | 16 | 16130000235477 | 16130000235482 | 4 | Amendements nos 1118, 2414, 1415 | Amendements n<sup>os</sup> <lienAdt id_syceron="2954734"> 1118</lienAdt>, <lienAdt id_syceron="2954736"> 2414</lienAdt>, <lienAdt id_syceron="2954742"> 1415</li… | |
| 16130000235488 | L16/debats | 16 | 16130000235477 | 16130000235487 | 1 | Amendement no 2415 | Amendement n<sup>o</sup> <lienAdt id_syceron="2954750"> 2415</lienAdt> | |
| 16130000235491 | L16/debats | 16 | 16130000235477 | 16130000235490 | 1 | Mme Clémence Guetté | 2954761 | |
| 16130000235492 | L16/debats | 16 | 16130000235477 | 16130000235490 | 2 | Mme la présidente | 2954766 | |
| 16130000235494 | L16/debats | 16 | 16130000235477 | 16130000235493 | 1 | Amendements nos 227, 2730, 2062 | Amendements n<sup>os</sup> <lienAdt id_syceron="2954770"> 227</lienAdt>, <lienAdt id_syceron="2954772"> 2730</lienAdt>, <lienAdt id_syceron="2954953"> 2062</lie… | |
| 16130000235495 | L16/debats | 16 | 16130000235477 | 16130000235493 | 2 | Sous-amendement nos 3102, 3080, 3079 | Sous-amendement n<sup>os</sup> <lienAdt id_syceron="2954954"> 3102, 3080, 3079</lienAdt> | |
| 16130000235497 | L16/debats | 16 | 16130000235477 | 16130000235496 | 1 | Amendement no 2442 | Amendement n<sup>o</sup> <lienAdt id_syceron="2954964"> 2442</lienAdt> | |
| 16130000235500 | L16/debats | 16 | 16130000235477 | 16130000235499 | 1 | Amendement no 2849 | Amendement n<sup>o</sup> <lienAdt id_syceron="2954983"> 2849</lienAdt> | |
| 16130000235502 | L16/debats | 16 | 16130000235477 | 16130000235501 | 1 | Amendements nos 2832, 2593, 2831, 1926, 2047, 2856, 2951, 2594, 747 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955007"> 2832</lienAdt>, <lienAdt id_syceron="2955010"> 2593</lienAdt>, <lienAdt id_syceron="2955016"> 2831</li… | |
| 16130000235504 | L16/debats | 16 | 16130000235477 | 16130000235503 | 1 | Amendements nos 1491, 1945, 2443, 830, 2444 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955712"> 1491</lienAdt>, <lienAdt id_syceron="2955718"> 1945</lienAdt>, <lienAdt id_syceron="2955735"> 2443</li… | |
| 16130000235506 | L16/debats | 16 | 16130000235477 | 16130000235505 | 1 | Amendements nos 961, 2741 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955498"> 961</lienAdt>, <lienAdt id_syceron="2955507"> 2741</lienAdt> | |
| 16130000235508 | L16/debats | 16 | 16130000235477 | 16130000235507 | 1 | Amendement no 2717 | Amendement n<sup>o</sup> <lienAdt id_syceron="2955517"> 2717</lienAdt> | |
| 16130000235509 | L16/debats | 16 | 16130000235477 | 16130000235507 | 2 | M. Henri Alfandari, rapporteur de la commission des affaires économiques | 2955521 | |
| 16130000235511 | L16/debats | 16 | 16130000235477 | 16130000235510 | 1 | Amendements nos 2445, 2682 rectifié, 1606, 1379, 1067, 1068, 1079, 1080, 1172, 1081, 1970, 1971, 1082, 1170, 991, 1972, 1194 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955527"> 2445</lienAdt>, <lienAdt id_syceron="2956095"> 2682 rectifié</lienAdt>, <lienAdt id_syceron="2956121">… | |
| 16130000235513 | L16/debats | 16 | 16130000235477 | 16130000235512 | 1 | Amendements nos 992, 2118, 2117, 1894, 1203 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955405"> 992</lienAdt>, <lienAdt id_syceron="2955410"> 2118, 2117</lienAdt>, <lienAdt id_syceron="2955419"> 189… | |
| 16130000235515 | L16/debats | 16 | 16130000235477 | 16130000235514 | 1 | Amendements nos 1205, 3047, 1206, 1896, 1263, 1266, 2718, 1267 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955426"> 1205</lienAdt>, <lienAdt id_syceron="2955428"> 3047</lienAdt>, <lienAdt id_syceron="2955430"> 1206, 18… | |
| 16130000235517 | L16/debats | 16 | 16130000235477 | 16130000235516 | 1 | Amendements nos 582, 2048, 192, 2028 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955439"> 582</lienAdt>, <lienAdt id_syceron="2955454"> 2048</lienAdt>, <lienAdt id_syceron="2955462"> 192</lien… | |
| 16130000235519 | L16/debats | 16 | 16130000235477 | 16130000235518 | 1 | Amendement no 2719 | Amendement n<sup>o</sup> <lienAdt id_syceron="2955470"> 2719</lienAdt> | |
| 16130000235521 | L16/debats | 16 | 16130000235477 | 16130000235520 | 1 | Amendement no 1210 | Amendement n<sup>o</sup> <lienAdt id_syceron="2955475"> 1210</lienAdt> | |
| 16130000235523 | L16/debats | 16 | 16130000235477 | 16130000235522 | 1 | Amendements nos 2206, 1313 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955479"> 2206, 1313</lienAdt> | |
| 16130000235525 | L16/debats | 16 | 16130000235477 | 16130000235524 | 1 | Amendements nos 337, 2607, 1030 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955577"> 337</lienAdt>, <lienAdt id_syceron="2955579"> 2607</lienAdt>, <lienAdt id_syceron="2955590"> 1030</lie… | |
| 16130000235527 | L16/debats | 16 | 16130000235477 | 16130000235526 | 1 | Amendements nos 55, 311, 732, 2312, 2775 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955597"> 55, 311, 732, 2312</lienAdt>, <lienAdt id_syceron="2955598"> 2775</lienAdt> | |
| 16130000235529 | L16/debats | 16 | 16130000235477 | 16130000235528 | 1 | Amendements nos 239, 238, 829 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955608">239, 238, 829</lienAdt> | |
| 16130000235530 | L16/debats | 16 | 16130000235477 | 16130000235528 | 2 | Mme Aude Luquet, rapporteure pour avis de la commission du développement durable et de l’aménagement du territoire | 2955610 | |
| 16130000235532 | L16/debats | 16 | 16130000235477 | 16130000235531 | 1 | Amendements nos 1865, 525, 782, 1696, 2039, 2613, 710, 919, 526, 1697 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955613"> 1865</lienAdt>, <lienAdt id_syceron="2955617"> 525</lienAdt>, <lienAdt id_syceron="2955619"> 782</lien… | |
| 16130000235533 | L16/debats | 16 | 16130000235477 | 16130000235531 | 2 | M. Éric Bothorel, rapporteur de la commission des affaires économiques | 2955804 | |
| 16130000235534 | L16/debats | 16 | 16130000235477 | 16130000235531 | 3 | Amendements nos 1587, 2687, 1101, 2892, 1790, 2446, 875 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955775"> 1587</lienAdt>, <lienAdt id_syceron="2955777"> 2687</lienAdt>, <lienAdt id_syceron="2955786"> 1101</li… | |
| 16130000235536 | L16/debats | 16 | 16130000235477 | 16130000235535 | 1 | Amendement no 1784, deuxième rectification | Amendement n<sup>o</sup> <lienAdt id_syceron="2955904"> 1784, deuxième rectification</lienAdt> | |
| 16130000235537 | L16/debats | 16 | 16130000235477 | 16130000235535 | 2 | Sous-amendement no 3168 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="2955906"> 3168</lienAdt> | |
| 16130000235539 | L16/debats | 16 | 16130000235477 | 16130000235538 | 1 | Amendements nos 2449, 2452, 2920, 116, 927, 1317, 2451, 2787, 2588, 2450, 2589, 2448 | Amendements n<sup>os</sup> <lienAdt id_syceron="2955914"> 2449</lienAdt>, <lienAdt id_syceron="2955916">2452, 2920</lienAdt>, <lienAdt id_syceron="2955921"> 116… | |
| 16130000235541 | L16/debats | 16 | 16130000235477 | 16130000235540 | 1 | Amendement no 1062 | Amendement n<sup>o</sup> <lienAdt id_syceron="2956051"> 1062</lienAdt> | |
| 16130000235543 | L16/debats | 16 | 16130000235477 | 16130000235542 | 1 | Amendements nos 743, 2893, 1785, 3032, 2301, 58, 876, 663, 2839, 1947, 1953, 1959, 2894, 2226, 1966, 2000, 2895, 432, 2040, 719, 2306, 1457, 433, 994, 1974, 170… | Amendements n<sup>os</sup> <lienAdt id_syceron="2956054"> 743</lienAdt>, <lienAdt id_syceron="2956056"> 2893</lienAdt>, <lienAdt id_syceron="2956069"> 1785</lie… | |
| 16130000235545 | L16/debats | 16 | 16130000235477 | 16130000235544 | 1 | Amendements nos 341, 921, 2217, 2845, 2984, 2686, 340, 920, 2202, 2844, 2982, 1249, 1323, 1268, 1710 | Amendements n<sup>os</sup> <lienAdt id_syceron="2956236"> 341</lienAdt>, <lienAdt id_syceron="2956238"> 921</lienAdt>, <lienAdt id_syceron="2956240"> 2217</lien… | |
| 16130000235547 | L16/debats | 16 | 16130000235477 | 16130000235546 | 1 | Amendements nos 745, 1702, 2456, 2455, 2454 | Amendements n<sup>os</sup> <lienAdt id_syceron="2956871"> 745, 1702</lienAdt>, <lienAdt id_syceron="2956874"> 2456</lienAdt>, <lienAdt id_syceron="2956788"> 245… | |
| 16130000235549 | L16/debats | 16 | 16130000235477 | 16130000235548 | 1 | Amendements nos 2969, 1251, 1866, 2022 | Amendements n<sup>os</sup> <lienAdt id_syceron="2956796"> 2969, 1251</lienAdt>, <lienAdt id_syceron="2956798"> 1866</lienAdt>, <lienAdt id_syceron="2956799"> 20… | |
| 16130000235551 | L16/debats | 16 | 16130000235477 | 16130000235550 | 1 | Mme Aurélie Trouvé | 2956809 | |
| 16130000235552 | L16/debats | 16 | 16130000235477 | 16130000235550 | 2 | Amendements nos 1568, 1102, 998, 2049 rectifié, 347, 1180, 2025, 2854, 766, 139, 196, 230, 334, 231, 2788, 232, 233, 2467, 895, 2466, 897, 2769, 2896, 2457 | Amendements n<sup>os</sup> <lienAdt id_syceron="2956812"> 1568</lienAdt>, <lienAdt id_syceron="2956826"> 1102</lienAdt>, <lienAdt id_syceron="2956828"> 998</lie… |