Inspiration: For patients visiting hospitals’ emergency rooms, the seemingly never-ending time in the waiting room can be exhausting. Especially during the COVID-19 Pandemic, where protocols are implemented to restrict visitors, spending long hours in the ER alone can become challenging for individuals requiring ongoing care.

What it does: The website HospitalHost is designed to provide its users with a coherent overview of the estimated wait times at nearby hospitals. Operating on a dynamic database into which patient logs are constantly updated, HospitalHost aims to optimize efficiency in access to medical care, while also promoting patient comfort. Once a hospital staff/volunteer submits information on a patient who has arrived at the ER, an update to the patient log will be generated in the website's staff portal. Contents displayed in this log include the priority level of the patient’s case determined by a medical practitioner, and the patients’ estimated wait time. Distinguished by hospitals, the inputted data will be merged into a “total estimated wait time” to be presented to the public. The system will then generate an output that displays the hospital with the shortest estimated wait time.

How we built it: To manage and render components from an evolving dataset, our team used the React JavaScript Web development framework to construct our website. We also used an express and node.js backend to create a REST API that executed queries on a MySQL database and returned information in JSON format to our React App.

Challenges we ran into: Merging the backend data with the front end of the website. The first challenge was to learn SQL Query Language which is used to interact with the MySQL Database - a language that none of us were comfortable using prior to this hackathon.Additionally, creating the API design proved to be a challenging process as a well-designed API needs to be as simple but as effective as possible. With this in mind, we had to try our best to envision the complete structure of the application prior to writing any code to help save us time when making the api calls through the react app..

Accomplishments that we're proud of: We had a very collaborative team. We met each other online and formed our team the night before the event started. We are also proud of our diversity. Every team member was being very respectful to each other. Although the software we used to construct our projects were unfamiliar to some of us at first, our group accepted the challenge with enthusiasm.

What we learned: Being more resourceful in the programming software/databases we use to enhance the efficiency in project development.

What's next for EngHacks2021Hospital: --Obtaining patient location and factoring in proximity for hospital suggestions (output) --Implementing a system to collect user feedback --Intelligently deciding the priority of a patient’s issues based on some written description --Creating a built-in call system to directly contact hospitals --Communicating with hospitals to promote website usage --Enhancing the website’s visual appeal

Share this project: