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 |
|---|---|---|---|---|---|---|---|
| 17060000142929 | L17/dossiers | 17 | 17060000142928 | 17060000142928 | 1 | PA795876 | PM843725 |
| 17060000142936 | L17/dossiers | 17 | 17060000142935 | 17060000142935 | 1 | PA795820 | PM843713 |
| 17060000142943 | L17/dossiers | 17 | 17060000142942 | 17060000142942 | 1 | PA793342 | PM842345 |
| 17060000142950 | L17/dossiers | 17 | 17060000142949 | 17060000142949 | 1 | PA793322 | PM840246 |
| 17060000142957 | L17/dossiers | 17 | 17060000142956 | 17060000142956 | 1 | PA793736 | PM842693 |
| 17060000142964 | L17/dossiers | 17 | 17060000142963 | 17060000142963 | 1 | PA841575 | PM843143 |
| 17060000142971 | L17/dossiers | 17 | 17060000142970 | 17060000142970 | 1 | PA793948 | PM842615 |
| 17060000142978 | L17/dossiers | 17 | 17060000142977 | 17060000142977 | 1 | PA841199 | PM842792 |
| 17060000142985 | L17/dossiers | 17 | 17060000142984 | 17060000142984 | 1 | PA267200 | PM843098 |
| 17060000142992 | L17/dossiers | 17 | 17060000142991 | 17060000142991 | 1 | PA719024 | PM842390 |
| 17060000142999 | L17/dossiers | 17 | 17060000142998 | 17060000142998 | 1 | PA841761 | PM843320 |
| 17060000143006 | L17/dossiers | 17 | 17060000143005 | 17060000143005 | 1 | PA720146 | PM842849 |
| 17060000143013 | L17/dossiers | 17 | 17060000143012 | 17060000143012 | 1 | PA817203 | PM842978 |
| 17060000143072 | L17/dossiers | 17 | 17060000143071 | 17060000143071 | 1 | PA796010 | PM843743 |
| 17060000143079 | L17/dossiers | 17 | 17060000143078 | 17060000143078 | 1 | PA841047 | PM842675 |
| 17060000143086 | L17/dossiers | 17 | 17060000143085 | 17060000143085 | 1 | PA721234 | PM843692 |
| 17060000143093 | L17/dossiers | 17 | 17060000143092 | 17060000143092 | 1 | PA720838 | PM843671 |
| 17060000143100 | L17/dossiers | 17 | 17060000143099 | 17060000143099 | 1 | PA842311 | PM843803 |
| 17060000143142 | L17/dossiers | 17 | 17060000143141 | 17060000143141 | 1 | PA794114 | PM842888 |
| 17060000143149 | L17/dossiers | 17 | 17060000143148 | 17060000143148 | 1 | PA793664 | PM842549 |
| 17060000143165 | L17/dossiers | 17 | 17060000143164 | 17060000143164 | 1 | PA703532 | PM775699 |
| 17060000143172 | L17/dossiers | 17 | 17060000143171 | 17060000143171 | 1 | PA429889 | PM829767 |
| 17060000143179 | L17/dossiers | 17 | 17060000143178 | 17060000143178 | 1 | PA708632 | PM775667 |
| 17060000143199 | L17/dossiers | 17 | 17060000143198 | 17060000143198 | 1 | PA721960 | PM840378 |
| 17060000143206 | L17/dossiers | 17 | 17060000143205 | 17060000143205 | 1 | PA842187 | PM843704 |
| 17060000143213 | L17/dossiers | 17 | 17060000143212 | 17060000143212 | 1 | PA722382 | PM843314 |
| 17060000143221 | L17/dossiers | 17 | 17060000143220 | 17060000143220 | 1 | PA841885 | PM843446 |
| 17060000143228 | L17/dossiers | 17 | 17060000143227 | 17060000143227 | 1 | PA793374 | PM842477 |
| 17060000143235 | L17/dossiers | 17 | 17060000143234 | 17060000143234 | 1 | PA266808 | PM843347 |
| 17060000143239 | L17/dossiers | 17 | 17060000143238 | 17060000143238 | 1 | PA588884 | PM840450 |
| 17060000143243 | L17/dossiers | 17 | 17060000143242 | 17060000143242 | 1 | PA841769 | PM843323 |
| 17060000143250 | L17/dossiers | 17 | 17060000143249 | 17060000143249 | 1 | PA795026 | PM843368 |
| 17060000143254 | L17/dossiers | 17 | 17060000143253 | 17060000143253 | 1 | PA795228 | PM840447 |
| 17060000143258 | L17/dossiers | 17 | 17060000143257 | 17060000143257 | 1 | PA721426 | PM843356 |
| 17060000143262 | L17/dossiers | 17 | 17060000143261 | 17060000143261 | 1 | PA795176 | PM843788 |
| 17060000143269 | L17/dossiers | 17 | 17060000143268 | 17060000143268 | 1 | PA775182 | PM775464 |
| 17060000143276 | L17/dossiers | 17 | 17060000143275 | 17060000143275 | 1 | PA747420 | PM775761 |
| 17060000143296 | L17/dossiers | 17 | 17060000143295 | 17060000143295 | 1 | PA703537 | PM775721 |
| 17060000143303 | L17/dossiers | 17 | 17060000143302 | 17060000143302 | 1 | PA840765 | PM842447 |
| 17060000143313 | L17/dossiers | 17 | 17060000143312 | 17060000143312 | 1 | PA721896 | PM840405 |
| 17060000143323 | L17/dossiers | 17 | 17060000143322 | 17060000143322 | 1 | PA643210 | PM873637 |
| 17060000143330 | L17/dossiers | 17 | 17060000143329 | 17060000143329 | 1 | PA732419 | PM775647 |
| 17060000143337 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 1 | PA429886 | PM829757 |
| 17060000143338 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 2 | PA736175 | PM829795 |
| 17060000143339 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 3 | PA736173 | PM829799 |
| 17060000143340 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 4 | PA757676 | PM829801 |
| 17060000143341 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 5 | PA775172 | PM775474 |
| 17060000143342 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 6 | PA827898 | PM828454 |
| 17060000143343 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 7 | PA850008 | PM850016 |
| 17060000143344 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 8 | PA827912 | PM828488 |