johns_hopkins_csse_daily_reports
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 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40177 | 40177 | 2020-03-05 | US | King County, WA | 51 | 10 | 1 | 47.548 | -121.9836 | 2020-03-05T22:03:17 | ||||
40180 | 40180 | 2020-03-05 | US | Unassigned Location (From Diamond Princess) | 45 | 0 | 0 | 35.4437 | 139.638 | 2020-03-02T19:53:03 | ||||
40191 | 40191 | 2020-03-05 | US | Santa Clara, CA | 20 | 0 | 1 | 37.3541 | -121.9552 | 2020-03-05T22:53:03 | ||||
40193 | 40193 | 2020-03-05 | US | Snohomish County, WA | 18 | 1 | 0 | 48.033 | -121.8339 | 2020-03-05T20:23:07 | ||||
40194 | 40194 | 2020-03-05 | US | Westchester County, NY | 18 | 0 | 0 | 41.122 | -73.7949 | 2020-03-05T21:33:03 | ||||
40205 | 40205 | 2020-03-05 | US | Los Angeles, CA | 11 | 0 | 0 | 34.0522 | -118.2437 | 2020-03-05T21:03:14 | ||||
40220 | 40220 | 2020-03-05 | US | Cook County, IL | 5 | 0 | 2 | 41.7377 | -87.6976 | 2020-03-05T18:33:03 | ||||
40227 | 40227 | 2020-03-05 | US | New York City, NY | 4 | 0 | 0 | 40.7128 | -74.006 | 2020-03-05T21:03:13 | ||||
40234 | 40234 | 2020-03-05 | US | Orange County, CA | 3 | 0 | 0 | 33.7879 | -117.8531 | 2020-03-04T02:13:11 | ||||
40235 | 40235 | 2020-03-05 | US | San Diego County, CA | 3 | 0 | 1 | 32.7157 | -117.1611 | 2020-03-05T20:33:03 | ||||
40242 | 40242 | 2020-03-05 | US | Bergen County, NJ | 2 | 0 | 0 | 40.9263 | -74.077 | 2020-03-05T21:03:12 | ||||
40243 | 40243 | 2020-03-05 | US | Fulton County, GA | 2 | 0 | 0 | 33.8034 | -84.3963 | 2020-03-03T03:33:02 | ||||
40244 | 40244 | 2020-03-05 | US | Grafton County, NH | 2 | 0 | 0 | 43.9088 | -71.826 | 2020-03-03T23:33:03 | ||||
40245 | 40245 | 2020-03-05 | US | Harris County, TX | 2 | 0 | 0 | 29.7752 | -95.3103 | 2020-03-05T21:53:02 | ||||
40246 | 40246 | 2020-03-05 | US | Hillsborough, FL | 2 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-03T18:33:02 | ||||
40247 | 40247 | 2020-03-05 | US | Placer County, CA | 2 | 1 | 0 | 39.0916 | -120.8039 | 2020-03-04T19:53:02 | ||||
40248 | 40248 | 2020-03-05 | US | Providence, RI | 2 | 0 | 0 | 41.824 | -71.4128 | 2020-03-02T03:43:02 | ||||
40249 | 40249 | 2020-03-05 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
40250 | 40250 | 2020-03-05 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
40251 | 40251 | 2020-03-05 | US | San Francisco County, CA | 2 | 0 | 0 | 37.7749 | -122.4194 | 2020-03-05T20:33:03 | ||||
40252 | 40252 | 2020-03-05 | US | San Mateo, CA | 2 | 0 | 0 | 37.563 | -122.3255 | 2020-03-03T00:43:02 | ||||
40253 | 40253 | 2020-03-05 | US | Washington County, OR | 2 | 0 | 0 | 45.547 | -123.1386 | 2020-03-03T03:03:02 | ||||
40279 | 40279 | 2020-03-05 | US | Norfolk County, MA | 1 | 0 | 0 | 42.1767 | -71.1449 | 2020-03-03T14:33:03 | ||||
40280 | 40280 | 2020-03-05 | US | Berkeley, CA | 1 | 0 | 0 | 37.8715 | -122.273 | 2020-03-03T23:53:03 | ||||
40281 | 40281 | 2020-03-05 | US | Boston, MA | 1 | 0 | 1 | 42.3601 | -71.0589 | 2020-02-28T21:13:12 | ||||
40282 | 40282 | 2020-03-05 | US | Clark County, NV | 1 | 0 | 0 | 36.0796 | -115.094 | 2020-03-05T20:53:03 | ||||
40283 | 40283 | 2020-03-05 | US | Contra Costa County, CA | 1 | 0 | 0 | 37.8534 | -121.9018 | 2020-03-04T04:23:05 | ||||
40284 | 40284 | 2020-03-05 | US | Fort Bend County, TX | 1 | 0 | 0 | 29.5693 | -95.8143 | 2020-03-05T01:16:59 | ||||
40285 | 40285 | 2020-03-05 | US | Grant County, WA | 1 | 0 | 0 | 47.1981 | -119.3732 | 2020-03-05T20:23:07 | ||||
40286 | 40286 | 2020-03-05 | US | Humboldt County, CA | 1 | 0 | 0 | 40.745 | -123.8695 | 2020-02-21T05:13:09 | ||||
40287 | 40287 | 2020-03-05 | US | Madison, WI | 1 | 0 | 1 | 43.0731 | -89.4012 | 2020-03-03T15:53:03 | ||||
40288 | 40288 | 2020-03-05 | US | Maricopa County, AZ | 1 | 0 | 0 | 33.2918 | -112.4291 | 2020-03-03T17:33:02 | ||||
40289 | 40289 | 2020-03-05 | US | Queens County, NY | 1 | 0 | 0 | 40.7282 | -73.7949 | 2020-03-05T21:43:02 | ||||
40290 | 40290 | 2020-03-05 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
40291 | 40291 | 2020-03-05 | US | Santa Rosa County, FL | 1 | 0 | 0 | 30.769 | -86.9824 | 2020-03-05T20:03:03 | ||||
40292 | 40292 | 2020-03-05 | US | Sarasota, FL | 1 | 0 | 0 | 27.3364 | -82.5307 | 2020-03-02T03:23:06 | ||||
40293 | 40293 | 2020-03-05 | US | Sonoma County, CA | 1 | 0 | 0 | 38.578 | -122.9888 | 2020-03-02T20:53:02 | ||||
40294 | 40294 | 2020-03-05 | US | Tempe, AZ | 1 | 0 | 1 | 33.4255 | -111.94 | 2020-02-25T21:23:03 | ||||
40295 | 40295 | 2020-03-05 | US | Umatilla, OR | 1 | 0 | 0 | 45.775 | -118.7606 | 2020-03-02T20:23:16 | ||||
40296 | 40296 | 2020-03-05 | US | Wake County, NC | 1 | 0 | 0 | 35.8032 | -78.5661 | 2020-03-03T20:53:02 | ||||
40297 | 40297 | 2020-03-05 | US | Williamson County, TN | 1 | 0 | 0 | 35.9179 | -86.8622 | 2020-03-05T23:33:03 | ||||
40300 | 40300 | 2020-03-05 | US | Lackland, TX (From Diamond Princess) | 0 | 0 | 0 | 29.3829 | -98.6134 | 2020-02-24T23:33:02 | ||||
40301 | 40301 | 2020-03-05 | US | Omaha, NE (From Diamond Princess) | 0 | 0 | 0 | 41.2545 | -95.9758 | 2020-02-24T23:33:02 | ||||
40302 | 40302 | 2020-03-05 | US | Travis, CA (From Diamond Princess) | 0 | 0 | 0 | 38.2721 | -121.9399 | 2020-02-24T23:33:02 | ||||
62518 | 62518 | 2020-03-07 | US | King County, WA | 71 | 15 | 1 | 47.548 | -121.9836 | 2020-03-07T20:23:03 | ||||
62520 | 62520 | 2020-03-07 | US | Westchester County, NY | 57 | 0 | 0 | 41.122 | -73.7949 | 2020-03-07T18:23:05 | ||||
62526 | 62526 | 2020-03-07 | US | Unassigned Location (From Diamond Princess) | 45 | 0 | 0 | 35.4437 | 139.638 | 2020-03-02T19:53:03 | ||||
62529 | 62529 | 2020-03-07 | US | Santa Clara County, CA | 32 | 0 | 1 | 37.3541 | -121.9552 | 2020-03-07T23:43:03 | ||||
62532 | 62532 | 2020-03-07 | US | Snohomish County, WA | 27 | 1 | 0 | 48.033 | -121.8339 | 2020-03-07T20:23:03 | ||||
62539 | 62539 | 2020-03-07 | US | Grand Princess Cruise Ship | 21 | 0 | 0 | 37.6489 | -122.6655 | 2020-03-07T01:33:02 | ||||
62549 | 62549 | 2020-03-07 | US | Los Angeles, CA | 14 | 0 | 0 | 34.0522 | -118.2437 | 2020-03-07T23:53:03 | ||||
62556 | 62556 | 2020-03-07 | US | New York County, NY | 11 | 0 | 0 | 40.7128 | -74.006 | 2020-03-07T18:23:05 | ||||
62561 | 62561 | 2020-03-07 | US | San Francisco County, CA | 9 | 0 | 0 | 37.7749 | -122.4194 | 2020-03-07T23:53:03 | ||||
62570 | 62570 | 2020-03-07 | US | Cook County, IL | 6 | 0 | 2 | 41.7377 | -87.6976 | 2020-03-07T01:53:03 | ||||
62575 | 62575 | 2020-03-07 | US | Harris County, TX | 5 | 0 | 0 | 29.7752 | -95.3103 | 2020-03-07T05:13:03 | ||||
62576 | 62576 | 2020-03-07 | US | Placer County, CA | 5 | 1 | 0 | 39.0916 | -120.8039 | 2020-03-06T23:13:07 | ||||
62577 | 62577 | 2020-03-07 | US | Unassigned Location, WA | 5 | 0 | 0 | 47.7511 | -120.7401 | 2020-03-06T00:33:03 | ||||
62583 | 62583 | 2020-03-07 | US | Bergen County, NJ | 4 | 0 | 0 | 40.9263 | -74.077 | 2020-03-07T02:53:02 | ||||
62584 | 62584 | 2020-03-07 | US | Nassau County, NY | 4 | 0 | 0 | 40.6546 | -73.5594 | 2020-03-07T00:03:28 | ||||
62591 | 62591 | 2020-03-07 | US | Contra Costa County, CA | 3 | 0 | 0 | 37.8534 | -121.9018 | 2020-03-06T19:43:02 | ||||
62592 | 62592 | 2020-03-07 | US | Douglas County, CO | 3 | 0 | 0 | 39.2587 | -104.9389 | 2020-03-07T01:53:03 | ||||
62593 | 62593 | 2020-03-07 | US | Fort Bend County, TX | 3 | 0 | 0 | 29.5693 | -95.8143 | 2020-03-07T02:03:30 | ||||
62594 | 62594 | 2020-03-07 | US | Fulton County, GA | 3 | 0 | 0 | 33.8034 | -84.3963 | 2020-03-07T16:53:03 | ||||
62595 | 62595 | 2020-03-07 | US | Maricopa County, AZ | 3 | 0 | 1 | 33.2918 | -112.4291 | 2020-03-07T19:53:02 | ||||
62596 | 62596 | 2020-03-07 | US | Montgomery County, MD | 3 | 0 | 0 | 39.1547 | -77.2405 | 2020-03-06T04:03:17 | ||||
62597 | 62597 | 2020-03-07 | US | Orange County, CA | 3 | 0 | 0 | 33.7879 | -117.8531 | 2020-03-04T02:13:11 | ||||
62598 | 62598 | 2020-03-07 | US | Providence County, RI | 3 | 0 | 0 | 41.8882 | -71.4774 | 2020-03-07T02:23:08 | ||||
62599 | 62599 | 2020-03-07 | US | San Diego County, CA | 3 | 0 | 1 | 32.7157 | -117.1611 | 2020-03-05T20:33:03 | ||||
62600 | 62600 | 2020-03-07 | US | Suffolk County, MA | 3 | 0 | 1 | 42.3601 | -71.0589 | 2020-03-06T18:33:03 | ||||
62601 | 62601 | 2020-03-07 | US | Washington County, OR | 3 | 0 | 0 | 45.547 | -123.1386 | 2020-03-07T20:13:14 | ||||
62606 | 62606 | 2020-03-07 | US | Norfolk County, MA | 2 | 0 | 0 | 42.1767 | -71.1449 | 2020-03-06T18:33:03 | ||||
62607 | 62607 | 2020-03-07 | US | Alameda County, CA | 2 | 0 | 0 | 37.6017 | -121.7195 | 2020-03-07T13:13:14 | ||||
62608 | 62608 | 2020-03-07 | US | Broward County, FL | 2 | 0 | 0 | 26.1901 | -80.3659 | 2020-03-07T04:43:02 | ||||
62609 | 62609 | 2020-03-07 | US | Denver County, CO | 2 | 0 | 0 | 39.7392 | -104.9903 | 2020-03-06T23:33:02 | ||||
62610 | 62610 | 2020-03-07 | US | Fairfield County, CT | 2 | 0 | 0 | 41.256 | -73.3709 | 2020-03-07T20:13:14 | ||||
62611 | 62611 | 2020-03-07 | US | Floyd County, GA | 2 | 0 | 0 | 34.2829 | -85.2308 | 2020-03-07T16:53:03 | ||||
62612 | 62612 | 2020-03-07 | US | Grafton County, NH | 2 | 0 | 0 | 43.9088 | -71.826 | 2020-03-03T23:33:03 | ||||
62613 | 62613 | 2020-03-07 | US | Hillsborough, FL | 2 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-03T18:33:02 | ||||
62614 | 62614 | 2020-03-07 | US | Lee County, FL | 2 | 0 | 0 | 26.663 | -81.9535 | 2020-03-07T16:43:02 | ||||
62615 | 62615 | 2020-03-07 | US | Pinal County, AZ | 2 | 0 | 0 | 32.8162 | -111.2845 | 2020-03-07T17:13:23 | ||||
62616 | 62616 | 2020-03-07 | US | Rockland County, NY | 2 | 0 | 0 | 41.1489 | -73.983 | 2020-03-07T16:43:02 | ||||
62617 | 62617 | 2020-03-07 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
62618 | 62618 | 2020-03-07 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
62619 | 62619 | 2020-03-07 | US | San Mateo, CA | 2 | 0 | 0 | 37.563 | -122.3255 | 2020-03-03T00:43:02 | ||||
62620 | 62620 | 2020-03-07 | US | Saratoga County, NY | 2 | 0 | 0 | 43.0324 | -73.936 | 2020-03-07T18:23:05 | ||||
62621 | 62621 | 2020-03-07 | US | Summit County, CO | 2 | 0 | 0 | 39.5912 | -106.064 | 2020-03-06T01:29:39 | ||||
62651 | 62651 | 2020-03-07 | US | Charleston County, SC | 1 | 0 | 0 | 32.7957 | -79.7848 | 2020-03-07T01:53:03 | ||||
62652 | 62652 | 2020-03-07 | US | Chatham County, NC | 1 | 0 | 0 | 35.7211 | -79.1781 | 2020-03-06T16:13:15 | ||||
62653 | 62653 | 2020-03-07 | US | Clark County, NV | 1 | 0 | 0 | 36.0796 | -115.094 | 2020-03-05T20:53:03 | ||||
62654 | 62654 | 2020-03-07 | US | Clark County, WA | 1 | 0 | 0 | 45.7466 | -122.5194 | 2020-03-07T20:03:07 | ||||
62655 | 62655 | 2020-03-07 | US | Cobb County, GA | 1 | 0 | 0 | 33.8999 | -84.5641 | 2020-03-07T16:53:03 | ||||
62656 | 62656 | 2020-03-07 | US | Davis County, UT | 1 | 0 | 0 | 40.9629 | -112.0953 | 2020-03-07T04:43:02 | ||||
62657 | 62657 | 2020-03-07 | US | Delaware County, PA | 1 | 0 | 0 | 39.9078 | -75.3879 | 2020-03-06T15:33:03 | ||||
62658 | 62658 | 2020-03-07 | US | Douglas County, NE | 1 | 0 | 0 | 41.3148 | -96.1951 | 2020-03-06T23:33:02 | ||||
62659 | 62659 | 2020-03-07 | US | El Paso County, CO | 1 | 0 | 0 | 38.9108 | -104.4723 | 2020-03-07T01:13:21 | ||||
62660 | 62660 | 2020-03-07 | US | Fayette County, KY | 1 | 0 | 0 | 38.0606 | -84.4803 | 2020-03-06T23:23:03 | ||||
62661 | 62661 | 2020-03-07 | US | Grant County, WA | 1 | 0 | 0 | 47.1981 | -119.3732 | 2020-03-05T20:23:07 | ||||
62662 | 62662 | 2020-03-07 | US | Honolulu County, HI | 1 | 0 | 0 | 21.307 | -157.8584 | 2020-03-07T02:03:30 | ||||
62663 | 62663 | 2020-03-07 | US | Humboldt County, CA | 1 | 0 | 0 | 40.745 | -123.8695 | 2020-02-21T05:13:09 | ||||
62664 | 62664 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);