FDA Mobile News App Just Got Accepted into Apple's App Store

Like everyone else on the planet looking to score 99 cents (70 cents after commission), I developed an iPhone app: FDA Mobile News.

Basically it's a glorified RSS reader devoted to FDA's RSS feeds and I charge a whopping $0.00 for it (I get 70% of that--so who's the fool, now?).

It still has some problems that need to be worked out (as my only reviewer pointed out--someone who goes by the name of "Saddam Hussein's Lost Car Keys" [WTF?] it isn't particularly clear that the globe icon that I use is actually a hyperlink to the full RSS article).

Well, the way the App Store is these days, I wouldn't be surprised if my parents were toiling away in their basement crafting some "newfangled iAARP contraption for that iTelephone store where everybody gets rich"--70 cents at a time.

Things I Like About FDA Informatics

Sometimes me conscience gets to me. And lately I feel like I've been bashing the FDA data releases too much.

So today, I reverse course and list 2 IT-related thingies pushed out by the FDA that I like (sort of).

I'll go back to bashing the FDA later this week.

Thing # 1. The Peanut Product Recall Widget. This is a small Flash box (widget) that anyone can place onto a web-site. You just place a small snippet of code in your HTML and you get access to what looks like *all* FDA-related product recalls (not just the peanuts).

Why then, do they call it the Peanut Product Recall Widget? I have no idea, but bad branding isn't a felony.

The styling of the widget lies somewhere between "design by Stevie Wonder" and "absolutely horrendous", but as mentioned above--not...a...felony.


Thing #2. the MedWatch widget. Same principle applies as with the Product Recall Widget. Small bit of code and you get 4 links to MedWatch information. The utility of this widget is a tad suspect, as all it does is provide a collection of 4 hyperlinks. The Product Recall Widget has a search function, thereby vaulting it to a higher echelon in the pantheon of widgets.

But there you have it. 2 examples of the FDA reaching out on the informatics front and doing a good job.

AERS & VAERS Reporting Frequency has Approximately Tripled since their Inceptions

A little bit of navel gazing today, but I decided to plot the # of reports submitted to the AERS and VAERS systems vs. Time today. There are small bits of information in the graphs shown below that might warrant further examination.

e.g., The # of reports submitted to AERS has almost tripled from 1998 to 2008 (11 years).

Is this a big increase?

I can't really say with any certainty, but it feels like an inadequate increase given the concomitant increases in the use of information technology over that period (e.g., the interwebs).

[Aside: Wolfram Alpha is being of no use in trying to find the change in internet usage over the years to serve as a comparison---okay wikipedia is telling me that internet usage from 1997 to 2007 has gone up almost 6 fold in the developed world...so I think my feeling is probably correct.]

Also...what's going on with those dips in the # of reports in the early 2000s?

Note that 1997 only includes data for Q4 of that year so it's artificially low.

VAERS
As far as VAERS is concerned, it looks mostly like a flat-line from 1991 to 2006 (okay it doubled, but that's over 16 years) and then there's a HUUUUGE spike over the past 2 years.

Is VAERS being "marketed" better all of a sudden, or is it The Jenny McCarthy/ Autism effect? Or both?

FDA AERS Data & Quality Control

FDA just released its Q4 2008 AERS data (yes, it’s May 13, but that’s another story altogether).

This post is about Quality Control of AERS data. It seems that every quarter, there’s some type of SNAFU with the data release (last year they released AERS data partially contaminated with a previous quarter's data).

This quarter, we have the classic newline-characters-where-they-don’t-belong error that's screwing up my AERS parser.

A little Background:
FDA releases its data in 2 forms (ASCII and SGML). ASCII is the one that I use and each ASCII file consists of row after row after row of $-delimited Adverse Event Records.

2 sample rows might look something like this:

$12345$abcdef$somestuff here$blah$more blah$blah $34321$blahblah$doscum$etcetc$vixerunt$gaius$cicero

Each row should represent one particular database record and my parser dutifully goes through each row extracting all the little bits of information between the dollar $ign$.

But with this latest quarterly release FDA released its Drug data file (aka DRUG08Q4.txt) with 4 significant quality control errors (see sample screenshot below).

[For those who want gruesome details, the following lines in the DRUG.txt file contain errors: 537-538, 258909-258910, 281285-281286, 408948]

The gist of the issue is that whoever entered the data for these 4 drug-records forgot to remove the newline characters (“carriage returns”) and so the record is actually split across 2 or more lines.

While this doesn’t seem like a big deal, if your parser isn’t “smart” it could inadvertently stuff the wrong data into the wrong slots in your database.

And so, you have to design your parser to look for these types of errors--and then you have to have a human look at the problem just to assure yourself that there wasn’t a bigger error. This wastes time...especially when the file you’re looking at has 416,000 records.

‘t would be nicer if FDA did more quality control on their data releases.

FAERS - AERS, but Fancier

Someone at FDA sent this to me recently (see below). It's an email sent around from within the FDA announcing a new Adverse Event Reporting system (sort of).

Emphases are mine. Editorial comments are mine, too.

Spoiler alert: They forked over $$$$$ and went with Oracle.

Bioinformatics Board (BiB) News

Post Market Safety BRB Announces Selection of Vendor[We've decided to shop at Barney's. Can't tell you what we're buying just yet, but it's gonna be FAB!] for New Enterprise Adverse Event System

The Bioinformatics Board (BIB) News provides FDA employees with an update on the activities and progress of the BiB. This month’s news focuses on the Post Market Safety BRB and the selection of the Adverse Event System Vendor. For more information about the BiB or the contents of this message, please contact your BiB representative or email the Bioinformatics Board, bioinformatics@fda.hhs.gov.

Post Market Safety Business Review Board Announces Selection of Vendor for New Enterprise Adverse Event System FDA’s Bioinformatics Board and the Post Market Safety Business Review Board are pleased to announce a significant milestone for the Agency. After an extensive analysis of FDA scientific needs for the management and analysis of post market product safety reports, and an evaluation of leading industry tools, the FDA Adverse Event Reporting System (FAERS) Program has selected Oracle AERS[$$$] (Adverse Event Reporting System) as the new tool for FDA staff[guess who's not getting access to the data juuuust yet...?] to efficiently[you wouldn't believe what we were doing before] analyze post market safety reports in order to identify potential product safety problems.

Selection of the new FAERS tool represents a significant landmark for the Agency. With the selection of an advanced tool that all centers and offices can leverage, the Agency can now focus on implementing processes for sharing post market safety data across our product centers as well as advancing the science of post market report analysis. Achievement of this milestone represents the efforts of numerous individuals from across the Agency over several years[wow. just...wow]. While in many ways this is just a beginning, it is important to recognize our progress towards meeting the goal of providing modern tools necessary to address many post-market surveillance needs. Selection of Oracle AERS[What? no love for MySQL? They're about to be subsumed by Oracle, too, ya know.] positions the Agency for success in this complex and dynamic arena.

We expect the initial users in CDER and CBER to receive training and begin using the new system as early as fall 2009[but don't quote us on that] with additional users being trained and brought on over time. CDRH users are expected to begin using the tool in 2010, and additional centers and offices expected shortly thereafter.

Tuesdays are a busy day @ FDA

3 non-colinear points define a plane...and 3 Tuesdays in a row is enough for me to jump to 2 conclusions, but I think the first conclusion is correct and the 2nd conclusion has a good chance of being right, too.

Conclusion 1. The FDA updates its warning letters database by hand every Tuesday morning.

Why do I think so?
I have an automated ‘bot’ that fetches new FDA warning letters from FDA.gov daily, but recently (when I bothered paying attention to it) I noticed that most days it doesn’t retrieve any new warning letters.

Then I started paying attention, and for the past 3 weeks, my bot only fetches new letters on Tuesday mornings (EST).

Not Monday night (I checked).

Not Tuesday at 6 AM (I checked).

Only Tuesday mornings between ~9 and ~11AM.

So, this smells like a human who has a Tuesday morning to-do list. Task # 1? Push out last week’s warning letters.

Why this can’t be automated on a daily basis? Beats me.


Conclusion 2. Updating of clinical trial data @ clinicaltrials.gov is done by the same person/entity/thing at FDA. This conclusion is far more tenuous, but hear me out.

(admittedly weak) Reasoning?
Every day, I have another bot that fetches new clinical trials data.

Every day, the bot finds updated data around 10AM--Except on Tuesdays when the new data show up around 11:30AM.

Tuesday’s task # 2? Push out new clinical trial data.

Updated FDA Search add-on for Firefox (WOHOOO!)

Just updated the FDA Search add-on from version 0.3.0 to 0.6.0 (I just make these numbers up as I have no idea what they're supposed to mean).

It's a pretty significant upgrade, so I doubled the version #.

What can it do now?

you can highlight a word or phrase and search

• the FDA's website
• the CDC's website
• drug adverse events
• vaccine adverse events
• drug safety analysis
• clinical trials
• FDA warning letters

Also has some nifty icons added, which took me 4ever to figure out how to add. Mozilla's xul documentation is horrendous.