johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
646 rows where confirmed = 459 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 600
- Japan 12
- Australia 7
- China 6
- India 3
- Ukraine 3
- Papua New Guinea 2
- Bosnia and Herzegovina 1
- Colombia 1
- Congo (Kinshasa) 1
- France 1
- Italy 1
- Jordan 1
- Malaysia 1
- Mexico 1
- Netherlands 1
- Russia 1
- Venezuela 1
- Vietnam 1
- Winter Olympics 2022 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2162273 | 2162273 | 2022-10-16 | US | Puerto Rico | Culebra | 72049 | 459 | 0 | 0 | 18.31586 | -65.28813 | 2022-10-17 04:20:31 | Culebra, Puerto Rico, US | |
3997996 | 3997996 | 2022-09-27 | US | Virginia | Highland | 51091 | 459 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-09-28 04:23:01 | Highland, Virginia, US | |
2772324 | 2772324 | 2022-09-26 | US | Virginia | Highland | 51091 | 459 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-09-27 04:23:01 | Highland, Virginia, US | |
373553 | 373553 | 2022-09-13 | US | Kansas | Stanton | 20187 | 459 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-09-14 04:20:44 | Stanton, Kansas, US | |
2396155 | 2396155 | 2022-09-12 | US | Kansas | Stanton | 20187 | 459 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-09-13 04:20:57 | Stanton, Kansas, US | |
3767233 | 3767233 | 2022-09-11 | US | Kansas | Stanton | 20187 | 459 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-09-12 04:20:58 | Stanton, Kansas, US | |
3825808 | 3825808 | 2022-09-10 | US | Kansas | Stanton | 20187 | 459 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-09-11 04:20:50 | Stanton, Kansas, US | |
964265 | 964265 | 2022-09-09 | US | Kansas | Stanton | 20187 | 459 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-09-10 04:21:10 | Stanton, Kansas, US | |
254667 | 254667 | 2022-09-08 | US | Kansas | Stanton | 20187 | 459 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-09-09 04:21:11 | Stanton, Kansas, US | |
3746465 | 3746465 | 2022-09-07 | US | Kansas | Stanton | 20187 | 459 | 9 | 0 | 37.56304714 | -101.7843534 | 2022-09-08 04:21:02 | Stanton, Kansas, US | |
3775207 | 3775207 | 2022-08-30 | US | Kansas | Hodgeman | 20083 | 459 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-08-31 04:20:57 | Hodgeman, Kansas, US | |
1681803 | 1681803 | 2022-08-29 | US | Kansas | Hodgeman | 20083 | 459 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-08-30 04:21:03 | Hodgeman, Kansas, US | |
1878287 | 1878287 | 2022-08-28 | US | Kansas | Hodgeman | 20083 | 459 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-08-29 04:21:06 | Hodgeman, Kansas, US | |
2097414 | 2097414 | 2022-08-27 | US | Kansas | Hodgeman | 20083 | 459 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-08-28 04:21:02 | Hodgeman, Kansas, US | |
1533229 | 1533229 | 2022-08-26 | US | Kansas | Hodgeman | 20083 | 459 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-08-27 04:20:57 | Hodgeman, Kansas, US | |
2830116 | 2830116 | 2022-08-25 | US | Kansas | Hodgeman | 20083 | 459 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-08-26 04:21:02 | Hodgeman, Kansas, US | |
2324649 | 2324649 | 2022-08-24 | US | Kansas | Hodgeman | 20083 | 459 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-08-25 04:21:13 | Hodgeman, Kansas, US | |
2405226 | 2405226 | 2022-08-21 | US | North Dakota | Burke | 38013 | 459 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-08-22 04:20:38 | Burke, North Dakota, US | |
3800304 | 3800304 | 2022-08-20 | US | North Dakota | Burke | 38013 | 459 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-08-21 04:20:44 | Burke, North Dakota, US | |
2365890 | 2365890 | 2022-08-19 | US | North Dakota | Burke | 38013 | 459 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-08-20 04:21:01 | Burke, North Dakota, US | |
1163561 | 1163561 | 2022-08-18 | US | North Dakota | Burke | 38013 | 459 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-08-19 04:20:54 | Burke, North Dakota, US | |
3952885 | 3952885 | 2022-08-17 | US | North Dakota | Burke | 38013 | 459 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-08-18 04:21:11 | Burke, North Dakota, US | |
3619491 | 3619491 | 2022-08-01 | US | North Dakota | Logan | 38047 | 459 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-08-02 04:20:53 | Logan, North Dakota, US | |
3873971 | 3873971 | 2022-07-31 | US | North Dakota | Logan | 38047 | 459 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-08-01 04:21:03 | Logan, North Dakota, US | |
676725 | 676725 | 2022-07-30 | US | North Dakota | Logan | 38047 | 459 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-07-31 04:21:02 | Logan, North Dakota, US | |
1785924 | 1785924 | 2022-07-29 | US | North Dakota | Logan | 38047 | 459 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-07-30 04:20:42 | Logan, North Dakota, US | |
1068287 | 1068287 | 2022-07-28 | US | North Dakota | Logan | 38047 | 459 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-07-29 04:20:45 | Logan, North Dakota, US | |
2337806 | 2337806 | 2022-07-27 | US | North Dakota | Logan | 38047 | 459 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-07-28 04:20:56 | Logan, North Dakota, US | |
1489996 | 1489996 | 2022-07-26 | US | North Dakota | Logan | 38047 | 459 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-07-27 04:21:04 | Logan, North Dakota, US | |
3400500 | 3400500 | 2022-06-18 | US | Texas | Dickens | 48125 | 459 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-06-19 04:20:51 | Dickens, Texas, US | |
2314377 | 2314377 | 2022-06-17 | US | Texas | Dickens | 48125 | 459 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-06-18 04:21:10 | Dickens, Texas, US | |
561881 | 561881 | 2022-06-16 | US | Texas | Dickens | 48125 | 459 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-06-17 04:20:56 | Dickens, Texas, US | |
2894811 | 2894811 | 2022-04-21 | US | North Dakota | Divide | 38023 | 459 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-22 04:20:45 | Divide, North Dakota, US | |
2309683 | 2309683 | 2022-04-20 | US | North Dakota | Divide | 38023 | 459 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-21 04:20:46 | Divide, North Dakota, US | |
2253822 | 2253822 | 2022-04-19 | US | North Dakota | Divide | 38023 | 459 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-20 04:20:45 | Divide, North Dakota, US | |
1848372 | 1848372 | 2022-04-18 | US | North Dakota | Divide | 38023 | 459 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-19 04:21:00 | Divide, North Dakota, US | |
3419316 | 3419316 | 2022-04-17 | US | North Dakota | Divide | 38023 | 459 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-18 04:21:12 | Divide, North Dakota, US | |
306265 | 306265 | 2022-04-16 | US | North Dakota | Divide | 38023 | 459 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-17 04:20:59 | Divide, North Dakota, US | |
2672210 | 2672210 | 2022-04-15 | US | North Dakota | Divide | 38023 | 459 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-16 04:20:48 | Divide, North Dakota, US | |
1225995 | 1225995 | 2022-04-14 | US | North Dakota | Divide | 38023 | 459 | 4 | 0 | 48.814938700000006 | -103.48736109999999 | 2022-04-15 04:20:57 | Divide, North Dakota, US | |
577912 | 577912 | 2022-02-25 | US | Texas | Edwards | 48137 | 459 | 11 | 0 | 29.98202582 | -100.304252 | 2022-02-26 04:21:12 | Edwards, Texas, US | |
1514488 | 1514488 | 2022-02-24 | US | Texas | Edwards | 48137 | 459 | 11 | 0 | 29.98202582 | -100.304252 | 2022-02-25 04:21:11 | Edwards, Texas, US | |
1060929 | 1060929 | 2022-02-23 | US | Texas | Edwards | 48137 | 459 | 11 | 0 | 29.98202582 | -100.304252 | 2022-02-24 04:21:14 | Edwards, Texas, US | |
2643049 | 2643049 | 2022-02-14 | US | Kansas | Hamilton | 20075 | 459 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-15 04:21:09 | Hamilton, Kansas, US | |
187366 | 187366 | 2022-02-13 | US | Kansas | Hamilton | 20075 | 459 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-14 04:20:51 | Hamilton, Kansas, US | |
317212 | 317212 | 2022-02-12 | US | Kansas | Hamilton | 20075 | 459 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-13 04:21:00 | Hamilton, Kansas, US | |
234538 | 234538 | 2022-02-11 | US | Kansas | Hamilton | 20075 | 459 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-12 04:21:06 | Hamilton, Kansas, US | |
1465380 | 1465380 | 2022-02-10 | US | Kansas | Hamilton | 20075 | 459 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-11 04:21:09 | Hamilton, Kansas, US | |
3075341 | 3075341 | 2022-02-09 | US | Kansas | Hamilton | 20075 | 459 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-10 04:21:14 | Hamilton, Kansas, US | |
1363648 | 1363648 | 2022-02-08 | US | Kansas | Hamilton | 20075 | 459 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-09 04:21:04 | Hamilton, Kansas, US | |
74768 | 74768 | 2022-02-07 | Winter Olympics 2022 | 459 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2022-02-08 04:21:15 | Winter Olympics 2022 | |||
72386 | 72386 | 2022-02-07 | US | Kansas | Hamilton | 20075 | 459 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-08 04:21:15 | Hamilton, Kansas, US | |
981350 | 981350 | 2022-02-01 | US | North Dakota | Golden Valley | 38033 | 459 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-02-02 04:21:09 | Golden Valley, North Dakota, US | |
2660192 | 2660192 | 2022-01-31 | US | North Dakota | Golden Valley | 38033 | 459 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-02-01 04:21:11 | Golden Valley, North Dakota, US | |
1320621 | 1320621 | 2022-01-26 | US | North Dakota | Kidder | 38043 | 459 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-01-27 04:21:19 | Kidder, North Dakota, US | |
1230762 | 1230762 | 2022-01-24 | US | Texas | Knox | 48275 | 459 | 22 | 0 | 33.60519951 | -99.74229059999999 | 2022-01-25 04:21:05 | Knox, Texas, US | |
1961491 | 1961491 | 2022-01-20 | US | Idaho | Custer | 16037 | 459 | 7 | 0 | 44.24186819 | -114.2855494 | 2022-01-21 04:21:09 | Custer, Idaho, US | |
3228455 | 3228455 | 2022-01-19 | US | Montana | Granite | 30039 | 459 | 6 | 0 | 46.40605220000001 | -113.4414186 | 2022-01-20 04:21:07 | Granite, Montana, US | |
3466285 | 3466285 | 2022-01-18 | US | Nebraska | Perkins | 31135 | 459 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-01-19 04:21:23 | Perkins, Nebraska, US | |
3689673 | 3689673 | 2022-01-13 | US | New Mexico | De Baca | 35011 | 459 | 3 | 0 | 34.34274529 | -104.4117842 | 2022-01-14 04:21:54 | De Baca, New Mexico, US | |
2612923 | 2612923 | 2022-01-06 | US | South Dakota | Hand | 46059 | 459 | 8 | 0 | 44.54708407 | -99.00386459 | 2022-01-07 04:22:09 | Hand, South Dakota, US | |
1289115 | 1289115 | 2022-01-04 | US | Texas | Hardeman | 48197 | 459 | 14 | 0 | 34.28944521 | -99.74632408 | 2022-01-05 04:21:59 | Hardeman, Texas, US | |
1703459 | 1703459 | 2022-01-03 | US | Texas | Hardeman | 48197 | 459 | 14 | 0 | 34.28944521 | -99.74632408 | 2022-01-04 04:22:17 | Hardeman, Texas, US | |
3522542 | 3522542 | 2022-01-02 | US | Texas | Hardeman | 48197 | 459 | 14 | 0 | 34.28944521 | -99.74632408 | 2022-01-03 02:22:25 | Hardeman, Texas, US | |
1434623 | 1434623 | 2021-12-28 | US | Nebraska | Cherry | 31031 | 459 | 7 | 0 | 42.54502621 | -101.1244332 | 2021-12-29 03:21:43 | Cherry, Nebraska, US | |
3819612 | 3819612 | 2021-12-23 | US | Texas | Oldham | 48359 | 459 | 6 | 0 | 35.40425596 | -102.6027606 | 2021-12-24 04:21:34 | Oldham, Texas, US | |
1257542 | 1257542 | 2021-12-20 | US | Puerto Rico | Patillas | 72109 | 459 | 0 | 0 | 18.03174 | -66.012242 | 2021-12-21 03:21:27 | Patillas, Puerto Rico, US | |
1257523 | 1257523 | 2021-12-20 | US | Puerto Rico | Jayuya | 72073 | 459 | 0 | 0 | 18.211446 | -66.58878 | 2021-12-21 03:21:27 | Jayuya, Puerto Rico, US | |
2906586 | 2906586 | 2021-12-19 | US | South Dakota | Faulk | 46049 | 459 | 15 | 0 | 45.07082625 | -99.14535601 | 2021-12-20 04:21:43 | Faulk, South Dakota, US | |
1261659 | 1261659 | 2021-12-18 | US | South Dakota | Faulk | 46049 | 459 | 15 | 0 | 45.07082625 | -99.14535601 | 2021-12-19 04:21:11 | Faulk, South Dakota, US | |
2401687 | 2401687 | 2021-12-17 | US | South Dakota | Faulk | 46049 | 459 | 15 | 0 | 45.07082625 | -99.14535601 | 2021-12-18 02:22:20 | Faulk, South Dakota, US | |
1662858 | 1662858 | 2021-12-12 | US | North Dakota | Towner | 38095 | 459 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-12-13 04:22:02 | Towner, North Dakota, US | |
1666874 | 1666874 | 2021-12-11 | US | North Dakota | Towner | 38095 | 459 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-12-12 04:22:12 | Towner, North Dakota, US | |
3658026 | 3658026 | 2021-12-10 | US | North Dakota | Towner | 38095 | 459 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-12-11 04:22:45 | Towner, North Dakota, US | |
1080686 | 1080686 | 2021-12-09 | US | Puerto Rico | Maunabo | 72095 | 459 | 0 | 0 | 18.017889 | -65.922235 | 2021-12-10 04:22:28 | Maunabo, Puerto Rico, US | |
1080357 | 1080357 | 2021-12-09 | US | North Dakota | Towner | 38095 | 459 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-12-10 04:22:28 | Towner, North Dakota, US | |
553535 | 553535 | 2021-12-08 | US | Puerto Rico | Maunabo | 72095 | 459 | 0 | 0 | 18.017889 | -65.922235 | 2021-12-09 04:22:49 | Maunabo, Puerto Rico, US | |
3072929 | 3072929 | 2021-11-23 | US | South Dakota | Potter | 46107 | 459 | 5 | 0 | 45.06583079 | -99.95498503 | 2021-11-24 04:22:14 | Potter, South Dakota, US | |
3072905 | 3072905 | 2021-11-23 | US | South Dakota | Hanson | 46061 | 459 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-11-24 04:22:14 | Hanson, South Dakota, US | |
3343890 | 3343890 | 2021-11-16 | US | Kansas | Cheyenne | 20023 | 459 | 14 | 0 | 39.78580976 | -101.7318201 | 2021-11-17 04:21:48 | Cheyenne, Kansas, US | |
2288726 | 2288726 | 2021-11-15 | US | Kansas | Cheyenne | 20023 | 459 | 14 | 0 | 39.78580976 | -101.7318201 | 2021-11-16 04:21:10 | Cheyenne, Kansas, US | |
3642607 | 3642607 | 2021-11-08 | US | Texas | Collingsworth | 48087 | 459 | 11 | 0 | 34.96489496 | -100.27001109999999 | 2021-11-09 04:21:36 | Collingsworth, Texas, US | |
2003715 | 2003715 | 2021-11-07 | US | Texas | Collingsworth | 48087 | 459 | 11 | 0 | 34.96489496 | -100.27001109999999 | 2021-11-08 04:21:43 | Collingsworth, Texas, US | |
498706 | 498706 | 2021-11-06 | US | Texas | Collingsworth | 48087 | 459 | 11 | 0 | 34.96489496 | -100.27001109999999 | 2021-11-07 04:21:53 | Collingsworth, Texas, US | |
3124561 | 3124561 | 2021-11-05 | US | Texas | Collingsworth | 48087 | 459 | 11 | 0 | 34.96489496 | -100.27001109999999 | 2021-11-06 04:21:51 | Collingsworth, Texas, US | |
3513644 | 3513644 | 2021-11-01 | US | New York | Hamilton | 36041 | 459 | 3 | 0 | 43.66146647 | -74.49721957 | 2021-11-02 04:22:03 | Hamilton, New York, US | |
2124160 | 2124160 | 2021-10-21 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 459 | 0 | 0 | 58.62403337 | -156.21405890000003 | 2021-10-22 04:21:14 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
492924 | 492924 | 2021-10-14 | US | Kansas | Gove | 20063 | 459 | 22 | 0 | 38.91588178 | -100.4829321 | 2021-10-15 04:21:26 | Gove, Kansas, US | |
636328 | 636328 | 2021-10-13 | US | North Dakota | Hettinger | 38041 | 459 | 5 | 0 | 46.43375068 | -102.4632417 | 2021-10-14 04:21:29 | Hettinger, North Dakota, US | |
635212 | 635212 | 2021-10-13 | US | Kansas | Gove | 20063 | 459 | 22 | 0 | 38.91588178 | -100.4829321 | 2021-10-14 04:21:29 | Gove, Kansas, US | |
2959175 | 2959175 | 2021-10-08 | China | Liaoning | 459 | 2 | 0 | 41.2956 | 122.6085 | 2021-10-09 04:21:34 | Liaoning, China | |||
469535 | 469535 | 2021-10-07 | US | Nebraska | Stanton | 31167 | 459 | 11 | 0 | 41.9169835 | -97.19394708 | 2021-10-08 04:21:25 | Stanton, Nebraska, US | |
2460915 | 2460915 | 2021-10-06 | US | Nebraska | Stanton | 31167 | 459 | 11 | 0 | 41.9169835 | -97.19394708 | 2021-10-07 04:21:36 | Stanton, Nebraska, US | |
1275204 | 1275204 | 2021-10-03 | US | Idaho | Adams | 16003 | 459 | 8 | 0 | 44.89333571 | -116.4545247 | 2021-10-04 04:21:31 | Adams, Idaho, US | |
1336869 | 1336869 | 2021-09-28 | US | Oklahoma | Roger Mills | 40129 | 459 | 12 | 0 | 35.68711719 | -99.69666167 | 2021-09-29 04:21:45 | Roger Mills, Oklahoma, US | |
1335631 | 1335631 | 2021-09-28 | US | Kansas | Trego | 20195 | 459 | 8 | 0 | 38.91467218 | -99.87284448 | 2021-09-29 04:21:45 | Trego, Kansas, US | |
1334711 | 1334711 | 2021-09-28 | US | Alaska | Prince of Wales-Hyder | 2198 | 459 | 5 | 0 | 55.76261984 | -133.0511621 | 2021-09-29 04:21:45 | Prince of Wales-Hyder, Alaska, US | |
1238238 | 1238238 | 2021-09-27 | US | Oklahoma | Roger Mills | 40129 | 459 | 12 | 0 | 35.68711719 | -99.69666167 | 2021-09-28 04:21:28 | Roger Mills, Oklahoma, US | |
1237000 | 1237000 | 2021-09-27 | US | Kansas | Trego | 20195 | 459 | 8 | 0 | 38.91467218 | -99.87284448 | 2021-09-28 04:21:28 | Trego, Kansas, US | |
1236080 | 1236080 | 2021-09-27 | US | Alaska | Prince of Wales-Hyder | 2198 | 459 | 5 | 0 | 55.76261984 | -133.0511621 | 2021-09-28 04:21:28 | Prince of Wales-Hyder, Alaska, US |
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]);