daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
705 rows where deaths = 23 and province_or_state = "Tennessee" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-03 | US | Tennessee | Bledsoe | 47007 | 3574 | 23 | 0 | 35.59942968 | -85.20611967 | 2021-12-04 04:22:18 | Bledsoe, Tennessee, US | |
2021-12-02 | US | Tennessee | Bledsoe | 47007 | 3570 | 23 | 0 | 35.59942968 | -85.20611967 | 2021-12-03 04:23:05 | Bledsoe, Tennessee, US | |
2021-11-17 | US | Tennessee | Moore | 47127 | 1449 | 23 | 0 | 35.27724699 | -86.36230578 | 2021-11-18 04:21:33 | Moore, Tennessee, US | |
2021-11-16 | US | Tennessee | Moore | 47127 | 1446 | 23 | 0 | 35.27724699 | -86.36230578 | 2021-11-17 04:21:48 | Moore, Tennessee, US | |
2021-09-13 | US | Tennessee | Trousdale | 47169 | 2919 | 23 | 0 | 36.39026213 | -86.16087954 | 2021-09-14 04:21:41 | Trousdale, Tennessee, US | |
2021-09-12 | US | Tennessee | Trousdale | 47169 | 2913 | 23 | 0 | 36.39026213 | -86.16087954 | 2021-09-13 04:21:15 | Trousdale, Tennessee, US | |
2021-09-11 | US | Tennessee | Trousdale | 47169 | 2912 | 23 | 0 | 36.39026213 | -86.16087954 | 2021-09-12 04:21:13 | Trousdale, Tennessee, US | |
2021-09-10 | US | Tennessee | Trousdale | 47169 | 2897 | 23 | 0 | 36.39026213 | -86.16087954 | 2021-09-11 04:21:30 | Trousdale, Tennessee, US | |
2021-09-09 | US | Tennessee | Trousdale | 47169 | 2874 | 23 | 0 | 36.39026213 | -86.16087954 | 2021-09-10 04:21:20 | Trousdale, Tennessee, US | |
2021-09-08 | US | Tennessee | Trousdale | 47169 | 2867 | 23 | 0 | 36.39026213 | -86.16087954 | 2021-09-09 04:21:27 | Trousdale, Tennessee, US | |
2021-09-01 | US | Tennessee | Van Buren | 47175 | 991 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-09-02 04:21:15 | Van Buren, Tennessee, US | |
2021-08-31 | US | Tennessee | Van Buren | 47175 | 988 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-09-01 04:21:38 | Van Buren, Tennessee, US | |
2021-08-30 | US | Tennessee | Van Buren | 47175 | 979 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-31 04:21:46 | Van Buren, Tennessee, US | |
2021-08-29 | US | Tennessee | Van Buren | 47175 | 973 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-30 04:21:23 | Van Buren, Tennessee, US | |
2021-08-28 | US | Tennessee | Van Buren | 47175 | 971 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-29 04:21:14 | Van Buren, Tennessee, US | |
2021-08-27 | US | Tennessee | Pickett | 47137 | 877 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-28 04:21:28 | Pickett, Tennessee, US | |
2021-08-27 | US | Tennessee | Van Buren | 47175 | 963 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-28 04:21:28 | Van Buren, Tennessee, US | |
2021-08-26 | US | Tennessee | Pickett | 47137 | 866 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-27 04:21:37 | Pickett, Tennessee, US | |
2021-08-26 | US | Tennessee | Van Buren | 47175 | 962 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-27 04:21:37 | Van Buren, Tennessee, US | |
2021-08-25 | US | Tennessee | Pickett | 47137 | 864 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-26 04:21:28 | Pickett, Tennessee, US | |
2021-08-25 | US | Tennessee | Van Buren | 47175 | 957 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-26 04:21:28 | Van Buren, Tennessee, US | |
2021-08-24 | US | Tennessee | Pickett | 47137 | 857 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-25 04:21:41 | Pickett, Tennessee, US | |
2021-08-24 | US | Tennessee | Van Buren | 47175 | 952 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-25 04:21:41 | Van Buren, Tennessee, US | |
2021-08-23 | US | Tennessee | Pickett | 47137 | 846 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-24 04:21:19 | Pickett, Tennessee, US | |
2021-08-23 | US | Tennessee | Van Buren | 47175 | 950 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-24 04:21:19 | Van Buren, Tennessee, US | |
2021-08-22 | US | Tennessee | Pickett | 47137 | 846 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-23 04:21:27 | Pickett, Tennessee, US | |
2021-08-22 | US | Tennessee | Van Buren | 47175 | 946 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-23 04:21:27 | Van Buren, Tennessee, US | |
2021-08-21 | US | Tennessee | Pickett | 47137 | 846 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-22 04:21:29 | Pickett, Tennessee, US | |
2021-08-21 | US | Tennessee | Van Buren | 47175 | 944 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-22 04:21:29 | Van Buren, Tennessee, US | |
2021-08-20 | US | Tennessee | Pickett | 47137 | 843 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-21 04:21:38 | Pickett, Tennessee, US | |
2021-08-20 | US | Tennessee | Van Buren | 47175 | 943 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-21 04:21:38 | Van Buren, Tennessee, US | |
2021-08-19 | US | Tennessee | Pickett | 47137 | 838 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-20 04:21:33 | Pickett, Tennessee, US | |
2021-08-19 | US | Tennessee | Van Buren | 47175 | 940 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-20 04:21:33 | Van Buren, Tennessee, US | |
2021-08-18 | US | Tennessee | Pickett | 47137 | 836 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-19 04:21:15 | Pickett, Tennessee, US | |
2021-08-18 | US | Tennessee | Van Buren | 47175 | 935 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-19 04:21:15 | Van Buren, Tennessee, US | |
2021-08-17 | US | Tennessee | Pickett | 47137 | 833 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-18 04:21:35 | Pickett, Tennessee, US | |
2021-08-17 | US | Tennessee | Van Buren | 47175 | 932 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-18 04:21:35 | Van Buren, Tennessee, US | |
2021-08-16 | US | Tennessee | Pickett | 47137 | 825 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-17 04:21:49 | Pickett, Tennessee, US | |
2021-08-16 | US | Tennessee | Van Buren | 47175 | 928 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-17 04:21:49 | Van Buren, Tennessee, US | |
2021-08-15 | US | Tennessee | Pickett | 47137 | 819 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-16 04:21:31 | Pickett, Tennessee, US | |
2021-08-15 | US | Tennessee | Van Buren | 47175 | 928 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-16 04:21:31 | Van Buren, Tennessee, US | |
2021-08-14 | US | Tennessee | Pickett | 47137 | 818 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-15 04:21:41 | Pickett, Tennessee, US | |
2021-08-14 | US | Tennessee | Van Buren | 47175 | 928 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-15 04:21:41 | Van Buren, Tennessee, US | |
2021-08-13 | US | Tennessee | Pickett | 47137 | 817 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-14 04:21:25 | Pickett, Tennessee, US | |
2021-08-13 | US | Tennessee | Van Buren | 47175 | 925 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-14 04:21:25 | Van Buren, Tennessee, US | |
2021-08-12 | US | Tennessee | Pickett | 47137 | 814 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-13 04:21:24 | Pickett, Tennessee, US | |
2021-08-12 | US | Tennessee | Van Buren | 47175 | 924 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-13 04:21:24 | Van Buren, Tennessee, US | |
2021-08-11 | US | Tennessee | Pickett | 47137 | 806 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-12 04:21:25 | Pickett, Tennessee, US | |
2021-08-11 | US | Tennessee | Van Buren | 47175 | 918 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-12 04:21:25 | Van Buren, Tennessee, US | |
2021-08-10 | US | Tennessee | Pickett | 47137 | 804 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-11 04:21:58 | Pickett, Tennessee, US | |
2021-08-10 | US | Tennessee | Van Buren | 47175 | 914 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-11 04:21:58 | Van Buren, Tennessee, US | |
2021-08-09 | US | Tennessee | Pickett | 47137 | 801 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-10 04:21:27 | Pickett, Tennessee, US | |
2021-08-09 | US | Tennessee | Van Buren | 47175 | 909 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-10 04:21:27 | Van Buren, Tennessee, US | |
2021-08-08 | US | Tennessee | Pickett | 47137 | 798 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-09 04:21:24 | Pickett, Tennessee, US | |
2021-08-08 | US | Tennessee | Van Buren | 47175 | 909 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-09 04:21:24 | Van Buren, Tennessee, US | |
2021-08-07 | US | Tennessee | Pickett | 47137 | 798 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-08 04:21:33 | Pickett, Tennessee, US | |
2021-08-07 | US | Tennessee | Van Buren | 47175 | 904 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-08 04:21:33 | Van Buren, Tennessee, US | |
2021-08-06 | US | Tennessee | Pickett | 47137 | 798 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-07 04:21:30 | Pickett, Tennessee, US | |
2021-08-06 | US | Tennessee | Van Buren | 47175 | 899 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-07 04:21:30 | Van Buren, Tennessee, US | |
2021-08-05 | US | Tennessee | Pickett | 47137 | 798 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-06 04:21:18 | Pickett, Tennessee, US | |
2021-08-05 | US | Tennessee | Van Buren | 47175 | 894 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-06 04:21:18 | Van Buren, Tennessee, US | |
2021-08-04 | US | Tennessee | Pickett | 47137 | 795 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-05 04:21:51 | Pickett, Tennessee, US | |
2021-08-04 | US | Tennessee | Van Buren | 47175 | 889 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-05 04:21:51 | Van Buren, Tennessee, US | |
2021-08-03 | US | Tennessee | Pickett | 47137 | 792 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-04 04:21:25 | Pickett, Tennessee, US | |
2021-08-03 | US | Tennessee | Van Buren | 47175 | 889 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-04 04:21:25 | Van Buren, Tennessee, US | |
2021-08-02 | US | Tennessee | Pickett | 47137 | 791 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-03 04:21:39 | Pickett, Tennessee, US | |
2021-08-02 | US | Tennessee | Van Buren | 47175 | 888 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-03 04:21:39 | Van Buren, Tennessee, US | |
2021-08-01 | US | Tennessee | Pickett | 47137 | 790 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-02 04:21:36 | Pickett, Tennessee, US | |
2021-08-01 | US | Tennessee | Van Buren | 47175 | 887 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-02 04:21:36 | Van Buren, Tennessee, US | |
2021-07-31 | US | Tennessee | Pickett | 47137 | 790 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-08-01 04:21:50 | Pickett, Tennessee, US | |
2021-07-31 | US | Tennessee | Van Buren | 47175 | 887 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-08-01 04:21:50 | Van Buren, Tennessee, US | |
2021-07-30 | US | Tennessee | Pickett | 47137 | 790 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-31 04:21:35 | Pickett, Tennessee, US | |
2021-07-30 | US | Tennessee | Van Buren | 47175 | 887 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-31 04:21:35 | Van Buren, Tennessee, US | |
2021-07-29 | US | Tennessee | Pickett | 47137 | 789 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-30 04:21:34 | Pickett, Tennessee, US | |
2021-07-29 | US | Tennessee | Van Buren | 47175 | 886 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-30 04:21:34 | Van Buren, Tennessee, US | |
2021-07-28 | US | Tennessee | Pickett | 47137 | 789 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-29 04:21:33 | Pickett, Tennessee, US | |
2021-07-28 | US | Tennessee | Van Buren | 47175 | 883 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-29 04:21:33 | Van Buren, Tennessee, US | |
2021-07-27 | US | Tennessee | Pickett | 47137 | 786 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-28 04:21:39 | Pickett, Tennessee, US | |
2021-07-27 | US | Tennessee | Van Buren | 47175 | 881 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-28 04:21:39 | Van Buren, Tennessee, US | |
2021-07-26 | US | Tennessee | Pickett | 47137 | 785 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-27 04:21:18 | Pickett, Tennessee, US | |
2021-07-26 | US | Tennessee | Van Buren | 47175 | 880 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-27 04:21:18 | Van Buren, Tennessee, US | |
2021-07-25 | US | Tennessee | Pickett | 47137 | 783 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-26 04:21:28 | Pickett, Tennessee, US | |
2021-07-25 | US | Tennessee | Van Buren | 47175 | 878 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-26 04:21:28 | Van Buren, Tennessee, US | |
2021-07-24 | US | Tennessee | Pickett | 47137 | 783 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-25 04:22:12 | Pickett, Tennessee, US | |
2021-07-24 | US | Tennessee | Van Buren | 47175 | 878 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-25 04:22:12 | Van Buren, Tennessee, US | |
2021-07-23 | US | Tennessee | Pickett | 47137 | 783 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-24 00:21:36 | Pickett, Tennessee, US | |
2021-07-23 | US | Tennessee | Van Buren | 47175 | 878 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-24 00:21:36 | Van Buren, Tennessee, US | |
2021-07-22 | US | Tennessee | Pickett | 47137 | 783 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-23 04:21:29 | Pickett, Tennessee, US | |
2021-07-22 | US | Tennessee | Van Buren | 47175 | 877 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-23 04:21:29 | Van Buren, Tennessee, US | |
2021-07-21 | US | Tennessee | Pickett | 47137 | 782 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-22 04:21:19 | Pickett, Tennessee, US | |
2021-07-21 | US | Tennessee | Van Buren | 47175 | 876 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-22 04:21:19 | Van Buren, Tennessee, US | |
2021-07-20 | US | Tennessee | Pickett | 47137 | 781 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-21 04:21:40 | Pickett, Tennessee, US | |
2021-07-20 | US | Tennessee | Van Buren | 47175 | 875 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-21 04:21:40 | Van Buren, Tennessee, US | |
2021-07-19 | US | Tennessee | Pickett | 47137 | 781 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-20 04:21:48 | Pickett, Tennessee, US | |
2021-07-19 | US | Tennessee | Van Buren | 47175 | 875 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-20 04:21:48 | Van Buren, Tennessee, US | |
2021-07-18 | US | Tennessee | Pickett | 47137 | 781 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-19 04:21:24 | Pickett, Tennessee, US | |
2021-07-18 | US | Tennessee | Van Buren | 47175 | 874 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-19 04:21:24 | Van Buren, Tennessee, US | |
2021-07-17 | US | Tennessee | Pickett | 47137 | 781 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-18 04:22:07 | Pickett, Tennessee, US | |
2021-07-17 | US | Tennessee | Van Buren | 47175 | 874 | 23 | 0 | 35.69864497 | -85.45221699 | 2021-07-18 04:22:07 | Van Buren, Tennessee, US | |
2021-07-16 | US | Tennessee | Pickett | 47137 | 781 | 23 | 0 | 36.55606529 | -85.07763299999998 | 2021-07-17 04:22:22 | Pickett, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;