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 |
|---|---|---|---|---|---|---|---|---|
| 16130000404407 | L16/debats | 16 | 16130000404389 | 16130000404403 | 4 | M. Erwan Balanant | 3107364 | |
| 16130000404408 | L16/debats | 16 | 16130000404389 | 16130000404403 | 5 | Amendements nos 7, 13, 22, 36, 39, 40, 42, 44, 64, 66, 71 | Amendements n<sup>os</sup> <lienAdt id_syceron="3107373"> 7</lienAdt>, <lienAdt id_syceron="3107386"> 13</lienAdt>, <lienAdt id_syceron="3107564"> 22</lienAdt>,… | |
| 16130000404409 | L16/debats | 16 | 16130000404389 | 16130000404403 | 6 | Mme Laurence Boone, secrétaire d’État chargée de l’Europe | 3106667 | |
| 16130000404410 | L16/debats | 16 | 16130000404389 | 16130000404403 | 7 | Amendements nos 47, 46, 37, 45, 56, 58, 60, 69, 10, 75, 21, 14, 15, 16, 17, 18 | Amendements n<sup>os</sup> <lienAdt id_syceron="3106731"> 47</lienAdt>, <lienAdt id_syceron="3106736"> 46</lienAdt>, <lienAdt id_syceron="3106737"> 37</lienAdt>… | |
| 16130000404412 | L16/debats | 16 | 16130000404389 | 16130000404411 | 1 | Amendements nos 2, 25, 28, 50, 76, 73, 61, 41, 65, 72, 3, 26, 29, 51, 77 | Amendements n<sup>os</sup> <lienAdt id_syceron="3106963"> 2</lienAdt>, <lienAdt id_syceron="3106968"> 25</lienAdt>, <lienAdt id_syceron="3106970"> 28</lienAdt>,… | |
| 16130000404414 | L16/debats | 16 | 16130000404389 | 16130000404413 | 1 | Mme Caroline Fiat | 3107497 | |
| 16130000404415 | L16/debats | 16 | 16130000404389 | 16130000404413 | 2 | Mme Marine Le Pen | 3107499 | |
| 16130000404416 | L16/debats | 16 | 16130000404389 | 16130000404413 | 3 | M. Philippe Gosselin | 3107501 | |
| 16130000405631 | L16/debats | 16 | 16130000405572 | 16130000405630 | 1 | Mme Raquel Garrido | 3109073 | |
| 16130000405632 | L16/debats | 16 | 16130000405572 | 16130000405630 | 2 | Amendements nos 3, 5, 4 | Amendements n<sup>os</sup> <lienAdt id_syceron="3109086"> 3</lienAdt>, <lienAdt id_syceron="3109488"> 5</lienAdt>, <lienAdt id_syceron="3109500"> 4</lienAdt> | |
| 16130000405634 | L16/debats | 16 | 16130000405572 | 16130000405633 | 1 | M. Charles Sitzenstuhl | 3109513 | |
| 16130000405637 | L16/debats | 16 | 16130000405572 | 16130000405636 | 1 | Mme Aurore Bergé | 3109554 | |
| 16130000405640 | L16/debats | 16 | 16130000405572 | 16130000405639 | 1 | M. Benjamin Lucas | 3109626 | |
| 16130000405641 | L16/debats | 16 | 16130000405572 | 16130000405639 | 2 | Mme Ségolène Amiot | 3109639 | |
| 16130000407191 | L16/debats | 16 | 16130000407183 | 16130000407190 | 1 | Amendements nos 3, 26, 29, 77, 48 | Amendements n<sup>os</sup> <lienAdt id_syceron="3115633"> 3, 26, 29, 77</lienAdt>, <lienAdt id_syceron="3109282"> 48</lienAdt> | |
| 16130000407192 | L16/debats | 16 | 16130000407183 | 16130000407190 | 2 | Sous-amendements nos 100, 94, 96, 117, 101, 95, 106, 111, 109, 112, 115, 105, 121, 82, 118 | Sous-amendements n<sup>os</sup> <lienAdt id_syceron="3109287"> 100</lienAdt>, <lienAdt id_syceron="3109294"> 94</lienAdt>, <lienAdt id_syceron="3109298"> 96</li… | |
| 16130000407193 | L16/debats | 16 | 16130000407183 | 16130000407190 | 4 | M. Mathieu Lefèvre, rapporteur de la commission des lois constitutionnelles, de la législation et de l’administration générale de la République | 3108770 | |
| 16130000407194 | L16/debats | 16 | 16130000407183 | 16130000407190 | 5 | Mme Laurence Boone, secrétaire d’État chargée de l’Europe | 3109649 | |
| 16130000407196 | L16/debats | 16 | 16130000407183 | 16130000407195 | 1 | M. Philippe Gosselin | 3109416 | |
| 16130000407199 | L16/debats | 16 | 16130000407183 | 16130000407198 | 1 | Amendements nos 11, 32 | Amendements n<sup>os</sup> <lienAdt id_syceron="3109438"> 11</lienAdt>, <lienAdt id_syceron="3109442"> 32</lienAdt> | |
| 16130000407201 | L16/debats | 16 | 16130000407183 | 16130000407200 | 1 | M. Philippe Gosselin | 3109686 | |
| 16130000407203 | L16/debats | 16 | 16130000407183 | 16130000407202 | 1 | Amendements nos 19, 33, 70, 62, 78, 12 | Amendements n<sup>os</sup> <lienAdt id_syceron="3109695"> 19</lienAdt>, <lienAdt id_syceron="3109728"> 33</lienAdt>, <lienAdt id_syceron="3110084"> 70</lienAdt>… | |
| 16130000407205 | L16/debats | 16 | 16130000407183 | 16130000407204 | 1 | M. Philippe Gosselin | 3110320 | |
| 16130000407207 | L16/debats | 16 | 16130000407183 | 16130000407206 | 1 | Amendements nos 20, 49 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110326"> 20</lienAdt>, <lienAdt id_syceron="3110336"> 49</lienAdt> | |
| 16130000407209 | L16/debats | 16 | 16130000407183 | 16130000407208 | 1 | Amendements nos 38, 74 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110436"> 38</lienAdt>, <lienAdt id_syceron="3110364"> 74</lienAdt> | |
| 16130000407213 | L16/debats | 16 | 16130000407183 | 16130000407212 | 1 | Mme la présidente | 3110543 | |
| 16130000407215 | L16/debats | 16 | 16130000407183 | 16130000407214 | 1 | M. Jean-Paul Lecoq (GDR-NUPES) | 3110557 | |
| 16130000407216 | L16/debats | 16 | 16130000407183 | 16130000407214 | 2 | M. Jean-Philippe Tanguy (RN) | 3110579 | |
| 16130000407218 | L16/debats | 16 | 16130000407183 | 16130000407217 | 1 | M. Antoine Léaument (LFI-NUPES) | 3110661 | |
| 16130000407219 | L16/debats | 16 | 16130000407183 | 16130000407217 | 2 | M. Philippe Gosselin (LR) | 3110688 | |
| 16130000407220 | L16/debats | 16 | 16130000407183 | 16130000407217 | 3 | M. Hervé Saulignac (SOC) | 3110694 | |
| 16130000408805 | L16/debats | 16 | 16130000408785 | 16130000408804 | 1 | Amendements nos 10, 26, 25, 24 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110414"> 10</lienAdt>, <lienAdt id_syceron="3110429"> 26, 25</lienAdt>, <lienAdt id_syceron="3110438"> 24</lien… | |
| 16130000408807 | L16/debats | 16 | 16130000408785 | 16130000408806 | 1 | Amendement no 9 | Amendement n<sup>o</sup> <lienAdt id_syceron="3110149"> 9</lienAdt> | |
| 16130000408808 | L16/debats | 16 | 16130000408785 | 16130000408806 | 2 | Sous-amendement no 39 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3110151"> 39</lienAdt> | |
| 16130000408809 | L16/debats | 16 | 16130000408785 | 16130000408806 | 3 | Amendement no 36 | Amendement n<sup>o</sup> <lienAdt id_syceron="3110171"> 36</lienAdt> | |
| 16130000408811 | L16/debats | 16 | 16130000408785 | 16130000408810 | 1 | Amendements nos 20 rectifié, 34 rectifié, 3 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110182"> 20 rectifié</lienAdt>, <lienAdt id_syceron="3110188"> 34 rectifié</lienAdt>, <lienAdt id_syceron="3110… | |
| 16130000408813 | L16/debats | 16 | 16130000408785 | 16130000408812 | 1 | Amendements nos 27, 28, 43, 44, 13 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110035"> 27, 28</lienAdt>, <lienAdt id_syceron="3110037"> 43</lienAdt>, <lienAdt id_syceron="3110041"> 44</lien… | |
| 16130000408815 | L16/debats | 16 | 16130000408785 | 16130000408814 | 1 | Amendements nos 23, 1 rectifié, 8 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110048"> 23</lienAdt>, <lienAdt id_syceron="3110066"> 1 rectifié</lienAdt>, <lienAdt id_syceron="3110238"> 8</l… | |
| 16130000408817 | L16/debats | 16 | 16130000408785 | 16130000408816 | 1 | Amendements nos 29, 30, 31, 32 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110249"> 29, 30, 31, 32</lienAdt> | |
| 16130000408819 | L16/debats | 16 | 16130000408785 | 16130000408818 | 1 | Amendements nos 37, 16 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110253"> 37</lienAdt>, <lienAdt id_syceron="3110257"> 16</lienAdt> | |
| 16130000408820 | L16/debats | 16 | 16130000408785 | 16130000408818 | 2 | Sous-amendement no 41 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3110261"> 41</lienAdt> | |
| 16130000408821 | L16/debats | 16 | 16130000408785 | 16130000408818 | 3 | Amendements nos 2, 12, 4, 5, 6, 11 | Amendements n<sup>os</sup> <lienAdt id_syceron="3110447"> 2</lienAdt>, <lienAdt id_syceron="3110449"> 12</lienAdt>, <lienAdt id_syceron="3110451"> 4</lienAdt>, … | |
| 16130000408823 | L16/debats | 16 | 16130000408785 | 16130000408822 | 1 | Amendement no 21 | Amendement n<sup>o</sup> <lienAdt id_syceron="3110720"> 21</lienAdt> | |
| 16130000409825 | L16/debats | 16 | 16130000409800 | 16130000409824 | 1 | Amendement no 175 | Amendement n<sup>o</sup> <lienAdt id_syceron="3112917"> 175</lienAdt> | |
| 16130000409827 | L16/debats | 16 | 16130000409800 | 16130000409826 | 1 | Mme Chantal Jourdan | 3112931 | |
| 16130000409828 | L16/debats | 16 | 16130000409800 | 16130000409826 | 2 | Mme Danielle Brulebois | 3112935 | |
| 16130000409829 | L16/debats | 16 | 16130000409800 | 16130000409826 | 3 | M. Julien Rancoule | 3112939 | |
| 16130000409830 | L16/debats | 16 | 16130000409800 | 16130000409826 | 4 | Mme Catherine Couturier | 3112941 | |
| 16130000409831 | L16/debats | 16 | 16130000409800 | 16130000409826 | 5 | M. Emmanuel Mandon | 3112947 | |
| 16130000409832 | L16/debats | 16 | 16130000409800 | 16130000409826 | 6 | Amendements nos 10, 214, 189 rectifié, 208, 34, 38, 168, 318, 185, 176, 177, 178, 393, 103, 108, 193, 171, 209, 194, 11, 12, 394, 61, 395, 396, 397, 398, 399, 4… | Amendements n<sup>os</sup> <lienAdt id_syceron="3112951"> 10</lienAdt>, <lienAdt id_syceron="3112953"> 214</lienAdt>, <lienAdt id_syceron="3111413"> 189 rectifi… |