Name | n3_chennan_house_redfin_com |
---|---|
Data | 193.75M (+ 0B) |
Tables | 26 (+ 0) |
Columns | 129 (+ 0) |
Table Rows | 1,053,334 (+ 0) |
Media | 0B (+ 0B) |
Files | 0 (+ 0) |
Last Commit | 2023-06-19 18:36:38 (+ 169 d) |
In the real estates database, there are 469,764 records from 43 states in America. Each record is comprised of price, baths, beds, square feet, built, country, type, size etc. It also comes with 20,903 zip codes of these states in the data set. The whole United States real estates data set consists of 26 tables.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
detail | 1 | key |
100%
|
value |
100%
|
||
exterior_feature | 0 | title |
0%
|
exterior_feature_x_sub_exterior_feature | 0 | exterior_feature_id |
0%
|
sub_exterior_feature_id |
0%
|
||
interior_feature | 0 | title |
0%
|
interior_feature_x_sub_interior_feature | 0 | interior_feature_id |
0%
|
sub_interior_feature_id |
0%
|
||
property_detail | 0 | title |
0%
|
property_detail_x_sub_property_detail | 0 | property_detail_id |
0%
|
sub_property_detail_id |
0%
|
||
real_estate | 469,764 | price |
76.86%
|
beds |
98.99%
|
||
baths |
98.99%
|
||
sqft |
98.88%
|
||
built |
35.33%
|
||
status |
10.58%
|
||
county |
84.28%
|
||
type |
67.39%
|
||
mls |
84.03%
|
||
size |
97.56%
|
||
apn |
97.56%
|
||
reactid |
0%
|
||
description |
0%
|
||
street_address |
0%
|
||
address_locality |
0%
|
||
address_region |
0%
|
||
postal_code |
0%
|
||
address_country |
0%
|
||
latitude |
0%
|
||
longitude |
0%
|
||
alt |
0%
|
||
real_estate_x_detail | 1 | real_estate_id |
100%
|
detail_id |
100%
|
||
real_estate_x_exterior_feature | 0 | real_estate_id |
0%
|
exterior_feature_id |
0%
|
||
real_estate_x_interior_feature | 0 | real_estate_id |
0%
|
interior_feature_id |
0%
|
||
real_estate_x_property_detail | 0 | real_estate_id |
0%
|
property_detail_id |
0%
|
||
real_estate_x_surrounding_facility | 0 | real_estate_id |
0%
|
surrounding_facility_id |
0%
|
||
real_estate_x_utilities_and_location | 0 | real_estate_id |
0%
|
utilities_and_location_id |
0%
|
||
state | 43 | title |
100%
|
sub_exterior_feature | 0 | key |
0%
|
value |
0%
|
||
sub_interior_feature | 0 | key |
0%
|
value |
0%
|
||
sub_property_detail | 0 | key |
0%
|
value |
0%
|
||
sub_surrounding_facility | 0 | key |
0%
|
value |
0%
|
||
sub_utilities_and_location | 0 | key |
0%
|
value |
0%
|
||
surrounding_facility | 0 | title |
0%
|
surrounding_facility_x_sub_surrounding_facility | 0 | surrounding_facility_id |
0%
|
sub_surrounding_facility_id |
0%
|
||
utilities_and_location | 0 | title |
0%
|
utilities_and_location_x_sub_utilities_and_location | 0 | utilities_and_location_id |
0%
|
sub_utilities_and_location_id |
0%
|
||
zipcode | 20,903 | title |
100%
|
state_id |
100%
|
||
state |
100%
|
||
zipcode_x_real_estate | 562,622 | zipcode_id |
100%
|
real_estate_id |
100%
|
No media sets.
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2023-01-01 (+ 95 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2022-09-27 (+ 271 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-12-30 (+ 115 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-09-05 (+ 150 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-04-08 (+ 68 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-01-29 (+ 120 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-10-01 (+ 38 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-08-23 (+ 141 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-04-04 (+ 196 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-09-21 (+ 197 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-03-07 (+ 43 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-01-23 (+ 44 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-12-09 (+ 29 d) | 193.75M (+ 0B) | 26 (+ 0) | 129 (+ 0) | 1,053,334 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-11-09 (+ 27 d) | 193.75M (+ 42.78M) | 26 (+ 22) | 129 (+ 99) | 1,053,334 (+ 2) | 0B (+ 0B) | 0 (+ 0) |
2018-10-13 (+ 29 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-09-13 (+ 34 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-08-09 (+ 27 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-07-12 (+ 31 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-06-10 (+ 31 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-05-10 (+ 28 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-04-11 (+ 38 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-03-03 (+ 35 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-01-27 (+ 29 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2017-12-29 (+ 20 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2017-12-08 (+ 9 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2017-11-28 (+ 19 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2017-11-09 (+ 10 d) | 150.97M (+ 0B) | 4 (+ 0) | 30 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2017-10-29 (+ 19 d) | 150.97M (+ 15.02M) | 4 (+ 0) | 30 (- 1) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2017-10-10 (+ 31 d) | 135.95M (+ 0B) | 4 (+ 0) | 31 (+ 0) | 1,053,332 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2017-09-08 | 135.95M | 4 | 31 | 1,053,332 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.