ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where county = "Adams", deaths = 18 and fips = 28001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
313763 | 313763 | 2020-07-08 | Adams | Mississippi | 28001 | 332 | 18 |
310593 | 310593 | 2020-07-07 | Adams | Mississippi | 28001 | 315 | 18 |
307425 | 307425 | 2020-07-06 | Adams | Mississippi | 28001 | 313 | 18 |
304258 | 304258 | 2020-07-05 | Adams | Mississippi | 28001 | 311 | 18 |
301094 | 301094 | 2020-07-04 | Adams | Mississippi | 28001 | 310 | 18 |
297931 | 297931 | 2020-07-03 | Adams | Mississippi | 28001 | 293 | 18 |
294773 | 294773 | 2020-07-02 | Adams | Mississippi | 28001 | 280 | 18 |
291619 | 291619 | 2020-07-01 | Adams | Mississippi | 28001 | 267 | 18 |
288468 | 288468 | 2020-06-30 | Adams | Mississippi | 28001 | 263 | 18 |
285318 | 285318 | 2020-06-29 | Adams | Mississippi | 28001 | 253 | 18 |
282173 | 282173 | 2020-06-28 | Adams | Mississippi | 28001 | 252 | 18 |
279025 | 279025 | 2020-06-27 | Adams | Mississippi | 28001 | 248 | 18 |
275877 | 275877 | 2020-06-26 | Adams | Mississippi | 28001 | 243 | 18 |
272734 | 272734 | 2020-06-25 | Adams | Mississippi | 28001 | 242 | 18 |
269597 | 269597 | 2020-06-24 | Adams | Mississippi | 28001 | 234 | 18 |
266464 | 266464 | 2020-06-23 | Adams | Mississippi | 28001 | 233 | 18 |
263338 | 263338 | 2020-06-22 | Adams | Mississippi | 28001 | 232 | 18 |
260209 | 260209 | 2020-06-21 | Adams | Mississippi | 28001 | 227 | 18 |
257083 | 257083 | 2020-06-20 | Adams | Mississippi | 28001 | 227 | 18 |
253963 | 253963 | 2020-06-19 | Adams | Mississippi | 28001 | 227 | 18 |
250848 | 250848 | 2020-06-18 | Adams | Mississippi | 28001 | 227 | 18 |
247736 | 247736 | 2020-06-17 | Adams | Mississippi | 28001 | 227 | 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);