Nookipedia:Project Database

From Nookipedia, the Animal Crossing wiki
Tom Nook NH Character Icon.png
This project is led by SuperHamster.
As the leader, SuperHamster directs the project and its objectives. You can contact them directly on their talk page to discuss the project.
Tom Nook NH Character Icon.png
This project is led by SuperHamster.
As the leader, SuperHamster directs the project and its objectives. You can contact them directly on their talk page to discuss the project.

Welcome to Project Database, the Nookipedia Project dedicated to establishing and maintaining a database covering the Animal Crossing series.

Cargo[edit]

Nookipedia uses Cargo, a MediaWiki extension that provides a way to store data from templates into a database. This means that we can define data about a subject in just one location, and then re-use it across the wiki through querying. It also enables external users to re-use our data, through the MediaWiki API, api.nookipedia.com, and other services.

Basics[edit]

On the wiki, editors can interact with Cargo through parser functions:

  • #cargo_declare - Defines the schema for a table. Placed within the noinclude part of a template.
  • #cargo_store - Stores one row of data to a Cargo table. Placed within the include part of a template.
  • #cargo_query - Queries Cargo data tables, using SQL components.
  • #cargo_attach - Defines a template as adding rows to a table declared elsewhere.
  • #cargo_compound_query - displays the results of multiple queries in one place.

For full usage documentation, see mw:Extension:Cargo/Storing data and mw:Extension:Cargo/Querying data. For usage examples here on Nookipedia see Furniture/New Horizons.

Best practices[edit]

  • All table and column names should be completely lowercase, with words being separated by an underscore.
  • All table and column names should be singular, not plural. An exception is when a column's values are lists (e.g. a column that holds arrays of materials may be called materials).
  • Column names that refer to the same data should generally be consistent between tables, especially for the same "category" of tables.
    • For example, our item tables refer to the width and length of items as width and length, while our critter tables refer to these values as tank_width and tank_length. The reason for the difference is to clarify that the width of a critter refers to its tank size, and not the critter itself. The important thing here is that the column names are consistent between all item tables across all games, and all critter tables across all games.
  • Values should be plain text (no HTML or wikitext), unless that column is explicitly being used for display.
    • This is so that the data can be queried elsewhere (on both the wiki and externally) without having to worry about formatting issues.
    • Example 1: nh_furniture has columns buy1_price, buy1_currency, and buy1_wikitext. The first two hold an integer and string respectively; the last one holds the value inside of Template:Currency, for easy reference on the wiki.
    • Example 2: In Template:NHFishInfo, the catchphrase parameter stores the catchphrase as a normal string, while catchphrase-display stores the catchphrase with any included HTML. The nh_fish Cargo table stores the former, while the template displays the latter.
  • When performing a #cargo_store, provide every field, even if the field value is empty. There is a bug that causes duplicate entries when not all fields are explicitly defined when storing.

List of tables[edit]

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 [nb 1] 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
-

Helpful links[edit]

General[edit]

Inputting data[edit]

Retrieving data[edit]

Notes[edit]

  1. A check in the API column indicates that the table is queried via api.nookipedia.com