latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
58 rows where "date" is on date 2020-05-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_confirmed_cases
fips >30
county >30
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
27087 | 27087 | 2020-05-23 | Alameda | 1 | 2796 | 121 | 74 | 1 |
27088 | 27088 | 2020-05-23 | Alpine | 3 | 1 | 0 | 0 | 0 |
27089 | 27089 | 2020-05-23 | Amador | 5 | 10 | 0 | 0 | 0 |
27090 | 27090 | 2020-05-23 | Butte | 7 | 34 | 0 | 0 | 0 |
27091 | 27091 | 2020-05-23 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27092 | 27092 | 2020-05-23 | Colusa | 11 | 5 | 0 | 0 | 0 |
27093 | 27093 | 2020-05-23 | Contra Costa | 13 | 1287 | 36 | 42 | 0 |
27094 | 27094 | 2020-05-23 | Del Norte | 15 | 23 | 0 | 0 | 0 |
27095 | 27095 | 2020-05-23 | El Dorado | 17 | 74 | 0 | 0 | 0 |
27096 | 27096 | 2020-05-23 | Fresno | 19 | 2589 | 22 | 57 | 0 |
27097 | 27097 | 2020-05-23 | Glenn | 21 | 12 | 0 | 0 | 0 |
27098 | 27098 | 2020-05-23 | Humboldt | 23 | 93 | 2 | 2 | 0 |
27099 | 27099 | 2020-05-23 | Imperial | 25 | 1145 | 23 | 0 | 0 |
27100 | 27100 | 2020-05-23 | Inyo | 27 | 19 | 1 | 0 | 0 |
27101 | 27101 | 2020-05-23 | Kern | 29 | 1757 | 29 | 62 | 2 |
27102 | 27102 | 2020-05-23 | Kings | 31 | 517 | 2 | 11 | 0 |
27103 | 27103 | 2020-05-23 | Lake | 33 | 12 | 0 | 0 | 0 |
27104 | 27104 | 2020-05-23 | Lassen | 35 | 2 | 0 | 0 | 0 |
27105 | 27105 | 2020-05-23 | Los Angeles | 37 | 44121 | 2092 | 1036 | 41 |
27106 | 27106 | 2020-05-23 | Madera | 39 | 84 | 2 | 1 | 0 |
27107 | 27107 | 2020-05-23 | Marin | 41 | 388 | 14 | 19 | 0 |
27108 | 27108 | 2020-05-23 | Mariposa | 43 | 15 | 1 | 0 | 0 |
27109 | 27109 | 2020-05-23 | Mendocino | 45 | 21 | 0 | 0 | 0 |
27110 | 27110 | 2020-05-23 | Merced | 47 | 251 | 6 | 0 | 0 |
27111 | 27111 | 2020-05-23 | Modoc | 49 | 0 | 0 | 0 | 0 |
27112 | 27112 | 2020-05-23 | Mono | 51 | 34 | 1 | 0 | 0 |
27113 | 27113 | 2020-05-23 | Monterey | 53 | 395 | 8 | 24 | 0 |
27114 | 27114 | 2020-05-23 | Napa | 55 | 101 | 3 | 5 | 0 |
27115 | 27115 | 2020-05-23 | Nevada | 57 | 41 | 1 | 0 | 0 |
27116 | 27116 | 2020-05-23 | Orange | 59 | 5157 | 130 | 216 | 12 |
27117 | 27117 | 2020-05-23 | Placer | 61 | 185 | 9 | 1 | 0 |
27118 | 27118 | 2020-05-23 | Plumas | 63 | 4 | 0 | 0 | 0 |
27119 | 27119 | 2020-05-23 | Riverside | 65 | 6464 | 290 | 0 | 0 |
27120 | 27120 | 2020-05-23 | Sacramento | 67 | 1289 | 56 | 17 | 0 |
27121 | 27121 | 2020-05-23 | San Benito | 69 | 69 | 2 | 0 | 0 |
27122 | 27122 | 2020-05-23 | San Bernardino | 71 | 4315 | 190 | 169 | 7 |
27123 | 27123 | 2020-05-23 | San Diego | 73 | 6559 | 249 | 125 | 7 |
27124 | 27124 | 2020-05-23 | San Francisco | 75 | 2350 | 40 | 30 | 0 |
27125 | 27125 | 2020-05-23 | San Joaquin | 77 | 772 | 33 | 20 | 0 |
27126 | 27126 | 2020-05-23 | San Luis Obispo | 79 | 258 | 1 | 5 | 0 |
27127 | 27127 | 2020-05-23 | San Mateo | 81 | 1833 | 76 | 50 | 0 |
27128 | 27128 | 2020-05-23 | Santa Barbara | 83 | 1551 | 12 | 0 | 0 |
27129 | 27129 | 2020-05-23 | Santa Clara | 85 | 2673 | 137 | 17 | 0 |
27130 | 27130 | 2020-05-23 | Santa Cruz | 87 | 192 | 2 | 6 | 0 |
27131 | 27131 | 2020-05-23 | Shasta | 89 | 36 | 4 | 0 | 0 |
27132 | 27132 | 2020-05-23 | Sierra | 91 | 1 | 0 | 0 | 0 |
27133 | 27133 | 2020-05-23 | Siskiyou | 93 | 6 | 0 | 0 | 0 |
27134 | 27134 | 2020-05-23 | Solano | 95 | 455 | 20 | 0 | 0 |
27135 | 27135 | 2020-05-23 | Sonoma | 97 | 482 | 4 | 15 | 0 |
27136 | 27136 | 2020-05-23 | Stanislaus | 99 | 629 | 28 | 8 | 0 |
27137 | 27137 | 2020-05-23 | Sutter | 101 | 40 | 2 | 0 | 0 |
27138 | 27138 | 2020-05-23 | Tehama | 103 | 3 | 1 | 0 | 0 |
27139 | 27139 | 2020-05-23 | Trinity | 105 | 1 | 0 | 0 | 0 |
27140 | 27140 | 2020-05-23 | Tulare | 107 | 1641 | 75 | 0 | 0 |
27141 | 27141 | 2020-05-23 | Tuolumne | 109 | 3 | 0 | 1 | 0 |
27142 | 27142 | 2020-05-23 | Ventura | 111 | 912 | 30 | 0 | 0 |
27143 | 27143 | 2020-05-23 | Yolo | 113 | 190 | 22 | 2 | 0 |
27144 | 27144 | 2020-05-23 | 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 );