Media Representation: TV And Netflix (2016)

Gender representation in media as coded through language

@kaggle.stephanieperez22_media_representation_tv_and_netflix_2016

Table List

6 tables(168.37 KB)

Cbs Clean Data

@kaggle.stephanieperez22_media_representation_tv_and_netflix_2016.cbs_clean_data

27.82 KB
10 rows
38 columns

broadcasting_station Broadcasting Station	series_name Series Name	sit_com_drama Sit-com/Drama	total_characters Total Characters	main_characters_fem Main Characters Fem	main_characters_male Main Characters Male	total_main_characters Total Main Characters	other_characters_fem Other Characters Fem	other_characters_male Other Characters Male	minors_fem Minors Fem	minors_male Minors Male	adults_fem Adults Fem	adults_male Adults Male	total_characters_fem Total Characters Fem	total_characters_male Total Characters Male	speaking_time_fem Speaking Time Fem	percentage_speaking_time_fem Percentage Speaking Time Fem	speaking_time_male Speaking Time Male	percentage_speaking_time_male Percentage Speaking Time Male	total_speaking_time Total Speaking Time	white_american White American	white_other White Other	black Black	latino Latino	asian Asian	middle_eastern Middle Eastern	total_non_white Total Non-White	unspecified Unspecified	straight Straight	unspecified_1 Unspecified.1	married Married	in_a_relat In A Relat.	single Single	unspecified_2 Unspecified.2	parents Parents	not_parents Not Parents	unspecified_3 Unspecified.3
CBS	Big Bang Theory, The	sc	9	3	4	7		2			3	6	3	6	7	30%	16	70%	23	8				1		1		7	2	4	2	1	2	2	5	2
CBS	Blue Bloods	dr	27	2	6	8	6	13	1	2	7	17	8	19	7	21%	26	79%	33	24		1	2			3		6	21	6		3	18	7	2	18
CBS	Bull	dr	21	3	3	6	4	11			7	14	7	14	7	21%	27	79%	34	12		4	1	2		7	2		21	2			19	1	1	19
CBS	Hawaii Five-0	sc	19	1	5	6	6	7	1		6	12	7	12	5	24%	16	76%	21	4	2	2	1	6	3	12	1	4	15			5	14	3	1	15
CBS	Kevin Can Wait	sc	10	2	2	4	3	3	2	2	3	3	5	5	6	38%	10	63%	16	8							2	6	4	2	4		4	2	2	6
CBS	MacGyver	dr	14	2	3	5	2	7			4	10	4	10	8	33%	16	67%	24	3		4	6	1		11		1	13			1	13			14
CBS	Madame Secretary	dr	25	3	4	7	6	12	2	1	7	15	9	16	15	42%	21	58%	36	16	2	3	2			5	2	2	23	2			23	2	3	20
CBS	NCIS	dr	20	3	5	8	5	7		1	8	11	8	12	15	41%	22	59%	37	12		3	3			6	2	4	16		3		17	2	1	17
CBS	NCIS: Los Angeles	dr	16	3	4	7	2	7			5	11	5	11	10	36%	18	64%	28	13		1	1	1		3		4	12		4		12	2		14
CBS	NCIS: New Orleans	dr	17	3	3	6	4	7		1	7	9	7	10	10	36%	18	64%	28	8		7	1			8	1	3	14	1	3	1	12	4	1	12


CREATE TABLE cbs_clean_data (
  "broadcasting_station" VARCHAR,
  "series_name" VARCHAR,
  "sit_com_drama" VARCHAR,
  "total_characters" BIGINT,
  "main_characters_fem" BIGINT,
  "main_characters_male" BIGINT,
  "total_main_characters" BIGINT,
  "other_characters_fem" BIGINT,
  "other_characters_male" BIGINT,
  "minors_fem" BIGINT,
  "minors_male" BIGINT,
  "adults_fem" BIGINT,
  "adults_male" BIGINT,
  "total_characters_fem" BIGINT,
  "total_characters_male" BIGINT,
  "speaking_time_fem" BIGINT,
  "percentage_speaking_time_fem" VARCHAR,
  "speaking_time_male" BIGINT,
  "percentage_speaking_time_male" VARCHAR,
  "total_speaking_time" BIGINT,
  "white_american" BIGINT,
  "white_other" BIGINT,
  "black" BIGINT,
  "latino" BIGINT,
  "asian" BIGINT,
  "middle_eastern" BIGINT,
  "total_non_white" BIGINT,
  "unspecified" BIGINT,
  "straight" BIGINT,
  "lgbtq" BIGINT,
  "unspecified_1" BIGINT,
  "married" BIGINT,
  "in_a_relat" BIGINT,
  "single" BIGINT,
  "unspecified_2" BIGINT,
  "parents" BIGINT,
  "not_parents" BIGINT,
  "unspecified_3" BIGINT
);