ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where county = "Amherst" and deaths = 1 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
78162 | 78162 | 2020-04-21 | Amherst | Virginia | 51009 | 10 | 1 |
80954 | 80954 | 2020-04-22 | Amherst | Virginia | 51009 | 10 | 1 |
83755 | 83755 | 2020-04-23 | Amherst | Virginia | 51009 | 10 | 1 |
86562 | 86562 | 2020-04-24 | Amherst | Virginia | 51009 | 10 | 1 |
424243 | 424243 | 2020-08-11 | Amherst | Virginia | 51009 | 183 | 1 |
427467 | 427467 | 2020-08-12 | Amherst | Virginia | 51009 | 184 | 1 |
430695 | 430695 | 2020-08-13 | Amherst | Virginia | 51009 | 196 | 1 |
433920 | 433920 | 2020-08-14 | Amherst | Virginia | 51009 | 202 | 1 |
437146 | 437146 | 2020-08-15 | Amherst | Virginia | 51009 | 206 | 1 |
440372 | 440372 | 2020-08-16 | Amherst | Virginia | 51009 | 219 | 1 |
443598 | 443598 | 2020-08-17 | Amherst | Virginia | 51009 | 217 | 1 |
446825 | 446825 | 2020-08-18 | Amherst | Virginia | 51009 | 223 | 1 |
450053 | 450053 | 2020-08-19 | Amherst | Virginia | 51009 | 228 | 1 |
453281 | 453281 | 2020-08-20 | Amherst | Virginia | 51009 | 237 | 1 |
456509 | 456509 | 2020-08-21 | Amherst | Virginia | 51009 | 246 | 1 |
459736 | 459736 | 2020-08-22 | Amherst | Virginia | 51009 | 253 | 1 |
462965 | 462965 | 2020-08-23 | Amherst | Virginia | 51009 | 259 | 1 |
466194 | 466194 | 2020-08-24 | Amherst | Virginia | 51009 | 262 | 1 |
469423 | 469423 | 2020-08-25 | Amherst | Virginia | 51009 | 270 | 1 |
472655 | 472655 | 2020-08-26 | Amherst | Virginia | 51009 | 269 | 1 |
475888 | 475888 | 2020-08-27 | Amherst | Virginia | 51009 | 273 | 1 |
479121 | 479121 | 2020-08-28 | Amherst | Virginia | 51009 | 277 | 1 |
482355 | 482355 | 2020-08-29 | Amherst | Virginia | 51009 | 282 | 1 |
485590 | 485590 | 2020-08-30 | Amherst | Virginia | 51009 | 286 | 1 |
488823 | 488823 | 2020-08-31 | Amherst | Virginia | 51009 | 290 | 1 |
492056 | 492056 | 2020-09-01 | Amherst | Virginia | 51009 | 298 | 1 |
495290 | 495290 | 2020-09-02 | Amherst | Virginia | 51009 | 307 | 1 |
498523 | 498523 | 2020-09-03 | Amherst | Virginia | 51009 | 313 | 1 |
501757 | 501757 | 2020-09-04 | Amherst | Virginia | 51009 | 319 | 1 |
504991 | 504991 | 2020-09-05 | Amherst | Virginia | 51009 | 320 | 1 |
508223 | 508223 | 2020-09-06 | Amherst | Virginia | 51009 | 323 | 1 |
511456 | 511456 | 2020-09-07 | Amherst | Virginia | 51009 | 325 | 1 |
514689 | 514689 | 2020-09-08 | Amherst | Virginia | 51009 | 325 | 1 |
517924 | 517924 | 2020-09-09 | Amherst | Virginia | 51009 | 327 | 1 |
521161 | 521161 | 2020-09-10 | Amherst | Virginia | 51009 | 328 | 1 |
524397 | 524397 | 2020-09-11 | Amherst | Virginia | 51009 | 333 | 1 |
527633 | 527633 | 2020-09-12 | Amherst | Virginia | 51009 | 339 | 1 |
530870 | 530870 | 2020-09-13 | Amherst | Virginia | 51009 | 343 | 1 |
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);