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

83 rows where ELIMINATION-3 = "E"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
17 17 Bachelorette 13 13_BRADY_E     E                   D8              
18 18 Bachelorette 13 13_BRYCE_P     E                   D8              
19 19 Bachelorette 13 13_DIGGY_M     E                 D10                
48 48 Bachelorette 12 12_NICK_B     E                 D6 D12              
49 49 Bachelorette 12 12_CHRISTIAN_B     E                 D6 D12              
50 50 Bachelorette 12 12_ALI_Z     E                 D10 D12              
101 101 Bachelorette 10 10_BRADLEY_W     E                 D14 D12              
102 102 Bachelorette 10 10_BRETT_M     E                 D14 D12              
127 127 Bachelorette 09 09_BRANDON_A     E                 D14 D10              
128 128 Bachelorette 09 09_DAN_C     E                 D14 D5              
153 153 Bachelorette 08 08_STEVIE_A     E                 D13 D12              
178 178 Bachelorette 07 07_CHRIS_D     E                   D10              
179 179 Bachelorette 07 07_JEFF_M     E                   D10              
203 203 Bachelorette 06 06_JOHN_C     E                   D9              
204 204 Bachelorette 06 06_STEVE_K     E                 D12                
231 231 Bachelorette 05 05_BRAD_S     E                 D8 D11              
232 232 Bachelorette 05 05_TANNER_F     E                   D11              
258 258 Bachelorette 04 04_PAUL_B   R E                 D7 D10              
259 259 Bachelorette 04 04_RONALD_M     E                 D7 D10              
281 281 Bachelorette 03 03_JOSH_C     E                 D7 D6              
282 282 Bachelorette 03 03_KEITH R1   E                 D1 D6              
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              
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              
368 368 Bachelor 21 21_BRITTANY_F     E                 D12 D7              
369 369 Bachelor 21 21_CHRISTEN_W   R E                 D6 D7              
398 398 Bachelor 20 20_JAMI_L     E                   D12              
399 399 Bachelor 20 20_SHUSHANNA_M     E                 D6 D12              
428 428 Bachelor 19 19_AMBER_J     E                 D11 D12              
429 429 Bachelor 19 19_TRACY_D     E                 D11 D12              
430 430 Bachelor 19 19_TRINA_S     E                 D11                
457 457 Bachelor 18 18_CHRISTY_H     E                 D13 D10              
458 458 Bachelor 18 18_LUCY_A     E                 D13 D10              
485 485 Bachelor 17 17_KRISTY_K     E                 D13 D12              
486 486 Bachelor 17 17_TARYN_D     E                 D13 D12              
487 487 Bachelor 17 17_KACIE_B   R E                 D13 D12              
512 512 Bachelor 16 16_ERIKA_U     E                   D11              
513 513 Bachelor 16 16_JACLYN_S     E                 D12 D11              
539 539 Bachelor 15 15_KIMBERLY_C     E                 D15 D12              
540 540 Bachelor 15 15_SARAH_P     E                   D12              
565 565 Bachelor 14 14_ELIZABETH_KI   R E                 D5 D8              
566 566 Bachelor 14 14_VALISHIA_S     E                 D6                
591 591 Bachelor 13 13_ERICA_D     E                 D8 D8              
592 592 Bachelor 13 13_KARI_F     E                 D8                
617 617 Bachelor 12 12_AMY_R     E                 D7 D10              
618 618 Bachelor 12 12_ERIN_S     E                 D7 D10              
619 619 Bachelor 12 12_KRISTINE_H     E                 D8 D10              
643 643 Bachelor 11 11_LINDSEY_H     E                 D7 D6              
644 644 Bachelor 11 11_SARAH_N   R E                 D7 D6              
645 645 Bachelor 11 11_SOLISA_S     E                 D7 D5              
669 669 Bachelor 10 10_AMANDA_H     E                 D7 D4              
670 670 Bachelor 10 10_ERIN_P     E                 D7 D4              
693 693 Bachelor 09 09_GINA_C     E                 D6 D6              
721 721 Bachelor 08 08_Shiloh     E                 D6, D12 D5              
747 747 Bachelor 07 07_Jenny R   E               D6 D10 D6              
774 774 Bachelor 06 06_Amanda     E                                  
775 775 Bachelor 06 06_Kristie     E                                  
776 776 Bachelor 06 06_Susie     E                                  
777 777 Bachelor 06 06_Heather     E                   D2              
800 800 Bachelor 05 05_JESSICA_H     E                 D8 D6              
801 801 Bachelor 05 05_JULIE_D     E                 D7 D6              
802 802 Bachelor 05 05_JENNY_S     E                 D8 D6              
803 803 Bachelor 05 05_KATIE_G     E                 D7 D6              
826 826 Bachelor 04 04_Misty     E                 D5 D3              
827 827 Bachelor 04 04_Karin     E                 D4 D5              
828 828 Bachelor 04 04_Jenny     E                 D6 D5              
829 829 Bachelor 04 04_Antoinette     E                 D6 D5              
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              
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              
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              

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