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

From Nookipedia, the Animal Crossing wiki
(Adding PG fossils)
m
 
(17 intermediate revisions by 4 users 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:''' 13:42, September 8, 2020 (EDT)
+
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 22: Line 22:
 
! style="min-width:235px;"| Structure
 
! style="min-width:235px;"| Structure
 
! Notes
 
! Notes
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/amiibo_card|amiibo_card]]'''
 +
| [[Amiibo]] cards
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 7 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>number</code> - String
 +
*<code>image_front</code> - String
 +
*<code>dice</code> - Integer
 +
*<code>hand</code> - String
 +
*<code>birthday</code> - String
 +
*<code>sign</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/cf_art|cf_art]]'''
 +
| {{CF|short}} art
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 11 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>has_fake</code> - Boolean
 +
*<code>buy_price</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>availability</code> - String
 +
*<code>availability_note</code> - String
 +
*<code>authenticity</code> - String
 +
*<code>width</code> - Float
 +
*<code>length</code> - Float
 +
|}
 +
| Missing art textures
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/cf_bug|cf_bug]]'''
 +
| {{CF|short}} bugs
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 57 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>number</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>catchphrase2</code> - String
 +
*<code>size</code> - String
 +
*<code>location</code> - String
 +
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>availability</code> - String
 +
*<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>peaktime</code> - String
 +
*<code>peaktime_availability</code> - String
 +
*<code>peaktime2</code> - String
 +
*<code>peaktime_availability2</code> - String
 +
*<code>peaktime3</code> - String
 +
*<code>peaktime_availability3</code> - String
 +
*<code>peaktime4</code> - String
 +
*<code>peaktime_availability4</code> - String
 +
*<code>description</code> - Text
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/cf_fish|cf_fish]]'''
 +
| {{CF|short}} fish
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 56 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>number</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>description</code> - Text
 +
*<code>catchphrase</code> - String
 +
*<code>catchphrase2</code> - String
 +
*<code>location</code> - String
 +
*<code>shadow_size</code> - String
 +
*<code>fish_size</code> - String
 +
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>availability</code> - String
 +
*<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>peaktime</code> - String
 +
*<code>peaktime_availability</code> - String
 +
*<code>peaktime2</code> - String
 +
*<code>peaktime_availability2</code> - String
 +
*<code>peaktime3</code> - String
 +
*<code>peaktime_availability3</code> - String
 +
*<code>peaktime4</code> - String
 +
*<code>peaktime_availability4</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/cf_house|cf_house]]'''
 +
| {{CF|short}} 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 13 fields}}
 +
|-
 +
|
 +
*<code>villager</code> - String
 +
*<code>interior_image</code> - String
 +
*<code>interior_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>notes</code> - Wikitext string
 +
|}
 +
| -
 
|-  
 
|-  
 
| {{Table cell|Gray}}
 
| {{Table cell|Gray}}
Line 28: Line 237:
 
| {{CF|short}} villagers
 
| {{CF|short}} villagers
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
 
! {{Colorshow|4c4c4c|Open to view 7 fields}}
 
! {{Colorshow|4c4c4c|Open to view 7 fields}}
Line 40: Line 249:
 
*<code>favseries</code> - String
 
*<code>favseries</code> - String
 
*<code>favcolor</code> - String
 
*<code>favcolor</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/e_card|e_card]]'''
 +
| [[e-Reader card]]s
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 10 fields}}
 +
|-
 +
|
 +
*<code>villager</code> - String
 +
*<code>number</code> - String
 +
*<code>image_front</code> - String
 +
*<code>image_back</code> - String
 +
*<code>gender</code> - String
 +
*<code>sign</code> - String
 +
*<code>clothes</code> - String
 +
*<code>phrase</code> - String
 +
*<code>description</code> - String
 +
*<code>password_line1</code> - String
 +
*<code>password_line2</code> - String
 
|}
 
|}
 
| -
 
| -
Line 45: Line 278:
 
| {{Table cell|Yellow}}
 
| {{Table cell|Yellow}}
 
| {{Table cell|No}}
 
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/furniture_collection|furniture_collection]]'''
 +
| Furniture collection (such as series, sets, and themes) across the series
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 17 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>image</code> - String
 +
*<code>type1</code> - String
 +
*<code>type1_note</code> - String
 +
*<code>type2</code> - String
 +
*<code>type2_note</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>nlwa</code> - Boolean
 +
*<code>nh</code> - Boolean
 +
*<code>hhd</code> - Boolean
 +
*<code>pc</code> - Boolean
 +
|}
 +
