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

43 rows where DATES-2 = "D14"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SEASON, ELIMINATION-2, ELIMINATION-3, ELIMINATION-4, ELIMINATION-5, ELIMINATION-6, ELIMINATION-7, DATES-3, 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
88 88 Bachelorette 10 10_JOSH_M     R   R         W   D14 D12   D1 D6 D1 D1 D1 D1
91 91 Bachelorette 10 10_MARCUS_G   R   R       E       D14 D12 D1 D9 D6 D1 D1    
92 92 Bachelorette 10 10_BRIAN_O       R R   E         D14 D12 D6 D1 D6 D4      
93 93 Bachelorette 10 10_DYLAN_P       R     E         D14   D1 D9 D6 D4      
95 95 Bachelorette 10 10_CODY_S           ED           D14 D12 D6 D9 D1        
97 97 Bachelorette 10 10_MARQUEL_M         E             D14 D12 D6 D9          
98 98 Bachelorette 10 10_PATRICK_J         E             D14 D12   D9          
99 99 Bachelorette 10 10_TASOS_H       E               D14 D12              
101 101 Bachelorette 10 10_BRADLEY_W     E                 D14 D12              
102 102 Bachelorette 10 10_BRETT_M     E                 D14 D12              
103 103 Bachelorette 10 10_RON_W     EQ                 D14 D12              
104 104 Bachelorette 10 10_CARL_K   E                   D14                
105 105 Bachelorette 10 10_CRAIG_M   E                   D14                
106 106 Bachelorette 10 10_NICK_S   E                   D14                
115 115 Bachelorette 09 09_DREW_K R1         R R     ED   D14 D10 D10 D7 D1 D2 D1 D1 D1
117 117 Bachelorette 09 09_ZAK_W R1     R   R   E       D14 D5 D10 D7 D1 D2 D1    
118 118 Bachelorette 09 09_MICHAEL_G R1       R   E         D14 D10 D10 D2 D6 D1      
119 119 Bachelorette 09 09_JAMES_C     R R   E           D14 D5 D1 D7 D6        
120 120 Bachelorette 09 09_JUAN_G           E           D14 D5 D10 D7 D6        
121 121 Bachelorette 09 09_KASEY_S     R     E           D14 D1 D10 D7 D6        
122 122 Bachelorette 09 09_MIKEY_T         E             D14 D10 D10 D7          
123 123 Bachelorette 09 09_BEN_S R1 R     ED             D14 D10 D10 D2          
125 125 Bachelorette 09 09_ZACK_K       E               D14 D10              
127 127 Bachelorette 09 09_BRANDON_A     E                 D14 D10              
128 128 Bachelorette 09 09_DAN_C     E                 D14 D5              
129 129 Bachelorette 09 09_BRIAN_J     EF                 D14 D10              
130 130 Bachelorette 09 09_NICK_M R1 E                   D14                
132 132 Bachelorette 09 09_WILL_R   E                   D14                
327 327 Bachelorette 01 01_RYAN_S           W           D14 D1 D1 D1 D1        
328 328 Bachelorette 01 01_CHARLIE_M           E           D14 D1 D1 D1 D1        
329 329 Bachelorette 01 01_RUSS_X         E             D14 D1 D1 D1          
330 330 Bachelorette 01 01_GREG_T       E               D14 D5 D1            
331 331 Bachelorette 01 01_BOB_G     E                 D14 D5              
332 332 Bachelorette 01 01_JAMIE_B     E                 D14 D5              
333 333 Bachelorette 01 01_MIKE_X     E                 D14 D5              
334 334 Bachelorette 01 01_ROB_X     E                 D14 D5              
335 335 Bachelorette 01 01_BRIAN_C   E                   D14                
336 336 Bachelorette 01 01_BRIAN_S   E                   D14                
337 337 Bachelorette 01 01_BROOK_X   E                   D14                
338 338 Bachelorette 01 01_JACK_X   E                   D14                
339 339 Bachelorette 01 01_JEFF_X   E                   D14                
340 340 Bachelorette 01 01_JOSH_X   E                   D14                
341 341 Bachelorette 01 01_BRIAN_H   EQ                   D14                

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