Dataset: New Horizons Catalog | Animal Crossing

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

42.12 KB
280 rows
38 columns


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,
  "filename" VARCHAR,
  "clothgroup_id" VARCHAR,
  "internal_id" VARCHAR,
  "unique_entry_id" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR
);

Achievements

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.achievements

52.23 KB
96 rows
35 columns


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

33.5 KB
70 rows
30 columns


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,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Bags

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.bags

34.97 KB
256 rows
32 columns


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,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Bottoms

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.bottoms

56.77 KB
761 rows
33 columns


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,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Ceiling Decor

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.ceiling_decor

43.43 KB
419 rows
41 columns


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,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Clothing Other

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.clothing_other

22.22 KB
9 rows
34 columns


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,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Construction

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.construction

19.55 KB
418 rows
8 columns


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

78.13 KB
1060 rows
36 columns


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,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Fencing

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.fencing

19.49 KB
99 rows
23 columns


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,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Fish

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.fish

64.44 KB
80 rows
50 columns


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

30.86 KB
209 rows
25 columns


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,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Fossils

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.fossils

27.01 KB
73 rows
17 columns


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

31.71 KB
189 rows
41 columns


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,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Headwear

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.headwear

69.51 KB
889 rows
35 columns


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,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Housewares

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.housewares

359.52 KB
8537 rows
43 columns


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,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Insects

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.insects

64.44 KB
80 rows
47 columns


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

27.38 KB
61 rows
41 columns


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,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Message Cards

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.message_cards

18.77 KB
74 rows
20 columns


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

176.11 KB
3183 rows
45 columns


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,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Music

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.music

18.21 KB
110 rows
19 columns


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,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Other

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.other

43.74 KB
410 rows
24 columns


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,
  "inventory_filename" VARCHAR,
  "storage_filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Paradise Planning

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.paradise_planning

58.8 KB
413 rows
8 columns


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

134.74 KB
3800 rows
30 columns


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,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Posters

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.posters

32.98 KB
483 rows
18 columns


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,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Reactions

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.reactions

12.82 KB
88 rows
11 columns


