Restaurants On Yellowpages.com

6,000 Restaurants on Yellowpages.com

@kaggle.promptcloudhq_restaurants_on_yellowpagescom

Table List

1 table(695.89 KB)

Yellowpages Com Restaurant Sample 1

@kaggle.promptcloudhq_restaurants_on_yellowpagescom.yellowpages_com_restaurant_sample_1

695.89 KB
6000 rows
11 columns

uniq_id Uniq Id	url Url	name Name	street Street	zip_code Zip Code	city City	state State	phone Phone	email Email	website Website	categories Categories
8818b239af04554c3d78e50fde37b2be	http://www.yellowpages.com/revere-ma/mip/ital-uil-usa-459527423?lid=459527423	Ital Uil Usa	199 Revere St	2151	Revere	MA	(781) 284-6425	nan	nan	Italian Restaurants, Mediterranean Restaurants, Restaurants
24db17d57d8def6e0e9d8b4086a13457	http://www.yellowpages.com/watertown-ma/mip/sbarro-7058407?lid=7058407	Sbarro	455 Arsenal St	2472	Watertown	MA	(617) 926-9372	nan	http://www.sbarro.com	Pizza, Italian Restaurants, Family Style Restaurants, Restaurants, Fast Food Restaurants
9285fda8cc37ecd02a9d85ca1f5d9631	http://www.yellowpages.com/medford-ma/mip/helens-roastbeef-pizzeria-11278421?lid=11278421	Helens Roastbeef Pizzeria	321A Boston Ave	2155	Medford	MA	(781) 395-9097	nan	nan	Italian Restaurants, Pizza, American Restaurants, Steak Houses, Sandwich Shops, Restaurants
b68ae4954fd6975b82f28fb1299d9e35	http://www.yellowpages.com/west-roxbury-ma/mip/west-napoli-cafe-9948406?lid=9948406	West Napoli Cafe	1946 Centre St	2132	West Roxbury	MA	(617) 325-7909	nan	http://www.westnapolipizza.com	Pizza, Italian Restaurants, Sandwich Shops, Restaurants
a354f7f7a3907bc8b21bbd7ba9c632e8	http://www.yellowpages.com/newton-ma/mip/uno-chicago-grill-464769243?lid=464769243	Uno Chicago Grill	287 Washington St	2458	Newton	MA	(617) 964-7663	mail@unos.com	http://www.unos.com	Restaurants, Pizza, Bar & Grills, Take Out Restaurants, Italian Restaurants
e2d27eac972de2d2fa029e9611030b9d	http://www.yellowpages.com/arlington-ma/mip/arlington-house-of-pizza-6883161?lid=6883161	Arlington House Of Pizza	797 Massachusetts Ave	2476	Arlington	MA	(781) 646-5016	nan	http://www.arlingtonhouseofpizza.com	Pizza, Italian Restaurants, Restaurants
a9507573ee5a84fde2789320e0a8a78e	http://www.yellowpages.com/winthrop-ma/mip/letteries-italian-market-10958603?lid=10958603	Letterie's Italian Market	67 Woodside Ave	2152	Winthrop	MA	(617) 846-0351	nan	nan	Italian Restaurants, Delicatessens, Mediterranean Restaurants, Restaurants
0c989ba52903dd0fd3071c5985b3c991	http://www.yellowpages.com/boston-ma/mip/aragosta-bar-and-bistro-465271887?lid=465271887	Aragosta Bar and Bistro	3 Battery Wharf	2109	Boston	MA	(617) 994-9036	info@aragostabistro.com	http://www.aragostabistro.com	Italian Restaurants
2005df67e10813c82a04b3c3848d202e	http://www.yellowpages.com/stoneham-ma/mip/andreas-house-of-pizza-10495215?lid=10495215	Andrea's House Of Pizza	498 Main St	2180	Stoneham	MA	(781) 438-9115	CKomburas@coldcuts.com	http://andreashouseofpizza.com	Pizza, Convenience Stores, Delicatessens, American Restaurants, Sandwich Shops, Italian Restaurants, Restaurants
29d24e2ea14584e8f406bab7a4d2c367	http://www.yellowpages.com/arlington-ma/mip/my-brothers-place-8030303?lid=8030303	My Brothers Place	181 Broadway	2474	Arlington	MA	(781) 646-0110	Emmanuelstr@gmail.com	http://mybrothersplacearlington.net	Pizza, American Restaurants, Sandwich Shops, Italian Restaurants, Restaurants


CREATE TABLE yellowpages_com_restaurant_sample_1 (
  "uniq_id" VARCHAR,
  "url" VARCHAR,
  "name" VARCHAR,
  "street" VARCHAR,
  "zip_code" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "website" VARCHAR,
  "categories" VARCHAR
);