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 |
---|---|---|---|---|---|---|---|
1061884 | 1061884 | 2021-02-24 | Saratoga | New York | 36091 | 11723 | 145 |
1058638 | 1058638 | 2021-02-23 | Saratoga | New York | 36091 | 11687 | 145 |
1055392 | 1055392 | 2021-02-22 | Saratoga | New York | 36091 | 11642 | 143 |
1052146 | 1052146 | 2021-02-21 | Saratoga | New York | 36091 | 11604 | 143 |
1048899 | 1048899 | 2021-02-20 | Saratoga | New York | 36091 | 11560 | 141 |
1045652 | 1045652 | 2021-02-19 | Saratoga | New York | 36091 | 11517 | 141 |
1042407 | 1042407 | 2021-02-18 | Saratoga | New York | 36091 | 11484 | 141 |
1039162 | 1039162 | 2021-02-17 | Saratoga | New York | 36091 | 11441 | 141 |
1035917 | 1035917 | 2021-02-16 | Saratoga | New York | 36091 | 11415 | 141 |
1032672 | 1032672 | 2021-02-15 | Saratoga | New York | 36091 | 11379 | 141 |
1029426 | 1029426 | 2021-02-14 | Saratoga | New York | 36091 | 11349 | 141 |
1026179 | 1026179 | 2021-02-13 | Saratoga | New York | 36091 | 11304 | 141 |
1022934 | 1022934 | 2021-02-12 | Saratoga | New York | 36091 | 11256 | 140 |
1019689 | 1019689 | 2021-02-11 | Saratoga | New York | 36091 | 11212 | 138 |
1016444 | 1016444 | 2021-02-10 | Saratoga | New York | 36091 | 11168 | 137 |
1013199 | 1013199 | 2021-02-09 | Saratoga | New York | 36091 | 11109 | 132 |
1009954 | 1009954 | 2021-02-08 | Saratoga | New York | 36091 | 11067 | 129 |
1006708 | 1006708 | 2021-02-07 | Saratoga | New York | 36091 | 11017 | 129 |
1003462 | 1003462 | 2021-02-06 | Saratoga | New York | 36091 | 10942 | 127 |
1000216 | 1000216 | 2021-02-05 | Saratoga | New York | 36091 | 10869 | 127 |
996970 | 996970 | 2021-02-04 | Saratoga | New York | 36091 | 10795 | 125 |
993724 | 993724 | 2021-02-03 | Saratoga | New York | 36091 | 10718 | 124 |
990478 | 990478 | 2021-02-02 | Saratoga | New York | 36091 | 10657 | 121 |
987232 | 987232 | 2021-02-01 | Saratoga | New York | 36091 | 10604 | 120 |
983985 | 983985 | 2021-01-31 | Saratoga | New York | 36091 | 10548 | 120 |
980738 | 980738 | 2021-01-30 | Saratoga | New York | 36091 | 10475 | 118 |
977492 | 977492 | 2021-01-29 | Saratoga | New York | 36091 | 10390 | 116 |
974247 | 974247 | 2021-01-28 | Saratoga | New York | 36091 | 10304 | 113 |
971002 | 971002 | 2021-01-27 | Saratoga | New York | 36091 | 10198 | 110 |
967757 | 967757 | 2021-01-26 | Saratoga | New York | 36091 | 10109 | 108 |
964513 | 964513 | 2021-01-25 | Saratoga | New York | 36091 | 10020 | 101 |
961268 | 961268 | 2021-01-24 | Saratoga | New York | 36091 | 9951 | 95 |
958023 | 958023 | 2021-01-23 | Saratoga | New York | 36091 | 9842 | 89 |
954777 | 954777 | 2021-01-22 | Saratoga | New York | 36091 | 9689 | 86 |
951532 | 951532 | 2021-01-21 | Saratoga | New York | 36091 | 9527 | 84 |
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 |
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);