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 latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
318901 | 318901 | 2022-02-12 | US | Tennessee | Polk | 47139 | 4575 | 53 | 0 | 35.12245443 | -84.52075859 | 2022-02-13 04:21:00 | Polk, Tennessee, US | |
322921 | 322921 | 2022-10-30 | US | Tennessee | Polk | 47139 | 5382 | 88 | 0 | 35.12245443 | -84.52075859 | 2022-10-31 04:21:36 | Polk, Tennessee, US | |
325892 | 325892 | 2020-07-20 | US | Tennessee | Polk | 47139 | 82 | 0 | 0 | 70 | 35.12245443 | -84.52075859 | 2020-07-21 04:38:46 | Polk, Tennessee, US |
330895 | 330895 | 2022-12-27 | US | Tennessee | Polk | 47139 | 5522 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-28 04:21:04 | Polk, Tennessee, US | |
334886 | 334886 | 2021-08-04 | US | Tennessee | Polk | 47139 | 2190 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-08-05 04:21:51 | Polk, Tennessee, US | |
338921 | 338921 | 2022-03-18 | US | Tennessee | Polk | 47139 | 4729 | 70 | 0 | 35.12245443 | -84.52075859 | 2022-03-19 04:20:47 | Polk, Tennessee, US | |
343249 | 343249 | 2021-02-03 | US | Tennessee | Polk | 47139 | 1556 | 19 | 0 | 1559 | 35.12245443 | -84.52075859 | 2021-02-04 05:22:26 | Polk, Tennessee, US |
347240 | 347240 | 2020-09-14 | US | Tennessee | Polk | 47139 | 371 | 11 | 0 | 355 | 35.12245443 | -84.52075859 | 2020-09-15 03:22:50 | Polk, Tennessee, US |
351285 | 351285 | 2022-12-14 | US | Tennessee | Polk | 47139 | 5506 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-15 04:20:58 | Polk, Tennessee, US | |
355270 | 355270 | 2021-03-11 | US | Tennessee | Polk | 47139 | 1798 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-03-12 05:26:50 | Polk, Tennessee, US | |
359311 | 359311 | 2022-03-11 | US | Tennessee | Polk | 47139 | 4722 | 68 | 0 | 35.12245443 | -84.52075859 | 2022-03-12 04:20:50 | Polk, Tennessee, US | |
363327 | 363327 | 2022-05-07 | US | Tennessee | Polk | 47139 | 4748 | 74 | 0 | 35.12245443 | -84.52075859 | 2022-05-08 04:20:49 | Polk, Tennessee, US | |
366301 | 366301 | 2020-07-16 | US | Tennessee | Polk | 47139 | 71 | 0 | 0 | 63 | 35.12245443 | -84.52075859 | 2020-07-17 04:34:50 | Polk, Tennessee, US |
370236 | 370236 | 2020-08-08 | US | Tennessee | Polk | 47139 | 231 | 3 | 0 | 201 | 35.12245443 | -84.52075859 | 2020-08-09 04:34:54 | Polk, Tennessee, US |
375185 | 375185 | 2022-09-13 | US | Tennessee | Polk | 47139 | 5279 | 85 | 0 | 35.12245443 | -84.52075859 | 2022-09-14 04:20:44 | Polk, Tennessee, US | |
379153 | 379153 | 2020-11-06 | US | Tennessee | Polk | 47139 | 548 | 13 | 0 | 544 | 35.12245443 | -84.52075859 | 2020-11-07 05:24:52 | Polk, Tennessee, US |
383169 | 383169 | 2021-04-30 | US | Tennessee | Polk | 47139 | 2033 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-05-01 04:20:47 | Polk, Tennessee, US | |
387212 | 387212 | 2022-09-23 | US | Tennessee | Polk | 47139 | 5301 | 86 | 0 | 35.12245443 | -84.52075859 | 2022-09-24 04:21:40 | Polk, Tennessee, US | |
391199 | 391199 | 2021-04-04 | US | Tennessee | Polk | 47139 | 1918 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-04-05 04:20:35 | Polk, Tennessee, US | |
395207 | 395207 | 2020-11-27 | US | Tennessee | Polk | 47139 | 645 | 15 | 0 | 635 | 35.12245443 | -84.52075859 | 2020-11-28 05:25:50 | Polk, Tennessee, US |
399253 | 399253 | 2022-10-07 | US | Tennessee | Polk | 47139 | 5328 | 87 | 0 | 35.12245443 | -84.52075859 | 2022-10-08 04:22:56 | Polk, Tennessee, US | |
403244 | 403244 | 2021-06-29 | US | Tennessee | Polk | 47139 | 2108 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-06-30 04:21:41 | Polk, Tennessee, US | |
407278 | 407278 | 2021-12-07 | US | Tennessee | Polk | 47139 | 3289 | 33 | 0 | 35.12245443 | -84.52075859 | 2021-12-08 04:22:46 | Polk, Tennessee, US | |
411274 | 411274 | 2021-07-28 | US | Tennessee | Polk | 47139 | 2142 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-07-29 04:21:33 | Polk, Tennessee, US | |
414249 | 414249 | 2020-07-05 | US | Tennessee | Polk | 47139 | 50 | 0 | 0 | 45 | 35.12245443 | -84.52075859 | 2020-07-06 04:33:57 | Polk, Tennessee, US |
417927 | 417927 | 2020-04-18 | US | Tennessee | Polk | 47139 | 6 | 0 | 0 | 5 | 35.12245443 | -84.52075859 | 2020-04-18 22:32:47 | Polk, Tennessee, US |
422324 | 422324 | 2022-09-18 | US | Tennessee | Polk | 47139 | 5289 | 85 | 0 | 35.12245443 | -84.52075859 | 2022-09-19 04:21:49 | Polk, Tennessee, US | |
426334 | 426334 | 2021-10-10 | US | Tennessee | Polk | 47139 | 3116 | 27 | 0 | 35.12245443 | -84.52075859 | 2021-10-11 04:21:31 | Polk, Tennessee, US | |
430301 | 430301 | 2020-09-07 | US | Tennessee | Polk | 47139 | 365 | 11 | 0 | 342 | 35.12245443 | -84.52075859 | 2020-09-08 04:28:25 | Polk, Tennessee, US |
434346 | 434346 | 2022-11-03 | US | Tennessee | Polk | 47139 | 5405 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-11-04 04:22:11 | Polk, Tennessee, US | |
438330 | 438330 | 2021-01-21 | US | Tennessee | Polk | 47139 | 1440 | 17 | 0 | 1449 | 35.12245443 | -84.52075859 | 2021-01-22 05:22:10 | Polk, Tennessee, US |
441395 | 441395 | 2020-07-26 | US | Tennessee | Polk | 47139 | 129 | 0 | 0 | 105 | 35.12245443 | -84.52075859 | 2020-07-27 04:35:02 | Polk, Tennessee, US |
446338 | 446338 | 2021-10-20 | US | Tennessee | Polk | 47139 | 3166 | 29 | 0 | 35.12245443 | -84.52075859 | 2021-10-21 04:21:18 | Polk, Tennessee, US | |
450355 | 450355 | 2021-11-17 | US | Tennessee | Polk | 47139 | 3226 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-18 04:21:33 | Polk, Tennessee, US | |
454376 | 454376 | 2022-12-21 | US | Tennessee | Polk | 47139 | 5515 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-22 04:20:56 | Polk, Tennessee, US | |
457420 | 457420 | 2020-08-07 | US | Tennessee | Polk | 47139 | 224 | 3 | 0 | 192 | 35.12245443 | -84.52075859 | 2020-08-08 04:34:53 | Polk, Tennessee, US |
462364 | 462364 | 2022-02-02 | US | Tennessee | Polk | 47139 | 4424 | 52 | 0 | 35.12245443 | -84.52075859 | 2022-02-03 04:21:21 | Polk, Tennessee, US | |
466381 | 466381 | 2022-05-02 | US | Tennessee | Polk | 47139 | 4747 | 74 | 0 | 35.12245443 | -84.52075859 | 2022-05-03 04:21:00 | Polk, Tennessee, US | |
470395 | 470395 | 2021-10-07 | US | Tennessee | Polk | 47139 | 3102 | 27 | 0 | 35.12245443 | -84.52075859 | 2021-10-08 04:21:25 | Polk, Tennessee, US | |
474386 | 474386 | 2021-02-19 | US | Tennessee | Polk | 47139 | 1696 | 21 | 0 | 1690 | 35.12245443 | -84.52075859 | 2021-02-20 05:22:51 | Polk, Tennessee, US |
478428 | 478428 | 2022-06-26 | US | Tennessee | Polk | 47139 | 4852 | 79 | 0 | 35.12245443 | -84.52075859 | 2022-06-27 04:21:00 | Polk, Tennessee, US | |
482579 | 482579 | 2022-11-08 | US | Tennessee | Polk | 47139 | 5438 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-11-09 04:21:22 | Polk, Tennessee, US | |
486570 | 486570 | 2021-07-19 | US | Tennessee | Polk | 47139 | 2124 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-07-20 04:21:48 | Polk, Tennessee, US | |
490609 | 490609 | 2022-11-25 | US | Tennessee | Polk | 47139 | 5477 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-11-26 04:21:11 | Polk, Tennessee, US | |
494619 | 494619 | 2021-10-14 | US | Tennessee | Polk | 47139 | 3148 | 29 | 0 | 35.12245443 | -84.52075859 | 2021-10-15 04:21:26 | Polk, Tennessee, US | |
498636 | 498636 | 2021-11-06 | US | Tennessee | Polk | 47139 | 3200 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-07 04:21:53 | Polk, Tennessee, US | |
502653 | 502653 | 2022-04-02 | US | Tennessee | Polk | 47139 | 4738 | 71 | 0 | 35.12245443 | -84.52075859 | 2022-04-03 04:20:48 | Polk, Tennessee, US | |
506673 | 506673 | 2022-12-17 | US | Tennessee | Polk | 47139 | 5506 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-18 04:21:03 | Polk, Tennessee, US | |
510664 | 510664 | 2021-08-14 | US | Tennessee | Polk | 47139 | 2295 | 25 | 0 | 35.12245443 | -84.52075859 | 2021-08-15 04:21:41 | Polk, Tennessee, US | |
514678 | 514678 | 2021-08-19 | US | Tennessee | Polk | 47139 | 2366 | 25 | 0 | 35.12245443 | -84.52075859 | 2021-08-20 04:21:33 | Polk, Tennessee, US | |
518717 | 518717 | 2022-10-15 | US | Tennessee | Polk | 47139 | 5346 | 87 | 0 | 35.12245443 | -84.52075859 | 2022-10-16 04:22:39 | Polk, Tennessee, US | |
521456 | 521456 | 2020-04-21 | US | Tennessee | Polk | 47139 | 7 | 0 | 0 | 5 | 35.12245443 | -84.52075859 | 2020-04-21 23:30:50 | Polk, Tennessee, US |
525834 | 525834 | 2021-06-09 | US | Tennessee | Polk | 47139 | 2095 | 25 | 0 | 35.12245443 | -84.52075859 | 2021-06-10 04:23:17 | Polk, Tennessee, US | |
528812 | 528812 | 2020-07-04 | US | Tennessee | Polk | 47139 | 49 | 0 | 0 | 45 | 35.12245443 | -84.52075859 | 2020-07-05 04:33:46 | Polk, Tennessee, US |
533680 | 533680 | 2021-02-22 | US | Tennessee | Polk | 47139 | 1708 | 21 | 0 | 1704 | 35.12245443 | -84.52075859 | 2021-02-23 05:23:41 | Polk, Tennessee, US |
537719 | 537719 | 2021-10-27 | US | Tennessee | Polk | 47139 | 3181 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-10-28 04:22:08 | Polk, Tennessee, US | |
541741 | 541741 | 2022-10-26 | US | Tennessee | Polk | 47139 | 5369 | 88 | 0 | 35.12245443 | -84.52075859 | 2022-10-27 04:22:01 | Polk, Tennessee, US | |
545757 | 545757 | 2022-12-15 | US | Tennessee | Polk | 47139 | 5506 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-16 04:21:01 | Polk, Tennessee, US | |
549718 | 549718 | 2020-09-12 | US | Tennessee | Polk | 47139 | 371 | 11 | 0 | 354 | 35.12245443 | -84.52075859 | 2020-09-13 04:30:52 | Polk, Tennessee, US |
553758 | 553758 | 2021-12-08 | US | Tennessee | Polk | 47139 | 3292 | 33 | 0 | 35.12245443 | -84.52075859 | 2021-12-09 04:22:49 | Polk, Tennessee, US | |
557774 | 557774 | 2022-01-16 | US | Tennessee | Polk | 47139 | 3812 | 50 | 0 | 35.12245443 | -84.52075859 | 2022-01-17 04:21:08 | Polk, Tennessee, US | |
561792 | 561792 | 2022-06-16 | US | Tennessee | Polk | 47139 | 4814 | 79 | 0 | 35.12245443 | -84.52075859 | 2022-06-17 04:20:56 | Polk, Tennessee, US | |
565946 | 565946 | 2021-06-22 | US | Tennessee | Polk | 47139 | 2106 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-06-23 04:21:46 | Polk, Tennessee, US | |
570087 | 570087 | 2021-10-29 | US | Tennessee | Polk | 47139 | 3185 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-10-30 04:22:03 | Polk, Tennessee, US | |
572989 | 572989 | 2020-06-06 | US | Tennessee | Polk | 47139 | 26 | 0 | 0 | 21 | 35.12245443 | -84.52075859 | 2020-06-07 03:53:30 | Polk, Tennessee, US |
577817 | 577817 | 2022-02-25 | US | Tennessee | Polk | 47139 | 4678 | 65 | 0 | 35.12245443 | -84.52075859 | 2022-02-26 04:21:12 | Polk, Tennessee, US | |
581812 | 581812 | 2021-07-13 | US | Tennessee | Polk | 47139 | 2114 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-07-14 04:21:35 | Polk, Tennessee, US | |
585787 | 585787 | 2020-08-13 | US | Tennessee | Polk | 47139 | 260 | 5 | 0 | 219 | 35.12245443 | -84.52075859 | 2020-08-14 04:51:19 | Polk, Tennessee, US |
588321 | 588321 | 2020-04-05 | US | Tennessee | Polk | 47139 | 3 | 0 | 0 | 3 | 35.12245443 | -84.52075859 | 2020-04-05 23:06:45 | Polk, Tennessee, US |
592608 | 592608 | 2021-08-08 | US | Tennessee | Polk | 47139 | 2230 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-08-09 04:21:24 | Polk, Tennessee, US | |
596644 | 596644 | 2022-07-01 | US | Tennessee | Polk | 47139 | 4881 | 80 | 0 | 35.12245443 | -84.52075859 | 2022-07-02 04:21:16 | Polk, Tennessee, US | |
600657 | 600657 | 2021-10-19 | US | Tennessee | Polk | 47139 | 3163 | 29 | 0 | 35.12245443 | -84.52075859 | 2021-10-20 04:21:00 | Polk, Tennessee, US | |
604672 | 604672 | 2021-09-23 | US | Tennessee | Polk | 47139 | 2982 | 25 | 0 | 35.12245443 | -84.52075859 | 2021-09-24 04:21:44 | Polk, Tennessee, US | |
608665 | 608665 | 2021-04-09 | US | Tennessee | Polk | 47139 | 1944 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-04-10 04:20:59 | Polk, Tennessee, US | |
612649 | 612649 | 2020-08-29 | US | Tennessee | Polk | 47139 | 346 | 10 | 0 | 316 | 35.12245443 | -84.52075859 | 2020-08-30 04:28:22 | Polk, Tennessee, US |
616662 | 616662 | 2021-02-08 | US | Tennessee | Polk | 47139 | 1600 | 21 | 0 | 1601 | 35.12245443 | -84.52075859 | 2021-02-09 05:23:30 | Polk, Tennessee, US |
620851 | 620851 | 2022-11-05 | US | Tennessee | Polk | 47139 | 5414 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-11-06 04:21:24 | Polk, Tennessee, US | |
624864 | 624864 | 2022-05-22 | US | Tennessee | Polk | 47139 | 4759 | 75 | 0 | 35.12245443 | -84.52075859 | 2022-05-26 04:20:50 | Polk, Tennessee, US | |
628858 | 628858 | 2021-07-10 | US | Tennessee | Polk | 47139 | 2114 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-07-11 04:21:43 | Polk, Tennessee, US | |
632894 | 632894 | 2022-07-12 | US | Tennessee | Polk | 47139 | 4939 | 82 | 0 | 35.12245443 | -84.52075859 | 2022-07-13 04:20:58 | Polk, Tennessee, US | |
636907 | 636907 | 2021-10-13 | US | Tennessee | Polk | 47139 | 3139 | 29 | 0 | 35.12245443 | -84.52075859 | 2021-10-14 04:21:29 | Polk, Tennessee, US | |
640898 | 640898 | 2021-03-31 | US | Tennessee | Polk | 47139 | 1909 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-04-01 04:27:05 | Polk, Tennessee, US | |
644918 | 644918 | 2021-09-07 | US | Tennessee | Polk | 47139 | 2731 | 25 | 0 | 35.12245443 | -84.52075859 | 2021-09-08 04:21:31 | Polk, Tennessee, US | |
648928 | 648928 | 2021-05-05 | US | Tennessee | Polk | 47139 | 2052 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-05-06 04:20:38 | Polk, Tennessee, US | |
652946 | 652946 | 2021-08-09 | US | Tennessee | Polk | 47139 | 2243 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-08-10 04:21:27 | Polk, Tennessee, US | |
656979 | 656979 | 2021-10-22 | US | Tennessee | Polk | 47139 | 3176 | 29 | 0 | 35.12245443 | -84.52075859 | 2021-10-23 04:21:32 | Polk, Tennessee, US | |
661299 | 661299 | 2022-05-13 | US | Tennessee | Polk | 47139 | 4754 | 74 | 0 | 35.12245443 | -84.52075859 | 2022-05-14 04:20:48 | Polk, Tennessee, US | |
665299 | 665299 | 2020-08-11 | US | Tennessee | Polk | 47139 | 236 | 3 | 0 | 210 | 35.12245443 | -84.52075859 | 2020-08-12 04:27:29 | Polk, Tennessee, US |
669243 | 669243 | 2020-09-16 | US | Tennessee | Polk | 47139 | 373 | 11 | 0 | 359 | 35.12245443 | -84.52075859 | 2020-09-17 04:22:00 | Polk, Tennessee, US |
673285 | 673285 | 2022-07-21 | US | Tennessee | Polk | 47139 | 5005 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-07-22 04:21:15 | Polk, Tennessee, US | |
677301 | 677301 | 2022-07-30 | US | Tennessee | Polk | 47139 | 5059 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-07-31 04:21:02 | Polk, Tennessee, US | |
681284 | 681284 | 2020-11-23 | US | Tennessee | Polk | 47139 | 620 | 14 | 0 | 618 | 35.12245443 | -84.52075859 | 2020-11-24 05:27:31 | Polk, Tennessee, US |
685324 | 685324 | 2021-10-24 | US | Tennessee | Polk | 47139 | 3180 | 29 | 0 | 35.12245443 | -84.52075859 | 2021-10-25 04:22:31 | Polk, Tennessee, US | |
689341 | 689341 | 2021-11-13 | US | Tennessee | Polk | 47139 | 3212 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-14 04:21:31 | Polk, Tennessee, US | |
693362 | 693362 | 2022-12-23 | US | Tennessee | Polk | 47139 | 5521 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-24 04:21:02 | Polk, Tennessee, US | |
697374 | 697374 | 2022-03-17 | US | Tennessee | Polk | 47139 | 4722 | 70 | 0 | 35.12245443 | -84.52075859 | 2022-03-18 04:20:55 | Polk, Tennessee, US | |
701389 | 701389 | 2021-11-04 | US | Tennessee | Polk | 47139 | 3197 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-05 04:21:54 | Polk, Tennessee, US | |
705379 | 705379 | 2021-03-16 | US | Tennessee | Polk | 47139 | 1824 | 24 | 0 | 35.12245443 | -84.52075859 | 2021-03-17 05:25:07 | Polk, Tennessee, US | |
709417 | 709417 | 2021-09-29 | US | Tennessee | Polk | 47139 | 3035 | 27 | 0 | 35.12245443 | -84.52075859 | 2021-09-30 04:21:20 | Polk, Tennessee, US | |
713439 | 713439 | 2022-11-01 | US | Tennessee | Polk | 47139 | 5388 | 88 | 0 | 35.12245443 | -84.52075859 | 2022-11-02 04:22:09 | Polk, 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]);