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 |
|---|---|---|---|---|---|---|---|---|
| 16130000447314 | L16/debats | 16 | 16130000447306 | 16130000447311 | 3 | M. Sébastien Lecornu, ministre des armées | 3139630 | |
| 16130000447315 | L16/debats | 16 | 16130000447306 | 16130000447311 | 4 | Amendements nos 446, 98, 535, 447, 452, 283, 1307, 1612, 1629, 190, 193, 454, 217, 285, 1308, 1236, 206, 264, 427, 284, 1298, 1304, 1303, 1142, 442, 475, 1302, … | Amendements n<sup>os</sup> <lienAdt id_syceron="3139632"> 446, 98, 535</lienAdt>, <lienAdt id_syceron="3139634"> 447</lienAdt>, <lienAdt id_syceron="3139644"> 4… | |
| 16130000447316 | L16/debats | 16 | 16130000447306 | 16130000447311 | 5 | M. Loïc Kervran, vice-président de la commission de la défense nationale et des forces armées | 3140204 | |
| 16130000447724 | L16/debats | 16 | 16130000447702 | 16130000447723 | 1 | Amendement no 30 | Amendement n<sup>o</sup> <lienAdt id_syceron="3140995"> 30</lienAdt> | |
| 16130000447726 | L16/debats | 16 | 16130000447702 | 16130000447725 | 1 | M. Éric Woerth | 3141110 | |
| 16130000447727 | L16/debats | 16 | 16130000447702 | 16130000447725 | 2 | Mme Véronique Louwagie | 3141117 | |
| 16130000447728 | L16/debats | 16 | 16130000447702 | 16130000447725 | 3 | M. Philippe Brun | 3141126 | |
| 16130000447731 | L16/debats | 16 | 16130000447702 | 16130000447730 | 1 | Amendements nos 3, 22, 18, 24, 27, 28, 19, 23, 25, 21, 16, 17, 26, 15, 29, 12, 1, 20, 10, 13, 2, 4, 5, 6, 9, 14, 8, 7, 11 | Amendements n<sup>os</sup> <lienAdt id_syceron="3141132"> 3</lienAdt>, <lienAdt id_syceron="3141145"> 22</lienAdt>, <lienAdt id_syceron="3141156"> 18</lienAdt>,… | |
| 16130000447738 | L16/debats | 16 | 16130000447702 | 16130000447737 | 1 | Amendement no 42 | Amendement n<sup>o</sup> <lienAdt id_syceron="3141369"> 42</lienAdt> | |
| 16130000447741 | L16/debats | 16 | 16130000447702 | 16130000447740 | 1 | Amendements nos 7, 24, 20, 32, 26, 17, 36, 21, 5, 25, 27, 34, 23, 35, 38, 18, 31, 19, 4, 12, 33, 28, 29, 30, 39, 2, 3, 13, 37, 1, 22, 8, 10, 9, 11, 14, 15, 16 | Amendements n<sup>os</sup> <lienAdt id_syceron="3141380"> 7</lienAdt>, <lienAdt id_syceron="3141385"> 24</lienAdt>, <lienAdt id_syceron="3141388"> 20</lienAdt>,… | |
| 16130000448895 | L16/debats | 16 | 16130000448758 | 16130000448894 | 1 | M. Michel Castellani | 3143067 | |
| 16130000448896 | L16/debats | 16 | 16130000448758 | 16130000448894 | 2 | Amendements nos 1, 5, 12, 18 | Amendements n<sup>os</sup> <lienAdt id_syceron="3143070"> 1</lienAdt>, <lienAdt id_syceron="3143072"> 5</lienAdt>, <lienAdt id_syceron="3143074"> 12</lienAdt>, … | |
| 16130000448898 | L16/debats | 16 | 16130000448758 | 16130000448897 | 1 | Amendements nos 2, 6, 9, 13 | Amendements n<sup>os</sup> <lienAdt id_syceron="3143095"> 2</lienAdt>, <lienAdt id_syceron="3143097"> 6</lienAdt>, <lienAdt id_syceron="3143099"> 9</lienAdt>, <… | |
| 16130000448900 | L16/debats | 16 | 16130000448758 | 16130000448899 | 1 | Amendements nos 7, 10, 14 | Amendements n<sup>os</sup> <lienAdt id_syceron="3143171"> 7</lienAdt>, <lienAdt id_syceron="3143174"> 10</lienAdt>, <lienAdt id_syceron="3143176"> 14</lienAdt> | |
| 16130000448902 | L16/debats | 16 | 16130000448758 | 16130000448901 | 1 | Amendements nos 8, 11, 15 | Amendements n<sup>os</sup> <lienAdt id_syceron="3143187"> 8</lienAdt>, <lienAdt id_syceron="3143190"> 11, 15</lienAdt> | |
| 16130000450623 | L16/debats | 16 | 16130000450567 | 16130000450622 | 1 | Mme Caroline Fiat | 3144162 | |
| 16130000450624 | L16/debats | 16 | 16130000450567 | 16130000450622 | 2 | M. le président | 3144166 | |
| 16130000450638 | L16/debats | 16 | 16130000450567 | 16130000450637 | 1 | Mme Véronique Louwagie | 3144669 | |
| 16130000450639 | L16/debats | 16 | 16130000450567 | 16130000450637 | 2 | M. Jean-Philippe Nilor | 3144679 | |
| 16130000453761 | L16/debats | 16 | 16130000453753 | 16130000453760 | 1 | Amendements nos 31 | Amendements n<sup>os</sup> <lienAdt id_syceron="3146817"> 31</lienAdt> | |
| 16130000453762 | L16/debats | 16 | 16130000453753 | 16130000453760 | 2 | Sous-amendements nos 41, 43, 42, 44, 47, 48, 45, 49, 51, 46, 50, 52 | Sous-amendements n<sup>os</sup> <lienAdt id_syceron="3146822"> 41</lienAdt>, <lienAdt id_syceron="3147173"> 43</lienAdt>, <lienAdt id_syceron="3147177"> 42</lie… | |
| 16130000453763 | L16/debats | 16 | 16130000453753 | 16130000453760 | 3 | Amendements nos 8, 9, 6, 21, 27, 28 | Amendements n<sup>os</sup> <lienAdt id_syceron="3147204"> 8</lienAdt>, <lienAdt id_syceron="3146860"> 9</lienAdt>, <lienAdt id_syceron="3146861"> 6</lienAdt>, <… | |
| 16130000453764 | L16/debats | 16 | 16130000453753 | 16130000453760 | 4 | M. Éric Coquerel, président de la commission des finances, de l’économie générale et du contrôle budgétaire | 3146885 | |
| 16130000453765 | L16/debats | 16 | 16130000453753 | 16130000453760 | 5 | M. Gabriel Attal, ministre délégué chargé des comptes publics | 3146889 | |
| 16130000453767 | L16/debats | 16 | 16130000453753 | 16130000453766 | 1 | M. Christophe Naegelen, rapporteur | 3146853 | |
| 16130000453768 | L16/debats | 16 | 16130000453753 | 16130000453766 | 2 | M. Gabriel Attal, ministre délégué | 3146855 | |
| 16130000453769 | L16/debats | 16 | 16130000453753 | 16130000453766 | 3 | Mme la présidente | 3146858 | |
| 16130000453791 | L16/debats | 16 | 16130000453753 | 16130000453790 | 1 | M. Jean-Félix Acquaviva | 3148560 | |
| 16130000453792 | L16/debats | 16 | 16130000453753 | 16130000453790 | 2 | M. Philippe Dunoyer | 3148563 | |
| 16130000453793 | L16/debats | 16 | 16130000453753 | 16130000453790 | 3 | Mme Sophie Blanc | 3148570 | |
| 16130000453794 | L16/debats | 16 | 16130000453753 | 16130000453790 | 4 | M. Jean-Philippe Nilor | 3148572 | |
| 16130000453795 | L16/debats | 16 | 16130000453753 | 16130000453790 | 5 | M. Elie Califer | 3148579 | |
| 16130000453796 | L16/debats | 16 | 16130000453753 | 16130000453790 | 6 | M. Davy Rimane | 3148583 | |
| 16130000453797 | L16/debats | 16 | 16130000453753 | 16130000453790 | 7 | Amendement no 65 rectifié | Amendement n<sup>o</sup> <lienAdt id_syceron="3148590"> 65 rectifié</lienAdt> | |
| 16130000453798 | L16/debats | 16 | 16130000453753 | 16130000453790 | 8 | Sous-amendement no 66 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3148599"> 66</lienAdt> | |
| 16130000453799 | L16/debats | 16 | 16130000453753 | 16130000453790 | 9 | Amendements nos 34, 48 | Amendements n<sup>os</sup> <lienAdt id_syceron="3148605"> 34</lienAdt>, <lienAdt id_syceron="3148608"> 48</lienAdt> | |
| 16130000453800 | L16/debats | 16 | 16130000453753 | 16130000453790 | 10 | Sous-amendement no 62 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3148611"> 62</lienAdt> | |
| 16130000453802 | L16/debats | 16 | 16130000453753 | 16130000453801 | 1 | Amendements nos 52, 49 | Amendements n<sup>os</sup> <lienAdt id_syceron="3148631"> 52</lienAdt>, <lienAdt id_syceron="3148634"> 49</lienAdt> | |
| 16130000453804 | L16/debats | 16 | 16130000453753 | 16130000453803 | 1 | M. Philippe Dunoyer | 3147610 | |
| 16130000453805 | L16/debats | 16 | 16130000453753 | 16130000453803 | 2 | Mme Caroline Parmentier | 3147614 | |
| 16130000453806 | L16/debats | 16 | 16130000453753 | 16130000453803 | 3 | Amendements nos 46, 1 | Amendements n<sup>os</sup> <lienAdt id_syceron="3147620"> 46</lienAdt>, <lienAdt id_syceron="3147622"> 1</lienAdt> | |
| 16130000453808 | L16/debats | 16 | 16130000453753 | 16130000453807 | 1 | Amendements nos 8, 31, 9, 19 | Amendements n<sup>os</sup> <lienAdt id_syceron="3147634"> 8</lienAdt>, <lienAdt id_syceron="3147643"> 31</lienAdt>, <lienAdt id_syceron="3147654"> 9</lienAdt>, … | |
| 16130000453811 | L16/debats | 16 | 16130000453753 | 16130000453810 | 1 | Amendements nos 21, 16, 15 | Amendements n<sup>os</sup> <lienAdt id_syceron="3147797"> 21</lienAdt>, <lienAdt id_syceron="3147801"> 16</lienAdt>, <lienAdt id_syceron="3147826"> 15</lienAdt> | |
| 16130000453813 | L16/debats | 16 | 16130000453753 | 16130000453812 | 1 | Amendement no 13 | Amendement n<sup>o</sup> <lienAdt id_syceron="3147932"> 13</lienAdt> | |
| 16130000453816 | L16/debats | 16 | 16130000453753 | 16130000453815 | 1 | Amendements nos 18, 2, 3, 24, 41, 6, 23, 7, 30, 20, 22, 43, 26 | Amendements n<sup>os</sup> <lienAdt id_syceron="3147952"> 18</lienAdt>, <lienAdt id_syceron="3148263"> 2</lienAdt>, <lienAdt id_syceron="3148282"> 3</lienAdt>, … | |
| 16130000454986 | L16/debats | 16 | 16130000454981 | 16130000454985 | 1 | Amendement no 44 | Amendement n<sup>o</sup> <lienAdt id_syceron="3147730"> 44</lienAdt> | |
| 16130000454987 | L16/debats | 16 | 16130000454981 | 16130000454985 | 2 | M. Olivier Serva, rapporteur de la commission du développement durable et de l’aménagement du territoire | 3147733 | |
| 16130000454988 | L16/debats | 16 | 16130000454981 | 16130000454985 | 3 | M. Jean-François Carenco, ministre délégué chargé des outre-mer | 3147735 | |
| 16130000454989 | L16/debats | 16 | 16130000454981 | 16130000454985 | 4 | Amendement no 42 | Amendement n<sup>o</sup> <lienAdt id_syceron="3147749"> 42</lienAdt> | |
| 16130000454991 | L16/debats | 16 | 16130000454981 | 16130000454990 | 1 | Mme Mathilde Panot | 3147768 |