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 |
|---|---|---|---|---|---|---|---|
| 15060000157348 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 8 | PA905 | PM703566 |
| 15060000157349 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 9 | PA268007 | PM736325 |
| 15060000157350 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 10 | PA429845 | PM736278 |
| 15060000157351 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 11 | PA736235 | PM736426 |
| 15060000157352 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 12 | PA703487 | PM703711 |
| 15060000157353 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 13 | PA736228 | PM736380 |
| 15060000157354 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 14 | PA1573 | PM703652 |
| 15060000157355 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 15 | PA736168 | PM736301 |
| 15060000157356 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 16 | PA703529 | PM703650 |
| 15060000157357 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 17 | PA429866 | PM736287 |
| 15060000157358 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 18 | PA415464 | PM703627 |
| 15060000157359 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 19 | PA736242 | PM736349 |
| 15060000157360 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 20 | PA736224 | PM736403 |
| 15060000157361 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 21 | PA415480 | PM709303 |
| 15060000157374 | L15/dossiers | 15 | 15060000157373 | 15060000157373 | 1 | PA429858 | PM736268 |
| 15060000157375 | L15/dossiers | 15 | 15060000157373 | 15060000157373 | 2 | PA304085 | PM736343 |
| 15060000157376 | L15/dossiers | 15 | 15060000157373 | 15060000157373 | 3 | PA303997 | PM703603 |
| 15060000157383 | L15/dossiers | 15 | 15060000157382 | 15060000157382 | 1 | PA1183 | PM706347 |
| 15060000157390 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 1 | PA205280 | PM736412 |
| 15060000157391 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 2 | PA736192 | PM736353 |
| 15060000157392 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 3 | PA703510 | PM703672 |
| 15060000157393 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 4 | PA703518 | PM703704 |
| 15060000157394 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 5 | PA736238 | PM736352 |
| 15060000157395 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 6 | PA2447 | PM703679 |
| 15060000157396 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 7 | PA304085 | PM736343 |
| 15060000157397 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 8 | PA1562 | PM736340 |
| 15060000157398 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 9 | PA267081 | PM703617 |
| 15060000157399 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 10 | PA715322 | PM715327 |
| 15060000157400 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 11 | PA736211 | PM736410 |
| 15060000157401 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 12 | PA703488 | PM703632 |
| 15060000157402 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 13 | PA304108 | PM736399 |
| 15060000157403 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 14 | PA708632 | PM708643 |
| 15060000157404 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 15 | PA415489 | PM703714 |
| 15060000157405 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 16 | PA304086 | PM736348 |
| 15060000157406 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 17 | PA736172 | PM736415 |
| 15060000157407 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 18 | PA528 | PM736270 |
| 15060000157408 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 19 | PA415456 | PM736433 |
| 15060000157409 | L15/dossiers | 15 | 15060000157389 | 15060000157389 | 20 | PA736216 | PM736273 |
| 15060000157416 | L15/dossiers | 15 | 15060000157415 | 15060000157415 | 1 | PA720634 | PM736312 |
| 15060000157423 | L15/dossiers | 15 | 15060000157422 | 15060000157422 | 1 | PA736211 | PM736410 |
| 15060000157430 | L15/dossiers | 15 | 15060000157429 | 15060000157429 | 1 | PA429840 | PM736360 |
| 15060000157437 | L15/dossiers | 15 | 15060000157436 | 15060000157436 | 1 | PA343775 | PM736367 |
| 15060000157444 | L15/dossiers | 15 | 15060000157443 | 15060000157443 | 1 | PA736244 | PM736333 |
| 15060000157451 | L15/dossiers | 15 | 15060000157450 | 15060000157450 | 1 | PA703518 | PM703704 |
| 15060000157452 | L15/dossiers | 15 | 15060000157450 | 15060000157450 | 2 | PA304000 | PM703599 |
| 15060000157459 | L15/dossiers | 15 | 15060000157458 | 15060000157458 | 1 | PA703513 | PM703621 |
| 15060000157466 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 1 | PA429869 | PM736350 |
| 15060000157467 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 2 | PA429832 | PM736408 |
| 15060000157468 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 3 | PA736206 | PM736351 |
| 15060000157469 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 4 | PA703516 | PM703559 |