johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 21365 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 11
- Russia 2
- Pakistan 1
- Papua New Guinea 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2378793 | 2378793 | 2022-09-29 | US | Texas | Walker | 48471 | 21365 | 215 | 0 | 30.73872995 | -95.57440968 | 2022-09-30 04:23:09 | Walker, Texas, US | |
1318746 | 1318746 | 2022-01-26 | US | Arkansas | Unassigned | 90005 | 21365 | 0 | 0 | 36.38177105 | 0.0 | 2022-01-27 04:21:19 | Unassigned, Arkansas, US | |
1143898 | 1143898 | 2022-01-23 | US | Tennessee | Putnam | 47141 | 21365 | 271 | 0 | 36.14005459 | -85.50646123 | 2022-01-24 04:21:12 | Putnam, Tennessee, US | |
1257300 | 1257300 | 2021-12-20 | US | Ohio | Wood | 39173 | 21365 | 291 | 0 | 41.36224827 | -83.62285108 | 2021-12-21 03:21:27 | Wood, Ohio, US | |
3832638 | 3832638 | 2021-10-05 | Papua New Guinea | 21365 | 234 | 0 | -6.314993 | 143.95555 | 2021-10-06 04:21:33 | Papua New Guinea | ||||
642169 | 642169 | 2021-09-07 | Russia | North Ossetia - Alania Republic | 21365 | 446 | 0 | 42.79336110000001 | 44.6324493 | 2021-09-08 04:21:31 | North Ossetia - Alania Republic, Russia | |||
486068 | 486068 | 2021-07-19 | US | Ohio | Lake | 39085 | 21365 | 397 | 0 | 41.69710807 | -81.23676539 | 2021-07-20 04:21:48 | Lake, Ohio, US | |
3662259 | 3662259 | 2021-07-11 | US | Pennsylvania | Erie | 42049 | 21365 | 419 | 0 | 41.99253829 | -80.03301954 | 2021-07-12 04:21:34 | Erie, Pennsylvania, US | |
628543 | 628543 | 2021-07-10 | US | Pennsylvania | Erie | 42049 | 21365 | 419 | 0 | 41.99253829 | -80.03301954 | 2021-07-11 04:21:43 | Erie, Pennsylvania, US | |
1564315 | 1564315 | 2021-06-14 | Russia | Mordovia Republic | 21365 | 302 | 19049 | 2014 | 54.4419829 | 44.4661144 | 2021-06-15 04:22:22 | Mordovia Republic, Russia | ||
3395683 | 3395683 | 2021-04-28 | US | North Carolina | Cabarrus | 37025 | 21365 | 251 | 0 | 35.3877799 | -80.55267168 | 2021-04-29 04:20:55 | Cabarrus, North Carolina, US | |
1568247 | 1568247 | 2021-04-22 | Pakistan | Balochistan | 21365 | 227 | 20035 | 1103 | 28.328492 | 65.898403 | 2021-04-23 04:20:52 | Balochistan, Pakistan | ||
2248191 | 2248191 | 2021-04-07 | US | Georgia | Forsyth | 13117 | 21365 | 176 | 0 | 34.22604035 | -84.12315129999998 | 2021-04-08 04:21:13 | Forsyth, Georgia, US | |
1206600 | 1206600 | 2021-03-22 | US | South Carolina | Anderson | 45007 | 21365 | 491 | 0 | 34.51828081 | -82.63959517 | 2021-03-23 05:26:18 | Anderson, South Carolina, US | |
3762316 | 3762316 | 2020-12-28 | US | Florida | Volusia | 12127 | 21365 | 430 | 0 | 20935 | 29.05858895 | -81.18263252 | 2020-12-29 05:22:37 | Volusia, Florida, 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]);