johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
45 rows where deaths = 2972 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3312229 | 3312229 | 2022-11-23 | Japan | Hyogo | 1090431 | 2972 | 0 | 35.039913 | 134.828057 | 2022-11-24 04:21:09 | Hyogo, Japan | |||
3824419 | 3824419 | 2022-09-10 | Italy | Calabria | 546184 | 2972 | 0 | 38.90597598 | 16.59440194 | 2022-09-11 04:20:50 | Calabria, Italy | |||
962876 | 962876 | 2022-09-09 | Italy | Calabria | 545525 | 2972 | 0 | 38.90597598 | 16.59440194 | 2022-09-10 04:21:10 | Calabria, Italy | |||
1491034 | 1491034 | 2022-07-26 | US | Washington | King | 53033 | 487863 | 2972 | 0 | 47.49137892 | -121.8346131 | 2022-07-27 04:21:04 | King, Washington, US | |
2597480 | 2597480 | 2022-07-25 | US | Washington | King | 53033 | 487863 | 2972 | 0 | 47.49137892 | -121.8346131 | 2022-07-26 04:20:58 | King, Washington, US | |
670590 | 670590 | 2022-07-21 | Spain | Asturias | 250842 | 2972 | 0 | 43.3614 | -5.8593 | 2022-07-22 04:21:15 | Asturias, Spain | |||
1608553 | 1608553 | 2022-07-20 | Spain | Asturias | 250842 | 2972 | 0 | 43.3614 | -5.8593 | 2022-07-21 04:21:10 | Asturias, Spain | |||
959186 | 959186 | 2022-07-19 | Spain | Asturias | 250842 | 2972 | 0 | 43.3614 | -5.8593 | 2022-07-20 04:20:59 | Asturias, Spain | |||
2598032 | 2598032 | 2022-05-05 | Jamaica | 130596 | 2972 | 0 | 18.1096 | -77.2975 | 2022-05-06 04:21:00 | Jamaica | ||||
1576343 | 1576343 | 2022-04-10 | Russia | Astrakhan Oblast | 115310 | 2972 | 0 | 47.1878186 | 47.608851 | 2022-04-11 04:21:02 | Astrakhan Oblast, Russia | |||
2801026 | 2801026 | 2022-04-06 | Russia | Smolensk Oblast | 128241 | 2972 | 0 | 55.03434960000001 | 33.0192065 | 2022-04-07 04:20:53 | Smolensk Oblast, Russia | |||
1656613 | 1656613 | 2022-03-19 | Russia | Ivanovo Oblast | 105523 | 2972 | 0 | 56.9167446 | 41.43521370000001 | 2022-03-20 04:20:45 | Ivanovo Oblast, Russia | |||
950906 | 950906 | 2022-03-12 | Kyrgyzstan | 200720 | 2972 | 0 | 41.20438 | 74.766098 | 2022-03-13 04:20:49 | Kyrgyzstan | ||||
2525328 | 2525328 | 2022-03-02 | Italy | Abruzzo | 265841 | 2972 | 0 | 42.35122196 | 13.39843823 | 2022-03-03 04:21:01 | Abruzzo, Italy | |||
3856077 | 3856077 | 2022-02-18 | Russia | Ryazan Oblast | 91013 | 2972 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-19 04:21:11 | Ryazan Oblast, Russia | |||
3672318 | 3672318 | 2022-02-15 | US | Connecticut | Hartford | 9003 | 172975 | 2972 | 0 | 41.80283011 | -72.73103891 | 2022-02-16 04:21:10 | Hartford, Connecticut, US | |
1463855 | 1463855 | 2022-02-10 | Chile | Biobio | 216861 | 2972 | 0 | -37.4464 | -72.1416 | 2022-02-11 04:21:09 | Biobio, Chile | |||
802056 | 802056 | 2021-12-22 | Ukraine | Chernivtsi Oblast | 118530 | 2972 | 0 | 48.2917 | 25.9352 | 2021-12-23 04:21:21 | Chernivtsi Oblast, Ukraine | |||
3656050 | 3656050 | 2021-12-10 | US | Arizona | Pima | 4019 | 164693 | 2972 | 0 | 32.0971334 | -111.7890033 | 2021-12-11 04:22:45 | Pima, Arizona, US | |
550635 | 550635 | 2021-12-08 | Denmark | 529210 | 2972 | 0 | 56.2639 | 9.5018 | 2021-12-09 04:22:49 | Denmark | ||||
404551 | 404551 | 2021-12-07 | Russia | Tyumen Oblast | 83045 | 2972 | 0 | 58.8206488 | 70.36588370000001 | 2021-12-08 04:22:46 | Tyumen Oblast, Russia | |||
633744 | 633744 | 2021-10-13 | Colombia | Bolivar | 156975 | 2972 | 0 | 8.6704 | -74.03 | 2021-10-14 04:21:29 | Bolivar, Colombia | |||
1491640 | 1491640 | 2021-10-12 | Kosovo | 160435 | 2972 | 0 | 42.602636 | 20.902977 | 2021-10-13 04:20:51 | Kosovo | ||||
3009499 | 3009499 | 2021-10-11 | US | New Jersey | Bergen | 34003 | 117928 | 2972 | 0 | 40.96010917 | -74.07164325 | 2021-10-12 04:21:09 | Bergen, New Jersey, US | |
3007373 | 3007373 | 2021-10-11 | Kosovo | 160400 | 2972 | 0 | 42.602636 | 20.902977 | 2021-10-12 04:21:09 | Kosovo | ||||
2279333 | 2279333 | 2021-09-08 | Peru | San Martin | 48239 | 2972 | 0 | -7.039531 | -76.729127 | 2021-09-09 04:21:27 | San Martin, Peru | |||
642112 | 642112 | 2021-09-07 | Peru | San Martin | 48239 | 2972 | 0 | -7.039531 | -76.729127 | 2021-09-08 04:21:31 | San Martin, Peru | |||
3194175 | 3194175 | 2021-09-06 | Peru | San Martin | 48226 | 2972 | 0 | -7.039531 | -76.729127 | 2021-09-07 04:21:35 | San Martin, Peru | |||
3281043 | 3281043 | 2021-09-05 | Peru | San Martin | 48226 | 2972 | 0 | -7.039531 | -76.729127 | 2021-09-06 04:21:22 | San Martin, Peru | |||
3057845 | 3057845 | 2021-05-13 | United Kingdom | Northern Ireland | 121323 | 2972 | 0 | 119174 | 54.7877 | -6.4923 | 2021-05-14 04:20:41 | Northern Ireland, United Kingdom | ||
3117145 | 3117145 | 2021-05-06 | Uruguay | 213449 | 2972 | 184506 | 25971 | -32.5228 | -55.7658 | 2021-05-07 04:20:40 | Uruguay | |||
3925607 | 3925607 | 2021-04-24 | US | Massachusetts | Middlesex | 25017 | 130965 | 2972 | 0 | 42.48607732 | -71.39049229 | 2021-04-25 04:20:32 | Middlesex, Massachusetts, US | |
1409198 | 1409198 | 2021-04-23 | Peru | Cajamarca | 48543 | 2972 | 0 | 45571 | -6.430284 | -78.74559599999998 | 2021-04-24 04:20:38 | Cajamarca, Peru | ||
3643678 | 3643678 | 2021-03-30 | Netherlands | Noord-Brabant | 197894 | 2972 | 0 | 196409 | 51.561174 | 5.184942 | 2021-03-31 04:26:25 | Noord-Brabant, Netherlands | ||
1732710 | 1732710 | 2021-03-14 | Russia | Krasnoyarsk Krai | 64614 | 2972 | 59807 | 1835 | 63.3233807 | 97.0979974 | 2021-03-15 05:25:51 | Krasnoyarsk Krai, Russia | ||
2637887 | 2637887 | 2021-02-11 | Peru | Loreto | 28021 | 2972 | 0 | 25049 | -4.124847 | -74.424115 | 2021-02-12 05:23:29 | Loreto, Peru | ||
613751 | 613751 | 2021-02-08 | Lithuania | 188925 | 2972 | 171280 | 12804 | 55.1694 | 23.8813 | 2021-02-09 05:23:30 | Lithuania | |||
340015 | 340015 | 2021-02-03 | Brazil | Mato Grosso do Sul | 163692 | 2972 | 151776 | 8269 | -20.7722 | -54.7852 | 2021-02-04 05:22:26 | Mato Grosso do Sul, Brazil | ||
3879523 | 3879523 | 2021-01-14 | India | Haryana | 265803 | 2972 | 260565 | 2266 | 29.20004 | 76.332824 | 2021-01-15 17:22 | Haryana, India | ||
79187 | 79187 | 2020-10-14 | Mexico | Tabasco | 33275 | 2972 | 29545 | 758 | 17.8409 | -92.6189 | 2020-10-15 04:24:28 | Tabasco, Mexico | ||
2602208 | 2602208 | 2020-10-10 | Poland | 121638 | 2972 | 78982 | 39684 | 51.9194 | 19.1451 | 2020-10-11 04:23:46 | Poland | |||
1822870 | 1822870 | 2020-10-04 | Mexico | Guanajuato | 41676 | 2972 | 37047 | 1657 | 21.019 | -101.2574 | 2020-10-05 04:23:33 | Guanajuato, Mexico | ||
2379867 | 2379867 | 2020-10-01 | Russia | Saint Petersburg | 43306 | 2972 | 29217 | 11117 | 59.9606739 | 30.158655100000004 | 2020-10-02 04:23:51 | Saint Petersburg, Russia | ||
344202 | 344202 | 2020-09-14 | Guatemala | 82172 | 2972 | 71352 | 7848 | 15.7835 | -90.2308 | 2020-09-15 03:22:50 | Guatemala | |||
1432153 | 1432153 | 2020-05-20 | Russia | 308705 | 2972 | 85392 | 220341 | 61.52401 | 105.318756 | 2020-05-21 02:32:48 | Russia |
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]);