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

65 rows where ELIMINATION-4 = "E"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, ELIMINATION-1, 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
14 14 Bachelorette 13 13_IGGY_R       E               D8   D13            
15 15 Bachelorette 13 13_JONATHAN_T       E               D8 D6 D13            
45 45 Bachelorette 12 12_JAMES_F       E               D10 D12 D11            
46 46 Bachelorette 12 12_DANIEL_M       E               D10 D12 D11            
73 73 Bachelorette 11 11_COREY_S       E               D8   D8            
74 74 Bachelorette 11 11_JONATHAN_H       E               D7 D6 D8            
75 75 Bachelorette 11 11_RYAN_B       E                 D6 D8            
99 99 Bachelorette 10 10_TASOS_H       E               D14 D12              
125 125 Bachelorette 09 09_ZACK_K       E               D14 D10              
150 150 Bachelorette 08 08_CHARLIE_G       E               D13 D12 D8            
151 151 Bachelorette 08 08_MICHAEL_N       E               D13 D12              
177 177 Bachelorette 07 07_WEST_L       E               D6   D10            
201 201 Bachelorette 06 06_JESSE_B   R   E               D1 D9 D7            
202 202 Bachelorette 06 06_JONATHAN_N       E               D12 D9 D7            
228 228 Bachelorette 05 05_DAVID_G R1     E               D7   D10            
229 229 Bachelorette 05 05_JUAN_B   R   E               D7 D11 D10            
255 255 Bachelorette 04 04_BRIAN_T       E               D7 D10 D6            
280 280 Bachelorette 03 03_BEN_S       E               D7 D6 D4            
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            
330 330 Bachelorette 01 01_GREG_T       E               D14 D5 D1            
366 366 Bachelor 21 21_ASTRID_L       E               D6 D7 D13            
367 367 Bachelor 21 21_SARAH_V       E               D12 D7 D13            
395 395 Bachelor 20 20_AMBER_J     R E               D10 D12 D12            
396 396 Bachelor 20 20_RACHEL_T       E                 D12 D12            
424 424 Bachelor 19 19_ASHLEY_S       E               D11 D12 D8            
425 425 Bachelor 19 19_JUELIA_K       E               D11 D12 D8            
426 426 Bachelor 19 19_NIKKI_D       E                 D12 D6            
455 455 Bachelor 18 18_ELISE_M       E               D13   D6            
456 456 Bachelor 18 18_LAUREN_S       E               D13 D10 D6            
483 483 Bachelor 17 17_AMANDA_M       E               D13 D12 D8            
510 510 Bachelor 16 16_MONICA_S       E               D12 D11              
536 536 Bachelor 15 15_LINDSAY_H       E                 D12 D9            
537 537 Bachelor 15 15_MEGHAN_M       E               D15   D9            
538 538 Bachelor 15 15_STACEY_Q       E               D15 D12 D9            
561 561 Bachelor 14 14_ASHLEIGH_H       E               D6 D8 D6            
562 562 Bachelor 14 14_JESSIE_S       E               D5 D8 D6            
587 587 Bachelor 13 13_LAUREN_W       E               D8   D6            
588 588 Bachelor 13 13_MEGAN_P R     E                 D8 D6            
589 589 Bachelor 13 13_SHANNON_B       E                 D8 D6            
614 614 Bachelor 12 12_ASHLEE_W   R   E               D8 D10 D6            
615 615 Bachelor 12 12_KELLY_D       E               D7 D10 D6            
640 640 Bachelor 11 11_STEPHY_K     R E               D7 D6 D6            
642 642 Bachelor 11 11_MCCARTEN_D       E               D7 D6 D6            
666 666 Bachelor 10 10_KATE_B       E               D7 D4 D4            
667 667 Bachelor 10 10_NICOLE_C       E               D7 D5 D4            
668 668 Bachelor 10 10_STEPHANIE_T R1 R   E               D1 D5 D4            
690 690 Bachelor 09 09_JEANETTE_P     R E               D6 D6 D4            
691 691 Bachelor 09 09_DESIREE_V       E               D6 D6 D4            
718 718 Bachelor 08 08_Jehan   R   E               D12 D5 D1            
719 719 Bachelor 08 08_Tara   R   E               D6, D12 D5 D4            
744 744 Bachelor 07 07_Anitra R     E             D5 D10 D6 D5            
745 745 Bachelor 07 07_Kindle R     E             D5 D10 D6 D5            
772 772 Bachelor 06 06_Krysta       E                                
773 773 Bachelor 06 06_Elizabeth       E                   D1            
798 798 Bachelor 05 05_SUZIE_W       E               D8 D1 D3            
799 799 Bachelor 05 05_KAREN_L       E               D7 D6 D3            
824 824 Bachelor 04 04_Brooke       E               D4 D5 D3            
825 825 Bachelor 04 04_Lee-Ann       E               D6 D1 D3            
850 850 Bachelor 03 03_LIZ_X       E               D5 D3 D3            
851 851 Bachelor 03 03_ANN_MICHELLE_X       E               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            
900 900 Bachelor 01 01_KIM_X       E               D5 D4 D1            

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