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 |
|---|---|---|---|---|---|---|---|
| 15060000153096 | L15/dossiers | 15 | 15060000153095 | 15060000153095 | 1 | PA643089 | PM758076 |
| 15060000153103 | L15/dossiers | 15 | 15060000153102 | 15060000153102 | 1 | PA720178 | PM722882 |
| 15060000153110 | L15/dossiers | 15 | 15060000153109 | 15060000153109 | 1 | PA643089 | PM758076 |
| 15060000153117 | L15/dossiers | 15 | 15060000153116 | 15060000153116 | 1 | PA719946 | PM722808 |
| 15060000153135 | L15/dossiers | 15 | 15060000153134 | 15060000153134 | 1 | PA335999 | PM723480 |
| 15060000153142 | L15/dossiers | 15 | 15060000153141 | 15060000153141 | 1 | PA856 | PM723288 |
| 15060000153149 | L15/dossiers | 15 | 15060000153148 | 15060000153148 | 1 | PA720586 | PM723008 |
| 15060000153156 | L15/dossiers | 15 | 15060000153155 | 15060000153155 | 1 | PA722150 | PM723486 |
| 15060000153163 | L15/dossiers | 15 | 15060000153162 | 15060000153162 | 1 | PA721174 | PM723194 |
| 15060000153173 | L15/dossiers | 15 | 15060000153172 | 15060000153172 | 1 | PA721474 | PM723286 |
| 15060000153180 | L15/dossiers | 15 | 15060000153179 | 15060000153179 | 1 | PA330240 | PM722492 |
| 15060000153184 | L15/dossiers | 15 | 15060000153183 | 15060000153183 | 1 | PA944 | PM703562 |
| 15060000153191 | L15/dossiers | 15 | 15060000153190 | 15060000153190 | 1 | PA944 | PM703562 |
| 15060000153198 | L15/dossiers | 15 | 15060000153197 | 15060000153197 | 1 | PA944 | PM703562 |
| 15060000153208 | L15/dossiers | 15 | 15060000153207 | 15060000153207 | 1 | PA719464 | PM722670 |
| 15060000153215 | L15/dossiers | 15 | 15060000153214 | 15060000153214 | 1 | PA415476 | PM703653 |
| 15060000153222 | L15/dossiers | 15 | 15060000153221 | 15060000153221 | 1 | PA610681 | PM723150 |
| 15060000153240 | L15/dossiers | 15 | 15060000153239 | 15060000153239 | 1 | PA606171 | PM722632 |
| 15060000153249 | L15/dossiers | 15 | 15060000153248 | 15060000153248 | 1 | PA267289 | PM754301 |
| 15060000153253 | L15/dossiers | 15 | 15060000153252 | 15060000153252 | 1 | PA2337 | PM703577 |
| 15060000153260 | L15/dossiers | 15 | 15060000153259 | 15060000153259 | 1 | PA736175 | PM736344 |
| 15060000153261 | L15/dossiers | 15 | 15060000153259 | 15060000153259 | 2 | PA736195 | PM736357 |
| 15060000153262 | L15/dossiers | 15 | 15060000153259 | 15060000153259 | 3 | PA757676 | PM757692 |
| 15060000153263 | L15/dossiers | 15 | 15060000153259 | 15060000153259 | 4 | PA429836 | PM736345 |
| 15060000153264 | L15/dossiers | 15 | 15060000153259 | 15060000153259 | 5 | PA736173 | PM736369 |
| 15060000153274 | L15/dossiers | 15 | 15060000153273 | 15060000153273 | 1 | PA345619 | PM725692 |
| 15060000153275 | L15/dossiers | 15 | 15060000153273 | 15060000153273 | 2 | PA717153 | PM730062 |
| 15060000153276 | L15/dossiers | 15 | 15060000153273 | 15060000153273 | 3 | PA331481 | PM730094 |
| 15060000153283 | L15/dossiers | 15 | 15060000153282 | 15060000153282 | 1 | PA703528 | PM703588 |
| 15060000153293 | L15/dossiers | 15 | 15060000153292 | 15060000153292 | 1 | PA345619 | PM725692 |
| 15060000153306 | L15/dossiers | 15 | 15060000153305 | 15060000153305 | 1 | PA2150 | PM722506 |
| 15060000153313 | L15/dossiers | 15 | 15060000153312 | 15060000153312 | 1 | PA721210 | PM723204 |
| 15060000153320 | L15/dossiers | 15 | 15060000153319 | 15060000153319 | 1 | PA736247 | PM736281 |
| 15060000153321 | L15/dossiers | 15 | 15060000153319 | 15060000153319 | 2 | PA703520 | PM703665 |
| 15060000153322 | L15/dossiers | 15 | 15060000153319 | 15060000153319 | 3 | PA429842 | PM736373 |
| 15060000153323 | L15/dossiers | 15 | 15060000153319 | 15060000153319 | 4 | PA304000 | PM703599 |
| 15060000153342 | L15/dossiers | 15 | 15060000153341 | 15060000153341 | 1 | PA335999 | PM723480 |
| 15060000153349 | L15/dossiers | 15 | 15060000153348 | 15060000153348 | 1 | PA736228 | PM736380 |
| 15060000153356 | L15/dossiers | 15 | 15060000153355 | 15060000153355 | 1 | PA429858 | PM736268 |
| 15060000153357 | L15/dossiers | 15 | 15060000153355 | 15060000153355 | 2 | PA267340 | PM703713 |
| 15060000153358 | L15/dossiers | 15 | 15060000153355 | 15060000153355 | 3 | PA2538 | PM703570 |
| 15060000153365 | L15/dossiers | 15 | 15060000153364 | 15060000153364 | 1 | PA266867 | PM703554 |
| 15060000153372 | L15/dossiers | 15 | 15060000153371 | 15060000153371 | 1 | PA429858 | PM736268 |
| 15060000153373 | L15/dossiers | 15 | 15060000153371 | 15060000153371 | 2 | PA267340 | PM703713 |
| 15060000153374 | L15/dossiers | 15 | 15060000153371 | 15060000153371 | 3 | PA2538 | PM703570 |
| 15060000153381 | L15/dossiers | 15 | 15060000153380 | 15060000153380 | 1 | PA429858 | PM736268 |
| 15060000153382 | L15/dossiers | 15 | 15060000153380 | 15060000153380 | 2 | PA267340 | PM703713 |
| 15060000153383 | L15/dossiers | 15 | 15060000153380 | 15060000153380 | 3 | PA2538 | PM703570 |
| 15060000153390 | L15/dossiers | 15 | 15060000153389 | 15060000153389 | 1 | PA720822 | PM723086 |
| 15060000153400 | L15/dossiers | 15 | 15060000153399 | 15060000153399 | 1 | PA607395 | PM760313 |