Data Explorer

Query and explore hospital data across all modules.

SELECT department, COUNT(*) as visits, AVG(wait_time) FROM patient_visits GROUP BY department

Source: patient_visits

1,847 results

#

Department

Visits

Avg Wait

Revenue

Satisfaction

Trend

1

Emergency

4,821

12 min

KES 4.7M

4.8/5.0

2

Outpatient

12,847

23 min

KES 8.2M

4.5/5.0

3

Inpatient

3,486

45 min

KES 6.1M

4.2/5.0

4

Surgery

892

N/A

KES 3.4M

4.6/5.0

5

Maternity

1,274

18 min

KES 2.8M

4.7/5.0

6

Pediatrics

2,031

15 min

KES 1.9M

4.9/5.0