johns_hopkins_csse_daily_reports

⚠️ 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

13,502 rows where province_or_state = "Tennessee" sorted by day descending

View and edit SQL

province_or_state

  • Tennessee · 13,502

country_or_region

  • US 13,502
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391150 2020-08-08 US Tennessee Anderson 47001 676 6 0 670 36.12684348 -84.19965764 2020-08-09 04:34:54 Anderson, Tennessee, US
391259 2020-08-08 US Tennessee Bedford 47003 918 11 0 907 35.51123746 -86.45549096 2020-08-09 04:34:54 Bedford, Tennessee, US
391280 2020-08-08 US Tennessee Benton 47005 148 1 0 147 36.07110411 -88.06849355 2020-08-09 04:34:54 Benton, Tennessee, US
391313 2020-08-08 US Tennessee Bledsoe 47007 695 1 0 694 35.59942968 -85.20611967 2020-08-09 04:34:54 Bledsoe, Tennessee, US
391315 2020-08-08 US Tennessee Blount 47009 1277 11 0 1266 35.68938198 -83.92847788 2020-08-09 04:34:54 Blount, Tennessee, US
391351 2020-08-08 US Tennessee Bradley 47011 1903 12 0 1891 35.15739424 -84.857186 2020-08-09 04:34:54 Bradley, Tennessee, US
391466 2020-08-08 US Tennessee Campbell 47013 247 1 0 246 36.40355516 -84.15108559999999 2020-08-09 04:34:54 Campbell, Tennessee, US
391472 2020-08-08 US Tennessee Cannon 47015 143 0 0 143 35.80990797 -86.05738983 2020-08-09 04:34:54 Cannon, Tennessee, US
391497 2020-08-08 US Tennessee Carroll 47017 296 3 0 293 35.97366108 -88.45189331 2020-08-09 04:34:54 Carroll, Tennessee, US
391504 2020-08-08 US Tennessee Carter 47019 512 6 0 506 36.28969086 -82.12588974 2020-08-09 04:34:54 Carter, Tennessee, US
391562 2020-08-08 US Tennessee Cheatham 47021 578 7 0 571 36.26136216 -87.08903581 2020-08-09 04:34:54 Cheatham, Tennessee, US
391580 2020-08-08 US Tennessee Chester 47023 217 2 0 215 35.42527478 -88.6095842 2020-08-09 04:34:54 Chester, Tennessee, US
391613 2020-08-08 US Tennessee Claiborne 47025 266 0 0 266 36.48319149 -83.65947309 2020-08-09 04:34:54 Claiborne, Tennessee, US
391651 2020-08-08 US Tennessee Clay 47027 75 0 0 75 36.55151008 -85.53930419 2020-08-09 04:34:54 Clay, Tennessee, US
391683 2020-08-08 US Tennessee Cocke 47029 457 2 0 455 35.9278914 -83.11828725 2020-08-09 04:34:54 Cocke, Tennessee, US
391688 2020-08-08 US Tennessee Coffee 47031 522 3 0 519 35.49090731 -86.07311784 2020-08-09 04:34:54 Coffee, Tennessee, US
391772 2020-08-08 US Tennessee Crockett 47033 266 4 0 262 35.81830662 -89.14916269 2020-08-09 04:34:54 Crockett, Tennessee, US
391790 2020-08-08 US Tennessee Cumberland 47035 450 6 0 444 35.95271721 -84.99840585 2020-08-09 04:34:54 Cumberland, Tennessee, US
391822 2020-08-08 US Tennessee Davidson 47037 20383 213 0 20170 36.17007426 -86.78646056 2020-08-09 04:34:54 Davidson, Tennessee, US
391844 2020-08-08 US Tennessee DeKalb 47041 349 2 0 347 35.97616272 -85.83689361 2020-08-09 04:34:54 DeKalb, Tennessee, US
391854 2020-08-08 US Tennessee Decatur 47039 198 3 0 195 35.60048904 -88.11043779 2020-08-09 04:34:54 Decatur, Tennessee, US
391884 2020-08-08 US Tennessee Dickson 47043 679 2 0 677 36.14669837 -87.35891709 2020-08-09 04:34:54 Dickson, Tennessee, US
391934 2020-08-08 US Tennessee Dyer 47045 628 7 0 621 36.05931946 -89.41542855 2020-08-09 04:34:54 Dyer, Tennessee, US
392020 2020-08-08 US Tennessee Fayette 47047 686 8 0 678 35.19615831 -89.41399032 2020-08-09 04:34:54 Fayette, Tennessee, US
392024 2020-08-08 US Tennessee Fentress 47049 92 0 0 92 36.38128818 -84.92870012 2020-08-09 04:34:54 Fentress, Tennessee, US
392076 2020-08-08 US Tennessee Franklin 47051 325 4 0 321 35.15634626 -86.09201039 2020-08-09 04:34:54 Franklin, Tennessee, US
392136 2020-08-08 US Tennessee Gibson 47053 693 5 0 688 35.99438059 -88.93358327 2020-08-09 04:34:54 Gibson, Tennessee, US
392139 2020-08-08 US Tennessee Giles 47055 378 13 0 365 35.20222469 -87.03992678 2020-08-09 04:34:54 Giles, Tennessee, US
392173 2020-08-08 US Tennessee Grainger 47057 196 0 0 196 36.27469206 -83.51254721 2020-08-09 04:34:54 Grainger, Tennessee, US
392221 2020-08-08 US Tennessee Greene 47059 467 8 0 459 36.17470125 -82.84691273 2020-08-09 04:34:54 Greene, Tennessee, US
392238 2020-08-08 US Tennessee Grundy 47061 113 2 0 111 35.38433717 -85.72142731 2020-08-09 04:34:54 Grundy, Tennessee, US
392262 2020-08-08 US Tennessee Hamblen 47063 1383 14 0 1369 36.21990035 -83.26586179 2020-08-09 04:34:54 Hamblen, Tennessee, US
392271 2020-08-08 US Tennessee Hamilton 47065 6062 53 0 6009 35.17670231 -85.16652245 2020-08-09 04:34:54 Hamilton, Tennessee, US
392287 2020-08-08 US Tennessee Hancock 47067 78 2 0 76 36.52692871 -83.22375847 2020-08-09 04:34:54 Hancock, Tennessee, US
392295 2020-08-08 US Tennessee Hardeman 47069 898 17 0 881 35.20772017 -88.99161161 2020-08-09 04:34:54 Hardeman, Tennessee, US
392301 2020-08-08 US Tennessee Hardin 47071 462 8 0 454 35.19732531 -88.18593755 2020-08-09 04:34:54 Hardin, Tennessee, US
392334 2020-08-08 US Tennessee Hawkins 47073 451 7 0 444 36.44355426 -82.94885298 2020-08-09 04:34:54 Hawkins, Tennessee, US
392338 2020-08-08 US Tennessee Haywood 47075 463 6 0 457 35.58332824 -89.28536625 2020-08-09 04:34:54 Haywood, Tennessee, US
392345 2020-08-08 US Tennessee Henderson 47077 563 2 0 561 35.65581134 -88.38600175 2020-08-09 04:34:54 Henderson, Tennessee, US
392359 2020-08-08 US Tennessee Henry 47079 276 0 0 276 36.33160906 -88.30121797 2020-08-09 04:34:54 Henry, Tennessee, US
392366 2020-08-08 US Tennessee Hickman 47081 259 0 0 259 35.80609681 -87.47643507 2020-08-09 04:34:54 Hickman, Tennessee, US
392405 2020-08-08 US Tennessee Houston 47083 57 0 0 57 36.28872054 -87.71878828 2020-08-09 04:34:54 Houston, Tennessee, US
392426 2020-08-08 US Tennessee Humphreys 47085 120 3 0 117 36.03958805 -87.77992872 2020-08-09 04:34:54 Humphreys, Tennessee, US
392488 2020-08-08 US Tennessee Jackson 47087 124 1 0 123 36.36380466 -85.67239905 2020-08-09 04:34:54 Jackson, Tennessee, US
392526 2020-08-08 US Tennessee Jefferson 47089 559 3 0 556 36.04818632 -83.45148924 2020-08-09 04:34:54 Jefferson, Tennessee, US
392552 2020-08-08 US Tennessee Johnson 47091 265 0 0 265 36.45523950000001 -81.84886538 2020-08-09 04:34:54 Johnson, Tennessee, US
392636 2020-08-08 US Tennessee Knox 47093 4513 38 0 4475 35.99508821 -83.94635435 2020-08-09 04:34:54 Knox, Tennessee, US
392676 2020-08-08 US Tennessee Lake 47095 782 0 0 782 36.34180170000001 -89.48921915 2020-08-09 04:34:54 Lake, Tennessee, US
392707 2020-08-08 US Tennessee Lauderdale 47097 489 8 0 481 35.75893438 -89.63015909999999 2020-08-09 04:34:54 Lauderdale, Tennessee, US
392722 2020-08-08 US Tennessee Lawrence 47099 550 6 0 544 35.21675201 -87.39787695 2020-08-09 04:34:54 Lawrence, Tennessee, US
392755 2020-08-08 US Tennessee Lewis 47101 73 1 0 72 35.52853208 -87.49022694 2020-08-09 04:34:54 Lewis, Tennessee, US
392787 2020-08-08 US Tennessee Lincoln 47103 280 1 0 279 35.13738622 -86.58910106 2020-08-09 04:34:54 Lincoln, Tennessee, US
392823 2020-08-08 US Tennessee Loudon 47105 725 3 0 722 35.73939663 -84.31145275 2020-08-09 04:34:54 Loudon, Tennessee, US
392858 2020-08-08 US Tennessee Macon 47111 858 13 0 845 36.53157855 -86.00778595 2020-08-09 04:34:54 Macon, Tennessee, US
392878 2020-08-08 US Tennessee Madison 47113 1064 17 0 1047 35.61181957 -88.84076036 2020-08-09 04:34:54 Madison, Tennessee, US
392914 2020-08-08 US Tennessee Marion 47115 222 4 0 218 35.12997174 -85.62265895 2020-08-09 04:34:54 Marion, Tennessee, US
392931 2020-08-08 US Tennessee Marshall 47117 290 3 0 287 35.45798777 -86.76420988 2020-08-09 04:34:54 Marshall, Tennessee, US
392952 2020-08-08 US Tennessee Maury 47119 1225 7 0 1218 35.6187413 -87.07462444 2020-08-09 04:34:54 Maury, Tennessee, US
392982 2020-08-08 US Tennessee McMinn 47107 531 20 0 511 35.42812616 -84.61520715 2020-08-09 04:34:54 McMinn, Tennessee, US
392984 2020-08-08 US Tennessee McNairy 47109 371 5 0 366 35.17468549 -88.5647812 2020-08-09 04:34:54 McNairy, Tennessee, US
392999 2020-08-08 US Tennessee Meigs 47121 104 0 0 104 35.51558739 -84.81482914 2020-08-09 04:34:54 Meigs, Tennessee, US
393081 2020-08-08 US Tennessee Monroe 47123 418 9 0 409 35.44550387 -84.24902965 2020-08-09 04:34:54 Monroe, Tennessee, US
393103 2020-08-08 US Tennessee Montgomery 47125 1902 13 0 1889 36.49609412 -87.38550661 2020-08-09 04:34:54 Montgomery, Tennessee, US
393111 2020-08-08 US Tennessee Moore 47127 61 0 0 61 35.27724699 -86.36230578 2020-08-09 04:34:54 Moore, Tennessee, US
393123 2020-08-08 US Tennessee Morgan 47129 118 1 0 117 36.13248031 -84.64880098 2020-08-09 04:34:54 Morgan, Tennessee, US
393222 2020-08-08 US Tennessee Obion 47131 546 4 0 542 36.35732446 -89.14921589 2020-08-09 04:34:54 Obion, Tennessee, US
393298 2020-08-08 US Tennessee Out of TN 80047 2860 14 0 2846 36.55606529 0.0 2020-08-09 04:34:54 Out of TN, Tennessee, US
393300 2020-08-08 US Tennessee Overton 47133 180 1 0 179 36.34117832 -85.28989535 2020-08-09 04:34:54 Overton, Tennessee, US
393362 2020-08-08 US Tennessee Perry 47135 79 0 0 79 35.63708728 -87.86139634 2020-08-09 04:34:54 Perry, Tennessee, US
393380 2020-08-08 US Tennessee Pickett 47137 31 1 0 30 36.55606529 -85.07763299999998 2020-08-09 04:34:54 Pickett, Tennessee, US
393428 2020-08-08 US Tennessee Polk 47139 204 3 0 201 35.12245443 -84.52075859 2020-08-09 04:34:54 Polk, Tennessee, US
393488 2020-08-08 US Tennessee Putnam 47141 1740 18 0 1722 36.14005459 -85.50646123 2020-08-09 04:34:54 Putnam, Tennessee, US
393533 2020-08-08 US Tennessee Rhea 47143 528 2 0 526 35.60536161 -84.93076643 2020-08-09 04:34:54 Rhea, Tennessee, US
393559 2020-08-08 US Tennessee Roane 47145 461 2 0 459 35.84923189 -84.52458689 2020-08-09 04:34:54 Roane, Tennessee, US
393566 2020-08-08 US Tennessee Robertson 47147 1535 19 0 1516 36.52454807 -86.87346725 2020-08-09 04:34:54 Robertson, Tennessee, US
393604 2020-08-08 US Tennessee Rutherford 47149 6463 54 0 6409 35.84591405 -86.4107263 2020-08-09 04:34:54 Rutherford, Tennessee, US
393687 2020-08-08 US Tennessee Scott 47151 118 0 0 118 36.42325673 -84.50360494 2020-08-09 04:34:54 Scott, Tennessee, US
393701 2020-08-08 US Tennessee Sequatchie 47153 105 0 0 105 35.36979721 -85.41022136 2020-08-09 04:34:54 Sequatchie, Tennessee, US
393704 2020-08-08 US Tennessee Sevier 47155 1850 7 0 1843 35.78077323 -83.52244332 2020-08-09 04:34:54 Sevier, Tennessee, US
393722 2020-08-08 US Tennessee Shelby 47157 22916 301 0 22615 35.1864775 -89.89692423 2020-08-09 04:34:54 Shelby, Tennessee, US
393753 2020-08-08 US Tennessee Smith 47159 445 4 0 441 36.25359775 -85.95411046 2020-08-09 04:34:54 Smith, Tennessee, US
393831 2020-08-08 US Tennessee Stewart 47161 74 0 0 74 36.50235092 -87.83920548 2020-08-09 04:34:54 Stewart, Tennessee, US
393852 2020-08-08 US Tennessee Sullivan 47163 962 14 0 948 36.51240691 -82.30412917 2020-08-09 04:34:54 Sullivan, Tennessee, US
393859 2020-08-08 US Tennessee Sumner 47165 3404 73 0 3331 36.46824103 -86.45917204 2020-08-09 04:34:54 Sumner, Tennessee, US
393930 2020-08-08 US Tennessee Tipton 47167 1195 9 0 1186 35.501942 -89.73694895 2020-08-09 04:34:54 Tipton, Tennessee, US
393962 2020-08-08 US Tennessee Trousdale 47169 1582 6 0 1576 36.39026213 -86.16087954 2020-08-09 04:34:54 Trousdale, Tennessee, US
394023 2020-08-08 US Tennessee Unassigned 90047 3128 10 0 3118 36.55606529 0.0 2020-08-09 04:34:54 Unassigned, Tennessee, US
394031 2020-08-08 US Tennessee Unicoi 47171 161 0 0 161 36.10890856 -82.43709629 2020-08-09 04:34:54 Unicoi, Tennessee, US
394049 2020-08-08 US Tennessee Union 47173 154 0 0 154 36.28590426 -83.83651902 2020-08-09 04:34:54 Union, Tennessee, US
394066 2020-08-08 US Tennessee Van Buren 47175 36 0 0 36 35.69864497 -85.45221699 2020-08-09 04:34:54 Van Buren, Tennessee, US
394127 2020-08-08 US Tennessee Warren 47177 507 4 0 503 35.6728299 -85.77969117 2020-08-09 04:34:54 Warren, Tennessee, US
394160 2020-08-08 US Tennessee Washington 47179 1225 2 0 1223 36.29472368 -82.49454720000001 2020-08-09 04:34:54 Washington, Tennessee, US
394186 2020-08-08 US Tennessee Wayne 47181 225 2 0 223 35.23868267 -87.78644456 2020-08-09 04:34:54 Wayne, Tennessee, US
394189 2020-08-08 US Tennessee Weakley 47183 421 4 0 417 36.29896232 -88.71990865 2020-08-09 04:34:54 Weakley, Tennessee, US
394222 2020-08-08 US Tennessee White 47185 281 5 0 276 35.92929884 -85.45591799 2020-08-09 04:34:54 White, Tennessee, US
394248 2020-08-08 US Tennessee Williamson 47187 3478 25 0 3453 35.89099229 -86.89281867 2020-08-09 04:34:54 Williamson, Tennessee, US
394252 2020-08-08 US Tennessee Wilson 47189 2262 23 0 2239 36.15496772 -86.29775884 2020-08-09 04:34:54 Wilson, Tennessee, US
281714 2020-08-07 US Tennessee Anderson 47001 668 6 0 662 36.12684348 -84.19965764 2020-08-08 04:34:53 Anderson, Tennessee, US
281823 2020-08-07 US Tennessee Bedford 47003 908 11 0 897 35.51123746 -86.45549096 2020-08-08 04:34:53 Bedford, Tennessee, US
281844 2020-08-07 US Tennessee Benton 47005 139 1 0 138 36.07110411 -88.06849355 2020-08-08 04:34:53 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]);
Powered by Datasette · Query took 2148.5ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette