johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,239 rows where active = 111 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 112
- Kentucky 61
- Michigan 59
- Georgia 58
- Virginia 55
- Minnesota 47
- Kansas 44
- Indiana 43
- Illinois 41
- Puerto Rico 40
- Montana 38
- Missouri 33
- West Virginia 32
- Iowa 31
- Pennsylvania 29
- Arkansas 28
- New York 28
- Mississippi 27
- South Dakota 27
- North Carolina 26
- Alabama 25
- Wisconsin 25
- Oklahoma 24
- Vermont 24
- Idaho 23
- Alaska 20
- Louisiana 20
- Ohio 20
- Nebraska 19
- Hawaii 18
- …
country_or_region 1
- US · 1,239 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3669687 | 3669687 | 2021-03-06 | US | Nebraska | Garden | 31069 | 112 | 1 | 0 | 111 | 41.61703149 | -102.3313973 | 2021-03-07 05:21:54 | Garden, Nebraska, US |
3670740 | 3670740 | 2021-03-06 | US | Texas | Irion | 48235 | 108 | 1 | 0 | 111 | 31.30375559 | -100.982439 | 2021-03-07 05:21:54 | Irion, Texas, US |
3671048 | 3671048 | 2021-03-06 | US | Washington | Columbia | 53013 | 115 | 4 | 0 | 111 | 46.29442881 | -117.9051983 | 2021-03-07 05:21:54 | Columbia, Washington, US |
1618308 | 1618308 | 2021-03-05 | US | Nebraska | Garden | 31069 | 112 | 1 | 0 | 111 | 41.61703149 | -102.3313973 | 2021-03-06 04:23:41 | Garden, Nebraska, US |
1619669 | 1619669 | 2021-03-05 | US | Washington | Columbia | 53013 | 115 | 4 | 0 | 111 | 46.29442881 | -117.9051983 | 2021-03-06 04:23:41 | Columbia, Washington, US |
2209719 | 2209719 | 2021-03-04 | US | Nebraska | Garden | 31069 | 112 | 1 | 0 | 111 | 41.61703149 | -102.3313973 | 2021-03-05 05:26:29 | Garden, Nebraska, US |
1092140 | 1092140 | 2021-03-03 | US | Nebraska | Garden | 31069 | 112 | 1 | 0 | 111 | 41.61703149 | -102.3313973 | 2021-03-04 05:24:24 | Garden, Nebraska, US |
1093153 | 1093153 | 2021-03-03 | US | Texas | Foard | 48155 | 96 | 8 | 0 | 111 | 33.97308618 | -99.7767797 | 2021-03-04 05:24:24 | Foard, Texas, US |
3257225 | 3257225 | 2021-03-02 | US | Texas | Foard | 48155 | 96 | 8 | 0 | 111 | 33.97308618 | -99.7767797 | 2021-03-03 05:23:28 | Foard, Texas, US |
998865 | 998865 | 2021-03-01 | US | Alaska | Petersburg | 2195 | 112 | 1 | 0 | 111 | 57.13978948 | -132.9540995 | 2021-03-02 05:23:30 | Petersburg, Alaska, US |
1000468 | 1000468 | 2021-03-01 | US | Montana | Wibaux | 30109 | 117 | 6 | 0 | 111 | 46.95925154 | -104.2510927 | 2021-03-02 05:23:30 | Wibaux, Montana, US |
1001517 | 1001517 | 2021-03-01 | US | Texas | Foard | 48155 | 96 | 8 | 0 | 111 | 33.97308618 | -99.7767797 | 2021-03-02 05:23:30 | Foard, Texas, US |
2369526 | 2369526 | 2021-02-28 | US | Montana | Wibaux | 30109 | 117 | 6 | 0 | 111 | 46.95925154 | -104.2510927 | 2021-03-01 05:23:01 | Wibaux, Montana, US |
2370575 | 2370575 | 2021-02-28 | US | Texas | Foard | 48155 | 96 | 8 | 0 | 111 | 33.97308618 | -99.7767797 | 2021-03-01 05:23:01 | Foard, Texas, US |
2370615 | 2370615 | 2021-02-28 | US | Texas | Irion | 48235 | 108 | 1 | 0 | 111 | 31.30375559 | -100.982439 | 2021-03-01 05:23:01 | Irion, Texas, US |
3068028 | 3068028 | 2021-02-27 | US | Montana | Wibaux | 30109 | 117 | 6 | 0 | 111 | 46.95925154 | -104.2510927 | 2021-02-28 05:22:20 | Wibaux, Montana, US |
3069077 | 3069077 | 2021-02-27 | US | Texas | Foard | 48155 | 96 | 8 | 0 | 111 | 33.97308618 | -99.7767797 | 2021-02-28 05:22:20 | Foard, Texas, US |
3069117 | 3069117 | 2021-02-27 | US | Texas | Irion | 48235 | 108 | 1 | 0 | 111 | 31.30375559 | -100.982439 | 2021-02-28 05:22:20 | Irion, Texas, US |
3069275 | 3069275 | 2021-02-27 | US | Vermont | Grand Isle | 50013 | 111 | 0 | 0 | 111 | 44.7975824 | -73.29679772 | 2021-02-28 05:22:20 | Grand Isle, Vermont, US |
2185612 | 2185612 | 2021-02-26 | US | Montana | Wibaux | 30109 | 117 | 6 | 0 | 111 | 46.95925154 | -104.2510927 | 2021-02-27 05:22:28 | Wibaux, Montana, US |
2186701 | 2186701 | 2021-02-26 | US | Texas | Irion | 48235 | 108 | 1 | 0 | 111 | 31.30375559 | -100.982439 | 2021-02-27 05:22:28 | Irion, Texas, US |
1861123 | 1861123 | 2021-02-25 | US | Texas | Irion | 48235 | 108 | 1 | 0 | 111 | 31.30375559 | -100.982439 | 2021-02-26 05:22:40 | Irion, Texas, US |
2679825 | 2679825 | 2021-02-13 | US | Montana | Liberty | 30051 | 112 | 1 | 0 | 111 | 48.56084317 | -111.024307 | 2021-02-14 05:23:43 | Liberty, Montana, US |
615691 | 615691 | 2021-02-08 | US | Montana | Meagher | 30059 | 118 | 7 | 0 | 111 | 46.59907074 | -110.8898557 | 2021-02-09 05:23:30 | Meagher, Montana, US |
1674460 | 1674460 | 2021-02-07 | US | Montana | Meagher | 30059 | 118 | 7 | 0 | 111 | 46.59907074 | -110.8898557 | 2021-02-08 05:22:39 | Meagher, Montana, US |
976921 | 976921 | 2021-02-06 | US | Montana | Meagher | 30059 | 118 | 7 | 0 | 111 | 46.59907074 | -110.8898557 | 2021-02-07 05:23:00 | Meagher, Montana, US |
1590806 | 1590806 | 2021-02-05 | US | Oregon | Wallowa | 41063 | 114 | 3 | 0 | 111 | 45.57894064 | -117.18353799999998 | 2021-02-06 05:23:55 | Wallowa, Oregon, US |
1462538 | 1462538 | 2021-01-31 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-02-01 05:22:53 | Vieques, Puerto Rico, US |
2214446 | 2214446 | 2021-01-30 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-31 05:22:42 | Vieques, Puerto Rico, US |
1899933 | 1899933 | 2021-01-29 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-30 05:22:49 | Vieques, Puerto Rico, US |
2484749 | 2484749 | 2021-01-28 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-29 05:22:23 | Vieques, Puerto Rico, US |
3156384 | 3156384 | 2021-01-27 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-28 05:22:24 | Vieques, Puerto Rico, US |
15119 | 15119 | 2021-01-26 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-27 05:23:41 | Vieques, Puerto Rico, US |
2570443 | 2570443 | 2021-01-25 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-26 05:22:02 | Vieques, Puerto Rico, US |
1762075 | 1762075 | 2021-01-24 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-25 05:22:16 | Vieques, Puerto Rico, US |
2429682 | 2429682 | 2021-01-23 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-24 05:22:35 | Vieques, Puerto Rico, US |
2469584 | 2469584 | 2021-01-22 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-23 05:22:03 | Vieques, Puerto Rico, US |
436246 | 436246 | 2021-01-21 | US | Georgia | Webster | 13307 | 114 | 3 | 0 | 111 | 32.04066113 | -84.54742852 | 2021-01-22 05:22:10 | Webster, Georgia, US |
438135 | 438135 | 2021-01-21 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-22 05:22:10 | Vieques, Puerto Rico, US |
1096866 | 1096866 | 2021-01-20 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-21 05:22:01 | Vieques, Puerto Rico, US |
1097361 | 1097361 | 2021-01-20 | US | Vermont | Essex | 50009 | 111 | 0 | 0 | 111 | 44.72736416 | -71.73579864 | 2021-01-21 05:22:01 | Essex, Vermont, US |
910956 | 910956 | 2021-01-19 | US | Puerto Rico | Vieques | 72147 | 111 | 0 | 0 | 111 | 18.123276 | -65.44097099999999 | 2021-01-20 05:21:54 | Vieques, Puerto Rico, US |
911200 | 911200 | 2021-01-19 | US | Texas | Briscoe | 48045 | 161 | 3 | 0 | 111 | 34.53026962 | -101.2084947 | 2021-01-20 05:21:54 | Briscoe, Texas, US |
911451 | 911451 | 2021-01-19 | US | Vermont | Essex | 50009 | 111 | 0 | 0 | 111 | 44.72736416 | -71.73579864 | 2021-01-20 05:21:54 | Essex, Vermont, US |
3882580 | 3882580 | 2021-01-14 | US | Texas | Armstrong | 48011 | 188 | 6 | 0 | 111 | 34.96507426 | -101.3574874 | 2021-01-15 05:22:24 | Armstrong, Texas, US |
3311207 | 3311207 | 2021-01-13 | US | Texas | Armstrong | 48011 | 188 | 6 | 0 | 111 | 34.96507426 | -101.3574874 | 2021-01-14 05:22:32 | Armstrong, Texas, US |
776047 | 776047 | 2021-01-12 | US | Minnesota | Cook | 27031 | 111 | 0 | 0 | 111 | 47.90504893 | -90.52629546 | 2021-01-13 05:22:15 | Cook, Minnesota, US |
776877 | 776877 | 2021-01-12 | US | Oklahoma | Cimarron | 40025 | 112 | 1 | 0 | 111 | 36.74817177 | -102.5173885 | 2021-01-13 05:22:15 | Cimarron, Oklahoma, US |
777352 | 777352 | 2021-01-12 | US | Texas | Armstrong | 48011 | 187 | 5 | 0 | 111 | 34.96507426 | -101.3574874 | 2021-01-13 05:22:15 | Armstrong, Texas, US |
191768 | 191768 | 2021-01-11 | US | Minnesota | Cook | 27031 | 111 | 0 | 0 | 111 | 47.90504893 | -90.52629546 | 2021-01-12 05:22:15 | Cook, Minnesota, US |
192598 | 192598 | 2021-01-11 | US | Oklahoma | Cimarron | 40025 | 112 | 1 | 0 | 111 | 36.74817177 | -102.5173885 | 2021-01-12 05:22:15 | Cimarron, Oklahoma, US |
193073 | 193073 | 2021-01-11 | US | Texas | Armstrong | 48011 | 187 | 5 | 0 | 111 | 34.96507426 | -101.3574874 | 2021-01-12 05:22:15 | Armstrong, Texas, US |
2627571 | 2627571 | 2021-01-10 | US | Minnesota | Cook | 27031 | 111 | 0 | 0 | 111 | 47.90504893 | -90.52629546 | 2021-01-11 05:21:50 | Cook, Minnesota, US |
2628876 | 2628876 | 2021-01-10 | US | Texas | Armstrong | 48011 | 187 | 5 | 0 | 111 | 34.96507426 | -101.3574874 | 2021-01-11 05:21:50 | Armstrong, Texas, US |
3902964 | 3902964 | 2021-01-09 | US | Texas | Armstrong | 48011 | 187 | 5 | 0 | 111 | 34.96507426 | -101.3574874 | 2021-01-10 05:22:12 | Armstrong, Texas, US |
3903080 | 3903080 | 2021-01-09 | US | Texas | Jeff Davis | 48243 | 100 | 1 | 0 | 111 | 30.71490589 | -104.1399973 | 2021-01-10 05:22:12 | Jeff Davis, Texas, US |
156827 | 156827 | 2021-01-08 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-09 05:22:18 | Campbell, South Dakota, US |
157103 | 157103 | 2021-01-08 | US | Texas | Jeff Davis | 48243 | 100 | 1 | 0 | 111 | 30.71490589 | -104.1399973 | 2021-01-09 05:22:18 | Jeff Davis, Texas, US |
2542261 | 2542261 | 2021-01-07 | US | Georgia | Quitman | 13239 | 112 | 1 | 0 | 111 | 31.86728114 | -85.01773177 | 2021-01-08 05:22:42 | Quitman, Georgia, US |
2544251 | 2544251 | 2021-01-07 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-08 05:22:42 | Campbell, South Dakota, US |
2544527 | 2544527 | 2021-01-07 | US | Texas | Jeff Davis | 48243 | 100 | 1 | 0 | 111 | 30.71490589 | -104.1399973 | 2021-01-08 05:22:42 | Jeff Davis, Texas, US |
2867459 | 2867459 | 2021-01-06 | US | Puerto Rico | Las Marias | 72083 | 111 | 0 | 0 | 111 | 18.23679 | -66.98362 | 2021-01-07 05:22:03 | Las Marias, Puerto Rico, US |
2867560 | 2867560 | 2021-01-06 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-07 05:22:03 | Campbell, South Dakota, US |
3037046 | 3037046 | 2021-01-05 | US | Puerto Rico | Las Marias | 72083 | 111 | 0 | 0 | 111 | 18.23679 | -66.98362 | 2021-01-06 05:22:16 | Las Marias, Puerto Rico, US |
3037147 | 3037147 | 2021-01-05 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-06 05:22:16 | Campbell, South Dakota, US |
1064692 | 1064692 | 2021-01-04 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-05 05:21:49 | Campbell, South Dakota, US |
3233295 | 3233295 | 2021-01-03 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-04 05:22:02 | Campbell, South Dakota, US |
2230364 | 2230364 | 2021-01-02 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-03 05:22:52 | Campbell, South Dakota, US |
1139112 | 1139112 | 2021-01-01 | US | New York | Hamilton | 36041 | 112 | 1 | 0 | 111 | 43.66146647 | -74.49721957 | 2021-01-02 05:22:33 | Hamilton, New York, US |
1139728 | 1139728 | 2021-01-01 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-02 05:22:33 | Campbell, South Dakota, US |
3698334 | 3698334 | 2020-12-31 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2021-01-01 05:23:07 | Campbell, South Dakota, US |
1011856 | 1011856 | 2020-12-30 | US | Maine | Piscataquis | 23021 | 112 | 1 | 0 | 111 | 45.83839062 | -69.2860223 | 2020-12-31 05:22:49 | Piscataquis, Maine, US |
1013149 | 1013149 | 2020-12-30 | US | South Dakota | Campbell | 46021 | 115 | 4 | 0 | 111 | 45.77074915 | -100.0510181 | 2020-12-31 05:22:49 | Campbell, South Dakota, US |
2409892 | 2409892 | 2020-12-23 | US | Texas | Dickens | 48125 | 142 | 6 | 0 | 111 | 33.61616822 | -100.7788855 | 2020-12-24 05:23:04 | Dickens, Texas, US |
3770290 | 3770290 | 2020-12-22 | US | Alaska | Dillingham | 2070 | 112 | 1 | 0 | 111 | 59.79603738 | -158.23819419999995 | 2020-12-23 05:22:03 | Dillingham, Alaska, US |
2123007 | 2123007 | 2020-12-20 | US | Virginia | Bath | 51017 | 111 | 0 | 0 | 111 | 38.05852573 | -79.73912095 | 2020-12-21 05:27:58 | Bath, Virginia, US |
1901778 | 1901778 | 2020-12-18 | US | Colorado | Gilpin | 8047 | 126 | 2 | 0 | 111 | 39.85646523 | -105.5252597 | 2020-12-19 05:27:52 | Gilpin, Colorado, US |
2128406 | 2128406 | 2020-12-17 | US | Alaska | Dillingham | 2070 | 112 | 1 | 0 | 111 | 59.79603738 | -158.23819419999995 | 2020-12-18 05:28:18 | Dillingham, Alaska, US |
2130420 | 2130420 | 2020-12-17 | US | Northern Mariana Islands | 69 | 113 | 2 | 0 | 111 | 15.0979 | 145.6739 | 2020-12-18 05:28:18 | Northern Mariana Islands, US | |
3150006 | 3150006 | 2020-12-16 | US | Alaska | Dillingham | 2070 | 112 | 1 | 0 | 111 | 59.79603738 | -158.23819419999995 | 2020-12-17 05:28:12 | Dillingham, Alaska, US |
3151046 | 3151046 | 2020-12-16 | US | Kentucky | Robertson | 21201 | 114 | 3 | 0 | 111 | 38.51923469 | -84.05055616 | 2020-12-17 05:28:12 | Robertson, Kentucky, US |
3152020 | 3152020 | 2020-12-16 | US | Northern Mariana Islands | 69 | 113 | 2 | 0 | 111 | 15.0979 | 145.6739 | 2020-12-17 05:28:12 | Northern Mariana Islands, US | |
3152282 | 3152282 | 2020-12-16 | US | Pennsylvania | Sullivan | 42113 | 113 | 2 | 0 | 111 | 41.44634738 | -76.51246591 | 2020-12-17 05:28:12 | Sullivan, Pennsylvania, US |
3153102 | 3153102 | 2020-12-16 | US | West Virginia | Webster | 54101 | 111 | 0 | 0 | 111 | 38.49370949 | -80.4202023 | 2020-12-17 05:28:12 | Webster, West Virginia, US |
1034787 | 1034787 | 2020-12-15 | US | Alaska | Dillingham | 2070 | 112 | 1 | 0 | 111 | 59.79603738 | -158.23819419999995 | 2020-12-16 05:28:04 | Dillingham, Alaska, US |
1035827 | 1035827 | 2020-12-15 | US | Kentucky | Robertson | 21201 | 114 | 3 | 0 | 111 | 38.51923469 | -84.05055616 | 2020-12-16 05:28:04 | Robertson, Kentucky, US |
1036376 | 1036376 | 2020-12-15 | US | Montana | Mineral | 30061 | 111 | 0 | 0 | 111 | 47.15283992 | -115.0015239 | 2020-12-16 05:28:04 | Mineral, Montana, US |
1036801 | 1036801 | 2020-12-15 | US | Northern Mariana Islands | 69 | 113 | 2 | 0 | 111 | 15.0979 | 145.6739 | 2020-12-16 05:28:04 | Northern Mariana Islands, US | |
1753270 | 1753270 | 2020-12-14 | US | Montana | Mineral | 30061 | 111 | 0 | 0 | 111 | 47.15283992 | -115.0015239 | 2020-12-15 05:26:38 | Mineral, Montana, US |
1753695 | 1753695 | 2020-12-14 | US | Northern Mariana Islands | 69 | 113 | 2 | 0 | 111 | 15.0979 | 145.6739 | 2020-12-15 05:26:38 | Northern Mariana Islands, US | |
1754581 | 1754581 | 2020-12-14 | US | Virginia | Craig | 51045 | 112 | 1 | 0 | 111 | 37.48133648 | -80.21072274 | 2020-12-15 05:26:38 | Craig, Virginia, US |
3848387 | 3848387 | 2020-12-13 | US | Colorado | Costilla | 8023 | 141 | 2 | 0 | 111 | 37.27732493 | -105.4276548 | 2020-12-14 05:26:27 | Costilla, Colorado, US |
3849790 | 3849790 | 2020-12-13 | US | Montana | Mineral | 30061 | 111 | 0 | 0 | 111 | 47.15283992 | -115.0015239 | 2020-12-14 05:26:27 | Mineral, Montana, US |
3850215 | 3850215 | 2020-12-13 | US | Northern Mariana Islands | 69 | 113 | 2 | 0 | 111 | 15.0979 | 145.6739 | 2020-12-14 05:26:27 | Northern Mariana Islands, US | |
847997 | 847997 | 2020-12-12 | US | Northern Mariana Islands | 69 | 113 | 2 | 0 | 111 | 15.0979 | 145.6739 | 2020-12-13 05:27:20 | Northern Mariana Islands, US | |
863104 | 863104 | 2020-12-11 | US | Northern Mariana Islands | 69 | 113 | 2 | 0 | 111 | 15.0979 | 145.6739 | 2020-12-12 05:26:19 | Northern Mariana Islands, US | |
863726 | 863726 | 2020-12-11 | US | Texas | Cottle | 48101 | 101 | 5 | 0 | 111 | 34.07783319 | -100.2785062 | 2020-12-12 05:26:19 | Cottle, Texas, US |
864027 | 864027 | 2020-12-11 | US | Virginia | King and Queen | 51097 | 113 | 2 | 0 | 111 | 37.71044922 | -76.88689628 | 2020-12-12 05:26:19 | King and Queen, Virginia, US |
1602646 | 1602646 | 2020-12-10 | US | Northern Mariana Islands | 69 | 113 | 2 | 0 | 111 | 15.0979 | 145.6739 | 2020-12-11 05:26:59 | Northern Mariana Islands, US | |
1603569 | 1603569 | 2020-12-10 | US | Virginia | King and Queen | 51097 | 113 | 2 | 0 | 111 | 37.71044922 | -76.88689628 | 2020-12-11 05:26:59 | King and Queen, Virginia, 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]);