| Missing images in some pages.
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_art|nh_art]]'''
 
| '''[[Special:CargoTables/nh_art|nh_art]]'''
 
| {{NH|short}} art
 
| {{NH|short}} art
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 27 fields}}
 
|-
 
|-
 
|
 
|
Line 59: Line 322:
 
*<code>fake_image</code> - String
 
*<code>fake_image</code> - String
 
*<code>fake_image_url</code> - String
 
*<code>fake_image_url</code> - String
 +
*<code>texture</code> - String
 +
*<code>texture_url</code> - String
 +
*<code>fake_texture</code> - String
 +
*<code>fake_texture_url</code> - String
 
*<code>art_name</code> - String
 
*<code>art_name</code> - String
 
*<code>author</code> - String
 
*<code>author</code> - String
 
*<code>year</code> - String
 
*<code>year</code> - String
 
*<code>art_style</code> - String
 
*<code>art_style</code> - String
 +
*<code>art_type</code> - String
 
*<code>description</code> - Text
 
*<code>description</code> - Text
 +
*<code>theme1</code> - String
 +
*<code>theme2</code> - String
 +
*<code>theme_fake</code> - String
 
*<code>buy_price</code> - Integer
 
*<code>buy_price</code> - Integer
−
*<code>sell_price</code> - Integer
+
*<code>buy_wikitext</code> - Wikitext string
 +
*<code>sell</code> - Integer
 
*<code>availability</code> - String
 
*<code>availability</code> - String
 
*<code>availability_note</code> - String
 
*<code>availability_note</code> - String
Line 79: Line 351:
 
| {{NH|short}} bugs
 
| {{NH|short}} bugs
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 41 fields}}
+
! {{Colorshow|4c4c4c|Open to view 73 fields}}
 
|-
 
|-
 
|
 
|
Line 89: Line 361:
 
*<code>image</code> - String
 
*<code>image</code> - String
 
*<code>image_url</code> - String
 
*<code>image_url</code> - String
 +
*<code>render</code> - String
 +
*<code>render_url</code> - String
 
*<code>catchphrase</code> - String
 
*<code>catchphrase</code> - String
 
*<code>catchphrase2</code> - String
 
*<code>catchphrase2</code> - String
 +
*<code>location</code> - String
 +
*<code>rarity</code> - String
 +
*<code>total_catch</code> - Integer
 +
*<code>sell_nook</code> - Integer
 +
*<code>sell_flick</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 
*<code>n_availability</code> - String
 
*<code>n_availability</code> - String
 
*<code>n_m1</code> - Boolean
 
*<code>n_m1</code> - Boolean
Line 104: Line 385:
 
*<code>n_m11</code> - Boolean
 
*<code>n_m11</code> - Boolean
 
*<code>n_m12</code> - Boolean
 
*<code>n_m12</code> - Boolean
 +
*<code>n_m1_time</code> - String
 +
*<code>n_m2_time</code> - String
 +
*<code>n_m3_time</code> - String
 +
*<code>n_m4_time</code> - String
 +
*<code>n_m5_time</code> - String
 +
*<code>n_m6_time</code> - String
 +
*<code>n_m7_time</code> - String
 +
*<code>n_m8_time</code> - String
 +
*<code>n_m9_time</code> - String
 +
*<code>n_m10_time</code> - String
 +
*<code>n_m11_time</code> - String
 +
*<code>n_m12_time</code> - String
 
*<code>s_availability</code> - String
 
*<code>s_availability</code> - String
 
*<code>s_m1</code> - Boolean
 
*<code>s_m1</code> - Boolean
Line 117: Line 410:
 
*<code>s_m11</code> - Boolean
 
*<code>s_m11</code> - Boolean
 
*<code>s_m12</code> - Boolean
 
*<code>s_m12</code> - Boolean
 +
*<code>s_m1_time</code> - String
 +
*<code>s_m2_time</code> - String
 +
*<code>s_m3_time</code> - String
 +
*<code>s_m4_time</code> - String
 +
*<code>s_m5_time</code> - String
 +
*<code>s_m6_time</code> - String
 +
*<code>s_m7_time</code> - String
 +
*<code>s_m8_time</code> - String
 +
*<code>s_m9_time</code> - String
 +
*<code>s_m10_time</code> - String
 +
*<code>s_m11_time</code> - String
 +
*<code>s_m12_time</code> - String
 +
*<code>weather</code> - String
 
*<code>time</code> - String
 
*<code>time</code> - String
−
*<code>location</code> - String
+
*<code>time_n_availability</code> - String
−
*<code>rarity</code> - String
+
*<code>time_s_availability</code> - String
−
*<code>total_catch</code> - Integer
+
*<code>time2</code> - String
−
*<code>sell_nook</code> - Integer
+
*<code>time2_n_availability</code> - String
−
*<code>sell_flick</code> - Integer
+
*<code>time2_s_availability</code> - String
−
*<code>tank_width</code> - Float
 
−
*<code>tank_length</code> - Float
 
 
|}
 
|}
 
|  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
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 57 fields}}
 
|-
 
|-
 
|
 
|
Line 160: Line 481:
 
*<code>availability2</code> - String
 
*<code>availability2</code> - String
 
*<code>availability2_note</code> - String
 
*<code>availability2_note</code> - String
 +
*<code>variation_total</code> - Integer
 
*<code>vill_equip</code> - Boolean
 
*<code>vill_equip</code> - Boolean
 +
*<code>seasonality</code> - String
 +
*<code>gender</code> - String
 +
*<code>vill_gender</code> - String
 +
*<code>spring</code> - Integer
 +
*<code>summer</code> - Integer
 +
*<code>autumn</code> - Integer
 +
*<code>winter</code> - Integer
 +
*<code>china</code> - Integer
 +
*<code>birthday</code> - Integer
 +
*<code>book</code> - Integer
 +
*<code>sleep</code> - Integer
 +
*<code>bug_catching</code> - Integer
 +
*<code>japanese</code> - Integer
 +
*<code>fishing</code> - Integer
 +
*<code>usually</code> - Integer
 +
*<code>fashion</code> - Integer
 +
*<code>rain</code> - Integer
 +
*<code>birthday_main</code> - Integer
 +
*<code>countdown</code> - Integer
 +
*<code>snow</code> - Integer
 +
*<code>sports</code> - Integer
 +
*<code>yoga</code> - Integer
 +
*<code>sunbathing</code> - Integer
 +
*<code>concert</code> - Integer
 +
*<code>bunny_day</code> - Integer
 +
*<code>fireworks</code> - Integer
 +
*<code>halloween</code> - Integer
 +
*<code>turkey_day_plaza</code> - Integer
 +
*<code>turkey_day_home</code> - Integer
 +
*<code>toy_day</code> - Integer
 
*<code>version_added</code> - String
 
*<code>version_added</code> - String
 
*<code>unlocked</code> - Boolean
 
*<code>unlocked</code> - Boolean
 
*<code>notes</code> - String
 
*<code>notes</code> - String
 
|}
 
|}
−
| -
+
| Needs populating with the new data. (Integers should be replaced with booleans)
 
|-  
 
|-  
 
| {{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
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 6 fields}}
+
! {{Colorshow|4c4c4c|Open to view 10 fields}}
 
|-
 
|-
 
|
 
|
Line 180: Line 532:
 
*<code>en_name</code> - String
 
*<code>en_name</code> - String
 
*<code>variation</code> - String
 
*<code>variation</code> - String
 +
*<code>variation_number</code> - Integer
 
*<code>image</code> - String
 
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>image_storage</code> - String
 +
*<code>image_storage_url</code> - String
 
*<code>color1</code> - String
 
*<code>color1</code> - String
 
*<code>color2</code> - String
 
*<code>color2</code> - String
Line 191: Line 547:
 
| {{NH|short}} fish
 
| {{NH|short}} fish
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 48 fields}}
+
! {{Colorshow|4c4c4c|Open to view 75 fields}}
 
|-
 
|-
 
|
 
|
Line 201: Line 557:
 
*<code>image</code> - String
 
*<code>image</code> - String
 
*<code>image_url</code> - String
 
*<code>image_url</code> - String
 +
*<code>render</code> - String
 +
*<code>render_url</code> - String
 
*<code>catchphrase</code> - String
 
*<code>catchphrase</code> - String
 
*<code>catchphrase2</code> - String
 
*<code>catchphrase2</code> - String
 
*<code>catchphrase3</code> - String
 
*<code>catchphrase3</code> - String
 +
*<code>location</code> - String
 +
*<code>shadow_size</code> - String
 +
*<code>rarity</code> - String
 +
*<code>total_catch</code> - Integer
 +
*<code>sell_nook</code> - Integer
 +
*<code>sell_cj</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 
*<code>n_availability</code> - String
 
*<code>n_availability</code> - String
 
*<code>n_m1</code> - Boolean
 
*<code>n_m1</code> - Boolean
Line 217: Line 583:
 
*<code>n_m11</code> - Boolean
 
*<code>n_m11</code> - Boolean
 
*<code>n_m12</code> - Boolean
 
*<code>n_m12</code> - Boolean
 +
*<code>n_m1_time</code> - String
 +
*<code>n_m2_time</code> - String
 +
*<code>n_m3_time</code> - String
 +
*<code>n_m4_time</code> - String
 +
*<code>n_m5_time</code> - String
 +
*<code>n_m6_time</code> - String
 +
*<code>n_m7_time</code> - String
 +
*<code>n_m8_time</code> - String
 +
*<code>n_m9_time</code> - String
 +
*<code>n_m10_time</code> - String
 +
*<code>n_m11_time</code> - String
 +
*<code>n_m12_time</code> - String
 
*<code>s_availability</code> - String
 
*<code>s_availability</code> - String
 
*<code>s_m1</code> - Boolean
 
*<code>s_m1</code> - Boolean
Line 230: Line 608:
 
*<code>s_m11</code> - Boolean
 
*<code>s_m11</code> - Boolean
 
*<code>s_m12</code> - Boolean
 
*<code>s_m12</code> - Boolean
 +
*<code>s_m1_time</code> - String
 +
*<code>s_m2_time</code> - String
 +
*<code>s_m3_time</code> - String
 +
*<code>s_m4_time</code> - String
 +
*<code>s_m5_time</code> - String
 +
*<code>s_m6_time</code> - String
 +
*<code>s_m7_time</code> - String
 +
*<code>s_m8_time</code> - String
 +
*<code>s_m9_time</code> - String
 +
*<code>s_m10_time</code> - String
 +
*<code>s_m11_time</code> - String
 +
*<code>s_m12_time</code> - String
 
*<code>time</code> - String
 
*<code>time</code> - String
 
*<code>time_n_availability</code> - String
 
*<code>time_n_availability</code> - String
Line 236: Line 626:
 
*<code>time2_n_availability</code> - String
 
*<code>time2_n_availability</code> - String
 
*<code>time2_s_availability</code> - String
 
*<code>time2_s_availability</code> - String
−
*<code>location</code> - String
+
*<code>description</code> - Text
−
*<code>shadow_size</code> - String
 
−
*<code>rarity</code> - String
 
−
*<code>total_catch</code> - Integer
 
−
*<code>sell_nook</code> - Integer
 
−
*<code>sell_cj</code> - Integer
 
−
*<code>tank_width</code> - Float
 
−
*<code>tank_length</code> - Float
 
 
|}
 
|}
−
| Missing rarity data (common name for rarity percentages TBD).  
+
| Missing rarity data (common name for rarity percentages TBD). Needs description filling.
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nh_fossil|nh_fossil]]'''
 +
