johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
261098 | 261098 | 2020-03-03 | Azerbaijan | 3 | 0 | 0 | 40.1431 | 47.5769 | 2020-03-01T02:43:03 | |||||
261099 | 261099 | 2020-03-03 | Georgia | 3 | 0 | 0 | 42.3154 | 43.3569 | 2020-03-01T15:43:03 | |||||
261100 | 261100 | 2020-03-03 | Philippines | 3 | 1 | 1 | 13.0 | 122.0 | 2020-02-12T07:43:02 | |||||
261101 | 261101 | 2020-03-03 | Romania | 3 | 0 | 0 | 46.0 | 25.0 | 2020-03-03T00:23:16 | |||||
261102 | 261102 | 2020-03-03 | Russia | 3 | 0 | 2 | 60.0 | 90.0 | 2020-03-02T21:23:04 | |||||
261103 | 261103 | 2020-03-03 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
261104 | 261104 | 2020-03-03 | Brazil | 2 | 0 | 0 | -14.235 | -51.9253 | 2020-02-29T21:03:05 | |||||
261105 | 261105 | 2020-03-03 | Egypt | 2 | 0 | 1 | 26.0 | 30.0 | 2020-03-01T23:33:03 | |||||
261106 | 261106 | 2020-03-03 | Estonia | 2 | 0 | 0 | 58.5953 | 25.0136 | 2020-03-03T23:53:03 | |||||
261107 | 261107 | 2020-03-03 | Indonesia | 2 | 0 | 0 | -0.7893 | 113.9213 | 2020-03-02T18:03:04 | |||||
261108 | 261108 | 2020-03-03 | Ireland | 2 | 0 | 0 | 53.1424 | -7.6921 | 2020-03-03T23:53:03 | |||||
261109 | 261109 | 2020-03-03 | Portugal | 2 | 0 | 0 | 39.3999 | -8.2245 | 2020-03-03T15:33:02 | |||||
261110 | 261110 | 2020-03-03 | Senegal | 2 | 0 | 0 | 14.4974 | -14.4524 | 2020-03-03T23:53:03 | |||||
261111 | 261111 | 2020-03-03 | US | Fulton County, GA | 2 | 0 | 0 | 33.8034 | -84.3963 | 2020-03-03T03:33:02 | ||||
261112 | 261112 | 2020-03-03 | US | Grafton County, NH | 2 | 0 | 0 | 43.9088 | -71.826 | 2020-03-03T23:33:03 | ||||
261113 | 261113 | 2020-03-03 | US | Hillsborough, FL | 2 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-03T18:33:02 | ||||
261114 | 261114 | 2020-03-03 | US | Providence, RI | 2 | 0 | 0 | 41.824 | -71.4128 | 2020-03-02T03:43:02 | ||||
261115 | 261115 | 2020-03-03 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
261116 | 261116 | 2020-03-03 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
261117 | 261117 | 2020-03-03 | US | San Diego County, CA | 2 | 0 | 1 | 32.7157 | -117.1611 | 2020-02-21T05:43:02 | ||||
261118 | 261118 | 2020-03-03 | US | San Mateo, CA | 2 | 0 | 0 | 37.563 | -122.3255 | 2020-03-03T00:43:02 | ||||
261119 | 261119 | 2020-03-03 | US | Washington County, OR | 2 | 0 | 0 | 45.547 | -123.1386 | 2020-03-03T03:03:02 | ||||
261120 | 261120 | 2020-03-03 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
261121 | 261121 | 2020-03-03 | Andorra | 1 | 0 | 0 | 42.5063 | 1.5218 | 2020-03-02T20:23:16 | |||||
261122 | 261122 | 2020-03-03 | Argentina | 1 | 0 | 0 | -38.4161 | -63.6167 | 2020-03-03T17:43:02 | |||||
261123 | 261123 | 2020-03-03 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
261124 | 261124 | 2020-03-03 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
261125 | 261125 | 2020-03-03 | Belarus | 1 | 0 | 0 | 53.7098 | 27.9534 | 2020-02-28T16:23: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]);