johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
170 rows where active = 1454 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 19
- US 128
- Russia 11
- Equatorial Guinea 7
- Chile 3
- Italy 3
- Ukraine 3
- Japan 2
- Mexico 2
- Angola 1
- Canada 1
- Korea, South 1
- Lebanon 1
- Malaysia 1
- Netherlands 1
- Pakistan 1
- Senegal 1
- Sweden 1
- Uzbekistan 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2677483 | 2677483 | 2021-07-18 | Yemen | 6981 | 1368 | 4159 | 1454 | 15.552727 | 48.516388 | 2021-07-19 04:21:24 | Yemen | |||
3706112 | 3706112 | 2021-07-17 | Italy | Marche | 104252 | 3038 | 99760 | 1454 | 43.61675973 | 13.5188753 | 2021-07-18 04:22:07 | Marche, Italy | ||
3129182 | 3129182 | 2021-06-28 | Malaysia | Kelantan | 34521 | 217 | 32850 | 1454 | 6.1254 | 102.2381 | 2021-06-29 04:21:28 | Kelantan, Malaysia | ||
3125274 | 3125274 | 2021-06-28 | Canada | Manitoba | 56036 | 1139 | 53443 | 1454 | 53.7609 | -98.8139 | 2021-06-29 04:21:28 | Manitoba, Canada | ||
1711929 | 1711929 | 2021-06-02 | Ukraine | Chernihiv Oblast | 56866 | 1315 | 54097 | 1454 | 51.4982 | 31.2893 | 2021-06-03 04:23:32 | Chernihiv Oblast, Ukraine | ||
1192368 | 1192368 | 2021-05-31 | Ukraine | Ivano-Frankivsk Oblast | 86188 | 2059 | 82675 | 1454 | 48.9226 | 24.7111 | 2021-06-01 04:23:09 | Ivano-Frankivsk Oblast, Ukraine | ||
1873174 | 1873174 | 2021-05-15 | Russia | Leningrad Oblast | 43813 | 1292 | 41067 | 1454 | 60.1853296 | 32.3925325 | 2021-05-16 04:20:49 | Leningrad Oblast, Russia | ||
3054394 | 3054394 | 2021-05-13 | Russia | Kaluga Oblast | 34760 | 322 | 32984 | 1454 | 54.4382773 | 35.5272854 | 2021-05-14 04:20:41 | Kaluga Oblast, Russia | ||
3393620 | 3393620 | 2021-04-28 | Russia | Murmansk Oblast | 50280 | 1155 | 47671 | 1454 | 68.00004179999999 | 33.9999151 | 2021-04-29 04:20:55 | Murmansk Oblast, Russia | ||
36618 | 36618 | 2021-04-12 | Russia | Belgorod Oblast | 35296 | 590 | 33252 | 1454 | 50.7080119 | 37.5837615 | 2021-04-13 04:20:37 | Belgorod Oblast, Russia | ||
605689 | 605689 | 2021-04-09 | Japan | Aichi | 28516 | 600 | 26462 | 1454 | 35.035551 | 137.211621 | 2021-04-10 04:20:59 | Aichi, Japan | ||
2649414 | 2649414 | 2021-04-08 | Uzbekistan | 84322 | 634 | 82234 | 1454 | 41.377491 | 64.585262 | 2021-04-09 04:21:13 | Uzbekistan | |||
1837963 | 1837963 | 2021-03-12 | Japan | Osaka | 48093 | 1150 | 45489 | 1454 | 34.620965000000005 | 135.507481 | 2021-03-13 05:25:15 | Osaka, Japan | ||
3670799 | 3670799 | 2021-03-06 | US | Texas | Nolan | 48353 | 1389 | 50 | 0 | 1454 | 32.30365282 | -100.4060208 | 2021-03-07 05:21:54 | Nolan, Texas, US |
3669224 | 3669224 | 2021-03-06 | US | Michigan | Alpena | 26007 | 1502 | 48 | 0 | 1454 | 45.03477666 | -83.62212411 | 2021-03-07 05:21:54 | Alpena, Michigan, US |
3668756 | 3668756 | 2021-03-06 | US | Indiana | Tipton | 18159 | 1495 | 41 | 0 | 1454 | 40.31123252 | -86.05234925 | 2021-03-07 05:21:54 | Tipton, Indiana, US |
1619697 | 1619697 | 2021-03-05 | US | Washington | Unassigned | 90053 | 1459 | 5 | 0 | 1454 | 48.82227976 | 0.0 | 2021-03-06 04:23:41 | Unassigned, Washington, US |
2370239 | 2370239 | 2021-02-28 | US | Puerto Rico | Juncos | 72077 | 1454 | 0 | 0 | 1454 | 18.223793 | -65.909109 | 2021-03-01 05:23:01 | Juncos, Puerto Rico, US |
3068184 | 3068184 | 2021-02-27 | US | New Mexico | Grant | 35017 | 1488 | 34 | 0 | 1454 | 32.73911281 | -108.3827845 | 2021-02-28 05:22:20 | Grant, New Mexico, US |
2187137 | 2187137 | 2021-02-26 | US | Wisconsin | Marquette | 55077 | 1480 | 26 | 0 | 1454 | 43.81911946 | -89.40073763 | 2021-02-27 05:22:28 | Marquette, Wisconsin, US |
1938656 | 1938656 | 2021-02-23 | US | New Mexico | Taos | 35055 | 1503 | 49 | 0 | 1454 | 36.58006022 | -105.6310198 | 2021-02-24 05:29:16 | Taos, New Mexico, US |
473293 | 473293 | 2021-02-19 | US | Missouri | Clinton | 29049 | 1518 | 64 | 0 | 1454 | 39.6013098 | -94.40465394 | 2021-02-20 05:22:51 | Clinton, Missouri, US |
3053386 | 3053386 | 2021-02-16 | US | Texas | Shelby | 48419 | 1587 | 50 | 0 | 1454 | 31.79211404 | -94.14550696 | 2021-02-17 05:23:10 | Shelby, Texas, US |
3050925 | 3050925 | 2021-02-16 | US | Georgia | Brantley | 13025 | 1481 | 27 | 0 | 1454 | 31.19576557 | -81.97743999 | 2021-02-17 05:23:10 | Brantley, Georgia, US |
2285365 | 2285365 | 2021-02-14 | US | Missouri | Pike | 29163 | 1475 | 21 | 0 | 1454 | 39.34310674 | -91.16980779 | 2021-02-15 05:24:49 | Pike, Missouri, US |
2679765 | 2679765 | 2021-02-13 | US | Missouri | Pike | 29163 | 1475 | 21 | 0 | 1454 | 39.34310674 | -91.16980779 | 2021-02-14 05:23:43 | Pike, Missouri, US |
3542405 | 3542405 | 2021-02-12 | US | Tennessee | Humphreys | 47085 | 1521 | 21 | 0 | 1454 | 36.03958805 | -87.77992872 | 2021-02-13 05:22:12 | Humphreys, Tennessee, US |
3541398 | 3541398 | 2021-02-12 | US | Missouri | Pike | 29163 | 1475 | 21 | 0 | 1454 | 39.34310674 | -91.16980779 | 2021-02-13 05:22:12 | Pike, Missouri, US |
2638699 | 2638699 | 2021-02-11 | US | Illinois | Ford | 17053 | 1497 | 43 | 0 | 1454 | 40.59706922 | -88.22350769 | 2021-02-12 05:23:29 | Ford, Illinois, US |
3981558 | 3981558 | 2021-02-10 | US | Tennessee | Sequatchie | 47153 | 1471 | 26 | 0 | 1454 | 35.36979721 | -85.41022136 | 2021-02-11 05:23:55 | Sequatchie, Tennessee, US |
1531469 | 1531469 | 2021-02-09 | US | Wisconsin | Sawyer | 55113 | 1473 | 19 | 0 | 1454 | 45.87931905 | -91.14504927 | 2021-02-10 05:22:41 | Sawyer, Wisconsin, US |
617150 | 617150 | 2021-02-08 | US | West Virginia | Boone | 54005 | 1484 | 30 | 0 | 1454 | 38.01974191 | -81.69888019 | 2021-02-09 05:23:30 | Boone, West Virginia, US |
1676029 | 1676029 | 2021-02-07 | US | Wisconsin | Sawyer | 55113 | 1471 | 17 | 0 | 1454 | 45.87931905 | -91.14504927 | 2021-02-08 05:22:39 | Sawyer, Wisconsin, US |
976281 | 976281 | 2021-02-06 | US | Kentucky | Bourbon | 21017 | 1460 | 6 | 0 | 1454 | 38.2054607 | -84.21827874 | 2021-02-07 05:23:00 | Bourbon, Kentucky, US |
975397 | 975397 | 2021-02-06 | US | Arkansas | Grant | 5053 | 1483 | 29 | 0 | 1454 | 34.29017991 | -92.42320562 | 2021-02-07 05:23:00 | Grant, Arkansas, US |
1590904 | 1590904 | 2021-02-05 | US | Puerto Rico | Dorado | 72051 | 1454 | 0 | 0 | 1454 | 18.436115 | -66.278669 | 2021-02-06 05:23:55 | Dorado, Puerto Rico, US |
790166 | 790166 | 2021-02-04 | Chile | Araucania | 32832 | 422 | 30956 | 1454 | -38.9489 | -72.3311 | 2021-02-05 05:22:38 | Araucania, Chile | ||
340679 | 340679 | 2021-02-03 | US | Alabama | Washington | 1129 | 1483 | 29 | 0 | 1454 | 31.4092794 | -88.20689944 | 2021-02-04 05:22:26 | Washington, Alabama, US |
1684905 | 1684905 | 2021-02-02 | US | Alabama | Washington | 1129 | 1481 | 27 | 0 | 1454 | 31.4092794 | -88.20689944 | 2021-02-03 05:22:52 | Washington, Alabama, US |
1462693 | 1462693 | 2021-01-31 | US | Tennessee | Grundy | 47061 | 1526 | 24 | 0 | 1454 | 35.38433717 | -85.72142731 | 2021-02-01 05:22:53 | Grundy, Tennessee, US |
2214987 | 2214987 | 2021-01-30 | US | Virginia | Dinwiddie | 51053 | 1472 | 18 | 0 | 1454 | 37.07544585 | -77.63451754 | 2021-01-31 05:22:42 | Dinwiddie, Virginia, US |
1898934 | 1898934 | 2021-01-29 | US | Mississippi | Calhoun | 28013 | 1477 | 23 | 0 | 1454 | 33.93683395 | -89.33686647 | 2021-01-30 05:22:49 | Calhoun, Mississippi, US |
2482446 | 2482446 | 2021-01-28 | US | Arkansas | Franklin | 5047 | 1484 | 30 | 0 | 1454 | 35.51202821 | -93.89299569 | 2021-01-29 05:22:23 | Franklin, Arkansas, US |
3156937 | 3156937 | 2021-01-27 | US | Virginia | Fredericksburg | 51630 | 1468 | 14 | 0 | 1454 | 38.2977863 | -77.4922454 | 2021-01-28 05:22:24 | Fredericksburg, Virginia, US |
3154407 | 3154407 | 2021-01-27 | US | Georgia | Greene | 13133 | 1489 | 35 | 0 | 1454 | 33.5769205 | -83.17139104 | 2021-01-28 05:22:24 | Greene, Georgia, US |
2569945 | 2569945 | 2021-01-25 | US | North Carolina | Bertie | 37015 | 1484 | 30 | 0 | 1454 | 36.0688473 | -76.96545943 | 2021-01-26 05:22:02 | Bertie, North Carolina, US |
1759987 | 1759987 | 2021-01-24 | US | Florida | Hamilton | 12047 | 1469 | 15 | 0 | 1454 | 30.49673973 | -82.94998918 | 2021-01-25 05:22:16 | Hamilton, Florida, US |
1097011 | 1097011 | 2021-01-20 | US | Tennessee | Decatur | 47039 | 1486 | 27 | 0 | 1454 | 35.60048904 | -88.11043779 | 2021-01-21 05:22:01 | Decatur, Tennessee, US |
909685 | 909685 | 2021-01-19 | US | Louisiana | Madison | 22065 | 1480 | 26 | 0 | 1454 | 32.36918118 | -91.23973355 | 2021-01-20 05:21:54 | Madison, Louisiana, US |
238954 | 238954 | 2021-01-18 | US | Minnesota | Hubbard | 27057 | 1492 | 38 | 0 | 1454 | 47.10778564 | -94.91693868 | 2021-01-19 05:22:15 | Hubbard, Minnesota, US |
238013 | 238013 | 2021-01-18 | US | Georgia | Cook | 13075 | 1485 | 31 | 0 | 1454 | 31.16068491 | -83.42947229 | 2021-01-19 05:22:15 | Cook, Georgia, US |
3505071 | 3505071 | 2021-01-17 | US | Minnesota | Hubbard | 27057 | 1492 | 38 | 0 | 1454 | 47.10778564 | -94.91693868 | 2021-01-18 05:22:34 | Hubbard, Minnesota, US |
3880276 | 3880276 | 2021-01-14 | US | Florida | Lafayette | 12067 | 1476 | 22 | 0 | 1454 | 29.98484137 | -83.18166636 | 2021-01-15 05:22:24 | Lafayette, Florida, US |
3880036 | 3880036 | 2021-01-14 | US | Arkansas | Chicot | 5017 | 1489 | 35 | 0 | 1454 | 33.26458973 | -91.29539209 | 2021-01-15 05:22:24 | Chicot, Arkansas, US |
3311655 | 3311655 | 2021-01-13 | US | Washington | Unassigned | 90053 | 1458 | 4 | 0 | 1454 | 48.82227976 | 0.0 | 2021-01-14 05:22:32 | Unassigned, Washington, US |
3308655 | 3308655 | 2021-01-13 | US | Arkansas | Arkansas | 5001 | 1488 | 34 | 0 | 1454 | 34.29145151 | -91.37277296 | 2021-01-14 05:22:32 | Arkansas, Arkansas, US |
775378 | 775378 | 2021-01-12 | US | Illinois | Richland | 17159 | 1486 | 32 | 0 | 1454 | 38.71240969 | -88.08475366 | 2021-01-13 05:22:15 | Richland, Illinois, US |
192345 | 192345 | 2021-01-11 | US | North Carolina | Ashe | 37009 | 1481 | 27 | 0 | 1454 | 36.43296207 | -81.49862729 | 2021-01-12 05:22:15 | Ashe, North Carolina, US |
191312 | 191312 | 2021-01-11 | US | Iowa | Winneshiek | 19191 | 1473 | 19 | 0 | 1454 | 43.29094334 | -91.84422722 | 2021-01-12 05:22:15 | Winneshiek, Iowa, US |
3901437 | 3901437 | 2021-01-09 | US | Louisiana | Assumption | 22007 | 1483 | 29 | 0 | 1454 | 29.89946234 | -91.06461642 | 2021-01-10 05:22:12 | Assumption, Louisiana, US |
156983 | 156983 | 2021-01-08 | US | Texas | Andrews | 48003 | 1188 | 32 | 0 | 1454 | 32.30468633 | -102.6376548 | 2021-01-09 05:22:18 | Andrews, Texas, US |
156892 | 156892 | 2021-01-08 | US | Tennessee | Cannon | 47015 | 1488 | 16 | 0 | 1454 | 35.80990797 | -86.05738983 | 2021-01-09 05:22:18 | Cannon, Tennessee, US |
155460 | 155460 | 2021-01-08 | US | Louisiana | Assumption | 22007 | 1483 | 29 | 0 | 1454 | 29.89946234 | -91.06461642 | 2021-01-09 05:22:18 | Assumption, Louisiana, US |
2544707 | 2544707 | 2021-01-07 | US | Virginia | Buckingham | 51029 | 1466 | 12 | 0 | 1454 | 37.57242268 | -78.52518834 | 2021-01-08 05:22:42 | Buckingham, Virginia, US |
3233289 | 3233289 | 2021-01-03 | US | South Dakota | Bon Homme | 46009 | 1477 | 23 | 0 | 1454 | 42.98914167 | -97.88592746 | 2021-01-04 05:22:02 | Bon Homme, South Dakota, US |
2229322 | 2229322 | 2021-01-02 | US | Mississippi | Jasper | 28061 | 1479 | 25 | 0 | 1454 | 32.01922104 | -89.11786866 | 2021-01-03 05:22:52 | Jasper, Mississippi, US |
2228897 | 2228897 | 2021-01-02 | US | Kentucky | Clark | 21049 | 1469 | 15 | 0 | 1454 | 37.9689263 | -84.14615986 | 2021-01-03 05:22:52 | Clark, Kentucky, US |
1139722 | 1139722 | 2021-01-01 | US | South Dakota | Bon Homme | 46009 | 1477 | 23 | 0 | 1454 | 42.98914167 | -97.88592746 | 2021-01-02 05:22:33 | Bon Homme, South Dakota, US |
3698328 | 3698328 | 2020-12-31 | US | South Dakota | Bon Homme | 46009 | 1477 | 23 | 0 | 1454 | 42.98914167 | -97.88592746 | 2021-01-01 05:23:07 | Bon Homme, South Dakota, US |
3695749 | 3695749 | 2020-12-31 | Russia | Voronezh Oblast | 46205 | 1145 | 43606 | 1454 | 50.9800393 | 40.15065070000001 | 2021-01-01 05:23:07 | Voronezh Oblast, Russia | ||
1013690 | 1013690 | 2020-12-30 | US | Virginia | Pulaski | 51155 | 1485 | 31 | 0 | 1454 | 37.06474963 | -80.71229738 | 2020-12-31 05:22:49 | Pulaski, Virginia, US |
1013143 | 1013143 | 2020-12-30 | US | South Dakota | Bon Homme | 46009 | 1477 | 23 | 0 | 1454 | 42.98914167 | -97.88592746 | 2020-12-31 05:22:49 | Bon Homme, South Dakota, US |
1011431 | 1011431 | 2020-12-30 | US | Indiana | Spencer | 18147 | 1468 | 14 | 0 | 1454 | 38.01519732 | -87.0079644 | 2020-12-31 05:22:49 | Spencer, Indiana, US |
3771326 | 3771326 | 2020-12-22 | US | Kentucky | Perry | 21193 | 1466 | 12 | 0 | 1454 | 37.25023553 | -83.22922731 | 2020-12-23 05:22:03 | Perry, Kentucky, US |
2123128 | 2123128 | 2020-12-20 | US | Virginia | Winchester | 51840 | 1460 | 6 | 0 | 1454 | 39.17054517 | -78.17325058 | 2020-12-21 05:27:58 | Winchester, Virginia, US |
1903817 | 1903817 | 2020-12-18 | US | Pennsylvania | Clinton | 42035 | 1471 | 17 | 0 | 1454 | 41.23255967 | -77.63785995 | 2020-12-19 05:27:52 | Clinton, Pennsylvania, US |
2129936 | 2129936 | 2020-12-17 | US | Missouri | Randolph | 29175 | 1469 | 15 | 0 | 1454 | 39.44007257 | -92.4971374 | 2020-12-18 05:28:18 | Randolph, Missouri, US |
3150387 | 3150387 | 2020-12-16 | US | Georgia | Franklin | 13119 | 1479 | 25 | 0 | 1454 | 34.37525597 | -83.23159927 | 2020-12-17 05:28:12 | Franklin, Georgia, US |
1601007 | 1601007 | 2020-12-10 | US | Georgia | Emanuel | 13107 | 1502 | 48 | 0 | 1454 | 32.59221302 | -82.30239915 | 2020-12-11 05:26:59 | Emanuel, Georgia, US |
2978359 | 2978359 | 2020-12-09 | US | Texas | Kerr | 48265 | 1483 | 26 | 0 | 1454 | 30.06040006 | -99.34930144 | 2020-12-10 05:26:19 | Kerr, Texas, US |
2350998 | 2350998 | 2020-12-07 | US | Wisconsin | Taylor | 55119 | 1469 | 15 | 0 | 1454 | 45.21179252 | -90.5004405 | 2020-12-08 05:27:42 | Taylor, Wisconsin, US |
2350716 | 2350716 | 2020-12-07 | US | Virginia | Augusta | 51015 | 1466 | 12 | 0 | 1454 | 38.16404586 | -79.12461614 | 2020-12-08 05:27:42 | Augusta, Virginia, US |
1009779 | 1009779 | 2020-12-06 | US | West Virginia | Mercer | 54055 | 1495 | 41 | 0 | 1454 | 37.40481169 | -81.11023142 | 2020-12-07 05:26:14 | Mercer, West Virginia, US |
1007415 | 1007415 | 2020-12-06 | US | Indiana | Randolph | 18135 | 1484 | 30 | 0 | 1454 | 40.15734772 | -85.01139319 | 2020-12-07 05:26:14 | Randolph, Indiana, US |
3862938 | 3862938 | 2020-12-04 | US | Texas | Hill | 48217 | 1730 | 20 | 0 | 1454 | 31.99045053 | -97.13423143 | 2020-12-05 05:27:36 | Hill, Texas, US |
3861770 | 3861770 | 2020-12-04 | US | Missouri | Polk | 29167 | 1466 | 12 | 0 | 1454 | 37.6162296 | -93.39828174 | 2020-12-05 05:27:36 | Polk, Missouri, US |
3860801 | 3860801 | 2020-12-04 | US | Illinois | Douglas | 17041 | 1470 | 16 | 0 | 1454 | 39.76768052 | -88.21854195 | 2020-12-05 05:27:36 | Douglas, Illinois, US |
78565 | 78565 | 2020-12-03 | US | West Virginia | Jefferson | 54037 | 1471 | 17 | 0 | 1454 | 39.30776166 | -77.86014147 | 2020-12-04 05:27:27 | Jefferson, West Virginia, US |
2539907 | 2539907 | 2020-12-01 | US | Ohio | Washington | 39167 | 1496 | 42 | 0 | 1454 | 39.45690571 | -81.49121382 | 2020-12-02 05:27:41 | Washington, Ohio, US |
2937058 | 2937058 | 2020-11-28 | US | Mississippi | Pearl River | 28109 | 1521 | 67 | 0 | 1454 | 30.77090935 | -89.58677275 | 2020-11-29 05:25:55 | Pearl River, Mississippi, US |
392757 | 392757 | 2020-11-27 | US | Arkansas | Union | 5139 | 1510 | 56 | 0 | 1454 | 33.16887091 | -92.59746952 | 2020-11-28 05:25:50 | Union, Arkansas, US |
392497 | 392497 | 2020-11-27 | Russia | Zabaykalsky Krai | 18434 | 302 | 16678 | 1454 | 52.248521 | 115.956325 | 2020-11-28 05:25:50 | Zabaykalsky Krai, Russia | ||
925455 | 925455 | 2020-11-26 | US | Mississippi | Alcorn | 28003 | 1482 | 28 | 0 | 1454 | 34.88084463 | -88.57996173 | 2020-11-27 05:26:53 | Alcorn, Mississippi, US |
1351550 | 1351550 | 2020-11-24 | US | Iowa | Tama | 19171 | 1494 | 40 | 0 | 1454 | 42.07991767 | -92.53266945 | 2020-11-25 05:27:20 | Tama, Iowa, US |
3839451 | 3839451 | 2020-11-21 | US | Tennessee | Overton | 47133 | 1518 | 33 | 0 | 1454 | 36.34117832 | -85.28989535 | 2020-11-22 05:25:45 | Overton, Tennessee, US |
3839134 | 3839134 | 2020-11-21 | US | Pennsylvania | Crawford | 42039 | 1465 | 11 | 0 | 1454 | 41.68447709 | -80.10760592 | 2020-11-22 05:25:45 | Crawford, Pennsylvania, US |
3837424 | 3837424 | 2020-11-21 | US | Idaho | Payette | 16075 | 1467 | 13 | 0 | 1454 | 44.00545243 | -116.7647695 | 2020-11-22 05:25:45 | Payette, Idaho, US |
3341472 | 3341472 | 2020-11-17 | US | South Dakota | Meade | 46093 | 1465 | 11 | 0 | 1454 | 44.56676791 | -102.7162741 | 2020-11-18 05:40:31 | Meade, South Dakota, US |
3338897 | 3338897 | 2020-11-17 | Sweden | Blekinge | 1474 | 20 | 0 | 1454 | 56.2784 | 15.018 | 2020-11-18 05:40:31 | Blekinge, Sweden | ||
3172695 | 3172695 | 2020-11-16 | US | Texas | Deaf Smith | 48117 | 1614 | 35 | 0 | 1454 | 34.96522957 | -102.6054267 | 2020-11-17 05:25:54 | Deaf Smith, Texas, 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]);