johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,387 rows where active = 89 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 98
- Kansas 80
- Kentucky 70
- Virginia 67
- Michigan 61
- Missouri 61
- Georgia 57
- Nebraska 56
- Minnesota 52
- Iowa 46
- Illinois 43
- North Carolina 43
- Ohio 40
- Puerto Rico 38
- Oklahoma 34
- Arkansas 30
- Pennsylvania 30
- Tennessee 30
- Washington 30
- Mississippi 29
- New York 28
- South Dakota 28
- West Virginia 28
- Indiana 27
- Colorado 25
- North Dakota 25
- Oregon 24
- Louisiana 23
- Montana 21
- Wisconsin 21
- …
country_or_region 1
- US · 1,387 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2369764 | 2369764 | 2021-02-28 | US | New York | Unassigned | 90036 | 219 | 130 | 0 | 89 | 44.74530905 | 0.0 | 2021-03-01 05:23:01 | Unassigned, New York, US |
2185638 | 2185638 | 2021-02-26 | US | Nebraska | Deuel | 31049 | 91 | 2 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-27 05:22:28 | Deuel, Nebraska, US |
1860060 | 1860060 | 2021-02-25 | US | Nebraska | Deuel | 31049 | 91 | 2 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-26 05:22:40 | Deuel, Nebraska, US |
1861351 | 1861351 | 2021-02-25 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-26 05:22:40 | Highland, Virginia, US |
282238 | 282238 | 2021-02-24 | US | Nebraska | Deuel | 31049 | 91 | 2 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-25 05:24:57 | Deuel, Nebraska, US |
283529 | 283529 | 2021-02-24 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-25 05:24:57 | Highland, Virginia, US |
745660 | 745660 | 2021-02-20 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-21 05:24:33 | Highland, Virginia, US |
474758 | 474758 | 2021-02-19 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-20 05:22:51 | Highland, Virginia, US |
3603096 | 3603096 | 2021-02-17 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-18 05:22:58 | Deuel, Nebraska, US |
3052231 | 3052231 | 2021-02-16 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-17 05:23:10 | Deuel, Nebraska, US |
1340330 | 1340330 | 2021-02-15 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-16 05:24:38 | Deuel, Nebraska, US |
2285481 | 2285481 | 2021-02-14 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-15 05:24:49 | Deuel, Nebraska, US |
2679881 | 2679881 | 2021-02-13 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-14 05:23:43 | Deuel, Nebraska, US |
3541514 | 3541514 | 2021-02-12 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-13 05:22:12 | Deuel, Nebraska, US |
2639777 | 2639777 | 2021-02-11 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-12 05:23:29 | Deuel, Nebraska, US |
342330 | 342330 | 2021-02-03 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-04 05:22:26 | Deuel, Nebraska, US |
1686556 | 1686556 | 2021-02-02 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-03 05:22:52 | Deuel, Nebraska, US |
1687368 | 1687368 | 2021-02-02 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-02-03 05:22:52 | Harding, South Dakota, US |
1678526 | 1678526 | 2021-02-01 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-02 05:22:49 | Deuel, Nebraska, US |
1679338 | 1679338 | 2021-02-01 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-02-02 05:22:49 | Harding, South Dakota, US |
1461814 | 1461814 | 2021-01-31 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-01 05:22:53 | Deuel, Nebraska, US |
1462626 | 1462626 | 2021-01-31 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-02-01 05:22:53 | Harding, South Dakota, US |
2213722 | 2213722 | 2021-01-30 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-01-31 05:22:42 | Deuel, Nebraska, US |
2214534 | 2214534 | 2021-01-30 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-01-31 05:22:42 | Harding, South Dakota, US |
1899209 | 1899209 | 2021-01-29 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-01-30 05:22:49 | Deuel, Nebraska, US |
1900021 | 1900021 | 2021-01-29 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-01-30 05:22:49 | Harding, South Dakota, US |
2484025 | 2484025 | 2021-01-28 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-01-29 05:22:23 | Deuel, Nebraska, US |
2484837 | 2484837 | 2021-01-28 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-01-29 05:22:23 | Harding, South Dakota, US |
3155660 | 3155660 | 2021-01-27 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-01-28 05:22:24 | Deuel, Nebraska, US |
3156472 | 3156472 | 2021-01-27 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-01-28 05:22:24 | Harding, South Dakota, US |
3157031 | 3157031 | 2021-01-27 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-28 05:22:24 | Columbia, Washington, US |
14395 | 14395 | 2021-01-26 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-01-27 05:23:41 | Deuel, Nebraska, US |
15207 | 15207 | 2021-01-26 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-01-27 05:23:41 | Harding, South Dakota, US |
15766 | 15766 | 2021-01-26 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-27 05:23:41 | Columbia, Washington, US |
2570531 | 2570531 | 2021-01-25 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-01-26 05:22:02 | Harding, South Dakota, US |
2571090 | 2571090 | 2021-01-25 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-26 05:22:02 | Columbia, Washington, US |
1762163 | 1762163 | 2021-01-24 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-01-25 05:22:16 | Harding, South Dakota, US |
1762414 | 1762414 | 2021-01-24 | US | Texas | Irion | 48235 | 86 | 1 | 0 | 89 | 31.30375559 | -100.982439 | 2021-01-25 05:22:16 | Irion, Texas, US |
1762722 | 1762722 | 2021-01-24 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-25 05:22:16 | Columbia, Washington, US |
2430329 | 2430329 | 2021-01-23 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-24 05:22:35 | Columbia, Washington, US |
2470231 | 2470231 | 2021-01-22 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-23 05:22:03 | Columbia, Washington, US |
438782 | 438782 | 2021-01-21 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-22 05:22:10 | Columbia, Washington, US |
1097513 | 1097513 | 2021-01-20 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-21 05:22:01 | Columbia, Washington, US |
911603 | 911603 | 2021-01-19 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-20 05:21:54 | Columbia, Washington, US |
911624 | 911624 | 2021-01-19 | US | Washington | San Juan | 53055 | 89 | 0 | 0 | 89 | 48.60182783 | -122.96745 | 2021-01-20 05:21:54 | San Juan, Washington, US |
240666 | 240666 | 2021-01-18 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-19 05:22:15 | Columbia, Washington, US |
3506783 | 3506783 | 2021-01-17 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-18 05:22:34 | Columbia, Washington, US |
3104866 | 3104866 | 2021-01-16 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-17 05:22:17 | Columbia, Washington, US |
3518828 | 3518828 | 2021-01-15 | US | Washington | Columbia | 53013 | 93 | 4 | 0 | 89 | 46.29442881 | -117.9051983 | 2021-01-16 05:22:40 | Columbia, Washington, US |
3882204 | 3882204 | 2021-01-14 | US | Oregon | Wallowa | 41063 | 92 | 3 | 0 | 89 | 45.57894064 | -117.18353799999998 | 2021-01-15 05:22:24 | Wallowa, Oregon, US |
3883021 | 3883021 | 2021-01-14 | US | Washington | San Juan | 53055 | 89 | 0 | 0 | 89 | 48.60182783 | -122.96745 | 2021-01-15 05:22:24 | San Juan, Washington, US |
3310831 | 3310831 | 2021-01-13 | US | Oregon | Wallowa | 41063 | 92 | 3 | 0 | 89 | 45.57894064 | -117.18353799999998 | 2021-01-14 05:22:32 | Wallowa, Oregon, US |
776976 | 776976 | 2021-01-12 | US | Oregon | Wallowa | 41063 | 92 | 3 | 0 | 89 | 45.57894064 | -117.18353799999998 | 2021-01-13 05:22:15 | Wallowa, Oregon, US |
192697 | 192697 | 2021-01-11 | US | Oregon | Wallowa | 41063 | 92 | 3 | 0 | 89 | 45.57894064 | -117.18353799999998 | 2021-01-12 05:22:15 | Wallowa, Oregon, US |
2628500 | 2628500 | 2021-01-10 | US | Oregon | Wallowa | 41063 | 92 | 3 | 0 | 89 | 45.57894064 | -117.18353799999998 | 2021-01-11 05:21:50 | Wallowa, Oregon, US |
3037518 | 3037518 | 2021-01-05 | US | Texas | Stonewall | 48433 | 91 | 3 | 0 | 89 | 33.17906744 | -100.2538401 | 2021-01-06 05:22:16 | Stonewall, Texas, US |
3764669 | 3764669 | 2020-12-28 | US | Texas | Glasscock | 48173 | 82 | 1 | 0 | 89 | 31.86942909 | -101.5207776 | 2020-12-29 05:22:37 | Glasscock, Texas, US |
3780681 | 3780681 | 2020-12-27 | US | Puerto Rico | Vieques | 72147 | 89 | 0 | 0 | 89 | 18.123276 | -65.44097099999999 | 2020-12-28 05:22:06 | Vieques, Puerto Rico, US |
3780989 | 3780989 | 2020-12-27 | US | Texas | Glasscock | 48173 | 81 | 1 | 0 | 89 | 31.86942909 | -101.5207776 | 2020-12-28 05:22:06 | Glasscock, Texas, US |
2226286 | 2226286 | 2020-12-26 | US | Puerto Rico | Vieques | 72147 | 89 | 0 | 0 | 89 | 18.123276 | -65.44097099999999 | 2020-12-27 05:22:55 | Vieques, Puerto Rico, US |
2226594 | 2226594 | 2020-12-26 | US | Texas | Glasscock | 48173 | 80 | 1 | 0 | 89 | 31.86942909 | -101.5207776 | 2020-12-27 05:22:55 | Glasscock, Texas, US |
204313 | 204313 | 2020-12-25 | US | Nebraska | Dundy | 31057 | 93 | 4 | 0 | 89 | 40.17638677 | -101.6876522 | 2020-12-26 05:22:28 | Dundy, Nebraska, US |
205033 | 205033 | 2020-12-25 | US | Puerto Rico | Vieques | 72147 | 89 | 0 | 0 | 89 | 18.123276 | -65.44097099999999 | 2020-12-26 05:22:28 | Vieques, Puerto Rico, US |
3693536 | 3693536 | 2020-12-24 | US | Nebraska | Dundy | 31057 | 93 | 4 | 0 | 89 | 40.17638677 | -101.6876522 | 2020-12-25 05:22:48 | Dundy, Nebraska, US |
3694256 | 3694256 | 2020-12-24 | US | Puerto Rico | Vieques | 72147 | 89 | 0 | 0 | 89 | 18.123276 | -65.44097099999999 | 2020-12-25 05:22:48 | Vieques, Puerto Rico, US |
2409059 | 2409059 | 2020-12-23 | US | New York | Hamilton | 36041 | 90 | 1 | 0 | 89 | 43.66146647 | -74.49721957 | 2020-12-24 05:23:04 | Hamilton, New York, US |
2409608 | 2409608 | 2020-12-23 | US | Puerto Rico | Vieques | 72147 | 89 | 0 | 0 | 89 | 18.123276 | -65.44097099999999 | 2020-12-24 05:23:04 | Vieques, Puerto Rico, US |
3771159 | 3771159 | 2020-12-22 | US | Kansas | Greeley | 20071 | 90 | 1 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-23 05:22:03 | Greeley, Kansas, US |
928975 | 928975 | 2020-12-21 | US | Kansas | Greeley | 20071 | 90 | 1 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-22 05:22:33 | Greeley, Kansas, US |
2120996 | 2120996 | 2020-12-20 | US | Kansas | Greeley | 20071 | 90 | 1 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-21 05:27:58 | Greeley, Kansas, US |
2932503 | 2932503 | 2020-12-19 | US | Kansas | Greeley | 20071 | 90 | 1 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-20 05:27:32 | Greeley, Kansas, US |
2932772 | 2932772 | 2020-12-19 | US | Maine | Piscataquis | 23021 | 90 | 1 | 0 | 89 | 45.83839062 | -69.2860223 | 2020-12-20 05:27:32 | Piscataquis, Maine, US |
1902449 | 1902449 | 2020-12-18 | US | Kansas | Greeley | 20071 | 90 | 1 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-19 05:27:52 | Greeley, Kansas, US |
1903176 | 1903176 | 2020-12-18 | US | Montana | Powder River | 30075 | 94 | 5 | 0 | 89 | 45.39617714 | -105.636738 | 2020-12-19 05:27:52 | Powder River, Montana, US |
2130002 | 2130002 | 2020-12-17 | US | Montana | Powder River | 30075 | 94 | 5 | 0 | 89 | 45.39617714 | -105.636738 | 2020-12-18 05:28:18 | Powder River, Montana, US |
3150447 | 3150447 | 2020-12-16 | US | Georgia | Quitman | 13239 | 90 | 1 | 0 | 89 | 31.86728114 | -85.01773177 | 2020-12-17 05:28:12 | Quitman, Georgia, US |
3151602 | 3151602 | 2020-12-16 | US | Montana | Powder River | 30075 | 94 | 5 | 0 | 89 | 45.39617714 | -105.636738 | 2020-12-17 05:28:12 | Powder River, Montana, US |
3151696 | 3151696 | 2020-12-16 | US | Nebraska | Rock | 31149 | 91 | 2 | 0 | 89 | 42.42252217 | -99.44832069 | 2020-12-17 05:28:12 | Rock, Nebraska, US |
1035228 | 1035228 | 2020-12-15 | US | Georgia | Quitman | 13239 | 90 | 1 | 0 | 89 | 31.86728114 | -85.01773177 | 2020-12-16 05:28:04 | Quitman, Georgia, US |
1035656 | 1035656 | 2020-12-15 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-16 05:28:04 | Greeley, Kansas, US |
1752550 | 1752550 | 2020-12-14 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-15 05:26:38 | Greeley, Kansas, US |
1753371 | 1753371 | 2020-12-14 | US | Nebraska | Rock | 31149 | 91 | 2 | 0 | 89 | 42.42252217 | -99.44832069 | 2020-12-15 05:26:38 | Rock, Nebraska, US |
3849070 | 3849070 | 2020-12-13 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-14 05:26:27 | Greeley, Kansas, US |
3849891 | 3849891 | 2020-12-13 | US | Nebraska | Rock | 31149 | 91 | 2 | 0 | 89 | 42.42252217 | -99.44832069 | 2020-12-14 05:26:27 | Rock, Nebraska, US |
846852 | 846852 | 2020-12-12 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-13 05:27:20 | Greeley, Kansas, US |
847673 | 847673 | 2020-12-12 | US | Nebraska | Rock | 31149 | 91 | 2 | 0 | 89 | 42.42252217 | -99.44832069 | 2020-12-13 05:27:20 | Rock, Nebraska, US |
861959 | 861959 | 2020-12-11 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-12 05:26:19 | Greeley, Kansas, US |
862780 | 862780 | 2020-12-11 | US | Nebraska | Rock | 31149 | 91 | 2 | 0 | 89 | 42.42252217 | -99.44832069 | 2020-12-12 05:26:19 | Rock, Nebraska, US |
1601501 | 1601501 | 2020-12-10 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-11 05:26:59 | Greeley, Kansas, US |
1603512 | 1603512 | 2020-12-10 | US | Virginia | Bath | 51017 | 89 | 0 | 0 | 89 | 38.05852573 | -79.73912095 | 2020-12-11 05:26:59 | Bath, Virginia, US |
2976510 | 2976510 | 2020-12-09 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-10 05:26:19 | Greeley, Kansas, US |
2977255 | 2977255 | 2020-12-09 | US | Montana | Wibaux | 30109 | 93 | 4 | 0 | 89 | 46.95925154 | -104.2510927 | 2020-12-10 05:26:19 | Wibaux, Montana, US |
2977642 | 2977642 | 2020-12-09 | US | North Dakota | Sheridan | 38083 | 92 | 2 | 0 | 89 | 47.57700669 | -100.3426391 | 2020-12-10 05:26:19 | Sheridan, North Dakota, US |
1820070 | 1820070 | 2020-12-08 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-09 05:28:01 | Greeley, Kansas, US |
1820487 | 1820487 | 2020-12-08 | US | Minnesota | Cook | 27031 | 89 | 0 | 0 | 89 | 47.90504893 | -90.52629546 | 2020-12-09 05:28:01 | Cook, Minnesota, US |
1820758 | 1820758 | 2020-12-08 | US | Missouri | Worth | 29227 | 89 | 0 | 0 | 89 | 40.47945588 | -94.42328751 | 2020-12-09 05:28:01 | Worth, Missouri, US |
1822297 | 1822297 | 2020-12-08 | US | West Virginia | Webster | 54101 | 89 | 0 | 0 | 89 | 38.49370949 | -80.4202023 | 2020-12-09 05:28:01 | Webster, West Virginia, US |
2348706 | 2348706 | 2020-12-07 | US | Kansas | Greeley | 20071 | 89 | 0 | 0 | 89 | 38.4808095 | -101.8061079 | 2020-12-08 05:27:42 | Greeley, Kansas, US |
2349394 | 2349394 | 2020-12-07 | US | Missouri | Worth | 29227 | 89 | 0 | 0 | 89 | 40.47945588 | -94.42328751 | 2020-12-08 05:27:42 | Worth, Missouri, US |
1007557 | 1007557 | 2020-12-06 | US | Kansas | Comanche | 20033 | 90 | 1 | 0 | 89 | 37.19114520000001 | -99.27113247 | 2020-12-07 05:26:14 | Comanche, Kansas, 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]);