Baselight
Sign In

New Horizons Catalog | Animal Crossing

The catalog is a feature that appears in all Animal Crossing series games.

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon

Loading...
Loading...

About this Dataset

New Horizons Catalog | Animal Crossing

A comprehensive inventory of ACNH items, villagers, clothing, fish/bugs etc

This dataset comes from this spreadsheet, a comprehensive Item Catalog for Animal Crossing New Horizons (ACNH).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.

About Animal Crossing: New Horizons

Animal Crossing: New Horizons is a 2020 social simulation game developed and published by Nintendo for the Nintendo Switch. It is the fifth main entry in the Animal Crossing series. In New Horizons, the player controls a character who moves to a deserted island after purchasing a getaway package from Tom Nook, accomplishes assigned tasks, and develops the island as they choose. They can gather and craft items, customize the island, and develop it into a community of anthropomorphic animals.
More on Wiki
More on Fandom

Note: Image columns may not be visible in Kaggle sheets.

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.whenamancodes_new_horizons_catalog_animal_horizon.accessories
  • 43.13 kB
  • 280 rows
  • 38 columns
Loading... 
CREATE TABLE accessories (
  "name" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "seasonal_availability" VARCHAR,
  "seasonality" VARCHAR,
  "mannequin_season" VARCHAR,
  "gender" VARCHAR,
  "villager_gender" VARCHAR,
  "style_1" VARCHAR,
  "style_2" VARCHAR,
  "sort_order" VARCHAR,
  "label_themes" VARCHAR,
  "type" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "clothgroup_id" VARCHAR,
  "internal_id" VARCHAR,
  "unique_entry_id" VARCHAR,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37
);

Achievements

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.achievements
  • 53.48 kB
  • 96 rows
  • 35 columns
Loading... 
CREATE TABLE achievements (
  "name" VARCHAR,
  "achievement_description" VARCHAR,
  "achievement_criteria" VARCHAR,
  "n" BIGINT  -- #,
  "internal_id" BIGINT,
  "internal_name" VARCHAR,
  "internal_category" VARCHAR,
  "num_of_tiers" BIGINT,
  "tier_1" BIGINT,
  "tier_2" DOUBLE,
  "tier_3" DOUBLE,
  "tier_4" DOUBLE,
  "tier_5" DOUBLE,
  "tier_6" DOUBLE,
  "tier_1_reward" BIGINT,
  "tier_2_reward" DOUBLE,
  "tier_3_reward" DOUBLE,
  "tier_4_reward" DOUBLE,
  "tier_5_reward" DOUBLE,
  "tier_6_reward" DOUBLE,
  "tier_1_modifier" VARCHAR,
  "tier_1_noun" VARCHAR,
  "tier_2_modifier" VARCHAR,
  "tier_2_noun" VARCHAR,
  "tier_3_modifier" VARCHAR,
  "tier_3_noun" VARCHAR,
  "tier_4_modifier" VARCHAR,
  "tier_4_noun" VARCHAR,
  "tier_5_modifier" VARCHAR,
  "tier_5_noun" VARCHAR,
  "tier_6_modifier" VARCHAR,
  "tier_6_noun" VARCHAR,
  "sequential" VARCHAR,
  "version_added" VARCHAR,
  "unique_entry_id" VARCHAR
);

Artwork

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.artwork
  • 34.31 kB
  • 70 rows
  • 30 columns
