ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Saratoga" 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 |
---|---|---|---|---|---|---|---|
948287 | 948287 | 2021-01-20 | Saratoga | New York | 36091 | 9375 | 83 |
945040 | 945040 | 2021-01-19 | Saratoga | New York | 36091 | 9267 | 82 |
941794 | 941794 | 2021-01-18 | Saratoga | New York | 36091 | 9140 | 80 |
938549 | 938549 | 2021-01-17 | Saratoga | New York | 36091 | 8984 | 79 |
935304 | 935304 | 2021-01-16 | Saratoga | New York | 36091 | 8839 | 78 |
932059 | 932059 | 2021-01-15 | Saratoga | New York | 36091 | 8653 | 76 |
928814 | 928814 | 2021-01-14 | Saratoga | New York | 36091 | 8447 | 69 |
925569 | 925569 | 2021-01-13 | Saratoga | New York | 36091 | 8226 | 65 |
922323 | 922323 | 2021-01-12 | Saratoga | New York | 36091 | 8124 | 62 |
919078 | 919078 | 2021-01-11 | Saratoga | New York | 36091 | 7960 | 59 |
915833 | 915833 | 2021-01-10 | Saratoga | New York | 36091 | 7753 | 53 |
912588 | 912588 | 2021-01-09 | Saratoga | New York | 36091 | 7511 | 52 |
909343 | 909343 | 2021-01-08 | Saratoga | New York | 36091 | 7303 | 51 |
906098 | 906098 | 2021-01-07 | Saratoga | New York | 36091 | 7027 | 49 |
902852 | 902852 | 2021-01-06 | Saratoga | New York | 36091 | 6753 | 48 |
899607 | 899607 | 2021-01-05 | Saratoga | New York | 36091 | 6543 | 48 |
896362 | 896362 | 2021-01-04 | Saratoga | New York | 36091 | 6360 | 48 |
893116 | 893116 | 2021-01-03 | Saratoga | New York | 36091 | 6243 | 48 |
889870 | 889870 | 2021-01-02 | Saratoga | New York | 36091 | 6060 | 44 |
886623 | 886623 | 2021-01-01 | Saratoga | New York | 36091 | 5796 | 43 |
883378 | 883378 | 2020-12-31 | Saratoga | New York | 36091 | 5588 | 40 |
880133 | 880133 | 2020-12-30 | Saratoga | New York | 36091 | 5413 | 38 |
876888 | 876888 | 2020-12-29 | Saratoga | New York | 36091 | 5268 | 38 |
873643 | 873643 | 2020-12-28 | Saratoga | New York | 36091 | 5130 | 36 |
870398 | 870398 | 2020-12-27 | Saratoga | New York | 36091 | 4993 | 35 |
867153 | 867153 | 2020-12-26 | Saratoga | New York | 36091 | 4868 | 34 |
863908 | 863908 | 2020-12-25 | Saratoga | New York | 36091 | 4741 | 32 |
860663 | 860663 | 2020-12-24 | Saratoga | New York | 36091 | 4608 | 30 |
857418 | 857418 | 2020-12-23 | Saratoga | New York | 36091 | 4414 | 29 |
854173 | 854173 | 2020-12-22 | Saratoga | New York | 36091 | 4316 | 29 |
850928 | 850928 | 2020-12-21 | Saratoga | New York | 36091 | 4179 | 29 |
847683 | 847683 | 2020-12-20 | Saratoga | New York | 36091 | 4096 | 28 |
844438 | 844438 | 2020-12-19 | Saratoga | New York | 36091 | 4008 | 28 |
841192 | 841192 | 2020-12-18 | Saratoga | New York | 36091 | 3908 | 27 |
837947 | 837947 | 2020-12-17 | Saratoga | New York | 36091 | 3809 | 26 |
834701 | 834701 | 2020-12-16 | Saratoga | New York | 36091 | 3716 | 26 |
831455 | 831455 | 2020-12-15 | Saratoga | New York | 36091 | 3599 | 25 |
828208 | 828208 | 2020-12-14 | Saratoga | New York | 36091 | 3477 | 24 |
824962 | 824962 | 2020-12-13 | Saratoga | New York | 36091 | 3366 | 24 |
821715 | 821715 | 2020-12-12 | Saratoga | New York | 36091 | 3298 | 24 |
818469 | 818469 | 2020-12-11 | Saratoga | New York | 36091 | 3183 | 24 |
815223 | 815223 | 2020-12-10 | Saratoga | New York | 36091 | 3065 | 23 |
811978 | 811978 | 2020-12-09 | Saratoga | New York | 36091 | 2965 | 22 |
808733 | 808733 | 2020-12-08 | Saratoga | New York | 36091 | 2888 | 22 |
805488 | 805488 | 2020-12-07 | Saratoga | New York | 36091 | 2787 | 22 |
802243 | 802243 | 2020-12-06 | Saratoga | New York | 36091 | 2734 | 21 |
798998 | 798998 | 2020-12-05 | Saratoga | New York | 36091 | 2672 | 21 |
795753 | 795753 | 2020-12-04 | Saratoga | New York | 36091 | 2581 | 21 |
792508 | 792508 | 2020-12-03 | Saratoga | New York | 36091 | 2488 | 21 |
789263 | 789263 | 2020-12-02 | Saratoga | New York | 36091 | 2413 | 21 |
786018 | 786018 | 2020-12-01 | Saratoga | New York | 36091 | 2370 | 21 |
782774 | 782774 | 2020-11-30 | Saratoga | New York | 36091 | 2293 | 21 |
779528 | 779528 | 2020-11-29 | Saratoga | New York | 36091 | 2245 | 20 |
776283 | 776283 | 2020-11-28 | Saratoga | New York | 36091 | 2180 | 20 |
773038 | 773038 | 2020-11-27 | Saratoga | New York | 36091 | 2151 | 20 |
769793 | 769793 | 2020-11-26 | Saratoga | New York | 36091 | 2089 | 19 |
766547 | 766547 | 2020-11-25 | Saratoga | New York | 36091 | 2045 | 19 |
763302 | 763302 | 2020-11-24 | Saratoga | New York | 36091 | 2006 | 19 |
760057 | 760057 | 2020-11-23 | Saratoga | New York | 36091 | 1969 | 19 |
756811 | 756811 | 2020-11-22 | Saratoga | New York | 36091 | 1904 | 19 |
753564 | 753564 | 2020-11-21 | Saratoga | New York | 36091 | 1875 | 19 |
750318 | 750318 | 2020-11-20 | Saratoga | New York | 36091 | 1842 | 19 |
747072 | 747072 | 2020-11-19 | Saratoga | New York | 36091 | 1804 | 18 |
743826 | 743826 | 2020-11-18 | Saratoga | New York | 36091 | 1769 | 17 |
740579 | 740579 | 2020-11-17 | Saratoga | New York | 36091 | 1741 | 17 |
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 |
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);