Data & Graphics

GIF: Dams on Yangtze (Three Gorges) and Euphrates

Michael Data & Graphics, Interactive, Photo May 2, 2016

NASA reminded me again of its satellite images of the Three Gorges Dam before and after the construction of the dam. Here below I dug up the before and after images and present in a simple GIF, watch for the tremendous expansion of the water surface on the Yangtze River and its numerous tributaries in this mountainous region:

Three Gorges Dam: 2000-2006 Views from Satellite (via NASA)

Three Gorges Dam: 2000-2006 Views from Satellite (via NASA)

Here below is another extreme case of changes, the human extraction of water largely contributing to the sudden shrinking of reservoir along the Euphrates River:

Shrinking of Qadisiyah Reservoir between 2006 and 2009 (via NASA)

Shrinking of Qadisiyah Reservoir between 2006 and 2009 (via NASA)

Scientists using the twin gravity-measuring satellites of the Gravity Recovery and Climate Experiment (GRACE)have found that a large portion of the Middle East lost freshwater reserves rapidly during the past decade. The research team observed the Tigris and Euphrates river basins—including parts of Turkey, Syria, Iraq, and Iran—and found that 117 million acre feet (144 cubic kilometers) of fresh water was lost from 2003 to 2009. That amount is roughly equivalent to the volume of the Dead Sea. About 60 percent of the loss was attributed to the pumping of groundwater from underground reservoirs.

The New Video King: Facebook (Sorry YouTube)

Michael Data & Graphics, Video April 28, 2016

This genius rapper and YouTuber has been a massive inspiration, an eloquent communicator and has caught my attention time and time again. What’s also becoming interesting to me is that even though YouTube should have been the primary platform for such an amazing artist, yet Facebook has emerged as the new overload on the scoreboard, by a LOT!

The first piece that wowed me was “Dear Future Generations: Sorry” about our need, as a species, to care for the planet and our environment, registering 108 million views on Facebook, and 2.8 million views on YouTube, as of today. (See some more of his awesome pieces at the end of this post)


Here below are the scoreboard tallying YouTube (red) and Facebook (blue) views of some of his videos:

More here… (You can always follow him on Facebook and YouTube)


Ogilvy’s Vertical: Viewing the World Right-side Up Report

Michael Data & Graphics, Video April 27, 2016

An absolute fascinating read and data crunching from Ogilvy & Mather’s social team, with Kristen Rodriguez and Robert John Davis, Executive Director of Strategy for Content and Social. Highlights:

  • Mobile devices will account for 58% of online video watching worldwide in 2017, according to ZenithOptimedia
  • Phones are kept in portrait mode 98% of the time, according to Mobile Marketer
  • 29% of the time Americans spend watching video now occurs vertically, 5% in 2010, KPCB 2015 Internet Trends
  • Vertical content receives completion rates 9x higher than horizontal counterparts, Snapchat
  • Millenials are twice as likely to be focused on video they watch on their mobile devices as they are on video consumed on a TV, Ooyala Global Video Index Q4 2015

Audi – Audi has launched several campaigns using vertical media on Snapchat. In 2015, an Audi campaign around the brand’s involvement in the Le Mans race, a 24-hour race of endurance in France, “delivered a 36 percent video completion rate, which is 80 percent higher than automotive benchmark at Celtra, the ad tech partner on the effort.“ (Mobile Majority). The campaign repurposed TV assets by cropping them to the vertical aspect-ratio while also shortening them to 8-seconds.

Taco Bell – Taco Bell leveraged Snapchat to film a 4-minute short film called “Rush Order” starring Vine and Snapchat influencers during the 2014 MTV Movie Awards to announce the new Doritos Locos Taco. The video achieved 74 million impressions and the brand doubled its number of followers in just one day.

Viacom (below) – For the 2015 MTV Video Music Awards, Viacom partnered with Snapchat for a Live Story that drew on content from users who were given exclusive access. In addition to sponsoring the story itself, they also produced four 10-second ads shown during the Live Story. Over 12 million viewers tuned into the content, exceeding actual broadcast viewership of 9.8 million.

IAB: Internet Ad Revenue Growth 2005-2015

