city.id,city.ts,city.city,city.city_en,city.country,city.provience,region.id,region.ts,region.region
1,"2018-05-29 03:19:35",曼谷,Bangkok,泰国,,1,"2018-05-28 04:03:58",亚洲
2,"2018-05-30 01:48:44",新加坡,Singapore,新加坡,,1,"2018-05-28 04:03:58",亚洲
3,"2018-05-30 01:52:12",东京,Tokyo,日本,东京都,1,"2018-05-28 04:03:58",亚洲
4,"2018-05-30 01:55:47",大阪,Osaka,日本,大阪府,1,"2018-05-28 04:03:58",亚洲
5,"2018-05-30 02:01:18",清迈,"Chiang Mai",泰国,清迈府,1,"2018-05-28 04:03:58",亚洲
6,"2018-05-30 02:19:50",巴厘岛,Bali,,,1,"2018-05-28 04:03:58",亚洲
7,"2018-05-30 02:23:55",吉隆坡,"Kuala Lumpur",马来西亚,,1,"2018-05-28 04:03:58",亚洲
8,"2018-05-30 02:28:42",芭堤雅,Pattaya,泰国,,1,"2018-05-28 04:03:58",亚洲
9,"2018-05-30 02:29:47",哥打京那巴鲁,"Kota Kinabalu",马来西亚,沙巴,1,"2018-05-28 04:03:58",亚洲
10,"2018-05-30 02:35:19",京都,Kyoto,日本,京都府,1,"2018-05-28 04:03:58",亚洲
11,"2018-05-30 02:35:29",那霸,Naha,日本,冲绳县,1,"2018-05-28 04:03:58",亚洲
12,"2018-05-30 02:37:40",苏梅岛,"Koh Samui",泰国,,1,"2018-05-28 04:03:58",亚洲
13,"2018-05-30 02:39:44",甲米,Krabi,泰国,甲米府,1,"2018-05-28 04:03:58",亚洲
14,"2018-05-30 02:44:08",胡志明市,"Ho Chi Minh City",越南,,1,"2018-05-28 04:03:58",亚洲
15,"2018-05-30 02:44:42",迪拜,Dubai,阿联酋,,1,"2018-05-28 04:03:58",亚洲
16,"2018-05-30 02:46:05",巴黎,Paris,法国,,2,"2018-05-28 04:03:58",欧洲
17,"2018-05-30 02:49:46",伦敦,London,英国,,2,"2018-05-28 04:03:58",欧洲
18,"2018-05-30 02:53:25",米兰,Milan,意大利,,2,"2018-05-28 04:03:58",欧洲
19,"2018-05-28 04:03:58",法兰克福,Frankfurt,德国,黑森州,2,"2018-05-28 04:03:58",欧洲
20,"2018-05-30 03:12:44",罗马,Rome,意大利,,2,"2018-05-28 04:03:58",欧洲
21,"2018-05-30 03:16:01",巴塞罗那,Barcelona,西班牙,,2,"2018-05-28 04:03:58",欧洲
22,"2018-05-30 03:16:19",慕尼黑,Munich,德国,,2,"2018-05-28 04:03:58",欧洲
23,"2018-05-30 03:23:32",莫斯科,Moscow,俄罗斯,莫斯科州,2,"2018-05-28 04:03:58",欧洲
24,"2018-05-30 03:24:19",阿姆斯特丹,Amsterdam,荷兰,,2,"2018-05-28 04:03:58",欧洲
25,"2018-05-30 03:28:13",马德里,Madrid,西班牙,,2,"2018-05-28 04:03:58",欧洲
26,"2018-05-30 03:33:15",佛罗伦萨,Florence,意大利,,2,"2018-05-28 04:03:58",欧洲
27,"2018-05-30 03:35:29",威尼斯,Venice,意大利,,2,"2018-05-28 04:03:58",欧洲
28,"2018-05-30 03:39:33",布拉格,Prague,捷克,,2,"2018-05-28 04:03:58",欧洲
29,"2018-05-30 03:41:16",维也纳,Vienna,奥地利,,2,"2018-05-28 04:03:58",欧洲
30,"2018-05-30 03:41:53",柏林,Berlin,德国,柏林州,2,"2018-05-28 04:03:58",欧洲
31,"2018-05-30 03:42:11",苏黎世,Zurich,瑞士,苏黎世州,2,"2018-05-28 04:03:58",欧洲
32,"2018-05-30 03:43:25",雅典,Athens,,,2,"2018-05-28 04:03:58",欧洲
33,"2018-05-30 03:44:38",爱丁堡,Edinburgh,英国,,2,"2018-05-28 04:03:58",欧洲
34,"2018-05-30 03:47:18",洛杉矶,"Los Angeles",美国,,3,"2018-05-28 04:03:58",美洲
35,"2018-05-28 04:03:58",拉斯维加斯,"Las Vegas",美国,内华达州,3,"2018-05-28 04:03:58",美洲
36,"2018-05-30 03:47:41",纽约,"New York",美国,纽约州,3,"2018-05-28 04:03:58",美洲
37,"2018-05-30 03:47:46",旧金山,"San Francisco",美国,,3,"2018-05-28 04:03:58",美洲
38,"2018-05-30 03:47:56",温哥华,Vancouver,加拿大,,3,"2018-05-28 04:03:58",美洲
39,"2018-05-28 04:03:58",欧胡岛,Oahu,美国,夏威夷,3,"2018-05-28 04:03:58",美洲
40,"2018-05-28 04:03:58",塞班岛,Saipan,美国,,3,"2018-05-28 04:03:58",美洲
41,"2018-05-30 03:48:20",芝加哥,Chicago,美国,,3,"2018-05-28 04:03:58",美洲
42,"2018-05-30 03:49:22",多伦多,Toronto,加拿大,,3,"2018-05-28 04:03:58",美洲
43,"2018-05-30 03:49:32",波士顿,Boston,美国,马萨诸塞州,3,"2018-05-28 04:03:58",美洲
44,"2018-05-30 03:49:51",圣地亚哥,"San Diego",美国,,3,"2018-05-28 04:03:58",美洲
45,"2018-05-28 04:03:58",奥兰多,Orlando,美国,,3,"2018-05-28 04:03:58",美洲
46,"2018-05-30 03:50:21",华盛顿,Washington,美国,,3,"2018-05-28 04:03:58",美洲
47,"2018-05-30 03:50:25",西雅图,Seattle,美国,华盛顿州,3,"2018-05-28 04:03:58",美洲
48,"2018-05-28 04:03:58",关岛,Guam,美国,,3,"2018-05-28 04:03:58",美洲
49,"2018-05-30 03:50:40",迈阿密,Miami,美国,,3,"2018-05-28 04:03:58",美洲
50,"2018-05-28 04:03:58",蒙特雷郡,"Monterey County",美国,,3,"2018-05-28 04:03:58",美洲
51,"2018-05-28 04:03:58",佩吉,Page,美国,亚利桑那州,3,"2018-05-28 04:03:58",美洲
52,"2018-05-30 03:51:56",悉尼,Sydney,澳大利亚,,4,"2018-05-28 04:03:58",大洋洲
53,"2018-05-30 03:53:18",墨尔本,Melbourne,澳大利亚,维多利亚,4,"2018-05-28 04:03:58",大洋洲
54,"2018-05-30 03:54:43",奥克兰,Auckland,新西兰,,4,"2018-05-28 04:03:58",大洋洲
55,"2018-05-30 03:55:03",黄金海岸,"Gold Coast",澳大利亚,昆士兰,4,"2018-05-28 04:03:58",大洋洲
56,"2018-05-30 03:55:08",凯恩斯,Cairns,澳大利亚,昆士兰,4,"2018-05-28 04:03:58",大洋洲
57,"2018-05-30 03:55:32",布里斯班,Brisbane,澳大利亚,,4,"2018-05-28 04:03:58",大洋洲
58,"2018-05-30 03:55:48",皇后镇,Queenstown,新西兰,,4,"2018-05-28 04:03:58",大洋洲
59,"2018-05-30 03:57:10",基督城,Christchurch,新西兰,,4,"2018-05-28 04:03:58",大洋洲
60,"2018-05-30 03:57:28",阿德莱德,Adelaide,澳大利亚,南澳大利亚,4,"2018-05-28 04:03:58",大洋洲
61,"2018-05-30 03:58:10",珀斯,Perth,澳大利亚,西澳大利亚,4,"2018-05-28 04:03:58",大洋洲
62,"2018-05-30 03:58:26",特卡波湖,"Lake Tekapo",新西兰,,4,"2018-05-28 04:03:58",大洋洲
63,"2018-05-28 04:03:58",阿波罗湾,"Apollo Bay",澳大利亚,维多利亚,4,"2018-05-28 04:03:58",大洋洲
64,"2018-05-28 04:03:58",坎贝尔港,"Port Campbell",澳大利亚,维多利亚,4,"2018-05-28 04:03:58",大洋洲
65,"2018-05-30 03:58:39",霍巴特,Hobart,澳大利亚,,4,"2018-05-28 04:03:58",大洋洲
66,"2018-05-30 03:58:55",罗托鲁瓦,Rotorua,新西兰,,4,"2018-05-28 04:03:58",大洋洲
67,"2018-05-28 04:03:58",堪培拉,Canberra,澳大利亚,,4,"2018-05-28 04:03:58",大洋洲
68,"2018-05-30 03:59:07",达尼丁,Dunedin,新西兰,,4,"2018-05-28 04:03:58",大洋洲
69,"2018-05-30 03:59:15",惠灵顿,Wellington,新西兰,,4,"2018-05-28 04:03:58",大洋洲
70,"2018-05-30 03:59:47",毛里求斯,Mauritius,,,5,"2018-05-28 04:03:58",非洲
71,"2018-05-30 04:00:05",开罗,Cairo,埃及,,5,"2018-05-28 04:03:58",非洲
72,"2018-05-30 04:01:10",约翰内斯堡,Johannesburg,南非,豪登省,5,"2018-05-28 04:03:58",非洲
73,"2018-05-30 04:04:35",开普敦,"Cape Town",南非,,5,"2018-05-28 04:03:58",非洲
74,"2018-05-30 04:06:31",内罗毕,Nairobi,,,5,"2018-05-28 04:03:58",非洲
75,"2018-05-30 04:07:34",马埃岛,"Mahe Island",,,5,"2018-05-28 04:03:58",非洲
76,"2018-05-28 04:03:58",普拉兰岛,"Praslin Island",,,5,"2018-05-28 04:03:58",非洲
77,"2018-05-30 04:08:43",亚的斯亚贝巴,"Addis ababa",埃塞俄比亚,,5,"2018-05-28 04:03:58",非洲
78,"2018-05-30 04:09:04",卡萨布兰卡,Casablanca,摩洛哥,,5,"2018-05-28 04:03:58",非洲
79,"2018-05-30 04:09:16",卢克索,Luxor,埃及,卢克索省,5,"2018-05-28 04:03:58",非洲
80,"2018-05-30 04:09:34",达累斯萨拉姆,"Dar es salaam",,,5,"2018-05-28 04:03:58",非洲
81,"2018-05-30 04:17:00",马拉喀什,Marrakech,摩洛哥,,5,"2018-05-28 04:03:58",非洲
82,"2018-05-30 04:17:35",德班,Durban,南非,夸祖鲁-纳塔尔省,5,"2018-05-28 04:03:58",非洲
83,"2018-05-30 04:17:50",蒙巴萨,Mombasa,,,5,"2018-05-28 04:03:58",非洲
84,"2018-05-29 22:50:40",阿克拉,Accra,加纳,,5,"2018-05-28 04:03:58",非洲
85,"2018-05-28 04:03:58",阿斯旺,Aswan,埃及,阿斯旺省,5,"2018-05-28 04:03:58",非洲
86,"2018-05-28 04:03:58",塞舌尔拉迪戈岛,"La Digue Island",,,5,"2018-05-28 04:03:58",非洲
87,"2018-05-28 04:03:58",沙姆沙伊赫,"Sharm El Sheikh",埃及,,5,"2018-05-28 04:03:58",非洲