johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where deaths = 409 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753177 | 2753177 | 2022-12-29 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-30 04:21:04 | Saint Lucia | ||||
1075682 | 1075682 | 2022-12-28 | US | Minnesota | Stearns | 27145 | 60002 | 409 | 0 | 45.55192576 | -94.61078221 | 2022-12-29 04:21:01 | Stearns, Minnesota, US | |
1074183 | 1074183 | 2022-12-28 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-29 04:21:01 | Saint Lucia | ||||
1073920 | 1073920 | 2022-12-28 | Japan | Nagasaki | 275509 | 409 | 0 | 33.235712 | 129.608033 | 2022-12-29 04:21:01 | Nagasaki, Japan | |||
329679 | 329679 | 2022-12-27 | US | Minnesota | Stearns | 27145 | 60002 | 409 | 0 | 45.55192576 | -94.61078221 | 2022-12-28 04:21:04 | Stearns, Minnesota, US | |
328180 | 328180 | 2022-12-27 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-28 04:21:04 | Saint Lucia | ||||
219752 | 219752 | 2022-12-26 | US | Minnesota | Stearns | 27145 | 60002 | 409 | 0 | 45.55192576 | -94.61078221 | 2022-12-27 04:21:07 | Stearns, Minnesota, US | |
218253 | 218253 | 2022-12-26 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-27 04:21:07 | Saint Lucia | ||||
3224209 | 3224209 | 2022-12-25 | US | Minnesota | Stearns | 27145 | 60002 | 409 | 0 | 45.55192576 | -94.61078221 | 2022-12-26 04:21:06 | Stearns, Minnesota, US | |
3222710 | 3222710 | 2022-12-25 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-26 04:21:06 | Saint Lucia | ||||
1020123 | 1020123 | 2022-12-24 | US | Minnesota | Stearns | 27145 | 60002 | 409 | 0 | 45.55192576 | -94.61078221 | 2022-12-25 04:21:04 | Stearns, Minnesota, US | |
1018624 | 1018624 | 2022-12-24 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-25 04:21:04 | Saint Lucia | ||||
692146 | 692146 | 2022-12-23 | US | Minnesota | Stearns | 27145 | 60002 | 409 | 0 | 45.55192576 | -94.61078221 | 2022-12-24 04:21:02 | Stearns, Minnesota, US | |
690647 | 690647 | 2022-12-23 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-24 04:21:02 | Saint Lucia | ||||
2181356 | 2181356 | 2022-12-22 | US | Minnesota | Stearns | 27145 | 60002 | 409 | 0 | 45.55192576 | -94.61078221 | 2022-12-23 04:21:04 | Stearns, Minnesota, US | |
2179857 | 2179857 | 2022-12-22 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-23 04:21:04 | Saint Lucia | ||||
451661 | 451661 | 2022-12-21 | Saint Lucia | 29741 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-22 04:20:56 | Saint Lucia | ||||
2951660 | 2951660 | 2022-12-20 | Saint Lucia | 29736 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-21 04:21:03 | Saint Lucia | ||||
3174062 | 3174062 | 2022-12-19 | Saint Lucia | 29736 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-20 04:21:04 | Saint Lucia | ||||
1629789 | 1629789 | 2022-12-18 | US | Kentucky | Warren | 21227 | 52149 | 409 | 0 | 36.99903045 | -86.42672751 | 2022-12-19 04:21:03 | Warren, Kentucky, US | |
1628579 | 1628579 | 2022-12-18 | Saint Lucia | 29736 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-19 04:21:03 | Saint Lucia | ||||
505168 | 505168 | 2022-12-17 | US | Kentucky | Warren | 21227 | 52149 | 409 | 0 | 36.99903045 | -86.42672751 | 2022-12-18 04:21:03 | Warren, Kentucky, US | |
503958 | 503958 | 2022-12-17 | Saint Lucia | 29736 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-18 04:21:03 | Saint Lucia | ||||
3325740 | 3325740 | 2022-12-16 | US | Kentucky | Warren | 21227 | 52149 | 409 | 0 | 36.99903045 | -86.42672751 | 2022-12-17 04:21:04 | Warren, Kentucky, US | |
3324530 | 3324530 | 2022-12-16 | Saint Lucia | 29736 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-17 04:21:04 | Saint Lucia | ||||
544252 | 544252 | 2022-12-15 | US | Kentucky | Warren | 21227 | 52149 | 409 | 0 | 36.99903045 | -86.42672751 | 2022-12-16 04:21:01 | Warren, Kentucky, US | |
543042 | 543042 | 2022-12-15 | Saint Lucia | 29729 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-16 04:21:01 | Saint Lucia | ||||
349780 | 349780 | 2022-12-14 | US | Kentucky | Warren | 21227 | 52149 | 409 | 0 | 36.99903045 | -86.42672751 | 2022-12-15 04:20:58 | Warren, Kentucky, US | |
348570 | 348570 | 2022-12-14 | Saint Lucia | 29729 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-15 04:20:58 | Saint Lucia | ||||
309368 | 309368 | 2022-12-13 | US | Kentucky | Warren | 21227 | 52149 | 409 | 0 | 36.99903045 | -86.42672751 | 2022-12-14 04:21:04 | Warren, Kentucky, US | |
308777 | 308777 | 2022-12-13 | US | Georgia | Troup | 13285 | 18100 | 409 | 0 | 33.03349196 | -85.02812115 | 2022-12-14 04:21:04 | Troup, Georgia, US | |
308158 | 308158 | 2022-12-13 | Saint Lucia | 29729 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-14 04:21:04 | Saint Lucia | ||||
1150429 | 1150429 | 2022-12-12 | US | Kentucky | Warren | 21227 | 52149 | 409 | 0 | 36.99903045 | -86.42672751 | 2022-12-13 04:21:01 | Warren, Kentucky, US | |
1149838 | 1149838 | 2022-12-12 | US | Georgia | Troup | 13285 | 18100 | 409 | 0 | 33.03349196 | -85.02812115 | 2022-12-13 04:21:01 | Troup, Georgia, US | |
1149219 | 1149219 | 2022-12-12 | Saint Lucia | 29723 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-13 04:21:01 | Saint Lucia | ||||
869713 | 869713 | 2022-12-11 | US | Guam | 66 | 59460 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-12 04:21:01 | Guam, US | ||
869692 | 869692 | 2022-12-11 | US | Georgia | Troup | 13285 | 18100 | 409 | 0 | 33.03349196 | -85.02812115 | 2022-12-12 04:21:01 | Troup, Georgia, US | |
869073 | 869073 | 2022-12-11 | Saint Lucia | 29723 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-12 04:21:01 | Saint Lucia | ||||
258243 | 258243 | 2022-12-10 | US | Guam | 66 | 59460 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-11 04:20:50 | Guam, US | ||
258222 | 258222 | 2022-12-10 | US | Georgia | Troup | 13285 | 18100 | 409 | 0 | 33.03349196 | -85.02812115 | 2022-12-11 04:20:50 | Troup, Georgia, US | |
257603 | 257603 | 2022-12-10 | Saint Lucia | 29723 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-11 04:20:50 | Saint Lucia | ||||
3936957 | 3936957 | 2022-12-09 | US | Guam | 66 | 59460 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-10 04:21:02 | Guam, US | ||
3936936 | 3936936 | 2022-12-09 | US | Georgia | Troup | 13285 | 18100 | 409 | 0 | 33.03349196 | -85.02812115 | 2022-12-10 04:21:02 | Troup, Georgia, US | |
3936317 | 3936317 | 2022-12-09 | Saint Lucia | 29723 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-10 04:21:02 | Saint Lucia | ||||
3378389 | 3378389 | 2022-12-08 | US | Illinois | LaSalle | 17099 | 35613 | 409 | 0 | 41.3442613 | -88.88633881 | 2022-12-09 04:21:05 | LaSalle, Illinois, US | |
3378289 | 3378289 | 2022-12-08 | US | Guam | 66 | 59460 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-09 04:21:05 | Guam, US | ||
3378268 | 3378268 | 2022-12-08 | US | Georgia | Troup | 13285 | 18100 | 409 | 0 | 33.03349196 | -85.02812115 | 2022-12-09 04:21:05 | Troup, Georgia, US | |
3377649 | 3377649 | 2022-12-08 | Saint Lucia | 29723 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-09 04:21:05 | Saint Lucia | ||||
3377384 | 3377384 | 2022-12-08 | Japan | Miyazaki | 221546 | 409 | 0 | 32.193204 | 131.299374 | 2022-12-09 04:21:05 | Miyazaki, Japan | |||
1985660 | 1985660 | 2022-12-07 | US | Illinois | LaSalle | 17099 | 35589 | 409 | 0 | 41.3442613 | -88.88633881 | 2022-12-08 04:21:07 | LaSalle, Illinois, US | |
1985560 | 1985560 | 2022-12-07 | US | Guam | 66 | 59460 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-08 04:21:07 | Guam, US | ||
1985247 | 1985247 | 2022-12-07 | US | California | Yolo | 6113 | 53270 | 409 | 0 | 38.68278902 | -121.9018288 | 2022-12-08 04:21:07 | Yolo, California, US | |
1984920 | 1984920 | 2022-12-07 | Saint Lucia | 29723 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-08 04:21:07 | Saint Lucia | ||||
1984667 | 1984667 | 2022-12-07 | Japan | Shiga | 281053 | 409 | 0 | 35.215827 | 136.138064 | 2022-12-08 04:21:07 | Shiga, Japan | |||
1984655 | 1984655 | 2022-12-07 | Japan | Miyazaki | 220521 | 409 | 0 | 32.193204 | 131.299374 | 2022-12-08 04:21:07 | Miyazaki, Japan | |||
3715183 | 3715183 | 2022-12-06 | US | Illinois | LaSalle | 17099 | 35555 | 409 | 0 | 41.3442613 | -88.88633881 | 2022-12-07 04:20:58 | LaSalle, Illinois, US | |
3715083 | 3715083 | 2022-12-06 | US | Guam | 66 | 59460 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-07 04:20:58 | Guam, US | ||
3714770 | 3714770 | 2022-12-06 | US | California | Yolo | 6113 | 53266 | 409 | 0 | 38.68278902 | -121.9018288 | 2022-12-07 04:20:58 | Yolo, California, US | |
3714443 | 3714443 | 2022-12-06 | Saint Lucia | 29723 | 409 | 0 | 13.9094 | -60.9789 | 2022-12-07 04:20:58 | Saint Lucia | ||||
3714178 | 3714178 | 2022-12-06 | Japan | Miyazaki | 219538 | 409 | 0 | 32.193204 | 131.299374 | 2022-12-07 04:20:58 | Miyazaki, Japan | |||
2415788 | 2415788 | 2022-12-05 | US | Guam | 66 | 59460 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-06 04:21:03 | Guam, US | ||
2415475 | 2415475 | 2022-12-05 | US | California | Yolo | 6113 | 53047 | 409 | 0 | 38.68278902 | -121.9018288 | 2022-12-06 04:21:03 | Yolo, California, US | |
2414883 | 2414883 | 2022-12-05 | Japan | Miyazaki | 218359 | 409 | 0 | 32.193204 | 131.299374 | 2022-12-06 04:21:03 | Miyazaki, Japan | |||
722084 | 722084 | 2022-12-04 | US | Wisconsin | Winnebago | 55139 | 61728 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-12-05 04:20:58 | Winnebago, Wisconsin, US | |
719396 | 719396 | 2022-12-04 | US | Guam | 66 | 59424 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-05 04:20:58 | Guam, US | ||
719083 | 719083 | 2022-12-04 | US | California | Yolo | 6113 | 53041 | 409 | 0 | 38.68278902 | -121.9018288 | 2022-12-05 04:20:58 | Yolo, California, US | |
718491 | 718491 | 2022-12-04 | Japan | Miyazaki | 218073 | 409 | 0 | 32.193204 | 131.299374 | 2022-12-05 04:20:58 | Miyazaki, Japan | |||
2820373 | 2820373 | 2022-12-03 | US | Wisconsin | Winnebago | 55139 | 61728 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-12-04 04:20:56 | Winnebago, Wisconsin, US | |
2817685 | 2817685 | 2022-12-03 | US | Guam | 66 | 59424 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-04 04:20:56 | Guam, US | ||
2817372 | 2817372 | 2022-12-03 | US | California | Yolo | 6113 | 53039 | 409 | 0 | 38.68278902 | -121.9018288 | 2022-12-04 04:20:56 | Yolo, California, US | |
837229 | 837229 | 2022-12-02 | US | Wisconsin | Winnebago | 55139 | 61728 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-12-03 04:21:02 | Winnebago, Wisconsin, US | |
834541 | 834541 | 2022-12-02 | US | Guam | 66 | 59424 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-03 04:21:02 | Guam, US | ||
834228 | 834228 | 2022-12-02 | US | California | Yolo | 6113 | 53037 | 409 | 0 | 38.68278902 | -121.9018288 | 2022-12-03 04:21:02 | Yolo, California, US | |
2139759 | 2139759 | 2022-12-01 | US | Wisconsin | Winnebago | 55139 | 61684 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-12-02 04:21:07 | Winnebago, Wisconsin, US | |
2137071 | 2137071 | 2022-12-01 | US | Guam | 66 | 59330 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-02 04:21:07 | Guam, US | ||
2136758 | 2136758 | 2022-12-01 | US | California | Yolo | 6113 | 53034 | 409 | 0 | 38.68278902 | -121.9018288 | 2022-12-02 04:21:07 | Yolo, California, US | |
1968175 | 1968175 | 2022-11-30 | US | Wisconsin | Winnebago | 55139 | 61649 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-12-01 04:21:03 | Winnebago, Wisconsin, US | |
1965487 | 1965487 | 2022-11-30 | US | Guam | 66 | 59330 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-01 04:21:03 | Guam, US | ||
2560189 | 2560189 | 2022-11-29 | US | Wisconsin | Winnebago | 55139 | 61599 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-30 04:21:07 | Winnebago, Wisconsin, US | |
2557501 | 2557501 | 2022-11-29 | US | Guam | 66 | 59330 | 409 | 0 | 13.4443 | 144.7937 | 2022-11-30 04:21:07 | Guam, US | ||
1243263 | 1243263 | 2022-11-28 | US | Wisconsin | Winnebago | 55139 | 61546 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-29 04:21:05 | Winnebago, Wisconsin, US | |
1240575 | 1240575 | 2022-11-28 | US | Guam | 66 | 59330 | 409 | 0 | 13.4443 | 144.7937 | 2022-11-29 04:21:05 | Guam, US | ||
3555251 | 3555251 | 2022-11-27 | US | Wisconsin | Winnebago | 55139 | 61494 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-28 04:21:02 | Winnebago, Wisconsin, US | |
2103731 | 2103731 | 2022-11-26 | US | Wisconsin | Winnebago | 55139 | 61494 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-27 04:21:05 | Winnebago, Wisconsin, US | |
491222 | 491222 | 2022-11-25 | US | Wisconsin | Winnebago | 55139 | 61494 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-26 04:21:11 | Winnebago, Wisconsin, US | |
3527051 | 3527051 | 2022-11-24 | US | Wisconsin | Winnebago | 55139 | 61483 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-25 04:21:06 | Winnebago, Wisconsin, US | |
3315834 | 3315834 | 2022-11-23 | US | Wisconsin | Winnebago | 55139 | 61435 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-24 04:21:09 | Winnebago, Wisconsin, US | |
1623875 | 1623875 | 2022-11-22 | US | Wisconsin | Winnebago | 55139 | 61414 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-23 04:21:06 | Winnebago, Wisconsin, US | |
3463763 | 3463763 | 2022-11-21 | US | Wisconsin | Winnebago | 55139 | 61369 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-22 04:20:47 | Winnebago, Wisconsin, US | |
1643948 | 1643948 | 2022-11-20 | US | Wisconsin | Winnebago | 55139 | 61320 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-21 04:21:05 | Winnebago, Wisconsin, US | |
2067505 | 2067505 | 2022-11-19 | US | Wisconsin | Winnebago | 55139 | 61320 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-20 04:21:08 | Winnebago, Wisconsin, US | |
1758899 | 1758899 | 2022-11-18 | US | Wisconsin | Winnebago | 55139 | 61320 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-19 04:21:14 | Winnebago, Wisconsin, US | |
3029892 | 3029892 | 2022-11-17 | US | Wisconsin | Winnebago | 55139 | 61289 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-18 04:21:15 | Winnebago, Wisconsin, US | |
2489603 | 2489603 | 2022-11-16 | US | Wisconsin | Winnebago | 55139 | 61264 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-17 04:21:11 | Winnebago, Wisconsin, US | |
2486033 | 2486033 | 2022-11-16 | Japan | Yamaguchi | 185924 | 409 | 0 | 34.20119 | 131.573293 | 2022-11-17 04:21:11 | Yamaguchi, Japan | |||
295614 | 295614 | 2022-11-15 | US | Wisconsin | Winnebago | 55139 | 61218 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-16 04:21:09 | Winnebago, Wisconsin, US | |
292044 | 292044 | 2022-11-15 | Japan | Yamaguchi | 185279 | 409 | 0 | 34.20119 | 131.573293 | 2022-11-16 04:21:09 | Yamaguchi, Japan | |||
3600644 | 3600644 | 2022-11-14 | US | Wisconsin | Winnebago | 55139 | 61176 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-15 04:21:16 | Winnebago, Wisconsin, US | |
3597651 | 3597651 | 2022-11-14 | US | Colorado | Boulder | 8013 | 86967 | 409 | 0 | 40.09313619 | -105.3546767 | 2022-11-15 04:21:16 | Boulder, Colorado, US | |
315502 | 315502 | 2022-11-13 | US | Wisconsin | Winnebago | 55139 | 61100 | 409 | 0 | 44.06886922 | -88.64477096 | 2022-11-14 04:21:09 | Winnebago, Wisconsin, 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]);