YouGov Sport
Explore the interactive ERD
Table & Field Reference
online_press
| Column | Type | Keys |
|---|
date | Unknown | PK |
event_id | Unknown | PKFK |
correct_mention | Unknown | |
count | Unknown | |
date_formatted | Unknown | |
event_name | Unknown | |
exp_count | Unknown | |
gross | Unknown | |
image_mention | Unknown | |
incorrect_mention | Unknown | |
net | Unknown | |
other_mention | Unknown | |
readership | Unknown | |
social_media
| Column | Type | Keys |
|---|
date | Unknown | PK |
event_id | Unknown | PKFK |
comments | Unknown | |
count | Unknown | |
date_formatted | Unknown | |
dislikes | Unknown | |
event_name | Unknown | |
expcount | Unknown | |
gross | Unknown | |
image_mention | Unknown | |
impression | Unknown | |
likes | Unknown | |
net | Unknown | |
other_mention | Unknown | |
shares | Unknown | |
total_engagement | Unknown | |
views | Unknown | |
linear_tv
| Column | Type | Keys |
|---|
broadcaster_id | Unknown | PK |
country_id | Unknown | PK |
date | Unknown | PK |
event_id | Unknown | PKFK |
audience | Unknown | |
brand_exposure | Unknown | |
brand_exposure_per_hour | Unknown | |
brand_impact_score | Unknown | |
broadcaster | Unknown | |
count | Unknown | |
country | Unknown | |
dateformatted | Unknown | |
discount_percentage | Unknown | |
duration | Unknown | |
event_name | Unknown | |
gross | Unknown | |
net | Unknown | |
number_of_seconds | Unknown | |
sport_id | Unknown | |
sport_name | Unknown | |
digital_streaming
| Column | Type | Keys |
|---|
broadcaster_id | Unknown | PK |
country_id | Unknown | PK |
date | Unknown | PK |
event_id | Unknown | PKFK |
audience | Unknown | |
brand_exposure | Unknown | |
brand_exposure_per_hour | Unknown | |
brand_impact_score | Unknown | |
broadcaster_name | Unknown | |
country_name | Unknown | |
date_formatted | Unknown | |
duration | Unknown | |
event_name | Unknown | |
gross | Unknown | |
net | Unknown | |
sport_id | Unknown | |
sport_name | Unknown | |
event
| Column | Type | Keys |
|---|
id | Unknown | PK |
name | Unknown | |
social_media_video
| Column | Type | Keys |
|---|
date | Unknown | PK |
event_id | Unknown | PKFK |
brand_exposure | Unknown | |
brand_exposure_per_hour | Unknown | |
brand_impact_score | Unknown | |
comments | Unknown | |
count | Unknown | |
date_formatted | Unknown | |
dislikes | Unknown | |
duration | Unknown | |
event_name | Unknown | |
gross | Unknown | |
likes | Unknown | |
net | Unknown | |
shares | Unknown | |
total_engagement | Unknown | |
views | Unknown | |
