DataBrighten

    South Dakota ZIP codes with county

    385ZIP codes in South Dakota · 66 counties

    Every South Dakota ZIP code with its place name, county and county FIPS code, as CSV, Excel or JSON. Updated 19 November 2026.

    textnumberdateyes/no
    ZIP codes38557001 to 57799
    Counties66with at least one ZIP
    Places363distinct place names
    LicenceCC BY 4.0credit GeoNames

    South Dakota ZIP codes at a glance

    This list has 385 ZIP codes for South Dakota, each with the place name the postal service uses, the county it is assigned to, that county's five-digit FIPS code and an approximate latitude and longitude. The codes run from 57001 to 57799 and use 8 three-digit prefixes (570, 571, 572, 573, 574, 575, 576 and 577). They cover 66 counties and 363 place names.

    Minnehaha County has the most ZIP codes (26), followed by Brown County (14) and Pennington County (14). The place name used by the most ZIP codes is Sioux Falls, with 15.

    Counties with the most ZIP codes

    CountyFIPSZIP codes
    Minnehaha County4609926
    Brown County4601314
    Pennington County4610314
    Meade County4609311
    Spink County4611511
    Corson County4603110
    Roberts County461099
    Beadle County460058
    Brookings County460118
    Grant County460518

    How the county is assigned

    A ZIP code is a delivery route, not a drawn area, and some ZIP codes reach into two or more counties. This file gives the one county GeoNames assigns to each ZIP code, which is the usual answer for mail and for most reports. Post office box ZIP codes and single-building codes are included, so a few ZIP codes share the coordinates of their post office. The coordinates are approximate centre points estimated by GeoNames, good for a map pin but not for a boundary.

    Look up a ZIP code

    Keep ZIP codes as text even though South Dakota's start with 5: other states' codes start with 0, and a number column would drop that zero when you combine files.

    In Excel, with the CSV open (ZIP in column A, county in column C):

    =XLOOKUP("57376", A:A, C:C)

    In SQL, after loading the CSV as a table:

    SELECT zip, place, county, county_fips
    FROM sd_zip_codes
    WHERE zip = '57376';

    Result: 57376 · Tripp · Hutchinson County · 46067

    All 385 ZIP codes

    ZIPPlaceCountyCounty FIPSLatitudeLongitude
    57001AlcesterUnion County4612743.0047-96.6332
    57002AuroraBrookings County4601144.2838-96.7043
    57003BalticMinnehaha County4609943.7309-96.7563
    57004BeresfordUnion County4612743.0874-96.7813
    57005BrandonMinnehaha County4609943.5926-96.586
    57006BrookingsBrookings County4601144.3056-96.7914
    57007BrookingsBrookings County4601144.3697-96.7907
    57010BurbankClay County4602742.7638-96.8466
    57012CanistotaMcCook County4608743.5856-97.2889
    57013CantonLincoln County4608343.3038-96.5938
    57014CentervilleTurner County4612543.1176-96.9636
    57015ChancellorTurner County4612543.408-96.9827
    57016ChesterLake County4607943.8981-96.9759
    57017ColmanMoody County4610143.9558-96.8189
    57018ColtonMinnehaha County4609943.7951-96.9572
    57020CrooksMinnehaha County4609943.6669-96.8221
    57021DavisTurner County4612543.2864-96.9792
    57022Dell RapidsMinnehaha County4609943.8228-96.7223
    57024EganMoody County4610143.9866-96.6493
    57025Elk PointUnion County4612742.7382-96.687
    57026ElktonBrookings County4601144.235-96.5011
    57027FairviewLincoln County4608343.197-96.5135
    57028FlandreauMoody County4610144.0658-96.6222
    57029FreemanHutchinson County4606743.3605-97.4601
    57030GarretsonMinnehaha County4609943.7162-96.5196
    57031GayvilleYankton County4613542.8835-97.183
    57032HarrisburgLincoln County4608343.446-96.6864
    57033HartfordMinnehaha County4609943.6155-96.9501
    57034HudsonLincoln County4608343.1284-96.5306
    57035HumboldtMinnehaha County4609943.612-97.0697
    57036HurleyTurner County4612543.2893-97.1904
    57037IreneClay County4602743.1027-97.2558
    57038JeffersonUnion County4612742.6013-96.5784
    57039LennoxLincoln County4608343.3451-96.8821
    57040LestervilleYankton County4613543.0394-97.5956
    57041LyonsMinnehaha County4609943.7285-96.8709
    57042MadisonLake County4607944.0054-97.1149
    57043MarionTurner County4612543.4188-97.2771
    57045MennoHutchinson County4606743.234-97.565
    57046Mission HillYankton County4613542.9836-97.3349
    57047MonroeTurner County4612543.5207-97.212
    57048MontroseMcCook County4608743.7063-97.1885
    57049North Sioux CityUnion County4612742.5249-96.5074
    57050NundaLake County4607944.1525-96.9942
    57051OldhamKingsbury County4607744.2457-97.2696
    57052OlivetHutchinson County4606743.2928-97.7184
    57053ParkerTurner County4612543.402-97.1333
    57054RamonaLake County4607944.1229-97.2349
    57055RennerMinnehaha County4609943.6366-96.7119
    57057RutlandLake County4607944.0683-96.9519
    57058SalemMcCook County4608743.7356-97.3797
    57059ScotlandBon Homme County4600943.1212-97.7296
    57061SinaiBrookings County4601144.2444-97.0409
    57062SpringfieldBon Homme County4600942.8687-97.9288
    57063TaborBon Homme County4600942.9383-97.6923
    57064TeaLincoln County4608343.4711-96.8177
    57065TrentMoody County4610143.8942-96.6326
    57066TyndallBon Homme County4600942.99-97.8633
    57067UticaYankton County4613543.0164-97.3694
    57068Valley SpringsMinnehaha County4609943.5773-96.4956
    57069VermillionClay County4602742.7951-96.9258
    57070ViborgTurner County4612543.1815-97.114
    57071VolgaBrookings County4601144.3224-96.9251
    57072VolinYankton County4613542.9572-97.1803
    57073WakondaClay County4602742.996-97.0694
    57075WentworthLake County4607943.9852-96.9615
    57076WinfredLake County4607943.9972-97.3623
    57077WorthingLincoln County4608343.3291-96.7628
    57078YanktonYankton County4613542.8821-97.3986
    57101Sioux FallsMinnehaha County4609943.5464-96.6906
    57103Sioux FallsMinnehaha County4609943.5374-96.6864
    57104Sioux FallsMinnehaha County4609943.5514-96.7375
    57105Sioux FallsMinnehaha County4609943.524-96.7341
    57106Sioux FallsMinnehaha County4609943.5179-96.7924
    57107Sioux FallsMinnehaha County4609943.5566-96.8028
    57108Sioux FallsMinnehaha County4609943.4775-96.7041
    57109Sioux FallsMinnehaha County4609943.6746-96.7913
    57110Sioux FallsMinnehaha County4609943.5486-96.6332
    57117Sioux FallsMinnehaha County4609943.6746-96.7913
    57118Sioux FallsMinnehaha County4609943.6746-96.7913
    57186Sioux FallsMinnehaha County4609943.5424-96.7312
    57193Sioux FallsMinnehaha County4609943.6746-96.7913
    57197Sioux FallsMinnehaha County4609943.6746-96.7913
    57198Sioux FallsMinnehaha County4609943.6746-96.7913
    57201WatertownCodington County4602944.9043-97.124
    57212ArlingtonKingsbury County4607744.3668-97.0687
    57213AstoriaDeuel County4603944.5735-96.5416
    57214BadgerKingsbury County4607744.4918-97.2184
    57216Big Stone CityGrant County4605145.285-96.5614
    57217BradleyClark County4602545.0751-97.6387
    57218BrandtDeuel County4603944.6738-96.6435
    57219BristolDay County4603745.288-97.8086
    57220BruceBrookings County4601144.4675-96.911
    57221BryantHamlin County4605744.5987-97.4537
    57223CastlewoodHamlin County4605744.7313-97.0204
    57224Claire CityRoberts County4610945.8755-97.1073
    57225ClarkClark County4602544.878-97.7265
    57226Clear LakeDeuel County4603944.7612-96.6907
    57227CoronaRoberts County4610945.3595-96.6649
    57231De SmetKingsbury County4607744.3852-97.5634
    57232EdenMarshall County4609145.6211-97.3741
    57233ErwinKingsbury County4607744.4915-97.4103
    57234EstellineHamlin County4605744.6029-96.8928
    57235FlorenceCodington County4602945.0554-97.2866
    57236Garden CityClark County4602544.9841-97.5814
    57237GaryDeuel County4603944.827-96.5044
    57238GoodwinDeuel County4603944.8754-96.8608
    57239GrenvilleDay County4603745.5097-97.3092
    57241HaytiHamlin County4605744.6647-97.2305
    57242HazelHamlin County4605744.7572-97.3083
    57243HenryCodington County4602944.8858-97.4442
    57245KranzburgCodington County4602944.8923-96.9174
    57246LaboltGrant County4605145.0415-96.6892
    57247Lake CityMarshall County4609145.6899-97.3481
    57248Lake NordenHamlin County4605744.5844-97.2009
    57249Lake PrestonKingsbury County4607744.3692-97.3828
    57251MarvinGrant County4605145.2727-96.91
    57252MilbankGrant County4605145.2061-96.6255
    57255New EffingtonRoberts County4610945.8659-96.915
    57256OrtleyRoberts County4610945.2657-97.1925
    57257PeeverRoberts County4610945.5206-97.0012
    57258RaymondClark County4602544.8637-97.9168
    57259RevilloGrant County4605145.0805-96.5557
    57260RosholtRoberts County4610945.8753-96.7174
    57261RoslynDay County4603745.5006-97.5401
    57262SissetonRoberts County4610945.6732-97.0715
    57263South ShoreCodington County4602945.1049-96.9859
    57264StockholmGrant County4605145.1031-96.8106
    57265StrandburgGrant County4605145.0389-96.7901
    57266SummitRoberts County4610945.3521-97.0427
    57268TorontoDeuel County4603944.5786-96.7077
    57269Twin BrooksGrant County4605145.2309-96.8237
    57270VeblenMarshall County4609145.8535-97.3122
    57271ViennaClark County4602544.7362-97.5307
    57272WallaceCodington County4602945.0815-97.4458
    57273WaubayDay County4603745.3784-97.295
    57274WebsterDay County4603745.3151-97.5254
    57276WhiteBrookings County4601144.4132-96.615
    57278Willow LakeClark County4602544.6272-97.6747
    57279WilmotRoberts County4610945.4125-96.856
    57301MitchellDavison County4603543.7094-98.0298
    57311AlexandriaHanson County4606143.6684-97.7563
    57312AlpenaJerauld County4607344.1709-98.3962
    57313ArmourDouglas County4604343.316-98.3414
    57314ArtesianSanborn County4611144.021-98.0114
    57315AvonBon Homme County4600943.0397-98.0283
    57317BonesteelGregory County4605343.0695-98.988
    57319BridgewaterMcCook County4608743.5503-97.4691
    57321CanovaMiner County4609743.8855-97.5342
    57322CarpenterClark County4602544.6648-97.9168
    57323CarthageMiner County4609744.1496-97.7116
    57324CavourBeadle County4600544.365-98.0208
    57325ChamberlainBrule County4601543.7953-99.3118
    57326ChamberlainBrule County4601543.8108-99.3307
    57328CorsicaDouglas County4604343.4213-98.3564
    57329DanteCharles Mix County4602342.9967-98.1746
    57330DelmontDouglas County4604343.2573-98.1596
    57331DimockHutchinson County4606743.4705-97.9988
    57332EmeryHanson County4606143.5656-97.6475
    57334EthanDavison County4603543.5478-97.9881
    57335FairfaxGregory County4605343.0351-98.8308
    57337FedoraMiner County4609743.9841-97.789
    57339Fort ThompsonBuffalo County4601744.0517-99.3973
    57340FultonHanson County4606143.7588-97.8712
    57341Gann ValleyBuffalo County4601744.0693-99.0543
    57342GeddesCharles Mix County4602343.2597-98.6926
    57344HarrisonDouglas County4604343.4297-98.5273
    57345HighmoreHyde County4606944.5326-99.4543
    57346StephanHyde County4606944.248-99.4532
    57348HitchcockBeadle County4600544.5834-98.4509
    57349HowardMiner County4609744.0371-97.5603
    57350HuronBeadle County4600544.359-98.2163
    57353IroquoisKingsbury County4607744.3455-97.8542
    57354KaylorHutchinson County4606743.3341-97.7569
    57355KimballBrule County4601543.7467-98.9584
    57356Lake AndesCharles Mix County4602343.1303-98.4964
    57358LaneJerauld County4607344.0696-98.4252
    57359LetcherSanborn County4611143.8923-98.1743
    57361MartyCharles Mix County4602342.9925-98.4251
    57362MillerHand County4605944.4966-98.9894
    57363Mount VernonDavison County4603543.7204-98.2633
    57364New HollandDouglas County4604343.4291-98.6069
    57365OacomaLyman County4608543.7975-99.3947
    57366ParkstonHutchinson County4606743.3978-97.9678
    57367PickstownCharles Mix County4602343.0673-98.523
    57368PlankintonAurora County4600343.7373-98.4694
    57369PlatteCharles Mix County4602343.4251-98.9479
    57370PukwanaBrule County4601543.7783-99.1779
    57371Ree HeightsHand County4605944.5603-99.2286
    57373Saint LawrenceHand County4605944.5215-98.8754
    57374SpencerMcCook County4608743.7557-97.5936
    57375StickneyAurora County4600343.5842-98.5088
    57376TrippHutchinson County4606743.2404-97.9713
    57379VirgilBeadle County4600544.2908-98.4243
    57380WagnerCharles Mix County4602343.0819-98.2819
    57381WessingtonBeadle County4600544.4128-98.692
    57382Wessington SpringsJerauld County4607344.0664-98.6751
    57383White LakeAurora County4600343.7564-98.7076
    57384WolseyBeadle County4600544.3991-98.4743
    57385WoonsocketSanborn County4611144.0572-98.243
    57386YaleBeadle County4600544.5225-98.0401
    57399HuronBeadle County4600544.3633-98.2143
    57401AberdeenBrown County4601345.4661-98.4856
    57402AberdeenBrown County4601345.5896-98.352
    57420AkaskaWalworth County4612945.3324-100.1186
    57421AmherstMarshall County4609145.7585-97.9274
    57422AndoverDay County4603745.4222-97.9175
    57424AshtonSpink County4611545.0465-98.3973
    57426BarnardBrown County4601345.7325-98.4965
    57427BathBrown County4601345.4564-98.3552
    57428BowdleEdmunds County4604545.453-99.654
    57429BrentfordSpink County4611545.1635-98.3193
    57430BrittonMarshall County4609145.8023-97.7418
    57432ClaremontBrown County4601345.6661-98.0404
    57433ColumbiaBrown County4601345.6512-98.3158
    57434CondeSpink County4611545.1393-98.1534
    57435CresbardFaulk County4604945.1691-98.9411
    57436DolandSpink County4611544.8159-98.0947
    57437EurekaMcPherson County4608945.7707-99.3308
    57438FaulktonFaulk County4604945.0855-99.1954
    57439FerneyBrown County4601345.329-98.0837
    57440FrankfortSpink County4611544.8084-98.2935
    57441FrederickBrown County4601345.8493-98.5176
    57442GettysburgPotter County4610745.0259-99.9766
    57445GrotonBrown County4601345.4503-98.1058
    57446HeclaBrown County4601345.8725-98.1918
    57448HosmerEdmunds County4604545.569-99.4857
    57449HoughtonBrown County4601345.7967-98.0952
    57450HovenPotter County4610745.2278-99.7763
    57451IpswichEdmunds County4604545.4489-99.0148
    57452JavaWalworth County4612945.4492-99.822
    57454LangfordMarshall County4609145.6174-97.7925
    57455LebanonPotter County4610745.0123-99.7366
    57456LeolaMcPherson County4608945.7228-98.9409
    57457Long LakeMcPherson County4608945.8566-99.2051
    57460MansfieldSpink County4611545.243-98.5629
    57461MelletteSpink County4611545.1631-98.4824
    57465NorthvilleSpink County4611545.1611-98.6589
    57466OnakaFaulk County4604945.1965-99.4551
    57467OrientFaulk County4604944.8343-99.1058
    57468PierpontDay County4603745.496-97.8128
    57469RedfieldSpink County4611544.8719-98.5112
    57470RockhamFaulk County4604944.8767-98.8669
    57471RoscoeEdmunds County4604545.4271-99.3326
    57472SelbyWalworth County4612945.4786-100.0541
    57473SenecaFaulk County4604945.0262-99.461
    57474StratfordBrown County4601345.2866-98.2792
    57475TolstoyPotter County4610745.1702-99.6176
    57476TulareSpink County4611544.7305-98.5539
    57477TurtonSpink County4611545.0379-98.0996
    57479WarnerBrown County4601345.3486-98.4757
    57481WestportBrown County4601345.6705-98.5802
    57501PierreHughes County4606544.3695-100.3211
    57520AgarSully County4611944.8393-100.0712
    57521BelvidereJackson County4607143.886-101.2387
    57522BluntHughes County4606544.5026-99.9463
    57523BurkeGregory County4605343.1825-99.2937
    57528ColomeTripp County4612343.2273-99.6933
    57529DallasGregory County4605343.2351-99.514
    57531DraperJones County4607543.926-100.5085
    57532Fort PierreStanley County4611744.3426-100.4043
    57533GregoryGregory County4605343.2136-99.3622
    57534HamillTripp County4612343.6439-99.6918
    57536HarroldHughes County4606544.5215-99.7382
    57537HayesStanley County4611744.3703-101.0215
    57538HerrickGregory County4605343.1012-99.2173
    57540HolabirdHyde County4606944.5173-99.5943
    57541IdealTripp County4612343.5596-99.9279
    57543KadokaJackson County4607143.8446-101.5523
    57544KennebecLyman County4608543.8921-99.8502
    57547Long ValleyJackson County4607143.4754-101.4294
    57548Lower BruleLyman County4608544.0937-99.6139
    57551MartinBennett County4600743.1722-101.7341
    57552MidlandHaakon County4605544.0717-101.1554
    57553MilesvilleHaakon County4605544.4283-101.7523
    57555MissionTodd County4612143.285-100.5954
    57559MurdoJones County4607543.8961-100.7121
    57560NorrisMellette County4609543.4662-101.1517
    57562OkatonJones County4607543.8861-100.8918
    57563OkreekTodd County4612143.3633-100.3809
    57564OnidaSully County4611944.7125-100.0957
    57566ParmeleeTodd County4612143.3117-101.0081
    57567PhilipHaakon County4605544.055-101.6876
    57568PreshoLyman County4608543.8995-100.0746
    57569RelianceLyman County4608543.8789-99.6032
    57570RosebudTodd County4612143.2328-100.8535
    57571Saint CharlesGregory County4605343.0852-99.0925
    57572Saint FrancisTodd County4612143.1444-100.9051
    57574TuthillBennett County4600743.1196-101.4701
    57576VivianLyman County4608543.9535-100.286
    57577WanbleeJackson County4607143.5589-101.7219
    57579White RiverMellette County4609543.5666-100.7449
    57580WinnerTripp County4612343.3318-99.8033
    57584WittenTripp County4612343.4498-100.0783
    57585WoodMellette County4609543.5366-100.4379
    57601MobridgeWalworth County4612945.5407-100.4315
    57620BisonPerkins County4610545.5161-102.4827
    57621BullheadCorson County4603145.7656-101.0807
    57622Cherry CreekZiebach County4613744.6055-101.4999
    57623DupreeZiebach County4613745.0079-101.6337
    57625Eagle ButteDewey County4604145.0016-101.2329
    57626FaithMeade County4609344.9926-102.0541
    57630GlencrossDewey County4604145.4483-100.9213
    57631GlenhamWalworth County4612945.5335-100.2716
    57632HerreidCampbell County4602145.8452-100.049
    57633IsabelDewey County4604145.3962-101.4385
    57634KeldronCorson County4603145.7528-101.8843
    57636LantryDewey County4604145.0144-101.4315
    57638LemmonPerkins County4610545.9159-102.1928
    57639Little EagleCorson County4603145.6758-100.8043
    57640LodgepolePerkins County4610545.8232-102.7599
    57641Mc IntoshCorson County4603145.7084-101.1546
    57642Mc LaughlinCorson County4603145.8763-100.8915
    57644MeadowPerkins County4610545.3538-102.2844
    57645MorristownCorson County4603145.9386-101.7232
    57646Mound CityCampbell County4602145.6786-100.0479
    57648PollockCampbell County4602145.889-100.2875
    57649Prairie CityPerkins County4610545.5813-102.8085
    57650RalphHarding County4606345.8554-103.0356
    57651RevaHarding County4606345.5277-103.0692
    57652RidgeviewDewey County4604145.2024-100.605
    57656Timber LakeDewey County4604145.3927-101.0351
    57657Trail CityCorson County4603145.4725-100.7254
    57658WakpalaCorson County4603145.7006-100.5332
    57659WalkerCorson County4603145.9103-101.0904
    57660WataugaCorson County4603145.9276-101.5129
    57661WhitehorseDewey County4604145.2705-100.8865
    57701Rapid CityPennington County4610344.1415-103.2052
    57702Rapid CityPennington County4610344.0036-103.3589
    57703Rapid CityPennington County4610344.048-103.1763
    57706Ellsworth AfbMeade County4609344.1447-103.0759
    57709Rapid CityPennington County4610344.0761-103.3171
    57714AllenBennett County4600743.2908-101.9329
    57716BateslandBennett County4600743.1085-102.2006
    57717Belle FourcheButte County4601944.6723-103.8396
    57718Black HawkMeade County4609344.1512-103.3486
    57719Box ElderPennington County4610344.1199-103.0682
    57720BuffaloHarding County4606345.574-103.5826
    57722Buffalo GapCuster County4603343.4958-103.3157
    57724Camp CrookHarding County4606345.6402-104.0278
    57725CaputaPennington County4610343.9481-102.7935
    57730CusterCuster County4603343.6573-103.4258
    57732DeadwoodLawrence County4608144.3767-103.7296
    57735EdgemontFall River County4604743.2874-103.811
    57737EnningMeade County4609344.5755-102.5632
    57738FairburnCuster County4603343.6623-103.2133
    57741Fort MeadeMeade County4609344.4093-103.4554
    57744HermosaCuster County4603343.8188-103.206
    57745Hill CityPennington County4610343.9377-103.5782
    57747Hot SpringsFall River County4604743.4223-103.4766
    57748HowesMeade County4609344.5838-102.0229
    57750InteriorJackson County4607143.7319-101.9642
    57751KeystonePennington County4610343.8848-103.3995
    57752KyleOglala Lakota County4610243.425-102.1765
    57754LeadLawrence County4608144.263-103.8712
    57755LudlowHarding County4606345.8366-103.3491
    57756MandersonOglala Lakota County4610243.2353-102.4707
    57758Mud ButteMeade County4609345.031-102.8031
    57759NemoLawrence County4608144.2097-103.5449
    57760NewellButte County4601944.741-103.3914
    57761New UnderwoodPennington County4610344.0874-102.8136
    57762NislandButte County4601944.6665-103.5402
    57763OelrichsFall River County4604743.1551-103.2162
    57764OglalaOglala Lakota County4610243.1886-102.7396
    57766OralFall River County4604743.3876-103.1832
    57767OwankaPennington County4610344.0631-102.5628
    57769PiedmontMeade County4609344.2287-103.3688
    57770Pine RidgeOglala Lakota County4610243.1124-102.5984
    57772PorcupineOglala Lakota County4610243.2397-102.331
    57773PringleCuster County4603343.6086-103.5938
    57775QuinnPennington County4610344.1035-102.0159
    57776RedigHarding County4606345.2711-103.5482
    57779Saint OngeLawrence County4608144.5473-103.7232
    57780ScenicPennington County4610343.7994-102.5353
    57782SmithwickFall River County4604743.3014-103.2183
    57783SpearfishLawrence County4608144.4946-103.865
    57785SturgisMeade County4609344.3692-103.3617
    57787Union CenterMeade County4609344.6539-102.7252
    57788ValeButte County4601944.6222-103.3795
    57790WallPennington County4610343.9812-102.2245
    57791WastaPennington County4610344.225-102.4311
    57792White OwlMeade County4609344.6182-102.4452
    57793WhitewoodLawrence County4608144.4589-103.637
    57794Wounded KneeOglala Lakota County4610243.1405-102.3657
    57799SpearfishLawrence County4608144.4958-103.8703

    Source: GeoNames postal code data, CC BY 4.0, retrieved 19 November 2026. File: south-dakota-zip-codes.csv

    Data dictionary

    ColumnTypeMeaning
    ziptextFive-digit ZIP code
    placetextPlace name used by the postal service
    countytextCounty the ZIP code is assigned to
    county_fipstextFive-digit county FIPS code: 2-digit state code + 3-digit county code
    statetextTwo-letter state code
    state_nametextState name
    latitudenumberApproximate centre, decimal degrees (GeoNames estimate)
    longitudenumberApproximate centre, decimal degrees (GeoNames estimate)