Automating Vaccination Data for COVID-19 Dashboards
-
Achievement Award ProgramSan Bernardino County, Department of Public Health (SBCDPH), Research, Assessment, and Planning (RAP) is dedicated to providing general information, data, and reporting to all residents within the County’s 20,000 square miles. The past two years of the COVID-19 pandemic presented many challenges that required data to be promptly and accurately disseminated to a number of internal and external stakeholders through a platform that is easy to access and comprehend. Since the pandemic’s onset, RAP has been compiling relevant COVID-19 metrics for vital decision-making regarding the health and safety of County residents to the DPH executive team, and even more so as the County moved into the vaccination phases. The current COVID-19 Surveillance Dashboard has continued to evolve, where further solutions were needed to offer streamlined and automated processing of vaccination data for visualizations and reporting. To extract, transform, and load (ETL) vaccination data, RAP utilized Python programming to meet a variety of evolving data needs and resolve technical issues efficiently, creatively and consistently. ArcGIS Hub and Dashboards were used to report and visualize vaccine metrics to assist the County’s COVID response, identify gaps as the County strives for vaccine equity, and inform the public of the County’s vaccination progress. County San Bernardino County, Calif. Featured Resources Announcing 2022 Achievement Award Winners Achievement Award Category Information TechnologyAutomating Vaccination Data for COVID-19 DashboardsMay 1, 2022May 1, 2022, 12:00 am
About the Program
Explore Winning Programs
-
Blog
Announcing 2022 Achievement Award Winners
NACo is pleased to announce the winners for the 2022 Achievement Awards.
-
Reports & Toolkits
NACo Technology Guide for County Leaders: Workforce
The NACo County Technology Advisory Council, with input from the Tech Xchange and the NACo Workforce Advisory Board, has developed a guide on workforce retention and recruitment for technology workers. This guide provides an overview, along with benefits and questions to consider in the technology recruitment and retention process -
Policy Brief
Support the Deployment of Next Generation 911 Bill
Urge your Members of Congress to support legislation to provide funding for the deployment of Next Generation 9-1-1 and for other purposes. Introduced by Sen. Amy Klobuchar (D-Minn.) in the previous Congress, the legislation would provide for the establishment of Next Generation 9-1-1 and would vastly improve interoperability with regards to all emergency communication systems. The bill would also establish a Next Generation 9-1-1 cybersecurity center to coordinate with state, local and regional governments to detect and prevent cybersecurity intrusions related to Next Generation 9-1-1. -
Policy Brief
Support the Protecting Community Television Act
Urge your members of Congress to support the Support the Protecting Community Television Act. Introduced by Sens. Ed Markey (D-Mass.) and Tammy Baldwin (D-Wisc.) and Reps. Anna Eshoo (D-Calif.) and Peter DeFazio (D-Ore.) in the previous Congress, the legislation would amend the Communications Act of 1934 to reverse the Federal Communication Commission’s (FCC) 2019 order requiring that cable-related, in-kind contributions be subjected to the statutory five percent franchise fee cap. -
County News
TikTok: It’s hip, it’s fun and it’s a security risk
What threat does TikTok pose to data security, and how should counties regulate its use on government-issued devices? -
Webinar
OnBase as the Enabler to Integrate All Lines of Business
Jan. 12, 2023 , 2:00 pm – 3:00 pmSee how Horry County has successfully integrated multiple lines of business using OnBase as the foundation. From sharing documents across different lines of business, to automating workflows between departments and using RPA as a tool to increase efficiencies. -
Reports & Toolkits
Resource Hub for Counties: State, Local, Tribal and Territorial Fiscal Recovery, Infrastructure And Disaster Relief Flexibility Act
The bipartisan State, Local, Tribal, and Territorial Fiscal Recovery, Infrastructure, and Disaster Relief Flexibility Act will provide additional flexibility for the $350 billion Coronavirus State and Local Fiscal Recovery Fund authorized under the American Rescue Plant Act.
-
Webinar
Executive Perspectives on Preparing for an ERP Replacement Project
February 22, 2023 , 3:00 pm – 4:00 pmReplacing your finance and human capital management systems can be stressful for public sector organizations.02223:00 pm<p>Replacing your finance and human capital management systems can be stressful for public sector organizations.
-
Webinar
NACo Cyberattack Simulation: Election Disruptions
February 27, 2023 – March 3, 2023Presented by the NACo County Tech Xchange and Professional Development Academy02271:00 pm<p><em>Presented by the NACo County Tech Xchange and Professional Development Academy</em></p>
-
Webinar
NACo Cyberattack Simulation: Internet of Things
June 12, 2023 – June 16, 2023Presented by the NACo County Tech Xchange and Professional Development Academy06121:00 pm<p><em>Presented by the NACo County Tech Xchange and Professional Development Academy</em></p>
-
Webinar
NACo Cyberattack Simulation: Ransomware
September 11, 2023 – September 15, 2023Presented by the NACo County Tech Xchange and Professional Development Academy09111:00 pm<p><em>Presented by the NACo County Tech Xchange and Professional Development Academy</em></p>
-
Webinar
NACo Cyberattack Simulation: Employee Management
December 4, 2023 – December 8, 2023Presented by the NACo County Tech Xchange and Professional Development Academy12041:00 pm<p><em>Presented by the NACo County Tech Xchange and Professional Development Academy</em></p>
-
Reports & Toolkits
State and Local Fiscal Recovery Fund Resource Hub
Explore NACo's resource hub for the ARPA State and Local Fiscal Recovery Fund.Reports & Toolkitsdocument010512:15 pmReports & Toolkits<table border="1" cellpadding="1" cellspacing="1" style="width:100%" summary="call-out transparent">
<tbody>
<tr>
<td> -
Basic page
County Tech Xchange
The NACo County Tech Xchange is an online portal designed to connect county CIOs, IT Directors, CISOs, and other county IT leadership. This portal provides valuable resources in a central location that counties can use to improve their overall technology infrastructure.pagepagepage<table border="1" cellpadding="1" cellspacing="1" style="width:100%" summary="call-out transparent">
<tbody>
<tr> -
Basic page
TestIT: How Fast is Your Broadband
NACo has partnered with the Local Initiatives Support Corporation (LISC) and the Rural Community Assistance Partnership (RCAP) to develop a mobile app designed to identify areas with low or no connectivity to help ensure adequate funding for broadband infrastructure is provided across the country.pagepagepage<table border="1" cellpadding="1" cellspacing="1" style="width:100%" summary="call-out">
<tbody>
<tr>
<td> -
Basic page
Telecommunications & Technology Steering Committee
All matters pertaining to telecommunications and technology policy, including, but not limited to, the county role as a telecommunications regulator, service provider, and consumer, cable services technology and implementation, information technology development and implementation, information technology innovation, e-governance, and geo-spatial data collection and utilization.pagepagepage<p>All matters pertaining to telecommunications and technology policy, including, but not limited to, the county role as a telecommunications regulator, service provider, and consumer, cable services technology and implementation, info
-
Reports & Toolkits
Implementing Infrastructure Investments at the County Level: The Bipartisan Infrastructure Law (P.L. 117-58)
As intergovernmental partners, counties play a key role in ensuring the successful interpretation and implementation of the BILReports & Toolkitsdocument100710:00 amReports & Toolkits<table border="1" cellpadding="1" cellspacing="1" style="width:100%" summary="call-out transparent jump">
<tbody>
<tr>
<td>
Related Events
-
22Feb2023Webinar
Executive Perspectives on Preparing for an ERP Replacement Project
Feb. 22, 2023 , 3:00 pm – 4:00 pm -
27Feb2023
-
12Jun2023
-
11Sep2023
Upcoming Events
-
8Feb2023Webinar
Local Strategies for Reaching Families and Young Children Experiencing Homelessness
Feb. 8, 2023 , 2:00 pm – 3:00 pm -
11Feb2023
-
22Feb2023Webinar
Executive Perspectives on Preparing for an ERP Replacement Project
Feb. 22, 2023 , 3:00 pm – 4:00 pm
More From
-
Outreach Toolkit for Counties: the FCC’s Affordable Connectivity Program
Through the FCC's Affordable Connectivity Program, counties have a central role in providing all residents with an equal chance to connect to high-speed internet in their homes.
Learn More