One jurisdiction of Ohio food business profiles, which holds 16,336 records; 3 of its 3 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-columbus.
| Refresh | Up to 50K | 50K and up | 250K and up | 1M and up | 5M and up |
|---|---|---|---|---|---|
| One-time snapshotper delivery | $0.006 | $0.0051 | $0.0042 | $0.0033 | $0.0024 |
| Quarterlyper delivery, 4 a year | $0.0036 | $0.0031 | $0.0025 | $0.002 | $0.0014 |
| Monthlyper delivery, 12 a year | $0.0021 | $0.0018 | $0.0015 | $0.0012 | $0.00084 |
| Weeklyper delivery, 52 a year | $0.0009 | $0.00077 | $0.00063 | $0.00049 | $0.00036 |
| 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, 7,102 records, is priced in the “Up to 50K” column: a one-time snapshot is $250, the minimum order. Estimate a subset.
Sample release v5, published Oct 2, 2026, 09:12 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 | establishment_id | name | address | city | zip | license_no | license_status | last_inspected_on | violations_12m | critical_12m | business_entity_id | entity_name | entity_status | charter_number | match_state | confidence |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5bcfa118-785d-4a3c-8246-87492c6a9756 | oh-cincinnati | ac110818-d4d0-42f4-8b50-d4630f701257 | Stone Market | 9464 N Dixie Dr | Cincinnati | 45229 | OH8267-451 | Licensed | 2025-12-27 | 0 | 0 | fa09032b-39ce-4ec7-a8a4-182c06d18fa3 | NORTHSTAR HOSPITALITY LLC | Active | 3790108 | matched | 0.923 |
| e708bc78-0741-4a9f-86a4-3826141bb149 | oh-phdmc | 78fdc2a4-4303-4b31-b5ac-69e3c6ef773c | Stone Kitchen | 5514 E Third St | Miamisburg | 45426 | OH6269-273 | Licensed | 2026-04-07 | 1 | 1 | 95cc5a48-b67c-4698-acb9-9537a33c3ace | HEARTLAND KITCHENS LP | Active | 4797479 | matched | 0.897 |
| 884e7f6b-b6ea-4977-93c7-df0c46d3ffca | oh-columbus | b05117ae-3b57-40b0-a917-50b15c2aa7dd | Oak Pizza #7 | 9075 N High St | Columbus | 43212 | OH9024-923 | Licensed | 2026-05-29 | 3 | 3 | ∅ | ∅ | ∅ | ∅ | none | ∅ |
| 4ddf76f6-3c8f-4bd6-a4d6-cd1b9d5bcf77 | oh-cincinnati | 38bbf9b6-0273-4284-a82e-475452f3ff17 | Maple Cantina | 7905 Parsons Ave | Cincinnati | 45229 | OH5472-686 | Licensed | 2026-08-26 | 5 | 0 | ∅ | ∅ | ∅ | ∅ | candidate | 0.741 |
| 7ba6b9fa-7bca-41f6-af42-e91013d1fc5a | oh-columbus | a66bf70d-6e1e-44ed-8519-1e572381466f | Oak Chophouse #12 | 3227 Parsons Ave | Columbus | 43214 | OH2051-216 | Licensed | 2026-02-14 | 0 | 0 | ∅ | ∅ | ∅ | ∅ | none | ∅ |
| c423f767-dcaf-4549-91a7-edb4e4c2bf2b | oh-phdmc | 467efc2d-f8ea-4a04-88a1-4b6183f86a14 | Little Wok #8 | 2901 Linden Ave | Miamisburg | 45377 | OH3359-938 | Licensed | 2026-02-10 | 2 | 1 | 91879efe-7d76-4496-8920-55bc791b851b | GEM CITY HOSPITALITY LLC | Active | 4745668 | confirmed | 1 |
| cd3fd94c-b6c4-4899-a41a-7bae045f5c76 | oh-phdmc | 7e2f7fdc-d8b3-4b12-ae70-9a4105e3edc1 | Harvest Tavern #8 | 3994 Smithville Rd | Trotwood | 45402 | OH3980-418 | Licensed | 2026-09-28 | 2 | 0 | 3d04059c-383d-44e5-9a87-743c5e271f52 | OHIO VALLEY HOSPITALITY INC. | Active | 3669614 | matched | 0.865 |
| fd2a0fb2-0e03-477b-844c-c0de951c7871 | oh-cincinnati | 7be6da87-6948-4b26-870c-6bdd6055403e | Harvest Pub | 7308 Woodman Dr | Cincinnati | 45227 | OH8278-563 | Licensed | 2026-07-24 | 8 | 1 | ∅ | ∅ | ∅ | ∅ | candidate | 0.688 |
| 2ffd65b9-08f1-4de6-abc8-13c880e8dc51 | oh-phdmc | 83b3e1f6-46d3-4382-9f34-b5205feb6a97 | Union Dragon #1 | 1569 E Third St | Miamisburg | 45405 | OH8340-462 | Licensed | 2026-06-04 | 0 | 0 | ∅ | ∅ | ∅ | ∅ | candidate | 0.698 |
| 8f1bbaec-641d-4c8a-8d7e-eb82007336aa | oh-phdmc | e9ca8934-de46-41c1-96c2-d2037380b01d | Market Market #10 | 4814 Vine St | Miamisburg | 45410 | OH6620-484 | Licensed | 2026-03-09 | 5 | 2 | d4bb912c-ae4b-4fd0-891a-8db8534c1203 | GEM CITY PROVISIONS LLC | Active | 2338930 | matched | 0.897 |
| 4fe2d3c1-252e-45b3-89c4-e0ba36fd1a26 | oh-cincinnati | ae0c216b-c42f-47b9-bf51-3528679c8b45 | Stone Grill #9 | 3848 Springboro Pike | Cincinnati | 45227 | OH8935-388 | Licensed | 2025-11-12 | 3 | 0 | 45d29593-2728-4644-aca1-eecf6215d20d | CAPITAL CITY ENTERPRISES INC. | Active | 3163785 | confirmed | 1 |
| 93249141-6b8f-4ceb-89b8-c92a110874ea | oh-columbus | 00259077-270b-48e0-b6ef-58717d0ce13c | Brick Pizza | 5637 Main St | Columbus | 43206 | OH2173-230 | Licensed | 2026-08-18 | 2 | 2 | ∅ | ∅ | ∅ | ∅ | candidate | 0.707 |
showing 12 of 200 rows · 18 fields
| Id | Jurisdiction | State | Records | Last complete scan | In latest release | Release coverage |
|---|---|---|---|---|---|---|
| oh-columbus | Columbus Public Health | enabled | 7,102 | Oct 7, 2026, 02:00 UTC | yes | complete derive from pinned releases |
| 1 partition | 7,102 | 1 in release | ||||
A derive run covers one jurisdiction from pinned published releases of us-food-inspections and us-business-entities. A complete derive marks unseen every profile whose establishment the pinned food release no longer carries; an unseen profile, its links, and its events are left out of later releases.
The roadmap of jurisdictions still to collect is on the complete dataset's page.
| Version | Published | Records | Jurisdictions | What changed | Manifest SHA-256 |
|---|---|---|---|---|---|
| v19latest | Oct 7, 2026, 04:02 UTC | 16,336 | 3 | Derived from the newest pinned inspection and entity releases; +156 records | 8f2a3a198d15 |
| v18 | Oct 5, 2026, 14:04 UTC | 16,180 | 3 | Derived from the newest pinned inspection and entity releases; +94 records | 4998688486a9 |
| v17 | Oct 4, 2026, 05:50 UTC | 16,086 | 3 | Entity links re-matched after an entity release; +109 records | 0e56ac19ce42 |
| v16 | Oct 2, 2026, 06:11 UTC | 15,977 | 3 | Derived from the newest pinned inspection and entity releases; +183 records | 30b6f5968c2a |
| v15 | Sep 30, 2026, 15:34 UTC | 15,794 | 3 | Entity links re-matched after an entity release; +76 records | 49ab97d9bbfd |
| v14 | Sep 28, 2026, 21:58 UTC | 15,718 | 3 | Entity links re-matched after an entity release; +138 records | 5adc97018d63 |
| v13 | Sep 27, 2026, 06:27 UTC | 15,580 | 3 | Derived from the newest pinned inspection and entity releases; +132 records | 0906e7863bfe |
| v12 | Sep 25, 2026, 08:02 UTC | 15,448 | 3 | Derived from the newest pinned inspection and entity releases | 19c755915369 |
GET /product/v1/datasets/ohio-food-business-profiles/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/ohio-food-business-profiles/exports queues a CSV of the newest published release, cut by field, by jurisdiction, and by occurred-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-columbus only. See the API docs, or fetch the sample with no token from this site's mock at /api/product/v1/datasets/ohio-food-business-profiles/sample.
# The approved sample (catalog route: product token only)
curl "$TROVE_URL/product/v1/datasets/ohio-food-business-profiles/sample" -H "Authorization: Bearer $PRODUCT_TOKEN"
# The change feed from the start (delivery route: token and entitlement)
curl "$TROVE_URL/product/v1/datasets/ohio-food-business-profiles/feed?since=0&limit=100" -H "Authorization: Bearer $PRODUCT_TOKEN" -H "X-Trove-Entitlement: $ENTITLEMENT"| Seq | Type | Occurred on | Summary |
|---|---|---|---|
| 19392 | enforcement | 2026-08-31 | Critical violation cited at Oak Creamery on a standard inspection. |
| 19385 | opened | 2026-09-08 | New food licence for Old Noodle House, operated by KEYSTONE RESTAURANT GROUP LP (formed this year). |
| 19376 | enforcement | 2026-08-27 | Follow-up inspection at Union Smokehouse. |
| 19372 | closed | 2026-10-02 | Licence status for North Smokehouse #7 changed to Out of Business. |
| 19367 | enforcement | 2026-09-12 | Follow-up inspection at Little Cantina. |
| 19363 | opened | 2026-08-08 | New food licence for Riverside Kitchen. |
| 19360 | enforcement | 2026-09-11 | Critical violation cited at Little Tavern on a complaint inspection. |
| 19358 | opened | 2026-08-18 | New food licence for Riverside Smokehouse, operated by ERIE EATERIES INC. (formed this year). |
| 19357 | opened | 2026-08-26 | New food licence for Golden Market. |
| 19353 | enforcement | 2026-08-26 | Follow-up inspection at Little Cantina. |
| 19350 | ownership_changed | 2026-08-29 | Linked entity for Market Pizza changed to LAKESHORE BRANDS LTD.. |
| 19341 | enforcement | 2026-09-07 | Follow-up inspection at Twin Noodle House. |
| 19332 | opened | 2026-09-24 | New food licence for Silver Taqueria, operated by BUCKEYE VENTURES LLC (formed this year). |
| 19329 | ownership_changed | 2026-08-27 | Linked entity for Main Street Chophouse #8 changed to SCIOTO EATERIES LLC. |
| 19320 | enforcement | 2026-08-01 | Follow-up inspection at Silver Pizza. |
| 19319 | enforcement | 2026-10-04 | Critical violation cited at Riverside Market on a standard inspection. |
| 19315 | enforcement | 2026-09-18 | Follow-up inspection at Union Taqueria #1. |
| 19311 | ownership_changed | 2026-08-05 | Linked entity for Big Noodle House changed to KEYSTONE BRANDS LLC. |
| 19304 | enforcement | 2026-09-20 | Critical violation cited at Silver Taqueria #6 on a standard inspection. |
| 19296 | ownership_changed | 2026-09-13 | Linked entity for Silver Tavern changed to HEARTLAND PROVISIONS LLC. |
A health licence and a Secretary of State filing describe the same restaurant with different names, different addresses, and no shared key. Matching them by hand does not scale past one county.
Which restaurants opened in Dayton this month, and who owns them?
Which licensed kitchens have a dissolved or cancelled entity behind them?
Which operators changed ownership in the last two releases?
Restaurant supply and equipment sales; Merchant acquiring and lending; Franchise development; Local media and market research.
Built only from published releases of the two upstream datasets by matcher trove-match-v1 (precision 1.00, recall 1.00 on the evaluation set), with operator confirmations and rejections recorded per pair. A field is distributed only while every upstream field it is computed from is.
Re-derived within 48 hours of either upstream release.
Last complete scan of oh-columbus: Oct 7, 2026, 02:00 UTC.
Re-derived within 48 hours of either upstream release.
The newest release is v19, published Oct 7, 2026, 04:02 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 (3 today, listed on the complete dataset's page). An export can also be cut by field, by jurisdiction, and by a occurred-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: 567 rows from sample release v5. 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/ohio-food-business-profiles/sample.
Yes. A new jurisdiction or record category is collected within 30 days of a signed order, or the setup fee is refunded. 1 jurisdictions on this dataset's roadmap are planned; an order moves one up. Ask for one.
Only the 36 fields in the data dictionary are distributed. A field is distributed only while every upstream field it is computed from is. A jurisdiction that is not in the latest release is not delivered until it is.