daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
649 rows where deaths = 6 and province_or_state = "Tennessee" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-01-20 | US | Tennessee | Hancock | 47067 | 446 | 6 | 0 | 401 | 36.52692871 | -83.22375847 | 2021-01-21 05:22:01 | Hancock, Tennessee, US |
2021-01-19 | US | Tennessee | Hancock | 47067 | 442 | 6 | 0 | 399 | 36.52692871 | -83.22375847 | 2021-01-20 05:21:54 | Hancock, Tennessee, US |
2021-01-18 | US | Tennessee | Hancock | 47067 | 441 | 6 | 0 | 399 | 36.52692871 | -83.22375847 | 2021-01-19 05:22:15 | Hancock, Tennessee, US |
2021-01-17 | US | Tennessee | Hancock | 47067 | 440 | 6 | 0 | 396 | 36.52692871 | -83.22375847 | 2021-01-18 05:22:34 | Hancock, Tennessee, US |
2021-01-16 | US | Tennessee | Hancock | 47067 | 438 | 6 | 0 | 396 | 36.52692871 | -83.22375847 | 2021-01-17 05:22:17 | Hancock, Tennessee, US |
2021-01-15 | US | Tennessee | Hancock | 47067 | 431 | 6 | 0 | 392 | 36.52692871 | -83.22375847 | 2021-01-16 05:22:40 | Hancock, Tennessee, US |
2021-01-14 | US | Tennessee | Hancock | 47067 | 430 | 6 | 0 | 387 | 36.52692871 | -83.22375847 | 2021-01-15 05:22:24 | Hancock, Tennessee, US |
2021-01-13 | US | Tennessee | Hancock | 47067 | 422 | 6 | 0 | 383 | 36.52692871 | -83.22375847 | 2021-01-14 05:22:32 | Hancock, Tennessee, US |
2021-01-12 | US | Tennessee | Hancock | 47067 | 417 | 6 | 0 | 378 | 36.52692871 | -83.22375847 | 2021-01-13 05:22:15 | Hancock, Tennessee, US |
2021-01-12 | US | Tennessee | Moore | 47127 | 831 | 6 | 0 | 769 | 35.27724699 | -86.36230578 | 2021-01-13 05:22:15 | Moore, Tennessee, US |
2021-01-11 | US | Tennessee | Hancock | 47067 | 411 | 6 | 0 | 374 | 36.52692871 | -83.22375847 | 2021-01-12 05:22:15 | Hancock, Tennessee, US |
2021-01-11 | US | Tennessee | Moore | 47127 | 826 | 6 | 0 | 767 | 35.27724699 | -86.36230578 | 2021-01-12 05:22:15 | Moore, Tennessee, US |
2021-01-10 | US | Tennessee | Hancock | 47067 | 408 | 6 | 0 | 375 | 36.52692871 | -83.22375847 | 2021-01-11 05:21:50 | Hancock, Tennessee, US |
2021-01-10 | US | Tennessee | Moore | 47127 | 820 | 6 | 0 | 764 | 35.27724699 | -86.36230578 | 2021-01-11 05:21:50 | Moore, Tennessee, US |
2021-01-09 | US | Tennessee | Hancock | 47067 | 405 | 6 | 0 | 370 | 36.52692871 | -83.22375847 | 2021-01-10 05:22:12 | Hancock, Tennessee, US |
2021-01-09 | US | Tennessee | Moore | 47127 | 816 | 6 | 0 | 758 | 35.27724699 | -86.36230578 | 2021-01-10 05:22:12 | Moore, Tennessee, US |
2021-01-09 | US | Tennessee | Van Buren | 47175 | 701 | 6 | 0 | 606 | 35.69864497 | -85.45221699 | 2021-01-10 05:22:12 | Van Buren, Tennessee, US |
2021-01-08 | US | Tennessee | Hancock | 47067 | 401 | 6 | 0 | 362 | 36.52692871 | -83.22375847 | 2021-01-09 05:22:18 | Hancock, Tennessee, US |
2021-01-08 | US | Tennessee | Moore | 47127 | 804 | 6 | 0 | 749 | 35.27724699 | -86.36230578 | 2021-01-09 05:22:18 | Moore, Tennessee, US |
2021-01-08 | US | Tennessee | Van Buren | 47175 | 689 | 6 | 0 | 598 | 35.69864497 | -85.45221699 | 2021-01-09 05:22:18 | Van Buren, Tennessee, US |
2021-01-07 | US | Tennessee | Moore | 47127 | 802 | 6 | 0 | 747 | 35.27724699 | -86.36230578 | 2021-01-08 05:22:42 | Moore, Tennessee, US |
2021-01-07 | US | Tennessee | Van Buren | 47175 | 682 | 6 | 0 | 593 | 35.69864497 | -85.45221699 | 2021-01-08 05:22:42 | Van Buren, Tennessee, US |
2021-01-06 | US | Tennessee | Moore | 47127 | 790 | 6 | 0 | 727 | 35.27724699 | -86.36230578 | 2021-01-07 05:22:03 | Moore, Tennessee, US |
2021-01-06 | US | Tennessee | Van Buren | 47175 | 659 | 6 | 0 | 575 | 35.69864497 | -85.45221699 | 2021-01-07 05:22:03 | Van Buren, Tennessee, US |
2021-01-05 | US | Tennessee | Moore | 47127 | 778 | 6 | 0 | 722 | 35.27724699 | -86.36230578 | 2021-01-06 05:22:16 | Moore, Tennessee, US |
2021-01-05 | US | Tennessee | Van Buren | 47175 | 655 | 6 | 0 | 571 | 35.69864497 | -85.45221699 | 2021-01-06 05:22:16 | Van Buren, Tennessee, US |
2021-01-04 | US | Tennessee | Moore | 47127 | 770 | 6 | 0 | 714 | 35.27724699 | -86.36230578 | 2021-01-05 05:21:49 | Moore, Tennessee, US |
2021-01-04 | US | Tennessee | Van Buren | 47175 | 646 | 6 | 0 | 566 | 35.69864497 | -85.45221699 | 2021-01-05 05:21:49 | Van Buren, Tennessee, US |
2021-01-03 | US | Tennessee | Moore | 47127 | 766 | 6 | 0 | 713 | 35.27724699 | -86.36230578 | 2021-01-04 05:22:02 | Moore, Tennessee, US |
2021-01-03 | US | Tennessee | Van Buren | 47175 | 642 | 6 | 0 | 563 | 35.69864497 | -85.45221699 | 2021-01-04 05:22:02 | Van Buren, Tennessee, US |
2021-01-02 | US | Tennessee | Moore | 47127 | 765 | 6 | 0 | 709 | 35.27724699 | -86.36230578 | 2021-01-03 05:22:52 | Moore, Tennessee, US |
2021-01-02 | US | Tennessee | Van Buren | 47175 | 636 | 6 | 0 | 556 | 35.69864497 | -85.45221699 | 2021-01-03 05:22:52 | Van Buren, Tennessee, US |
2021-01-01 | US | Tennessee | Moore | 47127 | 757 | 6 | 0 | 695 | 35.27724699 | -86.36230578 | 2021-01-02 05:22:33 | Moore, Tennessee, US |
2021-01-01 | US | Tennessee | Van Buren | 47175 | 623 | 6 | 0 | 539 | 35.69864497 | -85.45221699 | 2021-01-02 05:22:33 | Van Buren, Tennessee, US |
2020-12-31 | US | Tennessee | Moore | 47127 | 749 | 6 | 0 | 695 | 35.27724699 | -86.36230578 | 2021-01-01 05:23:07 | Moore, Tennessee, US |
2020-12-31 | US | Tennessee | Van Buren | 47175 | 618 | 6 | 0 | 539 | 35.69864497 | -85.45221699 | 2021-01-01 05:23:07 | Van Buren, Tennessee, US |
2020-12-30 | US | Tennessee | Moore | 47127 | 745 | 6 | 0 | 678 | 35.27724699 | -86.36230578 | 2020-12-31 05:22:49 | Moore, Tennessee, US |
2020-12-30 | US | Tennessee | Van Buren | 47175 | 599 | 6 | 0 | 535 | 35.69864497 | -85.45221699 | 2020-12-31 05:22:49 | Van Buren, Tennessee, US |
2020-12-29 | US | Tennessee | Moore | 47127 | 723 | 6 | 0 | 666 | 35.27724699 | -86.36230578 | 2020-12-30 05:22:34 | Moore, Tennessee, US |
2020-12-29 | US | Tennessee | Van Buren | 47175 | 596 | 6 | 0 | 531 | 35.69864497 | -85.45221699 | 2020-12-30 05:22:34 | Van Buren, Tennessee, US |
2020-12-28 | US | Tennessee | Moore | 47127 | 717 | 6 | 0 | 664 | 35.27724699 | -86.36230578 | 2020-12-29 05:22:37 | Moore, Tennessee, US |
2020-12-28 | US | Tennessee | Van Buren | 47175 | 593 | 6 | 0 | 530 | 35.69864497 | -85.45221699 | 2020-12-29 05:22:37 | Van Buren, Tennessee, US |
2020-12-27 | US | Tennessee | Moore | 47127 | 716 | 6 | 0 | 660 | 35.27724699 | -86.36230578 | 2020-12-28 05:22:06 | Moore, Tennessee, US |
2020-12-27 | US | Tennessee | Van Buren | 47175 | 593 | 6 | 0 | 527 | 35.69864497 | -85.45221699 | 2020-12-28 05:22:06 | Van Buren, Tennessee, US |
2020-12-26 | US | Tennessee | Moore | 47127 | 711 | 6 | 0 | 649 | 35.27724699 | -86.36230578 | 2020-12-27 05:22:55 | Moore, Tennessee, US |
2020-12-26 | US | Tennessee | Van Buren | 47175 | 587 | 6 | 0 | 528 | 35.69864497 | -85.45221699 | 2020-12-27 05:22:55 | Van Buren, Tennessee, US |
2020-12-25 | US | Tennessee | Moore | 47127 | 701 | 6 | 0 | 631 | 35.27724699 | -86.36230578 | 2020-12-26 05:22:28 | Moore, Tennessee, US |
2020-12-25 | US | Tennessee | Van Buren | 47175 | 586 | 6 | 0 | 513 | 35.69864497 | -85.45221699 | 2020-12-26 05:22:28 | Van Buren, Tennessee, US |
2020-12-24 | US | Tennessee | Moore | 47127 | 694 | 6 | 0 | 631 | 35.27724699 | -86.36230578 | 2020-12-25 05:22:48 | Moore, Tennessee, US |
2020-12-24 | US | Tennessee | Van Buren | 47175 | 579 | 6 | 0 | 513 | 35.69864497 | -85.45221699 | 2020-12-25 05:22:48 | Van Buren, Tennessee, US |
2020-12-23 | US | Tennessee | Van Buren | 47175 | 563 | 6 | 0 | 513 | 35.69864497 | -85.45221699 | 2020-12-24 05:23:04 | Van Buren, Tennessee, US |
2020-12-19 | US | Tennessee | Bledsoe | 47007 | 1483 | 6 | 0 | 1425 | 35.59942968 | -85.20611967 | 2020-12-20 05:27:32 | Bledsoe, Tennessee, US |
2020-12-18 | US | Tennessee | Bledsoe | 47007 | 1465 | 6 | 0 | 1425 | 35.59942968 | -85.20611967 | 2020-12-19 05:27:52 | Bledsoe, Tennessee, US |
2020-12-17 | US | Tennessee | Bledsoe | 47007 | 1443 | 6 | 0 | 1395 | 35.59942968 | -85.20611967 | 2020-12-18 05:28:18 | Bledsoe, Tennessee, US |
2020-12-17 | US | Tennessee | Sequatchie | 47153 | 900 | 6 | 0 | 915 | 35.36979721 | -85.41022136 | 2020-12-18 05:28:18 | Sequatchie, Tennessee, US |
2020-12-16 | US | Tennessee | Bledsoe | 47007 | 1424 | 6 | 0 | 1374 | 35.59942968 | -85.20611967 | 2020-12-17 05:28:12 | Bledsoe, Tennessee, US |
2020-12-15 | US | Tennessee | Bledsoe | 47007 | 1405 | 6 | 0 | 1365 | 35.59942968 | -85.20611967 | 2020-12-16 05:28:04 | Bledsoe, Tennessee, US |
2020-12-14 | US | Tennessee | Bledsoe | 47007 | 1388 | 6 | 0 | 1356 | 35.59942968 | -85.20611967 | 2020-12-15 05:26:38 | Bledsoe, Tennessee, US |
2020-12-14 | US | Tennessee | Union | 47173 | 1018 | 6 | 0 | 1007 | 36.28590426 | -83.83651902 | 2020-12-15 05:26:38 | Union, Tennessee, US |
2020-12-13 | US | Tennessee | Bledsoe | 47007 | 1377 | 6 | 0 | 1341 | 35.59942968 | -85.20611967 | 2020-12-14 05:26:27 | Bledsoe, Tennessee, US |
2020-12-13 | US | Tennessee | Union | 47173 | 989 | 6 | 0 | 946 | 36.28590426 | -83.83651902 | 2020-12-14 05:26:27 | Union, Tennessee, US |
2020-12-12 | US | Tennessee | Bledsoe | 47007 | 1355 | 6 | 0 | 1319 | 35.59942968 | -85.20611967 | 2020-12-13 05:27:20 | Bledsoe, Tennessee, US |
2020-12-12 | US | Tennessee | Union | 47173 | 909 | 6 | 0 | 889 | 36.28590426 | -83.83651902 | 2020-12-13 05:27:20 | Union, Tennessee, US |
2020-12-11 | US | Tennessee | Bledsoe | 47007 | 1337 | 6 | 0 | 1315 | 35.59942968 | -85.20611967 | 2020-12-12 05:26:19 | Bledsoe, Tennessee, US |
2020-12-11 | US | Tennessee | Union | 47173 | 885 | 6 | 0 | 874 | 36.28590426 | -83.83651902 | 2020-12-12 05:26:19 | Union, Tennessee, US |
2020-12-10 | US | Tennessee | Union | 47173 | 873 | 6 | 0 | 856 | 36.28590426 | -83.83651902 | 2020-12-11 05:26:59 | Union, Tennessee, US |
2020-12-03 | US | Tennessee | Lake | 47095 | 1205 | 6 | 0 | 1187 | 36.34180170000001 | -89.48921915 | 2020-12-04 05:27:27 | Lake, Tennessee, US |
2020-12-03 | US | Tennessee | Morgan | 47129 | 820 | 6 | 0 | 793 | 36.13248031 | -84.64880098 | 2020-12-04 05:27:27 | Morgan, Tennessee, US |
2020-12-02 | US | Tennessee | Lake | 47095 | 1189 | 6 | 0 | 1183 | 36.34180170000001 | -89.48921915 | 2020-12-03 05:28:22 | Lake, Tennessee, US |
2020-12-02 | US | Tennessee | Morgan | 47129 | 805 | 6 | 0 | 782 | 36.13248031 | -84.64880098 | 2020-12-03 05:28:22 | Morgan, Tennessee, US |
2020-12-01 | US | Tennessee | Lake | 47095 | 1187 | 6 | 0 | 1176 | 36.34180170000001 | -89.48921915 | 2020-12-02 05:27:41 | Lake, Tennessee, US |
2020-12-01 | US | Tennessee | Morgan | 47129 | 800 | 6 | 0 | 774 | 36.13248031 | -84.64880098 | 2020-12-02 05:27:41 | Morgan, Tennessee, US |
2020-11-30 | US | Tennessee | Lake | 47095 | 1178 | 6 | 0 | 1172 | 36.34180170000001 | -89.48921915 | 2020-12-01 05:26:18 | Lake, Tennessee, US |
2020-11-30 | US | Tennessee | Morgan | 47129 | 788 | 6 | 0 | 756 | 36.13248031 | -84.64880098 | 2020-12-01 05:26:18 | Morgan, Tennessee, US |
2020-11-29 | US | Tennessee | Lake | 47095 | 1175 | 6 | 0 | 1172 | 36.34180170000001 | -89.48921915 | 2020-11-30 05:26:13 | Lake, Tennessee, US |
2020-11-29 | US | Tennessee | Morgan | 47129 | 759 | 6 | 0 | 733 | 36.13248031 | -84.64880098 | 2020-11-30 05:26:13 | Morgan, Tennessee, US |
2020-11-28 | US | Tennessee | Lake | 47095 | 1175 | 6 | 0 | 1170 | 36.34180170000001 | -89.48921915 | 2020-11-29 05:25:55 | Lake, Tennessee, US |
2020-11-28 | US | Tennessee | Morgan | 47129 | 745 | 6 | 0 | 724 | 36.13248031 | -84.64880098 | 2020-11-29 05:25:55 | Morgan, Tennessee, US |
2020-11-27 | US | Tennessee | Lake | 47095 | 1171 | 6 | 0 | 1159 | 36.34180170000001 | -89.48921915 | 2020-11-28 05:25:50 | Lake, Tennessee, US |
2020-11-27 | US | Tennessee | Morgan | 47129 | 732 | 6 | 0 | 703 | 36.13248031 | -84.64880098 | 2020-11-28 05:25:50 | Morgan, Tennessee, US |
2020-11-26 | US | Tennessee | Lake | 47095 | 1162 | 6 | 0 | 1157 | 36.34180170000001 | -89.48921915 | 2020-11-27 05:26:53 | Lake, Tennessee, US |
2020-11-26 | US | Tennessee | Morgan | 47129 | 714 | 6 | 0 | 689 | 36.13248031 | -84.64880098 | 2020-11-27 05:26:53 | Morgan, Tennessee, US |
2020-11-25 | US | Tennessee | Morgan | 47129 | 695 | 6 | 0 | 682 | 36.13248031 | -84.64880098 | 2020-11-26 05:27:44 | Morgan, Tennessee, US |
2020-11-24 | US | Tennessee | Morgan | 47129 | 688 | 6 | 0 | 673 | 36.13248031 | -84.64880098 | 2020-11-25 05:27:20 | Morgan, Tennessee, US |
2020-11-23 | US | Tennessee | Morgan | 47129 | 684 | 6 | 0 | 666 | 36.13248031 | -84.64880098 | 2020-11-24 05:27:31 | Morgan, Tennessee, US |
2020-11-22 | US | Tennessee | Morgan | 47129 | 679 | 6 | 0 | 648 | 36.13248031 | -84.64880098 | 2020-11-23 05:25:26 | Morgan, Tennessee, US |
2020-11-21 | US | Tennessee | Morgan | 47129 | 657 | 6 | 0 | 633 | 36.13248031 | -84.64880098 | 2020-11-22 05:25:45 | Morgan, Tennessee, US |
2020-11-20 | US | Tennessee | Morgan | 47129 | 640 | 6 | 0 | 603 | 36.13248031 | -84.64880098 | 2020-11-21 05:25:51 | Morgan, Tennessee, US |
2020-11-19 | US | Tennessee | Morgan | 47129 | 614 | 6 | 0 | 594 | 36.13248031 | -84.64880098 | 2020-11-20 05:26:28 | Morgan, Tennessee, US |
2020-11-19 | US | Tennessee | Scott | 47151 | 853 | 6 | 0 | 837 | 36.42325673 | -84.50360494 | 2020-11-20 05:26:28 | Scott, Tennessee, US |
2020-11-18 | US | Tennessee | Morgan | 47129 | 608 | 6 | 0 | 588 | 36.13248031 | -84.64880098 | 2020-11-19 05:25:23 | Morgan, Tennessee, US |
2020-11-18 | US | Tennessee | Scott | 47151 | 830 | 6 | 0 | 796 | 36.42325673 | -84.50360494 | 2020-11-19 05:25:23 | Scott, Tennessee, US |
2020-11-17 | US | Tennessee | Morgan | 47129 | 598 | 6 | 0 | 575 | 36.13248031 | -84.64880098 | 2020-11-18 05:40:31 | Morgan, Tennessee, US |
2020-11-17 | US | Tennessee | Scott | 47151 | 789 | 6 | 0 | 775 | 36.42325673 | -84.50360494 | 2020-11-18 05:40:31 | Scott, Tennessee, US |
2020-11-16 | US | Tennessee | Humphreys | 47085 | 620 | 6 | 0 | 600 | 36.03958805 | -87.77992872 | 2020-11-17 05:25:54 | Humphreys, Tennessee, US |
2020-11-16 | US | Tennessee | Morgan | 47129 | 592 | 6 | 0 | 573 | 36.13248031 | -84.64880098 | 2020-11-17 05:25:54 | Morgan, Tennessee, US |
2020-11-16 | US | Tennessee | Scott | 47151 | 776 | 6 | 0 | 758 | 36.42325673 | -84.50360494 | 2020-11-17 05:25:54 | Scott, Tennessee, US |
2020-11-15 | US | Tennessee | Humphreys | 47085 | 611 | 6 | 0 | 585 | 36.03958805 | -87.77992872 | 2020-11-16 05:25:57 | Humphreys, Tennessee, US |
2020-11-15 | US | Tennessee | Morgan | 47129 | 583 | 6 | 0 | 562 | 36.13248031 | -84.64880098 | 2020-11-16 05:25:57 | Morgan, Tennessee, US |
2020-11-15 | US | Tennessee | Scott | 47151 | 759 | 6 | 0 | 715 | 36.42325673 | -84.50360494 | 2020-11-16 05:25:57 | Scott, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;