johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where deaths = 4486 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2669867 | 2669867 | 2022-04-15 | Malaysia | Johor | 379756 | 4486 | 0 | 1.4854 | 103.7618 | 2022-04-16 04:20:48 | Johor, Malaysia | |||
3979 | 3979 | 2021-12-02 | Ukraine | Zaporizhia Oblast | 172575 | 4486 | 0 | 47.8388 | 35.1396 | 2021-12-03 04:23:05 | Zaporizhia Oblast, Ukraine | |||
2809029 | 2809029 | 2021-09-16 | Slovenia | 280544 | 4486 | 0 | 46.1512 | 14.9955 | 2021-09-17 04:21:46 | Slovenia | ||||
3218404 | 3218404 | 2021-07-26 | Mexico | Yucatan | 53045 | 4486 | 0 | 48559 | 20.7099 | -89.0943 | 2021-07-27 04:21:18 | Yucatan, Mexico | ||
2450719 | 2450719 | 2021-05-02 | India | Haryana | 514888 | 4486 | 405132 | 105270 | 29.20004 | 76.332824 | 2021-05-03 04:20:39 | Haryana, India | ||
1980762 | 1980762 | 2021-03-25 | Pakistan | Sindh | 264062 | 4486 | 255399 | 4177 | 26.009446 | 68.77680699999999 | 2021-03-26 05:26:55 | Sindh, Pakistan | ||
702963 | 702963 | 2021-03-16 | US | California | Orange | 6059 | 264033 | 4486 | 0 | 33.70147516 | -117.76459979999998 | 2021-03-17 05:25:07 | Orange, California, US | |
2056441 | 2056441 | 2021-03-15 | US | California | Orange | 6059 | 263994 | 4486 | 0 | 33.70147516 | -117.76459979999998 | 2021-03-16 05:25:13 | Orange, California, US | |
3601036 | 3601036 | 2021-02-17 | Italy | Toscana | 145020 | 4486 | 128138 | 12396 | 43.76923077 | 11.25588885 | 2021-02-18 05:22:58 | Toscana, Italy | ||
236968 | 236968 | 2021-01-18 | Bosnia and Herzegovina | 118083 | 4486 | 86505 | 27092 | 43.9159 | 17.6791 | 2021-01-19 05:22:15 | Bosnia and Herzegovina | |||
774429 | 774429 | 2021-01-12 | Mexico | Coahuila | 53078 | 4486 | 0 | 48592 | 27.0587 | -101.7068 | 2021-01-13 05:22:15 | Coahuila, Mexico | ||
766060 | 766060 | 2020-12-29 | Brazil | Mato Grosso | 178568 | 4486 | 168243 | 4966 | -12.6819 | -56.9211 | 2020-12-30 05:22:34 | Mato Grosso, Brazil | ||
3761491 | 3761491 | 2020-12-28 | Germany | Baden-Wurttemberg | 230029 | 4486 | 176933 | 50166 | 48.6616 | 9.3501 | 2020-12-29 05:22:37 | Baden-Wurttemberg, Germany | ||
1822769 | 1822769 | 2020-10-04 | Italy | Emilia-Romagna | 35922 | 4486 | 26482 | 4954 | 44.49436681 | 11.3417208 | 2020-10-05 04:23:33 | Emilia-Romagna, Italy |
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]);