johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where deaths = 3152 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
422786 | 422786 | 2022-09-18 | US | Washington | King | 53033 | 511939 | 3152 | 0 | 47.49137892 | -121.8346131 | 2022-09-19 04:21:49 | King, Washington, US | |
3376810 | 3376810 | 2022-09-17 | US | Washington | King | 53033 | 511939 | 3152 | 0 | 47.49137892 | -121.8346131 | 2022-09-18 04:22:50 | King, Washington, US | |
2358918 | 2358918 | 2022-09-16 | US | Washington | King | 53033 | 511939 | 3152 | 0 | 47.49137892 | -121.8346131 | 2022-09-17 04:20:19 | King, Washington, US | |
2355531 | 2355531 | 2022-09-16 | Malaysia | Sabah | 392752 | 3152 | 0 | 5.9788 | 116.0753 | 2022-09-17 04:20:19 | Sabah, Malaysia | |||
3774110 | 3774110 | 2022-08-30 | Russia | Ivanovo Oblast | 115308 | 3152 | 0 | 56.9167446 | 41.4352137 | 2022-08-31 04:20:57 | Ivanovo Oblast, Russia | |||
1680706 | 1680706 | 2022-08-29 | Russia | Ivanovo Oblast | 115149 | 3152 | 0 | 56.9167446 | 41.4352137 | 2022-08-30 04:21:03 | Ivanovo Oblast, Russia | |||
1877190 | 1877190 | 2022-08-28 | Russia | Ivanovo Oblast | 115001 | 3152 | 0 | 56.9167446 | 41.4352137 | 2022-08-29 04:21:06 | Ivanovo Oblast, Russia | |||
2096317 | 2096317 | 2022-08-27 | Russia | Ivanovo Oblast | 114866 | 3152 | 0 | 56.9167446 | 41.4352137 | 2022-08-28 04:21:02 | Ivanovo Oblast, Russia | |||
1532132 | 1532132 | 2022-08-26 | Russia | Ivanovo Oblast | 114737 | 3152 | 0 | 56.9167446 | 41.4352137 | 2022-08-27 04:20:57 | Ivanovo Oblast, Russia | |||
2829019 | 2829019 | 2022-08-25 | Russia | Ivanovo Oblast | 114621 | 3152 | 0 | 56.9167446 | 41.4352137 | 2022-08-26 04:21:02 | Ivanovo Oblast, Russia | |||
2323552 | 2323552 | 2022-08-24 | Russia | Ivanovo Oblast | 114512 | 3152 | 0 | 56.9167446 | 41.4352137 | 2022-08-25 04:21:13 | Ivanovo Oblast, Russia | |||
1250961 | 1250961 | 2022-08-23 | Russia | Ivanovo Oblast | 114409 | 3152 | 0 | 56.9167446 | 41.4352137 | 2022-08-24 04:20:46 | Ivanovo Oblast, Russia | |||
2669776 | 2669776 | 2022-04-15 | Italy | Abruzzo | 343733 | 3152 | 0 | 42.35122196 | 13.39843823 | 2022-04-16 04:20:48 | Abruzzo, Italy | |||
2477581 | 2477581 | 2022-02-03 | Ukraine | Chernivtsi Oblast | 137551 | 3152 | 0 | 48.2917 | 25.9352 | 2022-02-04 04:21:10 | Chernivtsi Oblast, Ukraine | |||
3425077 | 3425077 | 2022-01-21 | Netherlands | Noord-Holland | 659348 | 3152 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-01-22 04:21:13 | Noord-Holland, Netherlands | |||
1432652 | 1432652 | 2021-12-28 | Mexico | Durango | 50743 | 3152 | 0 | 24.5593 | -104.6588 | 2021-12-29 03:21:43 | Durango, Mexico | |||
730613 | 730613 | 2021-12-27 | Mexico | Durango | 50729 | 3152 | 0 | 24.5593 | -104.6588 | 2021-12-28 04:21:47 | Durango, Mexico | |||
2111785 | 2111785 | 2021-12-26 | Mexico | Durango | 50722 | 3152 | 0 | 24.5593 | -104.6588 | 2021-12-27 04:21:58 | Durango, Mexico | |||
3605157 | 3605157 | 2021-12-25 | Mexico | Durango | 50722 | 3152 | 0 | 24.5593 | -104.6588 | 2021-12-26 04:21:50 | Durango, Mexico | |||
3495861 | 3495861 | 2021-12-15 | Albania | 204627 | 3152 | 0 | 41.1533 | 20.1683 | 2021-12-16 04:22:11 | Albania | ||||
1144900 | 1144900 | 2021-12-01 | Italy | Marche | 124334 | 3152 | 0 | 43.61675973 | 13.5188753 | 2021-12-02 04:22:37 | Marche, Italy | |||
3401412 | 3401412 | 2021-11-30 | Italy | Marche | 123859 | 3152 | 0 | 43.61675973 | 13.5188753 | 2021-12-01 04:22:29 | Marche, Italy | |||
87385 | 87385 | 2021-11-09 | Russia | Ulyanovsk Oblast | 100741 | 3152 | 0 | 54.146317700000004 | 47.2324921 | 2021-11-10 04:21:38 | Ulyanovsk Oblast, Russia | |||
276208 | 276208 | 2021-11-03 | Japan | Tokyo | 381707 | 3152 | 0 | 35.711343 | 139.446921 | 2021-11-04 04:22:20 | Tokyo, Japan | |||
2045453 | 2045453 | 2021-10-18 | US | Massachusetts | Middlesex | 25017 | 156655 | 3152 | 0 | 42.48607732 | -71.39049229 | 2021-10-19 04:20:54 | Middlesex, Massachusetts, US | |
1491729 | 1491729 | 2021-10-12 | Netherlands | Noord-Brabant | 314958 | 3152 | 0 | 51.561174 | 5.1849419999999995 | 2021-10-13 04:20:51 | Noord-Brabant, Netherlands | |||
710056 | 710056 | 2021-09-29 | Uganda | 123445 | 3152 | 0 | 1.373333 | 32.290275 | 2021-09-30 04:21:20 | Uganda | ||||
601558 | 601558 | 2021-09-23 | El Salvador | 102024 | 3152 | 0 | 13.7942 | -88.8965 | 2021-09-24 04:21:44 | El Salvador | ||||
515356 | 515356 | 2021-08-19 | United Kingdom | Northern Ireland | 181775 | 3152 | 0 | 54.7877 | -6.4923 | 2021-08-20 04:21:33 | Northern Ireland, United Kingdom | |||
3468122 | 3468122 | 2021-08-03 | India | Goa | 171396 | 3152 | 167245 | 999 | 15.359682 | 74.057396 | 2021-08-04 04:21:25 | Goa, India | ||
3970765 | 3970765 | 2021-06-11 | Russia | Krasnodar Krai | 49495 | 3152 | 44321 | 2022 | 45.7684014 | 39.0261044 | 2021-06-12 04:22:22 | Krasnodar Krai, Russia | ||
522919 | 522919 | 2021-06-09 | Libya | 188157 | 3152 | 173877 | 11128 | 26.3351 | 17.228331 | 2021-06-10 04:23:17 | Libya | |||
3393622 | 3393622 | 2021-04-28 | Russia | Nizhny Novgorod Oblast | 113622 | 3152 | 108896 | 1574 | 55.47180329999999 | 44.0911594 | 2021-04-29 04:20:55 | Nizhny Novgorod Oblast, Russia | ||
982638 | 982638 | 2021-04-17 | Algeria | 119486 | 3152 | 83286 | 33048 | 28.0339 | 1.6596 | 2021-04-18 04:20:41 | Algeria | |||
3643768 | 3643768 | 2021-03-30 | Russia | Krasnoyarsk Krai | 66662 | 3152 | 61699 | 1811 | 63.3233807 | 97.0979974 | 2021-03-31 04:26:25 | Krasnoyarsk Krai, Russia | ||
2183732 | 2183732 | 2021-02-26 | Paraguay | 157603 | 3152 | 131461 | 22990 | -23.4425 | -58.4438 | 2021-02-27 05:22:28 | Paraguay | |||
1338559 | 1338559 | 2021-02-15 | Spain | Aragon | 104237 | 3152 | 3772 | 97313 | 41.5976 | -0.9057 | 2021-02-16 05:24:38 | Aragon, Spain | ||
2283285 | 2283285 | 2021-02-14 | Colombia | Santander | 88152 | 3152 | 82209 | 2791 | 6.6437 | -73.6536 | 2021-02-15 05:24:49 | Santander, Colombia | ||
2677921 | 2677921 | 2021-02-13 | Mexico | Queretaro | 52715 | 3152 | 0 | 49563 | 20.5888 | -100.3899 | 2021-02-14 05:23:43 | Queretaro, Mexico | ||
3303970 | 3303970 | 2020-11-02 | Canada | Ontario | 80261 | 3152 | 69403 | 7962 | 51.2538 | -85.3232 | 2020-11-03 06:00:16 | Ontario, Canada |
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]);