How to auto-fill a county field based on zip code?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am having an issue with the address field, it pulls all information except for county. Does anyone have a formula or know of a solution to have a field auto-filled once the zip code has been entered to identify the county name?

Thanks for your help!
Photo of Jessica

Jessica

  • 142 Points 100 badge 2x thumb
  • frustrated with the advanced address field

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
I suggest googling until you can find a free down load of an Excel file with all the US Zip codes.

Then create a new Table called Counties by Zip Codes, where the Key field is set to Zip Code.

Then build a relationship to the Address field based on the Zip code there.  You may find it easier to create a Zip Code mirror field with the formula and use that to make the relationship.

[Address: Postal Code]

Then, of course lookup the County.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
The file "2010 ZCTA to County Relationship File" on the following pages list ZipCode, State FIPS, and County Fips inthe first three columns:

https://www.census.gov/geo/maps-data/data/zcta_rel_download.html

A little script could reduce teh 44,000+ records to a QuickBse formula

State and County FIPS codes can be found here:

https://www2.census.gov/geo/docs/reference/codes/files/national_county.txt

But if you want accuracy be aware that zip code are just labels for postal delivery routes. Here in Michigan we have some places in western Upper Peninsula that have a Wisconsin zip code simple because that is the closest post office.
(Edited)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
Also, I am pretty sure the first three digits in the zip code define the upper and lower bounds of the zip code for the county, principal county, unorganized borough, independent cities or parish.

But then I read this: "If the ZIP Code crosses county lines, this field will contain the name of the county in which the greatest portion of that ZIP Code lies."

Actually I think I created such a formula in the past as I remember a QuickBase engineer contacted me years ago asking why I was taking up so much space in my application for formulas. I might still have that application somewhere.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
Use this resource:

https://www.gaslampmedia.com/download-zip-code-latitude-longitude-city-state-county-csv/

To convert to formula just use underscorejs, groupBy State and County combo, extract the min and max zip code and spit out a QuickBase formulas.
(Edited)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
Well I wrote a quick script using the algorithm I outlined above and spit out a formula.

I think the general idea is true that zip codes for a county are within certain upper and lower bounds but there appear to be exceptions you would have to hunt down.

Oddly the first test in the formula for zip code 00501 is an IRS Service Center out of sequence from the other zip codes for Suffolk County:

https://www.unitedstateszipcodes.org/00501/

I know there are so called "stealth" zip codes for US Marshal Servcies, Military Installations, Area 51 and apparently the IRS. I will contact Mulder & Scully and see if they have any insight.


