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)

Cw Clean Data

@kaggle.stephanieperez22_media_representation_tv_and_netflix_2016.cw_clean_data

27.78 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	total_non_white Total Non-White	unspecified Unspecified	straight Straight	lgbtq LGBTQ	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
CW	100, The	dr	23	4	7	11	5	7	5	6	4	8	9	14	8	44%	10	56%	18	14		7	1	1	9		4	2	17		5	1	17	1		22
CW	Arrow	dr	21	2	3	5	3	13			5	16	5	16	8	30%	19	70%	27	11	1	4	2	2	8	1	6	1	14	2			19	2		19
CW	DC's Legends	dr	15	2	8	10	1	4			3	12	3	12	6	18%	27	82%	33	10	2	2			2	1	1		14	1			14	1		14
CW	Flash, The	dr	13	2	4	6	2	5		1	4	8	4	9	8	22%	29	78%	37	5	1	4	2	1	7		6	1	6		2	3	8	2	9	2
CW	Frequency	dr	11	1	1	2	3	6			4	7	4	7	115	88%	15	12%	130	6		2	2	1	5		6		5	4	2		5	4	1	6
CW	Jane the Virgin	dr	21	3	3	6	11	4			14	7	14	7	19	56%	15	44%	34	11	2	1	6		7	1	11		10	2	3	12	4	7	6	8
CW	No Tomorrow	dr	17	3	3	6	5	6			8	9	8	9	15	54%	13	46%	28	10		3	1	3	7		5	1	11		5	2	10			17
CW	Supergirl	dr	14	3	3	6	4	4			7	7	7	7	9	60%	6	40%	15	7	2	5			5		1	2	11			1	13			14
CW	Supernatural	dr	16		4	4	4	8			4	12	4	12	5	23%	17	77%	22	10	2	1			1	3	4		12		2	3	11	3	2	11
CW	Vampire Diaries, The	dr	15	2	4	6	5	4	1		6	8	7	8	11	42%	15	58%	26	13		2			2		5		10		4		11	2	1	12


CREATE TABLE cw_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
);