ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Knox" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637456 | 637456 | 2020-10-16 | Knox | Tennessee | 47093 | 11975 | 92 |
634210 | 634210 | 2020-10-15 | Knox | Tennessee | 47093 | 11841 | 90 |
630965 | 630965 | 2020-10-14 | Knox | Tennessee | 47093 | 11761 | 90 |
627721 | 627721 | 2020-10-13 | Knox | Tennessee | 47093 | 11683 | 89 |
624479 | 624479 | 2020-10-12 | Knox | Tennessee | 47093 | 11525 | 86 |
621236 | 621236 | 2020-10-11 | Knox | Tennessee | 47093 | 11381 | 86 |
617993 | 617993 | 2020-10-10 | Knox | Tennessee | 47093 | 11272 | 86 |
614751 | 614751 | 2020-10-09 | Knox | Tennessee | 47093 | 11128 | 86 |
611510 | 611510 | 2020-10-08 | Knox | Tennessee | 47093 | 11022 | 85 |
608268 | 608268 | 2020-10-07 | Knox | Tennessee | 47093 | 10929 | 85 |
605025 | 605025 | 2020-10-06 | Knox | Tennessee | 47093 | 10816 | 85 |
601783 | 601783 | 2020-10-05 | Knox | Tennessee | 47093 | 10695 | 85 |
598540 | 598540 | 2020-10-04 | Knox | Tennessee | 47093 | 10610 | 85 |
595297 | 595297 | 2020-10-03 | Knox | Tennessee | 47093 | 10527 | 84 |
592056 | 592056 | 2020-10-02 | Knox | Tennessee | 47093 | 10461 | 84 |
588815 | 588815 | 2020-10-01 | Knox | Tennessee | 47093 | 10395 | 84 |
585575 | 585575 | 2020-09-30 | Knox | Tennessee | 47093 | 10314 | 84 |
582335 | 582335 | 2020-09-29 | Knox | Tennessee | 47093 | 10255 | 83 |
579095 | 579095 | 2020-09-28 | Knox | Tennessee | 47093 | 10197 | 83 |
575854 | 575854 | 2020-09-27 | Knox | Tennessee | 47093 | 10080 | 81 |
572610 | 572610 | 2020-09-26 | Knox | Tennessee | 47093 | 10005 | 80 |
569368 | 569368 | 2020-09-25 | Knox | Tennessee | 47093 | 9893 | 78 |
566127 | 566127 | 2020-09-24 | Knox | Tennessee | 47093 | 9813 | 77 |
562886 | 562886 | 2020-09-23 | Knox | Tennessee | 47093 | 9747 | 77 |
559649 | 559649 | 2020-09-22 | Knox | Tennessee | 47093 | 9692 | 76 |
556412 | 556412 | 2020-09-21 | Knox | Tennessee | 47093 | 9606 | 73 |
553175 | 553175 | 2020-09-20 | Knox | Tennessee | 47093 | 9497 | 73 |
549936 | 549936 | 2020-09-19 | Knox | Tennessee | 47093 | 9421 | 73 |
546697 | 546697 | 2020-09-18 | Knox | Tennessee | 47093 | 9240 | 71 |
543460 | 543460 | 2020-09-17 | Knox | Tennessee | 47093 | 9143 | 68 |
540224 | 540224 | 2020-09-16 | Knox | Tennessee | 47093 | 8983 | 68 |
536987 | 536987 | 2020-09-15 | Knox | Tennessee | 47093 | 8914 | 67 |
533751 | 533751 | 2020-09-14 | Knox | Tennessee | 47093 | 8689 | 67 |
530516 | 530516 | 2020-09-13 | Knox | Tennessee | 47093 | 8612 | 67 |
527279 | 527279 | 2020-09-12 | Knox | Tennessee | 47093 | 8483 | 67 |
524043 | 524043 | 2020-09-11 | Knox | Tennessee | 47093 | 8291 | 66 |
520807 | 520807 | 2020-09-10 | Knox | Tennessee | 47093 | 8160 | 66 |
517571 | 517571 | 2020-09-09 | Knox | Tennessee | 47093 | 8033 | 66 |
514336 | 514336 | 2020-09-08 | Knox | Tennessee | 47093 | 7930 | 66 |
511103 | 511103 | 2020-09-07 | Knox | Tennessee | 47093 | 7842 | 65 |
507870 | 507870 | 2020-09-06 | Knox | Tennessee | 47093 | 7671 | 64 |
504638 | 504638 | 2020-09-05 | Knox | Tennessee | 47093 | 7447 | 64 |
501404 | 501404 | 2020-09-04 | Knox | Tennessee | 47093 | 7283 | 64 |
498170 | 498170 | 2020-09-03 | Knox | Tennessee | 47093 | 7141 | 63 |
494937 | 494937 | 2020-09-02 | Knox | Tennessee | 47093 | 6987 | 61 |
491703 | 491703 | 2020-09-01 | Knox | Tennessee | 47093 | 6876 | 59 |
488470 | 488470 | 2020-08-31 | Knox | Tennessee | 47093 | 6786 | 58 |
485237 | 485237 | 2020-08-30 | Knox | Tennessee | 47093 | 6716 | 57 |
482002 | 482002 | 2020-08-29 | Knox | Tennessee | 47093 | 6578 | 56 |
478768 | 478768 | 2020-08-28 | Knox | Tennessee | 47093 | 6499 | 56 |
475535 | 475535 | 2020-08-27 | Knox | Tennessee | 47093 | 6389 | 56 |
472302 | 472302 | 2020-08-26 | Knox | Tennessee | 47093 | 6286 | 55 |
469070 | 469070 | 2020-08-25 | Knox | Tennessee | 47093 | 6246 | 55 |
465841 | 465841 | 2020-08-24 | Knox | Tennessee | 47093 | 6189 | 53 |
462612 | 462612 | 2020-08-23 | Knox | Tennessee | 47093 | 6078 | 53 |
459384 | 459384 | 2020-08-22 | Knox | Tennessee | 47093 | 6029 | 53 |
456156 | 456156 | 2020-08-21 | Knox | Tennessee | 47093 | 5910 | 52 |
452928 | 452928 | 2020-08-20 | Knox | Tennessee | 47093 | 5858 | 52 |
449700 | 449700 | 2020-08-19 | Knox | Tennessee | 47093 | 5731 | 52 |
446472 | 446472 | 2020-08-18 | Knox | Tennessee | 47093 | 5686 | 51 |
443246 | 443246 | 2020-08-17 | Knox | Tennessee | 47093 | 5623 | 50 |
440019 | 440019 | 2020-08-16 | Knox | Tennessee | 47093 | 5509 | 49 |
436794 | 436794 | 2020-08-15 | Knox | Tennessee | 47093 | 5429 | 49 |
433567 | 433567 | 2020-08-14 | Knox | Tennessee | 47093 | 5317 | 48 |
430342 | 430342 | 2020-08-13 | Knox | Tennessee | 47093 | 5209 | 47 |
427115 | 427115 | 2020-08-12 | Knox | Tennessee | 47093 | 5107 | 45 |
423892 | 423892 | 2020-08-11 | Knox | Tennessee | 47093 | 5035 | 46 |
420670 | 420670 | 2020-08-10 | Knox | Tennessee | 47093 | 4947 | 46 |
417449 | 417449 | 2020-08-09 | Knox | Tennessee | 47093 | 4859 | 45 |
414228 | 414228 | 2020-08-08 | Knox | Tennessee | 47093 | 4748 | 44 |
411008 | 411008 | 2020-08-07 | Knox | Tennessee | 47093 | 4642 | 42 |
407789 | 407789 | 2020-08-06 | Knox | Tennessee | 47093 | 4515 | 42 |
404569 | 404569 | 2020-08-05 | Knox | Tennessee | 47093 | 4440 | 40 |
401351 | 401351 | 2020-08-04 | Knox | Tennessee | 47093 | 4297 | 40 |
398136 | 398136 | 2020-08-03 | Knox | Tennessee | 47093 | 4242 | 39 |
394919 | 394919 | 2020-08-02 | Knox | Tennessee | 47093 | 4126 | 38 |
391703 | 391703 | 2020-08-01 | Knox | Tennessee | 47093 | 4037 | 35 |
388486 | 388486 | 2020-07-31 | Knox | Tennessee | 47093 | 3884 | 33 |
385269 | 385269 | 2020-07-30 | Knox | Tennessee | 47093 | 3760 | 31 |
382051 | 382051 | 2020-07-29 | Knox | Tennessee | 47093 | 3681 | 27 |
378834 | 378834 | 2020-07-28 | Knox | Tennessee | 47093 | 3517 | 27 |
375618 | 375618 | 2020-07-27 | Knox | Tennessee | 47093 | 3345 | 26 |
372405 | 372405 | 2020-07-26 | Knox | Tennessee | 47093 | 3223 | 23 |
369193 | 369193 | 2020-07-25 | Knox | Tennessee | 47093 | 3091 | 23 |
365984 | 365984 | 2020-07-24 | Knox | Tennessee | 47093 | 2967 | 22 |
362778 | 362778 | 2020-07-23 | Knox | Tennessee | 47093 | 2824 | 21 |
359571 | 359571 | 2020-07-22 | Knox | Tennessee | 47093 | 2632 | 21 |
356367 | 356367 | 2020-07-21 | Knox | Tennessee | 47093 | 2539 | 20 |
353164 | 353164 | 2020-07-20 | Knox | Tennessee | 47093 | 2427 | 19 |
349961 | 349961 | 2020-07-19 | Knox | Tennessee | 47093 | 2322 | 18 |
346761 | 346761 | 2020-07-18 | Knox | Tennessee | 47093 | 2251 | 18 |
343561 | 343561 | 2020-07-17 | Knox | Tennessee | 47093 | 2139 | 17 |
340363 | 340363 | 2020-07-16 | Knox | Tennessee | 47093 | 1991 | 17 |
337166 | 337166 | 2020-07-15 | Knox | Tennessee | 47093 | 1915 | 15 |
333972 | 333972 | 2020-07-14 | Knox | Tennessee | 47093 | 1815 | 14 |
330780 | 330780 | 2020-07-13 | Knox | Tennessee | 47093 | 1717 | 13 |
327594 | 327594 | 2020-07-12 | Knox | Tennessee | 47093 | 1642 | 10 |
324409 | 324409 | 2020-07-11 | Knox | Tennessee | 47093 | 1618 | 10 |
321228 | 321228 | 2020-07-10 | Knox | Tennessee | 47093 | 1569 | 10 |
318050 | 318050 | 2020-07-09 | Knox | Tennessee | 47093 | 1521 | 10 |
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);