ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Clay" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637423 | 637423 | 2020-10-16 | Clay | Tennessee | 47027 | 351 | 7 |
634177 | 634177 | 2020-10-15 | Clay | Tennessee | 47027 | 351 | 7 |
630932 | 630932 | 2020-10-14 | Clay | Tennessee | 47027 | 344 | 6 |
627688 | 627688 | 2020-10-13 | Clay | Tennessee | 47027 | 325 | 6 |
624446 | 624446 | 2020-10-12 | Clay | Tennessee | 47027 | 320 | 6 |
621203 | 621203 | 2020-10-11 | Clay | Tennessee | 47027 | 313 | 6 |
617960 | 617960 | 2020-10-10 | Clay | Tennessee | 47027 | 305 | 6 |
614718 | 614718 | 2020-10-09 | Clay | Tennessee | 47027 | 292 | 6 |
611477 | 611477 | 2020-10-08 | Clay | Tennessee | 47027 | 281 | 6 |
608235 | 608235 | 2020-10-07 | Clay | Tennessee | 47027 | 272 | 6 |
604992 | 604992 | 2020-10-06 | Clay | Tennessee | 47027 | 267 | 6 |
601750 | 601750 | 2020-10-05 | Clay | Tennessee | 47027 | 267 | 6 |
598507 | 598507 | 2020-10-04 | Clay | Tennessee | 47027 | 259 | 6 |
595264 | 595264 | 2020-10-03 | Clay | Tennessee | 47027 | 250 | 6 |
592023 | 592023 | 2020-10-02 | Clay | Tennessee | 47027 | 246 | 6 |
588782 | 588782 | 2020-10-01 | Clay | Tennessee | 47027 | 246 | 5 |
585542 | 585542 | 2020-09-30 | Clay | Tennessee | 47027 | 243 | 5 |
582302 | 582302 | 2020-09-29 | Clay | Tennessee | 47027 | 235 | 5 |
579062 | 579062 | 2020-09-28 | Clay | Tennessee | 47027 | 234 | 5 |
575821 | 575821 | 2020-09-27 | Clay | Tennessee | 47027 | 233 | 5 |
572577 | 572577 | 2020-09-26 | Clay | Tennessee | 47027 | 226 | 5 |
569335 | 569335 | 2020-09-25 | Clay | Tennessee | 47027 | 224 | 5 |
566094 | 566094 | 2020-09-24 | Clay | Tennessee | 47027 | 220 | 5 |
562853 | 562853 | 2020-09-23 | Clay | Tennessee | 47027 | 215 | 5 |
559616 | 559616 | 2020-09-22 | Clay | Tennessee | 47027 | 211 | 5 |
556379 | 556379 | 2020-09-21 | Clay | Tennessee | 47027 | 210 | 5 |
553142 | 553142 | 2020-09-20 | Clay | Tennessee | 47027 | 187 | 5 |
549903 | 549903 | 2020-09-19 | Clay | Tennessee | 47027 | 182 | 5 |
546664 | 546664 | 2020-09-18 | Clay | Tennessee | 47027 | 176 | 5 |
543427 | 543427 | 2020-09-17 | Clay | Tennessee | 47027 | 168 | 5 |
540191 | 540191 | 2020-09-16 | Clay | Tennessee | 47027 | 161 | 5 |
536954 | 536954 | 2020-09-15 | Clay | Tennessee | 47027 | 151 | 4 |
533718 | 533718 | 2020-09-14 | Clay | Tennessee | 47027 | 146 | 4 |
530483 | 530483 | 2020-09-13 | Clay | Tennessee | 47027 | 142 | 4 |
527246 | 527246 | 2020-09-12 | Clay | Tennessee | 47027 | 142 | 4 |
524010 | 524010 | 2020-09-11 | Clay | Tennessee | 47027 | 136 | 3 |
520774 | 520774 | 2020-09-10 | Clay | Tennessee | 47027 | 132 | 3 |
517538 | 517538 | 2020-09-09 | Clay | Tennessee | 47027 | 131 | 3 |
514303 | 514303 | 2020-09-08 | Clay | Tennessee | 47027 | 131 | 2 |
511070 | 511070 | 2020-09-07 | Clay | Tennessee | 47027 | 131 | 2 |
507837 | 507837 | 2020-09-06 | Clay | Tennessee | 47027 | 131 | 2 |
504605 | 504605 | 2020-09-05 | Clay | Tennessee | 47027 | 130 | 2 |
501371 | 501371 | 2020-09-04 | Clay | Tennessee | 47027 | 129 | 2 |
498137 | 498137 | 2020-09-03 | Clay | Tennessee | 47027 | 128 | 2 |
494904 | 494904 | 2020-09-02 | Clay | Tennessee | 47027 | 118 | 2 |
491670 | 491670 | 2020-09-01 | Clay | Tennessee | 47027 | 116 | 2 |
488437 | 488437 | 2020-08-31 | Clay | Tennessee | 47027 | 112 | 0 |
485204 | 485204 | 2020-08-30 | Clay | Tennessee | 47027 | 111 | 0 |
481969 | 481969 | 2020-08-29 | Clay | Tennessee | 47027 | 110 | 0 |
478735 | 478735 | 2020-08-28 | Clay | Tennessee | 47027 | 109 | 0 |
475502 | 475502 | 2020-08-27 | Clay | Tennessee | 47027 | 106 | 0 |
472269 | 472269 | 2020-08-26 | Clay | Tennessee | 47027 | 103 | 0 |
469037 | 469037 | 2020-08-25 | Clay | Tennessee | 47027 | 103 | 0 |
465808 | 465808 | 2020-08-24 | Clay | Tennessee | 47027 | 103 | 0 |
462579 | 462579 | 2020-08-23 | Clay | Tennessee | 47027 | 102 | 0 |
459351 | 459351 | 2020-08-22 | Clay | Tennessee | 47027 | 99 | 0 |
456123 | 456123 | 2020-08-21 | Clay | Tennessee | 47027 | 96 | 0 |
452895 | 452895 | 2020-08-20 | Clay | Tennessee | 47027 | 95 | 0 |
449667 | 449667 | 2020-08-19 | Clay | Tennessee | 47027 | 94 | 0 |
446439 | 446439 | 2020-08-18 | Clay | Tennessee | 47027 | 92 | 0 |
443213 | 443213 | 2020-08-17 | Clay | Tennessee | 47027 | 91 | 0 |
439986 | 439986 | 2020-08-16 | Clay | Tennessee | 47027 | 89 | 0 |
436761 | 436761 | 2020-08-15 | Clay | Tennessee | 47027 | 87 | 0 |
433534 | 433534 | 2020-08-14 | Clay | Tennessee | 47027 | 86 | 0 |
430309 | 430309 | 2020-08-13 | Clay | Tennessee | 47027 | 84 | 0 |
427082 | 427082 | 2020-08-12 | Clay | Tennessee | 47027 | 83 | 0 |
423859 | 423859 | 2020-08-11 | Clay | Tennessee | 47027 | 79 | 0 |
420637 | 420637 | 2020-08-10 | Clay | Tennessee | 47027 | 78 | 0 |
417416 | 417416 | 2020-08-09 | Clay | Tennessee | 47027 | 76 | 0 |
414195 | 414195 | 2020-08-08 | Clay | Tennessee | 47027 | 75 | 0 |
410975 | 410975 | 2020-08-07 | Clay | Tennessee | 47027 | 74 | 0 |
407756 | 407756 | 2020-08-06 | Clay | Tennessee | 47027 | 71 | 0 |
404536 | 404536 | 2020-08-05 | Clay | Tennessee | 47027 | 66 | 0 |
401318 | 401318 | 2020-08-04 | Clay | Tennessee | 47027 | 64 | 0 |
398103 | 398103 | 2020-08-03 | Clay | Tennessee | 47027 | 61 | 0 |
394886 | 394886 | 2020-08-02 | Clay | Tennessee | 47027 | 62 | 0 |
391670 | 391670 | 2020-08-01 | Clay | Tennessee | 47027 | 61 | 0 |
388453 | 388453 | 2020-07-31 | Clay | Tennessee | 47027 | 58 | 0 |
385236 | 385236 | 2020-07-30 | Clay | Tennessee | 47027 | 53 | 0 |
382018 | 382018 | 2020-07-29 | Clay | Tennessee | 47027 | 52 | 0 |
378801 | 378801 | 2020-07-28 | Clay | Tennessee | 47027 | 48 | 0 |
375585 | 375585 | 2020-07-27 | Clay | Tennessee | 47027 | 46 | 0 |
372372 | 372372 | 2020-07-26 | Clay | Tennessee | 47027 | 41 | 0 |
369160 | 369160 | 2020-07-25 | Clay | Tennessee | 47027 | 41 | 0 |
365951 | 365951 | 2020-07-24 | Clay | Tennessee | 47027 | 41 | 0 |
362745 | 362745 | 2020-07-23 | Clay | Tennessee | 47027 | 41 | 0 |
359538 | 359538 | 2020-07-22 | Clay | Tennessee | 47027 | 39 | 0 |
356334 | 356334 | 2020-07-21 | Clay | Tennessee | 47027 | 35 | 0 |
353131 | 353131 | 2020-07-20 | Clay | Tennessee | 47027 | 34 | 0 |
349928 | 349928 | 2020-07-19 | Clay | Tennessee | 47027 | 33 | 0 |
346728 | 346728 | 2020-07-18 | Clay | Tennessee | 47027 | 33 | 0 |
343528 | 343528 | 2020-07-17 | Clay | Tennessee | 47027 | 32 | 0 |
340330 | 340330 | 2020-07-16 | Clay | Tennessee | 47027 | 31 | 0 |
337133 | 337133 | 2020-07-15 | Clay | Tennessee | 47027 | 28 | 0 |
333939 | 333939 | 2020-07-14 | Clay | Tennessee | 47027 | 27 | 0 |
330747 | 330747 | 2020-07-13 | Clay | Tennessee | 47027 | 23 | 0 |
327561 | 327561 | 2020-07-12 | Clay | Tennessee | 47027 | 20 | 0 |
324376 | 324376 | 2020-07-11 | Clay | Tennessee | 47027 | 20 | 0 |
321195 | 321195 | 2020-07-10 | Clay | Tennessee | 47027 | 18 | 0 |
318017 | 318017 | 2020-07-09 | Clay | Tennessee | 47027 | 18 | 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);