03-14-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

249 rows sorted by Province/State

✎ View and edit SQL

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
2 2   Italy 2020-03-14T20:13:16 21157 1441 1966 41.8719 12.5674
3 3   Iran 2020-03-14T11:33:06 12729 611 2959 32.4279 53.688
4 4   Korea, South 2020-03-14T01:33:02 8086 72 510 35.9078 127.7669
5 5   Spain 2020-03-14T22:13:11 6391 195 517 40.4637 -3.7492
6 6   Germany 2020-03-14T22:13:11 4585 9 46 51.1657 10.4515
8 8   Switzerland 2020-03-14T11:53:29 1359 13 4 46.8182 8.2275
13 13   Norway 2020-03-14T22:13:11 1090 3 1 60.472 8.4689
16 16   Sweden 2020-03-14T22:13:11 961 2 1 60.1282 18.6435
17 17   Netherlands 2020-03-14T22:13:11 959 12 2 52.1326 5.2913
20 20   Japan 2020-03-14T22:33:03 773 22 118 36.2048 138.2529
23 23   Belgium 2020-03-14T11:53:29 689 4 1 50.5039 4.4699
24 24   Austria 2020-03-14T16:13:55 655 1 6 47.5162 14.5501
34 34   Qatar 2020-03-14T22:33:03 337 0 4 25.3548 51.1839
39 39   Malaysia 2020-03-14T16:13:55 238 0 35 4.2105 101.9758
40 40   Greece 2020-03-14T22:33:03 228 3 8 39.0742 21.8243
41 41   Finland 2020-03-14T22:33:03 225 0 1 61.9241 25.7482
42 42   Singapore 2020-03-14T16:14:30 212 0 105 1.3521 103.8198
43 43   Bahrain 2020-03-14T11:53:29 210 0 44 26.0667 50.5577
44 44   Israel 2020-03-14T20:13:16 176 0 1 31.0461 34.8516
45 45   Czechia 2020-03-14T20:13:16 189 0 0 49.8175 15.473
46 46   Slovenia 2020-03-14T22:33:03 181 1 0 46.1512 14.9955
48 48   Portugal 2020-03-14T16:14:47 169 0 2 39.3999 -8.2245
50 50   Iceland 2020-03-14T14:53:04 156 0 1 64.9631 -19.0208
51 51   Brazil 2020-03-13T22:21:58 151 0 0 -14.235 -51.9253
58 58   Ireland 2020-03-14T20:13:16 129 2 0 53.1424 -7.6921
60 60   Romania 2020-03-14T22:33:03 123 0 9 45.9432 24.9668
61 61   Estonia 2020-03-14T20:33:03 115 0 0 58.5953 25.0136
63 63   Philippines 2020-03-14T20:33:03 111 8 2 12.8797 121.774
64 64   Iraq 2020-03-14T22:33:03 110 10 26 33.2232 43.6793
65 65   Egypt 2020-03-14T22:33:03 109 2 27 26.8206 30.8025
66 66   Kuwait 2020-03-14T16:14:34 104 0 5 29.3117 47.4818
67 67   Poland 2020-03-14T22:53:02 103 3 0 51.9194 19.1451
68 68   Saudi Arabia 2020-03-14T20:33:03 103 0 1 23.8859 45.0792
69 69   India 2020-03-14T20:33:03 102 2 4 20.5937 78.9629
71 71   Indonesia 2020-03-14T22:53:02 96 5 8 -0.7893 113.9213
73 73   Lebanon 2020-03-14T12:13:12 93 3 1 33.8547 35.8623
74 74   United Arab Emirates 2020-03-13T22:21:58 85 0 17 23.4241 53.8478
75 75   Thailand 2020-03-14T12:13:12 82 1 35 15.87 100.9925
76 76   San Marino 2020-03-14T22:53:02 80 5 4 43.9424 12.4578
87 87   Chile 2020-03-14T20:33:03 61 0 0 -35.6751 -71.543
88 88   Russia 2020-03-14T22:53:02 59 0 8 61.524 105.3188
90 90   Taiwan* 2020-03-14T07:13:11 53 1 20 23.7 121.0
91 91   Vietnam 2020-03-14T12:13:12 53 0 16 14.0583 108.2772
92 92   Luxembourg 2020-03-14T20:33:03 51 1 0 49.8153 6.1296
96 96   Serbia 2020-03-14T22:53:02 46 0 0 44.0165 21.0059
98 98   Slovakia 2020-03-14T20:33:03 44 0 0 48.669 19.699
99 99   Bulgaria 2020-03-14T20:33:03 41 2 0 42.7339 25.4858
101 101   Brunei 2020-03-14T20:33:03 40 0 0 4.5353 114.7277
102 102   Albania 2020-03-14T12:33:03 38 1 0 41.1533 20.1683
103 103   Croatia 2020-03-14T20:33:03 38 0 1 45.1 15.2
104 104   Peru 2020-03-14T12:33:03 38 0 0 -9.19 -75.0152
105 105   South Africa 2020-03-14T16:14:56 38 0 0 -30.5595 22.9375
106 106   Algeria 2020-03-14T12:33:03 37 3 12 28.0339 1.6596
107 107   Panama 2020-03-14T12:33:03 36 1 0 8.538 -80.7821
108 108   Argentina 2020-03-14T20:33:03 34 2 1 -38.4161 -63.6167
111 111   Pakistan 2020-03-14T20:33:03 31 0 2 30.3753 69.3451
112 112   Georgia 2020-03-14T12:33:03 30 0 0 42.3154 43.3569
113 113   Hungary 2020-03-14T22:53:02 30 0 1 47.1625 19.5033
115 115   Ecuador 2020-03-14T22:53:02 28 2 0 -1.8312 -78.1834
116 116   Belarus 2020-03-13T22:21:59 27 0 3 53.7098 27.9534
118 118   Costa Rica 2020-03-14T12:33:03 26 0 0 9.7489 -83.7534
119 119   Cyprus 2020-03-14T22:53:02 26 0 0 35.1264 33.4299
120 120   Latvia 2020-03-14T12:33:03 26 0 1 56.8796 24.6032
121 121   Mexico 2020-03-14T20:53:02 26 0 4 23.6345 -102.5528
126 126   Colombia 2020-03-14T20:53:02 22 0 0 4.5709 -74.2973
133 133   Oman 2020-03-13T23:33:05 19 0 9 21.4735 55.9754
135 135   Armenia 2020-03-14T20:53:02 18 0 0 40.0691 45.0382
136 136   Bosnia and Herzegovina 2020-03-14T12:33:03 18 0 0 43.9159 17.6791
138 138   Malta 2020-03-14T12:33:03 18 0 1 35.9375 14.3754
139 139   Tunisia 2020-03-14T20:53:02 18 0 0 33.8869 9.5375
142 142   Morocco 2020-03-14T20:53:02 17 1 1 31.7917 -7.0926
145 145   Azerbaijan 2020-03-13T12:13:36 15 1 3 40.1431 47.5769
146 146   North Macedonia 2020-03-13T23:33:05 14 0 1 41.6086 21.7453
149 149   Moldova 2020-03-14T20:53:02 12 0 0 47.4116 28.3699
152 152   Afghanistan 2020-03-14T14:53:04 15 0 0 33.9391 67.71
153 153   Dominican Republic 2020-03-14T20:53:02 11 0 0 18.7357 -70.1627
154 154   Bolivia 2020-03-14T12:53:07 10 0 0 -16.2902 -63.5887
156 156   Maldives 2020-03-14T16:14:58 10 0 0 3.2028 73.2207
157 157   Senegal 2020-03-13T23:33:05 10 0 1 14.4974 -14.4524
158 158   Sri Lanka 2020-03-14T16:14:58 10 0 1 7.8731 80.7718
163 163   Martinique 2020-03-14T14:53:04 9 0 0 14.6415 -61.0242
165 165   Jamaica 2020-03-13T22:22:02 8 0 0 18.1096 -77.2975
166 166   Lithuania 2020-03-14T14:53:04 6 0 1 55.1694 23.8813
168 168   Cambodia 2020-03-14T12:53:07 7 0 1 12.5657 104.991
170 170   Kazakhstan 2020-03-14T12:53:07 6 0 0 48.0196 66.9237
171 171   New Zealand 2020-03-14T20:53:02 6 0 0 -40.9006 174.886
172 172   Paraguay 2020-03-13T23:33:06 6 0 0 -23.4425 -58.4438
173 173   Reunion 2020-03-14T20:53:02 6 0 0 -21.1151 55.5364
179 179   French Guiana 2020-03-07T03:23:05 5 0 0 3.9339 -53.1258
180 180   Turkey 2020-03-13T23:33:06 5 0 0 38.9637 35.2433
184 184   Cuba 2020-03-13T23:53:02 4 0 0 21.5218 -77.7812
185 185   Liechtenstein 2020-03-14T20:53:02 4 0 0 47.166 9.5554
189 189   Uruguay 2020-03-14T16:33:03 4 0 0 -32.5228 -55.7658
190 190   Bangladesh 2020-03-13T22:22:02 3 0 0 23.685 90.3563
192 192   Ghana 2020-03-14T23:13:05 3 0 0 7.9465 -1.0232
195 195   Ukraine 2020-03-13T22:22:02 3 1 0 48.3794 31.1656
196 196   Aruba 2020-03-13T23:53:03 2 0 0 12.5211 -69.9683
197 197   Burkina Faso 2020-03-13T22:22:02 2 0 0 12.2383 -1.5616
198 198   Cameroon 2020-03-13T22:22:02 2 0 0 3.848 11.5021
200 200   Congo (Kinshasa) 2020-03-13T22:22:02 2 0 0 -4.0383 21.7587

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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