Air Conditioning Cleaning Companies

Addresses, phone numbers of US air conditioning cleaning companies

Data Structure

air_conditioning_cleaning [185,000]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (84.8%)
varchar(255)
+ phone (100%)
varchar(255)
+ fax (4.2%)
city [14,535]
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%)
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 database that lists 185,000 air conditioning cleaning companies across 14,535 cities in 51 states of the United States. Each air_conditioning_cleaning record is comprised of address, zip code, phone number and fax number. In the table of air_conditioning_cleaning, there are 183,664 unique phone numbers.

Data Profile

Size 53.20M
Tables 3
Last Commit 2016-09-05 04:28:48

Updates / Commits

Time Size Tables Columns Rows
2016-09-05 04:28:48 53.20M 3 19 199586

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
air_conditioning_cleaning 185,000 .001 185
city 14,535 .001 14.535
state 51 .001 0.051
Total Credits 199.586 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.