johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23 rows where "day" is on date 2020-03-27 and province_or_state = "Wyoming" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
805823 | 805823 | 2020-03-27 | US | Wyoming | Albany | 56001 | 1 | 0 | 0 | 1 | 41.65498705 | -105.72354150000001 | 2020-03-27 22:14:55 | Albany, Wyoming, US |
806000 | 806000 | 2020-03-27 | US | Wyoming | Big Horn | 56003 | 0 | 0 | 0 | 0 | 44.52405055 | -107.9960365 | 2020-03-27 22:14:55 | Big Horn, Wyoming, US |
806172 | 806172 | 2020-03-27 | US | Wyoming | Campbell | 56005 | 1 | 0 | 0 | 1 | 44.24886082 | -105.54744040000001 | 2020-03-27 22:14:55 | Campbell, Wyoming, US |
806182 | 806182 | 2020-03-27 | US | Wyoming | Carbon | 56007 | 3 | 0 | 0 | 3 | 41.69357844 | -106.9326084 | 2020-03-27 22:14:55 | Carbon, Wyoming, US |
806420 | 806420 | 2020-03-27 | US | Wyoming | Converse | 56009 | 0 | 0 | 0 | 0 | 42.97272268 | -105.5081848 | 2020-03-27 22:14:55 | Converse, Wyoming, US |
806469 | 806469 | 2020-03-27 | US | Wyoming | Crook | 56011 | 0 | 0 | 0 | 0 | 44.58855102 | -104.56977049999999 | 2020-03-27 22:14:55 | Crook, Wyoming, US |
806784 | 806784 | 2020-03-27 | US | Wyoming | Fremont | 56013 | 17 | 0 | 0 | 17 | 43.04183996 | -108.6296893 | 2020-03-27 22:14:55 | Fremont, Wyoming, US |
806859 | 806859 | 2020-03-27 | US | Wyoming | Goshen | 56015 | 1 | 0 | 0 | 1 | 42.08798185 | -104.3534743 | 2020-03-27 22:14:55 | Goshen, Wyoming, US |
807091 | 807091 | 2020-03-27 | US | Wyoming | Hot Springs | 56017 | 0 | 0 | 0 | 0 | 43.71930657 | -108.44231740000001 | 2020-03-27 22:14:55 | Hot Springs, Wyoming, US |
807243 | 807243 | 2020-03-27 | US | Wyoming | Johnson | 56019 | 4 | 0 | 0 | 4 | 44.04057166 | -106.58451740000001 | 2020-03-27 22:14:55 | Johnson, Wyoming, US |
807387 | 807387 | 2020-03-27 | US | Wyoming | Laramie | 56021 | 17 | 0 | 0 | 17 | 41.30702520000001 | -104.6887497 | 2020-03-27 22:14:55 | Laramie, Wyoming, US |
807481 | 807481 | 2020-03-27 | US | Wyoming | Lincoln | 56023 | 0 | 0 | 0 | 0 | 42.26376367 | -110.6563997 | 2020-03-27 22:14:55 | Lincoln, Wyoming, US |
807842 | 807842 | 2020-03-27 | US | Wyoming | Natrona | 56025 | 8 | 0 | 0 | 8 | 42.96180148 | -106.79788500000001 | 2020-03-27 22:14:55 | Natrona, Wyoming, US |
807877 | 807877 | 2020-03-27 | US | Wyoming | Niobrara | 56027 | 0 | 0 | 0 | 0 | 43.05607708 | -104.47588959999999 | 2020-03-27 22:14:55 | Niobrara, Wyoming, US |
807995 | 807995 | 2020-03-27 | US | Wyoming | Park | 56029 | 1 | 0 | 0 | 1 | 44.52157546 | -109.58528249999999 | 2020-03-27 22:14:55 | Park, Wyoming, US |
808086 | 808086 | 2020-03-27 | US | Wyoming | Platte | 56031 | 0 | 0 | 0 | 0 | 42.13299116 | -104.96633100000001 | 2020-03-27 22:14:55 | Platte, Wyoming, US |
808401 | 808401 | 2020-03-27 | US | Wyoming | Sheridan | 56033 | 5 | 0 | 0 | 5 | 44.79048913 | -106.8862389 | 2020-03-27 22:14:55 | Sheridan, Wyoming, US |
808513 | 808513 | 2020-03-27 | US | Wyoming | Sublette | 56035 | 0 | 0 | 0 | 0 | 42.76558279 | -109.91309220000001 | 2020-03-27 22:14:55 | Sublette, Wyoming, US |
808546 | 808546 | 2020-03-27 | US | Wyoming | Sweetwater | 56037 | 1 | 0 | 0 | 1 | 41.65943896 | -108.8827882 | 2020-03-27 22:14:55 | Sweetwater, Wyoming, US |
808582 | 808582 | 2020-03-27 | US | Wyoming | Teton | 56039 | 10 | 0 | 0 | 10 | 43.93522482 | -110.5890801 | 2020-03-27 22:14:55 | Teton, Wyoming, US |
808646 | 808646 | 2020-03-27 | US | Wyoming | Uinta | 56041 | 0 | 0 | 0 | 0 | 41.2878183 | -110.54757820000002 | 2020-03-27 22:14:55 | Uinta, Wyoming, US |
808773 | 808773 | 2020-03-27 | US | Wyoming | Washakie | 56043 | 1 | 0 | 0 | 1 | 43.90451606 | -107.68018700000002 | 2020-03-27 22:14:55 | Washakie, Wyoming, US |
808851 | 808851 | 2020-03-27 | US | Wyoming | Weston | 56045 | 0 | 0 | 0 | 0 | 43.83961191 | -104.56748809999999 | 2020-03-27 22:14:55 | 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]);