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

49 rows where SEASON = 02

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
301 301 Bachelorette 02 02_IAN_M             W         D7 D1 D4 D1 D1 D1      
302 302 Bachelorette 02 02_MATTHEW_H             E         D7 D7 D1 D1 D1 D1      
303 303 Bachelorette 02 02_CHAD_X           E           D7 D7 D1 D1 D1        
304 304 Bachelorette 02 02_LANNY_X         E             D7 D7 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            
308 308 Bachelorette 02 02_RICK_X     E                 D1 D7              
309 309 Bachelorette 02 02_RYAN_R     E                 D7 D7              
310 310 Bachelorette 02 02_TODD_X     E                 D7 D2              
311 311 Bachelorette 02 02_DAMON_X   E                   D7                
312 312 Bachelorette 02 02_ELIOT_X   E                   D7                
313 313 Bachelorette 02 02_HAROLD_H   E                   D7                
314 314 Bachelorette 02 02_MARCUS_X   E                   D7                
315 315 Bachelorette 02 02_ROBERT_X   E                   D7                
316 316 Bachelorette 02 02_AARON_X E                                      
317 317 Bachelorette 02 02_ANDY_C E                                      
318 318 Bachelorette 02 02_ANSELM_C E                                      
319 319 Bachelorette 02 02_BRIAN_X E                                      
320 320 Bachelorette 02 02_CHRIS_X E                                      
321 321 Bachelorette 02 02_CORY_H E                                      
322 322 Bachelorette 02 02_JEFF_O E                                      
323 323 Bachelorette 02 02_JUSTIN_X E                                      
324 324 Bachelorette 02 02_KEITH_X E                                      
325 325 Bachelorette 02 02_TREVER_X E                                      
872 872 Bachelor 02 02_HELENE_E             W         D5 D1 D1 D1 D1 D1      
873 873 Bachelor 02 02_BROOKE_S             E         D5 D1 D3 D1 D1        
874 874 Bachelor 02 02_GWEN_G           E           D5 D3 D1 D1 D1        
875 875 Bachelor 02 02_ANGELA_X         E             D5 D5 D3 D1          
876 876 Bachelor 02 02_HAYLEY_X       E               D5 D3 D3            
877 877 Bachelor 02 02_HEATHER_C       E               D5 D5 D1            
878 878 Bachelor 02 02_CHRISTI_X     E                 D5 D5              
879 879 Bachelor 02 02_HEATHER_X     E                 D5 D5              
880 880 Bachelor 02 02_KYLA_X     E                 D5 D3              
881 881 Bachelor 02 02_SHANNON_X     E                 D5 D5              
882 882 Bachelor 02 02_DANA_X   E                   D5                
883 883 Bachelor 02 02_ERIN_X   E                   D5                
884 884 Bachelor 02 02_SUZANNE_X   E                   D5                
885 885 Bachelor 02 02_FRANCES_X   EQ                   D5                
886 886 Bachelor 02 02_ANINDITA_X   EQ                   D5                
887 887 Bachelor 02 02_AMBER_X E                                      
888 888 Bachelor 02 02_CAMILLE_X E                                      
889 889 Bachelor 02 02_CARI_X E                                      
890 890 Bachelor 02 02_CHRISTY_X E                                      
891 891 Bachelor 02 02_ERIN_X E                                      
892 892 Bachelor 02 02_FATIMA_X E                                      
893 893 Bachelor 02 02_LIANGY_X E                                      
894 894 Bachelor 02 02_LORI_X E                                      
895 895 Bachelor 02 02_MERILEE_X 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
);