daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
142 rows where deaths = 1314 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 | Arizona | Yavapai | 4025 | 57905 | 1314 | 0 | 34.59933926 | -112.5538588 | 2022-12-14 04:21:04 | Yavapai, Arizona, US | |
| 2022-12-12 | US | Missouri | Kansas City | 135013 | 1314 | 0 | 39.0997 | -94.5786 | 2022-12-13 04:21:01 | Kansas City, Missouri, US | ||
| 2022-12-12 | US | Arizona | Yavapai | 4025 | 57905 | 1314 | 0 | 34.59933926 | -112.5538588 | 2022-12-13 04:21:01 | Yavapai, Arizona, US | |
| 2022-12-11 | US | Missouri | Kansas City | 135013 | 1314 | 0 | 39.0997 | -94.5786 | 2022-12-12 04:21:01 | Kansas City, Missouri, US | ||
| 2022-12-11 | US | Arizona | Yavapai | 4025 | 57905 | 1314 | 0 | 34.59933926 | -112.5538588 | 2022-12-12 04:21:01 | Yavapai, Arizona, US | |
| 2022-12-10 | US | Missouri | Kansas City | 135013 | 1314 | 0 | 39.0997 | -94.5786 | 2022-12-11 04:20:50 | Kansas City, Missouri, US | ||
| 2022-12-10 | US | Arizona | Yavapai | 4025 | 57905 | 1314 | 0 | 34.59933926 | -112.5538588 | 2022-12-11 04:20:50 | Yavapai, Arizona, US | |
| 2022-12-09 | US | Missouri | Kansas City | 135013 | 1314 | 0 | 39.0997 | -94.5786 | 2022-12-10 04:21:02 | Kansas City, Missouri, US | ||
| 2022-12-09 | US | Arizona | Yavapai | 4025 | 57905 | 1314 | 0 | 34.59933926 | -112.5538588 | 2022-12-10 04:21:02 | Yavapai, Arizona, US | |
| 2022-12-08 | US | Missouri | Kansas City | 135013 | 1314 | 0 | 39.0997 | -94.5786 | 2022-12-09 04:21:05 | Kansas City, Missouri, US | ||
| 2022-12-08 | US | Arizona | Yavapai | 4025 | 57905 | 1314 | 0 | 34.59933926 | -112.5538588 | 2022-12-09 04:21:05 | Yavapai, Arizona, US | |
| 2022-12-07 | US | Missouri | Kansas City | 135013 | 1314 | 0 | 39.0997 | -94.5786 | 2022-12-08 04:21:07 | Kansas City, Missouri, US | ||
| 2022-12-07 | US | Arizona | Yavapai | 4025 | 57905 | 1314 | 0 | 34.59933926 | -112.5538588 | 2022-12-08 04:21:07 | Yavapai, Arizona, US | |
| 2022-12-06 | US | New Jersey | Mercer | 34021 | 103679 | 1314 | 0 | 40.28047017 | -74.70479631 | 2022-12-07 04:20:58 | Mercer, New Jersey, US | |
| 2022-12-06 | US | Missouri | Kansas City | 135013 | 1314 | 0 | 39.0997 | -94.5786 | 2022-12-07 04:20:58 | Kansas City, Missouri, US | ||
| 2022-11-22 | US | Pennsylvania | Lehigh | 42077 | 105251 | 1314 | 0 | 40.6154815 | -75.59435245 | 2022-11-23 04:21:06 | Lehigh, Pennsylvania, US | |
| 2022-11-21 | US | Pennsylvania | Lehigh | 42077 | 105251 | 1314 | 0 | 40.6154815 | -75.59435245 | 2022-11-22 04:20:47 | Lehigh, Pennsylvania, US | |
| 2022-11-20 | US | Pennsylvania | Lehigh | 42077 | 105251 | 1314 | 0 | 40.6154815 | -75.59435245 | 2022-11-21 04:21:05 | Lehigh, Pennsylvania, US | |
| 2022-11-19 | US | Pennsylvania | Lehigh | 42077 | 105251 | 1314 | 0 | 40.6154815 | -75.59435245 | 2022-11-20 04:21:08 | Lehigh, Pennsylvania, US | |
| 2022-11-18 | US | Pennsylvania | Lehigh | 42077 | 105251 | 1314 | 0 | 40.6154815 | -75.59435245 | 2022-11-19 04:21:14 | Lehigh, Pennsylvania, US | |
| 2022-11-17 | US | Pennsylvania | Lehigh | 42077 | 105251 | 1314 | 0 | 40.6154815 | -75.59435245 | 2022-11-18 04:21:15 | Lehigh, Pennsylvania, US | |
| 2022-11-16 | US | Pennsylvania | Lehigh | 42077 | 105251 | 1314 | 0 | 40.6154815 | -75.59435245 | 2022-11-17 04:21:11 | Lehigh, Pennsylvania, US | |
| 2022-11-08 | US | New Jersey | Burlington | 34005 | 130909 | 1314 | 0 | 39.87681124 | -74.66927768 | 2022-11-09 04:21:22 | Burlington, New Jersey, US | |
| 2022-11-07 | US | Missouri | Jackson | 29095 | 114095 | 1314 | 0 | 39.01002188 | -94.34724536 | 2022-11-08 04:21:21 | Jackson, Missouri, US | |
| 2022-11-06 | US | Missouri | Jackson | 29095 | 114030 | 1314 | 0 | 39.01002188 | -94.34724536 | 2022-11-07 04:21:26 | Jackson, Missouri, US | |
| 2022-11-05 | US | Missouri | Jackson | 29095 | 114030 | 1314 | 0 | 39.01002188 | -94.34724536 | 2022-11-06 04:21:24 | Jackson, Missouri, US | |
| 2022-11-04 | US | Missouri | Jackson | 29095 | 114030 | 1314 | 0 | 39.01002188 | -94.34724536 | 2022-11-05 04:21:52 | Jackson, Missouri, US | |
| 2022-11-03 | US | Missouri | Jackson | 29095 | 113972 | 1314 | 0 | 39.01002188 | -94.34724536 | 2022-11-04 04:22:11 | Jackson, Missouri, US | |
| 2022-11-02 | US | Missouri | Jackson | 29095 | 113933 | 1314 | 0 | 39.01002188 | -94.34724536 | 2022-11-03 04:22:05 | Jackson, Missouri, US | |
| 2022-11-01 | US | Missouri | Jackson | 29095 | 113885 | 1314 | 0 | 39.01002188 | -94.34724536 | 2022-11-02 04:22:09 | Jackson, Missouri, US | |
| 2022-10-11 | US | Washington | Snohomish | 53061 | 192939 | 1314 | 0 | 48.04615983 | -121.7170703 | 2022-10-12 04:22:51 | Snohomish, Washington, US | |
| 2022-10-10 | US | Washington | Snohomish | 53061 | 192939 | 1314 | 0 | 48.04615983 | -121.7170703 | 2022-10-11 04:23:05 | Snohomish, Washington, US | |
| 2022-10-09 | US | Washington | Snohomish | 53061 | 192674 | 1314 | 0 | 48.04615983 | -121.7170703 | 2022-10-10 04:22:32 | Snohomish, Washington, US | |
| 2022-10-08 | US | Washington | Snohomish | 53061 | 192674 | 1314 | 0 | 48.04615983 | -121.7170703 | 2022-10-09 04:21:16 | Snohomish, Washington, US | |
| 2022-10-07 | US | Washington | Snohomish | 53061 | 192674 | 1314 | 0 | 48.04615983 | -121.7170703 | 2022-10-08 04:22:56 | Snohomish, Washington, US | |
| 2022-09-28 | Chile | Los Rios | 131086 | 1314 | 0 | -40.231 | -72.3311 | 2022-09-29 04:22:34 | Los Rios, Chile | |||
| 2022-09-27 | Chile | Los Rios | 131018 | 1314 | 0 | -40.231 | -72.3311 | 2022-09-28 04:23:01 | Los Rios, Chile | |||
| 2022-09-26 | Chile | Los Rios | 130950 | 1314 | 0 | -40.231 | -72.3311 | 2022-09-27 04:23:01 | Los Rios, Chile | |||
| 2022-08-08 | US | Texas | Montgomery | 48339 | 158266 | 1314 | 0 | 30.30079133 | -95.50572772 | 2022-08-09 04:20:34 | Montgomery, Texas, US | |
| 2022-08-07 | US | Texas | Montgomery | 48339 | 157833 | 1314 | 0 | 30.30079133 | -95.50572772 | 2022-08-08 04:21:08 | Montgomery, Texas, US | |
| 2022-08-06 | US | Texas | Montgomery | 48339 | 157833 | 1314 | 0 | 30.30079133 | -95.50572772 | 2022-08-07 04:20:54 | Montgomery, Texas, US | |
| 2022-08-05 | US | Texas | Montgomery | 48339 | 157833 | 1314 | 0 | 30.30079133 | -95.50572772 | 2022-08-06 04:20:56 | Montgomery, Texas, US | |
| 2022-08-04 | US | Texas | Montgomery | 48339 | 157661 | 1314 | 0 | 30.30079133 | -95.50572772 | 2022-08-05 04:20:52 | Montgomery, Texas, US | |
| 2022-08-03 | US | Texas | Montgomery | 48339 | 157485 | 1314 | 0 | 30.30079133 | -95.50572772 | 2022-08-04 04:20:58 | Montgomery, Texas, US | |
| 2022-03-18 | Chile | Coquimbo | 118640 | 1314 | 0 | -29.959 | -71.3389 | 2022-03-19 04:20:47 | Coquimbo, Chile | |||
| 2022-03-13 | US | Tennessee | Knox | 47093 | 126417 | 1314 | 0 | 35.99508821 | -83.94635435 | 2022-03-14 04:20:46 | Knox, Tennessee, US | |
| 2022-03-09 | US | Louisiana | Jefferson | 22051 | 113157 | 1314 | 0 | 29.74075478 | -90.11115756 | 2022-03-10 04:20:48 | Jefferson, Louisiana, US | |
| 2022-03-05 | US | Pennsylvania | Luzerne | 42079 | 72979 | 1314 | 0 | 41.17823008 | -75.98447579 | 2022-03-06 04:20:49 | Luzerne, Pennsylvania, US | |
| 2022-03-04 | US | Pennsylvania | Luzerne | 42079 | 72943 | 1314 | 0 | 41.17823008 | -75.98447579 | 2022-03-05 04:21:10 | Luzerne, Pennsylvania, US | |
| 2022-02-23 | Suriname | 77935 | 1314 | 0 | 3.9193 | -56.0278 | 2022-02-24 04:21:14 | Suriname | ||||
| 2022-02-22 | Suriname | 77880 | 1314 | 0 | 3.9193 | -56.0278 | 2022-02-23 04:21:09 | Suriname | ||||
| 2022-02-21 | US | District of Columbia | District of Columbia | 11001 | 133697 | 1314 | 0 | 38.90417773 | -77.01655992 | 2022-02-22 04:21:01 | District of Columbia, District of Columbia ,US | |
| 2022-02-21 | Suriname | 77810 | 1314 | 0 | 3.9193 | -56.0278 | 2022-02-22 04:21:01 | Suriname | ||||
| 2022-02-20 | US | District of Columbia | District of Columbia | 11001 | 133697 | 1314 | 0 | 38.90417773 | -77.01655992 | 2022-02-21 04:21:05 | District of Columbia, District of Columbia ,US | |
| 2022-02-19 | US | District of Columbia | District of Columbia | 11001 | 133697 | 1314 | 0 | 38.90417773 | -77.01655992 | 2022-02-20 04:21:00 | District of Columbia, District of Columbia ,US | |
| 2022-02-18 | US | District of Columbia | District of Columbia | 11001 | 133697 | 1314 | 0 | 38.90417773 | -77.01655992 | 2022-02-19 04:21:11 | District of Columbia, District of Columbia ,US | |
| 2022-02-08 | US | Arizona | Mohave | 4015 | 55142 | 1314 | 0 | 35.70471703 | -113.7577902 | 2022-02-09 04:21:04 | Mohave, Arizona, US | |
| 2022-02-07 | Russia | Kaluga Oblast | 78068 | 1314 | 0 | 54.438277299999996 | 35.5272854 | 2022-02-08 04:21:15 | Kaluga Oblast, Russia | |||
| 2022-02-06 | US | Colorado | Jefferson | 8059 | 125503 | 1314 | 0 | 39.58635604 | -105.2517692 | 2022-02-07 04:21:05 | Jefferson, Colorado, US | |
| 2022-02-05 | US | Colorado | Jefferson | 8059 | 125413 | 1314 | 0 | 39.58635604 | -105.2517692 | 2022-02-06 04:21:00 | Jefferson, Colorado, US | |
| 2022-02-02 | Chile | Antofagasta | 93296 | 1314 | 0 | -23.6509 | -70.3975 | 2022-02-03 04:21:21 | Antofagasta, Chile | |||
| 2022-02-01 | Chile | Antofagasta | 91901 | 1314 | 0 | -23.6509 | -70.3975 | 2022-02-02 04:21:09 | Antofagasta, Chile | |||
| 2022-01-31 | Chile | Antofagasta | 90876 | 1314 | 0 | -23.6509 | -70.3975 | 2022-02-01 04:21:11 | Antofagasta, Chile | |||
| 2022-01-24 | Germany | Saarland | 91626 | 1314 | 0 | 49.3964 | 7.023 | 2022-01-25 04:21:05 | Saarland, Germany | |||
| 2022-01-09 | US | Texas | Nueces | 48355 | 62149 | 1314 | 0 | 27.736286 | -97.5433285 | 2022-01-10 04:22:07 | Nueces, Texas, US | |
| 2022-01-08 | US | Texas | Nueces | 48355 | 61533 | 1314 | 0 | 27.736286 | -97.5433285 | 2022-01-09 04:21:46 | Nueces, Texas, US | |
| 2022-01-07 | US | Texas | Nueces | 48355 | 60734 | 1314 | 0 | 27.736286 | -97.5433285 | 2022-01-08 04:21:53 | Nueces, Texas, US | |
| 2022-01-06 | US | Texas | Nueces | 48355 | 60212 | 1314 | 0 | 27.736286 | -97.5433285 | 2022-01-07 04:22:09 | Nueces, Texas, US | |
| 2022-01-06 | Italy | P.A. Bolzano | 106683 | 1314 | 0 | 46.49933453 | 11.35662422 | 2022-01-07 04:22:09 | P.A. Bolzano, Italy | |||
| 2022-01-05 | US | Texas | Nueces | 48355 | 59424 | 1314 | 0 | 27.736286 | -97.5433285 | 2022-01-06 04:22:09 | Nueces, Texas, US | |
| 2022-01-02 | US | Utah | Salt Lake | 49035 | 226602 | 1314 | 0 | 40.66616532 | -111.92160109999999 | 2022-01-03 02:22:25 | Salt Lake, Utah, US | |
| 2022-01-02 | US | North Carolina | Mecklenburg | 37119 | 179247 | 1314 | 0 | 35.24469268 | -80.8317671 | 2022-01-03 02:22:25 | Mecklenburg, North Carolina, US | |
| 2022-01-01 | US | Utah | Salt Lake | 49035 | 226602 | 1314 | 0 | 40.66616532 | -111.92160109999999 | 2022-01-02 04:20:52 | Salt Lake, Utah, US | |
| 2022-01-01 | US | North Carolina | Mecklenburg | 37119 | 179247 | 1314 | 0 | 35.24469268 | -80.8317671 | 2022-01-02 04:20:52 | Mecklenburg, North Carolina, US | |
| 2021-12-31 | US | Utah | Salt Lake | 49035 | 226602 | 1314 | 0 | 40.66616532 | -111.92160109999999 | 2022-01-01 04:22:14 | Salt Lake, Utah, US | |
| 2021-12-31 | US | North Carolina | Mecklenburg | 37119 | 179247 | 1314 | 0 | 35.24469268 | -80.8317671 | 2022-01-01 04:22:14 | Mecklenburg, North Carolina, US | |
| 2021-12-30 | US | Utah | Salt Lake | 49035 | 226602 | 1314 | 0 | 40.66616532 | -111.92160109999999 | 2021-12-31 04:21:50 | Salt Lake, Utah, US | |
| 2021-12-30 | US | North Carolina | Mecklenburg | 37119 | 179247 | 1314 | 0 | 35.24469268 | -80.8317671 | 2021-12-31 04:21:50 | Mecklenburg, North Carolina, US | |
| 2021-12-29 | US | North Carolina | Mecklenburg | 37119 | 176994 | 1314 | 0 | 35.24469268 | -80.8317671 | 2021-12-30 04:21:25 | Mecklenburg, North Carolina, US | |
| 2021-12-28 | US | North Carolina | Mecklenburg | 37119 | 175555 | 1314 | 0 | 35.24469268 | -80.8317671 | 2021-12-29 03:21:43 | Mecklenburg, North Carolina, US | |
| 2021-12-20 | US | Massachusetts | Plymouth | 25023 | 72553 | 1314 | 0 | 41.94070556 | -70.80802823 | 2021-12-21 03:21:27 | Plymouth, Massachusetts, US | |
| 2021-12-14 | Russia | Kabardino-Balkarian Republic | 40359 | 1314 | 0 | 43.480604799999995 | 43.5978976 | 2021-12-15 03:22:16 | Kabardino-Balkarian Republic, Russia | |||
| 2021-12-07 | Japan | Kanagawa | 169338 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-08 04:22:46 | Kanagawa, Japan | |||
| 2021-12-06 | Japan | Kanagawa | 169329 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-07 04:22:34 | Kanagawa, Japan | |||
| 2021-12-05 | Japan | Kanagawa | 169323 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-06 04:22:34 | Kanagawa, Japan | |||
| 2021-12-04 | Japan | Kanagawa | 169318 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-05 04:22:25 | Kanagawa, Japan | |||
| 2021-12-03 | Russia | Orel Oblast | 64197 | 1314 | 0 | 52.96854329999999 | 36.0692477 | 2021-12-04 04:22:18 | Orel Oblast, Russia | |||
| 2021-12-03 | Japan | Kanagawa | 169306 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-04 04:22:18 | Kanagawa, Japan | |||
| 2021-12-02 | Japan | Kanagawa | 169295 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-03 04:23:05 | Kanagawa, Japan | |||
| 2021-12-01 | Japan | Kanagawa | 169285 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-02 04:22:37 | Kanagawa, Japan | |||
| 2021-11-30 | Japan | Kanagawa | 169274 | 1314 | 0 | 35.415312 | 139.338983 | 2021-12-01 04:22:29 | Kanagawa, Japan | |||
| 2021-11-22 | US | New Jersey | Morris | 34027 | 60179 | 1314 | 0 | 40.86095313 | -74.54553709999998 | 2021-11-23 04:22:39 | Morris, New Jersey, US | |
| 2021-11-20 | Russia | Tambov Oblast | 52567 | 1314 | 0 | 52.9019574 | 41.3578918 | 2021-11-21 04:22:13 | Tambov Oblast, Russia | |||
| 2021-10-28 | Russia | Khanty-Mansi Autonomous Okrug | 81361 | 1314 | 0 | 61.0259025 | 69.0982628 | 2021-10-29 04:22:03 | Khanty-Mansi Autonomous Okrug, Russia | |||
| 2021-10-28 | Russia | Khakassia Republic | 43132 | 1314 | 0 | 53.72258845 | 91.44293627 | 2021-10-29 04:22:03 | Khakassia Republic, Russia | |||
| 2021-10-26 | Netherlands | Utrecht | 162945 | 1314 | 0 | 52.084251 | 5.163824 | 2021-10-27 04:22:32 | Utrecht, Netherlands | |||
| 2021-10-20 | Rwanda | 99252 | 1314 | 0 | -1.9403 | 29.8739 | 2021-10-21 04:21:18 | Rwanda | ||||
| 2021-10-19 | Rwanda | 99213 | 1314 | 0 | -1.9403 | 29.8739 | 2021-10-20 04:21:00 | Rwanda | ||||
| 2021-10-05 | US | Maryland | Baltimore City | 24510 | 59635 | 1314 | 0 | 39.30211911 | -76.61151012 | 2021-10-06 04:21:33 | Baltimore City, Maryland, US | |
| 2021-10-04 | US | Maryland | Baltimore City | 24510 | 59561 | 1314 | 0 | 39.30211911 | -76.61151012 | 2021-10-05 04:21:27 | Baltimore City, Maryland, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;