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 |
|---|---|---|---|---|---|---|---|
| 14060000102482 | L14/dossiers | 14 | 14060000102481 | 14060000102481 | 1 | PA346 | PM645086 |
| 14060000102492 | L14/dossiers | 14 | 14060000102491 | 14060000102491 | 1 | PA267622 | PM702957 |
| 14060000102493 | L14/dossiers | 14 | 14060000102491 | 14060000102491 | 2 | PA2825 | PM711565 |
| 14060000102549 | L14/dossiers | 14 | 14060000102548 | 14060000102548 | 1 | PA735 | PM645089 |
| 14060000102568 | L14/dossiers | 14 | 14060000102567 | 14060000102567 | 1 | PA267622 | PM700712 |
| 14060000102569 | L14/dossiers | 14 | 14060000102567 | 14060000102567 | 2 | PA2224 | PM700729 |
| 14060000102570 | L14/dossiers | 14 | 14060000102567 | 14060000102567 | 3 | PA2051 | PM701711 |
| 14060000102646 | L14/dossiers | 14 | 14060000102645 | 14060000102645 | 1 | PA1874 | PM645474 |
| 14060000102653 | L14/dossiers | 14 | 14060000102652 | 14060000102652 | 1 | PA563 | PM645307 |
| 14060000102663 | L14/dossiers | 14 | 14060000102662 | 14060000102662 | 1 | PA1886 | PM645099 |
| 14060000102776 | L14/dossiers | 14 | 14060000102775 | 14060000102775 | 1 | PA328 | PM653228 |
| 14060000102787 | L14/dossiers | 14 | 14060000102786 | 14060000102786 | 1 | PA267622 | PM702957 |
| 14060000102870 | L14/dossiers | 14 | 14060000102869 | 14060000102869 | 1 | PA335054 | PM645614 |
| 14060000102871 | L14/dossiers | 14 | 14060000102869 | 14060000102869 | 2 | PA608011 | PM645066 |
| 14060000102887 | L14/dossiers | 14 | 14060000102886 | 14060000102886 | 1 | PA2377 | PM645591 |
| 14060000102894 | L14/dossiers | 14 | 14060000102893 | 14060000102893 | 1 | PA2971 | PM645392 |
| 14060000102901 | L14/dossiers | 14 | 14060000102900 | 14060000102900 | 1 | PA1886 | PM645099 |
| 14060000102914 | L14/dossiers | 14 | 14060000102913 | 14060000102913 | 1 | PA610427 | PM645158 |
| 14060000102921 | L14/dossiers | 14 | 14060000102920 | 14060000102920 | 1 | PA689 | PM645113 |
| 14060000102928 | L14/dossiers | 14 | 14060000102927 | 14060000102927 | 1 | PA415482 | PM415579 |
| 14060000102940 | L14/dossiers | 14 | 14060000102939 | 14060000102939 | 1 | PA333134 | PM645341 |
| 14060000102947 | L14/dossiers | 14 | 14060000102946 | 14060000102946 | 1 | PA267591 | PM645573 |
| 14060000102954 | L14/dossiers | 14 | 14060000102953 | 14060000102953 | 1 | PA230 | PM645553 |
| 14060000102958 | L14/dossiers | 14 | 14060000102957 | 14060000102957 | 1 | PA1699 | PM645390 |
| 14060000102965 | L14/dossiers | 14 | 14060000102964 | 14060000102964 | 1 | PA267622 | PM702957 |
| 14060000102966 | L14/dossiers | 14 | 14060000102964 | 14060000102964 | 2 | PA1268 | PM702961 |
| 14060000102973 | L14/dossiers | 14 | 14060000102972 | 14060000102972 | 1 | PA610775 | PM645309 |
| 14060000102974 | L14/dossiers | 14 | 14060000102972 | 14060000102972 | 2 | PA266797 | PM645338 |
| 14060000102996 | L14/dossiers | 14 | 14060000102995 | 14060000102995 | 1 | PA334149 | PM645127 |
| 14060000103003 | L14/dossiers | 14 | 14060000103002 | 14060000103002 | 1 | PA267285 | PM645140 |
| 14060000103010 | L14/dossiers | 14 | 14060000103009 | 14060000103009 | 1 | PA328 | PM653228 |
| 14060000103011 | L14/dossiers | 14 | 14060000103009 | 14060000103009 | 2 | PA1268 | PM653525 |
| 14060000103041 | L14/dossiers | 14 | 14060000103040 | 14060000103040 | 1 | PA328 | PM653228 |
| 14060000103042 | L14/dossiers | 14 | 14060000103040 | 14060000103040 | 2 | PA2791 | PM653325 |
| 14060000103108 | L14/dossiers | 14 | 14060000103107 | 14060000103107 | 1 | PA1483 | PM645274 |
| 14060000103115 | L14/dossiers | 14 | 14060000103114 | 14060000103114 | 1 | PA605922 | PM645493 |
| 14060000103119 | L14/dossiers | 14 | 14060000103118 | 14060000103118 | 1 | PA1886 | PM645099 |
| 14060000103134 | L14/dossiers | 14 | 14060000103133 | 14060000103133 | 1 | PA1931 | PM645042 |
| 14060000103141 | L14/dossiers | 14 | 14060000103140 | 14060000103140 | 1 | PA267785 | PM645359 |
| 14060000103148 | L14/dossiers | 14 | 14060000103147 | 14060000103147 | 1 | PA606478 | PM645457 |
| 14060000103155 | L14/dossiers | 14 | 14060000103154 | 14060000103154 | 1 | PA606478 | PM645457 |
| 14060000103165 | L14/dossiers | 14 | 14060000103164 | 14060000103164 | 1 | PA1874 | PM645474 |
| 14060000103172 | L14/dossiers | 14 | 14060000103171 | 14060000103171 | 1 | PA2277 | PM645135 |
| 14060000103179 | L14/dossiers | 14 | 14060000103178 | 14060000103178 | 1 | PA267429 | PM645130 |
| 14060000103186 | L14/dossiers | 14 | 14060000103185 | 14060000103185 | 1 | PA2876 | PM645355 |
| 14060000103193 | L14/dossiers | 14 | 14060000103192 | 14060000103192 | 1 | PA335054 | PM645614 |
| 14060000103208 | L14/dossiers | 14 | 14060000103207 | 14060000103207 | 1 | PA267622 | PM702957 |
| 14060000103209 | L14/dossiers | 14 | 14060000103207 | 14060000103207 | 2 | PA328 | PM711554 |
| 14060000103243 | L14/dossiers | 14 | 14060000103242 | 14060000103242 | 1 | PA328 | PM653228 |
| 14060000103244 | L14/dossiers | 14 | 14060000103242 | 14060000103242 | 2 | PA1268 | PM653525 |