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

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

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid	SHOW	SEASON	CONTESTANT	ELIMINATION-1	ELIMINATION-2	ELIMINATION-3	DATES-2	DATES-3
204	204	Bachelorette	06	06_STEVE_K			E	D12
205	205	Bachelorette	06	06_HUNTER_W			ED	D12	D1
206	206	Bachelorette	06	06_CHRIS_H		E		D12
207	207	Bachelorette	06	06_CRAIG_M		E		D12
208	208	Bachelorette	06	06_TYLER_V		E		D12
209	209	Bachelorette	06	06_DEREK_X	E
210	210	Bachelorette	06	06_DERRICK_S	E
211	211	Bachelorette	06	06_JASON_W	E
212	212	Bachelorette	06	06_JAY_R	E
213	213	Bachelorette	06	06_JOHN_N	E
214	214	Bachelorette	06	06_KYLE_H	E
215	215	Bachelorette	06	06_PHIL_K	E
216	216	Bachelorette	06	06_TYLER_M	E
231	231	Bachelorette	05	05_BRAD_S			E	D8	D11
232	232	Bachelorette	05	05_TANNER_F			E		D11
233	233	Bachelorette	05	05_SASHA_P			ED	D8	D1
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
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
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
281	281	Bachelorette	03	03_JOSH_C			E	D7	D6
282	282	Bachelorette	03	03_KEITH	R1		E	D1	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
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
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
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

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

Advanced export