home / covid

Menu
  • GraphQL API

latimes_county_totals

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

31,362 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips >30

  • 37 586
  • 59 586
  • 85 586
  • 69 581
  • 23 564
  • 67 564
  • 95 560
  • 1 559
  • 9 559
  • 13 559
  • 41 559
  • 61 559
  • 65 559
  • 73 559
  • 75 559
  • 81 559
  • 87 559
  • 89 559
  • 97 559
  • 99 559
  • 111 559
  • 113 559
  • 19 555
  • 77 551
  • 39 545
  • 25 541
  • 107 541
  • 5 539
  • 79 538
  • 71 537
  • …

county >30

  • Los Angeles 586
  • Orange 586
  • Santa Clara 586
  • San Benito 581
  • Humboldt 564
  • Sacramento 564
  • Solano 560
  • Alameda 559
  • Calaveras 559
  • Contra Costa 559
  • Marin 559
  • Placer 559
  • Riverside 559
  • San Diego 559
  • San Francisco 559
  • San Mateo 559
  • Santa Cruz 559
  • Shasta 559
  • Sonoma 559
  • Stanislaus 559
  • Ventura 559
  • Yolo 559
  • Fresno 555
  • San Joaquin 551
  • Madera 545
  • Imperial 541
  • Tulare 541
  • Amador 539
  • San Luis Obispo 538
  • San Bernardino 537
  • …
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
1 1 2021-09-02 Alameda 1 109537 1316 655 2
2 2 2021-09-02 Alpine 3 89 0 0 0
3 3 2021-09-02 Amador 5 4559 53 33 0
4 4 2021-09-02 Butte 7 16281 209 108 0
5 5 2021-09-02 Calaveras 9 2948 63 25 0
6 6 2021-09-02 Colusa 11 2754 18 0 0
7 7 2021-09-02 Contra Costa 13 90440 882 193 10
8 8 2021-09-02 Del Norte 15 3012 25 44 2
9 9 2021-09-02 El Dorado 17 13678 122 60 0
10 10 2021-09-02 Fresno 19 117492 1801 337 0
11 11 2021-09-02 Glenn 21 2647 30 33 0
12 12 2021-09-02 Humboldt 23 7308 75 139 0
13 13 2021-09-02 Imperial 25 30031 753 57 0
14 14 2021-09-02 Inyo 27 1589 39 0 0
15 15 2021-09-02 Kern 29 126250 1478 614 5
16 16 2021-09-02 Kings 31 26715 266 194 0
17 17 2021-09-02 Lake 33 5396 77 37 3
18 18 2021-09-02 Lassen 35 6341 27 0 0
19 19 2021-09-02 Los Angeles 37 1412379 25366 2695 40
20 20 2021-09-02 Madera 39 18670 250 0 0
21 21 2021-09-02 Marin 41 16365 217 33 0
22 22 2021-09-02 Mariposa 43 833 10 8 0
23 23 2021-09-02 Mendocino 45 6117 64 42 0
24 24 2021-09-02 Merced 47 37265 513 178 1
25 25 2021-09-02 Modoc 49 627 8 6 1
26 26 2021-09-02 Mono 51 1461 5 3 0
27 27 2021-09-02 Monterey 53 46684 542 28 0
28 28 2021-09-02 Napa 55 11706 91 32 0
29 29 2021-09-02 Nevada 57 7503 85 140 0
30 30 2021-09-02 Orange 59 286536 5236 437 7
31 31 2021-09-02 Placer 61 31104 331 308 5
32 32 2021-09-02 Plumas 63 1017 6 0 0
33 33 2021-09-02 Riverside 65 337921 4749 846 11
34 34 2021-09-02 Sacramento 67 137854 1941 622 7
35 35 2021-09-02 San Benito 69 6767 65 37 0
36 36 2021-09-02 San Bernardino 71 332082 4924 484 6
37 37 2021-09-02 San Diego 73 335302 3908 925 20
38 38 2021-09-02 San Francisco 75 47465 591 210 4
39 39 2021-09-02 San Joaquin 77 87365 1540 0 0
40 40 2021-09-02 San Luis Obispo 79 25729 284 0 0
41 41 2021-09-02 San Mateo 81 49186 595 158 0
42 42 2021-09-02 Santa Barbara 83 39500 481 111 1
43 43 2021-09-02 Santa Clara 85 135732 1731 357 0
44 44 2021-09-02 Santa Cruz 87 18518 210 178 0
45 45 2021-09-02 Shasta 89 15889 255 159 1
46 46 2021-09-02 Sierra 91 198 0 7 0
47 47 2021-09-02 Siskiyou 93 3443 41 41 0
48 48 2021-09-02 Solano 95 41521 273 0 0
49 49 2021-09-02 Sonoma 97 37055 356 249 0
50 50 2021-09-02 Stanislaus 99 68020 1159 263 9
51 51 2021-09-02 Sutter 101 12161 124 75 1
52 52 2021-09-02 Tehama 103 7143 72 75 0
53 53 2021-09-02 Trinity 105 692 10 17 0
54 54 2021-09-02 Tulare 107 55762 869 472 0
55 55 2021-09-02 Tuolumne 109 5778 93 46 1
56 56 2021-09-02 Ventura 111 90731 1084 0 3
57 57 2021-09-02 Yolo 113 17244 231 68 0
58 58 2021-09-02 Yuba 115 8865 52 81 0
59 59 2021-09-01 Alameda 1 108882 1314 1200 2
60 60 2021-09-01 Alpine 3 89 0 0 0
61 61 2021-09-01 Amador 5 4526 53 43 0
62 62 2021-09-01 Butte 7 16173 209 149 0
63 63 2021-09-01 Calaveras 9 2923 63 59 2
64 64 2021-09-01 Colusa 11 2754 18 0 0
65 65 2021-09-01 Contra Costa 13 90247 872 293 3
66 66 2021-09-01 Del Norte 15 2968 23 34 0
67 67 2021-09-01 El Dorado 17 13618 122 28 0
68 68 2021-09-01 Fresno 19 117155 1801 1288 9
69 69 2021-09-01 Glenn 21 2614 30 7 0
70 70 2021-09-01 Humboldt 23 7169 75 58 0
71 71 2021-09-01 Imperial 25 29974 753 0 0
72 72 2021-09-01 Inyo 27 1589 39 0 0
73 73 2021-09-01 Kern 29 125636 1473 693 8
74 74 2021-09-01 Kings 31 26521 266 38 1
75 75 2021-09-01 Lake 33 5359 74 36 0
76 76 2021-09-01 Lassen 35 6341 27 0 0
77 77 2021-09-01 Los Angeles 37 1409684 25326 3895 73
78 78 2021-09-01 Madera 39 18670 250 0 0
79 79 2021-09-01 Marin 41 16332 217 21 2
80 80 2021-09-01 Mariposa 43 825 10 9 0
81 81 2021-09-01 Mendocino 45 6075 64 48 0
82 82 2021-09-01 Merced 47 37087 512 170 3
83 83 2021-09-01 Modoc 49 621 7 7 0
84 84 2021-09-01 Mono 51 1458 5 7 0
85 85 2021-09-01 Monterey 53 46656 542 111 0
86 86 2021-09-01 Napa 55 11674 91 48 4
87 87 2021-09-01 Nevada 57 7363 85 207 0
88 88 2021-09-01 Orange 59 286099 5229 646 4
89 89 2021-09-01 Placer 61 30796 326 0 0
90 90 2021-09-01 Plumas 63 1017 6 0 0
91 91 2021-09-01 Riverside 65 337075 4738 1022 7
92 92 2021-09-01 Sacramento 67 137232 1934 615 11
93 93 2021-09-01 San Benito 69 6730 65 34 0
94 94 2021-09-01 San Bernardino 71 331598 4918 689 1
95 95 2021-09-01 San Diego 73 334377 3888 0 0
96 96 2021-09-01 San Francisco 75 47255 587 382 3
97 97 2021-09-01 San Joaquin 77 87365 1540 1443 12
98 98 2021-09-01 San Luis Obispo 79 25729 284 0 0
99 99 2021-09-01 San Mateo 81 49028 595 268 0
100 100 2021-09-01 Santa Barbara 83 39389 480 175 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);
Powered by Datasette · Queries took 250.632ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals