AMPATH launched AMRS to make patients records easier to find. They used the Elastic Stack to develop visualisations for their users.

The <a href="https://www.ampathkenya.org/">Academic Model Providing Access to Healthcare</a> (AMPATH) was founded in 2001 to combat one of the world’s worst epidemics: HIV. AMPATH is a partnership between the Kenyan Ministry of Health, Moi University in Eldoret, Kenya, and a consortium of American universities.
<h2>The challenge: Paper charts and paper records
</h2>In most parts of the world, reliable patient records are hard to find. Access to patient data in clinics is a critical part of healthcare. However, paper records are hard to read, get lost or damaged, and are inefficient to store and retrieve. Imagine having to pull hundreds of charts daily from this stack of records:
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blte22b81766ce71874/5d5da3dcd47d0742ac772761/ampath-medical-records-blog.jpg" data-sys-asset-uid="blte22b81766ce71874" alt="Manual paper filing of records " style="display: block; margin: auto;">
Another problem with paper records is that they make reporting difficult. Separate books, called registers, are used to track patient data for aggregate government reporting. Sometimes several registers must be filled out to collect the information from a single visit.
A register is essentially a spreadsheet. Rows and columns track patient metrics. The results from each page are tallied and transferred to other registers. This is a slow, error-prone, time-consuming, unreliable process that leads to delayed reports.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt91fccdf3de93a257/5d5da2ddef04464325fb845c/ampath-registers-blog.jpg" data-sys-asset-uid="blt91fccdf3de93a257" alt="Logging records in manual registers" style="display: block; margin: auto;">
<h2>Making the move to digital
</h2>To manage the huge volumes of charts and develop better reports on patient care, AMPATH helped develop an open-source electronic medical record called OpenMRS. Launched in 2006, <a href="https://en.wikipedia.org/wiki/OpenMRS">OpenMRS</a> is currently used in over 60 countries around the world.
By 2015, widespread affordable cellular networks and affordably priced tablets allowed AMPATH to deploy an implementation of OpenMRS designed to run on tablets, called the <a href="http://www.gregoryschmidt.ca/writing/history-of-ampath-medical-record-system">AMPATH Medical Record System</a> (AMRS), which was designed for use during clinical appointments.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/bltdd370567952f5040/5d5da51b5b220072e8aa2b37/ampath-amrs-blog.jpg" data-sys-asset-uid="bltdd370567952f5040" alt="AMPATH Medical Records System" style="display: block; margin: auto;">
<h3>Moving to the Elastic Stack
</h3>Every day hundreds of providers across Western Kenya use AMRS. This results in a huge amount of data that needs to be managed and made available to key decision makers such as clinicians, clinic administrators, and the Ministry of Health.
Initially, AMPATH <a href="http://www.gregoryschmidt.ca/writing/ampath-ehr-current-data-capabilities">wrote custom code for each new visualization</a> and each new dashboard. The trouble is this took a lot of developer time, the visualizations created were slow to load, and they were hard to debug.
Stakeholders often requested new data visualizations, and it was hard to keep up with the demand using custom code. There was also interest in finding a tool to allow everyone to design their own visualizations, which would help them to better leverage their data and would free up developers’ time.
AMPATH required a solution that could handle a lot of data. The database has almost 8 million visit encounters, with 250 million clinical questions asked.
The Elastic Stack stood out as the right tool. It can handle large data sets and has an easy-to-use interface, a wide feature set, a great community with good documentation, and pricing aligned with AMPATH’s needs.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt92c9d5808c9d1497/5d5da561999e83431b7656d8/ampath-stats-blog.jpg" data-sys-asset-uid="blt92c9d5808c9d1497" alt="AMPATH data and statistics" style="display: block; margin: auto;">
<h2>AMPATH’s ETL process
</h2>In 2017 AMPATH started development on an extract, transform, load (ETL) process to move data from the electronic medical record MySQL database, through Logstash, into Elasticsearch. Kibana is then used to generate dashboards.
Let's look at the process in the real world.
<h3>Data collection
</h3>Clinicians use AMPATH’s application on their tablet’s web browser during the clinical visit. The application is built in Angular and stores data in a MySQL database exposed via a REST API in OpenMRS.
<h3>Data storage and ETL
</h3>To make reporting easier, the relational tables are flattened using the ETL process. <a href="https://github.com/AMPATH/etl">SQL scripts</a> extract the desired data by performing joins on several tables. The data is then transformed into a form that answers the questions asked (e.g., is this patient currently on antiretroviral drugs?). A SQL scripts then loads the transformed data into a MySQL table. This is now a flattened table.
Each flattened table represents a report. These reports are distributed to different decision makers and users.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt70e6f994770a02a8/5d5daad765c1577f11a494ba/ampath-diagram-blog.jpg" data-sys-asset-uid="blt70e6f994770a02a8" alt="AMPATH data pipeline" style="display: block; margin: auto;">
<h3>Ingestion into Elasticsearch
</h3>After the flattened data is stored in MySQL tables, it is ready to be consumed by Elasticsearch. This is done with Logstash. One of the benefits of Logstash is its ability to consume data from a variety of data sources.
Logstash consumes the MySQL data and pumps it into Elasticsearch in real time using the <a href="https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html">JDBC input plugin</a>. This plugin supports scheduling and selective data as input by using SQL queries. Each row in the MySQL table is considered a single event, and the columns in each row (event) are considered fields in the event.
<a href="https://medium.com/@fatmali/https-medium-com-fatmali-how-to-setup-a-docker-elk-elastic-logstash-kibana-stack-in-a-jiffy-ab56e2660416">AMPATH’s Elastic Stack is set up on a separate server from MySQL</a> using <a href="https://www.docker.com/">Docker</a>. AMPATH’s <a href="https://gist.github.com/Fatmali/c860f6046f821208a9af55bec49928c9">Logstash</a> config file is used to query the MySQL tables. Check out <a href="https://qbox.io/blog/migrating-mysql-data-into-elasticsearch-using-logstash">this blog post</a> for more details on AMPATH’s Logstash process.
<h2>Kibana visualizations
</h2>AMPATH started building Kibana visualizations in 2018 with a dedicated team, expanding the visualization component library, building new dashboards, and training new users on how to use Kibana.
These visualizations will be used by clinicians, clinic administrators, and key decision makers in AMPATH and the Ministry of Health.
Below are some examples of system monitoring Kibana dashboards currently in use.
90-90-90 Trend Analysis Dashboard
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt01b888705a604cf5/5d5da6abac511e7362584693/ampath-trend-analysis-blog.jpg" data-sys-asset-uid="blt01b888705a604cf5" alt="ampath-trend-analysis-blog.jpg">
 
