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 |
---|---|---|---|---|---|---|---|
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 |
870373 | 870373 | 2020-12-27 | Franklin | New York | 36033 | 699 | 9 |
867128 | 867128 | 2020-12-26 | Franklin | New York | 36033 | 694 | 9 |
863883 | 863883 | 2020-12-25 | Franklin | New York | 36033 | 663 | 9 |
860638 | 860638 | 2020-12-24 | Franklin | New York | 36033 | 635 | 9 |
857393 | 857393 | 2020-12-23 | Franklin | New York | 36033 | 618 | 9 |
854148 | 854148 | 2020-12-22 | Franklin | New York | 36033 | 609 | 9 |
850903 | 850903 | 2020-12-21 | Franklin | New York | 36033 | 591 | 9 |
847658 | 847658 | 2020-12-20 | Franklin | New York | 36033 | 576 | 9 |
844413 | 844413 | 2020-12-19 | Franklin | New York | 36033 | 558 | 9 |
841167 | 841167 | 2020-12-18 | Franklin | New York | 36033 | 540 | 9 |
837922 | 837922 | 2020-12-17 | Franklin | New York | 36033 | 502 | 9 |
834676 | 834676 | 2020-12-16 | Franklin | New York | 36033 | 485 | 9 |
831430 | 831430 | 2020-12-15 | Franklin | New York | 36033 | 476 | 9 |
828183 | 828183 | 2020-12-14 | Franklin | New York | 36033 | 459 | 9 |
824937 | 824937 | 2020-12-13 | Franklin | New York | 36033 | 443 | 9 |
821690 | 821690 | 2020-12-12 | Franklin | New York | 36033 | 432 | 9 |
818444 | 818444 | 2020-12-11 | Franklin | New York | 36033 | 421 | 9 |
815198 | 815198 | 2020-12-10 | Franklin | New York | 36033 | 398 | 9 |
811953 | 811953 | 2020-12-09 | Franklin | New York | 36033 | 375 | 9 |
808708 | 808708 | 2020-12-08 | Franklin | New York | 36033 | 368 | 9 |
805463 | 805463 | 2020-12-07 | Franklin | New York | 36033 | 350 | 9 |
802218 | 802218 | 2020-12-06 | Franklin | New York | 36033 | 322 | 8 |
798973 | 798973 | 2020-12-05 | Franklin | New York | 36033 | 305 | 8 |
795728 | 795728 | 2020-12-04 | Franklin | New York | 36033 | 293 | 8 |
792483 | 792483 | 2020-12-03 | Franklin | New York | 36033 | 283 | 7 |
789238 | 789238 | 2020-12-02 | Franklin | New York | 36033 | 276 | 7 |
785993 | 785993 | 2020-12-01 | Franklin | New York | 36033 | 271 | 7 |
782749 | 782749 | 2020-11-30 | Franklin | New York | 36033 | 266 | 7 |
779503 | 779503 | 2020-11-29 | Franklin | New York | 36033 | 266 | 7 |
776258 | 776258 | 2020-11-28 | Franklin | New York | 36033 | 259 | 7 |
773013 | 773013 | 2020-11-27 | Franklin | New York | 36033 | 259 | 7 |
769768 | 769768 | 2020-11-26 | Franklin | New York | 36033 | 255 | 7 |
766522 | 766522 | 2020-11-25 | Franklin | New York | 36033 | 245 | 6 |
763277 | 763277 | 2020-11-24 | Franklin | New York | 36033 | 243 | 6 |
760032 | 760032 | 2020-11-23 | Franklin | New York | 36033 | 239 | 5 |
756786 | 756786 | 2020-11-22 | Franklin | New York | 36033 | 231 | 5 |
753539 | 753539 | 2020-11-21 | Franklin | New York | 36033 | 229 | 4 |
750293 | 750293 | 2020-11-20 | Franklin | New York | 36033 | 220 | 3 |
747047 | 747047 | 2020-11-19 | Franklin | New York | 36033 | 215 | 3 |
743801 | 743801 | 2020-11-18 | Franklin | New York | 36033 | 207 | 3 |
740554 | 740554 | 2020-11-17 | Franklin | New York | 36033 | 195 | 3 |
737309 | 737309 | 2020-11-16 | Franklin | New York | 36033 | 189 | 3 |
734065 | 734065 | 2020-11-15 | Franklin | New York | 36033 | 188 | 3 |
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);