latimes-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- county
- The name of the county where the agency is based.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- date
- The date when the data were retrieved in ISO 8601 format.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- deaths
- The cumulative number of deaths at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- new_deaths
- The net change in deaths over the previous date.
58 rows where "date" is on date 2020-05-02
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_confirmed_cases
Link | rowid ▼ | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
28305 | 28305 | 2020-05-02 | Alameda | 1 | 1722 | 98 | 64 | 0 |
28306 | 28306 | 2020-05-02 | Alpine | 3 | 1 | 0 | 0 | 0 |
28307 | 28307 | 2020-05-02 | Amador | 5 | 8 | 0 | 0 | 0 |
28308 | 28308 | 2020-05-02 | Butte | 7 | 17 | 0 | 0 | 0 |
28309 | 28309 | 2020-05-02 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28310 | 28310 | 2020-05-02 | Colusa | 11 | 3 | 0 | 0 | 0 |
28311 | 28311 | 2020-05-02 | Contra Costa | 13 | 923 | 28 | 24 | 0 |
28312 | 28312 | 2020-05-02 | Del Norte | 15 | 3 | 0 | 0 | 0 |
28313 | 28313 | 2020-05-02 | El Dorado | 17 | 47 | 0 | 0 | 0 |
28314 | 28314 | 2020-05-02 | Fresno | 19 | 1180 | 8 | 27 | 0 |
28315 | 28315 | 2020-05-02 | Glenn | 21 | 5 | 0 | 0 | 0 |
28316 | 28316 | 2020-05-02 | Humboldt | 23 | 54 | 0 | 0 | 0 |
28317 | 28317 | 2020-05-02 | Imperial | 25 | 358 | 9 | 0 | 0 |
28318 | 28318 | 2020-05-02 | Inyo | 27 | 19 | 1 | 0 | 0 |
28319 | 28319 | 2020-05-02 | Kern | 29 | 969 | 8 | 30 | 0 |
28320 | 28320 | 2020-05-02 | Kings | 31 | 158 | 1 | 12 | 0 |
28321 | 28321 | 2020-05-02 | Lake | 33 | 7 | 0 | 0 | 0 |
28322 | 28322 | 2020-05-02 | Lassen | 35 | 0 | 0 | 0 | 0 |
28323 | 28323 | 2020-05-02 | Los Angeles | 37 | 24936 | 1212 | 674 | 38 |
28324 | 28324 | 2020-05-02 | Madera | 39 | 51 | 2 | 5 | 0 |
28325 | 28325 | 2020-05-02 | Marin | 41 | 239 | 13 | 0 | 0 |
28326 | 28326 | 2020-05-02 | Mariposa | 43 | 13 | 0 | 0 | 0 |
28327 | 28327 | 2020-05-02 | Mendocino | 45 | 12 | 0 | 0 | 0 |
28328 | 28328 | 2020-05-02 | Merced | 47 | 140 | 3 | 4 | 0 |
28329 | 28329 | 2020-05-02 | Modoc | 49 | 0 | 0 | 0 | 0 |
28330 | 28330 | 2020-05-02 | Mono | 51 | 26 | 1 | 0 | 0 |
28331 | 28331 | 2020-05-02 | Monterey | 53 | 226 | 6 | 4 | 1 |
28332 | 28332 | 2020-05-02 | Napa | 55 | 70 | 2 | 2 | 0 |
28333 | 28333 | 2020-05-02 | Nevada | 57 | 41 | 1 | 0 | 0 |
28334 | 28334 | 2020-05-02 | Orange | 59 | 2612 | 52 | 92 | 2 |
28335 | 28335 | 2020-05-02 | Placer | 61 | 159 | 8 | 9 | 0 |
28336 | 28336 | 2020-05-02 | Plumas | 63 | 4 | 0 | 0 | 0 |
28337 | 28337 | 2020-05-02 | Riverside | 65 | 4164 | 161 | 85 | 5 |
28338 | 28338 | 2020-05-02 | Sacramento | 67 | 1107 | 42 | 17 | 0 |
28339 | 28339 | 2020-05-02 | San Benito | 69 | 51 | 2 | 0 | 0 |
28340 | 28340 | 2020-05-02 | San Bernardino | 71 | 2182 | 117 | 69 | 8 |
28341 | 28341 | 2020-05-02 | San Diego | 73 | 3842 | 138 | 131 | 4 |
28342 | 28342 | 2020-05-02 | San Francisco | 75 | 1543 | 29 | 20 | 1 |
28343 | 28343 | 2020-05-02 | San Joaquin | 77 | 558 | 25 | 3 | 0 |
28344 | 28344 | 2020-05-02 | San Luis Obispo | 79 | 196 | 1 | 8 | 0 |
28345 | 28345 | 2020-05-02 | San Mateo | 81 | 1233 | 51 | 36 | 0 |
28346 | 28346 | 2020-05-02 | Santa Barbara | 83 | 508 | 8 | 2 | 0 |
28347 | 28347 | 2020-05-02 | Santa Clara | 85 | 2256 | 118 | 12 | 3 |
28348 | 28348 | 2020-05-02 | Santa Cruz | 87 | 134 | 2 | 2 | 0 |
28349 | 28349 | 2020-05-02 | Shasta | 89 | 31 | 4 | 0 | 0 |
28350 | 28350 | 2020-05-02 | Sierra | 91 | 0 | 0 | 0 | 0 |
28351 | 28351 | 2020-05-02 | Siskiyou | 93 | 5 | 0 | 0 | 0 |
28352 | 28352 | 2020-05-02 | Solano | 95 | 266 | 5 | 0 | 0 |
28353 | 28353 | 2020-05-02 | Sonoma | 97 | 252 | 2 | 4 | 0 |
28354 | 28354 | 2020-05-02 | Stanislaus | 99 | 400 | 14 | 20 | 1 |
28355 | 28355 | 2020-05-02 | Sutter | 101 | 31 | 2 | 0 | 0 |
28356 | 28356 | 2020-05-02 | Tehama | 103 | 1 | 1 | 0 | 0 |
28357 | 28357 | 2020-05-02 | Trinity | 105 | 0 | 0 | 0 | 0 |
28358 | 28358 | 2020-05-02 | Tulare | 107 | 720 | 40 | 40 | 0 |
28359 | 28359 | 2020-05-02 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
28360 | 28360 | 2020-05-02 | Ventura | 111 | 559 | 19 | 15 | 1 |
28361 | 28361 | 2020-05-02 | Yolo | 113 | 171 | 16 | 2 | 0 |
28362 | 28362 | 2020-05-02 | Yuba | 115 | 19 | 1 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );