johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where deaths = 2970 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1630485 | 1630485 | 2022-12-18 | US | New Jersey | Middlesex | 34023 | 261168 | 2970 | 0 | 40.43629879 | -74.41426991 | 2022-12-19 04:21:03 | Middlesex, New Jersey, US | |
505864 | 505864 | 2022-12-17 | US | New Jersey | Middlesex | 34023 | 261168 | 2970 | 0 | 40.43629879 | -74.41426991 | 2022-12-18 04:21:03 | Middlesex, New Jersey, US | |
3326436 | 3326436 | 2022-12-16 | US | New Jersey | Middlesex | 34023 | 261168 | 2970 | 0 | 40.43629879 | -74.41426991 | 2022-12-17 04:21:04 | Middlesex, New Jersey, US | |
544948 | 544948 | 2022-12-15 | US | New Jersey | Middlesex | 34023 | 260929 | 2970 | 0 | 40.43629879 | -74.41426991 | 2022-12-16 04:21:01 | Middlesex, New Jersey, US | |
912193 | 912193 | 2022-10-29 | Japan | Aichi | 1412562 | 2970 | 0 | 35.035551 | 137.211621 | 2022-10-30 04:22:14 | Aichi, Japan | |||
2083639 | 2083639 | 2022-05-15 | Australia | New South Wales | 2447877 | 2970 | 0 | -33.8688 | 151.2093 | 2022-05-16 04:20:47 | New South Wales, Australia | |||
3537639 | 3537639 | 2022-05-10 | US | New Jersey | Ocean | 34029 | 167312 | 2970 | 0 | 39.8895449 | -74.28089251 | 2022-05-11 04:20:48 | Ocean, New Jersey, US | |
224174 | 224174 | 2022-05-09 | US | New Jersey | Ocean | 34029 | 167099 | 2970 | 0 | 39.8895449 | -74.28089251 | 2022-05-10 04:20:50 | Ocean, New Jersey, US | |
3265481 | 3265481 | 2022-05-04 | Jamaica | 130473 | 2970 | 0 | 18.1096 | -77.2975 | 2022-05-05 04:20:55 | Jamaica | ||||
1652585 | 1652585 | 2022-04-09 | Russia | Astrakhan Oblast | 115247 | 2970 | 0 | 47.1878186 | 47.608851 | 2022-04-10 04:20:52 | Astrakhan Oblast, Russia | |||
2749082 | 2749082 | 2022-04-04 | Russia | Buryatia Republic | 134628 | 2970 | 0 | 52.718242599999996 | 109.492143 | 2022-04-05 04:20:48 | Buryatia Republic, Russia | |||
1660661 | 1660661 | 2021-12-12 | Russia | Omsk Oblast | 121470 | 2970 | 0 | 56.09352629999999 | 73.5099936 | 2021-12-13 04:22:02 | Omsk Oblast, Russia | |||
714664 | 714664 | 2021-11-12 | Russia | Chuvashia Republic | 39963 | 2970 | 0 | 55.4259922 | 47.0849429 | 2021-11-13 04:21:38 | Chuvashia Republic, Russia | |||
86797 | 86797 | 2021-11-09 | Albania | 190125 | 2970 | 0 | 41.1533 | 20.1683 | 2021-11-10 04:21:38 | Albania | ||||
3007155 | 3007155 | 2021-10-11 | Colombia | Bolivar | 156899 | 2970 | 0 | 8.6704 | -74.03 | 2021-10-12 04:21:09 | Bolivar, Colombia | |||
425515 | 425515 | 2021-10-10 | US | New Jersey | Bergen | 34003 | 117873 | 2970 | 0 | 40.96010917 | -74.07164325 | 2021-10-11 04:21:31 | Bergen, New Jersey, US | |
423389 | 423389 | 2021-10-10 | Kosovo | 160386 | 2970 | 0 | 42.602636 | 20.902977 | 2021-10-11 04:21:31 | Kosovo | ||||
2878372 | 2878372 | 2021-10-09 | US | New Jersey | Bergen | 34003 | 117750 | 2970 | 0 | 40.96010917 | -74.07164325 | 2021-10-10 04:21:38 | Bergen, New Jersey, US | |
3832571 | 3832571 | 2021-10-05 | Mexico | Durango | 47505 | 2970 | 0 | 24.5593 | -104.6588 | 2021-10-06 04:21:33 | Durango, Mexico | |||
987064 | 987064 | 2021-10-04 | Mexico | Durango | 47505 | 2970 | 0 | 24.5593 | -104.6588 | 2021-10-05 04:21:27 | Durango, Mexico | |||
1274374 | 1274374 | 2021-10-03 | Mexico | Durango | 47481 | 2970 | 0 | 24.5593 | -104.6588 | 2021-10-04 04:21:31 | Durango, Mexico | |||
3928127 | 3928127 | 2021-10-02 | Mexico | Durango | 47481 | 2970 | 0 | 24.5593 | -104.6588 | 2021-10-03 04:21:24 | Durango, Mexico | |||
2132038 | 2132038 | 2021-10-01 | Japan | Osaka | 199791 | 2970 | 0 | 34.620965000000005 | 135.507481 | 2021-10-02 04:21:25 | Osaka, Japan | |||
3806098 | 3806098 | 2021-09-11 | Russia | Chelyabinsk Oblast | 89040 | 2970 | 0 | 54.4223954 | 61.1865846 | 2021-09-12 04:21:13 | Chelyabinsk Oblast, Russia | |||
249457 | 249457 | 2021-09-04 | Peru | San Martin | 48213 | 2970 | 0 | -7.039531 | -76.729127 | 2021-09-05 04:21:33 | San Martin, Peru | |||
177879 | 177879 | 2021-09-02 | Colombia | Narino | 88812 | 2970 | 0 | 1.2892 | -77.3579 | 2021-09-03 04:21:20 | Narino, Colombia | |||
66914 | 66914 | 2021-09-01 | Colombia | Narino | 88783 | 2970 | 0 | 1.2892 | -77.3579 | 2021-09-02 04:21:15 | Narino, Colombia | |||
3683636 | 3683636 | 2021-08-02 | Russia | Altai Krai | 62639 | 2970 | 49168 | 10501 | 52.6932243 | 82.69314240000001 | 2021-08-03 04:21:39 | Altai Krai, Russia | ||
3385504 | 3385504 | 2021-07-29 | Namibia | 117896 | 2970 | 94412 | 20514 | -22.9576 | 18.4904 | 2021-07-30 04:21:34 | Namibia | |||
2717147 | 2717147 | 2021-06-10 | Peru | Ucayali | 31372 | 2970 | 0 | 28402 | -9.621718 | -73.444929 | 2021-06-11 04:23:20 | Ucayali, Peru | ||
2008315 | 2008315 | 2021-05-12 | United Kingdom | Northern Ireland | 121224 | 2970 | 0 | 119076 | 54.7877 | -6.4923 | 2021-05-13 04:20:51 | Northern Ireland, United Kingdom | ||
3958146 | 3958146 | 2021-05-11 | United Kingdom | Northern Ireland | 121111 | 2970 | 0 | 118963 | 54.7877 | -6.4923 | 2021-05-12 04:21:29 | Northern Ireland, United Kingdom | ||
2820758 | 2820758 | 2021-05-10 | Italy | Marche | 99794 | 2970 | 91306 | 5518 | 43.61675973 | 13.5188753 | 2021-05-11 04:20:41 | Marche, Italy | ||
1552141 | 1552141 | 2021-05-08 | Peru | Puno | 29556 | 2970 | 0 | 26586 | -14.995826999999998 | -69.922726 | 2021-05-09 04:20:35 | Puno, Peru | ||
1569701 | 1569701 | 2021-04-22 | US | Massachusetts | Middlesex | 25017 | 130366 | 2970 | 0 | 42.48607732 | -71.39049229 | 2021-04-23 04:20:52 | Middlesex, Massachusetts, US | |
1290131 | 1290131 | 2021-03-29 | Netherlands | Noord-Brabant | 196939 | 2970 | 0 | 195458 | 51.561174 | 5.184942 | 2021-03-30 04:26:23 | Noord-Brabant, Netherlands | ||
279872 | 279872 | 2021-02-24 | Algeria | 112461 | 2970 | 77537 | 31954 | 28.0339 | 1.6596 | 2021-02-25 05:24:57 | Algeria | |||
3050281 | 3050281 | 2021-02-16 | Mexico | Yucatan | 31619 | 2970 | 0 | 28649 | 20.7099 | -89.0943 | 2021-02-17 05:23:10 | Yucatan, Mexico | ||
1530582 | 1530582 | 2021-02-09 | US | Pennsylvania | Philadelphia | 42101 | 114303 | 2970 | 0 | 111333 | 40.00338507 | -75.1379271 | 2021-02-10 05:22:41 | Philadelphia, Pennsylvania, US |
2567749 | 2567749 | 2021-01-25 | Mexico | Guerrero | 29895 | 2970 | 0 | 26925 | 17.4392 | -99.5451 | 2021-01-26 05:22:02 | Guerrero, Mexico | ||
1759272 | 1759272 | 2021-01-24 | Ireland | 187554 | 2970 | 23364 | 161220 | 53.1424 | -7.6921 | 2021-01-25 05:22:16 | Ireland | |||
786122 | 786122 | 2020-10-15 | Brazil | Paraiba | 127456 | 2970 | 101073 | 23413 | -7.24 | -36.782 | 2020-10-16 04:24:01 | Paraiba, Brazil | ||
2614125 | 2614125 | 2020-09-26 | Mexico | Nuevo Leon | 38328 | 2970 | 32089 | 3269 | 25.5922 | -99.9962 | 2020-09-27 04:23:00 | Nuevo Leon, Mexico | ||
2607702 | 2607702 | 2020-09-24 | US | Michigan | Wayne | 26163 | 34759 | 2970 | 0 | 31789 | 42.28098405 | -83.281255 | 2020-09-25 04:23:00 | Wayne, Michigan, US |
2654056 | 2654056 | 2020-09-23 | Spain | Castilla y Leon | 42378 | 2970 | 8716 | 30692 | 41.8357 | -4.3976 | 2020-09-24 04:23:00 | Castilla y Leon, Spain | ||
2728741 | 2728741 | 2020-09-15 | Brazil | Distrito Federal | 178747 | 2970 | 165276 | 10501 | -15.7998 | -47.8645 | 2020-09-16 04:22:53 | Distrito Federal, Brazil | ||
1444419 | 1444419 | 2020-09-11 | Colombia | Atlantico | 65631 | 2970 | 61026 | 1635 | 10.6966 | -74.8741 | 2020-09-12 04:25:05 | Atlantico, Colombia | ||
217232 | 217232 | 2020-06-08 | Russia | Moscow | 197018 | 2970 | 104347 | 89701 | 55.7504461 | 37.6174943 | 2020-06-09 03:33:03 | Moscow, 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]);