daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,636 rows where active = 72 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 161
- Virginia 84
- Colorado 78
- Kentucky 68
- Missouri 68
- Nebraska 61
- Georgia 59
- Illinois 59
- Indiana 58
- Oklahoma 54
- Kansas 48
- Iowa 47
- New Mexico 41
- Tennessee 41
- Michigan 40
- Minnesota 40
- North Carolina 38
- South Dakota 36
- Puerto Rico 33
- Alabama 32
- New York 32
- Pennsylvania 32
- West Virginia 32
- Arkansas 30
- Idaho 29
- Mississippi 29
- Montana 29
- Ohio 29
- Wisconsin 25
- California 23
- …
country_or_region 1
- US · 1,636 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-03-03 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-03-04 05:24:24 | Terrell, Texas, US |
2021-03-02 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-03-03 05:23:28 | Terrell, Texas, US |
2021-03-01 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-03-02 05:23:30 | Terrell, Texas, US |
2021-02-28 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-03-01 05:23:01 | Terrell, Texas, US |
2021-02-27 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-28 05:22:20 | Terrell, Texas, US |
2021-02-26 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-27 05:22:28 | Terrell, Texas, US |
2021-02-25 | US | Alaska | Denali | 2068 | 72 | 0 | 0 | 72 | 63.67264044 | -150.0076108 | 2021-02-26 05:22:40 | Denali, Alaska, US |
2021-02-25 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-26 05:22:40 | Terrell, Texas, US |
2021-02-24 | US | Alaska | Denali | 2068 | 72 | 0 | 0 | 72 | 63.67264044 | -150.0076108 | 2021-02-25 05:24:57 | Denali, Alaska, US |
2021-02-24 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-25 05:24:57 | Terrell, Texas, US |
2021-02-23 | US | Alaska | Denali | 2068 | 72 | 0 | 0 | 72 | 63.67264044 | -150.0076108 | 2021-02-24 05:29:16 | Denali, Alaska, US |
2021-02-23 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-24 05:29:16 | Terrell, Texas, US |
2021-02-22 | US | Alaska | Denali | 2068 | 72 | 0 | 0 | 72 | 63.67264044 | -150.0076108 | 2021-02-23 05:23:41 | Denali, Alaska, US |
2021-02-22 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-23 05:23:41 | Terrell, Texas, US |
2021-02-21 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-22 05:24:21 | Terrell, Texas, US |
2021-02-20 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-21 05:24:33 | Terrell, Texas, US |
2021-02-19 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-20 05:22:51 | Terrell, Texas, US |
2021-02-18 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-19 05:24:16 | Terrell, Texas, US |
2021-02-17 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-18 05:22:58 | Terrell, Texas, US |
2021-02-16 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-17 05:23:10 | Storey, Nevada, US |
2021-02-16 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-17 05:23:10 | Terrell, Texas, US |
2021-02-15 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-16 05:24:38 | Storey, Nevada, US |
2021-02-15 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-16 05:24:38 | Terrell, Texas, US |
2021-02-14 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-15 05:24:49 | Storey, Nevada, US |
2021-02-14 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-15 05:24:49 | Terrell, Texas, US |
2021-02-13 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-14 05:23:43 | Storey, Nevada, US |
2021-02-13 | US | New Mexico | Catron | 35003 | 76 | 4 | 0 | 72 | 33.91514144 | -108.4046587 | 2021-02-14 05:23:43 | Catron, New Mexico, US |
2021-02-13 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-14 05:23:43 | Terrell, Texas, US |
2021-02-12 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-13 05:22:12 | Storey, Nevada, US |
2021-02-12 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-13 05:22:12 | Terrell, Texas, US |
2021-02-11 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-12 05:23:29 | Storey, Nevada, US |
2021-02-11 | US | Texas | McMullen | 48311 | 81 | 4 | 0 | 72 | 28.35251708 | -98.56769164 | 2021-02-12 05:23:29 | McMullen, Texas, US |
2021-02-11 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-12 05:23:29 | Terrell, Texas, US |
2021-02-11 | US | Washington | Wahkiakum | 53069 | 72 | 0 | 0 | 72 | 46.29180039999999 | -123.4250831 | 2021-02-12 05:23:29 | Wahkiakum, Washington, US |
2021-02-10 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-11 05:23:55 | Storey, Nevada, US |
2021-02-10 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-11 05:23:55 | Terrell, Texas, US |
2021-02-10 | US | Washington | Wahkiakum | 53069 | 72 | 0 | 0 | 72 | 46.29180039999999 | -123.4250831 | 2021-02-11 05:23:55 | Wahkiakum, Washington, US |
2021-02-09 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-10 05:22:41 | Storey, Nevada, US |
2021-02-07 | US | Nevada | Storey | 32029 | 74 | 2 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-08 05:22:39 | Storey, Nevada, US |
2021-02-06 | US | Nevada | Storey | 32029 | 74 | 2 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-07 05:23:00 | Storey, Nevada, US |
2021-02-05 | US | California | Alpine | 6003 | 72 | 0 | 0 | 72 | 38.59678594 | -119.8223594 | 2021-02-06 05:23:55 | Alpine, California, US |
2021-02-03 | US | Nebraska | Logan | 31113 | 72 | 0 | 0 | 72 | 41.56650314 | -100.4817851 | 2021-02-04 05:22:26 | Logan, Nebraska, US |
2021-02-03 | US | Texas | Kent | 48263 | 73 | 1 | 0 | 72 | 33.18104136 | -100.7780939 | 2021-02-04 05:22:26 | Kent, Texas, US |
2021-02-01 | US | Nebraska | Logan | 31113 | 72 | 0 | 0 | 72 | 41.56650314 | -100.4817851 | 2021-02-02 05:22:49 | Logan, Nebraska, US |
2021-01-31 | US | Nebraska | Logan | 31113 | 72 | 0 | 0 | 72 | 41.56650314 | -100.4817851 | 2021-02-01 05:22:53 | Logan, Nebraska, US |
2021-01-30 | US | Nebraska | Logan | 31113 | 72 | 0 | 0 | 72 | 41.56650314 | -100.4817851 | 2021-01-31 05:22:42 | Logan, Nebraska, US |
2021-01-28 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-29 05:22:23 | Garfield, Montana, US |
2021-01-27 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-28 05:22:24 | Garfield, Montana, US |
2021-01-26 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-27 05:23:41 | Garfield, Montana, US |
2021-01-26 | US | Nebraska | Logan | 31113 | 72 | 0 | 0 | 72 | 41.56650314 | -100.4817851 | 2021-01-27 05:23:41 | Logan, Nebraska, US |
2021-01-25 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-26 05:22:02 | Garfield, Montana, US |
2021-01-25 | US | Nebraska | Logan | 31113 | 72 | 0 | 0 | 72 | 41.56650314 | -100.4817851 | 2021-01-26 05:22:02 | Logan, Nebraska, US |
2021-01-25 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-01-26 05:22:02 | Terrell, Texas, US |
2021-01-24 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-25 05:22:16 | Garfield, Montana, US |
2021-01-23 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-24 05:22:35 | Garfield, Montana, US |
2021-01-23 | US | Nebraska | Logan | 31113 | 72 | 0 | 0 | 72 | 41.56650314 | -100.4817851 | 2021-01-24 05:22:35 | Logan, Nebraska, US |
2021-01-23 | US | Virginia | Highland | 51091 | 72 | 0 | 0 | 72 | 38.35799465 | -79.56124594 | 2021-01-24 05:22:35 | Highland, Virginia, US |
2021-01-22 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-23 05:22:03 | Garfield, Montana, US |
2021-01-22 | US | Nebraska | Logan | 31113 | 72 | 0 | 0 | 72 | 41.56650314 | -100.4817851 | 2021-01-23 05:22:03 | Logan, Nebraska, US |
2021-01-22 | US | Texas | Motley | 48345 | 117 | 7 | 0 | 72 | 34.07408766 | -100.779722 | 2021-01-23 05:22:03 | Motley, Texas, US |
2021-01-22 | US | Texas | Terrell | 48443 | 66 | 1 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-01-23 05:22:03 | Terrell, Texas, US |
2021-01-22 | US | Virginia | Highland | 51091 | 72 | 0 | 0 | 72 | 38.35799465 | -79.56124594 | 2021-01-23 05:22:03 | Highland, Virginia, US |
2021-01-21 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-22 05:22:10 | Garfield, Montana, US |
2021-01-21 | US | Texas | Motley | 48345 | 117 | 7 | 0 | 72 | 34.07408766 | -100.779722 | 2021-01-22 05:22:10 | Motley, Texas, US |
2021-01-21 | US | Texas | Terrell | 48443 | 66 | 1 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-01-22 05:22:10 | Terrell, Texas, US |
2021-01-20 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-21 05:22:01 | Garfield, Montana, US |
2021-01-20 | US | Texas | Motley | 48345 | 117 | 7 | 0 | 72 | 34.07408766 | -100.779722 | 2021-01-21 05:22:01 | Motley, Texas, US |
2021-01-20 | US | Texas | Terrell | 48443 | 66 | 1 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-01-21 05:22:01 | Terrell, Texas, US |
2021-01-19 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-20 05:21:54 | Garfield, Montana, US |
2021-01-19 | US | Texas | Motley | 48345 | 117 | 7 | 0 | 72 | 34.07408766 | -100.779722 | 2021-01-20 05:21:54 | Motley, Texas, US |
2021-01-19 | US | Texas | Terrell | 48443 | 66 | 1 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-01-20 05:21:54 | Terrell, Texas, US |
2021-01-18 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-19 05:22:15 | Garfield, Montana, US |
2021-01-17 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-18 05:22:34 | Garfield, Montana, US |
2021-01-16 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-17 05:22:17 | Garfield, Montana, US |
2021-01-15 | US | Montana | Garfield | 30033 | 74 | 2 | 0 | 72 | 47.27545948 | -107.0002351 | 2021-01-16 05:22:40 | Garfield, Montana, US |
2021-01-14 | US | South Dakota | Jones | 46075 | 72 | 0 | 0 | 72 | 43.96278565 | -100.6940008 | 2021-01-15 05:22:24 | Jones, South Dakota, US |
2021-01-11 | US | California | Alpine | 6003 | 72 | 0 | 0 | 72 | 38.59678594 | -119.8223594 | 2021-01-12 05:22:15 | Alpine, California, US |
2021-01-10 | US | California | Alpine | 6003 | 72 | 0 | 0 | 72 | 38.59678594 | -119.8223594 | 2021-01-11 05:21:50 | Alpine, California, US |
2021-01-09 | US | California | Alpine | 6003 | 72 | 0 | 0 | 72 | 38.59678594 | -119.8223594 | 2021-01-10 05:22:12 | Alpine, California, US |
2021-01-06 | US | Texas | Motley | 48345 | 115 | 5 | 0 | 72 | 34.07408766 | -100.779722 | 2021-01-07 05:22:03 | Motley, Texas, US |
2021-01-05 | US | Texas | Irion | 48235 | 68 | 0 | 0 | 72 | 31.30375559 | -100.982439 | 2021-01-06 05:22:16 | Irion, Texas, US |
2021-01-05 | US | Texas | Motley | 48345 | 115 | 5 | 0 | 72 | 34.07408766 | -100.779722 | 2021-01-06 05:22:16 | Motley, Texas, US |
2020-12-29 | US | Colorado | Kiowa | 8061 | 78 | 2 | 0 | 72 | 38.43260896 | -102.7392145 | 2020-12-30 05:22:34 | Kiowa, Colorado, US |
2020-12-28 | US | Colorado | Kiowa | 8061 | 78 | 2 | 0 | 72 | 38.43260896 | -102.7392145 | 2020-12-29 05:22:37 | Kiowa, Colorado, US |
2020-12-28 | US | Texas | Stonewall | 48433 | 79 | 3 | 0 | 72 | 33.17906744 | -100.2538401 | 2020-12-29 05:22:37 | Stonewall, Texas, US |
2020-12-27 | US | Colorado | Kiowa | 8061 | 78 | 2 | 0 | 72 | 38.43260896 | -102.7392145 | 2020-12-28 05:22:06 | Kiowa, Colorado, US |
2020-12-27 | US | Texas | Stonewall | 48433 | 74 | 3 | 0 | 72 | 33.17906744 | -100.2538401 | 2020-12-28 05:22:06 | Stonewall, Texas, US |
2020-12-25 | US | Oregon | Wallowa | 41063 | 75 | 3 | 0 | 72 | 45.57894064 | -117.18353799999998 | 2020-12-26 05:22:28 | Wallowa, Oregon, US |
2020-12-24 | US | Oregon | Wallowa | 41063 | 75 | 3 | 0 | 72 | 45.57894064 | -117.18353799999998 | 2020-12-25 05:22:48 | Wallowa, Oregon, US |
2020-12-23 | US | Oregon | Wallowa | 41063 | 75 | 3 | 0 | 72 | 45.57894064 | -117.18353799999998 | 2020-12-24 05:23:04 | Wallowa, Oregon, US |
2020-12-22 | US | Oregon | Wallowa | 41063 | 75 | 3 | 0 | 72 | 45.57894064 | -117.18353799999998 | 2020-12-23 05:22:03 | Wallowa, Oregon, US |
2020-12-22 | US | Washington | San Juan | 53055 | 72 | 0 | 0 | 72 | 48.60182783 | -122.96745 | 2020-12-23 05:22:03 | San Juan, Washington, US |
2020-12-16 | US | Montana | Judith Basin | 30045 | 72 | 0 | 0 | 72 | 47.04581276 | -110.2660688 | 2020-12-17 05:28:12 | Judith Basin, Montana, US |
2020-12-16 | US | New York | Hamilton | 36041 | 73 | 1 | 0 | 72 | 43.66146647 | -74.49721957 | 2020-12-17 05:28:12 | Hamilton, New York, US |
2020-12-15 | US | Montana | Judith Basin | 30045 | 72 | 0 | 0 | 72 | 47.04581276 | -110.2660688 | 2020-12-16 05:28:04 | Judith Basin, Montana, US |
2020-12-15 | US | New Mexico | Mora | 35033 | 72 | 0 | 0 | 72 | 36.01095101 | -104.9497716 | 2020-12-16 05:28:04 | Mora, New Mexico, US |
2020-12-15 | US | Oregon | Wallowa | 41063 | 75 | 3 | 0 | 72 | 45.57894064 | -117.18353799999998 | 2020-12-16 05:28:04 | Wallowa, Oregon, US |
2020-12-14 | US | Maine | Piscataquis | 23021 | 73 | 1 | 0 | 72 | 45.83839062 | -69.2860223 | 2020-12-15 05:26:38 | Piscataquis, Maine, US |
2020-12-13 | US | Washington | San Juan | 53055 | 72 | 0 | 0 | 72 | 48.60182783 | -122.96745 | 2020-12-14 05:26:27 | San Juan, Washington, US |
2020-12-12 | US | Vermont | Essex | 50009 | 72 | 0 | 0 | 72 | 44.72736416 | -71.73579864 | 2020-12-13 05:27:20 | Essex, Vermont, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;