Name | n3_chennan_contractor_homeadvisor_com |
---|---|
Data | 417.34M (+ 0B) |
Tables | 15 (+ 0) |
Columns | 69 (+ 0) |
Table Rows | 2,803,209 (+ 0) |
Media | 0B (+ 0B) |
Files | 0 (+ 0) |
Last Commit | 2023-06-19 18:36:38 (+ 169 d) |
This is a contractors database with 91,903 records by 100,727 categories from 2,478 cities of 51 states in America. Each record is comprised of title, phone number, description, street address, addressc locality, address region, postal code etc. There are other 5 tables closely related with contractors, they are areas of expertise with 89,428 records, 14,082 product brands used, service area with 6,981 records, 731 services offered records and hour with 1,184 records. The whole United States contractors data set has 15 tables.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
areas_of_expertise | 89,428 | value |
100%
|
category_1 | 100,727 | title |
100%
|
city_id |
100%
|
||
city |
100%
|
||
category_1_x_contractor | 1,158,761 | category_1_id |
100%
|
contractor_id |
100%
|
||
city | 2,478 | title |
100%
|
state_id |
100%
|
||
state |
100%
|
||
contractor | 91,903 | title |
100%
|
phone |
100%
|
||
description |
98.95%
|
||
street_address |
100%
|
||
addressc_locality |
100%
|
||
address_region |
100%
|
||
postal_code |
100%
|
||
website |
46%
|
||
contractor_x_areas_of_expertise | 286,165 | contractor_id |
100%
|
areas_of_expertise_id |
100%
|
||
contractor_x_hour | 133,975 | contractor_id |
100%
|
hour_id |
100%
|
||
contractor_x_product_brands_used | 118,677 | contractor_id |
100%
|
product_brands_used_id |
100%
|
||
contractor_x_service_area | 746,501 | contractor_id |
100%
|
service_area_id |
100%
|
||
contractor_x_services_offered | 51,565 | contractor_id |
100%
|
services_offered_id |
100%
|
||
hour | 1,184 | value |
100%
|
key |
100%
|
||
product_brands_used | 14,082 | value |
99.99%
|
service_area | 6,981 | value |
100%
|
services_offered | 731 | value |
100%
|
state | 51 | title |
100%
|
No media sets.
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2023-01-01 (+ 95 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2022-09-27 (+ 271 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-12-30 (+ 115 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-09-05 (+ 150 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-04-08 (+ 68 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-01-29 (+ 120 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-10-01 (+ 38 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-08-23 (+ 141 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-04-04 (+ 196 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-09-21 (+ 197 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-03-07 (+ 43 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-01-23 (+ 44 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-12-09 (+ 29 d) | 417.34M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-11-09 (+ 27 d) | 417.34M (+ 248.06M) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-10-13 (+ 29 d) | 169.28M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-09-13 (+ 34 d) | 169.28M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-08-09 (+ 27 d) | 169.28M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-07-12 (+ 31 d) | 169.28M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-06-10 (+ 31 d) | 169.28M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-05-10 (+ 28 d) | 169.28M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-04-11 (+ 38 d) | 169.28M (+ 0B) | 15 (+ 0) | 69 (+ 0) | 2,803,209 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-03-03 (+ 35 d) | 169.28M (+ 43.05M) | 15 (+ 0) | 69 (- 2) | 2,803,209 (+ 496,652) | 0B (+ 0B) | 0 (+ 0) |
2018-01-27 | 126.23M | 15 | 71 | 2,306,557 | 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.