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-05
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 |
---|---|---|---|---|---|---|---|---|
28131 | 28131 | 2020-05-05 | Alameda | 1 | 1828 | 103 | 36 | 2 |
28132 | 28132 | 2020-05-05 | Alpine | 3 | 1 | 0 | 0 | 0 |
28133 | 28133 | 2020-05-05 | Amador | 5 | 8 | 0 | 0 | 0 |
28134 | 28134 | 2020-05-05 | Butte | 7 | 19 | 0 | 3 | 0 |
28135 | 28135 | 2020-05-05 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28136 | 28136 | 2020-05-05 | Colusa | 11 | 3 | 0 | 0 | 0 |
28137 | 28137 | 2020-05-05 | Contra Costa | 13 | 961 | 29 | 20 | 1 |
28138 | 28138 | 2020-05-05 | Del Norte | 15 | 3 | 0 | 0 | 0 |
28139 | 28139 | 2020-05-05 | El Dorado | 17 | 53 | 0 | 0 | 0 |
28140 | 28140 | 2020-05-05 | Fresno | 19 | 1352 | 9 | 65 | 0 |
28141 | 28141 | 2020-05-05 | Glenn | 21 | 5 | 0 | 0 | 0 |
28142 | 28142 | 2020-05-05 | Humboldt | 23 | 54 | 0 | 0 | 0 |
28143 | 28143 | 2020-05-05 | Imperial | 25 | 400 | 9 | 21 | 0 |
28144 | 28144 | 2020-05-05 | Inyo | 27 | 19 | 1 | 0 | 0 |
28145 | 28145 | 2020-05-05 | Kern | 29 | 1045 | 11 | 29 | 3 |
28146 | 28146 | 2020-05-05 | Kings | 31 | 211 | 1 | 13 | 0 |
28147 | 28147 | 2020-05-05 | Lake | 33 | 8 | 0 | 1 | 0 |
28148 | 28148 | 2020-05-05 | Lassen | 35 | 0 | 0 | 0 | 0 |
28149 | 28149 | 2020-05-05 | Los Angeles | 37 | 27866 | 1315 | 1628 | 55 |
28150 | 28150 | 2020-05-05 | Madera | 39 | 54 | 2 | 0 | 0 |
28151 | 28151 | 2020-05-05 | Marin | 41 | 243 | 14 | 2 | 1 |
28152 | 28152 | 2020-05-05 | Mariposa | 43 | 14 | 0 | 0 | 0 |
28153 | 28153 | 2020-05-05 | Mendocino | 45 | 12 | 0 | 0 | 0 |
28154 | 28154 | 2020-05-05 | Merced | 47 | 146 | 3 | 0 | 0 |
28155 | 28155 | 2020-05-05 | Modoc | 49 | 0 | 0 | 0 | 0 |
28156 | 28156 | 2020-05-05 | Mono | 51 | 26 | 1 | 0 | 0 |
28157 | 28157 | 2020-05-05 | Monterey | 53 | 241 | 6 | 4 | 0 |
28158 | 28158 | 2020-05-05 | Napa | 55 | 75 | 2 | 1 | 0 |
28159 | 28159 | 2020-05-05 | Nevada | 57 | 41 | 1 | 0 | 0 |
28160 | 28160 | 2020-05-05 | Orange | 59 | 2865 | 61 | 66 | 4 |
28161 | 28161 | 2020-05-05 | Placer | 61 | 162 | 8 | 0 | 0 |
28162 | 28162 | 2020-05-05 | Plumas | 63 | 4 | 0 | 0 | 0 |
28163 | 28163 | 2020-05-05 | Riverside | 65 | 4454 | 184 | 100 | 3 |
28164 | 28164 | 2020-05-05 | Sacramento | 67 | 1133 | 47 | 6 | 0 |
28165 | 28165 | 2020-05-05 | San Benito | 69 | 53 | 2 | 1 | 0 |
28166 | 28166 | 2020-05-05 | San Bernardino | 71 | 2329 | 124 | 147 | 3 |
28167 | 28167 | 2020-05-05 | San Diego | 73 | 4160 | 150 | 140 | 6 |
28168 | 28168 | 2020-05-05 | San Francisco | 75 | 1728 | 31 | 104 | 2 |
28169 | 28169 | 2020-05-05 | San Joaquin | 77 | 577 | 26 | 4 | 0 |
28170 | 28170 | 2020-05-05 | San Luis Obispo | 79 | 204 | 1 | 2 | 0 |
28171 | 28171 | 2020-05-05 | San Mateo | 81 | 1315 | 56 | 34 | 5 |
28172 | 28172 | 2020-05-05 | Santa Barbara | 83 | 544 | 9 | 18 | 1 |
28173 | 28173 | 2020-05-05 | Santa Clara | 85 | 2296 | 126 | 13 | 2 |
28174 | 28174 | 2020-05-05 | Santa Cruz | 87 | 138 | 2 | 1 | 0 |
28175 | 28175 | 2020-05-05 | Shasta | 89 | 31 | 4 | 0 | 0 |
28176 | 28176 | 2020-05-05 | Sierra | 91 | 0 | 0 | 0 | 0 |
28177 | 28177 | 2020-05-05 | Siskiyou | 93 | 5 | 0 | 0 | 0 |
28178 | 28178 | 2020-05-05 | Solano | 95 | 325 | 6 | 5 | 0 |
28179 | 28179 | 2020-05-05 | Sonoma | 97 | 261 | 3 | 0 | 0 |
28180 | 28180 | 2020-05-05 | Stanislaus | 99 | 433 | 15 | 5 | 0 |
28181 | 28181 | 2020-05-05 | Sutter | 101 | 31 | 2 | 0 | 0 |
28182 | 28182 | 2020-05-05 | Tehama | 103 | 1 | 1 | 0 | 0 |
28183 | 28183 | 2020-05-05 | Trinity | 105 | 0 | 0 | 0 | 0 |
28184 | 28184 | 2020-05-05 | Tulare | 107 | 858 | 40 | 101 | 0 |
28185 | 28185 | 2020-05-05 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
28186 | 28186 | 2020-05-05 | Ventura | 111 | 595 | 19 | 18 | 0 |
28187 | 28187 | 2020-05-05 | Yolo | 113 | 172 | 19 | 1 | 0 |
28188 | 28188 | 2020-05-05 | 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 );