daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where deaths = 4374 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-04-20 | US | New York | Suffolk | 36103 | 431734 | 4374 | 0 | 40.88320119 | -72.8012172 | 2022-04-21 04:20:46 | Suffolk, New York, US | |
2022-03-26 | Peru | Loreto | 57821 | 4374 | 0 | -4.124847 | -74.424115 | 2022-03-27 04:20:47 | Loreto, Peru | |||
2022-03-25 | Peru | Loreto | 57821 | 4374 | 0 | -4.124847 | -74.424115 | 2022-03-26 04:20:23 | Loreto, Peru | |||
2022-03-24 | Peru | Loreto | 57821 | 4374 | 0 | -4.124847 | -74.424115 | 2022-03-25 04:20:46 | Loreto, Peru | |||
2022-03-23 | Peru | Loreto | 57821 | 4374 | 0 | -4.124847 | -74.424115 | 2022-03-24 04:20:43 | Loreto, Peru | |||
2022-03-23 | Mexico | Quintana Roo | 91241 | 4374 | 0 | 19.1817 | -88.4791 | 2022-03-24 04:20:43 | Quintana Roo, Mexico | |||
2022-03-22 | Peru | Loreto | 57821 | 4374 | 0 | -4.124847 | -74.424115 | 2022-03-23 04:20:48 | Loreto, Peru | |||
2022-03-22 | Mexico | Quintana Roo | 91241 | 4374 | 0 | 19.1817 | -88.4791 | 2022-03-23 04:20:48 | Quintana Roo, Mexico | |||
2022-03-21 | Peru | Loreto | 57821 | 4374 | 0 | -4.124847 | -74.424115 | 2022-03-22 04:20:54 | Loreto, Peru | |||
2022-03-21 | Mexico | Quintana Roo | 91236 | 4374 | 0 | 19.1817 | -88.4791 | 2022-03-22 04:20:54 | Quintana Roo, Mexico | |||
2022-03-20 | Mexico | Quintana Roo | 91229 | 4374 | 0 | 19.1817 | -88.4791 | 2022-03-21 04:20:50 | Quintana Roo, Mexico | |||
2022-03-15 | Dominican Republic | 576788 | 4374 | 0 | 18.7357 | -70.1627 | 2022-03-16 04:20:50 | Dominican Republic | ||||
2022-03-14 | Dominican Republic | 576641 | 4374 | 0 | 18.7357 | -70.1627 | 2022-03-15 04:20:47 | Dominican Republic | ||||
2022-03-13 | Dominican Republic | 576641 | 4374 | 0 | 18.7357 | -70.1627 | 2022-03-14 04:20:46 | Dominican Republic | ||||
2022-03-12 | Dominican Republic | 576367 | 4374 | 0 | 18.7357 | -70.1627 | 2022-03-13 04:20:49 | Dominican Republic | ||||
2022-03-11 | Dominican Republic | 576367 | 4374 | 0 | 18.7357 | -70.1627 | 2022-03-12 04:20:50 | Dominican Republic | ||||
2022-01-19 | Italy | Friuli Venezia Giulia | 220146 | 4374 | 0 | 45.6494354 | 13.76813649 | 2022-01-20 04:21:07 | Friuli Venezia Giulia, Italy | |||
2021-12-12 | US | California | San Diego | 6073 | 415006 | 4374 | 0 | 33.03484597 | -116.73653259999999 | 2021-12-13 04:22:02 | San Diego, California, US | |
2021-12-11 | US | California | San Diego | 6073 | 415006 | 4374 | 0 | 33.03484597 | -116.73653259999999 | 2021-12-12 04:22:12 | San Diego, California, US | |
2021-12-10 | US | California | San Diego | 6073 | 415006 | 4374 | 0 | 33.03484597 | -116.73653259999999 | 2021-12-11 04:22:45 | San Diego, California, US | |
2021-12-09 | Germany | Rheinland-Pfalz | 251709 | 4374 | 0 | 50.1183 | 7.309 | 2021-12-10 04:22:28 | Rheinland-Pfalz, Germany | |||
2021-09-19 | Netherlands | Zuid-Holland | 475591 | 4374 | 0 | 51.937835 | 4.462114 | 2021-09-20 04:21:22 | Zuid-Holland, Netherlands | |||
2021-09-18 | Netherlands | Zuid-Holland | 475087 | 4374 | 0 | 51.937835 | 4.462114 | 2021-09-19 04:21:34 | Zuid-Holland, Netherlands | |||
2021-09-08 | Libya | 319568 | 4374 | 0 | 26.3351 | 17.228331 | 2021-09-09 04:21:27 | Libya | ||||
2021-08-27 | Zimbabwe | 124236 | 4374 | 0 | -19.015438 | 29.154857 | 2021-08-28 04:21:28 | Zimbabwe | ||||
2021-07-27 | Ethiopia | 278920 | 4374 | 262968 | 11578 | 9.145 | 40.4897 | 2021-07-28 04:21:39 | Ethiopia | |||
2021-07-25 | India | Jammu and Kashmir | 320657 | 4374 | 314995 | 1288 | 33.75943 | 76.612638 | 2021-07-26 04:21:28 | Jammu and Kashmir, India | ||
2021-07-24 | India | Jammu and Kashmir | 320491 | 4374 | 314798 | 1319 | 33.75943 | 76.612638 | 2021-07-25 04:22:12 | Jammu and Kashmir, India | ||
2021-07-23 | India | Jammu and Kashmir | 320403 | 4374 | 314454 | 1575 | 33.75943 | 76.612638 | 2021-07-24 00:21:36 | Jammu and Kashmir, India | ||
2021-05-30 | Slovenia | 253631 | 4374 | 244937 | 4320 | 46.1512 | 14.9955 | 2021-05-31 03:08:59 | Slovenia | |||
2021-04-27 | US | New York | New York | 36061 | 134360 | 4374 | 0 | 40.76727260000001 | -73.97152637 | 2021-04-28 04:20:32 | New York, New York, US | |
2021-03-03 | Italy | Campania | 274196 | 4374 | 188570 | 81252 | 40.83956555 | 14.25084984 | 2021-03-04 05:24:24 | Campania, Italy | ||
2021-01-22 | India | Gujarat | 258264 | 4374 | 248650 | 5240 | 22.694884 | 71.590923 | 2021-01-23 05:22:03 | Gujarat, India | ||
2020-12-08 | Italy | Veneto | 170944 | 4374 | 86822 | 79748 | 45.43490485 | 12.33845213 | 2020-12-09 05:28:01 | Veneto, Italy | ||
2020-12-04 | Brazil | Espirito Santo | 197104 | 4374 | 181964 | 10579 | -19.1834 | -40.3089 | 2020-12-05 05:27:36 | Espirito Santo, Brazil | ||
2020-10-07 | Mexico | Puebla | 32664 | 4374 | 27396 | 894 | 19.0414 | -98.2063 | 2020-10-08 04:23:56 | Puebla, Mexico | ||
2020-05-29 | Russia | 387623 | 4374 | 159257 | 223992 | 61.52401 | 105.31875600000001 | 2020-05-30 02:32:48 | Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;