home / fivethirtyeight

Menu
  • GraphQL API

Bachelorette / Bachelor: bachelorette.csv

Table actions
  • GraphQL API for bachelorette/bachelorette

This table contains the data behind the stories:

  • How To Spot A Front-Runner On The ‘Bachelor’ Or ‘Bachelorette’
  • Rachel’s Season Is Fitting Neatly Into ‘Bachelorette’ History
  • Rachel Lindsay’s ‘Bachelorette’ Season, In Three Charts

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

921 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, 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 3 ✖

  • 10 33
  • D1 29
  • 2 1
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
921 921 Bachelor 01 01_WENDI_X E                                      
920 920 Bachelor 01 01_RACHEL_X E                                      
919 919 Bachelor 01 01_PAULA_X E                                      
918 918 Bachelor 01 01_LISA_X E                                      
917 917 Bachelor 01 01_KRISTINA_X E                                      
916 916 Bachelor 01 01_JILL_X E                                      
915 915 Bachelor 01 01_JACKIE_X E                                      
914 914 Bachelor 01 01_DENISE_X E                                      
913 913 Bachelor 01 01_DANIELA_X E                                      
912 912 Bachelor 01 01_AMBER_X E                                      
911 911 Bachelor 01 01_TINA_X   E                   D5                
910 910 Bachelor 01 01_MELISSA_X   E                   D5                
909 909 Bachelor 01 01_KATIE_X   E                   D5                
908 908 Bachelor 01 01_ANGELIQUE_X   E                   D5                
907 907 Bachelor 01 01_ANGELA_X   E                   D5                
906 906 Bachelor 01 01_AMY_X   E                   D5                
905 905 Bachelor 01 01_ALEXA_X   E                   D5                
904 904 Bachelor 01 01_RHONDA_X     E                 D5 D4              
903 903 Bachelor 01 01_LANEASE_A     E                 D5 D4              
902 902 Bachelor 01 01_CHRISTINA_X     E                 D5 D4              
901 901 Bachelor 01 01_CATHY_G     E                 D5 D4              
900 900 Bachelor 01 01_KIM_X       E               D5 D4 D1            
899 899 Bachelor 01 01_SHANNON_O         E             D5 D1 D1 D1          
898 898 Bachelor 01 01_TRISTA_R           E           D5 D1 D1 D1 D1        
897 897 Bachelor 01 01_AMANDA_M           W           D5 D1 D1 D1 D1        
896 896 Bachelor SEASON ID 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10
895 895 Bachelor 02 02_MERILEE_X E                                      
894 894 Bachelor 02 02_LORI_X E                                      
893 893 Bachelor 02 02_LIANGY_X E                                      
892 892 Bachelor 02 02_FATIMA_X E                                      
891 891 Bachelor 02 02_ERIN_X E                                      
890 890 Bachelor 02 02_CHRISTY_X E                                      
889 889 Bachelor 02 02_CARI_X E                                      
888 888 Bachelor 02 02_CAMILLE_X E                                      
887 887 Bachelor 02 02_AMBER_X E                                      
886 886 Bachelor 02 02_ANINDITA_X   EQ                   D5                
885 885 Bachelor 02 02_FRANCES_X   EQ                   D5                
884 884 Bachelor 02 02_SUZANNE_X   E                   D5                
883 883 Bachelor 02 02_ERIN_X   E                   D5                
882 882 Bachelor 02 02_DANA_X   E                   D5                
881 881 Bachelor 02 02_SHANNON_X     E                 D5 D5              
880 880 Bachelor 02 02_KYLA_X     E                 D5 D3              
879 879 Bachelor 02 02_HEATHER_X     E                 D5 D5              
878 878 Bachelor 02 02_CHRISTI_X     E                 D5 D5              
877 877 Bachelor 02 02_HEATHER_C       E               D5 D5 D1            
876 876 Bachelor 02 02_HAYLEY_X       E               D5 D3 D3            
875 875 Bachelor 02 02_ANGELA_X         E             D5 D5 D3 D1          
874 874 Bachelor 02 02_GWEN_G           E           D5 D3 D1 D1 D1        
873 873 Bachelor 02 02_BROOKE_S             E         D5 D1 D3 D1 D1        
872 872 Bachelor 02 02_HELENE_E             W         D5 D1 D1 D1 D1 D1      
871 871 Bachelor SEASON ID 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10
870 870 Bachelor 03 03_KRISTEN_X E                                      
869 869 Bachelor 03 03_TIFFANY_X E                                      
868 868 Bachelor 03 03_STEPHANIE_X E                                      
867 867 Bachelor 03 03_BROOKE_X E                                      
866 866 Bachelor 03 03_GINNY_X E                                      
865 865 Bachelor 03 03_ANGELA_X E                                      
864 864 Bachelor 03 03_COURTNEY_X E                                      
863 863 Bachelor 03 03_JENNIFER_X E                                      
862 862 Bachelor 03 03_AMY_X E                     D5                
861 861 Bachelor 03 03_KERRI_X E                                      
860 860 Bachelor 03 03_CHRISTINA_X   EQ                   D5                
859 859 Bachelor 03 03_ELIZABETH_X   E                   D5                
858 858 Bachelor 03 03_SHANNON_X   E                   D5                
857 857 Bachelor 03 03_AMY_X   E                   D5                
856 856 Bachelor 03 03_RACHEL_X   E                   D5                
855 855 Bachelor 03 03_TINA_X     E                 D5 D5              
854 854 Bachelor 03 03_HEATHER_X     E                 D5 D5              
853 853 Bachelor 03 03_AMBER_X     E                 D5 D1              
852 852 Bachelor 03 03_AUDREE_X     E                 D5 D5              
851 851 Bachelor 03 03_ANN_MICHELLE_X       E               D5 D3 D1            
850 850 Bachelor 03 03_LIZ_X       E               D5 D3 D3            
849 849 Bachelor 03 03_CRISTINA_X         E             D5 D3 D3 D1          
848 848 Bachelor 03 03_TINA_X           E           D5 D5 D3 D1 D1        
847 847 Bachelor 03 03_KIRSTEN_X             E         D5 D1 D1 D1 D1 D1      
846 846 Bachelor 03 03_JEN_X             W         D5 D5 D1 D1 D1 D1      
845 845 Bachelor SEASON ID 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 1 2
844 844 Bachelor 04 04_Shelly E                                      
843 843 Bachelor 04 04_Julie E                                      
842 842 Bachelor 04 04_Leona E                                      
841 841 Bachelor 04 04_Samentha E                                      
840 840 Bachelor 04 04_Kristi E                                      
839 839 Bachelor 04 04_Lauren E                                      
838 838 Bachelor 04 04_Heather E                                      
837 837 Bachelor 04 04_Shea E                                      
836 836 Bachelor 04 04_Stacey E                                      
835 835 Bachelor 04 04_Darla E                                      
834 834 Bachelor 04 04_Christine   E                   D5                
833 833 Bachelor 04 04_Jenn   E                   D5                
832 832 Bachelor 04 04_Lanah   E                   D6                
831 831 Bachelor 04 04_Lindsay   E                   D6                
830 830 Bachelor 04 04_Lindsay_clippers   ED                   D5                
829 829 Bachelor 04 04_Antoinette     E                 D6 D5              
828 828 Bachelor 04 04_Jenny     E                 D6 D5              
827 827 Bachelor 04 04_Karin     E                 D4 D5              
826 826 Bachelor 04 04_Misty     E                 D5 D3              
825 825 Bachelor 04 04_Lee-Ann       E               D6 D1 D3            
824 824 Bachelor 04 04_Brooke       E               D4 D5 D3            
823 823 Bachelor 04 04_Meredith         E             D4 D1 D3 D1          
822 822 Bachelor 04 04_Mary           E           D6 D3 D1 D1 D1        

Next page

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
);
Powered by Datasette · Queries took 579.488ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette