johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where "day" is on date 2020-09-13 and province_or_state = "Wyoming" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2872294 | 2872294 | 2020-09-13 | US | Wyoming | Albany | 56001 | 234 | 0 | 0 | 234 | 41.65498705 | -105.7235415 | 2020-09-14 04:26:00 | Albany, Wyoming, US |
2872295 | 2872295 | 2020-09-13 | US | Wyoming | Big Horn | 56003 | 51 | 1 | 0 | 50 | 44.52405055 | -107.9960365 | 2020-09-14 04:26:00 | Big Horn, Wyoming, US |
2872296 | 2872296 | 2020-09-13 | US | Wyoming | Campbell | 56005 | 222 | 1 | 0 | 221 | 44.24886082 | -105.5474404 | 2020-09-14 04:26:00 | Campbell, Wyoming, US |
2872297 | 2872297 | 2020-09-13 | US | Wyoming | Carbon | 56007 | 194 | 2 | 0 | 192 | 41.69357844 | -106.9326084 | 2020-09-14 04:26:00 | Carbon, Wyoming, US |
2872298 | 2872298 | 2020-09-13 | US | Wyoming | Converse | 56009 | 62 | 0 | 0 | 62 | 42.97272268 | -105.5081848 | 2020-09-14 04:26:00 | Converse, Wyoming, US |
2872299 | 2872299 | 2020-09-13 | US | Wyoming | Crook | 56011 | 23 | 0 | 0 | 23 | 44.58855102 | -104.5697705 | 2020-09-14 04:26:00 | Crook, Wyoming, US |
2872300 | 2872300 | 2020-09-13 | US | Wyoming | Fremont | 56013 | 625 | 14 | 0 | 611 | 43.04183996 | -108.6296893 | 2020-09-14 04:26:00 | Fremont, Wyoming, US |
2872301 | 2872301 | 2020-09-13 | US | Wyoming | Goshen | 56015 | 69 | 1 | 0 | 68 | 42.08798185 | -104.3534743 | 2020-09-14 04:26:00 | Goshen, Wyoming, US |
2872302 | 2872302 | 2020-09-13 | US | Wyoming | Hot Springs | 56017 | 30 | 0 | 0 | 30 | 43.71930657 | -108.4423174 | 2020-09-14 04:26:00 | Hot Springs, Wyoming, US |
2872303 | 2872303 | 2020-09-13 | US | Wyoming | Johnson | 56019 | 29 | 1 | 0 | 28 | 44.04057166 | -106.5845174 | 2020-09-14 04:26:00 | Johnson, Wyoming, US |
2872304 | 2872304 | 2020-09-13 | US | Wyoming | Laramie | 56021 | 624 | 4 | 0 | 620 | 41.3070252 | -104.6887497 | 2020-09-14 04:26:00 | Laramie, Wyoming, US |
2872305 | 2872305 | 2020-09-13 | US | Wyoming | Lincoln | 56023 | 124 | 1 | 0 | 123 | 42.26376367 | -110.6563997 | 2020-09-14 04:26:00 | Lincoln, Wyoming, US |
2872306 | 2872306 | 2020-09-13 | US | Wyoming | Natrona | 56025 | 368 | 2 | 0 | 366 | 42.96180148 | -106.797885 | 2020-09-14 04:26:00 | Natrona, Wyoming, US |
2872307 | 2872307 | 2020-09-13 | US | Wyoming | Niobrara | 56027 | 3 | 0 | 0 | 3 | 43.05607708 | -104.4758896 | 2020-09-14 04:26:00 | Niobrara, Wyoming, US |
2872308 | 2872308 | 2020-09-13 | US | Wyoming | Park | 56029 | 187 | 1 | 0 | 186 | 44.52157546 | -109.5852825 | 2020-09-14 04:26:00 | Park, Wyoming, US |
2872309 | 2872309 | 2020-09-13 | US | Wyoming | Platte | 56031 | 9 | 1 | 0 | 8 | 42.13299116 | -104.966331 | 2020-09-14 04:26:00 | Platte, Wyoming, US |
2872310 | 2872310 | 2020-09-13 | US | Wyoming | Sheridan | 56033 | 203 | 1 | 0 | 202 | 44.79048913 | -106.8862389 | 2020-09-14 04:26:00 | Sheridan, Wyoming, US |
2872311 | 2872311 | 2020-09-13 | US | Wyoming | Sublette | 56035 | 54 | 1 | 0 | 53 | 42.76558279 | -109.9130922 | 2020-09-14 04:26:00 | Sublette, Wyoming, US |
2872312 | 2872312 | 2020-09-13 | US | Wyoming | Sweetwater | 56037 | 318 | 2 | 0 | 316 | 41.65943896 | -108.8827882 | 2020-09-14 04:26:00 | Sweetwater, Wyoming, US |
2872313 | 2872313 | 2020-09-13 | US | Wyoming | Teton | 56039 | 470 | 1 | 0 | 469 | 43.93522482 | -110.5890801 | 2020-09-14 04:26:00 | Teton, Wyoming, US |
2872314 | 2872314 | 2020-09-13 | US | Wyoming | Uinta | 56041 | 311 | 2 | 0 | 309 | 41.2878183 | -110.5475782 | 2020-09-14 04:26:00 | Uinta, Wyoming, US |
2872315 | 2872315 | 2020-09-13 | US | Wyoming | Unassigned | 90056 | 2 | 0 | 0 | 2 | 44.79048913 | -110.6563997 | 2020-09-14 04:26:00 | Unassigned, Wyoming, US |
2872316 | 2872316 | 2020-09-13 | US | Wyoming | Washakie | 56043 | 111 | 6 | 0 | 105 | 43.90451606 | -107.680187 | 2020-09-14 04:26:00 | Washakie, Wyoming, US |
2872317 | 2872317 | 2020-09-13 | US | Wyoming | Weston | 56045 | 23 | 0 | 0 | 23 | 43.83961191 | -104.5674881 | 2020-09-14 04:26:00 | 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]);