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 |
|---|---|---|---|---|---|---|---|---|
| 15130000707443 | L15/debats | 15 | 15130000707338 | 15130000707440 | 3 | Mme Emmanuelle Ménard | 1571622 | |
| 15130000707444 | L15/debats | 15 | 15130000707338 | 15130000707440 | 4 | Mme Véronique Louwagie | 1571669 | |
| 15130000707445 | L15/debats | 15 | 15130000707338 | 15130000707440 | 5 | M. Thibault Bazin | 1571628 | |
| 15130000707446 | L15/debats | 15 | 15130000707338 | 15130000707440 | 6 | M. François Pupponi | 1571631 | |
| 15130000707447 | L15/debats | 15 | 15130000707338 | 15130000707440 | 7 | M. Xavier Roseren | 1571634 | |
| 15130000707448 | L15/debats | 15 | 15130000707338 | 15130000707440 | 8 | M. Gérald Darmanin, ministre | 1571637 | |
| 15130000707449 | L15/debats | 15 | 15130000707338 | 15130000707440 | 9 | M. François Pupponi | 1571641 | |
| 15130000707451 | L15/debats | 15 | 15130000707338 | 15130000707450 | 1 | Amendements nos 280, 304, 464, 477, 566, 1216, 1320 (sous-amendement), 1391 (sous-amendement), 1241 (sous-amendement) | Amendements n<sup>os</sup><lienAdt id_syceron="1571649"> 280</lienAdt>, <lienAdt id_syceron="1571652"> 304</lienAdt>, <lienAdt id_syceron="1571655"> 464</lienAd… | |
| 15130000707453 | L15/debats | 15 | 15130000707338 | 15130000707452 | 1 | Amendement no 1059 | Amendement n<sup>o</sup><lienAdt id_syceron="1572071"> 1059</lienAdt> | |
| 15130000707456 | L15/debats | 15 | 15130000707338 | 15130000707455 | 1 | Amendements nos 1297, 899 | Amendements n<sup>os</sup><lienAdt id_syceron="1572077"> 1297</lienAdt>, <lienAdt id_syceron="1572080"> 899</lienAdt> | |
| 15130000707458 | L15/debats | 15 | 15130000707338 | 15130000707457 | 1 | Amendement no 1417 | Amendement n<sup>o</sup><lienAdt id_syceron="1572085"> 1417</lienAdt> | |
| 15130000707460 | L15/debats | 15 | 15130000707338 | 15130000707459 | 1 | Amendements nos 1427, 900 | Amendements n<sup>os</sup><lienAdt id_syceron="1572089"> 1427</lienAdt>, <lienAdt id_syceron="1572094"> 900</lienAdt> | |
| 15130000707464 | L15/debats | 15 | 15130000707338 | 15130000707463 | 1 | Amendements nos 1378, 807, 730, 725, 727, 723, 724, 820, 1404, 194, 1359, 545, 546, 547, 548, 549, 912, 950, 718, 719, 1361, 726, 729, 1364, 1088, 1362, 465, 49… | Amendements n<sup>os</sup><lienAdt id_syceron="1571735"> 1378</lienAdt>, <lienAdt id_syceron="1571738"> 807</lienAdt>, <lienAdt id_syceron="1571745"> 730</lienA… | |
| 15130000707466 | L15/debats | 15 | 15130000707338 | 15130000707465 | 1 | M. Éric Coquerel | 1572884 | |
| 15130000707467 | L15/debats | 15 | 15130000707338 | 15130000707465 | 2 | M. le président | 1572891 | |
| 15130000707469 | L15/debats | 15 | 15130000707338 | 15130000707468 | 1 | Amendements nos 199, 1363, 298, 296, 299, 720, 721, 722, 728, 1365, 197, 198, 1390, 470, 589, 1282, 561, 1020, 1024, 575, 560, 1389, 355 | Amendements n<sup>os</sup><lienAdt id_syceron="1572903"> 199</lienAdt>, <lienAdt id_syceron="1572907"> 1363</lienAdt>, <lienAdt id_syceron="1573192"> 298</lienA… | |
| 15130000707471 | L15/debats | 15 | 15130000707338 | 15130000707470 | 1 | Amendements nos 1366, 28, 29, 1026, 1367, 1029, 1036, 1031, 301, 302, 303, 1368, 703, 704, 1369, 190, 212, 191 | Amendements n<sup>os</sup><lienAdt id_syceron="1572117"> 1366</lienAdt>, <lienAdt id_syceron="1572119"> 28, 29</lienAdt>, <lienAdt id_syceron="1572124"> 1026</l… | |
| 15130000707472 | L15/debats | 15 | 15130000707338 | 15130000707470 | 2 | Amendements nos 178, 180, 179, 183, 1360, 305 | Amendements n<sup>os</sup><lienAdt id_syceron="1572156"> 178, 180, 179, 183</lienAdt>, <lienAdt id_syceron="1572158"> 1360</lienAdt>, <lienAdt id_syceron="15721… | |
| 15130000707473 | L15/debats | 15 | 15130000707338 | 15130000707470 | 3 | Amendement no 1380 | Amendement n<sup>o</sup><lienAdt id_syceron="1572165"> 1380</lienAdt> | |
| 15130000707474 | L15/debats | 15 | 15130000707338 | 15130000707470 | 4 | Amendements nos 177, 195 | Amendements n<sup>os</sup><lienAdt id_syceron="1572167"> 177, 195</lienAdt> | |
| 15130000707475 | L15/debats | 15 | 15130000707338 | 15130000707470 | 5 | 1572168 | ||
| 15130000707476 | L15/debats | 15 | 15130000707338 | 15130000707470 | 6 | Amendements nos 1379, 307, 551, 911, 1037, 1038, 705, 707 | Amendements n<sup>os</sup><lienAdt id_syceron="1572169"> 1379</lienAdt>, <lienAdt id_syceron="1572171"> 307</lienAdt>, <lienAdt id_syceron="1572173"> 551</lienA… | |
| 15130000707477 | L15/debats | 15 | 15130000707338 | 15130000707470 | 7 | Amendements nos 1022, 1028 | Amendements n<sup>os</sup><lienAdt id_syceron="1572199"> 1022, 1028</lienAdt> | |
| 15130000707478 | L15/debats | 15 | 15130000707338 | 15130000707470 | 8 | Amendement no 706 | Amendement n<sup>o</sup><lienAdt id_syceron="1572201"> 706</lienAdt> | |
| 15130000707479 | L15/debats | 15 | 15130000707338 | 15130000707470 | 9 | Amendement no 503 | Amendement n<sup>o</sup><lienAdt id_syceron="1572203"> 503</lienAdt> | |
| 15130000707480 | L15/debats | 15 | 15130000707338 | 15130000707470 | 10 | Amendements nos 1370, 1039, 1371, 215, 309, 1341, 192, 1382, 1044, 308 | Amendements n<sup>os</sup><lienAdt id_syceron="1572205"> 1370</lienAdt>, <lienAdt id_syceron="1572207"> 1039</lienAdt>, <lienAdt id_syceron="1572210"> 1371</lie… | |
| 15130000707482 | L15/debats | 15 | 15130000707338 | 15130000707481 | 1 | M. Éric Coquerel | 1573451 | |
| 15130000707483 | L15/debats | 15 | 15130000707338 | 15130000707481 | 2 | M. le président | 1573452 | |
| 15130000707485 | L15/debats | 15 | 15130000707338 | 15130000707484 | 1 | Amendements nos433, 446, 1372 | Amendements n<sup>os</sup><lienAdt id_syceron="1573462">433, 446</lienAdt>, <lienAdt id_syceron="1573464"> 1372</lienAdt> | |
| 15130000707487 | L15/debats | 15 | 15130000707338 | 15130000707486 | 1 | M. Sébastien Jumel | 1573470 | |
| 15130000707488 | L15/debats | 15 | 15130000707338 | 15130000707486 | 2 | M. le président | 1573480 | |
| 15130000707490 | L15/debats | 15 | 15130000707338 | 15130000707489 | 1 | Amendements nos 1040, 311, 365, 371, 1041, 1383, 351, 350 | Amendements n<sup>os</sup><lienAdt id_syceron="1573482"> 1040</lienAdt>, <lienAdt id_syceron="1573811"> 311</lienAdt>, <lienAdt id_syceron="1573813"> 365</lienA… | |
| 15130000707492 | L15/debats | 15 | 15130000707338 | 15130000707491 | 1 | Amendements nos 1358, 1283, 1376, 1373, 1043, 1374, 30, 1375, 1045, 1047, 1049, 1050, 1377 | Amendements n<sup>os</sup><lienAdt id_syceron="1573842"> 1358</lienAdt>, <lienAdt id_syceron="1573845"> 1283</lienAdt>, <lienAdt id_syceron="1573848"> 1376</lie… | |
| 15130000707495 | L15/debats | 15 | 15130000707338 | 15130000707494 | 1 | Amendements nos 903, 904 | Amendements n<sup>os</sup><lienAdt id_syceron="1573882"> 903</lienAdt>, <lienAdt id_syceron="1573885"> 904</lienAdt> | |
| 15130000707497 | L15/debats | 15 | 15130000707338 | 15130000707496 | 1 | Amendement no 905 | Amendement n<sup>o</sup><lienAdt id_syceron="1573890"> 905</lienAdt> | |
| 15130000707499 | L15/debats | 15 | 15130000707338 | 15130000707498 | 1 | Amendements nos 906, 697 | Amendements n<sup>os</sup><lienAdt id_syceron="1573895"> 906</lienAdt>, <lienAdt id_syceron="1573897">697</lienAdt> | |
| 15130000707502 | L15/debats | 15 | 15130000707338 | 15130000707501 | 1 | Amendement no 907 | Amendement n<sup>o</sup><lienAdt id_syceron="1573903"> 907</lienAdt> | |
| 15130000707504 | L15/debats | 15 | 15130000707338 | 15130000707503 | 1 | Amendements nos 453, 508 | Amendements n<sup>os</sup><lienAdt id_syceron="1573907"> 453</lienAdt>, <lienAdt id_syceron="1573910"> 508</lienAdt> | |
| 15130000707507 | L15/debats | 15 | 15130000707338 | 15130000707506 | 1 | Amendements nos 1220, 908, 1167, 1343 | Amendements n<sup>os</sup><lienAdt id_syceron="1573917"> 1220, 908, 1167, 1343</lienAdt> | |
| 15130000707509 | L15/debats | 15 | 15130000707338 | 15130000707508 | 1 | Amendement no 909 | Amendement n<sup>o</sup><lienAdt id_syceron="1573922"> 909</lienAdt> | |
| 15130000707513 | L15/debats | 15 | 15130000707338 | 15130000707512 | 1 | Amendement no 910 | Amendement n<sup>o</sup><lienAdt id_syceron="1573932"> 910</lienAdt> | |
| 15130000707516 | L15/debats | 15 | 15130000707338 | 15130000707515 | 1 | Amendements nos913, 1251, 1252 (sous-amendements) | Amendements n<sup>os</sup><lienAdt id_syceron="1573939">913</lienAdt>, <lienAdt id_syceron="1573941"> 1251, 1252 (sous-amendements)</lienAdt> | |
| 15130000707518 | L15/debats | 15 | 15130000707338 | 15130000707517 | 1 | Amendement no 914 | Amendement n<sup>o</sup><lienAdt id_syceron="1573950"> 914</lienAdt> | |
| 15130000707520 | L15/debats | 15 | 15130000707338 | 15130000707519 | 1 | Amendement no 675 | Amendement n<sup>o</sup><lienAdt id_syceron="1573954"> 675</lienAdt> | |
| 15130000707522 | L15/debats | 15 | 15130000707338 | 15130000707521 | 1 | Mme Emmanuelle Ménard | 1573960 | |
| 15130000707523 | L15/debats | 15 | 15130000707338 | 15130000707521 | 2 | Amendement no 915 | Amendement n<sup>o</sup><lienAdt id_syceron="1573962"> 915</lienAdt> | |
| 15130000707526 | L15/debats | 15 | 15130000707338 | 15130000707525 | 1 | Amendement no 916 | Amendement n<sup>o</sup><lienAdt id_syceron="1573972"> 916</lienAdt> | |
| 15130000707528 | L15/debats | 15 | 15130000707338 | 15130000707527 | 1 | Amendements nos 917, 698 | Amendements n<sup>os</sup><lienAdt id_syceron="1573976"> 917</lienAdt>, <lienAdt id_syceron="1573978"> 698</lienAdt> | |
| 15130000707530 | L15/debats | 15 | 15130000707338 | 15130000707529 | 1 | Amendements nos 370, 361, 766, 676, 677 | Amendements n<sup>os</sup><lienAdt id_syceron="1573983"> 370</lienAdt>, <lienAdt id_syceron="1573986"> 361</lienAdt>, <lienAdt id_syceron="1573989"> 766</lienAd… | |
| 15130000707532 | L15/debats | 15 | 15130000707338 | 15130000707531 | 1 | Amendement no 918 | Amendement n<sup>o</sup><lienAdt id_syceron="1573997"> 918</lienAdt> |