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 |
|---|---|---|---|---|---|---|---|
| 15060000178984 | L15/dossiers | 15 | 15060000178983 | 15060000178983 | 1 | PA773441 | PM773491 |
| 15060000178985 | L15/dossiers | 15 | 15060000178983 | 15060000178983 | 2 | PA1872 | PM773455 |
| 15060000179016 | L15/dossiers | 15 | 15060000179015 | 15060000179015 | 1 | PA774960 | PM774985 |
| 15060000179023 | L15/dossiers | 15 | 15060000179022 | 15060000179022 | 1 | PA709315 | PM722526 |
| 15060000179030 | L15/dossiers | 15 | 15060000179029 | 15060000179029 | 1 | PA429895 | PM736262 |
| 15060000179049 | L15/dossiers | 15 | 15060000179048 | 15060000179048 | 1 | PA721194 | PM723200 |
| 15060000179053 | L15/dossiers | 15 | 15060000179052 | 15060000179052 | 1 | PA719558 | PM722696 |
| 15060000179060 | L15/dossiers | 15 | 15060000179059 | 15060000179059 | 1 | PA719558 | PM722696 |
| 15060000179067 | L15/dossiers | 15 | 15060000179066 | 15060000179066 | 1 | PA332747 | PM766920 |
| 15060000179076 | L15/dossiers | 15 | 15060000179075 | 15060000179075 | 1 | PA721678 | PM723352 |
| 15060000179083 | L15/dossiers | 15 | 15060000179082 | 15060000179082 | 1 | PA719558 | PM722696 |
| 15060000179090 | L15/dossiers | 15 | 15060000179089 | 15060000179089 | 1 | PA721932 | PM734586 |
| 15060000179097 | L15/dossiers | 15 | 15060000179096 | 15060000179096 | 1 | PA2150 | PM722506 |
| 15060000179110 | L15/dossiers | 15 | 15060000179109 | 15060000179109 | 1 | PA721450 | PM723278 |
| 15060000179126 | L15/dossiers | 15 | 15060000179125 | 15060000179125 | 1 | PA721666 | PM774327 |
| 15060000179133 | L15/dossiers | 15 | 15060000179132 | 15060000179132 | 1 | PA773441 | PM773491 |
| 15060000179147 | L15/dossiers | 15 | 15060000179146 | 15060000179146 | 1 | PA722102 | PM723472 |
| 15060000179154 | L15/dossiers | 15 | 15060000179153 | 15060000179153 | 1 | PA718884 | PM722488 |
| 15060000179161 | L15/dossiers | 15 | 15060000179160 | 15060000179160 | 1 | PA721666 | PM774327 |
| 15060000179168 | L15/dossiers | 15 | 15060000179167 | 15060000179167 | 1 | PA721968 | PM723436 |
| 15060000179175 | L15/dossiers | 15 | 15060000179174 | 15060000179174 | 1 | PA605036 | PM722444 |
| 15060000179186 | L15/dossiers | 15 | 15060000179185 | 15060000179185 | 1 | PA721968 | PM723436 |
| 15060000179193 | L15/dossiers | 15 | 15060000179192 | 15060000179192 | 1 | PA720568 | PM723002 |
| 15060000179200 | L15/dossiers | 15 | 15060000179199 | 15060000179199 | 1 | PA736178 | PM736296 |
| 15060000179207 | L15/dossiers | 15 | 15060000179206 | 15060000179206 | 1 | PA718784 | PM722456 |
| 15060000179214 | L15/dossiers | 15 | 15060000179213 | 15060000179213 | 1 | PA609590 | PM723326 |
| 15060000179224 | L15/dossiers | 15 | 15060000179223 | 15060000179223 | 1 | PA720916 | PM723112 |
| 15060000179231 | L15/dossiers | 15 | 15060000179230 | 15060000179230 | 1 | PA718744 | PM722442 |
| 15060000179238 | L15/dossiers | 15 | 15060000179237 | 15060000179237 | 1 | PA736167 | PM736327 |
| 15060000179245 | L15/dossiers | 15 | 15060000179244 | 15060000179244 | 1 | PA709315 | PM722526 |
| 15060000179252 | L15/dossiers | 15 | 15060000179251 | 15060000179251 | 1 | PA267260 | PM722476 |
| 15060000179262 | L15/dossiers | 15 | 15060000179261 | 15060000179261 | 1 | PA266788 | PM722914 |
| 15060000179269 | L15/dossiers | 15 | 15060000179268 | 15060000179268 | 1 | PA721932 | PM734586 |
| 15060000179276 | L15/dossiers | 15 | 15060000179275 | 15060000179275 | 1 | PA720586 | PM723008 |
| 15060000179283 | L15/dossiers | 15 | 15060000179282 | 15060000179282 | 1 | PA720586 | PM723008 |
| 15060000179290 | L15/dossiers | 15 | 15060000179289 | 15060000179289 | 1 | PA773441 | PM773491 |
| 15060000179291 | L15/dossiers | 15 | 15060000179289 | 15060000179289 | 2 | PA337633 | PM773479 |
| 15060000179298 | L15/dossiers | 15 | 15060000179297 | 15060000179297 | 1 | PA267440 | PM722522 |
| 15060000179305 | L15/dossiers | 15 | 15060000179304 | 15060000179304 | 1 | PA721474 | PM723286 |
| 15060000179309 | L15/dossiers | 15 | 15060000179308 | 15060000179308 | 1 | PA266788 | PM722914 |
| 15060000179313 | L15/dossiers | 15 | 15060000179312 | 15060000179312 | 1 | PA266788 | PM722914 |
| 15060000179320 | L15/dossiers | 15 | 15060000179319 | 15060000179319 | 1 | PA719456 | PM722668 |
| 15060000179324 | L15/dossiers | 15 | 15060000179323 | 15060000179323 | 1 | PA721474 | PM723286 |
| 15060000179334 | L15/dossiers | 15 | 15060000179333 | 15060000179333 | 1 | PA719364 | PM722638 |
| 15060000179341 | L15/dossiers | 15 | 15060000179340 | 15060000179340 | 1 | PA773441 | PM773491 |
| 15060000179342 | L15/dossiers | 15 | 15060000179340 | 15060000179340 | 2 | PA331481 | PM773459 |
| 15060000179343 | L15/dossiers | 15 | 15060000179340 | 15060000179340 | 3 | PA330357 | PM773447 |
| 15060000180034 | L15/dossiers | 15 | 15060000180033 | 15060000180033 | 1 | PA720386 | PM722948 |
| 15060000180041 | L15/dossiers | 15 | 15060000180040 | 15060000180040 | 1 | PA703534 | PM775695 |
| 15060000180072 | L15/dossiers | 15 | 15060000180071 | 15060000180071 | 1 | PA718894 | PM722494 |