debats.compte_rendu_sommaire1_sommaire2_sommaire3_para
Chemin compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para · présence : L17 74 %, L16 74 %, L15 76 %
46 307 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 |
|---|---|---|---|---|---|---|---|---|
| 17130000656551 | L17/debats | 17 | 17130000656539 | 17130000656550 | 1 | M. Robert Le Bourgeois | 4110261 | |
| 17130000656552 | L17/debats | 17 | 17130000656539 | 17130000656550 | 2 | M. Dominique Potier | 4110266 | |
| 17130000656553 | L17/debats | 17 | 17130000656539 | 17130000656550 | 3 | M. Jean-René Cazeneuve, rapporteur | 4110271 | |
| 17130000656554 | L17/debats | 17 | 17130000656539 | 17130000656550 | 4 | Mme Annie Genevard, ministre | 4110275 | |
| 17130000656555 | L17/debats | 17 | 17130000656539 | 17130000656550 | 5 | M. Pascal Lecamp | 4110289 | |
| 17130000656556 | L17/debats | 17 | 17130000656539 | 17130000656550 | 6 | Mme Manon Meunier | 4110295 | |
| 17130000656557 | L17/debats | 17 | 17130000656539 | 17130000656550 | 7 | M. Benoît Biteau | 4110304 | |
| 17130000656558 | L17/debats | 17 | 17130000656539 | 17130000656550 | 8 | Amendements nos 2107 rectifié, 713, 1746, 1817 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110307"> 2107 rectifié</lienAdt>, <lienAdt id_syceron="4110332"> 713</lienAdt>, <lienAdt id_syceron="4110354"> … | |
| 17130000656559 | L17/debats | 17 | 17130000656539 | 17130000656550 | 9 | Sous-amendement no 2426 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="4110355"> 2426</lienAdt> | |
| 17130000656560 | L17/debats | 17 | 17130000656539 | 17130000656550 | 10 | Amendements nos 702, 703, 1142, 1594, 2069, 2268 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110462"> 702</lienAdt>, <lienAdt id_syceron="4110464"> 703</lienAdt>, <lienAdt id_syceron="4110473"> 1142</lien… | |
| 17130000656561 | L17/debats | 17 | 17130000656539 | 17130000656550 | 11 | Sous-amendement no 2466 rectifié | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="4110496"> 2466 rectifié</lienAdt> | |
| 17130000656562 | L17/debats | 17 | 17130000656539 | 17130000656550 | 12 | Amendements nos 1595, 704, 705, 712, 1134, 701, 2075, 1537, 1680 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110509"> 1595</lienAdt>, <lienAdt id_syceron="4110512"> 704, 705</lienAdt>, <lienAdt id_syceron="4110522"> 712<… | |
| 17130000656564 | L17/debats | 17 | 17130000656539 | 17130000656563 | 1 | Amendement no 1838 | Amendement n<sup>o</sup> <lienAdt id_syceron="4110590"> 1838</lienAdt> | |
| 17130000656566 | L17/debats | 17 | 17130000656539 | 17130000656565 | 1 | Amendements nos 710, 1950, 1239 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110603"> 710</lienAdt>, <lienAdt id_syceron="4110606"> 1950</lienAdt>, <lienAdt id_syceron="4110613"> 1239</lie… | |
| 17130000656568 | L17/debats | 17 | 17130000656539 | 17130000656567 | 1 | M. Patrice Martin | 4110621 | |
| 17130000656569 | L17/debats | 17 | 17130000656539 | 17130000656567 | 2 | Mme Mélanie Thomin | 4110626 | |
| 17130000656570 | L17/debats | 17 | 17130000656539 | 17130000656567 | 3 | Amendement no 1345 | Amendement n<sup>o</sup> <lienAdt id_syceron="4110630"> 1345</lienAdt> | |
| 17130000656572 | L17/debats | 17 | 17130000656539 | 17130000656571 | 1 | Mme Marie Pochon | 4110635 | |
| 17130000656573 | L17/debats | 17 | 17130000656539 | 17130000656571 | 2 | M. Éric Martineau | 4110642 | |
| 17130000656574 | L17/debats | 17 | 17130000656539 | 17130000656571 | 3 | M. Patrice Martin | 4110645 | |
| 17130000656575 | L17/debats | 17 | 17130000656539 | 17130000656571 | 4 | Mme Anne-Sophie Ronceret | 4110653 | |
| 17130000656576 | L17/debats | 17 | 17130000656539 | 17130000656571 | 5 | Mme Mathilde Hignet | 4110665 | |
| 17130000656577 | L17/debats | 17 | 17130000656539 | 17130000656571 | 6 | M. Dominique Potier | 4110667 | |
| 17130000656579 | L17/debats | 17 | 17130000656539 | 17130000656578 | 1 | Amendement no 2109 | Amendement n<sup>o</sup> <lienAdt id_syceron="4110676"> 2109</lienAdt> | |
| 17130000656581 | L17/debats | 17 | 17130000656539 | 17130000656580 | 1 | Amendements nos 67, 72 | Amendements n<sup>os</sup> <lienAdt id_syceron="4109625"> 67</lienAdt>, <lienAdt id_syceron="4109630"> 72</lienAdt> | |
| 17130000656583 | L17/debats | 17 | 17130000656539 | 17130000656582 | 1 | Amendements nos 632, 69 | Amendements n<sup>os</sup> <lienAdt id_syceron="4109800"> 632</lienAdt>, <lienAdt id_syceron="4109820"> 69</lienAdt> | |
| 17130000656585 | L17/debats | 17 | 17130000656539 | 17130000656584 | 1 | Amendements nos 2027, 2084 | Amendements n<sup>os</sup> <lienAdt id_syceron="4109827"> 2027, 2084</lienAdt> | |
| 17130000656587 | L17/debats | 17 | 17130000656539 | 17130000656586 | 1 | Amendement no 1930 | Amendement n<sup>o</sup> <lienAdt id_syceron="4109844"> 1930</lienAdt> | |
| 17130000656589 | L17/debats | 17 | 17130000656539 | 17130000656588 | 1 | Amendements nos 125, 480, 995, 1387, 222, 126, 1048, 223, 224, 633, 127, 128, 129, 213, 211, 2081, 134, 1455, 1467, 1460, 1468, 215, 132, 1462, 634, 133, 1472, … | Amendements n<sup>os</sup> <lienAdt id_syceron="4109855"> 125</lienAdt>, <lienAdt id_syceron="4110568"> 480</lienAdt>, <lienAdt id_syceron="4109858"> 995</lienA… | |
| 17130000656591 | L17/debats | 17 | 17130000656539 | 17130000656590 | 1 | Amendements nos 23, 226 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110064"> 23</lienAdt>, <lienAdt id_syceron="4110073"> 226</lienAdt> | |
| 17130000656593 | L17/debats | 17 | 17130000656539 | 17130000656592 | 1 | Amendements nos 1621, 1121 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110084"> 1621</lienAdt>, <lienAdt id_syceron="4110086"> 1121</lienAdt> | |
| 17130000656596 | L17/debats | 17 | 17130000656539 | 17130000656595 | 1 | Amendement no 2147 | Amendement n<sup>o</sup> <lienAdt id_syceron="4110112"> 2147</lienAdt> | |
| 17130000656598 | L17/debats | 17 | 17130000656539 | 17130000656597 | 1 | Amendements nos 1342, 1353 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110125"> 1342</lienAdt>, <lienAdt id_syceron="4110142"> 1353</lienAdt> | |
| 17130000656600 | L17/debats | 17 | 17130000656539 | 17130000656599 | 1 | Amendements nos 588, 843, 844, 62, 376, 210, 74, 1452, 1966, 280, 426, 598, 1892, 606, 2148, 812, 1389, 1390, 1453, 1577, 1985, 2162, 2176 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110150"> 588</lienAdt>, <lienAdt id_syceron="4110155"> 843, 844</lienAdt>, <lienAdt id_syceron="4110161"> 62</l… | |
| 17130000656602 | L17/debats | 17 | 17130000656539 | 17130000656601 | 1 | Amendement no 858 | Amendement n<sup>o</sup> <lienAdt id_syceron="4110537"> 858</lienAdt> | |
| 17130000658370 | L17/debats | 17 | 17130000658350 | 17130000658369 | 1 | Mme Graziella Melchior | 4111576 | |
| 17130000658371 | L17/debats | 17 | 17130000658350 | 17130000658369 | 2 | M. Christian Baptiste | 4111581 | |
| 17130000658372 | L17/debats | 17 | 17130000658350 | 17130000658369 | 3 | M. Xavier Breton | 4111586 | |
| 17130000658373 | L17/debats | 17 | 17130000658350 | 17130000658369 | 4 | Amendements nos 26, 137, 180 | Amendements n<sup>os</sup> <lienAdt id_syceron="4111594"> 26</lienAdt>, <lienAdt id_syceron="4111597"> 137</lienAdt>, <lienAdt id_syceron="4111984"> 180</lienAd… | |
| 17130000658374 | L17/debats | 17 | 17130000658350 | 17130000658369 | 5 | Sous-amendement no 206 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="4111988"> 206</lienAdt> | |
| 17130000658375 | L17/debats | 17 | 17130000658350 | 17130000658369 | 6 | Amendements nos 116, 138 | Amendements n<sup>os</sup> <lienAdt id_syceron="4112002"> 116</lienAdt>, <lienAdt id_syceron="4112016"> 138</lienAdt> | |
| 17130000658377 | L17/debats | 17 | 17130000658350 | 17130000658376 | 1 | Amendements nos 60, 135, 140, 183 | Amendements n<sup>os</sup> <lienAdt id_syceron="4112043"> 60</lienAdt>, <lienAdt id_syceron="4112047"> 135</lienAdt>, <lienAdt id_syceron="4112050"> 140</lienAd… | |
| 17130000658379 | L17/debats | 17 | 17130000658350 | 17130000658378 | 1 | Amendements nos 141, 61, 108, 62, 184 | Amendements n<sup>os</sup> <lienAdt id_syceron="4110729"> 141</lienAdt>, <lienAdt id_syceron="4110736"> 61</lienAdt>, <lienAdt id_syceron="4110753"> 108</lienAd… | |
| 17130000658381 | L17/debats | 17 | 17130000658350 | 17130000658380 | 1 | M. Matthieu Marchio | 4110771 | |
| 17130000658382 | L17/debats | 17 | 17130000658350 | 17130000658380 | 2 | Amendements nos 117, 54, 118, 149, 110, 150, 119, 152, 185 rectifié | Amendements n<sup>os</sup> <lienAdt id_syceron="4110776"> 117</lienAdt>, <lienAdt id_syceron="4110905"> 54</lienAdt>, <lienAdt id_syceron="4110929"> 118</lienAd… | |
| 17130000658384 | L17/debats | 17 | 17130000658350 | 17130000658383 | 1 | Amendements nos 151, 176, 177 | Amendements n<sup>os</sup> <lienAdt id_syceron="4111014"> 151, 176, 177</lienAdt> | |
| 17130000658386 | L17/debats | 17 | 17130000658350 | 17130000658385 | 1 | Amendements nos 83, 153 | Amendements n<sup>os</sup> <lienAdt id_syceron="4111033"> 83</lienAdt>, <lienAdt id_syceron="4111035"> 153</lienAdt> | |
| 17130000658388 | L17/debats | 17 | 17130000658350 | 17130000658387 | 1 | M. Sylvain Maillard | 4111050 | |
| 17130000658389 | L17/debats | 17 | 17130000658350 | 17130000658387 | 2 | M. Erwan Balanant | 4111053 | |
| 17130000658391 | L17/debats | 17 | 17130000658350 | 17130000658390 | 1 | Amendement no 181 | Amendement n<sup>o</sup> <lienAdt id_syceron="4111285"> 181</lienAdt> |