Pisces Medicine
PISCES-Pinnacle Illuminations, Strategies Crafted for Exploration and Studies
"Pisces Medicine" stands as an autonomously developed online clinical data mining platform.
The platform undertakes a meticulous examination of raw data sourced from open-access clinical
databases, systematically reconstructing data relationships from the vantage point of clinical
researchers.A comprehensive database retrieval is executed through the utilization of pivotal
terminologies such as ICD-10 diagnoses. Under the precondition of ensuring the precision
of raw data, the platform strives to significantly lower the barriers for clinical researchers
regarding data extraction and analysis. The incorporation of a "0" code mechanism streamlines
the utilization of clinical data, effectively mitigating challenges faced by researchers in
the pursuit of clinical studies. In a commitment to further aid researchers in subsequent in-depth
investigations, we furnish graphical descriptive statistics of the retrieved data, providing
a visual representation of the salient characteristics within the search results.

Currently accessible online with eICU-CRD, "Pisces Medicine" is in continuous development with an
ongoing focus on expanding its capabilities to encompass other public open-source clinical
databases. Anticipate forthcoming updates as we endeavor to enhance and enrich the platform's functionalities.
Instructions
Definition
Explanation of terms appearing in the system
Name Definition
PatientID Patient identification number
DiagnosisString Patient diagnostic information
Gender Gender
Age Age
Ethnicity Ethnicity
BMI Body Mass Index
ICUType ICU types include Med-Surg ICU,Cardiac ICU,CCU-CTICU,
MICU,SICU,CTICU,Neuro ICU and CSICU
ICUTime Total ICU treatment time
DischargeICUStatus Discharge ICU status
DischargeHospitalStatus Discharge hospital status
AdmissionWeight Admission weight
DischargeWeight Discharge weight
APS Acute physiology score
ApacheScore Acute Physiology and Chronic Health Evaluation Score
pastHistoryValue Patient's Past History
pgtype The types of patient's past history include Cardiovascular,Endocrine,Gastrointestinal,
Infectious Disease,Neurologic,Oncology,Pulmonary,Renal,Rheumatic
Duration Of Medication Duration Of Medication
DrugName DrugName
DrugNameAs Abbreviation of drug terms
Dosage Dosage
RouteAdmin RouteAdmin
Frequency Frequency
TreatmentString Patient treatment methods
Treatment Group Treatment group include gastrointestinal,infectious diseases,
cardiovascular,endocrine,general,hematology,neurologic,oncology,
pulmonary,renal,surgery,transplant,burns/trauma,toxicology
PhysicalExamInfor Physical examination information
PhysicalExamGroup Physical examination group include Constitutional,Neurologic,Cardiovascular,Chest and Back,Extremities,Gastrointestinal,Head and Neck,Pulmonary,Skin
PhysicalExamValue Structured picklist of available of physical exam items: O2 Sat% Highest, withdraws to pain, HR Current, etc
LabName The picklist name of the lab
LabResult The numeric value of the lab
Lab Measure The measurement name of the lab
Organism Picklist organism found e.g.: Staphylococcus aureus, Pseudomonas aeruginosa, no growth, etc
Micro Lab type Micro lab type include None ,Stool ,Bronchial Lavage ,Blood ,Sputum ,Wound ,Abscess ,Peritoneal Fluid ,Urine ,CSF
Antibiotic Antibiotic
Sensitivity Level Picklist sensitivity level of antibiotic: Intermediate, Resistant or Sensitive