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 |
|---|---|---|---|---|---|---|---|
| 17060000120951 | L17/dossiers | 17 | 17060000120950 | 17060000120950 | 1 | PA721442 | PM843362 |
| 17060000120955 | L17/dossiers | 17 | 17060000120954 | 17060000120954 | 1 | PA721442 | PM843362 |
| 17060000120962 | L17/dossiers | 17 | 17060000120961 | 17060000120961 | 1 | PA793342 | PM842345 |
| 17060000120966 | L17/dossiers | 17 | 17060000120965 | 17060000120965 | 1 | PA775182 | PM775464 |
| 17060000120973 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 1 | PA720892 | PM840420 |
| 17060000120974 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 2 | PA795228 | PM840447 |
| 17060000120975 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 3 | PA793262 | PM842438 |
| 17060000120976 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 4 | PA794906 | PM843284 |
| 17060000120977 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 5 | PA794138 | PM842909 |
| 17060000120978 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 6 | PA795588 | PM843557 |
| 17060000120979 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 7 | PA795084 | PM840369 |
| 17060000120980 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 8 | PA842105 | PM843626 |
| 17060000120981 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 9 | PA588884 | PM840450 |
| 17060000120982 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 10 | PA841657 | PM843224 |
| 17060000120983 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 11 | PA720430 | PM843092 |
| 17060000120984 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 12 | PA793772 | PM842708 |
| 17060000120985 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 13 | PA795616 | PM840462 |
| 17060000120986 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 14 | PA793444 | PM840270 |
| 17060000120987 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 15 | PA794938 | PM843308 |
| 17060000120988 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 16 | PA795318 | PM843689 |
| 17060000120989 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 17 | PA841023 | PM842645 |
| 17060000120990 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 18 | PA796090 | PM840372 |
| 17060000120991 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 19 | PA793912 | PM842795 |
| 17060000120992 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 20 | PA842187 | PM843704 |
| 17060000120993 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 21 | PA842037 | PM843578 |
| 17060000120994 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 22 | PA791812 | PM840384 |
| 17060000120995 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 23 | PA793736 | PM842693 |
| 17060000120996 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 24 | PA721202 | PM840435 |
| 17060000120997 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 25 | PA721210 | PM843677 |
| 17060000120998 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 26 | PA795136 | PM843353 |
| 17060000120999 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 27 | PA793452 | PM842453 |
| 17060000121000 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 28 | PA793464 | PM840273 |
| 17060000121001 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 29 | PA842155 | PM843674 |
| 17060000121002 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 30 | PA795200 | PM843386 |
| 17060000121003 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 31 | PA795844 | PM843515 |
| 17060000121004 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 32 | PA841251 | PM842837 |
| 17060000121005 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 33 | PA794786 | PM843242 |
| 17060000121006 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 34 | PA794870 | PM843185 |
| 17060000121007 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 35 | PA796070 | PM843746 |
| 17060000121008 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 36 | PA795310 | PM840453 |
| 17060000121009 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 37 | PA794478 | PM843107 |
| 17060000121010 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 38 | PA841947 | PM843503 |
| 17060000121011 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 39 | PA794082 | PM842810 |
| 17060000121012 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 40 | PA795998 | PM843737 |
| 17060000121013 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 41 | PA794130 | PM840297 |
| 17060000121014 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 42 | PA720846 | PM840441 |
| 17060000121015 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 43 | PA841729 | PM843287 |
| 17060000121016 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 44 | PA795516 | PM843452 |
| 17060000121017 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 45 | PA841515 | PM843089 |
| 17060000121018 | L17/dossiers | 17 | 17060000120972 | 17060000120972 | 46 | PA795672 | PM843752 |