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 |
|---|---|---|---|---|---|---|---|
| 15060000187473 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 38 | PA736216 | PM736273 |
| 15060000187474 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 39 | PA775236 | PM775542 |
| 15060000187475 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 40 | PA747421 | PM775759 |
| 15060000187476 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 41 | PA415447 | PM775785 |
| 15060000187477 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 42 | PA429854 | PM736335 |
| 15060000187478 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 43 | PA703522 | PM775701 |
| 15060000187479 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 44 | PA775228 | PM775516 |
| 15060000187480 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 45 | PA775170 | PM775468 |
| 15060000187481 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 46 | PA775280 | PM775586 |
| 15060000187482 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 47 | PA775230 | PM775514 |
| 15060000187489 | L15/dossiers | 15 | 15060000187488 | 15060000187488 | 1 | PA773441 | PM773491 |
| 15060000187496 | L15/dossiers | 15 | 15060000187495 | 15060000187495 | 1 | PA429860 | PM736398 |
| 15060000187497 | L15/dossiers | 15 | 15060000187495 | 15060000187495 | 2 | PA702993 | PM736362 |
| 15060000187504 | L15/dossiers | 15 | 15060000187503 | 15060000187503 | 1 | PA719608 | PM722710 |
| 15060000187511 | L15/dossiers | 15 | 15060000187510 | 15060000187510 | 1 | PA783457 | PM783488 |
| 15060000187518 | L15/dossiers | 15 | 15060000187517 | 15060000187517 | 1 | PA783457 | PM783488 |
| 15060000187525 | L15/dossiers | 15 | 15060000187524 | 15060000187524 | 1 | PA722252 | PM723518 |
| 15060000187532 | L15/dossiers | 15 | 15060000187531 | 15060000187531 | 1 | PA719778 | PM722760 |
| 15060000187539 | L15/dossiers | 15 | 15060000187538 | 15060000187538 | 1 | PA429875 | PM736302 |
| 15060000187540 | L15/dossiers | 15 | 15060000187538 | 15060000187538 | 2 | PA415448 | PM775789 |
| 15060000187547 | L15/dossiers | 15 | 15060000187546 | 15060000187546 | 1 | PA1206 | PM723354 |
| 15060000187551 | L15/dossiers | 15 | 15060000187550 | 15060000187550 | 1 | PA1206 | PM723354 |
| 15060000187558 | L15/dossiers | 15 | 15060000187557 | 15060000187557 | 1 | PA722312 | PM723536 |
| 15060000187565 | L15/dossiers | 15 | 15060000187564 | 15060000187564 | 1 | PA720488 | PM772842 |
| 15060000187572 | L15/dossiers | 15 | 15060000187571 | 15060000187571 | 1 | PA267901 | PM723166 |
| 15060000187579 | L15/dossiers | 15 | 15060000187578 | 15060000187578 | 1 | PA720278 | PM722916 |
| 15060000187586 | L15/dossiers | 15 | 15060000187585 | 15060000187585 | 1 | PA721678 | PM723352 |
| 15060000187593 | L15/dossiers | 15 | 15060000187592 | 15060000187592 | 1 | PA607553 | PM722956 |
| 15060000187594 | L15/dossiers | 15 | 15060000187592 | 15060000187592 | 2 | PA722178 | PM723494 |
| 15060000187601 | L15/dossiers | 15 | 15060000187600 | 15060000187600 | 1 | PA721678 | PM723352 |
| 15060000187605 | L15/dossiers | 15 | 15060000187604 | 15060000187604 | 1 | PA720488 | PM772842 |
| 15060000187609 | L15/dossiers | 15 | 15060000187608 | 15060000187608 | 1 | PA775240 | PM775530 |
| 15060000187616 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 1 | PA756685 | PM775777 |
| 15060000187617 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 2 | PA429886 | PM736385 |
| 15060000187618 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 3 | PA736173 | PM736369 |
| 15060000187619 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 4 | PA775296 | PM775596 |
| 15060000187620 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 5 | PA304082 | PM736354 |
| 15060000187621 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 6 | PA757676 | PM757692 |
| 15060000187622 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 7 | PA775172 | PM775474 |
| 15060000187623 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 8 | PA429894 | PM736364 |
| 15060000187624 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 9 | PA429836 | PM736345 |
| 15060000187625 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 10 | PA775246 | PM775532 |
| 15060000187626 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 11 | PA678263 | PM736330 |
| 15060000187627 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 12 | PA1978 | PM736337 |
| 15060000187628 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 13 | PA736243 | PM736413 |
| 15060000187629 | L15/dossiers | 15 | 15060000187615 | 15060000187615 | 14 | PA736175 | PM736344 |
| 15060000187636 | L15/dossiers | 15 | 15060000187635 | 15060000187635 | 1 | PA720488 | PM772842 |
| 15060000187643 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 1 | PA775246 | PM775532 |
| 15060000187644 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 2 | PA775296 | PM775596 |
| 15060000187645 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 3 | PA757676 | PM757692 |