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 |
|---|---|---|---|---|---|---|---|
| 17060000139447 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 72 | PA719578 | PM842618 |
| 17060000139448 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 73 | PA721062 | PM843740 |
| 17060000139449 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 74 | PA795240 | PM843785 |
| 17060000139450 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 75 | PA795876 | PM843725 |
| 17060000139451 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 76 | PA796018 | PM843425 |
| 17060000139452 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 77 | PA841845 | PM843407 |
| 17060000139453 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 78 | PA795982 | PM840432 |
| 17060000139454 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 79 | PA795466 | PM843443 |
| 17060000139455 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 80 | PA793744 | PM842696 |
| 17060000139456 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 81 | PA720952 | PM843755 |
| 17060000139457 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 82 | PA794106 | PM842885 |
| 17060000139458 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 83 | PA794166 | PM842924 |
| 17060000139459 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 84 | PA842299 | PM843791 |
| 17060000139460 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 85 | PA795164 | PM840444 |
| 17060000139461 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 86 | PA795596 | PM840456 |
| 17060000139465 | L17/dossiers | 17 | 17060000139464 | 17060000139464 | 1 | PA842001 | PM843554 |
| 17060000139473 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 1 | PA720892 | PM840420 |
| 17060000139474 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 2 | PA795228 | PM840447 |
| 17060000139475 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 3 | PA793262 | PM842438 |
| 17060000139476 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 4 | PA794906 | PM843284 |
| 17060000139477 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 5 | PA794138 | PM842909 |
| 17060000139478 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 6 | PA795588 | PM843557 |
| 17060000139479 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 7 | PA793780 | PM842714 |
| 17060000139480 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 8 | PA795084 | PM840369 |
| 17060000139481 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 9 | PA842105 | PM843626 |
| 17060000139482 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 10 | PA588884 | PM840450 |
| 17060000139483 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 11 | PA795362 | PM843587 |
| 17060000139484 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 12 | PA841657 | PM843224 |
| 17060000139485 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 13 | PA796106 | PM843383 |
| 17060000139486 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 14 | PA720430 | PM843092 |
| 17060000139487 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 15 | PA793772 | PM842708 |
| 17060000139488 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 16 | PA795616 | PM840462 |
| 17060000139489 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 17 | PA840997 | PM842612 |
| 17060000139490 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 18 | PA793444 | PM840270 |
| 17060000139491 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 19 | PA841885 | PM843446 |
| 17060000139492 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 20 | PA794938 | PM843308 |
| 17060000139493 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 21 | PA795318 | PM843689 |
| 17060000139494 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 22 | PA841023 | PM842645 |
| 17060000139495 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 23 | PA796090 | PM840372 |
| 17060000139496 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 24 | PA793912 | PM842795 |
| 17060000139497 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 25 | PA795868 | PM843722 |
| 17060000139498 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 26 | PA842187 | PM843704 |
| 17060000139499 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 27 | PA842037 | PM843578 |
| 17060000139500 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 28 | PA791812 | PM840384 |
| 17060000139501 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 29 | PA793736 | PM842693 |
| 17060000139502 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 30 | PA721202 | PM840435 |
| 17060000139503 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 31 | PA721210 | PM843677 |
| 17060000139504 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 32 | PA795136 | PM843353 |
| 17060000139505 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 33 | PA793452 | PM842453 |
| 17060000139506 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 34 | PA793464 | PM840273 |