Home Data Medicine & Health

UK 11,299 Pharmacies API: Phone, Address, Postal Code, Review

Name	n3_chennan_pharmacy_nhs.uk
Data	61.70M (+ 0B)
Tables	8 (+ 0)
Columns	45 (+ 0)
Table Rows	358,161 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2023-06-19 18:36:38 (+ 169 d)

In this pharmacies database, there are 11,299 records with phone number, street address, address locality, address region, postal code and rating in each of the United Kingdom. There are 1,543 hours and 7,563 reviews records for these pharmacies. The whole UK pharmacies data set totally has 8 tables.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

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

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
pharmacy_x_hour	78,960	pharmacy_id	100%
pharmacy_x_hour	78,960	hour_id	100%
review	7,563	date	100%
		reviewtext	100%
		rating	100%
pharmacy_x_review	7,563	review_id	100%
pharmacy_x_review	7,563	pharmacy_id	100%
pharmacy	11,299	rating	44.57%
		postal_code	99.83%
		address_region	41.87%
		address_locality	99.81%
		street_address	99.83%
		phone	99.4%
		title	100%
category_1	25	title	100%
category_2	22,859	title	100%
		category_1_id	100%
		latitude	100%
		longitude	100%
category_2_x_pharmacy	228,349	category_2_id	100%
category_2_x_pharmacy	228,349	pharmacy_id	100%
hour	1,543	key	100%
hour	1,543	value	99.55%

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.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2023-01-01 (+ 95 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2022-09-27 (+ 271 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-12-30 (+ 115 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-09-05 (+ 150 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-04-08 (+ 68 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-01-29 (+ 120 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-10-01 (+ 38 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-08-23 (+ 141 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-04-04 (+ 196 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-09-21 (+ 197 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	61.70M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	61.70M (+ 19.88M)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	41.83M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	41.83M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	41.83M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	41.83M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	41.83M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	41.83M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11 (+ 38 d)	41.83M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-03-03 (+ 35 d)	41.83M (+ 0B)	8 (+ 0)	45 (+ 0)	358,161 (+ 77)	0B (+ 0B)	0 (+ 0)
2018-01-27	41.83M	8	45	358,084	0B	0

Download Latest Commit

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

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build 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. Create 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.