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 |
|---|---|---|---|---|---|---|---|
| 15060000183650 | L15/dossiers | 15 | 15060000183649 | 15060000183649 | 1 | PA773441 | PM773491 |
| 15060000183657 | L15/dossiers | 15 | 15060000183656 | 15060000183656 | 1 | PA773441 | PM773491 |
| 15060000183664 | L15/dossiers | 15 | 15060000183663 | 15060000183663 | 1 | PA720278 | PM722916 |
| 15060000183671 | L15/dossiers | 15 | 15060000183670 | 15060000183670 | 1 | PA721142 | PM723186 |
| 15060000183678 | L15/dossiers | 15 | 15060000183677 | 15060000183677 | 1 | PA2116 | PM736339 |
| 15060000183685 | L15/dossiers | 15 | 15060000183684 | 15060000183684 | 1 | PA267785 | PM723310 |
| 15060000183689 | L15/dossiers | 15 | 15060000183688 | 15060000183688 | 1 | PA404656 | PM736328 |
| 15060000183696 | L15/dossiers | 15 | 15060000183695 | 15060000183695 | 1 | PA721126 | PM723182 |
| 15060000183703 | L15/dossiers | 15 | 15060000183702 | 15060000183702 | 1 | PA719946 | PM722808 |
| 15060000183710 | L15/dossiers | 15 | 15060000183709 | 15060000183709 | 1 | PA783457 | PM783488 |
| 15060000183717 | L15/dossiers | 15 | 15060000183716 | 15060000183716 | 1 | PA773441 | PM773491 |
| 15060000183718 | L15/dossiers | 15 | 15060000183716 | 15060000183716 | 2 | PA1872 | PM773455 |
| 15060000183741 | L15/dossiers | 15 | 15060000183740 | 15060000183740 | 1 | PA773441 | PM773491 |
| 15060000183748 | L15/dossiers | 15 | 15060000183747 | 15060000183747 | 1 | PA770871 | PM770877 |
| 15060000183755 | L15/dossiers | 15 | 15060000183754 | 15060000183754 | 1 | PA703522 | PM775701 |
| 15060000183756 | L15/dossiers | 15 | 15060000183754 | 15060000183754 | 2 | PA429840 | PM736360 |
| 15060000183763 | L15/dossiers | 15 | 15060000183762 | 15060000183762 | 1 | PA736227 | PM736308 |
| 15060000183770 | L15/dossiers | 15 | 15060000183769 | 15060000183769 | 1 | PA773441 | PM773491 |
| 15060000183777 | L15/dossiers | 15 | 15060000183776 | 15060000183776 | 1 | PA605036 | PM722444 |
| 15060000183784 | L15/dossiers | 15 | 15060000183783 | 15060000183783 | 1 | PA719946 | PM722808 |
| 15060000183791 | L15/dossiers | 15 | 15060000183790 | 15060000183790 | 1 | PA719946 | PM722808 |
| 15060000183798 | L15/dossiers | 15 | 15060000183797 | 15060000183797 | 1 | PA719946 | PM722808 |
| 15060000183805 | L15/dossiers | 15 | 15060000183804 | 15060000183804 | 1 | PA721968 | PM723436 |
| 15060000183812 | L15/dossiers | 15 | 15060000183811 | 15060000183811 | 1 | PA721968 | PM723436 |
| 15060000183819 | L15/dossiers | 15 | 15060000183818 | 15060000183818 | 1 | PA721968 | PM723436 |
| 15060000183826 | L15/dossiers | 15 | 15060000183825 | 15060000183825 | 1 | PA720846 | PM723094 |
| 15060000183833 | L15/dossiers | 15 | 15060000183832 | 15060000183832 | 1 | PA736223 | PM736368 |
| 15060000183851 | L15/dossiers | 15 | 15060000183850 | 15060000183850 | 1 | PA773441 | PM773491 |
| 15060000183858 | L15/dossiers | 15 | 15060000183857 | 15060000183857 | 1 | PA332228 | PM722754 |
| 15060000183865 | L15/dossiers | 15 | 15060000183864 | 15060000183864 | 1 | PA267328 | PM775729 |
| 15060000183872 | L15/dossiers | 15 | 15060000183871 | 15060000183871 | 1 | PA415446 | PM775783 |
| 15060000183879 | L15/dossiers | 15 | 15060000183878 | 15060000183878 | 1 | PA415446 | PM775783 |
| 15060000183886 | L15/dossiers | 15 | 15060000183885 | 15060000183885 | 1 | PA721486 | PM723290 |
| 15060000183893 | L15/dossiers | 15 | 15060000183892 | 15060000183892 | 1 | PA719578 | PM722702 |
| 15060000183911 | L15/dossiers | 15 | 15060000183910 | 15060000183910 | 1 | PA720846 | PM723094 |
| 15060000183917 | L15/dossiers | 15 | 15060000183916 | 15060000183916 | 1 | PA719350 | PM722634 |
| 15060000183924 | L15/dossiers | 15 | 15060000183923 | 15060000183923 | 1 | PA588884 | PM723226 |
| 15060000183930 | L15/dossiers | 15 | 15060000183929 | 15060000183929 | 1 | PA720430 | PM722962 |
| 15060000183948 | L15/dossiers | 15 | 15060000183947 | 15060000183947 | 1 | PA721202 | PM723202 |
| 15060000183971 | L15/dossiers | 15 | 15060000183970 | 15060000183970 | 1 | PA425322 | PM736282 |
| 15060000183972 | L15/dossiers | 15 | 15060000183970 | 15060000183970 | 2 | PA736160 | PM736359 |
| 15060000183991 | L15/dossiers | 15 | 15060000183990 | 15060000183990 | 1 | PA267762 | PM736366 |
| 15060000183998 | L15/dossiers | 15 | 15060000183997 | 15060000183997 | 1 | PA720892 | PM723106 |
| 15060000184013 | L15/dossiers | 15 | 15060000184012 | 15060000184012 | 1 | PA718860 | PM722482 |
| 15060000184030 | L15/dossiers | 15 | 15060000184029 | 15060000184029 | 1 | PA721194 | PM723200 |
| 15060000184034 | L15/dossiers | 15 | 15060000184033 | 15060000184033 | 1 | PA606202 | PM722698 |
| 15060000184054 | L15/dossiers | 15 | 15060000184053 | 15060000184053 | 1 | PA744079 | PM744082 |
| 15060000184061 | L15/dossiers | 15 | 15060000184060 | 15060000184060 | 1 | PA744079 | PM744082 |
| 15060000184068 | L15/dossiers | 15 | 15060000184067 | 15060000184067 | 1 | PA721166 | PM785865 |
| 15060000184097 | L15/dossiers | 15 | 15060000184096 | 15060000184096 | 1 | PA643089 | PM758076 |