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-20
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths
Link | rowid ▼ | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
27261 | 27261 | 2020-05-20 | Alameda | 1 | 2564 | 120 | 50 | 1 |
27262 | 27262 | 2020-05-20 | Alpine | 3 | 1 | 0 | 0 | 0 |
27263 | 27263 | 2020-05-20 | Amador | 5 | 10 | 0 | 0 | 0 |
27264 | 27264 | 2020-05-20 | Butte | 7 | 30 | 0 | 5 | 0 |
27265 | 27265 | 2020-05-20 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27266 | 27266 | 2020-05-20 | Colusa | 11 | 4 | 0 | 1 | 0 |
27267 | 27267 | 2020-05-20 | Contra Costa | 13 | 1194 | 33 | 14 | 0 |
27268 | 27268 | 2020-05-20 | Del Norte | 15 | 15 | 0 | 1 | 0 |
27269 | 27269 | 2020-05-20 | El Dorado | 17 | 67 | 0 | 0 | 0 |
27270 | 27270 | 2020-05-20 | Fresno | 19 | 2372 | 20 | 100 | 3 |
27271 | 27271 | 2020-05-20 | Glenn | 21 | 12 | 0 | 0 | 0 |
27272 | 27272 | 2020-05-20 | Humboldt | 23 | 88 | 2 | 2 | 0 |
27273 | 27273 | 2020-05-20 | Imperial | 25 | 985 | 19 | 83 | 1 |
27274 | 27274 | 2020-05-20 | Inyo | 27 | 19 | 1 | 0 | 0 |
27275 | 27275 | 2020-05-20 | Kern | 29 | 1605 | 25 | 34 | 0 |
27276 | 27276 | 2020-05-20 | Kings | 31 | 457 | 2 | 41 | 0 |
27277 | 27277 | 2020-05-20 | Lake | 33 | 12 | 0 | 1 | 0 |
27278 | 27278 | 2020-05-20 | Lassen | 35 | 0 | 0 | 0 | 0 |
27279 | 27279 | 2020-05-20 | Los Angeles | 37 | 40975 | 1976 | 1343 | 50 |
27280 | 27280 | 2020-05-20 | Madera | 39 | 82 | 2 | 1 | 0 |
27281 | 27281 | 2020-05-20 | Marin | 41 | 343 | 14 | 7 | 0 |
27282 | 27282 | 2020-05-20 | Mariposa | 43 | 15 | 1 | 0 | 0 |
27283 | 27283 | 2020-05-20 | Mendocino | 45 | 15 | 0 | 0 | 0 |
27284 | 27284 | 2020-05-20 | Merced | 47 | 226 | 6 | 4 | 0 |
27285 | 27285 | 2020-05-20 | Modoc | 49 | 0 | 0 | 0 | 0 |
27286 | 27286 | 2020-05-20 | Mono | 51 | 34 | 1 | 0 | 0 |
27287 | 27287 | 2020-05-20 | Monterey | 53 | 355 | 8 | 6 | 0 |
27288 | 27288 | 2020-05-20 | Napa | 55 | 94 | 3 | 2 | 0 |
27289 | 27289 | 2020-05-20 | Nevada | 57 | 41 | 1 | 0 | 0 |
27290 | 27290 | 2020-05-20 | Orange | 59 | 4742 | 98 | 242 | 10 |
27291 | 27291 | 2020-05-20 | Placer | 61 | 177 | 8 | 0 | 0 |
27292 | 27292 | 2020-05-20 | Plumas | 63 | 4 | 0 | 0 | 0 |
27293 | 27293 | 2020-05-20 | Riverside | 65 | 6184 | 270 | 131 | 0 |
27294 | 27294 | 2020-05-20 | Sacramento | 67 | 1255 | 56 | 5 | 0 |
27295 | 27295 | 2020-05-20 | San Benito | 69 | 64 | 2 | 1 | 0 |
27296 | 27296 | 2020-05-20 | San Bernardino | 71 | 3795 | 177 | 88 | 2 |
27297 | 27297 | 2020-05-20 | San Diego | 73 | 6140 | 230 | 114 | 8 |
27298 | 27298 | 2020-05-20 | San Francisco | 75 | 2185 | 37 | 6 | 1 |
27299 | 27299 | 2020-05-20 | San Joaquin | 77 | 716 | 33 | 9 | 0 |
27300 | 27300 | 2020-05-20 | San Luis Obispo | 79 | 249 | 1 | 2 | 0 |
27301 | 27301 | 2020-05-20 | San Mateo | 81 | 1697 | 75 | 10 | 0 |
27302 | 27302 | 2020-05-20 | Santa Barbara | 83 | 1520 | 11 | 3 | 0 |
27303 | 27303 | 2020-05-20 | Santa Clara | 85 | 2609 | 136 | 36 | 0 |
27304 | 27304 | 2020-05-20 | Santa Cruz | 87 | 168 | 2 | 3 | 0 |
27305 | 27305 | 2020-05-20 | Shasta | 89 | 34 | 4 | 0 | 0 |
27306 | 27306 | 2020-05-20 | Sierra | 91 | 0 | 0 | 0 | 0 |
27307 | 27307 | 2020-05-20 | Siskiyou | 93 | 6 | 0 | 0 | 0 |
27308 | 27308 | 2020-05-20 | Solano | 95 | 435 | 18 | 5 | 2 |
27309 | 27309 | 2020-05-20 | Sonoma | 97 | 433 | 4 | 22 | 0 |
27310 | 27310 | 2020-05-20 | Stanislaus | 99 | 598 | 26 | 5 | 0 |
27311 | 27311 | 2020-05-20 | Sutter | 101 | 40 | 2 | 0 | 0 |
27312 | 27312 | 2020-05-20 | Tehama | 103 | 2 | 1 | 0 | 0 |
27313 | 27313 | 2020-05-20 | Trinity | 105 | 1 | 0 | 0 | 0 |
27314 | 27314 | 2020-05-20 | Tulare | 107 | 1552 | 73 | 13 | 2 |
27315 | 27315 | 2020-05-20 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
27316 | 27316 | 2020-05-20 | Ventura | 111 | 858 | 29 | 21 | 1 |
27317 | 27317 | 2020-05-20 | Yolo | 113 | 185 | 22 | 0 | 0 |
27318 | 27318 | 2020-05-20 | Yuba | 115 | 28 | 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 );