CREATE TABLE reactions (
  "n" BIGINT,
  "name" VARCHAR,
  "image" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "version_added" VARCHAR,
  "icon_filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Recipes

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.recipes

91.66 KB
924 rows
34 columns


CREATE TABLE recipes (
  "name" VARCHAR,
  "image" VARCHAR,
  "image_sh" 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" DOUBLE,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR,
  "recipes_to_unlock" BIGINT,
  "category" VARCHAR,
  "crafted_item_internal_id" BIGINT,
  "card_color" VARCHAR,
  "diy_icon_filename" VARCHAR,
  "diy_icon_filename_sh" VARCHAR,
  "serial_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Rugs

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.rugs

30.41 KB
209 rows
26 columns


CREATE TABLE rugs (
  "name" VARCHAR,
  "image" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" BIGINT,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "size_category" 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,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Sea Creatures

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.sea_creatures

53.48 KB
40 rows
50 columns


CREATE TABLE sea_creatures (
  "n" BIGINT,
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "critterpedia_image" VARCHAR,
  "furniture_image" VARCHAR,
  "sell" BIGINT,
  "shadow" VARCHAR,
  "movement_speed" 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,
  "version_added" VARCHAR,
  "unlocked" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Seasons And Events

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.seasons_and_events

203.86 KB
128 rows
134 columns


CREATE TABLE seasons_and_events (
  "name" VARCHAR,
  "type" VARCHAR,
  "display_name" VARCHAR,
  "n_2022_nh" VARCHAR,
  "n_2022_sh" VARCHAR,
  "n_2023_nh" VARCHAR,
  "n_2023_sh" VARCHAR,
  "n_2024_nh" VARCHAR,
  "n_2024_sh" VARCHAR,
  "sort_date" VARCHAR,
  "date_varies_by_year" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "next_day_overlap" VARCHAR,
  "version_added" VARCHAR,
  "version_last_updated" VARCHAR,
  "internal_label" VARCHAR,
  "unique_entry_id" VARCHAR,
  "n_2000_nh" VARCHAR,
  "n_2000_sh" VARCHAR,
  "n_2001_nh" VARCHAR,
  "n_2001_sh" VARCHAR,
  "n_2002_nh" VARCHAR,
  "n_2002_sh" VARCHAR,
  "n_2003_nh" VARCHAR,
  "n_2003_sh" VARCHAR,
  "n_2004_nh" VARCHAR,
  "n_2004_sh" VARCHAR,
  "n_2005_nh" VARCHAR,
  "n_2005_sh" VARCHAR,
  "n_2006_nh" VARCHAR,
  "n_2006_sh" VARCHAR,
  "n_2007_nh" VARCHAR,
  "n_2007_sh" VARCHAR,
  "n_2008_nh" VARCHAR,
  "n_2008_sh" VARCHAR,
  "n_2009_nh" VARCHAR,
  "n_2009_sh" VARCHAR,
  "n_2010_nh" VARCHAR,
  "n_2010_sh" VARCHAR,
  "n_2011_nh" VARCHAR,
  "n_2011_sh" VARCHAR,
  "n_2012_nh" VARCHAR,
  "n_2012_sh" VARCHAR,
  "n_2013_nh" VARCHAR,
  "n_2013_sh" VARCHAR,
  "n_2014_nh" VARCHAR,
  "n_2014_sh" VARCHAR,
  "n_2015_nh" VARCHAR,
  "n_2015_sh" VARCHAR,
  "n_2016_nh" VARCHAR,
  "n_2016_sh" VARCHAR,
  "n_2017_nh" VARCHAR,
  "n_2017_sh" VARCHAR,
  "n_2018_nh" VARCHAR,
  "n_2018_sh" VARCHAR,
  "n_2019_nh" VARCHAR,
  "n_2019_sh" VARCHAR,
  "n_2020_nh" VARCHAR,
  "n_2020_sh" VARCHAR,
  "n_2021_nh" VARCHAR,
  "n_2021_sh" VARCHAR,
  "n_2025_nh" VARCHAR,
  "n_2025_sh" VARCHAR,
  "n_2026_nh" VARCHAR,
  "n_2026_sh" VARCHAR,
  "n_2027_nh" VARCHAR,
  "n_2027_sh" VARCHAR,
  "n_2028_nh" VARCHAR,
  "n_2028_sh" VARCHAR,
  "n_2029_nh" VARCHAR,
  "n_2029_sh" VARCHAR,
  "n_2030_nh" VARCHAR,
  "n_2030_sh" VARCHAR,
  "n_2031_nh" VARCHAR,
  "n_2031_sh" VARCHAR,
  "n_2032_nh" VARCHAR,
  "n_2032_sh" VARCHAR,
  "n_2033_nh" VARCHAR,
  "n_2033_sh" VARCHAR,
  "n_2034_nh" VARCHAR,
  "n_2034_sh" VARCHAR,
  "n_2035_nh" VARCHAR,
  "n_2035_sh" VARCHAR,
  "n_2036_nh" VARCHAR,
  "n_2036_sh" VARCHAR,
  "n_2037_nh" VARCHAR,
  "n_2037_sh" VARCHAR,
  "n_2038_nh" VARCHAR,
  "n_2038_sh" VARCHAR,
  "n_2039_nh" VARCHAR,
  "n_2039_sh" VARCHAR,
  "n_2040_nh" VARCHAR,
  "n_2040_sh" VARCHAR,
  "n_2041_nh" VARCHAR,
  "n_2041_sh" VARCHAR,
  "n_2042_nh" VARCHAR,
  "n_2042_sh" VARCHAR,
  "n_2043_nh" VARCHAR,
  "n_2043_sh" VARCHAR
);

Shoes

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.shoes

45.91 KB
503 rows
33 columns


CREATE TABLE shoes (
  "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,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Socks

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.socks

38.66 KB
364 rows
33 columns


CREATE TABLE socks (
  "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,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Special Npcs

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.special_npcs

16.45 KB
65 rows
17 columns


CREATE TABLE special_npcs (
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "photo_image" VARCHAR,
  "gender" VARCHAR,
  "gender_asia" VARCHAR,
  "hobby" VARCHAR,
  "birthday" VARCHAR,
  "umbrella" VARCHAR,
  "umbrella_hhp" VARCHAR,
  "name_color" VARCHAR,
  "bubble_color" VARCHAR,
  "version_added" VARCHAR,
  "icon_filename" VARCHAR,
  "photo_filename" VARCHAR,
  "npc_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Tools Goods

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.tools_goods

39.61 KB
314 rows
36 columns


CREATE TABLE tools_goods (
  "name" VARCHAR,
  "image" VARCHAR,
  "variation" VARCHAR,
  "body_title" VARCHAR,
  "diy" VARCHAR,
  "customize" VARCHAR,
  "kit_cost" DOUBLE,
  "kit_type" VARCHAR,
  "cyrus_customize_price" DOUBLE,
  "uses" VARCHAR,
  "stack_size" BIGINT,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "hha_base_points" BIGINT,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "set" VARCHAR,
  "exchange_price" DOUBLE,
  "exchange_currency" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "season_event" VARCHAR,
  "season_event_exclusive" VARCHAR,
  "villager_equippable" VARCHAR,
  "food_power" DOUBLE,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Tops

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.tops

87.92 KB
1310 rows
34 columns


CREATE TABLE tops (
  "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,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR,
  "filename" VARCHAR,
  "clothgroup_id" BIGINT,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Umbrellas

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.umbrellas

19.75 KB
68 rows
24 columns


CREATE TABLE umbrellas (
  "name" VARCHAR,
  "storage_image" 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,
  "gender" VARCHAR,
  "villager_gender" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Villagers

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.villagers

107.26 KB
413 rows
30 columns


CREATE TABLE villagers (
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "photo_image" VARCHAR,
  "house_image" VARCHAR,
  "species" VARCHAR,
  "gender" VARCHAR,
  "personality" VARCHAR,
  "subtype" VARCHAR,
  "hobby" VARCHAR,
  "birthday" VARCHAR,
  "catchphrase" VARCHAR,
  "favorite_song" VARCHAR,
  "favorite_saying" VARCHAR,
  "style_1" VARCHAR,
  "style_2" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "default_clothing" BIGINT,
  "default_umbrella" VARCHAR,
  "wallpaper" VARCHAR,
  "flooring" VARCHAR,
  "furniture_list" VARCHAR,
  "furniture_name_list" VARCHAR,
  "diy_workbench" VARCHAR,
  "kitchen_equipment" VARCHAR,
  "version_added" VARCHAR,
  "name_color" VARCHAR,
  "bubble_color" VARCHAR,
  "filename" VARCHAR,
  "unique_entry_id" VARCHAR
);

Wall Mounted

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.wall_mounted

65.04 KB
731 rows
42 columns


CREATE TABLE wall_mounted (
  "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,
  "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,
  "door_deco" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "unlocked" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);

Wallpaper

@kaggle.whenamancodes_new_horizons_catalog_animal_horizon.wallpaper

42.1 KB
306 rows
32 columns


CREATE TABLE wallpaper (
  "name" VARCHAR,
  "image" VARCHAR,
  "vfx" VARCHAR,
  "vfx_type" 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,
  "window_type" VARCHAR,
  "window_color" VARCHAR,
  "pane_type" VARCHAR,
  "curtain_type" VARCHAR,
  "curtain_color" VARCHAR,
  "ceiling_type" 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,
  "filename" VARCHAR,
  "internal_id" BIGINT,
  "unique_entry_id" VARCHAR
);