FDA Drug & Device Data Scraper (OpenFDA)

Extract FDA drug approvals, adverse event reports, drug and device recalls, medical device 510(k) clearances, drug labels, and food recalls directly from the official OpenFDA API. This Actor provides structured access to over 44 million records across 8 FDA datasets, making it the most comprehensive OpenFDA data extraction tool on the Apify Store.

Whether you are a pharmaceutical researcher, healthcare compliance officer, medical device manufacturer, or data analyst, this Actor lets you pull exactly the FDA data you need without writing a single line of code. The OpenFDA API is free and public, and this Actor handles all pagination, rate limiting, and error handling automatically.

Key Features

Feature	Description
8 FDA Datasets	Drug adverse events, drug approvals, drug recalls, drug labels, device 510(k) clearances, device adverse events, device recalls, and food recalls
44M+ Records	Access the full breadth of FDA public data
OpenFDA Query Syntax	Use powerful search queries to filter by brand name, manufacturer, date range, and more
Automatic Pagination	Handles multi-page results up to the OpenFDA skip limit (26,000 offset)
Rate Limit Handling	Built-in 300ms delay between requests with automatic retry on rate limits
No API Key Required	Uses the free public OpenFDA API (240 requests/minute)
Structured JSON Output	Each record is pushed as a clean JSON object ready for analysis or RAG pipelines

Available Datasets

Dataset	Endpoint	Records	Use Case
Drug Adverse Events	drug_event	20M+	Side effect and safety reports (FAERS)
Drug Approvals	drug_approval	28K+	NDA/ANDA approval history
Drug Recalls	drug_recall	17K+	Drug enforcement and recall actions
Drug Labels	drug_label	255K+	Drug labeling, indications, warnings
Device 510(k) Clearances	device_510k	174K+	Medical device market clearances
Device Adverse Events	device_event	24M+	Medical device incident reports (MAUDE)
Device Recalls	device_recall	57K+	Medical device recall actions
Food Recalls	food_recall	28K+	Food enforcement and recall actions

How to Scrape FDA Data with OpenFDA

1. Go to the Actor page on the Apify Store and click "Start".
2. Select a Data Type from the dropdown (e.g., "Drug Approvals").
3. Enter a Search Query (optional). Use OpenFDA query syntax:
   • Drug approvals by brand: openfda.brand_name:"ibuprofen"
   • Drug events by drug: patient.drug.openfda.brand_name:"aspirin"
   • Drug recalls by firm: firm_name:"Pfizer"
   • Device 510(k) by product: product_code:"DQO"
   • Leave empty to get all records.
4. Set Max Results to control how many records to retrieve (default: 100, max: 26,000).
5. Click "Start" and wait for results.
6. Download your data in JSON, CSV, or Excel format from the Dataset tab.

Input Example

{
    "endpoint": "drug_approval",
    "searchQuery": "",
    "maxResults": 100
}

Searching for Specific Drugs

{
    "endpoint": "drug_event",
    "searchQuery": "patient.drug.openfda.brand_name:\"aspirin\"",
    "maxResults": 500
}

Getting Device 510(k) Clearances

{
    "endpoint": "device_510k",
    "searchQuery": "openfda.medical_specialty_description:\"Cardiovascular\"",
    "maxResults": 200
}

Output Example

Drug Approval Record

{
    "submissions": [
        {
            "submission_type": "ORIG",
            "submission_number": "1",
            "submission_status": "AP",
            "submission_status_date": "19820115",
            "submission_class_code": "TYPE 1",
            "submission_class_code_description": "Type 1 - New Molecular Entity"
        }
    ],
    "application_number": "NDA018612",
    "sponsor_name": "GLAXOSMITHKLINE",
    "openfda": {
        "application_number": ["NDA018612"],
        "brand_name": ["ZANTAC"],
        "generic_name": ["RANITIDINE HYDROCHLORIDE"],
        "manufacturer_name": ["GlaxoSmithKline"],
        "route": ["ORAL"],
        "substance_name": ["RANITIDINE HYDROCHLORIDE"]
    },
    "products": [
        {
            "product_number": "001",
            "brand_name": "ZANTAC",
            "active_ingredients": [
                {
                    "name": "RANITIDINE HYDROCHLORIDE",
                    "strength": "EQ 150MG BASE"
                }
            ],
            "dosage_form": "TABLET",
            "route": "ORAL",
            "marketing_status": "Discontinued"
        }
    ]
}

