johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, latitude
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
197911 | 197911 | 2020-01-29 | Malaysia | W.P. Putrajaya | 0 | 0 | 0 | 2.9264 | 101.6964 | 1/29/20 19:30 | ||||
197912 | 197912 | 2020-01-29 | Malaysia | Unknown | 0 | 0 | 0 | 1/29/20 19:30 | ||||||
197913 | 197913 | 2020-01-29 | Tonga | 0 | 0 | 0 | 1/29/20 19:30 | |||||||
197914 | 197914 | 2020-01-29 | Winter Olympics 2022 | 0 | 0 | 0 | 1/29/20 19:30 | |||||||
197915 | 197915 | 2020-01-29 | Antarctica | 0 | 0 | 0 | 1/29/20 19:30 | |||||||
197916 | 197916 | 2020-01-29 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/29/20 19:30 | ||||
197917 | 197917 | 2020-01-29 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/29/20 19:30 | ||||
197918 | 197918 | 2020-01-29 | Korea, North | 0 | 0 | 0 | 1/29/20 19:30 | |||||||
197919 | 197919 | 2020-01-29 | Ukraine | Unknown | 0 | 0 | 0 | 1/29/20 19:30 | ||||||
197920 | 197920 | 2020-01-29 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/29/20 19:30 | ||||
197921 | 197921 | 2020-01-29 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/29/20 19:30 | ||||
197922 | 197922 | 2020-01-29 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/29/20 19:30 | ||||
197923 | 197923 | 2020-01-29 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/29/20 19:30 | ||||
197924 | 197924 | 2020-01-29 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/29/20 19:30 | ||||
197925 | 197925 | 2020-01-29 | Nauru | 0 | 0 | 0 | 1/29/20 19:30 | |||||||
197926 | 197926 | 2020-01-29 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 1/29/20 19:30 | ||||
197927 | 197927 | 2020-01-29 | Tuvalu | 0 | 0 | 0 | 1/29/20 19:30 | |||||||
197928 | 197928 | 2020-01-29 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/29/20 19:30 | ||||
261016 | 261016 | 2020-03-03 | Mainland China | Hubei | 67217 | 2835 | 36208 | 30.9756 | 112.2707 | 2020-03-03T11:43:02 | ||||
261017 | 261017 | 2020-03-03 | South Korea | 5186 | 28 | 30 | 36.0 | 128.0 | 2020-03-03T09:43:02 | |||||
261018 | 261018 | 2020-03-03 | Italy | 2502 | 79 | 160 | 43.0 | 12.0 | 2020-03-03T20:03:06 | |||||
261019 | 261019 | 2020-03-03 | Iran | 2336 | 77 | 291 | 32.0 | 53.0 | 2020-03-03T14:23:03 | |||||
261020 | 261020 | 2020-03-03 | Mainland China | Guangdong | 1350 | 7 | 1101 | 23.3417 | 113.4244 | 2020-03-03T10:23:10 | ||||
261021 | 261021 | 2020-03-03 | Mainland China | Henan | 1272 | 22 | 1231 | 33.882 | 113.614 | 2020-03-03T09:43:02 | ||||
261022 | 261022 | 2020-03-03 | Mainland China | Zhejiang | 1213 | 1 | 1093 | 29.1832 | 120.0934 | 2020-03-03T12:33:02 | ||||
261023 | 261023 | 2020-03-03 | Mainland China | Hunan | 1018 | 4 | 906 | 27.6104 | 111.7088 | 2020-03-03T13:03:04 | ||||
261024 | 261024 | 2020-03-03 | Mainland China | Anhui | 990 | 6 | 936 | 31.8257 | 117.2264 | 2020-03-03T14:33:03 | ||||
261025 | 261025 | 2020-03-03 | Mainland China | Jiangxi | 935 | 1 | 870 | 27.614 | 115.7221 | 2020-03-03T02:03:11 | ||||
261026 | 261026 | 2020-03-03 | Mainland China | Shandong | 758 | 6 | 511 | 36.3427 | 118.1498 | 2020-03-03T07:53:03 | ||||
261027 | 261027 | 2020-03-03 | Others | Diamond Princess cruise ship | 706 | 6 | 10 | 35.4437 | 139.638 | 2020-03-03T03:13:06 | ||||
261028 | 261028 | 2020-03-03 | Mainland China | Jiangsu | 631 | 0 | 562 | 32.9711 | 119.455 | 2020-03-03T11:03:09 | ||||
261029 | 261029 | 2020-03-03 | Mainland China | Chongqing | 576 | 6 | 490 | 30.0572 | 107.874 | 2020-03-03T23:13:05 | ||||
261030 | 261030 | 2020-03-03 | Mainland China | Sichuan | 538 | 3 | 394 | 30.6171 | 102.7103 | 2020-03-03T09:33:02 | ||||
261031 | 261031 | 2020-03-03 | Mainland China | Heilongjiang | 480 | 13 | 366 | 47.862 | 127.7615 | 2020-03-03T13:03:04 | ||||
261032 | 261032 | 2020-03-03 | Mainland China | Beijing | 414 | 8 | 288 | 40.1824 | 116.4142 | 2020-03-03T02:03:11 | ||||
261033 | 261033 | 2020-03-03 | Mainland China | Shanghai | 338 | 3 | 294 | 31.202 | 121.4491 | 2020-03-03T03:43:02 | ||||
261034 | 261034 | 2020-03-03 | Mainland China | Hebei | 318 | 6 | 300 | 38.0428 | 114.5149 | 2020-03-03T09:33:02 | ||||
261035 | 261035 | 2020-03-03 | Mainland China | Fujian | 296 | 1 | 260 | 26.0789 | 117.9874 | 2020-03-03T13:43:03 | ||||
261036 | 261036 | 2020-03-03 | Japan | 293 | 6 | 43 | 36.0 | 138.0 | 2020-03-03T20:03:06 | |||||
261037 | 261037 | 2020-03-03 | Mainland China | Guangxi | 252 | 2 | 202 | 23.8298 | 108.7881 | 2020-03-03T00:23:14 | ||||
261038 | 261038 | 2020-03-03 | Mainland China | Shaanxi | 245 | 1 | 216 | 35.1917 | 108.8701 | 2020-03-02T08:03:12 | ||||
261039 | 261039 | 2020-03-03 | France | 212 | 4 | 12 | 47.0 | 2.0 | 2020-03-03T15:23:03 | |||||
261040 | 261040 | 2020-03-03 | Germany | 196 | 0 | 16 | 51.0 | 9.0 | 2020-03-03T20:03:06 | |||||
261041 | 261041 | 2020-03-03 | Mainland China | Yunnan | 174 | 2 | 169 | 24.974 | 101.487 | 2020-03-03T03:43:02 | ||||
261042 | 261042 | 2020-03-03 | Mainland China | Hainan | 168 | 5 | 155 | 19.1959 | 109.7453 | 2020-03-03T23:43:02 | ||||
261043 | 261043 | 2020-03-03 | Spain | 165 | 1 | 2 | 40.0 | -4.0 | 2020-03-03T23:53:03 | |||||
261044 | 261044 | 2020-03-03 | Mainland China | Guizhou | 146 | 2 | 114 | 26.8154 | 106.8748 | 2020-03-02T01:13:06 | ||||
261045 | 261045 | 2020-03-03 | Mainland China | Tianjin | 136 | 3 | 124 | 39.3054 | 117.323 | 2020-03-03T11:43:02 | ||||
261046 | 261046 | 2020-03-03 | Mainland China | Shanxi | 133 | 0 | 124 | 37.5777 | 112.2922 | 2020-03-03T23:13:05 | ||||
261047 | 261047 | 2020-03-03 | Mainland China | Liaoning | 125 | 1 | 106 | 41.2956 | 122.6085 | 2020-03-03T14:33:03 | ||||
261048 | 261048 | 2020-03-03 | Singapore | 110 | 0 | 78 | 1.2833 | 103.8333 | 2020-03-03T15:23:03 | |||||
261049 | 261049 | 2020-03-03 | Hong Kong | Hong Kong | 100 | 2 | 37 | 22.3 | 114.2 | 2020-03-03T11:53:01 | ||||
261050 | 261050 | 2020-03-03 | Mainland China | Jilin | 93 | 1 | 83 | 43.6661 | 126.1923 | 2020-03-02T15:03:23 | ||||
261051 | 261051 | 2020-03-03 | Mainland China | Gansu | 91 | 2 | 86 | 36.0611 | 103.8343 | 2020-03-03T13:43:03 | ||||
261052 | 261052 | 2020-03-03 | Mainland China | Xinjiang | 76 | 3 | 68 | 41.1129 | 85.2401 | 2020-03-03T07:33:03 | ||||
261053 | 261053 | 2020-03-03 | Mainland China | Inner Mongolia | 75 | 1 | 59 | 44.0935 | 113.9448 | 2020-03-03T09:23:02 | ||||
261054 | 261054 | 2020-03-03 | Mainland China | Ningxia | 74 | 0 | 69 | 37.2692 | 106.1655 | 2020-03-02T01:33:02 | ||||
261055 | 261055 | 2020-03-03 | Kuwait | 56 | 0 | 0 | 29.5 | 47.75 | 2020-03-02T20:33:02 | |||||
261056 | 261056 | 2020-03-03 | Switzerland | 56 | 0 | 2 | 46.8182 | 8.2275 | 2020-03-03T16:43:02 | |||||
261057 | 261057 | 2020-03-03 | United Kingdom | Unknown | 51 | 0 | 8 | 55.0 | -3.0 | 2020-03-03T15:13:26 | ||||
261058 | 261058 | 2020-03-03 | Bahrain | 49 | 0 | 0 | 26.0275 | 50.55 | 2020-03-02T20:33:02 | |||||
261059 | 261059 | 2020-03-03 | US | Unassigned Location (From Diamond Princess) | 45 | 0 | 0 | 35.4437 | 139.638 | 2020-03-02T19:53:03 | ||||
261060 | 261060 | 2020-03-03 | Thailand | 43 | 1 | 31 | 15.0 | 101.0 | 2020-03-02T06:23:04 | |||||
261061 | 261061 | 2020-03-03 | Taiwan | Taiwan | 42 | 1 | 12 | 23.7 | 121.0 | 2020-03-03T06:43:02 | ||||
261062 | 261062 | 2020-03-03 | Iraq | 32 | 0 | 0 | 33.0 | 44.0 | 2020-03-03T20:03:06 | |||||
261063 | 261063 | 2020-03-03 | Norway | 32 | 0 | 0 | 60.472 | 8.4689 | 2020-03-03T14:33:03 | |||||
261064 | 261064 | 2020-03-03 | United Arab Emirates | 27 | 0 | 5 | 24.0 | 54.0 | 2020-03-03T23:43:02 | |||||
261065 | 261065 | 2020-03-03 | Netherlands | 24 | 0 | 0 | 52.1326 | 5.2913 | 2020-03-03T15:13:26 | |||||
261066 | 261066 | 2020-03-03 | Austria | 12 | 0 | 0 | 47.5162 | 14.5501 | 2020-03-03T15:13:26 | |||||
261067 | 261067 | 2020-03-03 | Sweden | 21 | 0 | 0 | 63.0 | 16.0 | 2020-03-03T15:13:26 | |||||
261068 | 261068 | 2020-03-03 | US | King County, WA | 21 | 6 | 1 | 47.548 | -121.9836 | 2020-03-03T20:23:05 | ||||
261069 | 261069 | 2020-03-03 | Canada | Toronto, ON | 19 | 0 | 2 | 43.6532 | -79.3832 | 2020-03-03T20:03:08 | ||||
261070 | 261070 | 2020-03-03 | Mainland China | Qinghai | 18 | 0 | 18 | 35.7452 | 95.9956 | 2020-02-21T04:43:02 | ||||
261071 | 261071 | 2020-03-03 | Vietnam | 16 | 0 | 16 | 16.0 | 108.0 | 2020-02-25T08:53:02 | |||||
261072 | 261072 | 2020-03-03 | Australia | New South Wales | 13 | 0 | 4 | -33.8688 | 151.2093 | 2020-03-03T15:13:26 | ||||
261073 | 261073 | 2020-03-03 | Belgium | 13 | 0 | 1 | 50.8333 | 4.0 | 2020-03-03T15:13:26 | |||||
261074 | 261074 | 2020-03-03 | Lebanon | 13 | 0 | 0 | 33.8547 | 35.8623 | 2020-03-02T20:53:02 | |||||
261075 | 261075 | 2020-03-03 | Israel | 15 | 0 | 0 | 31.0 | 35.0 | 2020-03-03T04:23:07 | |||||
261076 | 261076 | 2020-03-03 | Oman | 12 | 0 | 2 | 21.0 | 57.0 | 2020-03-03T15:23:03 | |||||
261077 | 261077 | 2020-03-03 | Australia | Queensland | 11 | 0 | 1 | -28.0167 | 153.4 | 2020-03-03T15:23:03 | ||||
261078 | 261078 | 2020-03-03 | Iceland | 11 | 0 | 0 | 64.9631 | -19.0208 | 2020-03-03T15:13:26 | |||||
261079 | 261079 | 2020-03-03 | US | Santa Clara, CA | 11 | 0 | 1 | 37.3541 | -121.9552 | 2020-03-03T23:33:03 | ||||
261080 | 261080 | 2020-03-03 | Macau | Macau | 10 | 0 | 9 | 22.1667 | 113.55 | 2020-03-03T12:33:02 | ||||
261081 | 261081 | 2020-03-03 | San Marino | 9 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-03T15:23:03 | |||||
261082 | 261082 | 2020-03-03 | Australia | Victoria | 9 | 0 | 4 | -37.8136 | 144.9631 | 2020-03-02T00:53:03 | ||||
261083 | 261083 | 2020-03-03 | Canada | British Columbia | 9 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-03T23:53:03 | ||||
261084 | 261084 | 2020-03-03 | Croatia | 9 | 0 | 0 | 45.1667 | 15.5 | 2020-03-03T09:53:08 | |||||
261085 | 261085 | 2020-03-03 | Ecuador | 7 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-03T15:13:26 | |||||
261086 | 261086 | 2020-03-03 | Greece | 7 | 0 | 0 | 39.0742 | 21.8243 | 2020-03-01T23:23:02 | |||||
261087 | 261087 | 2020-03-03 | Qatar | 7 | 0 | 0 | 25.3548 | 51.1839 | 2020-03-03T03:23:03 | |||||
261088 | 261088 | 2020-03-03 | Denmark | 6 | 0 | 0 | 56.2639 | 9.5018 | 2020-03-03T15:13:26 | |||||
261089 | 261089 | 2020-03-03 | Finland | 10 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
261090 | 261090 | 2020-03-03 | US | Snohomish County, WA | 6 | 1 | 0 | 48.033 | -121.8339 | 2020-03-03T20:23:05 | ||||
261091 | 261091 | 2020-03-03 | Algeria | 5 | 0 | 0 | 28.0339 | 1.6596 | 2020-03-03T03:23:03 | |||||
261092 | 261092 | 2020-03-03 | Czech Republic | 5 | 0 | 0 | 49.8175 | 15.473 | 2020-03-03T15:13:26 | |||||
261093 | 261093 | 2020-03-03 | India | 5 | 0 | 3 | 21.0 | 78.0 | 2020-03-02T22:33:09 | |||||
261094 | 261094 | 2020-03-03 | Mexico | 5 | 0 | 1 | 23.0 | -102.0 | 2020-03-03T10:03:04 | |||||
261095 | 261095 | 2020-03-03 | Pakistan | 5 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-03T04:33:03 | |||||
261096 | 261096 | 2020-03-03 | US | Cook County, IL | 4 | 0 | 2 | 41.7377 | -87.6976 | 2020-03-02T20:33:02 | ||||
261097 | 261097 | 2020-03-03 | Australia | South Australia | 3 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-29T02:03:10 |
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]);