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 |
|---|---|---|---|---|---|---|---|
| 15060000168200 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 4 | PA513 | PM703605 |
| 15060000168201 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 5 | PA429894 | PM736364 |
| 15060000168202 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 6 | PA756685 | PM756689 |
| 15060000168203 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 7 | PA772756 | PM772768 |
| 15060000168204 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 8 | PA429836 | PM736345 |
| 15060000168205 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 9 | PA429845 | PM736278 |
| 15060000168206 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 10 | PA736195 | PM736357 |
| 15060000168207 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 11 | PA736228 | PM736380 |
| 15060000168208 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 12 | PA736173 | PM736369 |
| 15060000168209 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 13 | PA703509 | PM703687 |
| 15060000168210 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 14 | PA736181 | PM736416 |
| 15060000168211 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 15 | PA429866 | PM736287 |
| 15060000168212 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 16 | PA678263 | PM736330 |
| 15060000168213 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 17 | PA1978 | PM736337 |
| 15060000168214 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 18 | PA736189 | PM736363 |
| 15060000168215 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 19 | PA736243 | PM736413 |
| 15060000168216 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 20 | PA736209 | PM736400 |
| 15060000168217 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 21 | PA703499 | PM703641 |
| 15060000168218 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 22 | PA736175 | PM736344 |
| 15060000168219 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 23 | PA303995 | PM703611 |
| 15060000168220 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 24 | PA736201 | PM736347 |
| 15060000168221 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 25 | PA736217 | PM736384 |
| 15060000168228 | L15/dossiers | 15 | 15060000168227 | 15060000168227 | 1 | PA773441 | PM773491 |
| 15060000168267 | L15/dossiers | 15 | 15060000168266 | 15060000168266 | 1 | PA429887 | PM736274 |
| 15060000168274 | L15/dossiers | 15 | 15060000168273 | 15060000168273 | 1 | PA429858 | PM736268 |
| 15060000168275 | L15/dossiers | 15 | 15060000168273 | 15060000168273 | 2 | PA703490 | PM703631 |
| 15060000168276 | L15/dossiers | 15 | 15060000168273 | 15060000168273 | 3 | PA426327 | PM703630 |
| 15060000168283 | L15/dossiers | 15 | 15060000168282 | 15060000168282 | 1 | PA721142 | PM723186 |
| 15060000168294 | L15/dossiers | 15 | 15060000168293 | 15060000168293 | 1 | PA722150 | PM723486 |
| 15060000168301 | L15/dossiers | 15 | 15060000168300 | 15060000168300 | 1 | PA718926 | PM722502 |
| 15060000168308 | L15/dossiers | 15 | 15060000168307 | 15060000168307 | 1 | PA718926 | PM722502 |
| 15060000168312 | L15/dossiers | 15 | 15060000168311 | 15060000168311 | 1 | PA721202 | PM723202 |
| 15060000168319 | L15/dossiers | 15 | 15060000168318 | 15060000168318 | 1 | PA721506 | PM723296 |
| 15060000168326 | L15/dossiers | 15 | 15060000168325 | 15060000168325 | 1 | PA267440 | PM722522 |
| 15060000168333 | L15/dossiers | 15 | 15060000168332 | 15060000168332 | 1 | PA267440 | PM722522 |
| 15060000168340 | L15/dossiers | 15 | 15060000168339 | 15060000168339 | 1 | PA268019 | PM723092 |
| 15060000168347 | L15/dossiers | 15 | 15060000168346 | 15060000168346 | 1 | PA267318 | PM723260 |
| 15060000168354 | L15/dossiers | 15 | 15060000168353 | 15060000168353 | 1 | PA720278 | PM722916 |
| 15060000168366 | L15/dossiers | 15 | 15060000168365 | 15060000168365 | 1 | PA722126 | PM723478 |
| 15060000168378 | L15/dossiers | 15 | 15060000168377 | 15060000168377 | 1 | PA719092 | PM722560 |
| 15060000168385 | L15/dossiers | 15 | 15060000168384 | 15060000168384 | 1 | PA722260 | PM723520 |
| 15060000168399 | L15/dossiers | 15 | 15060000168398 | 15060000168398 | 1 | PA721246 | PM723214 |
| 15060000168505 | L15/dossiers | 15 | 15060000168504 | 15060000168504 | 1 | PA267318 | PM723260 |
| 15060000168512 | L15/dossiers | 15 | 15060000168511 | 15060000168511 | 1 | PA266788 | PM722914 |
| 15060000168519 | L15/dossiers | 15 | 15060000168518 | 15060000168518 | 1 | PA721142 | PM723186 |
| 15060000168532 | L15/dossiers | 15 | 15060000168531 | 15060000168531 | 1 | PA744079 | PM744082 |
| 15060000168539 | L15/dossiers | 15 | 15060000168538 | 15060000168538 | 1 | PA720606 | PM723014 |
| 15060000168546 | L15/dossiers | 15 | 15060000168545 | 15060000168545 | 1 | PA606098 | PM722642 |
| 15060000168553 | L15/dossiers | 15 | 15060000168552 | 15060000168552 | 1 | PA720892 | PM723106 |
| 15060000168560 | L15/dossiers | 15 | 15060000168559 | 15060000168559 | 1 | PA773441 | PM773491 |