daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,221 rows where deaths = 342 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 904
- Sweden 100
- Gambia 40
- Japan 36
- Russia 30
- France 10
- Ukraine 10
- Chile 9
- Netherlands 8
- Pakistan 8
- Mali 6
- Peru 6
- Uganda 6
- Colombia 4
- Germany 4
- India 4
- Spain 4
- Brazil 3
- Finland 3
- Australia 2
- Cabo Verde 2
- Italy 2
- Malaysia 2
- Saint Lucia 2
- United Arab Emirates 2
- Angola 1
- Austria 1
- Canada 1
- Congo (Kinshasa) 1
- Cyprus 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Georgia | Rockdale | 13247 | 22922 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-30 04:21:04 | Rockdale, Georgia, US | |
2022-12-28 | US | Georgia | Rockdale | 13247 | 22922 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-29 04:21:01 | Rockdale, Georgia, US | |
2022-12-27 | US | Maine | York | 23031 | 50129 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-28 04:21:04 | York, Maine, US | |
2022-12-27 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-28 04:21:04 | Rockdale, Georgia, US | |
2022-12-26 | US | Maine | York | 23031 | 50129 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-27 04:21:07 | York, Maine, US | |
2022-12-26 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-27 04:21:07 | Rockdale, Georgia, US | |
2022-12-25 | US | Maine | York | 23031 | 50129 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-26 04:21:06 | York, Maine, US | |
2022-12-25 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-26 04:21:06 | Rockdale, Georgia, US | |
2022-12-24 | US | Maine | York | 23031 | 50129 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-25 04:21:04 | York, Maine, US | |
2022-12-24 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-25 04:21:04 | Rockdale, Georgia, US | |
2022-12-23 | US | Maine | York | 23031 | 50089 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-24 04:21:02 | York, Maine, US | |
2022-12-23 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-24 04:21:02 | Rockdale, Georgia, US | |
2022-12-23 | Japan | Wakayama | 182140 | 342 | 0 | 33.911879 | 135.505446 | 2022-12-24 04:21:02 | Wakayama, Japan | |||
2022-12-22 | US | Maine | York | 23031 | 50068 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-23 04:21:04 | York, Maine, US | |
2022-12-22 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-23 04:21:04 | Rockdale, Georgia, US | |
2022-12-21 | US | Maine | York | 23031 | 50003 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-22 04:20:56 | York, Maine, US | |
2022-12-21 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-22 04:20:56 | Rockdale, Georgia, US | |
2022-12-20 | US | Maine | York | 23031 | 49950 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-21 04:21:03 | York, Maine, US | |
2022-12-14 | Japan | Ishikawa | 218028 | 342 | 0 | 36.769464 | 136.771027 | 2022-12-15 04:20:58 | Ishikawa, Japan | |||
2022-12-12 | Japan | Ehime | 208226 | 342 | 0 | 33.624835 | 132.856842 | 2022-12-13 04:21:01 | Ehime, Japan | |||
2022-12-11 | Japan | Ehime | 207557 | 342 | 0 | 33.624835 | 132.856842 | 2022-12-12 04:21:01 | Ehime, Japan | |||
2022-12-10 | Japan | Ehime | 206189 | 342 | 0 | 33.624835 | 132.856842 | 2022-12-11 04:20:50 | Ehime, Japan | |||
2022-12-07 | Japan | Kagawa | 174097 | 342 | 0 | 34.217292 | 133.969047 | 2022-12-08 04:21:07 | Kagawa, Japan | |||
2022-12-06 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-07 04:20:58 | Whatcom, Washington, US | |
2022-12-05 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-06 04:21:03 | Whatcom, Washington, US | |
2022-12-04 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-05 04:20:58 | Whatcom, Washington, US | |
2022-12-03 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-04 04:20:56 | Whatcom, Washington, US | |
2022-12-02 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-03 04:21:02 | Whatcom, Washington, US | |
2022-12-01 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-02 04:21:07 | Whatcom, Washington, US | |
2022-11-30 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-01 04:21:03 | Whatcom, Washington, US | |
2022-11-19 | Japan | Nagasaki | 230178 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-20 04:21:08 | Nagasaki, Japan | |||
2022-11-17 | Japan | Nagasaki | 227223 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-18 04:21:15 | Nagasaki, Japan | |||
2022-11-15 | US | Tennessee | Cumberland | 47035 | 18849 | 342 | 0 | 35.95271721 | -84.99840585 | 2022-11-16 04:21:09 | Cumberland, Tennessee, US | |
2022-11-14 | US | Tennessee | Cumberland | 47035 | 18840 | 342 | 0 | 35.95271721 | -84.99840585 | 2022-11-15 04:21:16 | Cumberland, Tennessee, US | |
2022-11-14 | Japan | Nagasaki | 227223 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-15 04:21:16 | Nagasaki, Japan | |||
2022-11-13 | US | New York | Schenectady | 36093 | 41759 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-14 04:21:09 | Schenectady, New York, US | |
2022-11-13 | Japan | Nagasaki | 227003 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-14 04:21:09 | Nagasaki, Japan | |||
2022-11-12 | US | New York | Schenectady | 36093 | 41748 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-13 04:21:14 | Schenectady, New York, US | |
2022-11-12 | Japan | Nagasaki | 226510 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-13 04:21:14 | Nagasaki, Japan | |||
2022-11-11 | US | New York | Schenectady | 36093 | 41725 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-12 04:20:41 | Schenectady, New York, US | |
2022-11-11 | Japan | Nagasaki | 225985 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-12 04:20:41 | Nagasaki, Japan | |||
2022-11-10 | US | New York | Schenectady | 36093 | 41706 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-11 04:21:22 | Schenectady, New York, US | |
2022-11-10 | Japan | Nagasaki | 225469 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-11 04:21:22 | Nagasaki, Japan | |||
2022-11-09 | US | New York | Schenectady | 36093 | 41684 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-10 04:21:16 | Schenectady, New York, US | |
2022-11-09 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-10 04:21:16 | DeKalb, Alabama, US | |
2022-11-09 | Japan | Nagasaki | 224935 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-10 04:21:16 | Nagasaki, Japan | |||
2022-11-08 | US | New York | Schenectady | 36093 | 41659 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-09 04:21:22 | Schenectady, New York, US | |
2022-11-08 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-09 04:21:22 | DeKalb, Alabama, US | |
2022-11-08 | Japan | Nagasaki | 224375 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-09 04:21:22 | Nagasaki, Japan | |||
2022-11-07 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-08 04:21:21 | DeKalb, Alabama, US | |
2022-11-07 | Japan | Nagasaki | 223699 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-08 04:21:21 | Nagasaki, Japan | |||
2022-11-07 | Japan | Aomori | 178913 | 342 | 0 | 40.781541 | 140.828896 | 2022-11-08 04:21:21 | Aomori, Japan | |||
2022-11-06 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-07 04:21:26 | DeKalb, Alabama, US | |
2022-11-06 | Japan | Nagasaki | 223514 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-07 04:21:26 | Nagasaki, Japan | |||
2022-11-05 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-06 04:21:24 | DeKalb, Alabama, US | |
2022-11-05 | Japan | Nagasaki | 223051 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-06 04:21:24 | Nagasaki, Japan | |||
2022-11-04 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-05 04:21:52 | DeKalb, Alabama, US | |
2022-11-04 | Japan | Nagasaki | 222390 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-05 04:21:52 | Nagasaki, Japan | |||
2022-11-03 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-04 04:22:11 | DeKalb, Alabama, US | |
2022-11-03 | Japan | Nagasaki | 222265 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-04 04:22:11 | Nagasaki, Japan | |||
2022-11-02 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-03 04:22:05 | DeKalb, Alabama, US | |
2022-11-02 | Japan | Nagasaki | 221747 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-03 04:22:05 | Nagasaki, Japan | |||
2022-11-01 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-02 04:22:09 | DeKalb, Alabama, US | |
2022-10-31 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-01 04:22:36 | DeKalb, Alabama, US | |
2022-10-30 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-10-31 04:21:36 | DeKalb, Alabama, US | |
2022-10-29 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-10-30 04:22:14 | DeKalb, Alabama, US | |
2022-10-28 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-10-29 04:21:13 | DeKalb, Alabama, US | |
2022-10-27 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-10-28 04:22:31 | DeKalb, Alabama, US | |
2022-10-23 | US | Virginia | Arlington | 51013 | 61693 | 342 | 0 | 38.8767675 | -77.10139853 | 2022-10-24 04:22:29 | Arlington, Virginia, US | |
2022-10-22 | US | Virginia | Arlington | 51013 | 61693 | 342 | 0 | 38.8767675 | -77.10139853 | 2022-10-23 04:22:46 | Arlington, Virginia, US | |
2022-10-21 | US | Virginia | Arlington | 51013 | 61693 | 342 | 0 | 38.8767675 | -77.10139853 | 2022-10-22 04:22:53 | Arlington, Virginia, US | |
2022-10-20 | US | Wisconsin | Sheboygan | 55117 | 37393 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-21 04:22:23 | Sheboygan, Wisconsin, US | |
2022-10-20 | US | Virginia | Arlington | 51013 | 61662 | 342 | 0 | 38.8767675 | -77.10139853 | 2022-10-21 04:22:23 | Arlington, Virginia, US | |
2022-10-19 | US | Wisconsin | Sheboygan | 55117 | 37371 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-20 04:22:59 | Sheboygan, Wisconsin, US | |
2022-10-18 | US | Wisconsin | Sheboygan | 55117 | 37356 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-19 04:22:26 | Sheboygan, Wisconsin, US | |
2022-10-18 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-19 04:22:26 | Crawford, Pennsylvania, US | |
2022-10-17 | US | Wisconsin | Sheboygan | 55117 | 37342 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-18 04:22:42 | Sheboygan, Wisconsin, US | |
2022-10-17 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-18 04:22:42 | Crawford, Pennsylvania, US | |
2022-10-17 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-18 04:22:42 | Lenawee, Michigan, US | |
2022-10-16 | US | Wisconsin | Sheboygan | 55117 | 37298 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-17 04:20:31 | Sheboygan, Wisconsin, US | |
2022-10-16 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-17 04:20:31 | Crawford, Pennsylvania, US | |
2022-10-16 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-17 04:20:31 | Lenawee, Michigan, US | |
2022-10-15 | US | Wisconsin | Sheboygan | 55117 | 37298 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-16 04:22:39 | Sheboygan, Wisconsin, US | |
2022-10-15 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-16 04:22:39 | Crawford, Pennsylvania, US | |
2022-10-15 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-16 04:22:39 | Lenawee, Michigan, US | |
2022-10-15 | Japan | Shiga | 239495 | 342 | 0 | 35.215827 | 136.138064 | 2022-10-16 04:22:39 | Shiga, Japan | |||
2022-10-14 | US | Wisconsin | Sheboygan | 55117 | 37298 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-15 04:22:00 | Sheboygan, Wisconsin, US | |
2022-10-14 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-15 04:22:00 | Crawford, Pennsylvania, US | |
2022-10-14 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-15 04:22:00 | Lenawee, Michigan, US | |
2022-10-13 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-14 04:22:28 | Crawford, Pennsylvania, US | |
2022-10-13 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-14 04:22:28 | Lenawee, Michigan, US | |
2022-10-12 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-13 04:22:39 | Crawford, Pennsylvania, US | |
2022-10-12 | US | Oklahoma | Creek | 40037 | 20944 | 342 | 0 | 35.90230551 | -96.37086028 | 2022-10-13 04:22:39 | Creek, Oklahoma, US | |
2022-10-12 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-13 04:22:39 | Lenawee, Michigan, US | |
2022-10-12 | US | Arkansas | Faulkner | 5045 | 40742 | 342 | 0 | 35.14719007 | -92.33717519 | 2022-10-13 04:22:39 | Faulkner, Arkansas, US | |
2022-10-11 | US | Pennsylvania | Crawford | 42039 | 23073 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-12 04:22:51 | Crawford, Pennsylvania, US | |
2022-10-11 | US | Oklahoma | Creek | 40037 | 20944 | 342 | 0 | 35.90230551 | -96.37086028 | 2022-10-12 04:22:51 | Creek, Oklahoma, US | |
2022-10-11 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-12 04:22:51 | Lenawee, Michigan, US | |
2022-10-10 | US | Pennsylvania | Crawford | 42039 | 23073 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-11 04:23:05 | Crawford, Pennsylvania, US | |
2022-10-10 | US | Oklahoma | Creek | 40037 | 20944 | 342 | 0 | 35.90230551 | -96.37086028 | 2022-10-11 04:23:05 | Creek, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;