johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
52 rows where deaths = 2982 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3551646 | 3551646 | 2022-11-27 | Japan | Hyogo | 1101896 | 2982 | 0 | 35.039913 | 134.828057 | 2022-11-28 04:21:02 | Hyogo, Japan | |||
480263 | 480263 | 2022-11-08 | US | Connecticut | New Haven | 9009 | 241261 | 2982 | 0 | 41.4080325 | -72.93620426 | 2022-11-09 04:21:22 | New Haven, Connecticut, US | |
431342 | 431342 | 2022-11-03 | Japan | Aichi | 1427668 | 2982 | 0 | 35.035551 | 137.211621 | 2022-11-04 04:22:11 | Aichi, Japan | |||
3109261 | 3109261 | 2022-07-13 | Chile | Maule | 266605 | 2982 | 0 | -35.5183 | -71.6885 | 2022-07-14 04:20:57 | Maule, Chile | |||
629684 | 629684 | 2022-07-12 | Chile | Maule | 266201 | 2982 | 0 | -35.5183 | -71.6885 | 2022-07-13 04:20:58 | Maule, Chile | |||
3722933 | 3722933 | 2022-04-25 | US | Florida | Polk | 12105 | 201296 | 2982 | 0 | 27.95027105 | -81.69732947 | 2022-04-26 04:20:51 | Polk, Florida, US | |
2029501 | 2029501 | 2022-04-24 | US | Florida | Polk | 12105 | 201296 | 2982 | 0 | 27.95027105 | -81.69732947 | 2022-04-25 04:20:56 | Polk, Florida, US | |
747076 | 747076 | 2022-04-23 | US | Florida | Polk | 12105 | 201296 | 2982 | 0 | 27.95027105 | -81.69732947 | 2022-04-24 04:20:56 | Polk, Florida, US | |
3437561 | 3437561 | 2022-04-22 | US | Florida | Polk | 12105 | 201296 | 2982 | 0 | 27.95027105 | -81.69732947 | 2022-04-23 04:20:50 | Polk, Florida, US | |
2893146 | 2893146 | 2022-04-21 | US | Florida | Polk | 12105 | 200495 | 2982 | 0 | 27.95027105 | -81.69732947 | 2022-04-22 04:20:45 | Polk, Florida, US | |
2308018 | 2308018 | 2022-04-20 | US | Florida | Polk | 12105 | 200495 | 2982 | 0 | 27.95027105 | -81.69732947 | 2022-04-21 04:20:46 | Polk, Florida, US | |
2307477 | 2307477 | 2022-04-20 | Russia | Astrakhan Oblast | 115709 | 2982 | 0 | 47.1878186 | 47.608851 | 2022-04-21 04:20:46 | Astrakhan Oblast, Russia | |||
2252157 | 2252157 | 2022-04-19 | US | Florida | Polk | 12105 | 200495 | 2982 | 0 | 27.95027105 | -81.69732947 | 2022-04-20 04:20:45 | Polk, Florida, US | |
3321354 | 3321354 | 2022-04-07 | US | Indiana | Marion | 18097 | 224862 | 2982 | 0 | 39.78163624 | -86.13826325 | 2022-04-08 04:20:48 | Marion, Indiana, US | |
2801890 | 2801890 | 2022-04-06 | US | Indiana | Marion | 18097 | 224862 | 2982 | 0 | 39.78163624 | -86.13826325 | 2022-04-07 04:20:53 | Marion, Indiana, US | |
1468141 | 1468141 | 2022-03-24 | Kyrgyzstan | 200847 | 2982 | 0 | 41.20438 | 74.766098 | 2022-03-25 04:20:46 | Kyrgyzstan | ||||
3022315 | 3022315 | 2022-03-23 | Kyrgyzstan | 200836 | 2982 | 0 | 41.20438 | 74.766098 | 2022-03-24 04:20:43 | Kyrgyzstan | ||||
3912685 | 3912685 | 2022-02-20 | US | Connecticut | Hartford | 9003 | 173583 | 2982 | 0 | 41.80283011 | -72.73103891 | 2022-02-21 04:21:05 | Hartford, Connecticut, US | |
3876243 | 3876243 | 2022-02-19 | US | Connecticut | Hartford | 9003 | 173583 | 2982 | 0 | 41.80283011 | -72.73103891 | 2022-02-20 04:21:00 | Hartford, Connecticut, US | |
3856499 | 3856499 | 2022-02-18 | US | Connecticut | Hartford | 9003 | 173583 | 2982 | 0 | 41.80283011 | -72.73103891 | 2022-02-19 04:21:11 | Hartford, Connecticut, US | |
233013 | 233013 | 2022-02-11 | Chile | Biobio | 220299 | 2982 | 0 | -37.4464 | -72.1416 | 2022-02-12 04:21:06 | Biobio, Chile | |||
2012936 | 2012936 | 2022-02-06 | Russia | Murmansk Oblast | 104455 | 2982 | 0 | 68.00004179999999 | 33.9999151 | 2022-02-07 04:21:05 | Murmansk Oblast, Russia | |||
3065643 | 3065643 | 2022-01-29 | Ukraine | Sumy Oblast | 149629 | 2982 | 0 | 50.9077 | 34.7981 | 2022-01-30 04:21:26 | Sumy Oblast, Ukraine | |||
3810266 | 3810266 | 2022-01-28 | Syria | 51230 | 2982 | 0 | 34.802075 | 38.99681500000001 | 2022-01-29 04:21:10 | Syria | ||||
3608698 | 3608698 | 2021-12-25 | Ukraine | Chernivtsi Oblast | 118872 | 2982 | 0 | 48.2917 | 25.9352 | 2021-12-26 04:21:50 | Chernivtsi Oblast, Ukraine | |||
1664187 | 1664187 | 2021-12-11 | Cambodia | 120343 | 2982 | 0 | 11.55 | 104.9167 | 2021-12-12 04:22:12 | Cambodia | ||||
153634 | 153634 | 2021-11-29 | Ukraine | Zhytomyr Oblast | 133221 | 2982 | 0 | 50.2547 | 28.6587 | 2021-11-30 04:22:53 | Zhytomyr Oblast, Ukraine | |||
1802849 | 1802849 | 2021-11-25 | Mexico | Tlaxcala | 29418 | 2982 | 0 | 19.3139 | -98.2404 | 2021-11-26 04:22:33 | Tlaxcala, Mexico | |||
3070288 | 3070288 | 2021-11-23 | Russia | Udmurt Republic | 72617 | 2982 | 0 | 57.1961165 | 52.69598320000001 | 2021-11-24 04:22:14 | Udmurt Republic, Russia | |||
3070067 | 3070067 | 2021-11-23 | Kosovo | 161031 | 2982 | 0 | 42.602636 | 20.902977 | 2021-11-24 04:22:14 | Kosovo | ||||
3749165 | 3749165 | 2021-11-22 | Kosovo | 161016 | 2982 | 0 | 42.602636 | 20.902977 | 2021-11-23 04:22:39 | Kosovo | ||||
1014372 | 1014372 | 2021-11-21 | Kosovo | 161006 | 2982 | 0 | 42.602636 | 20.902977 | 2021-11-22 04:22:20 | Kosovo | ||||
722536 | 722536 | 2021-11-20 | Kosovo | 160999 | 2982 | 0 | 42.602636 | 20.902977 | 2021-11-21 04:22:13 | Kosovo | ||||
3793715 | 3793715 | 2021-10-25 | Colombia | Bolivar | 157565 | 2982 | 0 | 8.6704 | -74.03 | 2021-10-26 04:22:09 | Bolivar, Colombia | |||
682161 | 682161 | 2021-10-24 | Colombia | Bolivar | 157521 | 2982 | 0 | 8.6704 | -74.03 | 2021-10-25 04:22:31 | Bolivar, Colombia | |||
770169 | 770169 | 2021-10-23 | Colombia | Bolivar | 157505 | 2982 | 0 | 8.6704 | -74.03 | 2021-10-24 04:21:22 | Bolivar, Colombia | |||
2125907 | 2125907 | 2021-10-21 | US | New Jersey | Bergen | 34003 | 118984 | 2982 | 0 | 40.96010917 | -74.07164325 | 2021-10-22 04:21:14 | Bergen, New Jersey, US | |
445519 | 445519 | 2021-10-20 | US | New Jersey | Bergen | 34003 | 118896 | 2982 | 0 | 40.96010917 | -74.07164325 | 2021-10-21 04:21:18 | Bergen, New Jersey, US | |
2899793 | 2899793 | 2021-08-12 | Mexico | Zacatecas | 35309 | 2982 | 0 | 22.7709 | -102.5832 | 2021-08-13 04:21:24 | Zacatecas, Mexico | |||
2295547 | 2295547 | 2021-06-24 | Mexico | Quintana Roo | 31461 | 2982 | 0 | 28479 | 19.1817 | -88.4791 | 2021-06-25 04:21:33 | Quintana Roo, Mexico | ||
3149236 | 3149236 | 2021-06-07 | United Kingdom | Northern Ireland | 123186 | 2982 | 0 | 121032 | 54.7877 | -6.4923 | 2021-06-08 04:22:35 | Northern Ireland, United Kingdom | ||
829238 | 829238 | 2021-06-06 | United Kingdom | Northern Ireland | 123132 | 2982 | 0 | 120978 | 54.7877 | -6.4923 | 2021-06-07 04:22:51 | Northern Ireland, United Kingdom | ||
2589643 | 2589643 | 2021-06-05 | United Kingdom | Northern Ireland | 123063 | 2982 | 0 | 120909 | 54.7877 | -6.4923 | 2021-06-06 04:24:03 | Northern Ireland, United Kingdom | ||
2318957 | 2318957 | 2021-06-04 | United Kingdom | Northern Ireland | 122968 | 2982 | 0 | 120814 | 54.7877 | -6.4923 | 2021-06-05 04:23:03 | Northern Ireland, United Kingdom | ||
1452242 | 1452242 | 2021-06-03 | United Kingdom | Northern Ireland | 122895 | 2982 | 0 | 120741 | 54.7877 | -6.4923 | 2021-06-04 04:23:37 | Northern Ireland, United Kingdom | ||
1711966 | 1711966 | 2021-06-02 | United Kingdom | Northern Ireland | 122815 | 2982 | 0 | 120662 | 54.7877 | -6.4923 | 2021-06-03 04:23:32 | Northern Ireland, United Kingdom | ||
1771197 | 1771197 | 2021-05-23 | Colombia | Norte de Santander | 59076 | 2982 | 54626 | 1468 | 7.9463 | -72.8988 | 2021-05-24 04:20:53 | Norte de Santander, Colombia | ||
1637911 | 1637911 | 2021-04-29 | US | Massachusetts | Middlesex | 25017 | 132011 | 2982 | 0 | 42.48607732 | -71.39049229 | 2021-04-30 04:21:03 | Middlesex, Massachusetts, US | |
2210669 | 2210669 | 2021-03-04 | US | Texas | Bexar | 48029 | 201834 | 2982 | 0 | 194515 | 29.44928723 | -98.52019748 | 2021-03-05 05:26:29 | Bexar, Texas, US |
2183312 | 2183312 | 2021-02-26 | Brazil | Alagoas | 130586 | 2982 | 123631 | 3973 | -9.5713 | -36.782 | 2021-02-27 05:22:28 | Alagoas, Brazil | ||
1026451 | 1026451 | 2020-10-17 | Mexico | Tabasco | 33516 | 2982 | 29715 | 819 | 17.8409 | -92.6189 | 2020-10-18 04:24:25 | Tabasco, Mexico | ||
968573 | 968573 | 2020-09-29 | US | Michigan | Wayne | 26163 | 35295 | 2982 | 0 | 32313 | 42.28098405 | -83.281255 | 2020-09-30 04:23:33 | Wayne, Michigan, US |
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]);