4 ms·
Income by Zip, Population by City, Home Ownership Stats – ACS Data from Cybersyn
- izyda 3y agoUnlike 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-financial/govtessentials 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-schema https://docs.cybersyn.com/getting-started/concepts/unified-s...
- altdataseller 3y agoIt 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?
- izyda 3y agoFair enough. Right now, our sort of ICP is analytical users on Snowflake.
- smlavine 3y agoWas expecting this to be a visualization of the data.
- izyda 3y agoYeah, 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/ https://app.cybersyn.com/home/ but haven't gotten to this one.
- hammock 3y agoThank 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
- izyda 3y agoYes, 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.