daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where deaths = 3935 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-19 | Russia | Lipetsk Oblast | 176077 | 3935 | 0 | 52.6935178 | 39.1122664 | 2022-12-20 04:21:04 | Lipetsk Oblast, Russia | |||
2022-12-18 | Russia | Lipetsk Oblast | 176055 | 3935 | 0 | 52.6935178 | 39.1122664 | 2022-12-19 04:21:03 | Lipetsk Oblast, Russia | |||
2022-12-17 | Russia | Lipetsk Oblast | 176029 | 3935 | 0 | 52.6935178 | 39.1122664 | 2022-12-18 04:21:03 | Lipetsk Oblast, Russia | |||
2022-12-16 | Russia | Lipetsk Oblast | 176001 | 3935 | 0 | 52.6935178 | 39.1122664 | 2022-12-17 04:21:04 | Lipetsk Oblast, Russia | |||
2022-11-11 | Russia | Udmurt Republic | 224061 | 3935 | 0 | 57.1961165 | 52.6959832 | 2022-11-12 04:20:41 | Udmurt Republic, Russia | |||
2022-11-10 | Russia | Udmurt Republic | 223975 | 3935 | 0 | 57.1961165 | 52.6959832 | 2022-11-11 04:21:22 | Udmurt Republic, Russia | |||
2022-11-09 | Russia | Udmurt Republic | 223873 | 3935 | 0 | 57.1961165 | 52.6959832 | 2022-11-10 04:21:16 | Udmurt Republic, Russia | |||
2022-09-01 | US | Ohio | Cuyahoga | 39035 | 313582 | 3935 | 0 | 41.424119 | -81.65918339 | 2022-09-02 04:21:07 | Cuyahoga, Ohio, US | |
2022-08-31 | US | Ohio | Cuyahoga | 39035 | 311171 | 3935 | 0 | 41.424119 | -81.65918339 | 2022-09-01 04:21:03 | Cuyahoga, Ohio, US | |
2022-07-21 | US | Texas | Hidalgo | 48215 | 227856 | 3935 | 0 | 26.39418217 | -98.18299696 | 2022-07-22 04:21:15 | Hidalgo, Texas, US | |
2022-07-20 | US | Texas | Hidalgo | 48215 | 227357 | 3935 | 0 | 26.39418217 | -98.18299696 | 2022-07-21 04:21:10 | Hidalgo, Texas, US | |
2022-07-19 | US | Texas | Hidalgo | 48215 | 226869 | 3935 | 0 | 26.39418217 | -98.18299696 | 2022-07-20 04:20:59 | Hidalgo, Texas, US | |
2022-06-28 | Italy | Marche | 494942 | 3935 | 0 | 43.61675973 | 13.5188753 | 2022-06-29 04:20:59 | Marche, Italy | |||
2022-06-27 | Italy | Marche | 492497 | 3935 | 0 | 43.61675973 | 13.5188753 | 2022-06-28 04:20:58 | Marche, Italy | |||
2022-06-22 | Colombia | Cordoba | 119748 | 3935 | 0 | 8.0493 | -75.574 | 2022-06-23 04:20:55 | Cordoba, Colombia | |||
2022-06-21 | Colombia | Cordoba | 119748 | 3935 | 0 | 8.0493 | -75.574 | 2022-06-22 04:20:54 | Cordoba, Colombia | |||
2022-06-20 | Colombia | Cordoba | 119748 | 3935 | 0 | 8.0493 | -75.574 | 2022-06-21 04:20:56 | Cordoba, Colombia | |||
2022-06-19 | Colombia | Cordoba | 119748 | 3935 | 0 | 8.0493 | -75.574 | 2022-06-20 04:21:01 | Cordoba, Colombia | |||
2022-06-18 | Colombia | Cordoba | 119748 | 3935 | 0 | 8.0493 | -75.574 | 2022-06-19 04:20:51 | Cordoba, Colombia | |||
2022-06-17 | Colombia | Cordoba | 119748 | 3935 | 0 | 8.0493 | -75.574 | 2022-06-18 04:21:10 | Cordoba, Colombia | |||
2022-06-16 | Colombia | Cordoba | 119748 | 3935 | 0 | 8.0493 | -75.574 | 2022-06-17 04:20:56 | Cordoba, Colombia | |||
2022-04-16 | Russia | Orenburg Oblast | 213706 | 3935 | 0 | 52.02692620000001 | 54.7276647 | 2022-04-17 04:20:59 | Orenburg Oblast, Russia | |||
2022-03-21 | US | Massachusetts | Middlesex | 25017 | 321549 | 3935 | 0 | 42.48607732 | -71.39049229 | 2022-03-22 04:20:54 | Middlesex, Massachusetts, US | |
2022-02-19 | Colombia | Tolima | 123661 | 3935 | 0 | 4.0925 | -75.1545 | 2022-02-20 04:21:00 | Tolima, Colombia | |||
2022-02-11 | Malaysia | Johor | 276770 | 3935 | 0 | 1.4854 | 103.7618 | 2022-02-12 04:21:06 | Johor, Malaysia | |||
2022-02-10 | Zambia | 308556 | 3935 | 0 | -13.133897 | 27.849332 | 2022-02-11 04:21:09 | Zambia | ||||
2021-11-25 | Spain | Aragon | 167765 | 3935 | 0 | 41.5976 | -0.9057 | 2021-11-26 04:22:33 | Aragon, Spain | |||
2021-11-24 | Spain | Aragon | 167296 | 3935 | 0 | 41.5976 | -0.9057 | 2021-11-25 04:22:33 | Aragon, Spain | |||
2021-11-23 | Spain | Aragon | 166856 | 3935 | 0 | 41.5976 | -0.9057 | 2021-11-24 04:22:14 | Aragon, Spain | |||
2021-11-21 | Ukraine | Kiev Oblast | 168022 | 3935 | 0 | 50.053000000000004 | 30.7667 | 2021-11-22 04:22:20 | Kiev Oblast, Ukraine | |||
2021-11-20 | Ukraine | Kiev Oblast | 167503 | 3935 | 0 | 50.053000000000004 | 30.7667 | 2021-11-21 04:22:13 | Kiev Oblast, Ukraine | |||
2021-11-12 | Russia | Volgograd Oblast | 109524 | 3935 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-13 04:21:38 | Volgograd Oblast, Russia | |||
2021-10-14 | India | Telangana | 668618 | 3935 | 0 | 18.1124 | 79.0193 | 2021-10-15 04:21:26 | Telangana, India | |||
2021-09-20 | West Bank and Gaza | 386493 | 3935 | 0 | 31.9522 | 35.2332 | 2021-09-21 04:21:26 | West Bank and Gaza | ||||
2021-05-15 | Peru | Loreto | 39127 | 3935 | 0 | 35192 | -4.124847 | -74.424115 | 2021-05-16 04:20:49 | Loreto, Peru | ||
2021-05-14 | Peru | Loreto | 39127 | 3935 | 0 | 35192 | -4.124847 | -74.424115 | 2021-05-15 04:20:58 | Loreto, Peru | ||
2021-04-08 | Italy | Liguria | 92766 | 3935 | 81103 | 7728 | 44.41149315 | 8.9326992 | 2021-04-09 04:21:13 | Liguria, Italy | ||
2021-04-05 | Mexico | Tabasco | 61436 | 3935 | 0 | 57501 | 17.8409 | -92.6189 | 2021-04-06 04:20:32 | Tabasco, Mexico | ||
2021-02-13 | Colombia | Atlantico | 119727 | 3935 | 114066 | 1726 | 10.6966 | -74.8741 | 2021-02-14 05:23:43 | Atlantico, Colombia | ||
2021-01-05 | Italy | Lazio | 170973 | 3935 | 89730 | 77308 | 41.89277044 | 12.48366722 | 2021-01-06 05:22:16 | Lazio, Italy | ||
2020-10-20 | Peru | Lambayeque | 27743 | 3935 | 0 | 23808 | -6.353049 | -79.824113 | 2020-10-21 04:24:14 | Lambayeque, Peru | ||
2020-07-31 | India | Tamil Nadu | 245859 | 3935 | 183956 | 57968 | 11.006091 | 78.400624 | 2020-08-01 04:36:27 | Tamil Nadu, India | ||
2020-07-13 | Egypt | 83001 | 3935 | 24975 | 54091 | 26.820553000000004 | 30.802497999999996 | 2020-07-14 04:34:46 | Egypt |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;