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 |
|---|---|---|---|---|---|---|---|
| 15060000173371 | L15/dossiers | 15 | 15060000173369 | 15060000173369 | 2 | PA721670 | PM773499 |
| 15060000173378 | L15/dossiers | 15 | 15060000173377 | 15060000173377 | 1 | PA2116 | PM736339 |
| 15060000173385 | L15/dossiers | 15 | 15060000173384 | 15060000173384 | 1 | PA773441 | PM773491 |
| 15060000173392 | L15/dossiers | 15 | 15060000173391 | 15060000173391 | 1 | PA719946 | PM722808 |
| 15060000173399 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 1 | PA343775 | PM736367 |
| 15060000173400 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 2 | PA736198 | PM736406 |
| 15060000173401 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 3 | PA744079 | PM744082 |
| 15060000173402 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 4 | PA775192 | PM775478 |
| 15060000173403 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 5 | PA267907 | PM775751 |
| 15060000173404 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 6 | PA267328 | PM775729 |
| 15060000173405 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 7 | PA775276 | PM775566 |
| 15060000173406 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 8 | PA267075 | PM775610 |
| 15060000173407 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 9 | PA703517 | PM775675 |
| 15060000173408 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 10 | PA343988 | PM736310 |
| 15060000173409 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 11 | PA736216 | PM736273 |
| 15060000173410 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 12 | PA758716 | PM775771 |
| 15060000173411 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 13 | PA736213 | PM775791 |
| 15060000173412 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 14 | PA775184 | PM775486 |
| 15060000173413 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 15 | PA736188 | PM736289 |
| 15060000173414 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 16 | PA736246 | PM775819 |
| 15060000173415 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 17 | PA775202 | PM775502 |
| 15060000173416 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 18 | PA775176 | PM775462 |
| 15060000173417 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 19 | PA715322 | PM775713 |
| 15060000173418 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 20 | PA415467 | PM775803 |
| 15060000173419 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 21 | PA415447 | PM775785 |
| 15060000173420 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 22 | PA775288 | PM775578 |
| 15060000173421 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 23 | PA773891 | PM773895 |
| 15060000173422 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 24 | PA1344 | PM736383 |
| 15060000173423 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 25 | PA345785 | PM736294 |
| 15060000173424 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 26 | PA736239 | PM736317 |
| 15060000173425 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 27 | PA736194 | PM736291 |
| 15060000173426 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 28 | PA703539 | PM703693 |
| 15060000173427 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 29 | PA267081 | PM775733 |
| 15060000173428 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 30 | PA703522 | PM775701 |
| 15060000173429 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 31 | PA775216 | PM775522 |
| 15060000173430 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 32 | PA1993 | PM736402 |
| 15060000173431 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 33 | PA775222 | PM775524 |
| 15060000173432 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 34 | PA703537 | PM775721 |
| 15060000173433 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 35 | PA736172 | PM736415 |
| 15060000173434 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 36 | PA429851 | PM736305 |
| 15060000173435 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 37 | PA703500 | PM775643 |
| 15060000173436 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 38 | PA711156 | PM736319 |
| 15060000173437 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 39 | PA736192 | PM736353 |
| 15060000173438 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 40 | PA775228 | PM775516 |
| 15060000173439 | L15/dossiers | 15 | 15060000173398 | 15060000173398 | 41 | PA425322 | PM736282 |
| 15060000173446 | L15/dossiers | 15 | 15060000173445 | 15060000173445 | 1 | PA719194 | PM722590 |
| 15060000173456 | L15/dossiers | 15 | 15060000173455 | 15060000173455 | 1 | PA703539 | PM703693 |
| 15060000173457 | L15/dossiers | 15 | 15060000173455 | 15060000173455 | 2 | PA415454 | PM703689 |
| 15060000173458 | L15/dossiers | 15 | 15060000173455 | 15060000173455 | 3 | PA429860 | PM736398 |
| 15060000173465 | L15/dossiers | 15 | 15060000173464 | 15060000173464 | 1 | PA719608 | PM722710 |