Looker Blog : Data Matters

The Data Has Spoken. Amazon’s HQ2 Should Be In....

Haarthi Sadasivam, Product Marketing Manager

Jan 26, 2018

If you’ve been on the internet in the past few months, you’ve already heard that Amazon is opening a massive new facility. Hundreds of cities across the U.S. have applied, hoping to get the chance to be the retail giant's next headquarters.

Last week, Amazon revealed their top 20 contenders, and the list ranges from long-established metropolitan areas like New York and Chicago, to emerging tech hubs like Denver and Austin. Bold outer boroughs of major metropolitan areas like Montgomery County, Maryland and Northern Virginia also threw their hats into the ring in a noble attempt to bring much-needed revenue and jobs to their community.

To help Amazon work through this varied list, we thought we’d share some data on the matter, direct from a reliable source: The 2015 Census.

The 2015 Census data (from this Data Block) offers a look into demographic data revolving around population, education, income, and diversity at a very granular level.

How We Broke It Down

Of the metrics presented from the Census, we selected 4 key factors to examine for each of our Amazon contenders. The factors listed below represent factors that any company looking to open an office of this size should consider.

  • Population density: Does a city possess growing room to handle a large influx of new workers?
  • Housing Vacancies: Will it be easy for new and relocated hires to find housing?
  • Diversity: Will the gender and racial distribution across each of these locations attract outside talent?
  • Education Achievement: Will Amazon be able to leverage the existing educated population of the location?

We took these factors and evaluated the top contenders in the nation from Amazon’s shortlist. For every factor, each city was assigned a score from 1-5 based on the quintile that the city fell into. The sum of these scores were used to determine the overall rank of each city.

And with 24 out of a possible 25 points, the Chicago Metropolitan Area emerged as a clear winner. Chicago was closely followed by Los Angeles and Atlanta, both with 22 points.

Chicago’s highly educated population and large amount of available housing makes it a perfect fit for Amazon’s expected 50,000-person workforce.

While these factors were not comprehensive, they provide us with a better lens to determine the overall suitability of a city to be the next Amazon HQ. Take a look at our rubric to see how our top pick Chicago ranked against other cities:

Please Note: We did this analysis with the US Census Data Block, so we were unable to include Toronto

Metropolitan Area Population Density Housing Vacancies Diversity (Race) Education (Bachelors) Education (Masters) Total Score
Chicago, IL 5 5 4 5 5 24
Atlanta, GA 5 4 5 4 4 22
Los Angeles, CA 3 5 4 5 5 22
Dallas, TX 5 4 3 5 4 21
New York City, NY 1 5 5 5 5 21
Miami, FL 4 5 3 4 3 19
Philadelphia, PA 3 4 3 4 4 18
Boston, MA 2 4 2 4 5 17
Denver, CO 5 3 1 3 3 15
Northern VA 2 2 4 3 4 15
Pittsburgh, PA 4 3 1 3 3 14
Austin, TX 4 2 2 3 2 13
Columbus, OH 3 3 2 2 2 12
Indianapolis, IN 3 3 2 2 2 12
Montgomery County, MD 2 1 4 1 3 11
Nashville, TN 4 2 2 2 1 11
Raleigh, NC 2 2 3 2 2 11
Newark, NJ 1 1 5 1 1 9
Washington DC 1 1 5 1 1 9

How did we arrive at these numbers? Let’s dive deeper into the census data.

Population Density

Amazon’s new office will be designed to hold 50,000 employees. While in reality, this population will be a combination of local hires and relocated hires and their families, an upper threshold for the local population increase could, theoretically, be as much as 100,000+ people.

Which of the cities above has enough growing room to handle that large of an influx of new people?

Denver tops the list with the lowest population density (ratio of average number of people per square mile) of the group followed closely by Austin. On the other end of the spectrum are New York City and DC, cities which already possess an extremely high population density.

Available Housing Infrastructure

Equally as important as the existing population is the availability of housing for the relocated hires.

So what about housing vacancies in these cities?

Chicago, our top pick, and Miami have by far the most available housing and could easily handle a significant increase in households. Cities like DC or Montgomery County on the other hand may have to rapidly adjust and invest in real estate projects to accommodate new Amazon workers.

Educational Level

The likelihood of Amazon bringing in ALL relocated hires for this new outpost is very unlikely, so another important consideration is the existing workforces of each city. We decided to look at the education level of each city’s current population to see what Amazon can potentially tap into.

How many Undergraduate and Graduate degree holders already live in these cities?

Areas like Northern Virginia and Montgomery County tend to have a higher % of the population (>30%) with a Bachelor’s degree or higher. But for the sake of Amazon’s move, we ranked metropolitan areas with a bigger population of degree holders (even with a slightly lower % of population with degrees) higher on the list. Chicago and LA are both looking pretty good with some of the highest number of college grads of the group!

Diversity (Gender and Race)

Amazon’s ideal workforce is made up of a diverse group of people. All of the cities that we’ve looked at have an almost equal distribution of Gender ratios -- so we felt best to remove Gender from our ranking algorithm. This doesn’t necessarily hold true for race.

Could a particular location's lack of diversity deter Amazon from attracting and relocating the best talent?

New York City and Washington DC top the diversity list, both with over 50% of their populations made up of non-white individuals. But the drop-off on this list is steep. Our top pick, Chicago ranks in the second highest Quintile with only 32% of the population identifying as non-white, and Pittsburgh is in last place, with only 11% of their population identifying as non-white.

While this is not a definitive pro-con evaluation of the potential cities for Amazon’s HQ2 -- other considerations like tax benefits and household prices are among those that come to mind -- our rankings provide a stepping stone to look at these cities more objectively and provide a way for Amazon to keep their employees and the local community in mind while expanding.

All of this data is available right now for free for all Looker customers. Check out Looker Data Blocks and easily connect to Looker Hosted offerings in a matter of minutes! Or reach out to our support team and to get started.

Next Previous

Subscribe for the Latest Posts

Recent Posts