Family Practice Doctors in US

Addresses, phone numbers, website URLs, services of family clinics in US

Data Structure

city [7,085]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)
family_doctor [32,602]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ streetaddress (99.3%)
varchar(255)
+ city (100%)
varchar(255)
+ state (100%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (99.6%)
varchar(255)
+ phone (96.9%)
varchar(255)
+ contact (65.1%)
varchar(255)
+ service (99.9%)
varchar(255)
+ website (30.3%)
varchar(255)
+ office_hour (8.8%)
varchar(255)
+ licensed (100%)
varchar(255)
+ city_served (33.9%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

This family clinics database comes with 32,602 family practice doctors across 7,085 cities in 51 states of the United States. Each family doctor record is comprised of street address, location city, state, zip code, phone number, contact information, service, website URL, office hours, licensed and city served. In table family doctor, there are 30,776 unique phone numbers.

Data Profile

Size 23.27M
Tables 3
Last Commit 2016-09-02 03:29:39

Updates / Commits

Time Size Tables Columns Rows
2016-09-02 03:29:39 23.27M 3 28 39738

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 7,085 .001 7.085
family_doctor 32,602 .001 32.602
state 51 .001 0.051
Total Credits 39.738 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.