Skip to content

Instantly share code, notes, and snippets.

@dgraham
Created March 4, 2016 17:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dgraham/8fce9f6871fc6ef075b6 to your computer and use it in GitHub Desktop.
Save dgraham/8fce9f6871fc6ef075b6 to your computer and use it in GitHub Desktop.
Assignment 3—SQL script
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