daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
505 rows where confirmed = 1206 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-29 | US | Oklahoma | Dewey | 40043 | 1206 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-30 04:21:04 | Dewey, Oklahoma, US | |
2022-12-05 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-06 04:21:03 | Washington, Colorado, US | |
2022-12-04 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-05 04:20:58 | Washington, Colorado, US | |
2022-12-03 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-04 04:20:56 | Washington, Colorado, US | |
2022-12-02 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-03 04:21:02 | Washington, Colorado, US | |
2022-12-01 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-02 04:21:07 | Washington, Colorado, US | |
2022-11-30 | US | North Dakota | Pierce | 38069 | 1206 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-12-01 04:21:03 | Pierce, North Dakota, US | |
2022-10-15 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-16 04:22:39 | Modoc, California, US | |
2022-10-14 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-15 04:22:00 | Modoc, California, US | |
2022-10-13 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-14 04:22:28 | Modoc, California, US | |
2022-10-12 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-13 04:22:39 | Modoc, California, US | |
2022-10-11 | US | North Dakota | Sargent | 38081 | 1206 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-10-12 04:22:51 | Sargent, North Dakota, US | |
2022-10-11 | US | Iowa | Unassigned | 90019 | 1206 | 0 | 0 | 43.38107862 | 0.0 | 2022-10-12 04:22:51 | Unassigned, Iowa, US | |
2022-10-11 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-12 04:22:51 | Modoc, California, US | |
2022-09-22 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-23 04:23:13 | Hall, Texas, US | |
2022-09-21 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-22 04:22:56 | Hall, Texas, US | |
2022-09-20 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-21 04:23:22 | Hall, Texas, US | |
2022-09-19 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-20 04:22:48 | Hall, Texas, US | |
2022-09-18 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-19 04:21:49 | Hall, Texas, US | |
2022-09-17 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-18 04:22:50 | Hall, Texas, US | |
2022-09-16 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-17 04:20:19 | Hall, Texas, US | |
2022-09-05 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-06 04:21:02 | Furnas, Nebraska, US | |
2022-09-04 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-05 04:21:01 | Furnas, Nebraska, US | |
2022-09-03 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-04 04:21:22 | Furnas, Nebraska, US | |
2022-09-02 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-03 04:21:04 | Furnas, Nebraska, US | |
2022-09-01 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-02 04:21:07 | Furnas, Nebraska, US | |
2022-08-31 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-01 04:21:03 | Furnas, Nebraska, US | |
2022-08-31 | US | Louisiana | Tensas | 22107 | 1206 | 13 | 0 | 32.00760749 | -91.32915234 | 2022-09-01 04:21:03 | Tensas, Louisiana, US | |
2022-08-30 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-08-31 04:20:57 | Furnas, Nebraska, US | |
2022-08-28 | US | Virginia | Rappahannock | 51157 | 1206 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-29 04:21:06 | Rappahannock, Virginia, US | |
2022-08-27 | US | Virginia | Rappahannock | 51157 | 1206 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-28 04:21:02 | Rappahannock, Virginia, US | |
2022-08-26 | US | Virginia | Rappahannock | 51157 | 1206 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-27 04:20:57 | Rappahannock, Virginia, US | |
2022-08-24 | US | Texas | Concho | 48095 | 1206 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-08-25 04:21:13 | Concho, Texas, US | |
2022-08-23 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-24 04:20:46 | Grand Isle, Vermont, US | |
2022-08-23 | US | Texas | Concho | 48095 | 1206 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-08-24 04:20:46 | Concho, Texas, US | |
2022-08-22 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-23 04:20:56 | Grand Isle, Vermont, US | |
2022-08-21 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-22 04:20:38 | Grand Isle, Vermont, US | |
2022-08-20 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-21 04:20:44 | Grand Isle, Vermont, US | |
2022-08-19 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-20 04:21:01 | Grand Isle, Vermont, US | |
2022-08-18 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-19 04:20:54 | Grand Isle, Vermont, US | |
2022-08-18 | US | Texas | Brewster | 48043 | 1206 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-08-19 04:20:54 | Brewster, Texas, US | |
2022-08-17 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-18 04:21:11 | Grand Isle, Vermont, US | |
2022-08-14 | US | New Mexico | Hidalgo | 35023 | 1206 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-15 04:20:59 | Hidalgo, New Mexico, US | |
2022-08-13 | US | New Mexico | Hidalgo | 35023 | 1206 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-14 04:20:55 | Hidalgo, New Mexico, US | |
2022-08-12 | US | New Mexico | Hidalgo | 35023 | 1206 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-13 04:20:52 | Hidalgo, New Mexico, US | |
2022-08-10 | US | Virginia | Craig | 51045 | 1206 | 22 | 0 | 37.48133648 | -80.21072274 | 2022-08-11 04:20:49 | Craig, Virginia, US | |
2022-07-26 | US | Virginia | Surry | 51181 | 1206 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-07-27 04:21:04 | Surry, Virginia, US | |
2022-07-25 | US | Virginia | Surry | 51181 | 1206 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-07-26 04:20:58 | Surry, Virginia, US | |
2022-07-10 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-11 04:20:46 | King and Queen, Virginia, US | |
2022-07-09 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-10 04:20:54 | King and Queen, Virginia, US | |
2022-07-08 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-09 04:20:59 | King and Queen, Virginia, US | |
2022-07-07 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-08 04:20:56 | King and Queen, Virginia, US | |
2022-07-06 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-07 04:20:55 | King and Queen, Virginia, US | |
2022-07-05 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-06 04:20:58 | Wheeler, Texas, US | |
2022-07-04 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-05 04:20:45 | Wheeler, Texas, US | |
2022-07-03 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-04 04:20:54 | Wheeler, Texas, US | |
2022-07-02 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-03 04:20:59 | Wheeler, Texas, US | |
2022-07-01 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-02 04:21:16 | Wheeler, Texas, US | |
2022-06-30 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-01 04:21:10 | Wheeler, Texas, US | |
2022-06-19 | US | Louisiana | Cameron | 22023 | 1206 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-20 04:21:01 | Cameron, Louisiana, US | |
2022-06-18 | US | Louisiana | Cameron | 22023 | 1206 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-19 04:20:51 | Cameron, Louisiana, US | |
2022-06-17 | US | Louisiana | Cameron | 22023 | 1206 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-18 04:21:10 | Cameron, Louisiana, US | |
2022-06-16 | US | Louisiana | Cameron | 22023 | 1206 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-17 04:20:56 | Cameron, Louisiana, US | |
2022-06-13 | US | Nebraska | Polk | 31143 | 1206 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-06-14 04:20:52 | Polk, Nebraska, US | |
2022-06-12 | US | Nebraska | Polk | 31143 | 1206 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-06-13 04:21:14 | Polk, Nebraska, US | |
2022-06-11 | US | Nebraska | Polk | 31143 | 1206 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-06-12 04:20:53 | Polk, Nebraska, US | |
2022-06-10 | US | Nebraska | Polk | 31143 | 1206 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-06-11 04:21:01 | Polk, Nebraska, US | |
2022-05-31 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-06-01 04:20:55 | Lyman, South Dakota, US | |
2022-05-30 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-31 04:20:51 | Lyman, South Dakota, US | |
2022-05-30 | US | Nebraska | Dixon | 31051 | 1206 | 11 | 0 | 42.49188363 | -96.86782408 | 2022-05-31 04:20:51 | Dixon, Nebraska, US | |
2022-05-29 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-30 04:20:50 | Lyman, South Dakota, US | |
2022-05-29 | US | Nebraska | Dixon | 31051 | 1206 | 11 | 0 | 42.49188363 | -96.86782408 | 2022-05-30 04:20:50 | Dixon, Nebraska, US | |
2022-05-28 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-29 04:20:53 | Lyman, South Dakota, US | |
2022-05-28 | US | Nebraska | Dixon | 31051 | 1206 | 11 | 0 | 42.49188363 | -96.86782408 | 2022-05-29 04:20:53 | Dixon, Nebraska, US | |
2022-05-27 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-28 04:21:07 | Lyman, South Dakota, US | |
2022-05-26 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-27 04:20:56 | Lyman, South Dakota, US | |
2022-05-25 | US | Virginia | Emporia | 51595 | 1206 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-26 04:20:50 | Emporia, Virginia, US | |
2022-05-25 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-26 04:20:50 | Lyman, South Dakota, US | |
2022-05-22 | US | Virginia | Emporia | 51595 | 1206 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-26 04:20:50 | Emporia, Virginia, US | |
2022-05-22 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-26 04:20:50 | Lyman, South Dakota, US | |
2022-05-05 | US | Texas | Martin | 48317 | 1206 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-05-06 04:21:00 | Martin, Texas, US | |
2022-05-04 | US | Texas | Martin | 48317 | 1206 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-05-05 04:20:55 | Martin, Texas, US | |
2022-05-03 | US | Texas | Martin | 48317 | 1206 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-05-04 04:20:59 | Martin, Texas, US | |
2022-05-02 | US | Texas | Goliad | 48175 | 1206 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-05-03 04:21:00 | Goliad, Texas, US | |
2022-04-26 | US | Vermont | Unassigned | 90050 | 1206 | 1 | 0 | 44.85627605 | 0.0 | 2022-04-27 04:20:52 | Unassigned, Vermont, US | |
2022-04-25 | US | Vermont | Unassigned | 90050 | 1206 | 1 | 0 | 44.85627605 | 0.0 | 2022-04-26 04:20:51 | Unassigned, Vermont, US | |
2022-04-15 | US | Colorado | Saguache | 8109 | 1206 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-04-16 04:20:48 | Saguache, Colorado, US | |
2022-02-17 | US | Kansas | Meade | 20119 | 1206 | 17 | 0 | 37.23859987 | -100.36483100000001 | 2022-02-18 04:21:04 | Meade, Kansas, US | |
2022-02-16 | US | Kansas | Meade | 20119 | 1206 | 17 | 0 | 37.23859987 | -100.36483100000001 | 2022-02-17 04:20:56 | Meade, Kansas, US | |
2022-02-15 | US | Montana | Broadwater | 30007 | 1206 | 18 | 0 | 46.33277565 | -111.49558130000001 | 2022-02-16 04:21:10 | Broadwater, Montana, US | |
2022-02-03 | US | Kansas | Kearny | 20093 | 1206 | 18 | 0 | 38.00017981 | -101.32168100000001 | 2022-02-04 04:21:10 | Kearny, Kansas, US | |
2022-02-02 | US | Montana | Teton | 30099 | 1206 | 18 | 0 | 47.83741052 | -112.24106880000001 | 2022-02-03 04:21:21 | Teton, Montana, US | |
2022-02-02 | US | Kansas | Kearny | 20093 | 1206 | 18 | 0 | 38.00017981 | -101.32168100000001 | 2022-02-03 04:21:21 | Kearny, Kansas, US | |
2022-02-01 | US | North Carolina | Hyde | 37095 | 1206 | 13 | 0 | 35.42017674 | -76.15180542 | 2022-02-02 04:21:09 | Hyde, North Carolina, US | |
2022-01-31 | US | Arkansas | Lafayette | 5073 | 1206 | 28 | 0 | 33.24116713 | -93.60677071 | 2022-02-01 04:21:11 | Lafayette, Arkansas, US | |
2022-01-29 | US | Texas | McCulloch | 48307 | 1206 | 42 | 0 | 31.1925468 | -99.34682807 | 2022-01-30 04:21:26 | McCulloch, Texas, US | |
2022-01-27 | US | Nebraska | Burt | 31021 | 1206 | 12 | 0 | 41.85056773 | -96.32605633 | 2022-01-28 04:21:09 | Burt, Nebraska, US | |
2022-01-26 | US | Wyoming | Crook | 56011 | 1206 | 22 | 0 | 44.58855102 | -104.56977049999999 | 2022-01-27 04:21:19 | Crook, Wyoming, US | |
2022-01-26 | US | Puerto Rico | Guanica | 72055 | 1206 | 0 | 0 | 17.982429 | -66.91964300000001 | 2022-01-27 04:21:19 | Guanica, Puerto Rico, US | |
2022-01-18 | US | Indiana | Ohio | 18115 | 1206 | 16 | 0 | 38.955304999999996 | -84.96515993 | 2022-01-19 04:21:23 | Ohio, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;