'It's In the Data': One Parent's Quest to Make School COVID Case Counts More Transparent

Sarah Favot

Favot is an award-winning journalist and adjunct instructor at USC's Annenberg School for Communication and Journalism. She previously was an investigative and data reporter at national education news site The 74 and local news site LA School Report. She's also worked at the Los Angeles Daily News. She was a Livingston Award finalist in 2011 and holds a Master's degree in journalism from Boston University and BA from the University of Windsor in Ontario, Canada.

'It's In the Data': One Parent's Quest to Make School COVID Case Counts More Transparent

Jorge A. Caballero agonized over whether to send his toddler to preschool, but ultimately decided he couldn't teach his child how to socialize and share with other children at home. On the third day of school, he received the news all parents dread: His child was in contact with another who tested positive for COVID-19.


He now regrets that decision and doesn't know if he'll send his toddler back.

"We're setting ourselves up for a major wave that starts with children," he said.

Caballero, co-founder and head of data insights for Coders Against COVID and a clinical informatics researcher, should know. For more than a year he's been poring over COVID data and posting aggregated metrics from the Los Angeles Unified School District (LAUSD) and other large school districts on his Twitter feed, @DataDrivenMD.

And just over a week ago, LAUSD parent advocacy group Parents Supporting Teachers tapped Caballero to help them get data they were asking the district for for months.

Less than a week after the district reported the first school-based COVID-19 outbreak at Grant Elementary School in East Hollywood where seven children contracted the virus, the parent group detailed thousands more COVID cases.

Those cases do not appear to be contracted at schools, but according to the parent group, district data shows there were 2,862 active COVID cases among students and staff as of Sunday night.

LAUSD has its own dashboard where parents can search for their child's school and see how many students or staff tested positive for COVID and how many cases were linked to a "school-based transmission." It also shows the infection rate for the community of schools and the community identified by the L.A. County Department of Public Health.

But the dashboard doesn't show district-wide aggregated data like the figures reported Sunday. That's where Caballero stepped in.

Caballero wrote a script that scrapes the district's data, and every morning he turns it over to a group of parents who've created a public Google spreadsheet that shows the rates district-wide, not just the individual school. It also creates a record of what the numbers were each day so parents can compare the rates and see trends over time. The district data offers just a snapshot of the data for that day. It helps parents "better understand and contextualize COVID-19 cases across our schools and neighborhoods," the group said.

Jorge Caballero is co-founder and head of data insights for Coders Against COVID.

"He has been a godsend," said Jenna Schwartz, co-founder of Parents Supporting Teachers. She quickly realized how monumental the task was after members of her group began to input the data for nearly 1,000 campuses by hand. Then, they found Caballero. "None of this would have been possible without him."

LAUSD has such robust data about positive cases because it requires every staff member and student to be tested weekly, regardless of their vaccination status. That is the strictest testing protocol of any major school district in the nation.

We talked to Caballero about why it was important to release this cumulative data.

What prompted you to start pulling the LAUSD data yourself and posting it on Twitter?

The reason I have an interest in what's going on at LAUSD and even New York City schools is because what they do ends up having a ripple effect across the country. We have a child who is too young to be vaccinated. We are in a precarious position where we can't safely send them to school because the community case rate is so high across the country [and] there is a known risk of our child getting exposed. In fact, we were just notified yesterday that they were exposed.

In the absence of effective public health measures, we will continue to have exposures and outbreaks that have collateral damage in that they harm people that are either immunocompromised or children who are too young to be vaccinated.

From my perspective of over a decade of health data expertise and analysis, it's in the data. We cannot afford to have people choose not to be vaccinated if we hope to keep schools open safely, if we hope to regain any sense of normality moving forward.

The moment that you put unvaccinated children and staff in an enclosed space for hours at a time, with the highly transmissible delta variant, you're going to have clusters of cases almost immediately.

When you talk to parents and you talk to teachers about the process — the process that is actually going on in terms of exposure notification — you quickly get the sense that LAUSD only has had seven school-linked cases, because they're not being reported effectively. They're not being contract-traced effectively.

The numbers don't add up. We're setting ourselves up for a major wave that starts with children.

Do you fault LAUSD for not having effective contact tracing, specifically, or are you saying in general that's a problem we're having at the national level as well?

It's not LAUSD's fault that we squandered the summer. We should have done better at a national, state and local level at recognizing the clear and present threat that was and is the delta variant.

We knew what was coming our way. Everything that's making headlines in the U.S. now made headlines in England, Scotland, the U.K, Israel, India, New Zealand, Australia.

We did fail at the policy level to adapt back-to-our-school policies to this new reality. It's taking a lot of effort to overcome the inertia of all of these existing policies and to move the Titanic in a direction that's going to steer away from that iceberg.

We all worked as hard as we could. We were at mile 23 of a marathon. Delta variant set us back to around mile 13. We have to adapt and we will make this into a relay race, we will find a way to get to the finish line, but we have to recognize that there needs to be a change in the strategy. We can't keep doing what we were doing.

Are there tech issues that you're seeing with the LAUSD dashboard?

