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 |
|---|---|---|---|---|---|---|---|
| 15060000142547 | L15/dossiers | 15 | 15060000142546 | 15060000142546 | 1 | PA2796 | PM722510 |
| 15060000142554 | L15/dossiers | 15 | 15060000142553 | 15060000142553 | 1 | PA642847 | PM722954 |
| 15060000142561 | L15/dossiers | 15 | 15060000142560 | 15060000142560 | 1 | PA718884 | PM722488 |
| 15060000142565 | L15/dossiers | 15 | 15060000142564 | 15060000142564 | 1 | PA718884 | PM722488 |
| 15060000142575 | L15/dossiers | 15 | 15060000142574 | 15060000142574 | 1 | PA346054 | PM723510 |
| 15060000142582 | L15/dossiers | 15 | 15060000142581 | 15060000142581 | 1 | PA713448 | PM722452 |
| 15060000142589 | L15/dossiers | 15 | 15060000142588 | 15060000142588 | 1 | PA712014 | PM722984 |
| 15060000142596 | L15/dossiers | 15 | 15060000142595 | 15060000142595 | 1 | PA643134 | PM722824 |
| 15060000142603 | L15/dossiers | 15 | 15060000142602 | 15060000142602 | 1 | PA643134 | PM722824 |
| 15060000142610 | L15/dossiers | 15 | 15060000142609 | 15060000142609 | 1 | PA718784 | PM722456 |
| 15060000142617 | L15/dossiers | 15 | 15060000142616 | 15060000142616 | 1 | PA605694 | PM722558 |
| 15060000142624 | L15/dossiers | 15 | 15060000142623 | 15060000142623 | 1 | PA721968 | PM723436 |
| 15060000142631 | L15/dossiers | 15 | 15060000142630 | 15060000142630 | 1 | PA712015 | PM722448 |
| 15060000142638 | L15/dossiers | 15 | 15060000142637 | 15060000142637 | 1 | PA267233 | PM723500 |
| 15060000142645 | L15/dossiers | 15 | 15060000142644 | 15060000142644 | 1 | PA721486 | PM723290 |
| 15060000142721 | L15/dossiers | 15 | 15060000142720 | 15060000142720 | 1 | PA719318 | PM722624 |
| 15060000142728 | L15/dossiers | 15 | 15060000142727 | 15060000142727 | 1 | PA2150 | PM722506 |
| 15060000142738 | L15/dossiers | 15 | 15060000142737 | 15060000142737 | 1 | PA2538 | PM703570 |
| 15060000142818 | L15/dossiers | 15 | 15060000142817 | 15060000142817 | 1 | PA345619 | PM725692 |
| 15060000142819 | L15/dossiers | 15 | 15060000142817 | 15060000142817 | 2 | PA607846 | PM730066 |
| 15060000142820 | L15/dossiers | 15 | 15060000142817 | 15060000142817 | 3 | PA717153 | PM730062 |
| 15060000142940 | L15/dossiers | 15 | 15060000142939 | 15060000142939 | 1 | PA719946 | PM722808 |
| 15060000142950 | L15/dossiers | 15 | 15060000142949 | 15060000142949 | 1 | PA719684 | PM722730 |
| 15060000142951 | L15/dossiers | 15 | 15060000142949 | 15060000142949 | 2 | PA720772 | PM723072 |
| 15060000142967 | L15/dossiers | 15 | 15060000142966 | 15060000142966 | 1 | PA223837 | PM722458 |
| 15060000142974 | L15/dossiers | 15 | 15060000142973 | 15060000142973 | 1 | PA719700 | PM722734 |
| 15060000142981 | L15/dossiers | 15 | 15060000142980 | 15060000142980 | 1 | PA334149 | PM723034 |
| 15060000142988 | L15/dossiers | 15 | 15060000142987 | 15060000142987 | 1 | PA642847 | PM722954 |
| 15060000142995 | L15/dossiers | 15 | 15060000142994 | 15060000142994 | 1 | PA718784 | PM722456 |
| 15060000143002 | L15/dossiers | 15 | 15060000143001 | 15060000143001 | 1 | PA267585 | PM722978 |
| 15060000143009 | L15/dossiers | 15 | 15060000143008 | 15060000143008 | 1 | PA345619 | PM725692 |
| 15060000143016 | L15/dossiers | 15 | 15060000143015 | 15060000143015 | 1 | PA642935 | PM723238 |
| 15060000143023 | L15/dossiers | 15 | 15060000143022 | 15060000143022 | 1 | PA718884 | PM722488 |
| 15060000143030 | L15/dossiers | 15 | 15060000143029 | 15060000143029 | 1 | PA718884 | PM722488 |
| 15060000143037 | L15/dossiers | 15 | 15060000143036 | 15060000143036 | 1 | PA719946 | PM722808 |
| 15060000143044 | L15/dossiers | 15 | 15060000143043 | 15060000143043 | 1 | PA334149 | PM723034 |
| 15060000143051 | L15/dossiers | 15 | 15060000143050 | 15060000143050 | 1 | PA345619 | PM725692 |
| 15060000143082 | L15/dossiers | 15 | 15060000143081 | 15060000143081 | 1 | PA345619 | PM725692 |
| 15060000143136 | L15/dossiers | 15 | 15060000143135 | 15060000143135 | 1 | PA266797 | PM722884 |
| 15060000143141 | L15/dossiers | 15 | 15060000143140 | 15060000143140 | 1 | PA429836 | PM736345 |
| 15060000143153 | L15/dossiers | 15 | 15060000143152 | 15060000143152 | 1 | PA736206 | PM736351 |
| 15060000143211 | L15/dossiers | 15 | 15060000143210 | 15060000143210 | 1 | PA303996 | PM703614 |
| 15060000143241 | L15/dossiers | 15 | 15060000143240 | 15060000143240 | 1 | PA429895 | PM736262 |
| 15060000143343 | L15/dossiers | 15 | 15060000143342 | 15060000143342 | 1 | PA720002 | PM722830 |
| 15060000143411 | L15/dossiers | 15 | 15060000143410 | 15060000143410 | 1 | PA720334 | PM722932 |
| 15060000143456 | L15/dossiers | 15 | 15060000143455 | 15060000143455 | 1 | PA721234 | PM723210 |
| 15060000143487 | L15/dossiers | 15 | 15060000143486 | 15060000143486 | 1 | PA267780 | PM723504 |
| 15060000143494 | L15/dossiers | 15 | 15060000143493 | 15060000143493 | 1 | PA719946 | PM722808 |
| 15060000143501 | L15/dossiers | 15 | 15060000143500 | 15060000143500 | 1 | PA719946 | PM722808 |
| 15060000143508 | L15/dossiers | 15 | 15060000143507 | 15060000143507 | 1 | PA267780 | PM723504 |