Socrata Open Data API Query (SoQL) for Government Portals

Returns rows from any dataset on a Socrata open-data portal (NYC, Chicago, Seattle, CDC, state portals) via the official SODA API with SoQL filters, plus dataset metadata and columns, or a keyword search of 500+ portal catalogs. Honours robots.txt. Priced per 100 rows.

Pricing

from $10.00 / 1,000 100 rows returneds

Rating

0.0

(0)

Developer

lathewright LLC

Actor stats

Bookmarked

Total users

Monthly active users

7 days ago

Last modified

Socrata Open Data Scraper: SODA datasets to CSV/JSON

datamule/socrata-soda-extractor

Export rows from any Socrata open-data portal (NYC, Chicago, WA, SF) by domain + dataset ID, with optional SoQL filters. Also lists a portal's datasets or a dataset's columns. Returns JSON/CSV/Excel rows, no API key. $0.0005 per record (about $0.50 per 1,000).

Datamule

Socrata Open Data Scraper | SoQL Filters, No API Key

themineworks/socrata-open-data

Search and pull datasets from any Socrata government portal (CDC, HHS, CMS, NY, NYC, Texas, 100s more). SoQL filtered queries, structured JSON, no API key, no anti bot. Works in Claude, ChatGPT and any MCP agent for instant public data access.

The Mine Works

SQL Query

useful-tools/sql-query

Run SQL queries over Apify Platform (currently supports only Datasets).

Useful tools

Data.gov API - US Open Government Datasets

alizarin_refrigerator-owner/data-gov-api---us-open-government-datasets

Access the Data.gov catalog of 300,000+ US government datasets. Search datasets by topic, agency, format, and keywords. Discover open data from federal, state, and local governments

The Howlers

NYC Open Data Dataset Search

scrupulous_waterbird_m4w/nyc-open-data

Search NYC Open Data and Socrata datasets including 311 requests, restaurant inspections, building permits, and the public catalog. Export normalized records with SoQL filters and pagination.