Language NL EN DE ES FR UK IT

Rebuild analysis

Kartel Analysis

Clean base for MEP, document and thematic network analysis. No hard political labels, but auditable evidence.

You are here

Import and analysis base

You are on the technical admin base. Here you check import status, runs and the state of the dataset.

Admin base

Import and analysis base

This page is intended as a technical starting point for import control. Publish it only behind session auth or extra Nginx protection.

yesDemo data loaded
20Shown import rows

Import rows

manifesto-project-mpds2024a

Type: party_position_import | status: completed
Seen: 5151 | inserted: 143 | updated: 0

{"dry_run":false,"dataset_version":"MPDS2024a","matched_local_parties":143,"skipped_no_partyfacts_mapping":14,"skipped_partyfacts_not_local":3802,"skipped_ambiguous_partyfacts_mapping":0,"examples":[{"entity_id":765,"partyfacts_id":"830","manifesto_party_id":"11220","source_year":2022,"partyname":"Left Party","rile":"-36.674","eu_delta":"0.00"},{"entity_id":1043,"partyfacts_id":"487","manifesto_party_id":"11320","source_year":2022,"partyname":"Social Democratic Labour Party","rile":"-5.114","eu_delta":"0.85"},{"entity_id":1094,"partyfacts_id":"1274","manifesto_party_id":"11420","source_year":2022,"partyname":"Liberals","rile":"10.624","eu_delta":"1.62"},{"entity_id":1099,"partyfacts_id":"690","manifesto_party_id":"11620","source_year":2022,"partyname":"Moderate Coalition Party","rile":"18.194","eu_delta":"1.08"},{"entity_id":1148,"partyfacts_id":"651","manifesto_party_id":"11520","source_year":2022,"partyname":"Christian Democrats","rile":"-5.556","eu_delta":"0.00"},{"entity_id":1083,"partyfacts_id":"456","manifesto_party_id":"11110","source_year":2022,"partyname":"Green Ecology Party","rile":"-5.376","eu_delta":"0.00"},{"entity_id":1054,"partyfacts_id":"409","manifesto_party_id":"11710","source_year":2022,"partyname":"Sweden Democrats","rile":"4.295","eu_delta":"-1.20"},{"entity_id":1061,"partyfacts_id":"379","manifesto_party_id":"13320","source_year":2019,"partyname":"Social Democratic Party","rile":"-18.483","eu_delta":"0.89"},{"entity_id":1060,"partyfacts_id":"1507","manifesto_party_id":"13410","source_year":2019,"partyname":"Danish Social-Liberal Party","rile":"-19.516","eu_delta":"4.52"},{"entity_id":1038,"partyfacts_id":"1204","manifesto_party_id":"13420","source_year":2019,"partyname":"Liberals","rile":"-17.483","eu_delta":"5.59"}]}

ep_official_memberships

Type: backfill | status: completed
Seen: 1 | inserted: 0 | updated: 0

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=1, offset=0, only_missing_party=1.

ep_official_memberships

Type: backfill | status: completed
Seen: 1 | inserted: 0 | updated: 0

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=1, offset=0, only_missing_party=1.

partyfacts

Type: mapping_import | status: completed
Seen: 228 | inserted: 183 | updated: 0

