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

From Nookipedia, the Animal Crossing wiki
m (Text replacement - ""collapsible collapsed"" to ""mw-collapsible mw-collapsed"")
(updating all up to pc (will continue it later))
Line 275: Line 275:
 
|}
 
|}
 
| -
 
| -
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{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|Green}}
Line 323: Line 353:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 41 fields}}
+
! {{Colorshow|4c4c4c|Open to view 73 fields}}
 
|-
 
|-
 
|
 
|
Line 331: 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 346: 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 359: 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).
Line 377: Line 439:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 26 fields}}
+
! {{Colorshow|4c4c4c|Open to view 57 fields}}
 
|-
 
|-
 
|
 
|
Line 402: Line 464:
 
*<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}}
Line 416: Line 509:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 6 fields}}
+
! {{Colorshow|4c4c4c|Open to view 10 fields}}
 
|-
 
|-
 
|
 
|
Line 422: Line 515:
 
*<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 435: Line 532:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 48 fields}}
+
! {{Colorshow|4c4c4c|Open to view 75 fields}}
 
|-
 
|-
 
|
 
|
Line 443: Line 540:
 
*<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 459: Line 566:
 
*<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 472: Line 591:
 
*<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 478: Line 609:
 
*<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
+
| Missing rarity data (common name for rarity percentages TBD). Needs description filling.
−
*<code>total_catch</code> - Integer
+
|-
−
*<code>sell_nook</code> - Integer
+
| {{Table cell|Green}}
−
*<code>sell_cj</code> - Integer
+
| {{Table cell|No}}
−
*<code>tank_width</code> - Float
+
| '''[[Special:CargoTables/nh_fossil|nh_fossil]]'''
−
*<code>tank_length</code> - Float
+
| {{NH|short}} fossil
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 10 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>image</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|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
 
|}
 
|}
−
| Missing rarity data (common name for rarity percentages TBD).
+
| -
 
|-
 
|-
 
| {{Table cell|Green}}
 
| {{Table cell|Green}}
Line 496: Line 659:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 41 fields}}
+
! {{Colorshow|4c4c4c|Open to view 50 fields}}
 
|-
 
|-
 
|
 
|
Line 507: Line 670:
 
*<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 522: Line 688:
 
*<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 537: Line 708:
 
*<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 556: Line 728:
 
*<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 570: Line 745:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 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 586: Line 762:
 
*<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 598: Line 776:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 25 fields}}
+
! {{Colorshow|4c4c4c|Open to view 29 fields}}
 
|-
 
|-
 
|
 
|
Line 604: Line 782:
 
*<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
Line 623: Line 804:
 
*<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|No}}
 +
