Nookipedia:Project Database/List of tables

From Nookipedia, the Animal Crossing wiki
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: 02:53, April 24, 2021 (EST)

Green 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.
Yellow Beta: This table is approaching completion. Structure is near finalized, and/or nearly all data has been populated.
Gray 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
Green No amiibo_card Amiibo cards
Open to view 7 fields
  • name - String
  • number - String
  • image_front - String
  • dice - Integer
  • hand - String
  • birthday - String
  • sign - String
-
Yellow No cf_art City Folk art
Open to view 11 fields
  • name - String
  • image - String
  • image_url - String
  • has_fake - Boolean
  • buy_price - Integer
  • sell - Integer
  • availability - String
  • availability_note - String
  • authenticity - String
  • width - Float
  • length - Float
Missing art textures
Green No cf_bug City Folk bugs
Open to view 57 fields
  • url - String
  • name - String
  • number - Integer
  • image - String
  • image_url - String
  • catchphrase - String
  • catchphrase2 - String
  • size - String
  • location - String
  • rarity - String
  • sell - Integer
  • tank_width - Float
  • tank_length - Float
  • availability - String
  • m1 - Boolean
  • m2 - Boolean
  • m3 - Boolean
  • m4 - Boolean
  • m5 - Boolean
  • m6 - Boolean
  • m7 - Boolean
  • m8_1 - Boolean
  • m8_2 - Boolean
  • m9_1 - Boolean
  • m9_2 - Boolean
  • m10 - Boolean
  • m11 - Boolean
  • m12 - Boolean
  • m1_time - String
  • m2_time - String
  • m3_time - String
  • m4_time - String
  • m5_time - String
  • m6_time - String
  • m7_time - String
  • m8_1_time - String
  • m8_2_time - String
  • m9_1_time - String
  • m9_2_time - String
  • m10_time - String
  • m11_time - String
  • m12_time - String
  • time - String
  • time_availability - String
  • time2 - String
  • time2_availability - String
  • time3 - String
  • time3_availability - String
  • peaktime - String
  • peaktime_availability - String
  • peaktime2 - String
  • peaktime_availability2 - String
  • peaktime3 - String
  • peaktime_availability3 - String
  • peaktime4 - String
  • peaktime_availability4 - String
  • description - Text
-
Green No cf_fish City Folk fish
Open to view 56 fields
  • url - String
  • name - String
  • number - Integer
  • image - String
  • image_url - String
  • description - Text
  • catchphrase - String
  • catchphrase2 - String
  • location - String
  • shadow_size - String
  • fish_size - String
  • rarity - String
  • sell - Integer
  • tank_width - Float
  • tank_length - Float
  • availability - String
  • m1 - Boolean
  • m2 - Boolean
  • m3 - Boolean
  • m4 - Boolean
  • m5 - Boolean
  • m6 - Boolean
  • m7 - Boolean
  • m8_1 - Boolean
  • m8_2 - Boolean
  • m9_1 - Boolean
  • m9_2 - Boolean
  • m10 - Boolean
  • m11 - Boolean
  • m12 - Boolean
  • m1_time - String
  • m2_time - String
  • m3_time - String
  • m4_time - String
  • m5_time - String
  • m6_time - String
  • m7_time - String
  • m8_1_time - String
  • m8_2_time - String
  • m9_1_time - String
  • m9_2_time - String
  • m10_time - String
  • m11_time - String
  • m12_time - String
  • time - String
  • time_availability - String
  • time2 - String
  • time2_availability - String
  • peaktime - String
  • peaktime_availability - String
  • peaktime2 - String
  • peaktime_availability2 - String
  • peaktime3 - String
  • peaktime_availability3 - String
  • peaktime4 - String
  • peaktime_availability4 - String
-
Yellow No cf_house City Folk villager homes (some parts used in villager endpoint)
Open to view 13 fields
  • villager - String
  • interior_image - String
  • interior_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
-
Gray No 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
-
Green No e_card e-Reader cards
Open to view 10 fields
  • villager - String
  • number - String
  • image_front - String
  • image_back - String
  • gender - String
  • sign - String
  • clothes - String
  • phrase - String
  • description - String
  • password_line1 - String
  • password_line2 - String
