⚠️ 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

485,061 rows sorted by date descending

View and edit SQL

fips

county

Link rowid id name date ▲ county fips confirmed_cases note population
4105 94501 94501: Alameda 2021-04-07 Alameda 1 2054   62826
4106 94502 94502: Alameda 2021-04-07 Alameda 1 235   14117
4107 94505 94505: Discovery Bay 2021-04-07 Alameda 1 1   16382
4108 94536 94536: Fremont 2021-04-07 Alameda 1 2716   72976
4109 94538 94538: Fremont 2021-04-07 Alameda 1 2778   63911
4110 94539 94539: Fremont 2021-04-07 Alameda 1 1069   52960
4111 94541 94541: Hayward 2021-04-07 Alameda 1 5917   65132
4112 94542 94542: Hayward 2021-04-07 Alameda 1 692   13973
4113 94544 94544: Hayward 2021-04-07 Alameda 1 7269   77121
4114 94545 94545: Hayward 2021-04-07 Alameda 1 2274   31657
4115 94546 94546: Castro Valley 2021-04-07 Alameda 1 1775   45536
4116 94550 94550: Livermore 2021-04-07 Alameda 1 2082   50138
4117 94551 94551: Livermore 2021-04-07 Alameda 1 2134   38986
4118 94552 94552: Castro Valley 2021-04-07 Alameda 1 390   15204
4119 94555 94555: Fremont 2021-04-07 Alameda 1 936   36037
4120 94560 94560: Newark 2021-04-07 Alameda 1 2662   44245
4121 94566 94566: Pleasanton 2021-04-07 Alameda 1 1318   45046
4122 94568 94568: Dublin 2021-04-07 Alameda 1 2299   58399
4123 94577 94577: San Leandro 2021-04-07 Alameda 1 2846   48666
4124 94578 94578: San Leandro 2021-04-07 Alameda 1 2913   40150
4125 94579 94579: San Leandro 2021-04-07 Alameda 1 1087   20237
4126 94580 94580: San Lorenzo 2021-04-07 Alameda 1 1952   28970
4127 94586 94586: Sunol 2021-04-07 Alameda 1 33   797
4128 94587 94587: Union City 2021-04-07 Alameda 1 3851   72446
4129 94588 94588: Pleasanton 2021-04-07 Alameda 1 884   31895
4130 94601 94601: Oakland 2021-04-07 Alameda 1 5641   53261
4131 94602 94602: Oakland 2021-04-07 Alameda 1 1194   29770
4132 94603 94603: Oakland 2021-04-07 Alameda 1 4232   33241
4133 94605 94605: Oakland 2021-04-07 Alameda 1 2560   42375
4134 94606 94606: Oakland 2021-04-07 Alameda 1 2112   37076
4135 94607 94607: Oakland 2021-04-07 Alameda 1 1284   26646
4136 94608 94608: Emeryville 2021-04-07 Alameda 1 1081   31000
4137 94609 94609: Oakland 2021-04-07 Alameda 1 952   22293
4138 94610 94610: Oakland 2021-04-07 Alameda 1 710   30862
4139 94611 94611: Oakland 2021-04-07 Alameda 1 860   37826
4140 94612 94612: Oakland 2021-04-07 Alameda 1 609   17279
4141 94613 94613: Oakland 2021-04-07 Alameda 1 2   212
4142 94618 94618: Oakland 2021-04-07 Alameda 1 249   15545
4143 94619 94619: Oakland 2021-04-07 Alameda 1 1086   24080
4144 94621 94621: Oakland 2021-04-07 Alameda 1 4015   32915
4145 94702 94702: Berkeley 2021-04-07 Alameda 1 520   16520
4146 94703 94703: Berkeley 2021-04-07 Alameda 1 566   19805
4147 94704 94704: Berkeley 2021-04-07 Alameda 1 917   29129
4148 94705 94705: Berkeley 2021-04-07 Alameda 1 306   13152
4149 94706 94706: Albany 2021-04-07 Alameda 1 345   19921
4150 94707 94707: Berkeley 2021-04-07 Alameda 1 137   12862
4151 94708 94708: Berkeley 2021-04-07 Alameda 1 90   11725
4152 94709 94709: Berkeley 2021-04-07 Alameda 1 155   11796
4153 94710 94710: Berkeley 2021-04-07 Alameda 1 553   8059
4154 94720 94720: Berkeley 2021-04-07 Alameda 1 194   1336
4155 95377 95377: Tracy 2021-04-07 Alameda 1 1   32091
4156 95391 95391: Mountain House 2021-04-07 Alameda 1 1   20131
4157 Ione & surrounding unincorporated areas Ione & surrounding unincorporated areas 2021-04-07 Amador 5 489   7439
4158 Jackson Jackson 2021-04-07 Amador 5 500   4694
4159 Pine Grove Pine Grove 2021-04-07 Amador 5 158   1730
4160 Pioneer Pioneer 2021-04-07 Amador 5 164   1443
4161 Plymouth & surrounding unincorporated areas Plymouth & surrounding unincorporated areas 2021-04-07 Amador 5 148   894
4162 Sutter Creek & Amador City Sutter Creek & Amador City 2021-04-07 Amador 5 227   2705
4163 Volcano Volcano 2021-04-07 Amador 5 27   44
4164 Biggs/Gridley Biggs/Gridley 2021-04-07 Butte 7 1398   8908
4165 Chico Chico 2021-04-07 Butte 7 6061   91998
4166 Durham Durham 2021-04-07 Butte 7 145   5863
4167 Oroville Oroville 2021-04-07 Butte 7 2883   19040
4168 Other Other 2021-04-07 Butte 7 320   33084
4169 Ridge Communities Ridge Communities 2021-04-07 Butte 7 386   39707
4170 95221, 95222 95221, 95222 2021-04-07 Calaveras 9 249   5029
4171 95223 95223 2021-04-07 Calaveras 9 82   2666
4172 95224, 95247, 95251, 95229 95224, 95247, 95251, 95229 2021-04-07 Calaveras 9 221   4816
4173 95225 95225 2021-04-07 Calaveras 9 28   378
4174 95226, 95252 95226, 95252 2021-04-07 Calaveras 9 761   16262
4175 95228 95228 2021-04-07 Calaveras 9 216   4541
4176 95232, 95245 95232, 95245 2021-04-07 Calaveras 9 54   161
4177 95246, 95250 95246, 95250 2021-04-07 Calaveras 9 42   1159
4178 95249 95249 2021-04-07 Calaveras 9 243   5444
4179 95254 95254 2021-04-07 Calaveras 9 33   1035
4180 95255, 95257, 95248 95255, 95257, 95248 2021-04-07 Calaveras 9 53   1802
4181 Other Other 2021-04-07 Calaveras 9 47    
4182 Alamo Alamo 2021-04-07 Contra Costa 13 464   14750
4183 Antioch Antioch 2021-04-07 Contra Costa 13 9121   112520
4184 Bay Point Bay Point 2021-04-07 Contra Costa 13 2665   22639
4185 Bethel Island Bethel Island 2021-04-07 Contra Costa 13 66   2137
4186 Brentwood Brentwood 2021-04-07 Contra Costa 13 3618   65118
4187 Byron Byron 2021-04-07 Contra Costa 13 99   1325
4188 Clayton Clayton 2021-04-07 Contra Costa 13 393   11337
4189 Concord Concord 2021-04-07 Contra Costa 13 7717   130143
4190 Crockett Crockett 2021-04-07 Contra Costa 13 123   3044
4191 Danville Danville 2021-04-07 Contra Costa 13 1556   43876
4192 Diablo Diablo 2021-04-07 Contra Costa 13 36   818
4193 Discovery Bay Discovery Bay 2021-04-07 Contra Costa 13 809   13352
4194 El Cerrito El Cerrito 2021-04-07 Contra Costa 13 681   24953
4195 El Sobrante El Sobrante 2021-04-07 Contra Costa 13 1165   12669
4196 Hercules Hercules 2021-04-07 Contra Costa 13 1207   25530
4197 Kensington Kensington 2021-04-07 Contra Costa 13 45   5077
4198 Knightsen Knightsen 2021-04-07 Contra Costa 13 23   1500
4199 Lafayette Lafayette 2021-04-07 Contra Costa 13 595   25604
4200 Martinez Martinez 2021-04-07 Contra Costa 13 1892   37106
4201 Moraga Moraga 2021-04-07 Contra Costa 13 309   16946
4202 Oakley Oakley 2021-04-07 Contra Costa 13 2999   42461
4203 Orinda Orinda 2021-04-07 Contra Costa 13 402   19009
4204 Pacheco Pacheco 2021-04-07 Contra Costa 13 226   3685

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