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 |
|---|---|---|---|---|---|---|---|
| 14060000093280 | L14/dossiers | 14 | 14060000093279 | 14060000093279 | 1 | PA608186 | PM645202 |
| 14060000093298 | L14/dossiers | 14 | 14060000093297 | 14060000093297 | 1 | PA328 | PM653228 |
| 14060000093299 | L14/dossiers | 14 | 14060000093297 | 14060000093297 | 2 | PA1268 | PM653525 |
| 14060000093310 | L14/dossiers | 14 | 14060000093309 | 14060000093309 | 1 | PA267204 | PM645551 |
| 14060000093317 | L14/dossiers | 14 | 14060000093316 | 14060000093316 | 1 | PA328 | PM653228 |
| 14060000093324 | L14/dossiers | 14 | 14060000093323 | 14060000093323 | 1 | PA340755 | PM645506 |
| 14060000093334 | L14/dossiers | 14 | 14060000093333 | 14060000093333 | 1 | PA2796 | PM645520 |
| 14060000093341 | L14/dossiers | 14 | 14060000093340 | 14060000093340 | 1 | PA267622 | PM702957 |
| 14060000093372 | L14/dossiers | 14 | 14060000093371 | 14060000093371 | 1 | PA2011 | PM645434 |
| 14060000093379 | L14/dossiers | 14 | 14060000093378 | 14060000093378 | 1 | PA266797 | PM645338 |
| 14060000093386 | L14/dossiers | 14 | 14060000093385 | 14060000093385 | 1 | PA606910 | PM645547 |
| 14060000093393 | L14/dossiers | 14 | 14060000093392 | 14060000093392 | 1 | PA1661 | PM645181 |
| 14060000093400 | L14/dossiers | 14 | 14060000093399 | 14060000093399 | 1 | PA267492 | PM645465 |
| 14060000093407 | L14/dossiers | 14 | 14060000093406 | 14060000093406 | 1 | PA267080 | PM645531 |
| 14060000093414 | L14/dossiers | 14 | 14060000093413 | 14060000093413 | 1 | PA332747 | PM645155 |
| 14060000093421 | L14/dossiers | 14 | 14060000093420 | 14060000093420 | 1 | PA1874 | PM645474 |
| 14060000093428 | L14/dossiers | 14 | 14060000093427 | 14060000093427 | 1 | PA330240 | PM645425 |
| 14060000093435 | L14/dossiers | 14 | 14060000093434 | 14060000093434 | 1 | PA550 | PM703612 |
| 14060000093454 | L14/dossiers | 14 | 14060000093453 | 14060000093453 | 1 | PA2083 | PM645105 |
| 14060000093461 | L14/dossiers | 14 | 14060000093460 | 14060000093460 | 1 | PA1206 | PM645054 |
| 14060000093468 | L14/dossiers | 14 | 14060000093467 | 14060000093467 | 1 | PA267457 | PM687216 |
| 14060000093475 | L14/dossiers | 14 | 14060000093474 | 14060000093474 | 1 | PA417099 | PM645346 |
| 14060000093485 | L14/dossiers | 14 | 14060000093484 | 14060000093484 | 1 | PA2876 | PM645355 |
| 14060000093492 | L14/dossiers | 14 | 14060000093491 | 14060000093491 | 1 | PA346886 | PM695110 |
| 14060000093496 | L14/dossiers | 14 | 14060000093495 | 14060000093495 | 1 | PA330788 | PM645510 |
| 14060000093506 | L14/dossiers | 14 | 14060000093505 | 14060000093505 | 1 | PA713448 | PM713451 |
| 14060000093513 | L14/dossiers | 14 | 14060000093512 | 14060000093512 | 1 | PA267622 | PM702957 |
| 14060000093543 | L14/dossiers | 14 | 14060000093542 | 14060000093542 | 1 | PA2713 | PM645148 |
| 14060000093550 | L14/dossiers | 14 | 14060000093549 | 14060000093549 | 1 | PA267622 | PM702957 |
| 14060000093551 | L14/dossiers | 14 | 14060000093549 | 14060000093549 | 2 | PA2825 | PM702962 |
| 14060000093558 | L14/dossiers | 14 | 14060000093557 | 14060000093557 | 1 | PA609016 | PM645074 |
| 14060000093565 | L14/dossiers | 14 | 14060000093564 | 14060000093564 | 1 | PA267506 | PM645270 |
| 14060000093572 | L14/dossiers | 14 | 14060000093571 | 14060000093571 | 1 | PA2073 | PM645207 |
| 14060000093579 | L14/dossiers | 14 | 14060000093578 | 14060000093578 | 1 | PA2952 | PM645464 |
| 14060000093586 | L14/dossiers | 14 | 14060000093585 | 14060000093585 | 1 | PA346886 | PM695110 |
| 14060000093593 | L14/dossiers | 14 | 14060000093592 | 14060000093592 | 1 | PA2713 | PM645148 |
| 14060000093603 | L14/dossiers | 14 | 14060000093602 | 14060000093602 | 1 | PA267622 | PM702957 |
| 14060000093604 | L14/dossiers | 14 | 14060000093602 | 14060000093602 | 2 | PA2825 | PM711565 |
| 14060000093611 | L14/dossiers | 14 | 14060000093610 | 14060000093610 | 1 | PA2236 | PM645149 |
| 14060000093618 | L14/dossiers | 14 | 14060000093617 | 14060000093617 | 1 | PA785 | PM715797 |
| 14060000093627 | L14/dossiers | 14 | 14060000093626 | 14060000093626 | 1 | PA1521 | PM645078 |
| 14060000093644 | L14/dossiers | 14 | 14060000093643 | 14060000093643 | 1 | PA608186 | PM645202 |
| 14060000093654 | L14/dossiers | 14 | 14060000093653 | 14060000093653 | 1 | PA441 | PM645279 |
| 14060000093661 | L14/dossiers | 14 | 14060000093660 | 14060000093660 | 1 | PA267622 | PM702957 |
| 14060000093668 | L14/dossiers | 14 | 14060000093667 | 14060000093667 | 1 | PA785 | PM715797 |
| 14060000093675 | L14/dossiers | 14 | 14060000093674 | 14060000093674 | 1 | PA267622 | PM702957 |
| 14060000093715 | L14/dossiers | 14 | 14060000093714 | 14060000093714 | 1 | PA230 | PM645553 |
| 14060000093722 | L14/dossiers | 14 | 14060000093721 | 14060000093721 | 1 | PA267622 | PM702957 |
| 14060000093784 | L14/dossiers | 14 | 14060000093783 | 14060000093783 | 1 | PA346886 | PM695110 |
| 14060000093791 | L14/dossiers | 14 | 14060000093790 | 14060000093790 | 1 | PA563 | PM645307 |