How 2 young math geeks solved the mystery of Mexico City's Covid-19 dead

Around the world, citizen sleuths have been scrambling to discover the pandemic's true toll. Picture: Pexels / Markus Spiske

Around the world, citizen sleuths have been scrambling to discover the pandemic's true toll. Picture: Pexels / Markus Spiske

Published May 5, 2021

Share

By Mary Beth Sheridan

Washington - The mystery surfaced early in the pandemic. Hospitals were jammed with coronavirus victims, but the official death count in Mexico City appeared suspiciously low. Sitting at her dining-room table one afternoon, Laurianne Despeghel, a 31-year-old economic consultant, clicked from chart to chart on her laptop, puzzling over how to uncover the real toll.

"I think the data exist," she typed to Mario Romero Zavala, a fellow math geek. She'd heard that death certificates were stored in a database at the city's civil registry. But it would be tough to crack. A day later, Romero Zavala messaged back with an idea. "I'm going to hurry," the 37-year-old software developer wrote. "I think by tomorrow morning we'll have the data."

"WOW!!!" Despeghel typed.

Thus began a cat-and-mouse game with the government that would last nearly a year and catapult the pair to national prominence. Just days after their conversation, they'd conclude that around 8,000 more people had died in Mexico's capital in the first five months of 2020 compared to prior years. By February 2021, they'd count 83,235 excess deaths - more than twice the government's confirmed covid-19 fatality total.

Around the world, citizen sleuths have been scrambling to discover the pandemic's true toll. As fatalities have soared, they've upstaged governments that have been slow or unwilling to report the scale of the tragedy.

In Iran, journalists at the BBC's Persian service ferreted out data last summer showing coronavirus deaths were nearly three times the publicly released number. In Nicaragua, a civic group counted more than 3 000 fatalities with Covid-19 symptoms. The official tally was 179.

Even developed democratic countries have struggled to keep pace with Covid-19 fatalities. The challenges range from a lack of testing to incorrect diagnoses to slow-moving death registry systems. To get the best sense of the pandemic's toll, scientists are turning to excess mortality, the difference in overall fatalities compared to prior years. It includes people killed by covid-19 and indirect victims - for example, patients unable to get treatment for other problems at overwhelmed hospitals.

In Mexico, calculating the fatalities has been particularly fraught. The pandemic response has been led by highly trained scientists, including Mexico City's leftist mayor, Claudia Sheinbaum, who has a PhD in energy engineering. They've produced detailed mortality reports, but released them well after the fact, while announcing far-lower daily totals of confirmed covid-19 deaths. That's led to suspicions the government is masking the size of the disaster.

Around the world, the covid-19 death count - flashed on TV screens, headlined in newspapers - has become a key barometer of the most profound global health crisis in a century. Rarely has a single figure carried such power to influence the public or to guide government policy. Or so thought Despeghel and Romero Zavala, a bitcoin enthusiast and tech entrepreneur, when they met in a WhatsApp chat group last May.

"What we wanted to do was say, we will find the number," Despeghel said in an interview. "So it didn't stay in the air."

Their first clue came from a report by a civic group, Mexicans Against Corruption and Impunity, issued last May 18. Its investigators revealed that there were at least 4,577 confirmed or suspected covid-19 deaths in Mexico City - three times the official count. Their source was a trove of leaked death certificates. To confirm the documents' authenticity, they checked a sample against the city's civil registry, using a feature on its website for obtaining copies of death certificates.

Sitting in her apartment the next day, Despeghel studied the group's report. She had loved math since her childhood in France, its order and unyielding discipline, and met her Mexican husband at the London School of Economics. "Numbers are my thing," she said. Now, on this Tuesday afternoon, she was examining how the anticorruption investigators had penetrated the civil registry. They just typed in the numbers from a death certificate, and it appeared - a bit like downloading a boarding pass with a flight confirmation number.

The problem was, "you need the info for each one" of the death certificates, Despeghel told Romero Zavala.

That didn't stop him from playing with the site, plugging in numbers. The son of an engineer, Romero Zavala had been fascinated with the Internet since he was a boy, whiling away hot Yucatán afternoons on his family's desktop computer. His first love wasn't math but Final Fantasy VII. Sites like the civil registry page were another kind of challenge.

"I'm really intrigued," he typed to Despeghel at 5:09 p.m.

Three minutes later, he realized something odd. The death certificates were issued in ascending order by each of the city's 52 civil registry offices, starting from No. 1 in 2020. "A rookie mistake, if this was the programmer's decision," Romero Zavala noted. And then it hit him: All they had to do was identify the highest-numbered certificate in each office. Add them up, and you'd have the Mexico City death toll.

An algorithm could do the work. Romero Zavala, a graduate of Mexico's prestigious Tec de Monterrey, wrote it quickly. It would act like a citizen seeking a copy of a death certificate, but bombard the system with ever-more-refined guesses about the top numbers.

Five days later, on a Sunday afternoon, Sebastián Garrido glanced at his email. He was editor of the data blog at Nexos, a Mexican magazine. He'd never heard of these two young data experts but was stunned by their pitch. Romero Zavala and Despeghel had found 8,072 excess deaths in the capital from January through May 20, while the government had confirmed only 1,832 covid-19 fatalities. "There was no other source of information that came close," he said. The blog post, published on May 25, exploded on social media and rippled across the Mexican and international press.

When Romero Zavala returned to the civil registry site two days later, he was greeted with a captcha - one of those "I'm not a robot" boxes meant to block automated users. He and Despeghel would have to do their subsequent updates for Nexos by hand. By June 7, they found 17,310 excess deaths in the city. That jumped to 22,705 at the end of June. By late August, the total had soared past 31,000.

Indeed, Mexico generally moved at a glacial pace in processing death statistics. It was hardly alone. "Mortality data is kind of a big black hole worldwide," said Andrew Noymer, an epidemiologist at the University of California at Irvine who specializes in death rates from pandemics. Even the U.S. Centers for Disease Control and Prevention typically took months to compile death statistics. As coronavirus cases soared, the CDC shrank that to a week.

Related Topics:

Covid-19