daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where confirmed = 27142 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-09-18 | Malaysia | W.P. Putrajaya | 27142 | 30 | 0 | 2.9264 | 101.6964 | 2022-09-19 04:21:49 | W.P. Putrajaya, Malaysia | |||
2022-05-26 | US | Arkansas | Unassigned | 90005 | 27142 | 0 | 0 | 36.38177105 | 0.0 | 2022-05-27 04:20:56 | Unassigned, Arkansas, US | |
2022-05-07 | US | Texas | Grayson | 48181 | 27142 | 635 | 0 | 33.62744998 | -96.67753461 | 2022-05-08 04:20:49 | Grayson, Texas, US | |
2022-05-03 | US | Hawaii | Hawaii | 15001 | 27142 | 187 | 0 | 19.60121157 | -155.5210167 | 2022-05-04 04:20:59 | Hawaii, Hawaii, US | |
2022-05-02 | US | Hawaii | Hawaii | 15001 | 27142 | 187 | 0 | 19.60121157 | -155.5210167 | 2022-05-03 04:21:00 | Hawaii, Hawaii, US | |
2022-05-01 | US | Hawaii | Hawaii | 15001 | 27142 | 187 | 0 | 19.60121157 | -155.5210167 | 2022-05-02 04:21:10 | Hawaii, Hawaii, US | |
2022-04-30 | US | Hawaii | Hawaii | 15001 | 27142 | 187 | 0 | 19.60121157 | -155.5210167 | 2022-05-01 04:20:57 | Hawaii, Hawaii, US | |
2022-04-29 | US | Hawaii | Hawaii | 15001 | 27142 | 187 | 0 | 19.60121157 | -155.5210167 | 2022-04-30 04:21:05 | Hawaii, Hawaii, US | |
2022-04-28 | US | Hawaii | Hawaii | 15001 | 27142 | 187 | 0 | 19.60121157 | -155.5210167 | 2022-04-29 04:20:59 | Hawaii, Hawaii, US | |
2022-04-27 | US | Hawaii | Hawaii | 15001 | 27142 | 187 | 0 | 19.60121157 | -155.5210167 | 2022-04-28 04:20:47 | Hawaii, Hawaii, US | |
2022-02-19 | US | Texas | Randall | 48381 | 27142 | 468 | 0 | 34.96585996 | -101.8971322 | 2022-02-20 04:21:00 | Randall, Texas, US | |
2021-10-06 | Sweden | Sormland | 27142 | 482 | 0 | 59.0336 | 16.7519 | 2021-10-07 04:21:36 | Sormland, Sweden | |||
2021-09-28 | US | Virginia | Chesapeake | 51550 | 27142 | 330 | 0 | 36.67670048 | -76.30545744 | 2021-09-29 04:21:45 | Chesapeake, Virginia, US | |
2021-07-29 | Sweden | Dalarna | 27142 | 344 | 0 | 26798 | 61.0917 | 14.6664 | 2021-07-30 04:21:34 | Dalarna, Sweden | ||
2021-07-28 | Sweden | Dalarna | 27142 | 344 | 0 | 26798 | 61.0917 | 14.6664 | 2021-07-29 04:21:33 | Dalarna, Sweden | ||
2021-06-17 | US | North Carolina | Gaston | 37071 | 27142 | 446 | 0 | 35.29373559 | -81.17477045 | 2021-06-18 04:22:16 | Gaston, North Carolina, US | |
2021-05-30 | US | Georgia | Clayton | 13063 | 27142 | 501 | 0 | 33.54187245 | -84.35594188 | 2021-05-31 03:08:59 | Clayton, Georgia, US | |
2021-04-09 | US | New York | Dutchess | 36027 | 27142 | 428 | 0 | 41.76486060000001 | -73.74356679 | 2021-04-10 04:20:59 | Dutchess, New York, US | |
2020-12-16 | Italy | Sardegna | 27142 | 623 | 11035 | 15484 | 39.21531192 | 9.110616306 | 2020-12-17 05:28:12 | Sardegna, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;