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

39.15 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.57 KB
63 rows
10 columns


CREATE TABLE special_npcs (
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "photo_image" VARCHAR,
  "gender" VARCHAR,
  "gender_asia" VARCHAR,
  "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

26.73 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

92.4 KB
1124 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.25 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

109.73 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

50.79 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

37.84 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
);