daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where deaths = 2985 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-28 | US | New Jersey | Middlesex | 34023 | 264084 | 2985 | 0 | 40.43629879 | -74.41426991 | 2022-12-29 04:21:01 | Middlesex, New Jersey, US | |
2022-11-29 | Japan | Hyogo | 1105756 | 2985 | 0 | 35.039913 | 134.828057 | 2022-11-30 04:21:07 | Hyogo, Japan | |||
2022-05-20 | US | New Jersey | Ocean | 34029 | 170352 | 2985 | 0 | 39.8895449 | -74.28089251 | 2022-05-21 04:20:58 | Ocean, New Jersey, US | |
2022-04-23 | Russia | Astrakhan Oblast | 115808 | 2985 | 0 | 47.1878186 | 47.608851 | 2022-04-24 04:20:56 | Astrakhan Oblast, Russia | |||
2022-04-12 | Russia | Buryatia Republic | 135188 | 2985 | 0 | 52.718242599999996 | 109.492143 | 2022-04-13 04:21:03 | Buryatia Republic, Russia | |||
2022-04-10 | US | Indiana | Marion | 18097 | 224913 | 2985 | 0 | 39.78163624 | -86.13826325 | 2022-04-11 04:21:02 | Marion, Indiana, US | |
2022-04-09 | US | Indiana | Marion | 18097 | 224913 | 2985 | 0 | 39.78163624 | -86.13826325 | 2022-04-10 04:20:52 | Marion, Indiana, US | |
2022-04-08 | US | Indiana | Marion | 18097 | 224913 | 2985 | 0 | 39.78163624 | -86.13826325 | 2022-04-09 04:20:42 | Marion, Indiana, US | |
2022-03-28 | Kyrgyzstan | 200892 | 2985 | 0 | 41.20438 | 74.766098 | 2022-03-29 04:20:46 | Kyrgyzstan | ||||
2022-03-27 | Finland | 844713 | 2985 | 0 | 61.92411 | 25.748151 | 2022-03-28 04:20:33 | Finland | ||||
2022-03-26 | Finland | 844713 | 2985 | 0 | 61.92411 | 25.748151 | 2022-03-27 04:20:47 | Finland | ||||
2022-03-25 | Finland | 844713 | 2985 | 0 | 61.92411 | 25.748151 | 2022-03-26 04:20:23 | Finland | ||||
2022-02-01 | US | Missouri | St. Louis | 29189 | 211558 | 2985 | 0 | 38.63770039999999 | -90.4458375 | 2022-02-02 04:21:09 | St. Louis, Missouri, US | |
2021-12-26 | Ukraine | Chernivtsi Oblast | 118939 | 2985 | 0 | 48.2917 | 25.9352 | 2021-12-27 04:21:58 | Chernivtsi Oblast, Ukraine | |||
2021-12-21 | Nigeria | 225255 | 2985 | 0 | 9.082 | 8.6753 | 2021-12-22 04:21:54 | Nigeria | ||||
2021-12-20 | Nigeria | 225255 | 2985 | 0 | 9.082 | 8.6753 | 2021-12-21 03:21:27 | Nigeria | ||||
2021-12-12 | Cambodia | 120355 | 2985 | 0 | 11.55 | 104.9167 | 2021-12-13 04:22:02 | Cambodia | ||||
2021-12-08 | Kosovo | 161157 | 2985 | 0 | 42.602636 | 20.902977 | 2021-12-09 04:22:49 | Kosovo | ||||
2021-12-07 | Kosovo | 161147 | 2985 | 0 | 42.602636 | 20.902977 | 2021-12-08 04:22:46 | Kosovo | ||||
2021-12-06 | Kosovo | 161139 | 2985 | 0 | 42.602636 | 20.902977 | 2021-12-07 04:22:34 | Kosovo | ||||
2021-12-05 | Kosovo | 161135 | 2985 | 0 | 42.602636 | 20.902977 | 2021-12-06 04:22:34 | Kosovo | ||||
2021-10-30 | Colombia | Bolivar | 157853 | 2985 | 0 | 8.6704 | -74.03 | 2021-10-31 04:22:08 | Bolivar, Colombia | |||
2021-10-29 | Colombia | Bolivar | 157801 | 2985 | 0 | 8.6704 | -74.03 | 2021-10-30 04:22:03 | Bolivar, Colombia | |||
2021-10-06 | Japan | Osaka | 200592 | 2985 | 0 | 34.620965000000005 | 135.507481 | 2021-10-07 04:21:36 | Osaka, Japan | |||
2021-09-30 | Russia | Novosibirsk Oblast | 63542 | 2985 | 0 | 54.9720169 | 79.48139240000002 | 2021-10-01 04:21:35 | Novosibirsk Oblast, Russia | |||
2021-08-28 | Uganda | 119544 | 2985 | 0 | 1.373333 | 32.290275 | 2021-08-29 04:21:14 | Uganda | ||||
2021-08-13 | Mexico | Zacatecas | 35557 | 2985 | 0 | 22.7709 | -102.5832 | 2021-08-14 04:21:25 | Zacatecas, Mexico | |||
2021-07-06 | Ukraine | Odessa Oblast | 140833 | 2985 | 137094 | 754 | 46.4846 | 30.7326 | 2021-07-07 04:21:20 | Odessa Oblast, Ukraine | ||
2021-06-28 | Sri Lanka | 255508 | 2985 | 221249 | 31274 | 7.873054 | 80.77179699999998 | 2021-06-29 04:21:28 | Sri Lanka | |||
2021-06-22 | United Kingdom | Northern Ireland | 125084 | 2985 | 0 | 122929 | 54.7877 | -6.4923 | 2021-06-23 04:21:46 | Northern Ireland, United Kingdom | ||
2021-06-21 | United Kingdom | Northern Ireland | 124897 | 2985 | 0 | 122742 | 54.7877 | -6.4923 | 2021-06-22 04:21:34 | Northern Ireland, United Kingdom | ||
2021-06-20 | United Kingdom | Northern Ireland | 124764 | 2985 | 0 | 122609 | 54.7877 | -6.4923 | 2021-06-21 04:21:41 | Northern Ireland, United Kingdom | ||
2021-06-19 | United Kingdom | Northern Ireland | 124639 | 2985 | 0 | 122484 | 54.7877 | -6.4923 | 2021-06-20 04:21:48 | Northern Ireland, United Kingdom | ||
2021-06-18 | United Kingdom | Northern Ireland | 124481 | 2985 | 0 | 122326 | 54.7877 | -6.4923 | 2021-06-19 04:22:33 | Northern Ireland, United Kingdom | ||
2021-06-17 | United Kingdom | Northern Ireland | 124303 | 2985 | 0 | 122148 | 54.7877 | -6.4923 | 2021-06-18 04:22:16 | Northern Ireland, United Kingdom | ||
2021-06-16 | United Kingdom | Northern Ireland | 124124 | 2985 | 0 | 121969 | 54.7877 | -6.4923 | 2021-06-17 04:22:36 | Northern Ireland, United Kingdom | ||
2021-06-15 | United Kingdom | Northern Ireland | 123981 | 2985 | 0 | 121826 | 54.7877 | -6.4923 | 2021-06-16 04:22:32 | Northern Ireland, United Kingdom | ||
2021-06-14 | United Kingdom | Northern Ireland | 123866 | 2985 | 0 | 121711 | 54.7877 | -6.4923 | 2021-06-15 04:22:22 | Northern Ireland, United Kingdom | ||
2021-06-13 | United Kingdom | Northern Ireland | 123779 | 2985 | 0 | 121624 | 54.7877 | -6.4923 | 2021-06-14 04:22:46 | Northern Ireland, United Kingdom | ||
2021-06-12 | United Kingdom | Northern Ireland | 123709 | 2985 | 0 | 121554 | 54.7877 | -6.4923 | 2021-06-13 04:22:44 | Northern Ireland, United Kingdom | ||
2021-05-28 | US | New Jersey | Essex | 34013 | 93933 | 2985 | 0 | 40.78681335 | -74.24657979 | 2021-05-29 04:20:41 | Essex, New Jersey, US | |
2021-05-17 | India | Telangana | 532784 | 2985 | 480458 | 49341 | 18.1124 | 79.0193 | 2021-05-18 04:20:33 | Telangana, India | ||
2021-04-30 | US | Massachusetts | Middlesex | 25017 | 132248 | 2985 | 0 | 42.48607732 | -71.39049229 | 2021-05-01 04:20:47 | Middlesex, Massachusetts, US | |
2021-03-12 | Italy | Friuli Venezia Giulia | 84590 | 2985 | 67864 | 13741 | 45.6494354 | 13.76813649 | 2021-03-13 05:25:15 | Friuli Venezia Giulia, Italy | ||
2021-01-20 | Brazil | Piaui | 153771 | 2985 | 149555 | 466 | -7.7183 | -42.7289 | 2021-01-21 05:22:01 | Piaui, Brazil | ||
2021-01-17 | India | Haryana | 266309 | 2985 | 261230 | 2094 | 29.20004 | 76.332824 | 2021-01-18 05:22:34 | Haryana, India | ||
2021-01-05 | Russia | Moscow Oblast | 162382 | 2985 | 119252 | 40145 | 55.50431579999999 | 38.0353929 | 2021-01-06 05:22:16 | Moscow Oblast, Russia | ||
2020-12-31 | Moldova | 144818 | 2985 | 130643 | 11190 | 47.4116 | 28.3699 | 2021-01-01 05:23:07 | Moldova | |||
2020-10-18 | Mexico | Tabasco | 33587 | 2985 | 29852 | 750 | 17.8409 | -92.6189 | 2020-10-19 04:24:16 | Tabasco, Mexico | ||
2020-10-17 | Brazil | Paraiba | 128416 | 2985 | 101073 | 24358 | -7.24 | -36.782 | 2020-10-18 04:24:25 | Paraiba, Brazil | ||
2020-09-14 | Colombia | Atlantico | 65843 | 2985 | 61382 | 1476 | 10.6966 | -74.8741 | 2020-09-15 03:22:50 | Atlantico, Colombia | ||
2020-08-13 | Mexico | Puebla | 23599 | 2985 | 18871 | 1743 | 19.0414 | -98.2063 | 2020-08-14 04:51:19 | Puebla, Mexico | ||
2020-07-09 | Brazil | Amazonas | 81318 | 2985 | 67024 | 11309 | -3.4168 | -65.8561 | 2020-07-10 04:34:24 | Amazonas, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;