This is a hospitals database with 1,217 records by 25 categories in the United Kingdom. Each hospital record is comprised of title, street address, address locality, address region, postal code, phone number, overview and rating. There are 3,792 reviews of these hospitals with rating, review text and date in each. The whole UK hospitals data set has 6 tables.
| Name | n3_chennan_hospital_nhs_uk |
|---|---|
| Data | 46.39M (+ 0B) |
| Tables | 6 (+ 0) |
| Columns | 38 (+ 0) |
| Table Rows | 257,869 (+ 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_hospital | 226,165 | category_2_id |
100%
|
| hospital_id |
100%
|
||
| hospital | 1,217 | title |
100%
|
| phone |
77.49%
|
||
| street_address |
99.67%
|
||
| address_locality |
98.36%
|
||
| address_region |
83.07%
|
||
| postal_code |
99.67%
|
||
| overview |
60.07%
|
||
| rating |
73.79%
|
||
| hospital_x_review | 3,811 | hospital_id |
100%
|
| review_id |
100%
|
||
| review | 3,792 | rating |
96.41%
|
| 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.
