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 |
|---|---|---|---|---|---|---|---|
| 15060000171769 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 18 | PA267872 | PM736409 |
| 15060000171770 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 19 | PA775248 | PM775554 |
| 15060000171771 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 20 | PA774311 | PM775763 |
| 15060000171772 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 21 | PA331381 | PM775739 |
| 15060000171779 | L15/dossiers | 15 | 15060000171778 | 15060000171778 | 1 | PA774954 | PM774972 |
| 15060000171786 | L15/dossiers | 15 | 15060000171785 | 15060000171785 | 1 | PA718838 | PM722474 |
| 15060000171793 | L15/dossiers | 15 | 15060000171792 | 15060000171792 | 1 | PA718838 | PM722474 |
| 15060000171800 | L15/dossiers | 15 | 15060000171799 | 15060000171799 | 1 | PA718838 | PM722474 |
| 15060000171807 | L15/dossiers | 15 | 15060000171806 | 15060000171806 | 1 | PA642935 | PM723238 |
| 15060000171814 | L15/dossiers | 15 | 15060000171813 | 15060000171813 | 1 | PA718784 | PM722456 |
| 15060000171821 | L15/dossiers | 15 | 15060000171820 | 15060000171820 | 1 | PA718780 | PM722454 |
| 15060000171828 | L15/dossiers | 15 | 15060000171827 | 15060000171827 | 1 | PA719946 | PM722808 |
| 15060000171835 | L15/dossiers | 15 | 15060000171834 | 15060000171834 | 1 | PA608826 | PM723276 |
| 15060000171842 | L15/dossiers | 15 | 15060000171841 | 15060000171841 | 1 | PA719578 | PM722702 |
| 15060000171849 | L15/dossiers | 15 | 15060000171848 | 15060000171848 | 1 | PA267306 | PM723054 |
| 15060000171853 | L15/dossiers | 15 | 15060000171852 | 15060000171852 | 1 | PA345619 | PM725692 |
| 15060000171854 | L15/dossiers | 15 | 15060000171852 | 15060000171852 | 2 | PA335758 | PM759788 |
| 15060000171861 | L15/dossiers | 15 | 15060000171860 | 15060000171860 | 1 | PA719980 | PM722822 |
| 15060000171866 | L15/dossiers | 15 | 15060000171865 | 15060000171865 | 1 | PA722280 | PM772999 |
| 15060000171870 | L15/dossiers | 15 | 15060000171869 | 15060000171869 | 1 | PA266788 | PM722914 |
| 15060000171877 | L15/dossiers | 15 | 15060000171876 | 15060000171876 | 1 | PA266788 | PM722914 |
| 15060000171887 | L15/dossiers | 15 | 15060000171886 | 15060000171886 | 1 | PA2116 | PM736339 |
| 15060000171894 | L15/dossiers | 15 | 15060000171893 | 15060000171893 | 1 | PA736209 | PM736400 |
| 15060000171912 | L15/dossiers | 15 | 15060000171911 | 15060000171911 | 1 | PA720634 | PM736312 |
| 15060000171919 | L15/dossiers | 15 | 15060000171918 | 15060000171918 | 1 | PA773441 | PM773491 |
| 15060000171920 | L15/dossiers | 15 | 15060000171918 | 15060000171918 | 2 | PA717161 | PM773483 |
| 15060000171930 | L15/dossiers | 15 | 15060000171929 | 15060000171929 | 1 | PA267306 | PM723054 |
| 15060000171931 | L15/dossiers | 15 | 15060000171929 | 15060000171929 | 2 | PA720492 | PM722980 |
| 15060000171941 | L15/dossiers | 15 | 15060000171940 | 15060000171940 | 1 | PA736183 | PM736405 |
| 15060000171962 | L15/dossiers | 15 | 15060000171961 | 15060000171961 | 1 | PA267785 | PM723310 |
| 15060000171969 | L15/dossiers | 15 | 15060000171968 | 15060000171968 | 1 | PA773441 | PM773491 |
| 15060000171976 | L15/dossiers | 15 | 15060000171975 | 15060000171975 | 1 | PA775206 | PM775506 |
| 15060000171977 | L15/dossiers | 15 | 15060000171975 | 15060000171975 | 2 | PA342564 | PM736388 |
| 15060000171978 | L15/dossiers | 15 | 15060000171975 | 15060000171975 | 3 | PA736191 | PM736336 |
| 15060000171979 | L15/dossiers | 15 | 15060000171975 | 15060000171975 | 4 | PA703511 | PM775685 |
| 15060000171980 | L15/dossiers | 15 | 15060000171975 | 15060000171975 | 5 | PA702993 | PM736362 |
| 15060000171990 | L15/dossiers | 15 | 15060000171989 | 15060000171989 | 1 | PA736179 | PM736420 |
| 15060000171997 | L15/dossiers | 15 | 15060000171996 | 15060000171996 | 1 | PA758431 | PM758701 |
| 15060000172004 | L15/dossiers | 15 | 15060000172003 | 15060000172003 | 1 | PA736201 | PM736347 |
| 15060000172011 | L15/dossiers | 15 | 15060000172010 | 15060000172010 | 1 | PA721474 | PM723286 |
| 15060000172015 | L15/dossiers | 15 | 15060000172014 | 15060000172014 | 1 | PA267042 | PM722910 |
| 15060000172023 | L15/dossiers | 15 | 15060000172022 | 15060000172022 | 1 | PA267780 | PM723504 |
| 15060000172027 | L15/dossiers | 15 | 15060000172026 | 15060000172026 | 1 | PA736241 | PM736300 |
| 15060000172034 | L15/dossiers | 15 | 15060000172033 | 15060000172033 | 1 | PA703523 | PM775703 |
| 15060000172066 | L15/dossiers | 15 | 15060000172065 | 15060000172065 | 1 | PA703520 | PM775705 |
| 15060000172073 | L15/dossiers | 15 | 15060000172072 | 15060000172072 | 1 | PA703517 | PM775675 |
| 15060000172080 | L15/dossiers | 15 | 15060000172079 | 15060000172079 | 1 | PA703518 | PM775673 |
| 15060000172090 | L15/dossiers | 15 | 15060000172089 | 15060000172089 | 1 | PA718756 | PM722446 |
| 15060000172091 | L15/dossiers | 15 | 15060000172089 | 15060000172089 | 2 | PA720598 | PM723012 |
| 15060000172104 | L15/dossiers | 15 | 15060000172103 | 15060000172103 | 1 | PA773441 | PM773491 |