daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27,469 rows where deaths = 20 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), 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 | US | Wyoming | Hot Springs | 56017 | 1425 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-30 04:21:04 | Hot Springs, Wyoming, US | |
2022-12-29 | US | Virginia | Falls Church | 51610 | 3360 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-12-30 04:21:04 | Falls Church, Virginia, US | |
2022-12-29 | US | Virginia | Bath | 51017 | 1049 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-30 04:21:04 | Bath, Virginia, US | |
2022-12-29 | US | Texas | Crockett | 48105 | 1335 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-12-30 04:21:04 | Crockett, Texas, US | |
2022-12-29 | US | Texas | Coke | 48081 | 1041 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-12-30 04:21:04 | Coke, Texas, US | |
2022-12-29 | US | South Dakota | Jerauld | 46073 | 470 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-30 04:21:04 | Jerauld, South Dakota, US | |
2022-12-29 | US | North Dakota | LaMoure | 38045 | 1147 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-12-30 04:21:04 | LaMoure, North Dakota, US | |
2022-12-29 | US | New Mexico | Union | 35059 | 925 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-30 04:21:04 | Union, New Mexico, US | |
2022-12-29 | US | Minnesota | Jackson | 27063 | 2600 | 20 | 0 | 43.67423373 | -95.15398258 | 2022-12-30 04:21:04 | Jackson, Minnesota, US | |
2022-12-29 | US | Michigan | Luce | 26095 | 1642 | 20 | 0 | 46.47227431 | -85.54471223 | 2022-12-30 04:21:04 | Luce, Michigan, US | |
2022-12-29 | US | Kansas | Rush | 20165 | 920 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-30 04:21:04 | Rush, Kansas, US | |
2022-12-29 | US | Kansas | Osborne | 20141 | 1000 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-30 04:21:04 | Osborne, Kansas, US | |
2022-12-29 | US | Illinois | Hardin | 17069 | 1412 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-12-30 04:21:04 | Hardin, Illinois, US | |
2022-12-29 | US | Illinois | Gallatin | 17059 | 1805 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-12-30 04:21:04 | Gallatin, Illinois, US | |
2022-12-29 | US | Idaho | Power | 16077 | 1638 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-12-30 04:21:04 | Power, Idaho, US | |
2022-12-29 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-30 04:21:04 | Beijing, China | |||
2022-12-28 | US | Wyoming | Hot Springs | 56017 | 1425 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-29 04:21:01 | Hot Springs, Wyoming, US | |
2022-12-28 | US | Virginia | Falls Church | 51610 | 3360 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-12-29 04:21:01 | Falls Church, Virginia, US | |
2022-12-28 | US | Virginia | Bath | 51017 | 1049 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-29 04:21:01 | Bath, Virginia, US | |
2022-12-28 | US | Texas | Crockett | 48105 | 1335 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-12-29 04:21:01 | Crockett, Texas, US | |
2022-12-28 | US | Texas | Coke | 48081 | 1041 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-12-29 04:21:01 | Coke, Texas, US | |
2022-12-28 | US | South Dakota | Jerauld | 46073 | 470 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-29 04:21:01 | Jerauld, South Dakota, US | |
2022-12-28 | US | North Dakota | LaMoure | 38045 | 1147 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-12-29 04:21:01 | LaMoure, North Dakota, US | |
2022-12-28 | US | New Mexico | Union | 35059 | 925 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-29 04:21:01 | Union, New Mexico, US | |
2022-12-28 | US | Michigan | Luce | 26095 | 1642 | 20 | 0 | 46.47227431 | -85.54471223 | 2022-12-29 04:21:01 | Luce, Michigan, US | |
2022-12-28 | US | Kansas | Rush | 20165 | 920 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-29 04:21:01 | Rush, Kansas, US | |
2022-12-28 | US | Kansas | Osborne | 20141 | 1000 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-29 04:21:01 | Osborne, Kansas, US | |
2022-12-28 | US | Illinois | Hardin | 17069 | 1412 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-12-29 04:21:01 | Hardin, Illinois, US | |
2022-12-28 | US | Illinois | Gallatin | 17059 | 1805 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-12-29 04:21:01 | Gallatin, Illinois, US | |
2022-12-28 | US | Idaho | Power | 16077 | 1638 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-12-29 04:21:01 | Power, Idaho, US | |
2022-12-28 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-29 04:21:01 | Beijing, China | |||
2022-12-27 | US | Wyoming | Hot Springs | 56017 | 1425 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-28 04:21:04 | Hot Springs, Wyoming, US | |
2022-12-27 | US | Virginia | Falls Church | 51610 | 3357 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-12-28 04:21:04 | Falls Church, Virginia, US | |
2022-12-27 | US | Virginia | Bath | 51017 | 1047 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-28 04:21:04 | Bath, Virginia, US | |
2022-12-27 | US | Texas | Crockett | 48105 | 1327 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-12-28 04:21:04 | Crockett, Texas, US | |
2022-12-27 | US | Texas | Coke | 48081 | 1036 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-12-28 04:21:04 | Coke, Texas, US | |
2022-12-27 | US | South Dakota | Jerauld | 46073 | 470 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-28 04:21:04 | Jerauld, South Dakota, US | |
2022-12-27 | US | North Dakota | LaMoure | 38045 | 1147 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-12-28 04:21:04 | LaMoure, North Dakota, US | |
2022-12-27 | US | New Mexico | Union | 35059 | 925 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-28 04:21:04 | Union, New Mexico, US | |
2022-12-27 | US | Michigan | Luce | 26095 | 1642 | 20 | 0 | 46.47227431 | -85.54471223 | 2022-12-28 04:21:04 | Luce, Michigan, US | |
2022-12-27 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-28 04:21:04 | Rush, Kansas, US | |
2022-12-27 | US | Kansas | Osborne | 20141 | 996 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-28 04:21:04 | Osborne, Kansas, US | |
2022-12-27 | US | Illinois | Hardin | 17069 | 1412 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-12-28 04:21:04 | Hardin, Illinois, US | |
2022-12-27 | US | Illinois | Gallatin | 17059 | 1804 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-12-28 04:21:04 | Gallatin, Illinois, US | |
2022-12-27 | US | Idaho | Power | 16077 | 1635 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-12-28 04:21:04 | Power, Idaho, US | |
2022-12-27 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-28 04:21:04 | Beijing, China | |||
2022-12-26 | US | Wyoming | Hot Springs | 56017 | 1419 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-27 04:21:07 | Hot Springs, Wyoming, US | |
2022-12-26 | US | Virginia | Falls Church | 51610 | 3356 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-12-27 04:21:07 | Falls Church, Virginia, US | |
2022-12-26 | US | Virginia | Bath | 51017 | 1047 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-27 04:21:07 | Bath, Virginia, US | |
2022-12-26 | US | Texas | Crockett | 48105 | 1327 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-12-27 04:21:07 | Crockett, Texas, US | |
2022-12-26 | US | Texas | Coke | 48081 | 1036 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-12-27 04:21:07 | Coke, Texas, US | |
2022-12-26 | US | South Dakota | Jerauld | 46073 | 470 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-27 04:21:07 | Jerauld, South Dakota, US | |
2022-12-26 | US | North Dakota | LaMoure | 38045 | 1147 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-12-27 04:21:07 | LaMoure, North Dakota, US | |
2022-12-26 | US | New Mexico | Union | 35059 | 925 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-27 04:21:07 | Union, New Mexico, US | |
2022-12-26 | US | Michigan | Luce | 26095 | 1638 | 20 | 0 | 46.47227431 | -85.54471223 | 2022-12-27 04:21:07 | Luce, Michigan, US | |
2022-12-26 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-27 04:21:07 | Rush, Kansas, US | |
2022-12-26 | US | Kansas | Osborne | 20141 | 996 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-27 04:21:07 | Osborne, Kansas, US | |
2022-12-26 | US | Illinois | Hardin | 17069 | 1411 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-12-27 04:21:07 | Hardin, Illinois, US | |
2022-12-26 | US | Illinois | Gallatin | 17059 | 1802 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-12-27 04:21:07 | Gallatin, Illinois, US | |
2022-12-26 | US | Idaho | Power | 16077 | 1635 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-12-27 04:21:07 | Power, Idaho, US | |
2022-12-26 | Peru | Unknown | 350 | 20 | 0 | 2022-12-27 04:21:07 | Unknown, Peru | |||||
2022-12-26 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-27 04:21:07 | Beijing, China | |||
2022-12-25 | US | Wyoming | Hot Springs | 56017 | 1419 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-26 04:21:06 | Hot Springs, Wyoming, US | |
2022-12-25 | US | Virginia | Falls Church | 51610 | 3347 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-12-26 04:21:06 | Falls Church, Virginia, US | |
2022-12-25 | US | Virginia | Bath | 51017 | 1046 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-26 04:21:06 | Bath, Virginia, US | |
2022-12-25 | US | Texas | Crockett | 48105 | 1327 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-12-26 04:21:06 | Crockett, Texas, US | |
2022-12-25 | US | Texas | Coke | 48081 | 1036 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-12-26 04:21:06 | Coke, Texas, US | |
2022-12-25 | US | South Dakota | Jerauld | 46073 | 470 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-26 04:21:06 | Jerauld, South Dakota, US | |
2022-12-25 | US | North Dakota | LaMoure | 38045 | 1147 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-12-26 04:21:06 | LaMoure, North Dakota, US | |
2022-12-25 | US | New Mexico | Union | 35059 | 925 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-26 04:21:06 | Union, New Mexico, US | |
2022-12-25 | US | Michigan | Luce | 26095 | 1638 | 20 | 0 | 46.47227431 | -85.54471223 | 2022-12-26 04:21:06 | Luce, Michigan, US | |
2022-12-25 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-26 04:21:06 | Rush, Kansas, US | |
2022-12-25 | US | Kansas | Osborne | 20141 | 996 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-26 04:21:06 | Osborne, Kansas, US | |
2022-12-25 | US | Illinois | Hardin | 17069 | 1411 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-12-26 04:21:06 | Hardin, Illinois, US | |
2022-12-25 | US | Illinois | Gallatin | 17059 | 1802 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-12-26 04:21:06 | Gallatin, Illinois, US | |
2022-12-25 | US | Idaho | Power | 16077 | 1635 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-12-26 04:21:06 | Power, Idaho, US | |
2022-12-25 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-26 04:21:06 | Beijing, China | |||
2022-12-24 | US | Wyoming | Hot Springs | 56017 | 1419 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-25 04:21:04 | Hot Springs, Wyoming, US | |
2022-12-24 | US | Virginia | Falls Church | 51610 | 3347 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-12-25 04:21:04 | Falls Church, Virginia, US | |
2022-12-24 | US | Virginia | Bath | 51017 | 1046 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-25 04:21:04 | Bath, Virginia, US | |
2022-12-24 | US | Texas | Crockett | 48105 | 1327 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-12-25 04:21:04 | Crockett, Texas, US | |
2022-12-24 | US | Texas | Coke | 48081 | 1036 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-12-25 04:21:04 | Coke, Texas, US | |
2022-12-24 | US | South Dakota | Jerauld | 46073 | 470 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-25 04:21:04 | Jerauld, South Dakota, US | |
2022-12-24 | US | North Dakota | LaMoure | 38045 | 1147 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-12-25 04:21:04 | LaMoure, North Dakota, US | |
2022-12-24 | US | New Mexico | Union | 35059 | 925 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-25 04:21:04 | Union, New Mexico, US | |
2022-12-24 | US | Michigan | Luce | 26095 | 1638 | 20 | 0 | 46.47227431 | -85.54471223 | 2022-12-25 04:21:04 | Luce, Michigan, US | |
2022-12-24 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-25 04:21:04 | Rush, Kansas, US | |
2022-12-24 | US | Kansas | Osborne | 20141 | 996 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-25 04:21:04 | Osborne, Kansas, US | |
2022-12-24 | US | Illinois | Hardin | 17069 | 1411 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-12-25 04:21:04 | Hardin, Illinois, US | |
2022-12-24 | US | Illinois | Gallatin | 17059 | 1802 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-12-25 04:21:04 | Gallatin, Illinois, US | |
2022-12-24 | US | Idaho | Power | 16077 | 1635 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-12-25 04:21:04 | Power, Idaho, US | |
2022-12-24 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-25 04:21:04 | Beijing, China | |||
2022-12-23 | US | Wyoming | Hot Springs | 56017 | 1419 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-24 04:21:02 | Hot Springs, Wyoming, US | |
2022-12-23 | US | Virginia | Falls Church | 51610 | 3347 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-12-24 04:21:02 | Falls Church, Virginia, US | |
2022-12-23 | US | Virginia | Bath | 51017 | 1046 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-24 04:21:02 | Bath, Virginia, US | |
2022-12-23 | US | Texas | Crockett | 48105 | 1327 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-12-24 04:21:02 | Crockett, Texas, US | |
2022-12-23 | US | Texas | Coke | 48081 | 1036 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-12-24 04:21:02 | Coke, Texas, US | |
2022-12-23 | US | South Dakota | Jerauld | 46073 | 470 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-24 04:21:02 | Jerauld, South Dakota, US | |
2022-12-23 | US | North Dakota | LaMoure | 38045 | 1147 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-12-24 04:21:02 | LaMoure, North Dakota, US | |
2022-12-23 | US | New Mexico | Union | 35059 | 925 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-24 04:21:02 | Union, New Mexico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;