Video Games Data

Video Games sales and details

@kaggle.ghassenkhaled_video_games_data

Table List

1 table(478.15 KB)

Video Games

@kaggle.ghassenkhaled_video_games_data.video_games

478.15 KB
16719 rows
16 columns

name Name	platform Platform	year_of_release Year Of Release	genre Genre	publisher Publisher	na_sales NA Sales	eu_sales EU Sales	jp_sales JP Sales	other_sales Other Sales	global_sales Global Sales	critic_score Critic Score	critic_count Critic Count	user_score User Score	user_count User Count	developer Developer	rating Rating
Wii Sports	Wii	2006	Sports	Nintendo	41.36	28.96	3.77	8.45	82.53	76	51	8	322	Nintendo	E
Super Mario Bros.	NES	1985	Platform	Nintendo	29.08	3.58	6.81	0.77	40.24			nan		nan	nan
Mario Kart Wii	Wii	2008	Racing	Nintendo	15.68	12.76	3.79	3.29	35.52	82	73	8.3	709	Nintendo	E
Wii Sports Resort	Wii	2009	Sports	Nintendo	15.61	10.93	3.28	2.95	32.77	80	73	8	192	Nintendo	E
Pokemon Red/Pokemon Blue	GB	1996	Role-Playing	Nintendo	11.27	8.89	10.22	1	31.37			nan		nan	nan
Tetris	GB	1989	Puzzle	Nintendo	23.2	2.26	4.22	0.58	30.26			nan		nan	nan
New Super Mario Bros.	DS	2006	Platform	Nintendo	11.28	9.14	6.5	2.88	29.8	89	65	8.5	431	Nintendo	E
Wii Play	Wii	2006	Misc	Nintendo	13.96	9.18	2.93	2.84	28.92	58	41	6.6	129	Nintendo	E
New Super Mario Bros. Wii	Wii	2009	Platform	Nintendo	14.44	6.94	4.7	2.24	28.32	87	80	8.4	594	Nintendo	E
Duck Hunt	NES	1984	Shooter	Nintendo	26.93	0.63	0.28	0.47	28.31			nan		nan	nan


CREATE TABLE video_games (
  "name" VARCHAR,
  "platform" VARCHAR,
  "year_of_release" DOUBLE,
  "genre" VARCHAR,
  "publisher" VARCHAR,
  "na_sales" DOUBLE,
  "eu_sales" DOUBLE,
  "jp_sales" DOUBLE,
  "other_sales" DOUBLE,
  "global_sales" DOUBLE,
  "critic_score" DOUBLE,
  "critic_count" DOUBLE,
  "user_score" VARCHAR,
  "user_count" DOUBLE,
  "developer" VARCHAR,
  "rating" VARCHAR
);