johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where deaths = 3877 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002894 | 4002894 | 2022-10-08 | Russia | Lipetsk Oblast | 172968 | 3877 | 0 | 52.6935178 | 39.1122664 | 2022-10-09 04:21:16 | Lipetsk Oblast, Russia | |||
253614 | 253614 | 2022-09-08 | Spain | Galicia | 725572 | 3877 | 0 | 42.5751 | -8.1339 | 2022-09-09 04:21:11 | Galicia, Spain | |||
3745412 | 3745412 | 2022-09-07 | Spain | Galicia | 725572 | 3877 | 0 | 42.5751 | -8.1339 | 2022-09-08 04:21:02 | Galicia, Spain | |||
115052 | 115052 | 2022-09-06 | Spain | Galicia | 725572 | 3877 | 0 | 42.5751 | -8.1339 | 2022-09-07 04:20:59 | Galicia, Spain | |||
3617346 | 3617346 | 2022-08-01 | Russia | Vologda Oblast | 193504 | 3877 | 0 | 60.0391461 | 43.1215213 | 2022-08-02 04:20:53 | Vologda Oblast, Russia | |||
3871826 | 3871826 | 2022-07-31 | Russia | Vologda Oblast | 193462 | 3877 | 0 | 60.0391461 | 43.1215213 | 2022-08-01 04:21:03 | Vologda Oblast, Russia | |||
674580 | 674580 | 2022-07-30 | Russia | Vologda Oblast | 193421 | 3877 | 0 | 60.0391461 | 43.1215213 | 2022-07-31 04:21:02 | Vologda Oblast, Russia | |||
1783779 | 1783779 | 2022-07-29 | Russia | Vologda Oblast | 193377 | 3877 | 0 | 60.0391461 | 43.1215213 | 2022-07-30 04:20:42 | Vologda Oblast, Russia | |||
1066142 | 1066142 | 2022-07-28 | Russia | Vologda Oblast | 193332 | 3877 | 0 | 60.0391461 | 43.1215213 | 2022-07-29 04:20:45 | Vologda Oblast, Russia | |||
2335661 | 2335661 | 2022-07-27 | Russia | Vologda Oblast | 193290 | 3877 | 0 | 60.0391461 | 43.1215213 | 2022-07-28 04:20:56 | Vologda Oblast, Russia | |||
1487851 | 1487851 | 2022-07-26 | Russia | Vologda Oblast | 193250 | 3877 | 0 | 60.0391461 | 43.1215213 | 2022-07-27 04:21:04 | Vologda Oblast, Russia | |||
3111944 | 3111944 | 2022-07-13 | US | Ohio | Cuyahoga | 39035 | 292507 | 3877 | 0 | 41.424119 | -81.65918339 | 2022-07-14 04:20:57 | Cuyahoga, Ohio, US | |
2239857 | 2239857 | 2022-06-28 | US | Arizona | Pima | 4019 | 267665 | 3877 | 0 | 32.0971334 | -111.7890033 | 2022-06-29 04:20:59 | Pima, Arizona, US | |
2148099 | 2148099 | 2022-06-27 | US | Arizona | Pima | 4019 | 267665 | 3877 | 0 | 32.0971334 | -111.7890033 | 2022-06-28 04:20:58 | Pima, Arizona, US | |
475900 | 475900 | 2022-06-26 | US | Arizona | Pima | 4019 | 267665 | 3877 | 0 | 32.0971334 | -111.7890033 | 2022-06-27 04:21:00 | Pima, Arizona, US | |
939275 | 939275 | 2022-06-25 | US | Arizona | Pima | 4019 | 267665 | 3877 | 0 | 32.0971334 | -111.7890033 | 2022-06-26 04:21:02 | Pima, Arizona, US | |
3347095 | 3347095 | 2022-06-24 | US | Arizona | Pima | 4019 | 267665 | 3877 | 0 | 32.0971334 | -111.7890033 | 2022-06-25 04:20:57 | Pima, Arizona, US | |
1648836 | 1648836 | 2022-06-23 | US | Arizona | Pima | 4019 | 267665 | 3877 | 0 | 32.0971334 | -111.7890033 | 2022-06-24 04:20:58 | Pima, Arizona, US | |
2188071 | 2188071 | 2022-06-22 | US | Arizona | Pima | 4019 | 267665 | 3877 | 0 | 32.0971334 | -111.7890033 | 2022-06-23 04:20:55 | Pima, Arizona, US | |
3727892 | 3727892 | 2022-06-07 | US | Michigan | Oakland | 26125 | 312684 | 3877 | 0 | 42.66090111 | -83.38595416 | 2022-06-08 04:20:55 | Oakland, Michigan, US | |
3889294 | 3889294 | 2022-06-06 | US | Michigan | Oakland | 26125 | 312684 | 3877 | 0 | 42.66090111 | -83.38595416 | 2022-06-07 04:21:08 | Oakland, Michigan, US | |
3509063 | 3509063 | 2022-06-05 | US | Michigan | Oakland | 26125 | 312684 | 3877 | 0 | 42.66090111 | -83.38595416 | 2022-06-06 04:20:57 | Oakland, Michigan, US | |
3529140 | 3529140 | 2022-06-04 | US | Michigan | Oakland | 26125 | 312684 | 3877 | 0 | 42.66090111 | -83.38595416 | 2022-06-05 04:20:55 | Oakland, Michigan, US | |
3135802 | 3135802 | 2022-06-03 | US | New York | Nassau | 36059 | 442252 | 3877 | 0 | 40.74066522 | -73.58941873 | 2022-06-04 04:20:58 | Nassau, New York, US | |
3135226 | 3135226 | 2022-06-03 | US | Michigan | Oakland | 26125 | 312684 | 3877 | 0 | 42.66090111 | -83.38595416 | 2022-06-04 04:20:58 | Oakland, Michigan, US | |
3580301 | 3580301 | 2022-06-02 | US | Michigan | Oakland | 26125 | 312684 | 3877 | 0 | 42.66090111 | -83.38595416 | 2022-06-03 04:20:58 | Oakland, Michigan, US | |
972594 | 972594 | 2022-06-01 | US | Michigan | Oakland | 26125 | 312684 | 3877 | 0 | 42.66090111 | -83.38595416 | 2022-06-02 05:20:39 | Oakland, Michigan, US | |
1503571 | 1503571 | 2022-05-16 | Italy | Marche | 463651 | 3877 | 0 | 43.61675973 | 13.5188753 | 2022-05-17 04:20:59 | Marche, Italy | |||
1471219 | 1471219 | 2022-03-24 | US | Texas | Hidalgo | 48215 | 199850 | 3877 | 0 | 26.39418217 | -98.18299696 | 2022-03-25 04:20:46 | Hidalgo, Texas, US | |
3025393 | 3025393 | 2022-03-23 | US | Texas | Hidalgo | 48215 | 199670 | 3877 | 0 | 26.39418217 | -98.18299696 | 2022-03-24 04:20:43 | Hidalgo, Texas, US | |
3809801 | 3809801 | 2022-01-28 | El Salvador | 127012 | 3877 | 0 | 13.7942 | -88.8965 | 2022-01-29 04:21:10 | El Salvador | ||||
3230127 | 3230127 | 2022-01-19 | Zambia | 299172 | 3877 | 0 | -13.133897 | 27.849332 | 2022-01-20 04:21:07 | Zambia | ||||
126786 | 126786 | 2022-01-09 | Malaysia | Johor | 248141 | 3877 | 0 | 1.4854 | 103.7618 | 2022-01-10 04:22:07 | Johor, Malaysia | |||
2612320 | 2612320 | 2022-01-06 | US | New York | Suffolk | 36103 | 354277 | 3877 | 0 | 40.88320119 | -72.8012172 | 2022-01-07 04:22:09 | Suffolk, New York, US | |
2167495 | 2167495 | 2022-01-01 | India | Himachal Pradesh | 228940 | 3877 | 0 | 31.927213000000002 | 77.233081 | 2022-01-02 04:20:52 | Himachal Pradesh, India | |||
550667 | 550667 | 2021-12-08 | Germany | Berlin | 290582 | 3877 | 0 | 52.52 | 13.405 | 2021-12-09 04:22:49 | Berlin, Germany | |||
2720740 | 2720740 | 2021-10-30 | Brazil | Tocantins | 228681 | 3877 | 0 | -10.1753 | -48.2982 | 2021-10-31 04:22:08 | Tocantins, Brazil | |||
566842 | 566842 | 2021-10-29 | Brazil | Tocantins | 228681 | 3877 | 0 | -10.1753 | -48.2982 | 2021-10-30 04:22:03 | Tocantins, Brazil | |||
812268 | 812268 | 2021-09-20 | US | Pennsylvania | Philadelphia | 42101 | 173006 | 3877 | 0 | 40.00338507 | -75.1379271 | 2021-09-21 04:21:26 | Philadelphia, Pennsylvania, US | |
2923764 | 2923764 | 2021-08-27 | US | California | San Diego | 6073 | 349581 | 3877 | 0 | 33.03484597 | -116.73653259999999 | 2021-08-28 04:21:28 | San Diego, California, US | |
3468318 | 3468318 | 2021-08-03 | Oman | 297431 | 3877 | 280927 | 12627 | 21.512583 | 55.92325500000001 | 2021-08-04 04:21:25 | Oman | |||
2339624 | 2339624 | 2021-06-15 | Russia | Nizhny Novgorod Oblast | 120622 | 3877 | 114274 | 2471 | 55.47180329999999 | 44.0911594 | 2021-06-16 04:22:32 | Nizhny Novgorod Oblast, Russia | ||
82964 | 82964 | 2021-05-25 | Costa Rica | 306899 | 3877 | 231319 | 71703 | 9.7489 | -83.7534 | 2021-05-26 04:20:35 | Costa Rica | |||
3883495 | 3883495 | 2021-04-11 | Georgia | 288396 | 3877 | 277303 | 7216 | 42.3154 | 43.3569 | 2021-04-12 04:21:00 | Georgia | |||
3369630 | 3369630 | 2021-03-21 | Spain | Pais Vasco | 157008 | 3877 | 16160 | 136971 | 42.9896 | -2.6189 | 2021-03-22 05:25:43 | Pais Vasco, Spain | ||
1744840 | 1744840 | 2021-03-20 | Spain | Pais Vasco | 157008 | 3877 | 16160 | 136971 | 42.9896 | -2.6189 | 2021-03-21 05:25:44 | Pais Vasco, Spain | ||
3421220 | 3421220 | 2021-03-19 | Spain | Pais Vasco | 157008 | 3877 | 16160 | 136971 | 42.9896 | -2.6189 | 2021-03-20 05:25:46 | Pais Vasco, Spain | ||
3453158 | 3453158 | 2021-03-18 | Spain | Pais Vasco | 157008 | 3877 | 16160 | 136971 | 42.9896 | -2.6189 | 2021-03-19 05:26:09 | Pais Vasco, Spain | ||
1580284 | 1580284 | 2021-03-13 | Netherlands | Zuid-Holland | 271827 | 3877 | 0 | 266267 | 51.937835 | 4.462114 | 2021-03-14 05:25:37 | Zuid-Holland, Netherlands | ||
3962475 | 3962475 | 2021-03-10 | India | Madhya Pradesh | 266043 | 3877 | 258251 | 3915 | 23.541513 | 78.289633 | 2021-03-11 05:25:48 | Madhya Pradesh, India | ||
2227569 | 2227569 | 2021-01-02 | Jordan | 296668 | 3877 | 273986 | 18805 | 31.24 | 36.51 | 2021-01-03 05:22:52 | Jordan | |||
3149457 | 3149457 | 2020-12-16 | Colombia | Valle del Cauca | 122199 | 3877 | 111820 | 6502 | 3.8009 | -76.6413 | 2020-12-17 05:28:12 | Valle del Cauca, Colombia | ||
786537 | 786537 | 2020-10-15 | Peru | Lambayeque | 27277 | 3877 | 0 | 23400 | -6.353049 | -79.824113 | 2020-10-16 04:24:01 | Lambayeque, Peru | ||
344015 | 344015 | 2020-09-14 | Brazil | Goias | 168026 | 3877 | 157660 | 3966 | -15.827 | -49.8362 | 2020-09-15 03:22:50 | Goias, Brazil |
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]);