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

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

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	DATES-8
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	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

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 CONTESTANT

Advanced export