johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
208 rows where active = 1204 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 164
- Russia 15
- Colombia 4
- Croatia 3
- Mexico 3
- Ukraine 3
- Chile 2
- Germany 2
- Angola 1
- Canada 1
- India 1
- Italy 1
- Japan 1
- Luxembourg 1
- Namibia 1
- Pakistan 1
- Peru 1
- Switzerland 1
- Tajikistan 1
- Trinidad and Tobago 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903958 | 3903958 | 2021-07-31 | Italy | Liguria | 105328 | 4363 | 99761 | 1204 | 44.41149315 | 8.9326992 | 2021-08-01 04:21:50 | Liguria, Italy | ||
408525 | 408525 | 2021-07-28 | Russia | North Ossetia - Alania Republic | 18565 | 257 | 17104 | 1204 | 42.79336110000001 | 44.6324493 | 2021-07-29 04:21:33 | North Ossetia - Alania Republic, Russia | ||
1893354 | 1893354 | 2021-06-30 | Russia | Khanty-Mansi Autonomous Okrug | 59888 | 809 | 57875 | 1204 | 61.0259025 | 69.0982628 | 2021-07-01 04:21:19 | Khanty-Mansi Autonomous Okrug, Russia | ||
563215 | 563215 | 2021-06-22 | Russia | Smolensk Oblast | 33043 | 1084 | 30755 | 1204 | 55.03434960000001 | 33.0192065 | 2021-06-23 04:21:46 | Smolensk Oblast, Russia | ||
3393248 | 3393248 | 2021-04-28 | Colombia | Narino | 53312 | 1759 | 50349 | 1204 | 1.2892 | -77.3579 | 2021-04-29 04:20:55 | Narino, Colombia | ||
3242580 | 3242580 | 2021-04-21 | Russia | Tyumen Oblast | 34691 | 446 | 33041 | 1204 | 58.8206488 | 70.36588370000001 | 2021-04-22 04:20:53 | Tyumen Oblast, Russia | ||
2983371 | 2983371 | 2021-04-10 | Namibia | 45323 | 564 | 43555 | 1204 | -22.9576 | 18.4904 | 2021-04-11 04:20:56 | Namibia | |||
2247398 | 2247398 | 2021-04-07 | Japan | Chiba | 30343 | 581 | 28558 | 1204 | 35.510141 | 140.198917 | 2021-04-08 04:21:13 | Chiba, Japan | ||
2247176 | 2247176 | 2021-04-07 | Chile | Antofagasta | 44493 | 887 | 42402 | 1204 | -23.6509 | -70.3975 | 2021-04-08 04:21:13 | Antofagasta, Chile | ||
3620926 | 3620926 | 2021-03-17 | Colombia | Cordoba | 40122 | 1906 | 37012 | 1204 | 8.0493 | -75.574 | 2021-03-18 05:26:22 | Cordoba, Colombia | ||
352063 | 352063 | 2021-03-11 | Canada | Manitoba | 32509 | 911 | 30394 | 1204 | 53.7609 | -98.8139 | 2021-03-12 05:26:50 | Manitoba, Canada | ||
1619532 | 1619532 | 2021-03-05 | US | Virginia | Alleghany | 51005 | 1251 | 47 | 0 | 1204 | 37.78636074 | -80.00222498 | 2021-03-06 04:23:41 | Alleghany, Virginia, US |
1616453 | 1616453 | 2021-03-05 | Russia | Khanty-Mansi Autonomous Okrug | 51982 | 756 | 50022 | 1204 | 61.0259025 | 69.0982628 | 2021-03-06 04:23:41 | Khanty-Mansi Autonomous Okrug, Russia | ||
2208059 | 2208059 | 2021-03-04 | US | Alabama | Wilcox | 1131 | 1229 | 25 | 0 | 1204 | 31.98773215 | -87.30891118 | 2021-03-05 05:26:29 | Wilcox, Alabama, US |
1000988 | 1000988 | 2021-03-01 | US | Oklahoma | Haskell | 40061 | 1214 | 10 | 0 | 1204 | 35.22257600000001 | -95.11513306 | 2021-03-02 05:23:30 | Haskell, Oklahoma, US |
998701 | 998701 | 2021-03-01 | Russia | Yaroslavl Oblast | 32944 | 406 | 31334 | 1204 | 57.77819760000001 | 39.0021095 | 2021-03-02 05:23:30 | Yaroslavl Oblast, Russia | ||
2370046 | 2370046 | 2021-02-28 | US | Oklahoma | Haskell | 40061 | 1213 | 9 | 0 | 1204 | 35.22257600000001 | -95.11513306 | 2021-03-01 05:23:01 | Haskell, Oklahoma, US |
1859712 | 1859712 | 2021-02-25 | US | Minnesota | Faribault | 27043 | 1220 | 16 | 0 | 1204 | 43.67381499 | -93.94787458 | 2021-02-26 05:22:40 | Faribault, Minnesota, US |
280147 | 280147 | 2021-02-24 | India | Rajasthan | 319801 | 2785 | 315812 | 1204 | 26.583423 | 73.847973 | 2021-02-25 05:24:57 | Rajasthan, India | ||
1938103 | 1938103 | 2021-02-23 | US | Michigan | Mason | 26105 | 1230 | 26 | 0 | 1204 | 43.99509218 | -86.24988902 | 2021-02-24 05:29:16 | Mason, Michigan, US |
530543 | 530543 | 2021-02-22 | Colombia | Boyaca | 45671 | 1063 | 43404 | 1204 | 5.4545 | -73.362 | 2021-02-23 05:23:41 | Boyaca, Colombia | ||
185025 | 185025 | 2021-02-21 | US | Tennessee | Stewart | 47161 | 1222 | 24 | 0 | 1204 | 36.50235092 | -87.83920548 | 2021-02-22 05:24:21 | Stewart, Tennessee, US |
184240 | 184240 | 2021-02-21 | US | New Mexico | San Miguel | 35047 | 1214 | 10 | 0 | 1204 | 35.48014807 | -104.8163562 | 2021-02-22 05:24:21 | San Miguel, New Mexico, US |
183595 | 183595 | 2021-02-21 | US | Maine | Somerset | 23025 | 1230 | 26 | 0 | 1204 | 45.51229767 | -69.95995554 | 2021-02-22 05:24:21 | Somerset, Maine, US |
745299 | 745299 | 2021-02-20 | US | Tennessee | Stewart | 47161 | 1221 | 24 | 0 | 1204 | 36.50235092 | -87.83920548 | 2021-02-21 05:24:33 | Stewart, Tennessee, US |
474397 | 474397 | 2021-02-19 | US | Tennessee | Stewart | 47161 | 1221 | 24 | 0 | 1204 | 36.50235092 | -87.83920548 | 2021-02-20 05:22:51 | Stewart, Tennessee, US |
1154755 | 1154755 | 2021-02-18 | US | Michigan | Iosco | 26069 | 1271 | 67 | 0 | 1204 | 44.35486835 | -83.63484895 | 2021-02-19 05:24:16 | Iosco, Michigan, US |
1154664 | 1154664 | 2021-02-18 | US | Maine | Aroostook | 23003 | 1247 | 43 | 0 | 1204 | 46.65926321 | -68.59841248 | 2021-02-19 05:24:16 | Aroostook, Maine, US |
1153871 | 1153871 | 2021-02-18 | US | Georgia | Brooks | 13027 | 1247 | 43 | 0 | 1204 | 30.83922642 | -83.58303423 | 2021-02-19 05:24:16 | Brooks, Georgia, US |
3602675 | 3602675 | 2021-02-17 | US | Michigan | Iosco | 26069 | 1270 | 66 | 0 | 1204 | 44.35486835 | -83.63484895 | 2021-02-18 05:22:58 | Iosco, Michigan, US |
3540274 | 3540274 | 2021-02-12 | US | Georgia | Jasper | 13159 | 1232 | 28 | 0 | 1204 | 33.31535543 | -83.68844964 | 2021-02-13 05:22:12 | Jasper, Georgia, US |
2641023 | 2641023 | 2021-02-11 | US | Virginia | Buchanan | 51027 | 1236 | 32 | 0 | 1204 | 37.26818323 | -82.03749726 | 2021-02-12 05:23:29 | Buchanan, Virginia, US |
3979186 | 3979186 | 2021-02-10 | US | Colorado | Elbert | 8039 | 1292 | 12 | 0 | 1204 | 39.28656773 | -104.1358721 | 2021-02-11 05:23:55 | Elbert, Colorado, US |
616317 | 616317 | 2021-02-08 | US | Oregon | Union | 41061 | 1222 | 18 | 0 | 1204 | 45.30915495 | -118.0068979 | 2021-02-09 05:23:30 | Union, Oregon, US |
1675010 | 1675010 | 2021-02-07 | US | Oklahoma | Johnston | 40069 | 1221 | 17 | 0 | 1204 | 34.31440473 | -96.66011537 | 2021-02-08 05:22:39 | Johnston, Oklahoma, US |
1673827 | 1673827 | 2021-02-07 | US | Kentucky | Butler | 21031 | 1222 | 18 | 0 | 1204 | 37.20946153 | -86.68748787 | 2021-02-08 05:22:39 | Butler, Kentucky, US |
976388 | 976388 | 2021-02-06 | US | Kentucky | Washington | 21229 | 1228 | 24 | 0 | 1204 | 37.75599461 | -85.17407732 | 2021-02-07 05:23:00 | Washington, Kentucky, US |
342605 | 342605 | 2021-02-03 | US | North Carolina | Madison | 37115 | 1234 | 30 | 0 | 1204 | 35.85402722 | -82.71346418 | 2021-02-04 05:22:26 | Madison, North Carolina, US |
342497 | 342497 | 2021-02-03 | US | New York | Delaware | 36025 | 1234 | 30 | 0 | 1204 | 42.19837623 | -74.96709306 | 2021-02-04 05:22:26 | Delaware, New York, US |
1686723 | 1686723 | 2021-02-02 | US | New York | Delaware | 36025 | 1233 | 29 | 0 | 1204 | 42.19837623 | -74.96709306 | 2021-02-03 05:22:52 | Delaware, New York, US |
2212427 | 2212427 | 2021-01-30 | US | Georgia | Charlton | 13049 | 1227 | 23 | 0 | 1204 | 30.78371028 | -82.13951596 | 2021-01-31 05:22:42 | Charlton, Georgia, US |
1897363 | 1897363 | 2021-01-29 | Russia | Khakassia Republic | 20278 | 382 | 18692 | 1204 | 53.72258845 | 91.44293627 | 2021-01-30 05:22:49 | Khakassia Republic, Russia | ||
3156452 | 3156452 | 2021-01-27 | US | South Dakota | Charles Mix | 46023 | 1219 | 15 | 0 | 1204 | 43.20660134 | -98.58856175 | 2021-01-28 05:22:24 | Charles Mix, South Dakota, US |
13583 | 13583 | 2021-01-26 | US | Iowa | Winnebago | 19189 | 1233 | 29 | 0 | 1204 | 43.37751174 | -93.73407298 | 2021-01-27 05:23:41 | Winnebago, Iowa, US |
2568593 | 2568593 | 2021-01-25 | US | Idaho | Gooding | 16047 | 1226 | 22 | 0 | 1204 | 42.96927962 | -114.8108306 | 2021-01-26 05:22:02 | Gooding, Idaho, US |
1760225 | 1760225 | 2021-01-24 | US | Idaho | Gooding | 16047 | 1226 | 22 | 0 | 1204 | 42.96927962 | -114.8108306 | 2021-01-25 05:22:16 | Gooding, Idaho, US |
2428819 | 2428819 | 2021-01-23 | US | Missouri | Livingston | 29117 | 1229 | 25 | 0 | 1204 | 39.78110272 | -93.54645978 | 2021-01-24 05:22:35 | Livingston, Missouri, US |
2427948 | 2427948 | 2021-01-23 | US | Illinois | Wabash | 17185 | 1216 | 12 | 0 | 1204 | 38.44272901 | -87.84922065 | 2021-01-24 05:22:35 | Wabash, Illinois, US |
1094835 | 1094835 | 2021-01-20 | US | Georgia | Bleckley | 13023 | 1244 | 40 | 0 | 1204 | 32.43829035 | -83.33035166 | 2021-01-21 05:22:01 | Bleckley, Georgia, US |
3506830 | 3506830 | 2021-01-17 | US | West Virginia | Hampshire | 54027 | 1228 | 24 | 0 | 1204 | 39.32103553 | -78.60826476 | 2021-01-18 05:22:34 | Hampshire, West Virginia, US |
3881282 | 3881282 | 2021-01-14 | US | Minnesota | Fillmore | 27045 | 1208 | 4 | 0 | 1204 | 43.67394126 | -92.08980382 | 2021-01-15 05:22:24 | Fillmore, Minnesota, US |
775481 | 775481 | 2021-01-12 | US | Indiana | Tipton | 18159 | 1243 | 39 | 0 | 1204 | 40.31123252 | -86.05234925 | 2021-01-13 05:22:15 | Tipton, Indiana, US |
192301 | 192301 | 2021-01-11 | US | New York | Lewis | 36049 | 1225 | 21 | 0 | 1204 | 43.7844157 | -75.44903992 | 2021-01-12 05:22:15 | Lewis, New York, US |
2629254 | 2629254 | 2021-01-10 | US | Virginia | Prince Edward | 51147 | 1222 | 18 | 0 | 1204 | 37.22554789 | -78.43597949 | 2021-01-11 05:21:50 | Prince Edward, Virginia, US |
2866069 | 2866069 | 2021-01-06 | US | Kentucky | Adair | 21001 | 1243 | 39 | 0 | 1204 | 37.10459774 | -85.28129668 | 2021-01-07 05:22:03 | Adair, Kentucky, US |
3037641 | 3037641 | 2021-01-05 | US | Virginia | Halifax | 51083 | 1242 | 38 | 0 | 1204 | 36.76654925 | -78.93512622 | 2021-01-06 05:22:16 | Halifax, Virginia, US |
3037384 | 3037384 | 2021-01-05 | US | Texas | Gaines | 48165 | 456 | 30 | 0 | 1204 | 32.74055318 | -102.6353295 | 2021-01-06 05:22:16 | Gaines, Texas, US |
3037282 | 3037282 | 2021-01-05 | US | Tennessee | Sequatchie | 47153 | 1177 | 17 | 0 | 1204 | 35.36979721 | -85.41022136 | 2021-01-06 05:22:16 | Sequatchie, Tennessee, US |
3036014 | 3036014 | 2021-01-05 | US | Minnesota | Houston | 27055 | 1217 | 13 | 0 | 1204 | 43.67129565 | -91.49143057 | 2021-01-06 05:22:16 | Houston, Minnesota, US |
3035657 | 3035657 | 2021-01-05 | US | Kentucky | Allen | 21003 | 1221 | 17 | 0 | 1204 | 36.75197631 | -86.19457544 | 2021-01-06 05:22:16 | Allen, Kentucky, US |
1064929 | 1064929 | 2021-01-04 | US | Texas | Gaines | 48165 | 456 | 30 | 0 | 1204 | 32.74055318 | -102.6353295 | 2021-01-05 05:21:49 | Gaines, Texas, US |
1063387 | 1063387 | 2021-01-04 | US | Louisiana | Winn | 22127 | 1234 | 30 | 0 | 1204 | 31.94449367 | -92.63789413 | 2021-01-05 05:21:49 | Winn, Louisiana, US |
1063073 | 1063073 | 2021-01-04 | US | Iowa | Poweshiek | 19157 | 1228 | 24 | 0 | 1204 | 41.68625425 | -92.53155731 | 2021-01-05 05:21:49 | Poweshiek, Iowa, US |
3233532 | 3233532 | 2021-01-03 | US | Texas | Gaines | 48165 | 456 | 30 | 0 | 1204 | 32.74055318 | -102.6353295 | 2021-01-04 05:22:02 | Gaines, Texas, US |
2230601 | 2230601 | 2021-01-02 | US | Texas | Gaines | 48165 | 456 | 30 | 0 | 1204 | 32.74055318 | -102.6353295 | 2021-01-03 05:22:52 | Gaines, Texas, US |
2228979 | 2228979 | 2021-01-02 | US | Kentucky | Simpson | 21213 | 1214 | 10 | 0 | 1204 | 36.74058474 | -86.58047435 | 2021-01-03 05:22:52 | Simpson, Kentucky, US |
1139874 | 1139874 | 2021-01-01 | US | Tennessee | Union | 47173 | 1286 | 17 | 0 | 1204 | 36.28590426 | -83.83651902 | 2021-01-02 05:22:33 | Union, Tennessee, US |
3698480 | 3698480 | 2020-12-31 | US | Tennessee | Union | 47173 | 1276 | 17 | 0 | 1204 | 36.28590426 | -83.83651902 | 2021-01-01 05:23:07 | Union, Tennessee, US |
3695876 | 3695876 | 2020-12-31 | US | Alabama | Monroe | 1099 | 1215 | 11 | 0 | 1204 | 31.56729412 | -87.36995001 | 2021-01-01 05:23:07 | Monroe, Alabama, US |
1012005 | 1012005 | 2020-12-30 | US | Minnesota | Cottonwood | 27033 | 1218 | 14 | 0 | 1204 | 44.00715262 | -95.18138802 | 2020-12-31 05:22:49 | Cottonwood, Minnesota, US |
1010934 | 1010934 | 2020-12-30 | US | Colorado | Montezuma | 8083 | 1328 | 18 | 0 | 1204 | 37.33859579 | -108.5958857 | 2020-12-31 05:22:49 | Montezuma, Colorado, US |
1010785 | 1010785 | 2020-12-30 | US | Arkansas | Hempstead | 5057 | 1215 | 11 | 0 | 1204 | 33.73325583 | -93.66935133 | 2020-12-31 05:22:49 | Hempstead, Arkansas, US |
3764310 | 3764310 | 2020-12-28 | US | Puerto Rico | Dorado | 72051 | 1204 | 0 | 0 | 1204 | 18.436115 | -66.278669 | 2020-12-29 05:22:37 | Dorado, Puerto Rico, US |
3762986 | 3762986 | 2020-12-28 | US | Kentucky | Hart | 21099 | 1213 | 9 | 0 | 1204 | 37.29943898 | -85.88461055 | 2020-12-29 05:22:37 | Hart, Kentucky, US |
3780630 | 3780630 | 2020-12-27 | US | Puerto Rico | Dorado | 72051 | 1204 | 0 | 0 | 1204 | 18.436115 | -66.278669 | 2020-12-28 05:22:06 | Dorado, Puerto Rico, US |
3779306 | 3779306 | 2020-12-27 | US | Kentucky | Hart | 21099 | 1213 | 9 | 0 | 1204 | 37.29943898 | -85.88461055 | 2020-12-28 05:22:06 | Hart, Kentucky, US |
2226297 | 2226297 | 2020-12-26 | US | South Carolina | Abbeville | 45001 | 1228 | 24 | 0 | 1204 | 34.22333378 | -82.46170658 | 2020-12-27 05:22:55 | Abbeville, South Carolina, US |
2225779 | 2225779 | 2020-12-26 | US | New York | Wyoming | 36121 | 1221 | 17 | 0 | 1204 | 42.70145109 | -78.22199579 | 2020-12-27 05:22:55 | Wyoming, New York, US |
3693595 | 3693595 | 2020-12-24 | US | Nebraska | Unassigned | 90031 | 1208 | 4 | 0 | 1204 | 42.8997274 | 0.0 | 2020-12-25 05:22:48 | Unassigned, Nebraska, US |
3691272 | 3691272 | 2020-12-24 | Chile | Maule | 23960 | 538 | 22218 | 1204 | -35.5183 | -71.6885 | 2020-12-25 05:22:48 | Maule, Chile | ||
2407989 | 2407989 | 2020-12-23 | US | Iowa | Butler | 19023 | 1221 | 17 | 0 | 1204 | 42.73172833 | -92.79015971 | 2020-12-24 05:23:04 | Butler, Iowa, US |
928873 | 928873 | 2020-12-21 | US | Iowa | Floyd | 19067 | 1235 | 31 | 0 | 1204 | 43.06000529999999 | -92.78940097 | 2020-12-22 05:22:33 | Floyd, Iowa, US |
2122521 | 2122521 | 2020-12-20 | US | South Carolina | Fairfield | 45039 | 1255 | 51 | 0 | 1204 | 34.39287073 | -81.1195624 | 2020-12-21 05:27:58 | Fairfield, South Carolina, US |
2934573 | 2934573 | 2020-12-19 | US | Virginia | Lee | 51105 | 1230 | 26 | 0 | 1204 | 36.70586667 | -83.12606515 | 2020-12-20 05:27:32 | Lee, Virginia, US |
2933154 | 2933154 | 2020-12-19 | US | Missouri | Pemiscot | 29155 | 1224 | 20 | 0 | 1204 | 36.2130572 | -89.78742322 | 2020-12-20 05:27:32 | Pemiscot, Missouri, US |
2932401 | 2932401 | 2020-12-19 | US | Iowa | Floyd | 19067 | 1232 | 28 | 0 | 1204 | 43.06000529999999 | -92.78940097 | 2020-12-20 05:27:32 | Floyd, Iowa, US |
3150550 | 3150550 | 2020-12-16 | US | Illinois | Carroll | 17015 | 1232 | 28 | 0 | 1204 | 42.06823429 | -89.93395545 | 2020-12-17 05:28:12 | Carroll, Illinois, US |
1035802 | 1035802 | 2020-12-15 | US | Kentucky | Marshall | 21157 | 1222 | 18 | 0 | 1204 | 36.88007070000001 | -88.32803576 | 2020-12-16 05:28:04 | Marshall, Kentucky, US |
1754572 | 1754572 | 2020-12-14 | US | Virginia | Carroll | 51035 | 1235 | 31 | 0 | 1204 | 36.73066666 | -80.73455942 | 2020-12-15 05:26:38 | Carroll, Virginia, US |
2978774 | 2978774 | 2020-12-09 | US | Wisconsin | Lafayette | 55065 | 1209 | 5 | 0 | 1204 | 42.66005229 | -90.1317729 | 2020-12-10 05:26:19 | Lafayette, Wisconsin, US |
2976726 | 2976726 | 2020-12-09 | US | Louisiana | Jackson | 22049 | 1237 | 33 | 0 | 1204 | 32.30251776 | -92.55692092 | 2020-12-10 05:26:19 | Jackson, Louisiana, US |
1822296 | 1822296 | 2020-12-08 | US | West Virginia | Wayne | 54099 | 1220 | 16 | 0 | 1204 | 38.14901357 | -82.42287994 | 2020-12-09 05:28:01 | Wayne, West Virginia, US |
1635532 | 1635532 | 2020-12-05 | US | Texas | Upshur | 48459 | 1204 | 22 | 0 | 1204 | 32.73706798 | -94.93999853 | 2020-12-06 05:26:18 | Upshur, Texas, US |
1633504 | 1633504 | 2020-12-05 | US | Iowa | Kossuth | 19109 | 1213 | 9 | 0 | 1204 | 43.20405458 | -94.20691791 | 2020-12-06 05:26:18 | Kossuth, Iowa, US |
3860320 | 3860320 | 2020-12-04 | US | Arkansas | Lawrence | 5075 | 1235 | 31 | 0 | 1204 | 36.04188196 | -91.10867198 | 2020-12-05 05:27:36 | Lawrence, Arkansas, US |
77497 | 77497 | 2020-12-03 | US | North Dakota | Ramsey | 38071 | 1236 | 9 | 0 | 1204 | 48.26886249 | -98.72223879 | 2020-12-04 05:27:27 | Ramsey, North Dakota, US |
2540171 | 2540171 | 2020-12-01 | US | Puerto Rico | Vega Baja | 72145 | 1204 | 0 | 0 | 1204 | 18.428262 | -66.397924 | 2020-12-02 05:27:41 | Vega Baja, Puerto Rico, US |
2937155 | 2937155 | 2020-11-28 | US | Missouri | Moniteau | 29135 | 1219 | 15 | 0 | 1204 | 38.63571781 | -92.57976951 | 2020-11-29 05:25:55 | Moniteau, Missouri, US |
393594 | 393594 | 2020-11-27 | US | Kentucky | Bell | 21013 | 1223 | 19 | 0 | 1204 | 36.73355174 | -83.67766671 | 2020-11-28 05:25:50 | Bell, Kentucky, US |
1974384 | 1974384 | 2020-11-25 | US | Mississippi | Holmes | 28051 | 1265 | 61 | 0 | 1204 | 33.12345854 | -90.08923538 | 2020-11-26 05:27:44 | Holmes, Mississippi, 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]);