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 |
|---|---|---|---|---|---|---|---|
| 15060000138045 | L15/dossiers | 15 | 15060000138044 | 15060000138044 | 1 | PA267901 | PM723166 |
| 15060000138067 | L15/dossiers | 15 | 15060000138066 | 15060000138066 | 1 | PA415446 | PM703678 |
| 15060000138087 | L15/dossiers | 15 | 15060000138086 | 15060000138086 | 1 | PA342564 | PM736388 |
| 15060000138106 | L15/dossiers | 15 | 15060000138105 | 15060000138105 | 1 | PA703529 | PM703650 |
| 15060000138125 | L15/dossiers | 15 | 15060000138124 | 15060000138124 | 1 | PA720968 | PM723126 |
| 15060000138132 | L15/dossiers | 15 | 15060000138131 | 15060000138131 | 1 | PA266788 | PM722914 |
| 15060000138136 | L15/dossiers | 15 | 15060000138135 | 15060000138135 | 1 | PA2150 | PM722506 |
| 15060000138144 | L15/dossiers | 15 | 15060000138143 | 15060000138143 | 1 | PA713448 | PM722452 |
| 15060000138151 | L15/dossiers | 15 | 15060000138150 | 15060000138150 | 1 | PA720614 | PM723016 |
| 15060000138158 | L15/dossiers | 15 | 15060000138157 | 15060000138157 | 1 | PA330909 | PM722548 |
| 15060000138165 | L15/dossiers | 15 | 15060000138164 | 15060000138164 | 1 | PA1206 | PM723354 |
| 15060000138172 | L15/dossiers | 15 | 15060000138171 | 15060000138171 | 1 | PA718838 | PM722474 |
| 15060000138179 | L15/dossiers | 15 | 15060000138178 | 15060000138178 | 1 | PA721054 | PM723156 |
| 15060000138186 | L15/dossiers | 15 | 15060000138185 | 15060000138185 | 1 | PA2377 | PM723550 |
| 15060000138193 | L15/dossiers | 15 | 15060000138192 | 15060000138192 | 1 | PA720468 | PM722972 |
| 15060000138200 | L15/dossiers | 15 | 15060000138199 | 15060000138199 | 1 | PA330788 | PM722570 |
| 15060000138207 | L15/dossiers | 15 | 15060000138206 | 15060000138206 | 1 | PA720586 | PM723008 |
| 15060000138235 | L15/dossiers | 15 | 15060000138234 | 15060000138234 | 1 | PA330909 | PM722548 |
| 15060000138242 | L15/dossiers | 15 | 15060000138241 | 15060000138241 | 1 | PA268019 | PM723092 |
| 15060000138249 | L15/dossiers | 15 | 15060000138248 | 15060000138248 | 1 | PA266808 | PM723264 |
| 15060000138256 | L15/dossiers | 15 | 15060000138255 | 15060000138255 | 1 | PA268019 | PM723092 |
| 15060000138278 | L15/dossiers | 15 | 15060000138277 | 15060000138277 | 1 | PA643134 | PM722824 |
| 15060000138288 | L15/dossiers | 15 | 15060000138287 | 15060000138287 | 1 | PA642847 | PM722954 |
| 15060000138295 | L15/dossiers | 15 | 15060000138294 | 15060000138294 | 1 | PA332747 | PM722798 |
| 15060000138347 | L15/dossiers | 15 | 15060000138346 | 15060000138346 | 1 | PA345619 | PM725692 |
| 15060000138422 | L15/dossiers | 15 | 15060000138421 | 15060000138421 | 1 | PA722374 | PM723556 |
| 15060000138453 | L15/dossiers | 15 | 15060000138452 | 15060000138452 | 1 | PA720746 | PM723064 |
| 15060000138522 | L15/dossiers | 15 | 15060000138521 | 15060000138521 | 1 | PA345722 | PM723428 |
| 15060000138529 | L15/dossiers | 15 | 15060000138528 | 15060000138528 | 1 | PA2792 | PM722870 |
| 15060000138536 | L15/dossiers | 15 | 15060000138535 | 15060000138535 | 1 | PA608016 | PM723024 |
| 15060000138543 | L15/dossiers | 15 | 15060000138542 | 15060000138542 | 1 | PA345619 | PM725692 |
| 15060000138544 | L15/dossiers | 15 | 15060000138542 | 15060000138542 | 2 | PA415482 | PM730088 |
| 15060000138685 | L15/dossiers | 15 | 15060000138684 | 15060000138684 | 1 | PA721418 | PM723268 |
| 15060000138703 | L15/dossiers | 15 | 15060000138702 | 15060000138702 | 1 | PA345619 | PM725692 |
| 15060000138710 | L15/dossiers | 15 | 15060000138709 | 15060000138709 | 1 | PA719464 | PM722670 |
| 15060000138717 | L15/dossiers | 15 | 15060000138716 | 15060000138716 | 1 | PA720846 | PM723094 |
| 15060000138724 | L15/dossiers | 15 | 15060000138723 | 15060000138723 | 1 | PA719946 | PM722808 |
| 15060000138731 | L15/dossiers | 15 | 15060000138730 | 15060000138730 | 1 | PA720100 | PM722860 |
| 15060000138738 | L15/dossiers | 15 | 15060000138737 | 15060000138737 | 1 | PA720468 | PM722972 |
| 15060000138745 | L15/dossiers | 15 | 15060000138744 | 15060000138744 | 1 | PA608416 | PM723540 |
| 15060000138752 | L15/dossiers | 15 | 15060000138751 | 15060000138751 | 1 | PA721486 | PM723290 |
| 15060000138759 | L15/dossiers | 15 | 15060000138758 | 15060000138758 | 1 | PA2792 | PM722870 |
| 15060000138766 | L15/dossiers | 15 | 15060000138765 | 15060000138765 | 1 | PA332228 | PM722754 |
| 15060000138773 | L15/dossiers | 15 | 15060000138772 | 15060000138772 | 1 | PA720854 | PM723096 |
| 15060000138780 | L15/dossiers | 15 | 15060000138779 | 15060000138779 | 1 | PA415459 | PM703660 |
| 15060000138799 | L15/dossiers | 15 | 15060000138798 | 15060000138798 | 1 | PA1206 | PM723354 |
| 15060000138806 | L15/dossiers | 15 | 15060000138805 | 15060000138805 | 1 | PA736167 | PM736327 |
| 15060000138824 | L15/dossiers | 15 | 15060000138823 | 15060000138823 | 1 | PA345619 | PM725692 |
| 15060000138825 | L15/dossiers | 15 | 15060000138823 | 15060000138823 | 2 | PA702191 | PM730058 |
| 15060000138835 | L15/dossiers | 15 | 15060000138834 | 15060000138834 | 1 | PA267766 | PM722970 |