Social Media-Integrated COVID-19 Dashboard Amplifies National Cities Are Essential Campaign

Client: Connecticut Conference of Municipalities

Location: Connecticut

 

About the Project

The COVID-19 pandemic sparked two emergencies for Connecticut, one for public health and one for the economy. The Connecticut Conference of Municipalities addressed both with a data analytics dashboard.

The dashboard helps keep CCM members informed about COVID-19 case counts in Connecticut communities and inspires them to support the Cities Are Essential advocacy campaign. This campaign, created by the National League of Cities and its state partners, seeks to secure local government funding in the fourth phase of the federal stimulus package. Using Tableau and data from the Connecticut Department of Health and Human Services, we created a dashboard with COVID-19 case counts for each town and built in functionality for users to easily tweet a curated message of support for local government funding to their congressional representatives.

“CCM is interested in finding new advocacy methods that make it easy for members to take action. I’m happy we were able to support such an important effort while also developing a tool that helps the people of CT stay informed about what is happening in their community.” —John McKenzie, FLO Senior Analyst

 

Meet the Client

CCM is Connecticut’s largest, nonpartisan organization of municipal leaders, representing all 169 towns and cities in Connecticut. CCM shares best practices and objective research to help our local leaders govern wisely and advocates at the state level for issues affecting local taxpayers.

 

The Solution

Using Tableau software, we created a COVID-19 dashboard showing town-specific COVID-19 data (number of cases, number of deaths, number of people tested). A live connection was set up between the dashboard and the State of Connecticut’s Open Data Portal to ensure the data reamins current. A series of buttons allows users to tweet an auto-generated message of support to their congressional and senate representatives.

COVID-19 Dashboard Stock Tweet

 

 

 

 

 

 

 

The dashboard is easily shared across social media and each Connecticut municipality can embed the dashboard for their own city or town on their website.

 

 

 

 

 

 

 

 

 

  • Mobile, Desktop, and Server Applications
Contact Us
staff image

John McKenzie

Director of Business Development

(617) 797-0152

  • This field is for validation purposes and should be left unchanged.
Explore Our Work
  • Storymap Advances Legislation to Address Salmon Recovery and Fish-Blocking Culverts

    Client: Association of Washington Cities

  • Event Analytics Dashboard Solves Long-Standing Member Engagement Challenge

    Client: Association of Washington Cities

  • Enterprise GIS Upgrades an Asset Management System

    Client: City of Monroe

View All Projects