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 |
|---|---|---|---|---|---|---|---|
| 17060000124474 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 70 | PA795164 | PM840444 |
| 17060000124475 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 71 | PA795596 | PM840456 |
| 17060000124482 | L17/dossiers | 17 | 17060000124481 | 17060000124481 | 1 | PA415488 | PM775641 |
| 17060000124489 | L17/dossiers | 17 | 17060000124488 | 17060000124488 | 1 | PA415447 | PM775785 |
| 17060000124496 | L17/dossiers | 17 | 17060000124495 | 17060000124495 | 1 | PA827942 | PM828628 |
| 17060000124503 | L17/dossiers | 17 | 17060000124502 | 17060000124502 | 1 | PA341381 | PM775747 |
| 17060000124523 | L17/dossiers | 17 | 17060000124522 | 17060000124522 | 1 | PA382672 | PM829681 |
| 17060000124530 | L17/dossiers | 17 | 17060000124529 | 17060000124529 | 1 | PA415447 | PM775785 |
| 17060000124537 | L17/dossiers | 17 | 17060000124536 | 17060000124536 | 1 | PA795746 | PM843584 |
| 17060000124549 | L17/dossiers | 17 | 17060000124548 | 17060000124548 | 1 | PA330240 | PM842357 |
| 17060000124556 | L17/dossiers | 17 | 17060000124555 | 17060000124555 | 1 | PA775284 | PM775590 |
| 17060000124563 | L17/dossiers | 17 | 17060000124562 | 17060000124562 | 1 | PA841067 | PM842687 |
| 17060000124570 | L17/dossiers | 17 | 17060000124569 | 17060000124569 | 1 | PA795864 | PM840429 |
| 17060000124577 | L17/dossiers | 17 | 17060000124576 | 17060000124576 | 1 | PA795966 | PM843530 |
| 17060000124584 | L17/dossiers | 17 | 17060000124583 | 17060000124583 | 1 | PA794702 | PM843248 |
| 17060000124591 | L17/dossiers | 17 | 17060000124590 | 17060000124590 | 1 | PA794270 | PM842972 |
| 17060000124598 | L17/dossiers | 17 | 17060000124597 | 17060000124597 | 1 | PA795808 | PM843644 |
| 17060000124605 | L17/dossiers | 17 | 17060000124604 | 17060000124604 | 1 | PA774958 | PM843389 |
| 17060000124612 | L17/dossiers | 17 | 17060000124611 | 17060000124611 | 1 | PA794154 | PM842918 |
| 17060000124619 | L17/dossiers | 17 | 17060000124618 | 17060000124618 | 1 | PA794786 | PM843242 |
| 17060000124626 | L17/dossiers | 17 | 17060000124625 | 17060000124625 | 1 | PA718884 | PM842420 |
| 17060000124633 | L17/dossiers | 17 | 17060000124632 | 17060000124632 | 1 | PA345722 | PM843650 |
| 17060000124641 | L17/dossiers | 17 | 17060000124640 | 17060000124640 | 1 | PA795722 | PM843488 |
| 17060000124649 | L17/dossiers | 17 | 17060000124648 | 17060000124648 | 1 | PA774958 | PM843389 |
| 17060000124656 | L17/dossiers | 17 | 17060000124655 | 17060000124655 | 1 | PA721442 | PM843362 |
| 17060000124663 | L17/dossiers | 17 | 17060000124662 | 17060000124662 | 1 | PA345722 | PM843650 |
| 17060000124671 | L17/dossiers | 17 | 17060000124670 | 17060000124670 | 1 | PA794486 | PM843110 |
| 17060000124678 | L17/dossiers | 17 | 17060000124677 | 17060000124677 | 1 | PA794058 | PM842861 |
| 17060000124685 | L17/dossiers | 17 | 17060000124684 | 17060000124684 | 1 | PA606098 | PM842633 |
| 17060000124692 | L17/dossiers | 17 | 17060000124691 | 17060000124691 | 1 | PA841853 | PM843413 |
| 17060000124716 | L17/dossiers | 17 | 17060000124715 | 17060000124715 | 1 | PA795430 | PM843602 |
| 17060000124730 | L17/dossiers | 17 | 17060000124729 | 17060000124729 | 1 | PA793624 | PM842564 |
| 17060000124753 | L17/dossiers | 17 | 17060000124752 | 17060000124752 | 1 | PA795156 | PM843680 |
| 17060000124775 | L17/dossiers | 17 | 17060000124774 | 17060000124774 | 1 | PA719930 | PM842870 |
| 17060000124798 | L17/dossiers | 17 | 17060000124797 | 17060000124797 | 1 | PA346782 | PM840426 |
| 17060000124805 | L17/dossiers | 17 | 17060000124804 | 17060000124804 | 1 | PA642764 | PM842711 |
| 17060000124818 | L17/dossiers | 17 | 17060000124817 | 17060000124817 | 1 | PA793122 | PM842369 |
| 17060000124825 | L17/dossiers | 17 | 17060000124824 | 17060000124824 | 1 | PA794166 | PM842924 |
| 17060000124832 | L17/dossiers | 17 | 17060000124831 | 17060000124831 | 1 | PA793852 | PM842684 |
| 17060000124839 | L17/dossiers | 17 | 17060000124838 | 17060000124838 | 1 | PA719024 | PM842390 |
| 17060000124846 | L17/dossiers | 17 | 17060000124845 | 17060000124845 | 1 | PA795240 | PM843785 |
| 17060000124853 | L17/dossiers | 17 | 17060000124852 | 17060000124852 | 1 | PA267743 | PM829699 |
| 17060000124860 | L17/dossiers | 17 | 17060000124859 | 17060000124859 | 1 | PA718850 | PM842411 |
| 17060000124867 | L17/dossiers | 17 | 17060000124866 | 17060000124866 | 1 | PA267328 | PM775729 |
| 17060000124874 | L17/dossiers | 17 | 17060000124873 | 17060000124873 | 1 | PA773891 | PM829713 |
| 17060000124881 | L17/dossiers | 17 | 17060000124880 | 17060000124880 | 1 | PA773891 | PM829713 |
| 17060000124888 | L17/dossiers | 17 | 17060000124887 | 17060000124887 | 1 | PA773891 | PM829713 |
| 17060000124895 | L17/dossiers | 17 | 17060000124894 | 17060000124894 | 1 | PA736229 | PM829923 |
| 17060000124902 | L17/dossiers | 17 | 17060000124901 | 17060000124901 | 1 | PA368 | PM847741 |
| 17060000124934 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 1 | PA827946 | PM828614 |