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 |
|---|---|---|---|---|---|---|---|
| 16060000100019 | L16/dossiers | 16 | 16060000100018 | 16060000100018 | 1 | PA718926 | PM796326 |
| 16060000100026 | L16/dossiers | 16 | 16060000100025 | 16060000100025 | 1 | PA607090 | PM796761 |
| 16060000100033 | L16/dossiers | 16 | 16060000100032 | 16060000100032 | 1 | PA267306 | PM797073 |
| 16060000100040 | L16/dossiers | 16 | 16060000100039 | 16060000100039 | 1 | PA610002 | PM797286 |
| 16060000100047 | L16/dossiers | 16 | 16060000100046 | 16060000100046 | 1 | PA719372 | PM796446 |
| 16060000100109 | L16/dossiers | 16 | 16060000100108 | 16060000100108 | 1 | PA719186 | PM796368 |
| 16060000100163 | L16/dossiers | 16 | 16060000100162 | 16060000100162 | 1 | PA720066 | PM796842 |
| 16060000100218 | L16/dossiers | 16 | 16060000100217 | 16060000100217 | 1 | PA794914 | PM797190 |
| 16060000100225 | L16/dossiers | 16 | 16060000100224 | 16060000100224 | 1 | PA744079 | PM744082 |
| 16060000100232 | L16/dossiers | 16 | 16060000100231 | 16060000100231 | 1 | PA775170 | PM775468 |
| 16060000100239 | L16/dossiers | 16 | 16060000100238 | 16060000100238 | 1 | PA744079 | PM744082 |
| 16060000100246 | L16/dossiers | 16 | 16060000100245 | 16060000100245 | 1 | PA744079 | PM744082 |
| 16060000100253 | L16/dossiers | 16 | 16060000100252 | 16060000100252 | 1 | PA721130 | PM775608 |
| 16060000100277 | L16/dossiers | 16 | 16060000100276 | 16060000100276 | 1 | PA266788 | PM796788 |
| 16060000100285 | L16/dossiers | 16 | 16060000100284 | 16060000100284 | 1 | PA717161 | PM791583 |
| 16060000100286 | L16/dossiers | 16 | 16060000100284 | 16060000100284 | 2 | PA801862 | PM801948 |
| 16060000100296 | L16/dossiers | 16 | 16060000100295 | 16060000100295 | 1 | PA717161 | PM791583 |
| 16060000100312 | L16/dossiers | 16 | 16060000100311 | 16060000100311 | 1 | PA2952 | PM796206 |
| 16060000100319 | L16/dossiers | 16 | 16060000100318 | 16060000100318 | 1 | PA2952 | PM796206 |
| 16060000100326 | L16/dossiers | 16 | 16060000100325 | 16060000100325 | 1 | PA2952 | PM796206 |
| 16060000100333 | L16/dossiers | 16 | 16060000100332 | 16060000100332 | 1 | PA608695 | PM797220 |
| 16060000100340 | L16/dossiers | 16 | 16060000100339 | 16060000100339 | 1 | PA717161 | PM791583 |
| 16060000100346 | L16/dossiers | 16 | 16060000100345 | 16060000100345 | 1 | PA721210 | PM797331 |
| 16060000100353 | L16/dossiers | 16 | 16060000100352 | 16060000100352 | 1 | PA736188 | PM736289 |
| 16060000100354 | L16/dossiers | 16 | 16060000100352 | 16060000100352 | 2 | PA720634 | PM736312 |
| 16060000100361 | L16/dossiers | 16 | 16060000100360 | 16060000100360 | 1 | PA2774 | PM736307 |
| 16060000100368 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 1 | PA736195 | PM736357 |
| 16060000100369 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 2 | PA756685 | PM775777 |
| 16060000100370 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 3 | PA429886 | PM736385 |
| 16060000100371 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 4 | PA757676 | PM757692 |
| 16060000100372 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 5 | PA304082 | PM736354 |
| 16060000100373 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 6 | PA775172 | PM775474 |
| 16060000100374 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 7 | PA429894 | PM736364 |
| 16060000100375 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 8 | PA429836 | PM736345 |
| 16060000100376 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 9 | PA736173 | PM736369 |
| 16060000100377 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 10 | PA775246 | PM775532 |
| 16060000100378 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 11 | PA678263 | PM736330 |
| 16060000100379 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 12 | PA1978 | PM736337 |
| 16060000100380 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 13 | PA736243 | PM736413 |
| 16060000100381 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 14 | PA736175 | PM736344 |
| 16060000100382 | L16/dossiers | 16 | 16060000100367 | 16060000100367 | 15 | PA775296 | PM775596 |
| 16060000100392 | L16/dossiers | 16 | 16060000100391 | 16060000100391 | 1 | PA720092 | PM796857 |
| 16060000100408 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 1 | PA606375 | PM775602 |
| 16060000100409 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 2 | PA342564 | PM736388 |
| 16060000100410 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 3 | PA702993 | PM736362 |
| 16060000100411 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 4 | PA429855 | PM736425 |
| 16060000100412 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 5 | PA736219 | PM736387 |
| 16060000100413 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 6 | PA304002 | PM736326 |
| 16060000100414 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 7 | PA736199 | PM736284 |
| 16060000100415 | L16/dossiers | 16 | 16060000100407 | 16060000100407 | 8 | PA775186 | PM775484 |