Airbnb Open Data

New York Airbnb Open Data

@kaggle.arianazmoudeh_airbnbopendata

Table List

1 table(6.17 MB)

Airbnb Open Data

@kaggle.arianazmoudeh_airbnbopendata.airbnb_open_data

6.17 MB
102599 rows
26 columns

id Id	name NAME	host_id Host Id	host_identity_verified Host Identity Verified	host_name Host Name	neighbourhood_group Neighbourhood Group	neighbourhood Neighbourhood	lat Lat	long Long	country Country	country_code Country Code	instant_bookable Instant Bookable	cancellation_policy Cancellation Policy	room_type Room Type	construction_year Construction Year	price Price	service_fee Service Fee	minimum_nights Minimum Nights	number_of_reviews Number Of Reviews	last_review Last Review	reviews_per_month Reviews Per Month	review_rate_number Review Rate Number	calculated_host_listings_count Calculated Host Listings Count	availability_365 Availability 365	house_rules House Rules	license License
1001254	Clean & quiet apt home by the park	80014485718	unconfirmed	Madaline	Brooklyn	Kensington	40.64749	-73.97237	United States	US	False	strict	Private room	2020	$966	$193	10	9	Tue Oct 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.21	4	6	286	Clean up and treat the home the way you'd like your home to be treated. No smoking.	nan
1002102	Skylit Midtown Castle	52335172823	verified	Jenna	Manhattan	Midtown	40.75362	-73.98377	United States	US	False	moderate	Entire home/apt	2007	$142	$28	30	45	Sat May 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.38	4	2	228	Pet friendly but please confirm with me if the pet you are planning on bringing with you is OK. I have a cute and quiet mixed chihuahua. I could accept more guests (for an extra fee) but this also needs to be confirmed beforehand. Also friends traveling together could sleep in separate beds for an e…	nan
1002403	THE VILLAGE OF HARLEM....NEW YORK !	78829239556	nan	Elise	Manhattan	Harlem	40.80902	-73.9419	United States	US	True	flexible	Private room	2005	$620	$124	3				5	1	352	I encourage you to use my kitchen, cooking and laundry facilities. There is no additional charge to use the washer/dryer in the basement. No smoking, inside or outside. Come home as late as you want. If you come home stumbling drunk, it's OK the first time. If you do it again, and you wake up me o…	nan
1002755	nan	85098326012	unconfirmed	Garry	Brooklyn	Clinton Hill	40.68514	-73.95976	United States	US	True	moderate	Entire home/apt	2005	$368	$74	30	270	Fri Jul 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	4.64	4	1	322	nan	nan
1003689	Entire Apt: Spacious Studio/Loft by central park	92037596077	verified	Lyndon	Manhattan	East Harlem	40.79851	-73.94399	United States	US	False	moderate	Entire home/apt	2009	$204	$41	10	9	Mon Nov 19 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1	3	1	289	Please no smoking in the house, porch or on the property (you can go to the nearby corner). Reasonable quiet after 10:30 pm. Please remove shoes in the house.	nan
1004098	Large Cozy 1 BR Apartment In Midtown East	45498551794	verified	Michelle	Manhattan	Murray Hill	40.74767	-73.975	United States	US	True	flexible	Entire home/apt	2013	$577	$115	3	74	Sat Jun 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	0.59	3	1	374	No smoking, please, and no drugs.	nan
1004650	BlissArtsSpace!	61300605564	nan	Alberta	Brooklyn	Bedford-Stuyvesant	40.68688	-73.95596	United States	US	False	moderate	Private room	2015	$71	$14	45	49	Thu Oct 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4	5	1	224	Please no shoes in the house so bring slippers or extra socks to keep your feet warm- especially in winter! No smoking either inside or outside. Please be considerate of neighbors from 10pm-7am in terms of noise. Please take out any trash and leave in the large blue garbage bin at the end of the dri…	nan
1005202	BlissArtsSpace!	90821839709	unconfirmed	Emma	Brooklyn	Bedford-Stuyvesant	40.68688	-73.95596	United States	US	False	moderate	Private room	2009	$1,060	$212	45	49	Thu Oct 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4	5	1	219	House Guidelines for our BnB We are delighted to welcome you. Check in Sun – Thurs by 8PM and Fri, Sat by 9pm. Please bear in mind that this is not a hotel but our home and we are opening it to you. We will do our utmost to make your stay enjoyable and fun. We ask that you take care to respect ou…	nan
1005754	Large Furnished Room Near B'way	79384379533	verified	Evelyn	Manhattan	Hell's Kitchen	40.76489	-73.98493	United States	US	True	strict	Private room	2005	$1,018	$204	2	430	Mon Jun 24 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	3.47	3	1	180	- Please clean up after yourself when using the kitchen. - When using the bathroom, please be careful to minimize the amount of water on the floor when showering and using the sink. - Please make sure to remove any strands of hair from the sink and floors with a tissue or paper towel. - Be respectfu…	nan
1006307	Cozy Clean Guest Room - Family Apt	75527839483	unconfirmed	Carl	Manhattan	Upper West Side	40.80178	-73.96723	United States	US	False	strict	Private room	2015	$291	$58	2	118	Fri Jul 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	0.99	5	1	375	NO SMOKING OR PETS ANYWHERE ON THE PROPERTY 1. Be respectful of the other tenants 2. If you use the grill, be sure to turn off the gas 3. Notify the owner of any discrepancies or things not functioning properly immediately 4. Please treat carpet stains promptly (or notify the owner) 5. Kindly turn o…	nan


CREATE TABLE airbnb_open_data (
  "id" BIGINT,
  "name" VARCHAR,
  "host_id" BIGINT,
  "host_identity_verified" VARCHAR,
  "host_name" VARCHAR,
  "neighbourhood_group" VARCHAR,
  "neighbourhood" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "country" VARCHAR,
  "country_code" VARCHAR,
  "instant_bookable" VARCHAR,
  "cancellation_policy" VARCHAR,
  "room_type" VARCHAR,
  "construction_year" DOUBLE,
  "price" VARCHAR,
  "service_fee" VARCHAR,
  "minimum_nights" DOUBLE,
  "number_of_reviews" DOUBLE,
  "last_review" TIMESTAMP,
  "reviews_per_month" DOUBLE,
  "review_rate_number" DOUBLE,
  "calculated_host_listings_count" DOUBLE,
  "availability_365" DOUBLE,
  "house_rules" VARCHAR,
  "license" VARCHAR
);