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 |
|---|---|---|---|---|---|---|---|---|
| 15130001329182 | L15/debats | 15 | 15130001329172 | 15130001329181 | 1 | M. Joachim Son-Forget | 2593275 | |
| 15130001329184 | L15/debats | 15 | 15130001329172 | 15130001329183 | 1 | Amendements nos 341, 23, 137, 669, 804, 787, 291, 574, 575, 630, 153, 292, 151, 162, 573, 685, 862, 687, 92, 174, 529, 628, 659, 742, 789, 915, 1026, 1033 recti… | Amendements n<sup>os</sup><lienAdt id_syceron="2593279"> 341</lienAdt>, <lienAdt id_syceron="2593309"> 23</lienAdt>, <lienAdt id_syceron="2593311">137, 669</lie… | |
| 15130001329185 | L15/debats | 15 | 15130001329172 | 15130001329183 | 2 | Sous-amendements nos 1214, 1205, 1206, 1215, 1216, 1217, 1224, 1218, 1197 rectifié, 1207, 1213 rectifié, 1209, 1219, 1234, 1202, 1198, 1222, 1212, 1211, 1203, 1… | Sous-amendements n<sup>os</sup><lienAdt id_syceron="2593550"> 1214</lienAdt>, <lienAdt id_syceron="2593553"> 1205</lienAdt>, <lienAdt id_syceron="2593559"> 1206… | |
| 15130001329186 | L15/debats | 15 | 15130001329172 | 15130001329183 | 3 | Amendements nos259, 1097, 53, 65, 125, 284, 369, 404, 470, 541, 632, 664, 712, 744, 857, 980, 1122, 660, 261, 984, 94, 25, 298, 1006, 1114, 371, 931, 933, 932, … | Amendements n<sup>os</sup><lienAdt id_syceron="2594727">259, 1097</lienAdt>, <lienAdt id_syceron="2594730"> 53, 65</lienAdt>, <lienAdt id_syceron="2594731"> 125… | |
| 15130001329189 | L15/debats | 15 | 15130001329172 | 15130001329188 | 1 | Amendements nos 681, 1115, 890, 891, 893, 898, 1174, 1175 | Amendements n<sup>os</sup><lienAdt id_syceron="2595570"> 681</lienAdt>, <lienAdt id_syceron="2595684"> 1115, 890</lienAdt>, <lienAdt id_syceron="2595577"> 891, … | |
| 15130001329190 | L15/debats | 15 | 15130001329172 | 15130001329188 | 2 | Sous-amendement no 1221 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2595585"> 1221</lienAdt> | |
| 15130001329191 | L15/debats | 15 | 15130001329172 | 15130001329188 | 3 | Amendements nos 673, 523 rectifié, 335, 902, 903, 904, 909, 793, 1111 | Amendements n<sup>os</sup><lienAdt id_syceron="2595596"> 673</lienAdt>, <lienAdt id_syceron="2595599"> 523 rectifié</lienAdt>, <lienAdt id_syceron="2595605"> 33… | |
| 15130001329193 | L15/debats | 15 | 15130001329172 | 15130001329192 | 1 | M. Fabrice Brun | 2594953 | |
| 15130001329194 | L15/debats | 15 | 15130001329172 | 15130001329192 | 2 | Amendements nos 455, 582, 993, 110, 238, 1136, 548, 306, 307, 262, 1106 | Amendements n<sup>os</sup><lienAdt id_syceron="2594956"> 455</lienAdt>, <lienAdt id_syceron="2594958"> 582, 993</lienAdt>, <lienAdt id_syceron="2594969"> 110</l… | |
| 15130001329196 | L15/debats | 15 | 15130001329172 | 15130001329195 | 1 | M. Jérôme Nury | 2594991 | |
| 15130001329197 | L15/debats | 15 | 15130001329172 | 15130001329195 | 2 | Amendements nos 456, 502, 546, 583, 790, 1137, 155, 800, 32, 205 | Amendements n<sup>os</sup><lienAdt id_syceron="2595379"> 456, 502, 546, 583, 790, 1137</lienAdt>, <lienAdt id_syceron="2595381"> 155</lienAdt>, <lienAdt id_syce… | |
| 15130001329199 | L15/debats | 15 | 15130001329172 | 15130001329198 | 1 | Amendement no 1088 | Amendement n<sup>o</sup><lienAdt id_syceron="2595392"> 1088</lienAdt> | |
| 15130001329201 | L15/debats | 15 | 15130001329172 | 15130001329200 | 1 | M. Michel Castellani | 2595396 | |
| 15130001329202 | L15/debats | 15 | 15130001329172 | 15130001329200 | 2 | M. Aurélien Pradié | 2595399 | |
| 15130001329203 | L15/debats | 15 | 15130001329172 | 15130001329200 | 3 | Amendements nos 239, 457, 542, 584, 638, 792, 986, 207, 1002, 1052, 206, 308, 240, 1139, 309, 77, 35, 444, 1003, 310, 76, 215, 707, 713, 1027, 172, 263, 797, 18… | Amendements n<sup>os</sup><lienAdt id_syceron="2595400"> 239</lienAdt>, <lienAdt id_syceron="2595403"> 457</lienAdt>, <lienAdt id_syceron="2595406"> 542</lienAd… | |
| 15130001329205 | L15/debats | 15 | 15130001329172 | 15130001329204 | 1 | Amendements nos 144, 750, 434, 435, 650, 1176 | Amendements n<sup>os</sup><lienAdt id_syceron="2597087"> 144</lienAdt>, <lienAdt id_syceron="2597089"> 750</lienAdt>, <lienAdt id_syceron="2597097"> 434, 435, 6… | |
| 15130001329207 | L15/debats | 15 | 15130001329172 | 15130001329206 | 1 | Amendement no 760 | Amendement n<sup>o</sup><lienAdt id_syceron="2597109"> 760</lienAdt> | |
| 15130001329209 | L15/debats | 15 | 15130001329172 | 15130001329208 | 1 | Amendement no 326 | Amendement n<sup>o</sup><lienAdt id_syceron="2597113"> 326</lienAdt> | |
| 15130001329211 | L15/debats | 15 | 15130001329172 | 15130001329210 | 1 | M. Jean-Paul Lecoq | 2597125 | |
| 15130001329213 | L15/debats | 15 | 15130001329172 | 15130001329212 | 1 | Amendement no 1009 | Amendement n<sup>o</sup><lienAdt id_syceron="2597129"> 1009</lienAdt> | |
| 15130001329215 | L15/debats | 15 | 15130001329172 | 15130001329214 | 1 | Amendement no 230, 340 | Amendement n<sup>o</sup><lienAdt id_syceron="2597132"> 230, 340</lienAdt> | |
| 15130001329217 | L15/debats | 15 | 15130001329172 | 15130001329216 | 1 | M. Philippe Michel-Kleisbauer | 2597136 | |
| 15130001329218 | L15/debats | 15 | 15130001329172 | 15130001329216 | 2 | Amendements nos 75, 612, 691, 794, 858, 1160 | Amendements n<sup>os</sup><lienAdt id_syceron="2597139"> 75</lienAdt>, <lienAdt id_syceron="2597140"> 612</lienAdt>, <lienAdt id_syceron="2597141"> 691</lienAdt… | |
| 15130001329220 | L15/debats | 15 | 15130001329172 | 15130001329219 | 1 | Mme Lamia El Aaraje | 2596570 | |
| 15130001329221 | L15/debats | 15 | 15130001329172 | 15130001329219 | 2 | M. Jean-Baptiste Moreau | 2596519 | |
| 15130001329223 | L15/debats | 15 | 15130001329172 | 15130001329222 | 1 | Amendements nos 27, 729, 472, 231, 766, 150, 806, 811, 812, 677, 899, 1086, 813, 783, 814, 447, 745, 784, 2, 408, 409, 665, 816, 1171, 1017, 956, 241, 393, 595,… | Amendements n<sup>os</sup><lienAdt id_syceron="2596522"> 27, 729</lienAdt>, <lienAdt id_syceron="2596523"> 472</lienAdt>, <lienAdt id_syceron="2596528"> 231</li… | |
| 15130001329225 | L15/debats | 15 | 15130001329172 | 15130001329224 | 1 | Amendements nos 74, 916, 516, 819, 290, 761, 762 | Amendements n<sup>os</sup><lienAdt id_syceron="2595553"> 74, 916</lienAdt>, <lienAdt id_syceron="2595555"> 516</lienAdt>, <lienAdt id_syceron="2595557"> 819</li… | |
| 15130001329227 | L15/debats | 15 | 15130001329172 | 15130001329226 | 1 | Amendements nos 73, 795, 982, 1071, 1155, 517, 158, 391, 955, 28, 869, 1153, 821, 822, 599, 244, 823, 410, 726, 876, 29, 474, 1022, 448, 1072, 184, 586, 601, 60… | Amendements n<sup>os</sup><lienAdt id_syceron="2595694"> 73, 795, 982, 1071, 1155</lienAdt>, <lienAdt id_syceron="2595696"> 517</lienAdt>, <lienAdt id_syceron="… | |
| 15130001329229 | L15/debats | 15 | 15130001329172 | 15130001329228 | 1 | Mme Caroline Fiat | 2596399 | |
| 15130001329231 | L15/debats | 15 | 15130001329172 | 15130001329230 | 1 | Amendements nos 1061 rectifié | Amendements n<sup>os</sup><lienAdt id_syceron="2596406"> 1061 rectifié</lienAdt> | |
| 15130001329232 | L15/debats | 15 | 15130001329172 | 15130001329230 | 2 | Sous-amendements nos 1227, 1225, 1232, 1230, 1228, 1226, 1231, 1229, 1237 | Sous-amendements n<sup>os</sup><lienAdt id_syceron="2596583"> 1227, 1225, 1232, 1230, 1228, 1226, 1231, 1229</lienAdt>, <lienAdt id_syceron="2596658"> 1237</lie… | |
| 15130001329234 | L15/debats | 15 | 15130001329172 | 15130001329233 | 1 | Amendement no 111 | Amendement n<sup>o</sup><lienAdt id_syceron="2596243"> 111</lienAdt> | |
| 15130001329236 | L15/debats | 15 | 15130001329172 | 15130001329235 | 1 | Amendement no 959 | Amendement n<sup>o</sup><lienAdt id_syceron="2596252"> 959</lienAdt> | |
| 15130001329237 | L15/debats | 15 | 15130001329172 | 15130001329235 | 2 | Sous-amendement no 1236 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2596254"> 1236</lienAdt> | |
| 15130001329239 | L15/debats | 15 | 15130001329172 | 15130001329238 | 1 | Amendements nos 72, 203, 288, 826, 246, 247, 325, 1145 | Amendements n<sup>os</sup><lienAdt id_syceron="2596263"> 72</lienAdt>, <lienAdt id_syceron="2596270"> 203, 288</lienAdt>, <lienAdt id_syceron="2596272"> 826</li… | |
| 15130001329241 | L15/debats | 15 | 15130001329172 | 15130001329240 | 1 | Amendements nos 248, 382, 1063, 336, 354 | Amendements n<sup>os</sup><lienAdt id_syceron="2596278"> 248, 382</lienAdt>, <lienAdt id_syceron="2596280"> 1063</lienAdt>, <lienAdt id_syceron="2596282"> 336</… | |
| 15130001329243 | L15/debats | 15 | 15130001329172 | 15130001329242 | 1 | Amendement no 1128 | Amendement n<sup>o</sup><lienAdt id_syceron="2596288"> 1128</lienAdt> | |
| 15130001329245 | L15/debats | 15 | 15130001329172 | 15130001329244 | 1 | Amendements nos 71, 827, 249, 917 | Amendements n<sup>os</sup><lienAdt id_syceron="2596297"> 71</lienAdt>, <lienAdt id_syceron="2596299"> 827</lienAdt>, <lienAdt id_syceron="2596301"> 249</lienAdt… | |
| 15130001329247 | L15/debats | 15 | 15130001329172 | 15130001329246 | 1 | M. Paul Molac | 2596327 | |
| 15130001329249 | L15/debats | 15 | 15130001329172 | 15130001329248 | 1 | Amendements nos 964, 348, 347, 696, 698, 349, 350, 343, 1024, 723 | Amendements n<sup>os</sup><lienAdt id_syceron="2596665"> 964</lienAdt>, <lienAdt id_syceron="2596680"> 348</lienAdt>, <lienAdt id_syceron="2596687"> 347, 696, 6… | |
| 15130001329251 | L15/debats | 15 | 15130001329172 | 15130001329250 | 1 | Amendement no 1031 | Amendement n<sup>o</sup><lienAdt id_syceron="2596822"> 1031</lienAdt> | |
| 15130001329253 | L15/debats | 15 | 15130001329172 | 15130001329252 | 1 | Amendements nos 608, 780 | Amendements n<sup>os</sup><lienAdt id_syceron="2596826"> 608, 780</lienAdt> | |
| 15130001329255 | L15/debats | 15 | 15130001329172 | 15130001329254 | 1 | Amendements nos 985, 988, 142, 559, 437, 345, 1000, 159, 237, 353, 267, 323, 344, 438, 473, 1025 | Amendements n<sup>os</sup><lienAdt id_syceron="2596830"> 985, 988</lienAdt>, <lienAdt id_syceron="2596832"> 142, 559</lienAdt>, <lienAdt id_syceron="2596834"> 4… | |
| 15130001329257 | L15/debats | 15 | 15130001329172 | 15130001329256 | 1 | Amendement no 79 | Amendement n<sup>o</sup><lienAdt id_syceron="2596938"> 79</lienAdt> | |
| 15130001329260 | L15/debats | 15 | 15130001329172 | 15130001329259 | 1 | Amendements nos 2, 1 | Amendements n<sup>os</sup><lienAdt id_syceron="2596942"> 2</lienAdt>, <lienAdt id_syceron="2596949"> 1</lienAdt> | |
| 15130001333091 | L15/debats | 15 | 15130001333078 | 15130001333090 | 1 | Mme Sabine Rubin | 2597472 | |
| 15130001333092 | L15/debats | 15 | 15130001333078 | 15130001333090 | 2 | M. Michel Castellani | 2597507 | |
| 15130001333093 | L15/debats | 15 | 15130001333078 | 15130001333090 | 3 | M. Gérard Leseul | 2597518 | |
| 15130001333094 | L15/debats | 15 | 15130001333078 | 15130001333090 | 4 | Mme Zivka Park | 2597534 | |
| 15130001333139 | L15/debats | 15 | 15130001333078 | 15130001333138 | 1 | Amendement no 1 | Amendement n<sup>o</sup><lienAdt id_syceron="2598534"> 1</lienAdt> |