ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Clark" and fips = 46025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536886 | 536886 | 2020-09-15 | Clark | South Dakota | 46025 | 31 | 0 |
533650 | 533650 | 2020-09-14 | Clark | South Dakota | 46025 | 28 | 0 |
530415 | 530415 | 2020-09-13 | Clark | South Dakota | 46025 | 27 | 0 |
527178 | 527178 | 2020-09-12 | Clark | South Dakota | 46025 | 27 | 0 |
523942 | 523942 | 2020-09-11 | Clark | South Dakota | 46025 | 24 | 0 |
520706 | 520706 | 2020-09-10 | Clark | South Dakota | 46025 | 23 | 0 |
517470 | 517470 | 2020-09-09 | Clark | South Dakota | 46025 | 23 | 0 |
514235 | 514235 | 2020-09-08 | Clark | South Dakota | 46025 | 23 | 0 |
511002 | 511002 | 2020-09-07 | Clark | South Dakota | 46025 | 23 | 0 |
507769 | 507769 | 2020-09-06 | Clark | South Dakota | 46025 | 22 | 0 |
504537 | 504537 | 2020-09-05 | Clark | South Dakota | 46025 | 22 | 0 |
501303 | 501303 | 2020-09-04 | Clark | South Dakota | 46025 | 21 | 0 |
498069 | 498069 | 2020-09-03 | Clark | South Dakota | 46025 | 21 | 0 |
494836 | 494836 | 2020-09-02 | Clark | South Dakota | 46025 | 21 | 0 |
491602 | 491602 | 2020-09-01 | Clark | South Dakota | 46025 | 19 | 0 |
488369 | 488369 | 2020-08-31 | Clark | South Dakota | 46025 | 19 | 0 |
485136 | 485136 | 2020-08-30 | Clark | South Dakota | 46025 | 19 | 0 |
481901 | 481901 | 2020-08-29 | Clark | South Dakota | 46025 | 19 | 0 |
478667 | 478667 | 2020-08-28 | Clark | South Dakota | 46025 | 19 | 0 |
475434 | 475434 | 2020-08-27 | Clark | South Dakota | 46025 | 18 | 0 |
472200 | 472200 | 2020-08-26 | Clark | South Dakota | 46025 | 18 | 0 |
468968 | 468968 | 2020-08-25 | Clark | South Dakota | 46025 | 18 | 0 |
465740 | 465740 | 2020-08-24 | Clark | South Dakota | 46025 | 18 | 0 |
462511 | 462511 | 2020-08-23 | Clark | South Dakota | 46025 | 17 | 0 |
459283 | 459283 | 2020-08-22 | Clark | South Dakota | 46025 | 17 | 0 |
456055 | 456055 | 2020-08-21 | Clark | South Dakota | 46025 | 17 | 0 |
452827 | 452827 | 2020-08-20 | Clark | South Dakota | 46025 | 17 | 0 |
449599 | 449599 | 2020-08-19 | Clark | South Dakota | 46025 | 17 | 0 |
446371 | 446371 | 2020-08-18 | Clark | South Dakota | 46025 | 17 | 0 |
443145 | 443145 | 2020-08-17 | Clark | South Dakota | 46025 | 17 | 0 |
439918 | 439918 | 2020-08-16 | Clark | South Dakota | 46025 | 17 | 0 |
436693 | 436693 | 2020-08-15 | Clark | South Dakota | 46025 | 17 | 0 |
433466 | 433466 | 2020-08-14 | Clark | South Dakota | 46025 | 17 | 0 |
430241 | 430241 | 2020-08-13 | Clark | South Dakota | 46025 | 17 | 0 |
427015 | 427015 | 2020-08-12 | Clark | South Dakota | 46025 | 16 | 0 |
423792 | 423792 | 2020-08-11 | Clark | South Dakota | 46025 | 16 | 0 |
420570 | 420570 | 2020-08-10 | Clark | South Dakota | 46025 | 16 | 0 |
417349 | 417349 | 2020-08-09 | Clark | South Dakota | 46025 | 16 | 0 |
414128 | 414128 | 2020-08-08 | Clark | South Dakota | 46025 | 16 | 0 |
410908 | 410908 | 2020-08-07 | Clark | South Dakota | 46025 | 16 | 0 |
407689 | 407689 | 2020-08-06 | Clark | South Dakota | 46025 | 16 | 0 |
404469 | 404469 | 2020-08-05 | Clark | South Dakota | 46025 | 16 | 0 |
401251 | 401251 | 2020-08-04 | Clark | South Dakota | 46025 | 16 | 0 |
398036 | 398036 | 2020-08-03 | Clark | South Dakota | 46025 | 16 | 0 |
394819 | 394819 | 2020-08-02 | Clark | South Dakota | 46025 | 16 | 0 |
391603 | 391603 | 2020-08-01 | Clark | South Dakota | 46025 | 16 | 0 |
388386 | 388386 | 2020-07-31 | Clark | South Dakota | 46025 | 16 | 0 |
385169 | 385169 | 2020-07-30 | Clark | South Dakota | 46025 | 16 | 0 |
381951 | 381951 | 2020-07-29 | Clark | South Dakota | 46025 | 16 | 0 |
378734 | 378734 | 2020-07-28 | Clark | South Dakota | 46025 | 16 | 0 |
375518 | 375518 | 2020-07-27 | Clark | South Dakota | 46025 | 16 | 0 |
372305 | 372305 | 2020-07-26 | Clark | South Dakota | 46025 | 16 | 0 |
369093 | 369093 | 2020-07-25 | Clark | South Dakota | 46025 | 16 | 0 |
365884 | 365884 | 2020-07-24 | Clark | South Dakota | 46025 | 16 | 0 |
362678 | 362678 | 2020-07-23 | Clark | South Dakota | 46025 | 16 | 0 |
359472 | 359472 | 2020-07-22 | Clark | South Dakota | 46025 | 16 | 0 |
356268 | 356268 | 2020-07-21 | Clark | South Dakota | 46025 | 16 | 0 |
353065 | 353065 | 2020-07-20 | Clark | South Dakota | 46025 | 16 | 0 |
349862 | 349862 | 2020-07-19 | Clark | South Dakota | 46025 | 16 | 0 |
346662 | 346662 | 2020-07-18 | Clark | South Dakota | 46025 | 16 | 0 |
343462 | 343462 | 2020-07-17 | Clark | South Dakota | 46025 | 16 | 0 |
340264 | 340264 | 2020-07-16 | Clark | South Dakota | 46025 | 16 | 0 |
337067 | 337067 | 2020-07-15 | Clark | South Dakota | 46025 | 16 | 0 |
333873 | 333873 | 2020-07-14 | Clark | South Dakota | 46025 | 15 | 0 |
330681 | 330681 | 2020-07-13 | Clark | South Dakota | 46025 | 15 | 0 |
327495 | 327495 | 2020-07-12 | Clark | South Dakota | 46025 | 15 | 0 |
324310 | 324310 | 2020-07-11 | Clark | South Dakota | 46025 | 15 | 0 |
321130 | 321130 | 2020-07-10 | Clark | South Dakota | 46025 | 15 | 0 |
317952 | 317952 | 2020-07-09 | Clark | South Dakota | 46025 | 15 | 0 |
314779 | 314779 | 2020-07-08 | Clark | South Dakota | 46025 | 15 | 0 |
311606 | 311606 | 2020-07-07 | Clark | South Dakota | 46025 | 15 | 0 |
308437 | 308437 | 2020-07-06 | Clark | South Dakota | 46025 | 15 | 0 |
305270 | 305270 | 2020-07-05 | Clark | South Dakota | 46025 | 15 | 0 |
302107 | 302107 | 2020-07-04 | Clark | South Dakota | 46025 | 15 | 0 |
298943 | 298943 | 2020-07-03 | Clark | South Dakota | 46025 | 15 | 0 |
295783 | 295783 | 2020-07-02 | Clark | South Dakota | 46025 | 15 | 0 |
292627 | 292627 | 2020-07-01 | Clark | South Dakota | 46025 | 15 | 0 |
289475 | 289475 | 2020-06-30 | Clark | South Dakota | 46025 | 15 | 0 |
286324 | 286324 | 2020-06-29 | Clark | South Dakota | 46025 | 14 | 0 |
283179 | 283179 | 2020-06-28 | Clark | South Dakota | 46025 | 14 | 0 |
280033 | 280033 | 2020-06-27 | Clark | South Dakota | 46025 | 14 | 0 |
276885 | 276885 | 2020-06-26 | Clark | South Dakota | 46025 | 13 | 0 |
273738 | 273738 | 2020-06-25 | Clark | South Dakota | 46025 | 13 | 0 |
270599 | 270599 | 2020-06-24 | Clark | South Dakota | 46025 | 13 | 0 |
267465 | 267465 | 2020-06-23 | Clark | South Dakota | 46025 | 12 | 0 |
264337 | 264337 | 2020-06-22 | Clark | South Dakota | 46025 | 12 | 0 |
261209 | 261209 | 2020-06-21 | Clark | South Dakota | 46025 | 11 | 0 |
258082 | 258082 | 2020-06-20 | Clark | South Dakota | 46025 | 11 | 0 |
254956 | 254956 | 2020-06-19 | Clark | South Dakota | 46025 | 11 | 0 |
251841 | 251841 | 2020-06-18 | Clark | South Dakota | 46025 | 11 | 0 |
248726 | 248726 | 2020-06-17 | Clark | South Dakota | 46025 | 11 | 0 |
245613 | 245613 | 2020-06-16 | Clark | South Dakota | 46025 | 11 | 0 |
242501 | 242501 | 2020-06-15 | Clark | South Dakota | 46025 | 11 | 0 |
239391 | 239391 | 2020-06-14 | Clark | South Dakota | 46025 | 9 | 0 |
236283 | 236283 | 2020-06-13 | Clark | South Dakota | 46025 | 9 | 0 |
233178 | 233178 | 2020-06-12 | Clark | South Dakota | 46025 | 7 | 0 |
230073 | 230073 | 2020-06-11 | Clark | South Dakota | 46025 | 6 | 0 |
226969 | 226969 | 2020-06-10 | Clark | South Dakota | 46025 | 6 | 0 |
223869 | 223869 | 2020-06-09 | Clark | South Dakota | 46025 | 5 | 0 |
220774 | 220774 | 2020-06-08 | Clark | South Dakota | 46025 | 4 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);