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 |
|---|---|---|---|---|---|---|---|---|
| 15130000298799 | L15/debats | 15 | 15130000298732 | 15130000298798 | 1 | M. Jean-Hugues Ratenon | 1169049 | |
| 15130000298800 | L15/debats | 15 | 15130000298732 | 15130000298798 | 2 | Amendements nos717, 363 | Amendements n<sup>os</sup><lienAdt id_syceron="1169051">717</lienAdt>, <lienAdt id_syceron="1169054">363</lienAdt> | |
| 15130000298802 | L15/debats | 15 | 15130000298732 | 15130000298801 | 1 | Amendements nos839, 659, 835 | Amendements n<sup>os</sup><lienAdt id_syceron="1169062">839</lienAdt>, <lienAdt id_syceron="1169065">659</lienAdt>, <lienAdt id_syceron="1169072">835</lienAdt> | |
| 15130000298804 | L15/debats | 15 | 15130000298732 | 15130000298803 | 1 | M. Thibault Bazin | 1169078 | |
| 15130000298805 | L15/debats | 15 | 15130000298732 | 15130000298803 | 2 | M. Philippe Chassaing | 1169083 | |
| 15130000298806 | L15/debats | 15 | 15130000298732 | 15130000298803 | 3 | M. Marc Fesneau | 1169086 | |
| 15130000298807 | L15/debats | 15 | 15130000298732 | 15130000298803 | 4 | M. Arnaud Viala | 1169094 | |
| 15130000298808 | L15/debats | 15 | 15130000298732 | 15130000298803 | 5 | Mme Émilie Bonnivard | 1169098 | |
| 15130000298809 | L15/debats | 15 | 15130000298732 | 15130000298803 | 6 | M. Philippe Gosselin | 1169102 | |
| 15130000298810 | L15/debats | 15 | 15130000298732 | 15130000298803 | 7 | Mme Véronique Louwagie | 1169106 | |
| 15130000298811 | L15/debats | 15 | 15130000298732 | 15130000298803 | 8 | M. Jean-Baptiste Moreau | 1169111 | |
| 15130000298812 | L15/debats | 15 | 15130000298732 | 15130000298803 | 9 | M. Jean Terlier | 1169119 | |
| 15130000298813 | L15/debats | 15 | 15130000298732 | 15130000298803 | 10 | M. Nicolas Turquois | 1169122 | |
| 15130000298814 | L15/debats | 15 | 15130000298732 | 15130000298803 | 11 | M. Julien Dive | 1169124 | |
| 15130000300553 | L15/debats | 15 | 15130000300548 | 15130000300552 | 1 | Amendement no68 | Amendement n<sup>o</sup><lienAdt id_syceron="1169290">68</lienAdt> | |
| 15130000300554 | L15/debats | 15 | 15130000300548 | 15130000300552 | 2 | M. Stanislas Guerini, rapporteur de la commission spéciale chargée d’examiner le projet de loi pour un État au service d’une société de confiance | 1169346 | |
| 15130000300555 | L15/debats | 15 | 15130000300548 | 15130000300552 | 3 | M. Gérald Darmanin, ministre de l’action et des comptes publics | 1169298 | |
| 15130000300556 | L15/debats | 15 | 15130000300548 | 15130000300552 | 4 | Amendements nos469, 230, 332, 470, 988, 898, 918 rectifié, 544 | Amendements n<sup>os</sup><lienAdt id_syceron="1169306">469</lienAdt>, <lienAdt id_syceron="1169311">230, 332, 470</lienAdt>, <lienAdt id_syceron="1169326">988<… | |
| 15130000300558 | L15/debats | 15 | 15130000300548 | 15130000300557 | 1 | Amendement no550 | Amendement n<sup>o</sup><lienAdt id_syceron="1169401">550</lienAdt> | |
| 15130000300560 | L15/debats | 15 | 15130000300548 | 15130000300559 | 1 | M. Jean Terlier | 1169566 | |
| 15130000300561 | L15/debats | 15 | 15130000300548 | 15130000300559 | 2 | M. André Chassaigne | 1169573 | |
| 15130000300562 | L15/debats | 15 | 15130000300548 | 15130000300559 | 3 | Amendements nos518, 525, 556, 60, 545, 114, 61, 543 | Amendements n<sup>os</sup><lienAdt id_syceron="1169578">518</lienAdt>, <lienAdt id_syceron="1169583">525</lienAdt>, <lienAdt id_syceron="1169586">556</lienAdt>,… | |
| 15130000300564 | L15/debats | 15 | 15130000300548 | 15130000300563 | 1 | Amendements nos47, 44, 231, 471, 48, 52, 102, 233, 67, 46, 103, 232, 558, 598, 765 | Amendements n<sup>os</sup><lienAdt id_syceron="1169618">47</lienAdt>, <lienAdt id_syceron="1169626">44</lienAdt>, <lienAdt id_syceron="1169628">231</lienAdt>, <… | |
| 15130000300566 | L15/debats | 15 | 15130000300548 | 15130000300565 | 1 | Mme Danielle Brulebois | 1169770 | |
| 15130000300567 | L15/debats | 15 | 15130000300548 | 15130000300565 | 2 | Amendements nos1083, 919, 770, 101, 1041, 1100 (sous-amendement), 334, 795, 1031, 570, 234 | Amendements n<sup>os</sup><lienAdt id_syceron="1169773">1083</lienAdt>, <lienAdt id_syceron="1169776">919</lienAdt>, <lienAdt id_syceron="1169785">770</lienAdt>… | |
| 15130000300569 | L15/debats | 15 | 15130000300548 | 15130000300568 | 1 | Amendements nos384, 170, 145, 661 | Amendements n<sup>os</sup><lienAdt id_syceron="1169880">384, 170</lienAdt>, <lienAdt id_syceron="1169892">145</lienAdt>, <lienAdt id_syceron="1169904">661</lien… | |
| 15130000300571 | L15/debats | 15 | 15130000300548 | 15130000300570 | 1 | Amendements nos754, 483 | Amendements n<sup>os</sup><lienAdt id_syceron="1169908">754</lienAdt>, <lienAdt id_syceron="1169912">483</lienAdt> | |
| 15130000300573 | L15/debats | 15 | 15130000300548 | 15130000300572 | 1 | Amendements nos899, 140 | Amendements n<sup>os</sup><lienAdt id_syceron="1169917">899</lienAdt>, <lienAdt id_syceron="1169925">140</lienAdt> | |
| 15130000300576 | L15/debats | 15 | 15130000300548 | 15130000300575 | 1 | M. Mohamed Laqhila | 1169938 | |
| 15130000300577 | L15/debats | 15 | 15130000300548 | 15130000300575 | 2 | Amendements nos62, 81, 547, 721, 146, 235, 685, 73, 1049 rectifié, 407, 236, 147, 339 | Amendements n<sup>os</sup><lienAdt id_syceron="1169942">62</lienAdt>, <lienAdt id_syceron="1169944">81</lienAdt>, <lienAdt id_syceron="1169946">547</lienAdt>, <… | |
| 15130000300579 | L15/debats | 15 | 15130000300548 | 15130000300578 | 1 | Amendements nos148, 921, 237, 662 | Amendements n<sup>os</sup><lienAdt id_syceron="1170183">148</lienAdt>, <lienAdt id_syceron="1170334">921</lienAdt>, <lienAdt id_syceron="1170342">237</lienAdt>,… | |
| 15130000300581 | L15/debats | 15 | 15130000300548 | 15130000300580 | 1 | M. Raphaël Gérard | 1170374 | |
| 15130000300582 | L15/debats | 15 | 15130000300548 | 15130000300580 | 2 | Amendements nos755, 385, 576, 241, 843 | Amendements n<sup>os</sup><lienAdt id_syceron="1170378">755, 385</lienAdt>, <lienAdt id_syceron="1170555">576</lienAdt>, <lienAdt id_syceron="1170563">241</lien… | |
| 15130000300584 | L15/debats | 15 | 15130000300548 | 15130000300583 | 1 | Amendements nos150, 239, 151, 240, 63, 238, 1005, 149 | Amendements n<sup>os</sup><lienAdt id_syceron="1170580">150</lienAdt>, <lienAdt id_syceron="1170587">239</lienAdt>, <lienAdt id_syceron="1170600">151</lienAdt>,… | |
| 15130000300586 | L15/debats | 15 | 15130000300548 | 15130000300585 | 1 | Amendements nos740, 418 | Amendements n<sup>os</sup><lienAdt id_syceron="1169215">740</lienAdt>, <lienAdt id_syceron="1169222">418</lienAdt> | |
| 15130000300589 | L15/debats | 15 | 15130000300548 | 15130000300588 | 1 | Amendements nos1053, 1054, 412 | Amendements n<sup>os</sup><lienAdt id_syceron="1169240">1053, 1054</lienAdt>, <lienAdt id_syceron="1169263">412</lienAdt> | |
| 15130000300591 | L15/debats | 15 | 15130000300548 | 15130000300590 | 1 | M. Raphaël Gérard | 1169270 | |
| 15130000300592 | L15/debats | 15 | 15130000300548 | 15130000300590 | 2 | M. Dominique Da Silva | 1169277 | |
| 15130000300593 | L15/debats | 15 | 15130000300548 | 15130000300590 | 3 | M. Mohamed Laqhila | 1169348 | |
| 15130000300594 | L15/debats | 15 | 15130000300548 | 15130000300590 | 4 | Amendements nos507, 566, 65, 517, 680, 689, 965, 861, 862, 863, 690, 951, 1110 (sous-amendement), 1094 rectifié (sous-amendement), 308, 486, 487, 674, 111 | Amendements n<sup>os</sup><lienAdt id_syceron="1169351">507</lienAdt>, <lienAdt id_syceron="1169357">566</lienAdt>, <lienAdt id_syceron="1169369">65</lienAdt>, … | |
| 15130000300596 | L15/debats | 15 | 15130000300548 | 15130000300595 | 1 | Amendements nos831, 153, 600, 447, 281, 190, 772, 1093, 923, 1109 (sous-amendement), 1095 (sous-amendement), 124, 109, 243 | Amendements n<sup>os</sup><lienAdt id_syceron="1169652">831</lienAdt>, <lienAdt id_syceron="1169655">153</lienAdt>, <lienAdt id_syceron="1169658">600</lienAdt>,… | |
| 15130000300599 | L15/debats | 15 | 15130000300548 | 15130000300598 | 1 | Mme Danièle Hérin | 1169730 | |
| 15130000300600 | L15/debats | 15 | 15130000300548 | 15130000300598 | 2 | Mme Danièle Obono | 1169820 | |
| 15130000300601 | L15/debats | 15 | 15130000300548 | 15130000300598 | 3 | M. Patrick Hetzel | 1169824 | |
| 15130000300602 | L15/debats | 15 | 15130000300548 | 15130000300598 | 4 | Amendements nos520, 587, 933, 934, 935, 936, 1044, 676, 488, 489 | Amendements n<sup>os</sup><lienAdt id_syceron="1169828">520</lienAdt>, <lienAdt id_syceron="1169833">587</lienAdt>, <lienAdt id_syceron="1169837">933</lienAdt>,… | |
| 15130000300604 | L15/debats | 15 | 15130000300548 | 15130000300603 | 1 | Amendements nos459, 678, 677, 138, 938 | Amendements n<sup>os</sup><lienAdt id_syceron="1169992">459</lienAdt>, <lienAdt id_syceron="1170003">678, 677</lienAdt>, <lienAdt id_syceron="1170019">138</lien… | |
| 15130000300606 | L15/debats | 15 | 15130000300548 | 15130000300605 | 1 | Mme Véronique Hammerer | 1170037 | |
| 15130000300607 | L15/debats | 15 | 15130000300548 | 15130000300605 | 2 | Amendements nos519, 594, 351, 867, 873, 869, 870, 871, 872, 874, 875, 955, 1112 (sous-amendement) | Amendements n<sup>os</sup><lienAdt id_syceron="1170044">519</lienAdt>, <lienAdt id_syceron="1170385">594</lienAdt>, <lienAdt id_syceron="1170404">351</lienAdt>,… | |
| 15130000302576 | L15/debats | 15 | 15130000302571 | 15130000302575 | 1 | Amendement no352 | Amendement n<sup>o</sup><lienAdt id_syceron="1170062">352</lienAdt> | |
| 15130000302577 | L15/debats | 15 | 15130000302571 | 15130000302575 | 2 | M. Stanislas Guerini, rapporteur de la commission spéciale chargée d’examiner le projet de loi pour un État au service d’une société de confiance | 1170065 |