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 |
|---|---|---|---|---|---|---|---|
| 15060000162480 | L15/dossiers | 15 | 15060000162479 | 15060000162479 | 1 | PA719272 | PM722612 |
| 15060000162487 | L15/dossiers | 15 | 15060000162486 | 15060000162486 | 1 | PA719436 | PM770316 |
| 15060000162497 | L15/dossiers | 15 | 15060000162496 | 15060000162496 | 1 | PA722390 | PM723560 |
| 15060000162504 | L15/dossiers | 15 | 15060000162503 | 15060000162503 | 1 | PA608826 | PM723276 |
| 15060000162511 | L15/dossiers | 15 | 15060000162510 | 15060000162510 | 1 | PA2150 | PM722506 |
| 15060000162518 | L15/dossiers | 15 | 15060000162517 | 15060000162517 | 1 | PA2150 | PM722506 |
| 15060000162525 | L15/dossiers | 15 | 15060000162524 | 15060000162524 | 1 | PA2150 | PM722506 |
| 15060000162532 | L15/dossiers | 15 | 15060000162531 | 15060000162531 | 1 | PA2150 | PM722506 |
| 15060000162544 | L15/dossiers | 15 | 15060000162543 | 15060000162543 | 1 | PA703513 | PM703621 |
| 15060000162551 | L15/dossiers | 15 | 15060000162550 | 15060000162550 | 1 | PA703485 | PM703654 |
| 15060000162558 | L15/dossiers | 15 | 15060000162557 | 15060000162557 | 1 | PA267306 | PM723054 |
| 15060000162570 | L15/dossiers | 15 | 15060000162569 | 15060000162569 | 1 | PA267794 | PM722468 |
| 15060000162577 | L15/dossiers | 15 | 15060000162576 | 15060000162576 | 1 | PA607090 | PM722796 |
| 15060000162584 | L15/dossiers | 15 | 15060000162583 | 15060000162583 | 1 | PA722390 | PM723560 |
| 15060000162591 | L15/dossiers | 15 | 15060000162590 | 15060000162590 | 1 | PA722202 | PM723502 |
| 15060000162598 | L15/dossiers | 15 | 15060000162597 | 15060000162597 | 1 | PA721474 | PM723286 |
| 15060000162602 | L15/dossiers | 15 | 15060000162601 | 15060000162601 | 1 | PA721474 | PM723286 |
| 15060000162606 | L15/dossiers | 15 | 15060000162605 | 15060000162605 | 1 | PA643089 | PM758076 |
| 15060000162613 | L15/dossiers | 15 | 15060000162612 | 15060000162612 | 1 | PA721474 | PM723286 |
| 15060000162620 | L15/dossiers | 15 | 15060000162619 | 15060000162619 | 1 | PA267762 | PM736366 |
| 15060000162627 | L15/dossiers | 15 | 15060000162626 | 15060000162626 | 1 | PA719946 | PM722808 |
| 15060000162634 | L15/dossiers | 15 | 15060000162633 | 15060000162633 | 1 | PA642847 | PM722954 |
| 15060000162641 | L15/dossiers | 15 | 15060000162640 | 15060000162640 | 1 | PA334149 | PM723034 |
| 15060000162648 | L15/dossiers | 15 | 15060000162647 | 15060000162647 | 1 | PA266797 | PM722884 |
| 15060000162655 | L15/dossiers | 15 | 15060000162654 | 15060000162654 | 1 | PA719608 | PM722710 |
| 15060000162662 | L15/dossiers | 15 | 15060000162661 | 15060000162661 | 1 | PA721486 | PM723290 |
| 15060000162669 | L15/dossiers | 15 | 15060000162668 | 15060000162668 | 1 | PA608416 | PM723540 |
| 15060000162673 | L15/dossiers | 15 | 15060000162672 | 15060000162672 | 1 | PA345619 | PM725692 |
| 15060000162674 | L15/dossiers | 15 | 15060000162672 | 15060000162672 | 2 | PA607846 | PM730066 |
| 15060000162675 | L15/dossiers | 15 | 15060000162672 | 15060000162672 | 3 | PA331481 | PM730094 |
| 15060000162726 | L15/dossiers | 15 | 15060000162725 | 15060000162725 | 1 | PA721932 | PM734586 |
| 15060000162733 | L15/dossiers | 15 | 15060000162732 | 15060000162732 | 1 | PA608172 | PM723048 |
| 15060000162740 | L15/dossiers | 15 | 15060000162739 | 15060000162739 | 1 | PA345619 | PM725692 |
| 15060000162747 | L15/dossiers | 15 | 15060000162746 | 15060000162746 | 1 | PA334149 | PM723034 |
| 15060000162754 | L15/dossiers | 15 | 15060000162753 | 15060000162753 | 1 | PA266788 | PM722914 |
| 15060000162761 | L15/dossiers | 15 | 15060000162760 | 15060000162760 | 1 | PA720468 | PM722972 |
| 15060000162768 | L15/dossiers | 15 | 15060000162767 | 15060000162767 | 1 | PA606098 | PM722642 |
| 15060000162775 | L15/dossiers | 15 | 15060000162774 | 15060000162774 | 1 | PA429875 | PM736302 |
| 15060000162776 | L15/dossiers | 15 | 15060000162774 | 15060000162774 | 2 | PA757678 | PM757684 |
| 15060000162777 | L15/dossiers | 15 | 15060000162774 | 15060000162774 | 3 | PA404656 | PM736328 |
| 15060000162796 | L15/dossiers | 15 | 15060000162795 | 15060000162795 | 1 | PA267233 | PM723500 |
| 15060000162803 | L15/dossiers | 15 | 15060000162802 | 15060000162802 | 1 | PA720892 | PM723106 |
| 15060000162810 | L15/dossiers | 15 | 15060000162809 | 15060000162809 | 1 | PA605036 | PM722444 |
| 15060000162814 | L15/dossiers | 15 | 15060000162813 | 15060000162813 | 1 | PA2377 | PM723550 |
| 15060000162821 | L15/dossiers | 15 | 15060000162820 | 15060000162820 | 1 | PA2377 | PM723550 |
| 15060000162828 | L15/dossiers | 15 | 15060000162827 | 15060000162827 | 1 | PA2150 | PM722506 |
| 15060000162834 | L15/dossiers | 15 | 15060000162833 | 15060000162833 | 1 | PA606098 | PM722642 |
| 15060000162841 | L15/dossiers | 15 | 15060000162840 | 15060000162840 | 1 | PA606098 | PM722642 |
| 15060000162848 | L15/dossiers | 15 | 15060000162847 | 15060000162847 | 1 | PA345722 | PM723428 |
| 15060000162855 | L15/dossiers | 15 | 15060000162854 | 15060000162854 | 1 | PA643134 | PM722824 |