I was looking through the openFDA API and have been trying to find a good way to get data from the start of 2014 to now. Unfortunately it appears the downloads only go to 01-25-16. I also ran a query on the live database giving a very wide date range and got some strange results which do not appear to match up with that of the downloaded JSON file.
The download JSON file can be found here: "http://download.open.fda.gov/2016-01-25/food/enforcement/food-enforcement-0001-of-0001.json.zip" and my query run can be found here https://api.fda.gov/food/enforcement.json?search=report_date:[20140101%20TO%2020170429]&limit=100 . The problem I am finding is that the query seems to return far less results then I am expecting if it stores the same contents as the downloadable JSON.
What I mean by that is that the first entry for the query is with a report date of "20160316" and the last entry having a report date of "20140903". Where as the download has well over a 100 entries for any given year within its bounds. Is this an issue with my query, the database, a bug or something else entirely? Any help would be much appreciated.