daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,185 rows where deaths = 3 and province_or_state = "Tennessee" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-12-07 | US | Tennessee | Van Buren | 47175 | 424 | 3 | 0 | 404 | 35.69864497 | -85.45221699 | 2020-12-08 05:27:42 | Van Buren, Tennessee, US |
2020-12-06 | US | Tennessee | Moore | 47127 | 449 | 3 | 0 | 423 | 35.27724699 | -86.36230578 | 2020-12-07 05:26:14 | Moore, Tennessee, US |
2020-12-06 | US | Tennessee | Van Buren | 47175 | 418 | 3 | 0 | 400 | 35.69864497 | -85.45221699 | 2020-12-07 05:26:14 | Van Buren, Tennessee, US |
2020-12-05 | US | Tennessee | Van Buren | 47175 | 416 | 3 | 0 | 394 | 35.69864497 | -85.45221699 | 2020-12-06 05:26:18 | Van Buren, Tennessee, US |
2020-12-04 | US | Tennessee | Van Buren | 47175 | 408 | 3 | 0 | 386 | 35.69864497 | -85.45221699 | 2020-12-05 05:27:36 | Van Buren, Tennessee, US |
2020-11-30 | US | Tennessee | Hancock | 47067 | 196 | 3 | 0 | 180 | 36.52692871 | -83.22375847 | 2020-12-01 05:26:18 | Hancock, Tennessee, US |
2020-11-30 | US | Tennessee | Moore | 47127 | 416 | 3 | 0 | 401 | 35.27724699 | -86.36230578 | 2020-12-01 05:26:18 | Moore, Tennessee, US |
2020-11-29 | US | Tennessee | Cannon | 47015 | 772 | 3 | 0 | 766 | 35.80990797 | -86.05738983 | 2020-11-30 05:26:13 | Cannon, Tennessee, US |
2020-11-29 | US | Tennessee | Hancock | 47067 | 190 | 3 | 0 | 169 | 36.52692871 | -83.22375847 | 2020-11-30 05:26:13 | Hancock, Tennessee, US |
2020-11-29 | US | Tennessee | Moore | 47127 | 403 | 3 | 0 | 391 | 35.27724699 | -86.36230578 | 2020-11-30 05:26:13 | Moore, Tennessee, US |
2020-11-28 | US | Tennessee | Cannon | 47015 | 762 | 3 | 0 | 763 | 35.80990797 | -86.05738983 | 2020-11-29 05:25:55 | Cannon, Tennessee, US |
2020-11-28 | US | Tennessee | Hancock | 47067 | 181 | 3 | 0 | 164 | 36.52692871 | -83.22375847 | 2020-11-29 05:25:55 | Hancock, Tennessee, US |
2020-11-28 | US | Tennessee | Moore | 47127 | 400 | 3 | 0 | 393 | 35.27724699 | -86.36230578 | 2020-11-29 05:25:55 | Moore, Tennessee, US |
2020-11-27 | US | Tennessee | Cannon | 47015 | 740 | 3 | 0 | 726 | 35.80990797 | -86.05738983 | 2020-11-28 05:25:50 | Cannon, Tennessee, US |
2020-11-27 | US | Tennessee | Hancock | 47067 | 173 | 3 | 0 | 153 | 36.52692871 | -83.22375847 | 2020-11-28 05:25:50 | Hancock, Tennessee, US |
2020-11-27 | US | Tennessee | Moore | 47127 | 395 | 3 | 0 | 386 | 35.27724699 | -86.36230578 | 2020-11-28 05:25:50 | Moore, Tennessee, US |
2020-11-26 | US | Tennessee | Cannon | 47015 | 720 | 3 | 0 | 722 | 35.80990797 | -86.05738983 | 2020-11-27 05:26:53 | Cannon, Tennessee, US |
2020-11-26 | US | Tennessee | Hancock | 47067 | 164 | 3 | 0 | 152 | 36.52692871 | -83.22375847 | 2020-11-27 05:26:53 | Hancock, Tennessee, US |
2020-11-26 | US | Tennessee | Moore | 47127 | 390 | 3 | 0 | 380 | 35.27724699 | -86.36230578 | 2020-11-27 05:26:53 | Moore, Tennessee, US |
2020-11-25 | US | Tennessee | Cannon | 47015 | 712 | 3 | 0 | 715 | 35.80990797 | -86.05738983 | 2020-11-26 05:27:44 | Cannon, Tennessee, US |
2020-11-25 | US | Tennessee | Hancock | 47067 | 160 | 3 | 0 | 147 | 36.52692871 | -83.22375847 | 2020-11-26 05:27:44 | Hancock, Tennessee, US |
2020-11-25 | US | Tennessee | Moore | 47127 | 382 | 3 | 0 | 374 | 35.27724699 | -86.36230578 | 2020-11-26 05:27:44 | Moore, Tennessee, US |
2020-11-24 | US | Tennessee | Cannon | 47015 | 709 | 3 | 0 | 710 | 35.80990797 | -86.05738983 | 2020-11-25 05:27:20 | Cannon, Tennessee, US |
2020-11-24 | US | Tennessee | Hancock | 47067 | 157 | 3 | 0 | 144 | 36.52692871 | -83.22375847 | 2020-11-25 05:27:20 | Hancock, Tennessee, US |
2020-11-23 | US | Tennessee | Hancock | 47067 | 156 | 3 | 0 | 144 | 36.52692871 | -83.22375847 | 2020-11-24 05:27:31 | Hancock, Tennessee, US |
2020-11-22 | US | Tennessee | Hancock | 47067 | 156 | 3 | 0 | 142 | 36.52692871 | -83.22375847 | 2020-11-23 05:25:26 | Hancock, Tennessee, US |
2020-11-21 | US | Tennessee | Hancock | 47067 | 150 | 3 | 0 | 137 | 36.52692871 | -83.22375847 | 2020-11-22 05:25:45 | Hancock, Tennessee, US |
2020-11-20 | US | Tennessee | Hancock | 47067 | 149 | 3 | 0 | 135 | 36.52692871 | -83.22375847 | 2020-11-21 05:25:51 | Hancock, Tennessee, US |
2020-11-19 | US | Tennessee | Hancock | 47067 | 147 | 3 | 0 | 135 | 36.52692871 | -83.22375847 | 2020-11-20 05:26:28 | Hancock, Tennessee, US |
2020-11-18 | US | Tennessee | Hancock | 47067 | 146 | 3 | 0 | 132 | 36.52692871 | -83.22375847 | 2020-11-19 05:25:23 | Hancock, Tennessee, US |
2020-11-17 | US | Tennessee | Hancock | 47067 | 144 | 3 | 0 | 131 | 36.52692871 | -83.22375847 | 2020-11-18 05:40:31 | Hancock, Tennessee, US |
2020-11-16 | US | Tennessee | Hancock | 47067 | 143 | 3 | 0 | 130 | 36.52692871 | -83.22375847 | 2020-11-17 05:25:54 | Hancock, Tennessee, US |
2020-11-15 | US | Tennessee | Hancock | 47067 | 142 | 3 | 0 | 128 | 36.52692871 | -83.22375847 | 2020-11-16 05:25:57 | Hancock, Tennessee, US |
2020-11-14 | US | Tennessee | Hancock | 47067 | 138 | 3 | 0 | 126 | 36.52692871 | -83.22375847 | 2020-11-15 05:26:53 | Hancock, Tennessee, US |
2020-11-13 | US | Tennessee | Hancock | 47067 | 138 | 3 | 0 | 124 | 36.52692871 | -83.22375847 | 2020-11-14 05:25:37 | Hancock, Tennessee, US |
2020-11-12 | US | Tennessee | Hancock | 47067 | 137 | 3 | 0 | 124 | 36.52692871 | -83.22375847 | 2020-11-13 05:25:30 | Hancock, Tennessee, US |
2020-11-11 | US | Tennessee | Hancock | 47067 | 137 | 3 | 0 | 124 | 36.52692871 | -83.22375847 | 2020-11-12 05:25:55 | Hancock, Tennessee, US |
2020-11-11 | US | Tennessee | Moore | 47127 | 322 | 3 | 0 | 314 | 35.27724699 | -86.36230578 | 2020-11-12 05:25:55 | Moore, Tennessee, US |
2020-11-10 | US | Tennessee | Hancock | 47067 | 136 | 3 | 0 | 124 | 36.52692871 | -83.22375847 | 2020-11-11 05:25:30 | Hancock, Tennessee, US |
2020-11-10 | US | Tennessee | Moore | 47127 | 320 | 3 | 0 | 310 | 35.27724699 | -86.36230578 | 2020-11-11 05:25:30 | Moore, Tennessee, US |
2020-11-09 | US | Tennessee | Hancock | 47067 | 136 | 3 | 0 | 125 | 36.52692871 | -83.22375847 | 2020-11-10 05:40:07 | Hancock, Tennessee, US |
2020-11-08 | US | Tennessee | Hancock | 47067 | 136 | 3 | 0 | 125 | 36.52692871 | -83.22375847 | 2020-11-09 05:25:45 | Hancock, Tennessee, US |
2020-11-07 | US | Tennessee | Hancock | 47067 | 135 | 3 | 0 | 125 | 36.52692871 | -83.22375847 | 2020-11-08 05:24:56 | Hancock, Tennessee, US |
2020-11-06 | US | Tennessee | Hancock | 47067 | 135 | 3 | 0 | 125 | 36.52692871 | -83.22375847 | 2020-11-07 05:24:52 | Hancock, Tennessee, US |
2020-11-05 | US | Tennessee | Hancock | 47067 | 135 | 3 | 0 | 123 | 36.52692871 | -83.22375847 | 2020-11-06 05:24:55 | Hancock, Tennessee, US |
2020-11-04 | US | Tennessee | Hancock | 47067 | 135 | 3 | 0 | 123 | 36.52692871 | -83.22375847 | 2020-11-05 06:05:03 | Hancock, Tennessee, US |
2020-11-03 | US | Tennessee | Hancock | 47067 | 135 | 3 | 0 | 126 | 36.52692871 | -83.22375847 | 2020-11-04 05:25:09 | Hancock, Tennessee, US |
2020-11-03 | US | Tennessee | Sequatchie | 47153 | 377 | 3 | 0 | 379 | 35.36979721 | -85.41022136 | 2020-11-04 05:25:09 | Sequatchie, Tennessee, US |
2020-11-02 | US | Tennessee | Hancock | 47067 | 135 | 3 | 0 | 126 | 36.52692871 | -83.22375847 | 2020-11-03 06:00:16 | Hancock, Tennessee, US |
2020-11-01 | US | Tennessee | Hancock | 47067 | 134 | 3 | 0 | 125 | 36.52692871 | -83.22375847 | 2020-11-02 05:25:04 | Hancock, Tennessee, US |
2020-10-31 | US | Tennessee | Hancock | 47067 | 134 | 3 | 0 | 125 | 36.52692871 | -83.22375847 | 2020-11-01 04:36:19 | Hancock, Tennessee, US |
2020-10-30 | US | Tennessee | Hancock | 47067 | 134 | 3 | 0 | 124 | 36.52692871 | -83.22375847 | 2020-10-31 04:24:44 | Hancock, Tennessee, US |
2020-10-29 | US | Tennessee | Hancock | 47067 | 131 | 3 | 0 | 122 | 36.52692871 | -83.22375847 | 2020-10-30 04:24:49 | Hancock, Tennessee, US |
2020-10-29 | US | Tennessee | Lincoln | 47103 | 952 | 3 | 0 | 942 | 35.13738622 | -86.58910106 | 2020-10-30 04:24:49 | Lincoln, Tennessee, US |
2020-10-28 | US | Tennessee | Hancock | 47067 | 131 | 3 | 0 | 120 | 36.52692871 | -83.22375847 | 2020-10-29 04:24:49 | Hancock, Tennessee, US |
2020-10-28 | US | Tennessee | Lincoln | 47103 | 937 | 3 | 0 | 928 | 35.13738622 | -86.58910106 | 2020-10-29 04:24:49 | Lincoln, Tennessee, US |
2020-10-28 | US | Tennessee | Unicoi | 47171 | 480 | 3 | 0 | 454 | 36.10890856 | -82.43709629 | 2020-10-29 04:24:49 | Unicoi, Tennessee, US |
2020-10-28 | US | Tennessee | Union | 47173 | 549 | 3 | 0 | 549 | 36.28590426 | -83.83651902 | 2020-10-29 04:24:49 | Union, Tennessee, US |
2020-10-27 | US | Tennessee | Hancock | 47067 | 129 | 3 | 0 | 118 | 36.52692871 | -83.22375847 | 2020-10-28 04:24:39 | Hancock, Tennessee, US |
2020-10-27 | US | Tennessee | Lake | 47095 | 979 | 3 | 0 | 985 | 36.34180170000001 | -89.48921915 | 2020-10-28 04:24:39 | Lake, Tennessee, US |
2020-10-27 | US | Tennessee | Lincoln | 47103 | 927 | 3 | 0 | 922 | 35.13738622 | -86.58910106 | 2020-10-28 04:24:39 | Lincoln, Tennessee, US |
2020-10-27 | US | Tennessee | Unicoi | 47171 | 456 | 3 | 0 | 442 | 36.10890856 | -82.43709629 | 2020-10-28 04:24:39 | Unicoi, Tennessee, US |
2020-10-27 | US | Tennessee | Union | 47173 | 547 | 3 | 0 | 546 | 36.28590426 | -83.83651902 | 2020-10-28 04:24:39 | Union, Tennessee, US |
2020-10-26 | US | Tennessee | Hancock | 47067 | 129 | 3 | 0 | 118 | 36.52692871 | -83.22375847 | 2020-10-27 04:24:45 | Hancock, Tennessee, US |
2020-10-26 | US | Tennessee | Lake | 47095 | 978 | 3 | 0 | 984 | 36.34180170000001 | -89.48921915 | 2020-10-27 04:24:45 | Lake, Tennessee, US |
2020-10-26 | US | Tennessee | Lincoln | 47103 | 921 | 3 | 0 | 914 | 35.13738622 | -86.58910106 | 2020-10-27 04:24:45 | Lincoln, Tennessee, US |
2020-10-26 | US | Tennessee | Unicoi | 47171 | 437 | 3 | 0 | 430 | 36.10890856 | -82.43709629 | 2020-10-27 04:24:45 | Unicoi, Tennessee, US |
2020-10-26 | US | Tennessee | Union | 47173 | 542 | 3 | 0 | 543 | 36.28590426 | -83.83651902 | 2020-10-27 04:24:45 | Union, Tennessee, US |
2020-10-25 | US | Tennessee | Hancock | 47067 | 129 | 3 | 0 | 116 | 36.52692871 | -83.22375847 | 2020-10-26 04:25:02 | Hancock, Tennessee, US |
2020-10-25 | US | Tennessee | Lake | 47095 | 977 | 3 | 0 | 982 | 36.34180170000001 | -89.48921915 | 2020-10-26 04:25:02 | Lake, Tennessee, US |
2020-10-25 | US | Tennessee | Lewis | 47101 | 417 | 3 | 0 | 400 | 35.52853208 | -87.49022694 | 2020-10-26 04:25:02 | Lewis, Tennessee, US |
2020-10-25 | US | Tennessee | Lincoln | 47103 | 912 | 3 | 0 | 894 | 35.13738622 | -86.58910106 | 2020-10-26 04:25:02 | Lincoln, Tennessee, US |
2020-10-25 | US | Tennessee | Unassigned | 90047 | 1538 | 3 | 0 | 2203 | 36.55606529 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Tennessee, US |
2020-10-25 | US | Tennessee | Unicoi | 47171 | 433 | 3 | 0 | 415 | 36.10890856 | -82.43709629 | 2020-10-26 04:25:02 | Unicoi, Tennessee, US |
2020-10-25 | US | Tennessee | Union | 47173 | 540 | 3 | 0 | 540 | 36.28590426 | -83.83651902 | 2020-10-26 04:25:02 | Union, Tennessee, US |
2020-10-24 | US | Tennessee | Hancock | 47067 | 127 | 3 | 0 | 114 | 36.52692871 | -83.22375847 | 2020-10-25 04:24:36 | Hancock, Tennessee, US |
2020-10-24 | US | Tennessee | Lake | 47095 | 975 | 3 | 0 | 980 | 36.34180170000001 | -89.48921915 | 2020-10-25 04:24:36 | Lake, Tennessee, US |
2020-10-24 | US | Tennessee | Lincoln | 47103 | 891 | 3 | 0 | 877 | 35.13738622 | -86.58910106 | 2020-10-25 04:24:36 | Lincoln, Tennessee, US |
2020-10-24 | US | Tennessee | Unicoi | 47171 | 413 | 3 | 0 | 401 | 36.10890856 | -82.43709629 | 2020-10-25 04:24:36 | Unicoi, Tennessee, US |
2020-10-24 | US | Tennessee | Union | 47173 | 537 | 3 | 0 | 535 | 36.28590426 | -83.83651902 | 2020-10-25 04:24:36 | Union, Tennessee, US |
2020-10-23 | US | Tennessee | Hancock | 47067 | 124 | 3 | 0 | 112 | 36.52692871 | -83.22375847 | 2020-10-24 04:24:46 | Hancock, Tennessee, US |
2020-10-23 | US | Tennessee | Lake | 47095 | 974 | 3 | 0 | 977 | 36.34180170000001 | -89.48921915 | 2020-10-24 04:24:46 | Lake, Tennessee, US |
2020-10-23 | US | Tennessee | Lincoln | 47103 | 855 | 3 | 0 | 849 | 35.13738622 | -86.58910106 | 2020-10-24 04:24:46 | Lincoln, Tennessee, US |
2020-10-23 | US | Tennessee | Unicoi | 47171 | 400 | 3 | 0 | 392 | 36.10890856 | -82.43709629 | 2020-10-24 04:24:46 | Unicoi, Tennessee, US |
2020-10-23 | US | Tennessee | Union | 47173 | 521 | 3 | 0 | 520 | 36.28590426 | -83.83651902 | 2020-10-24 04:24:46 | Union, Tennessee, US |
2020-10-22 | US | Tennessee | Hancock | 47067 | 121 | 3 | 0 | 110 | 36.52692871 | -83.22375847 | 2020-10-23 04:24:46 | Hancock, Tennessee, US |
2020-10-22 | US | Tennessee | Lake | 47095 | 972 | 3 | 0 | 972 | 36.34180170000001 | -89.48921915 | 2020-10-23 04:24:46 | Lake, Tennessee, US |
2020-10-22 | US | Tennessee | Lincoln | 47103 | 834 | 3 | 0 | 833 | 35.13738622 | -86.58910106 | 2020-10-23 04:24:46 | Lincoln, Tennessee, US |
2020-10-22 | US | Tennessee | Union | 47173 | 512 | 3 | 0 | 514 | 36.28590426 | -83.83651902 | 2020-10-23 04:24:46 | Union, Tennessee, US |
2020-10-21 | US | Tennessee | Hancock | 47067 | 121 | 3 | 0 | 109 | 36.52692871 | -83.22375847 | 2020-10-22 04:24:27 | Hancock, Tennessee, US |
2020-10-21 | US | Tennessee | Lake | 47095 | 969 | 3 | 0 | 973 | 36.34180170000001 | -89.48921915 | 2020-10-22 04:24:27 | Lake, Tennessee, US |
2020-10-20 | US | Tennessee | Hancock | 47067 | 120 | 3 | 0 | 109 | 36.52692871 | -83.22375847 | 2020-10-21 04:24:14 | Hancock, Tennessee, US |
2020-10-20 | US | Tennessee | Lake | 47095 | 965 | 3 | 0 | 967 | 36.34180170000001 | -89.48921915 | 2020-10-21 04:24:14 | Lake, Tennessee, US |
2020-10-19 | US | Tennessee | Hancock | 47067 | 120 | 3 | 0 | 109 | 36.52692871 | -83.22375847 | 2020-10-20 04:24:22 | Hancock, Tennessee, US |
2020-10-19 | US | Tennessee | Lake | 47095 | 965 | 3 | 0 | 965 | 36.34180170000001 | -89.48921915 | 2020-10-20 04:24:22 | Lake, Tennessee, US |
2020-10-19 | US | Tennessee | Unassigned | 90047 | 1301 | 3 | 0 | 3762 | 36.55606529 | 0.0 | 2020-10-20 04:24:22 | Unassigned, Tennessee, US |
2020-10-18 | US | Tennessee | Hancock | 47067 | 119 | 3 | 0 | 109 | 36.52692871 | -83.22375847 | 2020-10-19 04:24:16 | Hancock, Tennessee, US |
2020-10-18 | US | Tennessee | Lake | 47095 | 960 | 3 | 0 | 959 | 36.34180170000001 | -89.48921915 | 2020-10-19 04:24:16 | Lake, Tennessee, US |
2020-10-18 | US | Tennessee | Unassigned | 90047 | 1276 | 3 | 0 | 3572 | 36.55606529 | 0.0 | 2020-10-19 04:24:16 | Unassigned, Tennessee, US |
2020-10-17 | US | Tennessee | Hancock | 47067 | 119 | 3 | 0 | 110 | 36.52692871 | -83.22375847 | 2020-10-18 04:24:25 | Hancock, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;