Hair Salons in US

Addresses, phone numbers of Barber Shops in United States

Data Structure

city [15,287]
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%)
city_to_hair_salon [912,159]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ hair_salon_id (100%)
hair_salon [53,061]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ streetaddress (98.6%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (99.8%)
varchar(255)
+ phone (100%)
varchar(255)
+ website (16.2%)
varchar(255)
+ service_area (25.4%)
varchar(255)
+ office_hour (16%)
varchar(255)
+ licensed (100%)
varchar(255)
+ city_served (30.9%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

The hair salon database contains 53,061 barber shops in 15,287 cities over 51 states of US. Each record is comprised of street address, zip code, phone number, website URL, service area, office hours, licensed and city served. There are a total of 53,040 phone numbers in table hair salon, of which 52,295 are unique.

Data Profile

Size 115.69M
Tables 4
Last Commit 2016-09-02 03:31:23

Updates / Commits

Time Size Tables Columns Rows
2016-09-02 03:31:23 115.69M 4 28 980558

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 15,287 .001 15.287
city_to_hair_salon 912,159 .001 912.159
hair_salon 53,061 .001 53.061
state 51 .001 0.051
Total Credits 980.558 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.