Melbourne Airbnb Open Data

Detailed and summarized data of Airbnb activity in Melbourne, VIC, Australia

@kaggle.tylerx_melbourne_airbnb_open_data

Table List

6 tables(114.48 MB)

Calendar Dec18

Cleansed Listings Dec18

Listings Summary Dec18

Neighbourhoods

Reviews Dec18

Reviews Summary Dec18

Listings Summary Dec18

@kaggle.tylerx_melbourne_airbnb_open_data.listings_summary_dec18

1.52 MB
22895 rows
16 columns

id Id	name Name	host_id Host Id	host_name Host Name	neighbourhood Neighbourhood	latitude Latitude	longitude Longitude	room_type Room Type	price Price	minimum_nights Minimum Nights	number_of_reviews Number Of Reviews	last_review Last Review	reviews_per_month Reviews Per Month	calculated_host_listings_count Calculated Host Listings Count	availability_365 Availability 365
9835	Beautiful Room & House	33057	Manju	Manningham	-37.77268392793162	145.09213284673402	Private room	60	1	4	Sat Sep 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	0.04	1	365
10803	Room in Cool Deco Apartment in Brunswick	38901	Lindsay	Moreland	-37.76650511833534	144.98073609952365	Private room	35	3	108	Mon Nov 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5	1	213
12936	St Kilda 1BR APT+BEACHSIDE+VIEWS+PARKING+WIFI+AC	50121	Frank & Vince	Port Phillip	-37.859755022252834	144.9773691312915	Entire home/apt	159	3	15	Wed Nov 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0.15	17	326
15246	Large private room-close to city	59786	Eleni	Darebin	-37.758970717393446	144.98922790666975	Private room	50	2	29	Mon May 15 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	0.3	3
16760	Melbourne BnB near City & Sports	65090	Colin	Port Phillip	-37.8645303049528	144.9922379283506	Private room	69	1	63	Thu Nov 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0.74	1	328
38271	Melbourne - Old Trafford Apartment	164193	Daryl	Casey	-38.05725413934634	145.33935613079854	Entire home/apt	98	1	112	Sat Dec 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1.14	1	328
41836	CLOSE TO CITY & MELBOURNE AIRPORT	182833	Diana	Darebin	-37.69729418080277	145.00081557170424	Private room	50	7	159	Wed Aug 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1.62	3
43414	Home In The City	189682	Belinda	Melbourne	-37.8102672330311	144.98591997042834	Private room	100	1	3	Mon Nov 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0.29	1	11
43429	Tranquil Javanese-Style Apartment in Oakleigh East	189684	Allan	Monash	-37.89960099646283	145.1144745408343	Entire home/apt	98	2	168	Mon Dec 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1.72	1	310
44082	Queen Room in Beautiful House	193031	Vicki	Frankston	-38.14932045433776	145.14156886702006	Private room	60	3	28	Sat Oct 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0.29	5	310


CREATE TABLE listings_summary_dec18 (
  "id" BIGINT,
  "name" VARCHAR,
  "host_id" BIGINT,
  "host_name" VARCHAR,
  "neighbourhood_group" VARCHAR,
  "neighbourhood" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "room_type" VARCHAR,
  "price" BIGINT,
  "minimum_nights" BIGINT,
  "number_of_reviews" BIGINT,
  "last_review" TIMESTAMP,
  "reviews_per_month" DOUBLE,
  "calculated_host_listings_count" BIGINT,
  "availability_365" BIGINT
);