ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-05-07" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1293962 | 1293962 | 2021-05-07 | Alameda | California | 6001 | 87506 | 1543 |
1293963 | 1293963 | 2021-05-07 | Alpine | California | 6003 | 88 | 0 |
1293964 | 1293964 | 2021-05-07 | Amador | California | 6005 | 3651 | 47 |
1293965 | 1293965 | 2021-05-07 | Butte | California | 6007 | 11929 | 198 |
1293966 | 1293966 | 2021-05-07 | Calaveras | California | 6009 | 2111 | 53 |
1293967 | 1293967 | 2021-05-07 | Colusa | California | 6011 | 2221 | 16 |
1293968 | 1293968 | 2021-05-07 | Contra Costa | California | 6013 | 68437 | 802 |
1293969 | 1293969 | 2021-05-07 | Del Norte | California | 6015 | 1367 | 7 |
1293970 | 1293970 | 2021-05-07 | El Dorado | California | 6017 | 10067 | 112 |
1293971 | 1293971 | 2021-05-07 | Fresno | California | 6019 | 101536 | 1680 |
1293972 | 1293972 | 2021-05-07 | Glenn | California | 6021 | 2899 | 25 |
1293973 | 1293973 | 2021-05-07 | Humboldt | California | 6023 | 3935 | 39 |
1293974 | 1293974 | 2021-05-07 | Imperial | California | 6025 | 28311 | 721 |
1293975 | 1293975 | 2021-05-07 | Inyo | California | 6027 | 1424 | 38 |
1293976 | 1293976 | 2021-05-07 | Kern | California | 6029 | 108968 | 1367 |
1293977 | 1293977 | 2021-05-07 | Kings | California | 6031 | 22948 | 246 |
1293978 | 1293978 | 2021-05-07 | Lake | California | 6033 | 3465 | 43 |
1293979 | 1293979 | 2021-05-07 | Lassen | California | 6035 | 5697 | 24 |
1293980 | 1293980 | 2021-05-07 | Los Angeles | California | 6037 | 1235783 | 23991 |
1293981 | 1293981 | 2021-05-07 | Madera | California | 6039 | 16430 | 242 |
1293982 | 1293982 | 2021-05-07 | Marin | California | 6041 | 13956 | 228 |
1293983 | 1293983 | 2021-05-07 | Mariposa | California | 6043 | 445 | 7 |
1293984 | 1293984 | 2021-05-07 | Mendocino | California | 6045 | 4059 | 48 |
1293985 | 1293985 | 2021-05-07 | Merced | California | 6047 | 31743 | 458 |
1293986 | 1293986 | 2021-05-07 | Modoc | California | 6049 | 495 | 4 |
1293987 | 1293987 | 2021-05-07 | Mono | California | 6051 | 1278 | 4 |
1293988 | 1293988 | 2021-05-07 | Monterey | California | 6053 | 43563 | 382 |
1293989 | 1293989 | 2021-05-07 | Napa | California | 6055 | 9844 | 81 |
1293990 | 1293990 | 2021-05-07 | Nevada | California | 6057 | 4687 | 75 |
1293991 | 1293991 | 2021-05-07 | Orange | California | 6059 | 270625 | 5000 |
1293992 | 1293992 | 2021-05-07 | Placer | California | 6061 | 22550 | 290 |
1293993 | 1293993 | 2021-05-07 | Plumas | California | 6063 | 704 | 6 |
1293994 | 1293994 | 2021-05-07 | Riverside | California | 6065 | 299064 | 4587 |
1293995 | 1293995 | 2021-05-07 | Sacramento | California | 6067 | 104175 | 1672 |
1293996 | 1293996 | 2021-05-07 | San Benito | California | 6069 | 6045 | 63 |
1293997 | 1293997 | 2021-05-07 | San Bernardino | California | 6071 | 296425 | 4683 |
1293998 | 1293998 | 2021-05-07 | San Diego | California | 6073 | 277387 | 3716 |
1293999 | 1293999 | 2021-05-07 | San Francisco | California | 6075 | 36602 | 543 |
1294000 | 1294000 | 2021-05-07 | San Joaquin | California | 6077 | 73009 | 1391 |
1294001 | 1294001 | 2021-05-07 | San Luis Obispo | California | 6079 | 21282 | 260 |
1294002 | 1294002 | 2021-05-07 | San Mateo | California | 6081 | 41802 | 567 |
1294003 | 1294003 | 2021-05-07 | Santa Barbara | California | 6083 | 34291 | 453 |
1294004 | 1294004 | 2021-05-07 | Santa Clara | California | 6085 | 118792 | 2086 |
1294005 | 1294005 | 2021-05-07 | Santa Cruz | California | 6087 | 16188 | 206 |
1294006 | 1294006 | 2021-05-07 | Shasta | California | 6089 | 12071 | 226 |
1294007 | 1294007 | 2021-05-07 | Sierra | California | 6091 | 54 | 0 |
1294008 | 1294008 | 2021-05-07 | Siskiyou | California | 6093 | 2181 | 23 |
1294009 | 1294009 | 2021-05-07 | Solano | California | 6095 | 32757 | 249 |
1294010 | 1294010 | 2021-05-07 | Sonoma | California | 6097 | 29951 | 318 |
1294011 | 1294011 | 2021-05-07 | Stanislaus | California | 6099 | 61859 | 1055 |
1294012 | 1294012 | 2021-05-07 | Sutter | California | 6101 | 9396 | 111 |
1294013 | 1294013 | 2021-05-07 | Tehama | California | 6103 | 4970 | 53 |
1294014 | 1294014 | 2021-05-07 | Trinity | California | 6105 | 328 | 3 |
1294015 | 1294015 | 2021-05-07 | Tulare | California | 6107 | 49554 | 839 |
1294016 | 1294016 | 2021-05-07 | Tuolumne | California | 6109 | 4123 | 64 |
1294017 | 1294017 | 2021-05-07 | Ventura | California | 6111 | 80842 | 1011 |
1294018 | 1294018 | 2021-05-07 | Yolo | California | 6113 | 13871 | 209 |
1294019 | 1294019 | 2021-05-07 | Yuba | California | 6115 | 6209 | 46 |
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);