One jurisdiction of US food inspections, which holds 18,315 records; 6 of its 8 jurisdictions are in the latest release. The schema, sample, and delivery are the complete dataset's; an order for this subset carries only the rows of oh-lake.
| Refresh | Up to 50K | 50K and up | 250K and up | 1M and up | 5M and up |
|---|---|---|---|---|---|
| One-time snapshotper delivery | $0.004 | $0.0034 | $0.0028 | $0.0022 | $0.0016 |
| Quarterlyper delivery, 4 a year | $0.0024 | $0.002 | $0.0017 | $0.0013 | $0.00096 |
| Monthlyper delivery, 12 a year | $0.0014 | $0.0012 | $0.00098 | $0.00077 | $0.00056 |
| Weeklyper delivery, 52 a year | $0.0006 | $0.00051 | $0.00042 | $0.00033 | $0.00024 |
| Updates onlyper changed record, each release | Pay only for rows that are new or changed since your last delivery. Each changed record is charged at the one-time rate above for the tier the changed rows fall in. | ||||
Price per record, in USD. Columns are records per delivery.
Every delivery is at least $250. This subset, 1,104 records, is priced in the “Up to 50K” column: a one-time snapshot is $250, the minimum order. Estimate a subset.
Sample release v7, published Oct 1, 2026, 15:02 UTC. Up to 200 rows per kind, stratified by partition, children of sampled parents only. The first 12 rows of each kind are below.
| id | jurisdiction_id | name | license_no | address | city | jurisdiction.state | zip | license_type | license_status |
|---|---|---|---|---|---|---|---|---|---|
| e555bd90-17aa-4df9-bc3e-f0827b29b7b4 | oh-phdmc | Harvest Cafe #8 | OH1104-278 | 658 Wilmington Pike | Vandalia | OH | 45402 | Retail Food Establishment, Commercial, Risk Level III | Licensed |
| eb30b476-c71a-4ba0-9967-0bad5c611993 | oh-phdmc | Copper Deli | OH9206-809 | 9465 Main St | Dayton | OH | 45402 | Food Service Operation, Commercial, Risk Level IV | Closed |
| 870ca553-65fe-40e9-97d5-5a9f2ef797fc | oh-phdmc | Big Dragon #10 | OH6538-922 | 1252 Reading Rd | Huber Heights | OH | 45405 | Food Service Operation, Commercial, Risk Level III | Licensed |
| 4e3c973c-3822-4e04-b1ea-5fe000955b1d | oh-columbus | Stone Pub #12 | OH1702-573 | 6087 Hamilton Ave | Columbus | OH | 43229 | Temporary Food Service Operation | Licensed |
| 5355d81b-f18c-4093-a544-f77812eb6955 | oh-phdmc | North Taqueria | OH8722-112 | 7780 Vine St | Vandalia | OH | 45405 | Temporary Food Service Operation | Licensed |
| 45885e18-07e1-45a1-9114-725abf7dee4f | oh-phdmc | Silver Smokehouse | OH1055-484 | 2146 Wilmington Pike | Miamisburg | OH | 45426 | Mobile Food Service Operation | Licensed |
| d233a0e8-e047-4e78-a38e-49b5534f7464 | oh-cincinnati | Harvest Pizza | OH2576-217 | 1538 N Dixie Dr | Cincinnati | OH | 45208 | Mobile Food Service Operation | Pending |
| 1d12aa69-ae37-4cb7-8c62-6ce591eb7993 | oh-cincinnati | North Tavern | OH4003-928 | 3001 Reading Rd | Cincinnati | OH | 45219 | Retail Food Establishment, Commercial, Risk Level II | Licensed |
| deaccc85-1e7a-4dd2-b8ec-449f635f5a22 | oh-phdmc | Market Smokehouse | OH1827-189 | 6755 W Dorothy Ln | Centerville | OH | 45405 | Food Service Operation, Non-commercial, Risk Level II | Licensed |
| 3dad0ad2-1ee2-4b83-a2d3-f6ca9cde8a64 | oh-union-county-health-department | Union Bakery #4 | OH4413-139 | 1806 W Dorothy Ln | Marysville | OH | 43344 | Temporary Food Service Operation | Licensed |
| b384f6b5-510b-4a9e-a287-0a43efb8b6ff | oh-columbus | Copper Cafe | OH9516-125 | 5343 Woodman Dr | Columbus | OH | 43214 | Retail Food Establishment, Commercial, Risk Level III | Licensed |
| e38a70fd-8ac4-48e3-af31-bb8706ff3ffc | oh-columbus | North Taqueria | OH5836-295 | 4400 Vine St | Columbus | OH | 43214 | Temporary Food Service Operation | Licensed |
showing 12 of 200 rows · 10 fields
| Id | Jurisdiction | State | Records | Last complete scan | In latest release | Release coverage |
|---|---|---|---|---|---|---|
| oh-lake | Lake County General Health District | enabled | 1,104 | never | yes | partial: scan capped at 200 requests |
| 1 partition | 1,104 | 1 in release | ||||
A run declares its scope (jurisdiction, full scan or since-checkpoint) and ends complete, partial, or failed. Only a complete full scan of a jurisdiction, or an explicit upstream deletion, may mark an establishment unseen; partial runs keep prior observations with their original age and report degraded coverage.
The roadmap of jurisdictions still to collect is on the complete dataset's page.
| Version | Published | Records | Jurisdictions | What changed | Manifest SHA-256 |
|---|---|---|---|---|---|
| v41latest | Oct 7, 2026, 02:14 UTC | 18,315 | 6 | Browser-scanned districts re-read in full; +93 records | 0565fb6cdbaa |
| v40 | Oct 4, 2026, 22:51 UTC | 18,222 | 6 | New inspections from the nightly and daily extracts; +164 records | 6919c7a75c09 |
| v39 | Oct 2, 2026, 19:47 UTC | 18,058 | 6 | Browser-scanned districts re-read in full; +210 records | 1ea70c4aa704 |
| v38 | Sep 30, 2026, 04:18 UTC | 17,848 | 6 | Violation codes normalized for two districts' new report layout; +75 records | 97cf7bbc8ac4 |
| v37 | Sep 27, 2026, 10:10 UTC | 17,773 | 6 | Re-inspections and follow-ups added; no schema change; +165 records | d97a11f9bc49 |
| v36 | Sep 25, 2026, 11:28 UTC | 17,608 | 6 | New inspections from the nightly and daily extracts; +100 records | de7eba5f7b11 |
| v35 | Sep 23, 2026, 11:54 UTC | 17,508 | 6 | Madison County Public Health added; +377 records | 1d011e7ddbd6 |
| v34 | Sep 21, 2026, 11:48 UTC | 17,131 | 5 | Browser-scanned districts re-read in full | 241c49ff589a |
GET /product/v1/datasets/us-food-inspections/feed returns every upsert and removal since the sequence number you last read, pinned to the newest published release; page with next_since until has_more is false.
POST /product/v1/datasets/us-food-inspections/exports queues a CSV of the newest published release, cut by field, by jurisdiction, and by inspected-on date, and serves it with its SHA-256.
The sample is a catalog route and needs only the product token. The feed and exports are delivery routes and also need the entitlement assertion your customer backend signs; an assertion for this subset grants oh-lake only. See the API docs, or fetch the sample with no token from this site's mock at /api/product/v1/datasets/us-food-inspections/sample.
# The approved sample (catalog route: product token only)
curl "$TROVE_URL/product/v1/datasets/us-food-inspections/sample" -H "Authorization: Bearer $PRODUCT_TOKEN"
# The change feed from the start (delivery route: token and entitlement)
curl "$TROVE_URL/product/v1/datasets/us-food-inspections/feed?since=0&limit=100" -H "Authorization: Bearer $PRODUCT_TOKEN" -H "X-Trove-Entitlement: $ENTITLEMENT"Health districts publish inspections on 100+ portals with no API, each in its own layout, and a restaurant that stops appearing is not the same as a restaurant that closed.
Which establishments were licensed in the last 30 days in Montgomery County?
Which operators had a critical violation on a follow-up inspection this quarter?
Which licences changed from licensed to closed since the last release?
Restaurant software and POS vendors; Food-service distributors and suppliers; Compliance and insurance underwriting; Commercial real estate and site selection.
Collected directly from local health district portals (Dayton PHDMC, Cincinnati Socrata, Columbus ArcGIS, and 58 districts on inspections.myhealthdepartment.com) with an identified crawler at each portal's stated crawl delay. Public records.
Daily where the source publishes daily; otherwise on the district's cycle, with a freshness target of 72 hours.
Last complete scan of oh-lake: never.
Daily where the source publishes daily; otherwise on the district's cycle, with a freshness target of 72 hours.
The newest release is v41, published Oct 7, 2026, 02:14 UTC. A subscription is delivered weekly, monthly, or quarterly, or as updates only: the rows that changed since your last delivery.
Yes. Each jurisdiction in the latest release is sold on its own (6 today, listed on the complete dataset's page). An export can also be cut by field, by jurisdiction, and by a inspected-on date range. You pay per record delivered. Estimate a subset.
CSV, JSON Lines, Parquet, delivered by Download, Amazon S3, Google Cloud Storage, SFTP, Webhook, Snowflake (on request). Every file carries its release id, and an API export carries its SHA-256 in X-Trove-SHA256.
Yes, with no account: 600 rows from sample release v7. Up to 200 rows per kind, stratified by partition, children of sampled parents only. Open the sample in the workbench, or fetch it from /product/v1/datasets/us-food-inspections/sample.
Yes. A new jurisdiction or record category is collected within 30 days of a signed order, or the setup fee is refunded. 215 jurisdictions on this dataset's roadmap are planned; an order moves one up. Ask for one.
Only the 19 fields in the data dictionary are distributed. The inspector's own comments on a violation are not included; a violation carries the cited code requirement only. A jurisdiction that is not in the latest release is not delivered until it is.