In the UK dentists database, there are 7,677 records by 25 categories. Each record is comprised of title, phone number, overview, street address, address locality, address region, post code and rating. It also has 1,597 hours and 21,017 review with date, rating and review text in each. The whole United Kingdom dentists data set has 8 tables.
| Name | n3_chennan_dentist_nhs_uk |
|---|---|
| Data | 75.55M (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 46 (+ 0) |
| Table Rows | 343,864 (+ 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_dentist | 216,066 | category_2_id |
100%
|
| dentist_id |
100%
|
||
| dentist | 7,677 | title |
100%
|
| phone |
92.43%
|
||
| overview |
89.29%
|
||
| street_address |
99.69%
|
||
| address_locality |
98.02%
|
||
| address_region |
32.93%
|
||
| postal_code |
99.69%
|
||
| rating |
73.99%
|
||
| dentist_x_hour | 53,571 | dentist_id |
100%
|
| hour_id |
100%
|
||
| dentist_x_review | 21,052 | dentist_id |
100%
|
| review_id |
100%
|
||
| hour | 1,597 | key |
100%
|
| value |
99.56%
|
||
| review | 21,017 | rating |
98.96%
|
| date |
100%
|
||
| reviewtext |
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.
