Bachelorette / Bachelor: bachelorette.csv

Table actions

This table contains the data behind the stories:

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

48 rows where DATES-2 = "D8"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, ELIMINATION-2, ELIMINATION-3, ELIMINATION-4, ELIMINATION-5, ELIMINATION-6, ELIMINATION-7, DATES-3, DATES-4, DATES-5, DATES-6

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                

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
);