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 |
|---|---|---|---|---|---|---|---|
| 15060000155867 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 23 | PA1183 | PM706347 |
| 15060000155868 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 24 | PA404656 | PM736328 |
| 15060000155869 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 25 | PA736218 | PM736257 |
| 15060000155870 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 26 | PA703506 | PM703680 |
| 15060000155871 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 27 | PA703520 | PM703665 |
| 15060000155872 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 28 | PA736169 | PM736293 |
| 15060000155873 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 29 | PA703504 | PM703598 |
| 15060000155874 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 30 | PA1344 | PM736383 |
| 15060000155875 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 31 | PA415454 | PM703689 |
| 15060000155876 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 32 | PA304108 | PM736399 |
| 15060000155877 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 33 | PA703507 | PM703567 |
| 15060000155878 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 34 | PA715322 | PM715327 |
| 15060000155879 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 35 | PA267989 | PM703655 |
| 15060000155880 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 36 | PA1562 | PM736340 |
| 15060000155881 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 37 | PA267081 | PM703617 |
| 15060000155882 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 38 | PA736236 | PM736341 |
| 15060000155883 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 39 | PA736238 | PM736352 |
| 15060000155884 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 40 | PA703515 | PM703592 |
| 15060000155885 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 41 | PA205280 | PM736412 |
| 15060000155886 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 42 | PA394676 | PM703550 |
| 15060000155887 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 43 | PA736210 | PM736254 |
| 15060000155888 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 44 | PA415451 | PM703594 |
| 15060000155889 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 45 | PA415447 | PM703616 |
| 15060000155890 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 46 | PA267795 | PM703667 |
| 15060000155891 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 47 | PA343775 | PM736367 |
| 15060000155892 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 48 | PA1993 | PM736402 |
| 15060000155893 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 49 | PA703537 | PM703595 |
| 15060000155894 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 50 | PA736185 | PM736264 |
| 15060000155895 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 51 | PA2197 | PM703640 |
| 15060000155896 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 52 | PA703517 | PM703625 |
| 15060000155897 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 53 | PA2237 | PM703705 |
| 15060000155898 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 54 | PA703493 | PM703683 |
| 15060000155899 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 55 | PA703541 | PM703644 |
| 15060000155900 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 56 | PA304076 | PM703694 |
| 15060000155901 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 57 | PA267728 | PM736277 |
| 15060000155902 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 58 | PA736240 | PM736279 |
| 15060000155903 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 59 | PA267018 | PM703564 |
| 15060000155904 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 60 | PA711156 | PM736319 |
| 15060000155905 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 61 | PA426327 | PM703630 |
| 15060000155906 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 62 | PA736193 | PM736394 |
| 15060000155907 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 63 | PA301592 | PM736375 |
| 15060000155908 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 64 | PA227094 | PM736386 |
| 15060000155909 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 65 | PA703527 | PM703580 |
| 15060000155916 | L15/dossiers | 15 | 15060000155915 | 15060000155915 | 1 | PA703517 | PM703625 |
| 15060000155923 | L15/dossiers | 15 | 15060000155922 | 15060000155922 | 1 | PA205280 | PM736412 |
| 15060000155930 | L15/dossiers | 15 | 15060000155929 | 15060000155929 | 1 | PA736179 | PM736420 |
| 15060000155937 | L15/dossiers | 15 | 15060000155936 | 15060000155936 | 1 | PA343988 | PM736310 |
| 15060000155944 | L15/dossiers | 15 | 15060000155943 | 15060000155943 | 1 | PA415449 | PM703686 |
| 15060000155951 | L15/dossiers | 15 | 15060000155950 | 15060000155950 | 1 | PA736182 | PM736346 |
| 15060000155958 | L15/dossiers | 15 | 15060000155957 | 15060000155957 | 1 | PA703513 | PM703621 |