| {{NH|short}} fossils
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
 +
! {{Colorshow|4c4c4c|Open to view 11 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>fossil_group</code> - String
 +
*<code>interactable</code> - Boolean
 +
*<code>sell</code> - Integer
 +
*<code>color1</code> - String
 +
*<code>color2</code> - String
 +
*<code>hha_base</code> - Integer
 +
*<code>width</code> - Float
 +
*<code>length</code> - Float
 +
|}
 +
| -
 +
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
 
| {{Table cell|No}}
 
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nh_fossil_group|nh_fossil_group]]'''
 +
| {{NH|short}} fossil groups
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 3 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>room</code> - Integer
 +
*<code>description</code> - Text
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_furniture|nh_furniture]]'''
 
| '''[[Special:CargoTables/nh_furniture|nh_furniture]]'''
 
| {{NH|short}} furniture
 
| {{NH|short}} furniture
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 41 fields}}
+
! {{Colorshow|4c4c4c|Open to view 50 fields}}
 
|-
 
|-
 
|
 
|
Line 265: Line 688:
 
*<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>tag</code> - String
 
*<code>hha_base</code> - Integer
 
*<code>hha_base</code> - Integer
 +
*<code>lucky</code> - Boolean
 +
*<code>lucky_season</code> - String
 
*<code>function1</code> - String
 
