johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where deaths = 3426 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
451722 | 451722 | 2022-12-21 | Sweden | Vastra Gotaland | 449311 | 3426 | 0 | 58.2528 | 13.0596 | 2022-12-22 04:20:56 | Vastra Gotaland, Sweden | |||
2951721 | 2951721 | 2022-12-20 | Sweden | Vastra Gotaland | 449311 | 3426 | 0 | 58.2528 | 13.0596 | 2022-12-21 04:21:03 | Vastra Gotaland, Sweden | |||
3174123 | 3174123 | 2022-12-19 | Sweden | Vastra Gotaland | 449311 | 3426 | 0 | 58.2528 | 13.0596 | 2022-12-20 04:21:04 | Vastra Gotaland, Sweden | |||
1628640 | 1628640 | 2022-12-18 | Sweden | Vastra Gotaland | 449311 | 3426 | 0 | 58.2528 | 13.0596 | 2022-12-19 04:21:03 | Vastra Gotaland, Sweden | |||
504019 | 504019 | 2022-12-17 | Sweden | Vastra Gotaland | 449311 | 3426 | 0 | 58.2528 | 13.0596 | 2022-12-18 04:21:03 | Vastra Gotaland, Sweden | |||
3324591 | 3324591 | 2022-12-16 | Sweden | Vastra Gotaland | 449311 | 3426 | 0 | 58.2528 | 13.0596 | 2022-12-17 04:21:04 | Vastra Gotaland, Sweden | |||
543103 | 543103 | 2022-12-15 | Sweden | Vastra Gotaland | 449311 | 3426 | 0 | 58.2528 | 13.0596 | 2022-12-16 04:21:01 | Vastra Gotaland, Sweden | |||
3908133 | 3908133 | 2022-08-11 | Netherlands | Noord-Holland | 1376477 | 3426 | 0 | 52.600906 | 4.918688 | 2022-08-12 04:20:54 | Noord-Holland, Netherlands | |||
670262 | 670262 | 2022-07-21 | Italy | Abruzzo | 486176 | 3426 | 0 | 42.35122196 | 13.39843823 | 2022-07-22 04:21:15 | Abruzzo, Italy | |||
2892676 | 2892676 | 2022-04-21 | Russia | Vladimir Oblast | 150055 | 3426 | 0 | 56.0503336 | 40.656163299999996 | 2022-04-22 04:20:45 | Vladimir Oblast, Russia | |||
1720706 | 1720706 | 2022-03-25 | Russia | Leningrad Oblast | 180343 | 3426 | 0 | 60.185329599999996 | 32.3925325 | 2022-03-26 04:20:23 | Leningrad Oblast, Russia | |||
694613 | 694613 | 2022-03-17 | Russia | Lipetsk Oblast | 138213 | 3426 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-03-18 04:20:55 | Lipetsk Oblast, Russia | |||
1467735 | 1467735 | 2022-02-10 | Ukraine | Zhytomyr Oblast | 177804 | 3426 | 0 | 50.2547 | 28.6587 | 2022-02-11 04:21:09 | Zhytomyr Oblast, Ukraine | |||
978920 | 978920 | 2022-02-01 | Italy | Marche | 266988 | 3426 | 0 | 43.61675973 | 13.5188753 | 2022-02-02 04:21:09 | Marche, Italy | |||
3496297 | 3496297 | 2021-12-15 | Mexico | Zacatecas | 42417 | 3426 | 0 | 22.7709 | -102.5832 | 2021-12-16 04:22:11 | Zacatecas, Mexico | |||
3448958 | 3448958 | 2021-09-10 | Namibia | 126025 | 3426 | 0 | -22.9576 | 18.4904 | 2021-09-11 04:21:30 | Namibia | ||||
1606500 | 1606500 | 2021-08-16 | US | New York | Suffolk | 36103 | 209612 | 3426 | 0 | 40.88320119 | -72.8012172 | 2021-08-17 04:21:49 | Suffolk, New York, US | |
105594 | 105594 | 2021-08-15 | US | New York | Suffolk | 36103 | 209136 | 3426 | 0 | 40.88320119 | -72.8012172 | 2021-08-16 04:21:31 | Suffolk, New York, US | |
509952 | 509952 | 2021-08-14 | US | New York | Suffolk | 36103 | 208796 | 3426 | 0 | 40.88320119 | -72.8012172 | 2021-08-15 04:21:41 | Suffolk, New York, US | |
3335197 | 3335197 | 2021-07-21 | Venezuela | 295746 | 3426 | 279177 | 13143 | 6.4238 | -66.5897 | 2021-07-22 04:21:19 | Venezuela | |||
1893061 | 1893061 | 2021-06-30 | Germany | Sachsen-Anhalt | 99229 | 3426 | 95620 | 229 | 51.9503 | 11.6923 | 2021-07-01 04:21:19 | Sachsen-Anhalt, Germany | ||
400184 | 400184 | 2021-06-29 | Germany | Sachsen-Anhalt | 99228 | 3426 | 95450 | 392 | 51.9503 | 11.6923 | 2021-06-30 04:21:41 | Sachsen-Anhalt, Germany | ||
522824 | 522824 | 2021-06-09 | India | Telangana | 596813 | 3426 | 569086 | 24301 | 18.1124 | 79.0193 | 2021-06-10 04:23:17 | Telangana, India | ||
1188993 | 1188993 | 2021-05-31 | Russia | Sverdlovsk Oblast | 89295 | 3426 | 83191 | 2678 | 58.6414755 | 61.8021546 | 2021-06-01 04:23:09 | Sverdlovsk Oblast, Russia | ||
1412746 | 1412746 | 2021-05-24 | Algeria | 127107 | 3426 | 88497 | 35184 | 28.0339 | 1.6596 | 2021-05-25 04:21:08 | Algeria | |||
2020604 | 2020604 | 2021-04-20 | Dominican Republic | 261848 | 3426 | 219262 | 39160 | 18.7357 | -70.1627 | 2021-04-21 04:21:14 | Dominican Republic | |||
908275 | 908275 | 2021-01-19 | Mexico | San Luis Potosi | 45855 | 3426 | 0 | 42429 | 22.1565 | -100.9855 | 2021-01-20 05:21:54 | San Luis Potosi, Mexico | ||
1752950 | 1752950 | 2020-12-14 | US | Michigan | Wayne | 26163 | 76765 | 3426 | 0 | 73339 | 42.28098405 | -83.281255 | 2020-12-15 05:26:38 | Wayne, Michigan, US |
738382 | 738382 | 2020-12-02 | Mexico | Coahuila | 42410 | 3426 | 0 | 38984 | 27.0587 | -101.7068 | 2020-12-03 05:28:22 | Coahuila, Mexico | ||
3189896 | 3189896 | 2020-11-22 | Germany | Bayern | 181001 | 3426 | 123171 | 56578 | 48.7904 | 11.4979 | 2020-11-23 05:25:26 | Bayern, Germany | ||
3304352 | 3304352 | 2020-11-02 | Peru | Ica | 29728 | 3426 | 0 | 26302 | -14.235097 | -75.574821 | 2020-11-03 06:00:16 | Ica, Peru | ||
1823224 | 1823224 | 2020-10-04 | US | Arizona | Maricopa | 4013 | 143183 | 3426 | 0 | 139757 | 33.34835867 | -112.4918154 | 2020-10-05 04:23:33 | 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]);