daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where deaths = 4540 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-12-18 | Russia | Omsk Oblast | 230958 | 4540 | 0 | 56.0935263 | 73.5099936 | 2022-12-19 04:21:03 | Omsk Oblast, Russia | |||
2022-09-28 | Chile | Biobio | 452549 | 4540 | 0 | -37.4464 | -72.1416 | 2022-09-29 04:22:34 | Biobio, Chile | |||
2022-09-27 | Chile | Biobio | 452051 | 4540 | 0 | -37.4464 | -72.1416 | 2022-09-28 04:23:01 | Biobio, Chile | |||
2022-09-26 | Chile | Biobio | 451782 | 4540 | 0 | -37.4464 | -72.1416 | 2022-09-27 04:23:01 | Biobio, Chile | |||
2022-09-11 | Peru | Cajamarca | 108893 | 4540 | 0 | -6.430284 | -78.745596 | 2022-09-12 04:20:58 | Cajamarca, Peru | |||
2022-09-10 | Peru | Cajamarca | 108893 | 4540 | 0 | -6.430284 | -78.745596 | 2022-09-11 04:20:50 | Cajamarca, Peru | |||
2022-09-09 | Peru | Cajamarca | 108893 | 4540 | 0 | -6.430284 | -78.745596 | 2022-09-10 04:21:10 | Cajamarca, Peru | |||
2022-09-08 | Peru | Cajamarca | 108893 | 4540 | 0 | -6.430284 | -78.745596 | 2022-09-09 04:21:11 | Cajamarca, Peru | |||
2022-09-07 | Peru | Cajamarca | 108893 | 4540 | 0 | -6.430284 | -78.745596 | 2022-09-08 04:21:02 | Cajamarca, Peru | |||
2022-09-06 | Peru | Cajamarca | 108893 | 4540 | 0 | -6.430284 | -78.745596 | 2022-09-07 04:20:59 | Cajamarca, Peru | |||
2022-08-17 | US | New York | Suffolk | 36103 | 497683 | 4540 | 0 | 40.88320119 | -72.8012172 | 2022-08-18 04:21:11 | Suffolk, New York, US | |
2022-07-02 | Malaysia | Johor | 386159 | 4540 | 0 | 1.4854 | 103.7618 | 2022-07-03 04:20:59 | Johor, Malaysia | |||
2022-07-01 | Malaysia | Johor | 386080 | 4540 | 0 | 1.4854 | 103.7618 | 2022-07-02 04:21:16 | Johor, Malaysia | |||
2022-04-14 | United Kingdom | Northern Ireland | 699769 | 4540 | 0 | 54.7877 | -6.4923 | 2022-04-15 04:20:57 | Northern Ireland, United Kingdom | |||
2022-01-24 | Russia | Novosibirsk Oblast | 100837 | 4540 | 0 | 54.9720169 | 79.48139240000002 | 2022-01-25 04:21:05 | Novosibirsk Oblast, Russia | |||
2022-01-16 | US | California | San Diego | 6073 | 595420 | 4540 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-17 04:21:08 | San Diego, California, US | |
2022-01-15 | US | California | San Diego | 6073 | 595420 | 4540 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-16 04:21:12 | San Diego, California, US | |
2022-01-14 | US | California | San Diego | 6073 | 595420 | 4540 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-15 04:21:07 | San Diego, California, US | |
2022-01-09 | India | Jammu and Kashmir | 344652 | 4540 | 0 | 33.75943 | 76.612638 | 2022-01-10 04:22:07 | Jammu and Kashmir, India | |||
2021-09-08 | Russia | Irkutsk Oblast | 100838 | 4540 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-09 04:21:27 | Irkutsk Oblast, Russia | |||
2021-08-07 | Pakistan | Khyber Pakhtunkhwa | 147973 | 4540 | 0 | 34.485332 | 72.09169 | 2021-08-08 04:21:33 | Khyber Pakhtunkhwa, Pakistan | |||
2021-08-04 | Russia | Krasnoyarsk Krai | 92883 | 4540 | 78441 | 9902 | 63.3233807 | 97.0979974 | 2021-08-05 04:21:51 | Krasnoyarsk Krai, Russia | ||
2021-07-09 | Armenia | 226135 | 4540 | 217490 | 4105 | 40.0691 | 45.0382 | 2021-07-10 04:21:25 | Armenia | |||
2021-06-17 | Mexico | Guerrero | 41547 | 4540 | 0 | 37007 | 17.4392 | -99.5451 | 2021-06-18 04:22:16 | Guerrero, Mexico | ||
2021-06-09 | Russia | Rostov Oblast | 95618 | 4540 | 86825 | 4253 | 47.6222451 | 40.7957942 | 2021-06-10 04:23:17 | Rostov Oblast, Russia | ||
2021-05-20 | Georgia | 334705 | 4540 | 315254 | 14911 | 42.3154 | 43.3569 | 2021-05-21 04:20:43 | Georgia | |||
2021-04-25 | US | Michigan | Wayne | 26163 | 150249 | 4540 | 0 | 42.28098405 | -83.281255 | 2021-04-26 04:21:04 | Wayne, Michigan, US | |
2021-04-24 | US | Michigan | Wayne | 26163 | 150249 | 4540 | 0 | 42.28098405 | -83.281255 | 2021-04-25 04:20:32 | Wayne, Michigan, US | |
2021-01-09 | Mexico | Chihuahua | 37447 | 4540 | 0 | 32907 | 28.633000000000006 | -106.0691 | 2021-01-10 05:22:12 | Chihuahua, Mexico | ||
2020-10-18 | Mexico | Puebla | 33942 | 4540 | 28503 | 899 | 19.0414 | -98.2063 | 2020-10-19 04:24:16 | Puebla, Mexico | ||
2020-05-31 | Turkey | 163942 | 4540 | 127973 | 31429 | 38.9637 | 35.2433 | 2020-06-01 02:32:46 | Turkey |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;