Nookipedia:Project Database/List of tables

This section can be edited at Project Database/List of tables.

The following table lists tables, descriptions, and their status. Note that this table is manually updated. Last update: 13:42, September 8, 2020 (EDT)

	Production: This table's structure is finalized, and has been fully populated with data. It can reliably be used for querying on-wiki or externally.
	Beta: This table is approaching completion. Structure is near finalized, and/or nearly all data has been populated.
	Dev: This table is brand new. Columns may be added, removed, or changed, and/or is still missing a lot of data.

A full up-to-date list of tables (and their associated declare/attachment templates) is available at Special:CargoTables.

Status API 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 18 fields
`name` - String `image` - String `image_url` - String `has_fake` - Boolean `fake_image` - String `fake_image_url` - 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

-

pg_fossil

Animal Crossing fossils

Open to view 8 fields
`number` - Integer `name` - String `image` - String `fossil_group` - String `sell_price` - Integer `hha_base` - Integer `width` - Float `length` - Float

-

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`

-

Anonymous

Search

Nookipedia:Project Database/List of tables

Namespaces

More

Page actions

Navigation

Navigation

New Horizons

Community

Contents

Maintenance

Wiki tools

Wiki tools

Anonymous

Search

Nookipedia:Project Database/List of tables

Navigation

Wiki tools

Page actions

⧼Advertisement⧽