Name: Delicatessens Database
Creator: Oddity Software
License: https://www.odditysoftware.com/page-TOS.htm#terms-licenses

Current release story

Latest update

Version 2.0.0 October 17, 2026 Build #174

Delicatessens Database 2.0.0: 58,714 U.S. Locations

Version 2.0.0 brings 58,714 screened U.S. delicatessen and sandwich-shop locations into four linked tables, with separate category labels, related contacts, source lineage, and CSV, JSON, and SQLite files.

Read the update announcement Release questions and guidance

Delicatessens Database v.2.0.0

58,714 Deli and Sandwich Shops

U.S. delicatessens and sandwich shops

Explore 58,714 screened business locations across 50 states and Washington, DC. Delicatessens and sandwich shops remain separately labeled.

Download matching CSV, JSON and SQLite tables, with schemas, field profiles, representative samples and source notices. This point-in-time directory is not a live open-store check.

58,714 Deli and Sandwich Shops Records

SAMPLE DATA TABLE STRUCTURE RECORD INFO

License Database Purchase Options

USAGE

Delicatessens Usage

$40.00

Internal work

Import, modify, combine and analyze within one organization, including work by supervised contractors.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Usage License

Choose this package above

PUBLICATION

Delicatessens Publication

$80.00

Publish and build for clients

All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Publication License

Choose this package above

MASTER

Delicatessens Master

$120.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$10.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

Delicatessens Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database: #372
Version: 2.0.0
Format: XML schema

Data dictionary

Tables and fields

Release-defined structure

Table	Records	Fields
locations	58714	location_id, location_name, brand_name, address_line, city, region_code, postal_code, country_code, latitude, longitude, primary_category, reported_status, data_confidence
classifications	58714	classification_id, location_id, category_code, category_label, is_primary
contacts	111799	contact_id, location_id, contact_type, contact_value
source_lineage	175485	lineage_id, location_id, source_dataset, source_provider, source_license, source_update_time, source_confidence

Release at a glance

What is inside this database

50 U.S. states and Washington, DC

58,714Classifications

111,799Contacts

58,714Locations

175,485Source Lineage

Table and column statistics

Select a table to review its schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.

classifications58,714 records · 5 fields

classification_id

Distinct: 58,714
Missing: 0 (0.0%)

location_id

Distinct: 58,714
Missing: 0 (0.0%)

category_code

Distinct: 2
Missing: 0 (0.0%)

category_label

Distinct: 2
Missing: 0 (0.0%)

is_primary

Distinct: 1
Missing: 0 (0.0%)

locations58,714 records · 13 fields

location_id

Distinct: 58,714
Missing: 0 (0.0%)

location_name

Distinct: 19,404
Missing: 0 (0.0%)

brand_name

Distinct: 566
Missing: 33,285 (56.7%)

address_line

Distinct: 57,164
Missing: 0 (0.0%)

city

Distinct: 8,286
Missing: 0 (0.0%)

region_code

Distinct: 51
Missing: 0 (0.0%)

postal_code

Distinct: 28,675
Missing: 5 (0.0%)

country_code

Distinct: 1
Missing: 0 (0.0%)

latitude

Distinct: 58,624
Missing: 0 (0.0%)

longitude

Distinct: 58,625
Missing: 0 (0.0%)

primary_category

Distinct: 2
Missing: 0 (0.0%)

reported_status

Distinct: 1
Missing: 0 (0.0%)

data_confidence

Distinct: 8,099
Missing: 0 (0.0%)

source lineage175,485 records · 7 fields

lineage_id

Distinct: 175,485
Missing: 0 (0.0%)

location_id

Distinct: 58,714
Missing: 0 (0.0%)

source_dataset

Distinct: 8
Missing: 0 (0.0%)

source_provider

Distinct: 7
Missing: 0 (0.0%)

source_license

Distinct: 3
Missing: 0 (0.0%)

source_update_time

Distinct: 2,989
Missing: 0 (0.0%)

