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 |
|---|---|---|---|---|---|---|---|
| 16060000100466 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 59 | PA227096 | PM736342 |
| 16060000100467 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 60 | PA227096 | PM736342 |
| 16060000100468 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 61 | PA775294 | PM775580 |
| 16060000100469 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 62 | PA2870 | PM736316 |
| 16060000100470 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 63 | PA2870 | PM736316 |
| 16060000100471 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 64 | PA736162 | PM736320 |
| 16060000100472 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 65 | PA429852 | PM736275 |
| 16060000100473 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 66 | PA605888 | PM775604 |
| 16060000100483 | L16/dossiers | 16 | 16060000100482 | 16060000100482 | 1 | PA703511 | PM775685 |
| 16060000100484 | L16/dossiers | 16 | 16060000100482 | 16060000100482 | 2 | PA415447 | PM775785 |
| 16060000100485 | L16/dossiers | 16 | 16060000100482 | 16060000100482 | 3 | PA429832 | PM736408 |
| 16060000100486 | L16/dossiers | 16 | 16060000100482 | 16060000100482 | 4 | PA736212 | PM736331 |
| 16060000100516 | L16/dossiers | 16 | 16060000100515 | 16060000100515 | 1 | PA718850 | PM796203 |
| 16060000100523 | L16/dossiers | 16 | 16060000100522 | 16060000100522 | 1 | PA722202 | PM797358 |
| 16060000100530 | L16/dossiers | 16 | 16060000100529 | 16060000100529 | 1 | PA719608 | PM796593 |
| 16060000100537 | L16/dossiers | 16 | 16060000100536 | 16060000100536 | 1 | PA794894 | PM797181 |
| 16060000100544 | L16/dossiers | 16 | 16060000100543 | 16060000100543 | 1 | PA795636 | PM797601 |
| 16060000100551 | L16/dossiers | 16 | 16060000100550 | 16060000100550 | 1 | PA717161 | PM791583 |
| 16060000100583 | L16/dossiers | 16 | 16060000100582 | 16060000100582 | 1 | PA736216 | PM736273 |
| 16060000100590 | L16/dossiers | 16 | 16060000100589 | 16060000100589 | 1 | PA717161 | PM791583 |
| 16060000100675 | L16/dossiers | 16 | 16060000100674 | 16060000100674 | 1 | PA717161 | PM791583 |
| 16060000100686 | L16/dossiers | 16 | 16060000100685 | 16060000100685 | 1 | PA608695 | PM797220 |
| 16060000100693 | L16/dossiers | 16 | 16060000100692 | 16060000100692 | 1 | PA795616 | PM797589 |
| 16060000100700 | L16/dossiers | 16 | 16060000100699 | 16060000100699 | 1 | PA793736 | PM796503 |
| 16060000100707 | L16/dossiers | 16 | 16060000100706 | 16060000100706 | 1 | PA605694 | PM796401 |
| 16060000100714 | L16/dossiers | 16 | 16060000100713 | 16060000100713 | 1 | PA266788 | PM796788 |
| 16060000100721 | L16/dossiers | 16 | 16060000100720 | 16060000100720 | 1 | PA266788 | PM796788 |
| 16060000100728 | L16/dossiers | 16 | 16060000100727 | 16060000100727 | 1 | PA266788 | PM796788 |
| 16060000100735 | L16/dossiers | 16 | 16060000100734 | 16060000100734 | 1 | PA266788 | PM796788 |
| 16060000100742 | L16/dossiers | 16 | 16060000100741 | 16060000100741 | 1 | PA266788 | PM796788 |
| 16060000100749 | L16/dossiers | 16 | 16060000100748 | 16060000100748 | 1 | PA266788 | PM796788 |
| 16060000100756 | L16/dossiers | 16 | 16060000100755 | 16060000100755 | 1 | PA266788 | PM796788 |
| 16060000100763 | L16/dossiers | 16 | 16060000100762 | 16060000100762 | 1 | PA266788 | PM796788 |
| 16060000100770 | L16/dossiers | 16 | 16060000100769 | 16060000100769 | 1 | PA266788 | PM796788 |
| 16060000100777 | L16/dossiers | 16 | 16060000100776 | 16060000100776 | 1 | PA266788 | PM796788 |
| 16060000100784 | L16/dossiers | 16 | 16060000100783 | 16060000100783 | 1 | PA266788 | PM796788 |
| 16060000100791 | L16/dossiers | 16 | 16060000100790 | 16060000100790 | 1 | PA266788 | PM796788 |
| 16060000100798 | L16/dossiers | 16 | 16060000100797 | 16060000100797 | 1 | PA266788 | PM796788 |
| 16060000100805 | L16/dossiers | 16 | 16060000100804 | 16060000100804 | 1 | PA266788 | PM796788 |
| 16060000100812 | L16/dossiers | 16 | 16060000100811 | 16060000100811 | 1 | PA719272 | PM796347 |
| 16060000100819 | L16/dossiers | 16 | 16060000100818 | 16060000100818 | 1 | PA2952 | PM796206 |
| 16060000100826 | L16/dossiers | 16 | 16060000100825 | 16060000100825 | 1 | PA643089 | PM797439 |
| 16060000100836 | L16/dossiers | 16 | 16060000100835 | 16060000100835 | 1 | PA721270 | PM797829 |
| 16060000100837 | L16/dossiers | 16 | 16060000100835 | 16060000100835 | 2 | PA267306 | PM797073 |
| 16060000100838 | L16/dossiers | 16 | 16060000100835 | 16060000100835 | 3 | PA720838 | PM797865 |
| 16060000100839 | L16/dossiers | 16 | 16060000100835 | 16060000100835 | 4 | PA721118 | PM797376 |
| 16060000100846 | L16/dossiers | 16 | 16060000100845 | 16060000100845 | 1 | PA703513 | PM775671 |
| 16060000100847 | L16/dossiers | 16 | 16060000100845 | 16060000100845 | 2 | PA775284 | PM775590 |
| 16060000100854 | L16/dossiers | 16 | 16060000100853 | 16060000100853 | 1 | PA775264 | PM775570 |
| 16060000100861 | L16/dossiers | 16 | 16060000100860 | 16060000100860 | 1 | PA794598 | PM797010 |