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 |
|---|---|---|---|---|---|---|---|
| 15060000158185 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 11 | PA703539 | PM703693 |
| 15060000158186 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 12 | PA1183 | PM706347 |
| 15060000158187 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 13 | PA1183 | PM706347 |
| 15060000158188 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 14 | PA227029 | PM736306 |
| 15060000158189 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 15 | PA266867 | PM703554 |
| 15060000158190 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 16 | PA267081 | PM703617 |
| 15060000158191 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 17 | PA736206 | PM736351 |
| 15060000158192 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 18 | PA736232 | PM736401 |
| 15060000158193 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 19 | PA205280 | PM736412 |
| 15060000158194 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 20 | PA304000 | PM703599 |
| 15060000158195 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 21 | PA736230 | PM736377 |
| 15060000158196 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 22 | PA415447 | PM703616 |
| 15060000158197 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 23 | PA736213 | PM736431 |
| 15060000158198 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 24 | PA343775 | PM736367 |
| 15060000158199 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 25 | PA703497 | PM703569 |
| 15060000158200 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 26 | PA2447 | PM703679 |
| 15060000158201 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 27 | PA267728 | PM736277 |
| 15060000158202 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 28 | PA758431 | PM758701 |
| 15060000158203 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 29 | PA429874 | PM736314 |
| 15060000158204 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 30 | PA303996 | PM703614 |
| 15060000158205 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 31 | PA736196 | PM736370 |
| 15060000158212 | L15/dossiers | 15 | 15060000158211 | 15060000158211 | 1 | PA2116 | PM736339 |
| 15060000158219 | L15/dossiers | 15 | 15060000158218 | 15060000158218 | 1 | PA703485 | PM703654 |
| 15060000158226 | L15/dossiers | 15 | 15060000158225 | 15060000158225 | 1 | PA2552 | PM736292 |
| 15060000158233 | L15/dossiers | 15 | 15060000158232 | 15060000158232 | 1 | PA267081 | PM703617 |
| 15060000158240 | L15/dossiers | 15 | 15060000158239 | 15060000158239 | 1 | PA736207 | PM736391 |
| 15060000158247 | L15/dossiers | 15 | 15060000158246 | 15060000158246 | 1 | PA703538 | PM703698 |
| 15060000158254 | L15/dossiers | 15 | 15060000158253 | 15060000158253 | 1 | PA415447 | PM703616 |
| 15060000158261 | L15/dossiers | 15 | 15060000158260 | 15060000158260 | 1 | PA2116 | PM736339 |
| 15060000158268 | L15/dossiers | 15 | 15060000158267 | 15060000158267 | 1 | PA736220 | PM736267 |
| 15060000158275 | L15/dossiers | 15 | 15060000158274 | 15060000158274 | 1 | PA736231 | PM736381 |
| 15060000158282 | L15/dossiers | 15 | 15060000158281 | 15060000158281 | 1 | PA425322 | PM736282 |
| 15060000158289 | L15/dossiers | 15 | 15060000158288 | 15060000158288 | 1 | PA267328 | PM703547 |
| 15060000158290 | L15/dossiers | 15 | 15060000158288 | 15060000158288 | 2 | PA267018 | PM703564 |
| 15060000158291 | L15/dossiers | 15 | 15060000158288 | 15060000158288 | 3 | PA341381 | PM703618 |
| 15060000158298 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 1 | PA429836 | PM736345 |
| 15060000158299 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 2 | PA757676 | PM757692 |
| 15060000158300 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 3 | PA736173 | PM736369 |
| 15060000158301 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 4 | PA304082 | PM736354 |
| 15060000158302 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 5 | PA429891 | PM736329 |
| 15060000158303 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 6 | PA429894 | PM736364 |
| 15060000158304 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 7 | PA756685 | PM756689 |
| 15060000158305 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 8 | PA304071 | PM703676 |
| 15060000158306 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 9 | PA429886 | PM736385 |
| 15060000158307 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 10 | PA736195 | PM736357 |
| 15060000158308 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 11 | PA736177 | PM736318 |
| 15060000158309 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 12 | PA1978 | PM736337 |
| 15060000158310 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 13 | PA678263 | PM736330 |
| 15060000158311 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 14 | PA736243 | PM736413 |
| 15060000158312 | L15/dossiers | 15 | 15060000158297 | 15060000158297 | 15 | PA703499 | PM703641 |