Veterinary Clinics in US

Phone number, fax and address of vet clinic in United States

Data Structure

city [13,390]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ title (100%)
int(11)
+ count (90.8%)
varchar(255)
+ slug (100%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)
veterinary_clinic [288,531]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(200)
+ address (100%)
varchar(30)
+ fax (5.7%)
varchar(30)
+ zip_code (100%)
varchar(30)
+ phone (99.6%)

Description

This is a database of addresses, fax numbers, zip codes and phone numbers of 288,531 vet clinics across 51 states and 33,639 cities in the United States. There are 2,512 unique records that have a populated fax field, 3,073 unique records that have a populated zip code field and 41,020 unique records that have a populated phone number field in table veterinary_clinic.

Data Profile

Size 111.19M
Tables 3
Last Commit 2016-09-07 01:23:37

Updates / Commits

Time Size Tables Columns Rows
2016-09-07 01:23:37 111.19M 3 19 301972

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 13,390 .001 13.39
state 51 .001 0.051
veterinary_clinic 288,531 .001 288.531
Total Credits 301.972 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.