This dataset has one row per episode and includes ratings plus
original airdates in the UK (by series) and US
(by season). This dataset is made by joining the ratings_raw
and seasons_raw datasets by both series and episode.
Format
A data frame with 94 rows representing individual episodes and 11 variables:
- series
An integer denoting UK series (
1-10).- episode
An integer denoting episode number within a series.
- episode_count
An integer denoting continuous episode number across series (
1-94)- uk_airdate
A date denoting original airdate of episode in the UK.
- viewers_7day
The number of viewers in millions within a 7-day window from airdate.
- viewers_28day
The number of viewers in millions within a 28-day window from airdate.
- network_rank
An integer denoting the episode's weekly ranking within network (note that the networks changed for series 8 and later).
- channels_rank
An integer denoting the episode's weekly ranking across all channels.
- bbc_iplayer_requests
Number of BBC iPlayer requests (note: not available for all series, and only for series that aired on the BBC).
- us_season
An integer denoting US season (
1-5).- us_airdate
A date denoting original airdate of episode in the US, according to pbs.org.
Examples
if (require('tibble')) {
ratings
}
#> # A tibble: 94 × 11
#> series episode uk_airdate viewers_7…¹ viewe…² netwo…³ chann…⁴ bbc_i…⁵ episo…⁶
#> <dbl> <dbl> <date> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
#> 1 1 1 2010-08-17 2.24 7 NA NA NA 1
#> 2 1 2 2010-08-24 3 3 NA NA NA 2
#> 3 1 3 2010-08-31 3 2 NA NA NA 3
#> 4 1 4 2010-09-07 2.6 4 NA NA NA 4
#> 5 1 5 2010-09-14 3.03 1 NA NA NA 5
#> 6 1 6 2010-09-21 2.75 1 NA NA NA 6
#> 7 2 1 2011-08-16 3.1 2 NA NA NA 7
#> 8 2 2 2011-08-23 3.53 2 NA NA NA 8
#> 9 2 3 2011-08-30 3.82 1 NA NA NA 9
#> 10 2 4 2011-09-06 3.6 1 NA NA NA 10
#> # … with 84 more rows, 2 more variables: us_season <dbl>, us_airdate <chr>, and
#> # abbreviated variable names ¹viewers_7day, ²viewers_28day, ³network_rank,
#> # ⁴channels_rank, ⁵bbc_iplayer_requests, ⁶episode_count
head(ratings)
#> # A tibble: 6 × 11
#> series episode uk_airdate viewers_7day viewe…¹ netwo…² chann…³ bbc_i…⁴ episo…⁵
#> <dbl> <dbl> <date> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
#> 1 1 1 2010-08-17 2.24 7 NA NA NA 1
#> 2 1 2 2010-08-24 3 3 NA NA NA 2
#> 3 1 3 2010-08-31 3 2 NA NA NA 3
#> 4 1 4 2010-09-07 2.6 4 NA NA NA 4
#> 5 1 5 2010-09-14 3.03 1 NA NA NA 5
#> 6 1 6 2010-09-21 2.75 1 NA NA NA 6
#> # … with 2 more variables: us_season <dbl>, us_airdate <chr>, and abbreviated
#> # variable names ¹viewers_28day, ²network_rank, ³channels_rank,
#> # ⁴bbc_iplayer_requests, ⁵episode_count