latimes-place-totals
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,263 rows where "date" is on date 2022-05-29
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
267370 | 267370 | 94501 | 94501: Alameda | 2022-05-29 | Alameda | 1 | 8839 | 62826 | |
267371 | 267371 | 94502 | 94502: Alameda | 2022-05-29 | Alameda | 1 | 1417 | 14117 | |
267372 | 267372 | 94505 | 94505: Discovery Bay | 2022-05-29 | Alameda | 1 | 4 | 16382 | |
267373 | 267373 | 94514 | 94514: Byron | 2022-05-29 | Alameda | 1 | 3 | 1461 | |
267374 | 267374 | 94536 | 94536: Fremont | 2022-05-29 | Alameda | 1 | 9933 | 72976 | |
267375 | 267375 | 94538 | 94538: Fremont | 2022-05-29 | Alameda | 1 | 10584 | 63911 | |
267376 | 267376 | 94539 | 94539: Fremont | 2022-05-29 | Alameda | 1 | 5325 | 52960 | |
267377 | 267377 | 94541 | 94541: Hayward | 2022-05-29 | Alameda | 1 | 15610 | 65132 | |
267378 | 267378 | 94542 | 94542: Hayward | 2022-05-29 | Alameda | 1 | 2316 | 13973 | |
267379 | 267379 | 94544 | 94544: Hayward | 2022-05-29 | Alameda | 1 | 18926 | 77121 | |
267380 | 267380 | 94545 | 94545: Hayward | 2022-05-29 | Alameda | 1 | 7055 | 31657 | |
267381 | 267381 | 94546 | 94546: Castro Valley | 2022-05-29 | Alameda | 1 | 7201 | 45536 | |
267382 | 267382 | 94550 | 94550: Livermore | 2022-05-29 | Alameda | 1 | 7414 | 50138 | |
267383 | 267383 | 94551 | 94551: Livermore | 2022-05-29 | Alameda | 1 | 7028 | 38986 | |
267384 | 267384 | 94552 | 94552: Castro Valley | 2022-05-29 | Alameda | 1 | 1719 | 15204 | |
267385 | 267385 | 94555 | 94555: Fremont | 2022-05-29 | Alameda | 1 | 4299 | 36037 | |
267386 | 267386 | 94560 | 94560: Newark | 2022-05-29 | Alameda | 1 | 8820 | 44245 | |
267387 | 267387 | 94566 | 94566: Pleasanton | 2022-05-29 | Alameda | 1 | 5211 | 45046 | |
267388 | 267388 | 94568 | 94568: Dublin | 2022-05-29 | Alameda | 1 | 10408 | 58399 | |
267389 | 267389 | 94577 | 94577: San Leandro | 2022-05-29 | Alameda | 1 | 9137 | 48666 | |
267390 | 267390 | 94578 | 94578: San Leandro | 2022-05-29 | Alameda | 1 | 8780 | 40150 | |
267391 | 267391 | 94579 | 94579: San Leandro | 2022-05-29 | Alameda | 1 | 4035 | 20237 | |
267392 | 267392 | 94580 | 94580: San Lorenzo | 2022-05-29 | Alameda | 1 | 6154 | 28970 | |
267393 | 267393 | 94586 | 94586: Sunol | 2022-05-29 | Alameda | 1 | 104 | 797 | |
267394 | 267394 | 94587 | 94587: Union City | 2022-05-29 | Alameda | 1 | 12460 | 72446 | |
267395 | 267395 | 94588 | 94588: Pleasanton | 2022-05-29 | Alameda | 1 | 4097 | 31895 | |
267396 | 267396 | 94601 | 94601: Oakland | 2022-05-29 | Alameda | 1 | 14155 | 53261 | |
267397 | 267397 | 94602 | 94602: Oakland | 2022-05-29 | Alameda | 1 | 4441 | 29770 | |
267398 | 267398 | 94603 | 94603: Oakland | 2022-05-29 | Alameda | 1 | 9876 | 33241 | |
267399 | 267399 | 94605 | 94605: Oakland | 2022-05-29 | Alameda | 1 | 8727 | 42375 | |
267400 | 267400 | 94606 | 94606: Oakland | 2022-05-29 | Alameda | 1 | 6829 | 37076 | |
267401 | 267401 | 94607 | 94607: Oakland | 2022-05-29 | Alameda | 1 | 5494 | 26646 | |
267402 | 267402 | 94608 | 94608: Emeryville | 2022-05-29 | Alameda | 1 | 5387 | 31000 | |
267403 | 267403 | 94609 | 94609: Oakland | 2022-05-29 | Alameda | 1 | 3877 | 22293 | |
267404 | 267404 | 94610 | 94610: Oakland | 2022-05-29 | Alameda | 1 | 3999 | 30862 | |
267405 | 267405 | 94611 | 94611: Oakland | 2022-05-29 | Alameda | 1 | 4545 | 37826 | |
267406 | 267406 | 94612 | 94612: Oakland | 2022-05-29 | Alameda | 1 | 3193 | 17279 | |
267407 | 267407 | 94613 | 94613: Oakland | 2022-05-29 | Alameda | 1 | 4 | 212 | |
267408 | 267408 | 94618 | 94618: Oakland | 2022-05-29 | Alameda | 1 | 1653 | 15545 | |
267409 | 267409 | 94619 | 94619: Oakland | 2022-05-29 | Alameda | 1 | 4027 | 24080 | |
267410 | 267410 | 94621 | 94621: Oakland | 2022-05-29 | Alameda | 1 | 9626 | 32915 | |
267411 | 267411 | 94702 | 94702: Berkeley | 2022-05-29 | Alameda | 1 | 2448 | 16520 | |
267412 | 267412 | 94703 | 94703: Berkeley | 2022-05-29 | Alameda | 1 | 2685 | 19805 | |
267413 | 267413 | 94704 | 94704: Berkeley | 2022-05-29 | Alameda | 1 | 4404 | 29129 | |
267414 | 267414 | 94705 | 94705: Berkeley | 2022-05-29 | Alameda | 1 | 1477 | 13152 | |
267415 | 267415 | 94706 | 94706: Albany | 2022-05-29 | Alameda | 1 | 1877 | 19921 | |
267416 | 267416 | 94707 | 94707: Berkeley | 2022-05-29 | Alameda | 1 | 774 | 12862 | |
267417 | 267417 | 94708 | 94708: Berkeley | 2022-05-29 | Alameda | 1 | 730 | 11725 | |
267418 | 267418 | 94709 | 94709: Berkeley | 2022-05-29 | Alameda | 1 | 1261 | 11796 | |
267419 | 267419 | 94710 | 94710: Berkeley | 2022-05-29 | Alameda | 1 | 1601 | 8059 | |
267420 | 267420 | 94720 | 94720: Berkeley | 2022-05-29 | Alameda | 1 | 967 | 1336 | |
267421 | 267421 | 95377 | 95377: Tracy | 2022-05-29 | Alameda | 1 | 1 | 32091 | |
267422 | 267422 | 95391 | 95391: Mountain House | 2022-05-29 | Alameda | 1 | 3 | 20131 | |
267423 | 267423 | 95221, 95222 | 95221, 95222 | 2022-05-29 | Calaveras | 9 | 1043 | 5029 | |
267424 | 267424 | 95223 | 95223 | 2022-05-29 | Calaveras | 9 | 390 | 2666 | |
267425 | 267425 | 95225 | 95225 | 2022-05-29 | Calaveras | 9 | 102 | 378 | |
267426 | 267426 | 95226, 95252 | 95226, 95252 | 2022-05-29 | Calaveras | 9 | 2516 | 16262 | |
267427 | 267427 | 95228 | 95228 | 2022-05-29 | Calaveras | 9 | 821 | 4541 | |
267428 | 267428 | 95232, 95245 | 95232, 95245 | 2022-05-29 | Calaveras | 9 | 294 | 161 | |
267429 | 267429 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-29 | Calaveras | 9 | 880 | 5364 | |
267430 | 267430 | 95246, 95250 | 95246, 95250 | 2022-05-29 | Calaveras | 9 | 162 | 1159 | |
267431 | 267431 | 95249 | 95249 | 2022-05-29 | Calaveras | 9 | 767 | 5444 | |
267432 | 267432 | 95254 | 95254 | 2022-05-29 | Calaveras | 9 | 88 | 1035 | |
267433 | 267433 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-29 | Calaveras | 9 | 327 | 1802 | |
267434 | 267434 | Other | Other | 2022-05-29 | Calaveras | 9 | 55 | ||
267435 | 267435 | Alamo | Alamo | 2022-05-29 | Contra Costa | 13 | 1742 | 14750 | |
267436 | 267436 | Antioch | Antioch | 2022-05-29 | Contra Costa | 13 | 27162 | 112520 | |
267437 | 267437 | Bay Point | Bay Point | 2022-05-29 | Contra Costa | 13 | 6525 | 22639 | |
267438 | 267438 | Bethel Island | Bethel Island | 2022-05-29 | Contra Costa | 13 | 279 | 2137 | |
267439 | 267439 | Brentwood | Brentwood | 2022-05-29 | Contra Costa | 13 | 12478 | 65118 | |
267440 | 267440 | Byron | Byron | 2022-05-29 | Contra Costa | 13 | 262 | 1325 | |
267441 | 267441 | Clayton | Clayton | 2022-05-29 | Contra Costa | 13 | 1585 | 11337 | |
267442 | 267442 | Concord | Concord | 2022-05-29 | Contra Costa | 13 | 22454 | 130143 | |
267443 | 267443 | Crockett | Crockett | 2022-05-29 | Contra Costa | 13 | 503 | 3044 | |
267444 | 267444 | Danville | Danville | 2022-05-29 | Contra Costa | 13 | 6604 | 43876 | |
267445 | 267445 | Diablo | Diablo | 2022-05-29 | Contra Costa | 13 | 115 | 818 | |
267446 | 267446 | Discovery Bay | Discovery Bay | 2022-05-29 | Contra Costa | 13 | 2570 | 13352 | |
267447 | 267447 | El Cerrito | El Cerrito | 2022-05-29 | Contra Costa | 13 | 2947 | 24953 | |
267448 | 267448 | Hercules | Hercules | 2022-05-29 | Contra Costa | 13 | 4588 | 25530 | |
267449 | 267449 | Kensington | Kensington | 2022-05-29 | Contra Costa | 13 | 362 | 5077 | |
267450 | 267450 | Knightsen | Knightsen | 2022-05-29 | Contra Costa | 13 | 79 | 1500 | |
267451 | 267451 | Lafayette | Lafayette | 2022-05-29 | Contra Costa | 13 | 2722 | 25604 | |
267452 | 267452 | Martinez | Martinez | 2022-05-29 | Contra Costa | 13 | 7092 | 37106 | |
267453 | 267453 | Moraga | Moraga | 2022-05-29 | Contra Costa | 13 | 1499 | 16946 | |
267454 | 267454 | Oakley | Oakley | 2022-05-29 | Contra Costa | 13 | 10267 | 42461 | |
267455 | 267455 | Orinda | Orinda | 2022-05-29 | Contra Costa | 13 | 1884 | 19009 | |
267456 | 267456 | Pacheco | Pacheco | 2022-05-29 | Contra Costa | 13 | 722 | 3685 | |
267457 | 267457 | Pinole | Pinole | 2022-05-29 | Contra Costa | 13 | 3525 | 19505 | |
267458 | 267458 | Pittsburg | Pittsburg | 2022-05-29 | Contra Costa | 13 | 17578 | 74321 | |
267459 | 267459 | Pleasant Hill | Pleasant Hill | 2022-05-29 | Contra Costa | 13 | 4879 | 34267 | |
267460 | 267460 | Richmond | Richmond | 2022-05-29 | Contra Costa | 13 | 29913 | 111217 | |
267461 | 267461 | Rodeo | Rodeo | 2022-05-29 | Contra Costa | 13 | 1973 | 8679 | |
267462 | 267462 | San Pablo | San Pablo | 2022-05-29 | Contra Costa | 13 | 12639 | 31413 | |
267463 | 267463 | San Ramon | San Ramon | 2022-05-29 | Contra Costa | 13 | 9715 | 83118 | |
267464 | 267464 | Walnut Creek | Walnut Creek | 2022-05-29 | Contra Costa | 13 | 10870 | 70860 | |
267465 | 267465 | Auberry | Auberry | 2022-05-29 | Fresno | 19 | 262 | 3994 | |
267466 | 267466 | Biola | Biola | 2022-05-29 | Fresno | 19 | 300 | 949 | |
267467 | 267467 | Cantua Creek | Cantua Creek | 2022-05-29 | Fresno | 19 | 202 | 1125 | |
267468 | 267468 | Caruthers | Caruthers | 2022-05-29 | Fresno | 19 | 1092 | 5887 | |
267469 | 267469 | Clovis | Clovis | 2022-05-29 | Fresno | 19 | 16159 | 122949 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-place-totals" ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] INTEGER );