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 |
|---|---|---|---|---|---|---|---|
| 14060000105572 | L14/dossiers | 14 | 14060000105571 | 14060000105571 | 1 | PA608186 | PM645202 |
| 14060000105593 | L14/dossiers | 14 | 14060000105592 | 14060000105592 | 1 | PA266788 | PM645294 |
| 14060000105600 | L14/dossiers | 14 | 14060000105599 | 14060000105599 | 1 | PA328 | PM653228 |
| 14060000105601 | L14/dossiers | 14 | 14060000105599 | 14060000105599 | 2 | PA1268 | PM653525 |
| 14060000105637 | L14/dossiers | 14 | 14060000105636 | 14060000105636 | 1 | PA2597 | PM645126 |
| 14060000105648 | L14/dossiers | 14 | 14060000105647 | 14060000105647 | 1 | PA267492 | PM645465 |
| 14060000105655 | L14/dossiers | 14 | 14060000105654 | 14060000105654 | 1 | PA2952 | PM645464 |
| 14060000105662 | L14/dossiers | 14 | 14060000105661 | 14060000105661 | 1 | PA735 | PM645089 |
| 14060000105679 | L14/dossiers | 14 | 14060000105678 | 14060000105678 | 1 | PA1466 | PM645240 |
| 14060000105686 | L14/dossiers | 14 | 14060000105685 | 14060000105685 | 1 | PA785 | PM715797 |
| 14060000105693 | L14/dossiers | 14 | 14060000105692 | 14060000105692 | 1 | PA345619 | PM717221 |
| 14060000105700 | L14/dossiers | 14 | 14060000105699 | 14060000105699 | 1 | PA267459 | PM645564 |
| 14060000105711 | L14/dossiers | 14 | 14060000105710 | 14060000105710 | 1 | PA334149 | PM645127 |
| 14060000105725 | L14/dossiers | 14 | 14060000105724 | 14060000105724 | 1 | PA267735 | PM645237 |
| 14060000105732 | L14/dossiers | 14 | 14060000105731 | 14060000105731 | 1 | PA267622 | PM702957 |
| 14060000105739 | L14/dossiers | 14 | 14060000105738 | 14060000105738 | 1 | PA609726 | PM645311 |
| 14060000105746 | L14/dossiers | 14 | 14060000105745 | 14060000105745 | 1 | PA266788 | PM645294 |
| 14060000105753 | L14/dossiers | 14 | 14060000105752 | 14060000105752 | 1 | PA2075 | PM645260 |
| 14060000105760 | L14/dossiers | 14 | 14060000105759 | 14060000105759 | 1 | PA588872 | PM701032 |
| 14060000105767 | L14/dossiers | 14 | 14060000105766 | 14060000105766 | 1 | PA695100 | PM695111 |
| 14060000105774 | L14/dossiers | 14 | 14060000105773 | 14060000105773 | 1 | PA606098 | PM645171 |
| 14060000105781 | L14/dossiers | 14 | 14060000105780 | 14060000105780 | 1 | PA1699 | PM645390 |
| 14060000105788 | L14/dossiers | 14 | 14060000105787 | 14060000105787 | 1 | PA689 | PM645113 |
| 14060000105795 | L14/dossiers | 14 | 14060000105794 | 14060000105794 | 1 | PA2048 | PM693013 |
| 14060000105802 | L14/dossiers | 14 | 14060000105801 | 14060000105801 | 1 | PA610594 | PM645185 |
| 14060000105832 | L14/dossiers | 14 | 14060000105831 | 14060000105831 | 1 | PA2011 | PM645434 |
| 14060000105839 | L14/dossiers | 14 | 14060000105838 | 14060000105838 | 1 | PA230 | PM645553 |
| 14060000105846 | L14/dossiers | 14 | 14060000105845 | 14060000105845 | 1 | PA2790 | PM429928 |
| 14060000105888 | L14/dossiers | 14 | 14060000105887 | 14060000105887 | 1 | PA609513 | PM645228 |
| 14060000105903 | L14/dossiers | 14 | 14060000105902 | 14060000105902 | 1 | PA267673 | PM645249 |
| 14060000105925 | L14/dossiers | 14 | 14060000105924 | 14060000105924 | 1 | PA328 | PM653228 |
| 14060000105926 | L14/dossiers | 14 | 14060000105924 | 14060000105924 | 2 | PA1268 | PM653525 |
| 14060000105958 | L14/dossiers | 14 | 14060000105957 | 14060000105957 | 1 | PA267622 | PM702957 |
| 14060000105959 | L14/dossiers | 14 | 14060000105957 | 14060000105957 | 2 | PA1268 | PM702961 |
| 14060000105990 | L14/dossiers | 14 | 14060000105989 | 14060000105989 | 1 | PA606212 | PM645330 |
| 14060000105997 | L14/dossiers | 14 | 14060000105996 | 14060000105996 | 1 | PA328 | PM653228 |
| 14060000106030 | L14/dossiers | 14 | 14060000106029 | 14060000106029 | 1 | PA415455 | PM415535 |
| 14060000106074 | L14/dossiers | 14 | 14060000106073 | 14060000106073 | 1 | PA2664 | PM645139 |
| 14060000106088 | L14/dossiers | 14 | 14060000106087 | 14060000106087 | 1 | PA330684 | PM645497 |
| 14060000106095 | L14/dossiers | 14 | 14060000106094 | 14060000106094 | 1 | PA267492 | PM645465 |
| 14060000106099 | L14/dossiers | 14 | 14060000106098 | 14060000106098 | 1 | PA785 | PM715797 |
| 14060000106106 | L14/dossiers | 14 | 14060000106105 | 14060000106105 | 1 | PA267622 | PM702957 |
| 14060000106113 | L14/dossiers | 14 | 14060000106112 | 14060000106112 | 1 | PA267285 | PM645140 |
| 14060000106120 | L14/dossiers | 14 | 14060000106119 | 14060000106119 | 1 | PA267622 | PM700712 |
| 14060000106203 | L14/dossiers | 14 | 14060000106202 | 14060000106202 | 1 | PA267042 | PM645368 |
| 14060000106213 | L14/dossiers | 14 | 14060000106212 | 14060000106212 | 1 | PA1886 | PM645099 |
| 14060000106220 | L14/dossiers | 14 | 14060000106219 | 14060000106219 | 1 | PA1206 | PM645054 |
| 14060000106227 | L14/dossiers | 14 | 14060000106226 | 14060000106226 | 1 | PA334149 | PM645127 |
| 14060000106234 | L14/dossiers | 14 | 14060000106233 | 14060000106233 | 1 | PA267492 | PM645465 |
| 14060000106241 | L14/dossiers | 14 | 14060000106240 | 14060000106240 | 1 | PA606495 | PM645463 |