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 |
|---|---|---|---|---|---|---|---|
| 15060000172324 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 46 | PA708633 | PM775669 |
| 15060000172325 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 47 | PA429867 | PM736298 |
| 15060000172326 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 48 | PA227096 | PM736342 |
| 15060000172327 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 49 | PA703536 | PM775719 |
| 15060000172328 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 50 | PA775256 | PM775546 |
| 15060000172329 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 51 | PA775290 | PM775576 |
| 15060000172330 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 52 | PA643211 | PM775749 |
| 15060000172331 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 53 | PA775194 | PM775476 |
| 15060000172332 | L15/dossiers | 15 | 15060000172278 | 15060000172278 | 54 | PA2774 | PM736307 |
| 15060000172339 | L15/dossiers | 15 | 15060000172338 | 15060000172338 | 1 | PA773441 | PM773491 |
| 15060000172340 | L15/dossiers | 15 | 15060000172338 | 15060000172338 | 2 | PA773443 | PM773510 |
| 15060000172347 | L15/dossiers | 15 | 15060000172346 | 15060000172346 | 1 | PA773441 | PM773491 |
| 15060000172360 | L15/dossiers | 15 | 15060000172359 | 15060000172359 | 1 | PA267429 | PM722818 |
| 15060000172364 | L15/dossiers | 15 | 15060000172363 | 15060000172363 | 1 | PA721576 | PM772844 |
| 15060000172371 | L15/dossiers | 15 | 15060000172370 | 15060000172370 | 1 | PA720692 | PM723042 |
| 15060000172378 | L15/dossiers | 15 | 15060000172377 | 15060000172377 | 1 | PA718850 | PM722478 |
| 15060000172385 | L15/dossiers | 15 | 15060000172384 | 15060000172384 | 1 | PA720386 | PM722948 |
| 15060000172392 | L15/dossiers | 15 | 15060000172391 | 15060000172391 | 1 | PA720968 | PM723126 |
| 15060000172446 | L15/dossiers | 15 | 15060000172445 | 15060000172445 | 1 | PA721024 | PM723144 |
| 15060000172453 | L15/dossiers | 15 | 15060000172452 | 15060000172452 | 1 | PA718784 | PM722456 |
| 15060000172460 | L15/dossiers | 15 | 15060000172459 | 15060000172459 | 1 | PA721024 | PM723144 |
| 15060000172467 | L15/dossiers | 15 | 15060000172466 | 15060000172466 | 1 | PA2952 | PM722480 |
| 15060000172474 | L15/dossiers | 15 | 15060000172473 | 15060000172473 | 1 | PA721984 | PM723440 |
| 15060000172481 | L15/dossiers | 15 | 15060000172480 | 15060000172480 | 1 | PA2952 | PM722480 |
| 15060000172488 | L15/dossiers | 15 | 15060000172487 | 15060000172487 | 1 | PA2952 | PM722480 |
| 15060000172495 | L15/dossiers | 15 | 15060000172494 | 15060000172494 | 1 | PA720210 | PM722892 |
| 15060000172502 | L15/dossiers | 15 | 15060000172501 | 15060000172501 | 1 | PA721194 | PM723200 |
| 15060000172509 | L15/dossiers | 15 | 15060000172508 | 15060000172508 | 1 | PA643089 | PM758076 |
| 15060000172516 | L15/dossiers | 15 | 15060000172515 | 15060000172515 | 1 | PA721384 | PM723256 |
| 15060000172527 | L15/dossiers | 15 | 15060000172526 | 15060000172526 | 1 | PA721616 | PM723334 |
| 15060000172534 | L15/dossiers | 15 | 15060000172533 | 15060000172533 | 1 | PA266788 | PM722914 |
| 15060000172535 | L15/dossiers | 15 | 15060000172533 | 15060000172533 | 2 | PA719684 | PM722730 |
| 15060000172542 | L15/dossiers | 15 | 15060000172541 | 15060000172541 | 1 | PA719044 | PM722542 |
| 15060000172563 | L15/dossiers | 15 | 15060000172562 | 15060000172562 | 1 | PA331567 | PM722644 |
| 15060000172570 | L15/dossiers | 15 | 15060000172569 | 15060000172569 | 1 | PA721968 | PM723436 |
| 15060000172577 | L15/dossiers | 15 | 15060000172576 | 15060000172576 | 1 | PA331567 | PM722644 |
| 15060000172584 | L15/dossiers | 15 | 15060000172583 | 15060000172583 | 1 | PA643089 | PM758076 |
| 15060000172591 | L15/dossiers | 15 | 15060000172590 | 15060000172590 | 1 | PA721968 | PM723436 |
| 15060000172598 | L15/dossiers | 15 | 15060000172597 | 15060000172597 | 1 | PA722162 | PM723490 |
| 15060000172628 | L15/dossiers | 15 | 15060000172627 | 15060000172627 | 1 | PA720092 | PM722858 |
| 15060000172641 | L15/dossiers | 15 | 15060000172640 | 15060000172640 | 1 | PA719942 | PM760307 |
| 15060000172693 | L15/dossiers | 15 | 15060000172692 | 15060000172692 | 1 | PA331567 | PM722644 |
| 15060000172700 | L15/dossiers | 15 | 15060000172699 | 15060000172699 | 1 | PA722022 | PM723452 |
| 15060000172762 | L15/dossiers | 15 | 15060000172761 | 15060000172761 | 1 | PA331567 | PM722644 |
| 15060000172769 | L15/dossiers | 15 | 15060000172768 | 15060000172768 | 1 | PA720310 | PM722926 |
| 15060000172781 | L15/dossiers | 15 | 15060000172780 | 15060000172780 | 1 | PA267042 | PM722910 |
| 15060000172788 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 1 | PA429891 | PM736329 |
| 15060000172789 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 2 | PA775180 | PM775466 |
| 15060000172790 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 3 | PA429845 | PM736278 |
| 15060000172791 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 4 | PA775214 | PM775498 |