daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,284,537 rows where country_or_region = "US" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state, day
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 | 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 | ||||
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-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 | ||||
2020-03-07 | US | Honolulu County, HI | 1 | 0 | 0 | 21.307 | -157.8584 | 2020-03-07T02:03:30 | ||||
2020-03-07 | US | Humboldt County, CA | 1 | 0 | 0 | 40.745 | -123.8695 | 2020-02-21T05:13:09 | ||||
2020-03-07 | US | Jackson County, OR | 1 | 0 | 0 | 42.3345 | -122.7647 | 2020-03-07T20:03:06 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;