var Number z = ToNumber([ZipCode]);
If(
  501 <= $z and $z <= 11980, "Suffolk, NY",
  601 <= $z and $z <= 601, "Adjuntas, PR",
  602 <= $z and $z <= 602, "Aguada, PR",
  603 <= $z and $z <= 690, "Aguadilla, PR",
  606 <= $z and $z <= 606, "Maricao, PR",
  610 <= $z and $z <= 610, "Anasco, PR",
  611 <= $z and $z <= 641, "Utuado, PR",
  612 <= $z and $z <= 688, "Arecibo, PR",
  617 <= $z and $z <= 617, "Barceloneta, PR",
  622 <= $z and $z <= 623, "Cabo Rojo, PR",
  624 <= $z and $z <= 624, "Penuelas, PR",
  627 <= $z and $z <= 627, "Camuy, PR",
  631 <= $z and $z <= 669, "Lares, PR",
  636 <= $z and $z <= 683, "San German, PR",
  637 <= $z and $z <= 637, "Sabana Grande, PR",
  638 <= $z and $z <= 638, "Ciales, PR",
  646 <= $z and $z <= 646, "Dorado, PR",
  647 <= $z and $z <= 653, "Guanica, PR",
  650 <= $z and $z <= 650, "Florida, PR",
  656 <= $z and $z <= 785, "Guayanilla, PR",
  659 <= $z and $z <= 659, "Hatillo, PR",
  660 <= $z and $z <= 660, "Hormigueros, PR",
  662 <= $z and $z <= 662, "Isabela, PR",
  664 <= $z and $z <= 664, "Jayuya, PR",
  667 <= $z and $z <= 667, "Lajas, PR",
  670 <= $z and $z <= 670, "Las Marias, PR",
  674 <= $z and $z <= 674, "Manati, PR",
  676 <= $z and $z <= 676, "Moca, PR",
  677 <= $z and $z <= 677, "Rincon, PR",
  678 <= $z and $z <= 678, "Quebradillas, PR",
  680 <= $z and $z <= 682, "Mayaguez, PR",
  685 <= $z and $z <= 685, "San Sebastian, PR",
  687 <= $z and $z <= 687, "Morovis, PR",
  692 <= $z and $z <= 692, "Vega Alta, PR",
  693 <= $z and $z <= 694, "Vega Baja, PR",
  698 <= $z and $z <= 698, "Yauco, PR",
  703 <= $z and $z <= 703, "Aguas Buenas, PR",
  704 <= $z and $z <= 784, "Guayama, PR",
  705 <= $z and $z <= 786, "Aibonito, PR",
  707 <= $z and $z <= 707, "Maunabo, PR",
  714 <= $z and $z <= 714, "Arroyo, PR",
  715 <= $z and $z <= 780, "Ponce, PR",
  718 <= $z and $z <= 744, "Naguabo, PR",
  719 <= $z and $z <= 719, "Naranjito, PR",
  720 <= $z and $z <= 720, "Orocovis, PR",
  721 <= $z and $z <= 745, "Rio Grande, PR",
  723 <= $z and $z <= 723, "Patillas, PR",
  725 <= $z and $z <= 727, "Caguas, PR",
  729 <= $z and $z <= 729, "Canovanas, PR",
  735 <= $z and $z <= 742, "Ceiba, PR",
  736 <= $z and $z <= 737, "Cayey, PR",
  738 <= $z and $z <= 740, "Fajardo, PR",
  739 <= $z and $z <= 739, "Cidra, PR",
  741 <= $z and $z <= 792, "Humacao, PR",
  751 <= $z and $z <= 751, "Salinas, PR",
  754 <= $z and $z <= 754, "San Lorenzo, PR",
  757 <= $z and $z <= 757, "Santa Isabel, PR",
  765 <= $z and $z <= 765, "Vieques, PR",
  766 <= $z and $z <= 766, "Villalba, PR",
  767 <= $z and $z <= 767, "Yabucoa, PR",
  769 <= $z and $z <= 769, "Coamo, PR",
  771 <= $z and $z <= 771, "Las Piedras, PR",
  772 <= $z and $z <= 772, "Loiza, PR",
  773 <= $z and $z <= 773, "Luquillo, PR",
  775 <= $z and $z <= 775, "Culebra, PR",
  777 <= $z and $z <= 777, "Juncos, PR",
  778 <= $z and $z <= 778, "Gurabo, PR",
  782 <= $z and $z <= 782, "Comerio, PR",
  783 <= $z and $z <= 783, "Corozal, PR",
  794 <= $z and $z <= 794, "Barranquitas, PR",
  795 <= $z and $z <= 795, "Juana Diaz, PR",
  801 <= $z and $z <= 805, "Saint Thomas, VI",
  820 <= $z and $z <= 851, "Saint Croix, VI",
  830 <= $z and $z <= 831, "Saint John, VI",
  901 <= $z and $z <= 982, "San Juan, PR",
  934 <= $z and $z <= 961, "Bayamon, PR",
  949 <= $z and $z <= 952, "Toa Baja, PR",
  953 <= $z and $z <= 954, "Toa Alta, PR",
  962 <= $z and $z <= 963, "Catano, PR",
  965 <= $z and $z <= 971, "Guaynabo, PR",
  976 <= $z and $z <= 978, "Trujillo Alto, PR",
  983 <= $z and $z <= 988, "Carolina, PR",
  1001 <= $z and $z <= 1521, "Hampden, MA",
  1002 <= $z and $z <= 1243, "Hampshire, MA",
  1005 <= $z and $z <= 1772, "Worcester, MA",
  1029 <= $z and $z <= 1343, "Berkshire, MA",
  1054 <= $z and $z <= 1380, "Franklin, MA",
  1431 <= $z and $z <= 2495, "Middlesex, MA",
  1810 <= $z and $z <= 5544, "Essex, MA",
  2018 <= $z and $z <= 2770, "Plymouth, MA",
  2019 <= $z and $z <= 2762, "Norfolk, MA",
  2031 <= $z and $z <= 2791, "Bristol, MA",
  2101 <= $z and $z <= 2297, "Suffolk, MA",
  2532 <= $z and $z <= 2675, "Barnstable, MA",
  2535 <= $z and $z <= 2713, "Dukes, MA",
  2554 <= $z and $z <= 2584, "Nantucket, MA",
  2801 <= $z and $z <= 2878, "Newport, RI",
  2802 <= $z and $z <= 2940, "Providence, RI",
  2804 <= $z and $z <= 2898, "Washington, RI",
  2806 <= $z and $z <= 2885, "Bristol, RI",
  2816 <= $z and $z <= 2893, "Kent, RI",
  3031 <= $z and $z <= 3468, "Hillsborough, NH",
  3032 <= $z and $z <= 3885, "Rockingham, NH",
  3046 <= $z and $z <= 3307, "Merrimack, NH",
  3215 <= $z and $z <= 3785, "Grafton, NH",
  3218 <= $z and $z <= 3837, "Belknap, NH",
  3227 <= $z and $z <= 3897, "Carroll, NH",
  3280 <= $z and $z <= 3782, "Sullivan, NH",
  3431 <= $z and $z <= 3609, "Cheshire, NH",
  3570 <= $z and $z <= 3598, "Coos, NH",
  3805 <= $z and $z <= 3884, "Strafford, NH",
  3901 <= $z and $z <= 4095, "York, ME",
  4003 <= $z and $z <= 4260, "Cumberland, ME",
  4008 <= $z and $z <= 4579, "Sagadahoc, ME",
  4010 <= $z and $z <= 4292, "Oxford, ME",
  4210 <= $z and $z <= 4291, "Androscoggin, ME",
  4225 <= $z and $z <= 4992, "Franklin, ME",
  4259 <= $z and $z <= 4989, "Kennebec, ME",
  4341 <= $z and $z <= 4852, "Lincoln, ME",
  4354 <= $z and $z <= 4988, "Waldo, ME",
  4401 <= $z and $z <= 4969, "Penobscot, ME",
  4406 <= $z and $z <= 4485, "Piscataquis, ME",
  4408 <= $z and $z <= 4693, "Hancock, ME",
  4413 <= $z and $z <= 4694, "Washington, ME",
  4471 <= $z and $z <= 4788, "Aroostook, ME",
  4478 <= $z and $z <= 4985, "Somerset, ME",
  4547 <= $z and $z <= 4865, "Knox, ME",
  5001 <= $z and $z <= 5772, "Windsor, VT",
  5033 <= $z and $z <= 5679, "Orange, VT",
  5042 <= $z and $z <= 5873, "Caledonia, VT",
  5101 <= $z and $z <= 5363, "Windham, VT",
  5152 <= $z and $z <= 5776, "Bennington, VT",
  5401 <= $z and $z <= 5495, "Chittenden, VT",
  5440 <= $z and $z <= 5486, "Grand Isle, VT",
  5441 <= $z and $z <= 5488, "Franklin, VT",
  5442 <= $z and $z <= 5680, "Lamoille, VT",
  5443 <= $z and $z <= 5778, "Addison, VT",
  5601 <= $z and $z <= 5682, "Washington, VT",
  5701 <= $z and $z <= 5777, "Rutland, VT",
  5820 <= $z and $z <= 5875, "Orleans, VT",
  5824 <= $z and $z <= 5907, "Essex, VT",
  6001 <= $z and $z <= 6489, "Hartford, CT",
  6018 <= $z and $z <= 6798, "Litchfield, CT",
  6029 <= $z and $z <= 6279, "Tolland, CT",
  6226 <= $z and $z <= 6387, "Windham, CT",
  6249 <= $z and $z <= 6474, "New London, CT",
  6401 <= $z and $z <= 6770, "New Haven, CT",
  6404 <= $z and $z <= 6928, "Fairfield, CT",
  6409 <= $z and $z <= 6498, "Middlesex, CT",
  7001 <= $z and $z <= 8989, "Middlesex, NJ",
  7002 <= $z and $z <= 7399, "Hudson, NJ",
  7003 <= $z and $z <= 7199, "Essex, NJ",
  7005 <= $z and $z <= 7999, "Morris, NJ",
  7010 <= $z and $z <= 7677, "Bergen, NJ",
  7011 <= $z and $z <= 7544, "Passaic, NJ",
  7016 <= $z and $z <= 7974, "Union, NJ",
  7059 <= $z and $z <= 8896, "Somerset, NJ",
  7416 <= $z and $z <= 7890, "Sussex, NJ",
  7701 <= $z and $z <= 8750, "Monmouth, NJ",
  7820 <= $z and $z <= 8886, "Warren, NJ",
  7830 <= $z and $z <= 8889, "Hunterdon, NJ",
  8001 <= $z and $z <= 8347, "Salem, NJ",
  8002 <= $z and $z <= 8110, "Camden, NJ",
  8005 <= $z and $z <= 8759, "Ocean, NJ",
  8010 <= $z and $z <= 8641, "Burlington, NJ",
  8014 <= $z and $z <= 8344, "Gloucester, NJ",
  8037 <= $z and $z <= 8406, "Atlantic, NJ",
  8202 <= $z and $z <= 8270, "Cape May, NJ",
  8302 <= $z and $z <= 8362, "Cumberland, NJ",
  8520 <= $z and $z <= 8695, "Mercer, NJ",
  9007 <= $z and $z <= 9899, "undefined, AE",
  10001 <= $z and $z <= 10292, "New York, NY",
  10301 <= $z and $z <= 10314, "Richmond, NY",
  10451 <= $z and $z <= 10499, "Bronx, NY",
  10501 <= $z and $z <= 10805, "Westchester, NY",
  10509 <= $z and $z <= 12563, "Putnam, NY",
  10901 <= $z and $z <= 10995, "Rockland, NY",
  10910 <= $z and $z <= 12780, "Orange, NY",
  11001 <= $z and $z <= 11855, "Nassau, NY",
  11004 <= $z and $z <= 11697, "Queens, NY",
  11201 <= $z and $z <= 11256, "Kings, NY",
  12007 <= $z and $z <= 12469, "Albany, NY",
  12008 <= $z and $z <= 12345, "Schenectady, NY",
  12010 <= $z and $z <= 13452, "Montgomery, NY",
  12015 <= $z and $z <= 12496, "Greene, NY",
  12017 <= $z and $z <= 12593, "Columbia, NY",
  12018 <= $z and $z <= 12198, "Rensselaer, NY",
  12019 <= $z and $z <= 12884, "Saratoga, NY",
  12025 <= $z and $z <= 13470, "Fulton, NY",
  12031 <= $z and $z <= 13459, "Schoharie, NY",
  12057 <= $z and $z <= 12887, "Washington, NY",
  12064 <= $z and $z <= 13861, "Otsego, NY",
  12108 <= $z and $z <= 13436, "Hamilton, NY",
  12167 <= $z and $z <= 13860, "Delaware, NY",
  12401 <= $z and $z <= 12782, "Ulster, NY",
  12501 <= $z and $z <= 12604, "Dutchess, NY",
  12701 <= $z and $z <= 12792, "Sullivan, NY",
  12801 <= $z and $z <= 12886, "Warren, NY",
  12851 <= $z and $z <= 12998, "Essex, NY",
  12901 <= $z and $z <= 12992, "Clinton, NY",
  12914 <= $z and $z <= 13655, "Franklin, NY",
  12922 <= $z and $z <= 13699, "Saint Lawrence, NY",
  13020 <= $z and $z <= 13290, "Onondaga, NY",
  13021 <= $z and $z <= 13166, "Cayuga, NY",
  13028 <= $z and $z <= 13493, "Oswego, NY",
  13032 <= $z and $z <= 13484, "Madison, NY",
  13040 <= $z and $z <= 13863, "Cortland, NY",
  13053 <= $z and $z <= 14886, "Tompkins, NY",
  13054 <= $z and $z <= 13599, "Oneida, NY",
  13065 <= $z and $z <= 14860, "Seneca, NY",
  13124 <= $z and $z <= 13844, "Chenango, NY",
  13143 <= $z and $z <= 14590, "Wayne, NY",
  13305 <= $z and $z <= 13648, "Lewis, NY",
  13324 <= $z and $z <= 13491, "Herkimer, NY",
  13601 <= $z and $z <= 13693, "Jefferson, NY",
  13732 <= $z and $z <= 14892, "Tioga, NY",
  13737 <= $z and $z <= 13905, "Broome, NY",
  14001 <= $z and $z <= 14280, "Erie, NY",
  14003 <= $z and $z <= 14557, "Genesee, NY",
  14008 <= $z and $z <= 14305, "Niagara, NY",
  14009 <= $z and $z <= 14591, "Wyoming, NY",
  14029 <= $z and $z <= 14897, "Allegany, NY",
  14041 <= $z and $z <= 14788, "Cattaraugus, NY",
  14048 <= $z and $z <= 14787, "Chautauqua, NY",
  14098 <= $z and $z <= 14571, "Orleans, NY",
  14410 <= $z and $z <= 14694, "Monroe, NY",
  14414 <= $z and $z <= 14846, "Livingston, NY",
  14415 <= $z and $z <= 14878, "Yates, NY",
  14424 <= $z and $z <= 14585, "Ontario, NY",
  14529 <= $z and $z <= 14898, "Steuben, NY",
  14805 <= $z and $z <= 14893, "Schuyler, NY",
  14814 <= $z and $z <= 14925, "Chemung, NY",
  15001 <= $z and $z <= 16141, "Beaver, PA",
  15004 <= $z and $z <= 15483, "Washington, PA",
  15006 <= $z and $z <= 15295, "Allegheny, PA",
  15012 <= $z and $z <= 15631, "Fayette, PA",
  15062 <= $z and $z <= 15954, "Westmoreland, PA",
  15310 <= $z and $z <= 15380, "Greene, PA",
  15411 <= $z and $z <= 15963, "Somerset, PA",
  15521 <= $z and $z <= 17211, "Bedford, PA",
  15536 <= $z and $z <= 17267, "Fulton, PA",
  15630 <= $z and $z <= 16263, "Armstrong, PA",
  15681 <= $z and $z <= 16256, "Indiana, PA",
  15711 <= $z and $z <= 15865, "Jefferson, PA",
  15714 <= $z and $z <= 16699, "Cambria, PA",
  15721 <= $z and $z <= 16881, "Clearfield, PA",
  15821 <= $z and $z <= 16734, "Elk, PA",
  15828 <= $z and $z <= 16370, "Forest, PA",
  15832 <= $z and $z <= 15861, "Cameron, PA",
  16001 <= $z and $z <= 16066, "Butler, PA",
  16028 <= $z and $z <= 16375, "Clarion, PA",
  16101 <= $z and $z <= 16172, "Lawrence, PA",
  16110 <= $z and $z <= 16440, "Crawford, PA",
  16113 <= $z and $z <= 16311, "Mercer, PA",
  16301 <= $z and $z <= 16374, "Venango, PA",
  16312 <= $z and $z <= 16436, "Warren, PA",
  16333 <= $z and $z <= 16751, "Mckean, PA",
  16401 <= $z and $z <= 16565, "Erie, PA",
  16601 <= $z and $z <= 16693, "Blair, PA",
  16611 <= $z and $z <= 17264, "Huntingdon, PA",
  16677 <= $z and $z <= 16882, "Centre, PA",
  16720 <= $z and $z <= 17729, "Potter, PA",
  16822 <= $z and $z <= 17779, "Clinton, PA",
  16901 <= $z and $z <= 17765, "Tioga, PA",
  16910 <= $z and $z <= 18854, "Bradford, PA",
  17001 <= $z and $z <= 17266, "Cumberland, PA",
  17002 <= $z and $z <= 17099, "Mifflin, PA",
  17003 <= $z and $z <= 17088, "Lebanon, PA",
  17005 <= $z and $z <= 17177, "Dauphin, PA",
  17006 <= $z and $z <= 17090, "Perry, PA",
  17014 <= $z and $z <= 17094, "Juniata, PA",
  17017 <= $z and $z <= 17881, "Northumberland, PA",
  17019 <= $z and $z <= 17415, "York, PA",
  17022 <= $z and $z <= 19501, "Lancaster, PA",
  17201 <= $z and $z <= 17272, "Franklin, PA",
  17301 <= $z and $z <= 17375, "Adams, PA",
  17701 <= $z and $z <= 17776, "Lycoming, PA",
  17731 <= $z and $z <= 18632, "Sullivan, PA",
  17810 <= $z and $z <= 17889, "Union, PA",
  17812 <= $z and $z <= 17882, "Snyder, PA",
  17814 <= $z and $z <= 18631, "Columbia, PA",
  17821 <= $z and $z <= 17884, "Montour, PA",
  17901 <= $z and $z <= 19549, "Schuylkill, PA",
  18001 <= $z and $z <= 18351, "Northampton, PA",
  18011 <= $z and $z <= 18195, "Lehigh, PA",
  18012 <= $z and $z <= 18624, "Carbon, PA",
  18039 <= $z and $z <= 19067, "Bucks, PA",
  18041 <= $z and $z <= 19525, "Montgomery, PA",
  18056 <= $z and $z <= 19640, "Berks, PA",
  18058 <= $z and $z <= 18610, "Monroe, PA",
  18201 <= $z and $z <= 18774, "Luzerne, PA",
  18324 <= $z and $z <= 18464, "Pike, PA",
  18401 <= $z and $z <= 18473, "Wayne, PA",
  18403 <= $z and $z <= 18653, "Lackawanna, PA",
  18413 <= $z and $z <= 18847, "Susquehanna, PA",
  18419 <= $z and $z <= 18657, "Wyoming, PA",
  19003 <= $z and $z <= 19373, "Delaware, PA",
  19019 <= $z and $z <= 19255, "Philadelphia, PA",
  19301 <= $z and $z <= 19520, "Chester, PA",
  19415 <= $z and $z <= 19415, "undefined, PA",
  19701 <= $z and $z <= 19899, "New Castle, DE",
  19901 <= $z and $z <= 19980, "Kent, DE",
  19930 <= $z and $z <= 19975, "Sussex, DE",
  20001 <= $z and $z <= 20599, "District Of Columbia, DC",
  20101 <= $z and $z <= 22093, "Loudoun, VA",
  20106 <= $z and $z <= 22749, "Rappahannock, VA",
  20108 <= $z and $z <= 20110, "Manassas City, VA",
  20111 <= $z and $z <= 20113, "Manassas Park City, VA",
  20115 <= $z and $z <= 22742, "Fauquier, VA",
  20120 <= $z and $z <= 22321, "Fairfax, VA",
  20136 <= $z and $z <= 22195, "Prince William, VA",
  20601 <= $z and $z <= 20695, "Charles, MD",
  20606 <= $z and $z <= 20692, "Saint Marys, MD",
  20607 <= $z and $z <= 20799, "Prince Georges, MD",
  20610 <= $z and $z <= 20754, "Calvert, MD",
  20701 <= $z and $z <= 21794, "Howard, MD",
  20711 <= $z and $z <= 21412, "Anne Arundel, MD",
  20812 <= $z and $z <= 20997, "Montgomery, MD",
  21001 <= $z and $z <= 21161, "Harford, MD",
  21013 <= $z and $z <= 21286, "Baltimore, MD",
  21048 <= $z and $z <= 21797, "Carroll, MD",
  21201 <= $z and $z <= 21298, "Baltimore City, MD",
  21501 <= $z and $z <= 21766, "Allegany, MD",
  21520 <= $z and $z <= 21561, "Garrett, MD",
  21601 <= $z and $z <= 21679, "Talbot, MD",
  21607 <= $z and $z <= 21690, "Queen Annes, MD",
  21609 <= $z and $z <= 21688, "Caroline, MD",
  21610 <= $z and $z <= 21678, "Kent, MD",
  21613 <= $z and $z <= 21869, "Dorchester, MD",
  21701 <= $z and $z <= 21798, "Frederick, MD",
  21711 <= $z and $z <= 21795, "Washington, MD",
  21801 <= $z and $z <= 21875, "Wicomico, MD",
  21811 <= $z and $z <= 21872, "Worcester, MD",
  21817 <= $z and $z <= 21890, "Somerset, MD",
  21901 <= $z and $z <= 21930, "Cecil, MD",
  22030 <= $z and $z <= 22038, "Fairfax City, VA",
  22040 <= $z and $z <= 22046, "Falls Church City, VA",
  22201 <= $z and $z <= 22246, "Arlington, VA",
  22301 <= $z and $z <= 22336, "Alexandria City, VA",
  22401 <= $z and $z <= 22404, "Fredericksburg City, VA",
  22403 <= $z and $z <= 22555, "Stafford, VA",
  22407 <= $z and $z <= 22565, "Spotsylvania, VA",
  22427 <= $z and $z <= 22580, "Caroline, VA",
  22432 <= $z and $z <= 22579, "Northumberland, VA",
  22433 <= $z and $z <= 22972, "Orange, VA",
  22436 <= $z and $z <= 23115, "Essex, VA",
  22442 <= $z and $z <= 22581, "Westmoreland, VA",
  22448 <= $z and $z <= 22547, "King George, VA",
  22460 <= $z and $z <= 22572, "Richmond, VA",
  22480 <= $z and $z <= 22578, "Lancaster, VA",
  22601 <= $z and $z <= 22604, "Winchester City, VA",
  22602 <= $z and $z <= 22656, "Frederick, VA",
  22610 <= $z and $z <= 22649, "Warren, VA",
  22611 <= $z and $z <= 22663, "Clarke, VA",
  22626 <= $z and $z <= 22847, "Shenandoah, VA",
  22650 <= $z and $z <= 22851, "Page, VA",
  22701 <= $z and $z <= 22741, "Culpeper, VA",
  22709 <= $z and $z <= 22989, "Madison, VA",
  22801 <= $z and $z <= 22807, "Harrisonburg City, VA",
  22802 <= $z and $z <= 24471, "Rockingham, VA",
  22843 <= $z and $z <= 24486, "Augusta, VA",
  22901 <= $z and $z <= 24590, "Albemarle, VA",
  22902 <= $z and $z <= 22910, "Charlottesville City, VA",
  22920 <= $z and $z <= 24599, "Nelson, VA",
  22935 <= $z and $z <= 22973, "Greene, VA",
  22963 <= $z and $z <= 23084, "Fluvanna, VA",
  22980 <= $z and $z <= 22980, "Waynesboro City, VA",
  23001 <= $z and $z <= 23191, "Gloucester, VA",
  23002 <= $z and $z <= 23105, "Amelia, VA",
  23004 <= $z and $z <= 23936, "Buckingham, VA",
  23005 <= $z and $z <= 23192, "Hanover, VA",
  23009 <= $z and $z <= 23181, "King William, VA",
  23011 <= $z and $z <= 23141, "New Kent, VA",
  23014 <= $z and $z <= 23238, "Goochland, VA",
  23021 <= $z and $z <= 23163, "Mathews, VA",
  23023 <= $z and $z <= 23177, "King And Queen, VA",
  23024 <= $z and $z <= 23170, "Louisa, VA",
  23027 <= $z and $z <= 23040, "Cumberland, VA",
  23030 <= $z and $z <= 23147, "Charles City, VA",
  23031 <= $z and $z <= 23180, "Middlesex, VA",
  23058 <= $z and $z <= 23294, "Henrico, VA",
  23081 <= $z and $z <= 23188, "James City, VA",
  23090 <= $z and $z <= 23696, "York, VA",
  23101 <= $z and $z <= 23139, "Powhatan, VA",
  23112 <= $z and $z <= 23838, "Chesterfield, VA",
  23173 <= $z and $z <= 23298, "Richmond City, VA",
  23186 <= $z and $z <= 23187, "Williamsburg City, VA",
  23301 <= $z and $z <= 23488, "Accomack, VA",
  23304 <= $z and $z <= 23898, "Isle Of Wight, VA",
  23307 <= $z and $z <= 23486, "Northampton, VA",
  23320 <= $z and $z <= 23328, "Chesapeake City, VA",
  23432 <= $z and $z <= 23439, "Suffolk City, VA",
  23450 <= $z and $z <= 23521, "Virginia Beach City, VA",
  23501 <= $z and $z <= 23551, "Norfolk City, VA",
  23601 <= $z and $z <= 23628, "Newport News City, VA",
  23630 <= $z and $z <= 23681, "Hampton City, VA",
  23662 <= $z and $z <= 23662, "Poquoson City, VA",
  23701 <= $z and $z <= 23709, "Portsmouth City, VA",
  23801 <= $z and $z <= 23875, "Prince George, VA",
  23803 <= $z and $z <= 23806, "Petersburg City, VA",
  23821 <= $z and $z <= 23920, "Brunswick, VA",
  23822 <= $z and $z <= 23894, "Dinwiddie, VA",
  23824 <= $z and $z <= 23955, "Nottoway, VA",
  23827 <= $z and $z <= 23878, "Southampton, VA",
  23834 <= $z and $z <= 23834, "Colonial Heights City, VA",
  23839 <= $z and $z <= 23899, "Surry, VA",
  23847 <= $z and $z <= 23847, "Emporia City, VA",
  23851 <= $z and $z <= 23851, "Franklin City, VA",
  23860 <= $z and $z <= 23860, "Hopewell City, VA",
  23867 <= $z and $z <= 23897, "Sussex, VA",
  23870 <= $z and $z <= 23879, "Greensville, VA",
  23901 <= $z and $z <= 23966, "Prince Edward, VA",
  23915 <= $z and $z <= 24580, "Mecklenburg, VA",
  23923 <= $z and $z <= 23976, "Charlotte, VA",
  23938 <= $z and $z <= 23974, "Lunenburg, VA",
  23939 <= $z and $z <= 24593, "Appomattox, VA",
  24001 <= $z and $z <= 24048, "Roanoke City, VA",
  24018 <= $z and $z <= 24179, "Roanoke, VA",
  24019 <= $z and $z <= 24438, "Botetourt, VA",
  24023 <= $z and $z <= 24162, "Montgomery, VA",
  24053 <= $z and $z <= 24185, "Patrick, VA",
  24054 <= $z and $z <= 24168, "Henry, VA",
  24058 <= $z and $z <= 24347, "Pulaski, VA",
  24065 <= $z and $z <= 24184, "Franklin, VA",
  24069 <= $z and $z <= 24594, "Pittsylvania, VA",
  24072 <= $z and $z <= 24380, "Floyd, VA",
  24086 <= $z and $z <= 24167, "Giles, VA",
  24095 <= $z and $z <= 24570, "Bedford, VA",
  24112 <= $z and $z <= 24115, "Martinsville City, VA",
  24127 <= $z and $z <= 24131, "Craig, VA",
  24141 <= $z and $z <= 24143, "Radford, VA",
  24153 <= $z and $z <= 24157, "Salem, VA",
  24201 <= $z and $z <= 24209, "Bristol, VA",
  24210 <= $z and $z <= 24361, "Washington, VA",
  24215 <= $z and $z <= 24293, "Wise, VA",
  24217 <= $z and $z <= 24607, "Dickenson, VA",
  24218 <= $z and $z <= 24282, "Lee, VA",
  24224 <= $z and $z <= 24649, "Russell, VA",
  24239 <= $z and $z <= 24658, "Buchanan, VA",
  24244 <= $z and $z <= 24290, "Scott, VA",
  24273 <= $z and $z <= 24273, "Norton City, VA",
  24292 <= $z and $z <= 24379, "Grayson, VA",
  24311 <= $z and $z <= 24375, "Smyth, VA",
  24312 <= $z and $z <= 24382, "Wythe, VA",
  24314 <= $z and $z <= 24366, "Bland, VA",
  24317 <= $z and $z <= 24381, "Carroll, VA",
  24333 <= $z and $z <= 24333, "Galax City, VA",
  24377 <= $z and $z <= 24651, "Tazewell, VA",
  24401 <= $z and $z <= 24402, "Staunton City, VA",
  24412 <= $z and $z <= 24487, "Bath, VA",
  24413 <= $z and $z <= 24468, "Highland, VA",
  24415 <= $z and $z <= 24579, "Rockbridge, VA",
  24416 <= $z and $z <= 24416, "Buena Vista City, VA",
  24422 <= $z and $z <= 24422, "Clifton Forge City, VA",
  24426 <= $z and $z <= 24426, "Covington City, VA",
  24448 <= $z and $z <= 24474, "Alleghany, VA",
  24450 <= $z and $z <= 24450, "Lexington City, VA",
  24501 <= $z and $z <= 24515, "Lynchburg City, VA",
  24512 <= $z and $z <= 24588, "Campbell, VA",
  24520 <= $z and $z <= 24598, "Halifax, VA",
  24521 <= $z and $z <= 24595, "Amherst, VA",
  24523 <= $z and $z <= 24523, "Bedford City, VA",
  24540 <= $z and $z <= 24544, "Danville City, VA",
  24701 <= $z and $z <= 25971, "Mercer, WV",
  24716 <= $z and $z <= 25943, "Wyoming, WV",
  24801 <= $z and $z <= 24899, "Mcdowell, WV",
  24851 <= $z and $z <= 25697, "Mingo, WV",
  24901 <= $z and $z <= 25984, "Greenbrier, WV",
  24915 <= $z and $z <= 26291, "Pocahontas, WV",
  24918 <= $z and $z <= 24993, "Monroe, WV",
  24919 <= $z and $z <= 25988, "Summers, WV",
  25002 <= $z and $z <= 26680, "Fayette, WV",
  25003 <= $z and $z <= 25396, "Kanawha, WV",
  25004 <= $z and $z <= 25989, "Raleigh, WV",
  25005 <= $z and $z <= 25286, "Roane, WV",
  25009 <= $z and $z <= 25529, "Boone, WV",
  25011 <= $z and $z <= 25569, "Putnam, WV",
  25018 <= $z and $z <= 26617, "Clay, WV",
  25022 <= $z and $z <= 25654, "Logan, WV",
  25059 <= $z and $z <= 26691, "Nicholas, WV",
  25095 <= $z and $z <= 25550, "Mason, WV",
  25231 <= $z and $z <= 26173, "Jackson, WV",
  25234 <= $z and $z <= 26151, "Calhoun, WV",
  25258 <= $z and $z <= 26638, "Gilmer, WV",
  25401 <= $z and $z <= 25440, "Berkeley, WV",
  25410 <= $z and $z <= 25446, "Jefferson, WV",
  25411 <= $z and $z <= 25434, "Morgan, WV",
  25431 <= $z and $z <= 26865, "Hampshire, WV",
  25501 <= $z and $z <= 25573, "Lincoln, WV",
  25504 <= $z and $z <= 25779, "Cabell, WV",
  25507 <= $z and $z <= 25709, "Wayne, WV",
  26003 <= $z and $z <= 26074, "Ohio, WV",
  26030 <= $z and $z <= 26075, "Brooke, WV",
  26031 <= $z and $z <= 26055, "Marshall, WV",
  26034 <= $z and $z <= 26062, "Hancock, WV",
  26101 <= $z and $z <= 26187, "Wood, WV",
  26134 <= $z and $z <= 26170, "Pleasants, WV",
  26135 <= $z and $z <= 26434, "Tyler, WV",
  26138 <= $z and $z <= 26160, "Wirt, WV",
  26148 <= $z and $z <= 26421, "Ritchie, WV",
  26155 <= $z and $z <= 26581, "Wetzel, WV",
  26201 <= $z and $z <= 26237, "Upshur, WV",
  26203 <= $z and $z <= 26298, "Webster, WV",
  26224 <= $z and $z <= 26296, "Randolph, WV",
  26238 <= $z and $z <= 26416, "Barbour, WV",
  26260 <= $z and $z <= 26292, "Tucker, WV",
  26301 <= $z and $z <= 26568, "Harrison, WV",
  26321 <= $z and $z <= 26452, "Lewis, WV",
  26328 <= $z and $z <= 26456, "Doddridge, WV",
  26335 <= $z and $z <= 26641, "Braxton, WV",
  26347 <= $z and $z <= 26440, "Taylor, WV",
  26374 <= $z and $z <= 26764, "Preston, WV",
  26501 <= $z and $z <= 26590, "Monongalia, WV",
  26554 <= $z and $z <= 26591, "Marion, WV",
  26707 <= $z and $z <= 26855, "Grant, WV",
  26710 <= $z and $z <= 26767, "Mineral, WV",
  26801 <= $z and $z <= 26851, "Hardy, WV",
  26802 <= $z and $z <= 26886, "Pendleton, WV",
  27006 <= $z and $z <= 27028, "Davie, NC",
  27007 <= $z and $z <= 28676, "Surry, NC",
  27009 <= $z and $z <= 27285, "Forsyth, NC",
  27011 <= $z and $z <= 28642, "Yadkin, NC",
  27013 <= $z and $z <= 28159, "Rowan, NC",
  27016 <= $z and $z <= 27052, "Stokes, NC",
  27025 <= $z and $z <= 27375, "Rockingham, NC",
  27201 <= $z and $z <= 27359, "Alamance, NC",
  27203 <= $z and $z <= 27370, "Randolph, NC",
  27207 <= $z and $z <= 27559, "Chatham, NC",
  27209 <= $z and $z <= 27371, "Montgomery, NC",
  27212 <= $z and $z <= 27379, "Caswell, NC",
  27214 <= $z and $z <= 27499, "Guilford, NC",
  27231 <= $z and $z <= 27599, "Orange, NC",
  27237 <= $z and $z <= 28355, "Lee, NC",
  27239 <= $z and $z <= 27374, "Davidson, NC",
  27242 <= $z and $z <= 28394, "Moore, NC",
  27343 <= $z and $z <= 27583, "Person, NC",
  27501 <= $z and $z <= 28368, "Harnett, NC",
  27502 <= $z and $z <= 27699, "Wake, NC",
  27503 <= $z and $z <= 27722, "Durham, NC",
  27504 <= $z and $z <= 27593, "Johnston, NC",
  27507 <= $z and $z <= 27582, "Granville, NC",
  27508 <= $z and $z <= 27596, "Franklin, NC",
  27530 <= $z and $z <= 28578, "Wayne, NC",
  27536 <= $z and $z <= 27584, "Vance, NC",
  27551 <= $z and $z <= 27594, "Warren, NC",
  27801 <= $z and $z <= 27886, "Edgecombe, NC",
  27803 <= $z and $z <= 27891, "Nash, NC",
  27805 <= $z and $z <= 27983, "Bertie, NC",
  27806 <= $z and $z <= 27889, "Beaufort, NC",
  27811 <= $z and $z <= 28590, "Pitt, NC",
  27813 <= $z and $z <= 27896, "Wilson, NC",
  27818 <= $z and $z <= 27986, "Hertford, NC",
  27820 <= $z and $z <= 27897, "Northampton, NC",
  27823 <= $z and $z <= 27890, "Halifax, NC",
  27824 <= $z and $z <= 27960, "Hyde, NC",
  27825 <= $z and $z <= 27892, "Martin, NC",
  27888 <= $z and $z <= 28580, "Greene, NC",
  27906 <= $z and $z <= 27909, "Pasquotank, NC",
  27915 <= $z and $z <= 27982, "Dare, NC",
  27916 <= $z and $z <= 27973, "Currituck, NC",
  27919 <= $z and $z <= 27985, "Perquimans, NC",
  27921 <= $z and $z <= 27976, "Camden, NC",
  27925 <= $z and $z <= 27925, "Tyrrell, NC",
  27926 <= $z and $z <= 27979, "Gates, NC",
  27928 <= $z and $z <= 27970, "Washington, NC",
  27932 <= $z and $z <= 27980, "Chowan, NC",
  28001 <= $z and $z <= 28163, "Stanly, NC",
  28006 <= $z and $z <= 28164, "Gaston, NC",
  28007 <= $z and $z <= 28170, "Anson, NC",
  28010 <= $z and $z <= 28699, "Iredell, NC",
  28017 <= $z and $z <= 28169, "Cleveland, NC",
  28018 <= $z and $z <= 28746, "Rutherford, NC",
  28025 <= $z and $z <= 28124, "Cabarrus, NC",
  28031 <= $z and $z <= 28299, "Mecklenburg, NC",
  28033 <= $z and $z <= 28168, "Lincoln, NC",
  28079 <= $z and $z <= 28174, "Union, NC",
  28271 <= $z and $z <= 28271, "undefined, NC",
  28301 <= $z and $z <= 28395, "Cumberland, NC",
  28318 <= $z and $z <= 28447, "Sampson, NC",
  28319 <= $z and $z <= 28386, "Robeson, NC",
  28320 <= $z and $z <= 28448, "Bladen, NC",
  28325 <= $z and $z <= 28521, "Duplin, NC",
  28330 <= $z and $z <= 28380, "Richmond, NC",
  28343 <= $z and $z <= 28396, "Scotland, NC",
  28361 <= $z and $z <= 28376, "Hoke, NC",
  28401 <= $z and $z <= 28480, "New Hanover, NC",
  28404 <= $z and $z <= 28479, "Brunswick, NC",
  28421 <= $z and $z <= 28478, "Pender, NC",
  28423 <= $z and $z <= 28472, "Columbus, NC",
  28445 <= $z and $z <= 28584, "Onslow, NC",
  28501 <= $z and $z <= 28572, "Lenoir, NC",
  28509 <= $z and $z <= 28587, "Pamlico, NC",
  28511 <= $z and $z <= 28594, "Carteret, NC",
  28519 <= $z and $z <= 28586, "Craven, NC",
  28522 <= $z and $z <= 28585, "Jones, NC",
  28601 <= $z and $z <= 28682, "Catawba, NC",
  28604 <= $z and $z <= 28664, "Avery, NC",
  28605 <= $z and $z <= 28698, "Watauga, NC",
  28606 <= $z and $z <= 28697, "Wilkes, NC",
  28611 <= $z and $z <= 28667, "Caldwell, NC",
  28612 <= $z and $z <= 28690, "Burke, NC",
  28615 <= $z and $z <= 28694, "Ashe, NC",
  28623 <= $z and $z <= 28675, "Alleghany, NC",
  28636 <= $z and $z <= 28681, "Alexander, NC",
  28701 <= $z and $z <= 28816, "Buncombe, NC",
  28702 <= $z and $z <= 28719, "Swain, NC",
  28705 <= $z and $z <= 28777, "Mitchell, NC",
  28707 <= $z and $z <= 28789, "Jackson, NC",
  28708 <= $z and $z <= 28774, "Transylvania, NC",
  28710 <= $z and $z <= 28793, "Henderson, NC",
  28714 <= $z and $z <= 28755, "Yancey, NC",
  28716 <= $z and $z <= 28786, "Haywood, NC",
  28722 <= $z and $z <= 28782, "Polk, NC",
  28733 <= $z and $z <= 28771, "Graham, NC",
  28734 <= $z and $z <= 28775, "Macon, NC",
  28737 <= $z and $z <= 28762, "Mcdowell, NC",
  28743 <= $z and $z <= 28754, "Madison, NC",
  28781 <= $z and $z <= 28906, "Cherokee, NC",
  28902 <= $z and $z <= 28909, "Clay, NC",
  29001 <= $z and $z <= 29162, "Clarendon, SC",
  29002 <= $z and $z <= 29292, "Richland, SC",
  29003 <= $z and $z <= 29843, "Bamberg, SC",
  29006 <= $z and $z <= 29228, "Lexington, SC",
  29009 <= $z and $z <= 29175, "Kershaw, SC",
  29010 <= $z and $z <= 29080, "Lee, SC",
  29014 <= $z and $z <= 29729, "Chester, SC",
  29015 <= $z and $z <= 29180, "Fairfield, SC",
  29018 <= $z and $z <= 29432, "Orangeburg, SC",
  29030 <= $z and $z <= 29135, "Calhoun, SC",
  29031 <= $z and $z <= 29395, "Union, SC",
  29037 <= $z and $z <= 29355, "Newberry, SC",
  29040 <= $z and $z <= 29168, "Sumter, SC",
  29056 <= $z and $z <= 29590, "Williamsburg, SC",
  29058 <= $z and $z <= 29744, "Lancaster, SC",
  29069 <= $z and $z <= 29593, "Darlington, SC",
  29082 <= $z and $z <= 29929, "Colleton, SC",
  29101 <= $z and $z <= 29741, "Chesterfield, SC",
  29105 <= $z and $z <= 29166, "Saluda, SC",
  29114 <= $z and $z <= 29591, "Florence, SC",
  29137 <= $z and $z <= 29861, "Aiken, SC",
  29301 <= $z and $z <= 29698, "Spartanburg, SC",
  29325 <= $z and $z <= 29645, "Laurens, SC",
  29340 <= $z and $z <= 29702, "Cherokee, SC",
  29401 <= $z and $z <= 29487, "Charleston, SC",
  29410 <= $z and $z <= 29492, "Berkeley, SC",
  29420 <= $z and $z <= 29485, "Dorchester, SC",
  29440 <= $z and $z <= 29585, "Georgetown, SC",
  29511 <= $z and $z <= 29598, "Horry, SC",
  29512 <= $z and $z <= 29596, "Marlboro, SC",
  29519 <= $z and $z <= 29592, "Marion, SC",
  29536 <= $z and $z <= 29573, "Dillon, SC",
  29601 <= $z and $z <= 29690, "Greenville, SC",
  29620 <= $z and $z <= 29659, "Abbeville, SC",
  29621 <= $z and $z <= 29697, "Anderson, SC",
  29630 <= $z and $z <= 29685, "Pickens, SC",
  29643 <= $z and $z <= 29696, "Oconee, SC",
  29646 <= $z and $z <= 29848, "Greenwood, SC",
  29703 <= $z and $z <= 29745, "York, SC",
  29810 <= $z and $z <= 29849, "Allendale, SC",
  29812 <= $z and $z <= 29853, "Barnwell, SC",
  29821 <= $z and $z <= 29899, "Mccormick, SC",
  29824 <= $z and $z <= 29847, "Edgefield, SC",
  29901 <= $z and $z <= 29941, "Beaufort, SC",
  29911 <= $z and $z <= 29945, "Hampton, SC",
  29912 <= $z and $z <= 29943, "Jasper, SC",
  30002 <= $z and $z <= 39901, "Dekalb, GA",
  30003 <= $z and $z <= 30519, "Gwinnett, GA",
  30004 <= $z and $z <= 31199, "Fulton, GA",
  30006 <= $z and $z <= 30168, "Cobb, GA",
  30011 <= $z and $z <= 30680, "Barrow, GA",
  30012 <= $z and $z <= 30094, "Rockdale, GA",
  30014 <= $z and $z <= 30070, "Newton, GA",
  30018 <= $z and $z <= 30656, "Walton, GA",
  30028 <= $z and $z <= 30041, "Forsyth, GA",
  30055 <= $z and $z <= 31085, "Jasper, GA",
  30103 <= $z and $z <= 30184, "Bartow, GA",
  30104 <= $z and $z <= 30153, "Polk, GA",
  30105 <= $z and $z <= 30173, "Floyd, GA",
  30107 <= $z and $z <= 30189, "Cherokee, GA",
  30108 <= $z and $z <= 30185, "Carroll, GA",
  30110 <= $z and $z <= 30182, "Haralson, GA",
  30122 <= $z and $z <= 30187, "Douglas, GA",
  30132 <= $z and $z <= 30157, "Paulding, GA",
  30139 <= $z and $z <= 30746, "Gordon, GA",
  30143 <= $z and $z <= 30177, "Pickens, GA",
  30204 <= $z and $z <= 30257, "Lamar, GA",
  30205 <= $z and $z <= 30290, "Fayette, GA",
  30206 <= $z and $z <= 30295, "Pike, GA",
  30212 <= $z and $z <= 30284, "Spalding, GA",
  30216 <= $z and $z <= 30234, "Butts, GA",
  30217 <= $z and $z <= 30219, "Heard, GA",
  30218 <= $z and $z <= 31830, "Meriwether, GA",
  30220 <= $z and $z <= 30289, "Coweta, GA",
  30228 <= $z and $z <= 30281, "Henry, GA",
  30230 <= $z and $z <= 31833, "Troup, GA",
  30236 <= $z and $z <= 30298, "Clayton, GA",
  30285 <= $z and $z <= 31097, "Upson, GA",
  30401 <= $z and $z <= 31002, "Emanuel, GA",
  30410 <= $z and $z <= 30473, "Montgomery, GA",
  30411 <= $z and $z <= 30428, "Wheeler, GA",
  30413 <= $z and $z <= 30833, "Jefferson, GA",
  30414 <= $z and $z <= 30429, "Evans, GA",
  30415 <= $z and $z <= 30461, "Bulloch, GA",
  30420 <= $z and $z <= 30499, "Tattnall, GA",
  30424 <= $z and $z <= 30467, "Screven, GA",
  30426 <= $z and $z <= 30830, "Burke, GA",
  30436 <= $z and $z <= 30475, "Toombs, GA",
  30439 <= $z and $z <= 30451, "Candler, GA",
  30442 <= $z and $z <= 30822, "Jenkins, GA",
  30454 <= $z and $z <= 31075, "Laurens, GA",
  30457 <= $z and $z <= 30457, "Treutlen, GA",
  30501 <= $z and $z <= 30566, "Hall, GA",
  30510 <= $z and $z <= 30596, "Habersham, GA",
  30511 <= $z and $z <= 30558, "Banks, GA",
  30512 <= $z and $z <= 30572, "Union, GA",
  30513 <= $z and $z <= 30560, "Fannin, GA",
  30516 <= $z and $z <= 30643, "Hart, GA",
  30517 <= $z and $z <= 30599, "Jackson, GA",
  30520 <= $z and $z <= 30662, "Franklin, GA",
  30522 <= $z and $z <= 30540, "Gilmer, GA",
  30525 <= $z and $z <= 30581, "Rabun, GA",
  30528 <= $z and $z <= 30571, "White, GA",
  30533 <= $z and $z <= 30597, "Lumpkin, GA",
  30534 <= $z and $z <= 30534, "Dawson, GA",
  30538 <= $z and $z <= 30598, "Stephens, GA",
  30546 <= $z and $z <= 30582, "Towns, GA",
  30601 <= $z and $z <= 30683, "Clarke, GA",
  30619 <= $z and $z <= 30671, "Oglethorpe, GA",
  30621 <= $z and $z <= 30677, "Oconee, GA",
  30623 <= $z and $z <= 30663, "Morgan, GA",
  30624 <= $z and $z <= 30635, "Elbert, GA",
  30627 <= $z and $z <= 30647, "Madison, GA",
  30631 <= $z and $z <= 30664, "Taliaferro, GA",
  30642 <= $z and $z <= 30678, "Greene, GA",
  30660 <= $z and $z <= 30673, "Wilkes, GA",
  30705 <= $z and $z <= 30751, "Murray, GA",
  30707 <= $z and $z <= 30750, "Walker, GA",
  30710 <= $z and $z <= 30756, "Whitfield, GA",
  30726 <= $z and $z <= 30742, "Catoosa, GA",
  30730 <= $z and $z <= 30753, "Chattooga, GA",
  30738 <= $z and $z <= 30757, "Dade, GA",
  30802 <= $z and $z <= 30917, "Columbia, GA",
  30805 <= $z and $z <= 30999, "Richmond, GA",
  30806 <= $z and $z <= 30824, "Mcduffie, GA",
  30807 <= $z and $z <= 31045, "Warren, GA",
  30810 <= $z and $z <= 30820, "Glascock, GA",
  30817 <= $z and $z <= 30817, "Lincoln, GA",
  31001 <= $z and $z <= 31084, "Wilcox, GA",
  31003 <= $z and $z <= 31090, "Wilkinson, GA",
  31004 <= $z and $z <= 31086, "Monroe, GA",
  31005 <= $z and $z <= 31099, "Houston, GA",
  31006 <= $z and $z <= 31081, "Taylor, GA",
  31007 <= $z and $z <= 31092, "Dooly, GA",
  31008 <= $z and $z <= 31030, "Peach, GA",
  31010 <= $z and $z <= 31712, "Crisp, GA",
  31011 <= $z and $z <= 31077, "Dodge, GA",
  31014 <= $z and $z <= 31014, "Bleckley, GA",
  31017 <= $z and $z <= 31044, "Twiggs, GA",
  31018 <= $z and $z <= 31094, "Washington, GA",
  31024 <= $z and $z <= 31024, "Putnam, GA",
  31032 <= $z and $z <= 31033, "Jones, GA",
  31034 <= $z and $z <= 31062, "Baldwin, GA",
  31036 <= $z and $z <= 31036, "Pulaski, GA",
  31037 <= $z and $z <= 31549, "Telfair, GA",
  31041 <= $z and $z <= 31068, "Macon, GA",
  31049 <= $z and $z <= 31096, "Johnson, GA",
  31050 <= $z and $z <= 31078, "Crawford, GA",
  31087 <= $z and $z <= 31087, "Hancock, GA",
  31201 <= $z and $z <= 31299, "Bibb, GA",
  31301 <= $z and $z <= 31333, "Liberty, GA",
  31302 <= $z and $z <= 31499, "Chatham, GA",
  31303 <= $z and $z <= 31329, "Effingham, GA",
  31304 <= $z and $z <= 31331, "Mcintosh, GA",
  31308 <= $z and $z <= 31324, "Bryan, GA",
  31316 <= $z and $z <= 31316, "Long, GA",
  31501 <= $z and $z <= 31564, "Ware, GA",
  31510 <= $z and $z <= 31510, "Bacon, GA",
  31512 <= $z and $z <= 31567, "Coffee, GA",
  31513 <= $z and $z <= 31563, "Appling, GA",
  31516 <= $z and $z <= 31557, "Pierce, GA",
  31520 <= $z and $z <= 31561, "Glynn, GA",
  31532 <= $z and $z <= 31539, "Jeff Davis, GA",
  31537 <= $z and $z <= 31646, "Charlton, GA",
  31542 <= $z and $z <= 31566, "Brantley, GA",
  31545 <= $z and $z <= 31599, "Wayne, GA",
  31547 <= $z and $z <= 31569, "Camden, GA",
  31601 <= $z and $z <= 31699, "Lowndes, GA",
  31620 <= $z and $z <= 31647, "Cook, GA",
  31622 <= $z and $z <= 31749, "Berrien, GA",
  31623 <= $z and $z <= 31634, "Clinch, GA",
  31624 <= $z and $z <= 31650, "Atkinson, GA",
  31625 <= $z and $z <= 31720, "Brooks, GA",
  31626 <= $z and $z <= 31799, "Thomas, GA",
  31635 <= $z and $z <= 31649, "Lanier, GA",
  31648 <= $z and $z <= 31648, "Echols, GA",
  31701 <= $z and $z <= 31782, "Dougherty, GA",
  31709 <= $z and $z <= 31780, "Sumter, GA",
  31713 <= $z and $z <= 31766, "Calhoun, GA",
  31714 <= $z and $z <= 31790, "Turner, GA",
  31715 <= $z and $z <= 31752, "Decatur, GA",
  31716 <= $z and $z <= 31784, "Mitchell, GA",
  31722 <= $z and $z <= 31776, "Colquitt, GA",
  31723 <= $z and $z <= 31761, "Early, GA",
  31724 <= $z and $z <= 31751, "Clay, GA",
  31726 <= $z and $z <= 31785, "Terrell, GA",
  31727 <= $z and $z <= 31795, "Tift, GA",
  31728 <= $z and $z <= 31797, "Grady, GA",
  31736 <= $z and $z <= 31786, "Randolph, GA",
  31737 <= $z and $z <= 31737, "Miller, GA",
  31745 <= $z and $z <= 31759, "Seminole, GA",
  31750 <= $z and $z <= 31750, "Ben Hill, GA",
  31754 <= $z and $z <= 31767, "Quitman, GA",
  31760 <= $z and $z <= 31798, "Irwin, GA",
  31763 <= $z and $z <= 31787, "Lee, GA",
  31770 <= $z and $z <= 31770, "Baker, GA",
  31772 <= $z and $z <= 31796, "Worth, GA",
  31801 <= $z and $z <= 31836, "Talbot, GA",
  31803 <= $z and $z <= 31803, "Marion, GA",
  31804 <= $z and $z <= 31831, "Harris, GA",
  31805 <= $z and $z <= 31805, "Chattahoochee, GA",
  31806 <= $z and $z <= 31806, "Schley, GA",
  31808 <= $z and $z <= 31999, "Muscogee, GA",
  31814 <= $z and $z <= 31825, "Stewart, GA",
  31824 <= $z and $z <= 31832, "Webster, GA",
  32003 <= $z and $z <= 32656, "Clay, FL",
  32004 <= $z and $z <= 32260, "Saint Johns, FL",
  32007 <= $z and $z <= 32666, "Putnam, FL",
  32008 <= $z and $z <= 32094, "Suwannee, FL",
  32009 <= $z and $z <= 32097, "Nassau, FL",
  32013 <= $z and $z <= 32066, "Lafayette, FL",
  32024 <= $z and $z <= 32061, "Columbia, FL",
  32040 <= $z and $z <= 32087, "Baker, FL",
  32042 <= $z and $z <= 32622, "Bradford, FL",
  32052 <= $z and $z <= 32096, "Hamilton, FL",
  32054 <= $z and $z <= 32697, "Union, FL",
  32059 <= $z and $z <= 32350, "Madison, FL",
  32099 <= $z and $z <= 32290, "Duval, FL",
  32102 <= $z and $z <= 34797, "Lake, FL",
  32105 <= $z and $z <= 32774, "Volusia, FL",
  32110 <= $z and $z <= 32164, "Flagler, FL",
  32111 <= $z and $z <= 34492, "Marion, FL",
  32162 <= $z and $z <= 34785, "Sumter, FL",
  32301 <= $z and $z <= 32399, "Leon, FL",
  32305 <= $z and $z <= 32358, "Wakulla, FL",
  32320 <= $z and $z <= 32329, "Franklin, FL",
  32321 <= $z and $z <= 32360, "Liberty, FL",
  32324 <= $z and $z <= 32353, "Gadsden, FL",
  32336 <= $z and $z <= 32361, "Jefferson, FL",
  32347 <= $z and $z <= 32359, "Taylor, FL",
  32401 <= $z and $z <= 32466, "Bay, FL",
  32420 <= $z and $z <= 32460, "Jackson, FL",
  32421 <= $z and $z <= 32449, "Calhoun, FL",
  32422 <= $z and $z <= 32550, "Walton, FL",
  32425 <= $z and $z <= 32464, "Holmes, FL",
  32427 <= $z and $z <= 32463, "Washington, FL",
  32456 <= $z and $z <= 32465, "Gulf, FL",
  32501 <= $z and $z <= 32598, "Escambia, FL",
  32530 <= $z and $z <= 32583, "Santa Rosa, FL",
  32531 <= $z and $z <= 32588, "Okaloosa, FL",
  32601 <= $z and $z <= 32694, "Alachua, FL",
  32619 <= $z and $z <= 32693, "Gilchrist, FL",
  32621 <= $z and $z <= 34498, "Levy, FL",
  32628 <= $z and $z <= 32692, "Dixie, FL",
  32701 <= $z and $z <= 32799, "Seminole, FL",
  32703 <= $z and $z <= 34787, "Orange, FL",
  32754 <= $z and $z <= 32976, "Brevard, FL",
  32948 <= $z and $z <= 32978, "Indian River, FL",
  33001 <= $z and $z <= 33070, "Monroe, FL",
  33002 <= $z and $z <= 33299, "Miami-Dade, FL",
  33004 <= $z and $z <= 33443, "Broward, FL",
  33401 <= $z and $z <= 33499, "Palm Beach, FL",
  33440 <= $z and $z <= 33975, "Hendry, FL",
  33455 <= $z and $z <= 34997, "Martin, FL",
  33471 <= $z and $z <= 33944, "Glades, FL",
  33503 <= $z and $z <= 33697, "Hillsborough, FL",
  33523 <= $z and $z <= 34691, "Pasco, FL",
  33701 <= $z and $z <= 34698, "Pinellas, FL",
  33801 <= $z and $z <= 34759, "Polk, FL",
  33825 <= $z and $z <= 33960, "Highlands, FL",
  33834 <= $z and $z <= 33890, "Hardee, FL",
  33848 <= $z and $z <= 34773, "Osceola, FL",
  33901 <= $z and $z <= 34136, "Lee, FL",
  33927 <= $z and $z <= 33983, "Charlotte, FL",
  34002 <= $z and $z <= 34099, "undefined, AA",
  34101 <= $z and $z <= 34146, "Collier, FL",
  34201 <= $z and $z <= 34282, "Manatee, FL",
  34223 <= $z and $z <= 34295, "Sarasota, FL",
  34265 <= $z and $z <= 34269, "De Soto, FL",
  34423 <= $z and $z <= 34487, "Citrus, FL",
  34601 <= $z and $z <= 34661, "Hernando, FL",
  34945 <= $z and $z <= 34988, "Saint Lucie, FL",
  34972 <= $z and $z <= 34974, "Okeechobee, FL",
  35004 <= $z and $z <= 35987, "Saint Clair, AL",
  35005 <= $z and $z <= 35299, "Jefferson, AL",
  35007 <= $z and $z <= 35242, "Shelby, AL",
  35010 <= $z and $z <= 36861, "Tallapoosa, AL",
  35013 <= $z and $z <= 35133, "Blount, AL",
  35014 <= $z and $z <= 36268, "Talladega, AL",
  35016 <= $z and $z <= 35980, "Marshall, AL",
  35019 <= $z and $z <= 35179, "Cullman, AL",
  35034 <= $z and $z <= 36793, "Bibb, AL",
  35038 <= $z and $z <= 35587, "Walker, AL",
  35045 <= $z and $z <= 36790, "Chilton, AL",
  35072 <= $z and $z <= 36026, "Coosa, AL",
  35082 <= $z and $z <= 36267, "Clay, AL",
  35401 <= $z and $z <= 35490, "Tuscaloosa, AL",
  35441 <= $z and $z <= 36776, "Hale, AL",
  35442 <= $z and $z <= 35481, "Pickens, AL",
  35443 <= $z and $z <= 36740, "Greene, AL",
  35459 <= $z and $z <= 36925, "Sumter, AL",
  35540 <= $z and $z <= 35577, "Winston, AL",
  35542 <= $z and $z <= 35559, "Fayette, AL",
  35543 <= $z and $z <= 35594, "Marion, AL",
  35544 <= $z and $z <= 35592, "Lamar, AL",
  35571 <= $z and $z <= 35654, "Franklin, AL",
  35601 <= $z and $z <= 35775, "Morgan, AL",
  35610 <= $z and $z <= 35677, "Lauderdale, AL",
  35611 <= $z and $z <= 35742, "Limestone, AL",
  35616 <= $z and $z <= 35674, "Colbert, AL",
  35618 <= $z and $z <= 35672, "Lawrence, AL",
  35740 <= $z and $z <= 35979, "Jackson, AL",
  35741 <= $z and $z <= 35899, "Madison, AL",
  35901 <= $z and $z <= 35990, "Etowah, AL",
  35959 <= $z and $z <= 36275, "Cherokee, AL",
  35961 <= $z and $z <= 35989, "De Kalb, AL",
  36003 <= $z and $z <= 36749, "Autauga, AL",
  36005 <= $z and $z <= 36082, "Pike, AL",
  36009 <= $z and $z <= 36071, "Crenshaw, AL",
  36013 <= $z and $z <= 36191, "Montgomery, AL",
  36015 <= $z and $z <= 36456, "Butler, AL",
  36016 <= $z and $z <= 36072, "Barbour, AL",
  36020 <= $z and $z <= 36093, "Elmore, AL",
  36029 <= $z and $z <= 36089, "Bullock, AL",
  36031 <= $z and $z <= 36866, "Macon, AL",
  36032 <= $z and $z <= 36752, "Lowndes, AL",
  36038 <= $z and $z <= 36483, "Covington, AL",
  36201 <= $z and $z <= 36279, "Calhoun, AL",
  36261 <= $z and $z <= 36273, "Cleburne, AL",
  36263 <= $z and $z <= 36280, "Randolph, AL",
  36301 <= $z and $z <= 36376, "Houston, AL",
  36310 <= $z and $z <= 36373, "Henry, AL",
  36311 <= $z and $z <= 36374, "Dale, AL",
  36313 <= $z and $z <= 36477, "Geneva, AL",
  36323 <= $z and $z <= 36453, "Coffee, AL",
  36401 <= $z and $z <= 36475, "Conecuh, AL",
  36425 <= $z and $z <= 36481, "Monroe, AL",
  36426 <= $z and $z <= 36543, "Escambia, AL",
  36435 <= $z and $z <= 36778, "Wilcox, AL",
  36436 <= $z and $z <= 36784, "Clarke, AL",
  36505 <= $z and $z <= 36695, "Mobile, AL",
  36507 <= $z and $z <= 36580, "Baldwin, AL",
  36513 <= $z and $z <= 36585, "Washington, AL",
  36701 <= $z and $z <= 36785, "Dallas, AL",
  36732 <= $z and $z <= 36783, "Marengo, AL",
  36756 <= $z and $z <= 36786, "Perry, AL",
  36801 <= $z and $z <= 36879, "Lee, AL",
  36851 <= $z and $z <= 36875, "Russell, AL",
  36852 <= $z and $z <= 36863, "Chambers, AL",
  36904 <= $z and $z <= 36922, "Choctaw, AL",
  37010 <= $z and $z <= 37188, "Robertson, TN",
  37011 <= $z and $z <= 37250, "Davidson, TN",
  37012 <= $z and $z <= 37166, "Dekalb, TN",
  37014 <= $z and $z <= 37179, "Williamson, TN",
  37015 <= $z and $z <= 37146, "Cheatham, TN",
  37016 <= $z and $z <= 37190, "Cannon, TN",
  37018 <= $z and $z <= 37389, "Coffee, TN",
  37019 <= $z and $z <= 37091, "Marshall, TN",
  37020 <= $z and $z <= 37360, "Bedford, TN",
  37022 <= $z and $z <= 37186, "Sumner, TN",
  37023 <= $z and $z <= 37079, "Stewart, TN",
  37025 <= $z and $z <= 38476, "Hickman, TN",
  37029 <= $z and $z <= 37187, "Dickson, TN",
  37030 <= $z and $z <= 38569, "Smith, TN",
  37037 <= $z and $z <= 37167, "Rutherford, TN",
  37040 <= $z and $z <= 37191, "Montgomery, TN",
  37061 <= $z and $z <= 37178, "Houston, TN",
  37071 <= $z and $z <= 37184, "Wilson, TN",
  37074 <= $z and $z <= 37074, "Trousdale, TN",
  37078 <= $z and $z <= 37185, "Humphreys, TN",
  37083 <= $z and $z <= 37150, "Macon, TN",
  37096 <= $z and $z <= 37097, "Perry, TN",
  37110 <= $z and $z <= 38581, "Warren, TN",
  37144 <= $z and $z <= 38488, "Lincoln, TN",
  37174 <= $z and $z <= 38487, "Maury, TN",
  37301 <= $z and $z <= 37387, "Grundy, TN",
  37302 <= $z and $z <= 37450, "Hamilton, TN",
  37303 <= $z and $z <= 37826, "Mcminn, TN",
  37306 <= $z and $z <= 37398, "Franklin, TN",
  37307 <= $z and $z <= 37391, "Polk, TN",
  37310 <= $z and $z <= 37364, "Bradley, TN",
  37314 <= $z and $z <= 37885, "Monroe, TN",
  37321 <= $z and $z <= 37395, "Rhea, TN",
  37322 <= $z and $z <= 37880, "Meigs, TN",
  37327 <= $z and $z <= 37397, "Sequatchie, TN",
  37340 <= $z and $z <= 37396, "Marion, TN",
  37352 <= $z and $z <= 37352, "Moore, TN",
  37367 <= $z and $z <= 37367, "Bledsoe, TN",
  37501 <= $z and $z <= 38197, "Shelby, TN",
  37601 <= $z and $z <= 37690, "Washington, TN",
  37616 <= $z and $z <= 37818, "Greene, TN",
  37617 <= $z and $z <= 37699, "Sullivan, TN",
  37640 <= $z and $z <= 37691, "Johnson, TN",
  37642 <= $z and $z <= 37873, "Hawkins, TN",
  37643 <= $z and $z <= 37694, "Carter, TN",
  37650 <= $z and $z <= 37692, "Unicoi, TN",
  37701 <= $z and $z <= 37886, "Blount, TN",
  37705 <= $z and $z <= 37831, "Anderson, TN",
  37707 <= $z and $z <= 37879, "Claiborne, TN",
  37708 <= $z and $z <= 37888, "Grainger, TN",
  37713 <= $z and $z <= 37843, "Cocke, TN",
  37714 <= $z and $z <= 37847, "Campbell, TN",
  37719 <= $z and $z <= 37887, "Morgan, TN",
  37721 <= $z and $z <= 37998, "Knox, TN",
  37723 <= $z and $z <= 38578, "Cumberland, TN",
  37725 <= $z and $z <= 37890, "Jefferson, TN",
  37732 <= $z and $z <= 37892, "Scott, TN",
  37738 <= $z and $z <= 37876, "Sevier, TN",
  37742 <= $z and $z <= 37846, "Loudon, TN",
  37748 <= $z and $z <= 37854, "Roane, TN",
  37765 <= $z and $z <= 37869, "Hancock, TN",
  37778 <= $z and $z <= 37891, "Hamblen, TN",
  37779 <= $z and $z <= 37866, "Union, TN",
  38001 <= $z and $z <= 38337, "Crockett, TN",
  38002 <= $z and $z <= 38076, "Fayette, TN",
  38004 <= $z and $z <= 38071, "Tipton, TN",
  38007 <= $z and $z <= 38259, "Dyer, TN",
  38008 <= $z and $z <= 38381, "Hardeman, TN",
  38012 <= $z and $z <= 38069, "Haywood, TN",
  38037 <= $z and $z <= 38063, "Lauderdale, TN",
  38077 <= $z and $z <= 38080, "Lake, TN",
  38201 <= $z and $z <= 38390, "Carroll, TN",
  38221 <= $z and $z <= 38341, "Benton, TN",
  38222 <= $z and $z <= 38256, "Henry, TN",
  38225 <= $z and $z <= 38255, "Weakley, TN",
  38232 <= $z and $z <= 38281, "Obion, TN",
  38233 <= $z and $z <= 38389, "Gibson, TN",
  38301 <= $z and $z <= 38392, "Madison, TN",
  38310 <= $z and $z <= 38393, "Mcnairy, TN",
  38311 <= $z and $z <= 38380, "Decatur, TN",
  38326 <= $z and $z <= 3
(Edited)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
Here is my processing script in case you want to pursue this:

//"zip_code","latitude","longitude","city","state","county"
var data = [
  ["00501",40.922326,-72.637078,"Holtsville","NY","Suffolk"],
  ["00544",40.922326,-72.637078,"Holtsville","NY","Suffolk"],
  ...
  ["99929",56.449893,"-132.364407","Wrangell","AK","Wrangell Petersburg"],
  ["99950",55.542007,"-131.432682","Ketchikan","AK","Ketchikan Gateway"]
];
var result = _.chain(data)
  .groupBy(function(item) {
    return item[5] + ", " + item[4];
  })
  .map(function(data, county) {
     var minzip = _.chain(data).pluck(0).map(function(zip) {return parseInt(zip, 10)}).min().value();
     var maxzip = _.chain(data).pluck(0).map(function(zip) {return parseInt(zip, 10)}).max().value();
     return `  ${minzip} <= $z and $z <= ${maxzip}, "${county}",`;
  })
  .value();
  var formula = `
var Number z = ToNumber([ZipCode]);
If(
${result.join("\n")}
)
`;
console.log(formula);