03-05-2020
Data source: Big Local News · About: README
173 rows sorted by Last Update
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 |
|---|---|---|---|---|---|---|---|---|---|
| 121 | 121 | San Benito, CA | US | 2020-02-03T03:53:02 | 2 | 0 | 0 | 36.5761 | -120.9876 |
| 148 | 148 | Sri Lanka | 2020-02-08T03:43:03 | 1 | 0 | 1 | 7.0 | 81.0 | |
| 141 | 141 | Tibet | Mainland China | 2020-02-12T06:43:02 | 1 | 0 | 1 | 31.6927 | 88.0924 |
| 103 | 103 | Philippines | 2020-02-12T07:43:02 | 3 | 1 | 1 | 13.0 | 122.0 | |
| 131 | 131 | Cambodia | 2020-02-12T07:43:02 | 1 | 0 | 1 | 11.55 | 104.9167 | |
| 143 | 143 | Nepal | 2020-02-12T14:43:03 | 1 | 0 | 1 | 28.1667 | 84.25 | |
| 132 | 132 | London, ON | Canada | 2020-02-12T18:53:03 | 1 | 0 | 1 | 42.9849 | -81.2453 |
| 161 | 161 | San Antonio, TX | US | 2020-02-13T18:53:02 | 1 | 0 | 0 | 29.4241 | -98.4936 |
| 63 | 63 | Qinghai | Mainland China | 2020-02-21T04:43:02 | 18 | 0 | 18 | 35.7452 | 95.9956 |
| 157 | 157 | Humboldt County, CA | US | 2020-02-21T05:13:09 | 1 | 0 | 0 | 40.745 | -123.8695 |
| 125 | 125 | Afghanistan | 2020-02-24T23:33:02 | 4 | 0 | 0 | 33.0 | 65.0 | |
| 171 | 171 | Lackland, TX (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 29.3829 | -98.6134 |
| 172 | 172 | Omaha, NE (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 41.2545 | -95.9758 |
| 173 | 173 | Travis, CA (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 38.2721 | -121.9399 |
| 69 | 69 | Vietnam | 2020-02-25T08:53:02 | 16 | 0 | 16 | 16.0 | 108.0 | |
| 165 | 165 | Tempe, AZ | US | 2020-02-25T21:23:03 | 1 | 0 | 1 | 33.4255 | -111.94 |
| 145 | 145 | North Macedonia | 2020-02-27T16:23:03 | 1 | 0 | 0 | 41.6086 | 21.7453 | |
| 120 | 120 | Sacramento County, CA | US | 2020-02-27T20:33:02 | 2 | 0 | 0 | 38.4747 | -121.3542 |
| 139 | 139 | Lithuania | 2020-02-28T16:23:03 | 1 | 0 | 0 | 55.1694 | 23.8813 | |
| 144 | 144 | Nigeria | 2020-02-28T16:23:03 | 1 | 0 | 0 | 9.082 | 8.6753 | |
| 152 | 152 | Boston, MA | US | 2020-02-28T21:13:12 | 1 | 0 | 1 | 42.3601 | -71.0589 |
| 142 | 142 | Monaco | 2020-02-29T00:33:01 | 1 | 0 | 0 | 43.7333 | 7.4167 | |
| 170 | 170 | From Diamond Princess | Australia | 2020-02-29T02:03:10 | 0 | 0 | 0 | 35.4437 | 139.638 |
| 128 | 128 | Armenia | 2020-03-01T19:53:02 | 1 | 0 | 0 | 40.0691 | 45.0382 | |
| 29 | 29 | Guizhou | Mainland China | 2020-03-02T01:13:06 | 146 | 2 | 114 | 26.8154 | 106.8748 |
| 163 | 163 | Sarasota, FL | US | 2020-03-02T03:23:06 | 1 | 0 | 0 | 27.3364 | -82.5307 |
| 119 | 119 | Providence, RI | US | 2020-03-02T03:43:02 | 2 | 0 | 0 | 41.824 | -71.4128 |
| 133 | 133 | Dominican Republic | 2020-03-02T16:33:02 | 1 | 0 | 0 | 18.7357 | -70.1627 | |
| 110 | 110 | Indonesia | 2020-03-02T18:03:04 | 2 | 0 | 0 | -0.7893 | 113.9213 | |
| 51 | 51 | Unassigned Location (From Diamond Princess) | US | 2020-03-02T19:53:03 | 45 | 0 | 0 | 35.4437 | 139.638 |
| 126 | 126 | Andorra | 2020-03-02T20:23:16 | 1 | 0 | 0 | 42.5063 | 1.5218 | |
| 166 | 166 | Umatilla, OR | US | 2020-03-02T20:23:16 | 1 | 0 | 0 | 45.775 | -118.7606 |
| 130 | 130 | Tasmania | Australia | 2020-03-02T20:53:02 | 1 | 0 | 0 | -41.4545 | 145.9707 |
| 164 | 164 | Sonoma County, CA | US | 2020-03-02T20:53:02 | 1 | 0 | 0 | 38.578 | -122.9888 |
| 140 | 140 | Luxembourg | 2020-03-03T00:23:16 | 1 | 0 | 0 | 49.8144 | 6.1317 | |
| 123 | 123 | San Mateo, CA | US | 2020-03-03T00:43:02 | 2 | 0 | 0 | 37.563 | -122.3255 |
| 124 | 124 | Washington County, OR | US | 2020-03-03T03:03:02 | 2 | 0 | 0 | 45.547 | -123.1386 |
| 12 | 12 | Diamond Princess cruise ship | Others | 2020-03-03T03:13:06 | 706 | 6 | 10 | 35.4437 | 139.638 |
| 114 | 114 | Fulton County, GA | US | 2020-03-03T03:33:02 | 2 | 0 | 0 | 33.8034 | -84.3963 |
| 27 | 27 | Yunnan | Mainland China | 2020-03-03T03:43:02 | 174 | 2 | 169 | 24.974 | 101.487 |
| 89 | 89 | Pakistan | 2020-03-03T04:33:03 | 5 | 0 | 0 | 30.3753 | 69.3451 | |
| 88 | 88 | Mexico | 2020-03-03T10:03:04 | 5 | 0 | 1 | 23.0 | -102.0 | |
| 80 | 80 | Macau | Macau | 2020-03-03T12:33:02 | 10 | 0 | 9 | 22.1667 | 113.55 |
| 32 | 32 | Liaoning | Mainland China | 2020-03-03T14:33:03 | 125 | 1 | 106 | 41.2956 | 122.6085 |
| 150 | 150 | Norfolk County, MA | US | 2020-03-03T14:33:03 | 1 | 0 | 0 | 42.1767 | -71.1449 |
| 136 | 136 | Jordan | 2020-03-03T15:33:02 | 1 | 0 | 0 | 31.24 | 36.51 | |
| 169 | 169 | Ukraine | 2020-03-03T15:33:02 | 1 | 0 | 0 | 48.3794 | 31.1656 | |
| 158 | 158 | Madison, WI | US | 2020-03-03T15:53:03 | 1 | 0 | 1 | 43.0731 | -89.4012 |
| 159 | 159 | Maricopa County, AZ | US | 2020-03-03T17:33:02 | 1 | 0 | 0 | 33.2918 | -112.4291 |
| 117 | 117 | Hillsborough, FL | US | 2020-03-03T18:33:02 | 2 | 0 | 0 | 27.9904 | -82.3018 |
| 167 | 167 | Wake County, NC | US | 2020-03-03T20:53:02 | 1 | 0 | 0 | 35.8032 | -78.5661 |
| 115 | 115 | Grafton County, NH | US | 2020-03-03T23:33:03 | 2 | 0 | 0 | 43.9088 | -71.826 |
| 151 | 151 | Berkeley, CA | US | 2020-03-03T23:53:03 | 1 | 0 | 0 | 37.8715 | -122.273 |
| 79 | 79 | Denmark | 2020-03-04T00:03:15 | 10 | 0 | 0 | 56.2639 | 9.5018 | |
| 82 | 82 | Qatar | 2020-03-04T00:03:15 | 8 | 0 | 0 | 25.3548 | 51.1839 | |
| 44 | 44 | Ningxia | Mainland China | 2020-03-04T01:33:07 | 75 | 0 | 69 | 37.2692 | 106.1655 |
| 127 | 127 | Argentina | 2020-03-04T01:33:07 | 1 | 0 | 0 | -38.4161 | -63.6167 | |
| 137 | 137 | Latvia | 2020-03-04T01:33:07 | 1 | 0 | 0 | 56.8796 | 24.6032 | |
| 138 | 138 | Liechtenstein | 2020-03-04T01:33:07 | 1 | 0 | 0 | 47.14 | 9.55 | |
| 149 | 149 | Tunisia | 2020-03-04T01:33:07 | 1 | 0 | 0 | 34.0 | 9.0 | |
| 105 | 105 | Orange County, CA | US | 2020-03-04T02:13:11 | 3 | 0 | 0 | 33.7879 | -117.8531 |
| 104 | 104 | Saint Barthelemy | 2020-03-04T02:43:03 | 3 | 0 | 0 | 17.9 | -62.8333 | |
| 154 | 154 | Contra Costa County, CA | US | 2020-03-04T04:23:05 | 1 | 0 | 0 | 37.8534 | -121.9018 |
| 84 | 84 | Belarus | 2020-03-04T12:43:03 | 6 | 0 | 0 | 53.7098 | 27.9534 | |
| 134 | 134 | Faroe Islands | 2020-03-04T12:53:03 | 1 | 0 | 0 | 61.8926 | -6.9118 | |
| 49 | 49 | Malaysia | 2020-03-04T13:03:08 | 50 | 0 | 22 | 2.5 | 112.5 | |
| 135 | 135 | Gibraltar | 2020-03-04T13:03:13 | 1 | 0 | 0 | 36.1408 | -5.3536 | |
| 146 | 146 | Poland | 2020-03-04T15:13:18 | 1 | 0 | 0 | 51.9194 | 19.1451 | |
| 78 | 78 | Croatia | 2020-03-04T16:53:02 | 10 | 0 | 0 | 45.1667 | 15.5 | |
| 73 | 73 | Algeria | 2020-03-04T19:33:03 | 12 | 0 | 0 | 28.0339 | 1.6596 | |
| 129 | 129 | Northern Territory | Australia | 2020-03-04T19:43:02 | 1 | 0 | 0 | -12.4634 | 130.8456 |
| 118 | 118 | Placer County, CA | US | 2020-03-04T19:53:02 | 2 | 1 | 0 | 39.0916 | -120.8039 |
| 102 | 102 | New Zealand | 2020-03-04T20:13:11 | 3 | 0 | 0 | -40.9006 | 174.886 | |
| 92 | 92 | Brazil | 2020-03-04T20:33:02 | 4 | 0 | 0 | -14.235 | -51.9253 | |
| 54 | 54 | Iraq | 2020-03-04T20:43:02 | 35 | 2 | 0 | 33.0 | 44.0 | |
| 97 | 97 | Senegal | 2020-03-04T20:43:02 | 4 | 0 | 0 | 14.4974 | -14.4524 | |
| 59 | 59 | New South Wales | Australia | 2020-03-04T20:43:03 | 22 | 1 | 4 | -33.8688 | 151.2093 |
| 87 | 87 | South Australia | Australia | 2020-03-04T21:03:07 | 5 | 0 | 2 | -34.9285 | 138.6007 |
| 85 | 85 | Ireland | 2020-03-04T21:13:07 | 6 | 0 | 0 | 53.1424 | -7.6921 | |
| 18 | 18 | Beijing | Mainland China | 2020-03-04T23:23:01 | 418 | 8 | 297 | 40.1824 | 116.4142 |
| 17 | 17 | Heilongjiang | Mainland China | 2020-03-05T00:23:06 | 481 | 13 | 379 | 47.862 | 127.7615 |
| 36 | 36 | Hong Kong | Hong Kong | 2020-03-05T00:23:07 | 105 | 2 | 43 | 22.3 | 114.2 |
| 10 | 10 | Jiangxi | Mainland China | 2020-03-05T01:16:58 | 935 | 1 | 901 | 27.614 | 115.7221 |
| 155 | 155 | Fort Bend County, TX | US | 2020-03-05T01:16:59 | 1 | 0 | 0 | 29.5693 | -95.8143 |
| 6 | 6 | Henan | Mainland China | 2020-03-05T01:48:26 | 1272 | 22 | 1239 | 33.882 | 113.614 |
| 30 | 30 | Tianjin | Mainland China | 2020-03-05T03:33:27 | 136 | 3 | 128 | 39.3054 | 117.323 |
| 9 | 9 | Anhui | Mainland China | 2020-03-05T04:33:02 | 990 | 6 | 970 | 31.8257 | 117.2264 |
| 71 | 71 | British Columbia | Canada | 2020-03-05T04:43:03 | 13 | 0 | 3 | 49.2827 | -123.1207 |
| 26 | 26 | Shaanxi | Mainland China | 2020-03-05T06:03:08 | 245 | 1 | 224 | 35.1917 | 108.8701 |
| 42 | 42 | Xinjiang | Mainland China | 2020-03-05T06:03:08 | 76 | 3 | 70 | 41.1129 | 85.2401 |
| 28 | 28 | Hainan | Mainland China | 2020-03-05T06:13:10 | 168 | 6 | 158 | 19.1959 | 109.7453 |
| 21 | 21 | Shanghai | Mainland China | 2020-03-05T06:23:06 | 339 | 3 | 303 | 31.202 | 121.4491 |
| 50 | 50 | Thailand | 2020-03-05T06:23:06 | 47 | 1 | 31 | 15.0 | 101.0 | |
| 86 | 86 | Romania | 2020-03-05T06:23:06 | 6 | 0 | 1 | 46.0 | 25.0 | |
| 8 | 8 | Hunan | Mainland China | 2020-03-05T08:43:03 | 1018 | 4 | 938 | 27.6104 | 111.7088 |
| 2 | 2 | South Korea | 2020-03-05T09:03:09 | 6088 | 35 | 41 | 36.0 | 128.0 | |
| 5 | 5 | Guangdong | Mainland China | 2020-03-05T09:23:03 | 1351 | 7 | 1181 | 23.3417 | 113.4244 |
| 23 | 23 | Fujian | Mainland China | 2020-03-05T09:33:03 | 296 | 1 | 277 | 26.0789 | 117.9874 |
| 7 | 7 | Zhejiang | Mainland China | 2020-03-05T09:43:03 | 1215 | 1 | 1124 | 29.1832 | 120.0934 |
| 25 | 25 | Guangxi | Mainland China | 2020-03-05T10:03:08 | 252 | 2 | 214 | 23.8298 | 108.7881 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [03-05-2020] ( [Province/State] TEXT, [Country/Region] TEXT, [Last Update] TEXT, [Confirmed] INTEGER, [Deaths] INTEGER, [Recovered] INTEGER, [Latitude] FLOAT, [Longitude] FLOAT );