daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6,099 rows where deaths = 121 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 5,451
- Sierra Leone 137
- Japan 103
- Sweden 98
- Russia 69
- Somalia 15
- United Kingdom 15
- Colombia 14
- Ukraine 14
- Canada 13
- Spain 12
- Mali 11
- Cote d'Ivoire 9
- South Sudan 9
- France 8
- Netherlands 8
- India 7
- Malaysia 7
- Papua New Guinea 7
- Togo 6
- Equatorial Guinea 5
- Andorra 4
- Chad 4
- Timor-Leste 4
- Antigua and Barbuda 3
- Australia 3
- Brazil 3
- Chile 3
- Gambia 3
- Guinea-Bissau 3
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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-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 | Missouri | Audrain | 29007 | 6711 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-30 04:21:04 | Audrain, Missouri, 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 | Kentucky | Carter | 21043 | 11617 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-30 04:21:04 | Carter, Kentucky, US | |
2022-12-29 | San Marino | 23008 | 121 | 0 | 43.9424 | 12.4578 | 2022-12-30 04:21:04 | San Marino | ||||
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-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 | Missouri | Audrain | 29007 | 6711 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-29 04:21:01 | Audrain, Missouri, 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 | Kentucky | Carter | 21043 | 11617 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-29 04:21:01 | Carter, Kentucky, US | |
2022-12-28 | San Marino | 23008 | 121 | 0 | 43.9424 | 12.4578 | 2022-12-29 04:21:01 | San Marino | ||||
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-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 | Missouri | Audrain | 29007 | 6711 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-28 04:21:04 | Audrain, Missouri, 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 | Kentucky | Carter | 21043 | 11617 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-28 04:21:04 | Carter, Kentucky, 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 | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-28 04:21:04 | Burke, Georgia, US | |
2022-12-27 | San Marino | 23008 | 121 | 0 | 43.9424 | 12.4578 | 2022-12-28 04:21:04 | San Marino | ||||
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-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 | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-27 04:21:07 | Audrain, Missouri, 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 | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-27 04:21:07 | Scott, 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 | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-27 04:21:07 | Carter, Kentucky, 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 | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-27 04:21:07 | Burke, Georgia, 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-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 | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-26 04:21:06 | Audrain, Missouri, 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 | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-26 04:21:06 | Scott, 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 | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-26 04:21:06 | Carter, Kentucky, 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 | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-26 04:21:06 | Burke, Georgia, 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-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 | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-25 04:21:04 | Audrain, Missouri, 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 | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-25 04:21:04 | Scott, 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 | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-25 04:21:04 | Carter, Kentucky, 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 | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-25 04:21:04 | Burke, Georgia, 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-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 | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-24 04:21:02 | Audrain, Missouri, 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 | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-24 04:21:02 | Scott, 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 | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-24 04:21:02 | Carter, Kentucky, 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 | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-24 04:21:02 | Burke, Georgia, 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-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 | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-23 04:21:04 | Audrain, Missouri, 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 | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-23 04:21:04 | Scott, 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 | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-23 04:21:04 | Carter, Kentucky, 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 | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-23 04:21:04 | Burke, Georgia, 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-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 | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-22 04:20:56 | Audrain, Missouri, 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 | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-22 04:20:56 | Scott, 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 | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-22 04:20:56 | Carter, Kentucky, 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 | Georgia | Burke | 13033 | 6123 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-22 04:20:56 | Burke, Georgia, 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-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 | Missouri | Audrain | 29007 | 6686 | 121 | 0 | 39.215877 | -91.84242683 | 2022-12-21 04:21:03 | Audrain, Missouri, 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 | Maine | Somerset | 23025 | 12318 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-21 04:21:03 | Somerset, Maine, 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 | Kentucky | Montgomery | 21173 | 10947 | 121 | 0 | 38.03253032 | -83.9145241 | 2022-12-21 04:21:03 | Montgomery, Kentucky, 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 | Iowa | Jasper | 19099 | 10100 | 121 | 0 | 41.68576082 | -93.05567785 | 2022-12-21 04:21:03 | Jasper, Iowa, 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 | Georgia | Burke | 13033 | 6097 | 121 | 0 | 33.05917989 | -81.99928721 | 2022-12-21 04:21:03 | Burke, Georgia, 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-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 | Mississippi | Attala | 28007 | 6516 | 121 | 0 | 33.08658803 | -89.57838564 | 2022-12-20 04:21:04 | Attala, Mississippi, 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 | Kentucky | Scott | 21209 | 22186 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-20 04:21:04 | Scott, 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 | Carter | 21043 | 11546 | 121 | 0 | 38.31690743 | -83.05092385 | 2022-12-20 04:21:04 | Carter, Kentucky, 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 | Georgia | Harris | 13145 | 6891 | 121 | 0 | 32.73709786 | -84.90538572 | 2022-12-20 04:21:04 | Harris, Georgia, 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-18 | US | Tennessee | Hickman | 47081 | 8210 | 121 | 0 | 35.80609681 | -87.47643507 | 2022-12-19 04:21:03 | Hickman, Tennessee, US | |
2022-12-18 | US | Missouri | Morgan | 29141 | 4778 | 121 | 0 | 38.4181765 | -92.88791859 | 2022-12-19 04:21:03 | Morgan, Missouri, US | |
2022-12-18 | US | Mississippi | Attala | 28007 | 6516 | 121 | 0 | 33.08658803 | -89.57838564 | 2022-12-19 04:21:03 | Attala, Mississippi, 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 | Kentucky | Scott | 21209 | 22114 | 121 | 0 | 38.29622293 | -84.5816631 | 2022-12-19 04:21:03 | Scott, Kentucky, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;