INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Winter Haven','Winter Haven',28.02191876,-81.73300623,68435,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Melbourne','Melbourne',28.08331036,-80.60832035,170870,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Homestead','Homestead',25.46830202,-80.47778569,60673,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sanford','Sanford',28.78995974,-81.27998478,189374.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Miami Beach','Miami Beach',25.80991953,-80.13178111,248538,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Coral Springs','Coral Springs',26.27083701,-80.27082158,185548,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Port Charlotte','Port Charlotte',27.00004315,-82.10569666,56806,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Spring Hill','Spring Hill',28.47894513,-82.54771102,91887.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Palm Coast','Palm Coast',29.53800193,-81.22329574,45030,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Palatka','Palatka',29.64768516,-81.65130579,16094.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Leesburg','Leesburg',28.81050112,-81.88333297,33929,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lake City','Lake City',30.18971926,-82.63974675,20159.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Crestview','Crestview',30.75420677,-86.57260746,19552.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Panama City','Panama City',30.15861005,-85.65527328,68852.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dalton','Dalton',34.76972394,-84.97030217,45077.5,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Marietta','Marietta',33.95561342,-84.54324813,61360,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Waycross','Waycross',31.21381695,-82.35490625,17445.5,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('La Grange','La Grange',33.03647056,-85.03187464,28887,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Southaven','Southaven',34.96891075,-90.00345748,79923,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Meridian','Meridian',32.36418601,-88.70361434,40863.5,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Laurel','Laurel',31.69737917,-89.1392725,23366,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Spartanburg','Spartanburg',34.94942873,-81.93227055,81059,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Orangeburg','Orangeburg',33.49680422,-80.86223251,24192.5,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Galesburg','Galesburg',40.94777061,-90.37108362,32078.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Joliet','Joliet',41.52998313,-88.10667403,362946.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cape Girardeau','Cape Girardeau',37.30582237,-89.51808659,38165.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rockford','Rockford',42.26970542,-89.06969019,204371.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Evanston','Evanston',42.04834943,-87.69995467,212243,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rock Island','Rock Island',41.49339622,-90.53461369,102055.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Elgin','Elgin',42.03946108,-88.28991866,244050,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Richmond','Richmond',39.82889833,-84.89028121,41015.5,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Terre Haute','Terre Haute',39.46664654,-87.41387394,65149.5,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lafayette','Lafayette',40.41720868,-86.87824772,98104,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Marion','Marion',40.55833701,-85.65917485,34249,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('South Bend','South Bend',41.68330711,-86.25001734,171791,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('New Albany','New Albany',38.3108773,-85.82128382,78381.5,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Elkhart','Elkhart',41.68294537,-85.96879419,100295,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hopkinsville','Hopkinsville',36.86548749,-87.4886239,31630,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('London','London',37.12888226,-84.08335372,7844,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Madisonville','Madisonville',37.33274579,-87.5022148,20858.5,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rocky Mount','Rocky Mount',35.93799888,-77.79076624,57179,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Salisbury','Salisbury',35.67078005,-80.4744784,33907,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Durham','Durham',35.99995892,-78.91999964,257114.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lumberton','Lumberton',34.62720034,-79.01190617,27049.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Zanesville','Zanesville',39.94028688,-82.01332503,32514,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mansfield','Mansfield',40.75832481,-82.51554244,64039,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bowling Green','Bowling Green',41.37474713,-83.65139042,33147.5,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Springfield','Springfield',39.92000388,-83.799986,74450.5,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lancaster','Lancaster',39.71921511,-82.6053044,42356,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Johnson City','Johnson City',36.31332481,-82.35361434,68070.5,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kingsport','Kingsport',36.54832338,-82.56194788,50709.5,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Columbia','Columbia',35.61499534,-87.03526656,74866,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Barlett','Barlett',35.22290041,-89.84109013,164843.5,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Blacksburg','Blacksburg',37.22941876,-80.41419784,53845.5,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Harrisonburg','Harrisonburg',38.44942181,-78.86917586,42131.5,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Petersburg','Petersburg',37.22776512,-77.40223698,76158.5,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hampton','Hampton',37.03002525,-76.34994979,256601.5,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sheboygan','Sheboygan',43.75082949,-87.71442407,51148,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Waukesha','Waukesha',43.0116498,-88.23136926,159012,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('La Crosse','La Crosse',43.80136904,-91.23942855,69599.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Eau Claire','Eau Claire',44.81135907,-91.49835331,71296,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tomah','Tomah',43.98505292,-90.50389205,10796.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Janesville','Janesville',42.68262596,-89.02157943,65476.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Appleton','Appleton',44.26867902,-88.40050623,136888.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Parkersburg','Parkersburg',39.26665875,-81.56164718,46749.5,'United States of America','US','USA','West Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('White Sulphur Springs','White Sulphur Springs',37.79388043,-80.30348108,2154,'United States of America','US','USA','West Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Clarksburg','Clarksburg',39.28327272,-80.33691573,22502.5,'United States of America','US','USA','West Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dover','Dover',39.15808657,-75.524703,54662.5,'United States of America','US','USA','Delaware');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. Charles','St. Charles',38.60305585,-76.93893193,52792,'United States of America','US','USA','Maryland');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Annapolis','Annapolis',38.9783301,-76.49249923,58776,'United States of America','US','USA','Maryland');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hagerstown','Hagerstown',39.64164878,-77.72027958,58487.5,'United States of America','US','USA','Maryland');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Paterson','Paterson',40.91999453,-74.17000533,151205,'United States of America','US','USA','New Jersey');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Saratoga Springs','Saratoga Springs',43.08296328,-73.78501591,41891,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Poughkeepsie','Poughkeepsie',41.70023114,-73.92141585,100670.5,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Plattsburg','Plattsburg',44.69498374,-73.45798161,24233.5,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Beaver Falls','Beaver Falls',40.75194277,-80.31942326,64814.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Altoona','Altoona',40.51859784,-78.39496708,62784.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Williamsport','Williamsport',41.24108604,-77.0013829,43791.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lancaster','Lancaster',40.03777447,-76.30576644,209489,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Allentown','Allentown',40.59998822,-75.50002751,300980.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Waterville','Waterville',44.5518917,-69.64578536,20529,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Calais','Calais',45.16598859,-67.24239201,1781.5,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Houlton','Houlton',46.12551658,-67.83971989,6051.5,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Benton Harbor','Benton Harbor',42.11663983,-86.45419092,34637.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Battle Creek','Battle Creek',42.32109764,-85.17974675,62454,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bay City','Bay City',43.5944566,-83.88889531,51558.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Alpena','Alpena',45.06160219,-83.43269576,14524,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Iron Mountain','Iron Mountain',45.82246014,-88.06409265,12011,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ironwood','Ironwood',46.4558065,-90.15939112,6400,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sand Point','Sand Point',55.33970868,-160.4971908,667,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hydaburg','Hydaburg',55.21397992,-132.8006385,382,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mekoryuk','Mekoryuk',60.38864671,-166.1899372,99,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Atqasuk','Atqasuk',70.4693795,-157.395778,201,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Port Heiden','Port Heiden',56.94909365,-158.6268915,102,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Perryville','Perryville',55.91861391,-159.1511489,113,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dillingham','Dillingham',59.05656031,-158.4803121,1710,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Goodnews Bay','Goodnews Bay',59.12099265,-161.5871302,230,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nyac','Nyac',61.00414329,-159.9404806,75,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tununak','Tununak',60.58548667,-165.2557892,352,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mountain Village','Mountain Village',62.08552431,-163.729009,755,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Emmonak','Emmonak',62.77698081,-164.5229916,100,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kaltag','Kaltag',64.32719627,-158.7218986,190,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Teller','Teller',65.26359906,-166.3607864,83,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Koyukuk','Koyukuk',64.88028912,-157.7008499,101,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kobuk','Kobuk',66.9072455,-156.8809774,151,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Selawik','Selawik',66.60387901,-160.0093911,832,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Talkeetna','Talkeetna',62.3237785,-150.1094269,1078,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Whittier','Whittier',60.78415672,-148.6776797,177,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Montana','Montana',62.07968487,-150.0727625,10,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lake Minchumina','Lake Minchumina',63.88283063,-152.3121865,32,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cantwell','Cantwell',63.39159446,-148.9507896,222,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gulkana','Gulkana',62.27135276,-145.3821961,119,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Eagle','Eagle',64.78799501,-141.1999966,104,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nenana','Nenana',64.56379681,-149.0930032,75,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Big Delta','Big Delta',64.15252993,-145.8421939,591,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Allakaket','Allakaket',66.56548342,-152.6454995,97,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tanana','Tanana',65.17187339,-152.0787899,291.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Virginia','Virginia',47.52367413,-92.53640365,8709,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Winona','Winona',44.0504236,-91.63919743,29757.5,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rochester','Rochester',44.02205324,-92.46968937,102433,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lakeville','Lakeville',44.65010276,-93.24251042,156151,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ely','Ely',47.90042116,-91.82569767,3687,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Moorhead','Moorhead',46.87430808,-96.74219344,34332.5,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. Cloud','St. Cloud',45.56120994,-94.16222172,85974,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Miles City','Miles City',46.4088843,-105.8399844,8399.5,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bozeman','Bozeman',45.68009157,-111.0378325,39049.5,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Glasgow','Glasgow',48.18396975,-106.6352588,3144,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dickinson','Dickinson',46.88399742,-102.7888011,15987.5,'United States of America','US','USA','North Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jamestown','Jamestown',46.90601158,-98.70297815,14954.5,'United States of America','US','USA','North Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Williston','Williston',48.15678794,-103.6280005,12767.5,'United States of America','US','USA','North Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lihue','Lihue',21.98151227,-159.3710063,10694.5,'United States of America','US','USA','Hawaii');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wahiawa','Wahiawa',21.50309186,-158.0236209,95336,'United States of America','US','USA','Hawaii');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wailuku','Wailuku',20.89147544,-156.5047213,32769.5,'United States of America','US','USA','Hawaii');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Montpelier','Montpelier',42.32262209,-111.2969123,2775.5,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Twin Falls','Twin Falls',42.5609538,-114.4605693,42958.5,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Caldwell','Caldwell',43.66096417,-116.6705378,83403,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Salmon','Salmon',45.17567792,-113.8949966,3297,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Coeur d''Alene','Coeur d''Alene',47.67808331,-116.7794458,34514,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Richland','Richland',46.29181134,-119.2911013,39940.5,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bellingham','Bellingham',48.76013613,-122.4869269,86565.5,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Longview','Longview',46.13871991,-122.9369511,51290,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Walla Walla','Walla Walla',46.06515851,-118.3418828,37864,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Aberdeen','Aberdeen',46.97489626,-123.8143911,24400,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bremerton','Bremerton',47.57359552,-122.6420175,82039.5,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Everett','Everett',47.9604175,-122.1999677,291948,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bullhead City','Bullhead City',35.14817629,-114.5674878,37989,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Winslow','Winslow',35.28470542,-110.7006954,9931,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gila Bend','Gila Bend',32.95037762,-112.7246546,2012,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tombstone','Tombstone',31.71314048,-110.066884,1396.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Willcox','Willcox',32.25321088,-109.8313945,4451.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Scottsdale','Scottsdale',33.69234784,-111.8680402,15401,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kingman','Kingman',35.18987917,-114.0522221,33306.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Grand Canyon','Grand Canyon',36.05478762,-112.1385922,1068.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Arcata','Arcata',40.88519045,-124.0882245,19052,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Stockton','Stockton',37.95813397,-121.289739,488506.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Barstow','Barstow',34.89901837,-117.0218858,21119,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Victorville','Victoriaville',34.5365082,-117.2903191,83496,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pasadena','Pasadena',34.16038129,-118.1388719,144618,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Visalia','Visalia',36.32502952,-119.3160094,114699.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('El Centro','El Centro',32.79237693,-115.5580475,41661.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Luis Obispo','San Luis Obispo',35.28318097,-120.6585889,54759,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Merced','Merced',37.30261843,-120.481933,84355,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Yuba City','Yuba City',39.14103334,-121.6157656,84324.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Redding','Redding',40.58704327,-122.3905762,93871.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Santa Rosa','Santa Rosa',38.45040367,-122.6999889,193455,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Oceanside','Oceanside',33.2204645,-117.3349675,396474.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Modesto','Modesto',37.65541343,-120.9899899,269697,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Irvine','Irvine',33.68041058,-117.8299502,1611303.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ukiah','Ukiah',39.15423667,-123.2108621,21826.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Needles','Needles',34.84842714,-114.6133507,6246.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bishop','Bishop',37.36395835,-118.394076,4249,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Palm Springs','Palm Springs',33.77735557,-116.5330526,216461,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Santa Maria','Santa Maria',34.94012697,-120.4366386,98092.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tulare','Tulare',36.20702639,-119.3441213,53005.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mt. Shasta','Mt. Shasta',41.3103583,-122.3093925,3742.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Crescent City','Crescent City',41.7564551,-124.2004916,9439.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fort Collins','Fort Collins',40.56068829,-105.0588693,178818.5,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pueblo','Pueblo',38.2803882,-104.6300066,108244,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lamar','Lamar',38.08649823,-102.6194058,8567,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Trinidad','Trinidad',37.17133445,-104.5063965,8701.5,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gunnison','Gunnison',38.54476483,-106.92829,6273,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Durango','Durango',37.27564333,-107.8799891,19127.5,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Montrose','Montrose',38.47727541,-107.8655197,18463.5,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Craig','Craig',40.51728009,-107.5503968,9315.5,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Boulder','Boulder',40.03844627,-105.246093,106897.5,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Boulder City','Boulder City',35.97895245,-114.8315802,15072.5,'United States of America','US','USA','Nevada');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Winnemucca','Winnemucca',40.97337628,-117.7346847,7997.5,'United States of America','US','USA','Nevada');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Roswell','Roswell',33.39453656,-104.5224679,45082.5,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Clovis','Clovis',34.40506919,-103.2047706,33477.5,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Las Cruces','Las Cruces',32.31261293,-106.7778083,97675.5,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hobbs','Hobbs',32.71261436,-103.1406143,28375.5,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Socorro','Socorro',34.06211855,-106.8989895,8117,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gallup','Gallup',35.52407066,-108.7339938,21627,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Raton','Raton',36.89739768,-104.439889,6820,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tucumcari','Tucumcari',35.16980288,-103.725514,5259.5,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Roseburg','Roseburg',43.21843304,-123.3560987,25454.5,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pendleton','Pendleton',45.67259849,-118.7874886,16669,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('John Day','John Day',44.41652529,-118.9520264,1437.5,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Grants Pass','Grants Pass',42.43954002,-123.3271857,36690,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Corvallis','Corvallis',44.57235557,-123.2799793,54865.5,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Albany','Albany',44.62049217,-123.086942,48066.5,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Astoria','Astoria',46.18838096,-123.8299974,9773,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Logan','Logan',41.73593955,-111.8335979,58664,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Parowan','Parowan',37.84253379,-112.8272065,2533,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kanab','Kanab',37.04738853,-112.5254936,2861,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Monticello','Monticello',37.87178265,-109.3421995,1811.5,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Moab','Moab',38.57370363,-109.5491895,5309,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Price','Price',39.59979087,-110.8100169,9175,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cedar City','Cedar City',37.67742759,-113.061094,25371.5,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vernal','Vernal',40.45539756,-109.5280022,11175.5,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ogden','Ogden',41.23237856,-111.9680341,227774,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Green River','Green River',41.51455772,-109.4649827,10239.5,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rawlins','Rawlins',41.7906649,-107.234292,8458,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Douglas','Douglas',42.75647158,-105.3845341,5838,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Riverton','Riverton',43.02816042,-108.3950481,10350,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Thermopolis','Thermopolis',43.64597801,-108.2146715,3195,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gillette','Gillette',44.28317425,-105.5052503,26107,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jonesboro','Jonesboro',35.84257835,-90.70416406,58322,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Texarkana','Texarkana',33.44210472,-94.03747481,52169,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pine Bluff','Pine Bluff',34.22869753,-92.00305119,51472,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hot Springs','Hot Springs',34.50395205,-93.05500248,40826,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fort Smith','Fort Smith',35.38622377,-94.39835718,87986.5,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fayetteville','Fayetteville',36.06297833,-94.15720911,108267.5,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Conway','Conway',35.09128054,-92.4513184,56759.5,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('El Dorado','El Dorado',33.21392743,-92.66251998,21384.5,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Davenport','Davenport',41.55398684,-90.58753036,178282.5,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Burlington','Burlington',40.80793418,-91.11276961,27690.5,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dubuque','Dubuque',42.50093162,-90.66445073,59834,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Waterloo','Waterloo',42.49315432,-92.34279789,82091.5,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sioux City','Sioux City',42.50038902,-96.39999211,87090,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Council Bluffs','Council Bluffs',41.26227338,-95.86080021,80284.5,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ames','Ames',42.05385297,-93.61972254,56855,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mason City','Mason City',43.15401837,-93.20083338,27327,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Emporia','Emporia',38.40423077,-96.18137496,27796.5,'United States of America','US','USA','Kansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Salina','Salina',38.82467023,-97.6071794,46877,'United States of America','US','USA','Kansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dodge City','Dodge City',37.76005821,-100.018195,25237.5,'United States of America','US','USA','Kansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Coffeyville','Coffeyville',37.03806093,-95.6263184,10955,'United States of America','US','USA','Kansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. Charles','St. Charles',38.78428509,-90.50616581,213139.5,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Poplar Bluff','Poplar Bluff',36.76019676,-90.40268376,18575,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Joplin','Joplin',37.08459556,-94.51307886,60290.5,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Columbia','Columbia',38.95207847,-92.33390955,244754,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. Joseph','St. Joseph',39.76903119,-94.84639185,74878.5,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('McCook','McCook',40.20559369,-100.6261683,8003,'United States of America','US','USA','Nebraska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Norfolk','Norfolk',42.02871238,-97.43359827,24562,'United States of America','US','USA','Nebraska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('North Platte','North Platte',41.13628623,-100.7705005,24709.5,'United States of America','US','USA','Nebraska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sidney','Sidney',41.13980023,-102.9782727,6221.5,'United States of America','US','USA','Nebraska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Scottsbluff','Scottsbluff',41.86750775,-103.6606859,20172,'United States of America','US','USA','Nebraska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chadron','Chadron',42.82791424,-103.0030774,5686.5,'United States of America','US','USA','Nebraska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lawton','Lawton',34.59903668,-98.40997278,85795.5,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Norman','Norman',35.22791302,-97.34414636,113525,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Muskogee','Muskogee',35.74821718,-95.36943486,38995.5,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ponca City','Ponca City',36.7073576,-97.08527328,24843,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Shawnee','Shawnee',35.34278973,-96.93378382,29160,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Woodward','Woodward',36.43342084,-99.39769027,12339.5,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Guymon','Guymon',36.68580853,-101.4795012,10843.5,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Yankton','Yankton',42.88201947,-97.39248967,14495,'United States of America','US','USA','South Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Brookings','Brookings',44.30676455,-96.78803044,20313.5,'United States of America','US','USA','South Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mitchell','Mitchell',43.71429425,-98.02619776,14973,'United States of America','US','USA','South Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Aberdeen','Aberdeen',45.46511761,-98.48640222,24854,'United States of America','US','USA','South Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mobridge','Mobridge',45.54012596,-100.4347071,3083.5,'United States of America','US','USA','South Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Houma','Houma',29.59593121,-90.71948613,48196,'United States of America','US','USA','Louisiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Monroe','Monroe',32.50960349,-92.11919397,76674.5,'United States of America','US','USA','Louisiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Conroe','Conroe',30.31206321,-95.45586369,41643,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nacogdoches','Nacogdoches',31.60374147,-94.65526656,30691,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Eagle Pass','Eagle Pass',28.71102399,-100.4892774,39683,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Edinburg','Edinburg',26.30318646,-98.1599622,114573.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kingsville','Kingsville',27.51595481,-97.8558464,24560.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Port Arthur','Port Arthur',29.89898765,-93.92859257,54972,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Huntsville','Huntsville',30.72376935,-95.55058659,34444.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Killeen','Killeen',31.11728538,-97.72748214,120464,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lufkin','Lufkin',31.33843467,-94.72887964,38465.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Del Rio','Del Rio',29.36294802,-100.8963843,35803.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Angelo','San Angelo',31.4640084,-100.4366966,87297.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sherman','Sherman',33.63599469,-96.60858403,38696,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Beaumont','Beaumont',30.08626304,-94.10168278,107455.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bay City','Bay City',28.98111086,-95.96435978,17487,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Port Lavaca','Port Lavaca',28.61601687,-96.62969385,10715.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Falfurrias','Falfurrias',27.22690269,-98.14489852,5152.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Beeville','Beeville',28.40597801,-97.75083989,11748,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fort Stockton','Fort Stockton',30.89169191,-102.8849968,7434,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pecos','Pecos',31.41579429,-103.4998947,7991,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dumas','Dumas',35.86239626,-101.9668875,13551.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Denton','Denton',33.21576194,-97.12883651,138952.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Midland','Midland',32.030718,-102.0974996,98141.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Temple','Temple',31.10209251,-97.36300826,58432,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('New Haven','New Haven',41.33038291,-72.90000533,707883,'United States of America','US','USA','Connecticut');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lowell','Lowell',42.63368837,-71.31669112,415074,'United States of America','US','USA','Massachusetts');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Worcester','Worcester',42.27042889,-71.80002079,232290.5,'United States of America','US','USA','Massachusetts');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Manchester','Manchester',42.99599184,-71.45528731,153221.5,'United States of America','US','USA','New Hampshire');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Newport','Newport',41.49039899,-71.31335799,35893,'United States of America','US','USA','Rhode Island');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dothan','Dothan',31.22345461,-85.39058659,61715,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tuscaloosa','Tuscaloosa',33.22511538,-87.54417607,100594.5,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gadsden','Gadsden',34.01455039,-86.00664718,39265,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Enterprise','Enterprise',31.32781516,-85.84399561,23388.5,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Selma','Selma',32.40756838,-87.0211589,19553,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Coral Gables','Coral Gables',25.71541872,-80.29107874,98700.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cape Coral','Cape Coral',26.60290977,-81.97968368,117387.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Naples','Naples',26.14205935,-81.79499211,141902,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fort Pierce','Fort Pierce',27.44678591,-80.3258053,132984,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kissimmee','Kissimmee',28.29205731,-81.4077806,144589.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Titusville','Titusville',28.61234784,-80.80779138,47505.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. Augustine','St. Augustine',29.89487937,-81.31471135,44214,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ocala','Ocala',29.1873515,-82.14026819,95470,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fort Lauderdale','Fort Lauderdale',26.13606488,-80.14178552,1103781.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Apalachicola','Apalachicola',29.72561322,-84.99252303,2134,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vero Beach','Vero Beach',27.64225201,-80.39112431,51650.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Valdosta','Valdosta',30.8328583,-83.27859664,53420,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Albany','Albany',31.57873008,-84.15582992,82280,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Athens','Athens',33.96129783,-83.3780221,78017.5,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Macon','Macon',32.85038373,-83.63004806,104932.5,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Columbus','Columbus',32.47043276,-84.98001734,202225,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Douglas','Douglas',31.50777834,-82.85068994,12159,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dublin','Dublin',32.53745709,-82.91828272,19258.5,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gulfport','Gulfport',30.3675637,-89.09276371,76646,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hattiesburg','Hattiesburg',31.32727256,-89.2902452,53498.5,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tupelo','Tupelo',34.25792055,-88.70333012,33928,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Greenville','Greenville',33.41037539,-91.06168746,36539.5,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Natchez','Natchez',31.55480389,-91.38750737,20490.5,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Florence','Florence',34.19567629,-79.76279057,43977.5,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Greenville','Greenville',34.85292299,-82.3941545,203256.5,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sumter','Sumter',33.92065432,-80.34172164,27012,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Anderson','Anderson',34.50374534,-82.6502629,43475.5,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Aiken','Aiken',33.5494625,-81.72060388,36716.5,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Beaufort','Beaufort',32.43216636,-80.68950403,21941,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rock Hill','Rock Hill',34.94038535,-81.03000004,77165,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Decatur','Decatur',39.8407064,-88.95473596,74967.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Alton','Alton',38.89099693,-90.18422164,57386,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Quincy','Quincy',39.9359719,-91.40972823,43419.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Urbana','Urbana',40.10999229,-88.20418746,91792.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bloomington','Bloomington',40.48459475,-88.99359664,99842.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kankakee','Kankakee',41.12036989,-87.86110763,48115.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Waukegan','Waukegan',42.36404075,-87.8447262,144539,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Aurora','Aurora',41.76539512,-88.29999557,273949.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Carbondale','Carbondale',37.72683026,-89.22024947,28473,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Belleville','Belleville',38.52515362,-90.0002277,92409.5,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bloomington','Bloomington',39.16565716,-86.52640873,85781.5,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Muncie','Muncie',40.19375979,-85.38637496,75388,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kokomo','Kokomo',40.48676516,-86.13364201,53674,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gary','Gary',41.58039349,-87.33000309,335737,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fort Wayne','Fort Wayne',41.08039817,-85.12998234,264793,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Covington','Covington',39.0840084,-84.50859908,313064.5,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bowling Green','Bowling Green',36.99069948,-86.44364893,61349,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Paducah','Paducah',37.08371706,-88.60000309,33812,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Owensboro','Owensboro',37.77457928,-87.11332381,61151.5,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jacksonville','Jacksonville',34.75432436,-77.43055567,72651.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Goldsboro','Goldsboro',35.38513857,-77.99305363,42922.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Greenville','Greenville',35.61287661,-77.3666836,81661,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fayetteville','Fayetteville',35.06293601,-78.88359359,184040.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hickory','Hickory',35.7334894,-81.34140222,64898,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Asheville','Asheville',35.60119773,-82.55414474,105775,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Winston-Salem','Winston-Salem',36.10543052,-80.25999536,237491.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kitty Hawk','Kitty Hawk',36.07731854,-75.70471786,2109.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Akron','Akron',41.07039878,-81.51999597,451155,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lima','Lima',40.74287355,-84.10526453,54135,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Oak Ridge','Oak Ridge',36.01065594,-84.26972477,30471.5,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Murfreesboro','Murfreesboro',35.84596315,-86.39026717,100237,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Clarksville','Clarksville',36.5300816,-87.35943282,122115,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jackson','Jackson',35.61486615,-88.81389185,62638,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Alexandria','Alexandria',38.82043276,-77.09998153,127273,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fredericksburg','Fredericksburg',38.30351341,-77.46078638,76848,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Roanoke','Roanoke',37.27119916,-79.94161686,144669.5,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Danville','Danville',36.58625388,-79.39531946,43176,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Winchester','Winchester',39.1787313,-78.16663477,39418,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bristol','Bristol',36.61152366,-82.17600244,31276.5,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Superior','Superior',46.72124249,-92.10389775,27474,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('West Bend','West Bend',43.42570721,-88.18333602,31980.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fond du Lac','Fond du Lac',43.77343793,-88.44691166,48079.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Oshkosh','Oshkosh',44.02510215,-88.54251306,67857.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rhinelander','Rhinelander',45.63991315,-89.41207239,9633,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Racine','Racine',42.72771364,-87.81183415,105458.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Marinette','Marinette',45.10038535,-87.63047571,19170,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wheeling','Wheeling',40.06431032,-80.72107833,40940,'United States of America','US','USA','West Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Morgantown','Morgantown',39.62981488,-79.95606043,43882.5,'United States of America','US','USA','West Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Huntington','Huntington',38.41957867,-82.44528833,66957,'United States of America','US','USA','West Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Beckley','Beckley',37.78018618,-81.18301396,27358,'United States of America','US','USA','West Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wilmington','Wilmington',39.74626772,-75.54689803,116205.5,'United States of America','US','USA','Delaware');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cumberland','Cumberland',39.65317263,-78.76277409,20831.5,'United States of America','US','USA','Maryland');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Atlantic City','Atlantic City',39.36463727,-74.4233232,58563.5,'United States of America','US','USA','New Jersey');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Newark','Newark',40.70042137,-74.17000533,280123,'United States of America','US','USA','New Jersey');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Schenectady','Schenectady',42.81458173,-73.93996769,104767.5,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Binghamton','Binghamton',42.09901817,-75.91832239,92687.5,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Utica','Utica',43.10117922,-75.23306706,81870,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Watertown','Watertown',43.97515688,-75.91106185,30938,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Niagara Falls','Niagara Falls',43.09482302,-79.0369434,117567,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jamestown','Jamestown',42.09736452,-79.23553593,37916.5,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Elmira','Elmira',42.09012982,-76.80803552,46201,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('York','York',39.96292116,-76.72804041,128798.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Johnstown','Johnstown',40.32708498,-78.92222172,45821.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Scranton','Scranton',41.40929283,-75.66267908,114701,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('State College','State College',40.79372316,-77.8602452,64880.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Erie','Erie',42.12992067,-80.08499313,138991.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wilkes Barre','Wilkes Barre',41.24904421,-75.87793726,99824.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bar Harbor','Bar Harbor',44.38789654,-68.20437464,4483.5,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lewiston','Lewiston',44.10070477,-70.21525965,46689,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Presque Isle','Presque Isle',46.79340863,-68.00216476,9466,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ann Arbor','Ann Arbor',42.30037539,-83.71999089,189893,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kalamazoo','Kalamazoo',42.29215883,-85.58718958,128759.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Muskegon','Muskegon',43.23458193,-86.24836369,70644.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Flint','Flint',43.0128642,-83.68753809,206235,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Grand Rapids','Grand Rapids',42.96371991,-85.66994938,361934.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pontiac','Pontiac',42.65185264,-83.29022384,67994,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cadillac','Cadillac',44.25121238,-85.41360844,12177.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Traverse City','Traverse City',44.76844179,-85.62217452,28807,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Petoskey','Petoskey',45.37375368,-84.95518681,9424,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Escanaba','Escanaba',45.7456948,-87.06436039,14970,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Marquette','Marquette',46.54673118,-87.40658757,23711,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hancock','Hancock',47.12729006,-88.5808053,10322.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wrangell','Wrangell',56.47126752,-132.3715949,1658.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Shishmaref','Shishmaref',66.25697512,-166.0718893,254,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hoonah','Hoonah',58.11540489,-135.438617,361,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Atka','Atka',52.19648968,-174.2004887,61,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nikolski','Nikolski',52.93843406,-168.8676876,18,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Karluk','Karluk',57.57228558,-154.4550273,96,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('False Pass','False Pass',54.85121136,-163.415023,35,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kivalina','Kivalina',67.73149224,-164.4859034,374,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Newhalen','Newhalen',59.72034568,-154.8971967,160,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pilot Point','Pilot Point',57.56455996,-157.5691266,68,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chignik','Chignik',56.295671,-158.4022282,118,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('King Salmon','King Salmon',58.68870323,-156.6613784,292,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Quinhagak','Quinhagak',59.74923281,-161.9157864,250,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Aniak','Aniak',61.5787077,-159.5221857,501,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kotlit','Kotlit',63.03458783,-163.5532833,1002,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Unalakleet','Unalakleet',63.87342552,-160.7880516,741,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Koyuk','Koyuk',64.94026874,-161.1574717,254,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('McGrath','McGrath',62.9568148,-155.5957845,138,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hughes','Hughes',66.04918418,-154.2549878,78,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ambler','Ambler',67.08648521,-157.8514091,258,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wales','Wales',65.60959861,-168.0875027,99,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kotzebue','Kotzebue',66.89869305,-162.5965975,2873.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wasilla','Wasilla',61.58173077,-149.439442,8521,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Circle','Circle',65.82589032,-144.0605197,100,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Denali Park','Denali Park',63.73309816,-148.9140994,1063,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Yakutat','Yakutat',59.54730715,-139.7272183,109,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Homer','Homer',59.64293439,-151.5482797,5021.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tanacross','Tanacross',63.38570335,-143.346403,136,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wiseman','Wiseman',67.4104706,-150.1074891,14,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kailua-Kona','Kailua-Kona',19.6405556,-155.9955556,9870,'United States of America','US','USA','Hawaii');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Butte','Butte',46.0038961,-112.5338394,31478,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Grand Forks','Grand Forks',47.92527753,-97.0324858,53496,'United States of America','US','USA','North Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pocatello','Pocatello',42.87134829,-112.4447234,57327,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tacoma','Tacoma',47.21131594,-122.5150131,460273,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Yuma','Yuma',32.68527753,-114.6236084,88402.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Prescott','Prescott',34.59001914,-112.4477723,47587,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Long Beach','Long Beach',33.78696739,-118.1580439,1249195.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Grand Junction','Grand Junction',39.09385276,-108.5499998,75076,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ely','Ely',39.24702171,-114.887675,3911,'United States of America','US','USA','Nevada');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Carson City','Carson City',39.16384849,-119.7663953,53767,'United States of America','US','USA','Nevada');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Carlsbad','Carlsbad',32.420565,-104.2282998,25240,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Alamogordo','Alamogordo',32.89947634,-105.9597187,33710.5,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Medford','Medford',42.32662701,-122.8744227,89081.5,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Klamath Falls','Klamath Falls',42.22500531,-121.7805359,31090.5,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. George','St. George',37.10415509,-113.583336,79988,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Provo','Provo',40.24889854,-111.63777,231238,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Laramie','Laramie',41.31136599,-105.5905681,25587.5,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Little Rock','Little Rock',34.73608258,-92.33109318,227555,'United States of America','US','USA','Arkansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wichita','Wichita',37.71998313,-97.32998702,378543.5,'United States of America','US','USA','Kansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jefferson City','Jefferson City',38.57662335,-92.17332503,45511,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rapid City','Rapid City',44.08055096,-103.2305571,67760,'United States of America','US','USA','South Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lafayette','Lafayette',30.19997703,-92.01994938,135205.5,'United States of America','US','USA','Louisiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Galveston','Galveston',29.301143,-94.7974801,62516,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Freeport','Freeport',28.95948427,-95.35687748,43762,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Victoria','Victoria',28.80499758,-97.00334029,63126.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Odessa','Odessa',31.84556134,-102.3672248,98655,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wichita Falls','Wichita Falls',33.91362632,-98.49306848,97429,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Waco','Waco',31.54917116,-97.14638066,143157,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lubbock','Lubbock',33.58000327,-101.8799677,212343.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hartford','Hartford',41.77002016,-72.67996708,518509.5,'United States of America','US','USA','Connecticut');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Providence','Providence',41.82110231,-71.4149797,663726.5,'United States of America','US','USA','Rhode Island');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Birmingham','Birmingham',33.53000633,-86.82499516,670142,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mobile','Mobile',30.68002525,-88.04998499,221870,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pensacola','Pensacola',30.42112632,-87.21693506,145319.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. Petersburg','St. Petersburg',27.77053876,-82.67938257,523314.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Biloxi','Biloxi',30.39580487,-88.88530868,43857,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Springfield','Springfield',39.82000999,-89.65001652,125345,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Frankfort','Frankfort',38.2008065,-84.87335718,32214.5,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Greensboro','Greensboro',36.07000633,-79.80002344,310328,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dayton','Dayton',39.750376,-84.19998743,466067,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Virginia Beach','Virginia Beach',36.85321433,-75.97831873,877475.5,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Madison','Madison',43.07301556,-89.40111699,276036,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Green Bay','Green Bay',44.5299809,-88.00001388,149811.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Trenton','Trenton',40.2169625,-74.74335535,225713,'United States of America','US','USA','New Jersey');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lansing','Lansing',42.73352724,-84.54673629,198821.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gambell','Gambell',63.77971031,-171.7310787,681,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Palmer','Palmer',61.59971417,-149.1126919,9848,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Seward','Seward',60.1261607,-149.4699827,2900,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Duluth','Duluth',46.78333173,-92.10637822,82026.5,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bemidji','Bemidji',47.47357383,-94.88018823,14063.5,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Havre','Havre',48.54523968,-109.6776829,10266.5,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kalispell','Kalispell',48.19776735,-114.3159786,25040,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Idaho Falls','Idaho Falls',43.46668662,-112.0333014,65787,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lewiston','Lewiston',46.41660992,-117.016589,40096.5,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Yakima','Yakima',46.60223167,-120.5046965,93846,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wenatchee','Wenatchee',47.42362856,-120.3090237,45892,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Douglas','Douglas',31.35864016,-109.5483627,23438.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bakersfield','Bakersfield',35.36997154,-119.0199809,367259,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Oakland','Oakland',37.76892071,-122.2211034,953044,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lancaster','Lancaster',34.69804873,-118.135823,225799,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chico','Chico',39.72862022,-121.8363982,83226.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Monterey','Monterey',36.6002582,-121.8935781,77297.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Salinas','Salinas',36.68221702,-121.6416555,152737.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Los Alamos','Los Alamos',35.89110252,-106.2977084,11997,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Eugene','Eugene',44.05001019,-123.1000161,195183,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Coos Bay','Coos Bay',43.36661521,-124.2165888,23685,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bend','Bend',44.071921,-121.3099962,70598.5,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cody','Cody',44.52321128,-109.0571007,8976.5,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cedar Rapids','Cedar Rapids',41.96998212,-91.66002303,149338.5,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Springfield','Springfield',37.18001609,-93.31999923,180691,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lincoln','Lincoln',40.81997479,-96.68000086,244146,'United States of America','US','USA','Nebraska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Alexandria','Alexandria',31.31109784,-92.44501388,60876,'United States of America','US','USA','Louisiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Abilene','Abilene',32.4486253,-99.73278609,108008,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Brownsville','Brownsville',25.91997988,-97.50000248,174707,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tyler','Tyler',32.35108604,-95.30078272,101561.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Concord','Concord',43.20807192,-71.53804712,42646.5,'United States of America','US','USA','New Hampshire');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Huntsville','Huntsville',34.71995953,-86.60999536,185474.5,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Key West','Key West',24.55523114,-81.78274479,27011.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('West Palm Beach','West Palm Beach',26.74501996,-80.12362126,675521.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sarasota','Sarasota',27.33612083,-82.53078699,321223.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Daytona Beach','Daytona Beach',29.21055422,-81.0230754,140775.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gainesville','Gainesville',29.65138002,-82.32503727,158390.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ft. Myers','Ft. Myers',26.64029767,-81.86049199,120810.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Brunswick','Brunswick',31.1496865,-81.49165145,31785.5,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Augusta','Augusta',33.46081158,-81.98498051,152895.5,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vicksburg','Vicksburg',32.3524813,-90.8777452,24669.5,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Myrtle Beach','Myrtle Beach',33.68891136,-78.8869784,37333.5,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Charleston','Charleston',32.79237693,-79.99210474,254295,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Peoria','Peoria',40.69998212,-89.67004114,142622,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Evansville','Evansville',37.97469627,-87.5558291,144788,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Louisville','Louisville',38.22501691,-85.74870427,595819.5,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lexington','Lexington',38.05001467,-84.50002079,244972,'United States of America','US','USA','Kentucky');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Charlotte','Charlotte',35.20499453,-80.83003809,943574.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Youngstown','Youngstown',41.09969932,-80.64973902,194765,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Canton','Canton',40.79886497,-81.37863509,168410,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Toledo','Toledo',41.67002626,-83.57997359,388449,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Columbus','Columbus',39.97997438,-82.9900096,1003418,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chattanooga','Chattanooga',35.06998985,-85.25000086,206571.5,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Charlottesville','Charlottesville',38.02918907,-78.47692591,61314,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lynchburg','Lynchburg',37.4136194,-79.14246668,84581,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wausau','Wausau',44.95915367,-89.6299919,56100.5,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Albany','Albany',42.67001691,-73.81994918,484286,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ithaca','Ithaca',42.44057355,-76.4969434,45544.5,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Harrisburg','Harrisburg',40.27359987,-76.88474919,289210,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bangor','Bangor',44.80115297,-68.77834477,40843,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Portland','Portland',43.67216158,-70.2455274,99504,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Saginaw','Saginaw',43.4194802,-83.95082951,89457.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ketchikan','Ketchikan',55.3562193,-131.6639895,8121,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Unalaska','Unalaska',53.868584,-166.5316028,1938.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Togiak','Togiak',59.07036101,-160.3783234,236,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Red Devil','Red Devil',61.76099632,-157.3125273,24,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hooper Bay','Hooper Bay',61.53108787,-166.0965648,623,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wainwright','Wainwright',70.63688865,-160.0383041,174,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Galena','Galena',64.73329551,-156.9269953,485,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kaktovik','Kaktovik',70.08785552,-143.6029132,101,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Skagway','Skagway',59.45832033,-135.3138959,955,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cordova','Cordova',60.5427761,-145.7574962,1622.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kenai','Kenai',60.55435162,-151.2580131,6580.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fort Yukon','Fort Yukon',66.56468243,-145.2737789,833,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Santa Cruz','Santa Cruz',36.97194629,-122.0263904,101530.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Bernardino','San Bernardino',34.12038373,-117.3000342,973690.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bridgeport','Bridgeport',41.17997866,-73.19996118,578545,'United States of America','US','USA','Connecticut');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rochester','Rochester',43.17042564,-77.61994979,483177,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('International Falls','International Falls',48.60112775,-93.4108464,10832,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. Paul','St. Paul',44.94398663,-93.08497481,509961,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Billings','Billings',45.78830202,-108.5400004,102151.5,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Great Falls','Great Falls',47.50029055,-111.299987,61316.5,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Missoula','Missoula',46.87224103,-113.9930526,68010,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Minot','Minot',48.23249392,-101.2958173,37162,'United States of America','US','USA','North Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fargo','Fargo',46.8772278,-96.7894257,127472.5,'United States of America','US','USA','North Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hilo','Hilo',19.69999778,-155.0900273,47720.5,'United States of America','US','USA','Hawaii');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Olympia','Olympia',47.03804486,-122.899434,100950,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Spokane','Spokane',47.66999595,-117.4199494,272483.5,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vancouver','Vancouver',45.63030133,-122.6399925,343796.5,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Flagstaff','Flagstaff',35.19809572,-111.6505083,60779.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tucson','Tucson',32.20499676,-110.8899862,670953.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Santa Barbara','Santa Barbara',34.43498985,-119.7199899,135021,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fresno','Fresno',36.7477169,-119.7729841,540768,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Eureka','Eureka',40.80222394,-124.1474974,34012,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Colorado Springs','Colorado Springs',38.86296246,-104.7919863,427272,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Reno','Reno',39.52997601,-119.8200096,265363.5,'United States of America','US','USA','Nevada');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Elko','Elko',40.83250633,-115.7619886,17537,'United States of America','US','USA','Nevada');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Albuquerque','Albuquerque',35.10497479,-106.6413308,725723,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Salem','Salem',44.92807029,-123.0238967,187966,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Casper','Casper',42.86661989,-106.3124878,56149,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Topeka','Topeka',39.05000531,-95.66998499,126830.5,'United States of America','US','USA','Kansas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kansas City','Kansas City',39.10708851,-94.60409422,955272.5,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tulsa','Tulsa',36.12000327,-95.93002079,669434,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sioux Falls','Sioux Falls',43.54998903,-96.7299978,148030,'United States of America','US','USA','South Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Shreveport','Shreveport',32.50001752,-93.77002344,224099,'United States of America','US','USA','Louisiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Baton Rouge','Baton Rouge',30.45794578,-91.14015812,322710.5,'United States of America','US','USA','Louisiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ft. Worth','Ft. Worth',32.73997703,-97.34003809,1090830,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Corpus Christi','Corpus Christi',27.74281435,-97.40189478,249977.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Austin','Austin',30.26694969,-97.74277836,919684,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Amarillo','Amarillo',35.22998008,-101.8299966,178526,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('El Paso','El Paso',31.77998395,-106.5099952,658331,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Laredo','Laredo',27.50613629,-99.50721847,322768.5,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Burlington','Burlington',44.47579816,-73.21246688,66204,'United States of America','US','USA','Vermont');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Montgomery','Montgomery',32.36160219,-86.27918868,194491.5,'United States of America','US','USA','Alabama');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tallahassee','Tallahassee',30.44998761,-84.28003422,187402.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Orlando','Orlando',28.50997683,-81.38003036,778985,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jacksonville','Jacksonville',30.33002077,-81.66998682,904953.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Savannah','Savannah',32.02110618,-81.10999516,155848.5,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Columbia','Columbia',34.0399752,-80.89998214,257185.5,'United States of America','US','USA','South Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Indianapolis','Indianapolis',39.74998842,-86.17004806,1104641.5,'United States of America','US','USA','Indiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Wilmington','Wilmington',34.22551943,-77.94502039,126992,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Knoxville','Knoxville',35.97001243,-83.92003036,417137,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Richmond','Richmond',37.55001935,-77.449986,551443,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Charleston','Charleston',38.34973798,-81.63272811,87113,'United States of America','US','USA','West Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Baltimore','Baltimore',39.29999005,-76.61998499,1432946,'United States of America','US','USA','Maryland');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Syracuse','Syracuse',43.04999371,-76.15001367,403873.5,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Augusta','Augusta',44.31056276,-69.77998906,21301,'United States of America','US','USA','Maine');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sault Ste. Marie','Sault Ste. Marie',46.49526145,-84.34527572,50173.5,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sitka','Sitka',57.06039769,-135.3275494,8110,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Helena','Helena',46.59274904,-112.035291,33032.5,'United States of America','US','USA','Montana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bismarck','Bismarck',46.80831728,-100.7833163,60288.5,'United States of America','US','USA','North Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Boise','Boise',43.60859011,-116.2274899,242029,'United States of America','US','USA','Idaho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Jose','San Jose',37.29998293,-121.8499891,1281471.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sacramento','Sacramento',38.57502138,-121.4700381,1035949,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Las Vegas','Las Vegas',36.20999778,-115.2200061,1150717,'United States of America','US','USA','Nevada');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Santa Fe','Santa Fe',35.68692893,-105.9372394,80943,'United States of America','US','USA','New Mexico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Portland','Portland',45.52002382,-122.6799901,1207756.5,'United States of America','US','USA','Oregon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Salt Lake City','Salt Lake City',40.7750163,-111.9300519,572013,'United States of America','US','USA','Utah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cheyenne','Cheyenne',41.14000694,-104.8197107,64185,'United States of America','US','USA','Wyoming');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Des Moines','Des Moines',41.57998008,-93.61998092,286917.5,'United States of America','US','USA','Iowa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Omaha','Omaha',41.24000083,-96.00999007,643034,'United States of America','US','USA','Nebraska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Oklahoma City','Oklahoma City',35.47004295,-97.51868351,660475,'United States of America','US','USA','Oklahoma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pierre','Pierre',44.36833701,-100.350552,13734.5,'United States of America','US','USA','South Dakota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Antonio','San Antonio',29.48733319,-98.50730534,1364905,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jackson','Jackson',32.29881533,-90.18499679,213799,'United States of America','US','USA','Mississippi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Raleigh','Raleigh',35.81878135,-78.64469344,789991.5,'United States of America','US','USA','North Carolina');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cleveland','Cleveland',41.4699868,-81.69499821,1169757,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cincinnati','Cincinnati',39.16188479,-84.45692265,971191,'United States of America','US','USA','Ohio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nashville','Nashville',36.16997438,-86.77998499,703926,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Memphis','Memphis',35.1199868,-89.99999516,753843.5,'United States of America','US','USA','Tennessee');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Norfolk','Norfolk',36.84995872,-76.28000574,645336,'United States of America','US','USA','Virginia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Milwaukee','Milwaukee',43.05265505,-87.91996708,983590,'United States of America','US','USA','Wisconsin');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Buffalo','Buffalo',42.87997825,-78.88000208,647778.5,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Pittsburgh','Pittsburgh',40.4299986,-79.99998539,1535267.5,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kodiak','Kodiak',57.78999839,-152.4069869,7804.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cold Bay','Cold Bay',55.20000144,-162.7150916,154,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bethel','Bethel',60.79330345,-161.7557961,5440.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Point Hope','Point Hope',68.34772605,-166.8080201,461,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Barrow','Barrow',71.29056968,-156.78858,3412,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nome','Nome',64.50610008,-165.4063744,3021,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Valdez','Valdez',61.13599571,-146.348287,3283,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Juneau','Juneau',58.31412661,-134.419997,26172,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fairbanks','Fairbanks',64.83698427,-147.7106586,43608.5,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Prudhoe Bay','Prudhoe Bay',70.29218101,-148.6693598,2337,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Minneapolis','Minneapolis',44.97997927,-93.25178634,1491886.5,'United States of America','US','USA','Minnesota');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Honolulu','Honolulu',21.30687644,-157.8579979,578828.5,'United States of America','US','USA','Hawaii');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Seattle','Seattle',47.57000205,-122.339985,1821684.5,'United States of America','US','USA','Washington');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Phoenix','Phoenix',33.53997988,-112.0699917,2436022.5,'United States of America','US','USA','Arizona');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Diego','San Diego',32.82002382,-117.1799899,1938570.5,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('St. Louis','St. Louis',38.63501772,-90.23998051,1259958,'United States of America','US','USA','Missouri');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('New Orleans','New Orleans',29.99500246,-90.03996688,527428.5,'United States of America','US','USA','Louisiana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dallas','Dallas',32.82002382,-96.84001693,3004852,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Boston','Boston',42.32996014,-71.07001367,2528070.5,'United States of America','US','USA','Massachusetts');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tampa','Tampa',27.94698793,-82.45862085,1319232.5,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Philadelphia','Philadelphia',39.99997316,-75.16999597,3504775,'United States of America','US','USA','Pennsylvania');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Detroit','Detroit',42.32996014,-83.08005579,2526135,'United States of America','US','USA','Michigan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Anchorage','Anchorage',61.21996991,-149.9002149,252068,'United States of America','US','USA','Alaska');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Francisco','San Francisco',37.74000775,-122.4599777,2091036,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Denver','Denver',39.73918805,-104.984016,1930799.5,'United States of America','US','USA','Colorado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Houston','Houston',29.81997438,-95.33997929,4053287,'United States of America','US','USA','Texas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Miami','Miami',25.7876107,-80.22410608,2983947,'United States of America','US','USA','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Atlanta','Atlanta',33.83001385,-84.39994938,2464454,'United States of America','US','USA','Georgia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chicago','Chicago',41.82999066,-87.75005497,5915976,'United States of America','US','USA','Illinois');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Los Angeles','Los Angeles',33.98997825,-118.1799805,8097410,'United States of America','US','USA','California');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Washington, D.C.','Washington, D.C.',38.89954938,-77.00941858,2445216.5,'United States of America','US','USA','District of Columbia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('New York','New York',40.74997906,-73.98001693,13524139,'United States of America','US','USA','New York');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Christiansted','Christiansted',17.75037518,-64.749986,32543,'United States Virgin Islands','VI','VIR','');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Colonia del Sacramento','Colonia del Sacramento',-34.47999901,-57.84000247,21714,'Uruguay','UY','URY','Colonia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Trinidad','Trinidad',-33.54399894,-56.90099656,21093,'Uruguay','UY','URY','Flores');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fray Bentos','Fray Bentos',-33.13899903,-58.30399747,23279,'Uruguay','UY','URY','Río Negro');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Canelones','Canelones',-34.53800401,-56.28400149,19698,'Uruguay','UY','URY','Canelones');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Florida','Florida',-34.09900201,-56.21499845,32234,'Uruguay','UY','URY','Florida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Artigas','Artigas',-30.41598712,-56.48602014,32072.5,'Uruguay','UY','URY','Artigas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Baltasar Brum','Baltasar Brum',-30.7300248,-57.31997441,2432,'Uruguay','UY','URY','Artigas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tranqueras','Tranqueras',-31.20002195,-55.74996688,4775.5,'Uruguay','UY','URY','Rivera');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tacuarembo','Tacuarembo',-31.70996499,-55.98000452,53065.5,'Uruguay','UY','URY','Tacuarembó');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Paso de los Toros','Paso de los Toros',-32.8100012,-56.51004968,11450,'Uruguay','UY','URY','Tacuarembó');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vergara','Vergara',-32.92999388,-53.94999923,3749,'Uruguay','UY','URY','Treinta y Tres');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Treinta y Tres','Treinta y Tres',-33.23002724,-54.38002466,26668.5,'Uruguay','UY','URY','Treinta y Tres');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Santa Lucia','Santa Lucia',-34.47000324,-56.39997888,15264.5,'Uruguay','UY','URY','Canelones');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jose Batlle y Ordonez','Jose Batlle y Ordonez',-33.47001259,-55.12000533,2438,'Uruguay','UY','URY','Lavalleja');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Minas','Minas',-34.37000934,-55.23002446,39602.5,'Uruguay','UY','URY','Lavalleja');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Maldonado','Maldonado',-34.91002806,-54.95998926,51877.5,'Uruguay','UY','URY','Maldonado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Punta del Este','Punta del Este',-34.96997272,-54.94998987,84140,'Uruguay','UY','URY','Maldonado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Aigua','Aigua',-34.19999388,-54.75000208,2622,'Uruguay','UY','URY','Maldonado');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('La Paloma','La Paloma',-34.66999103,-54.1699858,2897,'Uruguay','UY','URY','Rocha');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Carmelo','Carmelo',-33.98961912,-58.29999211,15113.5,'Uruguay','UY','URY','Colonia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bella Union','Bella Union',-30.25961424,-57.59995732,17947,'Uruguay','UY','URY','Artigas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mercedes','Mercedes',-33.25953449,-58.02998275,41951.5,'Uruguay','UY','URY','Soriano');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Melo','Melo',-32.35948606,-54.17998519,53258.5,'Uruguay','UY','URY','Cerro Largo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rivera','Rivera',-30.89957518,-55.56000431,132232.5,'Uruguay','UY','URY','Rivera');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lascano','Lascano',-33.66958698,-54.20000981,5215.5,'Uruguay','UY','URY','Rocha');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Castillos','Castillos',-34.16960814,-53.82998071,7686,'Uruguay','UY','URY','Rocha');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Jose de Mayo','San Jose de Mayo',-34.34995888,-56.7099858,36462,'Uruguay','UY','URY','San José');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rocha','Rocha',-34.48297402,-54.33302494,26194.5,'Uruguay','UY','URY','Rocha');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Paysandu','Paysandu',-32.32997882,-58.0799797,76132.5,'Uruguay','UY','URY','Paysandú');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Salto','Salto',-31.39034625,-57.9686945,102756.5,'Uruguay','UY','URY','Salto');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Durazno','Durazno',-33.41001626,-56.51004968,33981.5,'Uruguay','UY','URY','Durazno');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Montevideo','Montevideo',-34.85804157,-56.17105229,759162,'Uruguay','UY','URY','Montevideo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Khujayli','Khujayli',42.4047101,59.45165767,55200.5,'Uzbekistan','UZ','UZB','Karakalpakstan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Urgut','Urgut',39.40070742,67.26069006,73524,'Uzbekistan','UZ','UZB','Samarkand');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kattaqorgon','Kattaqorgon',39.90070274,66.2607511,153247.5,'Uzbekistan','UZ','UZB','Samarkand');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Denow','Denow',38.27715843,67.88716345,143134,'Uzbekistan','UZ','UZB','Surkhandarya');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Guliston','Guliston',40.49573102,68.79072587,74446.5,'Uzbekistan','UZ','UZB','Sirdaryo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Iskandar','Iskandar',41.55073122,69.68074906,111634.5,'Uzbekistan','UZ','UZB','Tashkent');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chirchiq','Chirchiq',41.45497479,69.55998124,155093.5,'Uzbekistan','UZ','UZB','Tashkent');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kogon','Kogon',39.72107546,64.54576534,85093,'Uzbekistan','UZ','UZB','Bukhoro');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Khiwa','Khiwa',41.39112856,60.35573686,102659,'Uzbekistan','UZ','UZB','Khorezm');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chimboy','Chimboy',42.93113792,59.77075964,34277.5,'Uzbekistan','UZ','UZB','Karakalpakstan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Qunghirot','Qunghirot',43.0704059,58.90001176,57758,'Uzbekistan','UZ','UZB','Karakalpakstan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Zarafshon','Zarafshon',41.58222801,64.20180701,55292.5,'Uzbekistan','UZ','UZB','Navoi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Navoi','Navoi',40.1104057,65.35496659,172276.5,'Uzbekistan','UZ','UZB','Navoi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Shahrisabz','Shahrisabz',39.06178754,66.83146562,277798,'Uzbekistan','UZ','UZB','Kashkadarya');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Qarshi','Qarshi',38.87042971,65.80000403,304629.5,'Uzbekistan','UZ','UZB','Kashkadarya');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Qoqon','Qoqon',40.54040529,70.94000037,271250,'Uzbekistan','UZ','UZB','Ferghana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Jizzax','Jizzax',40.10038047,67.83000932,193997,'Uzbekistan','UZ','UZB','Jizzakh');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Angren','Angren',41.03037539,70.15493201,164513.5,'Uzbekistan','UZ','UZB','Tashkent');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Olmaliq','Olmaliq',40.85043805,69.59501786,119768,'Uzbekistan','UZ','UZB','Tashkent');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Muynoq','Muynoq',43.76832196,59.0213997,13000,'Uzbekistan','UZ','UZB','Karakalpakstan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Termiz','Termiz',37.23293276,67.27293738,159036,'Uzbekistan','UZ','UZB','Surkhandarya');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Fargona','Fargona',40.3899752,71.78000077,482000,'Uzbekistan','UZ','UZB','Ferghana');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Namangan','Namangan',41.00001548,71.66998165,599600,'Uzbekistan','UZ','UZB','Namangan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Urgentch','Urgentch',41.5599813,60.64000891,126476.5,'Uzbekistan','UZ','UZB','Khorezm');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bukhara','Bukhara',39.78001243,64.43001013,283560,'Uzbekistan','UZ','UZB','Bukhoro');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nukus','Nukus',42.47000327,59.61500688,228211,'Uzbekistan','UZ','UZB','Karakalpakstan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Andijon','Andijon',40.79000246,72.33996659,486950,'Uzbekistan','UZ','UZB','Andijon');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Samarqand','Samarqand',39.67001914,66.94499874,652150,'Uzbekistan','UZ','UZB','Samarkand');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tashkent','Tashkent',41.31170188,69.29493282,2081014,'Uzbekistan','UZ','UZB','Tashkent');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Luganville','Luganville',-15.51255573,167.1766068,10634.5,'Vanuatu','VU','VUT','Sanma');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Port Vila','Port-Vila',-17.7333504,168.3166406,39970.5,'Vanuatu','VU','VUT','Shefa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vatican City','Vatican City',41.90001223,12.44780839,832,'Vatican (Holy Sea)','VA','VAT','Lazio');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Carlos','San Carlos',9.657999007,-68.58999854,77192,'Venezuela','VE','VEN','Cojedes');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Felipe','San Felipe',10.33599598,-68.74599552,76766,'Venezuela','VE','VEN','Yaracuy');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Juan De Los Morros','San Juan De Los Morros',9.900999019,-67.35400159,87739,'Venezuela','VE','VEN','Guárico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('La Asuncion','La Asuncion',11.03333403,-63.8833315,35084,'Venezuela','VE','VEN','Nueva Esparta');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Guasdualito','Guasdualito',7.239983133,-70.73998214,28287.5,'Venezuela','VE','VEN','Apure');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Barinas','Barinas',8.59997764,-70.25001205,261405.5,'Venezuela','VE','VEN','Barinas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Valera','Valera',9.319959533,-70.6200153,142461.5,'Venezuela','VE','VEN','Trujillo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cabimas','Cabimas',10.42999514,-71.44999048,320956,'Venezuela','VE','VEN','Trujillo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Carora','Carora',10.18998395,-70.07999658,121749.5,'Venezuela','VE','VEN','Lara');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Guanare','Guanare',9.049976012,-69.75001673,131964,'Venezuela','VE','VEN','Portuguesa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Puerto la Cruz','Puerto la Cruz',10.16995933,-64.68001612,500464,'Venezuela','VE','VEN','Anzoátegui');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Anaco','Anaco',9.440003885,-64.4600037,100118,'Venezuela','VE','VEN','Anzoátegui');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Los Teques','Los Teques',10.41996991,-67.02002832,303470,'Venezuela','VE','VEN','Distrito Capital');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Valle de la Pascua','Valle de la Pascua',9.209992085,-66.019986,86273.5,'Venezuela','VE','VEN','Guárico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ocumare del Tuy','Ocumare del Tuy',10.11998822,-66.77999129,130824,'Venezuela','VE','VEN','Miranda');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Carupano','Carupano',10.67000633,-63.23000126,119187.5,'Venezuela','VE','VEN','Sucre');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Trujillo','Trujillo',9.38039512,-70.44000045,44231.5,'Venezuela','VE','VEN','Trujillo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Santa Rita','Santa Rita',10.53182698,-71.50394902,21095,'Venezuela','VE','VEN','Trujillo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Machiques','Machiques',10.07043052,-72.54994918,44936.5,'Venezuela','VE','VEN','Zulia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Carlos del Zulia','San Carlos del Zulia',9.010391865,-71.91998763,76935,'Venezuela','VE','VEN','Zulia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Puerto Cabello','Puerto Cabello',10.47043194,-68.17000981,174000,'Venezuela','VE','VEN','Carabobo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Acarigua','Acarigua',9.580382913,-69.20002446,202312.5,'Venezuela','VE','VEN','Portuguesa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Upata','Upata',8.020426452,-62.40999964,53474.5,'Venezuela','VE','VEN','Bolívar');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('El Manteco','El Manteco',7.35038983,-62.53332544,2215,'Venezuela','VE','VEN','Bolívar');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chaguaramas','Chaguaramas',9.215934874,-63.75226913,12500,'Venezuela','VE','VEN','Anzoátegui');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Barcelona','Barcelona',10.13037518,-64.72001367,361430,'Venezuela','VE','VEN','Anzoátegui');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('El Tigre','El Tigre',8.890347513,-64.26001591,174219.5,'Venezuela','VE','VEN','Anzoátegui');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Maiquetia','Maiquetia',10.60039817,-66.9699797,184003,'Venezuela','VE','VEN','Vargas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Calabozo','Calabozo',8.930396748,-67.43997685,110907,'Venezuela','VE','VEN','Guárico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Zaraza','Zaraza',9.340397562,-65.32000289,35279.5,'Venezuela','VE','VEN','Guárico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Altagracia de Orituco','Altagracia de Orituco',9.85041811,-66.37998987,34427,'Venezuela','VE','VEN','Guárico');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tucupita','Tucupita',9.060492166,-62.05999516,49704,'Venezuela','VE','VEN','Monagas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Porlamar','Porlamar',10.9603762,-63.84998926,142027,'Venezuela','VE','VEN','Nueva Esparta');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Fernando de Apure','San Fernando de Apure',7.899994526,-67.46994918,100740,'Venezuela','VE','VEN','Apure');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Barquisimeto','Barquisimeto',10.04999249,-69.29996668,962745,'Venezuela','VE','VEN','Lara');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Maturin','Maturin',9.749959126,-63.17003076,357707.5,'Venezuela','VE','VEN','Monagas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cumana','Cumana',10.44999392,-64.18002079,287693,'Venezuela','VE','VEN','Sucre');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Coro','Coro',11.42001223,-69.67999516,184098,'Venezuela','VE','VEN','Falcón');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Punto Fijo','Punto Fijo',11.71999392,-70.21001449,183260,'Venezuela','VE','VEN','Falcón');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('La Esmeralda','La Esmeralda',3.173823058,-65.54660405,149.5,'Venezuela','VE','VEN','Amazonas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ciudad Bolivar','Ciudad Bolivar',8.099982319,-63.60000452,317971.5,'Venezuela','VE','VEN','Bolívar');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('El Dorado','El Dorado',6.733295714,-61.6333287,2383,'Venezuela','VE','VEN','Bolívar');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Maracay','Maracay',10.2468797,-67.59580713,1007000,'Venezuela','VE','VEN','Aragua');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Merida','Merida',8.399989847,-71.13001001,275184,'Venezuela','VE','VEN','Mérida');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Puerto Ayacucho','Puerto Ayacucho',5.663903624,-67.62360905,51622.5,'Venezuela','VE','VEN','Amazonas');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('San Cristobal','San Cristobal',7.770002461,-72.24996749,342690.5,'Venezuela','VE','VEN','Táchira');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Valencia','Valencia',10.22998151,-67.9800214,1569526.5,'Venezuela','VE','VEN','Carabobo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ciudad Guayana','Ciudad Guayana',8.370017516,-62.61998682,634317.5,'Venezuela','VE','VEN','Bolívar');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Maracaibo','Maracaibo',10.72997683,-71.65997766,1764650,'Venezuela','VE','VEN','Zulia');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Caracas','Caracas',10.50099855,-66.91703719,2400339.5,'Venezuela','VE','VEN','Distrito Capital');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tay Ninh','Tay Ninh',11.32299911,106.1469997,126370,'Vietnam','VN','VNM','Tây Ninh');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Luan Chau','Luan Chau',21.74000399,103.3430047,7335,'Vietnam','VN','VNM','Điện Biên');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bac Kan','Bac Kan',22.1333333,105.8333333,29227,'Vietnam','VN','VNM','Bac Kan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lang Son','Lang Son',21.8459971,106.7570016,148000,'Vietnam','VN','VNM','Lạng Sơn');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Son La','Son La',21.32800214,103.9100047,19054,'Vietnam','VN','VNM','Son La');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tuyen Quang','Tuyen Quang',21.8179981,105.2109996,36430,'Vietnam','VN','VNM','Tuyên Quang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Yen Bai','Yen Bai',21.70500304,104.8750026,96540,'Vietnam','VN','VNM','Yên Bái');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hai Duong','Hai Duong',20.94200108,106.3310046,58030,'Vietnam','VN','VNM','Hải Dương');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Thai Binh','Thai Binh',20.45030412,106.3330296,210000,'Vietnam','VN','VNM','Thái Bình');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tuy Hoa','Tuy Hoa',13.08200402,109.3159987,69596,'Vietnam','VN','VNM','Phú Yên');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Thu Dau Mot','Thu Dau Mot',10.96907408,106.6527455,244277,'Vietnam','VN','VNM','Bình Duong');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dong Ha','Dong Ha',16.8499981,107.1333007,17662,'Vietnam','VN','VNM','Quảng Trị');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cao Lanh','Cao Lanh',10.46700013,105.6359976,149837,'Vietnam','VN','VNM','Đồng Tháp');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Truc Giang','Truc Giang',10.234998,106.3749966,59442,'Vietnam','VN','VNM','Bến Tre');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tra Vinh','Tra Vinh',9.934002087,106.3340017,131360,'Vietnam','VN','VNM','Trà Vinh');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vinh Long','Vinh Long',10.256004,105.9640026,103314,'Vietnam','VN','VNM','Vinh Long');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cao Bang','Cao Bang',22.66399806,106.2680046,41112,'Vietnam','VN','VNM','Cao Bằng');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hong Gai','Hong Gai',20.9604118,107.1000154,160490.5,'Vietnam','VN','VNM','Quảng Ninh');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cam Pha','Cam Pha',21.04043276,107.320002,75925.5,'Vietnam','VN','VNM','Quảng Ninh');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lao Chi','Lao Chi',22.50135134,103.9659948,51854,'Vietnam','VN','VNM','Lào Cai');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hoa Binh','Hoa Binh',20.81370241,105.3383142,102381,'Vietnam','VN','VNM','Hòa Bình');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Son Tay','Son Tay',21.13817873,105.5050223,115091.5,'Vietnam','VN','VNM','Hà Tây');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ninh Binh','Ninh Binh',20.25430503,105.9750195,130517,'Vietnam','VN','VNM','Ninh Bình');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Viet Tri','Viet Tri',21.33041506,105.4299882,305144,'Vietnam','VN','VNM','Phú Thọ');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bac Giang','Bac Giang',21.26700808,106.2000187,53728,'Vietnam','VN','VNM','Bắc Giang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ha Tinh','Ha Tinh',18.33377626,105.900037,165396,'Vietnam','VN','VNM','Ha Tinh');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Buon Me Thuot','Buon Me Thuot',12.66704205,108.0499833,248460,'Vietnam','VN','VNM','Dak Lak');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Da Lat','Da Lat',11.93042035,108.4199865,193698,'Vietnam','VN','VNM','Lâm Đồng');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Phan Rang','Phan Rang',11.56703168,108.9833113,135646.5,'Vietnam','VN','VNM','Ninh Thuận');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hon Quan','Hon Quan',11.65038576,106.6000459,40279,'Vietnam','VN','VNM','Bình Phước');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kon Tum','Kon Tum',14.38375897,107.9833207,76449,'Vietnam','VN','VNM','Kon Tum');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Quang Ngai','Quang Ngai',15.15043052,108.8299873,184625.5,'Vietnam','VN','VNM','Quảng Ngãi');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Quang Tri','Quang Tri',16.7503587,107.2000093,72722,'Vietnam','VN','VNM','Quảng Trị');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vung Tau','Vung Tau',10.35537437,107.0849776,229225,'Vietnam','VN','VNM','Bà Rịa–Vũng Tàu');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Phan Thiet','Phan Thiet',10.933737,108.1000577,248749,'Vietnam','VN','VNM','Bình Thuận');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Long Xuyen','Long Xuyen',10.38038576,105.4200146,254076.5,'Vietnam','VN','VNM','An Giang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chau Doc','Chau Doc',10.70039207,105.1166739,70239,'Vietnam','VN','VNM','An Giang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rach Gia','Rach Gia',10.01539512,105.0913525,252830,'Vietnam','VN','VNM','Kiên Giang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Tan An','Tan An',10.53373557,106.416698,101149.5,'Vietnam','VN','VNM','Long An');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('My Tho','My Tho',10.35041343,106.3500354,123226.5,'Vietnam','VN','VNM','Tiền Giang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bac Lieu','Bac Lieu',9.280375385,105.7199963,187500,'Vietnam','VN','VNM','Bạc Liêu');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ca Mau','Ca Mau',9.177358418,105.1500052,280765.5,'Vietnam','VN','VNM','Cà Mau');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Soc Trang','Soc Trang',9.603740661,105.9800321,236961,'Vietnam','VN','VNM','Sóc Trang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ha Giang','Ha Giang',22.83365664,104.9833488,35526,'Vietnam','VN','VNM','Hà Giang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Thai Nguyen','Thai Nguyen',21.59995933,105.8300154,415000,'Vietnam','VN','VNM','Thái Nguyên');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Thanh Hoa','Thanh Hoa',19.8200163,105.7999914,197551,'Vietnam','VN','VNM','Thanh Hóa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nam Dinh','Nam Dinh',20.42003135,106.2000187,243186,'Vietnam','VN','VNM','Nam Định');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Vinh','Vinh',18.6999813,105.6799987,514426.5,'Vietnam','VN','VNM','Nghệ An');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dong Hoi','Dong Hoi',17.48333722,106.6000459,110152.5,'Vietnam','VN','VNM','Quảng Bình');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Play Ku','Play Ku',13.98329246,108.0000122,128562.5,'Vietnam','VN','VNM','Gia Lai');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nha Trang','Nha Trang',12.25003908,109.1700183,347498.5,'Vietnam','VN','VNM','Khánh Hòa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Cam Ranh','Cam Ranh',11.90202415,109.2206612,85327,'Vietnam','VN','VNM','Khánh Hòa');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Qui Nhon','Qui Nhon',13.77997154,109.1800435,543095,'Vietnam','VN','VNM','Bình Định');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hue','Hue',16.46998822,107.5800378,645000,'Vietnam','VN','VNM','Thừa Thiên–Huế');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bien Hoa','Bien Hoa',10.97001385,106.8300577,652646,'Vietnam','VN','VNM','Đồng Nai');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Can Tho','Can Tho',10.04999249,105.7700191,690299,'Vietnam','VN','VNM','Can Tho');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Haiphong','Haiphong',20.83000633,106.6800927,1285847.5,'Vietnam','VN','VNM','Quảng Ninh');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Da Nang','Da Nang',16.06003908,108.2499711,943534.5,'Vietnam','VN','VNM','Da Nang');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hanoi','Hanoi',21.03332725,105.8500142,2904635,'Vietnam','VN','VNM','Thái Nguyên');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ho Chi Minh City','Ho Chi Minh City',10.78002545,106.6950272,4390665.5,'Vietnam','VN','VNM','Ho Chi Minh City');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bir Lehlou','Bir Lehlou',26.11916669,-9.652522218,350,'Western Sahara','EH','SAH','');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Al Bayda','Al Bayda',13.9789981,45.57400265,37821,'Yemen','YE','YEM','Al Bayda''');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('''Ataq','''Ataq',14.55000311,46.80000058,37315,'Yemen','YE','YEM','Shabwah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Marib','Marib',15.42099607,45.33399954,16794,'Yemen','YE','YEM','Ma''rib');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Dhamar','Dhamar',14.5574693,44.3874609,191259,'Yemen','YE','YEM','Dhamar');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ibb','Ibb',13.97585105,44.17088497,234837,'Yemen','YE','YEM','Ibb');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ash Shihr','Ash Shihr',14.75931744,49.60915767,54274,'Yemen','YE','YEM','Hadramawt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Zabid','Zabid',14.19508832,43.31553666,102547,'Yemen','YE','YEM','Al Hudaydah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hajjah','Hajjah',15.69174115,43.60213415,125918,'Yemen','YE','YEM','Hajjah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lahij','Lahij',13.05818097,44.88376135,44831.5,'Yemen','YE','YEM','Lahij');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Al Ghaydah','Al Ghaydah',16.23940798,52.1637821,23702,'Yemen','YE','YEM','Al Mahrah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Rida','Rida',14.42949261,44.8341003,45233,'Yemen','YE','YEM','Al Bayda''');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hadiboh','Hadiboh',12.65187502,54.02392696,9970.5,'Yemen','YE','YEM','Hadramawt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Saywun','Saywun',15.94299196,48.78734737,68747,'Yemen','YE','YEM','Hadramawt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sadah','Sadah',16.93977867,43.84976762,105542,'Yemen','YE','YEM','Sa`dah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Al Hudaydah','Al Hudaydah',14.79794558,42.95297481,627610.5,'Yemen','YE','YEM','Al Hudaydah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sayhut','Sayhut',15.21050437,51.24544023,189,'Yemen','YE','YEM','Al Mahrah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Al Mukalla','Al Mukalla',14.54116538,49.12593135,194080.5,'Yemen','YE','YEM','Hadramawt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Taizz','Taizz',13.60445253,44.03942012,683111,'Yemen','YE','YEM','Ta`izz');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Aden','Aden',12.77972251,45.00949011,775301,'Yemen','YE','YEM','`Adan');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sanaa','Sanaa',15.3547333,44.20659338,1921926.5,'Yemen','YE','YEM','Amanat Al Asimah');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kawambwa','Kawambwa',-9.779520651,29.08002315,20355,'Zambia','ZM','ZMB','Luapula');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nchelenge','Nchelenge',-9.349572735,28.73001868,15904,'Zambia','ZM','ZMB','Luapula');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chinsali','Chinsali',-10.54960285,32.0599963,7482.5,'Zambia','ZM','ZMB','Northern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kasama','Kasama',-10.19959837,31.17994665,156500,'Zambia','ZM','ZMB','Northern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kapiri Mposhi','Kapiri Mposhi',-13.96960081,28.65999711,30078,'Zambia','ZM','ZMB','Central');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mumbwa','Mumbwa',-14.97961668,27.07001664,14408.5,'Zambia','ZM','ZMB','Central');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chingola','Chingola',-12.53961058,27.85002071,165289.5,'Zambia','ZM','ZMB','Copperbelt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chililabombwe','Chililabombwe',-12.36959511,27.8199967,69698,'Zambia','ZM','ZMB','Copperbelt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Nyimba','Nyimba',-14.54951373,30.80999508,814,'Zambia','ZM','ZMB','Eastern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lundazi','Lundazi',-12.28954832,33.17000606,9540.5,'Zambia','ZM','ZMB','Eastern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chipata','Chipata',-13.62956989,32.64001257,82455,'Zambia','ZM','ZMB','Eastern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mwinilunga','Mwinilunga',-11.73955605,24.4399963,8336.5,'Zambia','ZM','ZMB','North-Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kasempa','Kasempa',-13.4596061,25.82001542,5622,'Zambia','ZM','ZMB','North-Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Solwezi','Solwezi',-12.17958087,26.39998002,51793.5,'Zambia','ZM','ZMB','North-Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Choma','Choma',-16.80947915,26.97002274,42324,'Zambia','ZM','ZMB','Southern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mongu','Mongu',-15.27959837,23.12002519,45098.5,'Zambia','ZM','ZMB','Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kaoma','Kaoma',-14.77962889,24.79997432,7259,'Zambia','ZM','ZMB','Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Sesheke','Sesheke',-17.46954222,24.30000484,10177.5,'Zambia','ZM','ZMB','Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lukulu','Lukulu',-14.38957518,23.24001786,3349,'Zambia','ZM','ZMB','Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kalabo','Kalabo',-14.98959023,22.68000036,7731,'Zambia','ZM','ZMB','Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Senanga','Senanga',-16.11959878,23.27004187,10005,'Zambia','ZM','ZMB','Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mansa','Mansa',-11.20000242,28.89000891,31357,'Zambia','ZM','ZMB','Luapula');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mpika','Mpika',-11.83004148,31.45998124,17242.5,'Zambia','ZM','ZMB','Northern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mbala','Mbala',-8.840043112,31.37001257,18384,'Zambia','ZM','ZMB','Northern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Luanshya','Luanshya',-13.13332111,28.40001298,132679,'Zambia','ZM','ZMB','Copperbelt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Ndola','Ndola',-12.99994424,28.65002356,395428.5,'Zambia','ZM','ZMB','Copperbelt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Zambezi','Zambezi',-13.54001463,23.10994828,4987.5,'Zambia','ZM','ZMB','North-Western');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kafue','Kafue',-15.78003294,28.18002641,25725.5,'Zambia','ZM','ZMB','Southern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mazabuka','Mazabuka',-15.86002806,27.76000036,57874.5,'Zambia','ZM','ZMB','Southern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kabwe','Kabwe',-14.44001137,28.44998409,188667,'Zambia','ZM','ZMB','Central');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mufulira','Mufulira',-12.54999754,28.25996985,137062,'Zambia','ZM','ZMB','Copperbelt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kitwe','Kitwe',-12.81003335,28.22002397,402907.5,'Zambia','ZM','ZMB','Copperbelt');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Livingstone','Livingstone',-17.86000934,25.86001298,137341.5,'Zambia','ZM','ZMB','Southern');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Lusaka','Lusaka',-15.41664427,28.28332759,1297720,'Zambia','ZM','ZMB','Lusaka');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mazowe','Mazowe',-17.51961668,30.97003699,9966,'Zimbabwe','ZW','ZWE','Mashonaland Central');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Shamva','Shamva',-17.31962889,31.57000036,8521,'Zimbabwe','ZW','ZWE','Mashonaland Central');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Victoria Falls','Victoria Falls',-17.92961749,25.8400142,23964.5,'Zimbabwe','ZW','ZWE','Matabeleland North');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Zvishavane','Zvishavane',-20.32957436,30.04998979,34557.5,'Zimbabwe','ZW','ZWE','Midlands');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kwekwe','Kwekwe',-18.92960814,29.79997921,80788,'Zimbabwe','ZW','ZWE','Midlands');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Plumtree','Plumtree',-20.47953937,27.8199967,1959.5,'Zimbabwe','ZW','ZWE','Matabeleland South');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Beitbridge','Beitbridge',-22.20961465,29.98999345,13759.5,'Zimbabwe','ZW','ZWE','Matabeleland South');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gwanda','Gwanda',-20.93961465,29.01000159,8252.5,'Zimbabwe','ZW','ZWE','Matabeleland South');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chiredzi','Chiredzi',-21.04958209,31.66002071,17816.5,'Zimbabwe','ZW','ZWE','Masvingo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Masvingo','Masvingo',-20.05961668,30.8200203,76300.5,'Zimbabwe','ZW','ZWE','Masvingo');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Karoi','Karoi',-16.81955605,29.67998653,13194,'Zimbabwe','ZW','ZWE','Mashonaland West');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chinhoyi','Chinhoyi',-17.35962645,30.18000769,52812,'Zimbabwe','ZW','ZWE','Mashonaland West');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kariba','Kariba',-16.52959959,28.80004024,23133.5,'Zimbabwe','ZW','ZWE','Mashonaland West');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Hwange','Hwange',-18.37000405,26.50002559,33599.5,'Zimbabwe','ZW','ZWE','Matabeleland North');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Gweru','Gweru',-19.45004148,29.82002966,164715.5,'Zimbabwe','ZW','ZWE','Midlands');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Mutare','Mutare',-18.97001911,32.6500378,216785,'Zimbabwe','ZW','ZWE','Manicaland');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Kadoma','Kadoma',-18.33000649,29.90994665,56400,'Zimbabwe','ZW','ZWE','Mashonaland West');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Chitungwiza','Chitungwiza',-18.00000079,31.10000321,331071,'Zimbabwe','ZW','ZWE','Harare');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Harare','Harare',-17.81778969,31.04470943,1557406.5,'Zimbabwe','ZW','ZWE','Harare');
INSERT INTO world_cities_table(city,city_ascii,lat,lng,pop,country,iso2,iso3,province) VALUES ('Bulawayo','Bulawayo',-20.16999754,28.58000199,697096,'Zimbabwe','ZW','ZWE','Bulawayo');