Forum Discussion

ThomasDay's avatar
ThomasDay
Impactful Individual
6 years ago
Solved

Simple US Census Data Feed?

Hello all, This probably falls into the "is it really this hard?" category, but I was hoping to find a simple way to get Population and Income data by zip code (a Zip Code Tabulation Area).  The mos...
Need Help
  • ThomasDay's avatar
    ThomasDay
    6 years ago

    Hello all and v-lid-msft 

    I did piece together a simple query using a json example from the census data api.  Here it is if anyone is looking to jumpstart their census exploration process.  It's easy to get an API key...just "apply" here: https://api.census.gov/data/key_signup.html As you look thru the api offerings, you'll see descriptions, variables, geographies (who knew this could be so confusing), groups, examples (sample api URL's)...which I've put in the Json.Document Function below in the simple PowerBI query..  There are keywords and parameters but this gets anyone going.

    I've lined out the key in the example below

    The table that this produces is shown, in part, here.  So that gets stuff into PowerBI

    Ok, enjoy,

    Tom

edhans's avatar
edhans
Community Champion
6 years ago

You are probably going to have to start here - https://data.census.gov/cedsci/ -  and become a bit of an expert. Some of the data is available via API, and some is exportable to Excel/CSV after a query. Not sure how much will be available via a simple web request.