daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,284,537 rows where country_or_region = "US" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state
country_or_region 1
- US · 3,284,537 ✖
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | US | American Samoa | 60 | 10 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-12-03 04:23:05 | American Samoa, US | ||
2021-12-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-12-02 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-12-02 | US | Guam | 66 | 19227 | 266 | 0 | 13.4443 | 144.7937 | 2021-12-03 04:23:05 | Guam, US | ||
2021-12-02 | US | Northern Mariana Islands | 69 | 1062 | 3 | 0 | 15.0979 | 145.6739 | 2021-12-03 04:23:05 | Northern Mariana Islands, US | ||
2021-12-02 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-12-03 04:23:05 | Recovered, US | |||
2021-12-02 | US | Virgin Islands | 78 | 7525 | 87 | 0 | 18.3358 | -64.8963 | 2021-12-03 04:23:05 | Virgin Islands, US | ||
2021-10-28 | US | American Samoa | 60 | 4 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-10-29 04:22:03 | American Samoa, US | ||
2021-10-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-10-28 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-10-28 | US | Guam | 66 | 18040 | 235 | 0 | 13.4443 | 144.7937 | 2021-10-29 04:22:03 | Guam, US | ||
2021-10-28 | US | Northern Mariana Islands | 69 | 298 | 3 | 0 | 15.0979 | 145.6739 | 2021-10-29 04:22:03 | Northern Mariana Islands, US | ||
2021-10-28 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-10-29 04:22:03 | Recovered, US | |||
2021-10-28 | US | Virgin Islands | 78 | 7186 | 81 | 0 | 18.3358 | -64.8963 | 2021-10-29 04:22:03 | Virgin Islands, US | ||
2020-10-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2020-10-25 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
2020-10-25 | US | Guam | 66 | 4216 | 71 | 0 | 4145 | 13.4443 | 144.7937 | 2020-10-26 04:25:02 | Guam, US | |
2020-10-25 | US | Northern Mariana Islands | 69 | 88 | 2 | 0 | 86 | 15.0979 | 145.6739 | 2020-10-26 04:25:02 | Northern Mariana Islands, US | |
2020-10-25 | US | Recovered | 0 | 0 | 3422878 | 0 | 0.0 | 0.0 | 2020-10-26 04:25:02 | Recovered, US | ||
2020-10-25 | US | Virgin Islands | 78 | 1346 | 21 | 0 | 1325 | 18.3358 | -64.8963 | 2020-10-26 04:25:02 | Virgin Islands, US | |
2021-01-26 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2021-01-26 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
2021-01-26 | US | Guam | 66 | 7566 | 129 | 0 | 7437 | 13.4443 | 144.7937 | 2021-01-27 05:23:41 | Guam, US | |
2021-01-26 | US | Northern Mariana Islands | 69 | 132 | 2 | 0 | 130 | 15.0979 | 145.6739 | 2021-01-27 05:23:41 | Northern Mariana Islands, US | |
2021-01-26 | US | Recovered | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2021-01-27 05:23:41 | Recovered, US | ||
2021-01-26 | US | Virgin Islands | 78 | 2373 | 24 | 0 | 2349 | 18.3358 | -64.8963 | 2021-01-27 05:23:41 | Virgin Islands, US | |
2021-09-18 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-09-18 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-09-18 | US | Guam | 66 | 13438 | 179 | 0 | 13.4443 | 144.7937 | 2021-09-19 04:21:34 | Guam, US | ||
2021-09-18 | US | Northern Mariana Islands | 69 | 258 | 2 | 0 | 15.0979 | 145.6739 | 2021-09-19 04:21:34 | Northern Mariana Islands, US | ||
2021-09-18 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-09-19 04:21:34 | Recovered, US | |||
2021-09-18 | US | Virgin Islands | 78 | 6458 | 67 | 0 | 18.3358 | -64.8963 | 2021-09-19 04:21:34 | Virgin Islands, US | ||
2021-05-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-05-28 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-05-28 | US | Guam | 66 | 8156 | 139 | 0 | 13.4443 | 144.7937 | 2021-05-29 04:20:41 | Guam, US | ||
2021-05-28 | US | Northern Mariana Islands | 69 | 183 | 2 | 0 | 15.0979 | 145.6739 | 2021-05-29 04:20:41 | Northern Mariana Islands, US | ||
2021-05-28 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-05-29 04:20:41 | Recovered, US | |||
2021-05-28 | US | Virgin Islands | 78 | 3442 | 27 | 0 | 18.3358 | -64.8963 | 2021-05-29 04:20:41 | Virgin Islands, US | ||
2022-03-20 | US | American Samoa | 60 | 1066 | 0 | 0 | -14.270999999999999 | -170.132 | 2022-03-21 04:20:50 | American Samoa, US | ||
2022-03-20 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2022-03-20 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2022-03-20 | US | Guam | 66 | 46730 | 341 | 0 | 13.4443 | 144.7937 | 2022-03-21 04:20:50 | Guam, US | ||
2022-03-20 | US | Northern Mariana Islands | 69 | 10689 | 31 | 0 | 15.0979 | 145.6739 | 2022-03-21 04:20:50 | Northern Mariana Islands, US | ||
2022-03-20 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2022-03-21 04:20:50 | Recovered, US | |||
2022-03-20 | US | Virgin Islands | 78 | 15578 | 110 | 0 | 18.3358 | -64.8963 | 2022-03-21 04:20:50 | Virgin Islands, US | ||
2021-11-11 | US | American Samoa | 60 | 4 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-11-12 04:22:01 | American Samoa, US | ||
2021-11-11 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-11-11 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-11-11 | US | Guam | 66 | 18840 | 258 | 0 | 13.4443 | 144.7937 | 2021-11-12 04:22:01 | Guam, US | ||
2021-11-11 | US | Northern Mariana Islands | 69 | 381 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-12 04:22:01 | Northern Mariana Islands, US | ||
2021-11-11 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-11-12 04:22:01 | Recovered, US | |||
2021-11-11 | US | Virgin Islands | 78 | 7329 | 84 | 0 | 18.3358 | -64.8963 | 2021-11-12 04:22:01 | Virgin Islands, US | ||
2021-08-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-08-25 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-08-25 | US | Guam | 66 | 9759 | 145 | 0 | 13.4443 | 144.7937 | 2021-08-26 04:21:28 | Guam, US | ||
2021-08-25 | US | Northern Mariana Islands | 69 | 229 | 2 | 0 | 15.0979 | 145.6739 | 2021-08-26 04:21:28 | Northern Mariana Islands, US | ||
2021-08-25 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-08-26 04:21:28 | Recovered, US | |||
2021-08-25 | US | Virgin Islands | 78 | 5707 | 51 | 0 | 18.3358 | -64.8963 | 2021-08-26 04:21:28 | Virgin Islands, US | ||
2021-04-12 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-04-12 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-04-12 | US | Guam | 66 | 7842 | 136 | 0 | 13.4443 | 144.7937 | 2021-04-13 04:20:37 | Guam, US | ||
2021-04-12 | US | Northern Mariana Islands | 69 | 160 | 2 | 0 | 15.0979 | 145.6739 | 2021-04-13 04:20:37 | Northern Mariana Islands, US | ||
2021-04-12 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-04-13 04:20:37 | Recovered, US | |||
2021-04-12 | US | Virgin Islands | 78 | 3005 | 26 | 0 | 18.3358 | -64.8963 | 2021-04-13 04:20:37 | Virgin Islands, US | ||
2020-03-05 | US | King County, WA | 51 | 10 | 1 | 47.548 | -121.9836 | 2020-03-05T22:03:17 | ||||
2020-03-05 | US | Unassigned Location (From Diamond Princess) | 45 | 0 | 0 | 35.4437 | 139.638 | 2020-03-02T19:53:03 | ||||
2020-03-05 | US | Santa Clara, CA | 20 | 0 | 1 | 37.3541 | -121.9552 | 2020-03-05T22:53:03 | ||||
2020-03-05 | US | Snohomish County, WA | 18 | 1 | 0 | 48.033 | -121.8339 | 2020-03-05T20:23:07 | ||||
2020-03-05 | US | Westchester County, NY | 18 | 0 | 0 | 41.122 | -73.7949 | 2020-03-05T21:33:03 | ||||
2020-03-05 | US | Los Angeles, CA | 11 | 0 | 0 | 34.0522 | -118.2437 | 2020-03-05T21:03:14 | ||||
2020-03-05 | US | Cook County, IL | 5 | 0 | 2 | 41.7377 | -87.6976 | 2020-03-05T18:33:03 | ||||
2020-03-05 | US | New York City, NY | 4 | 0 | 0 | 40.7128 | -74.006 | 2020-03-05T21:03:13 | ||||
2020-03-05 | US | Orange County, CA | 3 | 0 | 0 | 33.7879 | -117.8531 | 2020-03-04T02:13:11 | ||||
2020-03-05 | US | San Diego County, CA | 3 | 0 | 1 | 32.7157 | -117.1611 | 2020-03-05T20:33:03 | ||||
2020-03-05 | US | Bergen County, NJ | 2 | 0 | 0 | 40.9263 | -74.077 | 2020-03-05T21:03:12 | ||||
2020-03-05 | US | Fulton County, GA | 2 | 0 | 0 | 33.8034 | -84.3963 | 2020-03-03T03:33:02 | ||||
2020-03-05 | US | Grafton County, NH | 2 | 0 | 0 | 43.9088 | -71.826 | 2020-03-03T23:33:03 | ||||
2020-03-05 | US | Harris County, TX | 2 | 0 | 0 | 29.7752 | -95.3103 | 2020-03-05T21:53:02 | ||||
2020-03-05 | US | Hillsborough, FL | 2 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-03T18:33:02 | ||||
2020-03-05 | US | Placer County, CA | 2 | 1 | 0 | 39.0916 | -120.8039 | 2020-03-04T19:53:02 | ||||
2020-03-05 | US | Providence, RI | 2 | 0 | 0 | 41.824 | -71.4128 | 2020-03-02T03:43:02 | ||||
2020-03-05 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
2020-03-05 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
2020-03-05 | US | San Francisco County, CA | 2 | 0 | 0 | 37.7749 | -122.4194 | 2020-03-05T20:33:03 | ||||
2020-03-05 | US | San Mateo, CA | 2 | 0 | 0 | 37.563 | -122.3255 | 2020-03-03T00:43:02 | ||||
2020-03-05 | US | Washington County, OR | 2 | 0 | 0 | 45.547 | -123.1386 | 2020-03-03T03:03:02 | ||||
2020-03-05 | US | Norfolk County, MA | 1 | 0 | 0 | 42.1767 | -71.1449 | 2020-03-03T14:33:03 | ||||
2020-03-05 | US | Berkeley, CA | 1 | 0 | 0 | 37.8715 | -122.273 | 2020-03-03T23:53:03 | ||||
2020-03-05 | US | Boston, MA | 1 | 0 | 1 | 42.3601 | -71.0589 | 2020-02-28T21:13:12 | ||||
2020-03-05 | US | Clark County, NV | 1 | 0 | 0 | 36.0796 | -115.094 | 2020-03-05T20:53:03 | ||||
2020-03-05 | US | Contra Costa County, CA | 1 | 0 | 0 | 37.8534 | -121.9018 | 2020-03-04T04:23:05 | ||||
2020-03-05 | US | Fort Bend County, TX | 1 | 0 | 0 | 29.5693 | -95.8143 | 2020-03-05T01:16:59 | ||||
2020-03-05 | US | Grant County, WA | 1 | 0 | 0 | 47.1981 | -119.3732 | 2020-03-05T20:23:07 | ||||
2020-03-05 | US | Humboldt County, CA | 1 | 0 | 0 | 40.745 | -123.8695 | 2020-02-21T05:13:09 | ||||
2020-03-05 | US | Madison, WI | 1 | 0 | 1 | 43.0731 | -89.4012 | 2020-03-03T15:53:03 | ||||
2020-03-05 | US | Maricopa County, AZ | 1 | 0 | 0 | 33.2918 | -112.4291 | 2020-03-03T17:33:02 | ||||
2020-03-05 | US | Queens County, NY | 1 | 0 | 0 | 40.7282 | -73.7949 | 2020-03-05T21:43:02 | ||||
2020-03-05 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
2020-03-05 | US | Santa Rosa County, FL | 1 | 0 | 0 | 30.769 | -86.9824 | 2020-03-05T20:03:03 | ||||
2020-03-05 | US | Sarasota, FL | 1 | 0 | 0 | 27.3364 | -82.5307 | 2020-03-02T03:23:06 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;