daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,746 rows where deaths = 146 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
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-29 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-30 04:21:04 | Jersey, United Kingdom | |||
2022-12-29 | US | Wisconsin | Columbia | 55021 | 19191 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-30 04:21:04 | Columbia, Wisconsin, US | |
2022-12-29 | US | West Virginia | Jefferson | 54037 | 17870 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-30 04:21:04 | Jefferson, West Virginia, US | |
2022-12-29 | US | West Virginia | Jackson | 54035 | 8563 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-30 04:21:04 | Jackson, West Virginia, US | |
2022-12-29 | US | Texas | Hutchinson | 48233 | 7476 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-30 04:21:04 | Hutchinson, Texas, US | |
2022-12-29 | US | Ohio | Mercer | 39107 | 11149 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-30 04:21:04 | Mercer, Ohio, US | |
2022-12-29 | US | New York | Sullivan | 36105 | 23830 | 146 | 0 | 41.71579493 | -74.76394559 | 2022-12-30 04:21:04 | Sullivan, New York, US | |
2022-12-29 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-30 04:21:04 | Buffalo, Nebraska, US | |
2022-12-29 | US | Illinois | Effingham | 17049 | 12634 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-30 04:21:04 | Effingham, Illinois, US | |
2022-12-29 | US | Georgia | Chattooga | 13055 | 7465 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-30 04:21:04 | Chattooga, Georgia, US | |
2022-12-29 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-30 04:21:04 | Antigua and Barbuda | ||||
2022-12-28 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-29 04:21:01 | Jersey, United Kingdom | |||
2022-12-28 | US | Wisconsin | Columbia | 55021 | 19178 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-29 04:21:01 | Columbia, Wisconsin, US | |
2022-12-28 | US | West Virginia | Jefferson | 54037 | 17856 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-29 04:21:01 | Jefferson, West Virginia, US | |
2022-12-28 | US | West Virginia | Jackson | 54035 | 8555 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-29 04:21:01 | Jackson, West Virginia, US | |
2022-12-28 | US | Texas | Hutchinson | 48233 | 7476 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-29 04:21:01 | Hutchinson, Texas, US | |
2022-12-28 | US | Ohio | Mercer | 39107 | 11110 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-29 04:21:01 | Mercer, Ohio, US | |
2022-12-28 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-29 04:21:01 | Buffalo, Nebraska, US | |
2022-12-28 | US | Illinois | Effingham | 17049 | 12629 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-29 04:21:01 | Effingham, Illinois, US | |
2022-12-28 | US | Georgia | Chattooga | 13055 | 7465 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-29 04:21:01 | Chattooga, Georgia, US | |
2022-12-28 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-29 04:21:01 | Antigua and Barbuda | ||||
2022-12-27 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-28 04:21:04 | Jersey, United Kingdom | |||
2022-12-27 | US | Wisconsin | Columbia | 55021 | 19168 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-28 04:21:04 | Columbia, Wisconsin, US | |
2022-12-27 | US | West Virginia | Jefferson | 54037 | 17844 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-28 04:21:04 | Jefferson, West Virginia, US | |
2022-12-27 | US | West Virginia | Jackson | 54035 | 8546 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-28 04:21:04 | Jackson, West Virginia, US | |
2022-12-27 | US | Texas | Hutchinson | 48233 | 7459 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-28 04:21:04 | Hutchinson, Texas, US | |
2022-12-27 | US | Ohio | Mercer | 39107 | 11110 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-28 04:21:04 | Mercer, Ohio, US | |
2022-12-27 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-28 04:21:04 | Buffalo, Nebraska, US | |
2022-12-27 | US | Illinois | Effingham | 17049 | 12624 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-28 04:21:04 | Effingham, Illinois, US | |
2022-12-27 | US | Georgia | Chattooga | 13055 | 7446 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-28 04:21:04 | Chattooga, Georgia, US | |
2022-12-27 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-28 04:21:04 | Antigua and Barbuda | ||||
2022-12-26 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-27 04:21:07 | Jersey, United Kingdom | |||
2022-12-26 | US | Wisconsin | Columbia | 55021 | 19155 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-27 04:21:07 | Columbia, Wisconsin, US | |
2022-12-26 | US | West Virginia | Jefferson | 54037 | 17776 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-27 04:21:07 | Jefferson, West Virginia, US | |
2022-12-26 | US | West Virginia | Jackson | 54035 | 8524 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-27 04:21:07 | Jackson, West Virginia, US | |
2022-12-26 | US | Texas | Hutchinson | 48233 | 7459 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-27 04:21:07 | Hutchinson, Texas, US | |
2022-12-26 | US | Ohio | Mercer | 39107 | 11110 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-27 04:21:07 | Mercer, Ohio, US | |
2022-12-26 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-27 04:21:07 | Buffalo, Nebraska, US | |
2022-12-26 | US | Illinois | Effingham | 17049 | 12618 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-27 04:21:07 | Effingham, Illinois, US | |
2022-12-26 | US | Georgia | Chattooga | 13055 | 7446 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-27 04:21:07 | Chattooga, Georgia, US | |
2022-12-26 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-27 04:21:07 | Antigua and Barbuda | ||||
2022-12-25 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-26 04:21:06 | Jersey, United Kingdom | |||
2022-12-25 | US | Wisconsin | Columbia | 55021 | 19140 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-26 04:21:06 | Columbia, Wisconsin, US | |
2022-12-25 | US | West Virginia | Jefferson | 54037 | 17776 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-26 04:21:06 | Jefferson, West Virginia, US | |
2022-12-25 | US | West Virginia | Jackson | 54035 | 8524 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-26 04:21:06 | Jackson, West Virginia, US | |
2022-12-25 | US | Texas | Hutchinson | 48233 | 7459 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-26 04:21:06 | Hutchinson, Texas, US | |
2022-12-25 | US | Ohio | Mercer | 39107 | 11110 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-26 04:21:06 | Mercer, Ohio, US | |
2022-12-25 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-26 04:21:06 | Buffalo, Nebraska, US | |
2022-12-25 | US | Illinois | Effingham | 17049 | 12618 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-26 04:21:06 | Effingham, Illinois, US | |
2022-12-25 | US | Georgia | Chattooga | 13055 | 7446 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-26 04:21:06 | Chattooga, Georgia, US | |
2022-12-25 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-26 04:21:06 | Antigua and Barbuda | ||||
2022-12-24 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-25 04:21:04 | Jersey, United Kingdom | |||
2022-12-24 | US | Wisconsin | Columbia | 55021 | 19140 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-25 04:21:04 | Columbia, Wisconsin, US | |
2022-12-24 | US | West Virginia | Jefferson | 54037 | 17776 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-25 04:21:04 | Jefferson, West Virginia, US | |
2022-12-24 | US | West Virginia | Jackson | 54035 | 8524 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-25 04:21:04 | Jackson, West Virginia, US | |
2022-12-24 | US | Texas | Hutchinson | 48233 | 7459 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-25 04:21:04 | Hutchinson, Texas, US | |
2022-12-24 | US | Ohio | Mercer | 39107 | 11110 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-25 04:21:04 | Mercer, Ohio, US | |
2022-12-24 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-25 04:21:04 | Buffalo, Nebraska, US | |
2022-12-24 | US | Illinois | Effingham | 17049 | 12618 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-25 04:21:04 | Effingham, Illinois, US | |
2022-12-24 | US | Georgia | Chattooga | 13055 | 7446 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-25 04:21:04 | Chattooga, Georgia, US | |
2022-12-24 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-25 04:21:04 | Antigua and Barbuda | ||||
2022-12-23 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-24 04:21:02 | Jersey, United Kingdom | |||
2022-12-23 | US | Wisconsin | Columbia | 55021 | 19140 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-24 04:21:02 | Columbia, Wisconsin, US | |
2022-12-23 | US | West Virginia | Jefferson | 54037 | 17776 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-24 04:21:02 | Jefferson, West Virginia, US | |
2022-12-23 | US | West Virginia | Jackson | 54035 | 8524 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-24 04:21:02 | Jackson, West Virginia, US | |
2022-12-23 | US | Texas | Hutchinson | 48233 | 7459 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-24 04:21:02 | Hutchinson, Texas, US | |
2022-12-23 | US | Ohio | Mercer | 39107 | 11110 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-24 04:21:02 | Mercer, Ohio, US | |
2022-12-23 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-24 04:21:02 | Buffalo, Nebraska, US | |
2022-12-23 | US | Illinois | Effingham | 17049 | 12618 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-24 04:21:02 | Effingham, Illinois, US | |
2022-12-23 | US | Georgia | Chattooga | 13055 | 7446 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-24 04:21:02 | Chattooga, Georgia, US | |
2022-12-23 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-24 04:21:02 | Antigua and Barbuda | ||||
2022-12-22 | US | Wisconsin | Columbia | 55021 | 19124 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-23 04:21:04 | Columbia, Wisconsin, US | |
2022-12-22 | US | West Virginia | Jefferson | 54037 | 17776 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-23 04:21:04 | Jefferson, West Virginia, US | |
2022-12-22 | US | West Virginia | Jackson | 54035 | 8524 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-23 04:21:04 | Jackson, West Virginia, US | |
2022-12-22 | US | Texas | Hutchinson | 48233 | 7459 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-23 04:21:04 | Hutchinson, Texas, US | |
2022-12-22 | US | Ohio | Mercer | 39107 | 11110 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-23 04:21:04 | Mercer, Ohio, US | |
2022-12-22 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-23 04:21:04 | Buffalo, Nebraska, US | |
2022-12-22 | US | Illinois | Effingham | 17049 | 12609 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-23 04:21:04 | Effingham, Illinois, US | |
2022-12-22 | US | Georgia | Chattooga | 13055 | 7446 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-23 04:21:04 | Chattooga, Georgia, US | |
2022-12-22 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-23 04:21:04 | Antigua and Barbuda | ||||
2022-12-21 | US | Wisconsin | Columbia | 55021 | 19105 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-22 04:20:56 | Columbia, Wisconsin, US | |
2022-12-21 | US | West Virginia | Jefferson | 54037 | 17761 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-22 04:20:56 | Jefferson, West Virginia, US | |
2022-12-21 | US | West Virginia | Jackson | 54035 | 8520 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-22 04:20:56 | Jackson, West Virginia, US | |
2022-12-21 | US | Texas | Hutchinson | 48233 | 7459 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-22 04:20:56 | Hutchinson, Texas, US | |
2022-12-21 | US | Ohio | Mercer | 39107 | 11062 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-22 04:20:56 | Mercer, Ohio, US | |
2022-12-21 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-22 04:20:56 | Buffalo, Nebraska, US | |
2022-12-21 | US | Illinois | Effingham | 17049 | 12602 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-22 04:20:56 | Effingham, Illinois, US | |
2022-12-21 | US | Georgia | Chattooga | 13055 | 7446 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-22 04:20:56 | Chattooga, Georgia, US | |
2022-12-21 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-22 04:20:56 | Antigua and Barbuda | ||||
2022-12-20 | US | Wisconsin | Columbia | 55021 | 19093 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-21 04:21:03 | Columbia, Wisconsin, US | |
2022-12-20 | US | West Virginia | Jefferson | 54037 | 17739 | 146 | 0 | 39.30776166 | -77.86014147 | 2022-12-21 04:21:03 | Jefferson, West Virginia, US | |
2022-12-20 | US | West Virginia | Jackson | 54035 | 8509 | 146 | 0 | 38.84263974 | -81.68148753 | 2022-12-21 04:21:03 | Jackson, West Virginia, US | |
2022-12-20 | US | Texas | Hutchinson | 48233 | 7441 | 146 | 0 | 35.84006574 | -101.3546643 | 2022-12-21 04:21:03 | Hutchinson, Texas, US | |
2022-12-20 | US | Ohio | Mercer | 39107 | 11062 | 146 | 0 | 40.54043046 | -84.62912742 | 2022-12-21 04:21:03 | Mercer, Ohio, US | |
2022-12-20 | US | Nebraska | Buffalo | 31019 | 13655 | 146 | 0 | 40.85486962 | -99.07500296 | 2022-12-21 04:21:03 | Buffalo, Nebraska, US | |
2022-12-20 | US | Illinois | Effingham | 17049 | 12588 | 146 | 0 | 39.05935711 | -88.58969584 | 2022-12-21 04:21:03 | Effingham, Illinois, US | |
2022-12-20 | US | Georgia | Chattooga | 13055 | 7436 | 146 | 0 | 34.47197698 | -85.34535662 | 2022-12-21 04:21:03 | Chattooga, Georgia, US | |
2022-12-20 | Antigua and Barbuda | 9106 | 146 | 0 | 17.0608 | -61.7964 | 2022-12-21 04:21:03 | Antigua and Barbuda | ||||
2022-12-19 | US | Wisconsin | Marinette | 55075 | 14063 | 146 | 0 | 45.38553432 | -88.033246 | 2022-12-20 04:21:04 | Marinette, Wisconsin, US | |
2022-12-19 | US | Wisconsin | Columbia | 55021 | 19082 | 146 | 0 | 43.46492199 | -89.33589004 | 2022-12-20 04:21:04 | Columbia, Wisconsin, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;