This codebook.txt file was generated on 20211028 by wilsonkm ------------------- GENERAL INFORMATION ------------------- 1. Title of Dataset Appendix Files: Quantifying Agrifood Production and Consumption at the U.S. Metropolitan and County Level to Inform Urban Food System Interventions 2. Author Information Principal Investigator Contact Information Name: Peter Nixon Institution: University of Minnesota Email: nixon100@umn.edu -------------------------- SHARING/ACCESS INFORMATION -------------------------- 1. Licenses/restrictions placed on the data: CC0 1.0 Universal 2. Links to publications that cite or use the data: Nixon, P. & Ramaswami, A. (2018). Assessing Current Local Capacity for Agrifood Production To Meet Household Demand: Analyzing Select Food Commodities across 377 U.S. Metropolitan Areas. Environmental Science & Technology, 52(18), 10511-10521. Quantifying Agrifood Production and Consumption at the U.S. Metropolitan and County Level to Inform Urban Food System Interventions (Peter Nixon 2021) 3. Was data derived from another source? If yes, list source(s): See associated Thesis for details. Data derived from 2012 Agricultural Census (USDA), and the 05-10 What We Eat In America-FOod COmmodity Intake Dataset (05-10 WWEIA-FCID), which is associated with the National Health and Nutrition Examination and Survey (NHANES) 4. Recommended citation for the data: Nixon, Peter A. (2021). Appendix Files: Quantifying Agrifood Production and Consumption at the U.S. Metropolitan and County Level to Inform Urban Food System Interventions. Retrieved from the Data Repository for the University of Minnesota, https://doi.org/10.13020/q55y-ag77. --------------------- DATA & FILE OVERVIEW --------------------- 1. File List A. Filename: Appendix A. Qualitative Guidelines for Delineating Food Item & Food Ingredient Combinations by their Estimated Supply Chain Complexity.pdf Short description: Descriptions of the how different food ingredient and food item description combinations (derived from NHANES & FCID) were utilized to classify such as "fresh or minimally processed", "potentially fresh or minimally processed", or "processed". B. Filename: Appendix B. Agrifood Production & Demand by US County & US Metropolitan Area.ods Short description: Agrifood Production (2012) & Demand (05-10 Average) by US County & US Metropolitan Area. Total human-edible production and demand listed (i.e., fresh & processed). C. Filename: Appendix C. Nominal Current Local Capacity Results for US Counties.ods Short description: Ratio of local agrifood production to local household demand for 95 agrifoods, including total human-edible production and demand (i.e., fresh and processed, but no indirect animal feed demand or production). 2. Relationship between files: Data of Appendix B used to calculate results detailed in Appendix C. -------------------------- METHODOLOGICAL INFORMATION -------------------------- 1. Description of methods used for collection/generation of data: See associated Thesis for details. 2. Methods for processing the data: See associated Thesis for details. ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: Appendix B. Agrifood Production & Demand by US County & US Metropolitan Area.ods ----------------------------------------- Appendix B is an .ods file that can be accessed by Microsoft Excel. It is comprised of four sheets: Notes, Cnty_Production, Cnty_HH_Demand, and Crosswalk_Table. 1. Number of variables: - sheets Cnty_Production, Cnty_HH_Demand: 99 variables - Note: Columns E - CU refer to different kinds of foods and therefore are not defined below. The foods are categorized by Agrifood categories including field crops, fruits & nuts, vegetable, livestock, and animal products. - Crosswalk_Table: 6 variables 2. Number of cases/rows: - Notes: 3 rows - sheets Cnty_Production, Cnty_HH_Demand: 3117 rows Crosswalk_Table: 203 rows 3. Variable List A. Name: ANSI Code Description: ANSI Code B. Name: County name Description: Name of the county C. Name: MSA name Description: Name of Metropolitan Statistical Area to which County belongs (if applicable) Value labels if appropriate D. Name: County population Description: Population of the county Value labels if appropriate E. Name: Harmonized Production Category Description: USDA/production-oriented agrifood classifications Value labels if appropriate F. Name: Harmonized Consumption Category Description: NHANES & FCID/consumption-oriented food classifications Value labels if appropriate G. Name: USDA Broad Category Description: USDA food category (field crops, fruits and nuts, vegetables, livestock meats, and animal products) Value labels if appropriate H. Name: Notes Description: Conextual notes Value labels if appropriate I. Name: Fresh CLC Suitability Description: Whether agrifood is considered to contribute to food stocks consumed as fresh. Value labels if appropriate J. Name: Modelled Metric Description: County-level data leveraged to model data gaps and predict county-level production by harvest weight Value labels if appropriate ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: Appendix C. Nominal Current Local Capacity Results for US Counties.ods ----------------------------------------- Appendix C is an .ods file that can be accessed by Microsoft Excel. It is comprised of one sheet: CLC_Results. 1. Number of variables: 99 variables - Note: Columns E - CU refer to different kinds of foods and therefore are not defined below. The foods are categorized by Agrifood categories including field crops, fruits & nuts, vegetable, livestock, and animal products. 2. Number of cases/rows: 3117 rows 3.. Variable List Example. Name: Gender Description: Gender of respondent 1 = Male 2 = Female 3 = Other A. Name: ANSI Code Description: ANSI Code (county) B. Name: County name Description: Name of the county C. Name: MSA name Description: Name of Metropolitan Statistical Area to which County belongs (if applicable) Value labels if appropriate D. Name: County population Description: Population of the county Value labels if appropriate