johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
70,346 rows where deaths = 3 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 61,175
- China 4,484
- Japan 903
- Australia 542
- Brunei 435
- Malaysia 366
- Netherlands 303
- Canada 215
- Antigua and Barbuda 212
- Bhutan 169
- France 144
- Russia 124
- Ukraine 109
- Mainland China 103
- Saint Kitts and Nevis 72
- Monaco 60
- United Kingdom 59
- India 53
- Laos 48
- Burundi 44
- Colombia 40
- West Bank and Gaza 37
- Syria 33
- Malawi 32
- Libya 27
- Ethiopia 25
- Benin 18
- Botswana 17
- Zambia 17
- Malta 14
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756365 | 2756365 | 2022-12-29 | US | Washington | San Juan | 53055 | 1923 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-30 04:21:04 | San Juan, Washington, US | |
2756140 | 2756140 | 2022-12-29 | US | Texas | Terrell | 48443 | 137 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-12-30 04:21:04 | Terrell, Texas, US | |
2756036 | 2756036 | 2022-12-29 | US | Texas | Irion | 48235 | 586 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-30 04:21:04 | Irion, Texas, US | |
2756021 | 2756021 | 2022-12-29 | US | Texas | Hartley | 48205 | 1484 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-30 04:21:04 | Hartley, Texas, US | |
2756005 | 2756005 | 2022-12-29 | US | Texas | Glasscock | 48173 | 224 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-30 04:21:04 | Glasscock, Texas, US | |
2755813 | 2755813 | 2022-12-29 | US | South Dakota | Sully | 46119 | 263 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-12-30 04:21:04 | Sully, South Dakota, US | |
2755785 | 2755785 | 2022-12-29 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-30 04:21:04 | Harding, South Dakota, US | |
2755551 | 2755551 | 2022-12-29 | US | Oregon | Wheeler | 41069 | 303 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-12-30 04:21:04 | Wheeler, Oregon, US | |
2755299 | 2755299 | 2022-12-29 | US | North Dakota | Burke | 38013 | 483 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-12-30 04:21:04 | Burke, North Dakota, US | |
2755023 | 2755023 | 2022-12-29 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-30 04:21:04 | Rock, Nebraska, US | |
2754908 | 2754908 | 2022-12-29 | US | Montana | Garfield | 30033 | 250 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-12-30 04:21:04 | Garfield, Montana, US | |
2753816 | 2753816 | 2022-12-29 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2753322 | 2753322 | 2022-12-29 | US | Alaska | Aleutians West | 2016 | 1897 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-30 04:21:04 | Aleutians West, Alaska, US | |
2752717 | 2752717 | 2022-12-29 | China | Xinjiang | 2632 | 3 | 0 | 41.1129 | 85.2401 | 2022-12-30 04:21:04 | Xinjiang, China | |||
2752714 | 2752714 | 2022-12-29 | China | Tianjin | 2913 | 3 | 0 | 39.3054 | 117.323 | 2022-12-30 04:21:04 | Tianjin, China | |||
2752709 | 2752709 | 2022-12-29 | China | Shaanxi | 5589 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-30 04:21:04 | Shaanxi, China | |||
1077371 | 1077371 | 2022-12-28 | US | Washington | San Juan | 53055 | 1923 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-29 04:21:01 | San Juan, Washington, US | |
1077146 | 1077146 | 2022-12-28 | US | Texas | Terrell | 48443 | 137 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-12-29 04:21:01 | Terrell, Texas, US | |
1077042 | 1077042 | 2022-12-28 | US | Texas | Irion | 48235 | 586 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-29 04:21:01 | Irion, Texas, US | |
1077027 | 1077027 | 2022-12-28 | US | Texas | Hartley | 48205 | 1484 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-29 04:21:01 | Hartley, Texas, US | |
1077011 | 1077011 | 2022-12-28 | US | Texas | Glasscock | 48173 | 224 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-29 04:21:01 | Glasscock, Texas, US | |
1076819 | 1076819 | 2022-12-28 | US | South Dakota | Sully | 46119 | 263 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-12-29 04:21:01 | Sully, South Dakota, US | |
1076791 | 1076791 | 2022-12-28 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-29 04:21:01 | Harding, South Dakota, US | |
1076557 | 1076557 | 2022-12-28 | US | Oregon | Wheeler | 41069 | 303 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-12-29 04:21:01 | Wheeler, Oregon, US | |
1076305 | 1076305 | 2022-12-28 | US | North Dakota | Burke | 38013 | 483 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-12-29 04:21:01 | Burke, North Dakota, US | |
1076029 | 1076029 | 2022-12-28 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-29 04:21:01 | Rock, Nebraska, US | |
1075914 | 1075914 | 2022-12-28 | US | Montana | Garfield | 30033 | 250 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-12-29 04:21:01 | Garfield, Montana, US | |
1074822 | 1074822 | 2022-12-28 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
1074328 | 1074328 | 2022-12-28 | US | Alaska | Aleutians West | 2016 | 1897 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-29 04:21:01 | Aleutians West, Alaska, US | |
1073723 | 1073723 | 2022-12-28 | China | Xinjiang | 2632 | 3 | 0 | 41.1129 | 85.2401 | 2022-12-29 04:21:01 | Xinjiang, China | |||
1073720 | 1073720 | 2022-12-28 | China | Tianjin | 2913 | 3 | 0 | 39.3054 | 117.323 | 2022-12-29 04:21:01 | Tianjin, China | |||
1073715 | 1073715 | 2022-12-28 | China | Shaanxi | 5589 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-29 04:21:01 | Shaanxi, China | |||
331368 | 331368 | 2022-12-27 | US | Washington | San Juan | 53055 | 1917 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-28 04:21:04 | San Juan, Washington, US | |
331143 | 331143 | 2022-12-27 | US | Texas | Terrell | 48443 | 136 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-12-28 04:21:04 | Terrell, Texas, US | |
331039 | 331039 | 2022-12-27 | US | Texas | Irion | 48235 | 583 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-28 04:21:04 | Irion, Texas, US | |
331024 | 331024 | 2022-12-27 | US | Texas | Hartley | 48205 | 1481 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-28 04:21:04 | Hartley, Texas, US | |
331008 | 331008 | 2022-12-27 | US | Texas | Glasscock | 48173 | 224 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-28 04:21:04 | Glasscock, Texas, US | |
330816 | 330816 | 2022-12-27 | US | South Dakota | Sully | 46119 | 263 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-12-28 04:21:04 | Sully, South Dakota, US | |
330788 | 330788 | 2022-12-27 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-28 04:21:04 | Harding, South Dakota, US | |
330554 | 330554 | 2022-12-27 | US | Oregon | Wheeler | 41069 | 301 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-12-28 04:21:04 | Wheeler, Oregon, US | |
330302 | 330302 | 2022-12-27 | US | North Dakota | Burke | 38013 | 483 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-12-28 04:21:04 | Burke, North Dakota, US | |
330026 | 330026 | 2022-12-27 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-28 04:21:04 | Rock, Nebraska, US | |
329911 | 329911 | 2022-12-27 | US | Montana | Garfield | 30033 | 250 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-12-28 04:21:04 | Garfield, Montana, US | |
328819 | 328819 | 2022-12-27 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
328325 | 328325 | 2022-12-27 | US | Alaska | Aleutians West | 2016 | 1897 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-28 04:21:04 | Aleutians West, Alaska, US | |
327720 | 327720 | 2022-12-27 | China | Xinjiang | 2632 | 3 | 0 | 41.1129 | 85.2401 | 2022-12-28 04:21:04 | Xinjiang, China | |||
327717 | 327717 | 2022-12-27 | China | Tianjin | 2913 | 3 | 0 | 39.3054 | 117.323 | 2022-12-28 04:21:04 | Tianjin, China | |||
327712 | 327712 | 2022-12-27 | China | Shaanxi | 5589 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-28 04:21:04 | Shaanxi, China | |||
221441 | 221441 | 2022-12-26 | US | Washington | San Juan | 53055 | 1917 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-27 04:21:07 | San Juan, Washington, US | |
221216 | 221216 | 2022-12-26 | US | Texas | Terrell | 48443 | 136 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-12-27 04:21:07 | Terrell, Texas, US | |
221112 | 221112 | 2022-12-26 | US | Texas | Irion | 48235 | 583 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-27 04:21:07 | Irion, Texas, US | |
221097 | 221097 | 2022-12-26 | US | Texas | Hartley | 48205 | 1481 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-27 04:21:07 | Hartley, Texas, US | |
221081 | 221081 | 2022-12-26 | US | Texas | Glasscock | 48173 | 224 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-27 04:21:07 | Glasscock, Texas, US | |
220889 | 220889 | 2022-12-26 | US | South Dakota | Sully | 46119 | 263 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-12-27 04:21:07 | Sully, South Dakota, US | |
220861 | 220861 | 2022-12-26 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-27 04:21:07 | Harding, South Dakota, US | |
220627 | 220627 | 2022-12-26 | US | Oregon | Wheeler | 41069 | 301 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-12-27 04:21:07 | Wheeler, Oregon, US | |
220375 | 220375 | 2022-12-26 | US | North Dakota | Burke | 38013 | 483 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-12-27 04:21:07 | Burke, North Dakota, US | |
220099 | 220099 | 2022-12-26 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-27 04:21:07 | Rock, Nebraska, US | |
219984 | 219984 | 2022-12-26 | US | Montana | Garfield | 30033 | 250 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-12-27 04:21:07 | Garfield, Montana, US | |
218892 | 218892 | 2022-12-26 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
218398 | 218398 | 2022-12-26 | US | Alaska | Aleutians West | 2016 | 1895 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-27 04:21:07 | Aleutians West, Alaska, US | |
217793 | 217793 | 2022-12-26 | China | Xinjiang | 2632 | 3 | 0 | 41.1129 | 85.2401 | 2022-12-27 04:21:07 | Xinjiang, China | |||
217790 | 217790 | 2022-12-26 | China | Tianjin | 2913 | 3 | 0 | 39.3054 | 117.323 | 2022-12-27 04:21:07 | Tianjin, China | |||
217785 | 217785 | 2022-12-26 | China | Shaanxi | 5589 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-27 04:21:07 | Shaanxi, China | |||
3225898 | 3225898 | 2022-12-25 | US | Washington | San Juan | 53055 | 1917 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-26 04:21:06 | San Juan, Washington, US | |
3225673 | 3225673 | 2022-12-25 | US | Texas | Terrell | 48443 | 136 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-12-26 04:21:06 | Terrell, Texas, US | |
3225569 | 3225569 | 2022-12-25 | US | Texas | Irion | 48235 | 583 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-26 04:21:06 | Irion, Texas, US | |
3225554 | 3225554 | 2022-12-25 | US | Texas | Hartley | 48205 | 1481 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-26 04:21:06 | Hartley, Texas, US | |
3225538 | 3225538 | 2022-12-25 | US | Texas | Glasscock | 48173 | 224 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-26 04:21:06 | Glasscock, Texas, US | |
3225346 | 3225346 | 2022-12-25 | US | South Dakota | Sully | 46119 | 263 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-12-26 04:21:06 | Sully, South Dakota, US | |
3225318 | 3225318 | 2022-12-25 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-26 04:21:06 | Harding, South Dakota, US | |
3225084 | 3225084 | 2022-12-25 | US | Oregon | Wheeler | 41069 | 301 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-12-26 04:21:06 | Wheeler, Oregon, US | |
3224832 | 3224832 | 2022-12-25 | US | North Dakota | Burke | 38013 | 483 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-12-26 04:21:06 | Burke, North Dakota, US | |
3224556 | 3224556 | 2022-12-25 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-26 04:21:06 | Rock, Nebraska, US | |
3224441 | 3224441 | 2022-12-25 | US | Montana | Garfield | 30033 | 250 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-12-26 04:21:06 | Garfield, Montana, US | |
3223349 | 3223349 | 2022-12-25 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
3222855 | 3222855 | 2022-12-25 | US | Alaska | Aleutians West | 2016 | 1895 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-26 04:21:06 | Aleutians West, Alaska, US | |
3222250 | 3222250 | 2022-12-25 | China | Xinjiang | 2632 | 3 | 0 | 41.1129 | 85.2401 | 2022-12-26 04:21:06 | Xinjiang, China | |||
3222247 | 3222247 | 2022-12-25 | China | Tianjin | 2913 | 3 | 0 | 39.3054 | 117.323 | 2022-12-26 04:21:06 | Tianjin, China | |||
3222242 | 3222242 | 2022-12-25 | China | Shaanxi | 5589 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-26 04:21:06 | Shaanxi, China | |||
1021812 | 1021812 | 2022-12-24 | US | Washington | San Juan | 53055 | 1917 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-25 04:21:04 | San Juan, Washington, US | |
1021587 | 1021587 | 2022-12-24 | US | Texas | Terrell | 48443 | 136 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-12-25 04:21:04 | Terrell, Texas, US | |
1021483 | 1021483 | 2022-12-24 | US | Texas | Irion | 48235 | 583 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-25 04:21:04 | Irion, Texas, US | |
1021468 | 1021468 | 2022-12-24 | US | Texas | Hartley | 48205 | 1481 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-25 04:21:04 | Hartley, Texas, US | |
1021452 | 1021452 | 2022-12-24 | US | Texas | Glasscock | 48173 | 224 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-25 04:21:04 | Glasscock, Texas, US | |
1021260 | 1021260 | 2022-12-24 | US | South Dakota | Sully | 46119 | 263 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-12-25 04:21:04 | Sully, South Dakota, US | |
1021232 | 1021232 | 2022-12-24 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-25 04:21:04 | Harding, South Dakota, US | |
1020998 | 1020998 | 2022-12-24 | US | Oregon | Wheeler | 41069 | 301 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-12-25 04:21:04 | Wheeler, Oregon, US | |
1020746 | 1020746 | 2022-12-24 | US | North Dakota | Burke | 38013 | 483 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-12-25 04:21:04 | Burke, North Dakota, US | |
1020470 | 1020470 | 2022-12-24 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-25 04:21:04 | Rock, Nebraska, US | |
1020355 | 1020355 | 2022-12-24 | US | Montana | Garfield | 30033 | 250 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-12-25 04:21:04 | Garfield, Montana, US | |
1019263 | 1019263 | 2022-12-24 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
1018769 | 1018769 | 2022-12-24 | US | Alaska | Aleutians West | 2016 | 1895 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-25 04:21:04 | Aleutians West, Alaska, US | |
1018164 | 1018164 | 2022-12-24 | China | Xinjiang | 2632 | 3 | 0 | 41.1129 | 85.2401 | 2022-12-25 04:21:04 | Xinjiang, China | |||
1018161 | 1018161 | 2022-12-24 | China | Tianjin | 2913 | 3 | 0 | 39.3054 | 117.323 | 2022-12-25 04:21:04 | Tianjin, China | |||
1018156 | 1018156 | 2022-12-24 | China | Shaanxi | 5589 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-25 04:21:04 | Shaanxi, China | |||
693835 | 693835 | 2022-12-23 | US | Washington | San Juan | 53055 | 1917 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-24 04:21:02 | San Juan, Washington, US | |
693610 | 693610 | 2022-12-23 | US | Texas | Terrell | 48443 | 136 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-12-24 04:21:02 | Terrell, Texas, US | |
693506 | 693506 | 2022-12-23 | US | Texas | Irion | 48235 | 583 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-24 04:21:02 | Irion, Texas, US | |
693491 | 693491 | 2022-12-23 | US | Texas | Hartley | 48205 | 1481 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-24 04:21:02 | Hartley, Texas, 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]);