{"dry_run":false,"matched":183,"ambiguous":0,"unmatched":45,"method":"core/external exact name-country plus unique contained name-country","examples":[{"entity_id":991,"local_name":"Rassemblement national","country":"FRA","partyfacts_id":"433","partyfacts_name":"Rassemblement national","match_method":"exact-external-name-country"},{"entity_id":775,"local_name":"Prawo i Sprawiedliwość","country":"POL","partyfacts_id":"1565","partyfacts_name":"Prawo i Sprawiedliwość","match_method":"exact-core-name-country"},{"entity_id":1014,"local_name":"FRATELLI D' ITALIA","country":"ITA","partyfacts_id":"2280","partyfacts_name":"Fratelli d'Italia","match_method":"exact-core-name-country"},{"entity_id":783,"local_name":"Partito Democratico","country":"ITA","partyfacts_id":"802","partyfacts_name":"Partito Democratico","match_method":"exact-core-name-country"},{"entity_id":762,"local_name":"Sozialdemokratische Partei Deutschlands","country":"DEU","partyfacts_id":"383","partyfacts_name":"Sozialdemokratische Partei Deutschlands","match_method":"exact-core-name-country"},{"entity_id":1004,"local_name":"Partido Socialista Obrero Español","country":"ESP","partyfacts_id":"1338","partyfacts_name":"Partido Socialista Obrero Español","match_method":"exact-core-name-country"},{"entity_id":996,"local_name":"Koalicja Obywatelska","country":"POL","partyfacts_id":"9122","partyfacts_name":"Koalicja Obywatelska","match_method":"exact-core-name-country"},{"entity_id":761,"local_name":"Christlich-Soziale Union in Bayern e.V.","country":"DEU","partyfacts_id":"1731","partyfacts_name":"Christlich Soziale Union","match_method":"unique-contained-name-country"},{"entity_id":983,"local_name":"Alternative für Deutschland","country":"DEU","partyfacts_id":"1976","partyfacts_name":"Alternative für Deutschland","match_method":"exact-core-name-country"},{"entity_id":987,"local_name":"Bündnis 90/Die Grünen","country":"DEU","partyfacts_id":"1816","partyfacts_name":"Bündnis 90 / Die Grünen","match_method":"exact-core-name-country"},{"entity_id":756,"local_name":"Parti socialiste","country":"FRA","partyfacts_id":"1478","partyfacts_name":"Parti socialiste","match_method":"exact-core-name-country"},{"entity_id":768,"local_name":"Partidul Naţional Liberal","country":"ROU","partyfacts_id":"481","partyfacts_name":"Partidul Naţional Liberal","match_method":"exact-core-name-country"}]}

parlgov-development-2023

Type: import | status: completed
Seen: 1707 | inserted: 164 | updated: 0

ParlGov 2023 party positions imported via Party Facts parlgov dataset_party_id; unmatched or ambiguous rows skipped.

ches_2024

Type: party_position_import | status: completed
Seen: 279 | inserted: 129 | updated: 0

{"matched":129,"skipped_no_partyfacts":39,"skipped_not_local":111,"skipped_ambiguous":0,"examples":[{"entity_id":756,"partyfacts_id":"500","ches_party_id":"102","party":"PS","lrgen":"2.5555556","eu_position":"5.7777777","galtan":"2.7777777","people_v_elite":"4"},{"entity_id":1150,"partyfacts_id":"1680","ches_party_id":"103","party":"Vooruit","lrgen":"4.3000002","eu_position":"6.0999999","galtan":"3.0999999","people_v_elite":"4"},{"entity_id":1029,"partyfacts_id":"1563","ches_party_id":"104","party":"Ecolo","lrgen":"2.4444444","eu_position":"5.8888888","galtan":"1.5555556","people_v_elite":"6"},{"entity_id":1116,"partyfacts_id":"528","ches_party_id":"105","party":"Groen","lrgen":"2.5","eu_position":"5.9000001","galtan":"1.6","people_v_elite":"6"},{"entity_id":776,"partyfacts_id":"789","ches_party_id":"106","party":"MR","lrgen":"7.4444447","eu_position":"6.4444447","galtan":"5.2222223","people_v_elite":"2.6666667"},{"entity_id":758,"partyfacts_id":"49","ches_party_id":"107","party":"Open Vld","lrgen":"6.3333335","eu_position":"6.6999998","galtan":"3","people_v_elite":"4"},{"entity_id":1159,"partyfacts_id":"633","ches_party_id":"108","party":"LE","lrgen":"5.5555553","eu_position":"6.4285712","galtan":"5.75","people_v_elite":"4"},{"entity_id":1009,"partyfacts_id":"604","ches_party_id":"109","party":"CD&V","lrgen":"5.6999998","eu_position":"6.6999998","galtan":"6.8000002","people_v_elite":"3.3333333"},{"entity_id":1093,"partyfacts_id":"36","ches_party_id":"110","party":"N-VA","lrgen":"7.5","eu_position":"4.5","galtan":"7.0999999","people_v_elite":"2.6666667"},{"entity_id":1024,"partyfacts_id":"1753","ches_party_id":"119","party":"PVDA-PTB","lrgen":".80000001","eu_position":"2.4444444","galtan":"3.2","people_v_elite":"8"},{"entity_id":1061,"partyfacts_id":"379","ches_party_id":"201","party":"S","lrgen":"4","eu_position":"5.818182","galtan":"4","people_v_elite":"2.5"},{"entity_id":1060,"partyfacts_id":"1507","ches_party_id":"202","party":"RV","lrgen":"4.909091","eu_position":"7","galtan":"1.7272727","people_v_elite":"3"}]}

