johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where deaths = 4669 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
712727 | 712727 | 2022-11-01 | US | New York | Suffolk | 36103 | 525325 | 4669 | 0 | 40.88320119 | -72.8012172 | 2022-11-02 04:22:09 | Suffolk, New York, US | |
419537 | 419537 | 2022-09-18 | Russia | Chuvashia Republic | 96266 | 4669 | 0 | 55.4259922 | 47.0849429 | 2022-09-19 04:21:49 | Chuvashia Republic, Russia | |||
3871587 | 3871587 | 2022-07-31 | Japan | Tokyo | 2166733 | 4669 | 0 | 35.711343 | 139.446921 | 2022-08-01 04:21:03 | Tokyo, Japan | |||
942483 | 942483 | 2022-06-25 | United Kingdom | Northern Ireland | 713294 | 4669 | 0 | 54.7877 | -6.4923 | 2022-06-26 04:21:02 | Northern Ireland, United Kingdom | |||
1503861 | 1503861 | 2022-05-16 | Russia | Ulyanovsk Oblast | 202375 | 4669 | 0 | 54.1463177 | 47.2324921 | 2022-05-17 04:20:59 | Ulyanovsk Oblast, Russia | |||
2052074 | 2052074 | 2022-01-25 | Russia | Bashkortostan Republic | 128050 | 4669 | 0 | 54.8573563 | 57.1439682 | 2022-01-26 04:21:07 | Bashkortostan Republic, Russia | |||
686016 | 686016 | 2021-10-24 | Zimbabwe | 132651 | 4669 | 0 | -19.015438 | 29.154857 | 2021-10-25 04:22:31 | Zimbabwe | ||||
654278 | 654278 | 2021-10-22 | Slovenia | 316138 | 4669 | 0 | 46.1512 | 14.9955 | 2021-10-23 04:21:32 | Slovenia | ||||
3805967 | 3805967 | 2021-09-11 | Lithuania | 308382 | 4669 | 0 | 55.1694 | 23.8813 | 2021-09-12 04:21:13 | Lithuania | ||||
2518481 | 2518481 | 2021-08-18 | Spain | Pais Vasco | 247354 | 4669 | 0 | 42.9896 | -2.6189 | 2021-08-19 04:21:15 | Pais Vasco, Spain | |||
245573 | 245573 | 2021-08-17 | Spain | Pais Vasco | 246533 | 4669 | 0 | 42.9896 | -2.6189 | 2021-08-18 04:21:35 | Pais Vasco, Spain | |||
2899380 | 2899380 | 2021-08-12 | Armenia | 233400 | 4669 | 0 | 40.0691 | 45.0382 | 2021-08-13 04:21:24 | Armenia | ||||
1342396 | 1342396 | 2021-08-11 | Mexico | Yucatan | 56593 | 4669 | 0 | 20.7099 | -89.0943 | 2021-08-12 04:21:25 | Yucatan, Mexico | |||
410427 | 410427 | 2021-07-28 | US | Nevada | Clark | 32003 | 277982 | 4669 | 0 | 36.21458855 | -115.0130241 | 2021-07-29 04:21:33 | Clark, Nevada, US | |
1082040 | 1082040 | 2021-05-14 | Nepal | 439658 | 4669 | 327653 | 107336 | 28.1667 | 84.25 | 2021-05-15 04:20:58 | Nepal | |||
1081678 | 1081678 | 2021-05-14 | Brazil | Sergipe | 215831 | 4669 | 194081 | 17081 | -10.5741 | -37.3857 | 2021-05-15 04:20:58 | Sergipe, Brazil | ||
2481947 | 2481947 | 2021-01-28 | Israel | 628895 | 4669 | 551489 | 72737 | 31.046051 | 34.851612 | 2021-01-29 05:22:23 | Israel | |||
2481708 | 2481708 | 2021-01-28 | Brazil | Maranhao | 206680 | 4669 | 194420 | 7591 | -4.9609 | -45.2744 | 2021-01-29 05:22:23 | Maranhao, Brazil | ||
2123369 | 2123369 | 2020-12-20 | United Kingdom | Wales | 122766 | 4669 | 0 | 119651 | 52.1307 | -3.7837 | 2020-12-21 05:27:58 | Wales, United Kingdom | ||
751769 | 751769 | 2020-08-01 | US | California | Los Angeles | 6037 | 190857 | 4669 | 0 | 186188 | 34.30828379 | -118.2282411 | 2020-08-02 04:34:47 | Los Angeles, California, US |
367826 | 367826 | 2020-07-16 | South Africa | 324221 | 4669 | 165591 | 153961 | -30.5595 | 22.9375 | 2020-07-17 04:34:50 | South Africa | |||
574452 | 574452 | 2020-06-06 | Turkey | 169218 | 4669 | 135322 | 29227 | 38.9637 | 35.2433 | 2020-06-07 03:53:30 | Turkey |
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]);