This is a houses list with 1,596,311 records from 8,517 cities of 50 states in America. Each record is comprised of title, description, street address, type, address locality, address region, postal code, address country, price, bed, bath, est, year built, latitude, longitude, lot size and square footage. There are 57,667 schools near these homes with school name and 21,731 local informations of these homes. It also has 10,497,237 houses images in this US homes database. The whole America homes for sale database has 10 tables.
| Name | n3_chennan_house_homefinder_com_sale |
|---|---|
| Data | 5.14G (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 56 (+ 0) |
| Table Rows | 22,289,456 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 8,517 | title |
100%
|
| state_id |
100%
|
||
| city_x_home | 1,746,703 | city_id |
100%
|
| home_id |
100%
|
||
| home | 1,596,311 | title |
99.61%
|
| price |
100%
|
||
| description |
37.75%
|
||
| type |
80.16%
|
||
| street_address |
99.6%
|
||
| address_locality |
100%
|
||
| address_region |
100%
|
||
| postal_code |
99.92%
|
||
| address_country |
100%
|
||
| bed |
39.3%
|
||
| bath |
39.3%
|
||
| est |
26.57%
|
||
| year_buit |
38.11%
|
||
| latitude |
39.33%
|
||
| longitude |
39.33%
|
||
| lot_size |
26.43%
|
||
| square_footage |
38.11%
|
||
| home_x_local_info | 3,598,792 | home_id |
100%
|
| local_info_id |
100%
|
||
| home_x_school | 4,762,448 | home_id |
100%
|
| school_id |
100%
|
||
| image | 10,497,237 | image_url |
100%
|
| home_id |
100%
|
||
| local_info | 21,731 | key |
67.09%
|
| value |
100%
|
||
| school | 57,667 | school_name |
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
HOME_IMAGE
| Size (Bytes) | Files |
|---|---|
| 0P | 0 |
