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 |
|---|---|---|---|---|---|---|---|---|
| 15130001133396 | L15/debats | 15 | 15130001133351 | 15130001133395 | 1 | Amendement no 2249 | Amendement n<sup>o</sup><lienAdt id_syceron="1963338"> 2249</lienAdt> | |
| 15130001133398 | L15/debats | 15 | 15130001133351 | 15130001133397 | 1 | Amendements nos 1194, 51, 1043, 179, 328, 2136, 2533, 2070 | Amendements n<sup>os</sup><lienAdt id_syceron="1963353"> 1194</lienAdt>, <lienAdt id_syceron="1963368"> 51</lienAdt>, <lienAdt id_syceron="1963370"> 1043</lienA… | |
| 15130001133400 | L15/debats | 15 | 15130001133351 | 15130001133399 | 1 | Amendements nos 1196, 1948, 469 | Amendements n<sup>os</sup><lienAdt id_syceron="1963424"> 1196</lienAdt>, <lienAdt id_syceron="1963506"> 1948</lienAdt>, <lienAdt id_syceron="1963444"> 469</lien… | |
| 15130001133403 | L15/debats | 15 | 15130001133351 | 15130001133402 | 1 | Amendements nos 1890, 915, 1667 | Amendements n<sup>os</sup><lienAdt id_syceron="1963458"> 1890</lienAdt>, <lienAdt id_syceron="1963782"> 915</lienAdt>, <lienAdt id_syceron="1963479"> 1667</lien… | |
| 15130001135587 | L15/debats | 15 | 15130001135582 | 15130001135586 | 1 | Amendement no 1037 | Amendement n<sup>o</sup><lienAdt id_syceron="1963578"> 1037</lienAdt> | |
| 15130001135588 | L15/debats | 15 | 15130001135582 | 15130001135586 | 2 | Mme Stéphanie Kerbarh, rapporteure de la commission du développement durable et de l’aménagement du territoire | 1963626 | |
| 15130001135589 | L15/debats | 15 | 15130001135582 | 15130001135586 | 3 | Mme Brune Poirson, secrétaire d’État auprès de la ministre de la transition écologique et solidaire | 1963585 | |
| 15130001135590 | L15/debats | 15 | 15130001135582 | 15130001135586 | 4 | Amendements nos 1041, 47, 890, 440, 49, 594, 2380, 1665, 1622, 906, 2383, 2475, 2201, 1057, 577, 2403, 1392, 2404, 1058, 2452, 2405, 2427 | Amendements n<sup>os</sup><lienAdt id_syceron="1963595"> 1041</lienAdt>, <lienAdt id_syceron="1963602"> 47</lienAdt>, <lienAdt id_syceron="1963609"> 890</lienAd… | |
| 15130001135592 | L15/debats | 15 | 15130001135582 | 15130001135591 | 1 | Amendements nos 1325, 1989 | Amendements n<sup>os</sup><lienAdt id_syceron="1963853"> 1325</lienAdt>, <lienAdt id_syceron="1963987"> 1989</lienAdt> | |
| 15130001135594 | L15/debats | 15 | 15130001135582 | 15130001135593 | 1 | Mme Laurence Maillart-Méhaignerie | 1964001 | |
| 15130001135595 | L15/debats | 15 | 15130001135582 | 15130001135593 | 2 | Amendements nos 2483, 2406, 586, 1059, 61 rectifié, 1369, 82, 1362, 2407, 1846, 1039, 2408, 2453, 1017, 1354, 1359, 1990, 2476, 1302, 1067, 2455, 2279, 2101, 20… | Amendements n<sup>os</sup><lienAdt id_syceron="1964007"> 2483</lienAdt>, <lienAdt id_syceron="1964010"> 2406</lienAdt>, <lienAdt id_syceron="1964012"> 586</lien… | |
| 15130001136853 | L15/debats | 15 | 15130001136823 | 15130001136852 | 1 | Amendements nos 177, 1081 | Amendements n<sup>os</sup><lienAdt id_syceron="1965623"> 177</lienAdt>, <lienAdt id_syceron="1965625"> 1081</lienAdt> | |
| 15130001136856 | L15/debats | 15 | 15130001136823 | 15130001136855 | 1 | Amendements nos 998, 293, 175, 999, 1000, 272, 733, 176 | Amendements n<sup>os</sup><lienAdt id_syceron="1965637"> 998</lienAdt>, <lienAdt id_syceron="1965644"> 293</lienAdt>, <lienAdt id_syceron="1965646"> 175</lienAd… | |
| 15130001136858 | L15/debats | 15 | 15130001136823 | 15130001136857 | 1 | Amendement no 1169 | Amendement n<sup>o</sup><lienAdt id_syceron="1965764"> 1169</lienAdt> | |
| 15130001136860 | L15/debats | 15 | 15130001136823 | 15130001136859 | 1 | Amendement no 734 | Amendement n<sup>o</sup><lienAdt id_syceron="1965768"> 734</lienAdt> | |
| 15130001136862 | L15/debats | 15 | 15130001136823 | 15130001136861 | 1 | Amendement no 1086 | Amendement n<sup>o</sup><lienAdt id_syceron="1965772"> 1086</lienAdt> | |
| 15130001136864 | L15/debats | 15 | 15130001136823 | 15130001136863 | 1 | Amendement no 735 | Amendement n<sup>o</sup><lienAdt id_syceron="1965776"> 735</lienAdt> | |
| 15130001136866 | L15/debats | 15 | 15130001136823 | 15130001136865 | 1 | Amendement no 736 | Amendement n<sup>o</sup><lienAdt id_syceron="1965780"> 736</lienAdt> | |
| 15130001136868 | L15/debats | 15 | 15130001136823 | 15130001136867 | 1 | Amendements nos 737, 179 | Amendements n<sup>os</sup><lienAdt id_syceron="1965784"> 737</lienAdt>, <lienAdt id_syceron="1965786"> 179</lienAdt> | |
| 15130001136870 | L15/debats | 15 | 15130001136823 | 15130001136869 | 1 | Amendements nos 738, 180 | Amendements n<sup>os</sup><lienAdt id_syceron="1965796"> 738</lienAdt>, <lienAdt id_syceron="1965798"> 180</lienAdt> | |
| 15130001136872 | L15/debats | 15 | 15130001136823 | 15130001136871 | 1 | Amendements nos 739, 184 | Amendements n<sup>os</sup><lienAdt id_syceron="1965801"> 739</lienAdt>, <lienAdt id_syceron="1965803"> 184</lienAdt> | |
| 15130001136874 | L15/debats | 15 | 15130001136823 | 15130001136873 | 1 | Amendement no 740 | Amendement n<sup>o</sup><lienAdt id_syceron="1965806"> 740</lienAdt> | |
| 15130001136876 | L15/debats | 15 | 15130001136823 | 15130001136875 | 1 | Amendement no 741 | Amendement n<sup>o</sup><lienAdt id_syceron="1965817"> 741</lienAdt> | |
| 15130001136878 | L15/debats | 15 | 15130001136823 | 15130001136877 | 1 | Amendement no 742 | Amendement n<sup>o</sup><lienAdt id_syceron="1965821"> 742</lienAdt> | |
| 15130001136880 | L15/debats | 15 | 15130001136823 | 15130001136879 | 1 | Amendement no 743 | Amendement n<sup>o</sup><lienAdt id_syceron="1965825"> 743</lienAdt> | |
| 15130001136882 | L15/debats | 15 | 15130001136823 | 15130001136881 | 1 | Amendement no 744 | Amendement n<sup>o</sup><lienAdt id_syceron="1965829"> 744</lienAdt> | |
| 15130001136884 | L15/debats | 15 | 15130001136823 | 15130001136883 | 1 | Amendement no 745 | Amendement n<sup>o</sup><lienAdt id_syceron="1965833"> 745</lienAdt> | |
| 15130001136886 | L15/debats | 15 | 15130001136823 | 15130001136885 | 1 | Amendements nos 181, 1153 | Amendements n<sup>os</sup><lienAdt id_syceron="1965837"> 181</lienAdt>, <lienAdt id_syceron="1965842"> 1153</lienAdt> | |
| 15130001136888 | L15/debats | 15 | 15130001136823 | 15130001136887 | 1 | Amendement no 1149 | Amendement n<sup>o</sup><lienAdt id_syceron="1965847"> 1149</lienAdt> | |
| 15130001136890 | L15/debats | 15 | 15130001136823 | 15130001136889 | 1 | Amendement no 746 | Amendement n<sup>o</sup><lienAdt id_syceron="1965851"> 746</lienAdt> | |
| 15130001136892 | L15/debats | 15 | 15130001136823 | 15130001136891 | 1 | Amendement no 747 | Amendement n<sup>o</sup><lienAdt id_syceron="1965855"> 747</lienAdt> | |
| 15130001136894 | L15/debats | 15 | 15130001136823 | 15130001136893 | 1 | Amendements nos 514, 748, 749, 750 | Amendements n<sup>os</sup><lienAdt id_syceron="1965859"> 514</lienAdt>, <lienAdt id_syceron="1965049"> 748</lienAdt>, <lienAdt id_syceron="1965059"> 749</lienAd… | |
| 15130001136896 | L15/debats | 15 | 15130001136823 | 15130001136895 | 1 | Amendement no 751 | Amendement n<sup>o</sup><lienAdt id_syceron="1965067"> 751</lienAdt> | |
| 15130001136898 | L15/debats | 15 | 15130001136823 | 15130001136897 | 1 | Amendement no 386 | Amendement n<sup>o</sup><lienAdt id_syceron="1965071"> 386</lienAdt> | |
| 15130001136900 | L15/debats | 15 | 15130001136823 | 15130001136899 | 1 | Amendement no 752 | Amendement n<sup>o</sup><lienAdt id_syceron="1965078"> 752</lienAdt> | |
| 15130001136902 | L15/debats | 15 | 15130001136823 | 15130001136901 | 1 | Amendements nos 753, 183 | Amendements n<sup>os</sup><lienAdt id_syceron="1965082"> 753</lienAdt>, <lienAdt id_syceron="1965084"> 183</lienAdt> | |
| 15130001136904 | L15/debats | 15 | 15130001136823 | 15130001136903 | 1 | Amendement no 754 | Amendement n<sup>o</sup><lienAdt id_syceron="1965097"> 754</lienAdt> | |
| 15130001136906 | L15/debats | 15 | 15130001136823 | 15130001136905 | 1 | Amendement no 755 | Amendement n<sup>o</sup><lienAdt id_syceron="1965101"> 755</lienAdt> | |
| 15130001136908 | L15/debats | 15 | 15130001136823 | 15130001136907 | 1 | Amendement no 756 | Amendement n<sup>o</sup><lienAdt id_syceron="1965105"> 756</lienAdt> | |
| 15130001136910 | L15/debats | 15 | 15130001136823 | 15130001136909 | 1 | Amendements nos 757, 185, 1009 | Amendements n<sup>os</sup><lienAdt id_syceron="1965109"> 757</lienAdt>, <lienAdt id_syceron="1965111"> 185</lienAdt>, <lienAdt id_syceron="1965113"> 1009</lienA… | |
| 15130001136912 | L15/debats | 15 | 15130001136823 | 15130001136911 | 1 | Amendements nos 296, 186, , 666, 758, 1187 (sous-amendement), 706, 759, 667, 703 | Amendements n<sup>os</sup><lienAdt id_syceron="1965124"> 296</lienAdt>, <lienAdt id_syceron="1965134"> 186</lienAdt>, <lienAdt id_syceron="1965336" />, <lienAdt… | |
| 15130001136914 | L15/debats | 15 | 15130001136823 | 15130001136913 | 1 | Amendement no 760 | Amendement n<sup>o</sup><lienAdt id_syceron="1965374"> 760</lienAdt> | |
| 15130001136916 | L15/debats | 15 | 15130001136823 | 15130001136915 | 1 | Amendement no 761 | Amendement n<sup>o</sup><lienAdt id_syceron="1965378"> 761</lienAdt> | |
| 15130001136918 | L15/debats | 15 | 15130001136823 | 15130001136917 | 1 | Amendement no 762 | Amendement n<sup>o</sup><lienAdt id_syceron="1965382"> 762</lienAdt> | |
| 15130001136920 | L15/debats | 15 | 15130001136823 | 15130001136919 | 1 | Amendements nos 443, 763, 436, 505, 764, 31, 487, 513, 33, 491, 515, 446, 35, 492, 516, 224, 299, 225, 1176, 611, 81, 613, 765, 50, 766, 440, 425, 767, 228, 231… | Amendements n<sup>os</sup><lienAdt id_syceron="1965392"> 443</lienAdt>, <lienAdt id_syceron="1965668"> 763</lienAdt>, <lienAdt id_syceron="1965671"> 436</lienAd… | |
| 15130001136922 | L15/debats | 15 | 15130001136823 | 15130001136921 | 1 | Amendement no 769 | Amendement n<sup>o</sup><lienAdt id_syceron="1965926"> 769</lienAdt> | |
| 15130001136924 | L15/debats | 15 | 15130001136823 | 15130001136923 | 1 | Amendement no 770 | Amendement n<sup>o</sup><lienAdt id_syceron="1965930"> 770</lienAdt> | |
| 15130001136926 | L15/debats | 15 | 15130001136823 | 15130001136925 | 1 | Mme Marie-Christine Dalloz | 1965935 | |
| 15130001136927 | L15/debats | 15 | 15130001136823 | 15130001136925 | 2 | Mme Christine Pires Beaune | 1965943 | |
| 15130001136928 | L15/debats | 15 | 15130001136823 | 15130001136925 | 3 | M. Jean-René Cazeneuve | 1965947 |