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

3,437 rows sorted by Combined_Key

✎ 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 ▼
3271 3271       Armenia 3/29/20 23:08 40.0691 45.0382 424 3 30 391 Armenia
85 85 42005 Armstrong Pennsylvania US 3/29/20 23:08 40.81665618 -79.46290811 3 0 0 0 Armstrong, Pennsylvania, US
86 86 48011 Armstrong Texas US 3/29/20 23:08 34.96507426 -101.3574874 0 0 0 0 Armstrong, Texas, US
87 87 23003 Aroostook Maine US 3/29/20 23:08 46.65926321 -68.59841248 0 0 0 0 Aroostook, Maine, US
88 88 31005 Arthur Nebraska US 3/29/20 23:08 41.56896142 -101.6959559 0 0 0 0 Arthur, Nebraska, US
3179 3179     Aruba Netherlands 3/29/20 23:08 12.5211 -69.9683 50 0 1 49 Aruba, Netherlands
89 89 22005 Ascension Louisiana US 3/29/20 23:08 30.20406249 -90.9132841 139 2 0 0 Ascension, Louisiana, US
90 90 37009 Ashe North Carolina US 3/29/20 23:08 36.43296207 -81.49862729 0 0 0 0 Ashe, North Carolina, US
91 91 39005 Ashland Ohio US 3/29/20 23:08 40.84772277 -82.27280781 2 0 0 0 Ashland, Ohio, US
92 92 55003 Ashland Wisconsin US 3/29/20 23:08 46.31956891 -90.67837132 0 0 0 0 Ashland, Wisconsin, US
93 93 5003 Ashley Arkansas US 3/29/20 23:08 33.19153461 -91.7698471 1 0 0 0 Ashley, Arkansas, US
94 94 39007 Ashtabula Ohio US 3/29/20 23:08 41.70860332 -80.74830218 6 0 0 0 Ashtabula, Ohio, US
95 95 53003 Asotin Washington US 3/29/20 23:08 46.18894415 -117.2022851 0 0 0 0 Asotin, Washington, US
96 96 22007 Assumption Louisiana US 3/29/20 23:08 29.89946234 -91.06461642 14 0 0 0 Assumption, Louisiana, US
97 97 48013 Atascosa Texas US 3/29/20 23:08 28.89333001 -98.52730485 2 0 0 0 Atascosa, Texas, US
98 98 20005 Atchison Kansas US 3/29/20 23:08 39.53185661 -95.30870026 0 0 0 0 Atchison, Kansas, US
99 99 29005 Atchison Missouri US 3/29/20 23:08 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
100 100 39009 Athens Ohio US 3/29/20 23:08 39.33425634 -82.04278644 3 0 0 0 Athens, Ohio, US
101 101 13003 Atkinson Georgia US 3/29/20 23:08 31.29633502 -82.87545866 0 0 0 0 Atkinson, Georgia, US
102 102 34001 Atlantic New Jersey US 3/29/20 23:08 39.47538693 -74.65848483 24 0 0 0 Atlantic, New Jersey, US
103 103 40005 Atoka Oklahoma US 3/29/20 23:08 34.37366573 -96.03802487 0 0 0 0 Atoka, Oklahoma, US
104 104 28007 Attala Mississippi US 3/29/20 23:08 33.08658803 -89.57838564 9 0 0 0 Attala, Mississippi, US
105 105 29007 Audrain Missouri US 3/29/20 23:08 39.215877 -91.84242683 0 0 0 0 Audrain, Missouri, US
106 106 19009 Audubon Iowa US 3/29/20 23:08 41.6844628 -94.90581859 0 0 0 0 Audubon, Iowa, US
107 107 39011 Auglaize Ohio US 3/29/20 23:08 40.55998859 -84.2242143 2 0 0 0 Auglaize, Ohio, US
108 108 51015 Augusta Virginia US 3/29/20 23:08 38.16404586 -79.12461614 0 0 0 0 Augusta, Virginia, US
109 109 46003 Aurora South Dakota US 3/29/20 23:08 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
110 110 48015 Austin Texas US 3/29/20 23:08 29.88548725 -96.27736949 2 0 0 0 Austin, Texas, US
3180 3180     Australian Capital Territory Australia 3/29/20 23:14 -35.4735 149.0124 77 0 2 75 Australian Capital Territory, Australia
3272 3272       Austria 3/29/20 23:08 47.5162 14.5501 8788 86 479 8223 Austria
111 111 1001 Autauga Alabama US 3/29/20 23:08 32.53952745 -86.64408227 6 0 0 0 Autauga, Alabama, US
112 112 37011 Avery North Carolina US 3/29/20 23:08 36.07569796 -81.92308483 0 0 0 0 Avery, North Carolina, US
113 113 22009 Avoyelles Louisiana US 3/29/20 23:08 31.07796211 -92.00079449 13 0 0 0 Avoyelles, Louisiana, US
3273 3273       Azerbaijan 3/29/20 23:08 40.1431 47.5769 209 4 15 190 Azerbaijan
114 114 8009 Baca Colorado US 3/29/20 23:08 37.31940883 -102.5603223 1 0 0 0 Baca, Colorado, US
115 115 13005 Bacon Georgia US 3/29/20 23:08 31.55456473 -82.45936528 1 0 0 0 Bacon, Georgia, US
3274 3274       Bahamas 3/29/20 23:08 25.025885 -78.035889 11 0 1 10 Bahamas
3275 3275       Bahrain 3/29/20 23:08 26.0275 50.55 499 4 272 223 Bahrain
116 116 48017 Bailey Texas US 3/29/20 23:08 34.06854817 -102.8299707 0 0 0 0 Bailey, Texas, US
117 117 12003 Baker Florida US 3/29/20 23:08 30.33060121 -82.28467476 7 0 0 0 Baker, Florida, US
118 118 13007 Baker Georgia US 3/29/20 23:08 31.32669878 -84.44218806 1 1 0 0 Baker, Georgia, US
119 119 41001 Baker Oregon US 3/29/20 23:08 44.70915557 -117.6749883 0 0 0 0 Baker, Oregon, US
120 120 1003 Baldwin Alabama US 3/29/20 23:08 30.72774991 -87.72207058 19 1 0 0 Baldwin, Alabama, US
121 121 13009 Baldwin Georgia US 3/29/20 23:08 33.06882326 -83.24701748 2 0 0 0 Baldwin, Georgia, US
122 122 21007 Ballard Kentucky US 3/29/20 23:08 37.05842757 -88.99427697 0 0 0 0 Ballard, Kentucky, US
124 124 24510 Baltimore City Maryland US 3/29/20 23:08 39.30211911 -76.61151012 129 2 0 0 Baltimore City, Maryland, US
123 123 24005 Baltimore Maryland US 3/29/20 23:08 39.45784712 -76.62911955 162 1 0 0 Baltimore, Maryland, US
125 125 45009 Bamberg South Carolina US 3/29/20 23:08 33.21927586 -81.05659969 0 0 0 0 Bamberg, South Carolina, US
126 126 48019 Bandera Texas US 3/29/20 23:08 29.74619598 -99.24598147 0 0 0 0 Bandera, Texas, US
3276 3276       Bangladesh 3/29/20 23:08 23.685 90.3563 48 5 15 28 Bangladesh
127 127 13011 Banks Georgia US 3/29/20 23:08 34.35607081 -83.49644388 0 0 0 0 Banks, Georgia, US
128 128 31007 Banner Nebraska US 3/29/20 23:08 41.54634427 -103.7114332 0 0 0 0 Banner, Nebraska, US
129 129 16005 Bannock Idaho US 3/29/20 23:08 42.67002716 -112.2233311 3 0 0 0 Bannock, Idaho, US
130 130 26013 Baraga Michigan US 3/29/20 23:08 46.6720582 -88.36363591 0 0 0 0 Baraga, Michigan, US
3277 3277       Barbados 3/29/20 23:08 13.1939 -59.5432 33 0 0 33 Barbados
131 131 20007 Barber Kansas US 3/29/20 23:08 37.2288586 -98.68460053 0 0 0 0 Barber, Kansas, US
132 132 1005 Barbour Alabama US 3/29/20 23:08 31.868263 -85.3871286 0 0 0 0 Barbour, Alabama, US
133 133 54001 Barbour West Virginia US 3/29/20 23:08 39.1307219 -80.00350858 0 0 0 0 Barbour, West Virginia, US
134 134 38003 Barnes North Dakota US 3/29/20 23:08 46.93579637 -98.06605978 2 0 0 0 Barnes, North Dakota, US
135 135 25001 Barnstable Massachusetts US 3/29/20 23:08 41.72980578 -70.28854339 148 2 0 0 Barnstable, Massachusetts, US
136 136 45011 Barnwell South Carolina US 3/29/20 23:08 33.26679302 -81.43584352 0 0 0 0 Barnwell, South Carolina, US
137 137 21009 Barren Kentucky US 3/29/20 23:08 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
138 138 55005 Barron Wisconsin US 3/29/20 23:08 45.42372701 -91.84833627 0 0 0 0 Barron, Wisconsin, US
139 139 13013 Barrow Georgia US 3/29/20 23:08 33.99148694 -83.71436292 7 1 0 0 Barrow, Georgia, US
140 140 26015 Barry Michigan US 3/29/20 23:08 42.59513984 -85.30834519 1 0 0 0 Barry, Michigan, US
141 141 29009 Barry Missouri US 3/29/20 23:08 36.70978521 -93.82919888 1 0 0 0 Barry, Missouri, US
142 142 18005 Bartholomew Indiana US 3/29/20 23:08 39.20744865 -85.89558181 10 0 0 0 Bartholomew, Indiana, US
143 143 20009 Barton Kansas US 3/29/20 23:08 38.47889676 -98.75636726 0 0 0 0 Barton, Kansas, US
144 144 29011 Barton Missouri US 3/29/20 23:08 37.50207671 -94.34757022 0 0 0 0 Barton, Missouri, US
145 145 13015 Bartow Georgia US 3/29/20 23:08 34.23732119 -84.83887523 119 1 0 0 Bartow, Georgia, US
146 146 48021 Bastrop Texas US 3/29/20 23:08 30.10370699 -97.31206354 5 0 0 0 Bastrop, Texas, US
147 147 29013 Bates Missouri US 3/29/20 23:08 38.25271289 -94.34113157 2 0 0 0 Bates, Missouri, US
148 148 21011 Bath Kentucky US 3/29/20 23:08 38.14735938 -83.74588932 0 0 0 0 Bath, Kentucky, US
149 149 51017 Bath Virginia US 3/29/20 23:08 38.05852573 -79.73912095 0 0 0 0 Bath, Virginia, US
150 150 5005 Baxter Arkansas US 3/29/20 23:08 36.28784385 -92.33782872 1 0 0 0 Baxter, Arkansas, US
151 151 12005 Bay Florida US 3/29/20 23:08 30.26548745 -85.62122584 6 0 0 0 Bay, Florida, US
152 152 26017 Bay Michigan US 3/29/20 23:08 43.70639106 -83.98731479 5 0 0 0 Bay, Michigan, US
153 153 55007 Bayfield Wisconsin US 3/29/20 23:08 46.52868768 -91.19716729 2 0 0 0 Bayfield, Wisconsin, US
154 154 48023 Baylor Texas US 3/29/20 23:08 33.61640794 -99.21352901 0 0 0 0 Baylor, Texas, US
155 155 46005 Beadle South Dakota US 3/29/20 23:08 44.41464384 -98.27858469 20 0 0 0 Beadle, South Dakota, US
156 156 16007 Bear Lake Idaho US 3/29/20 23:08 42.28269683 -111.3289238 0 0 0 0 Bear Lake, Idaho, US
157 157 37013 Beaufort North Carolina US 3/29/20 23:08 35.48531943 -76.84325809 3 0 0 0 Beaufort, North Carolina, US
158 158 45013 Beaufort South Carolina US 3/29/20 23:08 32.39226291 -80.72619758 50 0 0 0 Beaufort, South Carolina, US
159 159 22011 Beauregard Louisiana US 3/29/20 23:08 30.64836518 -93.34173616 4 0 0 0 Beauregard, Louisiana, US
160 160 40007 Beaver Oklahoma US 3/29/20 23:08 36.7496847 -100.4758872 0 0 0 0 Beaver, Oklahoma, US
161 161 42007 Beaver Pennsylvania US 3/29/20 23:08 40.6825484 -80.34921611 28 0 0 0 Beaver, Pennsylvania, US
162 162 49001 Beaver Utah US 3/29/20 23:08 38.35657051 -113.2342232 1 0 0 0 Beaver, Utah, US
163 163 30001 Beaverhead Montana US 3/29/20 23:08 45.13434354 -112.8984694 0 0 0 0 Beaverhead, Montana, US
164 164 27005 Becker Minnesota US 3/29/20 23:08 46.93479392 -95.67158144 0 0 0 0 Becker, Minnesota, US
165 165 40009 Beckham Oklahoma US 3/29/20 23:08 35.26862449 -99.68128023 0 0 0 0 Beckham, Oklahoma, US
166 166 42009 Bedford Pennsylvania US 3/29/20 23:08 40.00522157 -78.48998442 0 0 0 0 Bedford, Pennsylvania, US
167 167 47003 Bedford Tennessee US 3/29/20 23:08 35.51123746 -86.45549096 1 0 0 0 Bedford, Tennessee, US
168 168 51019 Bedford Virginia US 3/29/20 23:08 37.3080028 -79.5281964 3 0 0 0 Bedford, Virginia, US
169 169 48025 Bee Texas US 3/29/20 23:08 28.41761668 -97.74215593 0 0 0 0 Bee, Texas, US
3181 3181     Beijing China 3/29/20 14:07 40.1824 116.4142 577 8 412 157 Beijing, China
3278 3278       Belarus 3/29/20 23:08 53.7098 27.9534 94 0 32 62 Belarus
3279 3279       Belgium 3/29/20 23:08 50.8333 4.469936 10836 431 1359 9046 Belgium
170 170 33001 Belknap New Hampshire US 3/29/20 23:08 43.51637314 -71.41684235 9 0 0 0 Belknap, New Hampshire, US
171 171 21013 Bell Kentucky US 3/29/20 23:08 36.73355174 -83.67766671 0 0 0 0 Bell, Kentucky, US
172 172 48027 Bell Texas US 3/29/20 23:08 31.03736027 -97.4785025 28 1 0 0 Bell, Texas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-29-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
);