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 |
|---|---|---|---|---|---|---|---|---|
| 16130000653699 | L16/debats | 16 | 16130000653620 | 16130000653696 | 3 | Mme la présidente | 3389991 | |
| 16130000653701 | L16/debats | 16 | 16130000653620 | 16130000653700 | 1 | Amendements nos 56, 53, 65, 57 | Amendements n<sup>os</sup> <lienAdt id_syceron="3389993"> 56</lienAdt>, <lienAdt id_syceron="3390358"> 53</lienAdt>, <lienAdt id_syceron="3390360"> 65</lienAdt>… | |
| 16130000653703 | L16/debats | 16 | 16130000653620 | 16130000653702 | 1 | Mme Sandra Regol | 3390372 | |
| 16130000653705 | L16/debats | 16 | 16130000653620 | 16130000653704 | 1 | Amendements nos 66, 73, 72, 34 rectifié, 38, 39, 40 | Amendements n<sup>os</sup> <lienAdt id_syceron="3390437"> 66, 73</lienAdt>, <lienAdt id_syceron="3390392"> 72</lienAdt>, <lienAdt id_syceron="3390416"> 34 recti… | |
| 16130000653707 | L16/debats | 16 | 16130000653620 | 16130000653706 | 1 | Amendements nos 29, 74, 77, 7, 76, 16, 78, 12 | Amendements n<sup>os</sup> <lienAdt id_syceron="3389122"> 29</lienAdt>, <lienAdt id_syceron="3389125"> 74</lienAdt>, <lienAdt id_syceron="3389130"> 77</lienAdt>… | |
| 16130000653709 | L16/debats | 16 | 16130000653620 | 16130000653708 | 1 | Amendement no 67 | Amendement n<sup>o</sup> <lienAdt id_syceron="3389413"> 67</lienAdt> | |
| 16130000653711 | L16/debats | 16 | 16130000653620 | 16130000653710 | 1 | Mme Danièle Obono | 3389445 | |
| 16130000653712 | L16/debats | 16 | 16130000653620 | 16130000653710 | 2 | M. Julien Odoul | 3389452 | |
| 16130000653715 | L16/debats | 16 | 16130000653620 | 16130000653714 | 1 | Amendements nos 81, 41, 68, 83 | Amendements n<sup>os</sup> <lienAdt id_syceron="3389826"> 81</lienAdt>, <lienAdt id_syceron="3389828"> 41</lienAdt>, <lienAdt id_syceron="3389830"> 68</lienAdt>… | |
| 16130000653717 | L16/debats | 16 | 16130000653620 | 16130000653716 | 1 | Amendement no 31 | Amendement n<sup>o</sup> <lienAdt id_syceron="3389839"> 31</lienAdt> | |
| 16130000653718 | L16/debats | 16 | 16130000653620 | 16130000653716 | 2 | Sous-amendement no 88 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3389852"> 88</lienAdt> | |
| 16130000653720 | L16/debats | 16 | 16130000653620 | 16130000653719 | 1 | M. Julien Odoul | 3389860 | |
| 16130000653721 | L16/debats | 16 | 16130000653620 | 16130000653719 | 2 | M. Antoine Léaument | 3389864 | |
| 16130000653722 | L16/debats | 16 | 16130000653620 | 16130000653719 | 3 | Amendement no 58 | Amendement n<sup>o</sup> <lienAdt id_syceron="3389871"> 58</lienAdt> | |
| 16130000653724 | L16/debats | 16 | 16130000653620 | 16130000653723 | 1 | Mme Caroline Yadan | 3389891 | |
| 16130000653725 | L16/debats | 16 | 16130000653620 | 16130000653723 | 2 | M. Emeric Salmon | 3389893 | |
| 16130000653728 | L16/debats | 16 | 16130000653620 | 16130000653727 | 1 | M. Emeric Salmon | 3389901 | |
| 16130000653730 | L16/debats | 16 | 16130000653620 | 16130000653729 | 1 | Amendements nos 59, 69, 42, 60 | Amendements n<sup>os</sup> <lienAdt id_syceron="3389908"> 59</lienAdt>, <lienAdt id_syceron="3389921"> 69</lienAdt>, <lienAdt id_syceron="3389925"> 42</lienAdt>… | |
| 16130000653732 | L16/debats | 16 | 16130000653620 | 16130000653731 | 1 | M. Julien Odoul | 3390511 | |
| 16130000653734 | L16/debats | 16 | 16130000653620 | 16130000653733 | 1 | Amendements nos 4, 61 | Amendements n<sup>os</sup> <lienAdt id_syceron="3390520"> 4</lienAdt>, <lienAdt id_syceron="3390522"> 61</lienAdt> | |
| 16130000653736 | L16/debats | 16 | 16130000653620 | 16130000653735 | 1 | Amendement no 64 | Amendement n<sup>o</sup> <lienAdt id_syceron="3390551"> 64</lienAdt> | |
| 16130000653738 | L16/debats | 16 | 16130000653620 | 16130000653737 | 1 | M. Sébastien Chenu | 3390573 | |
| 16130000653739 | L16/debats | 16 | 16130000653620 | 16130000653737 | 2 | M. Jérôme Guedj | 3390578 | |
| 16130000653740 | L16/debats | 16 | 16130000653620 | 16130000653737 | 3 | M. Laurent Jacobelli | 3390584 | |
| 16130000653743 | L16/debats | 16 | 16130000653620 | 16130000653742 | 1 | Mme Danièle Obono | 3390753 | |
| 16130000653744 | L16/debats | 16 | 16130000653620 | 16130000653742 | 2 | Amendements nos 3, 35 | Amendements n<sup>os</sup> <lienAdt id_syceron="3390918"> 3</lienAdt>, <lienAdt id_syceron="3390988"> 35</lienAdt> | |
| 16130000653746 | L16/debats | 16 | 16130000653620 | 16130000653745 | 1 | Amendements nos 9, 11, 13, 8, 10, 17 | Amendements n<sup>os</sup> <lienAdt id_syceron="3390781"> 9</lienAdt>, <lienAdt id_syceron="3390791"> 11</lienAdt>, <lienAdt id_syceron="3390799"> 13</lienAdt>,… | |
| 16130000656510 | L16/debats | 16 | 16130000656490 | 16130000656509 | 1 | Mme Laurence Cristol | 3390842 | |
| 16130000656511 | L16/debats | 16 | 16130000656490 | 16130000656509 | 2 | M. Sébastien Chenu | 3390846 | |
| 16130000656512 | L16/debats | 16 | 16130000656490 | 16130000656509 | 3 | Amendements nos 37, 6, 9, 17, 30, 36, 38, 22, 31, 5, 8 | Amendements n<sup>os</sup> <lienAdt id_syceron="3390855"> 37</lienAdt>, <lienAdt id_syceron="3390863"> 6</lienAdt>, <lienAdt id_syceron="3391211"> 9</lienAdt>, … | |
| 16130000656514 | L16/debats | 16 | 16130000656490 | 16130000656513 | 1 | M. David Valence | 3391379 | |
| 16130000656515 | L16/debats | 16 | 16130000656490 | 16130000656513 | 2 | M. Sébastien Chenu | 3391385 | |
| 16130000656516 | L16/debats | 16 | 16130000656490 | 16130000656513 | 3 | M. Andy Kerbrat | 3391391 | |
| 16130000656517 | L16/debats | 16 | 16130000656490 | 16130000656513 | 4 | Amendements nos 32, 23, 33 | Amendements n<sup>os</sup> <lienAdt id_syceron="3391395"> 32</lienAdt>, <lienAdt id_syceron="3391398"> 23</lienAdt>, <lienAdt id_syceron="3391403"> 33</lienAdt> | |
| 16130000656519 | L16/debats | 16 | 16130000656490 | 16130000656518 | 1 | Amendements nos 24, 34, 10 | Amendements n<sup>os</sup> <lienAdt id_syceron="3391413"> 24</lienAdt>, <lienAdt id_syceron="3391416"> 34</lienAdt>, <lienAdt id_syceron="3391424"> 10</lienAdt> | |
| 16130000656520 | L16/debats | 16 | 16130000656490 | 16130000656518 | 2 | Sous-amendement no 40 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3392028"> 40</lienAdt> | |
| 16130000656521 | L16/debats | 16 | 16130000656490 | 16130000656518 | 3 | Amendement no 25 | Amendement n<sup>o</sup> <lienAdt id_syceron="3392047"> 25</lienAdt> | |
| 16130000656523 | L16/debats | 16 | 16130000656490 | 16130000656522 | 1 | Amendements nos 35, 15, 3, 2, 11 rectifié, 13 | Amendements n<sup>os</sup> <lienAdt id_syceron="3392054"> 35</lienAdt>, <lienAdt id_syceron="3392061"> 15, 3</lienAdt>, <lienAdt id_syceron="3392713"> 2</lienAd… | |
| 16130000656525 | L16/debats | 16 | 16130000656490 | 16130000656524 | 1 | Amendements nos 19, 14 | Amendements n<sup>os</sup> <lienAdt id_syceron="3392091"> 19</lienAdt>, <lienAdt id_syceron="3392920"> 14</lienAdt> | |
| 16130000657090 | L16/debats | 16 | 16130000657069 | 16130000657089 | 1 | Amendements nos 30, 45, 21, 70, 58, 59, 20, 71, 32, 31, 64, 15, 8, 18 | Amendements n<sup>os</sup> <lienAdt id_syceron="3391647"> 30</lienAdt>, <lienAdt id_syceron="3391650"> 45</lienAdt>, <lienAdt id_syceron="3391656"> 21</lienAdt>… | |
| 16130000657091 | L16/debats | 16 | 16130000657069 | 16130000657089 | 2 | Sous-amendement no 73 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3391224"> 73</lienAdt> | |
| 16130000657092 | L16/debats | 16 | 16130000657069 | 16130000657089 | 3 | Amendements nos 19, 22, 23, 46, 9, 10 | Amendements n<sup>os</sup> <lienAdt id_syceron="3391241"> 19</lienAdt>, <lienAdt id_syceron="3391254"> 22</lienAdt>, <lienAdt id_syceron="3391265"> 23</lienAdt>… | |
| 16130000657095 | L16/debats | 16 | 16130000657069 | 16130000657094 | 1 | Amendement no 69 | Amendement n<sup>o</sup> <lienAdt id_syceron="3390666"> 69</lienAdt> | |
| 16130000657097 | L16/debats | 16 | 16130000657069 | 16130000657096 | 1 | Amendements nos 1, 11, 12 | Amendements n<sup>os</sup> <lienAdt id_syceron="3390672"> 1</lienAdt>, <lienAdt id_syceron="3391894"> 11</lienAdt>, <lienAdt id_syceron="3391899"> 12</lienAdt> | |
| 16130000657099 | L16/debats | 16 | 16130000657069 | 16130000657098 | 1 | Amendement no 2 | Amendement n<sup>o</sup> <lienAdt id_syceron="3391909"> 2</lienAdt> | |
| 16130000657101 | L16/debats | 16 | 16130000657069 | 16130000657100 | 1 | Amendements nos 44, 38, 16, 17 | Amendements n<sup>os</sup> <lienAdt id_syceron="3391921"> 44</lienAdt>, <lienAdt id_syceron="3391931"> 38</lienAdt>, <lienAdt id_syceron="3390943"> 16, 17</lien… | |
| 16130000657103 | L16/debats | 16 | 16130000657069 | 16130000657102 | 1 | Amendement no 67 | Amendement n<sup>o</sup> <lienAdt id_syceron="3390968"> 67</lienAdt> | |
| 16130000657105 | L16/debats | 16 | 16130000657069 | 16130000657104 | 1 | Amendements nos 39, 13, 40, 24, 6, 68, 63, 62 | Amendements n<sup>os</sup> <lienAdt id_syceron="3390975"> 39</lienAdt>, <lienAdt id_syceron="3392445"> 13</lienAdt>, <lienAdt id_syceron="3392458"> 40</lienAdt>… | |
| 16130000657108 | L16/debats | 16 | 16130000657069 | 16130000657107 | 1 | Amendements nos 7, 3, 4, 5 | Amendements n<sup>os</sup> <lienAdt id_syceron="3392496"> 7</lienAdt>, <lienAdt id_syceron="3392654"> 3, 4, 5</lienAdt> | |
| 16130000657110 | L16/debats | 16 | 16130000657069 | 16130000657109 | 1 | Amendement no 29 | Amendement n<sup>o</sup> <lienAdt id_syceron="3392668"> 29</lienAdt> |