Difference between revisions of "Nookipedia:Project Database/List of tables"

From Nookipedia, the Animal Crossing wiki
m
m
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
:''This section can be edited at [[Nookipedia:Project Database/List of tables|Project Database/List of tables]].''
 
:''This section can be edited at [[Nookipedia:Project Database/List of tables|Project Database/List of tables]].''
−
The following table lists tables, descriptions, and their status. Note that this table is manually updated. '''Last update:''' 23:35, April 9, 2021 (EST)
+
The following table lists tables, descriptions, and their status. Note that this table is manually updated. '''Last update:''' 02:53, April 24, 2021 (EST) <!-- Simply use {{subst:LOCALTIME}}, {{subst:LOCALMONTHNAME}} {{subst:LOCALDAY}}, {{subst:LOCALYEAR}} to update the time. -->
  
 
{|
 
{|
Line 431: Line 431:
 
|}
 
|}
 
|  Missing rarity data (common name for rarity percentages TBD).
 
|  Missing rarity data (common name for rarity percentages TBD).
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|Yes}}
 +
| '''[[Special:CargoTables/nh_calendar|nh_calendar]]'''
 +
| {{NH|short}} event and birthday notices.
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 4 fields}}
 +
|-
 +
|
 +
*<code>date</code> - Date
 +
*<code>event</code> - String
 +
*<code>type</code> - String
 +
*<code>link</code> - Page
 +
|}
 +
| -
 
|-  
 
|-  
 
| {{Table cell|Yellow}}
 
| {{Table cell|Yellow}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_clothing|nh_clothing]]'''
 
| '''[[Special:CargoTables/nh_clothing|nh_clothing]]'''
 
| {{NH|short}} clothing
 
| {{NH|short}} clothing
Line 503: Line 520:
 
|-  
 
|-  
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_clothing_variation|nh_clothing_variation]]'''
 
| '''[[Special:CargoTables/nh_clothing_variation|nh_clothing_variation]]'''
 
| {{NH|short}} clothing variations
 
| {{NH|short}} clothing variations
Line 620: Line 637:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 10 fields}}
+
! {{Colorshow|4c4c4c|Open to view 11 fields}}
 
|-
 
|-
 
|
 
|
 
*<code>name</code> - String
 
*<code>name</code> - String
 
*<code>image</code> - String
 
*<code>image</code> - String
 +
*<code>image_url</code> - String
 
*<code>fossil_group</code> - String
 
*<code>fossil_group</code> - String
 
*<code>interactable</code> - Boolean
 
*<code>interactable</code> - Boolean
Line 653: Line 671:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_furniture|nh_furniture]]'''
 
| '''[[Special:CargoTables/nh_furniture|nh_furniture]]'''
 
| {{NH|short}} furniture
 
| {{NH|short}} furniture
Line 716: Line 734:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_furniture_variation|nh_furniture_variation]]'''
 
| '''[[Special:CargoTables/nh_furniture_variation|nh_furniture_variation]]'''
 
| {{NH|short}} furniture variations
 
| {{NH|short}} furniture variations
Line 770: Line 788:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_interior|nh_interior]]'''
 
| '''[[Special:CargoTables/nh_interior|nh_interior]]'''
 
| {{NH|short}} wallpaper and flooring
 
| {{NH|short}} wallpaper and flooring
Line 776: Line 794:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 29 fields}}
+
! {{Colorshow|4c4c4c|Open to view 32 fields}}
 
|-
 
|-
 
|
 
|
Line 789: Line 807:
 
*<code>theme1</code> - String
 
*<code>theme1</code> - String
 
*<code>theme2</code> - String
 
*<code>theme2</code> - String
 +
*<code>hha_category</code> - String
 +
*<code>tag</code> - String
 +
*<code>hha_base</code> - Integer
 
*<code>buy1_price</code> - Integer
 
*<code>buy1_price</code> - Integer
 
*<code>buy1_currency</code> - String
 
*<code>buy1_currency</code> - String
Line 812: Line 833:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_item|nh_item]]'''
 
| '''[[Special:CargoTables/nh_item|nh_item]]'''
 
| {{NH|short}} other items
 
