You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "Global City And Country Name 1", "desc": "Global city and country name data set", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/global_city_and_country_name_1/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/global_city_and_country_name_1/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/global_city_and_country_name_1/main/list/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 20, "limit_total": 400, "time": 0.0033500000000000001131039706336878225556574761867523193359375 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 1670784, "pages_total": 83540 }, "struct": { "stem": { "0": "city_name" }, "leaf": "city_name.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city_name.id": 1, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Baba Kamba", "city_name.category_1_x_city_name_id": { "1": { "category_1_x_city_name.id": 1, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "2": { "city_name.id": 2, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Baba-Ali", "city_name.category_1_x_city_name_id": { "2": { "category_1_x_city_name.id": 2, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "3": { "city_name.id": 3, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Baba-Ali-Kalay", "city_name.category_1_x_city_name_id": { "3": { "category_1_x_city_name.id": 3, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "4": { "city_name.id": 4, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Baba-Gumbakay", "city_name.category_1_x_city_name_id": { "4": { "category_1_x_city_name.id": 4, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "5": { "city_name.id": 5, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Baba-Sadik", "city_name.category_1_x_city_name_id": { "5": { "category_1_x_city_name.id": 5, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "6": { "city_name.id": 6, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Baba-Sadin", "city_name.category_1_x_city_name_id": { "6": { "category_1_x_city_name.id": 6, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "7": { "city_name.id": 7, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Baba-Sakhibkarez", "city_name.category_1_x_city_name_id": { "7": { "category_1_x_city_name.id": 7, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "8": { "city_name.id": 8, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Baba-Yusuf", "city_name.category_1_x_city_name_id": { "8": { "category_1_x_city_name.id": 8, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "9": { "city_name.id": 9, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babadost", "city_name.category_1_x_city_name_id": { "9": { "category_1_x_city_name.id": 9, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "10": { "city_name.id": 10, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babadosti", "city_name.category_1_x_city_name_id": { "10": { "category_1_x_city_name.id": 10, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "11": { "city_name.id": 11, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babadzhi", "city_name.category_1_x_city_name_id": { "11": { "category_1_x_city_name.id": 11, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "12": { "city_name.id": 12, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babagday", "city_name.category_1_x_city_name_id": { "12": { "category_1_x_city_name.id": 12, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "13": { "city_name.id": 13, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babagurzaban", "city_name.category_1_x_city_name_id": { "13": { "category_1_x_city_name.id": 13, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "14": { "city_name.id": 14, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babajī", "city_name.category_1_x_city_name_id": { "14": { "category_1_x_city_name.id": 14, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" }, "1167167": { "category_1_x_city_name.id": 1167167, "category_1.id": 3126, "category_1.ts": "2017-12-11 01:11:38", "category_1.title": "B", "category_1.country": "Nigeria", "country.id": 126, "country.ts": "2017-12-11 00:46:14", "country.title": "Nigeria" } } }, "15": { "city_name.id": 15, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babak", "city_name.category_1_x_city_name_id": { "15": { "category_1_x_city_name.id": 15, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" }, "674164": { "category_1_x_city_name.id": 674164, "category_1.id": 1976, "category_1.ts": "2017-12-11 01:10:27", "category_1.title": "B", "category_1.country": "Indonesia", "country.id": 80, "country.ts": "2017-12-11 00:46:14", "country.title": "Indonesia" }, "790598": { "category_1_x_city_name.id": 790598, "category_1.id": 2001, "category_1.ts": "2017-12-11 01:10:29", "category_1.title": "B", "category_1.country": "Iran", "country.id": 81, "country.ts": "2017-12-11 00:46:14", "country.title": "Iran" }, "1367003": { "category_1_x_city_name.id": 1367003, "category_1.id": 3351, "category_1.ts": "2017-12-11 01:11:53", "category_1.title": "B", "category_1.country": "Philippines", "country.id": 135, "country.ts": "2017-12-11 00:46:14", "country.title": "Philippines" }, "1537947": { "category_1_x_city_name.id": 1537947, "category_1.id": 3601, "category_1.ts": "2017-12-11 01:12:08", "category_1.title": "B", "category_1.country": "Senegal", "country.id": 145, "country.ts": "2017-12-11 00:46:14", "country.title": "Senegal" } } }, "16": { "city_name.id": 16, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babakala", "city_name.category_1_x_city_name_id": { "16": { "category_1_x_city_name.id": 16, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "17": { "city_name.id": 17, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babakaray", "city_name.category_1_x_city_name_id": { "17": { "category_1_x_city_name.id": 17, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "18": { "city_name.id": 18, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babakashkhar", "city_name.category_1_x_city_name_id": { "18": { "category_1_x_city_name.id": 18, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } }, "20": { "city_name.id": 20, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babakhan", "city_name.category_1_x_city_name_id": { "20": { "category_1_x_city_name.id": 20, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" }, "790797": { "category_1_x_city_name.id": 790797, "category_1.id": 2001, "category_1.ts": "2017-12-11 01:10:29", "category_1.title": "B", "category_1.country": "Iran", "country.id": 81, "country.ts": "2017-12-11 00:46:14", "country.title": "Iran" } } }, "21": { "city_name.id": 21, "city_name.ts": "2017-12-11 01:24:00", "city_name.title": "Babakheyl’", "city_name.category_1_x_city_name_id": { "21": { "category_1_x_city_name.id": 21, "category_1.id": 1, "category_1.ts": "2017-12-11 01:08:46", "category_1.title": "B", "category_1.country": "Afghanistan", "country.id": 1, "country.ts": "2017-12-11 00:46:14", "country.title": "Afghanistan" } } } } } }