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 |
|---|---|---|---|---|---|---|---|---|
| 16130000366253 | L16/debats | 16 | 16130000366196 | 16130000366251 | 2 | M. le président | 3072524 | |
| 16130000366255 | L16/debats | 16 | 16130000366196 | 16130000366254 | 1 | Amendements nos 98, 18 | Amendements n<sup>os</sup> <lienAdt id_syceron="3072370"> 98</lienAdt>, <lienAdt id_syceron="3072372"> 18</lienAdt> | |
| 16130000366257 | L16/debats | 16 | 16130000366196 | 16130000366256 | 1 | M. William Martinet | 3072398 | |
| 16130000366258 | L16/debats | 16 | 16130000366196 | 16130000366256 | 2 | M. le président | 3072402 | |
| 16130000366260 | L16/debats | 16 | 16130000366196 | 16130000366259 | 1 | Amendements nos 25, 39 | Amendements n<sup>os</sup> <lienAdt id_syceron="3072406"> 25</lienAdt>, <lienAdt id_syceron="3072423"> 39</lienAdt> | |
| 16130000366262 | L16/debats | 16 | 16130000366196 | 16130000366261 | 1 | Amendement no 26 | Amendement n<sup>o</sup> <lienAdt id_syceron="3072750"> 26</lienAdt> | |
| 16130000366264 | L16/debats | 16 | 16130000366196 | 16130000366263 | 1 | M. Emmanuel Taché de la Pagerie | 3072784 | |
| 16130000366265 | L16/debats | 16 | 16130000366196 | 16130000366263 | 2 | M. Éric Coquerel | 3072788 | |
| 16130000366266 | L16/debats | 16 | 16130000366196 | 16130000366263 | 3 | Mme Annie Genevard | 3072796 | |
| 16130000366267 | L16/debats | 16 | 16130000366196 | 16130000366263 | 4 | M. Paul Midy | 3072815 | |
| 16130000366268 | L16/debats | 16 | 16130000366196 | 16130000366263 | 5 | Amendements nos 27, 40, 69, 113, 136 | Amendements n<sup>os</sup> <lienAdt id_syceron="3072826"> 27</lienAdt>, <lienAdt id_syceron="3072835"> 40</lienAdt>, <lienAdt id_syceron="3073321"> 69</lienAdt>… | |
| 16130000368445 | L16/debats | 16 | 16130000368440 | 16130000368444 | 1 | Amendement no 28 | Amendement n<sup>o</sup> <lienAdt id_syceron="3071801"> 28</lienAdt> | |
| 16130000368446 | L16/debats | 16 | 16130000368440 | 16130000368444 | 2 | M. Guillaume Kasbarian, rapporteur de la commission des affaires économiques | 3071803 | |
| 16130000368447 | L16/debats | 16 | 16130000368440 | 16130000368444 | 3 | M. Olivier Klein, ministre délégué chargé de la ville et du logement | 3071805 | |
| 16130000368448 | L16/debats | 16 | 16130000368440 | 16130000368444 | 4 | Amendements nos 11, 107, 20, 12, 147 rectifié, 16, 121 | Amendements n<sup>os</sup> <lienAdt id_syceron="3071808"> 11</lienAdt>, <lienAdt id_syceron="3071810"> 107</lienAdt>, <lienAdt id_syceron="3071821"> 20</lienAdt… | |
| 16130000368450 | L16/debats | 16 | 16130000368440 | 16130000368449 | 1 | Mme Annie Genevard | 3072178 | |
| 16130000368451 | L16/debats | 16 | 16130000368440 | 16130000368449 | 2 | Amendements nos 29, 42, 72, 137, 70, 144, 145, 71, 122 | Amendements n<sup>os</sup> <lienAdt id_syceron="3072179"> 29</lienAdt>, <lienAdt id_syceron="3072236"> 42</lienAdt>, <lienAdt id_syceron="3072241"> 72</lienAdt>… | |
| 16130000368453 | L16/debats | 16 | 16130000368440 | 16130000368452 | 1 | Amendements nos 75, 139, 30, 43, 74, 138, 10, 44 | Amendements n<sup>os</sup> <lienAdt id_syceron="3072699"> 75</lienAdt>, <lienAdt id_syceron="3072705"> 139</lienAdt>, <lienAdt id_syceron="3071926"> 30</lienAdt… | |
| 16130000368454 | L16/debats | 16 | 16130000368440 | 16130000368452 | 2 | Sous-amendement no 151 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3071968"> 151</lienAdt> | |
| 16130000368456 | L16/debats | 16 | 16130000368440 | 16130000368455 | 1 | Amendement no 76 | Amendement n<sup>o</sup> <lienAdt id_syceron="3071979"> 76</lienAdt> | |
| 16130000368458 | L16/debats | 16 | 16130000368440 | 16130000368457 | 1 | M. François Piquemal | 3071983 | |
| 16130000368459 | L16/debats | 16 | 16130000368440 | 16130000368457 | 2 | Amendements nos 17, 31, 78, 140, 77, 141, 6, 32, 45, 123, 46, 97, 149, 21 | Amendements n<sup>os</sup> <lienAdt id_syceron="3072303"> 17</lienAdt>, <lienAdt id_syceron="3072309"> 31</lienAdt>, <lienAdt id_syceron="3072313"> 78</lienAdt>… | |
| 16130000368461 | L16/debats | 16 | 16130000368440 | 16130000368460 | 1 | M. Michel Castellani | 3072554 | |
| 16130000368462 | L16/debats | 16 | 16130000368440 | 16130000368460 | 2 | Mme Danielle Simonnet | 3072558 | |
| 16130000368463 | L16/debats | 16 | 16130000368440 | 16130000368460 | 3 | Amendements nos 3, 33, 47, 81, 130, 79, 50, 131, 34, 49 rectifié, 35, 80, 142 | Amendements n<sup>os</sup> <lienAdt id_syceron="3072563"> 3</lienAdt>, <lienAdt id_syceron="3072568"> 33</lienAdt>, <lienAdt id_syceron="3072572"> 47</lienAdt>,… | |
| 16130000368465 | L16/debats | 16 | 16130000368440 | 16130000368464 | 1 | M. François Piquemal | 3073261 | |
| 16130000368466 | L16/debats | 16 | 16130000368440 | 16130000368464 | 2 | Amendements nos 51, 7, 82, 83, 84 | Amendements n<sup>os</sup> <lienAdt id_syceron="3073443"> 51</lienAdt>, <lienAdt id_syceron="3073456"> 7</lienAdt>, <lienAdt id_syceron="3073461"> 82</lienAdt>,… | |
| 16130000368468 | L16/debats | 16 | 16130000368440 | 16130000368467 | 1 | M. François Piquemal | 3073520 | |
| 16130000368471 | L16/debats | 16 | 16130000368440 | 16130000368470 | 1 | Amendement no 143 | Amendement n<sup>o</sup> <lienAdt id_syceron="3073668"> 143</lienAdt> | |
| 16130000368473 | L16/debats | 16 | 16130000368440 | 16130000368472 | 1 | M. Antoine Léaument | 3073717 | |
| 16130000369856 | L16/debats | 16 | 16130000369833 | 16130000369855 | 1 | Mme Ségolène Amiot | 3075702 | |
| 16130000369857 | L16/debats | 16 | 16130000369833 | 16130000369855 | 2 | Amendements nos 67, 75, 164, 73, 23, 72, 165 | Amendements n<sup>os</sup> <lienAdt id_syceron="3075706"> 67</lienAdt>, <lienAdt id_syceron="3075736"> 75</lienAdt>, <lienAdt id_syceron="3075745"> 164</lienAdt… | |
| 16130000369859 | L16/debats | 16 | 16130000369833 | 16130000369858 | 1 | Amendements nos 81 troisième rectification, 39 | Amendements n<sup>os</sup> <lienAdt id_syceron="3076156"> 81 troisième rectification</lienAdt>, <lienAdt id_syceron="3073542"> 39</lienAdt> | |
| 16130000369861 | L16/debats | 16 | 16130000369833 | 16130000369860 | 1 | Mme Véronique Riotton | 3073404 | |
| 16130000369862 | L16/debats | 16 | 16130000369833 | 16130000369860 | 2 | Mme Ségolène Amiot | 3073413 | |
| 16130000369863 | L16/debats | 16 | 16130000369833 | 16130000369860 | 3 | Amendement no 70, 172 | Amendement n<sup>o</sup> <lienAdt id_syceron="3073415"> 70</lienAdt>, <lienAdt id_syceron="3073418">172</lienAdt> | |
| 16130000369864 | L16/debats | 16 | 16130000369833 | 16130000369860 | 4 | Sous-amendement no 189 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3073419"> 189</lienAdt> | |
| 16130000369865 | L16/debats | 16 | 16130000369833 | 16130000369860 | 5 | Amendements nos 96, 163, 209 | Amendements n<sup>os</sup> <lienAdt id_syceron="3073422"> 96</lienAdt>, <lienAdt id_syceron="3073430"> 163</lienAdt>, <lienAdt id_syceron="3073758"> 209</lienAd… | |
| 16130000369867 | L16/debats | 16 | 16130000369833 | 16130000369866 | 1 | M. Hervé de Lépinau | 3073785 | |
| 16130000369868 | L16/debats | 16 | 16130000369833 | 16130000369866 | 2 | Mme Nadège Abomangoli | 3073792 | |
| 16130000369869 | L16/debats | 16 | 16130000369833 | 16130000369866 | 3 | Mme Virginie Duby-Muller | 3073797 | |
| 16130000369870 | L16/debats | 16 | 16130000369833 | 16130000369866 | 4 | M. Christophe Blanchet | 3073988 | |
| 16130000369871 | L16/debats | 16 | 16130000369833 | 16130000369866 | 5 | M. Dominique Potier | 3073994 | |
| 16130000369872 | L16/debats | 16 | 16130000369833 | 16130000369866 | 6 | Mme Nathalie Bassire | 3073998 | |
| 16130000369873 | L16/debats | 16 | 16130000369833 | 16130000369866 | 7 | Mme Emmanuelle Ménard | 3074001 | |
| 16130000369874 | L16/debats | 16 | 16130000369833 | 16130000369866 | 8 | Amendements nos 196 rectifié, 176 rectifié | Amendements n<sup>os</sup> <lienAdt id_syceron="3074003"> 196 rectifié</lienAdt>, <lienAdt id_syceron="3074010"> 176 rectifié</lienAdt> | |
| 16130000369875 | L16/debats | 16 | 16130000369833 | 16130000369866 | 9 | Sous-amendement no 184 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3074017"> 184</lienAdt> | |
| 16130000369876 | L16/debats | 16 | 16130000369833 | 16130000369866 | 10 | Amendements nos 123, 45 rectifié, 46 rectifié, 102, 14, 103, 66, 206, 47, 182, 56, 76, 130, 134 | Amendements n<sup>os</sup> <lienAdt id_syceron="3075555"> 123</lienAdt>, <lienAdt id_syceron="3075571"> 45 rectifié, 46 rectifié</lienAdt>, <lienAdt id_syceron=… | |
| 16130000370800 | L16/debats | 16 | 16130000370795 | 16130000370799 | 1 | Amendement no 77 | Amendement n<sup>o</sup> <lienAdt id_syceron="3075423"> 77</lienAdt> | |
| 16130000370801 | L16/debats | 16 | 16130000370795 | 16130000370799 | 2 | M. Arthur Delaporte, rapporteur de la commission des affaires économiques | 3075428 |