ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36043 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 |
---|---|---|---|---|---|---|---|
1194975 | 1194975 | 2021-04-06 | Herkimer | New York | 36043 | 4814 | 107 |
1191727 | 1191727 | 2021-04-05 | Herkimer | New York | 36043 | 4810 | 107 |
1188478 | 1188478 | 2021-04-04 | Herkimer | New York | 36043 | 4802 | 107 |
1185231 | 1185231 | 2021-04-03 | Herkimer | New York | 36043 | 4797 | 107 |
1181984 | 1181984 | 2021-04-02 | Herkimer | New York | 36043 | 4788 | 107 |
1178737 | 1178737 | 2021-04-01 | Herkimer | New York | 36043 | 4776 | 107 |
1175490 | 1175490 | 2021-03-31 | Herkimer | New York | 36043 | 4772 | 107 |
1172243 | 1172243 | 2021-03-30 | Herkimer | New York | 36043 | 4762 | 107 |
1168996 | 1168996 | 2021-03-29 | Herkimer | New York | 36043 | 4757 | 107 |
1165748 | 1165748 | 2021-03-28 | Herkimer | New York | 36043 | 4754 | 107 |
1162500 | 1162500 | 2021-03-27 | Herkimer | New York | 36043 | 4745 | 107 |
1159251 | 1159251 | 2021-03-26 | Herkimer | New York | 36043 | 4735 | 107 |
1156004 | 1156004 | 2021-03-25 | Herkimer | New York | 36043 | 4727 | 107 |
1152757 | 1152757 | 2021-03-24 | Herkimer | New York | 36043 | 4724 | 107 |
1149510 | 1149510 | 2021-03-23 | Herkimer | New York | 36043 | 4715 | 107 |
1146263 | 1146263 | 2021-03-22 | Herkimer | New York | 36043 | 4711 | 107 |
1143016 | 1143016 | 2021-03-21 | Herkimer | New York | 36043 | 4705 | 107 |
1139769 | 1139769 | 2021-03-20 | Herkimer | New York | 36043 | 4695 | 107 |
1136523 | 1136523 | 2021-03-19 | Herkimer | New York | 36043 | 4678 | 107 |
1133277 | 1133277 | 2021-03-18 | Herkimer | New York | 36043 | 4674 | 107 |
1130029 | 1130029 | 2021-03-17 | Herkimer | New York | 36043 | 4666 | 107 |
1126782 | 1126782 | 2021-03-16 | Herkimer | New York | 36043 | 4655 | 107 |
1123536 | 1123536 | 2021-03-15 | Herkimer | New York | 36043 | 4649 | 107 |
1120290 | 1120290 | 2021-03-14 | Herkimer | New York | 36043 | 4644 | 107 |
1117043 | 1117043 | 2021-03-13 | Herkimer | New York | 36043 | 4638 | 107 |
1113796 | 1113796 | 2021-03-12 | Herkimer | New York | 36043 | 4631 | 107 |
1110550 | 1110550 | 2021-03-11 | Herkimer | New York | 36043 | 4627 | 107 |
1107304 | 1107304 | 2021-03-10 | Herkimer | New York | 36043 | 4621 | 107 |
1104058 | 1104058 | 2021-03-09 | Herkimer | New York | 36043 | 4614 | 107 |
1100812 | 1100812 | 2021-03-08 | Herkimer | New York | 36043 | 4613 | 107 |
1097566 | 1097566 | 2021-03-07 | Herkimer | New York | 36043 | 4609 | 107 |
1094318 | 1094318 | 2021-03-06 | Herkimer | New York | 36043 | 4601 | 107 |
1091072 | 1091072 | 2021-03-05 | Herkimer | New York | 36043 | 4588 | 107 |
1087827 | 1087827 | 2021-03-04 | Herkimer | New York | 36043 | 4578 | 107 |
1084582 | 1084582 | 2021-03-03 | Herkimer | New York | 36043 | 4575 | 107 |
1081336 | 1081336 | 2021-03-02 | Herkimer | New York | 36043 | 4568 | 107 |
1078090 | 1078090 | 2021-03-01 | Herkimer | New York | 36043 | 4561 | 107 |
1074845 | 1074845 | 2021-02-28 | Herkimer | New York | 36043 | 4554 | 107 |
1071599 | 1071599 | 2021-02-27 | Herkimer | New York | 36043 | 4545 | 107 |
1068353 | 1068353 | 2021-02-26 | Herkimer | New York | 36043 | 4539 | 106 |
1065108 | 1065108 | 2021-02-25 | Herkimer | New York | 36043 | 4534 | 106 |
1061864 | 1061864 | 2021-02-24 | Herkimer | New York | 36043 | 4531 | 106 |
1058618 | 1058618 | 2021-02-23 | Herkimer | New York | 36043 | 4521 | 105 |
1055372 | 1055372 | 2021-02-22 | Herkimer | New York | 36043 | 4513 | 105 |
1052126 | 1052126 | 2021-02-21 | Herkimer | New York | 36043 | 4505 | 104 |
1048879 | 1048879 | 2021-02-20 | Herkimer | New York | 36043 | 4499 | 104 |
1045632 | 1045632 | 2021-02-19 | Herkimer | New York | 36043 | 4489 | 104 |
1042387 | 1042387 | 2021-02-18 | Herkimer | New York | 36043 | 4476 | 104 |
1039142 | 1039142 | 2021-02-17 | Herkimer | New York | 36043 | 4468 | 104 |
1035897 | 1035897 | 2021-02-16 | Herkimer | New York | 36043 | 4460 | 103 |
1032652 | 1032652 | 2021-02-15 | Herkimer | New York | 36043 | 4447 | 103 |
1029406 | 1029406 | 2021-02-14 | Herkimer | New York | 36043 | 4436 | 103 |
1026159 | 1026159 | 2021-02-13 | Herkimer | New York | 36043 | 4423 | 102 |
1022914 | 1022914 | 2021-02-12 | Herkimer | New York | 36043 | 4409 | 101 |
1019669 | 1019669 | 2021-02-11 | Herkimer | New York | 36043 | 4401 | 101 |
1016424 | 1016424 | 2021-02-10 | Herkimer | New York | 36043 | 4392 | 100 |
1013179 | 1013179 | 2021-02-09 | Herkimer | New York | 36043 | 4378 | 99 |
1009934 | 1009934 | 2021-02-08 | Herkimer | New York | 36043 | 4365 | 99 |
1006688 | 1006688 | 2021-02-07 | Herkimer | New York | 36043 | 4347 | 96 |
1003442 | 1003442 | 2021-02-06 | Herkimer | New York | 36043 | 4326 | 96 |
1000196 | 1000196 | 2021-02-05 | Herkimer | New York | 36043 | 4301 | 95 |
996950 | 996950 | 2021-02-04 | Herkimer | New York | 36043 | 4282 | 94 |
993704 | 993704 | 2021-02-03 | Herkimer | New York | 36043 | 4268 | 94 |
990458 | 990458 | 2021-02-02 | Herkimer | New York | 36043 | 4255 | 92 |
987212 | 987212 | 2021-02-01 | Herkimer | New York | 36043 | 4228 | 92 |
983965 | 983965 | 2021-01-31 | Herkimer | New York | 36043 | 4203 | 90 |
980718 | 980718 | 2021-01-30 | Herkimer | New York | 36043 | 4173 | 89 |
977472 | 977472 | 2021-01-29 | Herkimer | New York | 36043 | 4147 | 87 |
974227 | 974227 | 2021-01-28 | Herkimer | New York | 36043 | 4091 | 84 |
970982 | 970982 | 2021-01-27 | Herkimer | New York | 36043 | 4028 | 80 |
967737 | 967737 | 2021-01-26 | Herkimer | New York | 36043 | 3983 | 77 |
964493 | 964493 | 2021-01-25 | Herkimer | New York | 36043 | 3955 | 75 |
961248 | 961248 | 2021-01-24 | Herkimer | New York | 36043 | 3931 | 73 |
958003 | 958003 | 2021-01-23 | Herkimer | New York | 36043 | 3896 | 70 |
954757 | 954757 | 2021-01-22 | Herkimer | New York | 36043 | 3839 | 67 |
951512 | 951512 | 2021-01-21 | Herkimer | New York | 36043 | 3743 | 64 |
948267 | 948267 | 2021-01-20 | Herkimer | New York | 36043 | 3682 | 59 |
945020 | 945020 | 2021-01-19 | Herkimer | New York | 36043 | 3603 | 57 |
941774 | 941774 | 2021-01-18 | Herkimer | New York | 36043 | 3561 | 56 |
938529 | 938529 | 2021-01-17 | Herkimer | New York | 36043 | 3528 | 51 |
935284 | 935284 | 2021-01-16 | Herkimer | New York | 36043 | 3485 | 48 |
932039 | 932039 | 2021-01-15 | Herkimer | New York | 36043 | 3423 | 46 |
928794 | 928794 | 2021-01-14 | Herkimer | New York | 36043 | 3303 | 45 |
925549 | 925549 | 2021-01-13 | Herkimer | New York | 36043 | 3252 | 40 |
922303 | 922303 | 2021-01-12 | Herkimer | New York | 36043 | 3182 | 36 |
919058 | 919058 | 2021-01-11 | Herkimer | New York | 36043 | 3101 | 35 |
915813 | 915813 | 2021-01-10 | Herkimer | New York | 36043 | 3038 | 35 |
912568 | 912568 | 2021-01-09 | Herkimer | New York | 36043 | 2956 | 35 |
909323 | 909323 | 2021-01-08 | Herkimer | New York | 36043 | 2862 | 32 |
906078 | 906078 | 2021-01-07 | Herkimer | New York | 36043 | 2750 | 32 |
902832 | 902832 | 2021-01-06 | Herkimer | New York | 36043 | 2646 | 30 |
899587 | 899587 | 2021-01-05 | Herkimer | New York | 36043 | 2542 | 30 |
896342 | 896342 | 2021-01-04 | Herkimer | New York | 36043 | 2473 | 30 |
893096 | 893096 | 2021-01-03 | Herkimer | New York | 36043 | 2407 | 30 |
889850 | 889850 | 2021-01-02 | Herkimer | New York | 36043 | 2327 | 28 |
886603 | 886603 | 2021-01-01 | Herkimer | New York | 36043 | 2230 | 24 |
883358 | 883358 | 2020-12-31 | Herkimer | New York | 36043 | 2138 | 24 |
880113 | 880113 | 2020-12-30 | Herkimer | New York | 36043 | 2049 | 24 |
876868 | 876868 | 2020-12-29 | Herkimer | New York | 36043 | 1980 | 23 |
873623 | 873623 | 2020-12-28 | Herkimer | New York | 36043 | 1906 | 23 |
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);