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 |
|---|---|---|---|---|---|---|---|
| 15060000134709 | L15/dossiers | 15 | 15060000134707 | 15060000134707 | 2 | PA717153 | PM730062 |
| 15060000134716 | L15/dossiers | 15 | 15060000134715 | 15060000134715 | 1 | PA266788 | PM722914 |
| 15060000134723 | L15/dossiers | 15 | 15060000134722 | 15060000134722 | 1 | PA267440 | PM722522 |
| 15060000134730 | L15/dossiers | 15 | 15060000134729 | 15060000134729 | 1 | PA267585 | PM722978 |
| 15060000134737 | L15/dossiers | 15 | 15060000134736 | 15060000134736 | 1 | PA720614 | PM723016 |
| 15060000134741 | L15/dossiers | 15 | 15060000134740 | 15060000134740 | 1 | PA345619 | PM725692 |
| 15060000134742 | L15/dossiers | 15 | 15060000134740 | 15060000134740 | 2 | PA702191 | PM730058 |
| 15060000134835 | L15/dossiers | 15 | 15060000134834 | 15060000134834 | 1 | PA345619 | PM725692 |
| 15060000134836 | L15/dossiers | 15 | 15060000134834 | 15060000134834 | 2 | PA607846 | PM730066 |
| 15060000134859 | L15/dossiers | 15 | 15060000134858 | 15060000134858 | 1 | PA345619 | PM725692 |
| 15060000134866 | L15/dossiers | 15 | 15060000134865 | 15060000134865 | 1 | PA720892 | PM723106 |
| 15060000134875 | L15/dossiers | 15 | 15060000134874 | 15060000134874 | 1 | PA720846 | PM723094 |
| 15060000134894 | L15/dossiers | 15 | 15060000134893 | 15060000134893 | 1 | PA722142 | PM723484 |
| 15060000134912 | L15/dossiers | 15 | 15060000134911 | 15060000134911 | 1 | PA720286 | PM722918 |
| 15060000134927 | L15/dossiers | 15 | 15060000134926 | 15060000134926 | 1 | PA720210 | PM722892 |
| 15060000134934 | L15/dossiers | 15 | 15060000134933 | 15060000134933 | 1 | PA605991 | PM722660 |
| 15060000134941 | L15/dossiers | 15 | 15060000134940 | 15060000134940 | 1 | PA721202 | PM723202 |
| 15060000134961 | L15/dossiers | 15 | 15060000134960 | 15060000134960 | 1 | PA346218 | PM723348 |
| 15060000134968 | L15/dossiers | 15 | 15060000134967 | 15060000134967 | 1 | PA330240 | PM722492 |
| 15060000134975 | L15/dossiers | 15 | 15060000134974 | 15060000134974 | 1 | PA2796 | PM722510 |
| 15060000134982 | L15/dossiers | 15 | 15060000134981 | 15060000134981 | 1 | PA718784 | PM722456 |
| 15060000134989 | L15/dossiers | 15 | 15060000134988 | 15060000134988 | 1 | PA703482 | PM703642 |
| 15060000135013 | L15/dossiers | 15 | 15060000135012 | 15060000135012 | 1 | PA330240 | PM722492 |
| 15060000135020 | L15/dossiers | 15 | 15060000135019 | 15060000135019 | 1 | PA605991 | PM722660 |
| 15060000135027 | L15/dossiers | 15 | 15060000135026 | 15060000135026 | 1 | PA345619 | PM725692 |
| 15060000135028 | L15/dossiers | 15 | 15060000135026 | 15060000135026 | 2 | PA1872 | PM730104 |
| 15060000135060 | L15/dossiers | 15 | 15060000135059 | 15060000135059 | 1 | PA345619 | PM725692 |
| 15060000135061 | L15/dossiers | 15 | 15060000135059 | 15060000135059 | 2 | PA1872 | PM730104 |
| 15060000135096 | L15/dossiers | 15 | 15060000135095 | 15060000135095 | 1 | PA609520 | PM723508 |
| 15060000135112 | L15/dossiers | 15 | 15060000135111 | 15060000135111 | 1 | PA720846 | PM723094 |
| 15060000135126 | L15/dossiers | 15 | 15060000135125 | 15060000135125 | 1 | PA606171 | PM722632 |
| 15060000135201 | L15/dossiers | 15 | 15060000135200 | 15060000135200 | 1 | PA605036 | PM722444 |
| 15060000135211 | L15/dossiers | 15 | 15060000135210 | 15060000135210 | 1 | PA345619 | PM725692 |
| 15060000135219 | L15/dossiers | 15 | 15060000135218 | 15060000135218 | 1 | PA345619 | PM725692 |
| 15060000135226 | L15/dossiers | 15 | 15060000135225 | 15060000135225 | 1 | PA345619 | PM725692 |
| 15060000135289 | L15/dossiers | 15 | 15060000135288 | 15060000135288 | 1 | PA266774 | PM723526 |
| 15060000135296 | L15/dossiers | 15 | 15060000135295 | 15060000135295 | 1 | PA606212 | PM722662 |
| 15060000135303 | L15/dossiers | 15 | 15060000135302 | 15060000135302 | 1 | PA332747 | PM722798 |
| 15060000135311 | L15/dossiers | 15 | 15060000135310 | 15060000135310 | 1 | PA267260 | PM722476 |
| 15060000135315 | L15/dossiers | 15 | 15060000135314 | 15060000135314 | 1 | PA266797 | PM722884 |
| 15060000135319 | L15/dossiers | 15 | 15060000135318 | 15060000135318 | 1 | PA345619 | PM725692 |
| 15060000135320 | L15/dossiers | 15 | 15060000135318 | 15060000135318 | 2 | PA717169 | PM730074 |
| 15060000135327 | L15/dossiers | 15 | 15060000135326 | 15060000135326 | 1 | PA267785 | PM723310 |
| 15060000135334 | L15/dossiers | 15 | 15060000135333 | 15060000135333 | 1 | PA998 | PM723046 |
| 15060000135341 | L15/dossiers | 15 | 15060000135340 | 15060000135340 | 1 | PA998 | PM723046 |
| 15060000135348 | L15/dossiers | 15 | 15060000135347 | 15060000135347 | 1 | PA721314 | PM723236 |
| 15060000135355 | L15/dossiers | 15 | 15060000135354 | 15060000135354 | 1 | PA721314 | PM723236 |
| 15060000135362 | L15/dossiers | 15 | 15060000135361 | 15060000135361 | 1 | PA719946 | PM722808 |
| 15060000135369 | L15/dossiers | 15 | 15060000135368 | 15060000135368 | 1 | PA719488 | PM722676 |
| 15060000135391 | L15/dossiers | 15 | 15060000135390 | 15060000135390 | 1 | PA608416 | PM723540 |