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-24 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
858964 | 858964 | 2020-12-24 | Alameda | California | 6001 | 46774 | 619 |
858965 | 858965 | 2020-12-24 | Alpine | California | 6003 | 64 | 0 |
858966 | 858966 | 2020-12-24 | Amador | California | 6005 | 2107 | 23 |
858967 | 858967 | 2020-12-24 | Butte | California | 6007 | 6588 | 83 |
858968 | 858968 | 2020-12-24 | Calaveras | California | 6009 | 1002 | 22 |
858969 | 858969 | 2020-12-24 | Colusa | California | 6011 | 1214 | 8 |
858970 | 858970 | 2020-12-24 | Contra Costa | California | 6013 | 36752 | 308 |
858971 | 858971 | 2020-12-24 | Del Norte | California | 6015 | 695 | 2 |
858972 | 858972 | 2020-12-24 | El Dorado | California | 6017 | 4967 | 13 |
858973 | 858973 | 2020-12-24 | Fresno | California | 6019 | 60488 | 646 |
858974 | 858974 | 2020-12-24 | Glenn | California | 6021 | 1349 | 14 |
858975 | 858975 | 2020-12-24 | Humboldt | California | 6023 | 1539 | 17 |
858976 | 858976 | 2020-12-24 | Imperial | California | 6025 | 21323 | 405 |
858977 | 858977 | 2020-12-24 | Inyo | California | 6027 | 517 | 20 |
858978 | 858978 | 2020-12-24 | Kern | California | 6029 | 62439 | 485 |
858979 | 858979 | 2020-12-24 | Kings | California | 6031 | 15242 | 110 |
858980 | 858980 | 2020-12-24 | Lake | California | 6033 | 1595 | 22 |
858981 | 858981 | 2020-12-24 | Lassen | California | 6035 | 4180 | 8 |
858982 | 858982 | 2020-12-24 | Los Angeles | California | 6037 | 677538 | 9299 |
858983 | 858983 | 2020-12-24 | Madera | California | 6039 | 9371 | 116 |
858984 | 858984 | 2020-12-24 | Marin | California | 6041 | 9360 | 136 |
858985 | 858985 | 2020-12-24 | Mariposa | California | 6043 | 212 | 4 |
858986 | 858986 | 2020-12-24 | Mendocino | California | 6045 | 2314 | 25 |
858987 | 858987 | 2020-12-24 | Merced | California | 6047 | 17785 | 232 |
858988 | 858988 | 2020-12-24 | Modoc | California | 6049 | 292 | 0 |
858989 | 858989 | 2020-12-24 | Mono | California | 6051 | 814 | 4 |
858990 | 858990 | 2020-12-24 | Monterey | California | 6053 | 24856 | 185 |
858991 | 858991 | 2020-12-24 | Napa | California | 6055 | 5173 | 27 |
858992 | 858992 | 2020-12-24 | Nevada | California | 6057 | 2415 | 44 |
858993 | 858993 | 2020-12-24 | Orange | California | 6059 | 140699 | 1782 |
858994 | 858994 | 2020-12-24 | Placer | California | 6061 | 12262 | 120 |
858995 | 858995 | 2020-12-24 | Plumas | California | 6063 | 369 | 0 |
858996 | 858996 | 2020-12-24 | Riverside | California | 6065 | 158110 | 1829 |
858997 | 858997 | 2020-12-24 | Sacramento | California | 6067 | 59769 | 809 |
858998 | 858998 | 2020-12-24 | San Benito | California | 6069 | 3231 | 26 |
858999 | 858999 | 2020-12-24 | San Bernardino | California | 6071 | 174091 | 1420 |
859000 | 859000 | 2020-12-24 | San Diego | California | 6073 | 137018 | 1382 |
859001 | 859001 | 2020-12-24 | San Francisco | California | 6075 | 21501 | 178 |
859002 | 859002 | 2020-12-24 | San Joaquin | California | 6077 | 41104 | 618 |
859003 | 859003 | 2020-12-24 | San Luis Obispo | California | 6079 | 9471 | 67 |
859004 | 859004 | 2020-12-24 | San Mateo | California | 6081 | 22241 | 212 |
859005 | 859005 | 2020-12-24 | Santa Barbara | California | 6083 | 15657 | 151 |
859006 | 859006 | 2020-12-24 | Santa Clara | California | 6085 | 61090 | 644 |
859007 | 859007 | 2020-12-24 | Santa Cruz | California | 6087 | 7637 | 76 |
859008 | 859008 | 2020-12-24 | Shasta | California | 6089 | 7567 | 70 |
859009 | 859009 | 2020-12-24 | Sierra | California | 6091 | 23 | 0 |
859010 | 859010 | 2020-12-24 | Siskiyou | California | 6093 | 1076 | 8 |
859011 | 859011 | 2020-12-24 | Solano | California | 6095 | 17335 | 95 |
859012 | 859012 | 2020-12-24 | Sonoma | California | 6097 | 17444 | 180 |
859013 | 859013 | 2020-12-24 | Stanislaus | California | 6099 | 34682 | 565 |
859014 | 859014 | 2020-12-24 | Sutter | California | 6101 | 6037 | 46 |
859015 | 859015 | 2020-12-24 | Tehama | California | 6103 | 2737 | 33 |
859016 | 859016 | 2020-12-24 | Trinity | California | 6105 | 235 | 2 |
859017 | 859017 | 2020-12-24 | Tulare | California | 6107 | 30422 | 373 |
859018 | 859018 | 2020-12-24 | Tuolumne | California | 6109 | 2704 | 21 |
859019 | 859019 | 2020-12-24 | Ventura | California | 6111 | 33401 | 233 |
859020 | 859020 | 2020-12-24 | Yolo | California | 6113 | 7508 | 110 |
859021 | 859021 | 2020-12-24 | Yuba | California | 6115 | 3628 | 17 |
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);