Nookipedia:Project Database

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.

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

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

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

• 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

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)

	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
		amiibo_card	Amiibo cards	Open to view 7 fields name - String number - String image_front - String dice - Integer hand - String birthday - String sign - String	-
		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
		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	-
		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	-
		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	-
		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	-
		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	-
		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.
		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	-
		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).
		nh_calendar	New Horizons event and birthday notices.	Open to view 4 fields date - Date event - String type - String link - Page	-
		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)
		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	-
		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.
		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	-
		nh_fossil_group	New Horizons fossil groups	Open to view 3 fields name - String room - Integer description - Text	-
		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	-
		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	-
		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	-
		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	-
		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	-
		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 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	-
		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	-
		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	-
		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).
		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	-
		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	-
		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	-
		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	-
		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	-
		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).
		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	-
		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).
		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	-
		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	-
		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	-
		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	-
		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).
		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	-
		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).
		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	-
		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	-
		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	-
		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	-
		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	-
		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	-
		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	-
		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	-
		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	-
		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	-
		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	-
		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

General

• Wikidata:Glossary
• Wikibase Help:FAQ

Inputting data

• Help:Properties
• Help:Basic membership properties

Retrieving data

• How to use data on Wikimedia projects
• Extension:Wikibase Client/Lua
• Wikipedia:Lua