fivethirtyeight: bachelorette/bachelorette: 921 rows where sorted by DATES-2 descending

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 DATES-2 descending

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	ELIMINATION-10	DATES-2 ▲	DATES-3	DATES-4	DATES-5	DATES-6	DATES-7	DATES-8	DATES-9	DATES-10
5	5	Bachelorette	13	13_DEAN_U		R		R			R	E		D8	D8	D1	D9	D7	D1	D1
10	10	Bachelorette	13	13_KENNY_L					R	ED				D8	D8	D13	D2	D7
14	14	Bachelorette	13	13_IGGY_R				E						D8		D13
15	15	Bachelorette	13	13_JONATHAN_T				E						D8	D6	D13
16	16	Bachelorette	13	13_JACK_S				ED						D8	D8	D1
20	20	Bachelorette	13	13_FRED_J			ED							D8	D6
21	21	Bachelorette	13	13_BLAKE_E		E								D8
23	23	Bachelorette	13	13_LUCAS_Y		E								D8
63	63	Bachelorette	11	11_BEN_H			R		R			E		D8	D6	D5	D1	D5	D1	D1
64	64	Bachelorette	11	11_JARED_H				R		R	E			D8	D6	D1	D9	D5	D1	D1
67	67	Bachelorette	11	11_BEN_Z		R	R			E				D8	D1	D8	D9	D5
68	68	Bachelorette	11	11_TANNER_T						E				D8	D6	D8	D9	D5
71	71	Bachelorette	11	11_JUSTIN_R				R	E					D8		D8	D9
73	73	Bachelorette	11	11_COREY_S				E						D8		D8
79	79	Bachelorette	11	11_DANIEL_F		E								D8
80	80	Bachelorette	11	11_KUPAH_J		EU								D8
218	218	Bachelorette	05	05_ED_S			R						W	D8	D1	D10	D8		D1	D1	D1	D1
221	221	Bachelorette	05	05_WES_H		R						E		D8	D11	D10	D8	D6	D1	D1
223	223	Bachelorette	05	05_MICHAEL_S					R		E			D8	D11	D10	D1	D6	D1
225	225	Bachelorette	05	05_TANNER_P						E				D8	D11	D10	D8	D6
231	231	Bachelorette	05	05_BRAD_S			E							D8	D11
233	233	Bachelorette	05	05_SASHA_P			ED							D8	D1
234	234	Bachelorette	05	05_BRIAN_D		E								D8
236	236	Bachelorette	05	05_MATHUE_J		E								D8
583	583	Bachelor	13	13_MOLLY_M		R		R				E		D8		D1	D3	D1	D1	D1
585	585	Bachelor	13	13_NAOMI_C				R		E				D8	D8	D6	D1	D1
587	587	Bachelor	13	13_LAUREN_W				E						D8		D6
590	590	Bachelor	13	13_NIKKI_K	R1			ED						D8	D8	D2
591	591	Bachelor	13	13_ERICA_D			E							D8	D8
592	592	Bachelor	13	13_KARI_F			E							D8
593	593	Bachelor	13	13_NATALIE_G			ED							D8	D1
595	595	Bachelor	13	13_SHARON_S		E								D8
610	610	Bachelor	12	12_AMANDA_R	R1			R			E			D8	D10	D1	D4	D1	D1
611	611	Bachelor	12	12_NOELLE_D						E				D8	D10	D6	D1	D1
612	612	Bachelor	12	12_MARSHANA_R				R	E					D8	D10	D2	D4
614	614	Bachelor	12	12_ASHLEE_W		R		E						D8	D10	D6
616	616	Bachelor	12	12_HOLLY_D			R	ED						D8	D1	D2
619	619	Bachelor	12	12_KRISTINE_H			E							D8	D10
621	621	Bachelor	12	12_ERIN_H		E								D8
622	622	Bachelor	12	12_MICHELLE_P		E								D8
798	798	Bachelor	05	05_SUZIE_W				E						D8	D1	D3
800	800	Bachelor	05	05_JESSICA_H			E							D8	D6
802	802	Bachelor	05	05_JENNY_S			E							D8	D6
804	804	Bachelor	05	05_JEANMARIE_C		E								D8
805	805	Bachelor	05	05_ANNECATHERINE_L		E								D8
806	806	Bachelor	05	05_AMBER_L		E								D8
807	807	Bachelor	05	05_MANDY_C		E								D8
808	808	Bachelor	05	05_KRISTY_R		E								D8
65	65	Bachelorette	11	11_JOE_B						R	ED			D7	D6	D5		D2	D3
66	66	Bachelorette	11	11_CHRIS_S				R			ED			D7	D6	D5	D9	D5	D1
69	69	Bachelorette	11	11_JJ_L		R				ED				D7	D6	D8	D9	D2
70	70	Bachelorette	11	11_JOSHUA_A					E					D7	D6	D5	D9
72	72	Bachelorette	11	11_IAN_T					EQ					D7		D5	D9
74	74	Bachelorette	11	11_JONATHAN_H				E						D7	D6	D8
77	77	Bachelorette	11	11_TONY_H			EQ							D7	D6
219	219	Bachelorette	05	05_KIPTYN_L				R		R			E	D7	D11	D1	D8	D6	D1	D1	D1	D1
222	222	Bachelorette	05	05_JESSE_K				R	R		E			D7		D10	D1	D6	D1
227	227	Bachelorette	05	05_MARK_H				R	E					D7	D11	D2	D8
228	228	Bachelorette	05	05_DAVID_G	R1			E						D7		D10
229	229	Bachelorette	05	05_JUAN_B		R		E						D7	D11	D10
230	230	Bachelorette	05	05_MIKE_S		R		ED						D7	D11	D2
237	237	Bachelorette	05	05_SIMON_A		E								D7
249	249	Bachelorette	04	04_JESSE_C	R1			R				W		D7	D10	D1	D4	D1	D1	D1
250	250	Bachelorette	04	04_JASON_M			R					E		D7	D1	D6	D4	D1	D1	D1
251	251	Bachelorette	04	04_JEREMY_A	R1	R					E			D7	D10	D6	D1	D1	D1
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
255	255	Bachelorette	04	04_BRIAN_T				E						D7	D10	D6
256	256	Bachelorette	04	04_FREDERICK_G			R	ED						D7	D10	D2
257	257	Bachelorette	04	04_ROBERT_F			R	ED						D7	D10	D2
258	258	Bachelorette	04	04_PAUL_B		R	E							D7	D10
259	259	Bachelorette	04	04_RONALD_M			E							D7	D10
260	260	Bachelorette	04	04_RICHARD_M	R1		ED							D7	D1
261	261	Bachelorette	04	04_CHRISTOPHER_B		E								D7
262	262	Bachelorette	04	04_ERIC_P		E								D7
263	263	Bachelorette	04	04_RYAN_H		E								D7
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
277	277	Bachelorette	03	03_RYAN_SH						E				D7	D6	D1	D1	D1
278	278	Bachelorette	03	03_WENDELL_J					E					D7	D6	D4	D1
279	279	Bachelorette	03	03_FABRICE_L				EQ						D7	D1	D4
280	280	Bachelorette	03	03_BEN_S				E						D7	D6	D4
281	281	Bachelorette	03	03_JOSH_C			E							D7	D6
283	283	Bachelorette	03	03_A.W.		E								D7
284	284	Bachelorette	03	03_JASON_I		E								D7
285	285	Bachelorette	03	03_MARK		E								D7
286	286	Bachelorette	03	03_MATT_M		E								D7
287	287	Bachelorette	03	03_MICHAEL_F		E								D7
288	288	Bachelorette	03	03_RYAN_SM		E								D7
289	289	Bachelorette	03	03_STU_L		E								D7
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
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

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 DATES-2 descending

Advanced export