johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
628 rows where recovered = 98 sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- France 422
- Malaysia 53
- Netherlands 44
- Japan 25
- Australia 13
- Colombia 10
- Russia 9
- Barbados 4
- Cameroon 4
- China 4
- Cyprus 4
- Monaco 4
- Chile 3
- Dominica 3
- Saint Vincent and the Grenadines 3
- Bolivia 2
- Cambodia 2
- Mainland China 2
- Mongolia 2
- Saint Kitts and Nevis 2
- Canada 1
- Dominican Republic 1
- Estonia 1
- Fiji 1
- Kenya 1
- Libya 1
- Lithuania 1
- Madagascar 1
- Mozambique 1
- North Macedonia 1
- …
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2974664 | 2974664 | 2020-06-30 | Chile | Unknown | 0 | 0 | 98 | 0 | 2020-07-01 04:33:52 | Unknown, Chile | ||||
197746 | 197746 | 2020-08-31 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-01 04:28:31 | W.P. Putrajaya, Malaysia | ||
339973 | 339973 | 2021-02-03 | Australia | Northern Territory | 99 | 0 | 98 | 1 | -12.4634 | 130.8456 | 2021-02-04 05:22:26 | Northern Territory, Australia | ||
347954 | 347954 | 2020-09-14 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-15 03:22:50 | W.P. Putrajaya, Malaysia | ||
431015 | 431015 | 2020-09-07 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-08 04:28:25 | W.P. Putrajaya, Malaysia | ||
550432 | 550432 | 2020-09-12 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-13 04:30:52 | W.P. Putrajaya, Malaysia | ||
613363 | 613363 | 2020-08-29 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-30 04:28:22 | W.P. Putrajaya, Malaysia | ||
669957 | 669957 | 2020-09-16 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-17 04:22:00 | W.P. Putrajaya, Malaysia | ||
790081 | 790081 | 2021-02-04 | Australia | Northern Territory | 99 | 0 | 98 | 1 | -12.4634 | 130.8456 | 2021-02-05 05:22:38 | Northern Territory, Australia | ||
817255 | 817255 | 2020-09-05 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-06 04:28:33 | W.P. Putrajaya, Malaysia | ||
970577 | 970577 | 2020-09-29 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-30 04:23:33 | W.P. Putrajaya, Malaysia | ||
1049496 | 1049496 | 2020-09-30 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-10-01 04:23:42 | W.P. Putrajaya, Malaysia | ||
1109232 | 1109232 | 2020-09-02 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-03 04:28:22 | W.P. Putrajaya, Malaysia | ||
1125268 | 1125268 | 2020-09-17 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-18 05:05:00 | W.P. Putrajaya, Malaysia | ||
1176862 | 1176862 | 2020-09-10 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-11 04:46:23 | W.P. Putrajaya, Malaysia | ||
1247436 | 1247436 | 2020-09-08 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-09 04:28:48 | W.P. Putrajaya, Malaysia | ||
1357995 | 1357995 | 2020-09-03 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-04 04:28:26 | W.P. Putrajaya, Malaysia | ||
1448261 | 1448261 | 2020-09-11 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-12 04:25:05 | W.P. Putrajaya, Malaysia | ||
1483230 | 1483230 | 2020-08-21 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-22 04:27:49 | W.P. Putrajaya, Malaysia | ||
1519074 | 1519074 | 2020-09-28 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-29 04:23:42 | W.P. Putrajaya, Malaysia | ||
1526858 | 1526858 | 2020-08-28 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-29 04:28:19 | W.P. Putrajaya, Malaysia | ||
2000319 | 2000319 | 2020-08-26 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-27 04:28:15 | W.P. Putrajaya, Malaysia | ||
2063561 | 2063561 | 2020-09-01 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-02 04:28:25 | W.P. Putrajaya, Malaysia | ||
2175227 | 2175227 | 2020-09-09 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-10 04:29:01 | W.P. Putrajaya, Malaysia | ||
2219342 | 2219342 | 2020-08-23 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-24 04:27:56 | W.P. Putrajaya, Malaysia | ||
2303124 | 2303124 | 2020-08-22 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-23 04:27:48 | W.P. Putrajaya, Malaysia | ||
2458450 | 2458450 | 2020-09-19 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-20 04:22:00 | W.P. Putrajaya, Malaysia | ||
2513859 | 2513859 | 2020-08-27 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-28 04:28:11 | W.P. Putrajaya, Malaysia | ||
2585662 | 2585662 | 2020-09-27 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-28 04:23:00 | W.P. Putrajaya, Malaysia | ||
2609706 | 2609706 | 2020-09-24 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-25 04:23:00 | W.P. Putrajaya, Malaysia | ||
2617714 | 2617714 | 2020-09-26 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-27 04:23:00 | W.P. Putrajaya, Malaysia | ||
2657449 | 2657449 | 2020-09-23 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-24 04:23:00 | W.P. Putrajaya, Malaysia | ||
2665455 | 2665455 | 2020-09-04 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-05 04:28:19 | W.P. Putrajaya, Malaysia | ||
2732682 | 2732682 | 2020-09-15 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-16 04:22:53 | W.P. Putrajaya, Malaysia | ||
2816429 | 2816429 | 2020-09-25 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-26 04:23:00 | W.P. Putrajaya, Malaysia | ||
2840497 | 2840497 | 2020-09-21 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-22 04:23:00 | W.P. Putrajaya, Malaysia | ||
2852519 | 2852519 | 2020-09-18 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-19 04:22:00 | W.P. Putrajaya, Malaysia | ||
2872393 | 2872393 | 2020-09-13 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-14 04:26:00 | W.P. Putrajaya, Malaysia | ||
2994947 | 2994947 | 2020-08-24 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-25 04:28:02 | W.P. Putrajaya, Malaysia | ||
3097100 | 3097100 | 2020-09-20 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-21 04:23:00 | W.P. Putrajaya, Malaysia | ||
3165300 | 3165300 | 2020-09-06 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-07 04:28:30 | W.P. Putrajaya, Malaysia | ||
3319898 | 3319898 | 2020-09-22 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-09-23 04:23:00 | W.P. Putrajaya, Malaysia | ||
3566243 | 3566243 | 2020-08-25 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-26 04:28:11 | W.P. Putrajaya, Malaysia | ||
3935701 | 3935701 | 2020-08-30 | Malaysia | W.P. Putrajaya | 99 | 1 | 98 | 0 | 2.9264 | 101.6964 | 2020-08-31 04:28:27 | W.P. Putrajaya, Malaysia | ||
287360 | 287360 | 2020-06-15 | Japan | Shiga | 100 | 1 | 98 | 1 | 35.21582700000001 | 136.13806399999999 | 2020-06-16 04:33:09 | Shiga, Japan | ||
1196034 | 1196034 | 2020-06-17 | Japan | Shiga | 100 | 1 | 98 | 1 | 35.21582700000001 | 136.13806399999999 | 2020-06-18 04:33:18 | Shiga, Japan | ||
1837311 | 1837311 | 2020-06-14 | Japan | Shiga | 100 | 1 | 98 | 1 | 35.21582700000001 | 136.13806399999999 | 2020-06-15 03:33:14 | Shiga, Japan | ||
2386797 | 2386797 | 2020-06-16 | Japan | Shiga | 100 | 1 | 98 | 1 | 35.21582700000001 | 136.13806399999999 | 2020-06-17 04:33:21 | Shiga, Japan | ||
3061363 | 3061363 | 2020-06-13 | Japan | Shiga | 100 | 1 | 98 | 1 | 35.21582700000001 | 136.13806399999999 | 2020-06-14 03:33:15 | Shiga, Japan | ||
217006 | 217006 | 2020-06-08 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-09 03:33:03 | Aruba, Netherlands | ||
286984 | 286984 | 2020-06-15 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-16 04:33:09 | Aruba, Netherlands | ||
573859 | 573859 | 2020-06-06 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-07 03:53:30 | Aruba, Netherlands | ||
737307 | 737307 | 2020-06-12 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-13 03:33:14 | Aruba, Netherlands | ||
805171 | 805171 | 2020-06-01 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-02 02:33:08 | Aruba, Netherlands | ||
1135890 | 1135890 | 2020-06-26 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-27 04:33:35 | Aruba, Netherlands | ||
1136266 | 1136266 | 2020-06-26 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-27 04:33:35 | Shiga, Japan | ||
1195658 | 1195658 | 2020-06-17 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-18 04:33:18 | Aruba, Netherlands | ||
1210579 | 1210579 | 2020-06-09 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-10 04:07:00 | Aruba, Netherlands | ||
1269556 | 1269556 | 2020-06-05 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-06 02:33:00 | Aruba, Netherlands | ||
1273277 | 1273277 | 2020-06-11 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-12 05:09:52 | Aruba, Netherlands | ||
1281037 | 1281037 | 2020-06-04 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-05 02:33:06 | Aruba, Netherlands | ||
1510396 | 1510396 | 2020-06-22 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-23 04:33:22 | Aruba, Netherlands | ||
1510772 | 1510772 | 2020-06-22 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-23 04:33:22 | Shiga, Japan | ||
1522202 | 1522202 | 2020-06-23 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-24 04:33:28 | Aruba, Netherlands | ||
1522578 | 1522578 | 2020-06-23 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-24 04:33:28 | Shiga, Japan | ||
1587874 | 1587874 | 2021-02-05 | Australia | Northern Territory | 101 | 0 | 98 | 3 | -12.4634 | 130.8456 | 2021-02-06 05:23:55 | Northern Territory, Australia | ||
1691306 | 1691306 | 2020-06-19 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-20 04:33:19 | Aruba, Netherlands | ||
1691682 | 1691682 | 2020-06-19 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-20 04:33:19 | Shiga, Japan | ||
1790245 | 1790245 | 2020-05-29 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-05-30 02:32:48 | Aruba, Netherlands | ||
1793811 | 1793811 | 2020-05-31 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-01 02:32:46 | Aruba, Netherlands | ||
1836935 | 1836935 | 2020-06-14 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-15 03:33:14 | Aruba, Netherlands | ||
2039609 | 2039609 | 2020-06-27 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-28 04:34:04 | Aruba, Netherlands | ||
2039985 | 2039985 | 2020-06-27 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-28 04:34:04 | Shiga, Japan | ||
2306274 | 2306274 | 2020-06-28 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-29 04:33:44 | Aruba, Netherlands | ||
2386421 | 2386421 | 2020-06-16 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-17 04:33:21 | Aruba, Netherlands | ||
2437728 | 2437728 | 2020-06-20 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-21 04:33:19 | Aruba, Netherlands | ||
2438104 | 2438104 | 2020-06-20 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-21 04:33:19 | Shiga, Japan | ||
2555635 | 2555635 | 2020-06-02 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-03 02:33:13 | Aruba, Netherlands | ||
2624877 | 2624877 | 2020-06-25 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-26 04:33:43 | Aruba, Netherlands | ||
2625253 | 2625253 | 2020-06-25 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-26 04:33:43 | Shiga, Japan | ||
2700517 | 2700517 | 2020-06-24 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-25 05:26:54 | Aruba, Netherlands | ||
2700893 | 2700893 | 2020-06-24 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-25 05:26:54 | Shiga, Japan | ||
2712125 | 2712125 | 2020-05-28 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-05-29 02:32:50 | Aruba, Netherlands | ||
2799803 | 2799803 | 2020-06-07 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-08 03:33:22 | Aruba, Netherlands | ||
2863721 | 2863721 | 2020-06-10 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-11 03:33:41 | Aruba, Netherlands | ||
3060987 | 3060987 | 2020-06-13 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-14 03:33:15 | Aruba, Netherlands | ||
3249135 | 3249135 | 2020-06-21 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-22 04:33:20 | Aruba, Netherlands | ||
3249511 | 3249511 | 2020-06-21 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-22 04:33:20 | Shiga, Japan | ||
3638704 | 3638704 | 2020-05-30 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-05-31 02:32:45 | Aruba, Netherlands | ||
3682455 | 3682455 | 2020-06-18 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-19 04:33:17 | Aruba, Netherlands | ||
3682831 | 3682831 | 2020-06-18 | Japan | Shiga | 101 | 1 | 98 | 2 | 35.21582700000001 | 136.13806399999999 | 2020-06-19 04:33:17 | Shiga, Japan | ||
3866592 | 3866592 | 2020-06-03 | Netherlands | Aruba | 101 | 3 | 98 | 0 | 12.5211 | -69.9683 | 2020-06-04 02:33:14 | Aruba, Netherlands | ||
613386 | 613386 | 2021-02-08 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-09 05:23:30 | Northern Territory, Australia | ||
974616 | 974616 | 2021-02-06 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-07 05:23:00 | Northern Territory, Australia | ||
1527595 | 1527595 | 2021-02-09 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-10 05:22:41 | Northern Territory, Australia | ||
1672155 | 1672155 | 2021-02-07 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-08 05:22:39 | Northern Territory, Australia | ||
2637420 | 2637420 | 2021-02-11 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-12 05:23:29 | Northern Territory, Australia | ||
3539157 | 3539157 | 2021-02-12 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-13 05:22:12 | Northern Territory, Australia | ||
3978275 | 3978275 | 2021-02-10 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-11 05:23:55 | Northern Territory, Australia | ||
302856 | 302856 | 2020-07-01 | Netherlands | Aruba | 103 | 3 | 98 | 2 | 12.5211 | -69.9683 | 2020-07-02 04:33:46 | Aruba, Netherlands |
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]);