daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5,451 rows where country_or_region = "US" and deaths = 121 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state >30
- Mississippi 443
- Georgia 398
- North Carolina 334
- Illinois 290
- New York 290
- Wisconsin 275
- Indiana 261
- Texas 256
- Tennessee 240
- Virginia 233
- Kentucky 230
- Michigan 228
- Missouri 194
- Ohio 172
- Louisiana 158
- South Dakota 133
- Kansas 112
- Oklahoma 102
- Pennsylvania 84
- Minnesota 83
- Iowa 77
- Nebraska 75
- California 73
- Alabama 70
- Arkansas 67
- Maine 66
- West Virginia 60
- South Carolina 58
- Maryland 51
- Florida 49
- …
country_or_region 1
- US · 5,451 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Kentucky | Carter | 21043 | 11617 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-30 04:21:04 | Carter, Kentucky, US | |
2022-12-29 | US | Maine | Somerset | 23025 | 12377 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-30 04:21:04 | Somerset, Maine, US | |
2022-12-29 | US | Missouri | Audrain | 29007 | 6711 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-30 04:21:04 | Audrain, Missouri, US | |
2022-12-29 | US | Missouri | Morgan | 29141 | 4818 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-30 04:21:04 | Morgan, Missouri, US | |
2022-12-29 | US | Tennessee | Hickman | 47081 | 8226 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-30 04:21:04 | Hickman, Tennessee, US | |
2022-12-28 | US | Kentucky | Carter | 21043 | 11617 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-29 04:21:01 | Carter, Kentucky, US | |
2022-12-28 | US | Maine | Somerset | 23025 | 12370 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-29 04:21:01 | Somerset, Maine, US | |
2022-12-28 | US | Missouri | Audrain | 29007 | 6711 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-29 04:21:01 | Audrain, Missouri, US | |
2022-12-28 | US | Missouri | Morgan | 29141 | 4818 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-29 04:21:01 | Morgan, Missouri, US | |
2022-12-28 | US | Tennessee | Hickman | 47081 | 8226 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-29 04:21:01 | Hickman, Tennessee, US | |
2022-12-27 | US | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-28 04:21:04 | Burke, Georgia, US | |
2022-12-27 | US | Georgia | Harris | 13145 | 6908 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-28 04:21:04 | Harris, Georgia, US | |
2022-12-27 | US | Kentucky | Carter | 21043 | 11617 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-28 04:21:04 | Carter, Kentucky, US | |
2022-12-27 | US | Maine | Somerset | 23025 | 12352 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-28 04:21:04 | Somerset, Maine, US | |
2022-12-27 | US | Missouri | Audrain | 29007 | 6711 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-28 04:21:04 | Audrain, Missouri, US | |
2022-12-27 | US | Missouri | Morgan | 29141 | 4818 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-28 04:21:04 | Morgan, Missouri, US | |
2022-12-27 | US | Tennessee | Hickman | 47081 | 8226 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-28 04:21:04 | Hickman, Tennessee, US | |
2022-12-26 | US | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-27 04:21:07 | Burke, Georgia, US | |
2022-12-26 | US | Georgia | Harris | 13145 | 6908 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-27 04:21:07 | Harris, Georgia, US | |
2022-12-26 | US | Kentucky | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-27 04:21:07 | Carter, Kentucky, US | |
2022-12-26 | US | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-27 04:21:07 | Montgomery, Kentucky, US | |
2022-12-26 | US | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-27 04:21:07 | Scott, Kentucky, US | |
2022-12-26 | US | Maine | Somerset | 23025 | 12352 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-27 04:21:07 | Somerset, Maine, US | |
2022-12-26 | US | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-27 04:21:07 | Audrain, Missouri, US | |
2022-12-26 | US | Missouri | Morgan | 29141 | 4790 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-27 04:21:07 | Morgan, Missouri, US | |
2022-12-26 | US | Tennessee | Hickman | 47081 | 8226 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-27 04:21:07 | Hickman, Tennessee, US | |
2022-12-25 | US | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-26 04:21:06 | Burke, Georgia, US | |
2022-12-25 | US | Georgia | Harris | 13145 | 6908 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-26 04:21:06 | Harris, Georgia, US | |
2022-12-25 | US | Kentucky | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-26 04:21:06 | Carter, Kentucky, US | |
2022-12-25 | US | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-26 04:21:06 | Montgomery, Kentucky, US | |
2022-12-25 | US | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-26 04:21:06 | Scott, Kentucky, US | |
2022-12-25 | US | Maine | Somerset | 23025 | 12352 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-26 04:21:06 | Somerset, Maine, US | |
2022-12-25 | US | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-26 04:21:06 | Audrain, Missouri, US | |
2022-12-25 | US | Missouri | Morgan | 29141 | 4790 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-26 04:21:06 | Morgan, Missouri, US | |
2022-12-25 | US | Tennessee | Hickman | 47081 | 8226 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-26 04:21:06 | Hickman, Tennessee, US | |
2022-12-24 | US | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-25 04:21:04 | Burke, Georgia, US | |
2022-12-24 | US | Georgia | Harris | 13145 | 6908 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-25 04:21:04 | Harris, Georgia, US | |
2022-12-24 | US | Kentucky | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-25 04:21:04 | Carter, Kentucky, US | |
2022-12-24 | US | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-25 04:21:04 | Montgomery, Kentucky, US | |
2022-12-24 | US | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-25 04:21:04 | Scott, Kentucky, US | |
2022-12-24 | US | Maine | Somerset | 23025 | 12352 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-25 04:21:04 | Somerset, Maine, US | |
2022-12-24 | US | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-25 04:21:04 | Audrain, Missouri, US | |
2022-12-24 | US | Missouri | Morgan | 29141 | 4790 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-25 04:21:04 | Morgan, Missouri, US | |
2022-12-24 | US | Tennessee | Hickman | 47081 | 8226 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-25 04:21:04 | Hickman, Tennessee, US | |
2022-12-23 | US | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-24 04:21:02 | Burke, Georgia, US | |
2022-12-23 | US | Georgia | Harris | 13145 | 6908 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-24 04:21:02 | Harris, Georgia, US | |
2022-12-23 | US | Kentucky | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-24 04:21:02 | Carter, Kentucky, US | |
2022-12-23 | US | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-24 04:21:02 | Montgomery, Kentucky, US | |
2022-12-23 | US | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-24 04:21:02 | Scott, Kentucky, US | |
2022-12-23 | US | Maine | Somerset | 23025 | 12343 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-24 04:21:02 | Somerset, Maine, US | |
2022-12-23 | US | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-24 04:21:02 | Audrain, Missouri, US | |
2022-12-23 | US | Missouri | Morgan | 29141 | 4790 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-24 04:21:02 | Morgan, Missouri, US | |
2022-12-23 | US | Tennessee | Hickman | 47081 | 8226 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-24 04:21:02 | Hickman, Tennessee, US | |
2022-12-22 | US | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-23 04:21:04 | Burke, Georgia, US | |
2022-12-22 | US | Georgia | Harris | 13145 | 6908 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-23 04:21:04 | Harris, Georgia, US | |
2022-12-22 | US | Kentucky | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-23 04:21:04 | Carter, Kentucky, US | |
2022-12-22 | US | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-23 04:21:04 | Montgomery, Kentucky, US | |
2022-12-22 | US | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-23 04:21:04 | Scott, Kentucky, US | |
2022-12-22 | US | Maine | Somerset | 23025 | 12338 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-23 04:21:04 | Somerset, Maine, US | |
2022-12-22 | US | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-23 04:21:04 | Audrain, Missouri, US | |
2022-12-22 | US | Missouri | Morgan | 29141 | 4790 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-23 04:21:04 | Morgan, Missouri, US | |
2022-12-22 | US | Tennessee | Hickman | 47081 | 8225 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-23 04:21:04 | Hickman, Tennessee, US | |
2022-12-21 | US | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-22 04:20:56 | Burke, Georgia, US | |
2022-12-21 | US | Georgia | Harris | 13145 | 6908 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-22 04:20:56 | Harris, Georgia, US | |
2022-12-21 | US | Kentucky | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-22 04:20:56 | Carter, Kentucky, US | |
2022-12-21 | US | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-22 04:20:56 | Montgomery, Kentucky, US | |
2022-12-21 | US | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-22 04:20:56 | Scott, Kentucky, US | |
2022-12-21 | US | Maine | Somerset | 23025 | 12329 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-22 04:20:56 | Somerset, Maine, US | |
2022-12-21 | US | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-22 04:20:56 | Audrain, Missouri, US | |
2022-12-21 | US | Missouri | Morgan | 29141 | 4790 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-22 04:20:56 | Morgan, Missouri, US | |
2022-12-21 | US | Tennessee | Hickman | 47081 | 8225 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-22 04:20:56 | Hickman, Tennessee, US | |
2022-12-20 | US | Georgia | Burke | 13033 | 6097 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-21 04:21:03 | Burke, Georgia, US | |
2022-12-20 | US | Georgia | Harris | 13145 | 6891 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-21 04:21:03 | Harris, Georgia, US | |
2022-12-20 | US | Iowa | Jasper | 19099 | 10100 | 121 | 0 | 41.68576082 | -93.05567785 | 2022-12-21 04:21:03 | Jasper, Iowa, US | |
2022-12-20 | US | Kentucky | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-21 04:21:03 | Carter, Kentucky, US | |
2022-12-20 | US | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-21 04:21:03 | Montgomery, Kentucky, US | |
2022-12-20 | US | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-21 04:21:03 | Scott, Kentucky, US | |
2022-12-20 | US | Maine | Somerset | 23025 | 12318 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-21 04:21:03 | Somerset, Maine, US | |
2022-12-20 | US | Mississippi | Attala | 28007 | 6516 | 121 | 0 | 33.08658803 | -89.57838564 | 2022-12-21 04:21:03 | Attala, Mississippi, US | |
2022-12-20 | US | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-21 04:21:03 | Audrain, Missouri, US | |
2022-12-20 | US | Missouri | Morgan | 29141 | 4790 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-21 04:21:03 | Morgan, Missouri, US | |
2022-12-20 | US | Tennessee | Hickman | 47081 | 8217 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-21 04:21:03 | Hickman, Tennessee, US | |
2022-12-19 | US | Georgia | Burke | 13033 | 6097 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-20 04:21:04 | Burke, Georgia, US | |
2022-12-19 | US | Georgia | Harris | 13145 | 6891 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-20 04:21:04 | Harris, Georgia, US | |
2022-12-19 | US | Iowa | Jasper | 19099 | 10100 | 121 | 0 | 41.68576082 | -93.05567785 | 2022-12-20 04:21:04 | Jasper, Iowa, US | |
2022-12-19 | US | Kentucky | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-20 04:21:04 | Carter, Kentucky, US | |
2022-12-19 | US | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-20 04:21:04 | Montgomery, Kentucky, US | |
2022-12-19 | US | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-20 04:21:04 | Scott, Kentucky, US | |
2022-12-19 | US | Maine | Somerset | 23025 | 12293 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-20 04:21:04 | Somerset, Maine, US | |
2022-12-19 | US | Mississippi | Attala | 28007 | 6516 | 121 | 0 | 33.08658803 | -89.57838564 | 2022-12-20 04:21:04 | Attala, Mississippi, US | |
2022-12-19 | US | Missouri | Morgan | 29141 | 4778 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-20 04:21:04 | Morgan, Missouri, US | |
2022-12-19 | US | Tennessee | Hickman | 47081 | 8216 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-20 04:21:04 | Hickman, Tennessee, US | |
2022-12-18 | US | Georgia | Burke | 13033 | 6097 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-19 04:21:03 | Burke, Georgia, US | |
2022-12-18 | US | Georgia | Harris | 13145 | 6891 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-19 04:21:03 | Harris, Georgia, US | |
2022-12-18 | US | Iowa | Jasper | 19099 | 10100 | 121 | 0 | 41.68576082 | -93.05567785 | 2022-12-19 04:21:03 | Jasper, Iowa, US | |
2022-12-18 | US | Kentucky | Carter | 21043 | 11493 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-19 04:21:03 | Carter, Kentucky, US | |
2022-12-18 | US | Kentucky | Montgomery | 21173 | 10901 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-19 04:21:03 | Montgomery, Kentucky, US | |
2022-12-18 | US | Kentucky | Scott | 21209 | 22114 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-19 04:21:03 | Scott, Kentucky, US | |
2022-12-18 | US | Maine | Somerset | 23025 | 12293 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-19 04:21:03 | Somerset, Maine, US | |
2022-12-18 | US | Mississippi | Attala | 28007 | 6516 | 121 | 0 | 33.08658803 | -89.57838564 | 2022-12-19 04:21:03 | Attala, Mississippi, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;