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

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

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-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
136	136	Bachelorette	09	09_MIKE_X	E
137	137	Bachelorette	09	09_NICK_R	E
138	138	Bachelorette	09	09_JONATHAN_V	EU
141	141	Bachelorette	08	08_ARIE_L			R						ED		D1	D8	D8	D6	D1	D1	D1
143	143	Bachelorette	08	08_CHRIS_B			R		R		E			D13	D1	D8	D8	D6	D3	D1
144	144	Bachelorette	08	08_JOHN_W				R		E				D13	D12	D2	D8	D6	D1
145	145	Bachelorette	08	08_DOUG_C	R1			R		ED					D12	D1	D8	D6	D3
146	146	Bachelorette	08	08_RYAN_B		R			ED					D1	D12	D8	D8	D1
147	147	Bachelorette	08	08_TRAVIS_P					ED						D12	D8	D8	D1
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
159	159	Bachelorette	08	08_BRENT_R	E
160	160	Bachelorette	08	08_DAVID_H	E
161	161	Bachelorette	08	08_JACKSON_L	E
162	162	Bachelorette	08	08_JEANPAUL_L	E
163	163	Bachelorette	08	08_LERONE_A	E
164	164	Bachelorette	08	08_RANDY_W	E
166	166	Bachelorette	07	07_JP_R			R		R	R			W		D1	D10	D8	D1	D3	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
171	171	Bachelorette	07	07_RYAN_P	R1		R		R	ED					D10	D10	D8	D6	D1
173	173	Bachelorette	07	07_RYAN_M		R			EQ					D1		D10	D8	D6
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
184	184	Bachelorette	07	07_ANTHONY_S	E
185	185	Bachelorette	07	07_CHRIS_M	E
186	186	Bachelorette	07	07_FRANK_C	E
187	187	Bachelorette	07	07_JON_E	E
188	188	Bachelorette	07	07_MICHAEL_B	E
189	189	Bachelorette	07	07_ROB_D	E
190	190	Bachelorette	07	07_TIM_M	EU
192	192	Bachelorette	06	06_ROBERT_M	R1		R						W		D1	D7	D6	D4	D1	D1	D1	D1
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
197	197	Bachelorette	06	06_CRAIG_R					E					D12	D9	D7	D6	D4
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
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
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
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
228	228	Bachelorette	05	05_DAVID_G	R1			E						D7		D10
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
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
249	249	Bachelorette	04	04_JESSE_C	R1			R			W			D7	D10	D1	D4	D1	D1	D1
250	250	Bachelorette	04	04_JASON_M			R				E			D7	D1	D6	D4	D1	D1	D1
251	251	Bachelorette	04	04_JEREMY_A	R1	R				E				D7	D10	D6	D1	D1	D1
252	252	Bachelorette	04	04_GRAHAM_B		R			E					D1	D10	D6	D4	D1
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

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

Advanced export