ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Clinton" 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 |
---|---|---|---|---|---|---|---|
1279398 | 1279398 | 2021-05-02 | Clinton | New York | 36019 | 4701 | 33 |
1276151 | 1276151 | 2021-05-01 | Clinton | New York | 36019 | 4693 | 33 |
1272904 | 1272904 | 2021-04-30 | Clinton | New York | 36019 | 4683 | 33 |
1269657 | 1269657 | 2021-04-29 | Clinton | New York | 36019 | 4675 | 33 |
1266410 | 1266410 | 2021-04-28 | Clinton | New York | 36019 | 4666 | 33 |
1263163 | 1263163 | 2021-04-27 | Clinton | New York | 36019 | 4662 | 33 |
1259916 | 1259916 | 2021-04-26 | Clinton | New York | 36019 | 4654 | 33 |
1256669 | 1256669 | 2021-04-25 | Clinton | New York | 36019 | 4642 | 33 |
1253422 | 1253422 | 2021-04-24 | Clinton | New York | 36019 | 4633 | 33 |
1250175 | 1250175 | 2021-04-23 | Clinton | New York | 36019 | 4611 | 33 |
1246928 | 1246928 | 2021-04-22 | Clinton | New York | 36019 | 4591 | 33 |
1243681 | 1243681 | 2021-04-21 | Clinton | New York | 36019 | 4582 | 33 |
1240434 | 1240434 | 2021-04-20 | Clinton | New York | 36019 | 4577 | 32 |
1237187 | 1237187 | 2021-04-19 | Clinton | New York | 36019 | 4563 | 32 |
1233940 | 1233940 | 2021-04-18 | Clinton | New York | 36019 | 4550 | 32 |
1230692 | 1230692 | 2021-04-17 | Clinton | New York | 36019 | 4528 | 32 |
1227444 | 1227444 | 2021-04-16 | Clinton | New York | 36019 | 4511 | 32 |
1224196 | 1224196 | 2021-04-15 | Clinton | New York | 36019 | 4501 | 32 |
1220949 | 1220949 | 2021-04-14 | Clinton | New York | 36019 | 4472 | 32 |
1217701 | 1217701 | 2021-04-13 | Clinton | New York | 36019 | 4465 | 32 |
1214453 | 1214453 | 2021-04-12 | Clinton | New York | 36019 | 4441 | 32 |
1211206 | 1211206 | 2021-04-11 | Clinton | New York | 36019 | 4437 | 31 |
1207957 | 1207957 | 2021-04-10 | Clinton | New York | 36019 | 4417 | 31 |
1204709 | 1204709 | 2021-04-09 | Clinton | New York | 36019 | 4391 | 31 |
1201461 | 1201461 | 2021-04-08 | Clinton | New York | 36019 | 4364 | 31 |
1198212 | 1198212 | 2021-04-07 | Clinton | New York | 36019 | 4342 | 31 |
1194963 | 1194963 | 2021-04-06 | Clinton | New York | 36019 | 4319 | 31 |
1191715 | 1191715 | 2021-04-05 | Clinton | New York | 36019 | 4296 | 30 |
1188466 | 1188466 | 2021-04-04 | Clinton | New York | 36019 | 4274 | 30 |
1185219 | 1185219 | 2021-04-03 | Clinton | New York | 36019 | 4250 | 30 |
1181972 | 1181972 | 2021-04-02 | Clinton | New York | 36019 | 4230 | 30 |
1178725 | 1178725 | 2021-04-01 | Clinton | New York | 36019 | 4222 | 30 |
1175478 | 1175478 | 2021-03-31 | Clinton | New York | 36019 | 4187 | 30 |
1172231 | 1172231 | 2021-03-30 | Clinton | New York | 36019 | 4177 | 30 |
1168984 | 1168984 | 2021-03-29 | Clinton | New York | 36019 | 4155 | 30 |
1165736 | 1165736 | 2021-03-28 | Clinton | New York | 36019 | 4128 | 30 |
1162488 | 1162488 | 2021-03-27 | Clinton | New York | 36019 | 4111 | 30 |
1159239 | 1159239 | 2021-03-26 | Clinton | New York | 36019 | 4077 | 30 |
1155992 | 1155992 | 2021-03-25 | Clinton | New York | 36019 | 4061 | 30 |
1152745 | 1152745 | 2021-03-24 | Clinton | New York | 36019 | 4055 | 30 |
1149498 | 1149498 | 2021-03-23 | Clinton | New York | 36019 | 4031 | 30 |
1146251 | 1146251 | 2021-03-22 | Clinton | New York | 36019 | 4002 | 30 |
1143004 | 1143004 | 2021-03-21 | Clinton | New York | 36019 | 3987 | 30 |
1139757 | 1139757 | 2021-03-20 | Clinton | New York | 36019 | 3971 | 30 |
1136511 | 1136511 | 2021-03-19 | Clinton | New York | 36019 | 3962 | 29 |
1133265 | 1133265 | 2021-03-18 | Clinton | New York | 36019 | 3950 | 29 |
1130017 | 1130017 | 2021-03-17 | Clinton | New York | 36019 | 3936 | 29 |
1126770 | 1126770 | 2021-03-16 | Clinton | New York | 36019 | 3914 | 29 |
1123524 | 1123524 | 2021-03-15 | Clinton | New York | 36019 | 3900 | 29 |
1120278 | 1120278 | 2021-03-14 | Clinton | New York | 36019 | 3891 | 28 |
1117031 | 1117031 | 2021-03-13 | Clinton | New York | 36019 | 3882 | 28 |
1113784 | 1113784 | 2021-03-12 | Clinton | New York | 36019 | 3870 | 28 |
1110538 | 1110538 | 2021-03-11 | Clinton | New York | 36019 | 3854 | 28 |
1107292 | 1107292 | 2021-03-10 | Clinton | New York | 36019 | 3843 | 28 |
1104046 | 1104046 | 2021-03-09 | Clinton | New York | 36019 | 3830 | 27 |
1100800 | 1100800 | 2021-03-08 | Clinton | New York | 36019 | 3803 | 27 |
1097554 | 1097554 | 2021-03-07 | Clinton | New York | 36019 | 3788 | 27 |
1094306 | 1094306 | 2021-03-06 | Clinton | New York | 36019 | 3761 | 27 |
1091060 | 1091060 | 2021-03-05 | Clinton | New York | 36019 | 3741 | 26 |
1087815 | 1087815 | 2021-03-04 | Clinton | New York | 36019 | 3704 | 26 |
1084570 | 1084570 | 2021-03-03 | Clinton | New York | 36019 | 3682 | 26 |
1081324 | 1081324 | 2021-03-02 | Clinton | New York | 36019 | 3645 | 26 |
1078078 | 1078078 | 2021-03-01 | Clinton | New York | 36019 | 3610 | 26 |
1074833 | 1074833 | 2021-02-28 | Clinton | New York | 36019 | 3586 | 26 |
1071587 | 1071587 | 2021-02-27 | Clinton | New York | 36019 | 3558 | 26 |
1068341 | 1068341 | 2021-02-26 | Clinton | New York | 36019 | 3530 | 26 |
1065096 | 1065096 | 2021-02-25 | Clinton | New York | 36019 | 3507 | 26 |
1061852 | 1061852 | 2021-02-24 | Clinton | New York | 36019 | 3468 | 26 |
1058606 | 1058606 | 2021-02-23 | Clinton | New York | 36019 | 3452 | 26 |
1055360 | 1055360 | 2021-02-22 | Clinton | New York | 36019 | 3415 | 25 |
1052114 | 1052114 | 2021-02-21 | Clinton | New York | 36019 | 3390 | 25 |
1048867 | 1048867 | 2021-02-20 | Clinton | New York | 36019 | 3369 | 25 |
1045620 | 1045620 | 2021-02-19 | Clinton | New York | 36019 | 3352 | 25 |
1042375 | 1042375 | 2021-02-18 | Clinton | New York | 36019 | 3297 | 23 |
1039130 | 1039130 | 2021-02-17 | Clinton | New York | 36019 | 3278 | 23 |
1035885 | 1035885 | 2021-02-16 | Clinton | New York | 36019 | 3258 | 23 |
1032640 | 1032640 | 2021-02-15 | Clinton | New York | 36019 | 3239 | 22 |
1029394 | 1029394 | 2021-02-14 | Clinton | New York | 36019 | 3205 | 22 |
1026147 | 1026147 | 2021-02-13 | Clinton | New York | 36019 | 3161 | 22 |
1022902 | 1022902 | 2021-02-12 | Clinton | New York | 36019 | 3129 | 22 |
1019657 | 1019657 | 2021-02-11 | Clinton | New York | 36019 | 3103 | 22 |
1016412 | 1016412 | 2021-02-10 | Clinton | New York | 36019 | 3026 | 22 |
1013167 | 1013167 | 2021-02-09 | Clinton | New York | 36019 | 2999 | 22 |
1009922 | 1009922 | 2021-02-08 | Clinton | New York | 36019 | 2970 | 22 |
1006676 | 1006676 | 2021-02-07 | Clinton | New York | 36019 | 2928 | 22 |
1003430 | 1003430 | 2021-02-06 | Clinton | New York | 36019 | 2891 | 22 |
1000184 | 1000184 | 2021-02-05 | Clinton | New York | 36019 | 2856 | 22 |
996938 | 996938 | 2021-02-04 | Clinton | New York | 36019 | 2824 | 22 |
993692 | 993692 | 2021-02-03 | Clinton | New York | 36019 | 2799 | 22 |
990446 | 990446 | 2021-02-02 | Clinton | New York | 36019 | 2779 | 21 |
987200 | 987200 | 2021-02-01 | Clinton | New York | 36019 | 2749 | 20 |
983953 | 983953 | 2021-01-31 | Clinton | New York | 36019 | 2720 | 20 |
980706 | 980706 | 2021-01-30 | Clinton | New York | 36019 | 2670 | 20 |
977460 | 977460 | 2021-01-29 | Clinton | New York | 36019 | 2636 | 20 |
974215 | 974215 | 2021-01-28 | Clinton | New York | 36019 | 2583 | 20 |
970970 | 970970 | 2021-01-27 | Clinton | New York | 36019 | 2542 | 20 |
967725 | 967725 | 2021-01-26 | Clinton | New York | 36019 | 2505 | 20 |
964481 | 964481 | 2021-01-25 | Clinton | New York | 36019 | 2458 | 19 |
961236 | 961236 | 2021-01-24 | Clinton | New York | 36019 | 2424 | 18 |
957991 | 957991 | 2021-01-23 | Clinton | New York | 36019 | 2360 | 18 |
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);