Socrata Open Data Exporter: Permits, Licenses & Inspections

Download any dataset from 200+ government open-data portals built on Socrata (Chicago, New York City, Texas, Los Angeles, and hundreds more) straight to Excel, CSV, JSON, or XML. No API key, no coding.

Popular datasets

• Building permits for fresh construction and renovation leads
• Business licenses for newly registered local businesses
• Restaurant / food inspections
• Contracts, salaries, 311 service requests, crime, and thousands more

What data you get

One item per record, with every column the dataset publishes (or just the columns you select). Pagination is automatic and duplicate rows are filtered out, so a dataset with 50,000 rows comes back complete and clean.

Column names match the dataset's API field names — for example, a Chicago building-permits row includes fields like permit_, permit_type, issue_date, work_description, street_name, and every other column that dataset exposes.

Example output (one row, Chicago building permits)

{
  "permit_": "100987654",
  "permit_type": "PERMIT - NEW CONSTRUCTION",
  "issue_date": "2025-06-15T00:00:00.000",
  "work_description": "NEW 3-STORY RESIDENTIAL BUILDING",
  "street_number": "1234",
  "street_name": "MILWAUKEE",
  "total_fee": "3420.00"
}

How to run it in the Apify Console

1. Open the dataset you want on its portal (e.g. data.cityofchicago.org) and find its 4x4 ID on the dataset's API tab (e.g. ydr8-5enu).
2. In the Apify Console, click Try for free / Start on this Actor.
3. Enter the portal host in Socrata domain and the ID in Dataset ID.
4. Optionally add a filter (e.g. only records after a date), pick specific columns, and set Max rows.
5. Click Start. When the run finishes, open the Storage tab and export the results as Excel, CSV, JSON, or XML — or fetch them via the Apify API for automated pipelines.

Example input

{
  "socrataDomain": "data.cityofchicago.org",
  "datasetId": "ydr8-5enu",
  "soqlWhere": "issue_date > '2025-01-01'",
  "maxItems": 5000
}

Input settings

Field	Required	Description
Socrata domain (socrataDomain)	Yes	Portal host, e.g. data.cityofchicago.org, data.cityofnewyork.us, data.texas.gov
Dataset ID (datasetId)	Yes	The 4x4 identifier from the dataset's API tab, e.g. ydr8-5enu
Max rows (maxItems)	No (default 1000)	Stop after this many rows
Filter (soqlWhere)	No	SoQL WHERE clause, e.g. issue_date > '2025-01-01'
Columns (soqlSelect)	No	Comma-separated columns to return; blank = all
Socrata app token (appToken)	No	Free token from the portal that raises Socrata's rate limits for very large pulls

Great for

• Sales teams sourcing permit / license leads
• Researchers and journalists pulling public records at scale
• Feeding dashboards and data pipelines without writing API code
• Monitoring new permits, licenses, or inspections on a schedule

Limitations (good to know)

• Rate limits on huge pulls. Socrata throttles heavy anonymous usage. For very large exports, add a free Socrata app token (optional input) — the Actor also retries transient errors automatically, so normal runs are unaffected.
• The Actor exports the dataset as the portal publishes it; column names, coverage, and update frequency are set by the publishing government agency.
• Filters use Socrata's SoQL syntax; an invalid $where clause will end the run without results — copy the field names exactly as they appear on the dataset's API tab.

Data licensing and attribution

Each dataset on a Socrata portal carries its own license and terms of use, shown on the dataset's landing page. Check that page and attribute the publishing agency as its license requires.

FAQ

Where do I find the Dataset ID? On the dataset's page, open the API tab (or "API docs"). The endpoint looks like https://data.cityofchicago.org/resource/ydr8-5enu.json — the ydr8-5enu part is the ID.

Do I need an app token? No. Moderate volumes work without one. Add a token (free from the portal) only if you pull very large datasets frequently.

Can I get just the newest records? Yes — use the Filter field with the dataset's date column, e.g. issue_date > '2025-01-01'.

Use with AI agents (MCP)

This Actor works as a tool for AI agents via the Apify MCP server. Add it to Claude, Cursor, or any MCP-compatible assistant with this server URL:

https://mcp.apify.com?tools=doggo/socrata-opendata-exporter

Then just ask something like "Pull the latest 5,000 building permits from Chicago's open data portal" — the agent fills in the input, runs the Actor, and reads the results from the dataset. Standard pay-per-result pricing applies to the calling account.