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

921 rows sorted by CONTESTANT

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
853 853 Bachelor 03 03_AMBER_X     E                 D5 D1              
857 857 Bachelor 03 03_AMY_X   E                   D5                
862 862 Bachelor 03 03_AMY_X E                     D5                
290 290 Bachelorette 03 03_ANDREW E                                      
291 291 Bachelorette 03 03_ANDY_L E                                      
865 865 Bachelor 03 03_ANGELA_X E                                      
851 851 Bachelor 03 03_ANN_MICHELLE_X       E               D5 D3 D1            
852 852 Bachelor 03 03_AUDREE_X     E                 D5 D5              
280 280 Bachelorette 03 03_BEN_S       E               D7 D6 D4            
867 867 Bachelor 03 03_BROOKE_X E                                      
860 860 Bachelor 03 03_CHRISTINA_X   EQ                   D5                
293 293 Bachelorette 03 03_CHRIS_C E                                      
292 292 Bachelorette 03 03_CHRIS_M E                                      
294 294 Bachelorette 03 03_COLLIN_E E                                      
864 864 Bachelor 03 03_COURTNEY_X E                                      
849 849 Bachelor 03 03_CRISTINA_X         E             D5 D3 D3 D1          
295 295 Bachelorette 03 03_DAVID_V E                                      
859 859 Bachelor 03 03_ELIZABETH_X   E                   D5                
296 296 Bachelorette 03 03_ERIC_H E                                      
297 297 Bachelorette 03 03_ERIC_T E                                      
279 279 Bachelorette 03 03_FABRICE_L       EQ               D7 D1 D4            
866 866 Bachelor 03 03_GINNY_X E                                      
854 854 Bachelor 03 03_HEATHER_X     E                 D5 D5              
284 284 Bachelorette 03 03_JASON_I   E                   D7                
863 863 Bachelor 03 03_JENNIFER_X E                                      
846 846 Bachelor 03 03_JEN_X             W         D5 D5 D1 D1 D1 D1      
275 275 Bachelorette 03 03_JERRY_F               W       D7 D6 D1 D1 D1 D1      
276 276 Bachelorette 03 03_JOHN PAUL_M             E         D7 D1 D4 D1 D1 D1      
281 281 Bachelorette 03 03_JOSH_C     E                 D7 D6              
282 282 Bachelorette 03 03_KEITH R1   E                 D1 D6              
861 861 Bachelor 03 03_KERRI_X E                                      
298 298 Bachelorette 03 03_KEVIN E                                      
847 847 Bachelor 03 03_KIRSTEN_X             E         D5 D1 D1 D1 D1 D1      
870 870 Bachelor 03 03_KRISTEN_X E                                      
850 850 Bachelor 03 03_LIZ_X       E               D5 D3 D3            
285 285 Bachelorette 03 03_MARK   E                   D7                
299 299 Bachelorette 03 03_MATT_L E                                      
286 286 Bachelorette 03 03_MATT_M   E                   D7                
287 287 Bachelorette 03 03_MICHAEL_F   E                   D7                
856 856 Bachelor 03 03_RACHEL_X   E                   D5                
277 277 Bachelorette 03 03_RYAN_SH           E           D7 D6 D1 D1 D1        
288 288 Bachelorette 03 03_RYAN_SM   E                   D7                
858 858 Bachelor 03 03_SHANNON_X   E                   D5                
868 868 Bachelor 03 03_STEPHANIE_X E                                      
289 289 Bachelorette 03 03_STU_L   E                   D7                
869 869 Bachelor 03 03_TIFFANY_X E                                      
848 848 Bachelor 03 03_TINA_X           E           D5 D5 D3 D1 D1        
855 855 Bachelor 03 03_TINA_X     E                 D5 D5              
278 278 Bachelorette 03 03_WENDELL_J         E             D7 D6 D4 D1          
829 829 Bachelor 04 04_Antoinette     E                 D6 D5              
254 254 Bachelorette 04 04_BLAINE_T         E             D7 D10 D6 D4          
255 255 Bachelorette 04 04_BRIAN_T       E               D7 D10 D6            
264 264 Bachelorette 04 04_BRIAN_W E                                      
824 824 Bachelor 04 04_Brooke       E               D4 D5 D3            
265 265 Bachelorette 04 04_CHANDLER_F E                                      
261 261 Bachelorette 04 04_CHRISTOPHER_B   E                   D7                
834 834 Bachelor 04 04_Christine   E                   D5                
266 266 Bachelorette 04 04_DONATO_C E                                      
835 835 Bachelor 04 04_Darla E                                      
262 262 Bachelorette 04 04_ERIC_P   E                   D7                
821 821 Bachelor 04 04_Estella             W         D5 D5 D1 D1 D1 D1      
256 256 Bachelorette 04 04_FREDERICK_G     R ED               D7 D10 D2            
252 252 Bachelorette 04 04_GRAHAM_B   R       E           D1 D10 D6 D4 D1        
267 267 Bachelorette 04 04_GREGORY_M E                                      
838 838 Bachelor 04 04_Heather E                                      
250 250 Bachelorette 04 04_JASON_M     R         E       D7 D1 D6 D4 D1 D1 D1    
268 268 Bachelorette 04 04_JEFFREY_H E                                      
251 251 Bachelorette 04 04_JEREMY_A R1 R         E         D7 D10 D6 D1 D1 D1      
249 249 Bachelorette 04 04_JESSE_C R1     R       W       D7 D10 D1 D4 D1 D1 D1    
269 269 Bachelorette 04 04_JONATHAN_K E                                      
833 833 Bachelor 04 04_Jenn   E                   D5                
828 828 Bachelor 04 04_Jenny     E                 D6 D5              
843 843 Bachelor 04 04_Julie E                                      
827 827 Bachelor 04 04_Karin     E                 D4 D5              
820 820 Bachelor 04 04_Kelly-Jo             E         D4 D3 D1 D1 D1 D1      
840 840 Bachelor 04 04_Kristi E                                      
270 270 Bachelorette 04 04_LUKE_H E                                      
832 832 Bachelor 04 04_Lanah   E                   D6                
839 839 Bachelor 04 04_Lauren E                                      
825 825 Bachelor 04 04_Lee-Ann       E               D6 D1 D3            
842 842 Bachelor 04 04_Leona E                                      
831 831 Bachelor 04 04_Lindsay   E                   D6                
830 830 Bachelor 04 04_Lindsay_clippers   ED                   D5                
822 822 Bachelor 04 04_Mary           E           D6 D3 D1 D1 D1        
823 823 Bachelor 04 04_Meredith         E             D4 D1 D3 D1          
826 826 Bachelor 04 04_Misty     E                 D5 D3              
271 271 Bachelorette 04 04_PATRICK_C E                                      
272 272 Bachelorette 04 04_PATRICK_D E                                      
258 258 Bachelorette 04 04_PAUL_B   R E                 D7 D10              
260 260 Bachelorette 04 04_RICHARD_M R1   ED                 D7 D1              
257 257 Bachelorette 04 04_ROBERT_F     R ED               D7 D10 D2            
259 259 Bachelorette 04 04_RONALD_M     E                 D7 D10              
263 263 Bachelorette 04 04_RYAN_H   E                   D7                
253 253 Bachelorette 04 04_SEAN_R       R E             D7 D10 D6 D1          
273 273 Bachelorette 04 04_SPERO_S E                                      
841 841 Bachelor 04 04_Samentha E                                      
837 837 Bachelor 04 04_Shea E                                      
844 844 Bachelor 04 04_Shelly E                                      
836 836 Bachelor 04 04_Stacey E                                      
238 238 Bachelorette 05 05_ADAM_D E                                      

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