This data as json, CSV (advanced)
Link | rowid ▼ | id | name | url | review_count | categories | rating | price | street | city | zip_code | state |
---|---|---|---|---|---|---|---|---|---|---|---|---|
892 | 892 | pnyNC2_4RPmXHHfHd27k8g | Villa Leonhardi | https://www.yelp.com/biz/villa-leonhardi-frankfurt-am-main?adjust_creative=bAjUDwbbGYEWxyJGZW2dKQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=bAjUDwbbGYEWxyJGZW2dKQ | 12 | Italian | 3.5 | €€€ | Zeppelinallee 18 | Frankfurt | 60325 | HE |
1892 | 1892 | pnyNC2_4RPmXHHfHd27k8g | Villa Leonhardi | https://www.yelp.com/biz/villa-leonhardi-frankfurt-am-main?adjust_creative=bAjUDwbbGYEWxyJGZW2dKQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=bAjUDwbbGYEWxyJGZW2dKQ | 12 | Italian | 3.5 | €€€ | Zeppelinallee 18 | Frankfurt | 60325 | 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 );