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 |
|---|---|---|---|---|---|---|---|
| 16060000096055 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 4 | PA429894 | PM736364 |
| 16060000096056 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 5 | PA775172 | PM775474 |
| 16060000096057 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 6 | PA756685 | PM775777 |
| 16060000096058 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 7 | PA429886 | PM736385 |
| 16060000096059 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 8 | PA736195 | PM736357 |
| 16060000096060 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 9 | PA736173 | PM736369 |
| 16060000096061 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 10 | PA775246 | PM775532 |
| 16060000096062 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 11 | PA678263 | PM736330 |
| 16060000096063 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 12 | PA1978 | PM736337 |
| 16060000096064 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 13 | PA736243 | PM736413 |
| 16060000096065 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 14 | PA736175 | PM736344 |
| 16060000096066 | L16/dossiers | 16 | 16060000096051 | 16060000096051 | 15 | PA775296 | PM775596 |
| 16060000096073 | L16/dossiers | 16 | 16060000096072 | 16060000096072 | 1 | PA1874 | PM796383 |
| 16060000096077 | L16/dossiers | 16 | 16060000096076 | 16060000096076 | 1 | PA775298 | PM775594 |
| 16060000096078 | L16/dossiers | 16 | 16060000096076 | 16060000096076 | 2 | PA267340 | PM775731 |
| 16060000096085 | L16/dossiers | 16 | 16060000096084 | 16060000096084 | 1 | PA775182 | PM775464 |
| 16060000096092 | L16/dossiers | 16 | 16060000096091 | 16060000096091 | 1 | PA717161 | PM791583 |
| 16060000096093 | L16/dossiers | 16 | 16060000096091 | 16060000096091 | 2 | PA331481 | PM791666 |
| 16060000096094 | L16/dossiers | 16 | 16060000096091 | 16060000096091 | 3 | PA722190 | PM791668 |
| 16060000096632 | L16/dossiers | 16 | 16060000096631 | 16060000096631 | 1 | PA703513 | PM775671 |
| 16060000096651 | L16/dossiers | 16 | 16060000096650 | 16060000096650 | 1 | PA775218 | PM775518 |
| 16060000096658 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 1 | PA775296 | PM775596 |
| 16060000096659 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 2 | PA775246 | PM775532 |
| 16060000096660 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 3 | PA429894 | PM736364 |
| 16060000096661 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 4 | PA736175 | PM736344 |
| 16060000096662 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 5 | PA757676 | PM757692 |
| 16060000096663 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 6 | PA304082 | PM736354 |
| 16060000096664 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 7 | PA775172 | PM775474 |
| 16060000096665 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 8 | PA756685 | PM775777 |
| 16060000096666 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 9 | PA429836 | PM736345 |
| 16060000096667 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 10 | PA429886 | PM736385 |
| 16060000096668 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 11 | PA736195 | PM736357 |
| 16060000096669 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 12 | PA736173 | PM736369 |
| 16060000096670 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 13 | PA678263 | PM736330 |
| 16060000096671 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 14 | PA1978 | PM736337 |
| 16060000096672 | L16/dossiers | 16 | 16060000096657 | 16060000096657 | 15 | PA736243 | PM736413 |
| 16060000096679 | L16/dossiers | 16 | 16060000096678 | 16060000096678 | 1 | PA717161 | PM791583 |
| 16060000096686 | L16/dossiers | 16 | 16060000096685 | 16060000096685 | 1 | PA717161 | PM791583 |
| 16060000096693 | L16/dossiers | 16 | 16060000096692 | 16060000096692 | 1 | PA1874 | PM796383 |
| 16060000096716 | L16/dossiers | 16 | 16060000096715 | 16060000096715 | 1 | PA332228 | PM796704 |
| 16060000096723 | L16/dossiers | 16 | 16060000096722 | 16060000096722 | 1 | PA721314 | PM797151 |
| 16060000096730 | L16/dossiers | 16 | 16060000096729 | 16060000096729 | 1 | PA712015 | PM796176 |
| 16060000096737 | L16/dossiers | 16 | 16060000096736 | 16060000096736 | 1 | PA794854 | PM797163 |
| 16060000096744 | L16/dossiers | 16 | 16060000096743 | 16060000096743 | 1 | PA720692 | PM796986 |
| 16060000096751 | L16/dossiers | 16 | 16060000096750 | 16060000096750 | 1 | PA720754 | PM797121 |
| 16060000096758 | L16/dossiers | 16 | 16060000096757 | 16060000096757 | 1 | PA343988 | PM736310 |
| 16060000096759 | L16/dossiers | 16 | 16060000096757 | 16060000096757 | 2 | PA775176 | PM775462 |
| 16060000096760 | L16/dossiers | 16 | 16060000096757 | 16060000096757 | 3 | PA715745 | PM736297 |
| 16060000096761 | L16/dossiers | 16 | 16060000096757 | 16060000096757 | 4 | PA775242 | PM775528 |
| 16060000096762 | L16/dossiers | 16 | 16060000096757 | 16060000096757 | 5 | PA703513 | PM775671 |