Dry Cleaners in US

Addresses, phone numbers, website URLs of dry cleaning companies in US

Data Structure

city [14,971]
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_dry_cleaning [185,649]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ dry_cleaning_id (100%)
dry_cleaning [34,418]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ streetaddress (99.5%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (99.9%)
varchar(255)
+ phone (100%)
varchar(255)
+ website (7%)
varchar(255)
+ service_area (8.8%)
varchar(255)
+ office_hour (7.6%)
varchar(255)
+ licensed (100%)
varchar(255)
+ city_served (14%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

With street address, zip code, phone number, website URL, service area, office hours, licensed and city served, this dry cleaning services database contains 34,418 dry cleaning companies in 14,971 cities over 51 states of the United States. In table dry cleaning, there are 33,267 unique phone numbers.

Data Profile

Size 43.03M
Tables 4
Last Commit 2016-09-02 03:28:27

Updates / Commits

Time Size Tables Columns Rows
2016-09-02 03:28:27 43.03M 4 28 235089

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 14,971 .001 14.971
city_to_dry_cleaning 185,649 .001 185.649
dry_cleaning 34,418 .001 34.418
state 51 .001 0.051
Total Credits 235.089 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.