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-3 = "D6"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, ELIMINATION-1, ELIMINATION-3, ELIMINATION-4, ELIMINATION-5, ELIMINATION-6, ELIMINATION-7, ELIMINATION-8, DATES-1, 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
2 2 Bachelorette 13 13_BRYAN_A R1     R R   R     W     D6 D13 D1 D7 D1 D1 D1 D1
3 3 Bachelorette 13 13_PETER_K   R       R R     E   D1 D6 D13 D9 D7 D1 D1 D1 D1
8 8 Bachelorette 13 13_ALEX_B     R     E           D10 D6 D13 D9 D7        
9 9 Bachelorette 13 13_WILL_G         R ED           D10 D6 D13 D9 D1        
15 15 Bachelorette 13 13_JONATHAN_T       E               D8 D6 D13            
20 20 Bachelorette 13 13_FRED_J     ED                 D8 D6              
61 61 Bachelorette 11 11_SHAWN_B R1   R   R       W       D6 D8 D1   D3 D1 D1  
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    
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      
68 68 Bachelorette 11 11_TANNER_T           E           D8 D6 D8 D9 D5        
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          
74 74 Bachelorette 11 11_JONATHAN_H       E               D7 D6 D8            
75 75 Bachelorette 11 11_RYAN_B       E                 D6 D8            
76 76 Bachelorette 11 11_CLINT_A   R EU                 D1 D6              
77 77 Bachelorette 11 11_TONY_H     EQ                 D7 D6              
275 275 Bachelorette 03 03_JERRY_F               W       D7 D6 D1 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          
280 280 Bachelorette 03 03_BEN_S       E               D7 D6 D4            
281 281 Bachelorette 03 03_JOSH_C     E                 D7 D6              
282 282 Bachelorette 03 03_KEITH R1   E                 D1 D6              
634 634 Bachelor 11 11_DEANNA_P   R   R       E       D7 D6 D2 D4 D1 D1 D1    
635 635 Bachelor 11 11_JENNI_C R1     R       E       D7 D6 D1 D4 D1 D1 D1    
640 640 Bachelor 11 11_STEPHY_K     R E               D7 D6 D6            
642 642 Bachelor 11 11_MCCARTEN_D       E               D7 D6 D6            
643 643 Bachelor 11 11_LINDSEY_H     E                 D7 D6              
644 644 Bachelor 11 11_SARAH_N   R E                 D7 D6              
686 686 Bachelor 09 09_JENNIFER_W   R   R     W         D6 D6 D1 D1 D1 D1      
687 687 Bachelor 09 09_SADIE_M   R   R     E         D5 D6 D1 D1 D1 D1      
688 688 Bachelor 09 09_LISA_B R1 R       E           D1 D6 D4 D1 D1        
690 690 Bachelor 09 09_JEANETTE_P     R E               D6 D6 D4            
691 691 Bachelor 09 09_DESIREE_V       E               D6 D6 D4            
693 693 Bachelor 09 09_GINA_C     E                 D6 D6              
740 740 Bachelor 07 07_Sarah B.       R     W       D9 D10 D6 D1 D1 D1 D1      
741 741 Bachelor 07 07_Krisily R           EU       D9 D10 D6 D5 D1 D1 D1      
742 742 Bachelor 07 07_Sarah W. R1 R       E         D9 D1 D6 D5 D1 D1        
744 744 Bachelor 07 07_Anitra R     E             D5 D10 D6 D5            
745 745 Bachelor 07 07_Kindle R     E             D5 D10 D6 D5            
747 747 Bachelor 07 07_Jenny R   E               D6 D10 D6              
794 794 Bachelor 05 05_JESSICA_B             W         D7 D6 D1 D1 D1 D1      
799 799 Bachelor 05 05_KAREN_L       E               D7 D6 D3            
800 800 Bachelor 05 05_JESSICA_H     E                 D8 D6              
801 801 Bachelor 05 05_JULIE_D     E                 D7 D6              
802 802 Bachelor 05 05_JENNY_S     E                 D8 D6              
803 803 Bachelor 05 05_KATIE_G     E                 D7 D6              

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