fivethirtyeight: bachelorette/bachelorette: 15 rows where ELIMINATION-4 = "ED"

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

15 rows where ELIMINATION-4 = "ED"

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	DATES-2	DATES-3	DATES-4
16	16	Bachelorette	13	13_JACK_S				ED	D8	D8	D1
47	47	Bachelorette	12	12_CHAD_J				ED	D6	D12	D2
126	126	Bachelorette	09	09_BRAD_M				ED		D10	D1
152	152	Bachelorette	08	08_NATHAN_B				ED	D13		D2
230	230	Bachelorette	05	05_MIKE_S		R		ED	D7	D11	D2
256	256	Bachelorette	04	04_FREDERICK_G			R	ED	D7	D10	D2
257	257	Bachelorette	04	04_ROBERT_F			R	ED	D7	D10	D2
397	397	Bachelor	20	20_HAYLEY_F				ED	D6	D12	D12
427	427	Bachelor	19	19_JILIAN_A				ED	D11	D12	D6
484	484	Bachelor	17	17_LESLIE_H	R1			ED		D12	D1
563	563	Bachelor	14	14_KATHRYN_S				ED	D5	D8	D2
564	564	Bachelor	14	14_ELLA_N			R	ED		D1	D2
590	590	Bachelor	13	13_NIKKI_K	R1			ED	D8	D8	D2
616	616	Bachelor	12	12_HOLLY_D			R	ED	D8	D1	D2
641	641	Bachelor	11	11_JADE_B				ED	D7	D5	D2

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

15 rows where ELIMINATION-4 = "ED"

Advanced export