daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,237 rows where active = 108 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 1,237 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-03-06 | US | Montana | Powder River | 30075 | 114 | 6 | 0 | 108 | 45.39617714 | -105.636738 | 2021-03-07 05:21:54 | Powder River, Montana, US |
2021-03-05 | US | Montana | Powder River | 30075 | 114 | 6 | 0 | 108 | 45.39617714 | -105.636738 | 2021-03-06 04:23:41 | Powder River, Montana, US |
2021-03-04 | US | Montana | Powder River | 30075 | 114 | 6 | 0 | 108 | 45.39617714 | -105.636738 | 2021-03-05 05:26:29 | Powder River, Montana, US |
2021-03-03 | US | Montana | Powder River | 30075 | 114 | 6 | 0 | 108 | 45.39617714 | -105.636738 | 2021-03-04 05:24:24 | Powder River, Montana, US |
2021-03-02 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-03-03 05:23:28 | Garden, Nebraska, US |
2021-03-01 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-03-02 05:23:30 | Garden, Nebraska, US |
2021-02-28 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-03-01 05:23:01 | Garden, Nebraska, US |
2021-02-27 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-28 05:22:20 | Garden, Nebraska, US |
2021-02-26 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-27 05:22:28 | Garden, Nebraska, US |
2021-02-25 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-26 05:22:40 | Garden, Nebraska, US |
2021-02-24 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-25 05:24:57 | Garden, Nebraska, US |
2021-02-23 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-24 05:29:16 | Garden, Nebraska, US |
2021-02-22 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-23 05:23:41 | Garden, Nebraska, US |
2021-02-21 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-22 05:24:21 | Garden, Nebraska, US |
2021-02-20 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-21 05:24:33 | Garden, Nebraska, US |
2021-02-19 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-20 05:22:51 | Garden, Nebraska, US |
2021-02-19 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-20 05:22:51 | Garfield, Washington, US |
2021-02-18 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-19 05:24:16 | Garden, Nebraska, US |
2021-02-18 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-19 05:24:16 | Garfield, Washington, US |
2021-02-17 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-18 05:22:58 | Garden, Nebraska, US |
2021-02-17 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-18 05:22:58 | Garfield, Washington, US |
2021-02-16 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-17 05:23:10 | Columbia, Washington, US |
2021-02-16 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-17 05:23:10 | Garfield, Washington, US |
2021-02-15 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-16 05:24:38 | Columbia, Washington, US |
2021-02-15 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-16 05:24:38 | Garfield, Washington, US |
2021-02-14 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-15 05:24:49 | Columbia, Washington, US |
2021-02-14 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-15 05:24:49 | Garfield, Washington, US |
2021-02-13 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-14 05:23:43 | Columbia, Washington, US |
2021-02-13 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-14 05:23:43 | Garfield, Washington, US |
2021-02-12 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-13 05:22:12 | Columbia, Washington, US |
2021-02-12 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-13 05:22:12 | Garfield, Washington, US |
2021-02-11 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-12 05:23:29 | Garfield, Washington, US |
2021-02-10 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-11 05:23:55 | Garfield, Washington, US |
2021-02-09 | US | Montana | Liberty | 30051 | 109 | 1 | 0 | 108 | 48.56084317 | -111.024307 | 2021-02-10 05:22:41 | Liberty, Montana, US |
2021-02-09 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-10 05:22:41 | Columbia, Washington, US |
2021-02-08 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-09 05:23:30 | Columbia, Washington, US |
2021-02-07 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-08 05:22:39 | Columbia, Washington, US |
2021-02-06 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-07 05:23:00 | Columbia, Washington, US |
2021-02-05 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-06 05:23:55 | Columbia, Washington, US |
2021-02-03 | US | Georgia | Taliaferro | 13265 | 108 | 0 | 0 | 108 | 33.56543317 | -82.88136816 | 2021-02-04 05:22:26 | Taliaferro, Georgia, US |
2021-02-01 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-02-02 05:22:49 | Wibaux, Montana, US |
2021-01-31 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-02-01 05:22:53 | Wibaux, Montana, US |
2021-01-30 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-31 05:22:42 | Wibaux, Montana, US |
2021-01-29 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-30 05:22:49 | Wibaux, Montana, US |
2021-01-28 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-29 05:22:23 | Wibaux, Montana, US |
2021-01-27 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-28 05:22:24 | Wibaux, Montana, US |
2021-01-26 | US | Montana | Meagher | 30059 | 115 | 7 | 0 | 108 | 46.59907074 | -110.8898557 | 2021-01-27 05:23:41 | Meagher, Montana, US |
2021-01-26 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-27 05:23:41 | Wibaux, Montana, US |
2021-01-25 | US | Colorado | Cheyenne | 8017 | 121 | 6 | 0 | 108 | 38.82777431 | -102.6032558 | 2021-01-26 05:22:02 | Cheyenne, Colorado, US |
2021-01-25 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-26 05:22:02 | Wibaux, Montana, US |
2021-01-24 | US | Colorado | Cheyenne | 8017 | 121 | 6 | 0 | 108 | 38.82777431 | -102.6032558 | 2021-01-25 05:22:16 | Cheyenne, Colorado, US |
2021-01-24 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-25 05:22:16 | Wibaux, Montana, US |
2021-01-23 | US | Colorado | Cheyenne | 8017 | 118 | 6 | 0 | 108 | 38.82777431 | -102.6032558 | 2021-01-24 05:22:35 | Cheyenne, Colorado, US |
2021-01-23 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-24 05:22:35 | Wibaux, Montana, US |
2021-01-22 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-23 05:22:03 | Wibaux, Montana, US |
2021-01-21 | US | Colorado | Cheyenne | 8017 | 117 | 6 | 0 | 108 | 38.82777431 | -102.6032558 | 2021-01-22 05:22:10 | Cheyenne, Colorado, US |
2021-01-21 | US | Kansas | Lane | 20101 | 115 | 7 | 0 | 108 | 38.48119447 | -100.4660754 | 2021-01-22 05:22:10 | Lane, Kansas, US |
2021-01-21 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-22 05:22:10 | Wibaux, Montana, US |
2021-01-20 | US | Kansas | Lane | 20101 | 115 | 7 | 0 | 108 | 38.48119447 | -100.4660754 | 2021-01-21 05:22:01 | Lane, Kansas, US |
2021-01-20 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-21 05:22:01 | Wibaux, Montana, US |
2021-01-19 | US | Georgia | Webster | 13307 | 110 | 2 | 0 | 108 | 32.04066113 | -84.54742852 | 2021-01-20 05:21:54 | Webster, Georgia, US |
2021-01-19 | US | Kansas | Lane | 20101 | 115 | 7 | 0 | 108 | 38.48119447 | -100.4660754 | 2021-01-20 05:21:54 | Lane, Kansas, US |
2021-01-19 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-20 05:21:54 | Wibaux, Montana, US |
2021-01-18 | US | Georgia | Webster | 13307 | 110 | 2 | 0 | 108 | 32.04066113 | -84.54742852 | 2021-01-19 05:22:15 | Webster, Georgia, US |
2021-01-18 | US | Kansas | Lane | 20101 | 115 | 7 | 0 | 108 | 38.48119447 | -100.4660754 | 2021-01-19 05:22:15 | Lane, Kansas, US |
2021-01-18 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-19 05:22:15 | Wibaux, Montana, US |
2021-01-17 | US | Georgia | Webster | 13307 | 110 | 2 | 0 | 108 | 32.04066113 | -84.54742852 | 2021-01-18 05:22:34 | Webster, Georgia, US |
2021-01-17 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-18 05:22:34 | Wibaux, Montana, US |
2021-01-16 | US | Georgia | Webster | 13307 | 110 | 2 | 0 | 108 | 32.04066113 | -84.54742852 | 2021-01-17 05:22:17 | Webster, Georgia, US |
2021-01-16 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-17 05:22:17 | Wibaux, Montana, US |
2021-01-15 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-16 05:22:40 | Wibaux, Montana, US |
2021-01-15 | US | Texas | Briscoe | 48045 | 158 | 3 | 0 | 108 | 34.53026962 | -101.2084947 | 2021-01-16 05:22:40 | Briscoe, Texas, US |
2021-01-14 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-15 05:22:24 | Wibaux, Montana, US |
2021-01-14 | US | Puerto Rico | Vieques | 72147 | 108 | 0 | 0 | 108 | 18.123276 | -65.44097099999999 | 2021-01-15 05:22:24 | Vieques, Puerto Rico, US |
2021-01-14 | US | Texas | Briscoe | 48045 | 158 | 3 | 0 | 108 | 34.53026962 | -101.2084947 | 2021-01-15 05:22:24 | Briscoe, Texas, US |
2021-01-13 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-14 05:22:32 | Wibaux, Montana, US |
2021-01-13 | US | Texas | Briscoe | 48045 | 158 | 3 | 0 | 108 | 34.53026962 | -101.2084947 | 2021-01-14 05:22:32 | Briscoe, Texas, US |
2021-01-12 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-13 05:22:15 | Wibaux, Montana, US |
2021-01-11 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-12 05:22:15 | Wibaux, Montana, US |
2021-01-10 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-11 05:21:50 | Wibaux, Montana, US |
2021-01-09 | US | Montana | Wibaux | 30109 | 113 | 5 | 0 | 108 | 46.95925154 | -104.2510927 | 2021-01-10 05:22:12 | Wibaux, Montana, US |
2021-01-09 | US | Oklahoma | Cimarron | 40025 | 109 | 1 | 0 | 108 | 36.74817177 | -102.5173885 | 2021-01-10 05:22:12 | Cimarron, Oklahoma, US |
2021-01-08 | US | Oklahoma | Cimarron | 40025 | 109 | 1 | 0 | 108 | 36.74817177 | -102.5173885 | 2021-01-09 05:22:18 | Cimarron, Oklahoma, US |
2021-01-08 | US | Texas | Stonewall | 48433 | 110 | 3 | 0 | 108 | 33.17906744 | -100.2538401 | 2021-01-09 05:22:18 | Stonewall, Texas, US |
2021-01-06 | US | Texas | Armstrong | 48011 | 184 | 5 | 0 | 108 | 34.96507426 | -101.3574874 | 2021-01-07 05:22:03 | Armstrong, Texas, US |
2021-01-06 | US | Texas | Jeff Davis | 48243 | 97 | 1 | 0 | 108 | 30.71490589 | -104.1399973 | 2021-01-07 05:22:03 | Jeff Davis, Texas, US |
2021-01-05 | US | Minnesota | Cook | 27031 | 108 | 0 | 0 | 108 | 47.90504893 | -90.52629546 | 2021-01-06 05:22:16 | Cook, Minnesota, US |
2021-01-04 | US | Minnesota | Cook | 27031 | 108 | 0 | 0 | 108 | 47.90504893 | -90.52629546 | 2021-01-05 05:21:49 | Cook, Minnesota, US |
2021-01-04 | US | Texas | Sherman | 48421 | 222 | 6 | 0 | 108 | 36.27751473 | -101.8933156 | 2021-01-05 05:21:49 | Sherman, Texas, US |
2021-01-03 | US | Texas | Sherman | 48421 | 222 | 6 | 0 | 108 | 36.27751473 | -101.8933156 | 2021-01-04 05:22:02 | Sherman, Texas, US |
2021-01-02 | US | Texas | Sherman | 48421 | 222 | 6 | 0 | 108 | 36.27751473 | -101.8933156 | 2021-01-03 05:22:52 | Sherman, Texas, US |
2021-01-01 | US | South Dakota | Sully | 46119 | 111 | 3 | 0 | 108 | 44.71571812 | -100.1278092 | 2021-01-02 05:22:33 | Sully, South Dakota, US |
2021-01-01 | US | Texas | Sherman | 48421 | 222 | 6 | 0 | 108 | 36.27751473 | -101.8933156 | 2021-01-02 05:22:33 | Sherman, Texas, US |
2020-12-31 | US | South Dakota | Sully | 46119 | 111 | 3 | 0 | 108 | 44.71571812 | -100.1278092 | 2021-01-01 05:23:07 | Sully, South Dakota, US |
2020-12-30 | US | South Dakota | Sully | 46119 | 111 | 3 | 0 | 108 | 44.71571812 | -100.1278092 | 2020-12-31 05:22:49 | Sully, South Dakota, US |
2020-12-29 | US | Texas | Dickens | 48125 | 149 | 7 | 0 | 108 | 33.61616822 | -100.7788855 | 2020-12-30 05:22:34 | Dickens, Texas, US |
2020-12-28 | US | South Dakota | Campbell | 46021 | 112 | 4 | 0 | 108 | 45.77074915 | -100.0510181 | 2020-12-29 05:22:37 | Campbell, South Dakota, US |
2020-12-28 | US | Texas | Dickens | 48125 | 148 | 7 | 0 | 108 | 33.61616822 | -100.7788855 | 2020-12-29 05:22:37 | Dickens, Texas, US |
2020-12-27 | US | Texas | Dickens | 48125 | 144 | 7 | 0 | 108 | 33.61616822 | -100.7788855 | 2020-12-28 05:22:06 | Dickens, Texas, US |
2020-12-26 | US | New Mexico | Mora | 35033 | 109 | 1 | 0 | 108 | 36.01095101 | -104.9497716 | 2020-12-27 05:22:55 | Mora, New Mexico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;