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:
- New means newly listed. A hotel is "first seen" in the month it first appears in a release. That is usually close to an opening, but it can also be an existing hotel that started being listed.
- Gaps are gaps, not closures. A place missing from one release is treated as a data gap. A closure is recorded only when the place is marked closed. This keeps closure counts conservative.
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
| Column | Meaning | Availability |
|---|---|---|
first_seen_month | First monthly release containing the hotel. | in sample |
last_seen_month | Latest monthly release containing the hotel. | in sample |
last_confirmed_month | Latest release in which the hotel was confirmed operating. | in sample |
closed_month | Release in which the hotel was first marked closed. | in sample |
continuity_months | Number of monthly releases containing the hotel. | in sample |
lifecycle_stage | Lifecycle stage derived from the monthly history. | in sample |
status_history | Operating status by month. | in sample |
name_history | Previous names with the month they changed. | in sample |
oldest_seen_date | Earliest 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 type | Records |
|---|---|
field_changed | 1,628 |
field_added | 273 |
first_listed | 10 |
reopened | 2 |
closed | 2 |
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
- In the Hotels sheet, filter
first_seen_monthto the latest release, 2026-10. - Check
oldest_seen_dateto drop hotels that were listed long before. - Filter by country,
hotel_classorbrandto 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
- Filter
closed_monthto non-blank values for all recorded closures, or to one month. - Compare
last_confirmed_monthwithlast_seen_month: a hotel still listed but not confirmed operating for several months deserves a check. - For reopenings, filter the Hotel changes sheet on the
reopenedtype;status_historyon 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
- First seen is not an opening date. Use
oldest_seen_dateand your own checks before calling a hotel new. - Closures are recorded only when a place is marked closed, so a closure can appear in the data later than it happened.
- The sample covers 250 hotels; its counts illustrate the columns rather than measure a market.
Where to go next
The history and changes page lists every history column, and real estate and hotel development describes the use case.