debats.compte_rendu_sommaire1_sommaire2_sommaire3_para
Chemin compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.para · présence : L17 74 %, L16 74 %, L15 76 %
46 307 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 |
|---|---|---|---|---|---|---|---|---|
| 17130000088479 | L17/debats | 17 | 17130000088471 | 17130000088475 | 4 | Amendements nos 602, 601 | Amendements n<sup>os</sup> <lienAdt id_syceron="3578407"> 602</lienAdt>, <lienAdt id_syceron="3578443"> 601</lienAdt> | |
| 17130000088480 | L17/debats | 17 | 17130000088471 | 17130000088475 | 5 | Sous-amendement no 1000 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3578452"> 1000</lienAdt> | |
| 17130000088481 | L17/debats | 17 | 17130000088471 | 17130000088475 | 6 | Amendement no 876 | Amendement n<sup>o</sup> <lienAdt id_syceron="3578827"> 876</lienAdt> | |
| 17130000088483 | L17/debats | 17 | 17130000088471 | 17130000088482 | 1 | Amendements nos 880, 884, 885, 878, 598 | Amendements n<sup>os</sup> <lienAdt id_syceron="3578332"> 880</lienAdt>, <lienAdt id_syceron="3578356"> 884</lienAdt>, <lienAdt id_syceron="3578898"> 885</lienA… | |
| 17130000088485 | L17/debats | 17 | 17130000088471 | 17130000088484 | 1 | M. Charles Sitzenstuhl | 3579117 | |
| 17130000088487 | L17/debats | 17 | 17130000088471 | 17130000088486 | 1 | Amendement no 881 | Amendement n<sup>o</sup> <lienAdt id_syceron="3579154"> 881</lienAdt> | |
| 17130000088488 | L17/debats | 17 | 17130000088471 | 17130000088486 | 2 | Amendement no 875 | Amendement n<sup>o</sup> <lienAdt id_syceron="3579192"> 875</lienAdt> | |
| 17130000088491 | L17/debats | 17 | 17130000088471 | 17130000088490 | 1 | Mme Anaïs Belouassa-Cherifi | 3580256 | |
| 17130000088492 | L17/debats | 17 | 17130000088471 | 17130000088490 | 2 | M. Arthur Delaporte | 3580273 | |
| 17130000088494 | L17/debats | 17 | 17130000088471 | 17130000088493 | 1 | M. Sylvain Berrios | 3580290 | |
| 17130000088496 | L17/debats | 17 | 17130000088471 | 17130000088495 | 1 | M. Thibault Bazin | 3580298 | |
| 17130000088497 | L17/debats | 17 | 17130000088471 | 17130000088495 | 2 | M. Benjamin Lucas-Lundy | 3580317 | |
| 17130000088498 | L17/debats | 17 | 17130000088471 | 17130000088495 | 3 | M. Frédéric Petit | 3580339 | |
| 17130000088499 | L17/debats | 17 | 17130000088471 | 17130000088495 | 4 | M. Henri Alfandari | 3579295 | |
| 17130000088500 | L17/debats | 17 | 17130000088471 | 17130000088495 | 5 | M. Kévin Pfeffer | 3579304 | |
| 17130000088501 | L17/debats | 17 | 17130000088471 | 17130000088495 | 6 | M. Charles Sitzenstuhl | 3579312 | |
| 17130000088503 | L17/debats | 17 | 17130000088471 | 17130000088502 | 1 | M. Manuel Bompard | 3579323 | |
| 17130000088504 | L17/debats | 17 | 17130000088471 | 17130000088502 | 2 | M. le président | 3579324 | |
| 17130000088506 | L17/debats | 17 | 17130000088471 | 17130000088505 | 1 | Amendements nos 4, 11, 54, 72, 77, 78, 128, 187, 198, 240, 286, 318, 366, 719 | Amendements n<sup>os</sup> <lienAdt id_syceron="3579327"> 4</lienAdt>, <lienAdt id_syceron="3579338"> 11</lienAdt>, <lienAdt id_syceron="3579348"> 54, 72, 77, 7… | |
| 17130000088508 | L17/debats | 17 | 17130000088471 | 17130000088507 | 1 | Mme Caroline Yadan | 3580501 | |
| 17130000088509 | L17/debats | 17 | 17130000088471 | 17130000088507 | 2 | Mme Brigitte Liso | 3580506 | |
| 17130000088510 | L17/debats | 17 | 17130000088471 | 17130000088507 | 3 | M. le président | 3580511 | |
| 17130000088513 | L17/debats | 17 | 17130000088471 | 17130000088512 | 1 | Mme Stéphanie Rist | 3581264 | |
| 17130000088514 | L17/debats | 17 | 17130000088471 | 17130000088512 | 2 | M. le président | 3581266 | |
| 17130000088517 | L17/debats | 17 | 17130000088471 | 17130000088516 | 1 | Mme Mathilde Panot | 3581276 | |
| 17130000088518 | L17/debats | 17 | 17130000088471 | 17130000088516 | 2 | M. le président | 3581277 | |
| 17130000088520 | L17/debats | 17 | 17130000088471 | 17130000088519 | 1 | Amendements nos 335, 447, 391, 512, 446, 390 | Amendements n<sup>os</sup> <lienAdt id_syceron="3581537"> 335</lienAdt>, <lienAdt id_syceron="3581542"> 447</lienAdt>, <lienAdt id_syceron="3581544"> 391</lienA… | |
| 17130000088521 | L17/debats | 17 | 17130000088471 | 17130000088519 | 2 | Sous-amendement no 993 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3581676"> 993</lienAdt> | |
| 17130000088522 | L17/debats | 17 | 17130000088471 | 17130000088519 | 3 | Amendements nos 445, 511, 796, 798, 797, 960, 963 | Amendements n<sup>os</sup> <lienAdt id_syceron="3581686"> 445</lienAdt>, <lienAdt id_syceron="3581692"> 511</lienAdt>, <lienAdt id_syceron="3581696"> 796</lienA… | |
| 17130000088523 | L17/debats | 17 | 17130000088471 | 17130000088519 | 4 | Sous-amendement no 1007 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3581740"> 1007</lienAdt> | |
| 17130000088524 | L17/debats | 17 | 17130000088471 | 17130000088519 | 5 | Amendement no 794 | Amendement n<sup>o</sup> <lienAdt id_syceron="3581745"> 794</lienAdt> | |
| 17130000088526 | L17/debats | 17 | 17130000088471 | 17130000088525 | 1 | M. Manuel Bompard | 3579444 | |
| 17130000088529 | L17/debats | 17 | 17130000088471 | 17130000088528 | 1 | Amendements nos 57, 188, 243, 283, 314 | Amendements n<sup>os</sup> <lienAdt id_syceron="3579486"> 57</lienAdt>, <lienAdt id_syceron="3579492"> 188, 243, 283, 314</lienAdt> | |
| 17130000088531 | L17/debats | 17 | 17130000088471 | 17130000088530 | 1 | M. Christophe Blanchet | 3579533 | |
| 17130000088532 | L17/debats | 17 | 17130000088471 | 17130000088530 | 2 | M. le président | 3579535 | |
| 17130000088534 | L17/debats | 17 | 17130000088471 | 17130000088533 | 1 | Amendement no 392 | Amendement n<sup>o</sup> <lienAdt id_syceron="3580351"> 392</lienAdt> | |
| 17130000088536 | L17/debats | 17 | 17130000088471 | 17130000088535 | 1 | M. Jean-René Cazeneuve | 3580360 | |
| 17130000088537 | L17/debats | 17 | 17130000088471 | 17130000088535 | 2 | Mme Mathilde Panot | 3580367 | |
| 17130000088539 | L17/debats | 17 | 17130000088471 | 17130000088538 | 1 | Amendements nos 451, 337 | Amendements n<sup>os</sup> <lienAdt id_syceron="3580374"> 451</lienAdt>, <lienAdt id_syceron="3580384"> 337</lienAdt> | |
| 17130000088541 | L17/debats | 17 | 17130000088471 | 17130000088540 | 1 | M. Philippe Vigier | 3580397 | |
| 17130000088543 | L17/debats | 17 | 17130000088471 | 17130000088542 | 1 | Amendement no 514 | Amendement n<sup>o</sup> <lienAdt id_syceron="3580404"> 514</lienAdt> | |
| 17130000088544 | L17/debats | 17 | 17130000088471 | 17130000088542 | 2 | M. Laurent Saint-Martin, ministre du budget et des comptes publics | 3581115 | |
| 17130000088546 | L17/debats | 17 | 17130000088471 | 17130000088545 | 1 | M. Thibault Bazin | 3580900 | |
| 17130000088547 | L17/debats | 17 | 17130000088471 | 17130000088545 | 2 | M. le président | 3580907 | |
| 17130000088549 | L17/debats | 17 | 17130000088471 | 17130000088548 | 1 | Amendements nos 109, 773, 83, 513, 920, 73, 7, 111, 132, 479 | Amendements n<sup>os</sup> <lienAdt id_syceron="3580938"> 109</lienAdt>, <lienAdt id_syceron="3580983"> 773</lienAdt>, <lienAdt id_syceron="3581150"> 83</lienAd… | |
| 17130000088551 | L17/debats | 17 | 17130000088471 | 17130000088550 | 1 | M. Charles Sitzenstuhl | 3581249 | |
| 17130000088552 | L17/debats | 17 | 17130000088471 | 17130000088550 | 2 | M. Sylvain Berrios | 3581334 | |
| 17130000088554 | L17/debats | 17 | 17130000088471 | 17130000088553 | 1 | Amendement no 336 | Amendement n<sup>o</sup> <lienAdt id_syceron="3581363"> 336</lienAdt> | |
| 17130000090873 | L17/debats | 17 | 17130000090868 | 17130000090872 | 1 | Amendement no 809 | Amendement n<sup>o</sup> <lienAdt id_syceron="3580445"> 809</lienAdt> | |
| 17130000090874 | L17/debats | 17 | 17130000090868 | 17130000090872 | 2 | M. Ugo Bernalicis, rapporteur de la commission des affaires sociales | 3580450 |