Chicago Food Inspections avatar

Chicago Food Inspections

Pricing

from $10.00 / 1,000 results

Go to Apify Store
Chicago Food Inspections

Chicago Food Inspections

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

Pricing

from $10.00 / 1,000 results

Rating

0.0

(0)

Developer

Jamshaid Arif

Jamshaid Arif

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

3 days ago

Last modified

Share

Chicago Food Inspections — Apify Actor

Pulls Chicago food inspection records

Input

FieldDefaultNotes
resultsAnyResult filter: Pass / Pass w/ Conditions / Fail / Out of Business / No Entry / Not Ready / Business Not Located
whereRaw SoQL $where (advanced). Overrides results
selectall columnsComma-separated $select columns
orderinspection_date DESCSocrata $order clause
pageSize1000Rows per request (max 50000)
maxResults1000Total rows across pages (0 = all available)
startOffset0Row offset to start from (resume)
appToken— (secret)Optional Socrata app token; raises rate limit
impersonatechromecurl_cffi fingerprint (fine to leave as-is)
minInterval0Min seconds between page requests
proxyConfigurationproxy offNot 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='<value>' 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):

{
"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": "..."
}