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 |
|---|---|---|---|---|---|---|---|
| 14060000110508 | L14/dossiers | 14 | 14060000110507 | 14060000110507 | 1 | PA268019 | PM645116 |
| 14060000110525 | L14/dossiers | 14 | 14060000110524 | 14060000110524 | 1 | PA346886 | PM695110 |
| 14060000110532 | L14/dossiers | 14 | 14060000110531 | 14060000110531 | 1 | PA415481 | PM415577 |
| 14060000110533 | L14/dossiers | 14 | 14060000110531 | 14060000110531 | 2 | PA421497 | PM421499 |
| 14060000110562 | L14/dossiers | 14 | 14060000110561 | 14060000110561 | 1 | PA608186 | PM645202 |
| 14060000110575 | L14/dossiers | 14 | 14060000110574 | 14060000110574 | 1 | PA1874 | PM645474 |
| 14060000110582 | L14/dossiers | 14 | 14060000110581 | 14060000110581 | 1 | PA1874 | PM645474 |
| 14060000110592 | L14/dossiers | 14 | 14060000110591 | 14060000110591 | 1 | PA267622 | PM702957 |
| 14060000110599 | L14/dossiers | 14 | 14060000110598 | 14060000110598 | 1 | PA1152 | PM645561 |
| 14060000110606 | L14/dossiers | 14 | 14060000110605 | 14060000110605 | 1 | PA608186 | PM645202 |
| 14060000110618 | L14/dossiers | 14 | 14060000110617 | 14060000110617 | 1 | PA267622 | PM700712 |
| 14060000110648 | L14/dossiers | 14 | 14060000110647 | 14060000110647 | 1 | PA2952 | PM645464 |
| 14060000110655 | L14/dossiers | 14 | 14060000110654 | 14060000110654 | 1 | PA331567 | PM645186 |
| 14060000110662 | L14/dossiers | 14 | 14060000110661 | 14060000110661 | 1 | PA609709 | PM645302 |
| 14060000110672 | L14/dossiers | 14 | 14060000110671 | 14060000110671 | 1 | PA267042 | PM645368 |
| 14060000110679 | L14/dossiers | 14 | 14060000110678 | 14060000110678 | 1 | PA2792 | PM645308 |
| 14060000110686 | L14/dossiers | 14 | 14060000110685 | 14060000110685 | 1 | PA2045 | PM645421 |
| 14060000110694 | L14/dossiers | 14 | 14060000110693 | 14060000110693 | 1 | PA2045 | PM645421 |
| 14060000110712 | L14/dossiers | 14 | 14060000110711 | 14060000110711 | 1 | PA267285 | PM645140 |
| 14060000110719 | L14/dossiers | 14 | 14060000110718 | 14060000110718 | 1 | PA606212 | PM645330 |
| 14060000110726 | L14/dossiers | 14 | 14060000110725 | 14060000110725 | 1 | PA266774 | PM645583 |
| 14060000110733 | L14/dossiers | 14 | 14060000110732 | 14060000110732 | 1 | PA346886 | PM695110 |
| 14060000110740 | L14/dossiers | 14 | 14060000110739 | 14060000110739 | 1 | PA267743 | PM645058 |
| 14060000110747 | L14/dossiers | 14 | 14060000110746 | 14060000110746 | 1 | PA605694 | PM645416 |
| 14060000110758 | L14/dossiers | 14 | 14060000110757 | 14060000110757 | 1 | PA608011 | PM645066 |
| 14060000110759 | L14/dossiers | 14 | 14060000110757 | 14060000110757 | 2 | PA1379 | PM645433 |
| 14060000110769 | L14/dossiers | 14 | 14060000110768 | 14060000110768 | 1 | PA2960 | PM645040 |
| 14060000110797 | L14/dossiers | 14 | 14060000110796 | 14060000110796 | 1 | PA2011 | PM645434 |
| 14060000110804 | L14/dossiers | 14 | 14060000110803 | 14060000110803 | 1 | PA267622 | PM700712 |
| 14060000110849 | L14/dossiers | 14 | 14060000110848 | 14060000110848 | 1 | PA606098 | PM645171 |
| 14060000110856 | L14/dossiers | 14 | 14060000110855 | 14060000110855 | 1 | PA2792 | PM645308 |
| 14060000110863 | L14/dossiers | 14 | 14060000110862 | 14060000110862 | 1 | PA267429 | PM645130 |
| 14060000110870 | L14/dossiers | 14 | 14060000110869 | 14060000110869 | 1 | PA346886 | PM695110 |
| 14060000110877 | L14/dossiers | 14 | 14060000110876 | 14060000110876 | 1 | PA1886 | PM645099 |
| 14060000110932 | L14/dossiers | 14 | 14060000110931 | 14060000110931 | 1 | PA609513 | PM645228 |
| 14060000110940 | L14/dossiers | 14 | 14060000110939 | 14060000110939 | 1 | PA328 | PM653228 |
| 14060000110941 | L14/dossiers | 14 | 14060000110939 | 14060000110939 | 2 | PA1268 | PM653525 |
| 14060000110971 | L14/dossiers | 14 | 14060000110970 | 14060000110970 | 1 | PA1521 | PM645078 |
| 14060000110992 | L14/dossiers | 14 | 14060000110991 | 14060000110991 | 1 | PA328 | PM653228 |
| 14060000110993 | L14/dossiers | 14 | 14060000110991 | 14060000110991 | 2 | PA2240 | PM653295 |
| 14060000111727 | L14/dossiers | 14 | 14060000111726 | 14060000111726 | 1 | PA2011 | PM645434 |
| 14060000111734 | L14/dossiers | 14 | 14060000111733 | 14060000111733 | 1 | PA267330 | PM645032 |
| 14060000111741 | L14/dossiers | 14 | 14060000111740 | 14060000111740 | 1 | PA2907 | PM645289 |
| 14060000111755 | L14/dossiers | 14 | 14060000111754 | 14060000111754 | 1 | PA328 | PM653228 |
| 14060000111756 | L14/dossiers | 14 | 14060000111754 | 14060000111754 | 2 | PA2825 | PM653254 |
| 14060000111786 | L14/dossiers | 14 | 14060000111785 | 14060000111785 | 1 | PA334149 | PM645127 |
| 14060000111793 | L14/dossiers | 14 | 14060000111792 | 14060000111792 | 1 | PA610481 | PM645131 |
| 14060000111800 | L14/dossiers | 14 | 14060000111799 | 14060000111799 | 1 | PA345897 | PM645209 |
| 14060000111807 | L14/dossiers | 14 | 14060000111806 | 14060000111806 | 1 | PA266788 | PM645294 |
| 14060000111820 | L14/dossiers | 14 | 14060000111819 | 14060000111819 | 1 | PA267306 | PM645210 |