Socrata Open Data Scraper: SODA datasets to CSV/JSON
Pricing
from $0.35 / 1,000 dataset items
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).
You can access the Socrata Open Data Scraper: SODA datasets to CSV/JSON programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.
{ "openapi": "3.0.1", "info": { "version": "0.1", "x-build-id": "WJENRplZMXR84aSCM" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/datamule~socrata-soda-extractor/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-datamule-socrata-soda-extractor", "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/datamule~socrata-soda-extractor/runs": { "post": { "operationId": "runs-sync-datamule-socrata-soda-extractor", "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/datamule~socrata-soda-extractor/run-sync": { "post": { "operationId": "run-sync-datamule-socrata-soda-extractor", "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", "properties": { "mode": { "title": "Mode", "enum": [ "rows", "catalog", "metadata" ], "type": "string", "description": "What to return. \"rows\" (default) = records of one dataset, needs domain + datasetId. \"catalog\" = one row per dataset published on the domain (needs only domain). \"metadata\" = one record with a dataset's column names and types (needs domain + datasetId). Example: \"rows\".", "default": "rows" }, "domain": { "title": "Portal domain", "type": "string", "description": "Hostname of the Socrata open-data portal, no path. Required. Scheme and path are stripped if pasted. Example: \"data.cityofnewyork.us\" (others: data.cityofchicago.org, data.wa.gov, data.sfgov.org). Defaults to data.cityofnewyork.us so an empty input returns real data.", "default": "data.cityofnewyork.us" }, "datasetId": { "title": "Dataset ID (4x4)", "type": "string", "description": "Dataset ID: the 9-character xxxx-xxxx code at the end of the dataset URL on the portal. Needed for rows and metadata modes, ignored in catalog mode. Example: \"erm2-nwe9\" (NYC 311 service requests). Defaults to erm2-nwe9.", "default": "erm2-nwe9" }, "select": { "title": "$select (SoQL)", "type": "string", "description": "Optional SoQL $select: comma-separated column names to keep (rows mode). Leave empty for all columns. Example: \"unique_key, created_date, complaint_type, borough\"." }, "where": { "title": "$where (SoQL)", "type": "string", "description": "Optional SoQL $where filter (rows mode). Use column field names from metadata mode; strings in single quotes. Example: \"complaint_type = 'Noise - Residential' AND created_date > '2026-01-01T00:00:00'\"." }, "order": { "title": "$order (SoQL)", "type": "string", "description": "Optional SoQL $order sort (rows mode). Add DESC for newest first. Example: \"created_date DESC\". Without it row order is the portal's default." }, "q": { "title": "Full-text search", "type": "string", "description": "Optional full-text search. Rows mode: matches any text column (SoQL $q). Catalog mode: keyword filter on dataset names/descriptions. Example: \"pothole\"." }, "category": { "title": "Category (catalog mode)", "type": "string", "description": "Optional catalog-mode filter on the portal's dataset category; ignored in rows/metadata. Must match the portal's own category label exactly. Example: \"Public Safety\"." }, "maxRecords": { "title": "Max records", "minimum": 0, "type": "integer", "description": "Maximum records to return and be charged for. Default 1000 (= about $0.50). 0 = no limit, fetch the whole dataset (can be millions of rows, so set a cap first). Example: 100.", "default": 1000 }, "pageSize": { "title": "Page size", "minimum": 1, "maximum": 50000, "type": "integer", "description": "Rows per request to the portal, 1-50000. Default 1000 is fine; lower it only if the portal rate-limits. Example: 1000.", "default": 1000 }, "appToken": { "title": "Socrata app token (optional)", "type": "string", "description": "Optional Socrata app token for higher portal rate limits. Not needed for normal use. Stored as a secret. Example: leave empty." } } }, "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 }, "PROXY_UNBLOCKER_UNITS": { "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 }, "PROXY_UNBLOCKER_UNITS": { "type": "integer", "example": 0 } } } } } } } } }}OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.
OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.
By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.
You can download the OpenAPI definitions for Socrata Open Data Scraper: SODA datasets to CSV/JSON from the options below:
If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.
You can also check out our other API clients: