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 = "Vasternorrland" 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
- Vasternorrland · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884695 | 2884695 | 2021-06-20 | Sweden | Vasternorrland | 26791 | 474 | 0 | 26317 | 63.4276 | 17.7292 | 2021-06-21 04:21:41 | Vasternorrland, Sweden | ||
107778 | 107778 | 2021-06-19 | Sweden | Vasternorrland | 26791 | 474 | 0 | 26317 | 63.4276 | 17.7292 | 2021-06-20 04:21:48 | Vasternorrland, Sweden | ||
1125921 | 1125921 | 2021-06-18 | Sweden | Vasternorrland | 26791 | 474 | 0 | 26317 | 63.4276 | 17.7292 | 2021-06-19 04:22:33 | Vasternorrland, Sweden | ||
2911499 | 2911499 | 2021-06-17 | Sweden | Vasternorrland | 26791 | 474 | 0 | 26317 | 63.4276 | 17.7292 | 2021-06-18 04:22:16 | Vasternorrland, Sweden | ||
3030615 | 3030615 | 2021-06-16 | Sweden | Vasternorrland | 26791 | 474 | 0 | 26317 | 63.4276 | 17.7292 | 2021-06-17 04:22:36 | Vasternorrland, Sweden | ||
2339721 | 2339721 | 2021-06-15 | Sweden | Vasternorrland | 26791 | 474 | 0 | 26317 | 63.4276 | 17.7292 | 2021-06-16 04:22:32 | Vasternorrland, Sweden | ||
1564417 | 1564417 | 2021-06-14 | Sweden | Vasternorrland | 26783 | 474 | 0 | 26309 | 63.4276 | 17.7292 | 2021-06-15 04:22:22 | Vasternorrland, Sweden | ||
3381700 | 3381700 | 2021-06-13 | Sweden | Vasternorrland | 26783 | 474 | 0 | 26309 | 63.4276 | 17.7292 | 2021-06-14 04:22:46 | Vasternorrland, Sweden | ||
1736834 | 1736834 | 2021-06-12 | Sweden | Vasternorrland | 26783 | 474 | 0 | 26309 | 63.4276 | 17.7292 | 2021-06-13 04:22:44 | Vasternorrland, Sweden | ||
3970875 | 3970875 | 2021-06-11 | Sweden | Vasternorrland | 26783 | 474 | 0 | 26309 | 63.4276 | 17.7292 | 2021-06-12 04:22:22 | Vasternorrland, Sweden | ||
2717297 | 2717297 | 2021-06-10 | Sweden | Vasternorrland | 26773 | 473 | 0 | 26300 | 63.4276 | 17.7292 | 2021-06-11 04:23:20 | Vasternorrland, Sweden | ||
523182 | 523182 | 2021-06-09 | Sweden | Vasternorrland | 26761 | 473 | 0 | 26288 | 63.4276 | 17.7292 | 2021-06-10 04:23:17 | Vasternorrland, Sweden | ||
3472622 | 3472622 | 2021-06-08 | Sweden | Vasternorrland | 26727 | 470 | 0 | 26257 | 63.4276 | 17.7292 | 2021-06-09 04:23:31 | Vasternorrland, Sweden | ||
3145906 | 3145906 | 2021-06-07 | Sweden | Vasternorrland | 26678 | 470 | 0 | 26208 | 63.4276 | 17.7292 | 2021-06-08 04:22:35 | Vasternorrland, Sweden | ||
825908 | 825908 | 2021-06-06 | Sweden | Vasternorrland | 26678 | 470 | 0 | 26208 | 63.4276 | 17.7292 | 2021-06-07 04:22:51 | Vasternorrland, Sweden | ||
2586313 | 2586313 | 2021-06-05 | Sweden | Vasternorrland | 26678 | 470 | 0 | 26208 | 63.4276 | 17.7292 | 2021-06-06 04:24:03 | Vasternorrland, Sweden | ||
2315627 | 2315627 | 2021-06-04 | Sweden | Vasternorrland | 26678 | 470 | 0 | 26208 | 63.4276 | 17.7292 | 2021-06-05 04:23:03 | Vasternorrland, Sweden | ||
1448912 | 1448912 | 2021-06-03 | Sweden | Vasternorrland | 26653 | 468 | 0 | 26185 | 63.4276 | 17.7292 | 2021-06-04 04:23:37 | Vasternorrland, Sweden | ||
1708636 | 1708636 | 2021-06-02 | Sweden | Vasternorrland | 26417 | 467 | 0 | 25950 | 63.4276 | 17.7292 | 2021-06-03 04:23:32 | Vasternorrland, Sweden | ||
2104454 | 2104454 | 2021-06-01 | Sweden | Vasternorrland | 26417 | 467 | 0 | 25950 | 63.4276 | 17.7292 | 2021-06-02 04:24:34 | Vasternorrland, Sweden | ||
1189070 | 1189070 | 2021-05-31 | Sweden | Vasternorrland | 26417 | 467 | 0 | 25950 | 63.4276 | 17.7292 | 2021-06-01 04:23:09 | Vasternorrland, Sweden | ||
3089747 | 3089747 | 2021-05-30 | Sweden | Vasternorrland | 26417 | 467 | 0 | 25950 | 63.4276 | 17.7292 | 2021-05-31 03:08:59 | Vasternorrland, Sweden | ||
51116 | 51116 | 2021-05-29 | Sweden | Vasternorrland | 26417 | 467 | 0 | 25950 | 63.4276 | 17.7292 | 2021-05-30 04:20:55 | Vasternorrland, Sweden | ||
20695 | 20695 | 2021-05-28 | Sweden | Vasternorrland | 26417 | 467 | 0 | 25950 | 63.4276 | 17.7292 | 2021-05-29 04:20:41 | Vasternorrland, Sweden | ||
1807070 | 1807070 | 2021-05-27 | Sweden | Vasternorrland | 26417 | 467 | 0 | 25950 | 63.4276 | 17.7292 | 2021-05-28 04:20:36 | Vasternorrland, Sweden | ||
1310493 | 1310493 | 2021-05-26 | Sweden | Vasternorrland | 26369 | 467 | 0 | 25902 | 63.4276 | 17.7292 | 2021-05-27 04:20:59 | Vasternorrland, Sweden | ||
83419 | 83419 | 2021-05-25 | Sweden | Vasternorrland | 26311 | 467 | 0 | 25844 | 63.4276 | 17.7292 | 2021-05-26 04:20:35 | Vasternorrland, Sweden | ||
1413381 | 1413381 | 2021-05-24 | Sweden | Vasternorrland | 26188 | 467 | 0 | 25721 | 63.4276 | 17.7292 | 2021-05-25 04:21:08 | Vasternorrland, Sweden | ||
1771667 | 1771667 | 2021-05-23 | Sweden | Vasternorrland | 26188 | 467 | 0 | 25721 | 63.4276 | 17.7292 | 2021-05-24 04:20:53 | Vasternorrland, Sweden | ||
726822 | 726822 | 2021-05-22 | Sweden | Vasternorrland | 26188 | 467 | 0 | 25721 | 63.4276 | 17.7292 | 2021-05-23 04:20:51 | Vasternorrland, Sweden | ||
1952837 | 1952837 | 2021-05-21 | Sweden | Vasternorrland | 26188 | 467 | 0 | 25721 | 63.4276 | 17.7292 | 2021-05-22 04:20:45 | Vasternorrland, Sweden | ||
1913536 | 1913536 | 2021-05-20 | Sweden | Vasternorrland | 26109 | 466 | 0 | 25643 | 63.4276 | 17.7292 | 2021-05-21 04:20:43 | Vasternorrland, Sweden | ||
2256057 | 2256057 | 2021-05-19 | Sweden | Vasternorrland | 26050 | 466 | 0 | 25584 | 63.4276 | 17.7292 | 2021-05-20 04:21:05 | Vasternorrland, Sweden | ||
2391095 | 2391095 | 2021-05-18 | Sweden | Vasternorrland | 25897 | 465 | 0 | 25432 | 63.4276 | 17.7292 | 2021-05-19 04:20:42 | Vasternorrland, Sweden | ||
3574920 | 3574920 | 2021-05-17 | Sweden | Vasternorrland | 25725 | 465 | 0 | 25260 | 63.4276 | 17.7292 | 2021-05-18 04:20:33 | Vasternorrland, Sweden | ||
2939650 | 2939650 | 2021-05-16 | Sweden | Vasternorrland | 25725 | 465 | 0 | 25260 | 63.4276 | 17.7292 | 2021-05-17 04:20:34 | Vasternorrland, Sweden | ||
1873280 | 1873280 | 2021-05-15 | Sweden | Vasternorrland | 25725 | 465 | 0 | 25260 | 63.4276 | 17.7292 | 2021-05-16 04:20:49 | Vasternorrland, Sweden | ||
1082249 | 1082249 | 2021-05-14 | Sweden | Vasternorrland | 25725 | 465 | 0 | 25260 | 63.4276 | 17.7292 | 2021-05-15 04:20:58 | Vasternorrland, Sweden | ||
3054515 | 3054515 | 2021-05-13 | Sweden | Vasternorrland | 25495 | 461 | 0 | 25034 | 63.4276 | 17.7292 | 2021-05-14 04:20:41 | Vasternorrland, Sweden | ||
2004985 | 2004985 | 2021-05-12 | Sweden | Vasternorrland | 25495 | 461 | 0 | 25034 | 63.4276 | 17.7292 | 2021-05-13 04:20:51 | Vasternorrland, Sweden | ||
3954816 | 3954816 | 2021-05-11 | Sweden | Vasternorrland | 25265 | 461 | 0 | 24804 | 63.4276 | 17.7292 | 2021-05-12 04:21:29 | Vasternorrland, Sweden | ||
2821095 | 2821095 | 2021-05-10 | Sweden | Vasternorrland | 24914 | 460 | 0 | 24454 | 63.4276 | 17.7292 | 2021-05-11 04:20:41 | Vasternorrland, Sweden | ||
1425427 | 1425427 | 2021-05-09 | Sweden | Vasternorrland | 24914 | 460 | 0 | 24454 | 63.4276 | 17.7292 | 2021-05-10 04:20:38 | Vasternorrland, Sweden | ||
1552295 | 1552295 | 2021-05-08 | Sweden | Vasternorrland | 24914 | 460 | 0 | 24454 | 63.4276 | 17.7292 | 2021-05-09 04:20:35 | Vasternorrland, Sweden | ||
2502353 | 2502353 | 2021-05-07 | Sweden | Vasternorrland | 24914 | 460 | 0 | 24454 | 63.4276 | 17.7292 | 2021-05-08 04:21:04 | Vasternorrland, Sweden | ||
3113809 | 3113809 | 2021-05-06 | Sweden | Vasternorrland | 24711 | 460 | 0 | 24251 | 63.4276 | 17.7292 | 2021-05-07 04:20:40 | Vasternorrland, Sweden | ||
646276 | 646276 | 2021-05-05 | Sweden | Vasternorrland | 24490 | 459 | 0 | 24031 | 63.4276 | 17.7292 | 2021-05-06 04:20:38 | Vasternorrland, Sweden | ||
3675976 | 3675976 | 2021-05-04 | Sweden | Vasternorrland | 24182 | 459 | 0 | 23723 | 63.4276 | 17.7292 | 2021-05-05 04:20:43 | Vasternorrland, Sweden | ||
2761243 | 2761243 | 2021-05-03 | Sweden | Vasternorrland | 23802 | 458 | 0 | 23344 | 63.4276 | 17.7292 | 2021-05-04 04:20:34 | Vasternorrland, Sweden | ||
2451096 | 2451096 | 2021-05-02 | Sweden | Vasternorrland | 23802 | 458 | 0 | 23344 | 63.4276 | 17.7292 | 2021-05-03 04:20:39 | Vasternorrland, Sweden | ||
2825109 | 2825109 | 2021-05-01 | Sweden | Vasternorrland | 23802 | 458 | 0 | 23344 | 63.4276 | 17.7292 | 2021-05-02 04:20:48 | Vasternorrland, Sweden | ||
380517 | 380517 | 2021-04-30 | Sweden | Vasternorrland | 23802 | 458 | 0 | 23344 | 63.4276 | 17.7292 | 2021-05-01 04:20:47 | Vasternorrland, Sweden | ||
1636640 | 1636640 | 2021-04-29 | Sweden | Vasternorrland | 23561 | 458 | 0 | 23103 | 63.4276 | 17.7292 | 2021-04-30 04:21:03 | Vasternorrland, Sweden | ||
3393719 | 3393719 | 2021-04-28 | Sweden | Vasternorrland | 23312 | 458 | 0 | 22854 | 63.4276 | 17.7292 | 2021-04-29 04:20:55 | Vasternorrland, Sweden | ||
3702435 | 3702435 | 2021-04-27 | Sweden | Vasternorrland | 22938 | 452 | 0 | 22486 | 63.4276 | 17.7292 | 2021-04-28 04:20:32 | Vasternorrland, Sweden | ||
888444 | 888444 | 2021-04-26 | Sweden | Vasternorrland | 22467 | 445 | 0 | 22022 | 63.4276 | 17.7292 | 2021-04-27 04:20:52 | Vasternorrland, Sweden | ||
955189 | 955189 | 2021-04-25 | Sweden | Vasternorrland | 22467 | 445 | 0 | 22022 | 63.4276 | 17.7292 | 2021-04-26 04:21:04 | Vasternorrland, Sweden | ||
3924336 | 3924336 | 2021-04-24 | Sweden | Vasternorrland | 22467 | 445 | 0 | 22022 | 63.4276 | 17.7292 | 2021-04-25 04:20:32 | Vasternorrland, Sweden | ||
1409367 | 1409367 | 2021-04-23 | Sweden | Vasternorrland | 22467 | 445 | 0 | 22022 | 63.4276 | 17.7292 | 2021-04-24 04:20:38 | Vasternorrland, Sweden | ||
1568430 | 1568430 | 2021-04-22 | Sweden | Vasternorrland | 22178 | 445 | 0 | 21733 | 63.4276 | 17.7292 | 2021-04-23 04:20:52 | Vasternorrland, Sweden | ||
3242651 | 3242651 | 2021-04-21 | Sweden | Vasternorrland | 21848 | 439 | 0 | 21409 | 63.4276 | 17.7292 | 2021-04-22 04:20:53 | Vasternorrland, Sweden | ||
2021047 | 2021047 | 2021-04-20 | Sweden | Vasternorrland | 21431 | 437 | 0 | 20994 | 63.4276 | 17.7292 | 2021-04-21 04:21:14 | Vasternorrland, Sweden | ||
2411168 | 2411168 | 2021-04-19 | Sweden | Vasternorrland | 20861 | 437 | 0 | 20424 | 63.4276 | 17.7292 | 2021-04-20 04:20:41 | Vasternorrland, Sweden | ||
3129845 | 3129845 | 2021-04-18 | Sweden | Vasternorrland | 20861 | 437 | 0 | 20424 | 63.4276 | 17.7292 | 2021-04-19 04:20:57 | Vasternorrland, Sweden | ||
983273 | 983273 | 2021-04-17 | Sweden | Vasternorrland | 20861 | 437 | 0 | 20424 | 63.4276 | 17.7292 | 2021-04-18 04:20:41 | Vasternorrland, Sweden | ||
170368 | 170368 | 2021-04-16 | Sweden | Vasternorrland | 20861 | 437 | 0 | 20424 | 63.4276 | 17.7292 | 2021-04-17 04:20:40 | Vasternorrland, Sweden | ||
2549199 | 2549199 | 2021-04-15 | Sweden | Vasternorrland | 20503 | 437 | 0 | 20066 | 63.4276 | 17.7292 | 2021-04-16 04:20:46 | Vasternorrland, Sweden | ||
1842269 | 1842269 | 2021-04-14 | Sweden | Vasternorrland | 20222 | 437 | 0 | 19785 | 63.4276 | 17.7292 | 2021-04-15 04:20:54 | Vasternorrland, Sweden | ||
2572003 | 2572003 | 2021-04-13 | Sweden | Vasternorrland | 19862 | 435 | 0 | 19427 | 63.4276 | 17.7292 | 2021-04-14 04:20:41 | Vasternorrland, Sweden | ||
36754 | 36754 | 2021-04-12 | Sweden | Vasternorrland | 19234 | 434 | 0 | 18800 | 63.4276 | 17.7292 | 2021-04-13 04:20:37 | Vasternorrland, Sweden | ||
3883913 | 3883913 | 2021-04-11 | Sweden | Vasternorrland | 19234 | 434 | 0 | 18800 | 63.4276 | 17.7292 | 2021-04-12 04:21:00 | Vasternorrland, Sweden | ||
2983581 | 2983581 | 2021-04-10 | Sweden | Vasternorrland | 19234 | 434 | 0 | 18800 | 63.4276 | 17.7292 | 2021-04-11 04:20:56 | Vasternorrland, Sweden | ||
606013 | 606013 | 2021-04-09 | Sweden | Vasternorrland | 19234 | 434 | 0 | 18800 | 63.4276 | 17.7292 | 2021-04-10 04:20:59 | Vasternorrland, Sweden | ||
2646077 | 2646077 | 2021-04-08 | Sweden | Vasternorrland | 18912 | 432 | 0 | 18480 | 63.4276 | 17.7292 | 2021-04-09 04:21:13 | Vasternorrland, Sweden | ||
2247719 | 2247719 | 2021-04-07 | Sweden | Vasternorrland | 18617 | 432 | 0 | 18185 | 63.4276 | 17.7292 | 2021-04-08 04:21:13 | Vasternorrland, Sweden | ||
3003629 | 3003629 | 2021-04-06 | Sweden | Vasternorrland | 18404 | 430 | 0 | 17974 | 63.4276 | 17.7292 | 2021-04-07 04:20:53 | Vasternorrland, Sweden | ||
3085624 | 3085624 | 2021-04-05 | Sweden | Vasternorrland | 17857 | 429 | 0 | 17428 | 63.4276 | 17.7292 | 2021-04-06 04:20:32 | Vasternorrland, Sweden | ||
388547 | 388547 | 2021-04-04 | Sweden | Vasternorrland | 17857 | 429 | 0 | 17428 | 63.4276 | 17.7292 | 2021-04-05 04:20:35 | Vasternorrland, Sweden | ||
3710463 | 3710463 | 2021-04-03 | Sweden | Vasternorrland | 17857 | 429 | 0 | 17428 | 63.4276 | 17.7292 | 2021-04-04 04:20:49 | Vasternorrland, Sweden | ||
241579 | 241579 | 2021-04-02 | Sweden | Vasternorrland | 17857 | 429 | 0 | 17428 | 63.4276 | 17.7292 | 2021-04-03 04:20:44 | Vasternorrland, Sweden | ||
1302376 | 1302376 | 2021-04-01 | Sweden | Vasternorrland | 17857 | 429 | 0 | 17428 | 63.4276 | 17.7292 | 2021-04-02 04:20:36 | Vasternorrland, Sweden | ||
638248 | 638248 | 2021-03-31 | Sweden | Vasternorrland | 17608 | 428 | 0 | 17180 | 63.4276 | 17.7292 | 2021-04-01 04:27:05 | Vasternorrland, Sweden | ||
3643877 | 3643877 | 2021-03-30 | Sweden | Vasternorrland | 17371 | 427 | 0 | 16944 | 63.4276 | 17.7292 | 2021-03-31 04:26:25 | Vasternorrland, Sweden | ||
1290330 | 1290330 | 2021-03-29 | Sweden | Vasternorrland | 17063 | 425 | 0 | 16638 | 63.4276 | 17.7292 | 2021-03-30 04:26:23 | Vasternorrland, Sweden | ||
1536252 | 1536252 | 2021-03-28 | Sweden | Vasternorrland | 17063 | 425 | 0 | 16638 | 63.4276 | 17.7292 | 2021-03-29 04:28:35 | Vasternorrland, Sweden | ||
1219892 | 1219892 | 2021-03-27 | Sweden | Vasternorrland | 17063 | 425 | 0 | 16638 | 63.4276 | 17.7292 | 2021-03-28 05:28:10 | Vasternorrland, Sweden | ||
1881310 | 1881310 | 2021-03-26 | Sweden | Vasternorrland | 17063 | 425 | 0 | 16638 | 63.4276 | 17.7292 | 2021-03-27 05:25:04 | Vasternorrland, Sweden | ||
1980940 | 1980940 | 2021-03-25 | Sweden | Vasternorrland | 16906 | 424 | 0 | 16482 | 63.4276 | 17.7292 | 2021-03-26 05:26:55 | Vasternorrland, Sweden | ||
2781318 | 2781318 | 2021-03-24 | Sweden | Vasternorrland | 16663 | 424 | 0 | 16239 | 63.4276 | 17.7292 | 2021-03-25 05:27:00 | Vasternorrland, Sweden | ||
1798963 | 1798963 | 2021-03-23 | Sweden | Vasternorrland | 16556 | 423 | 0 | 16133 | 63.4276 | 17.7292 | 2021-03-24 05:25:40 | Vasternorrland, Sweden | ||
1204131 | 1204131 | 2021-03-22 | Sweden | Vasternorrland | 16321 | 423 | 0 | 15898 | 63.4276 | 17.7292 | 2021-03-23 05:26:18 | Vasternorrland, Sweden | ||
3369653 | 3369653 | 2021-03-21 | Sweden | Vasternorrland | 16321 | 423 | 0 | 15898 | 63.4276 | 17.7292 | 2021-03-22 05:25:43 | Vasternorrland, Sweden | ||
1744863 | 1744863 | 2021-03-20 | Sweden | Vasternorrland | 16321 | 423 | 0 | 15898 | 63.4276 | 17.7292 | 2021-03-21 05:25:44 | Vasternorrland, Sweden | ||
3421243 | 3421243 | 2021-03-19 | Sweden | Vasternorrland | 16321 | 423 | 0 | 15898 | 63.4276 | 17.7292 | 2021-03-20 05:25:46 | Vasternorrland, Sweden | ||
3453181 | 3453181 | 2021-03-18 | Sweden | Vasternorrland | 16203 | 421 | 0 | 15782 | 63.4276 | 17.7292 | 2021-03-19 05:26:09 | Vasternorrland, Sweden | ||
3621405 | 3621405 | 2021-03-17 | Sweden | Vasternorrland | 16073 | 421 | 0 | 15652 | 63.4276 | 17.7292 | 2021-03-18 05:26:22 | Vasternorrland, Sweden | ||
702729 | 702729 | 2021-03-16 | Sweden | Vasternorrland | 15911 | 418 | 0 | 15493 | 63.4276 | 17.7292 | 2021-03-17 05:25:07 | Vasternorrland, Sweden | ||
2056207 | 2056207 | 2021-03-15 | Sweden | Vasternorrland | 15738 | 417 | 0 | 15321 | 63.4276 | 17.7292 | 2021-03-16 05:25:13 | Vasternorrland, Sweden | ||
1732819 | 1732819 | 2021-03-14 | Sweden | Vasternorrland | 15738 | 417 | 0 | 15321 | 63.4276 | 17.7292 | 2021-03-15 05:25:51 | Vasternorrland, Sweden | ||
1580476 | 1580476 | 2021-03-13 | Sweden | Vasternorrland | 15738 | 417 | 0 | 15321 | 63.4276 | 17.7292 | 2021-03-14 05:25:37 | Vasternorrland, 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]);