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 |
|---|---|---|---|---|---|---|---|
| 16060000103825 | L16/dossiers | 16 | 16060000103824 | 16060000103824 | 1 | PA793624 | PM796440 |
| 16060000103908 | L16/dossiers | 16 | 16060000103907 | 16060000103907 | 1 | PA719318 | PM796470 |
| 16060000103915 | L16/dossiers | 16 | 16060000103914 | 16060000103914 | 1 | PA775228 | PM775516 |
| 16060000103922 | L16/dossiers | 16 | 16060000103921 | 16060000103921 | 1 | PA267042 | PM796932 |
| 16060000103929 | L16/dossiers | 16 | 16060000103928 | 16060000103928 | 1 | PA719578 | PM796620 |
| 16060000103936 | L16/dossiers | 16 | 16060000103935 | 16060000103935 | 1 | PA794118 | PM796725 |
| 16060000103943 | L16/dossiers | 16 | 16060000103942 | 16060000103942 | 1 | PA794118 | PM796725 |
| 16060000103950 | L16/dossiers | 16 | 16060000103949 | 16060000103949 | 1 | PA794118 | PM796725 |
| 16060000103957 | L16/dossiers | 16 | 16060000103956 | 16060000103956 | 1 | PA794118 | PM796725 |
| 16060000103964 | L16/dossiers | 16 | 16060000103963 | 16060000103963 | 1 | PA794118 | PM796725 |
| 16060000103971 | L16/dossiers | 16 | 16060000103970 | 16060000103970 | 1 | PA794598 | PM797010 |
| 16060000103978 | L16/dossiers | 16 | 16060000103977 | 16060000103977 | 1 | PA794278 | PM796824 |
| 16060000103985 | L16/dossiers | 16 | 16060000103984 | 16060000103984 | 1 | PA720022 | PM796866 |
| 16060000103992 | L16/dossiers | 16 | 16060000103991 | 16060000103991 | 1 | PA794830 | PM797145 |
| 16060000103999 | L16/dossiers | 16 | 16060000103998 | 16060000103998 | 1 | PA717161 | PM791583 |
| 16060000104000 | L16/dossiers | 16 | 16060000103998 | 16060000103998 | 2 | PA773443 | PM791682 |
| 16060000104009 | L16/dossiers | 16 | 16060000104008 | 16060000104008 | 1 | PA717161 | PM791583 |
| 16060000104016 | L16/dossiers | 16 | 16060000104015 | 16060000104015 | 1 | PA795216 | PM797364 |
| 16060000104023 | L16/dossiers | 16 | 16060000104022 | 16060000104022 | 1 | PA720146 | PM796803 |
| 16060000104081 | L16/dossiers | 16 | 16060000104080 | 16060000104080 | 1 | PA795778 | PM797682 |
| 16060000104085 | L16/dossiers | 16 | 16060000104084 | 16060000104084 | 1 | PA721486 | PM797517 |
| 16060000104092 | L16/dossiers | 16 | 16060000104091 | 16060000104091 | 1 | PA2116 | PM736339 |
| 16060000104102 | L16/dossiers | 16 | 16060000104101 | 16060000104101 | 1 | PA722374 | PM797196 |
| 16060000104109 | L16/dossiers | 16 | 16060000104108 | 16060000104108 | 1 | PA736177 | PM736318 |
| 16060000104116 | L16/dossiers | 16 | 16060000104115 | 16060000104115 | 1 | PA736177 | PM736318 |
| 16060000104123 | L16/dossiers | 16 | 16060000104122 | 16060000104122 | 1 | PA736177 | PM736318 |
| 16060000104130 | L16/dossiers | 16 | 16060000104129 | 16060000104129 | 1 | PA736188 | PM736289 |
| 16060000104137 | L16/dossiers | 16 | 16060000104136 | 16060000104136 | 1 | PA2116 | PM736339 |
| 16060000104147 | L16/dossiers | 16 | 16060000104146 | 16060000104146 | 1 | PA346782 | PM797691 |
| 16060000104154 | L16/dossiers | 16 | 16060000104153 | 16060000104153 | 1 | PA794118 | PM796725 |
| 16060000104161 | L16/dossiers | 16 | 16060000104160 | 16060000104160 | 1 | PA722046 | PM797625 |
| 16060000104169 | L16/dossiers | 16 | 16060000104168 | 16060000104168 | 1 | PA795216 | PM797364 |
| 16060000104176 | L16/dossiers | 16 | 16060000104175 | 16060000104175 | 1 | PA718850 | PM796203 |
| 16060000104186 | L16/dossiers | 16 | 16060000104185 | 16060000104185 | 1 | PA421348 | PM797544 |
| 16060000104197 | L16/dossiers | 16 | 16060000104196 | 16060000104196 | 1 | PA267429 | PM796722 |
| 16060000104204 | L16/dossiers | 16 | 16060000104203 | 16060000104203 | 1 | PA717161 | PM791583 |
| 16060000104205 | L16/dossiers | 16 | 16060000104203 | 16060000104203 | 2 | PA312976 | PM791676 |
| 16060000104238 | L16/dossiers | 16 | 16060000104237 | 16060000104237 | 1 | PA717161 | PM791583 |
| 16060000104239 | L16/dossiers | 16 | 16060000104237 | 16060000104237 | 2 | PA331481 | PM791666 |
| 16060000104240 | L16/dossiers | 16 | 16060000104237 | 16060000104237 | 3 | PA719938 | PM791702 |
| 16060000104247 | L16/dossiers | 16 | 16060000104246 | 16060000104246 | 1 | PA720014 | PM796863 |
| 16060000104254 | L16/dossiers | 16 | 16060000104253 | 16060000104253 | 1 | PA720014 | PM796863 |
| 16060000104261 | L16/dossiers | 16 | 16060000104260 | 16060000104260 | 1 | PA643089 | PM797439 |
| 16060000104268 | L16/dossiers | 16 | 16060000104267 | 16060000104267 | 1 | PA795820 | PM797700 |
| 16060000104272 | L16/dossiers | 16 | 16060000104271 | 16060000104271 | 1 | PA775174 | PM775472 |
| 16060000104273 | L16/dossiers | 16 | 16060000104271 | 16060000104271 | 2 | PA703523 | PM775703 |
| 16060000104274 | L16/dossiers | 16 | 16060000104271 | 16060000104271 | 3 | PA767418 | PM775767 |
| 16060000104275 | L16/dossiers | 16 | 16060000104271 | 16060000104271 | 4 | PA775276 | PM775566 |
| 16060000104363 | L16/dossiers | 16 | 16060000104362 | 16060000104362 | 1 | PA266808 | PM797313 |
| 16060000104370 | L16/dossiers | 16 | 16060000104369 | 16060000104369 | 1 | PA775272 | PM775562 |