# Chicago Food Inspections (`moving_beacon-owner1/chicago-food-inspections`) Actor Scrape Chicago food inspection records from the city's open Socrata API. Filter by inspection result or custom SoQL queries, with support for pagination, sorting, and column selection. Export raw inspection data to the Apify dataset, making it ideal for food safety analysis and compliance monitoring - **URL**: https://apify.com/moving\_beacon-owner1/chicago-food-inspections.md - **Developed by:** [Jamshaid Arif](https://apify.com/moving_beacon-owner1) (community) - **Categories:** Developer tools, Automation, Other - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, NaN bookmarks - **User rating**: No ratings yet ## Pricing from $10.00 / 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. 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 ## Chicago Food Inspections — Apify Actor Pulls Chicago food inspection records ### Input | Field | Default | Notes | |----------------|------------------------|--------------------------------------------------------------| | `results` | `Any` | Result filter: Pass / Pass w/ Conditions / Fail / Out of Business / No Entry / Not Ready / Business Not Located | | `where` | — | Raw SoQL `$where` (advanced). **Overrides** `results` | | `select` | all columns | Comma-separated `$select` columns | | `order` | `inspection_date DESC` | Socrata `$order` clause | | `pageSize` | `1000` | Rows per request (max 50000) | | `maxResults` | `1000` | Total rows across pages (`0` = all available) | | `startOffset` | `0` | Row offset to start from (resume) | | `appToken` | — (secret) | Optional Socrata app token; raises rate limit | | `impersonate` | `chrome` | curl_cffi fingerprint (fine to leave as-is) | | `minInterval` | `0` | Min seconds between page requests | | `proxyConfiguration` | proxy **off** | Not needed for this open API; enable only if rate-limited | #### Filtering: `results` vs `where` - Pick a value in **`results`** for the common case — the actor builds `results=''` for you (single quotes are escaped). - For anything richer (date ranges, risk level, multiple conditions), put a raw SoQL clause in **`where`**, e.g.: ```` inspection\_date > '2024-01-01' AND risk='Risk 1 (High)' AND results='Fail' ```` When `where` is set it takes precedence and `results` is ignored. ### Behaviour - Pages through the dataset with Socrata `$offset` / `$limit` until `maxResults` is reached or a short page signals the end. - Each row is pushed to the default dataset as-is (the raw Socrata record). - Stops early on an empty page, a bot-wall (`BlockedError`), or a request error. - curl_cffi calls run via `asyncio.to_thread` so the async actor loop isn't blocked. ### Output One item per inspection record, e.g. (fields depend on `select`): ```json { "inspection_id": "2557234", "dba_name": "SOME RESTAURANT", "results": "Fail", "inspection_date": "2024-03-12T00:00:00.000", "risk": "Risk 1 (High)", "address": "123 N MAIN ST", "violations": "..." } ```` # Actor input Schema ## `results` (type: `string`): Filter by the inspection result. Leave as 'Any' for no filter. ## `where` (type: `string`): Raw Socrata $where clause, e.g. "inspection\_date > '2024-01-01' AND risk='Risk 1 (High)'". If set, it overrides the result filter above. ## `select` (type: `string`): Comma-separated columns to return (blank = all). e.g. dba\_name,results,inspection\_date,address ## `order` (type: `string`): Socrata $order clause. ## `pageSize` (type: `integer`): Rows per Socrata request (max 50000; 1000 is a safe default). ## `maxResults` (type: `integer`): Total rows to fetch across pages (0 = all available). ## `startOffset` (type: `integer`): Row offset to start from (for resuming). ## `appToken` (type: `string`): Optional free Socrata app token. Raises your rate limit for large pulls. ## `impersonate` (type: `string`): curl\_cffi impersonate target. chrome is fine for Socrata. ## `minInterval` (type: `integer`): Rate limit: minimum delay between page requests. ## `proxyConfiguration` (type: `object`): Usually NOT needed for this open API. Leave proxy off unless you get rate-limited. ## Actor input object example ```json { "results": "", "order": "inspection_date DESC", "pageSize": 1000, "maxResults": 1000, "startOffset": 0, "impersonate": "chrome", "minInterval": 0, "proxyConfiguration": { "useApifyProxy": false } } ``` # 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 = {}; // Run the Actor and wait for it to finish const run = await client.actor("moving_beacon-owner1/chicago-food-inspections").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 = {} # Run the Actor and wait for it to finish run = client.actor("moving_beacon-owner1/chicago-food-inspections").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 '{}' | apify call moving_beacon-owner1/chicago-food-inspections --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=moving_beacon-owner1/chicago-food-inspections", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Chicago Food Inspections", "description": "Scrape Chicago food inspection records from the city's open Socrata API. Filter by inspection result or custom SoQL queries, with support for pagination, sorting, and column selection. Export raw inspection data to the Apify dataset, making it ideal for food safety analysis and compliance monitoring", "version": "0.0", "x-build-id": "ctmKUmYAq8kB0J7Wk" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/moving_beacon-owner1~chicago-food-inspections/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-moving_beacon-owner1-chicago-food-inspections", "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/moving_beacon-owner1~chicago-food-inspections/runs": { "post": { "operationId": "runs-sync-moving_beacon-owner1-chicago-food-inspections", "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/moving_beacon-owner1~chicago-food-inspections/run-sync": { "post": { "operationId": "run-sync-moving_beacon-owner1-chicago-food-inspections", "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": { "results": { "title": "Inspection result filter", "enum": [ "", "Pass", "Pass w/ Conditions", "Fail", "Out of Business", "No Entry", "Not Ready", "Business Not Located" ], "type": "string", "description": "Filter by the inspection result. Leave as 'Any' for no filter.", "default": "" }, "where": { "title": "Advanced SoQL WHERE (overrides result filter)", "type": "string", "description": "Raw Socrata $where clause, e.g. \"inspection_date > '2024-01-01' AND risk='Risk 1 (High)'\". If set, it overrides the result filter above." }, "select": { "title": "Columns ($select)", "type": "string", "description": "Comma-separated columns to return (blank = all). e.g. dba_name,results,inspection_date,address" }, "order": { "title": "Order ($order)", "type": "string", "description": "Socrata $order clause.", "default": "inspection_date DESC" }, "pageSize": { "title": "Page size", "minimum": 1, "maximum": 50000, "type": "integer", "description": "Rows per Socrata request (max 50000; 1000 is a safe default).", "default": 1000 }, "maxResults": { "title": "Max results", "minimum": 0, "type": "integer", "description": "Total rows to fetch across pages (0 = all available).", "default": 1000 }, "startOffset": { "title": "Start offset", "minimum": 0, "type": "integer", "description": "Row offset to start from (for resuming).", "default": 0 }, "appToken": { "title": "Socrata app token", "type": "string", "description": "Optional free Socrata app token. Raises your rate limit for large pulls." }, "impersonate": { "title": "Browser fingerprint", "type": "string", "description": "curl_cffi impersonate target. chrome is fine for Socrata.", "default": "chrome" }, "minInterval": { "title": "Min seconds between requests", "minimum": 0, "type": "integer", "description": "Rate limit: minimum delay between page requests.", "default": 0 }, "proxyConfiguration": { "title": "Proxy configuration", "type": "object", "description": "Usually NOT needed for this open API. Leave proxy off unless you get rate-limited.", "default": { "useApifyProxy": false } } } }, "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 } } } } } } } } } } ```