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)

Nbc Clean Data

@kaggle.stephanieperez22_media_representation_tv_and_netflix_2016.nbc_clean_data

27.81 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	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
NBC	Blacklist, The	dr	20	2	4	6	4	10			6	14	6	14	10	36%	18	64%	28	9	4	1	1	2	1	5	2	4		16		4		16	2		18
NBC	Blindspot	dr	16	3	4	7	4	5			7	9	7	9	15	58%	11	42%	26	8	1	3	1	1		5	2	2		14		2		14	1		15
NBC	Chicago Fire	dr	30	2	3	5	8	17	1	1	9	19	10	20	10	29%	25	71%	35	18		9	2			11	1	4		26		4		26	2		28
NBC	Chicago Med	dr	27	5	5	10	8	9		2	13	12	13	14	13	46%	15	54%	28	13		7	4	3		14		8		19	2	7	2	16	6	2	19
NBC	Chicago P.D.	dr	39	5	6	11	9	19	1	1	13	24	14	25	9	33%	18	67%	27	18		16	2	2		20	1	3		36		3	3	33	4	2	33
NBC	Good Place, The	sc	11	3	4	7	1	3			4	7	4	7	10	56%	8	44%	18	6		1		2	1	4	1	4	1	6		4		7			11
NBC	Grimm	dr	19	3	6	9	2	8	1		4	14	5	14	6	24%	19	76%	25	13		2	1	2		5	1	5		14	2	3	1	13	6	1	12
NBC	Law and Order: SVU	dr	22	2	2	4	7	11		2	9	11	9	13	22	69%	10	31%	32	13	1	3	3	1		7	1	3	3	16		4	2	16	4	1	17
NBC	This is Us	dr	26	2	3	5	10	11	1		11	14	12	14	6	20%	24	80%	30	13		5	2	3	1	11	2	7		19	4	3	1	18	6	3	17
NBC	Timeless	dr	21	1	2	3	5	13		1	6	14	6	15	8	31%	18	69%	26	13		2	1	2		5	3			21		1		20	3	1	17


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