-
Yellow No furniture_collection Furniture collection (such as series, sets, and themes) across the series
Open to view 17 fields
  • url - String
  • name - String
  • image - String
  • type1 - String
  • type1_note - String
  • type2 - String
  • type2_note - String
  • dnm - Boolean
  • ac - Boolean
  • e_plus - Boolean
  • ww - Boolean
  • cf - Boolean
  • nl - Boolean
  • nlwa - Boolean
  • nh - Boolean
  • hhd - Boolean
  • pc - Boolean
Missing images in some pages.
Green Yes nh_art New Horizons art
Open to view 27 fields
  • name - String
  • image - String
  • image_url - String
  • has_fake - Boolean
  • fake_image - String
  • fake_image_url - String
  • texture - String
  • texture_url - String
  • fake_texture - String
  • fake_texture_url - String
  • art_name - String
  • author - String
  • year - String
  • art_style - String
  • art_type - String
  • description - Text
  • theme1 - String
  • theme2 - String
  • theme_fake - String
  • buy_price - Integer
  • buy_wikitext - Wikitext string
  • sell - Integer
  • availability - String
  • availability_note - String
  • authenticity - String
  • width - Float
  • length - Float
-
Green Yes nh_bug New Horizons bugs
Open to view 73 fields
  • url - String
  • name - String
  • number - Integer
  • image - String
  • image_url - String
  • render - String
  • render_url - String
  • catchphrase - String
  • catchphrase2 - String
  • location - String
  • rarity - String
  • total_catch - Integer
  • sell_nook - Integer
  • sell_flick - Integer
  • tank_width - Float
  • tank_length - Float
  • 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
  • n_m1_time - String
  • n_m2_time - String
  • n_m3_time - String
  • n_m4_time - String
  • n_m5_time - String
  • n_m6_time - String
  • n_m7_time - String
  • n_m8_time - String
  • n_m9_time - String
  • n_m10_time - String
  • n_m11_time - String
  • n_m12_time - String
  • 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
  • s_m1_time - String
  • s_m2_time - String
  • s_m3_time - String
  • s_m4_time - String
  • s_m5_time - String
  • s_m6_time - String
  • s_m7_time - String
  • s_m8_time - String
  • s_m9_time - String
  • s_m10_time - String
  • s_m11_time - String
  • s_m12_time - String
  • weather - String
  • time - String
  • time_n_availability - String
  • time_s_availability - String
  • time2 - String
  • time2_n_availability - String
  • time2_s_availability - String
Missing rarity data (common name for rarity percentages TBD).
Green Yes nh_calendar New Horizons event and birthday notices.
Open to view 4 fields
  • date - Date
  • event - String
  • type - String
  • link - Page
-
Yellow Yes nh_clothing New Horizons clothing
Open to view 57 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
  • variation_total - Integer
  • vill_equip - Boolean
  • seasonality - String
  • gender - String
  • vill_gender - String
  • spring - Integer
  • summer - Integer
  • autumn - Integer
  • winter - Integer
  • china - Integer
  • birthday - Integer
  • book - Integer
  • sleep - Integer
  • bug_catching - Integer
  • japanese - Integer
  • fishing - Integer
  • usually - Integer
  • fashion - Integer
  • rain - Integer
  • birthday_main - Integer
  • countdown - Integer
  • snow - Integer
  • sports - Integer
  • yoga - Integer
  • sunbathing - Integer
  • concert - Integer
  • bunny_day - Integer
  • fireworks - Integer
  • halloween - Integer
  • turkey_day_plaza - Integer
  • turkey_day_home - Integer
  • toy_day - Integer
  • version_added - String
  • unlocked - Boolean
  • notes - String
Needs populating with the new data. (Integers should be replaced with booleans)
Green Yes nh_clothing_variation New Horizons clothing variations
Open to view 10 fields
  • identifier - String
  • en_name - String
  • variation - String
  • variation_number - Integer
  • image - String
  • image_url - String
  • image_storage - String
  • image_storage_url - String
  • color1 - String
  • color2 - String
