In the homes database, there are 842,238 homes records with street in each. These homes are over 1,021,945 streets from 3,377 counties of 64 states in the United States. It also comes with 28,695 zip codes in this data. It totally has 6 tables in the whole US homes data set.
| Name | n3zm_Home_zillow_com_2 |
|---|---|
| Data | 531.06M (+ 0B) |
| Tables | 6 (+ 0) |
| Columns | 32 (+ 0) |
| Table Rows | 1,896,385 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| county | 3,377 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| home | 842,238 | title |
100%
|
| street_id |
100%
|
||
| state | 64 | title |
100%
|
| state_x_zip_code | 66 | state_id |
100%
|
| zip_code_id |
100%
|
||
| street | 1,021,945 | title |
99.99%
|
| zip_code_id |
100%
|
||
| zip_code |
100%
|
||
| zip_code | 28,695 | title |
100%
|
| county_id |
99.77%
|
||
| county |
99.77%
|
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.
