US Realtors

US Realtors / Real Estate Agents Database (Phone, Certs, Zip)

Data Structure

city [30,228]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ zip (100%)
bigint(20) unsigned
+ state_id (100%)
realtor [1,430,716]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ type (100%)
varchar(255)
+ office (86.9%)
varchar(255)
+ fax (35.2%)
varchar(255)
+ toll_free (6.8%)
varchar(255)
+ mobile (49.2%)
varchar(255)
+ home_office (2%)
varchar(255)
+ locality (100%)
varchar(255)
+ specializations (3%)
varchar(255)
+ certifications (29.6%)
varchar(255)
+ affiliation (90.3%)
char(5)
+ zip (100%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ abbreviation (100%)
varchar(255)
+ title (100%)

Description

This 3-table database lists all United States realtors (property agents / companies) with a variety of certifications, specifications and affiliations, categorized by city and state.

Each realtor record has office phone number, fax number, toll free number, mobile number and / or home office number. Each agent or company is categorized by state and city, by zip code, with specialized properties and certifications.

The total number of unique office phone numbers are 170,272. The total number of unique realtor names are 559,426.

Data Profile

Size 363.30M
Tables 3
Last Commit 2016-12-07 00:26:14

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:26:14 363.30M 3 23 1460995
2016-08-31 03:11:15 363.30M 3 23 1460995

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 30,228 .001 30.228
realtor 1,430,716 .001 1430.716
state 51 .001 0.051
Total Credits 1460.995 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.