You can tell that the folks at LAUSD are struggling with the dashboard. There's just little quirks shown up over the course of the past two weeks. As a software engineer myself, I can tell that they're having difficulty getting their hands around the data.

In LAUSD's COVID dashboard and in your database you have the data divided by the communities identified by the L.A. County Department of Public Health and include the community case rate reported by the county. Why is it important to compare infection rates at schools to the community as a whole?

Comparing the case rate at the individual schools to the broader community is one way to identify data gaps and/or the need for improved contact tracing. For nearly every facility, the school-based case rate has been higher than the community and county case rates. This observation was the first indication, to me, that LAUSD was going to run into problems. When the school-based case rates are significantly higher than the community and county rates, this suggests that the community and county-level data is underestimating the actual case rate. For example, asymptomatic persons aren't getting tested and it could mean that school-based transmission is under-reported due to inadequate contact tracing resources. Before school started, the former issue was dominating the disparity in rates, but the more time that unvaccinated and/or unmasked kids spend in classrooms, cafeterias and hallways, the more that the latter comes into play.

Why is it important to have aggregated data rather than just data by school?

Detecting hotspots requires the ability to zoom in-and-out of the data across geography and time. Say that you're a family with a child under 12 who is in a social bubble with families that have kids in high school: You'd probably want to avoid having one of those high schoolers babysit when the case rate for the community of schools is trending upward.

Dr. Anthony Fauci, director of the National Institute of Allergy and Infectious Diseases and the chief medical advisor to the president, said he hopes we will have "some good control" over COVID by spring 2022 if people get vaccinated.

We can absolutely change that. It just requires the political will to acknowledge the problem and to be willing to make those tough decisions.

Would you support a federal vaccine mandate?

Absolutely. There's talk about a state level vaccine mandate and I'm very supportive of that. We are in a public health emergency. Based on the data that I'm seeing, it makes absolute sense and it would be quite frankly political and public health malpractice not to consider a vaccination mandate for those who are eligible for a fully approved vaccine.

You decided to send your toddler child to school and that's where they were exposed?

Just like any other set of parents, there's only so much you can do to help your child develop especially at this early age. There's no way two adults can teach their child how to share, how to socialize, how to resolve conflict.

We made the very difficult decision to try to send our kiddo back to pre-school and we thought we had everything covered. They spent no more than 15 minutes inside of a classroom, because we picked them up late and dropped them off early. We bought them HEPA filters, we made sure the windows were open and the staff were fully vaccinated. We did everything we possibly could within our control, and then some.

Three days into the school year, we received a notification that our child was exposed on the first day of class. We find ourselves in a situation that is all-too-common across the country, certainly across the state and definitely across the L.A. Unified School District.

Do you think you'll send your child back?

I didn't want to send them at all, but we had to for their sake. We needed to send them to school. I'm not certain that we will send them back. In our case, it seems as though somebody sent their child to class while waiting for test results. That is a frustratingly common scenario based on what my pediatrician friends are telling me. That's a betrayal of trust that we had placed on the other families in the school. We haven't decided yet, but right now, I'd say absolutely not.

This interview has been lightly edited for brevity and clarity.

LA’s Upgrade in Travel and NBA Viewing
Image Source: Los Angeles World Airports

🔦 Spotlight

Exciting developments are underway for Los Angeles as the city prepares for major upgrades in both travel and entertainment. The Los Angeles Board of Airport Commissioners has approved an additional $400 million for the Automated People Mover (APM) at LAX, increasing its total budget to $3.34 billion. This boost ensures the elevated train’s completion by December 8, 2025, with service starting in January 2026. For Angelenos, this means a significant improvement in travel convenience. The APM will streamline connections between parking, rental car facilities, and the new Metro transit station, drastically cutting traffic congestion around the airport. Imagine a future without the dreaded 30-minute traffic delays at LAX! The APM will operate 24/7, reducing airport traffic by 42 million vehicle miles annually and carrying 30 million passengers each year, while also creating thousands of local jobs and supporting small businesses.

Meanwhile, the NBA is also making waves with its new broadcasting deals. The league has signed multi-year agreements with ESPN, NBC, and Amazon Prime Video, marking a notable shift in media partnerships. ESPN will maintain its long-standing role, NBC returns as a network broadcaster after years away, and Amazon Prime Video will provide NBA games through its streaming platform. Starting with the 2025-2026 season, these deals will enhance the league's reach and revenue, aligning with the NBA's goal to expand its audience and adapt to evolving viewing habits. Whether you're catching the action on TV or streaming online, these changes promise to elevate the fan experience and bring more basketball excitement to Los Angeles.


🤝 Venture Deals

LA Companies

  • Pearl, a startup that makes AI-powered software that assists dentists in identifying cavities, gum disease, and other dental conditions, raised a $58M Series B funding led by Left Lane Capital with Smash Capital, and others also participating. - learn more

