don't change any of these numbers, you may want to add countries later.

cities example, last column is the state_id:

title,ascii_title,lat,lng,country_id,state_id
Playa Vista,playa vista,33.9727778000,-118.4266667000,232,22
Playa del Rey,playa del rey,33.9488889000,-118.4447222000,232,22
Pleasant Grove,pleasant grove,38.8238889000,-121.4827778000,232,22
Pleasant Hill,pleasant hill,37.9480556000,-122.0597222000,232,22
Pleasant Valley,pleasant valley,38.6830556000,-120.6619444000,232,22

state_id,country,code,title
1,CA,AB,Alberta
2,CA,BC,British Columbia
3,CA,MB,Manitoba
4,CA,NB,New Brunswick
5,CA,NL,Newfoundland
6,CA,NS,Nova Scotia
7,CA,NU,Nunavut
8,CA,ON,Ontario
9,CA,PE,Prince Edward Island
10,CA,QC,Quebec
11,CA,SK,Saskatchewan
12,CA,NT,Northwest Territories
13,CA,YT,Yukon Territory
14,US,AA,Armed Forces Americas
15,US,AE,Armed Forces Europe, Middle East, & Canada
16,US,AK,Alaska
17,US,AL,Alabama
18,US,AP,Armed Forces Pacific
19,US,AR,Arkansas
20,US,AS,American Samoa
21,US,AZ,Arizona
22,US,CA,California
23,US,CO,Colorado
24,US,CT,Connecticut
25,US,DC,District of Columbia
26,US,DE,Delaware
27,US,FL,Florida
28,US,FM,Federated States of Micronesia
29,US,GA,Georgia
30,US,GU,Guam
31,US,HI,Hawaii
32,US,IA,Iowa
33,US,ID,Idaho
34,US,IL,Illinois
35,US,IN,Indiana
36,US,KS,Kansas
37,US,KY,Kentucky
38,US,LA,Louisiana
39,US,MA,Massachusetts
40,US,MD,Maryland
41,US,ME,Maine
42,US,MH,Marshall Islands
43,US,MI,Michigan
44,US,MN,Minnesota
45,US,MO,Missouri
46,US,MP,Northern Mariana Islands
47,US,MS,Mississippi
48,US,MT,Montana
49,US,NC,North Carolina
50,US,ND,North Dakota
51,US,NE,Nebraska
52,US,NH,New Hampshire
53,US,NJ,New Jersey
54,US,NM,New Mexico
55,US,NV,Nevada
56,US,NY,New York
57,US,OH,Ohio
58,US,OK,Oklahoma
59,US,OR,Oregon
60,US,PA,Pennsylvania
61,US,PR,Puerto Rico
62,US,PW,Palau
63,US,RI,Rhode Island
64,US,SC,South Carolina
65,US,SD,South Dakota
66,US,TN,Tennessee
67,US,TX,Texas
68,US,UT,Utah
69,US,VA,Virginia
70,US,VI,Virgin Islands
71,US,VT,Vermont
72,US,WA,Washington
73,US,WV,West Virginia
74,US,WI,Wisconsin
75,US,WY,Wyoming