daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
516 rows where confirmed = 862 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-04 | US | North Dakota | Eddy | 38027 | 862 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-05 04:20:58 | Eddy, North Dakota, US | |
2022-12-03 | US | North Dakota | Eddy | 38027 | 862 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-04 04:20:56 | Eddy, North Dakota, US | |
2022-12-02 | US | North Dakota | Eddy | 38027 | 862 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-03 04:21:02 | Eddy, North Dakota, US | |
2022-11-17 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-18 04:21:15 | Sheridan, Montana, US | |
2022-11-16 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-17 04:21:11 | Sheridan, Montana, US | |
2022-11-15 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-16 04:21:09 | Sheridan, Montana, US | |
2022-11-14 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-15 04:21:16 | Sheridan, Montana, US | |
2022-11-13 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-14 04:21:09 | Sheridan, Montana, US | |
2022-11-12 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-13 04:21:14 | Sheridan, Montana, US | |
2022-11-11 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-12 04:20:41 | Sheridan, Montana, US | |
2022-11-10 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-11 04:21:22 | Sheridan, Montana, US | |
2022-11-09 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-10 04:21:16 | Sheridan, Montana, US | |
2022-11-08 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-09 04:21:22 | Sheridan, Montana, US | |
2022-11-07 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-08 04:21:21 | Sheridan, Montana, US | |
2022-11-06 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-07 04:21:26 | Sheridan, Montana, US | |
2022-11-05 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-06 04:21:24 | Sheridan, Montana, US | |
2022-11-04 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-05 04:21:52 | Sheridan, Montana, US | |
2022-11-03 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-04 04:22:11 | Sheridan, Montana, US | |
2022-11-02 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-03 04:22:05 | Sheridan, Montana, US | |
2022-11-01 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-02 04:22:09 | Sheridan, Montana, US | |
2022-10-31 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-01 04:22:36 | Sheridan, Montana, US | |
2022-10-30 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-31 04:21:36 | Sheridan, Montana, US | |
2022-10-29 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-30 04:22:14 | Sheridan, Montana, US | |
2022-10-28 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-29 04:21:13 | Sheridan, Montana, US | |
2022-10-27 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-28 04:22:31 | Sheridan, Montana, US | |
2022-10-26 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-27 04:22:01 | Sheridan, Montana, US | |
2022-10-25 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-26 04:22:19 | Sheridan, Montana, US | |
2022-10-24 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-25 04:21:53 | Sheridan, Montana, US | |
2022-10-23 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-24 04:22:29 | Sheridan, Montana, US | |
2022-10-22 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-23 04:22:46 | Sheridan, Montana, US | |
2022-10-21 | US | Montana | Sheridan | 30091 | 862 | 13 | 0 | 48.72085833 | -104.503829 | 2022-10-22 04:22:53 | Sheridan, Montana, US | |
2022-10-19 | US | North Dakota | Nelson | 38063 | 862 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-10-20 04:22:59 | Nelson, North Dakota, US | |
2022-10-18 | US | North Dakota | Nelson | 38063 | 862 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-10-19 04:22:26 | Nelson, North Dakota, US | |
2022-10-11 | US | South Dakota | Aurora | 46003 | 862 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-10-12 04:22:51 | Aurora, South Dakota, US | |
2022-10-10 | US | South Dakota | Aurora | 46003 | 862 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-10-11 04:23:05 | Aurora, South Dakota, US | |
2022-10-09 | US | South Dakota | Aurora | 46003 | 862 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-10-10 04:22:32 | Aurora, South Dakota, US | |
2022-10-08 | US | South Dakota | Aurora | 46003 | 862 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-10-09 04:21:16 | Aurora, South Dakota, US | |
2022-10-07 | US | South Dakota | Aurora | 46003 | 862 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-10-08 04:22:56 | Aurora, South Dakota, US | |
2022-10-06 | US | South Dakota | Aurora | 46003 | 862 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-10-07 04:23:08 | Aurora, South Dakota, US | |
2022-10-06 | US | Montana | Sweet Grass | 30097 | 862 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-10-07 04:23:08 | Sweet Grass, Montana, US | |
2022-10-05 | US | South Dakota | Aurora | 46003 | 862 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-10-06 04:21:22 | Aurora, South Dakota, US | |
2022-10-05 | US | Montana | Sweet Grass | 30097 | 862 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-10-06 04:21:22 | Sweet Grass, Montana, US | |
2022-10-04 | US | Montana | Sweet Grass | 30097 | 862 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-10-05 04:23:06 | Sweet Grass, Montana, US | |
2022-10-03 | US | Montana | Sweet Grass | 30097 | 862 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-10-04 04:22:55 | Sweet Grass, Montana, US | |
2022-10-02 | US | Montana | Sweet Grass | 30097 | 862 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-10-03 04:23:11 | Sweet Grass, Montana, US | |
2022-10-01 | US | Montana | Sweet Grass | 30097 | 862 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-10-02 04:21:23 | Sweet Grass, Montana, US | |
2022-09-30 | US | Montana | Sweet Grass | 30097 | 862 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-10-01 04:23:01 | Sweet Grass, Montana, US | |
2022-08-15 | US | North Dakota | Hettinger | 38041 | 862 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-08-16 04:20:58 | Hettinger, North Dakota, US | |
2022-08-14 | US | North Dakota | Hettinger | 38041 | 862 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-08-15 04:20:59 | Hettinger, North Dakota, US | |
2022-08-13 | US | North Dakota | Hettinger | 38041 | 862 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-08-14 04:20:55 | Hettinger, North Dakota, US | |
2022-08-12 | US | North Dakota | Hettinger | 38041 | 862 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-08-13 04:20:52 | Hettinger, North Dakota, US | |
2022-08-11 | US | North Dakota | Hettinger | 38041 | 862 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-08-12 04:20:54 | Hettinger, North Dakota, US | |
2022-08-04 | US | Texas | Baylor | 48023 | 862 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-08-05 04:20:52 | Baylor, Texas, US | |
2022-07-22 | US | Texas | Sutton | 48435 | 862 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-07-23 04:20:53 | Sutton, Texas, US | |
2022-07-21 | US | Texas | Sutton | 48435 | 862 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-07-22 04:21:15 | Sutton, Texas, US | |
2022-07-10 | US | New Mexico | Mora | 35033 | 862 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-07-11 04:20:46 | Mora, New Mexico, US | |
2022-07-09 | US | New Mexico | Mora | 35033 | 862 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-07-10 04:20:54 | Mora, New Mexico, US | |
2022-07-08 | US | New Mexico | Mora | 35033 | 862 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-07-09 04:20:59 | Mora, New Mexico, US | |
2022-07-07 | US | New Mexico | Mora | 35033 | 862 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-07-08 04:20:56 | Mora, New Mexico, US | |
2022-07-04 | US | North Dakota | Bowman | 38011 | 862 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-07-05 04:20:45 | Bowman, North Dakota, US | |
2022-07-03 | US | North Dakota | Bowman | 38011 | 862 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-07-04 04:20:54 | Bowman, North Dakota, US | |
2022-07-02 | US | North Dakota | Bowman | 38011 | 862 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-07-03 04:20:59 | Bowman, North Dakota, US | |
2022-07-01 | US | North Dakota | Bowman | 38011 | 862 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-07-02 04:21:16 | Bowman, North Dakota, US | |
2022-04-30 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-05-01 04:20:57 | Baca, Colorado, US | |
2022-04-29 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-30 04:21:05 | Baca, Colorado, US | |
2022-04-28 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-29 04:20:59 | Baca, Colorado, US | |
2022-04-27 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-28 04:20:47 | Baca, Colorado, US | |
2022-04-26 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-27 04:20:52 | Baca, Colorado, US | |
2022-04-25 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-26 04:20:51 | Baca, Colorado, US | |
2022-04-24 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-25 04:20:56 | Baca, Colorado, US | |
2022-04-23 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-24 04:20:56 | Baca, Colorado, US | |
2022-04-22 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-23 04:20:50 | Baca, Colorado, US | |
2022-04-21 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-22 04:20:45 | Baca, Colorado, US | |
2022-04-20 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-21 04:20:46 | Baca, Colorado, US | |
2022-04-19 | US | Delaware | Unassigned | 90010 | 862 | 0 | 0 | 39.57992638 | 0.0 | 2022-04-20 04:20:45 | Unassigned, Delaware, US | |
2022-04-19 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-20 04:20:45 | Baca, Colorado, US | |
2022-04-18 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-19 04:21:00 | Baca, Colorado, US | |
2022-04-17 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-18 04:21:12 | Baca, Colorado, US | |
2022-04-16 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-17 04:20:59 | Baca, Colorado, US | |
2022-04-15 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-16 04:20:48 | Baca, Colorado, US | |
2022-04-14 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-15 04:20:57 | Baca, Colorado, US | |
2022-04-13 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-13 23:21:06 | Baca, Colorado, US | |
2022-04-12 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-13 04:21:03 | Baca, Colorado, US | |
2022-04-11 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-12 04:20:49 | Baca, Colorado, US | |
2022-04-10 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-11 04:21:02 | Baca, Colorado, US | |
2022-04-09 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-10 04:20:52 | Baca, Colorado, US | |
2022-04-08 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-09 04:20:42 | Baca, Colorado, US | |
2022-04-07 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-08 04:20:48 | Baca, Colorado, US | |
2022-04-06 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-07 04:20:53 | Baca, Colorado, US | |
2022-04-05 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-06 04:20:49 | Baca, Colorado, US | |
2022-04-04 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-05 04:20:48 | Baca, Colorado, US | |
2022-04-03 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-04 04:20:51 | Baca, Colorado, US | |
2022-04-02 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-03 04:20:48 | Baca, Colorado, US | |
2022-04-01 | US | Colorado | Baca | 8009 | 862 | 13 | 0 | 37.31940883 | -102.5603223 | 2022-04-02 04:20:47 | Baca, Colorado, US | |
2022-03-23 | US | New York | Hamilton | 36041 | 862 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-03-24 04:20:43 | Hamilton, New York, US | |
2022-03-22 | US | New York | Hamilton | 36041 | 862 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-03-23 04:20:48 | Hamilton, New York, US | |
2022-03-04 | US | Texas | Cochran | 48079 | 862 | 23 | 0 | 33.60425307 | -102.82844990000001 | 2022-03-05 04:21:10 | Cochran, Texas, US | |
2022-02-17 | US | Vermont | Grand Isle | 50013 | 862 | 4 | 0 | 44.797582399999996 | -73.29679772 | 2022-02-18 04:21:04 | Grand Isle, Vermont, US | |
2022-02-03 | US | Arkansas | Calhoun | 5013 | 862 | 9 | 0 | 33.55598792 | -92.49974403 | 2022-02-04 04:21:10 | Calhoun, Arkansas, US | |
2022-02-03 | US | Alaska | Copper River | 2066 | 862 | 7 | 0 | 60.3886 | -162.8905196 | 2022-02-04 04:21:10 | Copper River, Alaska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;