{"id":39376,"date":"2026-03-04T15:27:05","date_gmt":"2026-03-04T14:27:05","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/cleaned-json-version-of-the-usda-phytochemical-ethnobotanical-database\/"},"modified":"2026-03-04T15:27:05","modified_gmt":"2026-03-04T14:27:05","slug":"cleaned-json-version-of-the-usda-phytochemical-ethnobotanical-database","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/cleaned-json-version-of-the-usda-phytochemical-ethnobotanical-database\/","title":{"rendered":"Cleaned JSON Version Of The USDA Phytochemical \/ Ethnobotanical Database"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hey everyone.<br \/> I recently needed to use Dr. Duke&#8217;s Phytochemical database for a project, but the raw CSV dumps from the USDA are an absolute nightmare to parse (missing fields, inconsistent naming, random caps lock everywhere).<\/p>\n<p>I spent the last couple of days completely cleaning, normalizing, and mapping the dataset into a relational JSON structure so it&#8217;s actually usable for data science pipelines.<\/p>\n<p>I put a sample of 400 fully mapped chemical\/plant entities on GitHub if anyone else needs this for their research. Saved me a ton of headache.<br \/> [<a href=\"https:\/\/github.com\/wirthal1990-tech\/USDA-Phytochemical-Database-JSON%5C\">https:\/\/github.com\/wirthal1990-tech\/USDA-Phytochemical-Database-JSON<\/a>]<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/DoubleReception2962\"> \/u\/DoubleReception2962 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1rkm80r\/cleaned_json_version_of_the_usda_phytochemical\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1rkm80r\/cleaned_json_version_of_the_usda_phytochemical\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-39376 jlk' href='javascript:void(0)' data-task='like' data-post_id='39376' data-nonce='65e0e39b87' 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-39376 lc'>0<\/span><\/a><\/div><\/div> <div class='status-39376 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hey everyone. I recently needed to use Dr. Duke&#8217;s Phytochemical database for a project, but the raw&#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-39376","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\/39376","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=39376"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/39376\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=39376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=39376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=39376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}