Michael Data & Graphics, Interactive April 22, 2016

According to IAB, the internet ad revenue has been growing rapidly over the years, despite a dip for just one year after the 2008 financial crisis. The mobile-based revenue growth has been particularly exponential, posting an average annual growth rate of 100% from 2010 to 2015 vs. non-mobile’s 9% during the same period. see interactive chart below:

Some highlights:

  • Mobile advertising skyrocketed to $20.7 billion during FY 2015, a 66 percent hike over the 2014 total of $12.5 billion
  • Digital video (non-mobile), a component of display-related advertising, reached $4.2 billion in 2015, a 30 percent rise over $3.3 billion in 2014
  • Social media advertising brought in $10.9 billion in 2015, up 55 percent over 2014’s $7 billion
  • Search (non-mobile) revenues reached $20.5 billion in 2015, up 8 percent from $19 billion in 2014
  • Display-related advertising (non-mobile) revenues in 2015 totaled $13.9 billion, representing 23 percent of the year’s revenues, an uptick of 3 percent over $13.5 billion in 2014
  • Retail advertisers continue to represent the largest category of internet ad spending, responsible for 22 percent last year, followed by automotive and financial services which each accounted for 13 percent of the year’s revenues

GIF: Shrinking Lake Mead, Expanding Las Vegas

Michael Data & Graphics, Interactive, Photo April 11, 2016
Lake Mead 1984-2016

Lake Mead 1984-2016, via NASA Earth Observatory

Lake Mead main body on Hoover Dam side, 1984-2016

Lake Mead main body on Hoover Dam side, 1984-2016

Las Vegas and Hoover Dam 1984-2016

Las Vegas and Hoover Dam 1984-2016

Lake Mead 2000-2015, via NASA

Lake Mead 2000-2015, via NASA

Lake Mead formed in 1930s following construction on the Hoover Dam along the Colorado River. At maximumcapacity, the reservoir would hold 36 trillion liters (9.3 trillion gallons); water in the vicinity of the dam would have an elevation of about 372 meters (1,220 feet) above sea level. In July 2000, the lake level was relatively high at 366 meters (1,200 feet). By July 2015, however, the level had dropped to 329 meters (1,078 feet).

Read full post at NASA Earth Observatory.

4.11 This Week in Numbers

Michael Data & Graphics April 11, 2016

From Polygraph:

To begin answering these questions, we Googled our way to 8,000 screenplays and matched each character’s lines to an actor. From there, we compiled the number of words spoken by male and female characters across roughly 2,000 films, arguably the largest undertaking of script analysis, ever.
Screen Shot 2016-04-11 at 11.42.25 AM

From Ian Bremmer via LinkedIn:

Sec State travel records
1 John Kerry: 1.06m miles (81 countries)
2 Condoleezza Rice: 1.059m (85)
3 Hillary Clinton: 956,733m (112)

Total Wealth of Female Billionaires
1 China $95.4B
2 US 28.8
3 UK 4.9
4 Spain 4.6
5 Italy 2.4
5 Nigeria 2.4
7 Australia 1.8
8 Brazil 1.4

Japan’s demographic shift

World Map of Internet Penetration

4.4 This Week in Numbers

Michael Data & Graphics, Photo April 6, 2016

From Ian Bremmer via LinkedIn:

Data leaked
Panama Papers, 2016: 2.6 TB
Offshore secrets, 2013: 260 GB
HSBC files, 2015: 3.3 GB
WikiLeaks, 2010: 1.7 GB

Who’s reporting about Mossack Fonseca (or not)

Executions in 2015
China: 1,000+
Iran: 977
Pakistan: 326
Saudi Arabia: 158
US: 28
Iraq: 26
Somalia: 25
Egypt: 22
Indonesia: 14
Chad: 10

GIF: Urbanization DC and Pearl River Delta

Michael Data & Graphics, Photo, Video March 30, 2016

Watch where urbanization sprawls in and around the U.S.’s capital between 1984 and 2010, via NASA Earth Observatory:

Any surface that water cannot pass through—for instance, rooftops, roads, parking lots, and sidewalks—is considered impervious.

