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 |
|---|---|---|---|---|---|---|---|
| 17060000135320 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 10 | PA736200 | PM829845 |
| 17060000135321 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 11 | PA341381 | PM775747 |
| 17060000135322 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 12 | PA775228 | PM775516 |
| 17060000135323 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 13 | PA736198 | PM829861 |
| 17060000135324 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 14 | PA736224 | PM829913 |
| 17060000135325 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 15 | PA736213 | PM775791 |
| 17060000135326 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 16 | PA415447 | PM775785 |
| 17060000135327 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 17 | PA775238 | PM775540 |
| 17060000135328 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 18 | PA715322 | PM775713 |
| 17060000135329 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 19 | PA343988 | PM829809 |
| 17060000135330 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 20 | PA415495 | PM775635 |
| 17060000135331 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 21 | PA342523 | PM828470 |
| 17060000135332 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 22 | PA827964 | PM828652 |
| 17060000135333 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 23 | PA775278 | PM775564 |
| 17060000135334 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 24 | PA827952 | PM828698 |
| 17060000135335 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 25 | PA205280 | PM829891 |
| 17060000135342 | L17/dossiers | 17 | 17060000135341 | 17060000135341 | 1 | PA410 | PM855580 |
| 17060000135343 | L17/dossiers | 17 | 17060000135341 | 17060000135341 | 2 | PA721836 | PM855144 |
| 17060000135376 | L17/dossiers | 17 | 17060000135375 | 17060000135375 | 1 | PA410 | PM855580 |
| 17060000135468 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 1 | PA429886 | PM829757 |
| 17060000135469 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 2 | PA827912 | PM828488 |
| 17060000135470 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 3 | PA757676 | PM829801 |
| 17060000135471 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 4 | PA775172 | PM775474 |
| 17060000135472 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 5 | PA827898 | PM828454 |
| 17060000135473 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 6 | PA850008 | PM850016 |
| 17060000135474 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 7 | PA756685 | PM775777 |
| 17060000135475 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 8 | PA827930 | PM828544 |
| 17060000135476 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 9 | PA268007 | PM829695 |
| 17060000135477 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 10 | PA736195 | PM829855 |
| 17060000135478 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 11 | PA736173 | PM829799 |
| 17060000135479 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 12 | PA775246 | PM775532 |
| 17060000135480 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 13 | PA827962 | PM828676 |
| 17060000135481 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 14 | PA736243 | PM829929 |
| 17060000135482 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 15 | PA736175 | PM829795 |
| 17060000135483 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 16 | PA828002 | PM828856 |
| 17060000135484 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 17 | PA775296 | PM775596 |
| 17060000135485 | L17/dossiers | 17 | 17060000135467 | 17060000135467 | 18 | PA828020 | PM828864 |
| 17060000135492 | L17/dossiers | 17 | 17060000135491 | 17060000135491 | 1 | PA827912 | PM828488 |
| 17060000135499 | L17/dossiers | 17 | 17060000135498 | 17060000135498 | 1 | PA410 | PM855580 |
| 17060000135530 | L17/dossiers | 17 | 17060000135529 | 17060000135529 | 1 | PA827974 | PM828744 |
| 17060000135563 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 1 | PA827946 | PM828614 |
| 17060000135564 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 2 | PA775180 | PM775466 |
| 17060000135565 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 3 | PA827904 | PM828514 |
| 17060000135566 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 4 | PA429845 | PM829729 |
| 17060000135567 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 5 | PA775214 | PM775498 |
| 17060000135568 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 6 | PA775224 | PM775512 |
| 17060000135569 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 7 | PA736177 | PM829835 |
| 17060000135570 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 8 | PA827950 | PM828598 |
| 17060000135571 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 9 | PA775252 | PM775558 |
| 17060000135572 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 10 | PA827968 | PM828750 |