dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 15060000131663 | L15/dossiers | 15 | 15060000131662 | 15060000131662 | 1 | PA267260 | PM722476 |
| 15060000131670 | L15/dossiers | 15 | 15060000131669 | 15060000131669 | 1 | PA267260 | PM722476 |
| 15060000131677 | L15/dossiers | 15 | 15060000131676 | 15060000131676 | 1 | PA267260 | PM722476 |
| 15060000131684 | L15/dossiers | 15 | 15060000131683 | 15060000131683 | 1 | PA267260 | PM722476 |
| 15060000131691 | L15/dossiers | 15 | 15060000131690 | 15060000131690 | 1 | PA2952 | PM722480 |
| 15060000131698 | L15/dossiers | 15 | 15060000131697 | 15060000131697 | 1 | PA2952 | PM722480 |
| 15060000131705 | L15/dossiers | 15 | 15060000131704 | 15060000131704 | 1 | PA2952 | PM722480 |
| 15060000131712 | L15/dossiers | 15 | 15060000131711 | 15060000131711 | 1 | PA2952 | PM722480 |
| 15060000131719 | L15/dossiers | 15 | 15060000131718 | 15060000131718 | 1 | PA2952 | PM722480 |
| 15060000131726 | L15/dossiers | 15 | 15060000131725 | 15060000131725 | 1 | PA345619 | PM725692 |
| 15060000131727 | L15/dossiers | 15 | 15060000131725 | 15060000131725 | 2 | PA1872 | PM730104 |
| 15060000131759 | L15/dossiers | 15 | 15060000131758 | 15060000131758 | 1 | PA345619 | PM725692 |
| 15060000131760 | L15/dossiers | 15 | 15060000131758 | 15060000131758 | 2 | PA1872 | PM730104 |
| 15060000131792 | L15/dossiers | 15 | 15060000131791 | 15060000131791 | 1 | PA2952 | PM722480 |
| 15060000131799 | L15/dossiers | 15 | 15060000131798 | 15060000131798 | 1 | PA2952 | PM722480 |
| 15060000131806 | L15/dossiers | 15 | 15060000131805 | 15060000131805 | 1 | PA721932 | PM734586 |
| 15060000131821 | L15/dossiers | 15 | 15060000131820 | 15060000131820 | 1 | PA998 | PM723046 |
| 15060000131828 | L15/dossiers | 15 | 15060000131827 | 15060000131827 | 1 | PA330684 | PM722528 |
| 15060000131835 | L15/dossiers | 15 | 15060000131834 | 15060000131834 | 1 | PA267260 | PM722476 |
| 15060000131842 | L15/dossiers | 15 | 15060000131841 | 15060000131841 | 1 | PA267260 | PM722476 |
| 15060000131849 | L15/dossiers | 15 | 15060000131848 | 15060000131848 | 1 | PA2952 | PM722480 |
| 15060000131856 | L15/dossiers | 15 | 15060000131855 | 15060000131855 | 1 | PA2952 | PM722480 |
| 15060000131863 | L15/dossiers | 15 | 15060000131862 | 15060000131862 | 1 | PA332747 | PM722798 |
| 15060000131883 | L15/dossiers | 15 | 15060000131882 | 15060000131882 | 1 | PA267527 | PM723274 |
| 15060000131890 | L15/dossiers | 15 | 15060000131889 | 15060000131889 | 1 | PA721932 | PM734586 |
| 15060000131897 | L15/dossiers | 15 | 15060000131896 | 15060000131896 | 1 | PA720822 | PM723086 |
| 15060000131904 | L15/dossiers | 15 | 15060000131903 | 15060000131903 | 1 | PA720822 | PM723086 |
| 15060000131911 | L15/dossiers | 15 | 15060000131910 | 15060000131910 | 1 | PA642868 | PM722992 |
| 15060000131943 | L15/dossiers | 15 | 15060000131942 | 15060000131942 | 1 | PA642868 | PM722992 |
| 15060000131950 | L15/dossiers | 15 | 15060000131949 | 15060000131949 | 1 | PA266788 | PM722914 |
| 15060000131957 | L15/dossiers | 15 | 15060000131956 | 15060000131956 | 1 | PA267429 | PM722818 |
| 15060000131964 | L15/dossiers | 15 | 15060000131963 | 15060000131963 | 1 | PA606712 | PM722756 |
| 15060000131971 | L15/dossiers | 15 | 15060000131970 | 15060000131970 | 1 | PA340853 | PM722534 |
| 15060000131978 | L15/dossiers | 15 | 15060000131977 | 15060000131977 | 1 | PA267318 | PM723260 |
| 15060000131985 | L15/dossiers | 15 | 15060000131984 | 15060000131984 | 1 | PA606712 | PM722756 |
| 15060000132003 | L15/dossiers | 15 | 15060000132002 | 15060000132002 | 1 | PA267318 | PM723260 |
| 15060000132010 | L15/dossiers | 15 | 15060000132009 | 15060000132009 | 1 | PA345619 | PM725692 |
| 15060000132011 | L15/dossiers | 15 | 15060000132009 | 15060000132009 | 2 | PA331481 | PM730094 |
| 15060000132018 | L15/dossiers | 15 | 15060000132017 | 15060000132017 | 1 | PA266788 | PM722914 |
| 15060000132025 | L15/dossiers | 15 | 15060000132024 | 15060000132024 | 1 | PA2952 | PM722480 |
| 15060000132032 | L15/dossiers | 15 | 15060000132031 | 15060000132031 | 1 | PA2952 | PM722480 |
| 15060000132039 | L15/dossiers | 15 | 15060000132038 | 15060000132038 | 1 | PA718850 | PM722478 |
| 15060000132049 | L15/dossiers | 15 | 15060000132048 | 15060000132048 | 1 | PA345619 | PM725692 |
| 15060000132050 | L15/dossiers | 15 | 15060000132048 | 15060000132048 | 2 | PA607846 | PM730066 |
| 15060000132144 | L15/dossiers | 15 | 15060000132143 | 15060000132143 | 1 | PA606098 | PM722642 |
| 15060000132151 | L15/dossiers | 15 | 15060000132150 | 15060000132150 | 1 | PA345619 | PM725692 |
| 15060000132152 | L15/dossiers | 15 | 15060000132150 | 15060000132150 | 2 | PA717169 | PM730074 |
| 15060000132222 | L15/dossiers | 15 | 15060000132221 | 15060000132221 | 1 | PA267330 | PM723392 |
| 15060000132241 | L15/dossiers | 15 | 15060000132240 | 15060000132240 | 1 | PA2952 | PM722480 |
| 15060000132248 | L15/dossiers | 15 | 15060000132247 | 15060000132247 | 1 | PA2952 | PM722480 |