daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
99 rows where deaths = 2485 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-30 04:21:04 | Jefferson, Alabama, US | |
2022-12-28 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-29 04:21:01 | Jefferson, Alabama, US | |
2022-12-27 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-28 04:21:04 | Jefferson, Alabama, US | |
2022-12-26 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-27 04:21:07 | Jefferson, Alabama, US | |
2022-12-25 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-26 04:21:06 | Jefferson, Alabama, US | |
2022-12-24 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-25 04:21:04 | Jefferson, Alabama, US | |
2022-12-23 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-24 04:21:02 | Jefferson, Alabama, US | |
2022-12-22 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-23 04:21:04 | Jefferson, Alabama, US | |
2022-12-21 | US | Alabama | Jefferson | 1073 | 225876 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-22 04:20:56 | Jefferson, Alabama, US | |
2022-12-20 | US | Alabama | Jefferson | 1073 | 224817 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-21 04:21:03 | Jefferson, Alabama, US | |
2022-12-19 | US | Alabama | Jefferson | 1073 | 224817 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-20 04:21:04 | Jefferson, Alabama, US | |
2022-12-18 | US | Alabama | Jefferson | 1073 | 224817 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-19 04:21:03 | Jefferson, Alabama, US | |
2022-12-17 | US | Alabama | Jefferson | 1073 | 224817 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-18 04:21:03 | Jefferson, Alabama, US | |
2022-12-16 | US | Alabama | Jefferson | 1073 | 224817 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-17 04:21:04 | Jefferson, Alabama, US | |
2022-12-15 | US | Alabama | Jefferson | 1073 | 224817 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-16 04:21:01 | Jefferson, Alabama, US | |
2022-12-14 | US | Alabama | Jefferson | 1073 | 224817 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-15 04:20:58 | Jefferson, Alabama, US | |
2022-12-13 | US | Alabama | Jefferson | 1073 | 223971 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-14 04:21:04 | Jefferson, Alabama, US | |
2022-12-12 | US | Alabama | Jefferson | 1073 | 223971 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-13 04:21:01 | Jefferson, Alabama, US | |
2022-12-11 | US | Alabama | Jefferson | 1073 | 223971 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-12 04:21:01 | Jefferson, Alabama, US | |
2022-12-10 | US | Alabama | Jefferson | 1073 | 223971 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-11 04:20:50 | Jefferson, Alabama, US | |
2022-12-09 | US | Alabama | Jefferson | 1073 | 223971 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-10 04:21:02 | Jefferson, Alabama, US | |
2022-12-08 | US | Alabama | Jefferson | 1073 | 223971 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-09 04:21:05 | Jefferson, Alabama, US | |
2022-12-07 | US | Alabama | Jefferson | 1073 | 223971 | 2485 | 0 | 33.55554728 | -86.895063 | 2022-12-08 04:21:07 | Jefferson, Alabama, US | |
2022-11-14 | Ukraine | Sevastopol* | 96263 | 2485 | 0 | 44.6054 | 33.522 | 2022-11-15 04:21:16 | Sevastopol*, Ukraine | |||
2022-11-13 | Ukraine | Sevastopol* | 96233 | 2485 | 0 | 44.6054 | 33.522 | 2022-11-14 04:21:09 | Sevastopol*, Ukraine | |||
2022-10-12 | Germany | Mecklenburg-Vorpommern | 625121 | 2485 | 0 | 53.6127 | 12.4296 | 2022-10-13 04:22:39 | Mecklenburg-Vorpommern, Germany | |||
2022-10-10 | Russia | Tambov Oblast | 135165 | 2485 | 0 | 52.9019574 | 41.3578918 | 2022-10-11 04:23:05 | Tambov Oblast, Russia | |||
2022-10-09 | Russia | Tambov Oblast | 135062 | 2485 | 0 | 52.9019574 | 41.3578918 | 2022-10-10 04:22:32 | Tambov Oblast, Russia | |||
2022-10-08 | Russia | Tambov Oblast | 134935 | 2485 | 0 | 52.9019574 | 41.3578918 | 2022-10-09 04:21:16 | Tambov Oblast, Russia | |||
2022-09-13 | US | Georgia | Fulton | 13121 | 258233 | 2485 | 0 | 33.79216944 | -84.46319413 | 2022-09-14 04:20:44 | Fulton, Georgia, US | |
2022-09-12 | US | Georgia | Fulton | 13121 | 258233 | 2485 | 0 | 33.79216944 | -84.46319413 | 2022-09-13 04:20:57 | Fulton, Georgia, US | |
2022-09-11 | US | Georgia | Fulton | 13121 | 258233 | 2485 | 0 | 33.79216944 | -84.46319413 | 2022-09-12 04:20:58 | Fulton, Georgia, US | |
2022-09-10 | US | Georgia | Fulton | 13121 | 258233 | 2485 | 0 | 33.79216944 | -84.46319413 | 2022-09-11 04:20:50 | Fulton, Georgia, US | |
2022-09-09 | US | Georgia | Fulton | 13121 | 258233 | 2485 | 0 | 33.79216944 | -84.46319413 | 2022-09-10 04:21:10 | Fulton, Georgia, US | |
2022-09-08 | US | Georgia | Fulton | 13121 | 258233 | 2485 | 0 | 33.79216944 | -84.46319413 | 2022-09-09 04:21:11 | Fulton, Georgia, US | |
2022-09-07 | US | Georgia | Fulton | 13121 | 258233 | 2485 | 0 | 33.79216944 | -84.46319413 | 2022-09-08 04:21:02 | Fulton, Georgia, US | |
2022-07-21 | US | California | Kern | 6029 | 266145 | 2485 | 0 | 35.34329425 | -118.7277796 | 2022-07-22 04:21:15 | Kern, California, US | |
2022-07-20 | US | California | Kern | 6029 | 266145 | 2485 | 0 | 35.34329425 | -118.7277796 | 2022-07-21 04:21:10 | Kern, California, US | |
2022-07-19 | US | California | Kern | 6029 | 266145 | 2485 | 0 | 35.34329425 | -118.7277796 | 2022-07-20 04:20:59 | Kern, California, US | |
2022-07-15 | Russia | Kemerovo Oblast | 166749 | 2485 | 0 | 54.5335781 | 87.342861 | 2022-07-16 04:21:05 | Kemerovo Oblast, Russia | |||
2022-06-22 | Russia | Kursk Oblast | 119053 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-23 04:20:55 | Kursk Oblast, Russia | |||
2022-06-21 | Russia | Kursk Oblast | 119016 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-22 04:20:54 | Kursk Oblast, Russia | |||
2022-06-20 | Russia | Kursk Oblast | 118982 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-21 04:20:56 | Kursk Oblast, Russia | |||
2022-06-19 | Russia | Kursk Oblast | 118952 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-20 04:21:01 | Kursk Oblast, Russia | |||
2022-06-18 | Russia | Kursk Oblast | 118921 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-19 04:20:51 | Kursk Oblast, Russia | |||
2022-06-17 | Russia | Kursk Oblast | 118888 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-18 04:21:10 | Kursk Oblast, Russia | |||
2022-06-16 | Russia | Kursk Oblast | 118852 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-17 04:20:56 | Kursk Oblast, Russia | |||
2022-06-15 | Russia | Kursk Oblast | 118810 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-16 04:20:55 | Kursk Oblast, Russia | |||
2022-06-14 | Russia | Kursk Oblast | 118774 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-15 04:20:54 | Kursk Oblast, Russia | |||
2022-06-13 | Russia | Kursk Oblast | 118745 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-14 04:20:52 | Kursk Oblast, Russia | |||
2022-06-12 | Russia | Kursk Oblast | 118720 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-13 04:21:14 | Kursk Oblast, Russia | |||
2022-06-11 | Russia | Kursk Oblast | 118692 | 2485 | 0 | 51.6568453 | 36.4852695 | 2022-06-12 04:20:53 | Kursk Oblast, Russia | |||
2022-04-27 | Italy | Calabria | 352430 | 2485 | 0 | 38.90597598 | 16.59440194 | 2022-04-28 04:20:47 | Calabria, Italy | |||
2022-04-10 | Chile | OHiggins | 148340 | 2485 | 0 | -34.5755 | -71.0022 | 2022-04-11 04:21:02 | OHiggins, Chile | |||
2022-04-09 | Chile | OHiggins | 148209 | 2485 | 0 | -34.5755 | -71.0022 | 2022-04-10 04:20:52 | OHiggins, Chile | |||
2022-02-18 | Colombia | Meta | 104031 | 2485 | 0 | 3.272 | -73.0877 | 2022-02-19 04:21:11 | Meta, Colombia | |||
2022-02-06 | US | Ohio | Franklin | 39049 | 281660 | 2485 | 0 | 39.96995815 | -83.01115755 | 2022-02-07 04:21:05 | Franklin, Ohio, US | |
2022-02-03 | US | New York | Erie | 36029 | 201442 | 2485 | 0 | 42.76249024 | -78.73063652 | 2022-02-04 04:21:10 | Erie, New York, US | |
2022-01-22 | Kuwait | 493107 | 2485 | 0 | 29.311659999999996 | 47.481766 | 2022-01-23 04:21:13 | Kuwait | ||||
2022-01-18 | Montenegro | 206676 | 2485 | 0 | 42.708678000000006 | 19.37439 | 2022-01-19 04:21:23 | Montenegro | ||||
2022-01-16 | US | Indiana | Marion | 18097 | 194915 | 2485 | 0 | 39.78163624 | -86.13826325 | 2022-01-17 04:21:08 | Marion, Indiana, US | |
2022-01-15 | US | Indiana | Marion | 18097 | 194915 | 2485 | 0 | 39.78163624 | -86.13826325 | 2022-01-16 04:21:12 | Marion, Indiana, US | |
2022-01-14 | US | Indiana | Marion | 18097 | 194915 | 2485 | 0 | 39.78163624 | -86.13826325 | 2022-01-15 04:21:07 | Marion, Indiana, US | |
2022-01-10 | Ukraine | Chernihiv Oblast | 95855 | 2485 | 0 | 51.4982 | 31.2893 | 2022-01-11 04:22:01 | Chernihiv Oblast, Ukraine | |||
2022-01-09 | Ukraine | Chernihiv Oblast | 95830 | 2485 | 0 | 51.4982 | 31.2893 | 2022-01-10 04:22:07 | Chernihiv Oblast, Ukraine | |||
2022-01-08 | Ukraine | Chernihiv Oblast | 95726 | 2485 | 0 | 51.4982 | 31.2893 | 2022-01-09 04:21:46 | Chernihiv Oblast, Ukraine | |||
2021-11-29 | Ukraine | Kherson Oblast | 76137 | 2485 | 0 | 46.6354 | 32.6169 | 2021-11-30 04:22:53 | Kherson Oblast, Ukraine | |||
2021-11-22 | US | New Jersey | Middlesex | 34023 | 108985 | 2485 | 0 | 40.43629879 | -74.41426991 | 2021-11-23 04:22:39 | Middlesex, New Jersey, US | |
2021-11-21 | US | New Jersey | Middlesex | 34023 | 108871 | 2485 | 0 | 40.43629879 | -74.41426991 | 2021-11-22 04:22:20 | Middlesex, New Jersey, US | |
2021-11-20 | US | New Jersey | Middlesex | 34023 | 108730 | 2485 | 0 | 40.43629879 | -74.41426991 | 2021-11-21 04:22:13 | Middlesex, New Jersey, US | |
2021-11-18 | US | New Jersey | Middlesex | 34023 | 108443 | 2485 | 0 | 40.43629879 | -74.41426991 | 2021-11-19 04:21:40 | Middlesex, New Jersey, US | |
2021-11-02 | Russia | Omsk Oblast | 98199 | 2485 | 0 | 56.09352629999999 | 73.5099936 | 2021-11-03 06:22:09 | Omsk Oblast, Russia | |||
2021-10-07 | Russia | Leningrad Oblast | 70884 | 2485 | 0 | 60.185329599999996 | 32.3925325 | 2021-10-08 04:21:25 | Leningrad Oblast, Russia | |||
2021-10-01 | Colombia | Cesar | 89074 | 2485 | 0 | 9.3373 | -73.6536 | 2021-10-02 04:21:25 | Cesar, Colombia | |||
2021-09-30 | Colombia | Cesar | 89041 | 2485 | 0 | 9.3373 | -73.6536 | 2021-10-01 04:21:35 | Cesar, Colombia | |||
2021-09-29 | Colombia | Cesar | 89019 | 2485 | 0 | 9.3373 | -73.6536 | 2021-09-30 04:21:20 | Cesar, Colombia | |||
2021-09-28 | Colombia | Cesar | 88986 | 2485 | 0 | 9.3373 | -73.6536 | 2021-09-29 04:21:45 | Cesar, Colombia | |||
2021-09-09 | US | Connecticut | Hartford | 9003 | 92311 | 2485 | 0 | 41.80283011 | -72.73103891 | 2021-09-10 04:21:20 | Hartford, Connecticut, US | |
2021-09-08 | US | Connecticut | Hartford | 9003 | 92175 | 2485 | 0 | 41.80283011 | -72.73103891 | 2021-09-09 04:21:27 | Hartford, Connecticut, US | |
2021-08-25 | US | Arizona | Pima | 4019 | 125346 | 2485 | 0 | 32.0971334 | -111.7890033 | 2021-08-26 04:21:28 | Pima, Arizona, US | |
2021-08-24 | US | Arizona | Pima | 4019 | 125346 | 2485 | 0 | 32.0971334 | -111.7890033 | 2021-08-25 04:21:41 | Pima, Arizona, US | |
2021-08-15 | US | Michigan | Oakland | 26125 | 122774 | 2485 | 0 | 42.66090111 | -83.38595416 | 2021-08-16 04:21:31 | Oakland, Michigan, US | |
2021-08-14 | US | Michigan | Oakland | 26125 | 122774 | 2485 | 0 | 42.66090111 | -83.38595416 | 2021-08-15 04:21:41 | Oakland, Michigan, US | |
2021-08-13 | US | Michigan | Oakland | 26125 | 122774 | 2485 | 0 | 42.66090111 | -83.38595416 | 2021-08-14 04:21:25 | Oakland, Michigan, US | |
2021-07-26 | Mexico | Aguascalientes | 27422 | 2485 | 0 | 24937 | 21.8853 | -102.2916 | 2021-07-27 04:21:18 | Aguascalientes, Mexico | ||
2021-07-25 | Mexico | Aguascalientes | 27421 | 2485 | 0 | 24936 | 21.8853 | -102.2916 | 2021-07-26 04:21:28 | Aguascalientes, Mexico | ||
2021-07-24 | Mexico | Aguascalientes | 27420 | 2485 | 0 | 24935 | 21.8853 | -102.2916 | 2021-07-25 04:22:12 | Aguascalientes, Mexico | ||
2021-07-23 | Mexico | Aguascalientes | 27359 | 2485 | 0 | 24874 | 21.8853 | -102.2916 | 2021-07-24 00:21:36 | Aguascalientes, Mexico | ||
2021-07-18 | Russia | Samara Oblast | 71795 | 2485 | 67629 | 1681 | 53.2128813 | 50.8914633 | 2021-07-19 04:21:24 | Samara Oblast, Russia | ||
2021-06-18 | Latvia | 136652 | 2485 | 132019 | 2148 | 56.8796 | 24.6032 | 2021-06-19 04:22:33 | Latvia | |||
2021-06-07 | Mexico | Durango | 34316 | 2485 | 0 | 31831 | 24.5593 | -104.6588 | 2021-06-08 04:22:35 | Durango, Mexico | ||
2021-06-06 | Mexico | Durango | 34313 | 2485 | 0 | 31828 | 24.5593 | -104.6588 | 2021-06-07 04:22:51 | Durango, Mexico | ||
2021-06-05 | Mexico | Durango | 34311 | 2485 | 0 | 31826 | 24.5593 | -104.6588 | 2021-06-06 04:24:03 | Durango, Mexico | ||
2021-03-29 | Peru | Puno | 25880 | 2485 | 0 | 23395 | -14.995826999999998 | -69.922726 | 2021-03-30 04:26:23 | Puno, Peru | ||
2021-03-02 | Russia | Nizhny Novgorod Oblast | 97338 | 2485 | 89688 | 5165 | 55.47180329999999 | 44.0911594 | 2021-03-03 05:23:28 | Nizhny Novgorod Oblast, Russia | ||
2021-02-28 | Mexico | Zacatecas | 27460 | 2485 | 0 | 24975 | 22.7709 | -102.5832 | 2021-03-01 05:23:01 | Zacatecas, Mexico | ||
2021-01-27 | United Kingdom | Northern Ireland | 101818 | 2485 | 0 | 100039 | 54.7877 | -6.4923 | 2021-01-28 05:22:24 | Northern Ireland, United Kingdom | ||
2020-12-09 | India | Rajasthan | 285627 | 2485 | 263350 | 19792 | 26.583423 | 73.847973 | 2020-12-10 05:26:19 | Rajasthan, India | ||
2020-06-30 | United Kingdom | Wales | 15743 | 2485 | 0 | 14233 | 52.1307 | -3.7837 | 2020-07-01 04:33:52 | Wales, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;