home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for 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

1,251,796 rows sorted by date descending

✎ View and edit SQL

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

These facets timed out: date

fips >30

  • 37 359,354
  • 73 110,660
  • 65 64,576
  • 71 64,384
  • 1 54,961
  • 29 46,850
  • 59 41,369
  • 41 38,478
  • 97 33,120
  • 19 31,712
  • 61 31,264
  • 13 29,970
  • 81 29,010
  • 107 28,140
  • 75 26,520
  • 53 25,407
  • 111 24,575
  • 79 22,374
  • 55 17,730
  • 25 16,660
  • 57 15,657
  • 85 14,940
  • 33 12,045
  • 83 11,110
  • 47 10,140
  • 9 9,036
  • 31 8,829
  • 67 8,016
  • 95 7,936
  • 99 7,780
  • …

county >30

  • Los Angeles 359,354
  • San Diego 110,660
  • Riverside 64,576
  • San Bernardino 64,384
  • Alameda 54,961
  • Kern 46,850
  • Orange 41,369
  • Marin 38,478
  • Sonoma 33,120
  • Fresno 31,712
  • Placer 31,264
  • Contra Costa 29,970
  • San Mateo 29,010
  • Tulare 28,140
  • San Francisco 26,520
  • Monterey 25,407
  • Ventura 24,575
  • San Luis Obispo 22,374
  • Napa 17,730
  • Imperial 16,660
  • Nevada 15,657
  • Santa Clara 14,940
  • Lake 12,045
  • Santa Barbara 11,110
  • Merced 10,140
  • Calaveras 9,036
  • Kings 8,829
  • Sacramento 8,016
  • Solano 7,936
  • Stanislaus 7,780
  • …
