johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where "day" is on date 2021-04-12 and province_or_state = "Wyoming" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40021 | 40021 | 2021-04-12 | US | Wyoming | Albany | 56001 | 4079 | 11 | 0 | 41.65498705 | -105.7235415 | 2021-04-13 04:20:37 | Albany, Wyoming, US | |
40022 | 40022 | 2021-04-12 | US | Wyoming | Big Horn | 56003 | 1117 | 32 | 0 | 44.52405055 | -107.9960365 | 2021-04-13 04:20:37 | Big Horn, Wyoming, US | |
40023 | 40023 | 2021-04-12 | US | Wyoming | Campbell | 56005 | 4776 | 60 | 0 | 44.24886082 | -105.5474404 | 2021-04-13 04:20:37 | Campbell, Wyoming, US | |
40024 | 40024 | 2021-04-12 | US | Wyoming | Carbon | 56007 | 1529 | 23 | 0 | 41.69357844 | -106.9326084 | 2021-04-13 04:20:37 | Carbon, Wyoming, US | |
40025 | 40025 | 2021-04-12 | US | Wyoming | Converse | 56009 | 986 | 17 | 0 | 42.97272268 | -105.5081848 | 2021-04-13 04:20:37 | Converse, Wyoming, US | |
40026 | 40026 | 2021-04-12 | US | Wyoming | Crook | 56011 | 425 | 12 | 0 | 44.58855102 | -104.5697705 | 2021-04-13 04:20:37 | Crook, Wyoming, US | |
40027 | 40027 | 2021-04-12 | US | Wyoming | Fremont | 56013 | 5109 | 82 | 0 | 43.04183996 | -108.6296893 | 2021-04-13 04:20:37 | Fremont, Wyoming, US | |
40028 | 40028 | 2021-04-12 | US | Wyoming | Goshen | 56015 | 1175 | 23 | 0 | 42.08798185 | -104.3534743 | 2021-04-13 04:20:37 | Goshen, Wyoming, US | |
40029 | 40029 | 2021-04-12 | US | Wyoming | Hot Springs | 56017 | 362 | 3 | 0 | 43.71930657 | -108.4423174 | 2021-04-13 04:20:37 | Hot Springs, Wyoming, US | |
40030 | 40030 | 2021-04-12 | US | Wyoming | Johnson | 56019 | 715 | 10 | 0 | 44.04057166 | -106.5845174 | 2021-04-13 04:20:37 | Johnson, Wyoming, US | |
40031 | 40031 | 2021-04-12 | US | Wyoming | Laramie | 56021 | 8776 | 111 | 0 | 41.30702520000001 | -104.6887497 | 2021-04-13 04:20:37 | Laramie, Wyoming, US | |
40032 | 40032 | 2021-04-12 | US | Wyoming | Lincoln | 56023 | 1383 | 12 | 0 | 42.26376367 | -110.6563997 | 2021-04-13 04:20:37 | Lincoln, Wyoming, US | |
40033 | 40033 | 2021-04-12 | US | Wyoming | Natrona | 56025 | 7855 | 135 | 0 | 42.96180148 | -106.797885 | 2021-04-13 04:20:37 | Natrona, Wyoming, US | |
40034 | 40034 | 2021-04-12 | US | Wyoming | Niobrara | 56027 | 150 | 2 | 0 | 43.05607708 | -104.4758896 | 2021-04-13 04:20:37 | Niobrara, Wyoming, US | |
40035 | 40035 | 2021-04-12 | US | Wyoming | Park | 56029 | 2655 | 30 | 0 | 44.52157546 | -109.5852825 | 2021-04-13 04:20:37 | Park, Wyoming, US | |
40036 | 40036 | 2021-04-12 | US | Wyoming | Platte | 56031 | 612 | 11 | 0 | 42.13299116 | -104.966331 | 2021-04-13 04:20:37 | Platte, Wyoming, US | |
40037 | 40037 | 2021-04-12 | US | Wyoming | Sheridan | 56033 | 3090 | 31 | 0 | 44.79048913 | -106.8862389 | 2021-04-13 04:20:37 | Sheridan, Wyoming, US | |
40038 | 40038 | 2021-04-12 | US | Wyoming | Sublette | 56035 | 742 | 7 | 0 | 42.76558279 | -109.9130922 | 2021-04-13 04:20:37 | Sublette, Wyoming, US | |
40039 | 40039 | 2021-04-12 | US | Wyoming | Sweetwater | 56037 | 4104 | 37 | 0 | 41.65943896 | -108.8827882 | 2021-04-13 04:20:37 | Sweetwater, Wyoming, US | |
40040 | 40040 | 2021-04-12 | US | Wyoming | Teton | 56039 | 3665 | 9 | 0 | 43.93522482 | -110.5890801 | 2021-04-13 04:20:37 | Teton, Wyoming, US | |
40041 | 40041 | 2021-04-12 | US | Wyoming | Uinta | 56041 | 2145 | 12 | 0 | 41.2878183 | -110.54757820000002 | 2021-04-13 04:20:37 | Uinta, Wyoming, US | |
40042 | 40042 | 2021-04-12 | US | Wyoming | Unassigned | 90056 | 0 | 0 | 0 | 44.79048913 | -110.6563997 | 2021-04-13 04:20:37 | Unassigned, Wyoming, US | |
40043 | 40043 | 2021-04-12 | US | Wyoming | Washakie | 56043 | 897 | 26 | 0 | 43.90451606 | -107.68018700000002 | 2021-04-13 04:20:37 | Washakie, Wyoming, US | |
40044 | 40044 | 2021-04-12 | US | Wyoming | Weston | 56045 | 641 | 5 | 0 | 43.83961191 | -104.5674881 | 2021-04-13 04:20:37 | 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]);