-
Green Yes nh_fish New Horizons fish
Open to view 75 fields
  • url - String
  • name - String
  • number - Integer
  • image - String
  • image_url - String
  • render - String
  • render_url - String
  • catchphrase - String
  • catchphrase2 - String
  • catchphrase3 - String
  • location - String
  • shadow_size - String
  • rarity - String
  • total_catch - Integer
  • sell_nook - Integer
  • sell_cj - Integer
  • tank_width - Float
  • tank_length - Float
  • 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
  • n_m1_time - String
  • n_m2_time - String
  • n_m3_time - String
  • n_m4_time - String
  • n_m5_time - String
  • n_m6_time - String
  • n_m7_time - String
  • n_m8_time - String
  • n_m9_time - String
  • n_m10_time - String
  • n_m11_time - String
  • n_m12_time - String
  • 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
  • s_m1_time - String
  • s_m2_time - String
  • s_m3_time - String
  • s_m4_time - String
  • s_m5_time - String
  • s_m6_time - String
  • s_m7_time - String
  • s_m8_time - String
  • s_m9_time - String
  • s_m10_time - String
  • s_m11_time - String
  • s_m12_time - String
  • time - String
  • time_n_availability - String
  • time_s_availability - String
  • time2 - String
  • time2_n_availability - String
  • time2_s_availability - String
  • description - Text
Missing rarity data (common name for rarity percentages TBD). Needs description filling.
Green No nh_fossil New Horizons fossils
Open to view 11 fields
  • name - String
  • image - String
  • image_url - String
  • fossil_group - String
  • interactable - Boolean
  • sell - Integer
  • color1 - String
  • color2 - String
  • hha_base - Integer
  • width - Float
  • length - Float
-
Green No nh_fossil_group New Horizons fossil groups
Open to view 3 fields
  • name - String
  • room - Integer
  • description - Text
-
Green Yes nh_furniture New Horizons furniture
Open to view 50 fields
  • identifier - String
  • en_name - String
  • category - String
  • category_sort - Integer
  • item_series - String
  • item_set - String
  • theme1 - String
  • theme2 - String
  • hha_category - String
  • tag - String
  • hha_base - Integer
  • lucky - Boolean
  • lucky_season - String
  • 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
  • availability3 - String
  • availability3_note - String
  • variation_total - Integer
  • pattern_total - Integer
  • customizable - Boolean
  • custom_kits - Integer
  • custom_kit_type - String
  • 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
  • is_material - Boolean
  • version_added - String
  • unlocked - Boolean
  • notes - String
-
Green Yes nh_furniture_variation New Horizons furniture variations
Open to view 7 fields
  • identifier - String
  • en_name - String
  • variation - String
  • variation_number - Integer
  • pattern - String
  • pattern_number - Integer
  • image - String
  • image_url - String
  • color1 - String
  • color2 - String
-
Green Yes nh_house New Horizons villager homes (some parts used in villager endpoint)
Open to view 18 fields
  • villager - String
  • name_sort - 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
  • music_image - String
  • music_image_url - String
  • items - Text
  • notes - Wikitext string
-
Green Yes nh_interior New Horizons wallpaper and flooring
Open to view 32 fields
  • identifier - String
  • en_name - String
  • image - String
  • image_url - String
  • category - String
  • category_sort - Integer
  • item_series - String
  • item_set - String
  • theme1 - String
  • theme2 - String
  • hha_category - String
  • tag - 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
  • grid_size - String
  • vfx - Boolean
  • color1 - String
  • color2 - String
  • is_material - Boolean
  • version_added - String
  • unlocked - Boolean
  • notes - String
-
Green Yes nh_item New Horizons other items
Open to view 28 fields
  • identifier - String
  • en_name - String
  • image - String
  • image_url - String
  • stack - Integer
  • hha_base - Integer
  • buy1_price - Integer
  • buy1_currency - String
  • buy1_wikitext - Wikitext string
  • sell - Integer
  • is_fence - Boolean
  • is_material - Boolean
  • material_type - String
  • material_seasonality - String
  • material_sort - Integer
  • material_name_sort - Integer
  • material_seasonality_sort - Integer
  • edible - Boolean
  • plant_type - String
  • availability1 - String
  • availability1_note - String
  • availability2 - String
  • availability2_note - String
  • availability3 - String
  • availability3_note - String
  • version_added - String
  • unlocked - Boolean
  • notes - String
