fivethirtyeight: bachelorette/bachelorette: 921 rows where sorted by DATES-3

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-3

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid	SHOW	SEASON	CONTESTANT	ELIMINATION-1	ELIMINATION-2	ELIMINATION-4	ELIMINATION-5	ELIMINATION-6	ELIMINATION-7	ELIMINATION-9	ELIMINATION-10	DATES-2	DATES-4	DATES-5	DATES-6	DATES-7	DATES-8	DATES-9	DATES-10
224	224	Bachelorette	05	05_JAKE_P		R			E				D1	D10	D8	D6
228	228	Bachelorette	05	05_DAVID_G	R1		E						D7	D10
234	234	Bachelorette	05	05_BRIAN_D		E							D8
235	235	Bachelorette	05	05_JULIEN_H		E
236	236	Bachelorette	05	05_MATHUE_J		E							D8
237	237	Bachelorette	05	05_SIMON_A		E							D7
238	238	Bachelorette	05	05_ADAM_D	E
239	239	Bachelorette	05	05_BRIAN_V	E
240	240	Bachelorette	05	05_BRYCE_H	E
241	241	Bachelorette	05	05_CALEB_K	E
242	242	Bachelorette	05	05_GREG_B	E
243	243	Bachelorette	05	05_JOHN_H	E
244	244	Bachelorette	05	05_JOHN_P	E
245	245	Bachelorette	05	05_JOSH_Y	E
246	246	Bachelorette	05	05_KYLE_Y	E
247	247	Bachelorette	05	05_STEPHEN_R	E
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
264	264	Bachelorette	04	04_BRIAN_W	E
265	265	Bachelorette	04	04_CHANDLER_F	E
266	266	Bachelorette	04	04_DONATO_C	E
267	267	Bachelorette	04	04_GREGORY_M	E
268	268	Bachelorette	04	04_JEFFREY_H	E
269	269	Bachelorette	04	04_JONATHAN_K	E
270	270	Bachelorette	04	04_LUKE_H	E
271	271	Bachelorette	04	04_PATRICK_C	E
272	272	Bachelorette	04	04_PATRICK_D	E
273	273	Bachelorette	04	04_SPERO_S	E
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
290	290	Bachelorette	03	03_ANDREW	E
291	291	Bachelorette	03	03_ANDY_L	E
292	292	Bachelorette	03	03_CHRIS_M	E
293	293	Bachelorette	03	03_CHRIS_C	E
294	294	Bachelorette	03	03_COLLIN_E	E
295	295	Bachelorette	03	03_DAVID_V	E
296	296	Bachelorette	03	03_ERIC_H	E
297	297	Bachelorette	03	03_ERIC_T	E
298	298	Bachelorette	03	03_KEVIN	E
299	299	Bachelorette	03	03_MATT_L	E
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
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
354	354	Bachelor	21	21_RAVEN_G			R		R	R		E	D12	D1	D10	D6	D3	D1	D1	D1
358	358	Bachelor	21	21_DANIELLE_M		R				ED			D1	D13	D10	D6	D1
363	363	Bachelor	21	21_JOSEPHINE_T				E					D6	D13	D10
371	371	Bachelor	21	21_LACEY_M		E							D12
372	372	Bachelor	21	21_HAILEY_M		E							D12
373	373	Bachelor	21	21_ELIZABETH_W		E							D12
374	374	Bachelor	21	21_LIZ_S		ED							D6
375	375	Bachelor	21	21_ANGELA_A	E
376	376	Bachelor	21	21_JASMINE_B	E
377	377	Bachelor	21	21_OLIVIA_B	E
378	378	Bachelor	21	21_IDA_D	E
379	379	Bachelor	21	21_BRIANA_G	E
380	380	Bachelor	21	21_LAUREN_H	E
381	381	Bachelor	21	21_SUSANNAH_M	E
382	382	Bachelor	21	21_MICHELLE_R	E
385	385	Bachelor	20	20_JOJO_F		R	R					E	D10	D1	D9	D7	D1	D1	D1	D1
386	386	Bachelor	20	20_CAILA_Q		R			R		EU		D1	D12	D9	D1	D3	D1	D1
388	388	Bachelor	20	20_BECCA_T			R			E			D10	D1	D9	D7	D3
401	401	Bachelor	20	20_JACKIE_D		E							D10
402	402	Bachelor	20	20_MANDI_K		E							D10
403	403	Bachelor	20	20_SAMANTHA_P		E							D6
404	404	Bachelor	20	20_LB_B		EQ							D10

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-3

Advanced export