Baselight

ESRB Data And More

Video game dataset with ESRB descriptor plus game information.

@kaggle.asherkatz_esrb_data_and_more

Loading...
Loading...

About this Dataset

ESRB Data And More

I was looking for an ESRB descriptor dataset with more than 10,000 rows which also contained release dates of games. I couldn't find anything to my liking so I decided to scrape one myself. On the longest run of my ELT pipeline, I was able to scrape ~59,000 rows of ESRB data, ~25,000 of which contained additional data such release year, publisher, genres etc. and ~7,000 of which contained sales data. I think this dataset has some potential for NLP featurization, as every row has two text description cells which can be parsed and featurized.

Tables

Combinedesrbdata

@kaggle.asherkatz_esrb_data_and_more.combinedesrbdata
  • 7.73 MB
  • 45891 rows
  • 75 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.