ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where deaths = 93 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 |
---|---|---|---|---|---|---|---|
2216714 | 2216714 | 2022-02-15 | Siskiyou | California | 6093 | 7134 | 93 |
2213463 | 2213463 | 2022-02-14 | Siskiyou | California | 6093 | 7134 | 93 |
2119075 | 2119075 | 2022-01-16 | Calaveras | California | 6009 | 5388 | 93 |
2115823 | 2115823 | 2022-01-15 | Calaveras | California | 6009 | 5388 | 93 |
2112572 | 2112572 | 2022-01-14 | Calaveras | California | 6009 | 5388 | 93 |
2109320 | 2109320 | 2022-01-13 | Calaveras | California | 6009 | 5281 | 93 |
2106069 | 2106069 | 2022-01-12 | Calaveras | California | 6009 | 5175 | 93 |
2102818 | 2102818 | 2022-01-11 | Calaveras | California | 6009 | 5117 | 93 |
2099567 | 2099567 | 2022-01-10 | Calaveras | California | 6009 | 5068 | 93 |
2096316 | 2096316 | 2022-01-09 | Calaveras | California | 6009 | 4915 | 93 |
2093064 | 2093064 | 2022-01-08 | Calaveras | California | 6009 | 4915 | 93 |
2089812 | 2089812 | 2022-01-07 | Calaveras | California | 6009 | 4915 | 93 |
2086561 | 2086561 | 2022-01-06 | Calaveras | California | 6009 | 4850 | 93 |
2083309 | 2083309 | 2022-01-05 | Calaveras | California | 6009 | 4837 | 93 |
2080057 | 2080057 | 2022-01-04 | Calaveras | California | 6009 | 4812 | 93 |
2076805 | 2076805 | 2022-01-03 | Calaveras | California | 6009 | 4738 | 93 |
2073554 | 2073554 | 2022-01-02 | Calaveras | California | 6009 | 4738 | 93 |
2070303 | 2070303 | 2022-01-01 | Calaveras | California | 6009 | 4738 | 93 |
2067052 | 2067052 | 2021-12-31 | Calaveras | California | 6009 | 4738 | 93 |
2063801 | 2063801 | 2021-12-30 | Calaveras | California | 6009 | 4716 | 93 |
1777863 | 1777863 | 2021-10-03 | Tehama | California | 6103 | 8743 | 93 |
1774613 | 1774613 | 2021-10-02 | Tehama | California | 6103 | 8743 | 93 |
1771363 | 1771363 | 2021-10-01 | Tehama | California | 6103 | 8743 | 93 |
1755080 | 1755080 | 2021-09-26 | Humboldt | California | 6023 | 8430 | 93 |
1751832 | 1751832 | 2021-09-25 | Humboldt | California | 6023 | 8430 | 93 |
1748583 | 1748583 | 2021-09-24 | Humboldt | California | 6023 | 8430 | 93 |
1745333 | 1745333 | 2021-09-23 | Humboldt | California | 6023 | 8414 | 93 |
1745338 | 1745338 | 2021-09-23 | Lake | California | 6033 | 6124 | 93 |
1677150 | 1677150 | 2021-09-02 | Tuolumne | California | 6109 | 5778 | 93 |
1053700 | 1053700 | 2021-02-22 | El Dorado | California | 6017 | 8927 | 93 |
1050453 | 1050453 | 2021-02-21 | El Dorado | California | 6017 | 8911 | 93 |
1047206 | 1047206 | 2021-02-20 | El Dorado | California | 6017 | 8882 | 93 |
1037513 | 1037513 | 2021-02-17 | Sutter | California | 6101 | 8722 | 93 |
1034268 | 1034268 | 2021-02-16 | Sutter | California | 6101 | 8708 | 93 |
1031022 | 1031022 | 2021-02-15 | Sutter | California | 6101 | 8656 | 93 |
1027775 | 1027775 | 2021-02-14 | Sutter | California | 6101 | 8656 | 93 |
1024530 | 1024530 | 2021-02-13 | Sutter | California | 6101 | 8656 | 93 |
1021285 | 1021285 | 2021-02-12 | Sutter | California | 6101 | 8656 | 93 |
897951 | 897951 | 2021-01-05 | Santa Cruz | California | 6087 | 9700 | 93 |
846031 | 846031 | 2020-12-20 | Solano | California | 6095 | 15209 | 93 |
842785 | 842785 | 2020-12-19 | Solano | California | 6095 | 15013 | 93 |
839540 | 839540 | 2020-12-18 | Solano | California | 6095 | 15013 | 93 |
836295 | 836295 | 2020-12-17 | Solano | California | 6095 | 14718 | 93 |
833049 | 833049 | 2020-12-16 | Solano | California | 6095 | 14274 | 93 |
826539 | 826539 | 2020-12-14 | Placer | California | 6061 | 9549 | 93 |
797315 | 797315 | 2020-12-05 | Kings | California | 6031 | 11911 | 93 |
508775 | 508775 | 2020-09-07 | Sonoma | California | 6097 | 6360 | 93 |
505543 | 505543 | 2020-09-06 | Sonoma | California | 6097 | 6303 | 93 |
502309 | 502309 | 2020-09-05 | Sonoma | California | 6097 | 6142 | 93 |
499075 | 499075 | 2020-09-04 | Sonoma | California | 6097 | 6142 | 93 |
495842 | 495842 | 2020-09-03 | Sonoma | California | 6097 | 6142 | 93 |
486135 | 486135 | 2020-08-31 | Santa Barbara | California | 6083 | 8143 | 93 |
440899 | 440899 | 2020-08-17 | Merced | California | 6047 | 7041 | 93 |
424802 | 424802 | 2020-08-12 | Ventura | California | 6111 | 8953 | 93 |
421581 | 421581 | 2020-08-11 | Ventura | California | 6111 | 8851 | 93 |
338024 | 338024 | 2020-07-16 | Contra Costa | California | 6013 | 5246 | 93 |
227932 | 227932 | 2020-06-11 | San Mateo | California | 6081 | 2494 | 93 |
224830 | 224830 | 2020-06-10 | San Mateo | California | 6081 | 2475 | 93 |
221735 | 221735 | 2020-06-09 | San Mateo | California | 6081 | 2437 | 93 |
178672 | 178672 | 2020-05-26 | Alameda | California | 6001 | 3007 | 93 |
175628 | 175628 | 2020-05-25 | Alameda | California | 6001 | 2895 | 93 |
172584 | 172584 | 2020-05-24 | Alameda | California | 6001 | 2868 | 93 |
101219 | 101219 | 2020-04-30 | San Bernardino | California | 6071 | 2058 | 93 |
75868 | 75868 | 2020-04-21 | Riverside | California | 6065 | 2960 | 93 |
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);