dossiers.document_commission
Chemin document.depotAmendements.amendementsCommission.commission · présence : L17 47 %, L16 41 %, L15 40 %, L14 40 %
14 026 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 | organe_ref | VARCHAR | document.depotAmendements.amendementsCommission.commission.organeRef · présence : L17 47 %, L16 41 %, L15 40 %, L14 40 % |
| 8 | amendable | BOOLEAN | document.depotAmendements.amendementsCommission.commission.amendable · présence : L17 47 %, L16 41 %, L15 40 %, L14 40 % |
| 9 | date_limite_depot | VARCHAR | document.depotAmendements.amendementsCommission.commission.dateLimiteDepot · présence : L17 47 %, L16 41 %, L15 40 %, L14 40 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | organe_ref | amendable | date_limite_depot |
|---|---|---|---|---|---|---|---|---|
| 14060000007410 | L14/dossiers | 14 | 14060000007407 | 14060000007407 | 1 | PO59047 | True | |
| 14060000007424 | L14/dossiers | 14 | 14060000007421 | 14060000007421 | 1 | PO59051 | True | |
| 14060000007427 | L14/dossiers | 14 | 14060000007425 | 14060000007425 | 1 | PO419604 | True | |
| 14060000007522 | L14/dossiers | 14 | 14060000007431 | 14060000007431 | 1 | PO420120 | True | |
| 14060000007531 | L14/dossiers | 14 | 14060000007529 | 14060000007529 | 1 | PO59047 | True | |
| 14060000007542 | L14/dossiers | 14 | 14060000007540 | 14060000007540 | 1 | PO420120 | True | |
| 14060000007545 | L14/dossiers | 14 | 14060000007543 | 14060000007543 | 1 | PO59051 | True | |
| 14060000007561 | L14/dossiers | 14 | 14060000007558 | 14060000007558 | 1 | PO419865 | True | |
| 14060000007564 | L14/dossiers | 14 | 14060000007562 | 14060000007562 | 1 | PO419865 | True | |
| 14060000007573 | L14/dossiers | 14 | 14060000007570 | 14060000007570 | 1 | PO59051 | True | |
| 14060000007612 | L14/dossiers | 14 | 14060000007609 | 14060000007609 | 1 | PO59051 | True | |
| 14060000007672 | L14/dossiers | 14 | 14060000007613 | 14060000007613 | 1 | PO59051 | True | |
| 14060000007676 | L14/dossiers | 14 | 14060000007673 | 14060000007673 | 1 | PO59051 | True | |
| 14060000007682 | L14/dossiers | 14 | 14060000007680 | 14060000007680 | 1 | PO59047 | True | |
| 14060000007808 | L14/dossiers | 14 | 14060000007806 | 14060000007806 | 1 | PO59051 | True | |
| 14060000007812 | L14/dossiers | 14 | 14060000007809 | 14060000007809 | 1 | PO59051 | True | |
| 14060000007818 | L14/dossiers | 14 | 14060000007815 | 14060000007815 | 1 | PO59051 | True | |
| 14060000007839 | L14/dossiers | 14 | 14060000007836 | 14060000007836 | 1 | PO59047 | True | |
| 14060000007908 | L14/dossiers | 14 | 14060000007848 | 14060000007848 | 1 | PO419610 | True | |
| 14060000007912 | L14/dossiers | 14 | 14060000007909 | 14060000007909 | 1 | PO419610 | True | |
| 14060000007917 | L14/dossiers | 14 | 14060000007913 | 14060000007913 | 1 | PO59051 | True | |
| 14060000007968 | L14/dossiers | 14 | 14060000007918 | 14060000007918 | 1 | PO419865 | True | |
| 14060000008004 | L14/dossiers | 14 | 14060000007969 | 14060000007969 | 1 | PO419604 | True | |
| 14060000008060 | L14/dossiers | 14 | 14060000008005 | 14060000008005 | 1 | PO420120 | True | |
| 14060000008116 | L14/dossiers | 14 | 14060000008070 | 14060000008070 | 1 | PO419604 | True | |
| 14060000008120 | L14/dossiers | 14 | 14060000008117 | 14060000008117 | 1 | PO59051 | True | |
| 14060000008121 | L14/dossiers | 14 | 14060000008117 | 14060000008117 | 2 | PO419604 | True | |
| 14060000008125 | L14/dossiers | 14 | 14060000008122 | 14060000008122 | 1 | PO59051 | True | |
| 14060000008126 | L14/dossiers | 14 | 14060000008122 | 14060000008122 | 2 | PO419604 | True | |
| 14060000008201 | L14/dossiers | 14 | 14060000008135 | 14060000008135 | 1 | PO59051 | True | |
| 14060000008216 | L14/dossiers | 14 | 14060000008214 | 14060000008214 | 1 | PO420120 | True | |
| 14060000008223 | L14/dossiers | 14 | 14060000008220 | 14060000008220 | 1 | PO420120 | True | |
| 14060000008258 | L14/dossiers | 14 | 14060000008226 | 14060000008226 | 1 | PO419865 | True | |
| 14060000008268 | L14/dossiers | 14 | 14060000008266 | 14060000008266 | 1 | PO59048 | True | |
| 14060000008273 | L14/dossiers | 14 | 14060000008271 | 14060000008271 | 1 | PO59048 | True | |
| 14060000008277 | L14/dossiers | 14 | 14060000008274 | 14060000008274 | 1 | PO59048 | True | |
| 14060000008281 | L14/dossiers | 14 | 14060000008278 | 14060000008278 | 1 | PO59048 | True | |
| 14060000008336 | L14/dossiers | 14 | 14060000008334 | 14060000008334 | 1 | PO59051 | True | |
| 14060000008352 | L14/dossiers | 14 | 14060000008337 | 14060000008337 | 1 | PO59051 | True | |
| 14060000008359 | L14/dossiers | 14 | 14060000008356 | 14060000008356 | 1 | PO59051 | True | |
| 14060000008364 | L14/dossiers | 14 | 14060000008362 | 14060000008362 | 1 | PO59051 | True | |
| 14060000008392 | L14/dossiers | 14 | 14060000008390 | 14060000008390 | 1 | PO419610 | True | |
| 14060000008421 | L14/dossiers | 14 | 14060000008419 | 14060000008419 | 1 | PO59051 | True | |
| 14060000008430 | L14/dossiers | 14 | 14060000008428 | 14060000008428 | 1 | PO59046 | True | |
| 14060000008434 | L14/dossiers | 14 | 14060000008431 | 14060000008431 | 1 | PO59046 | True | |
| 14060000008446 | L14/dossiers | 14 | 14060000008444 | 14060000008444 | 1 | PO419604 | True | |
| 14060000008466 | L14/dossiers | 14 | 14060000008447 | 14060000008447 | 1 | PO419604 | True | |
| 14060000008474 | L14/dossiers | 14 | 14060000008467 | 14060000008467 | 1 | PO59051 | True | |
| 14060000008490 | L14/dossiers | 14 | 14060000008486 | 14060000008486 | 1 | PO59051 | True | |
| 14060000008493 | L14/dossiers | 14 | 14060000008491 | 14060000008491 | 1 | PO59051 | True |