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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15130001503196 | L15/debats | 15 | 15130001503143 | 15130001503177 | 10 | Article 2 quater D | 2358174 | |||||
| 15130001503198 | L15/debats | 15 | 15130001503143 | 15130001503177 | 11 | Article 2 sexies | 2358267 | |||||
| 15130001503199 | L15/debats | 15 | 15130001503143 | 15130001503177 | 12 | Article 3 | 2358180 | |||||
| 15130001505555 | L15/debats | 15 | 15130001505473 | 15130001505552 | 1 | Suspension et reprise de la séance | <italique>Suspension et reprise de la séance</italique> | 2359918 | ||||
| 15130001505576 | L15/debats | 15 | 15130001505473 | 15130001505575 | 1 | Article 4 nonies | 2359862 | |||||
| 15130001505583 | L15/debats | 15 | 15130001505473 | 15130001505575 | 2 | Article 5 bis | 2359892 | |||||
| 15130001505584 | L15/debats | 15 | 15130001505473 | 15130001505575 | 3 | Article 7 | 2359894 | |||||
| 15130001505586 | L15/debats | 15 | 15130001505473 | 15130001505575 | 4 | Article 7 bis | 2359982 | |||||
| 15130001505588 | L15/debats | 15 | 15130001505473 | 15130001505575 | 5 | Article 8 | 2359986 | |||||
| 15130001505590 | L15/debats | 15 | 15130001505473 | 15130001505575 | 6 | Article 8 quater | 2360155 | |||||
| 15130001505592 | L15/debats | 15 | 15130001505473 | 15130001505575 | 7 | Article 8 quinquies A | 2360159 | |||||
| 15130001505594 | L15/debats | 15 | 15130001505473 | 15130001505575 | 8 | Article 8 quinquies B | 2360164 | |||||
| 15130001505596 | L15/debats | 15 | 15130001505473 | 15130001505575 | 9 | Article 8 quinquies C | 2360169 | |||||
| 15130001505598 | L15/debats | 15 | 15130001505473 | 15130001505575 | 10 | Article 8 quinquies D | 2360174 | |||||
| 15130001505600 | L15/debats | 15 | 15130001505473 | 15130001505575 | 11 | Article 8 sexies A | 2360179 | |||||
| 15130001505602 | L15/debats | 15 | 15130001505473 | 15130001505575 | 12 | Article 8 sexies B | 2360183 | |||||
| 15130001505604 | L15/debats | 15 | 15130001505473 | 15130001505575 | 13 | Article 8 septies A | 2360187 | |||||
| 15130001505606 | L15/debats | 15 | 15130001505473 | 15130001505575 | 14 | Article 8 septies B | 2360192 | |||||
| 15130001505608 | L15/debats | 15 | 15130001505473 | 15130001505575 | 15 | Article 8 septies C | 2360196 | |||||
| 15130001505610 | L15/debats | 15 | 15130001505473 | 15130001505575 | 16 | Articles 8 septies D et 8 octies A | 2360201 | |||||
| 15130001505611 | L15/debats | 15 | 15130001505473 | 15130001505575 | 17 | Article 9 | 2360203 | |||||
| 15130001505614 | L15/debats | 15 | 15130001505473 | 15130001505575 | 18 | Article 9 bis A | 2360380 | |||||
| 15130001505615 | L15/debats | 15 | 15130001505473 | 15130001505575 | 19 | Article 9 bis B | 2360382 | |||||
| 15130001505617 | L15/debats | 15 | 15130001505473 | 15130001505575 | 20 | Article 9 bis C | 2360402 | |||||
| 15130001505619 | L15/debats | 15 | 15130001505473 | 15130001505575 | 21 | Article 9 bis D | 2360408 | |||||
| 15130001505621 | L15/debats | 15 | 15130001505473 | 15130001505575 | 22 | Article 9 bis E | 2360411 | |||||
| 15130001505623 | L15/debats | 15 | 15130001505473 | 15130001505575 | 23 | Article 9 ter | 2360421 | |||||
| 15130001505625 | L15/debats | 15 | 15130001505473 | 15130001505575 | 24 | Article 9 quinquies | 2360433 | |||||
| 15130001505627 | L15/debats | 15 | 15130001505473 | 15130001505575 | 25 | Article 9 sexies | 2360445 | |||||
| 15130001505629 | L15/debats | 15 | 15130001505473 | 15130001505575 | 26 | Article 9 septies | 2360449 | |||||
| 15130001505631 | L15/debats | 15 | 15130001505473 | 15130001505575 | 27 | Article 9 octies | 2360452 | |||||
| 15130001505633 | L15/debats | 15 | 15130001505473 | 15130001505575 | 28 | Article 9 nonies | 2360458 | |||||
| 15130001505635 | L15/debats | 15 | 15130001505473 | 15130001505575 | 29 | Article 9 decies | 2360461 | |||||
| 15130001505637 | L15/debats | 15 | 15130001505473 | 15130001505575 | 30 | Article 9 undecies | 2360464 | |||||
| 15130001505638 | L15/debats | 15 | 15130001505473 | 15130001505575 | 31 | Article 9 duodecies | 2360591 | |||||
| 15130001507040 | L15/debats | 15 | 15130001507037 | 15130001507039 | 1 | Article 9 terdecies | 2360272 | PLFSS | PLFSS | |||
| 15130001507044 | L15/debats | 15 | 15130001507037 | 15130001507039 | 2 | Article 9 quaterdecies | 2360283 | PLFSS | PLFSS | |||
| 15130001507046 | L15/debats | 15 | 15130001507037 | 15130001507039 | 3 | Article 12 | 2360288 | PLFSS | PLFSS | |||
| 15130001507048 | L15/debats | 15 | 15130001507037 | 15130001507039 | 4 | Article 12 bis | 2360306 | PLFSS | PLFSS | |||
| 15130001507050 | L15/debats | 15 | 15130001507037 | 15130001507039 | 5 | Article 13 | 2360314 | PLFSS | PLFSS | |||
| 15130001507053 | L15/debats | 15 | 15130001507037 | 15130001507039 | 6 | Article 13 bis | 2360334 | PLFSS | PLFSS | |||
| 15130001507055 | L15/debats | 15 | 15130001507037 | 15130001507039 | 7 | Article 14 | 2360338 | PLFSS | PLFSS | |||
| 15130001507061 | L15/debats | 15 | 15130001507037 | 15130001507039 | 8 | Article 14 bis A | 2360513 | PLFSS | PLFSS | |||
| 15130001507063 | L15/debats | 15 | 15130001507037 | 15130001507039 | 9 | Article 14 bis B | 2360517 | PLFSS | PLFSS | |||
| 15130001507065 | L15/debats | 15 | 15130001507037 | 15130001507039 | 10 | Article 14 ter | 2360524 | PLFSS | PLFSS | |||
| 15130001507067 | L15/debats | 15 | 15130001507037 | 15130001507039 | 11 | Article 14 quater | 2360535 | PLFSS | PLFSS | |||
| 15130001507069 | L15/debats | 15 | 15130001507037 | 15130001507039 | 12 | Article 15 | 2360539 | PLFSS | PLFSS | |||
| 15130001507073 | L15/debats | 15 | 15130001507037 | 15130001507039 | 13 | Article 15 bis A | 2360705 | PLFSS | PLFSS | |||
| 15130001507075 | L15/debats | 15 | 15130001507037 | 15130001507039 | 14 | Article 15 bis B | 2360719 | PLFSS | PLFSS | |||
| 15130001507078 | L15/debats | 15 | 15130001507037 | 15130001507039 | 15 | Article 15 bis C | 2360661 | PLFSS | PLFSS |