data communication fellowship
Presentation #2
What has been done
product scope: Numbers will speak
The goal is to create and successfully launch
an online project helping and promoting the use of judiciary statistics for the journalism and research purposes
Target audience
Civic journalists
People seeking for a quick and convenient instrument for statistical insights and illustrations with a request for new knowledge
General public
People reading news, checking facts and open for works of visual expression
Project Deliverables
The concept of the project
Elements, stages, priorities
An instrument
To search and visualize the statistical indicators
Series of publications
Explaining&visualizing the judiciary statistics
Short guides
for the users of judiciary statistics (text, images, video)
Applicable datasets
Penal, Administrative, thematical. Yearly and regional basis
For posting publications and working with feedback
Types of communication
Social Media
Publications, instruments and guides will be available on social media publics. We plan to promote the materials in thematical groups (journalism, civic hacktivism, law).
Keep in touch
We plan to create a subscription list on our new publications and digests and to use polls to concretize the request for new vizualizations and guides. I also want to make available the collection of publications based on our data (like here)
Media&Expert Partner
We plan to involve the Institute of Law Enforcement Issues at the European University of St. Petersburg for expert and media support.
The best way for cooperation would be to organize a live hackathon (our own or as a nomination on a larger events)
Plan for this 3 weeks
Collect the data
Find the insights
Choose the topic
Choose the vizualization method
Collect illustrations and additional data
Create a publication
Promote a publication
What has been done
1. Dataset on punishment for criminal offenses
- Federal Court District data. 2013-2016. Each article of Penal Code.
- Number of people punished for each type of punishment
- Structured names of articles, chapters, sections created and from Penal Code are connected
2. Tools for scraping regional data are installed and configured
- Octoparse with configured data
- AMPPS Local server to store files on local drive
3. Visualization of data on punishment for criminal offenses
Created in Tableau. Used to analyze the Federal dynamics of criminal cases and punishments.
You can choose any article of a Penal code and compare the number of punished persons 2013-2016.
4. Visualization of data on administrative cases
Created in Tableau. Used to analyze the Regional dynamics of administrative cases and administrative sanctions. You can choose any type of aministrative case and compare the number of punished persons by region.
5. Setting hypotheses for verification using collected data
Created in Tableau. Used to analyze the Regional dynamics of administrative cases and administrative sanctions. You can choose any type of aministrative case and compare the number of punished persons by region.
Very high (99%) probability of being convicted for exceeding the limits of necessary defense in case of resistance to the attacker
How does the total number of convicts compare with the number of persons convicted of exceeding the limits of the necessary defense? And how this amount is correlated with the number of persons released from responsibility because of signs of necessary defense?

Data is not enough: law enforcement agencies also stop criminal cases until they are transferred to court. The only conclusion: if the case got to court, there is practically no chance to be justified.
The real insignificance of the defendants' acquittal on charges of serious crimes.
The number of acquitted in criminal cases is very low and continues to decline. And even in this amount (~ 2.7% from 2013 to 2016), the main part is the justification for slander (5 justified to 1 convict) and beatings are crimes of small gravity.

It turned out that the MEDIAZONA already has an article from December 2016 "Why the article on slander was excluded from the Criminal Code, and how he came back"
The number of convicts sent to correctional institutions of various types - is this information interesting?
The results doesn't demonstrate any dynamics in total.
What hasn't been done
I haven't found a story in the data.
The information seems insufficient
e.g. Data on the excess of the necessary defense limits proved to be insufficient. The information from law enforcement agencies is also required (and it's not available).

To increase the depth of the research it is necessary to work with individual solutions in court cases.

It would be also helpful to connect this data with general statistical criminal data and other thematical information.
Too many data
In datasets, there are a lot of topics for research, but each of them is rather superficial. One can study the correlation of crimes and punishments or the administrative cases, but the practical significance of the conclusions is not clear.
Data already used in media
The mention of the number of cases and convicts appears regularly in publications as a numerical fact. It is difficult to understand whether additional visualization of these simple data is needed.

I'm searching for context in the media (new legislation, high-profile cases)
Situation becomes more pessimistic
Made on