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

56,279 rows where province_or_state = "Tennessee" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state

  • Tennessee · 56,279 ✖

country_or_region

  • US 56,279
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
35196 35196 2021-10-23 US Tennessee Anderson 47001 12881 215 0   36.12684348 -84.19965764 2021-10-24 04:21:22 Anderson, Tennessee, US
35197 35197 2021-10-23 US Tennessee Bedford 47003 9115 154 0   35.51123746 -86.45549096 2021-10-24 04:21:22 Bedford, Tennessee, US
35198 35198 2021-10-23 US Tennessee Benton 47005 2770 52 0   36.07110411 -88.06849355 2021-10-24 04:21:22 Benton, Tennessee, US
35199 35199 2021-10-23 US Tennessee Bledsoe 47007 3479 18 0   35.59942968 -85.20611967 2021-10-24 04:21:22 Bledsoe, Tennessee, US
35200 35200 2021-10-23 US Tennessee Blount 47009 23605 265 0   35.68938198 -83.92847788 2021-10-24 04:21:22 Blount, Tennessee, US
35201 35201 2021-10-23 US Tennessee Bradley 47011 22034 193 0   35.15739424 -84.857186 2021-10-24 04:21:22 Bradley, Tennessee, US
35202 35202 2021-10-23 US Tennessee Campbell 47013 7183 80 0   36.40355516 -84.15108559999999 2021-10-24 04:21:22 Campbell, Tennessee, US
35203 35203 2021-10-23 US Tennessee Cannon 47015 2786 42 0   35.80990797 -86.05738983 2021-10-24 04:21:22 Cannon, Tennessee, US
35204 35204 2021-10-23 US Tennessee Carroll 47017 5712 102 0   35.97366108 -88.45189331 2021-10-24 04:21:22 Carroll, Tennessee, US
35205 35205 2021-10-23 US Tennessee Carter 47019 10480 213 0   36.28969086 -82.12588974 2021-10-24 04:21:22 Carter, Tennessee, US
35206 35206 2021-10-23 US Tennessee Cheatham 47021 6974 70 0   36.26136216 -87.08903581 2021-10-24 04:21:22 Cheatham, Tennessee, US
35207 35207 2021-10-23 US Tennessee Chester 47023 3510 73 0   35.42527478 -88.6095842 2021-10-24 04:21:22 Chester, Tennessee, US
35208 35208 2021-10-23 US Tennessee Claiborne 47025 5393 111 0   36.48319149 -83.65947309 2021-10-24 04:21:22 Claiborne, Tennessee, US
35209 35209 2021-10-23 US Tennessee Clay 47027 1517 37 0   36.55151008 -85.53930419 2021-10-24 04:21:22 Clay, Tennessee, US
35210 35210 2021-10-23 US Tennessee Cocke 47029 7348 106 0   35.9278914 -83.11828725 2021-10-24 04:21:22 Cocke, Tennessee, US
35211 35211 2021-10-23 US Tennessee Coffee 47031 10483 155 0   35.49090731 -86.07311784 2021-10-24 04:21:22 Coffee, Tennessee, US
35212 35212 2021-10-23 US Tennessee Crockett 47033 3344 62 0   35.81830662 -89.14916269 2021-10-24 04:21:22 Crockett, Tennessee, US
35213 35213 2021-10-23 US Tennessee Cumberland 47035 11015 219 0   35.95271721 -84.99840585 2021-10-24 04:21:22 Cumberland, Tennessee, US
35214 35214 2021-10-23 US Tennessee Davidson 47037 120580 1147 0   36.17007426 -86.78646056 2021-10-24 04:21:22 Davidson, Tennessee, US
35215 35215 2021-10-23 US Tennessee DeKalb 47041 4180 70 0   35.97616272 -85.83689361 2021-10-24 04:21:22 DeKalb, Tennessee, US
35216 35216 2021-10-23 US Tennessee Decatur 47039 2419 44 0   35.60048904 -88.11043779 2021-10-24 04:21:22 Decatur, Tennessee, US
35217 35217 2021-10-23 US Tennessee Dickson 47043 10349 163 0   36.14669837 -87.35891709 2021-10-24 04:21:22 Dickson, Tennessee, US
35218 35218 2021-10-23 US Tennessee Dyer 47045 8062 145 0   36.05931946 -89.41542855 2021-10-24 04:21:22 Dyer, Tennessee, US
35219 35219 2021-10-23 US Tennessee Fayette 47047 7272 106 0   35.19615831 -89.41399032 2021-10-24 04:21:22 Fayette, Tennessee, US
35220 35220 2021-10-23 US Tennessee Fentress 47049 3621 66 0   36.38128818 -84.92870012 2021-10-24 04:21:22 Fentress, Tennessee, US
35221 35221 2021-10-23 US Tennessee Franklin 47051 7900 102 0   35.15634626 -86.09201039 2021-10-24 04:21:22 Franklin, Tennessee, US
35222 35222 2021-10-23 US Tennessee Gibson 47053 10617 189 0   35.99438059 -88.93358327 2021-10-24 04:21:22 Gibson, Tennessee, US
35223 35223 2021-10-23 US Tennessee Giles 47055 6027 117 0   35.20222469 -87.03992678 2021-10-24 04:21:22 Giles, Tennessee, US
35224 35224 2021-10-23 US Tennessee Grainger 47057 4327 66 0   36.27469206 -83.51254721 2021-10-24 04:21:22 Grainger, Tennessee, US
35225 35225 2021-10-23 US Tennessee Greene 47059 13554 241 0   36.17470125 -82.84691273 2021-10-24 04:21:22 Greene, Tennessee, US
35226 35226 2021-10-23 US Tennessee Grundy 47061 2819 37 0   35.38433717 -85.72142731 2021-10-24 04:21:22 Grundy, Tennessee, US
35227 35227 2021-10-23 US Tennessee Hamblen 47063 12961 197 0   36.21990035 -83.26586179 2021-10-24 04:21:22 Hamblen, Tennessee, US
35228 35228 2021-10-23 US Tennessee Hamilton 47065 63287 647 0   35.17670231 -85.16652245 2021-10-24 04:21:22 Hamilton, Tennessee, US
35229 35229 2021-10-23 US Tennessee Hancock 47067 1204 20 0   36.52692871 -83.22375847 2021-10-24 04:21:22 Hancock, Tennessee, US
35230 35230 2021-10-23 US Tennessee Hardeman 47069 5097 79 0   35.20772017 -88.99161161 2021-10-24 04:21:22 Hardeman, Tennessee, US
35231 35231 2021-10-23 US Tennessee Hardin 47071 5520 81 0   35.19732531 -88.18593755 2021-10-24 04:21:22 Hardin, Tennessee, US
35232 35232 2021-10-23 US Tennessee Hawkins 47073 10144 167 0   36.44355426 -82.94885298 2021-10-24 04:21:22 Hawkins, Tennessee, US
35233 35233 2021-10-23 US Tennessee Haywood 47075 3797 76 0   35.58332824 -89.28536625 2021-10-24 04:21:22 Haywood, Tennessee, US
35234 35234 2021-10-23 US Tennessee Henderson 47077 5719 100 0   35.65581134 -88.38600175 2021-10-24 04:21:22 Henderson, Tennessee, US
35235 35235 2021-10-23 US Tennessee Henry 47079 5449 86 0   36.33160906 -88.30121797 2021-10-24 04:21:22 Henry, Tennessee, US
35236 35236 2021-10-23 US Tennessee Hickman 47081 4574 75 0   35.80609681 -87.47643507 2021-10-24 04:21:22 Hickman, Tennessee, US
35237 35237 2021-10-23 US Tennessee Houston 47083 1834 43 0   36.28872054 -87.71878828 2021-10-24 04:21:22 Houston, Tennessee, US
35238 35238 2021-10-23 US Tennessee Humphreys 47085 3208 45 0   36.03958805 -87.77992872 2021-10-24 04:21:22 Humphreys, Tennessee, US
35239 35239 2021-10-23 US Tennessee Jackson 47087 2068 40 0   36.36380466 -85.67239905 2021-10-24 04:21:22 Jackson, Tennessee, US
35240 35240 2021-10-23 US Tennessee Jefferson 47089 9880 144 0   36.04818632 -83.45148924 2021-10-24 04:21:22 Jefferson, Tennessee, US
35241 35241 2021-10-23 US Tennessee Johnson 47091 3523 48 0   36.45523950000001 -81.84886538 2021-10-24 04:21:22 Johnson, Tennessee, US
35242 35242 2021-10-23 US Tennessee Knox 47093 78177 914 0   35.99508821 -83.94635435 2021-10-24 04:21:22 Knox, Tennessee, US
35243 35243 2021-10-23 US Tennessee Lake 47095 2015 31 0   36.34180170000001 -89.48921915 2021-10-24 04:21:22 Lake, Tennessee, US
35244 35244 2021-10-23 US Tennessee Lauderdale 47097 5196 63 0   35.75893438 -89.63015909999999 2021-10-24 04:21:22 Lauderdale, Tennessee, US
35245 35245 2021-10-23 US Tennessee Lawrence 47099 9501 121 0   35.21675201 -87.39787695 2021-10-24 04:21:22 Lawrence, Tennessee, US
35246 35246 2021-10-23 US Tennessee Lewis 47101 2515 38 0   35.52853208 -87.49022694 2021-10-24 04:21:22 Lewis, Tennessee, US
35247 35247 2021-10-23 US Tennessee Lincoln 47103 6636 82 0   35.13738622 -86.58910106 2021-10-24 04:21:22 Lincoln, Tennessee, US
35248 35248 2021-10-23 US Tennessee Loudon 47105 9083 96 0   35.73939663 -84.31145275 2021-10-24 04:21:22 Loudon, Tennessee, US
35249 35249 2021-10-23 US Tennessee Macon 47111 5445 93 0   36.53157855 -86.00778595 2021-10-24 04:21:22 Macon, Tennessee, US
35250 35250 2021-10-23 US Tennessee Madison 47113 17542 310 0   35.61181957 -88.84076036 2021-10-24 04:21:22 Madison, Tennessee, US
35251 35251 2021-10-23 US Tennessee Marion 47115 5741 53 0   35.12997174 -85.62265895 2021-10-24 04:21:22 Marion, Tennessee, US
35252 35252 2021-10-23 US Tennessee Marshall 47117 6832 85 0   35.45798777 -86.76420988 2021-10-24 04:21:22 Marshall, Tennessee, US
35253 35253 2021-10-23 US Tennessee Maury 47119 19297 226 0   35.618741299999996 -87.07462444 2021-10-24 04:21:22 Maury, Tennessee, US
35254 35254 2021-10-23 US Tennessee McMinn 47107 10469 130 0   35.42812616 -84.61520715 2021-10-24 04:21:22 McMinn, Tennessee, US
35255 35255 2021-10-23 US Tennessee McNairy 47109 4594 69 0   35.17468549 -88.5647812 2021-10-24 04:21:22 McNairy, Tennessee, US
35256 35256 2021-10-23 US Tennessee Meigs 47121 2161 28 0   35.51558739 -84.81482914 2021-10-24 04:21:22 Meigs, Tennessee, US
35257 35257 2021-10-23 US Tennessee Monroe 47123 9664 122 0   35.44550387 -84.24902965 2021-10-24 04:21:22 Monroe, Tennessee, US
35258 35258 2021-10-23 US Tennessee Montgomery 47125 32715 330 0   36.49609412 -87.38550661 2021-10-24 04:21:22 Montgomery, Tennessee, US
35259 35259 2021-10-23 US Tennessee Moore 47127 1429 22 0   35.27724699 -86.36230578 2021-10-24 04:21:22 Moore, Tennessee, US
35260 35260 2021-10-23 US Tennessee Morgan 47129 3776 47 0   36.13248031 -84.64880098 2021-10-24 04:21:22 Morgan, Tennessee, US
35261 35261 2021-10-23 US Tennessee Obion 47131 6596 110 0   36.35732446 -89.14921589 2021-10-24 04:21:22 Obion, Tennessee, US
35262 35262 2021-10-23 US Tennessee Out of TN 80047 29125 132 0   36.55606529 0.0 2021-10-24 04:21:22 Out of TN, Tennessee, US
35263 35263 2021-10-23 US Tennessee Overton 47133 4769 81 0   36.34117832 -85.28989535 2021-10-24 04:21:22 Overton, Tennessee, US
35264 35264 2021-10-23 US Tennessee Perry 47135 1602 34 0   35.63708728 -87.86139634 2021-10-24 04:21:22 Perry, Tennessee, US
35265 35265 2021-10-23 US Tennessee Pickett 47137 1080 24 0   36.55606529 -85.07763299999998 2021-10-24 04:21:22 Pickett, Tennessee, US
35266 35266 2021-10-23 US Tennessee Polk 47139 3178 29 0   35.12245443 -84.52075859 2021-10-24 04:21:22 Polk, Tennessee, US
35267 35267 2021-10-23 US Tennessee Putnam 47141 16655 218 0   36.14005459 -85.50646123 2021-10-24 04:21:22 Putnam, Tennessee, US
35268 35268 2021-10-23 US Tennessee Rhea 47143 6946 92 0   35.60536161 -84.93076643 2021-10-24 04:21:22 Rhea, Tennessee, US
35269 35269 2021-10-23 US Tennessee Roane 47145 9950 150 0   35.84923189 -84.52458689 2021-10-24 04:21:22 Roane, Tennessee, US
35270 35270 2021-10-23 US Tennessee Robertson 47147 14025 188 0   36.52454807 -86.87346725 2021-10-24 04:21:22 Robertson, Tennessee, US
35271 35271 2021-10-23 US Tennessee Rutherford 47149 61502 545 0   35.84591405 -86.4107263 2021-10-24 04:21:22 Rutherford, Tennessee, US
35272 35272 2021-10-23 US Tennessee Scott 47151 5194 59 0   36.42325673 -84.50360494 2021-10-24 04:21:22 Scott, Tennessee, US
35273 35273 2021-10-23 US Tennessee Sequatchie 47153 2973 32 0   35.36979721 -85.41022136 2021-10-24 04:21:22 Sequatchie, Tennessee, US
35274 35274 2021-10-23 US Tennessee Sevier 47155 19970 266 0   35.78077323 -83.52244332 2021-10-24 04:21:22 Sevier, Tennessee, US
35275 35275 2021-10-23 US Tennessee Shelby 47157 143725 2236 0   35.1864775 -89.89692423 2021-10-24 04:21:22 Shelby, Tennessee, US
35276 35276 2021-10-23 US Tennessee Smith 47159 4156 52 0   36.25359775 -85.95411046 2021-10-24 04:21:22 Smith, Tennessee, US
35277 35277 2021-10-23 US Tennessee Stewart 47161 2129 35 0   36.50235092 -87.83920548 2021-10-24 04:21:22 Stewart, Tennessee, US
35278 35278 2021-10-23 US Tennessee Sullivan 47163 26540 413 0   36.51240691 -82.30412917 2021-10-24 04:21:22 Sullivan, Tennessee, US
35279 35279 2021-10-23 US Tennessee Sumner 47165 34088 405 0   36.46824103 -86.45917204 2021-10-24 04:21:22 Sumner, Tennessee, US
35280 35280 2021-10-23 US Tennessee Tipton 47167 11287 128 0   35.501942 -89.73694895 2021-10-24 04:21:22 Tipton, Tennessee, US
35281 35281 2021-10-23 US Tennessee Trousdale 47169 3152 26 0   36.39026213 -86.16087954 2021-10-24 04:21:22 Trousdale, Tennessee, US
35282 35282 2021-10-23 US Tennessee Unassigned 90047 21660 121 0   36.55606529 0.0 2021-10-24 04:21:22 Unassigned, Tennessee, US
35283 35283 2021-10-23 US Tennessee Unicoi 47171 3127 65 0   36.10890856 -82.43709629 2021-10-24 04:21:22 Unicoi, Tennessee, US
35284 35284 2021-10-23 US Tennessee Union 47173 3100 46 0   36.28590426 -83.83651902 2021-10-24 04:21:22 Union, Tennessee, US
35285 35285 2021-10-23 US Tennessee Van Buren 47175 1236 27 0   35.69864497 -85.45221699 2021-10-24 04:21:22 Van Buren, Tennessee, US
35286 35286 2021-10-23 US Tennessee Warren 47177 8568 119 0   35.672829899999996 -85.77969117 2021-10-24 04:21:22 Warren, Tennessee, US
35287 35287 2021-10-23 US Tennessee Washington 47179 21511 324 0   36.29472368 -82.49454720000001 2021-10-24 04:21:22 Washington, Tennessee, US
35288 35288 2021-10-23 US Tennessee Wayne 47181 4024 39 0   35.23868267 -87.78644456 2021-10-24 04:21:22 Wayne, Tennessee, US
35289 35289 2021-10-23 US Tennessee Weakley 47183 6231 88 0   36.29896232 -88.71990865 2021-10-24 04:21:22 Weakley, Tennessee, US
35290 35290 2021-10-23 US Tennessee White 47185 5604 96 0   35.92929884 -85.45591799 2021-10-24 04:21:22 White, Tennessee, US
35291 35291 2021-10-23 US Tennessee Williamson 47187 39476 268 0   35.89099229 -86.89281867 2021-10-24 04:21:22 Williamson, Tennessee, US
35292 35292 2021-10-23 US Tennessee Wilson 47189 26970 334 0   36.15496772 -86.29775884 2021-10-24 04:21:22 Wilson, Tennessee, US
315680 315680 2021-10-22 US Tennessee Anderson 47001 12881 215 0   36.12684348 -84.19965764 2021-10-23 04:21:32 Anderson, Tennessee, US
315681 315681 2021-10-22 US Tennessee Bedford 47003 9115 154 0   35.51123746 -86.45549096 2021-10-23 04:21:32 Bedford, Tennessee, US
315682 315682 2021-10-22 US Tennessee Benton 47005 2770 52 0   36.07110411 -88.06849355 2021-10-23 04:21:32 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]);