*<code>function1</code> - String
 
*<code>function2</code> - String
 
*<code>function2</code> - String
Line 280: Line 706:
 
*<code>availability2</code> - String
 
*<code>availability2</code> - String
 
*<code>availability2_note</code> - String
 
*<code>availability2_note</code> - String
 +
*<code>availability3</code> - String
 +
*<code>availability3_note</code> - String
 +
*<code>variation_total</code> - Integer
 +
*<code>pattern_total</code> - Integer
 
*<code>customizable</code> - Boolean
 
*<code>customizable</code> - Boolean
 
*<code>custom_kits</code> - Integer
 
*<code>custom_kits</code> - Integer
 +
*<code>custom_kit_type</code> - String
 
*<code>custom_body_part</code> - String
 
*<code>custom_body_part</code> - String
 
*<code>custom_pattern_part</code> - String
 
*<code>custom_pattern_part</code> - String
Line 295: Line 726:
 
*<code>lighting</code> - Boolean
 
*<code>lighting</code> - Boolean
 
*<code>door_decor</code> - Boolean
 
*<code>door_decor</code> - Boolean
 +
*<code>is_material</code> - Boolean
 
*<code>version_added</code> - String
 
*<code>version_added</code> - String
 
*<code>unlocked</code> - Boolean
 
*<code>unlocked</code> - Boolean
Line 302: 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
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
 
! {{Colorshow|4c4c4c|Open to view 7 fields}}
 
! {{Colorshow|4c4c4c|Open to view 7 fields}}
Line 314: Line 746:
 
*<code>en_name</code> - String
 
*<code>en_name</code> - String
 
*<code>variation</code> - String
 
*<code>variation</code> - String
 +
*<code>variation_number</code> - Integer
 
*<code>pattern</code> - String
 
*<code>pattern</code> - String
 +
*<code>pattern_number</code> - Integer
 
*<code>image</code> - String
 
*<code>image</code> - String
 +
*<code>image_url</code> - String
 
*<code>color1</code> - String
 
*<code>color1</code> - String
 
*<code>color2</code> - String
 
*<code>color2</code> - String
Line 326: Line 761:
 
| {{NH|short}} villager homes (some parts used in villager endpoint)
 
| {{NH|short}} villager homes (some parts used in villager endpoint)
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 15 fields}}
+
! {{Colorshow|4c4c4c|Open to view 18 fields}}
 
|-
 
|-
 
|
 
|
 
*<code>villager</code> - String
 
*<code>villager</code> - String
 +
*<code>name_sort</code> - String
 
*<code>interior_image</code> - String
 
*<code>interior_image</code> - String
 
*<code>interior_image_url</code> - String
 
*<code>interior_image_url</code> - String
Line 344: Line 780:
 
*<code>music</code> - String
 
*<code>music</code> - String
 
*<code>music_note</code> - String
 
*<code>music_note</code> - String
 +
*<code>music_image</code> - String
 +
*<code>music_image_url</code> - String
 
*<code>items</code> - Text
 
*<code>items</code> - Text
 
*<code>notes</code> - Wikitext string
 
*<code>notes</code> - Wikitext string
Line 350: 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
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 32 fields}}
 
|-
 
|-
 
|
 
|
Line 362: Line 800:
 
*<code>en_name</code> - String
 
*<code>en_name</code> - String
 
*<code>image</code> - String
 
*<code>image</code> - String
 +
*<code>image_url</code> - String
 
*<code>category</code> - String
 
*<code>category</code> - String
 +
*<code>category_sort</code> - Integer
 
*<code>item_series</code> - String
 
*<code>item_series</code> - String
 +
*<code>item_set</code> - String
 
*<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 381: Line 825:
 
*<code>color1</code> - String
 
*<code>color1</code> - String
 
*<code>color2</code> - String
 
*<code>color2</code> - String
 +
*<code>is_material</code> - Boolean
 +
*<code>version_added</code> - String
 +
*<code>unlocked</code> - Boolean
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|Yes}}
 +
| '''[[Special:CargoTables/nh_item|nh_item]]'''
 +
| {{NH|short}} other items
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 28 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>stack</code> - Integer
 +
*<code>hha_base</code> - Integer
 +
*<code>buy1_price</code> - Integer
 +
*<code>buy1_currency</code> - String
 +
*<code>buy1_wikitext</code> - Wikitext string
 +
*<code>sell</code> - Integer
 +
*<code>is_fence</code> - Boolean
 +
*<code>is_material</code> - Boolean
 +
*<code>material_type</code> - String
 +
*<code>material_seasonality</code> - String
 +
*<code>material_sort</code> - Integer
 +
*<code>material_name_sort</code> - Integer
 +
*<code>material_seasonality_sort</code> - Integer
 +
*<code>edible</code> - Boolean
 +
*<code>plant_type</code> - String
 +
*<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>version_added</code> - String
 
*<code>version_added</code> - String
 
*<code>unlocked</code> - Boolean
 
