johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where "day" is on date 2020-06-01 and province_or_state = "Wyoming" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
802144 | 802144 | 2020-06-01 | US | Wyoming | Albany | 56001 | 25 | 0 | 0 | 25 | 41.65498705 | -105.7235415 | 2020-06-02 02:33:08 | Albany, Wyoming, US |
802313 | 802313 | 2020-06-01 | US | Wyoming | Big Horn | 56003 | 6 | 0 | 0 | 6 | 44.52405055 | -107.9960365 | 2020-06-02 02:33:08 | Big Horn, Wyoming, US |
802472 | 802472 | 2020-06-01 | US | Wyoming | Campbell | 56005 | 31 | 0 | 0 | 31 | 44.24886082 | -105.5474404 | 2020-06-02 02:33:08 | Campbell, Wyoming, US |
802481 | 802481 | 2020-06-01 | US | Wyoming | Carbon | 56007 | 16 | 0 | 0 | 16 | 41.69357844 | -106.9326084 | 2020-06-02 02:33:08 | Carbon, Wyoming, US |
802715 | 802715 | 2020-06-01 | US | Wyoming | Converse | 56009 | 24 | 0 | 0 | 24 | 42.97272268 | -105.5081848 | 2020-06-02 02:33:08 | Converse, Wyoming, US |
802762 | 802762 | 2020-06-01 | US | Wyoming | Crook | 56011 | 5 | 0 | 0 | 5 | 44.58855102 | -104.5697705 | 2020-06-02 02:33:08 | Crook, Wyoming, US |
803051 | 803051 | 2020-06-01 | US | Wyoming | Fremont | 56013 | 282 | 0 | 0 | 282 | 43.04183996 | -108.6296893 | 2020-06-02 02:33:08 | Fremont, Wyoming, US |
803122 | 803122 | 2020-06-01 | US | Wyoming | Goshen | 56015 | 5 | 0 | 0 | 5 | 42.08798185 | -104.3534743 | 2020-06-02 02:33:08 | Goshen, Wyoming, US |
803339 | 803339 | 2020-06-01 | US | Wyoming | Hot Springs | 56017 | 12 | 0 | 0 | 12 | 43.71930657 | -108.4423174 | 2020-06-02 02:33:08 | Hot Springs, Wyoming, US |
803485 | 803485 | 2020-06-01 | US | Wyoming | Johnson | 56019 | 18 | 1 | 0 | 17 | 44.04057166 | -106.5845174 | 2020-06-02 02:33:08 | Johnson, Wyoming, US |
803611 | 803611 | 2020-06-01 | US | Wyoming | Laramie | 56021 | 188 | 0 | 0 | 188 | 41.30702520000001 | -104.6887497 | 2020-06-02 02:33:08 | Laramie, Wyoming, US |
803704 | 803704 | 2020-06-01 | US | Wyoming | Lincoln | 56023 | 15 | 0 | 0 | 15 | 42.26376367 | -110.6563997 | 2020-06-02 02:33:08 | Lincoln, Wyoming, US |
804049 | 804049 | 2020-06-01 | US | Wyoming | Natrona | 56025 | 79 | 0 | 0 | 79 | 42.96180148 | -106.797885 | 2020-06-02 02:33:08 | Natrona, Wyoming, US |
804084 | 804084 | 2020-06-01 | US | Wyoming | Niobrara | 56027 | 2 | 0 | 0 | 2 | 43.05607708 | -104.4758896 | 2020-06-02 02:33:08 | Niobrara, Wyoming, US |
804203 | 804203 | 2020-06-01 | US | Wyoming | Park | 56029 | 2 | 0 | 0 | 2 | 44.52157546 | -109.5852825 | 2020-06-02 02:33:08 | Park, Wyoming, US |
804287 | 804287 | 2020-06-01 | US | Wyoming | Platte | 56031 | 1 | 0 | 0 | 1 | 42.13299116 | -104.966331 | 2020-06-02 02:33:08 | Platte, Wyoming, US |
804576 | 804576 | 2020-06-01 | US | Wyoming | Sheridan | 56033 | 16 | 0 | 0 | 16 | 44.79048913 | -106.8862389 | 2020-06-02 02:33:08 | Sheridan, Wyoming, US |
804684 | 804684 | 2020-06-01 | US | Wyoming | Sublette | 56035 | 3 | 0 | 0 | 3 | 42.76558279 | -109.9130922 | 2020-06-02 02:33:08 | Sublette, Wyoming, US |
804715 | 804715 | 2020-06-01 | US | Wyoming | Sweetwater | 56037 | 30 | 0 | 0 | 30 | 41.65943896 | -108.8827882 | 2020-06-02 02:33:08 | Sweetwater, Wyoming, US |
804749 | 804749 | 2020-06-01 | US | Wyoming | Teton | 56039 | 100 | 0 | 0 | 100 | 43.93522482 | -110.5890801 | 2020-06-02 02:33:08 | Teton, Wyoming, US |
804810 | 804810 | 2020-06-01 | US | Wyoming | Uinta | 56041 | 12 | 0 | 0 | 12 | 41.2878183 | -110.54757820000002 | 2020-06-02 02:33:08 | Uinta, Wyoming, US |
804862 | 804862 | 2020-06-01 | US | Wyoming | Unassigned | 90056 | 0 | 16 | 0 | 0 | 44.79048913 | -110.6563997 | 2020-06-02 02:33:08 | Unassigned, Wyoming, US |
804957 | 804957 | 2020-06-01 | US | Wyoming | Washakie | 56043 | 37 | 0 | 0 | 37 | 43.90451606 | -107.68018700000002 | 2020-06-02 02:33:08 | Washakie, Wyoming, US |
805031 | 805031 | 2020-06-01 | US | Wyoming | Weston | 56045 | 1 | 0 | 0 | 1 | 43.83961191 | -104.5674881 | 2020-06-02 02:33:08 | Weston, Wyoming, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);