Ted Lasso: Roy Kent F-Bombs

Includes the number, percentage, and context of f**k used in each episode

@kaggle.joebeachcapital_roy_kent_f_bombs

Table List

1 table(13 KB)

Richmondway

@kaggle.joebeachcapital_roy_kent_f_bombs.richmondway

13 KB
34 rows
16 columns

character Character	episode_order Episode Order	season Season	episode Episode	season_episode Season Episode	f_count_rk F Count RK	f_count_total F Count Total	cum_rk_season Cum Rk Season	cum_total_season Cum Total Season	cum_rk_overall Cum Rk Overall	cum_total_overall Cum Total Overall	f_score F Score	f_perc F Perc	dating_flag Dating Flag	coaching_flag Coaching Flag	imdb_rating Imdb Rating
Roy Kent	1	1	1	S1_e1	2	13	2	13	2	13	0.1538461538461538	15.4	No	No	7.8
Roy Kent	2	1	2	S1_e2	2	8	4	21	4	21	0.25	25	No	No	8.1
Roy Kent	3	1	3	S1_e3	7	13	11	34	11	34	0.5384615384615384	53.8	No	No	8.5
Roy Kent	4	1	4	S1_e4	8	17	19	51	19	51	0.4705882352941176	47.1	No	No	8.2
Roy Kent	5	1	5	S1_e5	4	13	23	64	23	64	0.3076923076923077	30.8	No	No	8.9
Roy Kent	6	1	6	S1_e6	2	9	25	73	25	73	0.2222222222222222	22.2	No	No	8.5
Roy Kent	7	1	7	S1_e7	5	15	30	88	30	88	0.3333333333333333	33.3	No	No	9
Roy Kent	8	1	8	S1_e8	7	18	37	106	37	106	0.3888888888888889	38.9	Yes	No	8.7
Roy Kent	9	1	9	S1_e9	14	22	51	128	51	128	0.6363636363636364	63.6	Yes	No	8.6
Roy Kent	10	1	10	S1_e10	5	22	56	150	56	150	0.2272727272727272	22.7	Yes	No	9.1


CREATE TABLE richmondway (
  "character" VARCHAR,
  "episode_order" BIGINT,
  "season" BIGINT,
  "episode" BIGINT,
  "season_episode" VARCHAR,
  "f_count_rk" BIGINT,
  "f_count_total" BIGINT,
  "cum_rk_season" BIGINT,
  "cum_total_season" BIGINT,
  "cum_rk_overall" BIGINT,
  "cum_total_overall" BIGINT,
  "f_score" DOUBLE,
  "f_perc" DOUBLE,
  "dating_flag" VARCHAR,
  "coaching_flag" VARCHAR,
  "imdb_rating" DOUBLE
);