I want to be able to search for foods by specific fatty acids. My specific use case is finding foods with short- and medium-chain fatty acids but not long-chain fatty acids.
Are there any data-sets / websites that provide this sort of information? This is the sort of thing that either requires programmatic filtering of the dataset or for someone else to have specifically provided features for searching based on this criteria.
The USDA database does not provide this information. As included in @tetraminos answer below, USDA contains the necessary information: individual fatty acids are given names like "4:0" and "16:1 undifferentianted" with codes like "F4D0"
Self nutrition data appears to have this information, but no effective way to search for what I want (fatty acids more details). Is there data derived from a public source?
Given a particular food you can often find the information you want by googling.