| {{NH|short}} other items
Line 917: Line 938:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_photo|nh_photo]]'''
 
| '''[[Special:CargoTables/nh_photo|nh_photo]]'''
 
| {{NH|short}} villager photos and posters
 
| {{NH|short}} villager photos and posters
Line 923: Line 944:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 26 fields}}
+
! {{Colorshow|4c4c4c|Open to view 27 fields}}
 
|-
 
|-
 
|
 
|
Line 930: Line 951:
 
*<code>name_sort</code> - String
 
*<code>name_sort</code> - String
 
*<code>category</code> - String
 
*<code>category</code> - String
 +
*<code>hha_base</code> - Integer
 
*<code>buy1_price</code> - Integer
 
*<code>buy1_price</code> - Integer
 
*<code>buy1_currency</code> - String
 
*<code>buy1_currency</code> - String
Line 956: Line 978:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_photo_variation|nh_photo_variation]]'''
 
| '''[[Special:CargoTables/nh_photo_variation|nh_photo_variation]]'''
 
| {{NH|short}} villager photo customization
 
| {{NH|short}} villager photo customization
Line 1,107: Line 1,129:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_tool|nh_tool]]'''
 
| '''[[Special:CargoTables/nh_tool|nh_tool]]'''
 
| {{NH|short}} handheld items
 
| {{NH|short}} handheld items
Line 1,113: Line 1,135:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 29 fields}}
+
! {{Colorshow|4c4c4c|Open to view 28 fields}}
 
|-
 
|-
 
|
 
|
 
*<code>identifier</code> - String
 
*<code>identifier</code> - String
 
*<code>en_name</code> - String
 
*<code>en_name</code> - String
−
*<code>item_set</code> - Integer
 
 
*<code>uses</code> - String
 
*<code>uses</code> - String
 
*<code>inv_icon</code> - String
 
*<code>inv_icon</code> - String
Line 1,149: Line 1,170:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_tool_variation|nh_tool_variation]]'''
 
| '''[[Special:CargoTables/nh_tool_variation|nh_tool_variation]]'''
 
| {{NH|short}} handheld item variations
 
| {{NH|short}} handheld item variations
Line 1,683: Line 1,704:
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
 
| {{Table cell|No}}
 
| {{Table cell|No}}
−
| '''[[Special:CargoTables/pg_fossil|pg_fossil]]'''
+
| '''[[Special:CargoTables/pg_bug|pg_bug]]'''
−
| {{PG}} fossils
+
| {{PG}} bugs
 
|
 
|
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 8 fields}}
+
! {{Colorshow|4c4c4c|Open to view 60 fields}}
 
|-
 
|-
 
|
 
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>in_dnm</code> - Boolean
 +
*<code>in_plus</code> - Boolean
 +
*<code>in_pg</code> - Boolean
 +
*<code>in_e_plus</code> - Boolean
 
*<code>number</code> - Integer
 
*<code>number</code> - Integer
−
*<code>name</code> - String
+
*<code>num_dnm</code> - Integer
 +
*<code>num_plus</code> - Integer
 +
*<code>num_pg</code> - Integer
 +
*<code>num_e_plus</code> - Integer
 
*<code>image</code> - String
 
*<code>image</code> - String
−
*<code>fossil_group</code> - String
+
*<code>image_url</code> - String
−
*<code>sell_price</code> - Integer
+
*<code>catchphrase</code> - String
−
*<code>hha_base</code> - Integer
+
*<code>location</code> - String
−
*<code>width</code> - Float
+
*<code>location2</code> - String
−
*<code>length</code> - Float
+
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>feng_shui</code> - String
 +
*<code>availability</code> - String
 +
*<code>on_animal_island</code> - Boolean
 +
*<code>m1</code> - Boolean
 +
*<code>m2</code> - Boolean
 +
*<code>m3</code> - Boolean
 +
*<code>m4</code> - Boolean
 +
*<code>m5</code> - Boolean
 +
*<code>m6</code> - Boolean
 +
*<code>m7</code> - Boolean
 +
*<code>m8_1</code> - Boolean
 +
*<code>m8_2</code> - Boolean
 +
*<code>m9_1</code> - Boolean
 +
*<code>m9_2</code> - Boolean
 +
*<code>m10</code> - Boolean
 +
*<code>m11</code> - Boolean
 +
*<code>m12</code> - Boolean
 +
