-
-
Save dgraham/8fce9f6871fc6ef075b6 to your computer and use it in GitHub Desktop.
Assignment 3—SQL script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
drop table committees; | |
drop table senators; | |
drop table counties; | |
drop table states; | |
create table states (statecode char(2) primary key, population_2010 integer, population_2000 integer, population_1950 integer, population_1900 integer, landarea float, name char(20), admitted_to_union date); | |
create table counties(name char(30), statecode char(2) references states(statecode), population_1950 integer, population_2010 integer); | |
create table senators(statecode char(2) references states(statecode), name char(40) primary key, affiliation char(1), took_office integer, born integer); | |
create table committees(id char(5) primary key, parent_committee char(5) references committees(id), name char(200), chairman char(40) references senators(name), ranking_member char(40) references senators(name)); | |
insert into states values ('AL', 4779736, 4447100, 3061743, 1828697, 52419.02, 'Alabama', str_to_date('12-14-1819', '%m-%d-%Y')); | |
insert into states values ('AK', 710231, 626932, 128643, 63592, 663267.26, 'Alaska', str_to_date('01-03-1959', '%m-%d-%Y')); | |
insert into states values ('AZ', 6329017, 5130632, 749587, 122931, 113998.30, 'Arizona', str_to_date('02-14-1912', '%m-%d-%Y')); | |
insert into states values ('AR', 2915918, 2673400, 1909511, 1311564, 53178.62, 'Arkansas', str_to_date('06-15-1836', '%m-%d-%Y')); | |
insert into states values ('CA', 37253956, 33871648, 10586223, 1485053, 163695.57, 'California', str_to_date('09-09-1850', '%m-%d-%Y')); | |
insert into states values ('CO', 5029196, 4301261, 1325089, 539700, 104093.57, 'Colorado', str_to_date('08-01-1876', '%m-%d-%Y')); | |
insert into states values ('CT', 3518288, 3405565, 2007280, 908420, 5543.33, 'Connecticut', str_to_date('01-09-1788', '%m-%d-%Y')); | |
insert into states values ('DE', 897934, 783600, 318085, 184735, 2489.27, 'Delaware', str_to_date('12-07-1787', '%m-%d-%Y')); | |
insert into states values ('FL', 18801310, 15982378, 2771305, 528542, 65754.59, 'Florida', str_to_date('03-03-1845', '%m-%d-%Y')); | |
insert into states values ('GA', 9687653, 8186453, 3444578, 2216331, 59424.77, 'Georgia', str_to_date('01-02-1788', '%m-%d-%Y')); | |
insert into states values ('HI', 1360301, 1211537, 499794, 154001, 10930.98, 'Hawaii', str_to_date('08-21-1959', '%m-%d-%Y')); | |
insert into states values ('ID', 1567582, 1293953, 588637, 161772, 83570.08, 'Idaho', str_to_date('07-03-1890', '%m-%d-%Y')); | |
insert into states values ('IL', 12830632, 12419293, 8712176, 4821550, 57914.38, 'Illinois', str_to_date('12-03-1818', '%m-%d-%Y')); | |
insert into states values ('IN', 6483802, 6080485, 3934224, 2516462, 36417.73, 'Indiana', str_to_date('12-11-1816', '%m-%d-%Y')); | |
insert into states values ('IA', 3046355, 2926324, 2621073, 2231853, 56271.55, 'Iowa', str_to_date('12-28-1846', '%m-%d-%Y')); | |
insert into states values ('KS', 2853118, 2688418, 1905299, 1470495, 82276.84, 'Kansas', str_to_date('01-29-1861', '%m-%d-%Y')); | |
insert into states values ('KY', 4339367, 4041769, 2944806, 2147174, 40409.02, 'Kentucky', str_to_date('06-01-1792', '%m-%d-%Y')); | |
insert into states values ('LA', 4533372, 4468976, 2683516, 1381625, 51839.70, 'Louisiana', str_to_date('04-30-1812', '%m-%d-%Y')); | |
insert into states values ('ME', 1328361, 1274923, 913774, 694466, 35384.65, 'Maine', str_to_date('03-15-1820', '%m-%d-%Y')); | |
insert into states values ('MD', 5773552, 5296486, 2343001, 1188044, 12406.68, 'Maryland', str_to_date('04-28-1788', '%m-%d-%Y')); | |
insert into states values ('MA', 6547629, 6349097, 4690514, 2805346, 10554.57, 'Massachusetts', str_to_date('02-06-1788', '%m-%d-%Y')); | |
insert into states values ('MI', 9883640, 9938444, 6371766, 2420982, 96716.11, 'Michigan', str_to_date('01-26-1837', '%m-%d-%Y')); | |
insert into states values ('MN', 5303925, 4919479, 2982483, 1751394, 86938.87, 'Minnesota', str_to_date('05-11-1858', '%m-%d-%Y')); | |
insert into states values ('MS', 2967297, 2844658, 2178914, 1551270, 48430.19, 'Mississippi', str_to_date('12-10-1817', '%m-%d-%Y')); | |
insert into states values ('MO', 5988927, 5595211, 3954653, 3106665, 69704.31, 'Missouri', str_to_date('08-10-1821', '%m-%d-%Y')); | |
insert into states values ('MT', 989415, 902195, 591024, 243329, 147042.40, 'Montana', str_to_date('11-08-1889', '%m-%d-%Y')); | |
insert into states values ('NE', 1826341, 1711263, 1325510, 1066300, 77353.73, 'Nebraska', str_to_date('03-01-1867', '%m-%d-%Y')); | |
insert into states values ('NV', 2700551, 1998257, 160083, 42335, 110560.71, 'Nevada', str_to_date('10-31-1864', '%m-%d-%Y')); | |
insert into states values ('NH', 1316470, 1235786, 533242, 411588, 9349.94, 'New Hampshire', str_to_date('06-21-1788', '%m-%d-%Y')); | |
insert into states values ('NJ', 8791894, 8414350, 4835329, 1883669, 8721.30, 'New Jersey', str_to_date('12-18-1787', '%m-%d-%Y')); | |
insert into states values ('NM', 2059179, 1819046, 681187, 195310, 121589.48, 'New Mexico', str_to_date('01-06-1912', '%m-%d-%Y')); | |
insert into states values ('NY', 19378102, 18976457, 14830192, 7268894, 54556.00, 'New York', str_to_date('07-26-1788', '%m-%d-%Y')); | |
insert into states values ('NC', 9535483, 8049313, 4061929, 1893810, 53818.51, 'North Carolina', str_to_date('11-21-1789', '%m-%d-%Y')); | |
insert into states values ('ND', 672591, 642200, 619636, 319146, 70699.79, 'North Dakota', str_to_date('11-02-1889', '%m-%d-%Y')); | |
insert into states values ('OH', 11536504, 11353140, 7946627, 4157545, 44824.90, 'Ohio', str_to_date('03-01-1803', '%m-%d-%Y')); | |
insert into states values ('OK', 3751351, 3450654, 2233351, 7903912, 69898.19, 'Oklahoma', str_to_date('11-16-1907', '%m-%d-%Y')); | |
insert into states values ('OR', 3831074, 3421399, 1521341, 413536, 98380.64, 'Oregon', str_to_date('02-14-1859', '%m-%d-%Y')); | |
insert into states values ('PA', 12702379, 12281054, 10498012, 6302115, 46055.24, 'Pennsylvania', str_to_date('12-12-1787', '%m-%d-%Y')); | |
insert into states values ('RI', 1052567, 1048319, 791896, 428556, 1545.05, 'Rhode Island', str_to_date('05-29-1790', '%m-%d-%Y')); | |
insert into states values ('SC', 4625364, 4012012, 2117027, 1340316, 32020.20, 'South Carolina', str_to_date('05-23-1788', '%m-%d-%Y')); | |
insert into states values ('SD', 814180, 754844, 652740, 401570, 77116.49, 'South Dakota', str_to_date('11-02-1889', '%m-%d-%Y')); | |
insert into states values ('TN', 6346105, 5689283, 3291718, 2020616, 42143.27, 'Tennessee', str_to_date('06-01-1796', '%m-%d-%Y')); | |
insert into states values ('TX', 25145561, 20851820, 7711194, 3048710, 268580.82, 'Texas', str_to_date('12-29-1845', '%m-%d-%Y')); | |
insert into states values ('UT', 2763885, 2233169, 688862, 276749, 84898.83, 'Utah', str_to_date('01-04-1896', '%m-%d-%Y')); | |
insert into states values ('VT', 625741, 608827, 377747, 343641, 9614.26, 'Vermont', str_to_date('03-04-1791', '%m-%d-%Y')); | |
insert into states values ('VA', 8001024, 7078515, 3318680, 1854184, 42774.20, 'Virginia', str_to_date('06-25-1788', '%m-%d-%Y')); | |
insert into states values ('WA', 6724540, 5894121, 2378963, 518103, 71299.64, 'Washington', str_to_date('11-11-1889', '%m-%d-%Y')); | |
insert into states values ('WV', 1852994, 1808344, 2005552, 958800, 24229.76, 'West Virginia', str_to_date('06-20-1863', '%m-%d-%Y')); | |
insert into states values ('WI', 5686986, 5363675, 3434575, 2069042, 65497.82, 'Wisconsin', str_to_date('05-26-1848', '%m-%d-%Y')); | |
insert into states values ('WY', 563626, 493782, 290529, 92531, 97813.56, 'Wyoming', str_to_date('07-10-1890', '%m-%d-%Y')); | |
insert into senators values('AL', 'Jeff Sessions', 'R', 1997, 1946); | |
insert into senators values('AL', 'Richard Shelby', 'R', 1987, 1934); | |
insert into senators values('AK', 'Mark Begich', 'D', 2009, 1962); | |
insert into senators values('AK', 'Lisa Murkowski', 'R', 2002, 1957); | |
insert into senators values('AZ', 'John McCain', 'R', 1987, 1936); | |
insert into senators values('AZ', 'Jon Kyl', 'R', 1995, 1942); | |
insert into senators values('AR', 'John Boozman', 'R', 2011, 1950); | |
insert into senators values('AR', 'Mark Pryor', 'D', 2003, 1963); | |
insert into senators values('CA', 'Barbara Boxer', 'D', 1993, 1940); | |
insert into senators values('CA', 'Dianne Feinstein', 'D', 1992, 1933); | |
insert into senators values('CO', 'Mark Udall', 'D', 2009, 1950); | |
insert into senators values('CO', 'Michael Bennet', 'D', 2009, 1964); | |
insert into senators values('CT', 'Richard Blumenthal', 'D', 2011, 1946); | |
insert into senators values('CT', 'Joe Lieberman', 'D', 1989, 1942); | |
insert into senators values('DE', 'Thomas Carper', 'D', 2001, 1947); | |
insert into senators values('DE', 'Chris Coons', 'D', 2010, 1963); | |
insert into senators values('FL', 'Bill Nelson', 'D', 2001, 1942); | |
insert into senators values('FL', 'Marco Rubio', 'R', 2011, 1971); | |
insert into senators values('GA', 'Saxby Chambliss', 'R', 2003, 1943); | |
insert into senators values('GA', 'Johnny Isakson', 'R', 2005, 1944); | |
insert into senators values('HI', 'Daniel Akaka', 'D', 1990, 1924); | |
insert into senators values('HI', 'Daniel Inouye', 'D', 1963, 1924); | |
insert into senators values('ID', 'Jim Risch', 'R', 2009, 1943); | |
insert into senators values('ID', 'Mike Crapo', 'R', 1999, 1951); | |
insert into senators values('IL', 'Mark Kirk', 'R', 2010, 1959); | |
insert into senators values('IL', 'Richard Durbin', 'D', 1997, 1944); | |
insert into senators values('IN', 'Dan Coats', 'R', 2011, 1943); | |
insert into senators values('IN', 'Richard Lugar', 'R', 1977, 1932); | |
insert into senators values('IA', 'Chuck Grassley', 'R', 1981, 1933); | |
insert into senators values('IA', 'Tom Harkin', 'D', 1985, 1939); | |
insert into senators values('KS', 'Jerry Moran', 'R', 2011, 1954); | |
insert into senators values('KS', 'Pat Roberts', 'R', 1997, 1936); | |
insert into senators values('KY', 'Mitch McConnell', 'R', 1985, 1942); | |
insert into senators values('KY', 'Rand Paul', 'R', 2011, 1963); | |
insert into senators values('LA', 'David Vitter', 'R', 2005, 1961); | |
insert into senators values('LA', 'Mary Landrieu', 'D', 1997, 1955); | |
insert into senators values('ME', 'Olympia Snowe', 'R', 1995, 1947); | |
insert into senators values('ME', 'Susan Collins', 'R', 1997, 1952); | |
insert into senators values('MD', 'Barbara Mikulski', 'D', 1987, 1936); | |
insert into senators values('MD', 'Ben Cardin', 'D', 2007, 1943); | |
insert into senators values('MA', 'John Kerry', 'D', 1985, 1943); | |
insert into senators values('MA', 'Scott Brown', 'R', 2010, 1959); | |
insert into senators values('MI', 'Carl Levin', 'D', 1979, 1934); | |
insert into senators values('MI', 'Debbie Stabenow', 'D', 2001, 1950); | |
insert into senators values('MN', 'Al Franken', 'D', 2009, 1951); | |
insert into senators values('MN', 'Amy Klobuchar', 'D', 2007, 1960); | |
insert into senators values('MS', 'Roger Wicker', 'R', 2007, 1951); | |
insert into senators values('MS', 'Thad Cochran', 'R', 1979, 1937); | |
insert into senators values('MO', 'Claire McCaskill', 'D', 2007, 1953); | |
insert into senators values('MO', 'Roy Blunt', 'R', 2011, 1950); | |
insert into senators values('MT', 'Max Baucus', 'D', 1979, 1941); | |
insert into senators values('MT', 'Jon Tester', 'D', 2007, 1956); | |
insert into senators values('NE', 'Ben Nelson', 'D', 2001, 1941); | |
insert into senators values('NE', 'Mike Johanns', 'R', 2009, 1950); | |
insert into senators values('NV', 'Dean Heller', 'R', 2011, 1960); | |
insert into senators values('NV', 'Harry Reid', 'D', 1987, 1939); | |
insert into senators values('NH', 'Jeanne Shaheen', 'D', 2009, 1947); | |
insert into senators values('NH', 'Kelly Ayotte', 'R', 2011, 1968); | |
insert into senators values('NJ', 'Frank Lautenberg', 'D', 2003, 1924); | |
insert into senators values('NJ', 'Robert Menendez', 'D', 2006, 1954); | |
insert into senators values('NM', 'Jeff Bingaman', 'D', 1983, 1943); | |
insert into senators values('NM', 'Tom Udall', 'D', 2009, 1948); | |
insert into senators values('NY', 'Chuck Schumer', 'D', 1999, 1950); | |
insert into senators values('NY', 'Kirsten Gillibrand', 'D', 2009, 1966); | |
insert into senators values('NC', 'Richard Burr', 'R', 2005, 1955); | |
insert into senators values('NC', 'Kay Hagan', 'D', 2009, 1953); | |
insert into senators values('ND', 'John Hoeven', 'R', 2011, 1957); | |
insert into senators values('ND', 'Kent Conrad', 'D', 1987, 1948); | |
insert into senators values('OH', 'Sherrod Brown', 'D', 2007, 1952); | |
insert into senators values('OH', 'Rob Portman', 'R', 2011, 1955); | |
insert into senators values('OK', 'Tom Coburn', 'R', 2005, 1948); | |
insert into senators values('OK', 'James Inhofe', 'R', 1995, 1934); | |
insert into senators values('OR', 'Jeff Merkley', 'D', 2009, 1956); | |
insert into senators values('OR', 'Ron Wyden', 'D', 1996, 1949); | |
insert into senators values('PA', 'Bob Casey, Jr.', 'D', 2007, 1960); | |
insert into senators values('PA', 'Pat Toomey', 'R', 2011, 1961); | |
insert into senators values('RI', 'Sheldon Whitehouse', 'D', 2007, 1955); | |
insert into senators values('RI', 'Jack Reed', 'D', 1997, 1949); | |
insert into senators values('SC', 'Jim DeMint', 'R', 2005, 1951); | |
insert into senators values('SC', 'Lindsey Graham', 'R', 2003, 1955); | |
insert into senators values('SD', 'Tim Johnson', 'D', 1997, 1946); | |
insert into senators values('SD', 'John Thune', 'R', 2005, 1961); | |
insert into senators values('TN', 'Bob Corker', 'R', 2007, 1952); | |
insert into senators values('TN', 'Lamar Alexander', 'R', 2003, 1940); | |
insert into senators values('TX', 'John Cornyn', 'R', 2003, 1952); | |
insert into senators values('TX', 'Kay Bailey Hutchison', 'R', 1993, 1943); | |
insert into senators values('UT', 'Mike Lee', 'R', 2011, 1971); | |
insert into senators values('UT', 'Orrin Hatch', 'R', 1977, 1934); | |
insert into senators values('VT', 'Patrick Leahy', 'D', 1975, 1940); | |
insert into senators values('VT', 'Bernie Sanders', 'D', 2007, 1941); | |
insert into senators values('VA', 'Mark Warner', 'D', 2009, 1954); | |
insert into senators values('VA', 'Jim Webb', 'D', 2007, 1946); | |
insert into senators values('WA', 'Maria Cantwell', 'D', 2001, 1958); | |
insert into senators values('WA', 'Patty Murray', 'D', 1993, 1950); | |
insert into senators values('WV', 'Joe Manchin', 'D', 2010, 1947); | |
insert into senators values('WV', 'Jay Rockefeller', 'D', 1985, 1937); | |
insert into senators values('WI', 'Herb Kohl', 'D', 1989, 1935); | |
insert into senators values('WI', 'Ron Johnson', 'R', 2011, 1955); | |
insert into senators values('WY', 'Mike Enzi', 'R', 1997, 1944); | |
insert into senators values('WY', 'John Barrasso', 'R', 2007, 1952); | |
insert into committees values ('ANF', NULL, 'Agriculture, Nutrition and Forestry', 'Debbie Stabenow', 'Pat Roberts'); | |
insert into committees values ('ANF1', 'ANF', 'Commodities, Markets, Trade and Risk Management', 'Ben Nelson', 'Saxby Chambliss'); | |
insert into committees values ('ANF2', 'ANF', 'Conservation, Forestry and Natural Resources', 'Michael Bennet', 'John Boozman'); | |
insert into committees values ('ANF3', 'ANF', 'Jobs, Rural Economic Growth and Energy Innovation', 'Sherrod Brown', 'John Thune'); | |
insert into committees values ('ANF4', 'ANF', 'Livestock, Dairy, Poultry, Marketing and Agriculture Security', 'Kirsten Gillibrand', 'Mike Johanns'); | |
insert into committees values ('ANF5', 'ANF', 'Nutrition, Specialty Crops, Food and Agricultural Research', 'Bob Casey, Jr.', 'Richard Lugar'); | |
insert into committees values ('APR', NULL, 'Appropriations', 'Daniel Inouye', 'Thad Cochran'); | |
insert into committees values ('APR1', 'APR', 'Agriculture, Rural Development, Food and Drug Administration, and Related Agencies', 'Herb Kohl', 'Roy Blunt'); | |
insert into committees values ('APR2', 'APR', 'Commerce, Justice, Science, and Related Agencies', 'Barbara Mikulski', 'Kay Bailey Hutchison'); | |
insert into committees values ('APR3', 'APR', 'Defense', 'Daniel Inouye', 'Thad Cochran'); | |
insert into committees values ('APR4', 'APR', 'Energy and Water Development', 'Dianne Feinstein', 'Lamar Alexander'); | |
insert into committees values ('APR5', 'APR', 'Financial Services and General Government', 'Richard Durbin', 'Jerry Moran'); | |
insert into committees values ('APR6', 'APR', 'Homeland Security', 'Mary Landrieu', 'Dan Coats'); | |
insert into committees values ('APR7', 'APR', 'Interior, Environment, and Related Agencies', 'Jack Reed', 'Lisa Murkowski'); | |
insert into committees values ('APR8', 'APR', 'Labor, Health and Human Services, Education, and Related Agencies', 'Tom Harkin', 'Richard Shelby'); | |
insert into committees values ('APR9', 'APR', 'Legislative Branch', 'Ben Nelson', 'John Hoeven'); | |
insert into committees values ('APR10', 'APR', 'Military Construction, Veterans Affairs, and Related Agencies', 'Tim Johnson', 'Mark Kirk'); | |
insert into committees values ('APR11', 'APR', 'State, Foreign Operations, and Related Programs', 'Patrick Leahy', 'Lindsey Graham'); | |
insert into committees values ('APR12', 'APR', 'Transportation, Housing and Urban Development, and Related Agencies', 'Patty Murray', 'Susan Collins'); | |
insert into committees values ('ARM', NULL, 'Armed Services', 'Carl Levin', 'John McCain'); | |
insert into committees values ('ARM1', 'ARM', 'Airland', 'Joe Lieberman', 'Scott Brown'); | |
insert into committees values ('ARM2', 'ARM', 'Emerging Threats and Capabilities', 'Kay Hagan', 'Rob Portman'); | |
insert into committees values ('ARM3', 'ARM', 'Personnel', 'Jim Webb', 'Lindsey Graham'); | |
insert into committees values ('ARM4', 'ARM', 'Readiness and Management Support', 'Claire McCaskill', 'Kelly Ayotte'); | |
insert into committees values ('ARM5', 'ARM', 'SeaPower', 'Jack Reed', 'Roger Wicker'); | |
insert into committees values ('ARM6', 'ARM', 'Strategic Forces', 'Ben Nelson', 'Jeff Sessions'); | |
insert into committees values ('BHU', NULL, 'Banking, Housing, and Urban Affairs', 'Tim Johnson', 'Richard Shelby'); | |
insert into committees values ('BHU1', 'BHU', 'Economic Policy', 'Jon Tester', 'David Vitter'); | |
insert into committees values ('BHU2', 'BHU', 'Financial Institutions and Consumer Protection', 'Sherrod Brown', 'Bob Corker'); | |
insert into committees values ('BHU3', 'BHU', 'Housing, Transportation, and Community Development', 'Robert Menendez', 'Jim DeMint'); | |
insert into committees values ('BHU4', 'BHU', 'Securities, Insurance, and Investment', 'Jack Reed', 'Mike Crapo'); | |
insert into committees values ('BHU5', 'BHU', 'Security and International Trade and Finance', 'Mark Warner', 'Mike Johanns'); | |
insert into committees values ('BDG', NULL, 'Budget', 'Kent Conrad', 'Jeff Sessions'); | |
insert into committees values ('CST', NULL, 'Commerce, Science and Transportation', 'Jay Rockefeller', 'Kay Bailey Hutchison'); | |
insert into committees values ('CST1', 'CST', 'Aviation Operations, Safety, and Security', 'Maria Cantwell', 'John Thune'); | |
insert into committees values ('CST2', 'CST', 'Communications, Technology, and the Internet', 'John Kerry', 'Jim DeMint'); | |
insert into committees values ('CST3', 'CST', 'Competitiveness, Innovation, and Export Promotion', 'Amy Klobuchar', 'Roy Blunt'); | |
insert into committees values ('CST4', 'CST', 'Consumer Protection, Product Safety, and Insurance', 'Mark Pryor', 'Pat Toomey'); | |
insert into committees values ('CST5', 'CST', 'Oceans, Atmosphere, Fisheries, and Coast Guard', 'Mark Begich', 'Olympia Snowe'); | |
insert into committees values ('CST6', 'CST', 'Science and Space', 'Bill Nelson', 'John Boozman'); | |
insert into committees values ('CST7', 'CST', 'Surface Transportation and Merchant Marine Infrastructure, Safety, and Security', 'Frank Lautenberg', 'Roger Wicker'); | |
insert into committees values ('ENR', NULL, 'Energy and Natural Resources', 'Jeff Bingaman', 'Lisa Murkowski'); | |
insert into committees values ('ENR1', 'ENR', 'Energy', 'Maria Cantwell', 'Jim Risch'); | |
insert into committees values ('ENR2', 'ENR', 'National Parks', 'Mark Udall', 'Richard Burr'); | |
insert into committees values ('ENR3', 'ENR', 'Public Lands and Forests', 'Ron Wyden', 'John Barrasso'); | |
insert into committees values ('ENR4', 'ENR', 'Water and Power', 'Debbie Stabenow', 'Mike Lee'); | |
insert into committees values ('ENV', NULL, 'Environment and Public Works', 'Barbara Boxer', 'James Inhofe'); | |
insert into committees values ('ENV1', 'ENV', 'Children’s Health and Environmental Responsibility', 'Amy Klobuchar', 'Lamar Alexander'); | |
insert into committees values ('ENV2', 'ENV', 'Clean Air and Nuclear Safety', 'Thomas Carper', 'John Barrasso'); | |
insert into committees values ('ENV3', 'ENV', 'Green Jobs and the New Economy', 'Bernie Sanders', 'John Boozman'); | |
insert into committees values ('ENV4', 'ENV', 'Oversight', 'Sheldon Whitehouse', 'Mike Johanns'); | |
insert into committees values ('ENV5', 'ENV', 'Superfund, Toxics and Environmental Health', 'Frank Lautenberg', 'Mike Crapo'); | |
insert into committees values ('ENV6', 'ENV', 'Transportation and Infrastructure', 'Max Baucus', 'David Vitter'); | |
insert into committees values ('ENV7', 'ENV', 'Water and Wildlife', 'Ben Cardin', 'Jeff Sessions'); | |
insert into committees values ('FIN', NULL, 'Finance', 'Max Baucus', 'Orrin Hatch'); | |
insert into committees values ('FIN1', 'FIN', 'Energy, Natural Resources, and Infrastructure', 'Jeff Bingaman', 'John Cornyn'); | |
insert into committees values ('FIN2', 'FIN', 'Fiscal Responsibility and Economic Growth', 'Bill Nelson', 'Mike Crapo'); | |
insert into committees values ('FIN3', 'FIN', 'Health Care', 'Jay Rockefeller', 'Chuck Grassley'); | |
insert into committees values ('FIN4', 'FIN', 'International Trade, Customs, and Global Competitiveness', 'Ron Wyden', 'John Thune'); | |
insert into committees values ('FIN5', 'FIN', 'Social Security, Pensions, and Family Policy', 'Debbie Stabenow', 'Tom Coburn'); | |
insert into committees values ('FIN6', 'FIN', 'Taxation and IRS Oversight', 'Kent Conrad', 'Jon Kyl'); | |
insert into committees values ('FOR', NULL, 'Foreign Relations', 'John Kerry', 'Richard Lugar'); | |
insert into committees values ('FOR1', 'FOR', 'Western Hemisphere, Peace Corps and Narcotics Affairs', 'Robert Menendez', 'Marco Rubio'); | |
insert into committees values ('FOR2', 'FOR', 'Near Eastern and South and Central Asian Affairs', 'Bob Casey, Jr.', 'Jim Risch'); | |
insert into committees values ('FOR3', 'FOR', 'African Affairs', 'Chris Coons', 'Johnny Isakson'); | |
insert into committees values ('FOR4', 'FOR', 'East Asian and Pacific Affairs', 'Jim Webb', 'James Inhofe'); | |
insert into committees values ('FOR5', 'FOR', 'International Operations and Organizations, Human Rights, Democracy and Global Womens Issues', 'Barbara Boxer', 'Jim DeMint'); | |
insert into committees values ('FOR6', 'FOR', 'European Affairs', 'Jeanne Shaheen', 'John Barrasso'); | |
insert into committees values ('FOR7', 'FOR', 'International Development and Foreign Assistance, Economic Affairs, and International Environmental Protection', 'Ben Cardin', 'Bob Corker'); | |
insert into committees values ('HEA', NULL, 'Health, Education, Labor, and Pensions', 'Tom Harkin', 'Mike Enzi'); | |
insert into committees values ('HEA1', 'HEA', 'Subcommittee on Children and Families', 'Patty Murray', 'Richard Burr'); | |
insert into committees values ('HEA2', 'HEA', 'Subcommittee on Employment and Workplace Safety', 'Barbara Mikulski', 'Johnny Isakson'); | |
insert into committees values ('HEA3', 'HEA', 'Subcommittee on Primary Health and Aging', 'Bernie Sanders', 'Rand Paul'); | |
insert into committees values ('HSC', NULL, 'Homeland Security and Governmental Affairs', 'Joe Lieberman', 'Susan Collins'); | |
insert into committees values ('HSC1', 'HSC', 'Contracting Oversight', 'Claire McCaskill', 'Rob Portman'); | |
insert into committees values ('HSC2', 'HSC', 'Disaster Recovery and Intergovernmental Affairs', 'Mark Pryor', 'Rand Paul'); | |
insert into committees values ('HSC3', 'HSC', 'Federal Financial Management, Government Information and International Security', 'Thomas Carper', 'Scott Brown'); | |
insert into committees values ('HSC4', 'HSC', 'Investigations', 'Carl Levin', 'Tom Coburn'); | |
insert into committees values ('HSC5', 'HSC', 'Oversight of Government Management, the Federal Workforce and the District of Columbia', 'Daniel Akaka', 'Ron Johnson'); | |
insert into committees values ('JUD', NULL, 'Judiciary', 'Patrick Leahy', 'Chuck Grassley'); | |
insert into committees values ('JUD1', 'JUD', 'Administrative Oversight and the Courts', 'Amy Klobuchar', 'Jeff Sessions'); | |
insert into committees values ('JUD2', 'JUD', 'Antitrust, Competition Policy and Consumer Rights', 'Herb Kohl', 'Mike Lee'); | |
insert into committees values ('JUD3', 'JUD', 'The Constitution, Civil Rights and Human Rights', 'Richard Durbin', 'Lindsey Graham'); | |
insert into committees values ('JUD4', 'JUD', 'Crime and Terrorism', 'Sheldon Whitehouse', 'Jon Kyl'); | |
insert into committees values ('JUD5', 'JUD', 'Immigration, Refugees and Border Security', 'Chuck Schumer', 'John Cornyn'); | |
insert into committees values ('JUD6', 'JUD', 'Privacy, Technology and the Law', 'Al Franken', 'Tom Coburn'); | |
insert into committees values ('RUL', NULL, 'Rules and Administration', 'Chuck Schumer', 'Lamar Alexander'); | |
insert into committees values ('SBE', NULL, 'Small Business and Entrepreneurship', 'Mary Landrieu', 'Olympia Snowe'); | |
insert into committees values ('VET', NULL, 'Veterans Affairs', 'Patty Murray', 'Richard Burr'); | |
insert into counties values ('Autauga', 'AL', 18186,54571); | |
insert into counties values ('Baldwin', 'AL', 40997,182265); | |
insert into counties values ('Barbour', 'AL', 28892,27457); | |
insert into counties values ('Bibb', 'AL', 17987,22915); | |
insert into counties values ('Blount', 'AL', 28975,57322); | |
insert into counties values ('Bullock', 'AL', 16054,10914); | |
insert into counties values ('Butler', 'AL', 29228,20947); | |
insert into counties values ('Calhoun', 'AL', 79539,118572); | |
insert into counties values ('Chambers', 'AL', 39528,34215); | |
insert into counties values ('Cherokee', 'AL', 17634,25989); | |
insert into counties values ('Chilton', 'AL', 26922,43643); | |
insert into counties values ('Choctaw', 'AL', 19152,13859); | |
insert into counties values ('Clarke', 'AL', 26548,25833); | |
insert into counties values ('Clay', 'AL', 13929,13932); | |
insert into counties values ('Cleburne', 'AL', 11904,14972); | |
insert into counties values ('Coffee', 'AL', 30720,49948); | |
insert into counties values ('Colbert', 'AL', 39561,54428); | |
insert into counties values ('Conecuh', 'AL', 21776,13228); | |
insert into counties values ('Coosa', 'AL', 11766,11539); | |
insert into counties values ('Covington', 'AL', 40373,37765); | |
insert into counties values ('Crenshaw', 'AL', 18981,13906); | |
insert into counties values ('Cullman', 'AL', 49046,80406); | |
insert into counties values ('Dale', 'AL', 20828,50251); | |
insert into counties values ('Dallas', 'AL', 56270,43820); | |
insert into counties values ('DeKalb', 'AL', 45048,71109); | |
insert into counties values ('Elmore', 'AL', 31649,79303); | |
insert into counties values ('Escambia', 'AL', 31443,38319); | |
insert into counties values ('Etowah', 'AL', 93892,104430); | |
insert into counties values ('Fayette', 'AL', 19388,17241); | |
insert into counties values ('Franklin', 'AL', 25705,31704); | |
insert into counties values ('Geneva', 'AL', 25899,26790); | |
insert into counties values ('Greene', 'AL', 16482,9045); | |
insert into counties values ('Hale', 'AL', 20832,15760); | |
insert into counties values ('Henry', 'AL', 18674,17302); | |
insert into counties values ('Houston', 'AL', 46522,101547); | |
insert into counties values ('Jackson', 'AL', 38998,53227); | |
insert into counties values ('Jefferson', 'AL', 558928,658466); | |
insert into counties values ('Lamar', 'AL', 16441,14564); | |
insert into counties values ('Lauderdale', 'AL', 54179,92709); | |
insert into counties values ('Lawrence', 'AL', 27128,34339); | |
insert into counties values ('Lee', 'AL', 45073,140247); | |
insert into counties values ('Limestone', 'AL', 35766,82782); | |
insert into counties values ('Lowndes', 'AL', 18018,11299); | |
insert into counties values ('Macon', 'AL', 30561,21452); | |
insert into counties values ('Madison', 'AL', 72903,334811); | |
insert into counties values ('Marengo', 'AL', 29494,21027); | |
insert into counties values ('Marion', 'AL', 27264,30776); | |
insert into counties values ('Marshall', 'AL', 45090,93019); | |
insert into counties values ('Mobile', 'AL', 231105,412992); | |
insert into counties values ('Monroe', 'AL', 25732,23068); | |
insert into counties values ('Montgomery', 'AL', 138965,229363); | |
insert into counties values ('Morgan', 'AL', 52924,119490); | |
insert into counties values ('Perry', 'AL', 20439,10591); | |
insert into counties values ('Pickens', 'AL', 24349,19746); | |
insert into counties values ('Pike', 'AL', 30608,32899); | |
insert into counties values ('Randolph', 'AL', 22513,22913); | |
insert into counties values ('Russell', 'AL', 40364,52947); | |
insert into counties values ('St. Clair', 'AL', 26687,83593); | |
insert into counties values ('Shelby', 'AL', 30362,195085); | |
insert into counties values ('Sumter', 'AL', 23610,13763); | |
insert into counties values ('Talladega', 'AL', 63639,82291); | |
insert into counties values ('Tallapoosa', 'AL', 35074,41616); | |
insert into counties values ('Tuscaloosa', 'AL', 94092,194656); | |
insert into counties values ('Walker', 'AL', 63769,67023); | |
insert into counties values ('Washington', 'AL', 15612,17581); | |
insert into counties values ('Wilcox', 'AL', 23476,11670); | |
insert into counties values ('Winston', 'AL', 18250,24484); | |
insert into counties values ('Aleutians East', 'AK', 0,3141); | |
insert into counties values ('Aleutians West', 'AK', 0,5561); | |
insert into counties values ('Anchorage', 'AK', 59518,291826); | |
insert into counties values ('Bethel', 'AK', 0,17013); | |
insert into counties values ('Bristol Bay', 'AK', 0,997); | |
insert into counties values ('Denali', 'AK', 0,1826); | |
insert into counties values ('Dillingham', 'AK', 0,4847); | |
insert into counties values ('Fairbanks North Star', 'AK', 28650,97581); | |
insert into counties values ('Haines', 'AK', 0,2508); | |
insert into counties values ('Hoonah-Angoon', 'AK', 0,2150); | |
insert into counties values ('Juneau', 'AK', 28203,31275); | |
insert into counties values ('Kenai Peninsula', 'AK', 0,55400); | |
insert into counties values ('Ketchikan Gateway', 'AK', 0,13477); | |
insert into counties values ('Kodiak Island', 'AK', 0,13592); | |
insert into counties values ('Lake and Peninsula', 'AK', 0,1631); | |
insert into counties values ('Matanuska-Susitna', 'AK', 0,88995); | |
insert into counties values ('Nome', 'AK', 12272,9492); | |
insert into counties values ('North Slope', 'AK', 0,9430); | |
insert into counties values ('Northwest Arctic', 'AK', 0,7523); | |
insert into counties values ('Petersburg', 'AK', 0,3815); | |
insert into counties values ('Prince of Wales-Hyder', 'AK', 0,5559); | |
insert into counties values ('Sitka', 'AK', 0,8881); | |
insert into counties values ('Skagway', 'AK', 0,968); | |
insert into counties values ('Southeast Fairbanks', 'AK', 0,7029); | |
insert into counties values ('Valdez-Cordova', 'AK', 0,9636); | |
insert into counties values ('Wade Hampton', 'AK', 0,7459); | |
insert into counties values ('Wrangell', 'AK', 0,2369); | |
insert into counties values ('Yakutat', 'AK', 0,662); | |
insert into counties values ('Yukon-Koyukuk', 'AK', 0,5588); | |
insert into counties values ('Apache', 'AZ', 27767,71518); | |
insert into counties values ('Cochise', 'AZ', 31488,131346); | |
insert into counties values ('Coconino', 'AZ', 23910,134421); | |
insert into counties values ('Gila', 'AZ', 24158,53597); | |
insert into counties values ('Graham', 'AZ', 12985,37220); | |
insert into counties values ('Greenlee', 'AZ', 12805,8437); | |
insert into counties values ('La Paz', 'AZ', 0,20489); | |
insert into counties values ('Maricopa', 'AZ', 331770,3817117); | |
insert into counties values ('Mohave', 'AZ', 8510,200186); | |
insert into counties values ('Navajo', 'AZ', 29446,107449); | |
insert into counties values ('Pima', 'AZ', 141216,980263); | |
insert into counties values ('Pinal', 'AZ', 43191,375770); | |
insert into counties values ('Santa Cruz', 'AZ', 9344,47420); | |
insert into counties values ('Yavapai', 'AZ', 24991,211033); | |
insert into counties values ('Yuma', 'AZ', 28006,195751); | |
insert into counties values ('Arkansas', 'AR', 23665,19019); | |
insert into counties values ('Ashley', 'AR', 25660,21853); | |
insert into counties values ('Baxter', 'AR', 11683,41513); | |
insert into counties values ('Benton', 'AR', 38076,221339); | |
insert into counties values ('Boone', 'AR', 16260,36903); | |
insert into counties values ('Bradley', 'AR', 15987,11508); | |
insert into counties values ('Calhoun', 'AR', 7132,5368); | |
insert into counties values ('Carroll', 'AR', 13244,27446); | |
insert into counties values ('Chicot', 'AR', 22306,11800); | |
insert into counties values ('Clark', 'AR', 22998,22995); | |
insert into counties values ('Clay', 'AR', 26674,16083); | |
insert into counties values ('Cleburne', 'AR', 11487,25970); | |
insert into counties values ('Cleveland', 'AR', 8956,8689); | |
insert into counties values ('Columbia', 'AR', 28770,24552); | |
insert into counties values ('Conway', 'AR', 18137,21273); | |
insert into counties values ('Craighead', 'AR', 50613,96443); | |
insert into counties values ('Crawford', 'AR', 22727,61948); | |
insert into counties values ('Crittenden', 'AR', 47184,50902); | |
insert into counties values ('Cross', 'AR', 24757,17870); | |
insert into counties values ('Dallas', 'AR', 12416,8116); | |
insert into counties values ('Desha', 'AR', 25155,13008); | |
insert into counties values ('Drew', 'AR', 17959,18509); | |
insert into counties values ('Faulkner', 'AR', 25289,113237); | |
insert into counties values ('Franklin', 'AR', 12358,18125); | |
insert into counties values ('Fulton', 'AR', 9187,12245); | |
insert into counties values ('Garland', 'AR', 47102,96024); | |
insert into counties values ('Grant', 'AR', 9024,17853); | |
insert into counties values ('Greene', 'AR', 29149,42090); | |
insert into counties values ('Hempstead', 'AR', 25080,22609); | |
insert into counties values ('Hot Spring', 'AR', 22181,32923); | |
insert into counties values ('Howard', 'AR', 13342,13789); | |
insert into counties values ('Independence', 'AR', 23488,36647); | |
insert into counties values ('Izard', 'AR', 9953,13696); | |
insert into counties values ('Jackson', 'AR', 25912,17997); | |
insert into counties values ('Jefferson', 'AR', 76075,77435); | |
insert into counties values ('Johnson', 'AR', 16138,25540); | |
insert into counties values ('Lafayette', 'AR', 13203,7645); | |
insert into counties values ('Lawrence', 'AR', 21303,17415); | |
insert into counties values ('Lee', 'AR', 24322,10424); | |
insert into counties values ('Lincoln', 'AR', 17079,14134); | |
insert into counties values ('Little River', 'AR', 11690,13171); | |
insert into counties values ('Logan', 'AR', 20260,22353); | |
insert into counties values ('Lonoke', 'AR', 27278,68356); | |
insert into counties values ('Madison', 'AR', 11734,15717); | |
insert into counties values ('Marion', 'AR', 8609,16653); | |
insert into counties values ('Miller', 'AR', 32614,43462); | |
insert into counties values ('Mississippi', 'AR', 82375,46480); | |
insert into counties values ('Monroe', 'AR', 19540,8149); | |
insert into counties values ('Montgomery', 'AR', 6680,9487); | |
insert into counties values ('Nevada', 'AR', 14781,8997); | |
insert into counties values ('Newton', 'AR', 8685,8330); | |
insert into counties values ('Ouachita', 'AR', 33051,26120); | |
insert into counties values ('Perry', 'AR', 5978,10445); | |
insert into counties values ('Phillips', 'AR', 46254,21757); | |
insert into counties values ('Pike', 'AR', 10032,11291); | |
insert into counties values ('Poinsett', 'AR', 39311,24583); | |
insert into counties values ('Polk', 'AR', 14182,20662); | |
insert into counties values ('Pope', 'AR', 23291,61754); | |
insert into counties values ('Prairie', 'AR', 13768,8715); | |
insert into counties values ('Pulaski', 'AR', 196685,382748); | |
insert into counties values ('Randolph', 'AR', 15982,17969); | |
insert into counties values ('St. Francis', 'AR', 36841,28258); | |
insert into counties values ('Saline', 'AR', 23816,107118); | |
insert into counties values ('Scott', 'AR', 10057,11233); | |
insert into counties values ('Searcy', 'AR', 10424,8195); | |
insert into counties values ('Sebastian', 'AR', 64202,125744); | |
insert into counties values ('Sevier', 'AR', 12293,17058); | |
insert into counties values ('Sharp', 'AR', 8999,17264); | |
insert into counties values ('Stone', 'AR', 7662,12394); | |
insert into counties values ('Union', 'AR', 49686,41639); | |
insert into counties values ('Van Buren', 'AR', 9687,17295); | |
insert into counties values ('Washington', 'AR', 49979,203065); | |
insert into counties values ('White', 'AR', 38040,77076); | |
insert into counties values ('Woodruff', 'AR', 18957,7260); | |
insert into counties values ('Yell', 'AR', 14057,22185); | |
insert into counties values ('Alameda', 'CA', 740315,1510271); | |
insert into counties values ('Alpine', 'CA', 241,1175); | |
insert into counties values ('Amador', 'CA', 9151,38091); | |
insert into counties values ('Butte', 'CA', 64930,220000); | |
insert into counties values ('Calaveras', 'CA', 9902,45578); | |
insert into counties values ('Colusa', 'CA', 11651,21419); | |
insert into counties values ('Contra Costa', 'CA', 298984,1049025); | |
insert into counties values ('Del Norte', 'CA', 8078,28610); | |
insert into counties values ('El Dorado', 'CA', 16207,181058); | |
insert into counties values ('Fresno', 'CA', 276515,930450); | |
insert into counties values ('Glenn', 'CA', 15448,28122); | |
insert into counties values ('Humboldt', 'CA', 69241,134623); | |
insert into counties values ('Imperial', 'CA', 62975,174528); | |
insert into counties values ('Inyo', 'CA', 11658,18546); | |
insert into counties values ('Kern', 'CA', 228309,839631); | |
insert into counties values ('Kings', 'CA', 46768,152982); | |
insert into counties values ('Lake', 'CA', 11481,64665); | |
insert into counties values ('Lassen', 'CA', 18474,34895); | |
insert into counties values ('Los Angeles', 'CA', 4151687,9818605); | |
insert into counties values ('Madera', 'CA', 36964,150865); | |
insert into counties values ('Marin', 'CA', 85619,252409); | |
insert into counties values ('Mariposa', 'CA', 5145,18251); | |
insert into counties values ('Mendocino', 'CA', 40854,87841); | |
insert into counties values ('Merced', 'CA', 69780,255793); | |
insert into counties values ('Modoc', 'CA', 9678,9686); | |
insert into counties values ('Mono', 'CA', 2115,14202); | |
insert into counties values ('Monterey', 'CA', 130498,415057); | |
insert into counties values ('Napa', 'CA', 46603,136484); | |
insert into counties values ('Nevada', 'CA', 19888,98764); | |
insert into counties values ('Orange', 'CA', 216224,3010232); | |
insert into counties values ('Placer', 'CA', 41649,348432); | |
insert into counties values ('Plumas', 'CA', 13519,20007); | |
insert into counties values ('Riverside', 'CA', 170046,2189641); | |
insert into counties values ('Sacramento', 'CA', 277140,1418788); | |
insert into counties values ('San Benito', 'CA', 14370,55269); | |
insert into counties values ('San Bernardino', 'CA', 281642,2035210); | |
insert into counties values ('San Diego', 'CA', 556808,3095313); | |
insert into counties values ('San Francisco', 'CA', 775357,805235); | |
insert into counties values ('San Joaquin', 'CA', 200750,685306); | |
insert into counties values ('San Luis Obispo', 'CA', 51417,269637); | |
insert into counties values ('San Mateo', 'CA', 235659,718451); | |
insert into counties values ('Santa Barbara', 'CA', 98220,423895); | |
insert into counties values ('Santa Clara', 'CA', 290547,1781642); | |
insert into counties values ('Santa Cruz', 'CA', 66534,262382); | |
insert into counties values ('Shasta', 'CA', 36413,177223); | |
insert into counties values ('Sierra', 'CA', 2410,3240); | |
insert into counties values ('Siskiyou', 'CA', 30733,44900); | |
insert into counties values ('Solano', 'CA', 104833,413344); | |
insert into counties values ('Sonoma', 'CA', 103405,483878); | |
insert into counties values ('Stanislaus', 'CA', 127231,514453); | |
insert into counties values ('Sutter', 'CA', 26239,94737); | |
insert into counties values ('Tehama', 'CA', 19276,63463); | |
insert into counties values ('Trinity', 'CA', 5087,13786); | |
insert into counties values ('Tulare', 'CA', 149264,442179); | |
insert into counties values ('Tuolumne', 'CA', 12584,55365); | |
insert into counties values ('Ventura', 'CA', 114647,823318); | |
insert into counties values ('Yolo', 'CA', 40640,200849); | |
insert into counties values ('Yuba', 'CA', 24420,72155); | |
insert into counties values ('Adams', 'CO', 40234,441603); | |
insert into counties values ('Alamosa', 'CO', 10531,15445); | |
insert into counties values ('Arapahoe', 'CO', 52125,572003); | |
insert into counties values ('Archuleta', 'CO', 3030,12084); | |
insert into counties values ('Baca', 'CO', 7964,3788); | |
insert into counties values ('Bent', 'CO', 8775,6499); | |
insert into counties values ('Boulder', 'CO', 48296,294567); | |
insert into counties values ('Broomfield', 'CO', 0,55889); | |
insert into counties values ('Chaffee', 'CO', 7168,17809); | |
insert into counties values ('Cheyenne', 'CO', 3453,1836); | |
insert into counties values ('Clear Creek', 'CO', 3289,9088); | |
insert into counties values ('Conejos', 'CO', 10171,8256); | |
insert into counties values ('Costilla', 'CO', 6067,3524); | |
insert into counties values ('Crowley', 'CO', 5222,5823); | |
insert into counties values ('Custer', 'CO', 1573,4255); | |
insert into counties values ('Delta', 'CO', 17365,30952); | |
insert into counties values ('Denver', 'CO', 415786,600158); | |
insert into counties values ('Dolores', 'CO', 1966,2064); | |
insert into counties values ('Douglas', 'CO', 3507,285465); | |
insert into counties values ('Eagle', 'CO', 4488,52197); | |
insert into counties values ('Elbert', 'CO', 4477,23086); | |
insert into counties values ('El Paso', 'CO', 74523,622263); | |
insert into counties values ('Fremont', 'CO', 18366,46824); | |
insert into counties values ('Garfield', 'CO', 11625,56389); | |
insert into counties values ('Gilpin', 'CO', 850,5441); | |
insert into counties values ('Grand', 'CO', 3963,14843); | |
insert into counties values ('Gunnison', 'CO', 5716,15324); | |
insert into counties values ('Hinsdale', 'CO', 263,843); | |
insert into counties values ('Huerfano', 'CO', 10549,6711); | |
insert into counties values ('Jackson', 'CO', 1976,1394); | |
insert into counties values ('Jefferson', 'CO', 55687,534543); | |
insert into counties values ('Kiowa', 'CO', 3003,1398); | |
insert into counties values ('Kit Carson', 'CO', 8600,8270); | |
insert into counties values ('Lake', 'CO', 6150,7310); | |
insert into counties values ('La Plata', 'CO', 14880,51334); | |
insert into counties values ('Larimer', 'CO', 43554,299630); | |
insert into counties values ('Las Animas', 'CO', 25902,15507); | |
insert into counties values ('Lincoln', 'CO', 5909,5467); | |
insert into counties values ('Logan', 'CO', 17187,22709); | |
insert into counties values ('Mesa', 'CO', 38974,146723); | |
insert into counties values ('Mineral', 'CO', 698,712); | |
insert into counties values ('Moffat', 'CO', 5946,13795); | |
insert into counties values ('Montezuma', 'CO', 9991,25535); | |
insert into counties values ('Montrose', 'CO', 15220,41276); | |
insert into counties values ('Morgan', 'CO', 18074,28159); | |
insert into counties values ('Otero', 'CO', 25275,18831); | |
insert into counties values ('Ouray', 'CO', 2103,4436); | |
insert into counties values ('Park', 'CO', 1870,16206); | |
insert into counties values ('Phillips', 'CO', 4924,4442); | |
insert into counties values ('Pitkin', 'CO', 1646,17148); | |
insert into counties values ('Prowers', 'CO', 14836,12551); | |
insert into counties values ('Pueblo', 'CO', 90188,159063); | |
insert into counties values ('Rio Blanco', 'CO', 4719,6666); | |
insert into counties values ('Rio Grande', 'CO', 12832,11982); | |
insert into counties values ('Routt', 'CO', 8940,23509); | |
insert into counties values ('Saguache', 'CO', 5664,6108); | |
insert into counties values ('San Juan', 'CO', 1471,699); | |
insert into counties values ('San Miguel', 'CO', 2693,7359); | |
insert into counties values ('Sedgwick', 'CO', 5095,2379); | |
insert into counties values ('Summit', 'CO', 1135,27994); | |
insert into counties values ('Teller', 'CO', 2754,23350); | |
insert into counties values ('Washington', 'CO', 7520,4814); | |
insert into counties values ('Weld', 'CO', 67504,252825); | |
insert into counties values ('Yuma', 'CO', 10827,10043); | |
insert into counties values ('Fairfield', 'CT', 504342,916829); | |
insert into counties values ('Hartford', 'CT', 539661,894014); | |
insert into counties values ('Litchfield', 'CT', 98872,189927); | |
insert into counties values ('Middlesex', 'CT', 67332,165676); | |
insert into counties values ('New Haven', 'CT', 545784,862477); | |
insert into counties values ('New London', 'CT', 144821,274055); | |
insert into counties values ('Tolland', 'CT', 44709,152691); | |
insert into counties values ('Windham', 'CT', 61759,118428); | |
insert into counties values ('Kent', 'DE', 37870,162310); | |
insert into counties values ('New Castle', 'DE', 218879,538479); | |
insert into counties values ('Sussex', 'DE', 61336,197145); | |
insert into counties values ('Alachua', 'FL', 57026,247336); | |
insert into counties values ('Baker', 'FL', 6313,27115); | |
insert into counties values ('Bay', 'FL', 42689,168852); | |
insert into counties values ('Bradford', 'FL', 11457,28520); | |
insert into counties values ('Brevard', 'FL', 23653,543376); | |
insert into counties values ('Broward', 'FL', 83933,1748066); | |
insert into counties values ('Calhoun', 'FL', 7922,14625); | |
insert into counties values ('Charlotte', 'FL', 4286,159978); | |
insert into counties values ('Citrus', 'FL', 6111,141236); | |
insert into counties values ('Clay', 'FL', 14323,190865); | |
insert into counties values ('Collier', 'FL', 6488,321520); | |
insert into counties values ('Columbia', 'FL', 18216,67531); | |
insert into counties values ('DeSoto', 'FL', 9242,34862); | |
insert into counties values ('Dixie', 'FL', 3928,16422); | |
insert into counties values ('Duval', 'FL', 304029,864263); | |
insert into counties values ('Escambia', 'FL', 112706,297619); | |
insert into counties values ('Flagler', 'FL', 3367,95696); | |
insert into counties values ('Franklin', 'FL', 5814,11549); | |
insert into counties values ('Gadsden', 'FL', 36457,46389); | |
insert into counties values ('Gilchrist', 'FL', 3499,16939); | |
insert into counties values ('Glades', 'FL', 2199,12884); | |
insert into counties values ('Gulf', 'FL', 7460,15863); | |
insert into counties values ('Hamilton', 'FL', 8981,14799); | |
insert into counties values ('Hardee', 'FL', 10073,27731); | |
insert into counties values ('Hendry', 'FL', 6051,39140); | |
insert into counties values ('Hernando', 'FL', 6693,172778); | |
insert into counties values ('Highlands', 'FL', 13636,98786); | |
insert into counties values ('Hillsborough', 'FL', 249894,1229226); | |
insert into counties values ('Holmes', 'FL', 13988,19927); | |
insert into counties values ('Indian River', 'FL', 11872,138028); | |
insert into counties values ('Jackson', 'FL', 34645,49746); | |
insert into counties values ('Jefferson', 'FL', 10413,14761); | |
insert into counties values ('Lafayette', 'FL', 3440,8870); | |
insert into counties values ('Lake', 'FL', 36340,297052); | |
insert into counties values ('Lee', 'FL', 23404,618754); | |
insert into counties values ('Leon', 'FL', 51590,275487); | |
insert into counties values ('Levy', 'FL', 10637,40801); | |
insert into counties values ('Liberty', 'FL', 3182,8365); | |
insert into counties values ('Madison', 'FL', 14197,19224); | |
insert into counties values ('Manatee', 'FL', 34704,322833); | |
insert into counties values ('Marion', 'FL', 38187,331298); | |
insert into counties values ('Martin', 'FL', 7807,146318); | |
insert into counties values ('Miami-Dade', 'FL', 495084,2496435); | |
insert into counties values ('Monroe', 'FL', 29957,73090); | |
insert into counties values ('Nassau', 'FL', 12811,73314); | |
insert into counties values ('Okaloosa', 'FL', 27533,180822); | |
insert into counties values ('Okeechobee', 'FL', 3454,39996); | |
insert into counties values ('Orange', 'FL', 114950,1145956); | |
insert into counties values ('Osceola', 'FL', 11406,268685); | |
insert into counties values ('Palm Beach', 'FL', 114688,1320134); | |
insert into counties values ('Pasco', 'FL', 20529,464697); | |
insert into counties values ('Pinellas', 'FL', 159249,916542); | |
insert into counties values ('Polk', 'FL', 123997,602095); | |
insert into counties values ('Putnam', 'FL', 23615,74364); | |
insert into counties values ('St. Johns', 'FL', 24998,190039); | |
insert into counties values ('St. Lucie', 'FL', 20180,277789); | |
insert into counties values ('Santa Rosa', 'FL', 18554,151372); | |
insert into counties values ('Sarasota', 'FL', 28827,379448); | |
insert into counties values ('Seminole', 'FL', 26883,422718); | |
insert into counties values ('Sumter', 'FL', 11330,93420); | |
insert into counties values ('Suwannee', 'FL', 16986,41551); | |
insert into counties values ('Taylor', 'FL', 10416,22570); | |
insert into counties values ('Union', 'FL', 8906,15535); | |
insert into counties values ('Volusia', 'FL', 74229,494593); | |
insert into counties values ('Wakulla', 'FL', 5258,30776); | |
insert into counties values ('Walton', 'FL', 14725,55043); | |
insert into counties values ('Washington', 'FL', 11888,24896); | |
insert into counties values ('Appling', 'GA', 14003,18236); | |
insert into counties values ('Atkinson', 'GA', 7362,8375); | |
insert into counties values ('Bacon', 'GA', 8940,11096); | |
insert into counties values ('Baker', 'GA', 5952,3451); | |
insert into counties values ('Baldwin', 'GA', 29706,45720); | |
insert into counties values ('Banks', 'GA', 6935,18395); | |
insert into counties values ('Barrow', 'GA', 13115,69367); | |
insert into counties values ('Bartow', 'GA', 27370,100157); | |
insert into counties values ('Ben Hill', 'GA', 14879,17634); | |
insert into counties values ('Berrien', 'GA', 13966,19286); | |
insert into counties values ('Bibb', 'GA', 114079,155547); | |
insert into counties values ('Bleckley', 'GA', 9218,13063); | |
insert into counties values ('Brantley', 'GA', 6387,18411); | |
insert into counties values ('Brooks', 'GA', 18169,16243); | |
insert into counties values ('Bryan', 'GA', 5965,30233); | |
insert into counties values ('Bulloch', 'GA', 24740,70217); | |
insert into counties values ('Burke', 'GA', 23458,23316); | |
insert into counties values ('Butts', 'GA', 9079,23655); | |
insert into counties values ('Calhoun', 'GA', 8578,6694); | |
insert into counties values ('Camden', 'GA', 7322,50513); | |
insert into counties values ('Candler', 'GA', 8063,10998); | |
insert into counties values ('Carroll', 'GA', 34112,110527); | |
insert into counties values ('Catoosa', 'GA', 15146,63942); | |
insert into counties values ('Charlton', 'GA', 4821,12171); | |
insert into counties values ('Chatham', 'GA', 151481,265128); | |
insert into counties values ('Chattahoochee', 'GA', 12149,11267); | |
insert into counties values ('Chattooga', 'GA', 21197,26015); | |
insert into counties values ('Cherokee', 'GA', 20750,214346); | |
insert into counties values ('Clarke', 'GA', 36550,116714); | |
insert into counties values ('Clay', 'GA', 5844,3183); | |
insert into counties values ('Clayton', 'GA', 22872,259424); | |
insert into counties values ('Clinch', 'GA', 6007,6798); | |
insert into counties values ('Cobb', 'GA', 61830,688078); | |
insert into counties values ('Coffee', 'GA', 23961,42356); | |
insert into counties values ('Colquitt', 'GA', 33999,45498); | |
insert into counties values ('Columbia', 'GA', 9525,124053); | |
insert into counties values ('Cook', 'GA', 12201,17212); | |
insert into counties values ('Coweta', 'GA', 27786,127317); | |
insert into counties values ('Crawford', 'GA', 6080,12630); | |
insert into counties values ('Crisp', 'GA', 17663,23439); | |
insert into counties values ('Dade', 'GA', 7364,16633); | |
insert into counties values ('Dawson', 'GA', 3712,22330); | |
insert into counties values ('Decatur', 'GA', 23620,27842); | |
insert into counties values ('DeKalb', 'GA', 136395,691893); | |
insert into counties values ('Dodge', 'GA', 17865,21796); | |
insert into counties values ('Dooly', 'GA', 14159,14918); | |
insert into counties values ('Dougherty', 'GA', 43617,94565); | |
insert into counties values ('Douglas', 'GA', 12173,132403); | |
insert into counties values ('Early', 'GA', 17413,11008); | |
insert into counties values ('Echols', 'GA', 2494,4034); | |
insert into counties values ('Effingham', 'GA', 9133,52250); | |
insert into counties values ('Elbert', 'GA', 18585,20166); | |
insert into counties values ('Emanuel', 'GA', 19789,22598); | |
insert into counties values ('Evans', 'GA', 6653,11000); | |
insert into counties values ('Fannin', 'GA', 15192,23682); | |
insert into counties values ('Fayette', 'GA', 7978,106567); | |
insert into counties values ('Floyd', 'GA', 62899,96317); | |
insert into counties values ('Forsyth', 'GA', 11005,175511); | |
insert into counties values ('Franklin', 'GA', 14446,22084); | |
insert into counties values ('Fulton', 'GA', 473572,920581); | |
insert into counties values ('Gilmer', 'GA', 9963,28292); | |
insert into counties values ('Glascock', 'GA', 3579,3082); | |
insert into counties values ('Glynn', 'GA', 29046,79626); | |
insert into counties values ('Gordon', 'GA', 18922,55186); | |
insert into counties values ('Grady', 'GA', 18928,25011); | |
insert into counties values ('Greene', 'GA', 12843,15994); | |
insert into counties values ('Gwinnett', 'GA', 32320,805321); | |
insert into counties values ('Habersham', 'GA', 16553,43041); | |
insert into counties values ('Hall', 'GA', 40113,179684); | |
insert into counties values ('Hancock', 'GA', 11052,9429); | |
insert into counties values ('Haralson', 'GA', 14663,28780); | |
insert into counties values ('Harris', 'GA', 11265,32024); | |
insert into counties values ('Hart', 'GA', 14495,25213); | |
insert into counties values ('Heard', 'GA', 6975,11834); | |
insert into counties values ('Henry', 'GA', 15857,203922); | |
insert into counties values ('Houston', 'GA', 20964,139900); | |
insert into counties values ('Irwin', 'GA', 11973,9538); | |
insert into counties values ('Jackson', 'GA', 18997,60485); | |
insert into counties values ('Jasper', 'GA', 7473,13900); | |
insert into counties values ('Jeff Davis', 'GA', 9299,15068); | |
insert into counties values ('Jefferson', 'GA', 18855,16930); | |
insert into counties values ('Jenkins', 'GA', 10264,8340); | |
insert into counties values ('Johnson', 'GA', 9893,9980); | |
insert into counties values ('Jones', 'GA', 7538,28669); | |
insert into counties values ('Lamar', 'GA', 10242,18317); | |
insert into counties values ('Lanier', 'GA', 5151,10078); | |
insert into counties values ('Laurens', 'GA', 33123,48434); | |
insert into counties values ('Lee', 'GA', 6674,28298); | |
insert into counties values ('Liberty', 'GA', 8444,63453); | |
insert into counties values ('Lincoln', 'GA', 6462,7996); | |
insert into counties values ('Long', 'GA', 3598,14464); | |
insert into counties values ('Lowndes', 'GA', 35211,109233); | |
insert into counties values ('Lumpkin', 'GA', 6574,29966); | |
insert into counties values ('McDuffie', 'GA', 11443,21875); | |
insert into counties values ('McIntosh', 'GA', 6008,14333); | |
insert into counties values ('Macon', 'GA', 14213,14740); | |
insert into counties values ('Madison', 'GA', 12238,28120); | |
insert into counties values ('Marion', 'GA', 6521,8742); | |
insert into counties values ('Meriwether', 'GA', 21055,21992); | |
insert into counties values ('Miller', 'GA', 9023,6125); | |
insert into counties values ('Mitchell', 'GA', 22528,23498); | |
insert into counties values ('Monroe', 'GA', 10523,26424); | |
insert into counties values ('Montgomery', 'GA', 7901,9123); | |
insert into counties values ('Morgan', 'GA', 11899,17868); | |
insert into counties values ('Murray', 'GA', 10676,39628); | |
insert into counties values ('Muscogee', 'GA', 118028,189885); | |
insert into counties values ('Newton', 'GA', 20185,99958); | |
insert into counties values ('Oconee', 'GA', 7009,32808); | |
insert into counties values ('Oglethorpe', 'GA', 9958,14899); | |
insert into counties values ('Paulding', 'GA', 11752,142324); | |
insert into counties values ('Peach', 'GA', 11705,27695); | |
insert into counties values ('Pickens', 'GA', 8855,29431); | |
insert into counties values ('Pierce', 'GA', 11112,18758); | |
insert into counties values ('Pike', 'GA', 8459,17869); | |
insert into counties values ('Polk', 'GA', 30976,41475); | |
insert into counties values ('Pulaski', 'GA', 8808,12010); | |
insert into counties values ('Putnam', 'GA', 7731,21218); | |
insert into counties values ('Quitman', 'GA', 3015,2513); | |
insert into counties values ('Rabun', 'GA', 7424,16276); | |
insert into counties values ('Randolph', 'GA', 13804,7719); | |
insert into counties values ('Richmond', 'GA', 108876,200549); | |
insert into counties values ('Rockdale', 'GA', 8464,85215); | |
insert into counties values ('Schley', 'GA', 4036,5010); | |
insert into counties values ('Screven', 'GA', 18000,14593); | |
insert into counties values ('Seminole', 'GA', 7904,8729); | |
insert into counties values ('Spalding', 'GA', 31045,64073); | |
insert into counties values ('Stephens', 'GA', 16647,26175); | |
insert into counties values ('Stewart', 'GA', 9194,6058); | |
insert into counties values ('Sumter', 'GA', 24208,32819); | |
insert into counties values ('Talbot', 'GA', 7687,6865); | |
insert into counties values ('Taliaferro', 'GA', 4515,1717); | |
insert into counties values ('Tattnall', 'GA', 15939,25520); | |
insert into counties values ('Taylor', 'GA', 9113,8906); | |
insert into counties values ('Telfair', 'GA', 13221,16500); | |
insert into counties values ('Terrell', 'GA', 14314,9315); | |
insert into counties values ('Thomas', 'GA', 33932,44720); | |
insert into counties values ('Tift', 'GA', 22645,40118); | |
insert into counties values ('Toombs', 'GA', 17382,27223); | |
insert into counties values ('Towns', 'GA', 4803,10471); | |
insert into counties values ('Treutlen', 'GA', 6522,6885); | |
insert into counties values ('Troup', 'GA', 49841,67044); | |
insert into counties values ('Turner', 'GA', 10479,8930); | |
insert into counties values ('Twiggs', 'GA', 8308,9023); | |
insert into counties values ('Union', 'GA', 7318,21356); | |
insert into counties values ('Upson', 'GA', 25078,27153); | |
insert into counties values ('Walker', 'GA', 38198,68756); | |
insert into counties values ('Walton', 'GA', 20230,83768); | |
insert into counties values ('Ware', 'GA', 30289,36312); | |
insert into counties values ('Warren', 'GA', 8779,5834); | |
insert into counties values ('Washington', 'GA', 21012,21187); | |
insert into counties values ('Wayne', 'GA', 14248,30099); | |
insert into counties values ('Webster', 'GA', 4081,2799); | |
insert into counties values ('Wheeler', 'GA', 6712,7421); | |
insert into counties values ('White', 'GA', 5951,27144); | |
insert into counties values ('Whitfield', 'GA', 34432,102599); | |
insert into counties values ('Wilcox', 'GA', 10167,9255); | |
insert into counties values ('Wilkes', 'GA', 12388,10593); | |
insert into counties values ('Wilkinson', 'GA', 9781,9563); | |
insert into counties values ('Worth', 'GA', 19357,21679); | |
insert into counties values ('Hawaii', 'HI', 68350,185079); | |
insert into counties values ('Honolulu', 'HI', 353020,953207); | |
insert into counties values ('Kalawao', 'HI', 340,90); | |
insert into counties values ('Kauai', 'HI', 29565,67091); | |
insert into counties values ('Maui', 'HI', 48519,154834); | |
insert into counties values ('Ada', 'ID', 70649,392365); | |
insert into counties values ('Adams', 'ID', 3347,3976); | |
insert into counties values ('Bannock', 'ID', 41745,82839); | |
insert into counties values ('Bear Lake', 'ID', 6834,5986); | |
insert into counties values ('Benewah', 'ID', 6173,9285); | |
insert into counties values ('Bingham', 'ID', 23271,45607); | |
insert into counties values ('Blaine', 'ID', 5384,21376); | |
insert into counties values ('Boise', 'ID', 1776,7028); | |
insert into counties values ('Bonner', 'ID', 14853,40877); | |
insert into counties values ('Bonneville', 'ID', 30210,104234); | |
insert into counties values ('Boundary', 'ID', 5908,10972); | |
insert into counties values ('Butte', 'ID', 2722,2891); | |
insert into counties values ('Camas', 'ID', 1079,1117); | |
insert into counties values ('Canyon', 'ID', 53597,188923); | |
insert into counties values ('Caribou', 'ID', 5576,6963); | |
insert into counties values ('Cassia', 'ID', 14629,22952); | |
insert into counties values ('Clark', 'ID', 918,982); | |
insert into counties values ('Clearwater', 'ID', 8217,8761); | |
insert into counties values ('Custer', 'ID', 3318,4368); | |
insert into counties values ('Elmore', 'ID', 6687,27038); | |
insert into counties values ('Franklin', 'ID', 9867,12786); | |
insert into counties values ('Fremont', 'ID', 9351,13242); | |
insert into counties values ('Gem', 'ID', 8730,16719); | |
insert into counties values ('Gooding', 'ID', 11101,15464); | |
insert into counties values ('Idaho', 'ID', 11423,16267); | |
insert into counties values ('Jefferson', 'ID', 10495,26140); | |
insert into counties values ('Jerome', 'ID', 12080,22374); | |
insert into counties values ('Kootenai', 'ID', 24947,138494); | |
insert into counties values ('Latah', 'ID', 20971,37244); | |
insert into counties values ('Lemhi', 'ID', 6278,7936); | |
insert into counties values ('Lewis', 'ID', 4208,3821); | |
insert into counties values ('Lincoln', 'ID', 4256,5208); | |
insert into counties values ('Madison', 'ID', 9156,37536); | |
insert into counties values ('Minidoka', 'ID', 9785,20069); | |
insert into counties values ('Nez Perce', 'ID', 22658,39265); | |
insert into counties values ('Oneida', 'ID', 4387,4286); | |
insert into counties values ('Owyhee', 'ID', 6307,11526); | |
insert into counties values ('Payette', 'ID', 11921,22623); | |
insert into counties values ('Power', 'ID', 3988,7817); | |
insert into counties values ('Shoshone', 'ID', 22806,12765); | |
insert into counties values ('Teton', 'ID', 3204,10170); | |
insert into counties values ('Twin Falls', 'ID', 40979,77230); | |
insert into counties values ('Valley', 'ID', 4270,9862); | |
insert into counties values ('Washington', 'ID', 8576,10198); | |
insert into counties values ('Adams', 'IL', 64690,67103); | |
insert into counties values ('Alexander', 'IL', 20316,8238); | |
insert into counties values ('Bond', 'IL', 14157,17768); | |
insert into counties values ('Boone', 'IL', 17070,54165); | |
insert into counties values ('Brown', 'IL', 7132,6937); | |
insert into counties values ('Bureau', 'IL', 37711,34978); | |
insert into counties values ('Calhoun', 'IL', 6898,5089); | |
insert into counties values ('Carroll', 'IL', 18976,15387); | |
insert into counties values ('Cass', 'IL', 15097,13642); | |
insert into counties values ('Champaign', 'IL', 106100,201081); | |
insert into counties values ('Christian', 'IL', 38816,34800); | |
insert into counties values ('Clark', 'IL', 17362,16335); | |
insert into counties values ('Clay', 'IL', 17445,13815); | |
insert into counties values ('Clinton', 'IL', 22594,37762); | |
insert into counties values ('Coles', 'IL', 40328,53873); | |
insert into counties values ('Cook', 'IL', 4508792,5194675); | |
insert into counties values ('Crawford', 'IL', 21137,19817); | |
insert into counties values ('Cumberland', 'IL', 10496,11048); | |
insert into counties values ('DeKalb', 'IL', 40781,105160); | |
insert into counties values ('De Witt', 'IL', 16894,16561); | |
insert into counties values ('Douglas', 'IL', 16706,19980); | |
insert into counties values ('DuPage', 'IL', 154599,916924); | |
insert into counties values ('Edgar', 'IL', 23407,18576); | |
insert into counties values ('Edwards', 'IL', 9056,6721); | |
insert into counties values ('Effingham', 'IL', 21675,34242); | |
insert into counties values ('Fayette', 'IL', 24582,22140); | |
insert into counties values ('Ford', 'IL', 15901,14081); | |
insert into counties values ('Franklin', 'IL', 48685,39561); | |
insert into counties values ('Fulton', 'IL', 43716,37069); | |
insert into counties values ('Gallatin', 'IL', 9818,5589); | |
insert into counties values ('Greene', 'IL', 18852,13886); | |
insert into counties values ('Grundy', 'IL', 19217,50063); | |
insert into counties values ('Hamilton', 'IL', 12256,8457); | |
insert into counties values ('Hancock', 'IL', 25790,19104); | |
insert into counties values ('Hardin', 'IL', 7530,4320); | |
insert into counties values ('Henderson', 'IL', 8416,7331); | |
insert into counties values ('Henry', 'IL', 46492,50486); | |
insert into counties values ('Iroquois', 'IL', 32348,29718); | |
insert into counties values ('Jackson', 'IL', 38124,60218); | |
insert into counties values ('Jasper', 'IL', 12266,9698); | |
insert into counties values ('Jefferson', 'IL', 35892,38827); | |
insert into counties values ('Jersey', 'IL', 15264,22985); | |
insert into counties values ('Jo Daviess', 'IL', 21459,22678); | |
insert into counties values ('Johnson', 'IL', 8729,12582); | |
insert into counties values ('Kane', 'IL', 150388,515269); | |
insert into counties values ('Kankakee', 'IL', 73524,113449); | |
insert into counties values ('Kendall', 'IL', 12115,114736); | |
insert into counties values ('Knox', 'IL', 54366,52919); | |
insert into counties values ('Lake', 'IL', 179097,703462); | |
insert into counties values ('LaSalle', 'IL', 100610,113924); | |
insert into counties values ('Lawrence', 'IL', 20539,16833); | |
insert into counties values ('Lee', 'IL', 36451,36031); | |
insert into counties values ('Livingston', 'IL', 37809,38950); | |
insert into counties values ('Logan', 'IL', 30671,30305); | |
insert into counties values ('McDonough', 'IL', 28199,32612); | |
insert into counties values ('McHenry', 'IL', 50656,308760); | |
insert into counties values ('McLean', 'IL', 76577,169572); | |
insert into counties values ('Macon', 'IL', 98853,110768); | |
insert into counties values ('Macoupin', 'IL', 44210,47765); | |
insert into counties values ('Madison', 'IL', 182307,269282); | |
insert into counties values ('Marion', 'IL', 41700,39437); | |
insert into counties values ('Marshall', 'IL', 13025,12640); | |
insert into counties values ('Mason', 'IL', 15326,14666); | |
insert into counties values ('Massac', 'IL', 13594,15429); | |
insert into counties values ('Menard', 'IL', 9639,12705); | |
insert into counties values ('Mercer', 'IL', 17374,16434); | |
insert into counties values ('Monroe', 'IL', 13282,32957); | |
insert into counties values ('Montgomery', 'IL', 32460,30104); | |
insert into counties values ('Morgan', 'IL', 35568,35547); | |
insert into counties values ('Moultrie', 'IL', 13171,14846); | |
insert into counties values ('Ogle', 'IL', 33429,53497); | |
insert into counties values ('Peoria', 'IL', 174347,186494); | |
insert into counties values ('Perry', 'IL', 21684,22350); | |
insert into counties values ('Piatt', 'IL', 13970,16729); | |
insert into counties values ('Pike', 'IL', 22155,16430); | |
insert into counties values ('Pope', 'IL', 5779,4470); | |
insert into counties values ('Pulaski', 'IL', 13639,6161); | |
insert into counties values ('Putnam', 'IL', 4746,6006); | |
insert into counties values ('Randolph', 'IL', 31673,33476); | |
insert into counties values ('Richland', 'IL', 16889,16233); | |
insert into counties values ('Rock Island', 'IL', 133558,147546); | |
insert into counties values ('St. Clair', 'IL', 205995,270056); | |
insert into counties values ('Saline', 'IL', 33420,24913); | |
insert into counties values ('Sangamon', 'IL', 131484,197465); | |
insert into counties values ('Schuyler', 'IL', 9613,7544); | |
insert into counties values ('Scott', 'IL', 7245,5355); | |
insert into counties values ('Shelby', 'IL', 24434,22363); | |
insert into counties values ('Stark', 'IL', 8721,5994); | |
insert into counties values ('Stephenson', 'IL', 41595,47711); | |
insert into counties values ('Tazewell', 'IL', 76165,135394); | |
insert into counties values ('Union', 'IL', 20500,17808); | |
insert into counties values ('Vermilion', 'IL', 87079,81625); | |
insert into counties values ('Wabash', 'IL', 14651,11947); | |
insert into counties values ('Warren', 'IL', 21981,17707); | |
insert into counties values ('Washington', 'IL', 14460,14716); | |
insert into counties values ('Wayne', 'IL', 20933,16760); | |
insert into counties values ('White', 'IL', 20935,14665); | |
insert into counties values ('Whiteside', 'IL', 49336,58498); | |
insert into counties values ('Will', 'IL', 134336,677560); | |
insert into counties values ('Williamson', 'IL', 48621,66357); | |
insert into counties values ('Winnebago', 'IL', 152385,295266); | |
insert into counties values ('Woodford', 'IL', 21335,38664); | |
insert into counties values ('Adams', 'IN', 22393,34387); | |
insert into counties values ('Allen', 'IN', 183722,355329); | |
insert into counties values ('Bartholomew', 'IN', 36108,76794); | |
insert into counties values ('Benton', 'IN', 11462,8854); | |
insert into counties values ('Blackford', 'IN', 14026,12766); | |
insert into counties values ('Boone', 'IN', 23993,56640); | |
insert into counties values ('Brown', 'IN', 6209,15242); | |
insert into counties values ('Carroll', 'IN', 16010,20155); | |
insert into counties values ('Cass', 'IN', 38793,38966); | |
insert into counties values ('Clark', 'IN', 48330,110232); | |
insert into counties values ('Clay', 'IN', 23918,26890); | |
insert into counties values ('Clinton', 'IN', 29734,33224); | |
insert into counties values ('Crawford', 'IN', 9289,10713); | |
insert into counties values ('Daviess', 'IN', 26762,31648); | |
insert into counties values ('Dearborn', 'IN', 25141,50047); | |
insert into counties values ('Decatur', 'IN', 18218,25740); | |
insert into counties values ('DeKalb', 'IN', 26023,42223); | |
insert into counties values ('Delaware', 'IN', 90252,117671); | |
insert into counties values ('Dubois', 'IN', 23785,41889); | |
insert into counties values ('Elkhart', 'IN', 84512,197559); | |
insert into counties values ('Fayette', 'IN', 23391,24277); | |
insert into counties values ('Floyd', 'IN', 43955,74578); | |
insert into counties values ('Fountain', 'IN', 17836,17240); | |
insert into counties values ('Franklin', 'IN', 16034,23087); | |
insert into counties values ('Fulton', 'IN', 16565,20836); | |
insert into counties values ('Gibson', 'IN', 30720,33503); | |
insert into counties values ('Grant', 'IN', 62156,70061); | |
insert into counties values ('Greene', 'IN', 27886,33165); | |
insert into counties values ('Hamilton', 'IN', 28491,274569); | |
insert into counties values ('Hancock', 'IN', 20332,70002); | |
insert into counties values ('Harrison', 'IN', 17858,39364); | |
insert into counties values ('Hendricks', 'IN', 24594,145448); | |
insert into counties values ('Henry', 'IN', 45505,49462); | |
insert into counties values ('Howard', 'IN', 54498,82752); | |
insert into counties values ('Huntington', 'IN', 31400,37124); | |
insert into counties values ('Jackson', 'IN', 28237,42376); | |
insert into counties values ('Jasper', 'IN', 17031,33478); | |
insert into counties values ('Jay', 'IN', 23157,21253); | |
insert into counties values ('Jefferson', 'IN', 21613,32428); | |
insert into counties values ('Jennings', 'IN', 15250,28525); | |
insert into counties values ('Johnson', 'IN', 26183,139654); | |
insert into counties values ('Knox', 'IN', 43415,38440); | |
insert into counties values ('Kosciusko', 'IN', 33002,77358); | |
insert into counties values ('LaGrange', 'IN', 15347,37128); | |
insert into counties values ('Lake', 'IN', 368152,496005); | |
insert into counties values ('LaPorte', 'IN', 76808,111467); | |
insert into counties values ('Lawrence', 'IN', 34346,46134); | |
insert into counties values ('Madison', 'IN', 103911,131636); | |
insert into counties values ('Marion', 'IN', 551777,903393); | |
insert into counties values ('Marshall', 'IN', 29468,47051); | |
insert into counties values ('Martin', 'IN', 10678,10334); | |
insert into counties values ('Miami', 'IN', 28201,36903); | |
insert into counties values ('Monroe', 'IN', 50080,137974); | |
insert into counties values ('Montgomery', 'IN', 29122,38124); | |
insert into counties values ('Morgan', 'IN', 23726,68894); | |
insert into counties values ('Newton', 'IN', 11006,14244); | |
insert into counties values ('Noble', 'IN', 25075,47536); | |
insert into counties values ('Ohio', 'IN', 4223,6128); | |
insert into counties values ('Orange', 'IN', 16879,19840); | |
insert into counties values ('Owen', 'IN', 11763,21575); | |
insert into counties values ('Parke', 'IN', 15674,17339); | |
insert into counties values ('Perry', 'IN', 17367,19338); | |
insert into counties values ('Pike', 'IN', 14995,12845); | |
insert into counties values ('Porter', 'IN', 40076,164343); | |
insert into counties values ('Posey', 'IN', 19818,25910); | |
insert into counties values ('Pulaski', 'IN', 12493,13402); | |
insert into counties values ('Putnam', 'IN', 22950,37963); | |
insert into counties values ('Randolph', 'IN', 27141,26171); | |
insert into counties values ('Ripley', 'IN', 18763,28818); | |
insert into counties values ('Rush', 'IN', 19799,17392); | |
insert into counties values ('St. Joseph', 'IN', 205058,266931); | |
insert into counties values ('Scott', 'IN', 11519,24181); | |
insert into counties values ('Shelby', 'IN', 28026,44436); | |
insert into counties values ('Spencer', 'IN', 16174,20952); | |
insert into counties values ('Starke', 'IN', 15282,23363); | |
insert into counties values ('Steuben', 'IN', 17087,34185); | |
insert into counties values ('Sullivan', 'IN', 23667,21475); | |
insert into counties values ('Switzerland', 'IN', 7599,10613); | |
insert into counties values ('Tippecanoe', 'IN', 74473,172780); | |
insert into counties values ('Tipton', 'IN', 15566,15936); | |
insert into counties values ('Union', 'IN', 6412,7516); | |
insert into counties values ('Vanderburgh', 'IN', 160422,179703); | |
insert into counties values ('Vermillion', 'IN', 19723,16212); | |
insert into counties values ('Vigo', 'IN', 105160,107848); | |
insert into counties values ('Wabash', 'IN', 29047,32888); | |
insert into counties values ('Warren', 'IN', 8535,8508); | |
insert into counties values ('Warrick', 'IN', 21527,59689); | |
insert into counties values ('Washington', 'IN', 16520,28262); | |
insert into counties values ('Wayne', 'IN', 68566,68917); | |
insert into counties values ('Wells', 'IN', 19564,27636); | |
insert into counties values ('White', 'IN', 18042,24643); | |
insert into counties values ('Whitley', 'IN', 18828,33292); | |
insert into counties values ('Adair', 'IA', 12292,7682); | |
insert into counties values ('Adams', 'IA', 8753,4029); | |
insert into counties values ('Allamakee', 'IA', 16351,14330); | |
insert into counties values ('Appanoose', 'IA', 19683,12887); | |
insert into counties values ('Audubon', 'IA', 11579,6119); | |
insert into counties values ('Benton', 'IA', 22656,26076); | |
insert into counties values ('Black Hawk', 'IA', 100448,131090); | |
insert into counties values ('Boone', 'IA', 28139,26306); | |
insert into counties values ('Bremer', 'IA', 18884,24276); | |
insert into counties values ('Buchanan', 'IA', 21927,20958); | |
insert into counties values ('Buena Vista', 'IA', 21113,20260); | |
insert into counties values ('Butler', 'IA', 17394,14867); | |
insert into counties values ('Calhoun', 'IA', 16925,9670); | |
insert into counties values ('Carroll', 'IA', 23065,20816); | |
insert into counties values ('Cass', 'IA', 18532,13956); | |
insert into counties values ('Cedar', 'IA', 16910,18499); | |
insert into counties values ('Cerro Gordo', 'IA', 46053,44151); | |
insert into counties values ('Cherokee', 'IA', 19052,12072); | |
insert into counties values ('Chickasaw', 'IA', 15228,12439); | |
insert into counties values ('Clarke', 'IA', 9369,9286); | |
insert into counties values ('Clay', 'IA', 18103,16667); | |
insert into counties values ('Clayton', 'IA', 22522,18129); | |
insert into counties values ('Clinton', 'IA', 49664,49116); | |
insert into counties values ('Crawford', 'IA', 19741,17096); | |
insert into counties values ('Dallas', 'IA', 23661,66135); | |
insert into counties values ('Davis', 'IA', 9959,8753); | |
insert into counties values ('Decatur', 'IA', 12601,8457); | |
insert into counties values ('Delaware', 'IA', 17734,17764); | |
insert into counties values ('Des Moines', 'IA', 42056,40325); | |
insert into counties values ('Dickinson', 'IA', 12756,16667); | |
insert into counties values ('Dubuque', 'IA', 71337,93653); | |
insert into counties values ('Emmet', 'IA', 14102,10302); | |
insert into counties values ('Fayette', 'IA', 28294,20880); | |
insert into counties values ('Floyd', 'IA', 21505,16303); | |
insert into counties values ('Franklin', 'IA', 16268,10680); | |
insert into counties values ('Fremont', 'IA', 12323,7441); | |
insert into counties values ('Greene', 'IA', 15544,9336); | |
insert into counties values ('Grundy', 'IA', 13722,12453); | |
insert into counties values ('Guthrie', 'IA', 15197,10954); | |
insert into counties values ('Hamilton', 'IA', 19660,15673); | |
insert into counties values ('Hancock', 'IA', 15077,11341); | |
insert into counties values ('Hardin', 'IA', 22218,17534); | |
insert into counties values ('Harrison', 'IA', 19560,14928); | |
insert into counties values ('Henry', 'IA', 18708,20145); | |
insert into counties values ('Howard', 'IA', 13105,9566); | |
insert into counties values ('Humboldt', 'IA', 13117,9815); | |
insert into counties values ('Ida', 'IA', 10697,7089); | |
insert into counties values ('Iowa', 'IA', 15835,16355); | |
insert into counties values ('Jackson', 'IA', 18622,19848); | |
insert into counties values ('Jasper', 'IA', 32305,36842); | |
insert into counties values ('Jefferson', 'IA', 15696,16843); | |
insert into counties values ('Johnson', 'IA', 45756,130882); | |
insert into counties values ('Jones', 'IA', 19401,20638); | |
insert into counties values ('Keokuk', 'IA', 16797,10511); | |
insert into counties values ('Kossuth', 'IA', 26241,15543); | |
insert into counties values ('Lee', 'IA', 43102,35862); | |
insert into counties values ('Linn', 'IA', 104274,211226); | |
insert into counties values ('Louisa', 'IA', 11101,11387); | |
insert into counties values ('Lucas', 'IA', 12069,8898); | |
insert into counties values ('Lyon', 'IA', 14697,11581); | |
insert into counties values ('Madison', 'IA', 13131,15679); | |
insert into counties values ('Mahaska', 'IA', 24672,22381); | |
insert into counties values ('Marion', 'IA', 25930,33309); | |
insert into counties values ('Marshall', 'IA', 35611,40648); | |
insert into counties values ('Mills', 'IA', 14064,15059); | |
insert into counties values ('Mitchell', 'IA', 13945,10776); | |
insert into counties values ('Monona', 'IA', 16303,9243); | |
insert into counties values ('Monroe', 'IA', 11814,7970); | |
insert into counties values ('Montgomery', 'IA', 15685,10740); | |
insert into counties values ('Muscatine', 'IA', 32148,42745); | |
insert into counties values ('OBrien', 'IA', 18970,14398); | |
insert into counties values ('Osceola', 'IA', 10181,6462); | |
insert into counties values ('Page', 'IA', 23921,15932); | |
insert into counties values ('Palo Alto', 'IA', 15891,9421); | |
insert into counties values ('Plymouth', 'IA', 23252,24986); | |
insert into counties values ('Pocahontas', 'IA', 15496,7310); | |
insert into counties values ('Polk', 'IA', 226010,430640); | |
insert into counties values ('Pottawattamie', 'IA', 69682,93158); | |
insert into counties values ('Poweshiek', 'IA', 19344,18914); | |
insert into counties values ('Ringgold', 'IA', 9528,5131); | |
insert into counties values ('Sac', 'IA', 17518,10350); | |
insert into counties values ('Scott', 'IA', 100698,165224); | |
insert into counties values ('Shelby', 'IA', 15942,12167); | |
insert into counties values ('Sioux', 'IA', 26381,33704); | |
insert into counties values ('Story', 'IA', 44294,89542); | |
insert into counties values ('Tama', 'IA', 21688,17767); | |
insert into counties values ('Taylor', 'IA', 12420,6317); | |
insert into counties values ('Union', 'IA', 15651,12534); | |
insert into counties values ('Van Buren', 'IA', 11007,7570); | |
insert into counties values ('Wapello', 'IA', 47397,35625); | |
insert into counties values ('Warren', 'IA', 17758,46225); | |
insert into counties values ('Washington', 'IA', 19557,21704); | |
insert into counties values ('Wayne', 'IA', 11737,6403); | |
insert into counties values ('Webster', 'IA', 44241,38013); | |
insert into counties values ('Winnebago', 'IA', 13450,10866); | |
insert into counties values ('Winneshiek', 'IA', 21639,21056); | |
insert into counties values ('Woodbury', 'IA', 103917,102172); | |
insert into counties values ('Worth', 'IA', 11068,7598); | |
insert into counties values ('Wright', 'IA', 19652,13229); | |
insert into counties values ('Allen', 'KS', 18187,13371); | |
insert into counties values ('Anderson', 'KS', 10267,8102); | |
insert into counties values ('Atchison', 'KS', 21496,16924); | |
insert into counties values ('Barber', 'KS', 8521,4861); | |
insert into counties values ('Barton', 'KS', 29909,27674); | |
insert into counties values ('Bourbon', 'KS', 19153,15173); | |
insert into counties values ('Brown', 'KS', 14651,9984); | |
insert into counties values ('Butler', 'KS', 31001,65880); | |
insert into counties values ('Chase', 'KS', 4831,2790); | |
insert into counties values ('Chautauqua', 'KS', 7376,3669); | |
insert into counties values ('Cherokee', 'KS', 25144,21603); | |
insert into counties values ('Cheyenne', 'KS', 5668,2726); | |
insert into counties values ('Clark', 'KS', 3946,2215); | |
insert into counties values ('Clay', 'KS', 11697,8535); | |
insert into counties values ('Cloud', 'KS', 16104,9533); | |
insert into counties values ('Coffey', 'KS', 10408,8601); | |
insert into counties values ('Comanche', 'KS', 3888,1891); | |
insert into counties values ('Cowley', 'KS', 36905,36311); | |
insert into counties values ('Crawford', 'KS', 40231,39134); | |
insert into counties values ('Decatur', 'KS', 6185,2961); | |
insert into counties values ('Dickinson', 'KS', 21190,19754); | |
insert into counties values ('Doniphan', 'KS', 10499,7945); | |
insert into counties values ('Douglas', 'KS', 34086,110826); | |
insert into counties values ('Edwards', 'KS', 5936,3037); | |
insert into counties values ('Elk', 'KS', 6679,2882); | |
insert into counties values ('Ellis', 'KS', 19043,28452); | |
insert into counties values ('Ellsworth', 'KS', 8465,6497); | |
insert into counties values ('Finney', 'KS', 15092,36776); | |
insert into counties values ('Ford', 'KS', 19670,33848); | |
insert into counties values ('Franklin', 'KS', 19928,25992); | |
insert into counties values ('Geary', 'KS', 21671,34362); | |
insert into counties values ('Gove', 'KS', 4447,2695); | |
insert into counties values ('Graham', 'KS', 5020,2597); | |
insert into counties values ('Grant', 'KS', 4638,7829); | |
insert into counties values ('Gray', 'KS', 4894,6006); | |
insert into counties values ('Greeley', 'KS', 2010,1247); | |
insert into counties values ('Greenwood', 'KS', 13574,6689); | |
insert into counties values ('Hamilton', 'KS', 3696,2690); | |
insert into counties values ('Harper', 'KS', 10263,6034); | |
insert into counties values ('Harvey', 'KS', 21698,34684); | |
insert into counties values ('Haskell', 'KS', 2606,4256); | |
insert into counties values ('Hodgeman', 'KS', 3310,1916); | |
insert into counties values ('Jackson', 'KS', 11098,13462); | |
insert into counties values ('Jefferson', 'KS', 11084,19126); | |
insert into counties values ('Jewell', 'KS', 9698,3077); | |
insert into counties values ('Johnson', 'KS', 62783,544179); | |
insert into counties values ('Kearny', 'KS', 3492,3977); | |
insert into counties values ('Kingman', 'KS', 10324,7858); | |
insert into counties values ('Kiowa', 'KS', 4743,2553); | |
insert into counties values ('Labette', 'KS', 29285,21607); | |
insert into counties values ('Lane', 'KS', 2808,1750); | |
insert into counties values ('Leavenworth', 'KS', 42361,76227); | |
insert into counties values ('Lincoln', 'KS', 6643,3241); | |
insert into counties values ('Linn', 'KS', 10053,9656); | |
insert into counties values ('Logan', 'KS', 4206,2756); | |
insert into counties values ('Lyon', 'KS', 26576,33690); | |
insert into counties values ('McPherson', 'KS', 23670,29180); | |
insert into counties values ('Marion', 'KS', 16307,12660); | |
insert into counties values ('Marshall', 'KS', 17926,10117); | |
insert into counties values ('Meade', 'KS', 5710,4575); | |
insert into counties values ('Miami', 'KS', 19698,32787); | |
insert into counties values ('Mitchell', 'KS', 10320,6373); | |
insert into counties values ('Montgomery', 'KS', 46487,35471); | |
insert into counties values ('Morris', 'KS', 8485,5923); | |
insert into counties values ('Morton', 'KS', 2610,3233); | |
insert into counties values ('Nemaha', 'KS', 14341,10178); | |
insert into counties values ('Neosho', 'KS', 20348,16512); | |
insert into counties values ('Ness', 'KS', 6322,3107); | |
insert into counties values ('Norton', 'KS', 8808,5671); | |
insert into counties values ('Osage', 'KS', 12811,16295); | |
insert into counties values ('Osborne', 'KS', 8558,3858); | |
insert into counties values ('Ottawa', 'KS', 7265,6091); | |
insert into counties values ('Pawnee', 'KS', 11041,6973); | |
insert into counties values ('Phillips', 'KS', 9273,5642); | |
insert into counties values ('Pottawatomie', 'KS', 12344,21604); | |
insert into counties values ('Pratt', 'KS', 12156,9656); | |
insert into counties values ('Rawlins', 'KS', 5728,2519); | |
insert into counties values ('Reno', 'KS', 54058,64511); | |
insert into counties values ('Republic', 'KS', 11478,4980); | |
insert into counties values ('Rice', 'KS', 15635,10083); | |
insert into counties values ('Riley', 'KS', 33405,71115); | |
insert into counties values ('Rooks', 'KS', 9043,5181); | |
insert into counties values ('Rush', 'KS', 7231,3307); | |
insert into counties values ('Russell', 'KS', 13406,6970); | |
insert into counties values ('Saline', 'KS', 33409,55606); | |
insert into counties values ('Scott', 'KS', 4921,4936); | |
insert into counties values ('Sedgwick', 'KS', 222290,498365); | |
insert into counties values ('Seward', 'KS', 9972,22952); | |
insert into counties values ('Shawnee', 'KS', 105418,177934); | |
insert into counties values ('Sheridan', 'KS', 4607,2556); | |
insert into counties values ('Sherman', 'KS', 7373,6010); | |
insert into counties values ('Smith', 'KS', 8846,3853); | |
insert into counties values ('Stafford', 'KS', 8816,4437); | |
insert into counties values ('Stanton', 'KS', 2263,2235); | |
insert into counties values ('Stevens', 'KS', 4516,5724); | |
insert into counties values ('Sumner', 'KS', 23646,24132); | |
insert into counties values ('Thomas', 'KS', 7572,7900); | |
insert into counties values ('Trego', 'KS', 5868,3001); | |
insert into counties values ('Wabaunsee', 'KS', 7212,7053); | |
insert into counties values ('Wallace', 'KS', 2508,1485); | |
insert into counties values ('Washington', 'KS', 12977,5799); | |
insert into counties values ('Wichita', 'KS', 2640,2234); | |
insert into counties values ('Wilson', 'KS', 14815,9409); | |
insert into counties values ('Woodson', 'KS', 6711,3309); | |
insert into counties values ('Wyandotte', 'KS', 165318,157505); | |
insert into counties values ('Adair', 'KY', 17603,18656); | |
insert into counties values ('Allen', 'KY', 13787,19956); | |
insert into counties values ('Anderson', 'KY', 8984,21421); | |
insert into counties values ('Ballard', 'KY', 8545,8249); | |
insert into counties values ('Barren', 'KY', 28461,42173); | |
insert into counties values ('Bath', 'KY', 10410,11591); | |
insert into counties values ('Bell', 'KY', 47602,28691); | |
insert into counties values ('Boone', 'KY', 13015,118811); | |
insert into counties values ('Bourbon', 'KY', 17752,19985); | |
insert into counties values ('Boyd', 'KY', 49949,49542); | |
insert into counties values ('Boyle', 'KY', 20532,28432); | |
insert into counties values ('Bracken', 'KY', 8424,8488); | |
insert into counties values ('Breathitt', 'KY', 19964,13878); | |
insert into counties values ('Breckinridge', 'KY', 15528,20059); | |
insert into counties values ('Bullitt', 'KY', 11349,74319); | |
insert into counties values ('Butler', 'KY', 11309,12690); | |
insert into counties values ('Caldwell', 'KY', 13199,12984); | |
insert into counties values ('Calloway', 'KY', 20147,37191); | |
insert into counties values ('Campbell', 'KY', 76196,90336); | |
insert into counties values ('Carlisle', 'KY', 6206,5104); | |
insert into counties values ('Carroll', 'KY', 8517,10811); | |
insert into counties values ('Carter', 'KY', 22559,27720); | |
insert into counties values ('Casey', 'KY', 17446,15955); | |
insert into counties values ('Christian', 'KY', 42359,73955); | |
insert into counties values ('Clark', 'KY', 18898,35613); | |
insert into counties values ('Clay', 'KY', 23116,21730); | |
insert into counties values ('Clinton', 'KY', 10605,10272); | |
insert into counties values ('Crittenden', 'KY', 10818,9315); | |
insert into counties values ('Cumberland', 'KY', 9309,6856); | |
insert into counties values ('Daviess', 'KY', 57241,96656); | |
insert into counties values ('Edmonson', 'KY', 9376,12161); | |
insert into counties values ('Elliott', 'KY', 7085,7852); | |
insert into counties values ('Estill', 'KY', 14677,14672); | |
insert into counties values ('Fayette', 'KY', 100746,295803); | |
insert into counties values ('Fleming', 'KY', 11962,14348); | |
insert into counties values ('Floyd', 'KY', 53500,39451); | |
insert into counties values ('Franklin', 'KY', 25933,49285); | |
insert into counties values ('Fulton', 'KY', 13668,6813); | |
insert into counties values ('Gallatin', 'KY', 3969,8589); | |
insert into counties values ('Garrard', 'KY', 11029,16912); | |
insert into counties values ('Grant', 'KY', 9809,24662); | |
insert into counties values ('Graves', 'KY', 31364,37121); | |
insert into counties values ('Grayson', 'KY', 17063,25746); | |
insert into counties values ('Green', 'KY', 11261,11258); | |
insert into counties values ('Greenup', 'KY', 24887,36910); | |
insert into counties values ('Hancock', 'KY', 6009,8565); | |
insert into counties values ('Hardin', 'KY', 50312,105543); | |
insert into counties values ('Harlan', 'KY', 71751,29278); | |
insert into counties values ('Harrison', 'KY', 13736,18846); | |
insert into counties values ('Hart', 'KY', 15321,18199); | |
insert into counties values ('Henderson', 'KY', 30715,46250); | |
insert into counties values ('Henry', 'KY', 11394,15416); | |
insert into counties values ('Hickman', 'KY', 7778,4902); | |
insert into counties values ('Hopkins', 'KY', 38815,46920); | |
insert into counties values ('Jackson', 'KY', 13101,13494); | |
insert into counties values ('Jefferson', 'KY', 484615,741096); | |
insert into counties values ('Jessamine', 'KY', 12458,48586); | |
insert into counties values ('Johnson', 'KY', 23846,23356); | |
insert into counties values ('Kenton', 'KY', 104254,159720); | |
insert into counties values ('Knott', 'KY', 20320,16346); | |
insert into counties values ('Knox', 'KY', 30409,31883); | |
insert into counties values ('Larue', 'KY', 9956,14193); | |
insert into counties values ('Laurel', 'KY', 25797,58849); | |
insert into counties values ('Lawrence', 'KY', 14418,15860); | |
insert into counties values ('Lee', 'KY', 8739,7887); | |
insert into counties values ('Leslie', 'KY', 15537,11310); | |
insert into counties values ('Letcher', 'KY', 39522,24519); | |
insert into counties values ('Lewis', 'KY', 13520,13870); | |
insert into counties values ('Lincoln', 'KY', 18668,24742); | |
insert into counties values ('Livingston', 'KY', 7184,9519); | |
insert into counties values ('Logan', 'KY', 22335,26835); | |
insert into counties values ('Lyon', 'KY', 6853,8314); | |
insert into counties values ('McCracken', 'KY', 49137,65565); | |
insert into counties values ('McCreary', 'KY', 16660,18306); | |
insert into counties values ('McLean', 'KY', 10021,9531); | |
insert into counties values ('Madison', 'KY', 31179,82916); | |
insert into counties values ('Magoffin', 'KY', 13839,13333); | |
insert into counties values ('Marion', 'KY', 17212,19820); | |
insert into counties values ('Marshall', 'KY', 13387,31448); | |
insert into counties values ('Martin', 'KY', 11677,12929); | |
insert into counties values ('Mason', 'KY', 18486,17490); | |
insert into counties values ('Meade', 'KY', 9422,28602); | |
insert into counties values ('Menifee', 'KY', 4798,6306); | |
insert into counties values ('Mercer', 'KY', 14643,21331); | |
insert into counties values ('Metcalfe', 'KY', 9851,10099); | |
insert into counties values ('Monroe', 'KY', 13770,10963); | |
insert into counties values ('Montgomery', 'KY', 13025,26499); | |
insert into counties values ('Morgan', 'KY', 13624,13923); | |
insert into counties values ('Muhlenberg', 'KY', 32501,31499); | |
insert into counties values ('Nelson', 'KY', 19521,43437); | |
insert into counties values ('Nicholas', 'KY', 7532,7135); | |
insert into counties values ('Ohio', 'KY', 20840,23842); | |
insert into counties values ('Oldham', 'KY', 11018,60316); | |
insert into counties values ('Owen', 'KY', 9755,10841); | |
insert into counties values ('Owsley', 'KY', 7324,4755); | |
insert into counties values ('Pendleton', 'KY', 9610,14877); | |
insert into counties values ('Perry', 'KY', 46566,28712); | |
insert into counties values ('Pike', 'KY', 81154,65024); | |
insert into counties values ('Powell', 'KY', 6812,12613); | |
insert into counties values ('Pulaski', 'KY', 38452,63063); | |
insert into counties values ('Robertson', 'KY', 2881,2282); | |
insert into counties values ('Rockcastle', 'KY', 13925,17056); | |
insert into counties values ('Rowan', 'KY', 12708,23333); | |
insert into counties values ('Russell', 'KY', 13717,17565); | |
insert into counties values ('Scott', 'KY', 15141,47173); | |
insert into counties values ('Shelby', 'KY', 17912,42074); | |
insert into counties values ('Simpson', 'KY', 11678,17327); | |
insert into counties values ('Spencer', 'KY', 6157,17061); | |
insert into counties values ('Taylor', 'KY', 14403,24512); | |
insert into counties values ('Todd', 'KY', 12890,12460); | |
insert into counties values ('Trigg', 'KY', 9683,14339); | |
insert into counties values ('Trimble', 'KY', 5148,8809); | |
insert into counties values ('Union', 'KY', 14893,15007); | |
insert into counties values ('Warren', 'KY', 42758,113792); | |
insert into counties values ('Washington', 'KY', 12777,11717); | |
insert into counties values ('Wayne', 'KY', 16475,20813); | |
insert into counties values ('Webster', 'KY', 15555,13621); | |
insert into counties values ('Whitley', 'KY', 31940,35637); | |
insert into counties values ('Wolfe', 'KY', 7615,7355); | |
insert into counties values ('Woodford', 'KY', 11212,24939); | |
insert into counties values ('Acadia', 'LA', 47050,61773); | |
insert into counties values ('Allen', 'LA', 18835,25764); | |
insert into counties values ('Ascension', 'LA', 22387,107215); | |
insert into counties values ('Assumption', 'LA', 17278,23421); | |
insert into counties values ('Avoyelles', 'LA', 38031,42073); | |
insert into counties values ('Beauregard', 'LA', 17766,35654); | |
insert into counties values ('Bienville', 'LA', 19105,14353); | |
insert into counties values ('Bossier', 'LA', 40139,116979); | |
insert into counties values ('Caddo', 'LA', 176547,254969); | |
insert into counties values ('Calcasieu', 'LA', 89635,192768); | |
insert into counties values ('Caldwell', 'LA', 10293,10132); | |
insert into counties values ('Cameron', 'LA', 6244,6839); | |
insert into counties values ('Catahoula', 'LA', 11834,10407); | |
insert into counties values ('Claiborne', 'LA', 25063,17195); | |
insert into counties values ('Concordia', 'LA', 14398,20822); | |
insert into counties values ('De Soto', 'LA', 24398,26656); | |
insert into counties values ('East Baton Rouge', 'LA', 158236,440171); | |
insert into counties values ('East Carroll', 'LA', 16302,7759); | |
insert into counties values ('East Feliciana', 'LA', 19133,20267); | |
insert into counties values ('Evangeline', 'LA', 31629,33984); | |
insert into counties values ('Franklin', 'LA', 29376,20767); | |
insert into counties values ('Grant', 'LA', 14263,22309); | |
insert into counties values ('Iberia', 'LA', 40059,73240); | |
insert into counties values ('Iberville', 'LA', 26750,33387); | |
insert into counties values ('Jackson', 'LA', 15434,16274); | |
insert into counties values ('Jefferson', 'LA', 103873,432552); | |
insert into counties values ('Jefferson Davis', 'LA', 26298,31594); | |
insert into counties values ('Lafayette', 'LA', 57743,221578); | |
insert into counties values ('Lafourche', 'LA', 42209,96318); | |
insert into counties values ('La Salle', 'LA', 12717,14890); | |
insert into counties values ('Lincoln', 'LA', 25782,46735); | |
insert into counties values ('Livingston', 'LA', 20054,128026); | |
insert into counties values ('Madison', 'LA', 17451,12093); | |
insert into counties values ('Morehouse', 'LA', 32038,27979); | |
insert into counties values ('Natchitoches', 'LA', 38144,39566); | |
insert into counties values ('Orleans', 'LA', 570445,343829); | |
insert into counties values ('Ouachita', 'LA', 74713,153720); | |
insert into counties values ('Plaquemines', 'LA', 14239,23042); | |
insert into counties values ('Pointe Coupee', 'LA', 21841,22802); | |
insert into counties values ('Rapides', 'LA', 90648,131613); | |
insert into counties values ('Red River', 'LA', 12113,9091); | |
insert into counties values ('Richland', 'LA', 26672,20725); | |
insert into counties values ('Sabine', 'LA', 20880,24233); | |
insert into counties values ('St. Bernard', 'LA', 11087,35897); | |
insert into counties values ('St. Charles', 'LA', 13363,52780); | |
insert into counties values ('St. Helena', 'LA', 9013,11203); | |
insert into counties values ('St. James', 'LA', 15334,22102); | |
insert into counties values ('St. John the Baptist', 'LA', 14861,45924); | |
insert into counties values ('St. Landry', 'LA', 78476,83384); | |
insert into counties values ('St. Martin', 'LA', 26353,52160); | |
insert into counties values ('St. Mary', 'LA', 35848,54650); | |
insert into counties values ('St. Tammany', 'LA', 26988,233740); | |
insert into counties values ('Tangipahoa', 'LA', 53218,121097); | |
insert into counties values ('Tensas', 'LA', 13209,5252); | |
insert into counties values ('Terrebonne', 'LA', 43328,111860); | |
insert into counties values ('Union', 'LA', 19141,22721); | |
insert into counties values ('Vermilion', 'LA', 36929,57999); | |
insert into counties values ('Vernon', 'LA', 18974,52334); | |
insert into counties values ('Washington', 'LA', 38371,47168); | |
insert into counties values ('Webster', 'LA', 35704,41207); | |
insert into counties values ('West Baton Rouge', 'LA', 11738,23788); | |
insert into counties values ('West Carroll', 'LA', 17248,11604); | |
insert into counties values ('West Feliciana', 'LA', 10169,15625); | |
insert into counties values ('Winn', 'LA', 16119,15313); | |
insert into counties values ('Androscoggin', 'ME', 83594,107702); | |
insert into counties values ('Aroostook', 'ME', 96039,71870); | |
insert into counties values ('Cumberland', 'ME', 169201,281674); | |
insert into counties values ('Franklin', 'ME', 20682,30768); | |
insert into counties values ('Hancock', 'ME', 32105,54418); | |
insert into counties values ('Kennebec', 'ME', 83881,122151); | |
insert into counties values ('Knox', 'ME', 28121,39736); | |
insert into counties values ('Lincoln', 'ME', 18004,34457); | |
insert into counties values ('Oxford', 'ME', 44221,57833); | |
insert into counties values ('Penobscot', 'ME', 108198,153923); | |
insert into counties values ('Piscataquis', 'ME', 18617,17535); | |
insert into counties values ('Sagadahoc', 'ME', 20911,35293); | |
insert into counties values ('Somerset', 'ME', 39785,52228); | |
insert into counties values ('Waldo', 'ME', 21687,38786); | |
insert into counties values ('Washington', 'ME', 35187,32856); | |
insert into counties values ('York', 'ME', 93541,197131); | |
insert into counties values ('Allegany', 'MD', 89556,75087); | |
insert into counties values ('Anne Arundel', 'MD', 117392,537656); | |
insert into counties values ('Baltimore', 'MD', 270273,805029); | |
insert into counties values ('Calvert', 'MD', 12100,88737); | |
insert into counties values ('Caroline', 'MD', 18234,33066); | |
insert into counties values ('Carroll', 'MD', 44907,167134); | |
insert into counties values ('Cecil', 'MD', 33356,101108); | |
insert into counties values ('Charles', 'MD', 23415,146551); | |
insert into counties values ('Dorchester', 'MD', 27815,32618); | |
insert into counties values ('Frederick', 'MD', 62287,233385); | |
insert into counties values ('Garrett', 'MD', 21259,30097); | |
insert into counties values ('Harford', 'MD', 51782,244826); | |
insert into counties values ('Howard', 'MD', 23119,287085); | |
insert into counties values ('Kent', 'MD', 13677,20197); | |
insert into counties values ('Montgomery', 'MD', 164401,971777); | |
insert into counties values ('Prince Georges', 'MD', 194182,863420); | |
insert into counties values ('Queen Annes', 'MD', 14579,47798); | |
insert into counties values ('St. Marys', 'MD', 29111,105151); | |
insert into counties values ('Somerset', 'MD', 20745,26470); | |
insert into counties values ('Talbot', 'MD', 19428,37782); | |
insert into counties values ('Washington', 'MD', 78886,147430); | |
insert into counties values ('Wicomico', 'MD', 39641,98733); | |
insert into counties values ('Worcester', 'MD', 23148,51454); | |
insert into counties values ('Baltimore city', 'MD', 949708,620961); | |
insert into counties values ('Barnstable', 'MA', 46805,215888); | |
insert into counties values ('Berkshire', 'MA', 132966,131219); | |
insert into counties values ('Bristol', 'MA', 381569,548285); | |
insert into counties values ('Dukes', 'MA', 5633,16535); | |
insert into counties values ('Essex', 'MA', 522384,743159); | |
insert into counties values ('Franklin', 'MA', 52747,71372); | |
insert into counties values ('Hampden', 'MA', 367971,463490); | |
insert into counties values ('Hampshire', 'MA', 87594,158080); | |
insert into counties values ('Middlesex', 'MA', 1064569,1503085); | |
insert into counties values ('Nantucket', 'MA', 3484,10172); | |
insert into counties values ('Norfolk', 'MA', 392308,670850); | |
insert into counties values ('Plymouth', 'MA', 189468,494919); | |
insert into counties values ('Suffolk', 'MA', 896615,722023); | |
insert into counties values ('Worcester', 'MA', 546401,798552); | |
insert into counties values ('Alcona', 'MI', 5856,10942); | |
insert into counties values ('Alger', 'MI', 10007,9601); | |
insert into counties values ('Allegan', 'MI', 47493,111408); | |
insert into counties values ('Alpena', 'MI', 22189,29598); | |
insert into counties values ('Antrim', 'MI', 10721,23580); | |
insert into counties values ('Arenac', 'MI', 9644,15899); | |
insert into counties values ('Baraga', 'MI', 8037,8860); | |
insert into counties values ('Barry', 'MI', 26183,59173); | |
insert into counties values ('Bay', 'MI', 88461,107771); | |
insert into counties values ('Benzie', 'MI', 8306,17525); | |
insert into counties values ('Berrien', 'MI', 115702,156813); | |
insert into counties values ('Branch', 'MI', 30202,45248); | |
insert into counties values ('Calhoun', 'MI', 120813,136146); | |
insert into counties values ('Cass', 'MI', 28185,52293); | |
insert into counties values ('Charlevoix', 'MI', 13475,25949); | |
insert into counties values ('Cheboygan', 'MI', 13731,26152); | |
insert into counties values ('Chippewa', 'MI', 29206,38520); | |
insert into counties values ('Clare', 'MI', 10253,30926); | |
insert into counties values ('Clinton', 'MI', 31195,75382); | |
insert into counties values ('Crawford', 'MI', 4151,14074); | |
insert into counties values ('Delta', 'MI', 32913,37069); | |
insert into counties values ('Dickinson', 'MI', 24844,26168); | |
insert into counties values ('Eaton', 'MI', 40023,107759); | |
insert into counties values ('Emmet', 'MI', 16534,32694); | |
insert into counties values ('Genesee', 'MI', 270963,425790); | |
insert into counties values ('Gladwin', 'MI', 9451,25692); | |
insert into counties values ('Gogebic', 'MI', 27053,16427); | |
insert into counties values ('Grand Traverse', 'MI', 28598,86986); | |
insert into counties values ('Gratiot', 'MI', 33429,42476); | |
insert into counties values ('Hillsdale', 'MI', 31916,46688); | |
insert into counties values ('Houghton', 'MI', 39771,36628); | |
insert into counties values ('Huron', 'MI', 33149,33118); | |
insert into counties values ('Ingham', 'MI', 172941,280895); | |
insert into counties values ('Ionia', 'MI', 38158,63905); | |
insert into counties values ('Iosco', 'MI', 10906,25887); | |
insert into counties values ('Iron', 'MI', 17692,11817); | |
insert into counties values ('Isabella', 'MI', 28964,70311); | |
insert into counties values ('Jackson', 'MI', 107925,160248); | |
insert into counties values ('Kalamazoo', 'MI', 126707,250331); | |
insert into counties values ('Kalkaska', 'MI', 4597,17153); | |
insert into counties values ('Kent', 'MI', 288292,602622); | |
insert into counties values ('Keweenaw', 'MI', 2918,2156); | |
insert into counties values ('Lake', 'MI', 5257,11539); | |
insert into counties values ('Lapeer', 'MI', 35794,88319); | |
insert into counties values ('Leelanau', 'MI', 8647,21708); | |
insert into counties values ('Lenawee', 'MI', 64629,99892); | |
insert into counties values ('Livingston', 'MI', 26725,180967); | |
insert into counties values ('Luce', 'MI', 8147,6631); | |
insert into counties values ('Mackinac', 'MI', 9287,11113); | |
insert into counties values ('Macomb', 'MI', 184961,840978); | |
insert into counties values ('Manistee', 'MI', 18524,24733); | |
insert into counties values ('Marquette', 'MI', 47654,67077); | |
insert into counties values ('Mason', 'MI', 20474,28705); | |
insert into counties values ('Mecosta', 'MI', 18968,42798); | |
insert into counties values ('Menominee', 'MI', 25299,24029); | |
insert into counties values ('Midland', 'MI', 35662,83629); | |
insert into counties values ('Missaukee', 'MI', 7458,14849); | |
insert into counties values ('Monroe', 'MI', 75666,152021); | |
insert into counties values ('Montcalm', 'MI', 31013,63342); | |
insert into counties values ('Montmorency', 'MI', 4125,9765); | |
insert into counties values ('Muskegon', 'MI', 121545,172188); | |
insert into counties values ('Newaygo', 'MI', 21567,48460); | |
insert into counties values ('Oakland', 'MI', 396001,1202362); | |
insert into counties values ('Oceana', 'MI', 16105,26570); | |
insert into counties values ('Ogemaw', 'MI', 9345,21699); | |
insert into counties values ('Ontonagon', 'MI', 10282,6780); | |
insert into counties values ('Osceola', 'MI', 13797,23528); | |
insert into counties values ('Oscoda', 'MI', 3134,8640); | |
insert into counties values ('Otsego', 'MI', 6435,24164); | |
insert into counties values ('Ottawa', 'MI', 73751,263801); | |
insert into counties values ('Presque Isle', 'MI', 11996,13376); | |
insert into counties values ('Roscommon', 'MI', 5916,24449); | |
insert into counties values ('Saginaw', 'MI', 153515,200169); | |
insert into counties values ('St. Clair', 'MI', 91599,163040); | |
insert into counties values ('St. Joseph', 'MI', 35071,61295); | |
insert into counties values ('Sanilac', 'MI', 30837,43114); | |
insert into counties values ('Schoolcraft', 'MI', 9148,8485); | |
insert into counties values ('Shiawassee', 'MI', 45967,70648); | |
insert into counties values ('Tuscola', 'MI', 38258,55729); | |
insert into counties values ('Van Buren', 'MI', 39184,76258); | |
insert into counties values ('Washtenaw', 'MI', 134606,344791); | |
insert into counties values ('Wayne', 'MI', 2435235,1820584); | |
insert into counties values ('Wexford', 'MI', 18628,32735); | |
insert into counties values ('Aitkin', 'MN', 14327,16202); | |
insert into counties values ('Anoka', 'MN', 35579,330844); | |
insert into counties values ('Becker', 'MN', 24836,32504); | |
insert into counties values ('Beltrami', 'MN', 24962,44442); | |
insert into counties values ('Benton', 'MN', 15911,38451); | |
insert into counties values ('Big Stone', 'MN', 9607,5269); | |
insert into counties values ('Blue Earth', 'MN', 38327,64013); | |
insert into counties values ('Brown', 'MN', 25895,25893); | |
insert into counties values ('Carlton', 'MN', 24584,35386); | |
insert into counties values ('Carver', 'MN', 18155,91042); | |
insert into counties values ('Cass', 'MN', 19468,28567); | |
insert into counties values ('Chippewa', 'MN', 16739,12441); | |
insert into counties values ('Chisago', 'MN', 12669,53887); | |
insert into counties values ('Clay', 'MN', 30363,58999); | |
insert into counties values ('Clearwater', 'MN', 10204,8695); | |
insert into counties values ('Cook', 'MN', 2900,5176); | |
insert into counties values ('Cottonwood', 'MN', 15763,11687); | |
insert into counties values ('Crow Wing', 'MN', 30875,62500); | |
insert into counties values ('Dakota', 'MN', 49019,398552); | |
insert into counties values ('Dodge', 'MN', 12624,20087); | |
insert into counties values ('Douglas', 'MN', 21304,36009); | |
insert into counties values ('Faribault', 'MN', 23879,14553); | |
insert into counties values ('Fillmore', 'MN', 24465,20866); | |
insert into counties values ('Freeborn', 'MN', 34517,31255); | |
insert into counties values ('Goodhue', 'MN', 32118,46183); | |
insert into counties values ('Grant', 'MN', 9542,6018); | |
insert into counties values ('Hennepin', 'MN', 676579,1152425); | |
insert into counties values ('Houston', 'MN', 14435,19027); | |
insert into counties values ('Hubbard', 'MN', 11085,20428); | |
insert into counties values ('Isanti', 'MN', 12123,37816); | |
insert into counties values ('Itasca', 'MN', 33321,45058); | |
insert into counties values ('Jackson', 'MN', 16306,10266); | |
insert into counties values ('Kanabec', 'MN', 9192,16239); | |
insert into counties values ('Kandiyohi', 'MN', 28644,42239); | |
insert into counties values ('Kittson', 'MN', 9649,4552); | |
insert into counties values ('Koochiching', 'MN', 16910,13311); | |
insert into counties values ('Lac qui Parle', 'MN', 14545,7259); | |
insert into counties values ('Lake', 'MN', 7781,10866); | |
insert into counties values ('Lake of the Woods', 'MN', 4955,4045); | |
insert into counties values ('Le Sueur', 'MN', 19088,27703); | |
insert into counties values ('Lincoln', 'MN', 10150,5896); | |
insert into counties values ('Lyon', 'MN', 22253,25857); | |
insert into counties values ('McLeod', 'MN', 22198,36651); | |
insert into counties values ('Mahnomen', 'MN', 7059,5413); | |
insert into counties values ('Marshall', 'MN', 16125,9439); | |
insert into counties values ('Martin', 'MN', 25655,20840); | |
insert into counties values ('Meeker', 'MN', 18966,23300); | |
insert into counties values ('Mille Lacs', 'MN', 15165,26097); | |
insert into counties values ('Morrison', 'MN', 25832,33198); | |
insert into counties values ('Mower', 'MN', 42277,39163); | |
insert into counties values ('Murray', 'MN', 14801,8725); | |
insert into counties values ('Nicollet', 'MN', 20929,32727); | |
insert into counties values ('Nobles', 'MN', 22435,21378); | |
insert into counties values ('Norman', 'MN', 12909,6852); | |
insert into counties values ('Olmsted', 'MN', 48228,144248); | |
insert into counties values ('Otter Tail', 'MN', 51320,57303); | |
insert into counties values ('Pennington', 'MN', 12965,13930); | |
insert into counties values ('Pine', 'MN', 18223,29750); | |
insert into counties values ('Pipestone', 'MN', 14003,9596); | |
insert into counties values ('Polk', 'MN', 35900,31600); | |
insert into counties values ('Pope', 'MN', 12862,10995); | |
insert into counties values ('Ramsey', 'MN', 355332,508640); | |
insert into counties values ('Red Lake', 'MN', 6806,4089); | |
insert into counties values ('Redwood', 'MN', 22127,16059); | |
insert into counties values ('Renville', 'MN', 23954,15730); | |
insert into counties values ('Rice', 'MN', 36235,64142); | |
insert into counties values ('Rock', 'MN', 11278,9687); | |
insert into counties values ('Roseau', 'MN', 14505,15629); | |
insert into counties values ('St. Louis', 'MN', 206062,200226); | |
insert into counties values ('Scott', 'MN', 16486,129928); | |
insert into counties values ('Sherburne', 'MN', 10661,88499); | |
insert into counties values ('Sibley', 'MN', 15816,15226); | |
insert into counties values ('Stearns', 'MN', 70681,150642); | |
insert into counties values ('Steele', 'MN', 21155,36576); | |
insert into counties values ('Stevens', 'MN', 11106,9726); | |
insert into counties values ('Swift', 'MN', 15837,9783); | |
insert into counties values ('Todd', 'MN', 25420,24895); | |
insert into counties values ('Traverse', 'MN', 8053,3558); | |
insert into counties values ('Wabasha', 'MN', 16878,21676); | |
insert into counties values ('Wadena', 'MN', 12806,13843); | |
insert into counties values ('Waseca', 'MN', 14957,19136); | |
insert into counties values ('Washington', 'MN', 34544,238136); | |
insert into counties values ('Watonwan', 'MN', 13881,11211); | |
insert into counties values ('Wilkin', 'MN', 10567,6576); | |
insert into counties values ('Winona', 'MN', 39841,51461); | |
insert into counties values ('Wright', 'MN', 27716,124700); | |
insert into counties values ('Yellow Medicine', 'MN', 16279,10438); | |
insert into counties values ('Adams', 'MS', 32256,32297); | |
insert into counties values ('Alcorn', 'MS', 27158,37057); | |
insert into counties values ('Amite', 'MS', 19261,13131); | |
insert into counties values ('Attala', 'MS', 26652,19564); | |
insert into counties values ('Benton', 'MS', 8793,8729); | |
insert into counties values ('Bolivar', 'MS', 63004,34145); | |
insert into counties values ('Calhoun', 'MS', 18369,14962); | |
insert into counties values ('Carroll', 'MS', 15499,10597); | |
insert into counties values ('Chickasaw', 'MS', 18951,17392); | |
insert into counties values ('Choctaw', 'MS', 11009,8547); | |
insert into counties values ('Claiborne', 'MS', 11944,9604); | |
insert into counties values ('Clarke', 'MS', 19362,16732); | |
insert into counties values ('Clay', 'MS', 17757,20634); | |
insert into counties values ('Coahoma', 'MS', 49361,26151); | |
insert into counties values ('Copiah', 'MS', 30493,29449); | |
insert into counties values ('Covington', 'MS', 16036,19568); | |
insert into counties values ('DeSoto', 'MS', 24599,161252); | |
insert into counties values ('Forrest', 'MS', 45055,74934); | |
insert into counties values ('Franklin', 'MS', 10929,8118); | |
insert into counties values ('George', 'MS', 10012,22578); | |
insert into counties values ('Greene', 'MS', 8215,14400); | |
insert into counties values ('Grenada', 'MS', 18830,21906); | |
insert into counties values ('Hancock', 'MS', 11891,43929); | |
insert into counties values ('Harrison', 'MS', 84073,187105); | |
insert into counties values ('Hinds', 'MS', 142164,245285); | |
insert into counties values ('Holmes', 'MS', 33301,19198); | |
insert into counties values ('Humphreys', 'MS', 23115,9375); | |
insert into counties values ('Issaquena', 'MS', 4966,1406); | |
insert into counties values ('Itawamba', 'MS', 17216,23401); | |
insert into counties values ('Jackson', 'MS', 31401,139668); | |
insert into counties values ('Jasper', 'MS', 18912,17062); | |
insert into counties values ('Jefferson', 'MS', 11306,7726); | |
insert into counties values ('Jefferson Davis', 'MS', 15500,12487); | |
insert into counties values ('Jones', 'MS', 57235,67761); | |
insert into counties values ('Kemper', 'MS', 15893,10456); | |
insert into counties values ('Lafayette', 'MS', 22798,47351); | |
insert into counties values ('Lamar', 'MS', 13225,55658); | |
insert into counties values ('Lauderdale', 'MS', 64171,80261); | |
insert into counties values ('Lawrence', 'MS', 12639,12929); | |
insert into counties values ('Leake', 'MS', 21610,23805); | |
insert into counties values ('Lee', 'MS', 38237,82910); | |
insert into counties values ('Leflore', 'MS', 51813,32317); | |
insert into counties values ('Lincoln', 'MS', 27899,34869); | |
insert into counties values ('Lowndes', 'MS', 37852,59779); | |
insert into counties values ('Madison', 'MS', 33860,95203); | |
insert into counties values ('Marion', 'MS', 23967,27088); | |
insert into counties values ('Marshall', 'MS', 25106,37144); | |
insert into counties values ('Monroe', 'MS', 36543,36989); | |
insert into counties values ('Montgomery', 'MS', 14470,10925); | |
insert into counties values ('Neshoba', 'MS', 25730,29676); | |
insert into counties values ('Newton', 'MS', 22681,21720); | |
insert into counties values ('Noxubee', 'MS', 20022,11545); | |
insert into counties values ('Oktibbeha', 'MS', 24569,47671); | |
insert into counties values ('Panola', 'MS', 31271,34707); | |
insert into counties values ('Pearl River', 'MS', 20641,55834); | |
insert into counties values ('Perry', 'MS', 9108,12250); | |
insert into counties values ('Pike', 'MS', 35137,40404); | |
insert into counties values ('Pontotoc', 'MS', 19994,29957); | |
insert into counties values ('Prentiss', 'MS', 19810,25276); | |
insert into counties values ('Quitman', 'MS', 25885,8223); | |
insert into counties values ('Rankin', 'MS', 28881,141617); | |
insert into counties values ('Scott', 'MS', 21681,28264); | |
insert into counties values ('Sharkey', 'MS', 12903,4916); | |
insert into counties values ('Simpson', 'MS', 21819,27503); | |
insert into counties values ('Smith', 'MS', 16740,16491); | |
insert into counties values ('Stone', 'MS', 6264,17786); | |
insert into counties values ('Sunflower', 'MS', 56031,29450); | |
insert into counties values ('Tallahatchie', 'MS', 30486,15378); | |
insert into counties values ('Tate', 'MS', 18011,28886); | |
insert into counties values ('Tippah', 'MS', 17522,22232); | |
insert into counties values ('Tishomingo', 'MS', 15544,19593); | |
insert into counties values ('Tunica', 'MS', 21664,10778); | |
insert into counties values ('Union', 'MS', 20262,27134); | |
insert into counties values ('Walthall', 'MS', 15563,15443); | |
insert into counties values ('Warren', 'MS', 39616,48773); | |
insert into counties values ('Washington', 'MS', 70504,51137); | |
insert into counties values ('Wayne', 'MS', 17010,20747); | |
insert into counties values ('Webster', 'MS', 11607,10253); | |
insert into counties values ('Wilkinson', 'MS', 14116,9878); | |
insert into counties values ('Winston', 'MS', 22231,19198); | |
insert into counties values ('Yalobusha', 'MS', 15191,12678); | |
insert into counties values ('Yazoo', 'MS', 35712,28065); | |
insert into counties values ('Adair', 'MO', 19689,25607); | |
insert into counties values ('Andrew', 'MO', 11727,17291); | |
insert into counties values ('Atchison', 'MO', 11127,5685); | |
insert into counties values ('Audrain', 'MO', 23829,25529); | |
insert into counties values ('Barry', 'MO', 21755,35597); | |
insert into counties values ('Barton', 'MO', 12678,12402); | |
insert into counties values ('Bates', 'MO', 17534,17049); | |
insert into counties values ('Benton', 'MO', 9080,19056); | |
insert into counties values ('Bollinger', 'MO', 11019,12363); | |
insert into counties values ('Boone', 'MO', 48432,162642); | |
insert into counties values ('Buchanan', 'MO', 96826,89201); | |
insert into counties values ('Butler', 'MO', 37707,42794); | |
insert into counties values ('Caldwell', 'MO', 9929,9424); | |
insert into counties values ('Callaway', 'MO', 23316,44332); | |
insert into counties values ('Camden', 'MO', 7861,44002); | |
insert into counties values ('Cape Girardeau', 'MO', 38397,75674); | |
insert into counties values ('Carroll', 'MO', 15589,9295); | |
insert into counties values ('Carter', 'MO', 4777,6265); | |
insert into counties values ('Cass', 'MO', 19325,99478); | |
insert into counties values ('Cedar', 'MO', 10663,13982); | |
insert into counties values ('Chariton', 'MO', 14944,7831); | |
insert into counties values ('Christian', 'MO', 12412,77422); | |
insert into counties values ('Clark', 'MO', 9003,7139); | |
insert into counties values ('Clay', 'MO', 45221,221939); | |
insert into counties values ('Clinton', 'MO', 11726,20743); | |
insert into counties values ('Cole', 'MO', 35464,75990); | |
insert into counties values ('Cooper', 'MO', 16608,17601); | |
insert into counties values ('Crawford', 'MO', 11615,24696); | |
insert into counties values ('Dade', 'MO', 9324,7883); | |
insert into counties values ('Dallas', 'MO', 10392,16777); | |
insert into counties values ('Daviess', 'MO', 11180,8433); | |
insert into counties values ('DeKalb', 'MO', 8047,12892); | |
insert into counties values ('Dent', 'MO', 10936,15657); | |
insert into counties values ('Douglas', 'MO', 12638,13684); | |
insert into counties values ('Dunklin', 'MO', 45329,31953); | |
insert into counties values ('Franklin', 'MO', 36046,101492); | |
insert into counties values ('Gasconade', 'MO', 12342,15222); | |
insert into counties values ('Gentry', 'MO', 11036,6738); | |
insert into counties values ('Greene', 'MO', 104823,275174); | |
insert into counties values ('Grundy', 'MO', 13220,10261); | |
insert into counties values ('Harrison', 'MO', 14107,8957); | |
insert into counties values ('Henry', 'MO', 20043,22272); | |
insert into counties values ('Hickory', 'MO', 5387,9627); | |
insert into counties values ('Holt', 'MO', 9833,4912); | |
insert into counties values ('Howard', 'MO', 11857,10144); | |
insert into counties values ('Howell', 'MO', 22725,40400); | |
insert into counties values ('Iron', 'MO', 9458,10630); | |
insert into counties values ('Jackson', 'MO', 541035,674158); | |
insert into counties values ('Jasper', 'MO', 79106,117404); | |
insert into counties values ('Jefferson', 'MO', 38007,218733); | |
insert into counties values ('Johnson', 'MO', 20716,52595); | |
insert into counties values ('Knox', 'MO', 7617,4131); | |
insert into counties values ('Laclede', 'MO', 19010,35571); | |
insert into counties values ('Lafayette', 'MO', 25272,33381); | |
insert into counties values ('Lawrence', 'MO', 23420,38634); | |
insert into counties values ('Lewis', 'MO', 10733,10211); | |
insert into counties values ('Lincoln', 'MO', 13478,52566); | |
insert into counties values ('Linn', 'MO', 18865,12761); | |
insert into counties values ('Livingston', 'MO', 16532,15195); | |
insert into counties values ('McDonald', 'MO', 14144,23083); | |
insert into counties values ('Macon', 'MO', 18332,15566); | |
insert into counties values ('Madison', 'MO', 10380,12226); | |
insert into counties values ('Maries', 'MO', 7423,9176); | |
insert into counties values ('Marion', 'MO', 29765,28781); | |
insert into counties values ('Mercer', 'MO', 7235,3785); | |
insert into counties values ('Miller', 'MO', 13734,24748); | |
insert into counties values ('Mississippi', 'MO', 22551,14358); | |
insert into counties values ('Moniteau', 'MO', 10840,15607); | |
insert into counties values ('Monroe', 'MO', 11314,8840); | |
insert into counties values ('Montgomery', 'MO', 11555,12236); | |
insert into counties values ('Morgan', 'MO', 10207,20565); | |
insert into counties values ('New Madrid', 'MO', 39444,18956); | |
insert into counties values ('Newton', 'MO', 28240,58114); | |
insert into counties values ('Nodaway', 'MO', 24033,23370); | |
insert into counties values ('Oregon', 'MO', 11978,10881); | |
insert into counties values ('Osage', 'MO', 11301,13878); | |
insert into counties values ('Ozark', 'MO', 8856,9723); | |
insert into counties values ('Pemiscot', 'MO', 45624,18296); | |
insert into counties values ('Perry', 'MO', 14890,18971); | |
insert into counties values ('Pettis', 'MO', 31577,42201); | |
insert into counties values ('Phelps', 'MO', 21504,45156); | |
insert into counties values ('Pike', 'MO', 16844,18516); | |
insert into counties values ('Platte', 'MO', 14973,89322); | |
insert into counties values ('Polk', 'MO', 16062,31137); | |
insert into counties values ('Pulaski', 'MO', 10392,52274); | |
insert into counties values ('Putnam', 'MO', 9166,4979); | |
insert into counties values ('Ralls', 'MO', 8686,10167); | |
insert into counties values ('Randolph', 'MO', 22918,25414); | |
insert into counties values ('Ray', 'MO', 15932,23494); | |
insert into counties values ('Reynolds', 'MO', 6918,6696); | |
insert into counties values ('Ripley', 'MO', 11414,14100); | |
insert into counties values ('St. Charles', 'MO', 29834,360485); | |
insert into counties values ('St. Clair', 'MO', 10482,9805); | |
insert into counties values ('Ste. Genevieve', 'MO', 11237,18145); | |
insert into counties values ('St. Francois', 'MO', 35276,65359); | |
insert into counties values ('St. Louis', 'MO', 406349,998954); | |
insert into counties values ('Saline', 'MO', 26694,23370); | |
insert into counties values ('Schuyler', 'MO', 5760,4431); | |
insert into counties values ('Scotland', 'MO', 7332,4843); | |
insert into counties values ('Scott', 'MO', 32842,39191); | |
insert into counties values ('Shannon', 'MO', 8377,8441); | |
insert into counties values ('Shelby', 'MO', 9730,6373); | |
insert into counties values ('Stoddard', 'MO', 33463,29968); | |
insert into counties values ('Stone', 'MO', 9748,32202); | |
insert into counties values ('Sullivan', 'MO', 11299,6714); | |
insert into counties values ('Taney', 'MO', 9863,51675); | |
insert into counties values ('Texas', 'MO', 18992,26008); | |
insert into counties values ('Vernon', 'MO', 22685,21159); | |
insert into counties values ('Warren', 'MO', 7666,32513); | |
insert into counties values ('Washington', 'MO', 14689,25195); | |
insert into counties values ('Wayne', 'MO', 10514,13521); | |
insert into counties values ('Webster', 'MO', 15072,36202); | |
insert into counties values ('Worth', 'MO', 5120,2171); | |
insert into counties values ('Wright', 'MO', 15834,18815); | |
insert into counties values ('St. Louis city', 'MO', 856796,319294); | |
insert into counties values ('Beaverhead', 'MT', 6671,9246); | |
insert into counties values ('Big Horn', 'MT', 9824,12865); | |
insert into counties values ('Blaine', 'MT', 8516,6491); | |
insert into counties values ('Broadwater', 'MT', 2922,5612); | |
insert into counties values ('Carbon', 'MT', 10241,10078); | |
insert into counties values ('Carter', 'MT', 2798,1160); | |
insert into counties values ('Cascade', 'MT', 53027,81327); | |
insert into counties values ('Chouteau', 'MT', 6974,5813); | |
insert into counties values ('Custer', 'MT', 12661,11699); | |
insert into counties values ('Daniels', 'MT', 3946,1751); | |
insert into counties values ('Dawson', 'MT', 9092,8966); | |
insert into counties values ('Deer Lodge', 'MT', 16553,9298); | |
insert into counties values ('Fallon', 'MT', 3660,2890); | |
insert into counties values ('Fergus', 'MT', 14015,11586); | |
insert into counties values ('Flathead', 'MT', 31495,90928); | |
insert into counties values ('Gallatin', 'MT', 21902,89513); | |
insert into counties values ('Garfield', 'MT', 2172,1206); | |
insert into counties values ('Glacier', 'MT', 9645,13399); | |
insert into counties values ('Golden Valley', 'MT', 1337,884); | |
insert into counties values ('Granite', 'MT', 2773,3079); | |
insert into counties values ('Hill', 'MT', 14285,16096); | |
insert into counties values ('Jefferson', 'MT', 4014,11406); | |
insert into counties values ('Judith Basin', 'MT', 3200,2072); | |
insert into counties values ('Lake', 'MT', 13835,28746); | |
insert into counties values ('Lewis and Clark', 'MT', 24540,63395); | |
insert into counties values ('Liberty', 'MT', 2180,2339); | |
insert into counties values ('Lincoln', 'MT', 8693,19687); | |
insert into counties values ('McCone', 'MT', 3258,1734); | |
insert into counties values ('Madison', 'MT', 5998,7691); | |
insert into counties values ('Meagher', 'MT', 2079,1891); | |
insert into counties values ('Mineral', 'MT', 2081,4223); | |
insert into counties values ('Missoula', 'MT', 35493,109299); | |
insert into counties values ('Musselshell', 'MT', 5408,4538); | |
insert into counties values ('Park', 'MT', 11999,15636); | |
insert into counties values ('Petroleum', 'MT', 1026,494); | |
insert into counties values ('Phillips', 'MT', 6334,4253); | |
insert into counties values ('Pondera', 'MT', 6392,6153); | |
insert into counties values ('Powder River', 'MT', 2693,1743); | |
insert into counties values ('Powell', 'MT', 6301,7027); | |
insert into counties values ('Prairie', 'MT', 2377,1179); | |
insert into counties values ('Ravalli', 'MT', 13101,40212); | |
insert into counties values ('Richland', 'MT', 10366,9746); | |
insert into counties values ('Roosevelt', 'MT', 9580,10425); | |
insert into counties values ('Rosebud', 'MT', 6570,9233); | |
insert into counties values ('Sanders', 'MT', 6983,11413); | |
insert into counties values ('Sheridan', 'MT', 6674,3384); | |
insert into counties values ('Silver Bow', 'MT', 48422,34200); | |
insert into counties values ('Stillwater', 'MT', 5416,9117); | |
insert into counties values ('Sweet Grass', 'MT', 3621,3651); | |
insert into counties values ('Teton', 'MT', 7232,6073); | |
insert into counties values ('Toole', 'MT', 6867,5324); | |
insert into counties values ('Treasure', 'MT', 1402,718); | |
insert into counties values ('Valley', 'MT', 11353,7369); | |
insert into counties values ('Wheatland', 'MT', 3187,2168); | |
insert into counties values ('Wibaux', 'MT', 1907,1017); | |
insert into counties values ('Yellowstone', 'MT', 55875,147972); | |
insert into counties values ('Yellowstone National Park', 'MT', 58,0); | |
insert into counties values ('Adams', 'NE', 28855,31364); | |
insert into counties values ('Antelope', 'NE', 11624,6685); | |
insert into counties values ('Arthur', 'NE', 803,460); | |
insert into counties values ('Banner', 'NE', 1325,690); | |
insert into counties values ('Blaine', 'NE', 1203,478); | |
insert into counties values ('Boone', 'NE', 10721,5505); | |
insert into counties values ('Box Butte', 'NE', 12279,11308); | |
insert into counties values ('Boyd', 'NE', 4911,2099); | |
insert into counties values ('Brown', 'NE', 5164,3145); | |
insert into counties values ('Buffalo', 'NE', 25134,46102); | |
insert into counties values ('Burt', 'NE', 11536,6858); | |
insert into counties values ('Butler', 'NE', 11432,8395); | |
insert into counties values ('Cass', 'NE', 16361,25241); | |
insert into counties values ('Cedar', 'NE', 13843,8852); | |
insert into counties values ('Chase', 'NE', 5176,3966); | |
insert into counties values ('Cherry', 'NE', 8397,5713); | |
insert into counties values ('Cheyenne', 'NE', 12081,9998); | |
insert into counties values ('Clay', 'NE', 8700,6542); | |
insert into counties values ('Colfax', 'NE', 10010,10515); | |
insert into counties values ('Cuming', 'NE', 12994,9139); | |
insert into counties values ('Custer', 'NE', 19170,10939); | |
insert into counties values ('Dakota', 'NE', 10401,21006); | |
insert into counties values ('Dawes', 'NE', 9708,9182); | |
insert into counties values ('Dawson', 'NE', 19393,24326); | |
insert into counties values ('Deuel', 'NE', 3330,1941); | |
insert into counties values ('Dixon', 'NE', 9129,6000); | |
insert into counties values ('Dodge', 'NE', 26265,36691); | |
insert into counties values ('Douglas', 'NE', 281020,517110); | |
insert into counties values ('Dundy', 'NE', 4354,2008); | |
insert into counties values ('Fillmore', 'NE', 9610,5890); | |
insert into counties values ('Franklin', 'NE', 7096,3225); | |
insert into counties values ('Frontier', 'NE', 5282,2756); | |
insert into counties values ('Furnas', 'NE', 9385,4959); | |
insert into counties values ('Gage', 'NE', 28052,22311); | |
insert into counties values ('Garden', 'NE', 4114,2057); | |
insert into counties values ('Garfield', 'NE', 2912,2049); | |
insert into counties values ('Gosper', 'NE', 2734,2044); | |
insert into counties values ('Grant', 'NE', 1057,614); | |
insert into counties values ('Greeley', 'NE', 5575,2538); | |
insert into counties values ('Hall', 'NE', 32186,58607); | |
insert into counties values ('Hamilton', 'NE', 8778,9124); | |
insert into counties values ('Harlan', 'NE', 7189,3423); | |
insert into counties values ('Hayes', 'NE', 2404,967); | |
insert into counties values ('Hitchcock', 'NE', 5867,2908); | |
insert into counties values ('Holt', 'NE', 14859,10435); | |
insert into counties values ('Hooker', 'NE', 1061,736); | |
insert into counties values ('Howard', 'NE', 7226,6274); | |
insert into counties values ('Jefferson', 'NE', 13623,7547); | |
insert into counties values ('Johnson', 'NE', 7251,5217); | |
insert into counties values ('Kearney', 'NE', 6409,6489); | |
insert into counties values ('Keith', 'NE', 7449,8368); | |
insert into counties values ('Keya Paha', 'NE', 2160,824); | |
insert into counties values ('Kimball', 'NE', 4283,3821); | |
insert into counties values ('Knox', 'NE', 14820,8701); | |
insert into counties values ('Lancaster', 'NE', 119742,285407); | |
insert into counties values ('Lincoln', 'NE', 27380,36288); | |
insert into counties values ('Logan', 'NE', 1357,763); | |
insert into counties values ('Loup', 'NE', 1348,632); | |
insert into counties values ('McPherson', 'NE', 825,539); | |
insert into counties values ('Madison', 'NE', 24338,34876); | |
insert into counties values ('Merrick', 'NE', 8812,7845); | |
insert into counties values ('Morrill', 'NE', 8263,5042); | |
insert into counties values ('Nance', 'NE', 6512,3735); | |
insert into counties values ('Nemaha', 'NE', 10973,7248); | |
insert into counties values ('Nuckolls', 'NE', 9609,4500); | |
insert into counties values ('Otoe', 'NE', 17056,15740); | |
insert into counties values ('Pawnee', 'NE', 6744,2773); | |
insert into counties values ('Perkins', 'NE', 4809,2970); | |
insert into counties values ('Phelps', 'NE', 9048,9188); | |
insert into counties values ('Pierce', 'NE', 9405,7266); | |
insert into counties values ('Platte', 'NE', 19910,32237); | |
insert into counties values ('Polk', 'NE', 8044,5406); | |
insert into counties values ('Red Willow', 'NE', 12977,11055); | |
insert into counties values ('Richardson', 'NE', 16886,8363); | |
insert into counties values ('Rock', 'NE', 3026,1526); | |
insert into counties values ('Saline', 'NE', 14046,14200); | |
insert into counties values ('Sarpy', 'NE', 15693,158840); | |
insert into counties values ('Saunders', 'NE', 16923,20780); | |
insert into counties values ('Scotts Bluff', 'NE', 33939,36970); | |
insert into counties values ('Seward', 'NE', 13155,16750); | |
insert into counties values ('Sheridan', 'NE', 9539,5469); | |
insert into counties values ('Sherman', 'NE', 6421,3152); | |
insert into counties values ('Sioux', 'NE', 3124,1311); | |
insert into counties values ('Stanton', 'NE', 6387,6129); | |
insert into counties values ('Thayer', 'NE', 10563,5228); | |
insert into counties values ('Thomas', 'NE', 1206,647); | |
insert into counties values ('Thurston', 'NE', 8590,6940); | |
insert into counties values ('Valley', 'NE', 7252,4260); | |
insert into counties values ('Washington', 'NE', 11511,20234); | |
insert into counties values ('Wayne', 'NE', 10129,9595); | |
insert into counties values ('Webster', 'NE', 7395,3812); | |
insert into counties values ('Wheeler', 'NE', 1526,818); | |
insert into counties values ('York', 'NE', 14346,13665); | |
insert into counties values ('Churchill', 'NV', 6161,24877); | |
insert into counties values ('Clark', 'NV', 48289,1951269); | |
insert into counties values ('Douglas', 'NV', 2029,46997); | |
insert into counties values ('Elko', 'NV', 11654,48818); | |
insert into counties values ('Esmeralda', 'NV', 614,783); | |
insert into counties values ('Eureka', 'NV', 896,1987); | |
insert into counties values ('Humboldt', 'NV', 4838,16528); | |
insert into counties values ('Lander', 'NV', 1850,5775); | |
insert into counties values ('Lincoln', 'NV', 3837,5345); | |
insert into counties values ('Lyon', 'NV', 3679,51980); | |
insert into counties values ('Mineral', 'NV', 5560,4772); | |
insert into counties values ('Nye', 'NV', 3101,43946); | |
insert into counties values ('Pershing', 'NV', 3103,6753); | |
insert into counties values ('Storey', 'NV', 671,4010); | |
insert into counties values ('Washoe', 'NV', 50205,421407); | |
insert into counties values ('White Pine', 'NV', 9424,10030); | |
insert into counties values ('Carson City city', 'NV', 4172,55274); | |
insert into counties values ('Belknap', 'NH', 26632,60088); | |
insert into counties values ('Carroll', 'NH', 15868,47818); | |
insert into counties values ('Cheshire', 'NH', 38811,77117); | |
insert into counties values ('Coos', 'NH', 35932,33055); | |
insert into counties values ('Grafton', 'NH', 47923,89118); | |
insert into counties values ('Hillsborough', 'NH', 156987,400721); | |
insert into counties values ('Merrimack', 'NH', 63022,146445); | |
insert into counties values ('Rockingham', 'NH', 70059,295223); | |
insert into counties values ('Strafford', 'NH', 51567,123143); | |
insert into counties values ('Sullivan', 'NH', 26441,43742); | |
insert into counties values ('Atlantic', 'NJ', 132399,274549); | |
insert into counties values ('Bergen', 'NJ', 539139,905116); | |
insert into counties values ('Burlington', 'NJ', 135910,448734); | |
insert into counties values ('Camden', 'NJ', 300743,513657); | |
insert into counties values ('Cape May', 'NJ', 37131,97265); | |
insert into counties values ('Cumberland', 'NJ', 88597,156898); | |
insert into counties values ('Essex', 'NJ', 905949,783969); | |
insert into counties values ('Gloucester', 'NJ', 91727,288288); | |
insert into counties values ('Hudson', 'NJ', 647437,634266); | |
insert into counties values ('Hunterdon', 'NJ', 42736,128349); | |
insert into counties values ('Mercer', 'NJ', 229781,366513); | |
insert into counties values ('Middlesex', 'NJ', 264872,809858); | |
insert into counties values ('Monmouth', 'NJ', 225327,630380); | |
insert into counties values ('Morris', 'NJ', 164371,492276); | |
insert into counties values ('Ocean', 'NJ', 56622,576567); | |
insert into counties values ('Passaic', 'NJ', 337093,501226); | |
insert into counties values ('Salem', 'NJ', 49508,66083); | |
insert into counties values ('Somerset', 'NJ', 99052,323444); | |
insert into counties values ('Sussex', 'NJ', 34423,149265); | |
insert into counties values ('Union', 'NJ', 398138,536499); | |
insert into counties values ('Warren', 'NJ', 54374,108692); | |
insert into counties values ('Bernalillo', 'NM', 145673,662564); | |
insert into counties values ('Catron', 'NM', 3533,3725); | |
insert into counties values ('Chaves', 'NM', 40605,65645); | |
insert into counties values ('Cibola', 'NM', 0,27213); | |
insert into counties values ('Colfax', 'NM', 16761,13750); | |
insert into counties values ('Curry', 'NM', 23351,48376); | |
insert into counties values ('De Baca', 'NM', 3464,2022); | |
insert into counties values ('Dona Ana', 'NM', 39557,209233); | |
insert into counties values ('Eddy', 'NM', 40640,53829); | |
insert into counties values ('Grant', 'NM', 21649,29514); | |
insert into counties values ('Guadalupe', 'NM', 6772,4687); | |
insert into counties values ('Harding', 'NM', 3013,695); | |
insert into counties values ('Hidalgo', 'NM', 5095,4894); | |
insert into counties values ('Lea', 'NM', 30717,64727); | |
insert into counties values ('Lincoln', 'NM', 7409,20497); | |
insert into counties values ('Los Alamos', 'NM', 10476,17950); | |
insert into counties values ('Luna', 'NM', 8753,25095); | |
insert into counties values ('McKinley', 'NM', 27451,71492); | |
insert into counties values ('Mora', 'NM', 8720,4881); | |
insert into counties values ('Otero', 'NM', 14909,63797); | |
insert into counties values ('Quay', 'NM', 13971,9041); | |
insert into counties values ('Rio Arriba', 'NM', 24997,40246); | |
insert into counties values ('Roosevelt', 'NM', 16409,19846); | |
insert into counties values ('Sandoval', 'NM', 12438,131561); | |
insert into counties values ('San Juan', 'NM', 18292,130044); | |
insert into counties values ('San Miguel', 'NM', 26512,29393); | |
insert into counties values ('Santa Fe', 'NM', 38153,144170); | |
insert into counties values ('Sierra', 'NM', 7186,11988); | |
insert into counties values ('Socorro', 'NM', 9670,17866); | |
insert into counties values ('Taos', 'NM', 17146,32937); | |
insert into counties values ('Torrance', 'NM', 8012,16383); | |
insert into counties values ('Union', 'NM', 7372,4549); | |
insert into counties values ('Valencia', 'NM', 22481,76569); | |
insert into counties values ('Albany', 'NY', 239386,304204); | |
insert into counties values ('Allegany', 'NY', 43784,48946); | |
insert into counties values ('Bronx', 'NY', 1451277,1385108); | |
insert into counties values ('Broome', 'NY', 184698,200600); | |
insert into counties values ('Cattaraugus', 'NY', 77901,80317); | |
insert into counties values ('Cayuga', 'NY', 70136,80026); | |
insert into counties values ('Chautauqua', 'NY', 135189,134905); | |
insert into counties values ('Chemung', 'NY', 86827,88830); | |
insert into counties values ('Chenango', 'NY', 39138,50477); | |
insert into counties values ('Clinton', 'NY', 53622,82128); | |
insert into counties values ('Columbia', 'NY', 43182,63096); | |
insert into counties values ('Cortland', 'NY', 37158,49336); | |
insert into counties values ('Delaware', 'NY', 44420,47980); | |
insert into counties values ('Dutchess', 'NY', 136781,297488); | |
insert into counties values ('Erie', 'NY', 899238,919040); | |
insert into counties values ('Essex', 'NY', 35086,39370); | |
insert into counties values ('Franklin', 'NY', 44830,51599); | |
insert into counties values ('Fulton', 'NY', 51021,55531); | |
insert into counties values ('Genesee', 'NY', 47584,60079); | |
insert into counties values ('Greene', 'NY', 28745,49221); | |
insert into counties values ('Hamilton', 'NY', 4105,4836); | |
insert into counties values ('Herkimer', 'NY', 61407,64519); | |
insert into counties values ('Jefferson', 'NY', 85521,116229); | |
insert into counties values ('Kings', 'NY', 2738175,2504700); | |
insert into counties values ('Lewis', 'NY', 22521,27087); | |
insert into counties values ('Livingston', 'NY', 40257,65393); | |
insert into counties values ('Madison', 'NY', 46214,73442); | |
insert into counties values ('Monroe', 'NY', 487632,744344); | |
insert into counties values ('Montgomery', 'NY', 59594,50219); | |
insert into counties values ('Nassau', 'NY', 672765,1339532); | |
insert into counties values ('New York', 'NY', 1960101,1585873); | |
insert into counties values ('Niagara', 'NY', 189992,216469); | |
insert into counties values ('Oneida', 'NY', 222855,234878); | |
insert into counties values ('Onondaga', 'NY', 341719,467026); | |
insert into counties values ('Ontario', 'NY', 60172,107931); | |
insert into counties values ('Orange', 'NY', 152255,372813); | |
insert into counties values ('Orleans', 'NY', 29832,42883); | |
insert into counties values ('Oswego', 'NY', 77181,122109); | |
insert into counties values ('Otsego', 'NY', 50763,62259); | |
insert into counties values ('Putnam', 'NY', 20307,99710); | |
insert into counties values ('Queens', 'NY', 1550849,2230722); | |
insert into counties values ('Rensselaer', 'NY', 132607,159429); | |
insert into counties values ('Richmond', 'NY', 191555,468730); | |
insert into counties values ('Rockland', 'NY', 89276,311687); | |
insert into counties values ('St. Lawrence', 'NY', 98897,111944); | |
insert into counties values ('Saratoga', 'NY', 74869,219607); | |
insert into counties values ('Schenectady', 'NY', 142497,154727); | |
insert into counties values ('Schoharie', 'NY', 22703,32749); | |
insert into counties values ('Schuyler', 'NY', 14182,18343); | |
insert into counties values ('Seneca', 'NY', 29253,35251); | |
insert into counties values ('Steuben', 'NY', 91439,98990); | |
insert into counties values ('Suffolk', 'NY', 276129,1493350); | |
insert into counties values ('Sullivan', 'NY', 40731,77547); | |
insert into counties values ('Tioga', 'NY', 30166,51125); | |
insert into counties values ('Tompkins', 'NY', 59122,101564); | |
insert into counties values ('Ulster', 'NY', 92621,182493); | |
insert into counties values ('Warren', 'NY', 39205,65707); | |
insert into counties values ('Washington', 'NY', 47144,63216); | |
insert into counties values ('Wayne', 'NY', 57323,93772); | |
insert into counties values ('Westchester', 'NY', 625816,949113); | |
insert into counties values ('Wyoming', 'NY', 32822,42155); | |
insert into counties values ('Yates', 'NY', 17615,25348); | |
insert into counties values ('Alamance', 'NC', 71220,151131); | |
insert into counties values ('Alexander', 'NC', 14554,37198); | |
insert into counties values ('Alleghany', 'NC', 8155,11155); | |
insert into counties values ('Anson', 'NC', 26781,26948); | |
insert into counties values ('Ashe', 'NC', 21878,27281); | |
insert into counties values ('Avery', 'NC', 13352,17797); | |
insert into counties values ('Beaufort', 'NC', 37134,47759); | |
insert into counties values ('Bertie', 'NC', 26439,21282); | |
insert into counties values ('Bladen', 'NC', 29703,35190); | |
insert into counties values ('Brunswick', 'NC', 19238,107431); | |
insert into counties values ('Buncombe', 'NC', 124403,238318); | |
insert into counties values ('Burke', 'NC', 45518,90912); | |
insert into counties values ('Cabarrus', 'NC', 63783,178011); | |
insert into counties values ('Caldwell', 'NC', 43352,83029); | |
insert into counties values ('Camden', 'NC', 5223,9980); | |
insert into counties values ('Carteret', 'NC', 23059,66469); | |
insert into counties values ('Caswell', 'NC', 20870,23719); | |
insert into counties values ('Catawba', 'NC', 61794,154358); | |
insert into counties values ('Chatham', 'NC', 25392,63505); | |
insert into counties values ('Cherokee', 'NC', 18294,27444); | |
insert into counties values ('Chowan', 'NC', 12540,14793); | |
insert into counties values ('Clay', 'NC', 6006,10587); | |
insert into counties values ('Cleveland', 'NC', 64357,98078); | |
insert into counties values ('Columbus', 'NC', 50621,58098); | |
insert into counties values ('Craven', 'NC', 48823,103505); | |
insert into counties values ('Cumberland', 'NC', 96006,319431); | |
insert into counties values ('Currituck', 'NC', 6201,23547); | |
insert into counties values ('Dare', 'NC', 5405,33920); | |
insert into counties values ('Davidson', 'NC', 62244,162878); | |
insert into counties values ('Davie', 'NC', 15420,41240); | |
insert into counties values ('Duplin', 'NC', 41074,58505); | |
insert into counties values ('Durham', 'NC', 101639,267587); | |
insert into counties values ('Edgecombe', 'NC', 51634,56552); | |
insert into counties values ('Forsyth', 'NC', 146135,350670); | |
insert into counties values ('Franklin', 'NC', 31341,60619); | |
insert into counties values ('Gaston', 'NC', 110836,206086); | |
insert into counties values ('Gates', 'NC', 9555,12197); | |
insert into counties values ('Graham', 'NC', 6886,8861); | |
insert into counties values ('Granville', 'NC', 31793,59916); | |
insert into counties values ('Greene', 'NC', 18024,21362); | |
insert into counties values ('Guilford', 'NC', 191057,488406); | |
insert into counties values ('Halifax', 'NC', 58377,54691); | |
insert into counties values ('Harnett', 'NC', 47605,114678); | |
insert into counties values ('Haywood', 'NC', 37631,59036); | |
insert into counties values ('Henderson', 'NC', 30921,106740); | |
insert into counties values ('Hertford', 'NC', 21453,24669); | |
insert into counties values ('Hoke', 'NC', 15756,46952); | |
insert into counties values ('Hyde', 'NC', 6479,5810); | |
insert into counties values ('Iredell', 'NC', 56303,159437); | |
insert into counties values ('Jackson', 'NC', 19261,40271); | |
insert into counties values ('Johnston', 'NC', 65906,168878); | |
insert into counties values ('Jones', 'NC', 11004,10153); | |
insert into counties values ('Lee', 'NC', 23522,57866); | |
insert into counties values ('Lenoir', 'NC', 45953,59495); | |
insert into counties values ('Lincoln', 'NC', 27459,78265); | |
insert into counties values ('McDowell', 'NC', 25720,44996); | |
insert into counties values ('Macon', 'NC', 16174,33922); | |
insert into counties values ('Madison', 'NC', 20522,20764); | |
insert into counties values ('Martin', 'NC', 27938,24505); | |
insert into counties values ('Mecklenburg', 'NC', 197052,919628); | |
insert into counties values ('Mitchell', 'NC', 15143,15579); | |
insert into counties values ('Montgomery', 'NC', 17260,27798); | |
insert into counties values ('Moore', 'NC', 33129,88247); | |
insert into counties values ('Nash', 'NC', 59919,95840); | |
insert into counties values ('New Hanover', 'NC', 63272,202667); | |
insert into counties values ('Northampton', 'NC', 28432,22099); | |
insert into counties values ('Onslow', 'NC', 42047,177772); | |
insert into counties values ('Orange', 'NC', 34435,133801); | |
insert into counties values ('Pamlico', 'NC', 9993,13144); | |
insert into counties values ('Pasquotank', 'NC', 24347,40661); | |
insert into counties values ('Pender', 'NC', 18423,52217); | |
insert into counties values ('Perquimans', 'NC', 9602,13453); | |
insert into counties values ('Person', 'NC', 24361,39464); | |
insert into counties values ('Pitt', 'NC', 63789,168148); | |
insert into counties values ('Polk', 'NC', 11627,20510); | |
insert into counties values ('Randolph', 'NC', 50804,141752); | |
insert into counties values ('Richmond', 'NC', 39597,46639); | |
insert into counties values ('Robeson', 'NC', 87769,134168); | |
insert into counties values ('Rockingham', 'NC', 64816,93643); | |
insert into counties values ('Rowan', 'NC', 75410,138428); | |
insert into counties values ('Rutherford', 'NC', 46356,67810); | |
insert into counties values ('Sampson', 'NC', 49780,63431); | |
insert into counties values ('Scotland', 'NC', 26336,36157); | |
insert into counties values ('Stanly', 'NC', 37130,60585); | |
insert into counties values ('Stokes', 'NC', 21520,47401); | |
insert into counties values ('Surry', 'NC', 45593,73673); | |
insert into counties values ('Swain', 'NC', 9921,13981); | |
insert into counties values ('Transylvania', 'NC', 15194,33090); | |
insert into counties values ('Tyrrell', 'NC', 5048,4407); | |
insert into counties values ('Union', 'NC', 42034,201292); | |
insert into counties values ('Vance', 'NC', 32101,45422); | |
insert into counties values ('Wake', 'NC', 136450,900993); | |
insert into counties values ('Warren', 'NC', 23539,20972); | |
insert into counties values ('Washington', 'NC', 13180,13228); | |
insert into counties values ('Watauga', 'NC', 18342,51079); | |
insert into counties values ('Wayne', 'NC', 64267,122623); | |
insert into counties values ('Wilkes', 'NC', 45243,69340); | |
insert into counties values ('Wilson', 'NC', 54506,81234); | |
insert into counties values ('Yadkin', 'NC', 22133,38406); | |
insert into counties values ('Yancey', 'NC', 16306,17818); | |
insert into counties values ('Adams', 'ND', 4910,2343); | |
insert into counties values ('Barnes', 'ND', 16884,11066); | |
insert into counties values ('Benson', 'ND', 10675,6660); | |
insert into counties values ('Billings', 'ND', 1777,783); | |
insert into counties values ('Bottineau', 'ND', 12140,6429); | |
insert into counties values ('Bowman', 'ND', 4001,3151); | |
insert into counties values ('Burke', 'ND', 6621,1968); | |
insert into counties values ('Burleigh', 'ND', 25673,81308); | |
insert into counties values ('Cass', 'ND', 58877,149778); | |
insert into counties values ('Cavalier', 'ND', 11840,3993); | |
insert into counties values ('Dickey', 'ND', 9121,5289); | |
insert into counties values ('Divide', 'ND', 5967,2071); | |
insert into counties values ('Dunn', 'ND', 7212,3536); | |
insert into counties values ('Eddy', 'ND', 5372,2385); | |
insert into counties values ('Emmons', 'ND', 9715,3550); | |
insert into counties values ('Foster', 'ND', 5337,3343); | |
insert into counties values ('Golden Valley', 'ND', 3499,1680); | |
insert into counties values ('Grand Forks', 'ND', 39443,66861); | |
insert into counties values ('Grant', 'ND', 7114,2394); | |
insert into counties values ('Griggs', 'ND', 5460,2420); | |
insert into counties values ('Hettinger', 'ND', 7100,2477); | |
insert into counties values ('Kidder', 'ND', 6168,2435); | |
insert into counties values ('LaMoure', 'ND', 9498,4139); | |
insert into counties values ('Logan', 'ND', 6357,1990); | |
insert into counties values ('McHenry', 'ND', 12556,5395); | |
insert into counties values ('McIntosh', 'ND', 7590,2809); | |
insert into counties values ('McKenzie', 'ND', 6849,6360); | |
insert into counties values ('McLean', 'ND', 18824,8962); | |
insert into counties values ('Mercer', 'ND', 8686,8424); | |
insert into counties values ('Morton', 'ND', 19295,27471); | |
insert into counties values ('Mountrail', 'ND', 9418,7673); | |
insert into counties values ('Nelson', 'ND', 8090,3126); | |
insert into counties values ('Oliver', 'ND', 3091,1846); | |
insert into counties values ('Pembina', 'ND', 13990,7413); | |
insert into counties values ('Pierce', 'ND', 8326,4357); | |
insert into counties values ('Ramsey', 'ND', 14373,11451); | |
insert into counties values ('Ransom', 'ND', 8876,5457); | |
insert into counties values ('Renville', 'ND', 5405,2470); | |
insert into counties values ('Richland', 'ND', 19865,16321); | |
insert into counties values ('Rolette', 'ND', 11102,13937); | |
insert into counties values ('Sargent', 'ND', 7616,3829); | |
insert into counties values ('Sheridan', 'ND', 5253,1321); | |
insert into counties values ('Sioux', 'ND', 3696,4153); | |
insert into counties values ('Slope', 'ND', 2315,727); | |
insert into counties values ('Stark', 'ND', 16137,24199); | |
insert into counties values ('Steele', 'ND', 5145,1975); | |
insert into counties values ('Stutsman', 'ND', 24158,21100); | |
insert into counties values ('Towner', 'ND', 6360,2246); | |
insert into counties values ('Traill', 'ND', 11359,8121); | |
insert into counties values ('Walsh', 'ND', 18859,11119); | |
insert into counties values ('Ward', 'ND', 34782,61675); | |
insert into counties values ('Wells', 'ND', 10417,4207); | |
insert into counties values ('Williams', 'ND', 16442,22398); | |
insert into counties values ('Adams', 'OH', 20499,28550); | |
insert into counties values ('Allen', 'OH', 88183,106331); | |
insert into counties values ('Ashland', 'OH', 33040,53139); | |
insert into counties values ('Ashtabula', 'OH', 78695,101497); | |
insert into counties values ('Athens', 'OH', 45839,64757); | |
insert into counties values ('Auglaize', 'OH', 30637,45949); | |
insert into counties values ('Belmont', 'OH', 87740,70400); | |
insert into counties values ('Brown', 'OH', 22221,44846); | |
insert into counties values ('Butler', 'OH', 147203,368130); | |
insert into counties values ('Carroll', 'OH', 19039,28836); | |
insert into counties values ('Champaign', 'OH', 26793,40097); | |
insert into counties values ('Clark', 'OH', 111661,138333); | |
insert into counties values ('Clermont', 'OH', 42182,197363); | |
insert into counties values ('Clinton', 'OH', 25572,42040); | |
insert into counties values ('Columbiana', 'OH', 98920,107841); | |
insert into counties values ('Coshocton', 'OH', 31141,36901); | |
insert into counties values ('Crawford', 'OH', 38738,43784); | |
insert into counties values ('Cuyahoga', 'OH', 1389532,1280122); | |
insert into counties values ('Darke', 'OH', 41799,52959); | |
insert into counties values ('Defiance', 'OH', 25925,39037); | |
insert into counties values ('Delaware', 'OH', 30278,174214); | |
insert into counties values ('Erie', 'OH', 52565,77079); | |
insert into counties values ('Fairfield', 'OH', 52130,146156); | |
insert into counties values ('Fayette', 'OH', 22554,29030); | |
insert into counties values ('Franklin', 'OH', 503410,1163414); | |
insert into counties values ('Fulton', 'OH', 25580,42698); | |
insert into counties values ('Gallia', 'OH', 24910,30934); | |
insert into counties values ('Geauga', 'OH', 26646,93389); | |
insert into counties values ('Greene', 'OH', 58892,161573); | |
insert into counties values ('Guernsey', 'OH', 38452,40087); | |
insert into counties values ('Hamilton', 'OH', 723952,802374); | |
insert into counties values ('Hancock', 'OH', 44280,74782); | |
insert into counties values ('Hardin', 'OH', 28673,32058); | |
insert into counties values ('Harrison', 'OH', 19054,15864); | |
insert into counties values ('Henry', 'OH', 22423,28215); | |
insert into counties values ('Highland', 'OH', 28188,43589); | |
insert into counties values ('Hocking', 'OH', 19520,29380); | |
insert into counties values ('Holmes', 'OH', 18760,42366); | |
insert into counties values ('Huron', 'OH', 39353,59626); | |
insert into counties values ('Jackson', 'OH', 27767,33225); | |
insert into counties values ('Jefferson', 'OH', 96495,69709); | |
insert into counties values ('Knox', 'OH', 35287,60921); | |
insert into counties values ('Lake', 'OH', 75979,230041); | |
insert into counties values ('Lawrence', 'OH', 49115,62450); | |
insert into counties values ('Licking', 'OH', 70645,166492); | |
insert into counties values ('Logan', 'OH', 31329,45858); | |
insert into counties values ('Lorain', 'OH', 148162,301356); | |
insert into counties values ('Lucas', 'OH', 395551,441815); | |
insert into counties values ('Madison', 'OH', 22300,43435); | |
insert into counties values ('Mahoning', 'OH', 257629,238823); | |
insert into counties values ('Marion', 'OH', 49959,66501); | |
insert into counties values ('Medina', 'OH', 40417,172332); | |
insert into counties values ('Meigs', 'OH', 23227,23770); | |
insert into counties values ('Mercer', 'OH', 28311,40814); | |
insert into counties values ('Miami', 'OH', 61309,102506); | |
insert into counties values ('Monroe', 'OH', 15362,14642); | |
insert into counties values ('Montgomery', 'OH', 398441,535153); | |
insert into counties values ('Morgan', 'OH', 12836,15054); | |
insert into counties values ('Morrow', 'OH', 17168,34827); | |
insert into counties values ('Muskingum', 'OH', 74535,86074); | |
insert into counties values ('Noble', 'OH', 11750,14645); | |
insert into counties values ('Ottawa', 'OH', 29469,41428); | |
insert into counties values ('Paulding', 'OH', 15047,19614); | |
insert into counties values ('Perry', 'OH', 28999,36058); | |
insert into counties values ('Pickaway', 'OH', 29352,55698); | |
insert into counties values ('Pike', 'OH', 14607,28709); | |
insert into counties values ('Portage', 'OH', 63954,161419); | |
insert into counties values ('Preble', 'OH', 27081,42270); | |
insert into counties values ('Putnam', 'OH', 25248,34499); | |
insert into counties values ('Richland', 'OH', 91305,124475); | |
insert into counties values ('Ross', 'OH', 54424,78064); | |
insert into counties values ('Sandusky', 'OH', 46114,60944); | |
insert into counties values ('Scioto', 'OH', 82910,79499); | |
insert into counties values ('Seneca', 'OH', 52978,56745); | |
insert into counties values ('Shelby', 'OH', 28488,49423); | |
insert into counties values ('Stark', 'OH', 283194,375586); | |
insert into counties values ('Summit', 'OH', 410032,541781); | |
insert into counties values ('Trumbull', 'OH', 158915,210312); | |
insert into counties values ('Tuscarawas', 'OH', 70320,92582); | |
insert into counties values ('Union', 'OH', 20687,52300); | |
insert into counties values ('Van Wert', 'OH', 26971,28744); | |
insert into counties values ('Vinton', 'OH', 10759,13435); | |
insert into counties values ('Warren', 'OH', 38505,212693); | |
insert into counties values ('Washington', 'OH', 44407,61778); | |
insert into counties values ('Wayne', 'OH', 58716,114520); | |
insert into counties values ('Williams', 'OH', 26202,37642); | |
insert into counties values ('Wood', 'OH', 59605,125488); | |
insert into counties values ('Wyandot', 'OH', 19785,22615); | |
insert into counties values ('Adair', 'OK', 14918,22683); | |
insert into counties values ('Alfalfa', 'OK', 10699,5642); | |
insert into counties values ('Atoka', 'OK', 14269,14182); | |
insert into counties values ('Beaver', 'OK', 7411,5636); | |
insert into counties values ('Beckham', 'OK', 21627,22119); | |
insert into counties values ('Blaine', 'OK', 15049,11943); | |
insert into counties values ('Bryan', 'OK', 28999,42416); | |
insert into counties values ('Caddo', 'OK', 34913,29600); | |
insert into counties values ('Canadian', 'OK', 25644,115541); | |
insert into counties values ('Carter', 'OK', 36455,47557); | |
insert into counties values ('Cherokee', 'OK', 18989,46987); | |
insert into counties values ('Choctaw', 'OK', 20405,15205); | |
insert into counties values ('Cimarron', 'OK', 4589,2475); | |
insert into counties values ('Cleveland', 'OK', 41443,255755); | |
insert into counties values ('Coal', 'OK', 8056,5925); | |
insert into counties values ('Comanche', 'OK', 55165,124098); | |
insert into counties values ('Cotton', 'OK', 10180,6193); | |
insert into counties values ('Craig', 'OK', 18263,15029); | |
insert into counties values ('Creek', 'OK', 43143,69967); | |
insert into counties values ('Custer', 'OK', 21097,27469); | |
insert into counties values ('Delaware', 'OK', 14734,41487); | |
insert into counties values ('Dewey', 'OK', 8789,4810); | |
insert into counties values ('Ellis', 'OK', 7326,4151); | |
insert into counties values ('Garfield', 'OK', 52820,60580); | |
insert into counties values ('Garvin', 'OK', 29500,27576); | |
insert into counties values ('Grady', 'OK', 34872,52431); | |
insert into counties values ('Grant', 'OK', 10461,4527); | |
insert into counties values ('Greer', 'OK', 11749,6239); | |
insert into counties values ('Harmon', 'OK', 8079,2922); | |
insert into counties values ('Harper', 'OK', 5977,3685); | |
insert into counties values ('Haskell', 'OK', 13313,12769); | |
insert into counties values ('Hughes', 'OK', 20664,14003); | |
insert into counties values ('Jackson', 'OK', 20082,26446); | |
insert into counties values ('Jefferson', 'OK', 11122,6472); | |
insert into counties values ('Johnston', 'OK', 10608,10957); | |
insert into counties values ('Kay', 'OK', 48892,46562); | |
insert into counties values ('Kingfisher', 'OK', 12860,15034); | |
insert into counties values ('Kiowa', 'OK', 18926,9446); | |
insert into counties values ('Latimer', 'OK', 9690,11154); | |
insert into counties values ('Le Flore', 'OK', 35276,50384); | |
insert into counties values ('Lincoln', 'OK', 22102,34273); | |
insert into counties values ('Logan', 'OK', 22170,41848); | |
insert into counties values ('Love', 'OK', 7721,9423); | |
insert into counties values ('McClain', 'OK', 14681,34506); | |
insert into counties values ('McCurtain', 'OK', 31588,33151); | |
insert into counties values ('McIntosh', 'OK', 17829,20252); | |
insert into counties values ('Major', 'OK', 10279,7527); | |
insert into counties values ('Marshall', 'OK', 8177,15840); | |
insert into counties values ('Mayes', 'OK', 19743,41259); | |
insert into counties values ('Murray', 'OK', 10775,13488); | |
insert into counties values ('Muskogee', 'OK', 65573,70990); | |
insert into counties values ('Noble', 'OK', 12156,11561); | |
insert into counties values ('Nowata', 'OK', 12734,10536); | |
insert into counties values ('Okfuskee', 'OK', 16948,12191); | |
insert into counties values ('Oklahoma', 'OK', 325352,718633); | |
insert into counties values ('Okmulgee', 'OK', 44561,40069); | |
insert into counties values ('Osage', 'OK', 33071,47472); | |
insert into counties values ('Ottawa', 'OK', 32218,31848); | |
insert into counties values ('Pawnee', 'OK', 13616,16577); | |
insert into counties values ('Payne', 'OK', 46430,77350); | |
insert into counties values ('Pittsburg', 'OK', 41031,45837); | |
insert into counties values ('Pontotoc', 'OK', 30875,37492); | |
insert into counties values ('Pottawatomie', 'OK', 43517,69442); | |
insert into counties values ('Pushmataha', 'OK', 12001,11572); | |
insert into counties values ('Roger Mills', 'OK', 7395,3647); | |
insert into counties values ('Rogers', 'OK', 19532,86905); | |
insert into counties values ('Seminole', 'OK', 40672,25482); | |
insert into counties values ('Sequoyah', 'OK', 19773,42391); | |
insert into counties values ('Stephens', 'OK', 34071,45048); | |
insert into counties values ('Texas', 'OK', 14235,20640); | |
insert into counties values ('Tillman', 'OK', 17598,7992); | |
insert into counties values ('Tulsa', 'OK', 251686,603403); | |
insert into counties values ('Wagoner', 'OK', 16741,73085); | |
insert into counties values ('Washington', 'OK', 32880,50976); | |
insert into counties values ('Washita', 'OK', 17657,11629); | |
insert into counties values ('Woods', 'OK', 14526,8878); | |
insert into counties values ('Woodward', 'OK', 14383,20081); | |
insert into counties values ('Baker', 'OR', 16175,16134); | |
insert into counties values ('Benton', 'OR', 31570,85579); | |
insert into counties values ('Clackamas', 'OR', 86716,375992); | |
insert into counties values ('Clatsop', 'OR', 30776,37039); | |
insert into counties values ('Columbia', 'OR', 22967,49351); | |
insert into counties values ('Coos', 'OR', 42265,63043); | |
insert into counties values ('Crook', 'OR', 8991,20978); | |
insert into counties values ('Curry', 'OR', 6048,22364); | |
insert into counties values ('Deschutes', 'OR', 21812,157733); | |
insert into counties values ('Douglas', 'OR', 54549,107667); | |
insert into counties values ('Gilliam', 'OR', 2817,1871); | |
insert into counties values ('Grant', 'OR', 8329,7445); | |
insert into counties values ('Harney', 'OR', 6113,7422); | |
insert into counties values ('Hood River', 'OR', 12740,22346); | |
insert into counties values ('Jackson', 'OR', 58510,203206); | |
insert into counties values ('Jefferson', 'OR', 5536,21720); | |
insert into counties values ('Josephine', 'OR', 26542,82713); | |
insert into counties values ('Klamath', 'OR', 42150,66380); | |
insert into counties values ('Lake', 'OR', 6649,7895); | |
insert into counties values ('Lane', 'OR', 125776,351715); | |
insert into counties values ('Lincoln', 'OR', 21308,46034); | |
insert into counties values ('Linn', 'OR', 54317,116672); | |
insert into counties values ('Malheur', 'OR', 23223,31313); | |
insert into counties values ('Marion', 'OR', 101401,315335); | |
insert into counties values ('Morrow', 'OR', 4783,11173); | |
insert into counties values ('Multnomah', 'OR', 471537,735334); | |
insert into counties values ('Polk', 'OR', 26317,75403); | |
insert into counties values ('Sherman', 'OR', 2271,1765); | |
insert into counties values ('Tillamook', 'OR', 18606,25250); | |
insert into counties values ('Umatilla', 'OR', 41703,75889); | |
insert into counties values ('Union', 'OR', 17962,25748); | |
insert into counties values ('Wallowa', 'OR', 7264,7008); | |
insert into counties values ('Wasco', 'OR', 15552,25213); | |
insert into counties values ('Washington', 'OR', 61269,529710); | |
insert into counties values ('Wheeler', 'OR', 3313,1441); | |
insert into counties values ('Yamhill', 'OR', 33484,99193); | |
insert into counties values ('Adams', 'PA', 44197,101407); | |
insert into counties values ('Allegheny', 'PA', 1515237,1223348); | |
insert into counties values ('Armstrong', 'PA', 80842,68941); | |
insert into counties values ('Beaver', 'PA', 175192,170539); | |
insert into counties values ('Bedford', 'PA', 40775,49762); | |
insert into counties values ('Berks', 'PA', 255740,411442); | |
insert into counties values ('Blair', 'PA', 139514,127089); | |
insert into counties values ('Bradford', 'PA', 51722,62622); | |
insert into counties values ('Bucks', 'PA', 144620,625249); | |
insert into counties values ('Butler', 'PA', 97320,183862); | |
insert into counties values ('Cambria', 'PA', 209541,143679); | |
insert into counties values ('Cameron', 'PA', 7023,5085); | |
insert into counties values ('Carbon', 'PA', 57558,65249); | |
insert into counties values ('Centre', 'PA', 65922,153990); | |
insert into counties values ('Chester', 'PA', 159141,498886); | |
insert into counties values ('Clarion', 'PA', 38344,39988); | |
insert into counties values ('Clearfield', 'PA', 85957,81642); | |
insert into counties values ('Clinton', 'PA', 36532,39238); | |
insert into counties values ('Columbia', 'PA', 53460,67295); | |
insert into counties values ('Crawford', 'PA', 78948,88765); | |
insert into counties values ('Cumberland', 'PA', 94457,235406); | |
insert into counties values ('Dauphin', 'PA', 197784,268100); | |
insert into counties values ('Delaware', 'PA', 414234,558979); | |
insert into counties values ('Elk', 'PA', 34503,31946); | |
insert into counties values ('Erie', 'PA', 219388,280566); | |
insert into counties values ('Fayette', 'PA', 189899,136606); | |
insert into counties values ('Forest', 'PA', 4944,7716); | |
insert into counties values ('Franklin', 'PA', 75927,149618); | |
insert into counties values ('Fulton', 'PA', 10387,14845); | |
insert into counties values ('Greene', 'PA', 45394,38686); | |
insert into counties values ('Huntingdon', 'PA', 40872,45913); | |
insert into counties values ('Indiana', 'PA', 77106,88880); | |
insert into counties values ('Jefferson', 'PA', 49147,45200); | |
insert into counties values ('Juniata', 'PA', 15243,24636); | |
insert into counties values ('Lackawanna', 'PA', 257396,214437); | |
insert into counties values ('Lancaster', 'PA', 234717,519445); | |
insert into counties values ('Lawrence', 'PA', 105120,91108); | |
insert into counties values ('Lebanon', 'PA', 81683,133568); | |
insert into counties values ('Lehigh', 'PA', 198207,349497); | |
insert into counties values ('Luzerne', 'PA', 392241,320918); | |
insert into counties values ('Lycoming', 'PA', 101249,116111); | |
insert into counties values ('McKean', 'PA', 56607,43450); | |
insert into counties values ('Mercer', 'PA', 111954,116638); | |
insert into counties values ('Mifflin', 'PA', 43691,46682); | |
insert into counties values ('Monroe', 'PA', 33773,169842); | |
insert into counties values ('Montgomery', 'PA', 353068,799874); | |
insert into counties values ('Montour', 'PA', 16001,18267); | |
insert into counties values ('Northampton', 'PA', 185243,297735); | |
insert into counties values ('Northumberland', 'PA', 117115,94528); | |
insert into counties values ('Perry', 'PA', 24782,45969); | |
insert into counties values ('Philadelphia', 'PA', 2071605,1526006); | |
insert into counties values ('Pike', 'PA', 8425,57369); | |
insert into counties values ('Potter', 'PA', 16810,17457); | |
insert into counties values ('Schuylkill', 'PA', 200577,148289); | |
insert into counties values ('Snyder', 'PA', 22912,39702); | |
insert into counties values ('Somerset', 'PA', 81813,77742); | |
insert into counties values ('Sullivan', 'PA', 6745,6428); | |
insert into counties values ('Susquehanna', 'PA', 31970,43356); | |
insert into counties values ('Tioga', 'PA', 35474,41981); | |
insert into counties values ('Union', 'PA', 23150,44947); | |
insert into counties values ('Venango', 'PA', 65328,54984); | |
insert into counties values ('Warren', 'PA', 42698,41815); | |
insert into counties values ('Washington', 'PA', 209628,207820); | |
insert into counties values ('Wayne', 'PA', 28478,52822); | |
insert into counties values ('Westmoreland', 'PA', 313179,365169); | |
insert into counties values ('Wyoming', 'PA', 16766,28276); | |
insert into counties values ('York', 'PA', 202737,434972); | |
insert into counties values ('Bristol', 'RI', 29079,49875); | |
insert into counties values ('Kent', 'RI', 77763,166158); | |
insert into counties values ('Newport', 'RI', 61539,82888); | |
insert into counties values ('Providence', 'RI', 574973,626667); | |
insert into counties values ('Washington', 'RI', 48542,126979); | |
insert into counties values ('Abbeville', 'SC', 22456,25417); | |
insert into counties values ('Aiken', 'SC', 53137,160099); | |
insert into counties values ('Allendale', 'SC', 11773,10419); | |
insert into counties values ('Anderson', 'SC', 90664,187126); | |
insert into counties values ('Bamberg', 'SC', 17533,15987); | |
insert into counties values ('Barnwell', 'SC', 17266,22621); | |
insert into counties values ('Beaufort', 'SC', 26993,162233); | |
insert into counties values ('Berkeley', 'SC', 30251,177843); | |
insert into counties values ('Calhoun', 'SC', 14753,15175); | |
insert into counties values ('Charleston', 'SC', 164856,350209); | |
insert into counties values ('Cherokee', 'SC', 34992,55342); | |
insert into counties values ('Chester', 'SC', 32597,33140); | |
insert into counties values ('Chesterfield', 'SC', 36236,46734); | |
insert into counties values ('Clarendon', 'SC', 32215,34971); | |
insert into counties values ('Colleton', 'SC', 28242,38892); | |
insert into counties values ('Darlington', 'SC', 50016,68681); | |
insert into counties values ('Dillon', 'SC', 30930,32062); | |
insert into counties values ('Dorchester', 'SC', 22601,136555); | |
insert into counties values ('Edgefield', 'SC', 16591,26985); | |
insert into counties values ('Fairfield', 'SC', 21780,23956); | |
insert into counties values ('Florence', 'SC', 79710,136885); | |
insert into counties values ('Georgetown', 'SC', 31762,60158); | |
insert into counties values ('Greenville', 'SC', 168152,451225); | |
insert into counties values ('Greenwood', 'SC', 41628,69661); | |
insert into counties values ('Hampton', 'SC', 18027,21090); | |
insert into counties values ('Horry', 'SC', 59820,269291); | |
insert into counties values ('Jasper', 'SC', 10995,24777); | |
insert into counties values ('Kershaw', 'SC', 32287,61697); | |
insert into counties values ('Lancaster', 'SC', 37071,76652); | |
insert into counties values ('Laurens', 'SC', 46974,66537); | |
insert into counties values ('Lee', 'SC', 23173,19220); | |
insert into counties values ('Lexington', 'SC', 44279,262391); | |
insert into counties values ('McCormick', 'SC', 9577,10233); | |
insert into counties values ('Marion', 'SC', 33110,33062); | |
insert into counties values ('Marlboro', 'SC', 31766,28933); | |
insert into counties values ('Newberry', 'SC', 31771,37508); | |
insert into counties values ('Oconee', 'SC', 39050,74273); | |
insert into counties values ('Orangeburg', 'SC', 68726,92501); | |
insert into counties values ('Pickens', 'SC', 40058,119224); | |
insert into counties values ('Richland', 'SC', 142565,384504); | |
insert into counties values ('Saluda', 'SC', 15924,19875); | |
insert into counties values ('Spartanburg', 'SC', 150349,284307); | |
insert into counties values ('Sumter', 'SC', 57634,107456); | |
insert into counties values ('Union', 'SC', 31334,28961); | |
insert into counties values ('Williamsburg', 'SC', 43807,34423); | |
insert into counties values ('York', 'SC', 71596,226073); | |
insert into counties values ('Aurora', 'SD', 5020,2710); | |
insert into counties values ('Beadle', 'SD', 21082,17398); | |
insert into counties values ('Bennett', 'SD', 3396,3431); | |
insert into counties values ('Bon Homme', 'SD', 9440,7070); | |
insert into counties values ('Brookings', 'SD', 17851,31965); | |
insert into counties values ('Brown', 'SD', 32617,36531); | |
insert into counties values ('Brule', 'SD', 6076,5255); | |
insert into counties values ('Buffalo', 'SD', 1615,1912); | |
insert into counties values ('Butte', 'SD', 8161,10110); | |
insert into counties values ('Campbell', 'SD', 4046,1466); | |
insert into counties values ('Charles Mix', 'SD', 15558,9129); | |
insert into counties values ('Clark', 'SD', 8369,3691); | |
insert into counties values ('Clay', 'SD', 10993,13864); | |
insert into counties values ('Codington', 'SD', 18944,27227); | |
insert into counties values ('Corson', 'SD', 6168,4050); | |
insert into counties values ('Custer', 'SD', 5517,8216); | |
insert into counties values ('Davison', 'SD', 16522,19504); | |
insert into counties values ('Day', 'SD', 12294,5710); | |
insert into counties values ('Deuel', 'SD', 7689,4364); | |
insert into counties values ('Dewey', 'SD', 4968,5301); | |
insert into counties values ('Douglas', 'SD', 5636,3002); | |
insert into counties values ('Edmunds', 'SD', 7275,4071); | |
insert into counties values ('Fall River', 'SD', 10439,7094); | |
insert into counties values ('Faulk', 'SD', 4752,2364); | |
insert into counties values ('Grant', 'SD', 10233,7356); | |
insert into counties values ('Gregory', 'SD', 8556,4271); | |
insert into counties values ('Haakon', 'SD', 3167,1937); | |
insert into counties values ('Hamlin', 'SD', 7058,5903); | |
insert into counties values ('Hand', 'SD', 7149,3431); | |
insert into counties values ('Hanson', 'SD', 4896,3331); | |
insert into counties values ('Harding', 'SD', 2289,1255); | |
insert into counties values ('Hughes', 'SD', 8111,17022); | |
insert into counties values ('Hutchinson', 'SD', 11423,7343); | |
insert into counties values ('Hyde', 'SD', 2811,1420); | |
insert into counties values ('Jackson', 'SD', 3319,3031); | |
insert into counties values ('Jerauld', 'SD', 4476,2071); | |
insert into counties values ('Jones', 'SD', 2281,1006); | |
insert into counties values ('Kingsbury', 'SD', 9962,5148); | |
insert into counties values ('Lake', 'SD', 11792,11200); | |
insert into counties values ('Lawrence', 'SD', 16648,24097); | |
insert into counties values ('Lincoln', 'SD', 12767,44828); | |
insert into counties values ('Lyman', 'SD', 4572,3755); | |
insert into counties values ('McCook', 'SD', 8828,5618); | |
insert into counties values ('McPherson', 'SD', 7071,2459); | |
insert into counties values ('Marshall', 'SD', 7835,4656); | |
insert into counties values ('Meade', 'SD', 11516,25434); | |
insert into counties values ('Mellette', 'SD', 3046,2048); | |
insert into counties values ('Miner', 'SD', 6268,2389); | |
insert into counties values ('Minnehaha', 'SD', 70910,169468); | |
insert into counties values ('Moody', 'SD', 9252,6486); | |
insert into counties values ('Pennington', 'SD', 34053,100948); | |
insert into counties values ('Perkins', 'SD', 6776,2982); | |
insert into counties values ('Potter', 'SD', 4688,2329); | |
insert into counties values ('Roberts', 'SD', 14929,10149); | |
insert into counties values ('Sanborn', 'SD', 5142,2355); | |
insert into counties values ('Shannon', 'SD', 5669,13586); | |
insert into counties values ('Spink', 'SD', 12204,6415); | |
insert into counties values ('Stanley', 'SD', 2055,2966); | |
insert into counties values ('Sully', 'SD', 2713,1373); | |
insert into counties values ('Todd', 'SD', 4758,9612); | |
insert into counties values ('Tripp', 'SD', 9139,5644); | |
insert into counties values ('Turner', 'SD', 12100,8347); | |
insert into counties values ('Union', 'SD', 10792,14399); | |
insert into counties values ('Walworth', 'SD', 7648,5438); | |
insert into counties values ('Yankton', 'SD', 16804,22438); | |
insert into counties values ('Ziebach', 'SD', 2606,2801); | |
insert into counties values ('Anderson', 'TN', 59407,75129); | |
insert into counties values ('Bedford', 'TN', 23627,45058); | |
insert into counties values ('Benton', 'TN', 11495,16489); | |
insert into counties values ('Bledsoe', 'TN', 8561,12876); | |
insert into counties values ('Blount', 'TN', 54691,123010); | |
insert into counties values ('Bradley', 'TN', 32338,98963); | |
insert into counties values ('Campbell', 'TN', 34369,40716); | |
insert into counties values ('Cannon', 'TN', 9174,13801); | |
insert into counties values ('Carroll', 'TN', 26553,28522); | |
insert into counties values ('Carter', 'TN', 42432,57424); | |
insert into counties values ('Cheatham', 'TN', 9167,39105); | |
insert into counties values ('Chester', 'TN', 11149,17131); | |
insert into counties values ('Claiborne', 'TN', 24788,32213); | |
insert into counties values ('Clay', 'TN', 8701,7861); | |
insert into counties values ('Cocke', 'TN', 22991,35662); | |
insert into counties values ('Coffee', 'TN', 23049,52796); | |
insert into counties values ('Crockett', 'TN', 16624,14586); | |
insert into counties values ('Cumberland', 'TN', 18877,56053); | |
insert into counties values ('Davidson', 'TN', 321758,626681); | |
insert into counties values ('Decatur', 'TN', 9442,11757); | |
insert into counties values ('DeKalb', 'TN', 11680,18723); | |
insert into counties values ('Dickson', 'TN', 18805,49666); | |
insert into counties values ('Dyer', 'TN', 33473,38335); | |
insert into counties values ('Fayette', 'TN', 27535,38413); | |
insert into counties values ('Fentress', 'TN', 14917,17959); | |
insert into counties values ('Franklin', 'TN', 25431,41052); | |
insert into counties values ('Gibson', 'TN', 48132,49683); | |
insert into counties values ('Giles', 'TN', 26961,29485); | |
insert into counties values ('Grainger', 'TN', 13086,22657); | |
insert into counties values ('Greene', 'TN', 41048,68831); | |
insert into counties values ('Grundy', 'TN', 12558,13703); | |
insert into counties values ('Hamblen', 'TN', 23976,62544); | |
insert into counties values ('Hamilton', 'TN', 208255,336463); | |
insert into counties values ('Hancock', 'TN', 9116,6819); | |
insert into counties values ('Hardeman', 'TN', 23311,27253); | |
insert into counties values ('Hardin', 'TN', 16908,26026); | |
insert into counties values ('Hawkins', 'TN', 30494,56833); | |
insert into counties values ('Haywood', 'TN', 26212,18787); | |
insert into counties values ('Henderson', 'TN', 17173,27769); | |
insert into counties values ('Henry', 'TN', 23828,32330); | |
insert into counties values ('Hickman', 'TN', 13353,24690); | |
insert into counties values ('Houston', 'TN', 5318,8426); | |
insert into counties values ('Humphreys', 'TN', 11030,18538); | |
insert into counties values ('Jackson', 'TN', 12348,11638); | |
insert into counties values ('Jefferson', 'TN', 19667,51407); | |
insert into counties values ('Johnson', 'TN', 12278,18244); | |
insert into counties values ('Knox', 'TN', 223007,432226); | |
insert into counties values ('Lake', 'TN', 11655,7832); | |
insert into counties values ('Lauderdale', 'TN', 25047,27815); | |
insert into counties values ('Lawrence', 'TN', 28818,41869); | |
insert into counties values ('Lewis', 'TN', 6078,12161); | |
insert into counties values ('Lincoln', 'TN', 25624,33361); | |
insert into counties values ('Loudon', 'TN', 23182,48556); | |
insert into counties values ('McMinn', 'TN', 32024,52266); | |
insert into counties values ('McNairy', 'TN', 20390,26075); | |
insert into counties values ('Macon', 'TN', 13599,22248); | |
insert into counties values ('Madison', 'TN', 60128,98294); | |
insert into counties values ('Marion', 'TN', 20520,28237); | |
insert into counties values ('Marshall', 'TN', 17768,30617); | |
insert into counties values ('Maury', 'TN', 40368,80956); | |
insert into counties values ('Meigs', 'TN', 6080,11753); | |
insert into counties values ('Monroe', 'TN', 24513,44519); | |
insert into counties values ('Montgomery', 'TN', 44186,172331); | |
insert into counties values ('Moore', 'TN', 3948,6362); | |
insert into counties values ('Morgan', 'TN', 15727,21987); | |
insert into counties values ('Obion', 'TN', 29056,31807); | |
insert into counties values ('Overton', 'TN', 17566,22083); | |
insert into counties values ('Perry', 'TN', 6462,7915); | |
insert into counties values ('Pickett', 'TN', 5093,5077); | |
insert into counties values ('Polk', 'TN', 14074,16825); | |
insert into counties values ('Putnam', 'TN', 29869,72321); | |
insert into counties values ('Rhea', 'TN', 16041,31809); | |
insert into counties values ('Roane', 'TN', 31665,54181); | |
insert into counties values ('Robertson', 'TN', 27024,66283); | |
insert into counties values ('Rutherford', 'TN', 40696,262604); | |
insert into counties values ('Scott', 'TN', 17362,22228); | |
insert into counties values ('Sequatchie', 'TN', 5685,14112); | |
insert into counties values ('Sevier', 'TN', 23375,89889); | |
insert into counties values ('Shelby', 'TN', 482393,927644); | |
insert into counties values ('Smith', 'TN', 14098,19166); | |
insert into counties values ('Stewart', 'TN', 9175,13324); | |
insert into counties values ('Sullivan', 'TN', 95063,156823); | |
insert into counties values ('Sumner', 'TN', 33533,160645); | |
insert into counties values ('Tipton', 'TN', 29782,61081); | |
insert into counties values ('Trousdale', 'TN', 5520,7870); | |
insert into counties values ('Unicoi', 'TN', 15886,18313); | |
insert into counties values ('Union', 'TN', 8670,19109); | |
insert into counties values ('Van Buren', 'TN', 3985,5548); | |
insert into counties values ('Warren', 'TN', 22271,39839); | |
insert into counties values ('Washington', 'TN', 59971,122979); | |
insert into counties values ('Wayne', 'TN', 13864,17021); | |
insert into counties values ('Weakley', 'TN', 27962,35021); | |
insert into counties values ('White', 'TN', 16204,25841); | |
insert into counties values ('Williamson', 'TN', 24307,183182); | |
insert into counties values ('Wilson', 'TN', 26318,113993); | |
insert into counties values ('Anderson', 'TX', 31875,58458); | |
insert into counties values ('Andrews', 'TX', 5002,14786); | |
insert into counties values ('Angelina', 'TX', 36032,86771); | |
insert into counties values ('Aransas', 'TX', 4252,23158); | |
insert into counties values ('Archer', 'TX', 6816,9054); | |
insert into counties values ('Armstrong', 'TX', 2215,1901); | |
insert into counties values ('Atascosa', 'TX', 20048,44911); | |
insert into counties values ('Austin', 'TX', 14663,28417); | |
insert into counties values ('Bailey', 'TX', 7592,7165); | |
insert into counties values ('Bandera', 'TX', 4410,20485); | |
insert into counties values ('Bastrop', 'TX', 19622,74171); | |
insert into counties values ('Baylor', 'TX', 6875,3726); | |
insert into counties values ('Bee', 'TX', 18174,31861); | |
insert into counties values ('Bell', 'TX', 73824,310235); | |
insert into counties values ('Bexar', 'TX', 500460,1714773); | |
insert into counties values ('Blanco', 'TX', 3780,10497); | |
insert into counties values ('Borden', 'TX', 1106,641); | |
insert into counties values ('Bosque', 'TX', 11836,18212); | |
insert into counties values ('Bowie', 'TX', 61966,92565); | |
insert into counties values ('Brazoria', 'TX', 46549,313166); | |
insert into counties values ('Brazos', 'TX', 38390,194851); | |
insert into counties values ('Brewster', 'TX', 7309,9232); | |
insert into counties values ('Briscoe', 'TX', 3528,1637); | |
insert into counties values ('Brooks', 'TX', 9195,7223); | |
insert into counties values ('Brown', 'TX', 28607,38106); | |
insert into counties values ('Burleson', 'TX', 13000,17187); | |
insert into counties values ('Burnet', 'TX', 10356,42750); | |
insert into counties values ('Caldwell', 'TX', 19350,38066); | |
insert into counties values ('Calhoun', 'TX', 9222,21381); | |
insert into counties values ('Callahan', 'TX', 9087,13544); | |
insert into counties values ('Cameron', 'TX', 125170,406220); | |
insert into counties values ('Camp', 'TX', 8740,12401); | |
insert into counties values ('Carson', 'TX', 6852,6182); | |
insert into counties values ('Cass', 'TX', 26732,30464); | |
insert into counties values ('Castro', 'TX', 5417,8062); | |
insert into counties values ('Chambers', 'TX', 7871,35096); | |
insert into counties values ('Cherokee', 'TX', 38694,50845); | |
insert into counties values ('Childress', 'TX', 12123,7041); | |
insert into counties values ('Clay', 'TX', 9896,10752); | |
insert into counties values ('Cochran', 'TX', 5928,3127); | |
insert into counties values ('Coke', 'TX', 4045,3320); | |
insert into counties values ('Coleman', 'TX', 15503,8895); | |
insert into counties values ('Collin', 'TX', 41692,782341); | |
insert into counties values ('Collingsworth', 'TX', 9139,3057); | |
insert into counties values ('Colorado', 'TX', 17576,20874); | |
insert into counties values ('Comal', 'TX', 16357,108472); | |
insert into counties values ('Comanche', 'TX', 15516,13974); | |
insert into counties values ('Concho', 'TX', 5078,4087); | |
insert into counties values ('Cooke', 'TX', 22146,38437); | |
insert into counties values ('Coryell', 'TX', 16284,75388); | |
insert into counties values ('Cottle', 'TX', 6099,1505); | |
insert into counties values ('Crane', 'TX', 3965,4375); | |
insert into counties values ('Crockett', 'TX', 3981,3719); | |
insert into counties values ('Crosby', 'TX', 9582,6059); | |
insert into counties values ('Culberson', 'TX', 1825,2398); | |
insert into counties values ('Dallam', 'TX', 7640,6703); | |
insert into counties values ('Dallas', 'TX', 614799,2368139); | |
insert into counties values ('Dawson', 'TX', 19113,13833); | |
insert into counties values ('Deaf Smith', 'TX', 9111,19372); | |
insert into counties values ('Delta', 'TX', 8964,5231); | |
insert into counties values ('Denton', 'TX', 41365,662614); | |
insert into counties values ('DeWitt', 'TX', 22973,20097); | |
insert into counties values ('Dickens', 'TX', 7177,2444); | |
insert into counties values ('Dimmit', 'TX', 10654,9996); | |
insert into counties values ('Donley', 'TX', 6216,3677); | |
insert into counties values ('Duval', 'TX', 15643,11782); | |
insert into counties values ('Eastland', 'TX', 23942,18583); | |
insert into counties values ('Ector', 'TX', 42102,137130); | |
insert into counties values ('Edwards', 'TX', 2908,2002); | |
insert into counties values ('Ellis', 'TX', 45645,149610); | |
insert into counties values ('El Paso', 'TX', 194968,800647); | |
insert into counties values ('Erath', 'TX', 18434,37890); | |
insert into counties values ('Falls', 'TX', 26724,17866); | |
insert into counties values ('Fannin', 'TX', 31253,33915); | |
insert into counties values ('Fayette', 'TX', 24176,24554); | |
insert into counties values ('Fisher', 'TX', 11023,3974); | |
insert into counties values ('Floyd', 'TX', 10535,6446); | |
insert into counties values ('Foard', 'TX', 4216,1336); | |
insert into counties values ('Fort Bend', 'TX', 31056,585375); | |
insert into counties values ('Franklin', 'TX', 6257,10605); | |
insert into counties values ('Freestone', 'TX', 15696,19816); | |
insert into counties values ('Frio', 'TX', 10357,17217); | |
insert into counties values ('Gaines', 'TX', 8909,17526); | |
insert into counties values ('Galveston', 'TX', 113066,291309); | |
insert into counties values ('Garza', 'TX', 6281,6461); | |
insert into counties values ('Gillespie', 'TX', 10520,24837); | |
insert into counties values ('Glasscock', 'TX', 1089,1226); | |
insert into counties values ('Goliad', 'TX', 6219,7210); | |
insert into counties values ('Gonzales', 'TX', 21164,19807); | |
insert into counties values ('Gray', 'TX', 24728,22535); | |
insert into counties values ('Grayson', 'TX', 70467,120877); | |
insert into counties values ('Gregg', 'TX', 61258,121730); | |
insert into counties values ('Grimes', 'TX', 15135,26604); | |
insert into counties values ('Guadalupe', 'TX', 25392,131533); | |
insert into counties values ('Hale', 'TX', 28211,36273); | |
insert into counties values ('Hall', 'TX', 10930,3353); | |
insert into counties values ('Hamilton', 'TX', 10660,8517); | |
insert into counties values ('Hansford', 'TX', 4202,5613); | |
insert into counties values ('Hardeman', 'TX', 10212,4139); | |
insert into counties values ('Hardin', 'TX', 19535,54635); | |
insert into counties values ('Harris', 'TX', 806701,4092459); | |
insert into counties values ('Harrison', 'TX', 47745,65631); | |
insert into counties values ('Hartley', 'TX', 1913,6062); | |
insert into counties values ('Haskell', 'TX', 13736,5899); | |
insert into counties values ('Hays', 'TX', 17840,157107); | |
insert into counties values ('Hemphill', 'TX', 4123,3807); | |
insert into counties values ('Henderson', 'TX', 23405,78532); | |
insert into counties values ('Hidalgo', 'TX', 160446,774769); | |
insert into counties values ('Hill', 'TX', 31282,35089); | |
insert into counties values ('Hockley', 'TX', 20407,22935); | |
insert into counties values ('Hood', 'TX', 5287,51182); | |
insert into counties values ('Hopkins', 'TX', 23490,35161); | |
insert into counties values ('Houston', 'TX', 22825,23732); | |
insert into counties values ('Howard', 'TX', 26722,35012); | |
insert into counties values ('Hudspeth', 'TX', 4298,3476); | |
insert into counties values ('Hunt', 'TX', 42731,86129); | |
insert into counties values ('Hutchinson', 'TX', 31580,22150); | |
insert into counties values ('Irion', 'TX', 1590,1599); | |
insert into counties values ('Jack', 'TX', 7755,9044); | |
insert into counties values ('Jackson', 'TX', 12916,14075); | |
insert into counties values ('Jasper', 'TX', 20049,35710); | |
insert into counties values ('Jeff Davis', 'TX', 2090,2342); | |
insert into counties values ('Jefferson', 'TX', 195083,252273); | |
insert into counties values ('Jim Hogg', 'TX', 5389,5300); | |
insert into counties values ('Jim Wells', 'TX', 27991,40838); | |
insert into counties values ('Johnson', 'TX', 31390,150934); | |
insert into counties values ('Jones', 'TX', 22147,20202); | |
insert into counties values ('Karnes', 'TX', 17139,14824); | |
insert into counties values ('Kaufman', 'TX', 31170,103350); | |
insert into counties values ('Kendall', 'TX', 5423,33410); | |
insert into counties values ('Kenedy', 'TX', 632,416); | |
insert into counties values ('Kent', 'TX', 2249,808); | |
insert into counties values ('Kerr', 'TX', 14022,49625); | |
insert into counties values ('Kimble', 'TX', 4619,4607); | |
insert into counties values ('King', 'TX', 870,286); | |
insert into counties values ('Kinney', 'TX', 2668,3598); | |
insert into counties values ('Kleberg', 'TX', 21991,32061); | |
insert into counties values ('Knox', 'TX', 10082,3719); | |
insert into counties values ('Lamar', 'TX', 43033,49793); | |
insert into counties values ('Lamb', 'TX', 20015,13977); | |
insert into counties values ('Lampasas', 'TX', 9929,19677); | |
insert into counties values ('La Salle', 'TX', 7485,6886); | |
insert into counties values ('Lavaca', 'TX', 22159,19263); | |
insert into counties values ('Lee', 'TX', 10144,16612); | |
insert into counties values ('Leon', 'TX', 12024,16801); | |
insert into counties values ('Liberty', 'TX', 26729,75643); | |
insert into counties values ('Limestone', 'TX', 25251,23384); | |
insert into counties values ('Lipscomb', 'TX', 3658,3302); | |
insert into counties values ('Live Oak', 'TX', 9054,11531); | |
insert into counties values ('Llano', 'TX', 5377,19301); | |
insert into counties values ('Loving', 'TX', 227,82); | |
insert into counties values ('Lubbock', 'TX', 101048,278831); | |
insert into counties values ('Lynn', 'TX', 11030,5915); | |
insert into counties values ('McCulloch', 'TX', 11701,8283); | |
insert into counties values ('McLennan', 'TX', 130194,234906); | |
insert into counties values ('McMullen', 'TX', 1187,707); | |
insert into counties values ('Madison', 'TX', 7996,13664); | |
insert into counties values ('Marion', 'TX', 10172,10546); | |
insert into counties values ('Martin', 'TX', 5541,4799); | |
insert into counties values ('Mason', 'TX', 4945,4012); | |
insert into counties values ('Matagorda', 'TX', 21559,36702); | |
insert into counties values ('Maverick', 'TX', 12292,54258); | |
insert into counties values ('Medina', 'TX', 17013,46006); | |
insert into counties values ('Menard', 'TX', 4175,2242); | |
insert into counties values ('Midland', 'TX', 25785,136872); | |
insert into counties values ('Milam', 'TX', 23585,24757); | |
insert into counties values ('Mills', 'TX', 5999,4936); | |
insert into counties values ('Mitchell', 'TX', 14357,9403); | |
insert into counties values ('Montague', 'TX', 17070,19719); | |
insert into counties values ('Montgomery', 'TX', 24504,455746); | |
insert into counties values ('Moore', 'TX', 13349,21904); | |
insert into counties values ('Morris', 'TX', 9433,12934); | |
insert into counties values ('Motley', 'TX', 3963,1210); | |
insert into counties values ('Nacogdoches', 'TX', 30326,64524); | |
insert into counties values ('Navarro', 'TX', 39916,47735); | |
insert into counties values ('Newton', 'TX', 10832,14445); | |
insert into counties values ('Nolan', 'TX', 19808,15216); | |
insert into counties values ('Nueces', 'TX', 165471,340223); | |
insert into counties values ('Ochiltree', 'TX', 6024,10223); | |
insert into counties values ('Oldham', 'TX', 1672,2052); | |
insert into counties values ('Orange', 'TX', 40567,81837); | |
insert into counties values ('Palo Pinto', 'TX', 17154,28111); | |
insert into counties values ('Panola', 'TX', 19250,23796); | |
insert into counties values ('Parker', 'TX', 21528,116927); | |
insert into counties values ('Parmer', 'TX', 5787,10269); | |
insert into counties values ('Pecos', 'TX', 9939,15507); | |
insert into counties values ('Polk', 'TX', 16194,45413); | |
insert into counties values ('Potter', 'TX', 73366,121073); | |
insert into counties values ('Presidio', 'TX', 7354,7818); | |
insert into counties values ('Rains', 'TX', 4266,10914); | |
insert into counties values ('Randall', 'TX', 13774,120725); | |
insert into counties values ('Reagan', 'TX', 3127,3367); | |
insert into counties values ('Real', 'TX', 2479,3309); | |
insert into counties values ('Red River', 'TX', 21851,12860); | |
insert into counties values ('Reeves', 'TX', 11745,13783); | |
insert into counties values ('Refugio', 'TX', 10113,7383); | |
insert into counties values ('Roberts', 'TX', 1031,929); | |
insert into counties values ('Robertson', 'TX', 19908,16622); | |
insert into counties values ('Rockwall', 'TX', 6156,78337); | |
insert into counties values ('Runnels', 'TX', 16771,10501); | |
insert into counties values ('Rusk', 'TX', 42348,53330); | |
insert into counties values ('Sabine', 'TX', 8568,10834); | |
insert into counties values ('San Augustine', 'TX', 8837,8865); | |
insert into counties values ('San Jacinto', 'TX', 7172,26384); | |
insert into counties values ('San Patricio', 'TX', 35842,64804); | |
insert into counties values ('San Saba', 'TX', 8666,6131); | |
insert into counties values ('Schleicher', 'TX', 2852,3461); | |
insert into counties values ('Scurry', 'TX', 22779,16921); | |
insert into counties values ('Shackelford', 'TX', 5001,3378); | |
insert into counties values ('Shelby', 'TX', 23479,25448); | |
insert into counties values ('Sherman', 'TX', 2443,3034); | |
insert into counties values ('Smith', 'TX', 74701,209714); | |
insert into counties values ('Somervell', 'TX', 2542,8490); | |
insert into counties values ('Starr', 'TX', 13948,60968); | |
insert into counties values ('Stephens', 'TX', 10597,9630); | |
insert into counties values ('Sterling', 'TX', 1282,1143); | |
insert into counties values ('Stonewall', 'TX', 3679,1490); | |
insert into counties values ('Sutton', 'TX', 3746,4128); | |
insert into counties values ('Swisher', 'TX', 8249,7854); | |
insert into counties values ('Tarrant', 'TX', 361253,1809034); | |
insert into counties values ('Taylor', 'TX', 63370,131506); | |
insert into counties values ('Terrell', 'TX', 3189,984); | |
insert into counties values ('Terry', 'TX', 13107,12651); | |
insert into counties values ('Throckmorton', 'TX', 3618,1641); | |
insert into counties values ('Titus', 'TX', 17302,32334); | |
insert into counties values ('Tom Green', 'TX', 58929,110224); | |
insert into counties values ('Travis', 'TX', 160980,1024266); | |
insert into counties values ('Trinity', 'TX', 10040,14585); | |
insert into counties values ('Tyler', 'TX', 11292,21766); | |
insert into counties values ('Upshur', 'TX', 20822,39309); | |
insert into counties values ('Upton', 'TX', 5307,3355); | |
insert into counties values ('Uvalde', 'TX', 16015,26405); | |
insert into counties values ('Val Verde', 'TX', 16635,48879); | |
insert into counties values ('Van Zandt', 'TX', 22593,52579); | |
insert into counties values ('Victoria', 'TX', 31241,86793); | |
insert into counties values ('Walker', 'TX', 20163,67861); | |
insert into counties values ('Waller', 'TX', 11961,43205); | |
insert into counties values ('Ward', 'TX', 13346,10658); | |
insert into counties values ('Washington', 'TX', 20542,33718); | |
insert into counties values ('Webb', 'TX', 56141,250304); | |
insert into counties values ('Wharton', 'TX', 36077,41280); | |
insert into counties values ('Wheeler', 'TX', 10317,5410); | |
insert into counties values ('Wichita', 'TX', 98493,131500); | |
insert into counties values ('Wilbarger', 'TX', 20552,13535); | |
insert into counties values ('Willacy', 'TX', 20920,22134); | |
insert into counties values ('Williamson', 'TX', 38853,422679); | |
insert into counties values ('Wilson', 'TX', 14672,42918); | |
insert into counties values ('Winkler', 'TX', 10064,7110); | |
insert into counties values ('Wise', 'TX', 16141,59127); | |
insert into counties values ('Wood', 'TX', 21308,41964); | |
insert into counties values ('Yoakum', 'TX', 4339,7879); | |
insert into counties values ('Young', 'TX', 16810,18550); | |
insert into counties values ('Zapata', 'TX', 4405,14018); | |
insert into counties values ('Zavala', 'TX', 11201,11677); | |
insert into counties values ('Beaver', 'UT', 4856,6629); | |
insert into counties values ('Box Elder', 'UT', 19734,49975); | |
insert into counties values ('Cache', 'UT', 33536,112656); | |
insert into counties values ('Carbon', 'UT', 24901,21403); | |
insert into counties values ('Daggett', 'UT', 364,1059); | |
insert into counties values ('Davis', 'UT', 30867,306479); | |
insert into counties values ('Duchesne', 'UT', 8134,18607); | |
insert into counties values ('Emery', 'UT', 6304,10976); | |
insert into counties values ('Garfield', 'UT', 4151,5172); | |
insert into counties values ('Grand', 'UT', 1903,9225); | |
insert into counties values ('Iron', 'UT', 9642,46163); | |
insert into counties values ('Juab', 'UT', 5981,10246); | |
insert into counties values ('Kane', 'UT', 2299,7125); | |
insert into counties values ('Millard', 'UT', 9387,12503); | |
insert into counties values ('Morgan', 'UT', 2519,9469); | |
insert into counties values ('Piute', 'UT', 1911,1556); | |
insert into counties values ('Rich', 'UT', 1673,2264); | |
insert into counties values ('Salt Lake', 'UT', 274895,1029655); | |
insert into counties values ('San Juan', 'UT', 5315,14746); | |
insert into counties values ('Sanpete', 'UT', 13891,27822); | |
insert into counties values ('Sevier', 'UT', 12072,20802); | |
insert into counties values ('Summit', 'UT', 6745,36324); | |
insert into counties values ('Tooele', 'UT', 14636,58218); | |
insert into counties values ('Uintah', 'UT', 10300,32588); | |
insert into counties values ('Utah', 'UT', 81912,516564); | |
insert into counties values ('Wasatch', 'UT', 5574,23530); | |
insert into counties values ('Washington', 'UT', 9836,138115); | |
insert into counties values ('Wayne', 'UT', 2205,2778); | |
insert into counties values ('Weber', 'UT', 83319,231236); | |
insert into counties values ('Addison', 'VT', 19442,36821); | |
insert into counties values ('Bennington', 'VT', 24115,37125); | |
insert into counties values ('Caledonia', 'VT', 24049,31227); | |
insert into counties values ('Chittenden', 'VT', 62570,156545); | |
insert into counties values ('Essex', 'VT', 6257,6306); | |
insert into counties values ('Franklin', 'VT', 29894,47746); | |
insert into counties values ('Grand Isle', 'VT', 3406,6970); | |
insert into counties values ('Lamoille', 'VT', 11388,24475); | |
insert into counties values ('Orange', 'VT', 17027,28936); | |
insert into counties values ('Orleans', 'VT', 21190,27231); | |
insert into counties values ('Rutland', 'VT', 45905,61642); | |
insert into counties values ('Washington', 'VT', 42870,59534); | |
insert into counties values ('Windham', 'VT', 28749,44513); | |
insert into counties values ('Windsor', 'VT', 40885,56670); | |
insert into counties values ('Accomack', 'VA', 33832,33164); | |
insert into counties values ('Albemarle', 'VA', 26662,98970); | |
insert into counties values ('Alleghany', 'VA', 23139,16250); | |
insert into counties values ('Amelia', 'VA', 7908,12690); | |
insert into counties values ('Amherst', 'VA', 20332,32353); | |
insert into counties values ('Appomattox', 'VA', 8764,14973); | |
insert into counties values ('Arlington', 'VA', 135449,207627); | |
insert into counties values ('Augusta', 'VA', 34154,73750); | |
insert into counties values ('Bath', 'VA', 6296,4731); | |
insert into counties values ('Bedford', 'VA', 29627,68676); | |
insert into counties values ('Bland', 'VA', 6436,6824); | |
insert into counties values ('Botetourt', 'VA', 15766,33148); | |
insert into counties values ('Brunswick', 'VA', 20136,17434); | |
insert into counties values ('Buchanan', 'VA', 35748,24098); | |
insert into counties values ('Buckingham', 'VA', 12288,17146); | |
insert into counties values ('Campbell', 'VA', 28877,54842); | |
insert into counties values ('Caroline', 'VA', 12471,28545); | |
insert into counties values ('Carroll', 'VA', 26695,30042); | |
insert into counties values ('Charles City', 'VA', 4676,7256); | |
insert into counties values ('Charlotte', 'VA', 14057,12586); | |
insert into counties values ('Chesterfield', 'VA', 40400,316236); | |
insert into counties values ('Clarke', 'VA', 7074,14034); | |
insert into counties values ('Craig', 'VA', 3452,5190); | |
insert into counties values ('Culpeper', 'VA', 13242,46689); | |
insert into counties values ('Cumberland', 'VA', 7252,10052); | |
insert into counties values ('Dickenson', 'VA', 23393,15903); | |
insert into counties values ('Dinwiddie', 'VA', 18839,28001); | |
insert into counties values ('Essex', 'VA', 6530,11151); | |
insert into counties values ('Fairfax', 'VA', 98557,1081726); | |
insert into counties values ('Fauquier', 'VA', 21248,65203); | |
insert into counties values ('Floyd', 'VA', 11351,15279); | |
insert into counties values ('Fluvanna', 'VA', 7121,25691); | |
insert into counties values ('Franklin', 'VA', 24560,56159); | |
insert into counties values ('Frederick', 'VA', 17537,78305); | |
insert into counties values ('Giles', 'VA', 18956,17286); | |
insert into counties values ('Gloucester', 'VA', 10343,36858); | |
insert into counties values ('Goochland', 'VA', 8934,21717); | |
insert into counties values ('Grayson', 'VA', 21379,15533); | |
insert into counties values ('Greene', 'VA', 4745,18403); | |
insert into counties values ('Greensville', 'VA', 16319,12243); | |
insert into counties values ('Halifax', 'VA', 41442,36241); | |
insert into counties values ('Hanover', 'VA', 21985,99863); | |
insert into counties values ('Henrico', 'VA', 57340,306935); | |
insert into counties values ('Henry', 'VA', 31219,54151); | |
insert into counties values ('Highland', 'VA', 4069,2321); | |
insert into counties values ('Isle of Wight', 'VA', 14906,35270); | |
insert into counties values ('James City', 'VA', 6317,67009); | |
insert into counties values ('King and Queen', 'VA', 6299,6945); | |
insert into counties values ('King George', 'VA', 6710,23584); | |
insert into counties values ('King William', 'VA', 7589,15935); | |
insert into counties values ('Lancaster', 'VA', 8640,11391); | |
insert into counties values ('Lee', 'VA', 36106,25587); | |
insert into counties values ('Loudoun', 'VA', 21147,312311); | |
insert into counties values ('Louisa', 'VA', 12826,33153); | |
insert into counties values ('Lunenburg', 'VA', 14116,12914); | |
insert into counties values ('Madison', 'VA', 8273,13308); | |
insert into counties values ('Mathews', 'VA', 7148,8978); | |
insert into counties values ('Mecklenburg', 'VA', 33497,32727); | |
insert into counties values ('Middlesex', 'VA', 6715,10959); | |
insert into counties values ('Montgomery', 'VA', 29780,94392); | |
insert into counties values ('Nelson', 'VA', 14042,15020); | |
insert into counties values ('New Kent', 'VA', 3995,18429); | |
insert into counties values ('Northampton', 'VA', 17300,12389); | |
insert into counties values ('Northumberland', 'VA', 10012,12330); | |
insert into counties values ('Nottoway', 'VA', 15479,15853); | |
insert into counties values ('Orange', 'VA', 12755,33481); | |
insert into counties values ('Page', 'VA', 15152,24042); | |
insert into counties values ('Patrick', 'VA', 15642,18490); | |
insert into counties values ('Pittsylvania', 'VA', 66096,63506); | |
insert into counties values ('Powhatan', 'VA', 5556,28046); | |
insert into counties values ('Prince Edward', 'VA', 15398,23368); | |
insert into counties values ('Prince George', 'VA', 19679,35725); | |
insert into counties values ('Prince William', 'VA', 22612,402002); | |
insert into counties values ('Pulaski', 'VA', 27758,34872); | |
insert into counties values ('Rappahannock', 'VA', 6112,7373); | |
insert into counties values ('Richmond', 'VA', 6189,9254); | |
insert into counties values ('Roanoke', 'VA', 41486,92376); | |
insert into counties values ('Rockbridge', 'VA', 23359,22307); | |
insert into counties values ('Rockingham', 'VA', 35079,76314); | |
insert into counties values ('Russell', 'VA', 26818,28897); | |
insert into counties values ('Scott', 'VA', 27640,23177); | |
insert into counties values ('Shenandoah', 'VA', 21169,41993); | |
insert into counties values ('Smyth', 'VA', 30187,32208); | |
insert into counties values ('Southampton', 'VA', 26522,18570); | |
insert into counties values ('Spotsylvania', 'VA', 11920,122397); | |
insert into counties values ('Stafford', 'VA', 11902,128961); | |
insert into counties values ('Surry', 'VA', 6220,7058); | |
insert into counties values ('Sussex', 'VA', 12785,12087); | |
insert into counties values ('Tazewell', 'VA', 47512,45078); | |
insert into counties values ('Warren', 'VA', 14801,37575); | |
insert into counties values ('Washington', 'VA', 37536,54876); | |
insert into counties values ('Westmoreland', 'VA', 10148,17454); | |
insert into counties values ('Wise', 'VA', 56336,41452); | |
insert into counties values ('Wythe', 'VA', 23327,29235); | |
insert into counties values ('York', 'VA', 11750,65464); | |
insert into counties values ('Alexandria', 'VA', 61787,139966); | |
insert into counties values ('Bedford', 'VA', 0,6222); | |
insert into counties values ('Bristol', 'VA', 15954,17835); | |
insert into counties values ('Buena Vista', 'VA', 5214,6650); | |
insert into counties values ('Charlottesville', 'VA', 25969,43475); | |
insert into counties values ('Chesapeake', 'VA', 110371,222209); | |
insert into counties values ('Clifton Forge', 'VA', 5795,0); | |
insert into counties values ('Colonial Heights', 'VA', 6077,17411); | |
insert into counties values ('Covington', 'VA', 0,5961); | |
insert into counties values ('Danville', 'VA', 35066,43055); | |
insert into counties values ('Emporia', 'VA', 0,5927); | |
insert into counties values ('Fairfax', 'VA', 0,22565); | |
insert into counties values ('Falls Church', 'VA', 7535,12332); | |
insert into counties values ('Franklin', 'VA', 0,8582); | |
insert into counties values ('Fredericksburg', 'VA', 12158,24286); | |
insert into counties values ('Galax', 'VA', 0,7042); | |
insert into counties values ('Hampton', 'VA', 60994,137436); | |
insert into counties values ('Harrisonburg', 'VA', 10810,48914); | |
insert into counties values ('Hopewell', 'VA', 10219,22591); | |
insert into counties values ('Lexington', 'VA', 0,7042); | |
insert into counties values ('Lynchburg', 'VA', 47727,75568); | |
insert into counties values ('Manassas', 'VA', 0,37821); | |
insert into counties values ('Manassas Park', 'VA', 0,14273); | |
insert into counties values ('Martinsville', 'VA', 17251,13821); | |
insert into counties values ('Newport News', 'VA', 82233,180719); | |
insert into counties values ('Norfolk', 'VA', 213513,242803); | |
insert into counties values ('Norton', 'VA', 0,3958); | |
insert into counties values ('Petersburg', 'VA', 35054,32420); | |
insert into counties values ('Poquoson', 'VA', 0,12150); | |
insert into counties values ('Portsmouth', 'VA', 80039,95535); | |
insert into counties values ('Radford', 'VA', 9026,16408); | |
insert into counties values ('Richmond', 'VA', 230310,204214); | |
insert into counties values ('Roanoke', 'VA', 91921,97032); | |
insert into counties values ('Salem', 'VA', 0,24802); | |
insert into counties values ('South Boston', 'VA', 0,0); | |
insert into counties values ('Staunton', 'VA', 19927,23746); | |
insert into counties values ('Suffolk', 'VA', 37577,84585); | |
insert into counties values ('Virginia Beach', 'VA', 42277,437994); | |
insert into counties values ('Waynesboro', 'VA', 12357,21006); | |
insert into counties values ('Williamsburg', 'VA', 6735,14068); | |
insert into counties values ('Winchester', 'VA', 13841,26203); | |
insert into counties values ('Adams', 'WA', 6584,18728); | |
insert into counties values ('Asotin', 'WA', 10878,21623); | |
insert into counties values ('Benton', 'WA', 51370,175177); | |
insert into counties values ('Chelan', 'WA', 39301,72453); | |
insert into counties values ('Clallam', 'WA', 26396,71404); | |
insert into counties values ('Clark', 'WA', 85307,425363); | |
insert into counties values ('Columbia', 'WA', 4860,4078); | |
insert into counties values ('Cowlitz', 'WA', 53369,102410); | |
insert into counties values ('Douglas', 'WA', 10817,38431); | |
insert into counties values ('Ferry', 'WA', 4096,7551); | |
insert into counties values ('Franklin', 'WA', 13563,78163); | |
insert into counties values ('Garfield', 'WA', 3204,2266); | |
insert into counties values ('Grant', 'WA', 24346,89120); | |
insert into counties values ('Grays Harbor', 'WA', 53644,72797); | |
insert into counties values ('Island', 'WA', 11079,78506); | |
insert into counties values ('Jefferson', 'WA', 11618,29872); | |
insert into counties values ('King', 'WA', 732992,1931249); | |
insert into counties values ('Kitsap', 'WA', 75724,251133); | |
insert into counties values ('Kittitas', 'WA', 22235,40915); | |
insert into counties values ('Klickitat', 'WA', 12049,20318); | |
insert into counties values ('Lewis', 'WA', 43755,75455); | |
insert into counties values ('Lincoln', 'WA', 10970,10570); | |
insert into counties values ('Mason', 'WA', 15022,60699); | |
insert into counties values ('Okanogan', 'WA', 29131,41120); | |
insert into counties values ('Pacific', 'WA', 16558,20920); | |
insert into counties values ('Pend Oreille', 'WA', 7413,13001); | |
insert into counties values ('Pierce', 'WA', 275876,795225); | |
insert into counties values ('San Juan', 'WA', 3245,15769); | |
insert into counties values ('Skagit', 'WA', 43273,116901); | |
insert into counties values ('Skamania', 'WA', 4788,11066); | |
insert into counties values ('Snohomish', 'WA', 111580,713335); | |
insert into counties values ('Spokane', 'WA', 221561,471221); | |
insert into counties values ('Stevens', 'WA', 18580,43531); | |
insert into counties values ('Thurston', 'WA', 44884,252264); | |
insert into counties values ('Wahkiakum', 'WA', 3835,3978); | |
insert into counties values ('Walla Walla', 'WA', 40135,58781); | |
insert into counties values ('Whatcom', 'WA', 66733,201140); | |
insert into counties values ('Whitman', 'WA', 32469,44776); | |
insert into counties values ('Yakima', 'WA', 135723,243231); | |
insert into counties values ('Barbour', 'WV', 19745,16589); | |
insert into counties values ('Berkeley', 'WV', 30359,104169); | |
insert into counties values ('Boone', 'WV', 33173,24629); | |
insert into counties values ('Braxton', 'WV', 18082,14523); | |
insert into counties values ('Brooke', 'WV', 26904,24069); | |
insert into counties values ('Cabell', 'WV', 108035,96319); | |
insert into counties values ('Calhoun', 'WV', 10259,7627); | |
insert into counties values ('Clay', 'WV', 14961,9386); | |
insert into counties values ('Doddridge', 'WV', 9026,8202); | |
insert into counties values ('Fayette', 'WV', 82443,46039); | |
insert into counties values ('Gilmer', 'WV', 9746,8693); | |
insert into counties values ('Grant', 'WV', 8756,11937); | |
insert into counties values ('Greenbrier', 'WV', 39295,35480); | |
insert into counties values ('Hampshire', 'WV', 12577,23964); | |
insert into counties values ('Hancock', 'WV', 34388,30676); | |
insert into counties values ('Hardy', 'WV', 10032,14025); | |
insert into counties values ('Harrison', 'WV', 85296,69099); | |
insert into counties values ('Jackson', 'WV', 15299,29211); | |
insert into counties values ('Jefferson', 'WV', 17184,53498); | |
insert into counties values ('Kanawha', 'WV', 239629,193063); | |
insert into counties values ('Lewis', 'WV', 21074,16372); | |
insert into counties values ('Lincoln', 'WV', 22466,21720); | |
insert into counties values ('Logan', 'WV', 77391,36743); | |
insert into counties values ('McDowell', 'WV', 98887,22113); | |
insert into counties values ('Marion', 'WV', 71521,56418); | |
insert into counties values ('Marshall', 'WV', 36893,33107); | |
insert into counties values ('Mason', 'WV', 23537,27324); | |
insert into counties values ('Mercer', 'WV', 75013,62264); | |
insert into counties values ('Mineral', 'WV', 22333,28212); | |
insert into counties values ('Mingo', 'WV', 47409,26839); | |
insert into counties values ('Monongalia', 'WV', 60797,96189); | |
insert into counties values ('Monroe', 'WV', 13123,13502); | |
insert into counties values ('Morgan', 'WV', 8276,17541); | |
insert into counties values ('Nicholas', 'WV', 27696,26233); | |
insert into counties values ('Ohio', 'WV', 71672,44443); | |
insert into counties values ('Pendleton', 'WV', 9313,7695); | |
insert into counties values ('Pleasants', 'WV', 6369,7605); | |
insert into counties values ('Pocahontas', 'WV', 12480,8719); | |
insert into counties values ('Preston', 'WV', 31399,33520); | |
insert into counties values ('Putnam', 'WV', 21021,55486); | |
insert into counties values ('Raleigh', 'WV', 96273,78859); | |
insert into counties values ('Randolph', 'WV', 30558,29405); | |
insert into counties values ('Ritchie', 'WV', 12535,10449); | |
insert into counties values ('Roane', 'WV', 18408,14926); | |
insert into counties values ('Summers', 'WV', 19183,13927); | |
insert into counties values ('Taylor', 'WV', 18422,16895); | |
insert into counties values ('Tucker', 'WV', 10600,7141); | |
insert into counties values ('Tyler', 'WV', 10535,9208); | |
insert into counties values ('Upshur', 'WV', 19242,24254); | |
insert into counties values ('Wayne', 'WV', 38696,42481); | |
insert into counties values ('Webster', 'WV', 17888,9154); | |
insert into counties values ('Wetzel', 'WV', 20154,16583); | |
insert into counties values ('Wirt', 'WV', 5119,5717); | |
insert into counties values ('Wood', 'WV', 66540,86956); | |
insert into counties values ('Wyoming', 'WV', 37540,23796); | |
insert into counties values ('Adams', 'WI', 7906,20875); | |
insert into counties values ('Ashland', 'WI', 19461,16157); | |
insert into counties values ('Barron', 'WI', 34703,45870); | |
insert into counties values ('Bayfield', 'WI', 13760,15014); | |
insert into counties values ('Brown', 'WI', 98314,248007); | |
insert into counties values ('Buffalo', 'WI', 14719,13587); | |
insert into counties values ('Burnett', 'WI', 10236,15457); | |
insert into counties values ('Calumet', 'WI', 18840,48971); | |
insert into counties values ('Chippewa', 'WI', 42839,62415); | |
insert into counties values ('Clark', 'WI', 32459,34690); | |
insert into counties values ('Columbia', 'WI', 34023,56833); | |
insert into counties values ('Crawford', 'WI', 17652,16644); | |
insert into counties values ('Dane', 'WI', 169357,488073); | |
insert into counties values ('Dodge', 'WI', 57611,88759); | |
insert into counties values ('Door', 'WI', 20870,27785); | |
insert into counties values ('Douglas', 'WI', 46715,44159); | |
insert into counties values ('Dunn', 'WI', 27341,43857); | |
insert into counties values ('Eau Claire', 'WI', 54187,98736); | |
insert into counties values ('Florence', 'WI', 3756,4423); | |
insert into counties values ('Fond du Lac', 'WI', 67829,101633); | |
insert into counties values ('Forest', 'WI', 9437,9304); | |
insert into counties values ('Grant', 'WI', 41460,51208); | |
insert into counties values ('Green', 'WI', 24172,36842); | |
insert into counties values ('Green Lake', 'WI', 14749,19051); | |
insert into counties values ('Iowa', 'WI', 19610,23687); | |
insert into counties values ('Iron', 'WI', 8714,5916); | |
insert into counties values ('Jackson', 'WI', 16073,20449); | |
insert into counties values ('Jefferson', 'WI', 43069,83686); | |
insert into counties values ('Juneau', 'WI', 18930,26664); | |
insert into counties values ('Kenosha', 'WI', 75238,166426); | |
insert into counties values ('Kewaunee', 'WI', 17366,20574); | |
insert into counties values ('La Crosse', 'WI', 67587,114638); | |
insert into counties values ('Lafayette', 'WI', 18137,16836); | |
insert into counties values ('Langlade', 'WI', 21975,19977); | |
insert into counties values ('Lincoln', 'WI', 22235,28743); | |
insert into counties values ('Manitowoc', 'WI', 67159,81442); | |
insert into counties values ('Marathon', 'WI', 80337,134063); | |
insert into counties values ('Marinette', 'WI', 35748,41749); | |
insert into counties values ('Marquette', 'WI', 8839,15404); | |
insert into counties values ('Menominee', 'WI', 0,4232); | |
insert into counties values ('Milwaukee', 'WI', 871047,947735); | |
insert into counties values ('Monroe', 'WI', 31378,44673); | |
insert into counties values ('Oconto', 'WI', 26238,37660); | |
insert into counties values ('Oneida', 'WI', 20648,35998); | |
insert into counties values ('Outagamie', 'WI', 81722,176695); | |
insert into counties values ('Ozaukee', 'WI', 23361,86395); | |
insert into counties values ('Pepin', 'WI', 7462,7469); | |
insert into counties values ('Pierce', 'WI', 21448,41019); | |
insert into counties values ('Polk', 'WI', 24944,44205); | |
insert into counties values ('Portage', 'WI', 34858,70019); | |
insert into counties values ('Price', 'WI', 16344,14159); | |
insert into counties values ('Racine', 'WI', 109585,195408); | |
insert into counties values ('Richland', 'WI', 19245,18021); | |
insert into counties values ('Rock', 'WI', 92778,160331); | |
insert into counties values ('Rusk', 'WI', 16790,14755); | |
insert into counties values ('St. Croix', 'WI', 25905,84345); | |
insert into counties values ('Sauk', 'WI', 38120,61976); | |
insert into counties values ('Sawyer', 'WI', 10323,16557); | |
insert into counties values ('Shawano', 'WI', 35249,41949); | |
insert into counties values ('Sheboygan', 'WI', 80631,115507); | |
insert into counties values ('Taylor', 'WI', 18456,20689); | |
insert into counties values ('Trempealeau', 'WI', 23730,28816); | |
insert into counties values ('Vernon', 'WI', 27906,29773); | |
insert into counties values ('Vilas', 'WI', 9363,21430); | |
insert into counties values ('Walworth', 'WI', 41584,102228); | |
insert into counties values ('Washburn', 'WI', 11665,15911); | |
insert into counties values ('Washington', 'WI', 33902,131887); | |
insert into counties values ('Waukesha', 'WI', 85901,389891); | |
insert into counties values ('Waupaca', 'WI', 35056,52410); | |
insert into counties values ('Waushara', 'WI', 13920,24496); | |
insert into counties values ('Winnebago', 'WI', 91103,166994); | |
insert into counties values ('Wood', 'WI', 50500,74749); | |
insert into counties values ('Albany', 'WY', 19055,36299); | |
insert into counties values ('Big Horn', 'WY', 13176,11668); | |
insert into counties values ('Campbell', 'WY', 4839,46133); | |
insert into counties values ('Carbon', 'WY', 15742,15885); | |
insert into counties values ('Converse', 'WY', 5933,13833); | |
insert into counties values ('Crook', 'WY', 4738,7083); | |
insert into counties values ('Fremont', 'WY', 19580,40123); | |
insert into counties values ('Goshen', 'WY', 12634,13249); | |
insert into counties values ('Hot Springs', 'WY', 5250,4812); | |
insert into counties values ('Johnson', 'WY', 4707,8569); | |
insert into counties values ('Laramie', 'WY', 47662,91738); | |
insert into counties values ('Lincoln', 'WY', 9023,18106); | |
insert into counties values ('Natrona', 'WY', 31437,75450); | |
insert into counties values ('Niobrara', 'WY', 4701,2484); | |
insert into counties values ('Park', 'WY', 15535,28205); | |
insert into counties values ('Platte', 'WY', 7925,8667); | |
insert into counties values ('Sheridan', 'WY', 20185,29116); | |
insert into counties values ('Sublette', 'WY', 2481,10247); | |
insert into counties values ('Sweetwater', 'WY', 22017,43806); | |
insert into counties values ('Teton', 'WY', 2593,21294); | |
insert into counties values ('Uinta', 'WY', 7331,21118); | |
insert into counties values ('Washakie', 'WY', 7252,8533); | |
insert into counties values ('Weston', 'WY', 6733,7208); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment