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 |
|---|---|---|---|---|---|---|---|
| 15060000141571 | L15/dossiers | 15 | 15060000141570 | 15060000141570 | 1 | PA720386 | PM722948 |
| 15060000141578 | L15/dossiers | 15 | 15060000141577 | 15060000141577 | 1 | PA719272 | PM722612 |
| 15060000141585 | L15/dossiers | 15 | 15060000141584 | 15060000141584 | 1 | PA719272 | PM722612 |
| 15060000141592 | L15/dossiers | 15 | 15060000141591 | 15060000141591 | 1 | PA718926 | PM722502 |
| 15060000141599 | L15/dossiers | 15 | 15060000141598 | 15060000141598 | 1 | PA721932 | PM734586 |
| 15060000141609 | L15/dossiers | 15 | 15060000141608 | 15060000141608 | 1 | PA719946 | PM722808 |
| 15060000141616 | L15/dossiers | 15 | 15060000141615 | 15060000141615 | 1 | PA2377 | PM723550 |
| 15060000141623 | L15/dossiers | 15 | 15060000141622 | 15060000141622 | 1 | PA331567 | PM722644 |
| 15060000141630 | L15/dossiers | 15 | 15060000141629 | 15060000141629 | 1 | PA331567 | PM722644 |
| 15060000141641 | L15/dossiers | 15 | 15060000141640 | 15060000141640 | 1 | PA331567 | PM722644 |
| 15060000141648 | L15/dossiers | 15 | 15060000141647 | 15060000141647 | 1 | PA1327 | PM722762 |
| 15060000141655 | L15/dossiers | 15 | 15060000141654 | 15060000141654 | 1 | PA267766 | PM722970 |
| 15060000141698 | L15/dossiers | 15 | 15060000141697 | 15060000141697 | 1 | PA345619 | PM725692 |
| 15060000141709 | L15/dossiers | 15 | 15060000141708 | 15060000141708 | 1 | PA345619 | PM725692 |
| 15060000141743 | L15/dossiers | 15 | 15060000141742 | 15060000141742 | 1 | PA267780 | PM723504 |
| 15060000141747 | L15/dossiers | 15 | 15060000141746 | 15060000141746 | 1 | PA2952 | PM722480 |
| 15060000141754 | L15/dossiers | 15 | 15060000141753 | 15060000141753 | 1 | PA2952 | PM722480 |
| 15060000141761 | L15/dossiers | 15 | 15060000141760 | 15060000141760 | 1 | PA2952 | PM722480 |
| 15060000141768 | L15/dossiers | 15 | 15060000141767 | 15060000141767 | 1 | PA2952 | PM722480 |
| 15060000141775 | L15/dossiers | 15 | 15060000141774 | 15060000141774 | 1 | PA2952 | PM722480 |
| 15060000141782 | L15/dossiers | 15 | 15060000141781 | 15060000141781 | 1 | PA334149 | PM723034 |
| 15060000141789 | L15/dossiers | 15 | 15060000141788 | 15060000141788 | 1 | PA2952 | PM722480 |
| 15060000141796 | L15/dossiers | 15 | 15060000141795 | 15060000141795 | 1 | PA2952 | PM722480 |
| 15060000141803 | L15/dossiers | 15 | 15060000141802 | 15060000141802 | 1 | PA720846 | PM723094 |
| 15060000141813 | L15/dossiers | 15 | 15060000141812 | 15060000141812 | 1 | PA720468 | PM722972 |
| 15060000141820 | L15/dossiers | 15 | 15060000141819 | 15060000141819 | 1 | PA642868 | PM722992 |
| 15060000141827 | L15/dossiers | 15 | 15060000141826 | 15060000141826 | 1 | PA720960 | PM723124 |
| 15060000141842 | L15/dossiers | 15 | 15060000141841 | 15060000141841 | 1 | PA345619 | PM725692 |
| 15060000141849 | L15/dossiers | 15 | 15060000141848 | 15060000141848 | 1 | PA722390 | PM723560 |
| 15060000141866 | L15/dossiers | 15 | 15060000141865 | 15060000141865 | 1 | PA606712 | PM722756 |
| 15060000141888 | L15/dossiers | 15 | 15060000141887 | 15060000141887 | 1 | PA718838 | PM722474 |
| 15060000141895 | L15/dossiers | 15 | 15060000141894 | 15060000141894 | 1 | PA267801 | PM723320 |
| 15060000141902 | L15/dossiers | 15 | 15060000141901 | 15060000141901 | 1 | PA720430 | PM722962 |
| 15060000141912 | L15/dossiers | 15 | 15060000141911 | 15060000141911 | 1 | PA721932 | PM734586 |
| 15060000141922 | L15/dossiers | 15 | 15060000141921 | 15060000141921 | 1 | PA345619 | PM725692 |
| 15060000141954 | L15/dossiers | 15 | 15060000141953 | 15060000141953 | 1 | PA720430 | PM722962 |
| 15060000141967 | L15/dossiers | 15 | 15060000141966 | 15060000141966 | 1 | PA719578 | PM722702 |
| 15060000141974 | L15/dossiers | 15 | 15060000141973 | 15060000141973 | 1 | PA609726 | PM723426 |
| 15060000141981 | L15/dossiers | 15 | 15060000141980 | 15060000141980 | 1 | PA709315 | PM722526 |
| 15060000141988 | L15/dossiers | 15 | 15060000141987 | 15060000141987 | 1 | PA721486 | PM723290 |
| 15060000141995 | L15/dossiers | 15 | 15060000141994 | 15060000141994 | 1 | PA642847 | PM722954 |
| 15060000142002 | L15/dossiers | 15 | 15060000142001 | 15060000142001 | 1 | PA718780 | PM722454 |
| 15060000142009 | L15/dossiers | 15 | 15060000142008 | 15060000142008 | 1 | PA607090 | PM722796 |
| 15060000142016 | L15/dossiers | 15 | 15060000142015 | 15060000142015 | 1 | PA267289 | PM754301 |
| 15060000142023 | L15/dossiers | 15 | 15060000142022 | 15060000142022 | 1 | PA721474 | PM723286 |
| 15060000142030 | L15/dossiers | 15 | 15060000142029 | 15060000142029 | 1 | PA721474 | PM723286 |
| 15060000142037 | L15/dossiers | 15 | 15060000142036 | 15060000142036 | 1 | PA721474 | PM723286 |
| 15060000142044 | L15/dossiers | 15 | 15060000142043 | 15060000142043 | 1 | PA721474 | PM723286 |
| 15060000142051 | L15/dossiers | 15 | 15060000142050 | 15060000142050 | 1 | PA2155 | PM722490 |
| 15060000142058 | L15/dossiers | 15 | 15060000142057 | 15060000142057 | 1 | PA609245 | PM723318 |