johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 3605 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3028460 | 3028460 | 2022-11-17 | US | New Jersey | Bergen | 34003 | 299419 | 3605 | 0 | 40.96010917 | -74.07164325 | 2022-11-18 04:21:15 | Bergen, New Jersey, US | |
3986827 | 3986827 | 2022-09-15 | Russia | Dagestan Republic | 100274 | 3605 | 0 | 43.0574916 | 47.1332224 | 2022-09-16 04:21:19 | Dagestan Republic, Russia | |||
3986233 | 3986233 | 2022-06-15 | Uganda | 166497 | 3605 | 0 | 1.373333 | 32.290275 | 2022-06-16 04:20:55 | Uganda | ||||
950474 | 950474 | 2022-06-14 | Uganda | 166378 | 3605 | 0 | 1.373333 | 32.290275 | 2022-06-15 04:20:54 | Uganda | ||||
1576376 | 1576376 | 2022-04-10 | Russia | Lipetsk Oblast | 147103 | 3605 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-04-11 04:21:02 | Lipetsk Oblast, Russia | |||
1294271 | 1294271 | 2022-02-05 | Russia | Omsk Oblast | 151425 | 3605 | 0 | 56.09352629999999 | 73.5099936 | 2022-02-06 04:21:00 | Omsk Oblast, Russia | |||
2327601 | 2327601 | 2022-02-04 | Russia | Orenburg Oblast | 124077 | 3605 | 0 | 52.02692620000001 | 54.7276647 | 2022-02-05 04:21:05 | Orenburg Oblast, Russia | |||
2126014 | 2126014 | 2021-10-21 | US | New York | Suffolk | 36103 | 239557 | 3605 | 0 | 40.88320119 | -72.8012172 | 2021-10-22 04:21:14 | Suffolk, New York, US | |
70732 | 70732 | 2021-09-01 | Zambia | 206522 | 3605 | 0 | -13.133897 | 27.849332 | 2021-09-02 04:21:15 | Zambia | ||||
3891792 | 3891792 | 2021-08-29 | Colombia | Tolima | 106811 | 3605 | 0 | 4.0925 | -75.1545 | 2021-08-30 04:21:23 | Tolima, Colombia | |||
1483310 | 1483310 | 2021-08-13 | Brazil | Tocantins | 214482 | 3605 | 0 | -10.1753 | -48.2982 | 2021-08-14 04:21:25 | Tocantins, Brazil | |||
3687078 | 3687078 | 2021-08-02 | Ukraine | Kharkiv Oblast | 149513 | 3605 | 145143 | 765 | 49.9935 | 36.2304 | 2021-08-03 04:21:39 | Kharkiv Oblast, Ukraine | ||
2910861 | 2910861 | 2021-06-17 | Algeria | 134840 | 3605 | 93831 | 37404 | 28.0339 | 1.6596 | 2021-06-18 04:22:16 | Algeria | |||
3033308 | 3033308 | 2021-06-16 | US | Texas | Bexar | 48029 | 229246 | 3605 | 0 | 29.44928723 | -98.52019748 | 2021-06-17 04:22:36 | Bexar, Texas, US | |
3702000 | 3702000 | 2021-04-27 | Ethiopia | 254044 | 3605 | 195547 | 54892 | 9.145 | 40.4897 | 2021-04-28 04:20:32 | Ethiopia | |||
1302290 | 1302290 | 2021-04-01 | Russia | Rostov Oblast | 81077 | 3605 | 72862 | 4610 | 47.6222451 | 40.7957942 | 2021-04-02 04:20:36 | Rostov Oblast, Russia | ||
3879411 | 3879411 | 2021-01-14 | Colombia | Atlantico | 102482 | 3605 | 95314 | 3563 | 10.6966 | -74.8741 | 2021-01-15 05:22:24 | Atlantico, Colombia | ||
3652276 | 3652276 | 2020-10-24 | US | Florida | Miami-Dade | 12086 | 181633 | 3605 | 0 | 178028 | 25.6112362 | -80.55170587 | 2020-10-25 04:24:36 | Miami-Dade, Florida, US |
2171288 | 2171288 | 2020-09-09 | Brazil | Goias | 154755 | 3605 | 144751 | 4358 | -15.827 | -49.8362 | 2020-09-10 04:29:01 | Goias, Brazil | ||
3866639 | 3866639 | 2020-06-03 | Brazil | Ceara | 56056 | 3605 | 0 | 52451 | -5.4984 | -39.3206 | 2020-06-04 02:33:14 | Ceara, 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]);