johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
414 rows where active = 536 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 338
- Russia 14
- Ukraine 7
- Colombia 6
- Japan 6
- Chile 5
- Equatorial Guinea 3
- Malaysia 3
- Somalia 3
- Barbados 2
- Germany 2
- India 2
- Malta 2
- Armenia 1
- Belize 1
- Burkina Faso 1
- Costa Rica 1
- Cuba 1
- Eswatini 1
- Iceland 1
- Italy 1
- Jordan 1
- Kosovo 1
- Mali 1
- Mexico 1
- Mongolia 1
- Pakistan 1
- Peru 1
- Singapore 1
- Slovakia 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015404 | 3015404 | 2021-08-01 | Kosovo | 108465 | 2269 | 105660 | 536 | 42.602636 | 20.902977 | 2021-08-02 04:21:36 | Kosovo | |||
411919 | 411919 | 2021-07-28 | Ukraine | Donetsk Oblast | 91459 | 2388 | 88535 | 536 | 48.0159 | 37.8028 | 2021-07-29 04:21:33 | Donetsk Oblast, Ukraine | ||
1309779 | 1309779 | 2021-07-27 | Ukraine | Dnipropetrovsk Oblast | 136319 | 4499 | 131284 | 536 | 48.4647 | 35.0462 | 2021-07-28 04:21:39 | Dnipropetrovsk Oblast, Ukraine | ||
3335217 | 3335217 | 2021-07-21 | Malaysia | W.P. Labuan | 9502 | 141 | 8825 | 536 | 5.2831 | 115.2308 | 2021-07-22 04:21:19 | W.P. Labuan, Malaysia | ||
1495936 | 1495936 | 2021-07-03 | Tajikistan | 13975 | 93 | 13346 | 536 | 38.861 | 71.2761 | 2021-07-04 04:21:38 | Tajikistan | |||
562888 | 562888 | 2021-06-22 | Germany | Schleswig-Holstein | 63780 | 1619 | 61640 | 536 | 54.2194 | 9.6961 | 2021-06-23 04:21:46 | Schleswig-Holstein, Germany | ||
2914815 | 2914815 | 2021-06-17 | Ukraine | Zakarpattia Oblast | 62003 | 1600 | 59867 | 536 | 48.6208 | 22.2879 | 2021-06-18 04:22:16 | Zakarpattia Oblast, Ukraine | ||
2339613 | 2339613 | 2021-06-15 | Russia | Kurgan Oblast | 21830 | 431 | 20863 | 536 | 55.7655302 | 64.5632681 | 2021-06-16 04:22:32 | Kurgan Oblast, Russia | ||
1736726 | 1736726 | 2021-06-12 | Russia | Kurgan Oblast | 21740 | 431 | 20773 | 536 | 55.7655302 | 64.5632681 | 2021-06-13 04:22:44 | Kurgan Oblast, Russia | ||
20379 | 20379 | 2021-05-28 | Japan | Gunma | 7763 | 136 | 7091 | 536 | 36.504479 | 138.985605 | 2021-05-29 04:20:41 | Gunma, Japan | ||
1807022 | 1807022 | 2021-05-27 | Singapore | 61940 | 32 | 61372 | 536 | 1.2833 | 103.8333 | 2021-05-28 04:20:36 | Singapore | |||
2004850 | 2004850 | 2021-05-12 | Russia | Bryansk Oblast | 38975 | 311 | 38128 | 536 | 52.8873315 | 33.41585300000001 | 2021-05-13 04:20:51 | Bryansk Oblast, Russia | ||
2760941 | 2760941 | 2021-05-03 | Japan | Mie | 3899 | 87 | 3276 | 536 | 34.508018 | 136.376013 | 2021-05-04 04:20:34 | Mie, Japan | ||
2824969 | 2824969 | 2021-05-01 | Russia | Amur Oblast | 22310 | 281 | 21493 | 536 | 52.8032368 | 128.437295 | 2021-05-02 04:20:48 | Amur Oblast, Russia | ||
3927647 | 3927647 | 2021-04-24 | Ukraine | Sevastopol* | 13932 | 606 | 12790 | 536 | 44.6054 | 33.522 | 2021-04-25 04:20:32 | Sevastopol*, Ukraine | ||
3242537 | 3242537 | 2021-04-21 | Russia | Khanty-Mansi Autonomous Okrug | 55490 | 789 | 54165 | 536 | 61.0259025 | 69.0982628 | 2021-04-22 04:20:53 | Khanty-Mansi Autonomous Okrug, Russia | ||
3242292 | 3242292 | 2021-04-21 | India | Sikkim | 6846 | 136 | 6174 | 536 | 27.571671 | 88.472712 | 2021-04-22 04:20:53 | Sikkim, India | ||
3129731 | 3129731 | 2021-04-18 | Russia | Khanty-Mansi Autonomous Okrug | 55309 | 788 | 53985 | 536 | 61.0259025 | 69.0982628 | 2021-04-19 04:20:57 | Khanty-Mansi Autonomous Okrug, Russia | ||
2552510 | 2552510 | 2021-04-15 | Ukraine | Sevastopol* | 13725 | 587 | 12602 | 536 | 44.6054 | 33.522 | 2021-04-16 04:20:46 | Sevastopol*, Ukraine | ||
2983327 | 2983327 | 2021-04-10 | Malta | 29548 | 402 | 28610 | 536 | 35.9375 | 14.3754 | 2021-04-11 04:20:56 | Malta | |||
2645613 | 2645613 | 2021-04-08 | Colombia | Sucre | 23783 | 872 | 22375 | 536 | 8.814 | -74.7233 | 2021-04-09 04:21:13 | Sucre, Colombia | ||
1536210 | 1536210 | 2021-03-28 | South Sudan | 10098 | 108 | 9454 | 536 | 6.877000000000002 | 31.307 | 2021-03-29 04:28:35 | South Sudan | |||
355960 | 355960 | 2021-03-11 | Yemen | 2667 | 667 | 1464 | 536 | 15.552727 | 48.516388 | 2021-03-12 05:26:50 | Yemen | |||
3962717 | 3962717 | 2021-03-10 | Russia | Irkutsk Oblast | 57752 | 1854 | 55362 | 536 | 56.6370122 | 104.719221 | 2021-03-11 05:25:48 | Irkutsk Oblast, Russia | ||
3962405 | 3962405 | 2021-03-10 | Equatorial Guinea | 6371 | 96 | 5739 | 536 | 1.6508 | 10.2679 | 2021-03-11 05:25:48 | Equatorial Guinea | |||
3663493 | 3663493 | 2021-03-09 | Equatorial Guinea | 6371 | 96 | 5739 | 536 | 1.6508 | 10.2679 | 2021-03-10 05:24:35 | Equatorial Guinea | |||
2359352 | 2359352 | 2021-03-08 | Equatorial Guinea | 6371 | 96 | 5739 | 536 | 1.6508 | 10.2679 | 2021-03-09 05:28:19 | Equatorial Guinea | |||
3669537 | 3669537 | 2021-03-06 | US | Missouri | Linn | 29115 | 548 | 12 | 0 | 536 | 39.87001769 | -93.10704106 | 2021-03-07 05:21:54 | Linn, Missouri, US |
3668242 | 3668242 | 2021-03-06 | US | Colorado | Kit Carson | 8063 | 564 | 11 | 0 | 536 | 39.30497777 | -102.6022199 | 2021-03-07 05:21:54 | Kit Carson, Colorado, US |
1618177 | 1618177 | 2021-03-05 | US | Missouri | Ozark | 29153 | 552 | 16 | 0 | 536 | 36.64916339 | -92.44459066 | 2021-03-06 04:23:41 | Ozark, Missouri, US |
1618158 | 1618158 | 2021-03-05 | US | Missouri | Linn | 29115 | 548 | 12 | 0 | 536 | 39.87001769 | -93.10704106 | 2021-03-06 04:23:41 | Linn, Missouri, US |
2208965 | 2208965 | 2021-03-04 | US | Kansas | Morris | 20127 | 557 | 21 | 0 | 536 | 38.68827511 | -96.65128437 | 2021-03-05 05:26:29 | Morris, Kansas, US |
2208938 | 2208938 | 2021-03-04 | US | Kansas | Greenwood | 20073 | 549 | 13 | 0 | 536 | 37.8774388 | -96.23250453 | 2021-03-05 05:26:29 | Greenwood, Kansas, US |
2207506 | 2207506 | 2021-03-04 | Colombia | Meta | 42546 | 974 | 41036 | 536 | 3.272 | -73.0877 | 2021-03-05 05:26:29 | Meta, Colombia | ||
1091386 | 1091386 | 2021-03-03 | US | Kansas | Morris | 20127 | 557 | 21 | 0 | 536 | 38.68827511 | -96.65128437 | 2021-03-04 05:24:24 | Morris, Kansas, US |
1091359 | 1091359 | 2021-03-03 | US | Kansas | Greenwood | 20073 | 549 | 13 | 0 | 536 | 37.8774388 | -96.23250453 | 2021-03-04 05:24:24 | Greenwood, Kansas, US |
999926 | 999926 | 2021-03-01 | US | Louisiana | Cameron | 22023 | 542 | 6 | 0 | 536 | 29.87592238 | -93.19310676 | 2021-03-02 05:23:30 | Cameron, Louisiana, US |
2370241 | 2370241 | 2021-02-28 | US | Puerto Rico | Lares | 72081 | 536 | 0 | 0 | 536 | 18.269035 | -66.867236 | 2021-03-01 05:23:01 | Lares, Puerto Rico, US |
1859939 | 1859939 | 2021-02-25 | US | Missouri | Ozark | 29153 | 549 | 13 | 0 | 536 | 36.64916339 | -92.44459066 | 2021-02-26 05:22:40 | Ozark, Missouri, US |
1857857 | 1857857 | 2021-02-25 | Colombia | Meta | 42211 | 969 | 40706 | 536 | 3.272 | -73.0877 | 2021-02-26 05:22:40 | Meta, Colombia | ||
282117 | 282117 | 2021-02-24 | US | Missouri | Ozark | 29153 | 549 | 13 | 0 | 536 | 36.64916339 | -92.44459066 | 2021-02-25 05:24:57 | Ozark, Missouri, US |
281670 | 281670 | 2021-02-24 | US | Louisiana | Cameron | 22023 | 541 | 5 | 0 | 536 | 29.87592238 | -93.19310676 | 2021-02-25 05:24:57 | Cameron, Louisiana, US |
1938385 | 1938385 | 2021-02-23 | US | Missouri | Ozark | 29153 | 549 | 13 | 0 | 536 | 36.64916339 | -92.44459066 | 2021-02-24 05:29:16 | Ozark, Missouri, US |
1937770 | 1937770 | 2021-02-23 | US | Kansas | Ottawa | 20143 | 548 | 12 | 0 | 536 | 39.13237408 | -97.65020313 | 2021-02-24 05:29:16 | Ottawa, Kansas, US |
533096 | 533096 | 2021-02-22 | US | North Dakota | Foster | 38031 | 559 | 19 | 0 | 536 | 47.4571084 | -98.88279923 | 2021-02-23 05:23:41 | Foster, North Dakota, US |
532025 | 532025 | 2021-02-22 | US | Kansas | Ottawa | 20143 | 548 | 12 | 0 | 536 | 39.13237408 | -97.65020313 | 2021-02-23 05:23:41 | Ottawa, Kansas, US |
184430 | 184430 | 2021-02-21 | US | North Dakota | Foster | 38031 | 556 | 19 | 0 | 536 | 47.4571084 | -98.88279923 | 2021-02-22 05:24:21 | Foster, North Dakota, US |
744704 | 744704 | 2021-02-20 | US | North Dakota | Foster | 38031 | 556 | 19 | 0 | 536 | 47.4571084 | -98.88279923 | 2021-02-21 05:24:33 | Foster, North Dakota, US |
473802 | 473802 | 2021-02-19 | US | North Dakota | Foster | 38031 | 556 | 19 | 0 | 536 | 47.4571084 | -98.88279923 | 2021-02-20 05:22:51 | Foster, North Dakota, US |
1154440 | 1154440 | 2021-02-18 | US | Kansas | Ottawa | 20143 | 548 | 12 | 0 | 536 | 39.13237408 | -97.65020313 | 2021-02-19 05:24:16 | Ottawa, Kansas, US |
3602360 | 3602360 | 2021-02-17 | US | Kansas | Ottawa | 20143 | 548 | 12 | 0 | 536 | 39.13237408 | -97.65020313 | 2021-02-18 05:22:58 | Ottawa, Kansas, US |
3052487 | 3052487 | 2021-02-16 | US | North Carolina | Graham | 37075 | 548 | 12 | 0 | 536 | 35.3506925 | -83.83369267 | 2021-02-17 05:23:10 | Graham, North Carolina, US |
3051350 | 3051350 | 2021-02-16 | US | Iowa | Decatur | 19053 | 544 | 8 | 0 | 536 | 40.73742757 | -93.78645949 | 2021-02-17 05:23:10 | Decatur, Iowa, US |
1340586 | 1340586 | 2021-02-15 | US | North Carolina | Graham | 37075 | 548 | 12 | 0 | 536 | 35.3506925 | -83.83369267 | 2021-02-16 05:24:38 | Graham, North Carolina, US |
2285737 | 2285737 | 2021-02-14 | US | North Carolina | Graham | 37075 | 548 | 12 | 0 | 536 | 35.3506925 | -83.83369267 | 2021-02-15 05:24:49 | Graham, North Carolina, US |
3542170 | 3542170 | 2021-02-12 | US | Puerto Rico | Barceloneta | 72017 | 536 | 0 | 0 | 536 | 18.445533 | -66.56053100000001 | 2021-02-13 05:22:12 | Barceloneta, Puerto Rico, US |
3980134 | 3980134 | 2021-02-10 | US | Maine | Waldo | 23027 | 554 | 18 | 0 | 536 | 44.4858305 | -69.12061935 | 2021-02-11 05:23:55 | Waldo, Maine, US |
1673739 | 1673739 | 2021-02-07 | US | Kansas | Gray | 20069 | 548 | 12 | 0 | 536 | 37.73836671 | -100.4369088 | 2021-02-08 05:22:39 | Gray, Kansas, US |
976200 | 976200 | 2021-02-06 | US | Kansas | Gray | 20069 | 548 | 12 | 0 | 536 | 37.73836671 | -100.4369088 | 2021-02-07 05:23:00 | Gray, Kansas, US |
974758 | 974758 | 2021-02-06 | Colombia | Caqueta | 16747 | 602 | 15609 | 536 | 0.8699 | -73.8419 | 2021-02-07 05:23:00 | Caqueta, Colombia | ||
1590232 | 1590232 | 2021-02-05 | US | Nebraska | Dixon | 31051 | 544 | 8 | 0 | 536 | 42.49188363 | -96.86782408 | 2021-02-06 05:23:55 | Dixon, Nebraska, US |
1589458 | 1589458 | 2021-02-05 | US | Kansas | Gray | 20069 | 548 | 12 | 0 | 536 | 37.73836671 | -100.4369088 | 2021-02-06 05:23:55 | Gray, Kansas, US |
793436 | 793436 | 2021-02-04 | US | Texas | Crockett | 48105 | 407 | 15 | 0 | 536 | 30.72367027 | -101.4134238 | 2021-02-05 05:22:38 | Crockett, Texas, US |
791665 | 791665 | 2021-02-04 | US | Kansas | Gray | 20069 | 548 | 12 | 0 | 536 | 37.73836671 | -100.4369088 | 2021-02-05 05:22:38 | Gray, Kansas, US |
790224 | 790224 | 2021-02-04 | Colombia | Casanare | 11657 | 236 | 10885 | 536 | 5.7589 | -71.5724 | 2021-02-05 05:22:38 | Casanare, Colombia | ||
341557 | 341557 | 2021-02-03 | US | Kansas | Gray | 20069 | 548 | 12 | 0 | 536 | 37.73836671 | -100.4369088 | 2021-02-04 05:22:26 | Gray, Kansas, US |
1686900 | 1686900 | 2021-02-02 | US | North Dakota | McHenry | 38049 | 557 | 21 | 0 | 536 | 48.23104458 | -100.6324822 | 2021-02-03 05:22:52 | McHenry, North Dakota, US |
2484692 | 2484692 | 2021-01-28 | US | Puerto Rico | Ciales | 72039 | 536 | 0 | 0 | 536 | 18.28885 | -66.516475 | 2021-01-29 05:22:23 | Ciales, Puerto Rico, US |
2482497 | 2482497 | 2021-01-28 | US | Arkansas | Woodruff | 5147 | 542 | 6 | 0 | 536 | 35.18902527 | -91.2439489 | 2021-01-29 05:22:23 | Woodruff, Arkansas, US |
3157107 | 3157107 | 2021-01-27 | US | West Virginia | Ritchie | 54085 | 544 | 8 | 0 | 536 | 39.18094587 | -81.06356878 | 2021-01-28 05:22:24 | Ritchie, West Virginia, US |
3154380 | 3154380 | 2021-01-27 | US | Georgia | Crawford | 13079 | 547 | 11 | 0 | 536 | 32.71391813 | -83.98061238 | 2021-01-28 05:22:24 | Crawford, Georgia, US |
15568 | 15568 | 2021-01-26 | US | Texas | Trinity | 48455 | 767 | 18 | 0 | 536 | 31.0879489 | -95.1367187 | 2021-01-27 05:23:41 | Trinity, Texas, US |
13231 | 13231 | 2021-01-26 | US | Georgia | Wheeler | 13309 | 557 | 21 | 0 | 536 | 32.12009104 | -82.72574721 | 2021-01-27 05:23:41 | Wheeler, Georgia, US |
2569989 | 2569989 | 2021-01-25 | US | North Carolina | Jones | 37103 | 552 | 16 | 0 | 536 | 35.02254606 | -77.35870791 | 2021-01-26 05:22:02 | Jones, North Carolina, US |
2568555 | 2568555 | 2021-01-25 | US | Georgia | Wheeler | 13309 | 557 | 21 | 0 | 536 | 32.12009104 | -82.72574721 | 2021-01-26 05:22:02 | Wheeler, Georgia, US |
1762793 | 1762793 | 2021-01-24 | US | West Virginia | Pocahontas | 54075 | 545 | 9 | 0 | 536 | 38.32758728 | -80.00993811 | 2021-01-25 05:22:16 | Pocahontas, West Virginia, US |
1762677 | 1762677 | 2021-01-24 | US | Virginia | Poquoson | 51735 | 543 | 7 | 0 | 536 | 37.14259351 | -76.35798148 | 2021-01-25 05:22:16 | Poquoson, Virginia, US |
2430400 | 2430400 | 2021-01-23 | US | West Virginia | Pocahontas | 54075 | 545 | 9 | 0 | 536 | 38.32758728 | -80.00993811 | 2021-01-24 05:22:35 | Pocahontas, West Virginia, US |
2470275 | 2470275 | 2021-01-22 | US | West Virginia | Gilmer | 54021 | 542 | 6 | 0 | 536 | 38.9251277 | -80.85952723 | 2021-01-23 05:22:03 | Gilmer, West Virginia, US |
2470250 | 2470250 | 2021-01-22 | US | Washington | Pend Oreille | 53051 | 540 | 4 | 0 | 536 | 48.53234021 | -117.2741804 | 2021-01-23 05:22:03 | Pend Oreille, Washington, US |
2470119 | 2470119 | 2021-01-22 | US | Virginia | Covington | 51580 | 540 | 4 | 0 | 536 | 37.7824656 | -79.98631446 | 2021-01-23 05:22:03 | Covington, Virginia, US |
2468363 | 2468363 | 2021-01-22 | US | Maine | Washington | 23029 | 544 | 8 | 0 | 536 | 45.01607142 | -67.62813524 | 2021-01-23 05:22:03 | Washington, Maine, US |
2468353 | 2468353 | 2021-01-22 | US | Maine | Knox | 23013 | 540 | 4 | 0 | 536 | 44.11486325 | -69.10529169 | 2021-01-23 05:22:03 | Knox, Maine, US |
438826 | 438826 | 2021-01-21 | US | West Virginia | Gilmer | 54021 | 542 | 6 | 0 | 536 | 38.9251277 | -80.85952723 | 2021-01-22 05:22:10 | Gilmer, West Virginia, US |
438670 | 438670 | 2021-01-21 | US | Virginia | Covington | 51580 | 540 | 4 | 0 | 536 | 37.7824656 | -79.98631446 | 2021-01-22 05:22:10 | Covington, Virginia, US |
1096867 | 1096867 | 2021-01-20 | US | Puerto Rico | Villalba | 72149 | 536 | 0 | 0 | 536 | 18.127951 | -66.473115 | 2021-01-21 05:22:01 | Villalba, Puerto Rico, US |
1094197 | 1094197 | 2021-01-20 | Mongolia | 1568 | 1 | 1046 | 536 | 46.8625 | 103.8467 | 2021-01-21 05:22:01 | Mongolia | |||
1093876 | 1093876 | 2021-01-20 | Chile | Coquimbo | 15683 | 322 | 14825 | 536 | -29.959 | -71.3389 | 2021-01-21 05:22:01 | Coquimbo, Chile | ||
910104 | 910104 | 2021-01-19 | US | Missouri | Montgomery | 29139 | 545 | 9 | 0 | 536 | 38.94022054 | -91.47000721 | 2021-01-20 05:21:54 | Montgomery, Missouri, US |
239167 | 239167 | 2021-01-18 | US | Missouri | Montgomery | 29139 | 545 | 9 | 0 | 536 | 38.94022054 | -91.47000721 | 2021-01-19 05:22:15 | Montgomery, Missouri, US |
3505284 | 3505284 | 2021-01-17 | US | Missouri | Montgomery | 29139 | 545 | 9 | 0 | 536 | 38.94022054 | -91.47000721 | 2021-01-18 05:22:34 | Montgomery, Missouri, US |
3517723 | 3517723 | 2021-01-15 | US | North Carolina | Hyde | 37095 | 542 | 6 | 0 | 536 | 35.42017674 | -76.15180542 | 2021-01-16 05:22:40 | Hyde, North Carolina, US |
3515112 | 3515112 | 2021-01-15 | Barbados | 1036 | 7 | 493 | 536 | 13.1939 | -59.5432 | 2021-01-16 05:22:40 | Barbados | |||
3879285 | 3879285 | 2021-01-14 | Barbados | 1036 | 7 | 493 | 536 | 13.1939 | -59.5432 | 2021-01-15 05:22:24 | Barbados | |||
3311253 | 3311253 | 2021-01-13 | US | Texas | Crane | 48103 | 412 | 10 | 0 | 536 | 31.43052248 | -102.5143314 | 2021-01-14 05:22:32 | Crane, Texas, US |
776446 | 776446 | 2021-01-12 | US | Nebraska | Pierce | 31139 | 556 | 20 | 0 | 536 | 42.26434853 | -97.60122773 | 2021-01-13 05:22:15 | Pierce, Nebraska, US |
774372 | 774372 | 2021-01-12 | Japan | Miyazaki | 1337 | 10 | 791 | 536 | 32.193203999999994 | 131.299374 | 2021-01-13 05:22:15 | Miyazaki, Japan | ||
191920 | 191920 | 2021-01-11 | US | Mississippi | Wilkinson | 28157 | 560 | 24 | 0 | 536 | 31.16078225 | -91.31018819 | 2021-01-12 05:22:15 | Wilkinson, Mississippi, US |
189919 | 189919 | 2021-01-11 | Colombia | La Guajira | 14646 | 562 | 13548 | 536 | 11.3548 | -72.5205 | 2021-01-12 05:22:15 | La Guajira, Colombia | ||
2629468 | 2629468 | 2021-01-10 | US | Wyoming | Johnson | 56019 | 544 | 8 | 0 | 536 | 44.04057166 | -106.5845174 | 2021-01-11 05:21:50 | Johnson, Wyoming, 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]);