*<code>unlocked</code> - Boolean
Line 392: Line 878:
 
| {{NH|short}} furniture translations
 
| {{NH|short}} furniture translations
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
 
! {{Colorshow|4c4c4c|Open to view 15 fields}}
 
! {{Colorshow|4c4c4c|Open to view 15 fields}}
Line 420: Line 906:
 
| {{NH|short}} KK records
 
| {{NH|short}} KK records
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
 
! {{Colorshow|4c4c4c|Open to view 23 fields}}
 
! {{Colorshow|4c4c4c|Open to view 23 fields}}
Line 452: 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
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 27 fields}}
 
|-
 
|-
 
|
 
|
 
*<code>identifier</code> - String
 
*<code>identifier</code> - String
 
*<code>en_name</code> - String
 
*<code>en_name</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 490: 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
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 6 fields}}
+
! {{Colorshow|4c4c4c|Open to view 8 fields}}
 
|-
 
|-
 
|
 
|
Line 502: Line 990:
 
*<code>en_name</code> - String
 
*<code>en_name</code> - String
 
*<code>variation</code> - String
 
*<code>variation</code> - String
 +
*<code>variation_number</code> - Integer
 
*<code>image</code> - String
 
*<code>image</code> - String
 +
*<code>image_url</code> - String
 
*<code>color1</code> - String
 
*<code>color1</code> - String
 
*<code>color2</code> - String
 
*<code>color2</code> - String
Line 509: Line 999:
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
−
| {{Table cell|No}}
+
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_recipe|nh_recipe]]'''
 
| '''[[Special:CargoTables/nh_recipe|nh_recipe]]'''
 
| {{NH|short}} DIY recipes
 
| {{NH|short}} DIY recipes
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 30 fields}}
+
! {{Colorshow|4c4c4c|Open to view 32 fields}}
 
|-
 
|-
 
|
 
|
Line 521: Line 1,011:
 
*<code>en_name</code> - String
 
*<code>en_name</code> - String
 
*<code>image</code> - String
 
*<code>image</code> - String
 +
*<code>image_url</code> - String
 
*<code>serial_id</code> - Integer
 
*<code>serial_id</code> - Integer
 +
*<code>type</code> - String
 
*<code>buy1_price</code> - Integer
 
*<code>buy1_price</code> - Integer
 
*<code>buy1_currency</code> - String
 
*<code>buy1_currency</code> - String
Line 556: Line 1,048:
 
| {{NH|short}} sea creatures
 
| {{NH|short}} sea creatures
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 41 fields}}
+
! {{Colorshow|4c4c4c|Open to view 72 fields}}
 
|-
 
|-
 
|
 
|
Line 566: Line 1,058:
 
*<code>image</code> - String
 
*<code>image</code> - String
 
*<code>image_url</code> - String
 
*<code>image_url</code> - String
 +
*<code>render</code> - String
 +
*<code>render_url</code> - String
 
*<code>catchphrase</code> - String
 
*<code>catchphrase</code> - String
 
*<code>catchphrase2</code> - String
 
*<code>catchphrase2</code> - String
 +
*<code>shadow_size</code> - String
 +
*<code>shadow_movement</code> - String
 +
*<code>rarity</code> - String
 +
*<code>total_catch</code> - Integer
 +
*<code>sell_nook</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 
*<code>n_availability</code> - String
 
*<code>n_availability</code> - String
 
*<code>n_m1</code> - Boolean
 
*<code>n_m1</code> - Boolean
Line 581: Line 1,082:
 
*<code>n_m11</code> - Boolean
 
*<code>n_m11</code> - Boolean
 
*<code>n_m12</code> - Boolean
 
*<code>n_m12</code> - Boolean
 +
*<code>n_m1_time</code> - String
 +
*<code>n_m2_time</code> - String
 +
*<code>n_m3_time</code> - String
 +
*<code>n_m4_time</code> - String
 +
*<code>n_m5_time</code> - String
 +
*<code>n_m6_time</code> - String
 +
*<code>n_m7_time</code> - String
 +
*<code>n_m8_time</code> - String
 +
*<code>n_m9_time</code> - String
 +
*<code>n_m10_time</code> - String
 +
*<code>n_m11_time</code> - String
 +
*<code>n_m12_time</code> - String
 
*<code>s_availability</code> - String
 
*<code>s_availability</code> - String
 
*<code>s_m1</code> - Boolean
 
*<code>s_m1</code> - Boolean
Line 594: Line 1,107:
 
*<code>s_m11</code> - Boolean
 
*<code>s_m11</code> - Boolean
 
*<code>s_m12</code> - Boolean
 
*<code>s_m12</code> - Boolean
 +
*<code>s_m1_time</code> - String
 +
*<code>s_m2_time</code> - String
 +
*<code>s_m3_time</code> - String
 +
*<code>s_m4_time</code> - String
 +
*<code>s_m5_time</code> - String
 +
*<code>s_m6_time</code> - String
 +
*<code>s_m7_time</code> - String
 +
*<code>s_m8_time</code> - String
 +
*<code>s_m9_time</code> - String
 +
*<code>s_m10_time</code> - String
 +
*<code>s_m11_time</code> - String
 +
*<code>s_m12_time</code> - String
 
*<code>time</code> - String
 
*<code>time</code> - String
−
*<code>shadow_size</code> - String
+
*<code>time_n_availability</code> - String
−
*<code>shadow_movement</code> - String
+
*<code>time_s_availability</code> - String
−
*<code>rarity</code> - String
+
*<code>time2</code> - String
−
*<code>total_catch</code> - Integer
+
*<code>time2_n_availability</code> - String
−
*<code>sell_nook</code> - Integer
+
*<code>time2_s_availability</code> - String
−
*<code>tank_width</code> - Float
 
−
*<code>tank_length</code> - Float
 
 
|}
 
|}
 
| Missing rarity data (common name for rarity percentages TBD).
 
| Missing rarity data (common name for rarity percentages TBD).
 
|-
 
|-
 
| {{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
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 24 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_url</code> - String
 
*<code>hha_base</code> - Integer
 
*<code>hha_base</code> - Integer
 
*<code>buy1_price</code> - Integer
 
*<code>buy1_price</code> - Integer
Line 633: Line 1,157:
 
*<code>availability3</code> - String
 
*<code>availability3</code> - String
 
*<code>availability3_note</code> - String
 
*<code>availability3_note</code> - String
 +
*<code>availability4</code> - String
 +
*<code>availability4_note</code> - String
 
*<code>customizable</code> - Boolean
 
*<code>customizable</code> - Boolean
 
*<code>custom_kits</code> - Integer
 
*<code>custom_kits</code> - Integer
 
*<code>custom_body_part</code> - String
 
*<code>custom_body_part</code> - String
 +
*<code>is_material</code> - Boolean
 
*<code>version_added</code> - String
 
*<code>version_added</code> - String
 
*<code>unlocked</code> - Boolean
 
*<code>unlocked</code> - Boolean
Line 643: 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
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 6 fields}}
+
! {{Colorshow|4c4c4c|Open to view 8 fields}}
 
|-
 
|-
 
|
 
|
Line 655: Line 1,182:
 
*<code>en_name</code> - String
 
*<code>en_name</code> - String
 
*<code>variation</code> - String
 
*<code>variation</code> - String
 +
*<code>variation_number</code> - Integer
 
*<code>image</code> - String
 
*<code>image</code> - String
 +
*<code>image_url</code> - String
 
*<code>color1</code> - String
 
*<code>color1</code> - String
 
*<code>color2</code> - String
 
*<code>color2</code> - String
Line 666: Line 1,195:
 
| {{NH|short}} villagers (using in villager endpoint)
 
| {{NH|short}} villagers (using in villager endpoint)
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 25 fields}}
Line 673: Line 1,202:
 
*<code>url</code> - String
 
*<code>url</code> - String
 
*<code>name</code> - String
 
*<code>name</code> - String
 +
*<code>name_sort</code> - String
 
*<code>image</code> - String
 
*<code>image</code> - String
 
*<code>image_url</code> - String
 
*<code>image_url</code> - String
Line 690: Line 1,220:
 
*<code>clothing</code> - String
 
*<code>clothing</code> - String
 
*<code>clothing_variation</code> - String
 
*<code>clothing_variation</code> - String
 +
*<code>umbrella</code> - String
 
*<code>new</code> - Boolean
 
*<code>new</code> - Boolean
 
*<code>fav_style1</code> - String
 
*<code>fav_style1</code> - String
Line 696: Line 1,227:
 
*<code>fav_color2</code> - String
 
*<code>fav_color2</code> - String
 
*<code>hobby</code> - String
 
*<code>hobby</code> - String
 +
*<code>life_points</code> - String
 +
*<code>hobby_points</code> - String
 +
*<code>wave_type</code> - String
 +
*<code>bag</code> - String
 +
*<code>popsicle</code> - String
 +
*<code>food</code> - String
 +
*<code>drink</code> - String
 +
*<code>book</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nl_art|nl_art]]'''
 +
