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

230 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
101 101 Western Australia Australia 2020-03-11T20:00:00 14 1 0 -31.9505 115.8605
102 102   Cayman Islands 2020-03-11T20:00:00 1 0 0 19.3133 -81.2546
103 103   Japan 2020-03-11T20:00:00 701 19 118 36.2048 138.2529
104 104   Czechia 2020-03-11T20:00:00 141 0 0 49.8175 15.473
105 105   Qatar 2020-03-11T20:00:00 320 0 0 25.3548 51.1839
106 106   Singapore 2020-03-11T20:00:00 200 0 97 1.3521 103.8198
107 107   Guadeloupe 2020-03-11T20:00:00 1 0 0 16.265 -61.551
108 108   Dominican Republic 2020-03-11T20:00:00 5 0 0 18.7357 -70.1627
109 109   Egypt 2020-03-11T20:00:00 80 2 27 26.8206 30.8025
110 110   Bolivia 2020-03-11T20:00:00 3 0 0 -16.2902 -63.5887
111 111 Manitoba Canada 2020-03-11T20:00:00 4 0 0 53.7609 -98.8139
112 112 Saskatchewan Canada 2020-03-11T20:00:00 2 0 0 52.9399 -106.4509
113 113   Indonesia 2020-03-11T20:00:00 69 4 2 -0.7893 113.9213
114 114   Korea, South 2020-03-11T20:00:00 7979 66 510 35.9078 127.7669
115 115   Latvia 2020-03-11T20:00:00 17 0 1 56.8796 24.6032
116 116   Senegal 2020-03-11T20:00:00 10 0 1 14.4974 -14.4524
117 117   Ethiopia 2020-03-11T20:00:00 1 0 0 9.145 40.4897
118 118   Sudan 2020-03-11T20:00:00 0 1 0 12.8628 30.2176
119 119   Portugal 2020-03-11T20:00:00 112 0 1 39.3999 -8.2245
120 120   Andorra 2020-03-11T20:00:00 1 0 0 42.5063 1.5218
121 121   Guinea 2020-03-11T20:00:00 1 0 0 9.9456 -9.6966
122 122   Antigua and Barbuda 2020-03-11T20:00:00 1 0 0 17.0608 -61.7964
123 123   Belgium 2020-03-11T20:00:00 559 3 1 50.5039 4.4699
124 124   Russia 2020-03-11T20:00:00 45 0 3 61.524 105.3188
125 125   India 2020-03-11T20:00:00 82 2 4 20.5937 78.9629
126 126   Morocco 2020-03-11T20:00:00 7 1 1 31.7917 -7.0926
127 127   Aruba 2020-03-11T20:00:00 2 0 0 12.5211 -69.9683
128 128 Grand Princess Canada 2020-03-11T20:00:00 2 0 0 37.6489 -122.6655
129 129   Argentina 2020-03-11T20:00:00 31 2 0 -38.4161 -63.6167
130 130   Chile 2020-03-11T20:00:00 43 0 0 -35.6751 -71.543
131 131   Jordan 2020-03-11T20:00:00 1 0 1 31.24 36.51
132 132   Kenya 2020-03-11T20:00:00 1 0 0 -0.0236 37.9062
133 133 Saint Barthelemy France 2020-03-11T20:00:00 1 0 0 17.9 -62.8333
134 134 St Martin France 2020-03-11T20:00:00 2 0 0 18.0708 -63.0501
135 135   Poland 2020-03-11T20:00:00 68 2 0 51.9194 19.1451
136 136 Faroe Islands Denmark 2020-03-11T20:00:00 3 0 0 61.8926 -6.9118
137 137 Gibraltar United Kingdom 2020-03-11T20:00:00 1 0 1 36.1408 -5.3536
138 138   Hungary 2020-03-11T20:00:00 19 0 0 47.1625 19.5033
139 139 Northern Territory Australia 2020-03-11T20:00:00 1 0 0 -12.4634 130.8456
140 140 Alabama US 2020-03-11T20:00:00 5 0 0 32.3182 -86.9023
141 141   Slovenia 2020-03-11T20:00:00 141 0 0 46.1512 14.9955
142 142   Finland 2020-03-11T20:00:00 155 0 1 61.9241 25.7482
143 143   South Africa 2020-03-11T20:00:00 24 0 0 -30.5595 22.9375
144 144   Bosnia and Herzegovina 2020-03-11T20:00:00 13 0 0 43.9159 17.6791
145 145   Saudi Arabia 2020-03-11T20:00:00 86 0 1 23.8859 45.0792
146 146   Cote d'Ivoire 2020-03-11T20:00:00 1 0 0 7.54 -5.5471
147 147   Luxembourg 2020-03-11T20:00:00 34 0 0 49.8153 6.1296
148 148   Costa Rica 2020-03-11T20:00:00 23 0 0 9.7489 -83.7534
149 149 Alberta Canada 2020-03-11T20:00:00 29 0 0 53.9333 -116.5765
150 150   Bhutan 2020-03-11T20:00:00 1 0 0 27.5142 90.4336
151 151   Spain 2020-03-11T20:00:00 5232 133 193 40.4637 -3.7492
152 152   Malaysia 2020-03-11T20:00:00 197 0 26 4.2105 101.9758
153 153   Holy See 2020-03-11T20:00:00 1 0 0 41.9029 12.4534
154 154   Serbia 2020-03-11T20:00:00 35 0 0 44.0165 21.0059
155 155   Cameroon 2020-03-11T20:00:00 2 0 0 3.848 11.5021
156 156   Slovakia 2020-03-11T20:00:00 32 0 0 48.669 19.699
157 157   Togo 2020-03-11T20:00:00 1 0 0 8.6195 0.8248
158 158   Peru 2020-03-11T20:00:00 28 0 0 -9.19 -75.0152
159 159   Romania 2020-03-11T20:00:00 89 0 7 45.9432 24.9668
160 160   Mexico 2020-03-11T20:00:00 12 0 4 23.6345 -102.5528
161 161   Colombia 2020-03-11T20:00:00 13 0 0 4.5709 -74.2973
162 162 Grand Princess US 2020-03-11T20:00:00 21 0 0 37.64894 -122.665479
163 163   Brunei 2020-03-11T20:00:00 37 0 0 4.5353 114.7277
164 164   Martinique 2020-03-11T20:00:00 3 0 0 14.6415 -61.0242
165 165   French Guiana 2020-03-11T20:00:00 5 0 0 3.9339 -53.1258
166 166   Malta 2020-03-11T20:00:00 12 0 1 35.9375 14.3754
167 167   Paraguay 2020-03-11T20:00:00 6 0 0 -23.4425 -58.4438
168 168   Moldova 2020-03-11T20:00:00 6 0 0 47.4116 28.3699
169 169   Maldives 2020-03-11T20:00:00 9 0 0 3.2028 73.2207
170 170   Bulgaria 2020-03-11T20:00:00 23 1 0 42.7339 25.4858
171 171   Tunisia 2020-03-11T20:00:00 16 0 0 33.8869 9.5375
172 172   Cyprus 2020-03-11T20:00:00 14 0 0 35.1264 33.4299
173 173 Alaska US 2020-03-11T20:00:00 1 0 0 61.370716 -152.404419
174 174 Arizona US 2020-03-11T20:00:00 9 0 1 33.729759 -111.431221
175 175 Arkansas US 2020-03-11T20:00:00 6 0 0 34.969704 -92.373123
176 176 California US 2020-03-11T20:00:00 282 4 6 36.116203 -119.681564
177 177 Colorado US 2020-03-11T20:00:00 49 0 0 39.059811 -105.311104
178 178 Connecticut US 2020-03-11T20:00:00 11 0 0 41.597782 -72.755371
179 179 Delaware US 2020-03-11T20:00:00 4 0 0 39.318523 -75.507141
180 180 District of Columbia US 2020-03-11T20:00:00 10 0 0 38.897438 -77.026817
181 181 Florida US 2020-03-11T20:00:00 50 2 0 27.766279 -81.686783
182 182 Georgia US 2020-03-11T20:00:00 42 1 0 33.040619 -83.643074
183 183 Hawaii US 2020-03-11T20:00:00 2 0 0 21.094318 -157.498337
184 184 Idaho US 2020-03-11T20:00:00 1 0 0 44.240459 -114.478828
185 185 Illinois US 2020-03-11T20:00:00 46 0 2 40.349457 -88.986137
186 186 Indiana US 2020-03-11T20:00:00 13 0 0 39.849426 -86.258278
187 187 Iowa US 2020-03-11T20:00:00 17 0 0 42.011539 -93.210526
188 188 Kansas US 2020-03-11T20:00:00 5 1 0 38.5266 -96.726486
189 189 Kentucky US 2020-03-11T20:00:00 14 0 0 37.66814 -84.670067
190 190 Louisiana US 2020-03-11T20:00:00 36 0 0 31.169546 -91.867805
191 191 Maine US 2020-03-11T20:00:00 1 0 0 44.693947 -69.381927
192 192 Maryland US 2020-03-11T20:00:00 18 0 0 39.063946 -76.802101
193 193 Massachusetts US 2020-03-11T20:00:00 123 0 1 42.230171 -71.530106
194 194 Michigan US 2020-03-11T20:00:00 16 0 0 43.326618 -84.536095
195 195 Minnesota US 2020-03-11T20:00:00 14 0 0 45.694454 -93.900192
196 196 Mississippi US 2020-03-11T20:00:00 1 0 0 32.741646 -89.678696
197 197 Missouri US 2020-03-11T20:00:00 2 0 0 38.456085 -92.288368
198 198 Montana US 2020-03-11T20:00:00 1 0 0 46.921925 -110.454353
199 199 Nebraska US 2020-03-11T20:00:00 13 0 0 41.12537 -98.268082
200 200 Nevada US 2020-03-11T20:00:00 17 0 0 38.313515 -117.055374

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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