Vaccine Database

Comprehensive catalog of vaccines, products, manufacturers, and regulatory information. Search through hundreds of vaccines with detailed platform and approval data.

Vaccines Table

Core vaccine data including common names, disease targets, platforms, and status

Fields: 7
Primary Key: vaccine_uid

Products Table

Brand names, manufacturers, and regulatory approval details

Fields: 10
Primary Key: product_id

Sources Table

Evidence links, documentation, and reference materials

Fields: 6
Primary Key: source_id

Database Query Interface

347
Total Vaccines
1,248
Products
156
Manufacturers
2,891
Source Links

Database Records

Browse vaccine entries with detailed product information, regulatory data, and source documentation

Vaccines Table

Core vaccine information and classification data

Vaccine UID Common Name Disease Target Platform Status First Use Actions
VAC-COVID-001 COVID-19 mRNA SARS-CoV-2 mRNA in_use 2020-12-11
VAC-FLU-002 Seasonal Influenza Influenza A/B inactivated in_use 1945-01-01
VAC-MMR-003 Measles, Mumps, Rubella Measles/Mumps/Rubella live_attenuated in_use 1971-04-01
VAC-HPV-004 Human Papillomavirus HPV Types 16,18,6,11 protein_subunit in_use 2006-06-08
VAC-EXP-005 Experimental Cancer Multiple Cancer Types viral_vector investigational -

Products Table

Brand names, manufacturers, and regulatory information

Product ID Vaccine UID Brand Name Manufacturer FDA BLA WHO PQ Actions
1001 VAC-COVID-001 Comirnaty Pfizer-BioNTech 125742 Yes
1002 VAC-COVID-001 Spikevax Moderna 125663 Yes
1003 VAC-MMR-003 M-M-R II Merck & Co. 103516 Yes
1004 VAC-HPV-004 Gardasil 9 Merck & Co. 125508 Yes

Sources Table

Documentation, evidence links, and reference materials

Source ID Vaccine UID Evidence Type Source URL Added Actions
5001 VAC-COVID-001 Clinical Trial https://clinicaltrials.gov/ct2/show/NCT04368728 2024-01-15
5002 VAC-COVID-001 FDA Approval https://www.fda.gov/news-events/press-announcements/... 2024-01-10
5003 VAC-MMR-003 Safety Study https://pubmed.ncbi.nlm.nih.gov/12345678 2024-01-08
5004 VAC-HPV-004 Efficacy Data https://www.nejm.org/doi/full/10.1056/... 2024-01-05

Database Schema Information

Vaccines Table

Primary Key: vaccine_uid (text)
Foreign Keys: None
Constraints: status_current_use check constraint
Indexes: Primary key index

Products Table

Primary Key: product_id (bigserial)
Foreign Keys: vaccine_uid → vaccines
Constraints: None
Indexes: Primary key, FK indexes

Sources Table

Primary Key: source_id (bigserial)
Foreign Keys: vaccine_uid → vaccines, product_id → products
Constraints: None
Indexes: Primary key, FK indexes

Interactive Vaccine Catalog

Real-time searchable database with filtering capabilities, modeled after your React component

Loading vaccines...
Name Disease Platform Manufacturer Status First Public Use Earliest Trial Reg. Authority WHO PQ FDA BLA EMA Proc.

Loading vaccine data...

Please wait while we fetch the latest information

Data Sources: Source fields should cite WHO PQ, FDA CBER, EMA EPARs, CDC Pink Book, and trial registries for dates. Keep a per-row list of URLs for auditability. Data is refreshed from API endpoints matching your database schema.

🚀 Connect Your Seed Data API

Ready to load your vaccine_catalog_seed.json data? Follow these simple steps to connect your Next.js API.

1

Deploy Your Next.js API

Deploy to Vercel (Recommended)

vercel --prod

Gets you a URL like: your-app-name.vercel.app

Alternative Platforms

  • • Railway: Connect GitHub repo
  • • Render: Auto-deploy from Git
  • • Netlify: Functions for API routes
2

Connect to Frontend

Update JavaScript

// In vaccines page JavaScript:

vaccineCatalog.setApiEndpoint(

'https://your-app.vercel.app/api/vaccines'

);

For Local Testing

Add CORS headers to your API route for local development

📋 Expected Seed Data Structure

Your vaccine_catalog_seed.json should be an array of objects with these fields:

Required Fields

  • vaccine_uid string
  • vaccine_common_name string
  • disease_target string

Optional Fields

  • product_name_brand string
  • platform string
  • status_current_use enum
  • who_prequalified boolean
Sample JSON Structure: 
[
  {
    "vaccine_uid": "VAC-COVID-001",
    "vaccine_common_name": "COVID-19 mRNA",
    "disease_target": "SARS-CoV-2",
    "product_name_brand": "Comirnaty",
    "platform": "mRNA",
    "manufacturer_primary": "Pfizer-BioNTech",
    "status_current_use": "in_use",
    "who_prequalified": true,
    "fda_bla_number": "125742"
  }
]

📊 Connection Status Indicators

API Connected

Successfully loading seed data from your API

Local Sample Data

Using built-in sample data (no API configured)

Connection Failed

API error - using fallback sample data

Deploy to Vercel Next.js API Docs