| {{NL|short}} art
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 19 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>has_fake</code> - Boolean
 +
*<code>fake_image</code> - String
 +
*<code>fake_image_url</code> - String
 +
*<code>art_name</code> - String
 +
*<code>author</code> - String
 +
*<code>year</code> - String
 +
*<code>art_style</code> - String
 +
*<code>art_type</code> - String
 +
*<code>description</code> - Text
 +
*<code>buy_price</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>availability</code> - String
 +
*<code>availability_note</code> - String
 +
*<code>authenticity</code> - String
 +
*<code>width</code> - Float
 +
*<code>length</code> - Float
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nl_bug|nl_bug]]'''
 +
| {{NL|short}} bugs
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 64 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>number</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>catchphrase2</code> - String
 +
*<code>size</code> - String
 +
*<code>location</code> - String
 +
*<code>location2</code> - String
 +
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>sell_pre_wa</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>availability</code> - String
 +
*<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>on_tortimer_island</code> - Boolean
 +
*<code>on_island_tour</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>tortimer_island_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>peaktime</code> - String
 +
*<code>peaktime_availability</code> - String
 +
*<code>peaktime2</code> - String
 +
*<code>peaktime2_availability</code> - String
 +
*<code>peaktime3</code> - String
 +
*<code>peaktime3_availability</code> - String
 +
*<code>peaktime4</code> - String
 +
*<code>peaktime4_availability</code> - String
 +
*<code>description</code> - Text
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nl_fish|nl_fish]]'''
 +
| {{NL|short}} fish
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 64 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>number</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>catchphrase2</code> - String
 +
*<code>location</code> - String
 +
*<code>shadow_size</code> - String
 +
*<code>fish_size</code> - String
 +
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>sell_pre_wa</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>availability</code> - String
 +
*<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>on_tortimer_island</code> - Boolean
 +
*<code>on_island_tour</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>tortimer_island_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>peaktime</code> - String
 +
*<code>peaktime_availability</code> - String
 +
*<code>peaktime2</code> - String
 +
*<code>peaktime2_availability</code> - String
 +
*<code>peaktime3</code> - String
 +
*<code>peaktime3_availability</code> - String
 +
