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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15130000794963 | L15/debats | 15 | 15130000794861 | 15130000794864 | 55 | Article 41 | 1658781 | |||||
| 15130000794967 | L15/debats | 15 | 15130000794861 | 15130000794864 | 56 | Article 42 bis A | 1658799 | |||||
| 15130000794968 | L15/debats | 15 | 15130000794861 | 15130000794864 | 57 | Article 42 bis | 1658801 | |||||
| 15130000794971 | L15/debats | 15 | 15130000794861 | 15130000794864 | 58 | Article 42 ter | 1660112 | |||||
| 15130000794973 | L15/debats | 15 | 15130000794861 | 15130000794864 | 59 | Article 42 quater | 1660117 | |||||
| 15130000794975 | L15/debats | 15 | 15130000794861 | 15130000794864 | 60 | Article 42 quinquies | 1660124 | |||||
| 15130000794977 | L15/debats | 15 | 15130000794861 | 15130000794864 | 61 | Article 43 | 1660132 | |||||
| 15130000794979 | L15/debats | 15 | 15130000794861 | 15130000794864 | 62 | Article 43 bis | 1660152 | |||||
| 15130000794980 | L15/debats | 15 | 15130000794861 | 15130000794864 | 63 | Article 43 ter | 1660154 | |||||
| 15130000794982 | L15/debats | 15 | 15130000794861 | 15130000794864 | 64 | Article 43 quater | 1660166 | |||||
| 15130000794983 | L15/debats | 15 | 15130000794861 | 15130000794864 | 65 | Article 43 quinquies | 1660168 | |||||
| 15130000794985 | L15/debats | 15 | 15130000794861 | 15130000794864 | 66 | Article 55 | 1660173 | |||||
| 15130000794990 | L15/debats | 15 | 15130000794861 | 15130000794864 | 67 | Article 55 bis | 1660261 | |||||
| 15130000794993 | L15/debats | 15 | 15130000794861 | 15130000794864 | 68 | Article 55 ter | 1659711 | |||||
| 15130000794995 | L15/debats | 15 | 15130000794861 | 15130000794864 | 69 | Article 56 | 1659719 | |||||
| 15130000794997 | L15/debats | 15 | 15130000794861 | 15130000794864 | 70 | Suspension et reprise de la séance | <italique>Suspension et reprise de la séance<br /></italique> | 1659726 | ||||
| 15130000794998 | L15/debats | 15 | 15130000794861 | 15130000794864 | 71 | Article 57 | 1659730 | |||||
| 15130000795002 | L15/debats | 15 | 15130000794861 | 15130000794864 | 72 | Article 57 bis C | 1659807 | |||||
| 15130000795004 | L15/debats | 15 | 15130000794861 | 15130000794864 | 73 | Article 57 bis DA | 1660502 | |||||
| 15130000795005 | L15/debats | 15 | 15130000794861 | 15130000794864 | 74 | Article 57 bis D | 1659817 | |||||
| 15130000795007 | L15/debats | 15 | 15130000794861 | 15130000794864 | 75 | Articles 57 bis et 58 | 1659841 | |||||
| 15130000795008 | L15/debats | 15 | 15130000794861 | 15130000794864 | 76 | Article 59 | 1659832 | |||||
| 15130000795010 | L15/debats | 15 | 15130000794861 | 15130000794864 | 77 | Article 59 ter | 1659872 | |||||
| 15130000795012 | L15/debats | 15 | 15130000794861 | 15130000794864 | 78 | Article 59 quater | 1659881 | |||||
| 15130000795013 | L15/debats | 15 | 15130000794861 | 15130000794864 | 79 | Article 60 | 1659883 | |||||
| 15130000795015 | L15/debats | 15 | 15130000794861 | 15130000794864 | 80 | Article 61 | 1659896 | |||||
| 15130000795019 | L15/debats | 15 | 15130000794861 | 15130000794864 | 81 | Article 61 bis | 1660504 | |||||
| 15130000795020 | L15/debats | 15 | 15130000794861 | 15130000794864 | 82 | Article 61 ter A | 1658627 | |||||
| 15130000795022 | L15/debats | 15 | 15130000794861 | 15130000794864 | 83 | Article 61 ter | 1658650 | |||||
| 15130000795024 | L15/debats | 15 | 15130000794861 | 15130000794864 | 84 | Article 61 quater | 1658663 | |||||
| 15130000795025 | L15/debats | 15 | 15130000794861 | 15130000794864 | 85 | Article 61 quinquies A | 1658665 | |||||
| 15130000795026 | L15/debats | 15 | 15130000794861 | 15130000794864 | 86 | Article 61 quinquies | 1658667 | |||||
| 15130000795029 | L15/debats | 15 | 15130000794861 | 15130000794864 | 87 | Article 61 sexies | 1658726 | |||||
| 15130000795030 | L15/debats | 15 | 15130000794861 | 15130000794864 | 88 | Suspension et reprise de la séance | <italique>Suspension et reprise de la séance<br /></italique> | 1658728 | ||||
| 15130000795031 | L15/debats | 15 | 15130000794861 | 15130000794864 | 89 | Article 61 septies | 1658732 | |||||
| 15130000795033 | L15/debats | 15 | 15130000794861 | 15130000794864 | 90 | Article 61 octies | 1658762 | |||||
| 15130000795034 | L15/debats | 15 | 15130000794861 | 15130000794864 | 91 | Article 61 nonies A | 1658764 | |||||
| 15130000795036 | L15/debats | 15 | 15130000794861 | 15130000794864 | 92 | Article 61 undecies | 1658836 | |||||
| 15130000795038 | L15/debats | 15 | 15130000794861 | 15130000794864 | 93 | Article 61 duodecies | 1660506 | |||||
| 15130000795039 | L15/debats | 15 | 15130000794861 | 15130000794864 | 94 | Article 61 terdecies | 1658847 | |||||
| 15130000795040 | L15/debats | 15 | 15130000794861 | 15130000794864 | 95 | Article 61 quaterdecies | 1658849 | |||||
| 15130000795042 | L15/debats | 15 | 15130000794861 | 15130000794864 | 96 | Article 62 | 1658855 | |||||
| 15130000795044 | L15/debats | 15 | 15130000794861 | 15130000794864 | 97 | Article 62 bis A | 1658927 | |||||
| 15130000795045 | L15/debats | 15 | 15130000794861 | 15130000794864 | 98 | Article 62 bis | 1658929 | |||||
| 15130000795047 | L15/debats | 15 | 15130000794861 | 15130000794864 | 99 | Article 62 ter | 1658934 | |||||
| 15130000795049 | L15/debats | 15 | 15130000794861 | 15130000794864 | 100 | Article 62 quinquies A | 1659047 | |||||
| 15130000795051 | L15/debats | 15 | 15130000794861 | 15130000794864 | 101 | Article 62 sexies | 1659067 | |||||
| 15130000795053 | L15/debats | 15 | 15130000794861 | 15130000794864 | 102 | Article 62 septies | 1659082 | |||||
| 15130000795055 | L15/debats | 15 | 15130000794861 | 15130000794864 | 103 | Article 63 | 1659094 | |||||
| 15130000795056 | L15/debats | 15 | 15130000794861 | 15130000794864 | 104 | Article 63 bis A | 1659096 |