ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lake" and fips = 46079 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637382 | 637382 | 2020-10-16 | Lake | South Dakota | 46079 | 284 | 8 |
634136 | 634136 | 2020-10-15 | Lake | South Dakota | 46079 | 279 | 8 |
630891 | 630891 | 2020-10-14 | Lake | South Dakota | 46079 | 270 | 8 |
627647 | 627647 | 2020-10-13 | Lake | South Dakota | 46079 | 260 | 8 |
624405 | 624405 | 2020-10-12 | Lake | South Dakota | 46079 | 255 | 8 |
621162 | 621162 | 2020-10-11 | Lake | South Dakota | 46079 | 254 | 8 |
617919 | 617919 | 2020-10-10 | Lake | South Dakota | 46079 | 249 | 8 |
614677 | 614677 | 2020-10-09 | Lake | South Dakota | 46079 | 238 | 8 |
611436 | 611436 | 2020-10-08 | Lake | South Dakota | 46079 | 229 | 8 |
608194 | 608194 | 2020-10-07 | Lake | South Dakota | 46079 | 223 | 8 |
604951 | 604951 | 2020-10-06 | Lake | South Dakota | 46079 | 220 | 7 |
601709 | 601709 | 2020-10-05 | Lake | South Dakota | 46079 | 219 | 7 |
598466 | 598466 | 2020-10-04 | Lake | South Dakota | 46079 | 215 | 7 |
595223 | 595223 | 2020-10-03 | Lake | South Dakota | 46079 | 212 | 7 |
591982 | 591982 | 2020-10-02 | Lake | South Dakota | 46079 | 209 | 7 |
588741 | 588741 | 2020-10-01 | Lake | South Dakota | 46079 | 206 | 7 |
585501 | 585501 | 2020-09-30 | Lake | South Dakota | 46079 | 201 | 7 |
582261 | 582261 | 2020-09-29 | Lake | South Dakota | 46079 | 198 | 7 |
579021 | 579021 | 2020-09-28 | Lake | South Dakota | 46079 | 196 | 7 |
575780 | 575780 | 2020-09-27 | Lake | South Dakota | 46079 | 195 | 7 |
572536 | 572536 | 2020-09-26 | Lake | South Dakota | 46079 | 190 | 7 |
569294 | 569294 | 2020-09-25 | Lake | South Dakota | 46079 | 188 | 7 |
566053 | 566053 | 2020-09-24 | Lake | South Dakota | 46079 | 183 | 7 |
562812 | 562812 | 2020-09-23 | Lake | South Dakota | 46079 | 175 | 7 |
559575 | 559575 | 2020-09-22 | Lake | South Dakota | 46079 | 173 | 7 |
556338 | 556338 | 2020-09-21 | Lake | South Dakota | 46079 | 172 | 7 |
553101 | 553101 | 2020-09-20 | Lake | South Dakota | 46079 | 172 | 7 |
549862 | 549862 | 2020-09-19 | Lake | South Dakota | 46079 | 169 | 7 |
546623 | 546623 | 2020-09-18 | Lake | South Dakota | 46079 | 162 | 7 |
543386 | 543386 | 2020-09-17 | Lake | South Dakota | 46079 | 155 | 7 |
540150 | 540150 | 2020-09-16 | Lake | South Dakota | 46079 | 155 | 7 |
536913 | 536913 | 2020-09-15 | Lake | South Dakota | 46079 | 153 | 6 |
533677 | 533677 | 2020-09-14 | Lake | South Dakota | 46079 | 149 | 6 |
530442 | 530442 | 2020-09-13 | Lake | South Dakota | 46079 | 148 | 6 |
527205 | 527205 | 2020-09-12 | Lake | South Dakota | 46079 | 145 | 6 |
523969 | 523969 | 2020-09-11 | Lake | South Dakota | 46079 | 142 | 6 |
520733 | 520733 | 2020-09-10 | Lake | South Dakota | 46079 | 140 | 6 |
517497 | 517497 | 2020-09-09 | Lake | South Dakota | 46079 | 135 | 6 |
514262 | 514262 | 2020-09-08 | Lake | South Dakota | 46079 | 131 | 6 |
511029 | 511029 | 2020-09-07 | Lake | South Dakota | 46079 | 128 | 6 |
507796 | 507796 | 2020-09-06 | Lake | South Dakota | 46079 | 127 | 6 |
504564 | 504564 | 2020-09-05 | Lake | South Dakota | 46079 | 126 | 6 |
501330 | 501330 | 2020-09-04 | Lake | South Dakota | 46079 | 122 | 6 |
498096 | 498096 | 2020-09-03 | Lake | South Dakota | 46079 | 118 | 6 |
494863 | 494863 | 2020-09-02 | Lake | South Dakota | 46079 | 118 | 6 |
491629 | 491629 | 2020-09-01 | Lake | South Dakota | 46079 | 119 | 6 |
488396 | 488396 | 2020-08-31 | Lake | South Dakota | 46079 | 117 | 6 |
485163 | 485163 | 2020-08-30 | Lake | South Dakota | 46079 | 116 | 6 |
481928 | 481928 | 2020-08-29 | Lake | South Dakota | 46079 | 113 | 6 |
478694 | 478694 | 2020-08-28 | Lake | South Dakota | 46079 | 111 | 6 |
475461 | 475461 | 2020-08-27 | Lake | South Dakota | 46079 | 113 | 6 |
472227 | 472227 | 2020-08-26 | Lake | South Dakota | 46079 | 109 | 6 |
468995 | 468995 | 2020-08-25 | Lake | South Dakota | 46079 | 108 | 6 |
465767 | 465767 | 2020-08-24 | Lake | South Dakota | 46079 | 108 | 6 |
462538 | 462538 | 2020-08-23 | Lake | South Dakota | 46079 | 108 | 6 |
459310 | 459310 | 2020-08-22 | Lake | South Dakota | 46079 | 107 | 6 |
456082 | 456082 | 2020-08-21 | Lake | South Dakota | 46079 | 105 | 6 |
452854 | 452854 | 2020-08-20 | Lake | South Dakota | 46079 | 105 | 5 |
449626 | 449626 | 2020-08-19 | Lake | South Dakota | 46079 | 105 | 5 |
446398 | 446398 | 2020-08-18 | Lake | South Dakota | 46079 | 104 | 5 |
443172 | 443172 | 2020-08-17 | Lake | South Dakota | 46079 | 103 | 4 |
439945 | 439945 | 2020-08-16 | Lake | South Dakota | 46079 | 101 | 4 |
436720 | 436720 | 2020-08-15 | Lake | South Dakota | 46079 | 100 | 3 |
433493 | 433493 | 2020-08-14 | Lake | South Dakota | 46079 | 100 | 3 |
430268 | 430268 | 2020-08-13 | Lake | South Dakota | 46079 | 100 | 2 |
427041 | 427041 | 2020-08-12 | Lake | South Dakota | 46079 | 95 | 2 |
423818 | 423818 | 2020-08-11 | Lake | South Dakota | 46079 | 94 | 2 |
420596 | 420596 | 2020-08-10 | Lake | South Dakota | 46079 | 94 | 2 |
417375 | 417375 | 2020-08-09 | Lake | South Dakota | 46079 | 94 | 2 |
414154 | 414154 | 2020-08-08 | Lake | South Dakota | 46079 | 91 | 2 |
410934 | 410934 | 2020-08-07 | Lake | South Dakota | 46079 | 90 | 2 |
407715 | 407715 | 2020-08-06 | Lake | South Dakota | 46079 | 89 | 2 |
404495 | 404495 | 2020-08-05 | Lake | South Dakota | 46079 | 86 | 2 |
401277 | 401277 | 2020-08-04 | Lake | South Dakota | 46079 | 84 | 2 |
398062 | 398062 | 2020-08-03 | Lake | South Dakota | 46079 | 84 | 2 |
394845 | 394845 | 2020-08-02 | Lake | South Dakota | 46079 | 81 | 2 |
391629 | 391629 | 2020-08-01 | Lake | South Dakota | 46079 | 79 | 2 |
388412 | 388412 | 2020-07-31 | Lake | South Dakota | 46079 | 78 | 2 |
385195 | 385195 | 2020-07-30 | Lake | South Dakota | 46079 | 79 | 2 |
381977 | 381977 | 2020-07-29 | Lake | South Dakota | 46079 | 78 | 2 |
378760 | 378760 | 2020-07-28 | Lake | South Dakota | 46079 | 69 | 2 |
375544 | 375544 | 2020-07-27 | Lake | South Dakota | 46079 | 67 | 2 |
372331 | 372331 | 2020-07-26 | Lake | South Dakota | 46079 | 66 | 2 |
369119 | 369119 | 2020-07-25 | Lake | South Dakota | 46079 | 63 | 2 |
365910 | 365910 | 2020-07-24 | Lake | South Dakota | 46079 | 57 | 2 |
362704 | 362704 | 2020-07-23 | Lake | South Dakota | 46079 | 56 | 2 |
359498 | 359498 | 2020-07-22 | Lake | South Dakota | 46079 | 54 | 1 |
356294 | 356294 | 2020-07-21 | Lake | South Dakota | 46079 | 48 | 1 |
353091 | 353091 | 2020-07-20 | Lake | South Dakota | 46079 | 48 | 1 |
349888 | 349888 | 2020-07-19 | Lake | South Dakota | 46079 | 48 | 1 |
346688 | 346688 | 2020-07-18 | Lake | South Dakota | 46079 | 49 | 1 |
343488 | 343488 | 2020-07-17 | Lake | South Dakota | 46079 | 47 | 1 |
340290 | 340290 | 2020-07-16 | Lake | South Dakota | 46079 | 43 | 1 |
337093 | 337093 | 2020-07-15 | Lake | South Dakota | 46079 | 41 | 1 |
333899 | 333899 | 2020-07-14 | Lake | South Dakota | 46079 | 37 | 1 |
330707 | 330707 | 2020-07-13 | Lake | South Dakota | 46079 | 35 | 1 |
327521 | 327521 | 2020-07-12 | Lake | South Dakota | 46079 | 29 | 1 |
324336 | 324336 | 2020-07-11 | Lake | South Dakota | 46079 | 29 | 1 |
321156 | 321156 | 2020-07-10 | Lake | South Dakota | 46079 | 26 | 1 |
317978 | 317978 | 2020-07-09 | Lake | South Dakota | 46079 | 23 | 1 |
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);