Airbnb Data Dictionary

Explore our comprehensive Airbnb dataset with detailed short-term rental statistics, pricing analytics, and market insights for investors, researchers, and property managers.

Listings Data

Comprehensive details of all Airbnb listings providing essential insights into property distribution, amenities, pricing strategies, and competitive positioning across markets.

Key Questions This Data Answers

  • What is the distribution of property types in a market?
  • Which amenities are most common in top-performing listings?
  • How does nightly price vary by neighborhood and property type?
  • What is the density of listings in different geographical areas?

Common Use Cases

  • Market analysis and competitive positioning
  • Property type and amenity distribution analysis
  • Pricing strategy development based on property attributes
  • Geographical analysis of listing density and characteristics

Sample Visualizations

  • Heat maps showing property density by neighborhood
  • Price distribution charts by property type
  • Amenity correlation matrices
  • Property type distribution pie charts

Schema

64 fields
Field NameDescription
listing_idUnique identifier for the listing
listing_nameTitle of the listing
listing_typeType of property (e.g., apartment, house, villa)
room_typeType of room (e.g., entire home, private room)
cover_photo_urlURL of the main listing photo
photos_countNumber of photos available for the listing
host_idUnique identifier for the host
host_nameName of the host
cohost_idsIds of co-hosts associated with the listing
cohost_namesNames of co-hosts associated with the listing
superhostWhether the host is a superhost
countryCountry where the listing is located
stateState or province where the listing is located
cityCity where the listing is located
latitudeGeographical latitude coordinate
longitudeGeographical longitude coordinate
guestsMaximum number of guests allowed
bedroomsNumber of bedrooms available
bedsNumber of beds available
bathsNumber of bathrooms available
registrationIndicates if the listing has a registration number
amenitiesList of amenities offered
instant_bookWhether the listing can be booked instantly
min_nightsMinimum number of nights required to book
cancellation_policyType of cancellation policy offered
currencyCurrency used for pricing
cleaning_feeThe cleaning fee for the listing
extra_guest_feeFee for each extra guest
num_reviewsTotal number of reviews received
rating_overallOverall rating score
rating_accuracyRating score for listing accuracy
rating_checkinRating score for check-in experience
rating_cleanlinessRating score for cleanliness
rating_communicationRating score for host communication
rating_locationRating score for location
rating_valueRating score for value
ttm_revenueTotal revenue in trailing twelve months
ttm_revenue_nativeTotal revenue in native currency in trailing twelve months
ttm_avg_rateAverage daily rate in trailing twelve months
ttm_avg_rate_nativeAverage daily rate in native currency in trailing twelve months
ttm_occupancyOccupancy rate in trailing twelve months
ttm_adjusted_occupancyAdjusted occupancy rate in trailing twelve months, excluding owner-blocked days
ttm_revparRevenue per available room (RevPAR) in trailing twelve months
ttm_revpar_nativeRevenue per available room (RevPAR) in native currency in trailing twelve months
ttm_adjusted_revparAdjusted RevPAR in trailing twelve months
ttm_adjusted_revpar_nativeAdjusted RevPAR in native currency in trailing twelve months
ttm_reserved_daysNumber of booked/reserved days in trailing twelve months
ttm_blocked_daysNumber of host-blocked days in trailing twelve months
ttm_available_daysNumber of available days in trailing twelve months
ttm_total_daysTotal number of days in trailing twelve months (reserved + available)
l90d_revenueRevenue in the last 90 days
l90d_revenue_nativeRevenue in native currency in the last 90 days
l90d_avg_rateAverage daily rate in the last 90 days
l90d_avg_rate_nativeAverage daily rate in native currency in the last 90 days
l90d_occupancyOccupancy rate in the last 90 days
l90d_adjusted_occupancyAdjusted occupancy rate in the last 90 days
l90d_revparRevPAR in the last 90 days
l90d_revpar_nativeRevPAR in native currency in the last 90 days
l90d_adjusted_revparAdjusted RevPAR in the last 90 days
l90d_adjusted_revpar_nativeAdjusted RevPAR in native currency in the last 90 days
l90d_reserved_daysNumber of reserved days in the last 90 days
l90d_blocked_daysNumber of blocked days in the last 90 days
l90d_available_daysNumber of available days in the last 90 days
l90d_total_daysTotal number of days considered in the last 90 days period

