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

921 rows sorted by CONTESTANT

✎ 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, ELIMINATION-8, ELIMINATION-9, ELIMINATION-10, DATES-1, DATES-2, DATES-3, DATES-4, DATES-5, DATES-7, DATES-8, DATES-9, DATES-10

DATES-6 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
905 905 Bachelor 01 01_ALEXA_X   E                   D5                
897 897 Bachelor 01 01_AMANDA_M           W           D5 D1 D1 D1 D1        
912 912 Bachelor 01 01_AMBER_X E                                      
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                
342 342 Bachelorette 01 01_BILLY_X E                                      
331 331 Bachelorette 01 01_BOB_G     E                 D14 D5              
335 335 Bachelorette 01 01_BRIAN_C   E                   D14                
341 341 Bachelorette 01 01_BRIAN_H   EQ                   D14                
343 343 Bachelorette 01 01_BRIAN_K E                                      
336 336 Bachelorette 01 01_BRIAN_S   E                   D14                
337 337 Bachelorette 01 01_BROOK_X   E                   D14                
901 901 Bachelor 01 01_CATHY_G     E                 D5 D4              
328 328 Bachelorette 01 01_CHARLIE_M           E           D14 D1 D1 D1 D1        
902 902 Bachelor 01 01_CHRISTINA_X     E                 D5 D4              
344 344 Bachelorette 01 01_CHRIS_X E                                      
913 913 Bachelor 01 01_DANIELA_X E                                      
914 914 Bachelor 01 01_DENISE_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                                      
330 330 Bachelorette 01 01_GREG_T       E               D14 D5 D1            
915 915 Bachelor 01 01_JACKIE_X E                                      
338 338 Bachelorette 01 01_JACK_X   E                   D14                
332 332 Bachelorette 01 01_JAMIE_B     E                 D14 D5              
339 339 Bachelorette 01 01_JEFF_X   E                   D14                
916 916 Bachelor 01 01_JILL_X E                                      
340 340 Bachelorette 01 01_JOSH_X   E                   D14                
909 909 Bachelor 01 01_KATIE_X   E                   D5                
900 900 Bachelor 01 01_KIM_X       E               D5 D4 D1            
917 917 Bachelor 01 01_KRISTINA_X E                                      
903 903 Bachelor 01 01_LANEASE_A     E                 D5 D4              
918 918 Bachelor 01 01_LISA_X E                                      
348 348 Bachelorette 01 01_MATT_X E                                      
910 910 Bachelor 01 01_MELISSA_X   E                   D5                
333 333 Bachelorette 01 01_MIKE_X     E                 D14 D5              
919 919 Bachelor 01 01_PAULA_X E                                      
349 349 Bachelorette 01 01_PAUL_X E                                      
350 350 Bachelorette 01 01_PETER_X E                                      
920 920 Bachelor 01 01_RACHEL_X E                                      
904 904 Bachelor 01 01_RHONDA_X     E                 D5 D4              
334 334 Bachelorette 01 01_ROB_X     E                 D14 D5              
329 329 Bachelorette 01 01_RUSS_X         E             D14 D1 D1 D1          
327 327 Bachelorette 01 01_RYAN_S           W           D14 D1 D1 D1 D1        
899 899 Bachelor 01 01_SHANNON_O         E             D5 D1 D1 D1          
911 911 Bachelor 01 01_TINA_X   E                   D5                
898 898 Bachelor 01 01_TRISTA_R           E           D5 D1 D1 D1 D1        
351 351 Bachelorette 01 01_WAYNE_X E                                      
921 921 Bachelor 01 01_WENDI_X E                                      
316 316 Bachelorette 02 02_AARON_X E                                      
887 887 Bachelor 02 02_AMBER_X E                                      
317 317 Bachelorette 02 02_ANDY_C E                                      
875 875 Bachelor 02 02_ANGELA_X         E             D5 D5 D3 D1          
886 886 Bachelor 02 02_ANINDITA_X   EQ                   D5                
318 318 Bachelorette 02 02_ANSELM_C E                                      
305 305 Bachelorette 02 02_BRAD_X       E               D7 D7 D4            
319 319 Bachelorette 02 02_BRIAN_X E                                      
873 873 Bachelor 02 02_BROOKE_S             E         D5 D1 D3 D1 D1        
888 888 Bachelor 02 02_CAMILLE_X E                                      
889 889 Bachelor 02 02_CARI_X E                                      
303 303 Bachelorette 02 02_CHAD_X           E           D7 D7 D1 D1 D1        
878 878 Bachelor 02 02_CHRISTI_X     E                 D5 D5              
890 890 Bachelor 02 02_CHRISTY_X E                                      
320 320 Bachelorette 02 02_CHRIS_X E                                      
321 321 Bachelorette 02 02_CORY_H E                                      
311 311 Bachelorette 02 02_DAMON_X   E                   D7                
882 882 Bachelor 02 02_DANA_X   E                   D5                
312 312 Bachelorette 02 02_ELIOT_X   E                   D7                
883 883 Bachelor 02 02_ERIN_X   E                   D5                
891 891 Bachelor 02 02_ERIN_X E                                      
892 892 Bachelor 02 02_FATIMA_X E                                      
885 885 Bachelor 02 02_FRANCES_X   EQ                   D5                
874 874 Bachelor 02 02_GWEN_G           E           D5 D3 D1 D1 D1        
313 313 Bachelorette 02 02_HAROLD_H   E                   D7                
876 876 Bachelor 02 02_HAYLEY_X       E               D5 D3 D3            
877 877 Bachelor 02 02_HEATHER_C       E               D5 D5 D1            
879 879 Bachelor 02 02_HEATHER_X     E                 D5 D5              
872 872 Bachelor 02 02_HELENE_E             W         D5 D1 D1 D1 D1 D1      
301 301 Bachelorette 02 02_IAN_M             W         D7 D1 D4 D1 D1 D1      
322 322 Bachelorette 02 02_JEFF_O E                                      
323 323 Bachelorette 02 02_JUSTIN_X E                                      
324 324 Bachelorette 02 02_KEITH_X E                                      
880 880 Bachelor 02 02_KYLA_X     E                 D5 D3              
304 304 Bachelorette 02 02_LANNY_X         E             D7 D7 D1 D1          
893 893 Bachelor 02 02_LIANGY_X E                                      
894 894 Bachelor 02 02_LORI_X E                                      
314 314 Bachelorette 02 02_MARCUS_X   E                   D7                
302 302 Bachelorette 02 02_MATTHEW_H             E         D7 D7 D1 D1 D1 D1      
895 895 Bachelor 02 02_MERILEE_X E                                      
308 308 Bachelorette 02 02_RICK_X     E                 D1 D7              
315 315 Bachelorette 02 02_ROBERT_X   E                   D7                
306 306 Bachelorette 02 02_RYAN_M       E               D7 D2 D4            
309 309 Bachelorette 02 02_RYAN_R     E                 D7 D7              
307 307 Bachelorette 02 02_SEAN_X       E               D7 D7 D4            
881 881 Bachelor 02 02_SHANNON_X     E                 D5 D5              
884 884 Bachelor 02 02_SUZANNE_X   E                   D5                
310 310 Bachelorette 02 02_TODD_X     E                 D7 D2              
325 325 Bachelorette 02 02_TREVER_X E                                      
283 283 Bachelorette 03 03_A.W.   E                   D7                

Next page

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