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 |
|---|---|---|---|---|---|---|---|
| 16060000106675 | L16/dossiers | 16 | 16060000106674 | 16060000106674 | 1 | PA794410 | PM796911 |
| 16060000106682 | L16/dossiers | 16 | 16060000106681 | 16060000106681 | 1 | PA721486 | PM797517 |
| 16060000106689 | L16/dossiers | 16 | 16060000106688 | 16060000106688 | 1 | PA266788 | PM796788 |
| 16060000106700 | L16/dossiers | 16 | 16060000106699 | 16060000106699 | 1 | PA795966 | PM797781 |
| 16060000106707 | L16/dossiers | 16 | 16060000106706 | 16060000106706 | 1 | PA346782 | PM797691 |
| 16060000106714 | L16/dossiers | 16 | 16060000106713 | 16060000106713 | 1 | PA719890 | PM796680 |
| 16060000106721 | L16/dossiers | 16 | 16060000106720 | 16060000106720 | 1 | PA736181 | PM736416 |
| 16060000106722 | L16/dossiers | 16 | 16060000106720 | 16060000106720 | 2 | PA703538 | PM775715 |
| 16060000106723 | L16/dossiers | 16 | 16060000106720 | 16060000106720 | 3 | PA775228 | PM775516 |
| 16060000106724 | L16/dossiers | 16 | 16060000106720 | 16060000106720 | 4 | PA736237 | PM736417 |
| 16060000106725 | L16/dossiers | 16 | 16060000106720 | 16060000106720 | 5 | PA708632 | PM775667 |
| 16060000106732 | L16/dossiers | 16 | 16060000106731 | 16060000106731 | 1 | PA736193 | PM736394 |
| 16060000106733 | L16/dossiers | 16 | 16060000106731 | 16060000106731 | 2 | PA736180 | PM785871 |
| 16060000106751 | L16/dossiers | 16 | 16060000106750 | 16060000106750 | 1 | PA2116 | PM736339 |
| 16060000106758 | L16/dossiers | 16 | 16060000106757 | 16060000106757 | 1 | PA703520 | PM775705 |
| 16060000106765 | L16/dossiers | 16 | 16060000106764 | 16060000106764 | 1 | PA267762 | PM736366 |
| 16060000106772 | L16/dossiers | 16 | 16060000106771 | 16060000106771 | 1 | PA722252 | PM797610 |
| 16060000106779 | L16/dossiers | 16 | 16060000106778 | 16060000106778 | 1 | PA794314 | PM796848 |
| 16060000106786 | L16/dossiers | 16 | 16060000106785 | 16060000106785 | 1 | PA793342 | PM796269 |
| 16060000106793 | L16/dossiers | 16 | 16060000106792 | 16060000106792 | 1 | PA795156 | PM797334 |
| 16060000106800 | L16/dossiers | 16 | 16060000106799 | 16060000106799 | 1 | PA721474 | PM797511 |
| 16060000106807 | L16/dossiers | 16 | 16060000106806 | 16060000106806 | 1 | PA721024 | PM797592 |
| 16060000106818 | L16/dossiers | 16 | 16060000106817 | 16060000106817 | 1 | PA796118 | PM797859 |
| 16060000106822 | L16/dossiers | 16 | 16060000106821 | 16060000106821 | 1 | PA717161 | PM791583 |
| 16060000106823 | L16/dossiers | 16 | 16060000106821 | 16060000106821 | 2 | PA330357 | PM791696 |
| 16060000106836 | L16/dossiers | 16 | 16060000106835 | 16060000106835 | 1 | PA721474 | PM797511 |
| 16060000106843 | L16/dossiers | 16 | 16060000106842 | 16060000106842 | 1 | PA794522 | PM796971 |
| 16060000106850 | L16/dossiers | 16 | 16060000106849 | 16060000106849 | 1 | PA2116 | PM736339 |
| 16060000106857 | L16/dossiers | 16 | 16060000106856 | 16060000106856 | 1 | PA775248 | PM775554 |
| 16060000106864 | L16/dossiers | 16 | 16060000106863 | 16060000106863 | 1 | PA794038 | PM796668 |
| 16060000106879 | L16/dossiers | 16 | 16060000106878 | 16060000106878 | 1 | PA722390 | PM797214 |
| 16060000106883 | L16/dossiers | 16 | 16060000106882 | 16060000106882 | 1 | PA608826 | PM797256 |
| 16060000106890 | L16/dossiers | 16 | 16060000106889 | 16060000106889 | 1 | PA722390 | PM797214 |
| 16060000106897 | L16/dossiers | 16 | 16060000106896 | 16060000106896 | 1 | PA794022 | PM796662 |
| 16060000106912 | L16/dossiers | 16 | 16060000106911 | 16060000106911 | 1 | PA795808 | PM797694 |
| 16060000106921 | L16/dossiers | 16 | 16060000106920 | 16060000106920 | 1 | PA794146 | PM796737 |
| 16060000106925 | L16/dossiers | 16 | 16060000106924 | 16060000106924 | 1 | PA721314 | PM797151 |
| 16060000106932 | L16/dossiers | 16 | 16060000106931 | 16060000106931 | 1 | PA703485 | PM775811 |
| 16060000106939 | L16/dossiers | 16 | 16060000106938 | 16060000106938 | 1 | PA343988 | PM736310 |
| 16060000106946 | L16/dossiers | 16 | 16060000106945 | 16060000106945 | 1 | PA720892 | PM797520 |
| 16060000106953 | L16/dossiers | 16 | 16060000106952 | 16060000106952 | 1 | PA266788 | PM796788 |
| 16060000106960 | L16/dossiers | 16 | 16060000106959 | 16060000106959 | 1 | PA794038 | PM796668 |
| 16060000106967 | L16/dossiers | 16 | 16060000106966 | 16060000106966 | 1 | PA795778 | PM797682 |
| 16060000106974 | L16/dossiers | 16 | 16060000106973 | 16060000106973 | 1 | PA346054 | PM797679 |
| 16060000106981 | L16/dossiers | 16 | 16060000106980 | 16060000106980 | 1 | PA642847 | PM796872 |
| 16060000106988 | L16/dossiers | 16 | 16060000106987 | 16060000106987 | 1 | PA721314 | PM797151 |
| 16060000106995 | L16/dossiers | 16 | 16060000106994 | 16060000106994 | 1 | PA1874 | PM796383 |
| 16060000107002 | L16/dossiers | 16 | 16060000107001 | 16060000107001 | 1 | PA642847 | PM796872 |
| 16060000107009 | L16/dossiers | 16 | 16060000107008 | 16060000107008 | 1 | PA720900 | PM797553 |
| 16060000107016 | L16/dossiers | 16 | 16060000107015 | 16060000107015 | 1 | PA794670 | PM797049 |