johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
201 rows where "last_update" is on date 2020-02-01 sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, last_update
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107093 | 107093 | 2020-02-15 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
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 | ||||
107097 | 107097 | 2020-02-15 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
107100 | 107100 | 2020-02-15 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
261148 | 261148 | 2020-03-03 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
261152 | 261152 | 2020-03-03 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
479210 | 479210 | 2020-02-25 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
479212 | 479212 | 2020-02-25 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
479214 | 479214 | 2020-02-25 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
479216 | 479216 | 2020-02-25 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
562606 | 562606 | 2020-03-01 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
562608 | 562608 | 2020-03-01 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
566707 | 566707 | 2020-02-06 | France | 6 | 0 | 0 | 2020-02-01T01:52:40 | |||||||
566711 | 566711 | 2020-02-06 | Australia | Victoria | 4 | 0 | 0 | -37.8136 | 144.9631 | 2020-02-01T18:12:49 | ||||
566719 | 566719 | 2020-02-06 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
566720 | 566720 | 2020-02-06 | US | Chicago, IL | 2 | 0 | 0 | 41.8781 | -87.6298 | 2020-02-01T19:43:03 | ||||
566727 | 566727 | 2020-02-06 | Mainland China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2020-02-01T01:52:40 | ||||
566729 | 566729 | 2020-02-06 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
566731 | 566731 | 2020-02-06 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
566732 | 566732 | 2020-02-06 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
566733 | 566733 | 2020-02-06 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
566735 | 566735 | 2020-02-06 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
566736 | 566736 | 2020-02-06 | US | Seattle, WA | 1 | 0 | 0 | 47.6062 | -122.3321 | 2020-02-01T19:43:03 | ||||
566737 | 566737 | 2020-02-06 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
617485 | 617485 | 2020-02-27 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
617487 | 617487 | 2020-02-27 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
617489 | 617489 | 2020-02-27 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1085699 | 1085699 | 2020-02-22 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
1085700 | 1085700 | 2020-02-22 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
1085702 | 1085702 | 2020-02-22 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1085704 | 1085704 | 2020-02-22 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1085708 | 1085708 | 2020-02-22 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1152757 | 1152757 | 2020-03-02 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1152760 | 1152760 | 2020-03-02 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1192512 | 1192512 | 2020-02-14 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
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 | ||||
1192516 | 1192516 | 2020-02-14 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1192519 | 1192519 | 2020-02-14 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1243414 | 1243414 | 2020-02-17 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
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 | ||||
1243418 | 1243418 | 2020-02-17 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1243421 | 1243421 | 2020-02-17 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1366084 | 1366084 | 2020-02-08 | Australia | Victoria | 4 | 0 | 0 | -37.8136 | 144.9631 | 2020-02-01T18:12:49 | ||||
1366093 | 1366093 | 2020-02-08 | US | Chicago, IL | 2 | 0 | 0 | 41.8781 | -87.6298 | 2020-02-01T19:43:03 | ||||
1366100 | 1366100 | 2020-02-08 | Mainland China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2020-02-01T01:52:40 | ||||
1366102 | 1366102 | 2020-02-08 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
1366104 | 1366104 | 2020-02-08 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
1366105 | 1366105 | 2020-02-08 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
1366106 | 1366106 | 2020-02-08 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1366108 | 1366108 | 2020-02-08 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1366109 | 1366109 | 2020-02-08 | US | Seattle, WA | 1 | 0 | 0 | 47.6062 | -122.3321 | 2020-02-01T19:43:03 | ||||
1366110 | 1366110 | 2020-02-08 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1559718 | 1559718 | 2020-02-13 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
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 | ||||
1559722 | 1559722 | 2020-02-13 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1559725 | 1559725 | 2020-02-13 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1720109 | 1720109 | 2020-02-19 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
1720110 | 1720110 | 2020-02-19 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
1720111 | 1720111 | 2020-02-19 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
1720113 | 1720113 | 2020-02-19 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1720116 | 1720116 | 2020-02-19 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1783140 | 1783140 | 2020-02-18 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
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 | ||||
1783144 | 1783144 | 2020-02-18 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1783147 | 1783147 | 2020-02-18 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
1888767 | 1888767 | 2020-02-16 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
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 | ||||
1888771 | 1888771 | 2020-02-16 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
1888774 | 1888774 | 2020-02-16 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
2091700 | 2091700 | 2020-02-05 | France | 6 | 0 | 0 | 2020-02-01T01:52:40 | |||||||
2091702 | 2091702 | 2020-02-05 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-01T18:12:49 | ||||
2091703 | 2091703 | 2020-02-05 | Australia | Victoria | 4 | 0 | 0 | -37.8136 | 144.9631 | 2020-02-01T18:12:49 | ||||
2091712 | 2091712 | 2020-02-05 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
2091713 | 2091713 | 2020-02-05 | US | Chicago, IL | 2 | 0 | 0 | 41.8781 | -87.6298 | 2020-02-01T19:43:03 | ||||
2091720 | 2091720 | 2020-02-05 | Mainland China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2020-02-01T01:52:40 | ||||
2091722 | 2091722 | 2020-02-05 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
2091724 | 2091724 | 2020-02-05 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
2091725 | 2091725 | 2020-02-05 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
2091726 | 2091726 | 2020-02-05 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
2091728 | 2091728 | 2020-02-05 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
2091729 | 2091729 | 2020-02-05 | US | Seattle, WA | 1 | 0 | 0 | 47.6062 | -122.3321 | 2020-02-01T19:43:03 | ||||
2091730 | 2091730 | 2020-02-05 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
2135781 | 2135781 | 2020-02-21 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
2135782 | 2135782 | 2020-02-21 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
2135784 | 2135784 | 2020-02-21 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
2135786 | 2135786 | 2020-02-21 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
2135790 | 2135790 | 2020-02-21 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
2263517 | 2263517 | 2020-02-20 | Sweden | 1 | 0 | 0 | 2020-02-01T02:13:26 | |||||||
2263518 | 2263518 | 2020-02-20 | US | Boston, MA | 1 | 0 | 0 | 42.3601 | -71.0589 | 2020-02-01T19:43:03 | ||||
2263519 | 2263519 | 2020-02-20 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
2263521 | 2263521 | 2020-02-20 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
2263524 | 2263524 | 2020-02-20 | US | Tempe, AZ | 1 | 0 | 0 | 33.4255 | -111.94 | 2020-02-01T19:43:03 | ||||
2379257 | 2379257 | 2020-02-02 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2379266 | 2379266 | 2020-02-02 | France | 6 | 0 | 0 | 2020-02-01T01:52:40 |
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]);