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 |
|---|---|---|---|---|---|---|---|---|
| 15130001692235 | L15/debats | 15 | 15130001692170 | 15130001692234 | 1 | Amendements nos, 607, 688, 778 | Amendements n<sup>os</sup><lienAdt id_syceron="2534614" />, <lienAdt id_syceron="2534616">607</lienAdt>, <lienAdt id_syceron="2534629"> 688</lienAdt>, <lienAdt … | |
| 15130001693395 | L15/debats | 15 | 15130001693390 | 15130001693394 | 1 | Amendements nos208, 229, 496 | Amendements n<sup>os</sup><lienAdt id_syceron="2532999">208, 229, 496</lienAdt> | |
| 15130001693396 | L15/debats | 15 | 15130001693390 | 15130001693394 | 2 | M. Fabien Matras, rapporteur de la commission des lois constitutionnelles, de la législation et de l’administration générale de la République | 2533001 | |
| 15130001693397 | L15/debats | 15 | 15130001693390 | 15130001693394 | 3 | Mme Marlène Schiappa, ministre déléguée chargée de la citoyenneté | 2533004 | |
| 15130001693399 | L15/debats | 15 | 15130001693390 | 15130001693398 | 1 | Amendement no 690 | Amendement n<sup>o</sup><lienAdt id_syceron="2533009"> 690</lienAdt> | |
| 15130001693401 | L15/debats | 15 | 15130001693390 | 15130001693400 | 1 | M. Yannick Favennec-Bécot | 2533013 | |
| 15130001693402 | L15/debats | 15 | 15130001693390 | 15130001693400 | 2 | Amendements nos 758, 759, 558, 602, 628, 660, 691, 774, 757, 760, 761 | Amendements n<sup>os</sup><lienAdt id_syceron="2533017"> 758</lienAdt>, <lienAdt id_syceron="2533029"> 759</lienAdt>, <lienAdt id_syceron="2533033"> 558</lienAd… | |
| 15130001693404 | L15/debats | 15 | 15130001693390 | 15130001693403 | 1 | Amendements nos 140, 227, 262, 40, 6, 192, 226, 329, 499 | Amendements n<sup>os</sup><lienAdt id_syceron="2533116"> 140</lienAdt>, <lienAdt id_syceron="2533363">227, 262</lienAdt>, <lienAdt id_syceron="2533364"> 40</lie… | |
| 15130001693406 | L15/debats | 15 | 15130001693390 | 15130001693405 | 1 | M. David Corceiro | 2533130 | |
| 15130001693407 | L15/debats | 15 | 15130001693390 | 15130001693405 | 2 | Amendements nos 15, 692 | Amendements n<sup>os</sup><lienAdt id_syceron="2533135"> 15</lienAdt>, <lienAdt id_syceron="2533137"> 692</lienAdt> | |
| 15130001693409 | L15/debats | 15 | 15130001693390 | 15130001693408 | 1 | Amendements nos 17, 209, 228, 331, 497 | Amendements n<sup>os</sup><lienAdt id_syceron="2533141"> 17</lienAdt>, <lienAdt id_syceron="2533460">209, 228</lienAdt>, <lienAdt id_syceron="2533144"> 331</lie… | |
| 15130001693411 | L15/debats | 15 | 15130001693390 | 15130001693410 | 1 | Amendement no 584 | Amendement n<sup>o</sup><lienAdt id_syceron="2533153"> 584</lienAdt> | |
| 15130001693413 | L15/debats | 15 | 15130001693390 | 15130001693412 | 1 | Amendements nos 697, 698, 699, 700, 701 | Amendements n<sup>os</sup><lienAdt id_syceron="2533538"> 697, 698</lienAdt>, <lienAdt id_syceron="2533168"> 699</lienAdt>, <lienAdt id_syceron="2533540"> 700, 7… | |
| 15130001693415 | L15/debats | 15 | 15130001693390 | 15130001693414 | 1 | Amendements nos422, 444, 462, 705, 704, 703, 706, 702 | Amendements n<sup>os</sup><lienAdt id_syceron="2533542">422, 444, 462</lienAdt>, <lienAdt id_syceron="2533549"> 705</lienAdt>, <lienAdt id_syceron="2533551"> 70… | |
| 15130001693417 | L15/debats | 15 | 15130001693390 | 15130001693416 | 1 | Amendement no707 rectifié, 47, 495 | Amendement n<sup>o</sup><lienAdt id_syceron="2533555">707 rectifié</lienAdt>, <lienAdt id_syceron="2533557">47</lienAdt>, <lienAdt id_syceron="2533560"> 495</li… | |
| 15130001693419 | L15/debats | 15 | 15130001693390 | 15130001693418 | 1 | Amendements nos 3, 18, 45, 173, 202, 332, 494, 672, 745, 524 | Amendements n<sup>os</sup><lienAdt id_syceron="2533570"> 3</lienAdt>, <lienAdt id_syceron="2533572"> 18</lienAdt>, <lienAdt id_syceron="2533574">45, 173, 202</l… | |
| 15130001693421 | L15/debats | 15 | 15130001693390 | 15130001693420 | 1 | M. André Chassaigne | 2533610 | |
| 15130001693422 | L15/debats | 15 | 15130001693390 | 15130001693420 | 2 | Mme Emmanuelle Anthoine | 2533616 | |
| 15130001693423 | L15/debats | 15 | 15130001693390 | 15130001693420 | 3 | M. Michel Castellani | 2533621 | |
| 15130001693424 | L15/debats | 15 | 15130001693390 | 15130001693420 | 4 | Mme Caroline Fiat | 2533624 | |
| 15130001693425 | L15/debats | 15 | 15130001693390 | 15130001693420 | 5 | Amendements nos 480, 770, 708, 709 | Amendements n<sup>os</sup><lienAdt id_syceron="2533724"> 480</lienAdt>, <lienAdt id_syceron="2533728"> 770</lienAdt>, <lienAdt id_syceron="2533731"> 708, 709</l… | |
| 15130001693427 | L15/debats | 15 | 15130001693390 | 15130001693426 | 1 | Amendements nos 134, 204, 125 | Amendements n<sup>os</sup><lienAdt id_syceron="2534833"> 134, 204</lienAdt>, <lienAdt id_syceron="2533737"> 125</lienAdt> | |
| 15130001693429 | L15/debats | 15 | 15130001693390 | 15130001693428 | 1 | Amendements nos 181, 207, 231, 493, 674, 486, 120, 575, 151, 270, 617 , 245, 119, 746, 565, 582, 601, 625, 651, 710, 776, 186 rectifié | Amendements n<sup>os</sup><lienAdt id_syceron="2533744"> 181</lienAdt>, <lienAdt id_syceron="2533746">207, 231, 493</lienAdt>, <lienAdt id_syceron="2533747"> 67… | |
| 15130001693431 | L15/debats | 15 | 15130001693390 | 15130001693430 | 1 | Amendements nos 454, 711, 265, 278, 269, 288, 712, 232, 643, 713, 644, 714 | Amendements n<sup>os</sup><lienAdt id_syceron="2534072"> 454</lienAdt>, <lienAdt id_syceron="2534076"> 711</lienAdt>, <lienAdt id_syceron="2534078"> 265, 278</l… | |
| 15130001693433 | L15/debats | 15 | 15130001693390 | 15130001693432 | 1 | Amendements nos 20, 205, 233, 334 | Amendements n<sup>os</sup><lienAdt id_syceron="2534106"> 20</lienAdt>, <lienAdt id_syceron="2534108"> 205, 233</lienAdt>, <lienAdt id_syceron="2534109"> 334</li… | |
| 15130001693435 | L15/debats | 15 | 15130001693390 | 15130001693434 | 1 | Mme Nicole Dubré-Chirat | 2534124 | |
| 15130001693436 | L15/debats | 15 | 15130001693390 | 15130001693434 | 2 | Mme Emmanuelle Anthoine | 2534128 | |
| 15130001693438 | L15/debats | 15 | 15130001693390 | 15130001693437 | 1 | Amendement no 409 | Amendement n<sup>o</sup><lienAdt id_syceron="2534133"> 409</lienAdt> | |
| 15130001693440 | L15/debats | 15 | 15130001693390 | 15130001693439 | 1 | Amendement no 585 | Amendement n<sup>o</sup><lienAdt id_syceron="2534243"> 585</lienAdt> | |
| 15130001693442 | L15/debats | 15 | 15130001693390 | 15130001693441 | 1 | Amendements nos 23, 206, 234, 335, 622, 775, 525, 604 | Amendements n<sup>os</sup><lienAdt id_syceron="2534252"> 23</lienAdt>, <lienAdt id_syceron="2534254"> 206, 234, 335, 622</lienAdt>, <lienAdt id_syceron="2534255… | |
| 15130001693444 | L15/debats | 15 | 15130001693390 | 15130001693443 | 1 | Amendement no 586 | Amendement n<sup>o</sup><lienAdt id_syceron="2534282"> 586</lienAdt> | |
| 15130001693446 | L15/debats | 15 | 15130001693390 | 15130001693445 | 1 | Amendement no 587 | Amendement n<sup>o</sup><lienAdt id_syceron="2534288"> 587</lienAdt> | |
| 15130001693448 | L15/debats | 15 | 15130001693390 | 15130001693447 | 1 | Amendements nos 687, 112, 689 | Amendements n<sup>os</sup><lienAdt id_syceron="2534296"> 687</lienAdt>, <lienAdt id_syceron="2534298"> 112</lienAdt>, <lienAdt id_syceron="2534300"> 689</lienAd… | |
| 15130001693450 | L15/debats | 15 | 15130001693390 | 15130001693449 | 1 | Amendement no534 | Amendement n<sup>o</sup><lienAdt id_syceron="2534304">534</lienAdt> | |
| 15130001693451 | L15/debats | 15 | 15130001693390 | 15130001693449 | 2 | Sous-amendement no785 | Sous-amendement n<sup>o</sup><lienAdt id_syceron="2534555">785</lienAdt> | |
| 15130001693453 | L15/debats | 15 | 15130001693390 | 15130001693452 | 1 | Amendements nos 600, 783 | Amendements n<sup>os</sup><lienAdt id_syceron="2534569"> 600</lienAdt>, <lienAdt id_syceron="2534573"> 783</lienAdt> | |
| 15130001693455 | L15/debats | 15 | 15130001693390 | 15130001693454 | 1 | Amendements nos 21, 141, 264, 336, 749, 777, 779, 557 rectifié, 538, 541 | Amendements n<sup>os</sup><lienAdt id_syceron="2534577"> 21</lienAdt>, <lienAdt id_syceron="2534579"> 141</lienAdt>, <lienAdt id_syceron="2534581"> 264</lienAdt… | |
| 15130001693457 | L15/debats | 15 | 15130001693390 | 15130001693456 | 1 | M. Pierre Morel-À-L’Huissier | 2534695 | |
| 15130001693458 | L15/debats | 15 | 15130001693390 | 15130001693456 | 2 | Mme Caroline Janvier | 2534699 | |
| 15130001693459 | L15/debats | 15 | 15130001693390 | 15130001693456 | 3 | Amendements nos 101, 491, 162, 407, 768, 693, 725 | Amendements n<sup>os</sup><lienAdt id_syceron="2534701"> 101</lienAdt>, <lienAdt id_syceron="2534704"> 491</lienAdt>, <lienAdt id_syceron="2534705"> 162</lienAd… | |
| 15130001693461 | L15/debats | 15 | 15130001693390 | 15130001693460 | 1 | Amendements nos 556, 9, 22, 143, 212, 235, 623, 752, 597, 753 | Amendements n<sup>os</sup><lienAdt id_syceron="2534752"> 556</lienAdt>, <lienAdt id_syceron="2534762"> 9</lienAdt>, <lienAdt id_syceron="2534764"> 22</lienAdt>,… | |
| 15130001693463 | L15/debats | 15 | 15130001693390 | 15130001693462 | 1 | Mme Huguette Tiegna | 2534386 | |
| 15130001693464 | L15/debats | 15 | 15130001693390 | 15130001693462 | 2 | Mme Frédérique Meunier | 2534390 | |
| 15130001693465 | L15/debats | 15 | 15130001693390 | 15130001693462 | 3 | Amendements nos 406, 382, 427, , 412, 629, 236, 640, 405, 665, 647, 666, 429, 430, 431, 52, 82, 166, 191, 305, 529, 598, 630, 762, 43, 102, 103, 108 | Amendements n<sup>os</sup><lienAdt id_syceron="2534391"> 406</lienAdt>, <lienAdt id_syceron="2534408"> 382</lienAdt>, <lienAdt id_syceron="2534414"> 427</lienAd… | |
| 15130001693467 | L15/debats | 15 | 15130001693390 | 15130001693466 | 1 | Amendements nos 10, 174, 200, 237, 279 | Amendements n<sup>os</sup><lienAdt id_syceron="2533328"> 10, 174, 200, 237, 279</lienAdt> | |
| 15130001693469 | L15/debats | 15 | 15130001693390 | 15130001693468 | 1 | Mme Marie-Christine Verdier-Jouclas | 2533332 | |
| 15130001693470 | L15/debats | 15 | 15130001693390 | 15130001693468 | 2 | Amendements nos 4, 24, 48, 163, 176, 214, 238, 450, 481, 490, 631, 93, 99, 95, 94, 566, 432, 578, 433, 435, 567, 276 | Amendements n<sup>os</sup><lienAdt id_syceron="2533334"> 4, 24, 48, 163, 176, 214, 238, 450, 481, 490, 631</lienAdt>, <lienAdt id_syceron="2533336"> 93, 99, 95,… | |
| 15130001693472 | L15/debats | 15 | 15130001693390 | 15130001693471 | 1 | Amendements nos 339, 25, 44, 67, 239 | Amendements n<sup>os</sup><lienAdt id_syceron="2533379"> 339, 25, 44, 67, 239</lienAdt> | |
| 15130001693474 | L15/debats | 15 | 15130001693390 | 15130001693473 | 1 | Amendements nos 646, 240, 340, 127, 247, 289, 298 | Amendements n<sup>os</sup><lienAdt id_syceron="2533387"> 646</lienAdt>, <lienAdt id_syceron="2533389"> 240, 340, 127</lienAdt>, <lienAdt id_syceron="2533393"> 2… | |
| 15130001693476 | L15/debats | 15 | 15130001693390 | 15130001693475 | 1 | Amendements nos 248, 290 | Amendements n<sup>os</sup><lienAdt id_syceron="2533401"> 248, 290</lienAdt> |