daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where confirmed = 422, country_or_region = "US" and province_or_state = "Montana" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 42 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-08 | US | Montana | McCone | 30055 | 422 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-09 04:21:11 | McCone, Montana, US | |
2022-09-08 | US | Montana | Wheatland | 30107 | 422 | 14 | 0 | 46.46652491 | -109.8464636 | 2022-09-09 04:21:11 | Wheatland, Montana, US | |
2022-09-07 | US | Montana | McCone | 30055 | 422 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-08 04:21:02 | McCone, Montana, US | |
2022-09-07 | US | Montana | Wheatland | 30107 | 422 | 14 | 0 | 46.46652491 | -109.8464636 | 2022-09-08 04:21:02 | Wheatland, Montana, US | |
2022-09-06 | US | Montana | McCone | 30055 | 422 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-07 04:20:59 | McCone, Montana, US | |
2022-09-06 | US | Montana | Wheatland | 30107 | 422 | 14 | 0 | 46.46652491 | -109.8464636 | 2022-09-07 04:20:59 | Wheatland, Montana, US | |
2022-09-05 | US | Montana | McCone | 30055 | 422 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-06 04:21:02 | McCone, Montana, US | |
2022-09-05 | US | Montana | Wheatland | 30107 | 422 | 14 | 0 | 46.46652491 | -109.8464636 | 2022-09-06 04:21:02 | Wheatland, Montana, US | |
2022-09-04 | US | Montana | McCone | 30055 | 422 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-05 04:21:01 | McCone, Montana, US | |
2022-09-04 | US | Montana | Wheatland | 30107 | 422 | 14 | 0 | 46.46652491 | -109.8464636 | 2022-09-05 04:21:01 | Wheatland, Montana, US | |
2022-09-03 | US | Montana | McCone | 30055 | 422 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-04 04:21:22 | McCone, Montana, US | |
2022-09-03 | US | Montana | Wheatland | 30107 | 422 | 14 | 0 | 46.46652491 | -109.8464636 | 2022-09-04 04:21:22 | Wheatland, Montana, US | |
2022-09-02 | US | Montana | McCone | 30055 | 422 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-03 04:21:04 | McCone, Montana, US | |
2022-09-02 | US | Montana | Wheatland | 30107 | 422 | 14 | 0 | 46.46652491 | -109.8464636 | 2022-09-03 04:21:04 | Wheatland, Montana, US | |
2022-06-23 | US | Montana | Liberty | 30051 | 422 | 4 | 0 | 48.56084317 | -111.024307 | 2022-06-24 04:20:58 | Liberty, Montana, US | |
2022-06-22 | US | Montana | Liberty | 30051 | 422 | 4 | 0 | 48.56084317 | -111.024307 | 2022-06-23 04:20:55 | Liberty, Montana, US | |
2022-06-21 | US | Montana | Liberty | 30051 | 422 | 4 | 0 | 48.56084317 | -111.024307 | 2022-06-22 04:20:54 | Liberty, Montana, US | |
2022-06-20 | US | Montana | Liberty | 30051 | 422 | 4 | 0 | 48.56084317 | -111.024307 | 2022-06-21 04:20:56 | Liberty, Montana, US | |
2022-06-19 | US | Montana | Liberty | 30051 | 422 | 4 | 0 | 48.56084317 | -111.024307 | 2022-06-20 04:21:01 | Liberty, Montana, US | |
2022-06-18 | US | Montana | Liberty | 30051 | 422 | 4 | 0 | 48.56084317 | -111.024307 | 2022-06-19 04:20:51 | Liberty, Montana, US | |
2022-06-17 | US | Montana | Liberty | 30051 | 422 | 4 | 0 | 48.56084317 | -111.024307 | 2022-06-18 04:21:10 | Liberty, Montana, US | |
2021-10-04 | US | Montana | Fallon | 30025 | 422 | 4 | 0 | 46.33478338 | -104.41835649999999 | 2021-10-05 04:21:27 | Fallon, Montana, US | |
2021-10-03 | US | Montana | Fallon | 30025 | 422 | 4 | 0 | 46.33478338 | -104.41835649999999 | 2021-10-04 04:21:31 | Fallon, Montana, US | |
2021-10-02 | US | Montana | Fallon | 30025 | 422 | 4 | 0 | 46.33478338 | -104.41835649999999 | 2021-10-03 04:21:24 | Fallon, Montana, US | |
2021-10-01 | US | Montana | Fallon | 30025 | 422 | 4 | 0 | 46.33478338 | -104.41835649999999 | 2021-10-02 04:21:25 | Fallon, Montana, US | |
2021-05-14 | US | Montana | Sheridan | 30091 | 422 | 5 | 0 | 48.72085833 | -104.503829 | 2021-05-15 04:20:58 | Sheridan, Montana, US | |
2021-05-13 | US | Montana | Sheridan | 30091 | 422 | 5 | 0 | 48.72085833 | -104.503829 | 2021-05-14 04:20:41 | Sheridan, Montana, US | |
2021-05-12 | US | Montana | Sheridan | 30091 | 422 | 5 | 0 | 48.72085833 | -104.503829 | 2021-05-13 04:20:51 | Sheridan, Montana, US | |
2021-04-28 | US | Montana | Sheridan | 30091 | 422 | 5 | 0 | 48.72085833 | -104.503829 | 2021-04-29 04:20:55 | Sheridan, Montana, US | |
2021-03-17 | US | Montana | Broadwater | 30007 | 422 | 5 | 0 | 46.33277565 | -111.4955813 | 2021-03-18 05:26:22 | Broadwater, Montana, US | |
2021-03-16 | US | Montana | Broadwater | 30007 | 422 | 5 | 0 | 46.33277565 | -111.4955813 | 2021-03-17 05:25:07 | Broadwater, Montana, US | |
2021-03-15 | US | Montana | Broadwater | 30007 | 422 | 5 | 0 | 46.33277565 | -111.4955813 | 2021-03-16 05:25:13 | Broadwater, Montana, US | |
2021-03-14 | US | Montana | Broadwater | 30007 | 422 | 5 | 0 | 46.33277565 | -111.4955813 | 2021-03-15 05:25:51 | Broadwater, Montana, US | |
2021-02-24 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-25 05:24:57 | Teton, Montana, US |
2021-02-23 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-24 05:29:16 | Teton, Montana, US |
2021-02-22 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-23 05:23:41 | Teton, Montana, US |
2021-02-21 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-22 05:24:21 | Teton, Montana, US |
2021-02-20 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-21 05:24:33 | Teton, Montana, US |
2021-02-19 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-20 05:22:51 | Teton, Montana, US |
2021-01-16 | US | Montana | Chouteau | 30015 | 422 | 5 | 0 | 417 | 47.88084126 | -110.4353362 | 2021-01-17 05:22:17 | Chouteau, Montana, US |
2021-01-15 | US | Montana | Chouteau | 30015 | 422 | 5 | 0 | 417 | 47.88084126 | -110.4353362 | 2021-01-16 05:22:40 | Chouteau, Montana, US |
2020-11-15 | US | Montana | Fergus | 30027 | 422 | 2 | 0 | 420 | 47.26331584 | -109.2245206 | 2020-11-16 05:25:57 | Fergus, Montana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;