#Airbnb
Find a neighborhood where you can sleep on a real bed in a villa with internet while paying the lowest price possible.
table name:airbnb_search_details
Solution:
select top 1 neighbourhood from airbnb_search_details where property_type='Villa'
and bed_type='Real Bed'
and amenities like '%internet%'
order by price
Output:
SQL Script:
USE [StrataScratch]
GO
CREATE TABLE [dbo].[airbnb_search_details](
[Unnamed:0:] [int] NULL,
[id] [int] NULL,
[price] [float] NULL,
[property_type] [varchar](50) NULL,
[room_type] [varchar](50) NULL,
[amenities] [varchar](max) NULL,
[accommodates] [int] NULL,
[bathrooms] [int] NULL,
[bed_type] [varchar](50) NULL,
[cancellation_policy] [varchar](500) NULL,
[cleaning_fee] [bit] NULL,
[city] [varchar](50) NULL,
[host_identity_verified] [varchar](50) NULL,
[host_response_rate] [varchar](50) NULL,
[host_since] [datetime] NULL,
[neighbourhood] [varchar](50) NULL,
[number_of_reviews] [int] NULL,
[review_scores_rating] [float] NULL,
[zipcode] [int] NULL,
[bedrooms] [int] NULL,
[beds] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (0, 12513361, 555.68, N'Apartment', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning","Smoke detector","Carbon monoxide detector",Essentials,"Lock on bedroom door",Hangers,Iron}', 2, 1, N'Real Bed', N'flexible', 0, N'NYC', N't', N'89%', CAST(N'2015-11-18T00:00:00.000' AS DateTime), N'East Harlem', 3, 87, 10029, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (1, 7196412, 366.36, N'Cabin', N'Private room', N'{"Wireless Internet",Kitchen,Washer,Dryer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,"Hair dryer","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 3, N'Real Bed', N'moderate', 0, N'LA', N'f', N'100%', CAST(N'2016-09-10T00:00:00.000' AS DateTime), N'Valley Glen', 14, 91, 91606, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (2, 16333776, 482.83, N'House', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises","Pets live on this property",Dog(s),"Indoor fireplace","Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Self Check-In",Lockbox}', 2, 1, N'Real Bed', N'strict', 1, N'SF', N't', N'100%', CAST(N'2013-12-26T00:00:00.000' AS DateTime), N'Richmond District', 117, 96, 94118, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (3, 1786412, 448.86, N'Apartment', N'Private room', N'{"Wireless Internet","Air conditioning",Kitchen,Heating,"Suitable for events","Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'93%', CAST(N'2010-05-11T00:00:00.000' AS DateTime), N'Williamsburg', 8, 86, 11211, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (4, 14575777, 506.89, N'Villa', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Essentials,Shampoo,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 6, 2, N'Real Bed', N'strict', 1, N'LA', N't', N'70%', CAST(N'2015-10-22T00:00:00.000' AS DateTime), N'', 2, 100, 90703, 3, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (5, 20515889, 720.79, N'Villa', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises","Pets allowed","Elevator in building","Hot tub","Indoor fireplace",Heating,"Family/kid friendly","Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo}', 8, 3, N'Real Bed', N'strict', 1, N'LA', N'f', N'20%', CAST(N'2014-05-26T00:00:00.000' AS DateTime), N'Topanga', 0, NULL, 90265, 3, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (6, 13783491, 516.48, N'Villa', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises","Pets allowed","Hot tub","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 2, 1, N'Real Bed', N'strict', 1, N'LA', N't', N'90%', CAST(N'2015-08-20T00:00:00.000' AS DateTime), N'Hollywood Hills', 1, 100, 90046, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (7, 6591755, 529.33, N'Villa', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Pets allowed","Pets live on this property","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 16, 3, N'Real Bed', N'strict', 1, N'LA', N't', N'91%', CAST(N'2016-01-16T00:00:00.000' AS DateTime), N'Long Beach', 88, 90, 90803, 4, 6)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (8, 5203241, 679.68, N'Villa', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,Gym,"Hot tub","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 6, 2, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2017-08-17T00:00:00.000' AS DateTime), N'Rancho Palos Verdes', 1, 100, 90275, 2, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (9, 11508891, 633.51, N'Villa', N'Entire home/apt', N'{TV,Internet,"Wireless Internet",Kitchen,"Free parking on premises",Heating,"Family/kid friendly",Washer,Dryer,Essentials,"24-hour check-in","Laptop friendly workspace","Self Check-In",Keypad}', 10, 2, N'Real Bed', N'strict', 1, N'LA', N't', N'94%', CAST(N'2015-08-12T00:00:00.000' AS DateTime), N'Malibu', 43, 92, 90265, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (10, 18823930, 485.98, N'Villa', N'Entire home/apt', N'{TV,Internet,"Wireless Internet",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Heating,"Family/kid friendly",Washer,Dryer,Essentials,"24-hour check-in",Hangers,Iron,"Laptop friendly workspace"}', 6, 1, N'Real Bed', N'moderate', 1, N'LA', N't', N'90%', CAST(N'2013-12-06T00:00:00.000' AS DateTime), N'Harbor Gateway', 27, 93, 90501, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (11, 15523281, 598.9, N'Villa', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Pool,Kitchen,"Free parking on premises",Gym,Breakfast,"Hot tub","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Private entrance"}', 4, 1, N'Real Bed', N'strict', 1, N'LA', N'f', N'100%', CAST(N'2014-05-20T00:00:00.000' AS DateTime), N'', 5, 88, 90704, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (12, 19698509, 741.76, N'Villa', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron}', 8, 4, N'Real Bed', N'super_strict_60', 1, N'LA', N't', N'100%', CAST(N'2015-01-05T00:00:00.000' AS DateTime), N'', 0, NULL, 90277, 4, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (13, 12497464, 431.75, N'Apartment', N'Private room', N'{"Wireless Internet",Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector"}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'', CAST(N'2014-01-14T00:00:00.000' AS DateTime), N'Crown Heights', 2, 80, 11238, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (14, 17764793, 469.13, N'Villa', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,"Pets live on this property",Dog(s),"Free parking on street","Hot tub",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2012-11-02T00:00:00.000' AS DateTime), N'Topanga', 6, 100, 91364, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (15, 11136854, 485.2, N'Villa', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Pets allowed",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In","Doorman Entry"}', 6, 1, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2014-08-12T00:00:00.000' AS DateTime), N'Temple City', 28, 96, 91780, 2, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (16, 15754561, 482.83, N'Apartment', N'Entire home/apt', N'{"Wireless Internet","Air conditioning",Kitchen,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Hangers,Iron,"Laptop friendly workspace"}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'100%', CAST(N'2017-06-07T00:00:00.000' AS DateTime), N'Bedford-Stuyvesant', 0, NULL, 11216, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (17, 4471474, 313.55, N'House', N'Shared room', N'{}', 1, 1, N'Real Bed', N'flexible', 1, N'LA', N't', N'100%', CAST(N'2013-12-20T00:00:00.000' AS DateTime), N'', 0, NULL, 91405, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (23, 18073864, 482.83, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises",Gym,"Hot tub",Heating,"Family/kid friendly",Washer,Dryer,Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer","translation missing: en.hosting_amenity_50"}', 4, 2, N'Real Bed', N'flexible', 1, N'LA', N't', N'100%', CAST(N'2012-09-27T00:00:00.000' AS DateTime), N'', 10, 90, 91302, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (26, 19161964, 391.2, N'House', N'Private room', N'{Internet,"Wireless Internet","Air conditioning","Free parking on premises","Hot tub","Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Shampoo,"Hair dryer",Iron}', 1, 1, N'Real Bed', N'flexible', 1, N'LA', N'f', N'', CAST(N'2016-07-14T00:00:00.000' AS DateTime), N'', 0, NULL, 90650, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (18, 13207484, 368.89, N'House', N'Shared room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Smoking allowed","Pets allowed","Pets live on this property",Dog(s),"Buzzer/wireless intercom",Heating,"Family/kid friendly","Suitable for events",Washer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 4, 1, N'Couch', N'strict', 1, N'LA', N't', N'25%', CAST(N'2016-12-05T00:00:00.000' AS DateTime), N'Hollywood', 0, NULL, 90028, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (19, 7837072, 336.73, N'House', N'Private room', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Indoor fireplace",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'moderate', 0, N'LA', N'f', N'98%', CAST(N'2017-07-02T00:00:00.000' AS DateTime), N'', 0, NULL, 91770, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (20, 7823396, 417.44, N'House', N'Private room', N'{TV,"Cable TV","Wireless Internet","Air conditioning",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection",Microwave,"Coffee maker",Refrigerator,"Dishes and silverware","Long term stays allowed","Wide doorway","Flat, smooth pathway to front door","Well-lit path to entrance","Step-free access","Wide clearance to bed","Step-free access","Wide entryway"}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'100%', CAST(N'2015-05-27T00:00:00.000' AS DateTime), N'Richmond Hill', 74, 96, 11419, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (21, 7966742, 423.41, N'House', N'Private room', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Indoor fireplace",Heating,Washer,Dryer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'100%', CAST(N'2012-06-27T00:00:00.000' AS DateTime), N'Bedford-Stuyvesant', 18, 89, 11221, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (22, 257568, 389.18, N'House', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Self Check-In",Keypad}', 3, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'100%', CAST(N'2013-04-20T00:00:00.000' AS DateTime), N'Astoria', 246, 90, 11106, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (24, 13667633, 541.61, N'House', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises","Pets live on this property",Dog(s),Heating,"Family/kid friendly","Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo}', 5, 2, N'Real Bed', N'flexible', 1, N'LA', N't', N'100%', CAST(N'2015-05-08T00:00:00.000' AS DateTime), N'Westchester/Playa Del Rey', 8, 94, 90045, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (25, 590903, 662.01, N'House', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In",Lockbox,"Private entrance"}', 6, 2, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2015-03-01T00:00:00.000' AS DateTime), N'Mid-Wilshire', 2, 100, 90048, 3, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (27, 19475815, 470.05, N'House', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets allowed",Breakfast,Heating,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Private living room"}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'60%', CAST(N'2015-11-14T00:00:00.000' AS DateTime), N'Astoria', 4, 93, 11106, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (28, 1407841, 412.71, N'House', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Breakfast,"Indoor fireplace",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2016-05-27T00:00:00.000' AS DateTime), N'Mar Vista', 18, 99, 90066, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (29, 1535628, 407.75, N'House', N'Private room', N'{"Wireless Internet",Kitchen,"Pets live on this property",Dog(s),Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Hangers,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 2, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'100%', CAST(N'2016-03-10T00:00:00.000' AS DateTime), N'Hunts Point', 4, 100, 10474, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (30, 6888244, 501.06, N'House', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Pool,Kitchen,"Pets allowed",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In",Lockbox,"Bed linens","Extra pillows and blankets"}', 2, 2, N'Real Bed', N'strict', 1, N'NYC', N't', N'100%', CAST(N'2011-03-25T00:00:00.000' AS DateTime), N'Carroll Gardens', 8, 83, 11231, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (31, 8889145, 539.36, N'House', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials}', 4, 2, N'Real Bed', N'moderate', 1, N'LA', N't', N'', CAST(N'2012-01-06T00:00:00.000' AS DateTime), N'Studio City', 0, NULL, 91604, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (32, 15073872, 474.49, N'House', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Gym,"Pets live on this property",Dog(s),Cat(s),Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 4, 1, N'Real Bed', N'flexible', 0, N'LA', N't', N'100%', CAST(N'2013-03-06T00:00:00.000' AS DateTime), N'Studio City', 6, 100, 91604, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (33, 10174146, 695.65, N'House', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises","Hot tub","Indoor fireplace",Heating,"Family/kid friendly","Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Shampoo}', 9, 4, N'Real Bed', N'moderate', 1, N'LA', N't', N'83%', CAST(N'2015-08-09T00:00:00.000' AS DateTime), N'', 1, 100, 90048, 5, 5)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (34, 12600300, 424.85, N'House', N'Private room', N'{"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer","Laptop friendly workspace","translation missing: en.hosting_amenity_50","Self Check-In",Keypad}', 4, 2, N'Real Bed', N'strict', 1, N'NYC', N'f', N'99%', CAST(N'2017-05-06T00:00:00.000' AS DateTime), N'Flushing', 12, 93, 11355, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (66, 5792141, 486.75, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector",Hangers,"Hair dryer",Iron}', 4, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'80%', CAST(N'2010-12-03T00:00:00.000' AS DateTime), N'Harlem', 85, 90, 10027, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (67, 6390069, 570.38, N'Apartment', N'Entire home/apt', N'{TV,"Wireless Internet",Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Essentials,"Laptop friendly workspace"}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'', CAST(N'2011-01-17T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10027, 2, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (35, 62427, 667.83, N'Villa', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises",Gym,"Indoor fireplace",Heating,"Family/kid friendly","Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In","Doorman Entry"}', 12, 4, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2011-09-28T00:00:00.000' AS DateTime), N'Topanga', 32, 99, 90290, 4, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (36, 5447656, 417.44, N'House', N'Private room', N'{TV,"Cable TV","Wireless Internet","Air conditioning",Kitchen,"Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Hangers,"Hair dryer",Iron}', 2, 1, N'Real Bed', N'flexible', 1, N'DC', N't', N'100%', CAST(N'2011-03-25T00:00:00.000' AS DateTime), N'Logan Circle', 7, 97, 20005, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (37, 2974433, 529.33, N'House', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises","Hot tub",Heating,"Family/kid friendly","Suitable for events","Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo}', 4, 1, N'Real Bed', N'strict', 0, N'LA', N't', N'100%', CAST(N'2011-11-28T00:00:00.000' AS DateTime), N'Long Beach', 109, 97, 90803, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (38, 17010314, 430.41, N'House', N'Private room', N'{"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises","Pets allowed","Pets live on this property",Dog(s),Cat(s),"Other pet(s)",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer","Laptop friendly workspace","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2013-03-06T00:00:00.000' AS DateTime), N'', 33, 99, 91506, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (39, 20167264, 385.01, N'House', N'Private room', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 1, 1, N'Real Bed', N'flexible', 1, N'Boston', N't', N'100%', CAST(N'2013-03-06T00:00:00.000' AS DateTime), N'Dorchester', 220, 98, 2125, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (40, 4156913, 570.38, N'House', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Pets allowed",Heating,"Family/kid friendly","Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Hangers,"Hair dryer","Laptop friendly workspace"}', 6, 2, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'100%', CAST(N'2016-05-30T00:00:00.000' AS DateTime), N'The Rockaways', 2, 100, 11509, 4, 5)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (41, 11993790, 602.83, N'House', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Breakfast,"Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance","Childrens books and toys","Fireplace guards",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove}', 7, 2, N'Real Bed', N'strict', 1, N'NYC', N'f', N'100%', CAST(N'2017-05-06T00:00:00.000' AS DateTime), N'Windsor Terrace', 0, NULL, 11218, 5, 5)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (42, 10989476, 455.39, N'House', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,"24-hour check-in",Hangers,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Bed linens"}', 2, 1, N'Real Bed', N'moderate', 1, N'SF', N't', N'100%', CAST(N'2013-04-20T00:00:00.000' AS DateTime), N'Bernal Heights', 28, 98, 94110, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (43, 7939396, 459.51, N'Villa', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Pets allowed",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher","24-hour check-in",Hangers,"Hair dryer"}', 6, 1, N'Real Bed', N'strict', 1, N'LA', N't', N'91%', CAST(N'2014-01-16T00:00:00.000' AS DateTime), N'Long Beach', 120, 89, 90803, 2, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (44, 17840858, 529.83, N'House', N'Private room', N'{"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,"Hot tub",Heating,"Smoke detector",Essentials}', 2, 1, N'Real Bed', N'moderate', 1, N'LA', N'f', N'', CAST(N'2015-03-10T00:00:00.000' AS DateTime), N'Mid-Wilshire', 0, NULL, 90048, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (45, 2444713, 506.89, N'House', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2014-06-20T00:00:00.000' AS DateTime), N'Echo Park', 117, 98, 90039, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (46, 13276443, 470.05, N'House', N'Private room', N'{"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Indoor fireplace",Washer,"Smoke detector","Carbon monoxide detector","First aid kit",Shampoo}', 2, 1, N'Real Bed', N'flexible', 0, N'SF', N't', N'', CAST(N'2013-05-15T00:00:00.000' AS DateTime), N'Russian Hill', 2, 100, 94109, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (47, 19947454, 459.51, N'Apartment', N'Private room', N'{TV,Internet,"Wireless Internet",Kitchen,"Free parking on premises","Hot tub",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'flexible', 1, N'LA', N't', N'100%', CAST(N'2014-04-14T00:00:00.000' AS DateTime), N'Westwood', 10, 98, 90024, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (48, 13653016, 417.44, N'Other', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning","Smoking allowed",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher","24-hour check-in"}', 3, 1, N'Real Bed', N'strict', 0, N'LA', N'f', N'100%', CAST(N'2016-11-28T00:00:00.000' AS DateTime), N'', 1, 20, 90731, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (49, 20942873, 480.4, N'Condominium', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises","Indoor fireplace",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Self Check-In",Lockbox}', 2, 1, N'Real Bed', N'flexible', 0, N'LA', N't', N'80%', CAST(N'2013-09-13T00:00:00.000' AS DateTime), N'Santa Monica', 28, 96, 90405, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (50, 19583726, 552.15, N'Condominium', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 4, 2, N'Real Bed', N'moderate', 0, N'Boston', N'f', N'', CAST(N'2015-06-08T00:00:00.000' AS DateTime), N'South Boston', 15, 97, 2127, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (54, 4454031, 685.65, N'House', N'Entire home/apt', N'{TV,Internet,"Wireless Internet",Kitchen,"Free parking on premises","Pets live on this property","Other pet(s)",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Hair dryer"}', 6, 2, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2014-10-08T00:00:00.000' AS DateTime), N'', 6, 100, 90266, 4, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (56, 20282225, 507.52, N'Apartment', N'Private room', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer","Laptop friendly workspace"}', 2, 1, N'Real Bed', N'moderate', 1, N'Boston', N'f', N'100%', CAST(N'2014-07-14T00:00:00.000' AS DateTime), N'Dorchester', 1, 100, 2125, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (59, 6391342, 417.44, N'House', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Breakfast,"Indoor fireplace","Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Iron}', 2, 1, N'Real Bed', N'strict', 1, N'LA', N'f', N'100%', CAST(N'2014-06-24T00:00:00.000' AS DateTime), N'Westlake', 36, 96, 90005, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (51, 17196103, 482.83, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Elevator in building","Indoor fireplace","Buzzer/wireless intercom",Heating,Washer,Dryer,Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 4, 1, N'Real Bed', N'moderate', 1, N'LA', N't', N'89%', CAST(N'2009-12-25T00:00:00.000' AS DateTime), N'Marina Del Rey', 11, 91, 90292, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (52, 9318115, 680.13, N'House', N'Entire home/apt', N'{Internet,"Wireless Internet",Kitchen,"Free parking on premises","Pets allowed","Indoor fireplace",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer","Laptop friendly workspace","Private entrance"}', 5, 1, N'Real Bed', N'strict', 1, N'LA', N'f', N'100%', CAST(N'2016-06-13T00:00:00.000' AS DateTime), N'Malibu', 0, NULL, 90265, 3, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (53, 9937434, 497.67, N'Apartment', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50","Self Check-In",Keypad}', 2, 1, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2016-03-23T00:00:00.000' AS DateTime), N'Hermosa Beach', 1, 60, 90254, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (55, 16259866, 361.09, N'House', N'Private room', N'{"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,"Lock on bedroom door",Hangers,"Laptop friendly workspace","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'flexible', 0, N'NYC', N'f', N'100%', CAST(N'2016-01-11T00:00:00.000' AS DateTime), N'East New York', 14, 85, 11208, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (57, 23269, 519.3, N'Condominium', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning","Wheelchair accessible",Kitchen,"Free parking on premises",Gym,"Pets live on this property","Elevator in building",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 6, 2, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2015-11-29T00:00:00.000' AS DateTime), N'', 10, 100, 90802, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (58, 7637363, 661.87, N'House', N'Entire home/apt', N'{TV,"Wireless Internet",Pool,Kitchen,"Free parking on premises","Hot tub","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50"}', 8, 3, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2014-01-12T00:00:00.000' AS DateTime), N'Manhattan Beach', 5, 96, 90266, 4, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (60, 11606802, 455.39, N'House', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Pets allowed",Breakfast,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance"}', 5, 1, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2016-06-22T00:00:00.000' AS DateTime), N'Westlake', 45, 97, 90015, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (61, 12289125, 486.75, N'House', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,Breakfast,"Indoor fireplace","Buzzer/wireless intercom",Heating,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,Hangers,Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 6, 2, N'Real Bed', N'strict', 1, N'LA', N't', N'80%', CAST(N'2014-02-02T00:00:00.000' AS DateTime), N'Westlake', 31, 95, 90057, 2, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (62, 19875244, 630.99, N'Condominium', N'Entire home/apt', N'{TV,"Cable TV","Wireless Internet","Air conditioning",Kitchen,Breakfast,"Indoor fireplace","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 6, 2, N'Real Bed', N'flexible', 1, N'Chicago', N't', N'100%', CAST(N'2010-09-27T00:00:00.000' AS DateTime), N'Lakeview', 0, NULL, 60657, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (63, 392794, 270.81, N'House', N'Shared room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 4, 1, N'Real Bed', N'strict', 0, N'LA', N't', N'99%', CAST(N'2016-03-27T00:00:00.000' AS DateTime), N'Westlake', 35, 85, 90006, 1, 10)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (64, 992786, 474.49, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets allowed","Pets live on this property",Dog(s),"Buzzer/wireless intercom",Heating,"Smoke detector","First aid kit","Safety card",Essentials,Shampoo,"24-hour check-in",Hangers,Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'67%', CAST(N'2012-02-04T00:00:00.000' AS DateTime), N'Harlem', 21, 96, 10035, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (65, 13650177, 438.2, N'Apartment', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning","Wheelchair accessible",Kitchen,Elevator,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,Hangers,Iron,"Laptop friendly workspace","Hot water","Bed linens",Microwave,"Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove}', 2, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'100%', CAST(N'2015-07-04T00:00:00.000' AS DateTime), N'Harlem', 2, 100, 10030, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (68, 8579757, 501.06, N'Condominium', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Elevator,Heating,"Family/kid friendly","Suitable for events","Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron}', 5, 1, N'Real Bed', N'moderate', 0, N'NYC', N'f', N'93%', CAST(N'2017-01-05T00:00:00.000' AS DateTime), N'Harlem', 2, 90, 10039, 2, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (69, 14115855, 448.86, N'Apartment', N'Private room', N'{TV,"Wireless Internet",Kitchen,Washer,Dryer,"Smoke detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Bed linens","Extra pillows and blankets"}', 2, 1, N'Real Bed', N'moderate', 0, N'NYC', N'f', N'100%', CAST(N'2013-08-10T00:00:00.000' AS DateTime), N'Harlem', 8, 100, 10031, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (70, 685364, 478.75, N'Apartment', N'Entire home/apt', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,"Hot tub","Buzzer/wireless intercom",Heating}', 3, 1, N'Real Bed', N'moderate', 0, N'NYC', N't', N'100%', CAST(N'2012-05-12T00:00:00.000' AS DateTime), N'Harlem', 7, 100, 10035, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (71, 20031027, 409.43, N'Apartment', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,"Smoking allowed","Pets allowed",Heating,"Smoke detector","Carbon monoxide detector",Essentials,"Lock on bedroom door",Hangers,Iron,"Laptop friendly workspace","Private living room"}', 2, 1, N'Real Bed', N'flexible', 1, N'NYC', N'f', N'100%', CAST(N'2014-12-16T00:00:00.000' AS DateTime), N'Harlem', 4, 100, 10030, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (72, 2399406, 389.18, N'Apartment', N'Private room', N'{"Wireless Internet",Kitchen,"Pets allowed",Breakfast,Elevator,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'flexible', 0, N'NYC', N'f', N'100%', CAST(N'2016-02-28T00:00:00.000' AS DateTime), N'Harlem', 12, 92, 10030, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (73, 15991936, 551.75, N'Apartment', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In",Keypad,"Private living room","High chair","Childrens books and toys","Window guards",Crib,"Packn Play/travel crib","Childrens dinnerware","Hot water","Bed linens","Extra pillows and blankets","Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Luggage dropoff allowed","Long term stays allowed","Wide hallway clearance","Wide doorway","Well-lit path to entrance"}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2013-09-20T00:00:00.000' AS DateTime), N'Harlem', 19, 99, 10027, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (74, 17497415, 404.31, N'Apartment', N'Shared room', N'{"Wireless Internet",Kitchen,Elevator,"Family/kid friendly","Smoke detector",Essentials,Shampoo,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'flexible', 1, N'NYC', N't', N'22%', CAST(N'2016-10-08T00:00:00.000' AS DateTime), N'Harlem', 6, 84, 10027, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (75, 5321538, 674.52, N'Townhouse', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Indoor fireplace","Smoke detector","Carbon monoxide detector","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 8, 1, N'Real Bed', N'flexible', 1, N'NYC', N'f', N'100%', CAST(N'2013-09-13T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10027, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (76, 6228461, 409.43, N'Apartment', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Breakfast,"Pets live on this property",Cat(s),"Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove}', 2, 1, N'Real Bed', N'flexible', 1, N'NYC', N't', N'100%', CAST(N'2013-03-19T00:00:00.000' AS DateTime), N'Harlem', 7, 97, 10030, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (77, 12954602, 465.4, N'Loft', N'Entire home/apt', N'{Internet,"Wireless Internet","Free parking on premises",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In",Lockbox}', 3, 1, N'Real Bed', N'moderate', 1, N'LA', N'f', N'100%', CAST(N'2015-11-14T00:00:00.000' AS DateTime), N'Westside', 43, 97, 90064, 0, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (78, 15409556, 355.53, N'House', N'Private room', N'{"Family/kid friendly","Smoke detector"}', 2, 1, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2015-12-14T00:00:00.000' AS DateTime), N'Hawthorne', 5, 92, 90250, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (79, 14057888, 494.16, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV","Wireless Internet","Air conditioning","Wheelchair accessible",Kitchen,Doorman,Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,Hangers,Iron,"translation missing: en.hosting_amenity_50"}', 4, 1, N'Real Bed', N'flexible', 1, N'NYC', N't', N'100%', CAST(N'2013-05-20T00:00:00.000' AS DateTime), N'Harlem', 16, 91, 10037, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (80, 21005590, 444.27, N'Apartment', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,"Smoking allowed","Pets allowed",Elevator,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron}', 3, 1, N'Real Bed', N'flexible', 0, N'NYC', N't', N'', CAST(N'2016-03-20T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10039, 2, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (81, 4698479, 510.59, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning","Wheelchair accessible",Kitchen,Gym,Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card",Shampoo,Hangers,"Hair dryer","Laptop friendly workspace"}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'', CAST(N'2015-12-10T00:00:00.000' AS DateTime), N'Harlem', 5, 100, 10026, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (82, 6661783, 448.86, N'Apartment', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace",Other}', 2, 2, N'Real Bed', N'flexible', 1, N'NYC', N't', N'100%', CAST(N'2014-04-26T00:00:00.000' AS DateTime), N'Harlem', 28, 91, 10027, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (83, 2243670, 519.3, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,Iron,"Laptop friendly workspace"}', 3, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'90%', CAST(N'2013-03-05T00:00:00.000' AS DateTime), N'Harlem', 15, 97, 10027, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (84, 5059214, 431.75, N'Apartment', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Laptop friendly workspace","Private living room"}', 1, 3, N'Real Bed', N'strict', 0, N'NYC', N'f', N'', CAST(N'2014-03-14T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10030, 2, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (85, 20556938, 438.2, N'Apartment', N'Private room', N'{TV,Washer,"Cable TV",Dryer,Internet,"Smoke detector","Wireless Internet","Carbon monoxide detector","Air conditioning",Kitchen,Essentials,"Lock on bedroom door",Hangers,"Hair dryer",Doorman,"Laptop friendly workspace","translation missing: en.hosting_amenity_49",Elevator,"Private living room",Heating}', 2, 1, N'Real Bed', N'strict', 0, N'NYC', N'f', N'100%', CAST(N'2016-04-12T00:00:00.000' AS DateTime), N'Harlem', 41, 94, 10029, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (86, 10165064, 431.75, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Gym,Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Hair dryer",Iron,"Laptop friendly workspace"}', 3, 1, N'Real Bed', N'flexible', 0, N'NYC', N't', N'', CAST(N'2016-11-02T00:00:00.000' AS DateTime), N'Harlem', 1, 100, 10039, 2, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (87, 7359527, 434.38, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Breakfast,"Buzzer/wireless intercom",Heating,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo}', 2, 1, N'Real Bed', N'flexible', 0, N'NYC', N'f', N'', CAST(N'2015-04-08T00:00:00.000' AS DateTime), N'Harlem', 1, 100, 10030, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (88, 4902799, 621.26, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning","Wheelchair accessible",Kitchen,Elevator,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo}', 4, 2, N'Real Bed', N'strict', 1, N'NYC', N't', N'', CAST(N'2011-12-23T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10026, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (90, 10869168, 552.15, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Dryer,"Smoke detector",Essentials,Shampoo,"Hair dryer",Iron}', 7, 1, N'Real Bed', N'strict', 1, N'NYC', N'f', N'90%', CAST(N'2013-01-01T00:00:00.000' AS DateTime), N'Harlem', 29, 88, 10027, 3, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (91, 7591555, 424.85, N'Apartment', N'Entire home/apt', N'{"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Hair dryer",Iron,"Laptop friendly workspace"}', 2, 1, N'Real Bed', N'flexible', 1, N'NYC', N'f', N'38%', CAST(N'2013-06-02T00:00:00.000' AS DateTime), N'Harlem', 7, 95, 10039, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (89, 20976767, 431.75, N'Apartment', N'Shared room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_50"}', 2, 1, N'Pull-out Sofa', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2013-03-19T00:00:00.000' AS DateTime), N'Harlem', 30, 94, 10026, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (92, 15454112, 459.51, N'House', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Private entrance"}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2014-06-30T00:00:00.000' AS DateTime), N'Harlem', 73, 94, 10030, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (93, 16662334, 400.73, N'House', N'Private room', N'{"Wireless Internet",Kitchen,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'flexible', 1, N'LA', N't', N'100%', CAST(N'2014-09-20T00:00:00.000' AS DateTime), N'Gardena', 6, 97, 90249, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (94, 19118005, 552.15, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating}', 2, 1, N'Real Bed', N'strict', 0, N'NYC', N't', N'0%', CAST(N'2009-11-12T00:00:00.000' AS DateTime), N'Alphabet City', 11, 93, 10009, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (95, 11972209, 548.06, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance",Bathtub,"Baby bath","High chair","Childrens books and toys","Packn Play/travel crib","Childrens dinnerware"}', 7, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'100%', CAST(N'2014-01-29T00:00:00.000' AS DateTime), N'East Harlem', 140, 94, 10029, 3, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (96, 8284881, 621.46, N'House', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises",Gym,"Hot tub","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 8, 3, N'Real Bed', N'strict', 1, N'LA', N'f', N'100%', CAST(N'2016-11-01T00:00:00.000' AS DateTime), N'Pacific Palisades', 1, NULL, 90272, 4, 6)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (97, 14276565, 486.75, N'Apartment', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 4, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'87%', CAST(N'2014-01-22T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10027, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (98, 10923708, 340.12, N'Apartment', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets live on this property",Cat(s),"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials}', 1, 1, N'Real Bed', N'strict', 0, N'NYC', N't', N'100%', CAST(N'2014-06-30T00:00:00.000' AS DateTime), N'Harlem', 166, 91, 10031, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (99, 1998513, 438.2, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets allowed",Elevator,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Shampoo,"Self Check-In",Lockbox}', 2, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'80%', CAST(N'2013-12-21T00:00:00.000' AS DateTime), N'Harlem', 11, 87, 10027, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (100, 18211034, 449.98, N'Apartment', N'Private room', N'{"Wireless Internet",Kitchen,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,"Lock on bedroom door","Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'flexible', 0, N'NYC', N'f', N'', CAST(N'2016-01-07T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10030, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (101, 13041230, 431.75, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Wheelchair accessible",Kitchen,"Free parking on premises",Elevator,"Hot tub","Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,Iron,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 3, 1, N'Real Bed', N'flexible', 1, N'NYC', N't', N'', CAST(N'2013-12-21T00:00:00.000' AS DateTime), N'Harlem', 31, 87, 10027, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (102, 8256789, 552.15, N'Apartment', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Elevator,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Hair dryer",Iron}', 4, 2, N'Real Bed', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2015-10-02T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10027, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (103, 16354537, 478.75, N'Apartment', N'Private room', N'{"Wireless Internet","Air conditioning",Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Bed linens"}', 2, 1, N'Real Bed', N'strict', 0, N'NYC', N't', N'100%', CAST(N'2013-12-21T00:00:00.000' AS DateTime), N'Harlem', 14, 99, 10027, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (104, 7347593, 504.34, N'House', N'Private room', N'{TV,Internet,"Wireless Internet",Kitchen,"Smoking allowed","Indoor fireplace","Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In",Lockbox,"Hot water","Private bathroom","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"BBQ grill","Patio or balcony","Garden or backyard","Luggage dropoff allowed","Cleaning before checkout","Wide hallway clearance","Wide doorway","Wide doorway","Wide clearance to bed","Step-free access","Wide doorway","Fixed grab bars for shower & toilet","Accessible-height toilet","Wide clearance to shower & toilet","Step-free access","Wide entryway"}', 4, 1, N'Real Bed', N'strict', 0, N'NYC', N't', N'100%', CAST(N'2013-12-11T00:00:00.000' AS DateTime), N'Harlem', 14, 89, 10037, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (105, 17009057, 552.15, N'House', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_50","Self Check-In",Lockbox}', 4, 2, N'Real Bed', N'moderate', 1, N'SF', N't', N'80%', CAST(N'2014-02-23T00:00:00.000' AS DateTime), N'Bernal Heights', 25, 98, 94110, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (106, 18333003, 570.04, N'Apartment', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Pool,Kitchen,Gym,"Elevator in building",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials,Shampoo,Hangers,"Laptop friendly workspace","Private living room"}', 4, 2, N'Real Bed', N'flexible', 0, N'Chicago', N'f', N'80%', CAST(N'2015-06-30T00:00:00.000' AS DateTime), N'Loop', 0, NULL, 60606, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (107, 16274069, 482.83, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit",Essentials}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'100%', CAST(N'2014-02-11T00:00:00.000' AS DateTime), N'Bedford-Stuyvesant', 13, 92, 11216, 2, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (108, 20049857, 474.49, N'Apartment', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector",Essentials,Hangers,"Hair dryer","Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'moderate', 1, N'LA', N'f', N'', CAST(N'2017-10-07T00:00:00.000' AS DateTime), N'West Hollywood', 0, NULL, 90046, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (109, 18157879, 570.38, N'House', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Breakfast,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 7, 2, N'Real Bed', N'strict', 1, N'Chicago', N't', N'', CAST(N'2016-01-20T00:00:00.000' AS DateTime), N'Lincoln Park', 9, 98, 60614, 3, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (110, 17666136, 538.91, N'Apartment', N'Entire home/apt', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'', CAST(N'2014-11-17T00:00:00.000' AS DateTime), N'East Village', 1, 100, 10003, 2, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (111, 2135314, 519.3, N'Loft', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Doorman,Elevator,"Hot tub","Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo}', 2, 1, N'Real Bed', N'strict', 0, N'NYC', N'f', N'', CAST(N'2015-07-09T00:00:00.000' AS DateTime), N'East Village', 3, 87, 10003, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (112, 5321584, 717.01, N'House', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 8, 2, N'Real Bed', N'strict', 1, N'SF', N't', N'', CAST(N'2014-09-20T00:00:00.000' AS DateTime), N'Hayes Valley', 4, 100, 94102, 4, 5)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (113, 13121821, 501.06, N'Apartment', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector","First aid kit",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 1, 1, N'Real Bed', N'flexible', 0, N'NYC', N'f', N'', CAST(N'2014-09-20T00:00:00.000' AS DateTime), N'Park Slope', 0, NULL, 11215, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (114, 12282255, 449.98, N'Apartment', N'Entire home/apt', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets allowed","Family/kid friendly","Smoke detector","Fire extinguisher",Shampoo}', 3, 1, N'Real Bed', N'strict', 0, N'NYC', N't', N'100%', CAST(N'2015-04-23T00:00:00.000' AS DateTime), N'Harlem', 23, 94, 10030, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (115, 6630775, 504.34, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets live on this property",Dog(s),Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_50","Self Check-In","Smart lock"}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2014-06-30T00:00:00.000' AS DateTime), N'Harlem', 40, 97, 10030, 1, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (116, 9479348, 598.9, N'Apartment', N'Entire home/apt', N'{"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,Iron,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 7, 2, N'Real Bed', N'strict', 0, N'NYC', N'f', N'100%', CAST(N'2017-07-03T00:00:00.000' AS DateTime), N'Hell''s Kitchen', 1, 60, 10036, 3, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (117, 3710477, 674.52, N'House', N'Entire home/apt', N'{TV,"Cable TV","Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In",Lockbox,"Private entrance","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove}', 14, 2, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'100%', CAST(N'2017-10-07T00:00:00.000' AS DateTime), N'Astoria', 0, NULL, 11103, 6, 8)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (118, 13978228, 578.38, N'House', N'Entire home/apt', N'{"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed","Hot tub","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","First aid kit",Essentials,Hangers,"Hair dryer","Laptop friendly workspace"}', 4, 3, N'Real Bed', N'flexible', 0, N'LA', N't', N'100%', CAST(N'2015-08-05T00:00:00.000' AS DateTime), N'Mount Washington', 0, NULL, 90065, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (119, 16028615, 487.52, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning","Wheelchair accessible",Pool,Kitchen,Gym,"Elevator in building","Hot tub","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 4, 2, N'Real Bed', N'moderate', 1, N'Chicago', N't', N'100%', CAST(N'2016-09-02T00:00:00.000' AS DateTime), N'Loop', 1, 100, 60605, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (120, 15027031, 548.06, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets live on this property",Cat(s),"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 3, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'100%', CAST(N'2014-09-20T00:00:00.000' AS DateTime), N'Alphabet City', 12, 98, 10009, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (121, 19245819, 424.85, N'Apartment', N'Private room', N'{Internet,"Wireless Internet",Kitchen,"Pets live on this property",Dog(s),Washer,Dryer,"Smoke detector","Fire extinguisher"}', 1, 1, N'Real Bed', N'moderate', 0, N'SF', N't', N'', CAST(N'2010-03-16T00:00:00.000' AS DateTime), N'Mission District', 12, 90, 94110, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (122, 10770929, 561.68, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Hangers,"Hair dryer",Iron}', 8, 2, N'Real Bed', N'strict', 1, N'NYC', N't', N'100%', CAST(N'2014-06-30T00:00:00.000' AS DateTime), N'Harlem', 28, 92, 10026, 2, 5)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (123, 12592005, 524.7, N'Apartment', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'90%', CAST(N'2017-07-06T00:00:00.000' AS DateTime), N'Harlem', 10, 100, 10039, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (124, 1174876, 424.85, N'House', N'Private room', N'{"Wireless Internet","Air conditioning","Pets live on this property",Dog(s),Cat(s),Heating,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'strict', 0, N'NYC', N't', N'100%', CAST(N'2015-06-10T00:00:00.000' AS DateTime), N'Harlem', 69, 93, 10027, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (125, 20888646, 423.41, N'House', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Private living room","Private entrance"}', 2, 1, N'Real Bed', N'flexible', 1, N'LA', N'f', N'98%', CAST(N'2016-11-20T00:00:00.000' AS DateTime), N'Canoga Park', 4, 100, 91303, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (130, 11157369, 409.43, N'Apartment', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,Essentials,Shampoo,Iron,"Laptop friendly workspace"}', 1, 1, N'Real Bed', N'flexible', 1, N'NYC', N't', N'', CAST(N'2014-06-30T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10026, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (131, 15705947, 478.75, N'Apartment', N'Entire home/apt', N'{"Wireless Internet","Air conditioning",Kitchen,"Family/kid friendly","Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card",Essentials,Shampoo,"Hair dryer",Iron,"Laptop friendly workspace"}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'80%', CAST(N'2015-07-09T00:00:00.000' AS DateTime), N'Upper East Side', 7, 90, 10065, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (132, 11456592, 529.83, N'Loft', N'Private room', N'{"Wireless Internet","Air conditioning","Free parking on premises",Breakfast,Heating,Essentials,"Lock on bedroom door","Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'moderate', 0, N'NYC', N'f', N'100%', CAST(N'2011-02-23T00:00:00.000' AS DateTime), N'Williamsburg', 0, NULL, 11211, 0, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (126, 7834158, 599.15, N'Villa', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises","Indoor fireplace","Buzzer/wireless intercom",Heating,"Family/kid friendly","Suitable for events",Washer,Dryer,"Smoke detector",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 10, 4, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2014-08-21T00:00:00.000' AS DateTime), N'Redondo Beach', 39, 94, 90278, 4, 5)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (127, 6692191, 423.41, N'House', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 1, 2, N'Real Bed', N'flexible', 0, N'LA', N't', N'100%', CAST(N'2013-09-13T00:00:00.000' AS DateTime), N'Westlake', 9, 100, 90015, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (128, 8084290, 497.67, N'Condominium', N'Entire home/apt', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Breakfast,Elevator,Heating,"Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Private entrance",Bathtub,"Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Step-free access","Flat, smooth pathway to front door","Host greets you"}', 4, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2012-05-09T00:00:00.000' AS DateTime), N'Harlem', 7, 94, 10027, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (129, 6689195, 433.07, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,Gym,"Pets live on this property",Cat(s),"Buzzer/wireless intercom","Family/kid friendly",Washer,Dryer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 4, 1, N'Real Bed', N'strict', 0, N'LA', N't', N'', CAST(N'2013-05-30T00:00:00.000' AS DateTime), N'Burbank', 1, NULL, 91504, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (133, 1077375, 400.73, N'Apartment', N'Private room', N'{"Wireless Internet",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,Hangers,Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_50"}', 1, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'', CAST(N'2015-04-04T00:00:00.000' AS DateTime), N'Sunset Park', 1, 100, 11220, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (134, 17681277, 529.83, N'Apartment', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Indoor fireplace",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo}', 2, 1, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2011-04-07T00:00:00.000' AS DateTime), N'Echo Park', 0, NULL, 90026, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (135, 10842610, 519.3, N'Apartment', N'Entire home/apt', N'{"Wireless Internet",Kitchen,"Free parking on premises","Pets allowed",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 6, 1, N'Real Bed', N'flexible', 1, N'NYC', N't', N'100%', CAST(N'2012-07-07T00:00:00.000' AS DateTime), N'The Rockaways', 5, 100, 11692, 3, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (136, 8881130, 448.86, N'House', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Pets allowed","Pets live on this property",Heating,"Family/kid friendly",Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Hair dryer",Iron}', 2, 1, N'Real Bed', N'strict', 1, N'LA', N't', N'100%', CAST(N'2011-03-25T00:00:00.000' AS DateTime), N'Woodland Hills/Warner Center', 17, 98, 91364, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (137, 14236545, 490.53, N'Apartment', N'Private room', N'{"Wireless Internet",Heating,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'strict', 1, N'Boston', N't', N'100%', CAST(N'2014-12-23T00:00:00.000' AS DateTime), N'Dorchester', 7, 83, 2125, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (138, 14219018, 444.27, N'Apartment', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Gym,"Buzzer/wireless intercom",Heating,"Family/kid friendly","translation missing: en.hosting_amenity_50",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove}', 2, 1, N'Real Bed', N'strict', 1, N'NYC', N't', N'89%', CAST(N'2013-06-07T00:00:00.000' AS DateTime), N'Harlem', 97, 91, 10027, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (139, 8596057, 420.47, N'House', N'Private room', N'{"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises",Breakfast,"Family/kid friendly",Washer,Dryer,Essentials,Shampoo,Hangers,"Hair dryer","Self Check-In","Doorman Entry"}', 1, 2, N'Real Bed', N'flexible', 0, N'LA', N'f', N'100%', CAST(N'2016-04-20T00:00:00.000' AS DateTime), N'', 0, NULL, 91748, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (140, 11525500, 478.75, N'Apartment', N'Entire home/apt', N'{"Wireless Internet","Air conditioning",Heating,Washer,Dryer,Essentials,"Laptop friendly workspace",Microwave,Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Host greets you"}', 2, 1, N'Real Bed', N'flexible', 1, N'NYC', N'f', N'100%', CAST(N'2017-10-07T00:00:00.000' AS DateTime), N'Williamsburg', 2, 100, 11206, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (141, 533884, 662.01, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets allowed",Heating,"Family/kid friendly",Washer,Dryer,Shampoo,"24-hour check-in",Hangers,"Hair dryer","Laptop friendly workspace"}', 6, 1, N'Real Bed', N'flexible', 0, N'SF', N'f', N'', CAST(N'2016-01-20T00:00:00.000' AS DateTime), N'Cow Hollow', 0, NULL, 94123, 3, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (142, 3585452, 380.67, N'House', N'Private room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials}', 1, 1, N'Real Bed', N'flexible', 0, N'LA', N't', N'', CAST(N'2015-03-06T00:00:00.000' AS DateTime), N'Reseda', 3, 100, 91335, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (143, 14320263, 321.89, N'House', N'Shared room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 1, 2, N'Real Bed', N'strict', 1, N'LA', N'f', N'100%', CAST(N'2016-03-27T00:00:00.000' AS DateTime), N'Westlake', 0, NULL, 90005, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (144, 11399852, 424.85, N'House', N'Private room', N'{"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}', 2, 1, N'Real Bed', N'strict', 0, N'NYC', N't', N'100%', CAST(N'2015-06-10T00:00:00.000' AS DateTime), N'Harlem', 41, 95, 10027, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (145, 12386097, 366.36, N'Apartment', N'Shared room', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector",Essentials,Shampoo}', 1, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2015-10-02T00:00:00.000' AS DateTime), N'Harlem', 18, 96, 10027, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (146, 1404510, 534.71, N'Townhouse', N'Entire home/apt', N'{TV,"Wireless Internet",Kitchen,"Free parking on premises","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 6, 2, N'Real Bed', N'moderate', 1, N'LA', N't', N'100%', CAST(N'2015-09-02T00:00:00.000' AS DateTime), N'West Los Angeles', 10, 95, 90025, 3, 3)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (147, 4691130, 444.27, N'House', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Pool,Kitchen,"Free parking on premises",Breakfast,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 2, 1, N'Real Bed', N'flexible', 1, N'LA', N't', N'0%', CAST(N'2013-10-28T00:00:00.000' AS DateTime), N'', 0, NULL, 91324, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (148, 16449480, 468.21, N'Apartment', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Smoking allowed","Pets allowed",Doorman,Elevator,Heating,Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N'f', N'100%', CAST(N'2012-03-26T00:00:00.000' AS DateTime), N'East Harlem', 4, 90, 10029, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (149, 15149374, 444.27, N'Bungalow', N'Private room', N'{"Wireless Internet",Kitchen,"Pets allowed","Indoor fireplace",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}', 3, 1, N'Real Bed', N'strict', 1, N'LA', N't', N'97%', CAST(N'2012-08-17T00:00:00.000' AS DateTime), N'Venice', 3, 100, 90291, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (150, 10089727, 594.02, N'Villa', N'Entire home/apt', N'{"Air conditioning","Wheelchair accessible",Pool,"Free parking on premises",Gym,"Hot tub","Family/kid friendly",Essentials,Shampoo}', 6, 1, N'Real Bed', N'strict', 1, N'LA', N'f', N'100%', CAST(N'2015-06-06T00:00:00.000' AS DateTime), N'', 15, 89, 90265, 3, 4)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (151, 3323232, 460.52, N'Condominium', N'Private room', N'{TV,"Wireless Internet","Air conditioning",Kitchen,Breakfast,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private living room"}', 2, 1, N'Real Bed', N'flexible', 0, N'NYC', N'f', N'100%', CAST(N'2015-10-02T00:00:00.000' AS DateTime), N'Harlem', 0, NULL, 10039, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (152, 20899396, 470.05, N'Apartment', N'Entire home/apt', N'{TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Essentials,Shampoo}', 4, 1, N'Real Bed', N'flexible', 1, N'NYC', N't', N'100%', CAST(N'2013-12-21T00:00:00.000' AS DateTime), N'Harlem', 4, 85, 10030, 1, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (153, 3380585, 436.94, N'Apartment', N'Private room', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Elevator,"Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials}', 2, 1, N'Real Bed', N'moderate', 0, N'NYC', N'f', N'', CAST(N'2014-06-30T00:00:00.000' AS DateTime), N'Harlem', 2, 70, 10027, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (154, 16073836, 431.75, N'House', N'Private room', N'{TV,Internet,"Wireless Internet","Free parking on premises","Family/kid friendly",Washer,Dryer,Essentials}', 2, 1, N'Real Bed', N'flexible', 0, N'LA', N'f', N'', CAST(N'2016-09-02T00:00:00.000' AS DateTime), N'Culver City', 0, NULL, 90232, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (155, 20257960, 478.75, N'House', N'Private room', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,"Family/kid friendly",Washer,Dryer,"Smoke detector","First aid kit","Fire extinguisher"}', 2, 1, N'Real Bed', N'flexible', 0, N'LA', N't', N'', CAST(N'2013-03-06T00:00:00.000' AS DateTime), N'Mid-Wilshire', 0, NULL, 90035, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (156, 4559312, 510.59, N'Apartment', N'Entire home/apt', N'{Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets live on this property",Dog(s),"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Shampoo,Hangers,"Hair dryer","Laptop friendly workspace"}', 4, 1, N'Real Bed', N'strict', 0, N'NYC', N't', N'', CAST(N'2013-03-06T00:00:00.000' AS DateTime), N'Harlem', 2, 80, 10026, 2, 2)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (157, 2165604, 368.89, N'Apartment', N'Private room', N'{"Wireless Internet","Air conditioning",Kitchen,"Smoking allowed",Breakfast,"Pets live on this property",Cat(s),"Buzzer/wireless intercom","Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Host greets you"}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2016-03-14T00:00:00.000' AS DateTime), N'Harlem', 7, 94, 10039, 1, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (158, 18385413, 409.43, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Elevator,"Buzzer/wireless intercom",Heating,Essentials,Hangers,"Hair dryer",Iron}', 2, 1, N'Real Bed', N'flexible', 0, N'NYC', N'f', N'', CAST(N'2014-06-04T00:00:00.000' AS DateTime), N'Harlem', 18, 91, 10030, 0, 1)
GO
INSERT [dbo].[airbnb_search_details] ([Unnamed:0:], [id], [price], [property_type], [room_type], [amenities], [accommodates], [bathrooms], [bed_type], [cancellation_policy], [cleaning_fee], [city], [host_identity_verified], [host_response_rate], [host_since], [neighbourhood], [number_of_reviews], [review_scores_rating], [zipcode], [bedrooms], [beds]) VALUES (159, 9470528, 477.91, N'Apartment', N'Entire home/apt', N'{TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Smoke detector",Essentials}', 2, 1, N'Real Bed', N'moderate', 1, N'NYC', N't', N'100%', CAST(N'2015-10-02T00:00:00.000' AS DateTime), N'Harlem', 5, 88, 10027, 0, 2)
GO