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 |
|---|---|---|---|---|---|---|---|
| 15060000154200 | L15/dossiers | 15 | 15060000154199 | 15060000154199 | 1 | PA609520 | PM723508 |
| 15060000154210 | L15/dossiers | 15 | 15060000154209 | 15060000154209 | 1 | PA719890 | PM722790 |
| 15060000154217 | L15/dossiers | 15 | 15060000154216 | 15060000154216 | 1 | PA643089 | PM758076 |
| 15060000154224 | L15/dossiers | 15 | 15060000154223 | 15060000154223 | 1 | PA267450 | PM722586 |
| 15060000154231 | L15/dossiers | 15 | 15060000154230 | 15060000154230 | 1 | PA713448 | PM722452 |
| 15060000154238 | L15/dossiers | 15 | 15060000154237 | 15060000154237 | 1 | PA267328 | PM703547 |
| 15060000154257 | L15/dossiers | 15 | 15060000154256 | 15060000154256 | 1 | PA267330 | PM723392 |
| 15060000154261 | L15/dossiers | 15 | 15060000154260 | 15060000154260 | 1 | PA267018 | PM703564 |
| 15060000154268 | L15/dossiers | 15 | 15060000154267 | 15060000154267 | 1 | PA718784 | PM722456 |
| 15060000154275 | L15/dossiers | 15 | 15060000154274 | 15060000154274 | 1 | PA267018 | PM703564 |
| 15060000154282 | L15/dossiers | 15 | 15060000154281 | 15060000154281 | 1 | PA330240 | PM722492 |
| 15060000154299 | L15/dossiers | 15 | 15060000154298 | 15060000154298 | 1 | PA720370 | PM722944 |
| 15060000154300 | L15/dossiers | 15 | 15060000154298 | 15060000154298 | 2 | PA335054 | PM723254 |
| 15060000154316 | L15/dossiers | 15 | 15060000154315 | 15060000154315 | 1 | PA721474 | PM723286 |
| 15060000154323 | L15/dossiers | 15 | 15060000154322 | 15060000154322 | 1 | PA330240 | PM722492 |
| 15060000154330 | L15/dossiers | 15 | 15060000154329 | 15060000154329 | 1 | PA2116 | PM736339 |
| 15060000154331 | L15/dossiers | 15 | 15060000154329 | 15060000154329 | 2 | PA736236 | PM736341 |
| 15060000154332 | L15/dossiers | 15 | 15060000154329 | 15060000154329 | 3 | PA736203 | PM736432 |
| 15060000154339 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 1 | PA343775 | PM736367 |
| 15060000154340 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 2 | PA331381 | PM703620 |
| 15060000154341 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 3 | PA736160 | PM736359 |
| 15060000154342 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 4 | PA736211 | PM736410 |
| 15060000154343 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 5 | PA1001 | PM736371 |
| 15060000154344 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 6 | PA426327 | PM703630 |
| 15060000154345 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 7 | PA736188 | PM736289 |
| 15060000154346 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 8 | PA267112 | PM703608 |
| 15060000154347 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 9 | PA415479 | PM703586 |
| 15060000154348 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 10 | PA703532 | PM703568 |
| 15060000154349 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 11 | PA736216 | PM736273 |
| 15060000154350 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 12 | PA304085 | PM736343 |
| 15060000154351 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 13 | PA703539 | PM703693 |
| 15060000154352 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 14 | PA703483 | PM703613 |
| 15060000154353 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 15 | PA736192 | PM736353 |
| 15060000154354 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 16 | PA429851 | PM736305 |
| 15060000154355 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 17 | PA736213 | PM736431 |
| 15060000154356 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 18 | PA429887 | PM736274 |
| 15060000154357 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 19 | PA343988 | PM736310 |
| 15060000154358 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 20 | PA703521 | PM703544 |
| 15060000154359 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 21 | PA736223 | PM736368 |
| 15060000154360 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 22 | PA736202 | PM736392 |
| 15060000154361 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 23 | PA404656 | PM736328 |
| 15060000154362 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 24 | PA703515 | PM703592 |
| 15060000154363 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 25 | PA703500 | PM703574 |
| 15060000154364 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 26 | PA736227 | PM736308 |
| 15060000154365 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 27 | PA736246 | PM736428 |
| 15060000154366 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 28 | PA703494 | PM703602 |
| 15060000154367 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 29 | PA1993 | PM736402 |
| 15060000154368 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 30 | PA703537 | PM703595 |
| 15060000154369 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 31 | PA1122 | PM736304 |
| 15060000154370 | L15/dossiers | 15 | 15060000154338 | 15060000154338 | 32 | PA205280 | PM736412 |