daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
557 rows where confirmed = 784 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-06 | US | Kansas | Smith | 20183 | 784 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-12-07 04:20:58 | Smith, Kansas, US | |
2022-12-05 | US | Kansas | Smith | 20183 | 784 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-12-06 04:21:03 | Smith, Kansas, US | |
2022-12-04 | US | Kansas | Smith | 20183 | 784 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-12-05 04:20:58 | Smith, Kansas, US | |
2022-12-03 | US | Kansas | Smith | 20183 | 784 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-12-04 04:20:56 | Smith, Kansas, US | |
2022-12-02 | US | Kansas | Smith | 20183 | 784 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-12-03 04:21:02 | Smith, Kansas, US | |
2022-12-01 | US | Kansas | Smith | 20183 | 784 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-12-02 04:21:07 | Smith, Kansas, US | |
2022-11-30 | US | Kansas | Smith | 20183 | 784 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-12-01 04:21:03 | Smith, Kansas, US | |
2022-11-28 | US | Missouri | Scotland | 29199 | 784 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-29 04:21:05 | Scotland, Missouri, US | |
2022-11-27 | US | Missouri | Scotland | 29199 | 784 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-28 04:21:02 | Scotland, Missouri, US | |
2022-11-26 | US | Missouri | Scotland | 29199 | 784 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-27 04:21:05 | Scotland, Missouri, US | |
2022-11-25 | US | Missouri | Scotland | 29199 | 784 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-26 04:21:11 | Scotland, Missouri, US | |
2022-11-24 | US | Missouri | Scotland | 29199 | 784 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-25 04:21:06 | Scotland, Missouri, US | |
2022-11-23 | US | Missouri | Scotland | 29199 | 784 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-24 04:21:09 | Scotland, Missouri, US | |
2022-11-22 | US | Missouri | Scotland | 29199 | 784 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-23 04:21:06 | Scotland, Missouri, US | |
2022-10-18 | US | Colorado | Custer | 8027 | 784 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-10-19 04:22:26 | Custer, Colorado, US | |
2022-10-17 | US | Colorado | Custer | 8027 | 784 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-10-18 04:22:42 | Custer, Colorado, US | |
2022-10-15 | US | North Dakota | McIntosh | 38051 | 784 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-10-16 04:22:39 | McIntosh, North Dakota, US | |
2022-10-14 | US | North Dakota | McIntosh | 38051 | 784 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-10-15 04:22:00 | McIntosh, North Dakota, US | |
2022-09-25 | US | North Dakota | Emmons | 38029 | 784 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-09-26 04:20:52 | Emmons, North Dakota, US | |
2022-08-04 | US | Texas | Kinney | 48271 | 784 | 12 | 0 | 29.34967888 | -100.4186638 | 2022-08-05 04:20:52 | Kinney, Texas, US | |
2022-07-31 | China | Chongqing | 784 | 6 | 0 | 30.0572 | 107.874 | 2022-08-01 04:21:03 | Chongqing, China | |||
2022-07-30 | China | Chongqing | 784 | 6 | 0 | 30.0572 | 107.874 | 2022-07-31 04:21:02 | Chongqing, China | |||
2022-07-29 | China | Chongqing | 784 | 6 | 0 | 30.0572 | 107.874 | 2022-07-30 04:20:42 | Chongqing, China | |||
2022-07-28 | China | Chongqing | 784 | 6 | 0 | 30.0572 | 107.874 | 2022-07-29 04:20:45 | Chongqing, China | |||
2022-07-18 | US | North Dakota | Eddy | 38027 | 784 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-07-19 04:20:58 | Eddy, North Dakota, US | |
2022-06-26 | US | Colorado | Costilla | 8023 | 784 | 18 | 0 | 37.27732493 | -105.4276548 | 2022-06-27 04:21:00 | Costilla, Colorado, US | |
2022-06-21 | US | Kansas | Ness | 20135 | 784 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-06-22 04:20:54 | Ness, Kansas, US | |
2022-06-20 | US | Kansas | Ness | 20135 | 784 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-06-21 04:20:56 | Ness, Kansas, US | |
2022-06-19 | US | Kansas | Ness | 20135 | 784 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-06-20 04:21:01 | Ness, Kansas, US | |
2022-06-18 | US | Kansas | Ness | 20135 | 784 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-06-19 04:20:51 | Ness, Kansas, US | |
2022-06-17 | US | Kansas | Ness | 20135 | 784 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-06-18 04:21:10 | Ness, Kansas, US | |
2022-06-16 | US | Kansas | Ness | 20135 | 784 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-06-17 04:20:56 | Ness, Kansas, US | |
2022-06-15 | US | Kansas | Ness | 20135 | 784 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-06-16 04:20:55 | Ness, Kansas, US | |
2022-05-03 | US | South Dakota | Aurora | 46003 | 784 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-05-04 04:20:59 | Aurora, South Dakota, US | |
2022-05-02 | US | South Dakota | Aurora | 46003 | 784 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-05-03 04:21:00 | Aurora, South Dakota, US | |
2022-05-01 | US | South Dakota | Aurora | 46003 | 784 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-05-02 04:21:10 | Aurora, South Dakota, US | |
2022-04-30 | US | South Dakota | Aurora | 46003 | 784 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-05-01 04:20:57 | Aurora, South Dakota, US | |
2022-04-29 | US | South Dakota | Aurora | 46003 | 784 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-04-30 04:21:05 | Aurora, South Dakota, US | |
2022-04-28 | US | South Dakota | Aurora | 46003 | 784 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-04-29 04:20:59 | Aurora, South Dakota, US | |
2022-04-27 | US | South Dakota | Aurora | 46003 | 784 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-04-28 04:20:47 | Aurora, South Dakota, US | |
2022-04-27 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-28 04:20:47 | Union, New Mexico, US | |
2022-04-26 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-27 04:20:52 | Union, New Mexico, US | |
2022-04-25 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-26 04:20:51 | Union, New Mexico, US | |
2022-04-24 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-25 04:20:56 | Union, New Mexico, US | |
2022-04-23 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-24 04:20:56 | Union, New Mexico, US | |
2022-04-22 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-23 04:20:50 | Union, New Mexico, US | |
2022-04-21 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-22 04:20:45 | Union, New Mexico, US | |
2022-04-20 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-21 04:20:46 | Union, New Mexico, US | |
2022-04-19 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-20 04:20:45 | Marshall, South Dakota, US | |
2022-04-19 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-20 04:20:45 | Union, New Mexico, US | |
2022-04-18 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-19 04:21:00 | Marshall, South Dakota, US | |
2022-04-18 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-19 04:21:00 | Union, New Mexico, US | |
2022-04-18 | US | Minnesota | Unassigned | 90027 | 784 | 250 | 0 | 48.77754106 | 0.0 | 2022-04-19 04:21:00 | Unassigned, Minnesota, US | |
2022-04-17 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-18 04:21:12 | Marshall, South Dakota, US | |
2022-04-17 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-18 04:21:12 | Union, New Mexico, US | |
2022-04-16 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-17 04:20:59 | Marshall, South Dakota, US | |
2022-04-16 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-17 04:20:59 | Union, New Mexico, US | |
2022-04-15 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-16 04:20:48 | Marshall, South Dakota, US | |
2022-04-15 | US | New Mexico | Union | 35059 | 784 | 16 | 0 | 36.48126404 | -103.4709624 | 2022-04-16 04:20:48 | Union, New Mexico, US | |
2022-04-14 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-15 04:20:57 | Marshall, South Dakota, US | |
2022-04-13 | US | Texas | Mason | 48319 | 784 | 12 | 0 | 30.71780434 | -99.22629416 | 2022-04-13 23:21:06 | Mason, Texas, US | |
2022-04-13 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-13 23:21:06 | Marshall, South Dakota, US | |
2022-04-12 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-13 04:21:03 | Marshall, South Dakota, US | |
2022-04-11 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-12 04:20:49 | Marshall, South Dakota, US | |
2022-04-10 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-11 04:21:02 | Marshall, South Dakota, US | |
2022-04-09 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-10 04:20:52 | Marshall, South Dakota, US | |
2022-04-08 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-09 04:20:42 | Marshall, South Dakota, US | |
2022-04-07 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-08 04:20:48 | Marshall, South Dakota, US | |
2022-04-07 | US | Minnesota | Unassigned | 90027 | 784 | 240 | 0 | 48.77754106 | 0.0 | 2022-04-08 04:20:48 | Unassigned, Minnesota, US | |
2022-04-06 | US | South Dakota | Marshall | 46091 | 784 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-04-07 04:20:53 | Marshall, South Dakota, US | |
2022-03-08 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-03-09 04:20:59 | Clark, South Dakota, US | |
2022-03-08 | US | South Dakota | Bennett | 46007 | 784 | 13 | 0 | 43.19486375 | -101.6665572 | 2022-03-09 04:20:59 | Bennett, South Dakota, US | |
2022-03-07 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-03-08 04:20:54 | Clark, South Dakota, US | |
2022-03-06 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-03-07 04:20:47 | Clark, South Dakota, US | |
2022-03-05 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-03-06 04:20:49 | Clark, South Dakota, US | |
2022-03-04 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-03-05 04:21:10 | Clark, South Dakota, US | |
2022-03-03 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-03-04 04:21:09 | Clark, South Dakota, US | |
2022-03-02 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-03-03 04:21:01 | Clark, South Dakota, US | |
2022-03-01 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-03-02 04:21:07 | Clark, South Dakota, US | |
2022-02-27 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-02-28 04:21:05 | Clark, South Dakota, US | |
2022-02-27 | US | Kansas | Sheridan | 20179 | 784 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-28 04:21:05 | Sheridan, Kansas, US | |
2022-02-26 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-02-27 04:21:04 | Clark, South Dakota, US | |
2022-02-26 | US | Kansas | Sheridan | 20179 | 784 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-27 04:21:04 | Sheridan, Kansas, US | |
2022-02-25 | US | South Dakota | Clark | 46025 | 784 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-02-26 04:21:12 | Clark, South Dakota, US | |
2022-02-25 | US | Kansas | Sheridan | 20179 | 784 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-26 04:21:12 | Sheridan, Kansas, US | |
2022-02-24 | US | Kansas | Sheridan | 20179 | 784 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-25 04:21:11 | Sheridan, Kansas, US | |
2022-02-23 | US | Kansas | Sheridan | 20179 | 784 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-24 04:21:14 | Sheridan, Kansas, US | |
2022-02-17 | US | Kansas | Woodson | 20207 | 784 | 12 | 0 | 37.8865336 | -95.74006277 | 2022-02-18 04:21:04 | Woodson, Kansas, US | |
2022-02-17 | US | Kansas | Gove | 20063 | 784 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-18 04:21:04 | Gove, Kansas, US | |
2022-02-16 | US | Kansas | Woodson | 20207 | 784 | 12 | 0 | 37.8865336 | -95.74006277 | 2022-02-17 04:20:56 | Woodson, Kansas, US | |
2022-02-16 | US | Kansas | Gove | 20063 | 784 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-17 04:20:56 | Gove, Kansas, US | |
2022-02-15 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 784 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-02-16 04:21:10 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-02-14 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 784 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-02-15 04:21:09 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-02-07 | US | Texas | Real | 48385 | 784 | 23 | 0 | 29.83321503 | -99.82018052 | 2022-02-08 04:21:15 | Real, Texas, US | |
2022-02-06 | US | Texas | Real | 48385 | 784 | 23 | 0 | 29.83321503 | -99.82018052 | 2022-02-07 04:21:05 | Real, Texas, US | |
2022-02-06 | US | Pennsylvania | Cameron | 42023 | 784 | 19 | 0 | 41.43625568 | -78.20376845 | 2022-02-07 04:21:05 | Cameron, Pennsylvania, US | |
2022-01-24 | US | Texas | Coke | 48081 | 784 | 18 | 0 | 31.88911733 | -100.5297533 | 2022-01-25 04:21:05 | Coke, Texas, US | |
2022-01-23 | US | Washington | San Juan | 53055 | 784 | 1 | 0 | 48.60182783 | -122.96745 | 2022-01-24 04:21:12 | San Juan, Washington, US | |
2022-01-22 | US | Washington | San Juan | 53055 | 784 | 1 | 0 | 48.60182783 | -122.96745 | 2022-01-23 04:21:13 | San Juan, Washington, US | |
2022-01-21 | US | Washington | San Juan | 53055 | 784 | 1 | 0 | 48.60182783 | -122.96745 | 2022-01-22 04:21:13 | San Juan, Washington, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;