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 |
|---|---|---|---|---|---|---|---|---|
| 15060000009143 | L15/dossiers | 15 | 15060000008832 | 15060000008832 | 1 | PO59051 | True | |
| 15060000009144 | L15/dossiers | 15 | 15060000008832 | 15060000008832 | 2 | PO419610 | True | |
| 15060000009159 | L15/dossiers | 15 | 15060000009145 | 15060000009145 | 1 | PO59051 | True | |
| 15060000009219 | L15/dossiers | 15 | 15060000009160 | 15060000009160 | 1 | PO419865 | True | |
| 15060000009232 | L15/dossiers | 15 | 15060000009220 | 15060000009220 | 1 | PO59046 | True | |
| 15060000009272 | L15/dossiers | 15 | 15060000009233 | 15060000009233 | 1 | PO59048 | True | |
| 15060000009281 | L15/dossiers | 15 | 15060000009273 | 15060000009273 | 1 | PO419610 | True | |
| 15060000009337 | L15/dossiers | 15 | 15060000009282 | 15060000009282 | 1 | PO59051 | True | |
| 15060000009358 | L15/dossiers | 15 | 15060000009338 | 15060000009338 | 1 | PO59051 | True | |
| 15060000009392 | L15/dossiers | 15 | 15060000009359 | 15060000009359 | 1 | PO420120 | True | |
| 15060000009432 | L15/dossiers | 15 | 15060000009393 | 15060000009393 | 1 | PO420120 | True | |
| 15060000009472 | L15/dossiers | 15 | 15060000009433 | 15060000009433 | 1 | PO419610 | True | |
| 15060000009500 | L15/dossiers | 15 | 15060000009473 | 15060000009473 | 1 | PO59051 | True | |
| 15060000009540 | L15/dossiers | 15 | 15060000009501 | 15060000009501 | 1 | PO419610 | True | |
| 15060000009557 | L15/dossiers | 15 | 15060000009541 | 15060000009541 | 1 | PO420120 | True | |
| 15060000009592 | L15/dossiers | 15 | 15060000009558 | 15060000009558 | 1 | PO59051 | True | |
| 15060000009638 | L15/dossiers | 15 | 15060000009593 | 15060000009593 | 1 | PO59048 | True | |
| 15060000009646 | L15/dossiers | 15 | 15060000009639 | 15060000009639 | 1 | PO59051 | True | |
| 15060000009749 | L15/dossiers | 15 | 15060000009647 | 15060000009647 | 1 | PO420120 | True | |
| 15060000009794 | L15/dossiers | 15 | 15060000009750 | 15060000009750 | 1 | PO419610 | True | |
| 15060000009825 | L15/dossiers | 15 | 15060000009795 | 15060000009795 | 1 | PO59051 | True | |
| 15060000009861 | L15/dossiers | 15 | 15060000009826 | 15060000009826 | 1 | PO59051 | True | |
| 15060000009918 | L15/dossiers | 15 | 15060000009862 | 15060000009862 | 1 | PO420120 | True | |
| 15060000009944 | L15/dossiers | 15 | 15060000009919 | 15060000009919 | 1 | PO419610 | True | |
| 15060000009952 | L15/dossiers | 15 | 15060000009945 | 15060000009945 | 1 | PO419610 | True | |
| 15060000009974 | L15/dossiers | 15 | 15060000009953 | 15060000009953 | 1 | PO420120 | True | |
| 15060000010008 | L15/dossiers | 15 | 15060000009975 | 15060000009975 | 1 | PO420120 | True | |
| 15060000010019 | L15/dossiers | 15 | 15060000010009 | 15060000010009 | 1 | PO419865 | True | |
| 15060000010063 | L15/dossiers | 15 | 15060000010020 | 15060000010020 | 1 | PO420120 | True | |
| 15060000010066 | L15/dossiers | 15 | 15060000010064 | 15060000010064 | 1 | PO420120 | True | |
| 15060000010069 | L15/dossiers | 15 | 15060000010067 | 15060000010067 | 1 | PO419604 | True | |
| 15060000010072 | L15/dossiers | 15 | 15060000010070 | 15060000010070 | 1 | PO59051 | True | |
| 15060000010116 | L15/dossiers | 15 | 15060000010073 | 15060000010073 | 1 | PO59051 | True | |
| 15060000010119 | L15/dossiers | 15 | 15060000010117 | 15060000010117 | 1 | PO419610 | True | |
| 15060000010144 | L15/dossiers | 15 | 15060000010120 | 15060000010120 | 1 | PO420120 | True | |
| 15060000010174 | L15/dossiers | 15 | 15060000010145 | 15060000010145 | 1 | PO59051 | True | |
| 15060000010234 | L15/dossiers | 15 | 15060000010175 | 15060000010175 | 1 | PO420120 | True | |
| 15060000010252 | L15/dossiers | 15 | 15060000010235 | 15060000010235 | 1 | PO59051 | True | |
| 15060000010382 | L15/dossiers | 15 | 15060000010253 | 15060000010253 | 1 | PO419604 | True | |
| 15060000010407 | L15/dossiers | 15 | 15060000010383 | 15060000010383 | 1 | PO419604 | True | |
| 15060000010410 | L15/dossiers | 15 | 15060000010408 | 15060000010408 | 1 | PO420120 | True | |
| 15060000010430 | L15/dossiers | 15 | 15060000010411 | 15060000010411 | 1 | PO59051 | True | |
| 15060000010445 | L15/dossiers | 15 | 15060000010431 | 15060000010431 | 1 | PO59051 | True | |
| 15060000010493 | L15/dossiers | 15 | 15060000010446 | 15060000010446 | 1 | PO59051 | True | |
| 15060000010540 | L15/dossiers | 15 | 15060000010494 | 15060000010494 | 1 | PO59051 | True | |
| 15060000010543 | L15/dossiers | 15 | 15060000010541 | 15060000010541 | 1 | PO419610 | True | |
| 15060000010583 | L15/dossiers | 15 | 15060000010544 | 15060000010544 | 1 | PO419865 | True | |
| 15060000010619 | L15/dossiers | 15 | 15060000010584 | 15060000010584 | 1 | PO420120 | True | |
| 15060000010638 | L15/dossiers | 15 | 15060000010620 | 15060000010620 | 1 | PO420120 | True | |
| 15060000010641 | L15/dossiers | 15 | 15060000010639 | 15060000010639 | 1 | PO419604 | True |