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

160 rows sorted by Longitude

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude ▼
146 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0 40.745 -123.8695
113 Washington County, OR US 2020-03-03T03:03:02 2 0 0 45.547 -123.1386
67 British Columbia Canada 2020-03-04T04:23:05 12 0 3 49.2827 -123.1207
152 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
112 San Mateo, CA US 2020-03-03T00:43:02 2 0 0 37.563 -122.3255
143 Berkeley, CA US 2020-03-03T23:53:03 1 0 0 37.8715 -122.273
52 King County, WA US 2020-03-04T19:53:02 31 9 1 47.548 -121.9836
69 Santa Clara, CA US 2020-03-03T23:33:03 11 0 1 37.3541 -121.9552
160 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 38.2721 -121.9399
145 Contra Costa County, CA US 2020-03-04T04:23:05 1 0 0 37.8534 -121.9018
79 Snohomish County, WA US 2020-03-04T19:53:02 8 1 0 48.033 -121.8339
109 Sacramento County, CA US 2020-02-27T20:33:02 2 0 0 38.4747 -121.3542
110 San Benito, CA US 2020-02-03T03:53:02 2 0 0 36.5761 -120.9876
107 Placer County, CA US 2020-03-04T19:53:02 2 1 0 39.0916 -120.8039
154 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
80 Los Angeles, CA US 2020-03-04T18:13:18 7 0 0 34.0522 -118.2437
98 Orange County, CA US 2020-03-04T02:13:11 3 0 0 33.7879 -117.8531
111 San Diego County, CA US 2020-02-21T05:43:02 2 0 1 32.7157 -117.1611
148 Maricopa County, AZ US 2020-03-03T17:33:02 1 0 0 33.2918 -112.4291
153 Tempe, AZ US 2020-02-25T21:23:03 1 0 1 33.4255 -111.94
85   Mexico 2020-03-03T10:03:04 5 0 1 23.0 -102.0
158 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
150 San Antonio, TX US 2020-02-13T18:53:02 1 0 0 29.4241 -98.4936
159 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
147 Madison, WI US 2020-03-03T15:53:03 1 0 1 43.0731 -89.4012
91 Cook County, IL US 2020-03-02T20:33:02 4 0 2 41.7377 -87.6976
104 Fulton County, GA US 2020-03-03T03:33:02 2 0 0 33.8034 -84.3963
151 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
106 Hillsborough, FL US 2020-03-03T18:33:02 2 0 0 27.9904 -82.3018
122 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
59 Toronto, ON Canada 2020-03-03T20:03:08 19 0 2 43.6532 -79.3832
155 Wake County, NC US 2020-03-03T20:53:02 1 0 0 35.8032 -78.5661
73   Ecuador 2020-03-04T19:33:03 10 0 0 -1.8312 -78.1834
149 New York City, NY US 2020-03-02T01:53:03 1 0 0 40.7128 -74.006
75 Westchester County, NY US 2020-03-04T21:23:10 10 0 0 41.122 -73.7949
121 Montreal, QC Canada 2020-02-28T05:23:07 1 0 0 45.5017 -73.5673
105 Grafton County, NH US 2020-03-03T23:33:03 2 0 0 43.9088 -71.826
123   Chile 2020-03-04T01:33:07 1 0 0 -35.6751 -71.543
108 Providence, RI US 2020-03-02T03:43:02 2 0 0 41.824 -71.4128
142 Norfolk County, MA US 2020-03-03T14:33:03 1 0 0 42.1767 -71.1449
144 Boston, MA US 2020-02-28T21:13:12 1 0 1 42.3601 -71.0589
124   Dominican Republic 2020-03-02T16:33:02 1 0 0 18.7357 -70.1627
116   Argentina 2020-03-04T01:33:07 1 0 0 -38.4161 -63.6167
97   Saint Barthelemy 2020-03-04T02:43:03 3 0 0 17.9 -62.8333
88   Brazil 2020-03-04T20:33:02 4 0 0 -14.235 -51.9253
56   Iceland 2020-03-04T19:33:03 26 0 0 64.9631 -19.0208
90   Senegal 2020-03-04T20:43:02 4 0 0 14.4974 -14.4524
87   Portugal 2020-03-04T12:43:03 5 0 0 39.3999 -8.2245
83   Ireland 2020-03-04T21:13:07 6 0 0 53.1424 -7.6921
134   Morocco 2020-03-03T15:33:02 1 0 0 31.7917 -7.0926
125   Faroe Islands 2020-03-04T12:53:03 1 0 0 61.8926 -6.9118
126   Gibraltar 2020-03-04T13:03:13 1 0 0 36.1408 -5.3536
26   Spain 2020-03-04T20:43:02 222 2 2 40.0 -4.0
38   UK 2020-03-04T19:33:03 85 0 8 55.0 -3.0
115   Andorra 2020-03-02T20:23:16 1 0 0 42.5063 1.5218
66   Algeria 2020-03-04T19:33:03 12 0 0 28.0339 1.6596
22   France 2020-03-04T20:43:02 285 4 12 47.0 2.0
57   Belgium 2020-03-04T12:33:03 23 0 1 50.8333 4.0
49   Netherlands 2020-03-04T12:33:03 38 0 0 52.1326 5.2913
131   Luxembourg 2020-03-03T00:23:16 1 0 0 49.8144 6.1317
133   Monaco 2020-02-29T00:33:01 1 0 0 43.7333 7.4167
37   Switzerland 2020-03-04T19:33:03 90 0 3 46.8182 8.2275
43   Norway 2020-03-04T19:33:03 56 0 0 60.472 8.4689
136   Nigeria 2020-02-28T16:23:03 1 0 0 9.082 8.6753
23   Germany 2020-03-04T19:33:03 262 0 16 51.0 9.0
141   Tunisia 2020-03-04T01:33:07 1 0 0 34.0 9.0
72   Denmark 2020-03-04T00:03:15 10 0 0 56.2639 9.5018
129   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
3   Italy 2020-03-04T19:23:03 3089 107 276 43.0 12.0
61   San Marino 2020-03-04T19:33:03 16 1 0 43.9424 12.4578
53   Austria 2020-03-04T19:33:03 29 0 0 47.5162 14.5501
77   Czech Republic 2020-03-04T19:33:03 8 0 0 49.8175 15.473
71   Croatia 2020-03-04T16:53:02 10 0 0 45.1667 15.5
51   Sweden 2020-03-04T12:33:03 35 0 0 63.0 16.0
138   Poland 2020-03-04T15:13:18 1 0 0 51.9194 19.1451
102   Hungary 2020-03-04T19:33:03 2 0 0 47.1625 19.5033
137   North Macedonia 2020-02-27T16:23:03 1 0 0 41.6086 21.7453
76   Greece 2020-03-04T19:33:03 9 0 0 39.0742 21.8243
130   Lithuania 2020-02-28T16:23:03 1 0 0 55.1694 23.8813
128   Latvia 2020-03-04T01:33:07 1 0 0 56.8796 24.6032
89   Romania 2020-03-04T00:53:02 4 0 1 46.0 25.0
101   Estonia 2020-03-03T23:53:03 2 0 0 58.5953 25.0136
82   Finland 2020-03-01T23:23:02 6 0 1 64.0 26.0
81   Belarus 2020-03-04T12:43:03 6 0 0 53.7098 27.9534
100   Egypt 2020-03-01T23:33:03 2 0 1 26.0 30.0
156   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
63   Israel 2020-03-04T12:43:03 15 0 0 31.0 35.0
65   Lebanon 2020-03-04T16:53:02 13 0 1 33.8547 35.8623
127   Jordan 2020-03-03T15:33:02 1 0 0 31.24 36.51
93   Georgia 2020-03-01T15:43:03 3 0 0 42.3154 43.3569
50   Iraq 2020-03-04T20:43:02 35 2 0 33.0 44.0
139   Saudi Arabia 2020-03-02T23:53:02 1 0 0 24.0 45.0
117   Armenia 2020-03-01T19:53:02 1 0 0 40.0691 45.0382
92   Azerbaijan 2020-03-01T02:43:03 3 0 0 40.1431 47.5769
42   Kuwait 2020-03-02T20:33:02 56 0 0 29.5 47.75
44   Bahrain 2020-03-04T19:33:03 52 0 0 26.0275 50.55
78   Qatar 2020-03-04T00:03:15 8 0 0 25.3548 51.1839
4   Iran 2020-03-04T12:33:03 2922 92 552 32.0 53.0
55   United Arab Emirates 2020-03-03T23:43:02 27 0 5 24.0 54.0
64   Oman 2020-03-04T19:33:03 15 0 2 21.0 57.0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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