fda-database

FDA Database - openFDA Data Query Tool

Skill Overview

fda-database is a powerful Python tool for accessing and analyzing the U.S. FDA's public regulatory data, including adverse events, labeling information, recall records, and approval data for drugs, medical devices, food, and veterinary drugs.

Use Cases

1. Drug Safety Research and Pharmacovigilance

Researchers and drug safety professionals can query drug adverse event reports, analyze safety signals, monitor drug recalls, and obtain prescribing information and drug shortage data. It supports multidimensional searches by drug name, NDC code, reaction type, etc., suitable for post-market safety surveillance and comparative safety research.

2. Medical Device Regulation and Compliance Analysis

Medical device engineers and compliance experts can query device adverse events, 510(k) clearance records, PMA approval data, device classification, and UDI information. It supports searches by manufacturer, device type, and risk level, useful for post-market surveillance, competitor analysis, and regulatory pathway research.

3. Food Safety and Veterinary Drug Surveillance

Food safety officers and veterinary researchers can track food recalls (including allergens and contamination causes), monitor adverse events for dietary supplements, and query veterinary drug adverse reactions (supports search by species and breed). Suitable for food safety alerts, epidemiological investigations, and animal drug safety assessments.

Core Features

1. Unified openFDA API Query Interface

Provides a standardized Python interface to access all openFDA endpoints, including drugs, devices, food, veterinary drugs, and substances. Built-in automatic rate limiting, request caching, and error retry mechanisms. Supports API Key authentication to obtain higher request quotas (without key: 1,000/day; with key: 120,000/day).

2. Multidimensional Data Retrieval and Analysis

Supports complex query syntax, allowing searches by field, date range, and keyword combinations. Offers advanced query modes such as field counts, time trend analysis, and comparative analysis to help users quickly extract insights. Queryable data includes adverse events, product labels, the NDC directory, mandatory reports, 510(k), PMA, UDI, and 20+ other endpoints.

3. Cross-Database Linked Queries

Supports comprehensive queries across multiple FDA databases, for example querying a drug's adverse events, recall records, and shortage information simultaneously; or querying a medical device's adverse events, 510(k) clearances, and recall data. Facilitates comprehensive regulatory risk assessments and compliance reviews.

Frequently Asked Questions

Do I need to register an API Key for the openFDA API?

Not required, but strongly recommended. Without an API Key, the limit is 240 requests per minute and 1,000 requests per day. After registering an API Key (free), the daily request limit increases to 120,000. You can register at https://open.fda.gov/apis/authentication/ and then use it via the FDA_API_KEY environment variable or pass it directly.

What drug information can be queried in the FDA database?

Supports six major categories of drug data:

Adverse event reports (side effects, treatment failures, etc.)

Product labels (prescribing information, warnings, indications)

NDC directory (National Drug Code product information)

Mandatory reports (drug recalls and safety actions)

Drugs@FDA (historical approval data since 1939)

Drug shortages (current and resolved supply issues)

How do I query FDA medical device 510(k) clearance records?

Use the fda.query_device_510k() method, which can search by applicant name, device name, or device code. For example: fda.query_device_510k(applicant="Medtronic") or fda.query_device_510k(device_name="pacemaker"). The results include detailed information such as device description, submission date, and decision type.