| 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) |
| Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
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.
| 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%
|
| Size (Bytes) | Files |
|---|---|
| 1.34G | 1,295 |
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2023-06-19 (+ 169 d) | 71.27M (+ 0B) | 24 (+ 0) | 106 (+ 0) | 430,668 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2023-01-01 (+ 95 d) | 71.27M (+ 0B) | 24 (+ 0) | 106 (+ 0) | 430,668 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2022-09-27 (+ 271 d) | 71.27M (+ 0B) | 24 (+ 0) | 106 (+ 0) | 430,668 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2021-12-30 (+ 115 d) | 71.27M (+ 0B) | 24 (+ 0) | 106 (+ 0) | 430,668 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2021-09-05 (+ 150 d) | 71.27M (+ 0B) | 24 (+ 0) | 106 (+ 0) | 430,668 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2021-04-08 (+ 68 d) | 71.27M (+ 0B) | 24 (+ 0) | 106 (+ 0) | 430,668 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2021-01-29 (+ 120 d) | 71.27M (+ 0B) | 24 (+ 0) | 106 (+ 0) | 430,668 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2020-10-01 (+ 38 d) | 71.27M (+ 0B) | 24 (+ 0) | 106 (+ 0) | 430,668 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2020-08-23 (+ 141 d) | 71.27M (- 0.36M) | 24 (- 1) | 106 (- 7) | 430,668 (- 1,576) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2020-04-04 (+ 196 d) | 71.62M (+ 0B) | 25 (+ 0) | 113 (+ 0) | 432,244 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2019-09-21 (+ 197 d) | 71.62M (+ 0B) | 25 (+ 0) | 113 (+ 0) | 432,244 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2019-03-07 (+ 43 d) | 71.62M (+ 0B) | 25 (+ 0) | 113 (+ 0) | 432,244 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2019-01-23 (+ 44 d) | 71.62M (+ 0B) | 25 (+ 0) | 113 (+ 0) | 432,244 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2018-12-09 (+ 29 d) | 71.62M (+ 0B) | 25 (+ 0) | 113 (+ 0) | 432,244 (+ 0) | 1.34G (+ 0B) | 1,295 (+ 0) |
| 2018-11-09 (+ 27 d) | 71.62M (+ 43.45M) | 25 (+ 0) | 113 (+ 4) | 432,244 (+ 275,308) | 1.34G (+ 1.34G) | 1,295 (+ 1,294) |
| 2018-10-13 (+ 29 d) | 28.17M (+ 26.72M) | 25 (+ 0) | 109 (+ 0) | 156,936 (+ 156,341) | 62.36K (+ 0B) | 1 (+ 0) |
| 2018-09-13 (+ 34 d) | 1.45M (+ 0B) | 25 (+ 0) | 109 (+ 0) | 595 (+ 0) | 62.36K (+ 0B) | 1 (+ 0) |
| 2018-08-09 (+ 27 d) | 1.45M (+ 0B) | 25 (+ 0) | 109 (+ 0) | 595 (+ 0) | 62.36K (+ 0B) | 1 (+ 0) |
| 2018-07-12 (+ 31 d) | 1.45M (+ 0B) | 25 (+ 0) | 109 (+ 0) | 595 (+ 0) | 62.36K (+ 0B) | 1 (+ 0) |
| 2018-06-10 (+ 31 d) | 1.45M (+ 0B) | 25 (+ 0) | 109 (+ 0) | 595 (+ 0) | 62.36K (+ 0B) | 1 (+ 0) |
| 2018-05-10 (+ 28 d) | 1.45M (+ 1.23M) | 25 (+ 21) | 109 (+ 92) | 595 (+ 420) | 62.36K (+ 62.36K) | 1 (+ 1) |
| 2018-04-11 | 224K | 4 | 17 | 175 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.