The maps above show the extent of impervious surfaces in 1984 (top) and 2010. Areas with the greatest concentration of impervious surfaces are depicted with dark blue; areas with the lowest concentration of impervious surface areas are white.


Here’s a much more dramatic urbanization case study, China’s Pearl River Delta area, where you can see the rapid development of Guangzhou, Shenzhen, Dongguan between 1988 and 2014, also thanks to NASA Earth Observatory:


3.28 This Week in Numbers

Michael Data & Graphics March 29, 2016

Via LinkedIn:

From Ian Bremmer via LinkedIn:

US foreign-born population
1965: 9.6 million
2015: 45 million
2065: 78 million (projected)
(h/t pewresearch)

% Population 60+
Developed world
1950: 12%
2011: 22%
2050: 32%
Developing world
1950: 6%
2011: 9%
2050: 20%
(h/t @wef)

Share of world’s Muslim population
Indonesia: 13.1%
India: 11.0%
Pakistan: 10.5%
Bangladesh: 8.4%
Nigeria: 4.8%

Net favorability among women
Kasich: +18
Sanders: +15
Clinton: -3
Cruz: -16
Trump: -47
Net favorability among men
Kasich: +20
Sanders: +6
Cruz: -15
Clinton: -20
Trump: -22 (Gallup)

3.21 This Week in Numbers

Michael Data & Graphics March 23, 2016

From Ian Bremmer via LinkedIn:

Govt Debt 2007-15 (% of GDP)
US: 64% to 105%
Eurozone: 65% to 95%
Japan: 183% to 243%
China: 35% to 43%
India: 74% to 64%

US shrinking contribution to global growth
1996: 28.3%
1997: 29.6%
1998: 47%
2016: 20.9%
2017: 17.4%
2018: 15.7%

Brexit estimated economic cost to UK (by 2020):
£100 billion
950,000 jobs (Conf of British Industry)

Who wants a referendum on EU exit?
France: 53%
Sweden: 49%
Spain: 47%
Germany: 45%
Poland: 39%
Ireland: 38%

3.14 This Week in Numbers

Michael Data & Graphics March 15, 2016

Data viz video from GOOD:

Screen Shot 2016-03-15 at 11.22.50 AM

Click image to watch video “If The World Were 100 People”, simply amazing

From Ian Bremmer via LinkedIn:

If US cities were countries… (GDP)
NY = Australia
Miami = Singapore
LA = Netherlands
Chicago = Switzerland

Internet users, per 100 people
Norway: 96
UK: 91
Japan: 90
US: 87
Russia: 70
Turkey: 51
China: 49
India: 18
Indonesia: 17

Trump’s winning strategy: free media

3.7 This Week in Numbers

Michael Data & Graphics March 9, 2016

From Ian Bremmer via LinkedIn:

30% of all maritime trade travels through the South China Sea.

China stock-market value.
June, 2015: $10 trillion
Feb, 2016: $5.7 trillion

Hispanic eligible voters in the US (millions)
1988: 7.7
2000: 13.2
2008: 19.5
2016: 27.3

The world’s billionaires:
US & the Americas: 641
Asia-Pacific: 590
Europe: 489
Middle East & Africa: 90

Women in 2015 earning what men did ten years ago

World Population in 1950: 2.53 billion

Willing to fight for their country
Pakistan 89%
India 75%
Kenya 69%
Russia 59%
Greece 54%
Nigeria 50%
US 44%
France 29%
Germany 18% (Gallup)


2.29 This Week in Numbers

Michael Data & Graphics March 3, 2016

From Ian Bremmer via LinkedIn:

Who countries consider top threat to world peace (Gallup)

Total raised by candidates & super pacs ($ millions)
Clinton 188.0
Cruz 104.2
Sanders 96.3
Rubio 84.6
Carson 68.0
Trump 27.3
Kasich 27.3

Net favorability among Hispanic voters
Clinton: +37%
Sanders: +37%
Rubio: +8%
Kasich: +6%
Cruz: -5%
Trump: -64% (WaPo)

Worldwide terrorist-related deaths
2002: 725
2010: 13,186
2014: 32,727

London’s importance to EU
2.9% of population
4.5% of GDP

NYC’s importance to US
6.3% of population
8.1% of GDP