fivethirtyeight: bachelorette/bachelorette: 921 rows where sorted by ELIMINATION-1

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 ELIMINATION-1

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid	SHOW	SEASON	CONTESTANT	ELIMINATION-2	ELIMINATION-3	ELIMINATION-4	ELIMINATION-5	ELIMINATION-6	ELIMINATION-7	ELIMINATION-8	ELIMINATION-9	ELIMINATION-10	DATES-2	DATES-3	DATES-4	DATES-5	DATES-6	DATES-7	DATES-8	DATES-9	DATES-10
150	150	Bachelorette	08	08_CHARLIE_G			E							D13	D12	D8
151	151	Bachelorette	08	08_MICHAEL_N			E							D13	D12
152	152	Bachelorette	08	08_NATHAN_B			ED							D13		D2
153	153	Bachelorette	08	08_STEVIE_A		E								D13	D12
154	154	Bachelorette	08	08_ALESSANDRO_G		EU								D13	D12
155	155	Bachelorette	08	08_TONY_P		ED								D13	D12
156	156	Bachelorette	08	08_AARON_M	E									D13
157	157	Bachelorette	08	08_KYLE_D	E									D13
158	158	Bachelorette	08	08_JOE_G	ED									D1
166	166	Bachelorette	07	07_JP_R		R			R	R			W		D1	D10	D8	D1	D3	D1	D1	D1
167	167	Bachelorette	07	07_BEN_F			R	R					E	D6	D10	D10	D1	D6	D1	D1	D1	D1
168	168	Bachelorette	07	07_CONSTANTINE_T			R					EQ				D1	D8	D6	D1	D1	D1
169	169	Bachelorette	07	07_AMES_B			R				E				D10	D1	D8	D6	D3	D1
170	170	Bachelorette	07	07_LUCAS_D					R	E				D6	D10	D10	D8	D1	D3
172	172	Bachelorette	07	07_BLAKE_J				R	E					D6	D10	D10	D8	D6
173	173	Bachelorette	07	07_RYAN_M	R				EQ					D1		D10	D8	D6
174	174	Bachelorette	07	07_NICK_P				E						D6	D10	D10	D8
175	175	Bachelorette	07	07_WILLIAM_H	R			ED						D1	D10	D10	D2
176	176	Bachelorette	07	07_BEN_C		R		ED							D1	D10	D2
177	177	Bachelorette	07	07_WEST_L			E							D6		D10
178	178	Bachelorette	07	07_CHRIS_D		E									D10
179	179	Bachelorette	07	07_JEFF_M		E									D10
180	180	Bachelorette	07	07_BENTLEY_W	R	EQ								D6	D10
181	181	Bachelorette	07	07_MATT_C	E
182	182	Bachelorette	07	07_RYAN_M	E
183	183	Bachelorette	07	07_STEPHEN_D	E
193	193	Bachelorette	06	06_CHRIS_L			R						ED		D9	D1	D6	D4	D1	D1	D1	D1
194	194	Bachelorette	06	06_FRANK_N	R				R			EF		D1	D9	D7	D6	D1	D2	D1	D1
195	195	Bachelorette	06	06_KIRK_D		R		R			E			D12	D9	D7	D1	D4	D1	D1
196	196	Bachelorette	06	06_TY_B	R			R	R	E				D12		D7	D6	D1	D2
197	197	Bachelorette	06	06_CRAIG_R					E					D12	D9	D7	D6	D4
198	198	Bachelorette	06	06_JUSTIN_R				R	EF					D12	D9		D2
199	199	Bachelorette	06	06_CHRIS_N				E						D12	D9		D6
200	200	Bachelorette	06	06_KASEY_K				ED						D12		D1	D2
201	201	Bachelorette	06	06_JESSE_B	R		E							D1	D9	D7
202	202	Bachelorette	06	06_JONATHAN_N			E							D12	D9	D7
203	203	Bachelorette	06	06_JOHN_C		E									D9
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
218	218	Bachelorette	05	05_ED_S		R							W	D8	D1	D10	D8		D1	D1	D1	D1
219	219	Bachelorette	05	05_KIPTYN_L			R		R				E	D7	D11	D1	D8	D6	D1	D1	D1	D1
220	220	Bachelorette	05	05_REID_R					R			E			D11	D10	D8	D1	D1	D1	D1
221	221	Bachelorette	05	05_WES_H	R						E			D8	D11	D10	D8	D6	D1	D1
222	222	Bachelorette	05	05_JESSE_K			R	R		E				D7		D10	D1	D6	D1
223	223	Bachelorette	05	05_MICHAEL_S				R		E				D8	D11	D10	D1	D6	D1
224	224	Bachelorette	05	05_JAKE_P	R				E					D1		D10	D8	D6
225	225	Bachelorette	05	05_TANNER_P					E					D8	D11	D10	D8	D6
226	226	Bachelorette	05	05_ROBBY_D		R			ED						D11	D10	D8	D1
227	227	Bachelorette	05	05_MARK_H			R	E						D7	D11	D2	D8
229	229	Bachelorette	05	05_JUAN_B	R		E							D7	D11	D10
230	230	Bachelorette	05	05_MIKE_S	R		ED							D7	D11	D2
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
250	250	Bachelorette	04	04_JASON_M		R					E			D7	D1	D6	D4	D1	D1	D1
252	252	Bachelorette	04	04_GRAHAM_B	R				E					D1	D10	D6	D4	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
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
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

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 ELIMINATION-1

Advanced export