[dbsector]

Smart-hospital.in Database

---

Publication Date: 2024-11-01 

File Format: CSV 

Number of Files Analyzed: 5 

---

General Description 

The Smart-hospital.in database file contains data related to hospital operations, covering various management aspects such as appointment calendars, ambulance dispatch records, birth and death registries, and blood component billing.

---

Analyzed Files: 

1. Ambulance Call List.csv 

  - Number of Records: 98 

  - Number of Columns: 13 

  - Key Columns: Bill No, Case ID, Patient Name, Vehicle Number, Contact Number, Date, Driver Name 

  - Sample Record: Bill No: ACB372, Case ID: 115, Patient Name: Olivier Thomas (1), Vehicle Number: MP20SC1797, Contact Number: 7896541230, Date: 10/12/2024 05:35 PM, Driver Name: Ravi, Amount ($): 172.5

---

2. Appointment.csv 

  - Number of Records: 809 

  - Number of Columns: 13 

  - Key Columns: Patient Name, Appointment No, Appointment Date, Consultant, Department, Amount 

  - Sample Record: Patient Name: Vaisali Sharma (1124), Appointment No: APPNO6747, Appointment Date: 10/31/2024 05:30 PM, Phone: 8890768756, Doctor: Sonia Bush (9002), Fees ($): 144.0

---

3. Birth Record.csv 

  - Number of Records: 14 

  - Number of Columns: 8 

  - Key Columns: Reference No, Case ID, Child Name, Gender, Birth Date, Mother’s Name 

  - Sample Record: Reference No: BREF71, Case ID: 6457, Child Name: Sterling, Gender: Male, Birth Date: 10/12/2024 11:46 AM, Mother Name: Maya Agarwal (1084)

---

4. Blood Components Issue Billing.csv 

  - Number of Records: 73 

  - Number of Columns: 12 

  - Key Columns: Bill No, Case ID, Issue Date, Received To, Blood Group, Component, Quantity, Amount 

  - Sample Record: Bill No: BIB606, Issue Date: 10/30/2024 10:15 AM, Received To: Averitt (1014), Blood Group: A-, Component: Plasma, Amount ($): 108.9

---

5. Death Record.csv 

  - Number of Records: 6 

  - Number of Columns: 7 

  - Key Columns: Reference No, Case ID, Patient Name, Guardian Name, Death Date, Cause of Death 

  - Sample Record: Reference No: DREF52, Case ID: 6663, Patient Name: Joseph A. Vance (1114), Guardian Name: Harry, Gender: Male, Death Date: 10/20/2024 11:47 AM

---

DL

Hidden Content

You must register or login to view this content.

Hidden Content

You must register or login to view this content.

---

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Scamming | Last Known IP: 188.146.12.134