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 |
|---|---|---|---|---|---|---|---|
| 15060000133313 | L15/dossiers | 15 | 15060000133312 | 15060000133312 | 1 | PA718838 | PM722474 |
| 15060000133324 | L15/dossiers | 15 | 15060000133323 | 15060000133323 | 1 | PA721202 | PM723202 |
| 15060000133331 | L15/dossiers | 15 | 15060000133330 | 15060000133330 | 1 | PA720892 | PM723106 |
| 15060000133338 | L15/dossiers | 15 | 15060000133337 | 15060000133337 | 1 | PA719946 | PM722808 |
| 15060000133345 | L15/dossiers | 15 | 15060000133344 | 15060000133344 | 1 | PA345619 | PM725692 |
| 15060000133352 | L15/dossiers | 15 | 15060000133351 | 15060000133351 | 1 | PA720746 | PM723064 |
| 15060000133360 | L15/dossiers | 15 | 15060000133359 | 15060000133359 | 1 | PA1206 | PM723354 |
| 15060000133367 | L15/dossiers | 15 | 15060000133366 | 15060000133366 | 1 | PA266788 | PM722914 |
| 15060000133374 | L15/dossiers | 15 | 15060000133373 | 15060000133373 | 1 | PA266788 | PM722914 |
| 15060000133381 | L15/dossiers | 15 | 15060000133380 | 15060000133380 | 1 | PA266788 | PM722914 |
| 15060000133388 | L15/dossiers | 15 | 15060000133387 | 15060000133387 | 1 | PA266788 | PM722914 |
| 15060000133395 | L15/dossiers | 15 | 15060000133394 | 15060000133394 | 1 | PA266788 | PM722914 |
| 15060000133402 | L15/dossiers | 15 | 15060000133401 | 15060000133401 | 1 | PA266788 | PM722914 |
| 15060000133409 | L15/dossiers | 15 | 15060000133408 | 15060000133408 | 1 | PA266788 | PM722914 |
| 15060000133419 | L15/dossiers | 15 | 15060000133418 | 15060000133418 | 1 | PA1695 | PM723322 |
| 15060000133427 | L15/dossiers | 15 | 15060000133426 | 15060000133426 | 1 | PA719946 | PM722808 |
| 15060000133434 | L15/dossiers | 15 | 15060000133433 | 15060000133433 | 1 | PA689 | PM723090 |
| 15060000133441 | L15/dossiers | 15 | 15060000133440 | 15060000133440 | 1 | PA345619 | PM725692 |
| 15060000133442 | L15/dossiers | 15 | 15060000133440 | 15060000133440 | 2 | PA331481 | PM730094 |
| 15060000133443 | L15/dossiers | 15 | 15060000133440 | 15060000133440 | 3 | PA607846 | PM730066 |
| 15060000133519 | L15/dossiers | 15 | 15060000133518 | 15060000133518 | 1 | PA719946 | PM722808 |
| 15060000133526 | L15/dossiers | 15 | 15060000133525 | 15060000133525 | 1 | PA608826 | PM723276 |
| 15060000133533 | L15/dossiers | 15 | 15060000133532 | 15060000133532 | 1 | PA689 | PM723090 |
| 15060000133540 | L15/dossiers | 15 | 15060000133539 | 15060000133539 | 1 | PA267527 | PM723274 |
| 15060000133555 | L15/dossiers | 15 | 15060000133554 | 15060000133554 | 1 | PA606171 | PM722632 |
| 15060000133563 | L15/dossiers | 15 | 15060000133562 | 15060000133562 | 1 | PA345619 | PM725692 |
| 15060000133593 | L15/dossiers | 15 | 15060000133592 | 15060000133592 | 1 | PA942 | PM722900 |
| 15060000133605 | L15/dossiers | 15 | 15060000133604 | 15060000133604 | 1 | PA346218 | PM723348 |
| 15060000133612 | L15/dossiers | 15 | 15060000133611 | 15060000133611 | 1 | PA721506 | PM723296 |
| 15060000133619 | L15/dossiers | 15 | 15060000133618 | 15060000133618 | 1 | PA330684 | PM722528 |
| 15060000133626 | L15/dossiers | 15 | 15060000133625 | 15060000133625 | 1 | PA330684 | PM722528 |
| 15060000133633 | L15/dossiers | 15 | 15060000133632 | 15060000133632 | 1 | PA429890 | PM543935 |
| 15060000133643 | L15/dossiers | 15 | 15060000133642 | 15060000133642 | 1 | PA266797 | PM722884 |
| 15060000133650 | L15/dossiers | 15 | 15060000133649 | 15060000133649 | 1 | PA345619 | PM725692 |
| 15060000133651 | L15/dossiers | 15 | 15060000133649 | 15060000133649 | 2 | PA331481 | PM730094 |
| 15060000133718 | L15/dossiers | 15 | 15060000133717 | 15060000133717 | 1 | PA345619 | PM725692 |
| 15060000133749 | L15/dossiers | 15 | 15060000133748 | 15060000133748 | 1 | PA718784 | PM722456 |
| 15060000133756 | L15/dossiers | 15 | 15060000133755 | 15060000133755 | 1 | PA718720 | PM722436 |
| 15060000133763 | L15/dossiers | 15 | 15060000133762 | 15060000133762 | 1 | PA304082 | PM430056 |
| 15060000133775 | L15/dossiers | 15 | 15060000133774 | 15060000133774 | 1 | PA1874 | PM722598 |
| 15060000133786 | L15/dossiers | 15 | 15060000133785 | 15060000133785 | 1 | PA609726 | PM723426 |
| 15060000133790 | L15/dossiers | 15 | 15060000133789 | 15060000133789 | 1 | PA345619 | PM725692 |
| 15060000133791 | L15/dossiers | 15 | 15060000133789 | 15060000133789 | 2 | PA717171 | PM730064 |
| 15060000133792 | L15/dossiers | 15 | 15060000133789 | 15060000133789 | 3 | PA415482 | PM730088 |
| 15060000133876 | L15/dossiers | 15 | 15060000133875 | 15060000133875 | 1 | PA345619 | PM725692 |
| 15060000133877 | L15/dossiers | 15 | 15060000133875 | 15060000133875 | 2 | PA607846 | PM730066 |
| 15060000133878 | L15/dossiers | 15 | 15060000133875 | 15060000133875 | 3 | PA331481 | PM730094 |
| 15060000133970 | L15/dossiers | 15 | 15060000133969 | 15060000133969 | 1 | PA718838 | PM722474 |
| 15060000133977 | L15/dossiers | 15 | 15060000133976 | 15060000133976 | 1 | PA267200 | PM722974 |
| 15060000133984 | L15/dossiers | 15 | 15060000133983 | 15060000133983 | 1 | PA1012 | PM722418 |