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 |
|---|---|---|---|---|---|---|---|
| 16060000124778 | L16/dossiers | 16 | 16060000124761 | 16060000124761 | 17 | PA785857 | PM785867 |
| 16060000124785 | L16/dossiers | 16 | 16060000124784 | 16060000124784 | 1 | PA795958 | PM797778 |
| 16060000124796 | L16/dossiers | 16 | 16060000124795 | 16060000124795 | 1 | PA794770 | PM797112 |
| 16060000124803 | L16/dossiers | 16 | 16060000124802 | 16060000124802 | 1 | PA722190 | PM833697 |
| 16060000124804 | L16/dossiers | 16 | 16060000124802 | 16060000124802 | 2 | PA607846 | PM833721 |
| 16060000124811 | L16/dossiers | 16 | 16060000124810 | 16060000124810 | 1 | PA720668 | PM797106 |
| 16060000124847 | L16/dossiers | 16 | 16060000124846 | 16060000124846 | 1 | PA335054 | PM797298 |
| 16060000124857 | L16/dossiers | 16 | 16060000124856 | 16060000124856 | 1 | PA775182 | PM775464 |
| 16060000124864 | L16/dossiers | 16 | 16060000124863 | 16060000124863 | 1 | PA736211 | PM829879 |
| 16060000124871 | L16/dossiers | 16 | 16060000124870 | 16060000124870 | 1 | PA720684 | PM797082 |
| 16060000124884 | L16/dossiers | 16 | 16060000124883 | 16060000124883 | 1 | PA721916 | PM797595 |
| 16060000124892 | L16/dossiers | 16 | 16060000124891 | 16060000124891 | 1 | PA642847 | PM796872 |
| 16060000124899 | L16/dossiers | 16 | 16060000124898 | 16060000124898 | 1 | PA795050 | PM797274 |
| 16060000124906 | L16/dossiers | 16 | 16060000124905 | 16060000124905 | 1 | PA794946 | PM797205 |
| 16060000124913 | L16/dossiers | 16 | 16060000124912 | 16060000124912 | 1 | PA794038 | PM796668 |
| 16060000124920 | L16/dossiers | 16 | 16060000124919 | 16060000124919 | 1 | PA794914 | PM797190 |
| 16060000124927 | L16/dossiers | 16 | 16060000124926 | 16060000124926 | 1 | PA795844 | PM797709 |
| 16060000124934 | L16/dossiers | 16 | 16060000124933 | 16060000124933 | 1 | PA793616 | PM796437 |
| 16060000124941 | L16/dossiers | 16 | 16060000124940 | 16060000124940 | 1 | PA794030 | PM796665 |
| 16060000124948 | L16/dossiers | 16 | 16060000124947 | 16060000124947 | 1 | PA606098 | PM796449 |
| 16060000124955 | L16/dossiers | 16 | 16060000124954 | 16060000124954 | 1 | PA794562 | PM796995 |
| 16060000124962 | L16/dossiers | 16 | 16060000124961 | 16060000124961 | 1 | PA795156 | PM797334 |
| 16060000124969 | L16/dossiers | 16 | 16060000124968 | 16060000124968 | 1 | PA795808 | PM797694 |
| 16060000124976 | L16/dossiers | 16 | 16060000124975 | 16060000124975 | 1 | PA2952 | PM796206 |
| 16060000124983 | L16/dossiers | 16 | 16060000124982 | 16060000124982 | 1 | PA774954 | PM796797 |
| 16060000124990 | L16/dossiers | 16 | 16060000124989 | 16060000124989 | 1 | PA266788 | PM796788 |
| 16060000124997 | L16/dossiers | 16 | 16060000124996 | 16060000124996 | 1 | PA793394 | PM796299 |
| 16060000125004 | L16/dossiers | 16 | 16060000125003 | 16060000125003 | 1 | PA720468 | PM796983 |
| 16060000125011 | L16/dossiers | 16 | 16060000125010 | 16060000125010 | 1 | PA720684 | PM797082 |
| 16060000125019 | L16/dossiers | 16 | 16060000125018 | 16060000125018 | 1 | PA2952 | PM796206 |
| 16060000125026 | L16/dossiers | 16 | 16060000125025 | 16060000125025 | 1 | PA794270 | PM796821 |
| 16060000125033 | L16/dossiers | 16 | 16060000125032 | 16060000125032 | 1 | PA1327 | PM796632 |
| 16060000125040 | L16/dossiers | 16 | 16060000125039 | 16060000125039 | 1 | PA330240 | PM796155 |
| 16060000125047 | L16/dossiers | 16 | 16060000125046 | 16060000125046 | 1 | PA793122 | PM796161 |
| 16060000125054 | L16/dossiers | 16 | 16060000125053 | 16060000125053 | 1 | PA719024 | PM796305 |
| 16060000125067 | L16/dossiers | 16 | 16060000125066 | 16060000125066 | 1 | PA266788 | PM796788 |
| 16060000125080 | L16/dossiers | 16 | 16060000125079 | 16060000125079 | 1 | PA309643 | PM797403 |
| 16060000125084 | L16/dossiers | 16 | 16060000125083 | 16060000125083 | 1 | PA775240 | PM775530 |
| 16060000125107 | L16/dossiers | 16 | 16060000125106 | 16060000125106 | 1 | PA793374 | PM796290 |
| 16060000125123 | L16/dossiers | 16 | 16060000125122 | 16060000125122 | 1 | PA605745 | PM796419 |
| 16060000125127 | L16/dossiers | 16 | 16060000125126 | 16060000125126 | 1 | PA608416 | PM797133 |
| 16060000125131 | L16/dossiers | 16 | 16060000125130 | 16060000125130 | 1 | PA736197 | PM829863 |
| 16060000125144 | L16/dossiers | 16 | 16060000125143 | 16060000125143 | 1 | PA795058 | PM797277 |
| 16060000125157 | L16/dossiers | 16 | 16060000125156 | 16060000125156 | 1 | PA793342 | PM796269 |
| 16060000125161 | L16/dossiers | 16 | 16060000125160 | 16060000125160 | 1 | PA722190 | PM833697 |
| 16060000125162 | L16/dossiers | 16 | 16060000125160 | 16060000125160 | 2 | PA331481 | PM833713 |
| 16060000125163 | L16/dossiers | 16 | 16060000125160 | 16060000125160 | 3 | PA267797 | PM833731 |
| 16060000125164 | L16/dossiers | 16 | 16060000125160 | 16060000125160 | 4 | PA793940 | PM834771 |
| 16060000125179 | L16/dossiers | 16 | 16060000125178 | 16060000125178 | 1 | PA721916 | PM797595 |
| 16060000125192 | L16/dossiers | 16 | 16060000125191 | 16060000125191 | 1 | PA795310 | PM797415 |