Baselight

Airbnb Listings And Reviews In Washington, DC

Exploring Room Availability, Host Profiles, and Pricing Data

@kaggle.thedevastator_airbnb_listings_and_reviews_in_washington_dc

Loading...
Loading...

About this Dataset

Airbnb Listings And Reviews In Washington, DC


Airbnb Listings and Reviews in Washington, DC

Exploring Room Availability, Host Profiles, and Pricing Data

By Code for DC [source]


About this dataset

Welcome to the Airbnb Listings and Reviews dataset of Washington, DC. This valuable dataset offers insight into the vast rental market in the USA's capital city, providing information on hosts, room type and availability for hundreds of listings. With detailed listings about price, neighbourhood group, latitude and longitude coordinates and more - you can quickly find out what each listing is able to offer.

The Airbnb Listings dataset contains over 400 columns that provide vital parameter measurements for each location listed in Washington - including date when the listing was created or reviewed; name; host name; neighbourhood group; latitude and longitude coordinates furnished by satellite positioning system (GPS); room type; price per night paid by customers/renters; minimum number of nights required to stay at a particular place/lodging facility; calculated host listings count based on how many other accommodations they have opened within a given area or city of operation, reviews_per_month factors determined by calculating customer feedback received over an interval ranging from weeks to months as given in the reviews data-set & last but not least 'availability_365' column name –no amount signifies neither maximum limit nor no availability throughout year around hence availability 365 columns provides a guide on whether a listing is usually available at least 300 days in a calendar year period (calendar meaning 365 days).
We encourage you to explore this complex data set further – it can be used for analyses regarding market trends & characterizing shifts related pricing strategies channelled through hotel owners/operators. Let’ insight be your guide as you uncover new information about this amazing city!

More Datasets

For more datasets, click here.

Featured Notebooks

  • 🚨 Your notebook can be here! 🚨!

How to use the dataset

Welcome to the Airbnb Listings and Reviews dataset in DC. This dataset contains reviews of Airbnb listings as well as information about each listing, such as the host, location, room type, price, and availability. It is a great resource for researchers or anyone looking to learn more about hotel booking trends in the Washington DC area.

This guide will help you explore and make use of the data contained in this dataset. We’ll cover how to download it and how to access both types of data (listings information and reviews). Finally, we’ll go over some tips for using this dataset as effectively as possible.

Research Ideas

  • Using the Airbnb listings and reviews in DC, create a machine learning application that can facilitate more efficient price recommendations for hosts.
  • Use this dataset to develop a personalised recommendation system for visitors to Washington DC, by suggesting Airbnb listings based on their past preferences and location preferences.
  • Leverage this dataset to build an interactive visualization tool mapping out neighborhoods in Washington D.C., with filters mapping out different Airbnb listings -- room type, price, availability etc. This could help potential visitors to make informed decisions about where they might want stay when visiting D.C

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: Airbnb Reviews.csv

Column name Description
date The date at which the listing or review was made. (Date)

File: Airbnb Listings.csv

Column name Description
name The name of the Airbnb listing. (String)
host_name The name of the host of the Airbnb listing. (String)
neighbourhood_group The neighbourhood group where the Airbnb listing is located. (String)
latitude The latitude coordinate of the Airbnb listing. (Float)
longitude The longitude coordinate of the Airbnb listing. (Float)
room_type The type of room offered by the Airbnb listing. (String)
price The average nightly rate for the Airbnb listing. (Integer)
minimum_nights The minimum number of nights required when booking the Airbnb listing. (Integer)
number_of_reviews The number of reviews left by customers who have stayed at the Airbnb listing. (Integer)
last_review The date when the most recent review was written. (Date)
reviews_per_month The total amount of reviews generated per month. (Float)
calculated_host_listings_count The number of listings a host has. (Integer)
availability_365 The average daily availability rate during certain times periods. (Integer)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Code for DC.

Tables

Airbnb Listings

@kaggle.thedevastator_airbnb_listings_and_reviews_in_washington_dc.airbnb_listings
  • 265.5 KB
  • 3723 rows
  • 17 columns
Loading...

CREATE TABLE airbnb_listings (
  "index" BIGINT,
  "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
);

Airbnb Reviews

@kaggle.thedevastator_airbnb_listings_and_reviews_in_washington_dc.airbnb_reviews
  • 456.96 KB
  • 56989 rows
  • 3 columns
Loading...

CREATE TABLE airbnb_reviews (
  "index" BIGINT,
  "listing_id" BIGINT,
  "date" TIMESTAMP
);

Share link

Anyone who has the link will be able to view this.