dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 | acteur_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.acteurRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
| 8 | mandat_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.mandatRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|
| 17060000129860 | L17/dossiers | 17 | 17060000129768 | 17060000129768 | 92 | PA849534 | PM849592 |
| 17060000129861 | L17/dossiers | 17 | 17060000129768 | 17060000129768 | 93 | PA706108 | PM829553 |
| 17060000129862 | L17/dossiers | 17 | 17060000129768 | 17060000129768 | 94 | PA775192 | PM775478 |
| 17060000129863 | L17/dossiers | 17 | 17060000129768 | 17060000129768 | 95 | PA267743 | PM829699 |
| 17060000129870 | L17/dossiers | 17 | 17060000129869 | 17060000129869 | 1 | PA795466 | PM843443 |
| 17060000129874 | L17/dossiers | 17 | 17060000129873 | 17060000129873 | 1 | PA642868 | PM858305 |
| 17060000129882 | L17/dossiers | 17 | 17060000129881 | 17060000129881 | 1 | PA721908 | PM843467 |
| 17060000129883 | L17/dossiers | 17 | 17060000129881 | 17060000129881 | 2 | PA793708 | PM842525 |
| 17060000129903 | L17/dossiers | 17 | 17060000129902 | 17060000129902 | 1 | PA793342 | PM842345 |
| 17060000129907 | L17/dossiers | 17 | 17060000129906 | 17060000129906 | 1 | PA827910 | PM828508 |
| 17060000129914 | L17/dossiers | 17 | 17060000129913 | 17060000129913 | 1 | PA793672 | PM842555 |
| 17060000129918 | L17/dossiers | 17 | 17060000129917 | 17060000129917 | 1 | PA827954 | PM828704 |
| 17060000129919 | L17/dossiers | 17 | 17060000129917 | 17060000129917 | 2 | PA736204 | PM829853 |
| 17060000129920 | L17/dossiers | 17 | 17060000129917 | 17060000129917 | 3 | PA773891 | PM829713 |
| 17060000129921 | L17/dossiers | 17 | 17060000129917 | 17060000129917 | 4 | PA736236 | PM829899 |
| 17060000129922 | L17/dossiers | 17 | 17060000129917 | 17060000129917 | 5 | PA828018 | PM828882 |
| 17060000129953 | L17/dossiers | 17 | 17060000129952 | 17060000129952 | 1 | PA788192 | PM829697 |
| 17060000129982 | L17/dossiers | 17 | 17060000129981 | 17060000129981 | 1 | PA841713 | PM843275 |
| 17060000129986 | L17/dossiers | 17 | 17060000129985 | 17060000129985 | 1 | PA840721 | PM842378 |
| 17060000129993 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 1 | PA429889 | PM829767 |
| 17060000129994 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 2 | PA702993 | PM829493 |
| 17060000129995 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 3 | PA642982 | PM829146 |
| 17060000129996 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 4 | PA775268 | PM775574 |
| 17060000129997 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 5 | PA429835 | PM829719 |
| 17060000129998 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 6 | PA606375 | PM775602 |
| 17060000129999 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 7 | PA605888 | PM775604 |
| 17060000130000 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 8 | PA736181 | PM829839 |
| 17060000130001 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 9 | PA703512 | PM775665 |
| 17060000130002 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 10 | PA643028 | PM829316 |
| 17060000130003 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 11 | PA590034 | PM775606 |
| 17060000130004 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 12 | PA736229 | PM829923 |
| 17060000130005 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 13 | PA827920 | PM828574 |
| 17060000130006 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 14 | PA775294 | PM775580 |
| 17060000130007 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 15 | PA415477 | PM775809 |
| 17060000130008 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 16 | PA785855 | PM785869 |
| 17060000130009 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 17 | PA642756 | PM775779 |
| 17060000130010 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 18 | PA736219 | PM829867 |
| 17060000130011 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 19 | PA827900 | PM828434 |
| 17060000130012 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 20 | PA775186 | PM775484 |
| 17060000130013 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 21 | PA415488 | PM775641 |
| 17060000130014 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 22 | PA775194 | PM775476 |
| 17060000130015 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 23 | PA775196 | PM775482 |
| 17060000130016 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 24 | PA775200 | PM775504 |
| 17060000130017 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 25 | PA775206 | PM775506 |
| 17060000130018 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 26 | PA827924 | PM828550 |
| 17060000130019 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 27 | PA736234 | PM829887 |
| 17060000130020 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 28 | PA775210 | PM775492 |
| 17060000130021 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 29 | PA712422 | PM828926 |
| 17060000130022 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 30 | PA827932 | PM828526 |
| 17060000130023 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 31 | PA736167 | PM829803 |