johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
938 rows where country_or_region = "Sweden" and province_or_state = "Vasterbotten" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- 2020-06-26 1
- 2020-06-27 1
- 2020-06-28 1
- 2020-06-29 1
- 2020-06-30 1
- 2020-07-01 1
- 2020-07-02 1
- 2020-07-03 1
- 2020-07-04 1
- 2020-07-05 1
- …
province_or_state 1
- Vasterbotten · 381 ✖
country_or_region 1
- Sweden · 381 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884694 | 2884694 | 2021-06-20 | Sweden | Vasterbotten | 23298 | 181 | 0 | 23117 | 65.3337 | 16.5162 | 2021-06-21 04:21:41 | Vasterbotten, Sweden | ||
107777 | 107777 | 2021-06-19 | Sweden | Vasterbotten | 23298 | 181 | 0 | 23117 | 65.3337 | 16.5162 | 2021-06-20 04:21:48 | Vasterbotten, Sweden | ||
1125920 | 1125920 | 2021-06-18 | Sweden | Vasterbotten | 23298 | 181 | 0 | 23117 | 65.3337 | 16.5162 | 2021-06-19 04:22:33 | Vasterbotten, Sweden | ||
2911498 | 2911498 | 2021-06-17 | Sweden | Vasterbotten | 23298 | 181 | 0 | 23117 | 65.3337 | 16.5162 | 2021-06-18 04:22:16 | Vasterbotten, Sweden | ||
3030614 | 3030614 | 2021-06-16 | Sweden | Vasterbotten | 23298 | 181 | 0 | 23117 | 65.3337 | 16.5162 | 2021-06-17 04:22:36 | Vasterbotten, Sweden | ||
2339720 | 2339720 | 2021-06-15 | Sweden | Vasterbotten | 23298 | 181 | 0 | 23117 | 65.3337 | 16.5162 | 2021-06-16 04:22:32 | Vasterbotten, Sweden | ||
1564416 | 1564416 | 2021-06-14 | Sweden | Vasterbotten | 23270 | 181 | 0 | 23089 | 65.3337 | 16.5162 | 2021-06-15 04:22:22 | Vasterbotten, Sweden | ||
3381699 | 3381699 | 2021-06-13 | Sweden | Vasterbotten | 23270 | 181 | 0 | 23089 | 65.3337 | 16.5162 | 2021-06-14 04:22:46 | Vasterbotten, Sweden | ||
1736833 | 1736833 | 2021-06-12 | Sweden | Vasterbotten | 23270 | 181 | 0 | 23089 | 65.3337 | 16.5162 | 2021-06-13 04:22:44 | Vasterbotten, Sweden | ||
3970874 | 3970874 | 2021-06-11 | Sweden | Vasterbotten | 23270 | 181 | 0 | 23089 | 65.3337 | 16.5162 | 2021-06-12 04:22:22 | Vasterbotten, Sweden | ||
2717296 | 2717296 | 2021-06-10 | Sweden | Vasterbotten | 23244 | 181 | 0 | 23063 | 65.3337 | 16.5162 | 2021-06-11 04:23:20 | Vasterbotten, Sweden | ||
523181 | 523181 | 2021-06-09 | Sweden | Vasterbotten | 23231 | 181 | 0 | 23050 | 65.3337 | 16.5162 | 2021-06-10 04:23:17 | Vasterbotten, Sweden | ||
3472621 | 3472621 | 2021-06-08 | Sweden | Vasterbotten | 23185 | 181 | 0 | 23004 | 65.3337 | 16.5162 | 2021-06-09 04:23:31 | Vasterbotten, Sweden | ||
3145905 | 3145905 | 2021-06-07 | Sweden | Vasterbotten | 23146 | 181 | 0 | 22965 | 65.3337 | 16.5162 | 2021-06-08 04:22:35 | Vasterbotten, Sweden | ||
825907 | 825907 | 2021-06-06 | Sweden | Vasterbotten | 23146 | 181 | 0 | 22965 | 65.3337 | 16.5162 | 2021-06-07 04:22:51 | Vasterbotten, Sweden | ||
2586312 | 2586312 | 2021-06-05 | Sweden | Vasterbotten | 23146 | 181 | 0 | 22965 | 65.3337 | 16.5162 | 2021-06-06 04:24:03 | Vasterbotten, Sweden | ||
2315626 | 2315626 | 2021-06-04 | Sweden | Vasterbotten | 23146 | 181 | 0 | 22965 | 65.3337 | 16.5162 | 2021-06-05 04:23:03 | Vasterbotten, Sweden | ||
1448911 | 1448911 | 2021-06-03 | Sweden | Vasterbotten | 23108 | 181 | 0 | 22927 | 65.3337 | 16.5162 | 2021-06-04 04:23:37 | Vasterbotten, Sweden | ||
1708635 | 1708635 | 2021-06-02 | Sweden | Vasterbotten | 22909 | 181 | 0 | 22728 | 65.3337 | 16.5162 | 2021-06-03 04:23:32 | Vasterbotten, Sweden | ||
2104453 | 2104453 | 2021-06-01 | Sweden | Vasterbotten | 22909 | 181 | 0 | 22728 | 65.3337 | 16.5162 | 2021-06-02 04:24:34 | Vasterbotten, Sweden | ||
1189069 | 1189069 | 2021-05-31 | Sweden | Vasterbotten | 22909 | 181 | 0 | 22728 | 65.3337 | 16.5162 | 2021-06-01 04:23:09 | Vasterbotten, Sweden | ||
3089746 | 3089746 | 2021-05-30 | Sweden | Vasterbotten | 22909 | 181 | 0 | 22728 | 65.3337 | 16.5162 | 2021-05-31 03:08:59 | Vasterbotten, Sweden | ||
51115 | 51115 | 2021-05-29 | Sweden | Vasterbotten | 22909 | 181 | 0 | 22728 | 65.3337 | 16.5162 | 2021-05-30 04:20:55 | Vasterbotten, Sweden | ||
20694 | 20694 | 2021-05-28 | Sweden | Vasterbotten | 22909 | 181 | 0 | 22728 | 65.3337 | 16.5162 | 2021-05-29 04:20:41 | Vasterbotten, Sweden | ||
1807069 | 1807069 | 2021-05-27 | Sweden | Vasterbotten | 22909 | 181 | 0 | 22728 | 65.3337 | 16.5162 | 2021-05-28 04:20:36 | Vasterbotten, Sweden | ||
1310492 | 1310492 | 2021-05-26 | Sweden | Vasterbotten | 22874 | 179 | 0 | 22695 | 65.3337 | 16.5162 | 2021-05-27 04:20:59 | Vasterbotten, Sweden | ||
83418 | 83418 | 2021-05-25 | Sweden | Vasterbotten | 22774 | 180 | 0 | 22594 | 65.3337 | 16.5162 | 2021-05-26 04:20:35 | Vasterbotten, Sweden | ||
1413380 | 1413380 | 2021-05-24 | Sweden | Vasterbotten | 22641 | 180 | 0 | 22461 | 65.3337 | 16.5162 | 2021-05-25 04:21:08 | Vasterbotten, Sweden | ||
1771666 | 1771666 | 2021-05-23 | Sweden | Vasterbotten | 22641 | 180 | 0 | 22461 | 65.3337 | 16.5162 | 2021-05-24 04:20:53 | Vasterbotten, Sweden | ||
726821 | 726821 | 2021-05-22 | Sweden | Vasterbotten | 22641 | 180 | 0 | 22461 | 65.3337 | 16.5162 | 2021-05-23 04:20:51 | Vasterbotten, Sweden | ||
1952836 | 1952836 | 2021-05-21 | Sweden | Vasterbotten | 22641 | 180 | 0 | 22461 | 65.3337 | 16.5162 | 2021-05-22 04:20:45 | Vasterbotten, Sweden | ||
1913535 | 1913535 | 2021-05-20 | Sweden | Vasterbotten | 22560 | 180 | 0 | 22380 | 65.3337 | 16.5162 | 2021-05-21 04:20:43 | Vasterbotten, Sweden | ||
2256056 | 2256056 | 2021-05-19 | Sweden | Vasterbotten | 22499 | 180 | 0 | 22319 | 65.3337 | 16.5162 | 2021-05-20 04:21:05 | Vasterbotten, Sweden | ||
2391094 | 2391094 | 2021-05-18 | Sweden | Vasterbotten | 22342 | 180 | 0 | 22162 | 65.3337 | 16.5162 | 2021-05-19 04:20:42 | Vasterbotten, Sweden | ||
3574919 | 3574919 | 2021-05-17 | Sweden | Vasterbotten | 22214 | 180 | 0 | 22034 | 65.3337 | 16.5162 | 2021-05-18 04:20:33 | Vasterbotten, Sweden | ||
2939649 | 2939649 | 2021-05-16 | Sweden | Vasterbotten | 22214 | 180 | 0 | 22034 | 65.3337 | 16.5162 | 2021-05-17 04:20:34 | Vasterbotten, Sweden | ||
1873279 | 1873279 | 2021-05-15 | Sweden | Vasterbotten | 22214 | 180 | 0 | 22034 | 65.3337 | 16.5162 | 2021-05-16 04:20:49 | Vasterbotten, Sweden | ||
1082248 | 1082248 | 2021-05-14 | Sweden | Vasterbotten | 22214 | 180 | 0 | 22034 | 65.3337 | 16.5162 | 2021-05-15 04:20:58 | Vasterbotten, Sweden | ||
3054514 | 3054514 | 2021-05-13 | Sweden | Vasterbotten | 22021 | 180 | 0 | 21841 | 65.3337 | 16.5162 | 2021-05-14 04:20:41 | Vasterbotten, Sweden | ||
2004984 | 2004984 | 2021-05-12 | Sweden | Vasterbotten | 22021 | 180 | 0 | 21841 | 65.3337 | 16.5162 | 2021-05-13 04:20:51 | Vasterbotten, Sweden | ||
3954815 | 3954815 | 2021-05-11 | Sweden | Vasterbotten | 21820 | 180 | 0 | 21640 | 65.3337 | 16.5162 | 2021-05-12 04:21:29 | Vasterbotten, Sweden | ||
2821094 | 2821094 | 2021-05-10 | Sweden | Vasterbotten | 21589 | 179 | 0 | 21410 | 65.3337 | 16.5162 | 2021-05-11 04:20:41 | Vasterbotten, Sweden | ||
1425426 | 1425426 | 2021-05-09 | Sweden | Vasterbotten | 21589 | 179 | 0 | 21410 | 65.3337 | 16.5162 | 2021-05-10 04:20:38 | Vasterbotten, Sweden | ||
1552294 | 1552294 | 2021-05-08 | Sweden | Vasterbotten | 21589 | 179 | 0 | 21410 | 65.3337 | 16.5162 | 2021-05-09 04:20:35 | Vasterbotten, Sweden | ||
2502352 | 2502352 | 2021-05-07 | Sweden | Vasterbotten | 21589 | 179 | 0 | 21410 | 65.3337 | 16.5162 | 2021-05-08 04:21:04 | Vasterbotten, Sweden | ||
3113808 | 3113808 | 2021-05-06 | Sweden | Vasterbotten | 21453 | 179 | 0 | 21274 | 65.3337 | 16.5162 | 2021-05-07 04:20:40 | Vasterbotten, Sweden | ||
646275 | 646275 | 2021-05-05 | Sweden | Vasterbotten | 21352 | 178 | 0 | 21174 | 65.3337 | 16.5162 | 2021-05-06 04:20:38 | Vasterbotten, Sweden | ||
3675975 | 3675975 | 2021-05-04 | Sweden | Vasterbotten | 21143 | 178 | 0 | 20965 | 65.3337 | 16.5162 | 2021-05-05 04:20:43 | Vasterbotten, Sweden | ||
2761242 | 2761242 | 2021-05-03 | Sweden | Vasterbotten | 20903 | 178 | 0 | 20725 | 65.3337 | 16.5162 | 2021-05-04 04:20:34 | Vasterbotten, Sweden | ||
2451095 | 2451095 | 2021-05-02 | Sweden | Vasterbotten | 20903 | 178 | 0 | 20725 | 65.3337 | 16.5162 | 2021-05-03 04:20:39 | Vasterbotten, Sweden | ||
2825108 | 2825108 | 2021-05-01 | Sweden | Vasterbotten | 20903 | 178 | 0 | 20725 | 65.3337 | 16.5162 | 2021-05-02 04:20:48 | Vasterbotten, Sweden | ||
380516 | 380516 | 2021-04-30 | Sweden | Vasterbotten | 20903 | 178 | 0 | 20725 | 65.3337 | 16.5162 | 2021-05-01 04:20:47 | Vasterbotten, Sweden | ||
1636639 | 1636639 | 2021-04-29 | Sweden | Vasterbotten | 20798 | 178 | 0 | 20620 | 65.3337 | 16.5162 | 2021-04-30 04:21:03 | Vasterbotten, Sweden | ||
3393718 | 3393718 | 2021-04-28 | Sweden | Vasterbotten | 20695 | 178 | 0 | 20517 | 65.3337 | 16.5162 | 2021-04-29 04:20:55 | Vasterbotten, Sweden | ||
3702434 | 3702434 | 2021-04-27 | Sweden | Vasterbotten | 20458 | 178 | 0 | 20280 | 65.3337 | 16.5162 | 2021-04-28 04:20:32 | Vasterbotten, Sweden | ||
888443 | 888443 | 2021-04-26 | Sweden | Vasterbotten | 20182 | 178 | 0 | 20004 | 65.3337 | 16.5162 | 2021-04-27 04:20:52 | Vasterbotten, Sweden | ||
955188 | 955188 | 2021-04-25 | Sweden | Vasterbotten | 20182 | 178 | 0 | 20004 | 65.3337 | 16.5162 | 2021-04-26 04:21:04 | Vasterbotten, Sweden | ||
3924335 | 3924335 | 2021-04-24 | Sweden | Vasterbotten | 20182 | 178 | 0 | 20004 | 65.3337 | 16.5162 | 2021-04-25 04:20:32 | Vasterbotten, Sweden | ||
1409366 | 1409366 | 2021-04-23 | Sweden | Vasterbotten | 20182 | 178 | 0 | 20004 | 65.3337 | 16.5162 | 2021-04-24 04:20:38 | Vasterbotten, Sweden | ||
1568429 | 1568429 | 2021-04-22 | Sweden | Vasterbotten | 20056 | 176 | 0 | 19880 | 65.3337 | 16.5162 | 2021-04-23 04:20:52 | Vasterbotten, Sweden | ||
3242650 | 3242650 | 2021-04-21 | Sweden | Vasterbotten | 19896 | 177 | 0 | 19719 | 65.3337 | 16.5162 | 2021-04-22 04:20:53 | Vasterbotten, Sweden | ||
2021046 | 2021046 | 2021-04-20 | Sweden | Vasterbotten | 19797 | 177 | 0 | 19620 | 65.3337 | 16.5162 | 2021-04-21 04:21:14 | Vasterbotten, Sweden | ||
2411167 | 2411167 | 2021-04-19 | Sweden | Vasterbotten | 19575 | 177 | 0 | 19398 | 65.3337 | 16.5162 | 2021-04-20 04:20:41 | Vasterbotten, Sweden | ||
3129844 | 3129844 | 2021-04-18 | Sweden | Vasterbotten | 19575 | 177 | 0 | 19398 | 65.3337 | 16.5162 | 2021-04-19 04:20:57 | Vasterbotten, Sweden | ||
983272 | 983272 | 2021-04-17 | Sweden | Vasterbotten | 19575 | 177 | 0 | 19398 | 65.3337 | 16.5162 | 2021-04-18 04:20:41 | Vasterbotten, Sweden | ||
170367 | 170367 | 2021-04-16 | Sweden | Vasterbotten | 19575 | 177 | 0 | 19398 | 65.3337 | 16.5162 | 2021-04-17 04:20:40 | Vasterbotten, Sweden | ||
2549198 | 2549198 | 2021-04-15 | Sweden | Vasterbotten | 19454 | 177 | 0 | 19277 | 65.3337 | 16.5162 | 2021-04-16 04:20:46 | Vasterbotten, Sweden | ||
1842268 | 1842268 | 2021-04-14 | Sweden | Vasterbotten | 19357 | 175 | 0 | 19182 | 65.3337 | 16.5162 | 2021-04-15 04:20:54 | Vasterbotten, Sweden | ||
2572002 | 2572002 | 2021-04-13 | Sweden | Vasterbotten | 19151 | 171 | 0 | 18980 | 65.3337 | 16.5162 | 2021-04-14 04:20:41 | Vasterbotten, Sweden | ||
36753 | 36753 | 2021-04-12 | Sweden | Vasterbotten | 18905 | 170 | 0 | 18735 | 65.3337 | 16.5162 | 2021-04-13 04:20:37 | Vasterbotten, Sweden | ||
3883912 | 3883912 | 2021-04-11 | Sweden | Vasterbotten | 18905 | 170 | 0 | 18735 | 65.3337 | 16.5162 | 2021-04-12 04:21:00 | Vasterbotten, Sweden | ||
2983580 | 2983580 | 2021-04-10 | Sweden | Vasterbotten | 18905 | 170 | 0 | 18735 | 65.3337 | 16.5162 | 2021-04-11 04:20:56 | Vasterbotten, Sweden | ||
606012 | 606012 | 2021-04-09 | Sweden | Vasterbotten | 18905 | 170 | 0 | 18735 | 65.3337 | 16.5162 | 2021-04-10 04:20:59 | Vasterbotten, Sweden | ||
2646076 | 2646076 | 2021-04-08 | Sweden | Vasterbotten | 18793 | 170 | 0 | 18623 | 65.3337 | 16.5162 | 2021-04-09 04:21:13 | Vasterbotten, Sweden | ||
2247718 | 2247718 | 2021-04-07 | Sweden | Vasterbotten | 18634 | 170 | 0 | 18464 | 65.3337 | 16.5162 | 2021-04-08 04:21:13 | Vasterbotten, Sweden | ||
3003628 | 3003628 | 2021-04-06 | Sweden | Vasterbotten | 18479 | 170 | 0 | 18309 | 65.3337 | 16.5162 | 2021-04-07 04:20:53 | Vasterbotten, Sweden | ||
3085623 | 3085623 | 2021-04-05 | Sweden | Vasterbotten | 18287 | 168 | 0 | 18119 | 65.3337 | 16.5162 | 2021-04-06 04:20:32 | Vasterbotten, Sweden | ||
388546 | 388546 | 2021-04-04 | Sweden | Vasterbotten | 18287 | 168 | 0 | 18119 | 65.3337 | 16.5162 | 2021-04-05 04:20:35 | Vasterbotten, Sweden | ||
3710462 | 3710462 | 2021-04-03 | Sweden | Vasterbotten | 18287 | 168 | 0 | 18119 | 65.3337 | 16.5162 | 2021-04-04 04:20:49 | Vasterbotten, Sweden | ||
241578 | 241578 | 2021-04-02 | Sweden | Vasterbotten | 18287 | 168 | 0 | 18119 | 65.3337 | 16.5162 | 2021-04-03 04:20:44 | Vasterbotten, Sweden | ||
1302375 | 1302375 | 2021-04-01 | Sweden | Vasterbotten | 18287 | 168 | 0 | 18119 | 65.3337 | 16.5162 | 2021-04-02 04:20:36 | Vasterbotten, Sweden | ||
638247 | 638247 | 2021-03-31 | Sweden | Vasterbotten | 18195 | 168 | 0 | 18027 | 65.3337 | 16.5162 | 2021-04-01 04:27:05 | Vasterbotten, Sweden | ||
3643876 | 3643876 | 2021-03-30 | Sweden | Vasterbotten | 18013 | 166 | 0 | 17847 | 65.3337 | 16.5162 | 2021-03-31 04:26:25 | Vasterbotten, Sweden | ||
1290329 | 1290329 | 2021-03-29 | Sweden | Vasterbotten | 17812 | 165 | 0 | 17647 | 65.3337 | 16.5162 | 2021-03-30 04:26:23 | Vasterbotten, Sweden | ||
1536251 | 1536251 | 2021-03-28 | Sweden | Vasterbotten | 17812 | 165 | 0 | 17647 | 65.3337 | 16.5162 | 2021-03-29 04:28:35 | Vasterbotten, Sweden | ||
1219891 | 1219891 | 2021-03-27 | Sweden | Vasterbotten | 17812 | 165 | 0 | 17647 | 65.3337 | 16.5162 | 2021-03-28 05:28:10 | Vasterbotten, Sweden | ||
1881309 | 1881309 | 2021-03-26 | Sweden | Vasterbotten | 17812 | 165 | 0 | 17647 | 65.3337 | 16.5162 | 2021-03-27 05:25:04 | Vasterbotten, Sweden | ||
1980939 | 1980939 | 2021-03-25 | Sweden | Vasterbotten | 17712 | 164 | 0 | 17548 | 65.3337 | 16.5162 | 2021-03-26 05:26:55 | Vasterbotten, Sweden | ||
2781317 | 2781317 | 2021-03-24 | Sweden | Vasterbotten | 17595 | 163 | 0 | 17432 | 65.3337 | 16.5162 | 2021-03-25 05:27:00 | Vasterbotten, Sweden | ||
1798962 | 1798962 | 2021-03-23 | Sweden | Vasterbotten | 17395 | 160 | 0 | 17235 | 65.3337 | 16.5162 | 2021-03-24 05:25:40 | Vasterbotten, Sweden | ||
1204130 | 1204130 | 2021-03-22 | Sweden | Vasterbotten | 17173 | 158 | 0 | 17015 | 65.3337 | 16.5162 | 2021-03-23 05:26:18 | Vasterbotten, Sweden | ||
3369652 | 3369652 | 2021-03-21 | Sweden | Vasterbotten | 17173 | 158 | 0 | 17015 | 65.3337 | 16.5162 | 2021-03-22 05:25:43 | Vasterbotten, Sweden | ||
1744862 | 1744862 | 2021-03-20 | Sweden | Vasterbotten | 17173 | 158 | 0 | 17015 | 65.3337 | 16.5162 | 2021-03-21 05:25:44 | Vasterbotten, Sweden | ||
3421242 | 3421242 | 2021-03-19 | Sweden | Vasterbotten | 17173 | 158 | 0 | 17015 | 65.3337 | 16.5162 | 2021-03-20 05:25:46 | Vasterbotten, Sweden | ||
3453180 | 3453180 | 2021-03-18 | Sweden | Vasterbotten | 17032 | 158 | 0 | 16874 | 65.3337 | 16.5162 | 2021-03-19 05:26:09 | Vasterbotten, Sweden | ||
3621404 | 3621404 | 2021-03-17 | Sweden | Vasterbotten | 16902 | 157 | 0 | 16745 | 65.3337 | 16.5162 | 2021-03-18 05:26:22 | Vasterbotten, Sweden | ||
702728 | 702728 | 2021-03-16 | Sweden | Vasterbotten | 16612 | 152 | 0 | 16460 | 65.3337 | 16.5162 | 2021-03-17 05:25:07 | Vasterbotten, Sweden | ||
2056206 | 2056206 | 2021-03-15 | Sweden | Vasterbotten | 16343 | 150 | 0 | 16193 | 65.3337 | 16.5162 | 2021-03-16 05:25:13 | Vasterbotten, Sweden | ||
1732818 | 1732818 | 2021-03-14 | Sweden | Vasterbotten | 16343 | 150 | 0 | 16193 | 65.3337 | 16.5162 | 2021-03-15 05:25:51 | Vasterbotten, Sweden | ||
1580475 | 1580475 | 2021-03-13 | Sweden | Vasterbotten | 16343 | 150 | 0 | 16193 | 65.3337 | 16.5162 | 2021-03-14 05:25:37 | Vasterbotten, Sweden |
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]);