covid_casesdeaths_reshaped_bln

Table actions
Data provided via a collaboration between USAFacts and Big Local News. This is an ongoing effort to collect and distribute county-level data on confirmed coronavirus cases and deaths. Please cite USAFacts as the data provider. The three CSV files are the current version and will be updated daily around 8 a.m. The zipped archives are prior versions with a date stamp of when they were uploaded by Big Local News. See README for additional details

Data source: Big Local News · About: big-local-datasette

1,191,735 rows sorted by County Name

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid countyFIPS County Name ▼ State stateFIPS date cases deaths
2360 2360 45001 Abbeville County SC 45 1/22/20 0 0
5555 5555 45001 Abbeville County SC 45 1/23/20 0 0
8750 8750 45001 Abbeville County SC 45 1/24/20 0 0
11945 11945 45001 Abbeville County SC 45 1/25/20 0 0
15140 15140 45001 Abbeville County SC 45 1/26/20 0 0
18335 18335 45001 Abbeville County SC 45 1/27/20 0 0
21530 21530 45001 Abbeville County SC 45 1/28/20 0 0
24725 24725 45001 Abbeville County SC 45 1/29/20 0 0
27920 27920 45001 Abbeville County SC 45 1/30/20 0 0
31115 31115 45001 Abbeville County SC 45 1/31/20 0 0
34310 34310 45001 Abbeville County SC 45 2/1/20 0 0
37505 37505 45001 Abbeville County SC 45 2/2/20 0 0
40700 40700 45001 Abbeville County SC 45 2/3/20 0 0
43895 43895 45001 Abbeville County SC 45 2/4/20 0 0
47090 47090 45001 Abbeville County SC 45 2/5/20 0 0
50285 50285 45001 Abbeville County SC 45 2/6/20 0 0
53480 53480 45001 Abbeville County SC 45 2/7/20 0 0
56675 56675 45001 Abbeville County SC 45 2/8/20 0 0
59870 59870 45001 Abbeville County SC 45 2/9/20 0 0
63065 63065 45001 Abbeville County SC 45 2/10/20 0 0
66260 66260 45001 Abbeville County SC 45 2/11/20 0 0
69455 69455 45001 Abbeville County SC 45 2/12/20 0 0
72650 72650 45001 Abbeville County SC 45 2/13/20 0 0
75845 75845 45001 Abbeville County SC 45 2/14/20 0 0
79040 79040 45001 Abbeville County SC 45 2/15/20 0 0
82235 82235 45001 Abbeville County SC 45 2/16/20 0 0
85430 85430 45001 Abbeville County SC 45 2/17/20 0 0
88625 88625 45001 Abbeville County SC 45 2/18/20 0 0
91820 91820 45001 Abbeville County SC 45 2/19/20 0 0
95015 95015 45001 Abbeville County SC 45 2/20/20 0 0
98210 98210 45001 Abbeville County SC 45 2/21/20 0 0
101405 101405 45001 Abbeville County SC 45 2/22/20 0 0
104600 104600 45001 Abbeville County SC 45 2/23/20 0 0
107795 107795 45001 Abbeville County SC 45 2/24/20 0 0
110990 110990 45001 Abbeville County SC 45 2/25/20 0 0
114185 114185 45001 Abbeville County SC 45 2/26/20 0 0
117380 117380 45001 Abbeville County SC 45 2/27/20 0 0
120575 120575 45001 Abbeville County SC 45 2/28/20 0 0
123770 123770 45001 Abbeville County SC 45 2/29/20 0 0
126965 126965 45001 Abbeville County SC 45 3/1/20 0 0
130160 130160 45001 Abbeville County SC 45 3/2/20 0 0
133355 133355 45001 Abbeville County SC 45 3/3/20 0 0
136550 136550 45001 Abbeville County SC 45 3/4/20 0 0
139745 139745 45001 Abbeville County SC 45 3/5/20 0 0
142940 142940 45001 Abbeville County SC 45 3/6/20 0 0
146135 146135 45001 Abbeville County SC 45 3/7/20 0 0
149330 149330 45001 Abbeville County SC 45 3/8/20 0 0
152525 152525 45001 Abbeville County SC 45 3/9/20 0 0
155720 155720 45001 Abbeville County SC 45 3/10/20 0 0
158915 158915 45001 Abbeville County SC 45 3/11/20 0 0
162110 162110 45001 Abbeville County SC 45 3/12/20 0 0
165305 165305 45001 Abbeville County SC 45 3/13/20 0 0
168500 168500 45001 Abbeville County SC 45 3/14/20 0 0
171695 171695 45001 Abbeville County SC 45 3/15/20 0 0
174890 174890 45001 Abbeville County SC 45 3/16/20 0 0
178085 178085 45001 Abbeville County SC 45 3/17/20 0 0
181280 181280 45001 Abbeville County SC 45 3/18/20 0 0
184475 184475 45001 Abbeville County SC 45 3/19/20 1 0
187670 187670 45001 Abbeville County SC 45 3/20/20 1 0
190865 190865 45001 Abbeville County SC 45 3/21/20 1 0
194060 194060 45001 Abbeville County SC 45 3/22/20 1 0
197255 197255 45001 Abbeville County SC 45 3/23/20 1 0
200450 200450 45001 Abbeville County SC 45 3/24/20 1 0
203645 203645 45001 Abbeville County SC 45 3/25/20 3 0
206840 206840 45001 Abbeville County SC 45 3/26/20 3 0
210035 210035 45001 Abbeville County SC 45 3/27/20 3 0
213230 213230 45001 Abbeville County SC 45 3/28/20 3 0
216425 216425 45001 Abbeville County SC 45 3/29/20 3 0
219620 219620 45001 Abbeville County SC 45 3/30/20 3 0
222815 222815 45001 Abbeville County SC 45 3/31/20 4 0
226010 226010 45001 Abbeville County SC 45 4/1/20 4 0
229205 229205 45001 Abbeville County SC 45 4/2/20 5 0
232400 232400 45001 Abbeville County SC 45 4/3/20 5 0
235595 235595 45001 Abbeville County SC 45 4/4/20 5 0
238790 238790 45001 Abbeville County SC 45 4/5/20 5 0
241985 241985 45001 Abbeville County SC 45 4/6/20 5 0
245180 245180 45001 Abbeville County SC 45 4/7/20 5 0
248375 248375 45001 Abbeville County SC 45 4/8/20 6 0
251570 251570 45001 Abbeville County SC 45 4/9/20 7 0
254765 254765 45001 Abbeville County SC 45 4/10/20 7 0
257960 257960 45001 Abbeville County SC 45 4/11/20 7 0
261155 261155 45001 Abbeville County SC 45 4/12/20 9 0
264350 264350 45001 Abbeville County SC 45 4/13/20 9 0
267545 267545 45001 Abbeville County SC 45 4/14/20 9 0
270740 270740 45001 Abbeville County SC 45 4/15/20 10 0
273935 273935 45001 Abbeville County SC 45 4/16/20 10 0
277130 277130 45001 Abbeville County SC 45 4/17/20 10 0
280325 280325 45001 Abbeville County SC 45 4/18/20 15 0
283520 283520 45001 Abbeville County SC 45 4/19/20 17 0
286715 286715 45001 Abbeville County SC 45 4/20/20 17 0
289910 289910 45001 Abbeville County SC 45 4/21/20 18 0
293105 293105 45001 Abbeville County SC 45 4/22/20 22 0
296300 296300 45001 Abbeville County SC 45 4/23/20 23 0
299495 299495 45001 Abbeville County SC 45 4/24/20 24 0
302690 302690 45001 Abbeville County SC 45 4/25/20 24 0
305885 305885 45001 Abbeville County SC 45 4/26/20 24 0
309080 309080 45001 Abbeville County SC 45 4/27/20 29 0
312275 312275 45001 Abbeville County SC 45 4/28/20 29 0
315470 315470 45001 Abbeville County SC 45 4/29/20 29 0
318665 318665 45001 Abbeville County SC 45 4/30/20 31 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [covid_casesdeaths_reshaped_bln] (
   [countyFIPS] INTEGER,
   [County Name] TEXT,
   [State] TEXT,
   [stateFIPS] INTEGER,
   [date] TEXT,
   [cases] INTEGER,
   [deaths] INTEGER
);