C# parse csv file via CSVHelper

Install-Package CSVHelper

 

using System.IO;
using CsvHelper;
using CsvHelper.Configuration;

namespace ConsoleApp5
{
    internal class Program
    {
        static void Main(string[] args)
        {
            ParseCSVFile("../../../uscounties.csv");
            Console.ReadLine();
        }

        static void ParseCSVFile(string csvFile)
        {
            if (!File.Exists(csvFile))
            {
                return;
            }
            string csvStr = File.ReadAllText(csvFile);
            if (string.IsNullOrWhiteSpace(csvStr))
            {
                return;
            }
            using (StringReader sr = new StringReader(csvStr))
            {
                var cfg = new CsvConfiguration(System.Globalization.CultureInfo.InvariantCulture)
                {
                    PrepareHeaderForMatch = args => args.Header.ToLower(),
                    MissingFieldFound = null,
                    HeaderValidated = null
                };

                CsvReader reader = new CsvReader(sr, cfg);
                var countyList = reader.GetRecords<CountyModel>().ToList();
                var stateList = countyList.Select(x => x.State_Name).Distinct().ToList();
                var countyNames = countyList.Select(x => x.County).ToList();
                Console.WriteLine($"{DateTime.Now},state:{string.Join(",",stateList)}");
                
                Console.WriteLine($"\n\n\n\n\nCounty count:{countyNames.Count}");
                Console.WriteLine($"{string.Join(",", countyNames)}");
            }
        }
    }

    public class CountyModel
    {
        public string County { get; set; }
        public string County_Ascii { get; set; }
        public string County_Full { get; set; }
        public string County_Fips { get; set; }
        public string State_Name { get; set; }
        public double Lat { get; set; }
        public string Lng { get; set; }
        public long Population { get; set; }
    }
}

 

 

 

2026-09-12 21:59:20,state:California,Illinois,Texas,Arizona,Florida,New York,Nevada,Washington,Michigan,Massachusetts,Pennsylvania,Ohio,Minnesota,Utah,North Carolina,Virginia,Georgia,Maryland,Hawaii,Missouri,Connecticut,Indiana,New Jersey,Wisconsin,Tennessee,Oklahoma,Oregon,Kentucky,Colorado,District of Columbia,New Mexico,Alabama,Rhode Island,Kansas,Nebraska,Delaware,South Carolina,Idaho,Iowa,Louisiana,New Hampshire,Arkansas,Maine,Alaska,Mississippi,South Dakota,North Dakota,West Virginia,Vermont,Montana,Wyoming





