Usage & Publication License: database price dollar sign189.00

196,673 Restaurants Database of United States

Phone numbers, addresses, cuisines of 196,673 restaurants over 52 states in 29,712 cities

database structure screenshot of 196,673 Restaurants Database of United States

Description: The database includes 196,673 restaurants in 29,712 cities from all over the United States. In table restaurant, each record consists of cuisine, address, location city/state/postcode, phone number, zip code, fax number and website URL. The cuisine type contains pizza, American, fast food, hamburgers, sandwiches, salads, seafood, barbecue, southern, Mexican, Italian, Chinese and many other categories.

Related DBs:

Database Statistics

  • Size: 35.00 MB
  • Tables: 3
  • Records: 196,673
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
restaurant 196,673
  1. id
  2. city_id
  3. title
  4. cuisine
  5. address
  6. city_state_postcode
  7. phone
  8. zip_code
  9. fax
  10. website
  11. index_id
city 29,712
  1. id
  2. state_id
  3. title
  4. count
  5. abbreviation
  6. slug
state 52
  1. id
  2. title
  3. count
  4. abbreviation

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:


  • Alabama
  • Alaska
  • Arizona
  • Arkansas
  • California
  • Colorado
  • Connecticut
  • Delaware
  • Dist. of Columbia
  • Florida
  • Georgia
  • Hawaii
  • Idaho
  • Illinois
  • Indiana
  • Iowa
  • Kansas
  • Kentucky
  • Louisiana
  • Maine
  • Maryland
  • Massachusetts
  • Michigan
  • Minnesota
  • Mississippi
  • Missouri
  • Montana
  • Nebraska
  • Nevada
  • New Hampshire
  • New Jersey
  • New Mexico
  • New York
  • North Carolina
  • North Dakota
  • Ohio
  • Oklahoma
  • Oregon
  • Pennsylvania
  • Puerto Rico
  • Rhode Island
  • South Carolina
  • South Dakota
  • Tennessee
  • Texas
  • Utah
  • Vermont
  • Virginia
  • Washington
  • West Virginia
  • Wisconsin
  • Wyoming



  • There are 195,072 records with a cuisine.
  • There are 196,502 records that have a populated address field.
  • There are 196,673 records with a city/state/postcode.
  • There are 188,622 unique phone numbers in table restaurant.
  • There are 196,473 records with a zip-code.
  • There are 6,462 records with a fax number.
  • There are 21,232 records that have a non-empty website field.

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.

Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email:

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. How many days are there in a week? Use 1, 2, 3, ... to answer.

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!

Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.