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 combined_key
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
541671 | 541671 | 2022-10-26 | US | Tennessee | Anderson | 47001 | 26249 | 372 | 0 | 36.12684348 | -84.19965764 | 2022-10-27 04:22:01 | Anderson, Tennessee, US | |
545687 | 545687 | 2022-12-15 | US | Tennessee | Anderson | 47001 | 26766 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-16 04:21:01 | Anderson, Tennessee, US | |
549648 | 549648 | 2020-09-12 | US | Tennessee | Anderson | 47001 | 1017 | 10 | 0 | 1004 | 36.12684348 | -84.19965764 | 2020-09-13 04:30:52 | Anderson, Tennessee, US |
553688 | 553688 | 2021-12-08 | US | Tennessee | Anderson | 47001 | 13833 | 237 | 0 | 36.12684348 | -84.19965764 | 2021-12-09 04:22:49 | Anderson, Tennessee, US | |
557704 | 557704 | 2022-01-16 | US | Tennessee | Anderson | 47001 | 16876 | 277 | 0 | 36.12684348 | -84.19965764 | 2022-01-17 04:21:08 | Anderson, Tennessee, US | |
561722 | 561722 | 2022-06-16 | US | Tennessee | Anderson | 47001 | 22868 | 345 | 0 | 36.12684348 | -84.19965764 | 2022-06-17 04:20:56 | Anderson, Tennessee, US | |
565876 | 565876 | 2021-06-22 | US | Tennessee | Anderson | 47001 | 8810 | 175 | 0 | 36.12684348 | -84.19965764 | 2021-06-23 04:21:46 | Anderson, Tennessee, US | |
570017 | 570017 | 2021-10-29 | US | Tennessee | Anderson | 47001 | 13072 | 217 | 0 | 36.12684348 | -84.19965764 | 2021-10-30 04:22:03 | Anderson, Tennessee, US | |
570849 | 570849 | 2020-06-06 | US | Tennessee | Anderson | 47001 | 43 | 2 | 0 | 43 | 36.12684348 | -84.19965764 | 2020-06-07 03:53:30 | Anderson, Tennessee, US |
577747 | 577747 | 2022-02-25 | US | Tennessee | Anderson | 47001 | 21973 | 308 | 0 | 36.12684348 | -84.19965764 | 2022-02-26 04:21:12 | Anderson, Tennessee, US | |
581742 | 581742 | 2021-07-13 | US | Tennessee | Anderson | 47001 | 8835 | 176 | 0 | 36.12684348 | -84.19965764 | 2021-07-14 04:21:35 | Anderson, Tennessee, US | |
585717 | 585717 | 2020-08-13 | US | Tennessee | Anderson | 47001 | 749 | 7 | 0 | 715 | 36.12684348 | -84.19965764 | 2020-08-14 04:51:19 | Anderson, Tennessee, US |
586565 | 586565 | 2020-04-05 | US | Tennessee | Anderson | 47001 | 9 | 0 | 0 | 10 | 36.12684348 | -84.19965764 | 2020-04-05 23:06:45 | Anderson, Tennessee, US |
592538 | 592538 | 2021-08-08 | US | Tennessee | Anderson | 47001 | 9200 | 178 | 0 | 36.12684348 | -84.19965764 | 2021-08-09 04:21:24 | Anderson, Tennessee, US | |
596574 | 596574 | 2022-07-01 | US | Tennessee | Anderson | 47001 | 23204 | 349 | 0 | 36.12684348 | -84.19965764 | 2022-07-02 04:21:16 | Anderson, Tennessee, US | |
600587 | 600587 | 2021-10-19 | US | Tennessee | Anderson | 47001 | 12874 | 214 | 0 | 36.12684348 | -84.19965764 | 2021-10-20 04:21:00 | Anderson, Tennessee, US | |
604602 | 604602 | 2021-09-23 | US | Tennessee | Anderson | 47001 | 12109 | 192 | 0 | 36.12684348 | -84.19965764 | 2021-09-24 04:21:44 | Anderson, Tennessee, US | |
608595 | 608595 | 2021-04-09 | US | Tennessee | Anderson | 47001 | 8442 | 166 | 0 | 36.12684348 | -84.19965764 | 2021-04-10 04:20:59 | Anderson, Tennessee, US | |
612579 | 612579 | 2020-08-29 | US | Tennessee | Anderson | 47001 | 884 | 8 | 0 | 849 | 36.12684348 | -84.19965764 | 2020-08-30 04:28:22 | Anderson, Tennessee, US |
616592 | 616592 | 2021-02-08 | US | Tennessee | Anderson | 47001 | 7502 | 145 | 0 | 7242 | 36.12684348 | -84.19965764 | 2021-02-09 05:23:30 | Anderson, Tennessee, US |
620781 | 620781 | 2022-11-05 | US | Tennessee | Anderson | 47001 | 26359 | 375 | 0 | 36.12684348 | -84.19965764 | 2022-11-06 04:21:24 | Anderson, Tennessee, US | |
624794 | 624794 | 2022-05-22 | US | Tennessee | Anderson | 47001 | 22461 | 341 | 0 | 36.12684348 | -84.19965764 | 2022-05-26 04:20:50 | Anderson, Tennessee, US | |
628788 | 628788 | 2021-07-10 | US | Tennessee | Anderson | 47001 | 8826 | 176 | 0 | 36.12684348 | -84.19965764 | 2021-07-11 04:21:43 | Anderson, Tennessee, US | |
632824 | 632824 | 2022-07-12 | US | Tennessee | Anderson | 47001 | 23476 | 349 | 0 | 36.12684348 | -84.19965764 | 2022-07-13 04:20:58 | Anderson, Tennessee, US | |
636837 | 636837 | 2021-10-13 | US | Tennessee | Anderson | 47001 | 12765 | 210 | 0 | 36.12684348 | -84.19965764 | 2021-10-14 04:21:29 | Anderson, Tennessee, US | |
640828 | 640828 | 2021-03-31 | US | Tennessee | Anderson | 47001 | 8366 | 165 | 0 | 36.12684348 | -84.19965764 | 2021-04-01 04:27:05 | Anderson, Tennessee, US | |
644848 | 644848 | 2021-09-07 | US | Tennessee | Anderson | 47001 | 11028 | 184 | 0 | 36.12684348 | -84.19965764 | 2021-09-08 04:21:31 | Anderson, Tennessee, US | |
648858 | 648858 | 2021-05-05 | US | Tennessee | Anderson | 47001 | 8661 | 171 | 0 | 36.12684348 | -84.19965764 | 2021-05-06 04:20:38 | Anderson, Tennessee, US | |
652876 | 652876 | 2021-08-09 | US | Tennessee | Anderson | 47001 | 9236 | 178 | 0 | 36.12684348 | -84.19965764 | 2021-08-10 04:21:27 | Anderson, Tennessee, US | |
656909 | 656909 | 2021-10-22 | US | Tennessee | Anderson | 47001 | 12951 | 214 | 0 | 36.12684348 | -84.19965764 | 2021-10-23 04:21:32 | Anderson, Tennessee, US | |
661229 | 661229 | 2022-05-13 | US | Tennessee | Anderson | 47001 | 22385 | 337 | 0 | 36.12684348 | -84.19965764 | 2022-05-14 04:20:48 | Anderson, Tennessee, US | |
665229 | 665229 | 2020-08-11 | US | Tennessee | Anderson | 47001 | 723 | 6 | 0 | 692 | 36.12684348 | -84.19965764 | 2020-08-12 04:27:29 | Anderson, Tennessee, US |
669173 | 669173 | 2020-09-16 | US | Tennessee | Anderson | 47001 | 1068 | 11 | 0 | 1052 | 36.12684348 | -84.19965764 | 2020-09-17 04:22:00 | Anderson, Tennessee, US |
673215 | 673215 | 2022-07-21 | US | Tennessee | Anderson | 47001 | 23794 | 352 | 0 | 36.12684348 | -84.19965764 | 2022-07-22 04:21:15 | Anderson, Tennessee, US | |
677231 | 677231 | 2022-07-30 | US | Tennessee | Anderson | 47001 | 24094 | 352 | 0 | 36.12684348 | -84.19965764 | 2022-07-31 04:21:02 | Anderson, Tennessee, US | |
681214 | 681214 | 2020-11-23 | US | Tennessee | Anderson | 47001 | 2710 | 25 | 0 | 2712 | 36.12684348 | -84.19965764 | 2020-11-24 05:27:31 | Anderson, Tennessee, US |
685254 | 685254 | 2021-10-24 | US | Tennessee | Anderson | 47001 | 12974 | 214 | 0 | 36.12684348 | -84.19965764 | 2021-10-25 04:22:31 | Anderson, Tennessee, US | |
689271 | 689271 | 2021-11-13 | US | Tennessee | Anderson | 47001 | 13320 | 226 | 0 | 36.12684348 | -84.19965764 | 2021-11-14 04:21:31 | Anderson, Tennessee, US | |
693292 | 693292 | 2022-12-23 | US | Tennessee | Anderson | 47001 | 26908 | 382 | 0 | 36.12684348 | -84.19965764 | 2022-12-24 04:21:02 | Anderson, Tennessee, US | |
697304 | 697304 | 2022-03-17 | US | Tennessee | Anderson | 47001 | 22151 | 320 | 0 | 36.12684348 | -84.19965764 | 2022-03-18 04:20:55 | Anderson, Tennessee, US | |
701319 | 701319 | 2021-11-04 | US | Tennessee | Anderson | 47001 | 13186 | 221 | 0 | 36.12684348 | -84.19965764 | 2021-11-05 04:21:54 | Anderson, Tennessee, US | |
705309 | 705309 | 2021-03-16 | US | Tennessee | Anderson | 47001 | 8187 | 159 | 0 | 36.12684348 | -84.19965764 | 2021-03-17 05:25:07 | Anderson, Tennessee, US | |
709347 | 709347 | 2021-09-29 | US | Tennessee | Anderson | 47001 | 12315 | 198 | 0 | 36.12684348 | -84.19965764 | 2021-09-30 04:21:20 | Anderson, Tennessee, US | |
713369 | 713369 | 2022-11-01 | US | Tennessee | Anderson | 47001 | 26312 | 372 | 0 | 36.12684348 | -84.19965764 | 2022-11-02 04:22:09 | Anderson, Tennessee, US | |
717380 | 717380 | 2021-11-12 | US | Tennessee | Anderson | 47001 | 13313 | 223 | 0 | 36.12684348 | -84.19965764 | 2021-11-13 04:21:38 | Anderson, Tennessee, US | |
721401 | 721401 | 2022-12-04 | US | Tennessee | Anderson | 47001 | 26596 | 379 | 0 | 36.12684348 | -84.19965764 | 2022-12-05 04:20:58 | Anderson, Tennessee, US | |
725412 | 725412 | 2021-11-20 | US | Tennessee | Anderson | 47001 | 13441 | 232 | 0 | 36.12684348 | -84.19965764 | 2021-11-21 04:22:13 | Anderson, Tennessee, US | |
729404 | 729404 | 2021-05-22 | US | Tennessee | Anderson | 47001 | 8749 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-05-23 04:20:51 | Anderson, Tennessee, US | |
733442 | 733442 | 2021-12-27 | US | Tennessee | Anderson | 47001 | 14297 | 262 | 0 | 36.12684348 | -84.19965764 | 2021-12-28 04:21:47 | Anderson, Tennessee, US | |
734274 | 734274 | 2020-06-12 | US | Tennessee | Anderson | 47001 | 57 | 2 | 0 | 57 | 36.12684348 | -84.19965764 | 2020-06-13 03:33:14 | Anderson, Tennessee, US |
741203 | 741203 | 2020-12-02 | US | Tennessee | Anderson | 47001 | 3178 | 30 | 0 | 3167 | 36.12684348 | -84.19965764 | 2020-12-03 05:28:22 | Anderson, Tennessee, US |
745218 | 745218 | 2021-02-20 | US | Tennessee | Anderson | 47001 | 7752 | 150 | 0 | 7688 | 36.12684348 | -84.19965764 | 2021-02-21 05:24:33 | 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]);