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-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 | ||||
2020-03-07 | US | Jefferson County, WA | 1 | 0 | 0 | 47.7425 | -123.304 | 2020-03-07T16:43:02 | ||||
2020-03-07 | US | Kershaw County, SC | 1 | 0 | 0 | 34.3672 | -80.5883 | 2020-03-07T02:03:30 | ||||
2020-03-07 | US | Klamath County, OR | 1 | 0 | 0 | 42.6953 | -121.6142 | 2020-03-07T20:13:14 | ||||
2020-03-07 | US | Madera County, CA | 1 | 0 | 0 | 37.2519 | -119.6963 | 2020-03-07T20:13:14 | ||||
2020-03-07 | US | Madison, WI | 1 | 0 | 1 | 43.0731 | -89.4012 | 2020-03-03T15:53:03 | ||||
2020-03-07 | US | Marion County, IN | 1 | 0 | 0 | 39.8362 | -86.1752 | 2020-03-06T17:13:12 | ||||
2020-03-07 | US | Middlesex County, MA | 1 | 0 | 0 | 41.912 | -70.7168 | 2020-03-07T03:53:03 | ||||
2020-03-07 | US | Pierce County, WA | 1 | 0 | 0 | 47.0676 | -122.1295 | 2020-03-07T03:13:44 | ||||
2020-03-07 | US | Plymouth County, MA | 1 | 0 | 0 | 42.1615 | -70.7928 | 2020-03-07T03:53:03 | ||||
2020-03-07 | US | Ramsey County, MN | 1 | 0 | 0 | 44.9964 | -93.0616 | 2020-03-06T23:23:03 | ||||
2020-03-07 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
2020-03-07 | US | Santa Cruz County, CA | 1 | 0 | 0 | 36.9741 | -122.0308 | 2020-03-07T23:43:03 | ||||
2020-03-07 | US | Santa Rosa County, FL | 1 | 0 | 0 | 30.769 | -86.9824 | 2020-03-05T20:03:03 | ||||
2020-03-07 | US | Sarasota, FL | 1 | 0 | 0 | 27.3364 | -82.5307 | 2020-03-02T03:23:06 | ||||
2020-03-07 | US | Sonoma County, CA | 1 | 0 | 0 | 38.578 | -122.9888 | 2020-03-02T20:53:02 | ||||
2020-03-07 | US | Tulsa County, OK | 1 | 0 | 0 | 36.1593 | -95.941 | 2020-03-07T04:43:02 | ||||
2020-03-07 | US | Umatilla, OR | 1 | 0 | 0 | 45.775 | -118.7606 | 2020-03-02T20:23:16 | ||||
2020-03-07 | US | Wake County, NC | 1 | 0 | 0 | 35.8032 | -78.5661 | 2020-03-03T20:53:02 | ||||
2020-03-07 | US | Washoe County, NV | 1 | 0 | 0 | 40.5608 | -119.6035 | 2020-03-06T19:43:02 | ||||
2020-03-07 | US | Wayne County, PA | 1 | 0 | 0 | 41.6739 | -75.2479 | 2020-03-06T16:13:15 | ||||
2020-03-07 | US | Williamson County, TN | 1 | 0 | 0 | 35.9179 | -86.8622 | 2020-03-05T23:33:03 | ||||
2020-03-07 | US | Yolo County, CA | 1 | 0 | 0 | 38.7646 | -121.9018 | 2020-03-06T20:13:14 | ||||
2020-03-07 | US | Lackland, TX (From Diamond Princess) | 0 | 0 | 0 | 29.3829 | -98.6134 | 2020-02-24T23:33:02 | ||||
2020-03-07 | US | Montgomery County, TX | 0 | 0 | 0 | 30.3213 | -95.4778 | 2020-03-07T19:53:02 | ||||
2020-03-07 | US | Omaha, NE (From Diamond Princess) | 0 | 0 | 0 | 41.2545 | -95.9758 | 2020-02-24T23:33:02 | ||||
2020-03-07 | US | Travis, CA (From Diamond Princess) | 0 | 0 | 0 | 38.2721 | -121.9399 | 2020-02-24T23:33:02 | ||||
2022-11-12 | US | American Samoa | 60 | 8260 | 34 | 0 | -14.271 | -170.132 | 2022-11-13 04:21:14 | American Samoa, US | ||
2022-11-12 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2022-11-12 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2022-11-12 | US | Guam | 66 | 58990 | 406 | 0 | 13.4443 | 144.7937 | 2022-11-13 04:21:14 | Guam, US | ||
2022-11-12 | US | Northern Mariana Islands | 69 | 13219 | 41 | 0 | 15.0979 | 145.6739 | 2022-11-13 04:21:14 | Northern Mariana Islands, US | ||
2022-11-12 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2022-11-13 04:21:14 | Recovered, US | |||
2022-11-12 | US | Virgin Islands | 78 | 23445 | 124 | 0 | 18.3358 | -64.8963 | 2022-11-13 04:21:14 | Virgin Islands, US | ||
2021-09-01 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-09-01 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-09-01 | US | Guam | 66 | 10740 | 150 | 0 | 13.4443 | 144.7937 | 2021-09-02 04:21:15 | Guam, US | ||
2021-09-01 | US | Northern Mariana Islands | 69 | 243 | 2 | 0 | 15.0979 | 145.6739 | 2021-09-02 04:21:15 | Northern Mariana Islands, US | ||
2021-09-01 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-09-02 04:21:15 | Recovered, US | |||
2021-09-01 | US | Virgin Islands | 78 | 5934 | 56 | 0 | 18.3358 | -64.8963 | 2021-09-02 04:21:15 | Virgin Islands, US | ||
2022-02-07 | US | American Samoa | 60 | 49 | 0 | 0 | -14.270999999999999 | -170.132 | 2022-02-08 04:21:15 | American Samoa, US | ||
2022-02-07 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2022-02-07 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2022-02-07 | US | Guam | 66 | 36612 | 298 | 0 | 13.4443 | 144.7937 | 2022-02-08 04:21:15 | Guam, US | ||
2022-02-07 | US | Northern Mariana Islands | 69 | 6332 | 23 | 0 | 15.0979 | 145.6739 | 2022-02-08 04:21:15 | Northern Mariana Islands, US | ||
2022-02-07 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2022-02-08 04:21:15 | Recovered, US | |||
2022-02-07 | US | Virgin Islands | 78 | 15045 | 102 | 0 | 18.3358 | -64.8963 | 2022-02-08 04:21:15 | Virgin Islands, US | ||
2020-12-03 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2020-12-03 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
2020-12-03 | US | Guam | 66 | 6942 | 112 | 0 | 6830 | 13.4443 | 144.7937 | 2020-12-04 05:27:27 | Guam, US | |
2020-12-03 | US | Northern Mariana Islands | 69 | 106 | 2 | 0 | 104 | 15.0979 | 145.6739 | 2020-12-04 05:27:27 | Northern Mariana Islands, US | |
2020-12-03 | US | Recovered | 0 | 0 | 5404018 | 0 | 0.0 | 0.0 | 2020-12-04 05:27:27 | Recovered, US | ||
2020-12-03 | US | Virgin Islands | 78 | 1589 | 23 | 0 | 1566 | 18.3358 | -64.8963 | 2020-12-04 05:27:27 | Virgin Islands, US | |
2020-10-14 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2020-10-14 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
2020-10-14 | US | Guam | 66 | 3341 | 61 | 0 | 3280 | 13.4443 | 144.7937 | 2020-10-15 04:24:28 | Guam, US | |
2020-10-14 | US | Northern Mariana Islands | 69 | 77 | 2 | 0 | 75 | 15.0979 | 145.6739 | 2020-10-15 04:24:28 | Northern Mariana Islands, US | |
2020-10-14 | US | Recovered | 0 | 0 | 3155794 | 0 | 0.0 | 0.0 | 2020-10-15 04:24:28 | Recovered, US | ||
2020-10-14 | US | Virgin Islands | 78 | 1328 | 20 | 0 | 1308 | 18.3358 | -64.8963 | 2020-10-15 04:24:28 | Virgin Islands, US | |
2021-05-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-05-25 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-05-25 | US | Guam | 66 | 8141 | 139 | 0 | 13.4443 | 144.7937 | 2021-05-26 04:20:35 | Guam, US | ||
2021-05-25 | US | Northern Mariana Islands | 69 | 181 | 2 | 0 | 15.0979 | 145.6739 | 2021-05-26 04:20:35 | Northern Mariana Islands, US | ||
2021-05-25 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-05-26 04:20:35 | Recovered, US | |||
2021-05-25 | US | Virgin Islands | 78 | 3399 | 27 | 0 | 18.3358 | -64.8963 | 2021-05-26 04:20:35 | Virgin Islands, US | ||
2021-11-09 | US | American Samoa | 60 | 4 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-11-10 04:21:38 | American Samoa, US | ||
2021-11-09 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-11-09 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2021-11-09 | US | Guam | 66 | 18752 | 255 | 0 | 13.4443 | 144.7937 | 2021-11-10 04:21:38 | Guam, US | ||
2021-11-09 | US | Northern Mariana Islands | 69 | 369 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-10 04:21:38 | Northern Mariana Islands, US | ||
2021-11-09 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-11-10 04:21:38 | Recovered, US | |||
2021-11-09 | US | Virgin Islands | 78 | 7303 | 83 | 0 | 18.3358 | -64.8963 | 2021-11-10 04:21:38 | Virgin Islands, US | ||
2022-07-23 | US | American Samoa | 60 | 7471 | 33 | 0 | -14.271 | -170.132 | 2022-07-24 04:20:47 | American Samoa, US | ||
2022-07-23 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2022-07-23 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
2022-07-23 | US | Guam | 66 | 54163 | 377 | 0 | 13.4443 | 144.7937 | 2022-07-24 04:20:47 | Guam, US | ||
2022-07-23 | US | Northern Mariana Islands | 69 | 12398 | 35 | 0 | 15.0979 | 145.6739 | 2022-07-24 04:20:47 | Northern Mariana Islands, US | ||
2022-07-23 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2022-07-24 04:20:47 | Recovered, US | |||
2022-07-23 | US | Virgin Islands | 78 | 21569 | 120 | 0 | 18.3358 | -64.8963 | 2022-07-24 04:20:47 | Virgin Islands, US | ||
2020-08-04 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-05 04:34:43 | Diamond Princess, US | |
2020-08-04 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-05 04:34:43 | Grand Princess, US | |
2020-08-04 | US | Guam | 66 | 389 | 5 | 0 | 384 | 13.4443 | 144.7937 | 2020-08-05 04:34:43 | Guam, US | |
2020-08-04 | US | Northern Mariana Islands | 69 | 46 | 2 | 0 | 44 | 15.0979 | 145.6739 | 2020-08-05 04:34:43 | Northern Mariana Islands, US | |
2020-08-04 | US | Recovered | 0 | 0 | 1528979 | 0 | 0.0 | 0.0 | 2020-08-05 04:34:43 | Recovered, US | ||
2020-08-04 | US | Virgin Islands | 78 | 463 | 8 | 0 | 455 | 18.3358 | -64.8963 | 2020-08-05 04:34:43 | Virgin Islands, US | |
2020-03-04 | US | Unassigned Location (From Diamond Princess) | 45 | 0 | 0 | 35.4437 | 139.638 | 2020-03-02T19:53:03 | ||||
2020-03-04 | US | King County, WA | 31 | 9 | 1 | 47.548 | -121.9836 | 2020-03-04T19:53:02 | ||||
2020-03-04 | US | Santa Clara, CA | 11 | 0 | 1 | 37.3541 | -121.9552 | 2020-03-03T23:33:03 | ||||
2020-03-04 | US | Westchester County, NY | 10 | 0 | 0 | 41.122 | -73.7949 | 2020-03-04T21:23:10 | ||||
2020-03-04 | US | Snohomish County, WA | 8 | 1 | 0 | 48.033 | -121.8339 | 2020-03-04T19:53:02 | ||||
2020-03-04 | US | Los Angeles, CA | 7 | 0 | 0 | 34.0522 | -118.2437 | 2020-03-04T18:13:18 | ||||
2020-03-04 | US | Cook County, IL | 4 | 0 | 2 | 41.7377 | -87.6976 | 2020-03-02T20:33:02 | ||||
2020-03-04 | US | Orange County, CA | 3 | 0 | 0 | 33.7879 | -117.8531 | 2020-03-04T02:13:11 | ||||
2020-03-04 | US | Fulton County, GA | 2 | 0 | 0 | 33.8034 | -84.3963 | 2020-03-03T03:33:02 | ||||
2020-03-04 | US | Grafton County, NH | 2 | 0 | 0 | 43.9088 | -71.826 | 2020-03-03T23:33:03 | ||||
2020-03-04 | US | Hillsborough, FL | 2 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-03T18:33:02 | ||||
2020-03-04 | US | Placer County, CA | 2 | 1 | 0 | 39.0916 | -120.8039 | 2020-03-04T19:53:02 | ||||
2020-03-04 | US | Providence, RI | 2 | 0 | 0 | 41.824 | -71.4128 | 2020-03-02T03:43:02 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;