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 |
|---|---|---|---|---|---|---|---|
| 17060000128747 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 43 | PA607761 | PM828556 |
| 17060000128748 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 44 | PA415449 | PM775793 |
| 17060000128749 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 45 | PA342564 | PM829509 |
| 17060000128750 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 46 | PA268048 | PM829731 |
| 17060000128751 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 47 | PA2074 | PM775677 |
| 17060000128752 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 48 | PA775254 | PM775556 |
| 17060000128753 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 49 | PA775256 | PM775546 |
| 17060000128754 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 50 | PA703512 | PM775665 |
| 17060000128755 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 51 | PA643211 | PM775749 |
| 17060000128756 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 52 | PA610850 | PM828634 |
| 17060000128757 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 53 | PA827982 | PM828718 |
| 17060000128758 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 54 | PA775268 | PM775574 |
| 17060000128759 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 55 | PA606375 | PM775602 |
| 17060000128760 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 56 | PA703505 | PM775679 |
| 17060000128761 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 57 | PA775274 | PM775560 |
| 17060000128762 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 58 | PA703511 | PM775685 |
| 17060000128763 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 59 | PA827994 | PM828782 |
| 17060000128764 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 60 | PA643028 | PM829316 |
| 17060000128765 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 61 | PA775290 | PM775576 |
| 17060000128766 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 62 | PA736214 | PM829883 |
| 17060000128767 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 63 | PA736217 | PM829873 |
| 17060000128768 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 64 | PA828010 | PM828832 |
| 17060000128769 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 65 | PA775294 | PM775580 |
| 17060000128770 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 66 | PA828014 | PM828818 |
| 17060000128771 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 67 | PA828018 | PM828882 |
| 17060000128772 | L17/dossiers | 17 | 17060000128704 | 17060000128704 | 68 | PA828022 | PM828870 |
| 17060000128805 | L17/dossiers | 17 | 17060000128804 | 17060000128804 | 1 | PA410 | PM855580 |
| 17060000128806 | L17/dossiers | 17 | 17060000128804 | 17060000128804 | 2 | PA721836 | PM855144 |
| 17060000128889 | L17/dossiers | 17 | 17060000128888 | 17060000128888 | 1 | PA719918 | PM849155 |
| 17060000128896 | L17/dossiers | 17 | 17060000128895 | 17060000128895 | 1 | PA708632 | PM775667 |
| 17060000128903 | L17/dossiers | 17 | 17060000128902 | 17060000128902 | 1 | PA345722 | PM843650 |
| 17060000128927 | L17/dossiers | 17 | 17060000128926 | 17060000128926 | 1 | PA841023 | PM842645 |
| 17060000128936 | L17/dossiers | 17 | 17060000128935 | 17060000128935 | 1 | PA342384 | PM842771 |
| 17060000128940 | L17/dossiers | 17 | 17060000128939 | 17060000128939 | 1 | PA719024 | PM842390 |
| 17060000128944 | L17/dossiers | 17 | 17060000128943 | 17060000128943 | 1 | PA707706 | PM775741 |
| 17060000128945 | L17/dossiers | 17 | 17060000128943 | 17060000128943 | 2 | PA775278 | PM775564 |
| 17060000128952 | L17/dossiers | 17 | 17060000128951 | 17060000128951 | 1 | PA719024 | PM842390 |
| 17060000128959 | L17/dossiers | 17 | 17060000128958 | 17060000128958 | 1 | PA345722 | PM843650 |
| 17060000128976 | L17/dossiers | 17 | 17060000128975 | 17060000128975 | 1 | PA795176 | PM843788 |
| 17060000128985 | L17/dossiers | 17 | 17060000128984 | 17060000128984 | 1 | PA720162 | PM843068 |
| 17060000129007 | L17/dossiers | 17 | 17060000129006 | 17060000129006 | 1 | PA827960 | PM828664 |
| 17060000129014 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 1 | PA828004 | PM828838 |
| 17060000129015 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 2 | PA775180 | PM775466 |
| 17060000129016 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 3 | PA827904 | PM828514 |
| 17060000129017 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 4 | PA775214 | PM775498 |
| 17060000129018 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 5 | PA775224 | PM775512 |
| 17060000129019 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 6 | PA736177 | PM829835 |
| 17060000129020 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 7 | PA775252 | PM775558 |
| 17060000129021 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 8 | PA827968 | PM828750 |
| 17060000129022 | L17/dossiers | 17 | 17060000129013 | 17060000129013 | 9 | PA827978 | PM828730 |