johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where deaths = 3890 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- Russia 12
- US 8
- Norway 7
- India 2
- Trinidad and Tobago 2
- Colombia 1
- Germany 1
- Italy 1
- Malaysia 1
- Mexico 1
- Philippines 1
- Ukraine 1
- West Bank and Gaza 1
- Zambia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2486268 | 2486268 | 2022-11-16 | Russia | Vologda Oblast | 214796 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-17 04:21:11 | Vologda Oblast, Russia | |||
292279 | 292279 | 2022-11-15 | Russia | Vologda Oblast | 214757 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-16 04:21:09 | Vologda Oblast, Russia | |||
3597309 | 3597309 | 2022-11-14 | Russia | Vologda Oblast | 214725 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-15 04:21:16 | Vologda Oblast, Russia | |||
312167 | 312167 | 2022-11-13 | Russia | Vologda Oblast | 214691 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-14 04:21:09 | Vologda Oblast, Russia | |||
63328 | 63328 | 2022-11-12 | Russia | Vologda Oblast | 214654 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-13 04:21:14 | Vologda Oblast, Russia | |||
2927490 | 2927490 | 2022-11-11 | Russia | Vologda Oblast | 214613 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-12 04:20:41 | Vologda Oblast, Russia | |||
2506326 | 2506326 | 2022-11-10 | Russia | Vologda Oblast | 214569 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-11 04:21:22 | Vologda Oblast, Russia | |||
2431201 | 2431201 | 2022-11-09 | Russia | Vologda Oblast | 214527 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-10 04:21:16 | Vologda Oblast, Russia | |||
479857 | 479857 | 2022-11-08 | Russia | Vologda Oblast | 214488 | 3890 | 0 | 60.0391461 | 43.1215213 | 2022-11-09 04:21:22 | Vologda Oblast, Russia | |||
2159758 | 2159758 | 2022-10-16 | Russia | Lipetsk Oblast | 173797 | 3890 | 0 | 52.6935178 | 39.1122664 | 2022-10-17 04:20:31 | Lipetsk Oblast, Russia | |||
2853004 | 2853004 | 2022-08-22 | Norway | 1459129 | 3890 | 0 | 60.472 | 8.4689 | 2022-08-23 04:20:56 | Norway | ||||
2402976 | 2402976 | 2022-08-21 | Norway | 1458987 | 3890 | 0 | 60.472 | 8.4689 | 2022-08-22 04:20:38 | Norway | ||||
3798054 | 3798054 | 2022-08-20 | Norway | 1458952 | 3890 | 0 | 60.472 | 8.4689 | 2022-08-21 04:20:44 | Norway | ||||
2363640 | 2363640 | 2022-08-19 | Norway | 1458896 | 3890 | 0 | 60.472 | 8.4689 | 2022-08-20 04:21:01 | Norway | ||||
1161311 | 1161311 | 2022-08-18 | Norway | 1458751 | 3890 | 0 | 60.472 | 8.4689 | 2022-08-19 04:20:54 | Norway | ||||
3950635 | 3950635 | 2022-08-17 | Norway | 1458603 | 3890 | 0 | 60.472 | 8.4689 | 2022-08-18 04:21:11 | Norway | ||||
991137 | 991137 | 2022-08-16 | Norway | 1458460 | 3890 | 0 | 60.472 | 8.4689 | 2022-08-17 04:20:59 | Norway | ||||
1068336 | 1068336 | 2022-07-28 | US | Ohio | Cuyahoga | 39035 | 300605 | 3890 | 0 | 41.424119 | -81.65918339 | 2022-07-29 04:20:45 | Cuyahoga, Ohio, US | |
2337855 | 2337855 | 2022-07-27 | US | Ohio | Cuyahoga | 39035 | 297673 | 3890 | 0 | 41.424119 | -81.65918339 | 2022-07-28 04:20:56 | Cuyahoga, Ohio, US | |
3984859 | 3984859 | 2022-06-15 | US | New York | Nassau | 36059 | 448160 | 3890 | 0 | 40.74066522 | -73.58941873 | 2022-06-16 04:20:55 | Nassau, New York, US | |
949100 | 949100 | 2022-06-14 | US | New York | Nassau | 36059 | 447677 | 3890 | 0 | 40.74066522 | -73.58941873 | 2022-06-15 04:20:54 | Nassau, New York, US | |
3592998 | 3592998 | 2022-05-23 | Italy | Marche | 469221 | 3890 | 0 | 43.61675973 | 13.5188753 | 2022-05-24 04:20:57 | Marche, Italy | |||
1109917 | 1109917 | 2022-05-21 | Trinidad and Tobago | 157880 | 3890 | 0 | 10.6918 | -61.2225 | 2022-05-22 04:20:52 | Trinidad and Tobago | ||||
1169541 | 1169541 | 2022-05-20 | Trinidad and Tobago | 157363 | 3890 | 0 | 10.6918 | -61.2225 | 2022-05-21 04:20:58 | Trinidad and Tobago | ||||
2442950 | 2442950 | 2022-04-13 | Russia | Bryansk Oblast | 159913 | 3890 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-13 23:21:06 | Bryansk Oblast, Russia | |||
3323359 | 3323359 | 2022-04-07 | US | Texas | Hidalgo | 48215 | 203356 | 3890 | 0 | 26.39418217 | -98.18299696 | 2022-04-08 04:20:48 | Hidalgo, Texas, US | |
1363405 | 1363405 | 2022-02-08 | US | Illinois | Unassigned | 90017 | 206 | 3890 | 0 | 42.36542373 | 0.0 | 2022-02-09 04:21:04 | Unassigned, Illinois, US | |
2836506 | 2836506 | 2022-01-22 | Zambia | 301203 | 3890 | 0 | -13.133897 | 27.849332 | 2022-01-23 04:21:13 | Zambia | ||||
99379 | 99379 | 2022-01-14 | Malaysia | Johor | 249990 | 3890 | 0 | 1.4854 | 103.7618 | 2022-01-15 04:21:07 | Johor, Malaysia | |||
1391933 | 1391933 | 2022-01-07 | US | New York | Suffolk | 36103 | 359671 | 3890 | 0 | 40.88320119 | -72.8012172 | 2022-01-08 04:21:53 | Suffolk, New York, US | |
3655785 | 3655785 | 2021-12-10 | Russia | Bashkortostan Republic | 112679 | 3890 | 0 | 54.8573563 | 57.1439682 | 2021-12-11 04:22:45 | Bashkortostan Republic, Russia | |||
2621710 | 2621710 | 2021-09-17 | West Bank and Gaza | 381854 | 3890 | 0 | 31.9522 | 35.2332 | 2021-09-18 04:21:24 | West Bank and Gaza | ||||
2764850 | 2764850 | 2021-07-01 | Germany | Rheinland-Pfalz | 155220 | 3890 | 150500 | 877 | 50.1183 | 7.309 | 2021-07-02 04:21:47 | Rheinland-Pfalz, Germany | ||
3887215 | 3887215 | 2021-04-11 | Ukraine | Kiev | 176569 | 3890 | 111068 | 61611 | 50.4501 | 30.5234 | 2021-04-12 04:21:00 | Kiev, Ukraine | ||
2055838 | 2055838 | 2021-03-15 | India | Madhya Pradesh | 269391 | 3890 | 260477 | 5024 | 23.541513 | 78.289633 | 2021-03-16 05:25:13 | Madhya Pradesh, India | ||
1732437 | 1732437 | 2021-03-14 | India | Chhattisgarh | 317329 | 3890 | 309433 | 4006 | 21.264705 | 82.035366 | 2021-03-15 05:25:51 | Chhattisgarh, India | ||
1672292 | 1672292 | 2021-02-07 | Colombia | Atlantico | 118104 | 3890 | 111565 | 2649 | 10.6966 | -74.8741 | 2021-02-08 05:22:39 | Atlantico, Colombia | ||
2119795 | 2119795 | 2020-12-20 | Mexico | Coahuila | 46821 | 3890 | 0 | 42931 | 27.0587 | -101.7068 | 2020-12-21 05:27:58 | Coahuila, Mexico | ||
3836924 | 3836924 | 2020-11-21 | US | Arizona | Maricopa | 4013 | 187636 | 3890 | 0 | 183746 | 33.34835867 | -112.4918154 | 2020-11-22 05:25:45 | Maricopa, Arizona, US |
427509 | 427509 | 2020-09-07 | Philippines | 238727 | 3890 | 184906 | 49931 | 12.879721 | 121.774017 | 2020-09-08 04:28:25 | Philippines |
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]);