johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where deaths = 3022 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3026275 | 3026275 | 2022-11-17 | Japan | Aichi | 1485602 | 3022 | 0 | 35.035551 | 137.211621 | 2022-11-18 04:21:15 | Aichi, Japan | |||
396229 | 396229 | 2022-10-07 | Italy | Calabria | 563877 | 3022 | 0 | 38.90597598 | 16.59440194 | 2022-10-08 04:22:56 | Calabria, Italy | |||
900355 | 900355 | 2022-07-22 | Russia | Astrakhan Oblast | 119020 | 3022 | 0 | 47.1878186 | 47.608851 | 2022-07-23 04:20:53 | Astrakhan Oblast, Russia | |||
670491 | 670491 | 2022-07-21 | Russia | Astrakhan Oblast | 118943 | 3022 | 0 | 47.1878186 | 47.608851 | 2022-07-22 04:21:15 | Astrakhan Oblast, Russia | |||
3430080 | 3430080 | 2022-07-14 | US | Indiana | Marion | 18097 | 238386 | 3022 | 0 | 39.78163624 | -86.13826325 | 2022-07-15 04:20:53 | Marion, Indiana, US | |
3110600 | 3110600 | 2022-07-13 | US | Indiana | Marion | 18097 | 238386 | 3022 | 0 | 39.78163624 | -86.13826325 | 2022-07-14 04:20:57 | Marion, Indiana, US | |
1184941 | 1184941 | 2022-05-18 | Russia | Buryatia Republic | 136377 | 3022 | 0 | 52.7182426 | 109.492143 | 2022-05-19 04:20:54 | Buryatia Republic, Russia | |||
1184426 | 1184426 | 2022-05-18 | Australia | New South Wales | 2481957 | 3022 | 0 | -33.8688 | 151.2093 | 2022-05-19 04:20:54 | New South Wales, Australia | |||
3582838 | 3582838 | 2022-05-17 | Russia | Buryatia Republic | 136356 | 3022 | 0 | 52.7182426 | 109.492143 | 2022-05-18 04:20:50 | Buryatia Republic, Russia | |||
3350856 | 3350856 | 2022-04-01 | Russia | Ivanovo Oblast | 107594 | 3022 | 0 | 56.9167446 | 41.43521370000001 | 2022-04-02 04:20:47 | Ivanovo Oblast, Russia | |||
2446518 | 2446518 | 2022-02-22 | Cambodia | 127575 | 3022 | 0 | 11.55 | 104.9167 | 2022-02-23 04:21:09 | Cambodia | ||||
2331008 | 2331008 | 2022-02-04 | Ukraine | Sumy Oblast | 159056 | 3022 | 0 | 50.9077 | 34.7981 | 2022-02-05 04:21:05 | Sumy Oblast, Ukraine | |||
1432643 | 1432643 | 2021-12-28 | Mexico | Aguascalientes | 38661 | 3022 | 0 | 21.8853 | -102.2916 | 2021-12-29 03:21:43 | Aguascalientes, Mexico | |||
730604 | 730604 | 2021-12-27 | Mexico | Aguascalientes | 38658 | 3022 | 0 | 21.8853 | -102.2916 | 2021-12-28 04:21:47 | Aguascalientes, Mexico | |||
2111839 | 2111839 | 2021-12-26 | Nigeria | 237561 | 3022 | 0 | 9.082 | 8.6753 | 2021-12-27 04:21:58 | Nigeria | ||||
2111776 | 2111776 | 2021-12-26 | Mexico | Aguascalientes | 38657 | 3022 | 0 | 21.8853 | -102.2916 | 2021-12-27 04:21:58 | Aguascalientes, Mexico | |||
3605148 | 3605148 | 2021-12-25 | Mexico | Aguascalientes | 38657 | 3022 | 0 | 21.8853 | -102.2916 | 2021-12-26 04:21:50 | Aguascalientes, Mexico | |||
2907346 | 2907346 | 2021-12-19 | Ukraine | Ivano-Frankivsk Oblast | 125588 | 3022 | 0 | 48.9226 | 24.7111 | 2021-12-20 04:21:43 | Ivano-Frankivsk Oblast, Ukraine | |||
1716811 | 1716811 | 2021-12-16 | US | Arizona | Pima | 4019 | 166791 | 3022 | 0 | 32.0971334 | -111.7890033 | 2021-12-17 04:22:14 | Pima, Arizona, US | |
3496645 | 3496645 | 2021-12-15 | US | Arizona | Pima | 4019 | 166437 | 3022 | 0 | 32.0971334 | -111.7890033 | 2021-12-16 04:22:11 | Pima, Arizona, US | |
1078977 | 1078977 | 2021-12-09 | US | Illinois | Unassigned | 90017 | 96 | 3022 | 0 | 42.36542373 | 0.0 | 2021-12-10 04:22:28 | Unassigned, Illinois, US | |
3288587 | 3288587 | 2021-11-18 | Albania | 195021 | 3022 | 0 | 41.1533 | 20.1683 | 2021-11-19 04:21:40 | Albania | ||||
934817 | 934817 | 2021-10-16 | Japan | Osaka | 201684 | 3022 | 0 | 34.620965000000005 | 135.507481 | 2021-10-17 04:21:29 | Osaka, Japan | |||
1491439 | 1491439 | 2021-10-12 | Colombia | Narino | 89663 | 3022 | 0 | 1.2892 | -77.3579 | 2021-10-13 04:20:51 | Narino, Colombia | |||
3007172 | 3007172 | 2021-10-11 | Colombia | Narino | 89656 | 3022 | 0 | 1.2892 | -77.3579 | 2021-10-12 04:21:09 | Narino, Colombia | |||
1884884 | 1884884 | 2021-09-12 | El Salvador | 98122 | 3022 | 0 | 13.7942 | -88.8965 | 2021-09-13 04:21:15 | El Salvador | ||||
593264 | 593264 | 2021-08-08 | Ukraine | Odessa Oblast | 142450 | 3022 | 0 | 46.4846 | 30.7326 | 2021-08-09 04:21:24 | Odessa Oblast, Ukraine | |||
2951027 | 2951027 | 2021-07-16 | Zambia | 183344 | 3022 | 168052 | 12270 | -13.133897 | 27.849332 | 2021-07-17 04:22:22 | Zambia | |||
3127673 | 3127673 | 2021-06-28 | US | New Jersey | Essex | 34013 | 94494 | 3022 | 0 | 40.78681335 | -74.24657979 | 2021-06-29 04:21:28 | Essex, New Jersey, US | |
2592168 | 2592168 | 2021-06-27 | US | New Jersey | Essex | 34013 | 94482 | 3022 | 0 | 40.78681335 | -74.24657979 | 2021-06-28 04:21:29 | Essex, New Jersey, US | |
2295395 | 2295395 | 2021-06-24 | India | Goa | 165426 | 3022 | 159677 | 2727 | 15.359682 | 74.057396 | 2021-06-25 04:21:33 | Goa, India | ||
3145568 | 3145568 | 2021-06-07 | Italy | Marche | 103140 | 3022 | 96748 | 3370 | 43.61675973 | 13.5188753 | 2021-06-08 04:22:35 | Marche, Italy | ||
2410969 | 2410969 | 2021-04-19 | Netherlands | Noord-Brabant | 222421 | 3022 | 0 | 220938 | 51.561174 | 5.184942 | 2021-04-20 04:20:41 | Noord-Brabant, Netherlands | ||
1980525 | 1980525 | 2021-03-25 | Germany | Berlin | 140996 | 3022 | 131396 | 7592 | 52.52 | 13.405 | 2021-03-26 05:26:55 | Berlin, Germany | ||
3962613 | 3962613 | 2021-03-10 | Mexico | Oaxaca | 41969 | 3022 | 0 | 38947 | 17.0732 | -96.7266 | 2021-03-11 05:25:48 | Oaxaca, Mexico | ||
3663297 | 3663297 | 2021-03-09 | Algeria | 114543 | 3022 | 79319 | 32202 | 28.0339 | 1.6596 | 2021-03-10 05:24:35 | Algeria | |||
744576 | 744576 | 2021-02-20 | US | New York | Suffolk | 36103 | 157516 | 3022 | 0 | 154494 | 40.88320119 | -72.8012172 | 2021-02-21 05:24:33 | Suffolk, New York, US |
1676418 | 1676418 | 2021-02-01 | India | Haryana | 267989 | 3022 | 263886 | 1081 | 29.20004 | 76.332824 | 2021-02-02 05:22:49 | Haryana, India | ||
2466711 | 2466711 | 2021-01-22 | Georgia | 251974 | 3022 | 238737 | 10215 | 42.3154 | 43.3569 | 2021-01-23 05:22:03 | Georgia | |||
236946 | 236946 | 2021-01-18 | Azerbaijan | 227391 | 3022 | 215771 | 8598 | 40.1431 | 47.5769 | 2021-01-19 05:22:15 | Azerbaijan | |||
190346 | 190346 | 2021-01-11 | Slovenia | 139713 | 3022 | 112371 | 24320 | 46.1512 | 14.9955 | 2021-01-12 05:22:15 | Slovenia | |||
2347331 | 2347331 | 2020-12-07 | Germany | Baden-Wurttemberg | 166641 | 3022 | 122484 | 42683 | 48.6616 | 9.3501 | 2020-12-08 05:27:42 | Baden-Wurttemberg, Germany | ||
763992 | 763992 | 2020-10-18 | US | Michigan | Wayne | 26163 | 38146 | 3022 | 0 | 35124 | 42.28098405 | -83.281255 | 2020-10-19 04:24:16 | Wayne, Michigan, US |
1028030 | 1028030 | 2020-10-17 | US | Michigan | Wayne | 26163 | 38146 | 3022 | 0 | 35124 | 42.28098405 | -83.281255 | 2020-10-18 04:24:25 | Wayne, Michigan, US |
786153 | 786153 | 2020-10-15 | Canada | Ontario | 64396 | 3022 | 55921 | 5827 | 51.2538 | -85.3232 | 2020-10-16 04:24:01 | Ontario, Canada | ||
1121327 | 1121327 | 2020-09-17 | Brazil | Distrito Federal | 180844 | 3022 | 168653 | 9169 | -15.7998 | -47.8645 | 2020-09-18 05:05:00 | Distrito Federal, Brazil | ||
3531610 | 3531610 | 2020-08-12 | Peru | Lambayeque | 19165 | 3022 | 0 | 16143 | -6.353049 | -79.824113 | 2020-08-13 04:29:15 | Lambayeque, Peru | ||
2700565 | 2700565 | 2020-06-24 | Spain | Castilla - La Mancha | 17987 | 3022 | 6392 | 8573 | 39.2796 | -3.0977 | 2020-06-25 05:26:54 | Castilla - La Mancha, Spain | ||
1522250 | 1522250 | 2020-06-23 | Spain | Castilla - La Mancha | 17987 | 3022 | 6392 | 8573 | 39.2796 | -3.0977 | 2020-06-24 04:33:28 | Castilla - La Mancha, Spain | ||
1510444 | 1510444 | 2020-06-22 | Spain | Castilla - La Mancha | 17987 | 3022 | 6392 | 8573 | 39.2796 | -3.0977 | 2020-06-23 04:33:22 | Castilla - La Mancha, Spain | ||
3249183 | 3249183 | 2020-06-21 | Spain | Castilla - La Mancha | 17965 | 3022 | 6392 | 8551 | 39.2796 | -3.0977 | 2020-06-22 04:33:20 | Castilla - La Mancha, Spain | ||
2437776 | 2437776 | 2020-06-20 | Spain | Castilla - La Mancha | 17940 | 3022 | 6392 | 8526 | 39.2796 | -3.0977 | 2020-06-21 04:33:19 | Castilla - La Mancha, Spain | ||
1691354 | 1691354 | 2020-06-19 | Spain | Castilla - La Mancha | 17894 | 3022 | 6392 | 8480 | 39.2796 | -3.0977 | 2020-06-20 04:33:19 | Castilla - La Mancha, Spain | ||
2578250 | 2578250 | 2020-04-12 | Germany | 127854 | 3022 | 60300 | 64532 | 51.165691 | 10.451526 | 2020-04-12 23:17:00 | Germany |
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]);