johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
87,796 rows where deaths = 2 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 76,391
- China 5,381
- MS Zaandam 1,003
- Japan 887
- United Kingdom 562
- Malaysia 539
- India 323
- Chile 321
- Fiji 252
- Canada 211
- Mainland China 159
- Russia 136
- Belize 126
- France 120
- Spain 114
- Denmark 100
- Colombia 78
- Australia 57
- Monaco 53
- Angola 50
- Netherlands 50
- Burundi 48
- Mongolia 44
- West Bank and Gaza 37
- Saint Lucia 30
- Rwanda 29
- Bhutan 28
- Eswatini 26
- Djibouti 25
- Benin 20
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756115 | 2756115 | 2022-12-29 | US | Texas | Roberts | 48393 | 194 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-30 04:21:04 | Roberts, Texas, US | |
2756049 | 2756049 | 2022-12-29 | US | Texas | Kenedy | 48261 | 102 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-12-30 04:21:04 | Kenedy, Texas, US | |
2755935 | 2755935 | 2022-12-29 | US | Texas | Borden | 48033 | 119 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-12-30 04:21:04 | Borden, Texas, US | |
2755791 | 2755791 | 2022-12-29 | US | South Dakota | Jones | 46075 | 191 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-30 04:21:04 | Jones, South Dakota, US | |
2755706 | 2755706 | 2022-12-29 | US | Rhode Island | Unassigned | 90044 | 29535 | 2 | 0 | 41.87064746 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Rhode Island, US | |
2755338 | 2755338 | 2022-12-29 | US | North Dakota | Steele | 38091 | 426 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-30 04:21:04 | Steele, North Dakota, US | |
2755312 | 2755312 | 2022-12-29 | US | North Dakota | Griggs | 38039 | 668 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-12-30 04:21:04 | Griggs, North Dakota, US | |
2755185 | 2755185 | 2022-12-29 | US | New York | Unassigned | 90036 | 964 | 2 | 0 | 44.74530905 | 0.0 | 2022-12-30 04:21:04 | Unassigned, New York, US | |
2755049 | 2755049 | 2022-12-29 | US | Nevada | Eureka | 32011 | 188 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-12-30 04:21:04 | Eureka, Nevada, US | |
2755041 | 2755041 | 2022-12-29 | US | Nebraska | Wheeler | 31183 | 136 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-12-30 04:21:04 | Wheeler, Nebraska, US | |
2754952 | 2754952 | 2022-12-29 | US | Nebraska | Banner | 31007 | 99 | 2 | 0 | 41.54634427 | -103.7114332 | 2022-12-30 04:21:04 | Banner, Nebraska, US | |
2753836 | 2753836 | 2022-12-29 | US | Idaho | Camas | 16025 | 178 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-12-30 04:21:04 | Camas, Idaho, US | |
2753568 | 2753568 | 2022-12-29 | US | Colorado | Unassigned | 90008 | 220 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Colorado, US | |
2753540 | 2753540 | 2022-12-29 | US | Colorado | Lake | 8065 | 2169 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-12-30 04:21:04 | Lake, Colorado, US | |
2753329 | 2753329 | 2022-12-29 | US | Alaska | Denali | 2068 | 1800 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-12-30 04:21:04 | Denali, Alaska, US | |
2752955 | 2752955 | 2022-12-29 | MS Zaandam | 9 | 2 | 0 | 2022-12-30 04:21:04 | MS Zaandam | ||||||
2752788 | 2752788 | 2022-12-29 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-30 04:21:04 | Saint Pierre and Miquelon, France | |||
2752750 | 2752750 | 2022-12-29 | Colombia | Unknown | 0 | 2 | 0 | 2022-12-30 04:21:04 | Unknown, Colombia | |||||
2752718 | 2752718 | 2022-12-29 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-30 04:21:04 | Yunnan, China | |||
2752705 | 2752705 | 2022-12-29 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-30 04:21:04 | Liaoning, China | |||
2752693 | 2752693 | 2022-12-29 | China | Guizhou | 1794 | 2 | 0 | 26.8154 | 106.8748 | 2022-12-30 04:21:04 | Guizhou, China | |||
2752692 | 2752692 | 2022-12-29 | China | Guangxi | 2457 | 2 | 0 | 23.8298 | 108.7881 | 2022-12-30 04:21:04 | Guangxi, China | |||
2752690 | 2752690 | 2022-12-29 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-30 04:21:04 | Gansu, China | |||
2752684 | 2752684 | 2022-12-29 | Chile | Unknown | 42 | 2 | 0 | 2022-12-30 04:21:04 | Unknown, Chile | |||||
1077121 | 1077121 | 2022-12-28 | US | Texas | Roberts | 48393 | 194 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-29 04:21:01 | Roberts, Texas, US | |
1077055 | 1077055 | 2022-12-28 | US | Texas | Kenedy | 48261 | 102 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-12-29 04:21:01 | Kenedy, Texas, US | |
1076941 | 1076941 | 2022-12-28 | US | Texas | Borden | 48033 | 119 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-12-29 04:21:01 | Borden, Texas, US | |
1076797 | 1076797 | 2022-12-28 | US | South Dakota | Jones | 46075 | 191 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-29 04:21:01 | Jones, South Dakota, US | |
1076712 | 1076712 | 2022-12-28 | US | Rhode Island | Unassigned | 90044 | 29535 | 2 | 0 | 41.87064746 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Rhode Island, US | |
1076344 | 1076344 | 2022-12-28 | US | North Dakota | Steele | 38091 | 426 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-29 04:21:01 | Steele, North Dakota, US | |
1076318 | 1076318 | 2022-12-28 | US | North Dakota | Griggs | 38039 | 668 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-12-29 04:21:01 | Griggs, North Dakota, US | |
1076191 | 1076191 | 2022-12-28 | US | New York | Unassigned | 90036 | 963 | 2 | 0 | 44.74530905 | 0.0 | 2022-12-29 04:21:01 | Unassigned, New York, US | |
1076055 | 1076055 | 2022-12-28 | US | Nevada | Eureka | 32011 | 188 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-12-29 04:21:01 | Eureka, Nevada, US | |
1076047 | 1076047 | 2022-12-28 | US | Nebraska | Wheeler | 31183 | 136 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-12-29 04:21:01 | Wheeler, Nebraska, US | |
1075958 | 1075958 | 2022-12-28 | US | Nebraska | Banner | 31007 | 99 | 2 | 0 | 41.54634427 | -103.7114332 | 2022-12-29 04:21:01 | Banner, Nebraska, US | |
1074842 | 1074842 | 2022-12-28 | US | Idaho | Camas | 16025 | 178 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-12-29 04:21:01 | Camas, Idaho, US | |
1074574 | 1074574 | 2022-12-28 | US | Colorado | Unassigned | 90008 | 220 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Colorado, US | |
1074546 | 1074546 | 2022-12-28 | US | Colorado | Lake | 8065 | 2169 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-12-29 04:21:01 | Lake, Colorado, US | |
1074335 | 1074335 | 2022-12-28 | US | Alaska | Denali | 2068 | 1800 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-12-29 04:21:01 | Denali, Alaska, US | |
1073961 | 1073961 | 2022-12-28 | MS Zaandam | 9 | 2 | 0 | 2022-12-29 04:21:01 | MS Zaandam | ||||||
1073794 | 1073794 | 2022-12-28 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-29 04:21:01 | Saint Pierre and Miquelon, France | |||
1073724 | 1073724 | 2022-12-28 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-29 04:21:01 | Yunnan, China | |||
1073711 | 1073711 | 2022-12-28 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-29 04:21:01 | Liaoning, China | |||
1073699 | 1073699 | 2022-12-28 | China | Guizhou | 1794 | 2 | 0 | 26.8154 | 106.8748 | 2022-12-29 04:21:01 | Guizhou, China | |||
1073698 | 1073698 | 2022-12-28 | China | Guangxi | 2457 | 2 | 0 | 23.8298 | 108.7881 | 2022-12-29 04:21:01 | Guangxi, China | |||
1073696 | 1073696 | 2022-12-28 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-29 04:21:01 | Gansu, China | |||
1073690 | 1073690 | 2022-12-28 | Chile | Unknown | 42 | 2 | 0 | 2022-12-29 04:21:01 | Unknown, Chile | |||||
331118 | 331118 | 2022-12-27 | US | Texas | Roberts | 48393 | 191 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-28 04:21:04 | Roberts, Texas, US | |
331052 | 331052 | 2022-12-27 | US | Texas | Kenedy | 48261 | 101 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-12-28 04:21:04 | Kenedy, Texas, US | |
330938 | 330938 | 2022-12-27 | US | Texas | Borden | 48033 | 119 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-12-28 04:21:04 | Borden, Texas, US | |
330794 | 330794 | 2022-12-27 | US | South Dakota | Jones | 46075 | 191 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-28 04:21:04 | Jones, South Dakota, US | |
330709 | 330709 | 2022-12-27 | US | Rhode Island | Unassigned | 90044 | 29535 | 2 | 0 | 41.87064746 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Rhode Island, US | |
330341 | 330341 | 2022-12-27 | US | North Dakota | Steele | 38091 | 426 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-28 04:21:04 | Steele, North Dakota, US | |
330315 | 330315 | 2022-12-27 | US | North Dakota | Griggs | 38039 | 668 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-12-28 04:21:04 | Griggs, North Dakota, US | |
330188 | 330188 | 2022-12-27 | US | New York | Unassigned | 90036 | 964 | 2 | 0 | 44.74530905 | 0.0 | 2022-12-28 04:21:04 | Unassigned, New York, US | |
330052 | 330052 | 2022-12-27 | US | Nevada | Eureka | 32011 | 188 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-12-28 04:21:04 | Eureka, Nevada, US | |
330044 | 330044 | 2022-12-27 | US | Nebraska | Wheeler | 31183 | 136 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-12-28 04:21:04 | Wheeler, Nebraska, US | |
329955 | 329955 | 2022-12-27 | US | Nebraska | Banner | 31007 | 99 | 2 | 0 | 41.54634427 | -103.7114332 | 2022-12-28 04:21:04 | Banner, Nebraska, US | |
329156 | 329156 | 2022-12-27 | US | Iowa | Unassigned | 90019 | 1 | 2 | 0 | 43.38107862 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Iowa, US | |
328839 | 328839 | 2022-12-27 | US | Idaho | Camas | 16025 | 177 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-12-28 04:21:04 | Camas, Idaho, US | |
328571 | 328571 | 2022-12-27 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Colorado, US | |
328543 | 328543 | 2022-12-27 | US | Colorado | Lake | 8065 | 2169 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-12-28 04:21:04 | Lake, Colorado, US | |
328332 | 328332 | 2022-12-27 | US | Alaska | Denali | 2068 | 1800 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-12-28 04:21:04 | Denali, Alaska, US | |
327958 | 327958 | 2022-12-27 | MS Zaandam | 9 | 2 | 0 | 2022-12-28 04:21:04 | MS Zaandam | ||||||
327791 | 327791 | 2022-12-27 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-28 04:21:04 | Saint Pierre and Miquelon, France | |||
327721 | 327721 | 2022-12-27 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-28 04:21:04 | Yunnan, China | |||
327708 | 327708 | 2022-12-27 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-28 04:21:04 | Liaoning, China | |||
327696 | 327696 | 2022-12-27 | China | Guizhou | 1794 | 2 | 0 | 26.8154 | 106.8748 | 2022-12-28 04:21:04 | Guizhou, China | |||
327695 | 327695 | 2022-12-27 | China | Guangxi | 2457 | 2 | 0 | 23.8298 | 108.7881 | 2022-12-28 04:21:04 | Guangxi, China | |||
327693 | 327693 | 2022-12-27 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-28 04:21:04 | Gansu, China | |||
327687 | 327687 | 2022-12-27 | Chile | Unknown | 42 | 2 | 0 | 2022-12-28 04:21:04 | Unknown, Chile | |||||
221191 | 221191 | 2022-12-26 | US | Texas | Roberts | 48393 | 191 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-27 04:21:07 | Roberts, Texas, US | |
221125 | 221125 | 2022-12-26 | US | Texas | Kenedy | 48261 | 101 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-12-27 04:21:07 | Kenedy, Texas, US | |
221011 | 221011 | 2022-12-26 | US | Texas | Borden | 48033 | 119 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-12-27 04:21:07 | Borden, Texas, US | |
220867 | 220867 | 2022-12-26 | US | South Dakota | Jones | 46075 | 191 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-27 04:21:07 | Jones, South Dakota, US | |
220782 | 220782 | 2022-12-26 | US | Rhode Island | Unassigned | 90044 | 29535 | 2 | 0 | 41.87064746 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Rhode Island, US | |
220414 | 220414 | 2022-12-26 | US | North Dakota | Steele | 38091 | 426 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-12-27 04:21:07 | Steele, North Dakota, US | |
220388 | 220388 | 2022-12-26 | US | North Dakota | Griggs | 38039 | 668 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-12-27 04:21:07 | Griggs, North Dakota, US | |
220261 | 220261 | 2022-12-26 | US | New York | Unassigned | 90036 | 967 | 2 | 0 | 44.74530905 | 0.0 | 2022-12-27 04:21:07 | Unassigned, New York, US | |
220125 | 220125 | 2022-12-26 | US | Nevada | Eureka | 32011 | 188 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-12-27 04:21:07 | Eureka, Nevada, US | |
220117 | 220117 | 2022-12-26 | US | Nebraska | Wheeler | 31183 | 136 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-12-27 04:21:07 | Wheeler, Nebraska, US | |
220028 | 220028 | 2022-12-26 | US | Nebraska | Banner | 31007 | 99 | 2 | 0 | 41.54634427 | -103.7114332 | 2022-12-27 04:21:07 | Banner, Nebraska, US | |
219229 | 219229 | 2022-12-26 | US | Iowa | Unassigned | 90019 | 1 | 2 | 0 | 43.38107862 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Iowa, US | |
218912 | 218912 | 2022-12-26 | US | Idaho | Camas | 16025 | 177 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-12-27 04:21:07 | Camas, Idaho, US | |
218644 | 218644 | 2022-12-26 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Colorado, US | |
218616 | 218616 | 2022-12-26 | US | Colorado | Lake | 8065 | 2168 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-12-27 04:21:07 | Lake, Colorado, US | |
218405 | 218405 | 2022-12-26 | US | Alaska | Denali | 2068 | 1800 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-12-27 04:21:07 | Denali, Alaska, US | |
218031 | 218031 | 2022-12-26 | MS Zaandam | 9 | 2 | 0 | 2022-12-27 04:21:07 | MS Zaandam | ||||||
217864 | 217864 | 2022-12-26 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-27 04:21:07 | Saint Pierre and Miquelon, France | |||
217794 | 217794 | 2022-12-26 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-27 04:21:07 | Yunnan, China | |||
217781 | 217781 | 2022-12-26 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-27 04:21:07 | Liaoning, China | |||
217769 | 217769 | 2022-12-26 | China | Guizhou | 1794 | 2 | 0 | 26.8154 | 106.8748 | 2022-12-27 04:21:07 | Guizhou, China | |||
217768 | 217768 | 2022-12-26 | China | Guangxi | 2457 | 2 | 0 | 23.8298 | 108.7881 | 2022-12-27 04:21:07 | Guangxi, China | |||
217766 | 217766 | 2022-12-26 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-27 04:21:07 | Gansu, China | |||
217760 | 217760 | 2022-12-26 | Chile | Unknown | 42 | 2 | 0 | 2022-12-27 04:21:07 | Unknown, Chile | |||||
3225648 | 3225648 | 2022-12-25 | US | Texas | Roberts | 48393 | 191 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-26 04:21:06 | Roberts, Texas, US | |
3225582 | 3225582 | 2022-12-25 | US | Texas | Kenedy | 48261 | 101 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-12-26 04:21:06 | Kenedy, Texas, US | |
3225468 | 3225468 | 2022-12-25 | US | Texas | Borden | 48033 | 119 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-12-26 04:21:06 | Borden, Texas, US | |
3225324 | 3225324 | 2022-12-25 | US | South Dakota | Jones | 46075 | 191 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-26 04:21:06 | Jones, South Dakota, US | |
3225239 | 3225239 | 2022-12-25 | US | Rhode Island | Unassigned | 90044 | 29535 | 2 | 0 | 41.87064746 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Rhode Island, 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]);