dossiers.document_commission
Chemin document.depotAmendements.amendementsCommission.commission · présence : L17 47 %, L16 41 %, L15 40 %, L14 40 %
14 035 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 |
|---|---|---|---|---|---|---|---|---|
| 14060000060447 | L14/dossiers | 14 | 14060000060444 | 14060000060444 | 1 | PO419610 | True | |
| 14060000060464 | L14/dossiers | 14 | 14060000060448 | 14060000060448 | 1 | PO419610 | True | |
| 14060000060505 | L14/dossiers | 14 | 14060000060465 | 14060000060465 | 1 | PO420120 | True | |
| 14060000060581 | L14/dossiers | 14 | 14060000060579 | 14060000060579 | 1 | PO59051 | True | |
| 14060000060622 | L14/dossiers | 14 | 14060000060582 | 14060000060582 | 1 | PO59051 | True | |
| 14060000060631 | L14/dossiers | 14 | 14060000060629 | 14060000060629 | 1 | PO59047 | True | |
| 14060000060660 | L14/dossiers | 14 | 14060000060658 | 14060000060658 | 1 | PO59051 | True | |
| 14060000060663 | L14/dossiers | 14 | 14060000060661 | 14060000060661 | 1 | PO59051 | True | |
| 14060000060667 | L14/dossiers | 14 | 14060000060664 | 14060000060664 | 1 | PO59051 | True | |
| 14060000060671 | L14/dossiers | 14 | 14060000060668 | 14060000060668 | 1 | PO59051 | True | |
| 14060000060714 | L14/dossiers | 14 | 14060000060685 | 14060000060685 | 1 | PO420120 | True | |
| 14060000060719 | L14/dossiers | 14 | 14060000060717 | 14060000060717 | 1 | PO59051 | True | |
| 14060000060723 | L14/dossiers | 14 | 14060000060720 | 14060000060720 | 1 | PO59051 | True | |
| 14060000060727 | L14/dossiers | 14 | 14060000060724 | 14060000060724 | 1 | PO59051 | True | |
| 14060000060731 | L14/dossiers | 14 | 14060000060728 | 14060000060728 | 1 | PO59051 | True | |
| 14060000060747 | L14/dossiers | 14 | 14060000060745 | 14060000060745 | 1 | PO59051 | True | |
| 14060000060784 | L14/dossiers | 14 | 14060000060773 | 14060000060773 | 1 | PO419604 | True | |
| 14060000060795 | L14/dossiers | 14 | 14060000060792 | 14060000060792 | 1 | PO419610 | True | |
| 14060000060809 | L14/dossiers | 14 | 14060000060796 | 14060000060796 | 1 | PO419610 | True | |
| 14060000060813 | L14/dossiers | 14 | 14060000060810 | 14060000060810 | 1 | PO59051 | True | |
| 14060000060845 | L14/dossiers | 14 | 14060000060814 | 14060000060814 | 1 | PO419610 | True | |
| 14060000060862 | L14/dossiers | 14 | 14060000060846 | 14060000060846 | 1 | PO59051 | True | |
| 14060000060907 | L14/dossiers | 14 | 14060000060889 | 14060000060889 | 1 | PO59051 | True | |
| 14060000060910 | L14/dossiers | 14 | 14060000060908 | 14060000060908 | 1 | PO59046 | True | |
| 14060000060959 | L14/dossiers | 14 | 14060000060911 | 14060000060911 | 1 | PO59046 | True | |
| 14060000060966 | L14/dossiers | 14 | 14060000060963 | 14060000060963 | 1 | PO59051 | True | |
| 14060000060967 | L14/dossiers | 14 | 14060000060963 | 14060000060963 | 2 | PO419610 | True | |
| 14060000060972 | L14/dossiers | 14 | 14060000060970 | 14060000060970 | 1 | PO59051 | True | |
| 14060000060973 | L14/dossiers | 14 | 14060000060970 | 14060000060970 | 2 | PO419610 | True | |
| 14060000061002 | L14/dossiers | 14 | 14060000061000 | 14060000061000 | 1 | PO59047 | True | |
| 14060000061035 | L14/dossiers | 14 | 14060000061033 | 14060000061033 | 1 | PO419604 | True | |
| 14060000061039 | L14/dossiers | 14 | 14060000061036 | 14060000061036 | 1 | PO419604 | True | |
| 14060000061043 | L14/dossiers | 14 | 14060000061040 | 14060000061040 | 1 | PO419604 | True | |
| 14060000061046 | L14/dossiers | 14 | 14060000061044 | 14060000061044 | 1 | PO419604 | True | |
| 14060000061337 | L14/dossiers | 14 | 14060000061049 | 14060000061049 | 1 | PO419604 | True | |
| 14060000061341 | L14/dossiers | 14 | 14060000061338 | 14060000061338 | 1 | PO420120 | True | |
| 14060000061387 | L14/dossiers | 14 | 14060000061355 | 14060000061355 | 1 | PO59048 | True | |
| 14060000061436 | L14/dossiers | 14 | 14060000061388 | 14060000061388 | 1 | PO59051 | True | |
| 14060000061440 | L14/dossiers | 14 | 14060000061437 | 14060000061437 | 1 | PO59048 | True | |
| 14060000061483 | L14/dossiers | 14 | 14060000061441 | 14060000061441 | 1 | PO59048 | True | |
| 14060000061497 | L14/dossiers | 14 | 14060000061484 | 14060000061484 | 1 | PO59051 | True | |
| 14060000061500 | L14/dossiers | 14 | 14060000061498 | 14060000061498 | 1 | PO59046 | True | |
| 14060000061575 | L14/dossiers | 14 | 14060000061501 | 14060000061501 | 1 | PO419604 | True | |
| 14060000061584 | L14/dossiers | 14 | 14060000061582 | 14060000061582 | 1 | PO59047 | True | |
| 14060000061611 | L14/dossiers | 14 | 14060000061593 | 14060000061593 | 1 | PO419604 | True | |
| 14060000061619 | L14/dossiers | 14 | 14060000061616 | 14060000061616 | 1 | PO419610 | True | |
| 14060000061623 | L14/dossiers | 14 | 14060000061620 | 14060000061620 | 1 | PO419610 | True | |
| 14060000061628 | L14/dossiers | 14 | 14060000061626 | 14060000061626 | 1 | PO419610 | True | |
| 14060000061669 | L14/dossiers | 14 | 14060000061666 | 14060000061666 | 1 | PO420120 | True | |
| 14060000061681 | L14/dossiers | 14 | 14060000061670 | 14060000061670 | 1 | PO420120 | True |