With 171,323 records, this plumbers database has a large amount of data and rich in tables and fields. Each record is comprised of title, phone number, street address, address locality, address region, postal code, categories, etc. In the whole plumber data set, all these plumbers are throughout 2,537 cities of 51 states in America. The America plumbers data also comes with 24,843 plumbers images in the media package.
There are 8 tables in the whole United States plumbers API.
| Name | n3_chennan_plumber_yellowpages_com |
|---|---|
| Data | 250.47M (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 50 (+ 0) |
| Table Rows | 965,800 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 2,537 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_plumber | 689,668 | city_id |
100%
|
| plumber_id |
100%
|
||
| hour | 2,326 | key |
100%
|
| value |
100%
|
||
| image | 24,843 | alt |
100%
|
| plumber_id |
100%
|
||
| plumber | 171,323 | title |
100%
|
| phone |
99.98%
|
||
| street_address |
84.47%
|
||
| address_locality |
92.58%
|
||
| address_region |
92.58%
|
||
| postal_code |
92.58%
|
||
| general_info |
21.85%
|
||
| location |
3.63%
|
||
| latitude |
81.03%
|
||
| longitude |
81.03%
|
||
| extra_phone |
24.09%
|
||
| service |
32.43%
|
||
| brand |
25.32%
|
||
| payment |
35.67%
|
||
| neighborhood |
27.95%
|
||
| weblink |
38.17%
|
||
| categories |
90.01%
|
||
| association |
3.58%
|
||
| plumber_x_hour | 75,052 | plumber_id |
100%
|
| hour_id |
100%
|
||
| state | 51 | title |
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
PLUMBER_IMAGE
| Size (Bytes) | Files |
|---|---|
| 0P | 0 |
