johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where deaths = 2636 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1211458 | 1211458 | 2022-07-11 | Germany | Schleswig-Holstein | 878408 | 2636 | 0 | 54.2194 | 9.6961 | 2022-07-12 04:20:51 | Schleswig-Holstein, Germany | |||
3985074 | 3985074 | 2022-06-15 | US | Ohio | Franklin | 39049 | 306118 | 2636 | 0 | 39.96995815 | -83.01115755 | 2022-06-16 04:20:55 | Franklin, Ohio, US | |
949315 | 949315 | 2022-06-14 | US | Ohio | Franklin | 39049 | 306118 | 2636 | 0 | 39.96995815 | -83.01115755 | 2022-06-15 04:20:54 | Franklin, Ohio, US | |
3889229 | 3889229 | 2022-06-06 | US | Massachusetts | Worcester | 25027 | 208317 | 2636 | 0 | 42.35026951 | -71.90493363 | 2022-06-07 04:21:08 | Worcester, Massachusetts, US | |
2084012 | 2084012 | 2022-05-15 | Malawi | 85888 | 2636 | 0 | -13.2543 | 34.3015 | 2022-05-16 04:20:47 | Malawi | ||||
3354722 | 3354722 | 2022-05-14 | Malawi | 85887 | 2636 | 0 | -13.2543 | 34.3015 | 2022-05-15 04:20:53 | Malawi | ||||
658367 | 658367 | 2022-05-13 | Malawi | 85866 | 2636 | 0 | -13.2543 | 34.3015 | 2022-05-14 04:20:48 | Malawi | ||||
1399928 | 1399928 | 2022-05-06 | US | New York | Erie | 36029 | 223208 | 2636 | 0 | 42.76249024 | -78.73063652 | 2022-05-07 04:21:09 | Erie, New York, US | |
2600283 | 2600283 | 2022-05-05 | US | New York | Erie | 36029 | 222464 | 2636 | 0 | 42.76249024 | -78.73063652 | 2022-05-06 04:21:00 | Erie, New York, US | |
3238594 | 3238594 | 2022-03-21 | Russia | Yaroslavl Oblast | 151214 | 2636 | 0 | 57.77819760000001 | 39.002109499999996 | 2022-03-22 04:20:54 | Yaroslavl Oblast, Russia | |||
336015 | 336015 | 2022-03-18 | Mexico | Baja California Sur | 102153 | 2636 | 0 | 26.0444 | -111.6661 | 2022-03-19 04:20:47 | Baja California Sur, Mexico | |||
694468 | 694468 | 2022-03-17 | Mexico | Baja California Sur | 102153 | 2636 | 0 | 26.0444 | -111.6661 | 2022-03-18 04:20:55 | Baja California Sur, Mexico | |||
189719 | 189719 | 2022-02-13 | Ukraine | Zakarpattia Oblast | 108236 | 2636 | 0 | 48.6208 | 22.2879 | 2022-02-14 04:20:51 | Zakarpattia Oblast, Ukraine | |||
1289630 | 1289630 | 2022-01-04 | Ukraine | Cherkasy Oblast | 129355 | 2636 | 0 | 49.4444 | 32.0598 | 2022-01-05 04:21:59 | Cherkasy Oblast, Ukraine | |||
278640 | 278640 | 2021-11-03 | US | Ohio | Cuyahoga | 39035 | 149715 | 2636 | 0 | 41.424119 | -81.65918339 | 2021-11-04 04:22:20 | Cuyahoga, Ohio, US | |
2043891 | 2043891 | 2021-10-18 | Kyrgyzstan | 179913 | 2636 | 0 | 41.20438 | 74.766098 | 2021-10-19 04:20:54 | Kyrgyzstan | ||||
2459091 | 2459091 | 2021-10-06 | Spain | Galicia | 186707 | 2636 | 0 | 42.5751 | -8.1339 | 2021-10-07 04:21:36 | Galicia, Spain | |||
3832785 | 3832785 | 2021-10-05 | Spain | Galicia | 186673 | 2636 | 0 | 42.5751 | -8.1339 | 2021-10-06 04:21:33 | Galicia, Spain | |||
987278 | 987278 | 2021-10-04 | Spain | Galicia | 186639 | 2636 | 0 | 42.5751 | -8.1339 | 2021-10-05 04:21:27 | Galicia, Spain | |||
3011596 | 3011596 | 2021-09-22 | Russia | Volgograd Oblast | 89294 | 2636 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-23 04:21:43 | Volgograd Oblast, Russia | |||
3892164 | 3892164 | 2021-08-29 | Russia | Novosibirsk Oblast | 58159 | 2636 | 0 | 54.9720169 | 79.48139240000002 | 2021-08-30 04:21:23 | Novosibirsk Oblast, Russia | |||
3706252 | 3706252 | 2021-07-17 | Netherlands | Noord-Holland | 304475 | 2636 | 0 | 301083 | 52.60090600000001 | 4.918688 | 2021-07-18 04:22:07 | Noord-Holland, Netherlands | ||
2947483 | 2947483 | 2021-07-16 | Netherlands | Noord-Holland | 302081 | 2636 | 0 | 298715 | 52.60090600000001 | 4.918688 | 2021-07-17 04:22:22 | Noord-Holland, Netherlands | ||
3659430 | 3659430 | 2021-07-11 | Colombia | Bolivar | 141275 | 2636 | 135899 | 2740 | 8.6704 | -74.03 | 2021-07-12 04:21:34 | Bolivar, Colombia | ||
625714 | 625714 | 2021-07-10 | Colombia | Bolivar | 140876 | 2636 | 135899 | 2341 | 8.6704 | -74.03 | 2021-07-11 04:21:43 | Bolivar, Colombia | ||
829433 | 829433 | 2021-07-09 | Colombia | Bolivar | 140494 | 2636 | 134160 | 3698 | 8.6704 | -74.03 | 2021-07-10 04:21:25 | Bolivar, Colombia | ||
2295650 | 2295650 | 2021-06-24 | Russia | Irkutsk Oblast | 72800 | 2636 | 68846 | 1318 | 56.6370122 | 104.719221 | 2021-06-25 04:21:33 | Irkutsk Oblast, Russia | ||
3702325 | 3702325 | 2021-04-27 | Russia | Krasnodar Krai | 45183 | 2636 | 39776 | 2771 | 45.7684014 | 39.0261044 | 2021-04-28 04:20:32 | Krasnodar Krai, Russia | ||
1571178 | 1571178 | 2021-04-22 | US | Texas | El Paso | 48141 | 112756 | 2636 | 0 | 31.76980765 | -106.2363275 | 2021-04-23 04:20:52 | El Paso, Texas, US | |
927824 | 927824 | 2020-12-21 | Netherlands | Zuid-Holland | 184892 | 2636 | 0 | 181368 | 51.937835 | 4.462114 | 2020-12-22 05:22:33 | Zuid-Holland, Netherlands | ||
2291552 | 2291552 | 2020-10-12 | Morocco | 153761 | 2636 | 129498 | 21627 | 31.7917 | -7.0926 | 2020-10-13 04:24:02 | Morocco | |||
1523091 | 1523091 | 2020-08-28 | Germany | Bayern | 56639 | 2636 | 50250 | 3878 | 48.7904 | 11.4979 | 2020-08-29 04:28:19 | Bayern, Germany | ||
753318 | 753318 | 2020-08-01 | Mexico | Baja California | 13594 | 2636 | 10218 | 740 | 30.8406 | -115.2838 | 2020-08-02 04:34:47 | Baja California, Mexico |
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]);