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 |
|---|---|---|---|---|---|---|---|
| 17060000149762 | L17/dossiers | 17 | 17060000149761 | 17060000149761 | 1 | PA840983 | PM842597 |
| 17060000149773 | L17/dossiers | 17 | 17060000149772 | 17060000149772 | 1 | PA841395 | PM842981 |
| 17060000149785 | L17/dossiers | 17 | 17060000149784 | 17060000149784 | 1 | PA840773 | PM842456 |
| 17060000149798 | L17/dossiers | 17 | 17060000149797 | 17060000149797 | 1 | PA840685 | PM842354 |
| 17060000149810 | L17/dossiers | 17 | 17060000149809 | 17060000149809 | 1 | PA840809 | PM842474 |
| 17060000149821 | L17/dossiers | 17 | 17060000149820 | 17060000149820 | 1 | PA841769 | PM843323 |
| 17060000149833 | L17/dossiers | 17 | 17060000149832 | 17060000149832 | 1 | PA841207 | PM842798 |
| 17060000149845 | L17/dossiers | 17 | 17060000149844 | 17060000149844 | 1 | PA841191 | PM842789 |
| 17060000149852 | L17/dossiers | 17 | 17060000149851 | 17060000149851 | 1 | PA774958 | PM843389 |
| 17060000149859 | L17/dossiers | 17 | 17060000149858 | 17060000149858 | 1 | PA775282 | PM775584 |
| 17060000149866 | L17/dossiers | 17 | 17060000149865 | 17060000149865 | 1 | PA842001 | PM843554 |
| 17060000149874 | L17/dossiers | 17 | 17060000149873 | 17060000149873 | 1 | PA721270 | PM840438 |
| 17060000149882 | L17/dossiers | 17 | 17060000149881 | 17060000149881 | 1 | PA711156 | PM829933 |
| 17060000149889 | L17/dossiers | 17 | 17060000149888 | 17060000149888 | 1 | PA840997 | PM842612 |
| 17060000149898 | L17/dossiers | 17 | 17060000149897 | 17060000149897 | 1 | PA643089 | PM858443 |
| 17060000149902 | L17/dossiers | 17 | 17060000149901 | 17060000149901 | 1 | PA842001 | PM843554 |
| 17060000149909 | L17/dossiers | 17 | 17060000149908 | 17060000149908 | 1 | PA775300 | PM775600 |
| 17060000149916 | L17/dossiers | 17 | 17060000149915 | 17060000149915 | 1 | PA429869 | PM829749 |
| 17060000149929 | L17/dossiers | 17 | 17060000149928 | 17060000149928 | 1 | PA643210 | PM873637 |
| 17060000149948 | L17/dossiers | 17 | 17060000149947 | 17060000149947 | 1 | PA795318 | PM843689 |
| 17060000149955 | L17/dossiers | 17 | 17060000149954 | 17060000149954 | 1 | PA793780 | PM842714 |
| 17060000149959 | L17/dossiers | 17 | 17060000149958 | 17060000149958 | 1 | PA643210 | PM873637 |
| 17060000149967 | L17/dossiers | 17 | 17060000149966 | 17060000149966 | 1 | PA795240 | PM843785 |
| 17060000149974 | L17/dossiers | 17 | 17060000149973 | 17060000149973 | 1 | PA842037 | PM843578 |
| 17060000149981 | L17/dossiers | 17 | 17060000149980 | 17060000149980 | 1 | PA793716 | PM842528 |
| 17060000149988 | L17/dossiers | 17 | 17060000149987 | 17060000149987 | 1 | PA719558 | PM842663 |
| 17060000149995 | L17/dossiers | 17 | 17060000149994 | 17060000149994 | 1 | PA721486 | PM843614 |
| 17060000150003 | L17/dossiers | 17 | 17060000150002 | 17060000150002 | 1 | PA840967 | PM842579 |
| 17060000150010 | L17/dossiers | 17 | 17060000150009 | 17060000150009 | 1 | PA794762 | PM843233 |
| 17060000150017 | L17/dossiers | 17 | 17060000150016 | 17060000150016 | 1 | PA794198 | PM842876 |
| 17060000150024 | L17/dossiers | 17 | 17060000150023 | 17060000150023 | 1 | PA793342 | PM842345 |
| 17060000150031 | L17/dossiers | 17 | 17060000150030 | 17060000150030 | 1 | PA309643 | PM843545 |
| 17060000150038 | L17/dossiers | 17 | 17060000150037 | 17060000150037 | 1 | PA794322 | PM842942 |
| 17060000150045 | L17/dossiers | 17 | 17060000150044 | 17060000150044 | 1 | PA794734 | PM843146 |
| 17060000150052 | L17/dossiers | 17 | 17060000150051 | 17060000150051 | 1 | PA793616 | PM842561 |
| 17060000150059 | L17/dossiers | 17 | 17060000150058 | 17060000150058 | 1 | PA335999 | PM843494 |
| 17060000150066 | L17/dossiers | 17 | 17060000150065 | 17060000150065 | 1 | PA827982 | PM828718 |
| 17060000150073 | L17/dossiers | 17 | 17060000150072 | 17060000150072 | 1 | PA841769 | PM843323 |
| 17060000150077 | L17/dossiers | 17 | 17060000150076 | 17060000150076 | 1 | PA643210 | PM873637 |
| 17060000150078 | L17/dossiers | 17 | 17060000150076 | 17060000150076 | 2 | PA607846 | PM873684 |
| 17060000150079 | L17/dossiers | 17 | 17060000150076 | 17060000150076 | 3 | PA873627 | PM873661 |
| 17060000150080 | L17/dossiers | 17 | 17060000150076 | 17060000150076 | 4 | PA720066 | PM873675 |
| 17060000150113 | L17/dossiers | 17 | 17060000150112 | 17060000150112 | 1 | PA643210 | PM873637 |
| 17060000150114 | L17/dossiers | 17 | 17060000150112 | 17060000150112 | 2 | PA873624 | PM873671 |
| 17060000150115 | L17/dossiers | 17 | 17060000150112 | 17060000150112 | 3 | PA720066 | PM873675 |
| 17060000150116 | L17/dossiers | 17 | 17060000150112 | 17060000150112 | 4 | PA795950 | PM879422 |
| 17060000150148 | L17/dossiers | 17 | 17060000150147 | 17060000150147 | 1 | PA794118 | PM842894 |
| 17060000150158 | L17/dossiers | 17 | 17060000150157 | 17060000150157 | 1 | PA267241 | PM778080 |
| 17060000150165 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 1 | PA827950 | PM828598 |
| 17060000150166 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 2 | PA736177 | PM829835 |