latimes_place_totals

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

172,190 rows sorted by date descending

View and edit SQL

place

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y
12381 2020-10-16 Alameda 1 Alameda 442   -122.274444 37.756111
12382 2020-10-16 Alameda 1 Albany 61   -122.297778 37.886944
12383 2020-10-16 Alameda 1 Berkeley 730   -122.272778 37.871667
12384 2020-10-16 Alameda 1 Dublin 307   -121.935833 37.702222
12385 2020-10-16 Alameda 1 Emeryville 95   -122.285278 37.831389
12386 2020-10-16 Alameda 1 Fremont 1507   -121.988611 37.548333
12387 2020-10-16 Alameda 1 Hayward 3277   -122.080796 37.66882
12388 2020-10-16 Alameda 1 Homeless 152      
12389 2020-10-16 Alameda 1 Livermore 967   -121.768056 37.681944
12390 2020-10-16 Alameda 1 Newark 601   -122.033333 37.533333
12391 2020-10-16 Alameda 1 Oakland 8748   -122.270833 37.804444
12392 2020-10-16 Alameda 1 Other 37      
12393 2020-10-16 Alameda 1 Piedmont 38   -122.233333 37.816667
12394 2020-10-16 Alameda 1 Pleasanton 482   -121.874722 37.6625
12395 2020-10-16 Alameda 1 San Leandro 1216   -122.156111 37.725
12396 2020-10-16 Alameda 1 Sunol 12   -121.888611 37.594444
12397 2020-10-16 Alameda 1 Union City 833   -122.048333 37.596389
12398 2020-10-16 Amador 5 Ione & surrounding unincorporated areas 58   -120.932778 38.352778
12399 2020-10-16 Amador 5 Jackson 115   -120.774167 38.348889
12400 2020-10-16 Amador 5 Pine Grove 23   -120.658889 38.413056
12401 2020-10-16 Amador 5 Pioneer 22   -120.571944 38.431944
12402 2020-10-16 Amador 5 Plymouth & surrounding unincorporated areas 17   -120.844722 38.481944
12403 2020-10-16 Amador 5 State Prison Inmate 45   -120.9532 38.3703
12404 2020-10-16 Amador 5 Sutter Creek & Amador City 31   -120.8025 38.393056
12405 2020-10-16 Amador 5 Volcano 6   -120.562377 38.409966
12406 2020-10-16 Butte 7 Biggs/Gridley 253   -121.705559 39.385866
12407 2020-10-16 Butte 7 Chico 2031   -121.837651 39.728494
12408 2020-10-16 Butte 7 Durham 30   -121.795876 39.664949
12409 2020-10-16 Butte 7 Oroville 566   -121.556649 39.51384
12410 2020-10-16 Butte 7 Other 19      
12411 2020-10-16 Butte 7 Ridge Communities 62   -121.580872 39.799577
12412 2020-10-16 Calaveras 9 District 1 156   -120.829167 38.191667
12413 2020-10-16 Calaveras 9 District 2 29   -120.540833 38.228333
12414 2020-10-16 Calaveras 9 District 3 29   -120.076111 38.438889
12415 2020-10-16 Calaveras 9 District 4 45   -120.641944 37.981111
12416 2020-10-16 Calaveras 9 District 5 74   -120.866667 38.1
12417 2020-10-16 Contra Costa 13 Alamo 119   -122.032222 37.850278
12418 2020-10-16 Contra Costa 13 Antioch 2394   -121.805833 38.005
12419 2020-10-16 Contra Costa 13 Bay Point 938   -121.961667 38.029167
12420 2020-10-16 Contra Costa 13 Bethel Island 13   -121.640556 38.015
12421 2020-10-16 Contra Costa 13 Brentwood 689   -121.695833 37.931944
12422 2020-10-16 Contra Costa 13 Byron 24   -121.638056 37.867222
12423 2020-10-16 Contra Costa 13 Clayton 58   -121.935833 37.941111
12424 2020-10-16 Contra Costa 13 Concord 2399   -122.031111 37.978056
12425 2020-10-16 Contra Costa 13 Crockett 17   -122.213056 38.0525
12426 2020-10-16 Contra Costa 13 Danville 363   -122.0 37.821667
12427 2020-10-16 Contra Costa 13 Discovery Bay 117   -121.600278 37.908611
12428 2020-10-16 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
12429 2020-10-16 Contra Costa 13 El Sobrante 297   -122.295278 37.977222
12430 2020-10-16 Contra Costa 13 Hercules 262   -122.288611 38.017222
12431 2020-10-16 Contra Costa 13 Lafayette 145   -122.118056 37.885833
12432 2020-10-16 Contra Costa 13 Martinez 378   -122.134167 38.019444
12433 2020-10-16 Contra Costa 13 Moraga 69   -122.129722 37.835
12434 2020-10-16 Contra Costa 13 Oakley 551   -121.7125 37.9975
12435 2020-10-16 Contra Costa 13 Orinda 118   -122.179722 37.882778
12436 2020-10-16 Contra Costa 13 Other 189      
12437 2020-10-16 Contra Costa 13 Pacheco 72   -122.075278 37.983611
12438 2020-10-16 Contra Costa 13 Pinole 233   -122.291111 38.004444
12439 2020-10-16 Contra Costa 13 Pittsburg 2018   -121.884722 38.028056
12440 2020-10-16 Contra Costa 13 Pleasant Hill 298   -122.0525 37.948056
12441 2020-10-16 Contra Costa 13 Richmond 3448   -122.347778 37.935833
12442 2020-10-16 Contra Costa 13 Rodeo 117   -122.266944 38.033056
12443 2020-10-16 Contra Costa 13 San Pablo 1532   -122.345556 37.962222
12444 2020-10-16 Contra Costa 13 San Ramon 381   -121.978056 37.78
12445 2020-10-16 Contra Costa 13 Walnut Creek 641   -122.065 37.906389
12446 2020-10-16 El Dorado 17 Camino, Pollock Pines, Kyburz 38   -120.586594 38.761292
12447 2020-10-16 El Dorado 17 El Dorado Hills 337   -121.082222 38.685833
12448 2020-10-16 El Dorado 17 El Dorado, Diamond Springs 36   -120.815 38.694722
12449 2020-10-16 El Dorado 17 Greater Placerville Area 142   -120.798611 38.729722
12450 2020-10-16 El Dorado 17 North County 34   -120.306071 38.99614
12451 2020-10-16 El Dorado 17 Shingle Springs, Cameron Park, Rescue 168   -120.987222 38.668889
12452 2020-10-16 El Dorado 17 South County 14   -120.57326 38.581296
12453 2020-10-16 El Dorado 17 Tahoe Region 506   -119.977187 38.939926
12454 2020-10-16 Fresno 19 Auberry 35   -119.401944 37.066111
12455 2020-10-16 Fresno 19 Biola 64   -120.01717 36.802306
12456 2020-10-16 Fresno 19 Cantua Creek 37   -120.316389 36.501389
12457 2020-10-16 Fresno 19 Caruthers 266   -119.834562 36.542564
12458 2020-10-16 Fresno 19 Clovis 1743   -119.703056 36.825278
12459 2020-10-16 Fresno 19 Coalinga 491   -120.360278 36.139722
12460 2020-10-16 Fresno 19 Del Rey 120   -119.593694 36.659187
12461 2020-10-16 Fresno 19 Dunlap 6   -119.120898 36.737991
12462 2020-10-16 Fresno 19 Firebaugh 361   -120.456111 36.858889
12463 2020-10-16 Fresno 19 Five Points 15   -120.102441 36.428874
12464 2020-10-16 Fresno 19 Fowler 242   -119.683333 36.633333
12465 2020-10-16 Fresno 19 Fresno 16389   -119.766667 36.75
12466 2020-10-16 Fresno 19 Friant 21   -119.711944 36.987778
12467 2020-10-16 Fresno 19 Huron 413   -120.103056 36.202778
12468 2020-10-16 Fresno 19 Kerman 888   -120.06 36.723611
12469 2020-10-16 Fresno 19 Kingsburg 443   -119.553889 36.513889
12470 2020-10-16 Fresno 19 Laton 134   -119.686686 36.433282
12471 2020-10-16 Fresno 19 Mendota 991   -120.381667 36.753611
12472 2020-10-16 Fresno 19 Orange Cove 673   -119.313611 36.624444
12473 2020-10-16 Fresno 19 Other 238      
12474 2020-10-16 Fresno 19 Parlier 1109   -119.526944 36.611667
12475 2020-10-16 Fresno 19 Pinedale 19   -119.79 36.842778
12476 2020-10-16 Fresno 19 Prather 10   -119.513889 37.0375
12477 2020-10-16 Fresno 19 Raisin City 32   -119.904167 36.6025
12478 2020-10-16 Fresno 19 Reedley 1427   -119.450278 36.596389
12479 2020-10-16 Fresno 19 Riverdale 261   -119.859444 36.431111
12480 2020-10-16 Fresno 19 San Joaquin 203   -120.189167 36.606667

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 1057.452ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals