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 descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid countyFIPS County Name ▲ State stateFIPS date cases deaths
2472 2472 46137 Ziebach County SD 46 1/22/20 0 0
5667 5667 46137 Ziebach County SD 46 1/23/20 0 0
8862 8862 46137 Ziebach County SD 46 1/24/20 0 0
12057 12057 46137 Ziebach County SD 46 1/25/20 0 0
15252 15252 46137 Ziebach County SD 46 1/26/20 0 0
18447 18447 46137 Ziebach County SD 46 1/27/20 0 0
21642 21642 46137 Ziebach County SD 46 1/28/20 0 0
24837 24837 46137 Ziebach County SD 46 1/29/20 0 0
28032 28032 46137 Ziebach County SD 46 1/30/20 0 0
31227 31227 46137 Ziebach County SD 46 1/31/20 0 0
34422 34422 46137 Ziebach County SD 46 2/1/20 0 0
37617 37617 46137 Ziebach County SD 46 2/2/20 0 0
40812 40812 46137 Ziebach County SD 46 2/3/20 0 0
44007 44007 46137 Ziebach County SD 46 2/4/20 0 0
47202 47202 46137 Ziebach County SD 46 2/5/20 0 0
50397 50397 46137 Ziebach County SD 46 2/6/20 0 0
53592 53592 46137 Ziebach County SD 46 2/7/20 0 0
56787 56787 46137 Ziebach County SD 46 2/8/20 0 0
59982 59982 46137 Ziebach County SD 46 2/9/20 0 0
63177 63177 46137 Ziebach County SD 46 2/10/20 0 0
66372 66372 46137 Ziebach County SD 46 2/11/20 0 0
69567 69567 46137 Ziebach County SD 46 2/12/20 0 0
72762 72762 46137 Ziebach County SD 46 2/13/20 0 0
75957 75957 46137 Ziebach County SD 46 2/14/20 0 0
79152 79152 46137 Ziebach County SD 46 2/15/20 0 0
82347 82347 46137 Ziebach County SD 46 2/16/20 0 0
85542 85542 46137 Ziebach County SD 46 2/17/20 0 0
88737 88737 46137 Ziebach County SD 46 2/18/20 0 0
91932 91932 46137 Ziebach County SD 46 2/19/20 0 0
95127 95127 46137 Ziebach County SD 46 2/20/20 0 0
98322 98322 46137 Ziebach County SD 46 2/21/20 0 0
101517 101517 46137 Ziebach County SD 46 2/22/20 0 0
104712 104712 46137 Ziebach County SD 46 2/23/20 0 0
107907 107907 46137 Ziebach County SD 46 2/24/20 0 0
111102 111102 46137 Ziebach County SD 46 2/25/20 0 0
114297 114297 46137 Ziebach County SD 46 2/26/20 0 0
117492 117492 46137 Ziebach County SD 46 2/27/20 0 0
120687 120687 46137 Ziebach County SD 46 2/28/20 0 0
123882 123882 46137 Ziebach County SD 46 2/29/20 0 0
127077 127077 46137 Ziebach County SD 46 3/1/20 0 0
130272 130272 46137 Ziebach County SD 46 3/2/20 0 0
133467 133467 46137 Ziebach County SD 46 3/3/20 0 0
136662 136662 46137 Ziebach County SD 46 3/4/20 0 0
139857 139857 46137 Ziebach County SD 46 3/5/20 0 0
143052 143052 46137 Ziebach County SD 46 3/6/20 0 0
146247 146247 46137 Ziebach County SD 46 3/7/20 0 0
149442 149442 46137 Ziebach County SD 46 3/8/20 0 0
152637 152637 46137 Ziebach County SD 46 3/9/20 0 0
155832 155832 46137 Ziebach County SD 46 3/10/20 0 0
159027 159027 46137 Ziebach County SD 46 3/11/20 0 0
162222 162222 46137 Ziebach County SD 46 3/12/20 0 0
165417 165417 46137 Ziebach County SD 46 3/13/20 0 0
168612 168612 46137 Ziebach County SD 46 3/14/20 0 0
171807 171807 46137 Ziebach County SD 46 3/15/20 0 0
175002 175002 46137 Ziebach County SD 46 3/16/20 0 0
178197 178197 46137 Ziebach County SD 46 3/17/20 0 0
181392 181392 46137 Ziebach County SD 46 3/18/20 0 0
184587 184587 46137 Ziebach County SD 46 3/19/20 0 0
187782 187782 46137 Ziebach County SD 46 3/20/20 0 0
190977 190977 46137 Ziebach County SD 46 3/21/20 0 0
194172 194172 46137 Ziebach County SD 46 3/22/20 0 0
197367 197367 46137 Ziebach County SD 46 3/23/20 0 0
200562 200562 46137 Ziebach County SD 46 3/24/20 0 0
203757 203757 46137 Ziebach County SD 46 3/25/20 0 0
206952 206952 46137 Ziebach County SD 46 3/26/20 0 0
210147 210147 46137 Ziebach County SD 46 3/27/20 0 0
213342 213342 46137 Ziebach County SD 46 3/28/20 0 0
216537 216537 46137 Ziebach County SD 46 3/29/20 0 0
219732 219732 46137 Ziebach County SD 46 3/30/20 0 0
222927 222927 46137 Ziebach County SD 46 3/31/20 0 0
226122 226122 46137 Ziebach County SD 46 4/1/20 0 0
229317 229317 46137 Ziebach County SD 46 4/2/20 0 0
232512 232512 46137 Ziebach County SD 46 4/3/20 0 0
235707 235707 46137 Ziebach County SD 46 4/4/20 0 0
238902 238902 46137 Ziebach County SD 46 4/5/20 0 0
242097 242097 46137 Ziebach County SD 46 4/6/20 0 0
245292 245292 46137 Ziebach County SD 46 4/7/20 0 0
248487 248487 46137 Ziebach County SD 46 4/8/20 0 0
251682 251682 46137 Ziebach County SD 46 4/9/20 0 0
254877 254877 46137 Ziebach County SD 46 4/10/20 0 0
258072 258072 46137 Ziebach County SD 46 4/11/20 0 0
261267 261267 46137 Ziebach County SD 46 4/12/20 0 0
264462 264462 46137 Ziebach County SD 46 4/13/20 0 0
267657 267657 46137 Ziebach County SD 46 4/14/20 0 0
270852 270852 46137 Ziebach County SD 46 4/15/20 0 0
274047 274047 46137 Ziebach County SD 46 4/16/20 0 0
277242 277242 46137 Ziebach County SD 46 4/17/20 0 0
280437 280437 46137 Ziebach County SD 46 4/18/20 0 0
283632 283632 46137 Ziebach County SD 46 4/19/20 0 0
286827 286827 46137 Ziebach County SD 46 4/20/20 0 0
290022 290022 46137 Ziebach County SD 46 4/21/20 0 0
293217 293217 46137 Ziebach County SD 46 4/22/20 0 0
296412 296412 46137 Ziebach County SD 46 4/23/20 0 0
299607 299607 46137 Ziebach County SD 46 4/24/20 0 0
302802 302802 46137 Ziebach County SD 46 4/25/20 0 0
305997 305997 46137 Ziebach County SD 46 4/26/20 0 0
309192 309192 46137 Ziebach County SD 46 4/27/20 0 0
312387 312387 46137 Ziebach County SD 46 4/28/20 0 0
315582 315582 46137 Ziebach County SD 46 4/29/20 0 0
318777 318777 46137 Ziebach County SD 46 4/30/20 0 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
);