daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,759 rows where deaths = 269 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 1,573
- Russia 29
- Japan 26
- Germany 15
- Sweden 13
- Colombia 10
- Chile 6
- India 6
- Ukraine 6
- Barbados 5
- Korea, South 5
- Peru 5
- United Kingdom 5
- Italy 4
- Netherlands 4
- Canada 3
- Maldives 3
- Saint Lucia 3
- Cyprus 2
- Haiti 2
- Malaysia 2
- Mali 2
- Niger 2
- Pakistan 2
- Spain 2
- Afghanistan 1
- Armenia 1
- Australia 1
- Bangladesh 1
- Belarus 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-30 04:21:04 | Monroe, Tennessee, US | |
2022-12-29 | US | Michigan | Grand Traverse | 26055 | 21131 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-30 04:21:04 | Grand Traverse, Michigan, US | |
2022-12-28 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-29 04:21:01 | Monroe, Tennessee, US | |
2022-12-28 | US | Michigan | Grand Traverse | 26055 | 21131 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-29 04:21:01 | Grand Traverse, Michigan, US | |
2022-12-27 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-28 04:21:04 | Monroe, Tennessee, US | |
2022-12-27 | US | Michigan | Grand Traverse | 26055 | 21131 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-28 04:21:04 | Grand Traverse, Michigan, US | |
2022-12-26 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-27 04:21:07 | Monroe, Tennessee, US | |
2022-12-26 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-27 04:21:07 | Grand Traverse, Michigan, US | |
2022-12-26 | Japan | Tokushima | 126947 | 269 | 0 | 33.919178 | 134.242091 | 2022-12-27 04:21:07 | Tokushima, Japan | |||
2022-12-26 | Japan | Niigata | 384781 | 269 | 0 | 37.521819 | 138.918647 | 2022-12-27 04:21:07 | Niigata, Japan | |||
2022-12-25 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-26 04:21:06 | Monroe, Tennessee, US | |
2022-12-25 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-26 04:21:06 | Grand Traverse, Michigan, US | |
2022-12-25 | Japan | Niigata | 383660 | 269 | 0 | 37.521819 | 138.918647 | 2022-12-26 04:21:06 | Niigata, Japan | |||
2022-12-24 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-25 04:21:04 | Monroe, Tennessee, US | |
2022-12-24 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-25 04:21:04 | Grand Traverse, Michigan, US | |
2022-12-24 | Japan | Niigata | 381702 | 269 | 0 | 37.521819 | 138.918647 | 2022-12-25 04:21:04 | Niigata, Japan | |||
2022-12-23 | US | Tennessee | Monroe | 47123 | 17626 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-24 04:21:02 | Monroe, Tennessee, US | |
2022-12-23 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-24 04:21:02 | Grand Traverse, Michigan, US | |
2022-12-22 | US | Tennessee | Monroe | 47123 | 17614 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-23 04:21:04 | Monroe, Tennessee, US | |
2022-12-22 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-23 04:21:04 | Grand Traverse, Michigan, US | |
2022-12-21 | US | Tennessee | Monroe | 47123 | 17606 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-22 04:20:56 | Monroe, Tennessee, US | |
2022-12-21 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-22 04:20:56 | Grand Traverse, Michigan, US | |
2022-12-21 | US | Illinois | Williamson | 17199 | 28007 | 269 | 0 | 37.73033511 | -88.92994027 | 2022-12-22 04:20:56 | Williamson, Illinois, US | |
2022-12-20 | US | Tennessee | Monroe | 47123 | 17598 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-21 04:21:03 | Monroe, Tennessee, US | |
2022-12-20 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-21 04:21:03 | Grand Traverse, Michigan, US | |
2022-12-20 | US | Illinois | Williamson | 17199 | 27975 | 269 | 0 | 37.73033511 | -88.92994027 | 2022-12-21 04:21:03 | Williamson, Illinois, US | |
2022-12-19 | US | Tennessee | Monroe | 47123 | 17576 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-20 04:21:04 | Monroe, Tennessee, US | |
2022-12-19 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-20 04:21:04 | Grand Traverse, Michigan, US | |
2022-12-19 | US | Illinois | Williamson | 17199 | 27967 | 269 | 0 | 37.73033511 | -88.92994027 | 2022-12-20 04:21:04 | Williamson, Illinois, US | |
2022-12-19 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-20 04:21:04 | Matanuska-Susitna, Alaska, US | |
2022-12-18 | US | Tennessee | Monroe | 47123 | 17562 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-19 04:21:03 | Monroe, Tennessee, US | |
2022-12-18 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-19 04:21:03 | Grand Traverse, Michigan, US | |
2022-12-18 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-19 04:21:03 | Matanuska-Susitna, Alaska, US | |
2022-12-17 | US | Tennessee | Monroe | 47123 | 17562 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-18 04:21:03 | Monroe, Tennessee, US | |
2022-12-17 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-18 04:21:03 | Grand Traverse, Michigan, US | |
2022-12-17 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-18 04:21:03 | Matanuska-Susitna, Alaska, US | |
2022-12-16 | US | Tennessee | Monroe | 47123 | 17562 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-17 04:21:04 | Monroe, Tennessee, US | |
2022-12-16 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-17 04:21:04 | Grand Traverse, Michigan, US | |
2022-12-16 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-17 04:21:04 | Matanuska-Susitna, Alaska, US | |
2022-12-15 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-16 04:21:01 | Grand Traverse, Michigan, US | |
2022-12-15 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-16 04:21:01 | Matanuska-Susitna, Alaska, US | |
2022-12-14 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-15 04:20:58 | Grand Traverse, Michigan, US | |
2022-12-14 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-15 04:20:58 | Matanuska-Susitna, Alaska, US | |
2022-12-13 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-14 04:21:04 | Huntingdon, Pennsylvania, US | |
2022-12-13 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-14 04:21:04 | Grand Traverse, Michigan, US | |
2022-12-13 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-14 04:21:04 | Bannock, Idaho, US | |
2022-12-13 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-14 04:21:04 | Matanuska-Susitna, Alaska, US | |
2022-12-12 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-13 04:21:01 | Huntingdon, Pennsylvania, US | |
2022-12-12 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-13 04:21:01 | Grand Traverse, Michigan, US | |
2022-12-12 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-13 04:21:01 | Bannock, Idaho, US | |
2022-12-12 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-13 04:21:01 | Matanuska-Susitna, Alaska, US | |
2022-12-11 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-12 04:21:01 | Huntingdon, Pennsylvania, US | |
2022-12-11 | US | New York | Steuben | 36101 | 24669 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-12 04:21:01 | Steuben, New York, US | |
2022-12-11 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-12 04:21:01 | Grand Traverse, Michigan, US | |
2022-12-11 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-12 04:21:01 | Bannock, Idaho, US | |
2022-12-11 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-12 04:21:01 | Matanuska-Susitna, Alaska, US | |
2022-12-10 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-11 04:20:50 | Huntingdon, Pennsylvania, US | |
2022-12-10 | US | New York | Steuben | 36101 | 24657 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-11 04:20:50 | Steuben, New York, US | |
2022-12-10 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-11 04:20:50 | Grand Traverse, Michigan, US | |
2022-12-10 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-11 04:20:50 | Bannock, Idaho, US | |
2022-12-10 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-11 04:20:50 | Matanuska-Susitna, Alaska, US | |
2022-12-10 | Japan | Yamagata | 177502 | 269 | 0 | 38.448396 | 140.102154 | 2022-12-11 04:20:50 | Yamagata, Japan | |||
2022-12-09 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-10 04:21:02 | Huntingdon, Pennsylvania, US | |
2022-12-09 | US | New York | Steuben | 36101 | 24642 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-10 04:21:02 | Steuben, New York, US | |
2022-12-09 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-10 04:21:02 | Grand Traverse, Michigan, US | |
2022-12-09 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-10 04:21:02 | Bannock, Idaho, US | |
2022-12-09 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-10 04:21:02 | Matanuska-Susitna, Alaska, US | |
2022-12-09 | Japan | Yamagata | 176062 | 269 | 0 | 38.448396 | 140.102154 | 2022-12-10 04:21:02 | Yamagata, Japan | |||
2022-12-08 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-09 04:21:05 | Huntingdon, Pennsylvania, US | |
2022-12-08 | US | New York | Steuben | 36101 | 24624 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-09 04:21:05 | Steuben, New York, US | |
2022-12-08 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-09 04:21:05 | Grand Traverse, Michigan, US | |
2022-12-08 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-09 04:21:05 | Bannock, Idaho, US | |
2022-12-08 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-09 04:21:05 | Matanuska-Susitna, Alaska, US | |
2022-12-08 | Japan | Yamagata | 174715 | 269 | 0 | 38.448396 | 140.102154 | 2022-12-09 04:21:05 | Yamagata, Japan | |||
2022-12-07 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-08 04:21:07 | Huntingdon, Pennsylvania, US | |
2022-12-07 | US | New York | Steuben | 36101 | 24600 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-08 04:21:07 | Steuben, New York, US | |
2022-12-07 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-08 04:21:07 | Grand Traverse, Michigan, US | |
2022-12-07 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-08 04:21:07 | Bannock, Idaho, US | |
2022-12-07 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-08 04:21:07 | Matanuska-Susitna, Alaska, US | |
2022-12-06 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-07 04:20:58 | Huntingdon, Pennsylvania, US | |
2022-12-06 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-07 04:20:58 | Grand Traverse, Michigan, US | |
2022-12-06 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-07 04:20:58 | Bannock, Idaho, US | |
2022-12-06 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-07 04:20:58 | Matanuska-Susitna, Alaska, US | |
2022-12-06 | Japan | Saga | 182017 | 269 | 0 | 33.286977 | 130.115738 | 2022-12-07 04:20:58 | Saga, Japan | |||
2022-12-05 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-06 04:21:03 | Huntingdon, Pennsylvania, US | |
2022-12-05 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-06 04:21:03 | Bannock, Idaho, US | |
2022-12-05 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-06 04:21:03 | Matanuska-Susitna, Alaska, US | |
2022-12-04 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-05 04:20:58 | Huntingdon, Pennsylvania, US | |
2022-12-04 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-05 04:20:58 | Bannock, Idaho, US | |
2022-12-04 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-05 04:20:58 | Matanuska-Susitna, Alaska, US | |
2022-12-03 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-04 04:20:56 | Huntingdon, Pennsylvania, US | |
2022-12-03 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-04 04:20:56 | Bannock, Idaho, US | |
2022-12-03 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-04 04:20:56 | Matanuska-Susitna, Alaska, US | |
2022-12-02 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-03 04:21:02 | Huntingdon, Pennsylvania, US | |
2022-12-02 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-03 04:21:02 | Bannock, Idaho, US | |
2022-12-02 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-03 04:21:02 | Matanuska-Susitna, Alaska, US | |
2022-12-01 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-02 04:21:07 | Huntingdon, Pennsylvania, US | |
2022-12-01 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-02 04:21:07 | Bannock, Idaho, US | |
2022-12-01 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-02 04:21:07 | Matanuska-Susitna, Alaska, US | |
2022-11-30 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-01 04:21:03 | Huntingdon, Pennsylvania, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;