ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Franklin" 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 |
---|---|---|---|---|---|---|---|
1194970 | 1194970 | 2021-04-06 | Franklin | New York | 36033 | 2341 | 12 |
1191722 | 1191722 | 2021-04-05 | Franklin | New York | 36033 | 2333 | 12 |
1188473 | 1188473 | 2021-04-04 | Franklin | New York | 36033 | 2326 | 12 |
1185226 | 1185226 | 2021-04-03 | Franklin | New York | 36033 | 2323 | 12 |
1181979 | 1181979 | 2021-04-02 | Franklin | New York | 36033 | 2316 | 12 |
1178732 | 1178732 | 2021-04-01 | Franklin | New York | 36033 | 2310 | 12 |
1175485 | 1175485 | 2021-03-31 | Franklin | New York | 36033 | 2301 | 12 |
1172238 | 1172238 | 2021-03-30 | Franklin | New York | 36033 | 2298 | 12 |
1168991 | 1168991 | 2021-03-29 | Franklin | New York | 36033 | 2292 | 12 |
1165743 | 1165743 | 2021-03-28 | Franklin | New York | 36033 | 2284 | 12 |
1162495 | 1162495 | 2021-03-27 | Franklin | New York | 36033 | 2278 | 12 |
1159246 | 1159246 | 2021-03-26 | Franklin | New York | 36033 | 2273 | 12 |
1155999 | 1155999 | 2021-03-25 | Franklin | New York | 36033 | 2270 | 12 |
1152752 | 1152752 | 2021-03-24 | Franklin | New York | 36033 | 2262 | 12 |
1149505 | 1149505 | 2021-03-23 | Franklin | New York | 36033 | 2258 | 12 |
1146258 | 1146258 | 2021-03-22 | Franklin | New York | 36033 | 2254 | 12 |
1143011 | 1143011 | 2021-03-21 | Franklin | New York | 36033 | 2247 | 12 |
1139764 | 1139764 | 2021-03-20 | Franklin | New York | 36033 | 2242 | 12 |
1136518 | 1136518 | 2021-03-19 | Franklin | New York | 36033 | 2234 | 12 |
1133272 | 1133272 | 2021-03-18 | Franklin | New York | 36033 | 2231 | 12 |
1130024 | 1130024 | 2021-03-17 | Franklin | New York | 36033 | 2225 | 12 |
1126777 | 1126777 | 2021-03-16 | Franklin | New York | 36033 | 2222 | 12 |
1123531 | 1123531 | 2021-03-15 | Franklin | New York | 36033 | 2218 | 12 |
1120285 | 1120285 | 2021-03-14 | Franklin | New York | 36033 | 2213 | 12 |
1117038 | 1117038 | 2021-03-13 | Franklin | New York | 36033 | 2210 | 12 |
1113791 | 1113791 | 2021-03-12 | Franklin | New York | 36033 | 2208 | 12 |
1110545 | 1110545 | 2021-03-11 | Franklin | New York | 36033 | 2204 | 12 |
1107299 | 1107299 | 2021-03-10 | Franklin | New York | 36033 | 2199 | 12 |
1104053 | 1104053 | 2021-03-09 | Franklin | New York | 36033 | 2191 | 12 |
1100807 | 1100807 | 2021-03-08 | Franklin | New York | 36033 | 2187 | 12 |
1097561 | 1097561 | 2021-03-07 | Franklin | New York | 36033 | 2176 | 12 |
1094313 | 1094313 | 2021-03-06 | Franklin | New York | 36033 | 2160 | 12 |
1091067 | 1091067 | 2021-03-05 | Franklin | New York | 36033 | 2142 | 12 |
1087822 | 1087822 | 2021-03-04 | Franklin | New York | 36033 | 2120 | 12 |
1084577 | 1084577 | 2021-03-03 | Franklin | New York | 36033 | 2107 | 12 |
1081331 | 1081331 | 2021-03-02 | Franklin | New York | 36033 | 2098 | 12 |
1078085 | 1078085 | 2021-03-01 | Franklin | New York | 36033 | 2087 | 12 |
1074840 | 1074840 | 2021-02-28 | Franklin | New York | 36033 | 2074 | 12 |
1071594 | 1071594 | 2021-02-27 | Franklin | New York | 36033 | 2056 | 12 |
1068348 | 1068348 | 2021-02-26 | Franklin | New York | 36033 | 2027 | 12 |
1065103 | 1065103 | 2021-02-25 | Franklin | New York | 36033 | 2008 | 12 |
1061859 | 1061859 | 2021-02-24 | Franklin | New York | 36033 | 1996 | 12 |
1058613 | 1058613 | 2021-02-23 | Franklin | New York | 36033 | 1986 | 12 |
1055367 | 1055367 | 2021-02-22 | Franklin | New York | 36033 | 1977 | 12 |
1052121 | 1052121 | 2021-02-21 | Franklin | New York | 36033 | 1954 | 12 |
1048874 | 1048874 | 2021-02-20 | Franklin | New York | 36033 | 1935 | 12 |
1045627 | 1045627 | 2021-02-19 | Franklin | New York | 36033 | 1893 | 12 |
1042382 | 1042382 | 2021-02-18 | Franklin | New York | 36033 | 1857 | 12 |
1039137 | 1039137 | 2021-02-17 | Franklin | New York | 36033 | 1844 | 11 |
1035892 | 1035892 | 2021-02-16 | Franklin | New York | 36033 | 1838 | 11 |
1032647 | 1032647 | 2021-02-15 | Franklin | New York | 36033 | 1829 | 11 |
1029401 | 1029401 | 2021-02-14 | Franklin | New York | 36033 | 1807 | 11 |
1026154 | 1026154 | 2021-02-13 | Franklin | New York | 36033 | 1791 | 11 |
1022909 | 1022909 | 2021-02-12 | Franklin | New York | 36033 | 1776 | 11 |
1019664 | 1019664 | 2021-02-11 | Franklin | New York | 36033 | 1753 | 11 |
1016419 | 1016419 | 2021-02-10 | Franklin | New York | 36033 | 1724 | 11 |
1013174 | 1013174 | 2021-02-09 | Franklin | New York | 36033 | 1720 | 11 |
1009929 | 1009929 | 2021-02-08 | Franklin | New York | 36033 | 1706 | 11 |
1006683 | 1006683 | 2021-02-07 | Franklin | New York | 36033 | 1689 | 11 |
1003437 | 1003437 | 2021-02-06 | Franklin | New York | 36033 | 1671 | 11 |
1000191 | 1000191 | 2021-02-05 | Franklin | New York | 36033 | 1630 | 11 |
996945 | 996945 | 2021-02-04 | Franklin | New York | 36033 | 1602 | 11 |
993699 | 993699 | 2021-02-03 | Franklin | New York | 36033 | 1589 | 10 |
990453 | 990453 | 2021-02-02 | Franklin | New York | 36033 | 1584 | 9 |
987207 | 987207 | 2021-02-01 | Franklin | New York | 36033 | 1571 | 9 |
983960 | 983960 | 2021-01-31 | Franklin | New York | 36033 | 1539 | 9 |
980713 | 980713 | 2021-01-30 | Franklin | New York | 36033 | 1525 | 9 |
977467 | 977467 | 2021-01-29 | Franklin | New York | 36033 | 1465 | 9 |
974222 | 974222 | 2021-01-28 | Franklin | New York | 36033 | 1428 | 9 |
970977 | 970977 | 2021-01-27 | Franklin | New York | 36033 | 1399 | 9 |
967732 | 967732 | 2021-01-26 | Franklin | New York | 36033 | 1381 | 9 |
964488 | 964488 | 2021-01-25 | Franklin | New York | 36033 | 1359 | 9 |
961243 | 961243 | 2021-01-24 | Franklin | New York | 36033 | 1332 | 9 |
957998 | 957998 | 2021-01-23 | Franklin | New York | 36033 | 1297 | 9 |
954752 | 954752 | 2021-01-22 | Franklin | New York | 36033 | 1269 | 9 |
951507 | 951507 | 2021-01-21 | Franklin | New York | 36033 | 1202 | 9 |
948262 | 948262 | 2021-01-20 | Franklin | New York | 36033 | 1164 | 9 |
945015 | 945015 | 2021-01-19 | Franklin | New York | 36033 | 1147 | 9 |
941769 | 941769 | 2021-01-18 | Franklin | New York | 36033 | 1129 | 9 |
938524 | 938524 | 2021-01-17 | Franklin | New York | 36033 | 1103 | 9 |
935279 | 935279 | 2021-01-16 | Franklin | New York | 36033 | 1086 | 9 |
932034 | 932034 | 2021-01-15 | Franklin | New York | 36033 | 1040 | 9 |
928789 | 928789 | 2021-01-14 | Franklin | New York | 36033 | 1006 | 9 |
925544 | 925544 | 2021-01-13 | Franklin | New York | 36033 | 984 | 9 |
922298 | 922298 | 2021-01-12 | Franklin | New York | 36033 | 972 | 9 |
919053 | 919053 | 2021-01-11 | Franklin | New York | 36033 | 946 | 9 |
915808 | 915808 | 2021-01-10 | Franklin | New York | 36033 | 924 | 9 |
912563 | 912563 | 2021-01-09 | Franklin | New York | 36033 | 905 | 9 |
909318 | 909318 | 2021-01-08 | Franklin | New York | 36033 | 886 | 9 |
906073 | 906073 | 2021-01-07 | Franklin | New York | 36033 | 852 | 9 |
902827 | 902827 | 2021-01-06 | Franklin | New York | 36033 | 832 | 9 |
899582 | 899582 | 2021-01-05 | Franklin | New York | 36033 | 822 | 9 |
896337 | 896337 | 2021-01-04 | Franklin | New York | 36033 | 812 | 9 |
893091 | 893091 | 2021-01-03 | Franklin | New York | 36033 | 810 | 9 |
889845 | 889845 | 2021-01-02 | Franklin | New York | 36033 | 797 | 9 |
886598 | 886598 | 2021-01-01 | Franklin | New York | 36033 | 781 | 9 |
883353 | 883353 | 2020-12-31 | Franklin | New York | 36033 | 761 | 9 |
880108 | 880108 | 2020-12-30 | Franklin | New York | 36033 | 734 | 9 |
876863 | 876863 | 2020-12-29 | Franklin | New York | 36033 | 729 | 9 |
873618 | 873618 | 2020-12-28 | Franklin | New York | 36033 | 713 | 9 |
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);