yelp_com category_2
Specific business subcategories nested under the category_1 top-level category hierarchy.
You are browsing sample data.
{
"sample": {
"is_sample": "TRUE",
"limit_total": 200
},
"api": {
"title": "Business 1",
"point": {
"title": "By Table",
"desc": "Each API function returns data by a specific database table. "
}
},
"input": {
"url": false,
"get": false,
"post": false
},
"links": {
"up": {
"href": "https://www.datasn.com/n3a2/yelp_com/"
},
"home": {
"href": "https://www.datasn.com/n3a2/yelp_com/category_2/?app=html-json&manifest=row"
},
"next": {
"href": "https://www.datasn.com/n3a2/yelp_com/category_2/2/?app=html-json&manifest=row"
}
},
"meta": {
"query": {
"page": 1,
"limit": 100,
"limit_total": 200,
"time": "0.0024"
},
"stats": {
"raw_rows": 100,
"rows": 100,
"rows_total": 1382,
"pages_total": 14
},
"struct": {
"stem": {
"0": "category_2"
},
"leaf": "category_2.id",
"leaf_stem": {},
"leaf_stem_leaf": null
}
},
"output": {
"rows": {
"1": {
"category_2.id": 1,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Bagels"
},
"2": {
"category_2.id": 2,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Bakeries"
},
"3": {
"category_2.id": 3,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Beer, Wine & Spirits"
},
"4": {
"category_2.id": 4,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Breweries"
},
"5": {
"category_2.id": 5,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Butcher"
},
"6": {
"category_2.id": 6,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Candy Stores"
},
"7": {
"category_2.id": 7,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Cheese Shops"
},
"8": {
"category_2.id": 8,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Chocolatiers & Shops"
},
"9": {
"category_2.id": 9,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Churros"
},
"10": {
"category_2.id": 10,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Cideries"
},
"11": {
"category_2.id": 11,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Coffee & Tea"
},
"12": {
"category_2.id": 12,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Coffee Roasteries"
},
"13": {
"category_2.id": 13,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Convenience Stores"
},
"14": {
"category_2.id": 14,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Cupcakes"
},
"15": {
"category_2.id": 15,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Custom Cakes"
},
"16": {
"category_2.id": 16,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Delicatessen"
},
"17": {
"category_2.id": 17,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Desserts"
},
"18": {
"category_2.id": 18,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Distilleries"
},
"19": {
"category_2.id": 19,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Do-It-Yourself Food"
},
"20": {
"category_2.id": 20,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Donuts"
},
"21": {
"category_2.id": 21,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Empanadas"
},
"22": {
"category_2.id": 22,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Ethic Grocery"
},
"23": {
"category_2.id": 23,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Farmers Market"
},
"24": {
"category_2.id": 24,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Food Delivery Services"
},
"25": {
"category_2.id": 25,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Food Trucks"
},
"26": {
"category_2.id": 26,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Fruits & Veggies"
},
"27": {
"category_2.id": 27,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Grocery"
},
"28": {
"category_2.id": 28,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Health Markets"
},
"29": {
"category_2.id": 29,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Herbs & Spices"
},
"30": {
"category_2.id": 30,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Ice Cream & Frozen Yogurt"
},
"31": {
"category_2.id": 31,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Imported Food"
},
"32": {
"category_2.id": 32,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "International Grocery"
},
"33": {
"category_2.id": 33,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Internet Cafes"
},
"34": {
"category_2.id": 34,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Juice Bars & Smoothies"
},
"35": {
"category_2.id": 35,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Kiosk"
},
"36": {
"category_2.id": 36,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Macarons"
},
"37": {
"category_2.id": 37,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Meat Shops"
},
"38": {
"category_2.id": 38,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Organic Stores"
},
"39": {
"category_2.id": 39,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Pasta Shops"
},
"40": {
"category_2.id": 40,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Patisserie/Cake Shop"
},
"41": {
"category_2.id": 41,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Salumerie"
},
"42": {
"category_2.id": 42,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Seafood Markets"
},
"43": {
"category_2.id": 43,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Shaved Ice"
},
"44": {
"category_2.id": 44,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Specialty Food"
},
"45": {
"category_2.id": 45,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Street Vendors"
},
"46": {
"category_2.id": 46,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Tea Rooms"
},
"47": {
"category_2.id": 47,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Wine Tasting Room"
},
"48": {
"category_2.id": 48,
"category_2.ts": "2016-11-03 02:29:09",
"category_2.title": "Wineries"
},
"49": {
"category_2.id": 49,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Adult Entertainment"
},
"50": {
"category_2.id": 50,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Airport Lounges"
},
"51": {
"category_2.id": 51,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Bar Crawl"
},
"52": {
"category_2.id": 52,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Bars"
},
"53": {
"category_2.id": 53,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Beach Bars"
},
"54": {
"category_2.id": 54,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Beer Bar"
},
"55": {
"category_2.id": 55,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Champagne Bars"
},
"56": {
"category_2.id": 56,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Cocktail Bars"
},
"57": {
"category_2.id": 57,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Comedy Clubs"
},
"58": {
"category_2.id": 58,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Dance Clubs"
},
"59": {
"category_2.id": 59,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Dive Bars"
},
"60": {
"category_2.id": 60,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Gay Bars"
},
"61": {
"category_2.id": 61,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Hookah Bars"
},
"62": {
"category_2.id": 62,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Irish Pub"
},
"63": {
"category_2.id": 63,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Jazz & Blues"
},
"64": {
"category_2.id": 64,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Karaoke"
},
"65": {
"category_2.id": 65,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Lounges"
},
"66": {
"category_2.id": 66,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Music Venues"
},
"67": {
"category_2.id": 67,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Piano Bars"
},
"68": {
"category_2.id": 68,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Pool Halls"
},
"69": {
"category_2.id": 69,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Pubs"
},
"70": {
"category_2.id": 70,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Speakeasies"
},
"71": {
"category_2.id": 71,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Sports Bars"
},
"72": {
"category_2.id": 72,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Tiki Bars"
},
"73": {
"category_2.id": 73,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Vermouth Bars"
},
"74": {
"category_2.id": 74,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Whiskey Bars"
},
"75": {
"category_2.id": 75,
"category_2.ts": "2016-11-03 02:29:11",
"category_2.title": "Wine Bars"
},
"76": {
"category_2.id": 76,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Afghan"
},
"77": {
"category_2.id": 77,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "African"
},
"78": {
"category_2.id": 78,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "American (Traditional)"
},
"79": {
"category_2.id": 79,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Arabian"
},
"80": {
"category_2.id": 80,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Argentine"
},
"81": {
"category_2.id": 81,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Armenian"
},
"82": {
"category_2.id": 82,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Asian Fusion"
},
"83": {
"category_2.id": 83,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Australian"
},
"84": {
"category_2.id": 84,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Austrian"
},
"85": {
"category_2.id": 85,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Bangladeshi"
},
"86": {
"category_2.id": 86,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Barbeque"
},
"87": {
"category_2.id": 87,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Basque"
},
"88": {
"category_2.id": 88,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Belgian"
},
"89": {
"category_2.id": 89,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Bistros"
},
"90": {
"category_2.id": 90,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Brazilian"
},
"91": {
"category_2.id": 91,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Breakfast & Brunch"
},
"92": {
"category_2.id": 92,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "British"
},
"93": {
"category_2.id": 93,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Buffets"
},
"94": {
"category_2.id": 94,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Bulgarian"
},
"95": {
"category_2.id": 95,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Burgers"
},
"96": {
"category_2.id": 96,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Burmese"
},
"97": {
"category_2.id": 97,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Cafeteria"
},
"98": {
"category_2.id": 98,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Cajun/Creole"
},
"99": {
"category_2.id": 99,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Cambodian"
},
"100": {
"category_2.id": 100,
"category_2.ts": "2016-11-03 02:29:20",
"category_2.title": "Cantonese"
}
}
}
}
Table Overview:
The category_2 table contains more specific business categories nested under the category_1 hierarchy. The title column stores the subcategory name, _yf_slug stores its URL-friendly identifier, and category_1_id is intended to link the subcategory to a parent top-level category. The record ID and timestamp identify and date each record. The sample data uses category_1_id to represent the parent-category relationship.
Table Stats:
Size 208K
Columns 5
Rows (screenshot) 1,382
Rows (engine) 1,382