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

Accessories

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.accessories

25.26 KB
222 rows
22 columns


CREATE TABLE accessories (
  "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,
  "type" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Achievements

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.achievements

23.61 KB
84 rows
21 columns


CREATE TABLE achievements (
  "name" VARCHAR,
  "award_criteria" VARCHAR,
  "n" BIGINT,
  "internal_id" BIGINT,
  "internal_name" VARCHAR,
  "internal_category" VARCHAR,
  "num_of_tiers" BIGINT,
  "tier_1" BIGINT,
  "tier_2" BIGINT,
  "tier_3" BIGINT,
  "tier_4" BIGINT,
  "tier_5" BIGINT,
  "reward_tier_1" BIGINT,
  "reward_tier_2" BIGINT,
  "reward_tier_3" BIGINT,
  "reward_tier_4" BIGINT,
  "reward_tier_5" BIGINT,
  "reward_tier_6" BIGINT,
  "sequential" VARCHAR,
  "version" VARCHAR,
  "unique_entry_id" VARCHAR
);

Art

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.art

30.76 KB
70 rows
26 columns


CREATE TABLE art (
  "name" VARCHAR,
  "genuine" VARCHAR,
  "category" VARCHAR,
  "buy" BIGINT,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "real_artwork_title" VARCHAR,
  "artist" VARCHAR,
  "museum_description" 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,
  "speaker_type" VARCHAR,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Bags

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.bags

18.49 KB
96 rows
20 columns


CREATE TABLE bags (
  "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,
  "version" VARCHAR,
  "style" VARCHAR,
  "label_themes" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Bottoms

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.bottoms

43.45 KB
726 rows
20 columns


CREATE TABLE bottoms (
  "name" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "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
);

Construction

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.construction

13.8 KB
236 rows
7 columns


CREATE TABLE construction (
  "name" VARCHAR,
  "buy" BIGINT,
  "category" VARCHAR,
  "source" VARCHAR,
  "filename" VARCHAR,
  "version" VARCHAR,
  "unique_entry_id" VARCHAR
);

Dress Up

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.dress_up

56.1 KB
913 rows
22 columns


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

Fencing

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.fencing

8.88 KB
19 rows
11 columns


CREATE TABLE fencing (
  "name" VARCHAR,
  "diy" VARCHAR,
  "stack_size" BIGINT,
  "buy" VARCHAR,
  "sell" BIGINT,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Fish

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.fish

34.01 KB
80 rows
41 columns


CREATE TABLE fish (
  "n" BIGINT,
  "name" VARCHAR,
  "sell" BIGINT,
  "where_how" VARCHAR,
  "shadow" VARCHAR,
  "total_catches_to_unlock" BIGINT,
  "spawn_rates" VARCHAR,
  "rain_snow_catch_up" VARCHAR,
  "nh_jan" VARCHAR,
  "nh_feb" VARCHAR,
  "nh_mar" VARCHAR,
  "nh_apr" VARCHAR,
  "nh_may" VARCHAR,
  "nh_jun" VARCHAR,
  "nh_jul" VARCHAR,
  "nh_aug" VARCHAR,
  "nh_sep" VARCHAR,
  "nh_oct" VARCHAR,
  "nh_nov" VARCHAR,
  "nh_dec" VARCHAR,
  "sh_jan" VARCHAR,
  "sh_feb" VARCHAR,
  "sh_mar" VARCHAR,
  "sh_apr" VARCHAR,
  "sh_may" VARCHAR,
  "sh_jun" VARCHAR,
  "sh_jul" VARCHAR,
  "sh_aug" VARCHAR,
  "sh_sep" VARCHAR,
  "sh_oct" VARCHAR,
  "sh_nov" VARCHAR,
  "sh_dec" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "lighting_type" VARCHAR,
  "icon_filename" VARCHAR,
  "critterpedia_filename" VARCHAR,
  "furniture_filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Floors

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.floors

23.18 KB
176 rows
19 columns


CREATE TABLE floors (
  "name" VARCHAR,
  "vfx" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version" VARCHAR,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "tag" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Fossils

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.fossils

12.66 KB
73 rows
14 columns


CREATE TABLE fossils (
  "name" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "museum" VARCHAR,
  "version" VARCHAR,
  "interact" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Headwear

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.headwear

46.92 KB
698 rows
22 columns


CREATE TABLE headwear (
  "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,
  "type" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Housewares

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.housewares

152.75 KB
3275 rows
32 columns


CREATE TABLE housewares (
  "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" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "miles_price" DOUBLE,
  "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,
  "speaker_type" VARCHAR,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Insects

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.insects

34.37 KB
80 rows
38 columns


CREATE TABLE insects (
  "n" BIGINT,
  "name" VARCHAR,
  "sell" BIGINT,
  "where_how" VARCHAR,
  "weather" VARCHAR,
  "total_catches_to_unlock" BIGINT,
  "spawn_rates" VARCHAR,
  "nh_jan" VARCHAR,
  "nh_feb" VARCHAR,
  "nh_mar" VARCHAR,
  "nh_apr" VARCHAR,
  "nh_may" VARCHAR,
  "nh_jun" VARCHAR,
  "nh_jul" VARCHAR,
  "nh_aug" VARCHAR,
  "nh_sep" VARCHAR,
  "nh_oct" VARCHAR,
  "nh_nov" VARCHAR,
  "nh_dec" VARCHAR,
  "sh_jan" VARCHAR,
  "sh_feb" VARCHAR,
  "sh_mar" VARCHAR,
  "sh_apr" VARCHAR,
  "sh_may" VARCHAR,
  "sh_jun" VARCHAR,
  "sh_jul" VARCHAR,
  "sh_aug" VARCHAR,
  "sh_sep" VARCHAR,
  "sh_oct" VARCHAR,
  "sh_nov" VARCHAR,
  "sh_dec" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "icon_filename" VARCHAR,
  "critterpedia_filename" VARCHAR,
  "furniture_filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Miscellaneous

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.miscellaneous

82.16 KB
1307 rows
31 columns


CREATE TABLE miscellaneous (
  "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" BIGINT,
  "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,
  "speaker_type" VARCHAR,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Music

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.music

13.93 KB
98 rows
13 columns


CREATE TABLE music (
  "name" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Other

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.other

29.25 KB
353 rows
15 columns


CREATE TABLE other (
  "name" VARCHAR,
  "diy" VARCHAR,
  "stack_size" BIGINT,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "tag" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "version" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Photos

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.photos

107.12 KB
3128 rows
20 columns


CREATE TABLE photos (
  "name" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "pattern" VARCHAR,
  "pattern_title" VARCHAR,
  "diy" VARCHAR,
  "customize" VARCHAR,
  "kit_cost" BIGINT,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "version" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Posters

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.posters

28.6 KB
452 rows
13 columns


CREATE TABLE posters (
  "name" VARCHAR,
  "buy" BIGINT,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Reactions

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.reactions

5.36 KB
44 rows
5 columns


CREATE TABLE reactions (
  "name" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "internal_id" VARCHAR,
  "unique_entry_id" VARCHAR
);

Recipes

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.recipes

49.2 KB
595 rows
24 columns


CREATE TABLE recipes (
  "name" VARCHAR,
  "n__1" BIGINT,
  "material_1" VARCHAR,
  "n__2" DOUBLE,
  "material_2" VARCHAR,
  "n__3" DOUBLE,
  "material_3" VARCHAR,
  "n__4" DOUBLE,
  "material_4" VARCHAR,
  "n__5" DOUBLE,
  "material_5" VARCHAR,
  "n__6" DOUBLE,
  "material_6" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "recipes_to_unlock" BIGINT,
  "version" VARCHAR,
  "category" VARCHAR,
  "serial_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Rugs

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.rugs

19.67 KB
132 rows
19 columns


CREATE TABLE rugs (
  "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,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "tag" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Shoes

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.shoes

33.4 KB
454 rows
21 columns


CREATE TABLE shoes (
  "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
);

Socks

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.socks

28.63 KB
350 rows
21 columns


CREATE TABLE socks (
  "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
);

Tools

@kaggle.jessicali9530_animal_crossing_new_horizons_nookplaza_dataset.tools

22.45 KB
200 rows
22 columns


CREATE TABLE tools (
  "name" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "diy" VARCHAR,
  "customize" VARCHAR,
  "kit_cost" DOUBLE,
  "uses" VARCHAR,
  "stack_size" BIGINT,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "set" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);