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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15130000707640 | L15/debats | 15 | 15130000707338 | 15130000707462 | 88 | Article 60 bis | 1572974 | |||||
| 15130000707642 | L15/debats | 15 | 15130000707338 | 15130000707462 | 89 | Article 60 quinquies A | 1572985 | |||||
| 15130000707643 | L15/debats | 15 | 15130000707338 | 15130000707462 | 90 | Article 60 quinquies | 1572987 | |||||
| 15130000707645 | L15/debats | 15 | 15130000707338 | 15130000707462 | 91 | Article 61 bis | 1572991 | |||||
| 15130000707647 | L15/debats | 15 | 15130000707338 | 15130000707462 | 92 | Article 62 bis | 1572995 | |||||
| 15130000707648 | L15/debats | 15 | 15130000707338 | 15130000707462 | 93 | Article 63 quater A | 1572997 | |||||
| 15130000707650 | L15/debats | 15 | 15130000707338 | 15130000707462 | 94 | Article 63 quater B | 1573001 | |||||
| 15130000707652 | L15/debats | 15 | 15130000707338 | 15130000707462 | 95 | Article 63 sexies | 1573005 | |||||
| 15130000707653 | L15/debats | 15 | 15130000707338 | 15130000707462 | 96 | Article 63 septies | 1573007 | |||||
| 15130000707655 | L15/debats | 15 | 15130000707338 | 15130000707462 | 97 | Article 64 bis | 1573011 | |||||
| 15130000707656 | L15/debats | 15 | 15130000707338 | 15130000707462 | 98 | Article 64 ter | 1573013 | |||||
| 15130000707658 | L15/debats | 15 | 15130000707338 | 15130000707462 | 99 | Article 65 bis | Article 65 <italique>bis</italique> | 1573050 | ||||
| 15130000707660 | L15/debats | 15 | 15130000707338 | 15130000707462 | 100 | Article 71 quater A | Article 71 <italique>quater </italique>A | 1573054 | ||||
| 15130000707661 | L15/debats | 15 | 15130000707338 | 15130000707462 | 101 | Article 71 quater B | Article 71 <italique>quater </italique>B | 1573056 | ||||
| 15130000707663 | L15/debats | 15 | 15130000707338 | 15130000707462 | 102 | Article 71 quater | Article 71 <italique>quater</italique> | 1573061 | ||||
| 15130000707665 | L15/debats | 15 | 15130000707338 | 15130000707462 | 103 | Article 74 bis A | Article 74 <italique>bis </italique>A | 1573068 | ||||
| 15130000707666 | L15/debats | 15 | 15130000707338 | 15130000707462 | 104 | Article 74 bis | Article 74 <italique>bis</italique> | 1573070 | ||||
| 15130000707668 | L15/debats | 15 | 15130000707338 | 15130000707462 | 105 | Article 74 terA | Article 74 ter<italique />A | 1573084 | ||||
| 15130000707670 | L15/debats | 15 | 15130000707338 | 15130000707462 | 106 | Article 74 quinquies | 1573088 | |||||
| 15130000707671 | L15/debats | 15 | 15130000707338 | 15130000707462 | 107 | Article 74 sexies | 1573090 | |||||
| 15130000707673 | L15/debats | 15 | 15130000707338 | 15130000707462 | 108 | Article 74 octies | 1573095 | |||||
| 15130000707674 | L15/debats | 15 | 15130000707338 | 15130000707462 | 109 | Article 76 | 1573097 | |||||
| 15130000707679 | L15/debats | 15 | 15130000707338 | 15130000707462 | 110 | Rappel au règlement | <italique>Rappel au règlement<br /></italique> | 1574238 | ||||
| 15130000707682 | L15/debats | 15 | 15130000707338 | 15130000707462 | 111 | Article 76 (suite) | Article 76 <italique>(suite)</italique> | 1574248 | ||||
| 15130000707683 | L15/debats | 15 | 15130000707338 | 15130000707462 | 112 | Article 76 quinquies | 1574256 | |||||
| 15130000707685 | L15/debats | 15 | 15130000707338 | 15130000707462 | 113 | Article 76 sexies | 1574261 | |||||
| 15130000707687 | L15/debats | 15 | 15130000707338 | 15130000707462 | 114 | Article 77 bis A | 1574269 | |||||
| 15130000707689 | L15/debats | 15 | 15130000707338 | 15130000707462 | 115 | Article 77 quater A | 1573492 | |||||
| 15130000707690 | L15/debats | 15 | 15130000707338 | 15130000707462 | 116 | Article 77 quater | 1573494 | |||||
| 15130000707692 | L15/debats | 15 | 15130000707338 | 15130000707462 | 117 | Article 78 bis A | 1573499 | |||||
| 15130000707693 | L15/debats | 15 | 15130000707338 | 15130000707462 | 118 | Article 79 | 1573501 | |||||
| 15130000707695 | L15/debats | 15 | 15130000707338 | 15130000707462 | 119 | Article 79 bis A | 1573550 | |||||
| 15130000707697 | L15/debats | 15 | 15130000707338 | 15130000707462 | 120 | Article 79 bis B | 1573554 | |||||
| 15130000707699 | L15/debats | 15 | 15130000707338 | 15130000707462 | 121 | Article 79 bis | 1573558 | |||||
| 15130000707701 | L15/debats | 15 | 15130000707338 | 15130000707462 | 122 | Article 79 ter | 1573565 | |||||
| 15130000707703 | L15/debats | 15 | 15130000707338 | 15130000707462 | 123 | Article 79 quinquies | 1573570 | |||||
| 15130000707705 | L15/debats | 15 | 15130000707338 | 15130000707462 | 124 | Article 79 septies | 1573575 | |||||
| 15130000707707 | L15/debats | 15 | 15130000707338 | 15130000707462 | 125 | Article 79 octies | 1573580 | |||||
| 15130000707709 | L15/debats | 15 | 15130000707338 | 15130000707462 | 126 | Article 81 | 1573588 | |||||
| 15130000707711 | L15/debats | 15 | 15130000707338 | 15130000707462 | 127 | Article 81 ter | 1573618 | |||||
| 15130000707713 | L15/debats | 15 | 15130000707338 | 15130000707462 | 128 | Article 81 quater A | 1573638 | |||||
| 15130000707715 | L15/debats | 15 | 15130000707338 | 15130000707462 | 129 | Article 81 quater B | 1573643 | |||||
| 15130000707718 | L15/debats | 15 | 15130000707338 | 15130000707462 | 130 | Article 81 sexies | 1573662 | |||||
| 15130000707719 | L15/debats | 15 | 15130000707338 | 15130000707462 | 131 | Article 82 | 1573664 | |||||
| 15130000707720 | L15/debats | 15 | 15130000707338 | 15130000707462 | 132 | Article 83 | 1573666 | |||||
| 15130000707722 | L15/debats | 15 | 15130000707338 | 15130000707462 | 133 | Article 83 quinquies A | 1573669 | |||||
| 15130000707724 | L15/debats | 15 | 15130000707338 | 15130000707462 | 134 | Articles 83 quinquies et 84 quater | 1573679 | |||||
| 15130000707725 | L15/debats | 15 | 15130000707338 | 15130000707462 | 135 | Article 84 quinquies | 1573681 | |||||
| 15130000707727 | L15/debats | 15 | 15130000707338 | 15130000707462 | 136 | Article 85 | 1573685 | |||||
| 15130000712750 | L15/debats | 15 | 15130000712703 | 15130000712747 | 1 | Suspension et reprise de la séance | <italique>Suspension et reprise de la séance<br /></italique> | 1575209 |