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

115 rows where ELIMINATION-2 = "E"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, DATES-1, DATES-2

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
21 21 Bachelorette 13 13_BLAKE_E   E                   D8                
22 22 Bachelorette 13 13_JAMEY_K   E                   D10                
23 23 Bachelorette 13 13_LUCAS_Y   E                   D8                
51 51 Bachelorette 12 12_WILL_H   E                   D10                
52 52 Bachelorette 12 12_JAMES_S   E                                    
53 53 Bachelorette 12 12_BRANDON_H   E                                    
78 78 Bachelorette 11 11_CORY_S   E                                    
79 79 Bachelorette 11 11_DANIEL_F   E                   D8                
104 104 Bachelorette 10 10_CARL_K   E                   D14                
105 105 Bachelorette 10 10_CRAIG_M   E                   D14                
106 106 Bachelorette 10 10_NICK_S   E                   D14                
130 130 Bachelorette 09 09_NICK_M R1 E                   D14                
131 131 Bachelorette 09 09_ROBERT_G   E                                    
132 132 Bachelorette 09 09_WILL_R   E                   D14                
156 156 Bachelorette 08 08_AARON_M   E                   D13                
157 157 Bachelorette 08 08_KYLE_D   E                   D13                
181 181 Bachelorette 07 07_MATT_C   E                                    
182 182 Bachelorette 07 07_RYAN_M   E                                    
183 183 Bachelorette 07 07_STEPHEN_D   E                                    
206 206 Bachelorette 06 06_CHRIS_H   E                   D12                
207 207 Bachelorette 06 06_CRAIG_M   E                   D12                
208 208 Bachelorette 06 06_TYLER_V   E                   D12                
234 234 Bachelorette 05 05_BRIAN_D   E                   D8                
235 235 Bachelorette 05 05_JULIEN_H   E                                    
236 236 Bachelorette 05 05_MATHUE_J   E                   D8                
237 237 Bachelorette 05 05_SIMON_A   E                   D7                
261 261 Bachelorette 04 04_CHRISTOPHER_B   E                   D7                
262 262 Bachelorette 04 04_ERIC_P   E                   D7                
263 263 Bachelorette 04 04_RYAN_H   E                   D7                
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                
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                
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                
371 371 Bachelor 21 21_LACEY_M   E                   D12                
372 372 Bachelor 21 21_HAILEY_M   E                   D12                
373 373 Bachelor 21 21_ELIZABETH_W   E                   D12                
401 401 Bachelor 20 20_JACKIE_D   E                   D10                
402 402 Bachelor 20 20_MANDI_K   E                   D10                
403 403 Bachelor 20 20_SAMANTHA_P   E                   D6                
431 431 Bachelor 19 19_ALISSA_G   E                   D11                
432 432 Bachelor 19 19_JORDAN_B   E                                    
434 434 Bachelor 19 19_TANDRA_S   E                   D6                
435 435 Bachelor 19 19_TARA_E   E                   D6                
459 459 Bachelor 18 18_AMY_L   E                                    
460 460 Bachelor 18 18_CHANTEL_F   E                   D13                
488 488 Bachelor 17 17_BROOKE_B R1 E                   D13                
489 489 Bachelor 17 17_DIANA_W R1 E                   D13                
515 515 Bachelor 16 16_JENNA_B   E                   D12                
516 516 Bachelor 16 16_SHAWN_R   E                   D12                
542 542 Bachelor 15 15_KELTIE_C   E                   D15                
543 543 Bachelor 15 15_MELISSA_S   E                   D15                
544 544 Bachelor 15 15_RAICHHEL_G   E                   D15                
568 568 Bachelor 14 14_ASHLEY_E   E                   D5                
569 569 Bachelor 14 14_CRISTINA_M   E                   D6                
594 594 Bachelor 13 13_RAQUEL_M   E                                    
595 595 Bachelor 13 13_SHARON_S   E                   D8                
620 620 Bachelor 12 12_CARRI_P   E                   D7                
621 621 Bachelor 12 12_ERIN_H   E                   D8                
622 622 Bachelor 12 12_MICHELLE_P   E                   D8                
647 647 Bachelor 11 11_MALLORY_S   E                   D7                
648 648 Bachelor 11 11_ERIN_G   E                   D7                
672 672 Bachelor 10 10_ALEXIS_Y   E                   D7                
673 673 Bachelor 10 10_SUSAN_A   E                   D7                
674 674 Bachelor 10 10_TIFFANY_W   E                   D7                
695 695 Bachelor 09 09_SARAH_S   E                   D6                
696 696 Bachelor 09 09_KIM_J   E                   D6                
697 697 Bachelor 09 09_ELLEN_D   E                   D5                
722 722 Bachelor 08 08_Cole   E                   D12                
723 723 Bachelor 08 08_Yvonne   E                   D12                
724 724 Bachelor 08 08_Elizabeth   E                   D12                
748 748 Bachelor 07 07_Kerry R1 E                 D6 D10                
749 749 Bachelor 07 07_Carrie   E                 D6 D10                
750 750 Bachelor 07 07_Gina Marie   E                 D9 D10                
778 778 Bachelor 06 06_Wende   E                                    
779 779 Bachelor 06 06_Natalie   E                                    
780 780 Bachelor 06 06_Ashley   E                                    
781 781 Bachelor 06 06_Kelley   E                                    
804 804 Bachelor 05 05_JEANMARIE_C   E                   D8                
805 805 Bachelor 05 05_ANNECATHERINE_L   E                   D8                
806 806 Bachelor 05 05_AMBER_L   E                   D8                
807 807 Bachelor 05 05_MANDY_C   E                   D8                
808 808 Bachelor 05 05_KRISTY_R   E                   D8                
809 809 Bachelor 05 05_CELESTE_C   E                   D7                
831 831 Bachelor 04 04_Lindsay   E                   D6                
832 832 Bachelor 04 04_Lanah   E                   D6                
833 833 Bachelor 04 04_Jenn   E                   D5                

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