ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Brookings" and state = "South Dakota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
295778 | 295778 | 2020-07-02 | Brookings | South Dakota | 46011 | 68 | 0 |
298937 | 298937 | 2020-07-03 | Brookings | South Dakota | 46011 | 70 | 0 |
302101 | 302101 | 2020-07-04 | Brookings | South Dakota | 46011 | 73 | 0 |
305264 | 305264 | 2020-07-05 | Brookings | South Dakota | 46011 | 79 | 0 |
308431 | 308431 | 2020-07-06 | Brookings | South Dakota | 46011 | 81 | 0 |
311600 | 311600 | 2020-07-07 | Brookings | South Dakota | 46011 | 83 | 0 |
314772 | 314772 | 2020-07-08 | Brookings | South Dakota | 46011 | 86 | 0 |
317945 | 317945 | 2020-07-09 | Brookings | South Dakota | 46011 | 86 | 0 |
321123 | 321123 | 2020-07-10 | Brookings | South Dakota | 46011 | 90 | 0 |
324303 | 324303 | 2020-07-11 | Brookings | South Dakota | 46011 | 94 | 0 |
327488 | 327488 | 2020-07-12 | Brookings | South Dakota | 46011 | 95 | 0 |
330674 | 330674 | 2020-07-13 | Brookings | South Dakota | 46011 | 95 | 0 |
333866 | 333866 | 2020-07-14 | Brookings | South Dakota | 46011 | 95 | 0 |
337060 | 337060 | 2020-07-15 | Brookings | South Dakota | 46011 | 96 | 0 |
340257 | 340257 | 2020-07-16 | Brookings | South Dakota | 46011 | 97 | 0 |
343455 | 343455 | 2020-07-17 | Brookings | South Dakota | 46011 | 102 | 0 |
346655 | 346655 | 2020-07-18 | Brookings | South Dakota | 46011 | 103 | 0 |
349855 | 349855 | 2020-07-19 | Brookings | South Dakota | 46011 | 104 | 0 |
353058 | 353058 | 2020-07-20 | Brookings | South Dakota | 46011 | 104 | 0 |
356261 | 356261 | 2020-07-21 | Brookings | South Dakota | 46011 | 105 | 0 |
359465 | 359465 | 2020-07-22 | Brookings | South Dakota | 46011 | 107 | 0 |
362671 | 362671 | 2020-07-23 | Brookings | South Dakota | 46011 | 107 | 0 |
365877 | 365877 | 2020-07-24 | Brookings | South Dakota | 46011 | 108 | 0 |
369086 | 369086 | 2020-07-25 | Brookings | South Dakota | 46011 | 108 | 0 |
372298 | 372298 | 2020-07-26 | Brookings | South Dakota | 46011 | 111 | 0 |
375511 | 375511 | 2020-07-27 | Brookings | South Dakota | 46011 | 111 | 0 |
378727 | 378727 | 2020-07-28 | Brookings | South Dakota | 46011 | 111 | 0 |
381944 | 381944 | 2020-07-29 | Brookings | South Dakota | 46011 | 111 | 0 |
385162 | 385162 | 2020-07-30 | Brookings | South Dakota | 46011 | 112 | 0 |
388379 | 388379 | 2020-07-31 | Brookings | South Dakota | 46011 | 113 | 0 |
391596 | 391596 | 2020-08-01 | Brookings | South Dakota | 46011 | 118 | 1 |
394812 | 394812 | 2020-08-02 | Brookings | South Dakota | 46011 | 119 | 1 |
398029 | 398029 | 2020-08-03 | Brookings | South Dakota | 46011 | 120 | 1 |
401244 | 401244 | 2020-08-04 | Brookings | South Dakota | 46011 | 121 | 1 |
404462 | 404462 | 2020-08-05 | Brookings | South Dakota | 46011 | 122 | 1 |
407682 | 407682 | 2020-08-06 | Brookings | South Dakota | 46011 | 127 | 1 |
410901 | 410901 | 2020-08-07 | Brookings | South Dakota | 46011 | 128 | 1 |
414121 | 414121 | 2020-08-08 | Brookings | South Dakota | 46011 | 133 | 1 |
417342 | 417342 | 2020-08-09 | Brookings | South Dakota | 46011 | 137 | 1 |
420563 | 420563 | 2020-08-10 | Brookings | South Dakota | 46011 | 139 | 1 |
423785 | 423785 | 2020-08-11 | Brookings | South Dakota | 46011 | 140 | 1 |
427008 | 427008 | 2020-08-12 | Brookings | South Dakota | 46011 | 142 | 1 |
430234 | 430234 | 2020-08-13 | Brookings | South Dakota | 46011 | 143 | 1 |
433459 | 433459 | 2020-08-14 | Brookings | South Dakota | 46011 | 145 | 1 |
436686 | 436686 | 2020-08-15 | Brookings | South Dakota | 46011 | 151 | 1 |
439911 | 439911 | 2020-08-16 | Brookings | South Dakota | 46011 | 154 | 1 |
443138 | 443138 | 2020-08-17 | Brookings | South Dakota | 46011 | 156 | 1 |
446364 | 446364 | 2020-08-18 | Brookings | South Dakota | 46011 | 157 | 1 |
449592 | 449592 | 2020-08-19 | Brookings | South Dakota | 46011 | 162 | 1 |
452820 | 452820 | 2020-08-20 | Brookings | South Dakota | 46011 | 166 | 1 |
456048 | 456048 | 2020-08-21 | Brookings | South Dakota | 46011 | 169 | 1 |
459276 | 459276 | 2020-08-22 | Brookings | South Dakota | 46011 | 174 | 1 |
462504 | 462504 | 2020-08-23 | Brookings | South Dakota | 46011 | 182 | 1 |
465733 | 465733 | 2020-08-24 | Brookings | South Dakota | 46011 | 188 | 1 |
468961 | 468961 | 2020-08-25 | Brookings | South Dakota | 46011 | 195 | 1 |
472193 | 472193 | 2020-08-26 | Brookings | South Dakota | 46011 | 197 | 1 |
475427 | 475427 | 2020-08-27 | Brookings | South Dakota | 46011 | 224 | 1 |
478660 | 478660 | 2020-08-28 | Brookings | South Dakota | 46011 | 240 | 1 |
481894 | 481894 | 2020-08-29 | Brookings | South Dakota | 46011 | 269 | 1 |
485129 | 485129 | 2020-08-30 | Brookings | South Dakota | 46011 | 308 | 1 |
488362 | 488362 | 2020-08-31 | Brookings | South Dakota | 46011 | 321 | 1 |
491595 | 491595 | 2020-09-01 | Brookings | South Dakota | 46011 | 340 | 1 |
494829 | 494829 | 2020-09-02 | Brookings | South Dakota | 46011 | 362 | 1 |
498062 | 498062 | 2020-09-03 | Brookings | South Dakota | 46011 | 402 | 1 |
501296 | 501296 | 2020-09-04 | Brookings | South Dakota | 46011 | 431 | 1 |
504530 | 504530 | 2020-09-05 | Brookings | South Dakota | 46011 | 468 | 1 |
507762 | 507762 | 2020-09-06 | Brookings | South Dakota | 46011 | 491 | 1 |
510995 | 510995 | 2020-09-07 | Brookings | South Dakota | 46011 | 523 | 1 |
514228 | 514228 | 2020-09-08 | Brookings | South Dakota | 46011 | 534 | 1 |
517463 | 517463 | 2020-09-09 | Brookings | South Dakota | 46011 | 538 | 1 |
520699 | 520699 | 2020-09-10 | Brookings | South Dakota | 46011 | 556 | 1 |
523935 | 523935 | 2020-09-11 | Brookings | South Dakota | 46011 | 567 | 1 |
527171 | 527171 | 2020-09-12 | Brookings | South Dakota | 46011 | 589 | 1 |
530408 | 530408 | 2020-09-13 | Brookings | South Dakota | 46011 | 595 | 1 |
533643 | 533643 | 2020-09-14 | Brookings | South Dakota | 46011 | 600 | 1 |
536879 | 536879 | 2020-09-15 | Brookings | South Dakota | 46011 | 603 | 1 |
540116 | 540116 | 2020-09-16 | Brookings | South Dakota | 46011 | 609 | 2 |
543352 | 543352 | 2020-09-17 | Brookings | South Dakota | 46011 | 622 | 2 |
546589 | 546589 | 2020-09-18 | Brookings | South Dakota | 46011 | 632 | 2 |
549828 | 549828 | 2020-09-19 | Brookings | South Dakota | 46011 | 658 | 2 |
553067 | 553067 | 2020-09-20 | Brookings | South Dakota | 46011 | 665 | 2 |
556304 | 556304 | 2020-09-21 | Brookings | South Dakota | 46011 | 680 | 2 |
559541 | 559541 | 2020-09-22 | Brookings | South Dakota | 46011 | 696 | 2 |
562778 | 562778 | 2020-09-23 | Brookings | South Dakota | 46011 | 704 | 2 |
566019 | 566019 | 2020-09-24 | Brookings | South Dakota | 46011 | 719 | 2 |
569260 | 569260 | 2020-09-25 | Brookings | South Dakota | 46011 | 731 | 2 |
572502 | 572502 | 2020-09-26 | Brookings | South Dakota | 46011 | 751 | 2 |
575746 | 575746 | 2020-09-27 | Brookings | South Dakota | 46011 | 763 | 2 |
578987 | 578987 | 2020-09-28 | Brookings | South Dakota | 46011 | 768 | 2 |
582227 | 582227 | 2020-09-29 | Brookings | South Dakota | 46011 | 771 | 2 |
585467 | 585467 | 2020-09-30 | Brookings | South Dakota | 46011 | 779 | 2 |
588707 | 588707 | 2020-10-01 | Brookings | South Dakota | 46011 | 815 | 2 |
591948 | 591948 | 2020-10-02 | Brookings | South Dakota | 46011 | 822 | 2 |
595189 | 595189 | 2020-10-03 | Brookings | South Dakota | 46011 | 833 | 2 |
598432 | 598432 | 2020-10-04 | Brookings | South Dakota | 46011 | 842 | 2 |
601675 | 601675 | 2020-10-05 | Brookings | South Dakota | 46011 | 846 | 2 |
604917 | 604917 | 2020-10-06 | Brookings | South Dakota | 46011 | 849 | 2 |
608160 | 608160 | 2020-10-07 | Brookings | South Dakota | 46011 | 863 | 2 |
611402 | 611402 | 2020-10-08 | Brookings | South Dakota | 46011 | 874 | 2 |
614643 | 614643 | 2020-10-09 | Brookings | South Dakota | 46011 | 907 | 2 |
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);