380,000 Restaurants Mostly USA Based
Comprehensive Dataset Spanning American Eateries and other countries. Geotagged.
@kaggle.kwxdata_380k_restaurants_mostly_usa_based
N 380k Us Restaurants
@kaggle.kwxdata_380k_restaurants_mostly_usa_based.n_380k_us_restaurants
- 224.38 MB
- 380358 rows
- 13 columns
titleTitle | linkLink | categoryCategory | ratingRating | websiteWebsite | phonePhone | addressAddress | imagesImages | categoriesCategories | geo_coordinatesGeo Coordinates | time_zoneTime Zone | latitudeLatitude | longitudeLongitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dairy Queen Grill & Chill | https://www.google.com/maps/place/Dairy+Queen+Grill+%26+Chill/data=!4m7!3m6!1s0x888c0b7872476f8d:0xeb84f433284fd7!8m2!3d32.9338695!4d-85.9704191!16s%2Fg%2F11g8wpwwl7!19sChIJjW9HcngLjIgR108oM_SE6wA?authuser=0&hl=en&rclk=1 | Fast food restaurant | 3.8 | http://www.fourteenfoods.com/?y_source=1_ODk5NTM3OC03MTUtbG9jYXRpb24ud2Vic2l0ZQ%3D%3D | +1256-496-0404 | Dairy Queen Grill & Chill, 3143 US-280, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipPcfKkGPX58CGoqNoOXHpK9iVO35pQy5N-ui5_p=w529-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipMNJvg6S6b75_LkIDl-WnmbBgSq-6p6vyKUc936=w372-h298-k-no', 'title': 'Food & drink'}, {'thumbnail': 'https://lh5.goo… | ['Fast food restaurant', 'Ice cream shop'] | {'latitude': 32.9338695, 'longitude': -85.9704191} | America/Chicago | 32.9338695 | -85.9704191 |
| Jake's Restaurant | https://www.google.com/maps/place/Jake%27s+Restaurant/data=!4m7!3m6!1s0x888c0b6b15cb8265:0xe4899f2743507adf!8m2!3d32.945406!4d-85.953806!16s%2Fg%2F1thxw_83!19sChIJZYLLFWsLjIgR33pQQyefieQ?authuser=0&hl=en&rclk=1 | American restaurant | 4.4 | http://jakesonbroad.com/ | +1256-234-4300 | Jake's Restaurant, 16 Broad St, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipM2mTSe3GBvdYZz2Y3ccuu8VcJwE3BZJegyfc6N=w224-h307-k-no', 'title': 'All'}, {'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipPlo1WhxEfOp_U_MvsWdN9iI5dqWj_2cJulIOi3=w224-h298-k-no', 'title': 'Menu'}, {'thumbnail': 'https://lh5.googleuserc… | ['American restaurant'] | {'latitude': 32.945406, 'longitude': -85.953806} | America/Chicago | 32.945406 | -85.953806 |
| Carib Kitchen | https://www.google.com/maps/place/Carib+Kitchen/data=!4m7!3m6!1s0x888c0bce71d213ab:0x6058060e10e76d26!8m2!3d32.9446173!4d-85.954932!16s%2Fg%2F11h_wybn9p!19sChIJqxPScc4LjIgRJm3nEA4GWGA?authuser=0&hl=en&rclk=1 | Caribbean restaurant | 4.9 | https://carib-kitchen.webnode.com/ | +1256-392-4433 | Carib Kitchen, 68 Broad St, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipPzHBCXA6EFitDgywaQwLB6HDHgGcgp83wYcUk=w397-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipMBssK7NlVm-FyNvD8iKvO4nvjxZVl-4YNTNNg=w236-h298-k-no', 'title': 'Menu'}, {'thumbnail': 'https://lh5.googleusercon… | ['Caribbean restaurant'] | {'latitude': 32.9446173, 'longitude': -85.954932} | America/Chicago | 32.9446173 | -85.954932 |
| Cazadores Mexican Restaurant | https://www.google.com/maps/place/Cazadores+Mexican+Restaurant/data=!4m7!3m6!1s0x888c0b686dad414b:0x50d357e359dcec0d!8m2!3d32.935643!4d-85.952365!16s%2Fg%2F11cn68py4g!19sChIJS0GtbWgLjIgRDezcWeNX01A?authuser=0&hl=en&rclk=1 | Mexican restaurant | 4.5 | nan | +1256-392-3991 | Cazadores Mexican Restaurant, 910 Cherokee Rd, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipNXYmyS-7KBnRoRKN8q4lcB54hSZ0xAWvAfpiyM=w395-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipNQ2MT2wi5NKKhC-pZo7EaHHdjkpSB7ZY8nF_Au=w224-h374-k-no', 'title': 'Menu'}, {'thumbnail': 'https://lh5.googleuserc… | ['Mexican restaurant'] | {'latitude': 32.935643, 'longitude': -85.952365} | America/Chicago | 32.935643 | -85.952365 |
| La Posada Mexican Grill | https://www.google.com/maps/place/La+Posada+Mexican+Grill/data=!4m7!3m6!1s0x888c0c988ca012ab:0xe60f591a8f4ad5de!8m2!3d32.926932!4d-85.9649187!16s%2Fg%2F1th0np26!19sChIJqxKgjJgMjIgR3tVKjxpZD-Y?authuser=0&hl=en&rclk=1 | Mexican restaurant | 4.3 | http://www.laposadamexicangrill.net/ | +1256-329-3005 | La Posada Mexican Grill, 3714 US-280, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipObByCaI680CjslafAYUsNyPtIdkvzLg4wk3N7u=w645-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://streetviewpixels-pa.googleapis.com/v1/thumbnail?panoid=KCvpp8uJVt8cyxAImtjj4w&cb_client=maps_sv.tactile.gps&w=224&h=298&yaw=232.91544&pitch=0&thum… | ['Mexican restaurant', 'Latin American restaurant'] | {'latitude': 32.926932, 'longitude': -85.9649187} | America/Chicago | 32.926932 | -85.9649187 |
| Carlos Mexican Grill | https://www.google.com/maps/place/Carlos+Mexican+Grill/data=!4m7!3m6!1s0x888c0b6b5c1e3aa5:0xe6bd37ae6296c713!8m2!3d32.9452512!4d-85.9547877!16s%2Fg%2F1tfln67x!19sChIJpToeXGsLjIgRE8eWYq43veY?authuser=0&hl=en&rclk=1 | Mexican restaurant | 4.1 | https://carlos-mexican-grill.business.site/ | +1256-329-9901 | Carlos Mexican Grill, 136 Wheeler St, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipNPR9cvZlkJ-TL_GidWuwqrDSC9fNFwkCRJbDc-=w447-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipMEir0H1mcnUACI2i0tftmPYHl6ugQ1j5vxK4yI=w224-h298-k-no', 'title': 'Menu'}, {'thumbnail': 'https://lh5.googleuserc… | ['Mexican restaurant', 'Grill'] | {'latitude': 32.9452512, 'longitude': -85.9547877} | America/Chicago | 32.9452512 | -85.9547877 |
| Ruby Tuesday | https://www.google.com/maps/place/Ruby+Tuesday/data=!4m7!3m6!1s0x888c0cab98dac1df:0x22fbd43854c09868!8m2!3d32.9237923!4d-85.959552!16s%2Fg%2F1td2_6yc!19sChIJ38HamKsMjIgRaJjAVDjU-yI?authuser=0&hl=en&rclk=1 | American restaurant | 3.7 | https://rubytuesday.com/ | +1256-234-4047 | Ruby Tuesday, 4097 US-280 U, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipMVRjyBogpRwbxmJN-54DpecEClxCCN25GRlW_R=w397-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipPnJ63L9fpJOgwoD5c1iKnYlqvWLPMor34T8lVp=w529-h298-k-no', 'title': 'Latest'}, {'thumbnail': 'https://lh5.googleuse… | ['American restaurant'] | {'latitude': 32.923792299999995, 'longitude': -85.959552} | America/Chicago | 32.9237923 | -85.959552 |
| Castelluccio Fine Italian Dining | https://www.google.com/maps/place/Castelluccio+Fine+Italian+Dining/data=!4m7!3m6!1s0x888c0b1b4fe7e639:0x633d3b2d6c9eae57!8m2!3d32.9439739!4d-85.9530075!16s%2Fg%2F11n5lbbt26!19sChIJOebnTxsLjIgRV66ebC07PWM?authuser=0&hl=en&rclk=1 | Italian restaurant | 4.4 | https://www.facebook.com/CastelluccioFineItalianDining/ | +1256-392-5604 | Castelluccio Fine Italian Dining, 107 Alabama St, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipOoXYD751Sh0A_pU7MBRVxGeatGbvk3KMb7IoHh=w258-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipNtco_ocdQ-YeEi2sUJ7eH08W5fWDhEkCTD3E09=w224-h298-k-no', 'title': 'Menu'}, {'thumbnail': 'https://lh5.googleuserc… | ['Italian restaurant'] | {'latitude': 32.943973899999996, 'longitude': -85.9530075} | America/Chicago | 32.9439739 | -85.9530075 |
| Who's Diner | https://www.google.com/maps/place/Who%27s+Diner/data=!4m7!3m6!1s0x888c0b6814b44301:0xde0a5abab89f5294!8m2!3d32.9333441!4d-85.9724874!16s%2Fg%2F1262g51nb!19sChIJAUO0FGgLjIgRlFKfuLpaCt4?authuser=0&hl=en&rclk=1 | Diner | 4.5 | nan | +1256-212-1501 | Who's Diner, 1560 AL-22, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipNPpIVSMR13bU32zMB-I4Lir9Xeu870YLxVtvbk=w397-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://streetviewpixels-pa.googleapis.com/v1/thumbnail?panoid=J8yLHxRKUE-scDaSdqtY9w&cb_client=maps_sv.tactile.gps&w=224&h=298&yaw=293.8163&pitch=0&thumb… | ['Diner', 'Breakfast restaurant'] | {'latitude': 32.9333441, 'longitude': -85.97248739999999} | America/Chicago | 32.9333441 | -85.9724874 |
| JR’s Sportsbar and Grill | https://www.google.com/maps/place/JR%E2%80%99s+Sportsbar+and+Grill/data=!4m7!3m6!1s0x888c0b6aec6dbeb1:0x5b534b3cafea15ea!8m2!3d32.9443702!4d-85.9523315!16s%2Fg%2F1tqtyn77!19sChIJsb5t7GoLjIgR6hXqrzxLU1s?authuser=0&hl=en&rclk=1 | Bar & grill | 4.0 | http://www.jrssportsbarandgrill.com/ | +1256-329-2328 | JR’s Sportsbar and Grill, 145 Alabama St, Alexander City, AL 35010, United States | [{'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipNjbU8mcsHCiXmHnrN-7b9G09MB3vLfmeu1U4ec=w224-h298-k-no', 'title': 'All'}, {'thumbnail': 'https://lh5.googleusercontent.com/p/AF1QipP0c7TGEFUfyTtfokUm5OoyLpnKy6prZw-oXPaz=w224-h298-k-no', 'title': 'Menu'}, {'thumbnail': 'https://lh5.googleuserc… | ['Bar & grill'] | {'latitude': 32.9443702, 'longitude': -85.9523315} | America/Chicago | 32.9443702 | -85.9523315 |
CREATE TABLE n_380k_us_restaurants (
"title" VARCHAR,
"link" VARCHAR,
"category" VARCHAR,
"rating" VARCHAR,
"website" VARCHAR,
"phone" VARCHAR,
"address" VARCHAR,
"images" VARCHAR,
"categories" VARCHAR,
"geo_coordinates" VARCHAR,
"time_zone" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR
);