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 |
|---|---|---|---|---|---|---|---|---|
| 15060000027655 | L15/dossiers | 15 | 15060000027628 | 15060000027628 | 1 | PO59051 | True | |
| 15060000027686 | L15/dossiers | 15 | 15060000027656 | 15060000027656 | 1 | PO59047 | True | |
| 15060000027717 | L15/dossiers | 15 | 15060000027687 | 15060000027687 | 1 | PO59051 | True | |
| 15060000027967 | L15/dossiers | 15 | 15060000027718 | 15060000027718 | 1 | PO59048 | True | |
| 15060000027970 | L15/dossiers | 15 | 15060000027968 | 15060000027968 | 1 | PO59048 | True | |
| 15060000028001 | L15/dossiers | 15 | 15060000027971 | 15060000027971 | 1 | PO59051 | True | |
| 15060000028036 | L15/dossiers | 15 | 15060000028002 | 15060000028002 | 1 | PO419865 | True | |
| 15060000028081 | L15/dossiers | 15 | 15060000028037 | 15060000028037 | 1 | PO59048 | True | |
| 15060000028105 | L15/dossiers | 15 | 15060000028082 | 15060000028082 | 1 | PO419604 | True | |
| 15060000028108 | L15/dossiers | 15 | 15060000028106 | 15060000028106 | 1 | PO419610 | True | |
| 15060000028127 | L15/dossiers | 15 | 15060000028109 | 15060000028109 | 1 | PO59048 | True | |
| 15060000028173 | L15/dossiers | 15 | 15060000028128 | 15060000028128 | 1 | PO59048 | True | |
| 15060000028188 | L15/dossiers | 15 | 15060000028174 | 15060000028174 | 1 | PO419610 | True | |
| 15060000028201 | L15/dossiers | 15 | 15060000028189 | 15060000028189 | 1 | PO420120 | True | |
| 15060000028325 | L15/dossiers | 15 | 15060000028202 | 15060000028202 | 1 | PO419610 | True | |
| 15060000028372 | L15/dossiers | 15 | 15060000028326 | 15060000028326 | 1 | PO419610 | True | |
| 15060000028395 | L15/dossiers | 15 | 15060000028373 | 15060000028373 | 1 | PO59051 | True | |
| 15060000028413 | L15/dossiers | 15 | 15060000028396 | 15060000028396 | 1 | PO419604 | True | |
| 15060000028431 | L15/dossiers | 15 | 15060000028414 | 15060000028414 | 1 | PO420120 | True | |
| 15060000028499 | L15/dossiers | 15 | 15060000028432 | 15060000028432 | 1 | PO419604 | True | |
| 15060000028552 | L15/dossiers | 15 | 15060000028500 | 15060000028500 | 1 | PO59051 | True | |
| 15060000028565 | L15/dossiers | 15 | 15060000028553 | 15060000028553 | 1 | PO59051 | True | |
| 15060000028611 | L15/dossiers | 15 | 15060000028566 | 15060000028566 | 1 | PO59051 | True | |
| 15060000028614 | L15/dossiers | 15 | 15060000028612 | 15060000028612 | 1 | PO59048 | True | |
| 15060000028664 | L15/dossiers | 15 | 15060000028615 | 15060000028615 | 1 | PO59048 | True | |
| 15060000028667 | L15/dossiers | 15 | 15060000028665 | 15060000028665 | 1 | PO59051 | True | |
| 15060000028670 | L15/dossiers | 15 | 15060000028668 | 15060000028668 | 1 | PO420120 | True | |
| 15060000028673 | L15/dossiers | 15 | 15060000028671 | 15060000028671 | 1 | PO59048 | True | |
| 15060000028676 | L15/dossiers | 15 | 15060000028674 | 15060000028674 | 1 | PO419604 | True | |
| 15060000028698 | L15/dossiers | 15 | 15060000028677 | 15060000028677 | 1 | PO59051 | True | |
| 15060000028735 | L15/dossiers | 15 | 15060000028699 | 15060000028699 | 1 | PO419610 | True | |
| 15060000028765 | L15/dossiers | 15 | 15060000028736 | 15060000028736 | 1 | PO419604 | True | |
| 15060000028793 | L15/dossiers | 15 | 15060000028766 | 15060000028766 | 1 | PO420120 | True | |
| 15060000028842 | L15/dossiers | 15 | 15060000028794 | 15060000028794 | 1 | PO59051 | True | |
| 15060000028845 | L15/dossiers | 15 | 15060000028843 | 15060000028843 | 1 | PO59051 | True | |
| 15060000028848 | L15/dossiers | 15 | 15060000028846 | 15060000028846 | 1 | PO59051 | True | |
| 15060000028885 | L15/dossiers | 15 | 15060000028849 | 15060000028849 | 1 | PO419604 | True | |
| 15060000028953 | L15/dossiers | 15 | 15060000028886 | 15060000028886 | 1 | PO419865 | True | |
| 15060000028972 | L15/dossiers | 15 | 15060000028954 | 15060000028954 | 1 | PO59051 | True | |
| 15060000029011 | L15/dossiers | 15 | 15060000028973 | 15060000028973 | 1 | PO59051 | True | |
| 15060000029017 | L15/dossiers | 15 | 15060000029012 | 15060000029012 | 1 | PO59048 | True | |
| 15060000029050 | L15/dossiers | 15 | 15060000029018 | 15060000029018 | 1 | PO420120 | True | |
| 15060000029140 | L15/dossiers | 15 | 15060000029051 | 15060000029051 | 1 | PO59046 | True | |
| 15060000029143 | L15/dossiers | 15 | 15060000029141 | 15060000029141 | 1 | PO420120 | True | |
| 15060000029171 | L15/dossiers | 15 | 15060000029144 | 15060000029144 | 1 | PO419610 | True | |
| 15060000029180 | L15/dossiers | 15 | 15060000029172 | 15060000029172 | 1 | PO419865 | True | |
| 15060000029183 | L15/dossiers | 15 | 15060000029181 | 15060000029181 | 1 | PO59046 | True | |
| 15060000029224 | L15/dossiers | 15 | 15060000029184 | 15060000029184 | 1 | PO420120 | True | |
| 15060000029235 | L15/dossiers | 15 | 15060000029225 | 15060000029225 | 1 | PO419865 | True | |
| 15060000029308 | L15/dossiers | 15 | 15060000029236 | 15060000029236 | 1 | PO420120 | True |