daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
118 rows where confirmed = 5659 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-22 | Colombia | Guaviare | 5659 | 105 | 0 | 1.0654 | -73.2603 | 2022-12-23 04:21:04 | Guaviare, Colombia | |||
2022-12-21 | Colombia | Guaviare | 5659 | 105 | 0 | 1.0654 | -73.2603 | 2022-12-22 04:20:56 | Guaviare, Colombia | |||
2022-12-20 | Colombia | Guaviare | 5659 | 105 | 0 | 1.0654 | -73.2603 | 2022-12-21 04:21:03 | Guaviare, Colombia | |||
2022-12-19 | Colombia | Guaviare | 5659 | 105 | 0 | 1.0654 | -73.2603 | 2022-12-20 04:21:04 | Guaviare, Colombia | |||
2022-12-18 | Colombia | Guaviare | 5659 | 105 | 0 | 1.0654 | -73.2603 | 2022-12-19 04:21:03 | Guaviare, Colombia | |||
2022-12-17 | Colombia | Guaviare | 5659 | 105 | 0 | 1.0654 | -73.2603 | 2022-12-18 04:21:03 | Guaviare, Colombia | |||
2022-12-16 | Colombia | Guaviare | 5659 | 105 | 0 | 1.0654 | -73.2603 | 2022-12-17 04:21:04 | Guaviare, Colombia | |||
2022-12-15 | Colombia | Guaviare | 5659 | 105 | 0 | 1.0654 | -73.2603 | 2022-12-16 04:21:01 | Guaviare, Colombia | |||
2022-11-14 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-15 04:21:16 | Dawson, Nebraska, US | |
2022-11-13 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-14 04:21:09 | Dawson, Nebraska, US | |
2022-11-12 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-13 04:21:14 | Dawson, Nebraska, US | |
2022-11-11 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-12 04:20:41 | Dawson, Nebraska, US | |
2022-11-10 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-11 04:21:22 | Dawson, Nebraska, US | |
2022-11-09 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-10 04:21:16 | Dawson, Nebraska, US | |
2022-11-08 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-09 04:21:22 | Dawson, Nebraska, US | |
2022-11-07 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-08 04:21:21 | Dawson, Nebraska, US | |
2022-11-06 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-07 04:21:26 | Dawson, Nebraska, US | |
2022-11-05 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-06 04:21:24 | Dawson, Nebraska, US | |
2022-11-04 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-05 04:21:52 | Dawson, Nebraska, US | |
2022-11-03 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-04 04:22:11 | Dawson, Nebraska, US | |
2022-11-02 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-03 04:22:05 | Dawson, Nebraska, US | |
2022-11-01 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-02 04:22:09 | Dawson, Nebraska, US | |
2022-10-31 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-11-01 04:22:36 | Dawson, Nebraska, US | |
2022-10-30 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-10-31 04:21:36 | Dawson, Nebraska, US | |
2022-10-29 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-10-30 04:22:14 | Dawson, Nebraska, US | |
2022-10-28 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-10-29 04:21:13 | Dawson, Nebraska, US | |
2022-10-27 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-10-28 04:22:31 | Dawson, Nebraska, US | |
2022-10-26 | US | Nebraska | Dawson | 31047 | 5659 | 85 | 0 | 40.87028216 | -99.8201461 | 2022-10-27 04:22:01 | Dawson, Nebraska, US | |
2022-10-05 | US | Colorado | Teller | 8119 | 5659 | 61 | 0 | 38.88133511 | -105.1614893 | 2022-10-06 04:21:22 | Teller, Colorado, US | |
2022-09-22 | US | Texas | Milam | 48331 | 5659 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-09-23 04:23:13 | Milam, Texas, US | |
2022-09-21 | US | Texas | Milam | 48331 | 5659 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-09-22 04:22:56 | Milam, Texas, US | |
2022-09-20 | US | Texas | Milam | 48331 | 5659 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-09-21 04:23:22 | Milam, Texas, US | |
2022-09-19 | US | Texas | Milam | 48331 | 5659 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-09-20 04:22:48 | Milam, Texas, US | |
2022-09-02 | US | Tennessee | Johnson | 47091 | 5659 | 102 | 0 | 36.4552395 | -81.84886538 | 2022-09-03 04:21:04 | Johnson, Tennessee, US | |
2022-08-25 | US | Arkansas | Ashley | 5003 | 5659 | 73 | 0 | 33.19153461 | -91.7698471 | 2022-08-26 04:21:02 | Ashley, Arkansas, US | |
2022-08-14 | US | Illinois | Richland | 17159 | 5659 | 76 | 0 | 38.71240969 | -88.08475366 | 2022-08-15 04:20:59 | Richland, Illinois, US | |
2022-08-13 | US | Illinois | Richland | 17159 | 5659 | 76 | 0 | 38.71240969 | -88.08475366 | 2022-08-14 04:20:55 | Richland, Illinois, US | |
2022-08-12 | US | Illinois | Richland | 17159 | 5659 | 76 | 0 | 38.71240969 | -88.08475366 | 2022-08-13 04:20:52 | Richland, Illinois, US | |
2022-08-02 | US | Indiana | Sullivan | 18153 | 5659 | 77 | 0 | 39.08952258 | -87.41414469 | 2022-08-03 04:20:59 | Sullivan, Indiana, US | |
2022-08-01 | US | Indiana | Sullivan | 18153 | 5659 | 77 | 0 | 39.08952258 | -87.41414469 | 2022-08-02 04:20:53 | Sullivan, Indiana, US | |
2022-06-05 | US | Texas | Moore | 48341 | 5659 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-06-06 04:20:57 | Moore, Texas, US | |
2022-05-23 | US | West Virginia | Lincoln | 54043 | 5659 | 83 | 0 | 38.172154 | -82.07017953 | 2022-05-24 04:20:57 | Lincoln, West Virginia, US | |
2022-05-09 | US | Minnesota | Martin | 27091 | 5659 | 64 | 0 | 43.67429718 | -94.55099908 | 2022-05-10 04:20:50 | Martin, Minnesota, US | |
2022-05-05 | US | Maryland | Talbot | 24041 | 5659 | 88 | 0 | 38.76618159 | -76.10882561 | 2022-05-06 04:21:00 | Talbot, Maryland, US | |
2022-04-21 | US | Alabama | Barbour | 1005 | 5659 | 98 | 0 | 31.868263 | -85.3871286 | 2022-04-22 04:20:45 | Barbour, Alabama, US | |
2022-04-18 | US | Alabama | Barbour | 1005 | 5659 | 98 | 0 | 31.868263 | -85.3871286 | 2022-04-19 04:21:00 | Barbour, Alabama, US | |
2022-04-17 | US | Virginia | Staunton | 51790 | 5659 | 112 | 0 | 38.15965544 | -79.05979937 | 2022-04-18 04:21:12 | Staunton, Virginia, US | |
2022-04-16 | US | Virginia | Staunton | 51790 | 5659 | 112 | 0 | 38.15965544 | -79.05979937 | 2022-04-17 04:20:59 | Staunton, Virginia, US | |
2022-04-15 | US | Virginia | Staunton | 51790 | 5659 | 112 | 0 | 38.15965544 | -79.05979937 | 2022-04-16 04:20:48 | Staunton, Virginia, US | |
2022-03-21 | US | Texas | Austin | 48015 | 5659 | 73 | 0 | 29.88548725 | -96.27736949 | 2022-03-22 04:20:54 | Austin, Texas, US | |
2022-03-20 | US | Texas | Austin | 48015 | 5659 | 73 | 0 | 29.88548725 | -96.27736949 | 2022-03-21 04:20:50 | Austin, Texas, US | |
2022-03-03 | US | Virginia | Salem | 51775 | 5659 | 98 | 0 | 37.2836193 | -80.06219455 | 2022-03-04 04:21:09 | Salem, Virginia, US | |
2022-02-28 | US | Tennessee | Wayne | 47181 | 5659 | 58 | 0 | 35.23868267 | -87.78644456 | 2022-03-01 04:21:09 | Wayne, Tennessee, US | |
2022-02-27 | US | Missouri | Audrain | 29007 | 5659 | 106 | 0 | 39.215877 | -91.84242683 | 2022-02-28 04:21:05 | Audrain, Missouri, US | |
2022-02-26 | US | Missouri | Audrain | 29007 | 5659 | 106 | 0 | 39.215877 | -91.84242683 | 2022-02-27 04:21:04 | Audrain, Missouri, US | |
2022-02-25 | US | Missouri | Audrain | 29007 | 5659 | 106 | 0 | 39.215877 | -91.84242683 | 2022-02-26 04:21:12 | Audrain, Missouri, US | |
2022-02-07 | US | South Carolina | Barnwell | 45011 | 5659 | 90 | 0 | 33.26679302 | -81.43584352 | 2022-02-08 04:21:15 | Barnwell, South Carolina, US | |
2022-02-03 | US | Colorado | Morgan | 8087 | 5659 | 137 | 0 | 40.26279810000001 | -103.8093302 | 2022-02-04 04:21:10 | Morgan, Colorado, US | |
2022-02-02 | US | South Dakota | Yankton | 46135 | 5659 | 50 | 0 | 43.00924485 | -97.39467635 | 2022-02-03 04:21:21 | Yankton, South Dakota, US | |
2022-01-26 | United Kingdom | Turks and Caicos Islands | 5659 | 34 | 0 | 21.69400000000001 | -71.7979 | 2022-01-27 04:21:19 | Turks and Caicos Islands, United Kingdom | |||
2022-01-13 | US | West Virginia | Hancock | 54029 | 5659 | 127 | 0 | 40.51943859 | -80.57461608 | 2022-01-14 04:21:54 | Hancock, West Virginia, US | |
2022-01-12 | US | Texas | Fannin | 48147 | 5659 | 155 | 0 | 33.59564294 | -96.10751083 | 2022-01-13 08:00:09 | Fannin, Texas, US | |
2022-01-11 | US | Texas | Hutchinson | 48233 | 5659 | 116 | 0 | 35.84006574 | -101.3546643 | 2022-01-12 04:21:44 | Hutchinson, Texas, US | |
2021-12-29 | US | Pennsylvania | Susquehanna | 42115 | 5659 | 86 | 0 | 41.82147784 | -75.80071959 | 2021-12-30 04:21:25 | Susquehanna, Pennsylvania, US | |
2021-12-13 | US | Tennessee | Macon | 47111 | 5659 | 100 | 0 | 36.53157855 | -86.00778595 | 2021-12-14 04:22:38 | Macon, Tennessee, US | |
2021-12-06 | US | Indiana | Ripley | 18137 | 5659 | 94 | 0 | 39.10235626 | -85.26212744 | 2021-12-07 04:22:34 | Ripley, Indiana, US | |
2021-11-17 | US | South Carolina | Colleton | 45029 | 5659 | 190 | 0 | 32.87582989 | -80.67641292 | 2021-11-18 04:21:33 | Colleton, South Carolina, US | |
2021-11-15 | US | Pennsylvania | Jefferson | 42065 | 5659 | 131 | 0 | 41.12913106 | -78.9986361 | 2021-11-16 04:21:10 | Jefferson, Pennsylvania, US | |
2021-10-26 | US | Maryland | Calvert | 24009 | 5659 | 101 | 0 | 38.53961642 | -76.56820632 | 2021-10-27 04:22:32 | Calvert, Maryland, US | |
2021-10-25 | US | Virginia | Tazewell | 51185 | 5659 | 102 | 0 | 37.12191123 | -81.56685568 | 2021-10-26 04:22:09 | Tazewell, Virginia, US | |
2021-10-20 | US | North Carolina | Scotland | 37165 | 5659 | 106 | 0 | 34.8386299 | -79.4757978 | 2021-10-21 04:21:18 | Scotland, North Carolina, US | |
2021-10-19 | US | Washington | Whitman | 53075 | 5659 | 71 | 0 | 46.90022523 | -117.52417630000001 | 2021-10-20 04:21:00 | Whitman, Washington, US | |
2021-10-14 | US | Indiana | Clinton | 18023 | 5659 | 71 | 0 | 40.30319754 | -86.47277257 | 2021-10-15 04:21:26 | Clinton, Indiana, US | |
2021-10-12 | Japan | Yamaguchi | 5659 | 91 | 0 | 34.201190000000004 | 131.573293 | 2021-10-13 04:20:51 | Yamaguchi, Japan | |||
2021-09-18 | Japan | Saga | 5659 | 29 | 0 | 33.286977 | 130.115738 | 2021-09-19 04:21:34 | Saga, Japan | |||
2021-09-12 | US | North Dakota | Williams | 38105 | 5659 | 42 | 0 | 48.34522353 | -103.4793387 | 2021-09-13 04:21:15 | Williams, North Dakota, US | |
2021-08-22 | US | North Carolina | Hoke | 37093 | 5659 | 58 | 0 | 35.01888303 | -79.23651674 | 2021-08-23 04:21:27 | Hoke, North Carolina, US | |
2021-08-21 | US | North Carolina | Hoke | 37093 | 5659 | 58 | 0 | 35.01888303 | -79.23651674 | 2021-08-22 04:21:29 | Hoke, North Carolina, US | |
2021-08-20 | US | North Carolina | Hoke | 37093 | 5659 | 58 | 0 | 35.01888303 | -79.23651674 | 2021-08-21 04:21:38 | Hoke, North Carolina, US | |
2021-07-13 | US | Washington | Walla Walla | 53071 | 5659 | 71 | 0 | 46.23040051 | -118.4775539 | 2021-07-14 04:21:35 | Walla Walla, Washington, US | |
2021-06-07 | US | Kentucky | Pike | 21195 | 5659 | 103 | 0 | 37.47088263 | -82.39487445 | 2021-06-08 04:22:35 | Pike, Kentucky, US | |
2021-06-06 | US | Kentucky | Pike | 21195 | 5659 | 103 | 0 | 37.47088263 | -82.39487445 | 2021-06-07 04:22:51 | Pike, Kentucky, US | |
2021-06-05 | US | Kentucky | Pike | 21195 | 5659 | 103 | 0 | 37.47088263 | -82.39487445 | 2021-06-06 04:24:03 | Pike, Kentucky, US | |
2021-06-04 | US | Michigan | Tuscola | 26157 | 5659 | 175 | 0 | 43.46606813 | -83.41897025 | 2021-06-05 04:23:03 | Tuscola, Michigan, US | |
2021-06-04 | US | Kentucky | Pike | 21195 | 5659 | 103 | 0 | 37.47088263 | -82.39487445 | 2021-06-05 04:23:03 | Pike, Kentucky, US | |
2021-05-17 | US | Indiana | Noble | 18113 | 5659 | 84 | 0 | 41.39672484 | -85.41966713 | 2021-05-18 04:20:33 | Noble, Indiana, US | |
2021-05-11 | US | Minnesota | Benton | 27009 | 5659 | 97 | 0 | 45.69804958 | -93.99514135 | 2021-05-12 04:21:29 | Benton, Minnesota, US | |
2021-05-02 | US | Wisconsin | Grant | 55043 | 5659 | 90 | 0 | 42.8671731 | -90.7063218 | 2021-05-03 04:20:39 | Grant, Wisconsin, US | |
2021-05-01 | US | Wisconsin | Grant | 55043 | 5659 | 90 | 0 | 42.8671731 | -90.7063218 | 2021-05-02 04:20:48 | Grant, Wisconsin, US | |
2021-04-24 | US | Illinois | Grundy | 17063 | 5659 | 71 | 0 | 41.28569601 | -88.41905692 | 2021-04-25 04:20:32 | Grundy, Illinois, US | |
2021-03-23 | US | Tennessee | Lawrence | 47099 | 5659 | 86 | 0 | 35.21675201 | -87.39787695 | 2021-03-24 05:25:40 | Lawrence, Tennessee, US | |
2021-03-19 | US | Wisconsin | Sauk | 55111 | 5659 | 50 | 0 | 43.42574087 | -89.94966132 | 2021-03-20 05:25:46 | Sauk, Wisconsin, US | |
2021-03-07 | US | Georgia | Catoosa | 13047 | 5659 | 67 | 0 | 34.89872298 | -85.13757014 | 2021-03-08 05:24:48 | Catoosa, Georgia, US | |
2021-03-01 | US | Texas | Caldwell | 48055 | 5659 | 85 | 0 | 5109 | 29.83668859 | -97.61814775 | 2021-03-02 05:23:30 | Caldwell, Texas, US |
2021-02-26 | US | North Carolina | Duplin | 37061 | 5659 | 127 | 0 | 5532 | 34.93449805 | -77.93140529 | 2021-02-27 05:22:28 | Duplin, North Carolina, US |
2021-02-10 | US | Florida | Putnam | 12107 | 5659 | 109 | 0 | 5550 | 29.60779729 | -81.74230285 | 2021-02-11 05:23:55 | Putnam, Florida, US |
2021-02-05 | US | Virginia | Rockingham | 51165 | 5659 | 76 | 0 | 5583 | 38.51006137 | -78.87260325 | 2021-02-06 05:23:55 | Rockingham, Virginia, US |
2021-01-28 | US | Kentucky | Christian | 21047 | 5659 | 67 | 0 | 5592 | 36.89267803 | -87.49055367 | 2021-01-29 05:22:23 | Christian, Kentucky, US |
2021-01-13 | US | Indiana | Grant | 18053 | 5659 | 134 | 0 | 5525 | 40.51587228 | -85.65468702 | 2021-01-14 05:22:32 | Grant, Indiana, US |
2021-01-12 | US | New Hampshire | Merrimack | 33013 | 5659 | 83 | 0 | 5576 | 43.29662971 | -71.6811573 | 2021-01-13 05:22:15 | Merrimack, New Hampshire, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;