AgMRC-Commodities

Data Science for the Public Good

The Data Science for the Public Good (DSPG) Young Scholars program is an immersive summer program that engages students from across Iowa to work together on projects that address local and state government challenges around critical social issues relevant in the world today. Learn more about the program here.


AgMRC Commodity Reports

AGMRC Commodity Reports in tableau can be used as preliminary research in determining current production, market analysis, demographic data and price points. It can be useful in applying for a wide variety of grant funding, financial institutional loans, etc. The customizable marketing studies provide Value Added Producer Grant (VAPG) applicants with market intelligence that can easily be incorporated into feasibility studies and business plans that support the application process.


Objectives


Develop end to end automated report:


Egg/Beef Commodity Report


Cover Page (Egg/Beef)

image


image


Market Consumption Profile

Market Consumption Page


Demographic Profile – Part 1 & Part 2

image


Data Sources


Data Name Level Accessed Through Usage Website
ESRI Consumer Spending Primary Arc GIS Pro and previous teams work Used to find consumer spending for egg, beef, and overall food at and away from home Link
USDA Agricultural Marketing Service Secondary MariaDB Used to find number of CSAs and farmers markets in a state Link
CDC State Indicator Report Secondary MariaDB Used to find number of food hubs in a state Link
Data Axle Genie Secondary MariaDB Used to find number of grocery stores and restaurants in a state Link
National Oceanic and Atmospheric Administration Primary Website state historical weather data Link
USDA Local Food Directories Primary Website locations of farmer’s markets, food hubs Link
USDA Quickstats Primary Website survey and census data  Link


Detailed information about sources used can be found here


Code


Corresponding code is available on:


Team


The team brought together backgrounds in Computer Science, Data Science, Economics, and Political Science, with interests in applications of technical skills to achieve meaningful impacts for decision making processes related to products at the local level.