EAN have rolled out new and improved geography definitions.

The new dataset will extend the existing 195,000+ geography definitions to over 350,000+ definitions, including points of interest, train & metro stations, better airport resolution and more detailed geography in key areas.

The new dataset will represent a more realistic representation of how the world works. Definitions are more granular and include many thousands of manually drawn polygons & will ensure a stronger alignment with the other Expedia brands.


Below data & file locations point to the new geography dataset in a /new folder. You will be required to change the path to the files to ensure your systems pick up & leverage the new geo definitions.

We recommend you download files & analyse the new dataset in preparation for this change. Once you're ready to make the change, you will be required to change the path to the images to include /new/ to ensure your systems point to the new location.


The files in the default folder are no longer maintained. To ensure you continue to have access to newly added supply further enhancements to the dataset, refer to the updated RegionEANHotelIDMapping file. This file provides the most accurate and up-to-date region information for each hotel. We strongly recommend you use this file for all mapping & matching purposes.

Relational Data Files

The RegionID field in each of the geography files we create is used to link the files together, where applicable. The RegionID for the AirportcoordinatesList file is actually called AirportID, and the CountryList file lists the field as CountryID.

ParentRegionList and RegionList Multi-Language are two of the main files used. The ParentRegionList is used to map a given region to the next larger or next smaller region. For instance, the RegionID of Springfield, MO, USA would have a ParentRegionID that points to the state Missouri, USA. Missouri, USA would have a ParentRegionID that points to the country USA and so forth. ParentRegionIDs can also be determined in descending region size. For example, the RegionID of Springfield, MO, USA would be the ParentRegionID of Hammons Field Baseball Stadium.

  • ParentRegionList – Master list of all regions and the hierarchical relationship between regions.
  • RegionList Multi-Language – Localized names of the regions in the ParentRegionList file.
  • CountryList – List of countries and their country code.
  • CountryList Multi-Language – Localized names of the countries in the CountryList file.
  • CityCoordinatesList – List of cities and their bounding coordinates.
  • NeighborhoodCoordinatesList – List of neighborhoods and their bounding coordinates.
  • PointsOfInterestCoordinates – List of point of interest locations and their latitude/longitude coordinates.
  • AirportCoordinatesList – List of airport codes, their latitude/longitude coordinates, and the region ID of the nearest main city.
  • RegionCenterCoordinates – Latitude and longitude of the centroid of multi-city, city and neighborhood regions.
  • RegionEANHotelIDMapping – Mapping between of EANHotelID and RegionID. A region is typically mapped to a city, but when the exact city is not found it may be a larger metropolitan area.

Region Types Included in Geography Files

Contained Region Types

Geography File

Continent Country Province (State) Multi-Region (within a country) High Level Region Multi-City (Vicinity) City Neighborhood Point of Interest Train Station Metro Station Airport
ParentRegionList  
RegionList Multi-Language  
CountryList                      
CountryList Multi-Language                      
CityCoordinatesList                      
NeighborhoodCoordinatesList                      
PointsOfInterestCoordinates                      
AirportCoordinatesList                      
RegionCenterCoordinates                
RegionEANHotelIDMapping          

ParentRegionList

File Name: ParentRegionList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/ParentRegionList.zip

This file is the main list of region data. It can be used to hierarchically search regions from city all the way up to the continent using the ParentRegion data.

Attribute Name Base Data Type (Length)
RegionID 64-bit integer
RegionType nvarchar(50)
RelativeSignificance (no longer applicable; returns blank space) nvarchar(3)
SubClass nvarchar(50)
RegionName nvarchar(255)
RegionNameLong nvarchar(510)
ParentRegionID 64-bit integer
ParentRegionType nvarchar(50)
ParentRegionName nvarchar(255)
ParentRegionNameLong nvarchar(510)

RegionList Multi-Language

File Name: RegionList_xx_XX.txt
Zip File Name:https://www.ian.com/affiliatecenter/include/V2/new/RegionList_xx_XX.zip

This file holds all language translations for each region including English language.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
RegionID 64-bit integer
LanguageCode nvarchar(5)
RegionName nvarchar(255)
RegionNameLong nvarchar(510)

CountryList

File Name: CountryList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/CountryList.zip

This file contains a list of valid countries around the world. The CountryID is a link back to the region parent table. The ContinentID is also a link to the continent name in the region parent table. CountryCode is the two character designation for the country. Transliteration is the "clean" version of the country name.

Attribute Name Base Data Type (Length)
CountryID 64-bit integer
LanguageCode nvarchar(5)
CountryName nvarchar(256)
CountryCode nvarchar(2)
Transliteration nvarchar(256)
ContinentID 64-bit integer

CountryList Multi-Language

File Name: CountryList_xx_XX.txt
Zip File Name:https://www.ian.com/affiliatecenter/include/V2/new/CountryList_xx_XX.zip

This file holds all non-English language translations for the records located in the CountryList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
CountryID 64-bit integer
LanguageCode nvarchar(5)
CountryName nvarchar(256)

CityCoordinatesList

File Name: CityCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/CityCoordinatesList.zip

This file contains a list of cities and their matching RegionID. The Coordinates field is a colon delimited list of Latitude;Longitude values.

Attribute Name Base Data Type (Length)
RegionID 64-bit integer
RegionName nvarchar(255)
Coordinates varchar(max)

NeighborhoodCoordinatesList

File Name: NeighborhoodCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/NeighborhoodCoordinatesList.zip

This file contains a list of neighborhood and their matching RegionID. The Coordinates field is a colon delimited list of Latitude;Longitude values.

Attribute Name Base Data Type (Length)
RegionID 64-bit integer
RegionName nvarchar(255)
Coordinates varchar(max)

PointsOfInterestCoordinatesList

File Name: PointsOfInterestCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/PointsOfInterestCoordinatesList.zip

This file is a listing of all points of interest by latitude and longitude. The SubClassification shows what type of POI it is.

Attribute Name Base Data Type (Length)
RegionID 64-bit integer
RegionName nvarchar(255)
RegionNameLong nvarchar(510)
Latitude numeric(9,6)
Longitude numeric(9,6)
SubClassification nvarchar(20)

AirportCoordinatesList

File Name: AirportCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/AirportCoordinatesList.zip

This file contains a list of airports and their matching RegionID (MainCityID). AirportCode is the three letter airport abbreviation. Latitude and Longitude show the geographic coordinates of the airport. MainCityID is the RegionID of the major city the airport serves.

Attribute Name Base Data Type (Length)
AirportID 64-bit integer
AirportCode nvarchar(3)
AirportName nvarchar(70)
Latitude numeric(9,6)
Longitude numeric(9,6)
MainCityID 64-bit integer
CountryCode nvarchar(2)

RegionCenterCoordinatesList

File Name: RegionCenterCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/RegionCenterCoordinatesList.zip

This file lists the center point of high level regions, multi-city, city and neighborhood regions.

Attribute Name Base Data Type (Length)
RegionID 64-bit integer
RegionName nvarchar(255)
CenterLatitude numeric(9,6)
CenterLongitude numeric(9,6)

RegionEANHotelIDMapping

File Name: RegionEANHotelIDMapping.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/RegionEANHotelIDMapping.zip

This file links EAN properties to province/state, high level region, multi-city, city, neighborhood, point of interest and select country regions by EANHotelID.

Attribute Name Base Data Type (Length)
RegionID 64-bit integer
EANHotelID int