ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2020-12-12 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
820016 | 820016 | 2020-12-12 | Alameda | California | 6001 | 36302 | 542 |
820017 | 820017 | 2020-12-12 | Alpine | California | 6003 | 63 | 0 |
820018 | 820018 | 2020-12-12 | Amador | California | 6005 | 1212 | 19 |
820019 | 820019 | 2020-12-12 | Butte | California | 6007 | 4941 | 67 |
820020 | 820020 | 2020-12-12 | Calaveras | California | 6009 | 697 | 22 |
820021 | 820021 | 2020-12-12 | Colusa | California | 6011 | 923 | 8 |
820022 | 820022 | 2020-12-12 | Contra Costa | California | 6013 | 29599 | 279 |
820023 | 820023 | 2020-12-12 | Del Norte | California | 6015 | 505 | 1 |
820024 | 820024 | 2020-12-12 | El Dorado | California | 6017 | 3669 | 8 |
820025 | 820025 | 2020-12-12 | Fresno | California | 6019 | 43071 | 542 |
820026 | 820026 | 2020-12-12 | Glenn | California | 6021 | 1135 | 12 |
820027 | 820027 | 2020-12-12 | Humboldt | California | 6023 | 1231 | 10 |
820028 | 820028 | 2020-12-12 | Imperial | California | 6025 | 18599 | 372 |
820029 | 820029 | 2020-12-12 | Inyo | California | 6027 | 372 | 17 |
820030 | 820030 | 2020-12-12 | Kern | California | 6029 | 49939 | 467 |
820031 | 820031 | 2020-12-12 | Kings | California | 6031 | 13198 | 98 |
820032 | 820032 | 2020-12-12 | Lake | California | 6033 | 1205 | 22 |
820033 | 820033 | 2020-12-12 | Lassen | California | 6035 | 3127 | 5 |
820034 | 820034 | 2020-12-12 | Los Angeles | California | 6037 | 513029 | 8269 |
820035 | 820035 | 2020-12-12 | Madera | California | 6039 | 7648 | 107 |
820036 | 820036 | 2020-12-12 | Marin | California | 6041 | 8411 | 132 |
820037 | 820037 | 2020-12-12 | Mariposa | California | 6043 | 174 | 4 |
820038 | 820038 | 2020-12-12 | Mendocino | California | 6045 | 1953 | 24 |
820039 | 820039 | 2020-12-12 | Merced | California | 6047 | 14483 | 207 |
820040 | 820040 | 2020-12-12 | Modoc | California | 6049 | 225 | 0 |
820041 | 820041 | 2020-12-12 | Mono | California | 6051 | 631 | 3 |
820042 | 820042 | 2020-12-12 | Monterey | California | 6053 | 18421 | 154 |
820043 | 820043 | 2020-12-12 | Napa | California | 6055 | 4055 | 23 |
820044 | 820044 | 2020-12-12 | Nevada | California | 6057 | 1962 | 21 |
820045 | 820045 | 2020-12-12 | Orange | California | 6059 | 101696 | 1680 |
820046 | 820046 | 2020-12-12 | Placer | California | 6061 | 8904 | 92 |
820047 | 820047 | 2020-12-12 | Plumas | California | 6063 | 286 | 0 |
820048 | 820048 | 2020-12-12 | Riverside | California | 6065 | 115329 | 1573 |
820049 | 820049 | 2020-12-12 | Sacramento | California | 6067 | 47472 | 670 |
820050 | 820050 | 2020-12-12 | San Benito | California | 6069 | 2401 | 19 |
820051 | 820051 | 2020-12-12 | San Bernardino | California | 6071 | 124264 | 1215 |
820052 | 820052 | 2020-12-12 | San Diego | California | 6073 | 102531 | 1137 |
820053 | 820053 | 2020-12-12 | San Francisco | California | 6075 | 18249 | 167 |
820054 | 820054 | 2020-12-12 | San Joaquin | California | 6077 | 32044 | 534 |
820055 | 820055 | 2020-12-12 | San Luis Obispo | California | 6079 | 7452 | 46 |
820056 | 820056 | 2020-12-12 | San Mateo | California | 6081 | 17724 | 179 |
820057 | 820057 | 2020-12-12 | Santa Barbara | California | 6083 | 13056 | 140 |
820058 | 820058 | 2020-12-12 | Santa Clara | California | 6085 | 45986 | 527 |
820059 | 820059 | 2020-12-12 | Santa Cruz | California | 6087 | 5764 | 53 |
820060 | 820060 | 2020-12-12 | Shasta | California | 6089 | 6853 | 58 |
820061 | 820061 | 2020-12-12 | Sierra | California | 6091 | 19 | 0 |
820062 | 820062 | 2020-12-12 | Siskiyou | California | 6093 | 914 | 7 |
820063 | 820063 | 2020-12-12 | Solano | California | 6095 | 12738 | 91 |
820064 | 820064 | 2020-12-12 | Sonoma | California | 6097 | 14475 | 162 |
820065 | 820065 | 2020-12-12 | Stanislaus | California | 6099 | 28432 | 468 |
820066 | 820066 | 2020-12-12 | Sutter | California | 6101 | 4657 | 33 |
820067 | 820067 | 2020-12-12 | Tehama | California | 6103 | 2232 | 30 |
820068 | 820068 | 2020-12-12 | Trinity | California | 6105 | 205 | 1 |
820069 | 820069 | 2020-12-12 | Tulare | California | 6107 | 25042 | 327 |
820070 | 820070 | 2020-12-12 | Tuolumne | California | 6109 | 1547 | 17 |
820071 | 820071 | 2020-12-12 | Ventura | California | 6111 | 24999 | 198 |
820072 | 820072 | 2020-12-12 | Yolo | California | 6113 | 6049 | 89 |
820073 | 820073 | 2020-12-12 | Yuba | California | 6115 | 2820 | 10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);