daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
98,183 rows where province_or_state = "Tennessee" sorted by fips
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-09 | US | Tennessee | Anderson | 47001 | 23389 | 349 | 0 | 36.12684348 | -84.19965764 | 2022-07-10 04:20:54 | Anderson, Tennessee, US | |
2020-08-15 | US | Tennessee | Anderson | 47001 | 776 | 6 | 0 | 748 | 36.12684348 | -84.19965764 | 2020-08-16 04:27:42 | Anderson, Tennessee, US |
2021-11-29 | US | Tennessee | Anderson | 47001 | 13577 | 234 | 0 | 36.12684348 | -84.19965764 | 2021-11-30 04:22:53 | Anderson, Tennessee, US | |
2021-01-08 | US | Tennessee | Anderson | 47001 | 6373 | 86 | 0 | 6182 | 36.12684348 | -84.19965764 | 2021-01-09 05:22:18 | Anderson, Tennessee, US |
2022-03-29 | US | Tennessee | Anderson | 47001 | 22168 | 324 | 0 | 36.12684348 | -84.19965764 | 2022-03-30 04:20:45 | Anderson, Tennessee, US | |
2021-11-19 | US | Tennessee | Anderson | 47001 | 13432 | 232 | 0 | 36.12684348 | -84.19965764 | 2021-11-20 04:22:17 | Anderson, Tennessee, US | |
2022-06-21 | US | Tennessee | Anderson | 47001 | 22957 | 346 | 0 | 36.12684348 | -84.19965764 | 2022-06-22 04:20:54 | Anderson, Tennessee, US | |
2021-04-16 | US | Tennessee | Anderson | 47001 | 8503 | 170 | 0 | 36.12684348 | -84.19965764 | 2021-04-17 04:20:40 | Anderson, Tennessee, US | |
2020-07-27 | US | Tennessee | Anderson | 47001 | 483 | 4 | 0 | 465 | 36.12684348 | -84.19965764 | 2020-07-28 04:58:43 | Anderson, Tennessee, US |
2021-09-02 | US | Tennessee | Anderson | 47001 | 10622 | 184 | 0 | 36.12684348 | -84.19965764 | 2021-09-03 04:21:20 | Anderson, Tennessee, US | |
2021-02-21 | US | Tennessee | Anderson | 47001 | 7764 | 152 | 0 | 7701 | 36.12684348 | -84.19965764 | 2021-02-22 05:24:21 | Anderson, Tennessee, US |
2022-02-13 | US | Tennessee | Anderson | 47001 | 21538 | 301 | 0 | 36.12684348 | -84.19965764 | 2022-02-14 04:20:51 | Anderson, Tennessee, US | |
2021-01-11 | US | Tennessee | Anderson | 47001 | 6576 | 91 | 0 | 6382 | 36.12684348 | -84.19965764 | 2021-01-12 05:22:15 | Anderson, Tennessee, US |
2020-08-31 | US | Tennessee | Anderson | 47001 | 902 | 8 | 0 | 866 | 36.12684348 | -84.19965764 | 2020-09-01 04:28:31 | Anderson, Tennessee, US |
2022-10-19 | US | Tennessee | Anderson | 47001 | 26168 | 370 | 0 | 36.12684348 | -84.19965764 | 2022-10-20 04:22:59 | Anderson, Tennessee, US | |
2020-12-25 | US | Tennessee | Anderson | 47001 | 5361 | 55 | 0 | 5163 | 36.12684348 | -84.19965764 | 2020-12-26 05:22:28 | Anderson, Tennessee, US |
2020-08-19 | US | Tennessee | Anderson | 47001 | 820 | 6 | 0 | 793 | 36.12684348 | -84.19965764 | 2020-08-20 04:27:43 | Anderson, Tennessee, US |
2020-10-29 | US | Tennessee | Anderson | 47001 | 1813 | 14 | 0 | 1799 | 36.12684348 | -84.19965764 | 2020-10-30 04:24:49 | Anderson, Tennessee, US |
2020-06-08 | US | Tennessee | Anderson | 47001 | 46 | 2 | 0 | 46 | 36.12684348 | -84.19965764 | 2020-06-09 03:33:03 | Anderson, Tennessee, US |
2022-12-26 | US | Tennessee | Anderson | 47001 | 26910 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-27 04:21:07 | Anderson, Tennessee, US | |
2022-05-09 | US | Tennessee | Anderson | 47001 | 22347 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-05-10 04:20:50 | Anderson, Tennessee, US | |
2020-04-30 | US | Tennessee | Anderson | 47001 | 26 | 1 | 0 | 27 | 36.12684348 | -84.19965764 | 2020-05-01 02:32:28 | Anderson, Tennessee, US |
2022-05-31 | US | Tennessee | Anderson | 47001 | 22575 | 342 | 0 | 36.12684348 | -84.19965764 | 2022-06-01 04:20:55 | Anderson, Tennessee, US | |
2022-02-11 | US | Tennessee | Anderson | 47001 | 21486 | 301 | 0 | 36.12684348 | -84.19965764 | 2022-02-12 04:21:06 | Anderson, Tennessee, US | |
2021-01-18 | US | Tennessee | Anderson | 47001 | 6907 | 103 | 0 | 6689 | 36.12684348 | -84.19965764 | 2021-01-19 05:22:15 | Anderson, Tennessee, US |
2021-04-02 | US | Tennessee | Anderson | 47001 | 8384 | 165 | 0 | 36.12684348 | -84.19965764 | 2021-04-03 04:20:44 | Anderson, Tennessee, US | |
2021-08-17 | US | Tennessee | Anderson | 47001 | 9596 | 181 | 0 | 36.12684348 | -84.19965764 | 2021-08-18 04:21:35 | Anderson, Tennessee, US | |
2021-09-04 | US | Tennessee | Anderson | 47001 | 10757 | 184 | 0 | 36.12684348 | -84.19965764 | 2021-09-05 04:21:33 | Anderson, Tennessee, US | |
2022-09-08 | US | Tennessee | Anderson | 47001 | 25720 | 365 | 0 | 36.12684348 | -84.19965764 | 2022-09-09 04:21:11 | Anderson, Tennessee, US | |
2022-12-10 | US | Tennessee | Anderson | 47001 | 26682 | 381 | 0 | 36.12684348 | -84.19965764 | 2022-12-11 04:20:50 | Anderson, Tennessee, US | |
2022-03-15 | US | Tennessee | Anderson | 47001 | 22149 | 319 | 0 | 36.12684348 | -84.19965764 | 2022-03-16 04:20:50 | Anderson, Tennessee, US | |
2020-05-21 | US | Tennessee | Anderson | 47001 | 37 | 1 | 0 | 36 | 36.12684348 | -84.19965764 | 2020-05-22 02:36:51 | Anderson, Tennessee, US |
2020-04-28 | US | Tennessee | Anderson | 47001 | 22 | 1 | 0 | 23 | 36.12684348 | -84.19965764 | 2020-04-29 02:32:29 | Anderson, Tennessee, US |
2020-11-10 | US | Tennessee | Anderson | 47001 | 2166 | 18 | 0 | 2167 | 36.12684348 | -84.19965764 | 2020-11-11 05:25:30 | Anderson, Tennessee, US |
2021-11-03 | US | Tennessee | Anderson | 47001 | 13164 | 221 | 0 | 36.12684348 | -84.19965764 | 2021-11-04 04:22:20 | Anderson, Tennessee, US | |
2021-02-24 | US | Tennessee | Anderson | 47001 | 7825 | 155 | 0 | 7738 | 36.12684348 | -84.19965764 | 2021-02-25 05:24:57 | Anderson, Tennessee, US |
2020-06-15 | US | Tennessee | Anderson | 47001 | 60 | 2 | 0 | 58 | 36.12684348 | -84.19965764 | 2020-06-16 04:33:09 | Anderson, Tennessee, US |
2021-10-31 | US | Tennessee | Anderson | 47001 | 13087 | 217 | 0 | 36.12684348 | -84.19965764 | 2021-11-01 04:22:01 | Anderson, Tennessee, US | |
2022-11-15 | US | Tennessee | Anderson | 47001 | 26456 | 375 | 0 | 36.12684348 | -84.19965764 | 2022-11-16 04:21:09 | Anderson, Tennessee, US | |
2021-07-15 | US | Tennessee | Anderson | 47001 | 8843 | 176 | 0 | 36.12684348 | -84.19965764 | 2021-07-16 04:21:22 | Anderson, Tennessee, US | |
2020-07-01 | US | Tennessee | Anderson | 47001 | 104 | 2 | 0 | 102 | 36.12684348 | -84.19965764 | 2020-07-02 04:33:46 | Anderson, Tennessee, US |
2022-04-16 | US | Tennessee | Anderson | 47001 | 22207 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-04-17 04:20:59 | Anderson, Tennessee, US | |
2022-12-13 | US | Tennessee | Anderson | 47001 | 26736 | 381 | 0 | 36.12684348 | -84.19965764 | 2022-12-14 04:21:04 | Anderson, Tennessee, US | |
2022-11-13 | US | Tennessee | Anderson | 47001 | 26434 | 375 | 0 | 36.12684348 | -84.19965764 | 2022-11-14 04:21:09 | Anderson, Tennessee, US | |
2022-02-12 | US | Tennessee | Anderson | 47001 | 21517 | 301 | 0 | 36.12684348 | -84.19965764 | 2022-02-13 04:21:00 | Anderson, Tennessee, US | |
2022-10-30 | US | Tennessee | Anderson | 47001 | 26284 | 372 | 0 | 36.12684348 | -84.19965764 | 2022-10-31 04:21:36 | Anderson, Tennessee, US | |
2020-07-20 | US | Tennessee | Anderson | 47001 | 313 | 3 | 0 | 297 | 36.12684348 | -84.19965764 | 2020-07-21 04:38:46 | Anderson, Tennessee, US |
2022-12-27 | US | Tennessee | Anderson | 47001 | 26910 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-28 04:21:04 | Anderson, Tennessee, US | |
2021-08-04 | US | Tennessee | Anderson | 47001 | 9116 | 178 | 0 | 36.12684348 | -84.19965764 | 2021-08-05 04:21:51 | Anderson, Tennessee, US | |
2022-03-18 | US | Tennessee | Anderson | 47001 | 22153 | 320 | 0 | 36.12684348 | -84.19965764 | 2022-03-19 04:20:47 | Anderson, Tennessee, US | |
2021-02-03 | US | Tennessee | Anderson | 47001 | 7388 | 138 | 0 | 7152 | 36.12684348 | -84.19965764 | 2021-02-04 05:22:26 | Anderson, Tennessee, US |
2020-09-14 | US | Tennessee | Anderson | 47001 | 1044 | 10 | 0 | 1025 | 36.12684348 | -84.19965764 | 2020-09-15 03:22:50 | Anderson, Tennessee, US |
2022-12-14 | US | Tennessee | Anderson | 47001 | 26746 | 381 | 0 | 36.12684348 | -84.19965764 | 2022-12-15 04:20:58 | Anderson, Tennessee, US | |
2021-03-11 | US | Tennessee | Anderson | 47001 | 8098 | 159 | 0 | 36.12684348 | -84.19965764 | 2021-03-12 05:26:50 | Anderson, Tennessee, US | |
2022-03-11 | US | Tennessee | Anderson | 47001 | 22135 | 316 | 0 | 36.12684348 | -84.19965764 | 2022-03-12 04:20:50 | Anderson, Tennessee, US | |
2022-05-07 | US | Tennessee | Anderson | 47001 | 22340 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-05-08 04:20:49 | Anderson, Tennessee, US | |
2020-07-16 | US | Tennessee | Anderson | 47001 | 263 | 2 | 0 | 250 | 36.12684348 | -84.19965764 | 2020-07-17 04:34:50 | Anderson, Tennessee, US |
2020-08-08 | US | Tennessee | Anderson | 47001 | 690 | 6 | 0 | 670 | 36.12684348 | -84.19965764 | 2020-08-09 04:34:54 | Anderson, Tennessee, US |
2022-09-13 | US | Tennessee | Anderson | 47001 | 25797 | 365 | 0 | 36.12684348 | -84.19965764 | 2022-09-14 04:20:44 | Anderson, Tennessee, US | |
2020-11-06 | US | Tennessee | Anderson | 47001 | 2005 | 18 | 0 | 1980 | 36.12684348 | -84.19965764 | 2020-11-07 05:24:52 | Anderson, Tennessee, US |
2021-04-30 | US | Tennessee | Anderson | 47001 | 8633 | 171 | 0 | 36.12684348 | -84.19965764 | 2021-05-01 04:20:47 | Anderson, Tennessee, US | |
2022-09-23 | US | Tennessee | Anderson | 47001 | 25977 | 369 | 0 | 36.12684348 | -84.19965764 | 2022-09-24 04:21:40 | Anderson, Tennessee, US | |
2021-04-04 | US | Tennessee | Anderson | 47001 | 8392 | 165 | 0 | 36.12684348 | -84.19965764 | 2021-04-05 04:20:35 | Anderson, Tennessee, US | |
2020-11-27 | US | Tennessee | Anderson | 47001 | 2895 | 28 | 0 | 2805 | 36.12684348 | -84.19965764 | 2020-11-28 05:25:50 | Anderson, Tennessee, US |
2022-10-07 | US | Tennessee | Anderson | 47001 | 26097 | 370 | 0 | 36.12684348 | -84.19965764 | 2022-10-08 04:22:56 | Anderson, Tennessee, US | |
2021-06-29 | US | Tennessee | Anderson | 47001 | 8817 | 175 | 0 | 36.12684348 | -84.19965764 | 2021-06-30 04:21:41 | Anderson, Tennessee, US | |
2021-12-07 | US | Tennessee | Anderson | 47001 | 13806 | 237 | 0 | 36.12684348 | -84.19965764 | 2021-12-08 04:22:46 | Anderson, Tennessee, US | |
2021-07-28 | US | Tennessee | Anderson | 47001 | 8980 | 178 | 0 | 36.12684348 | -84.19965764 | 2021-07-29 04:21:33 | Anderson, Tennessee, US | |
2020-07-05 | US | Tennessee | Anderson | 47001 | 140 | 2 | 0 | 140 | 36.12684348 | -84.19965764 | 2020-07-06 04:33:57 | Anderson, Tennessee, US |
2020-04-18 | US | Tennessee | Anderson | 47001 | 13 | 1 | 0 | 15 | 36.12684348 | -84.19965764 | 2020-04-18 22:32:47 | Anderson, Tennessee, US |
2022-09-18 | US | Tennessee | Anderson | 47001 | 25907 | 368 | 0 | 36.12684348 | -84.19965764 | 2022-09-19 04:21:49 | Anderson, Tennessee, US | |
2021-10-10 | US | Tennessee | Anderson | 47001 | 12663 | 208 | 0 | 36.12684348 | -84.19965764 | 2021-10-11 04:21:31 | Anderson, Tennessee, US | |
2020-09-07 | US | Tennessee | Anderson | 47001 | 966 | 8 | 0 | 944 | 36.12684348 | -84.19965764 | 2020-09-08 04:28:25 | Anderson, Tennessee, US |
2022-11-03 | US | Tennessee | Anderson | 47001 | 26335 | 373 | 0 | 36.12684348 | -84.19965764 | 2022-11-04 04:22:11 | Anderson, Tennessee, US | |
2021-01-21 | US | Tennessee | Anderson | 47001 | 7033 | 112 | 0 | 6792 | 36.12684348 | -84.19965764 | 2021-01-22 05:22:10 | Anderson, Tennessee, US |
2020-07-26 | US | Tennessee | Anderson | 47001 | 465 | 4 | 0 | 426 | 36.12684348 | -84.19965764 | 2020-07-27 04:35:02 | Anderson, Tennessee, US |
2021-10-20 | US | Tennessee | Anderson | 47001 | 12909 | 214 | 0 | 36.12684348 | -84.19965764 | 2021-10-21 04:21:18 | Anderson, Tennessee, US | |
2021-11-17 | US | Tennessee | Anderson | 47001 | 13396 | 227 | 0 | 36.12684348 | -84.19965764 | 2021-11-18 04:21:33 | Anderson, Tennessee, US | |
2022-12-21 | US | Tennessee | Anderson | 47001 | 26868 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-22 04:20:56 | Anderson, Tennessee, US | |
2020-08-07 | US | Tennessee | Anderson | 47001 | 679 | 6 | 0 | 662 | 36.12684348 | -84.19965764 | 2020-08-08 04:34:53 | Anderson, Tennessee, US |
2022-02-02 | US | Tennessee | Anderson | 47001 | 20177 | 293 | 0 | 36.12684348 | -84.19965764 | 2022-02-03 04:21:21 | Anderson, Tennessee, US | |
2022-05-02 | US | Tennessee | Anderson | 47001 | 22304 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-05-03 04:21:00 | Anderson, Tennessee, US | |
2021-10-07 | US | Tennessee | Anderson | 47001 | 12619 | 207 | 0 | 36.12684348 | -84.19965764 | 2021-10-08 04:21:25 | Anderson, Tennessee, US | |
2021-02-19 | US | Tennessee | Anderson | 47001 | 7733 | 149 | 0 | 7668 | 36.12684348 | -84.19965764 | 2021-02-20 05:22:51 | Anderson, Tennessee, US |
2022-06-26 | US | Tennessee | Anderson | 47001 | 23069 | 346 | 0 | 36.12684348 | -84.19965764 | 2022-06-27 04:21:00 | Anderson, Tennessee, US | |
2022-11-08 | US | Tennessee | Anderson | 47001 | 26395 | 375 | 0 | 36.12684348 | -84.19965764 | 2022-11-09 04:21:22 | Anderson, Tennessee, US | |
2021-07-19 | US | Tennessee | Anderson | 47001 | 8866 | 176 | 0 | 36.12684348 | -84.19965764 | 2021-07-20 04:21:48 | Anderson, Tennessee, US | |
2022-11-25 | US | Tennessee | Anderson | 47001 | 26518 | 378 | 0 | 36.12684348 | -84.19965764 | 2022-11-26 04:21:11 | Anderson, Tennessee, US | |
2021-10-14 | US | Tennessee | Anderson | 47001 | 12785 | 211 | 0 | 36.12684348 | -84.19965764 | 2021-10-15 04:21:26 | Anderson, Tennessee, US | |
2021-11-06 | US | Tennessee | Anderson | 47001 | 13205 | 221 | 0 | 36.12684348 | -84.19965764 | 2021-11-07 04:21:53 | Anderson, Tennessee, US | |
2022-04-02 | US | Tennessee | Anderson | 47001 | 22176 | 328 | 0 | 36.12684348 | -84.19965764 | 2022-04-03 04:20:48 | Anderson, Tennessee, US | |
2022-12-17 | US | Tennessee | Anderson | 47001 | 26806 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-18 04:21:03 | Anderson, Tennessee, US | |
2021-08-14 | US | Tennessee | Anderson | 47001 | 9492 | 180 | 0 | 36.12684348 | -84.19965764 | 2021-08-15 04:21:41 | Anderson, Tennessee, US | |
2021-08-19 | US | Tennessee | Anderson | 47001 | 9722 | 181 | 0 | 36.12684348 | -84.19965764 | 2021-08-20 04:21:33 | Anderson, Tennessee, US | |
2022-10-15 | US | Tennessee | Anderson | 47001 | 26142 | 370 | 0 | 36.12684348 | -84.19965764 | 2022-10-16 04:22:39 | Anderson, Tennessee, US | |
2020-04-21 | US | Tennessee | Anderson | 47001 | 20 | 1 | 0 | 20 | 36.12684348 | -84.19965764 | 2020-04-21 23:30:50 | Anderson, Tennessee, US |
2021-06-09 | US | Tennessee | Anderson | 47001 | 8793 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-06-10 04:23:17 | Anderson, Tennessee, US | |
2020-07-04 | US | Tennessee | Anderson | 47001 | 131 | 2 | 0 | 132 | 36.12684348 | -84.19965764 | 2020-07-05 04:33:46 | Anderson, Tennessee, US |
2021-02-22 | US | Tennessee | Anderson | 47001 | 7769 | 153 | 0 | 7710 | 36.12684348 | -84.19965764 | 2021-02-23 05:23:41 | Anderson, Tennessee, US |
2021-10-27 | US | Tennessee | Anderson | 47001 | 13029 | 216 | 0 | 36.12684348 | -84.19965764 | 2021-10-28 04:22:08 | Anderson, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;