Board Game Data
Data is a collection of board game information from Board Game Geek
@kaggle.mrpantherson_board_game_data
Data is a collection of board game information from Board Game Geek
@kaggle.mrpantherson_board_game_data
Being a fan of board games, I wanted to see if there was any correlation with a games rating and any particular quality, the first step was to collect of this data.
The data was collected in March of 2017 from the website https://boardgamegeek.com/, this site has an API to retrieve game information (though sadly XML not JSON).
Mainly I want to thank the people who run the board game geek website for maintaining such a great resource for those of us in the hobby.
I wish I had some better questions to ask of the data, perhaps somebody else can think of some good ways to get some insight of this dataset.
CREATE TABLE bgg_db_1806 (
"rank" BIGINT,
"bgg_url" VARCHAR,
"game_id" BIGINT,
"names" VARCHAR,
"min_players" BIGINT,
"max_players" BIGINT,
"avg_time" BIGINT,
"min_time" BIGINT,
"max_time" BIGINT,
"year" BIGINT,
"avg_rating" DOUBLE,
"geek_rating" DOUBLE,
"num_votes" BIGINT,
"image_url" VARCHAR,
"age" BIGINT,
"mechanic" VARCHAR,
"owned" BIGINT,
"category" VARCHAR,
"designer" VARCHAR,
"weight" DOUBLE
);Anyone who has the link will be able to view this.