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 |
|---|---|---|---|---|---|---|---|
| 15060000146598 | L15/dossiers | 15 | 15060000146597 | 15060000146597 | 1 | PA718838 | PM722474 |
| 15060000146605 | L15/dossiers | 15 | 15060000146604 | 15060000146604 | 1 | PA1874 | PM722598 |
| 15060000146612 | L15/dossiers | 15 | 15060000146611 | 15060000146611 | 1 | PA2377 | PM723550 |
| 15060000146619 | L15/dossiers | 15 | 15060000146618 | 15060000146618 | 1 | PA720100 | PM722860 |
| 15060000146626 | L15/dossiers | 15 | 15060000146625 | 15060000146625 | 1 | PA722178 | PM723494 |
| 15060000146637 | L15/dossiers | 15 | 15060000146636 | 15060000146636 | 1 | PA345619 | PM725692 |
| 15060000146638 | L15/dossiers | 15 | 15060000146636 | 15060000146636 | 2 | PA717159 | PM730102 |
| 15060000146645 | L15/dossiers | 15 | 15060000146644 | 15060000146644 | 1 | PA709315 | PM722526 |
| 15060000146663 | L15/dossiers | 15 | 15060000146662 | 15060000146662 | 1 | PA719842 | PM722778 |
| 15060000146670 | L15/dossiers | 15 | 15060000146669 | 15060000146669 | 1 | PA719318 | PM722624 |
| 15060000146677 | L15/dossiers | 15 | 15060000146676 | 15060000146676 | 1 | PA720560 | PM723000 |
| 15060000146684 | L15/dossiers | 15 | 15060000146683 | 15060000146683 | 1 | PA720468 | PM722972 |
| 15060000146691 | L15/dossiers | 15 | 15060000146690 | 15060000146690 | 1 | PA330788 | PM722570 |
| 15060000146698 | L15/dossiers | 15 | 15060000146697 | 15060000146697 | 1 | PA340853 | PM722534 |
| 15060000146705 | L15/dossiers | 15 | 15060000146704 | 15060000146704 | 1 | PA718884 | PM722488 |
| 15060000146712 | L15/dossiers | 15 | 15060000146711 | 15060000146711 | 1 | PA345619 | PM725692 |
| 15060000146727 | L15/dossiers | 15 | 15060000146726 | 15060000146726 | 1 | PA267318 | PM723260 |
| 15060000146734 | L15/dossiers | 15 | 15060000146733 | 15060000146733 | 1 | PA720684 | PM723040 |
| 15060000146741 | L15/dossiers | 15 | 15060000146740 | 15060000146740 | 1 | PA721466 | PM723284 |
| 15060000146797 | L15/dossiers | 15 | 15060000146796 | 15060000146796 | 1 | PA606712 | PM722756 |
| 15060000146804 | L15/dossiers | 15 | 15060000146803 | 15060000146803 | 1 | PA267289 | PM754301 |
| 15060000146811 | L15/dossiers | 15 | 15060000146810 | 15060000146810 | 1 | PA605518 | PM722518 |
| 15060000146818 | L15/dossiers | 15 | 15060000146817 | 15060000146817 | 1 | PA718838 | PM722474 |
| 15060000146825 | L15/dossiers | 15 | 15060000146824 | 15060000146824 | 1 | PA415482 | PM760334 |
| 15060000146844 | L15/dossiers | 15 | 15060000146843 | 15060000146843 | 1 | PA266788 | PM722914 |
| 15060000146851 | L15/dossiers | 15 | 15060000146850 | 15060000146850 | 1 | PA425322 | PM736282 |
| 15060000146870 | L15/dossiers | 15 | 15060000146869 | 15060000146869 | 1 | PA721960 | PM723434 |
| 15060000146880 | L15/dossiers | 15 | 15060000146879 | 15060000146879 | 1 | PA267989 | PM703655 |
| 15060000146901 | L15/dossiers | 15 | 15060000146900 | 15060000146900 | 1 | PA268019 | PM723092 |
| 15060000146912 | L15/dossiers | 15 | 15060000146911 | 15060000146911 | 1 | PA223837 | PM722458 |
| 15060000146935 | L15/dossiers | 15 | 15060000146934 | 15060000146934 | 1 | PA721210 | PM723204 |
| 15060000146942 | L15/dossiers | 15 | 15060000146941 | 15060000146941 | 1 | PA702993 | PM736362 |
| 15060000146961 | L15/dossiers | 15 | 15060000146960 | 15060000146960 | 1 | PA429889 | PM736313 |
| 15060000146980 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 1 | PA304082 | PM736354 |
| 15060000146981 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 2 | PA736177 | PM736318 |
| 15060000146982 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 3 | PA757676 | PM757692 |
| 15060000146983 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 4 | PA429891 | PM736329 |
| 15060000146984 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 5 | PA429894 | PM736364 |
| 15060000146985 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 6 | PA756685 | PM756689 |
| 15060000146986 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 7 | PA429836 | PM736345 |
| 15060000146987 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 8 | PA304071 | PM703676 |
| 15060000146988 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 9 | PA429886 | PM736385 |
| 15060000146989 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 10 | PA736195 | PM736357 |
| 15060000146990 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 11 | PA736173 | PM736369 |
| 15060000146991 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 12 | PA1978 | PM736337 |
| 15060000146992 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 13 | PA678263 | PM736330 |
| 15060000146993 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 14 | PA736243 | PM736413 |
| 15060000146994 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 15 | PA703499 | PM703641 |
| 15060000146995 | L15/dossiers | 15 | 15060000146979 | 15060000146979 | 16 | PA736175 | PM736344 |
| 15060000147007 | L15/dossiers | 15 | 15060000147006 | 15060000147006 | 1 | PA304082 | PM736354 |