johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
802 rows where deaths = 420 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756311 | 2756311 | 2022-12-29 | US | Virginia | Roanoke City | 51770 | 27157 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-30 04:21:04 | Roanoke City, Virginia, US | |
2756012 | 2756012 | 2022-12-29 | US | Texas | Guadalupe | 48187 | 44759 | 420 | 0 | 29.58165339 | -97.94786822 | 2022-12-30 04:21:04 | Guadalupe, Texas, US | |
2755445 | 2755445 | 2022-12-29 | US | Oklahoma | Canadian | 40017 | 47106 | 420 | 0 | 35.5426055 | -97.98465569 | 2022-12-30 04:21:04 | Canadian, Oklahoma, US | |
1077317 | 1077317 | 2022-12-28 | US | Virginia | Roanoke City | 51770 | 27157 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-29 04:21:01 | Roanoke City, Virginia, US | |
1077018 | 1077018 | 2022-12-28 | US | Texas | Guadalupe | 48187 | 44759 | 420 | 0 | 29.58165339 | -97.94786822 | 2022-12-29 04:21:01 | Guadalupe, Texas, US | |
331314 | 331314 | 2022-12-27 | US | Virginia | Roanoke City | 51770 | 27115 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-28 04:21:04 | Roanoke City, Virginia, US | |
221387 | 221387 | 2022-12-26 | US | Virginia | Roanoke City | 51770 | 27110 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-27 04:21:07 | Roanoke City, Virginia, US | |
3225844 | 3225844 | 2022-12-25 | US | Virginia | Roanoke City | 51770 | 27067 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-26 04:21:06 | Roanoke City, Virginia, US | |
1021758 | 1021758 | 2022-12-24 | US | Virginia | Roanoke City | 51770 | 27067 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-25 04:21:04 | Roanoke City, Virginia, US | |
693781 | 693781 | 2022-12-23 | US | Virginia | Roanoke City | 51770 | 27067 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-24 04:21:02 | Roanoke City, Virginia, US | |
2182991 | 2182991 | 2022-12-22 | US | Virginia | Roanoke City | 51770 | 27015 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-23 04:21:04 | Roanoke City, Virginia, US | |
454795 | 454795 | 2022-12-21 | US | Virginia | Roanoke City | 51770 | 26996 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-22 04:20:56 | Roanoke City, Virginia, US | |
2954794 | 2954794 | 2022-12-20 | US | Virginia | Roanoke City | 51770 | 26957 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-21 04:21:03 | Roanoke City, Virginia, US | |
3176635 | 3176635 | 2022-12-19 | US | South Carolina | Sumter | 45085 | 33624 | 420 | 0 | 33.91826534 | -80.37942316 | 2022-12-20 04:21:04 | Sumter, South Carolina, US | |
1631152 | 1631152 | 2022-12-18 | US | South Carolina | Sumter | 45085 | 33624 | 420 | 0 | 33.91826534 | -80.37942316 | 2022-12-19 04:21:03 | Sumter, South Carolina, US | |
506531 | 506531 | 2022-12-17 | US | South Carolina | Sumter | 45085 | 33624 | 420 | 0 | 33.91826534 | -80.37942316 | 2022-12-18 04:21:03 | Sumter, South Carolina, US | |
3327103 | 3327103 | 2022-12-16 | US | South Carolina | Sumter | 45085 | 33624 | 420 | 0 | 33.91826534 | -80.37942316 | 2022-12-17 04:21:04 | Sumter, South Carolina, US | |
545615 | 545615 | 2022-12-15 | US | South Carolina | Sumter | 45085 | 33624 | 420 | 0 | 33.91826534 | -80.37942316 | 2022-12-16 04:21:01 | Sumter, South Carolina, US | |
351143 | 351143 | 2022-12-14 | US | South Carolina | Sumter | 45085 | 33624 | 420 | 0 | 33.91826534 | -80.37942316 | 2022-12-15 04:20:58 | Sumter, South Carolina, US | |
310731 | 310731 | 2022-12-13 | US | South Carolina | Sumter | 45085 | 33624 | 420 | 0 | 33.91826534 | -80.37942316 | 2022-12-14 04:21:04 | Sumter, South Carolina, US | |
308493 | 308493 | 2022-12-13 | US | Colorado | Boulder | 8013 | 88813 | 420 | 0 | 40.09313619 | -105.3546767 | 2022-12-14 04:21:04 | Boulder, Colorado, US | |
1149554 | 1149554 | 2022-12-12 | US | Colorado | Boulder | 8013 | 88756 | 420 | 0 | 40.09313619 | -105.3546767 | 2022-12-13 04:21:01 | Boulder, Colorado, US | |
257343 | 257343 | 2022-12-10 | Japan | Oita | 209526 | 420 | 0 | 33.200697 | 131.43324 | 2022-12-11 04:20:50 | Oita, Japan | |||
3936057 | 3936057 | 2022-12-09 | Japan | Oita | 208313 | 420 | 0 | 33.200697 | 131.43324 | 2022-12-10 04:21:02 | Oita, Japan | |||
1985433 | 1985433 | 2022-12-07 | US | Georgia | Columbia | 13073 | 41701 | 420 | 0 | 33.54534185 | -82.263524 | 2022-12-08 04:21:07 | Columbia, Georgia, US | |
3714956 | 3714956 | 2022-12-06 | US | Georgia | Columbia | 13073 | 41701 | 420 | 0 | 33.54534185 | -82.263524 | 2022-12-07 04:20:58 | Columbia, Georgia, US | |
2418282 | 2418282 | 2022-12-05 | US | Virginia | Roanoke City | 51770 | 26664 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-06 04:21:03 | Roanoke City, Virginia, US | |
2415661 | 2415661 | 2022-12-05 | US | Georgia | Columbia | 13073 | 41701 | 420 | 0 | 33.54534185 | -82.263524 | 2022-12-06 04:21:03 | Columbia, Georgia, US | |
721890 | 721890 | 2022-12-04 | US | Virginia | Roanoke City | 51770 | 26630 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-05 04:20:58 | Roanoke City, Virginia, US | |
719269 | 719269 | 2022-12-04 | US | Georgia | Columbia | 13073 | 41701 | 420 | 0 | 33.54534185 | -82.263524 | 2022-12-05 04:20:58 | Columbia, Georgia, US | |
2820179 | 2820179 | 2022-12-03 | US | Virginia | Roanoke City | 51770 | 26630 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-04 04:20:56 | Roanoke City, Virginia, US | |
2817558 | 2817558 | 2022-12-03 | US | Georgia | Columbia | 13073 | 41701 | 420 | 0 | 33.54534185 | -82.263524 | 2022-12-04 04:20:56 | Columbia, Georgia, US | |
837035 | 837035 | 2022-12-02 | US | Virginia | Roanoke City | 51770 | 26630 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-03 04:21:02 | Roanoke City, Virginia, US | |
834414 | 834414 | 2022-12-02 | US | Georgia | Columbia | 13073 | 41701 | 420 | 0 | 33.54534185 | -82.263524 | 2022-12-03 04:21:02 | Columbia, Georgia, US | |
2136944 | 2136944 | 2022-12-01 | US | Georgia | Columbia | 13073 | 41701 | 420 | 0 | 33.54534185 | -82.263524 | 2022-12-02 04:21:07 | Columbia, Georgia, US | |
1965360 | 1965360 | 2022-11-30 | US | Georgia | Columbia | 13073 | 41701 | 420 | 0 | 33.54534185 | -82.263524 | 2022-12-01 04:21:03 | Columbia, Georgia, US | |
1964904 | 1964904 | 2022-11-30 | Sweden | Varmland | 69842 | 420 | 0 | 59.7294 | 13.2354 | 2022-12-01 04:21:03 | Varmland, Sweden | |||
2556918 | 2556918 | 2022-11-29 | Sweden | Varmland | 69842 | 420 | 0 | 59.7294 | 13.2354 | 2022-11-30 04:21:07 | Varmland, Sweden | |||
1243141 | 1243141 | 2022-11-28 | US | West Virginia | Cabell | 54011 | 32860 | 420 | 0 | 38.42424062 | -82.23855912 | 2022-11-29 04:21:05 | Cabell, West Virginia, US | |
1239992 | 1239992 | 2022-11-28 | Sweden | Varmland | 69842 | 420 | 0 | 59.7294 | 13.2354 | 2022-11-29 04:21:05 | Varmland, Sweden | |||
3555129 | 3555129 | 2022-11-27 | US | West Virginia | Cabell | 54011 | 32836 | 420 | 0 | 38.42424062 | -82.23855912 | 2022-11-28 04:21:02 | Cabell, West Virginia, US | |
3551980 | 3551980 | 2022-11-27 | Sweden | Varmland | 69842 | 420 | 0 | 59.7294 | 13.2354 | 2022-11-28 04:21:02 | Varmland, Sweden | |||
2103609 | 2103609 | 2022-11-26 | US | West Virginia | Cabell | 54011 | 32836 | 420 | 0 | 38.42424062 | -82.23855912 | 2022-11-27 04:21:05 | Cabell, West Virginia, US | |
2100460 | 2100460 | 2022-11-26 | Sweden | Varmland | 69842 | 420 | 0 | 59.7294 | 13.2354 | 2022-11-27 04:21:05 | Varmland, Sweden | |||
491100 | 491100 | 2022-11-25 | US | West Virginia | Cabell | 54011 | 32836 | 420 | 0 | 38.42424062 | -82.23855912 | 2022-11-26 04:21:11 | Cabell, West Virginia, US | |
487951 | 487951 | 2022-11-25 | Sweden | Varmland | 69842 | 420 | 0 | 59.7294 | 13.2354 | 2022-11-26 04:21:11 | Varmland, Sweden | |||
3526929 | 3526929 | 2022-11-24 | US | West Virginia | Cabell | 54011 | 32836 | 420 | 0 | 38.42424062 | -82.23855912 | 2022-11-25 04:21:06 | Cabell, West Virginia, US | |
3523780 | 3523780 | 2022-11-24 | Sweden | Varmland | 69842 | 420 | 0 | 59.7294 | 13.2354 | 2022-11-25 04:21:06 | Varmland, Sweden | |||
3315712 | 3315712 | 2022-11-23 | US | West Virginia | Cabell | 54011 | 32836 | 420 | 0 | 38.42424062 | -82.23855912 | 2022-11-24 04:21:09 | Cabell, West Virginia, US | |
1622642 | 1622642 | 2022-11-22 | US | North Carolina | Rutherford | 37161 | 20458 | 420 | 0 | 35.40114178 | -81.92112099 | 2022-11-23 04:21:06 | Rutherford, North Carolina, US | |
3462530 | 3462530 | 2022-11-21 | US | North Carolina | Rutherford | 37161 | 20458 | 420 | 0 | 35.40114178 | -81.92112099 | 2022-11-22 04:20:47 | Rutherford, North Carolina, US | |
3461749 | 3461749 | 2022-11-21 | US | Maryland | Howard | 24027 | 59771 | 420 | 0 | 39.25305293 | -76.93126208 | 2022-11-22 04:20:47 | Howard, Maryland, US | |
1642715 | 1642715 | 2022-11-20 | US | North Carolina | Rutherford | 37161 | 20458 | 420 | 0 | 35.40114178 | -81.92112099 | 2022-11-21 04:21:05 | Rutherford, North Carolina, US | |
1641934 | 1641934 | 2022-11-20 | US | Maryland | Howard | 24027 | 59732 | 420 | 0 | 39.25305293 | -76.93126208 | 2022-11-21 04:21:05 | Howard, Maryland, US | |
2066272 | 2066272 | 2022-11-19 | US | North Carolina | Rutherford | 37161 | 20458 | 420 | 0 | 35.40114178 | -81.92112099 | 2022-11-20 04:21:08 | Rutherford, North Carolina, US | |
2065491 | 2065491 | 2022-11-19 | US | Maryland | Howard | 24027 | 59732 | 420 | 0 | 39.25305293 | -76.93126208 | 2022-11-20 04:21:08 | Howard, Maryland, US | |
1757666 | 1757666 | 2022-11-18 | US | North Carolina | Rutherford | 37161 | 20458 | 420 | 0 | 35.40114178 | -81.92112099 | 2022-11-19 04:21:14 | Rutherford, North Carolina, US | |
1756885 | 1756885 | 2022-11-18 | US | Maryland | Howard | 24027 | 59732 | 420 | 0 | 39.25305293 | -76.93126208 | 2022-11-19 04:21:14 | Howard, Maryland, US | |
3028659 | 3028659 | 2022-11-17 | US | North Carolina | Rutherford | 37161 | 20458 | 420 | 0 | 35.40114178 | -81.92112099 | 2022-11-18 04:21:15 | Rutherford, North Carolina, US | |
3027878 | 3027878 | 2022-11-17 | US | Maryland | Howard | 24027 | 59683 | 420 | 0 | 39.25305293 | -76.93126208 | 2022-11-18 04:21:15 | Howard, Maryland, US | |
2488370 | 2488370 | 2022-11-16 | US | North Carolina | Rutherford | 37161 | 20458 | 420 | 0 | 35.40114178 | -81.92112099 | 2022-11-17 04:21:11 | Rutherford, North Carolina, US | |
2487589 | 2487589 | 2022-11-16 | US | Maryland | Howard | 24027 | 59658 | 420 | 0 | 39.25305293 | -76.93126208 | 2022-11-17 04:21:11 | Howard, Maryland, US | |
313299 | 313299 | 2022-11-13 | US | Kentucky | Daviess | 21059 | 36804 | 420 | 0 | 37.73028906 | -87.0901948 | 2022-11-14 04:21:09 | Daviess, Kentucky, US | |
64460 | 64460 | 2022-11-12 | US | Kentucky | Daviess | 21059 | 36804 | 420 | 0 | 37.73028906 | -87.0901948 | 2022-11-13 04:21:14 | Daviess, Kentucky, US | |
2928622 | 2928622 | 2022-11-11 | US | Kentucky | Daviess | 21059 | 36804 | 420 | 0 | 37.73028906 | -87.0901948 | 2022-11-12 04:20:41 | Daviess, Kentucky, US | |
2507458 | 2507458 | 2022-11-10 | US | Kentucky | Daviess | 21059 | 36804 | 420 | 0 | 37.73028906 | -87.0901948 | 2022-11-11 04:21:22 | Daviess, Kentucky, US | |
2432333 | 2432333 | 2022-11-09 | US | Kentucky | Daviess | 21059 | 36804 | 420 | 0 | 37.73028906 | -87.0901948 | 2022-11-10 04:21:16 | Daviess, Kentucky, US | |
480989 | 480989 | 2022-11-08 | US | Kentucky | Daviess | 21059 | 36804 | 420 | 0 | 37.73028906 | -87.0901948 | 2022-11-09 04:21:22 | Daviess, Kentucky, US | |
2440139 | 2440139 | 2022-11-07 | US | Kentucky | Daviess | 21059 | 36804 | 420 | 0 | 37.73028906 | -87.0901948 | 2022-11-08 04:21:21 | Daviess, Kentucky, US | |
542123 | 542123 | 2022-10-26 | US | Virginia | Loudoun | 51107 | 89859 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-27 04:22:01 | Loudoun, Virginia, US | |
538767 | 538767 | 2022-10-26 | Japan | Okayama | 290161 | 420 | 0 | 34.89246 | 133.826252 | 2022-10-27 04:22:01 | Okayama, Japan | |||
1833524 | 1833524 | 2022-10-25 | US | Virginia | Loudoun | 51107 | 89819 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-26 04:22:19 | Loudoun, Virginia, US | |
797785 | 797785 | 2022-10-24 | US | Virginia | Loudoun | 51107 | 89771 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-25 04:21:53 | Loudoun, Virginia, US | |
3280240 | 3280240 | 2022-10-23 | US | Virginia | Loudoun | 51107 | 89681 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-24 04:22:29 | Loudoun, Virginia, US | |
2271278 | 2271278 | 2022-10-22 | US | Virginia | Loudoun | 51107 | 89681 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-23 04:22:46 | Loudoun, Virginia, US | |
1595578 | 1595578 | 2022-10-21 | US | Virginia | Loudoun | 51107 | 89681 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-22 04:22:53 | Loudoun, Virginia, US | |
2275294 | 2275294 | 2022-10-20 | US | Virginia | Loudoun | 51107 | 89650 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-21 04:22:23 | Loudoun, Virginia, US | |
201629 | 201629 | 2022-10-19 | US | Virginia | Loudoun | 51107 | 89592 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-20 04:22:59 | Loudoun, Virginia, US | |
2760290 | 2760290 | 2022-10-18 | US | Virginia | Loudoun | 51107 | 89534 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-19 04:22:26 | Loudoun, Virginia, US | |
2028124 | 2028124 | 2022-10-17 | US | Virginia | Loudoun | 51107 | 89491 | 420 | 0 | 39.08990083 | -77.63481877 | 2022-10-18 04:22:42 | Loudoun, Virginia, US | |
3250961 | 3250961 | 2022-10-11 | US | Georgia | Glynn | 13127 | 26226 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-12 04:22:51 | Glynn, Georgia, US | |
2968220 | 2968220 | 2022-10-10 | US | Georgia | Glynn | 13127 | 26226 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-11 04:23:05 | Glynn, Georgia, US | |
3100693 | 3100693 | 2022-10-09 | US | Texas | Victoria | 48469 | 21912 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-10 04:22:32 | Victoria, Texas, US | |
3098256 | 3098256 | 2022-10-09 | US | Georgia | Glynn | 13127 | 26226 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-10 04:22:32 | Glynn, Georgia, US | |
4005918 | 4005918 | 2022-10-08 | US | Texas | Victoria | 48469 | 21912 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-09 04:21:16 | Victoria, Texas, US | |
4003481 | 4003481 | 2022-10-08 | US | Georgia | Glynn | 13127 | 26226 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-09 04:21:16 | Glynn, Georgia, US | |
399515 | 399515 | 2022-10-07 | US | Texas | Victoria | 48469 | 21912 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-08 04:22:56 | Victoria, Texas, US | |
397078 | 397078 | 2022-10-07 | US | Georgia | Glynn | 13127 | 26226 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-08 04:22:56 | Glynn, Georgia, US | |
2532632 | 2532632 | 2022-10-06 | US | Texas | Victoria | 48469 | 21908 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-07 04:23:08 | Victoria, Texas, US | |
2530195 | 2530195 | 2022-10-06 | US | Georgia | Glynn | 13127 | 26226 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-07 04:23:08 | Glynn, Georgia, US | |
1814026 | 1814026 | 2022-10-05 | US | Texas | Victoria | 48469 | 21908 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-06 04:21:22 | Victoria, Texas, US | |
1812334 | 1812334 | 2022-10-05 | US | Maine | Cumberland | 23005 | 60929 | 420 | 0 | 43.8370751 | -70.37226999 | 2022-10-06 04:21:22 | Cumberland, Maine, US | |
1811589 | 1811589 | 2022-10-05 | US | Georgia | Glynn | 13127 | 26226 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-06 04:21:22 | Glynn, Georgia, US | |
134000 | 134000 | 2022-10-04 | US | Texas | Victoria | 48469 | 21905 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-05 04:23:06 | Victoria, Texas, US | |
131563 | 131563 | 2022-10-04 | US | Georgia | Glynn | 13127 | 26212 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-05 04:23:06 | Glynn, Georgia, US | |
2688947 | 2688947 | 2022-10-03 | US | Texas | Victoria | 48469 | 21905 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-04 04:22:55 | Victoria, Texas, US | |
2686510 | 2686510 | 2022-10-03 | US | Georgia | Glynn | 13127 | 26212 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-04 04:22:55 | Glynn, Georgia, US | |
2263014 | 2263014 | 2022-10-02 | US | Texas | Victoria | 48469 | 21890 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-03 04:23:11 | Victoria, Texas, US | |
2260577 | 2260577 | 2022-10-02 | US | Georgia | Glynn | 13127 | 26212 | 420 | 0 | 31.23279254 | -81.53811412 | 2022-10-03 04:23:11 | Glynn, Georgia, US | |
2998540 | 2998540 | 2022-10-01 | US | Texas | Victoria | 48469 | 21890 | 420 | 0 | 28.79780988 | -96.96813006 | 2022-10-02 04:21:23 | Victoria, 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]);