johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where deaths = 5555 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
962881 | 962881 | 2022-09-09 | Italy | Liguria | 564453 | 5555 | 0 | 44.41149315 | 8.9326992 | 2022-09-10 04:21:10 | Liguria, Italy | |||
253283 | 253283 | 2022-09-08 | Italy | Liguria | 564043 | 5555 | 0 | 44.41149315 | 8.9326992 | 2022-09-09 04:21:11 | Liguria, Italy | |||
1771024 | 1771024 | 2022-07-03 | Zimbabwe | 255586 | 5555 | 0 | -19.015438 | 29.154857 | 2022-07-04 04:20:54 | Zimbabwe | ||||
3369010 | 3369010 | 2022-07-02 | Zimbabwe | 255586 | 5555 | 0 | -19.015438 | 29.154857 | 2022-07-03 04:20:59 | Zimbabwe | ||||
597339 | 597339 | 2022-07-01 | Zimbabwe | 255586 | 5555 | 0 | -19.015438 | 29.154857 | 2022-07-02 04:21:16 | Zimbabwe | ||||
3943740 | 3943740 | 2022-06-30 | Zimbabwe | 255586 | 5555 | 0 | -19.015438 | 29.154857 | 2022-07-01 04:21:10 | Zimbabwe | ||||
3320432 | 3320432 | 2022-04-07 | Russia | Bashkortostan Republic | 279585 | 5555 | 0 | 54.8573563 | 57.1439682 | 2022-04-08 04:20:48 | Bashkortostan Republic, Russia | |||
3070215 | 3070215 | 2021-11-23 | Russia | Altai Krai | 100372 | 5555 | 0 | 52.693224300000004 | 82.69314240000001 | 2021-11-24 04:22:14 | Altai Krai, Russia | |||
447466 | 447466 | 2021-11-17 | Mexico | Oaxaca | 82527 | 5555 | 0 | 17.0732 | -96.7266 | 2021-11-18 04:21:33 | Oaxaca, Mexico | |||
3342723 | 3342723 | 2021-11-16 | Mexico | Tabasco | 143180 | 5555 | 0 | 17.8409 | -92.6189 | 2021-11-17 04:21:48 | Tabasco, Mexico | |||
1274861 | 1274861 | 2021-10-03 | US | California | San Bernardino | 6071 | 353025 | 5555 | 0 | 34.84060306 | -116.1774685 | 2021-10-04 04:21:31 | San Bernardino, California, US | |
1117688 | 1117688 | 2021-08-06 | Mexico | San Luis Potosi | 73938 | 5555 | 0 | 22.1565 | -100.9855 | 2021-08-07 04:21:30 | San Luis Potosi, Mexico | |||
1089946 | 1089946 | 2021-03-03 | Croatia | 244205 | 5555 | 235328 | 3322 | 45.1 | 15.2 | 2021-03-04 05:24:24 | Croatia | |||
1759259 | 1759259 | 2021-01-24 | India | Punjab | 171930 | 5555 | 164119 | 2256 | 30.841465000000003 | 75.40879 | 2021-01-25 05:22:16 | Punjab, India | ||
2291164 | 2291164 | 2020-10-12 | Bangladesh | 379738 | 5555 | 294391 | 79792 | 23.685 | 90.3563 | 2020-10-13 04:24:02 | Bangladesh |
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]);