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 |
|---|---|---|---|---|---|---|---|
| 17060000127590 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 5 | PA775172 | PM775474 |
| 17060000127591 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 6 | PA827898 | PM828454 |
| 17060000127592 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 7 | PA827912 | PM828488 |
| 17060000127593 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 8 | PA756685 | PM775777 |
| 17060000127594 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 9 | PA827930 | PM828544 |
| 17060000127595 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 10 | PA429886 | PM829757 |
| 17060000127596 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 11 | PA736195 | PM829855 |
| 17060000127597 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 12 | PA736173 | PM829799 |
| 17060000127598 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 13 | PA775246 | PM775532 |
| 17060000127599 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 14 | PA827962 | PM828676 |
| 17060000127600 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 15 | PA828002 | PM828856 |
| 17060000127601 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 16 | PA736243 | PM829929 |
| 17060000127602 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 17 | PA736175 | PM829795 |
| 17060000127603 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 18 | PA828020 | PM828864 |
| 17060000127613 | L17/dossiers | 17 | 17060000127612 | 17060000127612 | 1 | PA707706 | PM775741 |
| 17060000127614 | L17/dossiers | 17 | 17060000127612 | 17060000127612 | 2 | PA775278 | PM775564 |
| 17060000127649 | L17/dossiers | 17 | 17060000127648 | 17060000127648 | 1 | PA736228 | PM829925 |
| 17060000127656 | L17/dossiers | 17 | 17060000127655 | 17060000127655 | 1 | PA703495 | PM775653 |
| 17060000127657 | L17/dossiers | 17 | 17060000127655 | 17060000127655 | 2 | PA711156 | PM829933 |
| 17060000127700 | L17/dossiers | 17 | 17060000127699 | 17060000127699 | 1 | PA793322 | PM840246 |
| 17060000127707 | L17/dossiers | 17 | 17060000127706 | 17060000127706 | 1 | PA827958 | PM828690 |
| 17060000127708 | L17/dossiers | 17 | 17060000127706 | 17060000127706 | 2 | PA736196 | PM829865 |
| 17060000127715 | L17/dossiers | 17 | 17060000127714 | 17060000127714 | 1 | PA610002 | PM840363 |
| 17060000127750 | L17/dossiers | 17 | 17060000127749 | 17060000127749 | 1 | PA795636 | PM843476 |
| 17060000127763 | L17/dossiers | 17 | 17060000127762 | 17060000127762 | 1 | PA736201 | PM840423 |
| 17060000127776 | L17/dossiers | 17 | 17060000127775 | 17060000127775 | 1 | PA841701 | PM843269 |
| 17060000127790 | L17/dossiers | 17 | 17060000127789 | 17060000127789 | 1 | PA736188 | PM829827 |
| 17060000127797 | L17/dossiers | 17 | 17060000127796 | 17060000127796 | 1 | PA410 | PM855580 |
| 17060000127798 | L17/dossiers | 17 | 17060000127796 | 17060000127796 | 2 | PA267622 | PM855121 |
| 17060000127855 | L17/dossiers | 17 | 17060000127854 | 17060000127854 | 1 | PA410 | PM855580 |
| 17060000127856 | L17/dossiers | 17 | 17060000127854 | 17060000127854 | 2 | PA607846 | PM855126 |
| 17060000127863 | L17/dossiers | 17 | 17060000127862 | 17060000127862 | 1 | PA711156 | PM829933 |
| 17060000127882 | L17/dossiers | 17 | 17060000127881 | 17060000127881 | 1 | PA736237 | PM829897 |
| 17060000127901 | L17/dossiers | 17 | 17060000127900 | 17060000127900 | 1 | PA410 | PM855580 |
| 17060000127908 | L17/dossiers | 17 | 17060000127907 | 17060000127907 | 1 | PA410 | PM855580 |
| 17060000127940 | L17/dossiers | 17 | 17060000127939 | 17060000127939 | 1 | PA736182 | PM829837 |
| 17060000127969 | L17/dossiers | 17 | 17060000127968 | 17060000127968 | 1 | PA775210 | PM775492 |
| 17060000127979 | L17/dossiers | 17 | 17060000127978 | 17060000127978 | 1 | PA703536 | PM775719 |
| 17060000127980 | L17/dossiers | 17 | 17060000127978 | 17060000127978 | 2 | PA775294 | PM775580 |
| 17060000127987 | L17/dossiers | 17 | 17060000127986 | 17060000127986 | 1 | PA827978 | PM828730 |
| 17060000127988 | L17/dossiers | 17 | 17060000127986 | 17060000127986 | 2 | PA785857 | PM785867 |
| 17060000127998 | L17/dossiers | 17 | 17060000127997 | 17060000127997 | 1 | PA410 | PM855580 |
| 17060000127999 | L17/dossiers | 17 | 17060000127997 | 17060000127997 | 2 | PA855045 | PM855136 |
| 17060000128006 | L17/dossiers | 17 | 17060000128005 | 17060000128005 | 1 | PA793452 | PM842453 |
| 17060000128013 | L17/dossiers | 17 | 17060000128012 | 17060000128012 | 1 | PA720846 | PM840441 |
| 17060000128020 | L17/dossiers | 17 | 17060000128019 | 17060000128019 | 1 | PA721336 | PM843281 |
| 17060000128027 | L17/dossiers | 17 | 17060000128026 | 17060000128026 | 1 | PA794830 | PM843209 |
| 17060000128031 | L17/dossiers | 17 | 17060000128030 | 17060000128030 | 1 | PA817203 | PM842978 |
| 17060000128048 | L17/dossiers | 17 | 17060000128047 | 17060000128047 | 1 | PA720892 | PM840420 |
| 17060000128058 | L17/dossiers | 17 | 17060000128057 | 17060000128057 | 1 | PA703523 | PM775703 |