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

56 rows where SEASON = 13

✎ 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
2 2 Bachelorette 13 13_BRYAN_A R1     R R   R     W     D6 D13 D1 D7 D1 D1 D1 D1
3 3 Bachelorette 13 13_PETER_K   R       R R     E   D1 D6 D13 D9 D7 D1 D1 D1 D1
4 4 Bachelorette 13 13_ERIC_B     R     R R   E     D10 D8 D13 D9 D1 D3 D1 D1  
5 5 Bachelorette 13 13_DEAN_U   R   R     R E       D8 D8 D1 D9 D7 D1 D1    
6 6 Bachelorette 13 13_ADAM_G             ED         D10 D8 D13 D9 D7 D3      
7 7 Bachelorette 13 13_MATT_M             ED         D10   D13 D9 D7 D3      
8 8 Bachelorette 13 13_ALEX_B     R     E           D10 D6 D13 D9 D7        
9 9 Bachelorette 13 13_WILL_G         R ED           D10 D6 D13 D9 D1        
10 10 Bachelorette 13 13_KENNY_L         R ED           D8 D8 D13 D2 D7        
11 11 Bachelorette 13 13_ANTHONY_B     R   E               D1 D13 D9          
12 12 Bachelorette 13 13_JOSIAH_G   R     E             D10   D13 D9          
13 13 Bachelorette 13 13_LEE_G         ED             D10 D8 D13 D2          
14 14 Bachelorette 13 13_IGGY_R       E               D8   D13            
15 15 Bachelorette 13 13_JONATHAN_T       E               D8 D6 D13            
16 16 Bachelorette 13 13_JACK_S       ED               D8 D8 D1            
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                
20 20 Bachelorette 13 13_FRED_J     ED                 D8 D6              
21 21 Bachelorette 13 13_BLAKE_E   E                   D8                
22 22 Bachelorette 13 13_JAMEY_K   E                   D10                
23 23 Bachelorette 13 13_LUCAS_Y   E                   D8                
24 24 Bachelorette 13 13_DEMARIO_J   EU                   D10                
25 25 Bachelorette 13 13_BLAKE_K E                                      
26 26 Bachelorette 13 13_GRANT_H E                                      
27 27 Bachelorette 13 13_JEDIDIAH_B E                                      
28 28 Bachelorette 13 13_KYLE_S E                                      
29 29 Bachelorette 13 13_MICHAEL_B E                                      
30 30 Bachelorette 13 13_MILTON_L E                                      
31 31 Bachelorette 13 13_MOHIT_S E                                      
32 32 Bachelorette 13 13_ROB_H E                                      
582 582 Bachelor 13 13_MELISSA_R   R           W       D1 D8 D6 D1 D1 D1 D1    
583 583 Bachelor 13 13_MOLLY_M   R   R       E       D8   D1 D3 D1 D1 D1    
584 584 Bachelor 13 13_JILLIAN_H   R R       E         D1 D8 D6 D3 D1 D1      
585 585 Bachelor 13 13_NAOMI_C       R   E           D8 D8 D6 D1 D1        
586 586 Bachelor 13 13_STEPHANIE_H     R R E               D1 D2 D3          
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            
590 590 Bachelor 13 13_NIKKI_K R1     ED               D8 D8 D2            
591 591 Bachelor 13 13_ERICA_D     E                 D8 D8              
592 592 Bachelor 13 13_KARI_F     E                 D8                
593 593 Bachelor 13 13_NATALIE_G     ED                 D8 D1              
594 594 Bachelor 13 13_RAQUEL_M   E                                    
595 595 Bachelor 13 13_SHARON_S   E                   D8                
596 596 Bachelor 13 13_LISA_G   EQ                                    
597 597 Bachelor 13 13_ANN_L E                                      
598 598 Bachelor 13 13_DOMINIQUE_C E                                      
599 599 Bachelor 13 13_EMILY_H E                                      
600 600 Bachelor 13 13_JACKIE_H E                                      
601 601 Bachelor 13 13_JULIE_D E                                      
602 602 Bachelor 13 13_NICOLE_M E                                      
603 603 Bachelor 13 13_RENEE_S E                                      
604 604 Bachelor 13 13_SHELBY_G E                                      
605 605 Bachelor 13 13_STACIA_M E                                      
606 606 Bachelor 13 13_TREASURE_M 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
);