Link rowid id name date ▲ county fips confirmed_cases note population
1 1 94501 94501: Alameda 2022-12-30 Alameda 1 11911   62826
2 2 94502 94502: Alameda 2022-12-30 Alameda 1 2057   14117
3 3 94505 94505: Discovery Bay 2022-12-30 Alameda 1 4   16382
4 4 94514 94514: Byron 2022-12-30 Alameda 1 3   1461
5 5 94536 94536: Fremont 2022-12-30 Alameda 1 13610   72976
6 6 94538 94538: Fremont 2022-12-30 Alameda 1 14303   63911
7 7 94539 94539: Fremont 2022-12-30 Alameda 1 7755   52960
8 8 94541 94541: Hayward 2022-12-30 Alameda 1 19284   65132
9 9 94542 94542: Hayward 2022-12-30 Alameda 1 3054   13973
10 10 94544 94544: Hayward 2022-12-30 Alameda 1 23527   77121
11 11 94545 94545: Hayward 2022-12-30 Alameda 1 9166   31657
12 12 94546 94546: Castro Valley 2022-12-30 Alameda 1 9576   45536
13 13 94550 94550: Livermore 2022-12-30 Alameda 1 9399   50138
14 14 94551 94551: Livermore 2022-12-30 Alameda 1 8839   38986
15 15 94552 94552: Castro Valley 2022-12-30 Alameda 1 2419   15204
16 16 94555 94555: Fremont 2022-12-30 Alameda 1 6028   36037
17 17 94560 94560: Newark 2022-12-30 Alameda 1 11902   44245
18 18 94566 94566: Pleasanton 2022-12-30 Alameda 1 7054   45046
19 19 94568 94568: Dublin 2022-12-30 Alameda 1 14203   58399
20 20 94577 94577: San Leandro 2022-12-30 Alameda 1 11851   48666
21 21 94578 94578: San Leandro 2022-12-30 Alameda 1 11167   40150
22 22 94579 94579: San Leandro 2022-12-30 Alameda 1 5515   20237
23 23 94580 94580: San Lorenzo 2022-12-30 Alameda 1 8047   28970
24 24 94586 94586: Sunol 2022-12-30 Alameda 1 146   797
25 25 94587 94587: Union City 2022-12-30 Alameda 1 16574   72446
26 26 94588 94588: Pleasanton 2022-12-30 Alameda 1 5863   31895
27 27 94601 94601: Oakland 2022-12-30 Alameda 1 16510   53261
28 28 94602 94602: Oakland 2022-12-30 Alameda 1 6025   29770
29 29 94603 94603: Oakland 2022-12-30 Alameda 1 11584   33241
30 30 94605 94605: Oakland 2022-12-30 Alameda 1 10983   42375
31 31 94606 94606: Oakland 2022-12-30 Alameda 1 8752   37076
32 32 94607 94607: Oakland 2022-12-30 Alameda 1 6784   26646
33 33 94608 94608: Emeryville 2022-12-30 Alameda 1 7113   31000
34 34 94609 94609: Oakland 2022-12-30 Alameda 1 5244   22293
35 35 94610 94610: Oakland 2022-12-30 Alameda 1 5747   30862
36 36 94611 94611: Oakland 2022-12-30 Alameda 1 6604   37826
37 37 94612 94612: Oakland 2022-12-30 Alameda 1 4227   17279
38 38 94613 94613: Oakland 2022-12-30 Alameda 1 8   212
39 39 94618 94618: Oakland 2022-12-30 Alameda 1 2309   15545
40 40 94619 94619: Oakland 2022-12-30 Alameda 1 5343   24080
41 41 94621 94621: Oakland 2022-12-30 Alameda 1 11341   32915
42 42 94702 94702: Berkeley 2022-12-30 Alameda 1 3433   16520
43 43 94703 94703: Berkeley 2022-12-30 Alameda 1 3841   19805
44 44 94704 94704: Berkeley 2022-12-30 Alameda 1 5322   29129
45 45 94705 94705: Berkeley 2022-12-30 Alameda 1 2170   13152
46 46 94706 94706: Albany 2022-12-30 Alameda 1 2913   19921
47 47 94707 94707: Berkeley 2022-12-30 Alameda 1 1202   12862
48 48 94708 94708: Berkeley 2022-12-30 Alameda 1 1114   11725
49 49 94709 94709: Berkeley 2022-12-30 Alameda 1 1743   11796
50 50 94710 94710: Berkeley 2022-12-30 Alameda 1 2086   8059
51 51 94720 94720: Berkeley 2022-12-30 Alameda 1 1132   1336
52 52 95377 95377: Tracy 2022-12-30 Alameda 1 1   32091
53 53 95391 95391: Mountain House 2022-12-30 Alameda 1 2   20131
54 54 95221, 95222 95221, 95222 2022-12-30 Calaveras 9 140   5029
55 55 95223 95223 2022-12-30 Calaveras 9 51   2666
56 56 95225 95225 2022-12-30 Calaveras 9 17   378
57 57 95226, 95252 95226, 95252 2022-12-30 Calaveras 9 435   16262
58 58 95228 95228 2022-12-30 Calaveras 9 119   4541
59 59 95232, 95245 95232, 95245 2022-12-30 Calaveras 9 34   161
60 60 95233, 95224, 95247, 95251, 95229 95233, 95224, 95247, 95251, 95229 2022-12-30 Calaveras 9 135   5364
61 61 95246, 95250 95246, 95250 2022-12-30 Calaveras 9 36   1159
62 62 95249 95249 2022-12-30 Calaveras 9 140   5444
63 63 95254 95254 2022-12-30 Calaveras 9 26   1035
64 64 95255, 95257, 95248 95255, 95257, 95248 2022-12-30 Calaveras 9 35   1802
65 65 Other Other 2022-12-30 Calaveras 9 43    
66 66 Alamo Alamo 2022-12-30 Contra Costa 13 2429   14750
67 67 Antioch Antioch 2022-12-30 Contra Costa 13 36594   112520
68 68 Bay Point Bay Point 2022-12-30 Contra Costa 13 8291   22639
69 69 Bethel Island Bethel Island 2022-12-30 Contra Costa 13 397   2137
70 70 Brentwood Brentwood 2022-12-30 Contra Costa 13 18749   65118
71 71 Byron Byron 2022-12-30 Contra Costa 13 349   1325
72 72 Clayton Clayton 2022-12-30 Contra Costa 13 2132   11337
73 73 Concord Concord 2022-12-30 Contra Costa 13 30127   130143
74 74 Crockett Crockett 2022-12-30 Contra Costa 13 654   3044
75 75 Danville Danville 2022-12-30 Contra Costa 13 9666   43876
76 76 Diablo Diablo 2022-12-30 Contra Costa 13 153   818
77 77 Discovery Bay Discovery Bay 2022-12-30 Contra Costa 13 3417   13352
78 78 El Cerrito El Cerrito 2022-12-30 Contra Costa 13 4540   24953
79 79 Hercules Hercules 2022-12-30 Contra Costa 13 6580   25530
80 80 Kensington Kensington 2022-12-30 Contra Costa 13 592   5077
81 81 Knightsen Knightsen 2022-12-30 Contra Costa 13 105   1500
82 82 Lafayette Lafayette 2022-12-30 Contra Costa 13 4314   25604
83 83 Martinez Martinez 2022-12-30 Contra Costa 13 10486   37106
84 84 Moraga Moraga 2022-12-30 Contra Costa 13 2299   16946
85 85 Oakley Oakley 2022-12-30 Contra Costa 13 13815   42461
86 86 Orinda Orinda 2022-12-30 Contra Costa 13 2799   19009
87 87 Pacheco Pacheco 2022-12-30 Contra Costa 13 1020   3685
88 88 Pinole Pinole 2022-12-30 Contra Costa 13 5010   19505
89 89 Pittsburg Pittsburg 2022-12-30 Contra Costa 13 22663   74321
90 90 Pleasant Hill Pleasant Hill 2022-12-30 Contra Costa 13 7029   34267
91 91 Richmond Richmond 2022-12-30 Contra Costa 13 39779   111217
92 92 Rodeo Rodeo 2022-12-30 Contra Costa 13 2590   8679
93 93 San Pablo San Pablo 2022-12-30 Contra Costa 13 16631   31413
94 94 San Ramon San Ramon 2022-12-30 Contra Costa 13 15025   83118
95 95 Walnut Creek Walnut Creek 2022-12-30 Contra Costa 13 15575   70860
96 96 Auberry Auberry 2022-12-30 Fresno 19 407   3994
97 97 Biola Biola 2022-12-30 Fresno 19 469   949
98 98 Cantua Creek Cantua Creek 2022-12-30 Fresno 19 306   1125
99 99 Caruthers Caruthers 2022-12-30 Fresno 19 1583   5887
100 100 Clovis Clovis 2022-12-30 Fresno 19 28757   122949

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
);
Powered by Datasette · Queries took 3568.307ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals