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 |
|---|---|---|---|---|---|---|---|---|
| 16130000664871 | L16/debats | 16 | 16130000664819 | 16130000664868 | 3 | M. Roland Lescure, ministre délégué chargé de l’industrie et de l’énergie | 3400273 | |
| 16130000664872 | L16/debats | 16 | 16130000664819 | 16130000664868 | 4 | Amendements nos 6, 201, 77, 173, 300, 245, 52, 51, 70, 301, 83, 279, 84, 134, 2, 71, 302, 235, 280, 94, 169, 72, 246, 200, 303, 73, 74, 75, 88, 110, 176, 78, 79… | Amendements n<sup>os</sup> <lienAdt id_syceron="3400297"> 6</lienAdt>, <lienAdt id_syceron="3400323"> 201</lienAdt>, <lienAdt id_syceron="3400326"> 77</lienAdt>… | |
| 16130000664873 | L16/debats | 16 | 16130000664819 | 16130000664868 | 5 | M. Antoine Armand, rapporteur pour avis de la commission des affaires économiques | 3401774 | |
| 16130000664875 | L16/debats | 16 | 16130000664819 | 16130000664874 | 1 | Mme Delphine Batho | 3401783 | |
| 16130000664878 | L16/debats | 16 | 16130000664819 | 16130000664877 | 1 | Amendements nos 95, 132, 248, 85, 87, 175 rectifié, 97, 107 | Amendements n<sup>os</sup> <lienAdt id_syceron="3399466"> 95</lienAdt>, <lienAdt id_syceron="3399470"> 132</lienAdt>, <lienAdt id_syceron="3399540"> 248</lienAd… | |
| 16130000664880 | L16/debats | 16 | 16130000664819 | 16130000664879 | 1 | Amendements nos 137, 136 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400076"> 137</lienAdt>, <lienAdt id_syceron="3400085"> 136</lienAdt> | |
| 16130000664882 | L16/debats | 16 | 16130000664819 | 16130000664881 | 1 | Amendement no 306 | Amendement n<sup>o</sup> <lienAdt id_syceron="3400088"> 306</lienAdt> | |
| 16130000664884 | L16/debats | 16 | 16130000664819 | 16130000664883 | 1 | Amendements nos 90, 172, 251 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400092"> 90</lienAdt>, <lienAdt id_syceron="3400100"> 172</lienAdt>, <lienAdt id_syceron="3400114"> 251</lienAd… | |
| 16130000664886 | L16/debats | 16 | 16130000664819 | 16130000664885 | 1 | Amendement no 113 | Amendement n<sup>o</sup> <lienAdt id_syceron="3400682"> 113</lienAdt> | |
| 16130000664888 | L16/debats | 16 | 16130000664819 | 16130000664887 | 1 | Mme Anne Stambach-Terrenoir | 3400698 | |
| 16130000664889 | L16/debats | 16 | 16130000664819 | 16130000664887 | 2 | Amendements nos 9, 252, 309, 170, 285, 166, 286, 167, 287, 288, 289, 106 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400702"> 9</lienAdt>, <lienAdt id_syceron="3400703"> 252</lienAdt>, <lienAdt id_syceron="3400711"> 309</lienAdt… | |
| 16130000664890 | L16/debats | 16 | 16130000664819 | 16130000664887 | 3 | Sous-amendement no 341 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3401399"> 341</lienAdt> | |
| 16130000664891 | L16/debats | 16 | 16130000664819 | 16130000664887 | 4 | Amendements nos 294, 307, 308 | Amendements n<sup>os</sup> <lienAdt id_syceron="3401609"> 294</lienAdt>, <lienAdt id_syceron="3401611"> 307</lienAdt>, <lienAdt id_syceron="3401615"> 308</lienA… | |
| 16130000664893 | L16/debats | 16 | 16130000664819 | 16130000664892 | 1 | Amendement no 310 | Amendement n<sup>o</sup> <lienAdt id_syceron="3401622"> 310</lienAdt> | |
| 16130000664895 | L16/debats | 16 | 16130000664819 | 16130000664894 | 1 | Amendements nos 10, 99, 214, 139, 291, 100, 253, 101, 102, 178, 273, 231 | Amendements n<sup>os</sup> <lienAdt id_syceron="3401625"> 10</lienAdt>, <lienAdt id_syceron="3401629"> 99</lienAdt>, <lienAdt id_syceron="3401882"> 214</lienAdt… | |
| 16130000667299 | L16/debats | 16 | 16130000667294 | 16130000667298 | 1 | Amendements nos 91, 177, 325 | Amendements n<sup>os</sup> <lienAdt id_syceron="3399952"> 91</lienAdt>, <lienAdt id_syceron="3399967"> 177</lienAdt>, <lienAdt id_syceron="3399968"> 325</lienAd… | |
| 16130000667300 | L16/debats | 16 | 16130000667294 | 16130000667298 | 2 | M. Jean-Luc Fugit, rapporteur de la commission du développement durable et de l’aménagement du territoire | 3399972 | |
| 16130000667301 | L16/debats | 16 | 16130000667294 | 16130000667298 | 3 | M. Roland Lescure, ministre délégué chargé de l’industrie et de l’énergie | 3399975 | |
| 16130000667302 | L16/debats | 16 | 16130000667294 | 16130000667298 | 4 | Amendements nos 103, 118, 254, 161 | Amendements n<sup>os</sup> <lienAdt id_syceron="3399983"> 103</lienAdt>, <lienAdt id_syceron="3399985"> 118</lienAdt>, <lienAdt id_syceron="3399995"> 254</lienA… | |
| 16130000667304 | L16/debats | 16 | 16130000667294 | 16130000667303 | 1 | Amendements nos 105 rectifié, 98, 96 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400431"> 105 rectifié</lienAdt>, <lienAdt id_syceron="3400442"> 98</lienAdt>, <lienAdt id_syceron="3400454"> 96… | |
| 16130000667306 | L16/debats | 16 | 16130000667294 | 16130000667305 | 1 | Amendement no 185 | Amendement n<sup>o</sup> <lienAdt id_syceron="3400462"> 185</lienAdt> | |
| 16130000667309 | L16/debats | 16 | 16130000667294 | 16130000667308 | 1 | Amendements nos 4, 3 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400471"> 4, 3</lienAdt> | |
| 16130000667311 | L16/debats | 16 | 16130000667294 | 16130000667310 | 1 | Amendements nos 230, 274 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400486"> 230</lienAdt>, <lienAdt id_syceron="3400488"> 274</lienAdt> | |
| 16130000667313 | L16/debats | 16 | 16130000667294 | 16130000667312 | 1 | Amendements nos 11, 219, 255, 332 | Amendements n<sup>os</sup> <lienAdt id_syceron="3401031"> 11</lienAdt>, <lienAdt id_syceron="3401036"> 219</lienAdt>, <lienAdt id_syceron="3401042"> 255</lienAd… | |
| 16130000667315 | L16/debats | 16 | 16130000667294 | 16130000667314 | 1 | Amendements nos 12, 257, 326, 217, 63, 256, 186 | Amendements n<sup>os</sup> <lienAdt id_syceron="3401085"> 12</lienAdt>, <lienAdt id_syceron="3401088"> 257</lienAdt>, <lienAdt id_syceron="3401103"> 326</lienAd… | |
| 16130000667317 | L16/debats | 16 | 16130000667294 | 16130000667316 | 1 | Amendements nos 13, 138, 191, 259, 119, 284 (rectifié), 65, 147, 179, 187, 206, 258, 313, 66, 145, 180, 205, 327, 143, 64, 108, 260, 314, 121, 190, 122, 120, 12… | Amendements n<sup>os</sup> <lienAdt id_syceron="3401216"> 13</lienAdt>, <lienAdt id_syceron="3401219"> 138</lienAdt>, <lienAdt id_syceron="3401225"> 191</lienAd… | |
| 16130000667319 | L16/debats | 16 | 16130000667294 | 16130000667318 | 1 | Amendements nos 14, 124 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400241"> 14</lienAdt>, <lienAdt id_syceron="3400246"> 124</lienAdt> | |
| 16130000667321 | L16/debats | 16 | 16130000667294 | 16130000667320 | 1 | Amendement no 15 | Amendement n<sup>o</sup> <lienAdt id_syceron="3400257"> 15</lienAdt> | |
| 16130000667323 | L16/debats | 16 | 16130000667294 | 16130000667322 | 1 | Amendements nos 16, 153, 125, 290 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400261"> 16</lienAdt>, <lienAdt id_syceron="3400266"> 153</lienAdt>, <lienAdt id_syceron="3400270"> 125</lienAd… | |
| 16130000667325 | L16/debats | 16 | 16130000667294 | 16130000667324 | 1 | Amendements nos 17, 109, 261, 184, 236, 162, 67, 163, 182, 183 | Amendements n<sup>os</sup> <lienAdt id_syceron="3400354"> 17</lienAdt>, <lienAdt id_syceron="3400362"> 109</lienAdt>, <lienAdt id_syceron="3400364"> 261</lienAd… | |
| 16130000668615 | L16/debats | 16 | 16130000668576 | 16130000668614 | 1 | M. Charles Sitzenstuhl | 3401511 | |
| 16130000668616 | L16/debats | 16 | 16130000668576 | 16130000668614 | 2 | Mme Edwige Diaz | 3401515 | |
| 16130000668617 | L16/debats | 16 | 16130000668576 | 16130000668614 | 3 | M. François Ruffin | 3401520 | |
| 16130000668618 | L16/debats | 16 | 16130000668576 | 16130000668614 | 4 | M. Dominique Potier | 3401523 | |
| 16130000668619 | L16/debats | 16 | 16130000668576 | 16130000668614 | 5 | M. Charles Fournier | 3401528 | |
| 16130000668620 | L16/debats | 16 | 16130000668576 | 16130000668614 | 6 | Amendements nos 162, 85, 75, 116, 102, 43, 145, 203, 141, 171, 178, 187, 190 | Amendements n<sup>os</sup> <lienAdt id_syceron="3401529"> 162</lienAdt>, <lienAdt id_syceron="3401281"> 85</lienAdt>, <lienAdt id_syceron="3401287"> 75</lienAdt… | |
| 16130000668621 | L16/debats | 16 | 16130000668576 | 16130000668614 | 7 | Sous-amendements nos 204, 207 | Sous-amendements n<sup>os</sup> <lienAdt id_syceron="3401747"> 204</lienAdt>, <lienAdt id_syceron="3401688"> 207</lienAdt> | |
| 16130000668622 | L16/debats | 16 | 16130000668576 | 16130000668614 | 8 | Amendements nos 46, 173, 7, 10, 8, 9, 117, 125, 175, 140, 188, 191, 11, 12, 13, 14, 176, 144, 48, 91, 126, 183, 189, 192 | Amendements n<sup>os</sup> <lienAdt id_syceron="3401693"> 46</lienAdt>, <lienAdt id_syceron="3401694"> 173</lienAdt>, <lienAdt id_syceron="3401696"> 7, 10, 8, 9… | |
| 16130000668623 | L16/debats | 16 | 16130000668576 | 16130000668614 | 9 | Sous-amendement no 201 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3401847"> 201</lienAdt> | |
| 16130000668624 | L16/debats | 16 | 16130000668576 | 16130000668614 | 10 | Amendements nos 71, 163, 146, 51, 65 | Amendements n<sup>os</sup> <lienAdt id_syceron="3401867"> 71</lienAdt>, <lienAdt id_syceron="3401949"> 163</lienAdt>, <lienAdt id_syceron="3401957"> 146</lienAd… | |
| 16130000668626 | L16/debats | 16 | 16130000668576 | 16130000668625 | 1 | Amendements nos 42, 41, 137, 83, 186, 148, 134 | Amendements n<sup>os</sup> <lienAdt id_syceron="3401966"> 42, 41</lienAdt>, <lienAdt id_syceron="3401977"> 137</lienAdt>, <lienAdt id_syceron="3401981"> 83</lie… | |
| 16130000668629 | L16/debats | 16 | 16130000668576 | 16130000668628 | 1 | Amendements nos 100, 72, 181 | Amendements n<sup>os</sup> <lienAdt id_syceron="3402922"> 100</lienAdt>, <lienAdt id_syceron="3402703"> 72</lienAdt>, <lienAdt id_syceron="3402710"> 181</lienAd… | |
| 16130000668630 | L16/debats | 16 | 16130000668576 | 16130000668628 | 2 | Sous-amendement no 211 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3402715"> 211</lienAdt> | |
| 16130000668632 | L16/debats | 16 | 16130000668576 | 16130000668631 | 1 | M. Fabrice Le Vigoureux | 3402750 | |
| 16130000668633 | L16/debats | 16 | 16130000668576 | 16130000668631 | 2 | M. Antoine Vermorel-Marques | 3402755 | |
| 16130000669730 | L16/debats | 16 | 16130000669725 | 16130000669729 | 1 | Amendement no 177 | Amendement n<sup>o</sup> <lienAdt id_syceron="3403454"> 177</lienAdt> | |
| 16130000669731 | L16/debats | 16 | 16130000669725 | 16130000669729 | 2 | Mme Anne-Cécile Violland, rapporteure de la commission du développement durable et de l’aménagement du territoire | 3403461 | |
| 16130000669732 | L16/debats | 16 | 16130000669725 | 16130000669729 | 3 | M. Christophe Béchu, ministre de la transition écologique et de la cohésion des territoires | 3403463 | |
| 16130000669733 | L16/debats | 16 | 16130000669725 | 16130000669729 | 4 | Amendements nos 198, 169, 147, 157, 16, 17, 18, 149, 81, 124, 130, 1, 161, 150, 90, 3, 5, 88, 158, 143, 33, 57, 84, 112, 120, 167, 58, 87, 172, 195, 79, 114, 12… | Amendements n<sup>os</sup> <lienAdt id_syceron="3403470"> 198</lienAdt>, <lienAdt id_syceron="3403476"> 169</lienAdt>, <lienAdt id_syceron="3403478"> 147</lienA… | |
| 16130000669734 | L16/debats | 16 | 16130000669725 | 16130000669729 | 5 | Sous-amendement no 202 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3403675"> 202</lienAdt> |