Lodgingeo Global hotels database

Hotel Data Dictionary

Every column of the free sample, with its field group, what it means and an example value, followed by the full dataset field reference. Each column has its own anchor, for example #hotel_rates_by_site, so you can link straight to it.

Sheets in the sample

Sheets of the 2026-10 sample workbook
SheetRowsColumnsContent
Hotels250207One row per hotel: match columns, then every fact column.
Column guide763Definitions: file, column, meaning.
Hotel changes1,91512Monthly changes 2025-02 to 2026-10.
Category counts201,1586Open places within 500 m, 1 km and 3 km of each hotel, per category.
Buildings21514Building footprint per hotel: ID, name, source, area, grade, score, distance, OSM ID, polygon WKT.

Sample columns

Columns are listed in file order. Patterned names such as nearest_<service> stand for a family of columns, one per service, group or radius.

Columns of the sample workbook
ColumnSheet · groupMeaningExampleIn sample
product_idHotels · Match & IDsdelivered file only✓
hotel_nameHotels · Match & IDsdelivered file only✓
cityHotels · Match & IDsdelivered file only✓
countryHotels · Match & IDsdelivered file only✓
country_codeHotels · Match & IDsISO 3166-1 alpha-2 country code.✓
ld_idHotels · Match & IDsLodgingeo place ID; stable across monthly releases.✓
ld_nameHotels · Match & IDsName of the matched Lodgingeo place.✓
ld_name_altHotels · Match & IDsAlternative name of the matched place.✓
ld_cityHotels · Match & IDsCity of the matched place.✓
ld_addressHotels · Match & IDsAddress of the matched place.✓
ld_categoryHotels · Match & IDsCategory of the matched place.✓
name_scoreHotels · Match & IDsName similarity between your record and the match, 0–100.✓
city_scoreHotels · Match & IDsCity similarity between your record and the match, 0–100.✓
confidenceHotels · Match & IDsMatch confidence: 70% name score, 30% city score, plus a small bonus for places typed as hotels.✓
match_tierHotels · Match & IDshigh, medium, low or no_match, derived from confidence.✓
second_candidate_nameHotels · Match & IDsdelivered file only✓
second_candidate_confidenceHotels · Match & IDsdelivered file only✓
closest_candidate_nameHotels · Match & IDsdelivered file only✓
closest_candidate_confidenceHotels · Match & IDsdelivered file only✓
flagsHotels · Match & IDsNotes on the match, such as a close second candidate.✓
hotel_ld_idHotels · Match & IDsLodgingeo ID of the hotel used for all fact columns.✓
latitudeHotels · Location & addressLatitude, WGS84 decimal degrees.✓
longitudeHotels · Location & addressLongitude, WGS84 decimal degrees.✓
nameHotels · Location & addressProperty name.✓
name_altHotels · Location & addressAlternative or local-language name.✓
parent_nameHotels · Location & addressParent place or property group, where listed.✓
street_addressHotels · Location & addressStreet and number.✓
neighborhoodHotels · Location & addressNeighbourhood or district.✓
stateHotels · Location & addressState, province or region.✓
postal_codeHotels · Location & addressPostal code.✓
country_nameHotels · Location & addressCountry name.✓
formatted_addressHotels · Location & addressFull address on one line.✓
timezoneHotels · Location & addressIANA time zone, e.g. Europe/Madrid.✓
phoneHotels · Contacts & identityPhone number in international format.✓
websiteHotels · Contacts & identityWebsite URL as published by the property.✓
domainHotels · Contacts & identityWebsite domain without protocol or path.✓
chain_from_websiteHotels · Contacts & identityChain or group detected from the website.✓
brandHotels · Contacts & identityHotel brand, where known.✓
wikipedia_urlHotels · Contacts & identityWikipedia article, where one exists.✓
categoryHotels · Hotel details & amenitiesPrimary category of the place.✓
categoriesHotels · Hotel details & amenitiesAll categories of the place.✓
statusHotels · Hotel details & amenitiesOperating status in the latest release.✓
hotel_classHotels · Hotel details & amenitiesStar class (1–5), where listed.✓
ratingHotels · Hotel details & amenitiesAverage guest rating.✓
review_countHotels · Hotel details & amenitiesNumber of guest reviews.✓
rating_distributionHotels · Hotel details & amenitiesCount of reviews per star level.✓
price_levelHotels · Hotel details & amenitiesRelative price level, where listed.✓
check_in_timeHotels · Hotel details & amenitiesCheck-in time.✓
check_out_timeHotels · Hotel details & amenitiesCheck-out time.✓
amenitiesHotels · Hotel details & amenitiesAmenities listed as available.✓
amenities_unavailableHotels · Hotel details & amenitiesAmenities listed as not available.✓
attributesHotels · Hotel details & amenitiesOther listed attributes.✓
languagesHotels · Hotel details & amenitiesLanguages spoken, where listed.✓
floor_levelHotels · Hotel details & amenitiesFloor level of the place inside its building, where known.✓
area_typeHotels · Hotel details & amenitiesType of area around the place, where known.✓
hotel_rate_latestHotels · Prices & booking sitesHeadline nightly rate in the latest release.✓
hotel_rates_by_siteHotels · Prices & booking sitesNightly offer per booking site in the latest release.✓
booking_sites_latestHotels · Prices & booking sitesBooking sites offering the hotel in the latest release.✓
booking_otas_latestHotels · Prices & booking sitesOnline travel agencies among those sites.✓
booking_metasearch_latestHotels · Prices & booking sitesMetasearch sites among those sites.✓
booking_other_sites_latestHotels · Prices & booking sitesOther booking sites among those sites.✓
lowest_offer_latestHotels · Prices & booking sitesLowest nightly offer across sites in the latest release.✓
direct_offer_latestHotels · Prices & booking sitesOffer on the hotel's own website, where shown.✓
direct_vs_lowest_ota_pctHotels · Prices & booking sitesDirect offer compared with the lowest OTA offer, in percent (positive: direct is higher).✓
booking_sites_months_seenHotels · Prices & booking sitesMonths in which each booking site listed the hotel.✓
rate_history_by_monthHotels · Prices & booking sitesHeadline nightly rate per monthly release.✓
hotel_avg_rate_2025Hotels · Prices & booking sitesAverage of the monthly rates captured in 2025.✓
hotel_avg_rate_2026Hotels · Prices & booking sitesAverage of the monthly rates captured in 2026.✓
places_inside_buildingHotels · Building polygonNumber of other places located inside the same building.✓
contained_places_categoriesHotels · Building polygonCategories of the places inside the building.✓
building_idHotels · Building polygonBuilding identifier from the source dataset.✓
building_nameHotels · Building polygonBuilding name, where the source has one.✓
polygon_sourceHotels · Building polygonHow the footprint was matched: overture_contains, osm_name or overture_nearest.✓
building_area_m2Hotels · Building polygonFootprint area in square metres.✓
building_polygon_wktHotels · Building polygonBuilding footprint as a WKT MULTIPOLYGON in WGS84 (EPSG:4326).✓
building_match_gradeHotels · Building polygonMatch confidence grade, A (highest) to E (lowest).✓
building_match_scoreHotels · Building polygonNumeric match score behind the grade.✓
building_dist_mHotels · Building polygonDistance from the hotel point to the building, in metres (0 when inside).✓
building_osm_idHotels · Building polygonOpenStreetMap ID of the building, where matched by name.✓
building_osm_nameHotels · Building polygonOpenStreetMap name of the building.✓
oldest_seen_dateHotels · History & changesEarliest date the place is known to have been listed.✓
first_seen_monthHotels · History & changesFirst monthly release containing the hotel.✓
last_seen_monthHotels · History & changesLatest monthly release containing the hotel.✓
last_confirmed_monthHotels · History & changesLatest release in which the hotel was confirmed operating.✓
closed_monthHotels · History & changesRelease in which the hotel was first marked closed.✓
continuity_monthsHotels · History & changesNumber of monthly releases containing the hotel.✓
lifecycle_stageHotels · History & changesLifecycle stage derived from the monthly history.✓
rating_firstHotels · History & changesRating in the first release.✓
rating_latestHotels · History & changesRating in the latest release.✓
rating_trend_12mHotels · History & changesChange in rating over the last 12 months.✓
reviews_gained_last_monthHotels · History & changesReviews added since the previous release.✓
reviews_gained_all_timeHotels · History & changesReviews added since the hotel was first seen.✓
review_velocity_3mHotels · History & changesAverage reviews gained per month over the last 3 months.✓
status_historyHotels · History & changesOperating status by month.✓
name_historyHotels · History & changesPrevious names with the month they changed.✓
facts_change_timelineHotels · History & changesMonth-by-month list of changed facts.✓
facts_changes_totalHotels · History & changesTotal number of fact changes since the first release.✓
hotel_rating_change_2025Hotels · History & changesRating change during 2025.✓
hotel_reviews_gained_2025Hotels · History & changesReviews gained during 2025.✓
hotel_facts_changes_2025Hotels · History & changesFact changes during 2025.✓
hotel_rating_change_2026Hotels · History & changesRating change during 2026.✓
hotel_reviews_gained_2026Hotels · History & changesReviews gained during 2026.✓
hotel_facts_changes_2026Hotels · History & changesFact changes during 2026.✓
amenities_addedHotels · History & changesAmenities added since the previous release (also amenities_removed, attributes_added/removed, languages_added/removed).✓
nearest_<service>Hotels · Neighbourhood (within 3 km)Name of the nearest place of a service type, e.g. nearest_pharmacy; nearest_<service>_m gives the distance in metres.✓
count_<group>_3kmHotels · Neighbourhood (within 3 km)Number of open places of a category group within 3 km.✓
places_within_500mHotels · Neighbourhood (within 3 km)Open places within 500 m (also places_within_1km and places_within_3km).✓
nearby_lodging_*Hotels · Neighbourhood (within 3 km)Other places to stay nearby: the competitive set.✓
nearby_openings_*Hotels · Neighbourhood (within 3 km)Places that opened nearby, by period.✓
nearby_closures_*Hotels · Neighbourhood (within 3 km)Places that closed nearby, by period.✓
neighbourhood_momentum_12mHotels · Neighbourhood (within 3 km)Balance of openings and closures nearby over 12 months.✓
possible_replacementsHotels · Neighbourhood (within 3 km)Places that may have replaced a closed place at the same spot.✓
stable_recommendations_*Hotels · Neighbourhood (within 3 km)Nearby places that stay highly rated across releases.✓

