johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
819 rows where active = 185 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 76
- Georgia 54
- Virginia 50
- Puerto Rico 41
- Indiana 37
- Kentucky 37
- Illinois 26
- Nebraska 26
- Louisiana 24
- Missouri 24
- North Carolina 24
- Colorado 22
- Ohio 22
- Iowa 21
- Minnesota 21
- Montana 21
- New York 21
- Mississippi 20
- Tennessee 20
- West Virginia 19
- Kansas 18
- Wisconsin 17
- Idaho 14
- Michigan 14
- Arkansas 13
- New Mexico 10
- Oklahoma 10
- Oregon 10
- South Carolina 10
- Wyoming 10
- …
country_or_region 1
- US · 819 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3668524 | 3668524 | 2021-03-06 | US | Hawaii | Kauai | 15007 | 186 | 1 | 0 | 185 | 22.03935037 | -159.5966786 | 2021-03-07 05:21:54 | Kauai, Hawaii, US |
3670744 | 3670744 | 2021-03-06 | US | Texas | Jeff Davis | 48243 | 175 | 2 | 0 | 185 | 30.71490589 | -104.1399973 | 2021-03-07 05:21:54 | Jeff Davis, Texas, US |
1617145 | 1617145 | 2021-03-05 | US | Hawaii | Kauai | 15007 | 186 | 1 | 0 | 185 | 22.03935037 | -159.5966786 | 2021-03-06 04:23:41 | Kauai, Hawaii, US |
1619365 | 1619365 | 2021-03-05 | US | Texas | Jeff Davis | 48243 | 175 | 2 | 0 | 185 | 30.71490589 | -104.1399973 | 2021-03-06 04:23:41 | Jeff Davis, Texas, US |
2208556 | 2208556 | 2021-03-04 | US | Hawaii | Kauai | 15007 | 186 | 1 | 0 | 185 | 22.03935037 | -159.5966786 | 2021-03-05 05:26:29 | Kauai, Hawaii, US |
1093197 | 1093197 | 2021-03-03 | US | Texas | Jeff Davis | 48243 | 175 | 2 | 0 | 185 | 30.71490589 | -104.1399973 | 2021-03-04 05:24:24 | Jeff Davis, Texas, US |
999039 | 999039 | 2021-03-01 | US | Colorado | Costilla | 8023 | 193 | 2 | 0 | 185 | 37.27732493 | -105.4276548 | 2021-03-02 05:23:30 | Costilla, Colorado, US |
2368097 | 2368097 | 2021-02-28 | US | Colorado | Costilla | 8023 | 190 | 2 | 0 | 185 | 37.27732493 | -105.4276548 | 2021-03-01 05:23:01 | Costilla, Colorado, US |
3066599 | 3066599 | 2021-02-27 | US | Colorado | Costilla | 8023 | 190 | 2 | 0 | 185 | 37.27732493 | -105.4276548 | 2021-02-28 05:22:20 | Costilla, Colorado, US |
532768 | 532768 | 2021-02-22 | US | Nebraska | Frontier | 31063 | 186 | 1 | 0 | 185 | 40.52993007 | -100.3924658 | 2021-02-23 05:23:41 | Frontier, Nebraska, US |
184102 | 184102 | 2021-02-21 | US | Nebraska | Frontier | 31063 | 186 | 1 | 0 | 185 | 40.52993007 | -100.3924658 | 2021-02-22 05:24:21 | Frontier, Nebraska, US |
744376 | 744376 | 2021-02-20 | US | Nebraska | Frontier | 31063 | 186 | 1 | 0 | 185 | 40.52993007 | -100.3924658 | 2021-02-21 05:24:33 | Frontier, Nebraska, US |
745054 | 745054 | 2021-02-20 | US | Puerto Rico | Jayuya | 72073 | 185 | 0 | 0 | 185 | 18.211446 | -66.58878 | 2021-02-21 05:24:33 | Jayuya, Puerto Rico, US |
473474 | 473474 | 2021-02-19 | US | Nebraska | Frontier | 31063 | 186 | 1 | 0 | 185 | 40.52993007 | -100.3924658 | 2021-02-20 05:22:51 | Frontier, Nebraska, US |
474152 | 474152 | 2021-02-19 | US | Puerto Rico | Jayuya | 72073 | 185 | 0 | 0 | 185 | 18.211446 | -66.58878 | 2021-02-20 05:22:51 | Jayuya, Puerto Rico, US |
1155104 | 1155104 | 2021-02-18 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-19 05:24:16 | Daniels, Montana, US |
1155861 | 1155861 | 2021-02-18 | US | Puerto Rico | Jayuya | 72073 | 185 | 0 | 0 | 185 | 18.211446 | -66.58878 | 2021-02-19 05:24:16 | Jayuya, Puerto Rico, US |
3603024 | 3603024 | 2021-02-17 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-18 05:22:58 | Daniels, Montana, US |
3603781 | 3603781 | 2021-02-17 | US | Puerto Rico | Jayuya | 72073 | 185 | 0 | 0 | 185 | 18.211446 | -66.58878 | 2021-02-18 05:22:58 | Jayuya, Puerto Rico, US |
3051465 | 3051465 | 2021-02-16 | US | Kansas | Hodgeman | 20083 | 192 | 7 | 0 | 185 | 38.08780079 | -99.89829881 | 2021-02-17 05:23:10 | Hodgeman, Kansas, US |
3052159 | 3052159 | 2021-02-16 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-17 05:23:10 | Daniels, Montana, US |
3052916 | 3052916 | 2021-02-16 | US | Puerto Rico | Jayuya | 72073 | 185 | 0 | 0 | 185 | 18.211446 | -66.58878 | 2021-02-17 05:23:10 | Jayuya, Puerto Rico, US |
1339564 | 1339564 | 2021-02-15 | US | Kansas | Hodgeman | 20083 | 192 | 7 | 0 | 185 | 38.08780079 | -99.89829881 | 2021-02-16 05:24:38 | Hodgeman, Kansas, US |
1340258 | 1340258 | 2021-02-15 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-16 05:24:38 | Daniels, Montana, US |
1341015 | 1341015 | 2021-02-15 | US | Puerto Rico | Jayuya | 72073 | 185 | 0 | 0 | 185 | 18.211446 | -66.58878 | 2021-02-16 05:24:38 | Jayuya, Puerto Rico, US |
2284715 | 2284715 | 2021-02-14 | US | Kansas | Hodgeman | 20083 | 192 | 7 | 0 | 185 | 38.08780079 | -99.89829881 | 2021-02-15 05:24:49 | Hodgeman, Kansas, US |
2285409 | 2285409 | 2021-02-14 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-15 05:24:49 | Daniels, Montana, US |
2679115 | 2679115 | 2021-02-13 | US | Kansas | Hodgeman | 20083 | 192 | 7 | 0 | 185 | 38.08780079 | -99.89829881 | 2021-02-14 05:23:43 | Hodgeman, Kansas, US |
2679809 | 2679809 | 2021-02-13 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-14 05:23:43 | Daniels, Montana, US |
3540748 | 3540748 | 2021-02-12 | US | Kansas | Hodgeman | 20083 | 192 | 7 | 0 | 185 | 38.08780079 | -99.89829881 | 2021-02-13 05:22:12 | Hodgeman, Kansas, US |
3541442 | 3541442 | 2021-02-12 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-13 05:22:12 | Daniels, Montana, US |
2638388 | 2638388 | 2021-02-11 | US | Delaware | Unassigned | 90010 | 185 | 0 | 0 | 185 | 39.57992638 | 0.0 | 2021-02-12 05:23:29 | Unassigned, Delaware, US |
2639705 | 2639705 | 2021-02-11 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-12 05:23:29 | Daniels, Montana, US |
3980560 | 3980560 | 2021-02-10 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-11 05:23:55 | Daniels, Montana, US |
1529189 | 1529189 | 2021-02-09 | US | Kansas | Jewell | 20089 | 189 | 4 | 0 | 185 | 39.78470589 | -98.21820662 | 2021-02-10 05:22:41 | Jewell, Kansas, US |
1529880 | 1529880 | 2021-02-09 | US | Montana | Daniels | 30019 | 192 | 7 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-10 05:22:41 | Daniels, Montana, US |
614605 | 614605 | 2021-02-08 | US | Idaho | Butte | 16023 | 186 | 1 | 0 | 185 | 43.72592209 | -113.1735463 | 2021-02-09 05:23:30 | Butte, Idaho, US |
614980 | 614980 | 2021-02-08 | US | Kansas | Jewell | 20089 | 189 | 4 | 0 | 185 | 39.78470589 | -98.21820662 | 2021-02-09 05:23:30 | Jewell, Kansas, US |
1673374 | 1673374 | 2021-02-07 | US | Idaho | Butte | 16023 | 186 | 1 | 0 | 185 | 43.72592209 | -113.1735463 | 2021-02-08 05:22:39 | Butte, Idaho, US |
975835 | 975835 | 2021-02-06 | US | Idaho | Butte | 16023 | 186 | 1 | 0 | 185 | 43.72592209 | -113.1735463 | 2021-02-07 05:23:00 | Butte, Idaho, US |
1589093 | 1589093 | 2021-02-05 | US | Idaho | Butte | 16023 | 186 | 1 | 0 | 185 | 43.72592209 | -113.1735463 | 2021-02-06 05:23:55 | Butte, Idaho, US |
791300 | 791300 | 2021-02-04 | US | Idaho | Butte | 16023 | 186 | 1 | 0 | 185 | 43.72592209 | -113.1735463 | 2021-02-05 05:22:38 | Butte, Idaho, US |
342258 | 342258 | 2021-02-03 | US | Montana | Daniels | 30019 | 191 | 6 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-04 05:22:26 | Daniels, Montana, US |
1686484 | 1686484 | 2021-02-02 | US | Montana | Daniels | 30019 | 191 | 6 | 0 | 185 | 48.78420029 | -105.54763429999998 | 2021-02-03 05:22:52 | Daniels, Montana, US |
1461752 | 1461752 | 2021-01-31 | US | Montana | Granite | 30039 | 187 | 2 | 0 | 185 | 46.40605220000001 | -113.4414186 | 2021-02-01 05:22:53 | Granite, Montana, US |
1461856 | 1461856 | 2021-01-31 | US | Nebraska | Pawnee | 31133 | 186 | 1 | 0 | 185 | 40.13141096 | -96.23705437 | 2021-02-01 05:22:53 | Pawnee, Nebraska, US |
2213660 | 2213660 | 2021-01-30 | US | Montana | Granite | 30039 | 187 | 2 | 0 | 185 | 46.40605220000001 | -113.4414186 | 2021-01-31 05:22:42 | Granite, Montana, US |
2213764 | 2213764 | 2021-01-30 | US | Nebraska | Pawnee | 31133 | 186 | 1 | 0 | 185 | 40.13141096 | -96.23705437 | 2021-01-31 05:22:42 | Pawnee, Nebraska, US |
1899864 | 1899864 | 2021-01-29 | US | Puerto Rico | Arroyo | 72015 | 185 | 0 | 0 | 185 | 17.998457000000005 | -66.056546 | 2021-01-30 05:22:49 | Arroyo, Puerto Rico, US |
2482617 | 2482617 | 2021-01-28 | US | Colorado | Sedgwick | 8115 | 187 | 2 | 0 | 185 | 40.87595412 | -102.3519227 | 2021-01-29 05:22:23 | Sedgwick, Colorado, US |
3156215 | 3156215 | 2021-01-27 | US | Oregon | Harney | 41025 | 191 | 6 | 0 | 185 | 43.06422669 | -118.9666306 | 2021-01-28 05:22:24 | Harney, Oregon, US |
2468874 | 2468874 | 2021-01-22 | US | Nebraska | Greeley | 31077 | 187 | 2 | 0 | 185 | 41.56742671 | -98.52150266 | 2021-01-23 05:22:03 | Greeley, Nebraska, US |
2469969 | 2469969 | 2021-01-22 | US | Texas | Menard | 48327 | 180 | 5 | 0 | 185 | 30.88990665 | -99.8204794 | 2021-01-23 05:22:03 | Menard, Texas, US |
437425 | 437425 | 2021-01-21 | US | Nebraska | Greeley | 31077 | 187 | 2 | 0 | 185 | 41.56742671 | -98.52150266 | 2021-01-22 05:22:10 | Greeley, Nebraska, US |
3504097 | 3504097 | 2021-01-17 | US | Georgia | Baker | 13007 | 191 | 6 | 0 | 185 | 31.32669878 | -84.44218806 | 2021-01-18 05:22:34 | Baker, Georgia, US |
3506090 | 3506090 | 2021-01-17 | US | Puerto Rico | Guayanilla | 72059 | 185 | 0 | 0 | 185 | 18.039942 | -66.79186 | 2021-01-18 05:22:34 | Guayanilla, Puerto Rico, US |
3518868 | 3518868 | 2021-01-15 | US | West Virginia | Calhoun | 54013 | 185 | 0 | 0 | 185 | 38.84315422 | -81.11934872 | 2021-01-16 05:22:40 | Calhoun, West Virginia, US |
776418 | 776418 | 2021-01-12 | US | Nebraska | Harlan | 31083 | 185 | 0 | 0 | 185 | 40.17658508 | -99.40438879 | 2021-01-13 05:22:15 | Harlan, Nebraska, US |
3902030 | 3902030 | 2021-01-09 | US | Nebraska | Harlan | 31083 | 185 | 0 | 0 | 185 | 40.17658508 | -99.40438879 | 2021-01-10 05:22:12 | Harlan, Nebraska, US |
157370 | 157370 | 2021-01-08 | US | Virginia | Rappahannock | 51157 | 187 | 2 | 0 | 185 | 38.68295619 | -78.15826963 | 2021-01-09 05:22:18 | Rappahannock, Virginia, US |
157492 | 157492 | 2021-01-08 | US | West Virginia | Webster | 54101 | 185 | 0 | 0 | 185 | 38.49370949 | -80.4202023 | 2021-01-09 05:22:18 | Webster, West Virginia, US |
3037182 | 3037182 | 2021-01-05 | US | South Dakota | McPherson | 46089 | 186 | 1 | 0 | 185 | 45.76626028 | -99.22118798 | 2021-01-06 05:22:16 | McPherson, South Dakota, US |
1062613 | 1062613 | 2021-01-04 | US | Georgia | Clay | 13061 | 188 | 3 | 0 | 185 | 31.62221166 | -84.97713865 | 2021-01-05 05:21:49 | Clay, Georgia, US |
3232657 | 3232657 | 2021-01-03 | US | New Mexico | Union | 35059 | 192 | 7 | 0 | 185 | 36.48126404 | -103.4709624 | 2021-01-04 05:22:02 | Union, New Mexico, US |
1139090 | 1139090 | 2021-01-01 | US | New Mexico | Union | 35059 | 192 | 7 | 0 | 185 | 36.48126404 | -103.4709624 | 2021-01-02 05:22:33 | Union, New Mexico, US |
3697696 | 3697696 | 2020-12-31 | US | New Mexico | Union | 35059 | 192 | 7 | 0 | 185 | 36.48126404 | -103.4709624 | 2021-01-01 05:23:07 | Union, New Mexico, US |
1012511 | 1012511 | 2020-12-30 | US | New Mexico | Union | 35059 | 192 | 7 | 0 | 185 | 36.48126404 | -103.4709624 | 2020-12-31 05:22:49 | Union, New Mexico, US |
1013024 | 1013024 | 2020-12-30 | US | Puerto Rico | Ceiba | 72037 | 185 | 0 | 0 | 185 | 18.251818 | -65.666416 | 2020-12-31 05:22:49 | Ceiba, Puerto Rico, US |
1013610 | 1013610 | 2020-12-30 | US | Virginia | Charles City | 51036 | 193 | 8 | 0 | 185 | 37.35358063 | -77.05634116 | 2020-12-31 05:22:49 | Charles City, Virginia, US |
769039 | 769039 | 2020-12-29 | US | Puerto Rico | Ceiba | 72037 | 185 | 0 | 0 | 185 | 18.251818 | -65.666416 | 2020-12-30 05:22:34 | Ceiba, Puerto Rico, US |
3780518 | 3780518 | 2020-12-27 | US | Oregon | Lake | 41037 | 189 | 4 | 0 | 185 | 42.79246693 | -120.3850163 | 2020-12-28 05:22:06 | Lake, Oregon, US |
2223916 | 2223916 | 2020-12-26 | US | Alaska | Aleutians West | 2016 | 185 | 0 | 0 | 185 | 52.3233 | -174.1596 | 2020-12-27 05:22:55 | Aleutians West, Alaska, US |
2226123 | 2226123 | 2020-12-26 | US | Oregon | Lake | 41037 | 189 | 4 | 0 | 185 | 42.79246693 | -120.3850163 | 2020-12-27 05:22:55 | Lake, Oregon, US |
929752 | 929752 | 2020-12-21 | US | Nebraska | Franklin | 31061 | 187 | 2 | 0 | 185 | 40.17636348 | -98.95299073 | 2020-12-22 05:22:33 | Franklin, Nebraska, US |
2121773 | 2121773 | 2020-12-20 | US | Nebraska | Franklin | 31061 | 187 | 2 | 0 | 185 | 40.17636348 | -98.95299073 | 2020-12-21 05:27:58 | Franklin, Nebraska, US |
2129754 | 2129754 | 2020-12-17 | US | Minnesota | Traverse | 27155 | 187 | 2 | 0 | 185 | 45.77298854 | -96.47062949 | 2020-12-18 05:28:18 | Traverse, Minnesota, US |
2131031 | 2131031 | 2020-12-17 | US | Texas | Cochran | 48079 | 257 | 5 | 0 | 185 | 33.60425307 | -102.8284499 | 2020-12-18 05:28:18 | Cochran, Texas, US |
2131139 | 2131139 | 2020-12-17 | US | Texas | Lipscomb | 48295 | 224 | 6 | 0 | 185 | 36.27783108 | -100.2733151 | 2020-12-18 05:28:18 | Lipscomb, Texas, US |
3151238 | 3151238 | 2020-12-16 | US | Michigan | Luce | 26095 | 185 | 0 | 0 | 185 | 46.47227431 | -85.54471223 | 2020-12-17 05:28:12 | Luce, Michigan, US |
3152354 | 3152354 | 2020-12-16 | US | Puerto Rico | Rincon | 72117 | 185 | 0 | 0 | 185 | 18.335443 | -67.23174 | 2020-12-17 05:28:12 | Rincon, Puerto Rico, US |
3152631 | 3152631 | 2020-12-16 | US | Texas | Cochran | 48079 | 255 | 5 | 0 | 185 | 33.60425307 | -102.8284499 | 2020-12-17 05:28:12 | Cochran, Texas, US |
3152639 | 3152639 | 2020-12-16 | US | Texas | Concho | 48095 | 239 | 3 | 0 | 185 | 31.32635934 | -99.86473038 | 2020-12-17 05:28:12 | Concho, Texas, US |
1035712 | 1035712 | 2020-12-15 | US | Kansas | Smith | 20183 | 186 | 1 | 0 | 185 | 39.78516566 | -98.78566062 | 2020-12-16 05:28:04 | Smith, Kansas, US |
1037135 | 1037135 | 2020-12-15 | US | Puerto Rico | Rincon | 72117 | 185 | 0 | 0 | 185 | 18.335443 | -67.23174 | 2020-12-16 05:28:04 | Rincon, Puerto Rico, US |
1752606 | 1752606 | 2020-12-14 | US | Kansas | Smith | 20183 | 186 | 1 | 0 | 185 | 39.78516566 | -98.78566062 | 2020-12-15 05:26:38 | Smith, Kansas, US |
1754342 | 1754342 | 2020-12-14 | US | Texas | Fisher | 48151 | 204 | 5 | 0 | 185 | 32.74281316 | -100.4019302 | 2020-12-15 05:26:38 | Fisher, Texas, US |
3850333 | 3850333 | 2020-12-13 | US | Oklahoma | Harmon | 40057 | 185 | 0 | 0 | 185 | 34.7440135 | -99.84741652 | 2020-12-14 05:26:27 | Harmon, Oklahoma, US |
3850862 | 3850862 | 2020-12-13 | US | Texas | Fisher | 48151 | 201 | 5 | 0 | 185 | 32.74281316 | -100.4019302 | 2020-12-14 05:26:27 | Fisher, Texas, US |
846004 | 846004 | 2020-12-12 | US | Alaska | Yukon-Koyukuk | 2290 | 189 | 4 | 0 | 185 | 65.50815459 | -151.3907387 | 2020-12-13 05:27:20 | Yukon-Koyukuk, Alaska, US |
848644 | 848644 | 2020-12-12 | US | Texas | Fisher | 48151 | 201 | 5 | 0 | 185 | 32.74281316 | -100.4019302 | 2020-12-13 05:27:20 | Fisher, Texas, US |
849165 | 849165 | 2020-12-12 | US | Wyoming | Hot Springs | 56017 | 186 | 1 | 0 | 185 | 43.71930657 | -108.4423174 | 2020-12-13 05:27:20 | Hot Springs, Wyoming, US |
863066 | 863066 | 2020-12-11 | US | North Dakota | Golden Valley | 38033 | 187 | 0 | 0 | 185 | 46.94022281 | -103.8465421 | 2020-12-12 05:26:19 | Golden Valley, North Dakota, US |
863280 | 863280 | 2020-12-11 | US | Oregon | Curry | 41015 | 187 | 2 | 0 | 185 | 42.45911325 | -124.157282 | 2020-12-12 05:26:19 | Curry, Oregon, US |
863719 | 863719 | 2020-12-11 | US | Texas | Collingsworth | 48087 | 203 | 3 | 0 | 185 | 34.96489496 | -100.2700111 | 2020-12-12 05:26:19 | Collingsworth, Texas, US |
863751 | 863751 | 2020-12-11 | US | Texas | Fisher | 48151 | 201 | 5 | 0 | 185 | 32.74281316 | -100.4019302 | 2020-12-12 05:26:19 | Fisher, Texas, US |
863771 | 863771 | 2020-12-11 | US | Texas | Hall | 48191 | 267 | 3 | 0 | 185 | 34.5307555 | -100.6813852 | 2020-12-12 05:26:19 | Hall, Texas, US |
864039 | 864039 | 2020-12-11 | US | Virginia | Mathews | 51115 | 186 | 1 | 0 | 185 | 37.44164146 | -76.34098896 | 2020-12-12 05:26:19 | Mathews, Virginia, US |
1603261 | 1603261 | 2020-12-10 | US | Texas | Collingsworth | 48087 | 198 | 2 | 0 | 185 | 34.96489496 | -100.2700111 | 2020-12-11 05:26:59 | Collingsworth, Texas, US |
1603293 | 1603293 | 2020-12-10 | US | Texas | Fisher | 48151 | 200 | 5 | 0 | 185 | 32.74281316 | -100.4019302 | 2020-12-11 05:26:59 | Fisher, Texas, US |
1603623 | 1603623 | 2020-12-10 | US | Virginia | Surry | 51181 | 190 | 5 | 0 | 185 | 37.11781893 | -76.88450012 | 2020-12-11 05:26:59 | Surry, 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]);