daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48,690 rows where deaths = 6 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 >30
- US 41,246
- China 3,508
- Japan 572
- Malaysia 516
- France 493
- Australia 375
- Palau 235
- Korea, North 230
- Canada 206
- United Kingdom 158
- Sweden 140
- Burma 128
- Mainland China 90
- Burundi 77
- Colombia 74
- India 65
- Russia 40
- Ukraine 37
- Taiwan* 31
- Costa Rica 20
- Eritrea 17
- Saint Vincent and the Grenadines 17
- Antigua and Barbuda 16
- Chile 16
- Syria 15
- Malta 14
- Bhutan 13
- Denmark 13
- Others 12
- Congo (Brazzaville) 11
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Washington | Unassigned | 90053 | 3296 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Washington, US | |
2022-12-29 | US | Virginia | Highland | 51091 | 478 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-30 04:21:04 | Highland, Virginia, US | |
2022-12-29 | US | Texas | Oldham | 48359 | 627 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-30 04:21:04 | Oldham, Texas, US | |
2022-12-29 | US | South Dakota | Hanson | 46061 | 730 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-30 04:21:04 | Hanson, South Dakota, US | |
2022-12-29 | US | Oregon | Sherman | 41055 | 385 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-30 04:21:04 | Sherman, Oregon, US | |
2022-12-29 | US | Oregon | Gilliam | 41021 | 318 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-30 04:21:04 | Gilliam, Oregon, US | |
2022-12-29 | US | North Dakota | Eddy | 38027 | 875 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-30 04:21:04 | Eddy, North Dakota, US | |
2022-12-29 | US | New Mexico | De Baca | 35011 | 735 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-30 04:21:04 | De Baca, New Mexico, US | |
2022-12-29 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-30 04:21:04 | Greeley, Nebraska, US | |
2022-12-29 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-30 04:21:04 | Grant, Nebraska, US | |
2022-12-29 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-30 04:21:04 | Dundy, Nebraska, US | |
2022-12-29 | US | Minnesota | Lake of the Woods | 27077 | 906 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-12-30 04:21:04 | Lake of the Woods, Minnesota, US | |
2022-12-29 | US | Kansas | Greeley | 20071 | 390 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-30 04:21:04 | Greeley, Kansas, US | |
2022-12-29 | US | Illinois | Calhoun | 17013 | 1866 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-30 04:21:04 | Calhoun, Illinois, US | |
2022-12-29 | US | Colorado | Ouray | 8091 | 1099 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-30 04:21:04 | Ouray, Colorado, US | |
2022-12-29 | US | Colorado | Kiowa | 8061 | 389 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-30 04:21:04 | Kiowa, Colorado, US | |
2022-12-29 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-30 04:21:04 | Korea, North | ||||
2022-12-29 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-30 04:21:04 | Saint Barthelemy, France | |||
2022-12-29 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-30 04:21:04 | Hainan, China | |||
2022-12-29 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-30 04:21:04 | Anhui, China | |||
2022-12-28 | US | Washington | Unassigned | 90053 | 3296 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Washington, US | |
2022-12-28 | US | Virginia | Highland | 51091 | 478 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-29 04:21:01 | Highland, Virginia, US | |
2022-12-28 | US | Texas | Oldham | 48359 | 627 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-29 04:21:01 | Oldham, Texas, US | |
2022-12-28 | US | South Dakota | Hanson | 46061 | 730 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-29 04:21:01 | Hanson, South Dakota, US | |
2022-12-28 | US | Oregon | Sherman | 41055 | 385 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-29 04:21:01 | Sherman, Oregon, US | |
2022-12-28 | US | Oregon | Gilliam | 41021 | 318 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-29 04:21:01 | Gilliam, Oregon, US | |
2022-12-28 | US | North Dakota | Eddy | 38027 | 875 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-29 04:21:01 | Eddy, North Dakota, US | |
2022-12-28 | US | New Mexico | De Baca | 35011 | 734 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-29 04:21:01 | De Baca, New Mexico, US | |
2022-12-28 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-29 04:21:01 | Greeley, Nebraska, US | |
2022-12-28 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-29 04:21:01 | Grant, Nebraska, US | |
2022-12-28 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-29 04:21:01 | Dundy, Nebraska, US | |
2022-12-28 | US | Minnesota | Lake of the Woods | 27077 | 903 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-12-29 04:21:01 | Lake of the Woods, Minnesota, US | |
2022-12-28 | US | Kansas | Greeley | 20071 | 390 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-29 04:21:01 | Greeley, Kansas, US | |
2022-12-28 | US | Illinois | Calhoun | 17013 | 1866 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-29 04:21:01 | Calhoun, Illinois, US | |
2022-12-28 | US | Colorado | Ouray | 8091 | 1098 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-29 04:21:01 | Ouray, Colorado, US | |
2022-12-28 | US | Colorado | Kiowa | 8061 | 387 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-29 04:21:01 | Kiowa, Colorado, US | |
2022-12-28 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-29 04:21:01 | Korea, North | ||||
2022-12-28 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-29 04:21:01 | Saint Barthelemy, France | |||
2022-12-28 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-29 04:21:01 | Hainan, China | |||
2022-12-28 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-29 04:21:01 | Anhui, China | |||
2022-12-27 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Washington, US | |
2022-12-27 | US | Virginia | Highland | 51091 | 477 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-28 04:21:04 | Highland, Virginia, US | |
2022-12-27 | US | Texas | Oldham | 48359 | 623 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-28 04:21:04 | Oldham, Texas, US | |
2022-12-27 | US | South Dakota | Hanson | 46061 | 730 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-28 04:21:04 | Hanson, South Dakota, US | |
2022-12-27 | US | Oregon | Sherman | 41055 | 383 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-28 04:21:04 | Sherman, Oregon, US | |
2022-12-27 | US | Oregon | Gilliam | 41021 | 317 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-28 04:21:04 | Gilliam, Oregon, US | |
2022-12-27 | US | North Dakota | Eddy | 38027 | 875 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-28 04:21:04 | Eddy, North Dakota, US | |
2022-12-27 | US | New Mexico | De Baca | 35011 | 732 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-28 04:21:04 | De Baca, New Mexico, US | |
2022-12-27 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-28 04:21:04 | Greeley, Nebraska, US | |
2022-12-27 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-28 04:21:04 | Grant, Nebraska, US | |
2022-12-27 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-28 04:21:04 | Dundy, Nebraska, US | |
2022-12-27 | US | Minnesota | Lake of the Woods | 27077 | 903 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-12-28 04:21:04 | Lake of the Woods, Minnesota, US | |
2022-12-27 | US | Kansas | Greeley | 20071 | 389 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-28 04:21:04 | Greeley, Kansas, US | |
2022-12-27 | US | Illinois | Calhoun | 17013 | 1866 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-28 04:21:04 | Calhoun, Illinois, US | |
2022-12-27 | US | Colorado | Ouray | 8091 | 1098 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-28 04:21:04 | Ouray, Colorado, US | |
2022-12-27 | US | Colorado | Kiowa | 8061 | 387 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-28 04:21:04 | Kiowa, Colorado, US | |
2022-12-27 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-28 04:21:04 | Korea, North | ||||
2022-12-27 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-28 04:21:04 | Saint Barthelemy, France | |||
2022-12-27 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-28 04:21:04 | Hainan, China | |||
2022-12-27 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-28 04:21:04 | Anhui, China | |||
2022-12-26 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Washington, US | |
2022-12-26 | US | Virginia | Highland | 51091 | 477 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-27 04:21:07 | Highland, Virginia, US | |
2022-12-26 | US | Texas | Oldham | 48359 | 623 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-27 04:21:07 | Oldham, Texas, US | |
2022-12-26 | US | South Dakota | Hanson | 46061 | 730 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-27 04:21:07 | Hanson, South Dakota, US | |
2022-12-26 | US | Oregon | Sherman | 41055 | 383 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-27 04:21:07 | Sherman, Oregon, US | |
2022-12-26 | US | Oregon | Gilliam | 41021 | 317 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-27 04:21:07 | Gilliam, Oregon, US | |
2022-12-26 | US | North Dakota | Eddy | 38027 | 875 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-27 04:21:07 | Eddy, North Dakota, US | |
2022-12-26 | US | New Mexico | De Baca | 35011 | 731 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-27 04:21:07 | De Baca, New Mexico, US | |
2022-12-26 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-27 04:21:07 | Greeley, Nebraska, US | |
2022-12-26 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-27 04:21:07 | Grant, Nebraska, US | |
2022-12-26 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-27 04:21:07 | Dundy, Nebraska, US | |
2022-12-26 | US | Minnesota | Lake of the Woods | 27077 | 903 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-12-27 04:21:07 | Lake of the Woods, Minnesota, US | |
2022-12-26 | US | Kansas | Greeley | 20071 | 389 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-27 04:21:07 | Greeley, Kansas, US | |
2022-12-26 | US | Illinois | Calhoun | 17013 | 1865 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-27 04:21:07 | Calhoun, Illinois, US | |
2022-12-26 | US | Colorado | Ouray | 8091 | 1098 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-27 04:21:07 | Ouray, Colorado, US | |
2022-12-26 | US | Colorado | Kiowa | 8061 | 387 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-27 04:21:07 | Kiowa, Colorado, US | |
2022-12-26 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-27 04:21:07 | Korea, North | ||||
2022-12-26 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-27 04:21:07 | Saint Barthelemy, France | |||
2022-12-26 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-27 04:21:07 | Hainan, China | |||
2022-12-26 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-27 04:21:07 | Anhui, China | |||
2022-12-25 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Washington, US | |
2022-12-25 | US | Virginia | Highland | 51091 | 477 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-26 04:21:06 | Highland, Virginia, US | |
2022-12-25 | US | Texas | Oldham | 48359 | 623 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-26 04:21:06 | Oldham, Texas, US | |
2022-12-25 | US | South Dakota | Hanson | 46061 | 730 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-26 04:21:06 | Hanson, South Dakota, US | |
2022-12-25 | US | Oregon | Sherman | 41055 | 383 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-26 04:21:06 | Sherman, Oregon, US | |
2022-12-25 | US | Oregon | Gilliam | 41021 | 317 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-26 04:21:06 | Gilliam, Oregon, US | |
2022-12-25 | US | North Dakota | Eddy | 38027 | 875 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-26 04:21:06 | Eddy, North Dakota, US | |
2022-12-25 | US | New Mexico | De Baca | 35011 | 731 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-26 04:21:06 | De Baca, New Mexico, US | |
2022-12-25 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-26 04:21:06 | Greeley, Nebraska, US | |
2022-12-25 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-26 04:21:06 | Grant, Nebraska, US | |
2022-12-25 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-26 04:21:06 | Dundy, Nebraska, US | |
2022-12-25 | US | Minnesota | Lake of the Woods | 27077 | 903 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-12-26 04:21:06 | Lake of the Woods, Minnesota, US | |
2022-12-25 | US | Kansas | Greeley | 20071 | 389 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-26 04:21:06 | Greeley, Kansas, US | |
2022-12-25 | US | Illinois | Calhoun | 17013 | 1865 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-26 04:21:06 | Calhoun, Illinois, US | |
2022-12-25 | US | Colorado | Ouray | 8091 | 1098 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-26 04:21:06 | Ouray, Colorado, US | |
2022-12-25 | US | Colorado | Kiowa | 8061 | 387 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-26 04:21:06 | Kiowa, Colorado, US | |
2022-12-25 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-26 04:21:06 | Korea, North | ||||
2022-12-25 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-26 04:21:06 | Saint Barthelemy, France | |||
2022-12-25 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-26 04:21:06 | Hainan, China | |||
2022-12-25 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-26 04:21:06 | Anhui, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;