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 |
|---|---|---|---|---|---|---|---|
| 16060000114306 | L16/dossiers | 16 | 16060000114305 | 16060000114305 | 1 | PA794138 | PM796734 |
| 16060000114313 | L16/dossiers | 16 | 16060000114312 | 16060000114312 | 1 | PA608016 | PM797100 |
| 16060000114320 | L16/dossiers | 16 | 16060000114319 | 16060000114319 | 1 | PA794570 | PM796998 |
| 16060000114327 | L16/dossiers | 16 | 16060000114326 | 16060000114326 | 1 | PA794906 | PM797187 |
| 16060000114334 | L16/dossiers | 16 | 16060000114333 | 16060000114333 | 1 | PA795552 | PM797547 |
| 16060000114341 | L16/dossiers | 16 | 16060000114340 | 16060000114340 | 1 | PA720342 | PM796887 |
| 16060000114393 | L16/dossiers | 16 | 16060000114392 | 16060000114392 | 1 | PA774954 | PM796797 |
| 16060000114400 | L16/dossiers | 16 | 16060000114399 | 16060000114399 | 1 | PA720892 | PM797520 |
| 16060000114407 | L16/dossiers | 16 | 16060000114406 | 16060000114406 | 1 | PA722046 | PM797625 |
| 16060000114414 | L16/dossiers | 16 | 16060000114413 | 16060000114413 | 1 | PA267766 | PM796980 |
| 16060000114421 | L16/dossiers | 16 | 16060000114420 | 16060000114420 | 1 | PA794322 | PM796851 |
| 16060000114428 | L16/dossiers | 16 | 16060000114427 | 16060000114427 | 1 | PA722110 | PM797853 |
| 16060000114435 | L16/dossiers | 16 | 16060000114434 | 16060000114434 | 1 | PA794214 | PM796782 |
| 16060000114490 | L16/dossiers | 16 | 16060000114489 | 16060000114489 | 1 | PA720892 | PM797520 |
| 16060000114497 | L16/dossiers | 16 | 16060000114496 | 16060000114496 | 1 | PA643089 | PM797439 |
| 16060000114504 | L16/dossiers | 16 | 16060000114503 | 16060000114503 | 1 | PA794354 | PM796869 |
| 16060000114511 | L16/dossiers | 16 | 16060000114510 | 16060000114510 | 1 | PA795616 | PM797589 |
| 16060000114515 | L16/dossiers | 16 | 16060000114514 | 16060000114514 | 1 | PA720468 | PM796983 |
| 16060000114522 | L16/dossiers | 16 | 16060000114521 | 16060000114521 | 1 | PA794854 | PM797163 |
| 16060000114529 | L16/dossiers | 16 | 16060000114528 | 16060000114528 | 1 | PA712015 | PM796176 |
| 16060000114536 | L16/dossiers | 16 | 16060000114535 | 16060000114535 | 1 | PA793452 | PM796332 |
| 16060000114543 | L16/dossiers | 16 | 16060000114542 | 16060000114542 | 1 | PA643134 | PM796758 |
| 16060000114550 | L16/dossiers | 16 | 16060000114549 | 16060000114549 | 1 | PA795820 | PM797700 |
| 16060000114557 | L16/dossiers | 16 | 16060000114556 | 16060000114556 | 1 | PA794778 | PM797115 |
| 16060000114564 | L16/dossiers | 16 | 16060000114563 | 16060000114563 | 1 | PA794178 | PM796755 |
| 16060000114571 | L16/dossiers | 16 | 16060000114570 | 16060000114570 | 1 | PA774958 | PM797355 |
| 16060000114578 | L16/dossiers | 16 | 16060000114577 | 16060000114577 | 1 | PA643134 | PM796758 |
| 16060000114585 | L16/dossiers | 16 | 16060000114584 | 16060000114584 | 1 | PA795762 | PM797670 |
| 16060000114592 | L16/dossiers | 16 | 16060000114591 | 16060000114591 | 1 | PA267766 | PM796980 |
| 16060000114605 | L16/dossiers | 16 | 16060000114604 | 16060000114604 | 1 | PA643089 | PM797439 |
| 16060000114612 | L16/dossiers | 16 | 16060000114611 | 16060000114611 | 1 | PA720334 | PM796884 |
| 16060000114619 | L16/dossiers | 16 | 16060000114618 | 16060000114618 | 1 | PA721976 | PM797622 |
| 16060000114626 | L16/dossiers | 16 | 16060000114625 | 16060000114625 | 1 | PA266788 | PM796788 |
| 16060000114639 | L16/dossiers | 16 | 16060000114638 | 16060000114638 | 1 | PA333421 | PM796881 |
| 16060000114649 | L16/dossiers | 16 | 16060000114648 | 16060000114648 | 1 | PA794718 | PM797079 |
| 16060000114659 | L16/dossiers | 16 | 16060000114658 | 16060000114658 | 1 | PA266788 | PM796788 |
| 16060000114663 | L16/dossiers | 16 | 16060000114662 | 16060000114662 | 1 | PA266788 | PM796788 |
| 16060000114667 | L16/dossiers | 16 | 16060000114666 | 16060000114666 | 1 | PA266788 | PM796788 |
| 16060000114671 | L16/dossiers | 16 | 16060000114670 | 16060000114670 | 1 | PA643089 | PM797439 |
| 16060000114678 | L16/dossiers | 16 | 16060000114677 | 16060000114677 | 1 | PA736214 | PM736290 |
| 16060000114679 | L16/dossiers | 16 | 16060000114677 | 16060000114677 | 2 | PA330684 | PM775859 |
| 16060000114694 | L16/dossiers | 16 | 16060000114693 | 16060000114693 | 1 | PA1327 | PM796632 |
| 16060000114701 | L16/dossiers | 16 | 16060000114700 | 16060000114700 | 1 | PA720468 | PM796983 |
| 16060000114708 | L16/dossiers | 16 | 16060000114707 | 16060000114707 | 1 | PA267324 | PM797538 |
| 16060000114715 | L16/dossiers | 16 | 16060000114714 | 16060000114714 | 1 | PA793780 | PM796527 |
| 16060000114722 | L16/dossiers | 16 | 16060000114721 | 16060000114721 | 1 | PA794502 | PM796962 |
| 16060000114729 | L16/dossiers | 16 | 16060000114728 | 16060000114728 | 1 | PA793122 | PM796161 |
| 16060000114737 | L16/dossiers | 16 | 16060000114736 | 16060000114736 | 1 | PA721262 | PM797550 |
| 16060000114744 | L16/dossiers | 16 | 16060000114743 | 16060000114743 | 1 | PA721880 | PM797640 |
| 16060000114751 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 1 | PA775224 | PM775512 |