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

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

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid	SHOW	SEASON	CONTESTANT	ELIMINATION-1	ELIMINATION-2	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
136	136	Bachelorette	09	09_MIKE_X	E
137	137	Bachelorette	09	09_NICK_R	E
138	138	Bachelorette	09	09_JONATHAN_V	EU
140	140	Bachelorette	08	08_JEF_H		R	R	R					W	D13	D12	D8	D1	D6	D1	D1	D1	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
148	148	Bachelorette	08	08_ALEJANDRO_V				E						D13	D12		D8
149	149	Bachelorette	08	08_KALON_M				ED						D13		D8	D8
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
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
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
177	177	Bachelorette	07	07_WEST_L			E							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
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
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
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
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
227	227	Bachelorette	05	05_MARK_H			R	E						D7	D11	D2	D8
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
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
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
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
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

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

Advanced export