daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
150 rows where deaths = 1418 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-13 | US | Oregon | Multnomah | 41051 | 165352 | 1418 | 0 | 45.54747959 | -122.4169351 | 2022-12-14 04:21:04 | Multnomah, Oregon, US | |
2022-12-12 | US | Oregon | Multnomah | 41051 | 165352 | 1418 | 0 | 45.54747959 | -122.4169351 | 2022-12-13 04:21:01 | Multnomah, Oregon, US | |
2022-12-11 | US | Oregon | Multnomah | 41051 | 165352 | 1418 | 0 | 45.54747959 | -122.4169351 | 2022-12-12 04:21:01 | Multnomah, Oregon, US | |
2022-12-10 | US | Oregon | Multnomah | 41051 | 165352 | 1418 | 0 | 45.54747959 | -122.4169351 | 2022-12-11 04:20:50 | Multnomah, Oregon, US | |
2022-12-09 | US | Oregon | Multnomah | 41051 | 165352 | 1418 | 0 | 45.54747959 | -122.4169351 | 2022-12-10 04:21:02 | Multnomah, Oregon, US | |
2022-12-08 | US | Oregon | Multnomah | 41051 | 165352 | 1418 | 0 | 45.54747959 | -122.4169351 | 2022-12-09 04:21:05 | Multnomah, Oregon, US | |
2022-12-07 | US | Oregon | Multnomah | 41051 | 165352 | 1418 | 0 | 45.54747959 | -122.4169351 | 2022-12-08 04:21:07 | Multnomah, Oregon, US | |
2022-10-09 | Russia | Kostroma Oblast | 100764 | 1418 | 0 | 58.424756 | 44.2533273 | 2022-10-10 04:22:32 | Kostroma Oblast, Russia | |||
2022-09-21 | US | Minnesota | Ramsey | 27123 | 146871 | 1418 | 0 | 45.01625271 | -93.09872295 | 2022-09-22 04:22:56 | Ramsey, Minnesota, US | |
2022-09-20 | US | Minnesota | Ramsey | 27123 | 146871 | 1418 | 0 | 45.01625271 | -93.09872295 | 2022-09-21 04:23:22 | Ramsey, Minnesota, US | |
2022-09-19 | US | Minnesota | Ramsey | 27123 | 146871 | 1418 | 0 | 45.01625271 | -93.09872295 | 2022-09-20 04:22:48 | Ramsey, Minnesota, US | |
2022-09-18 | US | Minnesota | Ramsey | 27123 | 146871 | 1418 | 0 | 45.01625271 | -93.09872295 | 2022-09-19 04:21:49 | Ramsey, Minnesota, US | |
2022-09-17 | US | Minnesota | Ramsey | 27123 | 146871 | 1418 | 0 | 45.01625271 | -93.09872295 | 2022-09-18 04:22:50 | Ramsey, Minnesota, US | |
2022-09-16 | US | Minnesota | Ramsey | 27123 | 146871 | 1418 | 0 | 45.01625271 | -93.09872295 | 2022-09-17 04:20:19 | Ramsey, Minnesota, US | |
2022-09-15 | US | Minnesota | Ramsey | 27123 | 146871 | 1418 | 0 | 45.01625271 | -93.09872295 | 2022-09-16 04:21:19 | Ramsey, Minnesota, US | |
2022-07-31 | US | Colorado | Denver | 8031 | 204991 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-08-01 04:21:03 | Denver, Colorado, US | |
2022-07-30 | US | Colorado | Denver | 8031 | 204894 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-31 04:21:02 | Denver, Colorado, US | |
2022-07-29 | US | Colorado | Denver | 8031 | 204794 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-30 04:20:42 | Denver, Colorado, US | |
2022-07-28 | US | Colorado | Denver | 8031 | 204656 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-29 04:20:45 | Denver, Colorado, US | |
2022-07-27 | US | Colorado | Denver | 8031 | 204492 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-28 04:20:56 | Denver, Colorado, US | |
2022-07-26 | US | Colorado | Denver | 8031 | 204292 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-27 04:21:04 | Denver, Colorado, US | |
2022-07-25 | US | Colorado | Denver | 8031 | 204098 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-26 04:20:58 | Denver, Colorado, US | |
2022-07-24 | US | Colorado | Denver | 8031 | 203846 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-25 04:20:51 | Denver, Colorado, US | |
2022-07-23 | US | Colorado | Denver | 8031 | 203736 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-24 04:20:47 | Denver, Colorado, US | |
2022-07-22 | US | Colorado | Denver | 8031 | 203612 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-23 04:20:53 | Denver, Colorado, US | |
2022-07-21 | US | Colorado | Denver | 8031 | 203453 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-22 04:21:15 | Denver, Colorado, US | |
2022-07-20 | US | Colorado | Denver | 8031 | 203275 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-21 04:21:10 | Denver, Colorado, US | |
2022-07-19 | US | Colorado | Denver | 8031 | 203013 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-20 04:20:59 | Denver, Colorado, US | |
2022-07-18 | US | Colorado | Denver | 8031 | 202779 | 1418 | 0 | 39.76018276 | -104.8725695 | 2022-07-19 04:20:58 | Denver, Colorado, US | |
2022-07-03 | Singapore | 1467234 | 1418 | 0 | 1.2833 | 103.8333 | 2022-07-04 04:20:54 | Singapore | ||||
2022-06-28 | Netherlands | Overijssel | 571224 | 1418 | 0 | 52.444558 | 6.441722 | 2022-06-29 04:20:59 | Overijssel, Netherlands | |||
2022-06-27 | Netherlands | Overijssel | 570862 | 1418 | 0 | 52.444558 | 6.441722 | 2022-06-28 04:20:58 | Overijssel, Netherlands | |||
2022-06-26 | US | Illinois | Lake | 17097 | 171780 | 1418 | 0 | 42.3224907 | -88.00367925 | 2022-06-27 04:21:00 | Lake, Illinois, US | |
2022-06-26 | Netherlands | Overijssel | 570074 | 1418 | 0 | 52.444558 | 6.441722 | 2022-06-27 04:21:00 | Overijssel, Netherlands | |||
2022-06-25 | US | Illinois | Lake | 17097 | 171780 | 1418 | 0 | 42.3224907 | -88.00367925 | 2022-06-26 04:21:02 | Lake, Illinois, US | |
2022-06-25 | Netherlands | Overijssel | 570074 | 1418 | 0 | 52.444558 | 6.441722 | 2022-06-26 04:21:02 | Overijssel, Netherlands | |||
2022-06-24 | US | Illinois | Lake | 17097 | 171780 | 1418 | 0 | 42.3224907 | -88.00367925 | 2022-06-25 04:20:57 | Lake, Illinois, US | |
2022-06-24 | Netherlands | Overijssel | 570074 | 1418 | 0 | 52.444558 | 6.441722 | 2022-06-25 04:20:57 | Overijssel, Netherlands | |||
2022-06-23 | US | Illinois | Lake | 17097 | 171447 | 1418 | 0 | 42.3224907 | -88.00367925 | 2022-06-24 04:20:58 | Lake, Illinois, US | |
2022-06-23 | Netherlands | Overijssel | 569798 | 1418 | 0 | 52.444558 | 6.441722 | 2022-06-24 04:20:58 | Overijssel, Netherlands | |||
2022-06-22 | Netherlands | Overijssel | 569430 | 1418 | 0 | 52.444558 | 6.441722 | 2022-06-23 04:20:55 | Overijssel, Netherlands | |||
2022-05-02 | Russia | Kurgan Oblast | 103849 | 1418 | 0 | 55.7655302 | 64.5632681 | 2022-05-03 04:21:00 | Kurgan Oblast, Russia | |||
2022-04-14 | Japan | Saitama | 475846 | 1418 | 0 | 35.997101 | 139.347635 | 2022-04-15 04:20:57 | Saitama, Japan | |||
2022-04-13 | Japan | Saitama | 471983 | 1418 | 0 | 35.997101 | 139.347635 | 2022-04-13 23:21:06 | Saitama, Japan | |||
2022-04-12 | Malaysia | Kelantan | 246600 | 1418 | 0 | 6.1254 | 102.2381 | 2022-04-13 04:21:03 | Kelantan, Malaysia | |||
2022-04-11 | Malaysia | Kelantan | 246514 | 1418 | 0 | 6.1254 | 102.2381 | 2022-04-12 04:20:49 | Kelantan, Malaysia | |||
2022-04-10 | Malaysia | Kelantan | 246381 | 1418 | 0 | 6.1254 | 102.2381 | 2022-04-11 04:21:02 | Kelantan, Malaysia | |||
2022-03-22 | US | Virginia | Fairfax | 51059 | 174814 | 1418 | 0 | 38.83677558 | -77.27565836 | 2022-03-23 04:20:48 | Fairfax, Virginia, US | |
2022-03-21 | US | Virginia | Fairfax | 51059 | 174814 | 1418 | 0 | 38.83677558 | -77.27565836 | 2022-03-22 04:20:54 | Fairfax, Virginia, US | |
2022-03-18 | US | Ohio | Lucas | 39095 | 99438 | 1418 | 0 | 41.62101218 | -83.65468618 | 2022-03-19 04:20:47 | Lucas, Ohio, US | |
2022-03-17 | US | Ohio | Lucas | 39095 | 99438 | 1418 | 0 | 41.62101218 | -83.65468618 | 2022-03-18 04:20:55 | Lucas, Ohio, US | |
2022-03-10 | Russia | Karelia Republic | 128516 | 1418 | 0 | 62.61940309999999 | 33.4920267 | 2022-03-11 04:20:50 | Karelia Republic, Russia | |||
2022-03-09 | Chile | Antofagasta | 116482 | 1418 | 0 | -23.6509 | -70.3975 | 2022-03-10 04:20:48 | Antofagasta, Chile | |||
2022-03-08 | Italy | P.A. Bolzano | 192237 | 1418 | 0 | 46.49933453 | 11.35662422 | 2022-03-09 04:20:59 | P.A. Bolzano, Italy | |||
2022-03-08 | Chile | Antofagasta | 116227 | 1418 | 0 | -23.6509 | -70.3975 | 2022-03-09 04:20:59 | Antofagasta, Chile | |||
2022-03-07 | Chile | Antofagasta | 116038 | 1418 | 0 | -23.6509 | -70.3975 | 2022-03-08 04:20:54 | Antofagasta, Chile | |||
2022-02-22 | US | Texas | Collin | 48085 | 202438 | 1418 | 0 | 33.18820114 | -96.57264368 | 2022-02-23 04:21:09 | Collin, Texas, US | |
2022-02-09 | Bahrain | 442062 | 1418 | 0 | 26.0275 | 50.55 | 2022-02-10 04:21:14 | Bahrain | ||||
2022-01-29 | Japan | Hyogo | 123283 | 1418 | 0 | 35.039913 | 134.828057 | 2022-01-30 04:21:26 | Hyogo, Japan | |||
2022-01-28 | Russia | Kaliningrad Oblast | 90551 | 1418 | 0 | 54.7293041 | 21.1489473 | 2022-01-29 04:21:10 | Kaliningrad Oblast, Russia | |||
2022-01-20 | US | New York | Monroe | 36055 | 139416 | 1418 | 0 | 43.14638895 | -77.69322942 | 2022-01-21 04:21:09 | Monroe, New York, US | |
2022-01-19 | US | Alabama | Mobile | 1097 | 98462 | 1418 | 0 | 30.78472347 | -88.20842409 | 2022-01-20 04:21:07 | Mobile, Alabama, US | |
2021-12-28 | Russia | Kabardino-Balkarian Republic | 41690 | 1418 | 0 | 43.480604799999995 | 43.5978976 | 2021-12-29 03:21:43 | Kabardino-Balkarian Republic, Russia | |||
2021-12-26 | US | Ohio | Summit | 39153 | 85376 | 1418 | 0 | 41.12464734 | -81.53123079 | 2021-12-27 04:21:58 | Summit, Ohio, US | |
2021-12-20 | US | California | Stanislaus | 6099 | 92668 | 1418 | 0 | 37.55862499 | -120.9970722 | 2021-12-21 03:21:27 | Stanislaus, California, US | |
2021-12-19 | Russia | Orel Oblast | 68185 | 1418 | 0 | 52.96854329999999 | 36.0692477 | 2021-12-20 04:21:43 | Orel Oblast, Russia | |||
2021-12-12 | Australia | Victoria | 137227 | 1418 | 0 | -37.8136 | 144.9631 | 2021-12-13 04:22:02 | Victoria, Australia | |||
2021-12-09 | US | Illinois | DuPage | 17043 | 122278 | 1418 | 0 | 41.85116968 | -88.08642662 | 2021-12-10 04:22:28 | DuPage, Illinois, US | |
2021-12-05 | Uzbekistan | 194333 | 1418 | 0 | 41.377491 | 64.585262 | 2021-12-06 04:22:34 | Uzbekistan | ||||
2021-11-19 | US | Ohio | Montgomery | 39113 | 78032 | 1418 | 0 | 39.75394919 | -84.29050975 | 2021-11-20 04:22:17 | Montgomery, Ohio, US | |
2021-11-10 | Chile | Los Lagos | 90697 | 1418 | 0 | -41.9198 | -72.1416 | 2021-11-11 04:21:45 | Los Lagos, Chile | |||
2021-11-09 | Chile | Los Lagos | 90637 | 1418 | 0 | -41.9198 | -72.1416 | 2021-11-10 04:21:38 | Los Lagos, Chile | |||
2021-11-08 | Chile | Los Lagos | 90516 | 1418 | 0 | -41.9198 | -72.1416 | 2021-11-09 04:21:36 | Los Lagos, Chile | |||
2021-11-05 | Ukraine | Sevastopol* | 40787 | 1418 | 0 | 44.6054 | 33.522 | 2021-11-06 04:21:51 | Sevastopol*, Ukraine | |||
2021-10-26 | US | California | Alameda | 6001 | 121063 | 1418 | 0 | 37.64629437 | -121.8929271 | 2021-10-27 04:22:32 | Alameda, California, US | |
2021-09-27 | Russia | Bryansk Oblast | 64932 | 1418 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-28 04:21:28 | Bryansk Oblast, Russia | |||
2021-09-02 | Russia | Lipetsk Oblast | 47283 | 1418 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-09-03 04:21:20 | Lipetsk Oblast, Russia | |||
2021-08-22 | Yemen | 7509 | 1418 | 0 | 15.552726999999999 | 48.516388 | 2021-08-23 04:21:27 | Yemen | ||||
2021-08-16 | US | Massachusetts | Bristol | 25005 | 69793 | 1418 | 0 | 41.79228404 | -71.10872211 | 2021-08-17 04:21:49 | Bristol, Massachusetts, US | |
2021-08-06 | Chile | Araucania | 97096 | 1418 | 0 | -38.9489 | -72.3311 | 2021-08-07 04:21:30 | Araucania, Chile | |||
2021-07-22 | Mexico | Campeche | 13651 | 1418 | 0 | 12233 | 19.8301 | -90.5349 | 2021-07-23 04:21:29 | Campeche, Mexico | ||
2021-07-21 | Japan | Hokkaido | 42678 | 1418 | 40270 | 990 | 43.385711 | 142.552318 | 2021-07-22 04:21:19 | Hokkaido, Japan | ||
2021-07-20 | US | Pennsylvania | Delaware | 42045 | 52845 | 1418 | 0 | 39.91680171 | -75.40243663 | 2021-07-21 04:21:40 | Delaware, Pennsylvania, US | |
2021-07-20 | Japan | Hokkaido | 42560 | 1418 | 40179 | 963 | 43.385711 | 142.552318 | 2021-07-21 04:21:40 | Hokkaido, Japan | ||
2021-07-19 | Japan | Hokkaido | 42456 | 1418 | 40141 | 897 | 43.385711 | 142.552318 | 2021-07-20 04:21:48 | Hokkaido, Japan | ||
2021-07-16 | Chile | OHiggins | 66829 | 1418 | 64902 | 509 | -34.5755 | -71.0022 | 2021-07-17 04:22:22 | OHiggins, Chile | ||
2021-06-22 | US | Wisconsin | Milwaukee | 55079 | 117695 | 1418 | 0 | 43.00486062 | -87.96733172 | 2021-06-23 04:21:46 | Milwaukee, Wisconsin, US | |
2021-06-22 | Italy | Umbria | 56782 | 1418 | 54487 | 877 | 43.10675841 | 12.38824698 | 2021-06-23 04:21:46 | Umbria, Italy | ||
2021-06-21 | Italy | Umbria | 56775 | 1418 | 54474 | 883 | 43.10675841 | 12.38824698 | 2021-06-22 04:21:34 | Umbria, Italy | ||
2021-06-20 | Italy | Umbria | 56771 | 1418 | 54463 | 890 | 43.10675841 | 12.38824698 | 2021-06-21 04:21:41 | Umbria, Italy | ||
2021-06-19 | Italy | Umbria | 56744 | 1418 | 54432 | 894 | 43.10675841 | 12.38824698 | 2021-06-20 04:21:48 | Umbria, Italy | ||
2021-06-18 | Italy | Umbria | 56736 | 1418 | 54392 | 926 | 43.10675841 | 12.38824698 | 2021-06-19 04:22:33 | Umbria, Italy | ||
2021-06-17 | Italy | Umbria | 56723 | 1418 | 54352 | 953 | 43.10675841 | 12.38824698 | 2021-06-18 04:22:16 | Umbria, Italy | ||
2021-06-16 | Italy | Umbria | 56704 | 1418 | 54323 | 963 | 43.10675841 | 12.38824698 | 2021-06-17 04:22:36 | Umbria, Italy | ||
2021-06-14 | Ukraine | Crimea Republic* | 45037 | 1418 | 41652 | 1967 | 45.2835 | 34.2008 | 2021-06-15 04:22:22 | Crimea Republic*, Ukraine | ||
2021-06-03 | Russia | Ulyanovsk Oblast | 56190 | 1418 | 53610 | 1162 | 54.1463177 | 47.2324921 | 2021-06-04 04:23:37 | Ulyanovsk Oblast, Russia | ||
2021-05-24 | Colombia | Caldas | 68411 | 1418 | 64939 | 2054 | 5.2983 | -75.2479 | 2021-05-25 04:21:08 | Caldas, Colombia | ||
2021-05-20 | US | Massachusetts | Norfolk | 25021 | 54615 | 1418 | 0 | 42.16073095 | -71.20530408 | 2021-05-21 04:20:43 | Norfolk, Massachusetts, US | |
2021-05-20 | Russia | Omsk Oblast | 46830 | 1418 | 44454 | 958 | 56.09352629999999 | 73.5099936 | 2021-05-21 04:20:43 | Omsk Oblast, Russia | ||
2021-05-19 | US | Massachusetts | Norfolk | 25021 | 54579 | 1418 | 0 | 42.16073095 | -71.20530408 | 2021-05-20 04:21:05 | Norfolk, Massachusetts, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;