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-22
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 |
---|---|---|---|---|---|---|---|---|
27145 | 27145 | 2020-05-22 | Alameda | 1 | 2722 | 120 | 83 | 0 |
27146 | 27146 | 2020-05-22 | Alpine | 3 | 1 | 0 | 0 | 0 |
27147 | 27147 | 2020-05-22 | Amador | 5 | 10 | 0 | 0 | 0 |
27148 | 27148 | 2020-05-22 | Butte | 7 | 34 | 0 | 3 | 0 |
27149 | 27149 | 2020-05-22 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27150 | 27150 | 2020-05-22 | Colusa | 11 | 5 | 0 | 1 | 0 |
27151 | 27151 | 2020-05-22 | Contra Costa | 13 | 1245 | 36 | 25 | 0 |
27152 | 27152 | 2020-05-22 | Del Norte | 15 | 23 | 0 | 3 | 0 |
27153 | 27153 | 2020-05-22 | El Dorado | 17 | 74 | 0 | 7 | 0 |
27154 | 27154 | 2020-05-22 | Fresno | 19 | 2532 | 22 | 88 | 0 |
27155 | 27155 | 2020-05-22 | Glenn | 21 | 12 | 0 | 0 | 0 |
27156 | 27156 | 2020-05-22 | Humboldt | 23 | 91 | 2 | 3 | 0 |
27157 | 27157 | 2020-05-22 | Imperial | 25 | 1145 | 23 | 69 | 2 |
27158 | 27158 | 2020-05-22 | Inyo | 27 | 19 | 1 | 0 | 0 |
27159 | 27159 | 2020-05-22 | Kern | 29 | 1695 | 27 | 51 | 2 |
27160 | 27160 | 2020-05-22 | Kings | 31 | 506 | 2 | 18 | 0 |
27161 | 27161 | 2020-05-22 | Lake | 33 | 12 | 0 | 0 | 0 |
27162 | 27162 | 2020-05-22 | Lassen | 35 | 2 | 0 | 2 | 0 |
27163 | 27163 | 2020-05-22 | Los Angeles | 37 | 43085 | 2051 | 947 | 30 |
27164 | 27164 | 2020-05-22 | Madera | 39 | 83 | 2 | 0 | 0 |
27165 | 27165 | 2020-05-22 | Marin | 41 | 369 | 14 | 17 | 0 |
27166 | 27166 | 2020-05-22 | Mariposa | 43 | 15 | 1 | 0 | 0 |
27167 | 27167 | 2020-05-22 | Mendocino | 45 | 21 | 0 | 6 | 0 |
27168 | 27168 | 2020-05-22 | Merced | 47 | 251 | 6 | 17 | 0 |
27169 | 27169 | 2020-05-22 | Modoc | 49 | 0 | 0 | 0 | 0 |
27170 | 27170 | 2020-05-22 | Mono | 51 | 34 | 1 | 0 | 0 |
27171 | 27171 | 2020-05-22 | Monterey | 53 | 371 | 8 | 9 | 0 |
27172 | 27172 | 2020-05-22 | Napa | 55 | 96 | 3 | 1 | 0 |
27173 | 27173 | 2020-05-22 | Nevada | 57 | 41 | 1 | 0 | 0 |
27174 | 27174 | 2020-05-22 | Orange | 59 | 4941 | 118 | 100 | 6 |
27175 | 27175 | 2020-05-22 | Placer | 61 | 184 | 9 | 7 | 1 |
27176 | 27176 | 2020-05-22 | Plumas | 63 | 4 | 0 | 0 | 0 |
27177 | 27177 | 2020-05-22 | Riverside | 65 | 6464 | 290 | 121 | 6 |
27178 | 27178 | 2020-05-22 | Sacramento | 67 | 1272 | 56 | 6 | 0 |
27179 | 27179 | 2020-05-22 | San Benito | 69 | 69 | 2 | 3 | 0 |
27180 | 27180 | 2020-05-22 | San Bernardino | 71 | 4146 | 183 | 162 | 4 |
27181 | 27181 | 2020-05-22 | San Diego | 73 | 6434 | 242 | 119 | 1 |
27182 | 27182 | 2020-05-22 | San Francisco | 75 | 2320 | 40 | 122 | 3 |
27183 | 27183 | 2020-05-22 | San Joaquin | 77 | 752 | 33 | 19 | 0 |
27184 | 27184 | 2020-05-22 | San Luis Obispo | 79 | 253 | 1 | 2 | 0 |
27185 | 27185 | 2020-05-22 | San Mateo | 81 | 1783 | 76 | 45 | 1 |
27186 | 27186 | 2020-05-22 | Santa Barbara | 83 | 1551 | 12 | 11 | 1 |
27187 | 27187 | 2020-05-22 | Santa Clara | 85 | 2656 | 137 | 26 | 1 |
27188 | 27188 | 2020-05-22 | Santa Cruz | 87 | 186 | 2 | 12 | 0 |
27189 | 27189 | 2020-05-22 | Shasta | 89 | 36 | 4 | 2 | 0 |
27190 | 27190 | 2020-05-22 | Sierra | 91 | 1 | 0 | 1 | 0 |
27191 | 27191 | 2020-05-22 | Siskiyou | 93 | 6 | 0 | 0 | 0 |
27192 | 27192 | 2020-05-22 | Solano | 95 | 455 | 20 | 6 | 1 |
27193 | 27193 | 2020-05-22 | Sonoma | 97 | 467 | 4 | 23 | 0 |
27194 | 27194 | 2020-05-22 | Stanislaus | 99 | 621 | 28 | 10 | 0 |
27195 | 27195 | 2020-05-22 | Sutter | 101 | 40 | 2 | 0 | 0 |
27196 | 27196 | 2020-05-22 | Tehama | 103 | 3 | 1 | 1 | 0 |
27197 | 27197 | 2020-05-22 | Trinity | 105 | 1 | 0 | 0 | 0 |
27198 | 27198 | 2020-05-22 | Tulare | 107 | 1641 | 75 | 38 | 1 |
27199 | 27199 | 2020-05-22 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
27200 | 27200 | 2020-05-22 | Ventura | 111 | 912 | 30 | 29 | 1 |
27201 | 27201 | 2020-05-22 | Yolo | 113 | 188 | 22 | 2 | 0 |
27202 | 27202 | 2020-05-22 | 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 );