Open Street Map (OSM) is an incredibly powerful open-source geospatial platform, backed by a community of mappers. One of the most exciting parts of Open Street Map is the Overpass API, a read-only API for querying parts of the OSM map data like Points of Interest (POIs). We’ve ingested, processed, structured, and exposed all POIs in the US available on Open Street Map, and we’ve made them available with simple queries in Column’s API.
The American Housing Survey is a survey conducted by the U.S. Census Bureau which gives a detailed look at housing trends in the United States. We’ve loaded, parsed and data from the American Housing Survey for 2017, 2019 and 2021. Additionally, we’ve split out the sections of the dataset that are all currently combined into one massive table into separate API endpoints.
ACFRs are PDFs with hundreds of pages. They detail everything from outstanding bonds, construction projects, and projected taxation rates. We’ve compiled over 1000 ACFRs from counties in all 50 states, extracted the net position statements, converted the tables to CSV format, and added them to our API.
As of July 1st 2022, the federal government introduced a new disclosure requirement: all health insurance providers must disclose their negotiated rates with all healthcare providers across the US. We’ve removed the burden of scraping, structuring, formatting, and compressing large swaths of negotiated rate information and opened it up to the public.