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 |
|---|---|---|---|---|---|---|---|---|
| 15130001446537 | L15/debats | 15 | 15130001446505 | 15130001446536 | 1 | Amendement no 3295 | Amendement n<sup>o</sup><lienAdt id_syceron="2306185"> 3295</lienAdt> | |
| 15130001446539 | L15/debats | 15 | 15130001446505 | 15130001446538 | 1 | Amendements nos 3239, 3337, 3656 rectifié, 3660 | Amendements n<sup>os</sup><lienAdt id_syceron="2306199"> 3239</lienAdt>, <lienAdt id_syceron="2306201"> 3337</lienAdt>, <lienAdt id_syceron="2306211"> 3656 rect… | |
| 15130001446541 | L15/debats | 15 | 15130001446505 | 15130001446540 | 1 | Amendements nos 3298, 3299, 3297, 3034, 3296, 3306 | Amendements n<sup>os</sup><lienAdt id_syceron="2306224"> 3298, 3299</lienAdt>, <lienAdt id_syceron="2306249"> 3297</lienAdt>, <lienAdt id_syceron="2306253"> 303… | |
| 15130001446542 | L15/debats | 15 | 15130001446505 | 15130001446540 | 2 | Sous-amendement nos 3620, 3621, 3624, 3623 | Sous-amendement n<sup>os</sup><lienAdt id_syceron="2306321"> 3620, 3621, 3624, 3623</lienAdt> | |
| 15130001446543 | L15/debats | 15 | 15130001446505 | 15130001446540 | 3 | Amendements nos 2924, 3331, 3330, 513, 3428, 3443, 512, 3424, 3434, 3336, 3332, 514, 515, 3333, 723, 3335 | Amendements n<sup>os</sup><lienAdt id_syceron="2306339"> 2924</lienAdt>, <lienAdt id_syceron="2306341"> 3331</lienAdt>, <lienAdt id_syceron="2306350"> 3330</lie… | |
| 15130001446545 | L15/debats | 15 | 15130001446505 | 15130001446544 | 1 | Amendement no 3466 | Amendement n<sup>o</sup><lienAdt id_syceron="2306576"> 3466</lienAdt> | |
| 15130001446548 | L15/debats | 15 | 15130001446505 | 15130001446547 | 1 | Amendements nos 3167, 3300, 3531, 3419, 3421, 1294, 1, 3429, 3109, 3163, 3164, 3165, 3527, 3528, 3242, 3096, 3305, 3497, 3304 | Amendements n<sup>os</sup><lienAdt id_syceron="2306585"> 3167, 3300, 3531</lienAdt>, <lienAdt id_syceron="2306588"> 3419</lienAdt>, <lienAdt id_syceron="2306594… | |
| 15130001446549 | L15/debats | 15 | 15130001446505 | 15130001446547 | 2 | Sous-amendement no 3661 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2306762"> 3661</lienAdt> | |
| 15130001446550 | L15/debats | 15 | 15130001446505 | 15130001446547 | 3 | Amendements nos 1366, 2869, 2871, 2870, 21, 24, 63, 231, 963, 2995, 22, 25, 64, 103, 232, 265, 965, 104, 229, 3166 | Amendements n<sup>os</sup><lienAdt id_syceron="2306776"> 1366</lienAdt>, <lienAdt id_syceron="2306780"> 2869</lienAdt>, <lienAdt id_syceron="2306804"> 2871, 287… | |
| 15130001446551 | L15/debats | 15 | 15130001446505 | 15130001446547 | 4 | Sous-amendement no 3614 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2306817"> 3614</lienAdt> | |
| 15130001446553 | L15/debats | 15 | 15130001446505 | 15130001446552 | 1 | Amendements nos 3457, 74, 77 | Amendements n<sup>os</sup><lienAdt id_syceron="2306919"> 3457</lienAdt>, <lienAdt id_syceron="2306922"> 74, 77</lienAdt> | |
| 15130001446555 | L15/debats | 15 | 15130001446505 | 15130001446554 | 1 | Amendements nos 3469, 3459, 3461, 3264, 3263, 3463, 3265 | Amendements n<sup>os</sup><lienAdt id_syceron="2306926"> 3469, 3459, 3461, 3264, 3263, 3463, 3265</lienAdt> | |
| 15130001446562 | L15/debats | 15 | 15130001446505 | 15130001446561 | 1 | Amendements nos 3278, 3665 | Amendements n<sup>os</sup><lienAdt id_syceron="2306947"> 3278</lienAdt>, <lienAdt id_syceron="2306952"> 3665</lienAdt> | |
| 15130001446564 | L15/debats | 15 | 15130001446505 | 15130001446563 | 1 | Amendements nos 3279, 3477 rectifié, 2978, 1637, 3268, 2986, 545, 1375, 125, 3028, 2981, 2720, 2832, 2979, 2976, 1774, 303, 435, 546, 1807, 2971, 2974, 2941 | Amendements n<sup>os</sup><lienAdt id_syceron="2306957"> 3279</lienAdt>, <lienAdt id_syceron="2306961"> 3477 rectifié</lienAdt>, <lienAdt id_syceron="2306963">2… | |
| 15130001446568 | L15/debats | 15 | 15130001446505 | 15130001446567 | 1 | Amendement no 3526 | Amendement n<sup>o</sup><lienAdt id_syceron="2306986"> 3526</lienAdt> | |
| 15130001449119 | L15/debats | 15 | 15130001449089 | 15130001449118 | 1 | M. Éric Ciotti | 2307508 | |
| 15130001449120 | L15/debats | 15 | 15130001449089 | 15130001449118 | 2 | Amendement no 1 | Amendement n<sup>o</sup><lienAdt id_syceron="2307512"> 1</lienAdt> | |
| 15130001449122 | L15/debats | 15 | 15130001449089 | 15130001449121 | 1 | M. Éric Ciotti | 2307995 | |
| 15130001449123 | L15/debats | 15 | 15130001449089 | 15130001449121 | 2 | M. Sébastien Nadot | 2308003 | |
| 15130001449124 | L15/debats | 15 | 15130001449089 | 15130001449121 | 3 | Amendement no 2 | Amendement n<sup>o</sup><lienAdt id_syceron="2308007"> 2</lienAdt> | |
| 15130001449145 | L15/debats | 15 | 15130001449089 | 15130001449144 | 1 | Amendement no 44 | Amendement n<sup>o</sup><lienAdt id_syceron="2308433"> 44</lienAdt> | |
| 15130001449148 | L15/debats | 15 | 15130001449089 | 15130001449147 | 1 | Amendements nos 5, 6, 21 | Amendements n<sup>os</sup><lienAdt id_syceron="2308441"> 5</lienAdt>, <lienAdt id_syceron="2308448"> 6</lienAdt>, <lienAdt id_syceron="2308474"> 21</lienAdt> | |
| 15130001449150 | L15/debats | 15 | 15130001449089 | 15130001449149 | 1 | Amendement no 52 | Amendement n<sup>o</sup><lienAdt id_syceron="2308482"> 52</lienAdt> | |
| 15130001449152 | L15/debats | 15 | 15130001449089 | 15130001449151 | 1 | Amendement no 7 | Amendement n<sup>o</sup><lienAdt id_syceron="2308491"> 7</lienAdt> | |
| 15130001449154 | L15/debats | 15 | 15130001449089 | 15130001449153 | 1 | Amendements nos 16, 38, 18, 27, 8, 9, 10, 11, 17, 2, 3, 15, 28, 39, 45, 43 | Amendements n<sup>os</sup><lienAdt id_syceron="2308509"> 16</lienAdt>, <lienAdt id_syceron="2308511"> 38</lienAdt>, <lienAdt id_syceron="2308523"> 18</lienAdt>,… | |
| 15130001449155 | L15/debats | 15 | 15130001449089 | 15130001449153 | 2 | Sous-amendement no 53 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2308589"> 53</lienAdt> | |
| 15130001449156 | L15/debats | 15 | 15130001449089 | 15130001449153 | 3 | Amendements nos 40, 23, 25 | Amendements n<sup>os</sup><lienAdt id_syceron="2307768"> 40</lienAdt>, <lienAdt id_syceron="2307783"> 23, 25</lienAdt> | |
| 15130001449158 | L15/debats | 15 | 15130001449089 | 15130001449157 | 1 | Amendement no 50 | Amendement n<sup>o</sup><lienAdt id_syceron="2307787"> 50</lienAdt> | |
| 15130001449161 | L15/debats | 15 | 15130001449089 | 15130001449160 | 1 | Amendement no 22 | Amendement n<sup>o</sup><lienAdt id_syceron="2307799"> 22</lienAdt> | |
| 15130001451100 | L15/debats | 15 | 15130001451068 | 15130001451099 | 1 | Amendement no 427 | Amendement n<sup>o</sup><lienAdt id_syceron="2310511"> 427</lienAdt> | |
| 15130001451102 | L15/debats | 15 | 15130001451068 | 15130001451101 | 1 | M. Jean Lassalle | 2310526 | |
| 15130001451103 | L15/debats | 15 | 15130001451068 | 15130001451101 | 2 | M. Éric Coquerel | 2310531 | |
| 15130001451104 | L15/debats | 15 | 15130001451068 | 15130001451101 | 3 | M. Buon Tan | 2310537 | |
| 15130001451105 | L15/debats | 15 | 15130001451068 | 15130001451101 | 4 | M. Éric Pauget | 2310542 | |
| 15130001451106 | L15/debats | 15 | 15130001451068 | 15130001451101 | 5 | Mme Cécile Untermaier | 2310547 | |
| 15130001451107 | L15/debats | 15 | 15130001451068 | 15130001451101 | 6 | M. Thomas Gassilloud | 2310552 | |
| 15130001451108 | L15/debats | 15 | 15130001451068 | 15130001451101 | 7 | M. Jean-Christophe Lagarde | 2310635 | |
| 15130001451109 | L15/debats | 15 | 15130001451068 | 15130001451101 | 8 | M. Ludovic Pajot | 2310640 | |
| 15130001451111 | L15/debats | 15 | 15130001451068 | 15130001451110 | 1 | Mme Emmanuelle Ménard | 2310646 | |
| 15130001451113 | L15/debats | 15 | 15130001451068 | 15130001451112 | 1 | Amendements nos 725, 737, 648, 417 | Amendements n<sup>os</sup><lienAdt id_syceron="2310651"> 725</lienAdt>, <lienAdt id_syceron="2310655"> 737</lienAdt>, <lienAdt id_syceron="2310885"> 648</lienAd… | |
| 15130001451115 | L15/debats | 15 | 15130001451068 | 15130001451114 | 1 | M. Ugo Bernalicis | 2310909 | |
| 15130001451116 | L15/debats | 15 | 15130001451068 | 15130001451114 | 2 | M. le président | 2311034 | |
| 15130001451993 | L15/debats | 15 | 15130001451986 | 15130001451992 | 1 | Amendements nos 1021, 678, 970, 639, 1098, 140, 1104 | Amendements n<sup>os</sup><lienAdt id_syceron="2311533"> 1021</lienAdt>, <lienAdt id_syceron="2311540"> 678</lienAdt>, <lienAdt id_syceron="2311542"> 970</lienA… | |
| 15130001451994 | L15/debats | 15 | 15130001451986 | 15130001451992 | 2 | M. Jean-Michel Fauvergue, rapporteur de la commission des lois constitutionnelles, de la législation et de l’administration générale de la République | 2311554 | |
| 15130001451995 | L15/debats | 15 | 15130001451986 | 15130001451992 | 3 | Amendement no 1232 | Amendement n<sup>o</sup><lienAdt id_syceron="2311555"> 1232</lienAdt> | |
| 15130001451996 | L15/debats | 15 | 15130001451986 | 15130001451992 | 4 | M. Gérald Darmanin, ministre de l’intérieur | 2311561 | |
| 15130001451998 | L15/debats | 15 | 15130001451986 | 15130001451997 | 1 | Amendements nos 1353 | Amendements n<sup>os</sup><lienAdt id_syceron="2311061"> 1353</lienAdt> | |
| 15130001451999 | L15/debats | 15 | 15130001451986 | 15130001451997 | 2 | Sous-amendements nos, 1354 | Sous-amendements n<sup>os</sup><lienAdt id_syceron="2311219" />, <lienAdt id_syceron="2311565"> 1354</lienAdt> | |
| 15130001452000 | L15/debats | 15 | 15130001451986 | 15130001451997 | 3 | Amendements nos 568, 567, 644, , 561, 393, 1103 rectifié, 1233 rectifié, 319, 320, 1276 | Amendements n<sup>os</sup><lienAdt id_syceron="2311586"> 568, 567</lienAdt>, <lienAdt id_syceron="2311623"> 644</lienAdt>, <lienAdt id_syceron="2311625" />, <li… | |
| 15130001452002 | L15/debats | 15 | 15130001451986 | 15130001452001 | 1 | M. Ugo Bernalicis | 2312249 |