daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
160 rows where confirmed = 5069 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-28 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-29 04:21:01 | Wadena, Minnesota, US | |
2022-12-27 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-28 04:21:04 | Wadena, Minnesota, US | |
2022-12-26 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-27 04:21:07 | Wadena, Minnesota, US | |
2022-12-25 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-26 04:21:06 | Wadena, Minnesota, US | |
2022-12-24 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-25 04:21:04 | Wadena, Minnesota, US | |
2022-12-23 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-24 04:21:02 | Wadena, Minnesota, US | |
2022-12-22 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-23 04:21:04 | Wadena, Minnesota, US | |
2022-12-14 | US | Illinois | De Witt | 17039 | 5069 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-12-15 04:20:58 | De Witt, Illinois, US | |
2022-11-18 | US | Puerto Rico | Jayuya | 72073 | 5069 | 0 | 0 | 18.211446 | -66.58878 | 2022-11-19 04:21:14 | Jayuya, Puerto Rico, US | |
2022-11-08 | China | Beijing | 5069 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-09 04:21:22 | Beijing, China | |||
2022-09-12 | US | Nebraska | Washington | 31177 | 5069 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-09-13 04:20:57 | Washington, Nebraska, US | |
2022-09-11 | US | Nebraska | Washington | 31177 | 5069 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-09-12 04:20:58 | Washington, Nebraska, US | |
2022-09-10 | US | Nebraska | Washington | 31177 | 5069 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-09-11 04:20:50 | Washington, Nebraska, US | |
2022-09-09 | US | Nebraska | Washington | 31177 | 5069 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-09-10 04:21:10 | Washington, Nebraska, US | |
2022-09-08 | US | Nebraska | Washington | 31177 | 5069 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-09-09 04:21:11 | Washington, Nebraska, US | |
2022-09-07 | US | Nebraska | Washington | 31177 | 5069 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-09-08 04:21:02 | Washington, Nebraska, US | |
2022-09-06 | US | Nebraska | Washington | 31177 | 5069 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-09-07 04:20:59 | Washington, Nebraska, US | |
2022-08-30 | US | Louisiana | Jackson | 22049 | 5069 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-31 04:20:57 | Jackson, Louisiana, US | |
2022-08-27 | US | Puerto Rico | Loiza | 72087 | 5069 | 0 | 0 | 18.425688 | -65.89943 | 2022-08-28 04:21:02 | Loiza, Puerto Rico, US | |
2022-07-13 | US | Arkansas | Phillips | 5107 | 5069 | 99 | 0 | 34.43268455 | -90.84800154 | 2022-07-14 04:20:57 | Phillips, Arkansas, US | |
2022-07-07 | US | Virginia | New Kent | 51127 | 5069 | 34 | 0 | 37.50694406 | -76.99828634 | 2022-07-08 04:20:56 | New Kent, Virginia, US | |
2022-07-04 | US | Alabama | Fayette | 1057 | 5069 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-07-05 04:20:45 | Fayette, Alabama, US | |
2022-06-30 | US | Texas | Scurry | 48415 | 5069 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-07-01 04:21:10 | Scurry, Texas, US | |
2022-06-25 | US | Colorado | Chaffee | 8015 | 5069 | 50 | 0 | 38.74745778 | -106.1926573 | 2022-06-26 04:21:02 | Chaffee, Colorado, US | |
2022-06-13 | US | Nebraska | Saunders | 31155 | 5069 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-06-14 04:20:52 | Saunders, Nebraska, US | |
2022-06-12 | US | Nebraska | Saunders | 31155 | 5069 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-06-13 04:21:14 | Saunders, Nebraska, US | |
2022-06-11 | US | Nebraska | Saunders | 31155 | 5069 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-06-12 04:20:53 | Saunders, Nebraska, US | |
2022-06-10 | US | Nebraska | Saunders | 31155 | 5069 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-06-11 04:21:01 | Saunders, Nebraska, US | |
2022-06-01 | US | New Mexico | Roosevelt | 35041 | 5069 | 98 | 0 | 34.02097406 | -103.4799493 | 2022-06-02 05:20:39 | Roosevelt, New Mexico, US | |
2022-05-26 | US | Illinois | Pike | 17149 | 5069 | 67 | 0 | 39.62265059 | -90.8877017 | 2022-05-27 04:20:56 | Pike, Illinois, US | |
2022-05-17 | US | Georgia | McDuffie | 13189 | 5069 | 98 | 0 | 33.47851918 | -82.48252774 | 2022-05-18 04:20:50 | McDuffie, Georgia, US | |
2022-05-16 | US | Georgia | McDuffie | 13189 | 5069 | 98 | 0 | 33.47851918 | -82.48252774 | 2022-05-17 04:20:59 | McDuffie, Georgia, US | |
2022-05-15 | US | Georgia | McDuffie | 13189 | 5069 | 98 | 0 | 33.47851918 | -82.48252774 | 2022-05-16 04:20:47 | McDuffie, Georgia, US | |
2022-05-14 | US | Georgia | McDuffie | 13189 | 5069 | 98 | 0 | 33.47851918 | -82.48252774 | 2022-05-15 04:20:53 | McDuffie, Georgia, US | |
2022-05-13 | US | Georgia | McDuffie | 13189 | 5069 | 98 | 0 | 33.47851918 | -82.48252774 | 2022-05-14 04:20:48 | McDuffie, Georgia, US | |
2022-05-12 | US | Georgia | McDuffie | 13189 | 5069 | 98 | 0 | 33.47851918 | -82.48252774 | 2022-05-13 04:20:51 | McDuffie, Georgia, US | |
2022-05-11 | US | Georgia | McDuffie | 13189 | 5069 | 98 | 0 | 33.47851918 | -82.48252774 | 2022-05-12 04:20:54 | McDuffie, Georgia, US | |
2022-04-05 | US | Georgia | Tattnall | 13267 | 5069 | 131 | 0 | 32.04785085 | -82.05539188 | 2022-04-06 04:20:49 | Tattnall, Georgia, US | |
2022-03-30 | US | North Carolina | Madison | 37115 | 5069 | 79 | 0 | 35.85402722 | -82.71346418 | 2022-03-31 04:20:56 | Madison, North Carolina, US | |
2022-03-17 | US | Texas | Limestone | 48293 | 5069 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-03-18 04:20:55 | Limestone, Texas, US | |
2022-03-02 | US | Arkansas | Ashley | 5003 | 5069 | 61 | 0 | 33.19153461 | -91.76984709999999 | 2022-03-03 04:21:01 | Ashley, Arkansas, US | |
2022-02-23 | Australia | Western Australia | 5069 | 10 | 0 | -31.9505 | 115.8605 | 2022-02-24 04:21:14 | Western Australia, Australia | |||
2022-02-22 | US | Illinois | Edgar | 17045 | 5069 | 57 | 0 | 39.6809186 | -87.74759563 | 2022-02-23 04:21:09 | Edgar, Illinois, US | |
2022-02-13 | US | Georgia | Mitchell | 13205 | 5069 | 106 | 0 | 31.22483255 | -84.19381821 | 2022-02-14 04:20:51 | Mitchell, Georgia, US | |
2022-02-12 | US | Georgia | Mitchell | 13205 | 5069 | 106 | 0 | 31.22483255 | -84.19381821 | 2022-02-13 04:21:00 | Mitchell, Georgia, US | |
2022-02-11 | US | Georgia | Mitchell | 13205 | 5069 | 106 | 0 | 31.22483255 | -84.19381821 | 2022-02-12 04:21:06 | Mitchell, Georgia, US | |
2022-02-11 | Russia | Nenets Autonomous Okrug | 5069 | 93 | 0 | 68.27557185 | 57.1686375 | 2022-02-12 04:21:06 | Nenets Autonomous Okrug, Russia | |||
2022-02-09 | US | Kentucky | Spencer | 21215 | 5069 | 48 | 0 | 38.03223971 | -85.32749335 | 2022-02-10 04:21:14 | Spencer, Kentucky, US | |
2022-02-03 | US | Tennessee | Union | 47173 | 5069 | 67 | 0 | 36.28590426 | -83.83651902 | 2022-02-04 04:21:10 | Union, Tennessee, US | |
2022-02-02 | US | Georgia | Dodge | 13091 | 5069 | 138 | 0 | 32.17265114 | -83.16948926 | 2022-02-03 04:21:21 | Dodge, Georgia, US | |
2022-01-30 | US | Georgia | Franklin | 13119 | 5069 | 90 | 0 | 34.37525597 | -83.23159927 | 2022-01-31 04:21:09 | Franklin, Georgia, US | |
2022-01-29 | US | Georgia | Franklin | 13119 | 5069 | 90 | 0 | 34.37525597 | -83.23159927 | 2022-01-30 04:21:26 | Franklin, Georgia, US | |
2022-01-28 | US | Georgia | Franklin | 13119 | 5069 | 90 | 0 | 34.37525597 | -83.23159927 | 2022-01-29 04:21:10 | Franklin, Georgia, US | |
2022-01-27 | US | Minnesota | Dodge | 27039 | 5069 | 14 | 0 | 44.02238415 | -92.86244324 | 2022-01-28 04:21:09 | Dodge, Minnesota, US | |
2022-01-07 | US | Tennessee | Grainger | 47057 | 5069 | 92 | 0 | 36.27469206 | -83.51254721 | 2022-01-08 04:21:53 | Grainger, Tennessee, US | |
2022-01-07 | US | Ohio | Henry | 39069 | 5069 | 97 | 0 | 41.333964200000004 | -84.06830637 | 2022-01-08 04:21:53 | Henry, Ohio, US | |
2022-01-04 | US | Louisiana | Jefferson Davis | 22053 | 5069 | 133 | 0 | 30.26896765 | -92.81210004 | 2022-01-05 04:21:59 | Jefferson Davis, Louisiana, US | |
2022-01-02 | US | Texas | Gray | 48179 | 5069 | 95 | 0 | 35.40081878 | -100.8129222 | 2022-01-03 02:22:25 | Gray, Texas, US | |
2021-12-23 | US | Texas | Palo Pinto | 48363 | 5069 | 127 | 0 | 32.75310985 | -98.31319001 | 2021-12-24 04:21:34 | Palo Pinto, Texas, US | |
2021-12-13 | US | Puerto Rico | Ponce | 72113 | 5069 | 0 | 0 | 18.059498 | -66.613748 | 2021-12-14 04:22:38 | Ponce, Puerto Rico, US | |
2021-12-13 | US | Georgia | Madison | 13195 | 5069 | 81 | 0 | 34.12920917 | -83.21218732 | 2021-12-14 04:22:38 | Madison, Georgia, US | |
2021-12-12 | US | Puerto Rico | Ponce | 72113 | 5069 | 0 | 0 | 18.059498 | -66.613748 | 2021-12-13 04:22:02 | Ponce, Puerto Rico, US | |
2021-12-12 | US | Nevada | Douglas | 32005 | 5069 | 72 | 0 | 38.912862 | -119.61713329999999 | 2021-12-13 04:22:02 | Douglas, Nevada, US | |
2021-12-11 | US | Nevada | Douglas | 32005 | 5069 | 72 | 0 | 38.912862 | -119.61713329999999 | 2021-12-12 04:22:12 | Douglas, Nevada, US | |
2021-12-10 | US | Nevada | Douglas | 32005 | 5069 | 72 | 0 | 38.912862 | -119.61713329999999 | 2021-12-11 04:22:45 | Douglas, Nevada, US | |
2021-12-09 | US | Nevada | Douglas | 32005 | 5069 | 72 | 0 | 38.912862 | -119.61713329999999 | 2021-12-10 04:22:28 | Douglas, Nevada, US | |
2021-12-07 | US | West Virginia | Mingo | 54059 | 5069 | 91 | 0 | 37.73048351 | -82.13338365 | 2021-12-08 04:22:46 | Mingo, West Virginia, US | |
2021-12-05 | US | Texas | DeWitt | 48123 | 5069 | 85 | 0 | 29.08101855 | -97.35681170000001 | 2021-12-06 04:22:34 | DeWitt, Texas, US | |
2021-12-02 | US | Kentucky | Grayson | 21085 | 5069 | 100 | 0 | 37.46231118 | -86.34248968 | 2021-12-03 04:23:05 | Grayson, Kentucky, US | |
2021-11-17 | US | Alabama | Pike | 1109 | 5069 | 108 | 0 | 31.80396383 | -85.9408295 | 2021-11-18 04:21:33 | Pike, Alabama, US | |
2021-11-15 | US | Virginia | Petersburg | 51730 | 5069 | 103 | 0 | 37.20530399 | -77.39368102 | 2021-11-16 04:21:10 | Petersburg, Virginia, US | |
2021-11-10 | US | Minnesota | Nobles | 27105 | 5069 | 53 | 0 | 43.67434621 | -95.75329576 | 2021-11-11 04:21:45 | Nobles, Minnesota, US | |
2021-11-08 | US | Colorado | Summit | 8117 | 5069 | 11 | 0 | 39.63803232 | -106.1150762 | 2021-11-09 04:21:36 | Summit, Colorado, US | |
2021-10-31 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-11-01 04:22:01 | Chad | ||||
2021-10-30 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-31 04:22:08 | Chad | ||||
2021-10-29 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-30 04:22:03 | Chad | ||||
2021-10-28 | US | Wisconsin | Oneida | 55085 | 5069 | 91 | 0 | 45.70677897 | -89.51944105 | 2021-10-29 04:22:03 | Oneida, Wisconsin, US | |
2021-10-28 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-29 04:22:03 | Chad | ||||
2021-10-27 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-28 04:22:08 | Chad | ||||
2021-10-26 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-27 04:22:32 | Chad | ||||
2021-10-25 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-26 04:22:09 | Chad | ||||
2021-10-24 | US | North Carolina | Person | 37145 | 5069 | 87 | 0 | 36.38989032 | -78.97217358 | 2021-10-25 04:22:31 | Person, North Carolina, US | |
2021-10-24 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-25 04:22:31 | Chad | ||||
2021-10-23 | US | North Carolina | Person | 37145 | 5069 | 87 | 0 | 36.38989032 | -78.97217358 | 2021-10-24 04:21:22 | Person, North Carolina, US | |
2021-10-23 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-24 04:21:22 | Chad | ||||
2021-10-22 | US | North Carolina | Person | 37145 | 5069 | 87 | 0 | 36.38989032 | -78.97217358 | 2021-10-23 04:21:32 | Person, North Carolina, US | |
2021-10-22 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-23 04:21:32 | Chad | ||||
2021-10-21 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-22 04:21:14 | Chad | ||||
2021-10-20 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-21 04:21:18 | Chad | ||||
2021-10-19 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-20 04:21:00 | Chad | ||||
2021-10-18 | Chad | 5069 | 174 | 0 | 15.4542 | 18.7322 | 2021-10-19 04:20:54 | Chad | ||||
2021-10-16 | US | Indiana | Jefferson | 18077 | 5069 | 95 | 0 | 38.78576239 | -85.43633383 | 2021-10-17 04:21:29 | Jefferson, Indiana, US | |
2021-10-15 | US | Kentucky | Clay | 21051 | 5069 | 56 | 0 | 37.16451126 | -83.712575 | 2021-10-16 04:21:15 | Clay, Kentucky, US | |
2021-10-06 | US | Missouri | Lawrence | 29109 | 5069 | 104 | 0 | 37.10626634 | -93.83293097 | 2021-10-07 04:21:36 | Lawrence, Missouri, US | |
2021-10-02 | US | Missouri | Marion | 29127 | 5069 | 58 | 0 | 39.80601912 | -91.62203062 | 2021-10-03 04:21:24 | Marion, Missouri, US | |
2021-09-29 | US | Virginia | Charlottesville | 51540 | 5069 | 57 | 0 | 38.03527919 | -78.48569588 | 2021-09-30 04:21:20 | Charlottesville, Virginia, US | |
2021-09-14 | US | Georgia | Upson | 13293 | 5069 | 138 | 0 | 32.87920671 | -84.30024826 | 2021-09-15 03:22:37 | Upson, Georgia, US | |
2021-09-08 | US | Tennessee | Giles | 47055 | 5069 | 101 | 0 | 35.20222469 | -87.03992678 | 2021-09-09 04:21:27 | Giles, Tennessee, US | |
2021-08-23 | US | Wyoming | Albany | 56001 | 5069 | 19 | 0 | 41.65498705 | -105.72354150000001 | 2021-08-24 04:21:19 | Albany, Wyoming, US | |
2021-08-23 | US | Missouri | Howell | 29091 | 5069 | 58 | 0 | 36.77383887 | -91.88683935 | 2021-08-24 04:21:19 | Howell, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;