johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where confirmed = 22884 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3324326 | 3324326 | 2022-12-16 | Malaysia | W.P. Labuan | 22884 | 157 | 0 | 5.2831 | 115.2308 | 2022-12-17 04:21:04 | W.P. Labuan, Malaysia | |||
200699 | 200699 | 2022-10-19 | US | North Dakota | Ward | 38101 | 22884 | 251 | 0 | 48.22390169 | -101.5436763 | 2022-10-20 04:22:59 | Ward, North Dakota, US | |
375230 | 375230 | 2022-09-13 | US | Texas | Bowie | 48037 | 22884 | 446 | 0 | 33.44626922 | -94.41834132 | 2022-09-14 04:20:44 | Bowie, Texas, US | |
2397832 | 2397832 | 2022-09-12 | US | Texas | Bowie | 48037 | 22884 | 446 | 0 | 33.44626922 | -94.41834132 | 2022-09-13 04:20:57 | Bowie, Texas, US | |
1398032 | 1398032 | 2022-05-06 | Timor-Leste | 22884 | 130 | 0 | -8.874217 | 125.727539 | 2022-05-07 04:21:09 | Timor-Leste | ||||
24671 | 24671 | 2022-03-20 | Saint Lucia | 22884 | 365 | 0 | 13.9094 | -60.9789 | 2022-03-21 04:20:50 | Saint Lucia | ||||
2644279 | 2644279 | 2022-02-14 | US | Ohio | Wayne | 39169 | 22884 | 432 | 0 | 40.82925852 | -81.88844833 | 2022-02-15 04:21:09 | Wayne, Ohio, US | |
3641136 | 3641136 | 2021-11-08 | US | Maryland | Howard | 24027 | 22884 | 279 | 0 | 39.25305293 | -76.93126208 | 2021-11-09 04:21:36 | Howard, Maryland, US | |
633748 | 633748 | 2021-10-13 | Colombia | Caqueta | 22884 | 937 | 0 | 0.8699 | -73.8419 | 2021-10-14 04:21:29 | Caqueta, Colombia | |||
2410954 | 2410954 | 2021-04-19 | Mongolia | 22884 | 50 | 12860 | 11284 | 46.8625 | 103.8467 | 2021-04-20 04:20:41 | Mongolia | |||
2880298 | 2880298 | 2020-11-15 | Mexico | Oaxaca | 22884 | 1823 | 0 | 21061 | 17.0732 | -96.7266 | 2020-11-16 05:25:57 | Oaxaca, Mexico |
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]);