daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
125 rows where active = 1658 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-31 | Colombia | Boyaca | 102622 | 2450 | 98514 | 1658 | 5.4545 | -73.362 | 2021-08-01 04:21:50 | Boyaca, Colombia | ||
2021-07-30 | Russia | Ryazan Oblast | 35043 | 793 | 32592 | 1658 | 54.42267320000001 | 40.57052460000001 | 2021-07-31 04:21:35 | Ryazan Oblast, Russia | ||
2021-07-06 | Romania | 1081030 | 34021 | 1045351 | 1658 | 45.9432 | 24.9668 | 2021-07-07 04:21:20 | Romania | |||
2021-06-22 | Canada | Quebec | 374528 | 11195 | 361675 | 1658 | 52.9399 | -73.5491 | 2021-06-23 04:21:46 | Quebec, Canada | ||
2021-06-14 | Chile | Coquimbo | 41547 | 750 | 39139 | 1658 | -29.959 | -71.3389 | 2021-06-15 04:22:22 | Coquimbo, Chile | ||
2021-06-13 | Chile | Coquimbo | 41278 | 748 | 38872 | 1658 | -29.959 | -71.3389 | 2021-06-14 04:22:46 | Coquimbo, Chile | ||
2021-04-02 | Japan | Hyogo | 20431 | 594 | 18179 | 1658 | 35.039913 | 134.828057 | 2021-04-03 04:20:44 | Hyogo, Japan | ||
2021-03-23 | Mongolia | 5392 | 5 | 3947 | 1658 | 46.8625 | 103.8467 | 2021-03-24 05:25:40 | Mongolia | |||
2021-03-09 | El Salvador | 61539 | 1923 | 57958 | 1658 | 13.7942 | -88.8965 | 2021-03-10 05:24:35 | El Salvador | |||
2021-03-06 | US | Illinois | Clark | 17023 | 1689 | 31 | 0 | 1658 | 39.33425789 | -87.78705622 | 2021-03-07 05:21:54 | Clark, Illinois, US |
2021-03-05 | US | Kentucky | Russell | 21207 | 1696 | 38 | 0 | 1658 | 36.99308373 | -85.06070117 | 2021-03-06 04:23:41 | Russell, Kentucky, US |
2021-03-04 | US | Iowa | Hardin | 19083 | 1697 | 39 | 0 | 1658 | 42.38353877 | -93.23654611 | 2021-03-05 05:26:29 | Hardin, Iowa, US |
2021-03-03 | US | Kentucky | Simpson | 21213 | 1688 | 30 | 0 | 1658 | 36.74058474 | -86.58047435 | 2021-03-04 05:24:24 | Simpson, Kentucky, US |
2021-03-02 | US | Pennsylvania | Susquehanna | 42115 | 1711 | 53 | 0 | 1658 | 41.82147784 | -75.80071959 | 2021-03-03 05:23:28 | Susquehanna, Pennsylvania, US |
2021-03-01 | US | Georgia | Greene | 13133 | 1710 | 52 | 0 | 1658 | 33.5769205 | -83.17139104 | 2021-03-02 05:23:30 | Greene, Georgia, US |
2021-02-22 | US | Florida | Union | 12125 | 1728 | 70 | 0 | 1658 | 30.04412971 | -82.37497443 | 2021-02-23 05:23:41 | Union, Florida, US |
2021-02-21 | US | Texas | Reeves | 48389 | 1383 | 38 | 0 | 1658 | 31.32323325 | -103.6903896 | 2021-02-22 05:24:21 | Reeves, Texas, US |
2021-02-21 | US | Florida | Union | 12125 | 1728 | 70 | 0 | 1658 | 30.04412971 | -82.37497443 | 2021-02-22 05:24:21 | Union, Florida, US |
2021-02-18 | US | Missouri | Cooper | 29053 | 1682 | 24 | 0 | 1658 | 38.844478 | -92.80896081 | 2021-02-19 05:24:16 | Cooper, Missouri, US |
2021-02-12 | US | Indiana | Perry | 18123 | 1693 | 35 | 0 | 1658 | 38.07809328 | -86.63741946 | 2021-02-13 05:22:12 | Perry, Indiana, US |
2021-02-12 | US | Georgia | Jeff Davis | 13161 | 1698 | 40 | 0 | 1658 | 31.80405727 | -82.63724870000001 | 2021-02-13 05:22:12 | Jeff Davis, Georgia, US |
2021-02-05 | US | Iowa | Buchanan | 19019 | 1684 | 26 | 0 | 1658 | 42.4709188 | -91.83510825 | 2021-02-06 05:23:55 | Buchanan, Iowa, US |
2021-02-04 | US | Iowa | Buchanan | 19019 | 1683 | 25 | 0 | 1658 | 42.4709188 | -91.83510825 | 2021-02-05 05:22:38 | Buchanan, Iowa, US |
2021-02-03 | US | Indiana | Fulton | 18049 | 1696 | 38 | 0 | 1658 | 41.0469907 | -86.26252745 | 2021-02-04 05:22:26 | Fulton, Indiana, US |
2021-02-02 | US | North Carolina | Ashe | 37009 | 1692 | 34 | 0 | 1658 | 36.43296207 | -81.49862729 | 2021-02-03 05:22:52 | Ashe, North Carolina, US |
2021-01-31 | US | Maryland | Talbot | 24041 | 1679 | 21 | 0 | 1658 | 38.76618159 | -76.10882561 | 2021-02-01 05:22:53 | Talbot, Maryland, US |
2021-01-29 | US | Virginia | Hopewell | 51670 | 1675 | 17 | 0 | 1658 | 37.29186313 | -77.29754684 | 2021-01-30 05:22:49 | Hopewell, Virginia, US |
2021-01-24 | US | Wisconsin | Crawford | 55023 | 1673 | 15 | 0 | 1658 | 43.23870316 | -90.93073686 | 2021-01-25 05:22:16 | Crawford, Wisconsin, US |
2021-01-23 | US | Wisconsin | Crawford | 55023 | 1673 | 15 | 0 | 1658 | 43.23870316 | -90.93073686 | 2021-01-24 05:22:35 | Crawford, Wisconsin, US |
2021-01-23 | US | Georgia | Mitchell | 13205 | 1725 | 67 | 0 | 1658 | 31.22483255 | -84.19381821 | 2021-01-24 05:22:35 | Mitchell, Georgia, US |
2021-01-22 | US | Wisconsin | Crawford | 55023 | 1672 | 14 | 0 | 1658 | 43.23870316 | -90.93073686 | 2021-01-23 05:22:03 | Crawford, Wisconsin, US |
2021-01-20 | US | Ohio | Adams | 39001 | 1695 | 37 | 0 | 1658 | 38.84541072 | -83.4718964 | 2021-01-21 05:22:01 | Adams, Ohio, US |
2021-01-16 | US | Georgia | Grady | 13131 | 1699 | 41 | 0 | 1658 | 30.87454847 | -84.23418364 | 2021-01-17 05:22:17 | Grady, Georgia, US |
2021-01-15 | US | Oregon | Josephine | 41033 | 1689 | 31 | 0 | 1658 | 42.3665549 | -123.5561938 | 2021-01-16 05:22:40 | Josephine, Oregon, US |
2021-01-13 | US | West Virginia | Mingo | 54059 | 1678 | 20 | 0 | 1658 | 37.73048351 | -82.13338365 | 2021-01-14 05:22:32 | Mingo, West Virginia, US |
2021-01-13 | Chile | Valparaiso | 38806 | 1294 | 35854 | 1658 | -33.0472 | -71.6127 | 2021-01-14 05:22:32 | Valparaiso, Chile | ||
2021-01-12 | US | North Carolina | Greene | 37079 | 1692 | 34 | 0 | 1658 | 35.48544173 | -77.67578087 | 2021-01-13 05:22:15 | Greene, North Carolina, US |
2021-01-09 | US | South Dakota | Union | 46127 | 1688 | 30 | 0 | 1658 | 42.83112163 | -96.6557828 | 2021-01-10 05:22:12 | Union, South Dakota, US |
2021-01-08 | US | Tennessee | Bledsoe | 47007 | 1709 | 10 | 0 | 1658 | 35.59942968 | -85.20611967 | 2021-01-09 05:22:18 | Bledsoe, Tennessee, US |
2021-01-08 | US | South Carolina | Union | 45087 | 1703 | 45 | 0 | 1658 | 34.68835752 | -81.61730349 | 2021-01-09 05:22:18 | Union, South Carolina, US |
2021-01-01 | US | Missouri | Warren | 29219 | 1667 | 9 | 0 | 1658 | 38.76529479 | -91.16124662 | 2021-01-02 05:22:33 | Warren, Missouri, US |
2021-01-01 | US | Florida | Holmes | 12059 | 1683 | 25 | 0 | 1658 | 30.86747479 | -85.81319222 | 2021-01-02 05:22:33 | Holmes, Florida, US |
2020-12-31 | US | Florida | Holmes | 12059 | 1683 | 25 | 0 | 1658 | 30.86747479 | -85.81319222 | 2021-01-01 05:23:07 | Holmes, Florida, US |
2020-12-27 | US | Illinois | Saline | 17165 | 1687 | 29 | 0 | 1658 | 37.75332999 | -88.54119706 | 2020-12-28 05:22:06 | Saline, Illinois, US |
2020-12-21 | US | Mississippi | Hancock | 28045 | 1708 | 50 | 0 | 1658 | 30.41830223 | -89.48851033 | 2020-12-22 05:22:33 | Hancock, Mississippi, US |
2020-12-20 | US | Texas | Matagorda | 48321 | 1699 | 64 | 0 | 1658 | 28.81955746 | -96.01230294 | 2020-12-21 05:27:58 | Matagorda, Texas, US |
2020-12-15 | US | Kentucky | Boyle | 21021 | 1658 | 0 | 0 | 1658 | 37.62680923 | -84.8633779 | 2020-12-16 05:28:04 | Boyle, Kentucky, US |
2020-12-11 | US | Ohio | Holmes | 39075 | 1722 | 64 | 0 | 1658 | 40.56163713 | -81.92635677 | 2020-12-12 05:26:19 | Holmes, Ohio, US |
2020-12-06 | US | West Virginia | Harrison | 54033 | 1682 | 24 | 0 | 1658 | 39.2853852 | -80.37919577 | 2020-12-07 05:26:14 | Harrison, West Virginia, US |
2020-12-06 | US | Tennessee | Henry | 47079 | 1683 | 23 | 0 | 1658 | 36.33160906 | -88.30121797 | 2020-12-07 05:26:14 | Henry, Tennessee, US |
2020-12-05 | US | Texas | Polk | 48373 | 1690 | 42 | 0 | 1658 | 30.79472531 | -94.8276624 | 2020-12-06 05:26:18 | Polk, Texas, US |
2020-12-05 | US | Ohio | Fulton | 39051 | 1691 | 33 | 0 | 1658 | 41.60213491 | -84.12571393 | 2020-12-06 05:26:18 | Fulton, Ohio, US |
2020-12-04 | US | Texas | Polk | 48373 | 1676 | 42 | 0 | 1658 | 30.79472531 | -94.8276624 | 2020-12-05 05:27:36 | Polk, Texas, US |
2020-12-03 | US | Virginia | Franklin | 51067 | 1675 | 17 | 0 | 1658 | 36.99536167 | -79.88023649 | 2020-12-04 05:27:27 | Franklin, Virginia, US |
2020-12-03 | US | Tennessee | Haywood | 47075 | 1677 | 30 | 0 | 1658 | 35.58332824 | -89.28536625 | 2020-12-04 05:27:27 | Haywood, Tennessee, US |
2020-12-01 | US | Indiana | Daviess | 18027 | 1703 | 45 | 0 | 1658 | 38.70186039 | -87.07185406 | 2020-12-02 05:27:41 | Daviess, Indiana, US |
2020-11-27 | US | Tennessee | Carroll | 47017 | 1702 | 34 | 0 | 1658 | 35.97366108 | -88.45189331 | 2020-11-28 05:25:50 | Carroll, Tennessee, US |
2020-11-27 | US | Pennsylvania | Huntingdon | 42061 | 1710 | 52 | 0 | 1658 | 40.42162652 | -77.97673273 | 2020-11-28 05:25:50 | Huntingdon, Pennsylvania, US |
2020-11-27 | US | North Carolina | Vance | 37181 | 1713 | 55 | 0 | 1658 | 36.36880673 | -78.40670845 | 2020-11-28 05:25:50 | Vance, North Carolina, US |
2020-11-25 | Colombia | Boyaca | 20563 | 430 | 18475 | 1658 | 5.4545 | -73.362 | 2020-11-26 05:27:44 | Boyaca, Colombia | ||
2020-11-24 | US | Michigan | Montcalm | 26117 | 1680 | 22 | 0 | 1658 | 43.31082541 | -85.15252824 | 2020-11-25 05:27:20 | Montcalm, Michigan, US |
2020-11-23 | US | Tennessee | White | 47185 | 1649 | 17 | 0 | 1658 | 35.92929884 | -85.45591799 | 2020-11-24 05:27:31 | White, Tennessee, US |
2020-11-21 | US | Montana | Silver Bow | 30093 | 1677 | 19 | 0 | 1658 | 45.90018933 | -112.6620092 | 2020-11-22 05:25:45 | Silver Bow, Montana, US |
2020-11-14 | US | California | El Dorado | 6017 | 1673 | 4 | 0 | 1658 | 38.77965956 | -120.5233166 | 2020-11-15 05:26:53 | El Dorado, California, US |
2020-11-11 | US | Virginia | Albemarle | 51003 | 1682 | 24 | 0 | 1658 | 38.02080697 | -78.55481085 | 2020-11-12 05:25:55 | Albemarle, Virginia, US |
2020-11-07 | US | Washington | Whatcom | 53073 | 1702 | 44 | 0 | 1658 | 48.82227976 | -121.7490018 | 2020-11-08 05:24:56 | Whatcom, Washington, US |
2020-11-06 | US | Tennessee | Weakley | 47183 | 1705 | 27 | 0 | 1658 | 36.29896232 | -88.71990865 | 2020-11-07 05:24:52 | Weakley, Tennessee, US |
2020-11-06 | US | Missouri | Scott | 29201 | 1688 | 30 | 0 | 1658 | 37.05588075 | -89.56474493 | 2020-11-07 05:24:52 | Scott, Missouri, US |
2020-11-04 | US | Ohio | Ross | 39141 | 1718 | 60 | 0 | 1658 | 39.33705391 | -83.06000914 | 2020-11-05 06:05:03 | Ross, Ohio, US |
2020-11-01 | Pakistan | Islamabad | 20089 | 222 | 18209 | 1658 | 33.665087 | 73.121219 | 2020-11-02 05:25:04 | Islamabad, Pakistan | ||
2020-10-29 | US | Ohio | Wayne | 39169 | 1722 | 64 | 0 | 1658 | 40.82925852 | -81.88844833 | 2020-10-30 04:24:49 | Wayne, Ohio, US |
2020-10-29 | Colombia | Risaralda | 16932 | 389 | 14885 | 1658 | 5.3158 | -75.9928 | 2020-10-30 04:24:49 | Risaralda, Colombia | ||
2020-10-28 | US | Oklahoma | Le Flore | 40079 | 1682 | 24 | 0 | 1658 | 34.89851864 | -94.70392124 | 2020-10-29 04:24:49 | Le Flore, Oklahoma, US |
2020-10-27 | US | Oklahoma | Le Flore | 40079 | 1680 | 22 | 0 | 1658 | 34.89851864 | -94.70392124 | 2020-10-28 04:24:39 | Le Flore, Oklahoma, US |
2020-10-25 | US | Missouri | Taney | 29213 | 1691 | 33 | 0 | 1658 | 36.65465345 | -93.04075153 | 2020-10-26 04:25:02 | Taney, Missouri, US |
2020-10-22 | US | Wisconsin | St. Croix | 55109 | 1667 | 9 | 0 | 1658 | 45.03437474 | -92.45000068 | 2020-10-23 04:24:46 | St. Croix, Wisconsin, US |
2020-10-22 | US | Texas | Bowie | 48037 | 1959 | 72 | 0 | 1658 | 33.44626922 | -94.41834132 | 2020-10-23 04:24:46 | Bowie, Texas, US |
2020-10-22 | US | Tennessee | Obion | 47131 | 1725 | 20 | 0 | 1658 | 36.35732446 | -89.14921589 | 2020-10-23 04:24:46 | Obion, Tennessee, US |
2020-10-22 | US | Georgia | Ware | 13299 | 1720 | 62 | 0 | 1658 | 31.05449097 | -82.42224148 | 2020-10-23 04:24:46 | Ware, Georgia, US |
2020-10-22 | US | Florida | Okeechobee | 12093 | 1695 | 37 | 0 | 1658 | 27.386336199999995 | -80.88944347 | 2020-10-23 04:24:46 | Okeechobee, Florida, US |
2020-10-21 | US | Texas | Bowie | 48037 | 1915 | 72 | 0 | 1658 | 33.44626922 | -94.41834132 | 2020-10-22 04:24:27 | Bowie, Texas, US |
2020-10-21 | US | Arkansas | St. Francis | 5123 | 1668 | 10 | 0 | 1658 | 35.02201976 | -90.74828138 | 2020-10-22 04:24:27 | St. Francis, Arkansas, US |
2020-10-20 | India | Nagaland | 8020 | 28 | 6334 | 1658 | 26.06702 | 94.470302 | 2020-10-21 04:24:14 | Nagaland, India | ||
2020-10-16 | US | California | Shasta | 6089 | 1678 | 20 | 0 | 1658 | 40.76391419 | -122.0396884 | 2020-10-17 04:24:12 | Shasta, California, US |
2020-10-16 | Russia | Omsk Oblast | 13037 | 358 | 11021 | 1658 | 56.09352629999999 | 73.5099936 | 2020-10-17 04:24:12 | Omsk Oblast, Russia | ||
2020-10-14 | US | Mississippi | Neshoba | 28099 | 1767 | 109 | 0 | 1658 | 32.75339664 | -89.11726492 | 2020-10-15 04:24:28 | Neshoba, Mississippi, US |
2020-10-14 | Chile | Biobio | 26089 | 388 | 24043 | 1658 | -37.4464 | -72.1416 | 2020-10-15 04:24:28 | Biobio, Chile | ||
2020-10-10 | US | Oklahoma | Texas | 40139 | 1668 | 10 | 0 | 1658 | 36.74777635 | -101.4889765 | 2020-10-11 04:23:46 | Texas, Oklahoma, US |
2020-10-06 | US | Massachusetts | Barnstable | 25001 | 1832 | 159 | 0 | 1658 | 41.72980578 | -70.28854339 | 2020-10-07 04:23:40 | Barnstable, Massachusetts, US |
2020-09-30 | US | Puerto Rico | Caguas | 72025 | 1658 | 0 | 0 | 1658 | 18.211615 | -66.050779 | 2020-10-01 04:23:42 | Caguas, Puerto Rico, US |
2020-09-15 | US | Connecticut | Litchfield | 9005 | 1798 | 140 | 0 | 1658 | 41.7937534 | -73.2451475 | 2020-09-16 04:22:53 | Litchfield, Connecticut, US |
2020-09-13 | US | Indiana | Delaware | 18035 | 1717 | 59 | 0 | 1658 | 40.22787247 | -85.39732772 | 2020-09-14 04:26:00 | Delaware, Indiana, US |
2020-09-10 | India | Arunachal Pradesh | 5672 | 9 | 4005 | 1658 | 27.768456 | 96.384277 | 2020-09-11 04:46:23 | Arunachal Pradesh, India | ||
2020-09-08 | US | North Carolina | Sampson | 37163 | 1679 | 21 | 0 | 1658 | 34.98820368 | -78.36914061 | 2020-09-09 04:28:48 | Sampson, North Carolina, US |
2020-09-07 | US | North Carolina | Cleveland | 37045 | 1704 | 46 | 0 | 1658 | 35.33553364 | -81.55204486 | 2020-09-08 04:28:25 | Cleveland, North Carolina, US |
2020-09-04 | US | Arkansas | Crittenden | 5035 | 1693 | 35 | 0 | 1658 | 35.21247318 | -90.30839406 | 2020-09-05 04:28:19 | Crittenden, Arkansas, US |
2020-09-03 | US | South Carolina | Lancaster | 45057 | 1699 | 41 | 0 | 1658 | 34.68270843 | -80.70513032 | 2020-09-04 04:28:26 | Lancaster, South Carolina, US |
2020-09-02 | US | Florida | Walton | 12131 | 1678 | 20 | 0 | 1658 | 30.64204028 | -86.16935664 | 2020-09-03 04:28:22 | Walton, Florida, US |
2020-08-30 | US | Illinois | McLean | 17113 | 1674 | 16 | 0 | 1658 | 40.48996987 | -88.84621113 | 2020-08-31 04:28:27 | McLean, Illinois, US |
2020-08-29 | US | Ohio | Fairfield | 39045 | 1695 | 37 | 0 | 1658 | 39.75107189 | -82.63088163 | 2020-08-30 04:28:22 | Fairfield, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;