daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
341 rows where confirmed = 2562 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-11 | US | Virginia | Lexington | 51678 | 2562 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-12 04:21:01 | Lexington, Virginia, US | |
2022-12-10 | US | Virginia | Lexington | 51678 | 2562 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-11 04:20:50 | Lexington, Virginia, US | |
2022-12-09 | US | Virginia | Lexington | 51678 | 2562 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-10 04:21:02 | Lexington, Virginia, US | |
2022-11-29 | US | Texas | Swisher | 48437 | 2562 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-11-30 04:21:07 | Swisher, Texas, US | |
2022-11-28 | US | Texas | Swisher | 48437 | 2562 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-11-29 04:21:05 | Swisher, Texas, US | |
2022-11-01 | US | Georgia | Wilkinson | 13319 | 2562 | 64 | 0 | 32.80291082 | -83.17140684 | 2022-11-02 04:22:09 | Wilkinson, Georgia, US | |
2022-10-31 | US | Georgia | Wilkinson | 13319 | 2562 | 64 | 0 | 32.80291082 | -83.17140684 | 2022-11-01 04:22:36 | Wilkinson, Georgia, US | |
2022-10-30 | US | Georgia | Wilkinson | 13319 | 2562 | 64 | 0 | 32.80291082 | -83.17140684 | 2022-10-31 04:21:36 | Wilkinson, Georgia, US | |
2022-10-29 | US | Georgia | Wilkinson | 13319 | 2562 | 64 | 0 | 32.80291082 | -83.17140684 | 2022-10-30 04:22:14 | Wilkinson, Georgia, US | |
2022-10-28 | US | Georgia | Wilkinson | 13319 | 2562 | 64 | 0 | 32.80291082 | -83.17140684 | 2022-10-29 04:21:13 | Wilkinson, Georgia, US | |
2022-10-27 | US | Georgia | Wilkinson | 13319 | 2562 | 64 | 0 | 32.80291082 | -83.17140684 | 2022-10-28 04:22:31 | Wilkinson, Georgia, US | |
2022-10-26 | US | Oklahoma | Latimer | 40077 | 2562 | 38 | 0 | 34.87844729 | -95.25215049 | 2022-10-27 04:22:01 | Latimer, Oklahoma, US | |
2022-10-26 | US | Georgia | Wilkinson | 13319 | 2562 | 64 | 0 | 32.80291082 | -83.17140684 | 2022-10-27 04:22:01 | Wilkinson, Georgia, US | |
2022-10-25 | US | Oklahoma | Latimer | 40077 | 2562 | 38 | 0 | 34.87844729 | -95.25215049 | 2022-10-26 04:22:19 | Latimer, Oklahoma, US | |
2022-10-24 | US | Oklahoma | Latimer | 40077 | 2562 | 38 | 0 | 34.87844729 | -95.25215049 | 2022-10-25 04:21:53 | Latimer, Oklahoma, US | |
2022-10-23 | US | Oklahoma | Latimer | 40077 | 2562 | 38 | 0 | 34.87844729 | -95.25215049 | 2022-10-24 04:22:29 | Latimer, Oklahoma, US | |
2022-10-22 | US | Oklahoma | Latimer | 40077 | 2562 | 38 | 0 | 34.87844729 | -95.25215049 | 2022-10-23 04:22:46 | Latimer, Oklahoma, US | |
2022-10-21 | US | Oklahoma | Latimer | 40077 | 2562 | 38 | 0 | 34.87844729 | -95.25215049 | 2022-10-22 04:22:53 | Latimer, Oklahoma, US | |
2022-10-20 | US | Oklahoma | Latimer | 40077 | 2562 | 38 | 0 | 34.87844729 | -95.25215049 | 2022-10-21 04:22:23 | Latimer, Oklahoma, US | |
2022-10-18 | US | Iowa | Emmet | 19063 | 2562 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-19 04:22:26 | Emmet, Iowa, US | |
2022-10-18 | US | Georgia | Wilkinson | 13319 | 2562 | 63 | 0 | 32.80291082 | -83.17140684 | 2022-10-19 04:22:26 | Wilkinson, Georgia, US | |
2022-10-17 | US | Iowa | Emmet | 19063 | 2562 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-18 04:22:42 | Emmet, Iowa, US | |
2022-10-17 | US | Georgia | Wilkinson | 13319 | 2562 | 63 | 0 | 32.80291082 | -83.17140684 | 2022-10-18 04:22:42 | Wilkinson, Georgia, US | |
2022-10-16 | US | Iowa | Emmet | 19063 | 2562 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-17 04:20:31 | Emmet, Iowa, US | |
2022-10-16 | US | Georgia | Wilkinson | 13319 | 2562 | 63 | 0 | 32.80291082 | -83.17140684 | 2022-10-17 04:20:31 | Wilkinson, Georgia, US | |
2022-10-15 | US | Iowa | Emmet | 19063 | 2562 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-16 04:22:39 | Emmet, Iowa, US | |
2022-10-15 | US | Georgia | Wilkinson | 13319 | 2562 | 63 | 0 | 32.80291082 | -83.17140684 | 2022-10-16 04:22:39 | Wilkinson, Georgia, US | |
2022-10-14 | US | Iowa | Emmet | 19063 | 2562 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-15 04:22:00 | Emmet, Iowa, US | |
2022-10-14 | US | Georgia | Wilkinson | 13319 | 2562 | 63 | 0 | 32.80291082 | -83.17140684 | 2022-10-15 04:22:00 | Wilkinson, Georgia, US | |
2022-10-13 | US | Iowa | Emmet | 19063 | 2562 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-14 04:22:28 | Emmet, Iowa, US | |
2022-10-13 | US | Georgia | Wilkinson | 13319 | 2562 | 63 | 0 | 32.80291082 | -83.17140684 | 2022-10-14 04:22:28 | Wilkinson, Georgia, US | |
2022-10-12 | US | Iowa | Emmet | 19063 | 2562 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-13 04:22:39 | Emmet, Iowa, US | |
2022-10-12 | US | Georgia | Wilkinson | 13319 | 2562 | 63 | 0 | 32.80291082 | -83.17140684 | 2022-10-13 04:22:39 | Wilkinson, Georgia, US | |
2022-10-04 | US | Tennessee | Clay | 47027 | 2562 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-10-05 04:23:06 | Clay, Tennessee, US | |
2022-10-03 | US | Tennessee | Clay | 47027 | 2562 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-10-04 04:22:55 | Clay, Tennessee, US | |
2022-10-02 | US | West Virginia | Tyler | 54095 | 2562 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-10-03 04:23:11 | Tyler, West Virginia, US | |
2022-10-01 | US | West Virginia | Tyler | 54095 | 2562 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-10-02 04:21:23 | Tyler, West Virginia, US | |
2022-09-30 | US | West Virginia | Tyler | 54095 | 2562 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-10-01 04:23:01 | Tyler, West Virginia, US | |
2022-09-28 | US | Texas | Parmer | 48369 | 2562 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-09-29 04:22:34 | Parmer, Texas, US | |
2022-09-27 | US | Texas | Parmer | 48369 | 2562 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-09-28 04:23:01 | Parmer, Texas, US | |
2022-09-26 | US | Texas | Parmer | 48369 | 2562 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-09-27 04:23:01 | Parmer, Texas, US | |
2022-09-25 | US | Virginia | Franklin City | 51620 | 2562 | 55 | 0 | 36.6831435 | -76.93859681 | 2022-09-26 04:20:52 | Franklin City, Virginia, US | |
2022-09-24 | US | Virginia | Franklin City | 51620 | 2562 | 55 | 0 | 36.6831435 | -76.93859681 | 2022-09-25 04:23:31 | Franklin City, Virginia, US | |
2022-09-23 | US | Virginia | Franklin City | 51620 | 2562 | 55 | 0 | 36.6831435 | -76.93859681 | 2022-09-24 04:21:40 | Franklin City, Virginia, US | |
2022-09-22 | US | Tennessee | Moore | 47127 | 2562 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-09-23 04:23:13 | Moore, Tennessee, US | |
2022-09-21 | US | Tennessee | Moore | 47127 | 2562 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-09-22 04:22:56 | Moore, Tennessee, US | |
2022-09-05 | US | Texas | Castro | 48069 | 2562 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-09-06 04:21:02 | Castro, Texas, US | |
2022-09-04 | US | Texas | Castro | 48069 | 2562 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-09-05 04:21:01 | Castro, Texas, US | |
2022-09-03 | US | Texas | Castro | 48069 | 2562 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-09-04 04:21:22 | Castro, Texas, US | |
2022-09-02 | US | Texas | Castro | 48069 | 2562 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-09-03 04:21:04 | Castro, Texas, US | |
2022-08-30 | US | West Virginia | Clay | 54015 | 2562 | 48 | 0 | 38.46231092 | -81.07652217 | 2022-08-31 04:20:57 | Clay, West Virginia, US | |
2022-08-29 | US | West Virginia | Clay | 54015 | 2562 | 48 | 0 | 38.46231092 | -81.07652217 | 2022-08-30 04:21:03 | Clay, West Virginia, US | |
2022-08-25 | US | Montana | Dawson | 30021 | 2562 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-08-26 04:21:02 | Dawson, Montana, US | |
2022-08-24 | US | Montana | Dawson | 30021 | 2562 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-08-25 04:21:13 | Dawson, Montana, US | |
2022-08-23 | US | Montana | Dawson | 30021 | 2562 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-08-24 04:20:46 | Dawson, Montana, US | |
2022-08-22 | US | Montana | Dawson | 30021 | 2562 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-08-23 04:20:56 | Dawson, Montana, US | |
2022-08-21 | US | Montana | Dawson | 30021 | 2562 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-08-22 04:20:38 | Dawson, Montana, US | |
2022-08-20 | US | Montana | Dawson | 30021 | 2562 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-08-21 04:20:44 | Dawson, Montana, US | |
2022-08-19 | US | Montana | Dawson | 30021 | 2562 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-08-20 04:21:01 | Dawson, Montana, US | |
2022-08-16 | US | Texas | Runnels | 48399 | 2562 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-08-17 04:20:59 | Runnels, Texas, US | |
2022-08-02 | US | Illinois | Brown | 17009 | 2562 | 16 | 0 | 39.96209138 | -90.75068024 | 2022-08-03 04:20:59 | Brown, Illinois, US | |
2022-07-28 | US | Colorado | San Miguel | 8113 | 2562 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-07-29 04:20:45 | San Miguel, Colorado, US | |
2022-07-22 | US | Puerto Rico | Guanica | 72055 | 2562 | 0 | 0 | 17.982429 | -66.919643 | 2022-07-23 04:20:53 | Guanica, Puerto Rico, US | |
2022-06-30 | US | West Virginia | Ritchie | 54085 | 2562 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-07-01 04:21:10 | Ritchie, West Virginia, US | |
2022-06-30 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-07-01 04:21:10 | Liberty, Florida, US | |
2022-06-29 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-30 04:21:01 | Liberty, Florida, US | |
2022-06-28 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-29 04:20:59 | Liberty, Florida, US | |
2022-06-27 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-28 04:20:58 | Liberty, Florida, US | |
2022-06-26 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-27 04:21:00 | Liberty, Florida, US | |
2022-06-25 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-26 04:21:02 | Liberty, Florida, US | |
2022-06-24 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-25 04:20:57 | Liberty, Florida, US | |
2022-06-23 | US | Louisiana | East Carroll | 22035 | 2562 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-06-24 04:20:58 | East Carroll, Louisiana, US | |
2022-06-23 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-24 04:20:58 | Liberty, Florida, US | |
2022-06-22 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-23 04:20:55 | Liberty, Florida, US | |
2022-06-21 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-22 04:20:54 | Liberty, Florida, US | |
2022-06-20 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-21 04:20:56 | Liberty, Florida, US | |
2022-06-19 | US | Virginia | Falls Church | 51610 | 2562 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-06-20 04:21:01 | Falls Church, Virginia, US | |
2022-06-19 | US | Kentucky | Livingston | 21139 | 2562 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-20 04:21:01 | Livingston, Kentucky, US | |
2022-06-19 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-20 04:21:01 | Liberty, Florida, US | |
2022-06-18 | US | Virginia | Falls Church | 51610 | 2562 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-06-19 04:20:51 | Falls Church, Virginia, US | |
2022-06-18 | US | Kentucky | Livingston | 21139 | 2562 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-19 04:20:51 | Livingston, Kentucky, US | |
2022-06-18 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-19 04:20:51 | Liberty, Florida, US | |
2022-06-18 | US | Arkansas | Perry | 5105 | 2562 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-06-19 04:20:51 | Perry, Arkansas, US | |
2022-06-17 | US | Virginia | Falls Church | 51610 | 2562 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-06-18 04:21:10 | Falls Church, Virginia, US | |
2022-06-17 | US | Kentucky | Livingston | 21139 | 2562 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-18 04:21:10 | Livingston, Kentucky, US | |
2022-06-17 | US | Florida | Liberty | 12077 | 2562 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-06-18 04:21:10 | Liberty, Florida, US | |
2022-06-16 | US | Kentucky | Livingston | 21139 | 2562 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-17 04:20:56 | Livingston, Kentucky, US | |
2022-06-15 | US | Kentucky | Livingston | 21139 | 2562 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-16 04:20:55 | Livingston, Kentucky, US | |
2022-06-14 | US | Kentucky | Livingston | 21139 | 2562 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-15 04:20:54 | Livingston, Kentucky, US | |
2022-06-13 | US | Kentucky | Livingston | 21139 | 2562 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-14 04:20:52 | Livingston, Kentucky, US | |
2022-05-10 | US | Texas | Blanco | 48031 | 2562 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-05-11 04:20:48 | Blanco, Texas, US | |
2022-05-03 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-05-04 04:20:59 | Mercer, North Dakota, US | |
2022-05-02 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-05-03 04:21:00 | Mercer, North Dakota, US | |
2022-05-01 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-05-02 04:21:10 | Mercer, North Dakota, US | |
2022-04-30 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-05-01 04:20:57 | Mercer, North Dakota, US | |
2022-04-29 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-04-30 04:21:05 | Mercer, North Dakota, US | |
2022-04-28 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-04-29 04:20:59 | Mercer, North Dakota, US | |
2022-04-27 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-04-28 04:20:47 | Mercer, North Dakota, US | |
2022-04-26 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-04-27 04:20:52 | Mercer, North Dakota, US | |
2022-04-25 | US | North Dakota | Mercer | 38057 | 2562 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-04-26 04:20:51 | Mercer, North Dakota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;