daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
175 rows where confirmed = 5000 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-21 | US | Wisconsin | Burnett | 55013 | 5000 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-12-22 04:20:56 | Burnett, Wisconsin, US | |
2022-12-16 | US | Puerto Rico | Ciales | 72039 | 5000 | 0 | 0 | 18.28885 | -66.516475 | 2022-12-17 04:21:04 | Ciales, Puerto Rico, US | |
2022-11-21 | US | Tennessee | Cannon | 47015 | 5000 | 75 | 0 | 35.80990797 | -86.05738983 | 2022-11-22 04:20:47 | Cannon, Tennessee, US | |
2022-11-06 | US | Illinois | Bond | 17005 | 5000 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-11-07 04:21:26 | Bond, Illinois, US | |
2022-11-05 | US | Illinois | Bond | 17005 | 5000 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-11-06 04:21:24 | Bond, Illinois, US | |
2022-11-04 | US | Illinois | Bond | 17005 | 5000 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-11-05 04:21:52 | Bond, Illinois, US | |
2022-10-17 | US | Arkansas | Grant | 5053 | 5000 | 64 | 0 | 34.29017991 | -92.42320562 | 2022-10-18 04:22:42 | Grant, Arkansas, US | |
2022-10-16 | US | Arkansas | Grant | 5053 | 5000 | 64 | 0 | 34.29017991 | -92.42320562 | 2022-10-17 04:20:31 | Grant, Arkansas, US | |
2022-10-15 | US | Arkansas | Grant | 5053 | 5000 | 64 | 0 | 34.29017991 | -92.42320562 | 2022-10-16 04:22:39 | Grant, Arkansas, US | |
2022-09-18 | US | Kentucky | Union | 21225 | 5000 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-19 04:21:49 | Union, Kentucky, US | |
2022-09-17 | US | Kentucky | Union | 21225 | 5000 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-18 04:22:50 | Union, Kentucky, US | |
2022-09-16 | US | Kentucky | Union | 21225 | 5000 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-17 04:20:19 | Union, Kentucky, US | |
2022-09-15 | US | Kentucky | Union | 21225 | 5000 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-16 04:21:19 | Union, Kentucky, US | |
2022-09-14 | US | Kentucky | Union | 21225 | 5000 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-15 04:21:02 | Union, Kentucky, US | |
2022-09-13 | US | Virginia | Goochland | 51075 | 5000 | 58 | 0 | 37.71714806 | -77.90381514 | 2022-09-14 04:20:44 | Goochland, Virginia, US | |
2022-09-13 | US | Kentucky | Union | 21225 | 5000 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-14 04:20:44 | Union, Kentucky, US | |
2022-09-13 | US | Georgia | Putnam | 13237 | 5000 | 109 | 0 | 33.32056115 | -83.37552891 | 2022-09-14 04:20:44 | Putnam, Georgia, US | |
2022-09-12 | US | Kentucky | Union | 21225 | 5000 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-13 04:20:57 | Union, Kentucky, US | |
2022-09-12 | US | Georgia | Putnam | 13237 | 5000 | 109 | 0 | 33.32056115 | -83.37552891 | 2022-09-13 04:20:57 | Putnam, Georgia, US | |
2022-09-11 | US | Georgia | Putnam | 13237 | 5000 | 109 | 0 | 33.32056115 | -83.37552891 | 2022-09-12 04:20:58 | Putnam, Georgia, US | |
2022-09-10 | US | Georgia | Putnam | 13237 | 5000 | 109 | 0 | 33.32056115 | -83.37552891 | 2022-09-11 04:20:50 | Putnam, Georgia, US | |
2022-09-09 | US | Georgia | Putnam | 13237 | 5000 | 109 | 0 | 33.32056115 | -83.37552891 | 2022-09-10 04:21:10 | Putnam, Georgia, US | |
2022-09-08 | US | Georgia | Putnam | 13237 | 5000 | 109 | 0 | 33.32056115 | -83.37552891 | 2022-09-09 04:21:11 | Putnam, Georgia, US | |
2022-09-07 | US | Georgia | Putnam | 13237 | 5000 | 109 | 0 | 33.32056115 | -83.37552891 | 2022-09-08 04:21:02 | Putnam, Georgia, US | |
2022-08-25 | US | Maine | Washington | 23029 | 5000 | 60 | 0 | 45.01607142 | -67.62813524 | 2022-08-26 04:21:02 | Washington, Maine, US | |
2022-08-23 | US | Texas | Montague | 48337 | 5000 | 130 | 0 | 33.67521893 | -97.72500958 | 2022-08-24 04:20:46 | Montague, Texas, US | |
2022-08-20 | US | Puerto Rico | Comerio | 72045 | 5000 | 0 | 0 | 18.224687 | -66.221622 | 2022-08-21 04:20:44 | Comerio, Puerto Rico, US | |
2022-08-15 | US | Tennessee | Benton | 47005 | 5000 | 97 | 0 | 36.07110411 | -88.06849355 | 2022-08-16 04:20:58 | Benton, Tennessee, US | |
2022-08-08 | US | Virginia | Bristol | 51520 | 5000 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-08-09 04:20:34 | Bristol, Virginia, US | |
2022-08-02 | US | Texas | Panola | 48365 | 5000 | 131 | 0 | 32.1639596 | -94.30552481 | 2022-08-03 04:20:59 | Panola, Texas, US | |
2022-06-30 | US | Arkansas | Cross | 5037 | 5000 | 87 | 0 | 35.29631396 | -90.77185818 | 2022-07-01 04:21:10 | Cross, Arkansas, US | |
2022-06-26 | US | Indiana | Fulton | 18049 | 5000 | 103 | 0 | 41.0469907 | -86.26252745 | 2022-06-27 04:21:00 | Fulton, Indiana, US | |
2022-06-25 | US | Indiana | Fulton | 18049 | 5000 | 103 | 0 | 41.0469907 | -86.26252745 | 2022-06-26 04:21:02 | Fulton, Indiana, US | |
2022-06-24 | US | Indiana | Fulton | 18049 | 5000 | 103 | 0 | 41.0469907 | -86.26252745 | 2022-06-25 04:20:57 | Fulton, Indiana, US | |
2022-06-21 | US | Puerto Rico | Barceloneta | 72017 | 5000 | 0 | 0 | 18.445533 | -66.560531 | 2022-06-22 04:20:54 | Barceloneta, Puerto Rico, US | |
2022-06-20 | US | Wisconsin | Taylor | 55119 | 5000 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-06-21 04:20:56 | Taylor, Wisconsin, US | |
2022-06-11 | US | Texas | Milam | 48331 | 5000 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-06-12 04:20:53 | Milam, Texas, US | |
2022-06-10 | US | Texas | Milam | 48331 | 5000 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-06-11 04:21:01 | Milam, Texas, US | |
2022-06-02 | US | Texas | Scurry | 48415 | 5000 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-06-03 04:20:58 | Scurry, Texas, US | |
2022-06-01 | US | Minnesota | Fillmore | 27045 | 5000 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-06-02 05:20:39 | Fillmore, Minnesota, US | |
2022-05-26 | US | West Virginia | Barbour | 54001 | 5000 | 73 | 0 | 39.1307219 | -80.00350858 | 2022-05-27 04:20:56 | Barbour, West Virginia, US | |
2022-05-21 | US | Virginia | Colonial Heights | 51570 | 5000 | 97 | 0 | 37.26420587 | -77.39609676 | 2022-05-22 04:20:52 | Colonial Heights, Virginia, US | |
2022-05-20 | US | Virginia | Colonial Heights | 51570 | 5000 | 97 | 0 | 37.26420587 | -77.39609676 | 2022-05-21 04:20:58 | Colonial Heights, Virginia, US | |
2022-04-26 | US | North Carolina | Currituck | 37053 | 5000 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-27 04:20:52 | Currituck, North Carolina, US | |
2022-04-25 | US | North Carolina | Currituck | 37053 | 5000 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-26 04:20:51 | Currituck, North Carolina, US | |
2022-04-24 | US | North Carolina | Currituck | 37053 | 5000 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-25 04:20:56 | Currituck, North Carolina, US | |
2022-04-23 | US | North Carolina | Currituck | 37053 | 5000 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-24 04:20:56 | Currituck, North Carolina, US | |
2022-04-22 | US | North Carolina | Currituck | 37053 | 5000 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-23 04:20:50 | Currituck, North Carolina, US | |
2022-04-21 | US | North Carolina | Currituck | 37053 | 5000 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-22 04:20:45 | Currituck, North Carolina, US | |
2022-04-20 | US | North Carolina | Currituck | 37053 | 5000 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-21 04:20:46 | Currituck, North Carolina, US | |
2022-04-19 | US | New Mexico | Roosevelt | 35041 | 5000 | 92 | 0 | 34.02097406 | -103.4799493 | 2022-04-20 04:20:45 | Roosevelt, New Mexico, US | |
2022-04-18 | US | New Mexico | Roosevelt | 35041 | 5000 | 92 | 0 | 34.02097406 | -103.4799493 | 2022-04-19 04:21:00 | Roosevelt, New Mexico, US | |
2022-04-06 | US | Virginia | King George | 51099 | 5000 | 38 | 0 | 38.26818502 | -77.15852768 | 2022-04-07 04:20:53 | King George, Virginia, US | |
2022-03-22 | US | Texas | Burleson | 48051 | 5000 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-03-23 04:20:48 | Burleson, Texas, US | |
2022-03-21 | US | Texas | Burleson | 48051 | 5000 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-03-22 04:20:54 | Burleson, Texas, US | |
2022-03-20 | US | Texas | Burleson | 48051 | 5000 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-03-21 04:20:50 | Burleson, Texas, US | |
2022-03-19 | US | Texas | Burleson | 48051 | 5000 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-03-20 04:20:45 | Burleson, Texas, US | |
2022-03-18 | US | Texas | Burleson | 48051 | 5000 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-03-19 04:20:47 | Burleson, Texas, US | |
2022-03-17 | US | Texas | Burleson | 48051 | 5000 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-03-18 04:20:55 | Burleson, Texas, US | |
2022-03-16 | US | Texas | Burleson | 48051 | 5000 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-03-17 04:20:56 | Burleson, Texas, US | |
2022-03-15 | US | Texas | Burleson | 48051 | 5000 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-03-16 04:20:50 | Burleson, Texas, US | |
2022-03-07 | US | Oregon | Union | 41061 | 5000 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-08 04:20:54 | Union, Oregon, US | |
2022-03-03 | US | Oregon | Union | 41061 | 5000 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-04 04:21:09 | Union, Oregon, US | |
2022-02-27 | US | Georgia | McDuffie | 13189 | 5000 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-02-28 04:21:05 | McDuffie, Georgia, US | |
2022-02-26 | US | Georgia | McDuffie | 13189 | 5000 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-02-27 04:21:04 | McDuffie, Georgia, US | |
2022-02-25 | US | Georgia | McDuffie | 13189 | 5000 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-02-26 04:21:12 | McDuffie, Georgia, US | |
2022-02-24 | US | Georgia | McDuffie | 13189 | 5000 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-02-25 04:21:11 | McDuffie, Georgia, US | |
2022-02-23 | US | Georgia | McDuffie | 13189 | 5000 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-02-24 04:21:14 | McDuffie, Georgia, US | |
2022-02-11 | US | West Virginia | McDowell | 54047 | 5000 | 60 | 0 | 37.38002939 | -81.65083669 | 2022-02-12 04:21:06 | McDowell, West Virginia, US | |
2022-02-02 | US | Ohio | Holmes | 39075 | 5000 | 180 | 0 | 40.56163713 | -81.92635677 | 2022-02-03 04:21:21 | Holmes, Ohio, US | |
2022-01-31 | US | Mississippi | Stone | 28131 | 5000 | 67 | 0 | 30.79187949 | -89.11547539 | 2022-02-01 04:21:11 | Stone, Mississippi, US | |
2022-01-31 | US | Georgia | Dodge | 13091 | 5000 | 138 | 0 | 32.17265114 | -83.16948926 | 2022-02-01 04:21:11 | Dodge, Georgia, US | |
2022-01-18 | US | Maryland | Garrett | 24023 | 5000 | 103 | 0 | 39.52786077 | -79.27355126 | 2022-01-19 04:21:23 | Garrett, Maryland, US | |
2022-01-17 | US | North Carolina | Anson | 37007 | 5000 | 86 | 0 | 34.97403241 | -80.09953279 | 2022-01-18 04:21:04 | Anson, North Carolina, US | |
2022-01-16 | US | North Carolina | Anson | 37007 | 5000 | 86 | 0 | 34.97403241 | -80.09953279 | 2022-01-17 04:21:08 | Anson, North Carolina, US | |
2022-01-15 | US | North Carolina | Anson | 37007 | 5000 | 86 | 0 | 34.97403241 | -80.09953279 | 2022-01-16 04:21:12 | Anson, North Carolina, US | |
2022-01-14 | US | North Carolina | Anson | 37007 | 5000 | 86 | 0 | 34.97403241 | -80.09953279 | 2022-01-15 04:21:07 | Anson, North Carolina, US | |
2022-01-09 | US | South Carolina | Edgefield | 45037 | 5000 | 60 | 0 | 33.77221995 | -81.96231108 | 2022-01-10 04:22:07 | Edgefield, South Carolina, US | |
2022-01-08 | US | South Carolina | Edgefield | 45037 | 5000 | 60 | 0 | 33.77221995 | -81.96231108 | 2022-01-09 04:21:46 | Edgefield, South Carolina, US | |
2022-01-07 | US | South Carolina | Edgefield | 45037 | 5000 | 60 | 0 | 33.77221995 | -81.96231108 | 2022-01-08 04:21:53 | Edgefield, South Carolina, US | |
2022-01-04 | US | Kansas | Franklin | 20059 | 5000 | 66 | 0 | 38.56443815 | -95.28644341 | 2022-01-05 04:21:59 | Franklin, Kansas, US | |
2022-01-03 | US | Kansas | Franklin | 20059 | 5000 | 66 | 0 | 38.56443815 | -95.28644341 | 2022-01-04 04:22:17 | Franklin, Kansas, US | |
2022-01-02 | US | Mississippi | Tate | 28137 | 5000 | 120 | 0 | 34.65133709 | -89.94485778 | 2022-01-03 02:22:25 | Tate, Mississippi, US | |
2022-01-01 | US | Mississippi | Tate | 28137 | 5000 | 120 | 0 | 34.65133709 | -89.94485778 | 2022-01-02 04:20:52 | Tate, Mississippi, US | |
2021-12-31 | US | Mississippi | Tate | 28137 | 5000 | 120 | 0 | 34.65133709 | -89.94485778 | 2022-01-01 04:22:14 | Tate, Mississippi, US | |
2021-12-30 | US | Mississippi | Tate | 28137 | 5000 | 120 | 0 | 34.65133709 | -89.94485778 | 2021-12-31 04:21:50 | Tate, Mississippi, US | |
2021-12-26 | US | Michigan | Wexford | 26165 | 5000 | 84 | 0 | 44.33853602 | -85.57712739 | 2021-12-27 04:21:58 | Wexford, Michigan, US | |
2021-12-26 | US | Michigan | Chippewa | 26033 | 5000 | 64 | 0 | 46.29552653 | -84.54353449 | 2021-12-27 04:21:58 | Chippewa, Michigan, US | |
2021-12-26 | US | Arkansas | St. Francis | 5123 | 5000 | 72 | 0 | 35.02201976 | -90.74828138 | 2021-12-27 04:21:58 | St. Francis, Arkansas, US | |
2021-12-25 | US | Michigan | Wexford | 26165 | 5000 | 84 | 0 | 44.33853602 | -85.57712739 | 2021-12-26 04:21:50 | Wexford, Michigan, US | |
2021-12-25 | US | Michigan | Chippewa | 26033 | 5000 | 64 | 0 | 46.29552653 | -84.54353449 | 2021-12-26 04:21:50 | Chippewa, Michigan, US | |
2021-12-24 | US | Michigan | Wexford | 26165 | 5000 | 84 | 0 | 44.33853602 | -85.57712739 | 2021-12-25 04:21:37 | Wexford, Michigan, US | |
2021-12-24 | US | Michigan | Chippewa | 26033 | 5000 | 64 | 0 | 46.29552653 | -84.54353449 | 2021-12-25 04:21:37 | Chippewa, Michigan, US | |
2021-12-23 | US | Michigan | Wexford | 26165 | 5000 | 84 | 0 | 44.33853602 | -85.57712739 | 2021-12-24 04:21:34 | Wexford, Michigan, US | |
2021-12-23 | US | Michigan | Chippewa | 26033 | 5000 | 64 | 0 | 46.29552653 | -84.54353449 | 2021-12-24 04:21:34 | Chippewa, Michigan, US | |
2021-12-22 | US | Michigan | Wexford | 26165 | 5000 | 84 | 0 | 44.33853602 | -85.57712739 | 2021-12-23 04:21:21 | Wexford, Michigan, US | |
2021-12-22 | US | Michigan | Chippewa | 26033 | 5000 | 64 | 0 | 46.29552653 | -84.54353449 | 2021-12-23 04:21:21 | Chippewa, Michigan, US | |
2021-12-12 | US | Kansas | Ellis | 20051 | 5000 | 76 | 0 | 38.91458712 | -99.31751551 | 2021-12-13 04:22:02 | Ellis, Kansas, US | |
2021-12-11 | US | Kansas | Ellis | 20051 | 5000 | 76 | 0 | 38.91458712 | -99.31751551 | 2021-12-12 04:22:12 | Ellis, Kansas, US | |
2021-12-10 | US | Kansas | Ellis | 20051 | 5000 | 76 | 0 | 38.91458712 | -99.31751551 | 2021-12-11 04:22:45 | Ellis, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;