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 |
|---|---|---|---|---|---|---|---|
| 15060000135398 | L15/dossiers | 15 | 15060000135397 | 15060000135397 | 1 | PA718784 | PM722456 |
| 15060000135405 | L15/dossiers | 15 | 15060000135404 | 15060000135404 | 1 | PA2796 | PM722510 |
| 15060000135412 | L15/dossiers | 15 | 15060000135411 | 15060000135411 | 1 | PA718780 | PM722454 |
| 15060000135419 | L15/dossiers | 15 | 15060000135418 | 15060000135418 | 1 | PA721932 | PM734586 |
| 15060000135426 | L15/dossiers | 15 | 15060000135425 | 15060000135425 | 1 | PA606212 | PM722662 |
| 15060000135433 | L15/dossiers | 15 | 15060000135432 | 15060000135432 | 1 | PA642868 | PM722992 |
| 15060000135440 | L15/dossiers | 15 | 15060000135439 | 15060000135439 | 1 | PA1874 | PM722598 |
| 15060000135447 | L15/dossiers | 15 | 15060000135446 | 15060000135446 | 1 | PA223837 | PM722458 |
| 15060000135454 | L15/dossiers | 15 | 15060000135453 | 15060000135453 | 1 | PA642847 | PM722954 |
| 15060000135461 | L15/dossiers | 15 | 15060000135460 | 15060000135460 | 1 | PA720614 | PM723016 |
| 15060000135468 | L15/dossiers | 15 | 15060000135467 | 15060000135467 | 1 | PA267260 | PM722476 |
| 15060000135475 | L15/dossiers | 15 | 15060000135474 | 15060000135474 | 1 | PA330788 | PM722570 |
| 15060000135482 | L15/dossiers | 15 | 15060000135481 | 15060000135481 | 1 | PA267785 | PM723310 |
| 15060000135489 | L15/dossiers | 15 | 15060000135488 | 15060000135488 | 1 | PA721932 | PM734586 |
| 15060000135496 | L15/dossiers | 15 | 15060000135495 | 15060000135495 | 1 | PA345619 | PM725692 |
| 15060000135509 | L15/dossiers | 15 | 15060000135508 | 15060000135508 | 1 | PA1206 | PM723354 |
| 15060000135516 | L15/dossiers | 15 | 15060000135515 | 15060000135515 | 1 | PA998 | PM723046 |
| 15060000135523 | L15/dossiers | 15 | 15060000135522 | 15060000135522 | 1 | PA998 | PM723046 |
| 15060000135530 | L15/dossiers | 15 | 15060000135529 | 15060000135529 | 1 | PA998 | PM723046 |
| 15060000135537 | L15/dossiers | 15 | 15060000135536 | 15060000135536 | 1 | PA998 | PM723046 |
| 15060000135547 | L15/dossiers | 15 | 15060000135546 | 15060000135546 | 1 | PA345619 | PM725692 |
| 15060000135554 | L15/dossiers | 15 | 15060000135553 | 15060000135553 | 1 | PA345619 | PM725692 |
| 15060000135593 | L15/dossiers | 15 | 15060000135592 | 15060000135592 | 1 | PA345619 | PM725692 |
| 15060000135600 | L15/dossiers | 15 | 15060000135599 | 15060000135599 | 1 | PA720546 | PM722996 |
| 15060000135618 | L15/dossiers | 15 | 15060000135617 | 15060000135617 | 1 | PA720692 | PM723042 |
| 15060000135634 | L15/dossiers | 15 | 15060000135633 | 15060000135633 | 1 | PA689 | PM723090 |
| 15060000135650 | L15/dossiers | 15 | 15060000135649 | 15060000135649 | 1 | PA721270 | PM723220 |
| 15060000135666 | L15/dossiers | 15 | 15060000135665 | 15060000135665 | 1 | PA267306 | PM723054 |
| 15060000135673 | L15/dossiers | 15 | 15060000135672 | 15060000135672 | 1 | PA340853 | PM722534 |
| 15060000135680 | L15/dossiers | 15 | 15060000135679 | 15060000135679 | 1 | PA718926 | PM722502 |
| 15060000135697 | L15/dossiers | 15 | 15060000135696 | 15060000135696 | 1 | PA345619 | PM725692 |
| 15060000135708 | L15/dossiers | 15 | 15060000135707 | 15060000135707 | 1 | PA345619 | PM725692 |
| 15060000135709 | L15/dossiers | 15 | 15060000135707 | 15060000135707 | 2 | PA1872 | PM730104 |
| 15060000135743 | L15/dossiers | 15 | 15060000135742 | 15060000135742 | 1 | PA330684 | PM722528 |
| 15060000135753 | L15/dossiers | 15 | 15060000135752 | 15060000135752 | 1 | PA718926 | PM722502 |
| 15060000135771 | L15/dossiers | 15 | 15060000135770 | 15060000135770 | 1 | PA720738 | PM723062 |
| 15060000135785 | L15/dossiers | 15 | 15060000135784 | 15060000135784 | 1 | PA441 | PM723152 |
| 15060000135792 | L15/dossiers | 15 | 15060000135791 | 15060000135791 | 1 | PA1206 | PM723354 |
| 15060000135799 | L15/dossiers | 15 | 15060000135798 | 15060000135798 | 1 | PA720846 | PM723094 |
| 15060000135806 | L15/dossiers | 15 | 15060000135805 | 15060000135805 | 1 | PA642847 | PM722954 |
| 15060000135813 | L15/dossiers | 15 | 15060000135812 | 15060000135812 | 1 | PA346218 | PM723348 |
| 15060000135820 | L15/dossiers | 15 | 15060000135819 | 15060000135819 | 1 | PA267450 | PM722586 |
| 15060000135827 | L15/dossiers | 15 | 15060000135826 | 15060000135826 | 1 | PA718850 | PM722478 |
| 15060000135834 | L15/dossiers | 15 | 15060000135833 | 15060000135833 | 1 | PA345619 | PM725692 |
| 15060000135865 | L15/dossiers | 15 | 15060000135864 | 15060000135864 | 1 | PA340853 | PM722534 |
| 15060000135872 | L15/dossiers | 15 | 15060000135871 | 15060000135871 | 1 | PA719608 | PM722710 |
| 15060000135879 | L15/dossiers | 15 | 15060000135878 | 15060000135878 | 1 | PA266808 | PM723264 |
| 15060000135886 | L15/dossiers | 15 | 15060000135885 | 15060000135885 | 1 | PA346218 | PM723348 |
| 15060000135893 | L15/dossiers | 15 | 15060000135892 | 15060000135892 | 1 | PA267794 | PM722468 |
| 15060000135900 | L15/dossiers | 15 | 15060000135899 | 15060000135899 | 1 | PA333818 | PM722990 |