*<code>m1_time</code> - String
 +
*<code>m2_time</code> - String
 +
*<code>m3_time</code> - String
 +
*<code>m4_time</code> - String
 +
*<code>m5_time</code> - String
 +
*<code>m6_time</code> - String
 +
*<code>m7_time</code> - String
 +
*<code>m8_1_time</code> - String
 +
*<code>m8_2_time</code> - String
 +
*<code>m9_1_time</code> - String
 +
*<code>m9_2_time</code> - String
 +
*<code>m10_time</code> - String
 +
*<code>m11_time</code> - String
 +
*<code>m12_time</code> - String
 +
*<code>time</code> - String
 +
*<code>time_availability</code> - String
 +
*<code>time2</code> - String
 +
*<code>time2_availability</code> - String
 +
*<code>time3</code> - String
 +
*<code>time3_availability</code> - String
 +
*<code>time4</code> - String
 +
*<code>time4_availability</code> - String
 +
*<code>blathers_quote</code> - String
 +
|}
 +
|  Missing rarity data (common name for rarity percentages TBD).
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_clothing|pg_clothing]]'''
 +
| {{PG}} clothing
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 34 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>es_name</code> - String
 +
*<code>de_name</code> - String
 +
*<code>fr_name</code> - String
 +
*<code>it_name</code> - String
 +
*<code>ja_name</code> - String
 +
*<code>zh_name</code> - String
 +
*<code>in_dnm</code> - Boolean
 +
*<code>in_plus</code> - Boolean
 +
*<code>in_pg</code> - Boolean
 +
*<code>in_e_plus</code> - Boolean
 +
*<code>catalog_num_dnm</code> - Integer
 +
*<code>catalog_num_plus</code> - Integer
 +
*<code>catalog_num_pg</code> - Integer
 +
*<code>catalog_num_e_plus</code> - Integer
 +
*<code>image</code> - String
 +
*<code>texture</code> - String
 +
*<code>rarity_group</code> - String
 +
*<code>hra_base</code> - Integer
 +
*<code>buy</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>availability1</code> - String
 +
*<code>availability1_note</code> - String
 +
*<code>availability2</code> - String
 +
*<code>availability2_note</code> - String
 +
*<code>availability_other</code> - List of String
 +
*<code>availability_other_note</code> - String
 +
*<code>availability_dates</code> - String
 +
*<code>availability_season</code> - String
 +
*<code>style</code> - String
 +
*<code>universal_code</code> - String
 +
*<code>universal_code_plus</code> - String
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_fish|pg_fish]]'''
 +
| {{PG}} fish
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 61 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>number</code> - Integer
 +
*<code>in_dnm</code> - Boolean
 +
*<code>in_plus</code> - Boolean
 +
*<code>in_pg</code> - Boolean
 +
*<code>in_e_plus</code> - Boolean
 +
*<code>num_dnm</code> - Integer
 +
*<code>num_plus</code> - Integer
 +
*<code>num_pg</code> - Integer
 +
*<code>num_e_plus</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>location</code> - String
 +
*<code>location2</code> - String
 +
*<code>shadow_size</code> - String
 +
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>feng_shui</code> - String
 +
*<code>availability</code> - String
 +
*<code>on_animal_island</code> - Boolean
 +
*<code>m1</code> - Boolean
 +
*<code>m2</code> - Boolean
 +
*<code>m3</code> - Boolean
 +
*<code>m4</code> - Boolean
 +
*<code>m5</code> - Boolean
 +
*<code>m6</code> - Boolean
 +
*<code>m7</code> - Boolean
 +
*<code>m8_1</code> - Boolean
 +
*<code>m8_2</code> - Boolean
 +
*<code>m9_1</code> - Boolean
 +
*<code>m9_2</code> - Boolean
 +
*<code>m10</code> - Boolean
 +
*<code>m11</code> - Boolean
 +
*<code>m12</code> - Boolean
 +
*<code>m1_time</code> - String
 +
*<code>m2_time</code> - String
 +
*<code>m3_time</code> - String
 +
*<code>m4_time</code> - String
 +
*<code>m5_time</code> - String
 +
*<code>m6_time</code> - String
 +
*<code>m7_time</code> - String
 +
*<code>m8_1_time</code> - String
 +
