03-15-2020

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: README

258 rows sorted by Last Update

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid Province/State Country/Region Last Update ▼ Confirmed Deaths Recovered Latitude Longitude
71 71   Iraq 2020-03-14T22:33:03 116 10 26 33.2232 43.6793
136 136 Nevada US 2020-03-14T22:33:03 24 0 0 38.3135 -117.0554
141 141 South Carolina US 2020-03-14T22:33:03 28 0 0 33.8569 -80.945
170 170 Kansas US 2020-03-14T22:33:03 8 1 0 38.5266 -96.7265
118 118 Tennessee US 2020-03-14T22:33:04 39 0 0 35.7478 -86.6923
189 189 Vermont US 2020-03-14T22:33:04 8 0 0 44.0459 -72.7107
102 102   Serbia 2020-03-14T22:53:02 48 0 0 44.0165 21.0059
123 123   Ecuador 2020-03-14T22:53:02 28 2 0 -1.8312 -78.1834
128 128   Cyprus 2020-03-14T22:53:02 26 0 0 35.1264 33.4299
212 212   Monaco 2020-03-14T23:13:05 2 0 0 43.7384 7.4246
48 48 Yunnan China 2020-03-14T23:33:02 174 2 172 24.974 101.487
34 34 Shanghai China 2020-03-14T23:53:02 353 3 324 31.202 121.4491
30 30 Heilongjiang China 2020-03-15T00:33:02 482 13 453 47.862 127.7615
31 31 Beijing China 2020-03-15T01:13:10 442 8 353 40.1824 116.4142
11 11 Zhejiang China 2020-03-15T01:33:02 1231 1 1211 29.1832 120.0934
27 27 Jiangsu China 2020-03-15T01:53:02 631 0 631 32.9711 119.455
85 85 British Columbia Canada 2020-03-15T01:53:02 73 1 4 53.7267 -127.6476
129 129 Quebec Canada 2020-03-15T01:53:02 24 0 0 52.9399 -73.5491
206 206 New Brunswick Canada 2020-03-15T01:53:02 2 0 0 46.5653 -66.4619
73 73 Ontario Canada 2020-03-15T01:53:03 104 0 4 51.2538 -85.3232
111 111 Alberta Canada 2020-03-15T01:53:03 39 0 0 53.9333 -116.5765
26 26 Washington US 2020-03-15T02:13:21 643 40 1 47.4009 -121.4905
222 222 Newfoundland and Labrador Canada 2020-03-15T02:13:21 1 0 0 53.1355 -57.6604
223 223 Prince Edward Island Canada 2020-03-15T02:13:21 1 0 0 46.5107 -63.4168
145 145 Kentucky US 2020-03-15T02:53:02 20 0 0 37.6681 -84.6701
150 150 District of Columbia US 2020-03-15T02:53:03 16 0 0 38.8974 -77.0268
154 154 New Mexico US 2020-03-15T02:53:03 13 0 0 34.8405 -106.2485
200 200 Wyoming US 2020-03-15T02:53:03 3 0 0 42.756 -107.3025
28 28 Chongqing China 2020-03-15T03:53:04 576 6 570 30.0572 107.874
63 63 Liaoning China 2020-03-15T04:13:27 125 1 114 41.2956 122.6085
230 230   Equatorial Guinea 2020-03-15T06:41:54 1 0 0 1.5 10.0
231 231   Eswatini 2020-03-15T06:41:54 1 0 0 -26.5225 31.4659
239 239   Guinea 2020-03-15T06:41:54 1 0 0 9.9456 -9.6966
245 245   Rwanda 2020-03-15T06:41:54 1 0 0 -1.9403 29.8739
92 92   Taiwan* 2020-03-15T06:53:03 59 1 20 23.7 121.0
186 186 French Guiana France 2020-03-15T06:53:03 7 0 0 3.9339 -53.1258
215 215   Seychelles 2020-03-15T07:33:03 2 0 0 -4.6796 55.492
1 1 Hubei China 2020-03-15T18:20:18 67794 3085 54288 30.9756 112.2707
3 3   Iran 2020-03-15T18:20:18 13938 724 4590 32.4279 53.688
4 4   Korea, South 2020-03-15T18:20:18 8162 75 510 35.9078 127.7669
5 5   Spain 2020-03-15T18:20:18 7798 289 517 40.4637 -3.7492
6 6   Germany 2020-03-15T18:20:18 5795 11 46 51.1657 10.4515
7 7 France France 2020-03-15T18:20:18 4499 91 12 46.2276 2.2137
8 8   Switzerland 2020-03-15T18:20:18 2200 14 4 46.8182 8.2275
9 9 Guangdong China 2020-03-15T18:20:18 1360 8 1304 23.3417 113.4244
12 12   Norway 2020-03-15T18:20:18 1221 3 1 60.472 8.4689
14 14   Netherlands 2020-03-15T18:20:18 1135 20 2 52.1326 5.2913
15 15   Sweden 2020-03-15T18:20:18 1022 3 1 60.1282 18.6435
19 19   Belgium 2020-03-15T18:20:18 886 4 1 50.5039 4.4699
21 21   Austria 2020-03-15T18:20:18 860 1 6 47.5162 14.5501
29 29 Sichuan China 2020-03-15T18:20:18 539 3 516 30.6171 102.7103
32 32   Malaysia 2020-03-15T18:20:18 428 0 42 4.2105 101.9758
40 40   Portugal 2020-03-15T18:20:18 245 0 2 39.3999 -8.2245
41 41   Finland 2020-03-15T18:20:18 244 0 10 61.9241 25.7482
42 42   Czechia 2020-03-15T18:20:18 253 0 0 49.8175 15.473
43 43   Greece 2020-03-15T18:20:18 331 4 8 39.0742 21.8243
44 44   Singapore 2020-03-15T18:20:18 226 0 105 1.3521 103.8198
45 45   Slovenia 2020-03-15T18:20:18 219 1 0 46.1512 14.9955
47 47   Israel 2020-03-15T18:20:18 215 0 1 31.0461 34.8516
50 50   Brazil 2020-03-15T18:20:18 162 0 0 -14.235 -51.9253
51 51   Iceland 2020-03-15T18:20:18 171 5 8 64.9631 -19.0208
53 53 Hong Kong China 2020-03-15T18:20:18 145 4 81 22.3 114.2
54 54   Philippines 2020-03-15T18:20:18 140 11 2 12.8797 121.774
56 56 Tianjin China 2020-03-15T18:20:18 136 3 133 39.3054 117.323
57 57   Estonia 2020-03-15T18:20:18 171 0 1 58.5953 25.0136
59 59 Gansu China 2020-03-15T18:20:18 133 2 91 36.0611 103.8343
61 61   Romania 2020-03-15T18:20:18 131 0 9 45.9432 24.9668
64 64   Poland 2020-03-15T18:20:18 119 3 0 51.9194 19.1451
65 65   Indonesia 2020-03-15T18:20:18 117 5 8 -0.7893 113.9213
67 67   Thailand 2020-03-15T18:20:18 114 1 37 15.87 100.9925
68 68   India 2020-03-15T18:20:18 113 2 13 20.5937 78.9629
69 69   Kuwait 2020-03-15T18:20:18 112 0 5 29.3117 47.4818
70 70   Egypt 2020-03-15T18:20:18 110 2 21 26.8206 30.8025
72 72   Lebanon 2020-03-15T18:20:18 110 3 1 33.8547 35.8623
78 78   San Marino 2020-03-15T18:20:18 101 5 4 43.9424 12.4578
80 80   United Arab Emirates 2020-03-15T18:20:18 98 0 23 23.4241 53.8478
87 87   Russia 2020-03-15T18:20:18 63 0 8 61.524 105.3188
91 91   Luxembourg 2020-03-15T18:20:18 59 1 0 49.8153 6.1296
94 94   Vietnam 2020-03-15T18:20:18 56 0 16 14.0583 108.2772
95 95   Slovakia 2020-03-15T18:20:18 54 0 0 48.669 19.699
96 96   Pakistan 2020-03-15T18:20:18 53 0 2 30.3753 69.3451
97 97   South Africa 2020-03-15T18:20:18 51 0 0 -30.5595 22.9375
98 98   Brunei 2020-03-15T18:20:18 50 0 0 4.5353 114.7277
99 99   Croatia 2020-03-15T18:20:18 49 0 1 45.1 15.2
100 100   Algeria 2020-03-15T18:20:18 48 4 12 28.0339 1.6596
104 104   Argentina 2020-03-15T18:20:18 45 2 1 -38.4161 -63.6167
106 106   Bulgaria 2020-03-15T18:20:18 51 2 0 42.7339 25.4858
107 107   Panama 2020-03-15T18:20:18 43 1 0 8.538 -80.7821
108 108   Peru 2020-03-15T18:20:18 43 0 0 -9.19 -75.0152
109 109   Albania 2020-03-15T18:20:18 42 1 0 41.1533 20.1683
110 110   Mexico 2020-03-15T18:20:18 41 0 4 23.6345 -102.5528
114 114   Colombia 2020-03-15T18:20:18 34 0 0 4.5709 -74.2973
116 116   Hungary 2020-03-15T18:20:18 32 1 1 47.1625 19.5033
121 121   Latvia 2020-03-15T18:20:18 30 0 1 56.8796 24.6032
124 124   Morocco 2020-03-15T18:20:18 28 1 1 31.7917 -7.0926
127 127   Costa Rica 2020-03-15T18:20:18 27 0 0 9.7489 -83.7534
132 132   Armenia 2020-03-15T18:20:18 26 0 0 40.0691 45.0382
133 133   Bosnia and Herzegovina 2020-03-15T18:20:18 24 0 0 43.9159 17.6791
134 134   Malta 2020-03-15T18:20:18 21 0 1 35.9375 14.3754
138 138   Oman 2020-03-15T18:20:18 22 0 9 21.4735 55.9754

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-15-2020] (
   [Province/State] TEXT,
   [Country/Region] TEXT,
   [Last Update] TEXT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Latitude] FLOAT,
   [Longitude] FLOAT
);