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 |
|---|---|---|---|---|---|---|---|
| 17060000140830 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 21 | PA703500 | PM775643 |
| 17060000140831 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 22 | PA703517 | PM775675 |
| 17060000140832 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 23 | PA736186 | PM829807 |
| 17060000140833 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 24 | PA773891 | PM829713 |
| 17060000140834 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 25 | PA703537 | PM775721 |
| 17060000140835 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 26 | PA775298 | PM775594 |
| 17060000140836 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 27 | PA775270 | PM775572 |
| 17060000140837 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 28 | PA267075 | PM775610 |
| 17060000140838 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 29 | PA775178 | PM775460 |
| 17060000140848 | L17/dossiers | 17 | 17060000140847 | 17060000140847 | 1 | PA796062 | PM843668 |
| 17060000140852 | L17/dossiers | 17 | 17060000140851 | 17060000140851 | 1 | PA794938 | PM843308 |
| 17060000140856 | L17/dossiers | 17 | 17060000140855 | 17060000140855 | 1 | PA736196 | PM829865 |
| 17060000140857 | L17/dossiers | 17 | 17060000140855 | 17060000140855 | 2 | PA828010 | PM828832 |
| 17060000140882 | L17/dossiers | 17 | 17060000140881 | 17060000140881 | 1 | PA841207 | PM842798 |
| 17060000140886 | L17/dossiers | 17 | 17060000140885 | 17060000140885 | 1 | PA794778 | PM843239 |
| 17060000140890 | L17/dossiers | 17 | 17060000140889 | 17060000140889 | 1 | PA775188 | PM775490 |
| 17060000140914 | L17/dossiers | 17 | 17060000140913 | 17060000140913 | 1 | PA841207 | PM842798 |
| 17060000140928 | L17/dossiers | 17 | 17060000140927 | 17060000140927 | 1 | PA712014 | PM858454 |
| 17060000140932 | L17/dossiers | 17 | 17060000140931 | 17060000140931 | 1 | PA719558 | PM842663 |
| 17060000140939 | L17/dossiers | 17 | 17060000140938 | 17060000140938 | 1 | PA643210 | PM873637 |
| 17060000140940 | L17/dossiers | 17 | 17060000140938 | 17060000140938 | 2 | PA720066 | PM873675 |
| 17060000140941 | L17/dossiers | 17 | 17060000140938 | 17060000140938 | 3 | PA721670 | PM873693 |
| 17060000140942 | L17/dossiers | 17 | 17060000140938 | 17060000140938 | 4 | PA873624 | PM873671 |
| 17060000141070 | L17/dossiers | 17 | 17060000141069 | 17060000141069 | 1 | PA841681 | PM843245 |
| 17060000141077 | L17/dossiers | 17 | 17060000141076 | 17060000141076 | 1 | PA341981 | PM842822 |
| 17060000141099 | L17/dossiers | 17 | 17060000141098 | 17060000141098 | 1 | PA794770 | PM843236 |
| 17060000141106 | L17/dossiers | 17 | 17060000141105 | 17060000141105 | 1 | PA718850 | PM842411 |
| 17060000141113 | L17/dossiers | 17 | 17060000141112 | 17060000141112 | 1 | PA718850 | PM842411 |
| 17060000141120 | L17/dossiers | 17 | 17060000141119 | 17060000141119 | 1 | PA610968 | PM840381 |
| 17060000141127 | L17/dossiers | 17 | 17060000141126 | 17060000141126 | 1 | PA794138 | PM842909 |
| 17060000141134 | L17/dossiers | 17 | 17060000141133 | 17060000141133 | 1 | PA793122 | PM842369 |
| 17060000141141 | L17/dossiers | 17 | 17060000141140 | 17060000141140 | 1 | PA840979 | PM842588 |
| 17060000141148 | L17/dossiers | 17 | 17060000141147 | 17060000141147 | 1 | PA331973 | PM842624 |
| 17060000141155 | L17/dossiers | 17 | 17060000141154 | 17060000141154 | 1 | PA794658 | PM843164 |
| 17060000141162 | L17/dossiers | 17 | 17060000141161 | 17060000141161 | 1 | PA794658 | PM843164 |
| 17060000141169 | L17/dossiers | 17 | 17060000141168 | 17060000141168 | 1 | PA736201 | PM840423 |
| 17060000141176 | L17/dossiers | 17 | 17060000141175 | 17060000141175 | 1 | PA794870 | PM843185 |
| 17060000141183 | L17/dossiers | 17 | 17060000141182 | 17060000141182 | 1 | PA795466 | PM843443 |
| 17060000141190 | L17/dossiers | 17 | 17060000141189 | 17060000141189 | 1 | PA794486 | PM843110 |
| 17060000141197 | L17/dossiers | 17 | 17060000141196 | 17060000141196 | 1 | PA736201 | PM840423 |
| 17060000141204 | L17/dossiers | 17 | 17060000141203 | 17060000141203 | 1 | PA736201 | PM840423 |
| 17060000141211 | L17/dossiers | 17 | 17060000141210 | 17060000141210 | 1 | PA793708 | PM842525 |
| 17060000141218 | L17/dossiers | 17 | 17060000141217 | 17060000141217 | 1 | PA720386 | PM843020 |
| 17060000141225 | L17/dossiers | 17 | 17060000141224 | 17060000141224 | 1 | PA720386 | PM843020 |
| 17060000141232 | L17/dossiers | 17 | 17060000141231 | 17060000141231 | 1 | PA793322 | PM840246 |
| 17060000141240 | L17/dossiers | 17 | 17060000141239 | 17060000141239 | 1 | PA793322 | PM840246 |
| 17060000141247 | L17/dossiers | 17 | 17060000141246 | 17060000141246 | 1 | PA793322 | PM840246 |
| 17060000141254 | L17/dossiers | 17 | 17060000141253 | 17060000141253 | 1 | PA841769 | PM843323 |
| 17060000141261 | L17/dossiers | 17 | 17060000141260 | 17060000141260 | 1 | PA720838 | PM843671 |
| 17060000141268 | L17/dossiers | 17 | 17060000141267 | 17060000141267 | 1 | PA840171 | PM840360 |