Restaurant leads

App gallery / Leads

Restaurant leads: average score by inspected on, by year, new restaurant form, restaurant record

Shown in Aqua Workflow Dark · 16 featured looks, 520+ more to choose from

Restaurant leads

A lead list made from New York City's restaurant inspection results. Each restaurant appears once with its cuisine, address, business phone and map pin; its inspections carry the score, the letter grade and every violation cited. A restaurant still awaiting its first inspection has just opened: a lead for food and drink suppliers, kitchen equipment, cleaning and pest control, delivery, payments, insurance and staffing. Every page carries an outreach notice (CAN-SPAM, TCPA, do-not-call; no implied government affiliation).

Directory · 3 tables · design: Appetite Red Cards

Making an app from a pack is for subscribers. Sign in

Tables

  • restaurants16 columns · 31,442 rows in the full data
  • inspections9 columns · 92,983 rows in the full data
  • violations6 columns · 288,161 rows in the full data

Sources and licences

  • NYC restaurant inspection results — NYC Open Data terms of use (Free with credit)
  • Own packs (ours) — Ours (Free to use)

Shown in the app and its export: Restaurant inspection results from NYC Open Data (NYC Department of Health and Mental Hygiene, DOHMH New York City Restaurant Inspection Results), retrieved 2026-10-21. Changed by CreativePower: split into restaurants, inspections and violations; placeholder dates removed.

Sample: the whole source. Full data: 412,586 rows, 146 MB. Measured 2026-10-21.

Data from data.cityofnewyork.us, imported 2026-10-22.

The full data, for your own database

412,586 rows, 11.9 MB to download. CreativePower keeps only the made-up sample rows in your project; load the full data into your own PostgreSQL database (Supabase works): download these files into one folder, unzip the .csv.gz files, then run psql "<your connection string>" -f load.sql.