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 |
|---|---|---|---|---|---|---|---|---|
| 16130000397345 | L16/debats | 16 | 16130000397329 | 16130000397343 | 2 | Mme la présidente | 3100570 | |
| 16130000397380 | L16/debats | 16 | 16130000397329 | 16130000397379 | 1 | M. Max Mathiasin | 3101131 | |
| 16130000397381 | L16/debats | 16 | 16130000397329 | 16130000397379 | 2 | M. Jean-François Rousset | 3101140 | |
| 16130000397382 | L16/debats | 16 | 16130000397329 | 16130000397379 | 3 | M. Jean-Hugues Ratenon | 3101144 | |
| 16130000397383 | L16/debats | 16 | 16130000397329 | 16130000397379 | 4 | Mme Christelle Petex-Levet | 3101151 | |
| 16130000397384 | L16/debats | 16 | 16130000397329 | 16130000397379 | 5 | M. Philippe Vigier | 3101154 | |
| 16130000397385 | L16/debats | 16 | 16130000397329 | 16130000397379 | 6 | M. Elie Califer | 3101159 | |
| 16130000397386 | L16/debats | 16 | 16130000397329 | 16130000397379 | 7 | M. Frédéric Valletoux | 3101164 | |
| 16130000397387 | L16/debats | 16 | 16130000397329 | 16130000397379 | 8 | M. Fabien Roussel | 3101176 | |
| 16130000397388 | L16/debats | 16 | 16130000397329 | 16130000397379 | 9 | Mme la présidente | 3100855 | |
| 16130000397389 | L16/debats | 16 | 16130000397329 | 16130000397379 | 10 | Amendements nos 8, 9 | Amendements n<sup>os</sup> <lienAdt id_syceron="3100858"> 8</lienAdt>, <lienAdt id_syceron="3100890"> 9</lienAdt> | |
| 16130000397391 | L16/debats | 16 | 16130000397329 | 16130000397390 | 1 | M. Christian Baptiste | 3100922 | |
| 16130000397392 | L16/debats | 16 | 16130000397329 | 16130000397390 | 2 | M. François Braun, ministre | 3100937 | |
| 16130000397394 | L16/debats | 16 | 16130000397329 | 16130000397393 | 1 | Amendements nos 1, 6 | Amendements n<sup>os</sup> <lienAdt id_syceron="3100945"> 1</lienAdt>, <lienAdt id_syceron="3100946"> 6</lienAdt> | |
| 16130000397395 | L16/debats | 16 | 16130000397329 | 16130000397393 | 2 | Mme la présidente | 3100977 | |
| 16130000398689 | L16/debats | 16 | 16130000398666 | 16130000398688 | 1 | M. Jean-René Cazeneuve | 3103570 | |
| 16130000398692 | L16/debats | 16 | 16130000398666 | 16130000398691 | 1 | Amendement no 11 | Amendement n<sup>o</sup> <lienAdt id_syceron="3103586"> 11</lienAdt> | |
| 16130000398694 | L16/debats | 16 | 16130000398666 | 16130000398693 | 1 | M. Emmanuel Lacresse | 3103687 | |
| 16130000398695 | L16/debats | 16 | 16130000398666 | 16130000398693 | 2 | M. Pascal Lecamp | 3103695 | |
| 16130000398696 | L16/debats | 16 | 16130000398666 | 16130000398693 | 3 | Amendement no 24 | Amendement n<sup>o</sup> <lienAdt id_syceron="3103698"> 24</lienAdt> | |
| 16130000398698 | L16/debats | 16 | 16130000398666 | 16130000398697 | 1 | Amendements nos 12, 21, 44, 22, 45, 42 | Amendements n<sup>os</sup> <lienAdt id_syceron="3104259"> 12</lienAdt>, <lienAdt id_syceron="3104262"> 21</lienAdt>, <lienAdt id_syceron="3104269"> 44</lienAdt>… | |
| 16130000398699 | L16/debats | 16 | 16130000398666 | 16130000398697 | 2 | Sous-amendement no 62 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3104549"> 62</lienAdt> | |
| 16130000398700 | L16/debats | 16 | 16130000398666 | 16130000398697 | 3 | Amendements nos 23, 46 | Amendements n<sup>os</sup> <lienAdt id_syceron="3104584"> 23</lienAdt>, <lienAdt id_syceron="3104595"> 46</lienAdt> | |
| 16130000398702 | L16/debats | 16 | 16130000398666 | 16130000398701 | 1 | Mme Nadia Hai | 3104645 | |
| 16130000398705 | L16/debats | 16 | 16130000398666 | 16130000398704 | 1 | M. André Chassaigne | 3104671 | |
| 16130000398706 | L16/debats | 16 | 16130000398666 | 16130000398704 | 2 | M. Roland Lescure, ministre délégué | 3104677 | |
| 16130000398707 | L16/debats | 16 | 16130000398666 | 16130000398704 | 3 | M. Mathieu Lefèvre | 3104691 | |
| 16130000398709 | L16/debats | 16 | 16130000398666 | 16130000398708 | 1 | Amendements nos 33, 40 | Amendements n<sup>os</sup> <lienAdt id_syceron="3104701"> 33</lienAdt>, <lienAdt id_syceron="3103413"> 40</lienAdt> | |
| 16130000398711 | L16/debats | 16 | 16130000398666 | 16130000398710 | 1 | Amendement no 13 | Amendement n<sup>o</sup> <lienAdt id_syceron="3103440"> 13</lienAdt> | |
| 16130000398713 | L16/debats | 16 | 16130000398666 | 16130000398712 | 1 | M. Mathieu Lefèvre | 3103445 | |
| 16130000398714 | L16/debats | 16 | 16130000398666 | 16130000398712 | 2 | M. Pascal Lecamp | 3103457 | |
| 16130000398715 | L16/debats | 16 | 16130000398666 | 16130000398712 | 3 | Amendements nos 27, 47, 6, 10, 37, 8, 39, 56, 57, 48 | Amendements n<sup>os</sup> <lienAdt id_syceron="3103460"> 27</lienAdt>, <lienAdt id_syceron="3103474"> 47</lienAdt>, <lienAdt id_syceron="3101893"> 6</lienAdt>,… | |
| 16130000398716 | L16/debats | 16 | 16130000398666 | 16130000398712 | 4 | Sous-amendement no 59 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3102079"> 59</lienAdt> | |
| 16130000398717 | L16/debats | 16 | 16130000398666 | 16130000398712 | 5 | Amendements nos 26, 49 | Amendements n<sup>os</sup> <lienAdt id_syceron="3102834"> 26</lienAdt>, <lienAdt id_syceron="3102843"> 49</lienAdt> | |
| 16130000398719 | L16/debats | 16 | 16130000398666 | 16130000398718 | 1 | M. Stéphane Vojetta | 3103208 | |
| 16130000398721 | L16/debats | 16 | 16130000398666 | 16130000398720 | 1 | Amendements nos 35, 50, 51 | Amendements n<sup>os</sup> <lienAdt id_syceron="3103217"> 35</lienAdt>, <lienAdt id_syceron="3103245"> 50, 51</lienAdt> | |
| 16130000398723 | L16/debats | 16 | 16130000398666 | 16130000398722 | 1 | M. Pascal Lecamp | 3104334 | |
| 16130000398725 | L16/debats | 16 | 16130000398666 | 16130000398724 | 1 | Amendements nos 58 rectifié, 28, 53 | Amendements n<sup>os</sup> <lienAdt id_syceron="3104341"> 58 rectifié</lienAdt>, <lienAdt id_syceron="3104343"> 28</lienAdt>, <lienAdt id_syceron="3104345"> 53<… | |
| 16130000398727 | L16/debats | 16 | 16130000398666 | 16130000398726 | 1 | Amendements nos 29, 31, 52 | Amendements n<sup>os</sup> <lienAdt id_syceron="3104470"> 29</lienAdt>, <lienAdt id_syceron="3104476"> 31</lienAdt>, <lienAdt id_syceron="3104480"> 52</lienAdt> | |
| 16130000398729 | L16/debats | 16 | 16130000398666 | 16130000398728 | 1 | Mme Nadia Hai | 3104504 | |
| 16130000398732 | L16/debats | 16 | 16130000398666 | 16130000398731 | 1 | M. Jean-René Cazeneuve | 3104519 | |
| 16130000398735 | L16/debats | 16 | 16130000398666 | 16130000398734 | 1 | Amendements nos 30, 38, 36, 54 | Amendements n<sup>os</sup> <lienAdt id_syceron="3104769"> 30</lienAdt>, <lienAdt id_syceron="3104772"> 38</lienAdt>, <lienAdt id_syceron="3104781"> 36</lienAdt>… | |
| 16130000400900 | L16/debats | 16 | 16130000400883 | 16130000400899 | 1 | M. Sébastien Jumel | 3102892 | |
| 16130000400901 | L16/debats | 16 | 16130000400883 | 16130000400899 | 2 | M. Sylvain Maillard | 3102902 | |
| 16130000400904 | L16/debats | 16 | 16130000400883 | 16130000400902 | 1 | Mme la présidente | 3103299 | |
| 16130000402786 | L16/debats | 16 | 16130000402665 | 16130000402785 | 1 | M. Aymeric Caron | 3106176 | |
| 16130000402787 | L16/debats | 16 | 16130000402665 | 16130000402785 | 2 | Mme la présidente | 3106177 | |
| 16130000404404 | L16/debats | 16 | 16130000404389 | 16130000404403 | 1 | M. Michel Guiniot | 3107333 | |
| 16130000404405 | L16/debats | 16 | 16130000404389 | 16130000404403 | 2 | M. Nicolas Dupont-Aignan | 3107343 | |
| 16130000404406 | L16/debats | 16 | 16130000404389 | 16130000404403 | 3 | Mme Raquel Garrido | 3107349 |