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 |
|---|---|---|---|---|---|---|---|
| 17060000132388 | L17/dossiers | 17 | 17060000132327 | 17060000132327 | 61 | PA828010 | PM828832 |
| 17060000132389 | L17/dossiers | 17 | 17060000132327 | 17060000132327 | 62 | PA775294 | PM775580 |
| 17060000132390 | L17/dossiers | 17 | 17060000132327 | 17060000132327 | 63 | PA828014 | PM828818 |
| 17060000132391 | L17/dossiers | 17 | 17060000132327 | 17060000132327 | 64 | PA828018 | PM828882 |
| 17060000132392 | L17/dossiers | 17 | 17060000132327 | 17060000132327 | 65 | PA828022 | PM828870 |
| 17060000132410 | L17/dossiers | 17 | 17060000132409 | 17060000132409 | 1 | PA841215 | PM842801 |
| 17060000132420 | L17/dossiers | 17 | 17060000132419 | 17060000132419 | 1 | PA719890 | PM842855 |
| 17060000132424 | L17/dossiers | 17 | 17060000132423 | 17060000132423 | 1 | PA775236 | PM775542 |
| 17060000132431 | L17/dossiers | 17 | 17060000132430 | 17060000132430 | 1 | PA703510 | PM859251 |
| 17060000132438 | L17/dossiers | 17 | 17060000132437 | 17060000132437 | 1 | PA703510 | PM859251 |
| 17060000132445 | L17/dossiers | 17 | 17060000132444 | 17060000132444 | 1 | PA827928 | PM828538 |
| 17060000132465 | L17/dossiers | 17 | 17060000132464 | 17060000132464 | 1 | PA720256 | PM843041 |
| 17060000132469 | L17/dossiers | 17 | 17060000132468 | 17060000132468 | 1 | PA794270 | PM842972 |
| 17060000132480 | L17/dossiers | 17 | 17060000132479 | 17060000132479 | 1 | PA719338 | PM842654 |
| 17060000132504 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 1 | PA605888 | PM775604 |
| 17060000132505 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 2 | PA827920 | PM828574 |
| 17060000132506 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 3 | PA606375 | PM775602 |
| 17060000132507 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 4 | PA429889 | PM829767 |
| 17060000132508 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 5 | PA708633 | PM775669 |
| 17060000132509 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 6 | PA415477 | PM775809 |
| 17060000132510 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 7 | PA342564 | PM829509 |
| 17060000132511 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 8 | PA736234 | PM829887 |
| 17060000132512 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 9 | PA643028 | PM829316 |
| 17060000132513 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 10 | PA828018 | PM828882 |
| 17060000132514 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 11 | PA828010 | PM828832 |
| 17060000132515 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 12 | PA775256 | PM775546 |
| 17060000132516 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 13 | PA775196 | PM775482 |
| 17060000132517 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 14 | PA642982 | PM829146 |
| 17060000132518 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 15 | PA415488 | PM775641 |
| 17060000132519 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 16 | PA736214 | PM829883 |
| 17060000132520 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 17 | PA429835 | PM829719 |
| 17060000132521 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 18 | PA828022 | PM828870 |
| 17060000132522 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 19 | PA732419 | PM775647 |
| 17060000132523 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 20 | PA610850 | PM828634 |
| 17060000132524 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 21 | PA827994 | PM828782 |
| 17060000132525 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 22 | PA703512 | PM775665 |
| 17060000132526 | L17/dossiers | 17 | 17060000132503 | 17060000132503 | 23 | PA775254 | PM775556 |
| 17060000132533 | L17/dossiers | 17 | 17060000132532 | 17060000132532 | 1 | PA842311 | PM843803 |
| 17060000132560 | L17/dossiers | 17 | 17060000132559 | 17060000132559 | 1 | PA794994 | PM858360 |
| 17060000132567 | L17/dossiers | 17 | 17060000132566 | 17060000132566 | 1 | PA840665 | PM842336 |
| 17060000132571 | L17/dossiers | 17 | 17060000132570 | 17060000132570 | 1 | PA841017 | PM842636 |
| 17060000132578 | L17/dossiers | 17 | 17060000132577 | 17060000132577 | 1 | PA721960 | PM840378 |
| 17060000132586 | L17/dossiers | 17 | 17060000132585 | 17060000132585 | 1 | PA605888 | PM775604 |
| 17060000132587 | L17/dossiers | 17 | 17060000132585 | 17060000132585 | 2 | PA606375 | PM775602 |
| 17060000132588 | L17/dossiers | 17 | 17060000132585 | 17060000132585 | 3 | PA736181 | PM829839 |
| 17060000132625 | L17/dossiers | 17 | 17060000132624 | 17060000132624 | 1 | PA795244 | PM843749 |
| 17060000132629 | L17/dossiers | 17 | 17060000132628 | 17060000132628 | 1 | PA841191 | PM842789 |
| 17060000132636 | L17/dossiers | 17 | 17060000132635 | 17060000132635 | 1 | PA335054 | PM843332 |
| 17060000132643 | L17/dossiers | 17 | 17060000132642 | 17060000132642 | 1 | PA795616 | PM840462 |
| 17060000132661 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 1 | PA827978 | PM828730 |