home / la-times

Menu
  • GraphQL API

latimes-place-totals

Table actions
  • GraphQL API for latimes-place-totals

Most counties break out the location of cases within their service area. The Times is gathering and consolidating these lists. Each row contains cumulative case totals reported in that area as of that date. Some counties currently do not report cases by locality.

Different counties provide different geography types. Some provide data by region, some by Census designation, some by ZIP Code. The locations provided by Los Angeles County correspond to the public health department's official "Countywide Statistical Areas". Locations can be mapped after being joined to the shapes in latimes-places-polygons.geojson using the id column.

Be aware that some counties have shifted the place names used over time.

In some circumstances the true total of cases is obscured. Los Angeles and Orange counties decline to provide the precise number of cases in areas with low populations and instead provide a potential range. The lowest number in the range is entered into the record in the confirmed_cases field and an accompanying note includes the set of possible values.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

id
The unique identifier of the city, neighborhood or other area.
name
The name of the city, neighborhood or other area.
date
The date when the data were retrieved in ISO 8601 format.
county
The name of the county where the city is located.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
confirmed_cases
The cumulative number of confirmed coronavirus case at that time.
note
In cases where the confirmed_cases are obscured, this explains the range of possible values.
population
The number of residents in the area. Not available for all places.

1,277 rows where "date" is on date 2022-02-28

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Link rowid ▼ id name date county fips confirmed_cases note population
381672 381672 94501 94501: Alameda 2022-02-28 Alameda 1 7300   62826
381673 381673 94502 94502: Alameda 2022-02-28 Alameda 1 1166   14117
381674 381674 94505 94505: Discovery Bay 2022-02-28 Alameda 1 4   16382
381675 381675 94514 94514: Byron 2022-02-28 Alameda 1 2   1461
381676 381676 94536 94536: Fremont 2022-02-28 Alameda 1 8564   72976
381677 381677 94538 94538: Fremont 2022-02-28 Alameda 1 9151   63911
381678 381678 94539 94539: Fremont 2022-02-28 Alameda 1 4183   52960
381679 381679 94541 94541: Hayward 2022-02-28 Alameda 1 14457   65132
381680 381680 94542 94542: Hayward 2022-02-28 Alameda 1 2079   13973
381681 381681 94544 94544: Hayward 2022-02-28 Alameda 1 17495   77121
381682 381682 94545 94545: Hayward 2022-02-28 Alameda 1 6347   31657
381683 381683 94546 94546: Castro Valley 2022-02-28 Alameda 1 6187   45536
381684 381684 94550 94550: Livermore 2022-02-28 Alameda 1 6602   50138
381685 381685 94551 94551: Livermore 2022-02-28 Alameda 1 6444   38986
381686 381686 94552 94552: Castro Valley 2022-02-28 Alameda 1 1439   15204
381687 381687 94555 94555: Fremont 2022-02-28 Alameda 1 3596   36037
381688 381688 94560 94560: Newark 2022-02-28 Alameda 1 7784   44245
381689 381689 94566 94566: Pleasanton 2022-02-28 Alameda 1 4395   45046
381690 381690 94568 94568: Dublin 2022-02-28 Alameda 1 8802   58399
381691 381691 94577 94577: San Leandro 2022-02-28 Alameda 1 8058   48666
381692 381692 94578 94578: San Leandro 2022-02-28 Alameda 1 8005   40150
381693 381693 94579 94579: San Leandro 2022-02-28 Alameda 1 3538   20237
381694 381694 94580 94580: San Lorenzo 2022-02-28 Alameda 1 5548   28970
381695 381695 94586 94586: Sunol 2022-02-28 Alameda 1 91   797
381696 381696 94587 94587: Union City 2022-02-28 Alameda 1 11088   72446
381697 381697 94588 94588: Pleasanton 2022-02-28 Alameda 1 3324   31895
381698 381698 94601 94601: Oakland 2022-02-28 Alameda 1 13267   53261
381699 381699 94602 94602: Oakland 2022-02-28 Alameda 1 3582   29770
381700 381700 94603 94603: Oakland 2022-02-28 Alameda 1 9243   33241
381701 381701 94605 94605: Oakland 2022-02-28 Alameda 1 7828   42375
381702 381702 94606 94606: Oakland 2022-02-28 Alameda 1 5929   37076
381703 381703 94607 94607: Oakland 2022-02-28 Alameda 1 4757   26646
381704 381704 94608 94608: Emeryville 2022-02-28 Alameda 1 4332   31000
381705 381705 94609 94609: Oakland 2022-02-28 Alameda 1 3103   22293
381706 381706 94610 94610: Oakland 2022-02-28 Alameda 1 3064   30862
381707 381707 94611 94611: Oakland 2022-02-28 Alameda 1 3248   37826
381708 381708 94612 94612: Oakland 2022-02-28 Alameda 1 2567   17279
381709 381709 94613 94613: Oakland 2022-02-28 Alameda 1 14   212
381710 381710 94618 94618: Oakland 2022-02-28 Alameda 1 1134   15545
381711 381711 94619 94619: Oakland 2022-02-28 Alameda 1 3401   24080
381712 381712 94621 94621: Oakland 2022-02-28 Alameda 1 9134   32915
381713 381713 94702 94702: Berkeley 2022-02-28 Alameda 1 2014   16520
381714 381714 94703 94703: Berkeley 2022-02-28 Alameda 1 2140   19805
381715 381715 94704 94704: Berkeley 2022-02-28 Alameda 1 3145   29129
381716 381716 94705 94705: Berkeley 2022-02-28 Alameda 1 1106   13152
381717 381717 94706 94706: Albany 2022-02-28 Alameda 1 1480   19921
381718 381718 94707 94707: Berkeley 2022-02-28 Alameda 1 562   12862
381719 381719 94708 94708: Berkeley 2022-02-28 Alameda 1 513   11725
381720 381720 94709 94709: Berkeley 2022-02-28 Alameda 1 861   11796
381721 381721 94710 94710: Berkeley 2022-02-28 Alameda 1 1393   8059
381722 381722 94720 94720: Berkeley 2022-02-28 Alameda 1 690   1336
381723 381723 95377 95377: Tracy 2022-02-28 Alameda 1 1   32091
381724 381724 95391 95391: Mountain House 2022-02-28 Alameda 1 2   20131
381725 381725 Biggs/Gridley Biggs/Gridley 2022-02-28 Butte 7 2898   8908
381726 381726 Chico Chico 2022-02-28 Butte 7 17092   91998
381727 381727 Durham Durham 2022-02-28 Butte 7 387   5863
381728 381728 Oroville Oroville 2022-02-28 Butte 7 9846   19040
381729 381729 Ridge Communities Ridge Communities 2022-02-28 Butte 7 1821   39707
381730 381730 95221, 95222 95221, 95222 2022-02-28 Calaveras 9 1010   5029
381731 381731 95223 95223 2022-02-28 Calaveras 9 370   2666
381732 381732 95225 95225 2022-02-28 Calaveras 9 100   378
381733 381733 95226, 95252 95226, 95252 2022-02-28 Calaveras 9 2438   16262
381734 381734 95228 95228 2022-02-28 Calaveras 9 795   4541
381735 381735 95232, 95245 95232, 95245 2022-02-28 Calaveras 9 284   161
381736 381736 95233, 95224, 95247, 95251, 95229 95233, 95224, 95247, 95251, 95229 2022-02-28 Calaveras 9 835   5364
381737 381737 95246, 95250 95246, 95250 2022-02-28 Calaveras 9 152   1159
381738 381738 95249 95249 2022-02-28 Calaveras 9 729   5444
381739 381739 95254 95254 2022-02-28 Calaveras 9 82   1035
381740 381740 95255, 95257, 95248 95255, 95257, 95248 2022-02-28 Calaveras 9 309   1802
381741 381741 Other Other 2022-02-28 Calaveras 9 53    
381742 381742 Alamo Alamo 2022-02-28 Contra Costa 13 1505   14750
381743 381743 Antioch Antioch 2022-02-28 Contra Costa 13 25298   112520
381744 381744 Bay Point Bay Point 2022-02-28 Contra Costa 13 6172   22639
381745 381745 Bethel Island Bethel Island 2022-02-28 Contra Costa 13 263   2137
381746 381746 Brentwood Brentwood 2022-02-28 Contra Costa 13 11266   65118
381747 381747 Byron Byron 2022-02-28 Contra Costa 13 249   1325
381748 381748 Clayton Clayton 2022-02-28 Contra Costa 13 1396   11337
381749 381749 Concord Concord 2022-02-28 Contra Costa 13 20280   130143
381750 381750 Crockett Crockett 2022-02-28 Contra Costa 13 438   3044
381751 381751 Danville Danville 2022-02-28 Contra Costa 13 5602   43876
381752 381752 Diablo Diablo 2022-02-28 Contra Costa 13 100   818
381753 381753 Discovery Bay Discovery Bay 2022-02-28 Contra Costa 13 2355   13352
381754 381754 El Cerrito El Cerrito 2022-02-28 Contra Costa 13 2512   24953
381755 381755 Hercules Hercules 2022-02-28 Contra Costa 13 4024   25530
381756 381756 Kensington Kensington 2022-02-28 Contra Costa 13 275   5077
381757 381757 Knightsen Knightsen 2022-02-28 Contra Costa 13 73   1500
381758 381758 Lafayette Lafayette 2022-02-28 Contra Costa 13 2249   25604
381759 381759 Martinez Martinez 2022-02-28 Contra Costa 13 6217   37106
381760 381760 Moraga Moraga 2022-02-28 Contra Costa 13 1210   16946
381761 381761 Oakley Oakley 2022-02-28 Contra Costa 13 9469   42461
381762 381762 Orinda Orinda 2022-02-28 Contra Costa 13 1566   19009
381763 381763 Pacheco Pacheco 2022-02-28 Contra Costa 13 660   3685
381764 381764 Pinole Pinole 2022-02-28 Contra Costa 13 3178   19505
381765 381765 Pittsburg Pittsburg 2022-02-28 Contra Costa 13 16403   74321
381766 381766 Pleasant Hill Pleasant Hill 2022-02-28 Contra Costa 13 4146   34267
381767 381767 Richmond Richmond 2022-02-28 Contra Costa 13 27765   111217
381768 381768 Rodeo Rodeo 2022-02-28 Contra Costa 13 1783   8679
381769 381769 San Pablo San Pablo 2022-02-28 Contra Costa 13 11852   31413
381770 381770 San Ramon San Ramon 2022-02-28 Contra Costa 13 7967   83118
381771 381771 Walnut Creek Walnut Creek 2022-02-28 Contra Costa 13 9256   70860

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "latimes-place-totals" (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] INTEGER
);
Powered by Datasette · Queries took 1569.685ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README