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 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 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
774 | 774 | 2021-12-02 | US | American Samoa | 60 | 10 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-12-03 04:23:05 | American Samoa, US | ||
1007 | 1007 | 2021-12-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1238 | 1238 | 2021-12-02 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
1239 | 1239 | 2021-12-02 | US | Guam | 66 | 19227 | 266 | 0 | 13.4443 | 144.7937 | 2021-12-03 04:23:05 | Guam, US | ||
2769 | 2769 | 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 | ||
3123 | 3123 | 2021-12-02 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-12-03 04:23:05 | Recovered, US | |||
3625 | 3625 | 2021-12-02 | US | Virgin Islands | 78 | 7525 | 87 | 0 | 18.3358 | -64.8963 | 2021-12-03 04:23:05 | Virgin Islands, US | ||
4789 | 4789 | 2021-10-28 | US | American Samoa | 60 | 4 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-10-29 04:22:03 | American Samoa, US | ||
5022 | 5022 | 2021-10-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
5253 | 5253 | 2021-10-28 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
5254 | 5254 | 2021-10-28 | US | Guam | 66 | 18040 | 235 | 0 | 13.4443 | 144.7937 | 2021-10-29 04:22:03 | Guam, US | ||
6784 | 6784 | 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 | ||
7138 | 7138 | 2021-10-28 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-10-29 04:22:03 | Recovered, US | |||
7640 | 7640 | 2021-10-28 | US | Virgin Islands | 78 | 7186 | 81 | 0 | 18.3358 | -64.8963 | 2021-10-29 04:22:03 | Virgin Islands, US | ||
8995 | 8995 | 2020-10-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
9226 | 9226 | 2020-10-25 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
9227 | 9227 | 2020-10-25 | US | Guam | 66 | 4216 | 71 | 0 | 4145 | 13.4443 | 144.7937 | 2020-10-26 04:25:02 | Guam, US | |
10756 | 10756 | 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 | |
11110 | 11110 | 2020-10-25 | US | Recovered | 0 | 0 | 3422878 | 0 | 0.0 | 0.0 | 2020-10-26 04:25:02 | Recovered, US | ||
11612 | 11612 | 2020-10-25 | US | Virgin Islands | 78 | 1346 | 21 | 0 | 1325 | 18.3358 | -64.8963 | 2020-10-26 04:25:02 | Virgin Islands, US | |
13007 | 13007 | 2021-01-26 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
13238 | 13238 | 2021-01-26 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | |
13239 | 13239 | 2021-01-26 | US | Guam | 66 | 7566 | 129 | 0 | 7437 | 13.4443 | 144.7937 | 2021-01-27 05:23:41 | Guam, US | |
14769 | 14769 | 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 | |
15123 | 15123 | 2021-01-26 | US | Recovered | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2021-01-27 05:23:41 | Recovered, US | ||
15625 | 15625 | 2021-01-26 | US | Virgin Islands | 78 | 2373 | 24 | 0 | 2349 | 18.3358 | -64.8963 | 2021-01-27 05:23:41 | Virgin Islands, US | |
17029 | 17029 | 2021-09-18 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
17260 | 17260 | 2021-09-18 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
17261 | 17261 | 2021-09-18 | US | Guam | 66 | 13438 | 179 | 0 | 13.4443 | 144.7937 | 2021-09-19 04:21:34 | Guam, US | ||
18791 | 18791 | 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 | ||
19145 | 19145 | 2021-09-18 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-09-19 04:21:34 | Recovered, US | |||
19647 | 19647 | 2021-09-18 | US | Virgin Islands | 78 | 6458 | 67 | 0 | 18.3358 | -64.8963 | 2021-09-19 04:21:34 | Virgin Islands, US | ||
21040 | 21040 | 2021-05-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
21271 | 21271 | 2021-05-28 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
21272 | 21272 | 2021-05-28 | US | Guam | 66 | 8156 | 139 | 0 | 13.4443 | 144.7937 | 2021-05-29 04:20:41 | Guam, US | ||
22802 | 22802 | 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 | ||
23156 | 23156 | 2021-05-28 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-05-29 04:20:41 | Recovered, US | |||
23658 | 23658 | 2021-05-28 | US | Virgin Islands | 78 | 3442 | 27 | 0 | 18.3358 | -64.8963 | 2021-05-29 04:20:41 | Virgin Islands, US | ||
24845 | 24845 | 2022-03-20 | US | American Samoa | 60 | 1066 | 0 | 0 | -14.270999999999999 | -170.132 | 2022-03-21 04:20:50 | American Samoa, US | ||
25078 | 25078 | 2022-03-20 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
25309 | 25309 | 2022-03-20 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
25310 | 25310 | 2022-03-20 | US | Guam | 66 | 46730 | 341 | 0 | 13.4443 | 144.7937 | 2022-03-21 04:20:50 | Guam, US | ||
26840 | 26840 | 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 | ||
27194 | 27194 | 2022-03-20 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2022-03-21 04:20:50 | Recovered, US | |||
27696 | 27696 | 2022-03-20 | US | Virgin Islands | 78 | 15578 | 110 | 0 | 18.3358 | -64.8963 | 2022-03-21 04:20:50 | Virgin Islands, US | ||
28860 | 28860 | 2021-11-11 | US | American Samoa | 60 | 4 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-11-12 04:22:01 | American Samoa, US | ||
29093 | 29093 | 2021-11-11 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
29324 | 29324 | 2021-11-11 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
29325 | 29325 | 2021-11-11 | US | Guam | 66 | 18840 | 258 | 0 | 13.4443 | 144.7937 | 2021-11-12 04:22:01 | Guam, US | ||
30855 | 30855 | 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 | ||
31209 | 31209 | 2021-11-11 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-11-12 04:22:01 | Recovered, US | |||
31711 | 31711 | 2021-11-11 | US | Virgin Islands | 78 | 7329 | 84 | 0 | 18.3358 | -64.8963 | 2021-11-12 04:22:01 | Virgin Islands, US | ||
33089 | 33089 | 2021-08-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
33320 | 33320 | 2021-08-25 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
33321 | 33321 | 2021-08-25 | US | Guam | 66 | 9759 | 145 | 0 | 13.4443 | 144.7937 | 2021-08-26 04:21:28 | Guam, US | ||
34851 | 34851 | 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 | ||
35205 | 35205 | 2021-08-25 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-08-26 04:21:28 | Recovered, US | |||
35707 | 35707 | 2021-08-25 | US | Virgin Islands | 78 | 5707 | 51 | 0 | 18.3358 | -64.8963 | 2021-08-26 04:21:28 | Virgin Islands, US | ||
37099 | 37099 | 2021-04-12 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
37330 | 37330 | 2021-04-12 | US | Grand Princess | 99999 | 103 | 3 | 0 | 37.64894 | 0.0 | 2020-08-04 02:27:56 | Grand Princess, US | ||
37331 | 37331 | 2021-04-12 | US | Guam | 66 | 7842 | 136 | 0 | 13.4443 | 144.7937 | 2021-04-13 04:20:37 | Guam, US | ||
38861 | 38861 | 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 | ||
39215 | 39215 | 2021-04-12 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-04-13 04:20:37 | Recovered, US | |||
39717 | 39717 | 2021-04-12 | US | Virgin Islands | 78 | 3005 | 26 | 0 | 18.3358 | -64.8963 | 2021-04-13 04:20:37 | Virgin Islands, US | ||
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 |
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]);