The advancement of technology and availability of complex data tools have been a real boon to society, but utilizing the wrong tools for the job can have dire consequences. Our NodeXL #ddj mapping from October 5 to 11 finds the BBC and The Guardian reporting on a blunder by the English national health authority: It used the wrong Excel file format to store data, resulting in the loss of thousands of COVID-19 test results. Meanwhile, German television news program ZDF heute highlighted how the Arctic has reached record high temperatures this year; DCist and Spotlight DC examined problem evictions; and we find Information is Beautiful offering a daily feed of uplifting news amid the gloom of 2020’s news cycle.
COVID-19 Data Blunder
Nearly 16,000 COVID-19 test results in England went missing recently. The reason: developers used the wrong Microsoft Excel file format to store the data. The BBC explained that England’s public health agency pulled together coronavirus test data collected by commercial firms in CSV files and inserted them into Excel’s old XLS format, which could only handle about 65,000 rows of data rather than the one million-plus rows that Excel is actually capable of. So when the limit was reached, test results were left off. According to The Guardian, the blunder could have resulted in 50,000 potentially infectious people being missed by contact tracers.
You might never have imagined that the difference between XLS and XLSX could be a matter of life and death, after all we are just talking about Microsoft Excel.
But. This is 2020, and England is learning a COVID Excel lesson!https://t.co/3QLvfLTfIz
— Avinash Kaushik (@avinash) October 5, 2020
Is the 2020 news cycle getting you down? Check out Beautiful News Daily, a collection of charts celebrating good news, positive trends, uplifting statistics, and facts that are easily missed in the flood of hard news. The project, which covers a wide range of topics including quality of life, clean energy, nature, and animals, was launched in October 2019 by Information is Beautiful founder David McCandless.
— Stuart (@BobNottm) October 6, 2020
COVID-19’s US Foothold via Local Travel
By the time the United States implemented nationwide travel bans and regional lockdowns, the novel coronavirus was already spreading across states for months via local transmissions. The Wall Street Journal interviewed disease detectives and reviewed hundreds of pages of genetic, epidemiological, and computational research to establish how COVID-19 spread in the US (paywall). It found that while the country’s leaders were looking overseas for the cause of new infections, the earliest cases in many states most likely resulted from domestic travel.
Key point from this new WSJ story, and something to remember when Trump touts his China travel ban: "While the country was still looking outward, researchers now believe the earliest infections in many states came mostly from travel within the U.S." https://t.co/ZqkdUzAtKS pic.twitter.com/nNHTkJ2MMx
— Eric Geller (@ericgeller) October 9, 2020
Fires in the Arctic
Verkhoyansk, located in Russia’s Arctic region and usually one of the coldest places on Earth, saw temperatures reaching 38 degrees Celsius this summer — the highest temperature ever recorded in the Arctic. More fires also broke out in the region in 2019 and 2020 compared to previous years. German television news program ZDF heute used satellite imagery to illustrate findings by climate researchers and explain the effects of global warming in the area.
— ZDF heute (@ZDFheute) October 6, 2020
In a nine-month investigation, DCist and Spotlight DC, which are both based in the US capital, found more than 600 eviction cases containing discrepancies that if brought to a judge’s attention, would likely have resulted in the case being dismissed. The team pieced together the evidence by poring through more than 13,000 pages of court records, reviewing hours of security camera footage, and conducting nearly 60 interviews. Journalist Josh Kaplan summarizes the investigation’s findings in this tweet thread.
Last year, I started going to DC eviction court and was shocked by how many tenants lost their cases simply because they didn't show up. I started trying to understand why, and the answer was much stranger & more disturbing than I imagined. https://t.co/FEtgwOpwwN
— Josh Kaplan (@js_kaplan) October 6, 2020
Mapping a Kyrgyz Family Empire
The Organized Crime and Corruption Reporting Project, Kloop, Radio Azattyk, and Bellingcat jointly investigated a Kyrgyz family’s customs empire and how it used its power to influence important political processes in Kyrgyzstan. See an interactive map of the family’s property, which includes luxury apartments and valuable retail space.
Посмотрите интерактивную карту имущества влиятельного кыргызского клана Матраимовых. Это больше двух десятков объектов от элитного жилья до ценной торговой площади, о большая часть из этого не указано в декларациях братьев-чиновников. https://t.co/6Jt9dE6WaU pic.twitter.com/1iteWODcgr
— Kloop (@kloopnews) October 2, 2020
Should We Make Election Forecasts?
Should news outlets stop making election forecasts based on polling data? Nieman Lab’s Joshua Benton examines this question and dives into the complexities of election forecasting models, asking whether they help or confuse voters. Bonus link: Mapbox is organizing a free webinar on visualizing election data and mapping untold stories.
I think this is a very reasonable read on the consequences of election forecasts and covers a lot of things I've been trying to say on this subject for some time now, from @jbenton https://t.co/KTGL7ZVQVQ
— G. Elliott Morris (@gelliottmorris) October 7, 2020
Partisan Differences on the Pandemic
A Pew Research Center study finds major partisan gaps when it comes to perceptions of the COVID-19 pandemic, and deep disagreement between Democrats and Republicans on how the US has handled the outbreak. About two-thirds (68%) of Republicans and independents who lean Republican say the country has done about as much as it could to control the outbreak. But only one-in-ten (11%) Democrats and independents who lean Democratic hold that view.
Insane new @pewresearch data proves your media source determines your reality.
— Bruce Mehlman (@bpmehlman) October 8, 2020
Seclusion in Schools
Two decades ago, the US state of Illinois passed laws intended to protect students from being locked away in rooms as punishment or physically restrained to get them to behave. Although the legislation required schools to document each “isolated timeout” incident in detail, these records are not submitted for review to any state agencies. The Chicago Tribune and ProPublica Illinois filed public records requests to access these documents and created a database with more than 20,000 such incidents. An analysis revealed that a significant number of children were isolated for reasons that violate the law. This investigation just won the Online News Association Award for Investigative Data Journalism.
— Jodi Cohen (@Jodiscohen) October 8, 2020
Vulnerability to COVID-19 in England, Wales
British newspaper, magazine, and digital publisher Reach (formerly known as the Trinity Mirror) created an interactive for residents in England and Wales to see how vulnerable their area is to the coronavirus based on their postcode. Its analysis is based on data on excess deaths and population demographics, plus economic and social factors.
Check out our latest postcode-search interactive, which uses hyperlocal data to reveal your area's vulnerability to a second wave of #coronavirus: https://t.co/WNhYhG5ef6
A really in-depth tool spearheaded by @_BvdM, our @GoogleNewsInit fellow 👏👏👏 #ddj #dataviz #opendata pic.twitter.com/557fNHzxhm
— Annie Gouk (@AnnieGouk) October 5, 2020
Eunice Au is GIJN’s program manager. Previously, she was a Malaysia correspondent for Singapore’s The Straits Times, and a journalist at the New Straits Times. She has also written for The Sun, Malaysian Today, and Madam Chair.
For a look at NodeXL’s mapping on #ddj and data journalism on Twitter, check out this map.