This is a real estate database with 621,400 homes over 4,208 cities of 50 states in the United States. Each real estate record is comprised of description, street address, address locality, address region, price, postal code, phone number, bedroom, bath, sqft, latitude, longitude, etc. It also comes with 6,349,336 real estate images in the 74.21M media package of this data.
The whole United States real properties API has 8 tables.
| Name | n3_chennan_house_movoto_com |
|---|---|
| Data | 2.45G (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 45 (+ 0) |
| Table Rows | 12,855,193 (+ 0) |
| Media | 275.67M (+ 0B) |
| Files | 10,000 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 4,208 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_real_estate | 625,385 | city_id |
100%
|
| real_estate_id |
100%
|
||
| detail | 279,855 | value |
100%
|
| image | 6,349,336 | image_url |
100%
|
| real_estate_id |
100%
|
||
| real_estate | 621,400 | streetaddress |
100%
|
| addresslocality |
100%
|
||
| addressregion |
100%
|
||
| postalcode |
99.76%
|
||
| price |
99.97%
|
||
| description |
91.36%
|
||
| phone |
17.53%
|
||
| bedroom |
91.35%
|
||
| bath |
91.35%
|
||
| sqft |
91.15%
|
||
| latitude |
97.84%
|
||
| longitude |
97.84%
|
||
| sf_lot |
0.52%
|
||
| acres |
19.6%
|
||
| tax_id |
16.72%
|
||
| real_estate_x_detail | 4,974,959 | real_estate_id |
100%
|
| detail_id |
100%
|
||
| state | 50 | title |
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
REAL_ESTATE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 275.67M | 10,000 |
