This data as json, CSV (advanced)
Link | rowid ▼ | id | name | url | review_count | categories | rating | price | street | city | zip_code | state |
---|---|---|---|---|---|---|---|---|---|---|---|---|
864 | 864 | Ye2rr7EnLpqYrpEGZIFwRg | IIMORI Gyoza Bar | https://www.yelp.com/biz/iimori-gyoza-bar-frankfurt-am-main-2?adjust_creative=bAjUDwbbGYEWxyJGZW2dKQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=bAjUDwbbGYEWxyJGZW2dKQ | 15 | Japanese | 3.0 | €€ | Mainzer Landstr. 125 | Frankfurt | 60327 | HE |
1864 | 1864 | Ye2rr7EnLpqYrpEGZIFwRg | IIMORI Gyoza Bar | https://www.yelp.com/biz/iimori-gyoza-bar-frankfurt-am-main-2?adjust_creative=bAjUDwbbGYEWxyJGZW2dKQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=bAjUDwbbGYEWxyJGZW2dKQ | 15 | Japanese | 3.0 | €€ | Mainzer Landstr. 125 | Frankfurt | 60327 | HE |
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 );