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 |
|---|---|---|---|---|---|---|---|
| 15060000154371 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 33 | PA425322 | PM736282 |
| 15060000154372 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 34 | PA301592 | PM736375 |
| 15060000154373 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 35 | PA703534 | PM703549 |
| 15060000154374 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 36 | PA304076 | PM703694 |
| 15060000154375 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 37 | PA227029 | PM736306 |
| 15060000154376 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 38 | PA736183 | PM736405 |
| 15060000154377 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 39 | PA415451 | PM703594 |
| 15060000154378 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 40 | PA1344 | PM736383 |
| 15060000154379 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 41 | PA429854 | PM736335 |
| 15060000154380 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 42 | PA342665 | PM736382 |
| 15060000154381 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 43 | PA415486 | PM703623 |
| 15060000154382 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 44 | PA736166 | PM736435 |
| 15060000154383 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 45 | PA736167 | PM736327 |
| 15060000154384 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 46 | PA703518 | PM703704 |
| 15060000154385 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 47 | PA744079 | PM744082 |
| 15060000154386 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 48 | PA711156 | PM736319 |
| 15060000154387 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 49 | PA703497 | PM703569 |
| 15060000154388 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 50 | PA703498 | PM736260 |
| 15060000154389 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 51 | PA1183 | PM706347 |
| 15060000154390 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 52 | PA1183 | PM706347 |
| 15060000154391 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 53 | PA267328 | PM703547 |
| 15060000154392 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 54 | PA267018 | PM703564 |
| 15060000154393 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 55 | PA267989 | PM703655 |
| 15060000154394 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 56 | PA736176 | PM736434 |
| 15060000154395 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 57 | PA415495 | PM703579 |
| 15060000154396 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 58 | PA513 | PM703605 |
| 15060000154397 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 59 | PA394676 | PM703550 |
| 15060000154398 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 60 | PA736198 | PM736406 |
| 15060000154399 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 61 | PA267762 | PM736366 |
| 15060000154400 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 62 | PA736200 | PM736285 |
| 15060000154401 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 63 | PA736163 | PM736253 |
| 15060000154402 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 64 | PA703541 | PM703644 |
| 15060000154403 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 65 | PA341381 | PM703618 |
| 15060000154404 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 66 | PA703522 | PM703702 |
| 15060000154405 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 67 | PA304108 | PM736399 |
| 15060000154412 | L15/dossiers | 15 | 15060000154411 | 15060000154411 | 1 | PA736247 | PM736281 |
| 15060000154422 | L15/dossiers | 15 | 15060000154421 | 15060000154421 | 1 | PA718838 | PM722474 |
| 15060000154429 | L15/dossiers | 15 | 15060000154428 | 15060000154428 | 1 | PA719930 | PM722804 |
| 15060000154446 | L15/dossiers | 15 | 15060000154445 | 15060000154445 | 1 | PA267233 | PM723500 |
| 15060000154464 | L15/dossiers | 15 | 15060000154463 | 15060000154463 | 1 | PA333285 | PM722906 |
| 15060000154487 | L15/dossiers | 15 | 15060000154486 | 15060000154486 | 1 | PA607553 | PM722956 |
| 15060000154504 | L15/dossiers | 15 | 15060000154503 | 15060000154503 | 1 | PA605069 | PM722424 |
| 15060000154519 | L15/dossiers | 15 | 15060000154518 | 15060000154518 | 1 | PA719578 | PM722702 |
| 15060000154526 | L15/dossiers | 15 | 15060000154525 | 15060000154525 | 1 | PA721932 | PM734586 |
| 15060000154533 | L15/dossiers | 15 | 15060000154532 | 15060000154532 | 1 | PA736247 | PM736281 |
| 15060000154540 | L15/dossiers | 15 | 15060000154539 | 15060000154539 | 1 | PA2116 | PM736339 |
| 15060000154554 | L15/dossiers | 15 | 15060000154553 | 15060000154553 | 1 | PA721466 | PM723284 |
| 15060000154555 | L15/dossiers | 15 | 15060000154553 | 15060000154553 | 2 | PA1695 | PM723322 |
| 15060000154556 | L15/dossiers | 15 | 15060000154553 | 15060000154553 | 3 | PA721418 | PM723268 |
| 15060000154557 | L15/dossiers | 15 | 15060000154553 | 15060000154553 | 4 | PA609590 | PM723326 |