fivethirtyeight: bachelorette/bachelorette: 921 rows where sorted by rowid

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 rowid

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-8	ELIMINATION-9	ELIMINATION-10	DATES-1	DATES-2	DATES-3	DATES-4	DATES-5	DATES-6	DATES-7	DATES-8	DATES-9	DATES-10
101	101	Bachelorette	10	10_BRADLEY_W			E									D14	D12
102	102	Bachelorette	10	10_BRETT_M			E									D14	D12
103	103	Bachelorette	10	10_RON_W			EQ									D14	D12
104	104	Bachelorette	10	10_CARL_K		E										D14
105	105	Bachelorette	10	10_CRAIG_M		E										D14
106	106	Bachelorette	10	10_NICK_S		E										D14
107	107	Bachelorette	10	10_EMIL_S	E
108	108	Bachelorette	10	10_JASON_L	E
109	109	Bachelorette	10	10_JOSH_B	E
110	110	Bachelorette	10	10_MIKE_C	E
111	111	Bachelorette	10	10_RUDIE_D	E
112	112	Bachelorette	10	10_STEVEN_W	E
113	113	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
114	114	Bachelorette	09	09_CHRIS_S			R		R					W			D10	D10	D1	D6	D1	D1	D1	D1
115	115	Bachelorette	09	09_DREW_K	R1					R	R			ED		D14	D10	D10	D7	D1	D2	D1	D1	D1
116	116	Bachelorette	09	09_BROOKS_F		R			R				EQ			D1	D10	D10	D7	D6	D1	D1
117	117	Bachelorette	09	09_ZAK_W	R1			R		R		E				D14	D5	D10	D7	D1	D2	D1
118	118	Bachelorette	09	09_MICHAEL_G	R1				R		E					D14	D10	D10	D2	D6	D1
119	119	Bachelorette	09	09_JAMES_C			R	R		E						D14	D5	D1	D7	D6
120	120	Bachelorette	09	09_JUAN_G						E						D14	D5	D10	D7	D6
121	121	Bachelorette	09	09_KASEY_S			R			E						D14	D1	D10	D7	D6
122	122	Bachelorette	09	09_MIKEY_T					E							D14	D10	D10	D7
123	123	Bachelorette	09	09_BEN_S	R1	R			ED							D14	D10	D10	D2
124	124	Bachelorette	09	09_BRYDEN_V	R1	R			EQ							D1	D5	D10
125	125	Bachelorette	09	09_ZACK_K				E								D14	D10
126	126	Bachelorette	09	09_BRAD_M				ED									D10	D1
127	127	Bachelorette	09	09_BRANDON_A			E									D14	D10
128	128	Bachelorette	09	09_DAN_C			E									D14	D5
129	129	Bachelorette	09	09_BRIAN_J			EF									D14	D10
130	130	Bachelorette	09	09_NICK_M	R1	E										D14
131	131	Bachelorette	09	09_ROBERT_G		E
132	132	Bachelorette	09	09_WILL_R		E										D14
133	133	Bachelorette	09	09_DIOGO_C	E
134	134	Bachelorette	09	09_LARRY_B	E
135	135	Bachelorette	09	09_MICAH_X	E
136	136	Bachelorette	09	09_MIKE_X	E
137	137	Bachelorette	09	09_NICK_R	E
138	138	Bachelorette	09	09_JONATHAN_V	EU
139	139	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
140	140	Bachelorette	08	08_JEF_H		R		R	R					W		D13	D12	D8	D1	D6	D1	D1	D1	D1
141	141	Bachelorette	08	08_ARIE_L			R							ED			D1	D8	D8	D6	D1	D1	D1
142	142	Bachelorette	08	08_SEAN_L			R		R		R		E				D12	D8	D1	D6	D3	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
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
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
165	165	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
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
171	171	Bachelorette	07	07_RYAN_P	R1		R			R	ED						D10	D10	D8	D6	D1
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
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
191	191	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
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
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

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 rowid

Advanced export