johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
145 rows where active = 1584 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2693530 | 2693530 | 2021-07-06 | Colombia | Cauca | 44025 | 1167 | 41274 | 1584 | 2.705 | -76.82600000000002 | 2021-07-07 04:21:20 | Cauca, Colombia | ||
2072063 | 2072063 | 2021-07-02 | Pakistan | Khyber Pakhtunkhwa | 138306 | 4329 | 132393 | 1584 | 34.485332 | 72.09169 | 2021-07-03 04:21:37 | Khyber Pakhtunkhwa, Pakistan | ||
1893390 | 1893390 | 2021-06-30 | Russia | Stavropol Krai | 57181 | 1673 | 53924 | 1584 | 44.86325770000001 | 43.4406913 | 2021-07-01 04:21:19 | Stavropol Krai, Russia | ||
3675576 | 3675576 | 2021-05-04 | Ghana | 92740 | 780 | 90376 | 1584 | 7.9465 | -1.0232 | 2021-05-05 04:20:43 | Ghana | |||
2760879 | 2760879 | 2021-05-03 | India | Nagaland | 14451 | 115 | 12752 | 1584 | 26.06702 | 94.470302 | 2021-05-04 04:20:34 | Nagaland, India | ||
3663596 | 3663596 | 2021-03-09 | Italy | Molise | 11234 | 379 | 9271 | 1584 | 41.55774754 | 14.65916051 | 2021-03-10 05:24:35 | Molise, Italy | ||
3670032 | 3670032 | 2021-03-06 | US | North Dakota | Ramsey | 38071 | 1607 | 30 | 0 | 1584 | 48.26886249 | -98.72223879 | 2021-03-07 05:21:54 | Ramsey, North Dakota, US |
1616207 | 1616207 | 2021-03-05 | India | Rajasthan | 321123 | 2789 | 316750 | 1584 | 26.583423 | 73.847973 | 2021-03-06 04:23:41 | Rajasthan, India | ||
1092442 | 1092442 | 2021-03-03 | US | North Carolina | Warren | 37185 | 1602 | 18 | 0 | 1584 | 36.39728256 | -78.10652228 | 2021-03-04 05:24:24 | Warren, North Carolina, US |
1092003 | 1092003 | 2021-03-03 | US | Missouri | Morgan | 29141 | 1626 | 42 | 0 | 1584 | 38.4181765 | -92.88791859 | 2021-03-04 05:24:24 | Morgan, Missouri, US |
1090019 | 1090019 | 2021-03-03 | India | Delhi | 639921 | 10914 | 627423 | 1584 | 28.646519 | 77.10898 | 2021-03-04 05:24:24 | Delhi, India | ||
3255140 | 3255140 | 2021-03-02 | US | Illinois | Jo Daviess | 17085 | 1606 | 22 | 0 | 1584 | 42.36542373 | -90.21094405 | 2021-03-03 05:23:28 | Jo Daviess, Illinois, US |
999488 | 999488 | 2021-03-01 | US | Illinois | White | 17193 | 1609 | 25 | 0 | 1584 | 38.08706198 | -88.17657461 | 2021-03-02 05:23:30 | White, Illinois, US |
1937808 | 1937808 | 2021-02-23 | US | Kentucky | Anderson | 21005 | 1600 | 16 | 0 | 1584 | 38.00671029 | -84.99171713 | 2021-02-24 05:29:16 | Anderson, Kentucky, US |
184164 | 184164 | 2021-02-21 | US | Nebraska | York | 31185 | 1593 | 9 | 0 | 1584 | 40.87272618 | -97.59710186 | 2021-02-22 05:24:21 | York, Nebraska, US |
471282 | 471282 | 2021-02-19 | Cote d'Ivoire | 31825 | 185 | 30056 | 1584 | 7.54 | -5.5471 | 2021-02-20 05:22:51 | Cote d'Ivoire | |||
1341209 | 1341209 | 2021-02-15 | US | Tennessee | Grundy | 47061 | 1629 | 27 | 0 | 1584 | 35.38433717 | -85.72142731 | 2021-02-16 05:24:38 | Grundy, Tennessee, US |
1340967 | 1340967 | 2021-02-15 | US | Pennsylvania | Susquehanna | 42115 | 1637 | 53 | 0 | 1584 | 41.82147784 | -75.80071959 | 2021-02-16 05:24:38 | Susquehanna, Pennsylvania, US |
1339736 | 1339736 | 2021-02-15 | US | Kentucky | Simpson | 21213 | 1612 | 28 | 0 | 1584 | 36.74058474 | -86.58047435 | 2021-02-16 05:24:38 | Simpson, Kentucky, US |
2681335 | 2681335 | 2021-02-13 | US | West Virginia | Upshur | 54097 | 1613 | 29 | 0 | 1584 | 38.89285061 | -80.23689136 | 2021-02-14 05:23:43 | Upshur, West Virginia, US |
2679786 | 2679786 | 2021-02-13 | US | Missouri | Ste. Genevieve | 29186 | 1597 | 13 | 0 | 1584 | 37.89090059 | -90.1949941 | 2021-02-14 05:23:43 | Ste. Genevieve, Missouri, US |
3540201 | 3540201 | 2021-02-12 | US | Georgia | Banks | 13011 | 1614 | 30 | 0 | 1584 | 34.35607081 | -83.49644388 | 2021-02-13 05:22:12 | Banks, Georgia, US |
3981569 | 3981569 | 2021-02-10 | US | Tennessee | Union | 47173 | 1618 | 28 | 0 | 1584 | 36.28590426 | -83.83651902 | 2021-02-11 05:23:55 | Union, Tennessee, US |
3981551 | 3981551 | 2021-02-10 | US | Tennessee | Polk | 47139 | 1610 | 21 | 0 | 1584 | 35.12245443 | -84.52075859 | 2021-02-11 05:23:55 | Polk, Tennessee, US |
3980011 | 3980011 | 2021-02-10 | US | Kentucky | McCreary | 21147 | 1602 | 18 | 0 | 1584 | 36.73874143 | -84.48102924 | 2021-02-11 05:23:55 | McCreary, Kentucky, US |
614179 | 614179 | 2021-02-08 | US | Arkansas | Lee | 5077 | 1618 | 34 | 0 | 1584 | 34.78498904 | -90.78383866 | 2021-02-09 05:23:30 | Lee, Arkansas, US |
1589339 | 1589339 | 2021-02-05 | US | Iowa | Cedar | 19031 | 1604 | 20 | 0 | 1584 | 41.77233777 | -91.13246684 | 2021-02-06 05:23:55 | Cedar, Iowa, US |
793511 | 793511 | 2021-02-04 | US | Texas | Karnes | 48255 | 1646 | 27 | 0 | 1584 | 28.90705334 | -97.85960149 | 2021-02-05 05:22:38 | Karnes, Texas, US |
791739 | 791739 | 2021-02-04 | US | Kentucky | Allen | 21003 | 1605 | 21 | 0 | 1584 | 36.75197631 | -86.19457544 | 2021-02-05 05:22:38 | Allen, Kentucky, US |
1687509 | 1687509 | 2021-02-02 | US | Texas | Austin | 48015 | 1681 | 26 | 0 | 1584 | 29.88548725 | -96.27736949 | 2021-02-03 05:22:52 | Austin, Texas, US |
1460599 | 1460599 | 2021-01-31 | US | Georgia | Morgan | 13211 | 1596 | 12 | 0 | 1584 | 33.59232073 | -83.49129491 | 2021-02-01 05:22:53 | Morgan, Georgia, US |
2212310 | 2212310 | 2021-01-30 | US | Colorado | Routt | 8107 | 1668 | 19 | 0 | 1584 | 40.48596505 | -106.9905548 | 2021-01-31 05:22:42 | Routt, Colorado, US |
1900833 | 1900833 | 2021-01-29 | Malaysia | Pahang | 2862 | 10 | 1268 | 1584 | 3.8126 | 103.3256 | 2021-01-30 05:22:49 | Pahang, Malaysia | ||
2429571 | 2429571 | 2021-01-23 | US | Pennsylvania | Juniata | 42067 | 1660 | 76 | 0 | 1584 | 40.53358749 | -77.39975129999998 | 2021-01-24 05:22:35 | Juniata, Pennsylvania, US |
2468202 | 2468202 | 2021-01-22 | US | Kentucky | Grayson | 21085 | 1622 | 38 | 0 | 1584 | 37.46231118 | -86.34248968 | 2021-01-23 05:22:03 | Grayson, Kentucky, US |
3505240 | 3505240 | 2021-01-17 | US | Missouri | Cooper | 29053 | 1605 | 21 | 0 | 1584 | 38.844478 | -92.80896081 | 2021-01-18 05:22:34 | Cooper, Missouri, US |
192480 | 192480 | 2021-01-11 | US | North Dakota | Richland | 38077 | 1607 | 15 | 0 | 1584 | 46.26440649 | -96.94852979 | 2021-01-12 05:22:15 | Richland, North Dakota, US |
155184 | 155184 | 2021-01-08 | US | Iowa | Kossuth | 19109 | 1619 | 35 | 0 | 1584 | 43.20405458 | -94.20691791 | 2021-01-09 05:22:18 | Kossuth, Iowa, US |
155111 | 155111 | 2021-01-08 | US | Indiana | Starke | 18149 | 1631 | 47 | 0 | 1584 | 41.27890281 | -86.64686895 | 2021-01-09 05:22:18 | Starke, Indiana, US |
2544063 | 2544063 | 2021-01-07 | US | Pennsylvania | Elk | 42047 | 1605 | 21 | 0 | 1584 | 41.42822061 | -78.64524744 | 2021-01-08 05:22:42 | Elk, Pennsylvania, US |
3231409 | 3231409 | 2021-01-03 | US | Illinois | Cass | 17017 | 1604 | 20 | 0 | 1584 | 39.96991073 | -90.24734436 | 2021-01-04 05:22:02 | Cass, Illinois, US |
3231203 | 3231203 | 2021-01-03 | US | Georgia | Burke | 13033 | 1604 | 20 | 0 | 1584 | 33.05917989 | -81.99928721 | 2021-01-04 05:22:02 | Burke, Georgia, US |
3699015 | 3699015 | 2020-12-31 | US | Wisconsin | Crawford | 55023 | 1596 | 12 | 0 | 1584 | 43.23870316 | -90.93073686 | 2021-01-01 05:23:07 | Crawford, Wisconsin, US |
3698970 | 3698970 | 2020-12-31 | US | West Virginia | Logan | 54045 | 1642 | 58 | 0 | 1584 | 37.8299889 | -81.93528571 | 2021-01-01 05:23:07 | Logan, West Virginia, US |
3697417 | 3697417 | 2020-12-31 | US | Missouri | New Madrid | 29143 | 1615 | 31 | 0 | 1584 | 36.59666326 | -89.66070007 | 2021-01-01 05:23:07 | New Madrid, Missouri, US |
1012056 | 1012056 | 2020-12-30 | US | Minnesota | Roseau | 27135 | 1598 | 14 | 0 | 1584 | 48.77501878 | -95.81079919 | 2020-12-31 05:22:49 | Roseau, Minnesota, US |
769816 | 769816 | 2020-12-29 | US | West Virginia | Preston | 54077 | 1612 | 28 | 0 | 1584 | 39.46770987 | -79.66712803 | 2020-12-30 05:22:34 | Preston, West Virginia, US |
769738 | 769738 | 2020-12-29 | US | Washington | Adams | 53001 | 1600 | 16 | 0 | 1584 | 46.98299757 | -118.5601734 | 2020-12-30 05:22:34 | Adams, Washington, US |
769407 | 769407 | 2020-12-29 | US | Texas | Gonzales | 48177 | 1585 | 25 | 0 | 1584 | 29.45634206 | -97.49424032 | 2020-12-30 05:22:34 | Gonzales, Texas, US |
767169 | 767169 | 2020-12-29 | US | Georgia | Pierce | 13229 | 1617 | 33 | 0 | 1584 | 31.35928155 | -82.21598442 | 2020-12-30 05:22:34 | Pierce, Georgia, US |
3778108 | 3778108 | 2020-12-27 | Russia | Karachay-Cherkess Republic | 14765 | 41 | 13140 | 1584 | 43.7368326 | 41.7267991 | 2020-12-28 05:22:06 | Karachay-Cherkess Republic, Russia | ||
2408648 | 2408648 | 2020-12-23 | US | Mississippi | Marion | 28091 | 1643 | 59 | 0 | 1584 | 31.23132643 | -89.8209217 | 2020-12-24 05:23:04 | Marion, Mississippi, US |
3770671 | 3770671 | 2020-12-22 | US | Georgia | Franklin | 13119 | 1610 | 26 | 0 | 1584 | 34.37525597 | -83.23159927 | 2020-12-23 05:22:03 | Franklin, Georgia, US |
928489 | 928489 | 2020-12-21 | US | Georgia | Gilmer | 13123 | 1618 | 34 | 0 | 1584 | 34.69316688 | -84.45802506 | 2020-12-22 05:22:33 | Gilmer, Georgia, US |
2122205 | 2122205 | 2020-12-20 | US | Ohio | Perry | 39127 | 1617 | 33 | 0 | 1584 | 39.73508655 | -82.23804971 | 2020-12-21 05:27:58 | Perry, Ohio, US |
1904255 | 1904255 | 2020-12-18 | US | Texas | Gray | 48179 | 2040 | 29 | 0 | 1584 | 35.40081878 | -100.8129222 | 2020-12-19 05:27:52 | Gray, Texas, US |
1903019 | 1903019 | 2020-12-18 | US | Mississippi | Winston | 28159 | 1628 | 44 | 0 | 1584 | 33.08747908 | -89.03391385 | 2020-12-19 05:27:52 | Winston, Mississippi, US |
3150711 | 3150711 | 2020-12-16 | US | Indiana | Posey | 18129 | 1609 | 25 | 0 | 1584 | 38.02097333 | -87.86480429 | 2020-12-17 05:28:12 | Posey, Indiana, US |
1035078 | 1035078 | 2020-12-15 | US | Florida | Levy | 12075 | 1602 | 18 | 0 | 1584 | 29.31829741 | -82.74007147 | 2020-12-16 05:28:04 | Levy, Florida, US |
1753890 | 1753890 | 2020-12-14 | US | Oregon | Polk | 41053 | 1608 | 24 | 0 | 1584 | 44.90322804 | -123.4128888 | 2020-12-15 05:26:38 | Polk, Oregon, US |
1753235 | 1753235 | 2020-12-14 | US | Missouri | Washington | 29221 | 1615 | 31 | 0 | 1584 | 37.96130078 | -90.87948158 | 2020-12-15 05:26:38 | Washington, Missouri, US |
1008124 | 1008124 | 2020-12-06 | US | Mississippi | Prentiss | 28117 | 1619 | 35 | 0 | 1584 | 34.61810501 | -88.51986294 | 2020-12-07 05:26:14 | Prentiss, Mississippi, US |
77023 | 77023 | 2020-12-03 | US | Missouri | Perry | 29157 | 1596 | 12 | 0 | 1584 | 37.70660776 | -89.82741088 | 2020-12-04 05:27:27 | Perry, Missouri, US |
75868 | 75868 | 2020-12-03 | US | Georgia | Decatur | 13087 | 1630 | 46 | 0 | 1584 | 30.87967778 | -84.57619536 | 2020-12-04 05:27:27 | Decatur, Georgia, US |
2538517 | 2538517 | 2020-12-01 | US | Indiana | Ripley | 18137 | 1606 | 22 | 0 | 1584 | 39.10235626 | -85.26212744 | 2020-12-02 05:27:41 | Ripley, Indiana, US |
2538294 | 2538294 | 2020-12-01 | US | Hawaii | Hawaii | 15001 | 1618 | 34 | 0 | 1584 | 19.60121157 | -155.5210167 | 2020-12-02 05:27:41 | Hawaii, Hawaii, US |
1973114 | 1973114 | 2020-11-25 | US | Arkansas | Yell | 5149 | 1617 | 33 | 0 | 1584 | 35.00292371 | -93.41171338 | 2020-11-26 05:27:44 | Yell, Arkansas, US |
1352163 | 1352163 | 2020-11-24 | US | Mississippi | Union | 28145 | 1609 | 25 | 0 | 1584 | 34.49162015 | -89.00776006 | 2020-11-25 05:27:20 | Union, Mississippi, US |
1351775 | 1351775 | 2020-11-24 | US | Kentucky | Scott | 21209 | 1604 | 20 | 0 | 1584 | 38.29622293 | -84.5816631 | 2020-11-25 05:27:20 | Scott, Kentucky, US |
1351688 | 1351688 | 2020-11-24 | US | Kentucky | Calloway | 21035 | 1598 | 14 | 0 | 1584 | 36.62093411 | -88.2731593 | 2020-11-25 05:27:20 | Calloway, Kentucky, US |
680152 | 680152 | 2020-11-23 | US | Mississippi | Tate | 28137 | 1633 | 49 | 0 | 1584 | 34.65133709 | -89.94485778 | 2020-11-24 05:27:31 | Tate, Mississippi, US |
3838239 | 3838239 | 2020-11-21 | US | Minnesota | Steele | 27147 | 1590 | 6 | 0 | 1584 | 44.02240351 | -93.22627088 | 2020-11-22 05:25:45 | Steele, Minnesota, US |
3341935 | 3341935 | 2020-11-17 | US | Virginia | Henry | 51089 | 1621 | 37 | 0 | 1584 | 36.68542395 | -79.87634026 | 2020-11-18 05:40:31 | Henry, Virginia, US |
3338430 | 3338430 | 2020-11-17 | Colombia | Boyaca | 18738 | 396 | 16758 | 1584 | 5.4545 | -73.362 | 2020-11-18 05:40:31 | Boyaca, Colombia | ||
2881740 | 2881740 | 2020-11-15 | US | Louisiana | Webster | 22119 | 1629 | 45 | 0 | 1584 | 32.70847669 | -93.33121835 | 2020-11-16 05:25:57 | Webster, Louisiana, US |
2917525 | 2917525 | 2020-11-14 | US | North Carolina | Pender | 37141 | 1601 | 17 | 0 | 1584 | 34.52265624 | -77.90352133 | 2020-11-15 05:26:53 | Pender, North Carolina, US |
1990076 | 1990076 | 2020-11-09 | US | Kentucky | Oldham | 21185 | 1610 | 26 | 0 | 1584 | 38.39791089 | -85.448222 | 2020-11-10 05:40:07 | Oldham, Kentucky, US |
2920267 | 2920267 | 2020-11-04 | US | Indiana | Henry | 18065 | 1615 | 31 | 0 | 1584 | 39.93029017 | -85.39625719 | 2020-11-05 06:05:03 | Henry, Indiana, US |
2919039 | 2919039 | 2020-11-04 | Colombia | Quindio | 11176 | 274 | 9318 | 1584 | 4.461 | -75.6674 | 2020-11-05 06:05:03 | Quindio, Colombia | ||
3305791 | 3305791 | 2020-11-02 | US | Michigan | Allegan | 26005 | 1591 | 7 | 0 | 1584 | 42.59147037 | -85.89102866 | 2020-11-03 06:00:16 | Allegan, Michigan, US |
3304514 | 3304514 | 2020-11-02 | Sweden | Varmland | 1659 | 75 | 0 | 1584 | 59.7294 | 13.2354 | 2020-11-03 06:00:16 | Varmland, Sweden | ||
3409763 | 3409763 | 2020-11-01 | Sweden | Varmland | 1659 | 75 | 0 | 1584 | 59.7294 | 13.2354 | 2020-11-02 05:25:04 | Varmland, Sweden | ||
2080252 | 2080252 | 2020-10-31 | Sweden | Varmland | 1659 | 75 | 0 | 1584 | 59.7294 | 13.2354 | 2020-11-01 04:36:19 | Varmland, Sweden | ||
2246690 | 2246690 | 2020-10-30 | US | Virginia | Charlottesville | 51540 | 1615 | 31 | 0 | 1584 | 38.03527919 | -78.48569588 | 2020-10-31 04:24:44 | Charlottesville, Virginia, US |
2243705 | 2243705 | 2020-10-30 | Sweden | Varmland | 1659 | 75 | 0 | 1584 | 59.7294 | 13.2354 | 2020-10-31 04:24:44 | Varmland, Sweden | ||
213233 | 213233 | 2020-10-29 | US | Tennessee | Weakley | 47183 | 1612 | 26 | 0 | 1584 | 36.29896232 | -88.71990865 | 2020-10-30 04:24:49 | Weakley, Tennessee, US |
212417 | 212417 | 2020-10-29 | US | New Mexico | Curry | 35009 | 1596 | 12 | 0 | 1584 | 34.57421077 | -103.3468876 | 2020-10-30 04:24:49 | Curry, New Mexico, US |
210237 | 210237 | 2020-10-29 | Italy | Valle d'Aosta | 2981 | 162 | 1235 | 1584 | 45.73750286 | 7.320149366 | 2020-10-30 04:24:49 | Valle d'Aosta, Italy | ||
757123 | 757123 | 2020-10-28 | US | South Carolina | Newberry | 45071 | 1636 | 52 | 0 | 1584 | 34.28629098 | -81.59935761 | 2020-10-29 04:24:49 | Newberry, South Carolina, US |
1455407 | 1455407 | 2020-10-27 | US | South Carolina | Newberry | 45071 | 1631 | 47 | 0 | 1584 | 34.28629098 | -81.59935761 | 2020-10-28 04:24:39 | Newberry, South Carolina, US |
3482464 | 3482464 | 2020-10-26 | US | New Jersey | Cape May | 34009 | 1684 | 100 | 0 | 1584 | 39.15008829 | -74.80170244 | 2020-10-27 04:24:45 | Cape May, New Jersey, US |
10142 | 10142 | 2020-10-25 | US | Mississippi | Leflore | 28083 | 1671 | 87 | 0 | 1584 | 33.55545125 | -90.29900733 | 2020-10-26 04:25:02 | Leflore, Mississippi, US |
3654560 | 3654560 | 2020-10-24 | US | Tennessee | Wayne | 47181 | 1604 | 7 | 0 | 1584 | 35.23868267 | -87.78644456 | 2020-10-25 04:24:36 | Wayne, Tennessee, US |
3653379 | 3653379 | 2020-10-24 | US | Mississippi | Leflore | 28083 | 1671 | 87 | 0 | 1584 | 33.55545125 | -90.29900733 | 2020-10-25 04:24:36 | Leflore, Mississippi, US |
1180526 | 1180526 | 2020-10-22 | US | Texas | Cherokee | 48073 | 1304 | 32 | 0 | 1584 | 31.837258 | -95.16559897 | 2020-10-23 04:24:46 | Cherokee, Texas, US |
2194631 | 2194631 | 2020-10-21 | US | Texas | Cherokee | 48073 | 1290 | 32 | 0 | 1584 | 31.837258 | -95.16559897 | 2020-10-22 04:24:27 | Cherokee, Texas, US |
2192639 | 2192639 | 2020-10-21 | US | Illinois | Vermilion | 17183 | 1592 | 8 | 0 | 1584 | 40.18417171 | -87.73384359 | 2020-10-22 04:24:27 | Vermilion, Illinois, US |
764667 | 764667 | 2020-10-18 | US | North Carolina | Surry | 37171 | 1610 | 26 | 0 | 1584 | 36.41689489 | -80.69102283 | 2020-10-19 04:24:16 | Surry, North Carolina, US |
788197 | 788197 | 2020-10-15 | US | Mississippi | Panola | 28107 | 1620 | 36 | 0 | 1584 | 34.36398677 | -89.95064249 | 2020-10-16 04:24:01 | Panola, Mississippi, US |
80561 | 80561 | 2020-10-14 | US | Louisiana | Avoyelles | 22009 | 1646 | 62 | 0 | 1584 | 31.07796211 | -92.00079449 | 2020-10-15 04:24:28 | Avoyelles, Louisiana, 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]);