johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,420 rows where active = 39 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 173
- Nebraska 110
- Kansas 108
- Kentucky 105
- Illinois 103
- Georgia 102
- Virginia 101
- West Virginia 78
- Michigan 77
- Missouri 71
- North Dakota 71
- South Dakota 71
- Minnesota 68
- Indiana 66
- Iowa 66
- Oklahoma 66
- Montana 61
- Wyoming 61
- Colorado 58
- Tennessee 57
- Wisconsin 56
- Alaska 52
- North Carolina 50
- Ohio 50
- Arkansas 48
- Pennsylvania 47
- Mississippi 41
- California 34
- New York 34
- Alabama 32
- …
country_or_region 1
- US · 2,420 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2213755 | 2213755 | 2021-01-30 | US | Nebraska | Loup | 31115 | 39 | 0 | 0 | 39 | 41.91371961 | -99.45440415 | 2021-01-31 05:22:42 | Loup, Nebraska, US |
1899242 | 1899242 | 2021-01-29 | US | Nebraska | Loup | 31115 | 39 | 0 | 0 | 39 | 41.91371961 | -99.45440415 | 2021-01-30 05:22:49 | Loup, Nebraska, US |
2484058 | 2484058 | 2021-01-28 | US | Nebraska | Loup | 31115 | 39 | 0 | 0 | 39 | 41.91371961 | -99.45440415 | 2021-01-29 05:22:23 | Loup, Nebraska, US |
3155693 | 3155693 | 2021-01-27 | US | Nebraska | Loup | 31115 | 39 | 0 | 0 | 39 | 41.91371961 | -99.45440415 | 2021-01-28 05:22:24 | Loup, Nebraska, US |
14428 | 14428 | 2021-01-26 | US | Nebraska | Loup | 31115 | 39 | 0 | 0 | 39 | 41.91371961 | -99.45440415 | 2021-01-27 05:23:41 | Loup, Nebraska, US |
910259 | 910259 | 2021-01-19 | US | Nebraska | Keya Paha | 31103 | 39 | 0 | 0 | 39 | 42.87990694 | -99.71343729 | 2021-01-20 05:21:54 | Keya Paha, Nebraska, US |
239322 | 239322 | 2021-01-18 | US | Nebraska | Keya Paha | 31103 | 39 | 0 | 0 | 39 | 42.87990694 | -99.71343729 | 2021-01-19 05:22:15 | Keya Paha, Nebraska, US |
3879982 | 3879982 | 2021-01-14 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-15 05:22:24 | Aleutians East, Alaska, US |
3308609 | 3308609 | 2021-01-13 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-14 05:22:32 | Aleutians East, Alaska, US |
774754 | 774754 | 2021-01-12 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-13 05:22:15 | Aleutians East, Alaska, US |
190475 | 190475 | 2021-01-11 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-12 05:22:15 | Aleutians East, Alaska, US |
2626278 | 2626278 | 2021-01-10 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-11 05:21:50 | Aleutians East, Alaska, US |
3900366 | 3900366 | 2021-01-09 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-10 05:22:12 | Aleutians East, Alaska, US |
154389 | 154389 | 2021-01-08 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-09 05:22:18 | Aleutians East, Alaska, US |
154556 | 154556 | 2021-01-08 | US | California | Sierra | 6091 | 37 | 0 | 0 | 39 | 39.57713498 | -120.52007009999998 | 2021-01-09 05:22:18 | Sierra, California, US |
2541813 | 2541813 | 2021-01-07 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-08 05:22:42 | Aleutians East, Alaska, US |
2541980 | 2541980 | 2021-01-07 | US | California | Sierra | 6091 | 37 | 0 | 0 | 39 | 39.57713498 | -120.52007009999998 | 2021-01-08 05:22:42 | Sierra, California, US |
2542023 | 2542023 | 2021-01-07 | US | Colorado | Jackson | 8057 | 47 | 0 | 0 | 39 | 40.66593870000001 | -106.3408905 | 2021-01-08 05:22:42 | Jackson, Colorado, US |
2543493 | 2543493 | 2021-01-07 | US | Nebraska | Loup | 31115 | 39 | 0 | 0 | 39 | 41.91371961 | -99.45440415 | 2021-01-08 05:22:42 | Loup, Nebraska, US |
2543536 | 2543536 | 2021-01-07 | US | Nevada | Eureka | 32011 | 39 | 0 | 0 | 39 | 39.98100864 | -116.2683204 | 2021-01-08 05:22:42 | Eureka, Nevada, US |
2865122 | 2865122 | 2021-01-06 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-07 05:22:03 | Aleutians East, Alaska, US |
2865289 | 2865289 | 2021-01-06 | US | California | Sierra | 6091 | 37 | 0 | 0 | 39 | 39.57713498 | -120.52007009999998 | 2021-01-07 05:22:03 | Sierra, California, US |
2865332 | 2865332 | 2021-01-06 | US | Colorado | Jackson | 8057 | 47 | 0 | 0 | 39 | 40.66593870000001 | -106.3408905 | 2021-01-07 05:22:03 | Jackson, Colorado, US |
3034709 | 3034709 | 2021-01-05 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-06 05:22:16 | Aleutians East, Alaska, US |
3034876 | 3034876 | 2021-01-05 | US | California | Sierra | 6091 | 37 | 0 | 0 | 39 | 39.57713498 | -120.52007009999998 | 2021-01-06 05:22:16 | Sierra, California, US |
3034919 | 3034919 | 2021-01-05 | US | Colorado | Jackson | 8057 | 47 | 0 | 0 | 39 | 40.66593870000001 | -106.3408905 | 2021-01-06 05:22:16 | Jackson, Colorado, US |
1062254 | 1062254 | 2021-01-04 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-05 05:21:49 | Aleutians East, Alaska, US |
3230857 | 3230857 | 2021-01-03 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-04 05:22:02 | Aleutians East, Alaska, US |
2227926 | 2227926 | 2021-01-02 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-03 05:22:52 | Aleutians East, Alaska, US |
1137290 | 1137290 | 2021-01-01 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-02 05:22:33 | Aleutians East, Alaska, US |
3695896 | 3695896 | 2020-12-31 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2021-01-01 05:23:07 | Aleutians East, Alaska, US |
1010711 | 1010711 | 2020-12-30 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2020-12-31 05:22:49 | Aleutians East, Alaska, US |
766726 | 766726 | 2020-12-29 | US | Alaska | Aleutians East | 2013 | 39 | 0 | 0 | 39 | 55.32222414 | -161.9722021 | 2020-12-30 05:22:34 | Aleutians East, Alaska, US |
2933211 | 2933211 | 2020-12-19 | US | Montana | Golden Valley | 30037 | 39 | 0 | 0 | 39 | 46.3816474 | -109.1768522 | 2020-12-20 05:27:32 | Golden Valley, Montana, US |
2934565 | 2934565 | 2020-12-19 | US | Virginia | Highland | 51091 | 39 | 0 | 0 | 39 | 38.35799465 | -79.56124594 | 2020-12-20 05:27:32 | Highland, Virginia, US |
1009747 | 1009747 | 2020-12-06 | US | Washington | Wahkiakum | 53069 | 39 | 0 | 0 | 39 | 46.29180039999999 | -123.4250831 | 2020-12-07 05:26:14 | Wahkiakum, Washington, US |
741516 | 741516 | 2020-12-02 | US | Texas | Stonewall | 48433 | 48 | 2 | 0 | 39 | 33.17906744 | -100.2538401 | 2020-12-03 05:28:22 | Stonewall, Texas, US |
2540669 | 2540669 | 2020-12-01 | US | Vermont | Grand Isle | 50013 | 39 | 0 | 0 | 39 | 44.7975824 | -73.29679772 | 2020-12-02 05:27:41 | Grand Isle, Vermont, US |
3569991 | 3569991 | 2020-11-29 | US | Washington | Columbia | 53013 | 41 | 2 | 0 | 39 | 46.29442881 | -117.9051983 | 2020-11-30 05:26:13 | Columbia, Washington, US |
2938656 | 2938656 | 2020-11-28 | US | Washington | Columbia | 53013 | 41 | 2 | 0 | 39 | 46.29442881 | -117.9051983 | 2020-11-29 05:25:55 | Columbia, Washington, US |
394611 | 394611 | 2020-11-27 | US | North Dakota | Billings | 38007 | 42 | 0 | 0 | 39 | 47.02366884 | -103.3762965 | 2020-11-28 05:25:50 | Billings, North Dakota, US |
926058 | 926058 | 2020-11-26 | US | North Dakota | Billings | 38007 | 40 | 0 | 0 | 39 | 47.02366884 | -103.3762965 | 2020-11-27 05:26:53 | Billings, North Dakota, US |
1973454 | 1973454 | 2020-11-25 | US | Georgia | Taliaferro | 13265 | 39 | 0 | 0 | 39 | 33.56543317 | -82.88136816 | 2020-11-26 05:27:44 | Taliaferro, Georgia, US |
1974963 | 1974963 | 2020-11-25 | US | North Dakota | Billings | 38007 | 40 | 0 | 0 | 39 | 47.02366884 | -103.3762965 | 2020-11-26 05:27:44 | Billings, North Dakota, US |
1352546 | 1352546 | 2020-11-24 | US | New York | Hamilton | 36041 | 40 | 1 | 0 | 39 | 43.66146647 | -74.49721957 | 2020-11-25 05:27:20 | Hamilton, New York, US |
1352694 | 1352694 | 2020-11-24 | US | North Dakota | Billings | 38007 | 40 | 0 | 0 | 39 | 47.02366884 | -103.3762965 | 2020-11-25 05:27:20 | Billings, North Dakota, US |
680688 | 680688 | 2020-11-23 | US | North Dakota | Billings | 38007 | 40 | 0 | 0 | 39 | 47.02366884 | -103.3762965 | 2020-11-24 05:27:31 | Billings, North Dakota, US |
681428 | 681428 | 2020-11-23 | US | Texas | Irion | 48235 | 37 | 0 | 0 | 39 | 31.30375559 | -100.982439 | 2020-11-24 05:27:31 | Irion, Texas, US |
3192364 | 3192364 | 2020-11-22 | US | North Dakota | Billings | 38007 | 40 | 0 | 0 | 39 | 47.02366884 | -103.3762965 | 2020-11-23 05:25:26 | Billings, North Dakota, US |
3193104 | 3193104 | 2020-11-22 | US | Texas | Irion | 48235 | 33 | 0 | 0 | 39 | 31.30375559 | -100.982439 | 2020-11-23 05:25:26 | Irion, Texas, US |
3838858 | 3838858 | 2020-11-21 | US | North Dakota | Billings | 38007 | 40 | 0 | 0 | 39 | 47.02366884 | -103.3762965 | 2020-11-22 05:25:45 | Billings, North Dakota, US |
2704199 | 2704199 | 2020-11-20 | US | Pennsylvania | Sullivan | 42113 | 40 | 1 | 0 | 39 | 41.44634738 | -76.51246591 | 2020-11-21 05:25:51 | Sullivan, Pennsylvania, US |
822099 | 822099 | 2020-11-19 | US | California | Alpine | 6003 | 39 | 0 | 0 | 39 | 38.59678594 | -119.8223594 | 2020-11-20 05:26:28 | Alpine, California, US |
824612 | 824612 | 2020-11-19 | US | Texas | Collingsworth | 48087 | 64 | 0 | 0 | 39 | 34.96489496 | -100.2700111 | 2020-11-20 05:26:28 | Collingsworth, Texas, US |
123116 | 123116 | 2020-11-18 | US | Alaska | Denali | 2068 | 39 | 0 | 0 | 39 | 63.67264044 | -150.0076108 | 2020-11-19 05:25:23 | Denali, Alaska, US |
123233 | 123233 | 2020-11-18 | US | California | Alpine | 6003 | 39 | 0 | 0 | 39 | 38.59678594 | -119.8223594 | 2020-11-19 05:25:23 | Alpine, California, US |
3339004 | 3339004 | 2020-11-17 | US | Alaska | Denali | 2068 | 39 | 0 | 0 | 39 | 63.67264044 | -150.0076108 | 2020-11-18 05:40:31 | Denali, Alaska, US |
3340586 | 3340586 | 2020-11-17 | US | Montana | Judith Basin | 30045 | 39 | 0 | 0 | 39 | 47.04581276 | -110.2660688 | 2020-11-18 05:40:31 | Judith Basin, Montana, US |
3172930 | 3172930 | 2020-11-16 | US | Virginia | Bath | 51017 | 39 | 0 | 0 | 39 | 38.05852573 | -79.73912095 | 2020-11-17 05:25:54 | Bath, Virginia, US |
2882341 | 2882341 | 2020-11-15 | US | Nevada | Pershing | 32027 | 39 | 0 | 0 | 39 | 40.44003782 | -118.40056409999998 | 2020-11-16 05:25:57 | Pershing, Nevada, US |
2917773 | 2917773 | 2020-11-14 | US | Oklahoma | Unassigned | 90040 | 39 | 0 | 0 | 39 | 36.83532655 | 0.0 | 2020-11-15 05:26:53 | Unassigned, Oklahoma, US |
2785438 | 2785438 | 2020-11-13 | US | Alaska | Yakutat | 2282 | 39 | 0 | 0 | 39 | 59.8909808 | -140.36014509999998 | 2020-11-14 05:25:37 | Yakutat, Alaska, US |
2786704 | 2786704 | 2020-11-13 | US | Minnesota | Cook | 27031 | 39 | 0 | 0 | 39 | 47.90504893 | -90.52629546 | 2020-11-14 05:25:37 | Cook, Minnesota, US |
865203 | 865203 | 2020-11-12 | US | Alaska | Yakutat | 2282 | 39 | 0 | 0 | 39 | 59.8909808 | -140.36014509999998 | 2020-11-13 05:25:30 | Yakutat, Alaska, US |
3441247 | 3441247 | 2020-11-11 | US | Alaska | Yakutat | 2282 | 39 | 0 | 0 | 39 | 59.8909808 | -140.36014509999998 | 2020-11-12 05:25:55 | Yakutat, Alaska, US |
272587 | 272587 | 2020-11-10 | US | Alaska | Yakutat | 2282 | 39 | 0 | 0 | 39 | 59.8909808 | -140.36014509999998 | 2020-11-11 05:25:30 | Yakutat, Alaska, US |
272778 | 272778 | 2020-11-10 | US | Colorado | Lincoln | 8073 | 89 | 0 | 0 | 39 | 38.98749519 | -103.5136649 | 2020-11-11 05:25:30 | Lincoln, Colorado, US |
274151 | 274151 | 2020-11-10 | US | Montana | Liberty | 30051 | 40 | 1 | 0 | 39 | 48.56084317 | -111.024307 | 2020-11-11 05:25:30 | Liberty, Montana, US |
275239 | 275239 | 2020-11-10 | US | Texas | Glasscock | 48173 | 33 | 0 | 0 | 39 | 31.86942909 | -101.5207776 | 2020-11-11 05:25:30 | Glasscock, Texas, US |
1989222 | 1989222 | 2020-11-09 | US | Colorado | Baca | 8009 | 76 | 0 | 0 | 39 | 37.31940883 | -102.5603223 | 2020-11-10 05:40:07 | Baca, Colorado, US |
1989271 | 1989271 | 2020-11-09 | US | Colorado | Rio Blanco | 8103 | 77 | 1 | 0 | 39 | 39.97913541 | -108.2179009 | 2020-11-10 05:40:07 | Rio Blanco, Colorado, US |
1990628 | 1990628 | 2020-11-09 | US | Montana | Liberty | 30051 | 40 | 1 | 0 | 39 | 48.56084317 | -111.024307 | 2020-11-10 05:40:07 | Liberty, Montana, US |
1991716 | 1991716 | 2020-11-09 | US | Texas | Glasscock | 48173 | 33 | 0 | 0 | 39 | 31.86942909 | -101.5207776 | 2020-11-10 05:40:07 | Glasscock, Texas, US |
1992231 | 1992231 | 2020-11-09 | US | Wyoming | Niobrara | 56027 | 39 | 0 | 0 | 39 | 43.05607708 | -104.4758896 | 2020-11-10 05:40:07 | Niobrara, Wyoming, US |
1728909 | 1728909 | 2020-11-08 | US | Alaska | Prince of Wales-Hyder | 2198 | 40 | 1 | 0 | 39 | 55.76261984 | -133.0511621 | 2020-11-09 05:25:45 | Prince of Wales-Hyder, Alaska, US |
1729074 | 1729074 | 2020-11-08 | US | Colorado | Baca | 8009 | 70 | 0 | 0 | 39 | 37.31940883 | -102.5603223 | 2020-11-09 05:25:45 | Baca, Colorado, US |
1730480 | 1730480 | 2020-11-08 | US | Montana | Liberty | 30051 | 40 | 1 | 0 | 39 | 48.56084317 | -111.024307 | 2020-11-09 05:25:45 | Liberty, Montana, US |
1731568 | 1731568 | 2020-11-08 | US | Texas | Glasscock | 48173 | 32 | 0 | 0 | 39 | 31.86942909 | -101.5207776 | 2020-11-09 05:25:45 | Glasscock, Texas, US |
1544534 | 1544534 | 2020-11-07 | US | Colorado | Baca | 8009 | 69 | 0 | 0 | 39 | 37.31940883 | -102.5603223 | 2020-11-08 05:24:56 | Baca, Colorado, US |
1545913 | 1545913 | 2020-11-07 | US | Missouri | Worth | 29227 | 39 | 0 | 0 | 39 | 40.47945588 | -94.42328751 | 2020-11-08 05:24:56 | Worth, Missouri, US |
1545940 | 1545940 | 2020-11-07 | US | Montana | Liberty | 30051 | 40 | 1 | 0 | 39 | 48.56084317 | -111.024307 | 2020-11-08 05:24:56 | Liberty, Montana, US |
1547028 | 1547028 | 2020-11-07 | US | Texas | Glasscock | 48173 | 32 | 0 | 0 | 39 | 31.86942909 | -101.5207776 | 2020-11-08 05:24:56 | Glasscock, Texas, US |
1547388 | 1547388 | 2020-11-07 | US | Washington | San Juan | 53055 | 39 | 0 | 0 | 39 | 48.60182783 | -122.96745 | 2020-11-08 05:24:56 | San Juan, Washington, US |
376772 | 376772 | 2020-11-06 | US | Colorado | Baca | 8009 | 69 | 0 | 0 | 39 | 37.31940883 | -102.5603223 | 2020-11-07 05:24:52 | Baca, Colorado, US |
378101 | 378101 | 2020-11-06 | US | Missouri | Mercer | 29129 | 39 | 0 | 0 | 39 | 40.42212303 | -93.5682959 | 2020-11-07 05:24:52 | Mercer, Missouri, US |
378151 | 378151 | 2020-11-06 | US | Missouri | Worth | 29227 | 39 | 0 | 0 | 39 | 40.47945588 | -94.42328751 | 2020-11-07 05:24:52 | Worth, Missouri, US |
379266 | 379266 | 2020-11-06 | US | Texas | Glasscock | 48173 | 32 | 0 | 0 | 39 | 31.86942909 | -101.5207776 | 2020-11-07 05:24:52 | Glasscock, Texas, US |
379690 | 379690 | 2020-11-06 | US | West Virginia | Webster | 54101 | 39 | 0 | 0 | 39 | 38.49370949 | -80.4202023 | 2020-11-07 05:24:52 | Webster, West Virginia, US |
892710 | 892710 | 2020-11-05 | US | Colorado | Baca | 8009 | 69 | 0 | 0 | 39 | 37.31940883 | -102.5603223 | 2020-11-06 05:24:55 | Baca, Colorado, US |
894039 | 894039 | 2020-11-05 | US | Missouri | Mercer | 29129 | 39 | 0 | 0 | 39 | 40.42212303 | -93.5682959 | 2020-11-06 05:24:55 | Mercer, Missouri, US |
894116 | 894116 | 2020-11-05 | US | Montana | Liberty | 30051 | 39 | 0 | 0 | 39 | 48.56084317 | -111.024307 | 2020-11-06 05:24:55 | Liberty, Montana, US |
894990 | 894990 | 2020-11-05 | US | South Dakota | Jones | 46075 | 39 | 0 | 0 | 39 | 43.96278565 | -100.6940008 | 2020-11-06 05:24:55 | Jones, South Dakota, US |
895548 | 895548 | 2020-11-05 | US | Washington | Garfield | 53023 | 40 | 1 | 0 | 39 | 46.43197502 | -117.5454032 | 2020-11-06 05:24:55 | Garfield, Washington, US |
2922257 | 2922257 | 2020-11-04 | US | Texas | Foard | 48155 | 19 | 1 | 0 | 39 | 33.97308618 | -99.7767797 | 2020-11-05 06:05:03 | Foard, Texas, US |
2499471 | 2499471 | 2020-11-03 | US | Kentucky | Robertson | 21201 | 40 | 1 | 0 | 39 | 38.51923469 | -84.05055616 | 2020-11-04 05:25:09 | Robertson, Kentucky, US |
2499676 | 2499676 | 2020-11-03 | US | Michigan | Montmorency | 26119 | 39 | 0 | 0 | 39 | 45.0275929 | -84.12696227 | 2020-11-04 05:25:09 | Montmorency, Michigan, US |
2500625 | 2500625 | 2020-11-03 | US | Oregon | Harney | 41025 | 39 | 0 | 0 | 39 | 43.06422669 | -118.9666306 | 2020-11-04 05:25:09 | Harney, Oregon, US |
3304772 | 3304772 | 2020-11-02 | US | California | Trinity | 6105 | 43 | 0 | 0 | 39 | 40.64917670000001 | -123.114713 | 2020-11-03 06:00:16 | Trinity, California, US |
3306800 | 3306800 | 2020-11-02 | US | Oregon | Harney | 41025 | 39 | 0 | 0 | 39 | 43.06422669 | -118.9666306 | 2020-11-03 06:00:16 | Harney, Oregon, US |
3412049 | 3412049 | 2020-11-01 | US | Oregon | Harney | 41025 | 39 | 0 | 0 | 39 | 43.06422669 | -118.9666306 | 2020-11-02 05:25:04 | Harney, Oregon, 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]);