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

About this Dataset

Animal Crossing: New Horizons

Context

For Animal Crossing New Horizons fans. Learn all aspects of villagers, fish, insects, cloths, ... in this game.

Content

Let's explore Animal Crossing items together.

Acknowledgements

All 33 csv files were converted from Google Sheets (https://docs.google.com/spreadsheets/d/13d_LAJPlxMa_DubPTuirkIV4DERBMXbrWQsmSh8ReK4/edit#gid=1811573791). All original columns and image URLs from the spreadsheet are included. Thanks to those contributors who painstakingly collect and share this precious data.

Inspiration

Your data will be in front of the world's largest data science community. What questions do you want to see answered?

Tables

Socks

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.socks

40.09 kB
350 rows
27 columns

CREATE TABLE socks (
  "name" VARCHAR,
  "closet_image" VARCHAR,
  "storage_image" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "hha_base_points" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "seasonal_availability" VARCHAR,
  "mannequin_piece" VARCHAR,
  "style" VARCHAR,
  "label_themes" VARCHAR,
  "sort_order" DOUBLE,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "clothgroup_id" DOUBLE,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Special Npcs

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.special_npcs

10.82 kB
63 rows
10 columns

CREATE TABLE special_npcs (
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "photo_image" VARCHAR,
  "gender" VARCHAR,
  "gender_asia" VARCHAR  -- Gender (Asia),
  "version_added" VARCHAR,
  "npc_id" VARCHAR,
  "internal_id" DOUBLE,
  "birthday" VARCHAR,
  "unique_entry_id" VARCHAR
);

Tools

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.tools

27.37 kB
201 rows
25 columns

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

Tops

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.tops

94.62 kB
1,124 rows
27 columns

CREATE TABLE tops (
  "name" VARCHAR,
  "closet_image" VARCHAR,
  "storage_image" VARCHAR,
  "variation" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "hha_base_points" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "seasonal_availability" VARCHAR,
  "mannequin_piece" VARCHAR,
  "style" VARCHAR,
  "label_themes" VARCHAR,
  "sort_order" DOUBLE,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "clothgroup_id" DOUBLE,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Umbrellas

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.umbrellas

19.71 kB
67 rows
20 columns

CREATE TABLE umbrellas (
  "name" VARCHAR,
  "closet_image" VARCHAR,
  "storage_image" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "hha_base_points" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Villagers

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.villagers

112.36 kB
391 rows
24 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" DOUBLE,
  "wallpaper" VARCHAR,
  "flooring" VARCHAR,
  "furniture_list" VARCHAR,
  "furniture_name_list" VARCHAR,
  "filename" VARCHAR,
  "unique_entry_id" VARCHAR
);

Wall Mounted

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.wall_mounted

52.01 kB
459 rows
35 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,
  "kit_cost" DOUBLE,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "hha_base_points" DOUBLE,
  "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,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Wallpaper

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.wallpaper

38.75 kB
249 rows
29 columns

CREATE TABLE wallpaper (
  "name" VARCHAR,
  "image" 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,
  "window_type" VARCHAR,
  "window_color" VARCHAR,
  "pane_type" VARCHAR,
  "curtain_type" VARCHAR,
  "curtain_color" VARCHAR,
  "ceiling_type" VARCHAR,
  "hha_base_points" DOUBLE,
  "hha_concept_1" VARCHAR,
  "hha_concept_2" VARCHAR,
  "hha_series" VARCHAR,
  "tag" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);