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 |
|---|---|---|---|---|---|---|---|
| 15060000182081 | L15/dossiers | 15 | 15060000182080 | 15060000182080 | 1 | PA773441 | PM773491 |
| 15060000182082 | L15/dossiers | 15 | 15060000182080 | 15060000182080 | 2 | PA331481 | PM773459 |
| 15060000182083 | L15/dossiers | 15 | 15060000182080 | 15060000182080 | 3 | PA642788 | PM773495 |
| 15060000182084 | L15/dossiers | 15 | 15060000182080 | 15060000182080 | 4 | PA330357 | PM773447 |
| 15060000182186 | L15/dossiers | 15 | 15060000182185 | 15060000182185 | 1 | PA773441 | PM773491 |
| 15060000182193 | L15/dossiers | 15 | 15060000182192 | 15060000182192 | 1 | PA336316 | PM723406 |
| 15060000182200 | L15/dossiers | 15 | 15060000182199 | 15060000182199 | 1 | PA722030 | PM723454 |
| 15060000182201 | L15/dossiers | 15 | 15060000182199 | 15060000182199 | 2 | PA719024 | PM722536 |
| 15060000182226 | L15/dossiers | 15 | 15060000182225 | 15060000182225 | 1 | PA719448 | PM722666 |
| 15060000182250 | L15/dossiers | 15 | 15060000182249 | 15060000182249 | 1 | PA721194 | PM723200 |
| 15060000182257 | L15/dossiers | 15 | 15060000182256 | 15060000182256 | 1 | PA702052 | PM723172 |
| 15060000182258 | L15/dossiers | 15 | 15060000182256 | 15060000182256 | 2 | PA720334 | PM722932 |
| 15060000182267 | L15/dossiers | 15 | 15060000182266 | 15060000182266 | 1 | PA336316 | PM723406 |
| 15060000182274 | L15/dossiers | 15 | 15060000182273 | 15060000182273 | 1 | PA266788 | PM722914 |
| 15060000182281 | L15/dossiers | 15 | 15060000182280 | 15060000182280 | 1 | PA719436 | PM770316 |
| 15060000182294 | L15/dossiers | 15 | 15060000182293 | 15060000182293 | 1 | PA773441 | PM773491 |
| 15060000182295 | L15/dossiers | 15 | 15060000182293 | 15060000182293 | 2 | PA717159 | PM773461 |
| 15060000182296 | L15/dossiers | 15 | 15060000182293 | 15060000182293 | 3 | PA1872 | PM773455 |
| 15060000182318 | L15/dossiers | 15 | 15060000182317 | 15060000182317 | 1 | PA267355 | PM723524 |
| 15060000182327 | L15/dossiers | 15 | 15060000182326 | 15060000182326 | 1 | PA773441 | PM773491 |
| 15060000182409 | L15/dossiers | 15 | 15060000182408 | 15060000182408 | 1 | PA773441 | PM773491 |
| 15060000182410 | L15/dossiers | 15 | 15060000182408 | 15060000182408 | 2 | PA332 | PM773507 |
| 15060000182417 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 1 | PA304017 | PM775757 |
| 15060000182418 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 2 | PA736216 | PM736273 |
| 15060000182419 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 3 | PA736243 | PM736413 |
| 15060000182420 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 4 | PA736182 | PM736346 |
| 15060000182421 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 5 | PA775250 | PM775552 |
| 15060000182422 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 6 | PA736230 | PM736377 |
| 15060000182423 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 7 | PA775226 | PM775510 |
| 15060000182424 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 8 | PA775198 | PM775480 |
| 15060000182425 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 9 | PA331381 | PM775739 |
| 15060000182426 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 10 | PA758431 | PM758701 |
| 15060000182427 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 11 | PA267762 | PM736366 |
| 15060000182428 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 12 | PA736192 | PM736353 |
| 15060000182429 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 13 | PA703501 | PM775645 |
| 15060000182430 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 14 | PA703532 | PM775699 |
| 15060000182431 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 15 | PA736200 | PM736285 |
| 15060000182432 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 16 | PA775286 | PM775588 |
| 15060000182433 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 17 | PA736166 | PM775765 |
| 15060000182434 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 18 | PA736167 | PM736327 |
| 15060000182435 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 19 | PA775302 | PM775598 |
| 15060000182436 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 20 | PA775216 | PM775522 |
| 15060000182437 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 21 | PA429874 | PM736314 |
| 15060000182438 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 22 | PA703512 | PM775665 |
| 15060000182439 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 23 | PA703511 | PM775685 |
| 15060000182440 | L15/dossiers | 15 | 15060000182416 | 15060000182416 | 24 | PA429855 | PM736425 |
| 15060000182458 | L15/dossiers | 15 | 15060000182457 | 15060000182457 | 1 | PA718884 | PM722488 |
| 15060000182465 | L15/dossiers | 15 | 15060000182464 | 15060000182464 | 1 | PA719676 | PM722728 |
| 15060000182472 | L15/dossiers | 15 | 15060000182471 | 15060000182471 | 1 | PA721932 | PM734586 |
| 15060000182479 | L15/dossiers | 15 | 15060000182478 | 15060000182478 | 1 | PA736214 | PM736290 |