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 |
|---|---|---|---|---|---|---|---|
| 17060000114866 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 6 | PA703528 | PM703588 |
| 17060000114867 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 7 | PA736190 | PM736255 |
| 17060000114868 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 8 | PA703531 | PM703701 |
| 17060000114869 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 9 | PA905 | PM703566 |
| 17060000114870 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 10 | PA268007 | PM736325 |
| 17060000114871 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 11 | PA429845 | PM736278 |
| 17060000114872 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 12 | PA736235 | PM736426 |
| 17060000114873 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 13 | PA703487 | PM703711 |
| 17060000114874 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 14 | PA736228 | PM736380 |
| 17060000114875 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 15 | PA1573 | PM703652 |
| 17060000114876 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 16 | PA736168 | PM736301 |
| 17060000114877 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 17 | PA703509 | PM703687 |
| 17060000114878 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 18 | PA703529 | PM703650 |
| 17060000114879 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 19 | PA415464 | PM703627 |
| 17060000114880 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 20 | PA736242 | PM736349 |
| 17060000114881 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 21 | PA703495 | PM703708 |
| 17060000114882 | L17/dossiers | 17 | 17060000114860 | 17060000114860 | 22 | PA415480 | PM709303 |
| 17060000114910 | L17/dossiers | 17 | 17060000114909 | 17060000114909 | 1 | PA736186 | PM736396 |
| 17060000114911 | L17/dossiers | 17 | 17060000114909 | 17060000114909 | 2 | PA415454 | PM703689 |
| 17060000114940 | L17/dossiers | 17 | 17060000114939 | 17060000114939 | 1 | PA702993 | PM736362 |
| 17060000114941 | L17/dossiers | 17 | 17060000114939 | 17060000114939 | 2 | PA703505 | PM703626 |
| 17060000114942 | L17/dossiers | 17 | 17060000114939 | 17060000114939 | 3 | PA429867 | PM736298 |
| 17060000114943 | L17/dossiers | 17 | 17060000114939 | 17060000114939 | 4 | PA429889 | PM736313 |
| 17060000114944 | L17/dossiers | 17 | 17060000114939 | 17060000114939 | 5 | PA429889 | PM736313 |
| 17060000114945 | L17/dossiers | 17 | 17060000114939 | 17060000114939 | 6 | PA703490 | PM703631 |
| 17060000114973 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 1 | PA429886 | PM736385 |
| 17060000114974 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 2 | PA304082 | PM736354 |
| 17060000114975 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 3 | PA757676 | PM757692 |
| 17060000114976 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 4 | PA429891 | PM736329 |
| 17060000114977 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 5 | PA429894 | PM736364 |
| 17060000114978 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 6 | PA756685 | PM756689 |
| 17060000114979 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 7 | PA429836 | PM736345 |
| 17060000114980 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 8 | PA304071 | PM703676 |
| 17060000114981 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 9 | PA736195 | PM736357 |
| 17060000114982 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 10 | PA736177 | PM736318 |
| 17060000114983 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 11 | PA736173 | PM736369 |
| 17060000114984 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 12 | PA1978 | PM736337 |
| 17060000114985 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 13 | PA678263 | PM736330 |
| 17060000114986 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 14 | PA736243 | PM736413 |
| 17060000114987 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 15 | PA703499 | PM703641 |
| 17060000114988 | L17/dossiers | 17 | 17060000114972 | 17060000114972 | 16 | PA736175 | PM736344 |
| 17060000115016 | L17/dossiers | 17 | 17060000115015 | 17060000115015 | 1 | PA429875 | PM736302 |
| 17060000115017 | L17/dossiers | 17 | 17060000115015 | 17060000115015 | 2 | PA757678 | PM757684 |
| 17060000115018 | L17/dossiers | 17 | 17060000115015 | 17060000115015 | 3 | PA404656 | PM736328 |
| 17060000115047 | L17/dossiers | 17 | 17060000115046 | 17060000115046 | 1 | PA703513 | PM703621 |
| 17060000115048 | L17/dossiers | 17 | 17060000115046 | 17060000115046 | 2 | PA758716 | PM758720 |
| 17060000115049 | L17/dossiers | 17 | 17060000115046 | 17060000115046 | 3 | PA758716 | PM758720 |
| 17060000115050 | L17/dossiers | 17 | 17060000115046 | 17060000115046 | 4 | PA415462 | PM703628 |
| 17060000115079 | L17/dossiers | 17 | 17060000115078 | 17060000115078 | 1 | PA429858 | PM736268 |
| 17060000115109 | L17/dossiers | 17 | 17060000115108 | 17060000115108 | 1 | PA429858 | PM736268 |