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 |
|---|---|---|---|---|---|---|---|
| 17060000144557 | L17/dossiers | 17 | 17060000144555 | 17060000144555 | 2 | PA721134 | PM873687 |
| 17060000144588 | L17/dossiers | 17 | 17060000144587 | 17060000144587 | 1 | PA721960 | PM840378 |
| 17060000144605 | L17/dossiers | 17 | 17060000144604 | 17060000144604 | 1 | PA643210 | PM873637 |
| 17060000144631 | L17/dossiers | 17 | 17060000144630 | 17060000144630 | 1 | PA840809 | PM842474 |
| 17060000144638 | L17/dossiers | 17 | 17060000144637 | 17060000144637 | 1 | PA722390 | PM843317 |
| 17060000144645 | L17/dossiers | 17 | 17060000144644 | 17060000144644 | 1 | PA793780 | PM842714 |
| 17060000144652 | L17/dossiers | 17 | 17060000144651 | 17060000144651 | 1 | PA841701 | PM843269 |
| 17060000144659 | L17/dossiers | 17 | 17060000144658 | 17060000144658 | 1 | PA840773 | PM842456 |
| 17060000144666 | L17/dossiers | 17 | 17060000144665 | 17060000144665 | 1 | PA795552 | PM840408 |
| 17060000144673 | L17/dossiers | 17 | 17060000144672 | 17060000144672 | 1 | PA841713 | PM843275 |
| 17060000144680 | L17/dossiers | 17 | 17060000144679 | 17060000144679 | 1 | PA795672 | PM843752 |
| 17060000144687 | L17/dossiers | 17 | 17060000144686 | 17060000144686 | 1 | PA841729 | PM843287 |
| 17060000144694 | L17/dossiers | 17 | 17060000144693 | 17060000144693 | 1 | PA842279 | PM843779 |
| 17060000144701 | L17/dossiers | 17 | 17060000144700 | 17060000144700 | 1 | PA794686 | PM843080 |
| 17060000144708 | L17/dossiers | 17 | 17060000144707 | 17060000144707 | 1 | PA841873 | PM843434 |
| 17060000144715 | L17/dossiers | 17 | 17060000144714 | 17060000144714 | 1 | PA795240 | PM843785 |
| 17060000144736 | L17/dossiers | 17 | 17060000144735 | 17060000144735 | 1 | PA793322 | PM840246 |
| 17060000144744 | L17/dossiers | 17 | 17060000144743 | 17060000144743 | 1 | PA840171 | PM840360 |
| 17060000144751 | L17/dossiers | 17 | 17060000144750 | 17060000144750 | 1 | PA841717 | PM843278 |
| 17060000144758 | L17/dossiers | 17 | 17060000144757 | 17060000144757 | 1 | PA793904 | PM840288 |
| 17060000144765 | L17/dossiers | 17 | 17060000144764 | 17060000144764 | 1 | PA719922 | PM842867 |
| 17060000144772 | L17/dossiers | 17 | 17060000144771 | 17060000144771 | 1 | PA842195 | PM843707 |
| 17060000144779 | L17/dossiers | 17 | 17060000144778 | 17060000144778 | 1 | PA608826 | PM843365 |
| 17060000144786 | L17/dossiers | 17 | 17060000144785 | 17060000144785 | 1 | PA794166 | PM842924 |
| 17060000144793 | L17/dossiers | 17 | 17060000144792 | 17060000144792 | 1 | PA793464 | PM840273 |
| 17060000144800 | L17/dossiers | 17 | 17060000144799 | 17060000144799 | 1 | PA793464 | PM840273 |
| 17060000144807 | L17/dossiers | 17 | 17060000144806 | 17060000144806 | 1 | PA793464 | PM840273 |
| 17060000144814 | L17/dossiers | 17 | 17060000144813 | 17060000144813 | 1 | PA795164 | PM840444 |
| 17060000144821 | L17/dossiers | 17 | 17060000144820 | 17060000144820 | 1 | PA793756 | PM840282 |
| 17060000144828 | L17/dossiers | 17 | 17060000144827 | 17060000144827 | 1 | PA793230 | PM842423 |
| 17060000144835 | L17/dossiers | 17 | 17060000144834 | 17060000144834 | 1 | PA793166 | PM840261 |
| 17060000144842 | L17/dossiers | 17 | 17060000144841 | 17060000144841 | 1 | PA842141 | PM863671 |
| 17060000144849 | L17/dossiers | 17 | 17060000144848 | 17060000144848 | 1 | PA840997 | PM842612 |
| 17060000144862 | L17/dossiers | 17 | 17060000144861 | 17060000144861 | 1 | PA795516 | PM843452 |
| 17060000144869 | L17/dossiers | 17 | 17060000144868 | 17060000144868 | 1 | PA796018 | PM843425 |
| 17060000144882 | L17/dossiers | 17 | 17060000144881 | 17060000144881 | 1 | PA720162 | PM843068 |
| 17060000144889 | L17/dossiers | 17 | 17060000144888 | 17060000144888 | 1 | PA795050 | PM874601 |
| 17060000144896 | L17/dossiers | 17 | 17060000144895 | 17060000144895 | 1 | PA605745 | PM842504 |
| 17060000144903 | L17/dossiers | 17 | 17060000144902 | 17060000144902 | 1 | PA795808 | PM843644 |
| 17060000144915 | L17/dossiers | 17 | 17060000144914 | 17060000144914 | 1 | PA794154 | PM842918 |
| 17060000144932 | L17/dossiers | 17 | 17060000144931 | 17060000144931 | 1 | PA794038 | PM874607 |
| 17060000144980 | L17/dossiers | 17 | 17060000144979 | 17060000144979 | 1 | PA794778 | PM843239 |
| 17060000145015 | L17/dossiers | 17 | 17060000145014 | 17060000145014 | 1 | PA607553 | PM843059 |
| 17060000145023 | L17/dossiers | 17 | 17060000145022 | 17060000145022 | 1 | PA721916 | PM843470 |
| 17060000145036 | L17/dossiers | 17 | 17060000145035 | 17060000145035 | 1 | PA794686 | PM843080 |
| 17060000145043 | L17/dossiers | 17 | 17060000145042 | 17060000145042 | 1 | PA736166 | PM775765 |
| 17060000145068 | L17/dossiers | 17 | 17060000145067 | 17060000145067 | 1 | PA721896 | PM840405 |
| 17060000145075 | L17/dossiers | 17 | 17060000145074 | 17060000145074 | 1 | PA643210 | PM873637 |
| 17060000145082 | L17/dossiers | 17 | 17060000145081 | 17060000145081 | 1 | PA643210 | PM873637 |
| 17060000145104 | L17/dossiers | 17 | 17060000145103 | 17060000145103 | 1 | PA840889 | PM842534 |