Dataset: New York Airbnb Open Data

About this Dataset

New York Airbnb Open Data

This dataset provides a snapshot of the Airbnb market in Albany, New York, as of September 5, 2024. Airbnb is a global platform that connects hosts with guests seeking short-term accommodations, offering diverse lodging options ranging from entire homes and apartments to single rooms and shared spaces. Albany, as the capital of New York State, has a unique Airbnb market shaped by its mix of government-related travel, tourism, and local events.

The data includes three files – calendar.csv, listings.csv, and reviews.csv – which together capture key aspects of Albany’s Airbnb ecosystem:

Listings: Details on property types, pricing, and host characteristics.

Calendar: Daily availability and pricing data.

Reviews: Guest feedback on individual listings.

Overall Structure & Analysis Potential:

This dataset offers a rich foundation for analyzing various aspects of the Albany Airbnb market, such as:

Availability & Pricing Trends: By combining calendar.csv and listings.csv, one can examine how pricing and availability fluctuate over time and across different types of listings.

Listing Characteristics: listings.csv provides an overview of the type, size, and features of listings in Albany, helping identify the most common accommodation types and pricing ranges.

Guest Feedback: reviews.csv allows for sentiment analysis and topic modeling to understand guest satisfaction and common issues.

Tables

Calendar

@kaggle.rhonarosecortez_new_york_airbnb_open_data.calendar

59.17 KB
155490 rows
7 columns


CREATE TABLE calendar (
  "listing_id" BIGINT,
  "date" TIMESTAMP,
  "available" VARCHAR,
  "price" VARCHAR,
  "adjusted_price" VARCHAR,
  "minimum_nights" BIGINT,
  "maximum_nights" BIGINT
);

Listings

@kaggle.rhonarosecortez_new_york_airbnb_open_data.listings

334.09 KB
426 rows
75 columns


CREATE TABLE listings (
  "id" BIGINT,
  "listing_url" VARCHAR,
  "scrape_id" BIGINT,
  "last_scraped" TIMESTAMP,
  "source" VARCHAR,
  "name" VARCHAR,
  "description" VARCHAR,
  "neighborhood_overview" VARCHAR,
  "picture_url" VARCHAR,
  "host_id" BIGINT,
  "host_url" VARCHAR,
  "host_name" VARCHAR,
  "host_since" TIMESTAMP,
  "host_location" VARCHAR,
  "host_about" VARCHAR,
  "host_response_time" VARCHAR,
  "host_response_rate" VARCHAR,
  "host_acceptance_rate" VARCHAR,
  "host_is_superhost" VARCHAR,
  "host_thumbnail_url" VARCHAR,
  "host_picture_url" VARCHAR,
  "host_neighbourhood" VARCHAR,
  "host_listings_count" BIGINT,
  "host_total_listings_count" BIGINT,
  "host_verifications" VARCHAR,
  "host_has_profile_pic" VARCHAR,
  "host_identity_verified" VARCHAR,
  "neighbourhood" VARCHAR,
  "neighbourhood_cleansed" VARCHAR,
  "neighbourhood_group_cleansed" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "property_type" VARCHAR,
  "room_type" VARCHAR,
  "accommodates" BIGINT,
  "bathrooms" DOUBLE,
  "bathrooms_text" VARCHAR,
  "bedrooms" DOUBLE,
  "beds" DOUBLE,
  "amenities" VARCHAR,
  "price" VARCHAR,
  "minimum_nights" BIGINT,
  "maximum_nights" BIGINT,
  "minimum_minimum_nights" BIGINT,
  "maximum_minimum_nights" BIGINT,
  "minimum_maximum_nights" BIGINT,
  "maximum_maximum_nights" BIGINT,
  "minimum_nights_avg_ntm" DOUBLE,
  "maximum_nights_avg_ntm" DOUBLE,
  "calendar_updated" VARCHAR,
  "has_availability" VARCHAR,
  "availability_30" BIGINT,
  "availability_60" BIGINT,
  "availability_90" BIGINT,
  "availability_365" BIGINT,
  "calendar_last_scraped" TIMESTAMP,
  "number_of_reviews" BIGINT,
  "number_of_reviews_ltm" BIGINT,
  "number_of_reviews_l30d" BIGINT,
  "first_review" TIMESTAMP,
  "last_review" TIMESTAMP,
  "review_scores_rating" DOUBLE,
  "review_scores_accuracy" DOUBLE,
  "review_scores_cleanliness" DOUBLE,
  "review_scores_checkin" DOUBLE,
  "review_scores_communication" DOUBLE,
  "review_scores_location" DOUBLE,
  "review_scores_value" DOUBLE,
  "license" VARCHAR,
  "instant_bookable" VARCHAR,
  "calculated_host_listings_count" BIGINT,
  "calculated_host_listings_count_entire_homes" BIGINT,
  "calculated_host_listings_count_private_rooms" BIGINT,
  "calculated_host_listings_count_shared_rooms" BIGINT,
  "reviews_per_month" DOUBLE
);

Reviews

@kaggle.rhonarosecortez_new_york_airbnb_open_data.reviews

3.2 MB
24752 rows
6 columns


CREATE TABLE reviews (
  "listing_id" BIGINT,
  "id" BIGINT,
  "date" TIMESTAMP,
  "reviewer_id" BIGINT,
  "reviewer_name" VARCHAR,
  "comments" VARCHAR
);