johns_hopkins_csse_daily_reports
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
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756372 | 2756372 | 2022-12-29 | US | Washington | Unassigned | 90053 | 3296 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Washington, US | |
2756264 | 2756264 | 2022-12-29 | US | Virginia | Highland | 51091 | 478 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-30 04:21:04 | Highland, Virginia, US | |
2756098 | 2756098 | 2022-12-29 | US | Texas | Oldham | 48359 | 627 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-30 04:21:04 | Oldham, Texas, US | |
2755784 | 2755784 | 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 | |
2755543 | 2755543 | 2022-12-29 | US | Oregon | Sherman | 41055 | 385 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-30 04:21:04 | Sherman, Oregon, US | |
2755526 | 2755526 | 2022-12-29 | US | Oregon | Gilliam | 41021 | 318 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-30 04:21:04 | Gilliam, Oregon, US | |
2755306 | 2755306 | 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 | |
2755100 | 2755100 | 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 | |
2754987 | 2754987 | 2022-12-29 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-30 04:21:04 | Greeley, Nebraska, US | |
2754986 | 2754986 | 2022-12-29 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-30 04:21:04 | Grant, Nebraska, US | |
2754977 | 2754977 | 2022-12-29 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-30 04:21:04 | Dundy, Nebraska, US | |
2754642 | 2754642 | 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 | |
2754201 | 2754201 | 2022-12-29 | US | Kansas | Greeley | 20071 | 390 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-30 04:21:04 | Greeley, Kansas, US | |
2753875 | 2753875 | 2022-12-29 | US | Illinois | Calhoun | 17013 | 1866 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-30 04:21:04 | Calhoun, Illinois, US | |
2753552 | 2753552 | 2022-12-29 | US | Colorado | Ouray | 8091 | 1099 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-30 04:21:04 | Ouray, Colorado, US | |
2753537 | 2753537 | 2022-12-29 | US | Colorado | Kiowa | 8061 | 389 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-30 04:21:04 | Kiowa, Colorado, US | |
2752941 | 2752941 | 2022-12-29 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-30 04:21:04 | Korea, North | ||||
2752787 | 2752787 | 2022-12-29 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-30 04:21:04 | Saint Barthelemy, France | |||
2752694 | 2752694 | 2022-12-29 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-30 04:21:04 | Hainan, China | |||
2752686 | 2752686 | 2022-12-29 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-30 04:21:04 | Anhui, China | |||
1077378 | 1077378 | 2022-12-28 | US | Washington | Unassigned | 90053 | 3296 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Washington, US | |
1077270 | 1077270 | 2022-12-28 | US | Virginia | Highland | 51091 | 478 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-29 04:21:01 | Highland, Virginia, US | |
1077104 | 1077104 | 2022-12-28 | US | Texas | Oldham | 48359 | 627 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-29 04:21:01 | Oldham, Texas, US | |
1076790 | 1076790 | 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 | |
1076549 | 1076549 | 2022-12-28 | US | Oregon | Sherman | 41055 | 385 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-29 04:21:01 | Sherman, Oregon, US | |
1076532 | 1076532 | 2022-12-28 | US | Oregon | Gilliam | 41021 | 318 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-29 04:21:01 | Gilliam, Oregon, US | |
1076312 | 1076312 | 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 | |
1076106 | 1076106 | 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 | |
1075993 | 1075993 | 2022-12-28 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-29 04:21:01 | Greeley, Nebraska, US | |
1075992 | 1075992 | 2022-12-28 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-29 04:21:01 | Grant, Nebraska, US | |
1075983 | 1075983 | 2022-12-28 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-29 04:21:01 | Dundy, Nebraska, US | |
1075648 | 1075648 | 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 | |
1075207 | 1075207 | 2022-12-28 | US | Kansas | Greeley | 20071 | 390 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-29 04:21:01 | Greeley, Kansas, US | |
1074881 | 1074881 | 2022-12-28 | US | Illinois | Calhoun | 17013 | 1866 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-29 04:21:01 | Calhoun, Illinois, US | |
1074558 | 1074558 | 2022-12-28 | US | Colorado | Ouray | 8091 | 1098 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-29 04:21:01 | Ouray, Colorado, US | |
1074543 | 1074543 | 2022-12-28 | US | Colorado | Kiowa | 8061 | 387 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-29 04:21:01 | Kiowa, Colorado, US | |
1073947 | 1073947 | 2022-12-28 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-29 04:21:01 | Korea, North | ||||
1073793 | 1073793 | 2022-12-28 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-29 04:21:01 | Saint Barthelemy, France | |||
1073700 | 1073700 | 2022-12-28 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-29 04:21:01 | Hainan, China | |||
1073692 | 1073692 | 2022-12-28 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-29 04:21:01 | Anhui, China | |||
331375 | 331375 | 2022-12-27 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Washington, US | |
331267 | 331267 | 2022-12-27 | US | Virginia | Highland | 51091 | 477 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-28 04:21:04 | Highland, Virginia, US | |
331101 | 331101 | 2022-12-27 | US | Texas | Oldham | 48359 | 623 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-28 04:21:04 | Oldham, Texas, US | |
330787 | 330787 | 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 | |
330546 | 330546 | 2022-12-27 | US | Oregon | Sherman | 41055 | 383 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-28 04:21:04 | Sherman, Oregon, US | |
330529 | 330529 | 2022-12-27 | US | Oregon | Gilliam | 41021 | 317 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-28 04:21:04 | Gilliam, Oregon, US | |
330309 | 330309 | 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 | |
330103 | 330103 | 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 | |
329990 | 329990 | 2022-12-27 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-28 04:21:04 | Greeley, Nebraska, US | |
329989 | 329989 | 2022-12-27 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-28 04:21:04 | Grant, Nebraska, US | |
329980 | 329980 | 2022-12-27 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-28 04:21:04 | Dundy, Nebraska, US | |
329645 | 329645 | 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 | |
329204 | 329204 | 2022-12-27 | US | Kansas | Greeley | 20071 | 389 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-28 04:21:04 | Greeley, Kansas, US | |
328878 | 328878 | 2022-12-27 | US | Illinois | Calhoun | 17013 | 1866 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-28 04:21:04 | Calhoun, Illinois, US | |
328555 | 328555 | 2022-12-27 | US | Colorado | Ouray | 8091 | 1098 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-28 04:21:04 | Ouray, Colorado, US | |
328540 | 328540 | 2022-12-27 | US | Colorado | Kiowa | 8061 | 387 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-28 04:21:04 | Kiowa, Colorado, US | |
327944 | 327944 | 2022-12-27 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-28 04:21:04 | Korea, North | ||||
327790 | 327790 | 2022-12-27 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-28 04:21:04 | Saint Barthelemy, France | |||
327697 | 327697 | 2022-12-27 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-28 04:21:04 | Hainan, China | |||
327689 | 327689 | 2022-12-27 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-28 04:21:04 | Anhui, China | |||
221448 | 221448 | 2022-12-26 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Washington, US | |
221340 | 221340 | 2022-12-26 | US | Virginia | Highland | 51091 | 477 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-27 04:21:07 | Highland, Virginia, US | |
221174 | 221174 | 2022-12-26 | US | Texas | Oldham | 48359 | 623 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-27 04:21:07 | Oldham, Texas, US | |
220860 | 220860 | 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 | |
220619 | 220619 | 2022-12-26 | US | Oregon | Sherman | 41055 | 383 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-27 04:21:07 | Sherman, Oregon, US | |
220602 | 220602 | 2022-12-26 | US | Oregon | Gilliam | 41021 | 317 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-27 04:21:07 | Gilliam, Oregon, US | |
220382 | 220382 | 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 | |
220176 | 220176 | 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 | |
220063 | 220063 | 2022-12-26 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-27 04:21:07 | Greeley, Nebraska, US | |
220062 | 220062 | 2022-12-26 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-27 04:21:07 | Grant, Nebraska, US | |
220053 | 220053 | 2022-12-26 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-27 04:21:07 | Dundy, Nebraska, US | |
219718 | 219718 | 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 | |
219277 | 219277 | 2022-12-26 | US | Kansas | Greeley | 20071 | 389 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-27 04:21:07 | Greeley, Kansas, US | |
218951 | 218951 | 2022-12-26 | US | Illinois | Calhoun | 17013 | 1865 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-27 04:21:07 | Calhoun, Illinois, US | |
218628 | 218628 | 2022-12-26 | US | Colorado | Ouray | 8091 | 1098 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-27 04:21:07 | Ouray, Colorado, US | |
218613 | 218613 | 2022-12-26 | US | Colorado | Kiowa | 8061 | 387 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-27 04:21:07 | Kiowa, Colorado, US | |
218017 | 218017 | 2022-12-26 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-27 04:21:07 | Korea, North | ||||
217863 | 217863 | 2022-12-26 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-27 04:21:07 | Saint Barthelemy, France | |||
217770 | 217770 | 2022-12-26 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-27 04:21:07 | Hainan, China | |||
217762 | 217762 | 2022-12-26 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-27 04:21:07 | Anhui, China | |||
3225905 | 3225905 | 2022-12-25 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Washington, US | |
3225797 | 3225797 | 2022-12-25 | US | Virginia | Highland | 51091 | 477 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-26 04:21:06 | Highland, Virginia, US | |
3225631 | 3225631 | 2022-12-25 | US | Texas | Oldham | 48359 | 623 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-12-26 04:21:06 | Oldham, Texas, US | |
3225317 | 3225317 | 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 | |
3225076 | 3225076 | 2022-12-25 | US | Oregon | Sherman | 41055 | 383 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-12-26 04:21:06 | Sherman, Oregon, US | |
3225059 | 3225059 | 2022-12-25 | US | Oregon | Gilliam | 41021 | 317 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-12-26 04:21:06 | Gilliam, Oregon, US | |
3224839 | 3224839 | 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 | |
3224633 | 3224633 | 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 | |
3224520 | 3224520 | 2022-12-25 | US | Nebraska | Greeley | 31077 | 452 | 6 | 0 | 41.56742671 | -98.52150266 | 2022-12-26 04:21:06 | Greeley, Nebraska, US | |
3224519 | 3224519 | 2022-12-25 | US | Nebraska | Grant | 31075 | 108 | 6 | 0 | 41.91528587 | -101.740701 | 2022-12-26 04:21:06 | Grant, Nebraska, US | |
3224510 | 3224510 | 2022-12-25 | US | Nebraska | Dundy | 31057 | 375 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-12-26 04:21:06 | Dundy, Nebraska, US | |
3224175 | 3224175 | 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 | |
3223734 | 3223734 | 2022-12-25 | US | Kansas | Greeley | 20071 | 389 | 6 | 0 | 38.4808095 | -101.8061079 | 2022-12-26 04:21:06 | Greeley, Kansas, US | |
3223408 | 3223408 | 2022-12-25 | US | Illinois | Calhoun | 17013 | 1865 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-26 04:21:06 | Calhoun, Illinois, US | |
3223085 | 3223085 | 2022-12-25 | US | Colorado | Ouray | 8091 | 1098 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-12-26 04:21:06 | Ouray, Colorado, US | |
3223070 | 3223070 | 2022-12-25 | US | Colorado | Kiowa | 8061 | 387 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-12-26 04:21:06 | Kiowa, Colorado, US | |
3222474 | 3222474 | 2022-12-25 | Korea, North | 1 | 6 | 0 | 40.3399 | 127.5101 | 2022-12-26 04:21:06 | Korea, North | ||||
3222320 | 3222320 | 2022-12-25 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-26 04:21:06 | Saint Barthelemy, France | |||
3222227 | 3222227 | 2022-12-25 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-26 04:21:06 | Hainan, China | |||
3222219 | 3222219 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);