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 confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
day (date) >30 ✖
- 2020-03-22 97
- 2020-03-23 97
- 2020-03-24 97
- 2020-03-25 97
- 2020-03-28 97
- 2020-03-29 97
- 2020-03-30 97
- 2020-04-06 97
- 2020-04-07 97
- 2020-05-10 97
- 2020-05-11 97
- 2020-05-12 97
- 2020-05-13 97
- 2020-05-14 97
- 2020-05-15 97
- 2020-05-16 97
- 2020-05-17 97
- 2020-05-18 97
- 2020-05-19 97
- 2020-05-20 97
- 2020-05-22 97
- 2020-05-23 97
- 2020-05-24 97
- 2020-05-25 97
- 2020-05-26 97
- 2020-05-27 97
- 2020-05-28 97
- 2020-05-29 97
- 2020-05-30 97
- 2020-05-31 97
- …
province_or_state 1
- Tennessee · 98,083 ✖
country_or_region 1
- US 98,083
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
918802 | 918802 | 2020-03-26 | US | Tennessee | Van Buren | 47175 | 0 | 0 | 0 | 0 | 35.69864497 | -85.45221699 | 2020-03-26 23:48:35 | Van Buren, Tennessee, US |
918860 | 918860 | 2020-03-26 | US | Tennessee | Warren | 47177 | 0 | 0 | 0 | 0 | 35.672829899999996 | -85.77969117 | 2020-03-26 23:48:35 | Warren, Tennessee, US |
918920 | 918920 | 2020-03-26 | US | Tennessee | Wayne | 47181 | 0 | 0 | 0 | 0 | 35.23868267 | -87.78644456 | 2020-03-26 23:48:35 | Wayne, Tennessee, US |
918924 | 918924 | 2020-03-26 | US | Tennessee | Weakley | 47183 | 0 | 0 | 0 | 0 | 36.29896232 | -88.71990865 | 2020-03-26 23:48:35 | Weakley, Tennessee, US |
931984 | 931984 | 2020-04-16 | US | Tennessee | Crockett | 47033 | 0 | 0 | 0 | 0 | 35.81830662 | -89.14916269 | 2020-04-16 23:30:51 | Crockett, Tennessee, US |
932414 | 932414 | 2020-04-16 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-04-16 23:30:51 | Hancock, Tennessee, US |
933899 | 933899 | 2020-04-16 | US | Tennessee | Unassigned | 90047 | 0 | 0 | 0 | 197 | 36.55606529 | 0.0 | 2020-04-16 23:30:51 | Unassigned, Tennessee, US |
1129482 | 1129482 | 2020-03-25 | US | Tennessee | Benton | 47005 | 0 | 0 | 0 | 0 | 36.07110411 | -88.06849355 | 2020-03-25 23:33:19 | Benton, Tennessee, US |
1129515 | 1129515 | 2020-03-25 | US | Tennessee | Bledsoe | 47007 | 0 | 0 | 0 | 0 | 35.59942968 | -85.20611967 | 2020-03-25 23:33:19 | Bledsoe, Tennessee, US |
1129675 | 1129675 | 2020-03-25 | US | Tennessee | Cannon | 47015 | 0 | 0 | 0 | 0 | 35.80990797 | -86.05738983 | 2020-03-25 23:33:19 | Cannon, Tennessee, US |
1129707 | 1129707 | 2020-03-25 | US | Tennessee | Carter | 47019 | 0 | 0 | 0 | 0 | 36.28969086 | -82.12588974 | 2020-03-25 23:33:19 | Carter, Tennessee, US |
1129848 | 1129848 | 2020-03-25 | US | Tennessee | Clay | 47027 | 0 | 0 | 0 | 0 | 36.55151008 | -85.53930419 | 2020-03-25 23:33:19 | Clay, Tennessee, US |
1129884 | 1129884 | 2020-03-25 | US | Tennessee | Coffee | 47031 | 0 | 0 | 0 | 0 | 35.49090731 | -86.07311784 | 2020-03-25 23:33:19 | Coffee, Tennessee, US |
1129966 | 1129966 | 2020-03-25 | US | Tennessee | Crockett | 47033 | 0 | 0 | 0 | 0 | 35.81830662 | -89.14916269 | 2020-03-25 23:33:19 | Crockett, Tennessee, US |
1130038 | 1130038 | 2020-03-25 | US | Tennessee | DeKalb | 47041 | 0 | 0 | 0 | 0 | 35.97616272 | -85.83689361 | 2020-03-25 23:33:19 | DeKalb, Tennessee, US |
1130048 | 1130048 | 2020-03-25 | US | Tennessee | Decatur | 47039 | 0 | 0 | 0 | 0 | 35.60048904 | -88.11043779 | 2020-03-25 23:33:19 | Decatur, Tennessee, US |
1130220 | 1130220 | 2020-03-25 | US | Tennessee | Fentress | 47049 | 0 | 0 | 0 | 0 | 36.38128818 | -84.92870012 | 2020-03-25 23:33:19 | Fentress, Tennessee, US |
1130335 | 1130335 | 2020-03-25 | US | Tennessee | Giles | 47055 | 0 | 0 | 0 | 0 | 35.20222469 | -87.03992678 | 2020-03-25 23:33:19 | Giles, Tennessee, US |
1130369 | 1130369 | 2020-03-25 | US | Tennessee | Grainger | 47057 | 0 | 0 | 0 | 0 | 36.27469206 | -83.51254721 | 2020-03-25 23:33:19 | Grainger, Tennessee, US |
1130479 | 1130479 | 2020-03-25 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-03-25 23:33:19 | Hancock, Tennessee, US |
1130487 | 1130487 | 2020-03-25 | US | Tennessee | Hardeman | 47069 | 0 | 0 | 0 | 0 | 35.20772017 | -88.99161161 | 2020-03-25 23:33:19 | Hardeman, Tennessee, US |
1130530 | 1130530 | 2020-03-25 | US | Tennessee | Haywood | 47075 | 0 | 0 | 0 | 0 | 35.58332824 | -89.28536625 | 2020-03-25 23:33:19 | Haywood, Tennessee, US |
1130537 | 1130537 | 2020-03-25 | US | Tennessee | Henderson | 47077 | 0 | 0 | 0 | 0 | 35.65581134 | -88.38600175 | 2020-03-25 23:33:19 | Henderson, Tennessee, US |
1130551 | 1130551 | 2020-03-25 | US | Tennessee | Henry | 47079 | 0 | 0 | 0 | 0 | 36.33160906 | -88.30121797 | 2020-03-25 23:33:19 | Henry, Tennessee, US |
1130558 | 1130558 | 2020-03-25 | US | Tennessee | Hickman | 47081 | 0 | 0 | 0 | 0 | 35.80609681 | -87.47643507 | 2020-03-25 23:33:19 | Hickman, Tennessee, US |
1130617 | 1130617 | 2020-03-25 | US | Tennessee | Humphreys | 47085 | 0 | 0 | 0 | 0 | 36.03958805 | -87.77992872 | 2020-03-25 23:33:19 | Humphreys, Tennessee, US |
1130679 | 1130679 | 2020-03-25 | US | Tennessee | Jackson | 47087 | 0 | 0 | 0 | 0 | 36.36380466 | -85.67239905 | 2020-03-25 23:33:19 | Jackson, Tennessee, US |
1130742 | 1130742 | 2020-03-25 | US | Tennessee | Johnson | 47091 | 0 | 0 | 0 | 0 | 36.45523950000001 | -81.84886538 | 2020-03-25 23:33:19 | Johnson, Tennessee, US |
1130868 | 1130868 | 2020-03-25 | US | Tennessee | Lake | 47095 | 0 | 0 | 0 | 0 | 36.34180170000001 | -89.48921915 | 2020-03-25 23:33:19 | Lake, Tennessee, US |
1130897 | 1130897 | 2020-03-25 | US | Tennessee | Lauderdale | 47097 | 0 | 0 | 0 | 0 | 35.75893438 | -89.63015909999999 | 2020-03-25 23:33:19 | Lauderdale, Tennessee, US |
1130912 | 1130912 | 2020-03-25 | US | Tennessee | Lawrence | 47099 | 0 | 0 | 0 | 0 | 35.21675201 | -87.39787695 | 2020-03-25 23:33:19 | Lawrence, Tennessee, US |
1131047 | 1131047 | 2020-03-25 | US | Tennessee | Macon | 47111 | 0 | 0 | 0 | 0 | 36.53157855 | -86.00778595 | 2020-03-25 23:33:19 | Macon, Tennessee, US |
1131118 | 1131118 | 2020-03-25 | US | Tennessee | Marshall | 47117 | 0 | 0 | 0 | 0 | 35.45798777 | -86.76420988 | 2020-03-25 23:33:19 | Marshall, Tennessee, US |
1131169 | 1131169 | 2020-03-25 | US | Tennessee | McNairy | 47109 | 0 | 0 | 0 | 0 | 35.17468549 | -88.5647812 | 2020-03-25 23:33:19 | McNairy, Tennessee, US |
1131184 | 1131184 | 2020-03-25 | US | Tennessee | Meigs | 47121 | 0 | 0 | 0 | 0 | 35.51558739 | -84.81482914 | 2020-03-25 23:33:19 | Meigs, Tennessee, US |
1131296 | 1131296 | 2020-03-25 | US | Tennessee | Moore | 47127 | 0 | 0 | 0 | 0 | 35.27724699 | -86.36230578 | 2020-03-25 23:33:19 | Moore, Tennessee, US |
1131308 | 1131308 | 2020-03-25 | US | Tennessee | Morgan | 47129 | 0 | 0 | 0 | 0 | 36.13248031 | -84.64880098 | 2020-03-25 23:33:19 | Morgan, Tennessee, US |
1131406 | 1131406 | 2020-03-25 | US | Tennessee | Obion | 47131 | 0 | 0 | 0 | 0 | 36.35732446 | -89.14921589 | 2020-03-25 23:33:19 | Obion, Tennessee, US |
1131556 | 1131556 | 2020-03-25 | US | Tennessee | Pickett | 47137 | 0 | 0 | 0 | 0 | 36.55606529 | -85.07763299999998 | 2020-03-25 23:33:19 | Pickett, Tennessee, US |
1131605 | 1131605 | 2020-03-25 | US | Tennessee | Polk | 47139 | 0 | 0 | 0 | 0 | 35.12245443 | -84.52075859 | 2020-03-25 23:33:19 | Polk, Tennessee, US |
1131710 | 1131710 | 2020-03-25 | US | Tennessee | Rhea | 47143 | 0 | 0 | 0 | 0 | 35.60536161 | -84.93076643 | 2020-03-25 23:33:19 | Rhea, Tennessee, US |
1131872 | 1131872 | 2020-03-25 | US | Tennessee | Sequatchie | 47153 | 0 | 0 | 0 | 0 | 35.36979721 | -85.41022136 | 2020-03-25 23:33:19 | Sequatchie, Tennessee, US |
1131926 | 1131926 | 2020-03-25 | US | Tennessee | Smith | 47159 | 0 | 0 | 0 | 0 | 36.25359775 | -85.95411046 | 2020-03-25 23:33:19 | Smith, Tennessee, US |
1132002 | 1132002 | 2020-03-25 | US | Tennessee | Stewart | 47161 | 0 | 0 | 0 | 0 | 36.50235092 | -87.83920548 | 2020-03-25 23:33:19 | Stewart, Tennessee, US |
1132130 | 1132130 | 2020-03-25 | US | Tennessee | Trousdale | 47169 | 0 | 0 | 0 | 0 | 36.39026213 | -86.16087954 | 2020-03-25 23:33:19 | Trousdale, Tennessee, US |
1132171 | 1132171 | 2020-03-25 | US | Tennessee | Unicoi | 47171 | 0 | 0 | 0 | 0 | 36.10890856 | -82.43709629 | 2020-03-25 23:33:19 | Unicoi, Tennessee, US |
1132189 | 1132189 | 2020-03-25 | US | Tennessee | Union | 47173 | 0 | 0 | 0 | 0 | 36.28590426 | -83.83651902 | 2020-03-25 23:33:19 | Union, Tennessee, US |
1132205 | 1132205 | 2020-03-25 | US | Tennessee | Van Buren | 47175 | 0 | 0 | 0 | 0 | 35.69864497 | -85.45221699 | 2020-03-25 23:33:19 | Van Buren, Tennessee, US |
1132263 | 1132263 | 2020-03-25 | US | Tennessee | Warren | 47177 | 0 | 0 | 0 | 0 | 35.672829899999996 | -85.77969117 | 2020-03-25 23:33:19 | Warren, Tennessee, US |
1132323 | 1132323 | 2020-03-25 | US | Tennessee | Wayne | 47181 | 0 | 0 | 0 | 0 | 35.23868267 | -87.78644456 | 2020-03-25 23:33:19 | Wayne, Tennessee, US |
1132327 | 1132327 | 2020-03-25 | US | Tennessee | Weakley | 47183 | 0 | 0 | 0 | 0 | 36.29896232 | -88.71990865 | 2020-03-25 23:33:19 | Weakley, Tennessee, US |
1182262 | 1182262 | 2020-05-01 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-05-02 02:32:27 | Hancock, Tennessee, US |
1183823 | 1183823 | 2020-05-01 | US | Tennessee | Unassigned | 90047 | 0 | 0 | 0 | 33 | 36.55606529 | 0.0 | 2020-05-02 02:32:27 | Unassigned, Tennessee, US |
1197382 | 1197382 | 2020-04-22 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-04-22 23:30:53 | Hancock, Tennessee, US |
1198899 | 1198899 | 2020-04-22 | US | Tennessee | Unassigned | 90047 | 0 | 0 | 0 | 36 | 36.55606529 | 0.0 | 2020-04-22 23:30:53 | Unassigned, Tennessee, US |
1248022 | 1248022 | 2020-04-10 | US | Tennessee | Crockett | 47033 | 0 | 0 | 0 | 0 | 35.81830662 | -89.14916269 | 2020-04-10 22:54:07 | Crockett, Tennessee, US |
1248435 | 1248435 | 2020-04-10 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-04-10 22:54:07 | Hancock, Tennessee, US |
1248740 | 1248740 | 2020-04-10 | US | Tennessee | Lake | 47095 | 0 | 0 | 0 | 0 | 36.34180170000001 | -89.48921915 | 2020-04-10 22:54:07 | Lake, Tennessee, US |
1249111 | 1249111 | 2020-04-10 | US | Tennessee | Moore | 47127 | 0 | 0 | 0 | 0 | 35.27724699 | -86.36230578 | 2020-04-10 22:54:07 | Moore, Tennessee, US |
1249458 | 1249458 | 2020-04-10 | US | Tennessee | Rhea | 47143 | 0 | 0 | 0 | 0 | 35.60536161 | -84.93076643 | 2020-04-10 22:54:07 | Rhea, Tennessee, US |
1249859 | 1249859 | 2020-04-10 | US | Tennessee | Unassigned | 90047 | 0 | 0 | 0 | 22 | 36.55606529 | 0.0 | 2020-04-10 22:54:07 | Unassigned, Tennessee, US |
1249895 | 1249895 | 2020-04-10 | US | Tennessee | Van Buren | 47175 | 0 | 0 | 0 | 0 | 35.69864497 | -85.45221699 | 2020-04-10 22:54:07 | Van Buren, Tennessee, US |
1383239 | 1383239 | 2020-04-19 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-04-19 23:41:01 | Hancock, Tennessee, US |
1384741 | 1384741 | 2020-04-19 | US | Tennessee | Unassigned | 90047 | 0 | 0 | 0 | 88 | 36.55606529 | 0.0 | 2020-04-19 23:41:01 | Unassigned, Tennessee, US |
1402474 | 1402474 | 2020-05-14 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-05-15 02:33:02 | Hancock, Tennessee, US |
1404063 | 1404063 | 2020-05-14 | US | Tennessee | Unassigned | 90047 | 0 | 0 | 0 | 0 | 36.55606529 | 0.0 | 2020-05-15 02:33:02 | Unassigned, Tennessee, US |
1431511 | 1431511 | 2020-05-20 | US | Tennessee | Unassigned | 90047 | 0 | 0 | 0 | 83 | 36.55606529 | 0.0 | 2020-05-21 02:32:48 | Unassigned, Tennessee, US |
1457333 | 1457333 | 2020-04-24 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-04-25 06:30:53 | Hancock, Tennessee, US |
1458866 | 1458866 | 2020-04-24 | US | Tennessee | Unassigned | 90047 | 0 | 0 | 0 | 19 | 36.55606529 | 0.0 | 2020-04-25 06:30:53 | Unassigned, Tennessee, US |
1475969 | 1475969 | 2020-03-24 | US | Tennessee | Bedford | 47003 | 0 | 0 | 0 | 0 | 35.51123746 | -86.45549096 | 2020-03-24 23:37:31 | Bedford, Tennessee, US |
1475990 | 1475990 | 2020-03-24 | US | Tennessee | Benton | 47005 | 0 | 0 | 0 | 0 | 36.07110411 | -88.06849355 | 2020-03-24 23:37:31 | Benton, Tennessee, US |
1476023 | 1476023 | 2020-03-24 | US | Tennessee | Bledsoe | 47007 | 0 | 0 | 0 | 0 | 35.59942968 | -85.20611967 | 2020-03-24 23:37:31 | Bledsoe, Tennessee, US |
1476183 | 1476183 | 2020-03-24 | US | Tennessee | Cannon | 47015 | 0 | 0 | 0 | 0 | 35.80990797 | -86.05738983 | 2020-03-24 23:37:31 | Cannon, Tennessee, US |
1476215 | 1476215 | 2020-03-24 | US | Tennessee | Carter | 47019 | 0 | 0 | 0 | 0 | 36.28969086 | -82.12588974 | 2020-03-24 23:37:31 | Carter, Tennessee, US |
1476356 | 1476356 | 2020-03-24 | US | Tennessee | Clay | 47027 | 0 | 0 | 0 | 0 | 36.55151008 | -85.53930419 | 2020-03-24 23:37:31 | Clay, Tennessee, US |
1476392 | 1476392 | 2020-03-24 | US | Tennessee | Coffee | 47031 | 0 | 0 | 0 | 0 | 35.49090731 | -86.07311784 | 2020-03-24 23:37:31 | Coffee, Tennessee, US |
1476474 | 1476474 | 2020-03-24 | US | Tennessee | Crockett | 47033 | 0 | 0 | 0 | 0 | 35.81830662 | -89.14916269 | 2020-03-24 23:37:31 | Crockett, Tennessee, US |
1476546 | 1476546 | 2020-03-24 | US | Tennessee | DeKalb | 47041 | 0 | 0 | 0 | 0 | 35.97616272 | -85.83689361 | 2020-03-24 23:37:31 | DeKalb, Tennessee, US |
1476556 | 1476556 | 2020-03-24 | US | Tennessee | Decatur | 47039 | 0 | 0 | 0 | 0 | 35.60048904 | -88.11043779 | 2020-03-24 23:37:31 | Decatur, Tennessee, US |
1476728 | 1476728 | 2020-03-24 | US | Tennessee | Fentress | 47049 | 0 | 0 | 0 | 0 | 36.38128818 | -84.92870012 | 2020-03-24 23:37:31 | Fentress, Tennessee, US |
1476843 | 1476843 | 2020-03-24 | US | Tennessee | Giles | 47055 | 0 | 0 | 0 | 0 | 35.20222469 | -87.03992678 | 2020-03-24 23:37:31 | Giles, Tennessee, US |
1476877 | 1476877 | 2020-03-24 | US | Tennessee | Grainger | 47057 | 0 | 0 | 0 | 0 | 36.27469206 | -83.51254721 | 2020-03-24 23:37:31 | Grainger, Tennessee, US |
1476987 | 1476987 | 2020-03-24 | US | Tennessee | Hancock | 47067 | 0 | 0 | 0 | 0 | 36.52692871 | -83.22375847 | 2020-03-24 23:37:31 | Hancock, Tennessee, US |
1476995 | 1476995 | 2020-03-24 | US | Tennessee | Hardeman | 47069 | 0 | 0 | 0 | 0 | 35.20772017 | -88.99161161 | 2020-03-24 23:37:31 | Hardeman, Tennessee, US |
1477034 | 1477034 | 2020-03-24 | US | Tennessee | Hawkins | 47073 | 0 | 0 | 0 | 0 | 36.44355426 | -82.94885298 | 2020-03-24 23:37:31 | Hawkins, Tennessee, US |
1477038 | 1477038 | 2020-03-24 | US | Tennessee | Haywood | 47075 | 0 | 0 | 0 | 0 | 35.58332824 | -89.28536625 | 2020-03-24 23:37:31 | Haywood, Tennessee, US |
1477045 | 1477045 | 2020-03-24 | US | Tennessee | Henderson | 47077 | 0 | 0 | 0 | 0 | 35.65581134 | -88.38600175 | 2020-03-24 23:37:31 | Henderson, Tennessee, US |
1477059 | 1477059 | 2020-03-24 | US | Tennessee | Henry | 47079 | 0 | 0 | 0 | 0 | 36.33160906 | -88.30121797 | 2020-03-24 23:37:31 | Henry, Tennessee, US |
1477066 | 1477066 | 2020-03-24 | US | Tennessee | Hickman | 47081 | 0 | 0 | 0 | 0 | 35.80609681 | -87.47643507 | 2020-03-24 23:37:31 | Hickman, Tennessee, US |
1477125 | 1477125 | 2020-03-24 | US | Tennessee | Humphreys | 47085 | 0 | 0 | 0 | 0 | 36.03958805 | -87.77992872 | 2020-03-24 23:37:31 | Humphreys, Tennessee, US |
1477187 | 1477187 | 2020-03-24 | US | Tennessee | Jackson | 47087 | 0 | 0 | 0 | 0 | 36.36380466 | -85.67239905 | 2020-03-24 23:37:31 | Jackson, Tennessee, US |
1477250 | 1477250 | 2020-03-24 | US | Tennessee | Johnson | 47091 | 0 | 0 | 0 | 0 | 36.45523950000001 | -81.84886538 | 2020-03-24 23:37:31 | Johnson, Tennessee, US |
1477376 | 1477376 | 2020-03-24 | US | Tennessee | Lake | 47095 | 0 | 0 | 0 | 0 | 36.34180170000001 | -89.48921915 | 2020-03-24 23:37:31 | Lake, Tennessee, US |
1477405 | 1477405 | 2020-03-24 | US | Tennessee | Lauderdale | 47097 | 0 | 0 | 0 | 0 | 35.75893438 | -89.63015909999999 | 2020-03-24 23:37:31 | Lauderdale, Tennessee, US |
1477420 | 1477420 | 2020-03-24 | US | Tennessee | Lawrence | 47099 | 0 | 0 | 0 | 0 | 35.21675201 | -87.39787695 | 2020-03-24 23:37:31 | Lawrence, Tennessee, US |
1477454 | 1477454 | 2020-03-24 | US | Tennessee | Lewis | 47101 | 0 | 0 | 0 | 0 | 35.52853208 | -87.49022694 | 2020-03-24 23:37:31 | Lewis, Tennessee, US |
1477555 | 1477555 | 2020-03-24 | US | Tennessee | Macon | 47111 | 0 | 0 | 0 | 0 | 36.53157855 | -86.00778595 | 2020-03-24 23:37:31 | Macon, Tennessee, US |
1477626 | 1477626 | 2020-03-24 | US | Tennessee | Marshall | 47117 | 0 | 0 | 0 | 0 | 35.45798777 | -86.76420988 | 2020-03-24 23:37:31 | Marshall, Tennessee, US |
1477677 | 1477677 | 2020-03-24 | US | Tennessee | McNairy | 47109 | 0 | 0 | 0 | 0 | 35.17468549 | -88.5647812 | 2020-03-24 23:37:31 | McNairy, Tennessee, US |
1477692 | 1477692 | 2020-03-24 | US | Tennessee | Meigs | 47121 | 0 | 0 | 0 | 0 | 35.51558739 | -84.81482914 | 2020-03-24 23:37:31 | Meigs, 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]);