-
Green No 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
-
Gray No 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
-
Green Yes nh_photo New Horizons villager photos and posters
Open to view 27 fields
  • identifier - String
  • en_name - String
  • name_sort - String
  • category - 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
  • 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
-
Green Yes nh_photo_variation New Horizons villager photo customization
Open to view 8 fields
  • identifier - String
  • en_name - String
  • variation - String
  • variation_number - Integer
  • image - String
  • image_url - String
  • color1 - String
  • color2 - String
-
Green Yes nh_recipe New Horizons DIY recipes
Open to view 32 fields
  • identifier - String
  • en_name - String
  • image - String
  • image_url - String
  • serial_id - Integer
  • type - String
  • 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
-
Green Yes nh_sea_creature New Horizons sea creatures
Open to view 72 fields
  • url - String
  • name - String
  • number - Integer
  • image - String
  • image_url - String
  • render - String
  • render_url - String
  • catchphrase - String
  • catchphrase2 - String
  • shadow_size - String
  • shadow_movement - String
  • rarity - String
  • total_catch - Integer
  • sell_nook - Integer
  • tank_width - Float
  • tank_length - Float
  • 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
  • n_m1_time - String
  • n_m2_time - String
  • n_m3_time - String
  • n_m4_time - String
  • n_m5_time - String
  • n_m6_time - String
  • n_m7_time - String
  • n_m8_time - String
  • n_m9_time - String
  • n_m10_time - String
  • n_m11_time - String
  • n_m12_time - String
  • 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
  • s_m1_time - String
  • s_m2_time - String
  • s_m3_time - String
  • s_m4_time - String
  • s_m5_time - String
  • s_m6_time - String
  • s_m7_time - String
  • s_m8_time - String
  • s_m9_time - String
  • s_m10_time - String
  • s_m11_time - String
  • s_m12_time - String
  • time - String
  • time_n_availability - String
  • time_s_availability - String
  • time2 - String
  • time2_n_availability - String
  • time2_s_availability - String
Missing rarity data (common name for rarity percentages TBD).
Green Yes nh_tool New Horizons handheld items
Open to view 28 fields
  • identifier - String
  • en_name - String
  • uses - String
  • inv_icon - String
  • inv_icon_url - 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
  • availability4 - String
  • availability4_note - String
  • customizable - Boolean
  • custom_kits - Integer
  • custom_body_part - String
  • is_material - Boolean
  • version_added - String
  • unlocked - Boolean
  • notes - String
-
Green Yes nh_tool_variation New Horizons handheld item variations
Open to view 8 fields
  • identifier - String
  • en_name - String
  • variation - String
  • variation_number - Integer
  • image - String
  • image_url - String
  • color1 - String
  • color2 - String
-
Green Yes nh_villager New Horizons villagers (using in villager endpoint)
Open to view 25 fields
  • url - String
  • name - String
  • name_sort - 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
  • umbrella - String
  • new - Boolean
  • fav_style1 - String
  • fav_style2 - String
  • fav_color1 - String
  • fav_color2 - String
  • hobby - String
  • life_points - String
  • hobby_points - String
  • wave_type - String
  • bag - String
  • popsicle - String
  • food - String
  • drink - String
  • book - String
-
Green No nl_art New Leaf art
Open to view 19 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
  • art_type - String
  • description - Text
  • buy_price - Integer
  • sell - Integer
  • availability - String
  • availability_note - String
  • authenticity - String
  • width - Float
  • length - Float
