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 |
|---|---|---|---|---|---|---|---|
| 15060000157610 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 4 | PA429894 | PM736364 |
| 15060000157611 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 5 | PA756685 | PM756689 |
| 15060000157612 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 6 | PA429836 | PM736345 |
| 15060000157613 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 7 | PA304071 | PM703676 |
| 15060000157614 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 8 | PA429886 | PM736385 |
| 15060000157615 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 9 | PA736195 | PM736357 |
| 15060000157616 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 10 | PA736177 | PM736318 |
| 15060000157617 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 11 | PA736173 | PM736369 |
| 15060000157618 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 12 | PA678263 | PM736330 |
| 15060000157619 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 13 | PA736243 | PM736413 |
| 15060000157620 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 14 | PA703499 | PM703641 |
| 15060000157621 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 15 | PA736175 | PM736344 |
| 15060000157622 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 16 | PA1978 | PM736337 |
| 15060000157629 | L15/dossiers | 15 | 15060000157628 | 15060000157628 | 1 | PA2116 | PM736339 |
| 15060000157636 | L15/dossiers | 15 | 15060000157635 | 15060000157635 | 1 | PA429860 | PM736398 |
| 15060000157643 | L15/dossiers | 15 | 15060000157642 | 15060000157642 | 1 | PA2116 | PM736339 |
| 15060000157667 | L15/dossiers | 15 | 15060000157666 | 15060000157666 | 1 | PA703514 | PM703585 |
| 15060000157674 | L15/dossiers | 15 | 15060000157673 | 15060000157673 | 1 | PA343988 | PM736310 |
| 15060000157681 | L15/dossiers | 15 | 15060000157680 | 15060000157680 | 1 | PA2116 | PM736339 |
| 15060000157682 | L15/dossiers | 15 | 15060000157680 | 15060000157680 | 2 | PA736236 | PM736341 |
| 15060000157683 | L15/dossiers | 15 | 15060000157680 | 15060000157680 | 3 | PA736203 | PM736432 |
| 15060000157690 | L15/dossiers | 15 | 15060000157689 | 15060000157689 | 1 | PA2116 | PM736339 |
| 15060000157691 | L15/dossiers | 15 | 15060000157689 | 15060000157689 | 2 | PA736236 | PM736341 |
| 15060000157692 | L15/dossiers | 15 | 15060000157689 | 15060000157689 | 3 | PA736203 | PM736432 |
| 15060000157699 | L15/dossiers | 15 | 15060000157698 | 15060000157698 | 1 | PA736235 | PM736426 |
| 15060000157706 | L15/dossiers | 15 | 15060000157705 | 15060000157705 | 1 | PA736238 | PM736352 |
| 15060000157713 | L15/dossiers | 15 | 15060000157712 | 15060000157712 | 1 | PA304021 | PM736299 |
| 15060000157714 | L15/dossiers | 15 | 15060000157712 | 15060000157712 | 2 | PA267762 | PM736366 |
| 15060000157715 | L15/dossiers | 15 | 15060000157712 | 15060000157712 | 3 | PA513 | PM703605 |
| 15060000157722 | L15/dossiers | 15 | 15060000157721 | 15060000157721 | 1 | PA429874 | PM736314 |
| 15060000157729 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 1 | PA304071 | PM703676 |
| 15060000157730 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 2 | PA304082 | PM736354 |
| 15060000157731 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 3 | PA757676 | PM757692 |
| 15060000157732 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 4 | PA429891 | PM736329 |
| 15060000157733 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 5 | PA429894 | PM736364 |
| 15060000157734 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 6 | PA756685 | PM756689 |
| 15060000157735 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 7 | PA429836 | PM736345 |
| 15060000157736 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 8 | PA429886 | PM736385 |
| 15060000157737 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 9 | PA736195 | PM736357 |
| 15060000157738 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 10 | PA736177 | PM736318 |
| 15060000157739 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 11 | PA736173 | PM736369 |
| 15060000157740 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 12 | PA1978 | PM736337 |
| 15060000157741 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 13 | PA678263 | PM736330 |
| 15060000157742 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 14 | PA736243 | PM736413 |
| 15060000157743 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 15 | PA703499 | PM703641 |
| 15060000157744 | L15/dossiers | 15 | 15060000157728 | 15060000157728 | 16 | PA736175 | PM736344 |
| 15060000157757 | L15/dossiers | 15 | 15060000157756 | 15060000157756 | 1 | PA2116 | PM736339 |
| 15060000157770 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 1 | PA429894 | PM736364 |
| 15060000157771 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 2 | PA736175 | PM736344 |
| 15060000157772 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 3 | PA757676 | PM757692 |