us-counties

Table actions

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

570,096 rows sorted by county descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date county ▲ state fips cases deaths
120624 120624 2020-05-06 Ziebach South Dakota 46137 1 0
123602 123602 2020-05-07 Ziebach South Dakota 46137 1 0
126585 126585 2020-05-08 Ziebach South Dakota 46137 1 0
129574 129574 2020-05-09 Ziebach South Dakota 46137 1 0
132563 132563 2020-05-10 Ziebach South Dakota 46137 1 0
135554 135554 2020-05-11 Ziebach South Dakota 46137 1 0
138544 138544 2020-05-12 Ziebach South Dakota 46137 1 0
141540 141540 2020-05-13 Ziebach South Dakota 46137 1 0
144537 144537 2020-05-14 Ziebach South Dakota 46137 1 0
147538 147538 2020-05-15 Ziebach South Dakota 46137 1 0
150546 150546 2020-05-16 Ziebach South Dakota 46137 1 0
153557 153557 2020-05-17 Ziebach South Dakota 46137 1 0
156574 156574 2020-05-18 Ziebach South Dakota 46137 1 0
159595 159595 2020-05-19 Ziebach South Dakota 46137 1 0
162622 162622 2020-05-20 Ziebach South Dakota 46137 1 0
165651 165651 2020-05-21 Ziebach South Dakota 46137 1 0
168687 168687 2020-05-22 Ziebach South Dakota 46137 1 0
171726 171726 2020-05-23 Ziebach South Dakota 46137 1 0
174769 174769 2020-05-24 Ziebach South Dakota 46137 1 0
177813 177813 2020-05-25 Ziebach South Dakota 46137 1 0
180856 180856 2020-05-26 Ziebach South Dakota 46137 1 0
183906 183906 2020-05-27 Ziebach South Dakota 46137 1 0
186963 186963 2020-05-28 Ziebach South Dakota 46137 1 0
190027 190027 2020-05-29 Ziebach South Dakota 46137 1 0
193092 193092 2020-05-30 Ziebach South Dakota 46137 1 0
196162 196162 2020-05-31 Ziebach South Dakota 46137 1 0
199235 199235 2020-06-01 Ziebach South Dakota 46137 1 0
202310 202310 2020-06-02 Ziebach South Dakota 46137 1 0
205389 205389 2020-06-03 Ziebach South Dakota 46137 1 0
208471 208471 2020-06-04 Ziebach South Dakota 46137 2 0
211554 211554 2020-06-05 Ziebach South Dakota 46137 2 0
214642 214642 2020-06-06 Ziebach South Dakota 46137 2 0
217733 217733 2020-06-07 Ziebach South Dakota 46137 2 0
220826 220826 2020-06-08 Ziebach South Dakota 46137 2 0
223922 223922 2020-06-09 Ziebach South Dakota 46137 2 0
227024 227024 2020-06-10 Ziebach South Dakota 46137 2 0
230129 230129 2020-06-11 Ziebach South Dakota 46137 2 0
233236 233236 2020-06-12 Ziebach South Dakota 46137 2 0
236343 236343 2020-06-13 Ziebach South Dakota 46137 2 0
239452 239452 2020-06-14 Ziebach South Dakota 46137 2 0
242563 242563 2020-06-15 Ziebach South Dakota 46137 2 0
245676 245676 2020-06-16 Ziebach South Dakota 46137 2 0
248790 248790 2020-06-17 Ziebach South Dakota 46137 2 0
251906 251906 2020-06-18 Ziebach South Dakota 46137 2 0
255022 255022 2020-06-19 Ziebach South Dakota 46137 2 0
258149 258149 2020-06-20 Ziebach South Dakota 46137 2 0
261277 261277 2020-06-21 Ziebach South Dakota 46137 2 0
264406 264406 2020-06-22 Ziebach South Dakota 46137 2 0
267536 267536 2020-06-23 Ziebach South Dakota 46137 2 0
270671 270671 2020-06-24 Ziebach South Dakota 46137 2 0
273811 273811 2020-06-25 Ziebach South Dakota 46137 2 0
276959 276959 2020-06-26 Ziebach South Dakota 46137 2 0
280108 280108 2020-06-27 Ziebach South Dakota 46137 2 0
283256 283256 2020-06-28 Ziebach South Dakota 46137 3 0
286403 286403 2020-06-29 Ziebach South Dakota 46137 3 0
289556 289556 2020-06-30 Ziebach South Dakota 46137 2 0
292709 292709 2020-07-01 Ziebach South Dakota 46137 2 0
295866 295866 2020-07-02 Ziebach South Dakota 46137 1 0
299027 299027 2020-07-03 Ziebach South Dakota 46137 1 0
302192 302192 2020-07-04 Ziebach South Dakota 46137 1 0
305356 305356 2020-07-05 Ziebach South Dakota 46137 1 0
308525 308525 2020-07-06 Ziebach South Dakota 46137 1 0
311695 311695 2020-07-07 Ziebach South Dakota 46137 1 0
314870 314870 2020-07-08 Ziebach South Dakota 46137 1 0
318044 318044 2020-07-09 Ziebach South Dakota 46137 2 0
321223 321223 2020-07-10 Ziebach South Dakota 46137 3 0
324405 324405 2020-07-11 Ziebach South Dakota 46137 3 0
327591 327591 2020-07-12 Ziebach South Dakota 46137 3 0
330778 330778 2020-07-13 Ziebach South Dakota 46137 3 0
333971 333971 2020-07-14 Ziebach South Dakota 46137 3 0
337166 337166 2020-07-15 Ziebach South Dakota 46137 3 0
340364 340364 2020-07-16 Ziebach South Dakota 46137 3 0
343563 343563 2020-07-17 Ziebach South Dakota 46137 3 0
346764 346764 2020-07-18 Ziebach South Dakota 46137 3 0
349965 349965 2020-07-19 Ziebach South Dakota 46137 3 0
353169 353169 2020-07-20 Ziebach South Dakota 46137 3 0
356373 356373 2020-07-21 Ziebach South Dakota 46137 3 0
359578 359578 2020-07-22 Ziebach South Dakota 46137 3 0
362786 362786 2020-07-23 Ziebach South Dakota 46137 3 0
365992 365992 2020-07-24 Ziebach South Dakota 46137 3 0
369201 369201 2020-07-25 Ziebach South Dakota 46137 7 0
372413 372413 2020-07-26 Ziebach South Dakota 46137 7 0
375626 375626 2020-07-27 Ziebach South Dakota 46137 7 0
378842 378842 2020-07-28 Ziebach South Dakota 46137 7 0
382059 382059 2020-07-29 Ziebach South Dakota 46137 8 0
385277 385277 2020-07-30 Ziebach South Dakota 46137 8 0
388494 388494 2020-07-31 Ziebach South Dakota 46137 8 0
391711 391711 2020-08-01 Ziebach South Dakota 46137 8 0
394927 394927 2020-08-02 Ziebach South Dakota 46137 8 0
398144 398144 2020-08-03 Ziebach South Dakota 46137 8 0
401359 401359 2020-08-04 Ziebach South Dakota 46137 8 0
404577 404577 2020-08-05 Ziebach South Dakota 46137 9 0
407797 407797 2020-08-06 Ziebach South Dakota 46137 10 0
411016 411016 2020-08-07 Ziebach South Dakota 46137 33 0
414236 414236 2020-08-08 Ziebach South Dakota 46137 34 0
417457 417457 2020-08-09 Ziebach South Dakota 46137 35 0
420678 420678 2020-08-10 Ziebach South Dakota 46137 35 0
423900 423900 2020-08-11 Ziebach South Dakota 46137 35 0
427123 427123 2020-08-12 Ziebach South Dakota 46137 35 0
430350 430350 2020-08-13 Ziebach South Dakota 46137 35 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);