Track Hotel Openings and Closures Month by Month

Every monthly release of the hotel data is compared with the one before. The result is a set of lifecycle columns on each hotel and a log of every change, which together let you list new hotels, closures and reopenings for any month since the history began in January 2025.

The rule behind the history

Each release is matched place by place to the previous release, keeping each place's stable ld_id. Two rules shape what you see:

Because the history starts in January 2025, every hotel already listed then has a first-seen month of 2025-01. Count openings only from the following months.

Lifecycle columns on each hotel

Lifecycle columns
ColumnMeaningAvailability
first_seen_monthFirst monthly release containing the hotel.in sample
last_seen_monthLatest monthly release containing the hotel.in sample
last_confirmed_monthLatest release in which the hotel was confirmed operating.in sample
closed_monthRelease in which the hotel was first marked closed.in sample
continuity_monthsNumber of monthly releases containing the hotel.in sample
lifecycle_stageLifecycle stage derived from the monthly history.in sample
status_historyOperating status by month.in sample
name_historyPrevious names with the month they changed.in sample
oldest_seen_dateEarliest date the place is known to have been listed.in sample

oldest_seen_date helps separate the two meanings of "new": a hotel first seen in 2026 but with an oldest-seen date years earlier is a newly listed existing hotel, not an opening.

The change log

The Hotel changes sheet of the sample has one row per change, with its month in cycle_month. It holds 1,915 records for the 250 sample hotels:

Change records in the sample, by type
Change typeRecords
field_changed1,628
field_added273
first_listed10
reopened2
closed2

Most records are ordinary fact changes. The most-changed fields in the sample are amenities (623), website (337), rating (253). The lifecycle events are rarer: 10 first listings, 2 closures and 2 reopenings across the sample's history.

Recipe: new hotels this month

  1. In the Hotels sheet, filter first_seen_month to the latest release, 2026-10.
  2. Check oldest_seen_date to drop hotels that were listed long before.
  3. Filter by country, hotel_class or brand to your market.

For a monthly series, build a pivot table with first_seen_month in rows and a count of ld_id as the value, leaving out 2025-01.

Recipe: closures and reopenings

  1. Filter closed_month to non-blank values for all recorded closures, or to one month.
  2. Compare last_confirmed_month with last_seen_month: a hotel still listed but not confirmed operating for several months deserves a check.
  3. For reopenings, filter the Hotel changes sheet on the reopened type; status_history on the hotel shows the full sequence.

Recipe: neighbourhood momentum

For site selection and investment work, what happens around a hotel can matter as much as the hotel itself. Within 3 km of each hotel the data counts places that opened (nearby_openings_*) and closed (nearby_closures_*), and summarises the balance in neighbourhood_momentum_12m. possible_replacements flags places that may have taken over a closed place's spot.

Sort hotels by neighbourhood_momentum_12m within a city to see which areas are gaining places and which are losing them. Combined with nearby_lodging_*, it shows whether new competition is arriving next to a property.

Keeping up month by month

Monthly subscribers receive each release with a change file, so a tracking sheet only needs the new rows each month. Join them on ld_id; it does not change between releases. See monthly updates and the release log.

Example: a monthly openings report

Putting the recipes together, a simple monthly report for one market takes four steps. Filter the Hotels sheet to your countries. Count hotels whose first_seen_month is the new release and whose oldest_seen_date is recent: these are your likely openings. Count hotels whose closed_month is the new release: these are the recorded closures. Then list the hotels with the strongest positive and negative neighbourhood_momentum_12m to show where activity is concentrated. Kept as one sheet per month, this gives a running series that is easy to chart, and every number in it can be traced back to individual hotel rows.

Caveats

Where to go next

The history and changes page lists every history column, and real estate and hotel development describes the use case.

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