home / fivethirtyeight

Menu
  • GraphQL API

Bachelorette / Bachelor: bachelorette.csv

Table actions
  • GraphQL API for bachelorette/bachelorette

This table contains the data behind the stories:

  • How To Spot A Front-Runner On The ‘Bachelor’ Or ‘Bachelorette’
  • Rachel’s Season Is Fitting Neatly Into ‘Bachelorette’ History
  • Rachel Lindsay’s ‘Bachelorette’ Season, In Three Charts

Data was scraped from the Bachelor Nation Wiki and then missing seasons were filled in by ABC and FiveThirtyEight staffers.

Header Description
SHOW Bachelor or Bachelorette
SEASON Which season
CONTESTANT An identifier for the contestant in a given season
ELIMINATION-1 Who was eliminated in week 1
ELIMINATION-2 Who was eliminated in week 2
ELIMINATION-3 Who was eliminated in week 3
ELIMINATION-4 Who was eliminated in week 4
ELIMINATION-5 Who was eliminated in week 5
ELIMINATION-6 Who was eliminated in week 6
ELIMINATION-7 Who was eliminated in week 7
ELIMINATION-8 Who was eliminated in week 8
ELIMINATION-9 Who was eliminated in week 9
ELIMINATION-10 Who was eliminated in week 10
DATES-1 Who was on which date in week 1
DATES-2 Who was on which date in week 2
DATES-3 Who was on which date in week 3
DATES-4 Who was on which date in week 4
DATES-5 Who was on which date in week 5
DATES-6 Who was on which date in week 6
DATES-7 Who was on which date in week 7
DATES-8 Who was on which date in week 8
DATES-9 Who was on which date in week 9
DATES-10 Who was on which date in week 10
  • Eliminates connote either an elimination (starts with "E") or a rose (starts with "R").
  • Eliminations supercede roses.
  • "E" connotes a standard elimination, typically at a rose ceremony. "EQ" means the contestant quits. "EF" means the contestant was fired by production. "ED" connotes a date elimination. "EU" connotes an unscheduled elimination, one that takes place at a time outside of a date or rose ceremony.
  • "R" means the contestant received a rose. "R1" means the contestant got a first impression rose.
  • "D1" means a one-on-one date, "D2" means a 2-on-1, "D3" means a 3-on-1 group date, and so on.
  • Weeks of the show are deliminated by rose ceremonies, and may not line up exactly with episodes.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

921 rows sorted by DATES-2 descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, ELIMINATION-1, ELIMINATION-2, ELIMINATION-3, ELIMINATION-4, ELIMINATION-5, ELIMINATION-6, ELIMINATION-7, ELIMINATION-8, ELIMINATION-9, ELIMINATION-10, DATES-1, DATES-2, DATES-3, DATES-4, DATES-5, DATES-6, DATES-7, DATES-8, DATES-9

DATES-10 3 ✖

  • 10 33
  • D1 29
  • 2 1