| '''[[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 700: Line 923:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 25 fields}}
+
! {{Colorshow|4c4c4c|Open to view 26 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>buy1_price</code> - Integer
 
*<code>buy1_price</code> - Integer
Line 738: Line 962:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 6 fields}}
+
! {{Colorshow|4c4c4c|Open to view 8 fields}}
 
|-
 
|-
 
|
 
|
Line 744: Line 968:
 
*<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 757: Line 983:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 30 fields}}
+
! {{Colorshow|4c4c4c|Open to view 32 fields}}
 
|-
 
|-
 
|
 
|
Line 763: Line 989:
 
*<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 800: Line 1,028:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 41 fields}}
+
! {{Colorshow|4c4c4c|Open to view 72 fields}}
 
|-
 
|-
 
|
 
|
Line 808: Line 1,036:
 
*<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 823: Line 1,060:
 
*<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 836: Line 1,085:
 
*<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).
Line 854: Line 1,113:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 24 fields}}
+
! {{Colorshow|4c4c4c|Open to view 29 fields}}
 
|-
 
|-
 
|
 
|
Line 861: Line 1,120:
 
*<code>item_set</code> - Integer
 
*<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 875: Line 1,136:
 
*<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 891: Line 1,155:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 6 fields}}
+
! {{Colorshow|4c4c4c|Open to view 8 fields}}
 
|-
 
|-
 
|
 
|
Line 897: Line 1,161:
 
*<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 915: Line 1,181:
 
*<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 932: Line 1,199:
 
*<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 938: Line 1,206:
 
*<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
 
|}
 
|}
 
| -
 
| -
Line 1,127: Line 1,403:
 
| Missing rarity data (common name for rarity percentages TBD).
 
| Missing rarity data (common name for rarity percentages TBD).
 
|-  
 
|-  
−
| {{Table cell|Gray}}
+
| {{Table cell|Green}}
 
| {{Table cell|No}}
 
| {{Table cell|No}}
−
| '''[[Special:CargoTables/nl_villager|nl_villager]]'''
+
| '''[[Special:CargoTables/nl_house|nl_house]]'''
−
| {{NL|short}} villager preferences
+
| {{NL|short}} villager homes
 
|
 
|
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 14 fields}}
+
! {{Colorshow|4c4c4c|Open to view 16 fields}}
 
|-
 
|-
 
|
 
|
−
*<code>name</code> - String
+
*<code>villager</code> - String
 
*<code>name_sort</code> - String
 
*<code>name_sort</code> - String
−
*<code>pic</code> - String
+
*<code>interior_image</code> - String
−
*<code>quote</code> - String
+
*<code>interior_image_url</code> - String
−
*<code>siblings</code> - String
+
*<code>exterior_image</code> - String
−
*<code>skill</code> - String
+
*<code>exterior_image_url</code> - String
−
*<code>goal</code> - String
+
*<code>wallpaper</code> - String
−
*<code>fear</code> - String
+
*<code>wallpaper_image</code> - String
−
*<code>favclothing</code> - String
+
*<code>wallpaper_image_url</code> - String
−
*<code>leastfavclothing</code> - String
+
*<code>flooring</code> - String
−
*<code>favcolor</code> - String
+
*<code>flooring_image</code> - String
−
*<code>coffeetype</code> - String
+
*<code>flooring_image_url</code> - String
−
*<code>milk</code> - String
+
*<code>music</code> - String
−
*<code>sugar</code> - String
+
*<code>music_note</code> - String
 +
*<code>items</code> - Text
 +
*<code>notes</code> - Wikitext string
 
|}
 
|}
 
| -
 
| -
Line 1,199: Line 1,477:
 
*<code>m1_time</code> - String
 
*<code>m1_time</code> - String
 
*<code>m2_time</code> - String
 
*<code>m2_time</code> - String
−
*<code>m3_time</code> - String  
+
*<code>m3_time</code> - String
 
*<code>m4_time</code> - String
 
*<code>m4_time</code> - String
 
*<code>m5_time</code> - String
 
*<code>m5_time</code> - String
Line 1,231: Line 1,509:
 
|}
 
|}
 
| Missing rarity data (common name for rarity percentages TBD).
 
| Missing rarity data (common name for rarity percentages TBD).
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nl_villager|nl_villager]]'''
 +
| {{NL|short}} villagers
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 32 fields}}
 +
|-
 +
|
 +
*<code>name</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_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>clothing</code> - String
 +
*<code>umbrella</code> - String
 +
*<code>new</code> - Boolean
 +
*<code>nlwa</code> - Boolean
 +
*<code>siblings</code> - String
 +
*<code>favclothing</code> - String
 +
*<code>leastfavclothing</code> - String
 +
*<code>favcolor</code> - String
 +
*<code>skill</code> - String
 +
*<code>goal</code> - String
 +
*<code>fear</code> - String
 +
*<code>coffeetype</code> - String
 +
*<code>milk</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
 +
|}
 +
| -
 
|-  
 
|-  
 
| {{Table cell|Yellow}}
 
| {{Table cell|Yellow}}
Line 1,239: Line 1,654:
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 18 fields}}
+
! {{Colorshow|4c4c4c|Open to view 20 fields}}
 
|-
 
|-
 
|
 
|
Line 1,260: Line 1,675:
 
*<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
 
|}
 
|}
 
| -
 
| -

Revision as of 23:35, April 9, 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: 11:48, February 6, 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).
Yellow No 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 No 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 fossil
Open to view 10 fields
  • name - String
  • image - 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 No 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 No 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 No nh_interior New Horizons wallpaper and flooring
Open to view 29 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
  • 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 No 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 No nh_photo New Horizons villager photos and posters
Open to view 26 fields
  • identifier - String
  • en_name - String
  • name_sort - String
  • category - 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
  • 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 No 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 No nh_tool New Horizons handheld items
Open to view 29 fields
  • identifier - String
  • en_name - String
  • item_set - Integer
  • 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 No 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_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 song KK Song image, 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 25 fields
  • url - String
  • name - String
  • name_sort - String
  • alt_name - String
  • ID - String
  • image - String
  • image_url - String
  • species - String
  • gender - String
  • gender_japan - String
  • birthday - String
  • 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 37 fields
  • url - String
  • name - String
  • name_sort - String
  • alt_name - String
  • titlecolor - String
  • textcolor - String
  • id - String
  • image - String
  • image_url - String
  • species - String
  • personality - String
  • prev_personality - String
  • gender - String
  • birthday - String
  • birthday_month - String
  • birthday_day - Integer
  • birthday_sort - Integer
  • sign - String
  • 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
 -
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=562312"