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 |
|---|---|---|---|---|---|---|---|
| 15060000186727 | L15/dossiers | 15 | 15060000186726 | 15060000186726 | 1 | PA721486 | PM723290 |
| 15060000186734 | L15/dossiers | 15 | 15060000186733 | 15060000186733 | 1 | PA720100 | PM722860 |
| 15060000186741 | L15/dossiers | 15 | 15060000186740 | 15060000186740 | 1 | PA774952 | PM774983 |
| 15060000186748 | L15/dossiers | 15 | 15060000186747 | 15060000186747 | 1 | PA724827 | PM754304 |
| 15060000186755 | L15/dossiers | 15 | 15060000186754 | 15060000186754 | 1 | PA718926 | PM722502 |
| 15060000186762 | L15/dossiers | 15 | 15060000186761 | 15060000186761 | 1 | PA712015 | PM722448 |
| 15060000186769 | L15/dossiers | 15 | 15060000186768 | 15060000186768 | 1 | PA775284 | PM775590 |
| 15060000186776 | L15/dossiers | 15 | 15060000186775 | 15060000186775 | 1 | PA736216 | PM736273 |
| 15060000186783 | L15/dossiers | 15 | 15060000186782 | 15060000186782 | 1 | PA736187 | PM736365 |
| 15060000186790 | L15/dossiers | 15 | 15060000186789 | 15060000186789 | 1 | PA783457 | PM783488 |
| 15060000186794 | L15/dossiers | 15 | 15060000186793 | 15060000186793 | 1 | PA266788 | PM722914 |
| 15060000186801 | L15/dossiers | 15 | 15060000186800 | 15060000186800 | 1 | PA718838 | PM722474 |
| 15060000186809 | L15/dossiers | 15 | 15060000186808 | 15060000186808 | 1 | PA722030 | PM723454 |
| 15060000186813 | L15/dossiers | 15 | 15060000186812 | 15060000186812 | 1 | PA643134 | PM722824 |
| 15060000186820 | L15/dossiers | 15 | 15060000186819 | 15060000186819 | 1 | PA2116 | PM736339 |
| 15060000186827 | L15/dossiers | 15 | 15060000186826 | 15060000186826 | 1 | PA2116 | PM736339 |
| 15060000186858 | L15/dossiers | 15 | 15060000186857 | 15060000186857 | 1 | PA719364 | PM722638 |
| 15060000186865 | L15/dossiers | 15 | 15060000186864 | 15060000186864 | 1 | PA227089 | PM736372 |
| 15060000186872 | L15/dossiers | 15 | 15060000186871 | 15060000186871 | 1 | PA719080 | PM722554 |
| 15060000186879 | L15/dossiers | 15 | 15060000186878 | 15060000186878 | 1 | PA719318 | PM722624 |
| 15060000186886 | L15/dossiers | 15 | 15060000186885 | 15060000186885 | 1 | PA267042 | PM722910 |
| 15060000186893 | L15/dossiers | 15 | 15060000186892 | 15060000186892 | 1 | PA773441 | PM773491 |
| 15060000186894 | L15/dossiers | 15 | 15060000186892 | 15060000186892 | 2 | PA721670 | PM773499 |
| 15060000186911 | L15/dossiers | 15 | 15060000186910 | 15060000186910 | 1 | PA773441 | PM773491 |
| 15060000186918 | L15/dossiers | 15 | 15060000186917 | 15060000186917 | 1 | PA773441 | PM773491 |
| 15060000186925 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 1 | PA330684 | PM775859 |
| 15060000186926 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 2 | PA2538 | PM775801 |
| 15060000186927 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 3 | PA1001 | PM736371 |
| 15060000186928 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 4 | PA775248 | PM775554 |
| 15060000186929 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 5 | PA775184 | PM775486 |
| 15060000186930 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 6 | PA744079 | PM744082 |
| 15060000186931 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 7 | PA776985 | PM777700 |
| 15060000186932 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 8 | PA775176 | PM775462 |
| 15060000186933 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 9 | PA715322 | PM775713 |
| 15060000186934 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 10 | PA1993 | PM736402 |
| 15060000186935 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 11 | PA429854 | PM736335 |
| 15060000186936 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 12 | PA343988 | PM736310 |
| 15060000186937 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 13 | PA775228 | PM775516 |
| 15060000186938 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 14 | PA747421 | PM775759 |
| 15060000186939 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 15 | PA304085 | PM736343 |
| 15060000186940 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 16 | PA267075 | PM775610 |
| 15060000186941 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 17 | PA736194 | PM736291 |
| 15060000186942 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 18 | PA775192 | PM775478 |
| 15060000186943 | L15/dossiers | 15 | 15060000186924 | 15060000186924 | 19 | PA227094 | PM736386 |
| 15060000186950 | L15/dossiers | 15 | 15060000186949 | 15060000186949 | 1 | PA703497 | PM775637 |
| 15060000186981 | L15/dossiers | 15 | 15060000186980 | 15060000186980 | 1 | PA643089 | PM758076 |
| 15060000186994 | L15/dossiers | 15 | 15060000186993 | 15060000186993 | 1 | PA415454 | PM785875 |
| 15060000187001 | L15/dossiers | 15 | 15060000187000 | 15060000187000 | 1 | PA429854 | PM736335 |
| 15060000187008 | L15/dossiers | 15 | 15060000187007 | 15060000187007 | 1 | PA736229 | PM736389 |
| 15060000187015 | L15/dossiers | 15 | 15060000187014 | 15060000187014 | 1 | PA775260 | PM775550 |