city.id,city.ts,city.title,city.state,state.id,state.ts,state.title
1,"2017-10-18 03:49:28","North Birmingham",Alabama,1,"2017-10-17 02:32:26",Alabama
2,"2017-10-18 03:56:04","Mountain Brook",Alabama,1,"2017-10-17 02:32:26",Alabama
3,"2017-10-18 04:00:27",Tarrant,Alabama,1,"2017-10-17 02:32:26",Alabama
4,"2017-10-18 04:07:34",Homewood,Alabama,1,"2017-10-17 02:32:26",Alabama
5,"2017-10-18 04:14:10",Irondale,Alabama,1,"2017-10-17 02:32:26",Alabama
6,"2017-10-18 04:20:33",Vestavia,Alabama,1,"2017-10-17 02:32:26",Alabama
7,"2017-10-18 04:25:41",Forestdale,Alabama,1,"2017-10-17 02:32:26",Alabama
8,"2017-10-18 04:29:24",Fultondale,Alabama,1,"2017-10-17 02:32:26",Alabama
9,"2017-10-18 04:31:37",Anchorage,Alaska,2,"2017-10-17 02:32:26",Alaska
10,"2017-10-18 04:31:49",Barrow,Alaska,2,"2017-10-17 02:32:26",Alaska
11,"2017-10-18 04:31:55",Bethel,Alaska,2,"2017-10-17 02:32:26",Alaska
12,"2017-10-18 04:32:41",Fairbanks,Alaska,2,"2017-10-17 02:32:26",Alaska
13,"2017-10-18 04:33:00",Juneau,Alaska,2,"2017-10-17 02:32:26",Alaska
14,"2017-10-18 04:33:19",Kenai,Alaska,2,"2017-10-17 02:32:26",Alaska
15,"2017-10-18 04:33:24",Ketchikan,Alaska,2,"2017-10-17 02:32:26",Alaska
16,"2017-10-18 04:33:32",Kodiak,Alaska,2,"2017-10-17 02:32:26",Alaska
17,"2017-10-18 04:33:41",Sitka,Alaska,2,"2017-10-17 02:32:26",Alaska
18,"2017-10-18 04:34:26",Wasilla,Alaska,2,"2017-10-17 02:32:26",Alaska
19,"2017-10-18 04:53:57",Avondale,Arizona,3,"2017-10-17 02:32:26",Arizona
20,"2017-10-18 04:54:19",Buckeye,Arizona,3,"2017-10-17 02:32:26",Arizona
21,"2017-10-18 04:55:36","Bullhead City",Arizona,3,"2017-10-17 02:32:26",Arizona
22,"2017-10-18 04:56:40","Casa Grande",Arizona,3,"2017-10-17 02:32:26",Arizona
23,"2017-10-18 05:00:31",Chandler,Arizona,3,"2017-10-17 02:32:26",Arizona
24,"2017-10-18 05:01:25",Flagstaff,Arizona,3,"2017-10-17 02:32:26",Arizona
25,"2017-10-18 05:14:19",Gilbert,Arizona,3,"2017-10-17 02:32:26",Arizona
26,"2017-10-18 05:24:38",Glendale,Arizona,3,"2017-10-17 02:32:26",Arizona
27,"2017-10-18 05:43:54",Goodyear,Arizona,3,"2017-10-17 02:32:26",Arizona
28,"2017-10-18 05:45:00","Lake Havasu City",Arizona,3,"2017-10-17 02:32:26",Arizona
29,"2017-10-18 05:46:35",Marana,Arizona,3,"2017-10-17 02:32:26",Arizona
30,"2017-10-18 05:48:43",Maricopa,Arizona,3,"2017-10-17 02:32:26",Arizona
31,"2017-10-18 05:59:58",Mesa,Arizona,3,"2017-10-17 02:32:26",Arizona
32,"2017-10-18 06:03:58","Oro Valley",Arizona,3,"2017-10-17 02:32:26",Arizona
33,"2017-10-18 06:19:41",Peoria,Arizona,3,"2017-10-17 02:32:26",Arizona
34,"2017-10-18 06:33:03",Phoenix,Arizona,3,"2017-10-17 02:32:26",Arizona
35,"2017-10-18 06:34:41",Prescott,Arizona,3,"2017-10-17 02:32:26",Arizona
36,"2017-10-18 06:36:26","Prescott Valley",Arizona,3,"2017-10-17 02:32:26",Arizona
37,"2017-10-18 06:41:59",Scottsdale,Arizona,3,"2017-10-17 02:32:26",Arizona
38,"2017-10-18 06:42:30","Sierra Vista",Arizona,3,"2017-10-17 02:32:26",Arizona
39,"2017-10-18 06:58:35",Surprise,Arizona,3,"2017-10-17 02:32:26",Arizona
40,"2017-10-18 07:22:24",Tempe,Arizona,3,"2017-10-17 02:32:26",Arizona
41,"2017-10-18 07:29:37",Tucson,Arizona,3,"2017-10-17 02:32:26",Arizona
42,"2017-10-18 07:31:00",Yuma,Arizona,3,"2017-10-17 02:32:26",Arizona
43,"2017-10-18 07:33:32",Bentonville,Arkansas,4,"2017-10-17 02:32:26",Arkansas
44,"2017-10-18 07:34:53",Conway,Arkansas,4,"2017-10-17 02:32:26",Arkansas
45,"2017-10-18 07:36:40",Fayetteville,Arkansas,4,"2017-10-17 02:32:26",Arkansas
46,"2017-10-18 07:36:43","Fort Smith",Arkansas,4,"2017-10-17 02:32:26",Arkansas
47,"2017-10-18 07:37:51",Jonesboro,Arkansas,4,"2017-10-17 02:32:26",Arkansas
48,"2017-10-18 07:42:09","Little Rock",Arkansas,4,"2017-10-17 02:32:26",Arkansas
49,"2017-10-18 07:46:01","North Little Rock",Arkansas,4,"2017-10-17 02:32:26",Arkansas
50,"2017-10-18 07:46:30","Pine Bluff",Arkansas,4,"2017-10-17 02:32:26",Arkansas
51,"2017-10-18 07:49:19",Rogers,Arkansas,4,"2017-10-17 02:32:26",Arkansas
52,"2017-10-18 07:51:31",Springdale,Arkansas,4,"2017-10-17 02:32:26",Arkansas
53,"2017-10-18 08:15:42",Anaheim,California,5,"2017-10-17 02:32:26",California
54,"2017-10-18 08:20:14",Bakersfield,California,5,"2017-10-17 02:32:26",California
55,"2017-10-18 08:33:44","Chula Vista",California,5,"2017-10-17 02:32:26",California
56,"2017-10-18 08:53:51",Fontana,California,5,"2017-10-17 02:32:26",California
57,"2017-10-18 09:14:47",Fremont,California,5,"2017-10-17 02:32:26",California
58,"2017-10-18 09:19:12",Fresno,California,5,"2017-10-17 02:32:26",California
59,"2017-10-18 09:40:21",Glendale,California,5,"2017-10-17 02:32:26",California
60,"2017-10-18 10:03:47","Huntington Beach",California,5,"2017-10-17 02:32:26",California
61,"2017-10-18 10:27:23",Irvine,California,5,"2017-10-17 02:32:26",California
62,"2017-10-18 10:41:45","Long Beach",California,5,"2017-10-17 02:32:26",California
63,"2017-10-18 11:10:46","Los Angeles",California,5,"2017-10-17 02:32:26",California
64,"2017-10-18 11:16:49",Modesto,California,5,"2017-10-17 02:32:26",California
65,"2017-10-18 11:29:11","Moreno Valley",California,5,"2017-10-17 02:32:26",California
66,"2017-10-18 11:38:19",Oakland,California,5,"2017-10-17 02:32:26",California
67,"2017-10-18 11:46:05",Oxnard,California,5,"2017-10-17 02:32:26",California
68,"2017-10-18 11:51:16",Riverside,California,5,"2017-10-17 02:32:26",California
69,"2017-10-18 11:58:13",Sacramento,California,5,"2017-10-17 02:32:26",California
70,"2017-10-18 12:08:58","San Bernardino",California,5,"2017-10-17 02:32:26",California
71,"2017-10-18 12:20:55","San Diego",California,5,"2017-10-17 02:32:26",California
72,"2017-10-18 12:28:02","San Francisco",California,5,"2017-10-17 02:32:26",California
73,"2017-10-18 12:44:12","San Jose",California,5,"2017-10-17 02:32:26",California
74,"2017-10-18 13:06:13","Santa Ana",California,5,"2017-10-17 02:32:26",California
75,"2017-10-18 13:26:43","Santa Clarita",California,5,"2017-10-17 02:32:26",California
76,"2017-10-18 13:29:29",Stockton,California,5,"2017-10-17 02:32:26",California
77,"2017-10-18 13:50:47",Arvada,Colorado,6,"2017-10-17 02:32:26",Colorado
78,"2017-10-18 14:01:16",Aurora,Colorado,6,"2017-10-17 02:32:26",Colorado
79,"2017-10-18 14:06:46",Boulder,Colorado,6,"2017-10-17 02:32:26",Colorado
80,"2017-10-18 14:16:19",Broomfield,Colorado,6,"2017-10-17 02:32:26",Colorado
81,"2017-10-18 14:23:50","Castle Rock",Colorado,6,"2017-10-17 02:32:26",Colorado
82,"2017-10-18 14:46:03",Centennial,Colorado,6,"2017-10-17 02:32:26",Colorado
83,"2017-10-18 14:50:41","Colorado Springs",Colorado,6,"2017-10-17 02:32:26",Colorado
84,"2017-10-18 15:11:26","Commerce City",Colorado,6,"2017-10-17 02:32:26",Colorado
85,"2017-10-18 15:23:07",Denver,Colorado,6,"2017-10-17 02:32:26",Colorado
86,"2017-10-18 15:24:08","Fort Collins",Colorado,6,"2017-10-17 02:32:26",Colorado
87,"2017-10-18 15:26:07","Grand Junction",Colorado,6,"2017-10-17 02:32:26",Colorado
88,"2017-10-18 15:27:44",Greeley,Colorado,6,"2017-10-17 02:32:26",Colorado
89,"2017-10-18 15:49:48",Lakewood,Colorado,6,"2017-10-17 02:32:26",Colorado
90,"2017-10-18 16:12:06",Littleton,Colorado,6,"2017-10-17 02:32:26",Colorado
91,"2017-10-18 16:14:57",Longmont,Colorado,6,"2017-10-17 02:32:26",Colorado
92,"2017-10-18 16:19:33",Loveland,Colorado,6,"2017-10-17 02:32:26",Colorado
93,"2017-10-18 16:29:32",Northglenn,Colorado,6,"2017-10-17 02:32:26",Colorado
94,"2017-10-18 16:31:57",Parker,Colorado,6,"2017-10-17 02:32:26",Colorado
95,"2017-10-18 16:33:14",Pueblo,Colorado,6,"2017-10-17 02:32:26",Colorado
96,"2017-10-18 16:56:40",Thornton,Colorado,6,"2017-10-17 02:32:26",Colorado
97,"2017-10-18 17:19:23",Westminster,Colorado,6,"2017-10-17 02:32:26",Colorado
98,"2017-10-18 17:27:52",Bridgeport,Connecticut,7,"2017-10-17 02:32:26",Connecticut
99,"2017-10-18 17:36:17",Bristol,Connecticut,7,"2017-10-17 02:32:26",Connecticut
100,"2017-10-18 17:41:59",Danbury,Connecticut,7,"2017-10-17 02:32:26",Connecticut