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
76
Pilot
21210/30/201111.703.9165
59
The Thing You Love the Most
31311/6/201111.453.8161
59
Snow Falls
41411/13/201111.363.8161
85
The Price of Gold
51511/27/201110.693.4144
89
That Still Small Voice
61612/4/20119.663.2135
72
The Shepherd
71712/11/20118.922.9123
80
The Heart Is a Lonely Hunter
8181/8/201210.353.7157
63
Desperate Souls
9191/15/20129.833.3140
59
True North
101101/22/20129.333.2135
55
7:15 AM
111111/29/201210.913.5148
85
Fruit of the Poisonous Tree
121122/12/20128.653.0127
93
Skin Deep
131132/19/20129.843.1131
89
What Happened to Frederick
141143/4/201210.673.4144
102
Dreamy
151153/11/20129.122.9123
63
Red-Handed
161163/18/20128.692.9123
63
Heart of Darkness
171173/25/20128.822.9123
59
Hat Trick
181184/1/20128.362.8119
55
The Stable Boy
191194/22/20128.843.0127
63
The Return
201204/29/20129.203.0127
68
The Stranger
211215/6/20128.953.0127
89
An Apple Red as Blood
221
99
5/13/20129.663.3140
76
A Land without Magic
23219/30/201211.363.9185
90
Broken
242210/7/20129.843.4161
85
We Are Both
252310/14/20129.453.0142
81
Lady of the Lake
262410/21/20129.893.3157
76
The Crocodile
272510/28/20129.853.4161
71
The Doctor
282611/4/201210.153.5166
95
Tallahassee
292711/11/20128.752.7128
76
Child of the Moon
302811/25/20128.823.1147
85
Into the Deep
312912/2/20129.103.1147
90
Queen of Hearts
322101/6/20139.103.1147
52
The Cricket Game
332111/13/20138.242.8133
71
The Outsider
342121/20/20137.682.4114
71
In the Name of the Brother
352132/10/20137.082.2104
95
Tiny
362142/17/20137.612.4114
76
Manhattan
372153/3/20137.392.2104
85
The Queen Is Dead
382163/10/20137.642.3109
71
The Miller's Daughter
392173/17/20137.452.3109
76
Welcome to Storybrooke
402183/24/20137.382.2104
71
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
71
And Straight on 'Til Morning
45319/29/20138.522.6138
80
Heart of the Truest Believer
463210/6/20138.002.6138
42
Lost Girl
473310/13/20137.532.4127
69
Quite a Common Fairy
483410/20/20137.052.1111
69
Nasty Habits
493510/27/20137.232.2117
85
Good Form
503611/3/20137.552.3122
85
Ariel
513711/10/20136.712.1111
80
Dark Hollow
523811/17/20136.661.9101
80
Think Lovely Thoughts
533912/1/20136.641.9101
69
Save Henry
5431012/8/20136.942.1111
90
The New Neverland
5531112/15/20136.441.9101
80
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
80
The Tower
593153/30/20146.642.1111
74
Quiet Minds
603164/6/20147.262.4127
74
It's Not Easy Being Green
613174/13/20146.502.0106
74
The Jolly Roger
623184/20/20145.951.790
48
Bleeding Through
633194/27/20147.342.2117
90
A Curious Thing
643205/4/20146.862.1111
90
Kansas
653
99
5/11/20146.802.3122
85
Snow Drifts; There's No Place Like Home
66419/28/20149.473.5208
107
A Tale of Two Sisters
674210/5/20148.793.2190
65
White Out
684310/12/20147.922.7161
83
Rocky Road
694410/19/20148.072.7161
77
The Apprentice
704510/26/20146.872.4143
42
Breaking Glass
714611/2/20147.542.6155
77
Family Business
724711/9/20147.422.5149
101
The Snow Queen
734811/16/20146.802.4143
107
Smash the Mirror (Part 1 of 2); Smash the Mirror (Part 2 of 2)
744911/30/20146.432.1125
83
Fall
7541012/7/20146.202.0119
83
Shattered Sight
7641112/14/20145.691.7101
30
Heroes and Villains
774123/1/20156.662.2131
71
Darkness on the Edge of Town
784133/8/20156.722.1125
89
Unforgiven
794143/15/20155.881.8107
83
Enter the Dragon
804153/22/20155.791.9113
95
Poor Unfortunate Soul
814163/29/20155.481.7101
77
Best Laid Plans
824174/12/20155.171.695
71
Heart of Gold
834184/19/20155.121.7101
89
Sympathy for the De Vil
844194/26/20155.211.7101
89
Lily
854205/3/20155.311.7101
89
Mother
864
99
5/10/20155.511.8107
89
Operation Mongoose (Part 1 of 2); Operation Mongoose (Part 2 of 2)
87519/27/20155.9251.8124
48
The Dark Swan
885210/4/20155.3791.8124
55
The Price
895310/11/20155.2761.6110
76
Siege Perilous
905410/18/20154.9221.6110
55
The Broken Kingdom
915510/25/20155.1221.6110
76
Dreamcatcher
925611/1/20154.8311.5103
69
The Bear and the Bow
935711/8/20154.8761.6110
69
Nimue
945811/15/20154.8531.6110
62
Birth; The Bear King
955911/29/20154.3791.389
69
Broken Heart
9651012/6/20154.5611.389
48
Swan Song
975113/6/20164.0121.389
41
Souls of the Departed
985123/13/20164.3131.389
76
Labor of Love
995133/20/20163.5361.176
76
Devil's Due
1005143/27/20163.5091.069
55
The Brothers Jones
1015154/3/20163.7771.176
69
Our Decay
1025164/10/20163.7511.282
62
Her Handsome Hero
1035174/17/20163.7551.282
69
Ruby Slippers
1045184/24/20163.8481.282
82
Sisters
1055195/1/20163.7661.282
89
Firebird
1065205/8/20163.7491.176
82
Last Rites
1075
99
5/15/20164.0661.282
Loc
Only You; An Untold Story
108619/25/20163.9851.3106
49
The Savior
1096210/2/20163.7131.190
82
A Bitter Draught
1106310/9/20164.1051.298
73
The Other Shoe
1116410/16/20163.5271.190
65
Strange Case
1126510/23/20163.4011.082
65
Street Rats
1136610/30/20163.0550.973
65
Dark Waters
1146711/6/20163.5581.190
82
Heartless
1156811/13/20163.4010.973
65
I'll Be Your Mirror
1166911/27/20163.2741.082
82
The Changelings
11761012/4/20163.2680.973
82
Wish You Were Here
1186113/5/20173.0270.973
82
Tougher Than the Rest
1196123/12/20173.0620.973
82
Murder Most Foul
1206133/19/20172.7120.865
73
Ill-Boding Patterns
1216143/26/20172.8470.973
73
Page 23
1226154/2/20172.7960.865
73
A Wondrous Place
1236164/9/20172.5970.757
57
Mother's Little Helper
1246174/16/20172.5110.757
49
Awake
1256184/23/20172.6910.865
90
Where Bluebirds Fly
1266194/30/20173.0540.973
98
The Black Fairy
1276205/7/20172.8650.865
82
The Song in Your Heart
1286
99
5/14/20172.9510.973
65
The Final Battle (Part 1 of 2); The Final Battle (Part 2 of 2)
1297110/6/20173.2570.74568
Loc
Hyperion Heights
1307210/13/20172.7400.69063
Loc
A Pirate's Life
1317310/20/20172.4850.53649
Loc
The Garden of Forking Paths
1327410/27/20172.4390.5348
Loc
Beauty
1337511/3/20172.2910.49145
Loc
Greenbacks
1347611/10/20172.3680.5046
Loc
Wake Up Call
1357711/17/20172.2710.4743
Loc
Eloise Gardener; Pretty in Blue
1367812/8/20172.4470.49345
Loc
One Little Tear
1377912/15/20172.2870.5247
Loc
The Eighth Witch
1387103/2/20182.1400.42739
Loc
Secret Garden
1397113/9/20182.2200.5247
Loc
A Taste of the Heights
1407123/16/20182.3780.47844
Loc
Knightfall
1417133/23/20182.1090.4339
Loc
The Girl in the Tower
1427143/30/20182.0320.4743
Loc
Sisterhood
1437154/6/20182.1520.4844
Loc
Breadcrumbs
1447164/13/20182.1810.4339
Loc
Chosen
1457174/20/20182.1170.4037
Loc
The Guardian
1467184/27/20181.9830.4642
Loc
Flower Child
1477195/4/20181.9820.4037
Loc
Is This Henry Mills?
1487205/11/20182.2570.4642
Loc
Homecoming
1497
99
5/18/20182.2660.48344
Loc
Leaving Storybrooke

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

© SpottedRatings.com 2009-2022. All Rights Reserved.