johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1566790 | 1566790 | 2021-06-14 | US | Pennsylvania | Union | 42119 | 6176 | 89 | 0 | 40.96188846 | -77.05996014 | 2021-06-15 04:22:22 | Union, Pennsylvania, US | |
1581261 | 1581261 | 2021-03-13 | US | Indiana | Morgan | 18109 | 6176 | 130 | 0 | 39.47899078 | -86.44573375 | 2021-03-14 05:25:37 | Morgan, Indiana, US | |
1590533 | 1590533 | 2021-02-05 | US | North Carolina | Stanly | 37167 | 6176 | 100 | 0 | 6076 | 35.31647813 | -80.25093221 | 2021-02-06 05:23:55 | Stanly, North Carolina, US |
1595831 | 1595831 | 2022-10-21 | US | Wyoming | Uinta | 56041 | 6176 | 43 | 0 | 41.2878183 | -110.5475782 | 2022-10-22 04:22:53 | Uinta, Wyoming, US | |
1599214 | 1599214 | 2021-08-26 | US | Texas | Anderson | 48001 | 6176 | 136 | 0 | 31.81534745 | -95.65354823 | 2021-08-27 04:21:37 | Anderson, Texas, US | |
1611176 | 1611176 | 2022-07-20 | US | South Dakota | Yankton | 46135 | 6176 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-07-21 04:21:10 | Yankton, South Dakota, US | |
1619173 | 1619173 | 2021-03-05 | US | Tennessee | Gibson | 47053 | 6176 | 141 | 0 | 6056 | 35.99438059 | -88.93358327 | 2021-03-06 04:23:41 | Gibson, Tennessee, US |
1621365 | 1621365 | 2022-11-22 | US | Indiana | Fountain | 18045 | 6176 | 108 | 0 | 40.12361933 | -87.24217689 | 2022-11-23 04:21:06 | Fountain, Indiana, US | |
1626594 | 1626594 | 2022-09-22 | US | North Carolina | Caswell | 37033 | 6176 | 55 | 0 | 36.39312665 | -79.33353281 | 2022-09-23 04:23:13 | Caswell, North Carolina, US | |
1636928 | 1636928 | 2021-04-29 | US | Colorado | Fremont | 8043 | 6176 | 57 | 0 | 38.47362326 | -105.4399667 | 2021-04-30 04:21:03 | Fremont, Colorado, US | |
1641438 | 1641438 | 2022-11-20 | US | Indiana | Fountain | 18045 | 6176 | 108 | 0 | 40.12361933 | -87.24217689 | 2022-11-21 04:21:05 | Fountain, Indiana, US | |
1650335 | 1650335 | 2022-06-23 | US | Missouri | Randolph | 29175 | 6176 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-06-24 04:20:58 | Randolph, Missouri, US | |
1657458 | 1657458 | 2022-03-19 | US | Illinois | Shelby | 17173 | 6176 | 73 | 0 | 39.39133527 | -88.80611122 | 2022-03-20 04:20:45 | Shelby, Illinois, US | |
1708794 | 1708794 | 2021-06-02 | US | Arkansas | Greene | 5055 | 6176 | 77 | 0 | 36.11735460000001 | -90.55832668 | 2021-06-03 04:23:32 | Greene, Arkansas, US | |
1709866 | 1709866 | 2021-06-02 | US | Maine | Penobscot | 23019 | 6176 | 93 | 0 | 45.40194593 | -68.65020455 | 2021-06-03 04:23:32 | Penobscot, Maine, US | |
1726735 | 1726735 | 2021-09-25 | US | New York | Genesee | 36037 | 6176 | 131 | 0 | 43.0022601 | -78.19135193 | 2021-09-26 04:21:29 | Genesee, New York, US | |
1743957 | 1743957 | 2021-12-05 | US | Virginia | Tazewell | 51185 | 6176 | 119 | 0 | 37.12191123 | -81.56685568 | 2021-12-06 04:22:34 | Tazewell, Virginia, US | |
1756389 | 1756389 | 2022-11-18 | US | Indiana | Fountain | 18045 | 6176 | 108 | 0 | 40.12361933 | -87.24217689 | 2022-11-19 04:21:14 | Fountain, Indiana, US | |
1765284 | 1765284 | 2022-06-20 | US | Missouri | Randolph | 29175 | 6176 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-06-21 04:20:56 | Randolph, Missouri, US | |
1800056 | 1800056 | 2021-03-23 | US | Kentucky | Laurel | 21125 | 6176 | 47 | 0 | 37.10975748 | -84.11321779 | 2021-03-24 05:25:40 | Laurel, Kentucky, US | |
1807852 | 1807852 | 2021-05-27 | US | Indiana | Marshall | 18099 | 6176 | 114 | 0 | 41.32467367 | -86.26185087 | 2021-05-28 04:20:36 | Marshall, Indiana, US | |
1895789 | 1895789 | 2021-06-30 | US | Pennsylvania | Bradford | 42015 | 6176 | 96 | 0 | 41.78869215 | -76.51570822 | 2021-07-01 04:21:19 | Bradford, Pennsylvania, US | |
1935085 | 1935085 | 2021-07-05 | US | Pennsylvania | Bradford | 42015 | 6176 | 96 | 0 | 41.78869215 | -76.51570822 | 2021-07-06 04:21:32 | Bradford, Pennsylvania, US | |
1978921 | 1978921 | 2022-09-25 | US | North Carolina | Caswell | 37033 | 6176 | 55 | 0 | 36.39312665 | -79.33353281 | 2022-09-26 04:20:52 | Caswell, North Carolina, US | |
1981666 | 1981666 | 2021-03-25 | US | Illinois | Whiteside | 17195 | 6176 | 155 | 0 | 41.75509713 | -89.91556058 | 2021-03-26 05:26:55 | Whiteside, Illinois, US | |
2026370 | 2026370 | 2022-10-17 | US | Michigan | Alpena | 26007 | 6176 | 150 | 0 | 45.03477666 | -83.62212411 | 2022-10-18 04:22:42 | Alpena, Michigan, US | |
2034402 | 2034402 | 2022-10-14 | US | Michigan | Alpena | 26007 | 6176 | 150 | 0 | 45.03477666 | -83.62212411 | 2022-10-15 04:22:00 | Alpena, Michigan, US | |
2055269 | 2055269 | 2022-01-25 | US | Virginia | Orange | 51137 | 6176 | 71 | 0 | 38.24530219 | -78.01560400000002 | 2022-01-26 04:21:07 | Orange, Virginia, US | |
2060124 | 2060124 | 2020-09-01 | Russia | Smolensk Oblast | 6176 | 128 | 5300 | 748 | 55.03434960000001 | 33.0192065 | 2020-09-02 04:28:25 | Smolensk Oblast, Russia | ||
2064995 | 2064995 | 2022-11-19 | US | Indiana | Fountain | 18045 | 6176 | 108 | 0 | 40.12361933 | -87.24217689 | 2022-11-20 04:21:08 | Fountain, Indiana, US | |
2074565 | 2074565 | 2021-07-02 | US | Pennsylvania | Bradford | 42015 | 6176 | 96 | 0 | 41.78869215 | -76.51570822 | 2021-07-03 04:21:37 | Bradford, Pennsylvania, US | |
2118817 | 2118817 | 2022-04-08 | US | Texas | Gray | 48179 | 6176 | 124 | 0 | 35.40081878 | -100.8129222 | 2022-04-09 04:20:42 | Gray, Texas, US | |
2161148 | 2161148 | 2022-10-16 | US | Michigan | Alpena | 26007 | 6176 | 150 | 0 | 45.03477666 | -83.62212411 | 2022-10-17 04:20:31 | Alpena, Michigan, US | |
2189570 | 2189570 | 2022-06-22 | US | Missouri | Randolph | 29175 | 6176 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-06-23 04:20:55 | Randolph, Missouri, US | |
2197536 | 2197536 | 2021-12-03 | US | Missouri | Howell | 29091 | 6176 | 168 | 0 | 36.77383887 | -91.88683935 | 2021-12-04 04:22:18 | Howell, Missouri, US | |
2199042 | 2199042 | 2021-12-03 | US | Virginia | Tazewell | 51185 | 6176 | 119 | 0 | 37.12191123 | -81.56685568 | 2021-12-04 04:22:18 | Tazewell, Virginia, US | |
2227968 | 2227968 | 2021-01-02 | US | Arizona | Santa Cruz | 4023 | 6176 | 101 | 0 | 6075 | 31.52508998 | -110.8479088 | 2021-01-03 05:22:52 | Santa Cruz, Arizona, US |
2271531 | 2271531 | 2022-10-22 | US | Wyoming | Uinta | 56041 | 6176 | 43 | 0 | 41.2878183 | -110.5475782 | 2022-10-23 04:22:46 | Uinta, Wyoming, US | |
2275547 | 2275547 | 2022-10-20 | US | Wyoming | Uinta | 56041 | 6176 | 43 | 0 | 41.2878183 | -110.5475782 | 2022-10-21 04:22:23 | Uinta, Wyoming, US | |
2277238 | 2277238 | 2020-05-03 | US | Indiana | Marion | 18097 | 6176 | 395 | 0 | 5781 | 39.78163624 | -86.13826325 | 2020-05-04 02:32:28 | Marion, Indiana, US |
2313259 | 2313259 | 2022-06-17 | US | Missouri | Randolph | 29175 | 6176 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-06-18 04:21:10 | Randolph, Missouri, US | |
2320380 | 2320380 | 2022-03-16 | US | Illinois | Shelby | 17173 | 6176 | 73 | 0 | 39.39133527 | -88.80611122 | 2022-03-17 04:20:56 | Shelby, Illinois, US | |
2324458 | 2324458 | 2022-08-24 | US | Indiana | LaGrange | 18087 | 6176 | 104 | 0 | 41.64232188 | -85.42674232 | 2022-08-25 04:21:13 | LaGrange, Indiana, US | |
2342094 | 2342094 | 2021-06-15 | US | Pennsylvania | Union | 42119 | 6176 | 89 | 0 | 40.96188846 | -77.05996014 | 2021-06-16 04:22:32 | Union, Pennsylvania, US | |
2407507 | 2407507 | 2020-12-23 | US | Florida | Citrus | 12017 | 6176 | 239 | 0 | 5937 | 28.84804315 | -82.47614748 | 2020-12-24 05:23:04 | Citrus, Florida, US |
2421817 | 2421817 | 2022-07-15 | US | Tennessee | Chester | 47023 | 6176 | 99 | 0 | 35.42527478 | -88.6095842 | 2022-07-16 04:21:05 | Chester, Tennessee, US | |
2423506 | 2423506 | 2021-06-23 | US | Colorado | Garfield | 8045 | 6176 | 50 | 0 | 39.59921777 | -107.902708 | 2021-06-24 04:21:55 | Garfield, Colorado, US | |
2445708 | 2445708 | 2022-04-13 | US | Tennessee | Haywood | 47075 | 6176 | 102 | 0 | 35.58332824 | -89.28536625 | 2022-04-13 23:21:06 | Haywood, Tennessee, US | |
2476172 | 2476172 | 2022-02-03 | US | New Mexico | Unassigned | 90035 | 6176 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-02-04 04:21:10 | Unassigned, New Mexico, US | |
2487093 | 2487093 | 2022-11-16 | US | Indiana | Fountain | 18045 | 6176 | 108 | 0 | 40.12361933 | -87.24217689 | 2022-11-17 04:21:11 | Fountain, Indiana, US | |
2596946 | 2596946 | 2022-07-25 | US | South Dakota | Yankton | 46135 | 6176 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-07-26 04:20:58 | Yankton, South Dakota, US | |
2602369 | 2602369 | 2020-10-10 | US | Alabama | Baldwin | 1003 | 6176 | 65 | 0 | 6111 | 30.72774991 | -87.72207058 | 2020-10-11 04:23:46 | Baldwin, Alabama, US |
2652088 | 2652088 | 2022-09-24 | US | North Carolina | Caswell | 37033 | 6176 | 55 | 0 | 36.39312665 | -79.33353281 | 2022-09-25 04:23:31 | Caswell, North Carolina, US | |
2687901 | 2687901 | 2022-10-03 | US | New Mexico | Lincoln | 35027 | 6176 | 70 | 0 | 33.74526079 | -105.4586166 | 2022-10-04 04:22:55 | Lincoln, New Mexico, US | |
2741955 | 2741955 | 2022-07-07 | US | Idaho | Jefferson | 16051 | 6176 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-07-08 04:20:56 | Jefferson, Idaho, US | |
2760543 | 2760543 | 2022-10-18 | US | Wyoming | Uinta | 56041 | 6176 | 43 | 0 | 41.2878183 | -110.5475782 | 2022-10-19 04:22:26 | Uinta, Wyoming, US | |
2767171 | 2767171 | 2021-07-01 | US | New York | Jefferson | 36045 | 6176 | 68 | 0 | 44.04200959 | -75.94653457 | 2021-07-02 04:21:47 | Jefferson, New York, US | |
2767581 | 2767581 | 2021-07-01 | US | Pennsylvania | Bradford | 42015 | 6176 | 96 | 0 | 41.78869215 | -76.51570822 | 2021-07-02 04:21:47 | Bradford, Pennsylvania, US | |
2771268 | 2771268 | 2022-09-26 | US | North Carolina | Caswell | 37033 | 6176 | 55 | 0 | 36.39312665 | -79.33353281 | 2022-09-27 04:23:01 | Caswell, North Carolina, US | |
2829925 | 2829925 | 2022-08-25 | US | Indiana | LaGrange | 18087 | 6176 | 104 | 0 | 41.64232188 | -85.42674232 | 2022-08-26 04:21:02 | LaGrange, Indiana, US | |
2939891 | 2939891 | 2021-05-16 | US | California | San Benito | 6069 | 6176 | 63 | 0 | 36.60308176 | -121.069975 | 2021-05-17 04:20:34 | San Benito, California, US | |
3027382 | 3027382 | 2022-11-17 | US | Indiana | Fountain | 18045 | 6176 | 108 | 0 | 40.12361933 | -87.24217689 | 2022-11-18 04:21:15 | Fountain, Indiana, US | |
3032988 | 3032988 | 2021-06-16 | US | Pennsylvania | Union | 42119 | 6176 | 89 | 0 | 40.96188846 | -77.05996014 | 2021-06-17 04:22:36 | Union, Pennsylvania, US | |
3128155 | 3128155 | 2021-06-28 | US | Pennsylvania | Bradford | 42015 | 6176 | 96 | 0 | 41.78869215 | -76.51570822 | 2021-06-29 04:21:28 | Bradford, Pennsylvania, US | |
3215915 | 3215915 | 2022-10-12 | US | Michigan | Alpena | 26007 | 6176 | 150 | 0 | 45.03477666 | -83.62212411 | 2022-10-13 04:22:39 | Alpena, Michigan, US | |
3251764 | 3251764 | 2022-10-11 | US | Michigan | Alpena | 26007 | 6176 | 150 | 0 | 45.03477666 | -83.62212411 | 2022-10-12 04:22:51 | Alpena, Michigan, US | |
3271470 | 3271470 | 2022-06-19 | US | Missouri | Randolph | 29175 | 6176 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-06-20 04:21:01 | Randolph, Missouri, US | |
3280493 | 3280493 | 2022-10-23 | US | Wyoming | Uinta | 56041 | 6176 | 43 | 0 | 41.2878183 | -110.5475782 | 2022-10-24 04:22:29 | Uinta, Wyoming, US | |
3323235 | 3323235 | 2022-04-07 | US | Tennessee | Smith | 47159 | 6176 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-04-08 04:20:48 | Smith, Tennessee, US | |
3399382 | 3399382 | 2022-06-18 | US | Missouri | Randolph | 29175 | 6176 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-06-19 04:20:51 | Randolph, Missouri, US | |
3461253 | 3461253 | 2022-11-21 | US | Indiana | Fountain | 18045 | 6176 | 108 | 0 | 40.12361933 | -87.24217689 | 2022-11-22 04:20:47 | Fountain, Indiana, US | |
3473998 | 3473998 | 2021-06-08 | US | Minnesota | Chisago | 27025 | 6176 | 52 | 0 | 45.5021011 | -92.90861945 | 2021-06-09 04:23:31 | Chisago, Minnesota, US | |
3478487 | 3478487 | 2021-07-22 | US | New Jersey | Salem | 34033 | 6176 | 189 | 0 | 39.58719656 | -75.34696629999998 | 2021-07-23 04:21:29 | Salem, New Jersey, US | |
3531482 | 3531482 | 2020-08-12 | Japan | Osaka | 6176 | 98 | 4256 | 1822 | 34.620965000000005 | 135.507481 | 2020-08-13 04:29:15 | Osaka, Japan | ||
3651767 | 3651767 | 2020-10-24 | Russia | Kaliningrad Oblast | 6176 | 93 | 4203 | 1880 | 54.7293041 | 21.1489473 | 2020-10-25 04:24:36 | Kaliningrad Oblast, Russia | ||
3689403 | 3689403 | 2022-01-13 | US | Missouri | Lawrence | 29109 | 6176 | 141 | 0 | 37.10626634 | -93.83293097 | 2022-01-14 04:21:54 | Lawrence, Missouri, US | |
3710493 | 3710493 | 2021-04-03 | US | Alabama | Colbert | 1033 | 6176 | 127 | 0 | 34.69847452 | -87.80168544 | 2021-04-04 04:20:49 | Colbert, Alabama, US | |
3755090 | 3755090 | 2022-10-13 | US | Michigan | Alpena | 26007 | 6176 | 150 | 0 | 45.03477666 | -83.62212411 | 2022-10-14 04:22:28 | Alpena, Michigan, US | |
3778811 | 3778811 | 2020-12-27 | US | Idaho | Bannock | 16005 | 6176 | 57 | 0 | 6119 | 42.67002716 | -112.2233311 | 2020-12-28 05:22:06 | Bannock, Idaho, US |
3951007 | 3951007 | 2022-08-17 | US | Arkansas | Ouachita | 5103 | 6176 | 110 | 0 | 33.58839816 | -92.87795984 | 2022-08-18 04:21:11 | Ouachita, Arkansas, US | |
3981231 | 3981231 | 2021-02-10 | US | Pennsylvania | Crawford | 42039 | 6176 | 131 | 0 | 6045 | 41.68447709 | -80.10760592 | 2021-02-11 05:23:55 | Crawford, Pennsylvania, US |
3996940 | 3996940 | 2022-09-27 | US | North Carolina | Caswell | 37033 | 6176 | 55 | 0 | 36.39312665 | -79.33353281 | 2022-09-28 04:23:01 | Caswell, North Carolina, US | |
1821 | 1821 | 2021-12-02 | US | Louisiana | Beauregard | 22011 | 6177 | 124 | 0 | 30.64836518 | -93.34173616 | 2021-12-03 04:23:05 | Beauregard, Louisiana, US | |
3498 | 3498 | 2021-12-02 | US | Texas | Matagorda | 48321 | 6177 | 161 | 0 | 28.81955746 | -96.01230294 | 2021-12-03 04:23:05 | Matagorda, Texas, US | |
18986 | 18986 | 2021-09-18 | US | Oregon | Polk | 41053 | 6177 | 70 | 0 | 44.90322804 | -123.4128888 | 2021-09-19 04:21:34 | Polk, Oregon, US | |
92275 | 92275 | 2022-07-23 | US | Indiana | Randolph | 18135 | 6177 | 149 | 0 | 40.15734772 | -85.01139319 | 2022-07-24 04:20:47 | Randolph, Indiana, US | |
115027 | 115027 | 2022-09-06 | Sao Tome and Principe | 6177 | 76 | 0 | 0.1864 | 6.6131 | 2022-09-07 04:20:59 | Sao Tome and Principe | ||||
131955 | 131955 | 2022-10-04 | US | Iowa | Henry | 19087 | 6177 | 78 | 0 | 40.98767962 | -91.54436349 | 2022-10-05 04:23:06 | Henry, Iowa, US | |
140667 | 140667 | 2021-12-04 | US | Pennsylvania | Pike | 42103 | 6177 | 70 | 0 | 41.33155042 | -75.03208106 | 2021-12-05 04:22:25 | Pike, Pennsylvania, US | |
157140 | 157140 | 2021-01-08 | US | Texas | Maverick | 48323 | 6177 | 207 | 0 | 6829 | 28.7429195 | -100.3157686 | 2021-01-09 05:22:18 | Maverick, Texas, US |
188112 | 188112 | 2022-02-13 | US | Nebraska | Adams | 31001 | 6177 | 46 | 0 | 40.52449420000001 | -98.50117804 | 2022-02-14 04:20:51 | Adams, Nebraska, US | |
230783 | 230783 | 2022-05-31 | US | Maine | Franklin | 23007 | 6177 | 60 | 0 | 44.97330019 | -70.44381045 | 2022-06-01 04:20:55 | Franklin, Maine, US | |
235284 | 235284 | 2022-02-11 | US | Nebraska | Adams | 31001 | 6177 | 46 | 0 | 40.52449420000001 | -98.50117804 | 2022-02-12 04:21:06 | Adams, Nebraska, US | |
241609 | 241609 | 2021-04-02 | US | Alabama | Colbert | 1033 | 6177 | 126 | 0 | 34.69847452 | -87.80168544 | 2021-04-03 04:20:44 | Colbert, Alabama, US | |
253589 | 253589 | 2022-09-08 | Sao Tome and Principe | 6177 | 76 | 0 | 0.1864 | 6.6131 | 2022-09-09 04:21:11 | Sao Tome and Principe | ||||
262580 | 262580 | 2022-03-15 | US | Illinois | Shelby | 17173 | 6177 | 73 | 0 | 39.39133527 | -88.80611122 | 2022-03-16 04:20:50 | Shelby, Illinois, US | |
281512 | 281512 | 2021-02-24 | US | Kansas | Riley | 20161 | 6177 | 33 | 0 | 6144 | 39.28935726 | -96.73420026 | 2021-02-25 05:24:57 | Riley, Kansas, US |
317958 | 317958 | 2022-02-12 | US | Nebraska | Adams | 31001 | 6177 | 46 | 0 | 40.52449420000001 | -98.50117804 | 2022-02-13 04:21:00 | Adams, Nebraska, US | |
396662 | 396662 | 2022-10-07 | US | Alabama | Monroe | 1099 | 6177 | 84 | 0 | 31.56729412 | -87.36995001 | 2022-10-08 04:22:56 | Monroe, Alabama, US | |
432572 | 432572 | 2022-11-03 | US | Iowa | Jones | 19105 | 6177 | 79 | 0 | 42.12118609 | -91.13139641 | 2022-11-04 04:22:11 | Jones, Iowa, 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]);