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 |
|---|---|---|---|---|---|---|---|
| 15060000187813 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 10 | PA775202 | PM775502 |
| 15060000187814 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 11 | PA736224 | PM736403 |
| 15060000187821 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 1 | PA773891 | PM773895 |
| 15060000187822 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 2 | PA775228 | PM775516 |
| 15060000187823 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 3 | PA415446 | PM775783 |
| 15060000187824 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 4 | PA736204 | PM736338 |
| 15060000187825 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 5 | PA736235 | PM775795 |
| 15060000187826 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 6 | PA429858 | PM736268 |
| 15060000187827 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 7 | PA775302 | PM775598 |
| 15060000187828 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 8 | PA425322 | PM736282 |
| 15060000187829 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 9 | PA415495 | PM775635 |
| 15060000187830 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 10 | PA703534 | PM775695 |
| 15060000187831 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 11 | PA736246 | PM775819 |
| 15060000187832 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 12 | PA703522 | PM775701 |
| 15060000187833 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 13 | PA744079 | PM744082 |
| 15060000187834 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 14 | PA736198 | PM736406 |
| 15060000187835 | L15/dossiers | 15 | 15060000187820 | 15060000187820 | 15 | PA775202 | PM775502 |
| 15060000187842 | L15/dossiers | 15 | 15060000187841 | 15060000187841 | 1 | PA773441 | PM773491 |
| 15060000187849 | L15/dossiers | 15 | 15060000187848 | 15060000187848 | 1 | PA773441 | PM773491 |
| 15060000187856 | L15/dossiers | 15 | 15060000187855 | 15060000187855 | 1 | PA773441 | PM773491 |
| 15060000187863 | L15/dossiers | 15 | 15060000187862 | 15060000187862 | 1 | PA773441 | PM773491 |
| 15060000187870 | L15/dossiers | 15 | 15060000187869 | 15060000187869 | 1 | PA721474 | PM723286 |
| 15060000187874 | L15/dossiers | 15 | 15060000187873 | 15060000187873 | 1 | PA719980 | PM722822 |
| 15060000187881 | L15/dossiers | 15 | 15060000187880 | 15060000187880 | 1 | PA330008 | PM722416 |
| 15060000187885 | L15/dossiers | 15 | 15060000187884 | 15060000187884 | 1 | PA719464 | PM722670 |
| 15060000187892 | L15/dossiers | 15 | 15060000187891 | 15060000187891 | 1 | PA266788 | PM722914 |
| 15060000187899 | L15/dossiers | 15 | 15060000187898 | 15060000187898 | 1 | PA608416 | PM723540 |
| 15060000187906 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 1 | PA736175 | PM736344 |
| 15060000187907 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 2 | PA429894 | PM736364 |
| 15060000187908 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 3 | PA429886 | PM736385 |
| 15060000187909 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 4 | PA756685 | PM775777 |
| 15060000187910 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 5 | PA736173 | PM736369 |
| 15060000187911 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 6 | PA757676 | PM757692 |
| 15060000187912 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 7 | PA304082 | PM736354 |
| 15060000187913 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 8 | PA775172 | PM775474 |
| 15060000187914 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 9 | PA429836 | PM736345 |
| 15060000187915 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 10 | PA736195 | PM736357 |
| 15060000187916 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 11 | PA775246 | PM775532 |
| 15060000187917 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 12 | PA678263 | PM736330 |
| 15060000187918 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 13 | PA1978 | PM736337 |
| 15060000187919 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 14 | PA736243 | PM736413 |
| 15060000187920 | L15/dossiers | 15 | 15060000187905 | 15060000187905 | 15 | PA775296 | PM775596 |
| 15060000187927 | L15/dossiers | 15 | 15060000187926 | 15060000187926 | 1 | PA774956 | PM774979 |
| 15060000187931 | L15/dossiers | 15 | 15060000187930 | 15060000187930 | 1 | PA758431 | PM758701 |
| 15060000187938 | L15/dossiers | 15 | 15060000187937 | 15060000187937 | 1 | PA703510 | PM775681 |
| 15060000187945 | L15/dossiers | 15 | 15060000187944 | 15060000187944 | 1 | PA773441 | PM773491 |
| 15060000187952 | L15/dossiers | 15 | 15060000187951 | 15060000187951 | 1 | PA773441 | PM773491 |
| 15060000187959 | L15/dossiers | 15 | 15060000187958 | 15060000187958 | 1 | PA773441 | PM773491 |
| 15060000187966 | L15/dossiers | 15 | 15060000187965 | 15060000187965 | 1 | PA773441 | PM773491 |
| 15060000187973 | L15/dossiers | 15 | 15060000187972 | 15060000187972 | 1 | PA703510 | PM775681 |