Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
raw_datasets add week 5 - dairy cows Jan 28, 2019
clean_cheese.csv add week 5 - dairy cows Jan 28, 2019
fluid_milk_sales.csv
milk_products_facts.csv add week 5 - dairy cows Jan 28, 2019
milkcow_facts.csv
readme.md add week 5 - dairy cows Jan 28, 2019
state_milk_production.csv add week 5 - dairy cows Jan 28, 2019

readme.md

Datasets

milkcow_facts.csv
milk_facts.csv
milk_products_facts.csv
clean_cheese.csv
state_milk_production.csv

Data this week comes from the USDA (United States Department of Agriculture)! The raw datasets (Excel Sheets) can be found here. There is even more data at the source if you are interested, much of which requires a LOT of fun Excel sheet data munging. Enjoy!

A related NPR article - "Nobody is Moving our Cheese" and Washington Post article - "America's Cheese Stockpile hit an alltime high"".

This week's data was found via the Data is Plural newsletter.

Data Dictionary

  • milkcow_facts.csv
  • fluid_milk_sales.csv
  • milk_products_facts.csv
  • clean_cheese.csv
  • state_milk_production.csv

The "tame" datasets seen here might require a few gather calls, while some are already pretty tidy. Fluid milk sales, milkcow facts, and state milk production are good ones if you just want to plot, while the milk products and clean cheese allow for some creativity in the data organization steps.

milkcow_facts

variable class Description
year date Year
avg_milk_cow_number double Average number of milk cows
milk_per_cow double Average milk production/cow in pounds
milk_production_lbs double Total Milk production in pounds
avg_price_milk double Average price paid for milk (dollars per pound)
dairy_ration double Average price paid for dairy cow rations (dollars per pound)
milk_feed_price_ratio double Ratio of average price of milk per dairy cow ration
milk_cow_cost_per_animal double Average cost of milk cow per animal (dollars)
milk_volume_to_buy_cow_in_lbs double Milk volume required to purchase a cow (pounds)
alfalfa_hay_price double Alfalfa hay price received by farmers (tons)
slaughter_cow_price double Slaughter cow price (value of meat in dollars per pound)

fluid_milk_sales

variable class description
year date Year
milk_type integer Category of Milk product
pounds double Pounds of milk product per year

milk_products_facts

variable class description
year date Year
fluid_milk double Average milk consumption in lbs per person
fluid_yogurt double Average yogurt consumption in lbs per person
butter double Average butter consumption in lbs per person
cheese_american double Average American cheese consumption in lbs per person
cheese_other double Average other cheese consumption in lbs per person
cheese_cottage double Average cottage cheese consumption in lbs per person
evap_cnd_canned_whole_milk double Average evaporated and canned whole milk consumption in lbs per person
evap_cnd_bulk_whole_milk double Average evaporated and canned bulk whole milk consumption in lbs per person
evap_cnd_bulk_and_can_skim_milk double Average evaporated and canned bulk and can skim milk consumption in lbs per person
frozen_ice_cream_regular double Average regular frozen ice cream consumption in lbs per person
frozen_ice_cream_reduced_fat double Average reducated fat frozen ice cream consumption in lbs per person
frozen_sherbet double Average frozen sherbet consumption in lbs per person
frozen_other double Average other frozen milk product consumption in lbs per person
dry_whole_milk double Average dry whole milk consumption in lbs per person
dry_nonfat_milk double Average dry nonfat milk consumption in lbs per person
dry_buttermilk double Average dry buttermilk consumption in lbs per person
dry_whey double Average dry whey (milk protein) consumption in lbs per person

clean_cheese

variable class description
Year date Year
Cheddar double Cheddar consumption in lbs per person
American Other double American Other consumption in lbs per person
Mozzarella double Mozzarella consumption in lbs per person
Italian other double Italian other consumption in lbs per person
Swiss double Swiss consumption in lbs per person
Brick double Brick consumption in lbs per person
Muenster double Muenster consumption in lbs per person
Cream and Neufchatel double Cream and Neufchatel consumption in lbs per person
Blue double Blue consumption in lbs per person
Other Dairy Cheese double Other Dairy Cheese consumption in lbs per person
Processed Cheese double Processed Cheese consumption in lbs per person
Foods and spreads double Foods and spreads consumption in lbs per person
Total American Chese double Total American Chese consumption in lbs per person
Total Italian Cheese double Total Italian Cheese consumption in lbs per person
Total Natural Cheese double Total Natural Cheese consumption in lbs per person
Total Processed Cheese Products double Total Processed Cheese Products consumption in lbs per person

state_milk_production

variable class description
region character Region of the US
state character US State
year date Year
milk_produced double Pounds of Milk Produced