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 Last Update

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update ▼ Confirmed Deaths Recovered Latitude Longitude
110 San Benito, CA US 2020-02-03T03:53:02 2 0 0 36.5761 -120.9876
140   Sri Lanka 2020-02-08T03:43:03 1 0 1 7.0 81.0
132 Tibet Mainland China 2020-02-12T06:43:02 1 0 1 31.6927 88.0924
95   Philippines 2020-02-12T07:43:02 3 1 1 13.0 122.0
120   Cambodia 2020-02-12T07:43:02 1 0 1 11.55 104.9167
135   Nepal 2020-02-12T14:43:03 1 0 1 28.1667 84.25
122 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
150 San Antonio, TX US 2020-02-13T18:53:02 1 0 0 29.4241 -98.4936
60 Qinghai Mainland China 2020-02-21T04:43:02 18 0 18 35.7452 95.9956
146 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0 40.745 -123.8695
111 San Diego County, CA US 2020-02-21T05:43:02 2 0 1 32.7157 -117.1611
114   Afghanistan 2020-02-24T23:33:02 4 0 0 33.0 65.0
158 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
159 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
160 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 38.2721 -121.9399
62   Vietnam 2020-02-25T08:53:02 16 0 16 16.0 108.0
153 Tempe, AZ US 2020-02-25T21:23:03 1 0 1 33.4255 -111.94
137   North Macedonia 2020-02-27T16:23:03 1 0 0 41.6086 21.7453
109 Sacramento County, CA US 2020-02-27T20:33:02 2 0 0 38.4747 -121.3542
121 Montreal, QC Canada 2020-02-28T05:23:07 1 0 0 45.5017 -73.5673
130   Lithuania 2020-02-28T16:23:03 1 0 0 55.1694 23.8813
136   Nigeria 2020-02-28T16:23:03 1 0 0 9.082 8.6753
144 Boston, MA US 2020-02-28T21:13:12 1 0 1 42.3601 -71.0589
133   Monaco 2020-02-29T00:33:01 1 0 0 43.7333 7.4167
157 From Diamond Princess Australia 2020-02-29T02:03:10 0 0 0 35.4437 139.638
92   Azerbaijan 2020-03-01T02:43:03 3 0 0 40.1431 47.5769
99 Western Australia Australia 2020-03-01T02:43:03 2 1 0 -31.9505 115.8605
93   Georgia 2020-03-01T15:43:03 3 0 0 42.3154 43.3569
117   Armenia 2020-03-01T19:53:02 1 0 0 40.0691 45.0382
82   Finland 2020-03-01T23:23:02 6 0 1 64.0 26.0
100   Egypt 2020-03-01T23:33:03 2 0 1 26.0 30.0
29 Guizhou Mainland China 2020-03-02T01:13:06 146 2 114 26.8154 106.8748
149 New York City, NY US 2020-03-02T01:53:03 1 0 0 40.7128 -74.006
151 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
108 Providence, RI US 2020-03-02T03:43:02 2 0 0 41.824 -71.4128
47   Thailand 2020-03-02T06:23:04 43 1 31 15.0 101.0
124   Dominican Republic 2020-03-02T16:33:02 1 0 0 18.7357 -70.1627
103   Indonesia 2020-03-02T18:03:04 2 0 0 -0.7893 113.9213
46 Unassigned Location (From Diamond Princess) US 2020-03-02T19:53:03 45 0 0 35.4437 139.638
115   Andorra 2020-03-02T20:23:16 1 0 0 42.5063 1.5218
154 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
42   Kuwait 2020-03-02T20:33:02 56 0 0 29.5 47.75
91 Cook County, IL US 2020-03-02T20:33:02 4 0 2 41.7377 -87.6976
119 Tasmania Australia 2020-03-02T20:53:02 1 0 0 -41.4545 145.9707
152 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
96   Russia 2020-03-02T21:23:04 3 0 2 60.0 90.0
139   Saudi Arabia 2020-03-02T23:53:02 1 0 0 24.0 45.0
131   Luxembourg 2020-03-03T00:23:16 1 0 0 49.8144 6.1317
112 San Mateo, CA US 2020-03-03T00:43:02 2 0 0 37.563 -122.3255
113 Washington County, OR US 2020-03-03T03:03:02 2 0 0 45.547 -123.1386
12 Diamond Princess cruise ship Others 2020-03-03T03:13:06 706 6 10 35.4437 139.638
104 Fulton County, GA US 2020-03-03T03:33:02 2 0 0 33.8034 -84.3963
27 Yunnan Mainland China 2020-03-03T03:43:02 174 2 169 24.974 101.487
86   Pakistan 2020-03-03T04:33:03 5 0 0 30.3753 69.3451
48 Taiwan Taiwan 2020-03-03T06:43:02 42 1 12 23.7 121.0
85   Mexico 2020-03-03T10:03:04 5 0 1 23.0 -102.0
30 Tianjin Mainland China 2020-03-03T11:43:02 136 3 124 39.3054 117.323
74 Macau Macau 2020-03-03T12:33:02 10 0 9 22.1667 113.55
32 Liaoning Mainland China 2020-03-03T14:33:03 125 1 106 41.2956 122.6085
142 Norfolk County, MA US 2020-03-03T14:33:03 1 0 0 42.1767 -71.1449
33   Singapore 2020-03-03T15:23:03 110 0 78 1.2833 103.8333
68 Queensland Australia 2020-03-03T15:23:03 11 0 1 -28.0167 153.4
127   Jordan 2020-03-03T15:33:02 1 0 0 31.24 36.51
134   Morocco 2020-03-03T15:33:02 1 0 0 31.7917 -7.0926
156   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
147 Madison, WI US 2020-03-03T15:53:03 1 0 1 43.0731 -89.4012
148 Maricopa County, AZ US 2020-03-03T17:33:02 1 0 0 33.2918 -112.4291
106 Hillsborough, FL US 2020-03-03T18:33:02 2 0 0 27.9904 -82.3018
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
31 Shanxi Mainland China 2020-03-03T23:13:05 133 0 124 37.5777 112.2922
69 Santa Clara, CA US 2020-03-03T23:33:03 11 0 1 37.3541 -121.9552
105 Grafton County, NH US 2020-03-03T23:33:03 2 0 0 43.9088 -71.826
55   United Arab Emirates 2020-03-03T23:43:02 27 0 5 24.0 54.0
101   Estonia 2020-03-03T23:53:03 2 0 0 58.5953 25.0136
143 Berkeley, CA US 2020-03-03T23:53:03 1 0 0 37.8715 -122.273
72   Denmark 2020-03-04T00:03:15 10 0 0 56.2639 9.5018
78   Qatar 2020-03-04T00:03:15 8 0 0 25.3548 51.1839
24 Guangxi Mainland China 2020-03-04T00:13:08 252 2 210 23.8298 108.7881
6 Henan Mainland China 2020-03-04T00:33:05 1272 22 1234 33.882 113.614
89   Romania 2020-03-04T00:53:02 4 0 1 46.0 25.0
10 Jiangxi Mainland China 2020-03-04T01:33:07 935 1 884 27.614 115.7221
41 Ningxia Mainland China 2020-03-04T01:33:07 75 0 69 37.2692 106.1655
116   Argentina 2020-03-04T01:33:07 1 0 0 -38.4161 -63.6167
123   Chile 2020-03-04T01:33:07 1 0 0 -35.6751 -71.543
128   Latvia 2020-03-04T01:33:07 1 0 0 56.8796 24.6032
129   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
141   Tunisia 2020-03-04T01:33:07 1 0 0 34.0 9.0
98 Orange County, CA US 2020-03-04T02:13:11 3 0 0 33.7879 -117.8531
97   Saint Barthelemy 2020-03-04T02:43:03 3 0 0 17.9 -62.8333
18 Shanghai Mainland China 2020-03-04T04:13:08 338 3 298 31.202 121.4491
67 British Columbia Canada 2020-03-04T04:23:05 12 0 3 49.2827 -123.1207
145 Contra Costa County, CA US 2020-03-04T04:23:05 1 0 0 37.8534 -121.9018
5 Guangdong Mainland China 2020-03-04T10:03:19 1350 7 1133 23.3417 113.4244
7 Zhejiang Mainland China 2020-03-04T10:03:19 1213 1 1114 29.1832 120.0934
9 Anhui Mainland China 2020-03-04T10:03:19 990 6 956 31.8257 117.2264
20 Hebei Mainland China 2020-03-04T10:03:19 318 6 301 38.0428 114.5149
28 Hainan Mainland China 2020-03-04T10:03:19 168 5 158 19.1959 109.7453
35 Jilin Mainland China 2020-03-04T10:03:19 93 1 86 43.6661 126.1923
4   Iran 2020-03-04T12:33:03 2922 92 552 32.0 53.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
);