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 |
|---|---|---|---|---|---|---|---|
| 17060000135776 | L17/dossiers | 17 | 17060000135775 | 17060000135775 | 1 | PA718784 | PM842342 |
| 17060000135801 | L17/dossiers | 17 | 17060000135800 | 17060000135800 | 1 | PA410 | PM855580 |
| 17060000135802 | L17/dossiers | 17 | 17060000135800 | 17060000135800 | 2 | PA267797 | PM855133 |
| 17060000135803 | L17/dossiers | 17 | 17060000135800 | 17060000135800 | 3 | PA855045 | PM855136 |
| 17060000135804 | L17/dossiers | 17 | 17060000135800 | 17060000135800 | 4 | PA721670 | PM855884 |
| 17060000135836 | L17/dossiers | 17 | 17060000135835 | 17060000135835 | 1 | PA720892 | PM840420 |
| 17060000135850 | L17/dossiers | 17 | 17060000135849 | 17060000135849 | 1 | PA410 | PM855580 |
| 17060000135857 | L17/dossiers | 17 | 17060000135856 | 17060000135856 | 1 | PA268048 | PM829731 |
| 17060000135864 | L17/dossiers | 17 | 17060000135863 | 17060000135863 | 1 | PA841419 | PM843005 |
| 17060000135868 | L17/dossiers | 17 | 17060000135867 | 17060000135867 | 1 | PA736243 | PM829929 |
| 17060000135875 | L17/dossiers | 17 | 17060000135874 | 17060000135874 | 1 | PA795808 | PM843644 |
| 17060000135884 | L17/dossiers | 17 | 17060000135883 | 17060000135883 | 1 | PA703485 | PM775811 |
| 17060000135885 | L17/dossiers | 17 | 17060000135883 | 17060000135883 | 2 | PA775278 | PM775564 |
| 17060000135886 | L17/dossiers | 17 | 17060000135883 | 17060000135883 | 3 | PA827936 | PM828640 |
| 17060000135899 | L17/dossiers | 17 | 17060000135898 | 17060000135898 | 1 | PA794994 | PM858360 |
| 17060000135912 | L17/dossiers | 17 | 17060000135911 | 17060000135911 | 1 | PA775242 | PM775528 |
| 17060000135925 | L17/dossiers | 17 | 17060000135924 | 17060000135924 | 1 | PA796062 | PM843668 |
| 17060000135929 | L17/dossiers | 17 | 17060000135928 | 17060000135928 | 1 | PA775196 | PM775482 |
| 17060000135936 | L17/dossiers | 17 | 17060000135935 | 17060000135935 | 1 | PA775196 | PM775482 |
| 17060000135943 | L17/dossiers | 17 | 17060000135942 | 17060000135942 | 1 | PA793322 | PM840246 |
| 17060000135950 | L17/dossiers | 17 | 17060000135949 | 17060000135949 | 1 | PA712014 | PM858454 |
| 17060000135957 | L17/dossiers | 17 | 17060000135956 | 17060000135956 | 1 | PA719578 | PM842618 |
| 17060000135964 | L17/dossiers | 17 | 17060000135963 | 17060000135963 | 1 | PA795410 | PM843440 |
| 17060000135971 | L17/dossiers | 17 | 17060000135970 | 17060000135970 | 1 | PA841885 | PM843446 |
| 17060000135978 | L17/dossiers | 17 | 17060000135977 | 17060000135977 | 1 | PA794702 | PM843248 |
| 17060000135985 | L17/dossiers | 17 | 17060000135984 | 17060000135984 | 1 | PA793394 | PM842486 |
| 17060000135992 | L17/dossiers | 17 | 17060000135991 | 17060000135991 | 1 | PA793892 | PM842738 |
| 17060000135999 | L17/dossiers | 17 | 17060000135998 | 17060000135998 | 1 | PA795164 | PM840444 |
| 17060000136006 | L17/dossiers | 17 | 17060000136005 | 17060000136005 | 1 | PA267780 | PM843395 |
| 17060000136030 | L17/dossiers | 17 | 17060000136029 | 17060000136029 | 1 | PA793980 | PM842750 |
| 17060000136037 | L17/dossiers | 17 | 17060000136036 | 17060000136036 | 1 | PA795482 | PM843605 |
| 17060000136044 | L17/dossiers | 17 | 17060000136043 | 17060000136043 | 1 | PA719286 | PM842669 |
| 17060000136051 | L17/dossiers | 17 | 17060000136050 | 17060000136050 | 1 | PA642725 | PM849129 |
| 17060000136058 | L17/dossiers | 17 | 17060000136057 | 17060000136057 | 1 | PA408578 | PM843662 |
| 17060000136065 | L17/dossiers | 17 | 17060000136064 | 17060000136064 | 1 | PA608826 | PM843365 |
| 17060000136072 | L17/dossiers | 17 | 17060000136071 | 17060000136071 | 1 | PA841693 | PM843266 |
| 17060000136079 | L17/dossiers | 17 | 17060000136078 | 17060000136078 | 1 | PA642868 | PM858305 |
| 17060000136086 | L17/dossiers | 17 | 17060000136085 | 17060000136085 | 1 | PA643089 | PM858443 |
| 17060000136093 | L17/dossiers | 17 | 17060000136092 | 17060000136092 | 1 | PA643089 | PM858443 |
| 17060000136100 | L17/dossiers | 17 | 17060000136099 | 17060000136099 | 1 | PA719412 | PM842651 |
| 17060000136107 | L17/dossiers | 17 | 17060000136106 | 17060000136106 | 1 | PA794082 | PM842810 |
| 17060000136114 | L17/dossiers | 17 | 17060000136113 | 17060000136113 | 1 | PA330240 | PM842357 |
| 17060000136121 | L17/dossiers | 17 | 17060000136120 | 17060000136120 | 1 | PA794022 | PM842777 |
| 17060000136128 | L17/dossiers | 17 | 17060000136127 | 17060000136127 | 1 | PA795454 | PM843821 |
| 17060000136135 | L17/dossiers | 17 | 17060000136134 | 17060000136134 | 1 | PA793254 | PM842432 |
| 17060000136142 | L17/dossiers | 17 | 17060000136141 | 17060000136141 | 1 | PA794786 | PM843242 |
| 17060000136149 | L17/dossiers | 17 | 17060000136148 | 17060000136148 | 1 | PA410 | PM855580 |
| 17060000136150 | L17/dossiers | 17 | 17060000136148 | 17060000136148 | 2 | PA721836 | PM855144 |
| 17060000136191 | L17/dossiers | 17 | 17060000136190 | 17060000136190 | 1 | PA721742 | PM829056 |
| 17060000136198 | L17/dossiers | 17 | 17060000136197 | 17060000136197 | 1 | PA827996 | PM828764 |