johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,921 rows where active = 58 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 130
- Nebraska 85
- Kansas 81
- Virginia 74
- Kentucky 73
- Colorado 71
- Georgia 70
- Missouri 69
- Tennessee 63
- Michigan 60
- Minnesota 60
- Ohio 57
- Washington 57
- Iowa 52
- Oklahoma 51
- Illinois 50
- North Dakota 50
- Mississippi 45
- Pennsylvania 45
- New York 44
- North Carolina 43
- South Dakota 42
- Arkansas 38
- Indiana 37
- Wisconsin 34
- Idaho 33
- Montana 33
- Florida 32
- West Virginia 32
- Oregon 29
- …
country_or_region 1
- US · 1,921 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3980650 | 3980650 | 2021-02-10 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-11 05:23:55 | Hayes, Nebraska, US |
1528471 | 1528471 | 2021-02-09 | US | California | Sierra | 6091 | 56 | 0 | 0 | 58 | 39.57713498 | -120.52007009999998 | 2021-02-10 05:22:41 | Sierra, California, US |
1529970 | 1529970 | 2021-02-09 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-10 05:22:41 | Hayes, Nebraska, US |
614262 | 614262 | 2021-02-08 | US | California | Sierra | 6091 | 56 | 0 | 0 | 58 | 39.57713498 | -120.52007009999998 | 2021-02-09 05:23:30 | Sierra, California, US |
615761 | 615761 | 2021-02-08 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-09 05:23:30 | Hayes, Nebraska, US |
1674530 | 1674530 | 2021-02-07 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-08 05:22:39 | Hayes, Nebraska, US |
976991 | 976991 | 2021-02-06 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-07 05:23:00 | Hayes, Nebraska, US |
1590249 | 1590249 | 2021-02-05 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-06 05:23:55 | Hayes, Nebraska, US |
792456 | 792456 | 2021-02-04 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-05 05:22:38 | Hayes, Nebraska, US |
342348 | 342348 | 2021-02-03 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-04 05:22:26 | Hayes, Nebraska, US |
1686574 | 1686574 | 2021-02-02 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-03 05:22:52 | Hayes, Nebraska, US |
1678544 | 1678544 | 2021-02-01 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-02 05:22:49 | Hayes, Nebraska, US |
1461832 | 1461832 | 2021-01-31 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-02-01 05:22:53 | Hayes, Nebraska, US |
2213740 | 2213740 | 2021-01-30 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-31 05:22:42 | Hayes, Nebraska, US |
1897782 | 1897782 | 2021-01-29 | US | Colorado | Mineral | 8079 | 62 | 1 | 0 | 58 | 37.66954283 | -106.9281698 | 2021-01-30 05:22:49 | Mineral, Colorado, US |
1899227 | 1899227 | 2021-01-29 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-30 05:22:49 | Hayes, Nebraska, US |
2484043 | 2484043 | 2021-01-28 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-29 05:22:23 | Hayes, Nebraska, US |
3154179 | 3154179 | 2021-01-27 | US | California | Sierra | 6091 | 56 | 0 | 0 | 58 | 39.57713498 | -120.52007009999998 | 2021-01-28 05:22:24 | Sierra, California, US |
3155678 | 3155678 | 2021-01-27 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-28 05:22:24 | Hayes, Nebraska, US |
14413 | 14413 | 2021-01-26 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-27 05:23:41 | Hayes, Nebraska, US |
2569737 | 2569737 | 2021-01-25 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-26 05:22:02 | Hayes, Nebraska, US |
1761369 | 1761369 | 2021-01-24 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-25 05:22:16 | Hayes, Nebraska, US |
2428976 | 2428976 | 2021-01-23 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-24 05:22:35 | Hayes, Nebraska, US |
2468878 | 2468878 | 2021-01-22 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-23 05:22:03 | Hayes, Nebraska, US |
435961 | 435961 | 2021-01-21 | US | Colorado | Dolores | 8033 | 66 | 0 | 0 | 58 | 37.75208676 | -108.5211585 | 2021-01-22 05:22:10 | Dolores, Colorado, US |
437429 | 437429 | 2021-01-21 | US | Nebraska | Hayes | 31085 | 58 | 0 | 0 | 58 | 40.52451972 | -101.0603568 | 2021-01-22 05:22:10 | Hayes, Nebraska, US |
1095005 | 1095005 | 2021-01-20 | US | Idaho | Camas | 16025 | 58 | 0 | 0 | 58 | 43.46665742 | -114.8065892 | 2021-01-21 05:22:01 | Camas, Idaho, US |
909095 | 909095 | 2021-01-19 | US | Idaho | Camas | 16025 | 58 | 0 | 0 | 58 | 43.46665742 | -114.8065892 | 2021-01-20 05:21:54 | Camas, Idaho, US |
3880493 | 3880493 | 2021-01-14 | US | Idaho | Camas | 16025 | 58 | 0 | 0 | 58 | 43.46665742 | -114.8065892 | 2021-01-15 05:22:24 | Camas, Idaho, US |
2541840 | 2541840 | 2021-01-07 | US | Alaska | Yakutat | 2282 | 59 | 1 | 0 | 58 | 59.8909808 | -140.36014509999998 | 2021-01-08 05:22:42 | Yakutat, Alaska, US |
2543582 | 2543582 | 2021-01-07 | US | New Mexico | Catron | 35003 | 61 | 3 | 0 | 58 | 33.91514144 | -108.4046587 | 2021-01-08 05:22:42 | Catron, New Mexico, US |
2544537 | 2544537 | 2021-01-07 | US | Texas | Kent | 48263 | 59 | 1 | 0 | 58 | 33.18104136 | -100.7780939 | 2021-01-08 05:22:42 | Kent, Texas, US |
2544751 | 2544751 | 2021-01-07 | US | Virginia | Highland | 51091 | 58 | 0 | 0 | 58 | 38.35799465 | -79.56124594 | 2021-01-08 05:22:42 | Highland, Virginia, US |
2865149 | 2865149 | 2021-01-06 | US | Alaska | Yakutat | 2282 | 59 | 1 | 0 | 58 | 59.8909808 | -140.36014509999998 | 2021-01-07 05:22:03 | Yakutat, Alaska, US |
2867846 | 2867846 | 2021-01-06 | US | Texas | Kent | 48263 | 59 | 1 | 0 | 58 | 33.18104136 | -100.7780939 | 2021-01-07 05:22:03 | Kent, Texas, US |
1062715 | 1062715 | 2021-01-04 | US | Georgia | Taliaferro | 13265 | 58 | 0 | 0 | 58 | 33.56543317 | -82.88136816 | 2021-01-05 05:21:49 | Taliaferro, Georgia, US |
3231318 | 3231318 | 2021-01-03 | US | Georgia | Taliaferro | 13265 | 58 | 0 | 0 | 58 | 33.56543317 | -82.88136816 | 2021-01-04 05:22:02 | Taliaferro, Georgia, US |
2228387 | 2228387 | 2021-01-02 | US | Georgia | Taliaferro | 13265 | 58 | 0 | 0 | 58 | 33.56543317 | -82.88136816 | 2021-01-03 05:22:52 | Taliaferro, Georgia, US |
2410051 | 2410051 | 2020-12-23 | US | Texas | Terrell | 48443 | 52 | 1 | 0 | 58 | 30.22429013 | -102.0766732 | 2020-12-24 05:23:04 | Terrell, Texas, US |
2410105 | 2410105 | 2020-12-23 | US | Vermont | Grand Isle | 50013 | 58 | 0 | 0 | 58 | 44.7975824 | -73.29679772 | 2020-12-24 05:23:04 | Grand Isle, Vermont, US |
1903252 | 1903252 | 2020-12-18 | US | Nebraska | Logan | 31113 | 58 | 0 | 0 | 58 | 41.56650314 | -100.4817851 | 2020-12-19 05:27:52 | Logan, Nebraska, US |
2128405 | 2128405 | 2020-12-17 | US | Alaska | Denali | 2068 | 58 | 0 | 0 | 58 | 63.67264044 | -150.0076108 | 2020-12-18 05:28:18 | Denali, Alaska, US |
2130078 | 2130078 | 2020-12-17 | US | Nebraska | Logan | 31113 | 58 | 0 | 0 | 58 | 41.56650314 | -100.4817851 | 2020-12-18 05:28:18 | Logan, Nebraska, US |
2131069 | 2131069 | 2020-12-17 | US | Texas | Foard | 48155 | 41 | 4 | 0 | 58 | 33.97308618 | -99.7767797 | 2020-12-18 05:28:18 | Foard, Texas, US |
3150005 | 3150005 | 2020-12-16 | US | Alaska | Denali | 2068 | 58 | 0 | 0 | 58 | 63.67264044 | -150.0076108 | 2020-12-17 05:28:12 | Denali, Alaska, US |
3151678 | 3151678 | 2020-12-16 | US | Nebraska | Logan | 31113 | 58 | 0 | 0 | 58 | 41.56650314 | -100.4817851 | 2020-12-17 05:28:12 | Logan, Nebraska, US |
848214 | 848214 | 2020-12-12 | US | Pennsylvania | Cameron | 42023 | 59 | 1 | 0 | 58 | 41.43625568 | -78.20376845 | 2020-12-13 05:27:20 | Cameron, Pennsylvania, US |
1821378 | 1821378 | 2020-12-08 | US | Oklahoma | Unassigned | 90040 | 58 | 0 | 0 | 58 | 36.83532655 | 0.0 | 2020-12-09 05:28:01 | Unassigned, Oklahoma, US |
2349561 | 2349561 | 2020-12-07 | US | Nevada | Storey | 32029 | 60 | 2 | 0 | 58 | 39.44875482 | -119.5250207 | 2020-12-08 05:27:42 | Storey, Nevada, US |
2350014 | 2350014 | 2020-12-07 | US | Oklahoma | Unassigned | 90040 | 58 | 0 | 0 | 58 | 36.83532655 | 0.0 | 2020-12-08 05:27:42 | Unassigned, Oklahoma, US |
1006720 | 1006720 | 2020-12-06 | US | Alaska | Prince of Wales-Hyder | 2198 | 59 | 1 | 0 | 58 | 55.76261984 | -133.0511621 | 2020-12-07 05:26:14 | Prince of Wales-Hyder, Alaska, US |
1008431 | 1008431 | 2020-12-06 | US | Nevada | Storey | 32029 | 60 | 2 | 0 | 58 | 39.44875482 | -119.5250207 | 2020-12-07 05:26:14 | Storey, Nevada, US |
1008884 | 1008884 | 2020-12-06 | US | Oklahoma | Unassigned | 90040 | 58 | 0 | 0 | 58 | 36.83532655 | 0.0 | 2020-12-07 05:26:14 | Unassigned, Oklahoma, US |
1632729 | 1632729 | 2020-12-05 | US | Alaska | Prince of Wales-Hyder | 2198 | 59 | 1 | 0 | 58 | 55.76261984 | -133.0511621 | 2020-12-06 05:26:18 | Prince of Wales-Hyder, Alaska, US |
78361 | 78361 | 2020-12-03 | US | Vermont | Essex | 50009 | 58 | 0 | 0 | 58 | 44.72736416 | -71.73579864 | 2020-12-04 05:27:27 | Essex, Vermont, US |
740438 | 740438 | 2020-12-02 | US | Nevada | Storey | 32029 | 59 | 1 | 0 | 58 | 39.44875482 | -119.5250207 | 2020-12-03 05:28:22 | Storey, Nevada, US |
2538666 | 2538666 | 2020-12-01 | US | Kansas | Elk | 20049 | 58 | 0 | 0 | 58 | 37.45338105 | -96.24369667 | 2020-12-02 05:27:41 | Elk, Kansas, US |
2539532 | 2539532 | 2020-12-01 | US | Nevada | Storey | 32029 | 58 | 0 | 0 | 58 | 39.44875482 | -119.5250207 | 2020-12-02 05:27:41 | Storey, Nevada, US |
2540573 | 2540573 | 2020-12-01 | US | Texas | Oldham | 48359 | 111 | 2 | 0 | 58 | 35.40425596 | -102.6027606 | 2020-12-02 05:27:41 | Oldham, Texas, US |
1585435 | 1585435 | 2020-11-30 | US | Kansas | Elk | 20049 | 58 | 0 | 0 | 58 | 37.45338105 | -96.24369667 | 2020-12-01 05:26:18 | Elk, Kansas, US |
3568624 | 3568624 | 2020-11-29 | US | Nebraska | Dundy | 31057 | 60 | 2 | 0 | 58 | 40.17638677 | -101.6876522 | 2020-11-30 05:26:13 | Dundy, Nebraska, US |
3569256 | 3569256 | 2020-11-29 | US | Pennsylvania | Sullivan | 42113 | 59 | 1 | 0 | 58 | 41.44634738 | -76.51246591 | 2020-11-30 05:26:13 | Sullivan, Pennsylvania, US |
2935828 | 2935828 | 2020-11-28 | US | Colorado | Cheyenne | 8017 | 75 | 5 | 0 | 58 | 38.82777431 | -102.6032558 | 2020-11-29 05:25:55 | Cheyenne, Colorado, US |
2937289 | 2937289 | 2020-11-28 | US | Nebraska | Dundy | 31057 | 60 | 2 | 0 | 58 | 40.17638677 | -101.6876522 | 2020-11-29 05:25:55 | Dundy, Nebraska, US |
1974644 | 1974644 | 2020-11-25 | US | Nebraska | Dundy | 31057 | 60 | 2 | 0 | 58 | 40.17638677 | -101.6876522 | 2020-11-26 05:27:44 | Dundy, Nebraska, US |
1353747 | 1353747 | 2020-11-24 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-25 05:27:20 | Garfield, Washington, US |
680011 | 680011 | 2020-11-23 | US | Minnesota | Cook | 27031 | 58 | 0 | 0 | 58 | 47.90504893 | -90.52629546 | 2020-11-24 05:27:31 | Cook, Minnesota, US |
681605 | 681605 | 2020-11-23 | US | Virginia | Bath | 51017 | 58 | 0 | 0 | 58 | 38.05852573 | -79.73912095 | 2020-11-24 05:27:31 | Bath, Virginia, US |
681741 | 681741 | 2020-11-23 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-24 05:27:31 | Garfield, Washington, US |
3191976 | 3191976 | 2020-11-22 | US | Montana | Garfield | 30033 | 59 | 1 | 0 | 58 | 47.27545948 | -107.0002351 | 2020-11-23 05:25:26 | Garfield, Montana, US |
3193417 | 3193417 | 2020-11-22 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-23 05:25:26 | Garfield, Washington, US |
3838470 | 3838470 | 2020-11-21 | US | Montana | Garfield | 30033 | 59 | 1 | 0 | 58 | 47.27545948 | -107.0002351 | 2020-11-22 05:25:45 | Garfield, Montana, US |
3839911 | 3839911 | 2020-11-21 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-22 05:25:45 | Garfield, Washington, US |
2703480 | 2703480 | 2020-11-20 | US | Missouri | Worth | 29227 | 58 | 0 | 0 | 58 | 40.47945588 | -94.42328751 | 2020-11-21 05:25:51 | Worth, Missouri, US |
2703498 | 2703498 | 2020-11-20 | US | Montana | Garfield | 30033 | 59 | 1 | 0 | 58 | 47.27545948 | -107.0002351 | 2020-11-21 05:25:51 | Garfield, Montana, US |
2704939 | 2704939 | 2020-11-20 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-21 05:25:51 | Garfield, Washington, US |
822459 | 822459 | 2020-11-19 | US | Georgia | Webster | 13307 | 60 | 2 | 0 | 58 | 32.04066113 | -84.54742852 | 2020-11-20 05:26:28 | Webster, Georgia, US |
823567 | 823567 | 2020-11-19 | US | Montana | Liberty | 30051 | 59 | 1 | 0 | 58 | 48.56084317 | -111.024307 | 2020-11-20 05:26:28 | Liberty, Montana, US |
824999 | 824999 | 2020-11-19 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-20 05:26:28 | Garfield, Washington, US |
123593 | 123593 | 2020-11-18 | US | Georgia | Webster | 13307 | 60 | 2 | 0 | 58 | 32.04066113 | -84.54742852 | 2020-11-19 05:25:23 | Webster, Georgia, US |
126133 | 126133 | 2020-11-18 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-19 05:25:23 | Garfield, Washington, US |
3341121 | 3341121 | 2020-11-17 | US | Oklahoma | Cimarron | 40025 | 58 | 0 | 0 | 58 | 36.74817177 | -102.5173885 | 2020-11-18 05:40:31 | Cimarron, Oklahoma, US |
3342021 | 3342021 | 2020-11-17 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-18 05:40:31 | Garfield, Washington, US |
3171090 | 3171090 | 2020-11-16 | US | Kentucky | Robertson | 21201 | 60 | 2 | 0 | 58 | 38.51923469 | -84.05055616 | 2020-11-17 05:25:54 | Robertson, Kentucky, US |
3172769 | 3172769 | 2020-11-16 | US | Texas | Kimble | 48267 | 79 | 2 | 0 | 58 | 30.48678918 | -99.74856473 | 2020-11-17 05:25:54 | Kimble, Texas, US |
3173066 | 3173066 | 2020-11-16 | US | Washington | Garfield | 53023 | 59 | 1 | 0 | 58 | 46.43197502 | -117.5454032 | 2020-11-17 05:25:54 | Garfield, Washington, US |
2880804 | 2880804 | 2020-11-15 | US | Colorado | Costilla | 8023 | 71 | 2 | 0 | 58 | 37.27732493 | -105.4276548 | 2020-11-16 05:25:57 | Costilla, Colorado, US |
2883337 | 2883337 | 2020-11-15 | US | Texas | Kimble | 48267 | 77 | 2 | 0 | 58 | 30.48678918 | -99.74856473 | 2020-11-16 05:25:57 | Kimble, Texas, US |
2915782 | 2915782 | 2020-11-14 | US | Colorado | Costilla | 8023 | 70 | 2 | 0 | 58 | 37.27732493 | -105.4276548 | 2020-11-15 05:26:53 | Costilla, Colorado, US |
2918315 | 2918315 | 2020-11-14 | US | Texas | Kimble | 48267 | 76 | 2 | 0 | 58 | 30.48678918 | -99.74856473 | 2020-11-15 05:26:53 | Kimble, Texas, US |
2785645 | 2785645 | 2020-11-13 | US | Colorado | Rio Blanco | 8103 | 108 | 1 | 0 | 58 | 39.97913541 | -108.2179009 | 2020-11-14 05:25:37 | Rio Blanco, Colorado, US |
2786031 | 2786031 | 2020-11-13 | US | Illinois | Pope | 17151 | 59 | 1 | 0 | 58 | 37.41391284 | -88.56152109 | 2020-11-14 05:25:37 | Pope, Illinois, US |
2787613 | 2787613 | 2020-11-13 | US | Oregon | Harney | 41025 | 58 | 0 | 0 | 58 | 43.06422669 | -118.9666306 | 2020-11-14 05:25:37 | Harney, Oregon, US |
2787619 | 2787619 | 2020-11-13 | US | Oregon | Lake | 41037 | 58 | 0 | 0 | 58 | 42.79246693 | -120.3850163 | 2020-11-14 05:25:37 | Lake, Oregon, US |
865796 | 865796 | 2020-11-12 | US | Illinois | Pope | 17151 | 59 | 1 | 0 | 58 | 37.41391284 | -88.56152109 | 2020-11-13 05:25:30 | Pope, Illinois, US |
866751 | 866751 | 2020-11-12 | US | Montana | Daniels | 30019 | 61 | 3 | 0 | 58 | 48.78420029 | -105.54763429999998 | 2020-11-13 05:25:30 | Daniels, Montana, US |
866921 | 866921 | 2020-11-12 | US | New Hampshire | Unassigned | 90033 | 58 | 0 | 0 | 58 | 44.69063265 | 0.0 | 2020-11-13 05:25:30 | Unassigned, New Hampshire, US |
3442795 | 3442795 | 2020-11-11 | US | Montana | Daniels | 30019 | 61 | 3 | 0 | 58 | 48.78420029 | -105.54763429999998 | 2020-11-12 05:25:55 | Daniels, Montana, US |
3442874 | 3442874 | 2020-11-11 | US | Nebraska | Frontier | 31063 | 59 | 1 | 0 | 58 | 40.52993007 | -100.3924658 | 2020-11-12 05:25:55 | Frontier, Nebraska, US |
3442878 | 3442878 | 2020-11-11 | US | Nebraska | Garfield | 31071 | 58 | 0 | 0 | 58 | 41.91428955 | -98.99111827 | 2020-11-12 05:25:55 | Garfield, Nebraska, 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]);