This plumbers database contains 904 records across 865 cities of 51 states in the United States. Each plumber consists of title, telephone, description, street address, address locality, latitude, longitude, etc. In table service, there are 12 plumber services, such as commercial plumbing, emergency plumbing, remodel plumbing, residential plumbing, septic systems, sewers & drains, sump pumps, etc.
The whole America plumbers data set has 8 tables.
| Name | n3_chennan_plumber_plumbersnearyou_com |
|---|---|
| Data | 4.55M (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 43 (+ 0) |
| Table Rows | 20,262 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 865 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_plumber | 3,839 | city_id |
100%
|
| plumber_id |
100%
|
||
| hour | 154 | value |
100%
|
| key |
99.35%
|
||
| plumber | 904 | title |
100%
|
| telephone |
100%
|
||
| street_address |
56.64%
|
||
| address_locality |
56.64%
|
||
| address_region |
56.64%
|
||
| postal_code |
56.64%
|
||
| description |
87.28%
|
||
| latitude |
99.89%
|
||
| longitude |
99.89%
|
||
| plumber_x_hour | 6,322 | plumber_id |
100%
|
| hour_id |
100%
|
||
| plumber_x_service | 8,115 | plumber_id |
100%
|
| service_id |
100%
|
||
| service | 12 | value |
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
No media sets.
