Introducing Census Explorer

March 08, 2023

The US Census Bureau has a wealth of data, available in a variety of formats. However, it still takes a fair amount of technical acuity to answer questions like "Where are people severely rent burdened?" or "What are the most common places where people work from home?".

This is difficult for a few reasons:

  • Context. You must know where to find the data and how to extract it. Even with knowledge of the US Census Bureau's API, the documentation doesn't always work well in your browser. For example, try searching for median income among all the variables available.
  • Analysis. You may need to filter or aggregate data to answer your question. "Where are the incomes higher than the median income in the US?" requires generating that median value in order to answer the question.
  • Visualization. The shape files for the US Census data can be very large, which can make them difficult to visualize them on a map without knowledge of specialized tooling like ArcGIS or QGIS.
  • Storage. The data is a few gigs in size, which can be burdensome depending on your tooling.

Census Explorer solves these problems by taking advantage of developments in natural language processing that we've seen across a number of GPT-inspired products, as well as our custom software for visualizing large data sets.

Real estate developers trying to understand a market, journalists trying to understand the demographics of a neighborhood, or anyone else trying to understand the US Census data can use Census Explorer to answer these questions and more.

Examples from Census Explorer

Boomtowns

You can see the echo of the 2000s real estate bubble in the ring of suburbs around Las Vegas.

Las Vegas

You can see the shale boom if you ask about housing in the 2010s. In some areas of North Dakota, more than half the homes are from the last decade.

North Dakota

Infrastructure planning

Census Explorer can help policymakers determine where to focus investment in public transportation and internet infrastructure. For example, you can identify areas with low-income people who endure punishingly long commutes, such as in the New York City metro area.

New York City

You can also see that Native American reservations in Arizona have among the lowest internet access in the country.

Arizona

Notes on the data

Right now Census Explorer is a limited subset of the 2016-2021 5 Year American Community Survey data. It is also only available on the ZIP Code Tabulation Area (ZCTA) level. If you are interested in other geographies, surveys, or variables, let us know by dropping us a line at founders@mercator.tech.

Let us know what you think

We invite you to try Census Explorer for yourself and share your favorite results with us on Twitter (@dubo_ai) or LinkedIn (@Mercator). If you have any questions or feedback, reach out to us at founders@mercator.tech. Also, don't forget to sign up for our newsletter to receive updates on new features and releases on our homepage.