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 |
|---|---|---|---|---|---|---|---|
| 14060000107606 | L14/dossiers | 14 | 14060000107605 | 14060000107605 | 1 | PA267622 | PM702957 |
| 14060000107607 | L14/dossiers | 14 | 14060000107605 | 14060000107605 | 2 | PA2650 | PM711559 |
| 14060000107615 | L14/dossiers | 14 | 14060000107614 | 14060000107614 | 1 | PA1886 | PM645099 |
| 14060000107681 | L14/dossiers | 14 | 14060000107680 | 14060000107680 | 1 | PA267227 | PM645618 |
| 14060000107688 | L14/dossiers | 14 | 14060000107687 | 14060000107687 | 1 | PA917 | PM645163 |
| 14060000107695 | L14/dossiers | 14 | 14060000107694 | 14060000107694 | 1 | PA328 | PM653228 |
| 14060000107696 | L14/dossiers | 14 | 14060000107694 | 14060000107694 | 2 | PA1268 | PM653525 |
| 14060000107725 | L14/dossiers | 14 | 14060000107724 | 14060000107724 | 1 | PA267673 | PM645249 |
| 14060000107732 | L14/dossiers | 14 | 14060000107731 | 14060000107731 | 1 | PA2048 | PM693013 |
| 14060000107739 | L14/dossiers | 14 | 14060000107738 | 14060000107738 | 1 | PA334149 | PM645127 |
| 14060000107749 | L14/dossiers | 14 | 14060000107748 | 14060000107748 | 1 | PA267622 | PM702957 |
| 14060000107750 | L14/dossiers | 14 | 14060000107748 | 14060000107748 | 2 | PA702992 | PM702994 |
| 14060000107928 | L14/dossiers | 14 | 14060000107927 | 14060000107927 | 1 | PA1886 | PM645099 |
| 14060000107942 | L14/dossiers | 14 | 14060000107941 | 14060000107941 | 1 | PA709315 | PM709318 |
| 14060000107949 | L14/dossiers | 14 | 14060000107948 | 14060000107948 | 1 | PA267306 | PM645210 |
| 14060000107956 | L14/dossiers | 14 | 14060000107955 | 14060000107955 | 1 | PA1857 | PM645505 |
| 14060000107966 | L14/dossiers | 14 | 14060000107965 | 14060000107965 | 1 | PA346886 | PM695110 |
| 14060000107973 | L14/dossiers | 14 | 14060000107972 | 14060000107972 | 1 | PA1263 | PM645432 |
| 14060000107994 | L14/dossiers | 14 | 14060000107993 | 14060000107993 | 1 | PA2792 | PM645308 |
| 14060000108001 | L14/dossiers | 14 | 14060000108000 | 14060000108000 | 1 | PA268019 | PM645116 |
| 14060000108008 | L14/dossiers | 14 | 14060000108007 | 14060000108007 | 1 | PA309643 | PM645326 |
| 14060000108015 | L14/dossiers | 14 | 14060000108014 | 14060000108014 | 1 | PA334149 | PM645127 |
| 14060000108022 | L14/dossiers | 14 | 14060000108021 | 14060000108021 | 1 | PA267622 | PM702957 |
| 14060000108052 | L14/dossiers | 14 | 14060000108051 | 14060000108051 | 1 | PA1886 | PM645099 |
| 14060000108079 | L14/dossiers | 14 | 14060000108078 | 14060000108078 | 1 | PA1263 | PM645432 |
| 14060000108086 | L14/dossiers | 14 | 14060000108085 | 14060000108085 | 1 | PA295 | PM645103 |
| 14060000108093 | L14/dossiers | 14 | 14060000108092 | 14060000108092 | 1 | PA606899 | PM645545 |
| 14060000108100 | L14/dossiers | 14 | 14060000108099 | 14060000108099 | 1 | PA267260 | PM645459 |
| 14060000108107 | L14/dossiers | 14 | 14060000108106 | 14060000108106 | 1 | PA266788 | PM645294 |
| 14060000108114 | L14/dossiers | 14 | 14060000108113 | 14060000108113 | 1 | PA2713 | PM645148 |
| 14060000108121 | L14/dossiers | 14 | 14060000108120 | 14060000108120 | 1 | PA334149 | PM645127 |
| 14060000108128 | L14/dossiers | 14 | 14060000108127 | 14060000108127 | 1 | PA1874 | PM645474 |
| 14060000108135 | L14/dossiers | 14 | 14060000108134 | 14060000108134 | 1 | PA344492 | PM645300 |
| 14060000108142 | L14/dossiers | 14 | 14060000108141 | 14060000108141 | 1 | PA998 | PM645034 |
| 14060000108149 | L14/dossiers | 14 | 14060000108148 | 14060000108148 | 1 | PA267246 | PM645340 |
| 14060000108159 | L14/dossiers | 14 | 14060000108158 | 14060000108158 | 1 | PA429860 | PM429990 |
| 14060000108178 | L14/dossiers | 14 | 14060000108177 | 14060000108177 | 1 | PA346886 | PM695110 |
| 14060000108188 | L14/dossiers | 14 | 14060000108187 | 14060000108187 | 1 | PA267813 | PM645172 |
| 14060000108195 | L14/dossiers | 14 | 14060000108194 | 14060000108194 | 1 | PA2250 | PM645539 |
| 14060000108202 | L14/dossiers | 14 | 14060000108201 | 14060000108201 | 1 | PA227094 | PM429960 |
| 14060000108226 | L14/dossiers | 14 | 14060000108225 | 14060000108225 | 1 | PA1874 | PM645474 |
| 14060000108233 | L14/dossiers | 14 | 14060000108232 | 14060000108232 | 1 | PA330684 | PM645497 |
| 14060000108240 | L14/dossiers | 14 | 14060000108239 | 14060000108239 | 1 | PA335159 | PM645554 |
| 14060000108247 | L14/dossiers | 14 | 14060000108246 | 14060000108246 | 1 | PA346886 | PM695110 |
| 14060000108254 | L14/dossiers | 14 | 14060000108253 | 14060000108253 | 1 | PA267622 | PM702957 |
| 14060000108255 | L14/dossiers | 14 | 14060000108253 | 14060000108253 | 2 | PA1268 | PM702961 |
| 14060000108287 | L14/dossiers | 14 | 14060000108286 | 14060000108286 | 1 | PA334149 | PM645127 |
| 14060000108294 | L14/dossiers | 14 | 14060000108293 | 14060000108293 | 1 | PA267785 | PM645359 |
| 14060000108301 | L14/dossiers | 14 | 14060000108300 | 14060000108300 | 1 | PA2011 | PM645434 |
| 14060000108314 | L14/dossiers | 14 | 14060000108313 | 14060000108313 | 1 | PA346886 | PM695110 |