Table structure and fields details for the weatherCodes database

cities table

This is the main table, which contains the city-level records (cities, towns, villages and other populated places).
fieldfield descriptiondata typeStandard
weathercodeWeather station codetext (max. 8 characters)
cc1FIPS country code
A 2-character code uniquely identifying a geopolitical entity (countries, dependencies and areas of special sovereignty).
text (max. 2 characters)
adm1acFirst-level administrative divisiontext (max. 2 characters)
fullnameFull name, including diacritics and special characters
Diacritics are symbols situated on top or below characters, such as accents.
text (max. 255 characters)

states table

About 92% of the cities are currently classified in their respective states or provinces, including 100% of the United States’ records.
fieldfield descriptiondata typeStandard
cc1FIPS country code
A 2-character code uniquely identifying a geopolitical entity (countries, dependencies and areas of special sovereignty).
text (max. 2 characters)
adm1acFirst-level administrative divisiontext (max. 2 characters)
fullnameFull name, including diacritics and special characters
Diacritics are symbols situated on top or below characters, such as accents.
text (max. 200 characters)

countries table

Contains the country names (in English) and their codes.
fieldfield descriptiondata typeStandard
CC1FIPS country code
A 2-character code uniquely identifying a geopolitical entity (countries, dependencies and areas of special sovereignty).
text (max. 2 characters)
FULLNAMEFull name, including diacritics and special characters
Diacritics are symbols situated on top or below characters, such as accents.
text (max. 255 characters)
REGION_IDRegion numeric code
A 3-digit code uniquely identifying a region, which allows to link the country to the corresponding sub-region, region, and continent.
text (max. 3 characters)
COMMENTNotes and commentstext (max. 255 characters)

regions table

Contains the names and codes of the continents, regions and subregions.
fieldfield descriptiondata typeStandard
REGION_IDRegion numeric code
A 3-digit code uniquely identifying a region, which allows to link the country to the corresponding sub-region, region, and continent.
text (max. 3 characters)
REGION_PARENTParent region
A 3-digit code uniquely identifying the parent record of a region.
text (max. 3 characters)
REGION_NAMEName of the continent or regiontext (max. 128 characters)

This information applies only to the data files available since the last update of the weatherCodes database. The content of older files might differ.