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 |
|---|---|---|---|---|---|---|---|
| 15060000169036 | L15/dossiers | 15 | 15060000169035 | 15060000169035 | 1 | PA719578 | PM722702 |
| 15060000169043 | L15/dossiers | 15 | 15060000169042 | 15060000169042 | 1 | PA773441 | PM773491 |
| 15060000169044 | L15/dossiers | 15 | 15060000169042 | 15060000169042 | 2 | PA642788 | PM773495 |
| 15060000169082 | L15/dossiers | 15 | 15060000169081 | 15060000169081 | 1 | PA721398 | PM723262 |
| 15060000169092 | L15/dossiers | 15 | 15060000169091 | 15060000169091 | 1 | PA773441 | PM773491 |
| 15060000169102 | L15/dossiers | 15 | 15060000169101 | 15060000169101 | 1 | PA608016 | PM723024 |
| 15060000169106 | L15/dossiers | 15 | 15060000169105 | 15060000169105 | 1 | PA1012 | PM722418 |
| 15060000169113 | L15/dossiers | 15 | 15060000169112 | 15060000169112 | 1 | PA2377 | PM723550 |
| 15060000169120 | L15/dossiers | 15 | 15060000169119 | 15060000169119 | 1 | PA736201 | PM736347 |
| 15060000169136 | L15/dossiers | 15 | 15060000169135 | 15060000169135 | 1 | PA719020 | PM774184 |
| 15060000169146 | L15/dossiers | 15 | 15060000169145 | 15060000169145 | 1 | PA721506 | PM723296 |
| 15060000169153 | L15/dossiers | 15 | 15060000169152 | 15060000169152 | 1 | PA721486 | PM723290 |
| 15060000169160 | L15/dossiers | 15 | 15060000169159 | 15060000169159 | 1 | PA1874 | PM722598 |
| 15060000169167 | L15/dossiers | 15 | 15060000169166 | 15060000169166 | 1 | PA719608 | PM722710 |
| 15060000169177 | L15/dossiers | 15 | 15060000169176 | 15060000169176 | 1 | PA722030 | PM723454 |
| 15060000169184 | L15/dossiers | 15 | 15060000169183 | 15060000169183 | 1 | PA722252 | PM723518 |
| 15060000169191 | L15/dossiers | 15 | 15060000169190 | 15060000169190 | 1 | PA267780 | PM723504 |
| 15060000169198 | L15/dossiers | 15 | 15060000169197 | 15060000169197 | 1 | PA1206 | PM723354 |
| 15060000169205 | L15/dossiers | 15 | 15060000169204 | 15060000169204 | 1 | PA722202 | PM723502 |
| 15060000169212 | L15/dossiers | 15 | 15060000169211 | 15060000169211 | 1 | PA2377 | PM723550 |
| 15060000169219 | L15/dossiers | 15 | 15060000169218 | 15060000169218 | 1 | PA429869 | PM736350 |
| 15060000169226 | L15/dossiers | 15 | 15060000169225 | 15060000169225 | 1 | PA744079 | PM744082 |
| 15060000169233 | L15/dossiers | 15 | 15060000169232 | 15060000169232 | 1 | PA773441 | PM773491 |
| 15060000169267 | L15/dossiers | 15 | 15060000169266 | 15060000169266 | 1 | PA718784 | PM722456 |
| 15060000169271 | L15/dossiers | 15 | 15060000169270 | 15060000169270 | 1 | PA266788 | PM722914 |
| 15060000169278 | L15/dossiers | 15 | 15060000169277 | 15060000169277 | 1 | PA722038 | PM723456 |
| 15060000169285 | L15/dossiers | 15 | 15060000169284 | 15060000169284 | 1 | PA330909 | PM722548 |
| 15060000169292 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 1 | PA415446 | PM703678 |
| 15060000169293 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 2 | PA429858 | PM736268 |
| 15060000169294 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 3 | PA429842 | PM736373 |
| 15060000169295 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 4 | PA343988 | PM736310 |
| 15060000169296 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 5 | PA736192 | PM736353 |
| 15060000169297 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 6 | PA736211 | PM736410 |
| 15060000169298 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 7 | PA744079 | PM744082 |
| 15060000169299 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 8 | PA425322 | PM736282 |
| 15060000169300 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 9 | PA1001 | PM736371 |
| 15060000169301 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 10 | PA736186 | PM736396 |
| 15060000169302 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 11 | PA267081 | PM703617 |
| 15060000169303 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 12 | PA736239 | PM736317 |
| 15060000169304 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 13 | PA703503 | PM703582 |
| 15060000169305 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 14 | PA415495 | PM703579 |
| 15060000169306 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 15 | PA703480 | PM703624 |
| 15060000169307 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 16 | PA703515 | PM703592 |
| 15060000169308 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 17 | PA341381 | PM703618 |
| 15060000169309 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 18 | PA720634 | PM736312 |
| 15060000169310 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 19 | PA429851 | PM736305 |
| 15060000169311 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 20 | PA703500 | PM703574 |
| 15060000169312 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 21 | PA736237 | PM736417 |
| 15060000169313 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 22 | PA736240 | PM736279 |
| 15060000169314 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 23 | PA708632 | PM708643 |