ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
700 rows where county = "Mellette" and state = "South Dakota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
236315 | 236315 | 2020-06-13 | Mellette | South Dakota | 46095 | 1 | 0 |
239423 | 239423 | 2020-06-14 | Mellette | South Dakota | 46095 | 1 | 0 |
242533 | 242533 | 2020-06-15 | Mellette | South Dakota | 46095 | 1 | 0 |
245645 | 245645 | 2020-06-16 | Mellette | South Dakota | 46095 | 2 | 0 |
248758 | 248758 | 2020-06-17 | Mellette | South Dakota | 46095 | 2 | 0 |
251873 | 251873 | 2020-06-18 | Mellette | South Dakota | 46095 | 2 | 0 |
254988 | 254988 | 2020-06-19 | Mellette | South Dakota | 46095 | 2 | 0 |
258114 | 258114 | 2020-06-20 | Mellette | South Dakota | 46095 | 2 | 0 |
261241 | 261241 | 2020-06-21 | Mellette | South Dakota | 46095 | 2 | 0 |
264369 | 264369 | 2020-06-22 | Mellette | South Dakota | 46095 | 2 | 0 |
267497 | 267497 | 2020-06-23 | Mellette | South Dakota | 46095 | 2 | 0 |
270631 | 270631 | 2020-06-24 | Mellette | South Dakota | 46095 | 3 | 0 |
273770 | 273770 | 2020-06-25 | Mellette | South Dakota | 46095 | 3 | 0 |
276917 | 276917 | 2020-06-26 | Mellette | South Dakota | 46095 | 3 | 0 |
280065 | 280065 | 2020-06-27 | Mellette | South Dakota | 46095 | 3 | 0 |
283211 | 283211 | 2020-06-28 | Mellette | South Dakota | 46095 | 3 | 0 |
286356 | 286356 | 2020-06-29 | Mellette | South Dakota | 46095 | 3 | 0 |
289507 | 289507 | 2020-06-30 | Mellette | South Dakota | 46095 | 3 | 0 |
292659 | 292659 | 2020-07-01 | Mellette | South Dakota | 46095 | 4 | 0 |
295815 | 295815 | 2020-07-02 | Mellette | South Dakota | 46095 | 5 | 0 |
298975 | 298975 | 2020-07-03 | Mellette | South Dakota | 46095 | 5 | 0 |
302139 | 302139 | 2020-07-04 | Mellette | South Dakota | 46095 | 7 | 0 |
305302 | 305302 | 2020-07-05 | Mellette | South Dakota | 46095 | 7 | 0 |
308470 | 308470 | 2020-07-06 | Mellette | South Dakota | 46095 | 7 | 0 |
311639 | 311639 | 2020-07-07 | Mellette | South Dakota | 46095 | 6 | 0 |
314813 | 314813 | 2020-07-08 | Mellette | South Dakota | 46095 | 6 | 0 |
317986 | 317986 | 2020-07-09 | Mellette | South Dakota | 46095 | 6 | 0 |
321164 | 321164 | 2020-07-10 | Mellette | South Dakota | 46095 | 6 | 0 |
324344 | 324344 | 2020-07-11 | Mellette | South Dakota | 46095 | 9 | 0 |
327529 | 327529 | 2020-07-12 | Mellette | South Dakota | 46095 | 9 | 0 |
330715 | 330715 | 2020-07-13 | Mellette | South Dakota | 46095 | 9 | 0 |
333907 | 333907 | 2020-07-14 | Mellette | South Dakota | 46095 | 9 | 0 |
337101 | 337101 | 2020-07-15 | Mellette | South Dakota | 46095 | 10 | 0 |
340298 | 340298 | 2020-07-16 | Mellette | South Dakota | 46095 | 12 | 0 |
343496 | 343496 | 2020-07-17 | Mellette | South Dakota | 46095 | 13 | 0 |
346696 | 346696 | 2020-07-18 | Mellette | South Dakota | 46095 | 13 | 0 |
349896 | 349896 | 2020-07-19 | Mellette | South Dakota | 46095 | 14 | 0 |
353099 | 353099 | 2020-07-20 | Mellette | South Dakota | 46095 | 14 | 0 |
356302 | 356302 | 2020-07-21 | Mellette | South Dakota | 46095 | 17 | 0 |
359506 | 359506 | 2020-07-22 | Mellette | South Dakota | 46095 | 17 | 0 |
362712 | 362712 | 2020-07-23 | Mellette | South Dakota | 46095 | 21 | 0 |
365918 | 365918 | 2020-07-24 | Mellette | South Dakota | 46095 | 21 | 0 |
369127 | 369127 | 2020-07-25 | Mellette | South Dakota | 46095 | 21 | 0 |
372339 | 372339 | 2020-07-26 | Mellette | South Dakota | 46095 | 21 | 0 |
375552 | 375552 | 2020-07-27 | Mellette | South Dakota | 46095 | 23 | 0 |
378768 | 378768 | 2020-07-28 | Mellette | South Dakota | 46095 | 23 | 0 |
381985 | 381985 | 2020-07-29 | Mellette | South Dakota | 46095 | 23 | 0 |
385203 | 385203 | 2020-07-30 | Mellette | South Dakota | 46095 | 24 | 0 |
388420 | 388420 | 2020-07-31 | Mellette | South Dakota | 46095 | 24 | 0 |
391637 | 391637 | 2020-08-01 | Mellette | South Dakota | 46095 | 24 | 0 |
394853 | 394853 | 2020-08-02 | Mellette | South Dakota | 46095 | 24 | 0 |
398070 | 398070 | 2020-08-03 | Mellette | South Dakota | 46095 | 24 | 0 |
401285 | 401285 | 2020-08-04 | Mellette | South Dakota | 46095 | 24 | 0 |
404503 | 404503 | 2020-08-05 | Mellette | South Dakota | 46095 | 24 | 0 |
407723 | 407723 | 2020-08-06 | Mellette | South Dakota | 46095 | 24 | 0 |
410942 | 410942 | 2020-08-07 | Mellette | South Dakota | 46095 | 24 | 0 |
414162 | 414162 | 2020-08-08 | Mellette | South Dakota | 46095 | 24 | 0 |
417383 | 417383 | 2020-08-09 | Mellette | South Dakota | 46095 | 24 | 0 |
420604 | 420604 | 2020-08-10 | Mellette | South Dakota | 46095 | 24 | 0 |
423826 | 423826 | 2020-08-11 | Mellette | South Dakota | 46095 | 24 | 0 |
427049 | 427049 | 2020-08-12 | Mellette | South Dakota | 46095 | 24 | 0 |
430276 | 430276 | 2020-08-13 | Mellette | South Dakota | 46095 | 24 | 0 |
433501 | 433501 | 2020-08-14 | Mellette | South Dakota | 46095 | 24 | 0 |
436728 | 436728 | 2020-08-15 | Mellette | South Dakota | 46095 | 24 | 0 |
439953 | 439953 | 2020-08-16 | Mellette | South Dakota | 46095 | 24 | 0 |
443180 | 443180 | 2020-08-17 | Mellette | South Dakota | 46095 | 24 | 0 |
446406 | 446406 | 2020-08-18 | Mellette | South Dakota | 46095 | 24 | 0 |
449634 | 449634 | 2020-08-19 | Mellette | South Dakota | 46095 | 24 | 0 |
452862 | 452862 | 2020-08-20 | Mellette | South Dakota | 46095 | 24 | 0 |
456090 | 456090 | 2020-08-21 | Mellette | South Dakota | 46095 | 24 | 0 |
459318 | 459318 | 2020-08-22 | Mellette | South Dakota | 46095 | 24 | 0 |
462546 | 462546 | 2020-08-23 | Mellette | South Dakota | 46095 | 24 | 0 |
465775 | 465775 | 2020-08-24 | Mellette | South Dakota | 46095 | 24 | 0 |
469003 | 469003 | 2020-08-25 | Mellette | South Dakota | 46095 | 24 | 0 |
472235 | 472235 | 2020-08-26 | Mellette | South Dakota | 46095 | 24 | 0 |
475469 | 475469 | 2020-08-27 | Mellette | South Dakota | 46095 | 24 | 0 |
478702 | 478702 | 2020-08-28 | Mellette | South Dakota | 46095 | 24 | 0 |
481936 | 481936 | 2020-08-29 | Mellette | South Dakota | 46095 | 24 | 0 |
485171 | 485171 | 2020-08-30 | Mellette | South Dakota | 46095 | 24 | 0 |
488404 | 488404 | 2020-08-31 | Mellette | South Dakota | 46095 | 24 | 0 |
491637 | 491637 | 2020-09-01 | Mellette | South Dakota | 46095 | 24 | 0 |
494871 | 494871 | 2020-09-02 | Mellette | South Dakota | 46095 | 25 | 0 |
498104 | 498104 | 2020-09-03 | Mellette | South Dakota | 46095 | 25 | 0 |
501338 | 501338 | 2020-09-04 | Mellette | South Dakota | 46095 | 25 | 0 |
504572 | 504572 | 2020-09-05 | Mellette | South Dakota | 46095 | 25 | 0 |
507804 | 507804 | 2020-09-06 | Mellette | South Dakota | 46095 | 25 | 0 |
511037 | 511037 | 2020-09-07 | Mellette | South Dakota | 46095 | 25 | 0 |
514270 | 514270 | 2020-09-08 | Mellette | South Dakota | 46095 | 25 | 0 |
517505 | 517505 | 2020-09-09 | Mellette | South Dakota | 46095 | 25 | 0 |
520741 | 520741 | 2020-09-10 | Mellette | South Dakota | 46095 | 25 | 0 |
523977 | 523977 | 2020-09-11 | Mellette | South Dakota | 46095 | 25 | 0 |
527213 | 527213 | 2020-09-12 | Mellette | South Dakota | 46095 | 25 | 0 |
530450 | 530450 | 2020-09-13 | Mellette | South Dakota | 46095 | 25 | 0 |
533685 | 533685 | 2020-09-14 | Mellette | South Dakota | 46095 | 25 | 0 |
536921 | 536921 | 2020-09-15 | Mellette | South Dakota | 46095 | 25 | 0 |
540158 | 540158 | 2020-09-16 | Mellette | South Dakota | 46095 | 27 | 0 |
543394 | 543394 | 2020-09-17 | Mellette | South Dakota | 46095 | 29 | 0 |
546631 | 546631 | 2020-09-18 | Mellette | South Dakota | 46095 | 30 | 0 |
549870 | 549870 | 2020-09-19 | Mellette | South Dakota | 46095 | 29 | 0 |
553109 | 553109 | 2020-09-20 | Mellette | South Dakota | 46095 | 29 | 0 |
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);