Reference lists and lookup tables
Code lists you join other data to: ZIP codes to counties, county FIPS codes, country codes, airport codes and time zones. Each list is a free CSV, Excel and JSON file with a data dictionary, from a source with an open licence that we checked.
ZIP code to county
40,977 ZIP codes with county and FIPS, one file per state
referenceCounty FIPS codes
3,144 counties and county equivalents
referenceCountry codes
ISO codes, calling codes, currencies, domains, postal formats, languages
referenceAirport codes
8,799 IATA airports with ICAO code and coordinates
referenceTime zones
418 IANA zones with 2026 UTC offsets
Which list do you need?
- You have addresses and need counties. Start with the ZIP code list: join on the five-digit ZIP and you get the county name and its FIPS code.
- You have county data from different sources. Join on the five-digit FIPS code rather than the county name; names repeat across states (this list has 31 counties and parishes named Washington) and are spelled in different ways.
- You need to label countries. The ISO alpha-3 code is what the World Bank, IMF and UN use; alpha-2 is what web forms, domains and most software use. The country code list has both, side by side.
- You work with flights or travel. The airport list gives IATA codes, as printed on tickets, and ICAO codes, as used in flight data.
- You store times from different places. Keep the IANA zone name with each time; the time zone list shows what each name means in 2026.
Every file keeps codes as text, so leading zeros survive, and every page has a data dictionary that explains each column.
Sources and licences
- GeoNames postal codes, admin codes and country info: CC BY 4.0 (credit GeoNames).
- Natural Earth admin-2 counties, version 5.1.1: public domain.
- OurAirports: public domain.
- IANA tz database: public domain.
All were retrieved on 19 November 2026 and are shown as published, apart from the columns we computed, which each page names. See sources and licences. Looking for test files rather than lists? See sample files.