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 |
|---|---|---|---|---|---|---|---|
| 16060000105516 | L16/dossiers | 16 | 16060000105515 | 16060000105515 | 1 | PA267429 | PM796722 |
| 16060000105517 | L16/dossiers | 16 | 16060000105515 | 16060000105515 | 2 | PA421348 | PM797544 |
| 16060000105524 | L16/dossiers | 16 | 16060000105523 | 16060000105523 | 1 | PA717161 | PM791583 |
| 16060000105605 | L16/dossiers | 16 | 16060000105604 | 16060000105604 | 1 | PA775284 | PM775590 |
| 16060000105606 | L16/dossiers | 16 | 16060000105604 | 16060000105604 | 2 | PA775204 | PM775508 |
| 16060000105613 | L16/dossiers | 16 | 16060000105612 | 16060000105612 | 1 | PA775284 | PM775590 |
| 16060000105614 | L16/dossiers | 16 | 16060000105612 | 16060000105612 | 2 | PA775204 | PM775508 |
| 16060000105621 | L16/dossiers | 16 | 16060000105620 | 16060000105620 | 1 | PA775284 | PM775590 |
| 16060000105622 | L16/dossiers | 16 | 16060000105620 | 16060000105620 | 2 | PA775204 | PM775508 |
| 16060000105633 | L16/dossiers | 16 | 16060000105632 | 16060000105632 | 1 | PA703513 | PM775671 |
| 16060000105640 | L16/dossiers | 16 | 16060000105639 | 16060000105639 | 1 | PA719318 | PM796470 |
| 16060000105644 | L16/dossiers | 16 | 16060000105643 | 16060000105643 | 1 | PA793664 | PM796467 |
| 16060000105651 | L16/dossiers | 16 | 16060000105650 | 16060000105650 | 1 | PA2116 | PM736339 |
| 16060000105658 | L16/dossiers | 16 | 16060000105657 | 16060000105657 | 1 | PA330684 | PM775859 |
| 16060000105665 | L16/dossiers | 16 | 16060000105664 | 16060000105664 | 1 | PA794038 | PM796668 |
| 16060000105672 | L16/dossiers | 16 | 16060000105671 | 16060000105671 | 1 | PA309643 | PM797403 |
| 16060000105679 | L16/dossiers | 16 | 16060000105678 | 16060000105678 | 1 | PA720092 | PM796857 |
| 16060000105686 | L16/dossiers | 16 | 16060000105685 | 16060000105685 | 1 | PA736196 | PM736370 |
| 16060000105687 | L16/dossiers | 16 | 16060000105685 | 16060000105685 | 2 | PA267762 | PM736366 |
| 16060000105694 | L16/dossiers | 16 | 16060000105693 | 16060000105693 | 1 | PA775248 | PM775554 |
| 16060000105701 | L16/dossiers | 16 | 16060000105700 | 16060000105700 | 1 | PA429832 | PM736408 |
| 16060000105708 | L16/dossiers | 16 | 16060000105707 | 16060000105707 | 1 | PA720386 | PM796908 |
| 16060000105715 | L16/dossiers | 16 | 16060000105714 | 16060000105714 | 1 | PA795974 | PM797784 |
| 16060000105722 | L16/dossiers | 16 | 16060000105721 | 16060000105721 | 1 | PA719318 | PM796470 |
| 16060000105729 | L16/dossiers | 16 | 16060000105728 | 16060000105728 | 1 | PA720092 | PM796857 |
| 16060000105736 | L16/dossiers | 16 | 16060000105735 | 16060000105735 | 1 | PA720092 | PM796857 |
| 16060000105743 | L16/dossiers | 16 | 16060000105742 | 16060000105742 | 1 | PA794410 | PM796911 |
| 16060000105750 | L16/dossiers | 16 | 16060000105749 | 16060000105749 | 1 | PA794946 | PM797205 |
| 16060000105757 | L16/dossiers | 16 | 16060000105756 | 16060000105756 | 1 | PA794522 | PM796971 |
| 16060000105764 | L16/dossiers | 16 | 16060000105763 | 16060000105763 | 1 | PA794946 | PM797205 |
| 16060000105771 | L16/dossiers | 16 | 16060000105770 | 16060000105770 | 1 | PA736233 | PM736411 |
| 16060000105787 | L16/dossiers | 16 | 16060000105786 | 16060000105786 | 1 | PA736216 | PM736273 |
| 16060000105805 | L16/dossiers | 16 | 16060000105804 | 16060000105804 | 1 | PA793948 | PM796617 |
| 16060000105833 | L16/dossiers | 16 | 16060000105832 | 16060000105832 | 1 | PA774954 | PM796797 |
| 16060000105837 | L16/dossiers | 16 | 16060000105836 | 16060000105836 | 1 | PA642847 | PM796872 |
| 16060000105844 | L16/dossiers | 16 | 16060000105843 | 16060000105843 | 1 | PA721314 | PM797151 |
| 16060000105851 | L16/dossiers | 16 | 16060000105850 | 16060000105850 | 1 | PA720014 | PM796863 |
| 16060000105858 | L16/dossiers | 16 | 16060000105857 | 16060000105857 | 1 | PA718850 | PM796203 |
| 16060000105865 | L16/dossiers | 16 | 16060000105864 | 16060000105864 | 1 | PA793548 | PM796398 |
| 16060000105872 | L16/dossiers | 16 | 16060000105871 | 16060000105871 | 1 | PA267762 | PM736366 |
| 16060000105879 | L16/dossiers | 16 | 16060000105878 | 16060000105878 | 1 | PA2116 | PM736339 |
| 16060000105886 | L16/dossiers | 16 | 16060000105885 | 16060000105885 | 1 | PA719922 | PM796767 |
| 16060000105905 | L16/dossiers | 16 | 16060000105904 | 16060000105904 | 1 | PA794854 | PM797163 |
| 16060000105912 | L16/dossiers | 16 | 16060000105911 | 16060000105911 | 1 | PA795552 | PM797547 |
| 16060000105919 | L16/dossiers | 16 | 16060000105918 | 16060000105918 | 1 | PA342240 | PM796707 |
| 16060000105926 | L16/dossiers | 16 | 16060000105925 | 16060000105925 | 1 | PA775206 | PM775506 |
| 16060000105927 | L16/dossiers | 16 | 16060000105925 | 16060000105925 | 2 | PA736219 | PM736387 |
| 16060000105928 | L16/dossiers | 16 | 16060000105925 | 16060000105925 | 3 | PA775294 | PM775580 |
| 16060000105929 | L16/dossiers | 16 | 16060000105925 | 16060000105925 | 4 | PA605888 | PM775604 |
| 16060000105930 | L16/dossiers | 16 | 16060000105925 | 16060000105925 | 5 | PA702993 | PM736362 |