U.S. Airbnb Open Data

Airbnb listings and metrics of regions in the U.S.

@kaggle.kritikseth_us_airbnb_open_data

Table List

2 tables(27.73 MB)

Ab Us 2020

Ab Us 2023

Ab Us 2023

@kaggle.kritikseth_us_airbnb_open_data.ab_us_2023

14.33 MB
232147 rows
18 columns

id Id	name Name	host_id Host Id	host_name Host Name	neighbourhood_group Neighbourhood Group	neighbourhood Neighbourhood	latitude Latitude	longitude Longitude	room_type Room Type	price Price	minimum_nights Minimum Nights	number_of_reviews Number Of Reviews	last_review Last Review	reviews_per_month Reviews Per Month	calculated_host_listings_count Calculated Host Listings Count	availability_365 Availability 365	number_of_reviews_ltm Number Of Reviews Ltm	city City
958	Bright, Modern Garden Unit - 1BR/1BTH	1169	Holly	nan	Western Addition	37.77028	-122.43317	Entire home/apt	202	2	383	Sun Feb 19 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.31	1	128	59	San Francisco
5858	Creative Sanctuary	8904	Philip And Tania	nan	Bernal Heights	37.74474	-122.42089	Entire home/apt	235	30	111	Sun Aug 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	0.66	1	365		San Francisco
8142	Friendly Room Apt. Style -UCSF/USF - San Francisco	21994	Aaron	nan	Haight Ashbury	37.76555	-122.45213	Private room	56	32	9	Thu Oct 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.09	13	365	1	San Francisco
8339	Historic Alamo Square Victorian	24215	Rosy	nan	Western Addition	37.77564	-122.43642	Entire home/apt	575	9	28	Fri Jun 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	0.17	2	365		San Francisco
8739	Mission Sunshine, with Private Bath	7149	Ivan & Wendy	nan	Mission	37.7603	-122.42197	Private room	110	1	770	Sat Feb 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.65	2	159	34	San Francisco
10537	Elegant & Cozy w/City views. Private room: Purple	36752	Teresa	nan	Bayview	37.7175	-122.39698	Private room	95	1	19	Sat Jan 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	0.12	2	365	1	San Francisco
142177	Stylish, Spacious and Quiet Flat!	656263	Noreen	nan	Outer Richmond	37.7844	-122.47932	Entire home/apt	259	5	234	Fri Feb 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	1.69	1	32	13	San Francisco
490931	Mission's "La Lengua"	1269188	Maureen	nan	Bernal Heights	37.74766	-122.42041	Private room	100	30	80	Sat Nov 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.74	1	331	1	San Francisco
10578	Classic Nob Hill Studio - Roof Deck	37049	Andrew	nan	Nob Hill	37.79249	-122.41499	Entire home/apt	79	30	18	Sun May 17 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	0.13	1	230		San Francisco
12041	Sunny/Sunset view room UCSF/USF - San Francisco	21994	Aaron	nan	Haight Ashbury	37.76901	-122.44701	Private room	65	32	7	Sat Jun 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.05	13	365	1	San Francisco


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
);