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 = "Kronoberg" 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
- Kronoberg · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884685 | 2884685 | 2021-06-20 | Sweden | Kronoberg | 22177 | 318 | 0 | 21859 | 56.7183 | 14.4115 | 2021-06-21 04:21:41 | Kronoberg, Sweden | ||
107768 | 107768 | 2021-06-19 | Sweden | Kronoberg | 22177 | 318 | 0 | 21859 | 56.7183 | 14.4115 | 2021-06-20 04:21:48 | Kronoberg, Sweden | ||
1125911 | 1125911 | 2021-06-18 | Sweden | Kronoberg | 22177 | 318 | 0 | 21859 | 56.7183 | 14.4115 | 2021-06-19 04:22:33 | Kronoberg, Sweden | ||
2911489 | 2911489 | 2021-06-17 | Sweden | Kronoberg | 22177 | 318 | 0 | 21859 | 56.7183 | 14.4115 | 2021-06-18 04:22:16 | Kronoberg, Sweden | ||
3030605 | 3030605 | 2021-06-16 | Sweden | Kronoberg | 22177 | 318 | 0 | 21859 | 56.7183 | 14.4115 | 2021-06-17 04:22:36 | Kronoberg, Sweden | ||
2339711 | 2339711 | 2021-06-15 | Sweden | Kronoberg | 22177 | 318 | 0 | 21859 | 56.7183 | 14.4115 | 2021-06-16 04:22:32 | Kronoberg, Sweden | ||
1564407 | 1564407 | 2021-06-14 | Sweden | Kronoberg | 22123 | 318 | 0 | 21805 | 56.7183 | 14.4115 | 2021-06-15 04:22:22 | Kronoberg, Sweden | ||
3381690 | 3381690 | 2021-06-13 | Sweden | Kronoberg | 22123 | 318 | 0 | 21805 | 56.7183 | 14.4115 | 2021-06-14 04:22:46 | Kronoberg, Sweden | ||
1736824 | 1736824 | 2021-06-12 | Sweden | Kronoberg | 22123 | 318 | 0 | 21805 | 56.7183 | 14.4115 | 2021-06-13 04:22:44 | Kronoberg, Sweden | ||
3970865 | 3970865 | 2021-06-11 | Sweden | Kronoberg | 22123 | 318 | 0 | 21805 | 56.7183 | 14.4115 | 2021-06-12 04:22:22 | Kronoberg, Sweden | ||
2717287 | 2717287 | 2021-06-10 | Sweden | Kronoberg | 22080 | 318 | 0 | 21762 | 56.7183 | 14.4115 | 2021-06-11 04:23:20 | Kronoberg, Sweden | ||
523172 | 523172 | 2021-06-09 | Sweden | Kronoberg | 22050 | 318 | 0 | 21732 | 56.7183 | 14.4115 | 2021-06-10 04:23:17 | Kronoberg, Sweden | ||
3472612 | 3472612 | 2021-06-08 | Sweden | Kronoberg | 22017 | 317 | 0 | 21700 | 56.7183 | 14.4115 | 2021-06-09 04:23:31 | Kronoberg, Sweden | ||
3145896 | 3145896 | 2021-06-07 | Sweden | Kronoberg | 21938 | 316 | 0 | 21622 | 56.7183 | 14.4115 | 2021-06-08 04:22:35 | Kronoberg, Sweden | ||
825898 | 825898 | 2021-06-06 | Sweden | Kronoberg | 21938 | 316 | 0 | 21622 | 56.7183 | 14.4115 | 2021-06-07 04:22:51 | Kronoberg, Sweden | ||
2586303 | 2586303 | 2021-06-05 | Sweden | Kronoberg | 21938 | 316 | 0 | 21622 | 56.7183 | 14.4115 | 2021-06-06 04:24:03 | Kronoberg, Sweden | ||
2315617 | 2315617 | 2021-06-04 | Sweden | Kronoberg | 21938 | 316 | 0 | 21622 | 56.7183 | 14.4115 | 2021-06-05 04:23:03 | Kronoberg, Sweden | ||
1448902 | 1448902 | 2021-06-03 | Sweden | Kronoberg | 21908 | 315 | 0 | 21593 | 56.7183 | 14.4115 | 2021-06-04 04:23:37 | Kronoberg, Sweden | ||
1708626 | 1708626 | 2021-06-02 | Sweden | Kronoberg | 21641 | 313 | 0 | 21328 | 56.7183 | 14.4115 | 2021-06-03 04:23:32 | Kronoberg, Sweden | ||
2104444 | 2104444 | 2021-06-01 | Sweden | Kronoberg | 21641 | 313 | 0 | 21328 | 56.7183 | 14.4115 | 2021-06-02 04:24:34 | Kronoberg, Sweden | ||
1189060 | 1189060 | 2021-05-31 | Sweden | Kronoberg | 21641 | 313 | 0 | 21328 | 56.7183 | 14.4115 | 2021-06-01 04:23:09 | Kronoberg, Sweden | ||
3089737 | 3089737 | 2021-05-30 | Sweden | Kronoberg | 21641 | 313 | 0 | 21328 | 56.7183 | 14.4115 | 2021-05-31 03:08:59 | Kronoberg, Sweden | ||
51106 | 51106 | 2021-05-29 | Sweden | Kronoberg | 21641 | 313 | 0 | 21328 | 56.7183 | 14.4115 | 2021-05-30 04:20:55 | Kronoberg, Sweden | ||
20685 | 20685 | 2021-05-28 | Sweden | Kronoberg | 21641 | 313 | 0 | 21328 | 56.7183 | 14.4115 | 2021-05-29 04:20:41 | Kronoberg, Sweden | ||
1807060 | 1807060 | 2021-05-27 | Sweden | Kronoberg | 21641 | 313 | 0 | 21328 | 56.7183 | 14.4115 | 2021-05-28 04:20:36 | Kronoberg, Sweden | ||
1310483 | 1310483 | 2021-05-26 | Sweden | Kronoberg | 21639 | 313 | 0 | 21326 | 56.7183 | 14.4115 | 2021-05-27 04:20:59 | Kronoberg, Sweden | ||
83409 | 83409 | 2021-05-25 | Sweden | Kronoberg | 21552 | 313 | 0 | 21239 | 56.7183 | 14.4115 | 2021-05-26 04:20:35 | Kronoberg, Sweden | ||
1413371 | 1413371 | 2021-05-24 | Sweden | Kronoberg | 21427 | 312 | 0 | 21115 | 56.7183 | 14.4115 | 2021-05-25 04:21:08 | Kronoberg, Sweden | ||
1771657 | 1771657 | 2021-05-23 | Sweden | Kronoberg | 21427 | 312 | 0 | 21115 | 56.7183 | 14.4115 | 2021-05-24 04:20:53 | Kronoberg, Sweden | ||
726812 | 726812 | 2021-05-22 | Sweden | Kronoberg | 21427 | 312 | 0 | 21115 | 56.7183 | 14.4115 | 2021-05-23 04:20:51 | Kronoberg, Sweden | ||
1952827 | 1952827 | 2021-05-21 | Sweden | Kronoberg | 21427 | 312 | 0 | 21115 | 56.7183 | 14.4115 | 2021-05-22 04:20:45 | Kronoberg, Sweden | ||
1913526 | 1913526 | 2021-05-20 | Sweden | Kronoberg | 21349 | 312 | 0 | 21037 | 56.7183 | 14.4115 | 2021-05-21 04:20:43 | Kronoberg, Sweden | ||
2256047 | 2256047 | 2021-05-19 | Sweden | Kronoberg | 21261 | 312 | 0 | 20949 | 56.7183 | 14.4115 | 2021-05-20 04:21:05 | Kronoberg, Sweden | ||
2391085 | 2391085 | 2021-05-18 | Sweden | Kronoberg | 21117 | 312 | 0 | 20805 | 56.7183 | 14.4115 | 2021-05-19 04:20:42 | Kronoberg, Sweden | ||
3574910 | 3574910 | 2021-05-17 | Sweden | Kronoberg | 20919 | 311 | 0 | 20608 | 56.7183 | 14.4115 | 2021-05-18 04:20:33 | Kronoberg, Sweden | ||
2939640 | 2939640 | 2021-05-16 | Sweden | Kronoberg | 20919 | 311 | 0 | 20608 | 56.7183 | 14.4115 | 2021-05-17 04:20:34 | Kronoberg, Sweden | ||
1873270 | 1873270 | 2021-05-15 | Sweden | Kronoberg | 20919 | 311 | 0 | 20608 | 56.7183 | 14.4115 | 2021-05-16 04:20:49 | Kronoberg, Sweden | ||
1082239 | 1082239 | 2021-05-14 | Sweden | Kronoberg | 20919 | 311 | 0 | 20608 | 56.7183 | 14.4115 | 2021-05-15 04:20:58 | Kronoberg, Sweden | ||
3054505 | 3054505 | 2021-05-13 | Sweden | Kronoberg | 20586 | 311 | 0 | 20275 | 56.7183 | 14.4115 | 2021-05-14 04:20:41 | Kronoberg, Sweden | ||
2004975 | 2004975 | 2021-05-12 | Sweden | Kronoberg | 20586 | 311 | 0 | 20275 | 56.7183 | 14.4115 | 2021-05-13 04:20:51 | Kronoberg, Sweden | ||
3954806 | 3954806 | 2021-05-11 | Sweden | Kronoberg | 20297 | 310 | 0 | 19987 | 56.7183 | 14.4115 | 2021-05-12 04:21:29 | Kronoberg, Sweden | ||
2821085 | 2821085 | 2021-05-10 | Sweden | Kronoberg | 19915 | 308 | 0 | 19607 | 56.7183 | 14.4115 | 2021-05-11 04:20:41 | Kronoberg, Sweden | ||
1425417 | 1425417 | 2021-05-09 | Sweden | Kronoberg | 19915 | 308 | 0 | 19607 | 56.7183 | 14.4115 | 2021-05-10 04:20:38 | Kronoberg, Sweden | ||
1552285 | 1552285 | 2021-05-08 | Sweden | Kronoberg | 19915 | 308 | 0 | 19607 | 56.7183 | 14.4115 | 2021-05-09 04:20:35 | Kronoberg, Sweden | ||
2502343 | 2502343 | 2021-05-07 | Sweden | Kronoberg | 19915 | 308 | 0 | 19607 | 56.7183 | 14.4115 | 2021-05-08 04:21:04 | Kronoberg, Sweden | ||
3113799 | 3113799 | 2021-05-06 | Sweden | Kronoberg | 19716 | 307 | 0 | 19409 | 56.7183 | 14.4115 | 2021-05-07 04:20:40 | Kronoberg, Sweden | ||
646266 | 646266 | 2021-05-05 | Sweden | Kronoberg | 19500 | 307 | 0 | 19193 | 56.7183 | 14.4115 | 2021-05-06 04:20:38 | Kronoberg, Sweden | ||
3675966 | 3675966 | 2021-05-04 | Sweden | Kronoberg | 19211 | 307 | 0 | 18904 | 56.7183 | 14.4115 | 2021-05-05 04:20:43 | Kronoberg, Sweden | ||
2761233 | 2761233 | 2021-05-03 | Sweden | Kronoberg | 18839 | 303 | 0 | 18536 | 56.7183 | 14.4115 | 2021-05-04 04:20:34 | Kronoberg, Sweden | ||
2451086 | 2451086 | 2021-05-02 | Sweden | Kronoberg | 18839 | 303 | 0 | 18536 | 56.7183 | 14.4115 | 2021-05-03 04:20:39 | Kronoberg, Sweden | ||
2825099 | 2825099 | 2021-05-01 | Sweden | Kronoberg | 18839 | 303 | 0 | 18536 | 56.7183 | 14.4115 | 2021-05-02 04:20:48 | Kronoberg, Sweden | ||
380507 | 380507 | 2021-04-30 | Sweden | Kronoberg | 18839 | 303 | 0 | 18536 | 56.7183 | 14.4115 | 2021-05-01 04:20:47 | Kronoberg, Sweden | ||
1636630 | 1636630 | 2021-04-29 | Sweden | Kronoberg | 18655 | 302 | 0 | 18353 | 56.7183 | 14.4115 | 2021-04-30 04:21:03 | Kronoberg, Sweden | ||
3393709 | 3393709 | 2021-04-28 | Sweden | Kronoberg | 18428 | 302 | 0 | 18126 | 56.7183 | 14.4115 | 2021-04-29 04:20:55 | Kronoberg, Sweden | ||
3702425 | 3702425 | 2021-04-27 | Sweden | Kronoberg | 18168 | 302 | 0 | 17866 | 56.7183 | 14.4115 | 2021-04-28 04:20:32 | Kronoberg, Sweden | ||
888434 | 888434 | 2021-04-26 | Sweden | Kronoberg | 17811 | 302 | 0 | 17509 | 56.7183 | 14.4115 | 2021-04-27 04:20:52 | Kronoberg, Sweden | ||
955179 | 955179 | 2021-04-25 | Sweden | Kronoberg | 17811 | 302 | 0 | 17509 | 56.7183 | 14.4115 | 2021-04-26 04:21:04 | Kronoberg, Sweden | ||
3924326 | 3924326 | 2021-04-24 | Sweden | Kronoberg | 17811 | 302 | 0 | 17509 | 56.7183 | 14.4115 | 2021-04-25 04:20:32 | Kronoberg, Sweden | ||
1409357 | 1409357 | 2021-04-23 | Sweden | Kronoberg | 17811 | 302 | 0 | 17509 | 56.7183 | 14.4115 | 2021-04-24 04:20:38 | Kronoberg, Sweden | ||
1568420 | 1568420 | 2021-04-22 | Sweden | Kronoberg | 17628 | 302 | 0 | 17326 | 56.7183 | 14.4115 | 2021-04-23 04:20:52 | Kronoberg, Sweden | ||
3242641 | 3242641 | 2021-04-21 | Sweden | Kronoberg | 17392 | 301 | 0 | 17091 | 56.7183 | 14.4115 | 2021-04-22 04:20:53 | Kronoberg, Sweden | ||
2021037 | 2021037 | 2021-04-20 | Sweden | Kronoberg | 17189 | 301 | 0 | 16888 | 56.7183 | 14.4115 | 2021-04-21 04:21:14 | Kronoberg, Sweden | ||
2411158 | 2411158 | 2021-04-19 | Sweden | Kronoberg | 16875 | 299 | 0 | 16576 | 56.7183 | 14.4115 | 2021-04-20 04:20:41 | Kronoberg, Sweden | ||
3129835 | 3129835 | 2021-04-18 | Sweden | Kronoberg | 16875 | 299 | 0 | 16576 | 56.7183 | 14.4115 | 2021-04-19 04:20:57 | Kronoberg, Sweden | ||
983263 | 983263 | 2021-04-17 | Sweden | Kronoberg | 16875 | 299 | 0 | 16576 | 56.7183 | 14.4115 | 2021-04-18 04:20:41 | Kronoberg, Sweden | ||
170358 | 170358 | 2021-04-16 | Sweden | Kronoberg | 16875 | 299 | 0 | 16576 | 56.7183 | 14.4115 | 2021-04-17 04:20:40 | Kronoberg, Sweden | ||
2549189 | 2549189 | 2021-04-15 | Sweden | Kronoberg | 16720 | 299 | 0 | 16421 | 56.7183 | 14.4115 | 2021-04-16 04:20:46 | Kronoberg, Sweden | ||
1842259 | 1842259 | 2021-04-14 | Sweden | Kronoberg | 16535 | 299 | 0 | 16236 | 56.7183 | 14.4115 | 2021-04-15 04:20:54 | Kronoberg, Sweden | ||
2571993 | 2571993 | 2021-04-13 | Sweden | Kronoberg | 16370 | 299 | 0 | 16071 | 56.7183 | 14.4115 | 2021-04-14 04:20:41 | Kronoberg, Sweden | ||
36744 | 36744 | 2021-04-12 | Sweden | Kronoberg | 16056 | 297 | 0 | 15759 | 56.7183 | 14.4115 | 2021-04-13 04:20:37 | Kronoberg, Sweden | ||
3883903 | 3883903 | 2021-04-11 | Sweden | Kronoberg | 16056 | 297 | 0 | 15759 | 56.7183 | 14.4115 | 2021-04-12 04:21:00 | Kronoberg, Sweden | ||
2983571 | 2983571 | 2021-04-10 | Sweden | Kronoberg | 16056 | 297 | 0 | 15759 | 56.7183 | 14.4115 | 2021-04-11 04:20:56 | Kronoberg, Sweden | ||
606003 | 606003 | 2021-04-09 | Sweden | Kronoberg | 16056 | 297 | 0 | 15759 | 56.7183 | 14.4115 | 2021-04-10 04:20:59 | Kronoberg, Sweden | ||
2646067 | 2646067 | 2021-04-08 | Sweden | Kronoberg | 15892 | 297 | 0 | 15595 | 56.7183 | 14.4115 | 2021-04-09 04:21:13 | Kronoberg, Sweden | ||
2247709 | 2247709 | 2021-04-07 | Sweden | Kronoberg | 15714 | 297 | 0 | 15417 | 56.7183 | 14.4115 | 2021-04-08 04:21:13 | Kronoberg, Sweden | ||
3003619 | 3003619 | 2021-04-06 | Sweden | Kronoberg | 15659 | 297 | 0 | 15362 | 56.7183 | 14.4115 | 2021-04-07 04:20:53 | Kronoberg, Sweden | ||
3085614 | 3085614 | 2021-04-05 | Sweden | Kronoberg | 15435 | 297 | 0 | 15138 | 56.7183 | 14.4115 | 2021-04-06 04:20:32 | Kronoberg, Sweden | ||
388537 | 388537 | 2021-04-04 | Sweden | Kronoberg | 15435 | 297 | 0 | 15138 | 56.7183 | 14.4115 | 2021-04-05 04:20:35 | Kronoberg, Sweden | ||
3710453 | 3710453 | 2021-04-03 | Sweden | Kronoberg | 15435 | 297 | 0 | 15138 | 56.7183 | 14.4115 | 2021-04-04 04:20:49 | Kronoberg, Sweden | ||
241569 | 241569 | 2021-04-02 | Sweden | Kronoberg | 15435 | 297 | 0 | 15138 | 56.7183 | 14.4115 | 2021-04-03 04:20:44 | Kronoberg, Sweden | ||
1302366 | 1302366 | 2021-04-01 | Sweden | Kronoberg | 15435 | 297 | 0 | 15138 | 56.7183 | 14.4115 | 2021-04-02 04:20:36 | Kronoberg, Sweden | ||
638238 | 638238 | 2021-03-31 | Sweden | Kronoberg | 15331 | 297 | 0 | 15034 | 56.7183 | 14.4115 | 2021-04-01 04:27:05 | Kronoberg, Sweden | ||
3643867 | 3643867 | 2021-03-30 | Sweden | Kronoberg | 15208 | 297 | 0 | 14911 | 56.7183 | 14.4115 | 2021-03-31 04:26:25 | Kronoberg, Sweden | ||
1290320 | 1290320 | 2021-03-29 | Sweden | Kronoberg | 15075 | 297 | 0 | 14778 | 56.7183 | 14.4115 | 2021-03-30 04:26:23 | Kronoberg, Sweden | ||
1536242 | 1536242 | 2021-03-28 | Sweden | Kronoberg | 15075 | 297 | 0 | 14778 | 56.7183 | 14.4115 | 2021-03-29 04:28:35 | Kronoberg, Sweden | ||
1219882 | 1219882 | 2021-03-27 | Sweden | Kronoberg | 15075 | 297 | 0 | 14778 | 56.7183 | 14.4115 | 2021-03-28 05:28:10 | Kronoberg, Sweden | ||
1881300 | 1881300 | 2021-03-26 | Sweden | Kronoberg | 15075 | 297 | 0 | 14778 | 56.7183 | 14.4115 | 2021-03-27 05:25:04 | Kronoberg, Sweden | ||
1980930 | 1980930 | 2021-03-25 | Sweden | Kronoberg | 15034 | 297 | 0 | 14737 | 56.7183 | 14.4115 | 2021-03-26 05:26:55 | Kronoberg, Sweden | ||
2781308 | 2781308 | 2021-03-24 | Sweden | Kronoberg | 14962 | 296 | 0 | 14666 | 56.7183 | 14.4115 | 2021-03-25 05:27:00 | Kronoberg, Sweden | ||
1798953 | 1798953 | 2021-03-23 | Sweden | Kronoberg | 14892 | 296 | 0 | 14596 | 56.7183 | 14.4115 | 2021-03-24 05:25:40 | Kronoberg, Sweden | ||
1204121 | 1204121 | 2021-03-22 | Sweden | Kronoberg | 14762 | 296 | 0 | 14466 | 56.7183 | 14.4115 | 2021-03-23 05:26:18 | Kronoberg, Sweden | ||
3369643 | 3369643 | 2021-03-21 | Sweden | Kronoberg | 14762 | 296 | 0 | 14466 | 56.7183 | 14.4115 | 2021-03-22 05:25:43 | Kronoberg, Sweden | ||
1744853 | 1744853 | 2021-03-20 | Sweden | Kronoberg | 14762 | 296 | 0 | 14466 | 56.7183 | 14.4115 | 2021-03-21 05:25:44 | Kronoberg, Sweden | ||
3421233 | 3421233 | 2021-03-19 | Sweden | Kronoberg | 14762 | 296 | 0 | 14466 | 56.7183 | 14.4115 | 2021-03-20 05:25:46 | Kronoberg, Sweden | ||
3453171 | 3453171 | 2021-03-18 | Sweden | Kronoberg | 14707 | 296 | 0 | 14411 | 56.7183 | 14.4115 | 2021-03-19 05:26:09 | Kronoberg, Sweden | ||
3621395 | 3621395 | 2021-03-17 | Sweden | Kronoberg | 14625 | 296 | 0 | 14329 | 56.7183 | 14.4115 | 2021-03-18 05:26:22 | Kronoberg, Sweden | ||
702719 | 702719 | 2021-03-16 | Sweden | Kronoberg | 14557 | 296 | 0 | 14261 | 56.7183 | 14.4115 | 2021-03-17 05:25:07 | Kronoberg, Sweden | ||
2056197 | 2056197 | 2021-03-15 | Sweden | Kronoberg | 14473 | 296 | 0 | 14177 | 56.7183 | 14.4115 | 2021-03-16 05:25:13 | Kronoberg, Sweden | ||
1732809 | 1732809 | 2021-03-14 | Sweden | Kronoberg | 14473 | 296 | 0 | 14177 | 56.7183 | 14.4115 | 2021-03-15 05:25:51 | Kronoberg, Sweden | ||
1580466 | 1580466 | 2021-03-13 | Sweden | Kronoberg | 14473 | 296 | 0 | 14177 | 56.7183 | 14.4115 | 2021-03-14 05:25:37 | Kronoberg, 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]);