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 |
|---|---|---|---|---|---|---|---|---|
| 14060000027465 | L14/dossiers | 14 | 14060000027462 | 14060000027462 | 1 | PO59048 | True | |
| 14060000027479 | L14/dossiers | 14 | 14060000027466 | 14060000027466 | 1 | PO419610 | True | |
| 14060000027542 | L14/dossiers | 14 | 14060000027480 | 14060000027480 | 1 | PO59051 | True | |
| 14060000027617 | L14/dossiers | 14 | 14060000027614 | 14060000027614 | 1 | PO59051 | True | |
| 14060000027620 | L14/dossiers | 14 | 14060000027618 | 14060000027618 | 1 | PO59051 | True | |
| 14060000027642 | L14/dossiers | 14 | 14060000027639 | 14060000027639 | 1 | PO59051 | True | |
| 14060000027698 | L14/dossiers | 14 | 14060000027643 | 14060000027643 | 1 | PO59051 | True | |
| 14060000027704 | L14/dossiers | 14 | 14060000027701 | 14060000027701 | 1 | PO59047 | True | |
| 14060000027716 | L14/dossiers | 14 | 14060000027713 | 14060000027713 | 1 | PO59047 | True | |
| 14060000027727 | L14/dossiers | 14 | 14060000027725 | 14060000027725 | 1 | PO59051 | True | |
| 14060000027730 | L14/dossiers | 14 | 14060000027728 | 14060000027728 | 1 | PO59047 | True | |
| 14060000027840 | L14/dossiers | 14 | 14060000027837 | 14060000027837 | 1 | PO59051 | True | |
| 14060000027843 | L14/dossiers | 14 | 14060000027841 | 14060000027841 | 1 | PO59051 | True | |
| 14060000027913 | L14/dossiers | 14 | 14060000027896 | 14060000027896 | 1 | PO419604 | True | |
| 14060000027930 | L14/dossiers | 14 | 14060000027928 | 14060000027928 | 1 | PO419604 | True | |
| 14060000027933 | L14/dossiers | 14 | 14060000027931 | 14060000027931 | 1 | PO59051 | True | |
| 14060000027937 | L14/dossiers | 14 | 14060000027934 | 14060000027934 | 1 | PO59051 | True | |
| 14060000027943 | L14/dossiers | 14 | 14060000027940 | 14060000027940 | 1 | PO59051 | True | |
| 14060000027948 | L14/dossiers | 14 | 14060000027946 | 14060000027946 | 1 | PO59051 | True | |
| 14060000027954 | L14/dossiers | 14 | 14060000027952 | 14060000027952 | 1 | PO59051 | True | |
| 14060000027980 | L14/dossiers | 14 | 14060000027978 | 14060000027978 | 1 | PO59046 | True | |
| 14060000028272 | L14/dossiers | 14 | 14060000027984 | 14060000027984 | 1 | PO419604 | True | |
| 14060000028275 | L14/dossiers | 14 | 14060000028273 | 14060000028273 | 1 | PO59051 | True | |
| 14060000028331 | L14/dossiers | 14 | 14060000028279 | 14060000028279 | 1 | PO59046 | True | |
| 14060000028338 | L14/dossiers | 14 | 14060000028332 | 14060000028332 | 1 | PO59051 | True | |
| 14060000028358 | L14/dossiers | 14 | 14060000028356 | 14060000028356 | 1 | PO59051 | True | |
| 14060000028389 | L14/dossiers | 14 | 14060000028386 | 14060000028386 | 1 | PO59051 | True | |
| 14060000028392 | L14/dossiers | 14 | 14060000028390 | 14060000028390 | 1 | PO420120 | True | |
| 14060000028396 | L14/dossiers | 14 | 14060000028393 | 14060000028393 | 1 | PO420120 | True | |
| 14060000028399 | L14/dossiers | 14 | 14060000028397 | 14060000028397 | 1 | PO59051 | True | |
| 14060000028415 | L14/dossiers | 14 | 14060000028413 | 14060000028413 | 1 | PO59051 | True | |
| 14060000028457 | L14/dossiers | 14 | 14060000028416 | 14060000028416 | 1 | PO419610 | True | |
| 14060000028477 | L14/dossiers | 14 | 14060000028458 | 14060000028458 | 1 | PO419610 | True | |
| 14060000028480 | L14/dossiers | 14 | 14060000028478 | 14060000028478 | 1 | PO59051 | True | |
| 14060000028483 | L14/dossiers | 14 | 14060000028481 | 14060000028481 | 1 | PO59047 | True | |
| 14060000028565 | L14/dossiers | 14 | 14060000028495 | 14060000028495 | 1 | PO59048 | True | |
| 14060000028637 | L14/dossiers | 14 | 14060000028566 | 14060000028566 | 1 | PO59046 | True | |
| 14060000028643 | L14/dossiers | 14 | 14060000028641 | 14060000028641 | 1 | PO59047 | True | |
| 14060000028684 | L14/dossiers | 14 | 14060000028673 | 14060000028673 | 1 | PO420120 | True | |
| 14060000028727 | L14/dossiers | 14 | 14060000028685 | 14060000028685 | 1 | PO419610 | True | |
| 14060000028732 | L14/dossiers | 14 | 14060000028728 | 14060000028728 | 1 | PO59051 | True | |
| 14060000028739 | L14/dossiers | 14 | 14060000028737 | 14060000028737 | 1 | PO419604 | True | |
| 14060000028758 | L14/dossiers | 14 | 14060000028740 | 14060000028740 | 1 | PO59048 | True | |
| 14060000028764 | L14/dossiers | 14 | 14060000028759 | 14060000028759 | 1 | PO419865 | True | |
| 14060000028816 | L14/dossiers | 14 | 14060000028765 | 14060000028765 | 1 | PO419610 | True | |
| 14060000028859 | L14/dossiers | 14 | 14060000028817 | 14060000028817 | 1 | PO419865 | True | |
| 14060000028864 | L14/dossiers | 14 | 14060000028860 | 14060000028860 | 1 | PO59051 | True | |
| 14060000028868 | L14/dossiers | 14 | 14060000028865 | 14060000028865 | 1 | PO59051 | True | |
| 14060000028914 | L14/dossiers | 14 | 14060000028872 | 14060000028872 | 1 | PO419604 | True | |
| 14060000028917 | L14/dossiers | 14 | 14060000028915 | 14060000028915 | 1 | PO59051 | True |