03-02-2020
Data source: Big Local News · About: README
141 rows sorted by Latitude
This data as json, copyable, CSV (advanced)
Suggested facets: Deaths, Last Update (date)
| Link | rowid | Province/State | Country/Region | Last Update | Confirmed | Deaths | Recovered | Latitude ▼ | Longitude |
|---|---|---|---|---|---|---|---|---|---|
| 102 | 102 | Tasmania | Australia | 2020-03-02T20:53:02 | 1 | 0 | 0 | -41.4545 | 145.9707 |
| 117 | 117 | New Zealand | 2020-02-28T16:23:03 | 1 | 0 | 0 | -40.9006 | 174.886 | |
| 62 | 62 | Victoria | Australia | 2020-03-02T00:53:03 | 9 | 0 | 4 | -37.8136 | 144.9631 |
| 81 | 81 | South Australia | Australia | 2020-02-29T02:03:10 | 3 | 0 | 2 | -34.9285 | 138.6007 |
| 69 | 69 | New South Wales | Australia | 2020-03-01T23:33:03 | 6 | 0 | 4 | -33.8688 | 151.2093 |
| 89 | 89 | Western Australia | Australia | 2020-03-01T02:43:03 | 2 | 1 | 0 | -31.9505 | 115.8605 |
| 61 | 61 | Queensland | Australia | 2020-02-29T02:03:10 | 9 | 0 | 1 | -28.0167 | 153.4 |
| 90 | 90 | Brazil | 2020-02-29T21:03:05 | 2 | 0 | 0 | -14.235 | -51.9253 | |
| 70 | 70 | Ecuador | 2020-03-01T23:33:03 | 6 | 0 | 0 | -1.8312 | -78.1834 | |
| 92 | 92 | Indonesia | 2020-03-02T18:03:04 | 2 | 0 | 0 | -0.7893 | 113.9213 | |
| 33 | 33 | Singapore | 2020-03-02T20:33:02 | 108 | 0 | 78 | 1.2833 | 103.8333 | |
| 47 | 47 | Malaysia | 2020-03-01T12:53:02 | 29 | 0 | 18 | 2.5 | 112.5 | |
| 122 | 122 | Sri Lanka | 2020-02-08T03:43:03 | 1 | 0 | 1 | 7.0 | 81.0 | |
| 118 | 118 | Nigeria | 2020-02-28T16:23:03 | 1 | 0 | 0 | 9.082 | 8.6753 | |
| 104 | 104 | Cambodia | 2020-02-12T07:43:02 | 1 | 0 | 1 | 11.55 | 104.9167 | |
| 85 | 85 | Philippines | 2020-02-12T07:43:02 | 3 | 1 | 1 | 13.0 | 122.0 | |
| 121 | 121 | Senegal | 2020-03-02T20:23:16 | 1 | 0 | 0 | 14.4974 | -14.4524 | |
| 43 | 43 | Thailand | 2020-03-02T06:23:04 | 43 | 1 | 31 | 15.0 | 101.0 | |
| 55 | 55 | Vietnam | 2020-02-25T08:53:02 | 16 | 0 | 16 | 16.0 | 108.0 | |
| 107 | 107 | Dominican Republic | 2020-03-02T16:33:02 | 1 | 0 | 0 | 18.7357 | -70.1627 | |
| 26 | 26 | Hainan | Mainland China | 2020-03-02T02:03:18 | 168 | 5 | 151 | 19.1959 | 109.7453 |
| 73 | 73 | Oman | 2020-02-29T12:33:03 | 6 | 0 | 1 | 21.0 | 57.0 | |
| 74 | 74 | India | 2020-03-02T22:33:09 | 5 | 0 | 3 | 21.0 | 78.0 | |
| 60 | 60 | Macau | Macau | 2020-02-27T12:43:02 | 10 | 0 | 8 | 22.1667 | 113.55 |
| 34 | 34 | Hong Kong | Hong Kong | 2020-03-02T23:53:02 | 100 | 2 | 36 | 22.3 | 114.2 |
| 75 | 75 | Mexico | 2020-03-01T23:33:03 | 5 | 0 | 0 | 23.0 | -102.0 | |
| 5 | 5 | Guangdong | Mainland China | 2020-03-02T15:03:23 | 1350 | 7 | 1059 | 23.3417 | 113.4244 |
| 45 | 45 | Taiwan | Taiwan | 2020-03-02T08:03:12 | 41 | 1 | 12 | 23.7 | 121.0 |
| 22 | 22 | Guangxi | Mainland China | 2020-03-02T12:53:02 | 252 | 2 | 192 | 23.8298 | 108.7881 |
| 50 | 50 | United Arab Emirates | 2020-02-29T12:33:03 | 21 | 0 | 5 | 24.0 | 54.0 | |
| 120 | 120 | Saudi Arabia | 2020-03-02T23:53:02 | 1 | 0 | 0 | 24.0 | 45.0 | |
| 25 | 25 | Yunnan | Mainland China | 2020-03-02T06:23:04 | 174 | 2 | 168 | 24.974 | 101.487 |
| 86 | 86 | Qatar | 2020-03-01T23:33:03 | 3 | 0 | 0 | 25.3548 | 51.1839 | |
| 91 | 91 | Egypt | 2020-03-01T23:33:03 | 2 | 0 | 1 | 26.0 | 30.0 | |
| 41 | 41 | Bahrain | 2020-03-02T20:33:02 | 49 | 0 | 0 | 26.0275 | 50.55 | |
| 20 | 20 | Fujian | Mainland China | 2020-03-02T12:53:02 | 296 | 1 | 255 | 26.0789 | 117.9874 |
| 28 | 28 | Guizhou | Mainland China | 2020-03-02T01:13:06 | 146 | 2 | 114 | 26.8154 | 106.8748 |
| 134 | 134 | Sarasota, FL | US | 2020-03-02T03:23:06 | 1 | 0 | 0 | 27.3364 | -82.5307 |
| 8 | 8 | Hunan | Mainland China | 2020-03-02T11:43:03 | 1018 | 4 | 887 | 27.6104 | 111.7088 |
| 10 | 10 | Jiangxi | Mainland China | 2020-03-02T01:33:02 | 935 | 1 | 850 | 27.614 | 115.7221 |
| 125 | 125 | Hillsborough, FL | US | 2020-03-02T03:13:25 | 1 | 0 | 0 | 27.9904 | -82.3018 |
| 80 | 80 | Algeria | 2020-03-02T00:53:03 | 3 | 0 | 0 | 28.0339 | 1.6596 | |
| 116 | 116 | Nepal | 2020-02-12T14:43:03 | 1 | 0 | 1 | 28.1667 | 84.25 | |
| 7 | 7 | Zhejiang | Mainland China | 2020-03-02T11:43:03 | 1206 | 1 | 1069 | 29.1832 | 120.0934 |
| 139 | 139 | Lackland, TX (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 29.3829 | -98.6134 |
| 132 | 132 | San Antonio, TX | US | 2020-02-13T18:53:02 | 1 | 0 | 0 | 29.4241 | -98.4936 |
| 40 | 40 | Kuwait | 2020-03-02T20:33:02 | 56 | 0 | 0 | 29.5 | 47.75 | |
| 14 | 14 | Chongqing | Mainland China | 2020-03-02T23:23:02 | 576 | 6 | 469 | 30.0572 | 107.874 |
| 77 | 77 | Pakistan | 2020-02-29T18:03:05 | 4 | 0 | 0 | 30.3753 | 69.3451 | |
| 15 | 15 | Sichuan | Mainland China | 2020-03-02T15:03:23 | 538 | 3 | 386 | 30.6171 | 102.7103 |
| 1 | 1 | Hubei | Mainland China | 2020-03-02T15:03:23 | 67103 | 2803 | 33934 | 30.9756 | 112.2707 |
| 59 | 59 | Israel | 2020-03-01T23:23:02 | 12 | 0 | 0 | 31.0 | 35.0 | |
| 18 | 18 | Shanghai | Mainland China | 2020-03-02T04:03:13 | 337 | 3 | 292 | 31.202 | 121.4491 |
| 113 | 113 | Tibet | Mainland China | 2020-02-12T06:43:02 | 1 | 0 | 1 | 31.6927 | 88.0924 |
| 115 | 115 | Morocco | 2020-03-02T22:33:09 | 1 | 0 | 0 | 31.7917 | -7.0926 | |
| 9 | 9 | Anhui | Mainland China | 2020-03-02T15:03:23 | 990 | 6 | 917 | 31.8257 | 117.2264 |
| 4 | 4 | Iran | 2020-03-02T20:23:16 | 1501 | 66 | 291 | 32.0 | 53.0 | |
| 98 | 98 | San Diego County, CA | US | 2020-02-21T05:43:02 | 2 | 0 | 1 | 32.7157 | -117.1611 |
| 13 | 13 | Jiangsu | Mainland China | 2020-03-02T12:53:02 | 631 | 0 | 543 | 32.9711 | 119.455 |
| 48 | 48 | Iraq | 2020-03-02T20:53:02 | 26 | 0 | 0 | 33.0 | 44.0 | |
| 99 | 99 | Afghanistan | 2020-02-24T23:33:02 | 1 | 0 | 0 | 33.0 | 65.0 | |
| 136 | 136 | Tempe, AZ | US | 2020-02-25T21:23:03 | 1 | 0 | 1 | 33.4255 | -111.94 |
| 130 | 130 | Orange, CA | US | 2020-02-01T19:53:03 | 1 | 0 | 0 | 33.7879 | -117.8531 |
| 58 | 58 | Lebanon | 2020-03-02T20:53:02 | 13 | 0 | 0 | 33.8547 | 35.8623 | |
| 6 | 6 | Henan | Mainland China | 2020-03-02T11:43:03 | 1272 | 22 | 1205 | 33.882 | 113.614 |
| 127 | 127 | Los Angeles, CA | US | 2020-02-01T19:53:03 | 1 | 0 | 0 | 34.0522 | -118.2437 |
| 23 | 23 | Shaanxi | Mainland China | 2020-03-02T08:03:12 | 245 | 1 | 216 | 35.1917 | 108.8701 |
| 12 | 12 | Diamond Princess cruise ship | Others | 2020-03-02T14:33:03 | 705 | 6 | 10 | 35.4437 | 139.638 |
| 42 | 42 | Unassigned Location (From Diamond Princess) | US | 2020-03-02T19:53:03 | 45 | 0 | 0 | 35.4437 | 139.638 |
| 138 | 138 | From Diamond Princess | Australia | 2020-02-29T02:03:10 | 0 | 0 | 0 | 35.4437 | 139.638 |
| 52 | 52 | Qinghai | Mainland China | 2020-02-21T04:43:02 | 18 | 0 | 18 | 35.7452 | 95.9956 |
| 2 | 2 | South Korea | 2020-03-02T20:23:16 | 4335 | 28 | 30 | 36.0 | 128.0 | |
| 21 | 21 | Japan | 2020-03-02T20:33:02 | 274 | 6 | 32 | 36.0 | 138.0 | |
| 36 | 36 | Gansu | Mainland China | 2020-03-02T15:03:23 | 91 | 2 | 85 | 36.0611 | 103.8343 |
| 11 | 11 | Shandong | Mainland China | 2020-03-02T08:03:12 | 758 | 6 | 460 | 36.3427 | 118.1498 |
| 97 | 97 | San Benito, CA | US | 2020-02-03T03:53:02 | 2 | 0 | 0 | 36.5761 | -120.9876 |
| 39 | 39 | Ningxia | Mainland China | 2020-03-02T01:33:02 | 74 | 0 | 69 | 37.2692 | 106.1655 |
| 63 | 63 | Santa Clara, CA | US | 2020-03-02T20:33:02 | 9 | 0 | 1 | 37.3541 | -121.9552 |
| 133 | 133 | San Mateo, CA | US | 2020-03-02T20:43:02 | 1 | 0 | 0 | 37.563 | -122.3255 |
| 30 | 30 | Shanxi | Mainland China | 2020-03-02T23:23:02 | 133 | 0 | 119 | 37.5777 | 112.2922 |
| 19 | 19 | Hebei | Mainland China | 2020-03-02T09:43:05 | 318 | 6 | 296 | 38.0428 | 114.5149 |
| 141 | 141 | Travis, CA (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 38.2721 | -121.9399 |
| 96 | 96 | Sacramento County, CA | US | 2020-02-27T20:33:02 | 2 | 0 | 0 | 38.4747 | -121.3542 |
| 135 | 135 | Sonoma County, CA | US | 2020-03-02T20:53:02 | 1 | 0 | 0 | 38.578 | -122.9888 |
| 68 | 68 | Greece | 2020-03-01T23:23:02 | 7 | 0 | 0 | 39.0742 | 21.8243 | |
| 131 | 131 | Placer County, CA | US | 2020-03-02T23:53:02 | 1 | 0 | 0 | 39.0916 | -120.8039 |
| 29 | 29 | Tianjin | Mainland China | 2020-03-01T12:43:02 | 136 | 3 | 111 | 39.3054 | 117.323 |
| 93 | 93 | Portugal | 2020-03-02T22:43:02 | 2 | 0 | 0 | 39.3999 | -8.2245 | |
| 32 | 32 | Spain | 2020-03-02T14:43:05 | 120 | 0 | 2 | 40.0 | -4.0 | |
| 101 | 101 | Armenia | 2020-03-01T19:53:02 | 1 | 0 | 0 | 40.0691 | 45.0382 | |
| 82 | 82 | Azerbaijan | 2020-03-01T02:43:03 | 3 | 0 | 0 | 40.1431 | 47.5769 | |
| 17 | 17 | Beijing | Mainland China | 2020-03-02T02:13:16 | 414 | 8 | 282 | 40.1824 | 116.4142 |
| 129 | 129 | New York City, NY | US | 2020-03-02T01:53:03 | 1 | 0 | 0 | 40.7128 | -74.006 |
| 126 | 126 | Humboldt County, CA | US | 2020-02-21T05:13:09 | 1 | 0 | 0 | 40.745 | -123.8695 |
| 37 | 37 | Xinjiang | Mainland China | 2020-03-02T15:43:31 | 76 | 3 | 66 | 41.1129 | 85.2401 |
| 140 | 140 | Omaha, NE (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 41.2545 | -95.9758 |
| 31 | 31 | Liaoning | Mainland China | 2020-03-01T12:23:06 | 122 | 1 | 103 | 41.2956 | 122.6085 |
| 119 | 119 | North Macedonia | 2020-02-27T16:23:03 | 1 | 0 | 0 | 41.6086 | 21.7453 | |
| 78 | 78 | Cook County, IL | US | 2020-03-02T20:33:02 | 4 | 0 | 2 | 41.7377 | -87.6976 |
| 95 | 95 | Providence, RI | US | 2020-03-02T03:43:02 | 2 | 0 | 0 | 41.824 | -71.4128 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [03-02-2020] ( [Province/State] TEXT, [Country/Region] TEXT, [Last Update] TEXT, [Confirmed] INTEGER, [Deaths] INTEGER, [Recovered] INTEGER, [Latitude] FLOAT, [Longitude] FLOAT );