{"id":606,"date":"2010-02-16T10:44:26","date_gmt":"2010-02-16T14:44:26","guid":{"rendered":"http:\/\/blogs.lib.purdue.edu\/news\/?p=606"},"modified":"2015-04-23T11:19:04","modified_gmt":"2015-04-23T15:19:04","slug":"mels-database-of-the-week-for-21210","status":"publish","type":"post","link":"https:\/\/blogs.lib.purdue.edu\/news\/2010\/02\/16\/mels-database-of-the-week-for-21210\/","title":{"rendered":"MEL&#8217;s Database of the Week for 2\/12\/10"},"content":{"rendered":"<p>Welcome to Database of the Week &#8212; a feature from the Management &amp; Economics Library (MEL). These database snapshots will give you basic information about our most relevant and beneficial online resources.<\/p>\n<p><strong>This Week\u2019s Featured Database: <\/strong><em>FAOSTAT, <\/em>from the Food and Agriculture Organization of the United Nations.<\/p>\n<p><strong>Link:<\/strong> <a href=\"http:\/\/www.lib.purdue.edu\/mel\" target=\"_blank\">www.lib.purdue.edu\/mel<\/a>, in the pull down<em> Quick Access to Business Databases<\/em> alpha list right below the Libraries\u2019 search box.<\/p>\n<p><strong>D<\/strong><strong>escription\/focus:<\/strong> <em>FAOSTAT <\/em>provides data on production, prices, and trade on food and agriculture around the world.<\/p>\n<p><strong>Start with this hint: <\/strong>The <em>FAOSTAT<\/em> home page has no general search box.\u00a0 Instead, it is a portal to datasets and databases that let you view canned charts or build customized spreadsheets and reports.\u00a0 Begin with the list in the blue banner across the top:\u00a0 <strong>Production<\/strong>, <strong>Trade<\/strong>, <strong>Food<\/strong> <strong>Supply<\/strong>, etc.\u00a0 Select one to see the further options in that subject area.\u00a0 For example, if you click on <strong>Resources<\/strong>, the options in the green field become <strong>ResourceSTAT<\/strong> and <strong>PopSTAT<\/strong>.\u00a0 Click on <strong>ResourceSTAT<\/strong> to see links for data on <strong>Fertilizers<\/strong>, <strong>Water<\/strong>, <strong>Labor<\/strong>, <strong>Machinery<\/strong>, and others.\u00a0 You can then select <strong>Water<\/strong> to see the information about and link to <strong>AquaSTAT<\/strong>.\u00a0 For another example, go back up to the blue field and select <strong>Trade<\/strong>, then select <strong>TradeSTAT<\/strong>, then select <strong>Crops<\/strong> <strong>and<\/strong> <strong>livestock<\/strong> <strong>products<\/strong>.\u00a0 This brings up the lists of parameters so select from each, being sure to scroll across to include the years.<\/p>\n<p><strong>Why you should know this database:<\/strong> <em>FAOSTAT<\/em> supplies data on over 200 countries.\u00a0 The databases that are prominently displayed across the top of every web page are supplemented by links on the <strong>Home<\/strong> page to other food and agriculture databases and information from the UN, such as a wastewater database.<\/p>\n<p><strong>How this database can be integrated into the curriculum:<\/strong> <em>FAOSTAT<\/em> databases let students compare the agriculture, food, and livestock production of a country to other countries as well as see changes in a country\u2019s production across time.<\/p>\n<p><strong>Cost:<\/strong> Paid by the Libraries annually. For more information contact <a href=\"mailto:mdugan@purdue.edu\">mdugan@purdue.edu<\/a>.<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>Database of the Week comes to you from the Management &amp; Economics Library (MEL). Our intent is to give you a brief introduction to a database that you may not know. If you would like more information about this database, or if you would like a demonstration of it for a class, contact <a href=\"mailto:kranlib@purdue.edu\">kranlib@purdue.edu<\/a>. Database of the Week is archived at <a href=\"https:\/\/blogs.lib.purdue.edu\/news\/category\/mgmt\/database\/\">https:\/\/blogs.lib.purdue.edu\/news\/category\/mgmt\/database\/<\/a>. For more Purdue Libraries news, follow us on Twitter (<a href=\"http:\/\/twitter.com\/PurdueLibraries\">@PurdueLibraries<\/a>).<\/p>\n<p>If you would like us to promote your favorite database, send an email to <a href=\"mailto:mdugan@purdue.edu\">mdugan@purdue.edu<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to Database of the Week &#8212; a feature from the Management &amp; Economics Library (MEL). These database snapshots will give you basic information about our most relevant and beneficial online resources. This Week\u2019s Featured Database: FAOSTAT, from the Food and Agriculture Organization of the United Nations. Link: www.lib.purdue.edu\/mel, in the pull down Quick Access [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[118,120,101,71],"tags":[],"class_list":["post-606","post","type-post","status-publish","format-standard","hentry","category-collections","category-database","category-hsseb","category-mgmt"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pT6ms-9M","_links":{"self":[{"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/posts\/606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/comments?post=606"}],"version-history":[{"count":6,"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/posts\/606\/revisions"}],"predecessor-version":[{"id":3860,"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/posts\/606\/revisions\/3860"}],"wp:attachment":[{"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/media?parent=606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/categories?post=606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.lib.purdue.edu\/news\/wp-json\/wp\/v2\/tags?post=606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}