03-02-2020
Data source: Big Local News · About: README
141 rows sorted by Longitude
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 ▼ |
|---|---|---|---|---|---|---|---|---|---|
| 126 | 126 | Humboldt County, CA | US | 2020-02-21T05:13:09 | 1 | 0 | 0 | 40.745 | -123.8695 |
| 65 | 65 | British Columbia | Canada | 2020-02-29T23:23:13 | 8 | 0 | 3 | 49.2827 | -123.1207 |
| 135 | 135 | Sonoma County, CA | US | 2020-03-02T20:53:02 | 1 | 0 | 0 | 38.578 | -122.9888 |
| 94 | 94 | Portland, OR | US | 2020-03-02T03:33:08 | 2 | 0 | 0 | 45.5051 | -122.675 |
| 133 | 133 | San Mateo, CA | US | 2020-03-02T20:43:02 | 1 | 0 | 0 | 37.563 | -122.3255 |
| 57 | 57 | King County, WA | US | 2020-03-02T20:23:16 | 14 | 5 | 1 | 47.548 | -121.9836 |
| 63 | 63 | Santa Clara, CA | US | 2020-03-02T20:33:02 | 9 | 0 | 1 | 37.3541 | -121.9552 |
| 141 | 141 | Travis, CA (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 38.2721 | -121.9399 |
| 79 | 79 | Snohomish County, WA | US | 2020-03-02T20:53:02 | 4 | 1 | 0 | 48.033 | -121.8339 |
| 96 | 96 | Sacramento County, CA | US | 2020-02-27T20:33:02 | 2 | 0 | 0 | 38.4747 | -121.3542 |
| 97 | 97 | San Benito, CA | US | 2020-02-03T03:53:02 | 2 | 0 | 0 | 36.5761 | -120.9876 |
| 131 | 131 | Placer County, CA | US | 2020-03-02T23:53:02 | 1 | 0 | 0 | 39.0916 | -120.8039 |
| 137 | 137 | Umatilla, OR | US | 2020-03-02T20:23:16 | 1 | 0 | 0 | 45.775 | -118.7606 |
| 127 | 127 | Los Angeles, CA | US | 2020-02-01T19:53:03 | 1 | 0 | 0 | 34.0522 | -118.2437 |
| 130 | 130 | Orange, CA | US | 2020-02-01T19:53:03 | 1 | 0 | 0 | 33.7879 | -117.8531 |
| 98 | 98 | San Diego County, CA | US | 2020-02-21T05:43:02 | 2 | 0 | 1 | 32.7157 | -117.1611 |
| 136 | 136 | Tempe, AZ | US | 2020-02-25T21:23:03 | 1 | 0 | 1 | 33.4255 | -111.94 |
| 75 | 75 | Mexico | 2020-03-01T23:33:03 | 5 | 0 | 0 | 23.0 | -102.0 | |
| 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 |
| 140 | 140 | Omaha, NE (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 41.2545 | -95.9758 |
| 128 | 128 | Madison, WI | US | 2020-02-05T21:53:02 | 1 | 0 | 0 | 43.0731 | -89.4012 |
| 78 | 78 | Cook County, IL | US | 2020-03-02T20:33:02 | 4 | 0 | 2 | 41.7377 | -87.6976 |
| 134 | 134 | Sarasota, FL | US | 2020-03-02T03:23:06 | 1 | 0 | 0 | 27.3364 | -82.5307 |
| 125 | 125 | Hillsborough, FL | US | 2020-03-02T03:13:25 | 1 | 0 | 0 | 27.9904 | -82.3018 |
| 106 | 106 | London, ON | Canada | 2020-02-12T18:53:03 | 1 | 0 | 1 | 42.9849 | -81.2453 |
| 54 | 54 | Toronto, ON | Canada | 2020-03-02T20:53:02 | 17 | 0 | 2 | 43.6532 | -79.3832 |
| 70 | 70 | Ecuador | 2020-03-01T23:33:03 | 6 | 0 | 0 | -1.8312 | -78.1834 | |
| 129 | 129 | New York City, NY | US | 2020-03-02T01:53:03 | 1 | 0 | 0 | 40.7128 | -74.006 |
| 105 | 105 | Montreal, QC | Canada | 2020-02-28T05:23:07 | 1 | 0 | 0 | 45.5017 | -73.5673 |
| 124 | 124 | Grafton County, NH | US | 2020-03-02T20:33:02 | 1 | 0 | 0 | 43.9088 | -71.826 |
| 95 | 95 | Providence, RI | US | 2020-03-02T03:43:02 | 2 | 0 | 0 | 41.824 | -71.4128 |
| 123 | 123 | Boston, MA | US | 2020-02-28T21:13:12 | 1 | 0 | 1 | 42.3601 | -71.0589 |
| 107 | 107 | Dominican Republic | 2020-03-02T16:33:02 | 1 | 0 | 0 | 18.7357 | -70.1627 | |
| 90 | 90 | Brazil | 2020-02-29T21:03:05 | 2 | 0 | 0 | -14.235 | -51.9253 | |
| 72 | 72 | Iceland | 2020-03-02T22:33:09 | 6 | 0 | 0 | 64.9631 | -19.0208 | |
| 121 | 121 | Senegal | 2020-03-02T20:23:16 | 1 | 0 | 0 | 14.4974 | -14.4524 | |
| 93 | 93 | Portugal | 2020-03-02T22:43:02 | 2 | 0 | 0 | 39.3999 | -8.2245 | |
| 109 | 109 | Ireland | 2020-03-01T07:13:07 | 1 | 0 | 0 | 53.1424 | -7.6921 | |
| 115 | 115 | Morocco | 2020-03-02T22:33:09 | 1 | 0 | 0 | 31.7917 | -7.0926 | |
| 32 | 32 | Spain | 2020-03-02T14:43:05 | 120 | 0 | 2 | 40.0 | -4.0 | |
| 46 | 46 | UK | 2020-03-02T20:33:02 | 40 | 0 | 8 | 55.0 | -3.0 | |
| 100 | 100 | Andorra | 2020-03-02T20:23:16 | 1 | 0 | 0 | 42.5063 | 1.5218 | |
| 80 | 80 | Algeria | 2020-03-02T00:53:03 | 3 | 0 | 0 | 28.0339 | 1.6596 | |
| 24 | 24 | France | 2020-03-02T20:33:02 | 191 | 3 | 12 | 47.0 | 2.0 | |
| 64 | 64 | Belgium | 2020-03-02T20:53:02 | 8 | 0 | 1 | 50.8333 | 4.0 | |
| 53 | 53 | Netherlands | 2020-03-02T20:53:02 | 18 | 0 | 0 | 52.1326 | 5.2913 | |
| 112 | 112 | Luxembourg | 2020-03-01T07:13:07 | 1 | 0 | 0 | 49.8153 | 6.1296 | |
| 114 | 114 | Monaco | 2020-02-29T00:33:01 | 1 | 0 | 0 | 43.7333 | 7.4167 | |
| 44 | 44 | Switzerland | 2020-03-02T22:33:09 | 42 | 0 | 0 | 46.8182 | 8.2275 | |
| 49 | 49 | Norway | 2020-03-02T20:53:02 | 25 | 0 | 0 | 60.472 | 8.4689 | |
| 118 | 118 | Nigeria | 2020-02-28T16:23:03 | 1 | 0 | 0 | 9.082 | 8.6753 | |
| 27 | 27 | Germany | 2020-03-02T20:33:02 | 159 | 0 | 16 | 51.0 | 9.0 | |
| 76 | 76 | Denmark | 2020-03-01T23:33:03 | 4 | 0 | 0 | 56.2639 | 9.5018 | |
| 3 | 3 | Italy | 2020-03-02T20:23:16 | 2036 | 52 | 149 | 43.0 | 12.0 | |
| 66 | 66 | San Marino | 2020-03-02T01:03:12 | 8 | 0 | 0 | 43.9424 | 12.4578 | |
| 51 | 51 | Austria | 2020-03-02T21:23:04 | 18 | 0 | 0 | 47.5162 | 14.5501 | |
| 67 | 67 | Croatia | 2020-03-01T23:33:03 | 7 | 0 | 0 | 45.1 | 15.2 | |
| 83 | 83 | Czech Republic | 2020-03-02T16:33:02 | 3 | 0 | 0 | 49.8175 | 15.473 | |
| 56 | 56 | Sweden | 2020-03-02T20:53:02 | 15 | 0 | 0 | 63.0 | 16.0 | |
| 119 | 119 | North Macedonia | 2020-02-27T16:23:03 | 1 | 0 | 0 | 41.6086 | 21.7453 | |
| 68 | 68 | Greece | 2020-03-01T23:23:02 | 7 | 0 | 0 | 39.0742 | 21.8243 | |
| 111 | 111 | Lithuania | 2020-02-28T16:23:03 | 1 | 0 | 0 | 55.1694 | 23.8813 | |
| 110 | 110 | Latvia | 2020-03-02T20:13:49 | 1 | 0 | 0 | 56.8796 | 24.6032 | |
| 87 | 87 | Romania | 2020-02-28T15:33:03 | 3 | 0 | 0 | 45.9432 | 24.9668 | |
| 108 | 108 | Estonia | 2020-02-27T16:23:03 | 1 | 0 | 0 | 58.5953 | 25.0136 | |
| 71 | 71 | Finland | 2020-03-01T23:23:02 | 6 | 0 | 1 | 64.0 | 26.0 | |
| 103 | 103 | Belarus | 2020-02-28T16:23:03 | 1 | 0 | 0 | 53.7098 | 27.9534 | |
| 91 | 91 | Egypt | 2020-03-01T23:33:03 | 2 | 0 | 1 | 26.0 | 30.0 | |
| 59 | 59 | Israel | 2020-03-01T23:23:02 | 12 | 0 | 0 | 31.0 | 35.0 | |
| 58 | 58 | Lebanon | 2020-03-02T20:53:02 | 13 | 0 | 0 | 33.8547 | 35.8623 | |
| 84 | 84 | Georgia | 2020-03-01T15:43:03 | 3 | 0 | 0 | 42.3154 | 43.3569 | |
| 48 | 48 | Iraq | 2020-03-02T20:53:02 | 26 | 0 | 0 | 33.0 | 44.0 | |
| 120 | 120 | Saudi Arabia | 2020-03-02T23:53:02 | 1 | 0 | 0 | 24.0 | 45.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 | |
| 40 | 40 | Kuwait | 2020-03-02T20:33:02 | 56 | 0 | 0 | 29.5 | 47.75 | |
| 41 | 41 | Bahrain | 2020-03-02T20:33:02 | 49 | 0 | 0 | 26.0275 | 50.55 | |
| 86 | 86 | Qatar | 2020-03-01T23:33:03 | 3 | 0 | 0 | 25.3548 | 51.1839 | |
| 4 | 4 | Iran | 2020-03-02T20:23:16 | 1501 | 66 | 291 | 32.0 | 53.0 | |
| 50 | 50 | United Arab Emirates | 2020-02-29T12:33:03 | 21 | 0 | 5 | 24.0 | 54.0 | |
| 73 | 73 | Oman | 2020-02-29T12:33:03 | 6 | 0 | 1 | 21.0 | 57.0 | |
| 99 | 99 | Afghanistan | 2020-02-24T23:33:02 | 1 | 0 | 0 | 33.0 | 65.0 | |
| 77 | 77 | Pakistan | 2020-02-29T18:03:05 | 4 | 0 | 0 | 30.3753 | 69.3451 | |
| 74 | 74 | India | 2020-03-02T22:33:09 | 5 | 0 | 3 | 21.0 | 78.0 | |
| 122 | 122 | Sri Lanka | 2020-02-08T03:43:03 | 1 | 0 | 1 | 7.0 | 81.0 | |
| 116 | 116 | Nepal | 2020-02-12T14:43:03 | 1 | 0 | 1 | 28.1667 | 84.25 | |
| 37 | 37 | Xinjiang | Mainland China | 2020-03-02T15:43:31 | 76 | 3 | 66 | 41.1129 | 85.2401 |
| 113 | 113 | Tibet | Mainland China | 2020-02-12T06:43:02 | 1 | 0 | 1 | 31.6927 | 88.0924 |
| 88 | 88 | Russia | 2020-03-02T21:23:04 | 3 | 0 | 2 | 60.0 | 90.0 | |
| 52 | 52 | Qinghai | Mainland China | 2020-02-21T04:43:02 | 18 | 0 | 18 | 35.7452 | 95.9956 |
| 43 | 43 | Thailand | 2020-03-02T06:23:04 | 43 | 1 | 31 | 15.0 | 101.0 | |
| 25 | 25 | Yunnan | Mainland China | 2020-03-02T06:23:04 | 174 | 2 | 168 | 24.974 | 101.487 |
| 15 | 15 | Sichuan | Mainland China | 2020-03-02T15:03:23 | 538 | 3 | 386 | 30.6171 | 102.7103 |
| 33 | 33 | Singapore | 2020-03-02T20:33:02 | 108 | 0 | 78 | 1.2833 | 103.8333 | |
| 36 | 36 | Gansu | Mainland China | 2020-03-02T15:03:23 | 91 | 2 | 85 | 36.0611 | 103.8343 |
| 104 | 104 | Cambodia | 2020-02-12T07:43:02 | 1 | 0 | 1 | 11.55 | 104.9167 | |
| 39 | 39 | Ningxia | Mainland China | 2020-03-02T01:33:02 | 74 | 0 | 69 | 37.2692 | 106.1655 |
| 28 | 28 | Guizhou | Mainland China | 2020-03-02T01:13:06 | 146 | 2 | 114 | 26.8154 | 106.8748 |
| 14 | 14 | Chongqing | Mainland China | 2020-03-02T23:23:02 | 576 | 6 | 469 | 30.0572 | 107.874 |
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 );