ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where deaths = 148 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 13
- Tuolumne 23
- Santa Cruz 4
- Alameda 3
- Butte 3
- San Francisco 3
- Tulare 2
- El Dorado 1
- Kings 1
- Marin 1
- Merced 1
- Monterey 1
- Sacramento 1
- Santa Barbara 1
state 1
- California · 45 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2076855 | 2076855 | 2022-01-03 | Tuolumne | California | 6109 | 8418 | 148 |
2073604 | 2073604 | 2022-01-02 | Tuolumne | California | 6109 | 8292 | 148 |
2070353 | 2070353 | 2022-01-01 | Tuolumne | California | 6109 | 8292 | 148 |
2067102 | 2067102 | 2021-12-31 | Tuolumne | California | 6109 | 8292 | 148 |
2063851 | 2063851 | 2021-12-30 | Tuolumne | California | 6109 | 8292 | 148 |
2060601 | 2060601 | 2021-12-29 | Tuolumne | California | 6109 | 8261 | 148 |
2057352 | 2057352 | 2021-12-28 | Tuolumne | California | 6109 | 8228 | 148 |
2054103 | 2054103 | 2021-12-27 | Tuolumne | California | 6109 | 8154 | 148 |
2050853 | 2050853 | 2021-12-26 | Tuolumne | California | 6109 | 8154 | 148 |
2047603 | 2047603 | 2021-12-25 | Tuolumne | California | 6109 | 8154 | 148 |
2044353 | 2044353 | 2021-12-24 | Tuolumne | California | 6109 | 8154 | 148 |
2041104 | 2041104 | 2021-12-23 | Tuolumne | California | 6109 | 8154 | 148 |
2037854 | 2037854 | 2021-12-22 | Tuolumne | California | 6109 | 8133 | 148 |
2034604 | 2034604 | 2021-12-21 | Tuolumne | California | 6109 | 8114 | 148 |
2031354 | 2031354 | 2021-12-20 | Tuolumne | California | 6109 | 8090 | 148 |
2028103 | 2028103 | 2021-12-19 | Tuolumne | California | 6109 | 8059 | 148 |
2024852 | 2024852 | 2021-12-18 | Tuolumne | California | 6109 | 8059 | 148 |
2021601 | 2021601 | 2021-12-17 | Tuolumne | California | 6109 | 8050 | 148 |
2018350 | 2018350 | 2021-12-16 | Tuolumne | California | 6109 | 8050 | 148 |
2015100 | 2015100 | 2021-12-15 | Tuolumne | California | 6109 | 8043 | 148 |
2011849 | 2011849 | 2021-12-14 | Tuolumne | California | 6109 | 8015 | 148 |
2008598 | 2008598 | 2021-12-13 | Tuolumne | California | 6109 | 8015 | 148 |
2005347 | 2005347 | 2021-12-12 | Tuolumne | California | 6109 | 7989 | 148 |
1810312 | 1810312 | 2021-10-13 | El Dorado | California | 6017 | 16902 | 148 |
1017993 | 1017993 | 2021-02-11 | Butte | California | 6007 | 10594 | 148 |
1014748 | 1014748 | 2021-02-10 | Butte | California | 6007 | 10563 | 148 |
1011503 | 1011503 | 2021-02-09 | Butte | California | 6007 | 10524 | 148 |
985574 | 985574 | 2021-02-01 | Santa Cruz | California | 6087 | 13606 | 148 |
982327 | 982327 | 2021-01-31 | Santa Cruz | California | 6087 | 13383 | 148 |
979081 | 979081 | 2021-01-30 | Santa Cruz | California | 6087 | 13321 | 148 |
975836 | 975836 | 2021-01-29 | Santa Cruz | California | 6087 | 13321 | 148 |
946602 | 946602 | 2021-01-20 | Kings | California | 6031 | 19588 | 148 |
927135 | 927135 | 2021-01-14 | Marin | California | 6041 | 11214 | 148 |
849270 | 849270 | 2020-12-21 | Santa Barbara | California | 6083 | 14935 | 148 |
813550 | 813550 | 2020-12-10 | Monterey | California | 6053 | 17891 | 148 |
690263 | 690263 | 2020-11-02 | San Francisco | California | 6075 | 12511 | 148 |
687018 | 687018 | 2020-11-01 | San Francisco | California | 6075 | 12457 | 148 |
683774 | 683774 | 2020-10-31 | San Francisco | California | 6075 | 12402 | 148 |
599422 | 599422 | 2020-10-05 | Merced | California | 6047 | 9081 | 148 |
399024 | 399024 | 2020-08-04 | Sacramento | California | 6067 | 10173 | 148 |
328444 | 328444 | 2020-07-13 | Alameda | California | 6001 | 8077 | 148 |
325258 | 325258 | 2020-07-12 | Alameda | California | 6001 | 7866 | 148 |
322077 | 322077 | 2020-07-11 | Alameda | California | 6001 | 7746 | 148 |
315777 | 315777 | 2020-07-09 | Tulare | California | 6107 | 5509 | 148 |
312602 | 312602 | 2020-07-08 | Tulare | California | 6107 | 5298 | 148 |
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);