Home Data Rentals Apartment Rentals

UK 81,597 Properties: Address, Price, Lat, Lon, Phone w/ Image, Key Feature Database

Name	n3_chennan_house_rightmove_co_uk
Data	622.44M (- 2.27M)
Tables	15 (+ 0)
Columns	63 (+ 0)
Table Rows	2,016,417 (+ 0)
Media	13.03M (- 0.10G)
Files	300 (- 2,967)
Last Commit	2019-09-21 09:45:03 (+ 197 d)

This is a fields-rich database of rental property with 81,597 home records by 21 categories in the United Kingdom. Each rental properties record is comprised of price, address, phone number, description, property type, country and etc. It also comes with 1,063,974 images in the 115.34M property media sets of this database. Besides, there are 5 other tables related with these property, they are first table with 1,863 reocords, ground table with 1,488 records, key feature table with 163,129 records, letting information with 2,399 records and 5,254 need URl with location identifier in each.

The whole UK rental properties database consists of 15 tables.

Data Samples

Main (Desktop) / JSON / Excel / CSV (Download)

Database APIs

http://n3.datasn.io/data/api/v1/n3_chennan/uk_property/ (By Table)

Media Files

property_image ^{Bytes: 13.03M / Files: 300}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
category_1	21	title	100%
category_2	5,256	title	100%
		category_1_id	100%
		category_1	100%
category_2_x_property	90,518	category_2_id	100%
category_2_x_property	90,518	property_id	100%
first	1,863	value	100%
ground	1,488	value	100%
image	1,063,974	image_url	100%
image	1,063,974	property_id	100%
key_feature	163,129	value	100%
letting_information	2,399	value	100%
letting_information	2,399	key	100%
need_url	5,254	location_identifier	100%
property	81,597	address	100%
		description	99.5%
		price	62.9%
		phone	100%
		latitude	99.61%
		longitude	99.61%
		property_type	99.61%
		country	99.61%
property_x_first	4,355	property_id	100%
property_x_first	4,355	first_id	100%
property_x_ground	3,536	property_id	100%
property_x_ground	3,536	ground_id	100%
property_x_key_feature	492,023	property_id	100%
property_x_key_feature	492,023	key_feature_id	100%
property_x_letting_information	101,004	property_id	100%
property_x_letting_information	101,004	letting_information_id	100%

Notes:

Meta columns id and ts are not shown here, but included in columns total.
Some statistical or memo columns are not shown here, but included in columns total.
Non-empty percentage indicates the percent of values that are non-empty for that particular column.

Media Sets

property_image

Size (Bytes)	Files
13.03M	300

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2019-09-21 (+ 197 d)	622.44M (- 2.27M)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	13.03M (- 0.10G)	300 (- 2,967)
2019-03-07 (+ 43 d)	624.70M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2019-01-23 (+ 44 d)	624.70M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-12-09 (+ 29 d)	624.70M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-11-09 (+ 27 d)	624.70M (+ 511.73M)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-10-13 (+ 29 d)	112.97M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-09-13 (+ 34 d)	112.97M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-08-09 (+ 27 d)	112.97M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-07-12 (+ 31 d)	112.97M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-06-10 (+ 31 d)	112.97M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-05-10 (+ 28 d)	112.97M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-04-11 (+ 38 d)	112.97M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-03-03 (+ 35 d)	112.97M (+ 0B)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 0B)	3,267 (+ 0)
2018-01-27 (+ 29 d)	112.97M (+ 3.31M)	15 (+ 0)	63 (+ 0)	2,016,417 (+ 0)	115.34M (+ 111.01M)	3,267 (+ 3,167)
2017-12-29	109.66M	15	63	2,016,417	4.33M	100

Download Latest Commit

In the same time, you can also access this data set via API.

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to generate API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Make and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.