johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

33,678 rows where province_or_state = "Tennessee" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state

  • Tennessee · 33,678 ✖

country_or_region

  • US 33,678
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
903587 903587 2021-03-04 US Tennessee Anderson 47001 8044 158 0 7886 36.12684348 -84.19965764 2021-03-05 05:26:29 Anderson, Tennessee, US
903588 903588 2021-03-04 US Tennessee Bedford 47003 5816 120 0 5696 35.51123746 -86.45549096 2021-03-05 05:26:29 Bedford, Tennessee, US
903589 903589 2021-03-04 US Tennessee Benton 47005 1510 39 0 1471 36.07110411 -88.06849355 2021-03-05 05:26:29 Benton, Tennessee, US
903590 903590 2021-03-04 US Tennessee Bledsoe 47007 2010 10 0 2000 35.59942968 -85.20611967 2021-03-05 05:26:29 Bledsoe, Tennessee, US
903591 903591 2021-03-04 US Tennessee Blount 47009 14141 183 0 13958 35.68938198 -83.92847788 2021-03-05 05:26:29 Blount, Tennessee, US
903592 903592 2021-03-04 US Tennessee Bradley 47011 12996 141 0 12855 35.15739424 -84.857186 2021-03-05 05:26:29 Bradley, Tennessee, US
903593 903593 2021-03-04 US Tennessee Campbell 47013 3818 59 0 3759 36.40355516 -84.15108559999999 2021-03-05 05:26:29 Campbell, Tennessee, US
903594 903594 2021-03-04 US Tennessee Cannon 47015 1767 30 0 1737 35.80990797 -86.05738983 2021-03-05 05:26:29 Cannon, Tennessee, US
903595 903595 2021-03-04 US Tennessee Carroll 47017 3491 81 0 3410 35.97366108 -88.45189331 2021-03-05 05:26:29 Carroll, Tennessee, US
903596 903596 2021-03-04 US Tennessee Carter 47019 5990 155 0 5835 36.28969086 -82.12588974 2021-03-05 05:26:29 Carter, Tennessee, US
903597 903597 2021-03-04 US Tennessee Cheatham 47021 3945 44 0 3901 36.26136216 -87.08903581 2021-03-05 05:26:29 Cheatham, Tennessee, US
903598 903598 2021-03-04 US Tennessee Chester 47023 2023 48 0 1975 35.42527478 -88.6095842 2021-03-05 05:26:29 Chester, Tennessee, US
903599 903599 2021-03-04 US Tennessee Claiborne 47025 2830 69 0 2761 36.48319149 -83.65947309 2021-03-05 05:26:29 Claiborne, Tennessee, US
903600 903600 2021-03-04 US Tennessee Clay 47027 1071 30 0 1041 36.55151008 -85.53930419 2021-03-05 05:26:29 Clay, Tennessee, US
903601 903601 2021-03-04 US Tennessee Cocke 47029 4012 95 0 3917 35.9278914 -83.11828725 2021-03-05 05:26:29 Cocke, Tennessee, US
903602 903602 2021-03-04 US Tennessee Coffee 47031 6418 115 0 6303 35.49090731 -86.07311784 2021-03-05 05:26:29 Coffee, Tennessee, US
903603 903603 2021-03-04 US Tennessee Crockett 47033 1975 47 0 1928 35.81830662 -89.14916269 2021-03-05 05:26:29 Crockett, Tennessee, US
903604 903604 2021-03-04 US Tennessee Cumberland 47035 6127 122 0 6005 35.95271721 -84.99840585 2021-03-05 05:26:29 Cumberland, Tennessee, US
903605 903605 2021-03-04 US Tennessee Davidson 47037 81809 871 0 80938 36.17007426 -86.78646056 2021-03-05 05:26:29 Davidson, Tennessee, US
903606 903606 2021-03-04 US Tennessee DeKalb 47041 2661 51 0 2610 35.97616272 -85.83689361 2021-03-05 05:26:29 DeKalb, Tennessee, US
903607 903607 2021-03-04 US Tennessee Decatur 47039 1538 37 0 1501 35.60048904 -88.11043779 2021-03-05 05:26:29 Decatur, Tennessee, US
903608 903608 2021-03-04 US Tennessee Dickson 47043 6256 106 0 6150 36.14669837 -87.35891709 2021-03-05 05:26:29 Dickson, Tennessee, US
903609 903609 2021-03-04 US Tennessee Dyer 47045 5242 101 0 5141 36.05931946 -89.41542855 2021-03-05 05:26:29 Dyer, Tennessee, US
903610 903610 2021-03-04 US Tennessee Fayette 47047 4683 72 0 4611 35.19615831 -89.41399032 2021-03-05 05:26:29 Fayette, Tennessee, US
903611 903611 2021-03-04 US Tennessee Fentress 47049 2295 44 0 2251 36.38128818 -84.92870012 2021-03-05 05:26:29 Fentress, Tennessee, US
903612 903612 2021-03-04 US Tennessee Franklin 47051 4757 85 0 4672 35.15634626 -86.09201039 2021-03-05 05:26:29 Franklin, Tennessee, US
903613 903613 2021-03-04 US Tennessee Gibson 47053 6196 141 0 6055 35.99438059 -88.93358327 2021-03-05 05:26:29 Gibson, Tennessee, US
903614 903614 2021-03-04 US Tennessee Giles 47055 3752 97 0 3655 35.20222469 -87.03992678 2021-03-05 05:26:29 Giles, Tennessee, US
903615 903615 2021-03-04 US Tennessee Grainger 47057 2442 46 0 2396 36.27469206 -83.51254721 2021-03-05 05:26:29 Grainger, Tennessee, US
903616 903616 2021-03-04 US Tennessee Greene 47059 7309 145 0 7164 36.17470125 -82.84691273 2021-03-05 05:26:29 Greene, Tennessee, US
903617 903617 2021-03-04 US Tennessee Grundy 47061 1697 30 0 1667 35.38433717 -85.72142731 2021-03-05 05:26:29 Grundy, Tennessee, US
903618 903618 2021-03-04 US Tennessee Hamblen 47063 8063 165 0 7898 36.21990035 -83.26586179 2021-03-05 05:26:29 Hamblen, Tennessee, US
903619 903619 2021-03-04 US Tennessee Hamilton 47065 40539 463 0 40076 35.17670231 -85.16652245 2021-03-05 05:26:29 Hamilton, Tennessee, US
903620 903620 2021-03-04 US Tennessee Hancock 47067 497 12 0 485 36.52692871 -83.22375847 2021-03-05 05:26:29 Hancock, Tennessee, US
903621 903621 2021-03-04 US Tennessee Hardeman 47069 3388 64 0 3324 35.20772017 -88.99161161 2021-03-05 05:26:29 Hardeman, Tennessee, US
903622 903622 2021-03-04 US Tennessee Hardin 47071 3315 63 0 3252 35.19732531 -88.18593755 2021-03-05 05:26:29 Hardin, Tennessee, US
903623 903623 2021-03-04 US Tennessee Hawkins 47073 5271 95 0 5176 36.44355426 -82.94885298 2021-03-05 05:26:29 Hawkins, Tennessee, US
903624 903624 2021-03-04 US Tennessee Haywood 47075 2649 60 0 2589 35.58332824 -89.28536625 2021-03-05 05:26:29 Haywood, Tennessee, US
903625 903625 2021-03-04 US Tennessee Henderson 47077 3622 73 0 3549 35.65581134 -88.38600175 2021-03-05 05:26:29 Henderson, Tennessee, US
903626 903626 2021-03-04 US Tennessee Henry 47079 3012 75 0 2937 36.33160906 -88.30121797 2021-03-05 05:26:29 Henry, Tennessee, US
903627 903627 2021-03-04 US Tennessee Hickman 47081 2665 41 0 2624 35.80609681 -87.47643507 2021-03-05 05:26:29 Hickman, Tennessee, US
903628 903628 2021-03-04 US Tennessee Houston 47083 1036 32 0 1004 36.28872054 -87.71878828 2021-03-05 05:26:29 Houston, Tennessee, US
903629 903629 2021-03-04 US Tennessee Humphreys 47085 1549 21 0 1528 36.03958805 -87.77992872 2021-03-05 05:26:29 Humphreys, Tennessee, US
903630 903630 2021-03-04 US Tennessee Jackson 47087 1256 34 0 1222 36.36380466 -85.67239905 2021-03-05 05:26:29 Jackson, Tennessee, US
903631 903631 2021-03-04 US Tennessee Jefferson 47089 5688 119 0 5569 36.04818632 -83.45148924 2021-03-05 05:26:29 Jefferson, Tennessee, US
903632 903632 2021-03-04 US Tennessee Johnson 47091 2171 38 0 2133 36.45523950000001 -81.84886538 2021-03-05 05:26:29 Johnson, Tennessee, US
903633 903633 2021-03-04 US Tennessee Knox 47093 46250 587 0 45663 35.99508821 -83.94635435 2021-03-05 05:26:29 Knox, Tennessee, US
903634 903634 2021-03-04 US Tennessee Lake 47095 1679 26 0 1653 36.34180170000001 -89.48921915 2021-03-05 05:26:29 Lake, Tennessee, US
903635 903635 2021-03-04 US Tennessee Lauderdale 47097 3096 42 0 3054 35.75893438 -89.63015909999999 2021-03-05 05:26:29 Lauderdale, Tennessee, US
903636 903636 2021-03-04 US Tennessee Lawrence 47099 5574 83 0 5491 35.21675201 -87.39787695 2021-03-05 05:26:29 Lawrence, Tennessee, US
903637 903637 2021-03-04 US Tennessee Lewis 47101 1474 25 0 1449 35.52853208 -87.49022694 2021-03-05 05:26:29 Lewis, Tennessee, US
903638 903638 2021-03-04 US Tennessee Lincoln 47103 4156 62 0 4094 35.13738622 -86.58910106 2021-03-05 05:26:29 Lincoln, Tennessee, US
903639 903639 2021-03-04 US Tennessee Loudon 47105 5719 66 0 5653 35.73939663 -84.31145275 2021-03-05 05:26:29 Loudon, Tennessee, US
903640 903640 2021-03-04 US Tennessee Macon 47111 3372 73 0 3299 36.53157855 -86.00778595 2021-03-05 05:26:29 Macon, Tennessee, US
903641 903641 2021-03-04 US Tennessee Madison 47113 10123 230 0 9893 35.61181957 -88.84076036 2021-03-05 05:26:29 Madison, Tennessee, US
903642 903642 2021-03-04 US Tennessee Marion 47115 2947 44 0 2903 35.12997174 -85.62265895 2021-03-05 05:26:29 Marion, Tennessee, US
903643 903643 2021-03-04 US Tennessee Marshall 47117 3919 56 0 3863 35.45798777 -86.76420988 2021-03-05 05:26:29 Marshall, Tennessee, US
903644 903644 2021-03-04 US Tennessee Maury 47119 12246 163 0 12083 35.6187413 -87.07462444 2021-03-05 05:26:29 Maury, Tennessee, US
903645 903645 2021-03-04 US Tennessee McMinn 47107 5945 92 0 5853 35.42812616 -84.61520715 2021-03-05 05:26:29 McMinn, Tennessee, US
903646 903646 2021-03-04 US Tennessee McNairy 47109 2683 53 0 2630 35.17468549 -88.5647812 2021-03-05 05:26:29 McNairy, Tennessee, US
903647 903647 2021-03-04 US Tennessee Meigs 47121 1267 22 0 1245 35.51558739 -84.81482914 2021-03-05 05:26:29 Meigs, Tennessee, US
903648 903648 2021-03-04 US Tennessee Monroe 47123 5365 90 0 5275 35.44550387 -84.24902965 2021-03-05 05:26:29 Monroe, Tennessee, US
903649 903649 2021-03-04 US Tennessee Montgomery 47125 17484 213 0 17271 36.49609412 -87.38550661 2021-03-05 05:26:29 Montgomery, Tennessee, US
903650 903650 2021-03-04 US Tennessee Moore 47127 945 16 0 929 35.27724699 -86.36230578 2021-03-05 05:26:29 Moore, Tennessee, US
903651 903651 2021-03-04 US Tennessee Morgan 47129 2303 38 0 2265 36.13248031 -84.64880098 2021-03-05 05:26:29 Morgan, Tennessee, US
903652 903652 2021-03-04 US Tennessee Obion 47131 4369 95 0 4274 36.35732446 -89.14921589 2021-03-05 05:26:29 Obion, Tennessee, US
903653 903653 2021-03-04 US Tennessee Out of TN 80047 17066 94 0 16972 36.55606529 0.0 2021-03-05 05:26:29 Out of TN, Tennessee, US
903654 903654 2021-03-04 US Tennessee Overton 47133 2855 57 0 2798 36.34117832 -85.28989535 2021-03-05 05:26:29 Overton, Tennessee, US
903655 903655 2021-03-04 US Tennessee Perry 47135 1035 27 0 1008 35.63708728 -87.86139634 2021-03-05 05:26:29 Perry, Tennessee, US
903656 903656 2021-03-04 US Tennessee Pickett 47137 746 23 0 723 36.55606529 -85.07763299999998 2021-03-05 05:26:29 Pickett, Tennessee, US
903657 903657 2021-03-04 US Tennessee Polk 47139 1777 22 0 1755 35.12245443 -84.52075859 2021-03-05 05:26:29 Polk, Tennessee, US
903658 903658 2021-03-04 US Tennessee Putnam 47141 10635 170 0 10465 36.14005459 -85.50646123 2021-03-05 05:26:29 Putnam, Tennessee, US
903659 903659 2021-03-04 US Tennessee Rhea 47143 4152 73 0 4079 35.60536161 -84.93076643 2021-03-05 05:26:29 Rhea, Tennessee, US
903660 903660 2021-03-04 US Tennessee Roane 47145 5926 96 0 5830 35.84923189 -84.52458689 2021-03-05 05:26:29 Roane, Tennessee, US
903661 903661 2021-03-04 US Tennessee Robertson 47147 8997 121 0 8876 36.52454807 -86.87346725 2021-03-05 05:26:29 Robertson, Tennessee, US
903662 903662 2021-03-04 US Tennessee Rutherford 47149 38563 386 0 38177 35.84591405 -86.4107263 2021-03-05 05:26:29 Rutherford, Tennessee, US
903663 903663 2021-03-04 US Tennessee Scott 47151 2881 44 0 2837 36.42325673 -84.50360494 2021-03-05 05:26:29 Scott, Tennessee, US
903664 903664 2021-03-04 US Tennessee Sequatchie 47153 1573 27 0 1546 35.36979721 -85.41022136 2021-03-05 05:26:29 Sequatchie, Tennessee, US
903665 903665 2021-03-04 US Tennessee Sevier 47155 12109 164 0 11945 35.78077323 -83.52244332 2021-03-05 05:26:29 Sevier, Tennessee, US
903666 903666 2021-03-04 US Tennessee Shelby 47157 87618 1509 0 86109 35.1864775 -89.89692423 2021-03-05 05:26:29 Shelby, Tennessee, US
903667 903667 2021-03-04 US Tennessee Smith 47159 2569 36 0 2533 36.25359775 -85.95411046 2021-03-05 05:26:29 Smith, Tennessee, US
903668 903668 2021-03-04 US Tennessee Stewart 47161 1240 25 0 1215 36.50235092 -87.83920548 2021-03-05 05:26:29 Stewart, Tennessee, US
903669 903669 2021-03-04 US Tennessee Sullivan 47163 14431 274 0 14157 36.51240691 -82.30412917 2021-03-05 05:26:29 Sullivan, Tennessee, US
903670 903670 2021-03-04 US Tennessee Sumner 47165 21448 318 0 21130 36.46824103 -86.45917204 2021-03-05 05:26:29 Sumner, Tennessee, US
903671 903671 2021-03-04 US Tennessee Tipton 47167 6962 103 0 6859 35.501942 -89.73694895 2021-03-05 05:26:29 Tipton, Tennessee, US
903672 903672 2021-03-04 US Tennessee Trousdale 47169 2398 22 0 2376 36.39026213 -86.16087954 2021-03-05 05:26:29 Trousdale, Tennessee, US
903673 903673 2021-03-04 US Tennessee Unassigned 90047 15772 127 0 15645 36.55606529 0.0 2021-03-05 05:26:29 Unassigned, Tennessee, US
903674 903674 2021-03-04 US Tennessee Unicoi 47171 1814 47 0 1767 36.10890856 -82.43709629 2021-03-05 05:26:29 Unicoi, Tennessee, US
903675 903675 2021-03-04 US Tennessee Union 47173 1730 33 0 1697 36.28590426 -83.83651902 2021-03-05 05:26:29 Union, Tennessee, US
903676 903676 2021-03-04 US Tennessee Van Buren 47175 797 20 0 777 35.69864497 -85.45221699 2021-03-05 05:26:29 Van Buren, Tennessee, US
903677 903677 2021-03-04 US Tennessee Warren 47177 5325 76 0 5249 35.6728299 -85.77969117 2021-03-05 05:26:29 Warren, Tennessee, US
903678 903678 2021-03-04 US Tennessee Washington 47179 12818 234 0 12584 36.29472368 -82.49454720000001 2021-03-05 05:26:29 Washington, Tennessee, US
903679 903679 2021-03-04 US Tennessee Wayne 47181 2876 30 0 2846 35.23868267 -87.78644456 2021-03-05 05:26:29 Wayne, Tennessee, US
903680 903680 2021-03-04 US Tennessee Weakley 47183 3793 59 0 3734 36.29896232 -88.71990865 2021-03-05 05:26:29 Weakley, Tennessee, US
903681 903681 2021-03-04 US Tennessee White 47185 3393 66 0 3327 35.92929884 -85.45591799 2021-03-05 05:26:29 White, Tennessee, US
903682 903682 2021-03-04 US Tennessee Williamson 47187 25382 204 0 25178 35.89099229 -86.89281867 2021-03-05 05:26:29 Williamson, Tennessee, US
903683 903683 2021-03-04 US Tennessee Wilson 47189 16510 211 0 16299 36.15496772 -86.29775884 2021-03-05 05:26:29 Wilson, Tennessee, US
911312 911312 2021-03-03 US Tennessee Anderson 47001 8027 158 0 7869 36.12684348 -84.19965764 2021-03-04 05:24:24 Anderson, Tennessee, US
911313 911313 2021-03-03 US Tennessee Bedford 47003 5802 120 0 5682 35.51123746 -86.45549096 2021-03-04 05:24:24 Bedford, Tennessee, US
911314 911314 2021-03-03 US Tennessee Benton 47005 1510 39 0 1471 36.07110411 -88.06849355 2021-03-04 05:24:24 Benton, Tennessee, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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] INTEGER,
   [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]);