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-08 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
807035 | 807035 | 2020-12-08 | Alameda | California | 6001 | 33908 | 525 |
807036 | 807036 | 2020-12-08 | Alpine | California | 6003 | 53 | 0 |
807037 | 807037 | 2020-12-08 | Amador | California | 6005 | 992 | 17 |
807038 | 807038 | 2020-12-08 | Butte | California | 6007 | 4706 | 62 |
807039 | 807039 | 2020-12-08 | Calaveras | California | 6009 | 606 | 22 |
807040 | 807040 | 2020-12-08 | Colusa | California | 6011 | 885 | 7 |
807041 | 807041 | 2020-12-08 | Contra Costa | California | 6013 | 28088 | 267 |
807042 | 807042 | 2020-12-08 | Del Norte | California | 6015 | 489 | 1 |
807043 | 807043 | 2020-12-08 | El Dorado | California | 6017 | 3275 | 8 |
807044 | 807044 | 2020-12-08 | Fresno | California | 6019 | 41460 | 514 |
807045 | 807045 | 2020-12-08 | Glenn | California | 6021 | 1085 | 11 |
807046 | 807046 | 2020-12-08 | Humboldt | California | 6023 | 1137 | 9 |
807047 | 807047 | 2020-12-08 | Imperial | California | 6025 | 17400 | 359 |
807048 | 807048 | 2020-12-08 | Inyo | California | 6027 | 333 | 16 |
807049 | 807049 | 2020-12-08 | Kern | California | 6029 | 46397 | 457 |
807050 | 807050 | 2020-12-08 | Kings | California | 6031 | 12624 | 95 |
807051 | 807051 | 2020-12-08 | Lake | California | 6033 | 1090 | 21 |
807052 | 807052 | 2020-12-08 | Lassen | California | 6035 | 2856 | 2 |
807053 | 807053 | 2020-12-08 | Los Angeles | California | 6037 | 466459 | 8000 |
807054 | 807054 | 2020-12-08 | Madera | California | 6039 | 7115 | 107 |
807055 | 807055 | 2020-12-08 | Marin | California | 6041 | 8195 | 132 |
807056 | 807056 | 2020-12-08 | Mariposa | California | 6043 | 165 | 4 |
807057 | 807057 | 2020-12-08 | Mendocino | California | 6045 | 1816 | 24 |
807058 | 807058 | 2020-12-08 | Merced | California | 6047 | 13851 | 198 |
807059 | 807059 | 2020-12-08 | Modoc | California | 6049 | 197 | 0 |
807060 | 807060 | 2020-12-08 | Mono | California | 6051 | 590 | 3 |
807061 | 807061 | 2020-12-08 | Monterey | California | 6053 | 17746 | 136 |
807062 | 807062 | 2020-12-08 | Napa | California | 6055 | 3734 | 21 |
807063 | 807063 | 2020-12-08 | Nevada | California | 6057 | 1811 | 19 |
807064 | 807064 | 2020-12-08 | Orange | California | 6059 | 92811 | 1633 |
807065 | 807065 | 2020-12-08 | Placer | California | 6061 | 8173 | 81 |
807066 | 807066 | 2020-12-08 | Plumas | California | 6063 | 256 | 0 |
807067 | 807067 | 2020-12-08 | Riverside | California | 6065 | 103221 | 1513 |
807068 | 807068 | 2020-12-08 | Sacramento | California | 6067 | 44687 | 635 |
807069 | 807069 | 2020-12-08 | San Benito | California | 6069 | 2214 | 19 |
807070 | 807070 | 2020-12-08 | San Bernardino | California | 6071 | 108946 | 1207 |
807071 | 807071 | 2020-12-08 | San Diego | California | 6073 | 95508 | 1062 |
807072 | 807072 | 2020-12-08 | San Francisco | California | 6075 | 17223 | 164 |
807073 | 807073 | 2020-12-08 | San Joaquin | California | 6077 | 28532 | 530 |
807074 | 807074 | 2020-12-08 | San Luis Obispo | California | 6079 | 6965 | 42 |
807075 | 807075 | 2020-12-08 | San Mateo | California | 6081 | 16371 | 177 |
807076 | 807076 | 2020-12-08 | Santa Barbara | California | 6083 | 12502 | 139 |
807077 | 807077 | 2020-12-08 | Santa Clara | California | 6085 | 41316 | 513 |
807078 | 807078 | 2020-12-08 | Santa Cruz | California | 6087 | 5176 | 47 |
807079 | 807079 | 2020-12-08 | Shasta | California | 6089 | 6055 | 54 |
807080 | 807080 | 2020-12-08 | Sierra | California | 6091 | 18 | 0 |
807081 | 807081 | 2020-12-08 | Siskiyou | California | 6093 | 851 | 7 |
807082 | 807082 | 2020-12-08 | Solano | California | 6095 | 11955 | 90 |
807083 | 807083 | 2020-12-08 | Sonoma | California | 6097 | 13719 | 160 |
807084 | 807084 | 2020-12-08 | Stanislaus | California | 6099 | 26624 | 450 |
807085 | 807085 | 2020-12-08 | Sutter | California | 6101 | 4435 | 26 |
807086 | 807086 | 2020-12-08 | Tehama | California | 6103 | 2030 | 28 |
807087 | 807087 | 2020-12-08 | Trinity | California | 6105 | 195 | 1 |
807088 | 807088 | 2020-12-08 | Tulare | California | 6107 | 23662 | 319 |
807089 | 807089 | 2020-12-08 | Tuolumne | California | 6109 | 1321 | 14 |
807090 | 807090 | 2020-12-08 | Ventura | California | 6111 | 23473 | 195 |
807091 | 807091 | 2020-12-08 | Yolo | California | 6113 | 5549 | 84 |
807092 | 807092 | 2020-12-08 | Yuba | California | 6115 | 2650 | 11 |
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);