Pricing

Cost Component	Amount
Actor Start	$0.00005
Per Result	$0.002

Example costs:

• 100 drug approvals: ~$0.20
• 1,000 adverse event reports: ~$2.00
• 10,000 device recalls: ~$20.00

Users also pay for Apify platform compute on top of Actor pricing.

OpenFDA Query Syntax Reference

OpenFDA uses a specific query syntax. Here are common patterns:

• Exact match: field:"value" (e.g., openfda.brand_name:"aspirin")
• AND: field1:"value1"+AND+field2:"value2"
• OR: field1:"value1"+OR+field2:"value2"
• Date range: field:[20200101+TO+20201231]
• Exists: _exists_:field
• Wildcard: Not supported by OpenFDA

For full documentation, see OpenFDA API Reference.

Limitations

• Skip limit: OpenFDA caps the skip parameter at 26,000. For datasets larger than 27,000 records matching your query, use more specific search queries to narrow results.
• Rate limit: 240 requests/minute without an API key. The Actor includes built-in rate limiting (300ms between requests) and automatic retry with exponential backoff.
• Data freshness: OpenFDA data is updated periodically by the FDA. Check open.fda.gov for update schedules.

FAQ

Is it legal to scrape OpenFDA data?

Yes. OpenFDA is a free public API provided by the U.S. Food and Drug Administration. The data is in the public domain and not subject to copyright restrictions. This Actor uses the official API and complies with the OpenFDA Terms of Service.

How much does it cost to scrape OpenFDA?

The Actor charges $0.002 per result plus a $0.00005 Actor start fee. A typical run of 100 drug approvals costs approximately $0.20 in Actor fees. See the pricing table above for detailed estimates.

Can I export OpenFDA data to Excel or CSV?

Yes. Apify supports exporting data in JSON, CSV, Excel, XML, HTML, and RSS formats. After the Actor run completes, go to the Dataset tab and choose your preferred export format.

How often is the OpenFDA data updated?

You can schedule this Actor to run at any interval — daily, weekly, or monthly. OpenFDA data is updated periodically by the FDA. Check open.fda.gov for specific dataset update schedules.

What FDA datasets are available?

The Actor covers 8 FDA datasets: drug adverse events (20M+ records), drug approvals (28K+), drug recalls (17K+), drug labels (255K+), device 510(k) clearances (174K+), device adverse events (24M+), device recalls (57K+), and food recalls (28K+). That is over 44 million records total.

Other Scrapers by SeatSignal

• ClinicalTrials.gov Scraper — Extract data on 575K+ clinical studies from ClinicalTrials.gov
• Medicare Provider Scraper — Search 2.8M+ Medicare clinicians by specialty and location
• CPSC Product Recalls Scraper — Extract consumer product recall data from CPSC
• FDA Food Recalls Scraper — Extract FDA food enforcement and recall actions
• NHTSA Vehicle Safety Scraper — Extract vehicle safety complaints and recall data

Legal Disclaimer

This Actor accesses publicly available data from the OpenFDA API, which is a free public service provided by the U.S. Food and Drug Administration. The data is in the public domain and is not subject to copyright restrictions. This Actor does not bypass any authentication, access controls, or rate limits. Users are responsible for complying with the OpenFDA Terms of Service and for any use they make of the extracted data.

Support

For issues or feature requests, please open an issue on the Actor's page or contact the developer through the Apify Store.