Connecting…
Drag & Drop any WHONET .sqlite file here, or click to upload
Works directly with standard WHONET files from C:\WHONET\Data or custom folders/downloads.
Overview
Analytics
Visual distribution across selected clinical parameters
Frequency
Breakdown (%)
0 records
All Laboratory Isolates
Loading isolates…
Phenotype Columns
No database loaded
Please open or upload a WHONET SQLite database to view isolates.
Duplicate Isolates
Grouped by Specimen ID (case-insensitive)
Mixed-case SPEC_NUMs detected — e.g. csbl-135 ≠ CSBL-135. Normalize first for accurate duplicate detection.
No database loaded
Please open or upload a WHONET SQLite database to inspect duplicate records.
Bulk Data Corrections
Apply standardized quality fixes across all database records
SPEC_NUM → Uppercase
Normalize all specimen numbers to uppercase to prevent case-sensitive duplicate mismatches.
UPDATE Isolates SET SPEC_NUM = UPPER(SPEC_NUM)
PATIENT_ID → Uppercase
Normalize Patient IDs to uppercase for consistent lookups and deduplication.
UPDATE Isolates SET PATIENT_ID = UPPER(PATIENT_ID)
Trim Whitespace
Remove leading and trailing spaces from SPEC_NUM, PATIENT_ID, WARD, and DEPARTMENT (plus FULL_NAME when stored as a plain column).
UPDATE Isolates SET field = TRIM(field)
ORGANISM → Lowercase
Standardize organism codes to lowercase as used in official WHONET code lists.
UPDATE Isolates SET ORGANISM = LOWER(ORGANISM)
Fix History (This Session)
No fixes applied yet
SQL Query Console
Execute arbitrary SELECT or UPDATE queries directly on the current database (Ctrl+Enter to run)
Duplicates
Dup Groups
UPPER SPEC_NUM
Full Dup Query
Results will appear here…
Monthly AMR Data (SAPCAR-G)
Culture & Sensitivity (C&S) Surveillance Data
Month,
Year		 Total no. of samples received for culture
(Source of sample) 		Total
Sample		 Total no. of
Culture Positive Samples 		Total
Positive
Sample 		Total no. of Samples received for culture
(Type of sample) 		Total
Sample		 Total no. of
Culture Positive Samples 		Total
Positive
Sample
OPD IPD ICU Others OPD IPD ICU Others Blood Pus Sputum Urine Others Blood Pus Sputum Urine Others
No database loaded — please open or select a WHONET database to view surveillance data.
Sample Definitions:
  • No growth / normal commensals are defined as:
    • Blood: xxx (no growth), xpa, nor (normal flora), or scn (CoNS/skin contaminant).
    • Other Sample Types: xxx, xpa, xep, xsg, nor, ora, or vag.
  • All other pathogens are identified and counted as positive growth.