daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 29101 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-05-20 | Japan | Akita | 29101 | 66 | 0 | 39.748679 | 140.408228 | 2022-05-21 04:20:58 | Akita, Japan | |||
2022-04-24 | US | Tennessee | Maury | 47119 | 29101 | 345 | 0 | 35.618741299999996 | -87.07462444 | 2022-04-25 04:20:56 | Maury, Tennessee, US | |
2022-02-26 | US | Texas | Wichita | 48485 | 29101 | 645 | 0 | 33.98842886 | -98.70410340000001 | 2022-02-27 04:21:04 | Wichita, Texas, US | |
2022-01-02 | US | West Virginia | Kanawha | 54039 | 29101 | 573 | 0 | 38.33860077 | -81.52857054 | 2022-01-03 02:22:25 | Kanawha, West Virginia, US | |
2022-01-01 | US | West Virginia | Kanawha | 54039 | 29101 | 573 | 0 | 38.33860077 | -81.52857054 | 2022-01-02 04:20:52 | Kanawha, West Virginia, US | |
2021-12-31 | US | West Virginia | Kanawha | 54039 | 29101 | 573 | 0 | 38.33860077 | -81.52857054 | 2022-01-01 04:22:14 | Kanawha, West Virginia, US | |
2021-12-30 | US | West Virginia | Kanawha | 54039 | 29101 | 573 | 0 | 38.33860077 | -81.52857054 | 2021-12-31 04:21:50 | Kanawha, West Virginia, US | |
2021-12-22 | US | Ohio | Medina | 39103 | 29101 | 415 | 0 | 41.11770589 | -81.89986209999998 | 2021-12-23 04:21:21 | Medina, Ohio, US | |
2021-11-05 | US | Arizona | Yavapai | 4025 | 29101 | 708 | 0 | 34.59933926 | -112.5538588 | 2021-11-06 04:21:51 | Yavapai, Arizona, US | |
2021-10-24 | Mexico | Tlaxcala | 29101 | 2937 | 0 | 19.3139 | -98.2404 | 2021-10-25 04:22:31 | Tlaxcala, Mexico | |||
2021-10-23 | Mexico | Tlaxcala | 29101 | 2937 | 0 | 19.3139 | -98.2404 | 2021-10-24 04:21:22 | Tlaxcala, Mexico | |||
2021-10-02 | US | Colorado | Boulder | 8013 | 29101 | 250 | 0 | 40.09313619 | -105.3546767 | 2021-10-03 04:21:24 | Boulder, Colorado, US | |
2021-05-28 | Netherlands | Zeeland | 29101 | 246 | 0 | 28826 | 51.47936 | 3.861559 | 2021-05-29 04:20:41 | Zeeland, Netherlands | ||
2020-12-20 | Colombia | Cordoba | 29101 | 1667 | 26327 | 1107 | 8.0493 | -75.574 | 2020-12-21 05:27:58 | Cordoba, Colombia | ||
2020-12-15 | US | California | Ventura | 6111 | 29101 | 201 | 0 | 28956 | 34.44465746 | -119.0910613 | 2020-12-16 05:28:04 | Ventura, California, US |
2020-10-24 | Germany | Niedersachsen | 29101 | 728 | 22925 | 5986 | 52.6367 | 9.8451 | 2020-10-25 04:24:36 | Niedersachsen, Germany | ||
2020-08-05 | Brazil | Mato Grosso do Sul | 29101 | 458 | 22020 | 5853 | -20.7722 | -54.7852 | 2020-08-06 04:35:02 | Mato Grosso do Sul, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;