The Six Core Epidemiological Research Questions
Methodological ArchitectureEvaluating US DailyMed, FDA, and international approvals for malaria, SLE, RA, and discoid lupus.
Mapping clinical applications in Sjögren's, APS, sarcoidosis, lichen planus, dermatomyositis, and COVID-19.
Applying modified GRADE scoring (0 to 5) from randomized trials (JOQUER, RECOVERY) and systematic reviews.
Analyzing WHO VigiBase, FAERS disproportionality signals (RORs), and Indian PvPI prophylaxis monitoring.
Investigating 609k Twitter stances and qualitative Reddit SLE patient threads on eye exams and tolerability.
Evaluating the misalignment between search queries, media hype (+109% surge), and negative clinical trials.
Dataset A: Approved & Off-Label Indications Master
| ID | Indication & Clinical Intent | Status | Evidence Score | Key Evidence / Primary Trial | Action |
|---|
Key Published Clinical Trials & Systematic Reviews
Sjögren's Syndrome: JOQUER Trial
Double-blind RCT comparing HCQ 400 mg/day vs placebo over 24 weeks. Primary endpoint: ≥30% improvement in 2 of 3 major symptoms (dryness, pain, fatigue).
Sarcoidosis: 2024 Observational Study
Evaluating 60 patients with cutaneous (22%) and musculoskeletal (75%) sarcoidosis. 55% sustained therapy beyond 24 weeks; 18.3% discontinued due to ADRs.
COVID-19: RECOVERY Trial
Large pragmatic open-label randomized trial. 1,561 patients assigned to HCQ vs 3,155 to usual care. Evaluated 28-day mortality, hospital stay, and mechanical ventilation.
Interactive Retinal Toxicity Risk Stratifier & AAO 2025 Screening Protocol
Patient Exposure & Clinical Risk Factors
Calculated Exposure & Risk Stratification
Interactive 2×2 Pharmacovigilance Disproportionality Calculator (ROR)
The Reporting Odds Ratio compares the odds of a specific target adverse event occurring with HCQ versus all other medicinal products in the pharmacovigilance safety repository:
| Database Stratum | Target Adverse Event (e.g., Cardiomyopathy) | All Other Reported Reactions |
|---|---|---|
| Hydroxychloroquine Reports | Cell a (Cases) | Cell b (Other HCQ ADRs) |
| All Other Drugs in Database | Cell c (Other drugs target) | Cell d (Other drugs other ADRs) |
An ROR of 29.0 indicates that cardiomyopathy was reported 29 times more frequently with HCQ compared to the background spontaneous reporting rate across all other medications in FAERS.
US FAERS Disproportionality Signals & Reporting Odds Ratios (ROR)
FAERS 1998–2019| Target Adverse Drug Reaction | Database Domain | Reported Cases | Reporting Odds Ratio (ROR) | 95% Confidence Interval | Signal Intensity |
|---|
Indian Pharmacovigilance Profile (PvPI & MoHFW Prophylaxis Safety Surveillance)
India National PVA. Prospective Healthcare Worker Safety Assessment (n=1,323)
Observed adverse events in high-risk healthcare workers receiving prophylaxis under MoHFW national protocol:
B. National PvPI Spontaneous Prophylaxis Reports (n=214)
Spontaneous individual case safety reports received by the Pharmacovigilance Programme of India (PvPI):
Consolidated 15 ADR Master Dictionary & MedDRA Coding Taxonomy
Standard Coding Dictionary| ADR ID | Preferred Term (PT) | Organ System | MedDRA System Organ Class (SOC) | Seriousness Potential | Key Research Variables |
|---|---|---|---|---|---|
ADR-01 | Nausea | Gastrointestinal | Gastrointestinal disorders | Usually non-serious | Frequency, meal timing, duration |
ADR-02 | Vomiting | Gastrointestinal | Gastrointestinal disorders | Variable (dehydration) | Volume, oral intake maintenance |
ADR-03 | Diarrhoea | Gastrointestinal | Gastrointestinal disorders | Variable | Bristol stool chart, non-infectious |
ADR-04 | Maculopapular rash | Dermatological | Skin & subcutaneous | Variable | Morphology, onset post-initiation |
ADR-05 | Pruritus | Dermatological | Skin & subcutaneous | Usually non-serious | Sun exposure, pigmentation, duration |
ADR-06 | Hyperpigmentation | Dermatological | Skin & subcutaneous | Usually non-serious | Cumulative exposure, shins/palate |
ADR-07 | Retinopathy | Ophthalmological | Eye disorders | Serious / Irreversible | Daily dose (mg/kg), duration, SD-OCT, VF |
ADR-08 | QT prolongation | Cardiac | Cardiac disorders | Serious | Baseline QTc, ΔQTc, concomitant QT drugs |
ADR-09 | Torsades de pointes | Cardiac | Cardiac disorders | Life-threatening | Azithromycin co-medication, electrolytes |
ADR-10 | Cardiomyopathy | Cardiac | Cardiac disorders | Serious / Disabling | Cumulative dose, hypertrophy, CMR/biopsy |
ADR-11 | Hypoglycaemia | Metabolic | Metabolism & nutrition | Potentially serious | Blood glucose, antidiabetic co-drugs |
ADR-12 | Cytopenia (Leukopenia, etc.) | Haematological | Blood & lymphatic system | Potentially serious | Complete blood count (CBC) |
ADR-13 | Myopathy (Vacuolar) | Musculoskeletal | Musculoskeletal & connective | Potentially serious | Proximal weakness, serum CK |
ADR-14 | Peripheral neuropathy | Neurological | Nervous system | Variable | Electromyogram (EMG), sensory/motor |
ADR-15 | Neuropsychiatric reactions | Psychiatric | Psychiatric disorders | Variable | Psychosis, agitation, sleep disturbance |
Dataset D: Evidence vs Public Attention Triangulation Visualizer
The Epistemic DisconnectThis interactive quadrant visualizes the relationship between Clinical Evidence Strength (modified GRADE score 0 to 5) on the horizontal axis and Public & Search Visibility Index (0 to 100) on the vertical axis across all evaluated HCQ indications.
Triangulation Master Matrix
| Indication | Clinical Evidence | Google Search Visibility | Social Media Stance | Disconnect Classification | Final Assessment |
|---|
Dataset E: Complete 28-Field Variable Dictionary
Quantitative Dataset ArchitectureStandardized data coding dictionary for building retrospective patient cohorts, pharmacovigilance registries, or SPSS/R/Python analytical pipelines:
| No. | Variable Identifier | Data Type | Coding / Permitted Values | Epidemiological Definition |
|---|
Organ-Specific Deep Clinical Sub-Modules
Ophthalmological Surveillance
weight_kg: Actual real body weight in kg (≤5.0 mg/kg target)cumulative_dose_g: Lifetime grams consumed (>1000g high risk)egfr_ml_min: Estimated GFR (<60 mL/min clearance deficit)tamoxifen_concomitant: Tamoxifen co-therapy (OR 4.59)oct_finding: Normal, 'Flying Saucer' sign, photoreceptor thinninghumphrey_vf_pattern: 10-2 paracentral vs 24-2/30-2 pericentral (Asian)
Cardiovascular Safety Sub-Module
baseline_qtc_ms: Pre-treatment Bazett/Fridericia corrected QTcfollowup_qtc_ms: On-treatment QTc (>500 ms or >60 ms prolongation)concomitant_qt_drugs: Azithromycin, antiarrhythmics, SSRIsechocardiogram_lvef: LV ejection fraction % (hypertrophy/CMR)endomyocardial_biopsy: Curvilinear bodies on electron microscopy
Cutaneous Adverse Event Sub-Module
morphology: Maculopapular, lichenoid, pustular (AGEP), bullousbody_surface_area_percent: Percentage BSA involvedmucosal_involvement: Oral, ocular, or genital mucosal erosionsskin_pigmentation_site: Blue-grey shins, hard palate, nail beds
Part G: The Seven Core Pharmacoepidemiological Findings
Part H: Research Limitations & Mitigation Framework
Methodological Rigor| Methodological Limitation | Potential Impact on Observed Results | Implemented Mitigation Strategy |
|---|
Part I: Primary Research Workbook (Ready-to-Build 6-Sheet Structure)
Select any of the six standardized project sheets below to inspect structured records, copy tabular data, or export directly to CSV for spreadsheet modeling:
Sources & Evidence Library (#sources)
Primary authoritative literature, randomized controlled trials, global pharmacovigilance repositories, clinical guidelines, and social infodemiology studies grounding this pharmacoepidemiological research dataset.