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.
31,362 rows sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
31341 | 31341 | 2020-01-26 | Alameda | 1 | 0 | 0 | ||
31342 | 31342 | 2020-01-26 | Calaveras | 9 | 0 | 0 | ||
31343 | 31343 | 2020-01-26 | Contra Costa | 13 | 0 | 0 | ||
31344 | 31344 | 2020-01-26 | Humboldt | 23 | 0 | 0 | ||
31345 | 31345 | 2020-01-26 | Los Angeles | 37 | 1 | 0 | ||
31346 | 31346 | 2020-01-26 | Marin | 41 | 0 | 0 | ||
31347 | 31347 | 2020-01-26 | Orange | 59 | 1 | 0 | ||
31348 | 31348 | 2020-01-26 | Placer | 61 | 0 | 0 | ||
31349 | 31349 | 2020-01-26 | Riverside | 65 | 0 | 0 | ||
31350 | 31350 | 2020-01-26 | Sacramento | 67 | 0 | 0 | ||
31351 | 31351 | 2020-01-26 | San Benito | 69 | 0 | 0 | ||
31352 | 31352 | 2020-01-26 | San Diego | 73 | 0 | 0 | ||
31353 | 31353 | 2020-01-26 | San Francisco | 75 | 0 | 0 | ||
31354 | 31354 | 2020-01-26 | San Mateo | 81 | 0 | 0 | ||
31355 | 31355 | 2020-01-26 | Santa Clara | 85 | 0 | 0 | ||
31356 | 31356 | 2020-01-26 | Santa Cruz | 87 | 0 | 0 | ||
31357 | 31357 | 2020-01-26 | Shasta | 89 | 0 | 0 | ||
31358 | 31358 | 2020-01-26 | Solano | 95 | 0 | 0 | ||
31359 | 31359 | 2020-01-26 | Sonoma | 97 | 0 | 0 | ||
31360 | 31360 | 2020-01-26 | Stanislaus | 99 | 0 | 0 | ||
31361 | 31361 | 2020-01-26 | Ventura | 111 | 0 | 0 | ||
31362 | 31362 | 2020-01-26 | Yolo | 113 | 0 | 0 | ||
31338 | 31338 | 2020-01-27 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31339 | 31339 | 2020-01-27 | Orange | 59 | 1 | 0 | 0 | 0 |
31340 | 31340 | 2020-01-27 | Santa Clara | 85 | 1 | 0 | 1 | 0 |
31335 | 31335 | 2020-01-28 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31336 | 31336 | 2020-01-28 | Orange | 59 | 1 | 0 | 0 | 0 |
31337 | 31337 | 2020-01-28 | Santa Clara | 85 | 2 | 0 | 1 | 0 |
31332 | 31332 | 2020-01-29 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31333 | 31333 | 2020-01-29 | Orange | 59 | 1 | 0 | 0 | 0 |
31334 | 31334 | 2020-01-29 | Santa Clara | 85 | 3 | 0 | 1 | 0 |
31329 | 31329 | 2020-01-30 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31330 | 31330 | 2020-01-30 | Orange | 59 | 1 | 0 | 0 | 0 |
31331 | 31331 | 2020-01-30 | Santa Clara | 85 | 4 | 0 | 1 | 0 |
31307 | 31307 | 2020-01-31 | Alameda | 1 | 0 | 0 | 0 | 0 |
31308 | 31308 | 2020-01-31 | Calaveras | 9 | 0 | 0 | 0 | 0 |
31309 | 31309 | 2020-01-31 | Contra Costa | 13 | 0 | 0 | 0 | 0 |
31310 | 31310 | 2020-01-31 | Humboldt | 23 | 0 | 0 | 0 | 0 |
31311 | 31311 | 2020-01-31 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31312 | 31312 | 2020-01-31 | Marin | 41 | 0 | 0 | 0 | 0 |
31313 | 31313 | 2020-01-31 | Orange | 59 | 1 | 0 | 0 | 0 |
31314 | 31314 | 2020-01-31 | Placer | 61 | 0 | 0 | 0 | 0 |
31315 | 31315 | 2020-01-31 | Riverside | 65 | 0 | 0 | 0 | 0 |
31316 | 31316 | 2020-01-31 | Sacramento | 67 | 0 | 0 | 0 | 0 |
31317 | 31317 | 2020-01-31 | San Benito | 69 | 0 | 0 | 0 | 0 |
31318 | 31318 | 2020-01-31 | San Diego | 73 | 0 | 0 | 0 | 0 |
31319 | 31319 | 2020-01-31 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31320 | 31320 | 2020-01-31 | San Mateo | 81 | 0 | 0 | 0 | 0 |
31321 | 31321 | 2020-01-31 | Santa Clara | 85 | 6 | 0 | 2 | 0 |
31322 | 31322 | 2020-01-31 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
31323 | 31323 | 2020-01-31 | Shasta | 89 | 0 | 0 | 0 | 0 |
31324 | 31324 | 2020-01-31 | Solano | 95 | 0 | 0 | 0 | 0 |
31325 | 31325 | 2020-01-31 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31326 | 31326 | 2020-01-31 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
31327 | 31327 | 2020-01-31 | Ventura | 111 | 0 | 0 | 0 | 0 |
31328 | 31328 | 2020-01-31 | Yolo | 113 | 0 | 0 | 0 | 0 |
31304 | 31304 | 2020-02-01 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31305 | 31305 | 2020-02-01 | Orange | 59 | 1 | 0 | 0 | 0 |
31306 | 31306 | 2020-02-01 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31282 | 31282 | 2020-02-02 | Alameda | 1 | 1 | 0 | 1 | 0 |
31283 | 31283 | 2020-02-02 | Calaveras | 9 | 0 | 0 | 0 | 0 |
31284 | 31284 | 2020-02-02 | Contra Costa | 13 | 0 | 0 | 0 | 0 |
31285 | 31285 | 2020-02-02 | Humboldt | 23 | 0 | 0 | 0 | 0 |
31286 | 31286 | 2020-02-02 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31287 | 31287 | 2020-02-02 | Marin | 41 | 0 | 0 | 0 | 0 |
31288 | 31288 | 2020-02-02 | Orange | 59 | 1 | 0 | 0 | 0 |
31289 | 31289 | 2020-02-02 | Placer | 61 | 0 | 0 | 0 | 0 |
31290 | 31290 | 2020-02-02 | Riverside | 65 | 0 | 0 | 0 | 0 |
31291 | 31291 | 2020-02-02 | Sacramento | 67 | 0 | 0 | 0 | 0 |
31292 | 31292 | 2020-02-02 | San Benito | 69 | 2 | 0 | 2 | 0 |
31293 | 31293 | 2020-02-02 | San Diego | 73 | 0 | 0 | 0 | 0 |
31294 | 31294 | 2020-02-02 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31295 | 31295 | 2020-02-02 | San Mateo | 81 | 0 | 0 | 0 | 0 |
31296 | 31296 | 2020-02-02 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31297 | 31297 | 2020-02-02 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
31298 | 31298 | 2020-02-02 | Shasta | 89 | 0 | 0 | 0 | 0 |
31299 | 31299 | 2020-02-02 | Solano | 95 | 0 | 0 | 0 | 0 |
31300 | 31300 | 2020-02-02 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31301 | 31301 | 2020-02-02 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
31302 | 31302 | 2020-02-02 | Ventura | 111 | 0 | 0 | 0 | 0 |
31303 | 31303 | 2020-02-02 | Yolo | 113 | 0 | 0 | 0 | 0 |
31278 | 31278 | 2020-02-03 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31279 | 31279 | 2020-02-03 | Orange | 59 | 1 | 0 | 0 | 0 |
31280 | 31280 | 2020-02-03 | San Benito | 69 | 2 | 0 | 0 | 0 |
31281 | 31281 | 2020-02-03 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31274 | 31274 | 2020-02-04 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31275 | 31275 | 2020-02-04 | Orange | 59 | 1 | 0 | 0 | 0 |
31276 | 31276 | 2020-02-04 | San Benito | 69 | 2 | 0 | 0 | 0 |
31277 | 31277 | 2020-02-04 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31270 | 31270 | 2020-02-05 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31271 | 31271 | 2020-02-05 | Orange | 59 | 1 | 0 | 0 | 0 |
31272 | 31272 | 2020-02-05 | San Benito | 69 | 2 | 0 | 0 | 0 |
31273 | 31273 | 2020-02-05 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31266 | 31266 | 2020-02-06 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31267 | 31267 | 2020-02-06 | Orange | 59 | 1 | 0 | 0 | 0 |
31268 | 31268 | 2020-02-06 | San Benito | 69 | 2 | 0 | 0 | 0 |
31269 | 31269 | 2020-02-06 | Santa Clara | 85 | 6 | 1 | 0 | 1 |
31262 | 31262 | 2020-02-07 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31263 | 31263 | 2020-02-07 | Orange | 59 | 1 | 0 | 0 | 0 |
31264 | 31264 | 2020-02-07 | San Benito | 69 | 2 | 0 | 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 );