johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where confirmed = 20713 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2930226 | 2930226 | 2022-11-11 | US | Tennessee | Tipton | 47167 | 20713 | 251 | 0 | 35.501942 | -89.73694895 | 2022-11-12 04:20:41 | Tipton, Tennessee, US | |
3077320 | 3077320 | 2022-02-09 | US | Utah | Tooele | 49045 | 20713 | 89 | 0 | 40.44862644 | -113.12957150000001 | 2022-02-10 04:21:14 | Tooele, Utah, US | |
1670899 | 1670899 | 2021-12-29 | US | Ohio | Allen | 39003 | 20713 | 394 | 0 | 40.77285242 | -84.10802343 | 2021-12-30 04:21:25 | Allen, Ohio, US | |
637121 | 637121 | 2021-10-13 | US | Texas | Potter | 48375 | 20713 | 541 | 0 | 35.40133773 | -101.893964 | 2021-10-14 04:21:29 | Potter, Texas, US | |
68640 | 68640 | 2021-09-01 | US | Maryland | Howard | 24027 | 20713 | 265 | 0 | 39.25305293 | -76.93126208 | 2021-09-02 04:21:15 | Howard, Maryland, US | |
298365 | 298365 | 2021-07-15 | US | North Carolina | Pitt | 37147 | 20713 | 96 | 0 | 35.59535426 | -77.37353178 | 2021-07-16 04:21:22 | Pitt, North Carolina, US | |
2071618 | 2071618 | 2021-07-02 | Australia | Victoria | 20713 | 820 | 19868 | 25 | -37.8136 | 144.9631 | 2021-07-03 04:21:37 | Victoria, Australia | ||
3358877 | 3358877 | 2021-06-21 | Russia | Karachay-Cherkess Republic | 20713 | 165 | 20308 | 240 | 43.7368326 | 41.7267991 | 2021-06-22 04:21:34 | Karachay-Cherkess Republic, Russia | ||
2549203 | 2549203 | 2021-04-15 | Syria | 20713 | 1414 | 14469 | 4830 | 34.802075 | 38.99681500000001 | 2021-04-16 04:20:46 | Syria | |||
2429286 | 2429286 | 2021-01-23 | US | North Dakota | Cass | 38017 | 20713 | 186 | 0 | 20602 | 46.93201724 | -97.2444719 | 2021-01-24 05:22:35 | Cass, North Dakota, US |
202443 | 202443 | 2020-12-25 | Russia | Belgorod Oblast | 20713 | 229 | 18979 | 1505 | 50.7080119 | 37.5837615 | 2020-12-26 05:22:28 | Belgorod Oblast, Russia | ||
2663928 | 2663928 | 2020-09-04 | US | New Jersey | Essex | 34013 | 20713 | 2119 | 0 | 18594 | 40.78681335 | -74.24657979 | 2020-09-05 04:28:19 | Essex, New Jersey, 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]);