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 |
|---|---|---|---|---|---|---|---|
| 16060000109680 | L16/dossiers | 16 | 16060000109679 | 16060000109679 | 1 | PA717161 | PM791583 |
| 16060000109712 | L16/dossiers | 16 | 16060000109711 | 16060000109711 | 1 | PA304017 | PM775757 |
| 16060000109713 | L16/dossiers | 16 | 16060000109711 | 16060000109711 | 2 | PA736216 | PM736273 |
| 16060000109714 | L16/dossiers | 16 | 16060000109711 | 16060000109711 | 3 | PA736243 | PM736413 |
| 16060000109767 | L16/dossiers | 16 | 16060000109766 | 16060000109766 | 1 | PA795350 | PM797436 |
| 16060000109825 | L16/dossiers | 16 | 16060000109824 | 16060000109824 | 1 | PA719388 | PM796458 |
| 16060000109863 | L16/dossiers | 16 | 16060000109862 | 16060000109862 | 1 | PA330909 | PM796314 |
| 16060000109867 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 1 | PA2337 | PM775691 |
| 16060000109868 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 2 | PA2552 | PM736292 |
| 16060000109869 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 3 | PA303995 | PM775745 |
| 16060000109870 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 4 | PA736212 | PM736331 |
| 16060000109871 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 5 | PA760322 | PM775649 |
| 16060000109872 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 6 | PA721166 | PM785865 |
| 16060000109873 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 7 | PA736215 | PM736324 |
| 16060000109874 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 8 | PA266812 | PM736265 |
| 16060000109875 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 9 | PA703506 | PM777126 |
| 16060000109876 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 10 | PA703506 | PM777126 |
| 16060000109877 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 11 | PA429837 | PM736407 |
| 16060000109878 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 12 | PA736159 | PM736361 |
| 16060000109879 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 13 | PA719408 | PM775520 |
| 16060000109880 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 14 | PA775234 | PM775536 |
| 16060000109881 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 15 | PA736233 | PM736411 |
| 16060000109882 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 16 | PA775244 | PM775534 |
| 16060000109883 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 17 | PA703535 | PM793090 |
| 16060000109884 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 18 | PA703535 | PM793090 |
| 16060000109885 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 19 | PA703535 | PM793090 |
| 16060000109886 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 20 | PA736165 | PM736376 |
| 16060000109887 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 21 | PA736189 | PM736363 |
| 16060000109888 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 22 | PA429840 | PM736360 |
| 16060000109889 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 23 | PA415499 | PM775655 |
| 16060000109890 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 24 | PA775266 | PM775568 |
| 16060000109891 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 25 | PA736208 | PM736315 |
| 16060000109892 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 26 | PA775278 | PM775564 |
| 16060000109893 | L16/dossiers | 16 | 16060000109866 | 16060000109866 | 27 | PA736179 | PM736420 |
| 16060000109946 | L16/dossiers | 16 | 16060000109945 | 16060000109945 | 1 | PA2116 | PM736339 |
| 16060000109953 | L16/dossiers | 16 | 16060000109952 | 16060000109952 | 1 | PA2116 | PM736339 |
| 16060000109960 | L16/dossiers | 16 | 16060000109959 | 16060000109959 | 1 | PA2116 | PM736339 |
| 16060000109967 | L16/dossiers | 16 | 16060000109966 | 16060000109966 | 1 | PA795794 | PM797688 |
| 16060000109980 | L16/dossiers | 16 | 16060000109979 | 16060000109979 | 1 | PA346054 | PM797679 |
| 16060000109987 | L16/dossiers | 16 | 16060000109986 | 16060000109986 | 1 | PA720586 | PM797088 |
| 16060000109994 | L16/dossiers | 16 | 16060000109993 | 16060000109993 | 1 | PA717161 | PM791583 |
| 16060000109995 | L16/dossiers | 16 | 16060000109993 | 16060000109993 | 2 | PA312976 | PM791676 |
| 16060000110026 | L16/dossiers | 16 | 16060000110025 | 16060000110025 | 1 | PA717161 | PM791583 |
| 16060000110114 | L16/dossiers | 16 | 16060000110113 | 16060000110113 | 1 | PA717161 | PM791583 |
| 16060000110193 | L16/dossiers | 16 | 16060000110192 | 16060000110192 | 1 | PA429884 | PM736358 |
| 16060000110229 | L16/dossiers | 16 | 16060000110228 | 16060000110228 | 1 | PA429858 | PM736268 |
| 16060000110236 | L16/dossiers | 16 | 16060000110235 | 16060000110235 | 1 | PA785855 | PM785869 |
| 16060000110246 | L16/dossiers | 16 | 16060000110245 | 16060000110245 | 1 | PA775210 | PM775492 |
| 16060000110253 | L16/dossiers | 16 | 16060000110252 | 16060000110252 | 1 | PA795974 | PM797784 |
| 16060000110260 | L16/dossiers | 16 | 16060000110259 | 16060000110259 | 1 | PA794094 | PM796710 |