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

61 rows where DATES-2 = "D5"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SEASON, ELIMINATION-2, ELIMINATION-3, ELIMINATION-4, ELIMINATION-6, ELIMINATION-7, DATES-3, DATES-4, DATES-5

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
556 556 Bachelor 14 14_VIENNA_G     R         W       D5 D1 D6 D2 D1 D1 D1    
562 562 Bachelor 14 14_JESSIE_S       E               D5 D8 D6            
563 563 Bachelor 14 14_KATHRYN_S       ED               D5 D8 D2            
565 565 Bachelor 14 14_ELIZABETH_KI   R E                 D5 D8              
568 568 Bachelor 14 14_ASHLEY_E   E                   D5                
687 687 Bachelor 09 09_SADIE_M   R   R     E         D5 D6 D1 D1 D1 D1      
689 689 Bachelor 09 09_AGNESE_P     R   E             D5 D2 D4 D1          
692 692 Bachelor 09 09_JAMI_M     ED                 D5 D1              
694 694 Bachelor 09 09_ERICA_R     ED                 D5 D2              
697 697 Bachelor 09 09_ELLEN_D   E                   D5                
821 821 Bachelor 04 04_Estella             W         D5 D5 D1 D1 D1 D1      
826 826 Bachelor 04 04_Misty     E                 D5 D3              
830 830 Bachelor 04 04_Lindsay_clippers   ED                   D5                
833 833 Bachelor 04 04_Jenn   E                   D5                
834 834 Bachelor 04 04_Christine   E                   D5                
846 846 Bachelor 03 03_JEN_X             W         D5 D5 D1 D1 D1 D1      
847 847 Bachelor 03 03_KIRSTEN_X             E         D5 D1 D1 D1 D1 D1      
848 848 Bachelor 03 03_TINA_X           E           D5 D5 D3 D1 D1        
849 849 Bachelor 03 03_CRISTINA_X         E             D5 D3 D3 D1          
850 850 Bachelor 03 03_LIZ_X       E               D5 D3 D3            
851 851 Bachelor 03 03_ANN_MICHELLE_X       E               D5 D3 D1            
852 852 Bachelor 03 03_AUDREE_X     E                 D5 D5              
853 853 Bachelor 03 03_AMBER_X     E                 D5 D1              
854 854 Bachelor 03 03_HEATHER_X     E                 D5 D5              
855 855 Bachelor 03 03_TINA_X     E                 D5 D5              
856 856 Bachelor 03 03_RACHEL_X   E                   D5                
857 857 Bachelor 03 03_AMY_X   E                   D5                
858 858 Bachelor 03 03_SHANNON_X   E                   D5                
859 859 Bachelor 03 03_ELIZABETH_X   E                   D5                
860 860 Bachelor 03 03_CHRISTINA_X   EQ                   D5                
862 862 Bachelor 03 03_AMY_X E                     D5                
872 872 Bachelor 02 02_HELENE_E             W         D5 D1 D1 D1 D1 D1      
873 873 Bachelor 02 02_BROOKE_S             E         D5 D1 D3 D1 D1        
874 874 Bachelor 02 02_GWEN_G           E           D5 D3 D1 D1 D1        
875 875 Bachelor 02 02_ANGELA_X         E             D5 D5 D3 D1          
876 876 Bachelor 02 02_HAYLEY_X       E               D5 D3 D3            
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              
880 880 Bachelor 02 02_KYLA_X     E                 D5 D3              
881 881 Bachelor 02 02_SHANNON_X     E                 D5 D5              
882 882 Bachelor 02 02_DANA_X   E                   D5                
883 883 Bachelor 02 02_ERIN_X   E                   D5                
884 884 Bachelor 02 02_SUZANNE_X   E                   D5                
885 885 Bachelor 02 02_FRANCES_X   EQ                   D5                
886 886 Bachelor 02 02_ANINDITA_X   EQ                   D5                
897 897 Bachelor 01 01_AMANDA_M           W           D5 D1 D1 D1 D1        
898 898 Bachelor 01 01_TRISTA_R           E           D5 D1 D1 D1 D1        
899 899 Bachelor 01 01_SHANNON_O         E             D5 D1 D1 D1          
900 900 Bachelor 01 01_KIM_X       E               D5 D4 D1            
901 901 Bachelor 01 01_CATHY_G     E                 D5 D4              
902 902 Bachelor 01 01_CHRISTINA_X     E                 D5 D4              
903 903 Bachelor 01 01_LANEASE_A     E                 D5 D4              
904 904 Bachelor 01 01_RHONDA_X     E                 D5 D4              
905 905 Bachelor 01 01_ALEXA_X   E                   D5                
906 906 Bachelor 01 01_AMY_X   E                   D5                
907 907 Bachelor 01 01_ANGELA_X   E                   D5                
908 908 Bachelor 01 01_ANGELIQUE_X   E                   D5                
909 909 Bachelor 01 01_KATIE_X   E                   D5                
910 910 Bachelor 01 01_MELISSA_X   E                   D5                
911 911 Bachelor 01 01_TINA_X   E                   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
);