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 = "Ostergotland" 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
- Ostergotland · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884688 | 2884688 | 2021-06-20 | Sweden | Ostergotland | 42235 | 633 | 0 | 41602 | 58.3454 | 15.5198 | 2021-06-21 04:21:41 | Ostergotland, Sweden | ||
107771 | 107771 | 2021-06-19 | Sweden | Ostergotland | 42235 | 633 | 0 | 41602 | 58.3454 | 15.5198 | 2021-06-20 04:21:48 | Ostergotland, Sweden | ||
1125914 | 1125914 | 2021-06-18 | Sweden | Ostergotland | 42235 | 633 | 0 | 41602 | 58.3454 | 15.5198 | 2021-06-19 04:22:33 | Ostergotland, Sweden | ||
2911492 | 2911492 | 2021-06-17 | Sweden | Ostergotland | 42235 | 633 | 0 | 41602 | 58.3454 | 15.5198 | 2021-06-18 04:22:16 | Ostergotland, Sweden | ||
3030608 | 3030608 | 2021-06-16 | Sweden | Ostergotland | 42235 | 633 | 0 | 41602 | 58.3454 | 15.5198 | 2021-06-17 04:22:36 | Ostergotland, Sweden | ||
2339714 | 2339714 | 2021-06-15 | Sweden | Ostergotland | 42235 | 633 | 0 | 41602 | 58.3454 | 15.5198 | 2021-06-16 04:22:32 | Ostergotland, Sweden | ||
1564410 | 1564410 | 2021-06-14 | Sweden | Ostergotland | 42186 | 633 | 0 | 41553 | 58.3454 | 15.5198 | 2021-06-15 04:22:22 | Ostergotland, Sweden | ||
3381693 | 3381693 | 2021-06-13 | Sweden | Ostergotland | 42186 | 633 | 0 | 41553 | 58.3454 | 15.5198 | 2021-06-14 04:22:46 | Ostergotland, Sweden | ||
1736827 | 1736827 | 2021-06-12 | Sweden | Ostergotland | 42186 | 633 | 0 | 41553 | 58.3454 | 15.5198 | 2021-06-13 04:22:44 | Ostergotland, Sweden | ||
3970868 | 3970868 | 2021-06-11 | Sweden | Ostergotland | 42186 | 633 | 0 | 41553 | 58.3454 | 15.5198 | 2021-06-12 04:22:22 | Ostergotland, Sweden | ||
2717290 | 2717290 | 2021-06-10 | Sweden | Ostergotland | 42166 | 631 | 0 | 41535 | 58.3454 | 15.5198 | 2021-06-11 04:23:20 | Ostergotland, Sweden | ||
523175 | 523175 | 2021-06-09 | Sweden | Ostergotland | 42132 | 631 | 0 | 41501 | 58.3454 | 15.5198 | 2021-06-10 04:23:17 | Ostergotland, Sweden | ||
3472615 | 3472615 | 2021-06-08 | Sweden | Ostergotland | 42109 | 630 | 0 | 41479 | 58.3454 | 15.5198 | 2021-06-09 04:23:31 | Ostergotland, Sweden | ||
3145899 | 3145899 | 2021-06-07 | Sweden | Ostergotland | 42010 | 630 | 0 | 41380 | 58.3454 | 15.5198 | 2021-06-08 04:22:35 | Ostergotland, Sweden | ||
825901 | 825901 | 2021-06-06 | Sweden | Ostergotland | 42010 | 630 | 0 | 41380 | 58.3454 | 15.5198 | 2021-06-07 04:22:51 | Ostergotland, Sweden | ||
2586306 | 2586306 | 2021-06-05 | Sweden | Ostergotland | 42010 | 630 | 0 | 41380 | 58.3454 | 15.5198 | 2021-06-06 04:24:03 | Ostergotland, Sweden | ||
2315620 | 2315620 | 2021-06-04 | Sweden | Ostergotland | 42010 | 630 | 0 | 41380 | 58.3454 | 15.5198 | 2021-06-05 04:23:03 | Ostergotland, Sweden | ||
1448905 | 1448905 | 2021-06-03 | Sweden | Ostergotland | 41941 | 630 | 0 | 41311 | 58.3454 | 15.5198 | 2021-06-04 04:23:37 | Ostergotland, Sweden | ||
1708629 | 1708629 | 2021-06-02 | Sweden | Ostergotland | 41618 | 629 | 0 | 40989 | 58.3454 | 15.5198 | 2021-06-03 04:23:32 | Ostergotland, Sweden | ||
2104447 | 2104447 | 2021-06-01 | Sweden | Ostergotland | 41618 | 629 | 0 | 40989 | 58.3454 | 15.5198 | 2021-06-02 04:24:34 | Ostergotland, Sweden | ||
1189063 | 1189063 | 2021-05-31 | Sweden | Ostergotland | 41618 | 629 | 0 | 40989 | 58.3454 | 15.5198 | 2021-06-01 04:23:09 | Ostergotland, Sweden | ||
3089740 | 3089740 | 2021-05-30 | Sweden | Ostergotland | 41618 | 629 | 0 | 40989 | 58.3454 | 15.5198 | 2021-05-31 03:08:59 | Ostergotland, Sweden | ||
51109 | 51109 | 2021-05-29 | Sweden | Ostergotland | 41618 | 629 | 0 | 40989 | 58.3454 | 15.5198 | 2021-05-30 04:20:55 | Ostergotland, Sweden | ||
20688 | 20688 | 2021-05-28 | Sweden | Ostergotland | 41618 | 629 | 0 | 40989 | 58.3454 | 15.5198 | 2021-05-29 04:20:41 | Ostergotland, Sweden | ||
1807063 | 1807063 | 2021-05-27 | Sweden | Ostergotland | 41618 | 629 | 0 | 40989 | 58.3454 | 15.5198 | 2021-05-28 04:20:36 | Ostergotland, Sweden | ||
1310486 | 1310486 | 2021-05-26 | Sweden | Ostergotland | 41589 | 628 | 0 | 40961 | 58.3454 | 15.5198 | 2021-05-27 04:20:59 | Ostergotland, Sweden | ||
83412 | 83412 | 2021-05-25 | Sweden | Ostergotland | 41477 | 622 | 0 | 40855 | 58.3454 | 15.5198 | 2021-05-26 04:20:35 | Ostergotland, Sweden | ||
1413374 | 1413374 | 2021-05-24 | Sweden | Ostergotland | 41154 | 621 | 0 | 40533 | 58.3454 | 15.5198 | 2021-05-25 04:21:08 | Ostergotland, Sweden | ||
1771660 | 1771660 | 2021-05-23 | Sweden | Ostergotland | 41154 | 621 | 0 | 40533 | 58.3454 | 15.5198 | 2021-05-24 04:20:53 | Ostergotland, Sweden | ||
726815 | 726815 | 2021-05-22 | Sweden | Ostergotland | 41154 | 621 | 0 | 40533 | 58.3454 | 15.5198 | 2021-05-23 04:20:51 | Ostergotland, Sweden | ||
1952830 | 1952830 | 2021-05-21 | Sweden | Ostergotland | 41154 | 621 | 0 | 40533 | 58.3454 | 15.5198 | 2021-05-22 04:20:45 | Ostergotland, Sweden | ||
1913529 | 1913529 | 2021-05-20 | Sweden | Ostergotland | 41030 | 617 | 0 | 40413 | 58.3454 | 15.5198 | 2021-05-21 04:20:43 | Ostergotland, Sweden | ||
2256050 | 2256050 | 2021-05-19 | Sweden | Ostergotland | 40847 | 617 | 0 | 40230 | 58.3454 | 15.5198 | 2021-05-20 04:21:05 | Ostergotland, Sweden | ||
2391088 | 2391088 | 2021-05-18 | Sweden | Ostergotland | 40731 | 615 | 0 | 40116 | 58.3454 | 15.5198 | 2021-05-19 04:20:42 | Ostergotland, Sweden | ||
3574913 | 3574913 | 2021-05-17 | Sweden | Ostergotland | 40063 | 614 | 0 | 39449 | 58.3454 | 15.5198 | 2021-05-18 04:20:33 | Ostergotland, Sweden | ||
2939643 | 2939643 | 2021-05-16 | Sweden | Ostergotland | 40063 | 614 | 0 | 39449 | 58.3454 | 15.5198 | 2021-05-17 04:20:34 | Ostergotland, Sweden | ||
1873273 | 1873273 | 2021-05-15 | Sweden | Ostergotland | 40063 | 614 | 0 | 39449 | 58.3454 | 15.5198 | 2021-05-16 04:20:49 | Ostergotland, Sweden | ||
1082242 | 1082242 | 2021-05-14 | Sweden | Ostergotland | 40063 | 614 | 0 | 39449 | 58.3454 | 15.5198 | 2021-05-15 04:20:58 | Ostergotland, Sweden | ||
3054508 | 3054508 | 2021-05-13 | Sweden | Ostergotland | 39658 | 614 | 0 | 39044 | 58.3454 | 15.5198 | 2021-05-14 04:20:41 | Ostergotland, Sweden | ||
2004978 | 2004978 | 2021-05-12 | Sweden | Ostergotland | 39658 | 614 | 0 | 39044 | 58.3454 | 15.5198 | 2021-05-13 04:20:51 | Ostergotland, Sweden | ||
3954809 | 3954809 | 2021-05-11 | Sweden | Ostergotland | 39283 | 614 | 0 | 38669 | 58.3454 | 15.5198 | 2021-05-12 04:21:29 | Ostergotland, Sweden | ||
2821088 | 2821088 | 2021-05-10 | Sweden | Ostergotland | 38463 | 613 | 0 | 37850 | 58.3454 | 15.5198 | 2021-05-11 04:20:41 | Ostergotland, Sweden | ||
1425420 | 1425420 | 2021-05-09 | Sweden | Ostergotland | 38463 | 613 | 0 | 37850 | 58.3454 | 15.5198 | 2021-05-10 04:20:38 | Ostergotland, Sweden | ||
1552288 | 1552288 | 2021-05-08 | Sweden | Ostergotland | 38463 | 613 | 0 | 37850 | 58.3454 | 15.5198 | 2021-05-09 04:20:35 | Ostergotland, Sweden | ||
2502346 | 2502346 | 2021-05-07 | Sweden | Ostergotland | 38463 | 613 | 0 | 37850 | 58.3454 | 15.5198 | 2021-05-08 04:21:04 | Ostergotland, Sweden | ||
3113802 | 3113802 | 2021-05-06 | Sweden | Ostergotland | 38121 | 611 | 0 | 37510 | 58.3454 | 15.5198 | 2021-05-07 04:20:40 | Ostergotland, Sweden | ||
646269 | 646269 | 2021-05-05 | Sweden | Ostergotland | 37810 | 611 | 0 | 37199 | 58.3454 | 15.5198 | 2021-05-06 04:20:38 | Ostergotland, Sweden | ||
3675969 | 3675969 | 2021-05-04 | Sweden | Ostergotland | 37515 | 605 | 0 | 36910 | 58.3454 | 15.5198 | 2021-05-05 04:20:43 | Ostergotland, Sweden | ||
2761236 | 2761236 | 2021-05-03 | Sweden | Ostergotland | 36292 | 605 | 0 | 35687 | 58.3454 | 15.5198 | 2021-05-04 04:20:34 | Ostergotland, Sweden | ||
2451089 | 2451089 | 2021-05-02 | Sweden | Ostergotland | 36292 | 605 | 0 | 35687 | 58.3454 | 15.5198 | 2021-05-03 04:20:39 | Ostergotland, Sweden | ||
2825102 | 2825102 | 2021-05-01 | Sweden | Ostergotland | 36292 | 605 | 0 | 35687 | 58.3454 | 15.5198 | 2021-05-02 04:20:48 | Ostergotland, Sweden | ||
380510 | 380510 | 2021-04-30 | Sweden | Ostergotland | 36292 | 605 | 0 | 35687 | 58.3454 | 15.5198 | 2021-05-01 04:20:47 | Ostergotland, Sweden | ||
1636633 | 1636633 | 2021-04-29 | Sweden | Ostergotland | 35971 | 604 | 0 | 35367 | 58.3454 | 15.5198 | 2021-04-30 04:21:03 | Ostergotland, Sweden | ||
3393712 | 3393712 | 2021-04-28 | Sweden | Ostergotland | 35581 | 604 | 0 | 34977 | 58.3454 | 15.5198 | 2021-04-29 04:20:55 | Ostergotland, Sweden | ||
3702428 | 3702428 | 2021-04-27 | Sweden | Ostergotland | 35358 | 599 | 0 | 34759 | 58.3454 | 15.5198 | 2021-04-28 04:20:32 | Ostergotland, Sweden | ||
888437 | 888437 | 2021-04-26 | Sweden | Ostergotland | 34320 | 599 | 0 | 33721 | 58.3454 | 15.5198 | 2021-04-27 04:20:52 | Ostergotland, Sweden | ||
955182 | 955182 | 2021-04-25 | Sweden | Ostergotland | 34320 | 599 | 0 | 33721 | 58.3454 | 15.5198 | 2021-04-26 04:21:04 | Ostergotland, Sweden | ||
3924329 | 3924329 | 2021-04-24 | Sweden | Ostergotland | 34320 | 599 | 0 | 33721 | 58.3454 | 15.5198 | 2021-04-25 04:20:32 | Ostergotland, Sweden | ||
1409360 | 1409360 | 2021-04-23 | Sweden | Ostergotland | 34320 | 599 | 0 | 33721 | 58.3454 | 15.5198 | 2021-04-24 04:20:38 | Ostergotland, Sweden | ||
1568423 | 1568423 | 2021-04-22 | Sweden | Ostergotland | 33944 | 595 | 0 | 33349 | 58.3454 | 15.5198 | 2021-04-23 04:20:52 | Ostergotland, Sweden | ||
3242644 | 3242644 | 2021-04-21 | Sweden | Ostergotland | 33566 | 595 | 0 | 32971 | 58.3454 | 15.5198 | 2021-04-22 04:20:53 | Ostergotland, Sweden | ||
2021040 | 2021040 | 2021-04-20 | Sweden | Ostergotland | 33227 | 594 | 0 | 32633 | 58.3454 | 15.5198 | 2021-04-21 04:21:14 | Ostergotland, Sweden | ||
2411161 | 2411161 | 2021-04-19 | Sweden | Ostergotland | 31885 | 593 | 0 | 31292 | 58.3454 | 15.5198 | 2021-04-20 04:20:41 | Ostergotland, Sweden | ||
3129838 | 3129838 | 2021-04-18 | Sweden | Ostergotland | 31885 | 593 | 0 | 31292 | 58.3454 | 15.5198 | 2021-04-19 04:20:57 | Ostergotland, Sweden | ||
983266 | 983266 | 2021-04-17 | Sweden | Ostergotland | 31885 | 593 | 0 | 31292 | 58.3454 | 15.5198 | 2021-04-18 04:20:41 | Ostergotland, Sweden | ||
170361 | 170361 | 2021-04-16 | Sweden | Ostergotland | 31885 | 593 | 0 | 31292 | 58.3454 | 15.5198 | 2021-04-17 04:20:40 | Ostergotland, Sweden | ||
2549192 | 2549192 | 2021-04-15 | Sweden | Ostergotland | 31501 | 590 | 0 | 30911 | 58.3454 | 15.5198 | 2021-04-16 04:20:46 | Ostergotland, Sweden | ||
1842262 | 1842262 | 2021-04-14 | Sweden | Ostergotland | 31135 | 590 | 0 | 30545 | 58.3454 | 15.5198 | 2021-04-15 04:20:54 | Ostergotland, Sweden | ||
2571996 | 2571996 | 2021-04-13 | Sweden | Ostergotland | 30906 | 584 | 0 | 30322 | 58.3454 | 15.5198 | 2021-04-14 04:20:41 | Ostergotland, Sweden | ||
36747 | 36747 | 2021-04-12 | Sweden | Ostergotland | 30113 | 583 | 0 | 29530 | 58.3454 | 15.5198 | 2021-04-13 04:20:37 | Ostergotland, Sweden | ||
3883906 | 3883906 | 2021-04-11 | Sweden | Ostergotland | 30113 | 583 | 0 | 29530 | 58.3454 | 15.5198 | 2021-04-12 04:21:00 | Ostergotland, Sweden | ||
2983574 | 2983574 | 2021-04-10 | Sweden | Ostergotland | 30113 | 583 | 0 | 29530 | 58.3454 | 15.5198 | 2021-04-11 04:20:56 | Ostergotland, Sweden | ||
606006 | 606006 | 2021-04-09 | Sweden | Ostergotland | 30113 | 583 | 0 | 29530 | 58.3454 | 15.5198 | 2021-04-10 04:20:59 | Ostergotland, Sweden | ||
2646070 | 2646070 | 2021-04-08 | Sweden | Ostergotland | 29913 | 581 | 0 | 29332 | 58.3454 | 15.5198 | 2021-04-09 04:21:13 | Ostergotland, Sweden | ||
2247712 | 2247712 | 2021-04-07 | Sweden | Ostergotland | 29693 | 581 | 0 | 29112 | 58.3454 | 15.5198 | 2021-04-08 04:21:13 | Ostergotland, Sweden | ||
3003622 | 3003622 | 2021-04-06 | Sweden | Ostergotland | 29493 | 578 | 0 | 28915 | 58.3454 | 15.5198 | 2021-04-07 04:20:53 | Ostergotland, Sweden | ||
3085617 | 3085617 | 2021-04-05 | Sweden | Ostergotland | 28385 | 577 | 0 | 27808 | 58.3454 | 15.5198 | 2021-04-06 04:20:32 | Ostergotland, Sweden | ||
388540 | 388540 | 2021-04-04 | Sweden | Ostergotland | 28385 | 577 | 0 | 27808 | 58.3454 | 15.5198 | 2021-04-05 04:20:35 | Ostergotland, Sweden | ||
3710456 | 3710456 | 2021-04-03 | Sweden | Ostergotland | 28385 | 577 | 0 | 27808 | 58.3454 | 15.5198 | 2021-04-04 04:20:49 | Ostergotland, Sweden | ||
241572 | 241572 | 2021-04-02 | Sweden | Ostergotland | 28385 | 577 | 0 | 27808 | 58.3454 | 15.5198 | 2021-04-03 04:20:44 | Ostergotland, Sweden | ||
1302369 | 1302369 | 2021-04-01 | Sweden | Ostergotland | 28385 | 577 | 0 | 27808 | 58.3454 | 15.5198 | 2021-04-02 04:20:36 | Ostergotland, Sweden | ||
638241 | 638241 | 2021-03-31 | Sweden | Ostergotland | 28154 | 576 | 0 | 27578 | 58.3454 | 15.5198 | 2021-04-01 04:27:05 | Ostergotland, Sweden | ||
3643870 | 3643870 | 2021-03-30 | Sweden | Ostergotland | 27933 | 575 | 0 | 27358 | 58.3454 | 15.5198 | 2021-03-31 04:26:25 | Ostergotland, Sweden | ||
1290323 | 1290323 | 2021-03-29 | Sweden | Ostergotland | 27066 | 573 | 0 | 26493 | 58.3454 | 15.5198 | 2021-03-30 04:26:23 | Ostergotland, Sweden | ||
1536245 | 1536245 | 2021-03-28 | Sweden | Ostergotland | 27066 | 573 | 0 | 26493 | 58.3454 | 15.5198 | 2021-03-29 04:28:35 | Ostergotland, Sweden | ||
1219885 | 1219885 | 2021-03-27 | Sweden | Ostergotland | 27066 | 573 | 0 | 26493 | 58.3454 | 15.5198 | 2021-03-28 05:28:10 | Ostergotland, Sweden | ||
1881303 | 1881303 | 2021-03-26 | Sweden | Ostergotland | 27066 | 573 | 0 | 26493 | 58.3454 | 15.5198 | 2021-03-27 05:25:04 | Ostergotland, Sweden | ||
1980933 | 1980933 | 2021-03-25 | Sweden | Ostergotland | 26815 | 573 | 0 | 26242 | 58.3454 | 15.5198 | 2021-03-26 05:26:55 | Ostergotland, Sweden | ||
2781311 | 2781311 | 2021-03-24 | Sweden | Ostergotland | 26688 | 573 | 0 | 26115 | 58.3454 | 15.5198 | 2021-03-25 05:27:00 | Ostergotland, Sweden | ||
1798956 | 1798956 | 2021-03-23 | Sweden | Ostergotland | 26492 | 571 | 0 | 25921 | 58.3454 | 15.5198 | 2021-03-24 05:25:40 | Ostergotland, Sweden | ||
1204124 | 1204124 | 2021-03-22 | Sweden | Ostergotland | 25883 | 572 | 0 | 25311 | 58.3454 | 15.5198 | 2021-03-23 05:26:18 | Ostergotland, Sweden | ||
3369646 | 3369646 | 2021-03-21 | Sweden | Ostergotland | 25883 | 572 | 0 | 25311 | 58.3454 | 15.5198 | 2021-03-22 05:25:43 | Ostergotland, Sweden | ||
1744856 | 1744856 | 2021-03-20 | Sweden | Ostergotland | 25883 | 572 | 0 | 25311 | 58.3454 | 15.5198 | 2021-03-21 05:25:44 | Ostergotland, Sweden | ||
3421236 | 3421236 | 2021-03-19 | Sweden | Ostergotland | 25883 | 572 | 0 | 25311 | 58.3454 | 15.5198 | 2021-03-20 05:25:46 | Ostergotland, Sweden | ||
3453174 | 3453174 | 2021-03-18 | Sweden | Ostergotland | 25677 | 570 | 0 | 25107 | 58.3454 | 15.5198 | 2021-03-19 05:26:09 | Ostergotland, Sweden | ||
3621398 | 3621398 | 2021-03-17 | Sweden | Ostergotland | 25523 | 570 | 0 | 24953 | 58.3454 | 15.5198 | 2021-03-18 05:26:22 | Ostergotland, Sweden | ||
702722 | 702722 | 2021-03-16 | Sweden | Ostergotland | 25327 | 570 | 0 | 24757 | 58.3454 | 15.5198 | 2021-03-17 05:25:07 | Ostergotland, Sweden | ||
2056200 | 2056200 | 2021-03-15 | Sweden | Ostergotland | 24740 | 570 | 0 | 24170 | 58.3454 | 15.5198 | 2021-03-16 05:25:13 | Ostergotland, Sweden | ||
1732812 | 1732812 | 2021-03-14 | Sweden | Ostergotland | 24740 | 570 | 0 | 24170 | 58.3454 | 15.5198 | 2021-03-15 05:25:51 | Ostergotland, Sweden | ||
1580469 | 1580469 | 2021-03-13 | Sweden | Ostergotland | 24740 | 570 | 0 | 24170 | 58.3454 | 15.5198 | 2021-03-14 05:25:37 | Ostergotland, 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]);