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 = "Vastmanland" 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
- Vastmanland · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884696 | 2884696 | 2021-06-20 | Sweden | Vastmanland | 27486 | 348 | 0 | 27138 | 59.6714 | 16.2159 | 2021-06-21 04:21:41 | Vastmanland, Sweden | ||
107779 | 107779 | 2021-06-19 | Sweden | Vastmanland | 27486 | 348 | 0 | 27138 | 59.6714 | 16.2159 | 2021-06-20 04:21:48 | Vastmanland, Sweden | ||
1125922 | 1125922 | 2021-06-18 | Sweden | Vastmanland | 27486 | 348 | 0 | 27138 | 59.6714 | 16.2159 | 2021-06-19 04:22:33 | Vastmanland, Sweden | ||
2911500 | 2911500 | 2021-06-17 | Sweden | Vastmanland | 27486 | 348 | 0 | 27138 | 59.6714 | 16.2159 | 2021-06-18 04:22:16 | Vastmanland, Sweden | ||
3030616 | 3030616 | 2021-06-16 | Sweden | Vastmanland | 27486 | 348 | 0 | 27138 | 59.6714 | 16.2159 | 2021-06-17 04:22:36 | Vastmanland, Sweden | ||
2339722 | 2339722 | 2021-06-15 | Sweden | Vastmanland | 27486 | 348 | 0 | 27138 | 59.6714 | 16.2159 | 2021-06-16 04:22:32 | Vastmanland, Sweden | ||
1564418 | 1564418 | 2021-06-14 | Sweden | Vastmanland | 27444 | 348 | 0 | 27096 | 59.6714 | 16.2159 | 2021-06-15 04:22:22 | Vastmanland, Sweden | ||
3381701 | 3381701 | 2021-06-13 | Sweden | Vastmanland | 27444 | 348 | 0 | 27096 | 59.6714 | 16.2159 | 2021-06-14 04:22:46 | Vastmanland, Sweden | ||
1736835 | 1736835 | 2021-06-12 | Sweden | Vastmanland | 27444 | 348 | 0 | 27096 | 59.6714 | 16.2159 | 2021-06-13 04:22:44 | Vastmanland, Sweden | ||
3970876 | 3970876 | 2021-06-11 | Sweden | Vastmanland | 27444 | 348 | 0 | 27096 | 59.6714 | 16.2159 | 2021-06-12 04:22:22 | Vastmanland, Sweden | ||
2717298 | 2717298 | 2021-06-10 | Sweden | Vastmanland | 27418 | 348 | 0 | 27070 | 59.6714 | 16.2159 | 2021-06-11 04:23:20 | Vastmanland, Sweden | ||
523183 | 523183 | 2021-06-09 | Sweden | Vastmanland | 27398 | 348 | 0 | 27050 | 59.6714 | 16.2159 | 2021-06-10 04:23:17 | Vastmanland, Sweden | ||
3472623 | 3472623 | 2021-06-08 | Sweden | Vastmanland | 27363 | 347 | 0 | 27016 | 59.6714 | 16.2159 | 2021-06-09 04:23:31 | Vastmanland, Sweden | ||
3145907 | 3145907 | 2021-06-07 | Sweden | Vastmanland | 27319 | 347 | 0 | 26972 | 59.6714 | 16.2159 | 2021-06-08 04:22:35 | Vastmanland, Sweden | ||
825909 | 825909 | 2021-06-06 | Sweden | Vastmanland | 27319 | 347 | 0 | 26972 | 59.6714 | 16.2159 | 2021-06-07 04:22:51 | Vastmanland, Sweden | ||
2586314 | 2586314 | 2021-06-05 | Sweden | Vastmanland | 27319 | 347 | 0 | 26972 | 59.6714 | 16.2159 | 2021-06-06 04:24:03 | Vastmanland, Sweden | ||
2315628 | 2315628 | 2021-06-04 | Sweden | Vastmanland | 27319 | 347 | 0 | 26972 | 59.6714 | 16.2159 | 2021-06-05 04:23:03 | Vastmanland, Sweden | ||
1448913 | 1448913 | 2021-06-03 | Sweden | Vastmanland | 27292 | 347 | 0 | 26945 | 59.6714 | 16.2159 | 2021-06-04 04:23:37 | Vastmanland, Sweden | ||
1708637 | 1708637 | 2021-06-02 | Sweden | Vastmanland | 27122 | 347 | 0 | 26775 | 59.6714 | 16.2159 | 2021-06-03 04:23:32 | Vastmanland, Sweden | ||
2104455 | 2104455 | 2021-06-01 | Sweden | Vastmanland | 27122 | 347 | 0 | 26775 | 59.6714 | 16.2159 | 2021-06-02 04:24:34 | Vastmanland, Sweden | ||
1189071 | 1189071 | 2021-05-31 | Sweden | Vastmanland | 27122 | 347 | 0 | 26775 | 59.6714 | 16.2159 | 2021-06-01 04:23:09 | Vastmanland, Sweden | ||
3089748 | 3089748 | 2021-05-30 | Sweden | Vastmanland | 27122 | 347 | 0 | 26775 | 59.6714 | 16.2159 | 2021-05-31 03:08:59 | Vastmanland, Sweden | ||
51117 | 51117 | 2021-05-29 | Sweden | Vastmanland | 27122 | 347 | 0 | 26775 | 59.6714 | 16.2159 | 2021-05-30 04:20:55 | Vastmanland, Sweden | ||
20696 | 20696 | 2021-05-28 | Sweden | Vastmanland | 27122 | 347 | 0 | 26775 | 59.6714 | 16.2159 | 2021-05-29 04:20:41 | Vastmanland, Sweden | ||
1807071 | 1807071 | 2021-05-27 | Sweden | Vastmanland | 27122 | 347 | 0 | 26775 | 59.6714 | 16.2159 | 2021-05-28 04:20:36 | Vastmanland, Sweden | ||
1310494 | 1310494 | 2021-05-26 | Sweden | Vastmanland | 27070 | 347 | 0 | 26723 | 59.6714 | 16.2159 | 2021-05-27 04:20:59 | Vastmanland, Sweden | ||
83420 | 83420 | 2021-05-25 | Sweden | Vastmanland | 26998 | 345 | 0 | 26653 | 59.6714 | 16.2159 | 2021-05-26 04:20:35 | Vastmanland, Sweden | ||
1413382 | 1413382 | 2021-05-24 | Sweden | Vastmanland | 26900 | 345 | 0 | 26555 | 59.6714 | 16.2159 | 2021-05-25 04:21:08 | Vastmanland, Sweden | ||
1771668 | 1771668 | 2021-05-23 | Sweden | Vastmanland | 26900 | 345 | 0 | 26555 | 59.6714 | 16.2159 | 2021-05-24 04:20:53 | Vastmanland, Sweden | ||
726823 | 726823 | 2021-05-22 | Sweden | Vastmanland | 26900 | 345 | 0 | 26555 | 59.6714 | 16.2159 | 2021-05-23 04:20:51 | Vastmanland, Sweden | ||
1952838 | 1952838 | 2021-05-21 | Sweden | Vastmanland | 26900 | 345 | 0 | 26555 | 59.6714 | 16.2159 | 2021-05-22 04:20:45 | Vastmanland, Sweden | ||
1913537 | 1913537 | 2021-05-20 | Sweden | Vastmanland | 26799 | 345 | 0 | 26454 | 59.6714 | 16.2159 | 2021-05-21 04:20:43 | Vastmanland, Sweden | ||
2256058 | 2256058 | 2021-05-19 | Sweden | Vastmanland | 26741 | 345 | 0 | 26396 | 59.6714 | 16.2159 | 2021-05-20 04:21:05 | Vastmanland, Sweden | ||
2391096 | 2391096 | 2021-05-18 | Sweden | Vastmanland | 26633 | 345 | 0 | 26288 | 59.6714 | 16.2159 | 2021-05-19 04:20:42 | Vastmanland, Sweden | ||
3574921 | 3574921 | 2021-05-17 | Sweden | Vastmanland | 26429 | 345 | 0 | 26084 | 59.6714 | 16.2159 | 2021-05-18 04:20:33 | Vastmanland, Sweden | ||
2939651 | 2939651 | 2021-05-16 | Sweden | Vastmanland | 26429 | 345 | 0 | 26084 | 59.6714 | 16.2159 | 2021-05-17 04:20:34 | Vastmanland, Sweden | ||
1873281 | 1873281 | 2021-05-15 | Sweden | Vastmanland | 26429 | 345 | 0 | 26084 | 59.6714 | 16.2159 | 2021-05-16 04:20:49 | Vastmanland, Sweden | ||
1082250 | 1082250 | 2021-05-14 | Sweden | Vastmanland | 26429 | 345 | 0 | 26084 | 59.6714 | 16.2159 | 2021-05-15 04:20:58 | Vastmanland, Sweden | ||
3054516 | 3054516 | 2021-05-13 | Sweden | Vastmanland | 26155 | 345 | 0 | 25810 | 59.6714 | 16.2159 | 2021-05-14 04:20:41 | Vastmanland, Sweden | ||
2004986 | 2004986 | 2021-05-12 | Sweden | Vastmanland | 26155 | 345 | 0 | 25810 | 59.6714 | 16.2159 | 2021-05-13 04:20:51 | Vastmanland, Sweden | ||
3954817 | 3954817 | 2021-05-11 | Sweden | Vastmanland | 25994 | 345 | 0 | 25649 | 59.6714 | 16.2159 | 2021-05-12 04:21:29 | Vastmanland, Sweden | ||
2821096 | 2821096 | 2021-05-10 | Sweden | Vastmanland | 25585 | 345 | 0 | 25240 | 59.6714 | 16.2159 | 2021-05-11 04:20:41 | Vastmanland, Sweden | ||
1425428 | 1425428 | 2021-05-09 | Sweden | Vastmanland | 25585 | 345 | 0 | 25240 | 59.6714 | 16.2159 | 2021-05-10 04:20:38 | Vastmanland, Sweden | ||
1552296 | 1552296 | 2021-05-08 | Sweden | Vastmanland | 25585 | 345 | 0 | 25240 | 59.6714 | 16.2159 | 2021-05-09 04:20:35 | Vastmanland, Sweden | ||
2502354 | 2502354 | 2021-05-07 | Sweden | Vastmanland | 25585 | 345 | 0 | 25240 | 59.6714 | 16.2159 | 2021-05-08 04:21:04 | Vastmanland, Sweden | ||
3113810 | 3113810 | 2021-05-06 | Sweden | Vastmanland | 25448 | 343 | 0 | 25105 | 59.6714 | 16.2159 | 2021-05-07 04:20:40 | Vastmanland, Sweden | ||
646277 | 646277 | 2021-05-05 | Sweden | Vastmanland | 25214 | 343 | 0 | 24871 | 59.6714 | 16.2159 | 2021-05-06 04:20:38 | Vastmanland, Sweden | ||
3675977 | 3675977 | 2021-05-04 | Sweden | Vastmanland | 24947 | 343 | 0 | 24604 | 59.6714 | 16.2159 | 2021-05-05 04:20:43 | Vastmanland, Sweden | ||
2761244 | 2761244 | 2021-05-03 | Sweden | Vastmanland | 24678 | 343 | 0 | 24335 | 59.6714 | 16.2159 | 2021-05-04 04:20:34 | Vastmanland, Sweden | ||
2451097 | 2451097 | 2021-05-02 | Sweden | Vastmanland | 24678 | 343 | 0 | 24335 | 59.6714 | 16.2159 | 2021-05-03 04:20:39 | Vastmanland, Sweden | ||
2825110 | 2825110 | 2021-05-01 | Sweden | Vastmanland | 24678 | 343 | 0 | 24335 | 59.6714 | 16.2159 | 2021-05-02 04:20:48 | Vastmanland, Sweden | ||
380518 | 380518 | 2021-04-30 | Sweden | Vastmanland | 24678 | 343 | 0 | 24335 | 59.6714 | 16.2159 | 2021-05-01 04:20:47 | Vastmanland, Sweden | ||
1636641 | 1636641 | 2021-04-29 | Sweden | Vastmanland | 24558 | 343 | 0 | 24215 | 59.6714 | 16.2159 | 2021-04-30 04:21:03 | Vastmanland, Sweden | ||
3393720 | 3393720 | 2021-04-28 | Sweden | Vastmanland | 24411 | 343 | 0 | 24068 | 59.6714 | 16.2159 | 2021-04-29 04:20:55 | Vastmanland, Sweden | ||
3702436 | 3702436 | 2021-04-27 | Sweden | Vastmanland | 24214 | 340 | 0 | 23874 | 59.6714 | 16.2159 | 2021-04-28 04:20:32 | Vastmanland, Sweden | ||
888445 | 888445 | 2021-04-26 | Sweden | Vastmanland | 23883 | 340 | 0 | 23543 | 59.6714 | 16.2159 | 2021-04-27 04:20:52 | Vastmanland, Sweden | ||
955190 | 955190 | 2021-04-25 | Sweden | Vastmanland | 23883 | 340 | 0 | 23543 | 59.6714 | 16.2159 | 2021-04-26 04:21:04 | Vastmanland, Sweden | ||
3924337 | 3924337 | 2021-04-24 | Sweden | Vastmanland | 23883 | 340 | 0 | 23543 | 59.6714 | 16.2159 | 2021-04-25 04:20:32 | Vastmanland, Sweden | ||
1409368 | 1409368 | 2021-04-23 | Sweden | Vastmanland | 23883 | 340 | 0 | 23543 | 59.6714 | 16.2159 | 2021-04-24 04:20:38 | Vastmanland, Sweden | ||
1568431 | 1568431 | 2021-04-22 | Sweden | Vastmanland | 23731 | 339 | 0 | 23392 | 59.6714 | 16.2159 | 2021-04-23 04:20:52 | Vastmanland, Sweden | ||
3242652 | 3242652 | 2021-04-21 | Sweden | Vastmanland | 23581 | 339 | 0 | 23242 | 59.6714 | 16.2159 | 2021-04-22 04:20:53 | Vastmanland, Sweden | ||
2021048 | 2021048 | 2021-04-20 | Sweden | Vastmanland | 23371 | 339 | 0 | 23032 | 59.6714 | 16.2159 | 2021-04-21 04:21:14 | Vastmanland, Sweden | ||
2411169 | 2411169 | 2021-04-19 | Sweden | Vastmanland | 22996 | 339 | 0 | 22657 | 59.6714 | 16.2159 | 2021-04-20 04:20:41 | Vastmanland, Sweden | ||
3129846 | 3129846 | 2021-04-18 | Sweden | Vastmanland | 22996 | 339 | 0 | 22657 | 59.6714 | 16.2159 | 2021-04-19 04:20:57 | Vastmanland, Sweden | ||
983274 | 983274 | 2021-04-17 | Sweden | Vastmanland | 22996 | 339 | 0 | 22657 | 59.6714 | 16.2159 | 2021-04-18 04:20:41 | Vastmanland, Sweden | ||
170369 | 170369 | 2021-04-16 | Sweden | Vastmanland | 22996 | 339 | 0 | 22657 | 59.6714 | 16.2159 | 2021-04-17 04:20:40 | Vastmanland, Sweden | ||
2549200 | 2549200 | 2021-04-15 | Sweden | Vastmanland | 22837 | 339 | 0 | 22498 | 59.6714 | 16.2159 | 2021-04-16 04:20:46 | Vastmanland, Sweden | ||
1842270 | 1842270 | 2021-04-14 | Sweden | Vastmanland | 22691 | 339 | 0 | 22352 | 59.6714 | 16.2159 | 2021-04-15 04:20:54 | Vastmanland, Sweden | ||
2572004 | 2572004 | 2021-04-13 | Sweden | Vastmanland | 22490 | 339 | 0 | 22151 | 59.6714 | 16.2159 | 2021-04-14 04:20:41 | Vastmanland, Sweden | ||
36755 | 36755 | 2021-04-12 | Sweden | Vastmanland | 22123 | 338 | 0 | 21785 | 59.6714 | 16.2159 | 2021-04-13 04:20:37 | Vastmanland, Sweden | ||
3883914 | 3883914 | 2021-04-11 | Sweden | Vastmanland | 22123 | 338 | 0 | 21785 | 59.6714 | 16.2159 | 2021-04-12 04:21:00 | Vastmanland, Sweden | ||
2983582 | 2983582 | 2021-04-10 | Sweden | Vastmanland | 22123 | 338 | 0 | 21785 | 59.6714 | 16.2159 | 2021-04-11 04:20:56 | Vastmanland, Sweden | ||
606014 | 606014 | 2021-04-09 | Sweden | Vastmanland | 22123 | 338 | 0 | 21785 | 59.6714 | 16.2159 | 2021-04-10 04:20:59 | Vastmanland, Sweden | ||
2646078 | 2646078 | 2021-04-08 | Sweden | Vastmanland | 21949 | 338 | 0 | 21611 | 59.6714 | 16.2159 | 2021-04-09 04:21:13 | Vastmanland, Sweden | ||
2247720 | 2247720 | 2021-04-07 | Sweden | Vastmanland | 21788 | 338 | 0 | 21450 | 59.6714 | 16.2159 | 2021-04-08 04:21:13 | Vastmanland, Sweden | ||
3003630 | 3003630 | 2021-04-06 | Sweden | Vastmanland | 21518 | 332 | 0 | 21186 | 59.6714 | 16.2159 | 2021-04-07 04:20:53 | Vastmanland, Sweden | ||
3085625 | 3085625 | 2021-04-05 | Sweden | Vastmanland | 21125 | 332 | 0 | 20793 | 59.6714 | 16.2159 | 2021-04-06 04:20:32 | Vastmanland, Sweden | ||
388548 | 388548 | 2021-04-04 | Sweden | Vastmanland | 21125 | 332 | 0 | 20793 | 59.6714 | 16.2159 | 2021-04-05 04:20:35 | Vastmanland, Sweden | ||
3710464 | 3710464 | 2021-04-03 | Sweden | Vastmanland | 21125 | 332 | 0 | 20793 | 59.6714 | 16.2159 | 2021-04-04 04:20:49 | Vastmanland, Sweden | ||
241580 | 241580 | 2021-04-02 | Sweden | Vastmanland | 21125 | 332 | 0 | 20793 | 59.6714 | 16.2159 | 2021-04-03 04:20:44 | Vastmanland, Sweden | ||
1302377 | 1302377 | 2021-04-01 | Sweden | Vastmanland | 21125 | 332 | 0 | 20793 | 59.6714 | 16.2159 | 2021-04-02 04:20:36 | Vastmanland, Sweden | ||
638249 | 638249 | 2021-03-31 | Sweden | Vastmanland | 20948 | 332 | 0 | 20616 | 59.6714 | 16.2159 | 2021-04-01 04:27:05 | Vastmanland, Sweden | ||
3643878 | 3643878 | 2021-03-30 | Sweden | Vastmanland | 20696 | 332 | 0 | 20364 | 59.6714 | 16.2159 | 2021-03-31 04:26:25 | Vastmanland, Sweden | ||
1290331 | 1290331 | 2021-03-29 | Sweden | Vastmanland | 20396 | 332 | 0 | 20064 | 59.6714 | 16.2159 | 2021-03-30 04:26:23 | Vastmanland, Sweden | ||
1536253 | 1536253 | 2021-03-28 | Sweden | Vastmanland | 20396 | 332 | 0 | 20064 | 59.6714 | 16.2159 | 2021-03-29 04:28:35 | Vastmanland, Sweden | ||
1219893 | 1219893 | 2021-03-27 | Sweden | Vastmanland | 20396 | 332 | 0 | 20064 | 59.6714 | 16.2159 | 2021-03-28 05:28:10 | Vastmanland, Sweden | ||
1881311 | 1881311 | 2021-03-26 | Sweden | Vastmanland | 20396 | 332 | 0 | 20064 | 59.6714 | 16.2159 | 2021-03-27 05:25:04 | Vastmanland, Sweden | ||
1980941 | 1980941 | 2021-03-25 | Sweden | Vastmanland | 20260 | 332 | 0 | 19928 | 59.6714 | 16.2159 | 2021-03-26 05:26:55 | Vastmanland, Sweden | ||
2781319 | 2781319 | 2021-03-24 | Sweden | Vastmanland | 20109 | 332 | 0 | 19777 | 59.6714 | 16.2159 | 2021-03-25 05:27:00 | Vastmanland, Sweden | ||
1798964 | 1798964 | 2021-03-23 | Sweden | Vastmanland | 19918 | 332 | 0 | 19586 | 59.6714 | 16.2159 | 2021-03-24 05:25:40 | Vastmanland, Sweden | ||
1204132 | 1204132 | 2021-03-22 | Sweden | Vastmanland | 19669 | 330 | 0 | 19339 | 59.6714 | 16.2159 | 2021-03-23 05:26:18 | Vastmanland, Sweden | ||
3369654 | 3369654 | 2021-03-21 | Sweden | Vastmanland | 19669 | 330 | 0 | 19339 | 59.6714 | 16.2159 | 2021-03-22 05:25:43 | Vastmanland, Sweden | ||
1744864 | 1744864 | 2021-03-20 | Sweden | Vastmanland | 19669 | 330 | 0 | 19339 | 59.6714 | 16.2159 | 2021-03-21 05:25:44 | Vastmanland, Sweden | ||
3421244 | 3421244 | 2021-03-19 | Sweden | Vastmanland | 19669 | 330 | 0 | 19339 | 59.6714 | 16.2159 | 2021-03-20 05:25:46 | Vastmanland, Sweden | ||
3453182 | 3453182 | 2021-03-18 | Sweden | Vastmanland | 19573 | 330 | 0 | 19243 | 59.6714 | 16.2159 | 2021-03-19 05:26:09 | Vastmanland, Sweden | ||
3621406 | 3621406 | 2021-03-17 | Sweden | Vastmanland | 19484 | 330 | 0 | 19154 | 59.6714 | 16.2159 | 2021-03-18 05:26:22 | Vastmanland, Sweden | ||
702730 | 702730 | 2021-03-16 | Sweden | Vastmanland | 19317 | 330 | 0 | 18987 | 59.6714 | 16.2159 | 2021-03-17 05:25:07 | Vastmanland, Sweden | ||
2056208 | 2056208 | 2021-03-15 | Sweden | Vastmanland | 19138 | 330 | 0 | 18808 | 59.6714 | 16.2159 | 2021-03-16 05:25:13 | Vastmanland, Sweden | ||
1732820 | 1732820 | 2021-03-14 | Sweden | Vastmanland | 19138 | 330 | 0 | 18808 | 59.6714 | 16.2159 | 2021-03-15 05:25:51 | Vastmanland, Sweden | ||
1580477 | 1580477 | 2021-03-13 | Sweden | Vastmanland | 19138 | 330 | 0 | 18808 | 59.6714 | 16.2159 | 2021-03-14 05:25:37 | Vastmanland, 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]);