ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 36091 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
737334 | 737334 | 2020-11-16 | Saratoga | New York | 36091 | 1694 | 17 |
734090 | 734090 | 2020-11-15 | Saratoga | New York | 36091 | 1680 | 17 |
730844 | 730844 | 2020-11-14 | Saratoga | New York | 36091 | 1666 | 17 |
727600 | 727600 | 2020-11-13 | Saratoga | New York | 36091 | 1642 | 17 |
724356 | 724356 | 2020-11-12 | Saratoga | New York | 36091 | 1611 | 17 |
721113 | 721113 | 2020-11-11 | Saratoga | New York | 36091 | 1583 | 17 |
717870 | 717870 | 2020-11-10 | Saratoga | New York | 36091 | 1567 | 17 |
714627 | 714627 | 2020-11-09 | Saratoga | New York | 36091 | 1553 | 17 |
711383 | 711383 | 2020-11-08 | Saratoga | New York | 36091 | 1541 | 17 |
708139 | 708139 | 2020-11-07 | Saratoga | New York | 36091 | 1520 | 17 |
704896 | 704896 | 2020-11-06 | Saratoga | New York | 36091 | 1503 | 17 |
701653 | 701653 | 2020-11-05 | Saratoga | New York | 36091 | 1482 | 17 |
698409 | 698409 | 2020-11-04 | Saratoga | New York | 36091 | 1458 | 17 |
695166 | 695166 | 2020-11-03 | Saratoga | New York | 36091 | 1448 | 17 |
691924 | 691924 | 2020-11-02 | Saratoga | New York | 36091 | 1438 | 17 |
688680 | 688680 | 2020-11-01 | Saratoga | New York | 36091 | 1423 | 17 |
685435 | 685435 | 2020-10-31 | Saratoga | New York | 36091 | 1405 | 17 |
682192 | 682192 | 2020-10-30 | Saratoga | New York | 36091 | 1383 | 17 |
678949 | 678949 | 2020-10-29 | Saratoga | New York | 36091 | 1365 | 17 |
675706 | 675706 | 2020-10-28 | Saratoga | New York | 36091 | 1345 | 17 |
672463 | 672463 | 2020-10-27 | Saratoga | New York | 36091 | 1334 | 17 |
669221 | 669221 | 2020-10-26 | Saratoga | New York | 36091 | 1319 | 17 |
665977 | 665977 | 2020-10-25 | Saratoga | New York | 36091 | 1308 | 15 |
662732 | 662732 | 2020-10-24 | Saratoga | New York | 36091 | 1295 | 15 |
659488 | 659488 | 2020-10-23 | Saratoga | New York | 36091 | 1265 | 15 |
656244 | 656244 | 2020-10-22 | Saratoga | New York | 36091 | 1244 | 15 |
652999 | 652999 | 2020-10-21 | Saratoga | New York | 36091 | 1229 | 15 |
649754 | 649754 | 2020-10-20 | Saratoga | New York | 36091 | 1219 | 15 |
646510 | 646510 | 2020-10-19 | Saratoga | New York | 36091 | 1213 | 15 |
643264 | 643264 | 2020-10-18 | Saratoga | New York | 36091 | 1207 | 15 |
640016 | 640016 | 2020-10-17 | Saratoga | New York | 36091 | 1202 | 15 |
636770 | 636770 | 2020-10-16 | Saratoga | New York | 36091 | 1190 | 15 |
633524 | 633524 | 2020-10-15 | Saratoga | New York | 36091 | 1182 | 15 |
630279 | 630279 | 2020-10-14 | Saratoga | New York | 36091 | 1174 | 15 |
627035 | 627035 | 2020-10-13 | Saratoga | New York | 36091 | 1168 | 15 |
623793 | 623793 | 2020-10-12 | Saratoga | New York | 36091 | 1158 | 15 |
620550 | 620550 | 2020-10-11 | Saratoga | New York | 36091 | 1149 | 15 |
617308 | 617308 | 2020-10-10 | Saratoga | New York | 36091 | 1141 | 15 |
614066 | 614066 | 2020-10-09 | Saratoga | New York | 36091 | 1139 | 15 |
610825 | 610825 | 2020-10-08 | Saratoga | New York | 36091 | 1122 | 15 |
607583 | 607583 | 2020-10-07 | Saratoga | New York | 36091 | 1111 | 15 |
604340 | 604340 | 2020-10-06 | Saratoga | New York | 36091 | 1103 | 15 |
601098 | 601098 | 2020-10-05 | Saratoga | New York | 36091 | 1100 | 15 |
597855 | 597855 | 2020-10-04 | Saratoga | New York | 36091 | 1095 | 15 |
594612 | 594612 | 2020-10-03 | Saratoga | New York | 36091 | 1090 | 15 |
591371 | 591371 | 2020-10-02 | Saratoga | New York | 36091 | 1083 | 15 |
588130 | 588130 | 2020-10-01 | Saratoga | New York | 36091 | 1073 | 15 |
584890 | 584890 | 2020-09-30 | Saratoga | New York | 36091 | 1066 | 15 |
581649 | 581649 | 2020-09-29 | Saratoga | New York | 36091 | 1060 | 15 |
578409 | 578409 | 2020-09-28 | Saratoga | New York | 36091 | 1052 | 15 |
575168 | 575168 | 2020-09-27 | Saratoga | New York | 36091 | 1044 | 15 |
571924 | 571924 | 2020-09-26 | Saratoga | New York | 36091 | 1036 | 15 |
568682 | 568682 | 2020-09-25 | Saratoga | New York | 36091 | 1031 | 15 |
565441 | 565441 | 2020-09-24 | Saratoga | New York | 36091 | 1017 | 15 |
562200 | 562200 | 2020-09-23 | Saratoga | New York | 36091 | 1014 | 15 |
558963 | 558963 | 2020-09-22 | Saratoga | New York | 36091 | 1006 | 15 |
555726 | 555726 | 2020-09-21 | Saratoga | New York | 36091 | 1004 | 15 |
552489 | 552489 | 2020-09-20 | Saratoga | New York | 36091 | 998 | 15 |
549250 | 549250 | 2020-09-19 | Saratoga | New York | 36091 | 990 | 15 |
546011 | 546011 | 2020-09-18 | Saratoga | New York | 36091 | 985 | 15 |
542774 | 542774 | 2020-09-17 | Saratoga | New York | 36091 | 976 | 15 |
539538 | 539538 | 2020-09-16 | Saratoga | New York | 36091 | 970 | 15 |
536301 | 536301 | 2020-09-15 | Saratoga | New York | 36091 | 965 | 15 |
533065 | 533065 | 2020-09-14 | Saratoga | New York | 36091 | 964 | 15 |
529830 | 529830 | 2020-09-13 | Saratoga | New York | 36091 | 961 | 15 |
526593 | 526593 | 2020-09-12 | Saratoga | New York | 36091 | 955 | 15 |
523357 | 523357 | 2020-09-11 | Saratoga | New York | 36091 | 943 | 15 |
520121 | 520121 | 2020-09-10 | Saratoga | New York | 36091 | 918 | 15 |
516885 | 516885 | 2020-09-09 | Saratoga | New York | 36091 | 911 | 15 |
513650 | 513650 | 2020-09-08 | Saratoga | New York | 36091 | 900 | 15 |
510417 | 510417 | 2020-09-07 | Saratoga | New York | 36091 | 893 | 15 |
507184 | 507184 | 2020-09-06 | Saratoga | New York | 36091 | 889 | 15 |
503952 | 503952 | 2020-09-05 | Saratoga | New York | 36091 | 877 | 15 |
500718 | 500718 | 2020-09-04 | Saratoga | New York | 36091 | 868 | 15 |
497484 | 497484 | 2020-09-03 | Saratoga | New York | 36091 | 863 | 15 |
494251 | 494251 | 2020-09-02 | Saratoga | New York | 36091 | 852 | 15 |
491017 | 491017 | 2020-09-01 | Saratoga | New York | 36091 | 846 | 15 |
487784 | 487784 | 2020-08-31 | Saratoga | New York | 36091 | 844 | 15 |
484551 | 484551 | 2020-08-30 | Saratoga | New York | 36091 | 842 | 15 |
481316 | 481316 | 2020-08-29 | Saratoga | New York | 36091 | 832 | 15 |
478083 | 478083 | 2020-08-28 | Saratoga | New York | 36091 | 832 | 15 |
474850 | 474850 | 2020-08-27 | Saratoga | New York | 36091 | 829 | 15 |
471616 | 471616 | 2020-08-26 | Saratoga | New York | 36091 | 824 | 15 |
468384 | 468384 | 2020-08-25 | Saratoga | New York | 36091 | 824 | 15 |
465156 | 465156 | 2020-08-24 | Saratoga | New York | 36091 | 816 | 15 |
461927 | 461927 | 2020-08-23 | Saratoga | New York | 36091 | 815 | 15 |
458699 | 458699 | 2020-08-22 | Saratoga | New York | 36091 | 813 | 15 |
455471 | 455471 | 2020-08-21 | Saratoga | New York | 36091 | 808 | 15 |
452243 | 452243 | 2020-08-20 | Saratoga | New York | 36091 | 802 | 15 |
449015 | 449015 | 2020-08-19 | Saratoga | New York | 36091 | 800 | 15 |
445787 | 445787 | 2020-08-18 | Saratoga | New York | 36091 | 800 | 15 |
442561 | 442561 | 2020-08-17 | Saratoga | New York | 36091 | 795 | 15 |
439334 | 439334 | 2020-08-16 | Saratoga | New York | 36091 | 792 | 15 |
436109 | 436109 | 2020-08-15 | Saratoga | New York | 36091 | 783 | 15 |
432883 | 432883 | 2020-08-14 | Saratoga | New York | 36091 | 782 | 15 |
429657 | 429657 | 2020-08-13 | Saratoga | New York | 36091 | 774 | 15 |
426432 | 426432 | 2020-08-12 | Saratoga | New York | 36091 | 768 | 15 |
423209 | 423209 | 2020-08-11 | Saratoga | New York | 36091 | 767 | 15 |
419986 | 419986 | 2020-08-10 | Saratoga | New York | 36091 | 760 | 15 |
416766 | 416766 | 2020-08-09 | Saratoga | New York | 36091 | 757 | 15 |
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);