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

✎ View and edit SQL

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

Link rowid ▼ id name date county fips confirmed_cases note population
389334 389334 94501 94501: Alameda 2022-02-22 Alameda 1 7300   62826
389335 389335 94502 94502: Alameda 2022-02-22 Alameda 1 1166   14117
389336 389336 94505 94505: Discovery Bay 2022-02-22 Alameda 1 4   16382
389337 389337 94514 94514: Byron 2022-02-22 Alameda 1 2   1461
389338 389338 94536 94536: Fremont 2022-02-22 Alameda 1 8564   72976
389339 389339 94538 94538: Fremont 2022-02-22 Alameda 1 9151   63911
389340 389340 94539 94539: Fremont 2022-02-22 Alameda 1 4183   52960
389341 389341 94541 94541: Hayward 2022-02-22 Alameda 1 14457   65132
389342 389342 94542 94542: Hayward 2022-02-22 Alameda 1 2079   13973
389343 389343 94544 94544: Hayward 2022-02-22 Alameda 1 17495   77121
389344 389344 94545 94545: Hayward 2022-02-22 Alameda 1 6347   31657
389345 389345 94546 94546: Castro Valley 2022-02-22 Alameda 1 6187   45536
389346 389346 94550 94550: Livermore 2022-02-22 Alameda 1 6602   50138
389347 389347 94551 94551: Livermore 2022-02-22 Alameda 1 6444   38986
389348 389348 94552 94552: Castro Valley 2022-02-22 Alameda 1 1439   15204
389349 389349 94555 94555: Fremont 2022-02-22 Alameda 1 3596   36037
389350 389350 94560 94560: Newark 2022-02-22 Alameda 1 7784   44245
389351 389351 94566 94566: Pleasanton 2022-02-22 Alameda 1 4395   45046
389352 389352 94568 94568: Dublin 2022-02-22 Alameda 1 8802   58399
389353 389353 94577 94577: San Leandro 2022-02-22 Alameda 1 8058   48666
389354 389354 94578 94578: San Leandro 2022-02-22 Alameda 1 8005   40150
389355 389355 94579 94579: San Leandro 2022-02-22 Alameda 1 3538   20237
389356 389356 94580 94580: San Lorenzo 2022-02-22 Alameda 1 5548   28970
389357 389357 94586 94586: Sunol 2022-02-22 Alameda 1 91   797
389358 389358 94587 94587: Union City 2022-02-22 Alameda 1 11088   72446
389359 389359 94588 94588: Pleasanton 2022-02-22 Alameda 1 3324   31895
389360 389360 94601 94601: Oakland 2022-02-22 Alameda 1 13267   53261
389361 389361 94602 94602: Oakland 2022-02-22 Alameda 1 3582   29770
389362 389362 94603 94603: Oakland 2022-02-22 Alameda 1 9243   33241
389363 389363 94605 94605: Oakland 2022-02-22 Alameda 1 7828   42375
389364 389364 94606 94606: Oakland 2022-02-22 Alameda 1 5929   37076
389365 389365 94607 94607: Oakland 2022-02-22 Alameda 1 4757   26646
389366 389366 94608 94608: Emeryville 2022-02-22 Alameda 1 4332   31000
389367 389367 94609 94609: Oakland 2022-02-22 Alameda 1 3103   22293
389368 389368 94610 94610: Oakland 2022-02-22 Alameda 1 3064   30862
389369 389369 94611 94611: Oakland 2022-02-22 Alameda 1 3248   37826
389370 389370 94612 94612: Oakland 2022-02-22 Alameda 1 2567   17279
389371 389371 94613 94613: Oakland 2022-02-22 Alameda 1 14   212
389372 389372 94618 94618: Oakland 2022-02-22 Alameda 1 1134   15545
389373 389373 94619 94619: Oakland 2022-02-22 Alameda 1 3401   24080
389374 389374 94621 94621: Oakland 2022-02-22 Alameda 1 9134   32915
389375 389375 94702 94702: Berkeley 2022-02-22 Alameda 1 2014   16520
389376 389376 94703 94703: Berkeley 2022-02-22 Alameda 1 2140   19805
389377 389377 94704 94704: Berkeley 2022-02-22 Alameda 1 3145   29129
389378 389378 94705 94705: Berkeley 2022-02-22 Alameda 1 1106   13152
389379 389379 94706 94706: Albany 2022-02-22 Alameda 1 1480   19921
389380 389380 94707 94707: Berkeley 2022-02-22 Alameda 1 562   12862
389381 389381 94708 94708: Berkeley 2022-02-22 Alameda 1 513   11725
389382 389382 94709 94709: Berkeley 2022-02-22 Alameda 1 861   11796
389383 389383 94710 94710: Berkeley 2022-02-22 Alameda 1 1393   8059
389384 389384 94720 94720: Berkeley 2022-02-22 Alameda 1 690   1336
389385 389385 95377 95377: Tracy 2022-02-22 Alameda 1 1   32091
389386 389386 95391 95391: Mountain House 2022-02-22 Alameda 1 2   20131
389387 389387 Biggs/Gridley Biggs/Gridley 2022-02-22 Butte 7 2885   8908
389388 389388 Chico Chico 2022-02-22 Butte 7 17007   91998
389389 389389 Durham Durham 2022-02-22 Butte 7 383   5863
389390 389390 Oroville Oroville 2022-02-22 Butte 7 9794   19040
389391 389391 Ridge Communities Ridge Communities 2022-02-22 Butte 7 1810   39707
389392 389392 95221, 95222 95221, 95222 2022-02-22 Calaveras 9 1005   5029
389393 389393 95223 95223 2022-02-22 Calaveras 9 369   2666
389394 389394 95225 95225 2022-02-22 Calaveras 9 97   378
389395 389395 95226, 95252 95226, 95252 2022-02-22 Calaveras 9 2428   16262
389396 389396 95228 95228 2022-02-22 Calaveras 9 793   4541
389397 389397 95232, 95245 95232, 95245 2022-02-22 Calaveras 9 283   161
389398 389398 95233, 95224, 95247, 95251, 95229 95233, 95224, 95247, 95251, 95229 2022-02-22 Calaveras 9 833   5364
389399 389399 95246, 95250 95246, 95250 2022-02-22 Calaveras 9 148   1159
389400 389400 95249 95249 2022-02-22 Calaveras 9 723   5444
389401 389401 95254 95254 2022-02-22 Calaveras 9 82   1035
389402 389402 95255, 95257, 95248 95255, 95257, 95248 2022-02-22 Calaveras 9 305   1802
389403 389403 Other Other 2022-02-22 Calaveras 9 53    
389404 389404 Alamo Alamo 2022-02-22 Contra Costa 13 1492   14750
389405 389405 Antioch Antioch 2022-02-22 Contra Costa 13 25165   112520
389406 389406 Bay Point Bay Point 2022-02-22 Contra Costa 13 6137   22639
389407 389407 Bethel Island Bethel Island 2022-02-22 Contra Costa 13 261   2137
389408 389408 Brentwood Brentwood 2022-02-22 Contra Costa 13 11199   65118
389409 389409 Byron Byron 2022-02-22 Contra Costa 13 249   1325
389410 389410 Clayton Clayton 2022-02-22 Contra Costa 13 1384   11337
389411 389411 Concord Concord 2022-02-22 Contra Costa 13 20135   130143
389412 389412 Crockett Crockett 2022-02-22 Contra Costa 13 431   3044
389413 389413 Danville Danville 2022-02-22 Contra Costa 13 5567   43876
389414 389414 Diablo Diablo 2022-02-22 Contra Costa 13 98   818
389415 389415 Discovery Bay Discovery Bay 2022-02-22 Contra Costa 13 2349   13352
389416 389416 El Cerrito El Cerrito 2022-02-22 Contra Costa 13 2466   24953
389417 389417 Hercules Hercules 2022-02-22 Contra Costa 13 3986   25530
389418 389418 Kensington Kensington 2022-02-22 Contra Costa 13 267   5077
389419 389419 Knightsen Knightsen 2022-02-22 Contra Costa 13 74   1500
389420 389420 Lafayette Lafayette 2022-02-22 Contra Costa 13 2196   25604
389421 389421 Martinez Martinez 2022-02-22 Contra Costa 13 6160   37106
389422 389422 Moraga Moraga 2022-02-22 Contra Costa 13 1179   16946
389423 389423 Oakley Oakley 2022-02-22 Contra Costa 13 9412   42461
389424 389424 Orinda Orinda 2022-02-22 Contra Costa 13 1512   19009
389425 389425 Pacheco Pacheco 2022-02-22 Contra Costa 13 658   3685
389426 389426 Pinole Pinole 2022-02-22 Contra Costa 13 3147   19505
389427 389427 Pittsburg Pittsburg 2022-02-22 Contra Costa 13 16325   74321
389428 389428 Pleasant Hill Pleasant Hill 2022-02-22 Contra Costa 13 4108   34267
389429 389429 Richmond Richmond 2022-02-22 Contra Costa 13 27553   111217
389430 389430 Rodeo Rodeo 2022-02-22 Contra Costa 13 1767   8679
389431 389431 San Pablo San Pablo 2022-02-22 Contra Costa 13 11766   31413
389432 389432 San Ramon San Ramon 2022-02-22 Contra Costa 13 7909   83118
389433 389433 Walnut Creek Walnut Creek 2022-02-22 Contra Costa 13 9178   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 1526.66ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README