ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
150 rows where county = "Dewey", deaths = 0 and fips = 46041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
692517 | 692517 | 2020-11-02 | Dewey | South Dakota | 46041 | 406 | 0 |
689273 | 689273 | 2020-11-01 | Dewey | South Dakota | 46041 | 404 | 0 |
686028 | 686028 | 2020-10-31 | Dewey | South Dakota | 46041 | 403 | 0 |
682785 | 682785 | 2020-10-30 | Dewey | South Dakota | 46041 | 387 | 0 |
679542 | 679542 | 2020-10-29 | Dewey | South Dakota | 46041 | 330 | 0 |
676299 | 676299 | 2020-10-28 | Dewey | South Dakota | 46041 | 327 | 0 |
673056 | 673056 | 2020-10-27 | Dewey | South Dakota | 46041 | 308 | 0 |
669814 | 669814 | 2020-10-26 | Dewey | South Dakota | 46041 | 298 | 0 |
666570 | 666570 | 2020-10-25 | Dewey | South Dakota | 46041 | 298 | 0 |
663325 | 663325 | 2020-10-24 | Dewey | South Dakota | 46041 | 291 | 0 |
660081 | 660081 | 2020-10-23 | Dewey | South Dakota | 46041 | 291 | 0 |
656837 | 656837 | 2020-10-22 | Dewey | South Dakota | 46041 | 277 | 0 |
653592 | 653592 | 2020-10-21 | Dewey | South Dakota | 46041 | 276 | 0 |
650347 | 650347 | 2020-10-20 | Dewey | South Dakota | 46041 | 275 | 0 |
647103 | 647103 | 2020-10-19 | Dewey | South Dakota | 46041 | 268 | 0 |
643857 | 643857 | 2020-10-18 | Dewey | South Dakota | 46041 | 266 | 0 |
640609 | 640609 | 2020-10-17 | Dewey | South Dakota | 46041 | 259 | 0 |
637363 | 637363 | 2020-10-16 | Dewey | South Dakota | 46041 | 257 | 0 |
634117 | 634117 | 2020-10-15 | Dewey | South Dakota | 46041 | 252 | 0 |
630872 | 630872 | 2020-10-14 | Dewey | South Dakota | 46041 | 230 | 0 |
627628 | 627628 | 2020-10-13 | Dewey | South Dakota | 46041 | 220 | 0 |
624386 | 624386 | 2020-10-12 | Dewey | South Dakota | 46041 | 220 | 0 |
621143 | 621143 | 2020-10-11 | Dewey | South Dakota | 46041 | 211 | 0 |
617900 | 617900 | 2020-10-10 | Dewey | South Dakota | 46041 | 206 | 0 |
614658 | 614658 | 2020-10-09 | Dewey | South Dakota | 46041 | 202 | 0 |
611417 | 611417 | 2020-10-08 | Dewey | South Dakota | 46041 | 196 | 0 |
608175 | 608175 | 2020-10-07 | Dewey | South Dakota | 46041 | 190 | 0 |
604932 | 604932 | 2020-10-06 | Dewey | South Dakota | 46041 | 183 | 0 |
601690 | 601690 | 2020-10-05 | Dewey | South Dakota | 46041 | 179 | 0 |
598447 | 598447 | 2020-10-04 | Dewey | South Dakota | 46041 | 179 | 0 |
595204 | 595204 | 2020-10-03 | Dewey | South Dakota | 46041 | 174 | 0 |
591963 | 591963 | 2020-10-02 | Dewey | South Dakota | 46041 | 167 | 0 |
588722 | 588722 | 2020-10-01 | Dewey | South Dakota | 46041 | 165 | 0 |
585482 | 585482 | 2020-09-30 | Dewey | South Dakota | 46041 | 158 | 0 |
582242 | 582242 | 2020-09-29 | Dewey | South Dakota | 46041 | 153 | 0 |
579002 | 579002 | 2020-09-28 | Dewey | South Dakota | 46041 | 146 | 0 |
575761 | 575761 | 2020-09-27 | Dewey | South Dakota | 46041 | 144 | 0 |
572517 | 572517 | 2020-09-26 | Dewey | South Dakota | 46041 | 144 | 0 |
569275 | 569275 | 2020-09-25 | Dewey | South Dakota | 46041 | 143 | 0 |
566034 | 566034 | 2020-09-24 | Dewey | South Dakota | 46041 | 134 | 0 |
562793 | 562793 | 2020-09-23 | Dewey | South Dakota | 46041 | 125 | 0 |
559556 | 559556 | 2020-09-22 | Dewey | South Dakota | 46041 | 121 | 0 |
556319 | 556319 | 2020-09-21 | Dewey | South Dakota | 46041 | 117 | 0 |
553082 | 553082 | 2020-09-20 | Dewey | South Dakota | 46041 | 116 | 0 |
549843 | 549843 | 2020-09-19 | Dewey | South Dakota | 46041 | 115 | 0 |
546604 | 546604 | 2020-09-18 | Dewey | South Dakota | 46041 | 112 | 0 |
543367 | 543367 | 2020-09-17 | Dewey | South Dakota | 46041 | 108 | 0 |
540131 | 540131 | 2020-09-16 | Dewey | South Dakota | 46041 | 108 | 0 |
536894 | 536894 | 2020-09-15 | Dewey | South Dakota | 46041 | 108 | 0 |
533658 | 533658 | 2020-09-14 | Dewey | South Dakota | 46041 | 108 | 0 |
530423 | 530423 | 2020-09-13 | Dewey | South Dakota | 46041 | 103 | 0 |
527186 | 527186 | 2020-09-12 | Dewey | South Dakota | 46041 | 103 | 0 |
523950 | 523950 | 2020-09-11 | Dewey | South Dakota | 46041 | 102 | 0 |
520714 | 520714 | 2020-09-10 | Dewey | South Dakota | 46041 | 101 | 0 |
517478 | 517478 | 2020-09-09 | Dewey | South Dakota | 46041 | 95 | 0 |
514243 | 514243 | 2020-09-08 | Dewey | South Dakota | 46041 | 93 | 0 |
511010 | 511010 | 2020-09-07 | Dewey | South Dakota | 46041 | 93 | 0 |
507777 | 507777 | 2020-09-06 | Dewey | South Dakota | 46041 | 93 | 0 |
504545 | 504545 | 2020-09-05 | Dewey | South Dakota | 46041 | 91 | 0 |
501311 | 501311 | 2020-09-04 | Dewey | South Dakota | 46041 | 92 | 0 |
498077 | 498077 | 2020-09-03 | Dewey | South Dakota | 46041 | 89 | 0 |
494844 | 494844 | 2020-09-02 | Dewey | South Dakota | 46041 | 84 | 0 |
491610 | 491610 | 2020-09-01 | Dewey | South Dakota | 46041 | 82 | 0 |
488377 | 488377 | 2020-08-31 | Dewey | South Dakota | 46041 | 79 | 0 |
485144 | 485144 | 2020-08-30 | Dewey | South Dakota | 46041 | 79 | 0 |
481909 | 481909 | 2020-08-29 | Dewey | South Dakota | 46041 | 77 | 0 |
478675 | 478675 | 2020-08-28 | Dewey | South Dakota | 46041 | 73 | 0 |
475442 | 475442 | 2020-08-27 | Dewey | South Dakota | 46041 | 72 | 0 |
472208 | 472208 | 2020-08-26 | Dewey | South Dakota | 46041 | 68 | 0 |
468976 | 468976 | 2020-08-25 | Dewey | South Dakota | 46041 | 65 | 0 |
465748 | 465748 | 2020-08-24 | Dewey | South Dakota | 46041 | 65 | 0 |
462519 | 462519 | 2020-08-23 | Dewey | South Dakota | 46041 | 65 | 0 |
459291 | 459291 | 2020-08-22 | Dewey | South Dakota | 46041 | 64 | 0 |
456063 | 456063 | 2020-08-21 | Dewey | South Dakota | 46041 | 62 | 0 |
452835 | 452835 | 2020-08-20 | Dewey | South Dakota | 46041 | 61 | 0 |
449607 | 449607 | 2020-08-19 | Dewey | South Dakota | 46041 | 60 | 0 |
446379 | 446379 | 2020-08-18 | Dewey | South Dakota | 46041 | 59 | 0 |
443153 | 443153 | 2020-08-17 | Dewey | South Dakota | 46041 | 59 | 0 |
439926 | 439926 | 2020-08-16 | Dewey | South Dakota | 46041 | 58 | 0 |
436701 | 436701 | 2020-08-15 | Dewey | South Dakota | 46041 | 57 | 0 |
433474 | 433474 | 2020-08-14 | Dewey | South Dakota | 46041 | 57 | 0 |
430249 | 430249 | 2020-08-13 | Dewey | South Dakota | 46041 | 49 | 0 |
427023 | 427023 | 2020-08-12 | Dewey | South Dakota | 46041 | 49 | 0 |
423800 | 423800 | 2020-08-11 | Dewey | South Dakota | 46041 | 48 | 0 |
420578 | 420578 | 2020-08-10 | Dewey | South Dakota | 46041 | 48 | 0 |
417357 | 417357 | 2020-08-09 | Dewey | South Dakota | 46041 | 48 | 0 |
414136 | 414136 | 2020-08-08 | Dewey | South Dakota | 46041 | 49 | 0 |
410916 | 410916 | 2020-08-07 | Dewey | South Dakota | 46041 | 50 | 0 |
407697 | 407697 | 2020-08-06 | Dewey | South Dakota | 46041 | 65 | 0 |
404477 | 404477 | 2020-08-05 | Dewey | South Dakota | 46041 | 64 | 0 |
401259 | 401259 | 2020-08-04 | Dewey | South Dakota | 46041 | 63 | 0 |
398044 | 398044 | 2020-08-03 | Dewey | South Dakota | 46041 | 61 | 0 |
394827 | 394827 | 2020-08-02 | Dewey | South Dakota | 46041 | 59 | 0 |
391611 | 391611 | 2020-08-01 | Dewey | South Dakota | 46041 | 59 | 0 |
388394 | 388394 | 2020-07-31 | Dewey | South Dakota | 46041 | 58 | 0 |
385177 | 385177 | 2020-07-30 | Dewey | South Dakota | 46041 | 56 | 0 |
381959 | 381959 | 2020-07-29 | Dewey | South Dakota | 46041 | 54 | 0 |
378742 | 378742 | 2020-07-28 | Dewey | South Dakota | 46041 | 53 | 0 |
375526 | 375526 | 2020-07-27 | Dewey | South Dakota | 46041 | 53 | 0 |
372313 | 372313 | 2020-07-26 | Dewey | South Dakota | 46041 | 53 | 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);