daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 6802 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-08 | Japan | Osaka | 2335117 | 6802 | 0 | 34.620965 | 135.507481 | 2022-12-09 04:21:05 | Osaka, Japan | |||
2022-09-16 | Slovenia | 1153964 | 6802 | 0 | 46.1512 | 14.9955 | 2022-09-17 04:20:19 | Slovenia | ||||
2022-09-15 | Slovenia | 1151774 | 6802 | 0 | 46.1512 | 14.9955 | 2022-09-16 04:21:19 | Slovenia | ||||
2022-08-03 | Mexico | Guerrero | 112640 | 6802 | 0 | 17.4392 | -99.5451 | 2022-08-04 04:20:58 | Guerrero, Mexico | |||
2022-04-18 | Russia | Volgograd Oblast | 213752 | 6802 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-04-19 04:21:00 | Volgograd Oblast, Russia | |||
2022-04-14 | Mexico | Yucatan | 108794 | 6802 | 0 | 20.7099 | -89.0943 | 2022-04-15 04:20:57 | Yucatan, Mexico | |||
2022-02-19 | Ukraine | Kharkiv Oblast | 301213 | 6802 | 0 | 49.9935 | 36.2304 | 2022-02-20 04:21:00 | Kharkiv Oblast, Ukraine | |||
2022-01-26 | US | Nevada | Clark | 32003 | 482680 | 6802 | 0 | 36.21458855 | -115.0130241 | 2022-01-27 04:21:19 | Clark, Nevada, US | |
2021-11-25 | US | New York | Bronx | 36005 | 212370 | 6802 | 0 | 40.85209301 | -73.86282755 | 2021-11-26 04:22:33 | Bronx, New York, US | |
2021-11-24 | US | New York | Bronx | 36005 | 212370 | 6802 | 0 | 40.85209301 | -73.86282755 | 2021-11-25 04:22:33 | Bronx, New York, US | |
2021-11-05 | Mexico | Tamaulipas | 101627 | 6802 | 0 | 24.2669 | -98.8363 | 2021-11-06 04:21:51 | Tamaulipas, Mexico | |||
2021-10-09 | Italy | Puglia | 269696 | 6802 | 0 | 41.12559576 | 16.86736689 | 2021-10-10 04:21:38 | Puglia, Italy | |||
2021-10-06 | Colombia | Cundinamarca | 263807 | 6802 | 0 | 5.026 | -74.03 | 2021-10-07 04:21:36 | Cundinamarca, Colombia | |||
2021-04-27 | Germany | Hessen | 256451 | 6802 | 227700 | 23972 | 50.6521 | 9.1624 | 2021-04-28 04:20:32 | Hessen, Germany | ||
2021-04-24 | Peru | Lambayeque | 48480 | 6802 | 0 | 41678 | -6.353049 | -79.824113 | 2021-04-25 04:20:32 | Lambayeque, Peru | ||
2021-03-28 | Guatemala | 193377 | 6802 | 175438 | 11137 | 15.7835 | -90.2308 | 2021-03-29 04:28:35 | Guatemala | |||
2021-02-01 | Tunisia | 210045 | 6802 | 162223 | 41020 | 33.886917 | 9.537499 | 2021-02-02 05:22:49 | Tunisia | |||
2021-01-25 | Peru | Piura | 45248 | 6802 | 0 | 38446 | -5.133361 | -80.335861 | 2021-01-26 05:22:02 | Piura, Peru | ||
2020-11-10 | Brazil | Para | 259189 | 6802 | 242136 | 9376 | -1.9981 | -54.9306 | 2020-11-11 05:25:30 | Para, Brazil | ||
2020-11-09 | India | Andhra Pradesh | 844359 | 6802 | 816322 | 21235 | 15.9129 | 79.74 | 2020-11-10 05:40:07 | Andhra Pradesh, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;