ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 36111 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 |
---|---|---|---|---|---|---|---|
1055403 | 1055403 | 2021-02-22 | Ulster | New York | 36111 | 9780 | 226 |
1052157 | 1052157 | 2021-02-21 | Ulster | New York | 36111 | 9754 | 226 |
1048910 | 1048910 | 2021-02-20 | Ulster | New York | 36111 | 9698 | 226 |
1045663 | 1045663 | 2021-02-19 | Ulster | New York | 36111 | 9658 | 226 |
1042418 | 1042418 | 2021-02-18 | Ulster | New York | 36111 | 9604 | 224 |
1039173 | 1039173 | 2021-02-17 | Ulster | New York | 36111 | 9569 | 224 |
1035928 | 1035928 | 2021-02-16 | Ulster | New York | 36111 | 9541 | 223 |
1032683 | 1032683 | 2021-02-15 | Ulster | New York | 36111 | 9498 | 221 |
1029437 | 1029437 | 2021-02-14 | Ulster | New York | 36111 | 9464 | 221 |
1026190 | 1026190 | 2021-02-13 | Ulster | New York | 36111 | 9426 | 220 |
1022945 | 1022945 | 2021-02-12 | Ulster | New York | 36111 | 9382 | 220 |
1019700 | 1019700 | 2021-02-11 | Ulster | New York | 36111 | 9345 | 220 |
1016455 | 1016455 | 2021-02-10 | Ulster | New York | 36111 | 9276 | 220 |
1013210 | 1013210 | 2021-02-09 | Ulster | New York | 36111 | 9216 | 218 |
1009965 | 1009965 | 2021-02-08 | Ulster | New York | 36111 | 9170 | 218 |
1006719 | 1006719 | 2021-02-07 | Ulster | New York | 36111 | 9121 | 217 |
1003473 | 1003473 | 2021-02-06 | Ulster | New York | 36111 | 9064 | 215 |
1000227 | 1000227 | 2021-02-05 | Ulster | New York | 36111 | 9014 | 214 |
996981 | 996981 | 2021-02-04 | Ulster | New York | 36111 | 8955 | 213 |
993735 | 993735 | 2021-02-03 | Ulster | New York | 36111 | 8909 | 212 |
990489 | 990489 | 2021-02-02 | Ulster | New York | 36111 | 8899 | 212 |
987243 | 987243 | 2021-02-01 | Ulster | New York | 36111 | 8858 | 211 |
983996 | 983996 | 2021-01-31 | Ulster | New York | 36111 | 8778 | 210 |
980749 | 980749 | 2021-01-30 | Ulster | New York | 36111 | 8716 | 209 |
977503 | 977503 | 2021-01-29 | Ulster | New York | 36111 | 8615 | 208 |
974258 | 974258 | 2021-01-28 | Ulster | New York | 36111 | 8533 | 207 |
971013 | 971013 | 2021-01-27 | Ulster | New York | 36111 | 8442 | 205 |
967768 | 967768 | 2021-01-26 | Ulster | New York | 36111 | 8388 | 205 |
964524 | 964524 | 2021-01-25 | Ulster | New York | 36111 | 8301 | 204 |
961279 | 961279 | 2021-01-24 | Ulster | New York | 36111 | 8227 | 202 |
958034 | 958034 | 2021-01-23 | Ulster | New York | 36111 | 8129 | 200 |
954788 | 954788 | 2021-01-22 | Ulster | New York | 36111 | 8017 | 199 |
951543 | 951543 | 2021-01-21 | Ulster | New York | 36111 | 7901 | 199 |
948298 | 948298 | 2021-01-20 | Ulster | New York | 36111 | 7822 | 196 |
945051 | 945051 | 2021-01-19 | Ulster | New York | 36111 | 7745 | 192 |
941805 | 941805 | 2021-01-18 | Ulster | New York | 36111 | 7642 | 191 |
938560 | 938560 | 2021-01-17 | Ulster | New York | 36111 | 7548 | 189 |
935315 | 935315 | 2021-01-16 | Ulster | New York | 36111 | 7448 | 186 |
932070 | 932070 | 2021-01-15 | Ulster | New York | 36111 | 7337 | 183 |
928825 | 928825 | 2021-01-14 | Ulster | New York | 36111 | 7181 | 179 |
925580 | 925580 | 2021-01-13 | Ulster | New York | 36111 | 7107 | 175 |
922334 | 922334 | 2021-01-12 | Ulster | New York | 36111 | 7038 | 175 |
919089 | 919089 | 2021-01-11 | Ulster | New York | 36111 | 6927 | 170 |
915844 | 915844 | 2021-01-10 | Ulster | New York | 36111 | 6835 | 167 |
912599 | 912599 | 2021-01-09 | Ulster | New York | 36111 | 6677 | 165 |
909354 | 909354 | 2021-01-08 | Ulster | New York | 36111 | 6557 | 158 |
906109 | 906109 | 2021-01-07 | Ulster | New York | 36111 | 6417 | 154 |
902863 | 902863 | 2021-01-06 | Ulster | New York | 36111 | 6304 | 151 |
899618 | 899618 | 2021-01-05 | Ulster | New York | 36111 | 6186 | 151 |
896373 | 896373 | 2021-01-04 | Ulster | New York | 36111 | 6089 | 149 |
893127 | 893127 | 2021-01-03 | Ulster | New York | 36111 | 6019 | 146 |
889881 | 889881 | 2021-01-02 | Ulster | New York | 36111 | 5935 | 145 |
886634 | 886634 | 2021-01-01 | Ulster | New York | 36111 | 5816 | 143 |
883389 | 883389 | 2020-12-31 | Ulster | New York | 36111 | 5679 | 141 |
880144 | 880144 | 2020-12-30 | Ulster | New York | 36111 | 5572 | 140 |
876899 | 876899 | 2020-12-29 | Ulster | New York | 36111 | 5498 | 140 |
873654 | 873654 | 2020-12-28 | Ulster | New York | 36111 | 5436 | 139 |
870409 | 870409 | 2020-12-27 | Ulster | New York | 36111 | 5380 | 138 |
867164 | 867164 | 2020-12-26 | Ulster | New York | 36111 | 5328 | 136 |
863919 | 863919 | 2020-12-25 | Ulster | New York | 36111 | 5241 | 136 |
860674 | 860674 | 2020-12-24 | Ulster | New York | 36111 | 5164 | 135 |
857429 | 857429 | 2020-12-23 | Ulster | New York | 36111 | 5079 | 135 |
854184 | 854184 | 2020-12-22 | Ulster | New York | 36111 | 5001 | 134 |
850939 | 850939 | 2020-12-21 | Ulster | New York | 36111 | 4926 | 132 |
847694 | 847694 | 2020-12-20 | Ulster | New York | 36111 | 4850 | 131 |
844449 | 844449 | 2020-12-19 | Ulster | New York | 36111 | 4791 | 129 |
841203 | 841203 | 2020-12-18 | Ulster | New York | 36111 | 4736 | 125 |
837958 | 837958 | 2020-12-17 | Ulster | New York | 36111 | 4614 | 120 |
834712 | 834712 | 2020-12-16 | Ulster | New York | 36111 | 4547 | 118 |
831466 | 831466 | 2020-12-15 | Ulster | New York | 36111 | 4485 | 118 |
828219 | 828219 | 2020-12-14 | Ulster | New York | 36111 | 4393 | 116 |
824973 | 824973 | 2020-12-13 | Ulster | New York | 36111 | 4327 | 116 |
821726 | 821726 | 2020-12-12 | Ulster | New York | 36111 | 4251 | 114 |
818480 | 818480 | 2020-12-11 | Ulster | New York | 36111 | 4176 | 111 |
815234 | 815234 | 2020-12-10 | Ulster | New York | 36111 | 4103 | 108 |
811989 | 811989 | 2020-12-09 | Ulster | New York | 36111 | 4029 | 108 |
808744 | 808744 | 2020-12-08 | Ulster | New York | 36111 | 3974 | 104 |
805499 | 805499 | 2020-12-07 | Ulster | New York | 36111 | 3897 | 103 |
802254 | 802254 | 2020-12-06 | Ulster | New York | 36111 | 3858 | 100 |
799009 | 799009 | 2020-12-05 | Ulster | New York | 36111 | 3773 | 95 |
795764 | 795764 | 2020-12-04 | Ulster | New York | 36111 | 3697 | 94 |
792519 | 792519 | 2020-12-03 | Ulster | New York | 36111 | 3606 | 94 |
789274 | 789274 | 2020-12-02 | Ulster | New York | 36111 | 3499 | 94 |
786029 | 786029 | 2020-12-01 | Ulster | New York | 36111 | 3434 | 94 |
782785 | 782785 | 2020-11-30 | Ulster | New York | 36111 | 3381 | 94 |
779539 | 779539 | 2020-11-29 | Ulster | New York | 36111 | 3325 | 93 |
776294 | 776294 | 2020-11-28 | Ulster | New York | 36111 | 3276 | 93 |
773049 | 773049 | 2020-11-27 | Ulster | New York | 36111 | 3238 | 93 |
769804 | 769804 | 2020-11-26 | Ulster | New York | 36111 | 3180 | 93 |
766558 | 766558 | 2020-11-25 | Ulster | New York | 36111 | 3141 | 93 |
763313 | 763313 | 2020-11-24 | Ulster | New York | 36111 | 3109 | 92 |
760068 | 760068 | 2020-11-23 | Ulster | New York | 36111 | 3073 | 90 |
756822 | 756822 | 2020-11-22 | Ulster | New York | 36111 | 3023 | 90 |
753575 | 753575 | 2020-11-21 | Ulster | New York | 36111 | 3004 | 90 |
750329 | 750329 | 2020-11-20 | Ulster | New York | 36111 | 2969 | 89 |
747083 | 747083 | 2020-11-19 | Ulster | New York | 36111 | 2937 | 89 |
743837 | 743837 | 2020-11-18 | Ulster | New York | 36111 | 2865 | 88 |
740590 | 740590 | 2020-11-17 | Ulster | New York | 36111 | 2835 | 87 |
737345 | 737345 | 2020-11-16 | Ulster | New York | 36111 | 2800 | 87 |
734101 | 734101 | 2020-11-15 | Ulster | New York | 36111 | 2788 | 87 |
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);