daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
526 rows where confirmed = 1197 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 15
- US 471
- China 35
- Australia 3
- Japan 3
- Peru 3
- Niger 2
- Albania 1
- Antigua and Barbuda 1
- Azerbaijan 1
- Chile 1
- Georgia 1
- Latvia 1
- Netherlands 1
- Russia 1
- Sweden 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-14 | US | Oklahoma | Dewey | 40043 | 1197 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-15 04:20:58 | Dewey, Oklahoma, US | |
2022-12-13 | US | Oklahoma | Dewey | 40043 | 1197 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-14 04:21:04 | Dewey, Oklahoma, US | |
2022-12-12 | US | Oklahoma | Dewey | 40043 | 1197 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-13 04:21:01 | Dewey, Oklahoma, US | |
2022-12-11 | US | Oklahoma | Dewey | 40043 | 1197 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-12 04:21:01 | Dewey, Oklahoma, US | |
2022-12-10 | US | Oklahoma | Dewey | 40043 | 1197 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-11 04:20:50 | Dewey, Oklahoma, US | |
2022-12-09 | US | Oklahoma | Dewey | 40043 | 1197 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-10 04:21:02 | Dewey, Oklahoma, US | |
2022-12-08 | US | Oklahoma | Dewey | 40043 | 1197 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-09 04:21:05 | Dewey, Oklahoma, US | |
2022-11-30 | US | Illinois | Pope | 17151 | 1197 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-12-01 04:21:03 | Pope, Illinois, US | |
2022-11-16 | US | North Dakota | Pierce | 38069 | 1197 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-11-17 04:21:11 | Pierce, North Dakota, US | |
2022-11-15 | US | North Dakota | Pierce | 38069 | 1197 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-11-16 04:21:09 | Pierce, North Dakota, US | |
2022-10-03 | US | California | Modoc | 6049 | 1197 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-04 04:22:55 | Modoc, California, US | |
2022-10-02 | US | California | Modoc | 6049 | 1197 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-03 04:23:11 | Modoc, California, US | |
2022-10-01 | US | California | Modoc | 6049 | 1197 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-02 04:21:23 | Modoc, California, US | |
2022-09-30 | US | California | Modoc | 6049 | 1197 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-01 04:23:01 | Modoc, California, US | |
2022-09-29 | US | California | Modoc | 6049 | 1197 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-30 04:23:09 | Modoc, California, US | |
2022-09-27 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1197 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-28 04:23:01 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-09-26 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1197 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-27 04:23:01 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-09-25 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1197 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-26 04:20:52 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-09-24 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1197 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-25 04:23:31 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-09-23 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1197 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-24 04:21:40 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-09-22 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1197 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-23 04:23:13 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-09-21 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1197 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-22 04:22:56 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-09-12 | US | Nebraska | Thayer | 31169 | 1197 | 8 | 0 | 40.17626377 | -97.59504381 | 2022-09-13 04:20:57 | Thayer, Nebraska, US | |
2022-09-11 | US | Nebraska | Thayer | 31169 | 1197 | 8 | 0 | 40.17626377 | -97.59504381 | 2022-09-12 04:20:58 | Thayer, Nebraska, US | |
2022-09-11 | US | Idaho | Lincoln | 16063 | 1197 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-09-12 04:20:58 | Lincoln, Idaho, US | |
2022-09-10 | US | Nebraska | Thayer | 31169 | 1197 | 8 | 0 | 40.17626377 | -97.59504381 | 2022-09-11 04:20:50 | Thayer, Nebraska, US | |
2022-09-10 | US | Idaho | Lincoln | 16063 | 1197 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-09-11 04:20:50 | Lincoln, Idaho, US | |
2022-09-09 | US | Nebraska | Thayer | 31169 | 1197 | 8 | 0 | 40.17626377 | -97.59504381 | 2022-09-10 04:21:10 | Thayer, Nebraska, US | |
2022-09-09 | US | Idaho | Lincoln | 16063 | 1197 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-09-10 04:21:10 | Lincoln, Idaho, US | |
2022-09-08 | US | Nebraska | Thayer | 31169 | 1197 | 8 | 0 | 40.17626377 | -97.59504381 | 2022-09-09 04:21:11 | Thayer, Nebraska, US | |
2022-09-07 | US | Nebraska | Thayer | 31169 | 1197 | 8 | 0 | 40.17626377 | -97.59504381 | 2022-09-08 04:21:02 | Thayer, Nebraska, US | |
2022-09-06 | US | Nebraska | Thayer | 31169 | 1197 | 8 | 0 | 40.17626377 | -97.59504381 | 2022-09-07 04:20:59 | Thayer, Nebraska, US | |
2022-08-15 | US | Illinois | Hardin | 17069 | 1197 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-08-16 04:20:58 | Hardin, Illinois, US | |
2022-08-08 | US | New Mexico | Guadalupe | 35019 | 1197 | 17 | 0 | 34.86319296 | -104.790669 | 2022-08-09 04:20:34 | Guadalupe, New Mexico, US | |
2022-08-07 | US | New Mexico | Hidalgo | 35023 | 1197 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-08 04:21:08 | Hidalgo, New Mexico, US | |
2022-08-06 | US | New Mexico | Hidalgo | 35023 | 1197 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-07 04:20:54 | Hidalgo, New Mexico, US | |
2022-08-05 | US | New Mexico | Hidalgo | 35023 | 1197 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-06 04:20:56 | Hidalgo, New Mexico, US | |
2022-08-02 | US | Idaho | Boise | 16015 | 1197 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-08-03 04:20:59 | Boise, Idaho, US | |
2022-08-01 | US | Idaho | Boise | 16015 | 1197 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-08-02 04:20:53 | Boise, Idaho, US | |
2022-07-27 | US | Texas | Donley | 48129 | 1197 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-07-28 04:20:56 | Donley, Texas, US | |
2022-07-17 | US | Idaho | Lewis | 16061 | 1197 | 30 | 0 | 46.23315327 | -116.434146 | 2022-07-18 04:20:59 | Lewis, Idaho, US | |
2022-07-16 | US | Idaho | Lewis | 16061 | 1197 | 30 | 0 | 46.23315327 | -116.434146 | 2022-07-17 04:21:15 | Lewis, Idaho, US | |
2022-07-15 | US | Idaho | Lewis | 16061 | 1197 | 30 | 0 | 46.23315327 | -116.434146 | 2022-07-16 04:21:05 | Lewis, Idaho, US | |
2022-06-23 | US | Illinois | Putnam | 17155 | 1197 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-24 04:20:58 | Putnam, Illinois, US | |
2022-06-22 | US | Illinois | Putnam | 17155 | 1197 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-23 04:20:55 | Putnam, Illinois, US | |
2022-06-14 | US | Texas | Wheeler | 48483 | 1197 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-06-15 04:20:54 | Wheeler, Texas, US | |
2022-06-13 | US | Texas | Wheeler | 48483 | 1197 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-06-14 04:20:52 | Wheeler, Texas, US | |
2022-06-12 | US | Texas | Wheeler | 48483 | 1197 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-06-13 04:21:14 | Wheeler, Texas, US | |
2022-06-11 | US | Texas | Wheeler | 48483 | 1197 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-06-12 04:20:53 | Wheeler, Texas, US | |
2022-05-25 | US | Virginia | Charles City | 51036 | 1197 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-05-26 04:20:50 | Charles City, Virginia, US | |
2022-05-22 | US | Virginia | Charles City | 51036 | 1197 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-05-26 04:20:50 | Charles City, Virginia, US | |
2022-05-14 | US | Nebraska | Polk | 31143 | 1197 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-05-15 04:20:53 | Polk, Nebraska, US | |
2022-05-13 | US | Nebraska | Polk | 31143 | 1197 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-05-14 04:20:48 | Polk, Nebraska, US | |
2022-05-12 | US | Nebraska | Polk | 31143 | 1197 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-05-13 04:20:51 | Polk, Nebraska, US | |
2022-05-11 | US | Nebraska | Polk | 31143 | 1197 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-05-12 04:20:54 | Polk, Nebraska, US | |
2022-04-11 | US | Texas | Martin | 48317 | 1197 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-04-12 04:20:49 | Martin, Texas, US | |
2022-04-10 | US | Texas | Martin | 48317 | 1197 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-04-11 04:21:02 | Martin, Texas, US | |
2022-04-09 | US | Texas | Martin | 48317 | 1197 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-04-10 04:20:52 | Martin, Texas, US | |
2022-04-04 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-04-05 04:20:48 | Goliad, Texas, US | |
2022-04-03 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-04-04 04:20:51 | Goliad, Texas, US | |
2022-04-02 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-04-03 04:20:48 | Goliad, Texas, US | |
2022-04-01 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-04-02 04:20:47 | Goliad, Texas, US | |
2022-03-31 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-04-01 04:20:28 | Goliad, Texas, US | |
2022-03-30 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-31 04:20:56 | Goliad, Texas, US | |
2022-03-29 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-30 04:20:45 | Goliad, Texas, US | |
2022-03-28 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-29 04:20:46 | Goliad, Texas, US | |
2022-03-27 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-28 04:20:33 | Goliad, Texas, US | |
2022-03-26 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-27 04:20:47 | Goliad, Texas, US | |
2022-03-25 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-26 04:20:23 | Goliad, Texas, US | |
2022-03-24 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-25 04:20:46 | Goliad, Texas, US | |
2022-03-23 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-24 04:20:43 | Goliad, Texas, US | |
2022-03-22 | US | Texas | Goliad | 48175 | 1197 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-03-23 04:20:48 | Goliad, Texas, US | |
2022-03-13 | US | Minnesota | Unassigned | 90027 | 1197 | 200 | 0 | 48.77754106 | 0.0 | 2022-03-14 04:20:46 | Unassigned, Minnesota, US | |
2022-03-13 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-14 04:20:46 | Cameron, Louisiana, US | |
2022-03-12 | US | Minnesota | Unassigned | 90027 | 1197 | 200 | 0 | 48.77754106 | 0.0 | 2022-03-13 04:20:49 | Unassigned, Minnesota, US | |
2022-03-12 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-13 04:20:49 | Cameron, Louisiana, US | |
2022-03-11 | US | Minnesota | Unassigned | 90027 | 1197 | 200 | 0 | 48.77754106 | 0.0 | 2022-03-12 04:20:50 | Unassigned, Minnesota, US | |
2022-03-11 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-12 04:20:50 | Cameron, Louisiana, US | |
2022-03-10 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-11 04:20:50 | Cameron, Louisiana, US | |
2022-03-09 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-10 04:20:48 | Cameron, Louisiana, US | |
2022-03-08 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-09 04:20:59 | Cameron, Louisiana, US | |
2022-03-07 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-08 04:20:54 | Cameron, Louisiana, US | |
2022-03-07 | US | Colorado | Saguache | 8109 | 1197 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-03-08 04:20:54 | Saguache, Colorado, US | |
2022-03-06 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-07 04:20:47 | Cameron, Louisiana, US | |
2022-03-05 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-06 04:20:49 | Cameron, Louisiana, US | |
2022-03-04 | US | Louisiana | Cameron | 22023 | 1197 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-05 04:21:10 | Cameron, Louisiana, US | |
2022-02-28 | US | Iowa | Unassigned | 90019 | 1197 | 0 | 0 | 43.38107862 | 0.0 | 2022-03-01 04:21:09 | Unassigned, Iowa, US | |
2022-02-27 | US | Iowa | Unassigned | 90019 | 1197 | 0 | 0 | 43.38107862 | 0.0 | 2022-02-28 04:21:05 | Unassigned, Iowa, US | |
2022-02-26 | US | Iowa | Unassigned | 90019 | 1197 | 0 | 0 | 43.38107862 | 0.0 | 2022-02-27 04:21:04 | Unassigned, Iowa, US | |
2022-02-17 | US | South Dakota | Lyman | 46085 | 1197 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-02-18 04:21:04 | Lyman, South Dakota, US | |
2022-02-10 | US | Oregon | Wallowa | 41063 | 1197 | 14 | 0 | 45.57894064 | -117.18353799999998 | 2022-02-11 04:21:09 | Wallowa, Oregon, US | |
2022-02-06 | US | Kansas | Gray | 20069 | 1197 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-02-07 04:21:05 | Gray, Kansas, US | |
2022-02-05 | US | Kansas | Gray | 20069 | 1197 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-02-06 04:21:00 | Gray, Kansas, US | |
2022-02-04 | US | Kansas | Gray | 20069 | 1197 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-02-05 04:21:05 | Gray, Kansas, US | |
2022-02-01 | US | Missouri | Atchison | 29005 | 1197 | 19 | 0 | 40.43238737 | -95.42970639 | 2022-02-02 04:21:09 | Atchison, Missouri, US | |
2022-01-31 | US | Texas | San Saba | 48411 | 1197 | 31 | 0 | 31.1577796 | -98.81758731 | 2022-02-01 04:21:11 | San Saba, Texas, US | |
2022-01-12 | US | Nebraska | Clay | 31035 | 1197 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-01-13 08:00:09 | Clay, Nebraska, US | |
2022-01-10 | US | Missouri | Shelby | 29205 | 1197 | 13 | 0 | 39.79742518 | -92.07634971 | 2022-01-11 04:22:01 | Shelby, Missouri, US | |
2022-01-09 | US | Puerto Rico | Patillas | 72109 | 1197 | 0 | 0 | 18.03174 | -66.012242 | 2022-01-10 04:22:07 | Patillas, Puerto Rico, US | |
2022-01-07 | US | Missouri | Carter | 29035 | 1197 | 19 | 0 | 36.94160441 | -90.96051322 | 2022-01-08 04:21:53 | Carter, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;