daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
203 rows where confirmed = 4901 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-29 | US | Texas | Andrews | 48003 | 4901 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-12-30 04:21:04 | Andrews, Texas, US | |
2022-12-28 | US | Texas | Andrews | 48003 | 4901 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-12-29 04:21:01 | Andrews, Texas, US | |
2022-12-21 | US | Illinois | Warren | 17187 | 4901 | 87 | 0 | 40.84925021 | -90.6147432 | 2022-12-22 04:20:56 | Warren, Illinois, US | |
2022-11-21 | US | Wisconsin | Burnett | 55013 | 4901 | 44 | 0 | 45.86303537 | -92.36711412 | 2022-11-22 04:20:47 | Burnett, Wisconsin, US | |
2022-11-02 | US | Minnesota | Wadena | 27159 | 4901 | 62 | 0 | 46.58589171 | -94.96968506 | 2022-11-03 04:22:05 | Wadena, Minnesota, US | |
2022-11-01 | US | Minnesota | Wadena | 27159 | 4901 | 62 | 0 | 46.58589171 | -94.96968506 | 2022-11-02 04:22:09 | Wadena, Minnesota, US | |
2022-10-31 | US | Minnesota | Wadena | 27159 | 4901 | 62 | 0 | 46.58589171 | -94.96968506 | 2022-11-01 04:22:36 | Wadena, Minnesota, US | |
2022-10-30 | US | Minnesota | Wadena | 27159 | 4901 | 62 | 0 | 46.58589171 | -94.96968506 | 2022-10-31 04:21:36 | Wadena, Minnesota, US | |
2022-10-29 | US | Minnesota | Wadena | 27159 | 4901 | 62 | 0 | 46.58589171 | -94.96968506 | 2022-10-30 04:22:14 | Wadena, Minnesota, US | |
2022-10-28 | US | Minnesota | Wadena | 27159 | 4901 | 62 | 0 | 46.58589171 | -94.96968506 | 2022-10-29 04:21:13 | Wadena, Minnesota, US | |
2022-10-27 | US | Virginia | Giles | 51071 | 4901 | 52 | 0 | 37.31234791 | -80.70636931 | 2022-10-28 04:22:31 | Giles, Virginia, US | |
2022-10-27 | US | Minnesota | Wadena | 27159 | 4901 | 62 | 0 | 46.58589171 | -94.96968506 | 2022-10-28 04:22:31 | Wadena, Minnesota, US | |
2022-10-26 | US | Oklahoma | Murray | 40099 | 4901 | 82 | 0 | 34.48116015 | -97.06826283 | 2022-10-27 04:22:01 | Murray, Oklahoma, US | |
2022-10-25 | US | Oklahoma | Murray | 40099 | 4901 | 82 | 0 | 34.48116015 | -97.06826283 | 2022-10-26 04:22:19 | Murray, Oklahoma, US | |
2022-10-24 | US | Oklahoma | Murray | 40099 | 4901 | 82 | 0 | 34.48116015 | -97.06826283 | 2022-10-25 04:21:53 | Murray, Oklahoma, US | |
2022-10-23 | US | Oklahoma | Murray | 40099 | 4901 | 82 | 0 | 34.48116015 | -97.06826283 | 2022-10-24 04:22:29 | Murray, Oklahoma, US | |
2022-10-22 | US | Oklahoma | Murray | 40099 | 4901 | 82 | 0 | 34.48116015 | -97.06826283 | 2022-10-23 04:22:46 | Murray, Oklahoma, US | |
2022-10-21 | US | Oklahoma | Murray | 40099 | 4901 | 82 | 0 | 34.48116015 | -97.06826283 | 2022-10-22 04:22:53 | Murray, Oklahoma, US | |
2022-10-20 | US | Oklahoma | Murray | 40099 | 4901 | 82 | 0 | 34.48116015 | -97.06826283 | 2022-10-21 04:22:23 | Murray, Oklahoma, US | |
2022-10-20 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-21 04:22:23 | Union, Florida, US | |
2022-10-19 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-20 04:22:59 | Union, Florida, US | |
2022-10-18 | US | West Virginia | Morgan | 54065 | 4901 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-19 04:22:26 | Morgan, West Virginia, US | |
2022-10-18 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-19 04:22:26 | Union, Florida, US | |
2022-10-17 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-18 04:22:42 | Union, Florida, US | |
2022-10-16 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-17 04:20:31 | Union, Florida, US | |
2022-10-15 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-16 04:22:39 | Union, Florida, US | |
2022-10-14 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-15 04:22:00 | Union, Florida, US | |
2022-10-13 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-14 04:22:28 | Union, Florida, US | |
2022-10-12 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-13 04:22:39 | Union, Florida, US | |
2022-10-11 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-12 04:22:51 | Union, Florida, US | |
2022-10-10 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-11 04:23:05 | Union, Florida, US | |
2022-10-09 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-10 04:22:32 | Union, Florida, US | |
2022-10-08 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-09 04:21:16 | Union, Florida, US | |
2022-10-07 | US | Florida | Union | 12125 | 4901 | 120 | 0 | 30.04412971 | -82.37497443 | 2022-10-08 04:22:56 | Union, Florida, US | |
2022-09-15 | US | Virginia | Grayson | 51077 | 4901 | 84 | 0 | 36.65677234 | -81.23215889 | 2022-09-16 04:21:19 | Grayson, Virginia, US | |
2022-09-01 | US | Texas | Shelby | 48419 | 4901 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-02 04:21:07 | Shelby, Texas, US | |
2022-08-11 | US | Texas | Robertson | 48395 | 4901 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-08-12 04:20:54 | Robertson, Texas, US | |
2022-08-03 | US | Tennessee | Bledsoe | 47007 | 4901 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-08-04 04:20:58 | Bledsoe, Tennessee, US | |
2022-07-28 | US | Puerto Rico | Santa Isabel | 72133 | 4901 | 0 | 0 | 17.994525 | -66.388913 | 2022-07-29 04:20:45 | Santa Isabel, Puerto Rico, US | |
2022-07-24 | US | Arkansas | Drew | 5043 | 4901 | 71 | 0 | 33.59035001 | -91.71777921 | 2022-07-25 04:20:51 | Drew, Arkansas, US | |
2022-07-23 | US | Arkansas | Drew | 5043 | 4901 | 71 | 0 | 33.59035001 | -91.71777921 | 2022-07-24 04:20:47 | Drew, Arkansas, US | |
2022-07-21 | US | Illinois | Piatt | 17147 | 4901 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-07-22 04:21:15 | Piatt, Illinois, US | |
2022-07-19 | US | Iowa | Jackson | 19097 | 4901 | 70 | 0 | 42.17178824 | -90.57354837 | 2022-07-20 04:20:59 | Jackson, Iowa, US | |
2022-07-18 | US | Iowa | Jackson | 19097 | 4901 | 70 | 0 | 42.17178824 | -90.57354837 | 2022-07-19 04:20:58 | Jackson, Iowa, US | |
2022-07-17 | US | Iowa | Jackson | 19097 | 4901 | 70 | 0 | 42.17178824 | -90.57354837 | 2022-07-18 04:20:59 | Jackson, Iowa, US | |
2022-07-16 | US | Iowa | Jackson | 19097 | 4901 | 70 | 0 | 42.17178824 | -90.57354837 | 2022-07-17 04:21:15 | Jackson, Iowa, US | |
2022-07-15 | US | Iowa | Jackson | 19097 | 4901 | 70 | 0 | 42.17178824 | -90.57354837 | 2022-07-16 04:21:05 | Jackson, Iowa, US | |
2022-07-14 | US | Texas | Gonzales | 48177 | 4901 | 101 | 0 | 29.45634206 | -97.49424032 | 2022-07-15 04:20:53 | Gonzales, Texas, US | |
2022-07-14 | US | Iowa | Jackson | 19097 | 4901 | 70 | 0 | 42.17178824 | -90.57354837 | 2022-07-15 04:20:53 | Jackson, Iowa, US | |
2022-07-13 | US | Iowa | Jackson | 19097 | 4901 | 70 | 0 | 42.17178824 | -90.57354837 | 2022-07-14 04:20:57 | Jackson, Iowa, US | |
2022-07-06 | US | Tennessee | Polk | 47139 | 4901 | 81 | 0 | 35.12245443 | -84.52075859 | 2022-07-07 04:20:55 | Polk, Tennessee, US | |
2022-07-05 | US | West Virginia | Taylor | 54091 | 4901 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-07-06 04:20:58 | Taylor, West Virginia, US | |
2022-07-04 | US | Texas | Deaf Smith | 48117 | 4901 | 112 | 0 | 34.96522957 | -102.6054267 | 2022-07-05 04:20:45 | Deaf Smith, Texas, US | |
2022-07-03 | US | Texas | Deaf Smith | 48117 | 4901 | 112 | 0 | 34.96522957 | -102.6054267 | 2022-07-04 04:20:54 | Deaf Smith, Texas, US | |
2022-07-02 | US | Texas | Deaf Smith | 48117 | 4901 | 112 | 0 | 34.96522957 | -102.6054267 | 2022-07-03 04:20:59 | Deaf Smith, Texas, US | |
2022-07-01 | US | Texas | Deaf Smith | 48117 | 4901 | 112 | 0 | 34.96522957 | -102.6054267 | 2022-07-02 04:21:16 | Deaf Smith, Texas, US | |
2022-06-21 | US | Indiana | Starke | 18149 | 4901 | 100 | 0 | 41.27890281 | -86.64686895 | 2022-06-22 04:20:54 | Starke, Indiana, US | |
2022-06-20 | US | Indiana | Starke | 18149 | 4901 | 100 | 0 | 41.27890281 | -86.64686895 | 2022-06-21 04:20:56 | Starke, Indiana, US | |
2022-06-13 | US | Arkansas | Cross | 5037 | 4901 | 86 | 0 | 35.29631396 | -90.77185818 | 2022-06-14 04:20:52 | Cross, Arkansas, US | |
2022-06-07 | US | Georgia | Union | 13291 | 4901 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-06-08 04:20:55 | Union, Georgia, US | |
2022-06-06 | US | Georgia | Union | 13291 | 4901 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-06-07 04:21:08 | Union, Georgia, US | |
2022-06-05 | US | Georgia | Union | 13291 | 4901 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-06-06 04:20:57 | Union, Georgia, US | |
2022-06-04 | US | Georgia | Union | 13291 | 4901 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-06-05 04:20:55 | Union, Georgia, US | |
2022-06-03 | US | Georgia | Union | 13291 | 4901 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-06-04 04:20:58 | Union, Georgia, US | |
2022-06-02 | US | Georgia | Union | 13291 | 4901 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-06-03 04:20:58 | Union, Georgia, US | |
2022-06-01 | US | Georgia | Union | 13291 | 4901 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-06-02 05:20:39 | Union, Georgia, US | |
2022-05-08 | US | Mississippi | Jasper | 28061 | 4901 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-09 04:20:54 | Jasper, Mississippi, US | |
2022-05-07 | US | Mississippi | Jasper | 28061 | 4901 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-08 04:20:49 | Jasper, Mississippi, US | |
2022-05-06 | US | Mississippi | Jasper | 28061 | 4901 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-07 04:21:09 | Jasper, Mississippi, US | |
2022-05-05 | US | Mississippi | Jasper | 28061 | 4901 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-06 04:21:00 | Jasper, Mississippi, US | |
2022-05-04 | US | Mississippi | Jasper | 28061 | 4901 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-05 04:20:55 | Jasper, Mississippi, US | |
2022-05-03 | US | Mississippi | Jasper | 28061 | 4901 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-04 04:20:59 | Jasper, Mississippi, US | |
2022-05-02 | US | Mississippi | Jasper | 28061 | 4901 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-03 04:21:00 | Jasper, Mississippi, US | |
2022-04-25 | US | Puerto Rico | Guayama | 72057 | 4901 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-04-26 04:20:51 | Guayama, Puerto Rico, US | |
2022-03-20 | US | Virginia | Radford | 51750 | 4901 | 47 | 0 | 37.12222899 | -80.56027320000003 | 2022-03-21 04:20:50 | Radford, Virginia, US | |
2022-03-20 | Peru | Unknown | 4901 | 319 | 0 | 2022-03-21 04:20:50 | Unknown, Peru | |||||
2022-03-19 | US | Virginia | Radford | 51750 | 4901 | 47 | 0 | 37.12222899 | -80.56027320000003 | 2022-03-20 04:20:45 | Radford, Virginia, US | |
2022-03-18 | US | Virginia | Radford | 51750 | 4901 | 47 | 0 | 37.12222899 | -80.56027320000003 | 2022-03-19 04:20:47 | Radford, Virginia, US | |
2022-03-17 | US | Arkansas | Lincoln | 5079 | 4901 | 66 | 0 | 33.95317155 | -91.74002806 | 2022-03-18 04:20:55 | Lincoln, Arkansas, US | |
2022-03-16 | US | Washington | Adams | 53001 | 4901 | 38 | 0 | 46.98299757 | -118.56017340000001 | 2022-03-17 04:20:56 | Adams, Washington, US | |
2022-03-15 | US | Washington | Adams | 53001 | 4901 | 38 | 0 | 46.98299757 | -118.56017340000001 | 2022-03-16 04:20:50 | Adams, Washington, US | |
2022-03-15 | US | Indiana | Fulton | 18049 | 4901 | 99 | 0 | 41.0469907 | -86.26252745 | 2022-03-16 04:20:50 | Fulton, Indiana, US | |
2022-03-14 | US | Washington | Adams | 53001 | 4901 | 38 | 0 | 46.98299757 | -118.56017340000001 | 2022-03-15 04:20:47 | Adams, Washington, US | |
2022-03-04 | US | Texas | Milam | 48331 | 4901 | 99 | 0 | 30.78581830000001 | -96.97718698 | 2022-03-05 04:21:10 | Milam, Texas, US | |
2022-02-10 | US | Georgia | Tattnall | 13267 | 4901 | 123 | 0 | 32.04785085 | -82.05539188 | 2022-02-11 04:21:09 | Tattnall, Georgia, US | |
2022-02-10 | US | Arkansas | Logan | 5083 | 4901 | 60 | 0 | 35.21413234 | -93.71951016 | 2022-02-11 04:21:09 | Logan, Arkansas, US | |
2022-02-08 | US | Tennessee | Crockett | 47033 | 4901 | 78 | 0 | 35.81830662 | -89.14916269 | 2022-02-09 04:21:04 | Crockett, Tennessee, US | |
2022-02-07 | US | Tennessee | Johnson | 47091 | 4901 | 75 | 0 | 36.45523950000001 | -81.84886538 | 2022-02-08 04:21:15 | Johnson, Tennessee, US | |
2022-02-02 | US | Missouri | McDonald | 29119 | 4901 | 62 | 0 | 36.62869595 | -94.34867205 | 2022-02-03 04:21:21 | McDonald, Missouri, US | |
2022-01-22 | US | Puerto Rico | Moca | 72099 | 4901 | 0 | 0 | 18.377805 | -67.080952 | 2022-01-23 04:21:13 | Moca, Puerto Rico, US | |
2022-01-18 | US | Nevada | Churchill | 32001 | 4901 | 92 | 0 | 39.58105744 | -118.3394607 | 2022-01-19 04:21:23 | Churchill, Nevada, US | |
2022-01-11 | US | Wisconsin | Kewaunee | 55061 | 4901 | 51 | 0 | 44.51727459 | -87.61468386 | 2022-01-12 04:21:44 | Kewaunee, Wisconsin, US | |
2022-01-08 | Japan | Toyama | 4901 | 52 | 0 | 36.637464 | 137.26934599999998 | 2022-01-09 04:21:46 | Toyama, Japan | |||
2021-12-29 | US | Colorado | Delta | 8029 | 4901 | 123 | 0 | 38.86246243 | -107.86313419999999 | 2021-12-30 04:21:25 | Delta, Colorado, US | |
2021-12-29 | US | Alabama | Winston | 1133 | 4901 | 111 | 0 | 34.15030532 | -87.37325922 | 2021-12-30 04:21:25 | Winston, Alabama, US | |
2021-12-27 | US | Missouri | Barry | 29009 | 4901 | 93 | 0 | 36.70978521 | -93.82919888 | 2021-12-28 04:21:47 | Barry, Missouri, US | |
2021-12-26 | US | South Dakota | Lawrence | 46081 | 4901 | 73 | 0 | 44.35919441 | -103.79294279999999 | 2021-12-27 04:21:58 | Lawrence, South Dakota, US | |
2021-12-25 | US | South Dakota | Lawrence | 46081 | 4901 | 73 | 0 | 44.35919441 | -103.79294279999999 | 2021-12-26 04:21:50 | Lawrence, South Dakota, US | |
2021-12-24 | US | South Dakota | Lawrence | 46081 | 4901 | 73 | 0 | 44.35919441 | -103.79294279999999 | 2021-12-25 04:21:37 | Lawrence, South Dakota, US | |
2021-12-23 | US | South Dakota | Lawrence | 46081 | 4901 | 73 | 0 | 44.35919441 | -103.79294279999999 | 2021-12-24 04:21:34 | Lawrence, South Dakota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;