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 |
|---|---|---|---|---|---|---|---|
| 15060000149375 | L15/dossiers | 15 | 15060000149374 | 15060000149374 | 1 | PA345619 | PM725692 |
| 15060000149376 | L15/dossiers | 15 | 15060000149374 | 15060000149374 | 2 | PA335758 | PM759788 |
| 15060000149477 | L15/dossiers | 15 | 15060000149476 | 15060000149476 | 1 | PA718780 | PM722454 |
| 15060000149484 | L15/dossiers | 15 | 15060000149483 | 15060000149483 | 1 | PA721062 | PM723158 |
| 15060000149491 | L15/dossiers | 15 | 15060000149490 | 15060000149490 | 1 | PA719272 | PM722612 |
| 15060000149498 | L15/dossiers | 15 | 15060000149497 | 15060000149497 | 1 | PA719946 | PM722808 |
| 15060000149505 | L15/dossiers | 15 | 15060000149504 | 15060000149504 | 1 | PA721210 | PM723204 |
| 15060000149512 | L15/dossiers | 15 | 15060000149511 | 15060000149511 | 1 | PA345619 | PM725692 |
| 15060000149519 | L15/dossiers | 15 | 15060000149518 | 15060000149518 | 1 | PA267901 | PM723166 |
| 15060000149540 | L15/dossiers | 15 | 15060000149539 | 15060000149539 | 1 | PA609726 | PM723426 |
| 15060000149547 | L15/dossiers | 15 | 15060000149546 | 15060000149546 | 1 | PA606171 | PM722632 |
| 15060000149575 | L15/dossiers | 15 | 15060000149574 | 15060000149574 | 1 | PA345619 | PM725692 |
| 15060000149576 | L15/dossiers | 15 | 15060000149574 | 15060000149574 | 2 | PA717161 | PM730070 |
| 15060000149577 | L15/dossiers | 15 | 15060000149574 | 15060000149574 | 3 | PA332747 | PM758790 |
| 15060000149666 | L15/dossiers | 15 | 15060000149665 | 15060000149665 | 1 | PA720846 | PM723094 |
| 15060000149673 | L15/dossiers | 15 | 15060000149672 | 15060000149672 | 1 | PA330008 | PM722416 |
| 15060000149680 | L15/dossiers | 15 | 15060000149679 | 15060000149679 | 1 | PA1206 | PM723354 |
| 15060000149690 | L15/dossiers | 15 | 15060000149689 | 15060000149689 | 1 | PA330240 | PM722492 |
| 15060000149713 | L15/dossiers | 15 | 15060000149712 | 15060000149712 | 1 | PA2150 | PM722506 |
| 15060000149728 | L15/dossiers | 15 | 15060000149727 | 15060000149727 | 1 | PA345619 | PM725692 |
| 15060000149729 | L15/dossiers | 15 | 15060000149727 | 15060000149727 | 2 | PA717169 | PM730074 |
| 15060000149736 | L15/dossiers | 15 | 15060000149735 | 15060000149735 | 1 | PA337483 | PM723140 |
| 15060000149748 | L15/dossiers | 15 | 15060000149747 | 15060000149747 | 1 | PA2150 | PM722506 |
| 15060000149755 | L15/dossiers | 15 | 15060000149754 | 15060000149754 | 1 | PA718876 | PM722486 |
| 15060000149765 | L15/dossiers | 15 | 15060000149764 | 15060000149764 | 1 | PA345619 | PM725692 |
| 15060000149766 | L15/dossiers | 15 | 15060000149764 | 15060000149764 | 2 | PA607846 | PM730066 |
| 15060000149893 | L15/dossiers | 15 | 15060000149892 | 15060000149892 | 1 | PA267260 | PM722476 |
| 15060000149900 | L15/dossiers | 15 | 15060000149899 | 15060000149899 | 1 | PA346218 | PM723348 |
| 15060000149907 | L15/dossiers | 15 | 15060000149906 | 15060000149906 | 1 | PA720468 | PM722972 |
| 15060000149914 | L15/dossiers | 15 | 15060000149913 | 15060000149913 | 1 | PA721094 | PM723168 |
| 15060000149948 | L15/dossiers | 15 | 15060000149947 | 15060000149947 | 1 | PA340343 | PM722470 |
| 15060000149955 | L15/dossiers | 15 | 15060000149954 | 15060000149954 | 1 | PA721486 | PM723290 |
| 15060000149968 | L15/dossiers | 15 | 15060000149967 | 15060000149967 | 1 | PA721932 | PM734586 |
| 15060000149975 | L15/dossiers | 15 | 15060000149974 | 15060000149974 | 1 | PA722142 | PM723484 |
| 15060000149982 | L15/dossiers | 15 | 15060000149981 | 15060000149981 | 1 | PA334149 | PM723034 |
| 15060000149989 | L15/dossiers | 15 | 15060000149988 | 15060000149988 | 1 | PA340343 | PM722470 |
| 15060000149996 | L15/dossiers | 15 | 15060000149995 | 15060000149995 | 1 | PA608016 | PM723024 |
| 15060000150003 | L15/dossiers | 15 | 15060000150002 | 15060000150002 | 1 | PA303997 | PM703603 |
| 15060000150034 | L15/dossiers | 15 | 15060000150033 | 15060000150033 | 1 | PA267260 | PM722476 |
| 15060000150041 | L15/dossiers | 15 | 15060000150040 | 15060000150040 | 1 | PA304071 | PM703676 |
| 15060000150053 | L15/dossiers | 15 | 15060000150052 | 15060000150052 | 1 | PA205280 | PM736412 |
| 15060000150060 | L15/dossiers | 15 | 15060000150059 | 15060000150059 | 1 | PA736195 | PM736357 |
| 15060000150072 | L15/dossiers | 15 | 15060000150071 | 15060000150071 | 1 | PA717379 | PM723282 |
| 15060000150079 | L15/dossiers | 15 | 15060000150078 | 15060000150078 | 1 | PA267318 | PM723260 |
| 15060000150086 | L15/dossiers | 15 | 15060000150085 | 15060000150085 | 1 | PA266797 | PM722884 |
| 15060000150090 | L15/dossiers | 15 | 15060000150089 | 15060000150089 | 1 | PA736235 | PM736426 |
| 15060000150109 | L15/dossiers | 15 | 15060000150108 | 15060000150108 | 1 | PA703487 | PM703711 |
| 15060000150119 | L15/dossiers | 15 | 15060000150118 | 15060000150118 | 1 | PA345619 | PM725692 |
| 15060000150151 | L15/dossiers | 15 | 15060000150150 | 15060000150150 | 1 | PA721718 | PM723364 |
| 15060000150156 | L15/dossiers | 15 | 15060000150155 | 15060000150155 | 1 | PA722142 | PM723484 |