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 |
|---|---|---|---|---|---|---|---|
| 15060000186340 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 70 | PA429852 | PM736275 |
| 15060000186347 | L15/dossiers | 15 | 15060000186346 | 15060000186346 | 1 | PA719632 | PM722716 |
| 15060000186354 | L15/dossiers | 15 | 15060000186353 | 15060000186353 | 1 | PA718744 | PM722442 |
| 15060000186361 | L15/dossiers | 15 | 15060000186360 | 15060000186360 | 1 | PA721054 | PM723156 |
| 15060000186368 | L15/dossiers | 15 | 15060000186367 | 15060000186367 | 1 | PA721486 | PM723290 |
| 15060000186375 | L15/dossiers | 15 | 15060000186374 | 15060000186374 | 1 | PA718894 | PM722494 |
| 15060000186382 | L15/dossiers | 15 | 15060000186381 | 15060000186381 | 1 | PA720278 | PM722916 |
| 15060000186389 | L15/dossiers | 15 | 15060000186388 | 15060000186388 | 1 | PA720960 | PM723124 |
| 15060000186396 | L15/dossiers | 15 | 15060000186395 | 15060000186395 | 1 | PA775284 | PM775590 |
| 15060000186403 | L15/dossiers | 15 | 15060000186402 | 15060000186402 | 1 | PA773441 | PM773491 |
| 15060000186410 | L15/dossiers | 15 | 15060000186409 | 15060000186409 | 1 | PA773441 | PM773491 |
| 15060000186420 | L15/dossiers | 15 | 15060000186419 | 15060000186419 | 1 | PA720046 | PM722842 |
| 15060000186427 | L15/dossiers | 15 | 15060000186426 | 15060000186426 | 1 | PA608416 | PM723540 |
| 15060000186434 | L15/dossiers | 15 | 15060000186433 | 15060000186433 | 1 | PA721486 | PM723290 |
| 15060000186441 | L15/dossiers | 15 | 15060000186440 | 15060000186440 | 1 | PA722030 | PM723454 |
| 15060000186448 | L15/dossiers | 15 | 15060000186447 | 15060000186447 | 1 | PA719952 | PM722814 |
| 15060000186455 | L15/dossiers | 15 | 15060000186454 | 15060000186454 | 1 | PA720802 | PM774333 |
| 15060000186462 | L15/dossiers | 15 | 15060000186461 | 15060000186461 | 1 | PA721486 | PM723290 |
| 15060000186469 | L15/dossiers | 15 | 15060000186468 | 15060000186468 | 1 | PA783457 | PM783488 |
| 15060000186479 | L15/dossiers | 15 | 15060000186478 | 15060000186478 | 1 | PA718930 | PM722504 |
| 15060000186486 | L15/dossiers | 15 | 15060000186485 | 15060000186485 | 1 | PA2952 | PM722480 |
| 15060000186493 | L15/dossiers | 15 | 15060000186492 | 15060000186492 | 1 | PA719318 | PM722624 |
| 15060000186500 | L15/dossiers | 15 | 15060000186499 | 15060000186499 | 1 | PA719570 | PM722700 |
| 15060000186507 | L15/dossiers | 15 | 15060000186506 | 15060000186506 | 1 | PA267766 | PM722970 |
| 15060000186514 | L15/dossiers | 15 | 15060000186513 | 15060000186513 | 1 | PA719778 | PM722760 |
| 15060000186521 | L15/dossiers | 15 | 15060000186520 | 15060000186520 | 1 | PA720468 | PM722972 |
| 15060000186528 | L15/dossiers | 15 | 15060000186527 | 15060000186527 | 1 | PA2150 | PM722506 |
| 15060000186532 | L15/dossiers | 15 | 15060000186531 | 15060000186531 | 1 | PA773441 | PM773491 |
| 15060000186540 | L15/dossiers | 15 | 15060000186539 | 15060000186539 | 1 | PA721678 | PM723352 |
| 15060000186547 | L15/dossiers | 15 | 15060000186546 | 15060000186546 | 1 | PA720468 | PM722972 |
| 15060000186554 | L15/dossiers | 15 | 15060000186553 | 15060000186553 | 1 | PA2377 | PM723550 |
| 15060000186576 | L15/dossiers | 15 | 15060000186575 | 15060000186575 | 1 | PA719980 | PM722822 |
| 15060000186583 | L15/dossiers | 15 | 15060000186582 | 15060000186582 | 1 | PA718784 | PM722456 |
| 15060000186590 | L15/dossiers | 15 | 15060000186589 | 15060000186589 | 1 | PA1874 | PM722598 |
| 15060000186597 | L15/dossiers | 15 | 15060000186596 | 15060000186596 | 1 | PA266788 | PM722914 |
| 15060000186604 | L15/dossiers | 15 | 15060000186603 | 15060000186603 | 1 | PA720074 | PM722850 |
| 15060000186617 | L15/dossiers | 15 | 15060000186616 | 15060000186616 | 1 | PA227029 | PM736306 |
| 15060000186624 | L15/dossiers | 15 | 15060000186623 | 15060000186623 | 1 | PA2116 | PM736339 |
| 15060000186631 | L15/dossiers | 15 | 15060000186630 | 15060000186630 | 1 | PA774962 | PM774987 |
| 15060000186641 | L15/dossiers | 15 | 15060000186640 | 15060000186640 | 1 | PA720692 | PM723042 |
| 15060000186648 | L15/dossiers | 15 | 15060000186647 | 15060000186647 | 1 | PA720928 | PM774485 |
| 15060000186652 | L15/dossiers | 15 | 15060000186651 | 15060000186651 | 1 | PA720298 | PM722922 |
| 15060000186659 | L15/dossiers | 15 | 15060000186658 | 15060000186658 | 1 | PA720468 | PM722972 |
| 15060000186666 | L15/dossiers | 15 | 15060000186665 | 15060000186665 | 1 | PA719186 | PM722588 |
| 15060000186682 | L15/dossiers | 15 | 15060000186681 | 15060000186681 | 1 | PA721142 | PM723186 |
| 15060000186689 | L15/dossiers | 15 | 15060000186688 | 15060000186688 | 1 | PA721458 | PM723280 |
| 15060000186696 | L15/dossiers | 15 | 15060000186695 | 15060000186695 | 1 | PA774956 | PM774979 |
| 15060000186703 | L15/dossiers | 15 | 15060000186702 | 15060000186702 | 1 | PA606098 | PM722642 |
| 15060000186710 | L15/dossiers | 15 | 15060000186709 | 15060000186709 | 1 | PA721174 | PM723194 |
| 15060000186717 | L15/dossiers | 15 | 15060000186716 | 15060000186716 | 1 | PA721174 | PM723194 |