ESRB Data And More

Video game dataset with ESRB descriptor plus game information.

@kaggle.asherkatz_esrb_data_and_more

Table List

1 table(7.73 MB)

Combinedesrbdata

@kaggle.asherkatz_esrb_data_and_more.combinedesrbdata

7.73 MB
45891 rows
75 columns

game_title Game Title	esrb_rating Esrb Rating	content_descriptors Content Descriptors	interactive_elements Interactive Elements	content_summary Content Summary	platform Platform	release_date Release Date	updated Updated	developers Developers	genres Genres	release_year Release Year	publisher Publisher	number_of_descriptors Number Of Descriptors	crude_humor Crude Humor	mild_cartoon_violence Mild Cartoon Violence	cartoon_violence Cartoon Violence	mild_language Mild Language	mild_violence Mild Violence	violence Violence	blood_and_gore Blood And Gore	language Language	nudity Nudity	sexual_themes Sexual Themes	mild_fantasy_violence Mild Fantasy Violence
Ed, Edd n Eddy: Scam of the Century	E	Crude Humor,Mild Cartoon Violence	No Interactive Elements	No Rating Summary	Nintendo DS			nan	nan	2008	nan	2	1	1
Napoleon Dynamite	E10+	Cartoon Violence,Mild Language	No Interactive Elements	No Rating Summary	Nintendo DS	Wed Oct 31 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 09 2019 12:41:06 GMT+0000 (Coordinated Universal Time)	7 Studios	nan	2007	nan	2			1	1
Rail Simulator	E	No Descriptors	No Interactive Elements	No Rating Summary	Windows PC	Fri Oct 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 09 2019 12:41:06 GMT+0000 (Coordinated Universal Time)	Kuju Entertainment	Simulation	2007	Electronic Arts
NES Open Tournament Golf	E	No Descriptors	No Interactive Elements	No Rating Summary	Wii	Sun Jun 14 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 12 2019 12:10:28 GMT+0000 (Coordinated Universal Time)	Nintendo	Sports	1987	nan
Ultimate Duck Hunting	T	Mild Violence	No Interactive Elements	No Rating Summary	Wii	Tue May 26 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 09 2019 12:41:06 GMT+0000 (Coordinated Universal Time)	nan	nan	2009	Zoo Digital Publishing	1					1
Fortnite - Anime Legends	T	Violence	Users Interact, In-Game Purchases.	This is an action game in which players build forts, gather resources, craft weapons, and battle hordes of monsters in frenetic combat. Players compete in two multiplayer game modes: Save the World and Battle Royale. From a third-person perspective, players use guns, swords, and grenades to fight sk…	PlayStation 4			nan	nan	2022	nan	1						1
Demoniaca: Everlasting Night	M	Blood and Gore,Language,Nudity,Violence	No Interactive Elements	No Rating Summary	Nintendo Switch			nan	nan	2022	nan	4						1	1	1	1
Ryan’s Rescue Squad	E	Mild Cartoon Violence	No Interactive Elements	This is a side-scrolling platformer in which players help Ryan rescue his friends and stop a villain. Players traverse colorful 2D levels, throw balls to break blocks, and jump on enemies to defeat them. Enemies generally disappear when defeated; characters cry out when hit. Boss battles depict more…	Windows PC			nan	nan	2022	nan	1		1
The Sims™ 4 - Wedding Stories	T	Crude Humor,Sexual Themes,Violence	Online Interactions Not Rated by the ESRB.	No Rating Summary	Windows PC			nan	nan	2018	nan	3	1					1				1
The400 Mini	E	Mild Fantasy Violence	No Interactive Elements	This is a collection of classic Atari 400 games across a variety of genres (e.g., sports, platformers, action-adventure, space shooters). Some games contain moderate or pixilated depictions of violence: small figures shooting projectiles at robots; fighters exploring platforms while punching/kicking…	The400 Mini			nan	nan	2024	nan	1											1


CREATE TABLE combinedesrbdata (
  "game_title" VARCHAR,
  "esrb_rating" VARCHAR,
  "content_descriptors" VARCHAR,
  "interactive_elements" VARCHAR,
  "content_summary" VARCHAR,
  "platform" VARCHAR,
  "release_date" TIMESTAMP,
  "updated" TIMESTAMP,
  "developers" VARCHAR,
  "genres" VARCHAR,
  "release_year" BIGINT,
  "publisher" VARCHAR,
  "na_sales" DOUBLE,
  "eu_sales" DOUBLE,
  "jp_sales" DOUBLE,
  "other_sales" DOUBLE,
  "global_sales" DOUBLE,
  "number_of_descriptors" BIGINT,
  "crude_humor" DOUBLE,
  "mild_cartoon_violence" DOUBLE,
  "cartoon_violence" DOUBLE,
  "mild_language" DOUBLE,
  "mild_violence" DOUBLE,
  "violence" DOUBLE,
  "blood_and_gore" DOUBLE,
  "language" DOUBLE,
  "nudity" DOUBLE,
  "sexual_themes" DOUBLE,
  "mild_fantasy_violence" DOUBLE,
  "alcohol_reference" DOUBLE,
  "mild_suggestive_themes" DOUBLE,
  "simulated_gambling" DOUBLE,
  "fantasy_violence" DOUBLE,
  "mild_blood" DOUBLE,
  "use_of_alcohol" DOUBLE,
  "use_of_tobacco" DOUBLE,
  "drug_reference" DOUBLE,
  "strong_language" DOUBLE,
  "suggestive_themes" DOUBLE,
  "blood" DOUBLE,
  "partial_nudity" DOUBLE,
  "tobacco_reference" DOUBLE,
  "comic_mischief" DOUBLE,
  "animated_blood" DOUBLE,
  "intense_violence" DOUBLE,
  "alcohol_and_tobacco_reference" DOUBLE,
  "violent_references" DOUBLE,
  "strong_sexual_content" DOUBLE,
  "use_of_alcohol_and_tobacco" DOUBLE,
  "use_of_drugs" DOUBLE,
  "mild_lyrics" DOUBLE,
  "lyrics" DOUBLE,
  "use_of_drugs_and_alcohol" DOUBLE,
  "animated_violence" DOUBLE,
  "mild_sexual_themes" DOUBLE,
  "sexual_content" DOUBLE,
  "drug_and_alcohol_reference" DOUBLE,
  "strong_lyrics" DOUBLE,
  "mature_humor" DOUBLE,
  "edutainment" DOUBLE,
  "gambling" DOUBLE,
  "animated_blood_and_gore" DOUBLE,
  "informational" DOUBLE,
  "mature_sexual_themes" DOUBLE,
  "mild_animated_violence" DOUBLE,
  "gaming" DOUBLE,
  "realistic_violence" DOUBLE,
  "realistic_blood" DOUBLE,
  "suitable_for_mature_users" DOUBLE,
  "gambling_themes" DOUBLE,
  "realistic_blood_and_gore" DOUBLE,
  "sexual_violence" DOUBLE,
  "mild_realistic_violence" DOUBLE,
  "suitable_for_all_users" DOUBLE,
  "mild_animated_blood" DOUBLE
);