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 |
|---|---|---|---|---|---|---|---|---|
| 16130000337609 | L16/debats | 16 | 16130000337599 | 16130000337608 | 1 | Amendements nos 421, 422 | Amendements n<sup>os</sup> <lienAdt id_syceron="3047781"> 421, 422</lienAdt> | |
| 16130000337611 | L16/debats | 16 | 16130000337599 | 16130000337610 | 1 | Mme Louise Morel | 3047797 | |
| 16130000337612 | L16/debats | 16 | 16130000337599 | 16130000337610 | 2 | M. Sébastien Jumel | 3047800 | |
| 16130000337613 | L16/debats | 16 | 16130000337599 | 16130000337610 | 3 | Mme Agnès Pannier-Runacher, ministre | 3047805 | |
| 16130000337614 | L16/debats | 16 | 16130000337599 | 16130000337610 | 4 | Amendements nos 175, 590, 415, 156, 75, 407, 503, 468 | Amendements n<sup>os</sup> <lienAdt id_syceron="3047809"> 175</lienAdt>, <lienAdt id_syceron="3047885"> 590</lienAdt>, <lienAdt id_syceron="3047898"> 415</lienA… | |
| 16130000337615 | L16/debats | 16 | 16130000337599 | 16130000337610 | 5 | Sous-amendement no 705 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3047304"> 705</lienAdt> | |
| 16130000337616 | L16/debats | 16 | 16130000337599 | 16130000337610 | 6 | Amendement no 125 | Amendement n<sup>o</sup> <lienAdt id_syceron="3047323"> 125</lienAdt> | |
| 16130000337618 | L16/debats | 16 | 16130000337599 | 16130000337617 | 1 | Mme Marie-Noëlle Battistel | 3047336 | |
| 16130000337619 | L16/debats | 16 | 16130000337599 | 16130000337617 | 2 | M. Alexandre Loubet | 3047338 | |
| 16130000337620 | L16/debats | 16 | 16130000337599 | 16130000337617 | 3 | M. Matthias Tavel | 3047341 | |
| 16130000337621 | L16/debats | 16 | 16130000337599 | 16130000337617 | 4 | Mme Julie Laernoes | 3047739 | |
| 16130000337622 | L16/debats | 16 | 16130000337599 | 16130000337617 | 5 | Amendements nos 612, 283, 598, 504, 353, 319, 196, 352, 507, 200, 509, 516 | Amendements n<sup>os</sup> <lienAdt id_syceron="3047744"> 612</lienAdt>, <lienAdt id_syceron="3047763"> 283</lienAdt>, <lienAdt id_syceron="3047765"> 598</lienA… | |
| 16130000337624 | L16/debats | 16 | 16130000337599 | 16130000337623 | 1 | Mme Florence Goulet | 3048325 | |
| 16130000337625 | L16/debats | 16 | 16130000337599 | 16130000337623 | 2 | M. Maxime Laisney | 3048329 | |
| 16130000338711 | L16/debats | 16 | 16130000338683 | 16130000338710 | 1 | Mme Delphine Batho | 3048897 | |
| 16130000338712 | L16/debats | 16 | 16130000338683 | 16130000338710 | 2 | M. Benjamin Saint-Huile | 3048904 | |
| 16130000338713 | L16/debats | 16 | 16130000338683 | 16130000338710 | 3 | Mme Barbara Pompili | 3048910 | |
| 16130000338714 | L16/debats | 16 | 16130000338683 | 16130000338710 | 4 | Mme Aurélie Trouvé | 3050034 | |
| 16130000338715 | L16/debats | 16 | 16130000338683 | 16130000338710 | 5 | M. Philippe Bolo | 3050041 | |
| 16130000338716 | L16/debats | 16 | 16130000338683 | 16130000338710 | 6 | M. Dominique Potier | 3050048 | |
| 16130000338717 | L16/debats | 16 | 16130000338683 | 16130000338710 | 7 | M. Hubert Wulfranc | 3050051 | |
| 16130000338718 | L16/debats | 16 | 16130000338683 | 16130000338710 | 8 | M. Jérôme Nury | 3050054 | |
| 16130000338719 | L16/debats | 16 | 16130000338683 | 16130000338710 | 9 | M. Nicolas Dupont-Aignan | 3050056 | |
| 16130000338720 | L16/debats | 16 | 16130000338683 | 16130000338710 | 10 | Amendements nos 7, 23, 64, 112, 127, 181, 271, 304, 489, 565, 671 | Amendements n<sup>os</sup> <lienAdt id_syceron="3050059"> 7</lienAdt>, <lienAdt id_syceron="3050063"> 23</lienAdt>, <lienAdt id_syceron="3048713"> 64</lienAdt>,… | |
| 16130000338721 | L16/debats | 16 | 16130000338683 | 16130000338710 | 11 | Mme Maud Bregeon, rapporteure de la commission des affaires économiques | 3048935 | |
| 16130000338722 | L16/debats | 16 | 16130000338683 | 16130000338710 | 12 | Mme Agnès Pannier-Runacher, ministre de la transition énergétique | 3048959 | |
| 16130000338724 | L16/debats | 16 | 16130000338683 | 16130000338723 | 1 | Amendements nos 190, 103, 309 | Amendements n<sup>os</sup> <lienAdt id_syceron="3049808"> 190</lienAdt>, <lienAdt id_syceron="3049811"> 103</lienAdt>, <lienAdt id_syceron="3049813"> 309</lienA… | |
| 16130000338727 | L16/debats | 16 | 16130000338683 | 16130000338726 | 1 | Amendement no 672 | Amendement n<sup>o</sup> <lienAdt id_syceron="3048406"> 672</lienAdt> | |
| 16130000338729 | L16/debats | 16 | 16130000338683 | 16130000338728 | 1 | M. Hendrik Davi | 3048793 | |
| 16130000338731 | L16/debats | 16 | 16130000338683 | 16130000338730 | 1 | M. Sébastien Jumel | 3048805 | |
| 16130000338732 | L16/debats | 16 | 16130000338683 | 16130000338730 | 2 | Mme la présidente | 3048812 | |
| 16130000338733 | L16/debats | 16 | 16130000338683 | 16130000338730 | 3 | M. Maxime Laisney | 3048813 | |
| 16130000338734 | L16/debats | 16 | 16130000338683 | 16130000338730 | 4 | Mme la présidente | 3048817 | |
| 16130000338737 | L16/debats | 16 | 16130000338683 | 16130000338736 | 1 | Mme Julie Laernoes | 3048823 | |
| 16130000338738 | L16/debats | 16 | 16130000338683 | 16130000338736 | 2 | Mme Agnès Pannier-Runacher, ministre | 3048827 | |
| 16130000338740 | L16/debats | 16 | 16130000338683 | 16130000338739 | 1 | M. Sébastien Jumel | 3049320 | |
| 16130000338741 | L16/debats | 16 | 16130000338683 | 16130000338739 | 2 | Mme Aurélie Trouvé | 3049331 | |
| 16130000338743 | L16/debats | 16 | 16130000338683 | 16130000338742 | 1 | Amendements nos 9, 24, 65, 113, 134, 275, 312, 490, 557 | Amendements n<sup>os</sup> <lienAdt id_syceron="3049338"> 9</lienAdt>, <lienAdt id_syceron="3049345"> 24</lienAdt>, <lienAdt id_syceron="3049348"> 65</lienAdt>,… | |
| 16130000338744 | L16/debats | 16 | 16130000338683 | 16130000338742 | 2 | M. Guillaume Kasbarian, président de la commission des affaires économiques | 3049869 | |
| 16130000338746 | L16/debats | 16 | 16130000338683 | 16130000338745 | 1 | Mme Aurélie Trouvé | 3049879 | |
| 16130000338748 | L16/debats | 16 | 16130000338683 | 16130000338747 | 1 | Amendements nos 3, 416, 429, 367, 142, 141, 419 | Amendements n<sup>os</sup> <lienAdt id_syceron="3049883">3</lienAdt>, <lienAdt id_syceron="3049892"> 416</lienAdt>, <lienAdt id_syceron="3049049"> 429</lienAdt>… | |
| 16130000338750 | L16/debats | 16 | 16130000338683 | 16130000338749 | 1 | M. Bruno Millienne | 3049096 | |
| 16130000338751 | L16/debats | 16 | 16130000338683 | 16130000338749 | 2 | Mme la présidente | 3049106 | |
| 16130000338753 | L16/debats | 16 | 16130000338683 | 16130000338752 | 1 | Amendement no 257 | Amendement n<sup>o</sup> <lienAdt id_syceron="3049113"> 257</lienAdt> | |
| 16130000338755 | L16/debats | 16 | 16130000338683 | 16130000338754 | 1 | M. Antoine Armand | 3050294 | |
| 16130000338756 | L16/debats | 16 | 16130000338683 | 16130000338754 | 2 | M. Maxime Laisney | 3050298 | |
| 16130000338758 | L16/debats | 16 | 16130000338683 | 16130000338757 | 1 | Amendements nos 87, 588, 417, 250, 100, 251, 613, 614, 86, 186 | Amendements n<sup>os</sup> <lienAdt id_syceron="3050309"> 87</lienAdt>, <lienAdt id_syceron="3050313"> 588</lienAdt>, <lienAdt id_syceron="3050343"> 417</lienAd… | |
| 16130000338760 | L16/debats | 16 | 16130000338683 | 16130000338759 | 1 | M. Antoine Léaument | 3050460 | |
| 16130000338761 | L16/debats | 16 | 16130000338683 | 16130000338759 | 2 | Mme la présidente | 3050463 | |
| 16130000340072 | L16/debats | 16 | 16130000340067 | 16130000340071 | 1 | Amendement no 410 | Amendement n<sup>o</sup> <lienAdt id_syceron="3049388"> 410</lienAdt> |