What location column names does OpenHeatMap understand?
can_constituency_code
The Federal code for a Canadian parliamentary constituency
Defines an area
Accepted values:
59021, 59035, 35042, 48011, 59032, 61001, 35043, 35046, 11001, 48016,
... (see all)
can_constituency_name
The name of a Canadian parliamentary constituency
Converted into
can_constituency_codeAccepted values:
port moody-westwood-port coquitlam, port moody westwood port coquitlam, victoria, london-fanshawe, london fanshawe, edmonton-mill woods-beaumont, edmonton mill woods beaumont, vancouver kingsway, western arctic, london north centre,
... (see all)Example CSV file:
Canadian constituencies
can_province
The name or postal code of a Canadian province or territory
Converted into
can_province_codeAccepted values:
alberta, alberta province, ab, saskatchewan, saskatchewan province, sk, manitoba, manitoba province, mb, newfoundland & labrador,
... (see all)Example CSV file:
Province populations
can_province_code
The four-character code for a Canadian province or territory
Defines an area
Accepted values:
CA01, CA11, CA03, CA05, CA09, CA07, CA06, CA13, CA08, CA04,
... (see all)
city_code
The five-digit number identifying a US city within a particular state, as defined in
FIPS 6-4
Defines an area
Accepted values:
00065, 00100, 00113, 00116, 00124, 00125, 00135, 00142, 00148, 00155,
... (see all)
country
The English short name of a country, as defined by
ISO 3166
Converted into
country_codeAccepted values:
afghanistan, albania, algeria, america, american samoa, andorra, angola, anguilla, antarctica, antigua and barbuda,
... (see all)Example CSV file:
Worst places in the world to be a woman
country_code
The three-letter code identifying a country, as defined by
ISO 3166
Defines an area
Accepted values:
ABW, AFG, AGO, AIA, ALA, ALB, AND, ANT, ARE, ARG,
... (see all)
county_code
The three-digit number identifying a US county within a particular state, as defined in
FIPS 6-4
Defines an area
Accepted values:
001, 003, 005, 006, 007, 009, 011, 012, 013, 015,
... (see all)Example CSV file:
Unemployment rate by county
county_without_state
The name of a US county, eg Ventura County, as defined in
FIPS 6-4, without a state at the end
Converted into
county_code
district_code
The two-digit number identifying a US congressional district within a particular state, as defined in
FIPS 6-4
Defines an area
Accepted values: 00 to 60
Example CSV file:
At-risk congressional seats
dk_county
The name of a Danish Kommune
Converted into
dk_county_codeAccepted values:
albertslund kommune, allerod kommune, assens kommune, ballerup kommune, billund kommune, bornholm kommune, brondby kommune, bronderslev kommune, christianso horer under forsvarsministeriet, dragor kommune,
... (see all)Example CSV file:
Danish Kommunes
dk_county_code
A numerical code for a Danish Kommune
Defines an area
Accepted values:
2, 3, 4, 5, 6, 7, 8, 9, 10, 11,
... (see all)
fips_code
A five digit number representing a US county, in the form SSCCC where the first two digits represent a state, and the last three the county within that state
Converted into
state_code and
county_codeExample CSV file:
FIPS codes
hk_constituency
The name of a Hong Kong constituency
Converted into
hk_constituency_codeAccepted values:
中環, chung wan, 半山東, mid levels east, 衛城, castle road, 山頂, peak, 大學, university,
... (see all)Example CSV file:
Hong Kong districts
hk_constituency_code
A numerical code for a Hong Kong constituency
Defines an area
Accepted values:
0, 1, 2, 3, 4, 5, 6, 7, 8, 9,
... (see all)
hk_district
The name of a Hong Kong district
Converted into
hk_district_codeAccepted values:
中西區, central and western district, 灣仔區, wan chai district, 東區, eastern district, 南區, southern district, 油尖旺民, yau tsim mong district,
... (see all)Example CSV file:
Hong Kong districts
hk_district_code
A numerical code for a Hong Kong district
Defines an area
Accepted values:
0, 1, 2, 3, 4, 5, 6, 7, 8, 9,
... (see all)
ind_district
The name of an Indian district
Converted into
ind_district_codeAccepted values:
gilgit, kargil, ladakh, chilas, kupwara, baramula, srinagar, anantnag, doda, badgam,
... (see all)Example CSV file:
Indian district example
ind_district_code
A numerical code for an Indian district
Defines an area
Accepted values:
1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
... (see all)
ind_state
The name of an Indian state
Converted into
ind_state_codeAccepted values:
andaman and nicobar islands, andaman & nicobar islands, andhra pradesh, arunachal pradesh, assam, bihar, chandigarh, dadra and nagar haveli, dadra & nagar haveli, daman and diu,
... (see all)Example CSV file:
Indian state example
ind_state_code
A two-digit postal code for an Indian state
Defines an area
Accepted values:
AN, AP, AR, AS, BR, CH, DN, DD, DL, GA,
... (see all)
ip_address
The IP address of a machine, in the form XX.XX.XX.XX, to be converted by geolocation
Converted into
lat and
lonExample CSV file:
IP addresses
ire_constituency
The name of a Dáil Éireann (Irish parliament) constituency, based on the revisions for 2012
Converted into
ire_constituency_codeAccepted values:
cavan-monaghan, cavan monaghan, donegal north-east, donegal north east, north east donegal, donegal south-west, donegal south west, south west donegal, galway east, east galway,
... (see all)Example CSV file:
Constituency example
ire_constituency_2007
The name of a Dáil Éireann (Irish parliament) constituency, based on the revisions for 2007
Converted into
ire_constituency_2007_codeAccepted values:
cavan-monaghan, cavan monaghan, donegal north-east, donegal north east, north east donegal, donegal south-west, donegal south west, south west donegal, galway east, east galway,
... (see all)Example CSV file:
Constituency example
ire_constituency_2007_code
A two-digit code for a Dáil Éireann (Irish parliament) 2007 constituency, based on their order in an alphabetical listing
Defines an area
Accepted values:
01, 08, 09, 22, 23, 33, 36, 37, 03, 04,
... (see all)
ire_constituency_code
A two-digit code for a Dáil Éireann (Irish parliament) constituency, based on their order in an alphabetical listing
Defines an area
Accepted values:
00, 01, 02, 03, 04, 05, 06, 07, 08, 09,
... (see all)
ire_county
The name (in English) of an Irish county
Converted into
ire_county_codeAccepted values:
carlow, cavan, clare, cork, donegal, dublin, galway, kerry, kildare, kilkenny,
... (see all)Example CSV file:
Constituency example
ire_county_code
The short code for an Irish county
Defines an area
Accepted values:
CW, CN, CE, C, DL, D, G, KY, KE, KK,
... (see all)
lat aka latitude
Latitude
Defines a point
Accepted values: -90 to 90
Example CSV file:
Boulder Real Estate
lat_lon
A latitude, longitude pair in a single column
Converted into
lat and
lon
lon aka longitude, long, lng
Longitude
Defines a point
Accepted values: -180 to 180
Example CSV file:
Boulder Real Estate
lon_lat
A latitude, longitude pair in a single column
Converted into
lat and
lon
mex_muni
The name of a Mexican municipality
Converted into
mex_muni_codeAccepted values:
tlacotalpan, veracruz de ignacio de la llave, tlacotalpan veracruz de ignacio de la llave, tlacolulan, veracruz de ignacio de la llave, tlacolulan veracruz de ignacio de la llave, tihuatlan, veracruz de ignacio de la llave, tihuatlan veracruz de ignacio de la llave, tierra blanca, veracruz de ignacio de la llave, tierra blanca veracruz de ignacio de la llave, tezonapa, veracruz de ignacio de la llave, tezonapa veracruz de ignacio de la llave,
... (see all)Example CSV file:
Mexican Municipalities
mex_muni_code
A numerical code for a Mexican municipality
Defines an area
Accepted values:
30178, 30177, 30175, 30174, 30173, 30172, 30171, 30170, 30169, 30168,
... (see all)
mex_state
The name or abbreviated code of a Mexican state
Converted into
mex_state_codeAccepted values:
aguascalientes, agu, baja california, bcn, baja california sur, bcs, campeche, cam, chiapas, chp,
... (see all)
mex_state_code
The four-character code for a Mexican state
Defines an area
Accepted values:
MX01, MX02, MX03, MX04, MX05, MX06, MX07, MX08, MX09, MX10,
... (see all)Example CSV file:
State populations
nzl_electoral_district
The name of a New Zealand electoral district (2007 revision)
Converted into
nzl_electoral_district_codeAccepted values:
auckland central, bay of plenty, botany, christchurch central, christchurch east, east christchurch, clutha-southland, clutha southland, coromandel, dunedin north,
... (see all)Example CSV file:
Electoral district example
nzl_electoral_district_code
A numerical code for a New Zealand electoral district
Defines an area
Accepted values:
001, 002, 003, 004, 005, 006, 007, 008, 009, 010,
... (see all)
province_code
A four-character code identifying a state or province. All of the areas must be within the same country
Defines an area
Accepted values:
AF02, AF11, AF05, AF30, AF07, AF31, AF09, AF33, AF06, AF10,
... (see all)
state aka province
The English name or abbreviation identifying a state or province, optionally followed by the country name. All the states or provinces must be within the same country
Converted into
province_codeAccepted values:
badghes, badghes, afghanistan, badghes afghanistan, badghisat, badghisat, afghanistan, badghisat afghanistan, badgis, badgis, afghanistan, badgis afghanistan, badghis,
... (see all)Example CSV file:
US Presidential elections since 1868, 2008 election results
state_code
The two-digit number identifying a US state, as defined in
FIPS 5-2
Defines an area
Accepted values:
02, 01, 05, 04, 06, 08, 09, 10, 11, 12,
... (see all)
uk_constituency_code
The three-character code for a UK Westminster parliamentary constituency, as defined by the Office of National Statistics
Defines an area
Accepted values:
A01, A02, A03, A04, A05, A06, A07, A08, A09, A10,
... (see all)
uk_county
The name of a UK county
Converted into
uk_district_codeAccepted values:
buckinghamshire county, buckinghamshire, cambridgeshire county, cambridgeshire, cumbria county, cumbria, derbyshire county, derbyshire, devon county, devon,
... (see all)Example CSV file:
Counties
uk_district_code
The OS code four-character code for a UK council district or borough
Defines an area
Accepted values:
11UB, 11UC, 11UE, 11UF, 12UB, 12UC, 12UD, 12UE, 12UG, 16UB,
... (see all)
uk_region
The name of a British region
Converted into
uk_region_codeAccepted values:
east midlands, midlands east, eastern, eastern england, london, north east, north east england, north west, north west england, scotland,
... (see all)Example CSV file:
UK region example
uk_region_code
A three-character code for a British region, as defined in NUTS1
Defines an area
Accepted values:
UKF, UKH, UKI, UKC, UKD, UKM, UKJ, UKK, UKL, UKG,
... (see all)
ven_municipalities_code
The code for a Venezualan municipality
Defines an area
Accepted values:
0, 1, 2, 3, 4, 5, 6, 7, 8, 9,
... (see all)
ven_municipalities_name
The name of a municipality in Venezuala
Converted into
ven_municipalities_codeAccepted values:
atures, atabapo, maroa, rio negro, autana, manapiare, alto orinoco, anaco, aragua, bruzual,
... (see all)Example CSV file:
Venezualan municipalities
zip_code_area
The five-digit number identifying an area of the US for postal purposes
Defines an area
Accepted values:
01001, 01002, 01005, 01007, 01008, 01010, 01011, 01012, 01013, 01020,
... (see all)