dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 17060000125739 | L17/dossiers | 17 | 17060000125738 | 17060000125738 | 1 | PA720342 | PM842999 |
| 17060000125790 | L17/dossiers | 17 | 17060000125789 | 17060000125789 | 1 | PA840979 | PM842588 |
| 17060000125797 | L17/dossiers | 17 | 17060000125796 | 17060000125796 | 1 | PA840979 | PM842588 |
| 17060000125804 | L17/dossiers | 17 | 17060000125803 | 17060000125803 | 1 | PA840979 | PM842588 |
| 17060000125811 | L17/dossiers | 17 | 17060000125810 | 17060000125810 | 1 | PA722374 | PM843302 |
| 17060000125818 | L17/dossiers | 17 | 17060000125817 | 17060000125817 | 1 | PA642847 | PM843056 |
| 17060000125825 | L17/dossiers | 17 | 17060000125824 | 17060000125824 | 1 | PA642847 | PM843056 |
| 17060000125832 | L17/dossiers | 17 | 17060000125831 | 17060000125831 | 1 | PA795672 | PM843752 |
| 17060000125839 | L17/dossiers | 17 | 17060000125838 | 17060000125838 | 1 | PA720892 | PM840420 |
| 17060000125846 | L17/dossiers | 17 | 17060000125845 | 17060000125845 | 1 | PA606098 | PM842633 |
| 17060000125853 | L17/dossiers | 17 | 17060000125852 | 17060000125852 | 1 | PA774960 | PM840417 |
| 17060000125860 | L17/dossiers | 17 | 17060000125859 | 17060000125859 | 1 | PA794114 | PM842888 |
| 17060000125867 | L17/dossiers | 17 | 17060000125866 | 17060000125866 | 1 | PA608826 | PM843365 |
| 17060000125874 | L17/dossiers | 17 | 17060000125873 | 17060000125873 | 1 | PA795136 | PM843353 |
| 17060000125881 | L17/dossiers | 17 | 17060000125880 | 17060000125880 | 1 | PA793736 | PM842693 |
| 17060000125888 | L17/dossiers | 17 | 17060000125887 | 17060000125887 | 1 | PA793672 | PM842555 |
| 17060000125895 | L17/dossiers | 17 | 17060000125894 | 17060000125894 | 1 | PA795228 | PM840447 |
| 17060000125902 | L17/dossiers | 17 | 17060000125901 | 17060000125901 | 1 | PA795430 | PM843602 |
| 17060000125909 | L17/dossiers | 17 | 17060000125908 | 17060000125908 | 1 | PA606098 | PM842633 |
| 17060000125916 | L17/dossiers | 17 | 17060000125915 | 17060000125915 | 1 | PA795636 | PM843476 |
| 17060000125923 | L17/dossiers | 17 | 17060000125922 | 17060000125922 | 1 | PA795998 | PM843737 |
| 17060000125930 | L17/dossiers | 17 | 17060000125929 | 17060000125929 | 1 | PA721474 | PM843608 |
| 17060000125937 | L17/dossiers | 17 | 17060000125936 | 17060000125936 | 1 | PA795722 | PM843488 |
| 17060000125944 | L17/dossiers | 17 | 17060000125943 | 17060000125943 | 1 | PA795982 | PM840432 |
| 17060000125951 | L17/dossiers | 17 | 17060000125950 | 17060000125950 | 1 | PA795672 | PM843752 |
| 17060000125973 | L17/dossiers | 17 | 17060000125972 | 17060000125972 | 1 | PA795228 | PM840447 |
| 17060000125977 | L17/dossiers | 17 | 17060000125976 | 17060000125976 | 1 | PA793992 | PM842756 |
| 17060000125994 | L17/dossiers | 17 | 17060000125993 | 17060000125993 | 1 | PA841981 | PM843533 |
| 17060000125998 | L17/dossiers | 17 | 17060000125997 | 17060000125997 | 1 | PA368 | PM847741 |
| 17060000125999 | L17/dossiers | 17 | 17060000125997 | 17060000125997 | 2 | PA2538 | PM847747 |
| 17060000126000 | L17/dossiers | 17 | 17060000125997 | 17060000125997 | 3 | PA721836 | PM847755 |
| 17060000126038 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 1 | PA827920 | PM828574 |
| 17060000126039 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 2 | PA429889 | PM829767 |
| 17060000126040 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 3 | PA605888 | PM775604 |
| 17060000126041 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 4 | PA736234 | PM829887 |
| 17060000126042 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 5 | PA708633 | PM775669 |
| 17060000126043 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 6 | PA415477 | PM775809 |
| 17060000126044 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 7 | PA736225 | PM829907 |
| 17060000126045 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 8 | PA342564 | PM829509 |
| 17060000126046 | L17/dossiers | 17 | 17060000126037 | 17060000126037 | 9 | PA606375 | PM775602 |
| 17060000126053 | L17/dossiers | 17 | 17060000126052 | 17060000126052 | 1 | PA330684 | PM775859 |
| 17060000126060 | L17/dossiers | 17 | 17060000126059 | 17060000126059 | 1 | PA368 | PM847741 |
| 17060000126090 | L17/dossiers | 17 | 17060000126089 | 17060000126089 | 1 | PA267794 | PM842348 |
| 17060000126094 | L17/dossiers | 17 | 17060000126093 | 17060000126093 | 1 | PA720952 | PM843755 |
| 17060000126101 | L17/dossiers | 17 | 17060000126100 | 17060000126100 | 1 | PA795310 | PM840453 |
| 17060000126111 | L17/dossiers | 17 | 17060000126110 | 17060000126110 | 1 | PA722328 | PM849127 |
| 17060000126115 | L17/dossiers | 17 | 17060000126114 | 17060000126114 | 1 | PA330008 | PM842366 |
| 17060000126122 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 1 | PA721130 | PM775608 |
| 17060000126123 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 2 | PA827894 | PM828460 |
| 17060000126124 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 3 | PA736219 | PM829867 |