johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where active = 15485 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2450821 | 2450821 | 2021-05-02 | Jordan | 712901 | 8897 | 688519 | 15485 | 31.24 | 36.51 | 2021-05-03 04:20:39 | Jordan | |||
986612 | 986612 | 2021-04-17 | Venezuela | 181903 | 1888 | 164530 | 15485 | 6.4238 | -66.5897 | 2021-04-18 04:20:41 | Venezuela | |||
2184669 | 2184669 | 2021-02-26 | US | Indiana | Hendricks | 18063 | 15785 | 300 | 0 | 15485 | 39.76719009 | -86.51037283 | 2021-02-27 05:22:28 | Hendricks, Indiana, US |
3543028 | 3543028 | 2021-02-12 | US | Wisconsin | Rock | 55105 | 15647 | 162 | 0 | 15485 | 42.67151616 | -89.07147900000002 | 2021-02-13 05:22:12 | Rock, Wisconsin, US |
153731 | 153731 | 2021-01-08 | Brazil | Rio Grande do Sul | 474917 | 9359 | 450073 | 15485 | -30.0346 | -51.2177 | 2021-01-09 05:22:18 | Rio Grande do Sul, Brazil | ||
678823 | 678823 | 2020-11-23 | US | Arkansas | Pulaski | 5119 | 15743 | 258 | 0 | 15485 | 34.77054088 | -92.31355101 | 2020-11-24 05:27:31 | Pulaski, Arkansas, US |
1135983 | 1135983 | 2020-06-26 | Brazil | Espirito Santo | 41652 | 1507 | 24660 | 15485 | -19.1834 | -40.3089 | 2020-06-27 04:33:35 | Espirito Santo, Brazil | ||
3502898 | 3502898 | 2020-04-25 | Iran | 89328 | 5650 | 68193 | 15485 | 32.427908 | 53.68804599999999 | 2020-04-26 02:30:31 | Iran |
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]);