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)

Fox Clean Data

@kaggle.stephanieperez22_media_representation_tv_and_netflix_2016.fox_clean_data

27.88 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
FOX	Bones	dr	19	5	4	9	5	5			10	9	10	9	17	52%	16	48%	33	11		3	1		1	5	3	5		14		4		15	2		17
FOX	Brooklyn 99	sc	13	3	4	7	1	5		1	4	8	4	9	7	37%	12	63%	19	9		2	1		1	4		4	1	8	2	4	1	6	2	1	10
FOX	Empire	dr	24	2	4	6	11	7			13	11	13	11	12	40%	18	60%	30	3		20	1			21		6	1	17	2	1	1	20	5		19
FOX	Gotham	dr	25		5	5	8	12	2	2	6	15	8	17	6	24%	19	76%	25	20		3		2		5		5		20		6		19		4	21
FOX	Last Man on Earth	sc	7	3	3	6	1				4	3	4	3	5	33%	10	67%	15	5		1		1		2		2		5	2			5	1	2	4
FOX	Lethal Weapon	dr	26	1	3	4	7	15	1	2	7	16	8	18	4	15%	22	85%	26	13	1	7	3			10	2	5		21	3		5	18	5	3	18
FOX	Lucifer	dr	11	4	3	7	3	1			7	4	7	4	21	55%	17	45%	38	8		2	1			3		5		6	1		1	9	1		10
FOX	New Girl	sc	8	1	3	4	2	2			3	5	3	5	10	48%	11	52%	21	4		1		2		3	1	5		3	2	1	1	4		5	3
FOX	Pitch	dr	33	2	4	6	7	20			9	24	9	24	11.7	41%	16.52	59%	28.22	19		7	1	2		10	4	3		30		3	1	29	3		30
FOX	Rosewood	dr	16	3	3	6	3	7			6	10	6	10	18	44%	23	56%	41	9		5	2			7		3		13	2		1	13	1		15


CREATE TABLE fox_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" DOUBLE,
  "percentage_speaking_time_fem" VARCHAR,
  "speaking_time_male" DOUBLE,
  "percentage_speaking_time_male" VARCHAR,
  "total_speaking_time" DOUBLE,
  "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
);