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 |
|---|---|---|---|---|---|---|---|
| 16060000112513 | L16/dossiers | 16 | 16060000112511 | 16060000112511 | 2 | PA2074 | PM775677 |
| 16060000112514 | L16/dossiers | 16 | 16060000112511 | 16060000112511 | 3 | PA703511 | PM775685 |
| 16060000112515 | L16/dossiers | 16 | 16060000112511 | 16060000112511 | 4 | PA766947 | PM775799 |
| 16060000112516 | L16/dossiers | 16 | 16060000112511 | 16060000112511 | 5 | PA590034 | PM775606 |
| 16060000112523 | L16/dossiers | 16 | 16060000112522 | 16060000112522 | 1 | PA718784 | PM796266 |
| 16060000112530 | L16/dossiers | 16 | 16060000112529 | 16060000112529 | 1 | PA794038 | PM796668 |
| 16060000112531 | L16/dossiers | 16 | 16060000112529 | 16060000112529 | 2 | PA330240 | PM796155 |
| 16060000112532 | L16/dossiers | 16 | 16060000112529 | 16060000112529 | 3 | PA606098 | PM796449 |
| 16060000112533 | L16/dossiers | 16 | 16060000112529 | 16060000112529 | 4 | PA605991 | PM796428 |
| 16060000112537 | L16/dossiers | 16 | 16060000112536 | 16060000112536 | 1 | PA721486 | PM797517 |
| 16060000112544 | L16/dossiers | 16 | 16060000112543 | 16060000112543 | 1 | PA1206 | PM797637 |
| 16060000112551 | L16/dossiers | 16 | 16060000112550 | 16060000112550 | 1 | PA2116 | PM736339 |
| 16060000112558 | L16/dossiers | 16 | 16060000112557 | 16060000112557 | 1 | PA793246 | PM796227 |
| 16060000112565 | L16/dossiers | 16 | 16060000112564 | 16060000112564 | 1 | PA719100 | PM796407 |
| 16060000112572 | L16/dossiers | 16 | 16060000112571 | 16060000112571 | 1 | PA1327 | PM796632 |
| 16060000112579 | L16/dossiers | 16 | 16060000112578 | 16060000112578 | 1 | PA330909 | PM796314 |
| 16060000112589 | L16/dossiers | 16 | 16060000112588 | 16060000112588 | 1 | PA794562 | PM796995 |
| 16060000112596 | L16/dossiers | 16 | 16060000112595 | 16060000112595 | 1 | PA722142 | PM797673 |
| 16060000112603 | L16/dossiers | 16 | 16060000112602 | 16060000112602 | 1 | PA2116 | PM736339 |
| 16060000112610 | L16/dossiers | 16 | 16060000112609 | 16060000112609 | 1 | PA346054 | PM797679 |
| 16060000112626 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 1 | PA756685 | PM775777 |
| 16060000112627 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 2 | PA775172 | PM775474 |
| 16060000112628 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 3 | PA736243 | PM736413 |
| 16060000112629 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 4 | PA757676 | PM757692 |
| 16060000112630 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 5 | PA304082 | PM736354 |
| 16060000112631 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 6 | PA429894 | PM736364 |
| 16060000112632 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 7 | PA429836 | PM736345 |
| 16060000112633 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 8 | PA429886 | PM736385 |
| 16060000112634 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 9 | PA736195 | PM736357 |
| 16060000112635 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 10 | PA736173 | PM736369 |
| 16060000112636 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 11 | PA775246 | PM775532 |
| 16060000112637 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 12 | PA678263 | PM736330 |
| 16060000112638 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 13 | PA1978 | PM736337 |
| 16060000112639 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 14 | PA736175 | PM736344 |
| 16060000112640 | L16/dossiers | 16 | 16060000112625 | 16060000112625 | 15 | PA775296 | PM775596 |
| 16060000112671 | L16/dossiers | 16 | 16060000112670 | 16060000112670 | 1 | PA795552 | PM797547 |
| 16060000112678 | L16/dossiers | 16 | 16060000112677 | 16060000112677 | 1 | PA793330 | PM796263 |
| 16060000112685 | L16/dossiers | 16 | 16060000112684 | 16060000112684 | 1 | PA720692 | PM796986 |
| 16060000112692 | L16/dossiers | 16 | 16060000112691 | 16060000112691 | 1 | PA642847 | PM796872 |
| 16060000112699 | L16/dossiers | 16 | 16060000112698 | 16060000112698 | 1 | PA793672 | PM796473 |
| 16060000112706 | L16/dossiers | 16 | 16060000112705 | 16060000112705 | 1 | PA793342 | PM796269 |
| 16060000112713 | L16/dossiers | 16 | 16060000112712 | 16060000112712 | 1 | PA795596 | PM797580 |
| 16060000112720 | L16/dossiers | 16 | 16060000112719 | 16060000112719 | 1 | PA794538 | PM796977 |
| 16060000112727 | L16/dossiers | 16 | 16060000112726 | 16060000112726 | 1 | PA795884 | PM797733 |
| 16060000112772 | L16/dossiers | 16 | 16060000112771 | 16060000112771 | 1 | PA794178 | PM796755 |
| 16060000112779 | L16/dossiers | 16 | 16060000112778 | 16060000112778 | 1 | PA608016 | PM797100 |
| 16060000112786 | L16/dossiers | 16 | 16060000112785 | 16060000112785 | 1 | PA794670 | PM797049 |
| 16060000112793 | L16/dossiers | 16 | 16060000112792 | 16060000112792 | 1 | PA720092 | PM796857 |
| 16060000112800 | L16/dossiers | 16 | 16060000112799 | 16060000112799 | 1 | PA642847 | PM796872 |
| 16060000112807 | L16/dossiers | 16 | 16060000112806 | 16060000112806 | 1 | PA720286 | PM796878 |