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 |
|---|---|---|---|---|---|---|---|---|
| 15060000019467 | L15/dossiers | 15 | 15060000019465 | 15060000019465 | 1 | PO59048 | True | |
| 15060000019508 | L15/dossiers | 15 | 15060000019468 | 15060000019468 | 1 | PO419604 | True | |
| 15060000019547 | L15/dossiers | 15 | 15060000019509 | 15060000019509 | 1 | PO419865 | True | |
| 15060000019580 | L15/dossiers | 15 | 15060000019548 | 15060000019548 | 1 | PO59051 | True | |
| 15060000019597 | L15/dossiers | 15 | 15060000019581 | 15060000019581 | 1 | PO59051 | True | |
| 15060000019600 | L15/dossiers | 15 | 15060000019598 | 15060000019598 | 1 | PO420120 | True | |
| 15060000019613 | L15/dossiers | 15 | 15060000019601 | 15060000019601 | 1 | PO59051 | True | |
| 15060000019654 | L15/dossiers | 15 | 15060000019614 | 15060000019614 | 1 | PO59048 | True | |
| 15060000019696 | L15/dossiers | 15 | 15060000019655 | 15060000019655 | 1 | PO59048 | True | |
| 15060000019699 | L15/dossiers | 15 | 15060000019697 | 15060000019697 | 1 | PO420120 | True | |
| 15060000019734 | L15/dossiers | 15 | 15060000019700 | 15060000019700 | 1 | PO420120 | True | |
| 15060000019737 | L15/dossiers | 15 | 15060000019735 | 15060000019735 | 1 | PO59051 | True | |
| 15060000019738 | L15/dossiers | 15 | 15060000019735 | 15060000019735 | 2 | PO419865 | True | |
| 15060000019739 | L15/dossiers | 15 | 15060000019735 | 15060000019735 | 3 | PO419610 | True | |
| 15060000019742 | L15/dossiers | 15 | 15060000019740 | 15060000019740 | 1 | PO419865 | True | |
| 15060000019743 | L15/dossiers | 15 | 15060000019740 | 15060000019740 | 2 | PO59051 | True | |
| 15060000019746 | L15/dossiers | 15 | 15060000019744 | 15060000019744 | 1 | PO59051 | True | |
| 15060000019749 | L15/dossiers | 15 | 15060000019747 | 15060000019747 | 1 | PO419604 | True | |
| 15060000019768 | L15/dossiers | 15 | 15060000019750 | 15060000019750 | 1 | PO59051 | True | |
| 15060000019774 | L15/dossiers | 15 | 15060000019769 | 15060000019769 | 1 | PO59051 | True | |
| 15060000019827 | L15/dossiers | 15 | 15060000019775 | 15060000019775 | 1 | PO420120 | True | |
| 15060000019882 | L15/dossiers | 15 | 15060000019828 | 15060000019828 | 1 | PO59051 | True | |
| 15060000019909 | L15/dossiers | 15 | 15060000019883 | 15060000019883 | 1 | PO420120 | True | |
| 15060000019912 | L15/dossiers | 15 | 15060000019910 | 15060000019910 | 1 | PO59051 | True | |
| 15060000019921 | L15/dossiers | 15 | 15060000019913 | 15060000019913 | 1 | PO59048 | True | |
| 15060000019960 | L15/dossiers | 15 | 15060000019922 | 15060000019922 | 1 | PO420120 | True | |
| 15060000019963 | L15/dossiers | 15 | 15060000019961 | 15060000019961 | 1 | PO419865 | True | |
| 15060000019992 | L15/dossiers | 15 | 15060000019964 | 15060000019964 | 1 | PO59048 | True | |
| 15060000020029 | L15/dossiers | 15 | 15060000019993 | 15060000019993 | 1 | PO59048 | True | |
| 15060000020044 | L15/dossiers | 15 | 15060000020030 | 15060000020030 | 1 | PO419865 | True | |
| 15060000020152 | L15/dossiers | 15 | 15060000020045 | 15060000020045 | 1 | PO420120 | True | |
| 15060000020171 | L15/dossiers | 15 | 15060000020153 | 15060000020153 | 1 | PO420120 | True | |
| 15060000020174 | L15/dossiers | 15 | 15060000020172 | 15060000020172 | 1 | PO419610 | True | |
| 15060000020189 | L15/dossiers | 15 | 15060000020175 | 15060000020175 | 1 | PO419865 | True | |
| 15060000020192 | L15/dossiers | 15 | 15060000020190 | 15060000020190 | 1 | PO59048 | True | |
| 15060000020195 | L15/dossiers | 15 | 15060000020193 | 15060000020193 | 1 | PO419865 | True | |
| 15060000020217 | L15/dossiers | 15 | 15060000020196 | 15060000020196 | 1 | PO419604 | True | |
| 15060000020225 | L15/dossiers | 15 | 15060000020218 | 15060000020218 | 1 | PO59051 | True | |
| 15060000020228 | L15/dossiers | 15 | 15060000020226 | 15060000020226 | 1 | PO419604 | True | |
| 15060000020274 | L15/dossiers | 15 | 15060000020229 | 15060000020229 | 1 | PO419865 | True | |
| 15060000020302 | L15/dossiers | 15 | 15060000020275 | 15060000020275 | 1 | PO59048 | True | |
| 15060000020347 | L15/dossiers | 15 | 15060000020303 | 15060000020303 | 1 | PO420120 | True | |
| 15060000020350 | L15/dossiers | 15 | 15060000020348 | 15060000020348 | 1 | PO59051 | True | |
| 15060000020363 | L15/dossiers | 15 | 15060000020351 | 15060000020351 | 1 | PO59051 | True | |
| 15060000020394 | L15/dossiers | 15 | 15060000020364 | 15060000020364 | 1 | PO59048 | True | |
| 15060000020417 | L15/dossiers | 15 | 15060000020395 | 15060000020395 | 1 | PO420120 | True | |
| 15060000020443 | L15/dossiers | 15 | 15060000020418 | 15060000020418 | 1 | PO419610 | True | |
| 15060000020471 | L15/dossiers | 15 | 15060000020444 | 15060000020444 | 1 | PO59051 | True | |
| 15060000020507 | L15/dossiers | 15 | 15060000020472 | 15060000020472 | 1 | PO419610 | True | |
| 15060000020529 | L15/dossiers | 15 | 15060000020508 | 15060000020508 | 1 | PO419610 | True |