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.
| 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) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| 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%
|
| pharmacy_id |
100%
|
||
| hour | 1,543 | key |
100%
|
| value |
99.55%
|
||
| pharmacy | 11,299 | title |
100%
|
| phone |
99.4%
|
||
| street_address |
99.83%
|
||
| address_locality |
99.81%
|
||
| address_region |
41.87%
|
||
| postal_code |
99.83%
|
||
| rating |
44.57%
|
||
| pharmacy_x_hour | 78,960 | pharmacy_id |
100%
|
| hour_id |
100%
|
||
| pharmacy_x_review | 7,563 | pharmacy_id |
100%
|
| review_id |
100%
|
||
| review | 7,563 | rating |
100%
|
| reviewtext |
100%
|
||
| date |
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.
