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 |
|---|---|---|---|---|---|---|---|
| 16060000106363 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 1 | PA736195 | PM736357 |
| 16060000106364 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 2 | PA1978 | PM736337 |
| 16060000106365 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 3 | PA757676 | PM757692 |
| 16060000106366 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 4 | PA304082 | PM736354 |
| 16060000106367 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 5 | PA775172 | PM775474 |
| 16060000106368 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 6 | PA429894 | PM736364 |
| 16060000106369 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 7 | PA756685 | PM775777 |
| 16060000106370 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 8 | PA429836 | PM736345 |
| 16060000106371 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 9 | PA429886 | PM736385 |
| 16060000106372 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 10 | PA736173 | PM736369 |
| 16060000106373 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 11 | PA775246 | PM775532 |
| 16060000106374 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 12 | PA678263 | PM736330 |
| 16060000106375 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 13 | PA736243 | PM736413 |
| 16060000106376 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 14 | PA736175 | PM736344 |
| 16060000106377 | L16/dossiers | 16 | 16060000106362 | 16060000106362 | 15 | PA775296 | PM775596 |
| 16060000106384 | L16/dossiers | 16 | 16060000106383 | 16060000106383 | 1 | PA2116 | PM736339 |
| 16060000106391 | L16/dossiers | 16 | 16060000106390 | 16060000106390 | 1 | PA425322 | PM736282 |
| 16060000106392 | L16/dossiers | 16 | 16060000106390 | 16060000106390 | 2 | PA736200 | PM736285 |
| 16060000106393 | L16/dossiers | 16 | 16060000106390 | 16060000106390 | 3 | PA703493 | PM775659 |
| 16060000106424 | L16/dossiers | 16 | 16060000106423 | 16060000106423 | 1 | PA736196 | PM736370 |
| 16060000106431 | L16/dossiers | 16 | 16060000106430 | 16060000106430 | 1 | PA703510 | PM775681 |
| 16060000106438 | L16/dossiers | 16 | 16060000106437 | 16060000106437 | 1 | PA717161 | PM791583 |
| 16060000106439 | L16/dossiers | 16 | 16060000106437 | 16060000106437 | 2 | PA312976 | PM791676 |
| 16060000106471 | L16/dossiers | 16 | 16060000106470 | 16060000106470 | 1 | PA717161 | PM791583 |
| 16060000106472 | L16/dossiers | 16 | 16060000106470 | 16060000106470 | 2 | PA773443 | PM791682 |
| 16060000106479 | L16/dossiers | 16 | 16060000106478 | 16060000106478 | 1 | PA267766 | PM796980 |
| 16060000106484 | L16/dossiers | 16 | 16060000106483 | 16060000106483 | 1 | PA708632 | PM775667 |
| 16060000106491 | L16/dossiers | 16 | 16060000106490 | 16060000106490 | 1 | PA717161 | PM791583 |
| 16060000106521 | L16/dossiers | 16 | 16060000106520 | 16060000106520 | 1 | PA703485 | PM775811 |
| 16060000106528 | L16/dossiers | 16 | 16060000106527 | 16060000106527 | 1 | PA721474 | PM797511 |
| 16060000106535 | L16/dossiers | 16 | 16060000106534 | 16060000106534 | 1 | PA793904 | PM796596 |
| 16060000106542 | L16/dossiers | 16 | 16060000106541 | 16060000106541 | 1 | PA346782 | PM797691 |
| 16060000106546 | L16/dossiers | 16 | 16060000106545 | 16060000106545 | 1 | PA266797 | PM796812 |
| 16060000106550 | L16/dossiers | 16 | 16060000106549 | 16060000106549 | 1 | PA266788 | PM796788 |
| 16060000106560 | L16/dossiers | 16 | 16060000106559 | 16060000106559 | 1 | PA607395 | PM796818 |
| 16060000106568 | L16/dossiers | 16 | 16060000106567 | 16060000106567 | 1 | PA795552 | PM797547 |
| 16060000106575 | L16/dossiers | 16 | 16060000106574 | 16060000106574 | 1 | PA588884 | PM797373 |
| 16060000106591 | L16/dossiers | 16 | 16060000106590 | 16060000106590 | 1 | PA775292 | PM775582 |
| 16060000106598 | L16/dossiers | 16 | 16060000106597 | 16060000106597 | 1 | PA2116 | PM736339 |
| 16060000106605 | L16/dossiers | 16 | 16060000106604 | 16060000106604 | 1 | PA717161 | PM791583 |
| 16060000106612 | L16/dossiers | 16 | 16060000106611 | 16060000106611 | 1 | PA2116 | PM736339 |
| 16060000106619 | L16/dossiers | 16 | 16060000106618 | 16060000106618 | 1 | PA346782 | PM797691 |
| 16060000106626 | L16/dossiers | 16 | 16060000106625 | 16060000106625 | 1 | PA719286 | PM796353 |
| 16060000106635 | L16/dossiers | 16 | 16060000106634 | 16060000106634 | 1 | PA718784 | PM796266 |
| 16060000106642 | L16/dossiers | 16 | 16060000106641 | 16060000106641 | 1 | PA721486 | PM797517 |
| 16060000106649 | L16/dossiers | 16 | 16060000106648 | 16060000106648 | 1 | PA717161 | PM791583 |
| 16060000106650 | L16/dossiers | 16 | 16060000106648 | 16060000106648 | 2 | PA801862 | PM801948 |
| 16060000106657 | L16/dossiers | 16 | 16060000106656 | 16060000106656 | 1 | PA793330 | PM796263 |
| 16060000106664 | L16/dossiers | 16 | 16060000106663 | 16060000106663 | 1 | PA721474 | PM797511 |
| 16060000106671 | L16/dossiers | 16 | 16060000106670 | 16060000106670 | 1 | PA783457 | PM796992 |