ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 321, fips = 6097 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 |
---|---|---|---|---|---|---|---|
1365437 | 1365437 | 2021-05-29 | Sonoma | California | 6097 | 30298 | 321 |
1362191 | 1362191 | 2021-05-28 | Sonoma | California | 6097 | 30269 | 321 |
1358944 | 1358944 | 2021-05-27 | Sonoma | California | 6097 | 30257 | 321 |
1355698 | 1355698 | 2021-05-26 | Sonoma | California | 6097 | 30230 | 321 |
1352452 | 1352452 | 2021-05-25 | Sonoma | California | 6097 | 30187 | 321 |
1349206 | 1349206 | 2021-05-24 | Sonoma | California | 6097 | 30169 | 321 |
1345959 | 1345959 | 2021-05-23 | Sonoma | California | 6097 | 30168 | 321 |
1342711 | 1342711 | 2021-05-22 | Sonoma | California | 6097 | 30150 | 321 |
1339463 | 1339463 | 2021-05-21 | Sonoma | California | 6097 | 30130 | 321 |
1336216 | 1336216 | 2021-05-20 | Sonoma | California | 6097 | 30104 | 321 |
1332969 | 1332969 | 2021-05-19 | Sonoma | California | 6097 | 30101 | 321 |
1329722 | 1329722 | 2021-05-18 | Sonoma | California | 6097 | 30071 | 321 |
1326475 | 1326475 | 2021-05-17 | Sonoma | California | 6097 | 30067 | 321 |
1323229 | 1323229 | 2021-05-16 | Sonoma | California | 6097 | 30057 | 321 |
1319983 | 1319983 | 2021-05-15 | Sonoma | California | 6097 | 30053 | 321 |
1316736 | 1316736 | 2021-05-14 | Sonoma | California | 6097 | 30035 | 321 |
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);