daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,671 rows where deaths = 159 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 3,350
- Japan 46
- Russia 39
- Spain 25
- Comoros 23
- Sweden 19
- Benin 14
- Colombia 12
- Gabon 12
- Netherlands 12
- Chile 9
- Ukraine 9
- France 7
- India 7
- Nicaragua 7
- Peru 7
- Seychelles 6
- Brazil 5
- Bosnia and Herzegovina 4
- Djibouti 4
- Guyana 4
- Cabo Verde 3
- Malaysia 3
- Mauritania 3
- Niger 3
- Cameroon 2
- Canada 2
- Germany 2
- Slovakia 2
- Slovenia 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | South Carolina | Union | 45087 | 9411 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-30 04:21:04 | Union, South Carolina, US | |
2022-12-29 | US | Pennsylvania | Union | 42119 | 13303 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-30 04:21:04 | Union, Pennsylvania, US | |
2022-12-29 | US | Ohio | Champaign | 39021 | 10541 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-30 04:21:04 | Champaign, Ohio, US | |
2022-12-29 | US | Mississippi | Simpson | 28127 | 8308 | 159 | 0 | 31.91282117 | -89.91716179 | 2022-12-30 04:21:04 | Simpson, Mississippi, US | |
2022-12-29 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-30 04:21:04 | Randolph, Indiana, US | |
2022-12-29 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-30 04:21:04 | Fayette, Indiana, US | |
2022-12-28 | US | South Carolina | Union | 45087 | 9411 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-29 04:21:01 | Union, South Carolina, US | |
2022-12-28 | US | Pennsylvania | Union | 42119 | 13303 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-29 04:21:01 | Union, Pennsylvania, US | |
2022-12-28 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-29 04:21:01 | Champaign, Ohio, US | |
2022-12-28 | US | Mississippi | Simpson | 28127 | 8308 | 159 | 0 | 31.91282117 | -89.91716179 | 2022-12-29 04:21:01 | Simpson, Mississippi, US | |
2022-12-28 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-29 04:21:01 | Randolph, Indiana, US | |
2022-12-28 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-29 04:21:01 | Fayette, Indiana, US | |
2022-12-27 | US | South Carolina | Union | 45087 | 9411 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-28 04:21:04 | Union, South Carolina, US | |
2022-12-27 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-28 04:21:04 | Union, Pennsylvania, US | |
2022-12-27 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-28 04:21:04 | Champaign, Ohio, US | |
2022-12-27 | US | Mississippi | Simpson | 28127 | 8308 | 159 | 0 | 31.91282117 | -89.91716179 | 2022-12-28 04:21:04 | Simpson, Mississippi, US | |
2022-12-27 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-28 04:21:04 | Randolph, Indiana, US | |
2022-12-27 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-28 04:21:04 | Fayette, Indiana, US | |
2022-12-27 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-28 04:21:04 | Nez Perce, Idaho, US | |
2022-12-26 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-27 04:21:07 | Union, South Carolina, US | |
2022-12-26 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-27 04:21:07 | Chester, South Carolina, US | |
2022-12-26 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-27 04:21:07 | Union, Pennsylvania, US | |
2022-12-26 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-27 04:21:07 | Champaign, Ohio, US | |
2022-12-26 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-27 04:21:07 | Oldham, Kentucky, US | |
2022-12-26 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-27 04:21:07 | Randolph, Indiana, US | |
2022-12-26 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-27 04:21:07 | Fayette, Indiana, US | |
2022-12-26 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-27 04:21:07 | Nez Perce, Idaho, US | |
2022-12-25 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-26 04:21:06 | Union, South Carolina, US | |
2022-12-25 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-26 04:21:06 | Chester, South Carolina, US | |
2022-12-25 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-26 04:21:06 | Union, Pennsylvania, US | |
2022-12-25 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-26 04:21:06 | Champaign, Ohio, US | |
2022-12-25 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-26 04:21:06 | Oldham, Kentucky, US | |
2022-12-25 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-26 04:21:06 | Randolph, Indiana, US | |
2022-12-25 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-26 04:21:06 | Fayette, Indiana, US | |
2022-12-25 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-26 04:21:06 | Nez Perce, Idaho, US | |
2022-12-24 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-25 04:21:04 | Union, South Carolina, US | |
2022-12-24 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-25 04:21:04 | Chester, South Carolina, US | |
2022-12-24 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-25 04:21:04 | Union, Pennsylvania, US | |
2022-12-24 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-25 04:21:04 | Champaign, Ohio, US | |
2022-12-24 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-25 04:21:04 | Oldham, Kentucky, US | |
2022-12-24 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-25 04:21:04 | Randolph, Indiana, US | |
2022-12-24 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-25 04:21:04 | Fayette, Indiana, US | |
2022-12-24 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-25 04:21:04 | Nez Perce, Idaho, US | |
2022-12-23 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-24 04:21:02 | Union, South Carolina, US | |
2022-12-23 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-24 04:21:02 | Chester, South Carolina, US | |
2022-12-23 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-24 04:21:02 | Union, Pennsylvania, US | |
2022-12-23 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-24 04:21:02 | Champaign, Ohio, US | |
2022-12-23 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-24 04:21:02 | Oldham, Kentucky, US | |
2022-12-23 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-24 04:21:02 | Randolph, Indiana, US | |
2022-12-23 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-24 04:21:02 | Fayette, Indiana, US | |
2022-12-23 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-24 04:21:02 | Nez Perce, Idaho, US | |
2022-12-22 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-23 04:21:04 | Union, South Carolina, US | |
2022-12-22 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-23 04:21:04 | Chester, South Carolina, US | |
2022-12-22 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-23 04:21:04 | Union, Pennsylvania, US | |
2022-12-22 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-23 04:21:04 | Champaign, Ohio, US | |
2022-12-22 | US | New Mexico | Rio Arriba | 35039 | 13075 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-23 04:21:04 | Rio Arriba, New Mexico, US | |
2022-12-22 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-23 04:21:04 | Oldham, Kentucky, US | |
2022-12-22 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-23 04:21:04 | Randolph, Indiana, US | |
2022-12-22 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-23 04:21:04 | Fayette, Indiana, US | |
2022-12-22 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-23 04:21:04 | Nez Perce, Idaho, US | |
2022-12-21 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-22 04:20:56 | Union, South Carolina, US | |
2022-12-21 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-22 04:20:56 | Chester, South Carolina, US | |
2022-12-21 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-22 04:20:56 | Union, Pennsylvania, US | |
2022-12-21 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-22 04:20:56 | Champaign, Ohio, US | |
2022-12-21 | US | New Mexico | Rio Arriba | 35039 | 13068 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-22 04:20:56 | Rio Arriba, New Mexico, US | |
2022-12-21 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-22 04:20:56 | Oldham, Kentucky, US | |
2022-12-21 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-22 04:20:56 | Randolph, Indiana, US | |
2022-12-21 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-22 04:20:56 | Fayette, Indiana, US | |
2022-12-21 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-22 04:20:56 | Nez Perce, Idaho, US | |
2022-12-20 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-21 04:21:03 | Union, South Carolina, US | |
2022-12-20 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-21 04:21:03 | Chester, South Carolina, US | |
2022-12-20 | US | Pennsylvania | Union | 42119 | 13223 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-21 04:21:03 | Union, Pennsylvania, US | |
2022-12-20 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-21 04:21:03 | Champaign, Ohio, US | |
2022-12-20 | US | New Mexico | Rio Arriba | 35039 | 13052 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-21 04:21:03 | Rio Arriba, New Mexico, US | |
2022-12-20 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-21 04:21:03 | Oldham, Kentucky, US | |
2022-12-20 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-21 04:21:03 | Randolph, Indiana, US | |
2022-12-20 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-21 04:21:03 | Fayette, Indiana, US | |
2022-12-20 | US | Idaho | Nez Perce | 16069 | 10349 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-21 04:21:03 | Nez Perce, Idaho, US | |
2022-12-19 | US | South Carolina | Union | 45087 | 9268 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-20 04:21:04 | Union, South Carolina, US | |
2022-12-19 | US | South Carolina | Chester | 45023 | 12004 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-20 04:21:04 | Chester, South Carolina, US | |
2022-12-19 | US | Pennsylvania | Union | 42119 | 13223 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-20 04:21:04 | Union, Pennsylvania, US | |
2022-12-19 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-20 04:21:04 | Champaign, Ohio, US | |
2022-12-19 | US | New Mexico | Rio Arriba | 35039 | 13049 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-20 04:21:04 | Rio Arriba, New Mexico, US | |
2022-12-19 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-20 04:21:04 | Oldham, Kentucky, US | |
2022-12-19 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-20 04:21:04 | Randolph, Indiana, US | |
2022-12-19 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-20 04:21:04 | Fayette, Indiana, US | |
2022-12-19 | US | Idaho | Nez Perce | 16069 | 10349 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-20 04:21:04 | Nez Perce, Idaho, US | |
2022-12-18 | US | South Carolina | Union | 45087 | 9268 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-19 04:21:03 | Union, South Carolina, US | |
2022-12-18 | US | South Carolina | Chester | 45023 | 12004 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-19 04:21:03 | Chester, South Carolina, US | |
2022-12-18 | US | Pennsylvania | Union | 42119 | 13223 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-19 04:21:03 | Union, Pennsylvania, US | |
2022-12-18 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-19 04:21:03 | Champaign, Ohio, US | |
2022-12-18 | US | New Mexico | Rio Arriba | 35039 | 13034 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-19 04:21:03 | Rio Arriba, New Mexico, US | |
2022-12-18 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-19 04:21:03 | Randolph, Indiana, US | |
2022-12-18 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-19 04:21:03 | Fayette, Indiana, US | |
2022-12-18 | US | Idaho | Nez Perce | 16069 | 10349 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-19 04:21:03 | Nez Perce, Idaho, US | |
2022-12-17 | US | South Carolina | Union | 45087 | 9268 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-18 04:21:03 | Union, South Carolina, US | |
2022-12-17 | US | South Carolina | Chester | 45023 | 12004 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-18 04:21:03 | Chester, South Carolina, US | |
2022-12-17 | US | Pennsylvania | Union | 42119 | 13223 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-18 04:21:03 | Union, Pennsylvania, US | |
2022-12-17 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-18 04:21:03 | Champaign, Ohio, US | |
2022-12-17 | US | New Mexico | Rio Arriba | 35039 | 13034 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-18 04:21:03 | Rio Arriba, New Mexico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;