03-12-2020
Data source: Big Local News · About: README
218 rows sorted by Province/State
This data as json, copyable, CSV (advanced)
Link | rowid | Province/State ▼ | Country/Region | Last Update | Confirmed | Deaths | Recovered | Latitude | Longitude |
---|---|---|---|---|---|---|---|---|---|
195 | 195 | Jordan | 2020-03-03T15:33:02 | 1 | 0 | 0 | 31.24 | 36.51 | |
196 | 196 | Liechtenstein | 2020-03-04T01:33:07 | 1 | 0 | 0 | 47.14 | 9.55 | |
197 | 197 | Mongolia | 2020-03-10T06:13:43 | 1 | 0 | 0 | 46.8625 | 103.8467 | |
198 | 198 | Nepal | 2020-03-10T08:33:03 | 1 | 0 | 1 | 28.3949 | 84.124 | |
199 | 199 | Reunion | 2020-03-11T23:13:07 | 1 | 0 | 0 | -21.1151 | 55.5364 | |
200 | 200 | Togo | 2020-03-07T02:13:09 | 1 | 0 | 0 | 8.6195 | 0.8248 | |
201 | 201 | Turkey | 2020-03-11T03:33:05 | 1 | 0 | 0 | 38.9637 | 35.2433 | |
209 | 209 | Ukraine | 2020-03-03T15:33:02 | 1 | 0 | 0 | 48.3794 | 31.1656 | |
218 | 218 | occupied Palestinian territory | 2020-03-11T20:53:02 | 0 | 0 | 0 | 31.9522 | 35.2332 | |
214 | 214 | Alaska | US | 2020-03-10T02:33:04 | 0 | 0 | 0 | 61.3707 | -152.4044 |
102 | 102 | Alberta | Canada | 2020-03-11T23:13:07 | 19 | 0 | 0 | 53.9333 | -116.5765 |
12 | 12 | Anhui | China | 2020-03-11T02:18:14 | 990 | 6 | 984 | 31.8257 | 117.2264 |
138 | 138 | Arizona | US | 2020-03-11T18:52:04 | 9 | 0 | 1 | 33.7298 | -111.4312 |
150 | 150 | Arkansas | US | 2020-03-12T21:39:10 | 6 | 0 | 0 | 34.9697 | -92.3731 |
28 | 28 | Beijing | China | 2020-03-12T01:13:05 | 435 | 8 | 334 | 40.1824 | 116.4142 |
76 | 76 | British Columbia | Canada | 2020-03-12T01:53:03 | 46 | 1 | 4 | 53.7267 | -127.6476 |
38 | 38 | California | US | 2020-03-12T23:44:33 | 221 | 4 | 6 | 36.1162 | -119.6816 |
184 | 184 | Channel Islands | United Kingdom | 2020-03-11T20:53:02 | 2 | 0 | 0 | 49.3723 | -2.3644 |
22 | 22 | Chongqing | China | 2020-03-12T23:44:32 | 576 | 6 | 564 | 30.0572 | 107.874 |
79 | 79 | Colorado | US | 2020-03-12T21:39:10 | 45 | 0 | 0 | 39.0598 | -105.3111 |
156 | 156 | Connecticut | US | 2020-03-12T23:44:33 | 5 | 0 | 0 | 41.5978 | -72.7554 |
202 | 202 | Delaware | US | 2020-03-11T23:13:06 | 1 | 0 | 0 | 39.3185 | -75.5071 |
20 | 20 | Denmark | Denmark | 2020-03-12T09:53:06 | 615 | 0 | 1 | 56.2639 | 9.5018 |
16 | 16 | Diamond Princess | Cruise Ship | 2020-03-11T22:13:12 | 696 | 7 | 325 | 35.4437 | 139.638 |
77 | 77 | Diamond Princess | US | 2020-03-10T02:33:04 | 46 | 0 | 0 | 35.4437 | 139.638 |
131 | 131 | District of Columbia | US | 2020-03-11T22:53:03 | 10 | 0 | 0 | 38.8974 | -77.0268 |
173 | 173 | Faroe Islands | Denmark | 2020-03-11T20:53:02 | 2 | 0 | 0 | 61.8926 | -6.9118 |
83 | 83 | Florida | US | 2020-03-12T21:39:10 | 35 | 2 | 0 | 27.7663 | -81.6868 |
5 | 5 | France | France | 2020-03-11T22:53:03 | 2281 | 48 | 12 | 46.2276 | 2.2137 |
211 | 211 | From Diamond Princess | Australia | 2020-02-29T02:03:10 | 0 | 0 | 0 | 35.4437 | 139.638 |
34 | 34 | Fujian | China | 2020-03-11T02:18:14 | 296 | 1 | 295 | 26.0789 | 117.9874 |
49 | 49 | Gansu | China | 2020-03-11T14:33:03 | 127 | 2 | 88 | 37.8099 | 101.0583 |
212 | 212 | Gansu | Mainland China | 2020-03-11T02:18:28 | 0 | 0 | 0 | 36.0611 | 103.8343 |
86 | 86 | Georgia | US | 2020-03-12T21:39:10 | 31 | 1 | 0 | 33.0406 | -83.6431 |
210 | 210 | Gibraltar | United Kingdom | 2020-03-11T20:53:02 | 1 | 0 | 1 | 36.1408 | -5.3536 |
98 | 98 | Grand Princess | US | 2020-03-10T02:33:04 | 21 | 0 | 0 | 37.6489 | -122.6655 |
8 | 8 | Guangdong | China | 2020-03-12T03:53:02 | 1356 | 8 | 1289 | 23.3417 | 113.4244 |
36 | 36 | Guangxi | China | 2020-03-12T00:33:06 | 252 | 2 | 241 | 23.8298 | 108.7881 |
44 | 44 | Guizhou | China | 2020-03-12T01:13:06 | 146 | 2 | 137 | 26.8154 | 106.8748 |
42 | 42 | Hainan | China | 2020-03-12T03:53:02 | 168 | 6 | 160 | 19.1959 | 109.7453 |
180 | 180 | Hawaii | US | 2020-03-10T03:13:17 | 2 | 0 | 0 | 21.0943 | -157.4983 |
31 | 31 | Hebei | China | 2020-03-12T05:33:02 | 318 | 6 | 308 | 39.549 | 116.1306 |
213 | 213 | Hebei | Mainland China | 2020-03-11T02:18:29 | 0 | 0 | 0 | 38.0428 | 114.5149 |
25 | 25 | Heilongjiang | China | 2020-03-12T13:13:31 | 482 | 13 | 441 | 47.862 | 127.7615 |
9 | 9 | Henan | China | 2020-03-11T08:13:09 | 1273 | 22 | 1249 | 33.882 | 113.614 |
48 | 48 | Hong Kong | China | 2020-03-12T01:53:02 | 129 | 3 | 67 | 22.3 | 114.2 |
1 | 1 | Hubei | China | 2020-03-12T09:53:06 | 67781 | 3056 | 50318 | 30.9756 | 112.2707 |
11 | 11 | Hunan | China | 2020-03-12T09:53:06 | 1018 | 4 | 999 | 27.6104 | 111.7088 |
215 | 215 | Idaho | US | 2020-03-10T02:33:04 | 0 | 0 | 0 | 44.2405 | -114.4788 |
85 | 85 | Illinois | US | 2020-03-12T23:44:33 | 32 | 0 | 2 | 40.3495 | -88.9861 |
120 | 120 | Indiana | US | 2020-03-12T23:44:33 | 13 | 0 | 0 | 39.8494 | -86.2583 |
60 | 60 | Inner Mongolia | China | 2020-03-11T03:53:03 | 75 | 1 | 71 | 44.0935 | 113.9448 |
115 | 115 | Iowa | US | 2020-03-12T23:44:33 | 16 | 0 | 0 | 42.0115 | -93.2105 |
19 | 19 | Jiangsu | China | 2020-03-12T05:13:02 | 631 | 0 | 629 | 32.9711 | 119.455 |
13 | 13 | Jiangxi | China | 2020-03-12T02:13:04 | 935 | 1 | 934 | 27.614 | 115.7221 |
55 | 55 | Jilin | China | 2020-03-12T23:44:32 | 93 | 1 | 91 | 43.6661 | 126.1923 |
203 | 203 | Kansas | US | 2020-03-10T03:13:17 | 1 | 0 | 0 | 38.5266 | -96.7265 |
132 | 132 | Kentucky | US | 2020-03-12T23:44:33 | 10 | 0 | 0 | 37.6681 | -84.6701 |
50 | 50 | Liaoning | China | 2020-03-12T09:53:06 | 125 | 1 | 112 | 41.2956 | 122.6085 |
106 | 106 | Louisiana | US | 2020-03-12T23:44:33 | 19 | 0 | 0 | 31.1695 | -91.8678 |
129 | 129 | Macau | China | 2020-03-11T18:52:03 | 10 | 0 | 10 | 22.1667 | 113.55 |
216 | 216 | Maine | US | 2020-03-10T02:33:04 | 0 | 0 | 0 | 44.6939 | -69.3819 |
123 | 123 | Maryland | US | 2020-03-12T01:53:03 | 12 | 0 | 0 | 39.0639 | -76.8021 |
51 | 51 | Massachusetts | US | 2020-03-12T21:39:09 | 108 | 0 | 1 | 42.2302 | -71.5301 |
181 | 181 | Michigan | US | 2020-03-11T03:33:05 | 2 | 0 | 0 | 43.3266 | -84.5361 |
139 | 139 | Minnesota | US | 2020-03-12T21:39:10 | 9 | 0 | 0 | 45.6945 | -93.9002 |
204 | 204 | Mississippi | US | 2020-03-12T09:33:03 | 1 | 0 | 0 | 32.7416 | -89.6787 |
205 | 205 | Missouri | US | 2020-03-10T03:13:17 | 1 | 0 | 0 | 38.4561 | -92.2884 |
206 | 206 | Montana | US | 2020-03-11T23:13:06 | 1 | 0 | 0 | 46.9219 | -110.4544 |
133 | 133 | Nebraska | US | 2020-03-12T01:53:03 | 10 | 0 | 0 | 41.1254 | -98.2681 |
118 | 118 | Nevada | US | 2020-03-12T23:44:33 | 14 | 0 | 0 | 38.3135 | -117.0554 |
188 | 188 | New Brunswick | Canada | 2020-03-11T23:13:06 | 1 | 0 | 0 | 46.5653 | -66.4619 |
151 | 151 | New Hampshire | US | 2020-03-12T21:39:10 | 6 | 0 | 0 | 43.4525 | -71.5639 |
87 | 87 | New Jersey | US | 2020-03-12T21:39:10 | 29 | 1 | 0 | 40.2989 | -74.521 |
157 | 157 | New Mexico | US | 2020-03-12T23:44:33 | 5 | 0 | 0 | 34.8405 | -106.2485 |
67 | 67 | New South Wales | Australia | 2020-03-11T18:52:04 | 65 | 2 | 4 | -33.8688 | 151.2093 |
30 | 30 | New York | US | 2020-03-12T21:39:10 | 328 | 0 | 0 | 42.1657 | -74.9481 |
61 | 61 | Ningxia | China | 2020-03-11T09:33:12 | 75 | 0 | 72 | 37.2692 | 106.1655 |
117 | 117 | North Carolina | US | 2020-03-12T21:39:10 | 15 | 0 | 0 | 35.6301 | -79.8064 |
207 | 207 | North Dakota | US | 2020-03-12T09:33:03 | 1 | 0 | 0 | 47.5289 | -99.784 |
186 | 186 | Northern Territory | Australia | 2020-03-10T14:13:14 | 1 | 0 | 0 | -12.4634 | 130.8456 |
158 | 158 | Ohio | US | 2020-03-12T09:33:03 | 5 | 0 | 0 | 40.3888 | -82.7649 |
182 | 182 | Oklahoma | US | 2020-03-10T17:13:25 | 2 | 0 | 0 | 35.5653 | -96.9289 |
81 | 81 | Ontario | Canada | 2020-03-12T01:53:03 | 42 | 0 | 4 | 51.2538 | -85.3232 |
92 | 92 | Oregon | US | 2020-03-12T23:44:33 | 24 | 0 | 0 | 44.572 | -122.0709 |
96 | 96 | Pennsylvania | US | 2020-03-12T21:39:10 | 22 | 0 | 0 | 40.5908 | -77.2098 |
107 | 107 | Qinghai | China | 2020-03-11T02:18:14 | 18 | 0 | 18 | 35.7452 | 95.9956 |
136 | 136 | Quebec | Canada | 2020-03-12T01:53:03 | 9 | 0 | 0 | 52.9399 | -73.5491 |
99 | 99 | Queensland | Australia | 2020-03-11T18:52:04 | 20 | 0 | 8 | -28.0167 | 153.4 |
159 | 159 | Rhode Island | US | 2020-03-11T03:13:08 | 5 | 0 | 0 | 41.6809 | -71.5118 |
192 | 192 | Saint Barthelemy | France | 2020-03-11T20:53:02 | 1 | 0 | 0 | 17.9 | -62.8333 |
37 | 37 | Shaanxi | China | 2020-03-12T01:33:02 | 245 | 2 | 232 | 35.1917 | 108.8701 |
14 | 14 | Shandong | China | 2020-03-12T07:53:02 | 760 | 6 | 734 | 36.3427 | 118.1498 |
29 | 29 | Shanghai | China | 2020-03-12T07:53:02 | 344 | 3 | 321 | 31.202 | 121.4491 |
46 | 46 | Shanxi | China | 2020-03-12T09:13:24 | 133 | 0 | 132 | 37.5777 | 112.2922 |
23 | 23 | Sichuan | China | 2020-03-12T12:13:07 | 539 | 3 | 498 | 30.6171 | 102.7103 |
134 | 134 | South Australia | Australia | 2020-03-11T18:52:04 | 9 | 0 | 2 | -34.9285 | 138.6007 |
124 | 124 | South Carolina | US | 2020-03-12T21:39:10 | 12 | 0 | 0 | 33.8569 | -80.945 |
141 | 141 | South Dakota | US | 2020-03-11T22:53:03 | 8 | 1 | 0 | 44.2998 | -99.4388 |
174 | 174 | St Martin | France | 2020-03-11T20:53:02 | 2 | 0 | 0 | 18.0708 | -63.0501 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [03-12-2020] ( [Province/State] TEXT, [Country/Region] TEXT, [Last Update] TEXT, [Confirmed] INTEGER, [Deaths] INTEGER, [Recovered] INTEGER, [Latitude] FLOAT, [Longitude] FLOAT );