Droughts Threats Mexico's Culinary Heritage

The file "1_Vulnerability_Index.xlsx" contains vulnerability indices for the analyzed crops. The file consists of four spreadsheets: 1_Vuln_TypeofAgriculture: Vulnerability index by type of agriculture (rainfed or irrigated). 2_Vuln_RendAnom: Vulnerability index based on anomalies in agricultural yield during years classified as experiencing extreme drought between 1990 and 2023. 3_Vuln_IndexGeneral: General index, which is the average of the vulnerability index by type of agriculture and the vulnerability index based on anomalies in agricultural yield during years classified as experiencing extreme drought between 1990 and 2023. 4_VulnIndexGen_AppliedToProd: This sheet contains the general vulnerability index applied to the average annual production of selected native crops for the period 1990–2023. The average annual production is expressed in tons. The file "2_TypicalDishes_List.xlsx" includes a list of typical dishes from Mexican gastronomy. Each of the sheets in the file contains an "ID", the "Origin/Region" of the dishes, the "Type of dish" (salty, sweet and drink), the dish name ("Dish"), as well as the 48 selected native crops. Additionally, the typical dishes are associated with the native crops, where values of 1 indicate the use of the analyzed crops as ingredients in the preparation of the dishes, while a value of 0 indicates their non-use. The file have 4 sheet: the first sheet contains the general list of typical dishes from Mexican gastronomy, obtained from the review of the works by Saizar et al. (2010) and OCEANO (1999); in the second sheet, column BA indicates how many of the 48 analyzed native crops are used as ingredients in the preparation of each dish; In the third sheet, based on the number of native crops used as ingredients (column BA), only those dishes that use more than one crop in their preparation are enlisted. Additionally, the names were homogenized; the fourth sheet sheet contains a pivot table where, through the "Type of dish" filter, the dishes of each category are listed, along with the number of times in wich was named. In addition, there is a table with the number of dishes per type of dish. The file "3_VulnerabilityTypicalDishes.xlsx" includes a list of typical dishes from Mexican cuisine, classified according to their degree of vulnerability. The file consists of five sheets. The first sheet contains the general list of typical dishes from Mexican cuisine, where, according to the degree of vulnerability of the crops used as ingredients in their preparation, they are associated with one of the four vulnerability levels: - Very High (red)- High (orange)- Medium (yellow)- Low (green) The degree of vulnerability is assigned by prioritizing the highest degree of vulnerability, in order to avoid duplicate dishes. For example, if a dish uses two ingredients, one with very high vulnerability and the other with low vulnerability, it will automatically be included in the list of dishes with very high vulnerability and will not be assigned to the list of dishes with low vulnerability. Sheets 2 to 5 list the dishes according to their degree of vulnerability, along with a pivot table showing the number of repetitions of each dish, as well as the total number of dishes in each degree of vulnerability. Sheet 2 contains the dishes with very high vulnerability; Sheet 3 contains the dishes with high vulnerability; Sheet 4 contains the dishes with medium vulnerability; and finally, Sheet 5 contains the dishes with low vulnerability. The file "4_CropsPerState.docx" contains a table with the list of selected native crops produced in each state of the Mexican Republic.文件“1_Vulnerability_Index.xlsx”包含所分析作物的脆弱性指数。该文件包含4个工作表： 1. 1_Vuln_TypeofAgriculture：按农业类型（雨养农业或灌溉农业）划分的脆弱性指数。 2. 2_Vuln_RendAnom：基于1990-2023年间被归类为极端干旱年份的农作物产量异常值计算的脆弱性指数。 3. 3_Vuln_IndexGeneral：综合指数，即按农业类型划分的脆弱性指数与1990-2023年间极端干旱年份农作物产量异常值对应的脆弱性指数的平均值。 4. 4_VulnIndexGen_AppliedToProd：该工作表包含应用于1990-2023年期间选定本土作物（native crops）年均产量的综合脆弱性指数，年均产量单位为吨。 文件“2_TypicalDishes_List.xlsx”包含墨西哥美食典型菜品名录。该文件的每个工作表均包含"ID"、"Origin/Region"（菜品起源/地区）、"Type of dish"（菜品类型，分为咸、甜及饮品三类）、"Dish"（菜品名称），以及48种选定的本土作物（native crops）。此外，典型菜品与本土作物存在关联：数值1表示该分析中的本土作物被用作该菜品的制备原料，数值0则表示未使用该作物。 该文件包含4个工作表：第一个工作表收录了通过梳理Saizar等人（2010）及OCEANO（1999）的研究文献得到的墨西哥美食典型菜品总名录；第二个工作表的BA列统计了每道菜品所使用的48种分析用本土作物的数量；第三个工作表基于工作表BA列统计的食材作物数量，仅收录了制备过程中使用了至少两种本土作物的菜品，并对菜品名称进行了统一规范化处理；第四个工作表包含数据透视表，可通过"Type of dish"筛选器查看各分类下的菜品列表及其出现频次，同时附带了按菜品类型划分的菜品数量统计表。 文件“3_VulnerabilityTypicalDishes.xlsx”收录了按脆弱性等级分类的墨西哥美食典型菜品名录。 该文件包含5个工作表。第一个工作表收录了墨西哥美食典型菜品总名录，根据菜品制备所用作物的脆弱性等级，将菜品划分为以下4个等级： - 极高（红色）、高（橙色）、中等（黄色）、低（绿色） 脆弱性等级的赋值遵循最高优先级原则，以避免菜品重复归类。例如，若某道菜品使用了两种作物，一种为极高脆弱性等级，另一种为低脆弱性等级，则该菜品将自动被归入极高脆弱性菜品名录，而非低脆弱性菜品名录。 工作表2至5分别按脆弱性等级罗列对应菜品，并附带数据透视表，展示各菜品的重复频次及对应脆弱性等级的菜品总数量：工作表2收录极高脆弱性菜品；工作表3收录高脆弱性菜品；工作表4收录中等脆弱性菜品；工作表5收录低脆弱性菜品。 文件“4_CropsPerState.docx”包含一张表格，列出了墨西哥共和国各州市所生产的选定本土作物名录。