ECHR OpenData logo ECHR Open Data Explorer

Statistics & Visualizations

You have a question about the ECHR or the ECHR Open Data?

Please, open a ticket in GitHub issue tracker and we might add a new visualization and example.

How many cases per article are in the database?

How is the data obtained?
The data is retrieved from the SQL database with the following query, containing two successing inner joins: 
SELECT conclusion.article, conclusion.type, COUNT(c.itemid) FROM "case" as c
INNER JOIN conclusioncase
  ON c.itemid = conclusioncase.case_id
INNER JOIN conclusion
  ON conclusion.id = conclusioncase.conclusion_id
WHERE conclusion.article NOT NULL
GROUP BY conclusion.article, conclusion.type;
Please, note the need to enclose the table name "case" into brackets because case is a SQL keyword.

What are the countries with the largest number of cases accepted by the Court?

The tooltip indicates the number of cases and in brackets, the percentage of total cases judged by the Court. Therefore, the percentages do not sum to 100%. However, the slices are proportional to their percentage. The missing slice accounts for all the other countries.

How is the data obtained?
The data is retrieved from the SQL database first using the following : 
SELECT respondent, COUNT(respondent) FROM "case" GROUP BY respondent;

Please, note the need to enclose the table name "case" into brackets because case is a SQL keyword.

There is a bias as a small amount of cases concerns two countries at the same time, as for instance 001-157695 that accout for Russia and Ukraine. The table and pie chart above takes into account this bias.