FDA / openfda

openFDA is an FDA project to provide open APIs, raw data downloads, documentation and examples, and a developer community for an important collection of FDA public datasets.
https://open.fda.gov
Creative Commons Zero v1.0 Universal
568 stars 131 forks source link

Data in "source_types" is truncated at 28 chars combined string length. #86

Closed michael-newsrx closed 7 years ago

michael-newsrx commented 7 years ago

Data in "source_types" is truncated at 28 chars combined string length.

Examples:

"mdr_report_key" : "6683846"
"source_type" : [ "COMPANY REPRESENTATIVE", "FOREIG" ],

"mdr_report_key" : "6756214"
"source_type" : [ "FOREIGN", "HEALTH PROFESSIONAL", "U" ],

"mdr_text_key" : "81475920"
"source_type" : [ "HEALTH PROFESSIONAL", "USER FACI" ],
michael-newsrx commented 7 years ago

The sourced zipped MAUDE data is the source of this problem:

6756221||1717344-2017-05650|M|Y|||08/01/2017|N|Y|07/03/2017||N|000|I|U|||*||I|||SHARON|MURPHY|5920 LONGBOW DRIVE||BOULDER|CO|80301||US|80301|203|203|2034|||20349252|2034925267|COVIDIEN MFG DC BOULDER|5920 LONGBOW DR||BOULDER|CO|80301|3299|US|803013299|07/03/2017||Y||I||M||||||||||||||||||I|HEALTH PROFESSIONAL,USER FACI|08/01/2017|08/17/2017