Nail Salons (US)

Phone numbers, addresses, website URLs of nail salons in United States

Data Structure

city [14,806]
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_nail_salon [333,319]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ nail_salon_id (100%)
nail_salon [43,115]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ streetaddress (99.7%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (99.9%)
varchar(255)
+ phone (100%)
varchar(255)
+ warranty (4.1%)
varchar(255)
+ contact (6.8%)
varchar(255)
+ business_description (8.3%)
varchar(255)
+ senior_discount (3.9%)
varchar(255)
+ excluded_service (1.3%)
varchar(255)
+ service (100%)
varchar(255)
+ website (8.8%)
varchar(255)
+ service_area (11.3%)
varchar(255)
+ office_hour (8.5%)
varchar(255)
+ licensed (100%)
varchar(255)
+ city_served (13.6%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

This is a beauty nail salon database with 43,115 nail salons in 14,806 cities over 51 states throughout the United States. Each nail salon record consists of street address, address, zip code, phone numbers, warranty, contact, business description, senior discount, excluded service, service, website URL, service area, office hour, licensed and city served. In table nail salon, there are 42,548 unique phone numbers.

Data Profile

Size 61.09M
Tables 4
Last Commit 2016-12-07 00:24:32

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:24:32 61.09M 4 33 391291
2016-09-02 03:24:42 61.09M 4 33 391291

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 14,806 .001 14.806
city_to_nail_salon 333,319 .001 333.319
nail_salon 43,115 .001 43.115
state 51 .001 0.051
Total Credits 391.291 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.