At this year’s GEN (Global Editors Network) summit, Google News Initiative shared their notes regarding data journalism resources, particularly for investigative research and verification by online forensics. Here are some excerpts and we get a copy from Google News Lab, which you may find the complete notes attached at the end.
Google Public Data Explorer provides public data and forecasts from a range of international organizations and academic institutions. Visualized data are ready to interpret.
Google Trends compares search terms in a country and timeframe of your choice.
In the past 70 years, Airplane has been an important tool for people to travel long distances. According to IATA annual report In 2016, the major aviation accident rate was 0.39, which was equivalent to only one major accident happen in every 2.56 million flights. This seemingly safe number is built on countless blood and sweat. Step down and turn back a little bit, let’s count the successes and failures in the flying history.
Yearly how many planes crashed? any trend? how many people were on board? how many survived? how many died?
How the distribution of accidents between military and passengers? any insights?
The highest number of crashes by operator and type of aircraft. The relationship between operators and types of airplanes?
Find the airline routes with most accidents and try to find the reasons.
Find any interesting trends/behaviors that we encounter when we analyze the dataset.
History of airplane accidents
Count of accidents by Year
Form the picture, we can see the total accidents trend from low to high before the 1970s. After that, there are some small peaks around 1990 and 2010. But the overall trend after 1990 is gradually going down.
At the beginning of 20 centuries, 1903, Wright brothers invented plane. In 1909, French hold a big flight competition, which threatened the England and other European countries. Even there were many problems with the current planes, the military can’t wait for using it in war. The first time of airplanes’ appearing thus was in Italo-Turkish War. The power of airplane attracted other countries’ military, which leads a huge development in the military aviation industry. From 1914, the first world wartime, airplane mainly used for investigating, transporting, and some peripheral things. At the time of world war II, which is around 1940. Airplanes had widely used in battle. At the same time, World civil aviation organization (IATA) established in Havana, the capital of Cuba in 1945. In 1978, Cater, the president of the USA, signed meaningful a law in the history of American aviation legislation, which is <the airline deregulation act>. The establishment and merger of companies in the US domestic aviation industry, route selection, fare establishment, and even loss-making operations, are basically out of government control and intervention. The number of airplanes grows up fast with the high possibility of air crash occurred. The other reason we consider is that airplane technologies that at that time had weakness and need to improve. With the technologies completed, the amount of air crash will decrease. These situations are obvious after 2000.
There were more than four months after the 2017 Las Vegas shooting, which is the deadliest mass shooting* committed by an individual of the States. As the largest gun-holding ratio (per capita) country around the world, USA has long been debating the gun control, yet, no consensus has been able to achieve. That’s also why media play a huge role in formulating the public debate and policy-making of gun control. We will discuss the two following reports by BBC (America’s gun culture in 10 charts) and The Telegraph (One mass shooting every day: Seven facts about gun violence in America) to illustrate the strengths and limitations of media coverage on the gun control.
It has been more than a year under Donald Trump’s administration. Trump has made a lot of groundless claims and job promises which happen arbitrarily. Some newsagents keep a record of it and visualize the frequency. To criticise the act of the president in a more grounded way, The New York Times compares the lies frequency between Trump’s and the former president Barack Obama. We also dug deeper into one of his promises in his election platform which is job creation and employment enhancement. From which, we adopted a project from ProPublica. The following will discuss the visualization, the use of words and the effects of the two projects.