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-09-25 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
566986 | 566986 | 2020-09-25 | Alameda | California | 6001 | 21049 | 404 |
566987 | 566987 | 2020-09-25 | Alpine | California | 6003 | 2 | 0 |
566988 | 566988 | 2020-09-25 | Amador | California | 6005 | 287 | 16 |
566989 | 566989 | 2020-09-25 | Butte | California | 6007 | 2803 | 44 |
566990 | 566990 | 2020-09-25 | Calaveras | California | 6009 | 317 | 14 |
566991 | 566991 | 2020-09-25 | Colusa | California | 6011 | 529 | 6 |
566992 | 566992 | 2020-09-25 | Contra Costa | California | 6013 | 16469 | 205 |
566993 | 566993 | 2020-09-25 | Del Norte | California | 6015 | 139 | 1 |
566994 | 566994 | 2020-09-25 | El Dorado | California | 6017 | 1109 | 4 |
566995 | 566995 | 2020-09-25 | Fresno | California | 6019 | 28106 | 382 |
566996 | 566996 | 2020-09-25 | Glenn | California | 6021 | 567 | 3 |
566997 | 566997 | 2020-09-25 | Humboldt | California | 6023 | 501 | 7 |
566998 | 566998 | 2020-09-25 | Imperial | California | 6025 | 11781 | 316 |
566999 | 566999 | 2020-09-25 | Inyo | California | 6027 | 187 | 15 |
567000 | 567000 | 2020-09-25 | Kern | California | 6029 | 31865 | 367 |
567001 | 567001 | 2020-09-25 | Kings | California | 6031 | 7645 | 77 |
567002 | 567002 | 2020-09-25 | Lake | California | 6033 | 531 | 11 |
567003 | 567003 | 2020-09-25 | Lassen | California | 6035 | 740 | 0 |
567004 | 567004 | 2020-09-25 | Los Angeles | California | 6037 | 265775 | 6488 |
567005 | 567005 | 2020-09-25 | Madera | California | 6039 | 4458 | 65 |
567006 | 567006 | 2020-09-25 | Marin | California | 6041 | 6694 | 116 |
567007 | 567007 | 2020-09-25 | Mariposa | California | 6043 | 75 | 2 |
567008 | 567008 | 2020-09-25 | Mendocino | California | 6045 | 908 | 18 |
567009 | 567009 | 2020-09-25 | Merced | California | 6047 | 8872 | 142 |
567010 | 567010 | 2020-09-25 | Modoc | California | 6049 | 27 | 0 |
567011 | 567011 | 2020-09-25 | Mono | California | 6051 | 165 | 2 |
567012 | 567012 | 2020-09-25 | Monterey | California | 6053 | 9807 | 71 |
567013 | 567013 | 2020-09-25 | Napa | California | 6055 | 1662 | 13 |
567014 | 567014 | 2020-09-25 | Nevada | California | 6057 | 533 | 7 |
567015 | 567015 | 2020-09-25 | Orange | California | 6059 | 54328 | 1204 |
567016 | 567016 | 2020-09-25 | Placer | California | 6061 | 3542 | 44 |
567017 | 567017 | 2020-09-25 | Plumas | California | 6063 | 48 | 0 |
567018 | 567018 | 2020-09-25 | Riverside | California | 6065 | 58178 | 1189 |
567019 | 567019 | 2020-09-25 | Sacramento | California | 6067 | 22182 | 406 |
567020 | 567020 | 2020-09-25 | San Benito | California | 6069 | 1331 | 11 |
567021 | 567021 | 2020-09-25 | San Bernardino | California | 6071 | 53669 | 922 |
567022 | 567022 | 2020-09-25 | San Diego | California | 6073 | 46064 | 775 |
567023 | 567023 | 2020-09-25 | San Francisco | California | 6075 | 11041 | 99 |
567024 | 567024 | 2020-09-25 | San Joaquin | California | 6077 | 20194 | 441 |
567025 | 567025 | 2020-09-25 | San Luis Obispo | California | 6079 | 3544 | 29 |
567026 | 567026 | 2020-09-25 | San Mateo | California | 6081 | 9785 | 150 |
567027 | 567027 | 2020-09-25 | Santa Barbara | California | 6083 | 9037 | 113 |
567028 | 567028 | 2020-09-25 | Santa Clara | California | 6085 | 20882 | 307 |
567029 | 567029 | 2020-09-25 | Santa Cruz | California | 6087 | 2330 | 9 |
567030 | 567030 | 2020-09-25 | Shasta | California | 6089 | 777 | 17 |
567031 | 567031 | 2020-09-25 | Sierra | California | 6091 | 6 | 0 |
567032 | 567032 | 2020-09-25 | Siskiyou | California | 6093 | 165 | 0 |
567033 | 567033 | 2020-09-25 | Solano | California | 6095 | 6314 | 63 |
567034 | 567034 | 2020-09-25 | Sonoma | California | 6097 | 7320 | 120 |
567035 | 567035 | 2020-09-25 | Stanislaus | California | 6099 | 16452 | 348 |
567036 | 567036 | 2020-09-25 | Sutter | California | 6101 | 1705 | 11 |
567037 | 567037 | 2020-09-25 | Tehama | California | 6103 | 540 | 4 |
567038 | 567038 | 2020-09-25 | Trinity | California | 6105 | 16 | 0 |
567039 | 567039 | 2020-09-25 | Tulare | California | 6107 | 15897 | 259 |
567040 | 567040 | 2020-09-25 | Tuolumne | California | 6109 | 227 | 4 |
567041 | 567041 | 2020-09-25 | Ventura | California | 6111 | 12617 | 150 |
567042 | 567042 | 2020-09-25 | Yolo | California | 6113 | 2789 | 55 |
567043 | 567043 | 2020-09-25 | Yuba | California | 6115 | 1153 | 7 |
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);