Loading... 
CREATE TABLE artwork (
  "name" VARCHAR,
  "image" VARCHAR,
  "high_res_texture" VARCHAR,
  "genuine" VARCHAR,
  "category" VARCHAR,
  "buy" BIGINT,
  "sell" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "real_artwork_title" VARCHAR,
  "artist" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "hha_base_points" BIGINT,
  "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,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Bags

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.bags
  • 35.81 kB
  • 256 rows
  • 32 columns
Loading... 
CREATE TABLE bags (
  "name" VARCHAR,
  "closet_image" VARCHAR,
  "storage_image" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "seasonal_availability" VARCHAR,
  "seasonality" VARCHAR,
  "gender" VARCHAR,
  "style_1" VARCHAR,
  "style_2" VARCHAR,
  "label_themes" VARCHAR,
  "sort_order" BIGINT,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Bottoms

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.bottoms
  • 58.13 kB
  • 761 rows
  • 33 columns
Loading... 
CREATE TABLE bottoms (
  "name" VARCHAR,
  "closet_image" VARCHAR,
  "storage_image" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "seasonal_availability" VARCHAR,
  "seasonality" VARCHAR,
  "mannequin_season" VARCHAR,
  "gender" VARCHAR,
  "style_1" VARCHAR,
  "style_2" VARCHAR,
  "label_themes" VARCHAR,
  "sort_order" BIGINT,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Ceiling Decor

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.ceiling_decor
  • 44.47 kB
  • 419 rows
  • 41 columns
Loading... 
CREATE TABLE ceiling_decor (
  "name" VARCHAR,
  "image" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "pattern" VARCHAR,
  "pattern_title" VARCHAR,
  "diy" VARCHAR,
  "body_customize" VARCHAR,
  "pattern_customize" VARCHAR,
  "pattern_customize_options" VARCHAR,
  "kit_cost" DOUBLE,
  "kit_type" VARCHAR,
  "cyrus_customize_price" BIGINT,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "hha_base_points" BIGINT,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "hha_set" VARCHAR,
  "hha_category" VARCHAR,
  "interact" VARCHAR,
  "tag" VARCHAR,
  "outdoor" VARCHAR,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Clothing Other

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.clothing_other
  • 22.76 kB
  • 9 rows
  • 34 columns
Loading... 
CREATE TABLE clothing_other (
  "name" VARCHAR,
  "closet_image" VARCHAR,
  "storage_image" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "seasonal_availability" VARCHAR,
  "seasonality" VARCHAR,
  "gender" VARCHAR,
  "style_1" VARCHAR,
  "style_2" VARCHAR,
  "label_themes" VARCHAR,
  "sort_order" BIGINT,
  "villager_equippable" VARCHAR,
  "primary_shape" VARCHAR,
  "secondary_shape" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Construction

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.construction
  • 20.02 kB
  • 418 rows
  • 8 columns
Loading... 
CREATE TABLE construction (
  "name" VARCHAR,
  "image" VARCHAR,
  "buy" DOUBLE,
  "category" VARCHAR,
  "source" VARCHAR,
  "filename" VARCHAR,
  "version_added" VARCHAR,
  "unique_entry_id" VARCHAR
);

Dress Up

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.dress_up
  • 80.01 kB
  • 1,060 rows
  • 36 columns
Loading... 
CREATE TABLE dress_up (
  "name" VARCHAR,
  "closet_image" VARCHAR,
  "storage_image" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "seasonal_availability" VARCHAR,
  "seasonality" VARCHAR,
  "mannequin_season" VARCHAR,
  "gender" VARCHAR,
  "villager_gender" VARCHAR,
  "style_1" VARCHAR,
  "style_2" VARCHAR,
  "label_themes" VARCHAR,
  "sort_order" BIGINT,
  "villager_equippable" VARCHAR,
  "primary_shape" VARCHAR,
  "secondary_shape" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Fencing

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.fencing
  • 19.95 kB
  • 99 rows
  • 23 columns
Loading... 
CREATE TABLE fencing (
  "name" VARCHAR,
  "image" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "diy" VARCHAR,
  "customize" VARCHAR,
  "kit_cost" DOUBLE,
  "kit_type" VARCHAR,
  "cyrus_customize_price" DOUBLE,
  "stack_size" BIGINT,
  "buy" VARCHAR,
  "sell" BIGINT,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Fish

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.fish
  • 65.98 kB
  • 80 rows
  • 50 columns
Loading... 
CREATE TABLE fish (
  "n" BIGINT  -- #,
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "critterpedia_image" VARCHAR,
  "furniture_image" VARCHAR,
  "sell" BIGINT,
  "where_how" VARCHAR,
  "shadow" VARCHAR,
  "catch_difficulty" VARCHAR,
  "vision" 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,
  "size" VARCHAR,
  "surface" VARCHAR,
  "description" VARCHAR,
  "catch_phrase" VARCHAR,
  "hha_base_points" BIGINT,
  "hha_category" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "lighting_type" VARCHAR,
  "icon_filename" VARCHAR,
  "critterpedia_filename" VARCHAR,
  "furniture_filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Floors

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.floors
  • 31.6 kB
  • 209 rows
  • 25 columns
Loading... 
CREATE TABLE floors (
  "name" VARCHAR,
  "image" VARCHAR,
  "vfx" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "hha_base_points" BIGINT,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "tag" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Fossils

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.fossils
  • 27.66 kB
  • 73 rows
  • 17 columns
Loading... 
CREATE TABLE fossils (
  "name" VARCHAR,
  "image" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "fossil_group" VARCHAR,
  "description" VARCHAR,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "museum" VARCHAR,
  "interact" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Gyroids

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.gyroids
  • 32.47 kB
  • 189 rows
  • 41 columns
Loading... 
CREATE TABLE gyroids (
  "name" VARCHAR,
  "image" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "pattern" VARCHAR,
  "pattern_title" VARCHAR,
  "diy" VARCHAR,
  "body_customize" VARCHAR,
  "pattern_customize" VARCHAR,
  "kit_cost" DOUBLE,
  "kit_type" VARCHAR,
  "cyrus_customize_price" DOUBLE,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "exchange_price" VARCHAR,
  "exchange_currency" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "hha_base_points" BIGINT,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "hha_set" VARCHAR,
  "hha_category" VARCHAR,
  "interact" VARCHAR,
  "tag" VARCHAR,
  "outdoor" VARCHAR,
  "lighting_type" VARCHAR,
  "sound_type" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Headwear

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.headwear
  • 71.18 kB
  • 889 rows
  • 35 columns
Loading... 
CREATE TABLE headwear (
  "name" VARCHAR,
  "closet_image" VARCHAR,
  "storage_image" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "seasonal_availability" VARCHAR,
  "seasonality" VARCHAR,
  "mannequin_season" VARCHAR,
  "gender" VARCHAR,
  "villager_gender" VARCHAR,
  "style_1" VARCHAR,
  "style_2" VARCHAR,
  "label_themes" VARCHAR,
  "sort_order" BIGINT,
  "type" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Housewares

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.housewares
  • 368.15 kB
  • 8,537 rows
  • 43 columns
Loading... 
CREATE TABLE housewares (
  "name" VARCHAR,
  "image" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "pattern" VARCHAR,
  "pattern_title" VARCHAR,
  "diy" VARCHAR,
  "body_customize" VARCHAR,
  "pattern_customize" VARCHAR,
  "pattern_customize_options" VARCHAR,
  "kit_cost" DOUBLE,
  "kit_type" VARCHAR,
  "cyrus_customize_price" DOUBLE,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "surface" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "hha_base_points" BIGINT,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "hha_set" VARCHAR,
  "hha_category" VARCHAR,
  "interact" VARCHAR,
  "tag" VARCHAR,
  "outdoor" VARCHAR,
  "speaker_type" VARCHAR,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Insects

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.insects
  • 65.99 kB
  • 80 rows
  • 47 columns
Loading... 
CREATE TABLE insects (
  "n" BIGINT  -- #,
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "critterpedia_image" VARCHAR,
  "furniture_image" 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,
  "size" VARCHAR,
  "surface" VARCHAR,
  "description" VARCHAR,
  "catch_phrase" VARCHAR,
  "hha_base_points" BIGINT,
  "hha_category" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "icon_filename" VARCHAR,
  "critterpedia_filename" VARCHAR,
  "furniture_filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Interior Structures

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.interior_structures
  • 28.03 kB
  • 61 rows
  • 41 columns
Loading... 
CREATE TABLE interior_structures (
  "name" VARCHAR,
  "image" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "pattern" VARCHAR,
  "pattern_title" VARCHAR,
  "diy" VARCHAR,
  "body_customize" VARCHAR,
  "pattern_customize" VARCHAR,
  "kit_cost" DOUBLE,
  "kit_type" VARCHAR,
  "cyrus_customize_price" DOUBLE,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "exchange_price" VARCHAR,
  "exchange_currency" VARCHAR,
  "size" VARCHAR,
  "surface" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "hha_base_points" BIGINT,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "hha_set" VARCHAR,
  "hha_category" VARCHAR,
  "interact" VARCHAR,
  "tag" VARCHAR,
  "outdoor" VARCHAR,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Message Cards

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.message_cards
  • 19.22 kB
  • 74 rows
  • 20 columns
Loading... 
CREATE TABLE message_cards (
  "name" VARCHAR,
  "image" VARCHAR,
  "buy" VARCHAR,
  "back_color" VARCHAR,
  "body_color" VARCHAR,
  "head_color" VARCHAR,
  "foot_color" VARCHAR,
  "pen_color_1" VARCHAR,
  "pen_color_2" VARCHAR,
  "pen_color_3" VARCHAR,
  "pen_color_4" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "nh_start_date" VARCHAR,
  "nh_end_date" VARCHAR,
  "sh_start_date" VARCHAR,
  "sh_end_date" VARCHAR,
  "version" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Miscellaneous

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.miscellaneous
  • 180.34 kB
  • 3,183 rows
  • 45 columns
Loading... 
CREATE TABLE miscellaneous (
  "name" VARCHAR,
  "image" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "pattern" VARCHAR,
  "pattern_title" VARCHAR,
  "diy" VARCHAR,
  "body_customize" VARCHAR,
  "pattern_customize" VARCHAR,
  "pattern_customize_options" VARCHAR,
  "stack_size" BIGINT,
  "kit_cost" DOUBLE,
  "kit_type" VARCHAR,
  "cyrus_customize_price" DOUBLE,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "surface" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "hha_base_points" BIGINT,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "hha_set" VARCHAR,
  "hha_category" VARCHAR,
  "interact" VARCHAR,
  "tag" VARCHAR,
  "outdoor" VARCHAR,
  "speaker_type" VARCHAR,
  "lighting_type" VARCHAR,
  "food_power" DOUBLE,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Music

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.music
  • 18.65 kB
  • 110 rows
  • 19 columns
Loading... 
CREATE TABLE music (
  "name" VARCHAR,
  "framed_image" VARCHAR,
  "album_image" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Other

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.other
  • 44.79 kB
  • 410 rows
  • 24 columns
Loading... 
CREATE TABLE other (
  "name" VARCHAR,
  "inventory_image" VARCHAR,
  "storage_image" VARCHAR,
  "diy" VARCHAR,
  "stack_size" BIGINT,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "hha_base_points" BIGINT,
  "tag" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "food_power" DOUBLE,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "inventory_filename" VARCHAR,
  "storage_filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Paradise Planning

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.paradise_planning
  • 60.22 kB
  • 413 rows
  • 8 columns
Loading... 
CREATE TABLE paradise_planning (
  "name" VARCHAR,
  "filename" VARCHAR,
  "request" VARCHAR,
  "thought_bubble" VARCHAR,
  "song" VARCHAR,
  "furniture_list" VARCHAR,
  "furniture_name_list" VARCHAR,
  "unique_entry_id" VARCHAR
);

Photos

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.photos
  • 137.98 kB
  • 3,800 rows
  • 30 columns
Loading... 
CREATE TABLE photos (
  "name" VARCHAR,
  "image" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "pattern" VARCHAR,
  "pattern_title" VARCHAR,
  "diy" VARCHAR,
  "customize" VARCHAR,
  "kit_cost" BIGINT,
  "cyrus_customize_price" BIGINT,
  "buy" VARCHAR,
  "sell" BIGINT,
  "hha_base_points" BIGINT,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Posters

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.posters
  • 33.77 kB
  • 483 rows
  • 18 columns
Loading... 
CREATE TABLE posters (
  "name" VARCHAR,
  "image" VARCHAR,
  "buy" BIGINT,
  "sell" BIGINT,
  "hha_base_points" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR  -- Unlocked?,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Share link

Anyone who has the link will be able to view this.