Link rowid SHOW SEASON CONTESTANT ELIMINATION-1 ELIMINATION-2 ELIMINATION-3 ELIMINATION-4 ELIMINATION-5 ELIMINATION-6 ELIMINATION-7 ELIMINATION-8 ELIMINATION-9 ELIMINATION-10 DATES-1 DATES-2 ▲ DATES-3 DATES-4 DATES-5 DATES-6 DATES-7 DATES-8 DATES-9 DATES-10
5 5 Bachelorette 13 13_DEAN_U   R   R     R E       D8 D8 D1 D9 D7 D1 D1    
10 10 Bachelorette 13 13_KENNY_L         R ED           D8 D8 D13 D2 D7        
14 14 Bachelorette 13 13_IGGY_R       E               D8   D13            
15 15 Bachelorette 13 13_JONATHAN_T       E               D8 D6 D13            
16 16 Bachelorette 13 13_JACK_S       ED               D8 D8 D1            
20 20 Bachelorette 13 13_FRED_J     ED                 D8 D6              
21 21 Bachelorette 13 13_BLAKE_E   E                   D8                
23 23 Bachelorette 13 13_LUCAS_Y   E                   D8                
63 63 Bachelorette 11 11_BEN_H     R   R     E       D8 D6 D5 D1 D5 D1 D1    
64 64 Bachelorette 11 11_JARED_H       R   R E         D8 D6 D1 D9 D5 D1 D1    
67 67 Bachelorette 11 11_BEN_Z   R R     E           D8 D1 D8 D9 D5        
68 68 Bachelorette 11 11_TANNER_T           E           D8 D6 D8 D9 D5        
71 71 Bachelorette 11 11_JUSTIN_R       R E             D8   D8 D9          
73 73 Bachelorette 11 11_COREY_S       E               D8   D8            
79 79 Bachelorette 11 11_DANIEL_F   E                   D8                
80 80 Bachelorette 11 11_KUPAH_J   EU                   D8                
218 218 Bachelorette 05 05_ED_S     R             W   D8 D1 D10 D8   D1 D1 D1 D1
221 221 Bachelorette 05 05_WES_H   R           E       D8 D11 D10 D8 D6 D1 D1    
223 223 Bachelorette 05 05_MICHAEL_S         R   E         D8 D11 D10 D1 D6 D1      
225 225 Bachelorette 05 05_TANNER_P           E           D8 D11 D10 D8 D6        
231 231 Bachelorette 05 05_BRAD_S     E                 D8 D11              
233 233 Bachelorette 05 05_SASHA_P     ED                 D8 D1              
234 234 Bachelorette 05 05_BRIAN_D   E                   D8                
236 236 Bachelorette 05 05_MATHUE_J   E                   D8                
583 583 Bachelor 13 13_MOLLY_M   R   R       E       D8   D1 D3 D1 D1 D1    
585 585 Bachelor 13 13_NAOMI_C       R   E           D8 D8 D6 D1 D1        
587 587 Bachelor 13 13_LAUREN_W       E               D8   D6            
590 590 Bachelor 13 13_NIKKI_K R1     ED               D8 D8 D2            
591 591 Bachelor 13 13_ERICA_D     E                 D8 D8              
592 592 Bachelor 13 13_KARI_F     E                 D8                
593 593 Bachelor 13 13_NATALIE_G     ED                 D8 D1              
595 595 Bachelor 13 13_SHARON_S   E                   D8                
610 610 Bachelor 12 12_AMANDA_R R1     R     E         D8 D10 D1 D4 D1 D1      
611 611 Bachelor 12 12_NOELLE_D           E           D8 D10 D6 D1 D1        
612 612 Bachelor 12 12_MARSHANA_R       R E             D8 D10 D2 D4          
614 614 Bachelor 12 12_ASHLEE_W   R   E               D8 D10 D6            
616 616 Bachelor 12 12_HOLLY_D     R ED               D8 D1 D2            
619 619 Bachelor 12 12_KRISTINE_H     E                 D8 D10              
621 621 Bachelor 12 12_ERIN_H   E                   D8                
622 622 Bachelor 12 12_MICHELLE_P   E                   D8                
798 798 Bachelor 05 05_SUZIE_W       E               D8 D1 D3            
800 800 Bachelor 05 05_JESSICA_H     E                 D8 D6              
802 802 Bachelor 05 05_JENNY_S     E                 D8 D6              
804 804 Bachelor 05 05_JEANMARIE_C   E                   D8                
805 805 Bachelor 05 05_ANNECATHERINE_L   E                   D8                
806 806 Bachelor 05 05_AMBER_L   E                   D8                
807 807 Bachelor 05 05_MANDY_C   E                   D8                
808 808 Bachelor 05 05_KRISTY_R   E                   D8                
65 65 Bachelorette 11 11_JOE_B           R ED         D7 D6 D5   D2 D3      
66 66 Bachelorette 11 11_CHRIS_S       R     ED         D7 D6 D5 D9 D5 D1      
69 69 Bachelorette 11 11_JJ_L   R       ED           D7 D6 D8 D9 D2        
70 70 Bachelorette 11 11_JOSHUA_A         E             D7 D6 D5 D9          
72 72 Bachelorette 11 11_IAN_T         EQ             D7   D5 D9          
74 74 Bachelorette 11 11_JONATHAN_H       E               D7 D6 D8            
77 77 Bachelorette 11 11_TONY_H     EQ                 D7 D6              
219 219 Bachelorette 05 05_KIPTYN_L       R   R       E   D7 D11 D1 D8 D6 D1 D1 D1 D1
222 222 Bachelorette 05 05_JESSE_K       R R   E         D7   D10 D1 D6 D1      
227 227 Bachelorette 05 05_MARK_H       R E             D7 D11 D2 D8          
228 228 Bachelorette 05 05_DAVID_G R1     E               D7   D10            
229 229 Bachelorette 05 05_JUAN_B   R   E               D7 D11 D10            
230 230 Bachelorette 05 05_MIKE_S   R   ED               D7 D11 D2            
237 237 Bachelorette 05 05_SIMON_A   E                   D7                
249 249 Bachelorette 04 04_JESSE_C R1     R       W       D7 D10 D1 D4 D1 D1 D1    
250 250 Bachelorette 04 04_JASON_M     R         E       D7 D1 D6 D4 D1 D1 D1    
251 251 Bachelorette 04 04_JEREMY_A R1 R         E         D7 D10 D6 D1 D1 D1      
253 253 Bachelorette 04 04_SEAN_R       R E             D7 D10 D6 D1          
254 254 Bachelorette 04 04_BLAINE_T         E             D7 D10 D6 D4          
255 255 Bachelorette 04 04_BRIAN_T       E               D7 D10 D6            
256 256 Bachelorette 04 04_FREDERICK_G     R ED               D7 D10 D2            
257 257 Bachelorette 04 04_ROBERT_F     R ED               D7 D10 D2            
258 258 Bachelorette 04 04_PAUL_B   R E                 D7 D10              
259 259 Bachelorette 04 04_RONALD_M     E                 D7 D10              
260 260 Bachelorette 04 04_RICHARD_M R1   ED                 D7 D1              
261 261 Bachelorette 04 04_CHRISTOPHER_B   E                   D7                
262 262 Bachelorette 04 04_ERIC_P   E                   D7                
263 263 Bachelorette 04 04_RYAN_H   E                   D7                
275 275 Bachelorette 03 03_JERRY_F               W       D7 D6 D1 D1 D1 D1      
276 276 Bachelorette 03 03_JOHN PAUL_M             E         D7 D1 D4 D1 D1 D1      
277 277 Bachelorette 03 03_RYAN_SH           E           D7 D6 D1 D1 D1        
278 278 Bachelorette 03 03_WENDELL_J         E             D7 D6 D4 D1          
279 279 Bachelorette 03 03_FABRICE_L       EQ               D7 D1 D4            
280 280 Bachelorette 03 03_BEN_S       E               D7 D6 D4            
281 281 Bachelorette 03 03_JOSH_C     E                 D7 D6              
283 283 Bachelorette 03 03_A.W.   E                   D7                
284 284 Bachelorette 03 03_JASON_I   E                   D7                
285 285 Bachelorette 03 03_MARK   E                   D7                
286 286 Bachelorette 03 03_MATT_M   E                   D7                
287 287 Bachelorette 03 03_MICHAEL_F   E                   D7                
288 288 Bachelorette 03 03_RYAN_SM   E                   D7                
289 289 Bachelorette 03 03_STU_L   E                   D7                
301 301 Bachelorette 02 02_IAN_M             W         D7 D1 D4 D1 D1 D1      
302 302 Bachelorette 02 02_MATTHEW_H             E         D7 D7 D1 D1 D1 D1      
303 303 Bachelorette 02 02_CHAD_X           E           D7 D7 D1 D1 D1        
304 304 Bachelorette 02 02_LANNY_X         E             D7 D7 D1 D1          
305 305 Bachelorette 02 02_BRAD_X       E               D7 D7 D4            
306 306 Bachelorette 02 02_RYAN_M       E               D7 D2 D4            
307 307 Bachelorette 02 02_SEAN_X       E               D7 D7 D4            
309 309 Bachelorette 02 02_RYAN_R     E                 D7 D7              
310 310 Bachelorette 02 02_TODD_X     E                 D7 D2              
311 311 Bachelorette 02 02_DAMON_X   E                   D7                

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "bachelorette/bachelorette" (
"SHOW" TEXT,
  "SEASON" TEXT,
  "CONTESTANT" TEXT,
  "ELIMINATION-1" TEXT,
  "ELIMINATION-2" TEXT,
  "ELIMINATION-3" TEXT,
  "ELIMINATION-4" TEXT,
  "ELIMINATION-5" TEXT,
  "ELIMINATION-6" TEXT,
  "ELIMINATION-7" TEXT,
  "ELIMINATION-8" TEXT,
  "ELIMINATION-9" TEXT,
  "ELIMINATION-10" TEXT,
  "DATES-1" TEXT,
  "DATES-2" TEXT,
  "DATES-3" TEXT,
  "DATES-4" TEXT,
  "DATES-5" TEXT,
  "DATES-6" TEXT,
  "DATES-7" TEXT,
  "DATES-8" TEXT,
  "DATES-9" TEXT,
  "DATES-10" TEXT
);
Powered by Datasette · Queries took 29.316ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette