johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 3893 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2757146 | 2757146 | 2022-10-18 | Russia | Lipetsk Oblast | 173917 | 3893 | 0 | 52.6935178 | 39.1122664 | 2022-10-19 04:22:26 | Lipetsk Oblast, Russia | |||
2967669 | 2967669 | 2022-10-10 | Russia | Udmurt Republic | 216006 | 3893 | 0 | 57.1961165 | 52.6959832 | 2022-10-11 04:23:05 | Udmurt Republic, Russia | |||
1785973 | 1785973 | 2022-07-29 | US | Ohio | Cuyahoga | 39035 | 300605 | 3893 | 0 | 41.424119 | -81.65918339 | 2022-07-30 04:20:42 | Cuyahoga, Ohio, US | |
561057 | 561057 | 2022-06-16 | US | New York | Nassau | 36059 | 448751 | 3893 | 0 | 40.74066522 | -73.58941873 | 2022-06-17 04:20:56 | Nassau, New York, US | |
1951632 | 1951632 | 2022-04-12 | US | Texas | Hidalgo | 48215 | 203945 | 3893 | 0 | 26.39418217 | -98.18299696 | 2022-04-13 04:21:03 | Hidalgo, Texas, US | |
554843 | 554843 | 2022-01-16 | Malaysia | Johor | 250780 | 3893 | 0 | 1.4854 | 103.7618 | 2022-01-17 04:21:08 | Johor, Malaysia | |||
1030610 | 1030610 | 2021-12-06 | Russia | Novosibirsk Oblast | 85101 | 3893 | 0 | 54.9720169 | 79.48139240000002 | 2021-12-07 04:22:34 | Novosibirsk Oblast, Russia | |||
1740576 | 1740576 | 2021-12-05 | Korea, South | 477358 | 3893 | 0 | 35.90775700000001 | 127.766922 | 2021-12-06 04:22:34 | Korea, South | ||||
86863 | 86863 | 2021-11-09 | Brazil | Tocantins | 229929 | 3893 | 0 | -10.1753 | -48.2982 | 2021-11-10 04:21:38 | Tocantins, Brazil | |||
3805870 | 3805870 | 2021-09-11 | India | Telangana | 661302 | 3893 | 0 | 18.1124 | 79.0193 | 2021-09-12 04:21:13 | Telangana, India | |||
3448552 | 3448552 | 2021-09-10 | Belarus | 499279 | 3893 | 0 | 53.7098 | 27.9534 | 2021-09-11 04:21:30 | Belarus | ||||
1596470 | 1596470 | 2021-08-26 | Russia | Voronezh Oblast | 116239 | 3893 | 0 | 50.9800393 | 40.15065070000001 | 2021-08-27 04:21:37 | Voronezh Oblast, Russia | |||
2203840 | 2203840 | 2021-08-07 | Russia | Irkutsk Oblast | 88222 | 3893 | 0 | 56.6370122 | 104.719221 | 2021-08-08 04:21:33 | Irkutsk Oblast, Russia | |||
3740962 | 3740962 | 2021-07-12 | Dominican Republic | 334544 | 3893 | 275595 | 55056 | 18.7357 | -70.1627 | 2021-07-13 04:21:18 | Dominican Republic | |||
1932354 | 1932354 | 2021-07-05 | Germany | Rheinland-Pfalz | 155329 | 3893 | 150500 | 973 | 50.1183 | 7.309 | 2021-07-06 04:21:32 | Rheinland-Pfalz, Germany | ||
3621036 | 3621036 | 2021-03-17 | India | Madhya Pradesh | 271040 | 3893 | 261531 | 5616 | 23.541513 | 78.289633 | 2021-03-18 05:26:22 | Madhya Pradesh, India | ||
702966 | 702966 | 2021-03-16 | US | California | Riverside | 6065 | 294956 | 3893 | 0 | 33.74314981 | -115.9933578 | 2021-03-17 05:25:07 | Riverside, California, US | |
1338208 | 1338208 | 2021-02-15 | Honduras | 160983 | 3893 | 63346 | 93744 | 15.2 | -86.2419 | 2021-02-16 05:24:38 | Honduras | |||
2919257 | 2919257 | 2020-11-04 | Mexico | Baja California | 23480 | 3893 | 18526 | 1061 | 30.8406 | -115.2838 | 2020-11-05 06:05:03 | Baja California, Mexico | ||
3161798 | 3161798 | 2020-09-06 | Romania | 95014 | 3893 | 40307 | 50814 | 45.9432 | 24.9668 | 2020-09-07 04:28:30 | Romania |
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]);