Restaurant Health Inspection Scraper

Restaurant Health Inspection Scraper pulls structured data from NYC DOHMH & Chicago Open Data and returns it as a clean dataset you can export as JSON, CSV or Excel. It queries the New York City and Chicago restaurant inspection datasets and returns one normalised row per inspection with business name, address, date, pass or fail result, grade and violation text.

No API key, no login. Click Start and it works with the prefilled input.

What does Restaurant Health Inspection Scraper do?

It queries NYC DOHMH & Chicago Open Data and returns one row per record, with only the fields that matter. Runs on the Apify platform, so you get an API endpoint, scheduling, monitoring and integrations (Zapier, Make, Google Sheets, webhooks) without maintaining any infrastructure.

Why use it?

• NYC DOHMH & Chicago Open Data data without the plumbing: no proxy setup, no pagination code, no scraping maintenance.
• Schedule it to monitor changes daily or weekly and trigger alerts on new records.
• Feed it straight into a spreadsheet, database, or an AI agent via the Apify API or MCP server.
• Runs in seconds and returns a typed dataset that is ready for analysis.

How to use it

1. Click Try for free / Start.
2. Leave the default input to see a sample run, or type your own values (see Input below).
3. Press Start and wait a few seconds.
4. Open the Output tab and download as JSON, CSV, Excel or HTML.

Input

Field	Type	Default	Description
city	string	"all"	Which city open-data portal to search. One of: 'all', 'new_york', 'chicago'.
query	string	""	Optional restaurant name to search for. Blank returns the newest inspections.
result_filter	string	"all"	Return every inspection, or only failures and critical violations. One of: 'all', 'failures_only'.
maxResults	integer	20	Maximum number of inspection rows to return.

Example input:

{
  "city": "all",
  "query": "",
  "result_filter": "all",
  "maxResults": 5
}

Output

One item per record. Sample:

{
  "business_name": "UNCLE PAULS PIZZA NY",
  "address": "70, VANDERBILT AVENUE",
  "city": "New York (Manhattan)",
  "state": "NY",
  "zip": "10017",
  "phone": "2129221200"
}

You can download the dataset in various formats such as JSON, HTML, CSV, or Excel.

Data fields

Field	Type	Meaning
business_name	string	Business
address	string	Address
city	string	City
state	string	State
zip	string	ZIP
phone	string	Phone
cuisine_or_facility	string	Cuisine / Facility
inspection_date	string	Inspection Date
inspection_type	string	Inspection Type
result	string	Result
risk	string	Risk
critical_flag	string	Critical Flag
inspection_score	number	Score
grade	string	Grade
violation_code	string	Violation Code
violations	string	Violations
latitude	number	Latitude
longitude	number	Longitude
source	string	Source
source_url	string	Source URL

How much does it cost to run?

This Actor uses pay-per-event pricing: you pay per result item pushed to the dataset, and nothing for an empty run. Each run is a few seconds of compute, so typical costs are fractions of a cent per run, and the Apify free tier covers plenty of testing.

Tips and advanced options

• Raise maxResults for a bigger pull; the Actor pages through the source for you.
• Schedule it (e.g. every morning) and combine with a webhook to get only the new records.
• Add the Actor to an AI agent through the Apify MCP server for natural-language queries.

FAQ, disclaimers and support

• Is this legal? It uses publicly available data from NYC DOHMH & Chicago Open Data. You are responsible for how you use the data and for complying with the source's terms.
• It returned nothing? Both portals publish new inspections daily. Leave the name filter blank for the newest inspections, or search a business name such as 'pizza' or 'bakery'.
• Something broken? Open an issue on the Actor's Issues tab. Data sources change and get fixed quickly.
• Need a custom variant (extra fields, a different source, a scheduled report)? Get in touch through the Issues tab.