Overview of trends of HIV viral suppression in a clinic
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt8d1ab99f9386299e/5d5daa482372b57f91ccc125/ampath-vl-analysis-blog.jpg" data-sys-asset-uid="blt8d1ab99f9386299e" alt="Dashboard showing HIV viral load suppression" style="display: block; margin: auto;">
 
Using these charts to view the trends, the clinicians and the management of a clinic can check if a patient's HIV treatment is meeting international targets. This is a critical indicators for clinics.
Control of HIV viral load suppression (an indicator of HIV treatment control), compared across multiple counties
	
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blte4e5bb799f042884/5d5da81465c1577f11a49498/ampath-vl-to-target-blog.jpg" data-sys-asset-uid="blte4e5bb799f042884" alt="HIV viral load suppression compared to target rates" style="display: block; margin: auto;">
 
Comparison of HIV viral load suppression with target rates
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt1db0b2340648f3ba/5d5da8ca3f108672e37b00aa/ampath-vl-suppression-blog.jpg" data-sys-asset-uid="blt1db0b2340648f3ba" alt="HIV viral load suppression compared to target rates." style="display: block; margin: auto;">
 

	Utilizing anomaly detection in server response times with machine learning
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt8394c9a1ad7d6d27/5d5da8f7c0e6e77f8baf24f7/ampath-uptime-blog.jpg" data-sys-asset-uid="blt8394c9a1ad7d6d27" alt="AMPATH uptime monitoring" style="display: block; margin: auto;">
 

	While AMPATH’s primary use case is monitoring and visualizing HIV-related health data, it also use the Elastic Stack for a variety of other uses, including uptime monitoring and log analytics.

	Generating dashboards on the fly is a request AMPATH devs face on a daily basis. Before Kibana, this process was long and tedious, taking several weeks to code and produce visualizations that were often slow as they involved fetching data from a relational database. With Kibana, the AMPATH visualization team is able to create visualizations on the fly and embed them to the EMR. Users can then view and query the visualizations efficiently and quickly.
