03-05-2020
Data source: Big Local News · About: README
173 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 ▼ |
---|---|---|---|---|---|---|---|---|---|
157 | 157 | Humboldt County, CA | US | 2020-02-21T05:13:09 | 1 | 0 | 0 | 40.745 | -123.8695 |
124 | 124 | Washington County, OR | US | 2020-03-03T03:03:02 | 2 | 0 | 0 | 45.547 | -123.1386 |
71 | 71 | British Columbia | Canada | 2020-03-05T04:43:03 | 13 | 0 | 3 | 49.2827 | -123.1207 |
164 | 164 | Sonoma County, CA | US | 2020-03-02T20:53:02 | 1 | 0 | 0 | 38.578 | -122.9888 |
122 | 122 | San Francisco County, CA | US | 2020-03-05T20:33:03 | 2 | 0 | 0 | 37.7749 | -122.4194 |
123 | 123 | San Mateo, CA | US | 2020-03-03T00:43:02 | 2 | 0 | 0 | 37.563 | -122.3255 |
151 | 151 | Berkeley, CA | US | 2020-03-03T23:53:03 | 1 | 0 | 0 | 37.8715 | -122.273 |
47 | 47 | King County, WA | US | 2020-03-05T22:03:17 | 51 | 10 | 1 | 47.548 | -121.9836 |
62 | 62 | Santa Clara, CA | US | 2020-03-05T22:53:03 | 20 | 0 | 1 | 37.3541 | -121.9552 |
173 | 173 | Travis, CA (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 38.2721 | -121.9399 |
154 | 154 | Contra Costa County, CA | US | 2020-03-04T04:23:05 | 1 | 0 | 0 | 37.8534 | -121.9018 |
64 | 64 | Snohomish County, WA | US | 2020-03-05T20:23:07 | 18 | 1 | 0 | 48.033 | -121.8339 |
120 | 120 | Sacramento County, CA | US | 2020-02-27T20:33:02 | 2 | 0 | 0 | 38.4747 | -121.3542 |
121 | 121 | San Benito, CA | US | 2020-02-03T03:53:02 | 2 | 0 | 0 | 36.5761 | -120.9876 |
118 | 118 | Placer County, CA | US | 2020-03-04T19:53:02 | 2 | 1 | 0 | 39.0916 | -120.8039 |
156 | 156 | Grant County, WA | US | 2020-03-05T20:23:07 | 1 | 0 | 0 | 47.1981 | -119.3732 |
166 | 166 | Umatilla, OR | US | 2020-03-02T20:23:16 | 1 | 0 | 0 | 45.775 | -118.7606 |
76 | 76 | Los Angeles, CA | US | 2020-03-05T21:03:14 | 11 | 0 | 0 | 34.0522 | -118.2437 |
105 | 105 | Orange County, CA | US | 2020-03-04T02:13:11 | 3 | 0 | 0 | 33.7879 | -117.8531 |
106 | 106 | San Diego County, CA | US | 2020-03-05T20:33:03 | 3 | 0 | 1 | 32.7157 | -117.1611 |
153 | 153 | Clark County, NV | US | 2020-03-05T20:53:03 | 1 | 0 | 0 | 36.0796 | -115.094 |
159 | 159 | Maricopa County, AZ | US | 2020-03-03T17:33:02 | 1 | 0 | 0 | 33.2918 | -112.4291 |
165 | 165 | Tempe, AZ | US | 2020-02-25T21:23:03 | 1 | 0 | 1 | 33.4255 | -111.94 |
88 | 88 | Mexico | 2020-03-03T10:03:04 | 5 | 0 | 1 | 23.0 | -102.0 | |
171 | 171 | Lackland, TX (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 29.3829 | -98.6134 |
161 | 161 | San Antonio, TX | US | 2020-02-13T18:53:02 | 1 | 0 | 0 | 29.4241 | -98.4936 |
172 | 172 | Omaha, NE (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 41.2545 | -95.9758 |
155 | 155 | Fort Bend County, TX | US | 2020-03-05T01:16:59 | 1 | 0 | 0 | 29.5693 | -95.8143 |
116 | 116 | Harris County, TX | US | 2020-03-05T21:53:02 | 2 | 0 | 0 | 29.7752 | -95.3103 |
158 | 158 | Madison, WI | US | 2020-03-03T15:53:03 | 1 | 0 | 1 | 43.0731 | -89.4012 |
91 | 91 | Cook County, IL | US | 2020-03-05T18:33:03 | 5 | 0 | 2 | 41.7377 | -87.6976 |
162 | 162 | Santa Rosa County, FL | US | 2020-03-05T20:03:03 | 1 | 0 | 0 | 30.769 | -86.9824 |
168 | 168 | Williamson County, TN | US | 2020-03-05T23:33:03 | 1 | 0 | 0 | 35.9179 | -86.8622 |
114 | 114 | Fulton County, GA | US | 2020-03-03T03:33:02 | 2 | 0 | 0 | 33.8034 | -84.3963 |
163 | 163 | Sarasota, FL | US | 2020-03-02T03:23:06 | 1 | 0 | 0 | 27.3364 | -82.5307 |
117 | 117 | Hillsborough, FL | US | 2020-03-03T18:33:02 | 2 | 0 | 0 | 27.9904 | -82.3018 |
132 | 132 | London, ON | Canada | 2020-02-12T18:53:03 | 1 | 0 | 1 | 42.9849 | -81.2453 |
60 | 60 | Toronto, ON | Canada | 2020-03-05T17:53:03 | 21 | 0 | 2 | 43.6532 | -79.3832 |
167 | 167 | Wake County, NC | US | 2020-03-03T20:53:02 | 1 | 0 | 0 | 35.8032 | -78.5661 |
72 | 72 | Ecuador | 2020-03-05T17:53:02 | 13 | 0 | 0 | -1.8312 | -78.1834 | |
113 | 113 | Bergen County, NJ | US | 2020-03-05T21:03:12 | 2 | 0 | 0 | 40.9263 | -74.077 |
98 | 98 | New York City, NY | US | 2020-03-05T21:03:13 | 4 | 0 | 0 | 40.7128 | -74.006 |
65 | 65 | Westchester County, NY | US | 2020-03-05T21:33:03 | 18 | 0 | 0 | 41.122 | -73.7949 |
160 | 160 | Queens County, NY | US | 2020-03-05T21:43:02 | 1 | 0 | 0 | 40.7282 | -73.7949 |
108 | 108 | Montreal, QC | Canada | 2020-03-05T14:03:04 | 2 | 0 | 0 | 45.5017 | -73.5673 |
115 | 115 | Grafton County, NH | US | 2020-03-03T23:33:03 | 2 | 0 | 0 | 43.9088 | -71.826 |
93 | 93 | Chile | 2020-03-05T18:13:04 | 4 | 0 | 0 | -35.6751 | -71.543 | |
119 | 119 | Providence, RI | US | 2020-03-02T03:43:02 | 2 | 0 | 0 | 41.824 | -71.4128 |
150 | 150 | Norfolk County, MA | US | 2020-03-03T14:33:03 | 1 | 0 | 0 | 42.1767 | -71.1449 |
152 | 152 | Boston, MA | US | 2020-02-28T21:13:12 | 1 | 0 | 1 | 42.3601 | -71.0589 |
133 | 133 | Dominican Republic | 2020-03-02T16:33:02 | 1 | 0 | 0 | 18.7357 | -70.1627 | |
127 | 127 | Argentina | 2020-03-04T01:33:07 | 1 | 0 | 0 | -38.4161 | -63.6167 | |
104 | 104 | Saint Barthelemy | 2020-03-04T02:43:03 | 3 | 0 | 0 | 17.9 | -62.8333 | |
92 | 92 | Brazil | 2020-03-04T20:33:02 | 4 | 0 | 0 | -14.235 | -51.9253 | |
55 | 55 | Iceland | 2020-03-05T13:53:03 | 34 | 0 | 0 | 64.9631 | -19.0208 | |
97 | 97 | Senegal | 2020-03-04T20:43:02 | 4 | 0 | 0 | 14.4974 | -14.4524 | |
81 | 81 | Portugal | 2020-03-05T13:53:03 | 8 | 0 | 0 | 39.3999 | -8.2245 | |
85 | 85 | Ireland | 2020-03-04T21:13:07 | 6 | 0 | 0 | 53.1424 | -7.6921 | |
111 | 111 | Morocco | 2020-03-05T13:53:03 | 2 | 0 | 0 | 31.7917 | -7.0926 | |
134 | 134 | Faroe Islands | 2020-03-04T12:53:03 | 1 | 0 | 0 | 61.8926 | -6.9118 | |
135 | 135 | Gibraltar | 2020-03-04T13:03:13 | 1 | 0 | 0 | 36.1408 | -5.3536 | |
24 | 24 | Spain | 2020-03-05T17:43:03 | 259 | 3 | 2 | 40.0 | -4.0 | |
34 | 34 | UK | 2020-03-05T18:03:03 | 115 | 1 | 8 | 55.0 | -3.0 | |
126 | 126 | Andorra | 2020-03-02T20:23:16 | 1 | 0 | 0 | 42.5063 | 1.5218 | |
73 | 73 | Algeria | 2020-03-04T19:33:03 | 12 | 0 | 0 | 28.0339 | 1.6596 | |
19 | 19 | France | 2020-03-05T15:13:22 | 423 | 7 | 12 | 47.0 | 2.0 | |
48 | 48 | Belgium | 2020-03-05T13:53:03 | 50 | 0 | 1 | 50.8333 | 4.0 | |
41 | 41 | Netherlands | 2020-03-05T14:23:03 | 82 | 0 | 0 | 52.1326 | 5.2913 | |
140 | 140 | Luxembourg | 2020-03-03T00:23:16 | 1 | 0 | 0 | 49.8144 | 6.1317 | |
142 | 142 | Monaco | 2020-02-29T00:33:01 | 1 | 0 | 0 | 43.7333 | 7.4167 | |
35 | 35 | Switzerland | 2020-03-05T17:43:03 | 114 | 1 | 3 | 46.8182 | 8.2275 | |
40 | 40 | Norway | 2020-03-05T17:43:03 | 87 | 0 | 0 | 60.472 | 8.4689 | |
144 | 144 | Nigeria | 2020-02-28T16:23:03 | 1 | 0 | 0 | 9.082 | 8.6753 | |
16 | 16 | Germany | 2020-03-05T17:43:03 | 482 | 0 | 16 | 51.0 | 9.0 | |
149 | 149 | Tunisia | 2020-03-04T01:33:07 | 1 | 0 | 0 | 34.0 | 9.0 | |
79 | 79 | Denmark | 2020-03-04T00:03:15 | 10 | 0 | 0 | 56.2639 | 9.5018 | |
138 | 138 | Liechtenstein | 2020-03-04T01:33:07 | 1 | 0 | 0 | 47.14 | 9.55 | |
3 | 3 | Italy | 2020-03-05T17:43:03 | 3858 | 148 | 414 | 43.0 | 12.0 | |
61 | 61 | San Marino | 2020-03-05T13:53:03 | 21 | 1 | 0 | 43.9424 | 12.4578 | |
53 | 53 | Austria | 2020-03-05T17:53:02 | 41 | 0 | 0 | 47.5162 | 14.5501 | |
112 | 112 | Slovenia | 2020-03-05T17:13:30 | 2 | 0 | 0 | 46.1512 | 14.9955 | |
74 | 74 | Czech Republic | 2020-03-05T17:53:02 | 12 | 0 | 0 | 49.8175 | 15.473 | |
78 | 78 | Croatia | 2020-03-04T16:53:02 | 10 | 0 | 0 | 45.1667 | 15.5 | |
38 | 38 | Sweden | 2020-03-05T18:03:03 | 94 | 0 | 0 | 63.0 | 16.0 | |
107 | 107 | Bosnia and Herzegovina | 2020-03-05T17:13:30 | 2 | 0 | 0 | 43.9159 | 17.6791 | |
146 | 146 | Poland | 2020-03-04T15:13:18 | 1 | 0 | 0 | 51.9194 | 19.1451 | |
109 | 109 | Hungary | 2020-03-05T17:13:27 | 2 | 0 | 0 | 47.1625 | 19.5033 | |
145 | 145 | North Macedonia | 2020-02-27T16:23:03 | 1 | 0 | 0 | 41.6086 | 21.7453 | |
56 | 56 | Greece | 2020-03-05T14:23:03 | 31 | 0 | 0 | 39.0742 | 21.8243 | |
147 | 147 | South Africa | 2020-03-05T13:53:03 | 1 | 0 | 0 | -30.5595 | 22.9375 | |
139 | 139 | Lithuania | 2020-02-28T16:23:03 | 1 | 0 | 0 | 55.1694 | 23.8813 | |
137 | 137 | Latvia | 2020-03-04T01:33:07 | 1 | 0 | 0 | 56.8796 | 24.6032 | |
86 | 86 | Romania | 2020-03-05T06:23:06 | 6 | 0 | 1 | 46.0 | 25.0 | |
101 | 101 | Estonia | 2020-03-05T13:53:03 | 3 | 0 | 0 | 58.5953 | 25.0136 | |
75 | 75 | Finland | 2020-03-05T13:53:03 | 12 | 0 | 1 | 64.0 | 26.0 | |
84 | 84 | Belarus | 2020-03-04T12:43:03 | 6 | 0 | 0 | 53.7098 | 27.9534 | |
100 | 100 | Egypt | 2020-03-05T13:53:03 | 3 | 0 | 1 | 26.0 | 30.0 | |
169 | 169 | Ukraine | 2020-03-03T15:33:02 | 1 | 0 | 0 | 48.3794 | 31.1656 | |
66 | 66 | Israel | 2020-03-05T17:53:02 | 17 | 0 | 0 | 31.0 | 35.0 | |
95 | 95 | Palestine | 2020-03-05T13:53:03 | 4 | 0 | 0 | 31.9522 | 35.2332 |
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 );