daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where deaths = 4643 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-24 | Chile | Biobio | 482529 | 4643 | 0 | -37.4464 | -72.1416 | 2022-11-25 04:21:06 | Biobio, Chile | |||
2022-10-25 | Malaysia | Johor | 394977 | 4643 | 0 | 1.4854 | 103.7618 | 2022-10-26 04:22:19 | Johor, Malaysia | |||
2022-10-23 | US | New York | Suffolk | 36103 | 522620 | 4643 | 0 | 40.88320119 | -72.8012172 | 2022-10-24 04:22:29 | Suffolk, New York, US | |
2022-10-22 | US | New York | Suffolk | 36103 | 522348 | 4643 | 0 | 40.88320119 | -72.8012172 | 2022-10-23 04:22:46 | Suffolk, New York, US | |
2022-10-21 | US | New York | Suffolk | 36103 | 522050 | 4643 | 0 | 40.88320119 | -72.8012172 | 2022-10-22 04:22:53 | Suffolk, New York, US | |
2022-06-13 | Russia | Chuvashia Republic | 80479 | 4643 | 0 | 55.4259922 | 47.0849429 | 2022-06-14 04:20:52 | Chuvashia Republic, Russia | |||
2022-06-12 | Russia | Chuvashia Republic | 80445 | 4643 | 0 | 55.4259922 | 47.0849429 | 2022-06-13 04:21:14 | Chuvashia Republic, Russia | |||
2022-06-11 | Russia | Chuvashia Republic | 80406 | 4643 | 0 | 55.4259922 | 47.0849429 | 2022-06-12 04:20:53 | Chuvashia Republic, Russia | |||
2022-06-10 | Russia | Chuvashia Republic | 80361 | 4643 | 0 | 55.4259922 | 47.0849429 | 2022-06-11 04:21:01 | Chuvashia Republic, Russia | |||
2022-06-09 | Russia | Chuvashia Republic | 80317 | 4643 | 0 | 55.4259922 | 47.0849429 | 2022-06-10 04:20:55 | Chuvashia Republic, Russia | |||
2022-06-08 | Russia | Chuvashia Republic | 80280 | 4643 | 0 | 55.4259922 | 47.0849429 | 2022-06-09 04:20:54 | Chuvashia Republic, Russia | |||
2022-06-02 | United Kingdom | Northern Ireland | 713294 | 4643 | 0 | 54.7877 | -6.4923 | 2022-06-03 04:20:58 | Northern Ireland, United Kingdom | |||
2022-03-30 | Japan | Osaka | 791075 | 4643 | 0 | 34.620965000000005 | 135.507481 | 2022-03-31 04:20:56 | Osaka, Japan | |||
2022-02-01 | Russia | Novosibirsk Oblast | 104583 | 4643 | 0 | 54.9720169 | 79.48139240000002 | 2022-02-02 04:21:09 | Novosibirsk Oblast, Russia | |||
2022-01-30 | US | California | San Diego | 6073 | 726071 | 4643 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-31 04:21:09 | San Diego, California, US | |
2022-01-29 | US | California | San Diego | 6073 | 726071 | 4643 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-30 04:21:26 | San Diego, California, US | |
2022-01-28 | US | California | San Diego | 6073 | 726071 | 4643 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-29 04:21:10 | San Diego, California, US | |
2021-11-03 | Ukraine | Lviv Oblast | 185466 | 4643 | 0 | 49.8397 | 24.0297 | 2021-11-04 04:22:20 | Lviv Oblast, Ukraine | |||
2021-10-25 | US | New York | New York | 36061 | 168703 | 4643 | 0 | 40.76727260000001 | -73.97152637 | 2021-10-26 04:22:09 | New York, New York, US | |
2021-10-12 | Mexico | Morelos | 49133 | 4643 | 0 | 18.6813 | -99.1013 | 2021-10-13 04:20:51 | Morelos, Mexico | |||
2021-10-11 | Zimbabwe | 131875 | 4643 | 0 | -19.015438 | 29.154857 | 2021-10-12 04:21:09 | Zimbabwe | ||||
2021-08-08 | Mexico | Yucatan | 55988 | 4643 | 0 | 20.7099 | -89.0943 | 2021-08-09 04:21:24 | Yucatan, Mexico | |||
2021-05-25 | Brazil | Alagoas | 189586 | 4643 | 177282 | 7661 | -9.5713 | -36.782 | 2021-05-26 04:20:35 | Alagoas, Brazil | ||
2021-05-02 | Ukraine | Kiev | 196346 | 4643 | 124435 | 67268 | 50.4501 | 30.5234 | 2021-05-03 04:20:39 | Kiev, Ukraine | ||
2021-01-27 | Bosnia and Herzegovina | 120864 | 4643 | 93657 | 22564 | 43.9159 | 17.6791 | 2021-01-28 05:22:24 | Bosnia and Herzegovina | |||
2021-01-16 | Mexico | Sonora | 57342 | 4643 | 0 | 52699 | 29.2972 | -110.3309 | 2021-01-17 05:22:17 | Sonora, Mexico | ||
2021-01-05 | Peru | Lambayeque | 33451 | 4643 | 0 | 28808 | -6.353049 | -79.824113 | 2021-01-06 05:22:16 | Lambayeque, Peru | ||
2020-10-23 | Mexico | Puebla | 34683 | 4643 | 28961 | 1079 | 19.0414 | -98.2063 | 2020-10-24 04:24:46 | Puebla, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;