fivethirtyeight: bachelorette/bachelorette: 921 rows where sorted by SEASON

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 SEASON

descending

✎ 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	DATES-2	DATES-3	DATES-4	DATES-5	DATES-6	DATES-7
327	327	Bachelorette	01	01_RYAN_S						W			D14	D1	D1	D1	D1
328	328	Bachelorette	01	01_CHARLIE_M						E			D14	D1	D1	D1	D1
329	329	Bachelorette	01	01_RUSS_X					E				D14	D1	D1	D1
330	330	Bachelorette	01	01_GREG_T				E					D14	D5	D1
331	331	Bachelorette	01	01_BOB_G			E						D14	D5
332	332	Bachelorette	01	01_JAMIE_B			E						D14	D5
333	333	Bachelorette	01	01_MIKE_X			E						D14	D5
334	334	Bachelorette	01	01_ROB_X			E						D14	D5
335	335	Bachelorette	01	01_BRIAN_C		E							D14
336	336	Bachelorette	01	01_BRIAN_S		E							D14
337	337	Bachelorette	01	01_BROOK_X		E							D14
338	338	Bachelorette	01	01_JACK_X		E							D14
339	339	Bachelorette	01	01_JEFF_X		E							D14
340	340	Bachelorette	01	01_JOSH_X		E							D14
341	341	Bachelorette	01	01_BRIAN_H		EQ							D14
342	342	Bachelorette	01	01_BILLY_X	E
343	343	Bachelorette	01	01_BRIAN_K	E
344	344	Bachelorette	01	01_CHRIS_X	E
345	345	Bachelorette	01	01_DUANE_X	E
346	346	Bachelorette	01	01_ERIC_X	E
347	347	Bachelorette	01	01_GREGG_H	E
348	348	Bachelorette	01	01_MATT_X	E
349	349	Bachelorette	01	01_PAUL_X	E
350	350	Bachelorette	01	01_PETER_X	E
351	351	Bachelorette	01	01_WAYNE_X	E
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
912	912	Bachelor	01	01_AMBER_X	E
913	913	Bachelor	01	01_DANIELA_X	E
914	914	Bachelor	01	01_DENISE_X	E
915	915	Bachelor	01	01_JACKIE_X	E
916	916	Bachelor	01	01_JILL_X	E
917	917	Bachelor	01	01_KRISTINA_X	E
918	918	Bachelor	01	01_LISA_X	E
919	919	Bachelor	01	01_PAULA_X	E
920	920	Bachelor	01	01_RACHEL_X	E
921	921	Bachelor	01	01_WENDI_X	E
301	301	Bachelorette	02	02_IAN_M							W		D7	D1	D4	D1	D1	D1
302	302	Bachelorette	02	02_MATTHEW_H							E		D7	D7	D1	D1	D1	D1
303	303	Bachelorette	02	02_CHAD_X						E			D7	D7	D1	D1	D1
304	304	Bachelorette	02	02_LANNY_X					E				D7	D7	D1	D1
305	305	Bachelorette	02	02_BRAD_X				E					D7	D7	D4
306	306	Bachelorette	02	02_RYAN_M				E					D7	D2	D4
307	307	Bachelorette	02	02_SEAN_X				E					D7	D7	D4
308	308	Bachelorette	02	02_RICK_X			E						D1	D7
309	309	Bachelorette	02	02_RYAN_R			E						D7	D7
310	310	Bachelorette	02	02_TODD_X			E						D7	D2
311	311	Bachelorette	02	02_DAMON_X		E							D7
312	312	Bachelorette	02	02_ELIOT_X		E							D7
313	313	Bachelorette	02	02_HAROLD_H		E							D7
314	314	Bachelorette	02	02_MARCUS_X		E							D7
315	315	Bachelorette	02	02_ROBERT_X		E							D7
316	316	Bachelorette	02	02_AARON_X	E
317	317	Bachelorette	02	02_ANDY_C	E
318	318	Bachelorette	02	02_ANSELM_C	E
319	319	Bachelorette	02	02_BRIAN_X	E
320	320	Bachelorette	02	02_CHRIS_X	E
321	321	Bachelorette	02	02_CORY_H	E
322	322	Bachelorette	02	02_JEFF_O	E
323	323	Bachelorette	02	02_JUSTIN_X	E
324	324	Bachelorette	02	02_KEITH_X	E
325	325	Bachelorette	02	02_TREVER_X	E
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
887	887	Bachelor	02	02_AMBER_X	E
888	888	Bachelor	02	02_CAMILLE_X	E
889	889	Bachelor	02	02_CARI_X	E
890	890	Bachelor	02	02_CHRISTY_X	E
891	891	Bachelor	02	02_ERIN_X	E
892	892	Bachelor	02	02_FATIMA_X	E
893	893	Bachelor	02	02_LIANGY_X	E
894	894	Bachelor	02	02_LORI_X	E
895	895	Bachelor	02	02_MERILEE_X	E
275	275	Bachelorette	03	03_JERRY_F								W	D7	D6	D1	D1	D1	D1

Advanced export

JSON shape: default, array, newline-delimited

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

Bachelorette / Bachelor: bachelorette.csv

921 rows sorted by SEASON

Advanced export