yelp_com city
No table description or topics provided.
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/city/?app=html-json&manifest=row"
},
"next": {
"href": "https://www.datasn.com/n3a2/yelp_com/city/2/?app=html-json&manifest=row"
}
},
"meta": {
"query": {
"page": 1,
"limit": 50,
"limit_total": 200,
"time": 0.0022899999999999999349131751813501978176645934581756591796875
},
"stats": {
"raw_rows": 50,
"rows": 50,
"rows_total": 219,
"pages_total": 5
},
"struct": {
"stem": {
"0": "city",
"1": "region"
},
"leaf": "city.id",
"leaf_stem": {},
"leaf_stem_leaf": null
}
},
"output": {
"rows": {
"1": {
"city.id": 1,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Buenos Aires",
"region.id": 1,
"region.ts": "2016-11-03 01:59:18",
"region.title": "ARGENTINA"
},
"2": {
"city.id": 2,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Adelaide",
"region.id": 2,
"region.ts": "2016-11-03 01:59:18",
"region.title": "AUSTRALIA"
},
"3": {
"city.id": 3,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Brisbane",
"region.id": 2,
"region.ts": "2016-11-03 01:59:18",
"region.title": "AUSTRALIA"
},
"4": {
"city.id": 4,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Melbourne",
"region.id": 2,
"region.ts": "2016-11-03 01:59:18",
"region.title": "AUSTRALIA"
},
"5": {
"city.id": 5,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Perth",
"region.id": 2,
"region.ts": "2016-11-03 01:59:18",
"region.title": "AUSTRALIA"
},
"6": {
"city.id": 6,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Sydney",
"region.id": 2,
"region.ts": "2016-11-03 01:59:18",
"region.title": "AUSTRALIA"
},
"7": {
"city.id": 7,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Wien",
"region.id": 3,
"region.ts": "2016-11-03 01:59:18",
"region.title": "AUSTRIA"
},
"8": {
"city.id": 8,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Antwerpen",
"region.id": 4,
"region.ts": "2016-11-03 01:59:18",
"region.title": "BELGIUM"
},
"9": {
"city.id": 9,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Bruxelles",
"region.id": 4,
"region.ts": "2016-11-03 01:59:18",
"region.title": "BELGIUM"
},
"10": {
"city.id": 10,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Rio de Janeiro",
"region.id": 5,
"region.ts": "2016-11-03 01:59:18",
"region.title": "BRAZIL"
},
"11": {
"city.id": 11,
"city.ts": "2016-11-03 01:59:18",
"city.title": "São Paulo",
"region.id": 5,
"region.ts": "2016-11-03 01:59:18",
"region.title": "BRAZIL"
},
"12": {
"city.id": 12,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Calgary",
"region.id": 6,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CANADA"
},
"13": {
"city.id": 13,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Edmonton",
"region.id": 6,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CANADA"
},
"14": {
"city.id": 14,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Halifax",
"region.id": 6,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CANADA"
},
"15": {
"city.id": 15,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Montréal",
"region.id": 6,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CANADA"
},
"16": {
"city.id": 16,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Ottawa",
"region.id": 6,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CANADA"
},
"17": {
"city.id": 17,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Toronto",
"region.id": 6,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CANADA"
},
"18": {
"city.id": 18,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Vancouver",
"region.id": 6,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CANADA"
},
"19": {
"city.id": 19,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Santiago",
"region.id": 7,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CHILE"
},
"20": {
"city.id": 20,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Praha",
"region.id": 8,
"region.ts": "2016-11-03 01:59:18",
"region.title": "CZECH REPUBLIC"
},
"21": {
"city.id": 21,
"city.ts": "2016-11-03 01:59:18",
"city.title": "København",
"region.id": 9,
"region.ts": "2016-11-03 01:59:18",
"region.title": "DENMARK"
},
"22": {
"city.id": 22,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Helsinki",
"region.id": 10,
"region.ts": "2016-11-03 01:59:18",
"region.title": "FINLAND"
},
"23": {
"city.id": 23,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Lyon",
"region.id": 11,
"region.ts": "2016-11-03 01:59:18",
"region.title": "FRANCE"
},
"24": {
"city.id": 24,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Marseille",
"region.id": 11,
"region.ts": "2016-11-03 01:59:18",
"region.title": "FRANCE"
},
"25": {
"city.id": 25,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Paris",
"region.id": 11,
"region.ts": "2016-11-03 01:59:18",
"region.title": "FRANCE"
},
"26": {
"city.id": 26,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Berlin",
"region.id": 12,
"region.ts": "2016-11-03 01:59:18",
"region.title": "GERMANY"
},
"27": {
"city.id": 27,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Frankfurt am Main",
"region.id": 12,
"region.ts": "2016-11-03 01:59:18",
"region.title": "GERMANY"
},
"28": {
"city.id": 28,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Hamburg",
"region.id": 12,
"region.ts": "2016-11-03 01:59:18",
"region.title": "GERMANY"
},
"29": {
"city.id": 29,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Köln",
"region.id": 12,
"region.ts": "2016-11-03 01:59:18",
"region.title": "GERMANY"
},
"30": {
"city.id": 30,
"city.ts": "2016-11-03 01:59:18",
"city.title": "München",
"region.id": 12,
"region.ts": "2016-11-03 01:59:18",
"region.title": "GERMANY"
},
"31": {
"city.id": 31,
"city.ts": "2016-11-03 01:59:18",
"city.title": "香港",
"region.id": 13,
"region.ts": "2016-11-03 01:59:18",
"region.title": "HONG KONG"
},
"32": {
"city.id": 32,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Milano",
"region.id": 14,
"region.ts": "2016-11-03 01:59:18",
"region.title": "ITALY"
},
"33": {
"city.id": 33,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Roma",
"region.id": 14,
"region.ts": "2016-11-03 01:59:18",
"region.title": "ITALY"
},
"34": {
"city.id": 34,
"city.ts": "2016-11-03 01:59:18",
"city.title": "大阪市",
"region.id": 15,
"region.ts": "2016-11-03 01:59:18",
"region.title": "JAPAN"
},
"35": {
"city.id": 35,
"city.ts": "2016-11-03 01:59:18",
"city.title": "東京",
"region.id": 15,
"region.ts": "2016-11-03 01:59:18",
"region.title": "JAPAN"
},
"36": {
"city.id": 36,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Kuala Lumpur",
"region.id": 16,
"region.ts": "2016-11-03 01:59:18",
"region.title": "MALAYSIA"
},
"37": {
"city.id": 37,
"city.ts": "2016-11-03 01:59:18",
"city.title": "México, D.F.",
"region.id": 17,
"region.ts": "2016-11-03 01:59:18",
"region.title": "MEXICO"
},
"38": {
"city.id": 38,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Auckland",
"region.id": 18,
"region.ts": "2016-11-03 01:59:18",
"region.title": "NEW ZEALAND"
},
"39": {
"city.id": 39,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Oslo",
"region.id": 19,
"region.ts": "2016-11-03 01:59:18",
"region.title": "NORWAY"
},
"40": {
"city.id": 40,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Manila",
"region.id": 20,
"region.ts": "2016-11-03 01:59:18",
"region.title": "PHILIPPINES"
},
"41": {
"city.id": 41,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Kraków",
"region.id": 21,
"region.ts": "2016-11-03 01:59:18",
"region.title": "POLAND"
},
"42": {
"city.id": 42,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Warszawa",
"region.id": 21,
"region.ts": "2016-11-03 01:59:18",
"region.title": "POLAND"
},
"43": {
"city.id": 43,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Lisboa",
"region.id": 22,
"region.ts": "2016-11-03 01:59:18",
"region.title": "PORTUGAL"
},
"44": {
"city.id": 44,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Dublin",
"region.id": 23,
"region.ts": "2016-11-03 01:59:18",
"region.title": "REPUBLIC OF IRELAND"
},
"45": {
"city.id": 45,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Singapore",
"region.id": 24,
"region.ts": "2016-11-03 01:59:18",
"region.title": "SINGAPORE"
},
"46": {
"city.id": 46,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Barcelona",
"region.id": 25,
"region.ts": "2016-11-03 01:59:18",
"region.title": "SPAIN"
},
"47": {
"city.id": 47,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Madrid",
"region.id": 25,
"region.ts": "2016-11-03 01:59:18",
"region.title": "SPAIN"
},
"48": {
"city.id": 48,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Stockholm",
"region.id": 26,
"region.ts": "2016-11-03 01:59:18",
"region.title": "SWEDEN"
},
"49": {
"city.id": 49,
"city.ts": "2016-11-03 01:59:18",
"city.title": "Zürich",
"region.id": 27,
"region.ts": "2016-11-03 01:59:18",
"region.title": "SWITZERLAND"
},
"50": {
"city.id": 50,
"city.ts": "2016-11-03 01:59:18",
"city.title": "台北市",
"region.id": 28,
"region.ts": "2016-11-03 01:59:18",
"region.title": "TAIWAN"
}
}
}
}
Table Stats:
Size 64K
Columns 5
Rows (screenshot) 219
Rows (engine) 219