Sunday, August 7, 2016

The Ultimate SpotVault, Once Upon a Time


The Ultimate SpotVault is a fully sortable record of every single episode in the history of a veteran series. This allows you to compare both raw numbers (total viewership and adults 18-49 rating) as well as the historical-adjusted stat A18-49+ for episodes across different seasons. This table also has the lead-in's A18-49+ for each episode, so you can see which episodes had the most and least support.

Just click any category name at the top to sort, and hold SHIFT and click another to sort by the second category within the first. (For example, click '#' and SHIFT-click 'A18-49+' to arrange all season premieres by A18-49+.)

See the bottom of this page for a few additional pointers and explanations.

Tot#Seas
#
Date
Viewers
A18-49
A18-49+LeadTitle
11110/23/201112.934.0169
63
Pilot
21210/30/201111.703.9165
51
The Thing You Love the Most
31311/6/201111.453.8161
51
Snow Falls
41411/13/201111.363.8161
72
The Price of Gold
51511/27/201110.693.4144
76
That Still Small Voice
61612/4/20119.663.2135
59
The Shepherd
71712/11/20118.922.9123
68
The Heart Is a Lonely Hunter
8181/8/201210.353.7157
59
Desperate Souls
9191/15/20129.833.3140
51
True North
101101/22/20129.333.2135
47
7:15 AM
111111/29/201210.913.5148
80
Fruit of the Poisonous Tree
121122/12/20128.653.0127
85
Skin Deep
131132/19/20129.843.1131
85
What Happened to Frederick
141143/4/201210.673.4144
93
Dreamy
151153/11/20129.122.9123
59
Red-Handed
161163/18/20128.692.9123
55
Heart of Darkness
171173/25/20128.822.9123
51
Hat Trick
181184/1/20128.362.8119
51
The Stable Boy
191194/22/20128.843.0127
59
The Return
201204/29/20129.203.0127
63
The Stranger
211215/6/20128.953.0127
85
An Apple Red as Blood
221
99
5/13/20129.663.3140
68
A Land without Magic
23219/30/201211.363.9185
90
Broken
242210/7/20129.843.4161
71
We Are Both
252310/14/20129.453.0142
66
Lady of the Lake
262410/21/20129.893.3157
62
The Crocodile
272510/28/20129.853.4161
62
The Doctor
282611/4/201210.153.5166
81
Tallahassee
292711/11/20128.752.7128
66
Child of the Moon
302811/25/20128.823.1147
76
Into the Deep
312912/2/20129.103.1147
76
Queen of Hearts
322101/6/20139.103.1147
43
The Cricket Game
332111/13/20138.242.8133
66
The Outsider
342121/20/20137.682.4114
62
In the Name of the Brother
352132/10/20137.082.2104
85
Tiny
362142/17/20137.612.4114
71
Manhattan
372153/3/20137.392.2104
81
The Queen Is Dead
382163/10/20137.642.3109
66
The Miller's Daughter
392173/17/20137.452.3109
71
Welcome to Storybrooke
402183/24/20137.382.2104
62
Selfless, Brave and True
412194/21/20137.372.1100
62
Lacey
422204/28/20137.162.095
76
The Evil Queen
432215/5/20137.502.2104
71
Second Star to the Right
442
99
5/12/20137.332.3109
66
And Straight on 'Til Morning
45319/29/20138.522.6138
74
Heart of the Truest Believer
463210/6/20138.002.6138
37
Lost Girl
473310/13/20137.532.4127
64
Quite a Common Fairy
483410/20/20137.052.1111
58
Nasty Habits
493510/27/20137.232.2117
74
Good Form
503611/3/20137.552.3122
74
Ariel
513711/10/20136.712.1111
69
Dark Hollow
523811/17/20136.661.9101
74
Think Lovely Thoughts
533912/1/20136.641.9101
64
Save Henry
5431012/8/20136.942.1111
80
The New Neverland
5531112/15/20136.441.9101
74
Going Home
563123/9/20147.662.4127
64
New York City Serenade
573133/16/20147.752.4127
80
Witch Hunt
583143/23/20146.912.1111
74
The Tower
593153/30/20146.642.1111
69
Quiet Minds
603164/6/20147.262.4127
74
It's Not Easy Being Green
613174/13/20146.502.0106
69
The Jolly Roger
623184/20/20145.951.790
53
Bleeding Through
633194/27/20147.342.2117
85
A Curious Thing
643205/4/20146.862.1111
85
Kansas
653
99
5/11/20146.802.3122
85
Snow Drifts; There's No Place Like Home
66419/28/20149.473.5208
89
A Tale of Two Sisters
674210/5/20148.793.2190
48
White Out
684310/12/20147.922.7161
71
Rocky Road
694410/19/20148.072.7161
65
The Apprentice
704510/26/20146.872.4143
36
Breaking Glass
714611/2/20147.542.6155
71
Family Business
724711/9/20147.422.5149
89
The Snow Queen
734811/16/20146.802.4143
95
Smash the Mirror (Part 1 of 2); Smash the Mirror (Part 2 of 2)
744911/30/20146.432.1125
71
Fall
7541012/7/20146.202.0119
77
Shattered Sight
7641112/14/20145.691.7101
30
Heroes and Villains
774123/1/20156.662.2131
77
Darkness on the Edge of Town
784133/8/20156.722.1125
83
Unforgiven
794143/15/20155.881.8107
77
Enter the Dragon
804153/22/20155.791.9113
83
Poor Unfortunate Soul
814163/29/20155.481.7101
65
Best Laid Plans
824174/12/20155.171.695
65
Heart of Gold
834184/19/20155.121.7101
83
Sympathy for the De Vil
844194/26/20155.211.7101
89
Lily
854205/3/20155.311.7101
83
Mother
864
99
5/10/20155.511.8107
83
Operation Mongoose (Part 1 of 2); Operation Mongoose (Part 2 of 2)
87519/27/20155.921.8124
48
The Dark Swan
885210/4/20155.381.8124
55
The Price
895310/11/20155.281.6110
76
Siege Perilous
905410/18/20154.921.6110
55
The Broken Kingdom
915510/25/20155.121.6110
76
Dreamcatcher
925611/1/20154.831.5103
69
The Bear and the Bow
935711/8/20154.881.6110
69
Nimue
945811/15/20154.851.6110
62
Birth; The Bear King
955911/29/20154.381.389
69
Broken Heart
9651012/6/20154.561.389
48
Swan Song
975113/6/20164.011.389
41
Souls of the Departed
985123/13/20164.311.389
76
Labor of Love
995133/20/20163.541.176
76
Devil's Due
1005143/27/20163.511.069
55
The Brothers Jones
1015154/3/20163.781.176
69
Our Decay
1025164/10/20163.751.282
62
Her Handsome Hero
1035174/17/20163.751.282
69
Ruby Slippers
1045184/24/20163.851.282
82
Sisters
1055195/1/20163.771.282
89
Firebird
1065205/8/20163.751.176
82
Last Rites
1075
99
5/15/20164.071.282
Loc
Only You; An Untold Story
108619/25/20163.981.3106
49
The Savior
1096210/2/20163.711.190
82
A Bitter Draught
1106310/9/20164.111.298
73
The Other Shoe
1116410/16/20163.531.190
65
Strange Case
1126510/23/20163.401.082
65
Street Rats
1136610/30/20163.060.973
65
Dark Waters
1146711/6/20163.561.190
82
Heartless
1156811/13/20163.400.973
65
I'll Be Your Mirror
1166911/27/20163.271.082
82
The Changelings
11761012/4/20163.270.973
82
Wish You Were Here
1186113/5/20173.030.973
82
Tougher Than the Rest
1196123/12/20173.060.973
82
Murder Most Foul
1206133/19/20172.710.865
73
Ill-Boding Patterns
1216143/26/20172.850.973
73
Page 23
1226154/2/20172.800.865
73
A Wondrous Place
1236164/9/20172.600.757
57
Mother's Little Helper
1246174/16/20172.510.757
49
Awake
1256184/23/20172.690.865
90
Where Bluebirds Fly
1266194/30/20173.050.973
98
The Black Fairy
1276205/7/20172.870.865
82
The Song in Your Heart
1286
99
5/14/20172.950.973
65
The Final Battle (Part 1 of 2); The Final Battle (Part 2 of 2)

A few pointers for these tables:

1. 'Tot#' refers to the episode number in the entire history of the series. For now, double-length episodes with only one rating count just once in this number, but we may be able to change that in the future. '#' is the episode number within just its season. Season finales are always given a # of 99, which allows all finales to be more easily sorted together. Whenever there's a 99, though, you can hover over that number 99 to see what the actual season episode number is.

2. Hover over any lead-in number to see the name of the lead-in program!

3. As in the SpotVault proper, 'Lead' generally refers to the rating in just the last half-hour, providing a better picture of who was watching immediately before the show started. However, those breakdowns are not always available. In those situations the 'Lead' will be in italics, meaning 'Lead-in' refers to the entire program and not just the last half-hour. The general rule is that breakdowns are not available for the entire 2008-09, 2009-10 and 2015-16 seasons, plus a handful of weeks in other seasons (mostly holiday/summer weeks).

No comments:

Post a Comment

Newer Post Older Post Home
© SpottedRatings.com 2009-2017. All Rights Reserved.