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 day
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 3,284,437 ✖
Link | rowid | day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3362436 | 3362436 | 2020-02-09 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
3362437 | 3362437 | 2020-02-09 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
3362438 | 3362438 | 2020-02-09 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
3362439 | 3362439 | 2020-02-09 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
3362440 | 3362440 | 2020-02-09 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
3089055 | 3089055 | 2020-02-10 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3089056 | 3089056 | 2020-02-10 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
3089057 | 3089057 | 2020-02-10 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
3089066 | 3089066 | 2020-02-10 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
3089067 | 3089067 | 2020-02-10 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
3089068 | 3089068 | 2020-02-10 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
3089069 | 3089069 | 2020-02-10 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
3089070 | 3089070 | 2020-02-10 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
3089071 | 3089071 | 2020-02-10 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
3197756 | 3197756 | 2020-02-11 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3197757 | 3197757 | 2020-02-11 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
3197758 | 3197758 | 2020-02-11 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
3197767 | 3197767 | 2020-02-11 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
3197768 | 3197768 | 2020-02-11 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
3197769 | 3197769 | 2020-02-11 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
3197770 | 3197770 | 2020-02-11 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
3197771 | 3197771 | 2020-02-11 | US | San Diego County, CA | 1 | 0 | 0 | 32.7157 | -117.1611 | 2020-02-11T01:23:05 | ||||
3197772 | 3197772 | 2020-02-11 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
3197773 | 3197773 | 2020-02-11 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
2567297 | 2567297 | 2020-02-12 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
2567298 | 2567298 | 2020-02-12 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
2567299 | 2567299 | 2020-02-12 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
2567308 | 2567308 | 2020-02-12 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
2567309 | 2567309 | 2020-02-12 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
2567310 | 2567310 | 2020-02-12 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
2567311 | 2567311 | 2020-02-12 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
2567312 | 2567312 | 2020-02-12 | US | San Diego County, CA | 1 | 0 | 0 | 32.7157 | -117.1611 | 2020-02-11T01:23:05 | ||||
2567313 | 2567313 | 2020-02-12 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
2567314 | 2567314 | 2020-02-12 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1559707 | 1559707 | 2020-02-13 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1559708 | 1559708 | 2020-02-13 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
1559709 | 1559709 | 2020-02-13 | US | San Diego County, CA | 2 | 0 | 0 | 32.7157 | -117.1611 | 2020-02-13T03:13:08 | ||||
1559710 | 1559710 | 2020-02-13 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
1559719 | 1559719 | 2020-02-13 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
1559720 | 1559720 | 2020-02-13 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1559721 | 1559721 | 2020-02-13 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
1559722 | 1559722 | 2020-02-13 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1559723 | 1559723 | 2020-02-13 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
1559724 | 1559724 | 2020-02-13 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
1559725 | 1559725 | 2020-02-13 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1192500 | 1192500 | 2020-02-14 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1192501 | 1192501 | 2020-02-14 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
1192502 | 1192502 | 2020-02-14 | US | San Diego County, CA | 2 | 0 | 0 | 32.7157 | -117.1611 | 2020-02-13T03:13:08 | ||||
1192503 | 1192503 | 2020-02-14 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
1192513 | 1192513 | 2020-02-14 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
1192514 | 1192514 | 2020-02-14 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1192515 | 1192515 | 2020-02-14 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
1192516 | 1192516 | 2020-02-14 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1192517 | 1192517 | 2020-02-14 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
1192518 | 1192518 | 2020-02-14 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
1192519 | 1192519 | 2020-02-14 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
107081 | 107081 | 2020-02-15 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
107082 | 107082 | 2020-02-15 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
107083 | 107083 | 2020-02-15 | US | San Diego County, CA | 2 | 0 | 0 | 32.7157 | -117.1611 | 2020-02-13T03:13:08 | ||||
107084 | 107084 | 2020-02-15 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
107094 | 107094 | 2020-02-15 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
107095 | 107095 | 2020-02-15 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
107096 | 107096 | 2020-02-15 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
107097 | 107097 | 2020-02-15 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
107098 | 107098 | 2020-02-15 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
107099 | 107099 | 2020-02-15 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
107100 | 107100 | 2020-02-15 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1888755 | 1888755 | 2020-02-16 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1888756 | 1888756 | 2020-02-16 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
1888757 | 1888757 | 2020-02-16 | US | San Diego County, CA | 2 | 0 | 0 | 32.7157 | -117.1611 | 2020-02-13T03:13:08 | ||||
1888758 | 1888758 | 2020-02-16 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
1888768 | 1888768 | 2020-02-16 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
1888769 | 1888769 | 2020-02-16 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1888770 | 1888770 | 2020-02-16 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
1888771 | 1888771 | 2020-02-16 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1888772 | 1888772 | 2020-02-16 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
1888773 | 1888773 | 2020-02-16 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
1888774 | 1888774 | 2020-02-16 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1243402 | 1243402 | 2020-02-17 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1243403 | 1243403 | 2020-02-17 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
1243404 | 1243404 | 2020-02-17 | US | San Diego County, CA | 2 | 0 | 0 | 32.7157 | -117.1611 | 2020-02-13T03:13:08 | ||||
1243405 | 1243405 | 2020-02-17 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
1243415 | 1243415 | 2020-02-17 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
1243416 | 1243416 | 2020-02-17 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1243417 | 1243417 | 2020-02-17 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
1243418 | 1243418 | 2020-02-17 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1243419 | 1243419 | 2020-02-17 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
1243420 | 1243420 | 2020-02-17 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
1243421 | 1243421 | 2020-02-17 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1783128 | 1783128 | 2020-02-18 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1783129 | 1783129 | 2020-02-18 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
1783130 | 1783130 | 2020-02-18 | US | San Diego County, CA | 2 | 0 | 0 | 32.7157 | -117.1611 | 2020-02-13T03:13:08 | ||||
1783131 | 1783131 | 2020-02-18 | US | Santa Clara, CA | 2 | 0 | 0 | 37.3541 | -121.9552 | 2020-02-03T00:43:02 | ||||
1783141 | 1783141 | 2020-02-18 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
1783142 | 1783142 | 2020-02-18 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1783143 | 1783143 | 2020-02-18 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
1783144 | 1783144 | 2020-02-18 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1783145 | 1783145 | 2020-02-18 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
1783146 | 1783146 | 2020-02-18 | US | Seattle, WA | 1 | 0 | 1 | 47.6062 | -122.3321 | 2020-02-09T07:03:04 | ||||
1783147 | 1783147 | 2020-02-18 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 |
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]);