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-17
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 |
---|---|---|---|---|---|---|---|---|
27435 | 27435 | 2020-05-17 | Alameda | 1 | 2416 | 114 | 55 | 0 |
27436 | 27436 | 2020-05-17 | Alpine | 3 | 1 | 0 | 0 | 0 |
27437 | 27437 | 2020-05-17 | Amador | 5 | 9 | 0 | 0 | 0 |
27438 | 27438 | 2020-05-17 | Butte | 7 | 23 | 0 | 1 | 0 |
27439 | 27439 | 2020-05-17 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27440 | 27440 | 2020-05-17 | Colusa | 11 | 3 | 0 | 0 | 0 |
27441 | 27441 | 2020-05-17 | Contra Costa | 13 | 1133 | 33 | 21 | 0 |
27442 | 27442 | 2020-05-17 | Del Norte | 15 | 8 | 0 | 3 | 0 |
27443 | 27443 | 2020-05-17 | El Dorado | 17 | 64 | 0 | 0 | 0 |
27444 | 27444 | 2020-05-17 | Fresno | 19 | 2107 | 16 | 54 | 0 |
27445 | 27445 | 2020-05-17 | Glenn | 21 | 9 | 0 | 0 | 0 |
27446 | 27446 | 2020-05-17 | Humboldt | 23 | 77 | 0 | 0 | 0 |
27447 | 27447 | 2020-05-17 | Imperial | 25 | 786 | 15 | 0 | 0 |
27448 | 27448 | 2020-05-17 | Inyo | 27 | 19 | 1 | 0 | 0 |
27449 | 27449 | 2020-05-17 | Kern | 29 | 1515 | 25 | 42 | 0 |
27450 | 27450 | 2020-05-17 | Kings | 31 | 399 | 2 | 7 | 0 |
27451 | 27451 | 2020-05-17 | Lake | 33 | 8 | 0 | 0 | 0 |
27452 | 27452 | 2020-05-17 | Lassen | 35 | 0 | 0 | 0 | 0 |
27453 | 27453 | 2020-05-17 | Los Angeles | 37 | 38011 | 1821 | 637 | 28 |
27454 | 27454 | 2020-05-17 | Madera | 39 | 71 | 2 | 1 | 0 |
27455 | 27455 | 2020-05-17 | Marin | 41 | 317 | 14 | 18 | 0 |
27456 | 27456 | 2020-05-17 | Mariposa | 43 | 15 | 1 | 0 | 0 |
27457 | 27457 | 2020-05-17 | Mendocino | 45 | 14 | 0 | 1 | 0 |
27458 | 27458 | 2020-05-17 | Merced | 47 | 200 | 6 | 0 | 0 |
27459 | 27459 | 2020-05-17 | Modoc | 49 | 0 | 0 | 0 | 0 |
27460 | 27460 | 2020-05-17 | Mono | 51 | 34 | 1 | 1 | 0 |
27461 | 27461 | 2020-05-17 | Monterey | 53 | 341 | 8 | 13 | 0 |
27462 | 27462 | 2020-05-17 | Napa | 55 | 90 | 3 | 0 | 0 |
27463 | 27463 | 2020-05-17 | Nevada | 57 | 41 | 1 | 0 | 0 |
27464 | 27464 | 2020-05-17 | Orange | 59 | 4376 | 88 | 154 | 2 |
27465 | 27465 | 2020-05-17 | Placer | 61 | 175 | 8 | 1 | 0 |
27466 | 27466 | 2020-05-17 | Plumas | 63 | 4 | 0 | 0 | 0 |
27467 | 27467 | 2020-05-17 | Riverside | 65 | 5618 | 242 | 0 | 0 |
27468 | 27468 | 2020-05-17 | Sacramento | 67 | 1237 | 55 | 15 | 1 |
27469 | 27469 | 2020-05-17 | San Benito | 69 | 61 | 2 | 0 | 0 |
27470 | 27470 | 2020-05-17 | San Bernardino | 71 | 3511 | 168 | 48 | 2 |
27471 | 27471 | 2020-05-17 | San Diego | 73 | 5836 | 209 | 174 | 0 |
27472 | 27472 | 2020-05-17 | San Francisco | 75 | 2091 | 36 | 37 | 0 |
27473 | 27473 | 2020-05-17 | San Joaquin | 77 | 687 | 32 | 19 | 1 |
27474 | 27474 | 2020-05-17 | San Luis Obispo | 79 | 243 | 1 | 0 | 0 |
27475 | 27475 | 2020-05-17 | San Mateo | 81 | 1602 | 66 | 0 | 0 |
27476 | 27476 | 2020-05-17 | Santa Barbara | 83 | 1474 | 11 | 56 | 0 |
27477 | 27477 | 2020-05-17 | Santa Clara | 85 | 2490 | 136 | 7 | 1 |
27478 | 27478 | 2020-05-17 | Santa Cruz | 87 | 159 | 2 | 2 | 0 |
27479 | 27479 | 2020-05-17 | Shasta | 89 | 34 | 4 | 0 | 0 |
27480 | 27480 | 2020-05-17 | Sierra | 91 | 0 | 0 | 0 | 0 |
27481 | 27481 | 2020-05-17 | Siskiyou | 93 | 5 | 0 | 0 | 0 |
27482 | 27482 | 2020-05-17 | Solano | 95 | 410 | 16 | 0 | 0 |
27483 | 27483 | 2020-05-17 | Sonoma | 97 | 373 | 4 | 0 | 0 |
27484 | 27484 | 2020-05-17 | Stanislaus | 99 | 571 | 24 | 12 | 0 |
27485 | 27485 | 2020-05-17 | Sutter | 101 | 38 | 2 | 0 | 0 |
27486 | 27486 | 2020-05-17 | Tehama | 103 | 2 | 1 | 0 | 0 |
27487 | 27487 | 2020-05-17 | Trinity | 105 | 1 | 0 | 0 | 0 |
27488 | 27488 | 2020-05-17 | Tulare | 107 | 1430 | 67 | 4 | 0 |
27489 | 27489 | 2020-05-17 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
27490 | 27490 | 2020-05-17 | Ventura | 111 | 764 | 25 | 0 | 0 |
27491 | 27491 | 2020-05-17 | Yolo | 113 | 184 | 22 | 1 | 0 |
27492 | 27492 | 2020-05-17 | Yuba | 115 | 25 | 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 );