Income by Zip, Population by City, Home Ownership Stats – ACS Data from Cybersyn | Hacker News Reader

Income by Zip, Population by City, Home Ownership Stats – ACS Data from Cybersyn

app.snowflake.com

13 pointsizyda9 comments

Unlike the US Census released every 10 years, the American Community Survey is published annually. The data is difficult to wrangle but extremely important. Everything from income by zip-code, population growth by city, and home ownership statistics are published. There are even entire websites dedicated to just selling CSVs of income by zip-code.

Cybersyn made the data easier to work with by releasing it on Snowflake in a consistent, intuitive form.

Docs on this dataset: https://docs.cybersyn.com/public-domain/economic-and-financi...

And docs on our data structure, in general: https://docs.cybersyn.com/getting-started/concepts/unified-s...

It would be far easier if you had a simple JSON endpoint where I can pass a zip code and get the stats. That would be infinitely easier than figuring out things like how did I even use Snowflake?

Fair enough. Right now, our sort of ICP is analytical users on Snowflake.

Was expecting this to be a visualization of the data.

Yeah, our goal is to just make this data easily available in an easy-to-use tabular format in Snowflake. We occasionally visualize our datasets to demo them: https://app.cybersyn.com/home/ but haven't gotten to this one.

Thank you! I have found manipulable (complex cross tabs, time series etc) census and ACS data is really hard to access outside of those services you pay for

Yes, exactly! Sadly, there are entire commercial vendors dedicated to selling cleaned up versions of relatively simple cross-tabs. The ACS does extraordinary data surveying, but is less strong at structuring it, especially for analytical use cases.

If you are looking for future datasets to tackle, may I suggest ATUS or any HNWI-targeted data (not sure there is a public dataset of this last one tho)

ATUS is a great suggestion!

Reply on news.ycombinator.com