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 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.
Develop end to end automated report:
|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
Corresponding code is available on:
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.