daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where confirmed = 35743 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-23 | US | Puerto Rico | Ponce | 72113 | 35743 | 0 | 0 | 18.059498 | -66.613748 | 2022-10-24 04:22:29 | Ponce, Puerto Rico, US | |
2022-06-30 | US | Texas | Parker | 48367 | 35743 | 453 | 0 | 32.77757172 | -97.80500621 | 2022-07-01 04:21:10 | Parker, Texas, US | |
2022-04-27 | US | Texas | Potter | 48375 | 35743 | 738 | 0 | 35.40133773 | -101.893964 | 2022-04-28 04:20:47 | Potter, Texas, US | |
2022-03-15 | Mexico | Chiapas | 35743 | 2393 | 0 | 16.7569 | -93.1292 | 2022-03-16 04:20:50 | Chiapas, Mexico | |||
2022-03-14 | Mexico | Chiapas | 35743 | 2393 | 0 | 16.7569 | -93.1292 | 2022-03-15 04:20:47 | Chiapas, Mexico | |||
2022-02-05 | US | Pennsylvania | Lebanon | 42075 | 35743 | 477 | 0 | 40.36680311 | -76.45651841 | 2022-02-06 04:21:00 | Lebanon, Pennsylvania, US | |
2021-11-11 | Colombia | Casanare | 35743 | 933 | 0 | 5.7589 | -71.5724 | 2021-11-12 04:22:01 | Casanare, Colombia | |||
2021-08-19 | France | French Polynesia | 35743 | 245 | 0 | -17.6797 | -149.4068 | 2021-08-20 04:21:33 | French Polynesia, France | |||
2020-10-03 | Italy | Emilia-Romagna | 35743 | 4485 | 26468 | 4790 | 44.49436681 | 11.3417208 | 2020-10-04 04:23:44 | Emilia-Romagna, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;