US Plastic Surgeons

US Plastic Surgeons Database (Phone, Address, Zip code)

Data Structure

city [525]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ state_slug (100%)
state [50]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
surgeon [10,226]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ address (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ state_slug (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ city_slug (100%)
char(5)
+ zip_code (100%)
varchar(255)
+ phone (99.6%)

Description

This is a pretty straightforward directory database of all the plastic surgeons / doctors in the US, indexed by state and city. Each surgeon has an address, a phone number, and a zip code.

Data Profile

Size 4.28M
Tables 3
Last Commit 2016-08-30 21:37:24

Updates / Commits

Time Size Tables Columns Rows
2016-08-30 21:37:24 4.28M 3 20 10801

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 525 .001 0.525
state 50 .001 0.05
surgeon 10,226 .001 10.226
Total Credits 10.801 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.