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 |
|---|---|---|---|---|---|---|---|
| 16060000103349 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 10 | PA775176 | PM775462 |
| 16060000103350 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 11 | PA736199 | PM736284 |
| 16060000103351 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 12 | PA736231 | PM736381 |
| 16060000103352 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 13 | PA429886 | PM736385 |
| 16060000103353 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 14 | PA429833 | PM736271 |
| 16060000103354 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 15 | PA736229 | PM736389 |
| 16060000103355 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 16 | PA703523 | PM775703 |
| 16060000103422 | L16/dossiers | 16 | 16060000103421 | 16060000103421 | 1 | PA795808 | PM797694 |
| 16060000103429 | L16/dossiers | 16 | 16060000103428 | 16060000103428 | 1 | PA795228 | PM797370 |
| 16060000103436 | L16/dossiers | 16 | 16060000103435 | 16060000103435 | 1 | PA796090 | PM797844 |
| 16060000103443 | L16/dossiers | 16 | 16060000103442 | 16060000103442 | 1 | PA721486 | PM797517 |
| 16060000103450 | L16/dossiers | 16 | 16060000103449 | 16060000103449 | 1 | PA721984 | PM797367 |
| 16060000103457 | L16/dossiers | 16 | 16060000103456 | 16060000103456 | 1 | PA794030 | PM796665 |
| 16060000103464 | L16/dossiers | 16 | 16060000103463 | 16060000103463 | 1 | PA605782 | PM796350 |
| 16060000103474 | L16/dossiers | 16 | 16060000103473 | 16060000103473 | 1 | PA720704 | PM797067 |
| 16060000103475 | L16/dossiers | 16 | 16060000103473 | 16060000103473 | 2 | PA266797 | PM796812 |
| 16060000103512 | L16/dossiers | 16 | 16060000103511 | 16060000103511 | 1 | PA608695 | PM797220 |
| 16060000103535 | L16/dossiers | 16 | 16060000103534 | 16060000103534 | 1 | PA609332 | PM797532 |
| 16060000103557 | L16/dossiers | 16 | 16060000103556 | 16060000103556 | 1 | PA736201 | PM797523 |
| 16060000103564 | L16/dossiers | 16 | 16060000103563 | 16060000103563 | 1 | PA717161 | PM791583 |
| 16060000103572 | L16/dossiers | 16 | 16060000103571 | 16060000103571 | 1 | PA793194 | PM796200 |
| 16060000103580 | L16/dossiers | 16 | 16060000103579 | 16060000103579 | 1 | PA795828 | PM797703 |
| 16060000103601 | L16/dossiers | 16 | 16060000103600 | 16060000103600 | 1 | PA720692 | PM796986 |
| 16060000103605 | L16/dossiers | 16 | 16060000103604 | 16060000103604 | 1 | PA722308 | PM797229 |
| 16060000103612 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 1 | PA429845 | PM736278 |
| 16060000103613 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 2 | PA775180 | PM775466 |
| 16060000103614 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 3 | PA801838 | PM801842 |
| 16060000103615 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 4 | PA775214 | PM775498 |
| 16060000103616 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 5 | PA775224 | PM775512 |
| 16060000103617 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 6 | PA736177 | PM736318 |
| 16060000103618 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 7 | PA429866 | PM736287 |
| 16060000103619 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 8 | PA775252 | PM775558 |
| 16060000103620 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 9 | PA775272 | PM775562 |
| 16060000103621 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 10 | PA775282 | PM775584 |
| 16060000103622 | L16/dossiers | 16 | 16060000103611 | 16060000103611 | 11 | PA785857 | PM785867 |
| 16060000103632 | L16/dossiers | 16 | 16060000103631 | 16060000103631 | 1 | PA775248 | PM775554 |
| 16060000103639 | L16/dossiers | 16 | 16060000103638 | 16060000103638 | 1 | PA721474 | PM797511 |
| 16060000103643 | L16/dossiers | 16 | 16060000103642 | 16060000103642 | 1 | PA346782 | PM797691 |
| 16060000103650 | L16/dossiers | 16 | 16060000103649 | 16060000103649 | 1 | PA794118 | PM796725 |
| 16060000103657 | L16/dossiers | 16 | 16060000103656 | 16060000103656 | 1 | PA794118 | PM796725 |
| 16060000103664 | L16/dossiers | 16 | 16060000103663 | 16060000103663 | 1 | PA793394 | PM796299 |
| 16060000103679 | L16/dossiers | 16 | 16060000103678 | 16060000103678 | 1 | PA720430 | PM797025 |
| 16060000103686 | L16/dossiers | 16 | 16060000103685 | 16060000103685 | 1 | PA609590 | PM797742 |
| 16060000103693 | L16/dossiers | 16 | 16060000103692 | 16060000103692 | 1 | PA609590 | PM797742 |
| 16060000103697 | L16/dossiers | 16 | 16060000103696 | 16060000103696 | 1 | PA607489 | PM736390 |
| 16060000103704 | L16/dossiers | 16 | 16060000103703 | 16060000103703 | 1 | PA717161 | PM791583 |
| 16060000103786 | L16/dossiers | 16 | 16060000103785 | 16060000103785 | 1 | PA717161 | PM791583 |
| 16060000103816 | L16/dossiers | 16 | 16060000103815 | 16060000103815 | 1 | PA717161 | PM791583 |
| 16060000103817 | L16/dossiers | 16 | 16060000103815 | 16060000103815 | 2 | PA330357 | PM791696 |
| 16060000103818 | L16/dossiers | 16 | 16060000103815 | 16060000103815 | 3 | PA429846 | PM801952 |