Calendar Rates

Availability and pricing information crucial for understanding occupancy patterns, pricing strategies, seasonal variations, and special event impacts.

Key Questions This Data Answers

  • How does seasonality affect market occupancy?
  • How far in advance are properties typically booked?
  • What is the impact of holidays and local events on nightly rates?
  • How do hosts adjust their pricing strategies over the next year?

Common Use Cases

  • Seasonal pricing pattern analysis
  • Occupancy rate calculations and forecasting
  • Special event pricing impact studies
  • Dynamic pricing strategy development

Sample Visualizations

  • Occupancy rate calendars by market
  • Price fluctuation charts throughout the year
  • Special event pricing premium analysis
  • Booking window visualization by season

Schema

14 fields
Field NameDescription
listing_idUnique identifier for the listing
dateFirst day of the month for aggregated monthly data
vacant_daysNumber of days the property was vacant
reserved_daysNumber of days the property was reserved
occupancyOccupancy rate
revenueTotal revenue generated during the month
rate_avgAverage daily rate
booked_rate_avgAverage rate when booked
booking_lead_time_avgAverage booking lead time in days
length_of_stay_avgAverage length of stay in days
min_nights_avgAverage minimum nights requirement
native_booked_rate_avgAverage rate when booked in native currency
native_rate_avgAverage daily rate in native currency
native_revenueRevenue generated in native currency

Reviews Data

Guest reviews and ratings with sentiment analysis providing invaluable insights into guest satisfaction, property performance, and host-guest interactions.

Key Questions This Data Answers

  • What are the common themes in positive and negative guest reviews?
  • How do guest satisfaction scores correlate with property location?
  • Are there trends in guest feedback over time?
  • Which hosts or properties consistently receive the best ratings?

Common Use Cases

  • Guest satisfaction analysis by property type or location
  • Sentiment trend analysis over time
  • Common complaint and praise identification
  • Correlation between amenities and positive reviews

Sample Visualizations

  • Sentiment score heat maps by neighborhood
  • Word clouds of most common positive/negative terms
  • Rating trends over time by property category
  • Review volume seasonality charts

Schema

4 fields
Field NameDescription
listing_idUnique identifier for the listing
dateFirst day of the month when reviews were aggregated
num_reviewsNumber of reviews for the listing
reviewersList of reviewer IDs

Host Data Coming Soon

Detailed host information revealing behaviors, performance metrics, and profile characteristics to understand host professionalism, experience levels, and management practices.

Key Questions This Data Answers

  • What is the ratio of professional property managers to individual hosts?
  • How many properties does a typical host manage?
  • What are the characteristics of Superhosts in a given market?
  • How does host experience level correlate with property performance?

Common Use Cases

  • Professional vs. amateur host analysis
  • Superhost performance metrics and characteristics
  • Multi-property host portfolio analysis
  • Host listing growth patterns over time

Sample Visualizations

  • Distribution of hosts by property count
  • Superhost percentage by neighborhood
  • Host performance comparison by experience level
  • Host experience timeline analysis

Schema

11 fields
Field NameDescription
host_idUnique identifier for the host
host_nameName of the host
is_hostWhether the user is a host
is_superhostWhether the host is a superhost
ratingsHost rating score
reviews_countNumber of reviews received by the host
listing_countNumber of properties managed by host
member_sinceDate the host joined the platform
languagesLanguages spoken by the host
profile_pictureURL to host profile image
aboutHost self-description and biography

Data Quality Commitment

We are committed to providing the highest quality data for your research and business needs. Our rigorous data collection and processing methodology ensures:

Comprehensive Coverage

Our data collection process captures over 95% of all active listings in each market, ensuring you have the complete picture.

Regular Updates

All datasets are updated monthly, with timestamps indicating the exact collection date for transparency.

Data Cleaning

Our automated and manual cleaning processes remove duplicates, correct errors, and standardize formats for consistency.