daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
502 rows where confirmed = 1284 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-27 | US | Texas | Donley | 48129 | 1284 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-12-28 04:21:04 | Donley, Texas, US | |
2022-12-26 | US | Texas | Donley | 48129 | 1284 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-12-27 04:21:07 | Donley, Texas, US | |
2022-12-25 | US | Texas | Donley | 48129 | 1284 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-12-26 04:21:06 | Donley, Texas, US | |
2022-12-24 | US | Texas | Donley | 48129 | 1284 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-12-25 04:21:04 | Donley, Texas, US | |
2022-12-23 | US | Texas | Donley | 48129 | 1284 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-12-24 04:21:02 | Donley, Texas, US | |
2022-12-22 | US | Texas | Donley | 48129 | 1284 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-12-23 04:21:04 | Donley, Texas, US | |
2022-12-21 | US | Texas | Donley | 48129 | 1284 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-12-22 04:20:56 | Donley, Texas, US | |
2022-11-20 | US | Virginia | Rappahannock | 51157 | 1284 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-11-21 04:21:05 | Rappahannock, Virginia, US | |
2022-11-19 | US | Virginia | Rappahannock | 51157 | 1284 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-11-20 04:21:08 | Rappahannock, Virginia, US | |
2022-11-18 | US | Virginia | Rappahannock | 51157 | 1284 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-11-19 04:21:14 | Rappahannock, Virginia, US | |
2022-11-17 | US | Wisconsin | Florence | 55037 | 1284 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-11-18 04:21:15 | Florence, Wisconsin, US | |
2022-10-25 | US | Pennsylvania | Sullivan | 42113 | 1284 | 37 | 0 | 41.44634738 | -76.51246591 | 2022-10-26 04:22:19 | Sullivan, Pennsylvania, US | |
2022-10-24 | US | Pennsylvania | Sullivan | 42113 | 1284 | 37 | 0 | 41.44634738 | -76.51246591 | 2022-10-25 04:21:53 | Sullivan, Pennsylvania, US | |
2022-10-23 | US | Pennsylvania | Sullivan | 42113 | 1284 | 37 | 0 | 41.44634738 | -76.51246591 | 2022-10-24 04:22:29 | Sullivan, Pennsylvania, US | |
2022-10-22 | US | Pennsylvania | Sullivan | 42113 | 1284 | 37 | 0 | 41.44634738 | -76.51246591 | 2022-10-23 04:22:46 | Sullivan, Pennsylvania, US | |
2022-10-21 | US | Pennsylvania | Sullivan | 42113 | 1284 | 37 | 0 | 41.44634738 | -76.51246591 | 2022-10-22 04:22:53 | Sullivan, Pennsylvania, US | |
2022-10-20 | US | Pennsylvania | Sullivan | 42113 | 1284 | 37 | 0 | 41.44634738 | -76.51246591 | 2022-10-21 04:22:23 | Sullivan, Pennsylvania, US | |
2022-10-19 | US | Pennsylvania | Sullivan | 42113 | 1284 | 37 | 0 | 41.44634738 | -76.51246591 | 2022-10-20 04:22:59 | Sullivan, Pennsylvania, US | |
2022-10-11 | US | Nevada | Lander | 32015 | 1284 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-10-12 04:22:51 | Lander, Nevada, US | |
2022-10-10 | US | Nevada | Lander | 32015 | 1284 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-10-11 04:23:05 | Lander, Nevada, US | |
2022-10-09 | US | Nevada | Lander | 32015 | 1284 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-10-10 04:22:32 | Lander, Nevada, US | |
2022-10-08 | US | Nevada | Lander | 32015 | 1284 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-10-09 04:21:16 | Lander, Nevada, US | |
2022-10-07 | US | Nevada | Lander | 32015 | 1284 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-10-08 04:22:56 | Lander, Nevada, US | |
2022-10-06 | US | Nevada | Lander | 32015 | 1284 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-10-07 04:23:08 | Lander, Nevada, US | |
2022-10-05 | US | Nevada | Lander | 32015 | 1284 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-10-06 04:21:22 | Lander, Nevada, US | |
2022-10-04 | US | Virginia | Surry | 51181 | 1284 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-10-05 04:23:06 | Surry, Virginia, US | |
2022-10-03 | US | Virginia | Surry | 51181 | 1284 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-10-04 04:22:55 | Surry, Virginia, US | |
2022-09-13 | US | Kansas | Stafford | 20185 | 1284 | 29 | 0 | 38.03100851 | -98.71762001 | 2022-09-14 04:20:44 | Stafford, Kansas, US | |
2022-09-12 | US | Kansas | Stafford | 20185 | 1284 | 29 | 0 | 38.03100851 | -98.71762001 | 2022-09-13 04:20:57 | Stafford, Kansas, US | |
2022-09-11 | US | Kansas | Stafford | 20185 | 1284 | 29 | 0 | 38.03100851 | -98.71762001 | 2022-09-12 04:20:58 | Stafford, Kansas, US | |
2022-09-10 | US | Kansas | Stafford | 20185 | 1284 | 29 | 0 | 38.03100851 | -98.71762001 | 2022-09-11 04:20:50 | Stafford, Kansas, US | |
2022-09-09 | US | Kansas | Stafford | 20185 | 1284 | 29 | 0 | 38.03100851 | -98.71762001 | 2022-09-10 04:21:10 | Stafford, Kansas, US | |
2022-09-08 | US | Kansas | Stafford | 20185 | 1284 | 29 | 0 | 38.03100851 | -98.71762001 | 2022-09-09 04:21:11 | Stafford, Kansas, US | |
2022-09-07 | US | Kansas | Stafford | 20185 | 1284 | 29 | 0 | 38.03100851 | -98.71762001 | 2022-09-08 04:21:02 | Stafford, Kansas, US | |
2022-08-21 | US | Illinois | Putnam | 17155 | 1284 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-08-22 04:20:38 | Putnam, Illinois, US | |
2022-08-20 | US | Illinois | Putnam | 17155 | 1284 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-08-21 04:20:44 | Putnam, Illinois, US | |
2022-08-19 | US | Illinois | Putnam | 17155 | 1284 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-08-20 04:21:01 | Putnam, Illinois, US | |
2022-07-27 | US | Illinois | Henderson | 17071 | 1284 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-28 04:20:56 | Henderson, Illinois, US | |
2022-07-26 | US | Illinois | Henderson | 17071 | 1284 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-27 04:21:04 | Henderson, Illinois, US | |
2022-07-16 | US | Puerto Rico | Vieques | 72147 | 1284 | 0 | 0 | 18.123276 | -65.440971 | 2022-07-17 04:21:15 | Vieques, Puerto Rico, US | |
2022-07-15 | US | Puerto Rico | Vieques | 72147 | 1284 | 0 | 0 | 18.123276 | -65.440971 | 2022-07-16 04:21:05 | Vieques, Puerto Rico, US | |
2022-06-14 | US | Nevada | Mineral | 32021 | 1284 | 17 | 0 | 38.53841696 | -118.4344506 | 2022-06-15 04:20:54 | Mineral, Nevada, US | |
2022-06-13 | US | Nevada | Mineral | 32021 | 1284 | 17 | 0 | 38.53841696 | -118.4344506 | 2022-06-14 04:20:52 | Mineral, Nevada, US | |
2022-06-12 | US | Nevada | Mineral | 32021 | 1284 | 17 | 0 | 38.53841696 | -118.4344506 | 2022-06-13 04:21:14 | Mineral, Nevada, US | |
2022-06-11 | US | Nevada | Mineral | 32021 | 1284 | 17 | 0 | 38.53841696 | -118.4344506 | 2022-06-12 04:20:53 | Mineral, Nevada, US | |
2022-06-10 | US | Nevada | Mineral | 32021 | 1284 | 17 | 0 | 38.53841696 | -118.4344506 | 2022-06-11 04:21:01 | Mineral, Nevada, US | |
2022-06-09 | US | Nevada | Mineral | 32021 | 1284 | 17 | 0 | 38.53841696 | -118.4344506 | 2022-06-10 04:20:55 | Mineral, Nevada, US | |
2022-06-08 | US | Nevada | Mineral | 32021 | 1284 | 17 | 0 | 38.53841696 | -118.4344506 | 2022-06-09 04:20:54 | Mineral, Nevada, US | |
2022-06-07 | US | Kansas | Scott | 20171 | 1284 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-06-08 04:20:55 | Scott, Kansas, US | |
2022-06-06 | US | Kansas | Scott | 20171 | 1284 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-06-07 04:21:08 | Scott, Kansas, US | |
2022-06-05 | US | Kansas | Scott | 20171 | 1284 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-06-06 04:20:57 | Scott, Kansas, US | |
2022-06-04 | US | Texas | Garza | 48169 | 1284 | 28 | 0 | 33.17969345 | -101.2984114 | 2022-06-05 04:20:55 | Garza, Texas, US | |
2022-06-04 | US | Kansas | Scott | 20171 | 1284 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-06-05 04:20:55 | Scott, Kansas, US | |
2022-06-03 | US | Kansas | Scott | 20171 | 1284 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-06-04 04:20:58 | Scott, Kansas, US | |
2022-06-02 | US | Kansas | Scott | 20171 | 1284 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-06-03 04:20:58 | Scott, Kansas, US | |
2022-06-01 | US | Kansas | Scott | 20171 | 1284 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-06-02 05:20:39 | Scott, Kansas, US | |
2022-05-26 | US | Montana | Broadwater | 30007 | 1284 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-27 04:20:56 | Broadwater, Montana, US | |
2022-05-25 | US | Montana | Broadwater | 30007 | 1284 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-26 04:20:50 | Broadwater, Montana, US | |
2022-05-25 | US | Illinois | Scott | 17171 | 1284 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-05-26 04:20:50 | Scott, Illinois, US | |
2022-05-24 | US | Montana | Broadwater | 30007 | 1284 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-25 04:20:56 | Broadwater, Montana, US | |
2022-05-24 | US | Illinois | Scott | 17171 | 1284 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-05-25 04:20:56 | Scott, Illinois, US | |
2022-05-23 | US | Montana | Broadwater | 30007 | 1284 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-24 04:20:57 | Broadwater, Montana, US | |
2022-05-23 | US | Illinois | Scott | 17171 | 1284 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-05-24 04:20:57 | Scott, Illinois, US | |
2022-05-22 | US | Montana | Broadwater | 30007 | 1284 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-26 04:20:50 | Broadwater, Montana, US | |
2022-05-22 | US | Illinois | Scott | 17171 | 1284 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-05-26 04:20:50 | Scott, Illinois, US | |
2022-05-21 | US | Montana | Broadwater | 30007 | 1284 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-22 04:20:52 | Broadwater, Montana, US | |
2022-05-21 | US | Illinois | Scott | 17171 | 1284 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-05-22 04:20:52 | Scott, Illinois, US | |
2022-05-20 | US | Montana | Broadwater | 30007 | 1284 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-21 04:20:58 | Broadwater, Montana, US | |
2022-05-20 | US | Illinois | Scott | 17171 | 1284 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-05-21 04:20:58 | Scott, Illinois, US | |
2022-05-10 | US | Texas | Crane | 48103 | 1284 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-11 04:20:48 | Crane, Texas, US | |
2022-05-05 | US | Montana | Teton | 30099 | 1284 | 23 | 0 | 47.83741052 | -112.2410688 | 2022-05-06 04:21:00 | Teton, Montana, US | |
2022-05-04 | US | Montana | Teton | 30099 | 1284 | 23 | 0 | 47.83741052 | -112.2410688 | 2022-05-05 04:20:55 | Teton, Montana, US | |
2022-05-02 | US | Virginia | Covington | 51580 | 1284 | 26 | 0 | 37.7824656 | -79.98631446 | 2022-05-03 04:21:00 | Covington, Virginia, US | |
2022-04-26 | US | South Dakota | Day | 46037 | 1284 | 35 | 0 | 45.367281 | -97.60737498 | 2022-04-27 04:20:52 | Day, South Dakota, US | |
2022-04-25 | US | South Dakota | Day | 46037 | 1284 | 35 | 0 | 45.367281 | -97.60737498 | 2022-04-26 04:20:51 | Day, South Dakota, US | |
2022-04-24 | US | South Dakota | Day | 46037 | 1284 | 35 | 0 | 45.367281 | -97.60737498 | 2022-04-25 04:20:56 | Day, South Dakota, US | |
2022-04-23 | US | South Dakota | Day | 46037 | 1284 | 35 | 0 | 45.367281 | -97.60737498 | 2022-04-24 04:20:56 | Day, South Dakota, US | |
2022-04-22 | US | South Dakota | Day | 46037 | 1284 | 35 | 0 | 45.367281 | -97.60737498 | 2022-04-23 04:20:50 | Day, South Dakota, US | |
2022-04-21 | US | South Dakota | Day | 46037 | 1284 | 35 | 0 | 45.367281 | -97.60737498 | 2022-04-22 04:20:45 | Day, South Dakota, US | |
2022-04-20 | US | South Dakota | Day | 46037 | 1284 | 35 | 0 | 45.367281 | -97.60737498 | 2022-04-21 04:20:46 | Day, South Dakota, US | |
2022-04-20 | US | Illinois | Alexander | 17003 | 1284 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-21 04:20:46 | Alexander, Illinois, US | |
2022-04-19 | US | Illinois | Alexander | 17003 | 1284 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-20 04:20:45 | Alexander, Illinois, US | |
2022-04-18 | US | Illinois | Alexander | 17003 | 1284 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-19 04:21:00 | Alexander, Illinois, US | |
2022-04-17 | US | Illinois | Alexander | 17003 | 1284 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-18 04:21:12 | Alexander, Illinois, US | |
2022-04-16 | US | Illinois | Alexander | 17003 | 1284 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-17 04:20:59 | Alexander, Illinois, US | |
2022-04-15 | US | Illinois | Alexander | 17003 | 1284 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-16 04:20:48 | Alexander, Illinois, US | |
2022-04-14 | US | Illinois | Alexander | 17003 | 1284 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-15 04:20:57 | Alexander, Illinois, US | |
2022-04-13 | US | Vermont | Essex | 50009 | 1284 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-04-13 23:21:06 | Essex, Vermont, US | |
2022-04-03 | US | Virginia | Cumberland | 51049 | 1284 | 26 | 0 | 37.51328851 | -78.24398086 | 2022-04-04 04:20:51 | Cumberland, Virginia, US | |
2022-04-02 | US | Virginia | Cumberland | 51049 | 1284 | 26 | 0 | 37.51328851 | -78.24398086 | 2022-04-03 04:20:48 | Cumberland, Virginia, US | |
2022-04-01 | US | Virginia | Cumberland | 51049 | 1284 | 26 | 0 | 37.51328851 | -78.24398086 | 2022-04-02 04:20:47 | Cumberland, Virginia, US | |
2022-03-18 | US | Texas | McCulloch | 48307 | 1284 | 46 | 0 | 31.1925468 | -99.34682807 | 2022-03-19 04:20:47 | McCulloch, Texas, US | |
2022-03-17 | US | Texas | McCulloch | 48307 | 1284 | 46 | 0 | 31.1925468 | -99.34682807 | 2022-03-18 04:20:55 | McCulloch, Texas, US | |
2022-03-16 | US | Texas | McCulloch | 48307 | 1284 | 46 | 0 | 31.1925468 | -99.34682807 | 2022-03-17 04:20:56 | McCulloch, Texas, US | |
2022-03-16 | US | Oklahoma | Greer | 40055 | 1284 | 30 | 0 | 34.93535801 | -99.56056120000001 | 2022-03-17 04:20:56 | Greer, Oklahoma, US | |
2022-03-15 | US | Texas | McCulloch | 48307 | 1284 | 46 | 0 | 31.1925468 | -99.34682807 | 2022-03-16 04:20:50 | McCulloch, Texas, US | |
2022-03-15 | US | Oklahoma | Greer | 40055 | 1284 | 30 | 0 | 34.93535801 | -99.56056120000001 | 2022-03-16 04:20:50 | Greer, Oklahoma, US | |
2022-03-14 | US | Oklahoma | Greer | 40055 | 1284 | 30 | 0 | 34.93535801 | -99.56056120000001 | 2022-03-15 04:20:47 | Greer, Oklahoma, US | |
2022-03-13 | US | Oklahoma | Greer | 40055 | 1284 | 30 | 0 | 34.93535801 | -99.56056120000001 | 2022-03-14 04:20:46 | Greer, Oklahoma, US | |
2022-03-12 | US | Oklahoma | Greer | 40055 | 1284 | 30 | 0 | 34.93535801 | -99.56056120000001 | 2022-03-13 04:20:49 | Greer, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;