This is a professional wedding services database with 125,803 records from 2,166 regions of 58 states in America. Each record consists of title, city, description, votes, score, address, region, postalcode, telephone, latitude, longitude, review count, typical price, service quality, responsiveness, professionalism, value, flexibility, website and etc. There are 23 categories for these wedding services in this data, such as Wedding Venues, Wedding Photographers, Wedding DJs, Wedding Registry, Wedding Planners, Wedding Hairstyles, Wedding Videographers, Wedding Florists, Wedding Caterers, Wedding Officiants, Wedding Rentals, Wedding Dresses, Wedding Bands, etc. In table comment, it has 263,629 records with uniq, user, marry date, comment, profession id, score overall, service quality, responsiveness, value, flexibility and professionalism in each. Beside, it includes 2,901,357 images of these wedding services. In the media set, it has 15.35G photo images in the file. The whole United States wedding services data set totally has 10 tables.
| Name | n3_lyz_weddingwire.com |
|---|---|
| Data | 1.82G (+ 1.29G) |
| Tables | 10 (+ 0) |
| Columns | 71 (+ 0) |
| Table Rows | 3,442,109 (+ 0) |
| Media | 15.35G (+ 0B) |
| Files | 244,438 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category | 23 | category |
100%
|
| category_x_state | 1,047 | category_id |
100%
|
| state_id |
100%
|
||
| category_x_state_x_region | 2,166 | category_x_state_id |
100%
|
| region_id |
100%
|
||
| category_x_state_x_region_x_profession | 145,860 | category_x_state_x_region_id |
100%
|
| profession_id |
100%
|
||
| comment | 263,629 | uniq |
100%
|
| user |
98.83%
|
||
| marry_date |
98.76%
|
||
| comment |
89.77%
|
||
| profession_id |
100%
|
||
| score_overall |
100%
|
||
| service_quality |
100%
|
||
| responsiveness |
100%
|
||
| value |
100%
|
||
| flexibility |
100%
|
||
| professionalism |
100%
|
||
| image_slug | 2,901,357 | profession_id |
100%
|
| title |
99.96%
|
||
| profession | 125,803 | title |
100%
|
| city |
99.99%
|
||
| description |
70.26%
|
||
| votes |
68.86%
|
||
| guests_from |
12.72%
|
||
| guests_to |
11.71%
|
||
| score |
78.39%
|
||
| address |
99.93%
|
||
| region |
99.93%
|
||
| postalcode |
99.91%
|
||
| telephone_hide |
0%
|
||
| telephone |
99.48%
|
||
| latitude |
99.93%
|
||
| longitude |
99.93%
|
||
| review_count |
78.39%
|
||
| typical_price |
36.48%
|
||
| service_quality |
78.37%
|
||
| responsiveness |
78.37%
|
||
| professionalism |
78.37%
|
||
| value |
78.37%
|
||
| flexibility |
78.37%
|
||
| web_site |
21.04%
|
||
| region | 2,166 | region |
100%
|
| total |
100%
|
||
| state | 58 | state |
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
PHOTO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 15.35G | 244,438 |
