Posts in Visualise
The Novel Coronavirus - a Pandemic Disease Visualised
 

The Novel Coronavirus (2019-nCoV) has caused global alarm as the originally defined pneumonia cluster found in China has spread beyond its original source into upwards of 25 countries.

To keep you informed with the latest statistics on where it’s being diagnosed and how it’s being contained, the team at White Box Analytics have extracted the most up-to-date World Health Organisation data on the virus, providing you with an updated source on the numbers behind the virus.

 

The visualisation paints a picture about where the coronavirus is concentrated, as well as the countries it has spread to since its identification in early January. The map of China sheds light on the high number of occurrences in Hubei, where the Wuhan seafood and live animal market thought to be the source of the virus, is located. Latest updates of WHO data shows this number is now in excess of 27,000 diagnoses in Hubei alone.

The trends and incremental change component of the visualisation further shows the exponential-like growth in the spread of the virus, acting as an alarming warning sign for the world, particularly those who have or are likely to travel to majorly affected locations. The WHO is however implementing a number of strategies to combat the virus that is yet to have a vaccine or proven treatment (see below).

Update 19th February 2020

This last week has been very fascinating in terms of how the Coronavirus is both being diagnosed, and how it is impacting the societies and economies of China and those related to it.

An issue with the virus has been that it has taken approximately two weeks to diagnose (using medical diagnostic tests) each person affected. The problem with using the diagnostic test as the sole measuring tool is that, due to the huge number of people picking up the virus on a daily basis, hospitals have not been able to test all people likely to have picked it up. By changing the diagnosis criteria to include those people who have been clinically diagnosed, many reports have shown a huge spike in the number of new diagnosed cases. Take, for example, this John Hopkins University chart showing new diagnosed cases, using the new criteria.

John Hopkins University Data

The jump reflects the first day the new criteria came into place. Despite this rise, however, the World Health Organisation have not changed the way they are recording the number of diagnoses. Looking at our visualisation now, we have updated it so you have the option to filter between clinically diagnosed and laboratory confirmed cases, as well as total cases which includes both. This paints an important picture about the way data is presented in the news, and in business projects; we need to be consistent with the way we use data, and when changes are made, stakeholders need to be informed so that there aren’t misconceptions about its implications.

In terms of its impact on the Chinese economy, Chinese e-Commerce giant Alibaba has rolled out a number of measures through its retail platform Tmall, to minimise the impact of Coronavirus on businesses using its marketplace. These measures include providing a free set-up tool (to launch on the platform), cutting annual service fees for the first six months of the year, and lowering automatic settlement, interest and trading related fees (source).

Despite these efforts however, the impact is having a huge effect on both China and the rest of the world. A New York Times update today (19/02/2020) has reported that more than 10% of China’s population are confined to their homes. This confinement has taken its toll, leading Hong Kong bank, HSBC, to plan to cut up to 35,000 jobs with reported losses of $4.5 billion (source).

Information about the virus

Origin -

It has been reported that the likely source of the virus was the Huanan Wholesale Seafood Market in Wuhan (source).

Symptoms -

The coronavirus exists in a number of forms and is associated with respiratory and gastro-intestinal issues often associated with a common cold or the flu. These symptoms vary from mild to moderate.

Current strategies for prevention -

Education through online training - informative articles and video tutorials about the source, spread and warning signs of coronavirus. By identifying the signs and symptoms identified above, people can help prevent the further spread of the virus.

Accelerating research and innovation - The WHO is playing a coordinating role by bringing the scientific community together, identifying key research priorities. It will produce a global research agenda and a framework to decide which projects are undertaken first. The aim will be to fast-track development and evaluation of effective diagnostic tests, vaccines, and medicines, and to bring affordable access to vulnerable populations, leveraging community engagement.

Expenditure for global preparedness - a US$675 million preparedness and response plan has been developed to cover strategies to combat the virus between February and April 2020.


For the latest updates, visit this page or follow White Box on LinkedIn.

 

For more fascinating visualisations and data stories, click here.

 
VisualiseLouis Keating
Brexit and the next James Bond; how do they mix? - Visualisation

How do Brexit and the next James Bond character relate? Ije Ireumi’s Monday Makeover chart from a YouGov survey reveal Brits who voted to leave the EU do not wish to accept a non-british nationality, gay or female person playing the next James Bond character. Did you spot any other interesting insights in this data visualisation?

 

For more fascinating visualisations and data stories, click here.

To keep up with all things data and White Box, follow us on our LinkedIn page.

 
VisualiseLouis Keating
Harmful Pesticide Usage in the US - Visualisation
 

This week we welcomed Sai Diwakar Bhrugubanda to the White Box team. Sai has kicked things off with an interesting visualisation on the usage of harmful pesticide ingredients in the United States, relative to their respective usage in other countries including China, Brazil as well as the continent of Europe.

Context

The United States of America (USA), European Union (EU), Brazil (BRA) and China (CHN) are the largest agricultural producers and users of agricultural pesticides in the world, accounting for more than 50% of all global agricultural production.

