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

24 rows where DATES-4 = "D4"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
276 276 Bachelorette 03 03_JOHN PAUL_M             E         D7 D1 D4 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            
301 301 Bachelorette 02 02_IAN_M             W         D7 D1 D4 D1 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            
660 660 Bachelor 10 10_TESSA_H     R         W       D7 D2 D4 D1 D1 D1 D1    
661 661 Bachelor 10 10_BEVIN_P     R         E       D7   D4 D4 D1 D1 D1    
662 662 Bachelor 10 10_DANIELLE_I             E         D7 D4 D4 D4 D1 D1      
664 664 Bachelor 10 10_STEPHANIE_W         E             D7 D5 D4 D1          
665 665 Bachelor 10 10_TINA_W         E             D7 D5 D4 D4          
666 666 Bachelor 10 10_KATE_B       E               D7 D4 D4            
667 667 Bachelor 10 10_NICOLE_C       E               D7 D5 D4            
668 668 Bachelor 10 10_STEPHANIE_T R1 R   E               D1 D5 D4            
688 688 Bachelor 09 09_LISA_B R1 R       E           D1 D6 D4 D1 D1        
689 689 Bachelor 09 09_AGNESE_P     R   E             D5 D2 D4 D1          
690 690 Bachelor 09 09_JEANETTE_P     R E               D6 D6 D4            
691 691 Bachelor 09 09_DESIREE_V       E               D6 D6 D4            
715 715 Bachelor 08 08_Moana     R       E         D6, D12 D5 D4 D1 D1 D1      
716 716 Bachelor 08 08_Susan     R     E           D6, D12 D1 D4 D1 D1        
717 717 Bachelor 08 08_Sarah_B     R   E             D6, D12 D2 D4 D1          
719 719 Bachelor 08 08_Tara   R   E               D6, D12 D5 D4            

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