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 = 03

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, ELIMINATION-1, ELIMINATION-2, ELIMINATION-4, 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
275 275 Bachelorette 03 03_JERRY_F               W       D7 D6 D1 D1 D1 D1      
276 276 Bachelorette 03 03_JOHN PAUL_M             E         D7 D1 D4 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          
279 279 Bachelorette 03 03_FABRICE_L       EQ               D7 D1 D4            
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              
283 283 Bachelorette 03 03_A.W.   E                   D7                
284 284 Bachelorette 03 03_JASON_I   E                   D7                
285 285 Bachelorette 03 03_MARK   E                   D7                
286 286 Bachelorette 03 03_MATT_M   E                   D7                
287 287 Bachelorette 03 03_MICHAEL_F   E                   D7                
288 288 Bachelorette 03 03_RYAN_SM   E                   D7                
289 289 Bachelorette 03 03_STU_L   E                   D7                
290 290 Bachelorette 03 03_ANDREW E                                      
291 291 Bachelorette 03 03_ANDY_L E                                      
292 292 Bachelorette 03 03_CHRIS_M E                                      
293 293 Bachelorette 03 03_CHRIS_C E                                      
294 294 Bachelorette 03 03_COLLIN_E E                                      
295 295 Bachelorette 03 03_DAVID_V E                                      
296 296 Bachelorette 03 03_ERIC_H E                                      
297 297 Bachelorette 03 03_ERIC_T E                                      
298 298 Bachelorette 03 03_KEVIN E                                      
299 299 Bachelorette 03 03_MATT_L E                                      
846 846 Bachelor 03 03_JEN_X             W         D5 D5 D1 D1 D1 D1      
847 847 Bachelor 03 03_KIRSTEN_X             E         D5 D1 D1 D1 D1 D1      
848 848 Bachelor 03 03_TINA_X           E           D5 D5 D3 D1 D1        
849 849 Bachelor 03 03_CRISTINA_X         E             D5 D3 D3 D1          
850 850 Bachelor 03 03_LIZ_X       E               D5 D3 D3            
851 851 Bachelor 03 03_ANN_MICHELLE_X       E               D5 D3 D1            
852 852 Bachelor 03 03_AUDREE_X     E                 D5 D5              
853 853 Bachelor 03 03_AMBER_X     E                 D5 D1              
854 854 Bachelor 03 03_HEATHER_X     E                 D5 D5              
855 855 Bachelor 03 03_TINA_X     E                 D5 D5              
856 856 Bachelor 03 03_RACHEL_X   E                   D5                
857 857 Bachelor 03 03_AMY_X   E                   D5                
858 858 Bachelor 03 03_SHANNON_X   E                   D5                
859 859 Bachelor 03 03_ELIZABETH_X   E                   D5                
860 860 Bachelor 03 03_CHRISTINA_X   EQ                   D5                
861 861 Bachelor 03 03_KERRI_X E                                      
862 862 Bachelor 03 03_AMY_X E                     D5                
863 863 Bachelor 03 03_JENNIFER_X E                                      
864 864 Bachelor 03 03_COURTNEY_X E                                      
865 865 Bachelor 03 03_ANGELA_X E                                      
866 866 Bachelor 03 03_GINNY_X E                                      
867 867 Bachelor 03 03_BROOKE_X E                                      
868 868 Bachelor 03 03_STEPHANIE_X E                                      
869 869 Bachelor 03 03_TIFFANY_X E                                      
870 870 Bachelor 03 03_KRISTEN_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
);