Comparing the inclination and ability of different regulatory agencies to ban or eliminate pesticides that have the most potential for harm to humans and the environment provides us with a glimpse into the effectiveness of each nation’s pesticide regulatory laws and oversight.

The Data Sample

Pesticide Action Network (PAN) International maintains a list of pesticides that are banned in various countries. However, because of drawbacks with the data the analysis was done independently of PAN international list. Despite this, many of the same sources were used.

The United States Geological Survey (USGA) National Water-Quality Assessment Project maintains an online resource of annual pesticide use estimates for all pesticides in USA agriculture from 1992 forward.

We proceeded to plot data points for a 25 year period, from 1992 - 2016, with the approval status of over 500 agricultural pesticides used in the USA compared with the number approved in the EU, Brazil and China.

Statistics

Comparing the list of 500 active pesticide ingredients used in agricultural application in the US since 1970, the following countries banned a large number of them:

  • Europe - 72 ingredients,

  • Brazil - 17 ingredients,

  • China - 11 ingredients ,

  • And at least one other country within the data set banned 85 ingredients.

Considering the great deal of banned ingredients among other countries compared to the US, the quantity of pesticide use is alarming - China being the greatest consumer whilst seemingly having the least stringent regulations on dangerous pesticides.

 

Consumption of Pesticides

 

More than 10% of the total pesticide use in the USA in 2016 was from pesticide ingredients either banned, not approved or of unknown status in Brazil, China and the EU, a huge figure considering the enormity of US agricultural production.

Discussion

Of the pesticides banned in at least two of these nations, many have been implicated in acute pesticide poisonings (poison exposure to a single dose / repeated small amounts of doses of pesticides) in the USA .

From 2000 – 2015 there were over 1000 pesticide illnesses in California alone (largest agriculture producing state by value), with up to 100 poisoning incidents in the USA each year.

Worryingly, there has been 1 death per year since 2012 as a result of pesticide poisonings. On top of this, from 1990 -2014, there were 27 deaths, as well as 22 high-severe and 181 moderate-severe cases of illness.

Specifically, the National Indicate for occupational safety and health indicate between 1998 and 2011 – 43% of insecticide related illness in the USA involved cholinesterase.

Over 45 million pounds of agriculture pesticide use in the USA comes from the 13 pesticide that are banned or in the process of being phased out in at least two of the three other agricultural nations.

However 10 of the 13 are either banned, being phased out, not approved of unknown status in all three.

Conclusion

Total pesticide bans remain the most effective way to prevent intentional or accidental exposure to highly hazardous pesticides and can catalyse the transition to safer alternatives . Surprisingly, the USA is lagging when it comes to banning or phasing out pesticides that the top agricultural powers have identified as too harmful for use.

This is likely due to deficiencies in pesticide legislation in the USA. FIFRA gives the US EPA significant discretion on which pesticides it ultimately decides to cancel and makes the US EPA-initiated, non-voluntary cancellation process particularly onerous and politically fraught. This, in part, has led to an almost exclusive reliance on industry-initiated, voluntary cancellation of pesticides in the USA.

Without a change in the US EPA’s current reliance on voluntary mechanisms for pesticide cancellations, the USA will likely lag behind its peers in banning these harmful pesticides. Recent mitigation measures finalized by the US EPA, which include warning labels, extra training requirements and safer packaging standards that are fully supported by the pesticide industry, indicate that voluntary mitigations will likely be used in lieu of cancellations for at least some of these dangerous pesticides in the future.


This visualisation was created by Sai Diwakar Bhrugubanda.

For more fascinating visualisations and data stories, click here.

To keep up with all things data and White Box, follow us on our LinkedIn page.

 
VisualiseJack Sloman
Sydney lock-out laws interactive map
 

Methodology

We looked at four key crime offences (domestic and non domestic violence related assault & offensive language and conduct), from 59 months pre lock-out (Mar-09 to Jan-14) compared to 59 months post lock-out (Feb-14 to Dec-18).

Data from Bureau of Crime Statistics and Research.

Highlight zoning includes the lock-out zone, proximal displacement and distal displacement areas.

We have also contextualised by showing the NSW overall trend.

 

Interactive map

Hover over any suburb to see the volume of crimes before and after the lock-out laws were introduced.

Use the filters at the top to highlight zoning and see specific crimes.

You can also pan and zoom in/out using the options in the map (top left).

If viewing on a mobile device, you can also use this link to view the desktop version.

 

Analysis

Using this tool and data, we have summarised the findings in this analysis.

If you’d like to discuss how we can help you use data for insights, get in touch or look for more inspiration here.

Melbourne Cup Challenge
 

For this years Melbourne Cup, we’ve pulled together the last 20 years of runners and winners and created a game to test your gambling strategy. Most people choose by name or jersey colour, so time to find out how good that method is! Odds are, the bookie will come out on top…

If you have issues viewing on a mobile, click here but we suggest you use a laptop for the best experience.

 
VisualiseLouis Keating