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 |
|---|---|---|---|---|---|---|---|---|
| 16130000465248 | L16/debats | 16 | 16130000465225 | 16130000465246 | 2 | M. Jérémie Patrier-Leitus | 3157261 | |
| 16130000465249 | L16/debats | 16 | 16130000465225 | 16130000465246 | 3 | Amendements nos 1071, 670, 1073 | Amendements n<sup>os</sup> <lienAdt id_syceron="3157262"> 1071</lienAdt>, <lienAdt id_syceron="3157661"> 670</lienAdt>, <lienAdt id_syceron="3157679"> 1073</lie… | |
| 16130000465251 | L16/debats | 16 | 16130000465225 | 16130000465250 | 1 | Amendement no 1002 | Amendement n<sup>o</sup> <lienAdt id_syceron="3157688"> 1002</lienAdt> | |
| 16130000465253 | L16/debats | 16 | 16130000465225 | 16130000465252 | 1 | Amendements nos 261 deuxième rectification, 489 | Amendements n<sup>os</sup> <lienAdt id_syceron="3157705"> 261 deuxième rectification</lienAdt>, <lienAdt id_syceron="3157861"> 489</lienAdt> | |
| 16130000465255 | L16/debats | 16 | 16130000465225 | 16130000465254 | 1 | Amendement no 527 | Amendement n<sup>o</sup> <lienAdt id_syceron="3157865"> 527</lienAdt> | |
| 16130000465256 | L16/debats | 16 | 16130000465225 | 16130000465254 | 2 | Sous-amendement no 1133 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3157867"> 1133</lienAdt> | |
| 16130000465257 | L16/debats | 16 | 16130000465225 | 16130000465254 | 3 | Amendement no 628, 626, 638 | Amendement n<sup>o</sup> <lienAdt id_syceron="3157870"> 628, 626, 638</lienAdt> | |
| 16130000465259 | L16/debats | 16 | 16130000465225 | 16130000465258 | 1 | Amendements nos 1150, 1154, 1158, 1159, 1160, 1168 | Amendements n<sup>os</sup> <lienAdt id_syceron="3157874"> 1150</lienAdt>, <lienAdt id_syceron="3157877"> 1154</lienAdt>, <lienAdt id_syceron="3157878"> 1158</li… | |
| 16130000465261 | L16/debats | 16 | 16130000465225 | 16130000465260 | 1 | M. Thierry Frappé | 3158083 | |
| 16130000465262 | L16/debats | 16 | 16130000465225 | 16130000465260 | 2 | Amendements nos 342, 521, 673 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158084"> 342</lienAdt>, <lienAdt id_syceron="3158088"> 521</lienAdt>, <lienAdt id_syceron="3158092"> 673</lienA… | |
| 16130000465263 | L16/debats | 16 | 16130000465225 | 16130000465260 | 3 | Mme Agnès Firmin Le Bodo, ministre déléguée chargée de l’organisation territoriale et des professions de santé | 3158103 | |
| 16130000465264 | L16/debats | 16 | 16130000465225 | 16130000465260 | 4 | Amendements nos 340, 43, 716, 341, 518 | Amendements n<sup>os</sup> <lienAdt id_syceron="3157707"> 340</lienAdt>, <lienAdt id_syceron="3157709"> 43</lienAdt>, <lienAdt id_syceron="3157717"> 716</lienAd… | |
| 16130000465265 | L16/debats | 16 | 16130000465225 | 16130000465260 | 5 | Sous-amendement no 1179 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3157725"> 1179</lienAdt> | |
| 16130000465267 | L16/debats | 16 | 16130000465225 | 16130000465266 | 1 | Amendements nos 113, 1019 rectifié, 1045, 1081 | Amendements n<sup>os</sup> <lienAdt id_syceron="3157738"> 113</lienAdt>, <lienAdt id_syceron="3157739"> 1019 rectifié</lienAdt>, <lienAdt id_syceron="3157744"> … | |
| 16130000465269 | L16/debats | 16 | 16130000465225 | 16130000465268 | 1 | Amendements nos 1036, 1035, 136, 591, 946, 947, 161, 759, 932, 933, 934, 747, 985, 476, 522, 1041, 445, 705, 1032, 449, 477, 751 | Amendements n<sup>os</sup> <lienAdt id_syceron="3157964"> 1036, 1035</lienAdt>, <lienAdt id_syceron="3157968"> 136</lienAdt>, <lienAdt id_syceron="3157970"> 591… | |
| 16130000465272 | L16/debats | 16 | 16130000465225 | 16130000465271 | 1 | Amendements nos 44, 869, 710, 675, 762 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158169"> 44</lienAdt>, <lienAdt id_syceron="3158180"> 869</lienAdt>, <lienAdt id_syceron="3158185"> 710</lienAd… | |
| 16130000465274 | L16/debats | 16 | 16130000465225 | 16130000465273 | 1 | Amendements nos 806, 911, 912, 913, 857 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158625"> 806</lienAdt>, <lienAdt id_syceron="3158117"> 911</lienAdt>, <lienAdt id_syceron="3159324"> 912</lienA… | |
| 16130000465276 | L16/debats | 16 | 16130000465225 | 16130000465275 | 1 | M. Timothée Houssin | 3157911 | |
| 16130000465277 | L16/debats | 16 | 16130000465225 | 16130000465275 | 2 | Mme Astrid Panosyan-Bouvet | 3157916 | |
| 16130000465278 | L16/debats | 16 | 16130000465225 | 16130000465275 | 3 | M. Pierre Dharréville | 3157923 | |
| 16130000465279 | L16/debats | 16 | 16130000465225 | 16130000465275 | 4 | Amendements nos 1148, 1151, 1152, 1153, 534, 533, 994, 38, 532 | Amendements n<sup>os</sup> <lienAdt id_syceron="3157928"> 1148</lienAdt>, <lienAdt id_syceron="3157934"> 1151</lienAdt>, <lienAdt id_syceron="3157938"> 1152</li… | |
| 16130000465281 | L16/debats | 16 | 16130000465225 | 16130000465280 | 1 | Amendements nos 156, 704 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158540"> 156</lienAdt>, <lienAdt id_syceron="3158547"> 704</lienAdt> | |
| 16130000465283 | L16/debats | 16 | 16130000465225 | 16130000465282 | 1 | Amendements nos 689, 686, 989, 1016, 1015, 67, 66, 64, 253, 1184, 997, 873, 875, 1147, 1149, 1155, 1156, 1157, 1163, 1166, 539, 50, 935 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158566"> 689</lienAdt>, <lienAdt id_syceron="3158568"> 686</lienAdt>, <lienAdt id_syceron="3158574"> 989</lienA… | |
| 16130000465285 | L16/debats | 16 | 16130000465225 | 16130000465284 | 1 | M. Maxime Laisney | 3159786 | |
| 16130000465286 | L16/debats | 16 | 16130000465225 | 16130000465284 | 2 | Amendement no 696 | Amendement n<sup>o</sup> <lienAdt id_syceron="3159788"> 696</lienAdt> | |
| 16130000467037 | L16/debats | 16 | 16130000467032 | 16130000467036 | 1 | Amendement no 746 | Amendement n<sup>o</sup> <lienAdt id_syceron="3158703"> 746</lienAdt> | |
| 16130000467038 | L16/debats | 16 | 16130000467032 | 16130000467036 | 2 | M. Frédéric Valletoux, rapporteur de la commission des affaires sociales | 3158704 | |
| 16130000467039 | L16/debats | 16 | 16130000467032 | 16130000467036 | 3 | M. François Braun, ministre de la santé et de la prévention | 3158707 | |
| 16130000467040 | L16/debats | 16 | 16130000467032 | 16130000467036 | 4 | Amendements nos 145, 936, 676, 743, 949, 700 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158713"> 145</lienAdt>, <lienAdt id_syceron="3158720"> 936</lienAdt>, <lienAdt id_syceron="3158725"> 676</lienA… | |
| 16130000467042 | L16/debats | 16 | 16130000467032 | 16130000467041 | 1 | Amendements nos 1082, 147, 1033 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158740"> 1082</lienAdt>, <lienAdt id_syceron="3158757"> 147</lienAdt>, <lienAdt id_syceron="3158767"> 1033</lie… | |
| 16130000467044 | L16/debats | 16 | 16130000467032 | 16130000467043 | 1 | Amendements nos 245, 375, 702 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158777"> 245</lienAdt>, <lienAdt id_syceron="3158779"> 375</lienAdt>, <lienAdt id_syceron="3158780"> 702</lienA… | |
| 16130000467046 | L16/debats | 16 | 16130000467032 | 16130000467045 | 1 | Amendement no 775 | Amendement n<sup>o</sup> <lienAdt id_syceron="3158801"> 775</lienAdt> | |
| 16130000467048 | L16/debats | 16 | 16130000467032 | 16130000467047 | 1 | Mme Ersilia Soudais | 3158805 | |
| 16130000467049 | L16/debats | 16 | 16130000467032 | 16130000467047 | 2 | Amendements nos 26, 376, 863 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158810"> 26</lienAdt>, <lienAdt id_syceron="3158813"> 376</lienAdt>, <lienAdt id_syceron="3158827"> 863</lienAd… | |
| 16130000467050 | L16/debats | 16 | 16130000467032 | 16130000467047 | 3 | Sous-amendement no 1124 | Sous-amendement n<sup>o</sup> <lienAdt id_syceron="3158829"> 1124</lienAdt> | |
| 16130000467051 | L16/debats | 16 | 16130000467032 | 16130000467047 | 4 | Amendements nos 266, 46, 45, 270, 96, 1121, 95, 273, 379, 377, 378, 47, 957, 1028, 275, 536, 32, 540, 1115, 60, 576, 99, 39, 94, 1116, 381, 51, 383, 384, 33 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158835"> 266</lienAdt>, <lienAdt id_syceron="3158842"> 46, 45</lienAdt>, <lienAdt id_syceron="3158851"> 270</li… | |
| 16130000467053 | L16/debats | 16 | 16130000467032 | 16130000467052 | 1 | Amendements nos 1034, 926, 927, 294 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158920"> 1034</lienAdt>, <lienAdt id_syceron="3158930"> 926</lienAdt>, <lienAdt id_syceron="3158932"> 927</lien… | |
| 16130000467055 | L16/debats | 16 | 16130000467032 | 16130000467054 | 1 | Amendements nos 848, 541, 757, 299 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158942"> 848</lienAdt>, <lienAdt id_syceron="3159071"> 541</lienAdt>, <lienAdt id_syceron="3159076"> 757</lienA… | |
| 16130000467057 | L16/debats | 16 | 16130000467032 | 16130000467056 | 1 | Amendement no 1122 | Amendement n<sup>o</sup> <lienAdt id_syceron="3159091"> 1122</lienAdt> | |
| 16130000467059 | L16/debats | 16 | 16130000467032 | 16130000467058 | 1 | Amendement no 402 | Amendement n<sup>o</sup> <lienAdt id_syceron="3159096"> 402</lienAdt> | |
| 16130000467060 | L16/debats | 16 | 16130000467032 | 16130000467058 | 2 | Mme Agnès Firmin Le Bodo, ministre déléguée chargée de l’organisation territoriale et des professions de santé | 3159212 | |
| 16130000467061 | L16/debats | 16 | 16130000467032 | 16130000467058 | 3 | Amendements nos 398, 542, 813, 897, 387, 779, 810, 389, 390, 394, 396, 397, 14, 392, 399, 537, 798, 400, 818, 401 , 55, 718, 318, 571, 915, 916, 917, 1057, 1062… | Amendements n<sup>os</sup> <lienAdt id_syceron="3159098"> 398, 542</lienAdt>, <lienAdt id_syceron="3159100"> 813</lienAdt>, <lienAdt id_syceron="3159102"> 897, … | |
| 16130000467063 | L16/debats | 16 | 16130000467032 | 16130000467062 | 1 | M. Matthieu Marchio | 3159049 | |
| 16130000467064 | L16/debats | 16 | 16130000467032 | 16130000467062 | 2 | M. Pierre Dharréville | 3159057 | |
| 16130000467065 | L16/debats | 16 | 16130000467032 | 16130000467062 | 3 | Amendements nos 48, 543, 1059, 758, 1025, 321, 1013, 329, 1038, 448, 354, 404, 403, 408 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158639"> 48</lienAdt>, <lienAdt id_syceron="3158640"> 543</lienAdt>, <lienAdt id_syceron="3158650"> 1059</lienA… | |
| 16130000467067 | L16/debats | 16 | 16130000467032 | 16130000467066 | 1 | Amendements nos 708, 709, 711, 395 | Amendements n<sup>os</sup> <lienAdt id_syceron="3158687"> 708, 709, 711</lienAdt>, <lienAdt id_syceron="3158689"> 395</lienAdt> | |
| 16130000467069 | L16/debats | 16 | 16130000467032 | 16130000467068 | 1 | Amendements nos 579, 363, 27, 129, 361, 28, 130, 369, 849, 1011, 1012, 544, 950, 163, 837, 951, 242, 845, 905, 906, 1103, 211, 117, 461, 416, 568, 939, 940, 941… | Amendements n<sup>os</sup> <lienAdt id_syceron="3158945"> 579</lienAdt>, <lienAdt id_syceron="3158947"> 363</lienAdt>, <lienAdt id_syceron="3158957"> 27</lienAd… | |
| 16130000467071 | L16/debats | 16 | 16130000467032 | 16130000467070 | 1 | Amendement no 1186 | Amendement n<sup>o</sup> <lienAdt id_syceron="3159973"> 1186</lienAdt> | |
| 16130000468385 | L16/debats | 16 | 16130000468364 | 16130000468384 | 1 | Mme Mathilde Paris | 3159999 | |
| 16130000468386 | L16/debats | 16 | 16130000468364 | 16130000468384 | 2 | Amendements nos 218, 32 | Amendements n<sup>os</sup> <lienAdt id_syceron="3160004"> 218</lienAdt>, <lienAdt id_syceron="3160031"> 32</lienAdt> |