johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where active = 7990 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2641351 | 2641351 | 2021-02-11 | Ukraine | Mykolaiv Oblast | 39931 | 727 | 31214 | 7990 | 46.975 | 31.9946 | 2021-02-12 05:23:29 | Mykolaiv Oblast, Ukraine | ||
2482813 | 2482813 | 2021-01-28 | US | Georgia | Newton | 13217 | 8150 | 160 | 0 | 7990 | 33.55514538 | -83.84547140000002 | 2021-01-29 05:22:23 | Newton, Georgia, US |
156480 | 156480 | 2021-01-08 | US | Ohio | Richland | 39139 | 8148 | 158 | 0 | 7990 | 40.77180308 | -82.53799609999999 | 2021-01-09 05:22:18 | Richland, Ohio, US |
847906 | 847906 | 2020-12-12 | US | North Carolina | New Hanover | 37129 | 8056 | 66 | 0 | 7990 | 34.25758282 | -77.87075626 | 2020-12-13 05:27:20 | New Hanover, North Carolina, US |
927227 | 927227 | 2020-11-26 | US | Wisconsin | La Crosse | 55063 | 8024 | 34 | 0 | 7990 | 43.90632465 | -91.11451093 | 2020-11-27 05:26:53 | La Crosse, Wisconsin, US |
2703662 | 2703662 | 2020-11-20 | US | New Jersey | Atlantic | 34001 | 8266 | 276 | 0 | 7990 | 39.47538693 | -74.65848483 | 2020-11-21 05:25:51 | Atlantic, New Jersey, US |
2849506 | 2849506 | 2020-09-18 | US | Florida | Brevard | 12009 | 8264 | 274 | 0 | 7990 | 28.29409504 | -80.73091022 | 2020-09-19 04:22:00 | Brevard, Florida, US |
207346 | 207346 | 2020-08-19 | US | Indiana | Lake | 18089 | 8298 | 308 | 0 | 7990 | 41.41874274 | -87.38277575 | 2020-08-20 04:27:43 | Lake, Indiana, US |
120805 | 120805 | 2020-07-19 | US | Virginia | Prince William | 51153 | 8152 | 162 | 0 | 7990 | 38.70916224 | -77.48713689 | 2020-07-20 05:34:40 | Prince William, Virginia, US |
364296 | 364296 | 2020-07-16 | US | Massachusetts | Bristol | 25005 | 8593 | 603 | 0 | 7990 | 41.79228404 | -71.10872211 | 2020-07-17 04:34:50 | Bristol, Massachusetts, 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]);