Child pages
  • Federal EMS COVID Resource Reporting Tool Dashboard
Skip to end of metadata
Go to start of metadata




Introduction

The EMS COVID Reporting Tool has been created by the NHTSA, Office of EMS to capture, in one place, PPE needs, personnel exposures and shortages in one unified reporting database.   This will allow the NHTSA Office of EMS to present an accurate and current picture of the nation’s EMS status at the federal level.


The goal of the EMS COVID Resource Reporting Dashboard is to provide state/territory data managers and national partners with a current status of various types of PPE by EMS agencies.  The dashboard is only available to authorized state/territory and national partners. Access requires an application and approval for an Active Directory (AD) account. Authorized state/territory users will be restricted to viewing only those reporting agencies from their state/territory. They will not be able to see data from other states/territories.

This user guide provides details on the EMS COVID Resource Reporting Tool Dashboard. The images used in this user guide represent “Sample Data” and are NOT actual EMS response data.


Elements of the Dashboard

This dashboard is comprised of two visualizations, a date filter, a trend line and a table.

Response Date

The Response Date filter allows you to see submissions, defaulting to the last 7 days. The dashboard is updated daily Monday through Friday.

The Map

This visualization reflects the survey responses of EMS agencies related to their availability of COVID Resources. This section offers three drop-down filtering options; PPE Availability, COVID Exposure, and Personnel Shortage. The criteria are described below for each of the 3 filtering options. 

.

PPE Availability:

Acute Stress/Need [RED] = any PPE item marked as Zero or 1-3 days

Minimal Stress/Need [GOLD] = any PPE item marked as 4-14 days

No Stress/Need [GREEN] = all PPE items marked as 15+ days or N/A

 

COVID Exposure:

Acute Stress/Need [RED] = CONFIRMED NEW > 5% (Confirmed New/Number of EMS personnel) OR TOTAL CONFIRMED > 15% (Total Confirmed/Number of EMS personnel) OR SUSPECTED > 5% (Suspected/Number of EMS personnel) OR DEATHS any number greater than zero

Minimal Stress/Need [GOLD] = CONFIRMED NEW < 5% [not zero] (Confirmed New/Number of EMS personnel) OR TOTAL CONFIRMED < 15% [not zero] (Total Confirmed/Number of EMS personnel) OR SUSPECTED < 5% [not zero] (Suspected/Number of EMS personnel) OR DEATHS = zero

No Stress/Need [GREEN] = all 4 COVID Exposure questions are zero


Personnel Shortage Criteria:

Acute Stress/Need [RED] = response of YES to question “…shortage of personnel today?” OR “…shortage of personnel within one week?”

No Stress/Need [GREEN] = response of NO to both questions  “…shortage of personnel today?” AND “…shortage of personnel within one week?”

.

Agency Contact Information

This visualization lists the EMS agency name, phone number, staff contact name, and stress level of the agency requesting COVID resources.

PPE Availability

This visualization lists several different types of PPE being requested by EMS agencies. All of the sections in the donut charts should differ in size, based on the number of values in each of the three groupings. Hover the mouse over any section of the donut, and the Stress Level and number of Responses will be displayed.  Stress Level: Indicates the quantity of PPE available. Total donut = number of responses.

Donut chart criteria:

Acute Stress/Need [RED] = PPE item marked as Zero or 1-3 days

Minimal Stress/Need [GOLD] = PPE item marked as 4-14 days

No Stress/Need [GREEN] = PPE item marked as 15+ days or N/A

Personnel Shortage

This visualization represents the responses of two survey questions related to the shortage of personnel today and within one week.

Personnel Shortage criteria:

Acute Stress/Need [RED] = response of YES to question “…shortage of personnel today?” OR “…shortage of personnel within one week?”

No Stress/Need [GREEN] = response of NO to both questions  “…shortage of personnel today?” AND “…shortage of personnel within one week?” The area in the two sections, “Personnel Shortage this Week” and “No Personnel Shortage this Week,” can differ in size, based on the number of values shown.

COVID Exposure

