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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2022-04-13 194
- 2022-05-26 194
- 2020-07-05 99
- 2020-03-23 97
- 2020-03-24 97
- 2020-03-25 97
- 2020-03-26 97
- 2020-03-27 97
- 2020-04-07 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-21 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
- …
day (date) >30 ✖
- 2020-03-22 97
- 2020-03-23 97
- 2020-03-24 97
- 2020-03-25 97
- 2020-03-26 97
- 2020-03-27 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-21 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
- …
province_or_state 1
- Tennessee · 98,183 ✖
country_or_region 1
- US 98,183
Link | rowid | day | country_or_region | province_or_state | admin2 | fips ▼ | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40984 | 40984 | 2020-04-13 | US | Tennessee | DeKalb | 10 | 0 | 0 | 10 | 35.97616272 | -85.83689361 | 2020-04-13 23:07:54 | DeKalb, Tennessee, US | |
42206 | 42206 | 2020-04-13 | US | Tennessee | Out of TN | 112 | 1 | 0 | 259 | 36.55606529 | 0.0 | 2020-04-13 23:07:54 | Out of TN, Tennessee, US | |
339689 | 339689 | 2020-03-21 | US | Tennessee | 371 | 1 | 0 | 35.7478 | -86.6923 | 2020-03-21T23:13:18 | ||||
587111 | 587111 | 2020-04-05 | US | Tennessee | DeKalb | 7 | 0 | 0 | 7 | 35.97616272 | -85.83689361 | 2020-04-05 23:06:45 | DeKalb,Tennessee,US | |
588222 | 588222 | 2020-04-05 | US | Tennessee | Out of TN | 89 | 0 | 0 | 264 | 36.55606529 | 0.0 | 2020-04-05 23:06:45 | Out of TN,Tennessee,US | |
807973 | 807973 | 2020-03-27 | US | Tennessee | Out of TN | 141 | 0 | 0 | 141 | 0.0 | 0.0 | 2020-03-27 22:14:55 | Out of TN,Tennessee,US | |
808671 | 808671 | 2020-03-27 | US | Tennessee | Unassigned | 172 | 3 | 0 | 169 | 0.0 | 0.0 | 2020-03-27 22:14:55 | Unassigned, Tennessee, US | |
857951 | 857951 | 2020-04-15 | US | Tennessee | DeKalb | 10 | 0 | 0 | 10 | 35.97616272 | -85.83689361 | 2020-04-15 22:56:51 | DeKalb, Tennessee, US | |
859185 | 859185 | 2020-04-15 | US | Tennessee | Out of TN | 115 | 1 | 0 | 259 | 36.55606529 | 0.0 | 2020-04-15 22:56:51 | Out of TN, Tennessee, US | |
918073 | 918073 | 2020-03-26 | US | Tennessee | Out of TN | 117 | 0 | 0 | 117 | 0.0 | 0.0 | 2020-03-26 23:48:35 | Out of TN,Tennessee,US | |
918765 | 918765 | 2020-03-26 | US | Tennessee | Unassigned | 112 | 0 | 0 | 112 | 0.0 | 0.0 | 2020-03-26 23:48:35 | Unassigned, Tennessee, US | |
1131474 | 1131474 | 2020-03-25 | US | Tennessee | Out of TN | 100 | 0 | 0 | 100 | 0.0 | 0.0 | 2020-03-25 23:33:19 | Out of TN,Tennessee,US | |
1132168 | 1132168 | 2020-03-25 | US | Tennessee | Unassigned | 81 | 0 | 0 | 81 | 0.0 | 0.0 | 2020-03-25 23:33:19 | Unassigned, Tennessee, US | |
1176985 | 1176985 | 2020-03-18 | US | Tennessee | 79 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-18T19:14:34 | ||||
1248080 | 1248080 | 2020-04-10 | US | Tennessee | DeKalb | 9 | 0 | 0 | 8 | 35.97616272 | -85.83689361 | 2020-04-10 22:54:07 | DeKalb,Tennessee,US | |
1249271 | 1249271 | 2020-04-10 | US | Tennessee | Out of TN | 106 | 1 | 0 | 274 | 36.55606529 | 0.0 | 2020-04-10 22:54:07 | Out of TN,Tennessee,US | |
1463577 | 1463577 | 2020-03-15 | US | Tennessee | 39 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-14T22:33:04 | ||||
1477982 | 1477982 | 2020-03-24 | US | Tennessee | Out of TN | 95 | 0 | 0 | 95 | 0.0 | 0.0 | 2020-03-24 23:37:31 | Out of TN,Tennessee,US | |
1478676 | 1478676 | 2020-03-24 | US | Tennessee | Unassigned | 38 | 0 | 0 | 38 | 0.0 | 0.0 | 2020-03-24 23:37:31 | Unassigned, Tennessee, US | |
1526956 | 1526956 | 2020-03-19 | US | Tennessee | 154 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-19T21:13:40 | ||||
1748820 | 1748820 | 2020-04-04 | US | Tennessee | DeKalb | 5 | 0 | 0 | 5 | 35.97616272 | -85.83689361 | 4/4/20 23:34 | DeKalb,Tennessee,US | |
1749894 | 1749894 | 2020-04-04 | US | Tennessee | Out of TN | 82 | 1 | 0 | 217 | 36.55606529 | 0.0 | 4/4/20 23:34 | Out of TN,Tennessee,US | |
1871343 | 1871343 | 2020-03-30 | US | Tennessee | Out of TN | 150 | 0 | 0 | 150 | 0.0 | 0.0 | 3/30/20 22:52 | Out of TN,Tennessee,US | |
1872046 | 1872046 | 2020-03-30 | US | Tennessee | Unassigned | 197 | 4 | 0 | 193 | 0.0 | 0.0 | 3/30/20 22:52 | Unassigned, Tennessee, US | |
2111194 | 2111194 | 2020-03-14 | US | Tennessee | 32 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-14T22:33:04 | ||||
2127555 | 2127555 | 2020-03-11 | US | Tennessee | 9 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-11T22:53:03 | ||||
2146039 | 2146039 | 2020-03-23 | US | Tennessee | Out of TN | 89 | 0 | 0 | 89 | 0.0 | 0.0 | 2020-03-23 23:19:34 | Out of TN,Tennessee,US | |
2146734 | 2146734 | 2020-03-23 | US | Tennessee | Unassigned | 54 | 0 | 0 | 54 | 0.0 | 0.0 | 2020-03-23 23:19:34 | Unassigned, Tennessee, US | |
2255223 | 2255223 | 2020-03-16 | US | Tennessee | 52 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-16T22:13:21 | ||||
2282967 | 2282967 | 2020-03-12 | US | Tennessee | 18 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-12T21:39:10 | ||||
2564876 | 2564876 | 2020-04-11 | US | Tennessee | DeKalb | 9 | 0 | 0 | 9 | 35.97616272 | -85.83689361 | 2020-04-11 22:45:33 | DeKalb,Tennessee,US | |
2566080 | 2566080 | 2020-04-11 | US | Tennessee | Out of TN | 109 | 1 | 0 | 275 | 36.55606529 | 0.0 | 2020-04-11 22:45:33 | Out of TN,Tennessee,US | |
2576020 | 2576020 | 2020-04-12 | US | Tennessee | DeKalb | 9 | 0 | 0 | 9 | 35.97616272 | -85.83689361 | 2020-04-12 23:18:00 | DeKalb, Tennessee, US | |
2577232 | 2577232 | 2020-04-12 | US | Tennessee | Out of TN | 109 | 1 | 0 | 275 | 36.55606529 | 0.0 | 2020-04-12 23:18:00 | Out of TN, Tennessee, US | |
2874584 | 2874584 | 2020-03-29 | US | Tennessee | Out of TN | 150 | 0 | 0 | 150 | 0.0 | 0.0 | 3/29/20 23:08 | Out of TN,Tennessee,US | |
2875282 | 2875282 | 2020-03-29 | US | Tennessee | Unassigned | 190 | 4 | 0 | 186 | 0.0 | 0.0 | 3/29/20 23:08 | Unassigned, Tennessee, US | |
2907886 | 2907886 | 2020-03-22 | US | Tennessee | Out-of-state | 82 | 0 | 0 | 82 | 36.55606529 | 0.0 | 3/22/20 23:45 | Out-of-state, Tennessee, US | |
2907889 | 2907889 | 2020-03-22 | US | Tennessee | Unknown | 30 | 0 | 0 | 30 | 36.55606529 | 0.0 | 3/22/20 23:45 | Unknown, Tennessee, US | |
3019669 | 3019669 | 2020-04-07 | US | Tennessee | DeKalb | 7 | 0 | 0 | 7 | 35.97616272 | -85.83689361 | 2020-04-07 23:04:49 | DeKalb,Tennessee,US | |
3020823 | 3020823 | 2020-04-07 | US | Tennessee | Out of TN | 101 | 2 | 0 | 289 | 36.55606529 | 0.0 | 2020-04-07 23:04:49 | Out of TN,Tennessee,US | |
3335877 | 3335877 | 2020-04-14 | US | Tennessee | DeKalb | 10 | 0 | 0 | 10 | 35.97616272 | -85.83689361 | 2020-04-14 23:33:31 | DeKalb, Tennessee, US | |
3337104 | 3337104 | 2020-04-14 | US | Tennessee | Out of TN | 114 | 1 | 0 | 259 | 36.55606529 | 0.0 | 2020-04-14 23:33:31 | Out of TN, Tennessee, US | |
3363015 | 3363015 | 2020-04-01 | US | Tennessee | DeKalb | 5 | 0 | 0 | 5 | 35.97616272 | -85.83689361 | 2020-04-01 21:58:49 | DeKalb,Tennessee,US | |
3363998 | 3363998 | 2020-04-01 | US | Tennessee | Out of TN | 69 | 0 | 0 | 243 | 0.0 | 0.0 | 2020-04-01 21:58:49 | Out of TN,Tennessee,US | |
3364477 | 3364477 | 2020-04-01 | US | Tennessee | Unassigned | 0 | 0 | 0 | 431 | 0.0 | 0.0 | 2020-04-01 21:58:49 | Unassigned, Tennessee, US | |
3559973 | 3559973 | 2020-04-08 | US | Tennessee | DeKalb | 7 | 0 | 0 | 7 | 35.97616272 | -85.83689361 | 2020-04-08 22:51:58 | DeKalb,Tennessee,US | |
3561138 | 3561138 | 2020-04-08 | US | Tennessee | Out of TN | 103 | 0 | 0 | 282 | 36.55606529 | 0.0 | 2020-04-08 22:51:58 | Out of TN,Tennessee,US | |
3625389 | 3625389 | 2020-04-06 | US | Tennessee | DeKalb | 7 | 0 | 0 | 7 | 35.97616272 | -85.83689361 | 4/6/20 23:22 | DeKalb,Tennessee,US | |
3626516 | 3626516 | 2020-04-06 | US | Tennessee | Out of TN | 98 | 0 | 0 | 289 | 36.55606529 | 0.0 | 4/6/20 23:22 | Out of TN,Tennessee,US | |
3699747 | 3699747 | 2020-04-02 | US | Tennessee | DeKalb | 5 | 0 | 0 | 5 | 35.97616272 | -85.83689361 | 4/2/20 23:25 | DeKalb,Tennessee,US | |
3700770 | 3700770 | 2020-04-02 | US | Tennessee | Out of TN | 75 | 1 | 0 | 242 | 36.55606529 | 0.0 | 4/2/20 23:25 | Out of TN,Tennessee,US | |
3733998 | 3733998 | 2020-03-20 | US | Tennessee | 233 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-20T23:43:03 | ||||
3738671 | 3738671 | 2020-04-03 | US | Tennessee | DeKalb | 5 | 0 | 0 | 5 | 35.97616272 | -85.83689361 | 2020-04-03 22:46:37 | DeKalb,Tennessee,US | |
3739719 | 3739719 | 2020-04-03 | US | Tennessee | Out of TN | 78 | 1 | 0 | 186 | 36.55606529 | 0.0 | 2020-04-03 22:46:37 | Out of TN,Tennessee,US | |
3752936 | 3752936 | 2020-03-10 | US | Tennessee | 7 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-10T19:53:13 | ||||
3765496 | 3765496 | 2020-03-13 | US | Tennessee | 26 | 0 | 0 | 35.747845 | -86.692345 | 2020-03-11T20:00:00 | ||||
3814140 | 3814140 | 2020-03-31 | US | Tennessee | DeKalb | 4 | 0 | 0 | 4 | 35.97616272 | -85.83689361 | 2020-03-31 23:43:56 | DeKalb,Tennessee,US | |
3815101 | 3815101 | 2020-03-31 | US | Tennessee | Out of TN | 190 | 0 | 0 | 190 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Out of TN,Tennessee,US | |
3815572 | 3815572 | 2020-03-31 | US | Tennessee | Unassigned | 307 | 11 | 0 | 296 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Tennessee, US | |
3891405 | 3891405 | 2020-03-17 | US | Tennessee | 74 | 0 | 0 | 35.7478 | -86.6923 | 2020-03-17T23:13:10 | ||||
3945924 | 3945924 | 2020-03-28 | US | Tennessee | Out of TN | 148 | 0 | 0 | 148 | 0.0 | 0.0 | 3/28/20 23:05 | Out of TN,Tennessee,US | |
3946619 | 3946619 | 2020-03-28 | US | Tennessee | Unassigned | 161 | 4 | 0 | 157 | 0.0 | 0.0 | 3/28/20 23:05 | Unassigned, Tennessee, US | |
3947842 | 3947842 | 2020-04-09 | US | Tennessee | DeKalb | 7 | 0 | 0 | 7 | 35.97616272 | -85.83689361 | 2020-04-09 23:02:37 | DeKalb,Tennessee,US | |
3949023 | 3949023 | 2020-04-09 | US | Tennessee | Out of TN | 105 | 1 | 0 | 274 | 36.55606529 | 0.0 | 2020-04-09 23:02:37 | Out of TN,Tennessee,US | |
3244 | 3244 | 2021-12-02 | US | Tennessee | Anderson | 47001 | 13677 | 234 | 0 | 36.12684348 | -84.19965764 | 2021-12-03 04:23:05 | Anderson, Tennessee, US | |
7259 | 7259 | 2021-10-28 | US | Tennessee | Anderson | 47001 | 13051 | 217 | 0 | 36.12684348 | -84.19965764 | 2021-10-29 04:22:03 | Anderson, Tennessee, US | |
11231 | 11231 | 2020-10-25 | US | Tennessee | Anderson | 47001 | 1683 | 14 | 0 | 1674 | 36.12684348 | -84.19965764 | 2020-10-26 04:25:02 | Anderson, Tennessee, US |
15244 | 15244 | 2021-01-26 | US | Tennessee | Anderson | 47001 | 7166 | 116 | 0 | 6938 | 36.12684348 | -84.19965764 | 2021-01-27 05:23:41 | Anderson, Tennessee, US |
19266 | 19266 | 2021-09-18 | US | Tennessee | Anderson | 47001 | 11841 | 190 | 0 | 36.12684348 | -84.19965764 | 2021-09-19 04:21:34 | Anderson, Tennessee, US | |
23277 | 23277 | 2021-05-28 | US | Tennessee | Anderson | 47001 | 8773 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-05-29 04:20:41 | Anderson, Tennessee, US | |
27315 | 27315 | 2022-03-20 | US | Tennessee | Anderson | 47001 | 22158 | 320 | 0 | 36.12684348 | -84.19965764 | 2022-03-21 04:20:50 | Anderson, Tennessee, US | |
31330 | 31330 | 2021-11-11 | US | Tennessee | Anderson | 47001 | 13300 | 223 | 0 | 36.12684348 | -84.19965764 | 2021-11-12 04:22:01 | Anderson, Tennessee, US | |
35326 | 35326 | 2021-08-25 | US | Tennessee | Anderson | 47001 | 10054 | 182 | 0 | 36.12684348 | -84.19965764 | 2021-08-26 04:21:28 | Anderson, Tennessee, US | |
39336 | 39336 | 2021-04-12 | US | Tennessee | Anderson | 47001 | 8457 | 165 | 0 | 36.12684348 | -84.19965764 | 2021-04-13 04:20:37 | Anderson, Tennessee, US | |
40393 | 40393 | 2020-04-13 | US | Tennessee | Anderson | 47001 | 13 | 1 | 0 | 14 | 36.12684348 | -84.19965764 | 2020-04-13 23:07:54 | Anderson, Tennessee, US |
46622 | 46622 | 2021-11-02 | US | Tennessee | Anderson | 47001 | 13134 | 220 | 0 | 36.12684348 | -84.19965764 | 2021-11-03 06:22:09 | Anderson, Tennessee, US | |
47451 | 47451 | 2020-04-17 | US | Tennessee | Anderson | 47001 | 13 | 1 | 0 | 15 | 36.12684348 | -84.19965764 | 2020-04-17 23:30:52 | Anderson, Tennessee, US |
53698 | 53698 | 2021-05-29 | US | Tennessee | Anderson | 47001 | 8774 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-05-30 04:20:55 | Anderson, Tennessee, US | |
57709 | 57709 | 2021-03-07 | US | Tennessee | Anderson | 47001 | 8016 | 158 | 0 | 36.12684348 | -84.19965764 | 2021-03-08 05:24:48 | Anderson, Tennessee, US | |
58574 | 58574 | 2020-07-23 | US | Tennessee | Anderson | 47001 | 388 | 3 | 0 | 371 | 36.12684348 | -84.19965764 | 2020-07-24 05:30:40 | Anderson, Tennessee, US |
65980 | 65980 | 2022-11-12 | US | Tennessee | Anderson | 47001 | 26434 | 375 | 0 | 36.12684348 | -84.19965764 | 2022-11-13 04:21:14 | Anderson, Tennessee, US | |
69971 | 69971 | 2021-09-01 | US | Tennessee | Anderson | 47001 | 10559 | 183 | 0 | 36.12684348 | -84.19965764 | 2021-09-02 04:21:15 | Anderson, Tennessee, US | |
74005 | 74005 | 2022-02-07 | US | Tennessee | Anderson | 47001 | 21153 | 298 | 0 | 36.12684348 | -84.19965764 | 2022-02-08 04:21:15 | Anderson, Tennessee, US | |
77991 | 77991 | 2020-12-03 | US | Tennessee | Anderson | 47001 | 3219 | 31 | 0 | 3208 | 36.12684348 | -84.19965764 | 2020-12-04 05:27:27 | Anderson, Tennessee, US |
81985 | 81985 | 2020-10-14 | US | Tennessee | Anderson | 47001 | 1475 | 13 | 0 | 1450 | 36.12684348 | -84.19965764 | 2020-10-15 04:24:28 | Anderson, Tennessee, US |
86001 | 86001 | 2021-05-25 | US | Tennessee | Anderson | 47001 | 8759 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-05-26 04:20:35 | Anderson, Tennessee, US | |
90039 | 90039 | 2021-11-09 | US | Tennessee | Anderson | 47001 | 13259 | 223 | 0 | 36.12684348 | -84.19965764 | 2021-11-10 04:21:38 | Anderson, Tennessee, US | |
94057 | 94057 | 2022-07-23 | US | Tennessee | Anderson | 47001 | 23842 | 352 | 0 | 36.12684348 | -84.19965764 | 2022-07-24 04:20:47 | Anderson, Tennessee, US | |
94896 | 94896 | 2020-08-04 | US | Tennessee | Anderson | 47001 | 638 | 7 | 0 | 623 | 36.12684348 | -84.19965764 | 2020-08-05 04:34:43 | Anderson, Tennessee, US |
102240 | 102240 | 2022-01-14 | US | Tennessee | Anderson | 47001 | 16625 | 276 | 0 | 36.12684348 | -84.19965764 | 2022-01-15 04:21:07 | Anderson, Tennessee, US | |
106236 | 106236 | 2021-08-15 | US | Tennessee | Anderson | 47001 | 9515 | 180 | 0 | 36.12684348 | -84.19965764 | 2021-08-16 04:21:31 | Anderson, Tennessee, US | |
110360 | 110360 | 2021-06-19 | US | Tennessee | Anderson | 47001 | 8805 | 175 | 0 | 36.12684348 | -84.19965764 | 2021-06-20 04:21:48 | Anderson, Tennessee, US | |
111208 | 111208 | 2020-05-08 | US | Tennessee | Anderson | 47001 | 30 | 1 | 0 | 30 | 36.12684348 | -84.19965764 | 2020-05-09 02:32:35 | Anderson, Tennessee, US |
117667 | 117667 | 2022-09-06 | US | Tennessee | Anderson | 47001 | 25658 | 365 | 0 | 36.12684348 | -84.19965764 | 2022-09-07 04:20:59 | Anderson, Tennessee, US | |
118504 | 118504 | 2020-07-19 | US | Tennessee | Anderson | 47001 | 285 | 2 | 0 | 287 | 36.12684348 | -84.19965764 | 2020-07-20 05:34:40 | Anderson, Tennessee, US |
125606 | 125606 | 2020-11-18 | US | Tennessee | Anderson | 47001 | 2502 | 25 | 0 | 2485 | 36.12684348 | -84.19965764 | 2020-11-19 05:25:23 | Anderson, Tennessee, US |
129647 | 129647 | 2022-01-09 | US | Tennessee | Anderson | 47001 | 15546 | 269 | 0 | 36.12684348 | -84.19965764 | 2022-01-10 04:22:07 | Anderson, Tennessee, US | |
133668 | 133668 | 2022-10-04 | US | Tennessee | Anderson | 47001 | 26063 | 370 | 0 | 36.12684348 | -84.19965764 | 2022-10-05 04:23:06 | Anderson, Tennessee, US | |
134492 | 134492 | 2020-04-29 | US | Tennessee | Anderson | 47001 | 26 | 1 | 0 | 26 | 36.12684348 | -84.19965764 | 2020-04-30 02:32:27 | Anderson, Tennessee, US |
140885 | 140885 | 2021-12-04 | US | Tennessee | Anderson | 47001 | 13728 | 235 | 0 | 36.12684348 | -84.19965764 | 2021-12-05 04:22:25 | Anderson, 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]);