ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 311 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- California · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428171 | 2428171 | 2022-04-21 | Yolo | California | 6113 | 40000 | 311 |
2424915 | 2424915 | 2022-04-20 | Yolo | California | 6113 | 40000 | 311 |
2421659 | 2421659 | 2022-04-19 | Yolo | California | 6113 | 40000 | 311 |
2346806 | 2346806 | 2022-03-27 | Yolo | California | 6113 | 39411 | 311 |
2343553 | 2343553 | 2022-03-26 | Yolo | California | 6113 | 39411 | 311 |
2340300 | 2340300 | 2022-03-25 | Yolo | California | 6113 | 39411 | 311 |
1992309 | 1992309 | 2021-12-08 | Madera | California | 6039 | 26567 | 311 |
1989058 | 1989058 | 2021-12-07 | Madera | California | 6039 | 26534 | 311 |
1985808 | 1985808 | 2021-12-06 | Madera | California | 6039 | 26511 | 311 |
1982558 | 1982558 | 2021-12-05 | Madera | California | 6039 | 26388 | 311 |
1979308 | 1979308 | 2021-12-04 | Madera | California | 6039 | 26388 | 311 |
1976058 | 1976058 | 2021-12-03 | Madera | California | 6039 | 26388 | 311 |
1972809 | 1972809 | 2021-12-02 | Madera | California | 6039 | 26334 | 311 |
1969559 | 1969559 | 2021-12-01 | Madera | California | 6039 | 26233 | 311 |
1966309 | 1966309 | 2021-11-30 | Madera | California | 6039 | 26194 | 311 |
1963057 | 1963057 | 2021-11-29 | Madera | California | 6039 | 26180 | 311 |
1959806 | 1959806 | 2021-11-28 | Madera | California | 6039 | 26005 | 311 |
1956555 | 1956555 | 2021-11-27 | Madera | California | 6039 | 26005 | 311 |
1953304 | 1953304 | 2021-11-26 | Madera | California | 6039 | 26005 | 311 |
1742120 | 1742120 | 2021-09-22 | Solano | California | 6095 | 44320 | 311 |
1729114 | 1729114 | 2021-09-18 | San Luis Obispo | California | 6079 | 28194 | 311 |
1242061 | 1242061 | 2021-04-21 | Sonoma | California | 6097 | 29720 | 311 |
1238814 | 1238814 | 2021-04-20 | Sonoma | California | 6097 | 29715 | 311 |
1235567 | 1235567 | 2021-04-19 | Sonoma | California | 6097 | 29696 | 311 |
1232320 | 1232320 | 2021-04-18 | Sonoma | California | 6097 | 29679 | 311 |
1229071 | 1229071 | 2021-04-17 | Sonoma | California | 6097 | 29632 | 311 |
1225823 | 1225823 | 2021-04-16 | Sonoma | California | 6097 | 29632 | 311 |
1222576 | 1222576 | 2021-04-15 | Sonoma | California | 6097 | 29632 | 311 |
1219328 | 1219328 | 2021-04-14 | Sonoma | California | 6097 | 29608 | 311 |
1216080 | 1216080 | 2021-04-13 | Sonoma | California | 6097 | 29573 | 311 |
1196591 | 1196591 | 2021-04-07 | Sonoma | California | 6097 | 29431 | 311 |
1193343 | 1193343 | 2021-04-06 | Sonoma | California | 6097 | 29423 | 311 |
1190093 | 1190093 | 2021-04-05 | Sonoma | California | 6097 | 29402 | 311 |
1186846 | 1186846 | 2021-04-04 | Sonoma | California | 6097 | 29372 | 311 |
1183599 | 1183599 | 2021-04-03 | Sonoma | California | 6097 | 29349 | 311 |
1180352 | 1180352 | 2021-04-02 | Sonoma | California | 6097 | 29310 | 311 |
1177105 | 1177105 | 2021-04-01 | Sonoma | California | 6097 | 29257 | 311 |
1173858 | 1173858 | 2021-03-31 | Sonoma | California | 6097 | 29255 | 311 |
544330 | 544330 | 2020-09-18 | Imperial | California | 6025 | 11534 | 311 |
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);