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 = "Gavleborg" 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
- Gavleborg · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884679 | 2884679 | 2021-06-20 | Sweden | Gavleborg | 35814 | 560 | 0 | 35254 | 61.3012 | 16.1534 | 2021-06-21 04:21:41 | Gavleborg, Sweden | ||
107762 | 107762 | 2021-06-19 | Sweden | Gavleborg | 35814 | 560 | 0 | 35254 | 61.3012 | 16.1534 | 2021-06-20 04:21:48 | Gavleborg, Sweden | ||
1125905 | 1125905 | 2021-06-18 | Sweden | Gavleborg | 35814 | 560 | 0 | 35254 | 61.3012 | 16.1534 | 2021-06-19 04:22:33 | Gavleborg, Sweden | ||
2911483 | 2911483 | 2021-06-17 | Sweden | Gavleborg | 35814 | 560 | 0 | 35254 | 61.3012 | 16.1534 | 2021-06-18 04:22:16 | Gavleborg, Sweden | ||
3030599 | 3030599 | 2021-06-16 | Sweden | Gavleborg | 35814 | 560 | 0 | 35254 | 61.3012 | 16.1534 | 2021-06-17 04:22:36 | Gavleborg, Sweden | ||
2339705 | 2339705 | 2021-06-15 | Sweden | Gavleborg | 35814 | 560 | 0 | 35254 | 61.3012 | 16.1534 | 2021-06-16 04:22:32 | Gavleborg, Sweden | ||
1564401 | 1564401 | 2021-06-14 | Sweden | Gavleborg | 35802 | 560 | 0 | 35242 | 61.3012 | 16.1534 | 2021-06-15 04:22:22 | Gavleborg, Sweden | ||
3381684 | 3381684 | 2021-06-13 | Sweden | Gavleborg | 35802 | 560 | 0 | 35242 | 61.3012 | 16.1534 | 2021-06-14 04:22:46 | Gavleborg, Sweden | ||
1736818 | 1736818 | 2021-06-12 | Sweden | Gavleborg | 35802 | 560 | 0 | 35242 | 61.3012 | 16.1534 | 2021-06-13 04:22:44 | Gavleborg, Sweden | ||
3970859 | 3970859 | 2021-06-11 | Sweden | Gavleborg | 35802 | 560 | 0 | 35242 | 61.3012 | 16.1534 | 2021-06-12 04:22:22 | Gavleborg, Sweden | ||
2717281 | 2717281 | 2021-06-10 | Sweden | Gavleborg | 35791 | 560 | 0 | 35231 | 61.3012 | 16.1534 | 2021-06-11 04:23:20 | Gavleborg, Sweden | ||
523166 | 523166 | 2021-06-09 | Sweden | Gavleborg | 35779 | 560 | 0 | 35219 | 61.3012 | 16.1534 | 2021-06-10 04:23:17 | Gavleborg, Sweden | ||
3472606 | 3472606 | 2021-06-08 | Sweden | Gavleborg | 35748 | 559 | 0 | 35189 | 61.3012 | 16.1534 | 2021-06-09 04:23:31 | Gavleborg, Sweden | ||
3145890 | 3145890 | 2021-06-07 | Sweden | Gavleborg | 35695 | 559 | 0 | 35136 | 61.3012 | 16.1534 | 2021-06-08 04:22:35 | Gavleborg, Sweden | ||
825892 | 825892 | 2021-06-06 | Sweden | Gavleborg | 35695 | 559 | 0 | 35136 | 61.3012 | 16.1534 | 2021-06-07 04:22:51 | Gavleborg, Sweden | ||
2586297 | 2586297 | 2021-06-05 | Sweden | Gavleborg | 35695 | 559 | 0 | 35136 | 61.3012 | 16.1534 | 2021-06-06 04:24:03 | Gavleborg, Sweden | ||
2315611 | 2315611 | 2021-06-04 | Sweden | Gavleborg | 35695 | 559 | 0 | 35136 | 61.3012 | 16.1534 | 2021-06-05 04:23:03 | Gavleborg, Sweden | ||
1448896 | 1448896 | 2021-06-03 | Sweden | Gavleborg | 35674 | 559 | 0 | 35115 | 61.3012 | 16.1534 | 2021-06-04 04:23:37 | Gavleborg, Sweden | ||
1708620 | 1708620 | 2021-06-02 | Sweden | Gavleborg | 35512 | 556 | 0 | 34956 | 61.3012 | 16.1534 | 2021-06-03 04:23:32 | Gavleborg, Sweden | ||
2104438 | 2104438 | 2021-06-01 | Sweden | Gavleborg | 35512 | 556 | 0 | 34956 | 61.3012 | 16.1534 | 2021-06-02 04:24:34 | Gavleborg, Sweden | ||
1189054 | 1189054 | 2021-05-31 | Sweden | Gavleborg | 35512 | 556 | 0 | 34956 | 61.3012 | 16.1534 | 2021-06-01 04:23:09 | Gavleborg, Sweden | ||
3089731 | 3089731 | 2021-05-30 | Sweden | Gavleborg | 35512 | 556 | 0 | 34956 | 61.3012 | 16.1534 | 2021-05-31 03:08:59 | Gavleborg, Sweden | ||
51100 | 51100 | 2021-05-29 | Sweden | Gavleborg | 35512 | 556 | 0 | 34956 | 61.3012 | 16.1534 | 2021-05-30 04:20:55 | Gavleborg, Sweden | ||
20679 | 20679 | 2021-05-28 | Sweden | Gavleborg | 35512 | 556 | 0 | 34956 | 61.3012 | 16.1534 | 2021-05-29 04:20:41 | Gavleborg, Sweden | ||
1807054 | 1807054 | 2021-05-27 | Sweden | Gavleborg | 35512 | 556 | 0 | 34956 | 61.3012 | 16.1534 | 2021-05-28 04:20:36 | Gavleborg, Sweden | ||
1310477 | 1310477 | 2021-05-26 | Sweden | Gavleborg | 35474 | 553 | 0 | 34921 | 61.3012 | 16.1534 | 2021-05-27 04:20:59 | Gavleborg, Sweden | ||
83403 | 83403 | 2021-05-25 | Sweden | Gavleborg | 35401 | 553 | 0 | 34848 | 61.3012 | 16.1534 | 2021-05-26 04:20:35 | Gavleborg, Sweden | ||
1413365 | 1413365 | 2021-05-24 | Sweden | Gavleborg | 35236 | 552 | 0 | 34684 | 61.3012 | 16.1534 | 2021-05-25 04:21:08 | Gavleborg, Sweden | ||
1771651 | 1771651 | 2021-05-23 | Sweden | Gavleborg | 35236 | 552 | 0 | 34684 | 61.3012 | 16.1534 | 2021-05-24 04:20:53 | Gavleborg, Sweden | ||
726806 | 726806 | 2021-05-22 | Sweden | Gavleborg | 35236 | 552 | 0 | 34684 | 61.3012 | 16.1534 | 2021-05-23 04:20:51 | Gavleborg, Sweden | ||
1952821 | 1952821 | 2021-05-21 | Sweden | Gavleborg | 35236 | 552 | 0 | 34684 | 61.3012 | 16.1534 | 2021-05-22 04:20:45 | Gavleborg, Sweden | ||
1913520 | 1913520 | 2021-05-20 | Sweden | Gavleborg | 35168 | 551 | 0 | 34617 | 61.3012 | 16.1534 | 2021-05-21 04:20:43 | Gavleborg, Sweden | ||
2256041 | 2256041 | 2021-05-19 | Sweden | Gavleborg | 35077 | 551 | 0 | 34526 | 61.3012 | 16.1534 | 2021-05-20 04:21:05 | Gavleborg, Sweden | ||
2391079 | 2391079 | 2021-05-18 | Sweden | Gavleborg | 34951 | 550 | 0 | 34401 | 61.3012 | 16.1534 | 2021-05-19 04:20:42 | Gavleborg, Sweden | ||
3574904 | 3574904 | 2021-05-17 | Sweden | Gavleborg | 34706 | 549 | 0 | 34157 | 61.3012 | 16.1534 | 2021-05-18 04:20:33 | Gavleborg, Sweden | ||
2939634 | 2939634 | 2021-05-16 | Sweden | Gavleborg | 34706 | 549 | 0 | 34157 | 61.3012 | 16.1534 | 2021-05-17 04:20:34 | Gavleborg, Sweden | ||
1873264 | 1873264 | 2021-05-15 | Sweden | Gavleborg | 34706 | 549 | 0 | 34157 | 61.3012 | 16.1534 | 2021-05-16 04:20:49 | Gavleborg, Sweden | ||
1082233 | 1082233 | 2021-05-14 | Sweden | Gavleborg | 34706 | 549 | 0 | 34157 | 61.3012 | 16.1534 | 2021-05-15 04:20:58 | Gavleborg, Sweden | ||
3054499 | 3054499 | 2021-05-13 | Sweden | Gavleborg | 34441 | 549 | 0 | 33892 | 61.3012 | 16.1534 | 2021-05-14 04:20:41 | Gavleborg, Sweden | ||
2004969 | 2004969 | 2021-05-12 | Sweden | Gavleborg | 34441 | 549 | 0 | 33892 | 61.3012 | 16.1534 | 2021-05-13 04:20:51 | Gavleborg, Sweden | ||
3954800 | 3954800 | 2021-05-11 | Sweden | Gavleborg | 34260 | 549 | 0 | 33711 | 61.3012 | 16.1534 | 2021-05-12 04:21:29 | Gavleborg, Sweden | ||
2821079 | 2821079 | 2021-05-10 | Sweden | Gavleborg | 33930 | 548 | 0 | 33382 | 61.3012 | 16.1534 | 2021-05-11 04:20:41 | Gavleborg, Sweden | ||
1425411 | 1425411 | 2021-05-09 | Sweden | Gavleborg | 33930 | 548 | 0 | 33382 | 61.3012 | 16.1534 | 2021-05-10 04:20:38 | Gavleborg, Sweden | ||
1552279 | 1552279 | 2021-05-08 | Sweden | Gavleborg | 33930 | 548 | 0 | 33382 | 61.3012 | 16.1534 | 2021-05-09 04:20:35 | Gavleborg, Sweden | ||
2502337 | 2502337 | 2021-05-07 | Sweden | Gavleborg | 33930 | 548 | 0 | 33382 | 61.3012 | 16.1534 | 2021-05-08 04:21:04 | Gavleborg, Sweden | ||
3113793 | 3113793 | 2021-05-06 | Sweden | Gavleborg | 33792 | 546 | 0 | 33246 | 61.3012 | 16.1534 | 2021-05-07 04:20:40 | Gavleborg, Sweden | ||
646260 | 646260 | 2021-05-05 | Sweden | Gavleborg | 33627 | 546 | 0 | 33081 | 61.3012 | 16.1534 | 2021-05-06 04:20:38 | Gavleborg, Sweden | ||
3675960 | 3675960 | 2021-05-04 | Sweden | Gavleborg | 33378 | 544 | 0 | 32834 | 61.3012 | 16.1534 | 2021-05-05 04:20:43 | Gavleborg, Sweden | ||
2761227 | 2761227 | 2021-05-03 | Sweden | Gavleborg | 33107 | 544 | 0 | 32563 | 61.3012 | 16.1534 | 2021-05-04 04:20:34 | Gavleborg, Sweden | ||
2451080 | 2451080 | 2021-05-02 | Sweden | Gavleborg | 33107 | 544 | 0 | 32563 | 61.3012 | 16.1534 | 2021-05-03 04:20:39 | Gavleborg, Sweden | ||
2825093 | 2825093 | 2021-05-01 | Sweden | Gavleborg | 33107 | 544 | 0 | 32563 | 61.3012 | 16.1534 | 2021-05-02 04:20:48 | Gavleborg, Sweden | ||
380501 | 380501 | 2021-04-30 | Sweden | Gavleborg | 33107 | 544 | 0 | 32563 | 61.3012 | 16.1534 | 2021-05-01 04:20:47 | Gavleborg, Sweden | ||
1636624 | 1636624 | 2021-04-29 | Sweden | Gavleborg | 32946 | 543 | 0 | 32403 | 61.3012 | 16.1534 | 2021-04-30 04:21:03 | Gavleborg, Sweden | ||
3393703 | 3393703 | 2021-04-28 | Sweden | Gavleborg | 32801 | 543 | 0 | 32258 | 61.3012 | 16.1534 | 2021-04-29 04:20:55 | Gavleborg, Sweden | ||
3702419 | 3702419 | 2021-04-27 | Sweden | Gavleborg | 32596 | 543 | 0 | 32053 | 61.3012 | 16.1534 | 2021-04-28 04:20:32 | Gavleborg, Sweden | ||
888428 | 888428 | 2021-04-26 | Sweden | Gavleborg | 32223 | 543 | 0 | 31680 | 61.3012 | 16.1534 | 2021-04-27 04:20:52 | Gavleborg, Sweden | ||
955173 | 955173 | 2021-04-25 | Sweden | Gavleborg | 32223 | 543 | 0 | 31680 | 61.3012 | 16.1534 | 2021-04-26 04:21:04 | Gavleborg, Sweden | ||
3924320 | 3924320 | 2021-04-24 | Sweden | Gavleborg | 32223 | 543 | 0 | 31680 | 61.3012 | 16.1534 | 2021-04-25 04:20:32 | Gavleborg, Sweden | ||
1409351 | 1409351 | 2021-04-23 | Sweden | Gavleborg | 32223 | 543 | 0 | 31680 | 61.3012 | 16.1534 | 2021-04-24 04:20:38 | Gavleborg, Sweden | ||
1568414 | 1568414 | 2021-04-22 | Sweden | Gavleborg | 32030 | 540 | 0 | 31490 | 61.3012 | 16.1534 | 2021-04-23 04:20:52 | Gavleborg, Sweden | ||
3242635 | 3242635 | 2021-04-21 | Sweden | Gavleborg | 31855 | 539 | 0 | 31316 | 61.3012 | 16.1534 | 2021-04-22 04:20:53 | Gavleborg, Sweden | ||
2021031 | 2021031 | 2021-04-20 | Sweden | Gavleborg | 31608 | 537 | 0 | 31071 | 61.3012 | 16.1534 | 2021-04-21 04:21:14 | Gavleborg, Sweden | ||
2411152 | 2411152 | 2021-04-19 | Sweden | Gavleborg | 31127 | 537 | 0 | 30590 | 61.3012 | 16.1534 | 2021-04-20 04:20:41 | Gavleborg, Sweden | ||
3129829 | 3129829 | 2021-04-18 | Sweden | Gavleborg | 31127 | 537 | 0 | 30590 | 61.3012 | 16.1534 | 2021-04-19 04:20:57 | Gavleborg, Sweden | ||
983257 | 983257 | 2021-04-17 | Sweden | Gavleborg | 31127 | 537 | 0 | 30590 | 61.3012 | 16.1534 | 2021-04-18 04:20:41 | Gavleborg, Sweden | ||
170352 | 170352 | 2021-04-16 | Sweden | Gavleborg | 31127 | 537 | 0 | 30590 | 61.3012 | 16.1534 | 2021-04-17 04:20:40 | Gavleborg, Sweden | ||
2549183 | 2549183 | 2021-04-15 | Sweden | Gavleborg | 30926 | 536 | 0 | 30390 | 61.3012 | 16.1534 | 2021-04-16 04:20:46 | Gavleborg, Sweden | ||
1842253 | 1842253 | 2021-04-14 | Sweden | Gavleborg | 30725 | 536 | 0 | 30189 | 61.3012 | 16.1534 | 2021-04-15 04:20:54 | Gavleborg, Sweden | ||
2571987 | 2571987 | 2021-04-13 | Sweden | Gavleborg | 30398 | 536 | 0 | 29862 | 61.3012 | 16.1534 | 2021-04-14 04:20:41 | Gavleborg, Sweden | ||
36738 | 36738 | 2021-04-12 | Sweden | Gavleborg | 29814 | 534 | 0 | 29280 | 61.3012 | 16.1534 | 2021-04-13 04:20:37 | Gavleborg, Sweden | ||
3883897 | 3883897 | 2021-04-11 | Sweden | Gavleborg | 29814 | 534 | 0 | 29280 | 61.3012 | 16.1534 | 2021-04-12 04:21:00 | Gavleborg, Sweden | ||
2983565 | 2983565 | 2021-04-10 | Sweden | Gavleborg | 29814 | 534 | 0 | 29280 | 61.3012 | 16.1534 | 2021-04-11 04:20:56 | Gavleborg, Sweden | ||
605997 | 605997 | 2021-04-09 | Sweden | Gavleborg | 29814 | 534 | 0 | 29280 | 61.3012 | 16.1534 | 2021-04-10 04:20:59 | Gavleborg, Sweden | ||
2646061 | 2646061 | 2021-04-08 | Sweden | Gavleborg | 29483 | 532 | 0 | 28951 | 61.3012 | 16.1534 | 2021-04-09 04:21:13 | Gavleborg, Sweden | ||
2247703 | 2247703 | 2021-04-07 | Sweden | Gavleborg | 29162 | 533 | 0 | 28629 | 61.3012 | 16.1534 | 2021-04-08 04:21:13 | Gavleborg, Sweden | ||
3003613 | 3003613 | 2021-04-06 | Sweden | Gavleborg | 28886 | 526 | 0 | 28360 | 61.3012 | 16.1534 | 2021-04-07 04:20:53 | Gavleborg, Sweden | ||
3085608 | 3085608 | 2021-04-05 | Sweden | Gavleborg | 28169 | 525 | 0 | 27644 | 61.3012 | 16.1534 | 2021-04-06 04:20:32 | Gavleborg, Sweden | ||
388531 | 388531 | 2021-04-04 | Sweden | Gavleborg | 28169 | 525 | 0 | 27644 | 61.3012 | 16.1534 | 2021-04-05 04:20:35 | Gavleborg, Sweden | ||
3710447 | 3710447 | 2021-04-03 | Sweden | Gavleborg | 28169 | 525 | 0 | 27644 | 61.3012 | 16.1534 | 2021-04-04 04:20:49 | Gavleborg, Sweden | ||
241563 | 241563 | 2021-04-02 | Sweden | Gavleborg | 28169 | 525 | 0 | 27644 | 61.3012 | 16.1534 | 2021-04-03 04:20:44 | Gavleborg, Sweden | ||
1302360 | 1302360 | 2021-04-01 | Sweden | Gavleborg | 28169 | 525 | 0 | 27644 | 61.3012 | 16.1534 | 2021-04-02 04:20:36 | Gavleborg, Sweden | ||
638232 | 638232 | 2021-03-31 | Sweden | Gavleborg | 27932 | 523 | 0 | 27409 | 61.3012 | 16.1534 | 2021-04-01 04:27:05 | Gavleborg, Sweden | ||
3643861 | 3643861 | 2021-03-30 | Sweden | Gavleborg | 27633 | 521 | 0 | 27112 | 61.3012 | 16.1534 | 2021-03-31 04:26:25 | Gavleborg, Sweden | ||
1290314 | 1290314 | 2021-03-29 | Sweden | Gavleborg | 27019 | 518 | 0 | 26501 | 61.3012 | 16.1534 | 2021-03-30 04:26:23 | Gavleborg, Sweden | ||
1536236 | 1536236 | 2021-03-28 | Sweden | Gavleborg | 27019 | 518 | 0 | 26501 | 61.3012 | 16.1534 | 2021-03-29 04:28:35 | Gavleborg, Sweden | ||
1219876 | 1219876 | 2021-03-27 | Sweden | Gavleborg | 27019 | 518 | 0 | 26501 | 61.3012 | 16.1534 | 2021-03-28 05:28:10 | Gavleborg, Sweden | ||
1881294 | 1881294 | 2021-03-26 | Sweden | Gavleborg | 27019 | 518 | 0 | 26501 | 61.3012 | 16.1534 | 2021-03-27 05:25:04 | Gavleborg, Sweden | ||
1980924 | 1980924 | 2021-03-25 | Sweden | Gavleborg | 26794 | 517 | 0 | 26277 | 61.3012 | 16.1534 | 2021-03-26 05:26:55 | Gavleborg, Sweden | ||
2781302 | 2781302 | 2021-03-24 | Sweden | Gavleborg | 26542 | 517 | 0 | 26025 | 61.3012 | 16.1534 | 2021-03-25 05:27:00 | Gavleborg, Sweden | ||
1798947 | 1798947 | 2021-03-23 | Sweden | Gavleborg | 26237 | 513 | 0 | 25724 | 61.3012 | 16.1534 | 2021-03-24 05:25:40 | Gavleborg, Sweden | ||
1204115 | 1204115 | 2021-03-22 | Sweden | Gavleborg | 25545 | 510 | 0 | 25035 | 61.3012 | 16.1534 | 2021-03-23 05:26:18 | Gavleborg, Sweden | ||
3369637 | 3369637 | 2021-03-21 | Sweden | Gavleborg | 25545 | 510 | 0 | 25035 | 61.3012 | 16.1534 | 2021-03-22 05:25:43 | Gavleborg, Sweden | ||
1744847 | 1744847 | 2021-03-20 | Sweden | Gavleborg | 25545 | 510 | 0 | 25035 | 61.3012 | 16.1534 | 2021-03-21 05:25:44 | Gavleborg, Sweden | ||
3421227 | 3421227 | 2021-03-19 | Sweden | Gavleborg | 25545 | 510 | 0 | 25035 | 61.3012 | 16.1534 | 2021-03-20 05:25:46 | Gavleborg, Sweden | ||
3453165 | 3453165 | 2021-03-18 | Sweden | Gavleborg | 25258 | 509 | 0 | 24749 | 61.3012 | 16.1534 | 2021-03-19 05:26:09 | Gavleborg, Sweden | ||
3621389 | 3621389 | 2021-03-17 | Sweden | Gavleborg | 25045 | 509 | 0 | 24536 | 61.3012 | 16.1534 | 2021-03-18 05:26:22 | Gavleborg, Sweden | ||
702713 | 702713 | 2021-03-16 | Sweden | Gavleborg | 24745 | 508 | 0 | 24237 | 61.3012 | 16.1534 | 2021-03-17 05:25:07 | Gavleborg, Sweden | ||
2056191 | 2056191 | 2021-03-15 | Sweden | Gavleborg | 24119 | 503 | 0 | 23616 | 61.3012 | 16.1534 | 2021-03-16 05:25:13 | Gavleborg, Sweden | ||
1732803 | 1732803 | 2021-03-14 | Sweden | Gavleborg | 24119 | 503 | 0 | 23616 | 61.3012 | 16.1534 | 2021-03-15 05:25:51 | Gavleborg, Sweden | ||
1580460 | 1580460 | 2021-03-13 | Sweden | Gavleborg | 24119 | 503 | 0 | 23616 | 61.3012 | 16.1534 | 2021-03-14 05:25:37 | Gavleborg, 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]);