Chicago Food Inspections
Pricing
from $10.00 / 1,000 results
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
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
3 days ago
Last modified
Categories
Share
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
resultsfor the common case — the actor buildsresults='<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
whereis set it takes precedence andresultsis ignored.
Behaviour
- Pages through the dataset with Socrata
$offset/$limituntilmaxResultsis 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_threadso 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": "..."}