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 |
---|---|---|---|---|---|---|---|
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 |
730819 | 730819 | 2020-11-14 | Franklin | New York | 36033 | 184 | 3 |
727575 | 727575 | 2020-11-13 | Franklin | New York | 36033 | 174 | 3 |
724331 | 724331 | 2020-11-12 | Franklin | New York | 36033 | 161 | 3 |
721088 | 721088 | 2020-11-11 | Franklin | New York | 36033 | 152 | 2 |
717845 | 717845 | 2020-11-10 | Franklin | New York | 36033 | 147 | 2 |
714602 | 714602 | 2020-11-09 | Franklin | New York | 36033 | 140 | 1 |
711358 | 711358 | 2020-11-08 | Franklin | New York | 36033 | 136 | 1 |
708114 | 708114 | 2020-11-07 | Franklin | New York | 36033 | 127 | 1 |
704871 | 704871 | 2020-11-06 | Franklin | New York | 36033 | 114 | 1 |
701628 | 701628 | 2020-11-05 | Franklin | New York | 36033 | 105 | 1 |
698384 | 698384 | 2020-11-04 | Franklin | New York | 36033 | 96 | 1 |
695141 | 695141 | 2020-11-03 | Franklin | New York | 36033 | 96 | 1 |
691899 | 691899 | 2020-11-02 | Franklin | New York | 36033 | 88 | 1 |
688655 | 688655 | 2020-11-01 | Franklin | New York | 36033 | 87 | 1 |
685410 | 685410 | 2020-10-31 | Franklin | New York | 36033 | 86 | 1 |
682167 | 682167 | 2020-10-30 | Franklin | New York | 36033 | 82 | 1 |
678924 | 678924 | 2020-10-29 | Franklin | New York | 36033 | 80 | 1 |
675681 | 675681 | 2020-10-28 | Franklin | New York | 36033 | 80 | 1 |
672438 | 672438 | 2020-10-27 | Franklin | New York | 36033 | 80 | 1 |
669196 | 669196 | 2020-10-26 | Franklin | New York | 36033 | 80 | 1 |
665952 | 665952 | 2020-10-25 | Franklin | New York | 36033 | 79 | 1 |
662707 | 662707 | 2020-10-24 | Franklin | New York | 36033 | 79 | 1 |
659463 | 659463 | 2020-10-23 | Franklin | New York | 36033 | 79 | 1 |
656219 | 656219 | 2020-10-22 | Franklin | New York | 36033 | 79 | 1 |
652974 | 652974 | 2020-10-21 | Franklin | New York | 36033 | 78 | 1 |
649729 | 649729 | 2020-10-20 | Franklin | New York | 36033 | 77 | 1 |
646485 | 646485 | 2020-10-19 | Franklin | New York | 36033 | 77 | 1 |
643239 | 643239 | 2020-10-18 | Franklin | New York | 36033 | 77 | 1 |
639991 | 639991 | 2020-10-17 | Franklin | New York | 36033 | 77 | 1 |
636745 | 636745 | 2020-10-16 | Franklin | New York | 36033 | 75 | 1 |
633499 | 633499 | 2020-10-15 | Franklin | New York | 36033 | 75 | 1 |
630254 | 630254 | 2020-10-14 | Franklin | New York | 36033 | 72 | 1 |
627010 | 627010 | 2020-10-13 | Franklin | New York | 36033 | 72 | 1 |
623768 | 623768 | 2020-10-12 | Franklin | New York | 36033 | 71 | 1 |
620525 | 620525 | 2020-10-11 | Franklin | New York | 36033 | 71 | 1 |
617283 | 617283 | 2020-10-10 | Franklin | New York | 36033 | 71 | 1 |
614041 | 614041 | 2020-10-09 | Franklin | New York | 36033 | 71 | 1 |
610800 | 610800 | 2020-10-08 | Franklin | New York | 36033 | 71 | 1 |
607558 | 607558 | 2020-10-07 | Franklin | New York | 36033 | 70 | 1 |
604315 | 604315 | 2020-10-06 | Franklin | New York | 36033 | 70 | 1 |
601073 | 601073 | 2020-10-05 | Franklin | New York | 36033 | 70 | 1 |
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);