johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where deaths = 2602 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
868698 | 868698 | 2022-12-11 | Germany | Mecklenburg-Vorpommern | 682175 | 2602 | 0 | 53.6127 | 12.4296 | 2022-12-12 04:21:01 | Mecklenburg-Vorpommern, Germany | |||
257228 | 257228 | 2022-12-10 | Germany | Mecklenburg-Vorpommern | 682175 | 2602 | 0 | 53.6127 | 12.4296 | 2022-12-11 04:20:50 | Mecklenburg-Vorpommern, Germany | |||
3935942 | 3935942 | 2022-12-09 | Germany | Mecklenburg-Vorpommern | 682175 | 2602 | 0 | 53.6127 | 12.4296 | 2022-12-10 04:21:02 | Mecklenburg-Vorpommern, Germany | |||
1964593 | 1964593 | 2022-11-30 | Japan | Saitama | 1368090 | 2602 | 0 | 35.997101 | 139.347635 | 2022-12-01 04:21:03 | Saitama, Japan | |||
1470565 | 1470565 | 2022-03-24 | US | Ohio | Franklin | 39049 | 287926 | 2602 | 0 | 39.96995815 | -83.01115755 | 2022-03-25 04:20:46 | Franklin, Ohio, US | |
338171 | 338171 | 2022-03-18 | US | New York | Erie | 36029 | 206954 | 2602 | 0 | 42.76249024 | -78.73063652 | 2022-03-19 04:20:47 | Erie, New York, US | |
1547657 | 1547657 | 2022-03-07 | Australia | Victoria | 1091012 | 2602 | 0 | -37.8136 | 144.9631 | 2022-03-08 04:20:54 | Victoria, Australia | |||
3855886 | 3855886 | 2022-02-18 | Malawi | 85179 | 2602 | 0 | -13.2543 | 34.3015 | 2022-02-19 04:21:11 | Malawi | ||||
463005 | 463005 | 2022-02-02 | Ukraine | Chernihiv Oblast | 105446 | 2602 | 0 | 51.4982 | 31.2893 | 2022-02-03 04:21:21 | Chernihiv Oblast, Ukraine | |||
459629 | 459629 | 2022-02-02 | Russia | Smolensk Oblast | 92279 | 2602 | 0 | 55.03434960000001 | 33.0192065 | 2022-02-03 04:21:21 | Smolensk Oblast, Russia | |||
1779214 | 1779214 | 2022-01-27 | Colombia | Cesar | 101398 | 2602 | 0 | 9.3373 | -73.6536 | 2022-01-28 04:21:09 | Cesar, Colombia | |||
1692442 | 1692442 | 2022-01-10 | Netherlands | Gelderland | 381988 | 2602 | 0 | 52.061738 | 5.939114 | 2022-01-11 04:22:01 | Gelderland, Netherlands | |||
786023 | 786023 | 2021-12-13 | Ukraine | Kherson Oblast | 77744 | 2602 | 0 | 46.6354 | 32.6169 | 2021-12-14 04:22:38 | Kherson Oblast, Ukraine | |||
404256 | 404256 | 2021-12-07 | Italy | Abruzzo | 89384 | 2602 | 0 | 42.35122196 | 13.39843823 | 2021-12-08 04:22:46 | Abruzzo, Italy | |||
1358404 | 1358404 | 2021-11-27 | Malaysia | W.P. Kuala Lumpur | 202090 | 2602 | 0 | 3.139 | 101.6869 | 2021-11-28 04:22:43 | W.P. Kuala Lumpur, Malaysia | |||
2721261 | 2721261 | 2021-10-30 | Russia | Udmurt Republic | 63342 | 2602 | 0 | 57.1961165 | 52.69598320000001 | 2021-10-31 04:22:08 | Udmurt Republic, Russia | |||
1239293 | 1239293 | 2021-09-27 | Ukraine | Zaporizhia Oblast | 111786 | 2602 | 0 | 47.8388 | 35.1396 | 2021-09-28 04:21:28 | Zaporizhia Oblast, Ukraine | |||
1235686 | 1235686 | 2021-09-27 | Kyrgyzstan | 178317 | 2602 | 0 | 41.20438 | 74.766098 | 2021-09-28 04:21:28 | Kyrgyzstan | ||||
3011788 | 3011788 | 2021-09-22 | US | Arizona | Pima | 4019 | 133119 | 2602 | 0 | 32.0971334 | -111.7890033 | 2021-09-23 04:21:43 | Pima, Arizona, US | |
3448901 | 3448901 | 2021-09-10 | Latvia | 146381 | 2602 | 0 | 56.8796 | 24.6032 | 2021-09-11 04:21:30 | Latvia | ||||
1853777 | 1853777 | 2021-08-20 | Chile | Biobio | 149810 | 2602 | 0 | -37.4464 | -72.1416 | 2021-08-21 04:21:38 | Biobio, Chile | |||
3358869 | 3358869 | 2021-06-21 | Russia | Irkutsk Oblast | 72324 | 2602 | 68697 | 1025 | 56.6370122 | 104.719221 | 2021-06-22 04:21:34 | Irkutsk Oblast, Russia | ||
1708473 | 1708473 | 2021-06-02 | Peru | Junin | 72318 | 2602 | 0 | 69716 | -11.541783 | -74.876968 | 2021-06-03 04:23:32 | Junin, Peru | ||
3113194 | 3113194 | 2021-05-06 | Belarus | 364951 | 2602 | 355531 | 6818 | 53.7098 | 27.9534 | 2021-05-07 04:20:40 | Belarus | |||
39502 | 39502 | 2021-04-12 | US | Texas | El Paso | 48141 | 111178 | 2602 | 0 | 31.76980765 | -106.2363275 | 2021-04-13 04:20:37 | El Paso, Texas, US | |
3886661 | 3886661 | 2021-04-11 | US | Texas | El Paso | 48141 | 111002 | 2602 | 0 | 31.76980765 | -106.2363275 | 2021-04-12 04:21:00 | El Paso, Texas, US | |
1219629 | 1219629 | 2021-03-27 | Libya | 156116 | 2602 | 143697 | 9817 | 26.3351 | 17.228331 | 2021-03-28 05:28:10 | Libya | |||
1881047 | 1881047 | 2021-03-26 | Libya | 156116 | 2602 | 143697 | 9817 | 26.3351 | 17.228331 | 2021-03-27 05:25:04 | Libya | |||
1799357 | 1799357 | 2021-03-23 | US | Florida | Palm Beach | 12099 | 128620 | 2602 | 0 | 26.64676272 | -80.46536002 | 2021-03-24 05:25:40 | Palm Beach, Florida, US | |
3452746 | 3452746 | 2021-03-18 | Ethiopia | 181869 | 2602 | 145349 | 33918 | 9.145 | 40.4897 | 2021-03-19 05:26:09 | Ethiopia | |||
283807 | 283807 | 2021-02-24 | Ukraine | Kiev | 135676 | 2602 | 92498 | 40576 | 50.4501 | 30.5234 | 2021-02-25 05:24:57 | Kiev, Ukraine | ||
2678041 | 2678041 | 2021-02-13 | Russia | Krasnoyarsk Krai | 59893 | 2602 | 55000 | 2291 | 63.3233807 | 97.0979974 | 2021-02-14 05:23:43 | Krasnoyarsk Krai, Russia | ||
3515133 | 3515133 | 2021-01-15 | Brazil | Alagoas | 110572 | 2602 | 104789 | 3181 | -9.5713 | -36.782 | 2021-01-16 05:22:40 | Alagoas, Brazil | ||
1600204 | 1600204 | 2020-12-10 | Italy | Liguria | 54684 | 2602 | 43124 | 8958 | 44.41149315 | 8.9326992 | 2020-12-11 05:26:59 | Liguria, Italy | ||
2498300 | 2498300 | 2020-11-03 | Spain | Andalusia | 149816 | 2602 | 10671 | 136543 | 37.5443 | -4.7278 | 2020-11-04 05:25:09 | Andalusia, Spain |
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]);