Status
|
API [nb 1]
|
Table Name
|
Description
|
Structure
|
Notes
|
|
|
cf_villager
|
City Folk villagers
|
Open to view 7 fields
|
name - String
name_sort - String
favclothing - String
leastfavclothing - String
favgenre - String
favseries - String
favcolor - String
|
|
-
|
|
|
nh_art
|
New Horizons art
|
Open to view 16 fields
|
name - String
image - String
fake - Boolean
fake_image - String
art_name - String
author - String
year - String
art_style - String
description - Text
buy_price - Integer
sell_price - Integer
availability - String
availability_note - String
authenticity - String
width - Float
length - Float
|
|
-
|
|
|
nh_bug
|
New Horizons bugs
|
Open to view 41 fields
|
url - String
name - String
number - Integer
image - String
image_url - String
catchphrase - String
catchphrase2 - String
n_availability - String
n_m1 - Boolean
n_m2 - Boolean
n_m3 - Boolean
n_m4 - Boolean
n_m5 - Boolean
n_m6 - Boolean
n_m7 - Boolean
n_m8 - Boolean
n_m9 - Boolean
n_m10 - Boolean
n_m11 - Boolean
n_m12 - Boolean
s_availability - String
s_m1 - Boolean
s_m2 - Boolean
s_m3 - Boolean
s_m4 - Boolean
s_m5 - Boolean
s_m6 - Boolean
s_m7 - Boolean
s_m8 - Boolean
s_m9 - Boolean
s_m10 - Boolean
s_m11 - Boolean
s_m12 - Boolean
time - String
location - String
rarity - String
total_catch - Integer
sell_nook - Integer
sell_flick - Integer
tank_width - Float
tank_length - Float
|
|
Missing rarity data (common name for rarity percentages TBD).
|
|
|
nh_clothing
|
New Horizons clothing
|
Open to view 26 fields
|
identifier - String
en_name - String
category - String
category_sort - Integer
style1 - String
style2 - String
label1 - String
label2 - String
label3 - String
label4 - String
label5 - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
vill_equip - Boolean
version_added - String
unlocked - Boolean
notes - String
|
|
-
|
|
|
nh_clothing_variation
|
New Horizons clothing variations
|
Open to view 6 fields
|
identifier - String
en_name - String
variation - String
image - String
color1 - String
color2 - String
|
|
-
|
|
|
nh_fish
|
New Horizons fish
|
Open to view 48 fields
|
url - String
name - String
number - Integer
image - String
image_url - String
catchphrase - String
catchphrase2 - String
catchphrase3 - String
n_availability - String
n_m1 - Boolean
n_m2 - Boolean
n_m3 - Boolean
n_m4 - Boolean
n_m5 - Boolean
n_m6 - Boolean
n_m7 - Boolean
n_m8 - Boolean
n_m9 - Boolean
n_m10 - Boolean
n_m11 - Boolean
n_m12 - Boolean
s_availability - String
s_m1 - Boolean
s_m2 - Boolean
s_m3 - Boolean
s_m4 - Boolean
s_m5 - Boolean
s_m6 - Boolean
s_m7 - Boolean
s_m8 - Boolean
s_m9 - Boolean
s_m10 - Boolean
s_m11 - Boolean
s_m12 - Boolean
time - String
time_n_availability - String
time_s_availability - String
time2 - String
time2_n_availability - String
time2_s_availability - String
location - String
shadow_size - String
rarity - String
total_catch - Integer
sell_nook - Integer
sell_cj - Integer
tank_width - Float
tank_length - Float
|
|
Missing rarity data (common name for rarity percentages TBD).
|
|
|
nh_furniture
|
New Horizons furniture
|
Open to view 41 fields
|
identifier - String
en_name - String
category - String
category_sort - Integer
item_series - String
item_set - String
theme1 - String
theme2 - String
tag - String
hha_base - Integer
function1 - String
function2 - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
customizable - Boolean
custom_kits - Integer
custom_body_part - String
custom_pattern_part - String
grid_size - String
length - Float
width - Float
height - Float
outdoor - Boolean
interactable - Boolean
animated - Boolean
sound - Boolean
music - Boolean
lighting - Boolean
door_decor - Boolean
version_added - String
unlocked - Boolean
notes - String
|
|
-
|
|
|
nh_furniture_variation
|
New Horizons furniture variations
|
Open to view 7 fields
|
identifier - String
en_name - String
variation - String
pattern - String
image - String
color1 - String
color2 - String
|
|
-
|
|
|
nh_house
|
New Horizons villager homes (some parts used in villager endpoint)
|
Open to view 15 fields
|
villager - String
interior_image - String
interior_image_url - String
exterior_image - String
exterior_image_url - String
wallpaper - String
wallpaper_image - String
wallpaper_image_url - String
flooring - String
flooring_image - String
flooring_image_url - String
music - String
music_note - String
items - Text
notes - Wikitext string
|
|
-
|
|
|
nh_interior
|
New Horizons wallpaper and flooring
|
Open to view 25 fields
|
identifier - String
en_name - String
image - String
category - String
item_series - String
theme1 - String
theme2 - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
grid_size - String
vfx - Boolean
color1 - String
color2 - String
version_added - String
unlocked - Boolean
notes - String
|
|
-
|
|
|
nh_language_name
|
New Horizons furniture translations
|
Open to view 15 fields
|
identifier - String
en_name - String
de_name - String
es_name - String
esl_name - String
fr_name - String
frq_name - String
it_name - String
ja_name - String
ko_name - String
nl_name - String
ru_name - String
zh_name - String
zht_name - String
notes - String
|
|
-
|
|
|
nh_music
|
New Horizons KK records
|
Open to view 23 fields
|
identifier - String
en_name - String
image - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
grid_size - String
length - Float
width - Float
height - Float
color1 - String
color2 - String
version_added - String
unlocked - Boolean
notes - String
|
|
-
|
|
|
nh_photo
|
New Horizons villager photos and posters
|
Open to view 25 fields
|
identifier - String
en_name - String
category - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
customizable - Boolean
custom_kits - Integer
custom_body_part - String
grid_size - String
length - Float
width - Float
height - Float
interactable - Boolean
version_added - String
unlocked - Boolean
notes - String
|
|
-
|
|
|
nh_photo_variation
|
New Horizons villager photo customization
|
Open to view 6 fields
|
identifier - String
en_name - String
variation - String
image - String
color1 - String
color2 - String
|
|
-
|
|
|
nh_recipe
|
New Horizons DIY recipes
|
Open to view 30 fields
|
identifier - String
en_name - String
image - String
serial_id - Integer
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Int
recipes_to_unlock - Int
diy_availability1 - String
diy_availability1_note - String
diy_availability2 - String
diy_availability2_note - String
materials - String
material1 - String
material1_num - Integer
material2 - String
material2_num - Integer
material3 - String
material3_num - Integer
material4 - String
material4_num - Integer
material5 - String
material5_num - Integer
material6 - String
material6_num - Integer
notes - String
|
|
-
|
|
|
nh_sea_creature
|
New Horizons sea creatures
|
Open to view 41 fields
|
url - String
name - String
number - Integer
image - String
image_url - String
catchphrase - String
catchphrase2 - String
n_availability - String
n_m1 - Boolean
n_m2 - Boolean
n_m3 - Boolean
n_m4 - Boolean
n_m5 - Boolean
n_m6 - Boolean
n_m7 - Boolean
n_m8 - Boolean
n_m9 - Boolean
n_m10 - Boolean
n_m11 - Boolean
n_m12 - Boolean
s_availability - String
s_m1 - Boolean
s_m2 - Boolean
s_m3 - Boolean
s_m4 - Boolean
s_m5 - Boolean
s_m6 - Boolean
s_m7 - Boolean
s_m8 - Boolean
s_m9 - Boolean
s_m10 - Boolean
s_m11 - Boolean
s_m12 - Boolean
time - String
shadow_size - String
shadow_movement - String
rarity - String
total_catch - Integer
sell_nook - Integer
tank_width - Float
tank_length - Float
|
|
Missing rarity data (common name for rarity percentages TBD).
|
|
|
nh_tool
|
New Horizons handheld items
|
Open to view 24 fields
|
identifier - String
en_name - String
item_set - Integer
uses - String
hha_base - Integer
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
availability3 - String
availability3_note - String
customizable - Boolean
custom_kits - Integer
custom_body_part - String
version_added - String
unlocked - Boolean
notes - String
|
|
-
|
|
|
nh_tool_variation
|
New Horizons handheld item variations
|
Open to view 6 fields
|
identifier - String
en_name - String
variation - String
image - String
color1 - String
color2 - String
|
|
-
|
|
|
nh_villager
|
New Horizons villagers (using in villager endpoint)
|
Open to view 25 fields
|
url - String
name - String
image - String
image_url - String
photo - String
photo_url - String
icon - String
icon_url - String
quote - String
species - String
gender - String
personality - String
sub_personality - String
birthday - String
birthday_sort - Integer
sign - String
catchphrase - String
clothing - String
clothing_variation - String
new - Boolean
fav_style1 - String
fav_style2 - String
fav_color1 - String
fav_color2 - String
hobby - String
|
|
-
|
|
|
nl_villager
|
New Leaf villager preferences
|
Open to view 14 fields
|
name - String
name_sort - String
pic - String
quote - String
siblings - String
skill - String
goal - String
fear - String
favclothing - String
leastfavclothing - String
favcolor - String
coffeetype - String
milk - String
sugar - String
|
|
-
|
|
|
pc_villager
|
Pocket Camp villager info and rewards
|
Columns need renaming to match standard
Open to view 18 fields
|
name - String
name_sort - String
image - String
theme - String
material - String
description - Text
friendshipLevel - Integer
unlockmode - String
furniture1 - String
furniture2 - String
furniture3 - String
furniture4 - String
furniture5 - String
friendReward1 - String
friendReward3 - String
friendRewardLvl1 - Integer
friendRewardLvl2 - Integer
friendRewardLvl3 - Integer
|
|
-
|
|
|
song
|
KK Song image, audio and Animal Crossing series appearances
|
Open to view 18 fields
|
url - String
name - String
name_sort - String
order_number - Integer
image - String
image_url - String
aircheck - String
aircheck_url - String
live - String
live_url - String
mood - String
dnm - Boolean
ac - Boolean
e_plus - Boolean
ww - Boolean
cf - Boolean
nl - Boolean
nh - Boolean
|
|
-
|
|
|
special_character
|
Special character info and Animal Crossing series appearances
|
Open to view 25 fields
|
url - String
name - String
name_sort - String
alt_name - String
ID - String
image - String
image_url - String
species - String
gender - String
gender_japan - String
birthday - String
birthday_sort - Integer
sign - String
speciespage_debut - String
dnm - Boolean
ac - Boolean
e_plus - Boolean
ww - Boolean
cf - Boolean
nl - Boolean
wa - Boolean
nh - Boolean
film - Boolean
hhd - Boolean
pc - Boolean
|
|
-
|
|
|
villager
|
Animal Crossing series villagers
|
Open to view 37 fields
|
url - String
name - String
name_sort - String
alt_name - String
titlecolor - String
textcolor - String
id - String
image - String
image_url - String
species - String
personality - String
prev_personality - String
gender - String
birthday - String
birthday_month - String
birthday_day - Integer
birthday_sort - Integer
sign - String
quote - String
phrase - String
prev_phrase - String
prev_phrase2 - String
clothing - String
clothing_nh_var - String
islander - Boolean
debut - String
dnm - Boolean
ac - Boolean
e_plus - Boolean
ww - Boolean
cf - Boolean
nl - Boolean
wa - Boolean
nh - Boolean
film - Boolean
hhd - Boolean
pc - Boolean
|
|
-
|
|
|
ww_villager
|
Wild World villager picture, quote and preferences
|
Open to view 6 fields
|
name - String
name_sort - String
pic - String
quote - String
favclothing - String
leastfavclothing - String
|
|
-
|