This visualization represents the survey responses related to COVID Exposures of EMS personnel. It contains “Sample Data” which are not the responses of actual EMS agencies. This section of the dashboard contains a single visualization displaying the counts of:

  • COVID Confirmed Deaths
  • Newly Confirmed Cases
  • Suspected Exposures
  • Total Confirmed Cases

COVID Vaccine

This visualization represents survey responses in relation to EMS personnel and the COVID vaccine. It contains “Sample Data” which are not the responses of actual EMS agencies. This section of the dashboard contains a single visualization displaying the counts of:

  • EMS Personnel Eligible for the Vaccine
  • Additional Doses Needed
  • EMS Personnel Who Refused the Vaccine

The three sections can differ in size, based on the number of values greater than zero in each of the three sections. 

By clicking on a section of the pie chart, it will cause the dashboard to refresh and filter the information selected.  To filter on two or more sections of the pie chart, hold the CTRL key and click on the sections. Click on the pie section again to exit.

Tableau Toolbar

All Tableau dashboards share the same toolbar at the bottom of the view. Note that while most dashboards will have the same selections, some items may differ based on user permissions.

Undo, Redo, Revert, Refresh and Pause

These selections are found on the left side of the Tableau toolbar and can be used to help navigate the dashboard.


Undo will remove the last selection made, if you have used undo to remove a selection, you can then use redo to return to that selection. Revert returns the dashboard to its original view. Refresh will reload the data on the dashboard subject to any selections made. Pause will stop the dashboard from refreshing as you make selections.

As an example, if you want to make a set of complete selections in a dashboard’s filters, you could use these buttons to speed up the process. Normally, every time a change is made, the dashboard will refresh. If you select “Pause” however, the dashboard will remain the same no matter how many selections you make. Once you have made all your selections, you can select “Refresh” to reload the dashboard based on those selections.

Subscribe, Custom Views, Edit, Share, and Download

These selections are found on the right side of the Tableau toolbar and can be used to interact with the dashboard in external ways.


The Subscribe button allows users to subscribe to a daily or weekly email that will show a static image of the dashboard as well as a link to the view.

You can select either a particular view (tab) or all the views (tabs) available in the dashboard. Under “Email Subscriptions,” you can choose the frequency of emails. In “Subject Line,” you can assign the subject for the emails. As a default, the subscription will be assigned to the email address associated with your NEMSIS account.

Custom Views allows users to save any particular set of filters or selections for quick access later. A user can create their view and then name it and save it either for their own personal use or use by anyone with access to this dashboard. Previously saved views will appear in the custom views tab.

Edit will open the dashboard in the web editor for Tableau. Note that this option is not available on all dashboards and will require some knowledge of how to use Tableau to build and edit dashboards.

Share will provide a couple of options for sharing the dashboard with others, specifically an embed code and a regular HTML link. While you can use the link to share the dashboard with others, please keep in mind that many of the NEMSIS dashboards will require a username and password. Only those with credentials will be able to access them.

The last option is Download. Clicking on the download button opens up several options to download either the workbook, the data within it, or a static image of the view.

Selecting any one of these file types will produce a download of the requested file. Remember that not all options will be available for all dashboards and views.

Contact Info

Any questions, comments, concerns, or suggestions regarding this or other reports made available by the NEMSIS TAC, please contact us or leave a comment below!

Contact information is also available on our website.

Kevin White, BS
University of Utah School of Medicine
NEMSIS Technical Assistance Center
Phone: (801) 213-3408
Fax: (801) 581-8686
Email: kevin.white@hsc.utah.edu
Atim Effiong, MPH
University of Utah School of Medicine
NEMSIS Technical Assistance Center
Phone: (801) 585-9158
Fax: (801) 581-8686
Email: atim.effiong@hsc.utah.edu 
Laurel Baeder, BA, MStat
University of Utah School of Medicine
NEMSIS Technical Assistance Center
Phone: (801) 587-5337
Fax: (801) 581-8686
Email: laurel.baeder@hsc.utah.edu





  • No labels