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 |
|---|---|---|---|---|---|---|---|---|
| 15130001355986 | L15/debats | 15 | 15130001355914 | 15130001355983 | 3 | M. Clément Beaune, secrétaire d’État chargé des affaires européennes | 2215625 | |
| 15130001355987 | L15/debats | 15 | 15130001355914 | 15130001355983 | 4 | Amendements nos 28, 32, 21, 22, 23, 9, 31, 24 | Amendements n<sup>os</sup><lienAdt id_syceron="2215630"> 28</lienAdt>, <lienAdt id_syceron="2215639"> 32</lienAdt>, <lienAdt id_syceron="2215641"> 21, 22, 23</l… | |
| 15130001355989 | L15/debats | 15 | 15130001355914 | 15130001355988 | 1 | Amendement no 36 | Amendement n<sup>o</sup><lienAdt id_syceron="2215844"> 36</lienAdt> | |
| 15130001355991 | L15/debats | 15 | 15130001355914 | 15130001355990 | 1 | Mme Constance Le Grip | 2215862 | |
| 15130001355992 | L15/debats | 15 | 15130001355914 | 15130001355990 | 2 | M. Jean Lassalle | 2215867 | |
| 15130001355993 | L15/debats | 15 | 15130001355914 | 15130001355990 | 3 | Mme Céline Calvez | 2215877 | |
| 15130001355994 | L15/debats | 15 | 15130001355914 | 15130001355990 | 4 | Amendements nos 26, 30, 27, 54, 45 | Amendements n<sup>os</sup><lienAdt id_syceron="2215883"> 26</lienAdt>, <lienAdt id_syceron="2215461"> 30</lienAdt>, <lienAdt id_syceron="2215473"> 27</lienAdt>,… | |
| 15130001356870 | L15/debats | 15 | 15130001356849 | 15130001356869 | 1 | Mme Catherine Fabre | 2217014 | |
| 15130001356871 | L15/debats | 15 | 15130001356849 | 15130001356869 | 2 | M. Xavier Breton | 2217231 | |
| 15130001356872 | L15/debats | 15 | 15130001356849 | 15130001356869 | 3 | M. Patrick Mignola | 2217235 | |
| 15130001356873 | L15/debats | 15 | 15130001356849 | 15130001356869 | 4 | Mme Valérie Petit | 2217246 | |
| 15130001356874 | L15/debats | 15 | 15130001356849 | 15130001356869 | 5 | Mme Clémentine Autain | 2217254 | |
| 15130001356875 | L15/debats | 15 | 15130001356849 | 15130001356869 | 6 | M. Joachim Son-Forget | 2217267 | |
| 15130001356876 | L15/debats | 15 | 15130001356849 | 15130001356869 | 7 | Mme Agnès Thill | 2217281 | |
| 15130001356877 | L15/debats | 15 | 15130001356849 | 15130001356869 | 8 | Amendements nos 1, 7, 11, 21, 34, 63, 71, 81, 85, 44, 56, 97, 80, 3, 51, 95 | Amendements n<sup>os</sup><lienAdt id_syceron="2217336"> 1</lienAdt>, <lienAdt id_syceron="2217341"> 7</lienAdt>, <lienAdt id_syceron="2217354"> 11</lienAdt>, <… | |
| 15130001356880 | L15/debats | 15 | 15130001356849 | 15130001356879 | 1 | Amendements nos 16, 26 | Amendements n<sup>os</sup><lienAdt id_syceron="2217592"> 16</lienAdt>, <lienAdt id_syceron="2217642"> 26</lienAdt> | |
| 15130001356881 | L15/debats | 15 | 15130001356849 | 15130001356879 | 2 | Sous-amendement no 122 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2217645"> 122</lienAdt> | |
| 15130001356882 | L15/debats | 15 | 15130001356849 | 15130001356879 | 3 | Amendements nos 78, 86 | Amendements n<sup>os</sup><lienAdt id_syceron="2217682"> 78</lienAdt>, <lienAdt id_syceron="2218172"> 86</lienAdt> | |
| 15130001356883 | L15/debats | 15 | 15130001356849 | 15130001356879 | 4 | Sous-amendement no 123 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2218142"> 123</lienAdt> | |
| 15130001356884 | L15/debats | 15 | 15130001356849 | 15130001356879 | 5 | Amendements nos 37 rectifié, 45, 91 | Amendements n<sup>os</sup><lienAdt id_syceron="2218146"> 37 rectifié</lienAdt>, <lienAdt id_syceron="2218150"> 45</lienAdt>, <lienAdt id_syceron="2218153"> 91</… | |
| 15130001356885 | L15/debats | 15 | 15130001356849 | 15130001356879 | 6 | Sous-amendement no 124 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2218157"> 124</lienAdt> | |
| 15130001356886 | L15/debats | 15 | 15130001356849 | 15130001356879 | 7 | Amendements nos 13, 23 | Amendements n<sup>os</sup><lienAdt id_syceron="2218161"> 13</lienAdt>, <lienAdt id_syceron="2218164"> 23</lienAdt> | |
| 15130001356887 | L15/debats | 15 | 15130001356849 | 15130001356879 | 8 | Sous-amendement no 125 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2218167"> 125</lienAdt> | |
| 15130001357988 | L15/debats | 15 | 15130001357983 | 15130001357987 | 1 | Amendements nos 15, 25 | Amendements n<sup>os</sup><lienAdt id_syceron="2217804"> 15</lienAdt>, <lienAdt id_syceron="2217808"> 25</lienAdt> | |
| 15130001357989 | L15/debats | 15 | 15130001357983 | 15130001357987 | 2 | Mme Albane Gaillot, rapporteure de la commission des affaires sociales | 2217811 | |
| 15130001357990 | L15/debats | 15 | 15130001357983 | 15130001357987 | 3 | Mme Brigitte Bourguignon, ministre déléguée chargée de l’autonomie | 2217815 | |
| 15130001357992 | L15/debats | 15 | 15130001357983 | 15130001357991 | 1 | Mme Marie-Pierre Rixain | 2217843 | |
| 15130001357993 | L15/debats | 15 | 15130001357983 | 15130001357991 | 2 | Mme Agnès Thill | 2217848 | |
| 15130001357994 | L15/debats | 15 | 15130001357983 | 15130001357991 | 3 | Amendements nos 8, 17, 40, 59, 65, 64 rectifié, 88 rectifié, 94, 113, 106, 60, 4, 52 | Amendements n<sup>os</sup><lienAdt id_syceron="2218179"> 8</lienAdt>, <lienAdt id_syceron="2218184"> 17</lienAdt>, <lienAdt id_syceron="2218188"> 40</lienAdt>, … | |
| 15130001357996 | L15/debats | 15 | 15130001357983 | 15130001357995 | 1 | Amendements nos 119 rectifié, 120 rectifié | Amendements n<sup>os</sup><lienAdt id_syceron="2218539"> 119 rectifié, 120 rectifié</lienAdt> | |
| 15130001357998 | L15/debats | 15 | 15130001357983 | 15130001357997 | 1 | M. Guillaume Gouffier-Cha | 2218552 | |
| 15130001357999 | L15/debats | 15 | 15130001357983 | 15130001357997 | 2 | M. Thibault Bazin | 2218554 | |
| 15130001358000 | L15/debats | 15 | 15130001357983 | 15130001357997 | 3 | M. Pascal Brindeau | 2218556 | |
| 15130001358001 | L15/debats | 15 | 15130001357983 | 15130001357997 | 4 | Amendements nos 9, 18 | Amendements n<sup>os</sup><lienAdt id_syceron="2218560"> 9</lienAdt>, <lienAdt id_syceron="2218564"> 18</lienAdt> | |
| 15130001358003 | L15/debats | 15 | 15130001357983 | 15130001358002 | 1 | M. Matthieu Orphelin | 2218569 | |
| 15130001358004 | L15/debats | 15 | 15130001357983 | 15130001358002 | 2 | Mme la présidente | 2218575 | |
| 15130001358006 | L15/debats | 15 | 15130001357983 | 15130001358005 | 1 | Amendements nos 28, 39, 61, 66, 72, 82, 38, 46, 55 rectifié, 87 | Amendements n<sup>os</sup><lienAdt id_syceron="2218728"> 28</lienAdt>, <lienAdt id_syceron="2218731"> 39</lienAdt>, <lienAdt id_syceron="2218735"> 61</lienAdt>,… | |
| 15130001358008 | L15/debats | 15 | 15130001357983 | 15130001358007 | 1 | Mme Marie-Pierre Rixain | 2218881 | |
| 15130001358009 | L15/debats | 15 | 15130001357983 | 15130001358007 | 2 | M. Patrick Hetzel | 2218885 | |
| 15130001358010 | L15/debats | 15 | 15130001357983 | 15130001358007 | 3 | M. Jean-Christophe Lagarde | 2218890 | |
| 15130001358011 | L15/debats | 15 | 15130001357983 | 15130001358007 | 4 | Amendements nos 2, 10, 19, 29, 35, 69, 70, 83 | Amendements n<sup>os</sup><lienAdt id_syceron="2218895"> 2</lienAdt>, <lienAdt id_syceron="2218900"> 10</lienAdt>, <lienAdt id_syceron="2218229"> 19</lienAdt>, … | |
| 15130001358013 | L15/debats | 15 | 15130001357983 | 15130001358012 | 1 | Amendements nos 50, 68, 90, 32, 118 rectifié, 5, 53 | Amendements n<sup>os</sup><lienAdt id_syceron="2217901"> 50</lienAdt>, <lienAdt id_syceron="2217906"> 68</lienAdt>, <lienAdt id_syceron="2217910"> 90</lienAdt>,… | |
| 15130001358015 | L15/debats | 15 | 15130001357983 | 15130001358014 | 1 | Amendements nos 103, 6, 54 | Amendements n<sup>os</sup><lienAdt id_syceron="2219098"> 103</lienAdt>, <lienAdt id_syceron="2219280"> 6</lienAdt>, <lienAdt id_syceron="2219529"> 54</lienAdt> | |
| 15130001358017 | L15/debats | 15 | 15130001357983 | 15130001358016 | 1 | Mme Bérangère Couillard | 2218822 | |
| 15130001358018 | L15/debats | 15 | 15130001357983 | 15130001358016 | 2 | Mme Anne-Laure Blin | 2218826 | |
| 15130001358019 | L15/debats | 15 | 15130001357983 | 15130001358016 | 3 | M. Jean-Louis Bourlanges | 2218829 | |
| 15130001358020 | L15/debats | 15 | 15130001357983 | 15130001358016 | 4 | Mme Agnès Thill | 2218834 | |
| 15130001358021 | L15/debats | 15 | 15130001357983 | 15130001358016 | 5 | Amendements nos 43, 48, 67, 89, 92, 41 | Amendements n<sup>os</sup><lienAdt id_syceron="2218836"> 43</lienAdt>, <lienAdt id_syceron="2218839"> 48</lienAdt>, <lienAdt id_syceron="2218844"> 67</lienAdt>,… | |
| 15130001358023 | L15/debats | 15 | 15130001357983 | 15130001358022 | 1 | Amendements nos 12, 22, 14, 24, 20, 30, 42, 62 | Amendements n<sup>os</sup><lienAdt id_syceron="2218371"> 12</lienAdt>, <lienAdt id_syceron="2218381"> 22</lienAdt>, <lienAdt id_syceron="2218590"> 14</lienAdt>,… | |
| 15130001358025 | L15/debats | 15 | 15130001357983 | 15130001358024 | 1 | Amendements nos 93, 84, 96, 108, 98 | Amendements n<sup>os</sup><lienAdt id_syceron="2218960"> 93</lienAdt>, <lienAdt id_syceron="2218981"> 84</lienAdt>, <lienAdt id_syceron="2219040"> 96</lienAdt>,… |