04-02-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

2,572 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
101 101 54001 Barbour West Virginia US 4/2/20 23:25 39.1307219 -80.00350858 1 0 0 0 Barbour, West Virginia, US
102 102 38003 Barnes North Dakota US 4/2/20 23:25 46.93579637 -98.06605978 2 0 0 0 Barnes, North Dakota, US
103 103 25001 Barnstable Massachusetts US 4/2/20 23:25 41.72980578 -70.28854339 283 3 0 0 Barnstable, Massachusetts, US
104 104 45011 Barnwell South Carolina US 4/2/20 23:25 33.26679302 -81.43584352 2 0 0 0 Barnwell, South Carolina, US
105 105 21009 Barren Kentucky US 4/2/20 23:25 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
106 106 13013 Barrow Georgia US 4/2/20 23:25 33.99148694 -83.71436292 20 2 0 0 Barrow, Georgia, US
107 107 26015 Barry Michigan US 4/2/20 23:25 42.59513984 -85.30834519 4 0 0 0 Barry, Michigan, US
108 108 29009 Barry Missouri US 4/2/20 23:25 36.70978521 -93.82919888 1 0 0 0 Barry, Missouri, US
109 109 18005 Bartholomew Indiana US 4/2/20 23:25 39.20744865 -85.89558181 15 0 0 0 Bartholomew, Indiana, US
110 110 20009 Barton Kansas US 4/2/20 23:25 38.47889676 -98.75636726 2 0 0 0 Barton, Kansas, US
111 111 13015 Bartow Georgia US 4/2/20 23:25 34.23732119 -84.83887523 147 4 0 0 Bartow, Georgia, US
112 112 48021 Bastrop Texas US 4/2/20 23:25 30.10370699 -97.31206354 10 0 0 0 Bastrop, Texas, US
113 113 29013 Bates Missouri US 4/2/20 23:25 38.25271289 -94.34113157 2 0 0 0 Bates, Missouri, US
114 114 5005 Baxter Arkansas US 4/2/20 23:25 36.28784385 -92.33782872 1 0 0 0 Baxter, Arkansas, US
115 115 12005 Bay Florida US 4/2/20 23:25 30.26548745 -85.62122584 15 0 0 0 Bay, Florida, US
116 116 26017 Bay Michigan US 4/2/20 23:25 43.70639106 -83.98731479 16 0 0 0 Bay, Michigan, US
117 117 55007 Bayfield Wisconsin US 4/2/20 23:25 46.52868768 -91.19716729 3 0 0 0 Bayfield, Wisconsin, US
118 118 46005 Beadle South Dakota US 4/2/20 23:25 44.41464384 -98.27858469 21 1 0 0 Beadle, South Dakota, US
119 119 37013 Beaufort North Carolina US 4/2/20 23:25 35.48531943 -76.84325809 7 0 0 0 Beaufort, North Carolina, US
120 120 45013 Beaufort South Carolina US 4/2/20 23:25 32.39226291 -80.72619758 130 2 0 0 Beaufort, South Carolina, US
121 121 22011 Beauregard Louisiana US 4/2/20 23:25 30.64836518 -93.34173616 10 0 0 0 Beauregard, Louisiana, US
122 122 42007 Beaver Pennsylvania US 4/2/20 23:25 40.6825484 -80.34921611 55 2 0 0 Beaver, Pennsylvania, US
123 123 40009 Beckham Oklahoma US 4/2/20 23:25 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
124 124 42009 Bedford Pennsylvania US 4/2/20 23:25 40.00522157 -78.48998442 3 0 0 0 Bedford, Pennsylvania, US
125 125 47003 Bedford Tennessee US 4/2/20 23:25 35.51123746 -86.45549096 6 0 0 0 Bedford, Tennessee, US
126 126 51019 Bedford Virginia US 4/2/20 23:25 37.3080028 -79.5281964 3 0 0 0 Bedford, Virginia, US
127 127 33001 Belknap New Hampshire US 4/2/20 23:25 43.51637314 -71.41684235 13 0 0 0 Belknap, New Hampshire, US
128 128 48027 Bell Texas US 4/2/20 23:25 31.03736027 -97.4785025 51 1 0 0 Bell, Texas, US
129 129 39013 Belmont Ohio US 4/2/20 23:25 40.01625942 -80.9924051 12 0 0 0 Belmont, Ohio, US
130 130 27007 Beltrami Minnesota US 4/2/20 23:25 47.97373527 -94.93732139 4 0 0 0 Beltrami, Minnesota, US
131 131 13017 Ben Hill Georgia US 4/2/20 23:25 31.76095874 -83.22145359 3 0 0 0 Ben Hill, Georgia, US
132 132 50003 Bennington Vermont US 4/2/20 23:25 43.03519828 -73.09048868 17 0 0 0 Bennington, Vermont, US
133 133 5007 Benton Arkansas US 4/2/20 23:25 36.33644656 -94.25680817 40 0 0 0 Benton, Arkansas, US
134 134 18007 Benton Indiana US 4/2/20 23:25 40.60626947 -87.31093999 0 0 0 0 Benton, Indiana, US
135 135 19011 Benton Iowa US 4/2/20 23:25 42.08011739 -92.06463573 7 0 0 0 Benton, Iowa, US
136 136 27009 Benton Minnesota US 4/2/20 23:25 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
137 137 28009 Benton Mississippi US 4/2/20 23:25 34.81681228 -89.18945516 5 0 0 0 Benton, Mississippi, US
138 138 29015 Benton Missouri US 4/2/20 23:25 38.29503305 -93.28756116 3 0 0 0 Benton, Missouri, US
139 139 41003 Benton Oregon US 4/2/20 23:25 44.49167306 -123.4316987 15 1 0 0 Benton, Oregon, US
140 140 47005 Benton Tennessee US 4/2/20 23:25 36.07110411 -88.06849355 4 0 0 0 Benton, Tennessee, US
141 141 53005 Benton Washington US 4/2/20 23:25 46.23946995 -119.5120834 130 19 0 0 Benton, Washington, US
142 142 34003 Bergen New Jersey US 4/2/20 23:25 40.96010917 -74.07164325 4099 120 0 0 Bergen, New Jersey, US
143 143 45015 Berkeley South Carolina US 4/2/20 23:25 33.20222596 -79.94654523 33 0 0 0 Berkeley, South Carolina, US
144 144 54003 Berkeley West Virginia US 4/2/20 23:25 39.46704621 -78.02414609 27 0 0 0 Berkeley, West Virginia, US
145 145 42011 Berks Pennsylvania US 4/2/20 23:25 40.41570541 -75.92457766 168 1 0 0 Berks, Pennsylvania, US
146 146 25003 Berkshire Massachusetts US 4/2/20 23:25 42.37428441 -73.20524838 213 5 0 0 Berkshire, Massachusetts, US
147 147 35001 Bernalillo New Mexico US 4/2/20 23:25 35.05163625 -106.6703554 148 4 0 0 Bernalillo, New Mexico, US
148 148 13019 Berrien Georgia US 4/2/20 23:25 31.27590016 -83.2252992 3 0 0 0 Berrien, Georgia, US
149 149 26021 Berrien Michigan US 4/2/20 23:25 41.95447397 -86.4131308 40 1 0 0 Berrien, Michigan, US
150 150 37015 Bertie North Carolina US 4/2/20 23:25 36.0688473 -76.96545943 6 1 0 0 Bertie, North Carolina, US
151 151 48029 Bexar Texas US 4/2/20 23:25 29.44928723 -98.52019748 229 9 0 0 Bexar, Texas, US
152 152 1007 Bibb Alabama US 4/2/20 23:25 32.99642064 -87.1251146 4 0 0 0 Bibb, Alabama, US
153 153 13021 Bibb Georgia US 4/2/20 23:25 32.80904227 -83.70489165 24 1 0 0 Bibb, Georgia, US
154 154 22013 Bienville Louisiana US 4/2/20 23:25 32.34569994 -93.05398492 8 1 0 0 Bienville, Louisiana, US
155 155 27011 Big Stone Minnesota US 4/2/20 23:25 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
156 156 16011 Bingham Idaho US 4/2/20 23:25 43.2167288 -112.3978437 2 0 0 0 Bingham, Idaho, US
157 157 19013 Black Hawk Iowa US 4/2/20 23:25 42.4704581 -92.30524729 8 0 0 0 Black Hawk, Iowa, US
158 158 18009 Blackford Indiana US 4/2/20 23:25 40.47388153 -85.32499702 1 0 0 0 Blackford, Indiana, US
159 159 37017 Bladen North Carolina US 4/2/20 23:25 34.61296243 -78.56180059 1 0 0 0 Bladen, North Carolina, US
160 160 16013 Blaine Idaho US 4/2/20 23:25 43.4085812 -113.9752658 256 2 0 0 Blaine, Idaho, US
161 161 42013 Blair Pennsylvania US 4/2/20 23:25 40.47961444 -78.34917412 4 0 0 0 Blair, Pennsylvania, US
162 162 48031 Blanco Texas US 4/2/20 23:25 30.26640707 -98.3999852 1 0 0 0 Blanco, Texas, US
163 163 13023 Bleckley Georgia US 4/2/20 23:25 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
164 164 47007 Bledsoe Tennessee US 4/2/20 23:25 35.59942968 -85.20611967 2 0 0 0 Bledsoe, Tennessee, US
165 165 1009 Blount Alabama US 4/2/20 23:25 33.98210918 -86.56790593 9 0 0 0 Blount, Alabama, US
166 166 47009 Blount Tennessee US 4/2/20 23:25 35.68938198 -83.92847788 32 0 0 0 Blount, Tennessee, US
167 167 27013 Blue Earth Minnesota US 4/2/20 23:25 44.03554215 -94.06699781 10 0 0 0 Blue Earth, Minnesota, US
168 168 28011 Bolivar Mississippi US 4/2/20 23:25 33.79696941 -90.87372121 27 1 0 0 Bolivar, Mississippi, US
169 169 29017 Bollinger Missouri US 4/2/20 23:25 37.32449052 -90.02725304 1 0 0 0 Bollinger, Missouri, US
170 170 46009 Bon Homme South Dakota US 4/2/20 23:25 42.98914167 -97.88592746 1 0 0 0 Bon Homme, South Dakota, US
171 171 17005 Bond Illinois US 4/2/20 23:25 38.88829622 -89.43534887 3 0 0 0 Bond, Illinois, US
172 172 16017 Bonner Idaho US 4/2/20 23:25 48.29996017 -116.6017932 1 0 0 0 Bonner, Idaho, US
173 173 16019 Bonneville Idaho US 4/2/20 23:25 43.38713372 -111.6161537 2 0 0 0 Bonneville, Idaho, US
174 174 5009 Boone Arkansas US 4/2/20 23:25 36.3084504 -93.09374925 1 0 0 0 Boone, Arkansas, US
175 175 18011 Boone Indiana US 4/2/20 23:25 40.0509304 -86.46841646 32 0 0 0 Boone, Indiana, US
176 176 19015 Boone Iowa US 4/2/20 23:25 42.03657094 -93.9313999 2 0 0 0 Boone, Iowa, US
177 177 21015 Boone Kentucky US 4/2/20 23:25 38.97065142 -84.72615357 8 0 0 0 Boone, Kentucky, US
178 178 29019 Boone Missouri US 4/2/20 23:25 38.99186229 -92.30723575 69 1 0 0 Boone, Missouri, US
179 179 22015 Bossier Louisiana US 4/2/20 23:25 32.67932307 -93.60460152 87 2 0 0 Bossier, Louisiana, US
180 180 51023 Botetourt Virginia US 4/2/20 23:25 37.55531756 -79.80982182 8 0 0 0 Botetourt, Virginia, US
181 181 8013 Boulder Colorado US 4/2/20 23:25 40.09313619 -105.3546767 114 2 0 0 Boulder, Colorado, US
182 182 20011 Bourbon Kansas US 4/2/20 23:25 37.85508555 -94.84865997 3 0 0 0 Bourbon, Kansas, US
183 183 21017 Bourbon Kentucky US 4/2/20 23:25 38.2054607 -84.21827874 2 1 0 0 Bourbon, Kentucky, US
184 184 48037 Bowie Texas US 4/2/20 23:25 33.44626922 -94.41834132 9 1 0 0 Bowie, Texas, US
185 185 49003 Box Elder Utah US 4/2/20 23:25 41.52106798 -113.0832816 7 0 0 0 Box Elder, Utah, US
186 186 21019 Boyd Kentucky US 4/2/20 23:25 38.36176608 -82.68652187 4 0 0 0 Boyd, Kentucky, US
187 187 21021 Boyle Kentucky US 4/2/20 23:25 37.62680923 -84.8633779 4 0 0 0 Boyle, Kentucky, US
188 188 21023 Bracken Kentucky US 4/2/20 23:25 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
189 189 12007 Bradford Florida US 4/2/20 23:25 29.95079741 -82.16611613 5 0 0 0 Bradford, Florida, US
190 190 42015 Bradford Pennsylvania US 4/2/20 23:25 41.78869215 -76.51570822 8 0 0 0 Bradford, Pennsylvania, US
191 191 5011 Bradley Arkansas US 4/2/20 23:25 33.46755808 -92.15980837 4 0 0 0 Bradley, Arkansas, US
192 192 47011 Bradley Tennessee US 4/2/20 23:25 35.15739424 -84.857186 18 0 0 0 Bradley, Tennessee, US
193 193 26023 Branch Michigan US 4/2/20 23:25 41.91600556 -85.05929476 5 0 0 0 Branch, Michigan, US
194 194 48039 Brazoria Texas US 4/2/20 23:25 29.18757369 -95.44563172 109 1 0 0 Brazoria, Texas, US
195 195 48041 Brazos Texas US 4/2/20 23:25 30.6636448 -96.30205577 68 4 0 0 Brazos, Texas, US
196 196 21025 Breathitt Kentucky US 4/2/20 23:25 37.52333168 -83.31959161 2 0 0 0 Breathitt, Kentucky, US
197 197 21027 Breckinridge Kentucky US 4/2/20 23:25 37.77377239 -86.42885017 2 0 0 0 Breckinridge, Kentucky, US
198 198 19017 Bremer Iowa US 4/2/20 23:25 42.77461496 -92.31795937 1 0 0 0 Bremer, Iowa, US
199 199 12009 Brevard Florida US 4/2/20 23:25 28.29409504 -80.73091022 49 0 0 0 Brevard, Florida, US
200 200 25005 Bristol Massachusetts US 4/2/20 23:25 41.79228404 -71.10872211 424 3 0 0 Bristol, Massachusetts, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-02-2020] (
   [FIPS] INTEGER,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] FLOAT,
   [Long_] FLOAT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT
);