johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,273 rows where active = 91 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 112
- Virginia 73
- Missouri 60
- Kentucky 58
- Iowa 46
- Georgia 43
- Indiana 40
- Michigan 40
- Nebraska 38
- Ohio 38
- North Carolina 37
- Pennsylvania 35
- Puerto Rico 35
- Minnesota 34
- West Virginia 33
- Illinois 32
- Oklahoma 32
- New York 31
- Colorado 30
- Tennessee 29
- Kansas 28
- Delaware 27
- Montana 26
- South Dakota 26
- Alabama 25
- Arkansas 24
- Mississippi 23
- Oregon 23
- Wisconsin 22
- Florida 21
- …
country_or_region 1
- US · 1,273 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1093421 | 1093421 | 2021-03-03 | US | Virginia | Highland | 51091 | 92 | 1 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-03-04 05:24:24 | Highland, Virginia, US |
3257493 | 3257493 | 2021-03-02 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-03-03 05:23:28 | Highland, Virginia, US |
1001785 | 1001785 | 2021-03-01 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-03-02 05:23:30 | Highland, Virginia, US |
2370843 | 2370843 | 2021-02-28 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-03-01 05:23:01 | Highland, Virginia, US |
3069345 | 3069345 | 2021-02-27 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-02-28 05:22:20 | Highland, Virginia, US |
2186929 | 2186929 | 2021-02-26 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-02-27 05:22:28 | Highland, Virginia, US |
1938506 | 1938506 | 2021-02-23 | US | Nebraska | Deuel | 31049 | 93 | 2 | 0 | 91 | 41.11168186 | -102.3333331 | 2021-02-24 05:29:16 | Deuel, Nebraska, US |
3542735 | 3542735 | 2021-02-12 | US | Vermont | Grand Isle | 50013 | 91 | 0 | 0 | 91 | 44.7975824 | -73.29679772 | 2021-02-13 05:22:12 | Grand Isle, Vermont, US |
2640998 | 2640998 | 2021-02-11 | US | Vermont | Grand Isle | 50013 | 91 | 0 | 0 | 91 | 44.7975824 | -73.29679772 | 2021-02-12 05:23:29 | Grand Isle, Vermont, US |
1687579 | 1687579 | 2021-02-02 | US | Texas | Foard | 48155 | 75 | 7 | 0 | 91 | 33.97308618 | -99.7767797 | 2021-02-03 05:22:52 | Foard, Texas, US |
1679589 | 1679589 | 2021-02-01 | US | Texas | Irion | 48235 | 88 | 1 | 0 | 91 | 31.30375559 | -100.982439 | 2021-02-02 05:22:49 | Irion, Texas, US |
1462877 | 1462877 | 2021-01-31 | US | Texas | Irion | 48235 | 88 | 1 | 0 | 91 | 31.30375559 | -100.982439 | 2021-02-01 05:22:53 | Irion, Texas, US |
2214785 | 2214785 | 2021-01-30 | US | Texas | Irion | 48235 | 88 | 1 | 0 | 91 | 31.30375559 | -100.982439 | 2021-01-31 05:22:42 | Irion, Texas, US |
15418 | 15418 | 2021-01-26 | US | Texas | Foard | 48155 | 73 | 5 | 0 | 91 | 33.97308618 | -99.7767797 | 2021-01-27 05:23:41 | Foard, Texas, US |
2571111 | 2571111 | 2021-01-25 | US | Washington | San Juan | 53055 | 91 | 0 | 0 | 91 | 48.60182783 | -122.96745 | 2021-01-26 05:22:02 | San Juan, Washington, US |
2470252 | 2470252 | 2021-01-22 | US | Washington | San Juan | 53055 | 91 | 0 | 0 | 91 | 48.60182783 | -122.96745 | 2021-01-23 05:22:03 | San Juan, Washington, US |
3104887 | 3104887 | 2021-01-16 | US | Washington | San Juan | 53055 | 91 | 0 | 0 | 91 | 48.60182783 | -122.96745 | 2021-01-17 05:22:17 | San Juan, Washington, US |
3518032 | 3518032 | 2021-01-15 | US | Oregon | Wallowa | 41063 | 94 | 3 | 0 | 91 | 45.57894064 | -117.18353799999998 | 2021-01-16 05:22:40 | Wallowa, Oregon, US |
3518849 | 3518849 | 2021-01-15 | US | Washington | San Juan | 53055 | 91 | 0 | 0 | 91 | 48.60182783 | -122.96745 | 2021-01-16 05:22:40 | San Juan, Washington, US |
3882661 | 3882661 | 2021-01-14 | US | Texas | Glasscock | 48173 | 83 | 1 | 0 | 91 | 31.86942909 | -101.5207776 | 2021-01-15 05:22:24 | Glasscock, Texas, US |
3882790 | 3882790 | 2021-01-14 | US | Texas | Sterling | 48431 | 87 | 4 | 0 | 91 | 31.82781912 | -101.0500746 | 2021-01-15 05:22:24 | Sterling, Texas, US |
3311417 | 3311417 | 2021-01-13 | US | Texas | Sterling | 48431 | 87 | 4 | 0 | 91 | 31.82781912 | -101.0500746 | 2021-01-14 05:22:32 | Sterling, Texas, US |
2866355 | 2866355 | 2021-01-06 | US | Michigan | Keweenaw | 26083 | 93 | 2 | 0 | 91 | 47.63197653 | -88.41434263 | 2021-01-07 05:22:03 | Keweenaw, Michigan, US |
2867930 | 2867930 | 2021-01-06 | US | Texas | Sterling | 48431 | 84 | 1 | 0 | 91 | 31.82781912 | -101.0500746 | 2021-01-07 05:22:03 | Sterling, Texas, US |
3037388 | 3037388 | 2021-01-05 | US | Texas | Glasscock | 48173 | 83 | 1 | 0 | 91 | 31.86942909 | -101.5207776 | 2021-01-06 05:22:16 | Glasscock, Texas, US |
1064933 | 1064933 | 2021-01-04 | US | Texas | Glasscock | 48173 | 83 | 1 | 0 | 91 | 31.86942909 | -101.5207776 | 2021-01-05 05:21:49 | Glasscock, Texas, US |
2229583 | 2229583 | 2021-01-02 | US | Nebraska | Garden | 31069 | 92 | 1 | 0 | 91 | 41.61703149 | -102.3313973 | 2021-01-03 05:22:52 | Garden, Nebraska, US |
1138947 | 1138947 | 2021-01-01 | US | Nebraska | Garden | 31069 | 92 | 1 | 0 | 91 | 41.61703149 | -102.3313973 | 2021-01-02 05:22:33 | Garden, Nebraska, US |
1012368 | 1012368 | 2020-12-30 | US | Nebraska | Garden | 31069 | 91 | 0 | 0 | 91 | 41.61703149 | -102.3313973 | 2020-12-31 05:22:49 | Garden, Nebraska, US |
767602 | 767602 | 2020-12-29 | US | Kansas | Greeley | 20071 | 92 | 1 | 0 | 91 | 38.4808095 | -101.8061079 | 2020-12-30 05:22:34 | Greeley, Kansas, US |
3762866 | 3762866 | 2020-12-28 | US | Kansas | Greeley | 20071 | 92 | 1 | 0 | 91 | 38.4808095 | -101.8061079 | 2020-12-29 05:22:37 | Greeley, Kansas, US |
203110 | 203110 | 2020-12-25 | US | Georgia | Quitman | 13239 | 92 | 1 | 0 | 91 | 31.86728114 | -85.01773177 | 2020-12-26 05:22:28 | Quitman, Georgia, US |
3692333 | 3692333 | 2020-12-24 | US | Georgia | Quitman | 13239 | 92 | 1 | 0 | 91 | 31.86728114 | -85.01773177 | 2020-12-25 05:22:48 | Quitman, Georgia, US |
2407685 | 2407685 | 2020-12-23 | US | Georgia | Quitman | 13239 | 92 | 1 | 0 | 91 | 31.86728114 | -85.01773177 | 2020-12-24 05:23:04 | Quitman, Georgia, US |
3770731 | 3770731 | 2020-12-22 | US | Georgia | Quitman | 13239 | 92 | 1 | 0 | 91 | 31.86728114 | -85.01773177 | 2020-12-23 05:22:03 | Quitman, Georgia, US |
928547 | 928547 | 2020-12-21 | US | Georgia | Quitman | 13239 | 92 | 1 | 0 | 91 | 31.86728114 | -85.01773177 | 2020-12-22 05:22:33 | Quitman, Georgia, US |
929244 | 929244 | 2020-12-21 | US | Maine | Piscataquis | 23021 | 92 | 1 | 0 | 91 | 45.83839062 | -69.2860223 | 2020-12-22 05:22:33 | Piscataquis, Maine, US |
2120568 | 2120568 | 2020-12-20 | US | Georgia | Quitman | 13239 | 92 | 1 | 0 | 91 | 31.86728114 | -85.01773177 | 2020-12-21 05:27:58 | Quitman, Georgia, US |
2932075 | 2932075 | 2020-12-19 | US | Georgia | Quitman | 13239 | 92 | 1 | 0 | 91 | 31.86728114 | -85.01773177 | 2020-12-20 05:27:32 | Quitman, Georgia, US |
2934435 | 2934435 | 2020-12-19 | US | Texas | Sterling | 48431 | 88 | 1 | 0 | 91 | 31.82781912 | -101.0500746 | 2020-12-20 05:27:32 | Sterling, Texas, US |
1902021 | 1902021 | 2020-12-18 | US | Georgia | Quitman | 13239 | 92 | 1 | 0 | 91 | 31.86728114 | -85.01773177 | 2020-12-19 05:27:52 | Quitman, Georgia, US |
3850317 | 3850317 | 2020-12-13 | US | Oklahoma | Cimarron | 40025 | 91 | 0 | 0 | 91 | 36.74817177 | -102.5173885 | 2020-12-14 05:26:27 | Cimarron, Oklahoma, US |
863091 | 863091 | 2020-12-11 | US | North Dakota | Sheridan | 38083 | 94 | 2 | 0 | 91 | 47.57700669 | -100.3426391 | 2020-12-12 05:26:19 | Sheridan, North Dakota, US |
1602246 | 1602246 | 2020-12-10 | US | Montana | Wibaux | 30109 | 95 | 4 | 0 | 91 | 46.95925154 | -104.2510927 | 2020-12-11 05:26:59 | Wibaux, Montana, US |
1602633 | 1602633 | 2020-12-10 | US | North Dakota | Sheridan | 38083 | 92 | 2 | 0 | 91 | 47.57700669 | -100.3426391 | 2020-12-11 05:26:59 | Sheridan, North Dakota, US |
2977917 | 2977917 | 2020-12-09 | US | Pennsylvania | Sullivan | 42113 | 92 | 1 | 0 | 91 | 41.44634738 | -76.51246591 | 2020-12-10 05:26:19 | Sullivan, Pennsylvania, US |
2977971 | 2977971 | 2020-12-09 | US | Puerto Rico | Las Marias | 72083 | 91 | 0 | 0 | 91 | 18.23679 | -66.98362 | 2020-12-10 05:26:19 | Las Marias, Puerto Rico, US |
2348023 | 2348023 | 2020-12-07 | US | Colorado | Costilla | 8023 | 112 | 2 | 0 | 91 | 37.27732493 | -105.4276548 | 2020-12-08 05:27:42 | Costilla, Colorado, US |
2349344 | 2349344 | 2020-12-07 | US | Missouri | Mercer | 29129 | 92 | 1 | 0 | 91 | 40.42212303 | -93.5682959 | 2020-12-08 05:27:42 | Mercer, Missouri, US |
2350888 | 2350888 | 2020-12-07 | US | West Virginia | Calhoun | 54013 | 91 | 0 | 0 | 91 | 38.84315422 | -81.11934872 | 2020-12-08 05:27:42 | Calhoun, West Virginia, US |
1008214 | 1008214 | 2020-12-06 | US | Missouri | Mercer | 29129 | 92 | 1 | 0 | 91 | 40.42212303 | -93.5682959 | 2020-12-07 05:26:14 | Mercer, Missouri, US |
1632904 | 1632904 | 2020-12-05 | US | Colorado | Custer | 8027 | 119 | 1 | 0 | 91 | 38.10883162 | -105.3683478 | 2020-12-06 05:26:18 | Custer, Colorado, US |
3863203 | 3863203 | 2020-12-04 | US | Virginia | Norton | 51720 | 91 | 0 | 0 | 91 | 36.93357076 | -82.62750411 | 2020-12-05 05:27:36 | Norton, Virginia, US |
78402 | 78402 | 2020-12-03 | US | Virginia | Craig | 51045 | 92 | 1 | 0 | 91 | 37.48133648 | -80.21072274 | 2020-12-04 05:27:27 | Craig, Virginia, US |
2538712 | 2538712 | 2020-12-01 | US | Kansas | Osborne | 20141 | 91 | 0 | 0 | 91 | 39.3503437 | -98.76753828 | 2020-12-02 05:27:41 | Osborne, Kansas, US |
2540444 | 2540444 | 2020-12-01 | US | Texas | Cottle | 48101 | 87 | 4 | 0 | 91 | 34.07783319 | -100.2785062 | 2020-12-02 05:27:41 | Cottle, Texas, US |
2540782 | 2540782 | 2020-12-01 | US | Virginia | Rappahannock | 51157 | 93 | 2 | 0 | 91 | 38.68295619 | -78.15826963 | 2020-12-02 05:27:41 | Rappahannock, Virginia, US |
1585481 | 1585481 | 2020-11-30 | US | Kansas | Osborne | 20141 | 91 | 0 | 0 | 91 | 39.3503437 | -98.76753828 | 2020-12-01 05:26:18 | Osborne, Kansas, US |
1586259 | 1586259 | 2020-11-30 | US | Nebraska | Pawnee | 31133 | 91 | 0 | 0 | 91 | 40.13141096 | -96.23705437 | 2020-12-01 05:26:18 | Pawnee, Nebraska, US |
1587213 | 1587213 | 2020-11-30 | US | Texas | Cottle | 48101 | 87 | 4 | 0 | 91 | 34.07783319 | -100.2785062 | 2020-12-01 05:26:18 | Cottle, Texas, US |
3569616 | 3569616 | 2020-11-29 | US | Texas | Cottle | 48101 | 86 | 4 | 0 | 91 | 34.07783319 | -100.2785062 | 2020-11-30 05:26:13 | Cottle, Texas, US |
394976 | 394976 | 2020-11-27 | US | Puerto Rico | Lajas | 72079 | 91 | 0 | 0 | 91 | 18.011661 | -67.040585 | 2020-11-28 05:25:50 | Lajas, Puerto Rico, US |
926423 | 926423 | 2020-11-26 | US | Puerto Rico | Lajas | 72079 | 91 | 0 | 0 | 91 | 18.011661 | -67.040585 | 2020-11-27 05:26:53 | Lajas, Puerto Rico, US |
1351224 | 1351224 | 2020-11-24 | US | Idaho | Adams | 16003 | 93 | 2 | 0 | 91 | 44.89333571 | -116.4545247 | 2020-11-25 05:27:20 | Adams, Idaho, US |
1353829 | 1353829 | 2020-11-24 | US | West Virginia | Wirt | 54105 | 92 | 1 | 0 | 91 | 39.02775007 | -81.37473928 | 2020-11-25 05:27:20 | Wirt, West Virginia, US |
680293 | 680293 | 2020-11-23 | US | Montana | Daniels | 30019 | 94 | 3 | 0 | 91 | 48.78420029 | -105.54763429999998 | 2020-11-24 05:27:31 | Daniels, Montana, US |
2703536 | 2703536 | 2020-11-20 | US | Montana | Wheatland | 30107 | 94 | 3 | 0 | 91 | 46.46652491 | -109.8464636 | 2020-11-21 05:25:51 | Wheatland, Montana, US |
2703694 | 2703694 | 2020-11-20 | US | New Mexico | Guadalupe | 35019 | 93 | 2 | 0 | 91 | 34.86319296 | -104.790669 | 2020-11-21 05:25:51 | Guadalupe, New Mexico, US |
2704642 | 2704642 | 2020-11-20 | US | Texas | Kimble | 48267 | 101 | 2 | 0 | 91 | 30.48678918 | -99.74856473 | 2020-11-21 05:25:51 | Kimble, Texas, US |
822119 | 822119 | 2020-11-19 | US | California | Mariposa | 6043 | 93 | 2 | 0 | 91 | 37.57978556 | -119.9073334 | 2020-11-20 05:26:28 | Mariposa, California, US |
822829 | 822829 | 2020-11-19 | US | Kansas | Clark | 20025 | 95 | 4 | 0 | 91 | 37.23577007 | -99.81883015 | 2020-11-20 05:26:28 | Clark, Kansas, US |
823596 | 823596 | 2020-11-19 | US | Montana | Wheatland | 30107 | 94 | 3 | 0 | 91 | 46.46652491 | -109.8464636 | 2020-11-20 05:26:28 | Wheatland, Montana, US |
823630 | 823630 | 2020-11-19 | US | Nebraska | Frontier | 31063 | 92 | 1 | 0 | 91 | 40.52993007 | -100.3924658 | 2020-11-20 05:26:28 | Frontier, Nebraska, US |
824343 | 824343 | 2020-11-19 | US | Puerto Rico | Unassigned | 72999 | 1073 | 982 | 0 | 91 | 18.459681 | -67.336525 | 2020-11-20 05:26:28 | Unassigned, Puerto Rico, US |
824777 | 824777 | 2020-11-19 | US | Texas | Shackelford | 48417 | 80 | 0 | 0 | 91 | 32.73587756 | -99.35401337 | 2020-11-20 05:26:28 | Shackelford, Texas, US |
825074 | 825074 | 2020-11-19 | US | West Virginia | Tucker | 54093 | 91 | 0 | 0 | 91 | 39.11240885 | -79.57053576 | 2020-11-20 05:26:28 | Tucker, West Virginia, US |
123253 | 123253 | 2020-11-18 | US | California | Mariposa | 6043 | 93 | 2 | 0 | 91 | 37.57978556 | -119.9073334 | 2020-11-19 05:25:23 | Mariposa, California, US |
123328 | 123328 | 2020-11-18 | US | Colorado | Lincoln | 8073 | 124 | 0 | 0 | 91 | 38.98749519 | -103.5136649 | 2020-11-19 05:25:23 | Lincoln, Colorado, US |
123963 | 123963 | 2020-11-18 | US | Kansas | Clark | 20025 | 95 | 4 | 0 | 91 | 37.23577007 | -99.81883015 | 2020-11-19 05:25:23 | Clark, Kansas, US |
125911 | 125911 | 2020-11-18 | US | Texas | Shackelford | 48417 | 73 | 0 | 0 | 91 | 32.73587756 | -99.35401337 | 2020-11-19 05:25:23 | Shackelford, Texas, US |
3341010 | 3341010 | 2020-11-17 | US | North Dakota | Steele | 38091 | 96 | 1 | 0 | 91 | 47.45611548 | -97.72728747 | 2020-11-18 05:40:31 | Steele, North Dakota, US |
3172356 | 3172356 | 2020-11-16 | US | Puerto Rico | Ceiba | 72037 | 91 | 0 | 0 | 91 | 18.251818 | -65.666416 | 2020-11-17 05:25:54 | Ceiba, Puerto Rico, US |
3173102 | 3173102 | 2020-11-16 | US | West Virginia | Clay | 54015 | 94 | 3 | 0 | 91 | 38.46231092 | -81.07652217 | 2020-11-17 05:25:54 | Clay, West Virginia, US |
2882241 | 2882241 | 2020-11-15 | US | Nebraska | Boyd | 31015 | 93 | 2 | 0 | 91 | 42.8997274 | -98.76486568 | 2020-11-16 05:25:57 | Boyd, Nebraska, US |
2882924 | 2882924 | 2020-11-15 | US | Puerto Rico | Ceiba | 72037 | 91 | 0 | 0 | 91 | 18.251818 | -65.666416 | 2020-11-16 05:25:57 | Ceiba, Puerto Rico, US |
2882963 | 2882963 | 2020-11-15 | US | Puerto Rico | Penuelas | 72111 | 91 | 0 | 0 | 91 | 18.059645 | -66.721572 | 2020-11-16 05:25:57 | Penuelas, Puerto Rico, US |
2883481 | 2883481 | 2020-11-15 | US | Vermont | Orange | 50017 | 91 | 0 | 0 | 91 | 44.00470222 | -72.37640104 | 2020-11-16 05:25:57 | Orange, Vermont, US |
2883670 | 2883670 | 2020-11-15 | US | West Virginia | Clay | 54015 | 94 | 3 | 0 | 91 | 38.46231092 | -81.07652217 | 2020-11-16 05:25:57 | Clay, West Virginia, US |
2883705 | 2883705 | 2020-11-15 | US | West Virginia | Ritchie | 54085 | 92 | 1 | 0 | 91 | 39.18094587 | -81.06356878 | 2020-11-16 05:25:57 | Ritchie, West Virginia, US |
2917219 | 2917219 | 2020-11-14 | US | Nebraska | Boyd | 31015 | 93 | 2 | 0 | 91 | 42.8997274 | -98.76486568 | 2020-11-15 05:26:53 | Boyd, Nebraska, US |
2917293 | 2917293 | 2020-11-14 | US | Nebraska | Sherman | 31163 | 94 | 3 | 0 | 91 | 41.22045983 | -98.97588642 | 2020-11-15 05:26:53 | Sherman, Nebraska, US |
2917728 | 2917728 | 2020-11-14 | US | Oklahoma | Harmon | 40057 | 91 | 0 | 0 | 91 | 34.7440135 | -99.84741652 | 2020-11-15 05:26:53 | Harmon, Oklahoma, US |
2918062 | 2918062 | 2020-11-14 | US | South Dakota | McPherson | 46089 | 92 | 1 | 0 | 91 | 45.76626028 | -99.22118798 | 2020-11-15 05:26:53 | McPherson, South Dakota, US |
2918648 | 2918648 | 2020-11-14 | US | West Virginia | Clay | 54015 | 94 | 3 | 0 | 91 | 38.46231092 | -81.07652217 | 2020-11-15 05:26:53 | Clay, West Virginia, US |
2785945 | 2785945 | 2020-11-13 | US | Idaho | Oneida | 16071 | 91 | 0 | 0 | 91 | 42.19494279999999 | -112.5407838 | 2020-11-14 05:25:37 | Oneida, Idaho, US |
2787101 | 2787101 | 2020-11-13 | US | Nebraska | Perkins | 31135 | 101 | 10 | 0 | 91 | 40.85082525 | -101.6502942 | 2020-11-14 05:25:37 | Perkins, Nebraska, US |
2787550 | 2787550 | 2020-11-13 | US | Oklahoma | Harmon | 40057 | 91 | 0 | 0 | 91 | 34.7440135 | -99.84741652 | 2020-11-14 05:25:37 | Harmon, Oklahoma, US |
2787690 | 2787690 | 2020-11-13 | US | Pennsylvania | Potter | 42105 | 92 | 1 | 0 | 91 | 41.74471626 | -77.89559864 | 2020-11-14 05:25:37 | Potter, Pennsylvania, US |
2788036 | 2788036 | 2020-11-13 | US | Texas | Carson | 48065 | 127 | 2 | 0 | 91 | 35.40365929 | -101.3542669 | 2020-11-14 05:25:37 | Carson, Texas, US |
2788151 | 2788151 | 2020-11-13 | US | Texas | Lipscomb | 48295 | 100 | 1 | 0 | 91 | 36.27783108 | -100.2733151 | 2020-11-14 05:25:37 | Lipscomb, Texas, 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]);