Data Journalism Top 10: Best Dataviz, Westminster Accounts, Cosmetics Waste, Capitol Rioters Sentencing

1 year ago 81

Tortoise and Sky News collaborated on the Westminster Accounts database, which shows how much money is funneled into UK politics. Image: Screenshot, Tortoise

With the one-year mark of Russia’s invasion of Ukraine approaching, data journalists are still finding novel ways to report on the war’s developments and implications. This week, the Institute of War & Peace Reporting (IWPR) visualized data from thousands of social media comments to see how the war was perceived in Central Asia.

Our weekly NodeXL and human curation of the most popular data journalism stories on Twitter also features a tool by Tortoise and Sky News to explore donations received by UK’s members of Parliament, a look at cosmetics waste from Deduktif, Le Monde’s podcast on mapping, and an analysis of the sentencing of rioters involved in the 2021 US Capitol attack.

The Mega List of Data Visualization Lists

We’re kicking off this year’s first GIJN Top 10 in Data Journalism column with a look back on the great work produced by data teams worldwide in 2022. Since 2015, data journalist and visualization consultant Maarten Lambrechts has been compiling a year-end meta list of best data visualization lists. His latest collection includes the work of Axios, Scientific American, Vox, Atlo Team, and ProPublica, among others. (Disclaimer: GIJN’s own Editor’s Pick: Top 10 Data Journalism Projects from 2022 is mentioned in the piece.)

[NEW] A little later than usual, but the 2022 List of Visualisation Lists is out! 32 lists of the past year's best visualizations, charts, graphics, maps, data and satellite journalism, and science photography https://t.co/DytKhRykmg pic.twitter.com/qeuNAwvGkV

— Maarten Lambrechts @maarten@vis.social (@maartenzam) January 3, 2023

How Russia’s War is Perceived in Central Asia

A journalist-analyst team at the IWPR’s Central Asia Bureau for Analytical Reporting sifted through over 25,000 comments on social media — including emojis — and Google searches about news on the war in Ukraine, published by leading news outlets in Kazakhstan and Uzbekistan. Among their findings, they noted that users in Uzbekistan were active in commenting from the very start of the war, but that comments declined as the war progressed — until the news in September of Russia’s partial mobilization of military reservists sparked renewed engagement. In Kazakhstan, the most comments on Russia’s mobilization came from users in three regions bordering Russia. Of note: less than one-third of comments from either country were in support of the war.

Kazakistan ve Özbekistan'da #Ukrayna'daki savaşın internette nasıl tartışıldığını içeren ilgi çekici bir çalışma..https://t.co/kanrWtPJfl

— Burak Çalışkan (@burakccaliskan) January 2, 2023

The Westminster Accounts

British news website Tortoise Media and TV channel Sky News collaborated on a first-of-its-kind “database of databases” to reveal the scale of money funneled into UK politics. The tool can be used to search, by UK postcode or by Members of Parliament (MPs), for the sources and amounts of donations. In explaining the methodology, they noted that gathering all sources of cash — often from tens of thousands of financial reports — was a laborious process despite this information being publicly available. Some notable numbers: Sky News reported that, since the end of 2019, MPs have earned around £17.1 million (about US$20.8 million) on top of their salaries. And a small group of mostly Conservative MPs have gotten nearly 90% — £15.2 million (US$18.5 million) — of that amount.

Important work (resource) from @CatNeilan @GWhittell @tortoise & @SamCoatesSky @EdClowes @SkyNews

WESTMINSTER ACCOUNTS shines spotlight on £183m donated (& declared) by MPs this parliament (3+ years).

Tool here: https://t.co/9YDH73J7Sz

Story here: https://t.co/LFMT6aLwW7

— Kevin Keith (@KevKeith) January 9, 2023

Cosmetics Waste

By combining online surveys, data from the Indonesia Food and Drug Supervisory Agency, and field reporting, this project by Indonesian independent media site Deduktif raises readers’ awareness of the waste problems generated by lipstick usage. They packaged the story, through gamification, into an interactive format in which readers enter their name and, for instance, the number of lipsticks they buy, and receive personalized responses and data visualizations based on their entries. Check out the video (in Indonesian) here.

i really love this coverage. interesting topic, sprinkled with relevant data, and its interactive format. nothing hits harder than personalisation.https://t.co/I8CwY0DGev

— rsl flrn (@kchulhu) January 3, 2023

Podcast: Mapping Change

This week’s Radio France podcast episode “Les Cartes en mouvement” (Moving Maps) discusses an interactive map of rail networks in the Île-de-France — a region in north-central France that includes Paris. This area was featured in a recent Le Monde article that visualized the record-breaking amount of planned works on the region’s rail network in 2023. Never before, the article claims, has so much construction been scheduled in such a short timeframe on one of the world’s densest train networks. Île-de-France residents alone represent 70% of national passenger traffic for the SNCF, France’s state rail company. The map details the vast amount of work is planned, but also shows where major engineering works will result in day-long delays and where track regeneration will cause slowdowns on evenings and weekends. Check out the rest of the podcast episodes here.