ep_official_memberships

Type: backfill | status: completed
Seen: 5 | inserted: 0 | updated: 0

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=5, offset=0, only_missing_party=1.

ep_official_memberships

Type: backfill | status: completed
Seen: 5 | inserted: 0 | updated: 0

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=5, offset=0, only_missing_party=1.

ep_official_memberships

Type: backfill | status: completed
Seen: 5 | inserted: 0 | updated: 4

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=5, offset=0, only_missing_party=1.

ep_official_memberships

Type: backfill | status: completed
Seen: 5 | inserted: 2 | updated: 15

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=5, offset=0, only_missing_party=1.

ep_official_memberships

Type: backfill | status: completed
Seen: 1 | inserted: 0 | updated: 1

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=1, offset=0, only_missing_party=1.

ep_official_memberships

Type: backfill | status: completed
Seen: 1 | inserted: 0 | updated: 5

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=1, offset=0, only_missing_party=1.

ep_official_memberships

Type: backfill | status: partial
Seen: 0 | inserted: 0 | updated: 0

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch onderbroken door max-seconds=20, limit=1, offset=0, only_missing_party=1.

parlgov-development-2023

Type: import | status: completed
Seen: 1707 | inserted: 164 | updated: 0

ParlGov 2023 party positions imported via Party Facts parlgov dataset_party_id; unmatched or ambiguous rows skipped.

ches_2024

Type: party_position_import | status: completed
Seen: 279 | inserted: 129 | updated: 0

{"matched":129,"skipped_no_partyfacts":39,"skipped_not_local":111,"skipped_ambiguous":0,"examples":[{"entity_id":756,"partyfacts_id":"500","ches_party_id":"102","party":"PS","lrgen":"2.5555556","eu_position":"5.7777777","galtan":"2.7777777","people_v_elite":"4"},{"entity_id":1150,"partyfacts_id":"1680","ches_party_id":"103","party":"Vooruit","lrgen":"4.3000002","eu_position":"6.0999999","galtan":"3.0999999","people_v_elite":"4"},{"entity_id":1029,"partyfacts_id":"1563","ches_party_id":"104","party":"Ecolo","lrgen":"2.4444444","eu_position":"5.8888888","galtan":"1.5555556","people_v_elite":"6"},{"entity_id":1116,"partyfacts_id":"528","ches_party_id":"105","party":"Groen","lrgen":"2.5","eu_position":"5.9000001","galtan":"1.6","people_v_elite":"6"},{"entity_id":776,"partyfacts_id":"789","ches_party_id":"106","party":"MR","lrgen":"7.4444447","eu_position":"6.4444447","galtan":"5.2222223","people_v_elite":"2.6666667"},{"entity_id":758,"partyfacts_id":"49","ches_party_id":"107","party":"Open Vld","lrgen":"6.3333335","eu_position":"6.6999998","galtan":"3","people_v_elite":"4"},{"entity_id":1159,"partyfacts_id":"633","ches_party_id":"108","party":"LE","lrgen":"5.5555553","eu_position":"6.4285712","galtan":"5.75","people_v_elite":"4"},{"entity_id":1009,"partyfacts_id":"604","ches_party_id":"109","party":"CD&V","lrgen":"5.6999998","eu_position":"6.6999998","galtan":"6.8000002","people_v_elite":"3.3333333"},{"entity_id":1093,"partyfacts_id":"36","ches_party_id":"110","party":"N-VA","lrgen":"7.5","eu_position":"4.5","galtan":"7.0999999","people_v_elite":"2.6666667"},{"entity_id":1024,"partyfacts_id":"1753","ches_party_id":"119","party":"PVDA-PTB","lrgen":".80000001","eu_position":"2.4444444","galtan":"3.2","people_v_elite":"8"},{"entity_id":1061,"partyfacts_id":"379","ches_party_id":"201","party":"S","lrgen":"4","eu_position":"5.818182","galtan":"4","people_v_elite":"2.5"},{"entity_id":1060,"partyfacts_id":"1507","ches_party_id":"202","party":"RV","lrgen":"4.909091","eu_position":"7","galtan":"1.7272727","people_v_elite":"3"}]}

