Demographic Data

In Australia we have a huge amount of national info in gov census data. That's "joinable" to Tessitura by Geo area (in our case by Local Gov Area).  I did a slideshow of it a while ago if you think it might be relevant.

In Australia we have a huge amount of national info in gov census data. That's "joinable" to Tessitura by Geo area (in our case by Local Gov Area).  I did a slideshow of it a while ago if you think it might be relevant.

Thanks so much Heath.  I've been looking at a few sites here in the states that provide demographic data from our census.  Wondering if anyone has a preference for the most accurate, up to date, and easy to access.

As for your slideshow, if it is easy to pull up and share I'd love to see it (although separate in my work here!).  Thanks again.

I've also just gone to the census bureau's website: https://data.census.gov/cedsci/

The learning curve can be steep, but it's a really powerful tool once you get the hang of it.

It maybe does bear saying that for some topics right now, you're better off taking data from the American Community Survey (ACS), which is updated much more regularly because it's done by sampling and not a proper census (even though the census bureau runs it). When the 2020 census results are all tallied, though, that'll change.

Greetings, Erik!  It depends on the demographic data you're looking for, I suppose.  At the Arsht Center, we've developed a geocoder service interceptor that uses Google Maps APIs (free for non-profits!) to automatically geocode addresses as they are entered or updated -- that is, it translates the address to latitude and longitude.  Once that's done, it's very easy to begin manually or automatically loading demographic data from Census Bureau APIs, GIS APIs, etc.  For instance, using the City of Miami and Miami-Dade County GIS, we append County Commissioner Districts and local "Neighborhoods", which help us better segments customers -- instead of relying on postal code.  And, of course, all of that's loaded into Analytics, for better slicing and dicing.  Admittedly, we haven't yet appended Census Data -- only explored its uses and done some manual analysis.

For manual analysis and data append, we use QGIS and shape files from those GIS services.  If you load the shape files and then latitudes and longitudes, you can output the intersection of addresses in the shape file and basically end up with attributes you can then append to records.  (For geocoding, by the way, i you want to go the manual route, it's relatively inexpensive to get that done in bulk for you.  We used Zeta Interactive to geocode a whole bunch of our addresses before the Geocoder Service Interceptor Plugin.)

Here are some links that might be of help:

Census Bureau APIs (shape files are available for you to append TIGER/Line and Tract data to addresses, which then gives you a path forward for appending actual Census Bureau statistics -- this year's data isn't going to be available, so I'd recommend using the American Community Surveys or more 3/5-year vintages).

* https://www.census.gov/data/developers/data-sets.html

QGIS (free download)

* https://www.qgis.org/en/site/

City of Boston GIS & OpenData

* https://bostonopendata-boston.opendata.arcgis.com/

If nothing else the memes are good 
docs.google.com/.../edit

Thanks for sharing!

Thanks for the help!

I'll take a look at both, thanks for the help!