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 |
|---|---|---|---|---|---|---|---|
| 17060000134786 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 46 | PA703512 | PM775665 |
| 17060000134787 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 47 | PA643211 | PM775749 |
| 17060000134788 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 48 | PA610850 | PM828634 |
| 17060000134789 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 49 | PA827980 | PM828710 |
| 17060000134790 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 50 | PA827982 | PM828718 |
| 17060000134791 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 51 | PA775268 | PM775574 |
| 17060000134792 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 52 | PA606375 | PM775602 |
| 17060000134793 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 53 | PA703505 | PM775679 |
| 17060000134794 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 54 | PA775274 | PM775560 |
| 17060000134795 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 55 | PA703511 | PM775685 |
| 17060000134796 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 56 | PA827994 | PM828782 |
| 17060000134797 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 57 | PA643028 | PM829316 |
| 17060000134798 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 58 | PA429889 | PM829767 |
| 17060000134799 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 59 | PA775290 | PM775576 |
| 17060000134800 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 60 | PA736214 | PM829883 |
| 17060000134801 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 61 | PA736217 | PM829873 |
| 17060000134802 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 62 | PA828010 | PM828832 |
| 17060000134803 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 63 | PA775294 | PM775580 |
| 17060000134804 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 64 | PA828014 | PM828818 |
| 17060000134805 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 65 | PA828018 | PM828882 |
| 17060000134806 | L17/dossiers | 17 | 17060000134740 | 17060000134740 | 66 | PA828022 | PM828870 |
| 17060000134813 | L17/dossiers | 17 | 17060000134812 | 17060000134812 | 1 | PA267743 | PM829699 |
| 17060000134820 | L17/dossiers | 17 | 17060000134819 | 17060000134819 | 1 | PA794938 | PM843308 |
| 17060000134824 | L17/dossiers | 17 | 17060000134823 | 17060000134823 | 1 | PA703513 | PM775671 |
| 17060000134831 | L17/dossiers | 17 | 17060000134830 | 17060000134830 | 1 | PA720892 | PM840420 |
| 17060000134838 | L17/dossiers | 17 | 17060000134837 | 17060000134837 | 1 | PA793904 | PM840288 |
| 17060000134852 | L17/dossiers | 17 | 17060000134851 | 17060000134851 | 1 | PA722190 | PM843659 |
| 17060000134883 | L17/dossiers | 17 | 17060000134882 | 17060000134882 | 1 | PA775268 | PM775574 |
| 17060000134890 | L17/dossiers | 17 | 17060000134889 | 17060000134889 | 1 | PA775206 | PM775506 |
| 17060000134891 | L17/dossiers | 17 | 17060000134889 | 17060000134889 | 2 | PA827900 | PM828434 |
| 17060000134892 | L17/dossiers | 17 | 17060000134889 | 17060000134889 | 3 | PA827932 | PM828526 |
| 17060000134893 | L17/dossiers | 17 | 17060000134889 | 17060000134889 | 4 | PA766947 | PM775799 |
| 17060000134894 | L17/dossiers | 17 | 17060000134889 | 17060000134889 | 5 | PA642756 | PM775779 |
| 17060000134901 | L17/dossiers | 17 | 17060000134900 | 17060000134900 | 1 | PA410 | PM855580 |
| 17060000134959 | L17/dossiers | 17 | 17060000134958 | 17060000134958 | 1 | PA841709 | PM849151 |
| 17060000134975 | L17/dossiers | 17 | 17060000134974 | 17060000134974 | 1 | PA267285 | PM842900 |
| 17060000134987 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 1 | PA756685 | PM775777 |
| 17060000134988 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 2 | PA757676 | PM829801 |
| 17060000134989 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 3 | PA828002 | PM828856 |
| 17060000134990 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 4 | PA429886 | PM829757 |
| 17060000134991 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 5 | PA775172 | PM775474 |
| 17060000134992 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 6 | PA827898 | PM828454 |
| 17060000134993 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 7 | PA850008 | PM850016 |
| 17060000134994 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 8 | PA827912 | PM828488 |
| 17060000134995 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 9 | PA827930 | PM828544 |
| 17060000134996 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 10 | PA268007 | PM829695 |
| 17060000134997 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 11 | PA736195 | PM829855 |
| 17060000134998 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 12 | PA736173 | PM829799 |
| 17060000134999 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 13 | PA775246 | PM775532 |
| 17060000135000 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 14 | PA827962 | PM828676 |