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
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
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
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
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
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
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
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
54	54	Bachelorette	12	12_SAL_D	E
55	55	Bachelorette	12	12_PETER_M	E
56	56	Bachelorette	12	12_NICK_S	E
57	57	Bachelorette	12	12_JONATHAN_H	E
58	58	Bachelorette	12	12_JAKE_P	E
59	59	Bachelorette	12	12_COLEY_K	E
62	62	Bachelorette	11	11_NICK_V				R	R			E					D9	D1	D3	D1	D1
64	64	Bachelorette	11	11_JARED_H			R		R	E				D8	D6	D1	D9	D5	D1	D1
65	65	Bachelorette	11	11_JOE_B					R	ED				D7	D6	D5		D2	D3
66	66	Bachelorette	11	11_CHRIS_S			R			ED				D7	D6	D5	D9	D5	D1
68	68	Bachelorette	11	11_TANNER_T					E					D8	D6	D8	D9	D5
69	69	Bachelorette	11	11_JJ_L		R			ED					D7	D6	D8	D9	D2
70	70	Bachelorette	11	11_JOSHUA_A				E						D7	D6	D5	D9
71	71	Bachelorette	11	11_JUSTIN_R			R	E						D8		D8	D9
72	72	Bachelorette	11	11_IAN_T				EQ						D7		D5	D9
73	73	Bachelorette	11	11_COREY_S			E							D8		D8
74	74	Bachelorette	11	11_JONATHAN_H			E							D7	D6	D8
75	75	Bachelorette	11	11_RYAN_B			E								D6	D8
78	78	Bachelorette	11	11_CORY_S		E
79	79	Bachelorette	11	11_DANIEL_F		E								D8
80	80	Bachelorette	11	11_KUPAH_J		EU								D8
81	81	Bachelorette	11	11_BRADLEY_C	E
82	82	Bachelorette	11	11_DAVID_X	E
83	83	Bachelorette	11	11_JOSH_S	E
84	84	Bachelorette	11	11_SHAWN_E	E
85	85	Bachelorette	11	11_BRADY_T	EQ
86	86	Bachelorette	11	11_RYAN_M	EF
90	90	Bachelorette	10	10_CHRIS_S		R			R			ED		D1			D9	D6	D4	D1	D1
91	91	Bachelorette	10	10_MARCUS_G		R	R				E			D14	D12	D1	D9	D6	D1	D1
92	92	Bachelorette	10	10_BRIAN_O			R	R		E				D14	D12	D6	D1	D6	D4
93	93	Bachelorette	10	10_DYLAN_P			R			E				D14		D1	D9	D6	D4
95	95	Bachelorette	10	10_CODY_S					ED					D14	D12	D6	D9	D1
96	96	Bachelorette	10	10_ANDREW_P				E							D12	D6	D9
97	97	Bachelorette	10	10_MARQUEL_M				E						D14	D12	D6	D9
98	98	Bachelorette	10	10_PATRICK_J				E						D14	D12		D9
99	99	Bachelorette	10	10_TASOS_H			E							D14	D12
100	100	Bachelorette	10	10_ERIC_H		R	EU							D1	D12	D6
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
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
120	120	Bachelorette	09	09_JUAN_G					E					D14	D5	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
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

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