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 |
|---|---|---|---|---|---|---|---|---|
| 16130000590992 | L16/debats | 16 | 16130000590968 | 16130000590991 | 1 | Mme Hélène Laporte | 3324933 | |
| 16130000590993 | L16/debats | 16 | 16130000590968 | 16130000590991 | 2 | Mme la présidente | 3324936 | |
| 16130000590995 | L16/debats | 16 | 16130000590968 | 16130000590994 | 1 | Amendements nos 20, 160, 74 | Amendements n<sup>os</sup> <lienAdt id_syceron="3325270"> 20</lienAdt>, <lienAdt id_syceron="3325295"> 160</lienAdt>, <lienAdt id_syceron="3323708">74</lienAdt> | |
| 16130000590997 | L16/debats | 16 | 16130000590968 | 16130000590996 | 1 | Amendement no 122 | Amendement n<sup>o</sup> <lienAdt id_syceron="3323523"> 122</lienAdt> | |
| 16130000590999 | L16/debats | 16 | 16130000590968 | 16130000590998 | 1 | Amendements nos 17, 64, 89 | Amendements n<sup>os</sup> <lienAdt id_syceron="3323554"> 17</lienAdt>, <lienAdt id_syceron="3323559"> 64</lienAdt>, <lienAdt id_syceron="3323564"> 89</lienAdt> | |
| 16130000591001 | L16/debats | 16 | 16130000590968 | 16130000591000 | 1 | Mme Edwige Diaz | 3325050 | |
| 16130000591002 | L16/debats | 16 | 16130000590968 | 16130000591000 | 2 | M. Benjamin Lucas | 3325056 | |
| 16130000591003 | L16/debats | 16 | 16130000590968 | 16130000591000 | 3 | Amendements nos 65, 90 | Amendements n<sup>os</sup> <lienAdt id_syceron="3325063"> 65, 90</lienAdt> | |
| 16130000591005 | L16/debats | 16 | 16130000590968 | 16130000591004 | 1 | Amendements nos 172, 2 | Amendements n<sup>os</sup> <lienAdt id_syceron="3323909"> 172</lienAdt>, <lienAdt id_syceron="3325464"> 2</lienAdt> | |
| 16130000591007 | L16/debats | 16 | 16130000590968 | 16130000591006 | 1 | Amendements nos 66, 91, 136 | Amendements n<sup>os</sup> <lienAdt id_syceron="3325310"> 66, 91</lienAdt>, <lienAdt id_syceron="3325311"> 136</lienAdt> | |
| 16130000591009 | L16/debats | 16 | 16130000590968 | 16130000591008 | 1 | Amendements nos 21, 120 | Amendements n<sup>os</sup> <lienAdt id_syceron="3325577"> 21</lienAdt>, <lienAdt id_syceron="3325642"> 120</lienAdt> | |
| 16130000593326 | L16/debats | 16 | 16130000593307 | 16130000593325 | 1 | M. Jean-François Rousset | 3325774 | |
| 16130000593327 | L16/debats | 16 | 16130000593307 | 16130000593325 | 2 | M. Thierry Frappé | 3325786 | |
| 16130000593328 | L16/debats | 16 | 16130000593307 | 16130000593325 | 3 | Amendements nos 62, 50, 8, 23, 1, 29, 52, 53, 35, 54, 24, 34, 55, 63 | Amendements n<sup>os</sup> <lienAdt id_syceron="3325789"> 62</lienAdt>, <lienAdt id_syceron="3325794"> 50</lienAdt>, <lienAdt id_syceron="3325803"> 8</lienAdt>,… | |
| 16130000593330 | L16/debats | 16 | 16130000593307 | 16130000593329 | 1 | M. Benoit Mournet | 3325874 | |
| 16130000593331 | L16/debats | 16 | 16130000593307 | 16130000593329 | 2 | Amendements nos 49, 58, 60, 64 | Amendements n<sup>os</sup> <lienAdt id_syceron="3325879"> 49</lienAdt>, <lienAdt id_syceron="3325883"> 58</lienAdt>, <lienAdt id_syceron="3325887"> 60, 64</lien… | |
| 16130000593333 | L16/debats | 16 | 16130000593307 | 16130000593332 | 1 | Amendement no 38 | Amendement n<sup>o</sup> <lienAdt id_syceron="3325070"> 38</lienAdt> | |
| 16130000593335 | L16/debats | 16 | 16130000593307 | 16130000593334 | 1 | Amendement no 33 | Amendement n<sup>o</sup> <lienAdt id_syceron="3325085"> 33</lienAdt> | |
| 16130000593337 | L16/debats | 16 | 16130000593307 | 16130000593336 | 1 | Amendements nos 43, 51, 59 | Amendements n<sup>os</sup> <lienAdt id_syceron="3325101"> 43</lienAdt>, <lienAdt id_syceron="3325111"> 51</lienAdt>, <lienAdt id_syceron="3325130"> 59</lienAdt> | |
| 16130000606902 | L16/debats | 16 | 16130000606863 | 16130000606901 | 1 | Mme Fanta Berete | 3342770 | |
| 16130000606903 | L16/debats | 16 | 16130000606863 | 16130000606901 | 2 | M. Emmanuel Maquet | 3342775 | |
| 16130000606904 | L16/debats | 16 | 16130000606863 | 16130000606901 | 3 | Amendements nos 6, 4, 9, 2, 8, 13, 14, 17 rectifié, 18 rectifié, 1, 10, 12, 16 | Amendements n<sup>os</sup> <lienAdt id_syceron="3342778">6</lienAdt>, <lienAdt id_syceron="3342784">4</lienAdt>, <lienAdt id_syceron="3342932">9</lienAdt>, <lie… | |
| 16130000606906 | L16/debats | 16 | 16130000606863 | 16130000606905 | 1 | Amendements nos 11, 19, 20 | Amendements n<sup>os</sup> <lienAdt id_syceron="3343171"> 11</lienAdt>, <lienAdt id_syceron="3343176"> 19</lienAdt>, <lienAdt id_syceron="3343180"> 20</lienAdt> | |
| 16130000606908 | L16/debats | 16 | 16130000606863 | 16130000606907 | 1 | Amendement no 5 | Amendement n<sup>o</sup> <lienAdt id_syceron="3343196"> 5</lienAdt> | |
| 16130000606910 | L16/debats | 16 | 16130000606863 | 16130000606909 | 1 | Amendement no 3 | Amendement n<sup>o</sup> <lienAdt id_syceron="3343204"> 3</lienAdt> | |
| 16130000606912 | L16/debats | 16 | 16130000606863 | 16130000606911 | 1 | Amendement no 21 | Amendement n<sup>o</sup> <lienAdt id_syceron="3343222"> 21</lienAdt> | |
| 16130000607650 | L16/debats | 16 | 16130000607620 | 16130000607649 | 1 | M. Bruno Fuchs | 3344333 | |
| 16130000607651 | L16/debats | 16 | 16130000607620 | 16130000607649 | 2 | M. Antoine Léaument | 3343488 | |
| 16130000607652 | L16/debats | 16 | 16130000607620 | 16130000607649 | 3 | Amendements nos 5 rectifié, 12 rectifié, 16 rectifié, 4 deuxième rectification, 17 deuxième rectification, 20 deuxième rectification, 13, 6, 18 | Amendements n<sup>os</sup> <lienAdt id_syceron="3343491"> 5 rectifié</lienAdt>, <lienAdt id_syceron="3343493"> 12 rectifié</lienAdt>, <lienAdt id_syceron="33434… | |
| 16130000607654 | L16/debats | 16 | 16130000607620 | 16130000607653 | 1 | Amendements nos 7, 19 | Amendements n<sup>os</sup> <lienAdt id_syceron="3343710"> 7</lienAdt>, <lienAdt id_syceron="3343713"> 19</lienAdt> | |
| 16130000607657 | L16/debats | 16 | 16130000607620 | 16130000607656 | 1 | Amendements nos 23, 8 | Amendements n<sup>os</sup> <lienAdt id_syceron="3343729"> 23</lienAdt>, <lienAdt id_syceron="3343731"> 8</lienAdt> | |
| 16130000607658 | L16/debats | 16 | 16130000607620 | 16130000607656 | 2 | Sous-amendement no 25 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3343735"> 25</lienAdt> | |
| 16130000607660 | L16/debats | 16 | 16130000607620 | 16130000607659 | 1 | Amendements nos 14, 15, 3, 10 | Amendements n<sup>os</sup> <lienAdt id_syceron="3343744"> 14, 15</lienAdt>, <lienAdt id_syceron="3343757"> 3</lienAdt>, <lienAdt id_syceron="3343947"> 10</lienA… | |
| 16130000607662 | L16/debats | 16 | 16130000607620 | 16130000607661 | 1 | Amendement no 24 | Amendement n<sup>o</sup> <lienAdt id_syceron="3343977"> 24</lienAdt> | |
| 16130000608902 | L16/debats | 16 | 16130000608880 | 16130000608901 | 1 | Mme Christine Engrand | 3346279 | |
| 16130000608903 | L16/debats | 16 | 16130000608880 | 16130000608901 | 2 | M. Thibault Bazin | 3346283 | |
| 16130000608904 | L16/debats | 16 | 16130000608880 | 16130000608901 | 3 | Mme Danielle Brulebois | 3346289 | |
| 16130000608905 | L16/debats | 16 | 16130000608880 | 16130000608901 | 4 | Amendements nos 36, 108, 197, 59, 274, 198, 110, 100, 259 | Amendements n<sup>os</sup> <lienAdt id_syceron="3346291"> 36</lienAdt>, <lienAdt id_syceron="3346544"> 108</lienAdt>, <lienAdt id_syceron="3346547"> 197</lienAd… | |
| 16130000608907 | L16/debats | 16 | 16130000608880 | 16130000608906 | 1 | Amendement no 191 | Amendement n<sup>o</sup> <lienAdt id_syceron="3346694"> 191</lienAdt> | |
| 16130000608909 | L16/debats | 16 | 16130000608880 | 16130000608908 | 1 | M. Frédéric Falcon | 3346704 | |
| 16130000608910 | L16/debats | 16 | 16130000608880 | 16130000608908 | 2 | Mme Ersilia Soudais | 3346708 | |
| 16130000608911 | L16/debats | 16 | 16130000608880 | 16130000608908 | 3 | M. Thibault Bazin | 3346712 | |
| 16130000608912 | L16/debats | 16 | 16130000608880 | 16130000608908 | 4 | M. Christophe Béchu, ministre | 3346715 | |
| 16130000608913 | L16/debats | 16 | 16130000608880 | 16130000608908 | 5 | Amendements nos 239, 199, 61, 93, 79 | Amendements n<sup>os</sup> <lienAdt id_syceron="3345128"> 239</lienAdt>, <lienAdt id_syceron="3345144"> 199</lienAdt>, <lienAdt id_syceron="3345147"> 61</lienAd… | |
| 16130000608914 | L16/debats | 16 | 16130000608880 | 16130000608908 | 6 | Sous-amendement no 366 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3345190"> 366</lienAdt> | |
| 16130000608915 | L16/debats | 16 | 16130000608880 | 16130000608908 | 7 | Amendements nos 87, 29, 30, 32, 31, 159, 200, 201, 342, 256, 2, 346 rectifié, 80, 94, 202, 203 | Amendements n<sup>os</sup> <lienAdt id_syceron="3345211"> 87</lienAdt>, <lienAdt id_syceron="3345217"> 29, 30, 32, 31</lienAdt>, <lienAdt id_syceron="3345739"> … | |
| 16130000608917 | L16/debats | 16 | 16130000608880 | 16130000608916 | 1 | Amendements nos 326, 271, 232 | Amendements n<sup>os</sup> <lienAdt id_syceron="3345955"> 326</lienAdt>, <lienAdt id_syceron="3345959"> 271</lienAdt>, <lienAdt id_syceron="3345990"> 232</lienA… | |
| 16130000608920 | L16/debats | 16 | 16130000608880 | 16130000608919 | 1 | M. Frédéric Falcon | 3345996 | |
| 16130000608921 | L16/debats | 16 | 16130000608880 | 16130000608919 | 2 | Amendements nos 38, 328, 63, 62, 88, 74 | Amendements n<sup>os</sup> <lienAdt id_syceron="3346002"> 38</lienAdt>, <lienAdt id_syceron="3346105"> 328</lienAdt>, <lienAdt id_syceron="3346110"> 63</lienAdt… | |
| 16130000608923 | L16/debats | 16 | 16130000608880 | 16130000608922 | 1 | Amendements nos 166, 194, 167, 90, 89, 347, 352 | Amendements n<sup>os</sup> <lienAdt id_syceron="3346137"> 166</lienAdt>, <lienAdt id_syceron="3346157"> 194</lienAdt>, <lienAdt id_syceron="3346164"> 167</lienA… |