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

54 rows where DATES-4 = "D6"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, ELIMINATION-1, ELIMINATION-4, ELIMINATION-5, ELIMINATION-6, ELIMINATION-7, ELIMINATION-8, ELIMINATION-10, DATES-2, DATES-3, 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
89 89 Bachelorette 10 10_NICK_V R1   R     R R     EU     D1 D6 D9 D1 D4 D1 D1 D1
92 92 Bachelorette 10 10_BRIAN_O       R R   E         D14 D12 D6 D1 D6 D4      
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          
100 100 Bachelorette 10 10_ERIC_H   R   EU               D1 D12 D6            
250 250 Bachelorette 04 04_JASON_M     R         E       D7 D1 D6 D4 D1 D1 D1    
251 251 Bachelorette 04 04_JEREMY_A R1 R         E         D7 D10 D6 D1 D1 D1      
252 252 Bachelorette 04 04_GRAHAM_B   R       E           D1 D10 D6 D4 D1        
253 253 Bachelorette 04 04_SEAN_R       R E             D7 D10 D6 D1          
254 254 Bachelorette 04 04_BLAINE_T         E             D7 D10 D6 D4          
255 255 Bachelorette 04 04_BRIAN_T       E               D7 D10 D6            
413 413 Bachelor 19 19_WHITNEY_B     R   R         W     D1 D6 D9 D6 D1 D1 D1 D1
414 414 Bachelor 19 19_BECCA_T     R     R       E   D11 D12 D6 D9 D1 D1 D1 D1 D1
417 417 Bachelor 19 19_CARLY_W         R   E           D12 D6 D1 D6 D3      
418 418 Bachelor 19 19_BRITT_N R1       R R E         D11 D12 D6 D1 D6 D3      
426 426 Bachelor 19 19_NIKKI_D       E                 D12 D6            
427 427 Bachelor 19 19_JILIAN_A       ED               D11 D12 D6            
444 444 Bachelor 18 18_NIKKI_F     R R R         W   D13 D10 D6 D1 D6 D1 D1 D1 D1
445 445 Bachelor 18 18_CLARE_C   R     R R       E   D1   D6 D9 D1 D4 D1 D1 D1
446 446 Bachelor 18 18_ANDI_D       R   R R   EQ     D13 D10 D6 D9 D1 D4 D1 D1  
447 447 Bachelor 18 18_RENEE_O         R     E       D13 D10 D6 D1 D6 D4 D1    
448 448 Bachelor 18 18_CHELSIE_W     R       E         D13 D1 D6 D9 D6 D4      
450 450 Bachelor 18 18_KAT_H   R       E           D1   D6 D9 D6        
451 451 Bachelor 18 18_CASSANDRA_F     R     ED           D13 D1 D6 D9 D6        
452 452 Bachelor 18 18_ALLI_R         E             D13 D10 D6 D9          
453 453 Bachelor 18 18_DANIELLE_R         E               D10 D6 D9          
454 454 Bachelor 18 18_KELLY_T   R     E             D13 D10 D6 D9          
455 455 Bachelor 18 18_ELISE_M       E               D13   D6            
456 456 Bachelor 18 18_LAUREN_S       E               D13 D10 D6            
556 556 Bachelor 14 14_VIENNA_G     R         W       D5 D1 D6 D2 D1 D1 D1    
557 557 Bachelor 14 14_TENLEY_M R1     R       E         D8 D6 D1 D1 D1 D1    
559 559 Bachelor 14 14_ALI_F   R       E           D1 D8 D6 D1 D1        
560 560 Bachelor 14 14_CORRIE_A         E             D6 D8 D6 D1          
561 561 Bachelor 14 14_ASHLEIGH_H       E               D6 D8 D6            
562 562 Bachelor 14 14_JESSIE_S       E               D5 D8 D6            
582 582 Bachelor 13 13_MELISSA_R   R           W       D1 D8 D6 D1 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        
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            
608 608 Bachelor 12 12_SHAYNE_L     R         W       D7 D1 D6 D4 D1 D1 D1    
609 609 Bachelor 12 12_CHELSEA_W   R   R       E       D7 D10 D6 D1 D1 D1 D1    
611 611 Bachelor 12 12_NOELLE_D           E           D8 D10 D6 D1 D1        
613 613 Bachelor 12 12_ROBIN_C     R   E             D7 D10 D6 D4          
614 614 Bachelor 12 12_ASHLEE_W   R   E               D8 D10 D6            
615 615 Bachelor 12 12_KELLY_D       E               D7 D10 D6            
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        
638 638 Bachelor 11 11_HILARY_R     R   E             D7 D1 D6 D4          
639 639 Bachelor 11 11_KRISTY_K     R   E             D7 D5 D6 D4          
640 640 Bachelor 11 11_STEPHY_K     R E               D7 D6 D6            
642 642 Bachelor 11 11_MCCARTEN_D       E               D7 D6 D6            

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