daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
147 rows where confirmed = 4889 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-18 | US | Illinois | Warren | 17187 | 4889 | 87 | 0 | 40.84925021 | -90.6147432 | 2022-12-19 04:21:03 | Warren, Illinois, US | |
2022-12-17 | US | Illinois | Warren | 17187 | 4889 | 87 | 0 | 40.84925021 | -90.6147432 | 2022-12-18 04:21:03 | Warren, Illinois, US | |
2022-12-16 | US | Illinois | Warren | 17187 | 4889 | 87 | 0 | 40.84925021 | -90.6147432 | 2022-12-17 04:21:04 | Warren, Illinois, US | |
2022-12-14 | US | West Virginia | Braxton | 54007 | 4889 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-15 04:20:58 | Braxton, West Virginia, US | |
2022-12-01 | US | Illinois | Carroll | 17015 | 4889 | 53 | 0 | 42.06823429 | -89.93395545 | 2022-12-02 04:21:07 | Carroll, Illinois, US | |
2022-11-28 | US | Michigan | Ogemaw | 26129 | 4889 | 115 | 0 | 44.33481032 | -84.12725175 | 2022-11-29 04:21:05 | Ogemaw, Michigan, US | |
2022-11-27 | US | Michigan | Ogemaw | 26129 | 4889 | 115 | 0 | 44.33481032 | -84.12725175 | 2022-11-28 04:21:02 | Ogemaw, Michigan, US | |
2022-11-26 | US | Michigan | Ogemaw | 26129 | 4889 | 115 | 0 | 44.33481032 | -84.12725175 | 2022-11-27 04:21:05 | Ogemaw, Michigan, US | |
2022-11-25 | US | Michigan | Ogemaw | 26129 | 4889 | 115 | 0 | 44.33481032 | -84.12725175 | 2022-11-26 04:21:11 | Ogemaw, Michigan, US | |
2022-11-24 | US | Michigan | Ogemaw | 26129 | 4889 | 115 | 0 | 44.33481032 | -84.12725175 | 2022-11-25 04:21:06 | Ogemaw, Michigan, US | |
2022-11-23 | US | Michigan | Ogemaw | 26129 | 4889 | 115 | 0 | 44.33481032 | -84.12725175 | 2022-11-24 04:21:09 | Ogemaw, Michigan, US | |
2022-11-22 | US | Michigan | Ogemaw | 26129 | 4889 | 115 | 0 | 44.33481032 | -84.12725175 | 2022-11-23 04:21:06 | Ogemaw, Michigan, US | |
2022-09-22 | US | Tennessee | Cannon | 47015 | 4889 | 70 | 0 | 35.80990797 | -86.05738983 | 2022-09-23 04:23:13 | Cannon, Tennessee, US | |
2022-09-08 | US | Texas | Lee | 48287 | 4889 | 62 | 0 | 30.31120597 | -96.97045773 | 2022-09-09 04:21:11 | Lee, Texas, US | |
2022-08-29 | US | Arkansas | Grant | 5053 | 4889 | 61 | 0 | 34.29017991 | -92.42320562 | 2022-08-30 04:21:03 | Grant, Arkansas, US | |
2022-08-28 | US | Arkansas | Grant | 5053 | 4889 | 61 | 0 | 34.29017991 | -92.42320562 | 2022-08-29 04:21:06 | Grant, Arkansas, US | |
2022-08-08 | US | Illinois | Ford | 17053 | 4889 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-08-09 04:20:34 | Ford, Illinois, US | |
2022-07-30 | US | Tennessee | Bledsoe | 47007 | 4889 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-07-31 04:21:02 | Bledsoe, Tennessee, US | |
2022-07-29 | US | Tennessee | Bledsoe | 47007 | 4889 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-07-30 04:20:42 | Bledsoe, Tennessee, US | |
2022-07-20 | US | Texas | Reeves | 48389 | 4889 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-07-21 04:21:10 | Reeves, Texas, US | |
2022-07-20 | US | Texas | Panola | 48365 | 4889 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-07-21 04:21:10 | Panola, Texas, US | |
2022-07-11 | US | Texas | Gonzales | 48177 | 4889 | 100 | 0 | 29.45634206 | -97.49424032 | 2022-07-12 04:20:51 | Gonzales, Texas, US | |
2022-07-04 | US | Michigan | Roscommon | 26143 | 4889 | 119 | 0 | 44.33473082 | -84.61067651 | 2022-07-05 04:20:45 | Roscommon, Michigan, US | |
2022-07-03 | US | Michigan | Roscommon | 26143 | 4889 | 119 | 0 | 44.33473082 | -84.61067651 | 2022-07-04 04:20:54 | Roscommon, Michigan, US | |
2022-07-02 | US | Michigan | Roscommon | 26143 | 4889 | 119 | 0 | 44.33473082 | -84.61067651 | 2022-07-03 04:20:59 | Roscommon, Michigan, US | |
2022-07-01 | US | Michigan | Roscommon | 26143 | 4889 | 119 | 0 | 44.33473082 | -84.61067651 | 2022-07-02 04:21:16 | Roscommon, Michigan, US | |
2022-06-30 | US | Michigan | Roscommon | 26143 | 4889 | 119 | 0 | 44.33473082 | -84.61067651 | 2022-07-01 04:21:10 | Roscommon, Michigan, US | |
2022-06-29 | US | Pennsylvania | Montour | 42093 | 4889 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-06-30 04:21:01 | Montour, Pennsylvania, US | |
2022-06-29 | US | Michigan | Roscommon | 26143 | 4889 | 119 | 0 | 44.33473082 | -84.61067651 | 2022-06-30 04:21:01 | Roscommon, Michigan, US | |
2022-06-28 | US | Pennsylvania | Montour | 42093 | 4889 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-06-29 04:20:59 | Montour, Pennsylvania, US | |
2022-06-28 | US | Michigan | Roscommon | 26143 | 4889 | 119 | 0 | 44.33473082 | -84.61067651 | 2022-06-29 04:20:59 | Roscommon, Michigan, US | |
2022-06-27 | US | Pennsylvania | Montour | 42093 | 4889 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-06-28 04:20:58 | Montour, Pennsylvania, US | |
2022-06-26 | US | Pennsylvania | Montour | 42093 | 4889 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-06-27 04:21:00 | Montour, Pennsylvania, US | |
2022-06-25 | US | Pennsylvania | Montour | 42093 | 4889 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-06-26 04:21:02 | Montour, Pennsylvania, US | |
2022-06-24 | US | Pennsylvania | Montour | 42093 | 4889 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-06-25 04:20:57 | Montour, Pennsylvania, US | |
2022-06-23 | US | Pennsylvania | Montour | 42093 | 4889 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-06-24 04:20:58 | Montour, Pennsylvania, US | |
2022-06-22 | US | Pennsylvania | Montour | 42093 | 4889 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-06-23 04:20:55 | Montour, Pennsylvania, US | |
2022-06-08 | US | Arkansas | Cross | 5037 | 4889 | 85 | 0 | 35.29631396 | -90.77185818 | 2022-06-09 04:20:54 | Cross, Arkansas, US | |
2022-04-28 | US | Puerto Rico | Morovis | 72101 | 4889 | 0 | 0 | 18.316963 | -66.420383 | 2022-04-29 04:20:59 | Morovis, Puerto Rico, US | |
2022-04-26 | US | Virginia | Colonial Heights | 51570 | 4889 | 97 | 0 | 37.26420587 | -77.39609676 | 2022-04-27 04:20:52 | Colonial Heights, Virginia, US | |
2022-04-13 | US | Vermont | Orange | 50017 | 4889 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-04-13 23:21:06 | Orange, Vermont, US | |
2022-03-27 | US | Vermont | Orange | 50017 | 4889 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-03-28 04:20:33 | Orange, Vermont, US | |
2022-03-26 | US | Vermont | Orange | 50017 | 4889 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-03-27 04:20:47 | Orange, Vermont, US | |
2022-03-25 | US | Vermont | Orange | 50017 | 4889 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-03-26 04:20:23 | Orange, Vermont, US | |
2022-03-22 | US | Michigan | Charlevoix | 26029 | 4889 | 60 | 0 | 45.37790017 | -85.19614053 | 2022-03-23 04:20:48 | Charlevoix, Michigan, US | |
2022-03-21 | US | Michigan | Charlevoix | 26029 | 4889 | 60 | 0 | 45.37790017 | -85.19614053 | 2022-03-22 04:20:54 | Charlevoix, Michigan, US | |
2022-02-25 | US | New York | Schoharie | 36095 | 4889 | 34 | 0 | 42.58831742 | -74.44339029999998 | 2022-02-26 04:21:12 | Schoharie, New York, US | |
2022-02-24 | US | Texas | Milam | 48331 | 4889 | 98 | 0 | 30.78581830000001 | -96.97718698 | 2022-02-25 04:21:11 | Milam, Texas, US | |
2022-02-23 | US | Arkansas | Lincoln | 5079 | 4889 | 63 | 0 | 33.95317155 | -91.74002806 | 2022-02-24 04:21:14 | Lincoln, Arkansas, US | |
2022-02-15 | US | Puerto Rico | San Lorenzo | 72129 | 4889 | 0 | 0 | 18.147987 | -65.976392 | 2022-02-16 04:21:10 | San Lorenzo, Puerto Rico, US | |
2022-02-14 | US | Puerto Rico | San Lorenzo | 72129 | 4889 | 0 | 0 | 18.147987 | -65.976392 | 2022-02-15 04:21:09 | San Lorenzo, Puerto Rico, US | |
2022-02-13 | US | Puerto Rico | San Lorenzo | 72129 | 4889 | 0 | 0 | 18.147987 | -65.976392 | 2022-02-14 04:20:51 | San Lorenzo, Puerto Rico, US | |
2022-02-09 | US | Georgia | Tattnall | 13267 | 4889 | 123 | 0 | 32.04785085 | -82.05539188 | 2022-02-10 04:21:14 | Tattnall, Georgia, US | |
2022-02-08 | US | Colorado | Teller | 8119 | 4889 | 57 | 0 | 38.88133511 | -105.16148929999999 | 2022-02-09 04:21:04 | Teller, Colorado, US | |
2022-02-07 | US | Tennessee | Crockett | 47033 | 4889 | 76 | 0 | 35.81830662 | -89.14916269 | 2022-02-08 04:21:15 | Crockett, Tennessee, US | |
2022-02-07 | US | South Carolina | Hampton | 45049 | 4889 | 78 | 0 | 32.77419582 | -81.13845571 | 2022-02-08 04:21:15 | Hampton, South Carolina, US | |
2022-02-01 | US | Idaho | Blaine | 16013 | 4889 | 28 | 0 | 43.4085812 | -113.9752658 | 2022-02-02 04:21:09 | Blaine, Idaho, US | |
2022-01-25 | US | Ohio | Holmes | 39075 | 4889 | 175 | 0 | 40.56163713 | -81.92635677 | 2022-01-26 04:21:07 | Holmes, Ohio, US | |
2022-01-24 | US | Puerto Rico | Cidra | 72041 | 4889 | 0 | 0 | 18.173559 | -66.161179 | 2022-01-25 04:21:05 | Cidra, Puerto Rico, US | |
2022-01-24 | US | New York | Essex | 36031 | 4889 | 52 | 0 | 44.11630765 | -73.77297842 | 2022-01-25 04:21:05 | Essex, New York, US | |
2022-01-21 | US | Vermont | Windham | 50025 | 4889 | 32 | 0 | 42.986982 | -72.71268875 | 2022-01-22 04:21:13 | Windham, Vermont, US | |
2022-01-19 | US | Mississippi | Tishomingo | 28141 | 4889 | 99 | 0 | 34.74023475 | -88.23917219 | 2022-01-20 04:21:07 | Tishomingo, Mississippi, US | |
2022-01-10 | US | Mississippi | Marion | 28091 | 4889 | 117 | 0 | 31.23132643 | -89.8209217 | 2022-01-11 04:22:01 | Marion, Mississippi, US | |
2022-01-10 | US | Kentucky | Lincoln | 21137 | 4889 | 108 | 0 | 37.45475628 | -84.6565327 | 2022-01-11 04:22:01 | Lincoln, Kentucky, US | |
2022-01-09 | US | Mississippi | Marion | 28091 | 4889 | 117 | 0 | 31.23132643 | -89.8209217 | 2022-01-10 04:22:07 | Marion, Mississippi, US | |
2022-01-08 | US | Mississippi | Marion | 28091 | 4889 | 117 | 0 | 31.23132643 | -89.8209217 | 2022-01-09 04:21:46 | Marion, Mississippi, US | |
2022-01-07 | US | Mississippi | Marion | 28091 | 4889 | 117 | 0 | 31.23132643 | -89.8209217 | 2022-01-08 04:21:53 | Marion, Mississippi, US | |
2022-01-05 | US | South Carolina | Edgefield | 45037 | 4889 | 60 | 0 | 33.77221995 | -81.96231108 | 2022-01-06 04:22:09 | Edgefield, South Carolina, US | |
2021-12-28 | Monaco | 4889 | 38 | 0 | 43.7333 | 7.4167 | 2021-12-29 03:21:43 | Monaco | ||||
2021-12-27 | US | Alabama | Clarke | 1025 | 4889 | 87 | 0 | 31.68099859 | -87.83548597 | 2021-12-28 04:21:47 | Clarke, Alabama, US | |
2021-12-21 | US | Arkansas | Yell | 5149 | 4889 | 88 | 0 | 35.00292371 | -93.41171338 | 2021-12-22 04:21:54 | Yell, Arkansas, US | |
2021-12-11 | US | New York | Delaware | 36025 | 4889 | 55 | 0 | 42.19837623 | -74.96709306 | 2021-12-12 04:22:12 | Delaware, New York, US | |
2021-12-05 | US | South Carolina | Union | 45087 | 4889 | 112 | 0 | 34.68835752 | -81.61730349 | 2021-12-06 04:22:34 | Union, South Carolina, US | |
2021-12-04 | US | South Carolina | Union | 45087 | 4889 | 112 | 0 | 34.68835752 | -81.61730349 | 2021-12-05 04:22:25 | Union, South Carolina, US | |
2021-12-03 | US | South Carolina | Union | 45087 | 4889 | 112 | 0 | 34.68835752 | -81.61730349 | 2021-12-04 04:22:18 | Union, South Carolina, US | |
2021-12-01 | US | Georgia | Lumpkin | 13187 | 4889 | 109 | 0 | 34.57286511 | -84.00425681 | 2021-12-02 04:22:37 | Lumpkin, Georgia, US | |
2021-11-24 | US | Tennessee | Overton | 47133 | 4889 | 83 | 0 | 36.34117832 | -85.28989535 | 2021-11-25 04:22:33 | Overton, Tennessee, US | |
2021-10-21 | US | Puerto Rico | Ponce | 72113 | 4889 | 0 | 0 | 18.059498 | -66.613748 | 2021-10-22 04:21:14 | Ponce, Puerto Rico, US | |
2021-10-17 | US | Alabama | Dallas | 1047 | 4889 | 199 | 0 | 32.32688101 | -87.10866709999998 | 2021-10-18 04:21:10 | Dallas, Alabama, US | |
2021-10-14 | US | Pennsylvania | McKean | 42083 | 4889 | 82 | 0 | 41.80938602 | -78.56478358 | 2021-10-15 04:21:26 | McKean, Pennsylvania, US | |
2021-10-14 | US | Maryland | Worcester | 24047 | 4889 | 115 | 0 | 38.21274277 | -75.33200012 | 2021-10-15 04:21:26 | Worcester, Maryland, US | |
2021-10-12 | US | Mississippi | George | 28039 | 4889 | 79 | 0 | 30.86259065 | -88.64436789 | 2021-10-13 04:20:51 | George, Mississippi, US | |
2021-10-11 | US | Wyoming | Sheridan | 56033 | 4889 | 43 | 0 | 44.79048913 | -106.8862389 | 2021-10-12 04:21:09 | Sheridan, Wyoming, US | |
2021-10-11 | US | Illinois | Logan | 17107 | 4889 | 74 | 0 | 40.12581572 | -89.36638784 | 2021-10-12 04:21:09 | Logan, Illinois, US | |
2021-10-10 | US | Illinois | Logan | 17107 | 4889 | 74 | 0 | 40.12581572 | -89.36638784 | 2021-10-11 04:21:31 | Logan, Illinois, US | |
2021-10-09 | US | Illinois | Logan | 17107 | 4889 | 74 | 0 | 40.12581572 | -89.36638784 | 2021-10-10 04:21:38 | Logan, Illinois, US | |
2021-10-08 | US | Illinois | Logan | 17107 | 4889 | 74 | 0 | 40.12581572 | -89.36638784 | 2021-10-09 04:21:34 | Logan, Illinois, US | |
2021-10-04 | US | New Mexico | Unassigned | 90035 | 4889 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-05 04:21:27 | Unassigned, New Mexico, US | |
2021-09-26 | US | Illinois | Morgan | 17137 | 4889 | 96 | 0 | 39.71654544 | -90.20255104 | 2021-09-27 04:21:16 | Morgan, Illinois, US | |
2021-09-25 | US | Illinois | Morgan | 17137 | 4889 | 96 | 0 | 39.71654544 | -90.20255104 | 2021-09-26 04:21:29 | Morgan, Illinois, US | |
2021-09-24 | US | Illinois | Morgan | 17137 | 4889 | 96 | 0 | 39.71654544 | -90.20255104 | 2021-09-25 04:21:31 | Morgan, Illinois, US | |
2021-09-22 | US | Tennessee | Claiborne | 47025 | 4889 | 85 | 0 | 36.48319149 | -83.65947309 | 2021-09-23 04:21:43 | Claiborne, Tennessee, US | |
2021-09-20 | US | Texas | Howard | 48227 | 4889 | 112 | 0 | 32.30621324 | -101.4356444 | 2021-09-21 04:21:26 | Howard, Texas, US | |
2021-09-15 | US | Tennessee | Lauderdale | 47097 | 4889 | 55 | 0 | 35.75893438 | -89.63015909999999 | 2021-09-16 04:22:19 | Lauderdale, Tennessee, US | |
2021-09-12 | US | Missouri | Lawrence | 29109 | 4889 | 100 | 0 | 37.10626634 | -93.83293097 | 2021-09-13 04:21:15 | Lawrence, Missouri, US | |
2021-09-09 | Japan | Ehime | 4889 | 81 | 0 | 33.624835 | 132.856842 | 2021-09-10 04:21:20 | Ehime, Japan | |||
2021-08-28 | US | Tennessee | Weakley | 47183 | 4889 | 71 | 0 | 36.29896232 | -88.71990865 | 2021-08-29 04:21:14 | Weakley, Tennessee, US | |
2021-08-15 | US | Tennessee | Lincoln | 47103 | 4889 | 69 | 0 | 35.13738622 | -86.58910106 | 2021-08-16 04:21:31 | Lincoln, Tennessee, US | |
2021-08-07 | US | Tennessee | Cheatham | 47021 | 4889 | 56 | 0 | 36.26136216 | -87.08903581 | 2021-08-08 04:21:33 | Cheatham, Tennessee, US | |
2021-08-04 | US | Missouri | Webster | 29225 | 4889 | 67 | 0 | 37.2813734 | -92.876329 | 2021-08-05 04:21:51 | Webster, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;