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-10
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths, date (date)
Link | rowid ▼ | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
27841 | 27841 | 2020-05-10 | Alameda | 1 | 2072 | 106 | 33 | 1 |
27842 | 27842 | 2020-05-10 | Alpine | 3 | 1 | 0 | 0 | 0 |
27843 | 27843 | 2020-05-10 | Amador | 5 | 8 | 0 | 0 | 0 |
27844 | 27844 | 2020-05-10 | Butte | 7 | 18 | 0 | 0 | 0 |
27845 | 27845 | 2020-05-10 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27846 | 27846 | 2020-05-10 | Colusa | 11 | 3 | 0 | 0 | 0 |
27847 | 27847 | 2020-05-10 | Contra Costa | 13 | 1042 | 31 | 11 | 0 |
27848 | 27848 | 2020-05-10 | Del Norte | 15 | 3 | 0 | 0 | 0 |
27849 | 27849 | 2020-05-10 | El Dorado | 17 | 54 | 0 | 0 | 0 |
27850 | 27850 | 2020-05-10 | Fresno | 19 | 1618 | 9 | 36 | 0 |
27851 | 27851 | 2020-05-10 | Glenn | 21 | 6 | 0 | 0 | 0 |
27852 | 27852 | 2020-05-10 | Humboldt | 23 | 57 | 0 | 0 | 0 |
27853 | 27853 | 2020-05-10 | Imperial | 25 | 512 | 12 | 0 | 0 |
27854 | 27854 | 2020-05-10 | Inyo | 27 | 19 | 1 | 0 | 0 |
27855 | 27855 | 2020-05-10 | Kern | 29 | 1254 | 15 | 26 | 0 |
27856 | 27856 | 2020-05-10 | Kings | 31 | 287 | 1 | 12 | 0 |
27857 | 27857 | 2020-05-10 | Lake | 33 | 8 | 0 | 0 | 0 |
27858 | 27858 | 2020-05-10 | Lassen | 35 | 0 | 0 | 0 | 0 |
27859 | 27859 | 2020-05-10 | Los Angeles | 37 | 31703 | 1531 | 462 | 16 |
27860 | 27860 | 2020-05-10 | Madera | 39 | 67 | 2 | 0 | 0 |
27861 | 27861 | 2020-05-10 | Marin | 41 | 261 | 14 | 2 | 0 |
27862 | 27862 | 2020-05-10 | Mariposa | 43 | 15 | 0 | 0 | 0 |
27863 | 27863 | 2020-05-10 | Mendocino | 45 | 12 | 0 | 0 | 0 |
27864 | 27864 | 2020-05-10 | Merced | 47 | 163 | 3 | 0 | 0 |
27865 | 27865 | 2020-05-10 | Modoc | 49 | 0 | 0 | 0 | 0 |
27866 | 27866 | 2020-05-10 | Mono | 51 | 29 | 1 | 0 | 0 |
27867 | 27867 | 2020-05-10 | Monterey | 53 | 279 | 6 | 2 | 0 |
27868 | 27868 | 2020-05-10 | Napa | 55 | 79 | 2 | 0 | 0 |
27869 | 27869 | 2020-05-10 | Nevada | 57 | 41 | 1 | 0 | 0 |
27870 | 27870 | 2020-05-10 | Orange | 59 | 3502 | 76 | 122 | 2 |
27871 | 27871 | 2020-05-10 | Placer | 61 | 169 | 8 | 1 | 0 |
27872 | 27872 | 2020-05-10 | Plumas | 63 | 4 | 0 | 0 | 0 |
27873 | 27873 | 2020-05-10 | Riverside | 65 | 5039 | 205 | 47 | 1 |
27874 | 27874 | 2020-05-10 | Sacramento | 67 | 1167 | 50 | 2 | 0 |
27875 | 27875 | 2020-05-10 | San Benito | 69 | 55 | 2 | 0 | 0 |
27876 | 27876 | 2020-05-10 | San Bernardino | 71 | 2964 | 147 | 62 | 4 |
27877 | 27877 | 2020-05-10 | San Diego | 73 | 4926 | 175 | 150 | 0 |
27878 | 27878 | 2020-05-10 | San Francisco | 75 | 1943 | 34 | 52 | 1 |
27879 | 27879 | 2020-05-10 | San Joaquin | 77 | 613 | 29 | 9 | 1 |
27880 | 27880 | 2020-05-10 | San Luis Obispo | 79 | 220 | 1 | 6 | 0 |
27881 | 27881 | 2020-05-10 | San Mateo | 81 | 1425 | 56 | 0 | 0 |
27882 | 27882 | 2020-05-10 | Santa Barbara | 83 | 1308 | 11 | 58 | 0 |
27883 | 27883 | 2020-05-10 | Santa Clara | 85 | 2374 | 130 | 3 | 2 |
27884 | 27884 | 2020-05-10 | Santa Cruz | 87 | 141 | 2 | 0 | 0 |
27885 | 27885 | 2020-05-10 | Shasta | 89 | 31 | 4 | 0 | 0 |
27886 | 27886 | 2020-05-10 | Sierra | 91 | 0 | 0 | 0 | 0 |
27887 | 27887 | 2020-05-10 | Siskiyou | 93 | 5 | 0 | 0 | 0 |
27888 | 27888 | 2020-05-10 | Solano | 95 | 351 | 7 | 0 | 0 |
27889 | 27889 | 2020-05-10 | Sonoma | 97 | 309 | 3 | 0 | 0 |
27890 | 27890 | 2020-05-10 | Stanislaus | 99 | 501 | 21 | 5 | 1 |
27891 | 27891 | 2020-05-10 | Sutter | 101 | 33 | 2 | 0 | 0 |
27892 | 27892 | 2020-05-10 | Tehama | 103 | 1 | 1 | 0 | 0 |
27893 | 27893 | 2020-05-10 | Trinity | 105 | 1 | 0 | 0 | 0 |
27894 | 27894 | 2020-05-10 | Tulare | 107 | 1140 | 48 | 61 | 2 |
27895 | 27895 | 2020-05-10 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
27896 | 27896 | 2020-05-10 | Ventura | 111 | 666 | 19 | 0 | 0 |
27897 | 27897 | 2020-05-10 | Yolo | 113 | 173 | 20 | 1 | 0 |
27898 | 27898 | 2020-05-10 | Yuba | 115 | 20 | 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 );