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

52 rows where SEASON = 06

✎ 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-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
192 192 Bachelorette 06 06_ROBERT_M R1   R             W     D1 D7 D6 D4 D1 D1 D1 D1
193 193 Bachelorette 06 06_CHRIS_L       R           ED     D9 D1 D6 D4 D1 D1 D1 D1
194 194 Bachelorette 06 06_FRANK_N   R       R     EF     D1 D9 D7 D6 D1 D2 D1 D1  
195 195 Bachelorette 06 06_KIRK_D     R   R     E       D12 D9 D7 D1 D4 D1 D1    
196 196 Bachelorette 06 06_TY_B   R     R R E         D12   D7 D6 D1 D2      
197 197 Bachelorette 06 06_CRAIG_R           E           D12 D9 D7 D6 D4        
198 198 Bachelorette 06 06_JUSTIN_R         R EF           D12 D9   D2          
199 199 Bachelorette 06 06_CHRIS_N         E             D12 D9   D6          
200 200 Bachelorette 06 06_KASEY_K         ED             D12   D1 D2          
201 201 Bachelorette 06 06_JESSE_B   R   E               D1 D9 D7            
202 202 Bachelorette 06 06_JONATHAN_N       E               D12 D9 D7            
203 203 Bachelorette 06 06_JOHN_C     E                   D9              
204 204 Bachelorette 06 06_STEVE_K     E                 D12                
205 205 Bachelorette 06 06_HUNTER_W     ED                 D12 D1              
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                
209 209 Bachelorette 06 06_DEREK_X E                                      
210 210 Bachelorette 06 06_DERRICK_S E                                      
211 211 Bachelorette 06 06_JASON_W E                                      
212 212 Bachelorette 06 06_JAY_R E                                      
213 213 Bachelorette 06 06_JOHN_N E                                      
214 214 Bachelorette 06 06_KYLE_H E                                      
215 215 Bachelorette 06 06_PHIL_K E                                      
216 216 Bachelorette 06 06_TYLER_M E                                      
766 766 Bachelor 06 06_Mary               W         D2   D1 D1 D1 D1    
767 767 Bachelor 06 06_Tanya               E           D1   D1 D1 D1    
768 768 Bachelor 06 06_Cynthia             E               D1 D1 D1      
769 769 Bachelor 06 06_Cheresse           E           D1                
770 770 Bachelor 06 06_Andrea         E               D1              
771 771 Bachelor 06 06_Jayne         E             D1     D1          
772 772 Bachelor 06 06_Krysta       E                                
773 773 Bachelor 06 06_Elizabeth       E                   D1            
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              
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                                    
782 782 Bachelor 06 06_Leina   EQ                                    
783 783 Bachelor 06 06_Carolyn E                                      
784 784 Bachelor 06 06_Amy E                                      
785 785 Bachelor 06 06_Lisa E                                      
786 786 Bachelor 06 06_Nicole E                                      
787 787 Bachelor 06 06_Kerry E                                      
788 788 Bachelor 06 06_Alma E                                      
789 789 Bachelor 06 06_Kristin E                                      
790 790 Bachelor 06 06_Jennifer E                                      
791 791 Bachelor 06 06_Abby E                                      
792 792 Bachelor 06 06_Melinda 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
);