Inside AirBnB - Netherlands

Data and advocacy about Airbnb's impact on residential communities.

@kaggle.konradb_inside_airbnb_netherlands

Table List

6 tables(67.86 MB)

Reviews

Listings Detailed

@kaggle.konradb_inside_airbnb_netherlands.listings_detailed

6.67 MB
6998 rows
75 columns

id Id	listing_url Listing Url	scrape_id Scrape Id	last_scraped Last Scraped	source Source	name Name	description Description	neighborhood_overview Neighborhood Overview	picture_url Picture Url	host_id Host Id	host_url Host Url	host_name Host Name	host_since Host Since	host_location Host Location	host_about Host About	host_response_time Host Response Time	host_response_rate Host Response Rate	host_acceptance_rate Host Acceptance Rate	host_is_superhost Host Is Superhost	host_thumbnail_url Host Thumbnail Url	host_picture_url Host Picture Url	host_neighbourhood Host Neighbourhood	host_listings_count Host Listings Count	host_total_listings_count Host Total Listings Count	host_verifications Host Verifications	host_has_profile_pic Host Has Profile Pic	host_identity_verified Host Identity Verified	neighbourhood Neighbourhood	neighbourhood_cleansed Neighbourhood Cleansed	latitude Latitude	longitude Longitude	property_type Property Type	room_type Room Type	accommodates Accommodates	bathrooms_text Bathrooms Text	bedrooms Bedrooms	beds Beds	amenities Amenities	price Price	minimum_nights Minimum Nights	maximum_nights Maximum Nights	minimum_minimum_nights Minimum Minimum Nights	maximum_minimum_nights Maximum Minimum Nights	minimum_maximum_nights Minimum Maximum Nights	maximum_maximum_nights Maximum Maximum Nights	minimum_nights_avg_ntm Minimum Nights Avg Ntm	maximum_nights_avg_ntm Maximum Nights Avg Ntm	has_availability Has Availability	availability_30 Availability 30	availability_60 Availability 60	availability_90 Availability 90	availability_365 Availability 365	calendar_last_scraped Calendar Last Scraped	number_of_reviews Number Of Reviews	number_of_reviews_ltm Number Of Reviews Ltm	number_of_reviews_l30d Number Of Reviews L30d	first_review First Review	last_review Last Review	review_scores_rating Review Scores Rating	review_scores_accuracy Review Scores Accuracy	review_scores_cleanliness Review Scores Cleanliness	review_scores_checkin Review Scores Checkin	review_scores_communication Review Scores Communication	review_scores_location Review Scores Location	review_scores_value Review Scores Value	license License	instant_bookable Instant Bookable	calculated_host_listings_count Calculated Host Listings Count	calculated_host_listings_count_entire_homes Calculated Host Listings Count Entire Homes	calculated_host_listings_count_private_rooms Calculated Host Listings Count Private Rooms	reviews_per_month Reviews Per Month
2818	https://www.airbnb.com/rooms/2818	20230309202119	Thu Mar 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	city scrape	Quiet Garden View Room & Super Fast Wi-Fi	Quiet Garden View Room & Super Fast Wi-Fi<br /><br /><b>The space</b><br />I'm renting a bedroom (room overlooking the garden) in my apartment in Amsterdam, <br /><br />The room is located to the east of the city centre in a quiet, typical Amsterdam neighbourhood, the "Indische Buurt". Amsterdam’s h…	Indische Buurt ("Indies Neighborhood") is a neighbourhood in the eastern portion of the city of Amsterdam, in the Dutch province of Noord-Holland. The name dates from the early 20th century and is derived from the fact that the neighbourhood's streets are named after islands and other geographical c…	https://a0.muscache.com/pictures/10272854/8dcca016_original.jpg	3159	https://www.airbnb.com/users/show/3159	Daniel	Wed Sep 24 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	Upon arriving in Amsterdam, one can imagine asking oneself: Where is the fun nightlife? What are the local hot spots? How can I experience the real life in this city? I offer you the opportunity to act, eat and sleep like-a-local! I provide the traveler with the opportunity to connect with…	within an hour	100%	100%	t	https://a0.muscache.com/im/users/3159/profile_pic/1259095323/original.jpg?aki_policy=profile_small	https://a0.muscache.com/im/users/3159/profile_pic/1259095323/original.jpg?aki_policy=profile_x_medium	Indische Buurt	1	1	['email', 'phone']	t	t	Amsterdam, North Holland, Netherlands	Oostelijk Havengebied - Indische Buurt	52.36435	4.94358	Private room in rental unit	Private room	2	1.5 shared baths	1	2	["Drying rack for clothing", "Host greets you", "Room-darkening shades", "PH neutral and dermatologically tested shampoo", "Hair dryer", "Bed linens", "Hot water", "Clothing storage: wardrobe", "Garden view", "Fast wifi \u2013 52 Mbps", "Paid washer \u2013 In unit", "Hot water kettle", "Single level…	$69.00	3	28	3	5	10	1125	3	1094.7	t	4	8	18	44	Thu Mar 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	322	37	3	Mon Mar 30 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.89	4.93	4.99	4.97	4.98	4.69	4.81	0363 5F3A 5684 6750 D14D	f	1		1	1.9
311124	https://www.airbnb.com/rooms/311124	20230309202119	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	city scrape	historic centre bright canal view jordaan	> Please be so kind to book ONLY AFTER contacing us. Since we are happy with our high ranking we only accept reservations when we can assure you maximum quality. <<br /> <br />Our guests love the studio because:<br /><br />* in the heart of historic Amsterdam in most appreciated 'Jordaan' neighbo…	Perfect location in the lively centre. All historic high lights, shopping, eating and drinking out options in walking distance.	https://a0.muscache.com/pictures/5208672/5bb6091f_original.jpg	1600010	https://www.airbnb.com/users/show/1600010	Anke & Robert	Thu Jan 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	We love cycling, travelling, healthy food and good weather, And we support the Airbnb concept. It is so nice to meet new people this way. At our place, or while we are travelling ourselves.	within a few hours	100%	68%	f	https://a0.muscache.com/im/users/1600010/profile_pic/1364046747/original.jpg?aki_policy=profile_small	https://a0.muscache.com/im/users/1600010/profile_pic/1364046747/original.jpg?aki_policy=profile_x_medium	Jordaan	1	1	['email', 'phone', 'work_email']	t	f	Amsterdam, North Holland, Netherlands	Centrum-West	52.37104	4.87713	Entire rental unit	Entire home/apt	2	1 bath	1	1	["Drying rack for clothing", "Wifi", "Waterfront", "Washer", "Blender", "Hair dryer", "Luggage dropoff allowed", "Bed linens", "Hot water", "Cleaning products", "Hot water kettle", "Cooking basics", "Rice maker", "Kitchen", "Laundromat nearby", "Dining table", "Dedicated workspace", "Stove", "Shampo…	$325.00	5	15	5	5	8	8	5	8	t	23	41	71	346	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	87	3		Tue May 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.76	4.72	4.79	4.9	4.92	4.93	4.6	0363 59D8 7D30 6CFA DC81	f	1	1		0.66
319985	https://www.airbnb.com/rooms/319985	20230309202119	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	city scrape	Elegant Appartement Central Location.	From December 26 thru January 2, minimum stay 4 nights<br /><br />Het aanbieden van een artistieke kijk op klassieke elegantie, dit appartement combineert stijlvol modern ingericht met hoge gestucte plafonds en renaissance-architectuur. Gratis WiFi en een wasserette aanwezig.<br /><br /><b>The space…	Bij aankomst vertel ik mijn gasten graag over de omgeving.	https://a0.muscache.com/pictures/3b76222e-ed0a-4a78-8b8a-c64f19fa00c4.jpg	1640702	https://www.airbnb.com/users/show/1640702	J	Mon Jan 23 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	I like to welcome guests who take good care of my property, and inform them about Amsterdam.	within a day	93%	89%	t	https://a0.muscache.com/im/pictures/user/0564f251-382c-44a0-bd2d-ce009ad22357.jpg?aki_policy=profile_small	https://a0.muscache.com/im/pictures/user/0564f251-382c-44a0-bd2d-ce009ad22357.jpg?aki_policy=profile_x_medium	De Pijp	2	3	['email', 'phone']	t	t	De Pijp, North Holland, Netherlands	De Pijp - Rivierenbuurt	52.35669	4.90187	Entire rental unit	Entire home/apt	4	1 bath	1	2	["Building staff", "Wifi", "Hair dryer", "Bed linens", "Hot water", "Cleaning products", "Hot water kettle", "Cooking basics", "Self check-in", "High chair", "Kitchen", "Laundromat nearby", "Dining table", "Central heating", "Dedicated workspace", "Stove", "Shampoo", "Long term stays allowed", "Clea…	$244.00	1	90	1	2	90	90	1.3	90	t	8	13	32	41	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	492	88	5	Sun May 06 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.75	4.83	4.69	4.86	4.78	4.85	4.62	0363 7D88 E1E8 F521 9A10	f	2	1	1	3.73
327285	https://www.airbnb.com/rooms/327285	20230309202119	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	city scrape	beautiful designed ap.+bikes+garden	Cosy and comfortable apartment on the ground floor of a typical Amsterdam building (1888) in the very populair neighbourhood 'De Pijp'. <br />'De Pijp' as we Amsterdammers know it today is without doubt a melting pot of cultures and nationalities. The Pijp is known for the vividness of it, and al…	'De Pijp' as we Amsterdammers know it today is without doubt a melting pot of cultures and nationalities. The Pijp is known for the vividness of it, and almost feels like a little village inside the city. <br /><br />De Pijp is brimming with fantastic cafés, culinair restaurants, coffee shops and b…	https://a0.muscache.com/pictures/4283713/63eaa97f_original.jpg	1672823	https://www.airbnb.com/users/show/1672823	Ester	Mon Jan 30 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	We are the parents of 4 beautiful children, two boys and two girls. Since two yours we are also the proud grandfathers of the two cutest grandchildren. We live in Amsterdam for 30 years. Marc, my husband and I design houses and everything inside. Beside architecture I also design huge spectacular ca…	within an hour	100%	100%	f	https://a0.muscache.com/im/pictures/user/cf563489-9f1e-44c1-9377-a9996eaed3ac.jpg?aki_policy=profile_small	https://a0.muscache.com/im/pictures/user/cf563489-9f1e-44c1-9377-a9996eaed3ac.jpg?aki_policy=profile_x_medium	De Pijp	3	4	['phone']	t	t	Amsterdam, North Holland, Netherlands	De Pijp - Rivierenbuurt	52.35625	4.89323	Private room in home	Private room	4	1.5 baths	1	6	["Board games", "Drying rack for clothing", "Wifi", "Children\u2019s dinnerware", "Blender", "Hair dryer", "Luggage dropoff allowed", "Free washer \u2013 In unit", "Outdoor furniture", "Bed linens", "Private backyard \u2013 Fully fenced", "Hot water", "Cleaning products", "Hot water kettle", "Single…	$244.00	2	30	1	5	30	30	2.7	30	t	1	3	5	13	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	561	26	8	Mon Mar 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.94	4.91	4.92	4.98	4.99	4.91	4.84	0363 8A88 B129 62B5 BD4E	t	2		2	4.19
331946	https://www.airbnb.com/rooms/331946	20230309202119	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	previous scrape	Lovely FAMILY house near Vondelpark	* Our house is only suitable for a couple or families with children (3) and not for adults groups <br /><br /><b>The space</b><br /> Dear travelers, welcome to our great FAMILY house (175 sqm) near the Amsterdam Vondelpark.<br />You will be staying in a refurbished loft in Amsterdam: have a look a…	nan	https://a0.muscache.com/pictures/b73c16af-4e31-4b61-a948-4a68cdfe3501.jpg	1687595	https://www.airbnb.com/users/show/1687595	Sebastiaan	Thu Feb 02 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	Welcome guests, I'm Sebastiaan and it would be very nice to hear from you if you have any questions - or if you would like to stay in our great family house.	nan	nan	nan	f	https://a0.muscache.com/im/users/1687595/profile_pic/1328270894/original.jpg?aki_policy=profile_small	https://a0.muscache.com/im/users/1687595/profile_pic/1328270894/original.jpg?aki_policy=profile_x_medium	Oud-West	1	1	['email', 'phone']	t	t	nan	De Baarsjes - Oud-West	52.3606	4.85739	Entire loft	Entire home/apt	4	1 bath	4	4	["Host greets you", "Wifi", "Children\u2019s dinnerware", "Washer", "Bed linens", "Hot water", "Cooking basics", "High chair", "Kitchen", "Baby safety gates", "Children\u2019s books and toys", "Stove", "Shampoo", "Babysitter recommendations", "Outlet covers", "Coffee maker", "Essentials", "Dishes an…	$220.00	2	14	2	2	14	14	2	14	t					Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	27			Mon Oct 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	4.88	4.88	4.64	4.92	4.88	4.79	4.75	0363 A942 21DC C431 1AD1	f	1	1		0.24
343094	https://www.airbnb.com/rooms/343094	20230309202119	Thu Mar 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	city scrape	Amstel Nest - an urban retreat for two	Amstel Nest is a stylish guest room for those who are looking for a quality accommodation. <br /><br />Located in the neighborhood of the Amstel river, adjacent to the popular district de Pijp, you can easily taste the authentic Amsterdam life and enjoy the great connectivity.<br /><br /><b>The spac…	From our place, you can easily take a stroll (20-25 minutes) or bike (8-10 minutes) along the Amstel river to the waterlooplein & center area. <br /><br />Located in the neighborhood of the Amstel river, adjacent to the popular district de Pijp, you can easily taste the authentic Amsterdam life and …	https://a0.muscache.com/pictures/4703255/285aabad_original.jpg	1740785	https://www.airbnb.com/users/show/1740785	Rob & Fang	Sun Feb 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	We are a family of 2 kids and 2 creative entrepreneurs, working at home with few independent projects. We love making 'slow coffee' with fresh grained coffee beans, and share it with our guests. We enjoy improvisational travels, and have tips about hidden treasures (café & boutique stores) in Amste…	within an hour	100%	100%	t	https://a0.muscache.com/im/pictures/user/1b70958a-abe7-47f8-995c-391afcea7310.jpg?aki_policy=profile_small	https://a0.muscache.com/im/pictures/user/1b70958a-abe7-47f8-995c-391afcea7310.jpg?aki_policy=profile_x_medium	Oosterparkbuurt	1	3	['email', 'phone']	t	t	Watergraafsmeer, North Holland, Netherlands	Oud-Oost	52.35715	4.90926	Private room in townhouse	Private room	2	1 private bath	1	1	["Lock on bedroom door", "Wifi", "Long term stays allowed", "Hangers", "Self check-in", "Lockbox", "Iron", "Refrigerator", "Hair dryer", "Hot water", "Luggage dropoff allowed", "Shampoo", "Heating", "Microwave", "Fire extinguisher", "Coffee maker", "Essentials", "Dishes and silverware", "Smoke alarm…	$108.00	3	30	1	7	4	1125	3.8	816.6	t	1	1	7	116	Thu Mar 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	462	56	2	Wed May 02 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.89	4.88	4.88	4.97	4.97	4.88	4.74	0363 FC71 F7DB 3AB4 3C42	t	1		1	3.5
20168	https://www.airbnb.com/rooms/20168	20230309202119	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	previous scrape	Studio with private bathroom in the centre 1	17th century Dutch townhouse in the heart of the city. no public transport needed! Located a stones throw from Rembrandt Square, Dam Square, Leidse Square and Flower Market. Walking distance from Central Station.<br />Comfortable, cosy, lockable studio with comfortable bed and with private bathroom,…	Located just in between famous central canals. In the streets surrounding the house, there are lots of antique shops, and for those who are into browsing for antiques. The Rijksmuseum is a short walk away. The famous nine-streets with all its little boutique shops, cafes, restaurants and whatnot is …	https://a0.muscache.com/pictures/69979628/fd6a3a80_original.jpg	59484	https://www.airbnb.com/users/show/59484	Alexander	Wed Dec 02 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	+ (Phone number hidden by Airbnb)	within an hour	100%	98%	f	https://a0.muscache.com/im/pictures/user/65092142-62d7-48a9-9479-ad5a24d99a77.jpg?aki_policy=profile_small	https://a0.muscache.com/im/pictures/user/65092142-62d7-48a9-9479-ad5a24d99a77.jpg?aki_policy=profile_x_medium	Grachtengordel	5	5	['email', 'phone']	t	t	Amsterdam, North Holland, Netherlands	Centrum-Oost	52.36407	4.89393	Private room in townhouse	Private room	2	1 private bath	1	1	["Carbon monoxide alarm", "Host greets you", "Wifi", "Long term stays allowed", "Hangers", "TV", "Paid parking off premises", "Refrigerator", "Free street parking", "Hair dryer", "Hot water", "Heating", "Bed linens", "Fire extinguisher", "Essentials", "Smoke alarm"]	$106.00	1	365	1	1	1125	1125	1	1125	t					Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	339			Tue Mar 02 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4.44	4.69	4.79	4.63	4.62	4.87	4.49	0363 CBB3 2C10 0C2A 1E29	t	2		2	2.14
350271	https://www.airbnb.com/rooms/350271	20230309202119	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	previous scrape	Luxe boat AMSTERDAM IJBURG!!!	28 december 2016 hebben wij veranderen onze locatie, nu zijn we in de beste een van de nieuwste wijk, buurt van Amsterdam, we zijn erg blij mee. Amsterdam IJBURG. is een hele rustig wijk, 14 min. in tram 26 vanaf Amsterdam Centraal Station. 25 min in de fiets naar Amsterdam Centraal Station en hebbe…	The boat is Amsterdam IJburg, quiet area compare to Amsterdam centrum but you are there in 15min. We are close (45km) from the biggest Natural Park of Europe (Oostvaardersplaats) and you are 15 min. By tram in Amsterdam centrum station. Little fishing town the green Marken is 25 km from here. Utrech…	https://a0.muscache.com/pictures/63320748/1c472b04_original.jpg	1775032	https://www.airbnb.com/users/show/1775032	Agustina	Sun Feb 19 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	Welcome to our ship 'De Zuiderzee' (1921). De Zuiderzee was re-built/renovated to meet all modern standards and is now a sailing, modern houseboat with place for 4 people. if you would like to stay in this old cargoship in the center of the Netherlands, please get in touch!	nan	nan	50%	f	https://a0.muscache.com/im/users/1775032/profile_pic/1329676993/original.jpg?aki_policy=profile_small	https://a0.muscache.com/im/users/1775032/profile_pic/1329676993/original.jpg?aki_policy=profile_x_medium	Oost	1	3	['email', 'phone']	t	t	Amsterdam, Noord-Holland, Netherlands	IJburg - Zeeburgereiland	52.36129	4.98845	Boat	Entire home/apt	4	1 bath	3	3	["Host greets you", "Wifi", "Washer", "Hair dryer", "Luggage dropoff allowed", "Outdoor furniture", "Bed linens", "Hot water", "Indoor fireplace: wood-burning", "Kitchen", "Dedicated workspace", "Children\u2019s books and toys", "Shampoo", "Coffee maker", "Essentials", "Dishes and silverware", "Smok…	$395.00	7	365	7	7	365	365	7	365	t					Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4	1		Wed Jul 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	4.33	5	4.67	5	5	5	4.33	0363 6334 AD6B 47DF B32A	f	1	1		0.04
357980	https://www.airbnb.com/rooms/357980	20230309202119	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	city scrape	★ STYLISH FAMILY HOME - CITY CENTER	Welcome to our lovely home! You've come to the right place to experience Amsterdam as it is - a stylish family home in a lovely neighboorhood in Amsterdam City Center.<br /><br /><b>The space</b><br />We offer a child friendly home (120ft²) that easily accomodates 3 adults and 3 children, or a maxim…	THE NEIGHBORHOOD:<br /><br />We are in the city centre in a quiet neighbourhood (Helmersbuurt). The neighbourhood is very popular and known for its nice bars, restaurants and plenty of facilities for families with children. Recently new (coffee) bars have been opened around the corner and across the…	https://a0.muscache.com/pictures/miso/Hosting-357980/original/3e3a9a36-afd3-4f4d-853b-afd82e3e7e16.jpeg	1811745	https://www.airbnb.com/users/show/1811745	Marre	Sun Feb 26 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	I am a mom of three and a web designer. We love living in the city in our spacious and cosy home in the middle of the city. I can't live without my family, friends, music, my IPhone and my home town Amsterdam. My style of travelling is 'live like the locals do' - try to get off the beaten track b…	within a few hours	100%	54%	f	https://a0.muscache.com/im/pictures/user/0d48c5ff-55bd-4d42-b452-9b73528b1d54.jpg?aki_policy=profile_small	https://a0.muscache.com/im/pictures/user/0d48c5ff-55bd-4d42-b452-9b73528b1d54.jpg?aki_policy=profile_x_medium	Oud-West	1	1	['email', 'phone', 'work_email']	t	t	Amsterdam, North Holland, Netherlands	De Baarsjes - Oud-West	52.36348	4.87648	Entire townhouse	Entire home/apt	4	1.5 baths	4	4	["Board games", "Children\u2019s dinnerware", "Room-darkening shades", "Hair dryer", "Luggage dropoff allowed", "Free washer \u2013 In unit", "Outdoor furniture", "Children\u2019s books and toys for ages 5-10 years old and 10+ years old", "Private backyard \u2013 Fully fenced", "Hot water", "Free dr…	$245.00	2	1125	2	2	1125	1125	2	1125	t	1	1	1	17	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	121	24	2	Thu Apr 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.88	4.89	4.83	4.93	4.97	4.95	4.75	0363 799F 0610 C059 F9F4	f	1	1		0.91
366438	https://www.airbnb.com/rooms/366438	20230309202119	Thu Mar 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	city scrape	Amsterdam@ city centre & canal view	Your own apartment for a couple of days in middle of city centre of Amsterdam!<br />Loft style apartment with two twinbeds, fully equipped kitchen, seperate bathroom and seperate toilet.<br /><br /><b>The space</b><br />Welcome! <br /><br />Our house is situated in heart of Amsterdam centre.<br />Yo…	Between Rembrandt square and Red Light district.<br />Perfect location for exploring the city and direct at canal.	https://a0.muscache.com/pictures/7cc382a6-37ee-446a-a16f-769dce0498fd.jpg	1849988	https://www.airbnb.com/users/show/1849988	Nicolet	Sat Mar 03 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Amsterdam, Netherlands	Hai, I am Nicolette, proud mom of 2 kids. Proud owner of Pancakes Amsterdam, a pancakes restaurant in the famous 9 streets & one across central station. And love our city Amsterdam, we welcome you in our Sous (basement)! Why Amsterdam? Because it is a cosy city, everything in walking distan…	within an hour	100%	100%	t	https://a0.muscache.com/im/users/1849988/profile_pic/1333540992/original.jpg?aki_policy=profile_small	https://a0.muscache.com/im/users/1849988/profile_pic/1333540992/original.jpg?aki_policy=profile_x_medium	Amsterdam Centrum	1	2	['email', 'phone']	t	t	Amsterdam, North Holland, Netherlands	Centrum-Oost	52.36737754954245	4.896707133551012	Private room in condo	Private room	2	1.5 baths	1	1	["Board games", "Host greets you", "Wifi", "Children\u2019s dinnerware", "Waterfront", "Hair dryer", "Bed linens", "Hot water", "Hot water kettle", "Single level home", "High chair", "Toaster", "Dining table", "Dedicated workspace", "Children\u2019s books and toys", "Babysitter recommendations", "Lo…	$170.00	3	60	2	3	60	60	2.8	60	t	12	14	22	162	Thu Mar 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	463	42	2	Tue Apr 10 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.74	4.82	4.74	4.84	4.88	4.92	4.63	0363 BD40 0F80 50E7 8478	f	1		1	3.48


CREATE TABLE listings_detailed (
  "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" VARCHAR,
  "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
);