*<code>m8_2_time</code> - String
 +
*<code>m9_1_time</code> - String
 +
*<code>m9_2_time</code> - String
 +
*<code>m10_time</code> - String
 +
*<code>m11_time</code> - String
 +
*<code>m12_time</code> - String
 +
*<code>time</code> - String
 +
*<code>time_availability</code> - String
 +
*<code>time2</code> - String
 +
*<code>time2_availability</code> - String
 +
*<code>time3</code> - String
 +
*<code>time3_availability</code> - String
 +
*<code>time4</code> - String
 +
*<code>time4_availability</code> - String
 +
*<code>blathers_quote</code> - Text
 +
|}
 +
| Missing rarity data (common name for rarity percentages TBD).
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_fossil|pg_fossil]]'''
 +
| {{PG}} fossils
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 8 fields}}
 +
|-
 +
|
 +
*<code>number</code> - Integer
 +
*<code>name</code> - String
 +
*<code>image</code> - String
 +
*<code>fossil_group</code> - String
 +
*<code>sell_price</code> - Integer
 +
*<code>hha_base</code> - Integer
 +
*<code>width</code> - Float
 +
*<code>length</code> - Float
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_furniture|pg_furniture]]'''
 +
| {{PG}} furniture
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 47 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>in_dnm</code> - Boolean
 +
*<code>in_plus</code> - Boolean
 +
*<code>in_pg</code> - Boolean
 +
*<code>in_e_plus</code> - Boolean
 +
*<code>catalog_num_dnm</code> - Integer
 +
*<code>catalog_num_plus</code> - Integer
 +
*<code>catalog_num_pg</code> - Integer
 +
*<code>catalog_num_e_plus</code> - Integer
 +
*<code>image_dnm</code> - String
 +
*<code>image_plus</code> - String
 +
*<code>image_pg</code> - String
 +
*<code>image_e_plus</code> - String
 +
*<code>audio</code> - String
 +
*<code>collection</code> - String
 +
*<code>rarity_group</code> - String
 +
*<code>hra_base</code> - Integer
 +
*<code>color</code> - String
 +
*<code>lucky</code> - Boolean
 +
*<code>function</code> - String
 +
*<code>has_surface</code> - Boolean
 +
*<code>buy</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>availability1</code> - String
 +
*<code>availability1_note</code> - String
 +
*<code>availability2</code> - String
 +
*<code>availability2_note</code> - String
 +
*<code>availability3</code> - String
 +
*<code>availability3_note</code> - String
 +
*<code>availability_other</code> - List of String
 +
*<code>availability_other_note</code> - String
 +
*<code>plus_availability</code> - String
 +
*<code>plus_availability_note</code> - String
 +
*<code>length</code> - Integer
 +
*<code>width</code> - Integer
 +
*<code>interactable</code> - Boolean
 +
*<code>interactivity</code> - String
 +
*<code>animated</code> - Boolean
 +
*<code>animation_activation</code> - String
 +
*<code>sound</code> - Boolean
 +
*<code>sound_activation</code> - String
 +
*<code>placeable</code> - Boolean
 +
*<code>placeable_surface</code> - Boolean
 +
*<code>walkable</code> - Boolean
 +
*<code>universal_code</code> - String
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_house|pg_house]]'''
 +
| {{PG}} villager homes (some parts used in villager endpoint)
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 18 fields}}
 +
|-
 +
|
 +
*<code>villager</code> - String
 +
*<code>islander</code> - Boolean
 +
*<code>game</code> - List of String
 +
*<code>interior_image</code> - String
 +
*<code>interior_image_url</code> - String
 +
*<code>exterior_image</code> - String
 +
*<code>exterior_image_url</code> - String
 +
*<code>wallpaper</code> - String
 +
*<code>wallpaper_image</code> - String
 +
*<code>wallpaper_image_url</code> - String
 +
*<code>flooring</code> - String
 +
*<code>flooring_image</code> - String
 +
*<code>flooring_image_url</code> - String
 +
*<code>music</code> - String
 +
*<code>music_note</code> - String
 +
*<code>items</code> - Text
 +
*<code>request_items</code> - Text
 +
*<code>notes</code> - Wikitext string
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_interior|pg_interior]]'''
 +
