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 |
|---|---|---|---|---|---|---|---|---|
| 15130001655602 | L15/debats | 15 | 15130001655597 | 15130001655601 | 1 | Amendements nos 629, 3332, 3366, 3932, 3053, 1567, 3479, 3290, 3978, 2968, 5160 | Amendements n<sup>os</sup><lienAdt id_syceron="2497326"> 629, 3332, 3366, 3932, 3053</lienAdt>, <lienAdt id_syceron="2497327"> 1567</lienAdt>, <lienAdt id_sycer… | |
| 15130001655603 | L15/debats | 15 | 15130001655597 | 15130001655601 | 2 | M. Lionel Causse, rapporteur de la commission spéciale pour les chapitres III à V du titre IV | 2497337 | |
| 15130001655604 | L15/debats | 15 | 15130001655597 | 15130001655601 | 3 | Mme Emmanuelle Wargon, ministre déléguée chargée du logement | 2497340 | |
| 15130001655605 | L15/debats | 15 | 15130001655597 | 15130001655601 | 4 | Amendements nos 6868, 6865, 6870, 6860, 6863, 6864, 6859, 6862, 6866, 6871, 6867, 6869, 6861, 3302, 6345, 7162, 1385, 3831, 1389, 3828 | Amendements n<sup>os</sup><lienAdt id_syceron="2497361"> 6868, 6865, 6870, 6860, 6863, 6864, 6859, 6862, 6866, 6871, 6867, 6869, 6861</lienAdt>, <lienAdt id_syc… | |
| 15130001655606 | L15/debats | 15 | 15130001655597 | 15130001655601 | 5 | Sous-amendement nos 7431, 7418 | Sous-amendement n<sup>os</sup><lienAdt id_syceron="2497862"> 7431, 7418</lienAdt> | |
| 15130001655607 | L15/debats | 15 | 15130001655597 | 15130001655601 | 7 | Mme Laurence Maillart-Méhaignerie, présidente de la commission spéciale | 2498031 | |
| 15130001655609 | L15/debats | 15 | 15130001655597 | 15130001655608 | 1 | Mme Delphine Batho | 2498064 | |
| 15130001655612 | L15/debats | 15 | 15130001655597 | 15130001655611 | 1 | Amendements nos 6855, 6856, 6857, 6872, 3907, 6858 | Amendements n<sup>os</sup><lienAdt id_syceron="2498271"> 6855</lienAdt>, <lienAdt id_syceron="2498292"> 6856</lienAdt>, <lienAdt id_syceron="2498300"> 6857</lie… | |
| 15130001655614 | L15/debats | 15 | 15130001655597 | 15130001655613 | 1 | Amendements nos 5026 | Amendements n<sup>os</sup><lienAdt id_syceron="2498627"> 5026</lienAdt> | |
| 15130001655615 | L15/debats | 15 | 15130001655597 | 15130001655613 | 2 | Sous-amendements nos 7438, 7439, 7440, 7408 | Sous-amendements n<sup>os</sup><lienAdt id_syceron="2498629"> 7438, 7439, 7440</lienAdt>, <lienAdt id_syceron="2498630"> 7408</lienAdt> | |
| 15130001655616 | L15/debats | 15 | 15130001655597 | 15130001655613 | 3 | Amendement no 3673 | Amendement n<sup>o</sup><lienAdt id_syceron="2498643"> 3673</lienAdt> | |
| 15130001655618 | L15/debats | 15 | 15130001655597 | 15130001655617 | 1 | Amendements nos 261, 271, , 904, 2190, 2673, 3291, 5183, 6008, 6187, 633, 6277, 3017, 3292, 5161, 3293, 1016 | Amendements n<sup>os</sup><lienAdt id_syceron="2498650"> 261, 271</lienAdt>, <lienAdt id_syceron="2498652" />, <lienAdt id_syceron="2498653"> 904, 2190, 2673</l… | |
| 15130001655620 | L15/debats | 15 | 15130001655597 | 15130001655619 | 1 | Amendements nos 5266, 5431, 824, 6186 | Amendements n<sup>os</sup><lienAdt id_syceron="2499008"> 5266</lienAdt>, <lienAdt id_syceron="2499010"> 5431</lienAdt>, <lienAdt id_syceron="2499018"> 824</lien… | |
| 15130001655622 | L15/debats | 15 | 15130001655597 | 15130001655621 | 1 | Amendements nos 4937, 1983, 4938, 557, 5452, 6160 | Amendements n<sup>os</sup><lienAdt id_syceron="2499028"> 4937</lienAdt>, <lienAdt id_syceron="2499030"> 1983</lienAdt>, <lienAdt id_syceron="2499032"> 4938</lie… | |
| 15130001655624 | L15/debats | 15 | 15130001655597 | 15130001655623 | 1 | Amendements nos 2901, 780, 5804, 1014, 4634, 823, 832, 820, 833, 1779, 6171, 818, 5318, 782, 5306, 830 | Amendements n<sup>os</sup><lienAdt id_syceron="2499048"> 2901</lienAdt>, <lienAdt id_syceron="2499055"> 780, 5804</lienAdt>, <lienAdt id_syceron="2499057"> 1014… | |
| 15130001655626 | L15/debats | 15 | 15130001655597 | 15130001655625 | 1 | Amendements nos, 29, 205, 479, 829, 918, 1311, 1572, 2151, 2260, 2969, 3516, 3645, 3800, 3983, 5163, 5308, 5779, 6166, 581, 7015, 5027, 919 | Amendements n<sup>os</sup><lienAdt id_syceron="2499078" />, <lienAdt id_syceron="2499079"> 29, 205, 479, 829, 918, 1311, 1572, 2151, 2260, 2969, 3516, 3645, 380… | |
| 15130001655627 | L15/debats | 15 | 15130001655597 | 15130001655625 | 2 | Sous-amendement no 7422 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2499375"> 7422</lienAdt> | |
| 15130001655628 | L15/debats | 15 | 15130001655597 | 15130001655625 | 3 | Amendement no 582, 583 | Amendement n<sup>o</sup><lienAdt id_syceron="2499383"> 582, 583</lienAdt> | |
| 15130001655630 | L15/debats | 15 | 15130001655597 | 15130001655629 | 1 | Amendements nos 3668, 4299 rectifié, 4298, 4300, 4623 | Amendements n<sup>os</sup><lienAdt id_syceron="2499390"> 3668</lienAdt>, <lienAdt id_syceron="2499394"> 4299 rectifié</lienAdt>, <lienAdt id_syceron="2499400"> … | |
| 15130001655632 | L15/debats | 15 | 15130001655597 | 15130001655631 | 1 | Amendement no 3000 | Amendement n<sup>o</sup><lienAdt id_syceron="2499423"> 3000</lienAdt> | |
| 15130001655634 | L15/debats | 15 | 15130001655597 | 15130001655633 | 1 | Amendements nos 831, 2423, 2643, 2996, 3038, 3137, 3222, 3854, 3930, 3979, 3989, 4919, 5175, 6281, 6875, 2995, 225, 294, 2162, 2454, 2730, 3990, 4660, 1470, 486… | Amendements n<sup>os</sup><lienAdt id_syceron="2499538"> 831, 2423, 2643, 2996, 3038, 3137, 3222, 3854, 3930, 3979</lienAdt>, <lienAdt id_syceron="2499539"> 39… | |
| 15130001655636 | L15/debats | 15 | 15130001655597 | 15130001655635 | 1 | Amendement no 1474 | Amendement n<sup>o</sup><lienAdt id_syceron="2499565"> 1474</lienAdt> | |
| 15130001655638 | L15/debats | 15 | 15130001655597 | 15130001655637 | 1 | Mme Maina Sage | 2499569 | |
| 15130001655639 | L15/debats | 15 | 15130001655597 | 15130001655637 | 2 | Mme Emmanuelle Wargon, ministre déléguée | 2499575 | |
| 15130001655641 | L15/debats | 15 | 15130001655597 | 15130001655640 | 1 | Amendement no 4920 | Amendement n<sup>o</sup><lienAdt id_syceron="2497973"> 4920</lienAdt> | |
| 15130001655642 | L15/debats | 15 | 15130001655597 | 15130001655640 | 2 | Mme Bérangère Abba, secrétaire d’État chargée de la biodiversité | 2497977 | |
| 15130001655643 | L15/debats | 15 | 15130001655597 | 15130001655640 | 3 | Amendements nos 3346, 3818, 3908, , 42, 462, 905, 1964, 2189, 2649, 2674, 2711, 3991, 5301, 6876, 3347, 2581, 4939, 5436, 1871, 6322, 1688, 5195, 5030 | Amendements n<sup>os</sup><lienAdt id_syceron="2497979"> 3346</lienAdt>, <lienAdt id_syceron="2497981"> 3818</lienAdt>, <lienAdt id_syceron="2497983"> 3908</lie… | |
| 15130001655645 | L15/debats | 15 | 15130001655597 | 15130001655644 | 1 | Amendements nos 3132, 4940, 6188 | Amendements n<sup>os</sup><lienAdt id_syceron="2497788"> 3132, 4940</lienAdt>, <lienAdt id_syceron="2498187"> 6188</lienAdt> | |
| 15130001655646 | L15/debats | 15 | 15130001655597 | 15130001655644 | 2 | Sous-amendement no 7444 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2498193"> 7444</lienAdt> | |
| 15130001655648 | L15/debats | 15 | 15130001655597 | 15130001655647 | 1 | Amendements nos 6372, 4911, 5544, 5545, 5646 | Amendements n<sup>os</sup><lienAdt id_syceron="2498221"> 6372</lienAdt>, <lienAdt id_syceron="2498228"> 4911</lienAdt>, <lienAdt id_syceron="2498230"> 5544, 554… | |
| 15130001655650 | L15/debats | 15 | 15130001655597 | 15130001655649 | 1 | Mme Delphine Batho | 2498252 | |
| 15130001655652 | L15/debats | 15 | 15130001655597 | 15130001655651 | 1 | Amendements nos 5546, 3016, 2863, 5065, 5064, 5579 | Amendements n<sup>os</sup><lienAdt id_syceron="2498325"> 5546</lienAdt>, <lienAdt id_syceron="2497911"> 3016</lienAdt>, <lienAdt id_syceron="2497913"> 2863</lie… | |
| 15130001655654 | L15/debats | 15 | 15130001655597 | 15130001655653 | 1 | Amendements nos 3107, 4930 | Amendements n<sup>os</sup><lienAdt id_syceron="2497952"> 3107</lienAdt>, <lienAdt id_syceron="2497954"> 4930</lienAdt> | |
| 15130001655655 | L15/debats | 15 | 15130001655597 | 15130001655653 | 2 | Mme Barbara Pompili, ministre de la transition écologique | 2497959 | |
| 15130001655657 | L15/debats | 15 | 15130001655597 | 15130001655656 | 1 | Amendements nos 600 rectifié, 653, 2692, 2883, 2970, 4812, 5515, 6877, 6986, 79, 179, 622, 687, 1912, 2821, 3322, 3430, 4875, 5949, 6353, 1952, 2568, 6337 | Amendements n<sup>os</sup><lienAdt id_syceron="2497963"> 600 rectifié</lienAdt>, <lienAdt id_syceron="2498327"> 653</lienAdt>, <lienAdt id_syceron="2498330"> 26… | |
| 15130001655659 | L15/debats | 15 | 15130001655597 | 15130001655658 | 1 | Amendement no 1981 | Amendement n<sup>o</sup><lienAdt id_syceron="2498348"> 1981</lienAdt> | |
| 15130001655661 | L15/debats | 15 | 15130001655597 | 15130001655660 | 1 | Amendements nos, 1116, 5031, 5057, 2662, 2717, 3348, 5208, 5699, 5786, 81, 5770 rectifié | Amendements n<sup>os</sup><lienAdt id_syceron="2498355" />, <lienAdt id_syceron="2498356"> 1116, 5031</lienAdt>, <lienAdt id_syceron="2498357"> 5057</lienAdt>, … | |
| 15130001655664 | L15/debats | 15 | 15130001655597 | 15130001655663 | 1 | Amendements nos 4069, 4068, 3126, 4067, 4070, 4071, 4721 | Amendements n<sup>os</sup><lienAdt id_syceron="2498373"> 4069, 4068</lienAdt>, <lienAdt id_syceron="2498381"> 3126</lienAdt>, <lienAdt id_syceron="2498383"> 406… | |
| 15130001655666 | L15/debats | 15 | 15130001655597 | 15130001655665 | 1 | M. Stéphane Buchou | 2498396 | |
| 15130001655667 | L15/debats | 15 | 15130001655597 | 15130001655665 | 2 | Mme Sophie Panonacle | 2498495 | |
| 15130001655668 | L15/debats | 15 | 15130001655597 | 15130001655665 | 3 | Amendements nos 1997, 1998, 1999, 2000 | Amendements n<sup>os</sup><lienAdt id_syceron="2498498"> 1997, 1998, 1999, 2000</lienAdt> | |
| 15130001655669 | L15/debats | 15 | 15130001655597 | 15130001655665 | 4 | Sous-amendement nos 7456, 7457, 7459, 7460 | Sous-amendement n<sup>os</sup><lienAdt id_syceron="2498502"> 7456, 7457, 7459, 7460</lienAdt> | |
| 15130001655670 | L15/debats | 15 | 15130001655597 | 15130001655665 | 5 | Amendement no 4466 | Amendement n<sup>o</sup><lienAdt id_syceron="2498521"> 4466</lienAdt> | |
| 15130001655672 | L15/debats | 15 | 15130001655597 | 15130001655671 | 1 | Amendements nos 1418 | Amendements n<sup>os</sup><lienAdt id_syceron="2498525"> 1418</lienAdt> | |
| 15130001655673 | L15/debats | 15 | 15130001655597 | 15130001655671 | 2 | Sous-amendement no 7473 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2498528"> 7473</lienAdt> | |
| 15130001655674 | L15/debats | 15 | 15130001655597 | 15130001655671 | 3 | Amendements nos 1399, 1995, 1994 | Amendements n<sup>os</sup><lienAdt id_syceron="2498534"> 1399</lienAdt>, <lienAdt id_syceron="2498683"> 1995, 1994</lienAdt> | |
| 15130001655676 | L15/debats | 15 | 15130001655597 | 15130001655675 | 1 | Amendements nos 2001, 2002, 2003, 2005, 2004 | Amendements n<sup>os</sup><lienAdt id_syceron="2498696"> 2001, 2002, 2003, 2005, 2004</lienAdt> | |
| 15130001655678 | L15/debats | 15 | 15130001655597 | 15130001655677 | 1 | Amendement no 1331 | Amendement n<sup>o</sup><lienAdt id_syceron="2498714"> 1331</lienAdt> | |
| 15130001655680 | L15/debats | 15 | 15130001655597 | 15130001655679 | 1 | Amendements nos 1707, 1783, 2288, 2801, 3481, 4062 | Amendements n<sup>os</sup><lienAdt id_syceron="2498722"> 1707, 1783, 2288, 2801, 3481, 4062</lienAdt> | |
| 15130001655683 | L15/debats | 15 | 15130001655597 | 15130001655682 | 1 | Amendements nos 2006, 1709, 1788, 2290, 3483, 4079, 4809, 5938, 2007, 1711, 1794, 2292, 3485, 4082 | Amendements n<sup>os</sup><lienAdt id_syceron="2498729"> 2006</lienAdt>, <lienAdt id_syceron="2498738"> 1709, 1788, 2290, 3483, 4079, 4809</lienAdt>, <lienAdt i… |