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

51 rows where ELIMINATION-5 = "E"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: SHOW, SEASON, ELIMINATION-1, DATES-2, 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
11 11 Bachelorette 13 13_ANTHONY_B     R   E               D1 D13 D9          
12 12 Bachelorette 13 13_JOSIAH_G   R     E             D10   D13 D9          
42 42 Bachelorette 12 12_VINCENT_V         E             D10 D12 D11 D9          
43 43 Bachelorette 12 12_GRANT_K         E             D10 D12 D11 D9          
44 44 Bachelorette 12 12_EVAN_B     R   E             D10 D12 D11 D9          
70 70 Bachelorette 11 11_JOSHUA_A         E             D7 D6 D5 D9          
71 71 Bachelorette 11 11_JUSTIN_R       R E             D8   D8 D9          
96 96 Bachelorette 10 10_ANDREW_P         E               D12 D6 D9          
97 97 Bachelorette 10 10_MARQUEL_M         E             D14 D12 D6 D9          
98 98 Bachelorette 10 10_PATRICK_J         E             D14 D12   D9          
122 122 Bachelorette 09 09_MIKEY_T         E             D14 D10 D10 D7          
148 148 Bachelorette 08 08_ALEJANDRO_V         E             D13 D12   D8          
174 174 Bachelorette 07 07_NICK_P         E             D6 D10 D10 D8          
199 199 Bachelorette 06 06_CHRIS_N         E             D12 D9   D6          
227 227 Bachelorette 05 05_MARK_H       R E             D7 D11 D2 D8          
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          
278 278 Bachelorette 03 03_WENDELL_J         E             D7 D6 D4 D1          
304 304 Bachelorette 02 02_LANNY_X         E             D7 D7 D1 D1          
329 329 Bachelorette 01 01_RUSS_X         E             D14 D1 D1 D1          
362 362 Bachelor 21 21_JAIMI_K         E             D6 D7 D13 D10          
363 363 Bachelor 21 21_JOSEPHINE_T         E             D6   D13 D10          
364 364 Bachelor 21 21_ALEXIS_W         E             D12 D7 D13 D10          
393 393 Bachelor 20 20_JENNIFER_S         E             D10 D12 D12 D9          
422 422 Bachelor 19 19_MACKENZIE_D   R     E             D6 D12 D8 D9          
423 423 Bachelor 19 19_SAMANTHA_S         E               D12 D8 D9          
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          
481 481 Bachelor 17 17_ROBYN_H R1       E             D13 D12 D8 D8          
508 508 Bachelor 16 16_JENNIFER_F       R E             D12   D1 D9          
533 533 Bachelor 15 15_LISA_M         E             D15 D12 D9 D8          
534 534 Bachelor 15 15_MARISSA_M         E             D15 D12   D8          
560 560 Bachelor 14 14_CORRIE_A         E             D6 D8 D6 D1          
586 586 Bachelor 13 13_STEPHANIE_H     R R E               D1 D2 D3          
612 612 Bachelor 12 12_MARSHANA_R       R E             D8 D10 D2 D4          
613 613 Bachelor 12 12_ROBIN_C     R   E             D7 D10 D6 D4          
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          
664 664 Bachelor 10 10_STEPHANIE_W         E             D7 D5 D4 D1          
665 665 Bachelor 10 10_TINA_W         E             D7 D5 D4 D4          
689 689 Bachelor 09 09_AGNESE_P     R   E             D5 D2 D4 D1          
717 717 Bachelor 08 08_Sarah_B     R   E             D6, D12 D2 D4 D1          
743 743 Bachelor 07 07_Kimberly R R R   E           D6 D10 D1 D5 D1          
770 770 Bachelor 06 06_Andrea         E               D1              
771 771 Bachelor 06 06_Jayne         E             D1     D1          
797 797 Bachelor 05 05_TRISH_S R1       E             D1 D2 D3 D1          
823 823 Bachelor 04 04_Meredith         E             D4 D1 D3 D1          
849 849 Bachelor 03 03_CRISTINA_X         E             D5 D3 D3 D1          
875 875 Bachelor 02 02_ANGELA_X         E             D5 D5 D3 D1          
899 899 Bachelor 01 01_SHANNON_O         E             D5 D1 D1 D1          

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