California Locations Don't Reconcile

[MelbourneDeveloper]

select  Locations.Name,
        sum(newcases) as TotalCases,
        sum(deaths) as TotalDeaths,
        sum(Recoveries) as TotalRecoveries  
from locationdays 
inner join locations
on locations.id = locationdays.locationid
inner join Provinces
on Provinces.id = locations.ProvinceId
inner join Regions
on Regions.id = Provinces.RegionId
where Provinces.Name='California' 
group by Locations.Name
order by TotalCases desc

As of 2020 - 4 - 12

Los Angeles doesn't match

State	Confirmed	Deaths	Recoveries
Los Angeles	8453	244	0
San Diego	1693	44	0
Santa Clara	1484	50	0
Riverside	1431	41	0
N/A	1364	24	0
Orange	1221	18	0
San Francisco	857	13	0
San Bernardino	810	25	0
Alameda	806	21	0
Sacramento	653	24	0
San Mateo	652	21	0
Contra Costa	530	11	0
Kern	371	3	0
Ventura	298	10	0
Santa Barbara	260	2	0
San Joaquin	257	14	0
Tulare	203	11	0
Fresno	191	5	0
Marin	154	10	0
Sonoma	145	2	0
Placer	123	4	0
Solano	121	2	0
Stanislaus	116	1	0
San Luis Obispo	110	1	0
Santa Cruz	80	1	0
Imperial	79	3	0

[MelbourneDeveloper]

This looks like a false alarm. The figures now reconcile as of 14/4/2020