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 |
|---|---|---|---|---|---|---|---|
| 17060000149351 | L17/dossiers | 17 | 17060000149350 | 17060000149350 | 1 | PA718884 | PM842420 |
| 17060000149358 | L17/dossiers | 17 | 17060000149357 | 17060000149357 | 1 | PA795808 | PM843644 |
| 17060000149365 | L17/dossiers | 17 | 17060000149364 | 17060000149364 | 1 | PA795820 | PM843713 |
| 17060000149372 | L17/dossiers | 17 | 17060000149371 | 17060000149371 | 1 | PA795820 | PM843713 |
| 17060000149379 | L17/dossiers | 17 | 17060000149378 | 17060000149378 | 1 | PA795430 | PM843602 |
| 17060000149386 | L17/dossiers | 17 | 17060000149385 | 17060000149385 | 1 | PA795010 | PM840354 |
| 17060000149393 | L17/dossiers | 17 | 17060000149392 | 17060000149392 | 1 | PA795820 | PM843713 |
| 17060000149400 | L17/dossiers | 17 | 17060000149399 | 17060000149399 | 1 | PA793948 | PM842615 |
| 17060000149407 | L17/dossiers | 17 | 17060000149406 | 17060000149406 | 1 | PA794166 | PM842924 |
| 17060000149414 | L17/dossiers | 17 | 17060000149413 | 17060000149413 | 1 | PA840685 | PM842354 |
| 17060000149421 | L17/dossiers | 17 | 17060000149420 | 17060000149420 | 1 | PA796010 | PM843743 |
| 17060000149431 | L17/dossiers | 17 | 17060000149430 | 17060000149430 | 1 | PA793174 | PM842384 |
| 17060000149438 | L17/dossiers | 17 | 17060000149437 | 17060000149437 | 1 | PA774954 | PM842843 |
| 17060000149445 | L17/dossiers | 17 | 17060000149444 | 17060000149444 | 1 | PA795982 | PM840432 |
| 17060000149452 | L17/dossiers | 17 | 17060000149451 | 17060000149451 | 1 | PA793796 | PM842723 |
| 17060000149456 | L17/dossiers | 17 | 17060000149455 | 17060000149455 | 1 | PA712014 | PM858454 |
| 17060000149473 | L17/dossiers | 17 | 17060000149472 | 17060000149472 | 1 | PA842271 | PM843776 |
| 17060000149490 | L17/dossiers | 17 | 17060000149489 | 17060000149489 | 1 | PA827964 | PM828652 |
| 17060000149491 | L17/dossiers | 17 | 17060000149489 | 17060000149489 | 2 | PA267340 | PM775731 |
| 17060000149501 | L17/dossiers | 17 | 17060000149500 | 17060000149500 | 1 | PA643210 | PM873637 |
| 17060000149509 | L17/dossiers | 17 | 17060000149508 | 17060000149508 | 1 | PA643210 | PM873637 |
| 17060000149528 | L17/dossiers | 17 | 17060000149527 | 17060000149527 | 1 | PA736235 | PM874830 |
| 17060000149538 | L17/dossiers | 17 | 17060000149537 | 17060000149537 | 1 | PA840955 | PM842573 |
| 17060000149557 | L17/dossiers | 17 | 17060000149556 | 17060000149556 | 1 | PA796062 | PM843668 |
| 17060000149564 | L17/dossiers | 17 | 17060000149563 | 17060000149563 | 1 | PA382672 | PM829681 |
| 17060000149571 | L17/dossiers | 17 | 17060000149570 | 17060000149570 | 1 | PA840983 | PM842597 |
| 17060000149582 | L17/dossiers | 17 | 17060000149581 | 17060000149581 | 1 | PA841183 | PM842786 |
| 17060000149586 | L17/dossiers | 17 | 17060000149585 | 17060000149585 | 1 | PA784534 | PM784544 |
| 17060000149593 | L17/dossiers | 17 | 17060000149592 | 17060000149592 | 1 | PA841769 | PM843323 |
| 17060000149600 | L17/dossiers | 17 | 17060000149599 | 17060000149599 | 1 | PA817211 | PM842600 |
| 17060000149607 | L17/dossiers | 17 | 17060000149606 | 17060000149606 | 1 | PA736229 | PM829923 |
| 17060000149614 | L17/dossiers | 17 | 17060000149613 | 17060000149613 | 1 | PA842271 | PM843776 |
| 17060000149628 | L17/dossiers | 17 | 17060000149627 | 17060000149627 | 1 | PA721270 | PM840438 |
| 17060000149634 | L17/dossiers | 17 | 17060000149633 | 17060000149633 | 1 | PA827988 | PM828788 |
| 17060000149641 | L17/dossiers | 17 | 17060000149640 | 17060000149640 | 1 | PA643210 | PM873637 |
| 17060000149648 | L17/dossiers | 17 | 17060000149647 | 17060000149647 | 1 | PA643210 | PM873637 |
| 17060000149655 | L17/dossiers | 17 | 17060000149654 | 17060000149654 | 1 | PA415446 | PM775783 |
| 17060000149662 | L17/dossiers | 17 | 17060000149661 | 17060000149661 | 1 | PA794570 | PM843137 |
| 17060000149675 | L17/dossiers | 17 | 17060000149674 | 17060000149674 | 1 | PA842279 | PM843779 |
| 17060000149679 | L17/dossiers | 17 | 17060000149678 | 17060000149678 | 1 | PA794686 | PM843080 |
| 17060000149686 | L17/dossiers | 17 | 17060000149685 | 17060000149685 | 1 | PA267780 | PM843395 |
| 17060000149693 | L17/dossiers | 17 | 17060000149692 | 17060000149692 | 1 | PA721486 | PM843614 |
| 17060000149700 | L17/dossiers | 17 | 17060000149699 | 17060000149699 | 1 | PA721486 | PM843614 |
| 17060000149707 | L17/dossiers | 17 | 17060000149706 | 17060000149706 | 1 | PA720092 | PM842948 |
| 17060000149714 | L17/dossiers | 17 | 17060000149713 | 17060000149713 | 1 | PA793948 | PM842615 |
| 17060000149721 | L17/dossiers | 17 | 17060000149720 | 17060000149720 | 1 | PA719930 | PM842870 |
| 17060000149728 | L17/dossiers | 17 | 17060000149727 | 17060000149727 | 1 | PA841431 | PM843017 |
| 17060000149735 | L17/dossiers | 17 | 17060000149734 | 17060000149734 | 1 | PA795664 | PM843569 |
| 17060000149742 | L17/dossiers | 17 | 17060000149741 | 17060000149741 | 1 | PA817211 | PM842600 |
| 17060000149749 | L17/dossiers | 17 | 17060000149748 | 17060000149748 | 1 | PA840657 | PM842333 |