Name: U.S. Airbnb Open Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

U.S. Airbnb Open Data

Context

Since its inception in 2008, Airbnb has disrupted the traditional hospitality industry as more travellers decide to use Airbnb as their primary means of accommodation. Airbnb offers travellers a more unique and personalized way of accommodation and experience.

Project

I had compiled this dataset for a project of mine on 20th October 2020. The project can be seen here- wherebnb.

Dataset was recompiled and updated in the same format on 14th April 2023

Content

This dataset has one file- AB_US_2023.csv which has columns describing features such as host id, hostname, listing id, listing name, latitude and longitude of listing, the neighbourhood, price, room type, minimum number of nights, number of reviews, last review date, reviews per month, availability, host listings and city.

Acknowledgements

This dataset is a compilation of multiple datasets found on Inside Airbnb.

Inspiration

Can we predict the price of each house in different regions?
Can we describe a region using the names of listings in that region?
What can we learn about different regions from the data?
Based on different factors is it possible to recommend a title to the host for his/her listing?
Can we estimate the popularity of a listing based on given features?

Tables

Ab Us 2020

@kaggle.kritikseth_us_airbnb_open_data.ab_us_2020

14.05 MB
226,030 rows
17 columns

CREATE TABLE ab_us_2020 (
  "id" BIGINT,
  "name" VARCHAR,
  "host_id" BIGINT,
  "host_name" VARCHAR,
  "neighbourhood_group" VARCHAR,
  "neighbourhood" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "room_type" VARCHAR,
  "price" BIGINT,
  "minimum_nights" BIGINT,
  "number_of_reviews" BIGINT,
  "last_review" VARCHAR,
  "reviews_per_month" DOUBLE,
  "calculated_host_listings_count" BIGINT,
  "availability_365" BIGINT,
  "city" VARCHAR
);

Ab Us 2023

@kaggle.kritikseth_us_airbnb_open_data.ab_us_2023

15.03 MB
232,147 rows
18 columns

CREATE TABLE ab_us_2023 (
  "id" BIGINT,
  "name" VARCHAR,
  "host_id" BIGINT,
  "host_name" VARCHAR,
  "neighbourhood_group" VARCHAR,
  "neighbourhood" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "room_type" VARCHAR,
  "price" BIGINT,
  "minimum_nights" BIGINT,
  "number_of_reviews" BIGINT,
  "last_review" TIMESTAMP,
  "reviews_per_month" DOUBLE,
  "calculated_host_listings_count" BIGINT,
  "availability_365" BIGINT,
  "number_of_reviews_ltm" BIGINT,
  "city" VARCHAR
);