Baselight
Sign In

Animal Crossing: New Horizons

detailed catalog with all image URLs (villagers, fish, insects, tools, etc.)

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url

Loading...
Loading...

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

Accessories

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.accessories
  • 35.5 KB
  • 231 rows
  • 28 columns
Loading... 

CREATE TABLE accessories (
  "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,
  "sort_order" DOUBLE,
  "label_themes" VARCHAR,
  "type" VARCHAR,
  "villager_equippable" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "clothgroup_id" DOUBLE,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Achievements

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.achievements
  • 49.54 KB
  • 87 rows
  • 35 columns
Loading... 

CREATE TABLE achievements (
  "name" VARCHAR,
  "achievement_description" VARCHAR,
  "achievement_criteria" VARCHAR,
  "n" DOUBLE,
  "internal_id" DOUBLE,
  "internal_name" VARCHAR,
  "internal_category" VARCHAR,
  "num_of_tiers" DOUBLE,
  "tier_1" DOUBLE,
  "tier_2" DOUBLE,
  "tier_3" DOUBLE,
  "tier_4" DOUBLE,
  "tier_5" DOUBLE,
  "tier_6" DOUBLE,
  "tier_1_reward" DOUBLE,
  "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
);

Art

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.art
  • 34.57 KB
  • 70 rows
  • 30 columns
Loading... 

CREATE TABLE art (
  "name" VARCHAR,
  "image" VARCHAR,
  "high_res_texture" VARCHAR,
  "genuine" VARCHAR,
  "category" VARCHAR,
  "buy" DOUBLE,
  "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" DOUBLE,
  "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,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Bags

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.bags
  • 25.51 KB
  • 96 rows
  • 26 columns
Loading... 

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

Bottoms

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.bottoms
  • 62.64 KB
  • 727 rows
  • 26 columns
Loading... 

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

Clothing Other

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.clothing_other
  • 20.47 KB
  • 9 rows
  • 29 columns
Loading... 

CREATE TABLE clothing_other (
  "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,
  "primary_shape" VARCHAR,
  "secondary_shape" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "clothgroup_id" DOUBLE,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Construction

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.construction
  • 16.39 KB
  • 236 rows
  • 7 columns
Loading... 

CREATE TABLE construction (
  "name" VARCHAR,
  "image" VARCHAR,
  "buy" DOUBLE,
  "category" VARCHAR,
  "source" VARCHAR,
  "filename" VARCHAR,
  "unique_entry_id" VARCHAR
);

Dress Up

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.dress_up
  • 82.24 KB
  • 924 rows
  • 28 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" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "seasonal_availability" VARCHAR,
  "mannequin_piece" VARCHAR,
  "style" VARCHAR,
  "label_themes" VARCHAR,
  "sort_order" DOUBLE,
  "villager_equippable" VARCHAR,
  "primary_shape" VARCHAR,
  "secondary_shape" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "clothgroup_id" DOUBLE,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Fencing

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.fencing
  • 10.74 KB
  • 19 rows
  • 13 columns
Loading... 

CREATE TABLE fencing (
  "name" VARCHAR,
  "image" VARCHAR,
  "diy" VARCHAR,
  "stack_size" DOUBLE,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Fish

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.fish
  • 68.23 KB
  • 80 rows
  • 50 columns
Loading... 

CREATE TABLE fish (
  "n__id" DOUBLE,
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "critterpedia_image" VARCHAR,
  "furniture_image" VARCHAR,
  "sell" DOUBLE,
  "where_how" VARCHAR,
  "shadow" VARCHAR,
  "catch_difficulty" VARCHAR,
  "vision" VARCHAR,
  "total_catches_to_unlock" DOUBLE,
  "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" DOUBLE,
  "hha_category" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "lighting_type" VARCHAR,
  "icon_filename" VARCHAR,
  "critterpedia_filename" VARCHAR,
  "furniture_filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Floors

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.floors
  • 28.07 KB
  • 178 rows
  • 22 columns
Loading... 

CREATE TABLE floors (
  "name" VARCHAR,
  "image" VARCHAR,
  "vfx" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" 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
);

Fossils

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.fossils
  • 27.04 KB
  • 73 rows
  • 16 columns
Loading... 

CREATE TABLE fossils (
  "name" VARCHAR,
  "image" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "description" VARCHAR,
  "hha_base_points" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "museum" VARCHAR,
  "interact" VARCHAR,
  "catalog" VARCHAR,
  "filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Headwear

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.headwear
  • 66.28 KB
  • 704 rows
  • 28 columns
Loading... 

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

Housewares

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.housewares
  • 186.7 KB
  • 3291 rows
  • 37 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,
  "kit_cost" DOUBLE,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "surface" VARCHAR,
  "miles_price" DOUBLE,
  "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,
  "speaker_type" VARCHAR,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Insects

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.insects
  • 68.6 KB
  • 80 rows
  • 47 columns
Loading... 

CREATE TABLE insects (
  "n__id" DOUBLE,
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "critterpedia_image" VARCHAR,
  "furniture_image" VARCHAR,
  "sell" DOUBLE,
  "where_how" VARCHAR,
  "weather" VARCHAR,
  "total_catches_to_unlock" DOUBLE,
  "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" DOUBLE,
  "hha_category" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "icon_filename" VARCHAR,
  "critterpedia_filename" VARCHAR,
  "furniture_filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Miscellaneous

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.miscellaneous
  • 99 KB
  • 1307 rows
  • 36 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,
  "kit_cost" DOUBLE,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "surface" 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,
  "speaker_type" VARCHAR,
  "lighting_type" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Music

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.music
  • 19.23 KB
  • 98 rows
  • 17 columns
Loading... 

CREATE TABLE music (
  "name" VARCHAR,
  "framed_image" VARCHAR,
  "album_image" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "hha_base_points" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Other

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.other
  • 38.77 KB
  • 355 rows
  • 19 columns
Loading... 

CREATE TABLE other (
  "name" VARCHAR,
  "inventory_image" VARCHAR,
  "storage_image" VARCHAR,
  "diy" VARCHAR,
  "stack_size" DOUBLE,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "hha_base_points" DOUBLE,
  "tag" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Photos

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.photos
  • 133.94 KB
  • 3128 rows
  • 23 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" DOUBLE,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "hha_base_points" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "variant_id" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Posters

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.posters
  • 34.17 KB
  • 452 rows
  • 16 columns
Loading... 

CREATE TABLE posters (
  "name" VARCHAR,
  "image" VARCHAR,
  "buy" DOUBLE,
  "sell" DOUBLE,
  "hha_base_points" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "catalog" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "filename" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Reactions

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.reactions
  • 7.32 KB
  • 44 rows
  • 6 columns
Loading... 

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

Recipes

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.recipes
  • 65.48 KB
  • 609 rows
  • 28 columns
Loading... 

CREATE TABLE recipes (
  "name" VARCHAR,
  "image" VARCHAR,
  "n__1" DOUBLE,
  "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,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "recipes_to_unlock" DOUBLE,
  "category" VARCHAR,
  "crafted_item_internal_id" DOUBLE,
  "card_color" VARCHAR,
  "serial_id" DOUBLE,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Rugs

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.rugs
  • 24.58 KB
  • 134 rows
  • 23 columns
Loading... 

CREATE TABLE rugs (
  "name" VARCHAR,
  "image" VARCHAR,
  "diy" VARCHAR,
  "buy" VARCHAR,
  "sell" DOUBLE,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "size" VARCHAR,
  "size_category" VARCHAR,
  "miles_price" DOUBLE,
  "source" VARCHAR,
  "source_notes" 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
);

Sea Creatures

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.sea_creatures
  • 56.5 KB
  • 40 rows
  • 50 columns
Loading... 

CREATE TABLE sea_creatures (
  "n__id" DOUBLE,
  "name" VARCHAR,
  "icon_image" VARCHAR,
  "critterpedia_image" VARCHAR,
  "furniture_image" VARCHAR,
  "sell" DOUBLE,
  "shadow" VARCHAR,
  "movement_speed" VARCHAR,
  "total_catches_to_unlock" DOUBLE,
  "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" DOUBLE,
  "hha_category" VARCHAR,
  "color_1" VARCHAR,
  "color_2" VARCHAR,
  "lighting_type" VARCHAR,
  "icon_filename" VARCHAR,
  "critterpedia_filename" VARCHAR,
  "furniture_filename" VARCHAR,
  "version_added" VARCHAR,
  "version_unlocked" VARCHAR,
  "internal_id" DOUBLE,
  "unique_entry_id" VARCHAR
);

Shoes

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.shoes
  • 46.76 KB
  • 457 rows
  • 27 columns
Loading... 

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

Socks

@kaggle.prasertk_animal_crossing_new_horizons_with_image_url.socks
  • 39.15 KB
  • 350 rows
  • 27 columns
Loading... 

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
Loading... 

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
Loading... 

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
Loading... 

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
Loading... 

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
Loading... 

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
Loading... 

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
Loading... 

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

Share link

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