US Restaurant Inspection Monitor: Grades, New Openings & Failed Inspections

US Restaurant Inspection Monitor gives you restaurant and food-service health inspections across seven US cities and counties (New York City, Chicago, San Francisco, Austin, Cincinnati, Boston, and Marin County), pulled from official open data and merged into one deduplicated feed, one record per establishment at its most recent inspection. It tracks two high-value signals between runs: a new establishment appearing (a restaurant that just opened) and a grade or result change (an establishment that just failed or was closed). Most inspection scrapers cover one city and dump raw inspection rows. This one covers seven cities in one schema, reduces to one clean record per establishment, and detects what changed.

Where can I get US restaurant health inspection data?

This is a self-serve source of US restaurant inspection data on Apify. It reads publicly available records from official city and county health departments, normalizes each one's format into one consistent schema, keeps one record per establishment at its latest meaningful inspection, and detects changes between runs so you learn the day a restaurant opens or fails an inspection. Each source is health-checked every run: a dataset that stops updating (some city portals silently freeze) is flagged stale, so the feed never quietly serves years-old data.

Cities and official sources covered

City	Official source	Outcome format
New York City	NYC DOHMH restaurant inspections	Letter grade (A / B / C), critical-violation flag, cuisine, phone, coordinates
Chicago	Chicago CDPH food inspections	Pass / Fail / Conditional, facility type, coordinates
San Francisco	SF DPH restaurant inspections	Pass / Conditional Pass / Closure rating, native coordinates
Austin	Austin Public Health inspection scores	0-100 hygiene score (coordinates via geocoding)
Cincinnati	Cincinnati Health Department	Approved / minor / major / closed status, phone, coordinates
Boston	Boston Inspectional Services (CKAN)	Pass / fail / closed, facility type (coordinates via geocoding)
Marin County (CA)	Marin County EHS	Colored placard grade (GREEN / YELLOW / RED), coordinates via geocoding

More cities are added over time as their open data is verified live; a couple of previously listed cities (Dallas, Montgomery County MD, Baton Rouge) are temporarily out because their public datasets stopped updating, and this Actor will not serve stale data as if it were current.

What data does each record include?

Field	Description
name	Establishment / restaurant name
city	Market: New York City, Chicago, San Francisco, Austin, Cincinnati, Boston, or Marin County
result	Normalized outcome: pass, conditional, fail, closed, other, unknown
grade	Letter grade where the city uses one (NYC A/B/C), else null
score	0-100 hygiene score where the city publishes one (Austin; higher is better)
critical	Whether the latest inspection failed or flagged a critical issue
facilityType	Restaurant, School, Grocery, and so on
cuisine	Cuisine description (NYC)
latestInspectionDate	Date of the most recent inspection used
address	street, city, state, zip
coordinates	Latitude/longitude (NYC, Chicago, and SF publish it; Austin, Boston, and Marin can be filled with geocoding)
phone	Phone where the city publishes it (NYC, Cincinnati)

Who uses restaurant inspection data?

Restaurant tech and POS companies. A new establishment appearing is a restaurant about to open that needs a POS, payments, and software. Run this weekly with a webhookUrl and get every new opening across all seven cities.

Food suppliers and distributors. Track newly opened restaurants in your markets, filter by city and facility type for territory-accurate prospect lists.

Food-safety consultants and pest control. A failed or low-grade inspection is a business that needs help now. The FAILING_INSPECTIONS output lists every establishment that failed, was closed, or flagged a critical issue.

Insurance and compliance. Monitor inspection outcomes and closures across a portfolio of locations.

Consumer apps, journalists, and researchers. A clean, geocoded, cross-city inspection dataset for maps, safety features, and food-safety analysis.

How is this different from a single-city inspection scraper?

• Seven cities in one consistent schema, not one.
• One record per establishment at its latest meaningful inspection, not thousands of raw violation rows.
• Change detection for new openings and grade/result changes, so it works as a monitor, not a one-time dump.
• Normalized outcome (result) comparable across cities that use letter grades, pass/fail, or numeric scores.
• Self-heals: RUN_HEALTH flags a source that silently returned zero when it had data last run, or one whose dataset has gone stale (stopped updating upstream).

How to use it

1. Open the Input tab.
2. Choose your cities (NYC, CHICAGO, SF, AUSTIN, CINCINNATI, BOSTON, MARIN).
3. For a recurring feed, turn on Monitor mode (onlyOutputChanges) and add a webhookUrl.
4. To map Austin, Boston, and Marin (which do not publish coordinates), turn on geocodeMissingCoordinates.
5. Click Start. The first run builds a baseline; every run after it reports only what changed.
6. Download from the Output tab as JSON, CSV, or Excel, or pull via the Apify API.

Free smoke test: set testMode: true to cap every city at 5 rows and skip the snapshot.

Output

Main dataset: establishments

{
  "id": "nyc_50145855",
  "sources": ["nyc"],
  "name": "CHINA RED EXPRESS",
  "city": "New York City",
  "cuisine": "Chinese",
  "facilityType": "Restaurant",
  "address": { "street": "118 CHAMBERS STREET", "city": "Manhattan", "state": "NY", "zip": "10007" },
  "coordinates": { "lat": 40.71518, "lng": -74.00853 },
  "phone": "+12122674015",
  "latestInspectionDate": "2025-04-25",
  "grade": "B",
  "score": null,
  "result": "conditional",
  "critical": true
}

Change events (Monitor mode + webhook)

Event types: new_establishment, inspection_result_changed, updated, removed. Also written to the CHANGES key, with RUN_HEALTH and FAILING_INSPECTIONS (everything failing or closed) on every run. Removals are only reported on an uncapped run (maxRecordsPerSource: 0); under the default cap the feed focuses on new openings and result changes.

Pricing: how much does it cost?

Pay-per-result. Only records written to the dataset are billed. In monitor mode each run bills only the establishments that changed, which is a handful, so a scheduled weekly monitor costs pennies. A full pull scales with the number of establishments; use maxRecordsPerSource to bound a first run.

FAQ

Where can I get restaurant health inspection data for US cities? This Actor. It returns one record per establishment with its latest inspection grade or score across New York City, Chicago, San Francisco, Austin, Cincinnati, Boston, and Marin County.

How do I find restaurants that just opened? Turn on Monitor mode and add a webhookUrl. A new establishment appearing in the inspection data is a restaurant that just opened; each is emitted as a new_establishment event.

How do I find restaurants that failed a health inspection? Every run writes FAILING_INSPECTIONS listing establishments whose latest inspection failed, was a closure, or flagged a critical issue. In monitor mode, a grade or result dropping fires an inspection_result_changed event.

Which cities are covered? New York City, Chicago, San Francisco, Austin, Cincinnati, Boston, and Marin County. More cities (many publish inspections on Socrata) are added over time as their data is verified live; request one via the Issues tab.

What is the difference between grade, score, and result? Cities score differently: NYC uses letter grades (A/B/C), Austin uses a 0-100 score, Chicago and San Francisco use pass/fail-style ratings. result normalizes all of them into one comparable field (pass, conditional, fail, closed).

Do all records have coordinates? NYC, Chicago, and San Francisco publish coordinates directly. For Austin, Boston, and Marin County, turn on geocodeMissingCoordinates to fill lat/lng via free OpenStreetMap geocoding, cached across runs.

Can I get the data as CSV, JSON, or an API? Yes: JSON, CSV, or Excel from the Output tab, or via the Apify API.

Is scraping restaurant inspection data legal? It uses only publicly available data published by official city and county health departments. It accesses no private data and bypasses no authentication.