Number of Cases in SCC Per 10,000 People - Printable Version

+- The CardBoard (https://thecardboard.org/board)
+-- Forum: Emergency (https://thecardboard.org/board/forum-11.html)
+--- Forum: Covid-19 (https://thecardboard.org/board/forum-12.html)
+--- Thread: Number of Cases in SCC Per 10,000 People (/thread-19376.html)

---

Number of Cases in SCC Per 10,000 People - Snorlax94 - 04-10-2020

One of my major peeves about recent Bay Area news headlines is when they highlight the number of cases per county, without normalizing for the number of people in that county. OMG!!!! SCC has 1442 cases and SF has only 724 cases. But wait, Santa Clara County has 2.2x as many people...

So SCC PHD released on its dashboard the number of cases in SCC by city, which is kind of meaningless without considering the relative populations.

Below is a chart normalizing #cases/10,000 people in SCC, with Wikipedia's list of top employers for that city. I know -- there are many flaws -- just because a company is HQed there, doesn't mean everyone works there, etc. But still, I found the data interesting.

Throwing out cities that were too small for data, it turns out San Jose and Palo Alto have the most cases per person, Cupertino and Mountain View have the least. In fact, San Jose and Palo Alto have more than 3x as many cases per person than Cupertino. 

Having a large part of your labor force work for tech companies that can have employees telecommute looks to be a brobdingnagian advantage (as is being semi-rural, like Gilroy).

[sorted from most to least cases per 10,000 residents] (the numbers like 2x in the employers reflect a large dropoff, ie, if the #2 employer has twice as many as the #3 employer, I put a 2x next to the #2 employer
City              cases per 10,000   Top employers
------             -------------------    ------------------
San Jose       9.256038647         County of Santa Clara, Cisco (2x, top 2 dominate), IBM (2x), City of San Jose, San Jose State U, eBay, Hitachi, San Jose Unified
Palo Alto       8.484920659         Stanford Health Care, Lucil Packard Children's Hospital, Stanford, Veteran's Affairs, VMWare, SAP
Los Gatos      6.831045475        Los Altos School District, Whole Foods, Los Altos High,  Palo Alto Medical Fndn, City of Los Altos, Coldwell Banker
Campbell      6.258424803         Barracuda Networks, Daley's Drywall, Whole Foods, Safeway, Home Depot, Bioreference Labs
Los Altos       5.85499138           Los Altos School District (2.3x), Whole Foods, Los Altos High, Palo Alto Med Fndn, City of Los Altos 
Morgan Hill    5.550991407        Morgan Hill Unified School District (almost 2x), Anritsu, Specialized Bike, Paramit, Caldoor, NxEdge
Milpitas          5.505338898        Cisco (1.7 x, top 5 dominate), KLA Corp, San Disk, Flex, Linear Tech, Milpitas Unified, Headway Tech, FireEye, Wal-Mart
Santa Clara    4.247486904        Applied Materials, Intel (3x, top 2 dominate), Great America, Avaya, Santa Clara City Hall, EMC Corp, Macy's, Santa Clara U
Sunnyvale      4.230228563        Google (almost 2x), Juniper Networks, Lockheed Martin, Apple, Yahoo, LinkedIn, NetApp
Gilroy             4.162042175       "The top 5 employers are Gilroy Unified, Christopher Ranch, St. Louis Regional Hospital, Wal-mart and Olam Intl"
Mountain View 3.683783983     Google (dominant, 8x next), Symantec, Intuit, El Camino Hospital, Microsoft, Synopsys, LinkedIn, Samsung
Cupertino 2.797110749      Apple (9x next, dominant), Cupertino Union, Foothill-De Anza CC, Fremont Union, Seagate Tech, Affymax

---