*<code>peaktime4</code> - String
 +
*<code>peaktime4_availability</code> - String
 +
*<code>description</code> - Text
 +
|}
 +
| Missing rarity data (common name for rarity percentages TBD).
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nl_house|nl_house]]'''
 +
| {{NL|short}} villager homes
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 16 fields}}
 +
|-
 +
|
 +
*<code>villager</code> - String
 +
*<code>name_sort</code> - 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>notes</code> - Wikitext string
 
|}
 
|}
 
| -
 
| -
 
|-  
 
|-  
−
| {{Table cell|Gray}}
+
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nl_sea_creature|nl_sea_creature]]'''
 +
| {{NL|short}} sea creatures
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 65 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>number</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>catchphrase2</code> - String
 +
*<code>sea_creature_size</code> - String
 +
*<code>shadow_size</code> - String
 +
*<code>shadow_movement</code> - String
 +
*<code>location</code> - String
 +
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>sell_pre_wa</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>availability</code> - String
 +
*<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>on_tortimer_island</code> - Boolean
 +
*<code>on_island_tour</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>tortimer_island_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>peaktime</code> - String
 +
*<code>peaktime_availability</code> - String
 +
*<code>peaktime2</code> - String
 +
*<code>peaktime_availability2</code> - String
 +
*<code>peaktime3</code> - String
 +
*<code>peaktime_availability3</code> - String
 +
*<code>peaktime4</code> - String
 +
*<code>peaktime_availability4</code> - String
 +
*<code>description</code> - Text
 +
|}
 +
| Missing rarity data (common name for rarity percentages TBD).
 +
|-
 +
| {{Table cell|Yellow}}
 
| {{Table cell|No}}
 
| {{Table cell|No}}
 
| '''[[Special:CargoTables/nl_villager|nl_villager]]'''
 
| '''[[Special:CargoTables/nl_villager|nl_villager]]'''
−
| {{NL|short}} villager preferences
+
| {{NL|short}} villagers
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 14 fields}}
+
! {{Colorshow|4c4c4c|Open to view 32 fields}}
 
|-
 
|-
 
|
 
|
 
*<code>name</code> - String
 
*<code>name</code> - String
 
*<code>name_sort</code> - String
 
*<code>name_sort</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>image_nlwa</code> - String
 +
*<code>image_nlwa_url</code> - String
 
*<code>pic</code> - String
 
*<code>pic</code> - String
 +
*<code>pic_url</code> - String
 +
*<code>icon</code> - String
 +
*<code>icon_url</code> - String
 +
*<code>birthday</code> - String
 +
*<code>birthday_sort</code> - Integer
 +
*<code>sign</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>catchphrase_note</code> - String
 +
*<code>catchphrase2</code> - String
 +
*<code>catchphrase2_note</code> - String
 
*<code>quote</code> - String
 
*<code>quote</code> - String
 +
*<code>clothing</code> - String
 +
*<code>umbrella</code> - String
 +
*<code>new</code> - Boolean
 +
*<code>nlwa</code> - Boolean
 
*<code>siblings</code> - String
 
*<code>siblings</code> - String
 +
*<code>favclothing</code> - String
 +
*<code>leastfavclothing</code> - String
 +
*<code>favcolor</code> - String
 
*<code>skill</code> - String
 
*<code>skill</code> - String
 
*<code>goal</code> - String
 
*<code>goal</code> - String
 
*<code>fear</code> - String
 
*<code>fear</code> - String
−
*<code>favclothing</code> - String
 
−
*<code>leastfavclothing</code> - String
 
−
*<code>favcolor</code> - String
 
 
*<code>coffeetype</code> - String
 
*<code>coffeetype</code> - String
 
*<code>milk</code> - String
 
*<code>milk</code> - String
 
*<code>sugar</code> - String
 
*<code>sugar</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nlwa_rv|nlwa_rv]]'''
 +
| {{NLWa|short}} RVs
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 16 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>description</code> - 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>notes</code> - Wikitext string
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Gray}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pc_furniture|pc_furniture]]'''
 +
| {{PC|short}} furniture
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 20 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>image</code> - String
 +
*<code>category</code> - String
 +
*<code>theme</code> - String
 +
*<code>rarity</code> - String
 +
*<code>buy</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>unlocked</code> - String
 +
*<code>availability</code> - String
 +
*<code>availability_note</code> - String
 +
*<code>availability_start</code> - String
 +
*<code>availability_end</code> - String
 +
*<code>length</code> - Integer
 +
*<code>width</code> - Integer
 +
*<code>conversation_piece</code> - Boolean
 +
*<code>memory</code> - Boolean
 +
*<code>gulliver_points</code> - Integer
 +
*<code>reaction</code> - String
 +
*<code>gift_group</code> - Integer
 +
*<code>crafting_time</code> - Integer
 +
*<code>crafting_difficulty</code> - String
 +
*<code>crafting_material1</code> - String
 +
*<code>crafting_material1_num</code> - Integer
 +
*<code>crafting_material2</code> - String
 +
*<code>crafting_material2_num</code> - Integer
 +
*<code>crafting_material3</code> - String
 +
*<code>crafting_material3_num</code> - Integer
 +
*<code>crafting_material4</code> - String
 +
*<code>crafting_material4_num</code> - Integer
 +
*<code>crafting_material5</code> - String
 +
*<code>crafting_material5_num</code> - Integer
 +
*<code>crafting_material6</code> - String
 +
*<code>crafting_material6_num</code> - Integer
 +
*<code>crafting_bells</code> - Integer
 +
*<code>reissued</code> - Boolean
 +