County count:3144
Los Angeles,Cook,Harris,Maricopa,San Diego,Orange,Miami-Dade,Kings,Dallas,Riverside,Clark,Queens,King,San Bernardino,Tarrant,Bexar,Broward,Santa Clara,Wayne,Alameda,Middlesex,New York,Sacramento,Philadelphia,Palm Beach,Suffolk,Hillsborough,Orange,Bronx,Nassau,Franklin,Travis,Oakland,Hennepin,Cuyahoga,Allegheny,Salt Lake,Wake,Contra Costa,Collin,Mecklenburg,Fairfax,Fulton,Montgomery,Pima,Duval,Fresno,Honolulu,Westchester,St. Louis,Gwinnett,Denton,Capitol,Marion,Pinellas,Bergen,Prince George's,Erie,Pierce,DuPage,Milwaukee,Shelby,Kern,Fort Bend,Hidalgo,Macomb,Middlesex,El Paso,Worcester,Montgomery,Essex,Baltimore,Snohomish,Ventura,Hamilton,San Francisco,Lee,Essex,Oklahoma,Multnomah,San Joaquin,Polk,Suffolk,Jefferson,Cobb,DeKalb,Monroe,El Paso,San Mateo,Norfolk,Jackson,Denver,Hudson,Davidson,Lake,Utah,Will,Montgomery,District of Columbia,Tulsa,Bernalillo,Williamson,Jefferson,Providence,Kent,Arapahoe,Ocean,Bucks,Monmouth,Brevard,Western Connecticut,Johnson,Pasco,Washington,Anne Arundel,Douglas,Bristol,Volusia,Jefferson,Union,Delaware,New Castle,Baltimore,Dane,South Central Connecticut,Lancaster,Stanislaus,Spokane,Greenville,Guilford,Chester,Ramsey,Summit,Montgomery,Plymouth,Adams,Sedgwick,Camden,Passaic,Ada,Kane,Clark,Morris,Polk,Lake,Washoe,Richmond,Knox,Prince William,Sonoma,Seminole,Tulare,Onondaga,Pinal,Burlington,York,Hampden,Sarasota,Virginia Beach,Naugatuck Valley,East Baton Rouge,Solano,Dakota,Santa Barbara,Monterey,Berks,Loudoun,Jefferson,Manatee,Lucas,Osceola,Hillsborough,Cameron,Clackamas,Richland,Charleston,Placer,St. Charles,Lake,Mobile,Waukesha,Orange,Madison,Genesee,Marion,Pulaski,Collier,Butler,Allen,Brazoria,Forsyth,Bell,Mercer,Lane,Horry,Lehigh,Chesterfield,Douglas,Hamilton,Stark,Orleans,Davis,Anoka,Washtenaw,Larimer,Hamilton,Rutherford,St. Lucie,Galveston,Nueces,Westmoreland,Weld,Somerset,Marion,Spartanburg,Rockland,Cumberland,Howard,Henrico,Durham,Greater Bridgeport,Boulder,Luzerne,Lancaster,Escambia,Fayette,Rockingham,Lubbock,Northampton,Lorain,Albany,McHenry,Cumberland,Gloucester,St. Johns,Lexington,Benton,Greene,Ottawa,Chatham,Cleveland,Thurston,Clayton,Dutchess,Leon,York,Merced,Dauphin,Anchorage,St. Louis,Frederick,Alachua,Ingham,Winnebago,San Luis Obispo,Cherokee,Southeastern Connecticut,Kitsap,Atlantic,Washington,Buncombe,St. Joseph,St. Tammany,Brown,Weber,Webb,Erie,Hays,Cumberland,Forsyth,McLennan,Santa Cruz,Madison,Harford,Kalamazoo,Williamson,Clay,Marin,Yakima,Washington,Sussex,Jefferson,St. Clair,Chesapeake,Union,Canyon,Warren,Henry,Lafayette,Baldwin,Berkeley,Yavapai,Brazos,Smith,Saratoga,Tuscaloosa,Arlington,Cabarrus,New Hanover,Gaston,Johnston,Montgomery,Norfolk,Lake,Barnstable,Whatcom,Shelby,Caddo,Linn,Jefferson,Richmond,Oneida,Clay,Delaware,Montgomery,Mahoning,Doña Ana,Jackson,Yolo,Mohave,Hinds,York,Okaloosa,Lackawanna,Ellis,Benton,Hall,Yuma,Clermont,Harrison,Niagara,Anderson,Washington,Champaign,Butte,Onslow,Elkhart,Calcasieu,Hernando,Deschutes,Richmond,Hawaii,Sumner,Muscogee,Minnehaha,Charlotte,Trumbull,St. Louis,Santa Rosa,Racine,Sarpy,Broome,Butler,Iredell,Washington,Livingston,Johnson,Beaufort,Sangamon,Cass,Outagamie,El Dorado,DeSoto,Tippecanoe,Saginaw,Boone,Kent,Bay,Newport News,Comal,Medina,Guadalupe,Hendricks,Ulster,Kootenai,Licking,Shasta,Lee,Imperial,Vanderburgh,Peoria,Paulding,Shawnee,Pitt,Alamance,Kanawha,Muskegon,Lower Connecticut River Valley,Carroll,Porter,Midland,Scott,Aiken,Davidson,Kaufman,Winnebago,McLean,Kent,Kenton,Charles,Chittenden,Greene,Houston,Pueblo,Canadian,Yellowstone,Kenosha,Wyandotte,Monroe,Dorchester,Indian River,Beaver,Johnson,Parker,Ector,Maui,Olmsted,Rock,Catawba,Stafford,Fairfield,Citrus,Columbia,Martin,Hampshire,Portage,Madera,Stearns,Sullivan,Schenectady,Rensselaer,St. Clair,Jackson,Rankin,Wilson,Mesa,Centre,Ouachita,Franklin,Alexandria,Johnson,Bibb,Santa Fe,Merrimack,Washington,Monroe,Penobscot,Scott,Sandoval,Cumberland,Kings,Berrien,Coweta,Brunswick,Rowan,Orange,Wright,Livingston,Douglas,Spotsylvania,Randolph,Randall,Taylor,Sussex,Jackson,Coconino,Lebanon,Schuylkill,Sumter,Grayson,Rock Island,Monroe,Warren,Cache,Boone,Blount,Harnett,Marathon,Washington,Kendall,Hampton,Florence,Tangipahoa,Washington,Clark,Napa,Pickens,Humboldt,Calhoun,Strafford,Wood,Madison,Cambria,Skagit,Black Hawk,Linn,Washington,Ascension,Tazewell,Hunterdon,Wichita,Bossier,Clarke,Bonneville,Berkeley,Berkshire,Sebastian,Faulkner,Rapides,Saline,Kennebec,Flagler,Fayette,Cochise,Chautauqua,Gregg,Richland,Carroll,Morgan,Jasper,Clark,Gallatin,Rockwall,Fayette,Comanche,Allegan,Blair,San Juan,Missoula,La Crosse,Douglas,Lowndes,Tom Green,Wayne,Henderson,Newton,Sheboygan,Oswego,Robeson,Wayne,Calhoun,Potter,St. Mary's,Jefferson,Albemarle,Pennington,Lycoming,Androscoggin,Craighead,Northwest Hills,Bartow,Matanuska-Susitna,Hanover,Ontario,Cowlitz,Delaware,Douglas,Hardin,LaPorte,Madison,Limestone,Bradley,Warren,Cass,Flathead,Platte,Miami,Carver,Mercer,Eaton,Hunt,Yamhill,LaSalle,Navajo,Houston,Dallas,Maury,St. Lawrence,Monongalia,Eau Claire,Kankakee,Bastrop,Woodbury,Terrebonne,Adams,Vigo,Franklin,Highlands,Walworth,Cecil,Wicomico,Moore,Sumter,Tompkins,Lancaster,Fond du Lac,Daviess,Whitfield,Liberty,Walton,Etowah,Bay,Craven,Nevada,Macon,Grant,Allen,Laramie,Cleveland,Columbiana,DeKalb,Burleigh,Sherburne,Story,Garland,Marshall,Floyd,Sevier,Madison,Montgomery,Dubuque,Franklin,Sutter,Suffolk,Rogers,Lenawee,Roanoke,Putnam,Nassau,Portsmouth,Ashtabula,Roanoke,Northeastern Connecticut,Benton,Lafourche,Nash,Grand Traverse,St. Croix,Lauderdale,Madison,Geauga,Fairbanks North Star,Rockdale,Frederick,Cape May,Calvert,St. Clair,Twin Falls,Campbell,Pottawattamie,Ozaukee,Christian,Cabell,Lincoln,Steuben,Tuscarawas,Rockingham,Grafton,Bowie,Victoria,Wayne,Cullman,Northumberland,Mendocino,Barrow,Polk,Elmore,Bannock,Lapeer,Dodge,Josephine,Burke,Angelina,Island,Wagoner,Muskingum,Jefferson,Rockingham,Glynn,Orange,Lewis,Lawrence,Henderson,Jackson,Coryell,Newport,Cascade,Yuba,Hancock,Bullitt,Midland,Howard,Buchanan,Bartholomew,Wood,Orangeburg,Leavenworth,Dougherty,Indiana,Lee,Payne,Walton,Cape Girardeau,Crawford,Bulloch,Putnam,Chemung,Monroe,St. Landry,Manitowoc,Talladega,James City,Floyd,Bedford,Caldwell,Oconee,Kosciusko,Walker,Chelan,Chatham,Natrona,Umatilla,Sullivan,Clinton,Lynchburg,Tooele,Wilson,Anderson,Clearfield,Clinton,Valencia,Forrest,Augusta,White,Clallam,Cheshire,Grays Harbor,Cole,Ross,Broomfield,Cattaraugus,Van Buren,Robertson,Lonoke,Putnam,Cayuga,Wise,Hancock,Boone,Erie,Fauquier,Franklin,Wood,Lea,Kauai,Lewis and Clark,Pottawatomie,Raleigh,Grand Forks,Creek,Somerset,Morgan,Scioto,Vermilion,DeKalb,Christian,Riley,Columbia,Greene,Lauderdale,Surry,York,Franklin,Portage,Lincoln,McKinley,Troup,Klamath,San Patricio,Harrison,Blue Earth,Greenwood,Oldham,Carteret,Effingham,Ward,Spalding,Otero,Walker,Laurens,Catoosa,Iberia,Kershaw,Butler,Lake,Shiawassee,Mason,Rice,Montcalm,Crow Wing,McCracken,Allegany,Liberty,Madison,Union,San Benito,Marquette,Aroostook,St. Francois,Williamson,Chippewa,Ionia,Jones,Muskogee,Wayne,Grant,Starr,Clay,Sauk,Wilkes,Pulaski,Hood,Lee,Lamar,Hamblen,Pender,Warren,Belmont,Carbon,Columbia,Apache,Salem,Warrick,Tehama,Nacogdoches,Marion,Harrison,Rutherford,Walker,Coos,Georgetown,Jefferson,Adams,Belknap,Stanly,Armstrong,Isabella,Jefferson,Chaves,Pope,Cumberland,Barry,Knox,Lincoln,Laurel,Haywood,Van Zandt,Darlington,Hall,Garfield,Iron,Walla Walla,Garfield,Athens,Lyon,Tipton,Reno,Waller,Livingston,Box Elder,Crawford,Eddy,Columbia,St. Joseph,Granville,Pike,Washington,Otter Tail,Rutland,Kenai Peninsula,Pickaway,Newton,Otsego,Washington,Autauga,Bradford,Pittsylvania,Herkimer,Coffee,Scott,Blount,Sampson,Jefferson,Oxford,Gordon,Washington,Russell,Sandusky,Loudon,Mercer,Anderson,Carson City,Lafayette,Huron,Columbia,Maverick,Colbert,Chisago,Windsor,Hawkins,Lowndes,Genesee,Hardin,Pearl River,Putnam,Vermilion,Camden,Acadia,Jefferson,Lawrence,Pike,Carter,Cherokee,Grady,Taney,Hancock,La Plata,Dickson,Marion,Campbell,Roane,Eagle,Franklin,Watauga,Whiteside,Coffee,Lenoir,McMinn,Seneca,Johnson,Navarro,Madison,Jessamine,Tuolumne,Warren,Culpeper,Nye,Elko,Washington,Pulaski,Hoke,Gila,Worcester,Saline,Medina,Columbia,Kerr,Washington,Boone,Grundy,Jackson,Jackson,Tuscola,Calumet,Rusk,Polk,Wilson,Burnet,Fulton,Ashland,Bedford,Logan,Cherokee,Franklin,Queen Anne's,Carroll,Oktibbeha,Grant,Darke,Waupaca,Cass,Chambers,Ogle,St. Charles,Harrisonburg,St. Martin,Wayne,Dearborn,Bonner,Atascosa,Lincoln,Somerset,Gibson,Newaygo,Lamar,Franklin,Buffalo,Bristol,Columbus,Henry,Venango,Laurens,Winona,Bingham,Fremont,Douglas,Dale,Montgomery,Duplin,Shelby,Le Flore,Knox,Henry,Santa Cruz,Edgecombe,Caldwell,Henry,Kendall,Carter,Bryan,Bryan,Jackson,Lincoln,Stevens,Goodhue,Cherokee,Shelby,Boyd,Tioga,St. Mary,Habersham,Val Verde,Monroe,Halifax,Curry,Nelson,Bedford,Noble,Greene,Crittenden,Campbell,Kittitas,Allegany,Vernon,Whitman,Wood,Barron,Coles,Ravalli,Franklin,Jackson,Beltrami,Greene,Chenango,Marshall,Clinton,Calaveras,Cortland,Perry,Colquitt,Monroe,Hancock,Auglaize,Logan,Mifflin,Osage,Chilton,Windham,Thomas,Hillsdale,Polk,Dunn,Charlottesville,Levy,Lawrence,Suwannee,Branch,Itasca,McClain,Shelby,Phelps,Stokes,Washington,Hopkins,Lawrence,Barren,Shenandoah,McDowell,Callaway,Beaufort,Delaware,Madison,St. Bernard,Holmes,Douglas,Macoupin,Henderson,Douglas,Davie,Kandiyohi,Franklin,Jefferson,Brown,Montrose,DeKalb,Erath,Polk,Chesterfield,Jackson,Stephenson,Sullivan,Gadsden,Camden,Huntingdon,Baldwin,Kay,Dubois,Pittsburg,Oconee,Stephens,Highland,Siskiyou,Okanogan,Pettis,Coffee,Fayette,Prince George,Cooke,Warren,Manassas,Summit,Washington,Nez Perce,Cerro Gordo,Isanti,Pierce,Upshur,Muscatine,Mercer,Union,Baxter,Hendry,Miller,Richmond,Vance,Fulton,Danville,Warren,Marinette,Butler,Clinton,Cheatham,Wharton,Crawford,Benton,Ohio,Sweetwater,Warren,Tift,Amador,Gratiot,Clatsop,Delaware,Mecosta,Latah,Shawano,Knox,Tioga,Tallapoosa,Pasquotank,Okeechobee,LaGrange,Preble,St. John the Baptist,Murray,Webster,Sanilac,Howell,Mower,Waldo,Marshall,Rio Arriba,Ottawa,Louisa,Isle of Wight,McKean,Sequoyah,Harrison,Campbell,Wyoming,Snyder,Tazewell,Orleans,Mayes,Pike,Oconto,Douglas,Williams,Person,Fremont,Gloucester,Fayette,Graham,Mississippi,Crawford,Avoyelles,Jim Wells,Champaign,Colleton,Lawrence,Des Moines,Newberry,Brown,Defiance,Montgomery,Woodford,Albany,Pontotoc,Calloway,Guernsey,Susquehanna,Independence,Oneida,Wayne,Boone,Finney,Jasper,Macon,Scott,Warren,Talbot,Union,Brown,Dare,Orange,Clinton,Hopkins,Houghton,Cass,Addison,Covington,Yadkin,Steele,Dodge,Hill,Fannin,Franklin,Sagadahoc,Putnam,Bennington,Clark,Clarion,Warren,Uintah,Green,Marion,Essex,Clinton,Whitley,Okmulgee,Webster,Dallas,Cocke,Delta,Huntington,McLeod,Coshocton,Williams,Natchitoches,Beauregard,Washington,Wasatch,Graves,Escambia,Jefferson,Carlton,Dyer,Alexander,Laclede,Matagorda,Chippewa,Adams,Sioux,Lincoln,Harris,Marshall,Knox,Ware,Lincoln,Scotts Bluff,Webster,Geary,Silver Bow,Miami,Livingston,Perry,Madison,Greenup,Wise,Morrow,Wakulla,DeSoto,Wapello,Brookings,Becker,Floyd,Monroe,Barry,Pickens,Miami,Lincoln,Greene,Clark,Steuben,Platte,Whitley,Taos,Effingham,Lumpkin,Nicollet,Cowley,Putnam,Alcorn,Morrison,Lincoln,Chambers,Preston,Emmet,Wexford,Ford,Botetourt,Rhea,Marshall,Lee,Lincoln,Morton,Harvey,Monroe,Transylvania,Pulaski,Caroline,Daviess,Marion,Halifax,Lee,Scotland,Jefferson,Christian,Petersburg,Accomack,Stark,Lawrence,Jasper,Hot Spring,Jefferson,Lafayette,Morgan,Fulton,Weakley,Gibson,Jefferson,Pike,Clinton,Seneca,Lee,Bureau,Panola,Dorchester,Jasper,Jackson,Lake,Claiborne,Polk,Gilmer,Henry,Greenbrier,Howard,Lyon,Chester,Jasper,Hale,Caroline,Evangeline,Sheridan,Stone,Franklin,Malheur,Jefferson Davis,Juneau,Marshall,Delta,Powhatan,Pontotoc,Madison,Amherst,Logan,Titus,Grimes,Washington,Haralson,Coos,Clare,Austin,Huron,Bee,Adams,Vernon,Greene,Summit,Cass,Clarendon,Wayne,Boyle,Montgomery,McCurtain,Wabash,Trempealeau,Polk,Freeborn,Giles,Currituck,Muhlenberg,Kleberg,Meade,Mecklenburg,Elk,Hardin,Caledonia,Obion,Park,Door,Franklin,Lassen,Ottawa,Williamsburg,Dawson,McPherson,Meade,Randolph,Schoharie,Knox,Marshall,Iberville,Orange,Sanpete,Monroe,Pine,Bladen,Cherokee,Bolivar,Morgan,Smyth,Elmore,Palo Pinto,Marion,Mason,Decatur,Marion,Carroll,Le Sueur,Ripley,Gallia,Sumter,Neshoba,Ellis,Alpena,Fayette,Fredericksburg,Van Wert,White,Adams,Codington,Jones,Marion,Carroll,Carroll,Garrett,Cass,Peach,Glenn,Stoddard,Marion,San Jacinto,Hancock,Baker,Lincoln,Wells,Montgomery,Tate,Custer,Washington,Dinwiddie,Wythe,White,Union,Fluvanna,Upson,Logan,Henderson,West Baton Rouge,Montgomery,Winchester,King George,Bradford,Elbert,Dillon,Copiah,Hocking,Grant,Scott,Logan,Jackson,Orleans,Randolph,Henry,Jennings,Adams,Gillespie,Perry,Tillamook,Dunklin,Edgefield,Woodford,Hardin,Lawrence,Cass,Leflore,Mille Lacs,Del Norte,Toombs,Pike,De Soto,Stephens,Ashe,Hart,McDonough,Oceana,Geneva,Union,Mineral,San Miguel,Cibola,Payette,Grayson,Juneau,Boone,Carroll,Lewis,Wasco,Butts,Iroquois,Caddo,Decatur,Montezuma,Goochland,Clay,Taylor,Carter,Union,Crook,Macon,Pottawatomie,Lamoille,Union,Charlevoix,Grady,Franklin,Montgomery,Johnson,Marlboro,McNairy,Wyoming,Dickinson,Staunton,Cheboygan,Garvin,Churchill,Brown,Harlan,Plymouth,Fannin,Benton,Gladwin,Simpson,Hardee,Salem,Luna,Otsego,Todd,Milam,Russell,Washington,Lyon,Cassia,Cherokee,Hickman,Hardeman,Grant,Manistee,Iosco,Adair,Miller,Cleburne,Bremer,Jefferson,Prentiss,Jerome,George,Texas,Posey,New Kent,Barton,Routt,Mason,Fayette,Chattooga,Fairfax,Blaine,Uvalde,Aransas,Waushara,Yazoo,Teller,Somerset,Lauderdale,White,Jackson,Barbour,Rowan,Morehouse,Audrain,Yates,Scott,Lincoln,Burke,Abbeville,Randolph,Randolph,Anderson,Sunflower,Nicholas,Grainger,Franklin,Tattnall,Dawson,Marion,Shelby,Antrim,Itawamba,Pacific,Hood River,Iowa,Roscommon,Ohio,Page,Upshur,McDonald,Winston,Vilas,Bell,Seminole,Washington,Meeker,Hampshire,Yankton,Klickitat,Teton,Curry,Juniata,Starke,Fayette,Menominee,Saline,Osceola,Saline,Ray,Overton,Saunders,Mercer,Emanuel,Franklin,Hopewell,Putnam,Waynesboro,Plaquemines,Crawford,Leelanau,Panola,Lampasas,Washington,Clarke,Poinsett,Mingo,Rockbridge,Randolph,Allen,Asotin,Llano,Caswell,St. Francis,Sumner,Columbia,Johnson,Henry,Anson,Limestone,Gaines,Minidoka,Beckham,Bibb,Scott,Grant,Ouachita,Sevier,Houston,Nobles,Bandera,Mahaska,Prince Edward,Colusa,Sabine,Lee,Meigs,Madison,Jo Daviess,Hubbard,Brooke,McDuffie,Morgan,Martin,Gage,Owen,Wyandot,Wabasha,Stutsman,Tippah,Taylor,Seward,Scott,Clinton,Fillmore,Moore,Hockley,Morgan,Dakota,Leake,Fayette,Allen,Logan,Jersey,Grenada,Lincoln,Greene,Clark,Adams,Washington,Newton,Morgan,Mitchell,Conway,Montague,Gray,Dodge,Boone,Colorado,Jackson,DeKalb,Dukes,Meriwether,Jones,Logan,Ogemaw,Breckinridge,Union,Letcher,Adams,Sullivan,Nodaway,Texas,Buena Vista,Shelby,Buchanan,Kewaunee,Uinta,Perry,Wyoming,Gem,Carroll,Lavaca,Fairfield,Coahoma,Carroll,Barnwell,Carbon,Greene,Lincoln,Assumption,Worth,Union,Smith,Fulton,Jones,Bourbon,Tyler,Jay,Lincoln,Pointe Coupee,Pierce,Spencer,Duchesne,Hutchinson,Chaffee,Woodward,Benton,Willacy,Yell,Greene,Freestone,Taylor,DeWitt,Henry,Simpson,Spencer,Davison,Clay,Hertford,Pike,Lincoln,Polk,Winneshiek,Labette,Calhoun,Gonzales,Elbert,Washington,Richland,Dodge,Crisp,Martin,Orange,Douglas,Marion,Wayne,Vernon,Hart,Wayne,Adair,Lamar,St. James,Holmes,Hempstead,Langlade,Los Alamos,Plumas,Buchanan,Franklin,McIntosh,Jackson,Monroe,Polk,Kent,Fentress,Beadle,Fayette,East Feliciana,Perry,Banks,Green Lake,Humphreys,Cherokee,Harrison,Saluda,Adair,Gilchrist,Perry,Wright,Roosevelt,Stone,Waseca,Burleson,Marengo,Randolph,Westmoreland,Yancey,Warren,Paulding,Inyo,Pickens,Macon,Bosque,Tishomingo,Houston,Butler,Andrews,King William,Frio,Ste. Genevieve,Poweshiek,Crawford,Appling,San Juan,Sawyer,Deaf Smith,Dickinson,Ashley,Bethel,Clay,Long,Berrien,Colonial Heights,Jefferson,Cedar,Otero,Brantley,Benzie,Hampton,Grant,Kalkaska,Russell,Johnson,Concordia,Covington,Montour,Madison,Andrew,Young,Eastland,Dickinson,Lee,Southampton,McDowell,Park,Polk,Sharp,Unicoi,Pike,Park,Avery,Hughes,Henry,Seward,Chester,Garrard,Schuyler,Delaware,Dallas,Winston,Cook,Attala,Patrick,Haywood,Idaho,Morgan,Madison,Franklin,Rabun,Falls,Humboldt,Hancock,Piscataquis,Gunnison,Marion,Richland,Bertie,Robertson,Ben Hill,Mariposa,Union,Dixie,Drew,Clayton,Union,Pitkin,Buckingham,Mason,Lafayette,Northampton,Madison,Burnett,Chickasaw,Tama,McCreary,Washburn,Bristol,Baker,Cooper,Sequatchie,Manassas Park,Lewis,Rush,Radford,Bond,Jackson,Piatt,La Paz,Hardin,Fountain,Appomattox,Richland,Alamosa,Bayfield,Giles,Cross,Edgar,Arkansas,Iowa,Scurry,Taylor,Clay,Warren,Parke,Kanabec,Brooks,Crawford,Leon,Otoe,Lawrence,Atchison,Socorro,Holmes,Potter,Bates,Wayne,Lee,Dade,Rockcastle,Hill,Ashland,Lawrence,Jasper,Aitkin,Fayette,Crawford,Benton,Van Buren,Wayne,Gooding,Jasper,Casey,Grand,Trinity,Henry,Brunswick,Williamsburg,Pawnee,Marshall,Marquette,Osage,New Madrid,Sevier,Jefferson,Union,Neosho,Brown,Richland,Nottoway,Floyd,Carroll,Oglethorpe,Mercer,Torrance,Phillips,Kingfisher,Cleburne,Barbour,Vermillion,De Witt,Redwood,Tipton,Jefferson,Floyd,West Feliciana,Fleming,Clarke,Roseau,Grayson,Clark,Moniteau,Clay,Clarke,Missaukee,Macon,Jackson,Washington,Gulf,Page,Larue,Jefferson,Arenac,Franklin,Bledsoe,Lawrence,Sibley,Mitchell,Karnes,Pemiscot,Jeff Davis,Pecos,Hamilton,Jackson,Alleghany,Hale,Cannon,LaSalle,Gasconade,Nelson,Pendleton,Falls Church,Saline,Harrison,Cedar,Mills,Renville,Dent,Fulton,Kossuth,San Juan,Nantucket,Pike,Carbon,Nolan,Moultrie,Las Animas,Bourbon,Atoka,Livingston,McKenzie,Gogebic,Trigg,Harrison,Craig,Choctaw,York,Noble,Clay,Butler,Wadena,Hardy,Callahan,Clay,Calhoun,Rusk,Smith,Screven,O'Brien,Price,Allamakee,Wetzel,Morgan,Pend Oreille,Trinity,Madison,Estill,Stewart,Swain,Izard,Comanche,Crockett,Fremont,Newton,Faribault,Archuleta,Massac,Zapata,Walthall,Chowan,Claiborne,Knott,Grundy,Pennington,Roane,Shoshone,Ketchikan Gateway,Converse,Murray,Dickenson,Lamar,Martinsville,Morgan,Madison,Glacier,Washington,White,Hamilton,Greene,Calhoun,Oglala Lakota,Winn,Amelia,Ford,Osage,Buffalo,Hughes,Johnson,Crawford,Meigs,Jackson,Millard,Sanders,Breathitt,Union,Perquimans,Monroe,Presque Isle,Moffat,Boundary,Mono,Crenshaw,Cass,Jackson,Clay,Bamberg,Powell,Lewis,Lewis,Lincoln,Calhoun,Towns,Big Horn,Bath,Webster,Lamb,Charlton,Morgan,Camp,Wright,Cass,Rains,Jefferson,Kodiak Island,Mason,Madison,Reeves,Poquoson,Bienville,Vinton,Caldwell,Wilbarger,Goshen,Juab,Howard,Stone,Amite,Lake,Glades,Franklin,Owyhee,Allen,Todd,Blanco,Pulaski,Bleckley,Teton,Yalobusha,Skamania,Butler,Pamlico,Valley,Monroe,Grundy,Choctaw,Chippewa,Edmonson,Colfax,Fulton,Morrow,Crawford,Braxton,Northumberland,Appanoose,Lyon,Pike,Washington,Dawson,Menard,Newton,Morris,Northampton,Jackson,Lunenburg,Union,Douglas,Custer,Trousdale,Blackford,Rolette,Prowers,Mississippi,Sumter,Macon,Linn,Koochiching,Telfair,Big Horn,Little River,Chickasaw,Lawrence,Shelby,Heard,Tallahatchie,Marion,Summers,Barton,Fergus,Greene,Haskell,Iron,Marshall,Terry,Live Oak,Red River,Clay,Cherokee,Decatur,Ramsey,Sierra,Lincoln,Cottonwood,Perry,Montgomery,Charlotte,Pope,Green,Magoffin,Owen,Rio Grande,McIntosh,Okfuskee,Conecuh,Greensville,Monroe,Richland,Watonwan,Alleghany,Ward,Washington,Wabash,Jefferson Davis,Carbon,Bacon,Candler,Martin,Dooly,Grant,Lake,Mackinac,Carroll,Lancaster,Camden,Noble,Lake,DeKalb,Wayne,St. Helena,Middlesex,Washita,Washington,North Slope,Pushmataha,Desha,Barnes,Sussex,Evans,Box Butte,Ripley,Guthrie,Louisa,Butte,Hancock,Colfax,Franklin,Essex,Early,Winnebago,Mitchell,Bollinger,Red Willow,Roosevelt,Custer,Crawford,Clay,Ralls,Metcalfe,Alcona,Walsh,Gates,Cumberland,Coosa,Johnston,Love,Lanier,Roberts,Montgomery,Bradley,Wilcox,Nemaha,Howard,Benewah,Pike,Holt,Perry,Leslie,Bullock,Emery,Noxubee,Sabine,Marshall,Yuma,Webster,Franklin,Pulaski,Jackson,Keokuk,Lewis,Switzerland,Runnels,Nome,Wayne,Lowndes,Martin,McLean,Cumberland,Scott,Calhoun,Grundy,Ochiltree,Linn,Chicot,McCormick,Grand,Swift,Duval,Stevens,Marion,Parmer,Beaverhead,Somervell,Sac,Carroll,Clarke,Rock,Montgomery,Deer Lodge,Humboldt,St. Clair,Wilkes,Cheyenne,Latimer,Montmorency,Madison,Mountrail,Brewster,Caldwell,Tunica,West Carroll,Hamilton,Yellow Medicine,Iron,Howard,Nowata,Zavala,Greenlee,Forest,Stephens,Rice,Brown,Jones,Irwin,Pipestone,Charles Mix,Emmet,Clear Creek,Todd,Madison,Clinton,Johnson,Stillwater,Jasper,Davis,Seminole,Pratt,McLean,Richmond,Hancock,Mitchell,Clearwater,Phelps,Crittenden,Cuming,Turner,Caldwell,Marshall,Livingston,Lyon,Cloud,Custer,Chattahoochee,Jack,Turner,Ozark,Archer,Palo Alto,Terrell,Sublette,Dawson,Wilcox,Gallatin,Alger,Wilkinson,White Pine,Benton,Monroe,Kemper,Lucas,Jenkins,Perry,Greene,Johnson,Oregon,Hancock,Montgomery,Clearwater,Platte,Modoc,Woods,Hickory,Catahoula,Claiborne,Blaine,Quay,Monona,Montgomery,Trimble,Mathews,Wilson,Daviess,Warren,Maries,Bracken,Oscoda,Butler,Carroll,Hamilton,Kiowa,Dimmit,Sitka,Knox,Lee,Houston,Mercer,Atkinson,Cedar,Coffey,Ritchie,Boise,Lake,Franklin,Lemhi,Keith,Baraga,Harrison,Kusilvak,Kane,Rosebud,Wilkinson,Lafayette,Nevada,Webster,Dawes,Power,Schoolcraft,Choctaw,Murray,Graham,Tyler,Prairie,Clay,Perry,Traill,San Miguel,Hamilton,Thomas,San Augustine,Searcy,Lincoln,Clay,Anderson,Coleman,Twiggs,Taylor,Pocahontas,Decatur,Richardson,Merrick,Doddridge,Nicholas,Washakie,Liberty,Clay,Broadwater,Allendale,Ballard,Dade,Major,Franklin,Benton,Yoakum,Grant,Wallowa,Conejos,Lexington,Pleasants,Valley,McCulloch,Monroe,Marion,Doniphan,Harney,Adair,Crook,Winkler,Cleveland,Grand Isle,Red River,Northwest Arctic,Pepin,Rappahannock,Greene,Hutchinson,Humphreys,Chariton,Ferry,Lake,Worth,Castro,Lee,Wheeler,Pierce,Elliott,Dallam,Gilmer,Beaver,Fall River,Van Buren,Grant,Grant,Kingman,Shannon,Caribou,Jefferson,Goliad,Newton,East Carroll,Southeast Fairbanks,Jefferson,Powell,Pocahontas,Nemaha,Bon Homme,Kit Carson,Wabaunsee,Union,Huerfano,Blaine,Brooks,Swisher,Bailey,Ida,Tillman,Chugach,Hancock,La Salle,Weston,Schuyler,Clinch,Childress,Burt,Pembina,Galax,Forest,Kearney,Refugio,King and Queen,Lac qui Parle,Russell,Clark,Moore,Tucker,Bear Lake,Thurston,Charles City,Buena Vista,Monroe,Saguache,Lake,Surry,Rio Blanco,Howard,Wayne,Fremont,Pershing,Wolfe,Van Buren,Fulton,Moody,Bottineau,Treutlen,Hamlin,Wilkin,Norman,Ellsworth,Teton,Brown,Antelope,Luce,Gentry,Dallas,Menifee,Spink,Iron,Bland,Randolph,Henderson,Pawnee,Lafayette,Grant,Osceola,Clay,Edwards,Calhoun,Pendleton,Pondera,Woodruff,Reynolds,Ohio,Shelby,Essex,Cumberland,Presidio,Greenwood,Chouteau,Gilpin,Sullivan,Taylor,Sherman,Sullivan,Miller,Ontonagon,Ottawa,Benson,Carson,Stanton,Mitchell,Quitman,Lander,Lynn,McCook,Talbot,Prince of Wales-Hyder,Gray,Alfalfa,San Saba,Covington,Crowley,Ransom,Cook,Tripp,Lincoln,Putnam,Audubon,Lincoln,Bent,Emporia,Dixon,Fillmore,Washington,Cherry,Calhoun,Greer,Cotton,Delta,Day,Haskell,Harper,Jefferson,Norton,Mahnomen,Lincoln,Boone,Morris,Coal,Stark,Carter,Brule,Walworth,Johnson,Custer,Kingsbury,Aleutians West,Polk,Garfield,Martin,Floyd,Hartley,McHenry,Dewey,Yukon-Koyukuk,Atchison,Warren,Stevens,Musselshell,Big Stone,Hansford,Garza,Hamilton,Ouray,Pickett,Toole,Wirt,Crosby,Beaver,Scott,Pulaski,Cameron,Sheridan,Mineral,Scott,Dickey,Thayer,Alexander,Stewart,Wheeler,Craig,Washington,Gallatin,Phillips,Rooks,Oneida,Carlisle,Adams,Jim Hogg,Dillingham,Calhoun,Scotland,Wahkiakum,Florence,Republic,Ringgold,Putnam,Hot Springs,Crane,Hyde,Furnas,Mineral,Morrill,Schley,Mills,Phillips,Custer,Hickman,Cameron,Lincoln,Kimble,Guadalupe,Dewey,Marshall,Calhoun,Deuel,Menominee,Holt,Phillips,Mora,Storey,Grant,LaMoure,Bath,Nuckolls,Kittson,Barber,Valley,Edmunds,Hidalgo,Dunn,Schuyler,Gregory,Columbia,Union,Stafford,Owsley,Mason,Tensas,Pierce,Clark,Red Lake,Meade,Wells,Sharkey,Kearny,Lake of the Woods,Corson,Sargent,Knox,Catron,Sioux,Pope,Lyman,Sweet Grass,Echols,Ellis,Lewis,Chase,Sheridan,Fisher,Haskell,Cavalier,Adams,Costilla,Hardin,Norton,Smith,Hardeman,Aleutians East,Baylor,Mercer,Hanson,Granite,Osborne,Baca,Tyrrell,Petersburg,Hudspeth,Chautauqua,Webster,Roger Mills,Foster,Coke,Bennett,Concho,Nance,Knox,Sutton,Donley,Emmons,Kimball,Traverse,Hemphill,Reagan,Harper,Upton,Shackelford,Kinney,Hand,Woodson,Nelson,Stanley,Perkins,Sherman,Rush,Glascock,Lincoln,Lipscomb,Jewell,Bowman,Brown,Clay,Harlan,Franklin,Douglas,Crockett,Perkins,Hall,Jackson,Real,Gove,Baker,Edwards,Trego,Fallon,Sierra,Decatur,Logan,Butte,Ness,Aurora,Rich,Cheyenne,Copper River,Morton,Collingsworth,Wayne,Frontier,Hitchcock,Chase,Cochran,Pawnee,Rawlins,McIntosh,Hamilton,Elk,Dolores,Hettinger,Sheridan,Kiowa,Harmon,Graham,Potter,Sanborn,Webster,Schleicher,Ziebach,Kidder,Niobrara,Garfield,Hoonah-Angoon,Eddy,Sedgwick,Renville,Miner,Highland,Sherman,Robertson,Grant,Quitman,Oldham,Griggs,Cimarron,Greeley,Culberson,Divide,Burke,McPherson,Adams,Keweenaw,Faulk,Wichita,Wrangell,Haines,Towner,Judith Basin,Wheatland,Gosper,Stanton,Meagher,Clark,Gilliam,Denali,Menard,Liberty,Mellette,Sherman,Worth,Jeff Davis,Deuel,Oliver,Armstrong,Logan,Powder River,Buffalo,Steele,Jerauld,Garden,Dickens,Cheyenne,Dundy,Comanche,Haakon,Garfield,Piute,Boyd,McCone,Golden Valley,Hodgeman,Throckmorton,Alpine,Campbell,Eureka,De Baca,Taliaferro,Sully,Daniels,Wheeler,Sterling,Lane,Wallace,Irion,Kiowa,Jackson,Cottle,Rock,Carter,Greeley,Sheridan,Briscoe,Edwards,Prairie,Skagway,Stonewall,Wibaux,Hyde,Motley,Sioux,Harding,Camas,Garfield,Glasscock,Esmeralda,Billings,Lake and Peninsula,Hinsdale,Jones,Foard,Issaquena,Bristol Bay,Golden Valley,Clark,Wheeler,Hayes,Terrell,Roberts,Keya Paha,Daggett,Logan,Slope,Banner,Harding,Kent,Treasure,Mineral,San Juan,Borden,McMullen,Hooker,Grant,Loup,Thomas,Yakutat,Arthur,McPherson,Petroleum,Blaine,King,Kenedy,Kalawao,Loving