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 |
|---|---|---|---|---|---|---|---|---|
| 15130001686615 | L15/debats | 15 | 15130001686589 | 15130001686614 | 1 | Amendements nos 73, 212, 249, 42, 43, 542 | Amendements n<sup>os</sup><lienAdt id_syceron="2527618"> 73</lienAdt>, <lienAdt id_syceron="2527620"> 212</lienAdt>, <lienAdt id_syceron="2527705"> 249</lienAdt… | |
| 15130001686617 | L15/debats | 15 | 15130001686589 | 15130001686616 | 1 | Amendement no 824 | Amendement n<sup>o</sup><lienAdt id_syceron="2527735"> 824</lienAdt> | |
| 15130001686619 | L15/debats | 15 | 15130001686589 | 15130001686618 | 1 | Amendement no 572 rectifié | Amendement n<sup>o</sup><lienAdt id_syceron="2527739"> 572 rectifié</lienAdt> | |
| 15130001686621 | L15/debats | 15 | 15130001686589 | 15130001686620 | 1 | M. Philippe Benassaya | 2527743 | |
| 15130001686622 | L15/debats | 15 | 15130001686589 | 15130001686620 | 2 | Amendements nos 206, 264, 428, 442 | Amendements n<sup>os</sup><lienAdt id_syceron="2527748"> 206</lienAdt>, <lienAdt id_syceron="2527750"> 264, 428, 442</lienAdt> | |
| 15130001686625 | L15/debats | 15 | 15130001686589 | 15130001686624 | 1 | Amendements nos 643, 110, 430, 439 | Amendements n<sup>os</sup><lienAdt id_syceron="2527760"> 643</lienAdt>, <lienAdt id_syceron="2527762"> 110</lienAdt>, <lienAdt id_syceron="2527775"> 430</lienAd… | |
| 15130001686630 | L15/debats | 15 | 15130001686589 | 15130001686629 | 1 | Amendements nos 101, 102 | Amendements n<sup>os</sup><lienAdt id_syceron="2527785"> 101</lienAdt>, <lienAdt id_syceron="2527787"> 102</lienAdt> | |
| 15130001686632 | L15/debats | 15 | 15130001686589 | 15130001686631 | 1 | Amendements nos 53, 55 | Amendements n<sup>os</sup><lienAdt id_syceron="2527790"> 53</lienAdt>, <lienAdt id_syceron="2527792"> 55</lienAdt> | |
| 15130001686634 | L15/debats | 15 | 15130001686589 | 15130001686633 | 1 | Amendement no 260 rectifié | Amendement n<sup>o</sup><lienAdt id_syceron="2526876"> 260 rectifié</lienAdt> | |
| 15130001686636 | L15/debats | 15 | 15130001686589 | 15130001686635 | 1 | Amendements nos 52, 54 | Amendements n<sup>os</sup><lienAdt id_syceron="2526882"> 52</lienAdt>, <lienAdt id_syceron="2526885"> 54</lienAdt> | |
| 15130001686639 | L15/debats | 15 | 15130001686589 | 15130001686638 | 1 | Amendements nos 422, 464 | Amendements n<sup>os</sup><lienAdt id_syceron="2526893"> 422</lienAdt>, <lienAdt id_syceron="2526895"> 464</lienAdt> | |
| 15130001686641 | L15/debats | 15 | 15130001686589 | 15130001686640 | 1 | Amendements nos 423, 765 | Amendements n<sup>os</sup><lienAdt id_syceron="2526899"> 423</lienAdt>, <lienAdt id_syceron="2526901"> 765</lienAdt> | |
| 15130001686644 | L15/debats | 15 | 15130001686589 | 15130001686643 | 1 | Amendements nos 465, 524 | Amendements n<sup>os</sup><lienAdt id_syceron="2526908"> 465</lienAdt>, <lienAdt id_syceron="2526910"> 524</lienAdt> | |
| 15130001686645 | L15/debats | 15 | 15130001686589 | 15130001686643 | 2 | Sous-amendement no 875 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2526912"> 875</lienAdt> | |
| 15130001686648 | L15/debats | 15 | 15130001686589 | 15130001686647 | 1 | Amendement no 466 | Amendement n<sup>o</sup><lienAdt id_syceron="2526929"> 466</lienAdt> | |
| 15130001686650 | L15/debats | 15 | 15130001686589 | 15130001686649 | 1 | Amendements nos 778, 779 | Amendements n<sup>os</sup><lienAdt id_syceron="2527131"> 778, 779</lienAdt> | |
| 15130001686652 | L15/debats | 15 | 15130001686589 | 15130001686651 | 1 | Amendements nos 467, 213, 342, 662, 331, 377, 416, 489, 631, 417, 375, 145, 575, 574, 456, 457, 458, 214, 332, 634, 790, , 434, 573, 378, 329, 638, 376 | Amendements n<sup>os</sup><lienAdt id_syceron="2526943"> 467</lienAdt>, <lienAdt id_syceron="2526945"> 213</lienAdt>, <lienAdt id_syceron="2526947"> 342, 662</l… | |
| 15130001686653 | L15/debats | 15 | 15130001686589 | 15130001686651 | 2 | Sous-amendement no 865 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2527234"> 865</lienAdt> | |
| 15130001686654 | L15/debats | 15 | 15130001686589 | 15130001686651 | 3 | Amendements nos 664, 842, 330, 639, 694, 469 | Amendements n<sup>os</sup><lienAdt id_syceron="2527422"> 664</lienAdt>, <lienAdt id_syceron="2527237"> 842</lienAdt>, <lienAdt id_syceron="2527239"> 330, 639</l… | |
| 15130001686656 | L15/debats | 15 | 15130001686589 | 15130001686655 | 1 | Amendement no 772 | Amendement n<sup>o</sup><lienAdt id_syceron="2527247"> 772</lienAdt> | |
| 15130001686658 | L15/debats | 15 | 15130001686589 | 15130001686657 | 1 | Amendements nos 48, 223, 346, 379, 495, 788 | Amendements n<sup>os</sup><lienAdt id_syceron="2527442"> 48, 223, 346</lienAdt>, <lienAdt id_syceron="2527468"> 379</lienAdt>, <lienAdt id_syceron="2527445"> 49… | |
| 15130001686660 | L15/debats | 15 | 15130001686589 | 15130001686659 | 1 | Amendements nos 697, 435, 443, 770 | Amendements n<sup>os</sup><lienAdt id_syceron="2527455"> 697</lienAdt>, <lienAdt id_syceron="2527466"> 435</lienAdt>, <lienAdt id_syceron="2527495"> 443</lienAd… | |
| 15130001686662 | L15/debats | 15 | 15130001686589 | 15130001686661 | 1 | Amendements nos 328, 657, 696 | Amendements n<sup>os</sup><lienAdt id_syceron="2527504"> 328, 657</lienAdt>, <lienAdt id_syceron="2527505"> 696</lienAdt> | |
| 15130001686664 | L15/debats | 15 | 15130001686589 | 15130001686663 | 1 | M. Frédéric Petit | 2527510 | |
| 15130001686665 | L15/debats | 15 | 15130001686589 | 15130001686663 | 2 | Amendements nos 253, 274, 251, 258, 257, 256, 254, 255, 116, 252, 272, 273 | Amendements n<sup>os</sup><lienAdt id_syceron="2527514"> 253</lienAdt>, <lienAdt id_syceron="2527521"> 274</lienAdt>, <lienAdt id_syceron="2527534"> 251, 258, 2… | |
| 15130001686668 | L15/debats | 15 | 15130001686589 | 15130001686667 | 1 | Amendements nos 348, 825 | Amendements n<sup>os</sup><lienAdt id_syceron="2527656"> 348</lienAdt>, <lienAdt id_syceron="2527657"> 825</lienAdt> | |
| 15130001686669 | L15/debats | 15 | 15130001686589 | 15130001686667 | 2 | Sous-amendement no 868 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2527659"> 868</lienAdt> | |
| 15130001686671 | L15/debats | 15 | 15130001686589 | 15130001686670 | 1 | Amendement no 361 | Amendement n<sup>o</sup><lienAdt id_syceron="2527666"> 361</lienAdt> | |
| 15130001686674 | L15/debats | 15 | 15130001686589 | 15130001686673 | 1 | Amendement no 49 | Amendement n<sup>o</sup><lienAdt id_syceron="2527673"> 49</lienAdt> | |
| 15130001686677 | L15/debats | 15 | 15130001686589 | 15130001686676 | 1 | Amendements nos 864, 786 | Amendements n<sup>os</sup><lienAdt id_syceron="2527678"> 864</lienAdt>, <lienAdt id_syceron="2527680"> 786</lienAdt> | |
| 15130001686679 | L15/debats | 15 | 15130001686589 | 15130001686678 | 1 | Amendements nos 115, 546, 549 | Amendements n<sup>os</sup><lienAdt id_syceron="2527692"> 115, 546, 549</lienAdt> | |
| 15130001686681 | L15/debats | 15 | 15130001686589 | 15130001686680 | 1 | M. Philippe Gomès | 2527697 | |
| 15130001686682 | L15/debats | 15 | 15130001686589 | 15130001686680 | 2 | Amendements nos 482, 483 | Amendements n<sup>os</sup><lienAdt id_syceron="2527800"> 482</lienAdt>, <lienAdt id_syceron="2527807"> 483</lienAdt> | |
| 15130001686683 | L15/debats | 15 | 15130001686589 | 15130001686680 | 3 | Sous-amendement no 866 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2527809"> 866</lienAdt> | |
| 15130001686684 | L15/debats | 15 | 15130001686589 | 15130001686680 | 4 | Amendement no 481 | Amendement n<sup>o</sup><lienAdt id_syceron="2527815"> 481</lienAdt> | |
| 15130001686686 | L15/debats | 15 | 15130001686589 | 15130001686685 | 1 | Amendements nos 38, 235, 526 | Amendements n<sup>os</sup><lienAdt id_syceron="2527824"> 38, 235</lienAdt>, <lienAdt id_syceron="2527826"> 526</lienAdt> | |
| 15130001686688 | L15/debats | 15 | 15130001686589 | 15130001686687 | 1 | Amendement no 827 | Amendement n<sup>o</sup><lienAdt id_syceron="2527834"> 827</lienAdt> | |
| 15130001686693 | L15/debats | 15 | 15130001686589 | 15130001686692 | 1 | Amendement no 7 | Amendement n<sup>o</sup><lienAdt id_syceron="2527841"> 7</lienAdt> | |
| 15130001686696 | L15/debats | 15 | 15130001686589 | 15130001686695 | 1 | Amendements nos 1, 9, 2, 11, 10 | Amendements n<sup>os</sup><lienAdt id_syceron="2527848"> 1</lienAdt>, <lienAdt id_syceron="2527851"> 9</lienAdt>, <lienAdt id_syceron="2527856"> 2</lienAdt>, <l… | |
| 15130001686698 | L15/debats | 15 | 15130001686589 | 15130001686697 | 1 | Amendement no 8 | Amendement n<sup>o</sup><lienAdt id_syceron="2527863"> 8</lienAdt> | |
| 15130001686700 | L15/debats | 15 | 15130001686589 | 15130001686699 | 1 | Amendement no 6 | Amendement n<sup>o</sup><lienAdt id_syceron="2527870"> 6</lienAdt> | |
| 15130001689823 | L15/debats | 15 | 15130001689805 | 15130001689822 | 1 | M. Dominique Potier | 2530734 | |
| 15130001689824 | L15/debats | 15 | 15130001689805 | 15130001689822 | 2 | M. Thierry Benoit | 2530739 | |
| 15130001689825 | L15/debats | 15 | 15130001689805 | 15130001689822 | 3 | M. Jean-Michel Clément | 2530748 | |
| 15130001689826 | L15/debats | 15 | 15130001689805 | 15130001689822 | 4 | M. Patrice Perrot, rapporteur pour avis de la commission du développement durable et de l’aménagement du territoire | 2530961 | |
| 15130001689827 | L15/debats | 15 | 15130001689805 | 15130001689822 | 5 | M. Maxime Minot | 2530832 | |
| 15130001689828 | L15/debats | 15 | 15130001689805 | 15130001689822 | 6 | M. Cédric Villani | 2530838 | |
| 15130001689829 | L15/debats | 15 | 15130001689805 | 15130001689822 | 7 | Amendements nos 46, 141 | Amendements n<sup>os</sup><lienAdt id_syceron="2530845"> 46</lienAdt>, <lienAdt id_syceron="2530850"> 141</lienAdt> | |
| 15130001689830 | L15/debats | 15 | 15130001689805 | 15130001689822 | 8 | M. Jean-Bernard Sempastous, rapporteur de la commission des affaires économiques | 2530853 | |
| 15130001689831 | L15/debats | 15 | 15130001689805 | 15130001689822 | 9 | Amendements nos 133, 12, 8, 47, 48, 142, 24, 49, 95, 143, 177, 43, 196, 78, 166, 161, 139, 39, 44, 89, 162 | Amendements n<sup>os</sup><lienAdt id_syceron="2530213"> 133</lienAdt>, <lienAdt id_syceron="2530219"> 12</lienAdt>, <lienAdt id_syceron="2530226"> 8</lienAdt>,… |