This is a agents and property database with 8,102 agents and 8,102 property over 2,585 cities from 413 counties of 227 regions in 8 states of the America. Each agent is comprised of name, office phone number, mobile phone number, voice mail, description, address, state, post code, fax number and website address and each property consists of description, price, address, state, post code, bed, bath, sq ft, type, school district, architecture, taxes, built, stories, latitude and longitude. Besides, there are exterior features with 2,210,972 records; interior feature with 206 records; 263 offices; room dimension with 921,127 records and 24 specialties. The America agents and property data also comes with 2,471,007 images in the 36.88M and 321.46M media sets. The whole United States agents and property data set totally has 23 tables.
| Name | n3_lyz_howardhanna.com |
|---|---|
| Data | 2.14G (+ 1.50G) |
| Tables | 23 (+ 0) |
| Columns | 121 (+ 0) |
| Table Rows | 7,546,436 (+ 0) |
| Media | 4.25G (+ 0B) |
| Files | 164,474 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
- http://n3.datasn.io/data/api/v1/n3_lyz/real_estate_agent_information_in_the_us_1/ (By Table)
- http://n3.datasn.io/data/api/v1/n3_lyz/property_for_sale_in_us_1/ (By Table)
Media Files
- agent_image Bytes: 321.46M / Files: 8,067
- property_image Bytes: 3.94G / Files: 156,407
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| agent | 8,102 | name |
100%
|
| office_phone |
94.43%
|
||
| mobile_phone |
84.65%
|
||
| voicemail |
22.43%
|
||
| description |
75.97%
|
||
| address |
99.54%
|
||
| state |
99.54%
|
||
| post_code |
99.54%
|
||
| fax |
31.02%
|
||
| website |
79.49%
|
||
| agent_x_office | 8,079 | agent_id |
100%
|
| office_id |
100%
|
||
| agent_x_property | 37,638 | agent_id |
100%
|
| property_id |
100%
|
||
| agent_x_region | 8,065 | agent_id |
100%
|
| region_id |
100%
|
||
| agent_x_specialty | 26,279 | agent_id |
100%
|
| specialty_id |
100%
|
||
| city | 2,585 | state_id |
100%
|
| city |
100%
|
||
| city_x_property | 98,612 | city_id |
100%
|
| property_id |
100%
|
||
| county | 413 | state_id |
100%
|
| county |
100%
|
||
| county_x_property | 161,822 | county_id |
100%
|
| property_id |
100%
|
||
| exterior_feature | 2,210,972 | title |
100%
|
| value |
50.88%
|
||
| property_id |
100%
|
||
| image_slug | 2,471,007 | property_id |
100%
|
| interior_feature | 206 | title |
100%
|
| value |
17.96%
|
||
| letter | 26 | letter |
100%
|
| letter_x_agent | 8,106 | letter_id |
100%
|
| agent_id |
100%
|
||
| office | 263 | office |
100%
|
| property | 208,223 | description |
78.86%
|
| price |
97.52%
|
||
| address |
96.03%
|
||
| state |
96.03%
|
||
| post_code |
96.02%
|
||
| bed |
64.81%
|
||
| bath |
35.24%
|
||
| sq_ft |
63.4%
|
||
| type |
87.28%
|
||
| school_district |
69.11%
|
||
| architecture |
56.32%
|
||
| taxes |
76.12%
|
||
| built |
66.68%
|
||
| stories |
41.6%
|
||
| latitude |
75.4%
|
||
| longitude |
75.4%
|
||
| property_x_interior_feature | 1,374,652 | property_id |
100%
|
| interior_feature_id |
100%
|
||
| region | 227 | city |
100%
|
| state |
100%
|
||
| zip_code |
100%
|
||
| room_dimension | 921,127 | title |
100%
|
| property_id |
100%
|
||
| value |
52.59%
|
||
| specialty | 24 | specialty |
100%
|
| state | 8 | state |
100%
|
| short |
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
AGENT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 321.46M | 8,067 |
PROPERTY_IMAGE
| Size (Bytes) | Files |
|---|---|
| 3.94G | 156,407 |
