home / fivethirtyeight

Menu
  • GraphQL API

Bachelorette / Bachelor: bachelorette.csv

Table actions
  • GraphQL API for bachelorette/bachelorette

This table contains the data behind the stories:

  • How To Spot A Front-Runner On The ‘Bachelor’ Or ‘Bachelorette’
  • Rachel’s Season Is Fitting Neatly Into ‘Bachelorette’ History
  • Rachel Lindsay’s ‘Bachelorette’ Season, In Three Charts

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 SEASON

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, 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

ELIMINATION-1 7 ✖

  • E 299
  • R1 45
  • 1 34
  • EU 7
  • R 6
  • EF 1
  • EQ 1

DATES-10 3 ✖

  • 10 33
  • D1 29
  • 2 1
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                                      
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                                      
275 275 Bachelorette 03 03_JERRY_F               W       D7 D6 D1 D1 D1 D1      

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
);
Powered by Datasette · Queries took 24.515ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette