NYC Restaurant Health Inspection + Contact Leads

📊 Example output (real run)

A real record from a live run — clean structured data, exported as CSV / JSON / Excel or via API.

Export every restaurant in New York City — with a verified phone number, street address, cuisine type, and its latest official health inspection grade (A/B/C) — straight from the NYC Department of Health and Mental Hygiene (DOHMH) inspection registry. The data is pulled live from the NYC Open Data portal, so every record is authoritative and free of third-party scraping risk. Filter by borough, cuisine, ZIP, or grade and download a phone-ready B2B lead list as JSON, CSV, or Excel.

This Actor runs on the Apify platform, so you get scheduled runs, an HTTP API, dataset storage, webhooks, and integrations (Zapier, Make, Google Sheets) on top of the data.

What does this Actor do?

It queries the official DOHMH restaurant inspection registry (~296,000 inspection records covering ~31,000 distinct restaurants) and returns ONE clean lead per restaurant — its most recent inspection — with the restaurant's name, borough, street address, ZIP, phone number, cuisine, latest letter grade, inspection score, inspection date, and whether the last inspection cited a critical violation.

Why use NYC Restaurant Health Inspection + Contact Leads?

• Phone number included. Unlike most government contractor/license registries (which publish name + license only), NYC's restaurant registry publishes a working phone number for the large majority of active restaurants — this is a ready-to-call lead list, not just a name list.
• Built-in intent signal. Filter to Grade C or critical-violation restaurants to reach owners who visibly need food-safety consulting, pest control, or equipment service RIGHT NOW — a warmer lead than a random cold list.
• Territory + niche targeting. Filter by borough, ZIP, or cuisine (pizza, Chinese, bakery, etc.) to build a route-density or vertical-specific list for a sales rep or campaign.
• Authoritative source. Data comes directly from the city health department, not a scraped directory or stale aggregator.

Who buys this data?

• Restaurant POS / ordering-platform and payment-processor sales teams prospecting new merchants
• Food-safety consultants, pest-control companies, and commercial kitchen-equipment service providers — target Grade C / critical-violation restaurants directly
• Restaurant insurance brokers and equipment/supply vendors building territory lead lists
• Marketing agencies and local SEO firms pitching restaurants by cuisine or neighborhood

How to use it

1. Click Try for free / Start.
2. (Optional) Choose a Borough, enter a Cuisine keyword, or a ZIP Code Prefix to narrow the territory.
3. (Optional) Set Health Grade to C to surface restaurants most likely to need help.
4. Leave Require Phone Number on (default) for a call-ready list.
5. Run it, then download the results from the Output tab as JSON, CSV, or Excel.

Input

Field	Description
boro	all, manhattan, brooklyn, queens, bronx, or staten island.
cuisine	Cuisine keyword filter (case-insensitive, partial match), e.g. Pizza.
zip_prefix	ZIP or ZIP prefix, e.g. 112 for parts of Brooklyn, 10023 for one ZIP.
grade	all, A, B, or C — filters on the restaurant's latest DOHMH grade.
require_phone	If on (default), only returns restaurants with a phone number on file.
max_results	Cap on rows returned (default 5,000; up to 35,000 — there are ~31,000 distinct restaurants citywide).

Example input:

{
  "boro": "manhattan",
  "grade": "A",
  "require_phone": true,
  "max_results": 5000
}

Output

Each item looks like this (real record from the live registry):

{
  "camis": "41685153",
  "restaurant_name": "RIVERSIDE CAFE",
  "boro": "Manhattan",
  "address": "475 RIVERSIDE DRIVE",
  "zip_code": "10115",
  "phone": "(212) 870-3043",
  "cuisine": "American",
  "latest_grade": "A",
  "grade_label": "A (Grade A)",
  "latest_score": "12",
  "latest_inspection_date": "2026-07-02",
  "critical_violation": true,
  "latest_violation_description": "After cooking or removal from hot holding, TCS food not cooled by an approved method...",
  "latitude": "40.811094482579",
  "longitude": "-73.964167591037",
  "verify_url": "https://a816-health.nyc.gov/ABCEatsRestaurants/#!/Search",
  "source": "NYC DOHMH Restaurant Inspection Results (data.cityofnewyork.us 43nn-pn8j)",
  "scraped_at": "2026-07-09T00:00:00Z"
}

You can download the dataset in JSON, HTML, CSV, or Excel. A CRM-ready CSV of the full run is also saved to the run's key-value store.

Data fields

Field	Description
camis	NYC's permanent restaurant ID (stable across inspections/renames)
restaurant_name	Restaurant's DBA name
boro / address / zip_code	Location
phone	Phone number on file, formatted (XXX) XXX-XXXX
cuisine	DOHMH cuisine category (150+ categories)
latest_grade / grade_label	Current letter grade: A, B, C, or pending/not-yet-graded
latest_score	Numeric inspection score (lower is better) from the latest inspection
latest_inspection_date	Date of the most recent inspection on file (YYYY-MM-DD)
critical_violation	true if the latest inspection cited a critical violation
latest_violation_description	Text of the violation cited at the latest inspection
verify_url	Official NYC "ABC Eats" restaurant grade lookup

How much does it cost?

This Actor uses Pay-Per-Result pricing — you only pay for the restaurant records you actually receive, no monthly subscription. A borough or cuisine segment is a few cents; the full citywide list is still inexpensive. The Actor uses lightweight HTTP requests against an official open-data API (no proxies or browsers required), so platform compute cost is minimal.

Tips

• Start with a borough or ZIP prefix to keep runs small and targeted, then widen.
• Combine grade = C with a borough filter to build a tight "needs help now" outreach list.
• Schedule a monthly run to catch newly graded restaurants and re-inspections as your CRM stays in sync.

FAQ, disclaimers & support

Is this legal? Yes. This Actor reads publicly available inspection data the City of New York publishes as open data for public use.

Does every restaurant have a phone number? The large majority of active restaurants do; a small number have no phone on file. Enable Require Phone Number (default) to only return leads with a working phone.

How fresh is the data? It is fetched live from the NYC Open Data portal on every run; DOHMH updates the underlying registry regularly as new inspections happen.

Does this cover other cities? This Actor is scoped to New York City. Similar registry scrapers for other cities/states are available on request.

For feature requests or issues, use the Issues tab.