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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | US | Sonoma County, CA | 1 | 0 | 0 | 38.578 | -122.9888 | 2020-03-02T20:53:02 | ||||
2020-03-05 | US | Tempe, AZ | 1 | 0 | 1 | 33.4255 | -111.94 | 2020-02-25T21:23:03 | ||||
2020-03-05 | US | Umatilla, OR | 1 | 0 | 0 | 45.775 | -118.7606 | 2020-03-02T20:23:16 | ||||
2020-03-05 | US | Wake County, NC | 1 | 0 | 0 | 35.8032 | -78.5661 | 2020-03-03T20:53:02 | ||||
2020-03-05 | US | Williamson County, TN | 1 | 0 | 0 | 35.9179 | -86.8622 | 2020-03-05T23:33:03 | ||||
2020-03-05 | US | Lackland, TX (From Diamond Princess) | 0 | 0 | 0 | 29.3829 | -98.6134 | 2020-02-24T23:33:02 | ||||
2020-03-05 | US | Omaha, NE (From Diamond Princess) | 0 | 0 | 0 | 41.2545 | -95.9758 | 2020-02-24T23:33:02 | ||||
2020-03-05 | US | Travis, CA (From Diamond Princess) | 0 | 0 | 0 | 38.2721 | -121.9399 | 2020-02-24T23:33:02 | ||||
2020-04-13 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-04-13 23:07:54 | Diamond Princess, US | |
2020-04-13 | US | Grand Princess | 99999 | 103 | 0 | 0 | 103 | 37.64894 | 0.0 | 2020-04-13 23:07:54 | Grand Princess, US | |
2020-04-13 | US | Guam | 66 | 133 | 5 | 0 | 128 | 13.4443 | 144.7937 | 2020-04-13 23:07:54 | Guam, US | |
2020-04-13 | US | Northern Mariana Islands | 11 | 2 | 0 | 9 | 15.0979 | 145.6739 | 2020-04-13 23:07:54 | Northern Mariana Islands, US | ||
2020-04-13 | US | Puerto Rico | 72 | 903 | 45 | 0 | 858 | 18.2208 | -66.5901 | 2020-04-13 23:07:54 | Puerto Rico, US | |
2020-04-13 | US | Recovered | 0 | 0 | 43482 | 0 | 0.0 | 0.0 | 2020-04-13 23:07:54 | Recovered, US | ||
2020-04-13 | US | Virgin Islands | 78 | 51 | 1 | 0 | 50 | 18.3358 | -64.8963 | 2020-04-13 23:07:54 | Virgin Islands, US | |
2021-11-02 | US | American Samoa | 60 | 4 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-11-03 06:22:09 | American Samoa, US | ||
2021-11-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-11-02 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-11-02 | US | Guam | 66 | 18321 | 242 | 0 | 13.4443 | 144.7937 | 2021-11-03 06:22:09 | Guam, US | ||
2021-11-02 | US | Northern Mariana Islands | 69 | 329 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-03 06:22:09 | Northern Mariana Islands, US | ||
2021-11-02 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-11-03 06:22:09 | Recovered, US | |||
2021-11-02 | US | Virgin Islands | 78 | 7233 | 81 | 0 | 18.3358 | -64.8963 | 2021-11-03 06:22:09 | Virgin Islands, US | ||
2020-04-17 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-04-17 23:30:52 | Diamond Princess, US | |
2020-04-17 | US | Grand Princess | 99999 | 103 | 0 | 0 | 103 | 37.64894 | 0.0 | 2020-04-17 23:30:52 | Grand Princess, US | |
2020-04-17 | US | Guam | 66 | 136 | 5 | 0 | 131 | 13.4443 | 144.7937 | 2020-04-17 23:30:52 | Guam, US | |
2020-04-17 | US | Northern Mariana Islands | 69 | 13 | 2 | 0 | 11 | 15.0979 | 145.6739 | 2020-04-17 23:30:52 | Northern Mariana Islands, US | |
2020-04-17 | US | Puerto Rico | 72 | 1068 | 58 | 0 | 1010 | 18.2208 | -66.5901 | 2020-04-17 23:30:52 | Puerto Rico, US | |
2020-04-17 | US | Recovered | 0 | 0 | 58545 | 0 | 0.0 | 0.0 | 2020-04-17 23:30:52 | Recovered, US | ||
2020-04-17 | US | Virgin Islands | 78 | 51 | 2 | 0 | 49 | 18.3358 | -64.8963 | 2020-04-17 23:30:52 | Virgin Islands, US | |
2021-05-29 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-05-29 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-05-29 | US | Guam | 66 | 8156 | 139 | 0 | 13.4443 | 144.7937 | 2021-05-30 04:20:55 | Guam, US | ||
2021-05-29 | US | Northern Mariana Islands | 69 | 183 | 2 | 0 | 15.0979 | 145.6739 | 2021-05-30 04:20:55 | Northern Mariana Islands, US | ||
2021-05-29 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-05-30 04:20:55 | Recovered, US | |||
2021-05-29 | US | Virgin Islands | 78 | 3442 | 27 | 0 | 18.3358 | -64.8963 | 2021-05-30 04:20:55 | Virgin Islands, US | ||
2021-03-07 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-03-07 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-03-07 | US | Guam | 66 | 7749 | 133 | 0 | 13.4443 | 144.7937 | 2021-03-08 05:24:48 | Guam, US | ||
2021-03-07 | US | Northern Mariana Islands | 69 | 145 | 2 | 0 | 15.0979 | 145.6739 | 2021-03-08 05:24:48 | Northern Mariana Islands, US | ||
2021-03-07 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-03-08 05:24:48 | Recovered, US | |||
2021-03-07 | US | Virgin Islands | 78 | 2735 | 25 | 0 | 18.3358 | -64.8963 | 2021-03-08 05:24:48 | Virgin Islands, US | ||
2020-07-23 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-07-24 05:30:40 | Diamond Princess, US | |
2020-07-23 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-24 05:30:40 | Grand Princess, US | |
2020-07-23 | US | Guam | 66 | 332 | 5 | 0 | 327 | 13.4443 | 144.7937 | 2020-07-24 05:30:40 | Guam, US | |
2020-07-23 | US | Northern Mariana Islands | 69 | 38 | 2 | 0 | 36 | 15.0979 | 145.6739 | 2020-07-24 05:30:40 | Northern Mariana Islands, US | |
2020-07-23 | US | Recovered | 0 | 0 | 1233269 | 0 | 0.0 | 0.0 | 2020-07-24 05:30:40 | Recovered, US | ||
2020-07-23 | US | Virgin Islands | 78 | 336 | 7 | 0 | 329 | 18.3358 | -64.8963 | 2020-07-24 05:30:40 | Virgin Islands, US | |
2020-03-07 | US | King County, WA | 71 | 15 | 1 | 47.548 | -121.9836 | 2020-03-07T20:23:03 | ||||
2020-03-07 | US | Westchester County, NY | 57 | 0 | 0 | 41.122 | -73.7949 | 2020-03-07T18:23:05 | ||||
2020-03-07 | US | Unassigned Location (From Diamond Princess) | 45 | 0 | 0 | 35.4437 | 139.638 | 2020-03-02T19:53:03 | ||||
2020-03-07 | US | Santa Clara County, CA | 32 | 0 | 1 | 37.3541 | -121.9552 | 2020-03-07T23:43:03 | ||||
2020-03-07 | US | Snohomish County, WA | 27 | 1 | 0 | 48.033 | -121.8339 | 2020-03-07T20:23:03 | ||||
2020-03-07 | US | Grand Princess Cruise Ship | 21 | 0 | 0 | 37.6489 | -122.6655 | 2020-03-07T01:33:02 | ||||
2020-03-07 | US | Los Angeles, CA | 14 | 0 | 0 | 34.0522 | -118.2437 | 2020-03-07T23:53:03 | ||||
2020-03-07 | US | New York County, NY | 11 | 0 | 0 | 40.7128 | -74.006 | 2020-03-07T18:23:05 | ||||
2020-03-07 | US | San Francisco County, CA | 9 | 0 | 0 | 37.7749 | -122.4194 | 2020-03-07T23:53:03 | ||||
2020-03-07 | US | Cook County, IL | 6 | 0 | 2 | 41.7377 | -87.6976 | 2020-03-07T01:53:03 | ||||
2020-03-07 | US | Harris County, TX | 5 | 0 | 0 | 29.7752 | -95.3103 | 2020-03-07T05:13:03 | ||||
2020-03-07 | US | Placer County, CA | 5 | 1 | 0 | 39.0916 | -120.8039 | 2020-03-06T23:13:07 | ||||
2020-03-07 | US | Unassigned Location, WA | 5 | 0 | 0 | 47.7511 | -120.7401 | 2020-03-06T00:33:03 | ||||
2020-03-07 | US | Bergen County, NJ | 4 | 0 | 0 | 40.9263 | -74.077 | 2020-03-07T02:53:02 | ||||
2020-03-07 | US | Nassau County, NY | 4 | 0 | 0 | 40.6546 | -73.5594 | 2020-03-07T00:03:28 | ||||
2020-03-07 | US | Contra Costa County, CA | 3 | 0 | 0 | 37.8534 | -121.9018 | 2020-03-06T19:43:02 | ||||
2020-03-07 | US | Douglas County, CO | 3 | 0 | 0 | 39.2587 | -104.9389 | 2020-03-07T01:53:03 | ||||
2020-03-07 | US | Fort Bend County, TX | 3 | 0 | 0 | 29.5693 | -95.8143 | 2020-03-07T02:03:30 | ||||
2020-03-07 | US | Fulton County, GA | 3 | 0 | 0 | 33.8034 | -84.3963 | 2020-03-07T16:53:03 | ||||
2020-03-07 | US | Maricopa County, AZ | 3 | 0 | 1 | 33.2918 | -112.4291 | 2020-03-07T19:53:02 | ||||
2020-03-07 | US | Montgomery County, MD | 3 | 0 | 0 | 39.1547 | -77.2405 | 2020-03-06T04:03:17 | ||||
2020-03-07 | US | Orange County, CA | 3 | 0 | 0 | 33.7879 | -117.8531 | 2020-03-04T02:13:11 | ||||
2020-03-07 | US | Providence County, RI | 3 | 0 | 0 | 41.8882 | -71.4774 | 2020-03-07T02:23:08 | ||||
2020-03-07 | US | San Diego County, CA | 3 | 0 | 1 | 32.7157 | -117.1611 | 2020-03-05T20:33:03 | ||||
2020-03-07 | US | Suffolk County, MA | 3 | 0 | 1 | 42.3601 | -71.0589 | 2020-03-06T18:33:03 | ||||
2020-03-07 | US | Washington County, OR | 3 | 0 | 0 | 45.547 | -123.1386 | 2020-03-07T20:13:14 | ||||
2020-03-07 | US | Norfolk County, MA | 2 | 0 | 0 | 42.1767 | -71.1449 | 2020-03-06T18:33:03 | ||||
2020-03-07 | US | Alameda County, CA | 2 | 0 | 0 | 37.6017 | -121.7195 | 2020-03-07T13:13:14 | ||||
2020-03-07 | US | Broward County, FL | 2 | 0 | 0 | 26.1901 | -80.3659 | 2020-03-07T04:43:02 | ||||
2020-03-07 | US | Denver County, CO | 2 | 0 | 0 | 39.7392 | -104.9903 | 2020-03-06T23:33:02 | ||||
2020-03-07 | US | Fairfield County, CT | 2 | 0 | 0 | 41.256 | -73.3709 | 2020-03-07T20:13:14 | ||||
2020-03-07 | US | Floyd County, GA | 2 | 0 | 0 | 34.2829 | -85.2308 | 2020-03-07T16:53:03 | ||||
2020-03-07 | US | Grafton County, NH | 2 | 0 | 0 | 43.9088 | -71.826 | 2020-03-03T23:33:03 | ||||
2020-03-07 | US | Hillsborough, FL | 2 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-03T18:33:02 | ||||
2020-03-07 | US | Lee County, FL | 2 | 0 | 0 | 26.663 | -81.9535 | 2020-03-07T16:43:02 | ||||
2020-03-07 | US | Pinal County, AZ | 2 | 0 | 0 | 32.8162 | -111.2845 | 2020-03-07T17:13:23 | ||||
2020-03-07 | US | Rockland County, NY | 2 | 0 | 0 | 41.1489 | -73.983 | 2020-03-07T16:43:02 | ||||
2020-03-07 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
2020-03-07 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
2020-03-07 | US | San Mateo, CA | 2 | 0 | 0 | 37.563 | -122.3255 | 2020-03-03T00:43:02 | ||||
2020-03-07 | US | Saratoga County, NY | 2 | 0 | 0 | 43.0324 | -73.936 | 2020-03-07T18:23:05 | ||||
2020-03-07 | US | Summit County, CO | 2 | 0 | 0 | 39.5912 | -106.064 | 2020-03-06T01:29:39 | ||||
2020-03-07 | US | Charleston County, SC | 1 | 0 | 0 | 32.7957 | -79.7848 | 2020-03-07T01:53:03 | ||||
2020-03-07 | US | Chatham County, NC | 1 | 0 | 0 | 35.7211 | -79.1781 | 2020-03-06T16:13:15 | ||||
2020-03-07 | US | Clark County, NV | 1 | 0 | 0 | 36.0796 | -115.094 | 2020-03-05T20:53:03 | ||||
2020-03-07 | US | Clark County, WA | 1 | 0 | 0 | 45.7466 | -122.5194 | 2020-03-07T20:03:07 | ||||
2020-03-07 | US | Cobb County, GA | 1 | 0 | 0 | 33.8999 | -84.5641 | 2020-03-07T16:53:03 | ||||
2020-03-07 | US | Davis County, UT | 1 | 0 | 0 | 40.9629 | -112.0953 | 2020-03-07T04:43:02 | ||||
2020-03-07 | US | Delaware County, PA | 1 | 0 | 0 | 39.9078 | -75.3879 | 2020-03-06T15:33:03 | ||||
2020-03-07 | US | Douglas County, NE | 1 | 0 | 0 | 41.3148 | -96.1951 | 2020-03-06T23:33:02 | ||||
2020-03-07 | US | El Paso County, CO | 1 | 0 | 0 | 38.9108 | -104.4723 | 2020-03-07T01:13:21 | ||||
2020-03-07 | US | Fayette County, KY | 1 | 0 | 0 | 38.0606 | -84.4803 | 2020-03-06T23:23:03 | ||||
2020-03-07 | US | Grant County, WA | 1 | 0 | 0 | 47.1981 | -119.3732 | 2020-03-05T20:23:07 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;