⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

526,495 rows sorted by date descending

View and edit SQL

fips

county

Link rowid id name date ▲ county fips confirmed_cases note population
10970 94501 94501: Alameda 2021-05-02 Alameda 1 2113   62826
10971 94502 94502: Alameda 2021-05-02 Alameda 1 240   14117
10972 94505 94505: Discovery Bay 2021-05-02 Alameda 1 1   16382
10973 94514 94514: Byron 2021-05-02 Alameda 1 1   1461
10974 94536 94536: Fremont 2021-05-02 Alameda 1 2784   72976
10975 94538 94538: Fremont 2021-05-02 Alameda 1 2892   63911
10976 94539 94539: Fremont 2021-05-02 Alameda 1 1115   52960
10977 94541 94541: Hayward 2021-05-02 Alameda 1 6029   65132
10978 94542 94542: Hayward 2021-05-02 Alameda 1 704   13973
10979 94544 94544: Hayward 2021-05-02 Alameda 1 7386   77121
10980 94545 94545: Hayward 2021-05-02 Alameda 1 2339   31657
10981 94546 94546: Castro Valley 2021-05-02 Alameda 1 1822   45536
10982 94550 94550: Livermore 2021-05-02 Alameda 1 2114   50138
10983 94551 94551: Livermore 2021-05-02 Alameda 1 2170   38986
10984 94552 94552: Castro Valley 2021-05-02 Alameda 1 398   15204
10985 94555 94555: Fremont 2021-05-02 Alameda 1 972   36037
10986 94560 94560: Newark 2021-05-02 Alameda 1 2722   44245
10987 94566 94566: Pleasanton 2021-05-02 Alameda 1 1364   45046
10988 94568 94568: Dublin 2021-05-02 Alameda 1 2432   58399
10989 94577 94577: San Leandro 2021-05-02 Alameda 1 2919   48666
10990 94578 94578: San Leandro 2021-05-02 Alameda 1 3009   40150
10991 94579 94579: San Leandro 2021-05-02 Alameda 1 1112   20237
10992 94580 94580: San Lorenzo 2021-05-02 Alameda 1 2013   28970
10993 94586 94586: Sunol 2021-05-02 Alameda 1 33   797
10994 94587 94587: Union City 2021-05-02 Alameda 1 3930   72446
10995 94588 94588: Pleasanton 2021-05-02 Alameda 1 912   31895
10996 94601 94601: Oakland 2021-05-02 Alameda 1 5767   53261
10997 94602 94602: Oakland 2021-05-02 Alameda 1 1236   29770
10998 94603 94603: Oakland 2021-05-02 Alameda 1 4341   33241
10999 94605 94605: Oakland 2021-05-02 Alameda 1 2678   42375
11000 94606 94606: Oakland 2021-05-02 Alameda 1 2182   37076
11001 94607 94607: Oakland 2021-05-02 Alameda 1 1352   26646
11002 94608 94608: Emeryville 2021-05-02 Alameda 1 1104   31000
11003 94609 94609: Oakland 2021-05-02 Alameda 1 974   22293
11004 94610 94610: Oakland 2021-05-02 Alameda 1 740   30862
11005 94611 94611: Oakland 2021-05-02 Alameda 1 892   37826
11006 94612 94612: Oakland 2021-05-02 Alameda 1 629   17279
11007 94613 94613: Oakland 2021-05-02 Alameda 1 2   212
11008 94618 94618: Oakland 2021-05-02 Alameda 1 257   15545
11009 94619 94619: Oakland 2021-05-02 Alameda 1 1142   24080
11010 94621 94621: Oakland 2021-05-02 Alameda 1 4099   32915
11011 94702 94702: Berkeley 2021-05-02 Alameda 1 540   16520
11012 94703 94703: Berkeley 2021-05-02 Alameda 1 583   19805
11013 94704 94704: Berkeley 2021-05-02 Alameda 1 957   29129
11014 94705 94705: Berkeley 2021-05-02 Alameda 1 315   13152
11015 94706 94706: Albany 2021-05-02 Alameda 1 352   19921
11016 94707 94707: Berkeley 2021-05-02 Alameda 1 137   12862
11017 94708 94708: Berkeley 2021-05-02 Alameda 1 97   11725
11018 94709 94709: Berkeley 2021-05-02 Alameda 1 156   11796
11019 94710 94710: Berkeley 2021-05-02 Alameda 1 561   8059
11020 94720 94720: Berkeley 2021-05-02 Alameda 1 196   1336
11021 95377 95377: Tracy 2021-05-02 Alameda 1 1   32091
11022 95391 95391: Mountain House 2021-05-02 Alameda 1 1   20131
11023 Ione & surrounding unincorporated areas Ione & surrounding unincorporated areas 2021-05-02 Amador 5 504   7439
11024 Jackson Jackson 2021-05-02 Amador 5 514   4694
11025 Pine Grove Pine Grove 2021-05-02 Amador 5 166   1730
11026 Pioneer Pioneer 2021-05-02 Amador 5 170   1443
11027 Plymouth & surrounding unincorporated areas Plymouth & surrounding unincorporated areas 2021-05-02 Amador 5 154   894
11028 Sutter Creek & Amador City Sutter Creek & Amador City 2021-05-02 Amador 5 231   2705
11029 Volcano Volcano 2021-05-02 Amador 5 28   44
11030 Biggs/Gridley Biggs/Gridley 2021-05-02 Butte 7 1420   8908
11031 Chico Chico 2021-05-02 Butte 7 6350   91998
11032 Durham Durham 2021-05-02 Butte 7 146   5863
11033 Oroville Oroville 2021-05-02 Butte 7 2988   19040
11034 Other Other 2021-05-02 Butte 7 313   33084
11035 Ridge Communities Ridge Communities 2021-05-02 Butte 7 396   39707
11036 95221, 95222 95221, 95222 2021-05-02 Calaveras 9 268   5029
11037 95223 95223 2021-05-02 Calaveras 9 87   2666
11038 95224, 95247, 95251, 95229 95224, 95247, 95251, 95229 2021-05-02 Calaveras 9 229   4816
11039 95225 95225 2021-05-02 Calaveras 9 29   378
11040 95226, 95252 95226, 95252 2021-05-02 Calaveras 9 776   16262
11041 95228 95228 2021-05-02 Calaveras 9 225   4541
11042 95232, 95245 95232, 95245 2021-05-02 Calaveras 9 58   161
11043 95246, 95250 95246, 95250 2021-05-02 Calaveras 9 43   1159
11044 95249 95249 2021-05-02 Calaveras 9 243   5444
11045 95254 95254 2021-05-02 Calaveras 9 33   1035
11046 95255, 95257, 95248 95255, 95257, 95248 2021-05-02 Calaveras 9 53   1802
11047 Other Other 2021-05-02 Calaveras 9 48    
11048 Alamo Alamo 2021-05-02 Contra Costa 13 479   14750
11049 Antioch Antioch 2021-05-02 Contra Costa 13 9441   112520
11050 Bay Point Bay Point 2021-05-02 Contra Costa 13 2744   22639
11051 Bethel Island Bethel Island 2021-05-02 Contra Costa 13 71   2137
11052 Brentwood Brentwood 2021-05-02 Contra Costa 13 3756   65118
11053 Byron Byron 2021-05-02 Contra Costa 13 101   1325
11054 Clayton Clayton 2021-05-02 Contra Costa 13 412   11337
11055 Concord Concord 2021-05-02 Contra Costa 13 7963   130143
11056 Crockett Crockett 2021-05-02 Contra Costa 13 125   3044
11057 Danville Danville 2021-05-02 Contra Costa 13 1631   43876
11058 Diablo Diablo 2021-05-02 Contra Costa 13 37   818
11059 Discovery Bay Discovery Bay 2021-05-02 Contra Costa 13 837   13352
11060 El Cerrito El Cerrito 2021-05-02 Contra Costa 13 699   24953
11061 El Sobrante El Sobrante 2021-05-02 Contra Costa 13 1232   12669
11062 Hercules Hercules 2021-05-02 Contra Costa 13 1258   25530
11063 Kensington Kensington 2021-05-02 Contra Costa 13 47   5077
11064 Knightsen Knightsen 2021-05-02 Contra Costa 13 24   1500
11065 Lafayette Lafayette 2021-05-02 Contra Costa 13 619   25604
11066 Martinez Martinez 2021-05-02 Contra Costa 13 1938   37106
11067 Moraga Moraga 2021-05-02 Contra Costa 13 334   16946
11068 Oakley Oakley 2021-05-02 Contra Costa 13 3154   42461
11069 Orinda Orinda 2021-05-02 Contra Costa 13 408   19009

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] TEXT
);