-
Green No nl_bug New Leaf bugs
Open to view 64 fields
  • url - String
  • name - String
  • number - Integer
  • image - String
  • image_url - String
  • catchphrase - String
  • catchphrase2 - String
  • size - String
  • location - String
  • location2 - String
  • rarity - String
  • sell - Integer
  • sell_pre_wa - Integer
  • tank_width - Float
  • tank_length - Float
  • availability - String
  • m1 - Boolean
  • m2 - Boolean
  • m3 - Boolean
  • m4 - Boolean
  • m5 - Boolean
  • m6 - Boolean
  • m7 - Boolean
  • m8_1 - Boolean
  • m8_2 - Boolean
  • m9_1 - Boolean
  • m9_2 - Boolean
  • m10 - Boolean
  • m11 - Boolean
  • m12 - Boolean
  • on_tortimer_island - Boolean
  • on_island_tour - Boolean
  • m1_time - String
  • m2_time - String
  • m3_time - String
  • m4_time - String
  • m5_time - String
  • m6_time - String
  • m7_time - String
  • m8_1_time - String
  • m8_2_time - String
  • m9_1_time - String
  • m9_2_time - String
  • m10_time - String
  • m11_time - String
  • m12_time - String
  • tortimer_island_time - String
  • time - String
  • time_availability - String
  • time2 - String
  • time2_availability - String
  • time3 - String
  • time3_availability - String
  • time4 - String
  • time4_availability - String
  • peaktime - String
  • peaktime_availability - String
  • peaktime2 - String
  • peaktime2_availability - String
  • peaktime3 - String
  • peaktime3_availability - String
  • peaktime4 - String
  • peaktime4_availability - String
  • description - Text
-
Green No nl_fish New Leaf fish
Open to view 64 fields
  • url - String
  • name - String
  • number - Integer
  • image - String
  • image_url - String
  • catchphrase - String
  • catchphrase2 - String
  • location - String
  • shadow_size - String
  • fish_size - String
  • rarity - String
  • sell - Integer
  • sell_pre_wa - Integer
  • tank_width - Float
  • tank_length - Float
  • availability - String
  • m1 - Boolean
  • m2 - Boolean
  • m3 - Boolean
  • m4 - Boolean
  • m5 - Boolean
  • m6 - Boolean
  • m7 - Boolean
  • m8_1 - Boolean
  • m8_2 - Boolean
  • m9_1 - Boolean
  • m9_2 - Boolean
  • m10 - Boolean
  • m11 - Boolean
  • m12 - Boolean
  • on_tortimer_island - Boolean
  • on_island_tour - Boolean
  • m1_time - String
  • m2_time - String
  • m3_time - String
  • m4_time - String
  • m5_time - String
  • m6_time - String
  • m7_time - String
  • m8_1_time - String
  • m8_2_time - String
  • m9_1_time - String
  • m9_2_time - String
  • m10_time - String
  • m11_time - String
  • m12_time - String
  • tortimer_island_time - String
  • time - String
  • time_availability - String
  • time2 - String
  • time2_availability - String
  • time3 - String
  • time3_availability - String
  • time4 - String
  • time4_availability - String
  • peaktime - String
  • peaktime_availability - String
  • peaktime2 - String
  • peaktime2_availability - String
  • peaktime3 - String
  • peaktime3_availability - String
  • peaktime4 - String
  • peaktime4_availability - String
  • description - Text
Missing rarity data (common name for rarity percentages TBD).
Green No nl_house New Leaf villager homes
Open to view 16 fields
  • villager - String
  • name_sort - 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
-
Green No nl_sea_creature New Leaf sea creatures
Open to view 65 fields
  • url - String
  • name - String
  • number - Integer
  • image - String
  • image_url - String
  • catchphrase - String
  • catchphrase2 - String
  • sea_creature_size - String
  • shadow_size - String
  • shadow_movement - String
  • location - String
  • rarity - String
  • sell - Integer
  • sell_pre_wa - Integer
  • tank_width - Float
  • tank_length - Float
  • availability - String
  • m1 - Boolean
  • m2 - Boolean
  • m3 - Boolean
  • m4 - Boolean
  • m5 - Boolean
  • m6 - Boolean
  • m7 - Boolean
  • m8_1 - Boolean
  • m8_2 - Boolean
  • m9_1 - Boolean
  • m9_2 - Boolean
  • m10 - Boolean
  • m11 - Boolean
  • m12 - Boolean
  • on_tortimer_island - Boolean
  • on_island_tour - Boolean
  • m1_time - String
  • m2_time - String
  • m3_time - String
  • m4_time - String
  • m5_time - String
  • m6_time - String
  • m7_time - String
  • m8_1_time - String
  • m8_2_time - String
  • m9_1_time - String
  • m9_2_time - String
  • m10_time - String
  • m11_time - String
  • m12_time - String
  • tortimer_island_time - String
  • time - String
  • time_availability - String
  • time2 - String
  • time2_availability - String
  • time3 - String
  • time3_availability - String
  • time4 - String
  • time4_availability - String
  • peaktime - String
  • peaktime_availability - String
  • peaktime2 - String
  • peaktime_availability2 - String
  • peaktime3 - String
  • peaktime_availability3 - String
  • peaktime4 - String
  • peaktime_availability4 - String
  • description - Text