partyfacts

Type: mapping_import | status: completed
Seen: 226 | inserted: 182 | updated: 0

{"dry_run":false,"matched":182,"ambiguous":0,"unmatched":44,"method":"core/external exact name-country plus unique contained name-country","examples":[{"entity_id":991,"local_name":"Rassemblement national","country":"FRA","partyfacts_id":"433","partyfacts_name":"Rassemblement national","match_method":"exact-external-name-country"},{"entity_id":775,"local_name":"Prawo i Sprawiedliwość","country":"POL","partyfacts_id":"1565","partyfacts_name":"Prawo i Sprawiedliwość","match_method":"exact-core-name-country"},{"entity_id":1014,"local_name":"FRATELLI D' ITALIA","country":"ITA","partyfacts_id":"2280","partyfacts_name":"Fratelli d'Italia","match_method":"exact-core-name-country"},{"entity_id":783,"local_name":"Partito Democratico","country":"ITA","partyfacts_id":"802","partyfacts_name":"Partito Democratico","match_method":"exact-core-name-country"},{"entity_id":762,"local_name":"Sozialdemokratische Partei Deutschlands","country":"DEU","partyfacts_id":"383","partyfacts_name":"Sozialdemokratische Partei Deutschlands","match_method":"exact-core-name-country"},{"entity_id":1004,"local_name":"Partido Socialista Obrero Español","country":"ESP","partyfacts_id":"1338","partyfacts_name":"Partido Socialista Obrero Español","match_method":"exact-core-name-country"},{"entity_id":996,"local_name":"Koalicja Obywatelska","country":"POL","partyfacts_id":"9122","partyfacts_name":"Koalicja Obywatelska","match_method":"exact-core-name-country"},{"entity_id":761,"local_name":"Christlich-Soziale Union in Bayern e.V.","country":"DEU","partyfacts_id":"1731","partyfacts_name":"Christlich Soziale Union","match_method":"unique-contained-name-country"},{"entity_id":983,"local_name":"Alternative für Deutschland","country":"DEU","partyfacts_id":"1976","partyfacts_name":"Alternative für Deutschland","match_method":"exact-core-name-country"},{"entity_id":987,"local_name":"Bündnis 90/Die Grünen","country":"DEU","partyfacts_id":"1816","partyfacts_name":"Bündnis 90 / Die Grünen","match_method":"exact-core-name-country"},{"entity_id":756,"local_name":"Parti socialiste","country":"FRA","partyfacts_id":"1478","partyfacts_name":"Parti socialiste","match_method":"exact-core-name-country"},{"entity_id":768,"local_name":"Partidul Naţional Liberal","country":"ROU","partyfacts_id":"481","partyfacts_name":"Partidul Naţional Liberal","match_method":"exact-core-name-country"}]}

opensanctions_ep_source_xml

Type: current_membership_import | status: completed
Seen: 718 | inserted: 195 | updated: 707

{"matched_terms":707,"party_entities_inserted":186,"group_entities_inserted":9,"skipped_no_id":0,"skipped_no_party":0,"skipped_no_local_term":11,"provenance":"OpenSanctions mirror of European Parliament source XML; lower confidence than direct EP RDF."}

legacy_political_group_repair

Type: repair | status: completed
Seen: 7658 | inserted: 0 | updated: 5761

Repaired political_group_entity_id only where legacy term pointed to null/non-PoliticalGroup and old meps.mep_political_group had a label.

ep_official_memberships

Type: backfill | status: completed
Seen: 25 | inserted: 0 | updated: 0

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=25, offset=75, only_missing_party=1.

ep_official_memberships

Type: backfill | status: completed
Seen: 25 | inserted: 0 | updated: 0

Officiële EP RDF-memberships voor nationale partijen en fracties. Batch limit=25, offset=50, only_missing_party=1.

Next logical step

Use these routes to continue your research from this page.