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 |
|---|---|---|---|---|---|---|---|---|
| 17060000039842 | L17/dossiers | 17 | 17060000039807 | 17060000039807 | 1 | PO420120 | True | |
| 17060000039845 | L17/dossiers | 17 | 17060000039843 | 17060000039843 | 1 | PO419865 | True | |
| 17060000039848 | L17/dossiers | 17 | 17060000039846 | 17060000039846 | 1 | PO419604 | True | |
| 17060000039851 | L17/dossiers | 17 | 17060000039849 | 17060000039849 | 1 | PO59051 | True | |
| 17060000039854 | L17/dossiers | 17 | 17060000039852 | 17060000039852 | 1 | PO59051 | True | |
| 17060000039857 | L17/dossiers | 17 | 17060000039855 | 17060000039855 | 1 | PO59051 | True | |
| 17060000039860 | L17/dossiers | 17 | 17060000039858 | 17060000039858 | 1 | PO59051 | True | |
| 17060000039863 | L17/dossiers | 17 | 17060000039861 | 17060000039861 | 1 | PO420120 | True | |
| 17060000039866 | L17/dossiers | 17 | 17060000039864 | 17060000039864 | 1 | PO59048 | True | |
| 17060000039869 | L17/dossiers | 17 | 17060000039867 | 17060000039867 | 1 | PO419610 | True | |
| 17060000039872 | L17/dossiers | 17 | 17060000039870 | 17060000039870 | 1 | PO59051 | True | |
| 17060000039875 | L17/dossiers | 17 | 17060000039873 | 17060000039873 | 1 | PO419865 | True | |
| 17060000039903 | L17/dossiers | 17 | 17060000039876 | 17060000039876 | 1 | PO59051 | True | |
| 17060000039906 | L17/dossiers | 17 | 17060000039904 | 17060000039904 | 1 | PO419604 | True | |
| 17060000039909 | L17/dossiers | 17 | 17060000039907 | 17060000039907 | 1 | PO419604 | True | |
| 17060000039912 | L17/dossiers | 17 | 17060000039910 | 17060000039910 | 1 | PO59051 | True | |
| 17060000039915 | L17/dossiers | 17 | 17060000039913 | 17060000039913 | 1 | PO419610 | True | |
| 17060000039932 | L17/dossiers | 17 | 17060000039916 | 17060000039916 | 1 | PO59048 | True | |
| 17060000040005 | L17/dossiers | 17 | 17060000039933 | 17060000039933 | 1 | PO419865 | True | |
| 17060000040031 | L17/dossiers | 17 | 17060000040006 | 17060000040006 | 1 | PO419610 | True | |
| 17060000040034 | L17/dossiers | 17 | 17060000040032 | 17060000040032 | 1 | PO420120 | True | |
| 17060000040044 | L17/dossiers | 17 | 17060000040035 | 17060000040035 | 1 | PO59048 | True | |
| 17060000040059 | L17/dossiers | 17 | 17060000040045 | 17060000040045 | 1 | PO59048 | True | |
| 17060000040080 | L17/dossiers | 17 | 17060000040060 | 17060000040060 | 1 | PO419604 | True | |
| 17060000040114 | L17/dossiers | 17 | 17060000040081 | 17060000040081 | 1 | PO420120 | True | |
| 17060000040187 | L17/dossiers | 17 | 17060000040115 | 17060000040115 | 1 | PO419865 | True | |
| 17060000040316 | L17/dossiers | 17 | 17060000040188 | 17060000040188 | 1 | PO419604 | True | |
| 17060000040339 | L17/dossiers | 17 | 17060000040317 | 17060000040317 | 1 | PO59051 | True | |
| 17060000040348 | L17/dossiers | 17 | 17060000040340 | 17060000040340 | 1 | PO420120 | True | |
| 17060000040456 | L17/dossiers | 17 | 17060000040349 | 17060000040349 | 1 | PO419865 | True | |
| 17060000040459 | L17/dossiers | 17 | 17060000040457 | 17060000040457 | 1 | PO59051 | True | |
| 17060000040462 | L17/dossiers | 17 | 17060000040460 | 17060000040460 | 1 | PO59051 | True | |
| 17060000040465 | L17/dossiers | 17 | 17060000040463 | 17060000040463 | 1 | PO420120 | True | |
| 17060000040468 | L17/dossiers | 17 | 17060000040466 | 17060000040466 | 1 | PO420120 | True | |
| 17060000040471 | L17/dossiers | 17 | 17060000040469 | 17060000040469 | 1 | PO419865 | True | |
| 17060000040472 | L17/dossiers | 17 | 17060000040469 | 17060000040469 | 2 | PO419610 | True | |
| 17060000040569 | L17/dossiers | 17 | 17060000040473 | 17060000040473 | 1 | PO59051 | True | |
| 17060000040632 | L17/dossiers | 17 | 17060000040570 | 17060000040570 | 1 | PO420120 | True | |
| 17060000040669 | L17/dossiers | 17 | 17060000040633 | 17060000040633 | 1 | PO420120 | True | |
| 17060000040736 | L17/dossiers | 17 | 17060000040670 | 17060000040670 | 1 | PO59048 | True | |
| 17060000040799 | L17/dossiers | 17 | 17060000040737 | 17060000040737 | 1 | PO419610 | True | |
| 17060000040867 | L17/dossiers | 17 | 17060000040800 | 17060000040800 | 1 | PO420120 | True | |
| 17060000040900 | L17/dossiers | 17 | 17060000040868 | 17060000040868 | 1 | PO59051 | True | |
| 17060000040979 | L17/dossiers | 17 | 17060000040901 | 17060000040901 | 1 | PO419865 | True | |
| 17060000041107 | L17/dossiers | 17 | 17060000040980 | 17060000040980 | 1 | PO419610 | True | |
| 17060000041127 | L17/dossiers | 17 | 17060000041108 | 17060000041108 | 1 | PO59051 | True | |
| 17060000041204 | L17/dossiers | 17 | 17060000041128 | 17060000041128 | 1 | PO419610 | True | |
| 17060000041280 | L17/dossiers | 17 | 17060000041205 | 17060000041205 | 1 | PO419604 | True | |
| 17060000041352 | L17/dossiers | 17 | 17060000041281 | 17060000041281 | 1 | PO419604 | True | |
| 17060000041413 | L17/dossiers | 17 | 17060000041353 | 17060000041353 | 1 | PO419610 | True |