Home Data Professional Services Plumbers

US 171,323 Plumbers: Phone, Address, Service, Lat, Lon w/ Hour, Image Database

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)
Last Commit	2019-09-21 09:45:03 (+ 197 d)

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. From the whole plumber data set, all these plumbers are throughout 2,537 cities of 51 states in America. It also comes with 24,843 plumbers images in the media package.

There are 8 tables in the whole United States plumbers API.

Data Samples

Main (Desktop) / JSON / Excel / CSV (Download)

Database APIs

http://n3.datasn.io/data/api/v1/n3_chennan/plumbers_in_us_1/ (By Table)

Media Files

plumber_image ^{Bytes: 0B / Files: 0}

Tables + Columns
Media Files
Updates
Download

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%
city_x_plumber	689,668	plumber_id	100%
hour	2,326	key	100%
hour	2,326	value	100%
image	24,843	alt	100%
image	24,843	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%
plumber_x_hour	75,052	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
0B	0

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2019-09-21 (+ 197 d)	250.47M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	250.47M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	250.47M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	250.47M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	250.47M (+ 51.59M)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	198.88M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	198.88M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	198.88M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	198.88M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	198.88M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	198.88M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11 (+ 38 d)	198.88M (+ 0B)	8 (+ 0)	50 (+ 0)	965,800 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-03-03	198.88M	8	50	965,800	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to generate API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Make and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.