HIV Daily Clinic Overview Dashboard - overview of the HIV care system
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt051542fb3689a6f6/5d5da92f3f108672e37b00b8/ampath-clinic-overview-blog.jpg" data-sys-asset-uid="blt051542fb3689a6f6" alt="AMPATH clinic overview" style="display: block; margin: auto;">
 
The following dashboard is helpful for administration to know which locations may have long waits.
HIV Daily Clinic Overview Dashboard - comparing the average wait time to see clinicians
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt56be5a2789fd8944/5d5da959999e83431b76570c/ampath-clinic-encounters-blog.jpg" data-sys-asset-uid="blt56be5a2789fd8944" alt="AMPATH clinic encounters dashboard" style="display: block; margin: auto;">
 
<h2>Next steps
</h2>This coming year AMPATH would like to expand its dashboards to cover new disease verticals, and train users to be able to build their own Kibana visualizations. We also hope to expand the use of Elastic’s machine learning features for monitoring system performance.
<hr>Elastic has been an indispensable part of AMPATH’s mission to provide healthcare in low-resource settings. As AMPATH continues to expand its care system, there is no doubt that the success in patient care is linked to timely accessible to data. This is made possible with the Elastic Stack.
Authors’ Bios
	
Fatma Ali is a full stack developer in Eldoret, Kenya and is AMPATH’s ETL lead (<a href="https://medium.com/@fatmali">https://medium.com/@fatmali</a>)
Susan Mastamet is AMPATH’s visualization lead in Eldoret, Kenya.
Gregory Schmidt, MD designs medical record systems with AMPATH. (<a href="http://www.gregoryschmidt.ca">www.gregoryschmidt.ca</a> @_GregSchmidt)
Jonathan Dick, MD is the Chief Medical Information Officer at AMPATH.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/bltfd2924fb5224b866/5d5da97e999e83431b765712/ampath-team-photo-blog.jpg" data-sys-asset-uid="bltfd2924fb5224b866" alt="AMRS team photo" style="display: block; margin: auto;">
<figcaption>
AMRS Team
</figcaption>

Ampath-Banner.jpg

Ampath-thumbnail.jpg

AMPATH: Providing healthcare in rural Kenya using the Elastic Stack

Start free trial

Blog Footer CTA

Sign up for Elastic Cloud free trial

AMPATH medical record team

The content on this page is not available in the selected language. As Elastic grows globally, we continue to support content in multiple languages.

The content on this page is not available in the selected language.

El contenido de esta página no está disponible en el idioma seleccionado. Elastic está trabajando para garantizar que el contenido esté disponible en varios idiomas. Gracias por tu paciencia mientras trabajamos.

By submitting you acknowledge that you've read and agree to our <a href="/legal/elastic-cloud-account-terms" target="_self">Terms of Service</a>, and you agree to receive the <a href="/legal/privacy-statement#how-we-use-the-information" target="_self">selected communications</a> at the contact details you provided above. See <a href="/legal/privacy-statement/" target="_self">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Communication Preferences - ONLY for /communication-preferences

Al enviar, confirma que ha leído y acepta nuestras <a href="/es/legal/elastic-cloud-account-terms" target="_self">Condiciones de servicio</a>, y que acepta recibir las <a href="/es/legal/privacy-statement#how-we-use-the-information" target="_self">comunicaciones seleccionadas</a> en los detalles de contacto que proporcionó anteriormente. Consulte la <a href="/es/legal/privacy-statement/" target="_self">Declaración de privacidad de Elastic</a> para obtener más información o para cancelar su suscripción en cualquier momento.

By submitting you acknowledge that you've read and agree to our <a href="/legal/serverless-preview-terms" target="_blank">Terms of Service</a>, and that Elastic may <a href="/legal/privacy-statement#how-we-use-the-information" target="_blank">contact you</a> about our related products and services, using the details you provide above. See <a href="/legal/privacy-statement/" target="_blank">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Serverless GDPR Text

Al enviar, confirma que ha leído y acepta nuestras <a href="/es/legal/serverless-preview-terms" target="_self">Condiciones de servicio</a>, y que Elastic puede <a href="/es/legal/privacy-statement#how-we-use-the-information" target="_self">ponerse en contacto con usted</a> acerca de nuestros productos y servicios relacionados. Consulte la <a href="/es/legal/privacy-statement/" target="_self">Declaración de privacidad de Elastic</a> para obtener más información o para cancelar su suscripción en cualquier momento.

By submitting you agree to <a href="/agreements/global/cloud-services-monthly" rel="nofollow">Elastic Cloud Terms of Service</a>. Your personal data will be processed in accordance with <a href="/legal/privacy-statement">Elastic's Privacy Statement</a>.

Cloud Trial GDPR Text

Al enviar esta información, aceptas los <a href="/es/agreements/global/cloud-services-monthly" rel="nofollow">Términos de servicio de Elastic</a>. Los datos personales se procesarán de conformidad con la <a href="/es/legal/privacy-statement">declaración de privacidad de Elastic</a>.

By submitting you acknowledge that you've read and agree to our <a href="/legal/terms-of-use" target="_blank">Terms of Service</a>, and that Elastic may <a href="/legal/privacy-statement#how-we-use-the-information" target="_blank">contact you</a> about our related products and services, using the details you provide above. See <a href="/legal/privacy-statement/" target="_blank">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Newsletter GDPR Text

Al enviar, confirma que ha leído y acepta nuestras <a href="/es/legal/terms-of-use" target="_self">Condiciones de servicio</a>, y que Elastic puede <a href="/es/legal/privacy-statement#how-we-use-the-information" target="_self">ponerse en contacto con usted</a> acerca de nuestros productos y servicios relacionados. Consulte la <a href="/es/legal/privacy-statement/" target="_self">Declaración de privacidad de Elastic</a> para obtener más información o para cancelar su suscripción en cualquier momento.

Hosted by

All Solutions

Follow us on Youtube

Watch now (no PT)

Articles by

Share by Email

Filters

All (no PT translation)

Contact information

See when this webinar starts in my time zone

Ver cuándo comienza este webinar en mi zona horaria

Thank you for your interest!

Register to Attend

Small image for

Register to Watch

Continue reading

Featured webinar

What to explore next...

Reset all

Load more press releases

Sign In to Attend

Share

Upcoming webinar

Learn more

Search Integrations

Share on Reddit

Share on Twitter

Share on Facebook

Load more news

View more posts

On-demand webinar

Follow us on Facebook

Author

Press Release

You'll also receive an email with related content.

You'll also receive an email with related content

Además, te enviaremos contenidos relevantes

Print

Contact Info

Overview

Video for

Read less

Register now

Share this story

See All Posts

See all top stories

View next

Can't make it? Register and we'll send you the recording. You'll also receive an email with related content

¿No puedes asistir? Regístrate y te enviaremos la grabación. También recibirás un correo electrónico con contenido relacionado.

Follow us on LinkedIn

Highlights

Explore similar demos

Follow us on Twitter

Share on LinkedIn

Load More

See more insights

Speakers

Close

Thank you for registering. We will send you a confirmation email soon.

Gracias por registrarte. Te enviaremos un correo electrónico de confirmación pronto.

Author

Articles by AMPATH medical record team

AMPATH: Providing healthcare in rural Kenya using the Elastic Stack

Sign up for Elastic Cloud free trial