{"id":41744,"date":"2026-07-14T20:27:11","date_gmt":"2026-07-14T18:27:11","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/self-promotion-8863-us-farmers-markets-cleaned-usda-data-cc-by-csv-json-doi\/"},"modified":"2026-07-14T20:27:11","modified_gmt":"2026-07-14T18:27:11","slug":"self-promotion-8863-us-farmers-markets-cleaned-usda-data-cc-by-csv-json-doi","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/self-promotion-8863-us-farmers-markets-cleaned-usda-data-cc-by-csv-json-doi\/","title":{"rendered":"[self-promotion] 8,863 US Farmers Markets \u2014 Cleaned USDA Data, CC-BY (CSV\/JSON, DOI)"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>USDA&#8217;s Local Food Portal is the canonical US farmers-market dataset, but the raw feed is rough: truncated names, stale records, a state= filter that substring-matches state names (querying &#8220;WA&#8221; returns Delaware rows), and thousands of missing websites\/hours.<\/p>\n<p>I cleaned and enriched it: deduplicated to 8,863 real markets (record-level), backfilled website coverage to ~50% from the live API + state sources, and added season\/SNAP\/organic fields. It&#8217;s CC-BY 4.0 as CSV\/JSON.<\/p>\n<p>Archived with DOI: <a href=\"https:\/\/doi.org\/10.5281\/zenodo.21360372\">https:\/\/doi.org\/10.5281\/zenodo.21360372<\/a><\/p>\n<p>Disclosure: I run <a href=\"http:\/\/harvestlymarkets.com\/\">harvestlymarkets.com<\/a>, the directory built on this data \u2014 full methodology and the same downloads live at <a href=\"https:\/\/harvestlymarkets.com\/data-sources\/\">https:\/\/harvestlymarkets.com\/data-sources\/<\/a>. Personal contact names\/emails are stripped from the redistributable; business fields come from USDA&#8217;s public feed.<\/p>\n<p>Happy to answer questions about the data-quality issues \u2014 the state-filter substring bug was a fun one to find.<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/the-rickest-rick137\"> \/u\/the-rickest-rick137 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1uwffwz\/selfpromotion_8863_us_farmers_markets_cleaned\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1uwffwz\/selfpromotion_8863_us_farmers_markets_cleaned\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-41744 jlk' href='javascript:void(0)' data-task='like' data-post_id='41744' data-nonce='86ab09b071' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-41744 lc'>0<\/span><\/a><\/div><\/div> <div class='status-41744 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>USDA&#8217;s Local Food Portal is the canonical US farmers-market dataset, but the raw feed is rough: truncated&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-41744","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/41744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=41744"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/41744\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=41744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=41744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=41744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}