dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 16060000104371 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 2 | PA775180 | PM775466 |
| 16060000104372 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 3 | PA801838 | PM801842 |
| 16060000104373 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 4 | PA429845 | PM736278 |
| 16060000104374 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 5 | PA775252 | PM775558 |
| 16060000104375 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 6 | PA775214 | PM775498 |
| 16060000104376 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 7 | PA775224 | PM775512 |
| 16060000104377 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 8 | PA736177 | PM736318 |
| 16060000104378 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 9 | PA429866 | PM736287 |
| 16060000104379 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 10 | PA775262 | PM775548 |
| 16060000104380 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 11 | PA775282 | PM775584 |
| 16060000104381 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 12 | PA785857 | PM785867 |
| 16060000104388 | L16/dossiers | 16 | 16060000104387 | 16060000104387 | 1 | PA719608 | PM796593 |
| 16060000104395 | L16/dossiers | 16 | 16060000104394 | 16060000104394 | 1 | PA421348 | PM797544 |
| 16060000104396 | L16/dossiers | 16 | 16060000104394 | 16060000104394 | 2 | PA267429 | PM796722 |
| 16060000104404 | L16/dossiers | 16 | 16060000104403 | 16060000104403 | 1 | PA720014 | PM796863 |
| 16060000104411 | L16/dossiers | 16 | 16060000104410 | 16060000104410 | 1 | PA719608 | PM796593 |
| 16060000104418 | L16/dossiers | 16 | 16060000104417 | 16060000104417 | 1 | PA720696 | PM796989 |
| 16060000104425 | L16/dossiers | 16 | 16060000104424 | 16060000104424 | 1 | PA795084 | PM797292 |
| 16060000104432 | L16/dossiers | 16 | 16060000104431 | 16060000104431 | 1 | PA720038 | PM796746 |
| 16060000104483 | L16/dossiers | 16 | 16060000104482 | 16060000104482 | 1 | PA793992 | PM796641 |
| 16060000104490 | L16/dossiers | 16 | 16060000104489 | 16060000104489 | 1 | PA721166 | PM785865 |
| 16060000104497 | L16/dossiers | 16 | 16060000104496 | 16060000104496 | 1 | PA609332 | PM797532 |
| 16060000104504 | L16/dossiers | 16 | 16060000104503 | 16060000104503 | 1 | PA720838 | PM797865 |
| 16060000104508 | L16/dossiers | 16 | 16060000104507 | 16060000104507 | 1 | PA775268 | PM775574 |
| 16060000104538 | L16/dossiers | 16 | 16060000104537 | 16060000104537 | 1 | PA340643 | PM796335 |
| 16060000104545 | L16/dossiers | 16 | 16060000104544 | 16060000104544 | 1 | PA340643 | PM796335 |
| 16060000104552 | L16/dossiers | 16 | 16060000104551 | 16060000104551 | 1 | PA340643 | PM796335 |
| 16060000104559 | L16/dossiers | 16 | 16060000104558 | 16060000104558 | 1 | PA793736 | PM796503 |
| 16060000104566 | L16/dossiers | 16 | 16060000104565 | 16060000104565 | 1 | PA643089 | PM797439 |
| 16060000104573 | L16/dossiers | 16 | 16060000104572 | 16060000104572 | 1 | PA719798 | PM796638 |
| 16060000104596 | L16/dossiers | 16 | 16060000104595 | 16060000104595 | 1 | PA794022 | PM796662 |
| 16060000104603 | L16/dossiers | 16 | 16060000104602 | 16060000104602 | 1 | PA719382 | PM796452 |
| 16060000104616 | L16/dossiers | 16 | 16060000104615 | 16060000104615 | 1 | PA605782 | PM796350 |
| 16060000104667 | L16/dossiers | 16 | 16060000104666 | 16060000104666 | 1 | PA720908 | PM797556 |
| 16060000104683 | L16/dossiers | 16 | 16060000104682 | 16060000104682 | 1 | PA642868 | PM796968 |
| 16060000104737 | L16/dossiers | 16 | 16060000104736 | 16060000104736 | 1 | PA722252 | PM797610 |
| 16060000104744 | L16/dossiers | 16 | 16060000104743 | 16060000104743 | 1 | PA721584 | PM797712 |
| 16060000104751 | L16/dossiers | 16 | 16060000104750 | 16060000104750 | 1 | PA333285 | PM796926 |
| 16060000104758 | L16/dossiers | 16 | 16060000104757 | 16060000104757 | 1 | PA795616 | PM797589 |
| 16060000104765 | L16/dossiers | 16 | 16060000104764 | 16060000104764 | 1 | PA795974 | PM797784 |
| 16060000104772 | L16/dossiers | 16 | 16060000104771 | 16060000104771 | 1 | PA793476 | PM796344 |
| 16060000104779 | L16/dossiers | 16 | 16060000104778 | 16060000104778 | 1 | PA795310 | PM797415 |
| 16060000104789 | L16/dossiers | 16 | 16060000104788 | 16060000104788 | 1 | PA720074 | PM796845 |
| 16060000104814 | L16/dossiers | 16 | 16060000104813 | 16060000104813 | 1 | PA720754 | PM797121 |
| 16060000104815 | L16/dossiers | 16 | 16060000104813 | 16060000104813 | 2 | PA722046 | PM797625 |
| 16060000104816 | L16/dossiers | 16 | 16060000104813 | 16060000104813 | 3 | PA719600 | PM796629 |
| 16060000104894 | L16/dossiers | 16 | 16060000104893 | 16060000104893 | 1 | PA757225 | PM797382 |
| 16060000104904 | L16/dossiers | 16 | 16060000104903 | 16060000104903 | 1 | PA794198 | PM796776 |
| 16060000104920 | L16/dossiers | 16 | 16060000104919 | 16060000104919 | 1 | PA717161 | PM791583 |
| 16060000104921 | L16/dossiers | 16 | 16060000104919 | 16060000104919 | 2 | PA330357 | PM791696 |