| {{PG}} wallpaper and flooring
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 30 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>in_dnm</code> - Boolean
 +
*<code>in_plus</code> - Boolean
 +
*<code>in_pg</code> - Boolean
 +
*<code>in_e_plus</code> - Boolean
 +
*<code>catalog_num_dnm</code> - Integer
 +
*<code>catalog_num_plus</code> - Integer
 +
*<code>catalog_num_pg</code> - Integer
 +
*<code>catalog_num_e_plus</code> - Integer
 +
*<code>image</code> - String
 +
*<code>category</code> - String
 +
*<code>category_sort</code> - Integer
 +
*<code>collection</code> - String
 +
*<code>rarity_group</code> - String
 +
*<code>hra_base</code> - Integer
 +
*<code>buy</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>availability1</code> - String
 +
*<code>availability1_note</code> - String
 +
*<code>availability2</code> - String
 +
*<code>availability2_note</code> - String
 +
*<code>availability3</code> - String
 +
*<code>availability3_note</code> - String
 +
*<code>availability_other</code> - List of String
 +
*<code>availability_other_note</code> - String
 +
*<code>plus_availability</code> - String
 +
*<code>plus_availability_note</code> - String
 +
*<code>universal_code</code> - String
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_item|pg_item]]'''
 +
| {{PG}} other items
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 19 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>in_dnm</code> - Boolean
 +
*<code>in_plus</code> - Boolean
 +
*<code>in_pg</code> - Boolean
 +
*<code>in_e_plus</code> - Boolean
 +
*<code>image</code> - String
 +
*<code>buy</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>availability1</code> - String
 +
*<code>availability1_note</code> - String
 +
*<code>availability2</code> - String
 +
*<code>availability2_note</code> - String
 +
*<code>availability3</code> - String
 +
*<code>availability3_note</code> - String
 +
*<code>availability_other</code> - List of String
 +
*<code>availability_other_note</code> - String
 +
*<code>universal_code</code> - String
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_language_name|pg_language_name]]'''
 +
| {{PG}} translations
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 8 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>de_name</code> - String
 +
*<code>es_name</code> - String
 +
*<code>fr_name</code> - String
 +
*<code>it_name</code> - String
 +
*<code>ja_name</code> - String
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_villager|pg_villager]]'''
 +
| {{PG}} villagers (using in villager endpoint)
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 25 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>romanized_name</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>species</code> - String
 +
*<code>gender</code> - String
 +
*<code>personality</code> - String
 +
*<code>sign</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>clothing</code> - String
 +
*<code>clothing_e_plus</code> - String
 +
*<code>clothing_plus</code> - String
 +
*<code>clothing_dnm</code> - String
 +
*<code>umbrella</code> - String
 +
*<code>in_dnm</code> - Boolean
 +
*<code>in_pg</code> - Boolean
 +
*<code>in_e_plus</code> - Boolean
 +
*<code>islander</code> - Boolean
 +
*<code>fav_fruit</code> - String
 +
*<code>allergic_fruit</code> - String
 +
*<code>fav_clothing</code> - String
 +
*<code>least_fav_clothing</code> - String
 +
*<code>song_gift</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/song|song]]'''
 +
| K.K. Slider song cover, audio, and {{SER}} appearances
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 18 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>name_sort</code> - String
 +
*<code>order_number</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>aircheck</code> - String
 +
*<code>aircheck_url</code> - String
 +
*<code>live</code> - String
 +
*<code>live_url</code> - String
 +
*<code>mood</code> - String
 +
*<code>dnm</code> - Boolean
 +
*<code>ac</code> - Boolean
 +
*<code>e_plus</code> - Boolean
 +
*<code>ww</code> - Boolean
 +
*<code>cf</code> - Boolean
 +
*<code>nl</code> - Boolean
 +
