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 |
|---|---|---|---|---|---|---|---|
| 14060000092574 | L14/dossiers | 14 | 14060000092573 | 14060000092573 | 1 | PA330240 | PM645425 |
| 14060000092591 | L14/dossiers | 14 | 14060000092590 | 14060000092590 | 1 | PA2048 | PM693013 |
| 14060000092598 | L14/dossiers | 14 | 14060000092597 | 14060000092597 | 1 | PA267622 | PM702957 |
| 14060000092629 | L14/dossiers | 14 | 14060000092628 | 14060000092628 | 1 | PA607619 | PM645383 |
| 14060000092636 | L14/dossiers | 14 | 14060000092635 | 14060000092635 | 1 | PA267433 | PM645316 |
| 14060000092643 | L14/dossiers | 14 | 14060000092642 | 14060000092642 | 1 | PA304015 | PM430030 |
| 14060000092670 | L14/dossiers | 14 | 14060000092669 | 14060000092669 | 1 | PA2011 | PM645434 |
| 14060000092677 | L14/dossiers | 14 | 14060000092676 | 14060000092676 | 1 | PA267622 | PM702957 |
| 14060000092678 | L14/dossiers | 14 | 14060000092676 | 14060000092676 | 2 | PA1268 | PM702961 |
| 14060000092708 | L14/dossiers | 14 | 14060000092707 | 14060000092707 | 1 | PA605036 | PM645278 |
| 14060000092715 | L14/dossiers | 14 | 14060000092714 | 14060000092714 | 1 | PA267622 | PM702957 |
| 14060000092716 | L14/dossiers | 14 | 14060000092714 | 14060000092714 | 2 | PA1268 | PM702961 |
| 14060000092755 | L14/dossiers | 14 | 14060000092754 | 14060000092754 | 1 | PA335319 | PM645070 |
| 14060000092768 | L14/dossiers | 14 | 14060000092767 | 14060000092767 | 1 | PA606478 | PM645457 |
| 14060000092775 | L14/dossiers | 14 | 14060000092774 | 14060000092774 | 1 | PA1886 | PM645099 |
| 14060000092830 | L14/dossiers | 14 | 14060000092829 | 14060000092829 | 1 | PA267336 | PM645424 |
| 14060000092837 | L14/dossiers | 14 | 14060000092836 | 14060000092836 | 1 | PA605643 | PM645405 |
| 14060000092844 | L14/dossiers | 14 | 14060000092843 | 14060000092843 | 1 | PA267622 | PM702957 |
| 14060000092851 | L14/dossiers | 14 | 14060000092850 | 14060000092850 | 1 | PA267327 | PM645031 |
| 14060000092858 | L14/dossiers | 14 | 14060000092857 | 14060000092857 | 1 | PA328 | PM653228 |
| 14060000092981 | L14/dossiers | 14 | 14060000092980 | 14060000092980 | 1 | PA2552 | PM429997 |
| 14060000093028 | L14/dossiers | 14 | 14060000093027 | 14060000093027 | 1 | PA687214 | PM687217 |
| 14060000093035 | L14/dossiers | 14 | 14060000093034 | 14060000093034 | 1 | PA267429 | PM645130 |
| 14060000093042 | L14/dossiers | 14 | 14060000093041 | 14060000093041 | 1 | PA268019 | PM645116 |
| 14060000093049 | L14/dossiers | 14 | 14060000093048 | 14060000093048 | 1 | PA2664 | PM645139 |
| 14060000093056 | L14/dossiers | 14 | 14060000093055 | 14060000093055 | 1 | PA429849 | PM429952 |
| 14060000093067 | L14/dossiers | 14 | 14060000093066 | 14060000093066 | 1 | PA606478 | PM645457 |
| 14060000093074 | L14/dossiers | 14 | 14060000093073 | 14060000093073 | 1 | PA266788 | PM645294 |
| 14060000093084 | L14/dossiers | 14 | 14060000093083 | 14060000093083 | 1 | PA785 | PM715797 |
| 14060000093091 | L14/dossiers | 14 | 14060000093090 | 14060000093090 | 1 | PA268019 | PM645116 |
| 14060000093098 | L14/dossiers | 14 | 14060000093097 | 14060000093097 | 1 | PA266788 | PM645294 |
| 14060000093105 | L14/dossiers | 14 | 14060000093104 | 14060000093104 | 1 | PA267622 | PM702957 |
| 14060000093106 | L14/dossiers | 14 | 14060000093104 | 14060000093104 | 2 | PA1268 | PM702961 |
| 14060000093138 | L14/dossiers | 14 | 14060000093137 | 14060000093137 | 1 | PA267622 | PM702957 |
| 14060000093139 | L14/dossiers | 14 | 14060000093137 | 14060000093137 | 2 | PA785 | PM702979 |
| 14060000093173 | L14/dossiers | 14 | 14060000093172 | 14060000093172 | 1 | PA2086 | PM645043 |
| 14060000093180 | L14/dossiers | 14 | 14060000093179 | 14060000093179 | 1 | PA267260 | PM645459 |
| 14060000093187 | L14/dossiers | 14 | 14060000093186 | 14060000093186 | 1 | PA1152 | PM645561 |
| 14060000093194 | L14/dossiers | 14 | 14060000093193 | 14060000093193 | 1 | PA606412 | PM645400 |
| 14060000093204 | L14/dossiers | 14 | 14060000093203 | 14060000093203 | 1 | PA267622 | PM702957 |
| 14060000093211 | L14/dossiers | 14 | 14060000093210 | 14060000093210 | 1 | PA2796 | PM645520 |
| 14060000093218 | L14/dossiers | 14 | 14060000093217 | 14060000093217 | 1 | PA267622 | PM702957 |
| 14060000093219 | L14/dossiers | 14 | 14060000093217 | 14060000093217 | 2 | PA2825 | PM702962 |
| 14060000093226 | L14/dossiers | 14 | 14060000093225 | 14060000093225 | 1 | PA2971 | PM645392 |
| 14060000093233 | L14/dossiers | 14 | 14060000093232 | 14060000093232 | 1 | PA267622 | PM702957 |
| 14060000093234 | L14/dossiers | 14 | 14060000093232 | 14060000093232 | 2 | PA1268 | PM702961 |
| 14060000093244 | L14/dossiers | 14 | 14060000093243 | 14060000093243 | 1 | PA267794 | PM645442 |
| 14060000093251 | L14/dossiers | 14 | 14060000093250 | 14060000093250 | 1 | PA1874 | PM645474 |
| 14060000093261 | L14/dossiers | 14 | 14060000093260 | 14060000093260 | 1 | PA337568 | PM645287 |
| 14060000093273 | L14/dossiers | 14 | 14060000093272 | 14060000093272 | 1 | PA606212 | PM645330 |