johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33,917 rows where deaths = 13 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 29,595
- China 1,061
- Diamond Princess 987
- Australia 639
- Kiribati 297
- Japan 268
- Colombia 203
- Malaysia 144
- Ukraine 86
- Russia 69
- Canada 59
- France 54
- Chile 46
- Denmark 39
- Sri Lanka 38
- India 32
- Togo 30
- Netherlands 22
- Mainland China 15
- Sao Tome and Principe 15
- United Kingdom 12
- Georgia 11
- Paraguay 11
- Peru 10
- Vanuatu 9
- Spain 8
- Uzbekistan 8
- Botswana 7
- Samoa 7
- Belize 6
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756307 | 2756307 | 2022-12-29 | US | Virginia | Rappahannock | 51157 | 1325 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-12-30 04:21:04 | Rappahannock, Virginia, US | |
2756091 | 2756091 | 2022-12-29 | US | Texas | Motley | 48345 | 316 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-30 04:21:04 | Motley, Texas, US | |
2756075 | 2756075 | 2022-12-29 | US | Texas | Mason | 48319 | 1003 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-12-30 04:21:04 | Mason, Texas, US | |
2756054 | 2756054 | 2022-12-29 | US | Texas | Kinney | 48271 | 818 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-30 04:21:04 | Kinney, Texas, US | |
2755796 | 2755796 | 2022-12-29 | US | South Dakota | Lyman | 46085 | 1394 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-30 04:21:04 | Lyman, South Dakota, US | |
2755783 | 2755783 | 2022-12-29 | US | South Dakota | Hand | 46059 | 651 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-12-30 04:21:04 | Hand, South Dakota, US | |
2755466 | 2755466 | 2022-12-29 | US | Oklahoma | Harper | 40059 | 822 | 13 | 0 | 36.78836519 | -99.6679804 | 2022-12-30 04:21:04 | Harper, Oklahoma, US | |
2755314 | 2755314 | 2022-12-29 | US | North Dakota | Kidder | 38043 | 587 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-30 04:21:04 | Kidder, North Dakota, US | |
2755033 | 2755033 | 2022-12-29 | US | Nebraska | Thayer | 31169 | 1267 | 13 | 0 | 40.17626377 | -97.59504381 | 2022-12-30 04:21:04 | Thayer, Nebraska, US | |
2755032 | 2755032 | 2022-12-29 | US | Nebraska | Stanton | 31167 | 721 | 13 | 0 | 41.9169835 | -97.19394708 | 2022-12-30 04:21:04 | Stanton, Nebraska, US | |
2755016 | 2755016 | 2022-12-29 | US | Nebraska | Perkins | 31135 | 567 | 13 | 0 | 40.85082525 | -101.6502942 | 2022-12-30 04:21:04 | Perkins, Nebraska, US | |
2754998 | 2754998 | 2022-12-29 | US | Nebraska | Kearney | 31099 | 1346 | 13 | 0 | 40.50663314 | -98.94877182 | 2022-12-30 04:21:04 | Kearney, Nebraska, US | |
2754996 | 2754996 | 2022-12-29 | US | Nebraska | Jefferson | 31095 | 1405 | 13 | 0 | 40.17584531 | -97.142601 | 2022-12-30 04:21:04 | Jefferson, Nebraska, US | |
2754956 | 2754956 | 2022-12-29 | US | Nebraska | Boyd | 31015 | 451 | 13 | 0 | 42.8997274 | -98.76486568 | 2022-12-30 04:21:04 | Boyd, Nebraska, US | |
2754940 | 2754940 | 2022-12-29 | US | Montana | Sweet Grass | 30097 | 900 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-30 04:21:04 | Sweet Grass, Montana, US | |
2754937 | 2754937 | 2022-12-29 | US | Montana | Sheridan | 30091 | 887 | 13 | 0 | 48.72085833 | -104.503829 | 2022-12-30 04:21:04 | Sheridan, Montana, US | |
2754448 | 2754448 | 2022-12-29 | US | Louisiana | Tensas | 22107 | 1292 | 13 | 0 | 32.00760749 | -91.32915234 | 2022-12-30 04:21:04 | Tensas, Louisiana, US | |
2754264 | 2754264 | 2022-12-29 | US | Kansas | Trego | 20195 | 903 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-30 04:21:04 | Trego, Kansas, US | |
2754220 | 2754220 | 2022-12-29 | US | Kansas | Logan | 20109 | 1008 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-30 04:21:04 | Logan, Kansas, US | |
2754207 | 2754207 | 2022-12-29 | US | Kansas | Hodgeman | 20083 | 491 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-30 04:21:04 | Hodgeman, Kansas, US | |
2753565 | 2753565 | 2022-12-29 | US | Colorado | Sedgwick | 8115 | 571 | 13 | 0 | 40.87595412 | -102.3519227 | 2022-12-30 04:21:04 | Sedgwick, Colorado, US | |
2753516 | 2753516 | 2022-12-29 | US | Colorado | Clear Creek | 8019 | 1905 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-12-30 04:21:04 | Clear Creek, Colorado, US | |
2753478 | 2753478 | 2022-12-29 | US | California | Plumas | 6063 | 4239 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-30 04:21:04 | Plumas, California, US | |
2753330 | 2753330 | 2022-12-29 | US | Alaska | Dillingham | 2070 | 2214 | 13 | 0 | 59.79603738 | -158.2381942 | 2022-12-30 04:21:04 | Dillingham, Alaska, US | |
2753327 | 2753327 | 2022-12-29 | US | Alaska | Chugach | 2063 | 2390 | 13 | 0 | 61.16666 | -149.9 | 2022-12-30 04:21:04 | Chugach, Alaska, US | |
2752940 | 2752940 | 2022-12-29 | Kiribati | 3430 | 13 | 0 | -3.3704 | -168.734 | 2022-12-30 04:21:04 | Kiribati | ||||
2752766 | 2752766 | 2022-12-29 | Diamond Princess | 712 | 13 | 0 | 2022-12-30 04:21:04 | Diamond Princess | ||||||
2752706 | 2752706 | 2022-12-29 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-30 04:21:04 | Macau, China | |||
2752696 | 2752696 | 2022-12-29 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-30 04:21:04 | Heilongjiang, China | |||
1077313 | 1077313 | 2022-12-28 | US | Virginia | Rappahannock | 51157 | 1325 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-12-29 04:21:01 | Rappahannock, Virginia, US | |
1077097 | 1077097 | 2022-12-28 | US | Texas | Motley | 48345 | 316 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-29 04:21:01 | Motley, Texas, US | |
1077081 | 1077081 | 2022-12-28 | US | Texas | Mason | 48319 | 1003 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-12-29 04:21:01 | Mason, Texas, US | |
1077060 | 1077060 | 2022-12-28 | US | Texas | Kinney | 48271 | 818 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-29 04:21:01 | Kinney, Texas, US | |
1076802 | 1076802 | 2022-12-28 | US | South Dakota | Lyman | 46085 | 1394 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-29 04:21:01 | Lyman, South Dakota, US | |
1076789 | 1076789 | 2022-12-28 | US | South Dakota | Hand | 46059 | 651 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-12-29 04:21:01 | Hand, South Dakota, US | |
1076472 | 1076472 | 2022-12-28 | US | Oklahoma | Harper | 40059 | 819 | 13 | 0 | 36.78836519 | -99.6679804 | 2022-12-29 04:21:01 | Harper, Oklahoma, US | |
1076320 | 1076320 | 2022-12-28 | US | North Dakota | Kidder | 38043 | 587 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-29 04:21:01 | Kidder, North Dakota, US | |
1076039 | 1076039 | 2022-12-28 | US | Nebraska | Thayer | 31169 | 1267 | 13 | 0 | 40.17626377 | -97.59504381 | 2022-12-29 04:21:01 | Thayer, Nebraska, US | |
1076038 | 1076038 | 2022-12-28 | US | Nebraska | Stanton | 31167 | 721 | 13 | 0 | 41.9169835 | -97.19394708 | 2022-12-29 04:21:01 | Stanton, Nebraska, US | |
1076022 | 1076022 | 2022-12-28 | US | Nebraska | Perkins | 31135 | 567 | 13 | 0 | 40.85082525 | -101.6502942 | 2022-12-29 04:21:01 | Perkins, Nebraska, US | |
1076004 | 1076004 | 2022-12-28 | US | Nebraska | Kearney | 31099 | 1346 | 13 | 0 | 40.50663314 | -98.94877182 | 2022-12-29 04:21:01 | Kearney, Nebraska, US | |
1076002 | 1076002 | 2022-12-28 | US | Nebraska | Jefferson | 31095 | 1405 | 13 | 0 | 40.17584531 | -97.142601 | 2022-12-29 04:21:01 | Jefferson, Nebraska, US | |
1075962 | 1075962 | 2022-12-28 | US | Nebraska | Boyd | 31015 | 451 | 13 | 0 | 42.8997274 | -98.76486568 | 2022-12-29 04:21:01 | Boyd, Nebraska, US | |
1075946 | 1075946 | 2022-12-28 | US | Montana | Sweet Grass | 30097 | 900 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-29 04:21:01 | Sweet Grass, Montana, US | |
1075943 | 1075943 | 2022-12-28 | US | Montana | Sheridan | 30091 | 887 | 13 | 0 | 48.72085833 | -104.503829 | 2022-12-29 04:21:01 | Sheridan, Montana, US | |
1075454 | 1075454 | 2022-12-28 | US | Louisiana | Tensas | 22107 | 1292 | 13 | 0 | 32.00760749 | -91.32915234 | 2022-12-29 04:21:01 | Tensas, Louisiana, US | |
1075270 | 1075270 | 2022-12-28 | US | Kansas | Trego | 20195 | 903 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-29 04:21:01 | Trego, Kansas, US | |
1075226 | 1075226 | 2022-12-28 | US | Kansas | Logan | 20109 | 1008 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-29 04:21:01 | Logan, Kansas, US | |
1075213 | 1075213 | 2022-12-28 | US | Kansas | Hodgeman | 20083 | 491 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-29 04:21:01 | Hodgeman, Kansas, US | |
1074571 | 1074571 | 2022-12-28 | US | Colorado | Sedgwick | 8115 | 571 | 13 | 0 | 40.87595412 | -102.3519227 | 2022-12-29 04:21:01 | Sedgwick, Colorado, US | |
1074522 | 1074522 | 2022-12-28 | US | Colorado | Clear Creek | 8019 | 1905 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-12-29 04:21:01 | Clear Creek, Colorado, US | |
1074484 | 1074484 | 2022-12-28 | US | California | Plumas | 6063 | 4239 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-29 04:21:01 | Plumas, California, US | |
1074336 | 1074336 | 2022-12-28 | US | Alaska | Dillingham | 2070 | 2214 | 13 | 0 | 59.79603738 | -158.2381942 | 2022-12-29 04:21:01 | Dillingham, Alaska, US | |
1074333 | 1074333 | 2022-12-28 | US | Alaska | Chugach | 2063 | 2390 | 13 | 0 | 61.16666 | -149.9 | 2022-12-29 04:21:01 | Chugach, Alaska, US | |
1073946 | 1073946 | 2022-12-28 | Kiribati | 3430 | 13 | 0 | -3.3704 | -168.734 | 2022-12-29 04:21:01 | Kiribati | ||||
1073772 | 1073772 | 2022-12-28 | Diamond Princess | 712 | 13 | 0 | 2022-12-29 04:21:01 | Diamond Princess | ||||||
1073712 | 1073712 | 2022-12-28 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-29 04:21:01 | Macau, China | |||
1073702 | 1073702 | 2022-12-28 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-29 04:21:01 | Heilongjiang, China | |||
331442 | 331442 | 2022-12-27 | US | Wisconsin | Buffalo | 55011 | 4128 | 13 | 0 | 44.37835084 | -91.75332578 | 2022-12-28 04:21:04 | Buffalo, Wisconsin, US | |
331310 | 331310 | 2022-12-27 | US | Virginia | Rappahannock | 51157 | 1320 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-12-28 04:21:04 | Rappahannock, Virginia, US | |
331094 | 331094 | 2022-12-27 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-28 04:21:04 | Motley, Texas, US | |
331078 | 331078 | 2022-12-27 | US | Texas | Mason | 48319 | 992 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-12-28 04:21:04 | Mason, Texas, US | |
331057 | 331057 | 2022-12-27 | US | Texas | Kinney | 48271 | 815 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-28 04:21:04 | Kinney, Texas, US | |
330799 | 330799 | 2022-12-27 | US | South Dakota | Lyman | 46085 | 1393 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-28 04:21:04 | Lyman, South Dakota, US | |
330786 | 330786 | 2022-12-27 | US | South Dakota | Hand | 46059 | 649 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-12-28 04:21:04 | Hand, South Dakota, US | |
330469 | 330469 | 2022-12-27 | US | Oklahoma | Harper | 40059 | 819 | 13 | 0 | 36.78836519 | -99.6679804 | 2022-12-28 04:21:04 | Harper, Oklahoma, US | |
330317 | 330317 | 2022-12-27 | US | North Dakota | Kidder | 38043 | 587 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-28 04:21:04 | Kidder, North Dakota, US | |
330036 | 330036 | 2022-12-27 | US | Nebraska | Thayer | 31169 | 1267 | 13 | 0 | 40.17626377 | -97.59504381 | 2022-12-28 04:21:04 | Thayer, Nebraska, US | |
330035 | 330035 | 2022-12-27 | US | Nebraska | Stanton | 31167 | 721 | 13 | 0 | 41.9169835 | -97.19394708 | 2022-12-28 04:21:04 | Stanton, Nebraska, US | |
330019 | 330019 | 2022-12-27 | US | Nebraska | Perkins | 31135 | 567 | 13 | 0 | 40.85082525 | -101.6502942 | 2022-12-28 04:21:04 | Perkins, Nebraska, US | |
330001 | 330001 | 2022-12-27 | US | Nebraska | Kearney | 31099 | 1346 | 13 | 0 | 40.50663314 | -98.94877182 | 2022-12-28 04:21:04 | Kearney, Nebraska, US | |
329999 | 329999 | 2022-12-27 | US | Nebraska | Jefferson | 31095 | 1405 | 13 | 0 | 40.17584531 | -97.142601 | 2022-12-28 04:21:04 | Jefferson, Nebraska, US | |
329959 | 329959 | 2022-12-27 | US | Nebraska | Boyd | 31015 | 451 | 13 | 0 | 42.8997274 | -98.76486568 | 2022-12-28 04:21:04 | Boyd, Nebraska, US | |
329943 | 329943 | 2022-12-27 | US | Montana | Sweet Grass | 30097 | 900 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-28 04:21:04 | Sweet Grass, Montana, US | |
329940 | 329940 | 2022-12-27 | US | Montana | Sheridan | 30091 | 887 | 13 | 0 | 48.72085833 | -104.503829 | 2022-12-28 04:21:04 | Sheridan, Montana, US | |
329451 | 329451 | 2022-12-27 | US | Louisiana | Tensas | 22107 | 1281 | 13 | 0 | 32.00760749 | -91.32915234 | 2022-12-28 04:21:04 | Tensas, Louisiana, US | |
329267 | 329267 | 2022-12-27 | US | Kansas | Trego | 20195 | 896 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-28 04:21:04 | Trego, Kansas, US | |
329223 | 329223 | 2022-12-27 | US | Kansas | Logan | 20109 | 1007 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-28 04:21:04 | Logan, Kansas, US | |
329210 | 329210 | 2022-12-27 | US | Kansas | Hodgeman | 20083 | 491 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-28 04:21:04 | Hodgeman, Kansas, US | |
328568 | 328568 | 2022-12-27 | US | Colorado | Sedgwick | 8115 | 570 | 13 | 0 | 40.87595412 | -102.3519227 | 2022-12-28 04:21:04 | Sedgwick, Colorado, US | |
328519 | 328519 | 2022-12-27 | US | Colorado | Clear Creek | 8019 | 1905 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-12-28 04:21:04 | Clear Creek, Colorado, US | |
328481 | 328481 | 2022-12-27 | US | California | Plumas | 6063 | 4239 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-28 04:21:04 | Plumas, California, US | |
328333 | 328333 | 2022-12-27 | US | Alaska | Dillingham | 2070 | 2214 | 13 | 0 | 59.79603738 | -158.2381942 | 2022-12-28 04:21:04 | Dillingham, Alaska, US | |
328330 | 328330 | 2022-12-27 | US | Alaska | Chugach | 2063 | 2390 | 13 | 0 | 61.16666 | -149.9 | 2022-12-28 04:21:04 | Chugach, Alaska, US | |
327943 | 327943 | 2022-12-27 | Kiribati | 3430 | 13 | 0 | -3.3704 | -168.734 | 2022-12-28 04:21:04 | Kiribati | ||||
327769 | 327769 | 2022-12-27 | Diamond Princess | 712 | 13 | 0 | 2022-12-28 04:21:04 | Diamond Princess | ||||||
327709 | 327709 | 2022-12-27 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-28 04:21:04 | Macau, China | |||
327699 | 327699 | 2022-12-27 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-28 04:21:04 | Heilongjiang, China | |||
221515 | 221515 | 2022-12-26 | US | Wisconsin | Buffalo | 55011 | 4127 | 13 | 0 | 44.37835084 | -91.75332578 | 2022-12-27 04:21:07 | Buffalo, Wisconsin, US | |
221383 | 221383 | 2022-12-26 | US | Virginia | Rappahannock | 51157 | 1320 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-12-27 04:21:07 | Rappahannock, Virginia, US | |
221167 | 221167 | 2022-12-26 | US | Texas | Motley | 48345 | 312 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-27 04:21:07 | Motley, Texas, US | |
221151 | 221151 | 2022-12-26 | US | Texas | Mason | 48319 | 992 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-12-27 04:21:07 | Mason, Texas, US | |
221130 | 221130 | 2022-12-26 | US | Texas | Kinney | 48271 | 815 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-27 04:21:07 | Kinney, Texas, US | |
220872 | 220872 | 2022-12-26 | US | South Dakota | Lyman | 46085 | 1393 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-27 04:21:07 | Lyman, South Dakota, US | |
220859 | 220859 | 2022-12-26 | US | South Dakota | Hand | 46059 | 649 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-12-27 04:21:07 | Hand, South Dakota, US | |
220542 | 220542 | 2022-12-26 | US | Oklahoma | Harper | 40059 | 819 | 13 | 0 | 36.78836519 | -99.6679804 | 2022-12-27 04:21:07 | Harper, Oklahoma, US | |
220390 | 220390 | 2022-12-26 | US | North Dakota | Kidder | 38043 | 587 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-27 04:21:07 | Kidder, North Dakota, US | |
220109 | 220109 | 2022-12-26 | US | Nebraska | Thayer | 31169 | 1267 | 13 | 0 | 40.17626377 | -97.59504381 | 2022-12-27 04:21:07 | Thayer, Nebraska, US | |
220108 | 220108 | 2022-12-26 | US | Nebraska | Stanton | 31167 | 721 | 13 | 0 | 41.9169835 | -97.19394708 | 2022-12-27 04:21:07 | Stanton, Nebraska, US | |
220092 | 220092 | 2022-12-26 | US | Nebraska | Perkins | 31135 | 567 | 13 | 0 | 40.85082525 | -101.6502942 | 2022-12-27 04:21:07 | Perkins, Nebraska, US |
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]);