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 |
|---|---|---|---|---|---|---|---|
| 15060000185510 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 32 | PA736161 | PM736421 |
| 15060000185511 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 33 | PA703509 | PM775687 |
| 15060000185512 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 34 | PA736181 | PM736416 |
| 15060000185513 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 35 | PA736225 | PM736334 |
| 15060000185514 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 36 | PA703536 | PM775719 |
| 15060000185515 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 37 | PA736229 | PM736389 |
| 15060000185516 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 38 | PA736167 | PM736327 |
| 15060000185517 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 39 | PA429860 | PM736398 |
| 15060000185518 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 40 | PA605888 | PM775604 |
| 15060000185519 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 41 | PA415449 | PM775793 |
| 15060000185520 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 42 | PA342564 | PM736388 |
| 15060000185521 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 43 | PA268048 | PM736422 |
| 15060000185522 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 44 | PA429888 | PM736379 |
| 15060000185523 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 45 | PA2074 | PM775677 |
| 15060000185524 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 46 | PA775254 | PM775556 |
| 15060000185525 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 47 | PA429844 | PM736276 |
| 15060000185526 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 48 | PA775256 | PM775546 |
| 15060000185527 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 49 | PA703512 | PM775665 |
| 15060000185528 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 50 | PA643211 | PM775749 |
| 15060000185529 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 51 | PA775268 | PM775574 |
| 15060000185530 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 52 | PA606375 | PM775602 |
| 15060000185531 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 53 | PA736209 | PM736400 |
| 15060000185532 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 54 | PA703505 | PM775679 |
| 15060000185533 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 55 | PA775274 | PM775560 |
| 15060000185534 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 56 | PA703511 | PM775685 |
| 15060000185535 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 57 | PA429883 | PM736355 |
| 15060000185536 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 58 | PA429889 | PM736313 |
| 15060000185537 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 59 | PA429889 | PM736313 |
| 15060000185538 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 60 | PA775290 | PM775576 |
| 15060000185539 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 61 | PA2774 | PM736307 |
| 15060000185540 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 62 | PA736214 | PM736290 |
| 15060000185541 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 63 | PA736217 | PM736384 |
| 15060000185542 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 64 | PA227096 | PM736342 |
| 15060000185543 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 65 | PA227096 | PM736342 |
| 15060000185544 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 66 | PA775294 | PM775580 |
| 15060000185545 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 67 | PA2870 | PM736316 |
| 15060000185546 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 68 | PA2870 | PM736316 |
| 15060000185547 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 69 | PA736162 | PM736320 |
| 15060000185548 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 70 | PA429852 | PM736275 |
| 15060000185558 | L15/dossiers | 15 | 15060000185557 | 15060000185557 | 1 | PA736233 | PM736411 |
| 15060000185568 | L15/dossiers | 15 | 15060000185567 | 15060000185567 | 1 | PA569 | PM775717 |
| 15060000185586 | L15/dossiers | 15 | 15060000185585 | 15060000185585 | 1 | PA429887 | PM736274 |
| 15060000185593 | L15/dossiers | 15 | 15060000185592 | 15060000185592 | 1 | PA721506 | PM723296 |
| 15060000185600 | L15/dossiers | 15 | 15060000185599 | 15060000185599 | 1 | PA721522 | PM723300 |
| 15060000185607 | L15/dossiers | 15 | 15060000185606 | 15060000185606 | 1 | PA720468 | PM722972 |
| 15060000185614 | L15/dossiers | 15 | 15060000185613 | 15060000185613 | 1 | PA720468 | PM722972 |
| 15060000185621 | L15/dossiers | 15 | 15060000185620 | 15060000185620 | 1 | PA720468 | PM722972 |
| 15060000185628 | L15/dossiers | 15 | 15060000185627 | 15060000185627 | 1 | PA642847 | PM722954 |
| 15060000185638 | L15/dossiers | 15 | 15060000185637 | 15060000185637 | 1 | PA267306 | PM723054 |
| 15060000185639 | L15/dossiers | 15 | 15060000185637 | 15060000185637 | 2 | PA722134 | PM723482 |