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 Country/Region descending

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region ▲ Last Update Confirmed Deaths Recovered Latitude Longitude
258   occupied Palestinian territory 2020-03-11T20:53:02 0 0 0 31.9522 35.2332
94   Vietnam 2020-03-15T18:20:18 56 0 16 14.0583 108.2772
171   Venezuela 2020-03-15T18:20:18 10 0 0 6.4238 -66.5897
255   Uzbekistan 2020-03-15T18:20:19 1 0 0 41.3775 64.5853
195   Uruguay 2020-03-14T16:33:03 4 0 0 -32.5228 -55.7658
13 United Kingdom United Kingdom 2020-03-14T14:53:04 1140 21 18 55.3781 -3.436
202 Channel Islands United Kingdom 2020-03-15T18:20:19 3 0 0 49.3723 -2.3644
254 Gibraltar United Kingdom 2020-03-14T16:33:03 1 0 1 36.1408 -5.3536
80   United Arab Emirates 2020-03-15T18:20:18 98 0 23 23.4241 53.8478
201   Ukraine 2020-03-13T22:22:02 3 1 0 48.3794 31.1656
24 New York US 2020-03-15T18:20:19 732 3 0 42.1657 -74.9481
26 Washington US 2020-03-15T02:13:21 643 40 1 47.4009 -121.4905
33 California US 2020-03-15T18:33:03 426 6 6 36.1162 -119.6816
55 Massachusetts US 2020-03-14T22:13:19 164 0 1 42.2302 -71.5301
66 Florida US 2020-03-15T18:20:19 115 4 0 27.7663 -81.6868
75 Colorado US 2020-03-14T22:13:32 131 1 0 39.0598 -105.3111
76 Georgia US 2020-03-15T18:20:19 99 1 0 33.0406 -83.6431
79 Louisiana US 2020-03-15T18:20:19 91 2 0 31.1695 -91.8678
84 New Jersey US 2020-03-15T18:20:19 98 2 0 40.2989 -74.521
86 Illinois US 2020-03-15T18:20:19 93 0 2 40.3495 -88.9861
88 Texas US 2020-03-15T18:20:19 72 0 0 31.0545 -97.5635
101 Pennsylvania US 2020-03-14T18:53:03 66 0 0 40.5908 -77.2098
103 Diamond Princess US 2020-03-10T02:33:04 46 0 0 35.4437 139.638
105 Virginia US 2020-03-15T18:20:19 45 1 0 37.7693 -78.17
112 Oregon US 2020-03-15T18:20:19 36 1 0 44.572 -122.0709
113 Minnesota US 2020-03-15T18:20:19 35 0 0 45.6945 -93.9002
115 Michigan US 2020-03-15T18:20:19 33 0 0 43.3266 -84.5361
117 North Carolina US 2020-03-15T18:20:19 33 0 0 35.6301 -79.8064
118 Tennessee US 2020-03-14T22:33:04 39 0 0 35.7478 -86.6923
119 Maryland US 2020-03-15T18:20:19 32 0 0 39.0639 -76.8021
122 Ohio US 2020-03-15T18:20:19 37 0 0 40.3888 -82.7649
125 Wisconsin US 2020-03-15T18:20:19 32 0 1 44.2685 -89.6165
130 Connecticut US 2020-03-15T18:20:19 24 0 0 41.5978 -72.7554
131 Utah US 2020-03-15T18:20:19 28 0 0 40.15 -111.8624
135 Grand Princess US 2020-03-10T02:33:04 21 0 0 37.6489 -122.6655
136 Nevada US 2020-03-14T22:33:03 24 0 0 38.3135 -117.0554
139 Indiana US 2020-03-15T18:20:19 20 0 0 39.8494 -86.2583
140 Rhode Island US 2020-03-14T18:53:03 20 0 0 41.6809 -71.5118
141 South Carolina US 2020-03-14T22:33:03 28 0 0 33.8569 -80.945
144 Iowa US 2020-03-15T18:20:19 18 0 0 42.0115 -93.2105
145 Kentucky US 2020-03-15T02:53:02 20 0 0 37.6681 -84.6701
147 Nebraska US 2020-03-15T18:20:19 17 0 0 41.1254 -98.2681
149 Arkansas US 2020-03-15T18:20:19 16 0 0 34.9697 -92.3731
150 District of Columbia US 2020-03-15T02:53:03 16 0 0 38.8974 -77.0268
154 New Mexico US 2020-03-15T02:53:03 13 0 0 34.8405 -106.2485
157 Alabama US 2020-03-15T18:20:19 12 0 0 32.3182 -86.9023
158 Arizona US 2020-03-14T18:13:23 13 0 1 33.7298 -111.4312
166 South Dakota US 2020-03-14T16:53:03 9 1 0 44.2998 -99.4388
170 Kansas US 2020-03-14T22:33:03 8 1 0 38.5266 -96.7265
175 Montana US 2020-03-15T18:20:19 7 0 0 46.9219 -110.4544
176 New Hampshire US 2020-03-14T16:53:03 13 0 0 43.4525 -71.5639
181 Delaware US 2020-03-14T18:13:20 7 0 0 39.3185 -75.5071
182 Hawaii US 2020-03-15T18:20:19 6 0 0 21.0943 -157.4983
183 Maine US 2020-03-15T18:20:19 12 0 0 44.6939 -69.3819
184 Mississippi US 2020-03-14T16:53:03 10 0 0 32.7416 -89.6787
187 Idaho US 2020-03-15T18:20:19 5 0 0 44.2405 -114.4788
188 Missouri US 2020-03-15T18:20:19 5 0 0 38.4561 -92.2884
189 Vermont US 2020-03-14T22:33:04 8 0 0 44.0459 -72.7107
194 Oklahoma US 2020-03-14T16:53:03 7 0 0 35.5653 -96.9289
198 Guam US 2020-03-15T18:20:19 3 0 0 13.4443 144.7937
199 Puerto Rico US 2020-03-14T18:33:03 5 0 0 18.2208 -66.5901
200 Wyoming US 2020-03-15T02:53:03 3 0 0 42.756 -107.3025
251 Alaska US 2020-03-13T14:53:03 1 0 0 61.3707 -152.4044
252 North Dakota US 2020-03-12T09:33:03 1 0 0 47.5289 -99.784
253 Virgin Islands, U.S. US 2020-03-14T16:15:18 1 0 0 18.3358 -64.8963
257 West Virginia US 2020-03-10T02:33:04 0 0 0 38.4912 -80.9545
180   Turkey 2020-03-15T18:20:18 6 0 0 38.9637 35.2433
143   Tunisia 2020-03-14T20:53:02 18 0 0 33.8869 9.5375
216   Trinidad and Tobago 2020-03-14T16:15:01 2 0 0 10.6918 -61.2225
250   Togo 2020-03-13T22:22:02 1 0 0 8.6195 0.8248
67   Thailand 2020-03-15T18:20:18 114 1 37 15.87 100.9925
92   Taiwan* 2020-03-15T06:53:03 59 1 20 23.7 121.0
8   Switzerland 2020-03-15T18:20:18 2200 14 4 46.8182 8.2275
15   Sweden 2020-03-15T18:20:18 1022 3 1 60.1282 18.6435
249   Suriname 2020-03-14T16:33:03 1 0 0 3.9193 -56.0278
248   Sudan 2020-03-14T01:13:32 1 1 0 12.8628 30.2176
161   Sri Lanka 2020-03-15T18:20:18 18 0 1 7.8731 80.7718
5   Spain 2020-03-15T18:20:18 7798 289 517 40.4637 -3.7492
97   South Africa 2020-03-15T18:20:18 51 0 0 -30.5595 22.9375
45   Slovenia 2020-03-15T18:20:18 219 1 0 46.1512 14.9955
95   Slovakia 2020-03-15T18:20:18 54 0 0 48.669 19.699
44   Singapore 2020-03-15T18:20:18 226 0 105 1.3521 103.8198
215   Seychelles 2020-03-15T07:33:03 2 0 0 -4.6796 55.492
102   Serbia 2020-03-14T22:53:02 48 0 0 44.0165 21.0059
164   Senegal 2020-03-13T23:33:05 24 0 1 14.4974 -14.4524
74   Saudi Arabia 2020-03-14T20:33:03 103 0 1 23.8859 45.0792
78   San Marino 2020-03-15T18:20:18 101 5 4 43.9424 12.4578
247   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
246   Saint Lucia 2020-03-14T16:15:18 2 0 0 13.9094 -60.9789
245   Rwanda 2020-03-15T06:41:54 1 0 0 -1.9403 29.8739
87   Russia 2020-03-15T18:20:18 63 0 8 61.524 105.3188
61   Romania 2020-03-15T18:20:18 131 0 9 45.9432 24.9668
174   Reunion 2020-03-15T18:20:19 7 0 0 -21.1151 55.5364
35   Qatar 2020-03-14T22:33:03 401 0 4 25.3548 51.1839
40   Portugal 2020-03-15T18:20:18 245 0 2 39.3999 -8.2245
64   Poland 2020-03-15T18:20:18 119 3 0 51.9194 19.1451
54   Philippines 2020-03-15T18:20:18 140 11 2 12.8797 121.774
108   Peru 2020-03-15T18:20:18 43 0 0 -9.19 -75.0152
179   Paraguay 2020-03-13T23:33:06 6 0 0 -23.4425 -58.4438
107   Panama 2020-03-15T18:20:18 43 1 0 8.538 -80.7821

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
);