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
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