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 |
|---|---|---|---|---|---|---|---|
| 14060000125945 | L14/dossiers | 14 | 14060000125944 | 14060000125944 | 1 | PA1699 | PM645390 |
| 14060000125952 | L14/dossiers | 14 | 14060000125951 | 14060000125951 | 1 | PA687214 | PM687217 |
| 14060000125959 | L14/dossiers | 14 | 14060000125958 | 14060000125958 | 1 | PA2081 | PM430004 |
| 14060000125987 | L14/dossiers | 14 | 14060000125986 | 14060000125986 | 1 | PA267622 | PM702957 |
| 14060000126028 | L14/dossiers | 14 | 14060000126027 | 14060000126027 | 1 | PA2250 | PM645539 |
| 14060000126035 | L14/dossiers | 14 | 14060000126034 | 14060000126034 | 1 | PA610521 | PM645190 |
| 14060000126039 | L14/dossiers | 14 | 14060000126038 | 14060000126038 | 1 | PA607603 | PM645379 |
| 14060000126046 | L14/dossiers | 14 | 14060000126045 | 14060000126045 | 1 | PA267151 | PM645165 |
| 14060000126053 | L14/dossiers | 14 | 14060000126052 | 14060000126052 | 1 | PA267622 | PM702957 |
| 14060000126054 | L14/dossiers | 14 | 14060000126052 | 14060000126052 | 2 | PA2679 | PM702976 |
| 14060000126055 | L14/dossiers | 14 | 14060000126052 | 14060000126052 | 3 | PA1243 | PM702966 |
| 14060000126138 | L14/dossiers | 14 | 14060000126137 | 14060000126137 | 1 | PA1713 | PM703557 |
| 14060000126162 | L14/dossiers | 14 | 14060000126161 | 14060000126161 | 1 | PA335159 | PM645554 |
| 14060000126172 | L14/dossiers | 14 | 14060000126171 | 14060000126171 | 1 | PA267289 | PM645242 |
| 14060000126190 | L14/dossiers | 14 | 14060000126189 | 14060000126189 | 1 | PA713448 | PM713451 |
| 14060000126197 | L14/dossiers | 14 | 14060000126196 | 14060000126196 | 1 | PA1874 | PM645474 |
| 14060000126204 | L14/dossiers | 14 | 14060000126203 | 14060000126203 | 1 | PA998 | PM645034 |
| 14060000126211 | L14/dossiers | 14 | 14060000126210 | 14060000126210 | 1 | PA266788 | PM645294 |
| 14060000126221 | L14/dossiers | 14 | 14060000126220 | 14060000126220 | 1 | PA643069 | PM701218 |
| 14060000126225 | L14/dossiers | 14 | 14060000126224 | 14060000126224 | 1 | PA588872 | PM701032 |
| 14060000126232 | L14/dossiers | 14 | 14060000126231 | 14060000126231 | 1 | PA267165 | PM645360 |
| 14060000126244 | L14/dossiers | 14 | 14060000126243 | 14060000126243 | 1 | PA2098 | PM645351 |
| 14060000126251 | L14/dossiers | 14 | 14060000126250 | 14060000126250 | 1 | PA328 | PM653228 |
| 14060000126252 | L14/dossiers | 14 | 14060000126250 | 14060000126250 | 2 | PA2912 | PM653346 |
| 14060000126345 | L14/dossiers | 14 | 14060000126344 | 14060000126344 | 1 | PA328 | PM653228 |
| 14060000126459 | L14/dossiers | 14 | 14060000126458 | 14060000126458 | 1 | PA267285 | PM645140 |
| 14060000126466 | L14/dossiers | 14 | 14060000126465 | 14060000126465 | 1 | PA1141 | PM645468 |
| 14060000126476 | L14/dossiers | 14 | 14060000126475 | 14060000126475 | 1 | PA608416 | PM645586 |
| 14060000126483 | L14/dossiers | 14 | 14060000126482 | 14060000126482 | 1 | PA590032 | PM703298 |
| 14060000126490 | L14/dossiers | 14 | 14060000126489 | 14060000126489 | 1 | PA346886 | PM695110 |
| 14060000126497 | L14/dossiers | 14 | 14060000126496 | 14060000126496 | 1 | PA267241 | PM645246 |
| 14060000126504 | L14/dossiers | 14 | 14060000126503 | 14060000126503 | 1 | PA346886 | PM695110 |
| 14060000126508 | L14/dossiers | 14 | 14060000126507 | 14060000126507 | 1 | PA227092 | PM429944 |
| 14060000126517 | L14/dossiers | 14 | 14060000126516 | 14060000126516 | 1 | PA266776 | PM645590 |
| 14060000126524 | L14/dossiers | 14 | 14060000126523 | 14060000126523 | 1 | PA1838 | PM645238 |
| 14060000126531 | L14/dossiers | 14 | 14060000126530 | 14060000126530 | 1 | PA2801 | PM645576 |
| 14060000126535 | L14/dossiers | 14 | 14060000126534 | 14060000126534 | 1 | PA267433 | PM645316 |
| 14060000126542 | L14/dossiers | 14 | 14060000126541 | 14060000126541 | 1 | PA415482 | PM415579 |
| 14060000126561 | L14/dossiers | 14 | 14060000126560 | 14060000126560 | 1 | PA2667 | PM645429 |
| 14060000126568 | L14/dossiers | 14 | 14060000126567 | 14060000126567 | 1 | PA330788 | PM645510 |
| 14060000126575 | L14/dossiers | 14 | 14060000126574 | 14060000126574 | 1 | PA1857 | PM645505 |
| 14060000126582 | L14/dossiers | 14 | 14060000126581 | 14060000126581 | 1 | PA267622 | PM702957 |
| 14060000126583 | L14/dossiers | 14 | 14060000126581 | 14060000126581 | 2 | PA1872 | PM702970 |
| 14060000126663 | L14/dossiers | 14 | 14060000126662 | 14060000126662 | 1 | PA346886 | PM695110 |
| 14060000126670 | L14/dossiers | 14 | 14060000126669 | 14060000126669 | 1 | PA267492 | PM645465 |
| 14060000126677 | L14/dossiers | 14 | 14060000126676 | 14060000126676 | 1 | PA345897 | PM645209 |
| 14060000126687 | L14/dossiers | 14 | 14060000126686 | 14060000126686 | 1 | PA267080 | PM645531 |
| 14060000126694 | L14/dossiers | 14 | 14060000126693 | 14060000126693 | 1 | PA346886 | PM695110 |
| 14060000126701 | L14/dossiers | 14 | 14060000126700 | 14060000126700 | 1 | PA346886 | PM695110 |
| 14060000126708 | L14/dossiers | 14 | 14060000126707 | 14060000126707 | 1 | PA1880 | PM645072 |