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

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

✎ 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-9	ELIMINATION-10	DATES-3	DATES-4	DATES-5	DATES-6	DATES-7	DATES-8	DATES-9	DATES-10
247	247	Bachelorette	05	05_STEPHEN_R	E
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
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
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
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
355	355	Bachelor	21	21_RACHEL_L			R		R			E		D7	D13	D1	D6	D1	D1	D1
360	360	Bachelor	21	21_WHITNEY_F						ED				D7	D13	D10	D2
370	370	Bachelor	21	21_DOMINIQUE_A			ED							D7
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
384	384	Bachelor	20	20_LAUREN_B			R	R					W	D1	D12	D9	D7	D1	D1	D1	D1
392	392	Bachelor	20	20_LEAH_B						EU				D12	D12	D9	D7
396	396	Bachelor	20	20_RACHEL_T				E						D12	D12
398	398	Bachelor	20	20_JAMI_L			E							D12
405	405	Bachelor	20	20_LAURA_E	E
406	406	Bachelor	20	20_IZZY_G	E
407	407	Bachelor	20	20_MAEGAN_M	E
408	408	Bachelor	20	20_JESSICA_M	E
409	409	Bachelor	20	20_BREANNE_R	E
410	410	Bachelor	20	20_LAUREN_R	E
411	411	Bachelor	20	20_TIARA_S	E
413	413	Bachelor	19	19_WHITNEY_B			R		R				W	D1	D6	D9	D6	D1	D1	D1	D1
417	417	Bachelor	19	19_CARLY_W					R		E			D12	D6	D1	D6	D3
423	423	Bachelor	19	19_SAMANTHA_S					E					D12	D8	D9
426	426	Bachelor	19	19_NIKKI_D				E						D12	D6
432	432	Bachelor	19	19_JORDAN_B		E
436	436	Bachelor	19	19_AMANDA_G	E
437	437	Bachelor	19	19_BO_S	E
438	438	Bachelor	19	19_BRITTANY_F	E
439	439	Bachelor	19	19_KARA_W	E
440	440	Bachelor	19	19_MICHELLE_D	E
441	441	Bachelor	19	19_NICOLE_M	E
442	442	Bachelor	19	19_REEGAN_C	E
449	449	Bachelor	18	18_SHARLEEN_J	R1			R		R	EQ			D10	D1	D9	D6	D1
453	453	Bachelor	18	18_DANIELLE_R					E					D10	D6	D9
459	459	Bachelor	18	18_AMY_L		E
462	462	Bachelor	18	18_ALEXIS_M	E
463	463	Bachelor	18	18_AMY_J	E
464	464	Bachelor	18	18_ASHLEY_P	E
465	465	Bachelor	18	18_CHRISTINE_L	E
466	466	Bachelor	18	18_KYLIE_L	E
467	467	Bachelor	18	18_LACY_F	E
468	468	Bachelor	18	18_LAUREN_H	E
469	469	Bachelor	18	18_MAGGIE_G	E
470	470	Bachelor	18	18_VALERIE_E	E
473	473	Bachelor	17	17_LINDSAY_Y			R		R		R		E	D12	D8	D1	D7	D3	D1	D1	D1
474	474	Bachelor	17	17_ASHLEE_F	R1		R					E		D1	D8	D8	D7	D1	D1	D1
482	482	Bachelor	17	17_JACKIE_[	R1				ED					D12	D8	D2
484	484	Bachelor	17	17_LESLIE_H	R1			ED						D12	D1
491	491	Bachelor	17	17_ASHLEY_H	E
492	492	Bachelor	17	17_ASHLEY_P	E
493	493	Bachelor	17	17_KELLY_D	E
494	494	Bachelor	17	17_KERIANN_M	E
495	495	Bachelor	17	17_LACEY_L	E
496	496	Bachelor	17	17_LAUREN_M	E
497	497	Bachelor	17	17_PAIGE_V	E
500	500	Bachelor	16	16_LINDZI_C	R1		R			R			E	D1	D8	D9	D6	D1	D1	D1	D1
506	506	Bachelor	16	16_CASEY_S						EF				D11	D8	D9	D6

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

Advanced export