daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
429 rows where confirmed = 1315 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-29 | US | Kentucky | Carlisle | 21039 | 1315 | 23 | 0 | 36.85372876 | -88.9669222 | 2022-12-30 04:21:04 | Carlisle, Kentucky, US | |
2022-12-28 | US | Kentucky | Carlisle | 21039 | 1315 | 23 | 0 | 36.85372876 | -88.9669222 | 2022-12-29 04:21:01 | Carlisle, Kentucky, US | |
2022-12-27 | US | Kentucky | Carlisle | 21039 | 1315 | 23 | 0 | 36.85372876 | -88.9669222 | 2022-12-28 04:21:04 | Carlisle, Kentucky, US | |
2022-10-11 | US | Kansas | Gray | 20069 | 1315 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-10-12 04:22:51 | Gray, Kansas, US | |
2022-10-10 | US | Kansas | Gray | 20069 | 1315 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-10-11 04:23:05 | Gray, Kansas, US | |
2022-10-09 | US | Kansas | Gray | 20069 | 1315 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-10-10 04:22:32 | Gray, Kansas, US | |
2022-10-08 | US | Kansas | Gray | 20069 | 1315 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-10-09 04:21:16 | Gray, Kansas, US | |
2022-10-07 | US | Kansas | Gray | 20069 | 1315 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-10-08 04:22:56 | Gray, Kansas, US | |
2022-10-06 | US | Kansas | Gray | 20069 | 1315 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-10-07 04:23:08 | Gray, Kansas, US | |
2022-10-05 | US | Kansas | Gray | 20069 | 1315 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-10-06 04:21:22 | Gray, Kansas, US | |
2022-08-29 | US | Virginia | King and Queen | 51097 | 1315 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-08-30 04:21:03 | King and Queen, Virginia, US | |
2022-07-31 | US | Texas | San Saba | 48411 | 1315 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-08-01 04:21:03 | San Saba, Texas, US | |
2022-07-30 | US | Texas | San Saba | 48411 | 1315 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-07-31 04:21:02 | San Saba, Texas, US | |
2022-07-29 | US | Texas | San Saba | 48411 | 1315 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-07-30 04:20:42 | San Saba, Texas, US | |
2022-07-18 | US | Texas | Goliad | 48175 | 1315 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-07-19 04:20:58 | Goliad, Texas, US | |
2022-07-12 | US | Iowa | Wayne | 19185 | 1315 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-13 04:20:58 | Wayne, Iowa, US | |
2022-07-11 | US | Texas | Garza | 48169 | 1315 | 28 | 0 | 33.17969345 | -101.2984114 | 2022-07-12 04:20:51 | Garza, Texas, US | |
2022-07-11 | US | Iowa | Wayne | 19185 | 1315 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-12 04:20:51 | Wayne, Iowa, US | |
2022-07-10 | US | Iowa | Wayne | 19185 | 1315 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-11 04:20:46 | Wayne, Iowa, US | |
2022-07-09 | US | Iowa | Wayne | 19185 | 1315 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-10 04:20:54 | Wayne, Iowa, US | |
2022-07-08 | US | Iowa | Wayne | 19185 | 1315 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-09 04:20:59 | Wayne, Iowa, US | |
2022-07-07 | US | Iowa | Wayne | 19185 | 1315 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-08 04:20:56 | Wayne, Iowa, US | |
2022-07-06 | US | Iowa | Wayne | 19185 | 1315 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-07 04:20:55 | Wayne, Iowa, US | |
2022-07-05 | US | South Dakota | Day | 46037 | 1315 | 35 | 0 | 45.367281 | -97.60737498 | 2022-07-06 04:20:58 | Day, South Dakota, US | |
2022-07-04 | US | South Dakota | Day | 46037 | 1315 | 35 | 0 | 45.367281 | -97.60737498 | 2022-07-05 04:20:45 | Day, South Dakota, US | |
2022-07-03 | US | South Dakota | Day | 46037 | 1315 | 35 | 0 | 45.367281 | -97.60737498 | 2022-07-04 04:20:54 | Day, South Dakota, US | |
2022-07-02 | US | South Dakota | Day | 46037 | 1315 | 35 | 0 | 45.367281 | -97.60737498 | 2022-07-03 04:20:59 | Day, South Dakota, US | |
2022-07-01 | US | South Dakota | Day | 46037 | 1315 | 35 | 0 | 45.367281 | -97.60737498 | 2022-07-02 04:21:16 | Day, South Dakota, US | |
2022-06-30 | US | South Dakota | Day | 46037 | 1315 | 35 | 0 | 45.367281 | -97.60737498 | 2022-07-01 04:21:10 | Day, South Dakota, US | |
2022-06-30 | US | Oregon | Wallowa | 41063 | 1315 | 16 | 0 | 45.57894064 | -117.183538 | 2022-07-01 04:21:10 | Wallowa, Oregon, US | |
2022-06-29 | US | South Dakota | Day | 46037 | 1315 | 35 | 0 | 45.367281 | -97.60737498 | 2022-06-30 04:21:01 | Day, South Dakota, US | |
2022-06-28 | US | Nevada | Mineral | 32021 | 1315 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-06-29 04:20:59 | Mineral, Nevada, US | |
2022-06-27 | US | Nevada | Mineral | 32021 | 1315 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-06-28 04:20:58 | Mineral, Nevada, US | |
2022-06-26 | US | Nevada | Mineral | 32021 | 1315 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-06-27 04:21:00 | Mineral, Nevada, US | |
2022-06-25 | US | Nevada | Mineral | 32021 | 1315 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-06-26 04:21:02 | Mineral, Nevada, US | |
2022-06-24 | US | Nevada | Mineral | 32021 | 1315 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-06-25 04:20:57 | Mineral, Nevada, US | |
2022-06-23 | US | Nevada | Mineral | 32021 | 1315 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-06-24 04:20:58 | Mineral, Nevada, US | |
2022-06-22 | US | Nevada | Mineral | 32021 | 1315 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-06-23 04:20:55 | Mineral, Nevada, US | |
2022-05-31 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-06-01 04:20:55 | Walworth, South Dakota, US | |
2022-05-30 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-31 04:20:51 | Walworth, South Dakota, US | |
2022-05-29 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-30 04:20:50 | Walworth, South Dakota, US | |
2022-05-28 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-29 04:20:53 | Walworth, South Dakota, US | |
2022-05-27 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-28 04:21:07 | Walworth, South Dakota, US | |
2022-05-26 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-27 04:20:56 | Walworth, South Dakota, US | |
2022-05-25 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-26 04:20:50 | Walworth, South Dakota, US | |
2022-05-24 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-25 04:20:56 | Walworth, South Dakota, US | |
2022-05-23 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-24 04:20:57 | Walworth, South Dakota, US | |
2022-05-22 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-26 04:20:50 | Walworth, South Dakota, US | |
2022-05-21 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-22 04:20:52 | Walworth, South Dakota, US | |
2022-05-20 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-21 04:20:58 | Walworth, South Dakota, US | |
2022-05-19 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-20 04:20:57 | Walworth, South Dakota, US | |
2022-05-18 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-19 04:20:54 | Walworth, South Dakota, US | |
2022-05-17 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-18 04:20:50 | Walworth, South Dakota, US | |
2022-05-16 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-17 04:20:59 | Walworth, South Dakota, US | |
2022-05-15 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-16 04:20:47 | Walworth, South Dakota, US | |
2022-05-14 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-15 04:20:53 | Walworth, South Dakota, US | |
2022-05-13 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-14 04:20:48 | Walworth, South Dakota, US | |
2022-05-12 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-13 04:20:51 | Walworth, South Dakota, US | |
2022-05-11 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-12 04:20:54 | Walworth, South Dakota, US | |
2022-05-10 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-11 04:20:48 | Walworth, South Dakota, US | |
2022-05-10 | US | Iowa | Taylor | 19173 | 1315 | 22 | 0 | 40.73710579 | -94.69778563 | 2022-05-11 04:20:48 | Taylor, Iowa, US | |
2022-05-09 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-10 04:20:50 | Walworth, South Dakota, US | |
2022-05-09 | US | Iowa | Taylor | 19173 | 1315 | 22 | 0 | 40.73710579 | -94.69778563 | 2022-05-10 04:20:50 | Taylor, Iowa, US | |
2022-05-08 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-09 04:20:54 | Walworth, South Dakota, US | |
2022-05-08 | US | Iowa | Taylor | 19173 | 1315 | 22 | 0 | 40.73710579 | -94.69778563 | 2022-05-09 04:20:54 | Taylor, Iowa, US | |
2022-05-07 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-08 04:20:49 | Walworth, South Dakota, US | |
2022-05-07 | US | Iowa | Taylor | 19173 | 1315 | 22 | 0 | 40.73710579 | -94.69778563 | 2022-05-08 04:20:49 | Taylor, Iowa, US | |
2022-05-06 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-07 04:21:09 | Walworth, South Dakota, US | |
2022-05-06 | US | Iowa | Taylor | 19173 | 1315 | 22 | 0 | 40.73710579 | -94.69778563 | 2022-05-07 04:21:09 | Taylor, Iowa, US | |
2022-05-05 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-06 04:21:00 | Walworth, South Dakota, US | |
2022-05-05 | US | Iowa | Taylor | 19173 | 1315 | 22 | 0 | 40.73710579 | -94.69778563 | 2022-05-06 04:21:00 | Taylor, Iowa, US | |
2022-05-04 | US | South Dakota | Walworth | 46129 | 1315 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-05-05 04:20:55 | Walworth, South Dakota, US | |
2022-05-04 | US | Iowa | Taylor | 19173 | 1315 | 22 | 0 | 40.73710579 | -94.69778563 | 2022-05-05 04:20:55 | Taylor, Iowa, US | |
2022-04-19 | US | South Dakota | Kingsbury | 46077 | 1315 | 21 | 0 | 44.36956169 | -97.4913945 | 2022-04-20 04:20:45 | Kingsbury, South Dakota, US | |
2022-04-18 | US | South Dakota | Kingsbury | 46077 | 1315 | 21 | 0 | 44.36956169 | -97.4913945 | 2022-04-19 04:21:00 | Kingsbury, South Dakota, US | |
2022-04-17 | US | South Dakota | Kingsbury | 46077 | 1315 | 21 | 0 | 44.36956169 | -97.4913945 | 2022-04-18 04:21:12 | Kingsbury, South Dakota, US | |
2022-04-16 | US | South Dakota | Kingsbury | 46077 | 1315 | 21 | 0 | 44.36956169 | -97.4913945 | 2022-04-17 04:20:59 | Kingsbury, South Dakota, US | |
2022-04-15 | US | South Dakota | Kingsbury | 46077 | 1315 | 21 | 0 | 44.36956169 | -97.4913945 | 2022-04-16 04:20:48 | Kingsbury, South Dakota, US | |
2022-04-14 | US | South Dakota | Kingsbury | 46077 | 1315 | 21 | 0 | 44.36956169 | -97.4913945 | 2022-04-15 04:20:57 | Kingsbury, South Dakota, US | |
2022-04-13 | US | South Dakota | Kingsbury | 46077 | 1315 | 21 | 0 | 44.36956169 | -97.4913945 | 2022-04-13 23:21:06 | Kingsbury, South Dakota, US | |
2022-03-11 | US | Puerto Rico | Guanica | 72055 | 1315 | 0 | 0 | 17.982429 | -66.91964300000001 | 2022-03-12 04:20:50 | Guanica, Puerto Rico, US | |
2022-02-27 | US | North Dakota | Sioux | 38085 | 1315 | 19 | 0 | 46.11323337 | -101.04401490000001 | 2022-02-28 04:21:05 | Sioux, North Dakota, US | |
2022-02-26 | US | North Dakota | Sioux | 38085 | 1315 | 19 | 0 | 46.11323337 | -101.04401490000001 | 2022-02-27 04:21:04 | Sioux, North Dakota, US | |
2022-02-17 | US | Texas | Hartley | 48205 | 1315 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-02-18 04:21:04 | Hartley, Texas, US | |
2022-02-06 | US | South Dakota | McCook | 46087 | 1315 | 30 | 0 | 43.6742571 | -97.36863144 | 2022-02-07 04:21:05 | McCook, South Dakota, US | |
2022-02-05 | US | South Dakota | McCook | 46087 | 1315 | 30 | 0 | 43.6742571 | -97.36863144 | 2022-02-06 04:21:00 | McCook, South Dakota, US | |
2022-02-04 | US | South Dakota | McCook | 46087 | 1315 | 30 | 0 | 43.6742571 | -97.36863144 | 2022-02-05 04:21:05 | McCook, South Dakota, US | |
2022-01-23 | US | Kansas | Morris | 20127 | 1315 | 23 | 0 | 38.68827511 | -96.65128437 | 2022-01-24 04:21:12 | Morris, Kansas, US | |
2022-01-22 | US | Kansas | Morris | 20127 | 1315 | 23 | 0 | 38.68827511 | -96.65128437 | 2022-01-23 04:21:13 | Morris, Kansas, US | |
2022-01-21 | US | Kansas | Morris | 20127 | 1315 | 23 | 0 | 38.68827511 | -96.65128437 | 2022-01-22 04:21:13 | Morris, Kansas, US | |
2022-01-19 | US | North Dakota | Bottineau | 38009 | 1315 | 24 | 0 | 48.79106111 | -100.8378166 | 2022-01-20 04:21:07 | Bottineau, North Dakota, US | |
2022-01-18 | US | Wyoming | Weston | 56045 | 1315 | 16 | 0 | 43.83961191 | -104.56748809999999 | 2022-01-19 04:21:23 | Weston, Wyoming, US | |
2022-01-10 | US | Illinois | Brown | 17009 | 1315 | 13 | 0 | 39.96209138 | -90.75068024 | 2022-01-11 04:22:01 | Brown, Illinois, US | |
2022-01-05 | US | Puerto Rico | Rincon | 72117 | 1315 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-01-06 04:22:09 | Rincon, Puerto Rico, US | |
2021-12-29 | US | West Virginia | Tucker | 54093 | 1315 | 32 | 0 | 39.11240885 | -79.57053576 | 2021-12-30 04:21:25 | Tucker, West Virginia, US | |
2021-12-29 | US | North Carolina | Camden | 37029 | 1315 | 9 | 0 | 36.33804939 | -76.15568396 | 2021-12-30 04:21:25 | Camden, North Carolina, US | |
2021-12-28 | China | Sichuan | 1315 | 3 | 0 | 30.6171 | 102.7103 | 2021-12-29 03:21:43 | Sichuan, China | |||
2021-12-26 | US | South Dakota | Hutchinson | 46067 | 1315 | 29 | 0 | 43.33449012 | -97.75536441 | 2021-12-27 04:21:58 | Hutchinson, South Dakota, US | |
2021-12-25 | US | South Dakota | Hutchinson | 46067 | 1315 | 29 | 0 | 43.33449012 | -97.75536441 | 2021-12-26 04:21:50 | Hutchinson, South Dakota, US | |
2021-12-24 | US | South Dakota | Hutchinson | 46067 | 1315 | 29 | 0 | 43.33449012 | -97.75536441 | 2021-12-25 04:21:37 | Hutchinson, South Dakota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;