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 |
|---|---|---|---|---|---|---|---|
| 15060000166440 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 29 | PA404656 | PM736328 |
| 15060000166441 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 30 | PA736218 | PM736257 |
| 15060000166442 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 31 | PA703520 | PM703665 |
| 15060000166443 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 32 | PA1344 | PM736383 |
| 15060000166444 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 33 | PA415454 | PM703689 |
| 15060000166445 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 34 | PA703487 | PM703711 |
| 15060000166446 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 35 | PA304108 | PM736399 |
| 15060000166447 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 36 | PA715322 | PM715327 |
| 15060000166448 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 37 | PA415486 | PM703623 |
| 15060000166449 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 38 | PA267907 | PM703591 |
| 15060000166450 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 39 | PA267081 | PM703617 |
| 15060000166451 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 40 | PA415495 | PM703579 |
| 15060000166452 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 41 | PA703515 | PM703592 |
| 15060000166453 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 42 | PA736203 | PM736432 |
| 15060000166454 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 43 | PA703488 | PM703632 |
| 15060000166455 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 44 | PA394676 | PM703550 |
| 15060000166456 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 45 | PA304000 | PM703599 |
| 15060000166457 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 46 | PA736210 | PM736254 |
| 15060000166458 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 47 | PA415451 | PM703594 |
| 15060000166459 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 48 | PA736186 | PM736396 |
| 15060000166460 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 49 | PA343775 | PM736367 |
| 15060000166461 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 50 | PA341381 | PM703618 |
| 15060000166462 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 51 | PA703537 | PM703595 |
| 15060000166463 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 52 | PA703516 | PM703559 |
| 15060000166464 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 53 | PA2042 | PM703682 |
| 15060000166465 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 54 | PA703497 | PM703569 |
| 15060000166466 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 55 | PA736224 | PM736403 |
| 15060000166467 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 56 | PA736204 | PM736338 |
| 15060000166468 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 57 | PA736183 | PM736405 |
| 15060000166469 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 58 | PA758716 | PM758720 |
| 15060000166470 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 59 | PA758716 | PM758720 |
| 15060000166471 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 60 | PA343988 | PM736310 |
| 15060000166472 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 61 | PA736200 | PM736285 |
| 15060000166473 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 62 | PA304076 | PM703694 |
| 15060000166474 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 63 | PA703485 | PM703654 |
| 15060000166475 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 64 | PA758431 | PM758701 |
| 15060000166476 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 65 | PA757678 | PM757684 |
| 15060000166477 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 66 | PA227094 | PM736386 |
| 15060000166478 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 67 | PA345785 | PM736294 |
| 15060000166479 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 68 | PA703527 | PM703580 |
| 15060000166480 | L15/dossiers | 15 | 15060000166411 | 15060000166411 | 69 | PA736196 | PM736370 |
| 15060000166491 | L15/dossiers | 15 | 15060000166490 | 15060000166490 | 1 | PA330240 | PM722492 |
| 15060000166498 | L15/dossiers | 15 | 15060000166497 | 15060000166497 | 1 | PA721474 | PM723286 |
| 15060000166505 | L15/dossiers | 15 | 15060000166504 | 15060000166504 | 1 | PA719092 | PM722560 |
| 15060000166512 | L15/dossiers | 15 | 15060000166511 | 15060000166511 | 1 | PA720846 | PM723094 |
| 15060000166519 | L15/dossiers | 15 | 15060000166518 | 15060000166518 | 1 | PA713448 | PM722452 |
| 15060000166526 | L15/dossiers | 15 | 15060000166525 | 15060000166525 | 1 | PA2538 | PM703570 |
| 15060000166536 | L15/dossiers | 15 | 15060000166535 | 15060000166535 | 1 | PA721246 | PM723214 |
| 15060000166546 | L15/dossiers | 15 | 15060000166545 | 15060000166545 | 1 | PA721286 | PM723224 |
| 15060000166550 | L15/dossiers | 15 | 15060000166549 | 15060000166549 | 1 | PA773441 | PM773491 |