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 |
|---|---|---|---|---|---|---|---|
| 16060000092770 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 44 | PA2197 | PM703640 |
| 16060000092771 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 45 | PA703513 | PM703621 |
| 16060000092772 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 46 | PA1344 | PM736383 |
| 16060000092773 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 47 | PA703521 | PM703544 |
| 16060000092774 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 48 | PA736205 | PM736288 |
| 16060000092775 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 49 | PA758431 | PM758701 |
| 16060000092776 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 50 | PA736166 | PM736435 |
| 16060000092777 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 51 | PA736167 | PM736327 |
| 16060000092778 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 52 | PA415462 | PM703628 |
| 16060000092801 | L16/dossiers | 16 | 16060000092800 | 16060000092800 | 1 | PA2042 | PM775815 |
| 16060000092824 | L16/dossiers | 16 | 16060000092823 | 16060000092823 | 1 | PA703513 | PM775671 |
| 16060000092825 | L16/dossiers | 16 | 16060000092823 | 16060000092823 | 2 | PA607489 | PM736390 |
| 16060000092826 | L16/dossiers | 16 | 16060000092823 | 16060000092823 | 3 | PA736248 | PM736269 |
| 16060000092827 | L16/dossiers | 16 | 16060000092823 | 16060000092823 | 4 | PA415446 | PM775783 |
| 16060000092881 | L16/dossiers | 16 | 16060000092880 | 16060000092880 | 1 | PA736196 | PM736370 |
| 16060000092904 | L16/dossiers | 16 | 16060000092903 | 16060000092903 | 1 | PA703520 | PM775705 |
| 16060000092905 | L16/dossiers | 16 | 16060000092903 | 16060000092903 | 2 | PA736213 | PM775791 |
| 16060000092906 | L16/dossiers | 16 | 16060000092903 | 16060000092903 | 3 | PA720634 | PM736312 |
| 16060000092907 | L16/dossiers | 16 | 16060000092903 | 16060000092903 | 4 | PA2538 | PM775801 |
| 16060000092931 | L16/dossiers | 16 | 16060000092930 | 16060000092930 | 1 | PA773441 | PM773491 |
| 16060000092932 | L16/dossiers | 16 | 16060000092930 | 16060000092930 | 2 | PA1872 | PM773455 |
| 16060000092962 | L16/dossiers | 16 | 16060000092961 | 16060000092961 | 1 | PA736209 | PM736400 |
| 16060000092985 | L16/dossiers | 16 | 16060000092984 | 16060000092984 | 1 | PA736183 | PM736405 |
| 16060000093008 | L16/dossiers | 16 | 16060000093007 | 16060000093007 | 1 | PA722162 | PM723490 |
| 16060000093040 | L16/dossiers | 16 | 16060000093039 | 16060000093039 | 1 | PA722022 | PM723452 |
| 16060000093104 | L16/dossiers | 16 | 16060000093103 | 16060000093103 | 1 | PA382672 | PM736263 |
| 16060000093127 | L16/dossiers | 16 | 16060000093126 | 16060000093126 | 1 | PA773441 | PM773491 |
| 16060000093128 | L16/dossiers | 16 | 16060000093126 | 16060000093126 | 2 | PA609520 | PM773503 |
| 16060000093265 | L16/dossiers | 16 | 16060000093264 | 16060000093264 | 1 | PA736228 | PM736380 |
| 16060000093288 | L16/dossiers | 16 | 16060000093287 | 16060000093287 | 1 | PA703530 | PM775689 |
| 16060000093312 | L16/dossiers | 16 | 16060000093311 | 16060000093311 | 1 | PA775250 | PM775552 |
| 16060000093353 | L16/dossiers | 16 | 16060000093352 | 16060000093352 | 1 | PA303997 | PM775743 |
| 16060000093377 | L16/dossiers | 16 | 16060000093376 | 16060000093376 | 1 | PA736226 | PM736280 |
| 16060000093401 | L16/dossiers | 16 | 16060000093400 | 16060000093400 | 1 | PA773441 | PM773491 |
| 16060000093460 | L16/dossiers | 16 | 16060000093459 | 16060000093459 | 1 | PA2538 | PM775801 |
| 16060000093484 | L16/dossiers | 16 | 16060000093483 | 16060000093483 | 1 | PA718876 | PM722486 |
| 16060000093540 | L16/dossiers | 16 | 16060000093539 | 16060000093539 | 1 | PA773441 | PM773491 |
| 16060000093576 | L16/dossiers | 16 | 16060000093575 | 16060000093575 | 1 | PA773441 | PM773491 |
| 16060000093577 | L16/dossiers | 16 | 16060000093575 | 16060000093575 | 2 | PA1872 | PM773455 |
| 16060000093607 | L16/dossiers | 16 | 16060000093606 | 16060000093606 | 1 | PA773441 | PM773491 |
| 16060000093645 | L16/dossiers | 16 | 16060000093644 | 16060000093644 | 1 | PA429895 | PM736262 |
| 16060000093669 | L16/dossiers | 16 | 16060000093668 | 16060000093668 | 1 | PA773441 | PM773491 |
| 16060000093670 | L16/dossiers | 16 | 16060000093668 | 16060000093668 | 2 | PA1872 | PM773455 |
| 16060000093707 | L16/dossiers | 16 | 16060000093706 | 16060000093706 | 1 | PA773441 | PM773491 |
| 16060000093708 | L16/dossiers | 16 | 16060000093706 | 16060000093706 | 2 | PA1872 | PM773455 |
| 16060000093741 | L16/dossiers | 16 | 16060000093740 | 16060000093740 | 1 | PA2774 | PM736307 |
| 16060000093742 | L16/dossiers | 16 | 16060000093740 | 16060000093740 | 2 | PA702993 | PM736362 |
| 16060000093743 | L16/dossiers | 16 | 16060000093740 | 16060000093740 | 3 | PA736219 | PM736387 |
| 16060000093744 | L16/dossiers | 16 | 16060000093740 | 16060000093740 | 4 | PA736199 | PM736284 |
| 16060000093745 | L16/dossiers | 16 | 16060000093740 | 16060000093740 | 5 | PA415488 | PM775641 |