daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23 rows where confirmed = 42832 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-10-19 | Colombia | Casanare | 42832 | 1025 | 0 | 5.7589 | -71.5724 | 2022-10-20 04:22:59 | Casanare, Colombia | |||
2022-10-18 | Colombia | Casanare | 42832 | 1025 | 0 | 5.7589 | -71.5724 | 2022-10-19 04:22:26 | Casanare, Colombia | |||
2022-10-17 | Colombia | Casanare | 42832 | 1025 | 0 | 5.7589 | -71.5724 | 2022-10-18 04:22:42 | Casanare, Colombia | |||
2022-10-16 | Colombia | Casanare | 42832 | 1025 | 0 | 5.7589 | -71.5724 | 2022-10-17 04:20:31 | Casanare, Colombia | |||
2022-10-15 | Colombia | Casanare | 42832 | 1025 | 0 | 5.7589 | -71.5724 | 2022-10-16 04:22:39 | Casanare, Colombia | |||
2022-10-14 | Colombia | Casanare | 42832 | 1025 | 0 | 5.7589 | -71.5724 | 2022-10-15 04:22:00 | Casanare, Colombia | |||
2022-10-13 | Colombia | Casanare | 42832 | 1025 | 0 | 5.7589 | -71.5724 | 2022-10-14 04:22:28 | Casanare, Colombia | |||
2022-08-01 | Mexico | Chiapas | 42832 | 2424 | 0 | 16.7569 | -93.1292 | 2022-08-02 04:20:53 | Chiapas, Mexico | |||
2022-07-25 | US | Michigan | Muskegon | 26121 | 42832 | 651 | 0 | 43.29123859 | -86.15176712 | 2022-07-26 04:20:58 | Muskegon, Michigan, US | |
2022-07-24 | US | Michigan | Muskegon | 26121 | 42832 | 651 | 0 | 43.29123859 | -86.15176712 | 2022-07-25 04:20:51 | Muskegon, Michigan, US | |
2022-07-23 | US | Michigan | Muskegon | 26121 | 42832 | 651 | 0 | 43.29123859 | -86.15176712 | 2022-07-24 04:20:47 | Muskegon, Michigan, US | |
2022-07-22 | US | Michigan | Muskegon | 26121 | 42832 | 651 | 0 | 43.29123859 | -86.15176712 | 2022-07-23 04:20:53 | Muskegon, Michigan, US | |
2022-07-21 | US | Michigan | Muskegon | 26121 | 42832 | 651 | 0 | 43.29123859 | -86.15176712 | 2022-07-22 04:21:15 | Muskegon, Michigan, US | |
2022-07-20 | US | Michigan | Muskegon | 26121 | 42832 | 651 | 0 | 43.29123859 | -86.15176712 | 2022-07-21 04:21:10 | Muskegon, Michigan, US | |
2022-07-19 | US | Michigan | Muskegon | 26121 | 42832 | 651 | 0 | 43.29123859 | -86.15176712 | 2022-07-20 04:20:59 | Muskegon, Michigan, US | |
2022-03-01 | US | Pennsylvania | Lackawanna | 42069 | 42832 | 725 | 0 | 41.43564672 | -75.60379201 | 2022-03-02 04:21:07 | Lackawanna, Pennsylvania, US | |
2022-02-24 | US | Maryland | Howard | 24027 | 42832 | 363 | 0 | 39.25305293 | -76.93126208 | 2022-02-25 04:21:11 | Howard, Maryland, US | |
2021-08-18 | Madagascar | 42832 | 954 | 0 | -18.766947000000002 | 46.869107 | 2021-08-19 04:21:15 | Madagascar | ||||
2021-06-09 | Russia | Tver Oblast | 42832 | 1097 | 40130 | 1605 | 57.1134475 | 35.174442799999994 | 2021-06-10 04:23:17 | Tver Oblast, Russia | ||
2021-04-16 | Malaysia | Johor | 42832 | 110 | 41609 | 1113 | 1.4854 | 103.7618 | 2021-04-17 04:20:40 | Johor, Malaysia | ||
2021-03-20 | US | Pennsylvania | Delaware | 42045 | 42832 | 1271 | 0 | 39.91680171 | -75.40243663 | 2021-03-21 05:25:44 | Delaware, Pennsylvania, US | |
2020-12-02 | US | Colorado | Denver | 8031 | 42832 | 644 | 0 | 36976 | 39.76018276 | -104.8725695 | 2020-12-03 05:28:22 | Denver, Colorado, US |
2020-11-24 | Belgium | Flemish Brabant | 42832 | 0 | 0 | 42832 | 50.9167 | 4.5833 | 2020-11-25 05:27:20 | Flemish Brabant, Belgium |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;