Database
196,673 Restaurants Database of United States
Phone numbers, addresses, cuisines of 196,673 restaurants over 52 states in 29,712 cities
Samples
CSV
Listed below are the first 10 - 100 (or more) records of each of the 3 tables.
Download CSV
restaurant top
| id | city_id | title | cuisine | address | city_state_postcode | phone | zip_code | fax | website | index_id |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Fox's Pizza Den | Pizza | 105 Kirkland St | Abbeville, AL 36310 | 334-585-1513 | 36310 | 417837 | ||
| 2 | 1 | Hardee's | American, Fast Food, Hamburgers, Sandwiches | 650 Ozark Rd | Abbeville, AL 36310 | 334-585-6111 | 36310 | www.hardees.com | 190479 | |
| 3 | 1 | Subway Sandwiches & Salads | Fast Food, Salads, Sandwiches | 521 Kirkland St | Abbeville, AL 36310 | 334-585-1021 | 36310 | www.subway.com | 148709 | |
| 4 | 3 | Gus's Hot Dogs | Fast Food | 14 Rex Ln | Adamsville, AL 35005 | 205-674-8911 | 35005 | 114108 | ||
| 5 | 3 | Jack's | Fast Food, Hamburgers | 5701 Adamsville Pkwy | Adamsville, AL 35005 | 205-674-6543 | 35005 | 114148 | ||
| 6 | 3 | McDonald's | Fast Food, Hamburgers, Sandwiches | 5721 Veterans Memorial Dr | Adamsville, AL 35005 | 205-674-7288 | 35005 | www.mcdonalds.com | 170901 | |
| 7 | 7 | Arby's | Fast Food, Sandwiches | 652 1st St. N. | Alabaster, AL 35007 | 205-664-1797 | 35007 | 114817 | ||
| 8 | 7 | Arby's | American, Fast Food, Sandwiches | 652 1st St N | Alabaster, AL 35007 | 205-664-1797 | 35007 | www.arbys.com | 187112 | |
| 9 | 7 | Buddys Bar B Que | Barbecue, Fast Food | Hwy 31 | Alabaster, AL 35144 | 205-663-6993 | 35144 | 405312 | ||
| 10 | 7 | Burger Palace | Sandwiches | 1614 Kent Dairy Rd | Alabaster, AL 35007 | 205-621-5757 | 35007 | 230361 | ||
| 11 | 7 | Captain D's Seafood | American, Seafood | 1381 1st St N | Alabaster, AL 35007 | 205-663-5263 | 35007 | www.captainds.com | 218675 | |
| 12 | 7 | Church's Fried Chicken | American, Fast Food | 691 Hwy 119 | Alabaster, AL 35007 | 205-620-0620 | 35007 | 114023 | ||
| 13 | 7 | Del Toro Mexican Restaurant | Fast Food | 478 Highway 119 | Alabaster, AL 35007 | 205-664-9949 | 35007 | 412014 | ||
| 14 | 7 | Domino's Pizza | Pizza | 125 Buck Creek Dr | Alabaster, AL 35007 | 205-621-1811 | 35007 | www.dominos.com | 182121 | |
| 15 | 7 | Down Home Country Cafe | American | 1633 Kent Dairy Rd. | Alabaster, AL 35007 | 205-664-1145 | 35007 | 114064 | ||
| 16 | 7 | Funtime Pizza | Pizza | 410 Highway 119 | Alabaster, AL 35007 | 205-663-9625 | 35007 | 418250 | ||
| 17 | 7 | Hardee's | American, Fast Food, Hamburgers, Sandwiches | Highway 31 S | Alabaster, AL 35007 | 205-663-1164 | 35007 | www.hardees.com | 189188 | |
| 18 | 7 | Hunan Garden 2 | Fast Food | 466 Highway 119 | Alabaster, AL 35007 | 205-663-5429 | 35007 | 422883 | ||
| 19 | 7 | Jim 'N Nick's Bar B-Q | American, Barbecue, Southern | 295 Alabaster Blvd | Alabaster, AL 35007 | 205-605-0170 | 35007 | www.jimnnicks.com | 255785 | |
| 20 | 7 | Johnny Ray's Bar-B-Q | Barbecue | Hwy 119 | Alabaster, AL 35007 | 205-621-5151 | 35007 | 114493 | ||
Download CSV
city top
| id | state_id | title | count | abbreviation | slug |
|---|---|---|---|---|---|
| 1 | 1 | Abbeville | 3 | AL | Abbeville |
| 2 | 1 | Abernant | 0 | AL | Abernant |
| 3 | 1 | Adamsville | 3 | AL | Adamsville |
| 4 | 1 | Addison | 0 | AL | Addison |
| 5 | 1 | Adger | 0 | AL | Adger |
| 6 | 1 | Akron | 0 | AL | Akron |
| 7 | 1 | Alabaster | 20 | AL | Alabaster |
| 8 | 1 | Alberta | 0 | AL | Alberta |
| 9 | 1 | Albertville | 32 | AL | Albertville |
| 10 | 1 | Alexander City | 32 | AL | Alexander%20City |
| 11 | 1 | Alexandria | 2 | AL | Alexandria |
| 12 | 1 | Aliceville | 1 | AL | Aliceville |
| 13 | 1 | Allgood | 0 | AL | Allgood |
| 14 | 1 | Alma | 0 | AL | Alma |
| 15 | 1 | Alpine | 1 | AL | Alpine |
| 16 | 1 | Alton | 0 | AL | Alton |
| 17 | 1 | Altoona | 0 | AL | Altoona |
| 18 | 1 | Andalusia | 11 | AL | Andalusia |
| 19 | 1 | Anderson | 0 | AL | Anderson |
| 20 | 1 | Annemanie | 0 | AL | Annemanie |
Download CSV
state top
| id | title | count | abbreviation |
|---|---|---|---|
| 1 | Alabama | 3934 | AL |
| 2 | Alaska | 432 | AK |
| 3 | Arizona | 3553 | AZ |
| 4 | Arkansas | 1408 | AR |
| 5 | California | 24812 | CA |
| 6 | Colorado | 3665 | CO |
| 7 | Connecticut | 2254 | CT |
| 8 | Delaware | 498 | DE |
| 9 | Dist. of Columbia | 1186 | DC |
| 10 | Florida | 13551 | FL |
| 11 | Georgia | 6703 | GA |
| 12 | Hawaii | 1224 | HI |
| 13 | Idaho | 630 | ID |
| 14 | Illinois | 7273 | IL |
| 15 | Indiana | 4152 | IN |
| 16 | Iowa | 3099 | IA |
| 17 | Kansas | 2032 | KS |
| 18 | Kentucky | 2861 | KY |
| 19 | Louisiana | 2810 | LA |
| 20 | Maine | 850 | ME |
| 21 | Maryland | 3394 | MD |
| 22 | Massachusetts | 4914 | MA |
| 23 | Michigan | 7653 | MI |
| 24 | Minnesota | 2632 | MN |
| 25 | Mississippi | 1738 | MS |
| 26 | Missouri | 4028 | MO |
| 27 | Montana | 584 | MT |
| 28 | Nebraska | 1062 | NE |
| 29 | Nevada | 1802 | NV |
| 30 | New Hampshire | 699 | NH |
| 31 | New Jersey | 3210 | NJ |
| 32 | New Mexico | 1060 | NM |
| 33 | New York | 14541 | NY |
| 34 | North Carolina | 4927 | NC |
| 35 | North Dakota | 433 | ND |
| 36 | Ohio | 8069 | OH |
| 37 | Oklahoma | 2261 | OK |
| 38 | Oregon | 2263 | OR |
| 39 | Pennsylvania | 6198 | PA |
| 40 | Puerto Rico | 101 | PR |
| 41 | Rhode Island | 929 | RI |
| 42 | South Carolina | 2601 | SC |
| 43 | South Dakota | 331 | SD |
| 44 | Tennessee | 3894 | TN |
| 45 | Texas | 14971 | TX |
| 46 | Utah | 1495 | UT |
| 47 | Vermont | 358 | VT |
| 48 | Virginia | 4635 | VA |
| 49 | Washington | 4000 | WA |
| 50 | West Virginia | 983 | WV |
| 51 | Wisconsin | 3595 | WI |
| 52 | Wyoming | 385 | WY |