The Hotels sheet has 207 columns in all; columns not named above belong to the families shown by pattern.

Full dataset fields

The data you order uses the Location Drive field reference: 97 fields in four groups. These are groupings, not tiers or plans. Lodgingeo adds the contact enrichment and the derived hotel columns described on the data pages. Fields the current sample does not contain are delivered with the full data.

Full dataset fields and whether the sample contains them
FieldGroupIn sample
idCorefull dataset
place_idCorefull dataset
cidCorefull dataset
knowledge_graph_idCorefull dataset
nameCore✓
name_altCore✓
place_typeCorefull dataset
categoryCore✓
categoriesCore✓
descriptionCorefull dataset
statusCore✓
is_claimedCorefull dataset
latitudeCore✓
longitudeCore✓
geohash4Corefull dataset
geohash6Corefull dataset
h3Corefull dataset
plus_codeCorefull dataset
street_addressCore✓
cityCore✓
neighborhoodCore✓
stateCore✓
regionCorefull dataset
postal_codeCore✓
country_nameCore✓
country_codeCore✓
formatted_addressCore✓
parent_nameCore✓
parent_idCorefull dataset
phoneCore✓
phone_localCorefull dataset
websiteCore✓
domainCore✓
google_maps_urlCorefull dataset
ratingCore✓
review_countCore✓
price_rangeCorefull dataset
price_levelCore✓
opening_hoursCorefull dataset
hours_confirmedCorefull dataset
timezoneCore✓
utc_offset_minutesCorefull dataset
languagesCore✓
photo_cover_urlCorefull dataset
logo_urlCorefull dataset
brandCore✓
amenitiesAdvanced✓
attributesAdvanced✓
typical_time_spentAdvancedfull dataset
rating_distributionAdvanced✓
wikipedia_urlAdvanced✓
menu_urlAdvancedfull dataset
reservation_urlAdvancedfull dataset
order_urlAdvancedfull dataset
booking_urlAdvancedfull dataset
polygon_sourceAdvanced✓
polygon_area_m2Advancedfull dataset
grade_letterAdvancedfull dataset
grade_scoreAdvancedfull dataset
grade_flagsAdvancedfull dataset
building_dist_mAdvanced✓
hotel_detailsPremium · Hospitalityfull dataset
hotel_pricePremium · Hospitalityfull dataset
hotel_classPremium · Hospitality✓
check_in_timePremium · Hospitality✓
check_out_timePremium · Hospitality✓
reviewsPremium · Review intelligencefull dataset
historical_reviewsPremium · Review intelligencefull dataset
review_sentimentsPremium · Review intelligencefull dataset
ev_connectorsPremium · EV chargingfull dataset
ev_connector_typesPremium · EV chargingfull dataset
ev_networkPremium · EV chargingfull dataset
ev_max_power_kwPremium · EV chargingfull dataset
ev_plug_countPremium · EV chargingfull dataset
ev_stall_countPremium · EV chargingfull dataset
ev_speedPremium · EV chargingfull dataset
ev_station_namePremium · EV chargingfull dataset
ev_station_cidPremium · EV chargingfull dataset
fuel_typesPremium · Fuelfull dataset
fuel_pricePremium · Fuelfull dataset
menu_itemsPremium · Diningfull dataset
photo_urlsAdded in v8full dataset
photo_datesAdded in v8full dataset
streetview_dateAdded in v8full dataset
menu_photo_urlAdded in v8full dataset
similar_placesAdded in v8full dataset
similar_places_idsAdded in v8full dataset
contained_placesAdded in v8full dataset
contained_places_idsAdded in v8full dataset
building_nameAdded in v8✓
floor_levelAdded in v8✓
area_typeAdded in v8✓
oldest_seen_dateAdded in v8✓
price_reportedAdded in v8full dataset
hotel_search_urlAdded in v8full dataset
trip_urlAdded in v8full dataset
emailLodgingeo contact enrichmentfull dataset
whatsappLodgingeo contact enrichmentfull dataset
facebook_urlLodgingeo contact enrichmentfull dataset
instagram_urlLodgingeo contact enrichmentfull dataset
linkedin_urlLodgingeo contact enrichmentfull dataset
x_urlLodgingeo contact enrichmentfull dataset
tiktok_urlLodgingeo contact enrichmentfull dataset
youtube_urlLodgingeo contact enrichmentfull dataset

See the fields in context on the data overview, or download the sample to see them with real values.

Get the data

Download the free Excel sample to see every column with real rows, or tell us the countries and fields you need for counts and a quote. We reply within 24 hours.

Download free sample Contact us