Missing rarity data (common name for rarity percentages TBD).
Yellow No nl_villager New Leaf villagers
Open to view 32 fields
  • name - String
  • name_sort - String
  • image - String
  • image_url - String
  • image_nlwa - String
  • image_nlwa_url - String
  • pic - String
  • pic_url - String
  • icon - String
  • icon_url - String
  • birthday - String
  • birthday_sort - Integer
  • sign - String
  • catchphrase - String
  • catchphrase_note - String
  • catchphrase2 - String
  • catchphrase2_note - String
  • quote - String
  • clothing - String
  • umbrella - String
  • new - Boolean
  • nlwa - Boolean
  • siblings - String
  • favclothing - String
  • leastfavclothing - String
  • favcolor - String
  • skill - String
  • goal - String
  • fear - String
  • coffeetype - String
  • milk - String
  • sugar - String
-
Green No nlwa_rv Welcome amiibo RVs
Open to view 16 fields
  • name - String
  • description - 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
-
Gray No pc_furniture Pocket Camp furniture
Open to view 20 fields
  • identifier - String
  • en_name - String
  • image - String
  • category - String
  • theme - String
  • rarity - String
  • buy - Integer
  • sell - Integer
  • unlocked - String
  • availability - String
  • availability_note - String
  • availability_start - String
  • availability_end - String
  • length - Integer
  • width - Integer
  • conversation_piece - Boolean
  • memory - Boolean
  • gulliver_points - Integer
  • reaction - String
  • gift_group - Integer
  • crafting_time - Integer
  • crafting_difficulty - String
  • crafting_material1 - String
  • crafting_material1_num - Integer
  • crafting_material2 - String
  • crafting_material2_num - Integer
  • crafting_material3 - String
  • crafting_material3_num - Integer
  • crafting_material4 - String
  • crafting_material4_num - Integer
  • crafting_material5 - String
  • crafting_material5_num - Integer
  • crafting_material6 - String
  • crafting_material6_num - Integer
  • crafting_bells - Integer
  • reissued - Boolean
  • reissue_crafting_time - Integer
  • reissue_crafting_material1 - String
  • reissue_crafting_material1_num - Integer
  • reissue_crafting_material2 - String
  • reissue_crafting_material2_num - Integer
  • reissue_crafting_material3 - String
  • reissue_crafting_material3_num - Integer
  • reissue_crafting_material4 - String
  • reissue_crafting_material4_num - Integer
  • reissue_crafting_material5 - String
  • reissue_crafting_material5_num - Integer
  • reissue_crafting_material6 - String
  • reissue_crafting_material6_num - Integer
  • reissue_crafting_bells - Integer
  • notes - String
-
Yellow No pc_villager Pocket Camp villager info and rewards Columns need renaming to match standard
Open to view 20 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
  • version_added - String
  • date_unlocked - String
-
Green No pg_bug Animal Crossing bugs
Open to view 60 fields
  • url - String
  • name - String
  • in_dnm - Boolean
  • in_plus - Boolean
  • in_pg - Boolean
  • in_e_plus - Boolean
  • number - Integer
  • num_dnm - Integer
  • num_plus - Integer
  • num_pg - Integer
  • num_e_plus - Integer
  • image - String
  • image_url - String
  • catchphrase - String
  • location - String
  • location2 - String
  • rarity - String
  • sell - Integer
  • tank_width - Float
  • tank_length - Float
  • feng_shui - String
  • availability - String
  • on_animal_island - Boolean
  • m1 - Boolean
  • m2 - Boolean
  • m3 - Boolean
  • m4 - Boolean
  • m5 - Boolean
  • m6 - Boolean
  • m7 - Boolean
  • m8_1 - Boolean
  • m8_2 - Boolean
  • m9_1 - Boolean
  • m9_2 - Boolean
  • m10 - Boolean
  • m11 - Boolean
  • m12 - Boolean
  • m1_time - String
  • m2_time - String
  • m3_time - String
  • m4_time - String
  • m5_time - String
  • m6_time - String
  • m7_time - String
  • m8_1_time - String
  • m8_2_time - String
  • m9_1_time - String
  • m9_2_time - String
  • m10_time - String
  • m11_time - String
  • m12_time - String
  • time - String
  • time_availability - String
  • time2 - String
  • time2_availability - String
  • time3 - String
  • time3_availability - String
  • time4 - String
  • time4_availability - String
  • blathers_quote - String