source_confidence

Distinct: 33,742
Missing: 58,714 (33.5%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

classificationsDownload this sample CSV

classification_id	location_id	category_code	category_label	is_primary
cls_00016972bfbe64ab742ab5eb	loc_1b19046478486429c4d65a81	sandwich_shop	Sandwich Shop	True
cls_0d5a894bed8e01d903a6d148	loc_9bb92b1072ca545c5d178cea	delicatessen	Delicatessen	True
cls_1a7755bf3b524cb9f2849370	loc_2971ecc680279ae5f05d82f2	sandwich_shop	Sandwich Shop	True
cls_27e43a66ff6526b79499e6ac	loc_98d593da8ce1a01bfaf27544	delicatessen	Delicatessen	True
cls_34eda8ddc5e13764c28492b8	loc_14b307e12eee9d614e41eacb	sandwich_shop	Sandwich Shop	True
cls_42b3434f15cb21d3ba5d5742	loc_256825f009241b4585e31e36	sandwich_shop	Sandwich Shop	True
cls_503e94a7e4fcad8c6616bfcc	loc_2fa7cb6022ad3f4dda4996f4	sandwich_shop	Sandwich Shop	True
cls_5e5348f1eb8798c6231427a8	loc_12f8bf5f1779932b2ad176fe	sandwich_shop	Sandwich Shop	True
cls_6badc9c7b6a2457664ac0d38	loc_203d2710ca3b2e4c9d69bd54	sandwich_shop	Sandwich Shop	True
cls_797acd72ff5809ac526493b3	loc_e23ba8ada4aac07e2878f127	sandwich_shop	Sandwich Shop	True
cls_8719d843d37e5f48cba60539	loc_cc487a0af94894f688d39897	delicatessen	Delicatessen	True
cls_947dff6574da1c26c3717563	loc_2ee8acca83d3a553368ea44d	sandwich_shop	Sandwich Shop	True
cls_a1fda4026f2fd604eb2b16aa	loc_8d73c4182080a963180ffbdd	delicatessen	Delicatessen	True
cls_af9272c402b93fcb0a2d46a9	loc_ef99e10b605484c8f75ea7bf	sandwich_shop	Sandwich Shop	True
cls_bd23f4ff8378b22e47252466	loc_729e876a8cc9d17ba8513dcc	sandwich_shop	Sandwich Shop	True
cls_cacfc264eeab9b4130273296	loc_9d1b11c0690176263a28365d	sandwich_shop	Sandwich Shop	True
cls_d7cc8cdc62cb16b058344216	loc_c48dfb52ddd17219f23396fa	sandwich_shop	Sandwich Shop	True
cls_e511200ef4051f17f5a0cebd	loc_20c318b86ff844efd461f31d	delicatessen	Delicatessen	True
cls_f2934b009ff21bc1aa859bc2	loc_074ee654c24ebbf89e4ec79e	sandwich_shop	Sandwich Shop	True
cls_ffff60c85bbb6bb0b7a7e0d2	loc_c89b19ac5098f6c9292c3c26	delicatessen	Delicatessen	True

contactsDownload this sample CSV

contact_id	location_id	contact_type	contact_value
ct_000285ee8c40e1e2df1926ec	loc_0c96e48dd38ca3099d411bbf	website	https://dannys-deli.business.site/
ct_0d78ed262bdb109a1b678cf6	loc_c475654cf5ead0124dd8e970	phone	+13379905214
ct_1af856d755b88c0e761ff4ce	loc_2f7ef015e1e117a0c05406db	website	https://restaurants.subway.com/united-states/mt/billings/2750-old-hardin-rd
ct_2826fa44672dd12e4e71fac8	loc_64c2e26442dc607ba550092d	phone	8884440934
ct_35e1a6a217a739d8802bb79a	loc_5cc9b6e4d7c7bf2cd8cd05d5	phone	4239421499
ct_42f255dfb4769cc275f065b2	loc_528d6afea68218e6f48d0b67	website	https://restaurants.subway.com/united-states/ia/dewitt/715-6th-ave
ct_504b1f0bb3c9ebe2f911c475	loc_84c6c81810d7ad27edfc49d7	phone	12098304426
ct_5db185058e8046ebf66528cf	loc_8091ce877737fb17ff336b5a	phone	9035672600
ct_6b2a111629a793f5a632d2ac	loc_6c2cd0d4cd6d1151b3fdcfac	phone	9284409909
ct_78a1fb1212b1b658a050c952	loc_578e96644d92e778e378b57c	website	http://www.subway.com/en-us
ct_861bb3ddffc6e2c08caca13d	loc_fa336e2f1042d273d1b36465	website	http://locations.pitapitusa.com/ll/US/WA/Battle-Ground/11-NW-12th-Ave
ct_9378df4534d9a04ef8470476	loc_2fdee799daa1c49900fc34a1	website	http://Sottinisubs.com/
ct_a12444992292c0bf9c855343	loc_f1ed0e9bf999a5a0eabacc5c	phone	+16034478444
ct_aee03386d8a0d4c934cecb66	loc_080d7167e64ea039b61faab4	phone	+13037941402
ct_bc47b058b9d355916a212cd8	loc_d781fcf774effb339b3f5cbd	phone	+14782004420
ct_c9a483848848027d7e9f1724	loc_645e0c9d08d2d3d35d61d51b	website	https://restaurants.subway.com/united-states/ma/acton/134-great-rd
ct_d73f6f3032ba81f7bc25843b	loc_4d7075a7c81cc9efdb099577	phone	+19192006990
ct_e4c6da3a1c9061e6a9bffcf0	loc_44297d35dbde9288e93077e6	website	https://restaurants.subway.com/united-states/tx/beaumont/1074-e-virginia
ct_f22b9092b4776856a5e422a7	loc_37824dc8203009076c916196	website	http://www.subway.com/
ct_ffff987b98ba0bf57380feb6	loc_3bfb7506efbf79870ae63081	phone	+15802377330

locationsDownload this sample CSV

location_id	location_name	brand_name	address_line	city	region_code	postal_code	country_code	latitude	longitude	primary_category	reported_status	data_confidence
loc_0002e5dcf42546288433d042	Rocky Mountain Deli		541 Big Thompson Ave Unit B	Estes Park	CO	80517	US	40.37963008	-105.51484655	delicatessen	open	0.9882358312606812
loc_0dbc5d62f8bc9cddfbdcc0c9	Subway San Diego		1025 W Laurel St Ste 103	San Diego	CA	92101	US	32.72961	-117.17223	sandwich_shop	open	0.9199122190475464
loc_1b0d1e022f7f42a605f07b39	Atlanta Bread Company		7611 N Kings Hwy	Myrtle Beach	SC	29572	US	33.7481968328131	-78.82011075092817	sandwich_shop	open	0.9199122190475464
loc_2891bf6fb8d521849e38c3fe	Subway		2465 Hempstead Tpke	East Meadow	NY	11554-2028	US	40.726656	-73.544198	sandwich_shop	open	0.9531283974647522
loc_361d0efca2cc8fbc322366a6	Aloha Deli Ice Cream & Shave Ice		61-3642 Kawaihae Rd Unit 2	Kamuela	HI	96743	US	20.038235215128793	-155.8285154526156	delicatessen	open	0.77
loc_4382c10c0fe0707737ea6b1e	Subway	Subway	6000 N. Terminal Pkwy, Intl Concourse E, Space ER-7, Hartsfield-Jackson Int'l Arprt	Atlanta	GA	30337	US	33.6409	-84.4263	sandwich_shop	open	0.9871838092803955
loc_50d439112a9a2ccca5160632	Subway	Subway	1122 Main St	Vilonia	AR	72173	US	35.08406843	-92.20393761	sandwich_shop	open	0.9199122190475464
loc_5e262ae514506ad1e4067a58	Marvin's BBQ & Deli		495 S Main St	Sebastopol	CA	95472	US	38.39833494	-122.82182898	delicatessen	open	0.9902192950248718
loc_6bd0dc5b2f4402b69ba379a2	Subway	Subway	114 South 5th Suite A	Pocatello	ID	83201	US	42.86648234	-112.44316303	sandwich_shop	open	0.9811906218528748
loc_7966bd6e7feb71b10a461c39	Dog-leash		14 Bow St	Somerville	MA	02143-2915	US	42.38061	-71.09719	delicatessen	open	0.7504402995109558
loc_86c6d21d3b68a286cf5ec26a	Firehouse Subs	Firehouse Subs	220-c Azalea Square	Summerville	SC	29483	US	33.03830071	-80.15666135	sandwich_shop	open	0.9902192950248718
loc_93cff35b19d41bf95260bf43	DiVello's Deli of Medford		185 Route 70	Medford	NJ	08055	US	39.90293117964212	-74.82928819008615	delicatessen	open	0.77
loc_a1140f27dcfada5775cb501f	Sally's Snack Bar		228 W 6th St	Los Angeles	CA	90014	US	34.04638691	-118.25173356	delicatessen	open	0.9199122190475464
loc_aea8fe23a659b945397119f6	Nourish Juicery And Kitchen		636 W Adrian St	Blissfield	MI	49228	US	41.837053	-83.877855	delicatessen	open	0.9199122190475464
loc_bc2e085b80587422285e2954	Subway		409 E Lee Hwy	Loudon	TN	37774-6437	US	35.7446208	-84.3246	sandwich_shop	open	0.981141984462738
loc_c99e6db7d7061b26dda32025	SUBWAY		437 Mount Rushmore Rd	Custer	SD	57730	US	43.76635433168944	-103.60093579259757	sandwich_shop	open	0.9199122190475464
loc_d7183b8958831d8fc3e9d036	Trickler's Deli		108 E Hundley Dr	Lake Dallas	TX	75065	US	33.12214087	-97.02965819	delicatessen	open	0.9902192950248718
loc_e4ca3d046b202b7035a415d5	Firehouse Subs Bradley	Firehouse Subs	1609 IL-50	Bourbonnais	IL	60914	US	41.17416659	-87.85206285	sandwich_shop	open	0.9728198647499084
loc_f21e263ddafcc7146933e212	SUBWAY		742 W Garfield Blvd	Chicago	IL	60609	US	41.79449902276144	-87.64467850027756	sandwich_shop	open	0.9199122190475464
loc_ffff9678dedfbb81152363e8	Jimmy John's	Jimmy John's	1827 E 10th St	Bloomington	IN	47408-3971	US	39.17169823	-86.51003787	sandwich_shop	open	0.9902192950248718

source lineageDownload this sample CSV

lineage_id	location_id	source_dataset	source_provider	source_license	source_update_time	source_confidence
src_0000178ebca1356eff47d9cc	loc_a9c8d57b34fb677bfcd85633	Overture-signals	overture	CDLA-Permissive-2.0	2026-09-14T15:43:16Z	1.0
src_0da33852ca3f23dc4b11de8a	loc_86f4b1691a01bffc1efa8cea	meta	meta	CDLA-Permissive-2.0	2026-09-14T00:00:00.000Z	0.9958621263504028
src_1af7b340e17c874f00af46ff	loc_a70e0c7f7aa1c28d8fe2bda0	Overture-signals	overture	CDLA-Permissive-2.0	2026-09-14T15:43:16Z	1.0
src_286c5d04b4b611313b43ffbb	loc_bbf4c76efa3b7d68999aeec6	Overture-signals	overture	CDLA-Permissive-2.0	2026-09-14T15:43:16Z	1.0
src_35d1e9cba4c76a4f9e01691c	loc_da88f48ffe7c83c96ea53924	Overture	overture	CDLA-Permissive-2.0	2026-09-17T22:52:12Z
src_433f1ba545cc203301808256	loc_148c4f754049942731185f3f	Overture-signals	overture	CDLA-Permissive-2.0	2026-09-14T15:43:16Z	1.0
src_50b3482f12a136fe0d34a6c9	loc_463d45902c3d0ebce829d9ea	Foursquare	foursquare	Apache-2.0	2025-08-22T00:00:00.000	0.77
src_5e0c193faa0a64478de35c6f	loc_06299c59850036a71c865392	Foursquare	foursquare	Apache-2.0	2025-08-19T00:00:00.000	0.77
src_6b6a28fcc4e4b3b4d47240ca	loc_012cdbabce88d30bd8f3a6ab	Overture	overture	CDLA-Permissive-2.0	2026-09-17T22:52:12Z
src_78feb9ca8b08954a4a2e9ed9	loc_022ae14c1ab00bf6f25d4ec9	Overture-signals	overture	CDLA-Permissive-2.0	2026-09-14T15:43:16Z	1.0
src_869f7001723d25d09716d625	loc_0077d125a7fb335873801c7b	Overture	overture	CDLA-Permissive-2.0	2026-09-17T22:52:12Z
src_9458b803b902cf456293b4c2	loc_45851888e4c8abc954b57fd8	BrightQuery	brightquery	CDLA-Permissive-2.0	2026-09-17T20:01:51.007Z	0.95
src_a1b481ef23dc847c287f64b7	loc_3a6d047cab68e350d9f8e61b	Overture-signals	overture	CDLA-Permissive-2.0	2026-09-14T15:43:16Z	1.0
src_af385e365d644ab9bad0f711	loc_9726a5a7b11e2bbaf0076f51	Overture-signals	overture	CDLA-Permissive-2.0	2026-09-14T15:43:16Z	1.0
src_bcdf255ac230e56b78309e12	loc_9c17d96725e94ff6d1bec57c	Overture	overture	CDLA-Permissive-2.0	2026-09-17T22:52:12Z
src_ca477a53b705b550e1031bbb	loc_39f23c746f9951c0a2ef7afc	meta	meta	CDLA-Permissive-2.0	2026-09-14T00:00:00.000Z	0.9640476107597351
src_d7d4178a505085ea85696e85	loc_120ededb3b815a22628bb475	Overture-signals	overture	CDLA-Permissive-2.0	2026-09-14T15:43:16Z	1.0
src_e52650c287d739f6fcfb8e1d	loc_3eb2433892202619c9f21ffb	meta	meta	CDLA-Permissive-2.0	2026-09-14T00:00:00.000Z	0.9961938858032227
src_f2981db0d905e4f000cd7e99	loc_e642a2bb534be30727513123	meta	meta	CDLA-Permissive-2.0	2026-09-14T00:00:00.000Z	0.5069928169250488
src_ffffeee5f8662fb3f7befd5d	loc_951c44ff04ea669f23ef0736	meta	meta	CDLA-Permissive-2.0	2026-09-14T00:00:00.000Z	0.9525197148323059

58,714 unique locations; linked classifications, contacts and provenance are detail rows, not extra businesses.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.

Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Delicatessens Database release guide Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Software - Databases, Development and Design

Delicatessens Database

Flexible data delivery

Latest update

Delicatessens Database 2.0.0: 58,714 U.S. Locations

Delicatessens Database v.2.0.0

58,714 Deli and Sandwich Shops

U.S. delicatessens and sandwich shops

License Database Purchase Options

Delicatessens Usage

Internal work

Delicatessens Publication

Publish and build for clients

Delicatessens Master

Client dataset handoff

Table Schema Database Field Statistics

Delicatessens Database

Tables and fields

What is inside this database

Category

Table and column statistics

Representative sample data

Data shaped around your project.

Find a database

RECENT DATA UPDATES

BROWSE CONTENT LISTS

Custom Data Solutions

Database Help

Get more from your data

How can we help?

Tell us what happened

Request received

Details