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 |
|---|---|---|---|---|---|---|---|---|
| 14060000038144 | L14/dossiers | 14 | 14060000038141 | 14060000038141 | 1 | PO419610 | True | |
| 14060000038150 | L14/dossiers | 14 | 14060000038148 | 14060000038148 | 1 | PO419610 | True | |
| 14060000038161 | L14/dossiers | 14 | 14060000038159 | 14060000038159 | 1 | PO420120 | True | |
| 14060000038192 | L14/dossiers | 14 | 14060000038162 | 14060000038162 | 1 | PO419604 | True | |
| 14060000038229 | L14/dossiers | 14 | 14060000038200 | 14060000038200 | 1 | PO419604 | True | |
| 14060000038238 | L14/dossiers | 14 | 14060000038236 | 14060000038236 | 1 | PO419604 | True | |
| 14060000038241 | L14/dossiers | 14 | 14060000038239 | 14060000038239 | 1 | PO420120 | True | |
| 14060000038247 | L14/dossiers | 14 | 14060000038245 | 14060000038245 | 1 | PO419604 | True | |
| 14060000038310 | L14/dossiers | 14 | 14060000038248 | 14060000038248 | 1 | PO420120 | True | |
| 14060000038430 | L14/dossiers | 14 | 14060000038341 | 14060000038341 | 1 | PO419604 | True | |
| 14060000038507 | L14/dossiers | 14 | 14060000038431 | 14060000038431 | 1 | PO59048 | True | |
| 14060000038521 | L14/dossiers | 14 | 14060000038508 | 14060000038508 | 1 | PO420120 | True | |
| 14060000038579 | L14/dossiers | 14 | 14060000038522 | 14060000038522 | 1 | PO59051 | True | |
| 14060000038608 | L14/dossiers | 14 | 14060000038597 | 14060000038597 | 1 | PO420120 | True | |
| 14060000038612 | L14/dossiers | 14 | 14060000038609 | 14060000038609 | 1 | PO59048 | True | |
| 14060000038617 | L14/dossiers | 14 | 14060000038615 | 14060000038615 | 1 | PO59048 | True | |
| 14060000038678 | L14/dossiers | 14 | 14060000038632 | 14060000038632 | 1 | PO419610 | True | |
| 14060000038708 | L14/dossiers | 14 | 14060000038696 | 14060000038696 | 1 | PO59051 | True | |
| 14060000038751 | L14/dossiers | 14 | 14060000038749 | 14060000038749 | 1 | PO420120 | True | |
| 14060000038766 | L14/dossiers | 14 | 14060000038764 | 14060000038764 | 1 | PO420120 | True | |
| 14060000038772 | L14/dossiers | 14 | 14060000038769 | 14060000038769 | 1 | PO420120 | True | |
| 14060000038820 | L14/dossiers | 14 | 14060000038817 | 14060000038817 | 1 | PO59048 | True | |
| 14060000038829 | L14/dossiers | 14 | 14060000038826 | 14060000038826 | 1 | PO59047 | True | |
| 14060000038897 | L14/dossiers | 14 | 14060000038841 | 14060000038841 | 1 | PO59051 | True | |
| 14060000038900 | L14/dossiers | 14 | 14060000038898 | 14060000038898 | 1 | PO59048 | True | |
| 14060000038906 | L14/dossiers | 14 | 14060000038903 | 14060000038903 | 1 | PO59046 | True | |
| 14060000038907 | L14/dossiers | 14 | 14060000038903 | 14060000038903 | 2 | PO420120 | True | |
| 14060000038908 | L14/dossiers | 14 | 14060000038903 | 14060000038903 | 3 | PO59051 | True | |
| 14060000038909 | L14/dossiers | 14 | 14060000038903 | 14060000038903 | 4 | PO419865 | True | |
| 14060000038910 | L14/dossiers | 14 | 14060000038903 | 14060000038903 | 5 | PO419610 | True | |
| 14060000038911 | L14/dossiers | 14 | 14060000038903 | 14060000038903 | 6 | PO419604 | True | |
| 14060000038912 | L14/dossiers | 14 | 14060000038903 | 14060000038903 | 7 | PO59047 | True | |
| 14060000038913 | L14/dossiers | 14 | 14060000038903 | 14060000038903 | 8 | PO59048 | True | |
| 14060000038916 | L14/dossiers | 14 | 14060000038914 | 14060000038914 | 1 | PO59048 | True | |
| 14060000039240 | L14/dossiers | 14 | 14060000039127 | 14060000039127 | 1 | PO59051 | True | |
| 14060000039485 | L14/dossiers | 14 | 14060000039428 | 14060000039428 | 1 | PO59051 | True | |
| 14060000039491 | L14/dossiers | 14 | 14060000039488 | 14060000039488 | 1 | PO420120 | True | |
| 14060000039500 | L14/dossiers | 14 | 14060000039497 | 14060000039497 | 1 | PO420120 | True | |
| 14060000039508 | L14/dossiers | 14 | 14060000039506 | 14060000039506 | 1 | PO420120 | True | |
| 14060000039511 | L14/dossiers | 14 | 14060000039509 | 14060000039509 | 1 | PO419610 | True | |
| 14060000039514 | L14/dossiers | 14 | 14060000039512 | 14060000039512 | 1 | PO59051 | True | |
| 14060000039517 | L14/dossiers | 14 | 14060000039515 | 14060000039515 | 1 | PO59051 | True | |
| 14060000039540 | L14/dossiers | 14 | 14060000039529 | 14060000039529 | 1 | PO59051 | True | |
| 14060000039552 | L14/dossiers | 14 | 14060000039550 | 14060000039550 | 1 | PO419604 | True | |
| 14060000039560 | L14/dossiers | 14 | 14060000039558 | 14060000039558 | 1 | PO59051 | True | |
| 14060000039576 | L14/dossiers | 14 | 14060000039573 | 14060000039573 | 1 | PO59046 | True | |
| 14060000039577 | L14/dossiers | 14 | 14060000039573 | 14060000039573 | 2 | PO59047 | True | |
| 14060000039617 | L14/dossiers | 14 | 14060000039594 | 14060000039594 | 1 | PO419610 | True | |
| 14060000039621 | L14/dossiers | 14 | 14060000039618 | 14060000039618 | 1 | PO419610 | True | |
| 14060000039627 | L14/dossiers | 14 | 14060000039625 | 14060000039625 | 1 | PO59046 | True |