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

23 rows where DATES-3 = "D8"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
4 4 Bachelorette 13 13_ERIC_B     R     R R   E     D10 D8 D13 D9 D1 D3 D1 D1  
5 5 Bachelorette 13 13_DEAN_U   R   R     R E       D8 D8 D1 D9 D7 D1 D1    
6 6 Bachelorette 13 13_ADAM_G             ED         D10 D8 D13 D9 D7 D3      
10 10 Bachelorette 13 13_KENNY_L         R ED           D8 D8 D13 D2 D7        
13 13 Bachelorette 13 13_LEE_G         ED             D10 D8 D13 D2          
16 16 Bachelorette 13 13_JACK_S       ED               D8 D8 D1            
17 17 Bachelorette 13 13_BRADY_E     E                   D8              
18 18 Bachelorette 13 13_BRYCE_P     E                   D8              
557 557 Bachelor 14 14_TENLEY_M R1     R       E         D8 D6 D1 D1 D1 D1    
559 559 Bachelor 14 14_ALI_F   R       E           D1 D8 D6 D1 D1        
560 560 Bachelor 14 14_CORRIE_A         E             D6 D8 D6 D1          
561 561 Bachelor 14 14_ASHLEIGH_H       E               D6 D8 D6            
562 562 Bachelor 14 14_JESSIE_S       E               D5 D8 D6            
563 563 Bachelor 14 14_KATHRYN_S       ED               D5 D8 D2            
565 565 Bachelor 14 14_ELIZABETH_KI   R E                 D5 D8              
567 567 Bachelor 14 14_MICHELLE K     ED                   D8              
582 582 Bachelor 13 13_MELISSA_R   R           W       D1 D8 D6 D1 D1 D1 D1    
584 584 Bachelor 13 13_JILLIAN_H   R R       E         D1 D8 D6 D3 D1 D1      
585 585 Bachelor 13 13_NAOMI_C       R   E           D8 D8 D6 D1 D1        
588 588 Bachelor 13 13_MEGAN_P R     E                 D8 D6            
589 589 Bachelor 13 13_SHANNON_B       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              

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