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 |
|---|---|---|---|---|---|---|---|---|
| 15130000847363 | L15/debats | 15 | 15130000847336 | 15130000847361 | 2 | Mme Elsa Faucillon | 1709844 | |
| 15130000847364 | L15/debats | 15 | 15130000847336 | 15130000847361 | 3 | M. Michel Castellani | 1709871 | |
| 15130000847365 | L15/debats | 15 | 15130000847336 | 15130000847361 | 4 | M. Pacôme Rupin | 1710091 | |
| 15130000847366 | L15/debats | 15 | 15130000847336 | 15130000847361 | 5 | M. Matthieu Orphelin | 1710107 | |
| 15130000847367 | L15/debats | 15 | 15130000847336 | 15130000847361 | 6 | M. Raphaël Gérard | 1710121 | |
| 15130000847370 | L15/debats | 15 | 15130000847336 | 15130000847369 | 1 | M. Nicolas Dupont-Aignan | 1710144 | |
| 15130000847371 | L15/debats | 15 | 15130000847336 | 15130000847369 | 2 | Mme Emmanuelle Ménard | 1710151 | |
| 15130000847372 | L15/debats | 15 | 15130000847336 | 15130000847369 | 3 | Mme Michèle Victory | 1710161 | |
| 15130000847373 | L15/debats | 15 | 15130000847336 | 15130000847369 | 4 | Mme Valérie Boyer | 1710163 | |
| 15130000847374 | L15/debats | 15 | 15130000847336 | 15130000847369 | 5 | M. M’jid El Guerrab | 1710177 | |
| 15130000847375 | L15/debats | 15 | 15130000847336 | 15130000847369 | 6 | M. Jean-Louis Thiériot | 1710245 | |
| 15130000847376 | L15/debats | 15 | 15130000847336 | 15130000847369 | 7 | Mme Constance Le Grip | 1710254 | |
| 15130000847377 | L15/debats | 15 | 15130000847336 | 15130000847369 | 8 | M. Gilles Lurton | 1710260 | |
| 15130000847378 | L15/debats | 15 | 15130000847336 | 15130000847369 | 9 | M. Guillaume Larrivé | 1710267 | |
| 15130000847379 | L15/debats | 15 | 15130000847336 | 15130000847369 | 10 | M. Bruno Fuchs | 1710272 | |
| 15130000847782 | L15/debats | 15 | 15130000847777 | 15130000847781 | 1 | Amendement no 227 | Amendement n<sup>o</sup><lienAdt id_syceron="1710189"> 227</lienAdt> | |
| 15130000847783 | L15/debats | 15 | 15130000847777 | 15130000847781 | 2 | Mme Anne Brugnera, rapporteure de la commission des affaires culturelles et de l’éducation | 1710192 | |
| 15130000847784 | L15/debats | 15 | 15130000847777 | 15130000847781 | 3 | M. Franck Riester, ministre de la culture | 1710194 | |
| 15130000847786 | L15/debats | 15 | 15130000847777 | 15130000847785 | 1 | Mme Constance Le Grip | 1710199 | |
| 15130000847787 | L15/debats | 15 | 15130000847777 | 15130000847785 | 2 | M. le président | 1710202 | |
| 15130000847788 | L15/debats | 15 | 15130000847777 | 15130000847785 | 3 | M. Franck Riester, ministre | 1710204 | |
| 15130000847790 | L15/debats | 15 | 15130000847777 | 15130000847789 | 1 | Amendements nos 256, 98, 40, 71, 79, 103, 118, 133, 77, 9, 113, 182, 78, 206 | Amendements n<sup>os</sup><lienAdt id_syceron="1710209"> 256</lienAdt>, <lienAdt id_syceron="1710224"> 98</lienAdt>, <lienAdt id_syceron="1710338"> 40</lienAdt>… | |
| 15130000847792 | L15/debats | 15 | 15130000847777 | 15130000847791 | 1 | Amendement no 235 | Amendement n<sup>o</sup><lienAdt id_syceron="1710432"> 235</lienAdt> | |
| 15130000847794 | L15/debats | 15 | 15130000847777 | 15130000847793 | 1 | Mme Emmanuelle Ménard | 1710446 | |
| 15130000847795 | L15/debats | 15 | 15130000847777 | 15130000847793 | 2 | Mme Anne-Christine Lang | 1710452 | |
| 15130000847796 | L15/debats | 15 | 15130000847777 | 15130000847793 | 3 | M. Pierre-Henri Dumont | 1710462 | |
| 15130000847797 | L15/debats | 15 | 15130000847777 | 15130000847793 | 4 | M. M’jid El Guerrab | 1710467 | |
| 15130000847798 | L15/debats | 15 | 15130000847777 | 15130000847793 | 5 | M. Antoine Herth | 1710471 | |
| 15130000847799 | L15/debats | 15 | 15130000847777 | 15130000847793 | 6 | Mme Constance Le Grip | 1710480 | |
| 15130000847800 | L15/debats | 15 | 15130000847777 | 15130000847793 | 7 | M. Michel Castellani | 1710486 | |
| 15130000847801 | L15/debats | 15 | 15130000847777 | 15130000847793 | 8 | Mme Céline Calvez | 1710493 | |
| 15130000847802 | L15/debats | 15 | 15130000847777 | 15130000847793 | 9 | M. Marc Le Fur | 1710498 | |
| 15130000847803 | L15/debats | 15 | 15130000847777 | 15130000847793 | 10 | Mme Valérie Boyer | 1710505 | |
| 15130000847804 | L15/debats | 15 | 15130000847777 | 15130000847793 | 11 | M. Philippe Vigier | 1710516 | |
| 15130000847805 | L15/debats | 15 | 15130000847777 | 15130000847793 | 12 | M. Éric Woerth | 1710591 | |
| 15130000847806 | L15/debats | 15 | 15130000847777 | 15130000847793 | 13 | Mme Sophie Mette | 1710596 | |
| 15130000847807 | L15/debats | 15 | 15130000847777 | 15130000847793 | 14 | M. Gilles Carrez | 1710599 | |
| 15130000847808 | L15/debats | 15 | 15130000847777 | 15130000847793 | 15 | M. Michel Larive | 1710607 | |
| 15130000847809 | L15/debats | 15 | 15130000847777 | 15130000847793 | 16 | Mme Anne Brugnera, rapporteure | 1710610 | |
| 15130000847810 | L15/debats | 15 | 15130000847777 | 15130000847793 | 17 | M. Franck Riester, ministre | 1710615 | |
| 15130000847811 | L15/debats | 15 | 15130000847777 | 15130000847793 | 18 | Amendements nos 190, 11, 41, 72, 85, 104, 121, 321 (sous-amendement), 268, 298, 138, 193, 248, 216, 10, 128, 129, 164, 247, 257, 189 | Amendements n<sup>os</sup><lienAdt id_syceron="1710745"> 190</lienAdt>, <lienAdt id_syceron="1710761"> 11</lienAdt>, <lienAdt id_syceron="1710763">41</lienAdt>,… | |
| 15130000847813 | L15/debats | 15 | 15130000847777 | 15130000847812 | 1 | Amendement no 130 | Amendement n<sup>o</sup><lienAdt id_syceron="1711226"> 130</lienAdt> | |
| 15130000847816 | L15/debats | 15 | 15130000847777 | 15130000847815 | 1 | Mme Emmanuelle Ménard | 1711276 | |
| 15130000847817 | L15/debats | 15 | 15130000847777 | 15130000847815 | 2 | Mme Valérie Boyer | 1711337 | |
| 15130000847818 | L15/debats | 15 | 15130000847777 | 15130000847815 | 3 | M. Marc Le Fur | 1711343 | |
| 15130000847819 | L15/debats | 15 | 15130000847777 | 15130000847815 | 4 | M. Michel Castellani | 1711347 | |
| 15130000847820 | L15/debats | 15 | 15130000847777 | 15130000847815 | 5 | Amendements nos 242, 64, 13, 12, 87, 134, 88, 14, 42, 73, 86, 105, 81, 236, 237, 263, 258, 277 rectifié | Amendements n<sup>os</sup><lienAdt id_syceron="1711350"> 242</lienAdt>, <lienAdt id_syceron="1711356"> 64</lienAdt>, <lienAdt id_syceron="1711358"> 13</lienAdt>… | |
| 15130000847822 | L15/debats | 15 | 15130000847777 | 15130000847821 | 1 | Amendements nos 111, 188, 83 | Amendements n<sup>os</sup><lienAdt id_syceron="1711576"> 111</lienAdt>, <lienAdt id_syceron="1711602"> 188</lienAdt>, <lienAdt id_syceron="1711710"> 83</lienAdt… | |
| 15130000847824 | L15/debats | 15 | 15130000847777 | 15130000847823 | 1 | M. Marc Le Fur | 1711721 | |
| 15130000847825 | L15/debats | 15 | 15130000847777 | 15130000847823 | 2 | Mme Valérie Boyer | 1711724 |