johns_hopkins_csse_daily_reports
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)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips ▼ | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144903 | 144903 | 2022-07-09 | US | Tennessee | Anderson | 47001 | 23389 | 349 | 0 | 36.12684348 | -84.19965764 | 2022-07-10 04:20:54 | Anderson, Tennessee, US | |
148858 | 148858 | 2020-08-15 | US | Tennessee | Anderson | 47001 | 776 | 6 | 0 | 748 | 36.12684348 | -84.19965764 | 2020-08-16 04:27:42 | Anderson, Tennessee, US |
152898 | 152898 | 2021-11-29 | US | Tennessee | Anderson | 47001 | 13577 | 234 | 0 | 36.12684348 | -84.19965764 | 2021-11-30 04:22:53 | Anderson, Tennessee, US | |
156885 | 156885 | 2021-01-08 | US | Tennessee | Anderson | 47001 | 6373 | 86 | 0 | 6182 | 36.12684348 | -84.19965764 | 2021-01-09 05:22:18 | Anderson, Tennessee, US |
160927 | 160927 | 2022-03-29 | US | Tennessee | Anderson | 47001 | 22168 | 324 | 0 | 36.12684348 | -84.19965764 | 2022-03-30 04:20:45 | Anderson, Tennessee, US | |
164942 | 164942 | 2021-11-19 | US | Tennessee | Anderson | 47001 | 13432 | 232 | 0 | 36.12684348 | -84.19965764 | 2021-11-20 04:22:17 | Anderson, Tennessee, US | |
168960 | 168960 | 2022-06-21 | US | Tennessee | Anderson | 47001 | 22957 | 346 | 0 | 36.12684348 | -84.19965764 | 2022-06-22 04:20:54 | Anderson, Tennessee, US | |
172950 | 172950 | 2021-04-16 | US | Tennessee | Anderson | 47001 | 8503 | 170 | 0 | 36.12684348 | -84.19965764 | 2021-04-17 04:20:40 | Anderson, Tennessee, US | |
173813 | 173813 | 2020-07-27 | US | Tennessee | Anderson | 47001 | 483 | 4 | 0 | 465 | 36.12684348 | -84.19965764 | 2020-07-28 04:58:43 | Anderson, Tennessee, US |
180936 | 180936 | 2021-09-02 | US | Tennessee | Anderson | 47001 | 10622 | 184 | 0 | 36.12684348 | -84.19965764 | 2021-09-03 04:21:20 | Anderson, Tennessee, US | |
184944 | 184944 | 2021-02-21 | US | Tennessee | Anderson | 47001 | 7764 | 152 | 0 | 7701 | 36.12684348 | -84.19965764 | 2021-02-22 05:24:21 | Anderson, Tennessee, US |
188985 | 188985 | 2022-02-13 | US | Tennessee | Anderson | 47001 | 21538 | 301 | 0 | 36.12684348 | -84.19965764 | 2022-02-14 04:20:51 | Anderson, Tennessee, US | |
192971 | 192971 | 2021-01-11 | US | Tennessee | Anderson | 47001 | 6576 | 91 | 0 | 6382 | 36.12684348 | -84.19965764 | 2021-01-12 05:22:15 | Anderson, Tennessee, US |
196962 | 196962 | 2020-08-31 | US | Tennessee | Anderson | 47001 | 902 | 8 | 0 | 866 | 36.12684348 | -84.19965764 | 2020-09-01 04:28:31 | Anderson, Tennessee, US |
201177 | 201177 | 2022-10-19 | US | Tennessee | Anderson | 47001 | 26168 | 370 | 0 | 36.12684348 | -84.19965764 | 2022-10-20 04:22:59 | Anderson, Tennessee, US | |
205158 | 205158 | 2020-12-25 | US | Tennessee | Anderson | 47001 | 5361 | 55 | 0 | 5163 | 36.12684348 | -84.19965764 | 2020-12-26 05:22:28 | Anderson, Tennessee, US |
209144 | 209144 | 2020-08-19 | US | Tennessee | Anderson | 47001 | 820 | 6 | 0 | 793 | 36.12684348 | -84.19965764 | 2020-08-20 04:27:43 | Anderson, Tennessee, US |
213140 | 213140 | 2020-10-29 | US | Tennessee | Anderson | 47001 | 1813 | 14 | 0 | 1799 | 36.12684348 | -84.19965764 | 2020-10-30 04:24:49 | Anderson, Tennessee, US |
213995 | 213995 | 2020-06-08 | US | Tennessee | Anderson | 47001 | 46 | 2 | 0 | 46 | 36.12684348 | -84.19965764 | 2020-06-09 03:33:03 | Anderson, Tennessee, US |
220898 | 220898 | 2022-12-26 | US | Tennessee | Anderson | 47001 | 26910 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-27 04:21:07 | Anderson, Tennessee, US | |
224910 | 224910 | 2022-05-09 | US | Tennessee | Anderson | 47001 | 22347 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-05-10 04:20:50 | Anderson, Tennessee, US | |
225738 | 225738 | 2020-04-30 | US | Tennessee | Anderson | 47001 | 26 | 1 | 0 | 27 | 36.12684348 | -84.19965764 | 2020-05-01 02:32:28 | Anderson, Tennessee, US |
232142 | 232142 | 2022-05-31 | US | Tennessee | Anderson | 47001 | 22575 | 342 | 0 | 36.12684348 | -84.19965764 | 2022-06-01 04:20:55 | Anderson, Tennessee, US | |
236157 | 236157 | 2022-02-11 | US | Tennessee | Anderson | 47001 | 21486 | 301 | 0 | 36.12684348 | -84.19965764 | 2022-02-12 04:21:06 | Anderson, Tennessee, US | |
240144 | 240144 | 2021-01-18 | US | Tennessee | Anderson | 47001 | 6907 | 103 | 0 | 6689 | 36.12684348 | -84.19965764 | 2021-01-19 05:22:15 | Anderson, Tennessee, US |
244161 | 244161 | 2021-04-02 | US | Tennessee | Anderson | 47001 | 8384 | 165 | 0 | 36.12684348 | -84.19965764 | 2021-04-03 04:20:44 | Anderson, Tennessee, US | |
248179 | 248179 | 2021-08-17 | US | Tennessee | Anderson | 47001 | 9596 | 181 | 0 | 36.12684348 | -84.19965764 | 2021-08-18 04:21:35 | Anderson, Tennessee, US | |
252193 | 252193 | 2021-09-04 | US | Tennessee | Anderson | 47001 | 10757 | 184 | 0 | 36.12684348 | -84.19965764 | 2021-09-05 04:21:33 | Anderson, Tennessee, US | |
256229 | 256229 | 2022-09-08 | US | Tennessee | Anderson | 47001 | 25720 | 365 | 0 | 36.12684348 | -84.19965764 | 2022-09-09 04:21:11 | Anderson, Tennessee, US | |
260248 | 260248 | 2022-12-10 | US | Tennessee | Anderson | 47001 | 26682 | 381 | 0 | 36.12684348 | -84.19965764 | 2022-12-11 04:20:50 | Anderson, Tennessee, US | |
264447 | 264447 | 2022-03-15 | US | Tennessee | Anderson | 47001 | 22149 | 319 | 0 | 36.12684348 | -84.19965764 | 2022-03-16 04:20:50 | Anderson, Tennessee, US | |
265276 | 265276 | 2020-05-21 | US | Tennessee | Anderson | 47001 | 37 | 1 | 0 | 36 | 36.12684348 | -84.19965764 | 2020-05-22 02:36:51 | Anderson, Tennessee, US |
268711 | 268711 | 2020-04-28 | US | Tennessee | Anderson | 47001 | 22 | 1 | 0 | 23 | 36.12684348 | -84.19965764 | 2020-04-29 02:32:29 | Anderson, Tennessee, US |
275056 | 275056 | 2020-11-10 | US | Tennessee | Anderson | 47001 | 2166 | 18 | 0 | 2167 | 36.12684348 | -84.19965764 | 2020-11-11 05:25:30 | Anderson, Tennessee, US |
279097 | 279097 | 2021-11-03 | US | Tennessee | Anderson | 47001 | 13164 | 221 | 0 | 36.12684348 | -84.19965764 | 2021-11-04 04:22:20 | Anderson, Tennessee, US | |
283087 | 283087 | 2021-02-24 | US | Tennessee | Anderson | 47001 | 7825 | 155 | 0 | 7738 | 36.12684348 | -84.19965764 | 2021-02-25 05:24:57 | Anderson, Tennessee, US |
283943 | 283943 | 2020-06-15 | US | Tennessee | Anderson | 47001 | 60 | 2 | 0 | 58 | 36.12684348 | -84.19965764 | 2020-06-16 04:33:09 | Anderson, Tennessee, US |
290909 | 290909 | 2021-10-31 | US | Tennessee | Anderson | 47001 | 13087 | 217 | 0 | 36.12684348 | -84.19965764 | 2021-11-01 04:22:01 | Anderson, Tennessee, US | |
294931 | 294931 | 2022-11-15 | US | Tennessee | Anderson | 47001 | 26456 | 375 | 0 | 36.12684348 | -84.19965764 | 2022-11-16 04:21:09 | Anderson, Tennessee, US | |
298922 | 298922 | 2021-07-15 | US | Tennessee | Anderson | 47001 | 8843 | 176 | 0 | 36.12684348 | -84.19965764 | 2021-07-16 04:21:22 | Anderson, Tennessee, US | |
299772 | 299772 | 2020-07-01 | US | Tennessee | Anderson | 47001 | 104 | 2 | 0 | 102 | 36.12684348 | -84.19965764 | 2020-07-02 04:33:46 | Anderson, Tennessee, US |
306783 | 306783 | 2022-04-16 | US | Tennessee | Anderson | 47001 | 22207 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-04-17 04:20:59 | Anderson, Tennessee, US | |
310803 | 310803 | 2022-12-13 | US | Tennessee | Anderson | 47001 | 26736 | 381 | 0 | 36.12684348 | -84.19965764 | 2022-12-14 04:21:04 | Anderson, Tennessee, US | |
314819 | 314819 | 2022-11-13 | US | Tennessee | Anderson | 47001 | 26434 | 375 | 0 | 36.12684348 | -84.19965764 | 2022-11-14 04:21:09 | Anderson, Tennessee, US | |
318831 | 318831 | 2022-02-12 | US | Tennessee | Anderson | 47001 | 21517 | 301 | 0 | 36.12684348 | -84.19965764 | 2022-02-13 04:21:00 | Anderson, Tennessee, US | |
322851 | 322851 | 2022-10-30 | US | Tennessee | Anderson | 47001 | 26284 | 372 | 0 | 36.12684348 | -84.19965764 | 2022-10-31 04:21:36 | Anderson, Tennessee, US | |
323684 | 323684 | 2020-07-20 | US | Tennessee | Anderson | 47001 | 313 | 3 | 0 | 297 | 36.12684348 | -84.19965764 | 2020-07-21 04:38:46 | Anderson, Tennessee, US |
330825 | 330825 | 2022-12-27 | US | Tennessee | Anderson | 47001 | 26910 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-28 04:21:04 | Anderson, Tennessee, US | |
334816 | 334816 | 2021-08-04 | US | Tennessee | Anderson | 47001 | 9116 | 178 | 0 | 36.12684348 | -84.19965764 | 2021-08-05 04:21:51 | Anderson, Tennessee, US | |
338851 | 338851 | 2022-03-18 | US | Tennessee | Anderson | 47001 | 22153 | 320 | 0 | 36.12684348 | -84.19965764 | 2022-03-19 04:20:47 | Anderson, Tennessee, US | |
343179 | 343179 | 2021-02-03 | US | Tennessee | Anderson | 47001 | 7388 | 138 | 0 | 7152 | 36.12684348 | -84.19965764 | 2021-02-04 05:22:26 | Anderson, Tennessee, US |
347170 | 347170 | 2020-09-14 | US | Tennessee | Anderson | 47001 | 1044 | 10 | 0 | 1025 | 36.12684348 | -84.19965764 | 2020-09-15 03:22:50 | Anderson, Tennessee, US |
351215 | 351215 | 2022-12-14 | US | Tennessee | Anderson | 47001 | 26746 | 381 | 0 | 36.12684348 | -84.19965764 | 2022-12-15 04:20:58 | Anderson, Tennessee, US | |
355200 | 355200 | 2021-03-11 | US | Tennessee | Anderson | 47001 | 8098 | 159 | 0 | 36.12684348 | -84.19965764 | 2021-03-12 05:26:50 | Anderson, Tennessee, US | |
359241 | 359241 | 2022-03-11 | US | Tennessee | Anderson | 47001 | 22135 | 316 | 0 | 36.12684348 | -84.19965764 | 2022-03-12 04:20:50 | Anderson, Tennessee, US | |
363257 | 363257 | 2022-05-07 | US | Tennessee | Anderson | 47001 | 22340 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-05-08 04:20:49 | Anderson, Tennessee, US | |
364089 | 364089 | 2020-07-16 | US | Tennessee | Anderson | 47001 | 263 | 2 | 0 | 250 | 36.12684348 | -84.19965764 | 2020-07-17 04:34:50 | Anderson, Tennessee, US |
367958 | 367958 | 2020-08-08 | US | Tennessee | Anderson | 47001 | 690 | 6 | 0 | 670 | 36.12684348 | -84.19965764 | 2020-08-09 04:34:54 | Anderson, Tennessee, US |
375115 | 375115 | 2022-09-13 | US | Tennessee | Anderson | 47001 | 25797 | 365 | 0 | 36.12684348 | -84.19965764 | 2022-09-14 04:20:44 | Anderson, Tennessee, US | |
379083 | 379083 | 2020-11-06 | US | Tennessee | Anderson | 47001 | 2005 | 18 | 0 | 1980 | 36.12684348 | -84.19965764 | 2020-11-07 05:24:52 | Anderson, Tennessee, US |
383099 | 383099 | 2021-04-30 | US | Tennessee | Anderson | 47001 | 8633 | 171 | 0 | 36.12684348 | -84.19965764 | 2021-05-01 04:20:47 | Anderson, Tennessee, US | |
387142 | 387142 | 2022-09-23 | US | Tennessee | Anderson | 47001 | 25977 | 369 | 0 | 36.12684348 | -84.19965764 | 2022-09-24 04:21:40 | Anderson, Tennessee, US | |
391129 | 391129 | 2021-04-04 | US | Tennessee | Anderson | 47001 | 8392 | 165 | 0 | 36.12684348 | -84.19965764 | 2021-04-05 04:20:35 | Anderson, Tennessee, US | |
395137 | 395137 | 2020-11-27 | US | Tennessee | Anderson | 47001 | 2895 | 28 | 0 | 2805 | 36.12684348 | -84.19965764 | 2020-11-28 05:25:50 | Anderson, Tennessee, US |
399183 | 399183 | 2022-10-07 | US | Tennessee | Anderson | 47001 | 26097 | 370 | 0 | 36.12684348 | -84.19965764 | 2022-10-08 04:22:56 | Anderson, Tennessee, US | |
403174 | 403174 | 2021-06-29 | US | Tennessee | Anderson | 47001 | 8817 | 175 | 0 | 36.12684348 | -84.19965764 | 2021-06-30 04:21:41 | Anderson, Tennessee, US | |
407208 | 407208 | 2021-12-07 | US | Tennessee | Anderson | 47001 | 13806 | 237 | 0 | 36.12684348 | -84.19965764 | 2021-12-08 04:22:46 | Anderson, Tennessee, US | |
411204 | 411204 | 2021-07-28 | US | Tennessee | Anderson | 47001 | 8980 | 178 | 0 | 36.12684348 | -84.19965764 | 2021-07-29 04:21:33 | Anderson, Tennessee, US | |
412054 | 412054 | 2020-07-05 | US | Tennessee | Anderson | 47001 | 140 | 2 | 0 | 140 | 36.12684348 | -84.19965764 | 2020-07-06 04:33:57 | Anderson, Tennessee, US |
415971 | 415971 | 2020-04-18 | US | Tennessee | Anderson | 47001 | 13 | 1 | 0 | 15 | 36.12684348 | -84.19965764 | 2020-04-18 22:32:47 | Anderson, Tennessee, US |
422254 | 422254 | 2022-09-18 | US | Tennessee | Anderson | 47001 | 25907 | 368 | 0 | 36.12684348 | -84.19965764 | 2022-09-19 04:21:49 | Anderson, Tennessee, US | |
426264 | 426264 | 2021-10-10 | US | Tennessee | Anderson | 47001 | 12663 | 208 | 0 | 36.12684348 | -84.19965764 | 2021-10-11 04:21:31 | Anderson, Tennessee, US | |
430231 | 430231 | 2020-09-07 | US | Tennessee | Anderson | 47001 | 966 | 8 | 0 | 944 | 36.12684348 | -84.19965764 | 2020-09-08 04:28:25 | Anderson, Tennessee, US |
434276 | 434276 | 2022-11-03 | US | Tennessee | Anderson | 47001 | 26335 | 373 | 0 | 36.12684348 | -84.19965764 | 2022-11-04 04:22:11 | Anderson, Tennessee, US | |
438260 | 438260 | 2021-01-21 | US | Tennessee | Anderson | 47001 | 7033 | 112 | 0 | 6792 | 36.12684348 | -84.19965764 | 2021-01-22 05:22:10 | Anderson, Tennessee, US |
439126 | 439126 | 2020-07-26 | US | Tennessee | Anderson | 47001 | 465 | 4 | 0 | 426 | 36.12684348 | -84.19965764 | 2020-07-27 04:35:02 | Anderson, Tennessee, US |
446268 | 446268 | 2021-10-20 | US | Tennessee | Anderson | 47001 | 12909 | 214 | 0 | 36.12684348 | -84.19965764 | 2021-10-21 04:21:18 | Anderson, Tennessee, US | |
450285 | 450285 | 2021-11-17 | US | Tennessee | Anderson | 47001 | 13396 | 227 | 0 | 36.12684348 | -84.19965764 | 2021-11-18 04:21:33 | Anderson, Tennessee, US | |
454306 | 454306 | 2022-12-21 | US | Tennessee | Anderson | 47001 | 26868 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-22 04:20:56 | Anderson, Tennessee, US | |
455142 | 455142 | 2020-08-07 | US | Tennessee | Anderson | 47001 | 679 | 6 | 0 | 662 | 36.12684348 | -84.19965764 | 2020-08-08 04:34:53 | Anderson, Tennessee, US |
462294 | 462294 | 2022-02-02 | US | Tennessee | Anderson | 47001 | 20177 | 293 | 0 | 36.12684348 | -84.19965764 | 2022-02-03 04:21:21 | Anderson, Tennessee, US | |
466311 | 466311 | 2022-05-02 | US | Tennessee | Anderson | 47001 | 22304 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-05-03 04:21:00 | Anderson, Tennessee, US | |
470325 | 470325 | 2021-10-07 | US | Tennessee | Anderson | 47001 | 12619 | 207 | 0 | 36.12684348 | -84.19965764 | 2021-10-08 04:21:25 | Anderson, Tennessee, US | |
474316 | 474316 | 2021-02-19 | US | Tennessee | Anderson | 47001 | 7733 | 149 | 0 | 7668 | 36.12684348 | -84.19965764 | 2021-02-20 05:22:51 | Anderson, Tennessee, US |
478358 | 478358 | 2022-06-26 | US | Tennessee | Anderson | 47001 | 23069 | 346 | 0 | 36.12684348 | -84.19965764 | 2022-06-27 04:21:00 | Anderson, Tennessee, US | |
482509 | 482509 | 2022-11-08 | US | Tennessee | Anderson | 47001 | 26395 | 375 | 0 | 36.12684348 | -84.19965764 | 2022-11-09 04:21:22 | Anderson, Tennessee, US | |
486500 | 486500 | 2021-07-19 | US | Tennessee | Anderson | 47001 | 8866 | 176 | 0 | 36.12684348 | -84.19965764 | 2021-07-20 04:21:48 | Anderson, Tennessee, US | |
490539 | 490539 | 2022-11-25 | US | Tennessee | Anderson | 47001 | 26518 | 378 | 0 | 36.12684348 | -84.19965764 | 2022-11-26 04:21:11 | Anderson, Tennessee, US | |
494549 | 494549 | 2021-10-14 | US | Tennessee | Anderson | 47001 | 12785 | 211 | 0 | 36.12684348 | -84.19965764 | 2021-10-15 04:21:26 | Anderson, Tennessee, US | |
498566 | 498566 | 2021-11-06 | US | Tennessee | Anderson | 47001 | 13205 | 221 | 0 | 36.12684348 | -84.19965764 | 2021-11-07 04:21:53 | Anderson, Tennessee, US | |
502583 | 502583 | 2022-04-02 | US | Tennessee | Anderson | 47001 | 22176 | 328 | 0 | 36.12684348 | -84.19965764 | 2022-04-03 04:20:48 | Anderson, Tennessee, US | |
506603 | 506603 | 2022-12-17 | US | Tennessee | Anderson | 47001 | 26806 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-18 04:21:03 | Anderson, Tennessee, US | |
510594 | 510594 | 2021-08-14 | US | Tennessee | Anderson | 47001 | 9492 | 180 | 0 | 36.12684348 | -84.19965764 | 2021-08-15 04:21:41 | Anderson, Tennessee, US | |
514608 | 514608 | 2021-08-19 | US | Tennessee | Anderson | 47001 | 9722 | 181 | 0 | 36.12684348 | -84.19965764 | 2021-08-20 04:21:33 | Anderson, Tennessee, US | |
518647 | 518647 | 2022-10-15 | US | Tennessee | Anderson | 47001 | 26142 | 370 | 0 | 36.12684348 | -84.19965764 | 2022-10-16 04:22:39 | Anderson, Tennessee, US | |
519471 | 519471 | 2020-04-21 | US | Tennessee | Anderson | 47001 | 20 | 1 | 0 | 20 | 36.12684348 | -84.19965764 | 2020-04-21 23:30:50 | Anderson, Tennessee, US |
525764 | 525764 | 2021-06-09 | US | Tennessee | Anderson | 47001 | 8793 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-06-10 04:23:17 | Anderson, Tennessee, US | |
526617 | 526617 | 2020-07-04 | US | Tennessee | Anderson | 47001 | 131 | 2 | 0 | 132 | 36.12684348 | -84.19965764 | 2020-07-05 04:33:46 | Anderson, Tennessee, US |
533610 | 533610 | 2021-02-22 | US | Tennessee | Anderson | 47001 | 7769 | 153 | 0 | 7710 | 36.12684348 | -84.19965764 | 2021-02-23 05:23:41 | Anderson, Tennessee, US |
537649 | 537649 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);