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-04
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_confirmed_cases, new_deaths
Link | rowid ▼ | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
28189 | 28189 | 2020-05-04 | Alameda | 1 | 1792 | 101 | 24 | 2 |
28190 | 28190 | 2020-05-04 | Alpine | 3 | 1 | 0 | 0 | 0 |
28191 | 28191 | 2020-05-04 | Amador | 5 | 8 | 0 | 0 | 0 |
28192 | 28192 | 2020-05-04 | Butte | 7 | 16 | 0 | -1 | 0 |
28193 | 28193 | 2020-05-04 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28194 | 28194 | 2020-05-04 | Colusa | 11 | 3 | 0 | 0 | 0 |
28195 | 28195 | 2020-05-04 | Contra Costa | 13 | 941 | 28 | 5 | 0 |
28196 | 28196 | 2020-05-04 | Del Norte | 15 | 3 | 0 | 0 | 0 |
28197 | 28197 | 2020-05-04 | El Dorado | 17 | 53 | 0 | 6 | 0 |
28198 | 28198 | 2020-05-04 | Fresno | 19 | 1287 | 9 | 89 | 1 |
28199 | 28199 | 2020-05-04 | Glenn | 21 | 5 | 0 | 0 | 0 |
28200 | 28200 | 2020-05-04 | Humboldt | 23 | 54 | 0 | 0 | 0 |
28201 | 28201 | 2020-05-04 | Imperial | 25 | 379 | 9 | 21 | 0 |
28202 | 28202 | 2020-05-04 | Inyo | 27 | 19 | 1 | 0 | 0 |
28203 | 28203 | 2020-05-04 | Kern | 29 | 1016 | 8 | 11 | 0 |
28204 | 28204 | 2020-05-04 | Kings | 31 | 198 | 1 | 26 | 0 |
28205 | 28205 | 2020-05-04 | Lake | 33 | 7 | 0 | 0 | 0 |
28206 | 28206 | 2020-05-04 | Lassen | 35 | 0 | 0 | 0 | 0 |
28207 | 28207 | 2020-05-04 | Los Angeles | 37 | 26238 | 1260 | 539 | 29 |
28208 | 28208 | 2020-05-04 | Madera | 39 | 54 | 2 | 3 | 0 |
28209 | 28209 | 2020-05-04 | Marin | 41 | 241 | 13 | 1 | 0 |
28210 | 28210 | 2020-05-04 | Mariposa | 43 | 14 | 0 | 1 | 0 |
28211 | 28211 | 2020-05-04 | Mendocino | 45 | 12 | 0 | 0 | 0 |
28212 | 28212 | 2020-05-04 | Merced | 47 | 146 | 3 | 4 | 0 |
28213 | 28213 | 2020-05-04 | Modoc | 49 | 0 | 0 | 0 | 0 |
28214 | 28214 | 2020-05-04 | Mono | 51 | 26 | 1 | 0 | 0 |
28215 | 28215 | 2020-05-04 | Monterey | 53 | 237 | 6 | 2 | 0 |
28216 | 28216 | 2020-05-04 | Napa | 55 | 74 | 2 | 4 | 0 |
28217 | 28217 | 2020-05-04 | Nevada | 57 | 41 | 1 | 0 | 0 |
28218 | 28218 | 2020-05-04 | Orange | 59 | 2799 | 57 | 84 | 5 |
28219 | 28219 | 2020-05-04 | Placer | 61 | 162 | 8 | 3 | 0 |
28220 | 28220 | 2020-05-04 | Plumas | 63 | 4 | 0 | 0 | 0 |
28221 | 28221 | 2020-05-04 | Riverside | 65 | 4354 | 181 | 174 | 20 |
28222 | 28222 | 2020-05-04 | Sacramento | 67 | 1127 | 47 | 10 | 5 |
28223 | 28223 | 2020-05-04 | San Benito | 69 | 52 | 2 | 1 | 0 |
28224 | 28224 | 2020-05-04 | San Bernardino | 71 | 2182 | 121 | 0 | 3 |
28225 | 28225 | 2020-05-04 | San Diego | 73 | 4020 | 144 | 93 | 5 |
28226 | 28226 | 2020-05-04 | San Francisco | 75 | 1624 | 29 | 22 | 0 |
28227 | 28227 | 2020-05-04 | San Joaquin | 77 | 573 | 26 | 4 | 1 |
28228 | 28228 | 2020-05-04 | San Luis Obispo | 79 | 202 | 1 | 1 | 0 |
28229 | 28229 | 2020-05-04 | San Mateo | 81 | 1281 | 51 | 48 | 0 |
28230 | 28230 | 2020-05-04 | Santa Barbara | 83 | 526 | 8 | 12 | 0 |
28231 | 28231 | 2020-05-04 | Santa Clara | 85 | 2283 | 124 | 19 | 4 |
28232 | 28232 | 2020-05-04 | Santa Cruz | 87 | 137 | 2 | 0 | 0 |
28233 | 28233 | 2020-05-04 | Shasta | 89 | 31 | 4 | 0 | 0 |
28234 | 28234 | 2020-05-04 | Sierra | 91 | 0 | 0 | 0 | 0 |
28235 | 28235 | 2020-05-04 | Siskiyou | 93 | 5 | 0 | 0 | 0 |
28236 | 28236 | 2020-05-04 | Solano | 95 | 320 | 6 | 54 | 1 |
28237 | 28237 | 2020-05-04 | Sonoma | 97 | 261 | 3 | 4 | 0 |
28238 | 28238 | 2020-05-04 | Stanislaus | 99 | 428 | 15 | 17 | 1 |
28239 | 28239 | 2020-05-04 | Sutter | 101 | 31 | 2 | 0 | 0 |
28240 | 28240 | 2020-05-04 | Tehama | 103 | 1 | 1 | 0 | 0 |
28241 | 28241 | 2020-05-04 | Trinity | 105 | 0 | 0 | 0 | 0 |
28242 | 28242 | 2020-05-04 | Tulare | 107 | 757 | 40 | 14 | 0 |
28243 | 28243 | 2020-05-04 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
28244 | 28244 | 2020-05-04 | Ventura | 111 | 577 | 19 | 11 | 0 |
28245 | 28245 | 2020-05-04 | Yolo | 113 | 171 | 19 | 0 | 2 |
28246 | 28246 | 2020-05-04 | 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 );