Flood of coronavirus data overwhelms state reporting system

Public reporting of new COVID-19 cases and deaths in Washington ground to a halt on Sunday.

A screenshot of the state Department of Health website that reports COVID-19 cases and other data, which was last updated on Sunday.

A screenshot of the state Department of Health website that reports COVID-19 cases and other data, which was last updated on Sunday.

By Lewis Kamb / The Seattle Times

SEATTLE — Even as the novel coronavirus has spread from Washington’s cities to small towns and rural communities, state Department of Health officials acknowledged Tuesday they’re wrestling with another thorny problem from the pandemic: A flood of statewide case data is overwhelming the disease-reporting system.

As a result, statewide public reporting of new coronavirus cases has ground to a halt. As of Wednesday, Washington’s last data update posted to the Department of Health website came from lab results reported three days earlier — as of midnight March 28.

The lag, in turn, has partially blinded both health officials and the public to the latest information about the disease’s spread statewide.

Washington state Secretary of Health John Wiesman acknowledged that timely and accurate information is critical in formulating public health strategies, but he tempered concerns about the data problems, and said they’ve had no adverse impacts to the state’s response — yet.

“Our team is on it. It’s a top priority for us, and we understand the importance of having the data both for our use and for transparency to the public,” Wiesman said in a phone interview.

“But it’s not changing our strategy or what public health actions we need to take at the moment,” he said. “Obviously, we don’t want this to go on for very long — that wouldn’t be good.”

Wiesman and Dr. Kathy Lofy, the state’s health officer, each said Tuesday that the data obtained to date has given officials a solid understanding that the coronavirus outbreak has spread statewide, beyond just the population centers in King and Snohomish counties. Social-distancing strategies, as those ordered by Gov. Jay Inslee, remain the best way to mitigate the spread, they said.

Officials typically only see significant trends by analyzing at least a week’s worth of data — not the two or so days that they’re missing now, Lofy added. The longer periods of data coincide with the virus’s incubation period, which is typically five to seven days, but can be up to two weeks.

“It’s just been since Sunday, so the past two days that we haven’t received” the data, Lofy said. “Obviously, it’s really important to us. But it’s the longer-term trend that we’re really looking for” when making policy decisions.

‘Overwhelmed the system’

For more than a week, late, incomplete and inaccurate data reports have hampered the health department’s daily coronavirus case updates, leading to a steady stream of complaints in public forums, questions from journalists about numbers that don’t add up and differences in the number of positive tests and confirmed cases.

Officials blame the troubles largely on a volume issue. As Washington’s coronavirus testing has ramped up dramatically over the past month — with 21 labs in Washington now testing patient samples — thousands of new data reports, with positive and negative test results, have flooded into the Washington Disease Reporting System (WDRS).

The system, however, wasn’t set up to take negative test results, Wiesman said. Before the coronavirus pandemic, the reporting system usually would receive “just positive results — say from someone who got E.coli in one county, or a case of measles in another,” he said.

“With coronavirus, we’re now importing data from all of the negative testing,” Wiesman said. “Early on in the outbreak, when the testing was limited, that wasn’t a problem. But now we’re getting as many as 6,000 to 7,000 test results — both positive and negative — each day. That has kind of overwhelmed the system.”

Negative results, which make up about 93% of the data, are streaming in without corresponding information for the origin of those results, so they cannot be assigned to any particular county, Wiesman said.

“Sometimes, these are getting sent in multiple times from the same labs on the same day,” he added.

Ferreting out duplicate reports is a manual process that often requires validating data through local public health departments, he said. As data volume has increased, that manual process has greatly slowed down the state’s abilities to regularly update or provide complete, accurate data, Wiesman said.

“One day last week, we had 2,o00 duplicates alone that we had to go through by hand to ensure we had reliable numbers,” he said.

To fix the problem, the state has enlisted Conduent, the vendor of the system’s Maven software, to essentially re-write proprietary code on the fly. The goal will be to separate positive and negative testing data, possibly by creating a new tool for the negative cases, said Jennifer McNamara, Department of Health’s chief information officer.

Other states, notably New York, also use the same reporting system, McNamara said. “We have been in touch with our colleagues in New York, and they are running into the same challenges that we are,” she said. “So they’ve been sharing with us some ways to minimize disruptions.”

One of New York’s suggestions was to try to streamline reporting by individual labs by limiting the number and timing of their daily reports, she said.

“We’re hopeful that by tomorrow, we’ll be able to report numbers that we can be comfortable with in terms of accuracy of the data,” McNamara said Tuesday.

Once the fixes are made, Wiesman said he expects the state will publish updated data every day by 3 p.m., listing one full day of data reported from the previous day. The state’s latest data update reported 4,896 positive cases statewide and 195 deaths — figures that are now at least three days stale.

Along with the positive and negative test results, the state also intends to include daily death tolls, patient gender and age information and hospitalization data when it becomes available, he said.

Already, the Department of Health site has made several upgrades, including new visualizations showing confirmed cases, the epidemiological curve, cumulative case and death counts, testing numbers and demographic information, he said.

Flattening the curve

Even when the fixes are made, Wiesman noted, “every data set has limitations.”

Dr. Jared Roach at the Seattle-based Institute for Systems Biology, said the state data is prone to have some inconsistencies because it’s being reported daily.

