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 |
|---|---|---|---|---|---|---|---|
| 15060000156467 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 2 | PA304082 | PM736354 |
| 15060000156468 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 3 | PA429891 | PM736329 |
| 15060000156469 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 4 | PA304071 | PM703676 |
| 15060000156470 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 5 | PA429894 | PM736364 |
| 15060000156471 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 6 | PA429886 | PM736385 |
| 15060000156472 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 7 | PA736195 | PM736357 |
| 15060000156473 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 8 | PA736177 | PM736318 |
| 15060000156474 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 9 | PA736173 | PM736369 |
| 15060000156475 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 10 | PA678263 | PM736330 |
| 15060000156476 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 11 | PA736243 | PM736413 |
| 15060000156477 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 12 | PA703499 | PM703641 |
| 15060000156478 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 13 | PA736175 | PM736344 |
| 15060000156485 | L15/dossiers | 15 | 15060000156484 | 15060000156484 | 1 | PA382672 | PM736263 |
| 15060000156492 | L15/dossiers | 15 | 15060000156491 | 15060000156491 | 1 | PA944 | PM703562 |
| 15060000156499 | L15/dossiers | 15 | 15060000156498 | 15060000156498 | 1 | PA429895 | PM736262 |
| 15060000156500 | L15/dossiers | 15 | 15060000156498 | 15060000156498 | 2 | PA736235 | PM736426 |
| 15060000156507 | L15/dossiers | 15 | 15060000156506 | 15060000156506 | 1 | PA2116 | PM736339 |
| 15060000156508 | L15/dossiers | 15 | 15060000156506 | 15060000156506 | 2 | PA736236 | PM736341 |
| 15060000156509 | L15/dossiers | 15 | 15060000156506 | 15060000156506 | 3 | PA736204 | PM736338 |
| 15060000156516 | L15/dossiers | 15 | 15060000156515 | 15060000156515 | 1 | PA415456 | PM736433 |
| 15060000156517 | L15/dossiers | 15 | 15060000156515 | 15060000156515 | 2 | PA415456 | PM736433 |
| 15060000156524 | L15/dossiers | 15 | 15060000156523 | 15060000156523 | 1 | PA404656 | PM736328 |
| 15060000156531 | L15/dossiers | 15 | 15060000156530 | 15060000156530 | 1 | PA2116 | PM736339 |
| 15060000156538 | L15/dossiers | 15 | 15060000156537 | 15060000156537 | 1 | PA343988 | PM736310 |
| 15060000156545 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 1 | PA703501 | PM703629 |
| 15060000156546 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 2 | PA415446 | PM703678 |
| 15060000156547 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 3 | PA569 | PM703710 |
| 15060000156548 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 4 | PA736230 | PM736377 |
| 15060000156549 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 5 | PA736223 | PM736368 |
| 15060000156550 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 6 | PA1122 | PM736304 |
| 15060000156551 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 7 | PA227098 | PM736321 |
| 15060000156552 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 8 | PA341381 | PM703618 |
| 15060000156553 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 9 | PA703514 | PM703585 |
| 15060000156554 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 10 | PA703532 | PM703568 |
| 15060000156555 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 11 | PA266795 | PM703637 |
| 15060000156556 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 12 | PA227029 | PM736306 |
| 15060000156557 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 13 | PA736222 | PM736436 |
| 15060000156558 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 14 | PA736182 | PM736346 |
| 15060000156559 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 15 | PA429869 | PM736350 |
| 15060000156560 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 16 | PA703480 | PM703624 |
| 15060000156561 | L15/dossiers | 15 | 15060000156544 | 15060000156544 | 17 | PA706108 | PM736256 |
| 15060000156568 | L15/dossiers | 15 | 15060000156567 | 15060000156567 | 1 | PA267762 | PM736366 |
| 15060000156575 | L15/dossiers | 15 | 15060000156574 | 15060000156574 | 1 | PA2116 | PM736339 |
| 15060000156582 | L15/dossiers | 15 | 15060000156581 | 15060000156581 | 1 | PA2116 | PM736339 |
| 15060000156589 | L15/dossiers | 15 | 15060000156588 | 15060000156588 | 1 | PA736235 | PM736426 |
| 15060000156596 | L15/dossiers | 15 | 15060000156595 | 15060000156595 | 1 | PA2116 | PM736339 |
| 15060000156597 | L15/dossiers | 15 | 15060000156595 | 15060000156595 | 2 | PA736236 | PM736341 |
| 15060000156598 | L15/dossiers | 15 | 15060000156595 | 15060000156595 | 3 | PA736203 | PM736432 |
| 15060000156605 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 1 | PA404656 | PM736328 |
| 15060000156606 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 2 | PA429854 | PM736335 |