Missing rarity data (common name for rarity percentages TBD).
Green No pg_clothing Animal Crossing clothing
Open to view 34 fields
  • identifier - String
  • en_name - String
  • es_name - String
  • de_name - String
  • fr_name - String
  • it_name - String
  • ja_name - String
  • zh_name - String
  • in_dnm - Boolean
  • in_plus - Boolean
  • in_pg - Boolean
  • in_e_plus - Boolean
  • catalog_num_dnm - Integer
  • catalog_num_plus - Integer
  • catalog_num_pg - Integer
  • catalog_num_e_plus - Integer
  • image - String
  • texture - String
  • rarity_group - String
  • hra_base - Integer
  • buy - Integer
  • sell - Integer
  • availability1 - String
  • availability1_note - String
  • availability2 - String
  • availability2_note - String
  • availability_other - List of String
  • availability_other_note - String
  • availability_dates - String
  • availability_season - String
  • style - String
  • universal_code - String
  • universal_code_plus - String
  • notes - String
-
Green No pg_fish Animal Crossing fish
Open to view 61 fields
  • url - String
  • name - String
  • number - Integer
  • in_dnm - Boolean
  • in_plus - Boolean
  • in_pg - Boolean
  • in_e_plus - Boolean
  • num_dnm - Integer
  • num_plus - Integer
  • num_pg - Integer
  • num_e_plus - Integer
  • image - String
  • image_url - String
  • catchphrase - String
  • location - String
  • location2 - String
  • shadow_size - String
  • rarity - String
  • sell - Integer
  • tank_width - Float
  • tank_length - Float
  • feng_shui - String
  • availability - String
  • on_animal_island - Boolean
  • m1 - Boolean
  • m2 - Boolean
  • m3 - Boolean
  • m4 - Boolean
  • m5 - Boolean
  • m6 - Boolean
  • m7 - Boolean
  • m8_1 - Boolean
  • m8_2 - Boolean
  • m9_1 - Boolean
  • m9_2 - Boolean
  • m10 - Boolean
  • m11 - Boolean
  • m12 - Boolean
  • m1_time - String
  • m2_time - String
  • m3_time - String
  • m4_time - String
  • m5_time - String
  • m6_time - String
  • m7_time - String
  • m8_1_time - String
  • m8_2_time - String
  • m9_1_time - String
  • m9_2_time - String
  • m10_time - String
  • m11_time - String
  • m12_time - String
  • time - String
  • time_availability - String
  • time2 - String
  • time2_availability - String
  • time3 - String
  • time3_availability - String
  • time4 - String
  • time4_availability - String
  • blathers_quote - Text
Missing rarity data (common name for rarity percentages TBD).
Green No 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
-
Green No pg_furniture Animal Crossing furniture
Open to view 47 fields
  • identifier - String
  • en_name - String
  • in_dnm - Boolean
  • in_plus - Boolean
  • in_pg - Boolean
  • in_e_plus - Boolean
  • catalog_num_dnm - Integer
  • catalog_num_plus - Integer
  • catalog_num_pg - Integer
  • catalog_num_e_plus - Integer
  • image_dnm - String
  • image_plus - String
  • image_pg - String
  • image_e_plus - String
  • audio - String
  • collection - String
  • rarity_group - String
  • hra_base - Integer
  • color - String
  • lucky - Boolean
  • function - String
  • has_surface - Boolean
  • buy - Integer
  • sell - Integer
  • availability1 - String
  • availability1_note - String
  • availability2 - String
  • availability2_note - String
  • availability3 - String
  • availability3_note - String
  • availability_other - List of String
  • availability_other_note - String
  • plus_availability - String
  • plus_availability_note - String
  • length - Integer
  • width - Integer
  • interactable - Boolean
  • interactivity - String
  • animated - Boolean
  • animation_activation - String
  • sound - Boolean
  • sound_activation - String
  • placeable - Boolean
  • placeable_surface - Boolean
  • walkable - Boolean
  • universal_code - String
  • notes - String
