What it returns
Search datasets across 300+ government open data portals that run Socrata (NYC, Chicago, San Francisco, Seattle, states, CDC, CMS and more) and query any dataset with SoQL filters, sorting, aggregation and column selection.
Request
POST https://api.pushbuild.com/socrata-open-data/run with a JSON body. Send your key in the X-API-Key header.
| Field | Type | Description |
|---|---|---|
mode | string: search, query | Default: "search". |
query | string | Search: keywords |
domain | string | e.g. data.cityofnewyork.us |
datasetId | string | Query: 4x4 id, e.g. erm2-nwe9 |
where | string | Query: SoQL, e.g. borough = 'BROOKLYN' |
select | string | Query: columns or aggregates |
order | string | Query: e.g. created_date DESC |
text | string | Query: full-text search |
maxItems | integer | Maximum items to return (1-500). Default: 100. |
Example
curl -X POST https://api.pushbuild.com/socrata-open-data/run \
-H "X-API-Key: YOUR_KEY" \
-H "Content-Type: application/json" \
-d '{"query": "restaurant inspections", "maxItems": 20}'Response
{"count": 20, "truncated": false, "seconds": 1.4, "items": [ { ... } ]}Each call returns up to 500 items. Records that fail validation or are not found are flagged in the items and not charged.
Pricing
Pay only for results returned: $0.08 per 1,000 rows. No charge for errors or empty searches.
Related APIs
Academic Papers Search API
Search scholarly papers across Crossref (150M+ works), arXiv and PubMed in one run.
Art Institute of Chicago API
Artworks from the Art Institute of Chicago collection: title, artist, date, medium, dimensions, place of origin, department, type, classification, style, public-domain and on-view flags, gallery, credit line, subject terms and a IIIF image URL.
Article & Web Page to Markdown API
Turn any URLs into clean, Markdown, text or JSON.
Bitcoin Fees API
Bitcoin network data from mempool.space: recommended fee rates (sat/vB), projected next blocks, mempool size, recent blocks with fees, reward and mining pool, difficulty adjustment estimate, hashrate and difficulty history, and mining pool share..
Bitstamp API
Bitstamp exchange public market data: 24h ticker for every pair (last, bid, ask, open, high, low, VWAP, volume in base and quote, change) and OHLC candles from 1 minute to 3 days, up to 1,000 per pair..
Book Search API
Search millions of books by keyword, title, author, subject or ISBN, plus author lookup.
Tell us what you need built.
Questions about this API, higher volumes, or a data source you need that we don't cover yet.
hello@pushbuild.com