Electricians in US

Addresses, phone numbers, website URLs of electricians in United States

Data Structure

city [16,245]
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_electrician [2,012,887]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ electrician_id (100%)
electrician [122,593]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ streetaddress (96.1%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (99.7%)
varchar(255)
+ phone (99.8%)
varchar(255)
+ warranty (31.9%)
varchar(255)
+ contact (37.2%)
varchar(255)
+ business_description (32.5%)
varchar(255)
+ senior_discount (25.9%)
varchar(255)
+ excluded_service (10.3%)
varchar(255)
+ service (99.9%)
varchar(255)
+ website (19.4%)
varchar(255)
+ service_area (30.9%)
varchar(255)
+ office_hour (32.1%)
varchar(255)
+ licensed (99.9%)
varchar(255)
+ city_served (40.7%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

This database contains 122,593 electricians in 16,245 cities over 51 states throughout the United States. Each electrician record is comprised of address, street address, zip code, phone number, warranty, contact, business description, senior discount, excluded service, service, website URL, service area, office hour, licensed and city served. There are 119,137 unique phone numbers in table electrician.

Data Profile

Size 270.97M
Tables 4
Last Commit 2016-09-05 04:31:36

Updates / Commits

Time Size Tables Columns Rows
2016-09-05 04:31:36 270.97M 4 34 2151776

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 16,245 .001 16.245
city_to_electrician 2,012,887 .001 2012.887
electrician 122,593 .001 122.593
state 51 .001 0.051
Total Credits 2151.776 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.