latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
52 rows where "date" is on date 2020-04-03 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases
fips >30
county >30
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
29862 | 29862 | 2020-04-03 | Alameda | 1 | 509 | 47 | 51 | 8 |
29863 | 29863 | 2020-04-03 | Alpine | 3 | 1 | 0 | 0 | 0 |
29864 | 29864 | 2020-04-03 | Amador | 5 | 3 | 0 | 0 | 0 |
29865 | 29865 | 2020-04-03 | Butte | 7 | 8 | 0 | 1 | 0 |
29866 | 29866 | 2020-04-03 | Calaveras | 9 | 4 | 0 | 1 | 0 |
29867 | 29867 | 2020-04-03 | Colusa | 11 | 2 | 0 | 1 | 0 |
29868 | 29868 | 2020-04-03 | Contra Costa | 13 | 324 | 5 | 30 | 2 |
29869 | 29869 | 2020-04-03 | Del Norte | 15 | 1 | 0 | 0 | 0 |
29870 | 29870 | 2020-04-03 | El Dorado | 17 | 22 | 0 | 3 | 0 |
29871 | 29871 | 2020-04-03 | Fresno | 19 | 285 | 1 | 14 | 1 |
29872 | 29872 | 2020-04-03 | Glenn | 21 | 2 | 0 | 0 | 0 |
29873 | 29873 | 2020-04-03 | Humboldt | 23 | 40 | 0 | 3 | 0 |
29874 | 29874 | 2020-04-03 | Imperial | 25 | 55 | 1 | 5 | 0 |
29875 | 29875 | 2020-04-03 | Inyo | 27 | 10 | 0 | 0 | 0 |
29876 | 29876 | 2020-04-03 | Kern | 29 | 194 | 2 | 39 | 1 |
29877 | 29877 | 2020-04-03 | Kings | 31 | 5 | 0 | 0 | 0 |
29878 | 29878 | 2020-04-03 | Los Angeles | 37 | 4605 | 93 | 534 | 13 |
29879 | 29879 | 2020-04-03 | Madera | 39 | 28 | 1 | 0 | 0 |
29880 | 29880 | 2020-04-03 | Marin | 41 | 131 | 6 | 13 | 0 |
29881 | 29881 | 2020-04-03 | Mendocino | 45 | 4 | 0 | 0 | 0 |
29882 | 29882 | 2020-04-03 | Merced | 47 | 19 | 0 | 3 | 0 |
29883 | 29883 | 2020-04-03 | Mono | 51 | 19 | 1 | 1 | 0 |
29884 | 29884 | 2020-04-03 | Monterey | 53 | 57 | 2 | 4 | 0 |
29885 | 29885 | 2020-04-03 | Napa | 55 | 20 | 2 | 2 | 1 |
29886 | 29886 | 2020-04-03 | Nevada | 57 | 31 | 1 | 1 | 1 |
29887 | 29887 | 2020-04-03 | Orange | 59 | 703 | 13 | 55 | 0 |
29888 | 29888 | 2020-04-03 | Placer | 61 | 97 | 2 | 7 | 0 |
29889 | 29889 | 2020-04-03 | Plumas | 63 | 2 | 0 | 0 | 0 |
29890 | 29890 | 2020-04-03 | Riverside | 65 | 638 | 15 | 145 | 1 |
29891 | 29891 | 2020-04-03 | Sacramento | 67 | 390 | 10 | 49 | 1 |
29892 | 29892 | 2020-04-03 | San Benito | 69 | 23 | 2 | 0 | 1 |
29893 | 29893 | 2020-04-03 | San Bernardino | 71 | 353 | 14 | 49 | 1 |
29894 | 29894 | 2020-04-03 | San Diego | 73 | 1112 | 17 | 146 | 1 |
29895 | 29895 | 2020-04-03 | San Francisco | 75 | 497 | 7 | 47 | 0 |
29896 | 29896 | 2020-04-03 | San Joaquin | 77 | 180 | 11 | 16 | 1 |
29897 | 29897 | 2020-04-03 | San Luis Obispo | 79 | 93 | 0 | 4 | 0 |
29898 | 29898 | 2020-04-03 | San Mateo | 81 | 486 | 13 | 33 | 3 |
29899 | 29899 | 2020-04-03 | Santa Barbara | 83 | 152 | 1 | 13 | 0 |
29900 | 29900 | 2020-04-03 | Santa Clara | 85 | 1293 | 43 | 43 | 1 |
29901 | 29901 | 2020-04-03 | Santa Cruz | 87 | 59 | 1 | 2 | 0 |
29902 | 29902 | 2020-04-03 | Shasta | 89 | 12 | 2 | 1 | 1 |
29903 | 29903 | 2020-04-03 | Siskiyou | 93 | 3 | 0 | 0 | 0 |
29904 | 29904 | 2020-04-03 | Solano | 95 | 73 | 1 | 12 | 0 |
29905 | 29905 | 2020-04-03 | Sonoma | 97 | 105 | 1 | 10 | 0 |
29906 | 29906 | 2020-04-03 | Stanislaus | 99 | 58 | 0 | 7 | 0 |
29907 | 29907 | 2020-04-03 | Sutter | 101 | 16 | 1 | 2 | 0 |
29908 | 29908 | 2020-04-03 | Tehama | 103 | 1 | 0 | 0 | 0 |
29909 | 29909 | 2020-04-03 | Tulare | 107 | 81 | 3 | 7 | 1 |
29910 | 29910 | 2020-04-03 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
29911 | 29911 | 2020-04-03 | Ventura | 111 | 189 | 6 | 12 | 0 |
29912 | 29912 | 2020-04-03 | Yolo | 113 | 33 | 1 | 0 | 0 |
29913 | 29913 | 2020-04-03 | Yuba | 115 | 9 | 0 | 1 | 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 );