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

50 rows where SEASON = 01

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, ELIMINATION-2, ELIMINATION-6, DATES-2, DATES-3

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
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                
342 342 Bachelorette 01 01_BILLY_X E                                      
343 343 Bachelorette 01 01_BRIAN_K E                                      
344 344 Bachelorette 01 01_CHRIS_X E                                      
345 345 Bachelorette 01 01_DUANE_X E                                      
346 346 Bachelorette 01 01_ERIC_X E                                      
347 347 Bachelorette 01 01_GREGG_H E                                      
348 348 Bachelorette 01 01_MATT_X E                                      
349 349 Bachelorette 01 01_PAUL_X E                                      
350 350 Bachelorette 01 01_PETER_X E                                      
351 351 Bachelorette 01 01_WAYNE_X E                                      
897 897 Bachelor 01 01_AMANDA_M           W           D5 D1 D1 D1 D1        
898 898 Bachelor 01 01_TRISTA_R           E           D5 D1 D1 D1 D1        
899 899 Bachelor 01 01_SHANNON_O         E             D5 D1 D1 D1          
900 900 Bachelor 01 01_KIM_X       E               D5 D4 D1            
901 901 Bachelor 01 01_CATHY_G     E                 D5 D4              
902 902 Bachelor 01 01_CHRISTINA_X     E                 D5 D4              
903 903 Bachelor 01 01_LANEASE_A     E                 D5 D4              
904 904 Bachelor 01 01_RHONDA_X     E                 D5 D4              
905 905 Bachelor 01 01_ALEXA_X   E                   D5                
906 906 Bachelor 01 01_AMY_X   E                   D5                
907 907 Bachelor 01 01_ANGELA_X   E                   D5                
908 908 Bachelor 01 01_ANGELIQUE_X   E                   D5                
909 909 Bachelor 01 01_KATIE_X   E                   D5                
910 910 Bachelor 01 01_MELISSA_X   E                   D5                
911 911 Bachelor 01 01_TINA_X   E                   D5                
912 912 Bachelor 01 01_AMBER_X E                                      
913 913 Bachelor 01 01_DANIELA_X E                                      
914 914 Bachelor 01 01_DENISE_X E                                      
915 915 Bachelor 01 01_JACKIE_X E                                      
916 916 Bachelor 01 01_JILL_X E                                      
917 917 Bachelor 01 01_KRISTINA_X E                                      
918 918 Bachelor 01 01_LISA_X E                                      
919 919 Bachelor 01 01_PAULA_X E                                      
920 920 Bachelor 01 01_RACHEL_X E                                      
921 921 Bachelor 01 01_WENDI_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
);