Icon

KNIME_​project_​final

Data loading and basic cleaning

Country name normalisation

Respondent state extraction

Data validation and quality control

Substantive classification of Article 6 violations

CPI and Article 6 structural correlation analysis

Temporal dynamics of Article 6 cases

Rule of Law analysis of Article 6 violations

Article 6 violations per 1 million inhabitants

Ranking countries and selecting the Top 10 by Article 6 cases.

total number of Article 6 cases, providing an overview of countries most frequently involved in Article 6 violations.
Bar Chart
CSV Reader
Line Plot
Join Top-10 countries with World Bank population data by country name (to compare violations with population size).
Joiner
Pie Chart
Convert Population from text to numeric format so it can be used in calculations.This step is crucial, because without proper conversion, any further quantitative analysis would be incorrect or impossible.
String to Number
Rule Engine
Visualize the ranking: violations per 1M inhabitants by country.
Bar Chart
Normalize respondent state names by removing bracketed suffixes (e.g. “No. 2”)
String Replacer
Standardizes country names so they match across different datasets.
Rule Engine
Rank TOP 10 respondent states by number of cases
Row Filter
Calculate violations per 1,000,000 people to normalize for country size.
Math Formula
Top 10 countries with the highest number of Article 6 cases.
Bar Chart
Sort countries by normalized violation rate (descending) to build a clear ranking.
Sorter
Combines Article 6 violation data with Rule of Law indicators by country name.
Joiner
Calculates the average Rule of Law score across several years for each country.
Math Formula
Aggregate Article 6 cases by respondent state and year.
GroupBy
Visualizes and compares Rule of Law levels across countries in a clear and intuitive way.
Bar Chart
Orders countries by their Rule of Law value to highlight relative performance.
Sorter
Loads the Corruption Perceptions Index (CPI) dataset for further analysis.
CSV Reader
Convert CPI table from years-in-columns to year-per-row format.
Unpivot
Computes the total number of Article 6 judgments across all respondent states.
GroupBy
Rename aggregated count column for clarity.
Column Renamer
Merges Article 6 case data with CPI data using country and year as matching keys.
Joiner
Calculates the total number of Article 6 cases among the top 10 respondent states.
GroupBy
Column Renamer
Column Filter
1. Fix Encoding problem. Point in Encoding section UTF-8 for depicting TÜRKİYE not TГњRKД°YE
CSV Reader
Clean column names by replacing spaces with underscores for consistent processing
Column Renamer
Convert year column to numeric format.
String to Number
Show the relationship between CPI and number of Article 6 cases.
Scatter Plot
standardizes country names into a single, consistent format.
Rule Engine
Rename columns after unpivot for clarity.
Column Renamer
The heatmap visualizes the intensity of Article 6 violations across countries and years. Darker cells indicate a higher number of cases, allowing us to identify both temporal trends and country-specific structural issues.
Heatmap
Calculates the percentage share of Article 6 cases accounted for by the top 10 respondent states.
Math Formula
Loads the Rule of Law dataset with country-level values for different years.
CSV Reader
Renames aggregated columns for clarity and consistency in further analysis.
Column Renamer
Visualizes the relationship between CPI and Article 6 cases, with bubble size emphasizing higher case counts.
Bubble Chart (JFreeChart)
Combines the total number of Article 6 cases with the aggregated total for the top 10 respondent states into a single table.
Cross Joiner
Displays how the total number of Article 6 cases changes over time.
Bar Chart
Extracts the year from the decision date, allowing aggregation of cases by year.
Date&Time Part Extractor
Visualizes the distribution of Article 6 cases across respondent states.
Bar Chart
Rule Engine
Converts the decision date from string format into a Date&Time format to enable time-based analysis.
String to Date&Time
Groups cases by year and calculates the total number of Article 6 judgments for each year.
GroupBy
Visualizes the yearly distribution of Article 6 judgments, highlighting temporal trends over time.
Bar Chart
Aggregates cases by Article 6 violation type and counts how often each type occurs.
GroupBy
Set normalized document title as main title field
Column Renamer
Aggregates cases by Article 6 violation type and counts how often each type occurs.
Sorter
Displays the proportional distribution of Article 6 judgments across different years.
Pie Chart
Classifies Article 6 violations into thematic categories based on keywords found in the Conclusion field.
Rule Engine
Normalize country name in document titles: TURKEY to TÜRKİYE
String Manipulation
1. Identify records with missing respondent state due to non-standard document titles2. Remove incomplete records with missing key analytical fields
Row Filter
Line Plot
Remove original document title after validation
Column Filter
Exclude cases with missing respondent state
Column Filter
Image View
Extract respondent state by splitting document title on “v.”
String Splitter (Regex)
This chart shows which procedural guarantees under Article 6 are most frequently violated.We can clearly see that criminal proceedings dominate the picture.
Pie Chart
Changed the name of column to Respondent_State
Column Renamer
Bar Chart
Rank respondent states by number of cases
Sorter
Checking missed points
Row Filter
Stacked Area Chart
Aggregate Article 6 cases by respondent state
GroupBy

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: user
Created at: 2026-01-17
On NodePit since: 2026-02-07
Last update: 2026-02-07
Created with KNIME version: v5.8.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!