ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where deaths = 42 and fips = 36083 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 |
---|---|---|---|---|---|---|---|
675704 | 675704 | 2020-10-28 | Rensselaer | New York | 36083 | 1099 | 42 |
672461 | 672461 | 2020-10-27 | Rensselaer | New York | 36083 | 1094 | 42 |
669219 | 669219 | 2020-10-26 | Rensselaer | New York | 36083 | 1088 | 42 |
665975 | 665975 | 2020-10-25 | Rensselaer | New York | 36083 | 1080 | 42 |
662730 | 662730 | 2020-10-24 | Rensselaer | New York | 36083 | 1073 | 42 |
659486 | 659486 | 2020-10-23 | Rensselaer | New York | 36083 | 1064 | 42 |
656242 | 656242 | 2020-10-22 | Rensselaer | New York | 36083 | 1058 | 42 |
652997 | 652997 | 2020-10-21 | Rensselaer | New York | 36083 | 1047 | 42 |
649752 | 649752 | 2020-10-20 | Rensselaer | New York | 36083 | 1040 | 42 |
646508 | 646508 | 2020-10-19 | Rensselaer | New York | 36083 | 1034 | 42 |
643262 | 643262 | 2020-10-18 | Rensselaer | New York | 36083 | 1027 | 42 |
640014 | 640014 | 2020-10-17 | Rensselaer | New York | 36083 | 1021 | 42 |
636768 | 636768 | 2020-10-16 | Rensselaer | New York | 36083 | 1020 | 42 |
633522 | 633522 | 2020-10-15 | Rensselaer | New York | 36083 | 1007 | 42 |
630277 | 630277 | 2020-10-14 | Rensselaer | New York | 36083 | 1002 | 42 |
627033 | 627033 | 2020-10-13 | Rensselaer | New York | 36083 | 994 | 42 |
623791 | 623791 | 2020-10-12 | Rensselaer | New York | 36083 | 985 | 42 |
620548 | 620548 | 2020-10-11 | Rensselaer | New York | 36083 | 980 | 42 |
617306 | 617306 | 2020-10-10 | Rensselaer | New York | 36083 | 970 | 42 |
614064 | 614064 | 2020-10-09 | Rensselaer | New York | 36083 | 964 | 42 |
610823 | 610823 | 2020-10-08 | Rensselaer | New York | 36083 | 958 | 42 |
607581 | 607581 | 2020-10-07 | Rensselaer | New York | 36083 | 957 | 42 |
604338 | 604338 | 2020-10-06 | Rensselaer | New York | 36083 | 952 | 42 |
601096 | 601096 | 2020-10-05 | Rensselaer | New York | 36083 | 945 | 42 |
597853 | 597853 | 2020-10-04 | Rensselaer | New York | 36083 | 944 | 42 |
594610 | 594610 | 2020-10-03 | Rensselaer | New York | 36083 | 937 | 42 |
591369 | 591369 | 2020-10-02 | Rensselaer | New York | 36083 | 931 | 42 |
588128 | 588128 | 2020-10-01 | Rensselaer | New York | 36083 | 923 | 42 |
584888 | 584888 | 2020-09-30 | Rensselaer | New York | 36083 | 919 | 42 |
581647 | 581647 | 2020-09-29 | Rensselaer | New York | 36083 | 916 | 42 |
578407 | 578407 | 2020-09-28 | Rensselaer | New York | 36083 | 913 | 42 |
575166 | 575166 | 2020-09-27 | Rensselaer | New York | 36083 | 911 | 42 |
571922 | 571922 | 2020-09-26 | Rensselaer | New York | 36083 | 908 | 42 |
568680 | 568680 | 2020-09-25 | Rensselaer | New York | 36083 | 905 | 42 |
565439 | 565439 | 2020-09-24 | Rensselaer | New York | 36083 | 903 | 42 |
562198 | 562198 | 2020-09-23 | Rensselaer | New York | 36083 | 902 | 42 |
558961 | 558961 | 2020-09-22 | Rensselaer | New York | 36083 | 901 | 42 |
555724 | 555724 | 2020-09-21 | Rensselaer | New York | 36083 | 901 | 42 |
552487 | 552487 | 2020-09-20 | Rensselaer | New York | 36083 | 899 | 42 |
549248 | 549248 | 2020-09-19 | Rensselaer | New York | 36083 | 896 | 42 |
546009 | 546009 | 2020-09-18 | Rensselaer | New York | 36083 | 895 | 42 |
542772 | 542772 | 2020-09-17 | Rensselaer | New York | 36083 | 892 | 42 |
539536 | 539536 | 2020-09-16 | Rensselaer | New York | 36083 | 887 | 42 |
536299 | 536299 | 2020-09-15 | Rensselaer | New York | 36083 | 884 | 42 |
533063 | 533063 | 2020-09-14 | Rensselaer | New York | 36083 | 879 | 42 |
529828 | 529828 | 2020-09-13 | Rensselaer | New York | 36083 | 879 | 42 |
526591 | 526591 | 2020-09-12 | Rensselaer | New York | 36083 | 876 | 42 |
523355 | 523355 | 2020-09-11 | Rensselaer | New York | 36083 | 870 | 42 |
520119 | 520119 | 2020-09-10 | Rensselaer | New York | 36083 | 867 | 42 |
516883 | 516883 | 2020-09-09 | Rensselaer | New York | 36083 | 866 | 42 |
513648 | 513648 | 2020-09-08 | Rensselaer | New York | 36083 | 865 | 42 |
510415 | 510415 | 2020-09-07 | Rensselaer | New York | 36083 | 860 | 42 |
507182 | 507182 | 2020-09-06 | Rensselaer | New York | 36083 | 859 | 42 |
503950 | 503950 | 2020-09-05 | Rensselaer | New York | 36083 | 858 | 42 |
500716 | 500716 | 2020-09-04 | Rensselaer | New York | 36083 | 854 | 42 |
497482 | 497482 | 2020-09-03 | Rensselaer | New York | 36083 | 848 | 42 |
494249 | 494249 | 2020-09-02 | Rensselaer | New York | 36083 | 844 | 42 |
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);