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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, ELIMINATION-1, 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
34 34 Bachelorette 12 12_JORDAN_R R1     R R         W   D6 D12 D11 D1 D5 D1 D1 D1 D1
38 38 Bachelorette 12 12_JAMES_T   R R       E         D6 D1 D11 D9 D5 D3      
39 39 Bachelorette 12 12_ALEX_W       R     ED         D6 D12 D2 D9 D5 D1      
47 47 Bachelorette 12 12_CHAD_J       ED               D6 D12 D2            
48 48 Bachelorette 12 12_NICK_B     E                 D6 D12              
49 49 Bachelorette 12 12_CHRISTIAN_B     E                 D6 D12              
167 167 Bachelorette 07 07_BEN_F       R R         E   D6 D10 D10 D1 D6 D1 D1 D1 D1
170 170 Bachelorette 07 07_LUCAS_D           R E         D6 D10 D10 D8 D1 D3      
172 172 Bachelorette 07 07_BLAKE_J         R E           D6 D10 D10 D8 D6        
174 174 Bachelorette 07 07_NICK_P         E             D6 D10 D10 D8          
177 177 Bachelorette 07 07_WEST_L       E               D6   D10            
180 180 Bachelorette 07 07_BENTLEY_W   R EQ                 D6 D10              
357 357 Bachelor 21 21_KRISTINA_S       R R R EQ         D6 D7 D13 D10 D1 D3      
362 362 Bachelor 21 21_JAIMI_K         E             D6 D7 D13 D10          
363 363 Bachelor 21 21_JOSEPHINE_T         E             D6   D13 D10          
366 366 Bachelor 21 21_ASTRID_L       E               D6 D7 D13            
369 369 Bachelor 21 21_CHRISTEN_W   R E                 D6 D7              
374 374 Bachelor 21 21_LIZ_S   ED                   D6                
387 387 Bachelor 20 20_AMANDA_S         R R R E       D6 D12 D12 D1 D7 D3 D1    
389 389 Bachelor 20 20_EMILY_F           R ED         D6 D12 D12 D9 D2 D1      
391 391 Bachelor 20 20_OLIVIA_C R1 R     R ED           D6 D12 D12 D9 D2        
397 397 Bachelor 20 20_HAYLEY_F       ED               D6 D12 D12            
399 399 Bachelor 20 20_SHUSHANNA_M     E                 D6 D12              
403 403 Bachelor 20 20_SAMANTHA_P   E                   D6                
416 416 Bachelor 19 19_JADE_R       R       E       D6   D1 D9 D6 D1 D1    
421 421 Bachelor 19 19_ASHLEY_I           ED           D6   D8 D9 D2        
422 422 Bachelor 19 19_MACKENZIE_D   R     E             D6 D12 D8 D9          
433 433 Bachelor 19 19_KIMBERLY_S E                     D6                
434 434 Bachelor 19 19_TANDRA_S   E                   D6                
435 435 Bachelor 19 19_TARA_E   E                   D6                
558 558 Bachelor 14 14_GIA_A       R     EQ         D6   D1 D2 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            
566 566 Bachelor 14 14_VALISHIA_S     E                 D6                
569 569 Bachelor 14 14_CRISTINA_M   E                   D6                
570 570 Bachelor 14 14_ROZLYN_P   EF                   D6                
686 686 Bachelor 09 09_JENNIFER_W   R   R     W         D6 D6 D1 D1 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              
695 695 Bachelor 09 09_SARAH_S   E                   D6                
696 696 Bachelor 09 09_KIM_J   E                   D6                
822 822 Bachelor 04 04_Mary           E           D6 D3 D1 D1 D1        
825 825 Bachelor 04 04_Lee-Ann       E               D6 D1 D3            
828 828 Bachelor 04 04_Jenny     E                 D6 D5              
829 829 Bachelor 04 04_Antoinette     E                 D6 D5              
831 831 Bachelor 04 04_Lindsay   E                   D6                
832 832 Bachelor 04 04_Lanah   E                   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
);