johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where active = 6809 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- US · 9 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1617026 | 1617026 | 2021-03-05 | US | Georgia | Dougherty | 13095 | 7092 | 283 | 0 | 6809 | 31.53328528 | -84.21722377 | 2021-03-06 04:23:41 | Dougherty, Georgia, US |
1463152 | 1463152 | 2021-01-31 | US | Virginia | Roanoke City | 51770 | 6928 | 119 | 0 | 6809 | 37.27791025 | -79.96189766 | 2021-02-01 05:22:53 | Roanoke City, Virginia, US |
3157129 | 3157129 | 2021-01-27 | US | Wisconsin | Chippewa | 55017 | 6888 | 79 | 0 | 6809 | 45.06939744 | -91.28068855 | 2021-01-28 05:22:24 | Chippewa, Wisconsin, US |
3309045 | 3309045 | 2021-01-13 | US | Georgia | Newton | 13217 | 6947 | 138 | 0 | 6809 | 33.55514538 | -83.84547140000002 | 2021-01-14 05:22:32 | Newton, Georgia, US |
3190902 | 3190902 | 2020-11-22 | US | Idaho | Bonneville | 16019 | 6865 | 56 | 0 | 6809 | 43.38713372 | -111.6161537 | 2020-11-23 05:25:26 | Bonneville, Idaho, US |
3443055 | 3443055 | 2020-11-11 | US | New York | Onondaga | 36067 | 7021 | 212 | 0 | 6809 | 43.00491923 | -76.19971155 | 2020-11-12 05:25:55 | Onondaga, New York, US |
1731113 | 1731113 | 2020-11-08 | US | Oregon | Washington | 41067 | 6897 | 88 | 0 | 6809 | 45.55972701 | -123.0955257 | 2020-11-09 05:25:45 | Washington, Oregon, US |
376558 | 376558 | 2020-11-06 | US | Alabama | Lee | 1081 | 6874 | 65 | 0 | 6809 | 32.60154883 | -85.35132246 | 2020-11-07 05:24:52 | Lee, Alabama, US |
3651975 | 3651975 | 2020-10-24 | US | Alaska | Anchorage | 2020 | 6851 | 42 | 0 | 6809 | 61.14998174 | -149.14269860000005 | 2020-10-25 04:24:36 | Anchorage, Alaska, 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]);