LA Venture Funds

  • Fulcrum Venture Group participated in a prior $3.5M Pre-Seed Round for Code Metal, a developer tools startup. - learn more
  • B Capital co-led a $12.5M Seed Round for Star Catcher, a startup that aims to develop a space-based grid that captures solar energy in space and distributes it to satellites and other space assets. - learn more
  • Mantis VC and Amplify participated in a $140M Series C for Chainguard, an open source security startup. - learn more
  • Prominent LA venture capitalist, Carter Reum and wife, Paris Hilton, participated in a $14M Seed/Series A for W, the men’s personal care brand from Jake Paul. - learn more

LA Exits


Download the dot.LA App

🤫 The Secret to Staying Fit at Your Desk: 6 Essential Under-Desk Exercise Machines

Health experts are sounding the alarm: our sedentary jobs are slowly killing us, yet we can't abandon our desks if we want to keep the lights on. It feels like we're caught between a rock and a hard place. Enter under-desk exercise machines – the overlooked heroes (albeit kind of goofy looking) of the modern workspace. These devices let tech professionals stay active, enhance their health, and increase their productivity, all without stepping away from their screens. Here are 6 fantastic options that will enhance the way you work and workout simultaneously.

DeskCycle Under Desk Bike Pedal Exerciser

This bike has nearly ten thousand five-star reviews on amazon. It works with nearly any desk/chair setup. It is quiet, sturdy and allows up to 40 pounds of resistance. If you are looking for an under-desk bike this is a fantastic option.

Type: Under-Desk Bike

Price: $180 - $200


Sunny Health & Fitness Dual Function Under Desk Pedal Exerciser

This under-desk bike is extremely quiet due to the magnetic resistance making it an ideal option if you work in a shared space. It doesn’t slip, has eight levels of resistance, and the option to work legs and arms. It’s about half the price of the DeskCycle bike making it a solid mid-range option for those looking to increase their daily activity.

Type: Under-Desk Bike

Price: $100 - $110


Sunny Health & Fitness Sitting Under Desk Elliptical

This under-desk elliptical comes in multiple colors if you really want to underscore that you are a quirky individual, in case an under-desk elliptical isn’t enough. This model is a bit heavy (very sturdy), has eight different resistance levels, and has more than nine thousand 5-star reviews.

Type: Under-Desk Elliptical

Price: $120 - $230


DeskCycle Ellipse Leg Exerciser

This under-desk elliptical is another great option. It is a bit pricey but it’s quiet, well-made and has eight resistance levels. It also syncs with your apple watch or fitbit which is a very large perk for those office-wide “step” challenges. Get ready to win.

Type: Under-Desk Elliptical

Price: $220 - $230


Daeyegim Quiet LED Remote Treadmill

If you have a standing desk and are looking to walk and work this is a fantastic option. This walking-only treadmill allows you to walk between 0.5 to 5 mph (or jog unless you have the stride length of an NBA forward). It is very quiet, which is perfect if you want to use it near others or during a meeting. You can’t change the incline or fold it in half but it is great for simply getting in some extra steps during the work day.

Type: Under-Desk Treadmill

Price: $220 - $230


Sunny Health & Fitness Foldable Manual Treadmill

This under-desk treadmill isn’t the most premium model but it is affordable and has an impressive array of features. It is a manual treadmill meaning it doesn’t need to be plugged in; it is foldable and offers an incline up to 13%. I personally can’t imagine working and walking up a 13% incline but if that sounds like your cup of tea, then I truly respect the hustle.

Type: Under-Desk Treadmill

Price: $150 - $200




Download the dot.LA App

🤠Musk Picks Texas and 🔥Tinder AI Picks Your Profile Pictures

🔦 Spotlight

Tinder is altering dating profile creation with its new AI-powered Photo Selector feature, designed to help users choose their most appealing dating profile pictures. This innovative tool employs facial recognition technology to curate a set of up to 10 photos from the user's device, streamlining the often time-consuming process of profile setup. To use the feature, users simply take a selfie within the Tinder app and grant access to their camera roll. The AI then analyzes the photos based on factors like lighting and composition, drawing from Tinder's research on what makes an effective profile picture.

The selection process occurs entirely on the user's device, ensuring privacy and data security. Tinder doesn't collect or store any biometric data or photos beyond those chosen for the profile, and the facial recognition data is deleted once the user exits the feature. This new tool addresses a common pain point for users, as Tinder's research shows that young singles typically spend about 25 to 33 minutes selecting a profile picture. By automating this process, Tinder aims to reduce profile creation time and allow users to focus more on making meaningful connections.

In wholly unrelated news, Elon Musk has announced plans to relocate the headquarters of X (formerly Twitter) and SpaceX from California to Texas. SpaceX will move from Hawthorne to Starbase, while X will shift from San Francisco to Austin. Musk cited concerns about aggressive drug users near X's current headquarters and a new California law regarding gender identity notification in schools as reasons for the move. This decision follows Musk's previous relocation of Tesla's headquarters to Texas in 2021.

🤝 Venture Deals

LA Companies

LA Venture Funds

LA Exits

  • Penguin Random House agreed to acquire comic book publisher Boom! Studios from backers like Walt Disney Co. - learn more

Download the dot.LA App

RELATEDEDITOR'S PICKS
Trending