Baselight
Sign In

The Bachelor And Bachelorette Contestant Data

Contestants, Eliminations, and Dates Across Seasons of The Bachelor and The Bachelorette

@fivethirtyeight.bachelorette

Bachelor And Bachelorette Contestant Eliminations And Dates
@fivethirtyeight.bachelorette.bachelorette

Column Description
SHOW Indicates whether the season is The Bachelor or The Bachelorette
SEASON The season number
CONTESTANT An identifier for the contestant in the given season
ELIMINATION-1 Elimination status or rose in week 1
ELIMINATION-2 Elimination status or rose in week 2
ELIMINATION-3 Elimination status or rose in week 3
ELIMINATION-4 Elimination status or rose in week 4
ELIMINATION-5 Elimination status or rose in week 5
ELIMINATION-6 Elimination status or rose in week 6
ELIMINATION-7 Elimination status or rose in week 7
ELIMINATION-8 Elimination status or rose in week 8
ELIMINATION-9 Elimination status or rose in week 9
ELIMINATION-10 Elimination status or rose in week 10
DATES-1 Contestants on dates in week 1
DATES-2 Contestants on dates in week 2
DATES-3 Contestants on dates in week 3
DATES-4 Contestants on dates in week 4
DATES-5 Contestants on dates in week 5
DATES-6 Contestants on dates in week 6
DATES-7 Contestants on dates in week 7
DATES-8 Contestants on dates in week 8
DATES-9 Contestants on dates in week 9
DATES-10 Contestants on dates in week 10

Notes:

  • Eliminations denote either an elimination (starts with "E") or a rose (starts with "R").
  • Eliminations supersede roses.
  • "E" indicates a standard elimination at a rose ceremony. "EQ" means the contestant quit. "EF" means eliminated by production. "ED" means eliminated on a date. "EU" means an unscheduled elimination.
  • "R" indicates a rose was received. "R1" denotes a first impression rose.
  • Dates codes: "D1" means a one-on-one date, "D2" a two-on-one, "D3" a group date with three people, and so on.
  • Weeks are divided by rose ceremonies and may not align exactly with episodes.
  • 27.33 KB
  • 921 rows
  • 23 columns
show

SHOW

season

SEASON

contestant

CONTESTANT

elimination_1

ELIMINATION-1

elimination_2

ELIMINATION-2

elimination_3

ELIMINATION-3

elimination_4

ELIMINATION-4

elimination_5

ELIMINATION-5

elimination_6

ELIMINATION-6

elimination_7

ELIMINATION-7

elimination_8

ELIMINATION-8

elimination_9

ELIMINATION-9

elimination_10

ELIMINATION-10

dates_1

DATES-1

dates_2

DATES-2

dates_3

DATES-3

dates_4

DATES-4

dates_5

DATES-5

dates_6

DATES-6

dates_7

DATES-7

dates_8

DATES-8

dates_9

DATES-9

dates_10

DATES-10

SHOWSEASONID1234567891012345678910
Bachelorette1313_BRYAN_AR1RRRWD6D13D1D7D1D1D1D1
Bachelorette1313_PETER_KRRRED1D6D13D9D7D1D1D1D1
Bachelorette1313_ERIC_BRRRED10D8D13D9D1D3D1D1
Bachelorette1313_DEAN_URRRED8D8D1D9D7D1D1
Bachelorette1313_ADAM_GEDD10D8D13D9D7D3
Bachelorette1313_MATT_MEDD10D13D9D7D3
Bachelorette1313_ALEX_BRED10D6D13D9D7
Bachelorette1313_WILL_GREDD10D6D13D9D1
Bachelorette1313_KENNY_LREDD8D8D13D2D7

CREATE TABLE bachelorette (
  "show" VARCHAR,
  "season" VARCHAR,
  "contestant" VARCHAR,
  "elimination_1" VARCHAR,
  "elimination_2" VARCHAR,
  "elimination_3" VARCHAR,
  "elimination_4" VARCHAR,
  "elimination_5" VARCHAR,
  "elimination_6" VARCHAR,
  "elimination_7" VARCHAR,
  "elimination_8" VARCHAR,
  "elimination_9" VARCHAR,
  "elimination_10" VARCHAR,
  "dates_1" VARCHAR,
  "dates_2" VARCHAR,
  "dates_3" VARCHAR,
  "dates_4" VARCHAR,
  "dates_5" VARCHAR,
  "dates_6" VARCHAR,
  "dates_7" VARCHAR,
  "dates_8" VARCHAR,
  "dates_9" VARCHAR,
  "dates_10" VARCHAR
);

Share link

Anyone who has the link will be able to view this.