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.
| 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) |
Data Samples
Database APIs
Tables & Columns
| 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%
|
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
No media sets.
