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 |
|---|---|---|---|---|---|---|---|
| 15060000165353 | L15/dossiers | 15 | 15060000165322 | 15060000165322 | 31 | PA736188 | PM736289 |
| 15060000165354 | L15/dossiers | 15 | 15060000165322 | 15060000165322 | 32 | PA711156 | PM736319 |
| 15060000165361 | L15/dossiers | 15 | 15060000165360 | 15060000165360 | 1 | PA304082 | PM736354 |
| 15060000165362 | L15/dossiers | 15 | 15060000165360 | 15060000165360 | 2 | PA736175 | PM736344 |
| 15060000165363 | L15/dossiers | 15 | 15060000165360 | 15060000165360 | 3 | PA429894 | PM736364 |
| 15060000165364 | L15/dossiers | 15 | 15060000165360 | 15060000165360 | 4 | PA736173 | PM736369 |
| 15060000165371 | L15/dossiers | 15 | 15060000165370 | 15060000165370 | 1 | PA712015 | PM722448 |
| 15060000165378 | L15/dossiers | 15 | 15060000165377 | 15060000165377 | 1 | PA720014 | PM722834 |
| 15060000165385 | L15/dossiers | 15 | 15060000165384 | 15060000165384 | 1 | PA721888 | PM723412 |
| 15060000165392 | L15/dossiers | 15 | 15060000165391 | 15060000165391 | 1 | PA345619 | PM725692 |
| 15060000165393 | L15/dossiers | 15 | 15060000165391 | 15060000165391 | 2 | PA331481 | PM730094 |
| 15060000165394 | L15/dossiers | 15 | 15060000165391 | 15060000165391 | 3 | PA607846 | PM730066 |
| 15060000165459 | L15/dossiers | 15 | 15060000165458 | 15060000165458 | 1 | PA345619 | PM725692 |
| 15060000165460 | L15/dossiers | 15 | 15060000165458 | 15060000165458 | 2 | PA642788 | PM770473 |
| 15060000165539 | L15/dossiers | 15 | 15060000165538 | 15060000165538 | 1 | PA720892 | PM723106 |
| 15060000165546 | L15/dossiers | 15 | 15060000165545 | 15060000165545 | 1 | PA703491 | PM703634 |
| 15060000165547 | L15/dossiers | 15 | 15060000165545 | 15060000165545 | 2 | PA702993 | PM736362 |
| 15060000165554 | L15/dossiers | 15 | 15060000165553 | 15060000165553 | 1 | PA266788 | PM722914 |
| 15060000165561 | L15/dossiers | 15 | 15060000165560 | 15060000165560 | 1 | PA332614 | PM722812 |
| 15060000165571 | L15/dossiers | 15 | 15060000165570 | 15060000165570 | 1 | PA721270 | PM723220 |
| 15060000165578 | L15/dossiers | 15 | 15060000165577 | 15060000165577 | 1 | PA721888 | PM723412 |
| 15060000165588 | L15/dossiers | 15 | 15060000165587 | 15060000165587 | 1 | PA267318 | PM723260 |
| 15060000165602 | L15/dossiers | 15 | 15060000165601 | 15060000165601 | 1 | PA304000 | PM703599 |
| 15060000165603 | L15/dossiers | 15 | 15060000165601 | 15060000165601 | 2 | PA703513 | PM703621 |
| 15060000165610 | L15/dossiers | 15 | 15060000165609 | 15060000165609 | 1 | PA736228 | PM736380 |
| 15060000165617 | L15/dossiers | 15 | 15060000165616 | 15060000165616 | 1 | PA721542 | PM723308 |
| 15060000165673 | L15/dossiers | 15 | 15060000165672 | 15060000165672 | 1 | PA720480 | PM722976 |
| 15060000165681 | L15/dossiers | 15 | 15060000165680 | 15060000165680 | 1 | PA429835 | PM736397 |
| 15060000165688 | L15/dossiers | 15 | 15060000165687 | 15060000165687 | 1 | PA720038 | PM722840 |
| 15060000165715 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 1 | PA736167 | PM736327 |
| 15060000165716 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 2 | PA429889 | PM736313 |
| 15060000165717 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 3 | PA702993 | PM736362 |
| 15060000165718 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 4 | PA736225 | PM736334 |
| 15060000165719 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 5 | PA736191 | PM736336 |
| 15060000165720 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 6 | PA342564 | PM736388 |
| 15060000165721 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 7 | PA415453 | PM703691 |
| 15060000165722 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 8 | PA736241 | PM736300 |
| 15060000165723 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 9 | PA429844 | PM736276 |
| 15060000165724 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 10 | PA703508 | PM703601 |
| 15060000165725 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 11 | PA736187 | PM736365 |
| 15060000165726 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 12 | PA766947 | PM766951 |
| 15060000165727 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 13 | PA703538 | PM703698 |
| 15060000165728 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 14 | PA703512 | PM703575 |
| 15060000165729 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 15 | PA703511 | PM703635 |
| 15060000165730 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 16 | PA268048 | PM736422 |
| 15060000165731 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 17 | PA736162 | PM736320 |
| 15060000165732 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 18 | PA2074 | PM703673 |
| 15060000165733 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 19 | PA415475 | PM703584 |
| 15060000165734 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 20 | PA429860 | PM736398 |
| 15060000165735 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 21 | PA429867 | PM736298 |