city.id,city.ts,city.city,state_x_letter.id,state.id,state.ts,state.state,letter.id,letter.ts,letter.letter
1,"2018-11-08 04:12:50",Abbeville,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
2,"2018-11-08 04:12:50",Abernant,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
3,"2018-11-08 04:12:50",Adamsville,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
4,"2018-11-08 04:12:50",Addison,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
5,"2018-11-08 04:12:50",Adger,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
6,"2018-11-08 04:12:50",Akron,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
7,"2018-11-08 04:12:50",Alabaster,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
8,"2018-11-08 04:12:50",Alberta,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
9,"2018-11-08 04:12:50",Albertville,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
10,"2018-11-08 04:12:50","Alexander City",1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
11,"2018-11-08 04:12:50",Alexandria,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
12,"2018-11-08 04:12:50",Aliceville,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
13,"2018-11-08 04:12:50",Allgood,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
14,"2018-11-08 04:12:50",Alpine,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
15,"2018-11-08 04:12:50",Alton,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
16,"2018-11-08 04:12:50",Altoona,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
17,"2018-11-08 04:12:50",Andalusia,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
18,"2018-11-08 04:12:50",Anderson,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
19,"2018-11-08 04:12:50",Annemanie,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
20,"2018-11-08 04:12:50",Anniston,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
21,"2018-11-08 04:12:50",Arab,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
22,"2018-11-08 04:12:50",Ardmore,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
23,"2018-11-08 04:12:50",Ariton,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
24,"2018-11-08 04:12:50",Arlington,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
25,"2018-11-08 04:12:50",Ashford,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
26,"2018-11-08 04:12:50",Ashland,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
27,"2018-11-08 04:12:50",Ashville,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
28,"2018-11-08 04:12:50",Athens,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
29,"2018-11-08 04:12:50",Atmore,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
30,"2018-11-08 04:12:50",Attalla,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
31,"2018-11-08 04:12:50",Auburn,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
32,"2018-11-08 04:12:50","Auburn University",1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
33,"2018-11-08 04:12:50",Autaugaville,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
34,"2018-11-08 04:12:50",Axis,1,1,"2018-04-10 05:11:19",Alabama,1,"2018-04-10 05:59:39",A
35,"2018-11-08 04:12:50",Baileyton,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
36,"2018-11-08 04:12:50",Banks,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
37,"2018-11-08 04:12:50",Bankston,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
38,"2018-11-08 04:12:50","Bay Minette",2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
39,"2018-11-08 04:12:50","Bayou La Batre",2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
40,"2018-11-08 04:12:50","Bear Creek",2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
41,"2018-11-08 04:12:50",Beatrice,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
42,"2018-11-08 04:12:50",Beaverton,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
43,"2018-11-08 04:12:50",Belk,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
44,"2018-11-08 04:12:50",Bellamy,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
45,"2018-11-08 04:12:50","Belle Mina",2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
46,"2018-11-08 04:12:50",Bellwood,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
47,"2018-11-08 04:12:50",Berry,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
48,"2018-11-08 04:12:50",Bessemer,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
49,"2018-11-08 04:12:50",Billingsley,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
50,"2018-11-08 04:12:50",Birmingham,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
51,"2018-11-08 04:12:50",Black,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
52,"2018-11-08 04:12:50",Blountsville,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
53,"2018-11-08 04:12:50",Boaz,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
54,"2018-11-08 04:12:50",Boligee,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
55,"2018-11-08 04:12:50","Bon Air",2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
56,"2018-11-08 04:12:50","Bon Secour",2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
57,"2018-11-08 04:12:50",Booth,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
58,"2018-11-08 04:12:50",Boykin,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
59,"2018-11-08 04:12:50",Brantley,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
60,"2018-11-08 04:12:50",Bremen,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
61,"2018-11-08 04:12:50",Brent,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
62,"2018-11-08 04:12:50",Brewton,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
63,"2018-11-08 04:12:50",Bridgeport,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
64,"2018-11-08 04:12:50",Brierfield,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
65,"2018-11-08 04:12:50",Brilliant,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
66,"2018-11-08 04:12:50",Brooklyn,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
67,"2018-11-08 04:12:50",Brookside,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
68,"2018-11-08 04:12:50",Brookwood,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
69,"2018-11-08 04:12:50",Brownsboro,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
70,"2018-11-08 04:12:50",Brundidge,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
71,"2018-11-08 04:12:50",Bryant,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
72,"2018-11-08 04:12:50",Bucks,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
73,"2018-11-08 04:12:50",Buhl,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
74,"2018-11-08 04:12:50",Burnwell,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
75,"2018-11-08 04:12:50",Butler,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
76,"2018-11-08 04:12:50",Bynum,2,1,"2018-04-10 05:11:19",Alabama,2,"2018-04-10 05:59:39",B
77,"2018-11-08 04:12:50",Calera,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
78,"2018-11-08 04:12:50",Calvert,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
79,"2018-11-08 04:12:50",Camden,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
80,"2018-11-08 04:12:50",Campbell,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
81,"2018-11-08 04:12:50","Carbon Hill",3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
82,"2018-11-08 04:12:50",Carlton,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
83,"2018-11-08 04:12:50",Carrollton,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
84,"2018-11-08 04:12:50",Castleberry,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
85,"2018-11-08 04:12:50",Catherine,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
86,"2018-11-08 04:12:50",Cecil,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
87,"2018-11-08 04:12:50","Cedar Bluff",3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
88,"2018-11-08 04:12:50",Centre,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
89,"2018-11-08 04:12:50",Centreville,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
90,"2018-11-08 04:12:50",Chancellor,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
91,"2018-11-08 04:12:50",Chapman,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
92,"2018-11-08 04:12:50",Chatom,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
93,"2018-11-08 04:12:50",Chelsea,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
94,"2018-11-08 04:12:50",Cherokee,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
95,"2018-11-08 04:12:50",Childersburg,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
96,"2018-11-08 04:12:50",Choccolocco,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
97,"2018-11-08 04:12:50",Chunchula,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
98,"2018-11-08 04:12:50",Citronelle,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
99,"2018-11-08 04:12:50",Clanton,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C
100,"2018-11-08 04:12:50",Clay,3,1,"2018-04-10 05:11:19",Alabama,3,"2018-04-10 05:59:39",C