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 |
|---|---|---|---|---|---|---|---|
| 15060000156912 | L15/dossiers | 15 | 15060000156885 | 15060000156885 | 27 | PA1183 | PM706347 |
| 15060000156913 | L15/dossiers | 15 | 15060000156885 | 15060000156885 | 28 | PA267907 | PM703591 |
| 15060000156914 | L15/dossiers | 15 | 15060000156885 | 15060000156885 | 29 | PA394676 | PM703550 |
| 15060000156915 | L15/dossiers | 15 | 15060000156885 | 15060000156885 | 30 | PA703500 | PM703574 |
| 15060000156916 | L15/dossiers | 15 | 15060000156885 | 15060000156885 | 31 | PA415489 | PM703714 |
| 15060000156917 | L15/dossiers | 15 | 15060000156885 | 15060000156885 | 32 | PA711156 | PM711160 |
| 15060000156930 | L15/dossiers | 15 | 15060000156929 | 15060000156929 | 1 | PA703513 | PM703621 |
| 15060000156937 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 1 | PA429890 | PM543935 |
| 15060000156938 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 2 | PA429895 | PM429915 |
| 15060000156939 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 3 | PA703486 | PM703718 |
| 15060000156940 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 4 | PA703531 | PM703701 |
| 15060000156941 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 5 | PA905 | PM703566 |
| 15060000156942 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 6 | PA304071 | PM703676 |
| 15060000156943 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 7 | PA1573 | PM703652 |
| 15060000156944 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 8 | PA703529 | PM703650 |
| 15060000156945 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 9 | PA415464 | PM703627 |
| 15060000156946 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 10 | PA415480 | PM709303 |
| 15060000156947 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 11 | PA415480 | PM709303 |
| 15060000156948 | L15/dossiers | 15 | 15060000156936 | 15060000156936 | 12 | PA732420 | PM732493 |
| 15060000156955 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 1 | PA703510 | PM703672 |
| 15060000156956 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 2 | PA304108 | PM736399 |
| 15060000156957 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 3 | PA703517 | PM703625 |
| 15060000156958 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 4 | PA703541 | PM703644 |
| 15060000156959 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 5 | PA708632 | PM708643 |
| 15060000156960 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 6 | PA415447 | PM703616 |
| 15060000156961 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 7 | PA304076 | PM703694 |
| 15060000156962 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 8 | PA301592 | PM736375 |
| 15060000156963 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 9 | PA415467 | PM703636 |
| 15060000156964 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 10 | PA267112 | PM703608 |
| 15060000156965 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 11 | PA736213 | PM736431 |
| 15060000156966 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 12 | PA703522 | PM703702 |
| 15060000156967 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 13 | PA267340 | PM703713 |
| 15060000156968 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 14 | PA415489 | PM703714 |
| 15060000156969 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 15 | PA703507 | PM703567 |
| 15060000156970 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 16 | PA703513 | PM703621 |
| 15060000156971 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 17 | PA703494 | PM703602 |
| 15060000156972 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 18 | PA1344 | PM736383 |
| 15060000156973 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 19 | PA343988 | PM736310 |
| 15060000156974 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 20 | PA267081 | PM703617 |
| 15060000156975 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 21 | PA715322 | PM715327 |
| 15060000156976 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 22 | PA736200 | PM736285 |
| 15060000156977 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 23 | PA425322 | PM736282 |
| 15060000156978 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 24 | PA711156 | PM736319 |
| 15060000156979 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 25 | PA429851 | PM736305 |
| 15060000156980 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 26 | PA703497 | PM703569 |
| 15060000156981 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 27 | PA267328 | PM703547 |
| 15060000156982 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 28 | PA703539 | PM703693 |
| 15060000156983 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 29 | PA303997 | PM703603 |
| 15060000156984 | L15/dossiers | 15 | 15060000156954 | 15060000156954 | 30 | PA703518 | PM703704 |
| 15060000156991 | L15/dossiers | 15 | 15060000156990 | 15060000156990 | 1 | PA426327 | PM703630 |