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

25 rows where SEASON = 14

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ELIMINATION-1, ELIMINATION-2, ELIMINATION-3, ELIMINATION-4, DATES-2, DATES-3, DATES-4, 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
556 556 Bachelor 14 14_VIENNA_G     R         W       D5 D1 D6 D2 D1 D1 D1    
557 557 Bachelor 14 14_TENLEY_M R1     R       E         D8 D6 D1 D1 D1 D1    
558 558 Bachelor 14 14_GIA_A       R     EQ         D6   D1 D2 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            
564 564 Bachelor 14 14_ELLA_N     R ED                 D1 D2            
565 565 Bachelor 14 14_ELIZABETH_KI   R E                 D5 D8              
566 566 Bachelor 14 14_VALISHIA_S     E                 D6                
567 567 Bachelor 14 14_MICHELLE K     ED                   D8              
568 568 Bachelor 14 14_ASHLEY_E   E                   D5                
569 569 Bachelor 14 14_CRISTINA_M   E                   D6                
570 570 Bachelor 14 14_ROZLYN_P   EF                   D6                
571 571 Bachelor 14 14_LEX_M E                                      
572 572 Bachelor 14 14_CAITLYN_M E                                      
573 573 Bachelor 14 14_CHANNY_C E                                      
574 574 Bachelor 14 14_ELIZABETH_KR E                                      
575 575 Bachelor 14 14_EMILY_H E                                      
576 576 Bachelor 14 14_KIMBERLY_S E                                      
577 577 Bachelor 14 14_KIRSTEN_P E                                      
578 578 Bachelor 14 14_SHEILA_L E                                      
579 579 Bachelor 14 14_STEPHANIE_M E                                      
580 580 Bachelor 14 14_TIANA_K E                                      

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