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 |
|---|---|---|---|---|---|---|---|---|
| 15130000917230 | L15/debats | 15 | 15130000917183 | 15130000917216 | 14 | Mme Caroline Fiat | 1777279 | |
| 15130000917231 | L15/debats | 15 | 15130000917183 | 15130000917216 | 15 | Amendements nos 112, 102, 125, 1, 30, 104, 103, 135, 274 | Amendements n<sup>os</sup><lienAdt id_syceron="1777290"> 112</lienAdt>, <lienAdt id_syceron="1777485"> 102</lienAdt>, <lienAdt id_syceron="1777490"> 125</lienAd… | |
| 15130000918253 | L15/debats | 15 | 15130000918248 | 15130000918252 | 1 | Amendement no 293 | Amendement n<sup>o</sup><lienAdt id_syceron="1777829"> 293</lienAdt> | |
| 15130000918254 | L15/debats | 15 | 15130000918248 | 15130000918252 | 2 | M. Rémy Rebeyrotte, rapporteur de la commission des lois constitutionnelles, de la législation et de l’administration générale de la République | 1777833 | |
| 15130000918255 | L15/debats | 15 | 15130000918248 | 15130000918252 | 3 | Mme Jacqueline Gourault, ministre de la cohésion des territoires et des relations avec les collectivités territoriales | 1777835 | |
| 15130000918257 | L15/debats | 15 | 15130000918248 | 15130000918256 | 1 | Amendement no 292 | Amendement n<sup>o</sup><lienAdt id_syceron="1778001"> 292</lienAdt> | |
| 15130000918259 | L15/debats | 15 | 15130000918248 | 15130000918258 | 1 | M. Patrick Hetzel | 1778448 | |
| 15130000918260 | L15/debats | 15 | 15130000918248 | 15130000918258 | 2 | M. Thierry Michels | 1778450 | |
| 15130000918261 | L15/debats | 15 | 15130000918248 | 15130000918258 | 3 | Mme Carole Grandjean | 1778454 | |
| 15130000918262 | L15/debats | 15 | 15130000918248 | 15130000918258 | 4 | M. Bruno Fuchs | 1778461 | |
| 15130000918263 | L15/debats | 15 | 15130000918248 | 15130000918258 | 5 | M. Raphaël Schellenberger | 1778468 | |
| 15130000918264 | L15/debats | 15 | 15130000918248 | 15130000918258 | 6 | M. Ludovic Mendes | 1778525 | |
| 15130000918265 | L15/debats | 15 | 15130000918248 | 15130000918258 | 7 | M. Stéphane Viry | 1778531 | |
| 15130000918266 | L15/debats | 15 | 15130000918248 | 15130000918258 | 8 | M. Sylvain Waserman | 1778536 | |
| 15130000918267 | L15/debats | 15 | 15130000918248 | 15130000918258 | 9 | M. Olivier Becht | 1778540 | |
| 15130000918268 | L15/debats | 15 | 15130000918248 | 15130000918258 | 10 | Mme Catherine Kamowski | 1778543 | |
| 15130000918269 | L15/debats | 15 | 15130000918248 | 15130000918258 | 11 | M. Éric Straumann | 1778549 | |
| 15130000918270 | L15/debats | 15 | 15130000918248 | 15130000918258 | 12 | Amendements nos 113, 189, 298, 203, 276, 196, 197, 101, 105, 278, 207, 2, 279, 181, 38, 205, 114, 106, 204 | Amendements n<sup>os</sup><lienAdt id_syceron="1778552"> 113</lienAdt>, <lienAdt id_syceron="1778731"> 189</lienAdt>, <lienAdt id_syceron="1778733"> 298</lienAd… | |
| 15130000918273 | L15/debats | 15 | 15130000918248 | 15130000918272 | 1 | Amendements nos 154, 151, 299, 4, 31, 246, 45, 5, 29, 288, 76, 313, 88, 44, 323 deuxième rectification, 325 (sous-amendement), 191, 190, 53, 253, 254, 66, 92, 1… | Amendements n<sup>os</sup><lienAdt id_syceron="1777961"> 154</lienAdt>, <lienAdt id_syceron="1777963"> 151</lienAdt>, <lienAdt id_syceron="1777966"> 299</lienAd… | |
| 15130000919387 | L15/debats | 15 | 15130000919329 | 15130000919386 | 1 | Amendements nos 300, 324 | Amendements n<sup>os</sup><lienAdt id_syceron="1779082"> 300</lienAdt>, <lienAdt id_syceron="1779085"> 324</lienAdt> | |
| 15130000919388 | L15/debats | 15 | 15130000919329 | 15130000919386 | 2 | M. Rémy Rebeyrotte, rapporteur de la commission des lois constitutionnelles, de la législation et de l’administration générale de la République | 1779086 | |
| 15130000919389 | L15/debats | 15 | 15130000919329 | 15130000919386 | 3 | Mme Jacqueline Gourault, ministre de la cohésion des territoires et des relations avec les collectivités territoriales | 1779090 | |
| 15130000919390 | L15/debats | 15 | 15130000919329 | 15130000919386 | 4 | Amendements nos 9, 296, 8, 159 | Amendements n<sup>os</sup><lienAdt id_syceron="1779140"> 9</lienAdt>, <lienAdt id_syceron="1779143"> 296</lienAdt>, <lienAdt id_syceron="1779162"> 8</lienAdt>, … | |
| 15130000919391 | L15/debats | 15 | 15130000919329 | 15130000919386 | 5 | Mme la présidente | 1779721 | |
| 15130000919393 | L15/debats | 15 | 15130000919329 | 15130000919392 | 1 | Mme Caroline Fiat | 1779728 | |
| 15130000919395 | L15/debats | 15 | 15130000919329 | 15130000919394 | 1 | Amendements nos 227, 130, 316 rectifié, 348, 10, 11, 32, 127, 15, 169, 157, 192, 249, 294, 295, 301, 12, 40, 333 (sous-amendement), 80, 84, 82, 39, 332 (sous-am… | Amendements n<sup>os</sup><lienAdt id_syceron="1779731"> 227</lienAdt>, <lienAdt id_syceron="1779378"> 130</lienAdt>, <lienAdt id_syceron="1779398"> 316 rectifi… | |
| 15130000919397 | L15/debats | 15 | 15130000919329 | 15130000919396 | 1 | Amendements nos 21, 22, 33, 328 (sous-amendement), 34, 329 (sous-amendement), 35, 330 (sous-amendement), 46, 334 (sous-amendement), 83, 85, 90, 164, 167, 174, 3… | Amendements n<sup>os</sup><lienAdt id_syceron="1779581"> 21</lienAdt>, <lienAdt id_syceron="1779588"> 22</lienAdt>, <lienAdt id_syceron="1779602"> 33</lienAdt>,… | |
| 15130000919399 | L15/debats | 15 | 15130000919329 | 15130000919398 | 1 | Amendements nos 13, 199, 283 | Amendements n<sup>os</sup><lienAdt id_syceron="1779814"> 13</lienAdt>, <lienAdt id_syceron="1779816"> 199</lienAdt>, <lienAdt id_syceron="1779897"> 283</lienAdt… | |
| 15130000919401 | L15/debats | 15 | 15130000919329 | 15130000919400 | 1 | M. Patrick Hetzel | 1779911 | |
| 15130000919402 | L15/debats | 15 | 15130000919329 | 15130000919400 | 2 | M. Raphaël Schellenberger | 1779914 | |
| 15130000919403 | L15/debats | 15 | 15130000919329 | 15130000919400 | 3 | M. Laurent Furst | 1779917 | |
| 15130000919404 | L15/debats | 15 | 15130000919329 | 15130000919400 | 4 | M. Dominique Potier | 1779924 | |
| 15130000919405 | L15/debats | 15 | 15130000919329 | 15130000919400 | 5 | M. Jean Lassalle | 1779930 | |
| 15130000919406 | L15/debats | 15 | 15130000919329 | 15130000919400 | 6 | M. Rémy Rebeyrotte, rapporteur | 1779934 | |
| 15130000919407 | L15/debats | 15 | 15130000919329 | 15130000919400 | 7 | Mme Jacqueline Gourault, ministre | 1779936 | |
| 15130000919409 | L15/debats | 15 | 15130000919329 | 15130000919408 | 1 | M. Patrick Hetzel | 1779943 | |
| 15130000919410 | L15/debats | 15 | 15130000919329 | 15130000919408 | 2 | M. Thibault Bazin | 1780014 | |
| 15130000919411 | L15/debats | 15 | 15130000919329 | 15130000919408 | 3 | M. Jacques Cattin | 1780021 | |
| 15130000919412 | L15/debats | 15 | 15130000919329 | 15130000919408 | 4 | M. Laurent Furst | 1780025 | |
| 15130000919413 | L15/debats | 15 | 15130000919329 | 15130000919408 | 5 | M. Éric Straumann | 1780034 | |
| 15130000919414 | L15/debats | 15 | 15130000919329 | 15130000919408 | 6 | M. Dominique Potier | 1780039 | |
| 15130000919415 | L15/debats | 15 | 15130000919329 | 15130000919408 | 7 | M. Vincent Thiébaut | 1780044 | |
| 15130000919416 | L15/debats | 15 | 15130000919329 | 15130000919408 | 8 | M. Pierre Cordier | 1780046 | |
| 15130000919417 | L15/debats | 15 | 15130000919329 | 15130000919408 | 9 | M. Christophe Arend | 1780392 | |
| 15130000919418 | L15/debats | 15 | 15130000919329 | 15130000919408 | 10 | Mme Caroline Fiat | 1780397 | |
| 15130000919419 | L15/debats | 15 | 15130000919329 | 15130000919408 | 11 | M. Olivier Becht | 1780405 | |
| 15130000919420 | L15/debats | 15 | 15130000919329 | 15130000919408 | 12 | M. Antoine Herth | 1780409 | |
| 15130000919421 | L15/debats | 15 | 15130000919329 | 15130000919408 | 13 | M. Bruno Fuchs | 1780413 | |
| 15130000919422 | L15/debats | 15 | 15130000919329 | 15130000919408 | 14 | M. Jean Lassalle | 1780418 | |
| 15130000919423 | L15/debats | 15 | 15130000919329 | 15130000919408 | 15 | M. Hubert Wulfranc | 1780425 |