ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where county = "Rock" and deaths = 18 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220487 | 1220487 | 2021-04-14 | Rock | Minnesota | 27133 | 1218 | 18 |
1217239 | 1217239 | 2021-04-13 | Rock | Minnesota | 27133 | 1214 | 18 |
1213992 | 1213992 | 2021-04-12 | Rock | Minnesota | 27133 | 1212 | 18 |
1210744 | 1210744 | 2021-04-11 | Rock | Minnesota | 27133 | 1210 | 18 |
1207495 | 1207495 | 2021-04-10 | Rock | Minnesota | 27133 | 1209 | 18 |
1204247 | 1204247 | 2021-04-09 | Rock | Minnesota | 27133 | 1206 | 18 |
1200999 | 1200999 | 2021-04-08 | Rock | Minnesota | 27133 | 1204 | 18 |
1197750 | 1197750 | 2021-04-07 | Rock | Minnesota | 27133 | 1202 | 18 |
1194501 | 1194501 | 2021-04-06 | Rock | Minnesota | 27133 | 1202 | 18 |
1191252 | 1191252 | 2021-04-05 | Rock | Minnesota | 27133 | 1202 | 18 |
1188004 | 1188004 | 2021-04-04 | Rock | Minnesota | 27133 | 1200 | 18 |
1184757 | 1184757 | 2021-04-03 | Rock | Minnesota | 27133 | 1200 | 18 |
1181511 | 1181511 | 2021-04-02 | Rock | Minnesota | 27133 | 1198 | 18 |
1178264 | 1178264 | 2021-04-01 | Rock | Minnesota | 27133 | 1196 | 18 |
1175017 | 1175017 | 2021-03-31 | Rock | Minnesota | 27133 | 1193 | 18 |
1171770 | 1171770 | 2021-03-30 | Rock | Minnesota | 27133 | 1190 | 18 |
1168522 | 1168522 | 2021-03-29 | Rock | Minnesota | 27133 | 1190 | 18 |
1165274 | 1165274 | 2021-03-28 | Rock | Minnesota | 27133 | 1190 | 18 |
1162026 | 1162026 | 2021-03-27 | Rock | Minnesota | 27133 | 1189 | 18 |
1158778 | 1158778 | 2021-03-26 | Rock | Minnesota | 27133 | 1188 | 18 |
190673 | 190673 | 2020-05-29 | Rock | Wisconsin | 55105 | 620 | 18 |
187609 | 187609 | 2020-05-28 | Rock | Wisconsin | 55105 | 607 | 18 |
184552 | 184552 | 2020-05-27 | Rock | Wisconsin | 55105 | 588 | 18 |
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);