johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 28020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2792245 | 2792245 | 2022-07-10 | US | Texas | Rockwall | 48397 | 28020 | 267 | 0 | 32.89779518 | -96.40771592 | 2022-07-11 04:20:46 | Rockwall, Texas, US | |
495861 | 495861 | 2021-11-06 | Russia | Karachay-Cherkess Republic | 28020 | 792 | 0 | 43.7368326 | 41.7267991 | 2021-11-07 04:21:53 | Karachay-Cherkess Republic, Russia | |||
103254 | 103254 | 2021-08-15 | Guinea | 28020 | 287 | 0 | 9.9456 | -9.6966 | 2021-08-16 04:21:31 | Guinea | ||||
1342633 | 1342633 | 2021-08-11 | US | Alabama | Baldwin | 1003 | 28020 | 338 | 0 | 30.72774991 | -87.72207058 | 2021-08-12 04:21:25 | Baldwin, Alabama, US | |
1219410 | 1219410 | 2021-03-27 | Colombia | Cauca | 28020 | 774 | 26737 | 509 | 2.705 | -76.82600000000002 | 2021-03-28 05:28:10 | Cauca, Colombia | ||
3900471 | 3900471 | 2021-01-09 | US | Arkansas | Pulaski | 5119 | 28020 | 427 | 0 | 27593 | 34.77054088 | -92.31355101 | 2021-01-10 05:22:12 | Pulaski, Arkansas, US |
816550 | 816550 | 2020-09-05 | US | Tennessee | Shelby | 47157 | 28020 | 400 | 0 | 27231 | 35.1864775 | -89.89692423 | 2020-09-06 04:28:33 | Shelby, Tennessee, 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]);