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 |
|---|---|---|---|---|---|---|---|---|
| 15130000418775 | L15/debats | 15 | 15130000418744 | 15130000418766 | 9 | M. Matthieu Orphelin | 1276538 | |
| 15130000418776 | L15/debats | 15 | 15130000418744 | 15130000418766 | 10 | M. Loïc Prud’homme | 1276543 | |
| 15130000418777 | L15/debats | 15 | 15130000418744 | 15130000418766 | 11 | M. Jean-Baptiste Moreau, rapporteur | 1276548 | |
| 15130000418778 | L15/debats | 15 | 15130000418744 | 15130000418766 | 12 | M. Stéphane Travert, ministre | 1276561 | |
| 15130000418779 | L15/debats | 15 | 15130000418744 | 15130000418766 | 13 | Amendement no1756 | Amendement n<sup>o</sup><lienAdt id_syceron="1275775">1756</lienAdt> | |
| 15130000418781 | L15/debats | 15 | 15130000418744 | 15130000418780 | 1 | Amendements nos86, 170, 259, 955, 986, 2479, 702, 713, 928, 1084, 1196, 1669, 64, 130, 142, 321, 329, 1036, 1548 rectifié, 670, 956, 2682, 2659, 2660, 2661, 266… | Amendements n<sup>os</sup><lienAdt id_syceron="1275734">86</lienAdt>, <lienAdt id_syceron="1275736">170</lienAdt>, <lienAdt id_syceron="1275738">259</lienAdt>, … | |
| 15130000418783 | L15/debats | 15 | 15130000418744 | 15130000418782 | 1 | Amendements nos2475, 1062, 2102, 2527 | Amendements n<sup>os</sup><lienAdt id_syceron="1276347">2475</lienAdt>, <lienAdt id_syceron="1276349">1062</lienAdt>, <lienAdt id_syceron="1276351">2102</lienAd… | |
| 15130000419905 | L15/debats | 15 | 15130000419900 | 15130000419904 | 1 | Amendement no256 | Amendement n<sup>o</sup><lienAdt id_syceron="1276005">256</lienAdt> | |
| 15130000419906 | L15/debats | 15 | 15130000419900 | 15130000419904 | 2 | M. Jean-Baptiste Moreau, rapporteur de la commission des affaires économiques | 1276008 | |
| 15130000419907 | L15/debats | 15 | 15130000419900 | 15130000419904 | 3 | M. Stéphane Travert, ministre de l’agriculture et de l’alimentation | 1276010 | |
| 15130000419908 | L15/debats | 15 | 15130000419900 | 15130000419904 | 4 | Amendements nos937, 1000, 1056, 1104, 1195, 35, 895, 2233, 1799 | Amendements n<sup>os</sup><lienAdt id_syceron="1276012">937</lienAdt>, <lienAdt id_syceron="1276014">1000</lienAdt>, <lienAdt id_syceron="1276019">1056</lienAdt… | |
| 15130000419910 | L15/debats | 15 | 15130000419900 | 15130000419909 | 1 | Amendements nos1757, 65, 618, 1606, 1704, 213, 957, 580, 553, 1688, 1693, 2414, 514, 2010, 2203, 2425, 1758, 66, 2694 rectifié (sous-amendement), 131, 319, 617,… | Amendements n<sup>os</sup><lienAdt id_syceron="1276337">1757</lienAdt>, <lienAdt id_syceron="1276493">65</lienAdt>, <lienAdt id_syceron="1276495">618</lienAdt>,… | |
| 15130000419912 | L15/debats | 15 | 15130000419900 | 15130000419911 | 1 | Amendements nos1957 rectifié, 185, 246, 265, 613, 794, 1081, 1136, 1200, 2427, 2214 | Amendements n<sup>os</sup><lienAdt id_syceron="1277347">1957 rectifié</lienAdt>, <lienAdt id_syceron="1277355">185</lienAdt>, <lienAdt id_syceron="1277357">246<… | |
| 15130000419913 | L15/debats | 15 | 15130000419900 | 15130000419911 | 2 | M. Roland Lescure, président de la commission des affaires économiques | 1277754 | |
| 15130000419914 | L15/debats | 15 | 15130000419900 | 15130000419911 | 3 | Amendements nos1959, 2227, 1903, 2430, 2431 | Amendements n<sup>os</sup><lienAdt id_syceron="1276589">1959</lienAdt>, <lienAdt id_syceron="1276597">2227</lienAdt>, <lienAdt id_syceron="1276600">1903</lienAd… | |
| 15130000419917 | L15/debats | 15 | 15130000419900 | 15130000419916 | 1 | Amendements nos1746, 1960, 2217, 2517 | Amendements n<sup>os</sup><lienAdt id_syceron="1276633">1746</lienAdt>, <lienAdt id_syceron="1276636">1960</lienAdt>, <lienAdt id_syceron="1276639">2217</lienAd… | |
| 15130000419919 | L15/debats | 15 | 15130000419900 | 15130000419918 | 1 | M. Richard Ramos | 1276661 | |
| 15130000419920 | L15/debats | 15 | 15130000419900 | 15130000419918 | 2 | M. Dominique Potier | 1276665 | |
| 15130000419921 | L15/debats | 15 | 15130000419900 | 15130000419918 | 3 | M. Jérôme Nury | 1276670 | |
| 15130000419922 | L15/debats | 15 | 15130000419900 | 15130000419918 | 4 | M. Thierry Benoit | 1276676 | |
| 15130000419923 | L15/debats | 15 | 15130000419900 | 15130000419918 | 5 | M. François Ruffin | 1276688 | |
| 15130000419925 | L15/debats | 15 | 15130000419900 | 15130000419924 | 1 | Amendements nos530, 740, 741, 879, 1253, 1774, 2403 | Amendements n<sup>os</sup><lienAdt id_syceron="1277070">530</lienAdt>, <lienAdt id_syceron="1277071">740</lienAdt>, <lienAdt id_syceron="1277074">741</lienAdt>,… | |
| 15130000419927 | L15/debats | 15 | 15130000419900 | 15130000419926 | 1 | Amendements nos215, 703, 795, 1173, 1202, 2429, 2215, 1961, 1054, 214, 1958, 331, 2653 rectifié, 2698 (sous-amendement), 2738 (sous-amendement), 2699 (sous-amen… | Amendements n<sup>os</sup><lienAdt id_syceron="1277202">215</lienAdt>, <lienAdt id_syceron="1277204">703</lienAdt>, <lienAdt id_syceron="1277206">795</lienAdt>,… | |
| 15130000419930 | L15/debats | 15 | 15130000419900 | 15130000419929 | 1 | Amendements nos 419, 1156, 1417, 2471, 2722 (sous-amendement) | Amendements n<sup>os</sup><lienAdt id_syceron="1277628"> 419</lienAdt>, <lienAdt id_syceron="1277630"> 1156</lienAdt>, <lienAdt id_syceron="1277634"> 1417</lien… | |
| 15130000419932 | L15/debats | 15 | 15130000419900 | 15130000419931 | 1 | M. Vincent Descoeur | 1277680 | |
| 15130000419933 | L15/debats | 15 | 15130000419900 | 15130000419931 | 2 | M. Jean-Yves Bony | 1277685 | |
| 15130000419936 | L15/debats | 15 | 15130000419900 | 15130000419935 | 1 | Amendements nos 1172, 1764, 954, 330, 1912, 1378, 2707 (sous-amendement) | Amendements n<sup>os</sup><lienAdt id_syceron="1277248"> 1172</lienAdt>, <lienAdt id_syceron="1277250"> 1764</lienAdt>, <lienAdt id_syceron="1277253"> 954</lien… | |
| 15130000419939 | L15/debats | 15 | 15130000419900 | 15130000419938 | 1 | M. Stéphane Travert, ministre | 1277285 | |
| 15130000419940 | L15/debats | 15 | 15130000419900 | 15130000419938 | 2 | Amendements nos 1964, 2518, 2519 | Amendements n<sup>os</sup><lienAdt id_syceron="1277770"> 1964</lienAdt>, <lienAdt id_syceron="1277783"> 2518</lienAdt>, <lienAdt id_syceron="1277789"> 2519</lie… | |
| 15130000419942 | L15/debats | 15 | 15130000419900 | 15130000419941 | 1 | Mme Isabelle Valentin | 1277796 | |
| 15130000419943 | L15/debats | 15 | 15130000419900 | 15130000419941 | 2 | M. Vincent Descoeur | 1277810 | |
| 15130000419944 | L15/debats | 15 | 15130000419900 | 15130000419941 | 3 | M. Jean-Bernard Sempastous | 1277816 | |
| 15130000419945 | L15/debats | 15 | 15130000419900 | 15130000419941 | 4 | M. Philippe Bolo | 1277821 | |
| 15130000419946 | L15/debats | 15 | 15130000419900 | 15130000419941 | 5 | M. André Chassaigne | 1277827 | |
| 15130000419947 | L15/debats | 15 | 15130000419900 | 15130000419941 | 6 | M. Charles de la Verpillière | 1277838 | |
| 15130000419948 | L15/debats | 15 | 15130000419900 | 15130000419941 | 7 | M. Julien Aubert | 1277843 | |
| 15130000421586 | L15/debats | 15 | 15130000421581 | 15130000421585 | 1 | Mme Marie-Christine Verdier-Jouclas | 1278702 | |
| 15130000421587 | L15/debats | 15 | 15130000421581 | 15130000421585 | 2 | Mme Fabienne Colboc | 1278714 | |
| 15130000421588 | L15/debats | 15 | 15130000421581 | 15130000421585 | 3 | M. Jean-Claude Bouchet | 1278726 | |
| 15130000421589 | L15/debats | 15 | 15130000421581 | 15130000421585 | 4 | M. Guillaume Garot | 1278739 | |
| 15130000421590 | L15/debats | 15 | 15130000421581 | 15130000421585 | 5 | M. Matthieu Orphelin | 1279232 | |
| 15130000421591 | L15/debats | 15 | 15130000421581 | 15130000421585 | 6 | M. Richard Ramos | 1279248 | |
| 15130000421592 | L15/debats | 15 | 15130000421581 | 15130000421585 | 7 | M. Dino Cinieri | 1279272 | |
| 15130000421593 | L15/debats | 15 | 15130000421581 | 15130000421585 | 8 | M. Marc Fesneau | 1279277 | |
| 15130000421594 | L15/debats | 15 | 15130000421581 | 15130000421585 | 9 | M. Dominique Potier | 1279623 | |
| 15130000421595 | L15/debats | 15 | 15130000421581 | 15130000421585 | 10 | M. Nicolas Forissier | 1279635 | |
| 15130000421596 | L15/debats | 15 | 15130000421581 | 15130000421585 | 11 | M. Stéphane Travert, ministre de l’agriculture et de l’alimentation | 1279644 | |
| 15130000421597 | L15/debats | 15 | 15130000421581 | 15130000421585 | 12 | Amendement no1918 | Amendement n<sup>o</sup><lienAdt id_syceron="1279729">1918</lienAdt> | |
| 15130000421598 | L15/debats | 15 | 15130000421581 | 15130000421585 | 13 | M. Jean-Baptiste Moreau, rapporteur de la commission des affaires économiques | 1279909 | |
| 15130000421599 | L15/debats | 15 | 15130000421581 | 15130000421585 | 14 | Amendement no880 | Amendement n<sup>o</sup><lienAdt id_syceron="1279734">880</lienAdt> |