Name: Board Games
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Board Games

This dataset comes from Board Games Geek.

Note that the two datasets can be joined on the id column.

This data contains an overview of many games and their user ratings.

Data Dictionary

`ratings.csv`

variable	class	description
num	double	Game number
id	double	Game ID
name	character	Game name
year	double	Game year
rank	double	Game rank
average	double	Average rating
bayes_average	double	Bayes average rating
users_rated	double	Users rated
url	character	Game url
thumbnail	character	Game thumbnail

`details.csv`

variable	class	description
num	double	Game number
id	double	Game ID
primary	character	Primary name
description	character	Description of game
yearpublished	double	Year published
minplayers	double	Min n of players
maxplayers	double	Max n of players
playingtime	double	Playing time in minutes
minplaytime	double	Min play time
maxplaytime	double	Max plat tome
minage	double	minimum age
boardgamecategory	character	Category
boardgamemechanic	character	Mechanic
boardgamefamily	character	Board game family
boardgameexpansion	character	Expansion
boardgameimplementation	character	Implementation
boardgamedesigner	character	Designer
boardgameartist	character	Artist
boardgamepublisher	character	Publisher
owned	double	Num owned
trading	double	Num trading
wanting	double	Num wanting
wishing	double	Num wishing

Tables

Details

@kaggle.joebeachcapital_board_games.details

18.51 MB
21,631 rows
23 columns

CREATE TABLE details (
  "num" BIGINT,
  "id" BIGINT,
  "primary" VARCHAR,
  "description" VARCHAR,
  "yearpublished" BIGINT,
  "minplayers" BIGINT,
  "maxplayers" BIGINT,
  "playingtime" BIGINT,
  "minplaytime" BIGINT,
  "maxplaytime" BIGINT,
  "minage" BIGINT,
  "boardgamecategory" VARCHAR,
  "boardgamemechanic" VARCHAR,
  "boardgamefamily" VARCHAR,
  "boardgameexpansion" VARCHAR,
  "boardgameimplementation" VARCHAR,
  "boardgamedesigner" VARCHAR,
  "boardgameartist" VARCHAR,
  "boardgamepublisher" VARCHAR,
  "owned" BIGINT,
  "trading" BIGINT,
  "wanting" BIGINT,
  "wishing" BIGINT
);

Ratings

@kaggle.joebeachcapital_board_games.ratings

2.87 MB
21,831 rows
10 columns

CREATE TABLE ratings (
  "num" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "year" BIGINT,
  "rank" BIGINT,
  "average" DOUBLE,
  "bayes_average" DOUBLE,
  "users_rated" BIGINT,
  "url" VARCHAR,
  "thumbnail" VARCHAR
);