For instance, some confirmed cases may have been reported on the date of a positive result, while others on the day the test was taken. Some cases were reported in the county where a patient tested positive, while others were reported in a county of residence.

Researchers relying on state data build that uncertainty into their models, Roach said. Scientists evaluating the “flattening of the curve,” for instance — evidence that social-distancing and other measures are slowing infection rates — create an upper and lower bound that show how many hospital beds might be needed as the pandemic progresses.

Modeling to estimate when Washington’s outbreak will peak, like that from the Institute for Health Metrics and Evaluation at the University of Washington, base trajectories on death data, not positive or negative cases, Lofy said. That means the institute’s model, which estimates Washington cases will surge to an apex about April 19, likely wouldn’t be affected by a lag in reported test results, she said.

“Most people who die are probably getting tested for COVID-19,” she said, “so we think the testing [for deaths] is probably fairly complete” to date, with less of a lag issue for daily positive and negative test results.

But Lofy acknowledged Tuesday that lapses in available testing, which have haunted surveillance of the pandemic’s spread in Washington and across the U.S., has stymied understanding — and continues to.

“We’ve seen dramatic increases in numbers of cases detected just recently” across the state, she said. “It’s hard to tell if we’re seeing a surge in COVID-19 activity, or if we haven’t been testing enough. So the testing capacity issues we’ve struggled with certainly does make it more difficult to interpret the data we have now that we have more broad testing.”

Staff reporter Mike Reicher contributed to this report.

Talk to us

More in Northwest

FILE - Sen. Patty Murray, D-Wash., speaks during a news conference the vote to codify Roe v. Wade, in this May 5, 2022 file photo on Capitol Hill in Washington. Murray is one of the U.S. Senate's most powerful members and seeking a sixth term. She is being challenged by Tiffany Smiley, a Republican from Pasco, Wash. (AP Photo/Jacquelyn Martin, File)
Providence continues to face questions about hospital debt collection

The hospital group has pushed back against the notion that Providence “intentionally takes advantage of those who are vulnerable.”

A Coast Guard cutter searches for a crashed chartered floatplane near Mutiny Bay Monday afternoon in Freeland, Washington on September 5, 2022.  (Kevin Clark / The Herald)
5 more bodies recovered from floatplane crash off Whidbey

About 80% of the plane, including the engine, was recovered using remotely operated vessels.

FILE - The logo for Boeing appears on a screen above a trading post on the floor of the New York Stock Exchange, Tuesday, July 13, 2021.  Boeing is behind schedule in submitting documentation for new versions of its 737 Max jetliner, and it's asking Congress for more time. Federal officials say Boeing has completed little of the work necessary to certify the new Max versions by a Dec. 31, 2022 deadline. (AP Photo/Richard Drew, file)
With 2 Max models at risk, Congress moves to give Boeing a break

Political action has begun in Congress to grant Boeing the extension it will need to get both the Renton-built Max 7 and Max 10 certified without any further design changes.

FILE - In this Jan. 18, 2014, file photo, a female resident orca whale breaches while swimming in Puget Sound near Bainbridge Island, Wash., as seen from a federally permitted research vessel. The National Marine Fisheries Service has finalized rules to expand the Southern Resident orca's critical habitat from the Canadian border down to Point Sur, Calif., adding 15,910 square miles, (41,207 square kilometers) of foraging areas, river mouths and migratory pathways. (AP Photo/Elaine Thompson, File)
Endangered southern resident orca numbers drop from 74 to 73

Since July 1, 2021, three whales died while two were born, officials said.

Logo for news use featuring Whidbey Island in Island County, Washington. 220118
Floatplane wreckage recovery in Puget Sound begins

The U.S. Navy will use a remotely operated vehicle Deep Drone 8,000, a barge and a crane in recovery efforts.

News logo for use with stories about coronavirus COVID-19 COVID
COVID, monkeypox levels down

State says prevention efforts will continue.

News logo for use with stories about coronavirus COVID-19 COVID
State employees likely to get 1K bonuses for COVID booster

Under a tentative deal state employees would get $1,000 bonuses for receiving a COVID-19 booster shot.

FILE - Then-Interim Seattle Police Chief Adrian Diaz addresses a news conference in Seattle, on Sept. 2, 2020. Seattle Mayor Bruce Harrell has named Diaz as his pick for permanent chief of the Seattle department. Harrell on Tuesday, Sept. 20, 2022,  announced his intent to appoint Diaz, who has served as interim police chief since 2020. (AP Photo/Elaine Thompson, File)
Seattle mayor appoints Adrian Diaz as city’s police chief

Diaz has served as interim police chief since September 2020.

NO CAPTION. Logo to accompany news of Washington state.
Human remains wash ashore, possibly from floatplane crash

A female torso found near Sequim could be connected to a floatplane crash near Whidbey Island.

NO CAPTION. Logo to accompany news of Seattle.
Seattle teachers approve new contract following strike

Teachers in Seattle have approved a new, three-year contract following a strike.

West Seattle Bridge reopened Saturday night

After 908 days without a high-rise bridge, the drivers and passengers of West Seattle regained seven road lanes.

NO CAPTION. Logo to accompany news of Washington state.
Monkeypox cases declining in WA, outbreak trajectory unclear

The drop in infections statewide is directly linked to the drop in cases in King County.