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 |
|---|---|---|---|---|---|---|---|
| 15060000150547 | L15/dossiers | 15 | 15060000150546 | 15060000150546 | 1 | PA642847 | PM722954 |
| 15060000150554 | L15/dossiers | 15 | 15060000150553 | 15060000150553 | 1 | PA642788 | PM722746 |
| 15060000150561 | L15/dossiers | 15 | 15060000150560 | 15060000150560 | 1 | PA340853 | PM722534 |
| 15060000150568 | L15/dossiers | 15 | 15060000150567 | 15060000150567 | 1 | PA267289 | PM754301 |
| 15060000150584 | L15/dossiers | 15 | 15060000150583 | 15060000150583 | 1 | PA345619 | PM725692 |
| 15060000150585 | L15/dossiers | 15 | 15060000150583 | 15060000150583 | 2 | PA1872 | PM730104 |
| 15060000150632 | L15/dossiers | 15 | 15060000150631 | 15060000150631 | 1 | PA608416 | PM723540 |
| 15060000150636 | L15/dossiers | 15 | 15060000150635 | 15060000150635 | 1 | PA345619 | PM725692 |
| 15060000150698 | L15/dossiers | 15 | 15060000150697 | 15060000150697 | 1 | PA345619 | PM725692 |
| 15060000150699 | L15/dossiers | 15 | 15060000150697 | 15060000150697 | 2 | PA415452 | PM759792 |
| 15060000150728 | L15/dossiers | 15 | 15060000150727 | 15060000150727 | 1 | PA720846 | PM723094 |
| 15060000150735 | L15/dossiers | 15 | 15060000150734 | 15060000150734 | 1 | PA720386 | PM722948 |
| 15060000150742 | L15/dossiers | 15 | 15060000150741 | 15060000150741 | 1 | PA720386 | PM722948 |
| 15060000150749 | L15/dossiers | 15 | 15060000150748 | 15060000150748 | 1 | PA720386 | PM722948 |
| 15060000150756 | L15/dossiers | 15 | 15060000150755 | 15060000150755 | 1 | PA721012 | PM755861 |
| 15060000150766 | L15/dossiers | 15 | 15060000150765 | 15060000150765 | 1 | PA719578 | PM722702 |
| 15060000150773 | L15/dossiers | 15 | 15060000150772 | 15060000150772 | 1 | PA2377 | PM723550 |
| 15060000150780 | L15/dossiers | 15 | 15060000150779 | 15060000150779 | 1 | PA266788 | PM722914 |
| 15060000150787 | L15/dossiers | 15 | 15060000150786 | 15060000150786 | 1 | PA719946 | PM722808 |
| 15060000150794 | L15/dossiers | 15 | 15060000150793 | 15060000150793 | 1 | PA609245 | PM723318 |
| 15060000150801 | L15/dossiers | 15 | 15060000150800 | 15060000150800 | 1 | PA720286 | PM722918 |
| 15060000150808 | L15/dossiers | 15 | 15060000150807 | 15060000150807 | 1 | PA345619 | PM725692 |
| 15060000150815 | L15/dossiers | 15 | 15060000150814 | 15060000150814 | 1 | PA345619 | PM725692 |
| 15060000150852 | L15/dossiers | 15 | 15060000150851 | 15060000150851 | 1 | PA721062 | PM723158 |
| 15060000150859 | L15/dossiers | 15 | 15060000150858 | 15060000150858 | 1 | PA345619 | PM725692 |
| 15060000150892 | L15/dossiers | 15 | 15060000150891 | 15060000150891 | 1 | PA721012 | PM755861 |
| 15060000150896 | L15/dossiers | 15 | 15060000150895 | 15060000150895 | 1 | PA721262 | PM723218 |
| 15060000150927 | L15/dossiers | 15 | 15060000150926 | 15060000150926 | 1 | PA429893 | PM723104 |
| 15060000150934 | L15/dossiers | 15 | 15060000150933 | 15060000150933 | 1 | PA605518 | PM722518 |
| 15060000150948 | L15/dossiers | 15 | 15060000150947 | 15060000150947 | 1 | PA719946 | PM722808 |
| 15060000150967 | L15/dossiers | 15 | 15060000150966 | 15060000150966 | 1 | PA345619 | PM725692 |
| 15060000150968 | L15/dossiers | 15 | 15060000150966 | 15060000150966 | 2 | PA1872 | PM730104 |
| 15060000150999 | L15/dossiers | 15 | 15060000150998 | 15060000150998 | 1 | PA345619 | PM725692 |
| 15060000151000 | L15/dossiers | 15 | 15060000150998 | 15060000150998 | 2 | PA332747 | PM758790 |
| 15060000151001 | L15/dossiers | 15 | 15060000150998 | 15060000150998 | 3 | PA717161 | PM730070 |
| 15060000151008 | L15/dossiers | 15 | 15060000151007 | 15060000151007 | 1 | PA345619 | PM725692 |
| 15060000151009 | L15/dossiers | 15 | 15060000151007 | 15060000151007 | 2 | PA605131 | PM759784 |
| 15060000151010 | L15/dossiers | 15 | 15060000151007 | 15060000151007 | 3 | PA717153 | PM730062 |
| 15060000151011 | L15/dossiers | 15 | 15060000151007 | 15060000151007 | 4 | PA331481 | PM730094 |
| 15060000151028 | L15/dossiers | 15 | 15060000151027 | 15060000151027 | 1 | PA345619 | PM725692 |
| 15060000151035 | L15/dossiers | 15 | 15060000151034 | 15060000151034 | 1 | PA721226 | PM723208 |
| 15060000151042 | L15/dossiers | 15 | 15060000151041 | 15060000151041 | 1 | PA345619 | PM725692 |
| 15060000151043 | L15/dossiers | 15 | 15060000151041 | 15060000151041 | 2 | PA607846 | PM730066 |
| 15060000151730 | L15/dossiers | 15 | 15060000151729 | 15060000151729 | 1 | PA643089 | PM758076 |
| 15060000151737 | L15/dossiers | 15 | 15060000151736 | 15060000151736 | 1 | PA267306 | PM723054 |
| 15060000151744 | L15/dossiers | 15 | 15060000151743 | 15060000151743 | 1 | PA721836 | PM723398 |
| 15060000151776 | L15/dossiers | 15 | 15060000151775 | 15060000151775 | 1 | PA721816 | PM748964 |
| 15060000151783 | L15/dossiers | 15 | 15060000151782 | 15060000151782 | 1 | PA609590 | PM723326 |
| 15060000151806 | L15/dossiers | 15 | 15060000151805 | 15060000151805 | 1 | PA721486 | PM723290 |
| 15060000151813 | L15/dossiers | 15 | 15060000151812 | 15060000151812 | 1 | PA718850 | PM722478 |