Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
328 lines (325 sloc) 54 KB
INSERT INTO state(name, shortcut, capital, population) VALUES ('Alabama', 'AL', 'Montgomery', 4802740);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Alaska', 'AK', 'Juneau', 722718);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Arizona', 'AZ', 'Phoenix', 6482505);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Arkansas', 'AR', 'Little Rock', 2937979);
INSERT INTO state(name, shortcut, capital, population) VALUES ('California', 'CA', 'Sacramento', 37691912);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Colorado', 'CO', 'Denver', 5116796);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Connecticut', 'CT', 'Hartford', 3580709);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Delaware', 'DE', 'Dover', 907135);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Florida', 'FL', 'Tallahassee', 19057542);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Georgia', 'GA', 'Atlanta', 9815210);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Hawaii', 'HI', 'Honolulu', 1374810);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Idaho', 'ID', 'Boise', 1584985);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Illinois', 'IL', 'Springfield', 12869257);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Indiana', 'IN', 'Indianapolis', 6516922);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Iowa', 'IA', 'Des Moines', 3062309);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Kansas', 'KS', 'Topeka', 2871238);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Kentucky', 'KY', 'Frankfort', 4369356);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Louisiana', 'LA', 'Baton Rouge', 4574836);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Maine', 'ME', 'Augusta', 1328188);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Maryland', 'MD', 'Annapolis', 5828289);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Massachusetts', 'MA', 'Boston', 6587536);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Michigan', 'MI', 'Lansing', 9876187);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Minnesota', 'MN', 'Saint Paul', 5344861);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Mississippi', 'MS', 'Jackson', 2978512);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Missouri', 'MO', 'Jefferson City', 6010688);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Montana', 'MT', 'Helena', 998199);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Nebraska', 'NE', 'Lincoln', 1842641);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Nevada', 'NV', 'Carson City', 2723322);
INSERT INTO state(name, shortcut, capital, population) VALUES ('New Hampshire', 'NH', 'Concord', 1318194);
INSERT INTO state(name, shortcut, capital, population) VALUES ('New Jersey', 'NJ', 'Trenton', 8821155);
INSERT INTO state(name, shortcut, capital, population) VALUES ('New Mexico', 'NM', 'Santa Fe', 2082224);
INSERT INTO state(name, shortcut, capital, population) VALUES ('New York', 'NY', 'Albany', 19465197);
INSERT INTO state(name, shortcut, capital, population) VALUES ('North Carolina', 'NC', 'Raleigh', 9656401);
INSERT INTO state(name, shortcut, capital, population) VALUES ('North Dakota', 'ND', 'Bismarck', 683932);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Ohio', 'OH', 'Columbus', 11544951);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Oklahoma', 'OK', 'Oklahoma City', 3791508);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Oregon', 'OR', 'Salem', 3871859);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Pennsylvania', 'PA', 'Harrisburg', 12742886);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Rhode Island', 'RI', 'Providence', 1051302);
INSERT INTO state(name, shortcut, capital, population) VALUES ('South Carolina', 'SC', 'Columbia', 4679230);
INSERT INTO state(name, shortcut, capital, population) VALUES ('South Dakota', 'SD', 'Pierre', 824082);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Tennessee', 'TN', 'Nashville', 6403353);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Texas', 'TX', 'Austin', 25674681);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Utah', 'UT', 'Salt Lake City', 2817222);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Vermont', 'VT', 'Montpelier', 626431);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Virginia', 'VA', 'Richmond', 8096604);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Washington', 'WA', 'Olympia', 6830038);
INSERT INTO state(name, shortcut, capital, population) VALUES ('West Virginia', 'WV', 'Charleston', 1855364);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Wisconsin', 'WI', 'Madison', 5711767);
INSERT INTO state(name, shortcut, capital, population) VALUES ('Wyoming', 'WY', 'Cheyenne', 568158);
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('New York', 1, 8175133, 302.60, 27016.30 , (SELECT id FROM state WHERE name = 'New York'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Los Angeles', 2, 3792621, 468.70, 8091.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Chicago', 3, 2695598, 227.60, 11843.60 , (SELECT id FROM state WHERE name = 'Illinois'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Houston', 4, 2099451, 599.60, 3501.40 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Philadelphia', 5, 1526006, 134.10, 11379.60 , (SELECT id FROM state WHERE name = 'Pennsylvania'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Phoenix', 6, 1445632, 516.70, 2797.80 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('San Antonio', 7, 1327407, 460.90, 2880.00 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('San Diego', 8, 1307402, 325.20, 4020.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Dallas', 9, 1197816, 340.50, 3517.80 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('San Jose', 10, 945942, 176.50, 5359.40 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Jacksonville', 11, 821784, 747.00, 1100.10 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Indianapolis', 12, 820445, 361.40, 2270.20 , (SELECT id FROM state WHERE name = 'Indiana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('San Francisco', 13, 805235, 46.90, 17169.20 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Austin', 14, 79039, 297.90, 2653.20 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Columbus', 15, 787033, 217.20, 3623.50 , (SELECT id FROM state WHERE name = 'Ohio'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fort Worth', 16, 741206, 339.80, 2181.30 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Charlotte', 17, 731424, 297.70, 2456.90 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Detroit', 18, 713777, 138.80, 5142.50 , (SELECT id FROM state WHERE name = 'Michigan'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('El Paso', 19, 649121, 255.20, 2543.60 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Memphis', 20, 646889, 315.10, 2053.00 , (SELECT id FROM state WHERE name = 'Tennessee'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Baltimore', 21, 620961, 80.90, 7675.70 , (SELECT id FROM state WHERE name = 'Maryland'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Boston', 22, 617594, 48.30, 12786.60 , (SELECT id FROM state WHERE name = 'Massachusetts'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Seattle', 23, 60866, 83.90, 7254.60 , (SELECT id FROM state WHERE name = 'Washington'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Washington', 24, 601723, 61.00, 9864.30 , (SELECT id FROM state WHERE name = 'District of Columbia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Nashville ', 25, 601222, 475.10, 1265.50 , (SELECT id FROM state WHERE name = 'Tennessee'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Denver', 26, 600158, 153.00, 3922.60 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Louisville ', 27, 597337, 325.20, 1836.80 , (SELECT id FROM state WHERE name = 'Kentucky'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Milwaukee', 28, 594833, 96.10, 6189.70 , (SELECT id FROM state WHERE name = 'Wisconsin'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Portland', 29, 583776, 134.30, 4346.80 , (SELECT id FROM state WHERE name = 'Oregon'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Las Vegas', 30, 583756, 135.80, 4298.60 , (SELECT id FROM state WHERE name = 'Nevada'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Oklahoma City', 31, 579999, 606.40, 956.50 , (SELECT id FROM state WHERE name = 'Oklahoma'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Albuquerque', 32, 545852, 187.70, 2908.10 , (SELECT id FROM state WHERE name = 'New Mexico'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Tucson', 33, 520116, 226.70, 2294.30 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fresno', 34, 494665, 112.00, 4416.70 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Sacramento', 35, 466488, 97.90, 4764.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Long Beach', 36, 462257, 50.30, 9190.00 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Kansas City', 37, 459787, 315.00, 1459.60 , (SELECT id FROM state WHERE name = 'Missouri'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Mesa', 38, 439041, 136.50, 3216.40 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Virginia Beach ', 39, 437994, 249.00, 1759.00 , (SELECT id FROM state WHERE name = 'Virginia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Atlanta', 40, 420003, 133.20, 3153.20 , (SELECT id FROM state WHERE name = 'Georgia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Colorado Springs', 41, 416427, 194.50, 2141.00 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Omaha', 42, 408958, 127.10, 3217.60 , (SELECT id FROM state WHERE name = 'Nebraska'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Raleigh', 43, 403892, 142.90, 2826.40 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Miami', 44, 399457, 35.90, 11126.90 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Cleveland', 45, 396815, 77.70, 5107.00 , (SELECT id FROM state WHERE name = 'Ohio'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Tulsa', 46, 391906, 196.80, 1991.40 , (SELECT id FROM state WHERE name = 'Oklahoma'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Oakland', 47, 390724, 55.80, 7002.20 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Minneapolis', 48, 382578, 54.00, 7084.80 , (SELECT id FROM state WHERE name = 'Minnesota'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Wichita', 49, 382368, 159.30, 2400.30 , (SELECT id FROM state WHERE name = 'Kansas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Arlington', 50, 365438, 95.90, 3810.60 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Bakersfield', 51, 347483, 142.20, 2443.60 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('New Orleans', 52, 343829, 169.40, 2029.70 , (SELECT id FROM state WHERE name = 'Louisiana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Honolulu ', 53, 337256, 60.50, 5574.50 , (SELECT id FROM state WHERE name = 'Hawaii'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Anaheim', 54, 336265, 49.80, 6752.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Tampa', 55, 335709, 113.40, 2960.40 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Aurora', 56, 325078, 154.70, 2101.30 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Santa Ana', 57, 324528, 27.30, 11887.50 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Saint Louis ', 58, 319294, 61.90, 5158.20 , (SELECT id FROM state WHERE name = 'Missouri'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Pittsburgh', 59, 305704, 55.40, 5518.10 , (SELECT id FROM state WHERE name = 'Pennsylvania'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Corpus Christi', 60, 305215, 160.60, 1900.50 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Riverside', 61, 303871, 81.10, 3746.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Cincinnati', 62, 296943, 77.90, 3811.80 , (SELECT id FROM state WHERE name = 'Ohio'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Lexington', 63, 295803, 283.60, 1043.00 , (SELECT id FROM state WHERE name = 'Kentucky'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Anchorage', 64, 291826, 1704.70, 171.20 , (SELECT id FROM state WHERE name = 'Alaska'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Stockton', 65, 291707, 61.70, 4727.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Toledo', 66, 287208, 80.70, 3559.00 , (SELECT id FROM state WHERE name = 'Ohio'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Saint Paul', 67, 285068, 52.00, 5482.10 , (SELECT id FROM state WHERE name = 'Minnesota'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Newark', 68, 27714, 24.20, 11452.10 , (SELECT id FROM state WHERE name = 'New Jersey'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Greensboro', 69, 269666, 126.50, 2131.70 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Buffalo', 70, 26131, 40.40, 6468.10 , (SELECT id FROM state WHERE name = 'New York'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Plano', 71, 259841, 71.60, 3629.10 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Lincoln', 72, 258379, 89.10, 2899.90 , (SELECT id FROM state WHERE name = 'Nebraska'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Henderson', 73, 257729, 107.70, 2393.00 , (SELECT id FROM state WHERE name = 'Nevada'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fort Wayne', 74, 253691, 110.60, 2293.80 , (SELECT id FROM state WHERE name = 'Indiana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Jersey City', 75, 247597, 14.80, 16729.50 , (SELECT id FROM state WHERE name = 'New Jersey'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Saint Petersburg', 76, 244769, 61.70, 3967.10 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Chula Vista', 77, 243916, 49.60, 4917.70 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Norfolk ', 78, 242803, 54.10, 4488.00 , (SELECT id FROM state WHERE name = 'Virginia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Orlando', 79, 2383, 102.40, 2327.10 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Chandler', 80, 236123, 64.40, 3666.50 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Laredo', 81, 236091, 88.90, 2655.70 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Madison', 82, 233209, 76.80, 3036.60 , (SELECT id FROM state WHERE name = 'Wisconsin'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Winston-Salem', 83, 229617, 132.40, 1734.30 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Lubbock', 84, 229573, 122.40, 1875.60 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Baton Rouge', 85, 229493, 76.90, 2984.30 , (SELECT id FROM state WHERE name = 'Louisiana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Durham', 86, 22833, 107.40, 2126.00 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Garland', 87, 226876, 57.10, 3973.30 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Glendale', 88, 226721, 60.00, 3778.70 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Reno', 89, 225221, 103.00, 2186.60 , (SELECT id FROM state WHERE name = 'Nevada'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Hialeah', 90, 224669, 21.50, 10449.70 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Chesapeake ', 91, 222209, 340.80, 652.00 , (SELECT id FROM state WHERE name = 'Virginia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Scottsdale', 92, 217385, 183.90, 1182.10 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('North Las Vegas', 93, 216961, 101.30, 2141.80 , (SELECT id FROM state WHERE name = 'Nevada'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Irving', 94, 21629, 67.00, 3228.20 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fremont', 95, 214089, 77.50, 2762.40 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Irvine', 96, 212375, 66.10, 3212.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Birmingham', 97, 212237, 146.10, 1452.70 , (SELECT id FROM state WHERE name = 'Alabama'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Rochester', 98, 210565, 35.80, 5881.70 , (SELECT id FROM state WHERE name = 'New York'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('San Bernardino', 99, 209924, 59.20, 3546.00 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Spokane', 100, 208916, 59.20, 3529.00 , (SELECT id FROM state WHERE name = 'Washington'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Gilbert', 101, 208453, 68.00, 3065.50 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Arlington ', 102, 207627, 26.00, 7985.70 , (SELECT id FROM state WHERE name = 'Virginia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Montgomery', 103, 205764, 159.60, 1289.20 , (SELECT id FROM state WHERE name = 'Alabama'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Boise', 104, 205671, 79.40, 2590.30 , (SELECT id FROM state WHERE name = 'Idaho'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Richmond ', 105, 204214, 59.80, 3414.90 , (SELECT id FROM state WHERE name = 'Virginia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Des Moines', 106, 203433, 80.90, 2514.60 , (SELECT id FROM state WHERE name = 'Iowa'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Modesto', 107, 201165, 36.90, 5451.60 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fayetteville', 108, 200654, 145.80, 1376.20 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Shreveport', 109, 199311, 105.40, 1891.00 , (SELECT id FROM state WHERE name = 'Louisiana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Akron', 110, 19911, 62.00, 3211.50 , (SELECT id FROM state WHERE name = 'Ohio'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Tacoma', 111, 198397, 49.70, 3991.90 , (SELECT id FROM state WHERE name = 'Washington'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Aurora', 112, 197899, 44.90, 4407.60 , (SELECT id FROM state WHERE name = 'Illinois'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Oxnard', 112, 197899, 26.90, 7356.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fontana', 114, 196069, 42.40, 4624.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Yonkers', 115, 195976, 18.00, 10887.60 , (SELECT id FROM state WHERE name = 'New York'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Augusta ', 116, 195844, 302.50, 647.40 , (SELECT id FROM state WHERE name = 'Georgia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Mobile', 117, 195111, 139.10, 1402.70 , (SELECT id FROM state WHERE name = 'Alabama'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Little Rock', 118, 193524, 119.20, 1623.50 , (SELECT id FROM state WHERE name = 'Arkansas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Moreno Valley', 119, 193365, 51.30, 3769.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Glendale', 120, 191719, 30.50, 6285.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Amarillo', 121, 190695, 99.50, 1916.50 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Huntington Beach', 122, 189992, 26.70, 7115.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Columbus', 123, 189885, 216.40, 877.50 , (SELECT id FROM state WHERE name = 'Georgia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Grand Rapids', 124, 18804, 44.40, 4235.10 , (SELECT id FROM state WHERE name = 'Michigan'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Salt Lake City', 125, 18644, 111.10, 1678.10 , (SELECT id FROM state WHERE name = 'Utah'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Tallahassee', 126, 181376, 100.20, 1810.10 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Worcester', 127, 181045, 37.40, 4840.80 , (SELECT id FROM state WHERE name = 'Massachusetts'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Newport News ', 128, 180719, 68.70, 2630.60 , (SELECT id FROM state WHERE name = 'Virginia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Huntsville', 129, 180105, 209.10, 861.30 , (SELECT id FROM state WHERE name = 'Alabama'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Knoxville', 130, 178874, 98.50, 1816.00 , (SELECT id FROM state WHERE name = 'Tennessee'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Providence', 131, 178042, 18.40, 9676.20 , (SELECT id FROM state WHERE name = 'Rhode Island'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Santa Clarita', 132, 17632, 52.70, 3345.70 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Grand Prairie', 133, 175396, 72.10, 2432.70 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Brownsville', 134, 175023, 132.30, 1322.90 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Jackson', 135, 173514, 111.00, 1563.20 , (SELECT id FROM state WHERE name = 'Mississippi'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Overland Park', 136, 173372, 74.80, 2317.80 , (SELECT id FROM state WHERE name = 'Kansas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Garden Grove', 137, 170883, 17.90, 9546.50 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Santa Rosa', 138, 167815, 41.30, 4063.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Chattanooga', 139, 167674, 137.20, 1222.10 , (SELECT id FROM state WHERE name = 'Tennessee'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Oceanside', 140, 167086, 41.20, 4055.50 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fort Lauderdale', 141, 165521, 34.80, 4756.40 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Rancho Cucamonga', 142, 165269, 39.90, 4142.10 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Port Saint Lucie', 143, 164603, 114.00, 1443.90 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Ontario', 144, 163924, 49.90, 3285.10 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Vancouver', 145, 161791, 46.50, 3479.40 , (SELECT id FROM state WHERE name = 'Washington'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Tempe', 146, 161719, 39.90, 4053.10 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Springfield', 147, 159498, 81.70, 1952.20 , (SELECT id FROM state WHERE name = 'Missouri'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Lancaster', 148, 156633, 94.30, 1661.00 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Eugene', 149, 156185, 43.70, 3574.00 , (SELECT id FROM state WHERE name = 'Oregon'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Pembroke Pines', 150, 15475, 33.10, 4675.20 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Salem', 151, 154637, 47.90, 3228.30 , (SELECT id FROM state WHERE name = 'Oregon'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Cape Coral', 152, 154305, 105.70, 1459.80 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Peoria', 153, 154065, 174.40, 883.40 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Sioux Falls', 154, 153888, 73.00, 2108.10 , (SELECT id FROM state WHERE name = 'South Dakota'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Springfield', 155, 15306, 31.90, 4798.10 , (SELECT id FROM state WHERE name = 'Massachusetts'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Elk Grove', 156, 153015, 42.20, 3625.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Rockford', 157, 152871, 61.10, 2502.00 , (SELECT id FROM state WHERE name = 'Illinois'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Palmdale', 158, 15275, 106.00, 1441.00 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Corona', 159, 152374, 38.80, 3927.20 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Salinas', 160, 150441, 23.20, 6484.50 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Pomona', 161, 149058, 23.00, 6480.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Pasadena', 162, 149043, 42.80, 3482.30 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Joliet', 163, 147433, 62.10, 2374.10 , (SELECT id FROM state WHERE name = 'Illinois'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Paterson', 164, 146199, 8.40, 17404.60 , (SELECT id FROM state WHERE name = 'New Jersey'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Kansas City', 165, 145786, 124.80, 1168.20 , (SELECT id FROM state WHERE name = 'Kansas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Torrance', 166, 145438, 20.50, 7094.50 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Syracuse', 167, 14517, 25.00, 5806.80 , (SELECT id FROM state WHERE name = 'New York'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Bridgeport', 168, 144229, 16.00, 9014.30 , (SELECT id FROM state WHERE name = 'Connecticut'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Hayward', 169, 144186, 45.30, 3182.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fort Collins', 170, 143986, 54.30, 2651.70 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Escondido', 171, 143911, 36.80, 3910.60 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Lakewood', 172, 14298, 42.90, 3332.90 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Naperville', 173, 141853, 38.80, 3656.00 , (SELECT id FROM state WHERE name = 'Illinois'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Dayton', 174, 141527, 55.70, 2540.90 , (SELECT id FROM state WHERE name = 'Ohio'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Hollywood', 175, 140768, 27.40, 5137.50 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Sunnyvale', 176, 140081, 22.00, 6367.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Alexandria ', 177, 139966, 15.00, 9331.10 , (SELECT id FROM state WHERE name = 'Virginia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Mesquite', 178, 139824, 46.00, 3039.70 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Hampton ', 179, 137436, 51.40, 2673.90 , (SELECT id FROM state WHERE name = 'Virginia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Pasadena', 180, 137122, 23.00, 5961.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Orange', 181, 136416, 24.80, 5500.60 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Savannah', 182, 136286, 103.20, 1320.60 , (SELECT id FROM state WHERE name = 'Georgia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Cary', 183, 135234, 54.30, 2490.50 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fullerton', 184, 135161, 22.40, 6034.00 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Warren', 185, 134056, 34.40, 3897.00 , (SELECT id FROM state WHERE name = 'Michigan'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Clarksville', 186, 132929, 97.60, 1362.00 , (SELECT id FROM state WHERE name = 'Tennessee'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('McKinney', 187, 131117, 62.20, 2108.00 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('McAllen', 188, 129877, 48.30, 2689.00 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('New Haven', 189, 129779, 18.70, 6940.10 , (SELECT id FROM state WHERE name = 'Connecticut'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Sterling Heights', 190, 129699, 36.50, 3553.40 , (SELECT id FROM state WHERE name = 'Michigan'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('West Valley City', 191, 12948, 35.60, 3637.10 , (SELECT id FROM state WHERE name = 'Utah'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Columbia', 192, 129272, 132.20, 977.90 , (SELECT id FROM state WHERE name = 'South Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Killeen', 193, 127921, 53.60, 2386.60 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Topeka', 194, 127473, 60.20, 2117.50 , (SELECT id FROM state WHERE name = 'Kansas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Thousand Oaks', 195, 126683, 55.00, 2303.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Cedar Rapids', 196, 126326, 70.80, 1784.30 , (SELECT id FROM state WHERE name = 'Iowa'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Olathe', 197, 125872, 59.70, 2108.40 , (SELECT id FROM state WHERE name = 'Kansas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Elizabeth', 198, 124969, 12.30, 10160.10 , (SELECT id FROM state WHERE name = 'New Jersey'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Waco', 199, 124805, 89.00, 1402.30 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Hartford', 200, 124775, 17.40, 7171.00 , (SELECT id FROM state WHERE name = 'Connecticut'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Visalia', 201, 124442, 36.20, 3437.60 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Gainesville', 202, 124354, 61.30, 2028.60 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Simi Valley', 203, 124237, 41.50, 2993.70 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Stamford', 204, 122643, 37.60, 3261.80 , (SELECT id FROM state WHERE name = 'Connecticut'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Bellevue', 205, 122363, 32.00, 3823.80 , (SELECT id FROM state WHERE name = 'Washington'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Concord', 206, 122067, 30.50, 4002.20 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Miramar', 207, 122041, 29.50, 4137.00 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Coral Springs', 208, 121096, 23.80, 5088.10 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Lafayette', 209, 120623, 49.20, 2451.70 , (SELECT id FROM state WHERE name = 'Louisiana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Charleston', 210, 120083, 109.00, 1101.70 , (SELECT id FROM state WHERE name = 'South Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Carrollton', 211, 119097, 36.30, 3280.90 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Roseville', 212, 118788, 36.20, 3281.40 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Thornton', 213, 118772, 34.80, 3413.00 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Beaumont', 214, 118296, 82.80, 1428.70 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Allentown', 215, 118032, 17.50, 6744.70 , (SELECT id FROM state WHERE name = 'Pennsylvania'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Surprise', 216, 117517, 105.70, 1111.80 , (SELECT id FROM state WHERE name = 'Arizona'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Evansville', 217, 117429, 44.20, 2656.80 , (SELECT id FROM state WHERE name = 'Indiana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Abilene', 218, 117063, 106.80, 1096.10 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Frisco', 219, 116989, 61.80, 1893.00 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Independence', 220, 11683, 77.60, 1505.50 , (SELECT id FROM state WHERE name = 'Missouri'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Santa Clara', 221, 116468, 18.40, 6329.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Springfield', 222, 11625, 59.50, 1953.80 , (SELECT id FROM state WHERE name = 'Illinois'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Vallejo', 223, 115942, 30.70, 3776.60 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Victorville', 224, 115903, 73.20, 1583.40 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Athens ', 225, 115452, 116.40, 991.90 , (SELECT id FROM state WHERE name = 'Georgia'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Peoria', 226, 115007, 48.00, 2396.00 , (SELECT id FROM state WHERE name = 'Illinois'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Lansing', 227, 114297, 36.00, 3174.90 , (SELECT id FROM state WHERE name = 'Michigan'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Ann Arbor', 228, 113934, 27.80, 4098.30 , (SELECT id FROM state WHERE name = 'Michigan'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('El Monte', 229, 113475, 9.60, 11820.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Denton', 230, 113383, 88.00, 1288.40 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Berkeley', 231, 11258, 10.50, 10721.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Provo', 232, 112488, 41.70, 2697.60 , (SELECT id FROM state WHERE name = 'Utah'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Downey', 233, 111772, 12.40, 9013.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Midland', 234, 111147, 72.10, 1541.60 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Norman', 235, 110925, 178.80, 620.40 , (SELECT id FROM state WHERE name = 'Oklahoma'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Waterbury', 236, 110366, 28.50, 3872.50 , (SELECT id FROM state WHERE name = 'Connecticut'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Costa Mesa', 237, 10996, 15.70, 7003.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Inglewood', 238, 109673, 9.10, 12052.00 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Manchester', 239, 109565, 33.10, 3310.10 , (SELECT id FROM state WHERE name = 'New Hampshire'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Murfreesboro', 240, 108755, 55.30, 1966.60 , (SELECT id FROM state WHERE name = 'Tennessee'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Columbia', 241, 1085, 63.10, 1719.50 , (SELECT id FROM state WHERE name = 'Missouri'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Elgin', 242, 108188, 37.20, 2908.30 , (SELECT id FROM state WHERE name = 'Illinois'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Clearwater', 243, 107685, 25.60, 4206.40 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Miami Gardens', 244, 107167, 18.20, 5888.30 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Rochester', 245, 106769, 54.60, 1955.50 , (SELECT id FROM state WHERE name = 'Minnesota'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Pueblo', 246, 106595, 53.60, 1988.70 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Lowell', 247, 106519, 13.60, 7832.30 , (SELECT id FROM state WHERE name = 'Massachusetts'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Wilmington', 248, 106476, 51.50, 2067.50 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Arvada', 249, 106433, 35.10, 3032.30 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('San Buenaventura (Ventura)', 249, 106433, 21.70, 4904.70 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Westminster', 251, 106114, 31.60, 3358.00 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('West Covina', 252, 106098, 16.00, 6631.10 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Gresham', 253, 105594, 23.20, 4551.50 , (SELECT id FROM state WHERE name = 'Oregon'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fargo', 254, 105549, 48.80, 2162.90 , (SELECT id FROM state WHERE name = 'North Dakota'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Norwalk', 254, 105549, 9.70, 10881.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Carlsbad', 256, 105328, 37.70, 2793.80 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Fairfield', 257, 105321, 37.40, 2816.10 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Cambridge', 258, 105162, 6.40, 16431.60 , (SELECT id FROM state WHERE name = 'Massachusetts'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Wichita Falls', 259, 104553, 72.10, 1450.10 , (SELECT id FROM state WHERE name = 'Texas'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('High Point', 260, 104371, 53.80, 1940.00 , (SELECT id FROM state WHERE name = 'North Carolina'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Billings', 261, 10417, 43.40, 2400.20 , (SELECT id FROM state WHERE name = 'Montana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Green Bay', 262, 104057, 45.50, 2287.00 , (SELECT id FROM state WHERE name = 'Wisconsin'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('West Jordan', 263, 103712, 32.50, 3191.10 , (SELECT id FROM state WHERE name = 'Utah'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Richmond', 264, 103701, 30.10, 3445.20 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Murrieta', 265, 103466, 33.60, 3079.30 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Burbank', 266, 10334, 17.30, 5973.40 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Palm Bay', 267, 10319, 65.70, 1570.60 , (SELECT id FROM state WHERE name = 'Florida'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Everett', 268, 103019, 33.40, 3084.40 , (SELECT id FROM state WHERE name = 'Washington'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Flint', 269, 102434, 33.40, 3066.90 , (SELECT id FROM state WHERE name = 'Michigan'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Antioch', 270, 102372, 28.30, 3617.40 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Erie', 271, 101786, 19.10, 5329.10 , (SELECT id FROM state WHERE name = 'Pennsylvania'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('South Bend', 272, 101168, 41.50, 2437.80 , (SELECT id FROM state WHERE name = 'Indiana'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Daly City', 273, 101123, 7.70, 13132.90 , (SELECT id FROM state WHERE name = 'California'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Centennial', 274, 100377, 28.70, 3497.50 , (SELECT id FROM state WHERE name = 'Colorado'));
INSERT INTO city(name, rank, population, land_area, population_density, state_id) VALUES ('Temecula', 275, 100097, 30.20, 3314.50 , (SELECT id FROM state WHERE name = 'California'));
You can’t perform that action at this time.