johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,322 rows where active = 93 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 114
- Kentucky 62
- Minnesota 58
- Colorado 57
- Iowa 54
- Virginia 50
- Georgia 47
- Illinois 46
- Nebraska 46
- Oklahoma 46
- Michigan 39
- Missouri 39
- Indiana 38
- South Dakota 38
- Tennessee 38
- New York 37
- Mississippi 34
- Kansas 32
- Ohio 31
- Pennsylvania 30
- North Carolina 29
- Washington 29
- Arkansas 27
- West Virginia 26
- Puerto Rico 25
- Alabama 22
- Oregon 22
- Louisiana 21
- Wisconsin 20
- North Dakota 19
- …
country_or_region 1
- US · 1,322 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3604317 | 3604317 | 2021-02-17 | US | Vermont | Grand Isle | 50013 | 93 | 0 | 0 | 93 | 44.7975824 | -73.29679772 | 2021-02-18 05:22:58 | Grand Isle, Vermont, US |
3053452 | 3053452 | 2021-02-16 | US | Vermont | Grand Isle | 50013 | 93 | 0 | 0 | 93 | 44.7975824 | -73.29679772 | 2021-02-17 05:23:10 | Grand Isle, Vermont, US |
1341551 | 1341551 | 2021-02-15 | US | Vermont | Grand Isle | 50013 | 93 | 0 | 0 | 93 | 44.7975824 | -73.29679772 | 2021-02-16 05:24:38 | Grand Isle, Vermont, US |
1591294 | 1591294 | 2021-02-05 | US | Texas | Irion | 48235 | 90 | 1 | 0 | 93 | 31.30375559 | -100.982439 | 2021-02-06 05:23:55 | Irion, Texas, US |
793461 | 793461 | 2021-02-04 | US | Texas | Foard | 48155 | 77 | 7 | 0 | 93 | 33.97308618 | -99.7767797 | 2021-02-05 05:22:38 | Foard, Texas, US |
343362 | 343362 | 2021-02-03 | US | Texas | Glasscock | 48173 | 86 | 2 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-02-04 05:22:26 | Glasscock, Texas, US |
1463185 | 1463185 | 2021-01-31 | US | Washington | Columbia | 53013 | 97 | 4 | 0 | 93 | 46.29442881 | -117.9051983 | 2021-02-01 05:22:53 | Columbia, Washington, US |
2215093 | 2215093 | 2021-01-30 | US | Washington | Columbia | 53013 | 97 | 4 | 0 | 93 | 46.29442881 | -117.9051983 | 2021-01-31 05:22:42 | Columbia, Washington, US |
1900580 | 1900580 | 2021-01-29 | US | Washington | Columbia | 53013 | 97 | 4 | 0 | 93 | 46.29442881 | -117.9051983 | 2021-01-30 05:22:49 | Columbia, Washington, US |
2570751 | 2570751 | 2021-01-25 | US | Texas | Glasscock | 48173 | 85 | 1 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-01-26 05:22:02 | Glasscock, Texas, US |
1761659 | 1761659 | 2021-01-24 | US | North Carolina | Unassigned | 90037 | 93 | 0 | 0 | 93 | 36.49360862 | 0.0 | 2021-01-25 05:22:16 | Unassigned, North Carolina, US |
1762383 | 1762383 | 2021-01-24 | US | Texas | Glasscock | 48173 | 85 | 1 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-01-25 05:22:16 | Glasscock, Texas, US |
2429990 | 2429990 | 2021-01-23 | US | Texas | Glasscock | 48173 | 85 | 1 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-01-24 05:22:35 | Glasscock, Texas, US |
2469892 | 2469892 | 2021-01-22 | US | Texas | Glasscock | 48173 | 85 | 1 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-01-23 05:22:03 | Glasscock, Texas, US |
438443 | 438443 | 2021-01-21 | US | Texas | Glasscock | 48173 | 85 | 1 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-01-22 05:22:10 | Glasscock, Texas, US |
1097174 | 1097174 | 2021-01-20 | US | Texas | Glasscock | 48173 | 85 | 1 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-01-21 05:22:01 | Glasscock, Texas, US |
1097303 | 1097303 | 2021-01-20 | US | Texas | Sterling | 48431 | 89 | 4 | 0 | 93 | 31.82781912 | -101.0500746 | 2021-01-21 05:22:01 | Sterling, Texas, US |
910807 | 910807 | 2021-01-19 | US | Oregon | Wallowa | 41063 | 96 | 3 | 0 | 93 | 45.57894064 | -117.18353799999998 | 2021-01-20 05:21:54 | Wallowa, Oregon, US |
911264 | 911264 | 2021-01-19 | US | Texas | Glasscock | 48173 | 85 | 1 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-01-20 05:21:54 | Glasscock, Texas, US |
911393 | 911393 | 2021-01-19 | US | Texas | Sterling | 48431 | 89 | 4 | 0 | 93 | 31.82781912 | -101.0500746 | 2021-01-20 05:21:54 | Sterling, Texas, US |
239870 | 239870 | 2021-01-18 | US | Oregon | Wallowa | 41063 | 96 | 3 | 0 | 93 | 45.57894064 | -117.18353799999998 | 2021-01-19 05:22:15 | Wallowa, Oregon, US |
3504225 | 3504225 | 2021-01-17 | US | Georgia | Taliaferro | 13265 | 93 | 0 | 0 | 93 | 33.56543317 | -82.88136816 | 2021-01-18 05:22:34 | Taliaferro, Georgia, US |
3505987 | 3505987 | 2021-01-17 | US | Oregon | Wallowa | 41063 | 96 | 3 | 0 | 93 | 45.57894064 | -117.18353799999998 | 2021-01-18 05:22:34 | Wallowa, Oregon, US |
3506444 | 3506444 | 2021-01-17 | US | Texas | Glasscock | 48173 | 85 | 1 | 0 | 93 | 31.86942909 | -101.5207776 | 2021-01-18 05:22:34 | Glasscock, Texas, US |
3104070 | 3104070 | 2021-01-16 | US | Oregon | Wallowa | 41063 | 96 | 3 | 0 | 93 | 45.57894064 | -117.18353799999998 | 2021-01-17 05:22:17 | Wallowa, Oregon, US |
2542003 | 2542003 | 2021-01-07 | US | Colorado | Cheyenne | 8017 | 107 | 6 | 0 | 93 | 38.82777431 | -102.6032558 | 2021-01-08 05:22:42 | Cheyenne, Colorado, US |
3036366 | 3036366 | 2021-01-05 | US | Nebraska | Garden | 31069 | 94 | 1 | 0 | 93 | 41.61703149 | -102.3313973 | 2021-01-06 05:22:16 | Garden, Nebraska, US |
3037324 | 3037324 | 2021-01-05 | US | Texas | Briscoe | 48045 | 142 | 2 | 0 | 93 | 34.53026962 | -101.2084947 | 2021-01-06 05:22:16 | Briscoe, Texas, US |
2230949 | 2230949 | 2021-01-02 | US | Washington | Garfield | 53023 | 95 | 2 | 0 | 93 | 46.43197502 | -117.5454032 | 2021-01-03 05:22:52 | Garfield, Washington, US |
1140313 | 1140313 | 2021-01-01 | US | Washington | Garfield | 53023 | 95 | 2 | 0 | 93 | 46.43197502 | -117.5454032 | 2021-01-02 05:22:33 | Garfield, Washington, US |
3698919 | 3698919 | 2020-12-31 | US | Washington | Garfield | 53023 | 95 | 2 | 0 | 93 | 46.43197502 | -117.5454032 | 2021-01-01 05:23:07 | Garfield, Washington, US |
1013734 | 1013734 | 2020-12-30 | US | Washington | Garfield | 53023 | 95 | 2 | 0 | 93 | 46.43197502 | -117.5454032 | 2020-12-31 05:22:49 | Garfield, Washington, US |
769749 | 769749 | 2020-12-29 | US | Washington | Garfield | 53023 | 95 | 2 | 0 | 93 | 46.43197502 | -117.5454032 | 2020-12-30 05:22:34 | Garfield, Washington, US |
930697 | 930697 | 2020-12-21 | US | Texas | Armstrong | 48011 | 159 | 5 | 0 | 93 | 34.96507426 | -101.3574874 | 2020-12-22 05:22:33 | Armstrong, Texas, US |
930907 | 930907 | 2020-12-21 | US | Texas | Sterling | 48431 | 90 | 1 | 0 | 93 | 31.82781912 | -101.0500746 | 2020-12-22 05:22:33 | Sterling, Texas, US |
2122718 | 2122718 | 2020-12-20 | US | Texas | Armstrong | 48011 | 155 | 5 | 0 | 93 | 34.96507426 | -101.3574874 | 2020-12-21 05:27:58 | Armstrong, Texas, US |
2934225 | 2934225 | 2020-12-19 | US | Texas | Armstrong | 48011 | 153 | 5 | 0 | 93 | 34.96507426 | -101.3574874 | 2020-12-20 05:27:32 | Armstrong, Texas, US |
2934341 | 2934341 | 2020-12-19 | US | Texas | Jeff Davis | 48243 | 89 | 1 | 0 | 93 | 30.71490589 | -104.1399973 | 2020-12-20 05:27:32 | Jeff Davis, Texas, US |
1904171 | 1904171 | 2020-12-18 | US | Texas | Armstrong | 48011 | 153 | 5 | 0 | 93 | 34.96507426 | -101.3574874 | 2020-12-19 05:27:52 | Armstrong, Texas, US |
1904287 | 1904287 | 2020-12-18 | US | Texas | Jeff Davis | 48243 | 88 | 1 | 0 | 93 | 30.71490589 | -104.1399973 | 2020-12-19 05:27:52 | Jeff Davis, Texas, US |
2131113 | 2131113 | 2020-12-17 | US | Texas | Jeff Davis | 48243 | 88 | 1 | 0 | 93 | 30.71490589 | -104.1399973 | 2020-12-18 05:28:18 | Jeff Davis, Texas, US |
3152007 | 3152007 | 2020-12-16 | US | North Dakota | Sheridan | 38083 | 95 | 2 | 0 | 93 | 47.57700669 | -100.3426391 | 2020-12-17 05:28:12 | Sheridan, North Dakota, US |
1036788 | 1036788 | 2020-12-15 | US | North Dakota | Sheridan | 38083 | 94 | 2 | 0 | 93 | 47.57700669 | -100.3426391 | 2020-12-16 05:28:04 | Sheridan, North Dakota, US |
1753682 | 1753682 | 2020-12-14 | US | North Dakota | Sheridan | 38083 | 94 | 2 | 0 | 93 | 47.57700669 | -100.3426391 | 2020-12-15 05:26:38 | Sheridan, North Dakota, US |
3850202 | 3850202 | 2020-12-13 | US | North Dakota | Sheridan | 38083 | 94 | 2 | 0 | 93 | 47.57700669 | -100.3426391 | 2020-12-14 05:26:27 | Sheridan, North Dakota, US |
847984 | 847984 | 2020-12-12 | US | North Dakota | Sheridan | 38083 | 94 | 2 | 0 | 93 | 47.57700669 | -100.3426391 | 2020-12-13 05:27:20 | Sheridan, North Dakota, US |
861342 | 861342 | 2020-12-11 | US | Delaware | Unassigned | 90010 | 93 | 0 | 0 | 93 | 39.57992638 | 0.0 | 2020-12-12 05:26:19 | Unassigned, Delaware, US |
1600884 | 1600884 | 2020-12-10 | US | Delaware | Unassigned | 90010 | 93 | 0 | 0 | 93 | 39.57992638 | 0.0 | 2020-12-11 05:26:59 | Unassigned, Delaware, US |
1601918 | 1601918 | 2020-12-10 | US | Minnesota | Cook | 27031 | 93 | 0 | 0 | 93 | 47.90504893 | -90.52629546 | 2020-12-11 05:26:59 | Cook, Minnesota, US |
2976927 | 2976927 | 2020-12-09 | US | Minnesota | Cook | 27031 | 93 | 0 | 0 | 93 | 47.90504893 | -90.52629546 | 2020-12-10 05:26:19 | Cook, Minnesota, US |
2977198 | 2977198 | 2020-12-09 | US | Missouri | Worth | 29227 | 93 | 0 | 0 | 93 | 40.47945588 | -94.42328751 | 2020-12-10 05:26:19 | Worth, Missouri, US |
1820051 | 1820051 | 2020-12-08 | US | Kansas | Comanche | 20033 | 94 | 1 | 0 | 93 | 37.19114520000001 | -99.27113247 | 2020-12-09 05:28:01 | Comanche, Kansas, US |
2348687 | 2348687 | 2020-12-07 | US | Kansas | Comanche | 20033 | 94 | 1 | 0 | 93 | 37.19114520000001 | -99.27113247 | 2020-12-08 05:27:42 | Comanche, Kansas, US |
1635196 | 1635196 | 2020-12-05 | US | South Dakota | Sully | 46119 | 96 | 3 | 0 | 93 | 44.71571812 | -100.1278092 | 2020-12-06 05:26:18 | Sully, South Dakota, US |
3862724 | 3862724 | 2020-12-04 | US | South Dakota | Sully | 46119 | 96 | 3 | 0 | 93 | 44.71571812 | -100.1278092 | 2020-12-05 05:27:36 | Sully, South Dakota, US |
3862892 | 3862892 | 2020-12-04 | US | Texas | Dickens | 48125 | 119 | 4 | 0 | 93 | 33.61616822 | -100.7788855 | 2020-12-05 05:27:36 | Dickens, Texas, US |
3863144 | 3863144 | 2020-12-04 | US | Virginia | Craig | 51045 | 94 | 1 | 0 | 93 | 37.48133648 | -80.21072274 | 2020-12-05 05:27:36 | Craig, Virginia, US |
76345 | 76345 | 2020-12-03 | US | Kansas | Chautauqua | 20019 | 94 | 1 | 0 | 93 | 37.14994405 | -96.2454192 | 2020-12-04 05:27:27 | Chautauqua, Kansas, US |
77086 | 77086 | 2020-12-03 | US | Montana | Liberty | 30051 | 94 | 1 | 0 | 93 | 48.56084317 | -111.024307 | 2020-12-04 05:27:27 | Liberty, Montana, US |
739557 | 739557 | 2020-12-02 | US | Kansas | Chautauqua | 20019 | 94 | 1 | 0 | 93 | 37.14994405 | -96.2454192 | 2020-12-03 05:28:22 | Chautauqua, Kansas, US |
740298 | 740298 | 2020-12-02 | US | Montana | Liberty | 30051 | 94 | 1 | 0 | 93 | 48.56084317 | -111.024307 | 2020-12-03 05:28:22 | Liberty, Montana, US |
2538694 | 2538694 | 2020-12-01 | US | Kansas | Lincoln | 20105 | 94 | 1 | 0 | 93 | 39.04549684 | -98.20756994 | 2020-12-02 05:27:41 | Lincoln, Kansas, US |
1585463 | 1585463 | 2020-11-30 | US | Kansas | Lincoln | 20105 | 94 | 1 | 0 | 93 | 39.04549684 | -98.20756994 | 2020-12-01 05:26:18 | Lincoln, Kansas, US |
1586905 | 1586905 | 2020-11-30 | US | Puerto Rico | Lajas | 72079 | 93 | 0 | 0 | 93 | 18.011661 | -67.040585 | 2020-12-01 05:26:18 | Lajas, Puerto Rico, US |
1587373 | 1587373 | 2020-11-30 | US | Texas | Sherman | 48421 | 157 | 2 | 0 | 93 | 36.27751473 | -101.8933156 | 2020-12-01 05:26:18 | Sherman, Texas, US |
3568578 | 3568578 | 2020-11-29 | US | Montana | Prairie | 30079 | 93 | 0 | 0 | 93 | 46.86048047 | -105.379384 | 2020-11-30 05:26:13 | Prairie, Montana, US |
3569776 | 3569776 | 2020-11-29 | US | Texas | Sherman | 48421 | 155 | 2 | 0 | 93 | 36.27751473 | -101.8933156 | 2020-11-30 05:26:13 | Sherman, Texas, US |
2938441 | 2938441 | 2020-11-28 | US | Texas | Sherman | 48421 | 152 | 2 | 0 | 93 | 36.27751473 | -101.8933156 | 2020-11-29 05:25:55 | Sherman, Texas, US |
2938555 | 2938555 | 2020-11-28 | US | Virginia | Falls Church | 51610 | 99 | 6 | 0 | 93 | 38.88485255 | -77.17560759 | 2020-11-29 05:25:55 | Falls Church, Virginia, US |
393957 | 393957 | 2020-11-27 | US | Minnesota | Lake of the Woods | 27077 | 94 | 1 | 0 | 93 | 48.77217001 | -94.90274472 | 2020-11-28 05:25:50 | Lake of the Woods, Minnesota, US |
395444 | 395444 | 2020-11-27 | US | Texas | Sherman | 48421 | 151 | 2 | 0 | 93 | 36.27751473 | -101.8933156 | 2020-11-28 05:25:50 | Sherman, Texas, US |
924708 | 924708 | 2020-11-26 | US | Illinois | Pope | 17151 | 94 | 1 | 0 | 93 | 37.41391284 | -88.56152109 | 2020-11-27 05:26:53 | Pope, Illinois, US |
926891 | 926891 | 2020-11-26 | US | Texas | Sherman | 48421 | 149 | 2 | 0 | 93 | 36.27751473 | -101.8933156 | 2020-11-27 05:26:53 | Sherman, Texas, US |
1976098 | 1976098 | 2020-11-25 | US | West Virginia | Wirt | 54105 | 94 | 1 | 0 | 93 | 39.02775007 | -81.37473928 | 2020-11-26 05:27:44 | Wirt, West Virginia, US |
1352299 | 1352299 | 2020-11-24 | US | Montana | Daniels | 30019 | 96 | 3 | 0 | 93 | 48.78420029 | -105.54763429999998 | 2020-11-25 05:27:20 | Daniels, Montana, US |
1352382 | 1352382 | 2020-11-24 | US | Nebraska | Garfield | 31071 | 94 | 1 | 0 | 93 | 41.91428955 | -98.99111827 | 2020-11-25 05:27:20 | Garfield, Nebraska, US |
1353527 | 1353527 | 2020-11-24 | US | Texas | Sherman | 48421 | 148 | 1 | 0 | 93 | 36.27751473 | -101.8933156 | 2020-11-25 05:27:20 | Sherman, Texas, US |
680376 | 680376 | 2020-11-23 | US | Nebraska | Garfield | 31071 | 94 | 1 | 0 | 93 | 41.91428955 | -98.99111827 | 2020-11-24 05:27:31 | Garfield, Nebraska, US |
3192194 | 3192194 | 2020-11-22 | US | New Mexico | Union | 35059 | 95 | 2 | 0 | 93 | 36.48126404 | -103.4709624 | 2020-11-23 05:25:26 | Union, New Mexico, US |
3193120 | 3193120 | 2020-11-22 | US | Texas | Kimble | 48267 | 106 | 2 | 0 | 93 | 30.48678918 | -99.74856473 | 2020-11-23 05:25:26 | Kimble, Texas, US |
3838023 | 3838023 | 2020-11-21 | US | Maine | Aroostook | 23003 | 94 | 1 | 0 | 93 | 46.65926321 | -68.59841248 | 2020-11-22 05:25:45 | Aroostook, Maine, US |
2704717 | 2704717 | 2020-11-20 | US | Texas | Shackelford | 48417 | 80 | 0 | 0 | 93 | 32.73587756 | -99.35401337 | 2020-11-21 05:25:51 | Shackelford, Texas, US |
824289 | 824289 | 2020-11-19 | US | Puerto Rico | Ceiba | 72037 | 93 | 0 | 0 | 93 | 18.251818 | -65.666416 | 2020-11-20 05:26:28 | Ceiba, Puerto Rico, US |
825036 | 825036 | 2020-11-19 | US | West Virginia | Doddridge | 54017 | 95 | 2 | 0 | 93 | 39.27057157 | -80.70671527 | 2020-11-20 05:26:28 | Doddridge, West Virginia, US |
125122 | 125122 | 2020-11-18 | US | North Dakota | Steele | 38091 | 104 | 1 | 0 | 93 | 47.45611548 | -97.72728747 | 2020-11-19 05:25:23 | Steele, North Dakota, US |
125423 | 125423 | 2020-11-18 | US | Puerto Rico | Ceiba | 72037 | 93 | 0 | 0 | 93 | 18.251818 | -65.666416 | 2020-11-19 05:25:23 | Ceiba, Puerto Rico, US |
3340250 | 3340250 | 2020-11-17 | US | Michigan | Montmorency | 26119 | 94 | 1 | 0 | 93 | 45.0275929 | -84.12696227 | 2020-11-18 05:40:31 | Montmorency, Michigan, US |
3340657 | 3340657 | 2020-11-17 | US | Nebraska | Gosper | 31073 | 94 | 1 | 0 | 93 | 40.51481965 | -99.83020279 | 2020-11-18 05:40:31 | Gosper, Nebraska, US |
3340781 | 3340781 | 2020-11-17 | US | New Mexico | Los Alamos | 35028 | 93 | 0 | 0 | 93 | 35.86631386 | -106.3134985 | 2020-11-18 05:40:31 | Los Alamos, New Mexico, US |
3341137 | 3341137 | 2020-11-17 | US | Oklahoma | Harmon | 40057 | 93 | 0 | 0 | 93 | 34.7440135 | -99.84741652 | 2020-11-18 05:40:31 | Harmon, Oklahoma, US |
3341311 | 3341311 | 2020-11-17 | US | Puerto Rico | Ceiba | 72037 | 93 | 0 | 0 | 93 | 18.251818 | -65.666416 | 2020-11-18 05:40:31 | Ceiba, Puerto Rico, US |
3171733 | 3171733 | 2020-11-16 | US | Nebraska | Perkins | 31135 | 103 | 10 | 0 | 93 | 40.85082525 | -101.6502942 | 2020-11-17 05:25:54 | Perkins, Nebraska, US |
3172182 | 3172182 | 2020-11-16 | US | Oklahoma | Harmon | 40057 | 93 | 0 | 0 | 93 | 34.7440135 | -99.84741652 | 2020-11-17 05:25:54 | Harmon, Oklahoma, US |
2882301 | 2882301 | 2020-11-15 | US | Nebraska | Perkins | 31135 | 103 | 10 | 0 | 93 | 40.85082525 | -101.6502942 | 2020-11-16 05:25:57 | Perkins, Nebraska, US |
2882750 | 2882750 | 2020-11-15 | US | Oklahoma | Harmon | 40057 | 93 | 0 | 0 | 93 | 34.7440135 | -99.84741652 | 2020-11-16 05:25:57 | Harmon, Oklahoma, US |
2882974 | 2882974 | 2020-11-15 | US | Puerto Rico | Santa Isabel | 72133 | 93 | 0 | 0 | 93 | 17.994525 | -66.388913 | 2020-11-16 05:25:57 | Santa Isabel, Puerto Rico, US |
2917279 | 2917279 | 2020-11-14 | US | Nebraska | Perkins | 31135 | 103 | 10 | 0 | 93 | 40.85082525 | -101.6502942 | 2020-11-15 05:26:53 | Perkins, Nebraska, US |
2918458 | 2918458 | 2020-11-14 | US | Vermont | Lamoille | 50015 | 94 | 1 | 0 | 93 | 44.60353043 | -72.64356694 | 2020-11-15 05:26:53 | Lamoille, Vermont, US |
2918848 | 2918848 | 2020-11-14 | US | Alaska | Copper River | 2066 | 93 | 0 | 0 | 93 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2785670 | 2785670 | 2020-11-13 | US | Delaware | Unassigned | 90010 | 93 | 0 | 0 | 93 | 39.57992638 | 0.0 | 2020-11-14 05:25:37 | Unassigned, Delaware, 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]);