New York Airbnb Open Data
NY Airbnb dataset as of September 05, 2024
@kaggle.rhonarosecortez_new_york_airbnb_open_data
NY Airbnb dataset as of September 05, 2024
@kaggle.rhonarosecortez_new_york_airbnb_open_data
CREATE TABLE calendar (
"listing_id" BIGINT,
"date" TIMESTAMP,
"available" VARCHAR,
"price" VARCHAR,
"adjusted_price" VARCHAR,
"minimum_nights" BIGINT,
"maximum_nights" BIGINT
);
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
);
CREATE TABLE reviews (
"listing_id" BIGINT,
"id" BIGINT,
"date" TIMESTAMP,
"reviewer_id" BIGINT,
"reviewer_name" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.