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)

Abc Clean Data

@kaggle.stephanieperez22_media_representation_tv_and_netflix_2016.abc_clean_data

27.89 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	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
ABC	Anerican Housewife	sc	11	3	2	5	5	1	2	1	6	2	8	3	13	81%	3	19%	16	9	1		1	2		5	1	5	4		2	5	3	3	5
ABC	Black-ish	sc	13	4	5	9	1	3	2	2	3	6	5	8	7	35%	13	65%	20	2	11			11		2		11	2			11	4	4	5
ABC	Designated Survivor	dr	28	3	4	7	7	14			10	18	10	18	9	30%	21	70%	30	23	1		2	3	2	6		22	4	2		22	2		26
ABC	Goldbergs, The	sc	19	2	4	6	1	12	2	9	1	7	3	16	5	25%	15	75%	20	15	1		3	4		2		17	2	2	1	14	4	3	12
ABC	Grey's Anatomy	dr	22	8	7	15	3	4		1	11	10	11	11	25	71%	10	29%	35	13	8			8	1	14	1	7	6	3	11	2	9	7	6
ABC	Last Man Standing	sc	8	2	3	5	2	1	1		3	4	4	4	7	39%	11	61%	18	7	1			1		4		4	2	2		4	2		6
ABC	Middle, The	sc	16	2	3	5	1	10	1	4	2	9	3	13	8	44%	10	56%	18	13	2		1	3		4		12	4			12	4	1	11
ABC	Modern Family	sc	15	2	6	8	2	5	1	6	3	5	4	11	5	23%	17	77%	22	12		2	1	3		5	3	7	6		2	7	7	7	1
ABC	Scandal	dr	21	6	5	11	4	6			10	11	10	11	10	36%	18	64%	28	14	5	1		6	1	4	3	14	2	4		15	2		19
ABC	Speechless	sc	23	2	3	5	9	9	8	7	3	5	11	12	8	44%	10	56%	18	13	4	1	3	8	2	3	1	19	2		1	20	3	12	8


CREATE TABLE abc_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" DOUBLE,
  "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
);