Airbnb Data

Exploring Global Hospitality: A Comprehensive Dataset of Airbnb Listings

@kaggle.lovishbansal123_airbnb_data

Table List

1 table(41.8 MB)

Airbnb Data

@kaggle.lovishbansal123_airbnb_data.airbnb_data

41.8 MB
74111 rows
29 columns

id Id	log_price Log Price	property_type Property Type	room_type Room Type	amenities Amenities	accommodates Accommodates	bathrooms Bathrooms	bed_type Bed Type	cancellation_policy Cancellation Policy	cleaning_fee Cleaning Fee	city City	description Description	first_review First Review	host_has_profile_pic Host Has Profile Pic	host_identity_verified Host Identity Verified	host_response_rate Host Response Rate	host_since Host Since	instant_bookable Instant Bookable	last_review Last Review	latitude Latitude	longitude Longitude	name Name	neighbourhood Neighbourhood	number_of_reviews Number Of Reviews	review_scores_rating Review Scores Rating	thumbnail_url Thumbnail Url	zipcode Zipcode	bedrooms Bedrooms	beds Beds
6901257	5.010635294096256	Apartment	Entire home/apt	{"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly",Essentials,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50"}	3	1	Real Bed	strict	true	NYC	Beautiful, sunlit brownstone 1-bedroom in the loveliest neighborhood in Brooklyn. Blocks from the promenade and Brooklyn Bridge Park, with their stunning views of Manhattan, and from the great shopping and food.	Sat Jun 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	t	t	nan	Mon Mar 26 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	f	Mon Jul 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	40.69652362997076	-73.99161684624262	Beautiful brownstone 1-bedroom	Brooklyn Heights	2	100	https://a0.muscache.com/im/pictures/6d7cbbf7-c034-459c-bc82-6522c957627c.jpg?aki_policy=small	11201	1	1
6304928	5.1298987149230735	Apartment	Entire home/apt	{"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50"}	7	1	Real Bed	strict	true	NYC	Enjoy travelling during your stay in Manhattan. My place is centrally located near Times Square and Central Park with easy access to main subways as well as walking distance to many popular restaurants and bus tours. My place is close to the subway, Totto Ramen, Hell's Kitchen, Ippudo Westside, Empa…	Sat Aug 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	f	100%	Mon Jun 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	Sat Sep 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	40.766115415949685	-73.98903992265213	Superb 3BR Apt Located Near Times Square	Hell's Kitchen	6	93	https://a0.muscache.com/im/pictures/348a55fe-4b65-452a-b48a-bfecb3b58a66.jpg?aki_policy=small	10019	3	3
7919400	4.976733742420574	Apartment	Entire home/apt	{TV,"Cable TV","Wireless Internet","Air conditioning",Kitchen,Breakfast,"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_a…	5	1	Real Bed	moderate	true	NYC	The Oasis comes complete with a full backyard with outdoor furniture to make the most of this summer vacation!! The unit has high ceilings, a completed renovation throughout, beautiful flood lighting and exposed brick! Best part, total seclusion. You share with no one! The entire unit is yours duri…	Sun Apr 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	t	100%	Tue Oct 25 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	t	Thu Sep 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	40.80810998936211	-73.94375584395794	The Garden Oasis	Harlem	10	92	https://a0.muscache.com/im/pictures/6fae5362-9e3a-4fa9-aa54-bbd5ea26538d.jpg?aki_policy=small	10027	1	3
13418779	6.620073206530356	House	Entire home/apt	{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Indoor fireplace","Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials}	4	1	Real Bed	flexible	true	SF	This light-filled home-away-from-home is super clean and comes with all of the modern amenities travelers could want. Located on a quiet street in the very trendy, super central Lower Haight neighborhood. 15 minutes to Superbowl City! Avail 2/4-2/8. Tucked away on a quaint and quiet one-way street j…		t	t	nan	Sun Apr 19 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	f		37.77200448256077	-122.43161868239788	Beautiful Flat in the Heart of SF!	Lower Haight			https://a0.muscache.com/im/pictures/72208dad-9c86-41ea-a735-43d933111063.jpg?aki_policy=small	94117.0	2	2
3808709	4.74493212836325	Apartment	Entire home/apt	{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Elevator in building",Heating,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo}	2	1	Real Bed	moderate	true	DC	Cool, cozy, and comfortable studio located in the heart of the city. Literally a 10 min walk to Columbia Heights metro where you'll find shopping, theater, bars and diverse restaurants. Fits two very well, and is very convenient to other great areas. Welcome home! It's in a diverse building, where…	Tue May 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	t	t	100%	Sun Mar 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	t	Sun Jan 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	38.925626916626506	-77.0345955156553	Great studio in midtown DC	Columbia Heights	4	40	nan	20009		1
12422935	4.442651256490317	Apartment	Private room	{TV,"Wireless Internet",Heating,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Hangers,"Laptop friendly workspace"}	2	1	Real Bed	strict	true	SF	Beautiful private room overlooking scenic views in San Francisco's upscale Noe Valley neighborhood. You'll have your own bedroom, queen bed, dresser, wardrobe, smart TV, workstation, desk&chair, WiFi, and kitchen. Fresh towels and linens are provided for your convenience. MUNI bus stop and all tech …	Sun Aug 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	t	100%	Wed Jun 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	Tue Sep 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	37.7531640472884	-122.4295260773271	Comfort Suite San Francisco	Noe Valley	3	100	https://a0.muscache.com/im/pictures/82509143-4b21-44eb-a556-e3c1e0afac60.jpg?aki_policy=small	94131	1	1
11825529	4.4188406077965965	Apartment	Entire home/apt	{TV,Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises",Gym,"Elevator in building","Hot tub",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer","Laptop friendly workspace"}	3	1	Real Bed	moderate	true	LA	Warm and cozy studio with full kitchen and bathroom. Big balcony. Parking included. Walk to the beach, rent a bike, eat at variety of restaurants, see boats at Marina harbor! Great location! Friendly neighborhood! Meet locals at "Cow's End" famous coffee and wrap cafe. Great experience all around. …	Fri Mar 10 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	f	100%	Fri Mar 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	Fri Apr 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	33.980454397275096	-118.46282073746792	Beach Town Studio and Parking!!!11h	nan	15	97	https://a0.muscache.com/im/pictures/4c920c60-43dc-4169-a0da-ccf37f1d7a94.jpg?aki_policy=small	90292	1	1
13971273	4.787491742782046	Condominium	Entire home/apt	{TV,"Cable TV","Wireless Internet","Wheelchair accessible",Pool,Kitchen,"Free parking on premises",Doorman,Dog(s),Cat(s),"Other pet(s)","Elevator in building","Hot tub","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",E…	2	1	Real Bed	moderate	true	LA	Arguably the best location (and safest) in downtown LA. Steps away from Staples Center, LA Live, LA Convention Center, 2 metro stations. Next door to FIDM. Convenience: Starbucks & cleaner in the building. Ralph's across the street. FREE ASSIGNED GATED INDOOR PARKING. FREE WIFI. Fully stocked kitc…	Fri Dec 16 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	t	t	100%	Sat May 18 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	f	Wed Apr 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	34.0467374142499	-118.2604389157384	Near LA Live, Staple's. Starbucks inside. OWN VIEW	Downtown	9	93	https://a0.muscache.com/im/pictures/61bd05d5-c4db-4c49-9f87-c0981c2d83b9.jpg?aki_policy=small	90015	1	1
180792	4.787491742782046	House	Private room	{TV,"Cable TV","Wireless Internet","Pets live on this property",Dog(s),Heating,"Smoke detector","First aid kit",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer","Private entrance","Hot water","Bed linens","Extra pillows and blankets","Coffee maker",Refrigerator,"Dishes and silverware",…	2	1	Real Bed	moderate	true	SF	Garden Studio with private entrance from the street and garden patio sitting area in a charming house in front of Lincoln Park(URL HIDDEN) Queen bed, en suite bathroom and Breakfast bar. Quiet neighborhood away from the crowds. Great location. Your private entrance leads to a beautiful garden-patio,…	Sat Feb 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	t	f	100%	Thu Jun 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	f	Sun Sep 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	37.78112798186231	-122.50109524305331	Cozy Garden Studio - Private Entry	Richmond District	159	99	https://a0.muscache.com/im/pictures/0ed6c128-7d60-4e05-b3bf-63158a230f70.jpg?aki_policy=small	94121	1	1
5385260	3.58351893845611	House	Private room	{"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Heating,"Family/kid friendly",Washer,Essentials,Shampoo,Hangers,"Hair dryer","Laptop friendly workspace","translation missing: en.hosting_amenity_50"}	2	1	Real Bed	moderate	true	LA	Quiet community. Close to supermarkets,restaurants,60 freeway.Looking forward to provide you with high quality service 安全宁静的街区, 近华人及韩国超市,餐厅,近60号高速。欢迎旅行商住宽敞、明亮、干净、整洁、出入方便 Available kitchen,laundry,living room 可使用厨房洗衣间及客厅 Anytime contact with message or email.phone call available 9am to 7pm. 任何时间的信息…	Mon Apr 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	f	100%	Sun Mar 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	t	Sun Apr 16 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	33.99256298219745	-117.89599660615322	No.7 Queen Size Cozy Room 舒适大床房	nan	2	90	https://a0.muscache.com/im/pictures/8d2f08ce-bf65-4018-a7b0-18823a7882a7.jpg?aki_policy=small	91748	1	1


CREATE TABLE airbnb_data (
  "id" BIGINT,
  "log_price" DOUBLE,
  "property_type" VARCHAR,
  "room_type" VARCHAR,
  "amenities" VARCHAR,
  "accommodates" BIGINT,
  "bathrooms" DOUBLE,
  "bed_type" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee" BOOLEAN,
  "city" VARCHAR,
  "description" VARCHAR,
  "first_review" TIMESTAMP,
  "host_has_profile_pic" VARCHAR,
  "host_identity_verified" VARCHAR,
  "host_response_rate" VARCHAR,
  "host_since" TIMESTAMP,
  "instant_bookable" VARCHAR,
  "last_review" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "name" VARCHAR,
  "neighbourhood" VARCHAR,
  "number_of_reviews" BIGINT,
  "review_scores_rating" DOUBLE,
  "thumbnail_url" VARCHAR,
  "zipcode" VARCHAR,
  "bedrooms" DOUBLE,
  "beds" DOUBLE
);