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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15130000705113 | L15/debats | 15 | 15130000704956 | 15130000705009 | 29 | Article 2 bis | 1570854 | |||||
| 15130000705114 | L15/debats | 15 | 15130000704956 | 15130000705009 | 30 | Article 2 quinquies | 1570856 | |||||
| 15130000705116 | L15/debats | 15 | 15130000704956 | 15130000705009 | 31 | Article 2 sexies A | 1570861 | |||||
| 15130000705118 | L15/debats | 15 | 15130000704956 | 15130000705009 | 32 | Article 2 sexies | 1570865 | |||||
| 15130000705120 | L15/debats | 15 | 15130000704956 | 15130000705009 | 33 | Article 2 septies | 1570869 | |||||
| 15130000705122 | L15/debats | 15 | 15130000704956 | 15130000705009 | 34 | Article 2 octies A | 1570472 | |||||
| 15130000705125 | L15/debats | 15 | 15130000704956 | 15130000705009 | 35 | Article 2 octies | 1570489 | |||||
| 15130000705127 | L15/debats | 15 | 15130000704956 | 15130000705009 | 36 | Article 2 nonies | Article 2 nonies <italique> </italique> | 1570494 | ||||
| 15130000705129 | L15/debats | 15 | 15130000704956 | 15130000705009 | 37 | Article 2 decies | Article 2 decies <italique> </italique> | 1570499 | ||||
| 15130000705131 | L15/debats | 15 | 15130000704956 | 15130000705009 | 38 | Article 3 | Article 3 <italique> </italique> | 1570522 | ||||
| 15130000705139 | L15/debats | 15 | 15130000704956 | 15130000705009 | 39 | Article 3 bis A | 1571275 | |||||
| 15130000705141 | L15/debats | 15 | 15130000704956 | 15130000705009 | 40 | Article 3 bis B | 1571283 | |||||
| 15130000705143 | L15/debats | 15 | 15130000704956 | 15130000705009 | 41 | Article 3 bis | 1571287 | |||||
| 15130000705145 | L15/debats | 15 | 15130000704956 | 15130000705009 | 42 | Article 3 quater | 1571324 | |||||
| 15130000705147 | L15/debats | 15 | 15130000704956 | 15130000705009 | 43 | Article 4 | 1571345 | |||||
| 15130000707342 | L15/debats | 15 | 15130000707338 | 15130000707341 | 1 | Article 4 bis | 1571474 | |||||
| 15130000707346 | L15/debats | 15 | 15130000707338 | 15130000707341 | 2 | Article 5 | 1571480 | |||||
| 15130000707348 | L15/debats | 15 | 15130000707338 | 15130000707341 | 3 | Article 6 | 1571500 | |||||
| 15130000707350 | L15/debats | 15 | 15130000707338 | 15130000707341 | 4 | Article 6 bis A | 1571510 | |||||
| 15130000707351 | L15/debats | 15 | 15130000707338 | 15130000707341 | 5 | Article 7 | 1571512 | |||||
| 15130000707353 | L15/debats | 15 | 15130000707338 | 15130000707341 | 6 | Article 8 | 1570956 | |||||
| 15130000707355 | L15/debats | 15 | 15130000707338 | 15130000707341 | 7 | Article 8 bis | 1570967 | |||||
| 15130000707357 | L15/debats | 15 | 15130000707338 | 15130000707341 | 8 | Article 8 ter | 1570971 | |||||
| 15130000707359 | L15/debats | 15 | 15130000707338 | 15130000707341 | 9 | Article 8 quater | 1570976 | |||||
| 15130000707361 | L15/debats | 15 | 15130000707338 | 15130000707341 | 10 | Article 9 | 1570980 | |||||
| 15130000707365 | L15/debats | 15 | 15130000707338 | 15130000707341 | 11 | Article 9 bis | 1571009 | |||||
| 15130000707367 | L15/debats | 15 | 15130000707338 | 15130000707341 | 12 | Article 9 ter | Article 9 <italique>ter</italique> | 1571173 | ||||
| 15130000707368 | L15/debats | 15 | 15130000707338 | 15130000707341 | 13 | Article 10 | 1576046 | |||||
| 15130000707369 | L15/debats | 15 | 15130000707338 | 15130000707341 | 14 | Article 10 bis | Article 10 <italique>bis</italique> | 1571175 | ||||
| 15130000707370 | L15/debats | 15 | 15130000707338 | 15130000707341 | 15 | Article 10 | 1576377 | |||||
| 15130000707371 | L15/debats | 15 | 15130000707338 | 15130000707341 | 16 | Article 11 | 1571177 | |||||
| 15130000707374 | L15/debats | 15 | 15130000707338 | 15130000707341 | 17 | Article 11 bis A | Article 11 <italique>bis </italique>A | 1571205 | ||||
| 15130000707376 | L15/debats | 15 | 15130000707338 | 15130000707341 | 18 | Article 11 bis B | Article 11 <italique>bis </italique>B | 1571209 | ||||
| 15130000707378 | L15/debats | 15 | 15130000707338 | 15130000707341 | 19 | Article 11 bis C | Article 11 <italique>bis </italique>C | 1571213 | ||||
| 15130000707380 | L15/debats | 15 | 15130000707338 | 15130000707341 | 20 | Article 22 bis A | Article 22 <italique>bis </italique>A | 1571217 | ||||
| 15130000707382 | L15/debats | 15 | 15130000707338 | 15130000707341 | 21 | Article 22 ter A | Article 22 <italique>ter </italique>A | 1571225 | ||||
| 15130000707384 | L15/debats | 15 | 15130000707338 | 15130000707341 | 22 | Article 22 ter B | Article 22 <italique>ter </italique>B | 1571229 | ||||
| 15130000707386 | L15/debats | 15 | 15130000707338 | 15130000707341 | 23 | Article 22 ter C | Article 22 <italique>ter </italique>C | 1571233 | ||||
| 15130000707388 | L15/debats | 15 | 15130000707338 | 15130000707341 | 24 | Article 22 ter D | Article 22 <italique>ter </italique>D | 1571237 | ||||
| 15130000707390 | L15/debats | 15 | 15130000707338 | 15130000707341 | 25 | Article 22 ter E | Article 22 <italique>ter </italique>E | 1571241 | ||||
| 15130000707392 | L15/debats | 15 | 15130000707338 | 15130000707341 | 26 | Article 23 | 1571245 | |||||
| 15130000707401 | L15/debats | 15 | 15130000707338 | 15130000707341 | 27 | Article 23 bis | 1571944 | |||||
| 15130000707403 | L15/debats | 15 | 15130000707338 | 15130000707341 | 28 | Article 24 | 1574088 | |||||
| 15130000707406 | L15/debats | 15 | 15130000707338 | 15130000707341 | 29 | Article 25 | 1574107 | |||||
| 15130000707408 | L15/debats | 15 | 15130000707338 | 15130000707341 | 30 | Article 25 bis A | Article 25 <italique>bis</italique> A | 1574141 | ||||
| 15130000707413 | L15/debats | 15 | 15130000707338 | 15130000707341 | 31 | Article 26 bis | 1574283 | |||||
| 15130000707416 | L15/debats | 15 | 15130000707338 | 15130000707341 | 32 | Article 27 | 1574301 | |||||
| 15130000707418 | L15/debats | 15 | 15130000707338 | 15130000707341 | 33 | Article 28 | 1574312 | |||||
| 15130000707420 | L15/debats | 15 | 15130000707338 | 15130000707341 | 34 | Article 29 | 1574323 | |||||
| 15130000707422 | L15/debats | 15 | 15130000707338 | 15130000707341 | 35 | Suspension et reprise de la séance | <italique>Suspension et reprise de la séance<br /></italique> | 1574608 |