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 |
|---|---|---|---|---|---|---|---|
| 16060000119358 | L16/dossiers | 16 | 16060000119357 | 16060000119357 | 1 | PA795820 | PM797700 |
| 16060000119362 | L16/dossiers | 16 | 16060000119361 | 16060000119361 | 1 | PA721474 | PM797511 |
| 16060000119366 | L16/dossiers | 16 | 16060000119365 | 16060000119365 | 1 | PA415454 | PM785875 |
| 16060000119373 | L16/dossiers | 16 | 16060000119372 | 16060000119372 | 1 | PA415454 | PM785875 |
| 16060000119384 | L16/dossiers | 16 | 16060000119383 | 16060000119383 | 1 | PA720728 | PM797157 |
| 16060000119393 | L16/dossiers | 16 | 16060000119392 | 16060000119392 | 1 | PA775292 | PM775582 |
| 16060000119417 | L16/dossiers | 16 | 16060000119416 | 16060000119416 | 1 | PA794410 | PM796911 |
| 16060000119424 | L16/dossiers | 16 | 16060000119423 | 16060000119423 | 1 | PA720908 | PM797556 |
| 16060000119435 | L16/dossiers | 16 | 16060000119434 | 16060000119434 | 1 | PA795362 | PM797442 |
| 16060000119447 | L16/dossiers | 16 | 16060000119446 | 16060000119446 | 1 | PA794178 | PM796755 |
| 16060000119454 | L16/dossiers | 16 | 16060000119453 | 16060000119453 | 1 | PA736196 | PM829865 |
| 16060000119461 | L16/dossiers | 16 | 16060000119460 | 16060000119460 | 1 | PA793664 | PM796467 |
| 16060000119465 | L16/dossiers | 16 | 16060000119464 | 16060000119464 | 1 | PA718930 | PM796287 |
| 16060000119485 | L16/dossiers | 16 | 16060000119484 | 16060000119484 | 1 | PA794718 | PM797079 |
| 16060000119492 | L16/dossiers | 16 | 16060000119491 | 16060000119491 | 1 | PA608172 | PM797064 |
| 16060000119526 | L16/dossiers | 16 | 16060000119525 | 16060000119525 | 1 | PA794094 | PM796710 |
| 16060000119533 | L16/dossiers | 16 | 16060000119532 | 16060000119532 | 1 | PA794270 | PM796821 |
| 16060000119540 | L16/dossiers | 16 | 16060000119539 | 16060000119539 | 1 | PA609590 | PM797742 |
| 16060000119562 | L16/dossiers | 16 | 16060000119561 | 16060000119561 | 1 | PA793816 | PM796548 |
| 16060000119573 | L16/dossiers | 16 | 16060000119572 | 16060000119572 | 1 | PA795762 | PM797670 |
| 16060000119595 | L16/dossiers | 16 | 16060000119594 | 16060000119594 | 1 | PA609332 | PM797532 |
| 16060000119609 | L16/dossiers | 16 | 16060000119608 | 16060000119608 | 1 | PA344201 | PM818321 |
| 16060000119620 | L16/dossiers | 16 | 16060000119619 | 16060000119619 | 1 | PA333285 | PM796926 |
| 16060000119632 | L16/dossiers | 16 | 16060000119631 | 16060000119631 | 1 | PA795430 | PM797481 |
| 16060000119650 | L16/dossiers | 16 | 16060000119649 | 16060000119649 | 1 | PA703513 | PM775671 |
| 16060000119657 | L16/dossiers | 16 | 16060000119656 | 16060000119656 | 1 | PA833735 | PM833737 |
| 16060000119681 | L16/dossiers | 16 | 16060000119680 | 16060000119680 | 1 | PA736196 | PM829865 |
| 16060000119682 | L16/dossiers | 16 | 16060000119680 | 16060000119680 | 2 | PA827958 | PM828690 |
| 16060000119689 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 1 | PA827912 | PM828488 |
| 16060000119690 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 2 | PA827962 | PM828676 |
| 16060000119691 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 3 | PA827930 | PM828544 |
| 16060000119692 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 4 | PA757676 | PM829801 |
| 16060000119693 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 5 | PA775172 | PM775474 |
| 16060000119694 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 6 | PA827898 | PM828454 |
| 16060000119695 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 7 | PA429894 | PM829765 |
| 16060000119696 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 8 | PA756685 | PM775777 |
| 16060000119697 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 9 | PA268007 | PM829695 |
| 16060000119698 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 10 | PA429886 | PM829757 |
| 16060000119699 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 11 | PA736195 | PM829855 |
| 16060000119700 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 12 | PA736173 | PM829799 |
| 16060000119701 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 13 | PA775246 | PM775532 |
| 16060000119702 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 14 | PA828002 | PM828856 |
| 16060000119703 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 15 | PA736243 | PM829929 |
| 16060000119704 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 16 | PA736175 | PM829795 |
| 16060000119705 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 17 | PA775296 | PM775596 |
| 16060000119706 | L16/dossiers | 16 | 16060000119688 | 16060000119688 | 18 | PA828020 | PM828864 |
| 16060000119713 | L16/dossiers | 16 | 16060000119712 | 16060000119712 | 1 | PA795636 | PM797601 |
| 16060000119720 | L16/dossiers | 16 | 16060000119719 | 16060000119719 | 1 | PA795808 | PM797694 |
| 16060000119724 | L16/dossiers | 16 | 16060000119723 | 16060000119723 | 1 | PA736175 | PM829795 |
| 16060000119725 | L16/dossiers | 16 | 16060000119723 | 16060000119723 | 2 | PA827898 | PM828454 |