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 = "Jonkoping" 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
- Jonkoping · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884683 | 2884683 | 2021-06-20 | Sweden | Jonkoping | 43263 | 554 | 0 | 42709 | 57.3708 | 14.3439 | 2021-06-21 04:21:41 | Jonkoping, Sweden | ||
107766 | 107766 | 2021-06-19 | Sweden | Jonkoping | 43263 | 554 | 0 | 42709 | 57.3708 | 14.3439 | 2021-06-20 04:21:48 | Jonkoping, Sweden | ||
1125909 | 1125909 | 2021-06-18 | Sweden | Jonkoping | 43263 | 554 | 0 | 42709 | 57.3708 | 14.3439 | 2021-06-19 04:22:33 | Jonkoping, Sweden | ||
2911487 | 2911487 | 2021-06-17 | Sweden | Jonkoping | 43263 | 554 | 0 | 42709 | 57.3708 | 14.3439 | 2021-06-18 04:22:16 | Jonkoping, Sweden | ||
3030603 | 3030603 | 2021-06-16 | Sweden | Jonkoping | 43263 | 554 | 0 | 42709 | 57.3708 | 14.3439 | 2021-06-17 04:22:36 | Jonkoping, Sweden | ||
2339709 | 2339709 | 2021-06-15 | Sweden | Jonkoping | 43263 | 554 | 0 | 42709 | 57.3708 | 14.3439 | 2021-06-16 04:22:32 | Jonkoping, Sweden | ||
1564405 | 1564405 | 2021-06-14 | Sweden | Jonkoping | 43205 | 554 | 0 | 42651 | 57.3708 | 14.3439 | 2021-06-15 04:22:22 | Jonkoping, Sweden | ||
3381688 | 3381688 | 2021-06-13 | Sweden | Jonkoping | 43205 | 554 | 0 | 42651 | 57.3708 | 14.3439 | 2021-06-14 04:22:46 | Jonkoping, Sweden | ||
1736822 | 1736822 | 2021-06-12 | Sweden | Jonkoping | 43205 | 554 | 0 | 42651 | 57.3708 | 14.3439 | 2021-06-13 04:22:44 | Jonkoping, Sweden | ||
3970863 | 3970863 | 2021-06-11 | Sweden | Jonkoping | 43205 | 554 | 0 | 42651 | 57.3708 | 14.3439 | 2021-06-12 04:22:22 | Jonkoping, Sweden | ||
2717285 | 2717285 | 2021-06-10 | Sweden | Jonkoping | 43170 | 554 | 0 | 42616 | 57.3708 | 14.3439 | 2021-06-11 04:23:20 | Jonkoping, Sweden | ||
523170 | 523170 | 2021-06-09 | Sweden | Jonkoping | 43128 | 554 | 0 | 42574 | 57.3708 | 14.3439 | 2021-06-10 04:23:17 | Jonkoping, Sweden | ||
3472610 | 3472610 | 2021-06-08 | Sweden | Jonkoping | 43053 | 554 | 0 | 42499 | 57.3708 | 14.3439 | 2021-06-09 04:23:31 | Jonkoping, Sweden | ||
3145894 | 3145894 | 2021-06-07 | Sweden | Jonkoping | 42948 | 554 | 0 | 42394 | 57.3708 | 14.3439 | 2021-06-08 04:22:35 | Jonkoping, Sweden | ||
825896 | 825896 | 2021-06-06 | Sweden | Jonkoping | 42948 | 554 | 0 | 42394 | 57.3708 | 14.3439 | 2021-06-07 04:22:51 | Jonkoping, Sweden | ||
2586301 | 2586301 | 2021-06-05 | Sweden | Jonkoping | 42948 | 554 | 0 | 42394 | 57.3708 | 14.3439 | 2021-06-06 04:24:03 | Jonkoping, Sweden | ||
2315615 | 2315615 | 2021-06-04 | Sweden | Jonkoping | 42948 | 554 | 0 | 42394 | 57.3708 | 14.3439 | 2021-06-05 04:23:03 | Jonkoping, Sweden | ||
1448900 | 1448900 | 2021-06-03 | Sweden | Jonkoping | 42914 | 554 | 0 | 42360 | 57.3708 | 14.3439 | 2021-06-04 04:23:37 | Jonkoping, Sweden | ||
1708624 | 1708624 | 2021-06-02 | Sweden | Jonkoping | 42452 | 553 | 0 | 41899 | 57.3708 | 14.3439 | 2021-06-03 04:23:32 | Jonkoping, Sweden | ||
2104442 | 2104442 | 2021-06-01 | Sweden | Jonkoping | 42452 | 553 | 0 | 41899 | 57.3708 | 14.3439 | 2021-06-02 04:24:34 | Jonkoping, Sweden | ||
1189058 | 1189058 | 2021-05-31 | Sweden | Jonkoping | 42452 | 553 | 0 | 41899 | 57.3708 | 14.3439 | 2021-06-01 04:23:09 | Jonkoping, Sweden | ||
3089735 | 3089735 | 2021-05-30 | Sweden | Jonkoping | 42452 | 553 | 0 | 41899 | 57.3708 | 14.3439 | 2021-05-31 03:08:59 | Jonkoping, Sweden | ||
51104 | 51104 | 2021-05-29 | Sweden | Jonkoping | 42452 | 553 | 0 | 41899 | 57.3708 | 14.3439 | 2021-05-30 04:20:55 | Jonkoping, Sweden | ||
20683 | 20683 | 2021-05-28 | Sweden | Jonkoping | 42452 | 553 | 0 | 41899 | 57.3708 | 14.3439 | 2021-05-29 04:20:41 | Jonkoping, Sweden | ||
1807058 | 1807058 | 2021-05-27 | Sweden | Jonkoping | 42452 | 553 | 0 | 41899 | 57.3708 | 14.3439 | 2021-05-28 04:20:36 | Jonkoping, Sweden | ||
1310481 | 1310481 | 2021-05-26 | Sweden | Jonkoping | 42416 | 552 | 0 | 41864 | 57.3708 | 14.3439 | 2021-05-27 04:20:59 | Jonkoping, Sweden | ||
83407 | 83407 | 2021-05-25 | Sweden | Jonkoping | 42261 | 552 | 0 | 41709 | 57.3708 | 14.3439 | 2021-05-26 04:20:35 | Jonkoping, Sweden | ||
1413369 | 1413369 | 2021-05-24 | Sweden | Jonkoping | 42047 | 552 | 0 | 41495 | 57.3708 | 14.3439 | 2021-05-25 04:21:08 | Jonkoping, Sweden | ||
1771655 | 1771655 | 2021-05-23 | Sweden | Jonkoping | 42047 | 552 | 0 | 41495 | 57.3708 | 14.3439 | 2021-05-24 04:20:53 | Jonkoping, Sweden | ||
726810 | 726810 | 2021-05-22 | Sweden | Jonkoping | 42047 | 552 | 0 | 41495 | 57.3708 | 14.3439 | 2021-05-23 04:20:51 | Jonkoping, Sweden | ||
1952825 | 1952825 | 2021-05-21 | Sweden | Jonkoping | 42047 | 552 | 0 | 41495 | 57.3708 | 14.3439 | 2021-05-22 04:20:45 | Jonkoping, Sweden | ||
1913524 | 1913524 | 2021-05-20 | Sweden | Jonkoping | 41933 | 552 | 0 | 41381 | 57.3708 | 14.3439 | 2021-05-21 04:20:43 | Jonkoping, Sweden | ||
2256045 | 2256045 | 2021-05-19 | Sweden | Jonkoping | 41820 | 552 | 0 | 41268 | 57.3708 | 14.3439 | 2021-05-20 04:21:05 | Jonkoping, Sweden | ||
2391083 | 2391083 | 2021-05-18 | Sweden | Jonkoping | 41588 | 552 | 0 | 41036 | 57.3708 | 14.3439 | 2021-05-19 04:20:42 | Jonkoping, Sweden | ||
3574908 | 3574908 | 2021-05-17 | Sweden | Jonkoping | 41398 | 552 | 0 | 40846 | 57.3708 | 14.3439 | 2021-05-18 04:20:33 | Jonkoping, Sweden | ||
2939638 | 2939638 | 2021-05-16 | Sweden | Jonkoping | 41398 | 552 | 0 | 40846 | 57.3708 | 14.3439 | 2021-05-17 04:20:34 | Jonkoping, Sweden | ||
1873268 | 1873268 | 2021-05-15 | Sweden | Jonkoping | 41398 | 552 | 0 | 40846 | 57.3708 | 14.3439 | 2021-05-16 04:20:49 | Jonkoping, Sweden | ||
1082237 | 1082237 | 2021-05-14 | Sweden | Jonkoping | 41398 | 552 | 0 | 40846 | 57.3708 | 14.3439 | 2021-05-15 04:20:58 | Jonkoping, Sweden | ||
3054503 | 3054503 | 2021-05-13 | Sweden | Jonkoping | 41113 | 552 | 0 | 40561 | 57.3708 | 14.3439 | 2021-05-14 04:20:41 | Jonkoping, Sweden | ||
2004973 | 2004973 | 2021-05-12 | Sweden | Jonkoping | 41113 | 552 | 0 | 40561 | 57.3708 | 14.3439 | 2021-05-13 04:20:51 | Jonkoping, Sweden | ||
3954804 | 3954804 | 2021-05-11 | Sweden | Jonkoping | 40783 | 552 | 0 | 40231 | 57.3708 | 14.3439 | 2021-05-12 04:21:29 | Jonkoping, Sweden | ||
2821083 | 2821083 | 2021-05-10 | Sweden | Jonkoping | 40396 | 550 | 0 | 39846 | 57.3708 | 14.3439 | 2021-05-11 04:20:41 | Jonkoping, Sweden | ||
1425415 | 1425415 | 2021-05-09 | Sweden | Jonkoping | 40396 | 550 | 0 | 39846 | 57.3708 | 14.3439 | 2021-05-10 04:20:38 | Jonkoping, Sweden | ||
1552283 | 1552283 | 2021-05-08 | Sweden | Jonkoping | 40396 | 550 | 0 | 39846 | 57.3708 | 14.3439 | 2021-05-09 04:20:35 | Jonkoping, Sweden | ||
2502341 | 2502341 | 2021-05-07 | Sweden | Jonkoping | 40396 | 550 | 0 | 39846 | 57.3708 | 14.3439 | 2021-05-08 04:21:04 | Jonkoping, Sweden | ||
3113797 | 3113797 | 2021-05-06 | Sweden | Jonkoping | 40190 | 549 | 0 | 39641 | 57.3708 | 14.3439 | 2021-05-07 04:20:40 | Jonkoping, Sweden | ||
646264 | 646264 | 2021-05-05 | Sweden | Jonkoping | 39976 | 548 | 0 | 39428 | 57.3708 | 14.3439 | 2021-05-06 04:20:38 | Jonkoping, Sweden | ||
3675964 | 3675964 | 2021-05-04 | Sweden | Jonkoping | 39580 | 548 | 0 | 39032 | 57.3708 | 14.3439 | 2021-05-05 04:20:43 | Jonkoping, Sweden | ||
2761231 | 2761231 | 2021-05-03 | Sweden | Jonkoping | 39170 | 547 | 0 | 38623 | 57.3708 | 14.3439 | 2021-05-04 04:20:34 | Jonkoping, Sweden | ||
2451084 | 2451084 | 2021-05-02 | Sweden | Jonkoping | 39170 | 547 | 0 | 38623 | 57.3708 | 14.3439 | 2021-05-03 04:20:39 | Jonkoping, Sweden | ||
2825097 | 2825097 | 2021-05-01 | Sweden | Jonkoping | 39170 | 547 | 0 | 38623 | 57.3708 | 14.3439 | 2021-05-02 04:20:48 | Jonkoping, Sweden | ||
380505 | 380505 | 2021-04-30 | Sweden | Jonkoping | 39170 | 547 | 0 | 38623 | 57.3708 | 14.3439 | 2021-05-01 04:20:47 | Jonkoping, Sweden | ||
1636628 | 1636628 | 2021-04-29 | Sweden | Jonkoping | 39005 | 546 | 0 | 38459 | 57.3708 | 14.3439 | 2021-04-30 04:21:03 | Jonkoping, Sweden | ||
3393707 | 3393707 | 2021-04-28 | Sweden | Jonkoping | 38761 | 545 | 0 | 38216 | 57.3708 | 14.3439 | 2021-04-29 04:20:55 | Jonkoping, Sweden | ||
3702423 | 3702423 | 2021-04-27 | Sweden | Jonkoping | 38416 | 545 | 0 | 37871 | 57.3708 | 14.3439 | 2021-04-28 04:20:32 | Jonkoping, Sweden | ||
888432 | 888432 | 2021-04-26 | Sweden | Jonkoping | 38026 | 544 | 0 | 37482 | 57.3708 | 14.3439 | 2021-04-27 04:20:52 | Jonkoping, Sweden | ||
955177 | 955177 | 2021-04-25 | Sweden | Jonkoping | 38026 | 544 | 0 | 37482 | 57.3708 | 14.3439 | 2021-04-26 04:21:04 | Jonkoping, Sweden | ||
3924324 | 3924324 | 2021-04-24 | Sweden | Jonkoping | 38026 | 544 | 0 | 37482 | 57.3708 | 14.3439 | 2021-04-25 04:20:32 | Jonkoping, Sweden | ||
1409355 | 1409355 | 2021-04-23 | Sweden | Jonkoping | 38026 | 544 | 0 | 37482 | 57.3708 | 14.3439 | 2021-04-24 04:20:38 | Jonkoping, Sweden | ||
1568418 | 1568418 | 2021-04-22 | Sweden | Jonkoping | 37825 | 544 | 0 | 37281 | 57.3708 | 14.3439 | 2021-04-23 04:20:52 | Jonkoping, Sweden | ||
3242639 | 3242639 | 2021-04-21 | Sweden | Jonkoping | 37630 | 544 | 0 | 37086 | 57.3708 | 14.3439 | 2021-04-22 04:20:53 | Jonkoping, Sweden | ||
2021035 | 2021035 | 2021-04-20 | Sweden | Jonkoping | 37309 | 544 | 0 | 36765 | 57.3708 | 14.3439 | 2021-04-21 04:21:14 | Jonkoping, Sweden | ||
2411156 | 2411156 | 2021-04-19 | Sweden | Jonkoping | 36848 | 542 | 0 | 36306 | 57.3708 | 14.3439 | 2021-04-20 04:20:41 | Jonkoping, Sweden | ||
3129833 | 3129833 | 2021-04-18 | Sweden | Jonkoping | 36848 | 542 | 0 | 36306 | 57.3708 | 14.3439 | 2021-04-19 04:20:57 | Jonkoping, Sweden | ||
983261 | 983261 | 2021-04-17 | Sweden | Jonkoping | 36848 | 542 | 0 | 36306 | 57.3708 | 14.3439 | 2021-04-18 04:20:41 | Jonkoping, Sweden | ||
170356 | 170356 | 2021-04-16 | Sweden | Jonkoping | 36848 | 542 | 0 | 36306 | 57.3708 | 14.3439 | 2021-04-17 04:20:40 | Jonkoping, Sweden | ||
2549187 | 2549187 | 2021-04-15 | Sweden | Jonkoping | 36638 | 542 | 0 | 36096 | 57.3708 | 14.3439 | 2021-04-16 04:20:46 | Jonkoping, Sweden | ||
1842257 | 1842257 | 2021-04-14 | Sweden | Jonkoping | 36399 | 541 | 0 | 35858 | 57.3708 | 14.3439 | 2021-04-15 04:20:54 | Jonkoping, Sweden | ||
2571991 | 2571991 | 2021-04-13 | Sweden | Jonkoping | 35985 | 539 | 0 | 35446 | 57.3708 | 14.3439 | 2021-04-14 04:20:41 | Jonkoping, Sweden | ||
36742 | 36742 | 2021-04-12 | Sweden | Jonkoping | 35454 | 539 | 0 | 34915 | 57.3708 | 14.3439 | 2021-04-13 04:20:37 | Jonkoping, Sweden | ||
3883901 | 3883901 | 2021-04-11 | Sweden | Jonkoping | 35454 | 539 | 0 | 34915 | 57.3708 | 14.3439 | 2021-04-12 04:21:00 | Jonkoping, Sweden | ||
2983569 | 2983569 | 2021-04-10 | Sweden | Jonkoping | 35454 | 539 | 0 | 34915 | 57.3708 | 14.3439 | 2021-04-11 04:20:56 | Jonkoping, Sweden | ||
606001 | 606001 | 2021-04-09 | Sweden | Jonkoping | 35454 | 539 | 0 | 34915 | 57.3708 | 14.3439 | 2021-04-10 04:20:59 | Jonkoping, Sweden | ||
2646065 | 2646065 | 2021-04-08 | Sweden | Jonkoping | 35155 | 538 | 0 | 34617 | 57.3708 | 14.3439 | 2021-04-09 04:21:13 | Jonkoping, Sweden | ||
2247707 | 2247707 | 2021-04-07 | Sweden | Jonkoping | 34847 | 537 | 0 | 34310 | 57.3708 | 14.3439 | 2021-04-08 04:21:13 | Jonkoping, Sweden | ||
3003617 | 3003617 | 2021-04-06 | Sweden | Jonkoping | 34365 | 534 | 0 | 33831 | 57.3708 | 14.3439 | 2021-04-07 04:20:53 | Jonkoping, Sweden | ||
3085612 | 3085612 | 2021-04-05 | Sweden | Jonkoping | 33681 | 533 | 0 | 33148 | 57.3708 | 14.3439 | 2021-04-06 04:20:32 | Jonkoping, Sweden | ||
388535 | 388535 | 2021-04-04 | Sweden | Jonkoping | 33681 | 533 | 0 | 33148 | 57.3708 | 14.3439 | 2021-04-05 04:20:35 | Jonkoping, Sweden | ||
3710451 | 3710451 | 2021-04-03 | Sweden | Jonkoping | 33681 | 533 | 0 | 33148 | 57.3708 | 14.3439 | 2021-04-04 04:20:49 | Jonkoping, Sweden | ||
241567 | 241567 | 2021-04-02 | Sweden | Jonkoping | 33681 | 533 | 0 | 33148 | 57.3708 | 14.3439 | 2021-04-03 04:20:44 | Jonkoping, Sweden | ||
1302364 | 1302364 | 2021-04-01 | Sweden | Jonkoping | 33681 | 533 | 0 | 33148 | 57.3708 | 14.3439 | 2021-04-02 04:20:36 | Jonkoping, Sweden | ||
638236 | 638236 | 2021-03-31 | Sweden | Jonkoping | 33356 | 535 | 0 | 32821 | 57.3708 | 14.3439 | 2021-04-01 04:27:05 | Jonkoping, Sweden | ||
3643865 | 3643865 | 2021-03-30 | Sweden | Jonkoping | 32823 | 534 | 0 | 32289 | 57.3708 | 14.3439 | 2021-03-31 04:26:25 | Jonkoping, Sweden | ||
1290318 | 1290318 | 2021-03-29 | Sweden | Jonkoping | 32217 | 537 | 0 | 31680 | 57.3708 | 14.3439 | 2021-03-30 04:26:23 | Jonkoping, Sweden | ||
1536240 | 1536240 | 2021-03-28 | Sweden | Jonkoping | 32217 | 537 | 0 | 31680 | 57.3708 | 14.3439 | 2021-03-29 04:28:35 | Jonkoping, Sweden | ||
1219880 | 1219880 | 2021-03-27 | Sweden | Jonkoping | 32217 | 537 | 0 | 31680 | 57.3708 | 14.3439 | 2021-03-28 05:28:10 | Jonkoping, Sweden | ||
1881298 | 1881298 | 2021-03-26 | Sweden | Jonkoping | 32217 | 537 | 0 | 31680 | 57.3708 | 14.3439 | 2021-03-27 05:25:04 | Jonkoping, Sweden | ||
1980928 | 1980928 | 2021-03-25 | Sweden | Jonkoping | 31945 | 536 | 0 | 31409 | 57.3708 | 14.3439 | 2021-03-26 05:26:55 | Jonkoping, Sweden | ||
2781306 | 2781306 | 2021-03-24 | Sweden | Jonkoping | 31440 | 532 | 0 | 30908 | 57.3708 | 14.3439 | 2021-03-25 05:27:00 | Jonkoping, Sweden | ||
1798951 | 1798951 | 2021-03-23 | Sweden | Jonkoping | 31096 | 531 | 0 | 30565 | 57.3708 | 14.3439 | 2021-03-24 05:25:40 | Jonkoping, Sweden | ||
1204119 | 1204119 | 2021-03-22 | Sweden | Jonkoping | 30459 | 526 | 0 | 29933 | 57.3708 | 14.3439 | 2021-03-23 05:26:18 | Jonkoping, Sweden | ||
3369641 | 3369641 | 2021-03-21 | Sweden | Jonkoping | 30459 | 526 | 0 | 29933 | 57.3708 | 14.3439 | 2021-03-22 05:25:43 | Jonkoping, Sweden | ||
1744851 | 1744851 | 2021-03-20 | Sweden | Jonkoping | 30459 | 526 | 0 | 29933 | 57.3708 | 14.3439 | 2021-03-21 05:25:44 | Jonkoping, Sweden | ||
3421231 | 3421231 | 2021-03-19 | Sweden | Jonkoping | 30459 | 526 | 0 | 29933 | 57.3708 | 14.3439 | 2021-03-20 05:25:46 | Jonkoping, Sweden | ||
3453169 | 3453169 | 2021-03-18 | Sweden | Jonkoping | 30171 | 526 | 0 | 29645 | 57.3708 | 14.3439 | 2021-03-19 05:26:09 | Jonkoping, Sweden | ||
3621393 | 3621393 | 2021-03-17 | Sweden | Jonkoping | 29805 | 526 | 0 | 29279 | 57.3708 | 14.3439 | 2021-03-18 05:26:22 | Jonkoping, Sweden | ||
702717 | 702717 | 2021-03-16 | Sweden | Jonkoping | 29428 | 525 | 0 | 28903 | 57.3708 | 14.3439 | 2021-03-17 05:25:07 | Jonkoping, Sweden | ||
2056195 | 2056195 | 2021-03-15 | Sweden | Jonkoping | 28878 | 525 | 0 | 28353 | 57.3708 | 14.3439 | 2021-03-16 05:25:13 | Jonkoping, Sweden | ||
1732807 | 1732807 | 2021-03-14 | Sweden | Jonkoping | 28878 | 525 | 0 | 28353 | 57.3708 | 14.3439 | 2021-03-15 05:25:51 | Jonkoping, Sweden | ||
1580464 | 1580464 | 2021-03-13 | Sweden | Jonkoping | 28878 | 525 | 0 | 28353 | 57.3708 | 14.3439 | 2021-03-14 05:25:37 | Jonkoping, 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]);