johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where deaths = 4516 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2556826 | 2556826 | 2022-11-29 | Russia | Omsk Oblast | 230219 | 4516 | 0 | 56.0935263 | 73.5099936 | 2022-11-30 04:21:07 | Omsk Oblast, Russia | |||
2888079 | 2888079 | 2022-08-12 | Australia | New South Wales | 3329963 | 4516 | 0 | -33.8688 | 151.2093 | 2022-08-13 04:20:52 | New South Wales, Australia | |||
3873835 | 3873835 | 2022-07-31 | US | New York | Suffolk | 36103 | 489917 | 4516 | 0 | 40.88320119 | -72.8012172 | 2022-08-01 04:21:03 | Suffolk, New York, US | |
676589 | 676589 | 2022-07-30 | US | New York | Suffolk | 36103 | 489427 | 4516 | 0 | 40.88320119 | -72.8012172 | 2022-07-31 04:21:02 | Suffolk, New York, US | |
1785788 | 1785788 | 2022-07-29 | US | New York | Suffolk | 36103 | 488853 | 4516 | 0 | 40.88320119 | -72.8012172 | 2022-07-30 04:20:42 | Suffolk, New York, US | |
3133577 | 3133577 | 2022-06-03 | Japan | Tokyo | 1547169 | 4516 | 0 | 35.711343 | 139.446921 | 2022-06-04 04:20:58 | Tokyo, Japan | |||
3323905 | 3323905 | 2022-04-07 | United Kingdom | Northern Ireland | 694425 | 4516 | 0 | 54.7877 | -6.4923 | 2022-04-08 04:20:48 | Northern Ireland, United Kingdom | |||
1258758 | 1258758 | 2021-12-18 | Italy | Liguria | 133551 | 4516 | 0 | 44.41149315 | 8.9326992 | 2021-12-19 04:21:11 | Liguria, Italy | |||
2402452 | 2402452 | 2021-12-17 | Ukraine | Kiev Oblast | 181631 | 4516 | 0 | 50.053000000000004 | 30.7667 | 2021-12-18 02:22:20 | Kiev Oblast, Ukraine | |||
494865 | 494865 | 2021-10-14 | US | Texas | Tarrant | 48439 | 361752 | 4516 | 0 | 32.77143818 | -97.29101614 | 2021-10-15 04:21:26 | Tarrant, Texas, US | |
3011616 | 3011616 | 2021-09-22 | Slovenia | 286267 | 4516 | 0 | 46.1512 | 14.9955 | 2021-09-23 04:21:43 | Slovenia | ||||
3331626 | 3331626 | 2021-07-21 | Mexico | Queretaro | 72001 | 4516 | 0 | 67485 | 20.5888 | -100.3899 | 2021-07-22 04:21:19 | Queretaro, Mexico | ||
2695934 | 2695934 | 2021-07-06 | US | New York | New York | 36061 | 139022 | 4516 | 0 | 40.76727260000001 | -73.97152637 | 2021-07-07 04:21:20 | New York, New York, US | |
2318963 | 2318963 | 2021-06-04 | Uruguay | 308490 | 4516 | 267776 | 36198 | -32.5228 | -55.7658 | 2021-06-05 04:23:03 | Uruguay | |||
3003451 | 3003451 | 2021-04-06 | Pakistan | Sindh | 267238 | 4516 | 257013 | 5709 | 26.009446 | 68.77680699999999 | 2021-04-07 04:20:53 | Sindh, Pakistan | ||
471407 | 471407 | 2021-02-19 | Italy | Toscana | 146900 | 4516 | 129174 | 13210 | 43.76923077 | 11.25588885 | 2021-02-20 05:22:51 | Toscana, Italy | ||
2482056 | 2482056 | 2021-01-28 | Mexico | Hidalgo | 31289 | 4516 | 0 | 26773 | 20.0911 | -98.7624 | 2021-01-29 05:22:23 | Hidalgo, Mexico | ||
2131648 | 2131648 | 2020-12-17 | United Kingdom | Wales | 114566 | 4516 | 0 | 111593 | 52.1307 | -3.7837 | 2020-12-18 05:28:18 | Wales, United Kingdom | ||
2935166 | 2935166 | 2020-11-28 | Hungary | 204708 | 4516 | 54021 | 146171 | 47.1625 | 19.5033 | 2020-11-29 05:25:55 | Hungary | |||
209974 | 209974 | 2020-10-29 | Brazil | Amazonas | 160596 | 4516 | 136063 | 20017 | -3.4168 | -65.8561 | 2020-10-30 04:24:49 | Amazonas, Brazil | ||
427058 | 427058 | 2020-09-07 | Bangladesh | 327359 | 4516 | 224573 | 98270 | 23.685 | 90.3563 | 2020-09-08 04:28:25 | 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]);