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 |
|---|---|---|---|---|---|---|---|
| 17060000151671 | L17/dossiers | 17 | 17060000151670 | 17060000151670 | 1 | PA722142 | PM843500 |
| 17060000151678 | L17/dossiers | 17 | 17060000151677 | 17060000151677 | 1 | PA722390 | PM843317 |
| 17060000151685 | L17/dossiers | 17 | 17060000151684 | 17060000151684 | 1 | PA793452 | PM842453 |
| 17060000151692 | L17/dossiers | 17 | 17060000151691 | 17060000151691 | 1 | PA719968 | PM842891 |
| 17060000151699 | L17/dossiers | 17 | 17060000151698 | 17060000151698 | 1 | PA841713 | PM843275 |
| 17060000151706 | L17/dossiers | 17 | 17060000151705 | 17060000151705 | 1 | PA609332 | PM840396 |
| 17060000151713 | L17/dossiers | 17 | 17060000151712 | 17060000151712 | 1 | PA794778 | PM843239 |
| 17060000151720 | L17/dossiers | 17 | 17060000151719 | 17060000151719 | 1 | PA795664 | PM843569 |
| 17060000151727 | L17/dossiers | 17 | 17060000151726 | 17060000151726 | 1 | PA719778 | PM842744 |
| 17060000151734 | L17/dossiers | 17 | 17060000151733 | 17060000151733 | 1 | PA719756 | PM842813 |
| 17060000151741 | L17/dossiers | 17 | 17060000151740 | 17060000151740 | 1 | PA840809 | PM842474 |
| 17060000151748 | L17/dossiers | 17 | 17060000151747 | 17060000151747 | 1 | PA720146 | PM842849 |
| 17060000151755 | L17/dossiers | 17 | 17060000151754 | 17060000151754 | 1 | PA878242 | PM878243 |
| 17060000151762 | L17/dossiers | 17 | 17060000151761 | 17060000151761 | 1 | PA793382 | PM842480 |
| 17060000151769 | L17/dossiers | 17 | 17060000151768 | 17060000151768 | 1 | PA794938 | PM843308 |
| 17060000151776 | L17/dossiers | 17 | 17060000151775 | 17060000151775 | 1 | PA368 | PM873126 |
| 17060000151783 | L17/dossiers | 17 | 17060000151782 | 17060000151782 | 1 | PA795762 | PM843767 |
| 17060000151790 | L17/dossiers | 17 | 17060000151789 | 17060000151789 | 1 | PA795050 | PM874601 |
| 17060000151797 | L17/dossiers | 17 | 17060000151796 | 17060000151796 | 1 | PA794094 | PM840291 |
| 17060000151804 | L17/dossiers | 17 | 17060000151803 | 17060000151803 | 1 | PA795540 | PM843620 |
| 17060000151808 | L17/dossiers | 17 | 17060000151807 | 17060000151807 | 1 | PA719890 | PM842855 |
| 17060000151812 | L17/dossiers | 17 | 17060000151811 | 17060000151811 | 1 | PA794786 | PM843242 |
| 17060000151819 | L17/dossiers | 17 | 17060000151818 | 17060000151818 | 1 | PA775196 | PM775482 |
| 17060000151826 | L17/dossiers | 17 | 17060000151825 | 17060000151825 | 1 | PA415486 | PM775813 |
| 17060000151833 | L17/dossiers | 17 | 17060000151832 | 17060000151832 | 1 | PA415488 | PM775641 |
| 17060000151834 | L17/dossiers | 17 | 17060000151832 | 17060000151832 | 2 | PA827920 | PM828574 |
| 17060000151835 | L17/dossiers | 17 | 17060000151832 | 17060000151832 | 3 | PA828018 | PM828882 |
| 17060000151836 | L17/dossiers | 17 | 17060000151832 | 17060000151832 | 4 | PA736217 | PM829873 |
| 17060000151843 | L17/dossiers | 17 | 17060000151842 | 17060000151842 | 1 | PA415486 | PM775813 |
| 17060000151850 | L17/dossiers | 17 | 17060000151849 | 17060000151849 | 1 | PA415486 | PM775813 |
| 17060000151857 | L17/dossiers | 17 | 17060000151856 | 17060000151856 | 1 | PA415486 | PM775813 |
| 17060000151864 | L17/dossiers | 17 | 17060000151863 | 17060000151863 | 1 | PA415486 | PM775813 |
| 17060000151871 | L17/dossiers | 17 | 17060000151870 | 17060000151870 | 1 | PA267241 | PM778080 |
| 17060000151878 | L17/dossiers | 17 | 17060000151877 | 17060000151877 | 1 | PA330240 | PM842357 |
| 17060000151885 | L17/dossiers | 17 | 17060000151884 | 17060000151884 | 1 | PA775290 | PM775576 |
| 17060000151892 | L17/dossiers | 17 | 17060000151891 | 17060000151891 | 1 | PA415446 | PM775783 |
| 17060000151893 | L17/dossiers | 17 | 17060000151891 | 17060000151891 | 2 | PA775270 | PM775572 |
| 17060000151900 | L17/dossiers | 17 | 17060000151899 | 17060000151899 | 1 | PA775178 | PM775460 |
| 17060000151907 | L17/dossiers | 17 | 17060000151906 | 17060000151906 | 1 | PA736241 | PM829931 |
| 17060000151908 | L17/dossiers | 17 | 17060000151906 | 17060000151906 | 2 | PA736175 | PM829795 |
| 17060000151909 | L17/dossiers | 17 | 17060000151906 | 17060000151906 | 3 | PA342564 | PM829509 |
| 17060000151916 | L17/dossiers | 17 | 17060000151915 | 17060000151915 | 1 | PA836345 | PM836353 |
| 17060000151923 | L17/dossiers | 17 | 17060000151922 | 17060000151922 | 1 | PA643210 | PM873637 |
| 17060000151931 | L17/dossiers | 17 | 17060000151930 | 17060000151930 | 1 | PA415446 | PM775783 |
| 17060000151938 | L17/dossiers | 17 | 17060000151937 | 17060000151937 | 1 | PA736224 | PM829913 |
| 17060000151945 | L17/dossiers | 17 | 17060000151944 | 17060000151944 | 1 | PA703529 | PM836349 |
| 17060000151952 | L17/dossiers | 17 | 17060000151951 | 17060000151951 | 1 | PA703529 | PM836349 |
| 17060000151959 | L17/dossiers | 17 | 17060000151958 | 17060000151958 | 1 | PA643210 | PM873637 |
| 17060000151967 | L17/dossiers | 17 | 17060000151966 | 17060000151966 | 1 | PA841893 | PM843449 |
| 17060000152008 | L17/dossiers | 17 | 17060000152007 | 17060000152007 | 1 | PA841893 | PM843449 |