debats.compte_rendu_sommaire1_sommaire2_sommaire3_para
Chemin compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para · présence : L17 74 %, L16 74 %, L15 76 %
46 400 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 | valeur | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para · présence : L17 74 %, L16 74 %, L15 76 % |
| 8 | id_syceron | BIGINT | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para.@id_syceron · présence : L17 72 %, L16 72 %, L15 74 % |
| 9 | xml | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para.#xml · présence : L17 72 %, L16 71 %, L15 72 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | valeur | id_syceron | xml |
|---|---|---|---|---|---|---|---|---|
| 16130000618974 | L16/debats | 16 | 16130000618946 | 16130000618973 | 1 | Mme Sophia Chikirou | 3354173 | |
| 16130000618975 | L16/debats | 16 | 16130000618946 | 16130000618973 | 2 | Mme la présidente | 3354177 | |
| 16130000618977 | L16/debats | 16 | 16130000618946 | 16130000618976 | 1 | Amendements nos 39, 59, 61, 66 | Amendements n<sup>os</sup> <lienAdt id_syceron="3354679"> 39</lienAdt>, <lienAdt id_syceron="3354693"> 59</lienAdt>, <lienAdt id_syceron="3354695"> 61</lienAdt>… | |
| 16130000618979 | L16/debats | 16 | 16130000618946 | 16130000618978 | 1 | Amendements nos 44, 43, 46, 8, 11, 24, 52, 12, 55 | Amendements n<sup>os</sup> <lienAdt id_syceron="3354717"> 44, 43</lienAdt>, <lienAdt id_syceron="3354741"> 46</lienAdt>, <lienAdt id_syceron="3354744"> 8</lienA… | |
| 16130000618980 | L16/debats | 16 | 16130000618946 | 16130000618978 | 2 | Sous-amendement no 84 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3354849"> 84</lienAdt> | |
| 16130000622277 | L16/debats | 16 | 16130000622260 | 16130000622276 | 1 | M. Pierre Meurin | 3357710 | |
| 16130000622278 | L16/debats | 16 | 16130000622260 | 16130000622276 | 2 | M. Antoine Léaument | 3357724 | |
| 16130000622279 | L16/debats | 16 | 16130000622260 | 16130000622276 | 3 | M. Michel Castellani | 3357735 | |
| 16130000622280 | L16/debats | 16 | 16130000622260 | 16130000622276 | 4 | Amendements nos 9, 1, 103, 37, 88, 54, 22, 89, 55, 51 | Amendements n<sup>os</sup> <lienAdt id_syceron="3357739"> 9</lienAdt>, <lienAdt id_syceron="3357744"> 1</lienAdt>, <lienAdt id_syceron="3357914"> 103</lienAdt>,… | |
| 16130000622281 | L16/debats | 16 | 16130000622260 | 16130000622276 | 5 | Sous-amendement no 107 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3357328"> 107</lienAdt> | |
| 16130000622282 | L16/debats | 16 | 16130000622260 | 16130000622276 | 6 | Amendements nos 44, 56, 65, 7, 57, 52 | Amendements n<sup>os</sup> <lienAdt id_syceron="3357340"> 44</lienAdt>, <lienAdt id_syceron="3357356"> 56</lienAdt>, <lienAdt id_syceron="3357358"> 65</lienAdt>… | |
| 16130000622283 | L16/debats | 16 | 16130000622260 | 16130000622276 | 7 | Sous-amendement no 108 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3357649"> 108</lienAdt> | |
| 16130000622284 | L16/debats | 16 | 16130000622260 | 16130000622276 | 8 | Amendements nos 58, 66, 59, 53, 63, 62, 106, 41, 42, 64, 93, 43, 61, 94, 96, 72, 14, 15, 16 | Amendements n<sup>os</sup> <lienAdt id_syceron="3357759"> 58, 66, 59</lienAdt>, <lienAdt id_syceron="3357660"> 53</lienAdt>, <lienAdt id_syceron="3357662"> 63, … | |
| 16130000623241 | L16/debats | 16 | 16130000623200 | 16130000623240 | 1 | Amendement no 92 | Amendement n<sup>o</sup> <lienAdt id_syceron="3358645">92</lienAdt> | |
| 16130000623242 | L16/debats | 16 | 16130000623200 | 16130000623240 | 2 | Mme Anne Brugnera, rapporteure de la commission des lois constitutionnelles, de la législation et de l’administration générale de la République | 3359172 | |
| 16130000623243 | L16/debats | 16 | 16130000623200 | 16130000623240 | 3 | M. Éric Dupond-Moretti, garde des sceaux, ministre de la justice | 3359175 | |
| 16130000623244 | L16/debats | 16 | 16130000623200 | 16130000623240 | 4 | Amendements nos 4, 5 | Amendements n<sup>os</sup> <lienAdt id_syceron="3359185">4, 5</lienAdt> | |
| 16130000623245 | L16/debats | 16 | 16130000623200 | 16130000623240 | 5 | M. Éric Pauget, rapporteur de la commission des lois constitutionnelles, de la législation et de l’administration générale de la République | 3359192 | |
| 16130000623248 | L16/debats | 16 | 16130000623200 | 16130000623247 | 1 | Amendement no 24, 6 rectifié | Amendement n<sup>o</sup> <lienAdt id_syceron="3359269"> 24</lienAdt>, <lienAdt id_syceron="3359868">6 rectifié</lienAdt> | |
| 16130000623250 | L16/debats | 16 | 16130000623200 | 16130000623249 | 1 | M. Pierre Meurin | 3359873 | |
| 16130000623251 | L16/debats | 16 | 16130000623200 | 16130000623249 | 2 | Amendement no 73, 74 rectifié | Amendement n<sup>o</sup> <lienAdt id_syceron="3359876">73</lienAdt>, <lienAdt id_syceron="3359878">74 rectifié</lienAdt> | |
| 16130000623253 | L16/debats | 16 | 16130000623200 | 16130000623252 | 1 | Amendement no 26, 75, 49, 76 | Amendement n<sup>o</sup> <lienAdt id_syceron="3359882">26</lienAdt>, <lienAdt id_syceron="3359888">75</lienAdt>, <lienAdt id_syceron="3359890">49</lienAdt>, <li… | |
| 16130000623255 | L16/debats | 16 | 16130000623200 | 16130000623254 | 1 | Amendement no 27, 97 | Amendement n<sup>o</sup> <lienAdt id_syceron="3359903">27</lienAdt>, <lienAdt id_syceron="3359937">97</lienAdt> | |
| 16130000623257 | L16/debats | 16 | 16130000623200 | 16130000623256 | 1 | Amendement no 28, 77 rectifié | Amendement n<sup>o</sup> <lienAdt id_syceron="3360106">28</lienAdt>, <lienAdt id_syceron="3360139">77 rectifié</lienAdt> | |
| 16130000623259 | L16/debats | 16 | 16130000623200 | 16130000623258 | 1 | Amendements nos 29, 78, 95, 71 | Amendements n<sup>os</sup> <lienAdt id_syceron="3360147">29</lienAdt>, <lienAdt id_syceron="3358760"> 78</lienAdt>, <lienAdt id_syceron="3358762"> 95</lienAdt>,… | |
| 16130000623263 | L16/debats | 16 | 16130000623200 | 16130000623262 | 1 | Amendement no 30, 80, 83, 13 | Amendement n<sup>o</sup> <lienAdt id_syceron="3358877">30</lienAdt>, <lienAdt id_syceron="3358879">80</lienAdt>, <lienAdt id_syceron="3358883">83</lienAdt>, <li… | |
| 16130000623265 | L16/debats | 16 | 16130000623200 | 16130000623264 | 1 | Amendement no 36, 105, 3 | Amendement n<sup>o</sup> <lienAdt id_syceron="3358897">36</lienAdt>, <lienAdt id_syceron="3358905">105</lienAdt>, <lienAdt id_syceron="3358914">3</lienAdt> | |
| 16130000623301 | L16/debats | 16 | 16130000623200 | 16130000623300 | 1 | Mme Mathilde Paris | 3359355 | |
| 16130000623302 | L16/debats | 16 | 16130000623200 | 16130000623300 | 2 | Mme Danièle Obono | 3359361 | |
| 16130000623303 | L16/debats | 16 | 16130000623200 | 16130000623300 | 3 | M. Laurent Esquenet-Goxes | 3359368 | |
| 16130000623306 | L16/debats | 16 | 16130000623200 | 16130000623305 | 1 | Amendement no 151, 102 | Amendement n<sup>o</sup> <lienAdt id_syceron="3359379">151</lienAdt>, <lienAdt id_syceron="3359393">102</lienAdt> | |
| 16130000623308 | L16/debats | 16 | 16130000623200 | 16130000623307 | 1 | Amendement no 94 | Amendement n<sup>o</sup> <lienAdt id_syceron="3359404">94</lienAdt> | |
| 16130000623311 | L16/debats | 16 | 16130000623200 | 16130000623310 | 1 | Amendements nos 12, 26, 137 | Amendements n<sup>os</sup> <lienAdt id_syceron="3359572">12</lienAdt>, <lienAdt id_syceron="3359575">26, 137</lienAdt> | |
| 16130000623313 | L16/debats | 16 | 16130000623200 | 16130000623312 | 1 | Mme Graziella Melchior | 3359592 | |
| 16130000623314 | L16/debats | 16 | 16130000623200 | 16130000623312 | 2 | Amendement no 131, 27, 132, 31 | Amendement n<sup>o</sup> <lienAdt id_syceron="3359596">131</lienAdt>, <lienAdt id_syceron="3359615">27</lienAdt>, <lienAdt id_syceron="3359635">132</lienAdt>, <… | |
| 16130000623316 | L16/debats | 16 | 16130000623200 | 16130000623315 | 1 | Amendement no 55, 57 | Amendement n<sup>o</sup> <lienAdt id_syceron="3359685">55</lienAdt>, <lienAdt id_syceron="3359687">57</lienAdt> | |
| 16130000623318 | L16/debats | 16 | 16130000623200 | 16130000623317 | 1 | Amendement no 18, 138, 143 | Amendement n<sup>o</sup> <lienAdt id_syceron="3359699">18</lienAdt>, <lienAdt id_syceron="3359701">138</lienAdt>, <lienAdt id_syceron="3359702">143</lienAdt> | |
| 16130000623320 | L16/debats | 16 | 16130000623200 | 16130000623319 | 1 | Amendement no 4 | Amendement n<sup>o</sup> <lienAdt id_syceron="3359723">4</lienAdt> | |
| 16130000623322 | L16/debats | 16 | 16130000623200 | 16130000623321 | 1 | Amendement no 106 | Amendement n<sup>o</sup> <lienAdt id_syceron="3360274">106</lienAdt> | |
| 16130000623324 | L16/debats | 16 | 16130000623200 | 16130000623323 | 1 | Amendements nos 5, 133, 134, 92 | Amendements n<sup>os</sup> <lienAdt id_syceron="3360301">5</lienAdt>, <lienAdt id_syceron="3360307"> 133, 134</lienAdt>, <lienAdt id_syceron="3360312"> 92</lien… | |
| 16130000623326 | L16/debats | 16 | 16130000623200 | 16130000623325 | 1 | Amendements nos 79, 140 | Amendements n<sup>os</sup> <lienAdt id_syceron="3360320">79</lienAdt>, <lienAdt id_syceron="3360322"> 140</lienAdt> | |
| 16130000623328 | L16/debats | 16 | 16130000623200 | 16130000623327 | 1 | Amendements nos 58 rectifié, 149, 100, 80, 84, 139, 142, 150 | Amendements n<sup>os</sup> <lienAdt id_syceron="3360332">58 rectifié</lienAdt>, <lienAdt id_syceron="3360334"> 149</lienAdt>, <lienAdt id_syceron="3361055"> 100… | |
| 16130000623330 | L16/debats | 16 | 16130000623200 | 16130000623329 | 1 | Amendements nos 147, 8 | Amendements n<sup>os</sup> <lienAdt id_syceron="3361090"> 147</lienAdt>, <lienAdt id_syceron="3361093"> 8</lienAdt> | |
| 16130000623332 | L16/debats | 16 | 16130000623200 | 16130000623331 | 1 | Mme Fabienne Colboc | 3361112 | |
| 16130000623333 | L16/debats | 16 | 16130000623200 | 16130000623331 | 2 | Amendements nos 62, 122 | Amendements n<sup>os</sup> <lienAdt id_syceron="3361119"> 62</lienAdt>, <lienAdt id_syceron="3361126"> 122</lienAdt> | |
| 16130000623335 | L16/debats | 16 | 16130000623200 | 16130000623334 | 1 | Amendements nos 144, 145, 53, 54, 52, 135 rectifié, 20, 146, 117 | Amendements n<sup>os</sup> <lienAdt id_syceron="3361468"> 144</lienAdt>, <lienAdt id_syceron="3361479"> 145</lienAdt>, <lienAdt id_syceron="3361487"> 53, 54, 52… | |
| 16130000623337 | L16/debats | 16 | 16130000623200 | 16130000623336 | 1 | Amendements nos 130, 24, 51, 108 | Amendements n<sup>os</sup> <lienAdt id_syceron="3361516"> 130</lienAdt>, <lienAdt id_syceron="3361521"> 24</lienAdt>, <lienAdt id_syceron="3361525"> 51</lienAdt… | |
| 16130000623339 | L16/debats | 16 | 16130000623200 | 16130000623338 | 1 | Amendement no 163 | Amendement n<sup>o</sup> <lienAdt id_syceron="3361678">163</lienAdt> | |
| 16130000623340 | L16/debats | 16 | 16130000623200 | 16130000623338 | 2 | Mme Isabelle Rauch, présidente de la commission des affaires culturelles et de l’éducation | 3361685 | |
| 16130000626331 | L16/debats | 16 | 16130000626326 | 16130000626330 | 1 | Amendements nos 31, 141 | Amendements n<sup>os</sup> <lienAdt id_syceron="3360389"> 31</lienAdt>, <lienAdt id_syceron="3360391"> 141</lienAdt> |