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 |
|---|---|---|---|---|---|---|---|---|
| 15060000006169 | L15/dossiers | 15 | 15060000006113 | 15060000006113 | 1 | PO59051 | True | |
| 15060000006186 | L15/dossiers | 15 | 15060000006170 | 15060000006170 | 1 | PO419604 | True | |
| 15060000006203 | L15/dossiers | 15 | 15060000006187 | 15060000006187 | 1 | PO59051 | True | |
| 15060000006245 | L15/dossiers | 15 | 15060000006204 | 15060000006204 | 1 | PO59051 | True | |
| 15060000006268 | L15/dossiers | 15 | 15060000006246 | 15060000006246 | 1 | PO59051 | True | |
| 15060000006288 | L15/dossiers | 15 | 15060000006269 | 15060000006269 | 1 | PO420120 | True | |
| 15060000006322 | L15/dossiers | 15 | 15060000006289 | 15060000006289 | 1 | PO59051 | True | |
| 15060000006400 | L15/dossiers | 15 | 15060000006323 | 15060000006323 | 1 | PO420120 | True | |
| 15060000006408 | L15/dossiers | 15 | 15060000006401 | 15060000006401 | 1 | PO59051 | True | |
| 15060000006411 | L15/dossiers | 15 | 15060000006409 | 15060000006409 | 1 | PO59051 | True | |
| 15060000006424 | L15/dossiers | 15 | 15060000006412 | 15060000006412 | 1 | PO59051 | True | |
| 15060000006443 | L15/dossiers | 15 | 15060000006425 | 15060000006425 | 1 | PO59051 | True | |
| 15060000006458 | L15/dossiers | 15 | 15060000006444 | 15060000006444 | 1 | PO59051 | True | |
| 15060000006474 | L15/dossiers | 15 | 15060000006459 | 15060000006459 | 1 | PO59051 | True | |
| 15060000006486 | L15/dossiers | 15 | 15060000006475 | 15060000006475 | 1 | PO420120 | True | |
| 15060000006502 | L15/dossiers | 15 | 15060000006487 | 15060000006487 | 1 | PO419865 | True | |
| 15060000006513 | L15/dossiers | 15 | 15060000006503 | 15060000006503 | 1 | PO419865 | True | |
| 15060000006524 | L15/dossiers | 15 | 15060000006514 | 15060000006514 | 1 | PO59051 | True | |
| 15060000006535 | L15/dossiers | 15 | 15060000006525 | 15060000006525 | 1 | PO420120 | True | |
| 15060000006544 | L15/dossiers | 15 | 15060000006536 | 15060000006536 | 1 | PO420120 | True | |
| 15060000006631 | L15/dossiers | 15 | 15060000006545 | 15060000006545 | 1 | PO420120 | True | |
| 15060000006634 | L15/dossiers | 15 | 15060000006632 | 15060000006632 | 1 | PO420120 | True | |
| 15060000006661 | L15/dossiers | 15 | 15060000006635 | 15060000006635 | 1 | PO420120 | True | |
| 15060000006695 | L15/dossiers | 15 | 15060000006662 | 15060000006662 | 1 | PO59051 | True | |
| 15060000006701 | L15/dossiers | 15 | 15060000006696 | 15060000006696 | 1 | PO59051 | True | |
| 15060000006735 | L15/dossiers | 15 | 15060000006702 | 15060000006702 | 1 | PO59051 | True | |
| 15060000006768 | L15/dossiers | 15 | 15060000006736 | 15060000006736 | 1 | PO420120 | True | |
| 15060000006781 | L15/dossiers | 15 | 15060000006769 | 15060000006769 | 1 | PO59046 | True | |
| 15060000006800 | L15/dossiers | 15 | 15060000006782 | 15060000006782 | 1 | PO59051 | True | |
| 15060000006821 | L15/dossiers | 15 | 15060000006801 | 15060000006801 | 1 | PO59051 | True | |
| 15060000006824 | L15/dossiers | 15 | 15060000006822 | 15060000006822 | 1 | PO59051 | True | |
| 15060000006864 | L15/dossiers | 15 | 15060000006825 | 15060000006825 | 1 | PO59051 | True | |
| 15060000006882 | L15/dossiers | 15 | 15060000006865 | 15060000006865 | 1 | PO420120 | True | |
| 15060000006885 | L15/dossiers | 15 | 15060000006883 | 15060000006883 | 1 | PO419865 | True | |
| 15060000006888 | L15/dossiers | 15 | 15060000006886 | 15060000006886 | 1 | PO59051 | True | |
| 15060000006908 | L15/dossiers | 15 | 15060000006889 | 15060000006889 | 1 | PO420120 | True | |
| 15060000006927 | L15/dossiers | 15 | 15060000006909 | 15060000006909 | 1 | PO420120 | True | |
| 15060000006973 | L15/dossiers | 15 | 15060000006928 | 15060000006928 | 1 | PO420120 | True | |
| 15060000007021 | L15/dossiers | 15 | 15060000006974 | 15060000006974 | 1 | PO419604 | True | |
| 15060000007040 | L15/dossiers | 15 | 15060000007022 | 15060000007022 | 1 | PO59051 | True | |
| 15060000007080 | L15/dossiers | 15 | 15060000007041 | 15060000007041 | 1 | PO59051 | True | |
| 15060000007090 | L15/dossiers | 15 | 15060000007081 | 15060000007081 | 1 | PO59051 | True | |
| 15060000007126 | L15/dossiers | 15 | 15060000007091 | 15060000007091 | 1 | PO59051 | True | |
| 15060000007170 | L15/dossiers | 15 | 15060000007127 | 15060000007127 | 1 | PO419610 | True | |
| 15060000007530 | L15/dossiers | 15 | 15060000007171 | 15060000007171 | 1 | PO59051 | True | |
| 15060000007577 | L15/dossiers | 15 | 15060000007531 | 15060000007531 | 1 | PO59051 | True | |
| 15060000007580 | L15/dossiers | 15 | 15060000007578 | 15060000007578 | 1 | PO59051 | True | |
| 15060000007583 | L15/dossiers | 15 | 15060000007581 | 15060000007581 | 1 | PO59051 | True | |
| 15060000007586 | L15/dossiers | 15 | 15060000007584 | 15060000007584 | 1 | PO59051 | True | |
| 15060000007613 | L15/dossiers | 15 | 15060000007587 | 15060000007587 | 1 | PO419610 | True |