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 |
|---|---|---|---|---|---|---|---|
| 16060000107793 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 2 | PA703511 | PM775685 |
| 16060000107794 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 3 | PA429855 | PM736425 |
| 16060000107795 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 4 | PA304002 | PM736326 |
| 16060000107796 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 5 | PA785855 | PM785869 |
| 16060000107797 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 6 | PA415449 | PM775793 |
| 16060000107798 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 7 | PA429888 | PM736379 |
| 16060000107799 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 8 | PA703512 | PM775665 |
| 16060000107800 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 9 | PA775290 | PM775576 |
| 16060000107807 | L16/dossiers | 16 | 16060000107806 | 16060000107806 | 1 | PA718784 | PM796266 |
| 16060000107816 | L16/dossiers | 16 | 16060000107815 | 16060000107815 | 1 | PA793122 | PM796161 |
| 16060000107823 | L16/dossiers | 16 | 16060000107822 | 16060000107822 | 1 | PA793832 | PM796557 |
| 16060000107833 | L16/dossiers | 16 | 16060000107832 | 16060000107832 | 1 | PA795350 | PM797436 |
| 16060000107840 | L16/dossiers | 16 | 16060000107839 | 16060000107839 | 1 | PA267328 | PM775729 |
| 16060000107847 | L16/dossiers | 16 | 16060000107846 | 16060000107846 | 1 | PA340643 | PM796335 |
| 16060000107854 | L16/dossiers | 16 | 16060000107853 | 16060000107853 | 1 | PA721474 | PM797511 |
| 16060000107861 | L16/dossiers | 16 | 16060000107860 | 16060000107860 | 1 | PA721960 | PM797811 |
| 16060000107868 | L16/dossiers | 16 | 16060000107867 | 16060000107867 | 1 | PA718674 | PM796164 |
| 16060000107875 | L16/dossiers | 16 | 16060000107874 | 16060000107874 | 1 | PA794434 | PM796920 |
| 16060000107886 | L16/dossiers | 16 | 16060000107885 | 16060000107885 | 1 | PA721486 | PM797517 |
| 16060000107893 | L16/dossiers | 16 | 16060000107892 | 16060000107892 | 1 | PA794198 | PM796776 |
| 16060000107900 | L16/dossiers | 16 | 16060000107899 | 16060000107899 | 1 | PA1567 | PM797631 |
| 16060000107907 | L16/dossiers | 16 | 16060000107906 | 16060000107906 | 1 | PA796062 | PM797832 |
| 16060000107914 | L16/dossiers | 16 | 16060000107913 | 16060000107913 | 1 | PA712014 | PM802637 |
| 16060000107919 | L16/dossiers | 16 | 16060000107918 | 16060000107918 | 1 | PA795958 | PM797778 |
| 16060000107927 | L16/dossiers | 16 | 16060000107926 | 16060000107926 | 1 | PA717161 | PM791583 |
| 16060000107928 | L16/dossiers | 16 | 16060000107926 | 16060000107926 | 2 | PA643210 | PM791690 |
| 16060000108031 | L16/dossiers | 16 | 16060000108030 | 16060000108030 | 1 | PA722046 | PM797625 |
| 16060000108049 | L16/dossiers | 16 | 16060000108048 | 16060000108048 | 1 | PA736243 | PM736413 |
| 16060000108056 | L16/dossiers | 16 | 16060000108055 | 16060000108055 | 1 | PA266788 | PM796788 |
| 16060000108063 | L16/dossiers | 16 | 16060000108062 | 16060000108062 | 1 | PA794222 | PM796785 |
| 16060000108073 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 1 | PA736234 | PM736424 |
| 16060000108074 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 2 | PA429855 | PM736425 |
| 16060000108075 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 3 | PA268048 | PM736422 |
| 16060000108076 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 4 | PA736161 | PM736421 |
| 16060000108077 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 5 | PA703511 | PM775685 |
| 16060000108078 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 6 | PA736199 | PM736284 |
| 16060000108079 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 7 | PA415488 | PM775641 |
| 16060000108080 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 8 | PA775196 | PM775482 |
| 16060000108081 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 9 | PA785855 | PM785869 |
| 16060000108082 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 10 | PA736229 | PM736389 |
| 16060000108083 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 11 | PA775254 | PM775556 |
| 16060000108084 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 12 | PA775268 | PM775574 |
| 16060000108085 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 13 | PA2774 | PM736307 |
| 16060000108086 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 14 | PA736214 | PM736290 |
| 16060000108087 | L16/dossiers | 16 | 16060000108072 | 16060000108072 | 15 | PA736217 | PM736384 |
| 16060000108121 | L16/dossiers | 16 | 16060000108120 | 16060000108120 | 1 | PA1001 | PM736371 |
| 16060000108122 | L16/dossiers | 16 | 16060000108120 | 16060000108120 | 2 | PA736178 | PM736296 |
| 16060000108140 | L16/dossiers | 16 | 16060000108139 | 16060000108139 | 1 | PA775292 | PM775582 |
| 16060000108147 | L16/dossiers | 16 | 16060000108146 | 16060000108146 | 1 | PA429842 | PM736373 |
| 16060000108165 | L16/dossiers | 16 | 16060000108164 | 16060000108164 | 1 | PA313924 | PM775727 |