daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where confirmed = 31648 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 7
- Colombia 1
- India 1
- Netherlands 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-22 | US | New York | Oswego | 36075 | 31648 | 210 | 0 | 43.42778894 | -76.14635194 | 2022-09-23 04:23:13 | Oswego, New York, US | |
2022-08-06 | US | Tennessee | Maury | 47119 | 31648 | 358 | 0 | 35.6187413 | -87.07462444 | 2022-08-07 04:20:54 | Maury, Tennessee, US | |
2022-01-24 | US | Mississippi | Rankin | 28121 | 31648 | 422 | 0 | 32.26469147 | -89.94537876 | 2022-01-25 04:21:05 | Rankin, Mississippi, US | |
2021-12-17 | US | Idaho | Kootenai | 16055 | 31648 | 472 | 0 | 47.67282258 | -116.7020872 | 2021-12-18 02:22:20 | Kootenai, Idaho, US | |
2021-12-02 | US | California | San Luis Obispo | 6079 | 31648 | 360 | 0 | 35.38822029 | -120.4039028 | 2021-12-03 04:23:05 | San Luis Obispo, California, US | |
2021-11-08 | US | Louisiana | Ouachita | 22073 | 31648 | 588 | 0 | 32.47645559 | -92.15704172 | 2021-11-09 04:21:36 | Ouachita, Louisiana, US | |
2021-07-24 | Netherlands | Zeeland | 31648 | 250 | 0 | 31333 | 51.47936 | 3.861559 | 2021-07-25 04:22:12 | Zeeland, Netherlands | ||
2021-06-14 | India | Arunachal Pradesh | 31648 | 151 | 28608 | 2889 | 27.768456 | 96.384277 | 2021-06-15 04:22:22 | Arunachal Pradesh, India | ||
2021-05-20 | US | South Dakota | Minnehaha | 46099 | 31648 | 360 | 0 | 43.67441641 | -96.7910885 | 2021-05-21 04:20:43 | Minnehaha, South Dakota, US | |
2020-10-21 | Colombia | Bolivar | 31648 | 821 | 30169 | 658 | 8.6704 | -74.03 | 2020-10-22 04:24:27 | Bolivar, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;