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 |
|---|---|---|---|---|---|---|---|
| 15060000187980 | L15/dossiers | 15 | 15060000187979 | 15060000187979 | 1 | PA773441 | PM773491 |
| 15060000187987 | L15/dossiers | 15 | 15060000187986 | 15060000187986 | 1 | PA266788 | PM722914 |
| 15060000187994 | L15/dossiers | 15 | 15060000187993 | 15060000187993 | 1 | PA719946 | PM722808 |
| 15060000188001 | L15/dossiers | 15 | 15060000188000 | 15060000188000 | 1 | PA719946 | PM722808 |
| 15060000188008 | L15/dossiers | 15 | 15060000188007 | 15060000188007 | 1 | PA721246 | PM723214 |
| 15060000188015 | L15/dossiers | 15 | 15060000188014 | 15060000188014 | 1 | PA643089 | PM758076 |
| 15060000188022 | L15/dossiers | 15 | 15060000188021 | 15060000188021 | 1 | PA718930 | PM722504 |
| 15060000188029 | L15/dossiers | 15 | 15060000188028 | 15060000188028 | 1 | PA643089 | PM758076 |
| 15060000188036 | L15/dossiers | 15 | 15060000188035 | 15060000188035 | 1 | PA335612 | PM723506 |
| 15060000188040 | L15/dossiers | 15 | 15060000188039 | 15060000188039 | 1 | PA266788 | PM722914 |
| 15060000188044 | L15/dossiers | 15 | 15060000188043 | 15060000188043 | 1 | PA718720 | PM722436 |
| 15060000188048 | L15/dossiers | 15 | 15060000188047 | 15060000188047 | 1 | PA773441 | PM773491 |
| 15060000188055 | L15/dossiers | 15 | 15060000188054 | 15060000188054 | 1 | PA604 | PM774354 |
| 15060000188062 | L15/dossiers | 15 | 15060000188061 | 15060000188061 | 1 | PA720092 | PM722858 |
| 15060000188069 | L15/dossiers | 15 | 15060000188068 | 15060000188068 | 1 | PA720092 | PM722858 |
| 15060000188076 | L15/dossiers | 15 | 15060000188075 | 15060000188075 | 1 | PA720092 | PM722858 |
| 15060000188083 | L15/dossiers | 15 | 15060000188082 | 15060000188082 | 1 | PA330240 | PM722492 |
| 15060000188090 | L15/dossiers | 15 | 15060000188089 | 15060000188089 | 1 | PA415447 | PM775785 |
| 15060000188097 | L15/dossiers | 15 | 15060000188096 | 15060000188096 | 1 | PA721226 | PM723208 |
| 15060000188104 | L15/dossiers | 15 | 15060000188103 | 15060000188103 | 1 | PA720286 | PM722918 |
| 15060000188111 | L15/dossiers | 15 | 15060000188110 | 15060000188110 | 1 | PA736235 | PM775795 |
| 15060000188118 | L15/dossiers | 15 | 15060000188117 | 15060000188117 | 1 | PA722178 | PM723494 |
| 15060000188123 | L15/dossiers | 15 | 15060000188122 | 15060000188122 | 1 | PA736214 | PM736290 |
| 15060000188130 | L15/dossiers | 15 | 15060000188129 | 15060000188129 | 1 | PA719570 | PM722700 |
| 15060000188137 | L15/dossiers | 15 | 15060000188136 | 15060000188136 | 1 | PA703495 | PM775653 |
| 15060000188144 | L15/dossiers | 15 | 15060000188143 | 15060000188143 | 1 | PA267673 | PM775865 |
| 15060000188151 | L15/dossiers | 15 | 15060000188150 | 15060000188150 | 1 | PA2150 | PM722506 |
| 15060000188158 | L15/dossiers | 15 | 15060000188157 | 15060000188157 | 1 | PA722178 | PM723494 |
| 15060000188162 | L15/dossiers | 15 | 15060000188161 | 15060000188161 | 1 | PA266788 | PM722914 |
| 15060000188169 | L15/dossiers | 15 | 15060000188168 | 15060000188168 | 1 | PA736196 | PM736370 |
| 15060000188176 | L15/dossiers | 15 | 15060000188175 | 15060000188175 | 1 | PA758716 | PM775771 |
| 15060000188177 | L15/dossiers | 15 | 15060000188175 | 15060000188175 | 2 | PA758716 | PM775771 |
| 15060000188184 | L15/dossiers | 15 | 15060000188183 | 15060000188183 | 1 | PA266788 | PM722914 |
| 15060000188191 | L15/dossiers | 15 | 15060000188190 | 15060000188190 | 1 | PA2116 | PM736339 |
| 15060000188198 | L15/dossiers | 15 | 15060000188197 | 15060000188197 | 1 | PA721296 | PM723228 |
| 15060000188208 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 1 | PA736195 | PM736357 |
| 15060000188209 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 2 | PA757676 | PM757692 |
| 15060000188210 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 3 | PA304082 | PM736354 |
| 15060000188211 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 4 | PA775172 | PM775474 |
| 15060000188212 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 5 | PA429894 | PM736364 |
| 15060000188213 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 6 | PA756685 | PM775777 |
| 15060000188214 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 7 | PA429836 | PM736345 |
| 15060000188215 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 8 | PA429886 | PM736385 |
| 15060000188216 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 9 | PA736173 | PM736369 |
| 15060000188217 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 10 | PA775246 | PM775532 |
| 15060000188218 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 11 | PA678263 | PM736330 |
| 15060000188219 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 12 | PA1978 | PM736337 |
| 15060000188220 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 13 | PA736243 | PM736413 |
| 15060000188221 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 14 | PA736175 | PM736344 |
| 15060000188222 | L15/dossiers | 15 | 15060000188207 | 15060000188207 | 15 | PA775296 | PM775596 |