*<code>reissue_crafting_time</code> - Integer
 +
*<code>reissue_crafting_material1</code> - String
 +
*<code>reissue_crafting_material1_num</code> - Integer
 +
*<code>reissue_crafting_material2</code> - String
 +
*<code>reissue_crafting_material2_num</code> - Integer
 +
*<code>reissue_crafting_material3</code> - String
 +
*<code>reissue_crafting_material3_num</code> - Integer
 +
*<code>reissue_crafting_material4</code> - String
 +
*<code>reissue_crafting_material4_num</code> - Integer
 +
*<code>reissue_crafting_material5</code> - String
 +
*<code>reissue_crafting_material5_num</code> - Integer
 +
*<code>reissue_crafting_material6</code> - String
 +
*<code>reissue_crafting_material6_num</code> - Integer
 +
*<code>reissue_crafting_bells</code> - Integer
 +
*<code>notes</code> - String
 
|}
 
|}
 
| -
 
| -
Line 731: Line 1,674:
 
| {{PC|short}} villager info and rewards
 
| {{PC|short}} villager info and rewards
 
| Columns need renaming to match standard
 
| Columns need renaming to match standard
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 20 fields}}
 
|-
 
|-
 
|
 
|
Line 754: Line 1,697:
 
*<code>friendRewardLvl2</code> - Integer
 
*<code>friendRewardLvl2</code> - Integer
 
*<code>friendRewardLvl3</code> - Integer
 
*<code>friendRewardLvl3</code> - Integer
 +
*<code>version_added</code> - String
 +
*<code>date_unlocked</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/pg_bug|pg_bug]]'''
 +
| {{PG}} bugs
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{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>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>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|Green}}
Line 762: Line 1,901:
 
| {{PG}} fossils
 
| {{PG}} fossils
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 8 fields}}
Line 775: Line 1,914:
 
*<code>width</code> - Float
 
*<code>width</code> - Float
 
*<code>length</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
 
|}
 
|}
 
| -
 
| -
Line 781: Line 2,144:
 
| {{Table cell|No}}
 
| {{Table cell|No}}
 
| '''[[Special:CargoTables/song|song]]'''
 
| '''[[Special:CargoTables/song|song]]'''
−
| KK Song image, audio and {{SER}} appearances
+
| K.K. Slider song cover, audio, and {{SER}} appearances
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 18 fields}}
Line 814: Line 2,177:
 
| Special character info and {{SER}} appearances
 
| Special character info and {{SER}} appearances
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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 29 fields}}
 
|-
 
|-
 
|
 
|
Line 826: Line 2,189:
 
*<code>image</code> - String
 
*<code>image</code> - String
 
*<code>image_url</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>species</code> - String
 
*<code>gender</code> - String
 
*<code>gender</code> - String
 
*<code>gender_japan</code> - String
 
*<code>gender_japan</code> - String
 
*<code>birthday</code> - String
 
*<code>birthday</code> - String
 +
*<code>birthday_month</code> - String
 +
*<code>birthday_day</code> - Integer
 
*<code>birthday_sort</code> - Integer
 
*<code>birthday_sort</code> - Integer
 
*<code>sign</code> - String
 
*<code>sign</code> - String
Line 852: Line 2,219:
 
| {{SER}} villagers
 
| {{SER}} villagers
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 37 fields}}
+
! {{Colorshow|4c4c4c|Open to view 40 fields}}
 
|-
 
|-
 
|
 
|
Line 861: Line 2,228:
 
*<code>name_sort</code> - String
 
*<code>name_sort</code> - String
 
*<code>alt_name</code> - String
 
*<code>alt_name</code> - String
−
*<code>titlecolor</code> - String
+
*<code>title_color</code> - String
−
*<code>textcolor</code> - String
+
*<code>text_color</code> - String
 
*<code>id</code> - String
 
*<code>id</code> - String
 
*<code>image</code> - String
 
*<code>image</code> - String
Line 868: Line 2,235:
 
*<code>species</code> - String
 
*<code>species</code> - String
 
*<code>personality</code> - String
 
*<code>personality</code> - String
 +
*<code>personality_note</code> - String
 
*<code>prev_personality</code> - String
 
*<code>prev_personality</code> - String
 +
*<code>prev_personality_note</code> - String
 
*<code>gender</code> - String
 
*<code>gender</code> - String
 
*<code>birthday</code> - String
 
*<code>birthday</code> - String
Line 875: Line 2,244:
 
*<code>birthday_sort</code> - Integer
 
*<code>birthday_sort</code> - Integer
 
*<code>sign</code> - String
 
*<code>sign</code> - String
 +
*<code>sign_sort</code> - Integer
 
*<code>quote</code> - String
 
*<code>quote</code> - String
 
*<code>phrase</code> - String
 
*<code>phrase</code> - String
Line 894: Line 2,264:
 
*<code>hhd</code> - Boolean
 
*<code>hhd</code> - Boolean
 
*<code>pc</code> - Boolean
 
*<code>pc</code> - Boolean
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/ww_house|ww_house]]'''
 +
| {{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"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 13 fields}}
 +
|-
 +
|
 +
*<code>villager</code> - String
 +
*<code>interior_image</code> - String
 +
*<code>interior_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>notes</code> - Wikitext string
 
|}
 
|}
 
| -
 
| -
Line 902: Line 2,298:
 
| {{WW|short}} villager picture, quote and preferences
 
| {{WW|short}} villager picture, quote and preferences
 
|
 
|
−
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
+
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
 
! {{Colorshow|4c4c4c|Open to view 6 fields}}
 
! {{Colorshow|4c4c4c|Open to view 6 fields}}
Line 910: 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"