fivethirtyeight: bachelorette/bachelorette: 921 rows where sorted by ELIMINATION-9 descending

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-9 descending

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
61	61	Bachelorette	11	11_SHAWN_B	R1		R		R				W				D6	D8	D1		D3	D1	D1
386	386	Bachelor	20	20_CAILA_Q		R				R			EU			D1		D12	D9	D1	D3	D1	D1
116	116	Bachelorette	09	09_BROOKS_F		R			R				EQ			D1	D10	D10	D7	D6	D1	D1
168	168	Bachelorette	07	07_CONSTANTINE_T				R					EQ					D1	D8	D6	D1	D1	D1
446	446	Bachelor	18	18_ANDI_D				R		R	R		EQ			D13	D10	D6	D9	D1	D4	D1	D1
194	194	Bachelorette	06	06_FRANK_N		R				R			EF			D1	D9	D7	D6	D1	D2	D1	D1
36	36	Bachelorette	12	12_CHASE_M			R			R			ED				D1	D11	D9	D2	D3	D1	D1
90	90	Bachelorette	10	10_CHRIS_S		R				R			ED			D1			D9	D6	D4	D1	D1
4	4	Bachelorette	13	13_ERIC_B			R			R	R		E			D10	D8	D13	D9	D1	D3	D1	D1
62	62	Bachelorette	11	11_NICK_V					R	R			E						D9	D1	D3	D1	D1
142	142	Bachelorette	08	08_SEAN_L			R		R		R		E				D12	D8	D1	D6	D3	D1	D1
220	220	Bachelorette	05	05_REID_R						R			E				D11	D10	D8	D1	D1	D1	D1
355	355	Bachelor	21	21_RACHEL_L			R		R				E				D7	D13	D1	D6	D1	D1	D1
415	415	Bachelor	19	19_KAITLYN_B		R	R	R			R		E			D11	D1	D8	D9	D6	D3	D1	D1
474	474	Bachelor	17	17_ASHLEE_F	R1		R						E				D1	D8	D8	D7	D1	D1	D1
501	501	Bachelor	16	16_NICKI_S					R				E			D12	D11	D8	D1	D6	D3	D1	D1
527	527	Bachelor	15	15_ASHLEU_H		R			R		R		E			D1	D12	D9	D2	D6	D3	D1	D1
1	1	SHOW	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
33	33	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
60	60	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
87	87	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
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
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
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
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
217	217	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
248	248	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
274	274	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
300	300	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
326	326	Bachelorette	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
352	352	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
383	383	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
412	412	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
443	443	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
471	471	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
498	498	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
524	524	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
555	555	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
581	581	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
607	607	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
633	633	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
659	659	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
685	685	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
713	713	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
739	739	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
765	765	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
793	793	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
819	819	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
845	845	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	1	2
871	871	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
896	896	Bachelor	SEASON	ID	1	2	3	4	5	6	7	8	9	10	1	2	3	4	5	6	7	8	9	10
2	2	Bachelorette	13	13_BRYAN_A	R1			R	R		R			W			D6	D13	D1	D7	D1	D1	D1	D1
3	3	Bachelorette	13	13_PETER_K		R				R	R			E		D1	D6	D13	D9	D7	D1	D1	D1	D1
5	5	Bachelorette	13	13_DEAN_U		R		R			R	E				D8	D8	D1	D9	D7	D1	D1
6	6	Bachelorette	13	13_ADAM_G							ED					D10	D8	D13	D9	D7	D3
7	7	Bachelorette	13	13_MATT_M							ED					D10		D13	D9	D7	D3
8	8	Bachelorette	13	13_ALEX_B			R			E						D10	D6	D13	D9	D7
9	9	Bachelorette	13	13_WILL_G					R	ED						D10	D6	D13	D9	D1
10	10	Bachelorette	13	13_KENNY_L					R	ED						D8	D8	D13	D2	D7
11	11	Bachelorette	13	13_ANTHONY_B			R		E								D1	D13	D9
12	12	Bachelorette	13	13_JOSIAH_G		R			E							D10		D13	D9
13	13	Bachelorette	13	13_LEE_G					ED							D10	D8	D13	D2
14	14	Bachelorette	13	13_IGGY_R				E								D8		D13
15	15	Bachelorette	13	13_JONATHAN_T				E								D8	D6	D13
16	16	Bachelorette	13	13_JACK_S				ED								D8	D8	D1
17	17	Bachelorette	13	13_BRADY_E			E										D8
18	18	Bachelorette	13	13_BRYCE_P			E										D8
19	19	Bachelorette	13	13_DIGGY_M			E									D10
20	20	Bachelorette	13	13_FRED_J			ED									D8	D6
21	21	Bachelorette	13	13_BLAKE_E		E										D8
22	22	Bachelorette	13	13_JAMEY_K		E										D10
23	23	Bachelorette	13	13_LUCAS_Y		E										D8
24	24	Bachelorette	13	13_DEMARIO_J		EU										D10
25	25	Bachelorette	13	13_BLAKE_K	E
26	26	Bachelorette	13	13_GRANT_H	E
27	27	Bachelorette	13	13_JEDIDIAH_B	E
28	28	Bachelorette	13	13_KYLE_S	E
29	29	Bachelorette	13	13_MICHAEL_B	E
30	30	Bachelorette	13	13_MILTON_L	E
31	31	Bachelorette	13	13_MOHIT_S	E
32	32	Bachelorette	13	13_ROB_H	E
34	34	Bachelorette	12	12_JORDAN_R	R1			R	R					W		D6	D12	D11	D1	D5	D1	D1	D1	D1
35	35	Bachelorette	12	12_ROBBY_H					R		R			E		D10		D11	D9	D5	D3	D1	D1	D1
37	37	Bachelorette	12	12_LUKE_P				R		R		E				D10		D1	D9	D5	D1	D1
38	38	Bachelorette	12	12_JAMES_T		R	R				E					D6	D1	D11	D9	D5	D3
39	39	Bachelorette	12	12_ALEX_W				R			ED					D6	D12	D2	D9	D5	D1
40	40	Bachelorette	12	12_DEREK_P		R			R	ED						D1		D11	D1	D2
41	41	Bachelorette	12	12_WELLS_A		R				ED						D10	D12	D11	D9	D1
42	42	Bachelorette	12	12_VINCENT_V					E							D10	D12	D11	D9
43	43	Bachelorette	12	12_GRANT_K					E							D10	D12	D11	D9
44	44	Bachelorette	12	12_EVAN_B			R		E							D10	D12	D11	D9
45	45	Bachelorette	12	12_JAMES_F				E								D10	D12	D11
46	46	Bachelorette	12	12_DANIEL_M				E								D10	D12	D11
47	47	Bachelorette	12	12_CHAD_J				ED								D6	D12	D2
48	48	Bachelorette	12	12_NICK_B			E									D6	D12
49	49	Bachelorette	12	12_CHRISTIAN_B			E									D6	D12
50	50	Bachelorette	12	12_ALI_Z			E									D10	D12
51	51	Bachelorette	12	12_WILL_H		E										D10
52	52	Bachelorette	12	12_JAMES_S		E
53	53	Bachelorette	12	12_BRANDON_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-9 descending

Advanced export