This is an electricians database with 387 records from 118 cities of UK.
Each record is comprised of description, address, review, star index, initial impression star, punctuality star, cleanliness star, quality star, value star, tel, mob, alt, website, member number, time, company and owned by company. There are 4 tables mostly related with these electricians, they are 55 association records; 20,815 comment records with uniq, comment, electrician, initial impression star, punctuality star, cleanliness star, quality star, value star, average rating, time and client in each; 5 check content records and 2,219 specialties. This UK electricians data also comes with 1,837 production images of these electricians and they are keeped in the 42.33M media set.
The whole UK electricians api totaly has 12 tables.
| Name | n3_lyz_trustatrader.com |
|---|---|
| Data | 18.89M (+ 608K) |
| Tables | 12 (+ 0) |
| Columns | 74 (+ 0) |
| Table Rows | 47,814 (+ 0) |
| Media | 42.33M (+ 0B) |
| Files | 989 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| association | 55 | title |
100%
|
| check_content | 5 | title |
100%
|
| city | 118 | city |
100%
|
| city_x_electrician | 11,260 | city_id |
100%
|
| electrician_id |
100%
|
||
| comment | 20,815 | uniq |
100%
|
| comment |
90.75%
|
||
| electrician_id |
100%
|
||
| initial_impression_star |
100%
|
||
| punctuality_star |
100%
|
||
| cleanliness_star |
100%
|
||
| quality_star |
100%
|
||
| value_star |
100%
|
||
| average_rating |
100%
|
||
| time |
100%
|
||
| client |
99.64%
|
||
| electrician | 387 | title |
100%
|
| description |
100%
|
||
| address |
100%
|
||
| review |
100%
|
||
| star_index |
100%
|
||
| initial_impression_star |
0.26%
|
||
| punctuality_star |
100%
|
||
| cleanliness_star |
100%
|
||
| quality_star |
100%
|
||
| value_star |
100%
|
||
| tel |
97.93%
|
||
| mob |
92.51%
|
||
| alt |
6.72%
|
||
| website |
76.74%
|
||
| member_number |
100%
|
||
| time |
100%
|
||
| company |
97.67%
|
||
| owned_by_company |
94.83%
|
||
| electrician_x_association | 1,331 | electrician_id |
100%
|
| association_id |
100%
|
||
| electrician_x_check_content | 1,890 | electrician_id |
100%
|
| check_content_id |
100%
|
||
| electrician_x_specialty | 7,897 | electrician_id |
100%
|
| specialty_id |
100%
|
||
| image_slug | 1,837 | electrician_id |
100%
|
| specialty | 2,219 | 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
PRODUCTION_IMAGE
| Size (Bytes) | Files |
|---|---|
| 42.33M | 989 |
