daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where deaths = 1839 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-10-06 | Chile | Coquimbo | 187610 | 1839 | 0 | -29.959 | -71.3389 | 2022-10-07 04:23:08 | Coquimbo, Chile | |||
2022-08-16 | Japan | Saitama | 931097 | 1839 | 0 | 35.997101 | 139.347635 | 2022-08-17 04:20:59 | Saitama, Japan | |||
2022-08-12 | Chile | Antofagasta | 156790 | 1839 | 0 | -23.6509 | -70.3975 | 2022-08-13 04:20:52 | Antofagasta, Chile | |||
2022-08-04 | US | Maryland | Baltimore City | 24510 | 130469 | 1839 | 0 | 39.30211911 | -76.61151012 | 2022-08-05 04:20:52 | Baltimore City, Maryland, US | |
2022-08-03 | US | Maryland | Baltimore City | 24510 | 130250 | 1839 | 0 | 39.30211911 | -76.61151012 | 2022-08-04 04:20:58 | Baltimore City, Maryland, US | |
2022-05-20 | Russia | Pskov Oblast | 110288 | 1839 | 0 | 57.5358729 | 28.8586826 | 2022-05-21 04:20:58 | Pskov Oblast, Russia | |||
2022-05-19 | Russia | Pskov Oblast | 110252 | 1839 | 0 | 57.5358729 | 28.8586826 | 2022-05-20 04:20:57 | Pskov Oblast, Russia | |||
2022-05-19 | Italy | Umbria | 281668 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-20 04:20:57 | Umbria, Italy | |||
2022-05-18 | Italy | Umbria | 281007 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-19 04:20:54 | Umbria, Italy | |||
2022-05-17 | Italy | Umbria | 280331 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-18 04:20:50 | Umbria, Italy | |||
2022-05-16 | Italy | Umbria | 279637 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-17 04:20:59 | Umbria, Italy | |||
2022-05-15 | Italy | Umbria | 279357 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-16 04:20:47 | Umbria, Italy | |||
2022-05-14 | Italy | Umbria | 278706 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-15 04:20:53 | Umbria, Italy | |||
2022-05-13 | Italy | Umbria | 278059 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-14 04:20:48 | Umbria, Italy | |||
2022-05-12 | Italy | Umbria | 277339 | 1839 | 0 | 43.10675841 | 12.38824698 | 2022-05-13 04:20:51 | Umbria, Italy | |||
2022-05-05 | US | New Mexico | Bernalillo | 35001 | 148599 | 1839 | 0 | 35.05163625 | -106.6703554 | 2022-05-06 04:21:00 | Bernalillo, New Mexico, US | |
2022-04-01 | Russia | Orel Oblast | 108460 | 1839 | 0 | 52.96854329999999 | 36.0692477 | 2022-04-02 04:20:47 | Orel Oblast, Russia | |||
2022-03-16 | Chile | OHiggins | 139414 | 1839 | 0 | -34.5755 | -71.0022 | 2022-03-17 04:20:56 | OHiggins, Chile | |||
2022-03-15 | Chile | OHiggins | 138535 | 1839 | 0 | -34.5755 | -71.0022 | 2022-03-16 04:20:50 | OHiggins, Chile | |||
2022-03-14 | Chile | OHiggins | 137982 | 1839 | 0 | -34.5755 | -71.0022 | 2022-03-15 04:20:47 | OHiggins, Chile | |||
2022-03-13 | Japan | Aichi | 370289 | 1839 | 0 | 35.035551 | 137.211621 | 2022-03-14 04:20:46 | Aichi, Japan | |||
2022-03-08 | Russia | Primorsky Krai | 160470 | 1839 | 0 | 45.0819456 | 134.726645 | 2022-03-09 04:20:59 | Primorsky Krai, Russia | |||
2022-02-20 | Australia | New South Wales | 1259503 | 1839 | 0 | -33.8688 | 151.2093 | 2022-02-21 04:21:05 | New South Wales, Australia | |||
2022-01-23 | Russia | Kemerovo Oblast | 91050 | 1839 | 0 | 54.53357809999999 | 87.342861 | 2022-01-24 04:21:12 | Kemerovo Oblast, Russia | |||
2022-01-18 | Russia | Tambov Oblast | 64154 | 1839 | 0 | 52.9019574 | 41.3578918 | 2022-01-19 04:21:23 | Tambov Oblast, Russia | |||
2022-01-17 | US | Maryland | Montgomery | 24031 | 152010 | 1839 | 0 | 39.13676329 | -77.20358245 | 2022-01-18 04:21:04 | Montgomery, Maryland, US | |
2022-01-16 | Russia | Belgorod Oblast | 83415 | 1839 | 0 | 50.7080119 | 37.5837615 | 2022-01-17 04:21:08 | Belgorod Oblast, Russia | |||
2022-01-11 | Finland | 355258 | 1839 | 0 | 61.92411 | 25.748151 | 2022-01-12 04:21:44 | Finland | ||||
2021-12-28 | Colombia | Quindio | 59008 | 1839 | 0 | 4.461 | -75.6674 | 2021-12-29 03:21:43 | Quindio, Colombia | |||
2021-12-08 | US | California | San Joaquin | 6077 | 108481 | 1839 | 0 | 37.93433732 | -121.2730061 | 2021-12-09 04:22:49 | San Joaquin, California, US | |
2021-11-10 | Ukraine | Zakarpattia Oblast | 72203 | 1839 | 0 | 48.6208 | 22.2879 | 2021-11-11 04:21:45 | Zakarpattia Oblast, Ukraine | |||
2021-11-10 | Germany | Hamburg | 102186 | 1839 | 0 | 53.5511 | 9.9937 | 2021-11-11 04:21:45 | Hamburg, Germany | |||
2021-10-31 | Russia | Ivanovo Oblast | 55334 | 1839 | 0 | 56.9167446 | 41.43521370000001 | 2021-11-01 04:22:01 | Ivanovo Oblast, Russia | |||
2021-10-18 | Russia | Smolensk Oblast | 54899 | 1839 | 0 | 55.03434960000001 | 33.0192065 | 2021-10-19 04:20:54 | Smolensk Oblast, Russia | |||
2021-10-12 | Ukraine | Vinnytsia Oblast | 77837 | 1839 | 0 | 49.2331 | 28.4682 | 2021-10-13 04:20:51 | Vinnytsia Oblast, Ukraine | |||
2021-10-08 | Brazil | Acre | 87940 | 1839 | 0 | -9.0238 | -70.812 | 2021-10-09 04:21:34 | Acre, Brazil | |||
2021-10-07 | Brazil | Acre | 87938 | 1839 | 0 | -9.0238 | -70.812 | 2021-10-08 04:21:25 | Acre, Brazil | |||
2021-10-06 | Brazil | Acre | 87931 | 1839 | 0 | -9.0238 | -70.812 | 2021-10-07 04:21:36 | Acre, Brazil | |||
2021-10-05 | Brazil | Acre | 87931 | 1839 | 0 | -9.0238 | -70.812 | 2021-10-06 04:21:33 | Acre, Brazil | |||
2021-09-28 | India | Puducherry | 126215 | 1839 | 0 | 11.882658000000001 | 78.86498 | 2021-09-29 04:21:45 | Puducherry, India | |||
2021-09-23 | US | Washington | King | 53033 | 148167 | 1839 | 0 | 47.49137892 | -121.8346131 | 2021-09-24 04:21:44 | King, Washington, US | |
2021-09-18 | Montenegro | 125728 | 1839 | 0 | 42.708678000000006 | 19.37439 | 2021-09-19 04:21:34 | Montenegro | ||||
2021-09-16 | Mexico | Campeche | 21781 | 1839 | 0 | 19.8301 | -90.5349 | 2021-09-17 04:21:46 | Campeche, Mexico | |||
2021-09-06 | US | Minnesota | Hennepin | 27053 | 135989 | 1839 | 0 | 45.00761521 | -93.47694895 | 2021-09-07 04:21:35 | Hennepin, Minnesota, US | |
2021-09-05 | US | Minnesota | Hennepin | 27053 | 135989 | 1839 | 0 | 45.00761521 | -93.47694895 | 2021-09-06 04:21:22 | Hennepin, Minnesota, US | |
2021-09-04 | US | Minnesota | Hennepin | 27053 | 135989 | 1839 | 0 | 45.00761521 | -93.47694895 | 2021-09-05 04:21:33 | Hennepin, Minnesota, US | |
2021-09-03 | US | Minnesota | Hennepin | 27053 | 135989 | 1839 | 0 | 45.00761521 | -93.47694895 | 2021-09-04 04:21:28 | Hennepin, Minnesota, US | |
2021-08-31 | Ukraine | Chernivtsi Oblast | 81704 | 1839 | 0 | 48.2917 | 25.9352 | 2021-09-01 04:21:38 | Chernivtsi Oblast, Ukraine | |||
2021-08-10 | Mexico | Chiapas | 16679 | 1839 | 0 | 16.7569 | -93.1292 | 2021-08-11 04:21:58 | Chiapas, Mexico | |||
2021-07-07 | Malaysia | Selangor | 268843 | 1839 | 235963 | 31041 | 3.0738 | 101.5183 | 2021-07-08 04:21:26 | Selangor, Malaysia | ||
2021-07-05 | United Arab Emirates | 641049 | 1839 | 619294 | 19916 | 23.424076 | 53.847818 | 2021-07-06 04:21:32 | United Arab Emirates | |||
2021-06-11 | US | New York | Richmond | 36085 | 74918 | 1839 | 0 | 40.58582155 | -74.14808598 | 2021-06-12 04:22:22 | Richmond, New York, US | |
2021-06-10 | US | New York | Richmond | 36085 | 74877 | 1839 | 0 | 40.58582155 | -74.14808598 | 2021-06-11 04:23:20 | Richmond, New York, US | |
2021-06-09 | US | New York | Richmond | 36085 | 74860 | 1839 | 0 | 40.58582155 | -74.14808598 | 2021-06-10 04:23:17 | Richmond, New York, US | |
2021-03-23 | US | New Jersey | Union | 34039 | 62044 | 1839 | 0 | 40.65835409 | -74.30680092 | 2021-03-24 05:25:40 | Union, New Jersey, US | |
2021-03-08 | Russia | Irkutsk Oblast | 57346 | 1839 | 54778 | 729 | 56.6370122 | 104.719221 | 2021-03-09 05:28:19 | Irkutsk Oblast, Russia | ||
2021-02-24 | Kenya | 104780 | 1839 | 86378 | 16563 | -0.0236 | 37.9062 | 2021-02-25 05:24:57 | Kenya | |||
2021-02-21 | Nigeria | 152074 | 1839 | 128619 | 21616 | 9.082 | 8.6753 | 2021-02-22 05:24:21 | Nigeria | |||
2021-02-09 | US | Connecticut | New Haven | 9009 | 66828 | 1839 | 0 | 64989 | 41.4080325 | -72.93620426 | 2021-02-10 05:22:41 | New Haven, Connecticut, US |
2021-02-03 | Ukraine | Dnipropetrovsk Oblast | 68015 | 1839 | 62153 | 4023 | 48.4647 | 35.0462 | 2021-02-04 05:22:26 | Dnipropetrovsk Oblast, Ukraine | ||
2021-01-29 | Mexico | Morelos | 18482 | 1839 | 0 | 16643 | 18.6813 | -99.1013 | 2021-01-30 05:22:49 | Morelos, Mexico | ||
2021-01-24 | Pakistan | Khyber Pakhtunkhwa | 65532 | 1839 | 60476 | 3217 | 34.485332 | 72.09169 | 2021-01-25 05:22:16 | Khyber Pakhtunkhwa, Pakistan | ||
2021-01-19 | Russia | Sverdlovsk Oblast | 65970 | 1839 | 58419 | 5712 | 58.6414755 | 61.8021546 | 2021-01-20 05:21:54 | Sverdlovsk Oblast, Russia | ||
2020-12-21 | India | Odisha | 326596 | 1839 | 321956 | 2801 | 20.505428 | 84.418059 | 2020-12-22 05:22:33 | Odisha, India | ||
2020-12-14 | Georgia | 191063 | 1839 | 161681 | 27543 | 42.3154 | 43.3569 | 2020-12-15 05:26:38 | Georgia | |||
2020-11-18 | Armenia | 120459 | 1839 | 80069 | 38551 | 40.0691 | 45.0382 | 2020-11-19 05:25:23 | Armenia | |||
2020-11-05 | Mexico | Quintana Roo | 13649 | 1839 | 11481 | 329 | 19.1817 | -88.4791 | 2020-11-06 05:24:55 | Quintana Roo, Mexico | ||
2020-10-28 | Mexico | Chihuahua | 17271 | 1839 | 12965 | 2467 | 28.633000000000006 | -106.0691 | 2020-10-29 04:24:49 | Chihuahua, Mexico | ||
2020-10-25 | India | Rajasthan | 186243 | 1839 | 167736 | 16668 | 26.583423 | 73.847973 | 2020-10-26 04:25:02 | Rajasthan, India | ||
2020-09-17 | Germany | Nordrhein-Westfalen | 63565 | 1839 | 58460 | 3266 | 51.4332 | 7.6616 | 2020-09-18 05:05:00 | Nordrhein-Westfalen, Germany | ||
2020-08-29 | Brazil | Sergipe | 72280 | 1839 | 62950 | 7491 | -10.5741 | -37.3857 | 2020-08-30 04:28:22 | Sergipe, Brazil | ||
2020-08-17 | Brazil | Santa Catarina | 121666 | 1839 | 110019 | 9808 | -27.2423 | -50.2189 | 2020-08-18 04:27:56 | Santa Catarina, Brazil | ||
2020-07-24 | Germany | Baden-Wurttemberg | 36731 | 1839 | 34260 | 727 | 48.6616 | 9.3501 | 2020-07-25 04:47:39 | Baden-Wurttemberg, Germany | ||
2020-07-17 | Germany | Baden-Wurttemberg | 36264 | 1839 | 34050 | 464 | 48.6616 | 9.3501 | 2020-07-18 04:34:45 | Baden-Wurttemberg, Germany | ||
2020-07-03 | Germany | Baden-Wurttemberg | 35771 | 1839 | 33570 | 410 | 48.6616 | 9.3501 | 2020-07-04 04:33:51 | Baden-Wurttemberg, Germany | ||
2020-06-29 | Iraq | 47151 | 1839 | 22974 | 22338 | 33.223191 | 43.679291 | 2020-06-30 04:33:48 | Iraq | |||
2020-06-26 | US | Massachusetts | Middlesex | 25017 | 23786 | 1839 | 0 | 21947 | 42.48607732 | -71.39049229 | 2020-06-27 04:33:35 | Middlesex, Massachusetts, US |
2020-05-30 | Peru | Loreto | 4635 | 1839 | 0 | 2796 | -4.124847 | -74.424115 | 2020-05-31 02:32:45 | Loreto, Peru |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;