johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
85 rows where active = 1855 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296398 | 3296398 | 2021-07-30 | Russia | Kursk Oblast | 46260 | 1086 | 43319 | 1855 | 51.6568453 | 36.4852695 | 2021-07-31 04:21:35 | Kursk Oblast, Russia | ||
1192388 | 1192388 | 2021-05-31 | Ukraine | Zhytomyr Oblast | 87643 | 1741 | 84047 | 1855 | 50.2547 | 28.6587 | 2021-06-01 04:23:09 | Zhytomyr Oblast, Ukraine | ||
2505648 | 2505648 | 2021-05-07 | Ukraine | Crimea Republic* | 41169 | 1247 | 38067 | 1855 | 45.2835 | 34.2008 | 2021-05-08 04:21:04 | Crimea Republic*, Ukraine | ||
3643667 | 3643667 | 2021-03-30 | Namibia | 44051 | 520 | 41676 | 1855 | -22.9576 | 18.4904 | 2021-03-31 04:26:25 | Namibia | |||
3962487 | 3962487 | 2021-03-10 | India | Telangana | 300536 | 1649 | 297032 | 1855 | 18.1124 | 79.0193 | 2021-03-11 05:25:48 | Telangana, India | ||
999259 | 999259 | 2021-03-01 | US | Georgia | Jones | 13169 | 1898 | 43 | 0 | 1855 | 33.02512137 | -83.56019163 | 2021-03-02 05:23:30 | Jones, Georgia, US |
3069578 | 3069578 | 2021-02-27 | US | Wisconsin | Vernon | 55123 | 1894 | 39 | 0 | 1855 | 43.59422667 | -90.8324691 | 2021-02-28 05:22:20 | Vernon, Wisconsin, US |
281142 | 281142 | 2021-02-24 | US | Illinois | Cass | 17017 | 1877 | 22 | 0 | 1855 | 39.96991073 | -90.24734436 | 2021-02-25 05:24:57 | Cass, Illinois, US |
532296 | 532296 | 2021-02-22 | US | Massachusetts | Franklin | 25011 | 1955 | 68 | 0 | 1855 | 42.58119713 | -72.58602547 | 2021-02-23 05:23:41 | Franklin, Massachusetts, US |
743151 | 743151 | 2021-02-20 | US | Georgia | Mitchell | 13205 | 1929 | 74 | 0 | 1855 | 31.22483255 | -84.19381821 | 2021-02-21 05:24:33 | Mitchell, Georgia, US |
473979 | 473979 | 2021-02-19 | US | Oklahoma | McIntosh | 40091 | 1887 | 32 | 0 | 1855 | 35.37235506 | -95.66599306 | 2021-02-20 05:22:51 | McIntosh, Oklahoma, US |
2680439 | 2680439 | 2021-02-13 | US | Oregon | Jefferson | 41031 | 1882 | 27 | 0 | 1855 | 44.62806839 | -121.17832 | 2021-02-14 05:23:43 | Jefferson, Oregon, US |
2638235 | 2638235 | 2021-02-11 | US | Arkansas | Randolph | 5121 | 1904 | 49 | 0 | 1855 | 36.3415714 | -91.02455531 | 2021-02-12 05:23:29 | Randolph, Arkansas, US |
3979284 | 3979284 | 2021-02-10 | US | Florida | Madison | 12079 | 1894 | 39 | 0 | 1855 | 30.44396917 | -83.47398594 | 2021-02-11 05:23:55 | Madison, Florida, US |
3978369 | 3978369 | 2021-02-10 | Chile | Maule | 38534 | 744 | 35935 | 1855 | -35.5183 | -71.6885 | 2021-02-11 05:23:55 | Maule, Chile | ||
977818 | 977818 | 2021-02-06 | US | South Dakota | Union | 46127 | 1894 | 39 | 0 | 1855 | 42.83112163 | -96.6557828 | 2021-02-07 05:23:00 | Union, South Dakota, US |
1591083 | 1591083 | 2021-02-05 | US | Tennessee | Bledsoe | 47007 | 1920 | 11 | 0 | 1855 | 35.59942968 | -85.20611967 | 2021-02-06 05:23:55 | Bledsoe, Tennessee, US |
1461347 | 1461347 | 2021-01-31 | US | Massachusetts | Dukes and Nantucket | 1857 | 3 | 0 | 1855 | 41.40674725 | -70.68763497 | 2021-02-01 05:22:53 | Dukes and Nantucket, Massachusetts, US | |
15880 | 15880 | 2021-01-26 | US | Wisconsin | Iowa | 55049 | 1865 | 10 | 0 | 1855 | 43.00050278 | -90.13469017 | 2021-01-27 05:23:41 | Iowa, Wisconsin, US |
2569770 | 2569770 | 2021-01-25 | US | Nebraska | Saline | 31151 | 1858 | 3 | 0 | 1855 | 40.52418865 | -97.14085859 | 2021-01-26 05:22:02 | Saline, Nebraska, US |
1762835 | 1762835 | 2021-01-24 | US | Wisconsin | Green Lake | 55047 | 1872 | 17 | 0 | 1855 | 43.80025981 | -89.04679553 | 2021-01-25 05:22:16 | Green Lake, Wisconsin, US |
2429009 | 2429009 | 2021-01-23 | US | Nebraska | Saline | 31151 | 1858 | 3 | 0 | 1855 | 40.52418865 | -97.14085859 | 2021-01-24 05:22:35 | Saline, Nebraska, US |
1097173 | 1097173 | 2021-01-20 | US | Texas | Gillespie | 48171 | 2080 | 33 | 0 | 1855 | 30.31824095 | -98.94676915 | 2021-01-21 05:22:01 | Gillespie, Texas, US |
1095931 | 1095931 | 2021-01-20 | US | Mississippi | Tishomingo | 28141 | 1916 | 61 | 0 | 1855 | 34.74023475 | -88.23917219 | 2021-01-21 05:22:01 | Tishomingo, Mississippi, US |
3504488 | 3504488 | 2021-01-17 | US | Indiana | Sullivan | 18153 | 1890 | 35 | 0 | 1855 | 39.08952258 | -87.41414469 | 2021-01-18 05:22:34 | Sullivan, Indiana, US |
3104686 | 3104686 | 2021-01-16 | US | Texas | Willacy | 48489 | 2176 | 69 | 0 | 1855 | 26.47411727 | -97.61535848 | 2021-01-17 05:22:17 | Willacy, Texas, US |
3518789 | 3518789 | 2021-01-15 | US | Virginia | Pulaski | 51155 | 1893 | 38 | 0 | 1855 | 37.06474963 | -80.71229738 | 2021-01-16 05:22:40 | Pulaski, Virginia, US |
3311777 | 3311777 | 2021-01-13 | US | Wisconsin | Taylor | 55119 | 1874 | 19 | 0 | 1855 | 45.21179252 | -90.5004405 | 2021-01-14 05:22:32 | Taylor, Wisconsin, US |
775197 | 775197 | 2021-01-12 | US | Georgia | Pierce | 13229 | 1890 | 35 | 0 | 1855 | 31.35928155 | -82.21598442 | 2021-01-13 05:22:15 | Pierce, Georgia, US |
3902001 | 3902001 | 2021-01-09 | US | Nebraska | Cass | 31025 | 1868 | 13 | 0 | 1855 | 40.90899107 | -96.13971217 | 2021-01-10 05:22:12 | Cass, Nebraska, US |
2865478 | 2865478 | 2021-01-06 | US | Georgia | Chattooga | 13055 | 1902 | 47 | 0 | 1855 | 34.47197698 | -85.34535662 | 2021-01-07 05:22:03 | Chattooga, Georgia, US |
3037411 | 3037411 | 2021-01-05 | US | Texas | Hockley | 48219 | 2887 | 80 | 0 | 1855 | 33.60771256 | -102.3431676 | 2021-01-06 05:22:16 | Hockley, Texas, US |
3035580 | 3035580 | 2021-01-05 | US | Kansas | Geary | 20061 | 1872 | 17 | 0 | 1855 | 38.99871131 | -96.7577178 | 2021-01-06 05:22:16 | Geary, Kansas, US |
3035097 | 3035097 | 2021-01-05 | US | Georgia | Franklin | 13119 | 1881 | 26 | 0 | 1855 | 34.37525597 | -83.23159927 | 2021-01-06 05:22:16 | Franklin, Georgia, US |
1063125 | 1063125 | 2021-01-04 | US | Kansas | Geary | 20061 | 1872 | 17 | 0 | 1855 | 38.99871131 | -96.7577178 | 2021-01-05 05:21:49 | Geary, Kansas, US |
2229250 | 2229250 | 2021-01-02 | US | Minnesota | Meeker | 27093 | 1887 | 32 | 0 | 1855 | 45.12328869 | -94.52839455 | 2021-01-03 05:22:52 | Meeker, Minnesota, US |
204904 | 204904 | 2020-12-25 | US | Pennsylvania | Clarion | 42031 | 1893 | 38 | 0 | 1855 | 41.19265812 | -79.42413524 | 2020-12-26 05:22:28 | Clarion, Pennsylvania, US |
2409856 | 2409856 | 2020-12-23 | US | Texas | Burnet | 48053 | 2155 | 24 | 0 | 1855 | 30.78801353 | -98.181887 | 2020-12-24 05:23:04 | Burnet, Texas, US |
930952 | 930952 | 2020-12-21 | US | Utah | Southeast Utah | 1867 | 12 | 0 | 1855 | 38.99617072 | -110.7013958 | 2020-12-22 05:22:33 | Southeast Utah, Utah, US | |
929187 | 929187 | 2020-12-21 | US | Louisiana | Franklin | 22041 | 1930 | 75 | 0 | 1855 | 32.13675181 | -91.67589857 | 2020-12-22 05:22:33 | Franklin, Louisiana, US |
3150982 | 3150982 | 2020-12-16 | US | Kentucky | Franklin | 21073 | 1872 | 17 | 0 | 1855 | 38.2379395 | -84.87962551 | 2020-12-17 05:28:12 | Franklin, Kentucky, US |
1037850 | 1037850 | 2020-12-15 | US | West Virginia | Jefferson | 54037 | 1874 | 19 | 0 | 1855 | 39.30776166 | -77.86014147 | 2020-12-16 05:28:04 | Jefferson, West Virginia, US |
1036263 | 1036263 | 2020-12-15 | US | Missouri | Dunklin | 29069 | 1869 | 14 | 0 | 1855 | 36.27167174 | -90.09122243 | 2020-12-16 05:28:04 | Dunklin, Missouri, US |
1752665 | 1752665 | 2020-12-14 | US | Kentucky | Greenup | 21089 | 1872 | 17 | 0 | 1855 | 38.54332505 | -82.9215658 | 2020-12-15 05:26:38 | Greenup, Kentucky, US |
860908 | 860908 | 2020-12-11 | Russia | Orel Oblast | 17810 | 221 | 15734 | 1855 | 52.96854329999999 | 36.0692477 | 2020-12-12 05:26:19 | Orel Oblast, Russia | ||
2978028 | 2978028 | 2020-12-09 | US | South Carolina | Chesterfield | 45025 | 1912 | 57 | 0 | 1855 | 34.64137396 | -80.15640140000002 | 2020-12-10 05:26:19 | Chesterfield, South Carolina, US |
741256 | 741256 | 2020-12-02 | US | Tennessee | Macon | 47111 | 1896 | 29 | 0 | 1855 | 36.53157855 | -86.00778595 | 2020-12-03 05:28:22 | Macon, Tennessee, US |
925520 | 925520 | 2020-11-26 | US | Mississippi | Sunflower | 28133 | 1910 | 55 | 0 | 1855 | 33.60192578 | -90.58882684 | 2020-11-27 05:26:53 | Sunflower, Mississippi, US |
1352891 | 1352891 | 2020-11-24 | US | Oklahoma | Osage | 40113 | 1873 | 18 | 0 | 1855 | 36.62888819 | -96.39635704 | 2020-11-25 05:27:20 | Osage, Oklahoma, US |
680630 | 680630 | 2020-11-23 | US | North Carolina | Hoke | 37093 | 1885 | 30 | 0 | 1855 | 35.01888303 | -79.23651674 | 2020-11-24 05:27:31 | Hoke, North Carolina, US |
3839508 | 3839508 | 2020-11-21 | US | Texas | Caldwell | 48055 | 1625 | 39 | 0 | 1855 | 29.83668859 | -97.61814775 | 2020-11-22 05:25:45 | Caldwell, Texas, US |
2883056 | 2883056 | 2020-11-15 | US | South Dakota | Davison | 46035 | 1870 | 15 | 0 | 1855 | 43.67490933 | -98.14458906 | 2020-11-16 05:25:57 | Davison, South Dakota, US |
274652 | 274652 | 2020-11-10 | US | Ohio | Ross | 39141 | 1918 | 63 | 0 | 1855 | 39.33705391 | -83.06000914 | 2020-11-11 05:25:30 | Ross, Ohio, US |
379092 | 379092 | 2020-11-06 | US | Tennessee | Carter | 47019 | 1930 | 37 | 0 | 1855 | 36.28969086 | -82.12588974 | 2020-11-07 05:24:52 | Carter, Tennessee, US |
754033 | 754033 | 2020-10-28 | Brazil | Acre | 30545 | 691 | 27999 | 1855 | -9.0238 | -70.812 | 2020-10-29 04:24:49 | Acre, Brazil | ||
3652296 | 3652296 | 2020-10-24 | US | Florida | Unassigned | 90012 | 1855 | 0 | 0 | 1855 | 30.86747479 | 0.0 | 2020-10-25 04:24:36 | Unassigned, Florida, US |
1056125 | 1056125 | 2020-10-23 | US | North Carolina | Edgecombe | 37065 | 1907 | 52 | 0 | 1855 | 35.91230639 | -77.59436892 | 2020-10-24 04:24:46 | Edgecombe, North Carolina, US |
1053594 | 1053594 | 2020-10-23 | Canada | Manitoba | 3935 | 48 | 2032 | 1855 | 53.7609 | -98.8139 | 2020-10-24 04:24:46 | Manitoba, Canada | ||
1796500 | 1796500 | 2020-10-19 | US | Missouri | Cass | 29037 | 1883 | 28 | 0 | 1855 | 38.64789422 | -94.353399 | 2020-10-20 04:24:22 | Cass, Missouri, US |
3782117 | 3782117 | 2020-10-13 | Russia | Kursk Oblast | 9021 | 60 | 7106 | 1855 | 51.6568453 | 36.4852695 | 2020-10-14 04:24:05 | Kursk Oblast, Russia | ||
3117916 | 3117916 | 2020-10-06 | US | Arizona | Cochise | 4003 | 1928 | 73 | 0 | 1855 | 31.87934684 | -109.7516088 | 2020-10-07 04:23:40 | Cochise, Arizona, US |
2515395 | 2515395 | 2020-10-03 | US | Iowa | Sioux | 19167 | 1859 | 4 | 0 | 1855 | 43.08221074 | -96.1767568 | 2020-10-04 04:23:44 | Sioux, Iowa, US |
2515023 | 2515023 | 2020-10-03 | US | Georgia | Rockdale | 13247 | 1892 | 37 | 0 | 1855 | 33.65145002 | -84.02202167 | 2020-10-04 04:23:44 | Rockdale, Georgia, US |
3390182 | 3390182 | 2020-10-02 | US | Georgia | Gordon | 13129 | 1894 | 39 | 0 | 1855 | 34.50487351 | -84.87296253 | 2020-10-03 04:23:40 | Gordon, Georgia, US |
2656578 | 2656578 | 2020-09-23 | US | South Carolina | Kershaw | 45055 | 1892 | 37 | 0 | 1855 | 34.33988254 | -80.58763164 | 2020-09-24 04:23:00 | Kershaw, South Carolina, US |
2837545 | 2837545 | 2020-09-21 | US | Florida | Walton | 12131 | 1877 | 22 | 0 | 1855 | 30.64204028 | -86.16935664 | 2020-09-22 04:23:00 | Walton, Florida, US |
668565 | 668565 | 2020-09-16 | US | North Carolina | Cleveland | 37045 | 1909 | 54 | 0 | 1855 | 35.33553364 | -81.55204486 | 2020-09-17 04:22:00 | Cleveland, North Carolina, US |
668081 | 668081 | 2020-09-16 | US | Mississippi | Lauderdale | 28075 | 1977 | 122 | 0 | 1855 | 32.40419769 | -88.66229662 | 2020-09-17 04:22:00 | Lauderdale, Mississippi, US |
427551 | 427551 | 2020-09-07 | Russia | Leningrad Oblast | 7049 | 83 | 5111 | 1855 | 60.1853296 | 32.3925325 | 2020-09-08 04:28:25 | Leningrad Oblast, Russia | ||
427403 | 427403 | 2020-09-07 | Malawi | 5621 | 176 | 3590 | 1855 | -13.2543 | 34.3015 | 2020-09-08 04:28:25 | Malawi | |||
816267 | 816267 | 2020-09-05 | US | Pennsylvania | Westmoreland | 42129 | 1904 | 49 | 0 | 1855 | 40.31377979999999 | -79.46615476 | 2020-09-06 04:28:33 | Westmoreland, Pennsylvania, US |
813829 | 813829 | 2020-09-05 | Russia | Ulyanovsk Oblast | 12550 | 111 | 10584 | 1855 | 54.1463177 | 47.2324921 | 2020-09-06 04:28:33 | Ulyanovsk Oblast, Russia | ||
145940 | 145940 | 2020-08-15 | India | Tripura | 7061 | 55 | 5151 | 1855 | 23.746783 | 91.743565 | 2020-08-16 04:27:42 | Tripura, India | ||
3534259 | 3534259 | 2020-08-12 | US | South Carolina | Pickens | 45077 | 1882 | 27 | 0 | 1855 | 34.88807695 | -82.72791551 | 2020-08-13 04:29:15 | Pickens, South Carolina, US |
3531753 | 3531753 | 2020-08-12 | Sweden | Dalarna | 2029 | 174 | 0 | 1855 | 61.0917 | 14.6664 | 2020-08-13 04:29:15 | Dalarna, Sweden | ||
370420 | 370420 | 2020-08-08 | US | Michigan | Saginaw | 26145 | 1986 | 131 | 0 | 1855 | 43.33433923 | -84.05131209999998 | 2020-08-09 04:34:54 | Saginaw, Michigan, US |
753902 | 753902 | 2020-08-01 | Montenegro | 3198 | 50 | 1293 | 1855 | 42.708678000000006 | 19.37439 | 2020-08-02 04:34:47 | Montenegro | |||
1925628 | 1925628 | 2020-07-30 | US | Nebraska | Dakota | 31043 | 1896 | 41 | 0 | 1855 | 42.39040144 | -96.56656425 | 2020-07-31 04:35:18 | Dakota, Nebraska, US |
2974710 | 2974710 | 2020-06-30 | Ukraine | Zakarpattia Oblast | 2889 | 91 | 943 | 1855 | 48.6208 | 22.2879 | 2020-07-01 04:33:52 | Zakarpattia Oblast, Ukraine | ||
1195833 | 1195833 | 2020-06-17 | Russia | Karachay-Cherkess Republic | 2446 | 9 | 582 | 1855 | 43.7368326 | 41.7267991 | 2020-06-18 04:33:18 | Karachay-Cherkess Republic, Russia | ||
2384228 | 2384228 | 2020-06-16 | US | Kansas | Ford | 20057 | 1863 | 8 | 0 | 1855 | 37.69200114 | -99.88825298 | 2020-06-17 04:33:21 | Ford, Kansas, US |
284790 | 284790 | 2020-06-15 | US | Kansas | Ford | 20057 | 1863 | 8 | 0 | 1855 | 37.69200114 | -99.88825298 | 2020-06-16 04:33:09 | Ford, Kansas, US |
2554107 | 2554107 | 2020-06-02 | US | Florida | Lee | 12071 | 1967 | 112 | 0 | 1855 | 26.58410348 | -81.88399313 | 2020-06-03 02:33:13 | Lee, Florida, US |
874629 | 874629 | 2020-05-24 | US | Arizona | Pima | 4019 | 2027 | 172 | 0 | 1855 | 32.0971334 | -111.7890033 | 2020-05-25 02:32:44 | Pima, Arizona, US |
266530 | 266530 | 2020-05-21 | US | Kentucky | Jefferson | 21111 | 1994 | 139 | 0 | 1855 | 38.18664655 | -85.65931031 | 2020-05-22 02:36:51 | Jefferson, Kentucky, 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]);