This is a comprehensive electricians database having 5,094 records with title, telephone, address, zip code, score, votes, description, locality, business overview, website and since in each of the United States. From the database, these electricians get 11 achievements with description in each and have 1,032 awards. There are 7,083 records of business hour for these electricians. Besides, it has 6,427 expertises and 3,368 licenses with trade, license, expiration. In the table quick fact, it has 10,952 records of these US electricians. They offers 41,341 services over 9,533 areas and these services are classified into 15,996 categories. It also comes with 1,576 images and there are 1.34G work images of these American electricians in the media set. The whole USA electricians dataset has 24 tables in total.
| Name | n3_lyz_homeadvisor.com |
|---|---|
| Data | 71.27M (+ 0B) |
| Tables | 24 (+ 0) |
| Columns | 106 (+ 0) |
| Table Rows | 430,668 (+ 0) |
| Media | 1.34G (+ 0B) |
| Files | 1,295 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| achievement | 11 | achievement |
100%
|
| description |
100%
|
||
| award | 1,032 | award |
98.26%
|
| electrician_id |
100%
|
||
| business_hour | 7,083 | title |
100%
|
| value |
100%
|
||
| electrician_id |
100%
|
||
| certification | 0 | title |
0%
|
| city | 16,048 | city |
100%
|
| state_x_letter_id |
100%
|
||
| city_x_electrician | 134,200 | city_id |
100%
|
| electrician_id |
100%
|
||
| electrician | 5,094 | title |
100%
|
| telephone |
100%
|
||
| address |
100%
|
||
| zip_code |
100%
|
||
| score |
90.11%
|
||
| votes |
77.74%
|
||
| description |
99.37%
|
||
| locality |
100%
|
||
| business_overview |
27.99%
|
||
| website |
36.2%
|
||
| since |
99.45%
|
||
| electrician_x_achievement | 13,131 | electrician_id |
100%
|
| achievement_id |
100%
|
||
| electrician_x_certification | 0 | electrician_id |
0%
|
| certification_id |
0%
|
||
| electrician_x_expertise | 15,246 | electrician_id |
100%
|
| expertise_id |
100%
|
||
| electrician_x_membership | 892 | electrician_id |
100%
|
| membership_id |
100%
|
||
| electrician_x_service_area | 147,557 | electrician_id |
100%
|
| service_area_id |
100%
|
||
| expertise | 6,427 | expertise |
99.98%
|
| image_slug | 1,576 | electrician_id |
100%
|
| letter | 26 | letter |
100%
|
| license | 3,368 | trade |
100%
|
| license |
100%
|
||
| expiration |
100%
|
||
| electrician_id |
100%
|
||
| membership | 1 | membership |
0%
|
| title |
100%
|
||
| quick_fact | 10,952 | title |
100%
|
| electrician_id |
100%
|
||
| service | 41,341 | service |
100%
|
| service_category_id |
100%
|
||
| service_area | 9,533 | area |
100%
|
| service_category | 15,996 | title |
100%
|
| electrician_id |
100%
|
||
| state | 51 | state |
100%
|
| state_x_letter | 1,103 | state_id |
100%
|
| letter_id |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
WORK_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.34G | 1,295 |
