frankfurt

2 rows where categories = "Italian, Pizza" and review_count = 87

descending

Link	rowid ▼	id	name	url	review_count	categories	rating	price	street	city	zip_code	state
349	349	rAF745Lptc7ytfDDjoXrlQ	Zimt & Koriander	https://www.yelp.com/biz/zimt-und-koriander-frankfurt-am-main-3?adjust_creative=bAjUDwbbGYEWxyJGZW2dKQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=bAjUDwbbGYEWxyJGZW2dKQ	87	Italian, Pizza	3.0	€€	Schärfengässchen 4	Frankfurt	60313	HE
1349	1349	rAF745Lptc7ytfDDjoXrlQ	Zimt & Koriander	https://www.yelp.com/biz/zimt-und-koriander-frankfurt-am-main-3?adjust_creative=bAjUDwbbGYEWxyJGZW2dKQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=bAjUDwbbGYEWxyJGZW2dKQ	87	Italian, Pizza	3.0	€€	Schärfengässchen 4	Frankfurt	60313	HE

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE frankfurt ( id TEXT, name TEXT, url TEXT, review_count TEXT, categories TEXT, rating TEXT, price TEXT, street TEXT, city TEXT, zip_code TEXT, state TEXT );