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 |
|---|---|---|---|---|---|---|---|
| 15060000160306 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 12 | PA732419 | PM760862 |
| 15060000160307 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 13 | PA736195 | PM736357 |
| 15060000160308 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 14 | PA736177 | PM736318 |
| 15060000160309 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 15 | PA736173 | PM736369 |
| 15060000160310 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 16 | PA703508 | PM703601 |
| 15060000160311 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 17 | PA415476 | PM703653 |
| 15060000160312 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 18 | PA736225 | PM736334 |
| 15060000160313 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 19 | PA703536 | PM703563 |
| 15060000160314 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 20 | PA429866 | PM736287 |
| 15060000160315 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 21 | PA678263 | PM736330 |
| 15060000160316 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 22 | PA1978 | PM736337 |
| 15060000160317 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 23 | PA415484 | PM703622 |
| 15060000160318 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 24 | PA736243 | PM736413 |
| 15060000160319 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 25 | PA736209 | PM736400 |
| 15060000160320 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 26 | PA703499 | PM703641 |
| 15060000160321 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 27 | PA429889 | PM736313 |
| 15060000160322 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 28 | PA736175 | PM736344 |
| 15060000160323 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 29 | PA736201 | PM736347 |
| 15060000160324 | L15/dossiers | 15 | 15060000160294 | 15060000160294 | 30 | PA2870 | PM736316 |
| 15060000160340 | L15/dossiers | 15 | 15060000160339 | 15060000160339 | 1 | PA415486 | PM703623 |
| 15060000160347 | L15/dossiers | 15 | 15060000160346 | 15060000160346 | 1 | PA415486 | PM703623 |
| 15060000160354 | L15/dossiers | 15 | 15060000160353 | 15060000160353 | 1 | PA415486 | PM703623 |
| 15060000160361 | L15/dossiers | 15 | 15060000160360 | 15060000160360 | 1 | PA2116 | PM736339 |
| 15060000160368 | L15/dossiers | 15 | 15060000160367 | 15060000160367 | 1 | PA736182 | PM736346 |
| 15060000160384 | L15/dossiers | 15 | 15060000160383 | 15060000160383 | 1 | PA345619 | PM725692 |
| 15060000160385 | L15/dossiers | 15 | 15060000160383 | 15060000160383 | 2 | PA717153 | PM730062 |
| 15060000160386 | L15/dossiers | 15 | 15060000160383 | 15060000160383 | 3 | PA720512 | PM768829 |
| 15060000160472 | L15/dossiers | 15 | 15060000160471 | 15060000160471 | 1 | PA345619 | PM725692 |
| 15060000160473 | L15/dossiers | 15 | 15060000160471 | 15060000160471 | 2 | PA717153 | PM730062 |
| 15060000160474 | L15/dossiers | 15 | 15060000160471 | 15060000160471 | 3 | PA720512 | PM768829 |
| 15060000160573 | L15/dossiers | 15 | 15060000160572 | 15060000160572 | 1 | PA345619 | PM725692 |
| 15060000160616 | L15/dossiers | 15 | 15060000160615 | 15060000160615 | 1 | PA345619 | PM725692 |
| 15060000160617 | L15/dossiers | 15 | 15060000160615 | 15060000160615 | 2 | PA717161 | PM766508 |
| 15060000160624 | L15/dossiers | 15 | 15060000160623 | 15060000160623 | 1 | PA345619 | PM725692 |
| 15060000160688 | L15/dossiers | 15 | 15060000160687 | 15060000160687 | 1 | PA266867 | PM703554 |
| 15060000160699 | L15/dossiers | 15 | 15060000160698 | 15060000160698 | 1 | PA721896 | PM723414 |
| 15060000160706 | L15/dossiers | 15 | 15060000160705 | 15060000160705 | 1 | PA643089 | PM758076 |
| 15060000160713 | L15/dossiers | 15 | 15060000160712 | 15060000160712 | 1 | PA718784 | PM722456 |
| 15060000160720 | L15/dossiers | 15 | 15060000160719 | 15060000160719 | 1 | PA718850 | PM722478 |
| 15060000160727 | L15/dossiers | 15 | 15060000160726 | 15060000160726 | 1 | PA722390 | PM723560 |
| 15060000160734 | L15/dossiers | 15 | 15060000160733 | 15060000160733 | 1 | PA267306 | PM723054 |
| 15060000160741 | L15/dossiers | 15 | 15060000160740 | 15060000160740 | 1 | PA721560 | PM764780 |
| 15060000160748 | L15/dossiers | 15 | 15060000160747 | 15060000160747 | 1 | PA720684 | PM723040 |
| 15060000160755 | L15/dossiers | 15 | 15060000160754 | 15060000160754 | 1 | PA722390 | PM723560 |
| 15060000160762 | L15/dossiers | 15 | 15060000160761 | 15060000160761 | 1 | PA642847 | PM722954 |
| 15060000160769 | L15/dossiers | 15 | 15060000160768 | 15060000160768 | 1 | PA722390 | PM723560 |
| 15060000160776 | L15/dossiers | 15 | 15060000160775 | 15060000160775 | 1 | PA2377 | PM723550 |
| 15060000160783 | L15/dossiers | 15 | 15060000160782 | 15060000160782 | 1 | PA266788 | PM722914 |
| 15060000160790 | L15/dossiers | 15 | 15060000160789 | 15060000160789 | 1 | PA689 | PM723090 |
| 15060000160797 | L15/dossiers | 15 | 15060000160796 | 15060000160796 | 1 | PA719520 | PM722684 |