Hi folks,<\/p>\n
I work on the data science team at AirROI<\/a>, we are one of the largest Airbnb data analytics platform.<\/p>\n FYI, we’ve released free Airbnb datasets on nearly 1,000 largest markets<\/strong>, and we’re releasing it for free to the community. This is one of the most granular free datasets available, containing not just listing details but critical performance metrics like trailing-twelve-month revenue, occupancy rates, and future calendar rates. We also refresh<\/strong> this free datasets on monthly<\/strong> basis.<\/p>\n Direct Download Link (No sign-up required):<\/strong> The data is structured into several interconnected tables, provided as CSV files per market.<\/p>\n 1. Listings Data (65 Fields)<\/strong> 2. Calendar Rates Data (14 Fields)<\/strong> 3. Reviews Data (4 Fields)<\/strong> 4. Host Data (11 Fields)<\/strong> Coming Soon<\/em><\/strong> Most free datasets stop at basic listing info. This one includes the performance data<\/strong> needed for serious analysis:<\/p>\n The data is provided under a permissive license for academic and personal use. We request attribution to AirROI<\/a> in public work.<\/p>\n This free dataset is updated monthly. If you need real-time, hyper-specific data, or larger historical dumps<\/strong>, we offer a low-cost API for developers and researchers: Alternatively, we also provide bespoke data services if your needs go beyond the scope of the free datasets.<\/p>\n We hope this data is useful. Happy analyzing!<\/p>\n<\/div>\n submitted by \/u\/jason-airroi <\/a>
www.airroi.com\/data-portal<\/a> -> then download from each market<\/p>\nDataset Overview & Schemas<\/h1>\n
This is the core table with detailed property information and\u2014most importantly\u2014performance metrics<\/strong>.<\/p>\n\n
listing_id<\/code>, listing_name<\/code>, property_type<\/code>, room_type<\/code>, neighborhood<\/code>, latitude<\/code>, longitude<\/code>, amenities<\/code> (list), bedrooms<\/code>, baths<\/code>.<\/li>\nhost_id<\/code>, host_name<\/code>, superhost<\/code> status, professional_management<\/code> flag.<\/li>\n\n
ttm_revenue<\/code> \/ ttm_revenue_native<\/code> (Total revenue last 12 months)<\/li>\nttm_avg_rate<\/code> \/ ttm_avg_rate_native<\/code> (Average daily rate)<\/li>\nttm_occupancy<\/code> \/ ttm_adjusted_occupancy<\/code><\/li>\nttm_revpar<\/code> \/ ttm_adjusted_revpar<\/code> (Revenue Per Available Room)<\/li>\nl90d_revenue<\/code>, l90d_occupancy<\/code>, etc. (Last 90-day snapshot)<\/li>\nttm_reserved_days<\/code>, ttm_blocked_days<\/code>, ttm_available_days<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
Monthly aggregated future pricing and availability data for forecasting.<\/p>\n\n
listing_id<\/code>, date<\/code> (monthly), vacant_days<\/code>, reserved_days<\/code>, occupancy<\/code>, revenue<\/code>, rate_avg<\/code>, booked_rate_avg<\/code>, booking_lead_time_avg<\/code>.<\/li>\n<\/ul>\n
Temporal review data for sentiment and volume analysis.<\/p>\n\n
listing_id<\/code>, date<\/code> (monthly), num_reviews<\/code>, reviewers<\/code> (list of IDs).<\/li>\n<\/ul>\n
Profile and portfolio information for hosts.<\/p>\n\n
host_id<\/code>, is_superhost<\/code>, listing_count<\/code>, member_since<\/code>, ratings<\/code>.<\/li>\n<\/ul>\nWhy This Dataset is Unique<\/h1>\n
\n
ttm_revenue<\/code> and occupancy<\/code> data.<\/li>\nrate_avg<\/code> fluctuates with seasonality and booking_lead_time<\/code>.<\/li>\nprofessional_management<\/code> and superhost<\/code> flags to understand market maturity.<\/li>\nlatitude<\/code>\/longitude<\/code> and ttm_revpar<\/code>.<\/li>\n<\/ul>\nPotential Use Cases<\/h1>\n
\n
occupancy<\/code> or revenue<\/code> based on amenities, location, and host data.<\/li>\nLicense & Usage<\/h1>\n
For Custom Needs<\/h1>\n
www.airroi.com\/api<\/a><\/p>\n
[link]<\/a><\/span> [comments]<\/a><\/span><\/p>
