home / fivethirtyeight

Mad Men: show-data.csv

This directory contains the data behind the story ‘Mad Men’ Is Ending. What’s Next For The Cast?

The primary file show-data.csv contains data of actors who appeared on at least half the episodes of television shows that were nominated for an Emmy for Outstanding Drama since the year 2000. It contains the following variables:

Header Definition
Performer The name of the actor, according to IMDb. This is not a unique identifier - two performers appeared in more than one program
Show The television show where this actor appeared in more than half the episodes
Show Start The year the television show began
Show End The year the television show ended, "PRESENT" if the show remains on the air as of May 10.
Status? Why the actor is no longer on the program: "END" if the show has concluded, "LEFT" if the show remains on the air.
CharEnd The year the character left the show. Equal to "Show End" if the performer stayed on until the final season.
Years Since 2015 minus CharEnd
#LEAD The number of leading roles in films the performer has appeared in since and including "CharEnd", according to OpusData
#SUPPORT The number of leading roles in films the performer has appeared in since and including "CharEnd", according to OpusData
#Shows The number of seasons of television of which the performer appeared in at least half the episodes since and including "CharEnd", according to OpusData
Score #LEAD + #Shows + 0.25*(#SUPPORT)
Score/Y "Score" divided by "Years Since"
lead_notes The list of films counted in #LEAD
support_notes The list of films counted in #SUPPORT
show_notes The seasons of shows counted in #Shows

The supplemental file performer-scores.csv is the consolidated data from show-data.csv made into a pivot table.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

248 rows

View and edit SQL

