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
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
657683 | 657683 | 2020-03-09 | Mainland China | Hubei | 67743 | 3008 | 46488 | 30.9756 | 112.2707 | 2020-03-09T14:33:03 | ||||
657684 | 657684 | 2020-03-09 | Italy | 9172 | 463 | 724 | 43.0 | 12.0 | 2020-03-09T18:13:11 | |||||
657685 | 657685 | 2020-03-09 | South Korea | 7478 | 53 | 118 | 36.0 | 128.0 | 2020-03-09T09:03:03 | |||||
657686 | 657686 | 2020-03-09 | Iran | 7161 | 237 | 2394 | 32.0 | 53.0 | 2020-03-09T10:53:03 | |||||
657687 | 657687 | 2020-03-09 | Mainland China | Guangdong | 1352 | 8 | 1260 | 23.3417 | 113.4244 | 2020-03-09T01:43:01 | ||||
657688 | 657688 | 2020-03-09 | Mainland China | Henan | 1272 | 22 | 1247 | 33.882 | 113.614 | 2020-03-08T05:03:02 | ||||
657689 | 657689 | 2020-03-09 | Mainland China | Zhejiang | 1215 | 1 | 1176 | 29.1832 | 120.0934 | 2020-03-09T09:43:03 | ||||
657690 | 657690 | 2020-03-09 | France | 1401 | 25 | 12 | 47.0 | 2.0 | 2020-03-09T00:43:03 | |||||
657691 | 657691 | 2020-03-09 | Germany | 1176 | 2 | 18 | 51.0 | 9.0 | 2020-03-09T18:13:11 | |||||
657692 | 657692 | 2020-03-09 | Spain | 1073 | 28 | 32 | 40.0 | -4.0 | 2020-03-09T18:13:11 | |||||
657693 | 657693 | 2020-03-09 | Mainland China | Hunan | 1018 | 4 | 979 | 27.6104 | 111.7088 | 2020-03-09T01:33:06 | ||||
657694 | 657694 | 2020-03-09 | Mainland China | Anhui | 990 | 6 | 984 | 31.8257 | 117.2264 | 2020-03-08T05:13:06 | ||||
657695 | 657695 | 2020-03-09 | Mainland China | Jiangxi | 935 | 1 | 923 | 27.614 | 115.7221 | 2020-03-09T01:53:01 | ||||
657696 | 657696 | 2020-03-09 | Mainland China | Shandong | 758 | 6 | 700 | 36.3427 | 118.1498 | 2020-03-09T10:13:06 | ||||
657697 | 657697 | 2020-03-09 | Others | Diamond Princess cruise ship | 696 | 6 | 40 | 35.4437 | 139.638 | 2020-03-06T01:29:39 | ||||
657698 | 657698 | 2020-03-09 | Mainland China | Jiangsu | 631 | 0 | 621 | 32.9711 | 119.455 | 2020-03-09T08:53:03 | ||||
657699 | 657699 | 2020-03-09 | Mainland China | Chongqing | 576 | 6 | 542 | 30.0572 | 107.874 | 2020-03-09T23:13:03 | ||||
657700 | 657700 | 2020-03-09 | Mainland China | Sichuan | 539 | 3 | 466 | 30.6171 | 102.7103 | 2020-03-09T08:53:03 | ||||
657701 | 657701 | 2020-03-09 | Japan | 511 | 17 | 76 | 36.0 | 138.0 | 2020-03-09T09:13:17 | |||||
657702 | 657702 | 2020-03-09 | Mainland China | Heilongjiang | 481 | 13 | 430 | 47.862 | 127.7615 | 2020-03-09T14:33:03 | ||||
657703 | 657703 | 2020-03-09 | Mainland China | Beijing | 428 | 8 | 315 | 40.1824 | 116.4142 | 2020-03-09T01:53:01 | ||||
657704 | 657704 | 2020-03-09 | Switzerland | 374 | 2 | 3 | 46.8182 | 8.2275 | 2020-03-09T11:33:10 | |||||
657705 | 657705 | 2020-03-09 | Mainland China | Shanghai | 342 | 3 | 315 | 31.202 | 121.4491 | 2020-03-09T04:03:11 | ||||
657706 | 657706 | 2020-03-09 | Netherlands | 321 | 3 | 0 | 52.1326 | 5.2913 | 2020-03-09T18:13:11 | |||||
657707 | 657707 | 2020-03-09 | United Kingdom | Unknown | 321 | 0 | 18 | 55.0 | -3.0 | 2020-03-09T18:33:03 | ||||
657708 | 657708 | 2020-03-09 | Mainland China | Hebei | 318 | 6 | 307 | 38.0428 | 114.5149 | 2020-03-07T13:03:05 | ||||
657709 | 657709 | 2020-03-09 | Mainland China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-07T13:03:05 | ||||
657710 | 657710 | 2020-03-09 | Mainland China | Guangxi | 252 | 2 | 230 | 23.8298 | 108.7881 | 2020-03-09T00:23:09 | ||||
657711 | 657711 | 2020-03-09 | Sweden | 248 | 0 | 1 | 63.0 | 16.0 | 2020-03-09T18:33:03 | |||||
657712 | 657712 | 2020-03-09 | Mainland China | Shaanxi | 245 | 1 | 227 | 35.1917 | 108.8701 | 2020-03-08T14:43:03 | ||||
657713 | 657713 | 2020-03-09 | Belgium | 239 | 0 | 1 | 50.8333 | 4.0 | 2020-03-09T10:43:05 | |||||
657714 | 657714 | 2020-03-09 | Norway | 205 | 0 | 1 | 60.472 | 8.4689 | 2020-03-09T18:33:03 | |||||
657715 | 657715 | 2020-03-09 | Mainland China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-06T03:23:06 | ||||
657716 | 657716 | 2020-03-09 | Mainland China | Hainan | 168 | 6 | 159 | 19.1959 | 109.7453 | 2020-03-08T04:33:02 | ||||
657717 | 657717 | 2020-03-09 | Singapore | 150 | 0 | 78 | 1.2833 | 103.8333 | 2020-03-08T13:33:13 | |||||
657718 | 657718 | 2020-03-09 | Mainland China | Guizhou | 146 | 2 | 123 | 26.8154 | 106.8748 | 2020-03-09T01:13:05 | ||||
657719 | 657719 | 2020-03-09 | Mainland China | Tianjin | 136 | 3 | 130 | 39.3054 | 117.323 | 2020-03-09T10:13:06 | ||||
657720 | 657720 | 2020-03-09 | Mainland China | Shanxi | 133 | 0 | 127 | 37.5777 | 112.2922 | 2020-03-09T11:43:02 | ||||
657721 | 657721 | 2020-03-09 | Austria | 98 | 0 | 2 | 47.5162 | 14.5501 | 2020-03-09T18:33:03 | |||||
657722 | 657722 | 2020-03-09 | Mainland China | Liaoning | 125 | 1 | 109 | 41.2956 | 122.6085 | 2020-03-08T05:13:06 | ||||
657723 | 657723 | 2020-03-09 | Mainland China | Gansu | 124 | 2 | 88 | 36.0611 | 103.8343 | 2020-03-09T14:33:03 | ||||
657724 | 657724 | 2020-03-09 | Hong Kong | Hong Kong | 115 | 3 | 59 | 22.3 | 114.2 | 2020-03-09T10:03:17 | ||||
657725 | 657725 | 2020-03-09 | US | Westchester County, NY | 98 | 0 | 0 | 41.122 | -73.7949 | 2020-03-09T17:13:16 | ||||
657726 | 657726 | 2020-03-09 | Bahrain | 95 | 0 | 14 | 26.0275 | 50.55 | 2020-03-09T10:03:17 | |||||
657727 | 657727 | 2020-03-09 | Mainland China | Jilin | 93 | 1 | 91 | 43.6661 | 126.1923 | 2020-03-09T14:33:03 | ||||
657728 | 657728 | 2020-03-09 | Denmark | 90 | 0 | 1 | 56.2639 | 9.5018 | 2020-03-09T18:13:11 | |||||
657729 | 657729 | 2020-03-09 | US | King County, WA | 83 | 17 | 1 | 47.548 | -121.9836 | 2020-03-08T20:23:09 | ||||
657730 | 657730 | 2020-03-09 | Mainland China | Xinjiang | 76 | 3 | 73 | 41.1129 | 85.2401 | 2020-03-08T05:33:02 | ||||
657731 | 657731 | 2020-03-09 | Mainland China | Inner Mongolia | 75 | 1 | 70 | 44.0935 | 113.9448 | 2020-03-08T05:13:06 | ||||
657732 | 657732 | 2020-03-09 | Mainland China | Ningxia | 75 | 0 | 71 | 37.2692 | 106.1655 | 2020-03-06T12:53:03 | ||||
657733 | 657733 | 2020-03-09 | Greece | 73 | 0 | 0 | 39.0742 | 21.8243 | 2020-03-08T17:23:07 | |||||
657734 | 657734 | 2020-03-09 | Kuwait | 64 | 0 | 1 | 29.5 | 47.75 | 2020-03-08T15:33:04 | |||||
657735 | 657735 | 2020-03-09 | Iraq | 60 | 6 | 9 | 33.0 | 44.0 | 2020-03-09T23:33:02 | |||||
657736 | 657736 | 2020-03-09 | Iceland | 58 | 0 | 0 | 64.9631 | -19.0208 | 2020-03-09T10:03:17 | |||||
657737 | 657737 | 2020-03-09 | Egypt | 55 | 1 | 12 | 26.0 | 30.0 | 2020-03-09T10:03:17 | |||||
657738 | 657738 | 2020-03-09 | Thailand | 50 | 1 | 33 | 15.0 | 101.0 | 2020-03-07T10:13:23 | |||||
657739 | 657739 | 2020-03-09 | Australia | New South Wales | 48 | 3 | 4 | -33.8688 | 151.2093 | 2020-03-09T18:53:13 | ||||
657740 | 657740 | 2020-03-09 | Taiwan | Taiwan | 45 | 1 | 15 | 23.7 | 121.0 | 2020-03-09T00:33:14 | ||||
657741 | 657741 | 2020-03-09 | US | Unassigned Location (From Diamond Princess) | 45 | 0 | 0 | 35.4437 | 139.638 | 2020-03-02T19:53:03 | ||||
657742 | 657742 | 2020-03-09 | United Arab Emirates | 45 | 0 | 7 | 24.0 | 54.0 | 2020-03-07T10:13:22 | |||||
657743 | 657743 | 2020-03-09 | India | 43 | 0 | 3 | 21.0 | 78.0 | 2020-03-09T09:13:17 | |||||
657744 | 657744 | 2020-03-09 | Israel | 38 | 0 | 0 | 31.0 | 35.0 | 2020-03-08T21:03:03 | |||||
657745 | 657745 | 2020-03-09 | US | Santa Clara County, CA | 38 | 0 | 1 | 37.3541 | -121.9552 | 2020-03-08T21:23:03 | ||||
657746 | 657746 | 2020-03-09 | San Marino | 37 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-08T14:23:10 | |||||
657747 | 657747 | 2020-03-09 | Canada | Ontario | 90 | 1 | 4 | 51.2538 | -85.3232 | 2020-03-09T17:53:24 | ||||
657748 | 657748 | 2020-03-09 | Canada | British Columbia | 32 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-09T22:43:25 | ||||
657749 | 657749 | 2020-03-09 | Lebanon | 32 | 0 | 1 | 33.8547 | 35.8623 | 2020-03-08T18:13:19 | |||||
657750 | 657750 | 2020-03-09 | Czech Republic | 31 | 0 | 0 | 49.8175 | 15.473 | 2020-03-08T19:53:03 | |||||
657751 | 657751 | 2020-03-09 | US | Snohomish County, WA | 31 | 1 | 0 | 48.033 | -121.8339 | 2020-03-08T21:43:03 | ||||
657752 | 657752 | 2020-03-09 | Finland | 44 | 1 | 1 | 64.0 | 26.0 | 2020-03-09T09:23:03 | |||||
657753 | 657753 | 2020-03-09 | Portugal | 30 | 0 | 0 | 39.3999 | -8.2245 | 2020-03-08T19:53:03 | |||||
657754 | 657754 | 2020-03-09 | Vietnam | 30 | 0 | 16 | 16.0 | 108.0 | 2020-03-08T19:53:03 | |||||
657755 | 657755 | 2020-03-09 | Brazil | 25 | 0 | 0 | -14.235 | -51.9253 | 2020-03-09T10:13:06 | |||||
657756 | 657756 | 2020-03-09 | Palestine | 22 | 0 | 0 | 31.9522 | 35.2332 | 2020-03-07T02:23:06 | |||||
657757 | 657757 | 2020-03-09 | Ireland | 21 | 0 | 0 | 53.1424 | -7.6921 | 2020-03-09T09:53:06 | |||||
657758 | 657758 | 2020-03-09 | US | Grand Princess Cruise Ship | 21 | 0 | 0 | 37.6489 | -122.6655 | 2020-03-07T01:33:02 | ||||
657759 | 657759 | 2020-03-09 | Algeria | 20 | 0 | 0 | 28.0339 | 1.6596 | 2020-03-09T10:13:06 | |||||
657760 | 657760 | 2020-03-09 | Philippines | 20 | 1 | 1 | 13.0 | 122.0 | 2020-03-09T09:23:03 | |||||
657761 | 657761 | 2020-03-09 | Indonesia | 19 | 0 | 0 | -0.7893 | 113.9213 | 2020-03-09T11:33:10 | |||||
657762 | 657762 | 2020-03-09 | US | New York County, NY | 19 | 0 | 0 | 40.7128 | -74.006 | 2020-03-09T17:13:16 | ||||
657763 | 657763 | 2020-03-09 | Mainland China | Qinghai | 18 | 0 | 18 | 35.7452 | 95.9956 | 2020-02-21T04:43:02 | ||||
657764 | 657764 | 2020-03-09 | Qatar | 18 | 0 | 0 | 25.3548 | 51.1839 | 2020-03-09T10:13:09 | |||||
657765 | 657765 | 2020-03-09 | Russia | 17 | 0 | 3 | 60.0 | 90.0 | 2020-03-08T21:03:03 | |||||
657766 | 657766 | 2020-03-09 | US | Nassau County, NY | 17 | 0 | 0 | 40.6546 | -73.5594 | 2020-03-09T17:13:14 | ||||
657767 | 657767 | 2020-03-09 | Oman | 16 | 0 | 2 | 21.0 | 57.0 | 2020-03-05T17:53:02 | |||||
657768 | 657768 | 2020-03-09 | Poland | 16 | 0 | 0 | 51.9194 | 19.1451 | 2020-03-09T11:33:10 | |||||
657769 | 657769 | 2020-03-09 | Slovenia | 16 | 0 | 0 | 46.1512 | 14.9955 | 2020-03-08T17:03:16 | |||||
657770 | 657770 | 2020-03-09 | Australia | Queensland | 15 | 0 | 8 | -28.0167 | 153.4 | 2020-03-08T05:43:04 | ||||
657771 | 657771 | 2020-03-09 | Australia | Victoria | 15 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-09T18:33:03 | ||||
657772 | 657772 | 2020-03-09 | Ecuador | 15 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-09T09:03:03 | |||||
657773 | 657773 | 2020-03-09 | Georgia | 15 | 0 | 0 | 42.3154 | 43.3569 | 2020-03-09T10:13:06 | |||||
657774 | 657774 | 2020-03-09 | Romania | 15 | 0 | 3 | 46.0 | 25.0 | 2020-03-08T17:23:07 | |||||
657775 | 657775 | 2020-03-09 | Saudi Arabia | 15 | 0 | 0 | 24.0 | 45.0 | 2020-03-09T09:03:03 | |||||
657776 | 657776 | 2020-03-09 | US | Los Angeles, CA | 14 | 0 | 0 | 34.0522 | -118.2437 | 2020-03-08T01:13:48 | ||||
657777 | 657777 | 2020-03-09 | Argentina | 12 | 1 | 0 | -38.4161 | -63.6167 | 2020-03-08T22:03:11 | |||||
657778 | 657778 | 2020-03-09 | Croatia | 12 | 0 | 0 | 45.1667 | 15.5 | 2020-03-07T10:13:23 | |||||
657779 | 657779 | 2020-03-09 | US | Contra Costa County, CA | 12 | 0 | 0 | 37.8534 | -121.9018 | 2020-03-08T21:43:03 | ||||
657780 | 657780 | 2020-03-09 | Estonia | 10 | 0 | 0 | 58.5953 | 25.0136 | 2020-03-06T13:03:13 | |||||
657781 | 657781 | 2020-03-09 | Macau | Macau | 10 | 0 | 10 | 22.1667 | 113.55 | 2020-03-06T10:23:03 | ||||
657782 | 657782 | 2020-03-09 | Azerbaijan | 9 | 0 | 0 | 40.1431 | 47.5769 | 2020-03-07T02:13:09 |
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]);