daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
477 rows where confirmed = 1257 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-13 | US | Vermont | Grand Isle | 50013 | 1257 | 7 | 0 | 44.7975824 | -73.29679772 | 2022-12-14 04:21:04 | Grand Isle, Vermont, US | |
2022-12-12 | US | Vermont | Grand Isle | 50013 | 1257 | 7 | 0 | 44.7975824 | -73.29679772 | 2022-12-13 04:21:01 | Grand Isle, Vermont, US | |
2022-12-11 | US | Vermont | Grand Isle | 50013 | 1257 | 7 | 0 | 44.7975824 | -73.29679772 | 2022-12-12 04:21:01 | Grand Isle, Vermont, US | |
2022-12-10 | US | Vermont | Grand Isle | 50013 | 1257 | 7 | 0 | 44.7975824 | -73.29679772 | 2022-12-11 04:20:50 | Grand Isle, Vermont, US | |
2022-12-09 | US | Vermont | Grand Isle | 50013 | 1257 | 7 | 0 | 44.7975824 | -73.29679772 | 2022-12-10 04:21:02 | Grand Isle, Vermont, US | |
2022-12-08 | US | Vermont | Grand Isle | 50013 | 1257 | 7 | 0 | 44.7975824 | -73.29679772 | 2022-12-09 04:21:05 | Grand Isle, Vermont, US | |
2022-12-07 | US | Vermont | Grand Isle | 50013 | 1257 | 7 | 0 | 44.7975824 | -73.29679772 | 2022-12-08 04:21:07 | Grand Isle, Vermont, US | |
2022-12-06 | US | Idaho | Lincoln | 16063 | 1257 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-12-07 04:20:58 | Lincoln, Idaho, US | |
2022-12-05 | US | Idaho | Lincoln | 16063 | 1257 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-12-06 04:21:03 | Lincoln, Idaho, US | |
2022-12-04 | US | Idaho | Lincoln | 16063 | 1257 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-12-05 04:20:58 | Lincoln, Idaho, US | |
2022-12-03 | US | Idaho | Lincoln | 16063 | 1257 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-12-04 04:20:56 | Lincoln, Idaho, US | |
2022-12-02 | US | Idaho | Lincoln | 16063 | 1257 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-12-03 04:21:02 | Lincoln, Idaho, US | |
2022-12-01 | US | Idaho | Lincoln | 16063 | 1257 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-12-02 04:21:07 | Lincoln, Idaho, US | |
2022-11-30 | US | Idaho | Lincoln | 16063 | 1257 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-12-01 04:21:03 | Lincoln, Idaho, US | |
2022-11-02 | US | New Mexico | Hidalgo | 35023 | 1257 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-11-03 04:22:05 | Hidalgo, New Mexico, US | |
2022-11-01 | US | New Mexico | Hidalgo | 35023 | 1257 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-11-02 04:22:09 | Hidalgo, New Mexico, US | |
2022-10-31 | US | New Mexico | Hidalgo | 35023 | 1257 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-11-01 04:22:36 | Hidalgo, New Mexico, US | |
2022-10-27 | US | New Mexico | Guadalupe | 35019 | 1257 | 18 | 0 | 34.86319296 | -104.790669 | 2022-10-28 04:22:31 | Guadalupe, New Mexico, US | |
2022-10-11 | US | Wisconsin | Florence | 55037 | 1257 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-10-12 04:22:51 | Florence, Wisconsin, US | |
2022-10-11 | US | Idaho | Boise | 16015 | 1257 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-10-12 04:22:51 | Boise, Idaho, US | |
2022-10-10 | US | Idaho | Boise | 16015 | 1257 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-10-11 04:23:05 | Boise, Idaho, US | |
2022-10-09 | US | Virginia | Rappahannock | 51157 | 1257 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-10-10 04:22:32 | Rappahannock, Virginia, US | |
2022-10-09 | US | Idaho | Boise | 16015 | 1257 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-10-10 04:22:32 | Boise, Idaho, US | |
2022-10-08 | US | Virginia | Rappahannock | 51157 | 1257 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-10-09 04:21:16 | Rappahannock, Virginia, US | |
2022-10-08 | US | Idaho | Boise | 16015 | 1257 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-10-09 04:21:16 | Boise, Idaho, US | |
2022-10-07 | US | Virginia | Rappahannock | 51157 | 1257 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-10-08 04:22:56 | Rappahannock, Virginia, US | |
2022-10-07 | US | Idaho | Boise | 16015 | 1257 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-10-08 04:22:56 | Boise, Idaho, US | |
2022-10-06 | US | Virginia | Rappahannock | 51157 | 1257 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-10-07 04:23:08 | Rappahannock, Virginia, US | |
2022-10-05 | US | Virginia | Rappahannock | 51157 | 1257 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-10-06 04:21:22 | Rappahannock, Virginia, US | |
2022-10-04 | US | Virginia | Rappahannock | 51157 | 1257 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-10-05 04:23:06 | Rappahannock, Virginia, US | |
2022-10-04 | US | Texas | Crockett | 48105 | 1257 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-10-05 04:23:06 | Crockett, Texas, US | |
2022-10-03 | US | Texas | Crockett | 48105 | 1257 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-10-04 04:22:55 | Crockett, Texas, US | |
2022-09-29 | US | Montana | Mineral | 30061 | 1257 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-09-30 04:23:09 | Mineral, Montana, US | |
2022-09-29 | US | Idaho | Boise | 16015 | 1257 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-09-30 04:23:09 | Boise, Idaho, US | |
2022-09-28 | US | Texas | Concho | 48095 | 1257 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-09-29 04:22:34 | Concho, Texas, US | |
2022-09-28 | US | Montana | Mineral | 30061 | 1257 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-09-29 04:22:34 | Mineral, Montana, US | |
2022-09-28 | US | Idaho | Boise | 16015 | 1257 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-09-29 04:22:34 | Boise, Idaho, US | |
2022-09-27 | US | Texas | Concho | 48095 | 1257 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-09-28 04:23:01 | Concho, Texas, US | |
2022-09-27 | US | Montana | Mineral | 30061 | 1257 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-09-28 04:23:01 | Mineral, Montana, US | |
2022-09-26 | US | Texas | Concho | 48095 | 1257 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-09-27 04:23:01 | Concho, Texas, US | |
2022-09-26 | US | Montana | Mineral | 30061 | 1257 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-09-27 04:23:01 | Mineral, Montana, US | |
2022-09-25 | US | Texas | Concho | 48095 | 1257 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-09-26 04:20:52 | Concho, Texas, US | |
2022-09-25 | US | Montana | Mineral | 30061 | 1257 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-09-26 04:20:52 | Mineral, Montana, US | |
2022-09-24 | US | Texas | Concho | 48095 | 1257 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-09-25 04:23:31 | Concho, Texas, US | |
2022-09-24 | US | Montana | Mineral | 30061 | 1257 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-09-25 04:23:31 | Mineral, Montana, US | |
2022-09-23 | US | Texas | Concho | 48095 | 1257 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-09-24 04:21:40 | Concho, Texas, US | |
2022-09-23 | US | Montana | Mineral | 30061 | 1257 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-09-24 04:21:40 | Mineral, Montana, US | |
2022-09-20 | US | Pennsylvania | Sullivan | 42113 | 1257 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-09-21 04:23:22 | Sullivan, Pennsylvania, US | |
2022-09-19 | US | Pennsylvania | Sullivan | 42113 | 1257 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-09-20 04:22:48 | Sullivan, Pennsylvania, US | |
2022-09-18 | US | Pennsylvania | Sullivan | 42113 | 1257 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-09-19 04:21:49 | Sullivan, Pennsylvania, US | |
2022-09-17 | US | Pennsylvania | Sullivan | 42113 | 1257 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-09-18 04:22:50 | Sullivan, Pennsylvania, US | |
2022-09-16 | US | Pennsylvania | Sullivan | 42113 | 1257 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-09-17 04:20:19 | Sullivan, Pennsylvania, US | |
2022-09-15 | US | Pennsylvania | Sullivan | 42113 | 1257 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-09-16 04:21:19 | Sullivan, Pennsylvania, US | |
2022-09-14 | US | Pennsylvania | Sullivan | 42113 | 1257 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-09-15 04:21:02 | Sullivan, Pennsylvania, US | |
2022-09-13 | US | Idaho | Lewis | 16061 | 1257 | 30 | 0 | 46.23315327 | -116.434146 | 2022-09-14 04:20:44 | Lewis, Idaho, US | |
2022-09-12 | US | Idaho | Lewis | 16061 | 1257 | 30 | 0 | 46.23315327 | -116.434146 | 2022-09-13 04:20:57 | Lewis, Idaho, US | |
2022-08-18 | US | Missouri | Reynolds | 29179 | 1257 | 27 | 0 | 37.36085952 | -90.97009925 | 2022-08-19 04:20:54 | Reynolds, Missouri, US | |
2022-08-17 | US | Missouri | Reynolds | 29179 | 1257 | 27 | 0 | 37.36085952 | -90.97009925 | 2022-08-18 04:21:11 | Reynolds, Missouri, US | |
2022-08-16 | US | Missouri | Reynolds | 29179 | 1257 | 27 | 0 | 37.36085952 | -90.97009925 | 2022-08-17 04:20:59 | Reynolds, Missouri, US | |
2022-08-16 | US | Georgia | Talbot | 13263 | 1257 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-17 04:20:59 | Talbot, Georgia, US | |
2022-08-15 | US | Texas | Wheeler | 48483 | 1257 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-08-16 04:20:58 | Wheeler, Texas, US | |
2022-08-15 | US | Missouri | Reynolds | 29179 | 1257 | 27 | 0 | 37.36085952 | -90.97009925 | 2022-08-16 04:20:58 | Reynolds, Missouri, US | |
2022-08-15 | US | Georgia | Talbot | 13263 | 1257 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-16 04:20:58 | Talbot, Georgia, US | |
2022-08-14 | US | Texas | Wheeler | 48483 | 1257 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-08-15 04:20:59 | Wheeler, Texas, US | |
2022-08-14 | US | Missouri | Reynolds | 29179 | 1257 | 27 | 0 | 37.36085952 | -90.97009925 | 2022-08-15 04:20:59 | Reynolds, Missouri, US | |
2022-08-14 | US | Georgia | Talbot | 13263 | 1257 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-15 04:20:59 | Talbot, Georgia, US | |
2022-08-13 | US | Texas | Wheeler | 48483 | 1257 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-08-14 04:20:55 | Wheeler, Texas, US | |
2022-08-13 | US | Missouri | Reynolds | 29179 | 1257 | 27 | 0 | 37.36085952 | -90.97009925 | 2022-08-14 04:20:55 | Reynolds, Missouri, US | |
2022-08-13 | US | Georgia | Talbot | 13263 | 1257 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-14 04:20:55 | Talbot, Georgia, US | |
2022-08-12 | US | Texas | Wheeler | 48483 | 1257 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-08-13 04:20:52 | Wheeler, Texas, US | |
2022-08-12 | US | Missouri | Reynolds | 29179 | 1257 | 27 | 0 | 37.36085952 | -90.97009925 | 2022-08-13 04:20:52 | Reynolds, Missouri, US | |
2022-08-12 | US | Georgia | Talbot | 13263 | 1257 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-13 04:20:52 | Talbot, Georgia, US | |
2022-08-11 | US | Georgia | Talbot | 13263 | 1257 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-12 04:20:54 | Talbot, Georgia, US | |
2022-08-10 | US | Georgia | Talbot | 13263 | 1257 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-11 04:20:49 | Talbot, Georgia, US | |
2022-07-31 | US | Illinois | Putnam | 17155 | 1257 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-08-01 04:21:03 | Putnam, Illinois, US | |
2022-07-30 | US | Illinois | Putnam | 17155 | 1257 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-07-31 04:21:02 | Putnam, Illinois, US | |
2022-07-29 | US | Illinois | Putnam | 17155 | 1257 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-07-30 04:20:42 | Putnam, Illinois, US | |
2022-07-13 | US | Texas | Martin | 48317 | 1257 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-07-14 04:20:57 | Martin, Texas, US | |
2022-07-13 | US | Minnesota | Lincoln | 27081 | 1257 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-14 04:20:57 | Lincoln, Minnesota, US | |
2022-07-12 | US | Minnesota | Lincoln | 27081 | 1257 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-13 04:20:58 | Lincoln, Minnesota, US | |
2022-07-11 | US | Minnesota | Lincoln | 27081 | 1257 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-12 04:20:51 | Lincoln, Minnesota, US | |
2022-07-10 | US | Virginia | Emporia | 51595 | 1257 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-07-11 04:20:46 | Emporia, Virginia, US | |
2022-07-10 | US | Minnesota | Lincoln | 27081 | 1257 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-11 04:20:46 | Lincoln, Minnesota, US | |
2022-07-09 | US | Virginia | Emporia | 51595 | 1257 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-07-10 04:20:54 | Emporia, Virginia, US | |
2022-07-09 | US | Minnesota | Lincoln | 27081 | 1257 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-10 04:20:54 | Lincoln, Minnesota, US | |
2022-07-08 | US | Virginia | Emporia | 51595 | 1257 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-07-09 04:20:59 | Emporia, Virginia, US | |
2022-07-08 | US | Minnesota | Lincoln | 27081 | 1257 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-09 04:20:59 | Lincoln, Minnesota, US | |
2022-07-07 | US | Minnesota | Lincoln | 27081 | 1257 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-08 04:20:56 | Lincoln, Minnesota, US | |
2022-07-06 | US | Virginia | Charles City | 51036 | 1257 | 29 | 0 | 37.35358063 | -77.05634116 | 2022-07-07 04:20:55 | Charles City, Virginia, US | |
2022-07-04 | US | Kentucky | Fulton | 21075 | 1257 | 33 | 0 | 36.55238827 | -89.20140068 | 2022-07-05 04:20:45 | Fulton, Kentucky, US | |
2022-07-03 | US | Kentucky | Fulton | 21075 | 1257 | 33 | 0 | 36.55238827 | -89.20140068 | 2022-07-04 04:20:54 | Fulton, Kentucky, US | |
2022-07-02 | US | Kentucky | Fulton | 21075 | 1257 | 33 | 0 | 36.55238827 | -89.20140068 | 2022-07-03 04:20:59 | Fulton, Kentucky, US | |
2022-07-01 | US | Kentucky | Fulton | 21075 | 1257 | 33 | 0 | 36.55238827 | -89.20140068 | 2022-07-02 04:21:16 | Fulton, Kentucky, US | |
2022-06-30 | US | Kentucky | Fulton | 21075 | 1257 | 33 | 0 | 36.55238827 | -89.20140068 | 2022-07-01 04:21:10 | Fulton, Kentucky, US | |
2022-06-29 | US | Kentucky | Fulton | 21075 | 1257 | 33 | 0 | 36.55238827 | -89.20140068 | 2022-06-30 04:21:01 | Fulton, Kentucky, US | |
2022-06-28 | US | Kentucky | Fulton | 21075 | 1257 | 33 | 0 | 36.55238827 | -89.20140068 | 2022-06-29 04:20:59 | Fulton, Kentucky, US | |
2022-06-27 | US | Kentucky | Fulton | 21075 | 1257 | 33 | 0 | 36.55238827 | -89.20140068 | 2022-06-28 04:20:58 | Fulton, Kentucky, US | |
2022-06-24 | US | Texas | San Saba | 48411 | 1257 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-06-25 04:20:57 | San Saba, Texas, US | |
2022-06-23 | US | Texas | Goliad | 48175 | 1257 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-06-24 04:20:58 | Goliad, Texas, US | |
2022-06-13 | US | Colorado | Saguache | 8109 | 1257 | 12 | 0 | 38.08054629 | -106.282466 | 2022-06-14 04:20:52 | Saguache, Colorado, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;