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 |
|---|---|---|---|---|---|---|---|---|
| 15130001874206 | L15/debats | 15 | 15130001874173 | 15130001874201 | 5 | Amendements nos 137, 212, 209, 106, 104, 226, 105 | Amendements n<sup>os</sup> <lienAdt id_syceron="2746528"> 137</lienAdt>, <lienAdt id_syceron="2746530"> 212, 209</lienAdt>, <lienAdt id_syceron="2746533"> 106</… | |
| 15130001874208 | L15/debats | 15 | 15130001874173 | 15130001874207 | 1 | Amendements nos 31, 14, 107, 153, 223 | Amendements n<sup>os</sup> <lienAdt id_syceron="2746740"> 31</lienAdt>, <lienAdt id_syceron="2746742"> 14</lienAdt>, <lienAdt id_syceron="2746746"> 107</lienAdt… | |
| 15130001874210 | L15/debats | 15 | 15130001874173 | 15130001874209 | 1 | Amendements nos 144, 163, 145 | Amendements n<sup>os</sup> <lienAdt id_syceron="2746760"> 144</lienAdt>, <lienAdt id_syceron="2746762"> 163</lienAdt>, <lienAdt id_syceron="2746765"> 145</lienA… | |
| 15130001874212 | L15/debats | 15 | 15130001874173 | 15130001874211 | 1 | Amendements nos 165, 120, 13 | Amendements n<sup>os</sup> <lienAdt id_syceron="2746769"> 165</lienAdt>, <lienAdt id_syceron="2746772"> 120</lienAdt>, <lienAdt id_syceron="2746774"> 13</lienAd… | |
| 15130001874214 | L15/debats | 15 | 15130001874173 | 15130001874213 | 1 | Amendements nos 79, 215 | Amendements n<sup>os</sup> <lienAdt id_syceron="2746787"> 79</lienAdt>, <lienAdt id_syceron="2746789"> 215</lienAdt> | |
| 15130001874215 | L15/debats | 15 | 15130001874173 | 15130001874213 | 2 | Sous-amendement no 246 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="2746791"> 246</lienAdt> | |
| 15130001874216 | L15/debats | 15 | 15130001874173 | 15130001874213 | 3 | Amendements nos 97, 190, 55, 219, 160, 90 | Amendements n<sup>os</sup> <lienAdt id_syceron="2746794"> 97</lienAdt>, <lienAdt id_syceron="2746801"> 190</lienAdt>, <lienAdt id_syceron="2746953"> 55</lienAdt… | |
| 15130001876714 | L15/debats | 15 | 15130001876694 | 15130001876713 | 1 | M. André Villiers | 2750180 | |
| 15130001876715 | L15/debats | 15 | 15130001876694 | 15130001876713 | 2 | M. Loïc Prud’homme | 2750191 | |
| 15130001876716 | L15/debats | 15 | 15130001876694 | 15130001876713 | 3 | M. André Chassaigne | 2749692 | |
| 15130001876717 | L15/debats | 15 | 15130001876694 | 15130001876713 | 4 | M. Jean-Baptiste Moreau | 2749697 | |
| 15130001876718 | L15/debats | 15 | 15130001876694 | 15130001876713 | 5 | M. Guillaume Larrivé | 2749704 | |
| 15130001876719 | L15/debats | 15 | 15130001876694 | 15130001876713 | 6 | M. Julien Denormandie, ministre | 2749710 | |
| 15130001876720 | L15/debats | 15 | 15130001876694 | 15130001876713 | 7 | Amendements nos 110, 171, 42, 43 | Amendements n<sup>os</sup> <lienAdt id_syceron="2749721"> 110</lienAdt>, <lienAdt id_syceron="2749945"> 171</lienAdt>, <lienAdt id_syceron="2749971"> 42</lienAd… | |
| 15130001876722 | L15/debats | 15 | 15130001876694 | 15130001876721 | 1 | Amendements nos 129, 228 | Amendements n<sup>os</sup> <lienAdt id_syceron="2750009"> 129</lienAdt>, <lienAdt id_syceron="2750016"> 228</lienAdt> | |
| 15130001876724 | L15/debats | 15 | 15130001876694 | 15130001876723 | 1 | M. André Villiers | 2750110 | |
| 15130001876725 | L15/debats | 15 | 15130001876694 | 15130001876723 | 2 | M. André Chassaigne | 2750114 | |
| 15130001876726 | L15/debats | 15 | 15130001876694 | 15130001876723 | 3 | M. Jean-Baptiste Moreau | 2750121 | |
| 15130001876727 | L15/debats | 15 | 15130001876694 | 15130001876723 | 4 | Amendements nos 111, 112, 72, 113, 109, 172, 48 | Amendements n<sup>os</sup> <lienAdt id_syceron="2750125"> 111</lienAdt>, <lienAdt id_syceron="2750141"> 112</lienAdt>, <lienAdt id_syceron="2750273"> 72</lienAd… | |
| 15130001876729 | L15/debats | 15 | 15130001876694 | 15130001876728 | 2 | Sous-amendement no 276 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="2749164"> 276</lienAdt> | |
| 15130001876731 | L15/debats | 15 | 15130001876694 | 15130001876730 | 1 | M. Christophe Naegelen | 2750966 | |
| 15130001876732 | L15/debats | 15 | 15130001876694 | 15130001876730 | 2 | M. Jean-Paul Dufrègne | 2750969 | |
| 15130001876733 | L15/debats | 15 | 15130001876694 | 15130001876730 | 3 | M. Fabien Matras | 2750976 | |
| 15130001876734 | L15/debats | 15 | 15130001876694 | 15130001876730 | 4 | Amendements nos 114, 4, 81, 98, 136, 155, 188, 207, 49, 26, 198, 173, 187, 65, 2, 135, 153, 206, 24, 78, 95, 182, 233, 245, 197, 224, 236, 248, 51, 256, 178 | Amendements n<sup>os</sup> <lienAdt id_syceron="2750980"> 114</lienAdt>, <lienAdt id_syceron="2751194"> 4</lienAdt>, <lienAdt id_syceron="2751201"> 81</lienAdt>… | |
| 15130001876736 | L15/debats | 15 | 15130001876694 | 15130001876735 | 1 | Amendement no 59 | Amendement n<sup>o</sup> <lienAdt id_syceron="2749867"> 59</lienAdt> | |
| 15130001876738 | L15/debats | 15 | 15130001876694 | 15130001876737 | 1 | Amendements nos 6, 169, 189, 209, 257, 258, 52, 5, 82, 99, 146, 156, 190, 208 | Amendements n<sup>os</sup> <lienAdt id_syceron="2749873">6</lienAdt>, <lienAdt id_syceron="2749875"> 169</lienAdt>, <lienAdt id_syceron="2750029"> 189</lienAdt>… | |
| 15130001876740 | L15/debats | 15 | 15130001876694 | 15130001876739 | 1 | Mme Marie-Christine Verdier-Jouclas | 2750080 | |
| 15130001876741 | L15/debats | 15 | 15130001876694 | 15130001876739 | 2 | M. Jean-Marie Sermier | 2750084 | |
| 15130001876742 | L15/debats | 15 | 15130001876694 | 15130001876739 | 3 | Amendements nos 179, 203, 186, 53, 87, 222, 225, 237, 247 | Amendements n<sup>os</sup> <lienAdt id_syceron="2750088"> 179</lienAdt>, <lienAdt id_syceron="2750201"> 203</lienAdt>, <lienAdt id_syceron="2750211"> 186</lienA… | |
| 15130001876743 | L15/debats | 15 | 15130001876694 | 15130001876739 | 4 | Sous-amendements nos 269, 274, 277, 278, 271 | Sous-amendements n<sup>os</sup> <lienAdt id_syceron="2750242"> 269, 274</lienAdt>, <lienAdt id_syceron="2750243"> 277</lienAdt>, <lienAdt id_syceron="2750245"> … | |
| 15130001876744 | L15/debats | 15 | 15130001876694 | 15130001876739 | 5 | Amendement no 180 | Amendement n<sup>o</sup> <lienAdt id_syceron="2750249"> 180</lienAdt> | |
| 15130001876746 | L15/debats | 15 | 15130001876694 | 15130001876745 | 1 | Amendements nos 204 rectifié, 238 | Amendements n<sup>os</sup> <lienAdt id_syceron="2750337"> 204 rectifié</lienAdt>, <lienAdt id_syceron="2750340"> 238</lienAdt> | |
| 15130001876749 | L15/debats | 15 | 15130001876694 | 15130001876748 | 1 | M. Fabrice Brun | 2750350 | |
| 15130001876750 | L15/debats | 15 | 15130001876694 | 15130001876748 | 2 | Amendements nos 181, 90, 142, 240, 122, 191, 104 rectifié, 121, 239, 123, 84, 101, 145, 157 | Amendements n<sup>os</sup> <lienAdt id_syceron="2750353"> 181</lienAdt>, <lienAdt id_syceron="2750363"> 90</lienAdt>, <lienAdt id_syceron="2751002"> 142</lienAd… | |
| 15130001876753 | L15/debats | 15 | 15130001876694 | 15130001876752 | 1 | Amendement no 105 | Amendement n<sup>o</sup> <lienAdt id_syceron="2751268"> 105</lienAdt> | |
| 15130001876755 | L15/debats | 15 | 15130001876694 | 15130001876754 | 1 | Amendement no 241 | Amendement n<sup>o</sup> <lienAdt id_syceron="2751274"> 241</lienAdt> | |
| 15130001876758 | L15/debats | 15 | 15130001876694 | 15130001876757 | 1 | M. Julien Dive | 2751282 | |
| 15130001876759 | L15/debats | 15 | 15130001876694 | 15130001876757 | 2 | Amendements nos 124, 242, deuxième rectification | Amendements n<sup>os</sup> <lienAdt id_syceron="2751287"> 124</lienAdt>, <lienAdt id_syceron="2751290"> 242, deuxième rectification</lienAdt> | |
| 15130001876761 | L15/debats | 15 | 15130001876694 | 15130001876760 | 1 | Amendements nos 55, 167, 227, 235, 108, 243, 54, 170, 211, 199, 205 | Amendements n<sup>os</sup> <lienAdt id_syceron="2751302"> 55</lienAdt>, <lienAdt id_syceron="2751357"> 167</lienAdt>, <lienAdt id_syceron="2751371"> 227</lienAd… | |
| 15130001878524 | L15/debats | 15 | 15130001878489 | 15130001878523 | 1 | M. Jean-Hugues Ratenon | 2751334 | |
| 15130001878525 | L15/debats | 15 | 15130001878489 | 15130001878523 | 2 | Amendements nos 5, 6 | Amendements n<sup>os</sup> <lienAdt id_syceron="2751341"> 5</lienAdt>, <lienAdt id_syceron="2751453"> 6</lienAdt> | |
| 15130001878527 | L15/debats | 15 | 15130001878489 | 15130001878526 | 1 | Amendement no 1 | Amendement n<sup>o</sup> <lienAdt id_syceron="2751469"> 1</lienAdt> | |
| 15130001878529 | L15/debats | 15 | 15130001878489 | 15130001878528 | 1 | M. Adrien Quatennens | 2751486 | |
| 15130001878530 | L15/debats | 15 | 15130001878489 | 15130001878528 | 2 | M. Guillaume Kasbarian | 2751494 | |
| 15130001878531 | L15/debats | 15 | 15130001878489 | 15130001878528 | 3 | Amendements nos 4, 2, 3 | Amendements n<sup>os</sup> <lienAdt id_syceron="2751506"> 4</lienAdt>, <lienAdt id_syceron="2751538"> 2</lienAdt>, <lienAdt id_syceron="2750867"> 3</lienAdt> | |
| 15130001879233 | L15/debats | 15 | 15130001879217 | 15130001879232 | 1 | M. Jean-Hugues Ratenon | 2752991 | |
| 15130001879234 | L15/debats | 15 | 15130001879217 | 15130001879232 | 2 | M. Erwan Balanant | 2752996 | |
| 15130001879255 | L15/debats | 15 | 15130001879217 | 15130001879254 | 1 | M. François Ruffin | 2752194 | |
| 15130001879256 | L15/debats | 15 | 15130001879217 | 15130001879254 | 2 | Amendement no 4 | Amendement n<sup>o</sup> <lienAdt id_syceron="2752203"> 4</lienAdt> | |
| 15130001879258 | L15/debats | 15 | 15130001879217 | 15130001879257 | 1 | Amendement no 5 | Amendement n<sup>o</sup> <lienAdt id_syceron="2752869"> 5</lienAdt> |