debats.compte_rendu_sommaire1_sommaire2_sommaire3
Chemin compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3 · présence : L17 84 %, L16 83 %, L15 85 %
24 558 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 | titre_struct_intitule | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.titreStruct.intitule · présence : L17 84 %, L16 83 %, L15 85 % |
| 8 | titre_struct_intitule_xml | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.titreStruct.intitule.#xml · présence : L17 83 %, L16 83 %, L15 83 % |
| 9 | titre_struct_id_syceron | BIGINT | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.titreStruct.@id_syceron · présence : L17 84 %, L16 83 %, L15 85 % |
| 10 | titre_struct_type_debat | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.titreStruct.@type_debat · présence : L17 15 %, L16 10 %, L15 18 % |
| 11 | type_debat | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.@type_debat · présence : L17 15 %, L16 10 %, L15 18 % |
| 12 | para | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.Para · présence : L16 0 % |
| 13 | para_id_syceron | BIGINT | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.Para.@id_syceron · présence : L16 0 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | titre_struct_intitule | titre_struct_intitule_xml | titre_struct_id_syceron | titre_struct_type_debat | type_debat | para | para_id_syceron |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15130001507191 | L15/debats | 15 | 15130001507037 | 15130001507170 | 9 | Article 42 BA | 2364321 | PLFSS | PLFSS | |||
| 15130001507193 | L15/debats | 15 | 15130001507037 | 15130001507170 | 10 | Article 42 CA | 2364325 | PLFSS | PLFSS | |||
| 15130001507194 | L15/debats | 15 | 15130001507037 | 15130001507170 | 11 | Article 42 DA | 2364327 | PLFSS | PLFSS | |||
| 15130001507196 | L15/debats | 15 | 15130001507037 | 15130001507170 | 12 | Article 42 DB | 2364331 | PLFSS | PLFSS | |||
| 15130001507197 | L15/debats | 15 | 15130001507037 | 15130001507170 | 13 | Article 42 D | 2364333 | PLFSS | PLFSS | |||
| 15130001507199 | L15/debats | 15 | 15130001507037 | 15130001507170 | 14 | Article 42 EA | 2364337 | PLFSS | PLFSS | |||
| 15130001507203 | L15/debats | 15 | 15130001507037 | 15130001507170 | 15 | Article 42 FA | 2364350 | PLFSS | PLFSS | |||
| 15130001507205 | L15/debats | 15 | 15130001507037 | 15130001507170 | 16 | Article 42 F | 2364356 | PLFSS | PLFSS | |||
| 15130001507207 | L15/debats | 15 | 15130001507037 | 15130001507170 | 17 | Article 42 G | 2364360 | PLFSS | PLFSS | |||
| 15130001507209 | L15/debats | 15 | 15130001507037 | 15130001507170 | 18 | Articles 42 L et 42 M | 2364364 | PLFSS | PLFSS | |||
| 15130001507210 | L15/debats | 15 | 15130001507037 | 15130001507170 | 19 | Article 42 N | 2364366 | PLFSS | PLFSS | |||
| 15130001507213 | L15/debats | 15 | 15130001507037 | 15130001507170 | 20 | Article 42 bis A | 2364377 | PLFSS | PLFSS | |||
| 15130001507215 | L15/debats | 15 | 15130001507037 | 15130001507170 | 21 | Article 42 bis B | 2364381 | PLFSS | PLFSS | |||
| 15130001507217 | L15/debats | 15 | 15130001507037 | 15130001507170 | 22 | Article 42 bis C | 2364384 | PLFSS | PLFSS | |||
| 15130001507219 | L15/debats | 15 | 15130001507037 | 15130001507170 | 23 | Article 42 bis D | 2364388 | PLFSS | PLFSS | |||
| 15130001507221 | L15/debats | 15 | 15130001507037 | 15130001507170 | 24 | Article 42 bis E | 2364392 | PLFSS | PLFSS | |||
| 15130001507223 | L15/debats | 15 | 15130001507037 | 15130001507170 | 25 | Article 42 bis F | 2364395 | PLFSS | PLFSS | |||
| 15130001507225 | L15/debats | 15 | 15130001507037 | 15130001507170 | 26 | Article 42 bis | 2364398 | PLFSS | PLFSS | |||
| 15130001507228 | L15/debats | 15 | 15130001507037 | 15130001507170 | 27 | Article 42 quater | 2364411 | PLFSS | PLFSS | |||
| 15130001507230 | L15/debats | 15 | 15130001507037 | 15130001507170 | 28 | Article 42 quinquies | 2364415 | PLFSS | PLFSS | |||
| 15130001507232 | L15/debats | 15 | 15130001507037 | 15130001507170 | 29 | Article 42 octies | 2364419 | PLFSS | PLFSS | |||
| 15130001507233 | L15/debats | 15 | 15130001507037 | 15130001507170 | 30 | Article 42 nonies A | 2364467 | PLFSS | PLFSS | |||
| 15130001507235 | L15/debats | 15 | 15130001507037 | 15130001507170 | 31 | Article 42 duodecies A | 2364472 | PLFSS | PLFSS | |||
| 15130001507236 | L15/debats | 15 | 15130001507037 | 15130001507170 | 32 | Article 42 duodecies B | 2364474 | PLFSS | PLFSS | |||
| 15130001507238 | L15/debats | 15 | 15130001507037 | 15130001507170 | 33 | Article 42 duodecies C | 2364478 | PLFSS | PLFSS | |||
| 15130001507240 | L15/debats | 15 | 15130001507037 | 15130001507170 | 34 | Article 42 duodecies D | 2364482 | PLFSS | PLFSS | |||
| 15130001507242 | L15/debats | 15 | 15130001507037 | 15130001507170 | 35 | Article 42 duodecies | 2364486 | PLFSS | PLFSS | |||
| 15130001507244 | L15/debats | 15 | 15130001507037 | 15130001507170 | 36 | Article 42 quaterdecies | 2364496 | PLFSS | PLFSS | |||
| 15130001507246 | L15/debats | 15 | 15130001507037 | 15130001507170 | 37 | Article 42 sexdecies A | 2364501 | PLFSS | PLFSS | |||
| 15130001507248 | L15/debats | 15 | 15130001507037 | 15130001507170 | 38 | Article 42 septdecies | 2364505 | PLFSS | PLFSS | |||
| 15130001507250 | L15/debats | 15 | 15130001507037 | 15130001507170 | 39 | Article 42 novodecies | 2364510 | PLFSS | PLFSS | |||
| 15130001507251 | L15/debats | 15 | 15130001507037 | 15130001507170 | 40 | Article 42 unvicies | 2364512 | PLFSS | PLFSS | |||
| 15130001507255 | L15/debats | 15 | 15130001507037 | 15130001507170 | 41 | Article 43 | 2364646 | PLFSS | PLFSS | |||
| 15130001507257 | L15/debats | 15 | 15130001507037 | 15130001507170 | 42 | Article 43 quater A | 2364667 | PLFSS | PLFSS | |||
| 15130001507259 | L15/debats | 15 | 15130001507037 | 15130001507170 | 43 | Article 43 quater B | 2364671 | PLFSS | PLFSS | |||
| 15130001507261 | L15/debats | 15 | 15130001507037 | 15130001507170 | 44 | Article 43 quater C | 2364675 | PLFSS | PLFSS | |||
| 15130001507263 | L15/debats | 15 | 15130001507037 | 15130001507170 | 45 | Article 43 quater D | 2364679 | PLFSS | PLFSS | |||
| 15130001507265 | L15/debats | 15 | 15130001507037 | 15130001507170 | 46 | Article 43 quater E | 2364683 | PLFSS | PLFSS | |||
| 15130001507267 | L15/debats | 15 | 15130001507037 | 15130001507170 | 47 | Article 43 quater F | 2364687 | PLFSS | PLFSS | |||
| 15130001507269 | L15/debats | 15 | 15130001507037 | 15130001507170 | 48 | Article 43 quater G | 2364691 | PLFSS | PLFSS | |||
| 15130001507271 | L15/debats | 15 | 15130001507037 | 15130001507170 | 49 | Article 43 septies A | 2364695 | PLFSS | PLFSS | |||
| 15130001507273 | L15/debats | 15 | 15130001507037 | 15130001507170 | 50 | Article 43 septies B | 2364699 | PLFSS | PLFSS | |||
| 15130001507275 | L15/debats | 15 | 15130001507037 | 15130001507170 | 51 | Article 43 septies C | 2364703 | PLFSS | PLFSS | |||
| 15130001507277 | L15/debats | 15 | 15130001507037 | 15130001507170 | 52 | Article 43 octies A | 2364717 | PLFSS | PLFSS | |||
| 15130001507279 | L15/debats | 15 | 15130001507037 | 15130001507170 | 53 | Article 43 octies B | 2364721 | PLFSS | PLFSS | |||
| 15130001507281 | L15/debats | 15 | 15130001507037 | 15130001507170 | 54 | Article 43 octies C | 2364725 | PLFSS | PLFSS | |||
| 15130001507283 | L15/debats | 15 | 15130001507037 | 15130001507170 | 55 | Article 43 octies | 2364729 | PLFSS | PLFSS | |||
| 15130001507285 | L15/debats | 15 | 15130001507037 | 15130001507170 | 56 | Article 43 undecies | 2364733 | PLFSS | PLFSS | |||
| 15130001507287 | L15/debats | 15 | 15130001507037 | 15130001507170 | 57 | Article 43 quaterdecies | 2364738 | PLFSS | PLFSS | |||
| 15130001507290 | L15/debats | 15 | 15130001507037 | 15130001507170 | 58 | Article 43 quindecies A | 2364748 | PLFSS | PLFSS |