RER, Transilien, métro… : des travaux pharaoniques affecteront le quotidien de millions d’usagers d’Ile-de-France en 2023 @lemondefr @ecazi @SophiFay https://t.co/hgpvuNU3W4 A écouter @franceculture dans la chronique les cartes en mouvement https://t.co/BsUS2avoHN pic.twitter.com/5NmtO5QO8x

— Le Monde en cartes (@LM_enCartes) January 8, 2023

Sentencing of US Capitol Rioters

On January 6, 2021, hundreds of people stormed the United States Capitol building to protest against Joe Biden’s 2020 presidential election win. The event triggered the largest police investigation in US history, with more than 900 people federally charged so far for trespassing, participating the insurrection, or other crimes. Two years on, The Washington Post examined the sentencing of more than 300 of these rioters and found that the final punishments meted out by judges were more lenient than the sentencing recommendations of federal prosecutors in more than three-quarters of the cases.

Nice infographic showing Jan 6 sentencing recommendations vs actuals, from the @washingtonpost.https://t.co/2XM1IHVcoc pic.twitter.com/CBTIqhUlUA

— Doug McClurg (@dpmcclurg) January 6, 2023

Savings Calculator for a Life of Luxury

GIJN member organization Rise Moldova revealed the riches of a prominent Moldovan oligarch in a news game, by presenting his belongings as items in a shopping catalog. The team included a calculator for readers to estimate, based on their current income, how many years it would take them to save up money to buy any, or all, of the oligarch’s assets, which include a yacht, a house in France, a business jet, and several luxury cars.

Горжусь собой. Сделала виртуальный магазин на основе расследования про молдавского коррупционера. Тут вы можете выбрать себе виллу, машину и даже самолет, а потом посчитать сколько на это копить. https://t.co/rxJu0yS6rA

— Нервическое существо (@LexTitova) December 27, 2022

On the Brink of Extinction

According to a report by Reuters, records show that at least 881 animal species have gone extinct since the 1500s. However, scientists suspect that the real number is closer to 1,473. Journalists from the wire service dove into the data to examine the extinction risks of threatened species and visualized the last sightings of hundreds of now-extinct animals, including notable species such as the dodo bird.

Get to know them, certain individual #animals, the last of their kind, have names…here's an intimate look at #wildlife species facing extinction – and with their demise entire ecosystems may collapse https://t.co/hcjlxG00I0

— Kathi Lynn Austin (@kathilynnaustin) January 3, 2023

Tracking India’s Government Data Quality

The availability of open government data increases transparency and accountability of a nation’s governance. It can also be very useful for data journalists to track changes, spot trends, and discover concerning issues by analyzing that data. In India, GIJN member organization Indiaspend highlighted the problem of open government data being released in unusable formats and of poor quality. It also reported on delays in the release or collection of 12 of the 20 government datasets they monitor, including crucial information such as the census, household expenditure, and poverty estimates.

An important piece on missing data by @IndiaSpend https://t.co/7CKmsNqCO8

— Pavan Kumar (@pavantimma45) January 4, 2023

New Book on Data Journalism

Mike Reilley, who teaches data journalism at the University of Illinois at Chicago, and Samantha Sunne, who teaches data techniques to journalists at the Society of Professional Journalists, Investigative Reporters and Editors, and at universities, have published a new book titled “Data + Journalism: A Story-Driven Approach to Learning Data Reporting.” The book is intended as a guide, with a global perspective, to reporting data-driven stories. On Twitter, data journalist and director of the Ohio Center for Journalism Lucia Walinchus noted that the book includes tips on Freedom of Information requests and finding free access to court databases such as PACER, as well as interesting historical case studies. Read a bonus chapter on diversity, equity, and inclusion in data reporting.

Thanks for this review, Lucia! Much appreciated. Love the highlights you made in the book. I always do that in textbooks, too!

Anyone who wants to buy the book, you can save $10 on it here. Pass it on:https://t.co/gc7KHg5GtF https://t.co/dKp63FV8Kp

— Mike Reilley (@journtoolbox) January 6, 2023

Thanks again to Marc Smith and Harald Meier of Connected Action for gathering the links and graphing them. GIJN’s Data Journalism Top 10 list is curated weekly.

Eunice Au is GIJN’s global team manager. Previously, she was a Malaysia correspondent for Singapore’s The Straits Times, and a journalist at Malaysia’s New Straits Times. She has also written for The Sun, Malaysian Today, and Madam Chair.

Alexa van Sickle is an associate editor at GIJN. She was previously a senior editor for the foreign correspondence magazine Roads and Kingdoms. She has also been an editor at the International Institute for Strategic Studies and a publisher at an international law non-profit in London. She lives in Vienna, Austria.