daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 41306 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 11
- Netherlands 3
- Colombia 1
- Italy 1
- Japan 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-27 | US | Ohio | Greene | 39057 | 41306 | 519 | 0 | 39.69116283 | -83.89032084 | 2022-07-28 04:20:56 | Greene, Ohio, US | |
2022-07-26 | US | Ohio | Greene | 39057 | 41306 | 519 | 0 | 39.69116283 | -83.89032084 | 2022-07-27 04:21:04 | Greene, Ohio, US | |
2022-07-25 | US | Texas | Guadalupe | 48187 | 41306 | 403 | 0 | 29.58165339 | -97.94786822 | 2022-07-26 04:20:58 | Guadalupe, Texas, US | |
2022-07-25 | US | Ohio | Greene | 39057 | 41306 | 519 | 0 | 39.69116283 | -83.89032084 | 2022-07-26 04:20:58 | Greene, Ohio, US | |
2022-07-24 | US | Ohio | Greene | 39057 | 41306 | 519 | 0 | 39.69116283 | -83.89032084 | 2022-07-25 04:20:51 | Greene, Ohio, US | |
2022-07-23 | US | Ohio | Greene | 39057 | 41306 | 519 | 0 | 39.69116283 | -83.89032084 | 2022-07-24 04:20:47 | Greene, Ohio, US | |
2022-07-22 | US | Ohio | Greene | 39057 | 41306 | 519 | 0 | 39.69116283 | -83.89032084 | 2022-07-23 04:20:53 | Greene, Ohio, US | |
2022-07-21 | US | Ohio | Greene | 39057 | 41306 | 519 | 0 | 39.69116283 | -83.89032084 | 2022-07-22 04:21:15 | Greene, Ohio, US | |
2022-04-15 | Netherlands | Curacao | 41306 | 271 | 0 | 12.1696 | -68.99 | 2022-04-16 04:20:48 | Curacao, Netherlands | |||
2022-04-14 | Netherlands | Curacao | 41306 | 271 | 0 | 12.1696 | -68.99 | 2022-04-15 04:20:57 | Curacao, Netherlands | |||
2022-04-13 | Netherlands | Curacao | 41306 | 271 | 0 | 12.1696 | -68.99 | 2022-04-13 23:21:06 | Curacao, Netherlands | |||
2022-02-24 | Colombia | Casanare | 41306 | 982 | 0 | 5.7589 | -71.5724 | 2022-02-25 04:21:11 | Casanare, Colombia | |||
2021-10-29 | US | Pennsylvania | Luzerne | 42079 | 41306 | 931 | 0 | 41.17823008 | -75.98447579 | 2021-10-30 04:22:03 | Luzerne, Pennsylvania, US | |
2021-10-26 | US | California | Sonoma | 6097 | 41306 | 404 | 0 | 38.52746429 | -122.88625060000001 | 2021-10-27 04:22:32 | Sonoma, California, US | |
2021-07-12 | Japan | Hyogo | 41306 | 1310 | 39620 | 376 | 35.039913 | 134.828057 | 2021-07-13 04:21:18 | Hyogo, Japan | ||
2021-03-02 | Italy | Sardegna | 41306 | 1170 | 27397 | 12739 | 39.21531192 | 9.110616306 | 2021-03-03 05:23:28 | Sardegna, Italy | ||
2020-06-28 | US | New York | Suffolk | 36103 | 41306 | 1978 | 0 | 39328 | 40.88320119 | -72.8012172 | 2020-06-29 04:33:44 | Suffolk, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;