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 |
|---|---|---|---|---|---|---|---|
| 15060000138842 | L15/dossiers | 15 | 15060000138841 | 15060000138841 | 1 | PA267766 | PM722970 |
| 15060000138849 | L15/dossiers | 15 | 15060000138848 | 15060000138848 | 1 | PA334149 | PM723034 |
| 15060000138856 | L15/dossiers | 15 | 15060000138855 | 15060000138855 | 1 | PA1960 | PM722810 |
| 15060000138863 | L15/dossiers | 15 | 15060000138862 | 15060000138862 | 1 | PA1960 | PM722810 |
| 15060000138870 | L15/dossiers | 15 | 15060000138869 | 15060000138869 | 1 | PA2377 | PM723550 |
| 15060000138877 | L15/dossiers | 15 | 15060000138876 | 15060000138876 | 1 | PA267785 | PM723310 |
| 15060000138884 | L15/dossiers | 15 | 15060000138883 | 15060000138883 | 1 | PA720614 | PM723016 |
| 15060000138891 | L15/dossiers | 15 | 15060000138890 | 15060000138890 | 1 | PA267766 | PM722970 |
| 15060000138898 | L15/dossiers | 15 | 15060000138897 | 15060000138897 | 1 | PA718884 | PM722488 |
| 15060000138905 | L15/dossiers | 15 | 15060000138904 | 15060000138904 | 1 | PA267200 | PM722974 |
| 15060000138912 | L15/dossiers | 15 | 15060000138911 | 15060000138911 | 1 | PA267200 | PM722974 |
| 15060000138919 | L15/dossiers | 15 | 15060000138918 | 15060000138918 | 1 | PA267200 | PM722974 |
| 15060000138926 | L15/dossiers | 15 | 15060000138925 | 15060000138925 | 1 | PA267200 | PM722974 |
| 15060000138933 | L15/dossiers | 15 | 15060000138932 | 15060000138932 | 1 | PA267200 | PM722974 |
| 15060000138943 | L15/dossiers | 15 | 15060000138942 | 15060000138942 | 1 | PA608416 | PM723540 |
| 15060000138964 | L15/dossiers | 15 | 15060000138963 | 15060000138963 | 1 | PA2952 | PM722480 |
| 15060000138971 | L15/dossiers | 15 | 15060000138970 | 15060000138970 | 1 | PA2952 | PM722480 |
| 15060000138978 | L15/dossiers | 15 | 15060000138977 | 15060000138977 | 1 | PA2952 | PM722480 |
| 15060000138985 | L15/dossiers | 15 | 15060000138984 | 15060000138984 | 1 | PA2952 | PM722480 |
| 15060000138992 | L15/dossiers | 15 | 15060000138991 | 15060000138991 | 1 | PA2952 | PM722480 |
| 15060000138999 | L15/dossiers | 15 | 15060000138998 | 15060000138998 | 1 | PA2952 | PM722480 |
| 15060000139006 | L15/dossiers | 15 | 15060000139005 | 15060000139005 | 1 | PA608416 | PM723540 |
| 15060000139013 | L15/dossiers | 15 | 15060000139012 | 15060000139012 | 1 | PA721062 | PM723158 |
| 15060000139020 | L15/dossiers | 15 | 15060000139019 | 15060000139019 | 1 | PA713448 | PM722452 |
| 15060000139027 | L15/dossiers | 15 | 15060000139026 | 15060000139026 | 1 | PA718784 | PM722456 |
| 15060000139034 | L15/dossiers | 15 | 15060000139033 | 15060000139033 | 1 | PA2377 | PM723550 |
| 15060000139041 | L15/dossiers | 15 | 15060000139040 | 15060000139040 | 1 | PA605991 | PM722660 |
| 15060000139048 | L15/dossiers | 15 | 15060000139047 | 15060000139047 | 1 | PA330240 | PM722492 |
| 15060000139055 | L15/dossiers | 15 | 15060000139054 | 15060000139054 | 1 | PA332228 | PM722754 |
| 15060000139062 | L15/dossiers | 15 | 15060000139061 | 15060000139061 | 1 | PA609245 | PM723318 |
| 15060000139069 | L15/dossiers | 15 | 15060000139068 | 15060000139068 | 1 | PA719946 | PM722808 |
| 15060000139076 | L15/dossiers | 15 | 15060000139075 | 15060000139075 | 1 | PA267801 | PM723320 |
| 15060000139083 | L15/dossiers | 15 | 15060000139082 | 15060000139082 | 1 | PA345619 | PM725692 |
| 15060000139084 | L15/dossiers | 15 | 15060000139082 | 15060000139082 | 2 | PA717169 | PM730074 |
| 15060000139223 | L15/dossiers | 15 | 15060000139222 | 15060000139222 | 1 | PA342935 | PM722856 |
| 15060000139230 | L15/dossiers | 15 | 15060000139229 | 15060000139229 | 1 | PA334843 | PM723534 |
| 15060000139237 | L15/dossiers | 15 | 15060000139236 | 15060000139236 | 1 | PA266774 | PM723526 |
| 15060000139244 | L15/dossiers | 15 | 15060000139243 | 15060000139243 | 1 | PA721270 | PM723220 |
| 15060000139251 | L15/dossiers | 15 | 15060000139250 | 15060000139250 | 1 | PA721506 | PM723296 |
| 15060000139258 | L15/dossiers | 15 | 15060000139257 | 15060000139257 | 1 | PA608416 | PM723540 |
| 15060000139265 | L15/dossiers | 15 | 15060000139264 | 15060000139264 | 1 | PA330240 | PM722492 |
| 15060000139272 | L15/dossiers | 15 | 15060000139271 | 15060000139271 | 1 | PA330909 | PM722548 |
| 15060000139291 | L15/dossiers | 15 | 15060000139290 | 15060000139290 | 1 | PA720846 | PM723094 |
| 15060000139298 | L15/dossiers | 15 | 15060000139297 | 15060000139297 | 1 | PA718884 | PM722488 |
| 15060000139305 | L15/dossiers | 15 | 15060000139304 | 15060000139304 | 1 | PA702992 | PM717139 |
| 15060000139306 | L15/dossiers | 15 | 15060000139304 | 15060000139304 | 2 | PA345619 | PM725692 |
| 15060000139307 | L15/dossiers | 15 | 15060000139304 | 15060000139304 | 3 | PA702191 | PM730058 |
| 15060000139386 | L15/dossiers | 15 | 15060000139385 | 15060000139385 | 1 | PA720468 | PM722972 |
| 15060000139393 | L15/dossiers | 15 | 15060000139392 | 15060000139392 | 1 | PA718784 | PM722456 |
| 15060000139400 | L15/dossiers | 15 | 15060000139399 | 15060000139399 | 1 | PA2952 | PM722480 |