# Socrata Open Data Exporter: Permits, Licenses & Inspections (`doggo/socrata-opendata-exporter`) Actor Download any dataset from 200+ government Socrata portals (Chicago, NYC, Texas, and more) to Excel, CSV, or JSON. Building permits, business licenses, restaurant inspections, contracts, and salaries. Filter by date or field and export thousands of clean rows fast. - **URL**: https://apify.com/doggo/socrata-opendata-exporter.md - **Developed by:** [Doggo](https://apify.com/doggo) (community) - **Categories:** Real estate, Open source - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $0.70 / 1,000 results This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## 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 Google Sheets**. 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 you get One row per record, with **every column** from the dataset, paginated automatically, so a dataset with 50,000 rows comes back complete. ### How to use it 1. Open the dataset you want on its portal (e.g. `data.cityofchicago.org`). 2. Copy the portal host into **Socrata domain** and the dataset's 4x4 ID into **Dataset ID** (you'll find it on the dataset's **API** tab, e.g. `ydr8-5enu`). 3. Optionally add a **filter** (e.g. only records after a date) or pick specific **columns**. 4. Run it and download. ### 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 ### Tip For very large pulls, add a free Socrata **app token** (optional field) to raise rate limits. # Actor input Schema ## `socrataDomain` (type: `string`): The open-data portal host, e.g. data.cityofchicago.org, data.cityofnewyork.us, data.texas.gov. ## `datasetId` (type: `string`): The 4x4 dataset identifier from the dataset's API endpoint (e.g. ydr8-5enu = Chicago building permits). Find it on the dataset page under "API". ## `maxItems` (type: `integer`): Stop after this many rows. ## `soqlWhere` (type: `string`): Optional SoQL WHERE clause, e.g. issue_date > '2025-01-01'. ## `soqlSelect` (type: `string`): Optional comma-separated columns to return; blank = all. ## `appToken` (type: `string`): Optional Socrata app token to raise rate limits (free from the portal). Not required for moderate volumes. ## Actor input object example ```json { "socrataDomain": "data.cityofchicago.org", "datasetId": "ydr8-5enu", "maxItems": 1000 } ```` # Actor output Schema ## `results` (type: `string`): Every exported row as JSON, with all columns from the source dataset. # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "socrataDomain": "data.cityofchicago.org", "datasetId": "ydr8-5enu" }; // Run the Actor and wait for it to finish const run = await client.actor("doggo/socrata-opendata-exporter").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "socrataDomain": "data.cityofchicago.org", "datasetId": "ydr8-5enu", } # Run the Actor and wait for it to finish run = client.actor("doggo/socrata-opendata-exporter").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "socrataDomain": "data.cityofchicago.org", "datasetId": "ydr8-5enu" }' | apify call doggo/socrata-opendata-exporter --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=doggo/socrata-opendata-exporter", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Socrata Open Data Exporter: Permits, Licenses & Inspections", "description": "Download any dataset from 200+ government Socrata portals (Chicago, NYC, Texas, and more) to Excel, CSV, or JSON. Building permits, business licenses, restaurant inspections, contracts, and salaries. Filter by date or field and export thousands of clean rows fast.", "version": "0.1", "x-build-id": "lLjw7cJHAuKu4IOaI" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/doggo~socrata-opendata-exporter/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-doggo-socrata-opendata-exporter", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/doggo~socrata-opendata-exporter/runs": { "post": { "operationId": "runs-sync-doggo-socrata-opendata-exporter", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/doggo~socrata-opendata-exporter/run-sync": { "post": { "operationId": "run-sync-doggo-socrata-opendata-exporter", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "required": [ "socrataDomain", "datasetId" ], "properties": { "socrataDomain": { "title": "Socrata domain", "type": "string", "description": "The open-data portal host, e.g. data.cityofchicago.org, data.cityofnewyork.us, data.texas.gov." }, "datasetId": { "title": "Dataset ID", "type": "string", "description": "The 4x4 dataset identifier from the dataset's API endpoint (e.g. ydr8-5enu = Chicago building permits). Find it on the dataset page under \"API\"." }, "maxItems": { "title": "Max rows", "minimum": 1, "type": "integer", "description": "Stop after this many rows.", "default": 1000 }, "soqlWhere": { "title": "Filter ($where)", "type": "string", "description": "Optional SoQL WHERE clause, e.g. issue_date > '2025-01-01'." }, "soqlSelect": { "title": "Columns ($select)", "type": "string", "description": "Optional comma-separated columns to return; blank = all." }, "appToken": { "title": "Socrata app token (optional)", "type": "string", "description": "Optional Socrata app token to raise rate limits (free from the portal). Not required for moderate volumes." } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```