Name: Animal Crossing New Horizons Catalog
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Animal Crossing New Horizons Catalog

Context

This dataset comes from this spreadsheet, a comprehensive Item Catalog for Animal Crossing New Horizons (ACNH). As described by Wikipedia,

ACNH is a life simulation game released by Nintendo for Nintendo Switch on March 20, 2020. It is the fifth main series title in the Animal Crossing series and, with 5 million digital copies sold, has broken the record for Switch title with most digital units sold in a single month. In New Horizons, the player assumes the role of a customizable character who moves to a deserted island. Taking place in real-time, the player can explore the island in a nonlinear fashion, gathering and crafting items, catching insects and fish, and developing the island into a community of anthropomorphic animals.

Content

There are 30 csvs each listing various items, villagers, clothing, and other collectibles from the game. The data was collected by a dedicated group of AC fans who continue to collaborate and build this spreadsheet for public use. The database contains the original data and full list of contributors and raw data. At the time of writing, the only difference between the spreadsheet and this version is that the Kaggle version omits all columns with images of the items, but is otherwise identical.

Acknowledgements

Thanks to every contributor listed on the spreadsheet! Please attribute this spreadsheet and group for any use of the data. They also have a Discord server linked in the spreadsheet in case you want to contact them.

Tables

Tops

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.tops

63.87 KB
1121 rows
21 columns


CREATE TABLE tops (
  "name" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "seasonal_availability" VARCHAR,
  "mannequin_piece" VARCHAR,
  "version" VARCHAR,
  "style" VARCHAR,
  "label_themes" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Umbrellas

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.umbrellas

14.35 KB
67 rows
16 columns


CREATE TABLE umbrellas (
  "name" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Villagers

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.villagers

52.24 KB
391 rows
17 columns


CREATE TABLE villagers (
  "name" VARCHAR,
  "species" VARCHAR,
  "gender" VARCHAR,
  "personality" VARCHAR,
  "hobby" VARCHAR,
  "birthday" VARCHAR,
  "catchphrase" VARCHAR,
  "favorite_song" VARCHAR,
  "style_1" VARCHAR,
  "style_2" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "wallpaper" VARCHAR,
  "flooring" VARCHAR,
  "furniture_list" VARCHAR,
  "filename" VARCHAR,
  "unique_entry_id" VARCHAR
);

Wall Mounted

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.wall_mounted

42.95 KB
3275 rows
31 columns


CREATE TABLE wall_mounted (
  "name" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "pattern" VARCHAR,
  "pattern_title" VARCHAR,
  "diy" VARCHAR,
  "body_customize" VARCHAR,
  "pattern_customize" VARCHAR,
  "kit_cost" DOUBLE,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version" VARCHAR,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "hha_set" VARCHAR,
  "interact" VARCHAR,
  "tag" VARCHAR,
  "outdoor" VARCHAR,
  "lighting_type" VARCHAR,
  "door_deco" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Wallpaper

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.wallpaper

31.99 KB
247 rows
26 columns


CREATE TABLE wallpaper (
  "name" VARCHAR,
  "vfx" VARCHAR,
  "vfx_type" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "catalog" VARCHAR,
  "window_type" VARCHAR,
  "window_color" VARCHAR,
  "pane_type" VARCHAR,
  "curtain_type" VARCHAR,
  "curtain_color" VARCHAR,
  "ceiling_type" VARCHAR,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "tag" VARCHAR,
  "version" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);