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

40 rows where DATES-3 = "D5"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, ELIMINATION-3, ELIMINATION-4, ELIMINATION-5, ELIMINATION-6, ELIMINATION-7, DATES-2, DATES-4, DATES-5, DATES-6, DATES-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
117 117 Bachelorette 09 09_ZAK_W R1     R   R   E       D14 D5 D10 D7 D1 D2 D1    
119 119 Bachelorette 09 09_JAMES_C     R R   E           D14 D5 D1 D7 D6        
120 120 Bachelorette 09 09_JUAN_G           E           D14 D5 D10 D7 D6        
124 124 Bachelorette 09 09_BRYDEN_V R1 R     EQ             D1 D5 D10            
128 128 Bachelorette 09 09_DAN_C     E                 D14 D5              
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              
636 636 Bachelor 11 11_BETTINA_B       R     E         D7 D5 D6 D1 D1 D1      
637 637 Bachelor 11 11_SHEENA_S           E           D7 D5 D6 D1 D1        
639 639 Bachelor 11 11_KRISTY_K     R   E             D7 D5 D6 D4          
641 641 Bachelor 11 11_JADE_B       ED               D7 D5 D2            
645 645 Bachelor 11 11_SOLISA_S     E                 D7 D5              
663 663 Bachelor 10 10_AMBER_A       R   E           D7 D5 D1 D4 D1        
664 664 Bachelor 10 10_STEPHANIE_W         E             D7 D5 D4 D1          
665 665 Bachelor 10 10_TINA_W         E             D7 D5 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            
714 714 Bachelor 08 08_Sarah_S       R     W         D12 D5 D1 D1 D1 D1      
715 715 Bachelor 08 08_Moana     R       E         D6, D12 D5 D4 D1 D1 D1      
718 718 Bachelor 08 08_Jehan   R   E               D12 D5 D1            
719 719 Bachelor 08 08_Tara   R   E               D6, D12 D5 D4            
721 721 Bachelor 08 08_Shiloh     E                 D6, D12 D5              
821 821 Bachelor 04 04_Estella             W         D5 D5 D1 D1 D1 D1      
824 824 Bachelor 04 04_Brooke       E               D4 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              
846 846 Bachelor 03 03_JEN_X             W         D5 D5 D1 D1 D1 D1      
848 848 Bachelor 03 03_TINA_X           E           D5 D5 D3 D1 D1        
852 852 Bachelor 03 03_AUDREE_X     E                 D5 D5              
854 854 Bachelor 03 03_HEATHER_X     E                 D5 D5              
855 855 Bachelor 03 03_TINA_X     E                 D5 D5              
875 875 Bachelor 02 02_ANGELA_X         E             D5 D5 D3 D1          
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              
881 881 Bachelor 02 02_SHANNON_X     E                 D5 D5              

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