-
Green No pg_house Animal Crossing villager homes (some parts used in villager endpoint)
Open to view 18 fields
  • villager - String
  • islander - Boolean
  • game - List of 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
  • request_items - Text
  • notes - Wikitext string
-
Green No pg_interior Animal Crossing wallpaper and flooring
Open to view 30 fields
  • identifier - String
  • en_name - String
  • in_dnm - Boolean
  • in_plus - Boolean
  • in_pg - Boolean
  • in_e_plus - Boolean
  • catalog_num_dnm - Integer
  • catalog_num_plus - Integer
  • catalog_num_pg - Integer
  • catalog_num_e_plus - Integer
  • image - String
  • category - String
  • category_sort - Integer
  • collection - String
  • rarity_group - String
  • hra_base - Integer
  • buy - Integer
  • sell - Integer
  • availability1 - String
  • availability1_note - String
  • availability2 - String
  • availability2_note - String
  • availability3 - String
  • availability3_note - String
  • availability_other - List of String
  • availability_other_note - String
  • plus_availability - String
  • plus_availability_note - String
  • universal_code - String
  • notes - String
-
Yellow No pg_item Animal Crossing other items
Open to view 19 fields
  • identifier - String
  • en_name - String
  • in_dnm - Boolean
  • in_plus - Boolean
  • in_pg - Boolean
  • in_e_plus - Boolean
  • image - String
  • buy - Integer
  • sell - Integer
  • availability1 - String
  • availability1_note - String
  • availability2 - String
  • availability2_note - String
  • availability3 - String
  • availability3_note - String
  • availability_other - List of String
  • availability_other_note - String
  • universal_code - String
  • notes - String
-
Green No pg_language_name Animal Crossing translations
Open to view 8 fields
  • identifier - String
  • en_name - String
  • de_name - String
  • es_name - String
  • fr_name - String
  • it_name - String
  • ja_name - String
  • notes - String
-
Green No pg_villager Animal Crossing villagers (using in villager endpoint)
Open to view 25 fields
  • url - String
  • name - String
  • romanized_name - String
  • image - String
  • image_url - String
  • species - String
  • gender - String
  • personality - String
  • sign - String
  • catchphrase - String
  • clothing - String
  • clothing_e_plus - String
  • clothing_plus - String
  • clothing_dnm - String
  • umbrella - String
  • in_dnm - Boolean
  • in_pg - Boolean
  • in_e_plus - Boolean
  • islander - Boolean
  • fav_fruit - String
  • allergic_fruit - String
  • fav_clothing - String
  • least_fav_clothing - String
  • song_gift - String
-
Green No song K.K. Slider song cover, 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
-
Yellow No special_character Special character info and Animal Crossing series appearances
Open to view 29 fields
  • url - String
  • name - String
  • name_sort - String
  • alt_name - String
  • ID - String
  • image - String
  • image_url - String
  • nh_phone_texture - String
  • nh_phone_texture_url - String
  • species - String
  • gender - String
  • gender_japan - String
  • birthday - String
  • birthday_month - String
  • birthday_day - Integer
  • 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
-
Green Yes villager Animal Crossing series villagers
Open to view 40 fields
  • url - String
  • name - String
  • name_sort - String
  • alt_name - String
  • title_color - String
  • text_color - String
  • id - String
  • image - String
  • image_url - String
  • species - String
  • personality - String
  • personality_note - String
  • prev_personality - String
  • prev_personality_note - String
  • gender - String
  • birthday - String
  • birthday_month - String
  • birthday_day - Integer
  • birthday_sort - Integer
  • sign - String
  • sign_sort - Integer
  • 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
-
Yellow No ww_house Wild World villager homes (some parts used in villager endpoint)
Open to view 13 fields
  • villager - String
  • interior_image - String
  • interior_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
-
Gray No 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
-