johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where deaths = 11299 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2506025 | 2506025 | 2022-11-10 | Italy | Campania | 2299733 | 11299 | 0 | 40.83956555 | 14.25084984 | 2022-11-11 04:21:22 | Campania, Italy | |||
2430900 | 2430900 | 2022-11-09 | Italy | Campania | 2299733 | 11299 | 0 | 40.83956555 | 14.25084984 | 2022-11-10 04:21:16 | Campania, Italy | |||
479556 | 479556 | 2022-11-08 | Italy | Campania | 2299733 | 11299 | 0 | 40.83956555 | 14.25084984 | 2022-11-09 04:21:22 | Campania, Italy | |||
2438706 | 2438706 | 2022-11-07 | Italy | Campania | 2299733 | 11299 | 0 | 40.83956555 | 14.25084984 | 2022-11-08 04:21:21 | Campania, Italy | |||
1049804 | 1049804 | 2022-11-06 | Italy | Campania | 2299733 | 11299 | 0 | 40.83956555 | 14.25084984 | 2022-11-07 04:21:26 | Campania, Italy | |||
617828 | 617828 | 2022-11-05 | Italy | Campania | 2299733 | 11299 | 0 | 40.83956555 | 14.25084984 | 2022-11-06 04:21:24 | Campania, Italy | |||
1022332 | 1022332 | 2022-11-04 | Italy | Campania | 2299733 | 11299 | 0 | 40.83956555 | 14.25084984 | 2022-11-05 04:21:52 | Campania, Italy | |||
3592995 | 3592995 | 2022-05-23 | Italy | Lazio | 1558322 | 11299 | 0 | 41.89277044 | 12.48366722 | 2022-05-24 04:20:57 | Lazio, Italy | |||
2845142 | 2845142 | 2021-11-10 | Spain | Andalusia | 811199 | 11299 | 0 | 37.5443 | -4.7278 | 2021-11-11 04:21:45 | Andalusia, Spain | |||
1913045 | 1913045 | 2021-05-20 | Colombia | Antioquia | 511880 | 11299 | 484594 | 15987 | 7.1986 | -75.3412 | 2021-05-21 04:20:43 | Antioquia, Colombia | ||
3393393 | 3393393 | 2021-04-28 | Italy | Veneto | 410176 | 11299 | 376358 | 22519 | 45.43490485 | 12.33845213 | 2021-04-29 04:20:55 | Veneto, Italy | ||
376148 | 376148 | 2020-11-06 | India | Tamil Nadu | 739147 | 11299 | 708846 | 19002 | 11.006091 | 78.400624 | 2020-11-07 05:24:52 | Tamil Nadu, India |
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]);