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

50 rows where SEASON = 10

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, ELIMINATION-1, ELIMINATION-2, ELIMINATION-3, ELIMINATION-4, ELIMINATION-5, ELIMINATION-6, ELIMINATION-7, ELIMINATION-8, DATES-2, DATES-3, 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
88 88 Bachelorette 10 10_JOSH_M     R   R         W   D14 D12   D1 D6 D1 D1 D1 D1
89 89 Bachelorette 10 10_NICK_V R1   R     R R     EU     D1 D6 D9 D1 D4 D1 D1 D1
90 90 Bachelorette 10 10_CHRIS_S   R       R     ED     D1     D9 D6 D4 D1 D1  
91 91 Bachelorette 10 10_MARCUS_G   R   R       E       D14 D12 D1 D9 D6 D1 D1    
92 92 Bachelorette 10 10_BRIAN_O       R R   E         D14 D12 D6 D1 D6 D4      
93 93 Bachelorette 10 10_DYLAN_P       R     E         D14   D1 D9 D6 D4      
94 94 Bachelorette 10 10_JJ_O     R   R E             D1   D9 D6        
95 95 Bachelorette 10 10_CODY_S           ED           D14 D12 D6 D9 D1        
96 96 Bachelorette 10 10_ANDREW_P         E               D12 D6 D9          
97 97 Bachelorette 10 10_MARQUEL_M         E             D14 D12 D6 D9          
98 98 Bachelorette 10 10_PATRICK_J         E             D14 D12   D9          
99 99 Bachelorette 10 10_TASOS_H       E               D14 D12              
100 100 Bachelorette 10 10_ERIC_H   R   EU               D1 D12 D6            
101 101 Bachelorette 10 10_BRADLEY_W     E                 D14 D12              
102 102 Bachelorette 10 10_BRETT_M     E                 D14 D12              
103 103 Bachelorette 10 10_RON_W     EQ                 D14 D12              
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                
107 107 Bachelorette 10 10_EMIL_S E                                      
108 108 Bachelorette 10 10_JASON_L E                                      
109 109 Bachelorette 10 10_JOSH_B E                                      
110 110 Bachelorette 10 10_MIKE_C E                                      
111 111 Bachelorette 10 10_RUDIE_D E                                      
112 112 Bachelorette 10 10_STEVEN_W E                                      
660 660 Bachelor 10 10_TESSA_H     R         W       D7 D2 D4 D1 D1 D1 D1    
661 661 Bachelor 10 10_BEVIN_P     R         E       D7   D4 D4 D1 D1 D1    
662 662 Bachelor 10 10_DANIELLE_I             E         D7 D4 D4 D4 D1 D1      
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          
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            
669 669 Bachelor 10 10_AMANDA_H     E                 D7 D4              
670 670 Bachelor 10 10_ERIN_P     E                 D7 D4              
671 671 Bachelor 10 10_PEYTON_W     ED                 D7 D2              
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                
675 675 Bachelor 10 10_BLAKENEY_R E                                      
676 676 Bachelor 10 10_CANDICE_D E                                      
677 677 Bachelor 10 10_CATHERINE_W E                                      
678 678 Bachelor 10 10_DANIELLE_V E                                      
679 679 Bachelor 10 10_JACKIE_T E                                      
680 680 Bachelor 10 10_JEANETTE_A E                                      
681 681 Bachelor 10 10_JESSICA_D E                                      
682 682 Bachelor 10 10_LINDA_M E                                      
683 683 Bachelor 10 10_LINDSAY_S E                                      
684 684 Bachelor 10 10_TIFFANY_F E                                      

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