*<code>nh</code> - Boolean
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/special_character|special_character]]'''
 +
| Special character info and {{SER}} appearances
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 29 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>name_sort</code> - String
 +
*<code>alt_name</code> - String
 +
*<code>ID</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>nh_phone_texture</code> - String
 +
*<code>nh_phone_texture_url</code> - String
 +
*<code>species</code> - String
 +
*<code>gender</code> - String
 +
*<code>gender_japan</code> - String
 +
*<code>birthday</code> - String
 +
*<code>birthday_month</code> - String
 +
*<code>birthday_day</code> - Integer
 +
*<code>birthday_sort</code> - Integer
 +
*<code>sign</code> - String
 +
*<code>speciespage_debut</code> - String
 +
*<code>dnm</code> - Boolean
 +
*<code>ac</code> - Boolean
 +
*<code>e_plus</code> - Boolean
 +
*<code>ww</code> - Boolean
 +
*<code>cf</code> - Boolean
 +
*<code>nl</code> - Boolean
 +
*<code>wa</code> - Boolean
 +
*<code>nh</code> - Boolean
 +
*<code>film</code> - Boolean
 +
*<code>hhd</code> - Boolean
 +
*<code>pc</code> - Boolean
 
|}
 
|}
 
| -
 
| -
 
|-  
 
|-  
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
−
| '''[[Special:CargoTables/song|song]]'''
+
| '''[[Special:CargoTables/villager|villager]]'''
−
| K.K. Slider song cover, audio, and {{SER}} appearances
+
| {{SER}} villagers
 
|
 
|
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 18 fields}}
+
! {{Colorshow|4c4c4c|Open to view 40 fields}}
 
|-
 
|-
 
|
 
|
Line 1,715: Line 2,227:
 
*<code>name</code> - String
 
*<code>name</code> - String
 
*<code>name_sort</code> - String
 
*<code>name_sort</code> - String
−
*<code>order_number</code> - Integer
+
*<code>alt_name</code> - String
 +
*<code>title_color</code> - String
 +
*<code>text_color</code> - String
 +
*<code>id</code> - String
 
*<code>image</code> - String
 
*<code>image</code> - String
 
*<code>image_url</code> - String
 
*<code>image_url</code> - String
−
*<code>aircheck</code> - String
+
*<code>species</code> - String
−
*<code>aircheck_url</code> - String
+
*<code>personality</code> - String
−
*<code>live</code> - String
+
*<code>personality_note</code> - String
−
*<code>live_url</code> - String
+
*<code>prev_personality</code> - String
−
*<code>mood</code> - String
+
*<code>prev_personality_note</code> - String
 +
*<code>gender</code> - String
 +
*<code>birthday</code> - String
 +
*<code>birthday_month</code> - String
 +
*<code>birthday_day</code> - Integer
 +
*<code>birthday_sort</code> - Integer
 +
*<code>sign</code> - String
 +
*<code>sign_sort</code> - Integer
 +
*<code>quote</code> - String
 +
*<code>phrase</code> - String
 +
*<code>prev_phrase</code> - String
 +
*<code>prev_phrase2</code> - String
 +
*<code>clothing</code> - String
 +
*<code>clothing_nh_var</code> - String
 +
*<code>islander</code> - Boolean
 +
*<code>debut</code> - String
 
*<code>dnm</code> - Boolean
 
*<code>dnm</code> - Boolean
 
*<code>ac</code> - Boolean
 
*<code>ac</code> - Boolean
Line 1,729: Line 2,259:
 
*<code>cf</code> - Boolean
 
*<code>cf</code> - Boolean
 
*<code>nl</code> - Boolean
 
*<code>nl</code> - Boolean
 +
*<code>wa</code> - Boolean
 
*<code>nh</code> - Boolean
 
*<code>nh</code> - Boolean
 +
*<code>film</code> - Boolean
 +
*<code>hhd</code> - Boolean
 +
*<code>pc</code> - Boolean
 
|}
 
|}
 
| -
 
| -
Line 1,735: Line 2,269:
 
| {{Table cell|Yellow}}
 
| {{Table cell|Yellow}}
 
| {{Table cell|No}}
 
| {{Table cell|No}}
−
| '''[[Special:CargoTables/special_character|special_character]]'''
+
| '''[[Special:CargoTables/ww_house|ww_house]]'''
−
| Special character info and {{SER}} appearances
+
| {{WW|short}} villager homes (some parts used in villager endpoint)
 
|
 
|
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 25 fields}}
+
! {{Colorshow|4c4c4c|Open to view 13 fields}}
 
|-
 
|-
 
|
 
|
−
*<code>url</code> - String
+
*<code>villager</code> - String
−
*<code>name</code> - String
+
*<code>interior_image</code> - String
−
*<code>name_sort</code> - String
+
*<code>interior_image_url</code> - String
−
*<code>alt_name</code> - String
+
*<code>wallpaper</code> - String
−
*<code>ID</code> - String
+
*<code>wallpaper_image</code> - String
−
*<code>image</code> - String
+
*<code>wallpaper_image_url</code> - String
−
*<code>image_url</code> - String
+
*<code>flooring</code> - String
−
*<code>species</code> - String
+
*<code>flooring_image</code> - String
−
*<code>gender</code> - String
+
*<code>flooring_image_url</code> - String
−
*<code>gender_japan</code> - String
+
*<code>music</code> - String
−
*<code>birthday</code> - String
+
*<code>music_note</code> - String
−
*<code>birthday_sort</code> - Integer
+
*<code>items</code> - Text
−
*<code>sign</code> - String
+
*<code>notes</code> - Wikitext string
−
*<code>speciespage_debut</code> - String
 
−
*<code>dnm</code> - Boolean
 
−
*<code>ac</code> - Boolean
 
−
*<code>e_plus</code> - Boolean
 
−
*<code>ww</code> - Boolean
 
−
*<code>cf</code> - Boolean
 
−
*<code>nl</code> - Boolean
 
−
*<code>wa</code> - Boolean
 
−
*<code>nh</code> - Boolean
 
−
*<code>film</code> - Boolean
 
−
*<code>hhd</code> - Boolean
 
−
*<code>pc</code> - Boolean
 
−
|}
 
−
| -
 
−
|-
 
−
| {{Table cell|Green}}
 
−
| {{Table cell|Yes}}
 
−
| '''[[Special:CargoTables/villager|villager]]'''
 
−
| {{SER}} villagers
 
−
|
 
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
−
|-
 
−
! {{Colorshow|4c4c4c|Open to view 37 fields}}
 
−
|-
 
−
|
 
−
*<code>url</code> - String
 
−
*<code>name</code> - String
 
−
*<code>name_sort</code> - String
 
−
*<code>alt_name</code> - String
 
−
*<code>titlecolor</code> - String
 
−
*<code>textcolor</code> - String
 
−
*<code>id</code> - String
 
−
*<code>image</code> - String
 
−
*<code>image_url</code> - String
 
−
*<code>species</code> - String
 
−
*<code>personality</code> - String
 
−
*<code>prev_personality</code> - String
 
−
*<code>gender</code> - String
 
−
*<code>birthday</code> - String
 
−
*<code>birthday_month</code> - String
 
−
*<code>birthday_day</code> - Integer
 
−
*<code>birthday_sort</code> - Integer
 
−
*<code>sign</code> - String
 
−
*<code>quote</code> - String
 
−
*<code>phrase</code> - String
 
−
*<code>prev_phrase</code> - String
 
−
*<code>prev_phrase2</code> - String
 
−
*<code>clothing</code> - String
 
−
*<code>clothing_nh_var</code> - String
 
−
*<code>islander</code> - Boolean
 
−
*<code>debut</code> - String
 
−
*<code>dnm</code> - Boolean
 
−
*<code>ac</code> - Boolean
 
−
*<code>e_plus</code> - Boolean
 
−
*<code>ww</code> - Boolean
 
−
*<code>cf</code> - Boolean
 
−
*<code>nl</code> - Boolean
 
−
*<code>wa</code> - Boolean
 
−
*<code>nh</code> - Boolean
 
−
*<code>film</code> - Boolean
 
−
*<code>hhd</code> - Boolean
 
−
*<code>pc</code> - Boolean
 
 
|}
 
|}
 
| -
 
| -
Line 1,834: Line 2,306:
 
*<code>name_sort</code> - String
 
*<code>name_sort</code> - String
 
*<code>pic</code> - String
 
*<code>pic</code> - String
−
*<code>quote - String
+
*<code>quote</code> - String
 
*<code>favclothing</code> - String
 
*<code>favclothing</code> - String
 
*<code>leastfavclothing</code> - String
 
*<code>leastfavclothing</code> - String

Latest revision as of 02:53, April 24, 2021

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
 -
Retrieved from "https://nookipedia.com/w/index.php?title=Nookipedia:Project_Database/List_of_tables&oldid=570949"