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 |
|---|---|---|---|---|---|---|---|---|
| 16130000742633 | L16/debats | 16 | 16130000742608 | 16130000742632 | 1 | Mme Edwige Diaz | 3474121 | |
| 16130000742634 | L16/debats | 16 | 16130000742608 | 16130000742632 | 2 | M. Antoine Léaument | 3474124 | |
| 16130000742635 | L16/debats | 16 | 16130000742608 | 16130000742632 | 3 | Mme Anne-Laure Blin | 3474130 | |
| 16130000742636 | L16/debats | 16 | 16130000742608 | 16130000742632 | 4 | Amendements nos 2954, 4576, 23, 777, 1022, 1540, 2551, 2766, 1285, 29, 3410, 3997, 4627 | Amendements n<sup>os</sup> <lienAdt id_syceron="3474136"> 2954</lienAdt>, <lienAdt id_syceron="3476220"> 4576</lienAdt>, <lienAdt id_syceron="3476222"> 23</lien… | |
| 16130000742638 | L16/debats | 16 | 16130000742608 | 16130000742637 | 1 | Amendements nos 2610, 4123, 3998, 4694, 4692 | Amendements n<sup>os</sup> <lienAdt id_syceron="3476468"> 2610</lienAdt>, <lienAdt id_syceron="3476477"> 4123</lienAdt>, <lienAdt id_syceron="3476486"> 3998</li… | |
| 16130000742640 | L16/debats | 16 | 16130000742608 | 16130000742639 | 1 | Amendement no 3550 | Amendement n<sup>o</sup> <lienAdt id_syceron="3476525"> 3550</lienAdt> | |
| 16130000742642 | L16/debats | 16 | 16130000742608 | 16130000742641 | 1 | Mme Chantal Jourdan | 3476533 | |
| 16130000742643 | L16/debats | 16 | 16130000742608 | 16130000742641 | 2 | Mme Edwige Diaz | 3476751 | |
| 16130000742644 | L16/debats | 16 | 16130000742608 | 16130000742641 | 3 | Mme Aurélie Trouvé | 3476754 | |
| 16130000742645 | L16/debats | 16 | 16130000742608 | 16130000742641 | 4 | M. Julien Dive | 3476762 | |
| 16130000742646 | L16/debats | 16 | 16130000742608 | 16130000742641 | 5 | Amendements nos 1182, 25, 1026, 1672, 3944, 4701, 2955, 2449, 3954, 86, 2577, 4541, 4560, 4571, 5594, 2920, 3135, 1183, 89 rectifié, 2450, 2642 | Amendements n<sup>os</sup> <lienAdt id_syceron="3476764"> 1182</lienAdt>, <lienAdt id_syceron="3474762"> 25, 1026, 1672</lienAdt>, <lienAdt id_syceron="3474763"… | |
| 16130000742647 | L16/debats | 16 | 16130000742608 | 16130000742641 | 6 | Mme Sandrine Le Feur, rapporteure pour avis de la commission du développement durable et de l’aménagement du territoire | 3475171 | |
| 16130000742648 | L16/debats | 16 | 16130000742608 | 16130000742641 | 7 | Amendements nos 90, 1184, 1185, 1186, 2451, 91, 2487, 2639, 2956, 3957, 92, 1187, 3174, 2453, 2454, 2957, 1189, 2452, 3477, 3193, 3551, 3176, 1188, 93, 1190, 32… | Amendements n<sup>os</sup> <lienAdt id_syceron="3475183"> 90</lienAdt>, <lienAdt id_syceron="3475190"> 1184</lienAdt>, <lienAdt id_syceron="3476593"> 1185</lien… | |
| 16130000745202 | L16/debats | 16 | 16130000745197 | 16130000745201 | 1 | Amendements nos 97, 2962, 3306 | Amendements n<sup>os</sup> <lienAdt id_syceron="3475483"> 97</lienAdt>, <lienAdt id_syceron="3475485"> 2962</lienAdt>, <lienAdt id_syceron="3475487"> 3306</lien… | |
| 16130000745203 | L16/debats | 16 | 16130000745197 | 16130000745201 | 2 | M. Pascal Lavergne, rapporteur de la commission des affaires économiques | 3475489 | |
| 16130000745204 | L16/debats | 16 | 16130000745197 | 16130000745201 | 3 | M. Marc Fesneau, ministre de l’agriculture et de la souveraineté alimentaire | 3475491 | |
| 16130000745205 | L16/debats | 16 | 16130000745197 | 16130000745201 | 4 | Amendements nos 2460, 685, 962, 2461, 2486, 3595, 4520, 4632, 4647, 4705, 3715, 1152, 1169, 3145, 4697, 34, 1054, 1547, 150, 687, 3561, 4590, 3598, 4565, 4633 r… | Amendements n<sup>os</sup> <lienAdt id_syceron="3475493"> 2460</lienAdt>, <lienAdt id_syceron="3475498"> 685</lienAdt>, <lienAdt id_syceron="3475501"> 962</lien… | |
| 16130000745207 | L16/debats | 16 | 16130000745197 | 16130000745206 | 1 | Amendements nos 3325, 2965, 43, 691, 1064, 2555, 40, 207, 1548, 3949, 4000, 1987, 3580, 2964, 3320, 42, 1060, 1550, 2966, 3324, 3327, 41, 208, 689, 2554, 4142, … | Amendements n<sup>os</sup> <lienAdt id_syceron="3475577"> 3325</lienAdt>, <lienAdt id_syceron="3475591"> 2965</lienAdt>, <lienAdt id_syceron="3475602"> 43, 691,… | |
| 16130000745209 | L16/debats | 16 | 16130000745197 | 16130000745208 | 1 | M. Dominique Potier | 3476305 | |
| 16130000745210 | L16/debats | 16 | 16130000745197 | 16130000745208 | 2 | M. David Taupiac | 3476310 | |
| 16130000745211 | L16/debats | 16 | 16130000745197 | 16130000745208 | 3 | Mme Lisa Belluco | 3476312 | |
| 16130000745212 | L16/debats | 16 | 16130000745197 | 16130000745208 | 4 | Mme Edwige Diaz | 3476321 | |
| 16130000745213 | L16/debats | 16 | 16130000745197 | 16130000745208 | 5 | M. Loïc Prud’homme | 3476326 | |
| 16130000745214 | L16/debats | 16 | 16130000745197 | 16130000745208 | 6 | M. Marc Fesneau, ministre | 3476841 | |
| 16130000745215 | L16/debats | 16 | 16130000745197 | 16130000745208 | 7 | Amendements nos 27, 1091, 3382, 3527, 3528, 3529, 3530, 3786, 3432, 46, 2772, 3330, 1125 rectifié | Amendements n<sup>os</sup> <lienAdt id_syceron="3476877"> 27</lienAdt>, <lienAdt id_syceron="3476892"> 1091</lienAdt>, <lienAdt id_syceron="3476902"> 3382</lien… | |
| 16130000745216 | L16/debats | 16 | 16130000745197 | 16130000745208 | 8 | Sous-amendement no 5595 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3475868"> 5595</lienAdt> | |
| 16130000745217 | L16/debats | 16 | 16130000745197 | 16130000745208 | 9 | Amendements nos 1344, 3887, 4138, 2773, 3328, 4001, 47, 1196, 1345, 1346, 48, 2774, 3329, 49, 98, 4578, 1197, 3334, 2482 | Amendements n<sup>os</sup> <lienAdt id_syceron="3475877"> 1344</lienAdt>, <lienAdt id_syceron="3475881"> 3887</lienAdt>, <lienAdt id_syceron="3475888"> 4138</li… | |
| 16130000745218 | L16/debats | 16 | 16130000745197 | 16130000745208 | 10 | Mme Sandrine Le Feur, rapporteure pour avis | 3476392 | |
| 16130000745219 | L16/debats | 16 | 16130000745197 | 16130000745208 | 11 | Amendements nos 1198, 4676, 50, 4306 | Amendements n<sup>os</sup> <lienAdt id_syceron="3476394"> 1198</lienAdt>, <lienAdt id_syceron="3476397"> 4676</lienAdt>, <lienAdt id_syceron="3476415"> 50</lien… | |
| 16130000745220 | L16/debats | 16 | 16130000745197 | 16130000745208 | 12 | Sous-amendement no 5596 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3476419"> 5596</lienAdt> | |
| 16130000745221 | L16/debats | 16 | 16130000745197 | 16130000745208 | 13 | Amendements nos 88, 2775 | Amendements n<sup>os</sup> <lienAdt id_syceron="3476429"> 88</lienAdt>, <lienAdt id_syceron="3476435"> 2775</lienAdt> | |
| 16130000745224 | L16/debats | 16 | 16130000745197 | 16130000745223 | 1 | Amendements nos 3436, 2477, 3438, 3421, 4228, 1204, 3400, 1132, 1148, 1702, 1880, 4005, 4004, 628, 1202 | Amendements n<sup>os</sup> <lienAdt id_syceron="3477027"> 3436</lienAdt>, <lienAdt id_syceron="3477031"> 2477</lienAdt>, <lienAdt id_syceron="3477036"> 3438</li… | |
| 16130000745226 | L16/debats | 16 | 16130000745197 | 16130000745225 | 1 | Mme Marie Pochon | 3477107 | |
| 16130000745227 | L16/debats | 16 | 16130000745197 | 16130000745225 | 2 | M. Grégoire de Fournas | 3477113 | |
| 16130000745228 | L16/debats | 16 | 16130000745197 | 16130000745225 | 3 | M. Marc Fesneau, ministre | 3477120 | |
| 16130000745229 | L16/debats | 16 | 16130000745197 | 16130000745225 | 4 | Amendements nos 2776, 3445, 1207, 3868, 1208, 4813 rectifié, 1209 | Amendements n<sup>os</sup> <lienAdt id_syceron="3477135"> 2776</lienAdt>, <lienAdt id_syceron="3476154"> 3445</lienAdt>, <lienAdt id_syceron="3476158"> 1207, 38… | |
| 16130000745231 | L16/debats | 16 | 16130000745197 | 16130000745230 | 1 | Amendements nos 1044, 1331, 2185 | Amendements n<sup>os</sup> <lienAdt id_syceron="3476179"> 1044, 1331</lienAdt>, <lienAdt id_syceron="3477813"> 2185</lienAdt> | |
| 16130000745233 | L16/debats | 16 | 16130000745197 | 16130000745232 | 1 | Mme Marie Pochon | 3476184 | |
| 16130000745234 | L16/debats | 16 | 16130000745197 | 16130000745232 | 2 | Amendements nos 2780, 2779, 3780, 1211, 1212, 3518, 3869, 1213, 1214, 2778, 1215, 3519, 1216, 4230, 4588 | Amendements n<sup>os</sup> <lienAdt id_syceron="3476187"> 2780</lienAdt>, <lienAdt id_syceron="3476201"> 2779</lienAdt>, <lienAdt id_syceron="3476204"> 3780</li… | |
| 16130000745236 | L16/debats | 16 | 16130000745197 | 16130000745235 | 1 | M. Vincent Descoeur | 3477528 | |
| 16130000745237 | L16/debats | 16 | 16130000745197 | 16130000745235 | 2 | Mme Lisa Belluco | 3477534 | |
| 16130000745238 | L16/debats | 16 | 16130000745197 | 16130000745235 | 3 | M. David Taupiac | 3477542 | |
| 16130000745239 | L16/debats | 16 | 16130000745197 | 16130000745235 | 4 | Amendements nos 1220, 3464, 99, 1576, 3472, 1441, 2188, 4580, 4423 | Amendements n<sup>os</sup> <lienAdt id_syceron="3477548"> 1220</lienAdt>, <lienAdt id_syceron="3477556"> 3464</lienAdt>, <lienAdt id_syceron="3477581"> 99</lien… | |
| 16130000745241 | L16/debats | 16 | 16130000745197 | 16130000745240 | 1 | Amendements nos 4425, 3778, 4002 | Amendements n<sup>os</sup> <lienAdt id_syceron="3477604"> 4425</lienAdt>, <lienAdt id_syceron="3477606"> 3778</lienAdt>, <lienAdt id_syceron="3477727"> 4002</li… | |
| 16130000745243 | L16/debats | 16 | 16130000745197 | 16130000745242 | 1 | Amendements nos 1597, 4628 | Amendements n<sup>os</sup> <lienAdt id_syceron="3477739"> 1597</lienAdt>, <lienAdt id_syceron="3477744"> 4628</lienAdt> | |
| 16130000745245 | L16/debats | 16 | 16130000745197 | 16130000745244 | 1 | Amendements nos 4231, 4232, 4147 | Amendements n<sup>os</sup> <lienAdt id_syceron="3477749"> 4231</lienAdt>, <lienAdt id_syceron="3477753"> 4232</lienAdt>, <lienAdt id_syceron="3477756"> 4147</li… | |
| 16130000745247 | L16/debats | 16 | 16130000745197 | 16130000745246 | 1 | Amendements nos 4307, 4308, 79, 4281, 81, 2225, 2235, 82, 2747, 995, 118, 3588, 87, 680, 679, 562, 4068, 1119, 1884, 1047, 1957, 3138, 100, 1131 rectifié, 104, … | Amendements n<sup>os</sup> <lienAdt id_syceron="3477771"> 4307, 4308</lienAdt>, <lienAdt id_syceron="3477790"> 79</lienAdt>, <lienAdt id_syceron="3477804"> 4281… | |
| 16130000745249 | L16/debats | 16 | 16130000745197 | 16130000745248 | 1 | Amendements nos 3913, 3431, 3750 | Amendements n<sup>os</sup> <lienAdt id_syceron="3477246"> 3913</lienAdt>, <lienAdt id_syceron="3477248"> 3431</lienAdt>, <lienAdt id_syceron="3477436"> 3750</li… | |
| 16130000747689 | L16/debats | 16 | 16130000747654 | 16130000747688 | 1 | Amendement no 2036 | Amendement n<sup>o</sup> <lienAdt id_syceron="3479718"> 2036</lienAdt> | |
| 16130000747690 | L16/debats | 16 | 16130000747654 | 16130000747688 | 2 | Sous-amendement no 3424 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3479722"> 3424</lienAdt> |