johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where deaths = 6597 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
538769 | 538769 | 2022-10-26 | Japan | Osaka | 2155882 | 6597 | 0 | 34.620965 | 135.507481 | 2022-10-27 04:22:01 | Osaka, Japan | |||
2732931 | 2732931 | 2022-02-27 | Germany | Thuringen | 400167 | 6597 | 0 | 51.011 | 10.8453 | 2022-02-28 04:21:05 | Thuringen, Germany | |||
3046084 | 3046084 | 2022-02-26 | Germany | Thuringen | 400167 | 6597 | 0 | 51.011 | 10.8453 | 2022-02-27 04:21:04 | Thuringen, Germany | |||
574739 | 574739 | 2022-02-25 | Germany | Thuringen | 400167 | 6597 | 0 | 51.011 | 10.8453 | 2022-02-26 04:21:12 | Thuringen, Germany | |||
233493 | 233493 | 2022-02-11 | Russia | Stavropol Krai | 160527 | 6597 | 0 | 44.86325770000001 | 43.4406913 | 2022-02-12 04:21:06 | Stavropol Krai, Russia | |||
3017568 | 3017568 | 2021-08-01 | US | New York | Bronx | 36005 | 187026 | 6597 | 0 | 40.85209301 | -73.86282755 | 2021-08-02 04:21:36 | Bronx, New York, US | |
3906191 | 3906191 | 2021-07-31 | US | New York | Bronx | 36005 | 186838 | 6597 | 0 | 40.85209301 | -73.86282755 | 2021-08-01 04:21:50 | Bronx, New York, US | |
3298396 | 3298396 | 2021-07-30 | US | New York | Bronx | 36005 | 186530 | 6597 | 0 | 40.85209301 | -73.86282755 | 2021-07-31 04:21:35 | Bronx, New York, US | |
1380725 | 1380725 | 2021-07-25 | US | New York | Bronx | 36005 | 185777 | 6597 | 0 | 40.85209301 | -73.86282755 | 2021-07-26 04:21:28 | Bronx, New York, US | |
1498709 | 1498709 | 2021-07-03 | US | Texas | Harris | 48201 | 472135 | 6597 | 0 | 29.85864939 | -95.39339521 | 2021-07-04 04:21:38 | Harris, Texas, US | |
400009 | 400009 | 2021-06-29 | Brazil | Piaui | 295781 | 6597 | 283852 | 5074 | -7.7183 | -42.7289 | 2021-06-30 04:21:41 | Piaui, Brazil | ||
2911164 | 2911164 | 2021-06-17 | Italy | Puglia | 252651 | 6597 | 235823 | 10231 | 41.12559576 | 16.86736689 | 2021-06-18 04:22:16 | Puglia, Italy | ||
83194 | 83194 | 2021-05-25 | Mexico | Sonora | 74820 | 6597 | 0 | 68223 | 29.2972 | -110.3309 | 2021-05-26 04:20:35 | Sonora, Mexico | ||
1090000 | 1090000 | 2021-03-03 | Greece | 197279 | 6597 | 93764 | 96918 | 39.0742 | 21.8243 | 2021-03-04 05:24:24 | Greece | |||
3860796 | 3860796 | 2020-12-04 | US | Illinois | Cook | 17031 | 322122 | 6597 | 0 | 315525 | 41.84144849 | -87.81658794 | 2020-12-05 05:27:36 | Cook, Illinois, US |
753626 | 753626 | 2020-08-01 | Brazil | Pernambuco | 96746 | 6597 | 70967 | 19182 | -8.8137 | -36.9541 | 2020-08-02 04:34:47 | Pernambuco, 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]);