DATA FOUNDRY · LIFE SCIENCES
Normalized FDA pharmaceutical product labeling and safety data.
Comprehensive structured dataset of 45,300 drug product records from the official OpenFDA directory. Includes active ingredients, indications, contraindications, and NDC identifiers.
COMMERCIAL ACCESS
Verified Parquet archives + Claude MCP integration
- ✓ Verified Data Foundry Parquet partitions (zstd)
- ✓ Model Context Protocol (MCP) tool integration
- ✓ Metering: Inquire for Access
- ✓ Deterministic quality gate & hash verification
- ✓ Contractual commercial rights clearance
Quotes reviewed by systems engineering within 1 business day
COLUMN SPECIFICATIONS
Typed relational schema.
Columnar Parquet & DuckDB ready.
| Column Name | Data Type | Description |
|---|---|---|
spl_id |
VARCHAR(64) | FDA Structured Product Labeling identifier |
brand_name |
VARCHAR(128) | Commercial brand or proprietary name |
generic_name |
VARCHAR(150) | Normalized active pharmaceutical ingredient name |
dosage_form |
VARCHAR(64) | Pharmaceutical dosage form (tablet, capsule, injection) |
indications_and_usage |
TEXT | FDA approved therapeutic indications |
contraindications |
TEXT | Contraindications and patient warning text |
SYSTEM STATUS & CAPABILITY BOUNDARIES
Engineering reality.
Verified operational features vs planned protocol capabilities.
Verified Operational Today
- ✓ Apache Parquet Partitions: Columnar archives (Zstandard compressed) with typed relational schemas.
- ✓ Zero-Copy Local Analytics: In-memory SQL exploration via DuckDB, Python Polars, and Arrow.
- ✓ Cryptographic Deduplication: SHA-256 release manifests and seen-keys ledger preventing record drift.
- ✓ Statutory Rights Clearance: 100% license-cleared provenance with statutory citations.
- ✓ Technical Quote Intake: Systems engineering review and schema sample verification.
Pilot & In-Specification Capabilities
- ◌ Remote MCP Streaming Adapter:
foundry_query_drug_labelstool endpoint available under enterprise pilot agreements. - ◌ Automated Micro-Settlement: Agent-to-agent procurement and escrow via EXCHANGER (active protocol specification).
- ◌ Multi-Region Edge Replicas: Global Cloudflare R2 bucket replication currently in private validation.
VERIFIED SAMPLE RECORD
Inspect the raw payload.
Zero mocked fields.
{
"spl_id": "9f83a01-2026-spl",
"brand_name": "Advil Liqui-Gels",
"generic_name": "IBUPROFEN",
"dosage_form": "CAPSULE, LIQUID FILLED",
"route": "ORAL",
"source": "openfda_drug_labels"
}
AGENT INTERFACE & MCP TOOL CONTRACT
Plug directly into Claude Code, Codex, and autonomous workflows.
Deterministic data retrieval.
Machine-Readable Contract
Direct dataset extraction is delivered via high-throughput columnar Apache Parquet. For autonomous assistants, ELYRAON provides standard Model Context Protocol (MCP) tool schemas and REST integration adapters with signed SHA-256 integrity receipts.
Adapter identifier: foundry_query_drug_labels
Pricing status: Inquire for Access
Active MCP Endpoint: https://elyraon.com.co/agents/mcp (Host to live structural verification tools; metered dataset adapters available in scoped pilots).
{"tool": "foundry_query_drug_labels", "arguments": {"active_ingredient": "Ibuprofen"}}
MACHINE-READABLE SPECIFICATIONS
Structured metadata for autonomous agents.
Zero scrapers, zero hallucinations.
{
"entity_id": "https://elyraon.com.co/datasets/openfda-pharma-adverse-events/#dataset",
"catalog_id": "https://elyraon.com.co/datasets/#catalog",
"canonical_url": "https://elyraon.com.co/datasets/openfda-pharma-adverse-events/",
"primary_format": "application/vnd.apache.parquet",
"compression": "zstd",
"ingestion_pipeline": "openfda_drugs.py",
"mcp_tool_name": "foundry_query_drug_labels",
"license": "Creative Commons CC0 1.0 & U.S. Government Open Data",
"duckdb_quickstart": "SELECT * FROM read_parquet('openfda-pharma-adverse-events.parquet') LIMIT 5;"
}
WHY ELYRAON DATA FOUNDRY
Architectural contrast.
Built for engineering reality.
Transforms unwieldy FDA SPL XML files into clean, columnar Parquet tables queryable in sub-seconds without regex headaches.
Conventional Data Feeds
- Undetected socket drops during volatility
- Messy unstructured CSV/JSON with broken parsers
- Ambiguous copyright terms creating lawsuit liability
- Expensive multi-thousand dollar rigid contracts
ELYRAON Data Foundry
- Continuous quality gate reconciliation
- Clean, typed, content-addressed Apache Parquet
- 100% license-cleared provenance with statutory citations
- Clear request-quote pricing and cryptographic delivery verification
RELATED DATASETS & AGENT PLATFORM
Connected intelligence feeds.
Cross-domain discovery and autonomous infrastructure.
TECHNICAL FREQUENTLY ASKED QUESTIONS
Clear answers.
Engineering boundaries.
What is the verified inventory size?
45,300 verified pharmaceutical labeling records in `openfda_drug_labels`.
Is patient personal identifiable information (PII) present?
No. This dataset contains drug product labeling, indications, and ingredients only; zero patient records.
Can biotech teams train medical LLMs on this?
Yes. Sourced under CC0 and public domain terms, ensuring complete commercial safety.
Are active ingredients standardized?
Yes. Generic chemical names are normalized across products.
How is access granted?
Inquire with your technical team to receive sample Parquet partitions.