johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where country_or_region = "US" and deaths = 3890 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 |
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]);