Link rowid Performer Show Show Start Show End Status? CharEnd Years Since #LEAD #SUPPORT #Shows Score Score/Y lead_notes support_notes show_notes
101 Milo Ventimiglia Heroes 2006 2010 END 2010 5 1 6 4 6.5 1.3 The Divide, 2012 That's My Boy, 2012; Kiss of the Damned, 2013; Grown Ups 2, 2013; Killing Season, 2013; Wild Card, 2015; Walter, 2015 Wolverine, Season 1; Mob City, Season 1; Chosen, Season 1-2
102 Masi Oka Heroes 2006 2010 END 2010 5 0 0 4 4.0 0.8     Hawaii Five-O, Season 2-5
103 Sam Waterston Law & Order 1990 2010 END 2010 5 0 0 3 3.0 0.6     The Newsroom, Season 1-3
104 Mary Lynn Rajskub 24 2001 2010 END 2010 5 0 2 3 3.5 0.7   Safety Not Guaranteed, 2012; The Kings of Summer, 2013 FCU: Fact Checker's Unit, Season 2; How to be a Gentleman, Season 1; 24: Live Another Day, Season 1
105 Emilie de Ravin Lost 2004 2010 END 2010 5 2 1 3 5.25 1.05 Remember Me, 2010; The Chameleon, 2011 Legend of the Guardians: The Owls of Ga'Hoole 3D, 2010 Once Upon A Time, Season 2-4
106 Henry Ian Cusick Lost 2004 2010 END 2010 5 1 0 3 4.0 0.8 The Girl on the Train, 2014   Scandal, Season 1; The 100, Season 1-2
107 Dominic Monaghan Lost 2004 2010 END 2010 5 1 0 3 4.0 0.8 The Day, 2012   FlashForward, Season 1; Goodnight Burbank, Season 1; 100 Code, Season 1
108 Hayden Panettiere Heroes 2006 2010 END 2010 5 3 1 3 6.25 1.25 Alpha and Omega 3D, 2010; Hoodwinked Too: Hood vs. Evil, 2011; Fireflies in the Garden, 2011 Scream 4, 2011 Nashville, Season 1-3
109 Sendhil Ramamurthy Heroes 2006 2010 END 2010 5 1 0 3 4.0 0.8 It's A Wonderful Afterlife, 2010   Covert Affairs, Season 1-2; Beauty and the Beast, Season 2
110 Julie Benz Dexter 2006 2013 END 2010 5 1 0 3 4.0 0.8 Answers to Nothing, 2011   No Ordinary Family, Season 1; Defiance, Season 1-2;
111 Jorge Garcia Lost 2004 2010 END 2010 5 1 0 2 3.0 0.6 The Wedding Ringer, 2015   Alcatraz, Season 1; Hawaii Five-O, Season 5
112 Naveen Andrews Lost 2004 2010 END 2010 5 0 1 2 2.25 0.45   Diana, 2013 Sinbad, Season 1; Once Upon A Time In Wonderland, Season 1
113 Yunjin Kim Lost 2004 2010 END 2010 5 0 0 2 2.0 0.4     Mistresses, Season 1-2
114 Terry O'Quinn Lost 2004 2010 END 2010 5 0 0 2 2.0 0.4     666 Park Ave, Season 1; Gang Related, Season 1
115 Greg Grunberg Heroes 2006 2010 END 2010 5 1 1 2 3.25 0.65 Big Ass Spider, 2013 Let's Kill Ward's Wide, 2015 Love Bites, Season 1; The Client List, Season 2;
116 Zachary Quinto Heroes 2006 2010 END 2010 5 2 2 2 4.5 0.9 Margin Call, 2011; Star Trek Into Darkness, 2013 What's Your Number, 2011; We'll Never Have Paris, 2015 American Horror Story, Season 2; The Slap, Season 1
117 Tate Donovan Damages 2007 2012 END 2010 5 0 1 2 2.25 0.45   Argo, 2012 Hostages, Season 1; 24: Live Another Day, Season 1
118 Josh Holloway Lost 2004 2010 END 2010 5 3 1 1 4.25 0.85 Stay Cool, 2011; Mission:Impossible - Ghost Protocol, 2011; Battle of the Year, 2013 Sabotage, 2014 Intelligence, Season 1
119 Jack Coleman Heroes 2006 2010 END 2010 5 0 0 1 1.0 0.2     Burn Notice, Season 7;
120 Ali Larter Heroes 2006 2010 END 2010 5 1 1 1 2.25 0.45 Lovesick, 2015 Resident Evil: Afterlife 3D Legends, Season 1
121 Ashley Crow Heroes 2006 2010 END 2010 5 0 0 1 1.0 0.2     The Secret Circle, Season 1
122 Shawn Doyle Big Love 2006 2011 End 2010 5 1 0 1 2.0 0.4 The Returned, 2014   Endgame, Season 1;
123 S. Epatha Merkerson Law & Order 1990 2010 END 2010 5 1 2 0 1.5 0.3 Peeples, 2013 Mother and Child, 2010; Lincoln, 2012  
124 Matthew Fox Lost 2004 2010 END 2010 5 1 2 0 1.5 0.3 Emperor, 2013 Alex Cross, 2012; World War Z, 2013  
125 Evangeline Lilly Lost 2004 2010 END 2010 5 0 4 0 1.0 0.2   Real Steel, 2011; The Hobbit: The Desolation of Smaug, 2013; The Hobbit: The Battle of the Five Armies, 2014; Ant-Man, 2015  
126 James Kyson Heroes 2006 2010 END 2010 5 0 0 0 0.0 0      
127 Cristine Rose Heroes 2006 2010 END 2010 5 0 0 0 0.0 0      
128 Melora Walters Big Love 2006 2011 End 2010 5 1 3 0 1.75 0.35 Underdogs, 2013 Love Ranch, 2010; I Melt with You, 2011; Short Term 12, 2013  
129 Harry Dean Stanton Big Love 2006 2011 End 2010 5 0 3 0 0.75 0.15   Rango, 2011; The Avengers, 2012; This Must Be The Place, 2012  
130 Ginnifer Goodwin Big Love 2006 2011 End 2011 4 1 1 5 6.25 1.5625 Something Borrowed, 2011 Take me Home tonight, 2011 Electric City, Season 1; Once Upon A Time, Season 1-4
131 Chlo‘ Sevigny Big Love 2006 2011 End 2011 4 1 2 4 5.5 1.375 The Wait, 2014 Mr. Nice, 2011; Little Accidents, 2015 Hit & Miss, Season 1; Portlandia, Season 3; Those Who Kill, Season 1; Bloodline, Season 1
132 Matt Ross Big Love 2006 2011 End 2011 4 0 0 4 4.0 1     Magic City, Season 1-2; Silicon Valley, Season 1-2
133 Connie Britton Friday Night Lights 2006 2011 END 2011 4 3 1 4 7.25 1.8125 The Fitzgerald Family Christmas, 2012; Angels Sing, 2013; This Is Where I Leave You, 2014 The To Do List, 2013 American Horror Story, Season 1; Nashville, Season 1-3
134 Jeanne Tripplehorn Big Love 2006 2011 End 2011 4 2 0 3 5.0 1.25 Morning, 2013; A Perfect Man, 2013   Electric City, Season 1; Criminal Minds Season 8-9
135 Aimee Teegarden Friday Night Lights 2006 2011 END 2011 4 2 2 3 5.5 1.375 Prom, 2011; Beneath the Darkness, 2012 Scream 4, 2011; Love and Honor, 2013 Aim High, Season 1-2; Star-Crossed, Season 1
136 Louanne Stephens Friday Night Lights 2006 2011 END 2011 4 0 0 3 3.0 0.75     Longmire, Season 1-3
137 Lisa Edelstein House 2004 2012 END 2011 4 0 0 2 2.0 0.5     The Legend of Korra, Season 2; Girlfriend's Guide to Divorce, Season 1
138 Joel McKinnon Miller Big Love 2006 2011 End 2011 4 0 2 2 2.5 0.625   Little Birds, 2012; Rushlights, 2013 Brooklyn Nine-Nine, Season 1-2
139 Jesse Plemons Friday Night Lights 2006 2011 END 2011 4 0 3 2 2.75 0.6875   Paul, 2011; Meeting Spencer, 2011; Battleship, 2012 Bent, Season 1; Breaking Bad, Season 5
140 Adrianne Palicki Friday Night Lights 2006 2011 END 2011 4 3 3 2 5.75 1.4375 Red Dawn, 2012; GI Joe: Retaliation, 2012; Dr. Cabbie, 2014 Elektra Luxx, 2011; Coffee Town, 2013; John Wick, 2014 About a Boy, Season 1; Agents of S.H.E.I.L.D., Season 2
141 Bill Paxton Big Love 2006 2011 End 2011 4 3 5 1 5.25 1.3125 Shanghai Calling, 2012; The Colony, 2013; Red Wing, 2013 Haywire, 2012; 2 Guns, 2013; Million Dollar Arm, 2014; Edge of Tomorrow, 2014; Nightcrawler, 2014 Hatfields & McCoys, Season 1;
142 Kyle Chandler Friday Night Lights 2006 2011 END 2011 4 1 6 1 3.5 0.875 Super 8, 2011 Argo, 2012; Zero Dark Thirty, 2012; Broken City, 2013; The Spectacular Now, 2013; Morning, 2013; The Wolf of Wall Street, 2013 Bloodline, Season 1
143 Zach Gilford Friday Night Lights 2006 2011 END 2011 4 3 3 1 4.75 1.1875 Answers to Nothing, 2011; In our Nature, 2013; Crazy Kind of Love, 2013 The Last Stand, 2013; Devil's Due, 2014; The Purge: Anarchy, 2014 Off The Map, Season 1
144 Derek Phillips Friday Night Lights 2006 2011 END 2011 4 0 1 1 1.25 0.3125   42, 2013 The Event, Season 1
145 Stacey Oristano Friday Night Lights 2006 2011 END 2011 4 0 0 1 1.0 0.25     Bunheads, Season 1
146 Douglas Smith Big Love 2006 2011 End 2011 4 2 3 0 2.75 0.6875 Percy Jackson: Sea of Monsters, 2013; Treading Water, 2015 Antiviral, 2013; Stage Fright, 2014; Ouija, 2014  
147 Grace Zabriskie Big Love 2006 2011 End 2011 4 0 2 0 0.5 0.125   Wring Cops, 2013; The Judge, 2014  
148 Keegan Holst Big Love 2006 2011 End 2011 4 0 0 0 0.0 0      
149 Garrett Gray Big Love 2006 2011 End 2011 4 0 0 0 0.0 0      
150 Amanda Seyfried Big Love 2006 2011 End 2011 4 8 3 0 8.75 2.1875 Red Riding Hood, 2011; In Time, 2011; Gine, 2012; Les Miserables, 2012; The Big Wedding, 2013; Epic, 2013; Lovelace, 2013; A Million Ways To Die In The West, 2014 The End of Love, 2013; Veronica Mars, 2014; While We're Young, 2015  
151 Mary Kay Place Big Love 2006 2011 End 2011 4 0 4 0 1.0 0.25   Smashed, 2012; Leonie, 2013; Bad Milo, 2013; Miss Meadows, 2014  
152 Daveigh Chase Big Love 2006 2011 End 2011 4 0 0 0 0.0 0      
153 Bruce Dern Big Love 2006 2011 End 2011 4 1 5 0 2.25 0.5625 Nebraska, 2013 Inside Out, 2011; The Hole 3D, 2012; Django Unchained, 2012; Kokuriko-zaka Kara, 2013; Cut Bank, 2015  
154 Brad Leland Friday Night Lights 2006 2011 END 2011 4 0 0 0 0.0 0      
155 Taylor Kitsch Friday Night Lights 2006 2011 END 2011 4 5 1 0 5.25 1.3125 The Bang Bang Club, 2011; John Carter, 2012; Battleship, 2012; Savages, 2012; The Grand Seduction, 2014 Lone Survivor, 2014  
156 Blue Deckert Friday Night Lights 2006 2011 END 2011 4 0 0 0 0.0 0      
157 Timothy F. Crowley Friday Night Lights 2006 2011 END 2011 4 0 0 0 0.0 0      
158 Siobhan Finneran Downton Abbey 2010 PRESENT LEFT 2012 3 0 0 8 8.0 2.666666667     The Syndicate, Season 2; Happy Valley, Season 1; Benidorm, Season 1-6
159 Jennifer Morrison House 2004 2012 END 2012 3 2 1 5 7.25 2.416666667 Knife Fight, 2013; Some Girl(s), 2013 Warrior, 2011 How I Met Your Mother, Season 6; Once Upon A Time, Season 1-4
160 Robert Sean Leonard House 2004 2012 END 2012 3 0 0 3 3.0 1     Falling Skies, Season 3
161 Jesse Spencer House 2004 2012 END 2012 3 1 0 3 4.0 1.333333333 The Girl is in Trouble, 2015   Chicago Fire, Season 1-3
162 Omar Epps House 2004 2012 END 2012 3 0 0 2 2.0 0.666666667     Resurrection, Season 1-2
163 Eric Dane Grey's Anatomy 2005 PRESENT LEFT 2012 3 0 0 1 1.0 0.333333333     The Last Ship, Season 1
164 David Harewood Homeland 2011 PRESENT LEFT 2012 3 0 0 1 1.0 0.333333333     Selfie, Season 1
165 Hugh Laurie House 2004 2012 END 2012 3 2 0 0 2.0 0.666666667 The Oranges, 2012; Mr. Pip, 2014    
166 Bobbin Bergstrom House 2004 2012 END 2012 3 0 0 0 0.0 0      
167 Peter Jacobson House 2004 2012 END 2012 3 0 1 0 0.25 0.083333333   White House Down, 2013  
168 Glenn Close Damages 2007 2012 END 2012 3 0 3 0 0.75 0.25   Guardians of the Galaxy, 2014; Low Down, 2014; 5 to 7, 2015  
169 Rose Byrne Damages 2007 2012 END 2012 3 5 3 0 5.75 1.916666667 I Give It A Year, 2013; Insidious Chapter 2, 2013; Neighbors, 2014; This is where I leave You, 2014; Adult Beginners, 2015 The Place Beyone the Pines, 2013; The Internship, 2013; Annie, 2014  
170 Zachary Booth Damages 2007 2012 END 2012 3 1 3 0 1.75 0.583333333 Keep the lights on, 2012 Dark Horse, 2012; Allegiance, 2012; Last Weekend, 2014  
171 Christina Robinson Dexter 2006 2013 END 2012 3 0 0 0 0.0 0      
172 Dan Stevens Downton Abbey 2010 PRESENT LEFT 2012 3 3 4 0 4.0 1.333333333 Summer in February, 2014; The Guest, 2014; Night at the Museum: Secret of the Tomb, 2014 Vamps, 2012; The Fifth Estate, 2013; A Walk Among the Tombstones, 2014; The Cobbler, 2015  
173 Bob Odenkirk Breaking Bad 2008 2013 END 2013 2 1 3 3 4.75 2.375 Dealin with Idiots, 2013 The Spectacular Now, 2013; Ass Backwards, 2013; Nebraska, 2013 Fargo, Season 1; The Birthday Boys, Season 1; Better Call Saul, Season 1
174 Michelle Fairley Game of Thrones 2011 PRESENT LEFT 2013 2 0 2 3 3.5 1.75   Ironclad: Battle for Blood, 2014; Jack et la mecanique du coeur, 2014 Suits, Season 3; 24: Live Another Day, Season 1; Resurrection, Season 2
175 David Zayas Dexter 2006 2013 END 2013 2 0 2 2 2.5 1.25   Annie, 2014; Ride, 2015 Saint George, Season 1; Gotham, Season 1
176 Dean Norris Breaking Bad 2008 2013 END 2013 2 1 2 2 3.5 1.75 Small Time, 2014 The Counselor, 2013; Men, Women and Children, 2014 Under The Dome, Season 1-2
177 Betsy Brandt Breaking Bad 2008 2013 END 2013 2 0 0 2 2.0 1     The Michael J. Fox Show, Season 1; Masters of Sex, Season 2;
178 Morena Baccarin Homeland 2011 PRESENT LEFT 2013 2 1 0 2 3.0 1.5 Back in the Day, 2014   The Red Tent, Season 1; Gotham, Season 1
179 Diego Klattenhoff Homeland 2011 PRESENT LEFT 2013 2 1 0 2 3.0 1.5 Pacific Rim, 2013   The Blacklist, Season 1-2
180 Marg Helgenberger CSI: Crime Scene Investigations 2000 PRESENT LEFT 2013 2 0 0 1 1.0 0.5     Intelligence, Season 1
181 James Remar Dexter 2006 2013 END 2013 2 1 2 1 2.5 1.25 Persecuted, 2014 Horns, 2014; Lap Dance, 2014 State of Affairs, Season 1;
182 Anna Gunn Breaking Bad 2008 2013 END 2013 2 0 0 1 1.0 0.5     Gracepoint, Season 1
183 Aaron Paul Breaking Bad 2008 2013 END 2013 2 4 1 1 5.25 2.625 Need for Speed, 2014; Decoding Annie Parker, 2014; Hellion, 2014; A Long Way Down, 2914 Exodus: Gods and Kings Bojack Horseman, Season 1
184 Jack Huston Boardwalk Empire 2010 2014 END 2013 2 1 3 1 2.75 1.375 Two Jacks, 2013 Kill your darlings, 2013; American Hustle, 2013; The Longest Ride, 2015 The Great Fire, Season 1
185 Michael C. Hall Dexter 2006 2013 END 2013 2 1 0 0 1.0 0.5 Cold in July, 2014 Kill Your Darlings, 2013  
186 Jennifer Carpenter Dexter 2006 2013 END 2013 2 0 1 0 0.25 0.125   The Devil's Hand, 2014  
187 C.S. Lee Dexter 2006 2013 END 2013 2 0 0 0 0.0 0      
188 Lauren VŽlez Dexter 2006 2013 END 2013 2 0 0 0 0.0 0      
189 Desmond Harrington Dexter 2006 2013 END 2013 2 0 0 0 0.0 0      
190 Bryan Cranston Breaking Bad 2008 2013 END 2013 2 2 1 0 2.25 1.125 Cold Comes the Night, 2014; Trumbo, 2015 Godzilla, 2014  
191 RJ Mitte Breaking Bad 2008 2013 END 2013 2 0 0 0 0.0 0      
192 Steven Michael Quezada Breaking Bad 2008 2013 END 2013 2 0 0 0 0.0 0      
193 Michael Stuhlbarg Boardwalk Empire 2010 2014 END 2013 2 0 2 0 0.5 0.25   Blue Jasmine, 2013; Cut Bank, 2015  
194 Anthony Laciura Boardwalk Empire 2010 2014 END 2013 2 0 0 0 0.0 0      
195 Brady Noon Boardwalk Empire 2010 2014 END 2013 2 0 0 0 0.0 0      
196 Connor Noon Boardwalk Empire 2010 2014 END 2013 2 0 0 0 0.0 0      
197 Lucy Gallina Boardwalk Empire 2010 2014 END 2013 2 0 0 0 0.0 0      
198 Josie Gallina Boardwalk Empire 2010 2014 END 2013 2 0 0 0 0.0 0      
199 Declan McTigue Boardwalk Empire 2010 2014 END 2013 2 0 0 0 0.0 0      
200 Rory McTigue Boardwalk Empire 2010 2014 END 2013 2 0 0 0 0.0 0      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "mad-men/show-data" (
"Performer" TEXT,
  "Show" TEXT,
  "Show Start" INTEGER,
  "Show End" TEXT,
  "Status?" TEXT,
  "CharEnd" INTEGER,
  "Years Since" INTEGER,
  "#LEAD" INTEGER,
  "#SUPPORT" INTEGER,
  "#Shows" INTEGER,
  "Score" REAL,
  "Score/Y" TEXT,
  "lead_notes" TEXT,
  "support_notes" TEXT,
  "show_notes" TEXT
)
Powered by Datasette · Query took 11.757ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub