fivethirtyeight: bachelorette/bachelorette: 921 rows where sorted by rowid 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 rowid 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
921	921	Bachelor	01	01_WENDI_X	E
920	920	Bachelor	01	01_RACHEL_X	E
919	919	Bachelor	01	01_PAULA_X	E
918	918	Bachelor	01	01_LISA_X	E
917	917	Bachelor	01	01_KRISTINA_X	E
916	916	Bachelor	01	01_JILL_X	E
915	915	Bachelor	01	01_JACKIE_X	E
914	914	Bachelor	01	01_DENISE_X	E
913	913	Bachelor	01	01_DANIELA_X	E
912	912	Bachelor	01	01_AMBER_X	E
911	911	Bachelor	01	01_TINA_X		E										D5
910	910	Bachelor	01	01_MELISSA_X		E										D5
909	909	Bachelor	01	01_KATIE_X		E										D5
908	908	Bachelor	01	01_ANGELIQUE_X		E										D5
907	907	Bachelor	01	01_ANGELA_X		E										D5
906	906	Bachelor	01	01_AMY_X		E										D5
905	905	Bachelor	01	01_ALEXA_X		E										D5
904	904	Bachelor	01	01_RHONDA_X			E									D5	D4
903	903	Bachelor	01	01_LANEASE_A			E									D5	D4
902	902	Bachelor	01	01_CHRISTINA_X			E									D5	D4
901	901	Bachelor	01	01_CATHY_G			E									D5	D4
900	900	Bachelor	01	01_KIM_X				E								D5	D4	D1
899	899	Bachelor	01	01_SHANNON_O					E							D5	D1	D1	D1
898	898	Bachelor	01	01_TRISTA_R						E						D5	D1	D1	D1	D1
897	897	Bachelor	01	01_AMANDA_M						W						D5	D1	D1	D1	D1
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
895	895	Bachelor	02	02_MERILEE_X	E
894	894	Bachelor	02	02_LORI_X	E
893	893	Bachelor	02	02_LIANGY_X	E
892	892	Bachelor	02	02_FATIMA_X	E
891	891	Bachelor	02	02_ERIN_X	E
890	890	Bachelor	02	02_CHRISTY_X	E
889	889	Bachelor	02	02_CARI_X	E
888	888	Bachelor	02	02_CAMILLE_X	E
887	887	Bachelor	02	02_AMBER_X	E
886	886	Bachelor	02	02_ANINDITA_X		EQ										D5
885	885	Bachelor	02	02_FRANCES_X		EQ										D5
884	884	Bachelor	02	02_SUZANNE_X		E										D5
883	883	Bachelor	02	02_ERIN_X		E										D5
882	882	Bachelor	02	02_DANA_X		E										D5
881	881	Bachelor	02	02_SHANNON_X			E									D5	D5
880	880	Bachelor	02	02_KYLA_X			E									D5	D3
879	879	Bachelor	02	02_HEATHER_X			E									D5	D5
878	878	Bachelor	02	02_CHRISTI_X			E									D5	D5
877	877	Bachelor	02	02_HEATHER_C				E								D5	D5	D1
876	876	Bachelor	02	02_HAYLEY_X				E								D5	D3	D3
875	875	Bachelor	02	02_ANGELA_X					E							D5	D5	D3	D1
874	874	Bachelor	02	02_GWEN_G						E						D5	D3	D1	D1	D1
873	873	Bachelor	02	02_BROOKE_S							E					D5	D1	D3	D1	D1
872	872	Bachelor	02	02_HELENE_E							W					D5	D1	D1	D1	D1	D1
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
870	870	Bachelor	03	03_KRISTEN_X	E
869	869	Bachelor	03	03_TIFFANY_X	E
868	868	Bachelor	03	03_STEPHANIE_X	E
867	867	Bachelor	03	03_BROOKE_X	E
866	866	Bachelor	03	03_GINNY_X	E
865	865	Bachelor	03	03_ANGELA_X	E
864	864	Bachelor	03	03_COURTNEY_X	E
863	863	Bachelor	03	03_JENNIFER_X	E
862	862	Bachelor	03	03_AMY_X	E											D5
861	861	Bachelor	03	03_KERRI_X	E
860	860	Bachelor	03	03_CHRISTINA_X		EQ										D5
859	859	Bachelor	03	03_ELIZABETH_X		E										D5
858	858	Bachelor	03	03_SHANNON_X		E										D5
857	857	Bachelor	03	03_AMY_X		E										D5
856	856	Bachelor	03	03_RACHEL_X		E										D5
855	855	Bachelor	03	03_TINA_X			E									D5	D5
854	854	Bachelor	03	03_HEATHER_X			E									D5	D5
853	853	Bachelor	03	03_AMBER_X			E									D5	D1
852	852	Bachelor	03	03_AUDREE_X			E									D5	D5
851	851	Bachelor	03	03_ANN_MICHELLE_X				E								D5	D3	D1
850	850	Bachelor	03	03_LIZ_X				E								D5	D3	D3
849	849	Bachelor	03	03_CRISTINA_X				E	E							D5	D3	D3	D1
848	848	Bachelor	03	03_TINA_X						E						D5	D5	D3	D1	D1
847	847	Bachelor	03	03_KIRSTEN_X							E					D5	D1	D1	D1	D1	D1
846	846	Bachelor	03	03_JEN_X							W					D5	D5	D1	D1	D1	D1
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
844	844	Bachelor	04	04_Shelly	E
843	843	Bachelor	04	04_Julie	E
842	842	Bachelor	04	04_Leona	E
841	841	Bachelor	04	04_Samentha	E
840	840	Bachelor	04	04_Kristi	E
839	839	Bachelor	04	04_Lauren	E
838	838	Bachelor	04	04_Heather	E
837	837	Bachelor	04	04_Shea	E
836	836	Bachelor	04	04_Stacey	E
835	835	Bachelor	04	04_Darla	E
834	834	Bachelor	04	04_Christine		E										D5
833	833	Bachelor	04	04_Jenn		E										D5
832	832	Bachelor	04	04_Lanah		E										D6
831	831	Bachelor	04	04_Lindsay		E										D6
830	830	Bachelor	04	04_Lindsay_clippers		ED										D5
829	829	Bachelor	04	04_Antoinette			E									D6	D5
828	828	Bachelor	04	04_Jenny			E									D6	D5
827	827	Bachelor	04	04_Karin			E									D4	D5
826	826	Bachelor	04	04_Misty			E									D5	D3
825	825	Bachelor	04	04_Lee-Ann				E								D6	D1	D3
824	824	Bachelor	04	04_Brooke				E								D4	D5	D3
823	823	Bachelor	04	04_Meredith					E							D4	D1	D3	D1
822	822	Bachelor	04	04_Mary						E						D6	D3	D1	D1	D1

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 descending

Advanced export