daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17,406 rows where deaths = 42 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 16,248
- Russia 363
- San Marino 178
- Japan 82
- Antigua and Barbuda 68
- France 66
- Saint Kitts and Nevis 40
- Colombia 39
- Ukraine 24
- Malaysia 22
- India 19
- Eritrea 17
- Netherlands 16
- Peru 16
- Dominica 14
- Australia 13
- Sweden 13
- Lesotho 11
- Seychelles 10
- Zambia 10
- Spain 9
- Chile 7
- New Zealand 7
- Germany 6
- United Kingdom 6
- Guinea-Bissau 5
- Mexico 5
- Monaco 5
- Barbados 4
- Botswana 4
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Wisconsin | Ashland | 55003 | 4077 | 42 | 0 | 46.31956891 | -90.67837132 | 2022-12-30 04:21:04 | Ashland, Wisconsin, US | |
2022-12-29 | US | Virginia | New Kent | 51127 | 5731 | 42 | 0 | 37.50694406 | -76.99828634 | 2022-12-30 04:21:04 | New Kent, Virginia, US | |
2022-12-29 | US | Virginia | Fredericksburg | 51630 | 6981 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-12-30 04:21:04 | Fredericksburg, Virginia, US | |
2022-12-29 | US | Texas | Yoakum | 48501 | 1644 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-12-30 04:21:04 | Yoakum, Texas, US | |
2022-12-29 | US | Texas | Live Oak | 48297 | 2376 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-12-30 04:21:04 | Live Oak, Texas, US | |
2022-12-29 | US | Tennessee | Hancock | 47067 | 2549 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-30 04:21:04 | Hancock, Tennessee, US | |
2022-12-29 | US | South Dakota | Bon Homme | 46009 | 2497 | 42 | 0 | 42.98914167 | -97.88592746 | 2022-12-30 04:21:04 | Bon Homme, South Dakota, US | |
2022-12-29 | US | Oklahoma | Haskell | 40061 | 3260 | 42 | 0 | 35.222576 | -95.11513306 | 2022-12-30 04:21:04 | Haskell, Oklahoma, US | |
2022-12-29 | US | North Carolina | Mitchell | 37121 | 4574 | 42 | 0 | 36.01059309 | -82.1582442 | 2022-12-30 04:21:04 | Mitchell, North Carolina, US | |
2022-12-29 | US | New York | Yates | 36123 | 4346 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-30 04:21:04 | Yates, New York, US | |
2022-12-29 | US | Missouri | Shannon | 29203 | 1890 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-30 04:21:04 | Shannon, Missouri, US | |
2022-12-29 | US | Missouri | Chariton | 29041 | 1970 | 42 | 0 | 39.51499357 | -92.9629191 | 2022-12-30 04:21:04 | Chariton, Missouri, US | |
2022-12-29 | US | Minnesota | Koochiching | 27071 | 3587 | 42 | 0 | 48.24539665 | -93.78352843 | 2022-12-30 04:21:04 | Koochiching, Minnesota, US | |
2022-12-29 | US | Minnesota | Cottonwood | 27033 | 3705 | 42 | 0 | 44.00715262 | -95.18138802 | 2022-12-30 04:21:04 | Cottonwood, Minnesota, US | |
2022-12-29 | US | Michigan | Lake | 26085 | 2361 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-30 04:21:04 | Lake, Michigan, US | |
2022-12-29 | US | Maine | Sagadahoc | 23023 | 6773 | 42 | 0 | 43.95415864 | -69.85074999 | 2022-12-30 04:21:04 | Sagadahoc, Maine, US | |
2022-12-29 | US | Maine | Lincoln | 23015 | 6728 | 42 | 0 | 44.05996956 | -69.54227124 | 2022-12-30 04:21:04 | Lincoln, Maine, US | |
2022-12-29 | US | Kansas | Russell | 20167 | 2132 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-30 04:21:04 | Russell, Kansas, US | |
2022-12-29 | US | Iowa | Sac | 19161 | 2816 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-12-30 04:21:04 | Sac, Iowa, US | |
2022-12-29 | US | Iowa | Clarke | 19039 | 2632 | 42 | 0 | 41.02868181 | -93.78499767 | 2022-12-30 04:21:04 | Clarke, Iowa, US | |
2022-12-29 | US | Illinois | Johnson | 17087 | 5488 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-30 04:21:04 | Johnson, Illinois, US | |
2022-12-29 | US | Arkansas | Perry | 5105 | 2952 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-30 04:21:04 | Perry, Arkansas, US | |
2022-12-28 | US | Wisconsin | Ashland | 55003 | 4075 | 42 | 0 | 46.31956891 | -90.67837132 | 2022-12-29 04:21:01 | Ashland, Wisconsin, US | |
2022-12-28 | US | Virginia | New Kent | 51127 | 5731 | 42 | 0 | 37.50694406 | -76.99828634 | 2022-12-29 04:21:01 | New Kent, Virginia, US | |
2022-12-28 | US | Virginia | Fredericksburg | 51630 | 6981 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-12-29 04:21:01 | Fredericksburg, Virginia, US | |
2022-12-28 | US | Texas | Yoakum | 48501 | 1644 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-12-29 04:21:01 | Yoakum, Texas, US | |
2022-12-28 | US | Texas | Live Oak | 48297 | 2376 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-12-29 04:21:01 | Live Oak, Texas, US | |
2022-12-28 | US | Tennessee | Hancock | 47067 | 2549 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-29 04:21:01 | Hancock, Tennessee, US | |
2022-12-28 | US | South Dakota | Bon Homme | 46009 | 2497 | 42 | 0 | 42.98914167 | -97.88592746 | 2022-12-29 04:21:01 | Bon Homme, South Dakota, US | |
2022-12-28 | US | Oklahoma | Haskell | 40061 | 3257 | 42 | 0 | 35.222576 | -95.11513306 | 2022-12-29 04:21:01 | Haskell, Oklahoma, US | |
2022-12-28 | US | North Carolina | Mitchell | 37121 | 4574 | 42 | 0 | 36.01059309 | -82.1582442 | 2022-12-29 04:21:01 | Mitchell, North Carolina, US | |
2022-12-28 | US | New York | Yates | 36123 | 4344 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-29 04:21:01 | Yates, New York, US | |
2022-12-28 | US | Missouri | Shannon | 29203 | 1890 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-29 04:21:01 | Shannon, Missouri, US | |
2022-12-28 | US | Missouri | Chariton | 29041 | 1970 | 42 | 0 | 39.51499357 | -92.9629191 | 2022-12-29 04:21:01 | Chariton, Missouri, US | |
2022-12-28 | US | Minnesota | Koochiching | 27071 | 3573 | 42 | 0 | 48.24539665 | -93.78352843 | 2022-12-29 04:21:01 | Koochiching, Minnesota, US | |
2022-12-28 | US | Minnesota | Cottonwood | 27033 | 3695 | 42 | 0 | 44.00715262 | -95.18138802 | 2022-12-29 04:21:01 | Cottonwood, Minnesota, US | |
2022-12-28 | US | Michigan | Lake | 26085 | 2361 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-29 04:21:01 | Lake, Michigan, US | |
2022-12-28 | US | Maine | Sagadahoc | 23023 | 6767 | 42 | 0 | 43.95415864 | -69.85074999 | 2022-12-29 04:21:01 | Sagadahoc, Maine, US | |
2022-12-28 | US | Maine | Lincoln | 23015 | 6716 | 42 | 0 | 44.05996956 | -69.54227124 | 2022-12-29 04:21:01 | Lincoln, Maine, US | |
2022-12-28 | US | Kansas | Russell | 20167 | 2132 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-29 04:21:01 | Russell, Kansas, US | |
2022-12-28 | US | Iowa | Sac | 19161 | 2816 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-12-29 04:21:01 | Sac, Iowa, US | |
2022-12-28 | US | Iowa | Clarke | 19039 | 2632 | 42 | 0 | 41.02868181 | -93.78499767 | 2022-12-29 04:21:01 | Clarke, Iowa, US | |
2022-12-28 | US | Illinois | Johnson | 17087 | 5482 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-29 04:21:01 | Johnson, Illinois, US | |
2022-12-28 | US | Arkansas | Perry | 5105 | 2952 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-29 04:21:01 | Perry, Arkansas, US | |
2022-12-27 | US | Wisconsin | Ashland | 55003 | 4071 | 42 | 0 | 46.31956891 | -90.67837132 | 2022-12-28 04:21:04 | Ashland, Wisconsin, US | |
2022-12-27 | US | Virginia | New Kent | 51127 | 5728 | 42 | 0 | 37.50694406 | -76.99828634 | 2022-12-28 04:21:04 | New Kent, Virginia, US | |
2022-12-27 | US | Virginia | Fredericksburg | 51630 | 6979 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-12-28 04:21:04 | Fredericksburg, Virginia, US | |
2022-12-27 | US | Texas | Yoakum | 48501 | 1643 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-12-28 04:21:04 | Yoakum, Texas, US | |
2022-12-27 | US | Texas | Live Oak | 48297 | 2368 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-12-28 04:21:04 | Live Oak, Texas, US | |
2022-12-27 | US | Tennessee | Hancock | 47067 | 2549 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-28 04:21:04 | Hancock, Tennessee, US | |
2022-12-27 | US | Oklahoma | Haskell | 40061 | 3257 | 42 | 0 | 35.222576 | -95.11513306 | 2022-12-28 04:21:04 | Haskell, Oklahoma, US | |
2022-12-27 | US | North Carolina | Mitchell | 37121 | 4574 | 42 | 0 | 36.01059309 | -82.1582442 | 2022-12-28 04:21:04 | Mitchell, North Carolina, US | |
2022-12-27 | US | New York | Yates | 36123 | 4344 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-28 04:21:04 | Yates, New York, US | |
2022-12-27 | US | Missouri | Shannon | 29203 | 1890 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-28 04:21:04 | Shannon, Missouri, US | |
2022-12-27 | US | Missouri | Chariton | 29041 | 1970 | 42 | 0 | 39.51499357 | -92.9629191 | 2022-12-28 04:21:04 | Chariton, Missouri, US | |
2022-12-27 | US | Minnesota | Koochiching | 27071 | 3573 | 42 | 0 | 48.24539665 | -93.78352843 | 2022-12-28 04:21:04 | Koochiching, Minnesota, US | |
2022-12-27 | US | Minnesota | Cottonwood | 27033 | 3695 | 42 | 0 | 44.00715262 | -95.18138802 | 2022-12-28 04:21:04 | Cottonwood, Minnesota, US | |
2022-12-27 | US | Michigan | Lake | 26085 | 2361 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-28 04:21:04 | Lake, Michigan, US | |
2022-12-27 | US | Maine | Sagadahoc | 23023 | 6761 | 42 | 0 | 43.95415864 | -69.85074999 | 2022-12-28 04:21:04 | Sagadahoc, Maine, US | |
2022-12-27 | US | Maine | Lincoln | 23015 | 6712 | 42 | 0 | 44.05996956 | -69.54227124 | 2022-12-28 04:21:04 | Lincoln, Maine, US | |
2022-12-27 | US | Kansas | Russell | 20167 | 2129 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-28 04:21:04 | Russell, Kansas, US | |
2022-12-27 | US | Iowa | Sac | 19161 | 2814 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-12-28 04:21:04 | Sac, Iowa, US | |
2022-12-27 | US | Iowa | Clarke | 19039 | 2623 | 42 | 0 | 41.02868181 | -93.78499767 | 2022-12-28 04:21:04 | Clarke, Iowa, US | |
2022-12-27 | US | Illinois | Johnson | 17087 | 5480 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-28 04:21:04 | Johnson, Illinois, US | |
2022-12-27 | US | Arkansas | Perry | 5105 | 2949 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-28 04:21:04 | Perry, Arkansas, US | |
2022-12-26 | US | Wisconsin | Ashland | 55003 | 4071 | 42 | 0 | 46.31956891 | -90.67837132 | 2022-12-27 04:21:07 | Ashland, Wisconsin, US | |
2022-12-26 | US | Virginia | New Kent | 51127 | 5725 | 42 | 0 | 37.50694406 | -76.99828634 | 2022-12-27 04:21:07 | New Kent, Virginia, US | |
2022-12-26 | US | Virginia | Fredericksburg | 51630 | 6976 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-12-27 04:21:07 | Fredericksburg, Virginia, US | |
2022-12-26 | US | Texas | Yoakum | 48501 | 1643 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-12-27 04:21:07 | Yoakum, Texas, US | |
2022-12-26 | US | Texas | Live Oak | 48297 | 2368 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-12-27 04:21:07 | Live Oak, Texas, US | |
2022-12-26 | US | Tennessee | Hancock | 47067 | 2549 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-27 04:21:07 | Hancock, Tennessee, US | |
2022-12-26 | US | Oklahoma | Haskell | 40061 | 3257 | 42 | 0 | 35.222576 | -95.11513306 | 2022-12-27 04:21:07 | Haskell, Oklahoma, US | |
2022-12-26 | US | North Carolina | Mitchell | 37121 | 4574 | 42 | 0 | 36.01059309 | -82.1582442 | 2022-12-27 04:21:07 | Mitchell, North Carolina, US | |
2022-12-26 | US | New York | Yates | 36123 | 4341 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-27 04:21:07 | Yates, New York, US | |
2022-12-26 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-27 04:21:07 | Shannon, Missouri, US | |
2022-12-26 | US | Missouri | Chariton | 29041 | 1964 | 42 | 0 | 39.51499357 | -92.9629191 | 2022-12-27 04:21:07 | Chariton, Missouri, US | |
2022-12-26 | US | Minnesota | Koochiching | 27071 | 3573 | 42 | 0 | 48.24539665 | -93.78352843 | 2022-12-27 04:21:07 | Koochiching, Minnesota, US | |
2022-12-26 | US | Minnesota | Cottonwood | 27033 | 3695 | 42 | 0 | 44.00715262 | -95.18138802 | 2022-12-27 04:21:07 | Cottonwood, Minnesota, US | |
2022-12-26 | US | Michigan | Lake | 26085 | 2356 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-27 04:21:07 | Lake, Michigan, US | |
2022-12-26 | US | Maine | Sagadahoc | 23023 | 6761 | 42 | 0 | 43.95415864 | -69.85074999 | 2022-12-27 04:21:07 | Sagadahoc, Maine, US | |
2022-12-26 | US | Maine | Lincoln | 23015 | 6712 | 42 | 0 | 44.05996956 | -69.54227124 | 2022-12-27 04:21:07 | Lincoln, Maine, US | |
2022-12-26 | US | Kansas | Russell | 20167 | 2129 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-27 04:21:07 | Russell, Kansas, US | |
2022-12-26 | US | Iowa | Sac | 19161 | 2814 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-12-27 04:21:07 | Sac, Iowa, US | |
2022-12-26 | US | Iowa | Clarke | 19039 | 2623 | 42 | 0 | 41.02868181 | -93.78499767 | 2022-12-27 04:21:07 | Clarke, Iowa, US | |
2022-12-26 | US | Illinois | Johnson | 17087 | 5476 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-27 04:21:07 | Johnson, Illinois, US | |
2022-12-26 | US | Arkansas | Perry | 5105 | 2947 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-27 04:21:07 | Perry, Arkansas, US | |
2022-12-25 | US | Wisconsin | Ashland | 55003 | 4071 | 42 | 0 | 46.31956891 | -90.67837132 | 2022-12-26 04:21:06 | Ashland, Wisconsin, US | |
2022-12-25 | US | Virginia | New Kent | 51127 | 5706 | 42 | 0 | 37.50694406 | -76.99828634 | 2022-12-26 04:21:06 | New Kent, Virginia, US | |
2022-12-25 | US | Virginia | Fredericksburg | 51630 | 6956 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-12-26 04:21:06 | Fredericksburg, Virginia, US | |
2022-12-25 | US | Texas | Yoakum | 48501 | 1643 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-12-26 04:21:06 | Yoakum, Texas, US | |
2022-12-25 | US | Texas | Live Oak | 48297 | 2368 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-12-26 04:21:06 | Live Oak, Texas, US | |
2022-12-25 | US | Tennessee | Hancock | 47067 | 2549 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-26 04:21:06 | Hancock, Tennessee, US | |
2022-12-25 | US | Oklahoma | Haskell | 40061 | 3257 | 42 | 0 | 35.222576 | -95.11513306 | 2022-12-26 04:21:06 | Haskell, Oklahoma, US | |
2022-12-25 | US | North Carolina | Mitchell | 37121 | 4574 | 42 | 0 | 36.01059309 | -82.1582442 | 2022-12-26 04:21:06 | Mitchell, North Carolina, US | |
2022-12-25 | US | New York | Yates | 36123 | 4340 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-26 04:21:06 | Yates, New York, US | |
2022-12-25 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-26 04:21:06 | Shannon, Missouri, US | |
2022-12-25 | US | Missouri | Chariton | 29041 | 1964 | 42 | 0 | 39.51499357 | -92.9629191 | 2022-12-26 04:21:06 | Chariton, Missouri, US | |
2022-12-25 | US | Minnesota | Koochiching | 27071 | 3573 | 42 | 0 | 48.24539665 | -93.78352843 | 2022-12-26 04:21:06 | Koochiching, Minnesota, US | |
2022-12-25 | US | Minnesota | Cottonwood | 27033 | 3695 | 42 | 0 | 44.00715262 | -95.18138802 | 2022-12-26 04:21:06 | Cottonwood, Minnesota, US | |
2022-12-25 | US | Michigan | Lake | 26085 | 2356 | 42 | 0 | 43.99050893 | -85.802173 | 2022-12-26 04:21:06 | Lake, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;